[2019-05-30 09:26:23] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 09:26:23', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 09:26:23] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 09:26:23',73,'192.168.31.178',1,2) [2019-05-30 09:26:23] UPDATE sales SET lastlogindate='2019-05-30 09:26:23' WHERE Sid='73' LIMIT 1 [2019-05-30 09:26:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 09:26:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 09:26:25] UPDATE sales SET lastlogindate='2019-05-30 09:26:25' WHERE Sid='73' LIMIT 1 [2019-05-30 09:26:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 09:26:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 09:26:29] UPDATE sales SET lastlogindate='2019-05-30 09:26:29' WHERE Sid='73' LIMIT 1 [2019-05-30 09:26:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:26:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 09:26:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 09:26: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)) [2019-05-30 09:26: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)) [2019-05-30 09:27:42] UPDATE sales SET lastlogindate='2019-05-30 09:27:42' WHERE Sid='73' LIMIT 1 [2019-05-30 09:27:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:27:42] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 09:27:42] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 09:27:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 09:27: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)) [2019-05-30 09:27: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)) [2019-05-30 10:54:05] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 10:54:05', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:05] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 10:54:05',73,'192.168.31.178',1,2) [2019-05-30 10:54:05] UPDATE sales SET lastlogindate='2019-05-30 10:54:05' WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:54:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:54:06] UPDATE sales SET lastlogindate='2019-05-30 10:54:06' WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:06] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:54:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:54:09] UPDATE sales SET lastlogindate='2019-05-30 10:54:09' WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:54:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:54:09] 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)) [2019-05-30 10:54: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)) [2019-05-30 10:54:45] UPDATE sales SET lastlogindate='2019-05-30 10:54:45' WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:54:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:54:46] 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)) [2019-05-30 10:54:46] 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)) [2019-05-30 10:54:59] UPDATE sales SET lastlogindate='2019-05-30 10:54:59' WHERE Sid='73' LIMIT 1 [2019-05-30 10:54:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:54:59] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:55:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:55: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)) [2019-05-30 10:55: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)) [2019-05-30 10:55:15] UPDATE sales SET lastlogindate='2019-05-30 10:55:15' WHERE Sid='73' LIMIT 1 [2019-05-30 10:55:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:55:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:55:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:55:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:55: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)) [2019-05-30 10:55: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)) [2019-05-30 10:57:36] UPDATE sales SET lastlogindate='2019-05-30 10:57:36' WHERE Sid='73' LIMIT 1 [2019-05-30 10:57:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:57:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 10:57:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 10:57:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 10:57: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)) [2019-05-30 10:57: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)) [2019-05-30 11:00:03] UPDATE sales SET lastlogindate='2019-05-30 11:00:03' WHERE Sid='73' LIMIT 1 [2019-05-30 11:00:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:00:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:00:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:00:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:00: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)) [2019-05-30 11:00: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)) [2019-05-30 11:00:47] UPDATE sales SET lastlogindate='2019-05-30 11:00:47' WHERE Sid='73' LIMIT 1 [2019-05-30 11:00:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:00:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:00:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:00:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:00: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)) [2019-05-30 11: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)) [2019-05-30 11:01:23] UPDATE sales SET lastlogindate='2019-05-30 11:01:23' WHERE Sid='73' LIMIT 1 [2019-05-30 11:01:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:01:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:01:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:01:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:01:24] 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)) [2019-05-30 11:01:24] 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)) [2019-05-30 11:02:44] UPDATE sales SET lastlogindate='2019-05-30 11:02:44' WHERE Sid='73' LIMIT 1 [2019-05-30 11:02:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:02:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:02:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:02:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11: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)) [2019-05-30 11: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)) [2019-05-30 11:04:49] UPDATE sales SET lastlogindate='2019-05-30 11:04:49' WHERE Sid='73' LIMIT 1 [2019-05-30 11:04:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:04:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:04:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:04:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:04:49] 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)) [2019-05-30 11:04: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)) [2019-05-30 11:12:55] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 11:12:55', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 11:12:55] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 11:12:55',73,'192.168.31.178',1,2) [2019-05-30 11:12:55] UPDATE sales SET lastlogindate='2019-05-30 11:12:55' WHERE Sid='73' LIMIT 1 [2019-05-30 11:12:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:12:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:12:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:12:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:12:56] UPDATE sales SET lastlogindate='2019-05-30 11:12:56' WHERE Sid='73' LIMIT 1 [2019-05-30 11:12:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:12:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11: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)) [2019-05-30 11:12:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:12:59] UPDATE sales SET lastlogindate='2019-05-30 11:12:59' WHERE Sid='73' LIMIT 1 [2019-05-30 11:12:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:12:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:12:59] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:13:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:13: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)) [2019-05-30 11:13: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)) [2019-05-30 11:13:28] UPDATE sales SET lastlogindate='2019-05-30 11:13:28' WHERE Sid='73' LIMIT 1 [2019-05-30 11:13:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:13:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:13:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:13:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:13: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)) [2019-05-30 11:13: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)) [2019-05-30 11:14:02] UPDATE sales SET lastlogindate='2019-05-30 11:14:02' WHERE Sid='73' LIMIT 1 [2019-05-30 11:14:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:14:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:14:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:14:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:14:02] 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)) [2019-05-30 11:14:02] 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)) [2019-05-30 11:14:12] UPDATE sales SET lastlogindate='2019-05-30 11:14:12' WHERE Sid='73' LIMIT 1 [2019-05-30 11:14:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:14:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 11:14:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 11:14:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 11:14: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)) [2019-05-30 11:14: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)) [2019-05-30 12:08:00] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 12:08:00', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 12:08:00] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 12:08:00',73,'192.168.31.178',1,2) [2019-05-30 12:08:00] UPDATE sales SET lastlogindate='2019-05-30 12:08:00' WHERE Sid='73' LIMIT 1 [2019-05-30 12:08:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 12:08:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 12:08:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 12:08:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 12:08:01] UPDATE sales SET lastlogindate='2019-05-30 12:08:01' WHERE Sid='73' LIMIT 1 [2019-05-30 12:08:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 12:08:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 12:08:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 12:08:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 13:08:29] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 13:08:29', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 13:08:29] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 13:08:29',73,'192.168.31.178',1,2) [2019-05-30 13:08:29] UPDATE sales SET lastlogindate='2019-05-30 13:08:29' WHERE Sid='73' LIMIT 1 [2019-05-30 13:08:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:08:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:08:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 13:08:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 13:08:30] UPDATE sales SET lastlogindate='2019-05-30 13:08:30' WHERE Sid='73' LIMIT 1 [2019-05-30 13:08:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:08:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:08:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 13:08:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 13:53:23] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 13:53:23', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 13:53:23] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 13:53:23',73,'192.168.31.178',1,2) [2019-05-30 13:53:23] UPDATE sales SET lastlogindate='2019-05-30 13:53:23' WHERE Sid='73' LIMIT 1 [2019-05-30 13:53:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:53:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:53:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 13:53:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 13:53:24] UPDATE sales SET lastlogindate='2019-05-30 13:53:24' WHERE Sid='73' LIMIT 1 [2019-05-30 13:53:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:53:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 13:53:24] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 13:53:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 14:24:49] UPDATE sales SET login_ip='192.168.31.36', lastlogindate='2019-05-30 14:24:49', logined=1 WHERE Sid='90' LIMIT 1 [2019-05-30 14:24:49] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 14:24:49',90,'192.168.31.36',1,2) [2019-05-30 14:24:49] UPDATE sales SET lastlogindate='2019-05-30 14:24:49' WHERE Sid='90' LIMIT 1 [2019-05-30 14:24:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:24:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:24:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 14:24:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 14:24:50] UPDATE sales SET lastlogindate='2019-05-30 14:24:50' WHERE Sid='90' LIMIT 1 [2019-05-30 14:24:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:24:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:24:50] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 14:24:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 14:47:37] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 14:47:37', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 14:47:37] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 14:47:37',73,'192.168.31.178',1,2) [2019-05-30 14:47:37] UPDATE sales SET lastlogindate='2019-05-30 14:47:37' WHERE Sid='73' LIMIT 1 [2019-05-30 14:47:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:47:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:47:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 14:47:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 14:47:38] UPDATE sales SET lastlogindate='2019-05-30 14:47:38' WHERE Sid='73' LIMIT 1 [2019-05-30 14:47:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:47:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 14:47:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 14:47:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:04:00] UPDATE sales SET login_ip='192.168.31.178', lastlogindate='2019-05-30 15:04:00', logined=1 WHERE Sid='73' LIMIT 1 [2019-05-30 15:04:00] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 15:04:00',73,'192.168.31.178',1,2) [2019-05-30 15:04:00] UPDATE sales SET lastlogindate='2019-05-30 15:04:00' WHERE Sid='73' LIMIT 1 [2019-05-30 15:04:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:04:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:04:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:04:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:04:01] UPDATE sales SET lastlogindate='2019-05-30 15:04:01' WHERE Sid='73' LIMIT 1 [2019-05-30 15:04:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:04:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:04:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:04:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:25:24] UPDATE sales SET lastlogindate='2019-05-30 15:25:24' WHERE Sid='73' LIMIT 1 [2019-05-30 15:25:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:25:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:25:24] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:25:25] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:25:25] 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)) [2019-05-30 15:25:25] 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)) [2019-05-30 15:26:32] UPDATE sales SET lastlogindate='2019-05-30 15:26:32' WHERE Sid='73' LIMIT 1 [2019-05-30 15:26:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:26:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:26:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:26:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:26: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)) [2019-05-30 15:26: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)) [2019-05-30 15:28:12] UPDATE sales SET lastlogindate='2019-05-30 15:28:12' WHERE Sid='73' LIMIT 1 [2019-05-30 15:28:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:28:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:28:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:28:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:28: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)) [2019-05-30 15:28: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)) [2019-05-30 15:53:45] UPDATE sales SET login_ip='192.168.31.199', lastlogindate='2019-05-30 15:53:45', logined=1 WHERE Sid='1' LIMIT 1 [2019-05-30 15:53:45] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 15:53:45',1,'192.168.31.199',1,2) [2019-05-30 15:53:45] UPDATE sales SET lastlogindate='2019-05-30 15:53:45' WHERE Sid='1' LIMIT 1 [2019-05-30 15:53:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:45] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:53:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:53:48] UPDATE sales SET lastlogindate='2019-05-30 15:53:48' WHERE Sid='1' LIMIT 1 [2019-05-30 15:53:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:53:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:53:54] UPDATE sales SET lastlogindate='2019-05-30 15:53:54' WHERE Sid='1' LIMIT 1 [2019-05-30 15:53:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:53:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 15:53:58] UPDATE sales SET lastlogindate='2019-05-30 15:53:58' WHERE Sid='1' LIMIT 1 [2019-05-30 15:53:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 15:53:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 15:53:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 16:08:02] UPDATE sales SET lastlogindate='2019-05-30 16:08:02' WHERE Sid='1' LIMIT 1 [2019-05-30 16:08:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:08:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:08:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 16:08:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 16:08: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)) [2019-05-30 16:08: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)) [2019-05-30 16:13:27] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '90', '192.168.31.36', '9', '2' ) [2019-05-30 16:13:27] UPDATE sales SET logined=2 WHERE Sid='90' LIMIT 1 [2019-05-30 16:13:36] UPDATE sales SET login_ip='192.168.31.36', lastlogindate='2019-05-30 16:13:36', logined=1 WHERE Sid='90' LIMIT 1 [2019-05-30 16:13:36] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 16:13:36',90,'192.168.31.36',1,2) [2019-05-30 16:13:36] UPDATE sales SET lastlogindate='2019-05-30 16:13:36' WHERE Sid='90' LIMIT 1 [2019-05-30 16:13:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:13:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:13:36] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 16:13:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 16:13:37] UPDATE sales SET lastlogindate='2019-05-30 16:13:37' WHERE Sid='90' LIMIT 1 [2019-05-30 16:13:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:13:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 16:13:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 16:13:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 17:15:38] UPDATE sales SET lastlogindate='2019-05-30 17:15:38' WHERE Sid='90' LIMIT 1 [2019-05-30 17:15:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 17:15:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 17:15:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 17:15:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 17:15:41] UPDATE admin SET login_ip='' WHERE id='90' LIMIT 1 [2019-05-30 17:15:41] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '90', '192.168.31.36', '9', '2' ) [2019-05-30 18:05:46] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '1', '192.168.31.199', '9', '2' ) [2019-05-30 18:05:46] UPDATE sales SET logined=2 WHERE Sid='1' LIMIT 1 [2019-05-30 18:05:56] UPDATE sales SET login_ip='192.168.31.199', lastlogindate='2019-05-30 18:05:56', logined=1 WHERE Sid='1' LIMIT 1 [2019-05-30 18:05:56] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 18:05:56',1,'192.168.31.199',1,2) [2019-05-30 18:05:56] UPDATE sales SET lastlogindate='2019-05-30 18:05:56' WHERE Sid='1' LIMIT 1 [2019-05-30 18:05:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:05:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:05:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 18:05:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 18:05:57] UPDATE sales SET lastlogindate='2019-05-30 18:05:57' WHERE Sid='1' LIMIT 1 [2019-05-30 18:05:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:05:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:05:57] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 18:05:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 18:59:04] UPDATE sales SET lastlogindate='2019-05-30 18:59:04' WHERE Sid='1' LIMIT 1 [2019-05-30 18:59:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 18:59:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 18:59: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)) [2019-05-30 18:59: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)) [2019-05-30 18:59:32] UPDATE sales SET lastlogindate='2019-05-30 18:59:32' WHERE Sid='1' LIMIT 1 [2019-05-30 18:59:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:32] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 18:59:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 18:59: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)) [2019-05-30 18:59: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)) [2019-05-30 18:59:47] UPDATE sales SET lastlogindate='2019-05-30 18:59:47' WHERE Sid='1' LIMIT 1 [2019-05-30 18:59:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 18:59:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 18:59:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 18:59: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)) [2019-05-30 18:59: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)) [2019-05-30 19:15:30] UPDATE sales SET lastlogindate='2019-05-30 19:15:30' WHERE Sid='1' LIMIT 1 [2019-05-30 19:15:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:15:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:15:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:15:31] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:15: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)) [2019-05-30 19:15: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)) [2019-05-30 19:16:47] UPDATE sales SET lastlogindate='2019-05-30 19:16:47' WHERE Sid='1' LIMIT 1 [2019-05-30 19:16:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:16:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:16:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:16:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:16:48] UPDATE project SET `Pdate`='2018-07-11',`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`='2019-05-30',`Pbexdate1`='2019-05-30',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='16',`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`='嘉華商場',`Pflat`='149',`Pfloor`='B',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='38',`PBDcarea`=NULL,`PBDsarea`='90',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='6',`PBDlandscape`=NULL,`PBDdecorating`='***1-1-2019 會加管理費*** 發展商 : 房屋署 入伙日期 : 1979年 單位數目 : 506伙 管理公司 : TEL 23483184 FAX 27724323 保安室 : TEL 27759779 法團: 27090433 首次出售時大約折扣率：免補地價 ********凶宅******** 油塘中心5G3 1985年 女子吊頸 ，1988年 多重受傷致命',`PBDdescription`='ALSO 137,138,114 149+114 做緊小廚子$17500租(每間)合共$35000 137+138 做緊打冷打$17500租(每間)合共$35000 4間鋪合共$70000租,同一個租客 租約2022年到期,要連租約買.不可俾租客知業主賣鋪',`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`='77',`Cid`=NULL,`Oid`=NULL,`PBDsources`='4',`Prpice`=NULL,`Poremarkmulti`='|2019-05-30 19:16:45::2::1::康誠JERRY比600萬||2018-07-25 16:10:22::2::82::租約2022年到期,要連租約買.不可俾租客知業主賣鋪||2018-07-10 22:43:52::2::77::* OS 嘉華商場B149,B114,$10M,OPEN BY RICKY 3%, ADD TEL 2%|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`='10000000',`Prent`=NULL,`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2018-07-10 22:43:53',`Pmodifydate`='2019-05-30 19:16:48',`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`='黃小姐####::(手提)92818283',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`=NULL WHERE Pid=6752 [2019-05-30 19:16:48] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('6752','2019-05-30 19:16:48','1','2','1','Popay,Pbpay,Poexdate1,Pbexdate1,Poremarkmulti') [2019-05-30 19:16:48] DELETE FROM projectalert WHERE PAPid='6752' && PAadmin='1' && PAtype='2' && PAalert=1 [2019-05-30 19:16:49] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-30 19:16:49',1,'192.168.31.199',3,'project','樓盤︰油塘/住宅 - 油塘中心 座: 嘉華商場, 單位: 149, 層: B, 地段編號: *',6752,2) [2019-05-30 19:16:49] UPDATE projectshare SET Pname='' WHERE Pid=6752 [2019-05-30 19:16:49] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=6752 [2019-05-30 19:16:49] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=6752 [2019-05-30 19:16:49] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-30 19:16:49] UPDATE project SET Pstatus=2 WHERE Pid=6752 [2019-05-30 19:16:49] UPDATE project SET Pstatus2=2 WHERE Pid=6752 [2019-05-30 19:16:49] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-30 19:16:49] UPDATE sales SET lastlogindate='2019-05-30 19:16:49' WHERE Sid='1' LIMIT 1 [2019-05-30 19:16:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:16:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:16:49] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:16:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:16: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)) [2019-05-30 19:16: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)) [2019-05-30 19:44:04] UPDATE sales SET login_ip='192.168.31.13', lastlogindate='2019-05-30 19:44:04', logined=1 WHERE Sid='77' LIMIT 1 [2019-05-30 19:44:04] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-30 19:44:04',77,'192.168.31.13',1,2) [2019-05-30 19:44:04] UPDATE sales SET lastlogindate='2019-05-30 19:44:04' WHERE Sid='77' LIMIT 1 [2019-05-30 19:44:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:44:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:44:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:44:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:44:06] UPDATE sales SET lastlogindate='2019-05-30 19:44:06' WHERE Sid='77' LIMIT 1 [2019-05-30 19:44:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:44:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:44:06] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:44:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:45:02] UPDATE sales SET lastlogindate='2019-05-30 19:45:02' WHERE Sid='77' LIMIT 1 [2019-05-30 19:45:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:45:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 19:45:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 19:45:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 19:45: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)) [2019-05-30 19:45: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)) [2019-05-30 20:08:09] UPDATE sales SET lastlogindate='2019-05-30 20:08:09' WHERE Sid='77' LIMIT 1 [2019-05-30 20:08:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:08:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:08:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:08:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:08: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)) [2019-05-30 20:08: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)) [2019-05-30 20:11:58] UPDATE sales SET lastlogindate='2019-05-30 20:11:58' WHERE Sid='77' LIMIT 1 [2019-05-30 20:11:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:11:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:11:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:11:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:11: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)) [2019-05-30 20:11: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)) [2019-05-30 20:22:28] UPDATE sales SET lastlogindate='2019-05-30 20:22:28' WHERE Sid='77' LIMIT 1 [2019-05-30 20:22:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:22:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20: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)) [2019-05-30 20:22:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20: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)) [2019-05-30 20: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)) [2019-05-30 20:23:41] UPDATE sales SET lastlogindate='2019-05-30 20:23:41' WHERE Sid='77' LIMIT 1 [2019-05-30 20:23:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:23:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20: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)) [2019-05-30 20:23:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:23: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)) [2019-05-30 20:23: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)) [2019-05-30 20:25:04] UPDATE sales SET lastlogindate='2019-05-30 20:25:04' WHERE Sid='77' LIMIT 1 [2019-05-30 20:25:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:25:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:25:04] UPDATE project SET `Pdate`='2018-09-20',`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`='2019-04-13',`Pbexdate1`='2019-04-13',`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`='01',`Pfloor`='20',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`='617',`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`=NULL,`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`='3',`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`='|2019-05-30 20:25:02::2::77::已售||2019-01-21 10:19:09::2::73::億林 STEVE SD $6.60M||2018-12-20 16:52:03::2::1::億林有盤||2018-09-25 20:47:18::2::83::JERRY 話$740萬||2018-09-13 11:57:56::2::84::放售720万，康诚JERRY\'coop OS OPEN BY LISA 3% TEL 2%.|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`='6600000',`Prent`=NULL,`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`=NULL,`Pexdate3`=NULL,`Pcreatedate`='2018-09-13 11:58:11',`Pmodifydate`='2019-05-30 20:25:04',`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####::(手提)69333318',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`=NULL WHERE Pid=7193 [2019-05-30 20:25:04] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('7193','2019-05-30 20:25:04','77','2','1','Poremarkmulti') [2019-05-30 20:25:04] DELETE FROM projectalert WHERE PAPid='7193' && PAadmin='77' && PAtype='2' && PAalert=1 [2019-05-30 20:25:04] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-30 20:25:04',77,'192.168.31.13',3,'project','樓盤︰藍田 - 康田苑 座: B, 單位: 01, 層: 20, 地段編號: ',7193,2) [2019-05-30 20:25:04] UPDATE projectshare SET Pname='' WHERE Pid=7193 [2019-05-30 20:25:04] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=7193 [2019-05-30 20:25:04] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=7193 [2019-05-30 20:25:04] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-30 20:25:04] UPDATE project SET Pstatus=2 WHERE Pid=7193 [2019-05-30 20:25:04] UPDATE project SET Pstatus2=2 WHERE Pid=7193 [2019-05-30 20:25:04] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-30 20:25:04] UPDATE sales SET lastlogindate='2019-05-30 20:25:04' WHERE Sid='77' LIMIT 1 [2019-05-30 20:25:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:25:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:25: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)) [2019-05-30 20:25: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)) [2019-05-30 20:25:27] UPDATE sales SET lastlogindate='2019-05-30 20:25:27' WHERE Sid='77' LIMIT 1 [2019-05-30 20:25:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:27] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:25:27] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:25:27] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:25: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)) [2019-05-30 20:25: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)) [2019-05-30 20:26:08] UPDATE sales SET lastlogindate='2019-05-30 20:26:08' WHERE Sid='77' LIMIT 1 [2019-05-30 20:26:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:26:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:26:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:26:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:26:09] 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)) [2019-05-30 20:26:09] 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)) [2019-05-30 20:26:47] UPDATE sales SET lastlogindate='2019-05-30 20:26:47' WHERE Sid='77' LIMIT 1 [2019-05-30 20:26:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:26:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:26:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:26:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:26: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)) [2019-05-30 20:26: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)) [2019-05-30 20:27:03] UPDATE sales SET lastlogindate='2019-05-30 20:27:03' WHERE Sid='77' LIMIT 1 [2019-05-30 20:27:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:27:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:27:03] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:27:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:27: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)) [2019-05-30 20:27: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)) [2019-05-30 20:27:58] UPDATE sales SET lastlogindate='2019-05-30 20:27:58' WHERE Sid='77' LIMIT 1 [2019-05-30 20:27:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:27:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:27:58] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:27:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:27: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)) [2019-05-30 20:27: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)) [2019-05-30 20:28:22] UPDATE sales SET lastlogindate='2019-05-30 20:28:22' WHERE Sid='77' LIMIT 1 [2019-05-30 20:28:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:28:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:28:22] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:28:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:28: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)) [2019-05-30 20:28: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)) [2019-05-30 20:36:44] UPDATE sales SET lastlogindate='2019-05-30 20:36:44' WHERE Sid='77' LIMIT 1 [2019-05-30 20:36:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:36:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:36:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:36:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:36: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)) [2019-05-30 20:36: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)) [2019-05-30 20:43:08] UPDATE sales SET lastlogindate='2019-05-30 20:43:08' WHERE Sid='77' LIMIT 1 [2019-05-30 20:43:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:08] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:43:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:43: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)) [2019-05-30 20:43: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)) [2019-05-30 20:43:18] UPDATE sales SET lastlogindate='2019-05-30 20:43:18' WHERE Sid='77' LIMIT 1 [2019-05-30 20:43:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:18] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:18] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:43:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:43:19] UPDATE project SET `Pdate`='2016-08-21',`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`='3',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-04-09',`Pbexdate1`='2019-04-09',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='6',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`='2',`Pextra3`=NULL,`Pextra4`='1',`Pextra5`=NULL,`Pextra6`='2',`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`='A',`Pflat`='03',`Pfloor`='6',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`='253',`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='37',`PBDcarea`='538',`PBDsarea`='469',`PBDinterval`=NULL,`PBDmfees`='630',`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`=NULL,`PBDdecorating`='啟田大廈簡介 發展商 : 合和實業 入伙日期: 05-1979 單位總數: 503 地址/地段: 啟田道61號 物業座數: 2座 所屬校網: 九龍區48號校網 2010/05/27 藍田啟田大廈 B座 老婦,下午2時許,疑從高處墮下,倒臥地上救護員到場證實不治',`PBDdescription`='已賣',`Pcustom`=NULL,`PBDaddress`=NULL,`PBDroom`='2',`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='3',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`='1',`PtmpBid`='1',`PtmpSid`='1',`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`='|2019-05-22 19:17:45::2::1::市場消息成交620萬||2019-05-09 20:25:17::2::1::唔租,只賣||2019-04-23 16:29:19::2::1::KP||2019-04-09 16:40:41::2::73::$16000- / $6.20M , CO-OP WITH HLW JOYCE LEUNG, OPEN FOR RENT AND SELL BY FIONA 3%, ADD TEL BY FIONA 2%||2019-03-13 14:48:55::2::83::封盤||2019-03-01 19:54:53::2::1::3月7日先可睇||2019-02-09 15:05:25::2::1::OS OR $550萬/短租$13000, 可約睇 , CO-OP JERRY||2017-05-20 16:26:25::2::1::RENT OUT||2016-11-23 16:18:15::2::1::JERRY 比盤$13000 ,有匙||2016-11-05 14:36:36::2::1::香港物業DAVID放$13800|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`='6200000',`Prent`='16000',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`=NULL,`Pexdate3`=NULL,`Pcreatedate`='2016-08-14 19:06:03',`Pmodifydate`='2019-05-30 20:43:19',`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`='00',`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`='HLW JOYCE LEUNG####::(手提)90588908||CO-OP JERRY####::(手提)69333318',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`=NULL WHERE Pid=253 [2019-05-30 20:43:19] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`PAalert`,`other`) VALUE ('253','2019-05-30 20:43:19','77','2','1','2','樓盤資料') [2019-05-30 20:43:19] DELETE FROM projectalert WHERE PAPid='253' && PAadmin='77' && PAtype='2' && PAalert=1 [2019-05-30 20:43:19] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-30 20:43:19',77,'192.168.31.13',3,'project','樓盤︰藍田 - 啟田大廈 座: A, 單位: 03, 層: 6, 地段編號: ',253,2) [2019-05-30 20:43:19] UPDATE projectshare SET Pname='' WHERE Pid=253 [2019-05-30 20:43:19] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=253 [2019-05-30 20:43:19] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=253 [2019-05-30 20:43:19] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-30 20:43:19] UPDATE project SET Pstatus=2 WHERE Pid=253 [2019-05-30 20:43:19] UPDATE project SET Pstatus2=2 WHERE Pid=253 [2019-05-30 20:43:19] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-30 20:43:19] UPDATE sales SET lastlogindate='2019-05-30 20:43:19' WHERE Sid='77' LIMIT 1 [2019-05-30 20:43:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:43:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:43:20] 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)) [2019-05-30 20:43:20] 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)) [2019-05-30 20:43:28] UPDATE sales SET lastlogindate='2019-05-30 20:43:28' WHERE Sid='77' LIMIT 1 [2019-05-30 20:43:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:29] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:43:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:43:33] UPDATE sales SET lastlogindate='2019-05-30 20:43:33' WHERE Sid='77' LIMIT 1 [2019-05-30 20:43:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:43:33] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:43:34] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:49:38] UPDATE sales SET lastlogindate='2019-05-30 20:49:38' WHERE Sid='77' LIMIT 1 [2019-05-30 20:49:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:49:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-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)) [2019-05-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)) [2019-05-30 20:49: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)) [2019-05-30 20:49: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)) [2019-05-30 20:49:42] UPDATE sales SET lastlogindate='2019-05-30 20:49:42' WHERE Sid='77' LIMIT 1 [2019-05-30 20:49:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:49:42] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 20:49:42] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 20:49:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 20:49: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)) [2019-05-30 20:49: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)) [2019-05-30 21:00:04] UPDATE sales SET lastlogindate='2019-05-30 21:00:04' WHERE Sid='77' LIMIT 1 [2019-05-30 21:00:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:00:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:00:04] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:00:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:00:46] UPDATE sales SET lastlogindate='2019-05-30 21:00:46' WHERE Sid='77' LIMIT 1 [2019-05-30 21:00:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:00:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:00:46] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:00:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:00: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)) [2019-05-30 21:00: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)) [2019-05-30 21:00:54] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰新界/深井、青山公路(屯門段) - 上源 座: 2A, 單位: A, 層: 12, 地段編號: *', '8325', '2' ) [2019-05-30 21:01:01] UPDATE sales SET lastlogindate='2019-05-30 21:01:01' WHERE Sid='77' LIMIT 1 [2019-05-30 21:01:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:01:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:01:15] UPDATE sales SET lastlogindate='2019-05-30 21:01:15' WHERE Sid='77' LIMIT 1 [2019-05-30 21:01:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:15] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:01:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:01:23] UPDATE sales SET lastlogindate='2019-05-30 21:01:23' WHERE Sid='77' LIMIT 1 [2019-05-30 21:01:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:01:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:01:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:01: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)) [2019-05-30 21:01: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)) [2019-05-30 21:07:14] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰藍田 - 康柏苑 座: E, 單位: 05, 層: 34, 地段編號: *', '4300', '2' ) [2019-05-30 21:07:15] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰藍田 - 康柏苑 座: E, 單位: 05, 層: 34, 地段編號: *', '4300', '2' ) [2019-05-30 21:10:27] UPDATE sales SET lastlogindate='2019-05-30 21:10:27' WHERE Sid='77' LIMIT 1 [2019-05-30 21:10:27] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:10:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-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)) [2019-05-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)) [2019-05-30 21:10:43] UPDATE sales SET lastlogindate='2019-05-30 21:10:43' WHERE Sid='77' LIMIT 1 [2019-05-30 21:10:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:10:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:10:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:10:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:10: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)) [2019-05-30 21:10: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)) [2019-05-30 21:10:56] UPDATE sales SET lastlogindate='2019-05-30 21:10:56' WHERE Sid='77' LIMIT 1 [2019-05-30 21:10:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:10:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:10:56] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:10:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:11:06] UPDATE sales SET lastlogindate='2019-05-30 21:11:06' WHERE Sid='77' LIMIT 1 [2019-05-30 21:11:06] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:11:06] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:11:06] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:11:06] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:11:07] 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)) [2019-05-30 21:11:07] 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)) [2019-05-30 21:11:24] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰藍田 - 康柏苑 座: F, 單位: 01, 層: 21, 地段編號: *', '8170', '2' ) [2019-05-30 21:13:33] UPDATE sales SET lastlogindate='2019-05-30 21:13:33' WHERE Sid='77' LIMIT 1 [2019-05-30 21:13:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:33] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:13:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:13:39] UPDATE sales SET lastlogindate='2019-05-30 21:13:39' WHERE Sid='77' LIMIT 1 [2019-05-30 21:13:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:39] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:13:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:13:52] UPDATE sales SET lastlogindate='2019-05-30 21:13:52' WHERE Sid='77' LIMIT 1 [2019-05-30 21:13:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:13:52] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:13:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:13: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)) [2019-05-30 21:13: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)) [2019-05-30 21:16:02] UPDATE sales SET lastlogindate='2019-05-30 21:16:02' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:02] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:11] UPDATE sales SET lastlogindate='2019-05-30 21:16:11' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16: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)) [2019-05-30 21:16: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)) [2019-05-30 21:16:16] UPDATE sales SET lastlogindate='2019-05-30 21:16:16' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:16] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:19] UPDATE sales SET lastlogindate='2019-05-30 21:16:19' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:19] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:20] 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)) [2019-05-30 21:16:20] 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)) [2019-05-30 21:16:30] UPDATE sales SET lastlogindate='2019-05-30 21:16:30' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:44] UPDATE sales SET lastlogindate='2019-05-30 21:16:44' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:44] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:47] UPDATE sales SET lastlogindate='2019-05-30 21:16:47' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:47] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:16:55] UPDATE sales SET lastlogindate='2019-05-30 21:16:55' WHERE Sid='77' LIMIT 1 [2019-05-30 21:16:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:16:55] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:16:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:18:12] UPDATE sales SET lastlogindate='2019-05-30 21:18:12' WHERE Sid='77' LIMIT 1 [2019-05-30 21:18:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:18:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:18:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:18:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:18: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)) [2019-05-30 21:18: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)) [2019-05-30 21:19:30] UPDATE sales SET lastlogindate='2019-05-30 21:19:30' WHERE Sid='77' LIMIT 1 [2019-05-30 21:19:30] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:19:30] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:19:30] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:19:30] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:19: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)) [2019-05-30 21:19: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)) [2019-05-30 21:20:12] UPDATE sales SET lastlogindate='2019-05-30 21:20:12' WHERE Sid='77' LIMIT 1 [2019-05-30 21:20:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:20:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:20:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:20:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:20: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)) [2019-05-30 21:20: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)) [2019-05-30 21:20:29] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - 鯉灣天下 座: , 單位: F, 層: 37, 地段編號: *', '1450', '2' ) [2019-05-30 21:20:30] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - 鯉灣天下 座: , 單位: F, 層: 37, 地段編號: *', '1450', '2' ) [2019-05-30 21:20:30] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - 鯉灣天下 座: , 單位: F, 層: 37, 地段編號: *', '1450', '2' ) [2019-05-30 21:22:23] UPDATE sales SET lastlogindate='2019-05-30 21:22:23' WHERE Sid='77' LIMIT 1 [2019-05-30 21:22:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:22:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:22:23] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:22:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:22: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)) [2019-05-30 21:22: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)) [2019-05-30 21:23:10] UPDATE sales SET lastlogindate='2019-05-30 21:23:10' WHERE Sid='77' LIMIT 1 [2019-05-30 21:23:10] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:23:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:23:11] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:23:11] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:23:11] 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)) [2019-05-30 21:23:11] 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)) [2019-05-30 21:23:53] UPDATE sales SET lastlogindate='2019-05-30 21:23:53' WHERE Sid='77' LIMIT 1 [2019-05-30 21:23:53] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:23:53] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-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)) [2019-05-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)) [2019-05-30 21:23: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)) [2019-05-30 21:23: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)) [2019-05-30 21:24:05] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - PENINSULA EAST 座: 1, 單位: C, 層: 40, 地段編號: *', '8769', '2' ) [2019-05-30 21:24:06] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - PENINSULA EAST 座: 1, 單位: C, 層: 40, 地段編號: *', '8769', '2' ) [2019-05-30 21:26:05] UPDATE sales SET lastlogindate='2019-05-30 21:26:05' WHERE Sid='77' LIMIT 1 [2019-05-30 21:26:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:05] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:26:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:26: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)) [2019-05-30 21:26: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)) [2019-05-30 21:26:25] UPDATE sales SET lastlogindate='2019-05-30 21:26:25' WHERE Sid='77' LIMIT 1 [2019-05-30 21:26:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:25] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:26:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:26: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)) [2019-05-30 21:26: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)) [2019-05-30 21:26:37] UPDATE sales SET lastlogindate='2019-05-30 21:26:37' WHERE Sid='77' LIMIT 1 [2019-05-30 21:26:37] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:37] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:37] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:26:37] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:26: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)) [2019-05-30 21:26: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)) [2019-05-30 21:26:38] UPDATE sales SET lastlogindate='2019-05-30 21:26:38' WHERE Sid='77' LIMIT 1 [2019-05-30 21:26:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:26:38] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:26:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:26: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)) [2019-05-30 21:26: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)) [2019-05-30 21:30:18] UPDATE sales SET lastlogindate='2019-05-30 21:30:18' WHERE Sid='77' LIMIT 1 [2019-05-30 21:30:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:30:18] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:30:18] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:30:18] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:40:56] UPDATE sales SET lastlogindate='2019-05-30 21:40:56' WHERE Sid='77' LIMIT 1 [2019-05-30 21:40:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:40:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21: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)) [2019-05-30 21:40:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:41:02] UPDATE sales SET lastlogindate='2019-05-30 21:41:02' WHERE Sid='77' LIMIT 1 [2019-05-30 21:41:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:41:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21: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)) [2019-05-30 21:41:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:41:07] UPDATE sales SET lastlogindate='2019-05-30 21:41:07' WHERE Sid='77' LIMIT 1 [2019-05-30 21:41:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:41:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:41:07] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:41:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-30 21:41:51] UPDATE sales SET lastlogindate='2019-05-30 21:41:51' WHERE Sid='77' LIMIT 1 [2019-05-30 21:41:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:41:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-30 21:41:51] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-30 21:41:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived))