[2020-12-30 14:40:47] UPDATE admin SET login_ip='192.168.2.110', login_time='16093104479107' WHERE id='0' LIMIT 1 [2020-12-30 14:40:47] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 14:40:47',0,'192.168.2.110',1,1) [2020-12-30 14:40:47] UPDATE admin SET lastlogindate='2020-12-30 14:40:47' WHERE id='-1' LIMIT 1 [2020-12-30 14:40:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 14:40:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 14:40:48] UPDATE admin SET lastlogindate='2020-12-30 14:40:48' WHERE id='-1' LIMIT 1 [2020-12-30 14:40:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 14:40:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 14:40:51] UPDATE admin SET lastlogindate='2020-12-30 14:40:51' WHERE id='-1' LIMIT 1 [2020-12-30 14:40:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 14:40:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 14:40:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:00:37] UPDATE sales SET login_ip='58.152.17.219', login_time='16093224377184' WHERE Sid='1' LIMIT 1 [2020-12-30 18:00:37] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 18:00:37',1,'58.152.17.219',1,2) [2020-12-30 18:00:37] UPDATE sales SET lastlogindate='2020-12-30 18:00:37' WHERE Sid='1' LIMIT 1 [2020-12-30 18:00:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:00:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:00:38] UPDATE sales SET lastlogindate='2020-12-30 18:00:38' WHERE Sid='1' LIMIT 1 [2020-12-30 18:00:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:00:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:00:48] UPDATE sales SET lastlogindate='2020-12-30 18:00:48' WHERE Sid='1' LIMIT 1 [2020-12-30 18:00:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:00:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:00:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:00:48] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:00:48] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:01:31] UPDATE sales SET lastlogindate='2020-12-30 18:01:31' WHERE Sid='1' LIMIT 1 [2020-12-30 18:01:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:01:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:01:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:01:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:01:32] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:01:32] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:23] UPDATE admin SET login_ip='58.152.17.219', login_time='16093225434678' WHERE id='1' LIMIT 1 [2020-12-30 18:02:23] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 18:02:23',1,'58.152.17.219',1,1) [2020-12-30 18:02:23] UPDATE admin SET lastlogindate='2020-12-30 18:02:23' WHERE id='1' LIMIT 1 [2020-12-30 18:02:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:23] UPDATE admin SET lastlogindate='2020-12-30 18:02:23' WHERE id='1' LIMIT 1 [2020-12-30 18:02:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:30] UPDATE admin SET lastlogindate='2020-12-30 18:02:30' WHERE id='1' LIMIT 1 [2020-12-30 18:02:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:30] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:30] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:33] UPDATE admin SET lastlogindate='2020-12-30 18:02:33' WHERE id='1' LIMIT 1 [2020-12-30 18:02:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:33] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:33] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:33] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:37] UPDATE admin SET lastlogindate='2020-12-30 18:02:37' WHERE id='1' LIMIT 1 [2020-12-30 18:02:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:38] UPDATE admin SET lastlogindate='2020-12-30 18:02:38' WHERE id='1' LIMIT 1 [2020-12-30 18:02:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:38] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:38] UPDATE admin SET lastlogindate='2020-12-30 18:02:38' WHERE id='1' LIMIT 1 [2020-12-30 18:02:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:39] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:39] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:46] UPDATE admin SET lastlogindate='2020-12-30 18:02:46' WHERE id='1' LIMIT 1 [2020-12-30 18:02:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:47] UPDATE admin SET lastlogindate='2020-12-30 18:02:47' WHERE id='1' LIMIT 1 [2020-12-30 18:02:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:02:50] UPDATE admin SET lastlogindate='2020-12-30 18:02:50' WHERE id='1' LIMIT 1 [2020-12-30 18:02:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:02:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:02:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:20] UPDATE sales SET lastlogindate='2020-12-30 18:10:20' WHERE Sid='1' LIMIT 1 [2020-12-30 18:10:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:20] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:22] UPDATE sales SET lastlogindate='2020-12-30 18:10:22' WHERE Sid='1' LIMIT 1 [2020-12-30 18:10:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:23] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:23] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:27] UPDATE sales SET lastlogindate='2020-12-30 18:10:27' WHERE Sid='1' LIMIT 1 [2020-12-30 18:10:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:28] UPDATE sales SET lastlogindate='2020-12-30 18:10:28' WHERE Sid='1' LIMIT 1 [2020-12-30 18:10:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:50] UPDATE sales SET lastlogindate='2020-12-30 18:10:50' WHERE Sid='1' LIMIT 1 [2020-12-30 18:10:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:10:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:10:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:10:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:14:17] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 18:14:17', '2', '1', '13800', '何太' ) [2020-12-30 18:14:17] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 18:14:17', '1', '58.152.17.219', '8', 'project', '樓盤︰藍田 - 康田苑 座: B, 單位: 05, 層: 27, 地段編號: *', '13800', '2' ) [2020-12-30 18:14:42] UPDATE sales SET lastlogindate='2020-12-30 18:14:42' WHERE Sid='1' LIMIT 1 [2020-12-30 18:14:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:42] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:42] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:14:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:14:50] UPDATE sales SET lastlogindate='2020-12-30 18:14:50' WHERE Sid='1' LIMIT 1 [2020-12-30 18:14:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:14:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:14:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:14:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:14:51] UPDATE sales SET lastlogindate='2020-12-30 18:14:51' WHERE Sid='1' LIMIT 1 [2020-12-30 18:14:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:14:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:14:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:14:51] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:14:51] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:17:48] UPDATE sales SET lastlogindate='2020-12-30 18:17:48' WHERE Sid='1' LIMIT 1 [2020-12-30 18:17:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:17:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:17:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:17:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:17:48] UPDATE sales SET lastlogindate='2020-12-30 18:17:48' WHERE Sid='1' LIMIT 1 [2020-12-30 18:17:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:17:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:17:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:17:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:00] UPDATE sales SET lastlogindate='2020-12-30 18:18:00' WHERE Sid='1' LIMIT 1 [2020-12-30 18:18:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:00] UPDATE sales SET lastlogindate='2020-12-30 18:18:00' WHERE Sid='1' LIMIT 1 [2020-12-30 18:18:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:04] UPDATE sales SET lastlogindate='2020-12-30 18:18:04' WHERE Sid='1' LIMIT 1 [2020-12-30 18:18:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:18:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:18:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:18:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:22:59] UPDATE sales SET login_ip='192.168.0.173', login_time='16093237793740' WHERE Sid='106' LIMIT 1 [2020-12-30 18:22:59] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 18:22:59',106,'192.168.0.173',1,2) [2020-12-30 18:22:59] UPDATE sales SET lastlogindate='2020-12-30 18:22:59' WHERE Sid='106' LIMIT 1 [2020-12-30 18:22:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:22:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:22:59] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:22:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:00] UPDATE sales SET lastlogindate='2020-12-30 18:23:00' WHERE Sid='106' LIMIT 1 [2020-12-30 18:23:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:23:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:04] UPDATE sales SET lastlogindate='2020-12-30 18:23:04' WHERE Sid='106' LIMIT 1 [2020-12-30 18:23:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:23:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:04] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:23:04] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:41] UPDATE sales SET login_ip='192.168.0.132', login_time='16093238218957' WHERE Sid='1' LIMIT 1 [2020-12-30 18:23:41] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 18:23:41',1,'192.168.0.132',1,2) [2020-12-30 18:23:41] UPDATE sales SET lastlogindate='2020-12-30 18:23:41' WHERE Sid='1' LIMIT 1 [2020-12-30 18:23:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:41] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:23:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:42] UPDATE sales SET lastlogindate='2020-12-30 18:23:42' WHERE Sid='1' LIMIT 1 [2020-12-30 18:23:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:42] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:23:42] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:23:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:23:49] UPDATE admin SET login_ip='' WHERE id='1' LIMIT 1 [2020-12-30 18:23:49] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '1', '192.168.0.132', '9', '2' ) [2020-12-30 18:24:30] UPDATE admin SET lastlogindate='2020-12-30 18:24:30' WHERE id='1' LIMIT 1 [2020-12-30 18:24:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:24:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:24:32] UPDATE admin SET lastlogindate='2020-12-30 18:24:32' WHERE id='1' LIMIT 1 [2020-12-30 18:24:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:24:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:24:35] UPDATE admin SET lastlogindate='2020-12-30 18:24:35' WHERE id='1' LIMIT 1 [2020-12-30 18:24:35] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:35] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:24:35] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:24:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:24:35] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:24:35] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:25:20] UPDATE sales SET lastlogindate='2020-12-30 18:25:20' WHERE Sid='106' LIMIT 1 [2020-12-30 18:25:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:20] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:25:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:25:21] UPDATE sales SET lastlogindate='2020-12-30 18:25:21' WHERE Sid='106' LIMIT 1 [2020-12-30 18:25:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:25:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:25:26] UPDATE sales SET lastlogindate='2020-12-30 18:25:26' WHERE Sid='106' LIMIT 1 [2020-12-30 18:25:26] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:25:26] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:25:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:25:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:25:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:26:35] UPDATE sales SET lastlogindate='2020-12-30 18:26:35' WHERE Sid='106' LIMIT 1 [2020-12-30 18:26:35] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:26:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:26:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:26:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:26:36] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:26:36] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:27:54] UPDATE sales SET lastlogindate='2020-12-30 18:27:54' WHERE Sid='106' LIMIT 1 [2020-12-30 18:27:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:27:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:27:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:27:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:27:55] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:27:55] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:28:49] UPDATE sales SET lastlogindate='2020-12-30 18:28:49' WHERE Sid='106' LIMIT 1 [2020-12-30 18:28:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:28:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:28:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:28:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:28:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:28:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:29:26] UPDATE sales SET lastlogindate='2020-12-30 18:29:26' WHERE Sid='106' LIMIT 1 [2020-12-30 18:29:26] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:29:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:29:26] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:29:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:29:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:29:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:29:55] UPDATE sales SET lastlogindate='2020-12-30 18:29:55' WHERE Sid='1' LIMIT 1 [2020-12-30 18:30:22] UPDATE sales SET lastlogindate='2020-12-30 18:30:22' WHERE Sid='106' LIMIT 1 [2020-12-30 18:30:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:30:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:30:22] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:30:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:30:22] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:30:22] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:34:31] UPDATE sales SET lastlogindate='2020-12-30 18:34:31' WHERE Sid='106' LIMIT 1 [2020-12-30 18:34:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:34:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:34:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:34:31] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:34:31] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:34:31] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:35:29] UPDATE sales SET lastlogindate='2020-12-30 18:35:29' WHERE Sid='106' LIMIT 1 [2020-12-30 18:35:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:35:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:35:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:35:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:35:29] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:35:29] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:38:08] UPDATE sales SET lastlogindate='2020-12-30 18:38:08' WHERE Sid='106' LIMIT 1 [2020-12-30 18:38:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:38:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:38:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:38:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:38:08] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:38:08] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:40:39] UPDATE sales SET lastlogindate='2020-12-30 18:40:39' WHERE Sid='106' LIMIT 1 [2020-12-30 18:40:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:40:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:40:39] UPDATE sales SET lastlogindate='2020-12-30 18:40:39' WHERE Sid='106' LIMIT 1 [2020-12-30 18:40:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:40:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:40:44] UPDATE sales SET lastlogindate='2020-12-30 18:40:44' WHERE Sid='106' LIMIT 1 [2020-12-30 18:40:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:40:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:40:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:40:44] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:40:44] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:41:03] UPDATE sales SET lastlogindate='2020-12-30 18:41:03' WHERE Sid='106' LIMIT 1 [2020-12-30 18:41:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:41:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:41:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:41:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:41:03] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:41:03] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:41:28] UPDATE sales SET lastlogindate='2020-12-30 18:41:28' WHERE Sid='106' LIMIT 1 [2020-12-30 18:41:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:41:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:41:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:41:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:41:29] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:41:29] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:14] UPDATE sales SET lastlogindate='2020-12-30 18:42:14' WHERE Sid='106' LIMIT 1 [2020-12-30 18:42:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:14] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:14] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:40] UPDATE sales SET lastlogindate='2020-12-30 18:42:40' WHERE Sid='106' LIMIT 1 [2020-12-30 18:42:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:40] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:55] UPDATE sales SET lastlogindate='2020-12-30 18:42:55' WHERE Sid='106' LIMIT 1 [2020-12-30 18:42:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:42:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:42:55] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:42:55] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:43:32] UPDATE sales SET lastlogindate='2020-12-30 18:43:32' WHERE Sid='106' LIMIT 1 [2020-12-30 18:43:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:43:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:43:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:43:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:43:33] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:43:33] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:45:23] UPDATE sales SET lastlogindate='2020-12-30 18:45:23' WHERE Sid='106' LIMIT 1 [2020-12-30 18:45:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:45:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:45:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:45:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:45:23] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:45:23] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:45:30] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 18:45:30', '2', '106', '9467', 'CHUI KA YU CALVIN' ) [2020-12-30 18:45:30] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 18:45:30', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 康柏苑 座: F, 單位: 06, 層: 11, 地段編號: *', '9467', '2' ) [2020-12-30 18:49:04] UPDATE sales SET lastlogindate='2020-12-30 18:49:04' WHERE Sid='106' LIMIT 1 [2020-12-30 18:49:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:49:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:49:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:49:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:49:04] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:49:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:49:10] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 18:49:10', '2', '106', '9506', '余小姐' ) [2020-12-30 18:49:10] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 18:49:10', '106', '192.168.0.173', '8', 'project', '樓盤︰油塘/住宅 - 海傲灣 座: 2, 單位: F, 層: 25, 地段編號: *', '9506', '2' ) [2020-12-30 18:50:15] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 18:50:15', '2', '106', '9506', '王生' ) [2020-12-30 18:50:15] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 18:50:15', '106', '192.168.0.173', '8', 'project', '樓盤︰油塘/住宅 - 海傲灣 座: 2, 單位: F, 層: 25, 地段編號: *', '9506', '2' ) [2020-12-30 18:50:45] UPDATE sales SET lastlogindate='2020-12-30 18:50:45' WHERE Sid='106' LIMIT 1 [2020-12-30 18:50:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:50:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:50:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:50:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:50:45] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:50:45] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:52:18] UPDATE sales SET lastlogindate='2020-12-30 18:52:18' WHERE Sid='106' LIMIT 1 [2020-12-30 18:52:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:52:18] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:52:18] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:52:18] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:52:18] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:52:18] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:55:23] UPDATE sales SET lastlogindate='2020-12-30 18:55:23' WHERE Sid='106' LIMIT 1 [2020-12-30 18:55:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:55:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:55:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:55:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:55:23] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:55:23] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:55:54] UPDATE sales SET lastlogindate='2020-12-30 18:55:54' WHERE Sid='106' LIMIT 1 [2020-12-30 18:55:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:55:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:55:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:55:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:55:54] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:55:54] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:58:28] UPDATE sales SET lastlogindate='2020-12-30 18:58:28' WHERE Sid='106' LIMIT 1 [2020-12-30 18:58:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:58:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 18:58:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:58:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 18:58:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 18:58:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:02:44] UPDATE sales SET lastlogindate='2020-12-30 19:02:44' WHERE Sid='106' LIMIT 1 [2020-12-30 19:02:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:02:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:02:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:02:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:02:45] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:02:45] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:02:58] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 19:02:58', '2', '106', '7253', '業主韓太' ) [2020-12-30 19:02:58] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 19:02:58', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 康田苑 座: B, 單位: 06, 層: 26, 地段編號: *', '7253', '2' ) [2020-12-30 19:37:45] UPDATE sales SET login_ip='192.168.0.114', login_time='16093282652811' WHERE Sid='108' LIMIT 1 [2020-12-30 19:37:45] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 19:37:45',108,'192.168.0.114',1,2) [2020-12-30 19:37:45] UPDATE sales SET lastlogindate='2020-12-30 19:37:45' WHERE Sid='108' LIMIT 1 [2020-12-30 19:37:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:37:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:37:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:37:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:37:46] UPDATE sales SET lastlogindate='2020-12-30 19:37:46' WHERE Sid='108' LIMIT 1 [2020-12-30 19:37:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:37:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:37:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:37:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:38:55] UPDATE sales SET lastlogindate='2020-12-30 19:38:55' WHERE Sid='108' LIMIT 1 [2020-12-30 19:38:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:38:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:38:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:38:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:38:57] UPDATE sales SET lastlogindate='2020-12-30 19:38:57' WHERE Sid='108' LIMIT 1 [2020-12-30 19:38:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:38:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:38:57] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:38:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:39:05] UPDATE sales SET lastlogindate='2020-12-30 19:39:05' WHERE Sid='108' LIMIT 1 [2020-12-30 19:39:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:39:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:39:11] UPDATE sales SET lastlogindate='2020-12-30 19:39:11' WHERE Sid='108' LIMIT 1 [2020-12-30 19:39:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:39:11] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:39:43] UPDATE sales SET login_ip='42.200.71.168', login_time='16093283831530' WHERE Sid='1' LIMIT 1 [2020-12-30 19:39:43] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 19:39:43',1,'42.200.71.168',1,2) [2020-12-30 19:39:43] UPDATE sales SET lastlogindate='2020-12-30 19:39:43' WHERE Sid='1' LIMIT 1 [2020-12-30 19:39:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:39:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:39:44] UPDATE sales SET lastlogindate='2020-12-30 19:39:44' WHERE Sid='1' LIMIT 1 [2020-12-30 19:39:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:39:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:39:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:05] UPDATE sales SET lastlogindate='2020-12-30 19:40:05' WHERE Sid='1' LIMIT 1 [2020-12-30 19:40:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:08] UPDATE sales SET lastlogindate='2020-12-30 19:40:08' WHERE Sid='108' LIMIT 1 [2020-12-30 19:40:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:08] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:08] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:15] UPDATE sales SET lastlogindate='2020-12-30 19:40:15' WHERE Sid='1' LIMIT 1 [2020-12-30 19:40:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:15] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:15] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:44] UPDATE sales SET lastlogindate='2020-12-30 19:40:44' WHERE Sid='108' LIMIT 1 [2020-12-30 19:40:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:44] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:44] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:57] UPDATE sales SET lastlogindate='2020-12-30 19:40:57' WHERE Sid='108' LIMIT 1 [2020-12-30 19:40:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:40:57] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:40:58] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:40:58] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:42:57] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 19:42:57', '2', '1', '13800', '何太' ) [2020-12-30 19:42:57] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 19:42:57', '1', '42.200.71.168', '8', 'project', '樓盤︰藍田 - 康田苑 座: B, 單位: 05, 層: 27, 地段編號: *', '13800', '2' ) [2020-12-30 19:44:55] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:44:57] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:44:57] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:44:58] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:09] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:09] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:11] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:12] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:13] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:14] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:14] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:17] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:17] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:31] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:32] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:32] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:33] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:33] UPDATE project SET PeditStartDate=NOW() WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:36] UPDATE sales SET lastlogindate='2020-12-30 19:45:36' WHERE Sid='1' LIMIT 1 [2020-12-30 19:45:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:45:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:45:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:45:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:45:37] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='1',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2020-10-11',`Pbexdate1`='2020-10-11',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='5',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`='B',`Pflat`='05',`Pfloor`='27',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`=NULL,`PBDsarea`='531',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`=NULL,`PBDdecorating`='發展商 : 房屋署 入伙日期 : 1982年 單位數目：792伙 彈性十字一型 A座裕康閣 B座和康閣 C座祈康閣 管理公司 : 首次出售時大約折扣率：免補地價 ***********兇宅************ 案發日期 2014/08/14 地區 藍田 地址 HONG TIN COURT BLK C KEI HONG HSE (HOS), KAI TIN RD 31 啟田道31號, 康田苑 C座 祈康閣 凶宅成因 52歲姓容男僱主於早上9時許被外傭發現在床上昏迷不醒,送院搶救證實不治',`PBDdescription`='3.5房, 改左一間士多房',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`='4',`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='2',`PtmpSid`='100',`Cid`=NULL,`Oid`=NULL,`PBDsources`='3',`Prpice`='7380000',`Poremarkmulti`='|2020-12-30 19:45:35::2::1::何太話底價738萬||2020-12-02 17:12:44::2::101::改745萬||2020-11-06 10:44:30::2::97::已核實F.3 NO.10352||2020-11-04 15:53:53::2::100::SIGN F.3 NO.10352 (4/11/2020 至 4/11/2021) BY LOUIS 5%||2020-11-04 15:53:21::2::100::已取消獨家||2020-10-15 10:53:57::2::97::已核實F.3 NO.10192||2020-10-12 18:19:29::2::100::何永德已取$50放盤現金券8032494704||2020-10-12 16:24:45::2::100::同事們請留意, 業主會睇28HSE, 如果用左此單位既相登廣告但價錢唔係登758萬, 業主會炸型||2020-10-11 17:55:50::2::100::佣金8折||2020-10-09 21:08:58::2::100::SIGN F.3 NO.10192 (9/10/2020 至 8/1/2021) BY LOUIS 5%||2020-10-09 21:08:04::2::100::*獨家OS $7.58M, BY LOUIS 20%|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`='7450000',`Prent`=NULL,`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2020-10-09 21:13:37',`Pmodifydate`='2020-12-30 19:45:37',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='何太####::(手提)91723688',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='8647' WHERE Pid=13800 [2020-12-30 19:45:37] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('13800','2020-12-30 19:45:37','1','2','1','Poremarkmulti') [2020-12-30 19:45:37] DELETE FROM projectalert WHERE PAPid='13800' && PAadmin='1' && PAtype='2' && PAalert=1 [2020-12-30 19:45:37] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='13800' LIMIT 1 [2020-12-30 19:45:37] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 19:45:37',1,'42.200.71.168',3,'project','樓盤︰藍田 - 康田苑 座: B, 單位: 05, 層: 27, 地段編號: *',13800,2) [2020-12-30 19:45:37] UPDATE projectshare SET Pname='' WHERE Pid=13800 [2020-12-30 19:45:37] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=13800 [2020-12-30 19:45:37] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=13800 [2020-12-30 19:45:37] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-12-30 19:45:37] UPDATE project SET Pstatus=2 WHERE Pid=13800 [2020-12-30 19:45:37] UPDATE project SET Pstatus2=2 WHERE Pid=13800 [2020-12-30 19:45:37] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-12-30 19:45:37] UPDATE sales SET lastlogindate='2020-12-30 19:45:37' WHERE Sid='1' LIMIT 1 [2020-12-30 19:45:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:45:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:45:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:45:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:45:37] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:45:37] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:48:05] UPDATE sales SET lastlogindate='2020-12-30 19:48:05' WHERE Sid='108' LIMIT 1 [2020-12-30 19:48:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:48:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:48:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:48:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:48:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:48:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:52:29] UPDATE sales SET lastlogindate='2020-12-30 19:52:29' WHERE Sid='1' LIMIT 1 [2020-12-30 19:52:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:52:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:52:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:52:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:52:29] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:52:29] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:52:58] UPDATE sales SET lastlogindate='2020-12-30 19:52:58' WHERE Sid='1' LIMIT 1 [2020-12-30 19:52:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:52:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:52:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:52:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:52:58] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:52:59] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:56:28] UPDATE sales SET lastlogindate='2020-12-30 19:56:28' WHERE Sid='1' LIMIT 1 [2020-12-30 19:56:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:56:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:56:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:56:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:56:29] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:56:29] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:56:32] UPDATE sales SET lastlogindate='2020-12-30 19:56:32' WHERE Sid='1' LIMIT 1 [2020-12-30 19:56:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:56:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:56:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:56:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:56:33] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:56:33] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:29] UPDATE sales SET lastlogindate='2020-12-30 19:59:29' WHERE Sid='1' LIMIT 1 [2020-12-30 19:59:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:30] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES (NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'嘉華商場','132','B',NULL,'3',NULL,NULL,NULL,NULL,NULL,'38',NULL,NULL,NULL,NULL,NULL,'6',NULL,'***1-1-2019 會加管理費*** 發展商 : 房屋署 入伙日期 : 1979年 單位數目 : 506伙 車位數目 : 67個 管理公司 : TEL 23483184 FAX 27724323 保安室 : TEL 27759779 法團: 27090433 首次出售時大約折扣率：免補地價 ********凶宅******** 油塘中心5G3 1985年 女子吊頸 ，1988年 多重受傷致命',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'2','1',NULL,NULL,'6',NULL,'|2020-12-30 19:59:19::2::1::OR $8500 , 已吉 , CO-OP 美居 傅生 |',NULL,NULL,NULL,'8500',NULL,NULL,NULL,NULL,NULL,NULL,'2020-12-30 19:59:30','2020-12-30 19:59:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CO-OP 美居 傅生 ####::(手提)61836377',NULL,NULL,NULL,NULL,NULL,'9526') [2020-12-30 19:59:30] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2020-12-30 19:59:30] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`) VALUE ('14616','2020-12-30 19:59:30','1','2','1','Prent','','8500') [2020-12-30 19:59:30] UPDATE project SET Pprice_old='2020-12-30 19:59:30::0::8500' WHERE Pid='14616' LIMIT 1 [2020-12-30 19:59:30] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 19:59:30',1,'42.200.71.168',2,'project','項目 : ',14616,'2') [2020-12-30 19:59:30] UPDATE sales SET lastlogindate='2020-12-30 19:59:30' WHERE Sid='1' LIMIT 1 [2020-12-30 19:59:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:30] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:30] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:50] UPDATE sales SET lastlogindate='2020-12-30 19:59:50' WHERE Sid='106' LIMIT 1 [2020-12-30 19:59:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:51] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:51] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:51] UPDATE sales SET lastlogindate='2020-12-30 19:59:51' WHERE Sid='106' LIMIT 1 [2020-12-30 19:59:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 19:59:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 19:59:52] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 19:59:52] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:00:50] UPDATE sales SET lastlogindate='2020-12-30 20:00:50' WHERE Sid='1' LIMIT 1 [2020-12-30 20:00:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:00:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:00:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:00:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:00:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:00:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:00:53] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='14616' LIMIT 1 [2020-12-30 20:01:09] UPDATE sales SET lastlogindate='2020-12-30 20:01:09' WHERE Sid='1' LIMIT 1 [2020-12-30 20:01:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:01:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:01:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:01:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:01:10] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:01:10] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:02:52] UPDATE sales SET lastlogindate='2020-12-30 20:02:52' WHERE Sid='1' LIMIT 1 [2020-12-30 20:02:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:02:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:02:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:02:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:02:52] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:02:52] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:03:51] UPDATE sales SET lastlogindate='2020-12-30 20:03:51' WHERE Sid='1' LIMIT 1 [2020-12-30 20:03:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:03:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:03:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:03:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:04:04] INSERT INTO `message`(`Mdate`, `Madmin`, `Madmintype`, `Mcontent`, `Mstatus`) VALUES ( NOW(), '1', '2', 'OR 嘉華商場B132 租$8500，已吉', '1' ) [2020-12-30 20:04:04] UPDATE sales SET lastlogindate='2020-12-30 20:04:04' WHERE Sid='1' LIMIT 1 [2020-12-30 20:04:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:04:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:04:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:04:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:06:31] UPDATE sales SET lastlogindate='2020-12-30 20:06:31' WHERE Sid='1' LIMIT 1 [2020-12-30 20:06:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:06:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:06:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:06:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:00] UPDATE sales SET lastlogindate='2020-12-30 20:34:00' WHERE Sid='108' LIMIT 1 [2020-12-30 20:34:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:44] UPDATE sales SET lastlogindate='2020-12-30 20:34:44' WHERE Sid='1' LIMIT 1 [2020-12-30 20:34:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:45] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:45] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:54] UPDATE sales SET lastlogindate='2020-12-30 20:34:54' WHERE Sid='1' LIMIT 1 [2020-12-30 20:34:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:54] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:54] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:34:58] UPDATE sales SET lastlogindate='2020-12-30 20:34:58' WHERE Sid='1' LIMIT 1 [2020-12-30 20:34:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:34:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:34:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:35:00] UPDATE sales SET lastlogindate='2020-12-30 20:35:00' WHERE Sid='1' LIMIT 1 [2020-12-30 20:35:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:35:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:35:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:35:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:35:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:35:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:35:02] UPDATE sales SET lastlogindate='2020-12-30 20:35:02' WHERE Sid='1' LIMIT 1 [2020-12-30 20:35:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:35:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:35:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:35:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:35:03] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:35:03] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:49:36] UPDATE sales SET lastlogindate='2020-12-30 20:49:36' WHERE Sid='1' LIMIT 1 [2020-12-30 20:49:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:49:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:49:38] UPDATE sales SET lastlogindate='2020-12-30 20:49:38' WHERE Sid='1' LIMIT 1 [2020-12-30 20:49:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:49:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:49:50] UPDATE sales SET lastlogindate='2020-12-30 20:49:50' WHERE Sid='1' LIMIT 1 [2020-12-30 20:49:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:49:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:49:59] UPDATE sales SET lastlogindate='2020-12-30 20:49:59' WHERE Sid='1' LIMIT 1 [2020-12-30 20:49:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:49:59] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:49:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:50:05] UPDATE sales SET lastlogindate='2020-12-30 20:50:05' WHERE Sid='1' LIMIT 1 [2020-12-30 20:50:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:50:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:50:27] UPDATE sales SET lastlogindate='2020-12-30 20:50:27' WHERE Sid='1' LIMIT 1 [2020-12-30 20:50:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:50:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:50:53] UPDATE sales SET lastlogindate='2020-12-30 20:50:53' WHERE Sid='1' LIMIT 1 [2020-12-30 20:50:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:50:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:50:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:51:27] UPDATE sales SET lastlogindate='2020-12-30 20:51:27' WHERE Sid='1' LIMIT 1 [2020-12-30 20:51:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:51:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:51:41] UPDATE sales SET lastlogindate='2020-12-30 20:51:41' WHERE Sid='1' LIMIT 1 [2020-12-30 20:51:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:41] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:51:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:51:53] UPDATE sales SET lastlogindate='2020-12-30 20:51:53' WHERE Sid='1' LIMIT 1 [2020-12-30 20:51:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:51:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:51:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:55:36] UPDATE sales SET lastlogindate='2020-12-30 20:55:36' WHERE Sid='1' LIMIT 1 [2020-12-30 20:55:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:55:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:55:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:55:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:56:00] UPDATE sales SET lastlogindate='2020-12-30 20:56:00' WHERE Sid='1' LIMIT 1 [2020-12-30 20:56:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:56:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:56:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:56:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:56:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:56:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:56:34] UPDATE sales SET lastlogindate='2020-12-30 20:56:34' WHERE Sid='1' LIMIT 1 [2020-12-30 20:56:34] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:56:34] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 20:56:34] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:56:35] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 20:56:35] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 20:56:35] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:00:39] UPDATE sales SET login_ip='192.168.0.173', login_time='16093332393782' WHERE Sid='106' LIMIT 1 [2020-12-30 21:00:39] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 21:00:39',106,'192.168.0.173',1,2) [2020-12-30 21:00:39] UPDATE sales SET lastlogindate='2020-12-30 21:00:39' WHERE Sid='106' LIMIT 1 [2020-12-30 21:00:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:00:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:00:40] UPDATE sales SET lastlogindate='2020-12-30 21:00:40' WHERE Sid='106' LIMIT 1 [2020-12-30 21:00:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:40] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:00:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:00:43] UPDATE sales SET lastlogindate='2020-12-30 21:00:43' WHERE Sid='106' LIMIT 1 [2020-12-30 21:00:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:00:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:00:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:00:43] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:00:43] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:01:36] UPDATE sales SET lastlogindate='2020-12-30 21:01:36' WHERE Sid='106' LIMIT 1 [2020-12-30 21:01:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:01:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:01:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:01:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:01:36] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:01:36] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:02:04] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:02:04', '2', '106', '9467', 'CHUI KA YU CALVIN' ) [2020-12-30 21:02:04] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:02:04', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 康柏苑 座: F, 單位: 06, 層: 11, 地段編號: *', '9467', '2' ) [2020-12-30 21:02:56] UPDATE sales SET lastlogindate='2020-12-30 21:02:56' WHERE Sid='106' LIMIT 1 [2020-12-30 21:02:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:02:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:02:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:02:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:02:56] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:02:56] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:03:32] UPDATE sales SET lastlogindate='2020-12-30 21:03:32' WHERE Sid='106' LIMIT 1 [2020-12-30 21:03:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:03:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:03:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:03:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:03:33] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:03:33] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:03:57] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:03:57', '2', '106', '1391', 'MS CHERRY' ) [2020-12-30 21:03:57] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:03:57', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 康華苑 座: A, 單位: 05, 層: 3, 地段編號: *', '1391', '2' ) [2020-12-30 21:05:31] UPDATE sales SET lastlogindate='2020-12-30 21:05:31' WHERE Sid='1' LIMIT 1 [2020-12-30 21:05:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:05:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:05:31] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:05:31] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:05:31] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:05:31] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:05] UPDATE sales SET lastlogindate='2020-12-30 21:07:05' WHERE Sid='106' LIMIT 1 [2020-12-30 21:07:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:05] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:21] UPDATE sales SET lastlogindate='2020-12-30 21:07:21' WHERE Sid='106' LIMIT 1 [2020-12-30 21:07:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:21] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:22] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:49] UPDATE sales SET lastlogindate='2020-12-30 21:07:49' WHERE Sid='1' LIMIT 1 [2020-12-30 21:07:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:07:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:07:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:07:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:16] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='4763' LIMIT 1 [2020-12-30 21:08:50] UPDATE sales SET lastlogindate='2020-12-30 21:08:50' WHERE Sid='1' LIMIT 1 [2020-12-30 21:08:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:50] UPDATE project SET `Pdate`='2017-09-30',`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Porecedate`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbrecedate`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='2',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-08-24',`Pbexdate1`='2019-08-24',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='105',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='2',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`=NULL,`Pflat`='?',`Pfloor`='L3',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`=NULL,`PBDsarea`='800',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='6',`PBDlandscape`=NULL,`PBDdecorating`=NULL,`PBDdescription`='CO-OP 康誠JERRY 爭鮮. 已封',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='1',`PtmpSid`=NULL,`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`='|2017-09-24 17:25:58::2::2::CO-OP 康誠JERRY放租27萬, 又話唔租了|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='270000',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`=NULL,`Pexdate3`=NULL,`Pcreatedate`='2017-09-24 17:26:07',`Pmodifydate`='2020-12-30 21:08:50',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='康誠JERRY####::(手提)92843561',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`='1',`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='3275' WHERE Pid=4763 [2020-12-30 21:08:50] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`) VALUE ('4763','2020-12-30 21:08:50','1','2','1','Pstepcount','1','2') [2020-12-30 21:08:50] DELETE FROM projectalert WHERE PAPid='4763' && PAadmin='1' && PAtype='2' && PAalert=1 [2020-12-30 21:08:50] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='4763' LIMIT 1 [2020-12-30 21:08:50] INSERT INTO project ( PgroupID,Pdate,Pcreatedate,Pmodifydate,Pnumber,Padnumber,Plocid,Pname,Pname2,Pflat,Pfloor,Plot_no,Pcar,Plivestatus,Pkeyno,PBDcarea,PBDsarea,PBDinterval,PBDaddress,PBDroom,PBDhall,PBDsuite,PBDcarspac,PBDcarspac_no,PBDmaidroom,PBDopeninterval,PBDtoilet,PBDstorerooms,PBDkitchen,PBDwindowsill,PBDrooftop,PBDgarden,PBDterrace,PBDwork_platform,PBDceiling,PBDdoorwidth,PBDpoweredby,PBDgas,PBDmfees,PBDrfees,PBDtype,PBDsources,PBDlandscape,PBDstatus,PBDexclusive,PBDlistings,PBDkey,PBDkey_no,Pdirection,PBDdecorating,PBDdescription,PBDmobiler_desc,PBDimages,PBDfiles,PBDyoutube,Poname,Potel,Poctel,Pomtel,Pocontact,Pocontacttel,Pocontactmulti,Poremark,Poremarkmulti,Pcustom,Pccontactmulti,Pcremarkmulti,Pdcontactmulti,Pdremarkmulti,Pbname,Pbremark,PtmpBid,PtmpSid,Pprice,Ppprice,Ppprice_s,Ppprice_t,Pmobile_pprice,Pmobile_pprice_s,Pmobile_pprice_t,Prent,Prent_s,Prent_t,Pmobiler_rent,Pmobiler_rent_s,Pmobiler_rent_t,Pprice_old,Prpice,Prpice2,Popay,Pbpay,Premark,Bid,Sid,Cid,Oid,Pstatus,Pmobile_status,Pmobile_top,Pmobile_sno,Porecedate,Potype,Popaytype,Popaydate,Popaymethod,Pobankno,Popayremark,Pbrecedate,Pbtype,Pbpaytype,Pbpaydate,Pbpaymethod,Pbbankno,Pbpayremark,Ptype,Pexdate1,Pexdate2,Pexdate3,Poexdate1,Pbexdate1,Polawyer,Pblawyer,Pocheque,Pbcheque,BDid,Poadminid,Pbadminid,Poreceived,Pbreceived,Bnamesearch,Snamesearch,Pocooperate,Pbcooperate,Pstatus2,Pstepcount,Polawyermore,Pblawyermore,Plastsenddate,Pttype,Pcompany,Pbrname,Pbrtel,Psaveas,Pextra1,Pextra2,Pextra3,Pextra4,Pextra5,Pextra6,Pextra7,Pextra8,Pextra9,Pextra10,Pextra11,PeditAdminType,PeditAdminID,PeditStartDate ) VALUES ( '4763',NULL,'2017-09-24 17:26:07','2020-12-30 21:08:50','','9527','37','','','?','L3','','',0,'','','800','','','','','','','','','','','','','','','','','','','','','','','','6','6','','1',NULL,NULL,NULL,NULL,'','','CO-OP 康誠JERRY 爭鮮. 已封','','','','','','','','','','','康誠JERRY####::(手提)92843561','',NULL,'','',NULL,NULL,NULL,'','','1','',0,0,'','','','','',0,'','','','','',NULL,0,0,'0.00','0.00','','','','','','','','','','','','','','','','','','','','','','','','2','','','','2019-08-24','2019-08-24','','','','','105','','','','','','','','','','1','','','',NULL,NULL,NULL,NULL,'2','','','','','','','','','','','','','','' ) [2020-12-30 21:08:50] UPDATE project SET Psaveas=1 WHERE Pid='4763' LIMIT 1 [2020-12-30 21:08:50] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 21:08:50',1,'42.200.71.168',3,'project','樓盤︰藍田 - 匯景廣場 座: , 單位: ?, 層: L3, 地段編號: ',4763,2) [2020-12-30 21:08:50] UPDATE projectshare SET Pname='' WHERE Pid=4763 [2020-12-30 21:08:50] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=4763 [2020-12-30 21:08:50] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=4763 [2020-12-30 21:08:50] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-12-30 21:08:50] UPDATE project SET Pstatus=2 WHERE Pid=4763 [2020-12-30 21:08:50] UPDATE project SET Pstatus2=2 WHERE Pid=4763 [2020-12-30 21:08:50] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-12-30 21:08:50] UPDATE sales SET lastlogindate='2020-12-30 21:08:50' WHERE Sid='1' LIMIT 1 [2020-12-30 21:08:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:52] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='14617' LIMIT 1 [2020-12-30 21:08:53] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='14617' LIMIT 1 [2020-12-30 21:08:58] UPDATE sales SET lastlogindate='2020-12-30 21:08:58' WHERE Sid='1' LIMIT 1 [2020-12-30 21:08:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:58] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='2',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-08-24',`Pbexdate1`='2019-08-24',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='105',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`=NULL,`Pflat`='?',`Pfloor`='L3',`Pcar`=NULL,`Plivestatus`='4',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`=NULL,`PBDsarea`='800',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='6',`PBDlandscape`=NULL,`PBDdecorating`=NULL,`PBDdescription`='CO-OP 康誠JERRY 爭鮮. 已封',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='1',`PtmpSid`=NULL,`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`=NULL,`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`=NULL,`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`=NULL,`Pexdate3`=NULL,`Pcreatedate`='2017-09-24 17:26:07',`Pmodifydate`='2020-12-30 21:08:58',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`='4763',`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='康誠JERRY####::(手提)92843561',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='9527' WHERE Pid=14617 [2020-12-30 21:08:58] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`) VALUE ('14617','2020-12-30 21:08:58','1','2','1','Plivestatus','0','4') [2020-12-30 21:08:58] DELETE FROM projectalert WHERE PAPid='14617' && PAadmin='1' && PAtype='2' && PAalert=1 [2020-12-30 21:08:58] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='14617' LIMIT 1 [2020-12-30 21:08:58] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 21:08:58',1,'42.200.71.168',3,'project','樓盤︰藍田 - 匯景廣場 座: , 單位: ?, 層: L3, 地段編號: ',14617,2) [2020-12-30 21:08:58] UPDATE projectshare SET Pname='' WHERE Pid=14617 [2020-12-30 21:08:58] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=14617 [2020-12-30 21:08:58] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=14617 [2020-12-30 21:08:58] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-12-30 21:08:58] UPDATE project SET Pstatus=2 WHERE Pid=14617 [2020-12-30 21:08:58] UPDATE project SET Pstatus2=2 WHERE Pid=14617 [2020-12-30 21:08:58] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-12-30 21:08:59] UPDATE sales SET lastlogindate='2020-12-30 21:08:59' WHERE Sid='1' LIMIT 1 [2020-12-30 21:08:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:08:59] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:08:59] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:08:59] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:03] UPDATE sales SET lastlogindate='2020-12-30 21:09:03' WHERE Sid='1' LIMIT 1 [2020-12-30 21:09:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:03] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:03] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:10] UPDATE sales SET lastlogindate='2020-12-30 21:09:10' WHERE Sid='1' LIMIT 1 [2020-12-30 21:09:10] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:10] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:10] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:10] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:10] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:17] UPDATE sales SET lastlogindate='2020-12-30 21:09:17' WHERE Sid='1' LIMIT 1 [2020-12-30 21:09:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:09:17] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:09:17] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:09:17] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:05] UPDATE sales SET lastlogindate='2020-12-30 21:10:05' WHERE Sid='106' LIMIT 1 [2020-12-30 21:10:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:05] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:06] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:13] UPDATE sales SET lastlogindate='2020-12-30 21:10:13' WHERE Sid='1' LIMIT 1 [2020-12-30 21:10:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:13] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:13] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:13] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:28] UPDATE sales SET lastlogindate='2020-12-30 21:10:28' WHERE Sid='1' LIMIT 1 [2020-12-30 21:10:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:37] UPDATE sales SET lastlogindate='2020-12-30 21:10:37' WHERE Sid='1' LIMIT 1 [2020-12-30 21:10:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:37] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:37] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:46] UPDATE sales SET lastlogindate='2020-12-30 21:10:46' WHERE Sid='1' LIMIT 1 [2020-12-30 21:10:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:10:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:10:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:10:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:16:41] UPDATE sales SET lastlogindate='2020-12-30 21:16:41' WHERE Sid='106' LIMIT 1 [2020-12-30 21:16:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:16:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:16:41] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:16:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:16:41] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:16:41] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:01] UPDATE sales SET lastlogindate='2020-12-30 21:17:01' WHERE Sid='106' LIMIT 1 [2020-12-30 21:17:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:15] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:17:15', '2', '106', '7847', '伍小姐' ) [2020-12-30 21:17:15] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:17:15', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 啟田大廈 座: B, 單位: 01, 層: 3, 地段編號: *', '7847', '2' ) [2020-12-30 21:17:28] UPDATE sales SET lastlogindate='2020-12-30 21:17:28' WHERE Sid='1' LIMIT 1 [2020-12-30 21:17:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:28] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:50] UPDATE sales SET lastlogindate='2020-12-30 21:17:50' WHERE Sid='106' LIMIT 1 [2020-12-30 21:17:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:17:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:17:51] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:17:51] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:18:44] UPDATE sales SET lastlogindate='2020-12-30 21:18:44' WHERE Sid='106' LIMIT 1 [2020-12-30 21:18:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:18:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:18:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:18:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:18:44] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:18:44] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:18:48] UPDATE sales SET lastlogindate='2020-12-30 21:18:48' WHERE Sid='108' LIMIT 1 [2020-12-30 21:18:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:18:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:18:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:18:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:18:48] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:18:48] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:19:12] UPDATE sales SET lastlogindate='2020-12-30 21:19:12' WHERE Sid='108' LIMIT 1 [2020-12-30 21:19:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:19:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:19:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:19:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:19:12] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:19:12] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:19:53] UPDATE sales SET lastlogindate='2020-12-30 21:19:53' WHERE Sid='106' LIMIT 1 [2020-12-30 21:19:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:19:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:19:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:19:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:19:53] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:19:53] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:01] UPDATE sales SET lastlogindate='2020-12-30 21:20:01' WHERE Sid='108' LIMIT 1 [2020-12-30 21:20:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:19] UPDATE sales SET lastlogindate='2020-12-30 21:20:19' WHERE Sid='1' LIMIT 1 [2020-12-30 21:20:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:19] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:19] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:31] UPDATE project SET PeditAdminType='2', PeditAdminID='1', PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:34] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:35] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:35] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:36] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:36] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:37] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:37] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:43] UPDATE sales SET lastlogindate='2020-12-30 21:20:43' WHERE Sid='108' LIMIT 1 [2020-12-30 21:20:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:20:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:43] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:20:43] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:20:44] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:44] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:46] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:50] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:50] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:50] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:51] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:51] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:51] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:51] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:52] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:53] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:20:53] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11232' LIMIT 1 [2020-12-30 21:21:03] UPDATE sales SET lastlogindate='2020-12-30 21:21:03' WHERE Sid='1' LIMIT 1 [2020-12-30 21:21:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:21:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:21:03] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='2',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2020-12-30',`Pbexdate1`='2020-12-30',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='105',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`=NULL,`Pflat`='2O',`Pfloor`='L4',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`='1070',`PBDsarea`=NULL,`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='6',`PBDlandscape`=NULL,`PBDdecorating`=NULL,`PBDdescription`='不包括冷管，現租客貢茶、元朗鬼巴士、雞旦仔',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='2',`PtmpSid`='1',`Cid`=NULL,`Oid`=NULL,`PBDsources`='9',`Prpice`=NULL,`Poremarkmulti`='|2020-12-30 21:21:01::2::1::租$92000 , 不包括冷管||2020-01-31 17:46:49::2::1::OR 租$115000，不包括冷管，現租客貢茶、元朗鬼巴士、雞旦仔|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='92000',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2020-01-31 17:47:20',`Pmodifydate`='2020-12-30 21:21:03',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='大鴻輝 TOMMY LEE####::(手提)98808989::(手提)28622109',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='5886' WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE project SET Pprice_old='2020-12-30 21:21:03::::92000.00,2020-01-31 17:47:20::0::115000' WHERE Pid='11232' LIMIT 1 [2020-12-30 21:21:03] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`,`other`) VALUE ('11232','2020-12-30 21:21:03','1','2','1','Prent','115000.00','92000','Popay,Pbpay,Poexdate1,Pbexdate1,Poremarkmulti') [2020-12-30 21:21:03] DELETE FROM projectalert WHERE PAPid='11232' && PAadmin='1' && PAtype='2' && PAalert=1 [2020-12-30 21:21:03] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='11232' LIMIT 1 [2020-12-30 21:21:03] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 21:21:03',1,'42.200.71.168',3,'project','樓盤︰藍田 - 匯景廣場 座: , 單位: 2O, 層: L4, 地段編號: *',11232,2) [2020-12-30 21:21:03] UPDATE projectshare SET Pname='' WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-12-30 21:21:03] UPDATE project SET Pstatus=2 WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE project SET Pstatus2=2 WHERE Pid=11232 [2020-12-30 21:21:03] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-12-30 21:21:03] UPDATE sales SET lastlogindate='2020-12-30 21:21:03' WHERE Sid='1' LIMIT 1 [2020-12-30 21:21:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:21:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:21:04] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:21:04] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:21:27] UPDATE sales SET lastlogindate='2020-12-30 21:21:27' WHERE Sid='108' LIMIT 1 [2020-12-30 21:21:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:21:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:21:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:21:27] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:21:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:22:06] UPDATE sales SET lastlogindate='2020-12-30 21:22:06' WHERE Sid='106' LIMIT 1 [2020-12-30 21:22:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:22:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:22:06] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:22:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:22:06] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:22:06] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:22:29] UPDATE sales SET lastlogindate='2020-12-30 21:22:29' WHERE Sid='106' LIMIT 1 [2020-12-30 21:22:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:22:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:22:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:22:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:22:29] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:22:29] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:23:36] UPDATE sales SET lastlogindate='2020-12-30 21:23:36' WHERE Sid='106' LIMIT 1 [2020-12-30 21:23:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:23:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:23:36] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:23:36] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:23:46] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:23:46', '2', '106', '11828', '陳小姐' ) [2020-12-30 21:23:46] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:23:46', '106', '192.168.0.173', '8', 'project', '樓盤︰油塘/住宅 - 海傲灣 座: 2, 單位: F, 層: 8, 地段編號: *', '11828', '2' ) [2020-12-30 21:23:52] UPDATE sales SET lastlogindate='2020-12-30 21:23:52' WHERE Sid='108' LIMIT 1 [2020-12-30 21:23:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:23:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:23:53] UPDATE sales SET lastlogindate='2020-12-30 21:23:53' WHERE Sid='108' LIMIT 1 [2020-12-30 21:23:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:23:53] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:23:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:24:14] UPDATE sales SET lastlogindate='2020-12-30 21:24:14' WHERE Sid='108' LIMIT 1 [2020-12-30 21:24:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:24:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:24:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:24:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:26:49] UPDATE project SET PeditAdminType='2', PeditAdminID='106', PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:53] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:55] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:56] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:57] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:58] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:58] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:59] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:26:59] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:00] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:00] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:01] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:01] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:01] UPDATE project SET PeditStartDate=NOW() WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:05] UPDATE sales SET lastlogindate='2020-12-30 21:27:05' WHERE Sid='106' LIMIT 1 [2020-12-30 21:27:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:27:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:27:05] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='2',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-11-17',`Pbexdate1`='2019-11-17',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='347',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`='2',`Pflat`='F',`Pfloor`='8',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='38',`PBDcarea`=NULL,`PBDsarea`='201',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`=NULL,`PBDdecorating`='入伙日期: 2019年9月30日 發展商: 九龍建業 管理公司: 康居物業管理有限公司 物業座數: 2 單位數目: 646 第1座（第1-A座及第1-B座）：24層 第2座：24層 不設4樓、13樓、14樓及24樓 每層伙數: 8-11 住宅停車位：61 校網: 觀塘區 ( 小學: 48 / 中學: 12 )',`PBDdescription`='12月10日交吉',`Pcustom`=NULL,`PBDaddress`='鯉魚門徑1號',`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='2',`PtmpSid`=NULL,`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`='|2020-12-30 21:27:03::2::106::RENT OUT||2020-12-20 10:44:18::2::107::NBA||2020-12-12 21:07:31::2::109::WHATSAPP MISS CHAN AND ASK WHETHER IT HAS RENTED.||2020-11-28 16:59:27::2::1::陳小姐電話未能接通||2020-11-28 16:41:30::2::109::OR $10500 CO-OP美聯Andy, BY ANNIE 5%||2020-11-14 11:30:06::2::88::電話未能接通|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='10500',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2019-11-16 15:01:25',`Pmodifydate`='2020-12-30 21:27:05',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`='1',`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`='10652',`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='CO-OP美聯Andy####::(手提)94948680||陳小姐####::(手提)51117908',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='6541' WHERE Pid=11828 [2020-12-30 21:27:05] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('11828','2020-12-30 21:27:05','106','2','1','Poremarkmulti') [2020-12-30 21:27:05] DELETE FROM projectalert WHERE PAPid='11828' && PAadmin='106' && PAtype='2' && PAalert=1 [2020-12-30 21:27:05] UPDATE project SET PeditAdminType=NULL, PeditAdminID=NULL, PeditStartDate=NULL WHERE Pid='11828' LIMIT 1 [2020-12-30 21:27:05] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2020-12-30 21:27:05',106,'192.168.0.173',3,'project','樓盤︰油塘/住宅 - 海傲灣 座: 2, 單位: F, 層: 8, 地段編號: *',11828,2) [2020-12-30 21:27:05] UPDATE projectshare SET Pname='' WHERE Pid=11828 [2020-12-30 21:27:05] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=11828 [2020-12-30 21:27:05] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=11828 [2020-12-30 21:27:05] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2020-12-30 21:27:05] UPDATE project SET Pstatus=2 WHERE Pid=11828 [2020-12-30 21:27:05] UPDATE project SET Pstatus2=2 WHERE Pid=11828 [2020-12-30 21:27:05] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2020-12-30 21:27:05] UPDATE sales SET lastlogindate='2020-12-30 21:27:05' WHERE Sid='106' LIMIT 1 [2020-12-30 21:27:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:27:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:27:06] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:27:06] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:27:50] UPDATE sales SET lastlogindate='2020-12-30 21:27:50' WHERE Sid='106' LIMIT 1 [2020-12-30 21:27:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:27:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:27:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:27:50] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:27:50] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:28:05] UPDATE sales SET lastlogindate='2020-12-30 21:28:05' WHERE Sid='106' LIMIT 1 [2020-12-30 21:28:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:28:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:28:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:28:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:28:06] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:28:06] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:06] UPDATE sales SET lastlogindate='2020-12-30 21:29:06' WHERE Sid='106' LIMIT 1 [2020-12-30 21:29:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:06] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:06] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:06] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:27] UPDATE sales SET lastlogindate='2020-12-30 21:29:27' WHERE Sid='106' LIMIT 1 [2020-12-30 21:29:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:27] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:27] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:47] UPDATE sales SET lastlogindate='2020-12-30 21:29:47' WHERE Sid='106' LIMIT 1 [2020-12-30 21:29:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:29:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:29:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:29:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:30:01] UPDATE sales SET lastlogindate='2020-12-30 21:30:01' WHERE Sid='106' LIMIT 1 [2020-12-30 21:30:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:30:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:30:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:30:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:30:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:30:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:30:17] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:30:17', '2', '106', '6726', '睇樓約鄭生' ) [2020-12-30 21:30:17] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:30:17', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 啟田大廈 座: A, 單位: 03, 層: 2, 地段編號: *', '6726', '2' ) [2020-12-30 21:30:21] INSERT INTO viewownertel ( `VOTdate`, `VOTstafftype`, `VOTstaff`, `VOTPid`, `VOTowner` ) VALUES ( '2020-12-30 21:30:21', '2', '106', '6726', '业主电话郑生' ) [2020-12-30 21:30:21] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( '2020-12-30 21:30:21', '106', '192.168.0.173', '8', 'project', '樓盤︰藍田 - 啟田大廈 座: A, 單位: 03, 層: 2, 地段編號: *', '6726', '2' ) [2020-12-30 21:40:44] UPDATE sales SET lastlogindate='2020-12-30 21:40:44' WHERE Sid='108' LIMIT 1 [2020-12-30 21:40:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:40:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:40:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:40:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:40:45] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:40:45] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:50:13] UPDATE sales SET lastlogindate='2020-12-30 21:50:13' WHERE Sid='108' LIMIT 1 [2020-12-30 21:50:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:50:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 21:50:13] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:50:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 21:50:13] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 21:50:13] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:04:25] UPDATE sales SET lastlogindate='2020-12-30 22:04:25' WHERE Sid='108' LIMIT 1 [2020-12-30 22:04:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:04:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:04:26] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:04:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:04:26] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:04:26] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:09:43] UPDATE sales SET lastlogindate='2020-12-30 22:09:43' WHERE Sid='108' LIMIT 1 [2020-12-30 22:09:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:09:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:09:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:09:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:09:43] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:09:44] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:10:19] UPDATE sales SET lastlogindate='2020-12-30 22:10:19' WHERE Sid='108' LIMIT 1 [2020-12-30 22:10:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:10:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:10:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:10:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:10:19] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:10:19] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:14] UPDATE sales SET lastlogindate='2020-12-30 22:12:14' WHERE Sid='108' LIMIT 1 [2020-12-30 22:12:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:14] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:14] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:14] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:22] UPDATE sales SET lastlogindate='2020-12-30 22:12:22' WHERE Sid='108' LIMIT 1 [2020-12-30 22:12:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:22] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:22] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:22] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:56] UPDATE sales SET lastlogindate='2020-12-30 22:12:56' WHERE Sid='108' LIMIT 1 [2020-12-30 22:12:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:12:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:12:57] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:12:57] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:11] UPDATE sales SET login_ip='192.168.0.114', login_time='16093378315654' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:11] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2020-12-30 22:17:11',108,'192.168.0.114',1,2) [2020-12-30 22:17:11] UPDATE sales SET lastlogindate='2020-12-30 22:17:11' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:12] UPDATE sales SET lastlogindate='2020-12-30 22:17:12' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:12] UPDATE sales SET lastlogindate='2020-12-30 22:17:12' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:15] UPDATE sales SET lastlogindate='2020-12-30 22:17:15' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:16] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:16] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:46] UPDATE sales SET lastlogindate='2020-12-30 22:17:46' WHERE Sid='108' LIMIT 1 [2020-12-30 22:17:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2020-12-30 22:17:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:17:47] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2020-12-30 22:17:47] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2020-12-30 22:20:16] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '192.168.0.114', '9', '' ) [2020-12-30 22:20:16] UPDATE admin SET logined=2 WHERE id='' LIMIT 1 [2020-12-30 22:20:47] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '192.168.0.114', '9', '' ) [2020-12-30 22:20:47] UPDATE admin SET logined=2 WHERE id='' LIMIT 1 [2020-12-30 22:31:04] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '1', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:04] UPDATE sales SET logined=2 WHERE Sid='1' LIMIT 1 [2020-12-30 22:31:28] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:28] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:31:35] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:35] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:31:45] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:45] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:31:47] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:47] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:31:55] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:55] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:31:59] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:31:59] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:32:00] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:32:00] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1 [2020-12-30 22:32:01] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '', '42.200.71.168', '9', '2' ) [2020-12-30 22:32:01] UPDATE sales SET logined=2 WHERE Sid='' LIMIT 1