'.$ar[$i][2].'>'.$ar[$i][3].' ';
if($ar[$i][2]<>$ar[$i][3]){
if($ar[$i][3]=='Y'){ $pbank='pall';}else{$pbank='0'; }
$update1=sprintf("update order_permoon set pmpay='%s',pbank=%s WHERE pmid='%s'",$ar[$i][3],$pbank,$ar[$i][1]);
mysql_select_db($database_BE2, $BE2);
mysql_query($update1, $BE2) or die(mysql_error());
// echo $update1.'
';
}
}
}
if(isset($_POST['d1'])&& $_POST['d1']=='formnext'){
include "premoon_up.php";
}
if(isset($_POST['d2'])&& $_POST['d2']=='formclean'){
include "premoon_up.php";
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_Rt2 = 25;
$pageNum_Rt2 = 0;
if (isset($_GET['pageNum_Rt2'])) {
$pageNum_Rt2 = $_GET['pageNum_Rt2'];
}
$startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2;
$colname_Rt2 = "-1";
if (isset($_GET['keyword'])) {
$colname_Rt2 = $_GET['keyword'];
}
mysql_select_db($database_BE2, $BE2);
$query_Rt1 = "SELECT distinct(pmoon) as mm FROM order_permoon where 1 order by pmoon desc" ;
$Rt1 = mysql_query($query_Rt1, $BE2) or die(mysql_error());
$row_Rt1 = mysql_fetch_assoc($Rt1);
$totalRows_Rt1=mysql_num_rows($Rt1);
if($row_Rt1==0){
$mm_now='2024-02';
$mm_new='2024-02';
$mm = '2024-02';
}else{
$mm_now=$row_Rt1['mm'];
$y=substr($mm_now,0,4);
$m=substr($mm_now,5,2);
$mm_new=date("Y-m", mktime(0,0,0,$m+1,1,$y));
// $mm_last=date("Y-m", mktime(0,0,0,$m-+1,1,$y));
}
$mm=$mm_now;
if (isset($_GET['mm'])) {
$mm = $_GET['mm'];
}
/*
mysql_select_db($database_BE2, $BE2);
$query_Rt2 = sprintf("SELECT a.*,b.dcode,b.p_money,b.p_count,c.p_title,d.scode,d.mem_user2,d.m_bankname,d.m_bankcode,d.m_bank,d.m_bank2 from order_percent as a, order_datas as b,product_data as c,member as d where a.ccid=b.ccid AND b.mem_auto=c.mem_auto AND a.puid=d.mem_auto AND a.pdate like '%s' ORDER BY a.pdate",$mm.'%') ;
$query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2);
$Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
*/
//echo $query_Rt2;
$sdate=$mm;
//$sdate2=date("Y-m-d", mktime(0,0,0,$m-1,31,$y));
//$query_Rt2 = sprintf("SELECT a.pmoon,a.puid,a.pmoney,a.pnow,a.pall,a.pall,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname,d.m_bank,d.m_bank2 from order_permoon as a, member as d where a.puid=d.mem_auto AND a.pmoon='%s' group by a.puid ORDER BY a.puid",$sdate);
$query_Rt2 = sprintf("SELECT a.*,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname,d.m_bank,d.m_bank2 from order_permoon as a, member as d where a.pall>0 AND a.puid=d.mem_auto AND a.pmoon='%s' group by a.puid ORDER BY a.puid",$sdate);
// $query_Rt2 = sprintf("SELECT a.*,b.dcode,b.p_money,b.p_count,d.scode,d.mem_user2,d.m_bankcode,d.m_bankname from order_percent as a, order_datas as b,member as d where a.ccid=b.ccid AND a.puid=d.mem_auto AND a.pdate like '%s' ORDER BY a.pdate DESC",$sdate.'%') ;
mysql_select_db($database_BE2, $BE2);
$Rt2 = mysql_query($query_Rt2, $BE2) or die(mysql_error());
$row_Rt2 = mysql_fetch_assoc($Rt2);
//echo $query_Rt2 ;
//============//
if (isset($_GET['totalRows_Rt2'])) {
$totalRows_Rt2 = $_GET['totalRows_Rt2'];
} else {
$all_Rt2 = mysql_query($query_Rt2);
$totalRows_Rt2 = mysql_num_rows($all_Rt2);
}
$totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1;
$queryString_Rt2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Rt2") == false &&
stristr($param, "totalRows_Rt2") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Rt2 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2);
?>