MENU
Count Child
sql: SELECT p.`PlacementMemberNo`,COUNT(p.`MemberNo`) AS NUM,p1.`MemberNo`,p1.`ChildNum` FROM `tbl_placement_info` as p INNER JOIN `tbl_placement_info` AS p1 ON p.`PlacementMemberNo`=p1.`MemberNo` GROUP BY p.`PlacementMemberNo`,p1.`MemberNo`,p1.`ChildNum` HAVING ( COUNT(p.`MemberNo`) <> p1.`ChildNum` )
Check Entitle Reward
*** update StatusPlanSubcription in tbl_member_info ( Entitle Reward Status : NO ) ***
check sql: SELECT MemberNo FROM tbl_member_info Where ( (PlanSubcriptionExpire >= '2025-09-16') AND (PlanSubcriptionExpire < '2025-09-17' ))
( 1) Check Transac buy EDR - sql : SELECT TransacDate,AmtTransac FROM tbl_transac_logs where Memberno='1035546' AND TransacType like 'EDR' AND MerchantID LIKE 'OCMALL' AND TransacDate>='2025-08-19'
*** update StatusPlanSubcription=0 where PlanSubcriptionExpire < '2025-09-17' in tbl_member_info ( Entitle Reward Status : NO ) ***
update sql : Update tbl_member_info Set StatusPlanSubcription='0' Where PlanSubcriptionExpire < '2025-09-17'
*** update StatusPlanSubcription in tbl_member_info ( Entitle Reward Status : YES ) ***
Update tbl_member_info Set StatusPlanSubcription='1' Where PlanSubcriptionExpire >= '2025-09-17' And StatusPlanSubcription < '1'
*** update NumOfSponsoring in tbl_member_info ***
check sql: SELECT MemberNo,NumOfSponsoring,Num FROM onecent.view_num_sponsoring where NumOfSponsoring < Num LIMIT 300
Fatal error: Uncaught mysqli_sql_exception: The user specified as a definer ('adminuser'@'%') does not exist in /var/www/smart.onecent.my/service/run-update-childnum.php:148
Stack trace:
#0 /var/www/smart.onecent.my/service/run-update-childnum.php(148): mysqli_query()
#1 {main}
thrown in /var/www/smart.onecent.my/service/run-update-childnum.php on line 148