" ;
mysql_query($query_Rt0, $BE2) or die(mysql_error());
$Rt0 = mysql_query($query_Rt0, $BE2) or die(mysql_error());
$row_Rt0 = mysql_fetch_assoc($Rt0);
$totalRows_Rt0 = mysql_num_rows($Rt0);
if($totalRows_Rt0>0){
$query_Rt0 =sprintf("delete From order_permoon WHERE pmoon>='%s'",$mm);
// echo '刪除 '.$mm." ".$query_Rt0."
" ;
mysql_select_db($database_BE2, $BE2);
mysql_query($query_Rt0, $BE2) or die(mysql_error());
}
/*
$query_Rt1 =sprintf("update order_permoon SET pall=pmoney+pnow WHERE pmoon='%s'",$sdateu);
mysql_select_db($database_BE2, $BE2);
echo '更新 上個月pall '.$query_Rt1."
" ;
mysql_query($query_Rt1, $BE2) or die(mysql_error());
*/
$query_Rt2 =sprintf("INSERT Into order_permoon(pmoon,pnmoon,puid,pnow) SELECT substring(a.pdate,1,7),concat('%s'),a.puid,sum(a.pmoney-a.depmoney) as pmoney from order_percent as a, member as d where a.puid=d.mem_auto AND a.pdate like '%s' group by a.puid ",$sdaten,$mm."%");
mysql_select_db($database_BE2, $BE2);
// echo '新增 '. $query_Rt2."
" ;
mysql_query($query_Rt2, $BE2) or die(mysql_error());
//$query_Rt2 =sprintf("update order_permoon(pmoon,pnmoon,puid,pnow) SELECT substring(a.pdate,1,7),concat('%s'),a.puid,sum(a.pmoney-a.depmoney) as pmoney from order_percent as a, member as d where a.puid=d.mem_auto AND a.pdate like '%s' group by a.puid ",$sdaten,$mm."%");
//mysql_select_db($database_BE2, $BE2);
//echo '新增 '. $query_Rt2."
" ;
//mysql_query($query_Rt2, $BE2) or die(mysql_error());
// 已付款 歸零 t1.pall-t1.pbank > pmoney
// $query_Rt3 =sprintf("INSERT Into order_permoon(pmoon,puid,pmoney) SELECT concat('%s'),t1.puid,t1.pall FROM order_permoon as t1 LEFT JOIN order_permoon as t2 ON t1.puid = t2.puid AND t2.pmoon='%s' WHERE t1.pmoon='%s' AND t2.puid Is Null",$mm,$mm,$sdateu);
$query_Rt3 =sprintf("INSERT Into order_permoon(pmoon,pnmoon,puid,pmoney,pupay) SELECT concat('%s'),concat('%s'),t1.puid,t1.pall-t1.pbank,t1.pmpay FROM order_permoon as t1 LEFT JOIN order_permoon as t2 ON t1.puid = t2.puid AND t2.pmoon='%s' WHERE t1.pmoon='%s' AND t2.puid Is Null",$mm,$sdaten,$mm,$sdateu);
mysql_select_db($database_BE2, $BE2);
// echo '新增 '.$query_Rt3."
";
mysql_query($query_Rt3, $BE2) or die(mysql_error());
// SELECT * FROM order_permoon as t1 LEFT JOIN order_permoon as t2 ON t1.puid = t2.puid AND t2.pmoon='2024-03' WHERE t1.pmoon='2024-02' AND t2.puid Is Null
$query_Rt4 =sprintf("update order_permoon as a,order_permoon as b SET a.pmoney=(b.pall-b.pbank) where a.pmoon='%s' AND b.pmoon='%s' AND a.puid=b.puid",$mm,$sdateu);
// echo '更新pmoney '.$query_Rt4."
";
mysql_select_db($database_BE2, $BE2);
mysql_query($query_Rt4, $BE2) or die(mysql_error());
/*
//已付款 歸零
$query_Rt5 =sprintf("update order_permoon SET pmoney=0 where pupay='Y' AND pmoon='%s'",$mm);
echo '已付款 歸零 '. $query_Rt5."
";
mysql_select_db($database_BE2, $BE2);
mysql_query($query_Rt5, $BE2) or die(mysql_error());
*/
//加總
$query_Rt6 =sprintf("update order_permoon SET pall=pmoney+pnow WHERE pmoon='%s'",$mm);
mysql_select_db($database_BE2, $BE2);
// echo '加總 '.$query_Rt6."
" ;
mysql_query($query_Rt6, $BE2) or die(mysql_error());
/*
SELECT * FROM order_permoon as t1 LEFT JOIN order_permoon as t2 ON t1.puid = t2.puid AND t2.pmoon='2024-03' WHERE t1.pmoon='2024-02' AND t2.puid Is Null
*/
//do {
// } while ($row_Rt2 = mysql_fetch_assoc($Rt2));
//$query_Rt4 = sprintf("INSERT Into order_permoon(pmoon,puid,pmoney) SELECT substring(a.pdate,1,7), a.puid,sum(a.pmoney-a.depmoney) from order_percent as a, member as d where a.puid=d.mem_auto AND a.pdate like '2024-04%' group by a.puid ORDER BY a.pdate");
?>