[2019-05-16 09:11:22] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '87', '192.168.31.95', '9', '2' ) [2019-05-16 09:11:22] UPDATE sales SET logined=2 WHERE Sid='87' LIMIT 1 [2019-05-16 09:11:31] UPDATE sales SET login_ip='192.168.31.95', lastlogindate='2019-05-16 09:11:31', logined=1 WHERE Sid='87' LIMIT 1 [2019-05-16 09:11:31] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 09:11:31',87,'192.168.31.95',1,2) [2019-05-16 09:11:31] UPDATE sales SET lastlogindate='2019-05-16 09:11:31' WHERE Sid='87' LIMIT 1 [2019-05-16 09:11:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11: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-16 09:11:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:11:33] UPDATE sales SET lastlogindate='2019-05-16 09:11:33' WHERE Sid='87' LIMIT 1 [2019-05-16 09:11:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11: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-16 09:11:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:11:44] UPDATE sales SET lastlogindate='2019-05-16 09:11:44' WHERE Sid='87' LIMIT 1 [2019-05-16 09:11:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:11: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-16 09:11:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:11: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-16 09:11: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-16 09:12:00] UPDATE sales SET lastlogindate='2019-05-16 09:12:00' WHERE Sid='87' LIMIT 1 [2019-05-16 09:12:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:12:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:12: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-16 09:12:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:12: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-16 09:12:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:12:32] UPDATE sales SET lastlogindate='2019-05-16 09:12:32' WHERE Sid='87' LIMIT 1 [2019-05-16 09:12:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:12:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 09:12: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-16 09:12:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 09:12: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-16 09:12: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-16 12:07:14] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '87', '192.168.31.95', '9', '2' ) [2019-05-16 12:07:14] UPDATE sales SET logined=2 WHERE Sid='87' LIMIT 1 [2019-05-16 12:07:21] UPDATE sales SET login_ip='192.168.31.95', lastlogindate='2019-05-16 12:07:21', logined=1 WHERE Sid='87' LIMIT 1 [2019-05-16 12:07:21] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 12:07:21',87,'192.168.31.95',1,2) [2019-05-16 12:07:21] UPDATE sales SET lastlogindate='2019-05-16 12:07:21' WHERE Sid='87' LIMIT 1 [2019-05-16 12:07:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07:21] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 12:07:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 12:07:22] UPDATE sales SET lastlogindate='2019-05-16 12:07:22' WHERE Sid='87' LIMIT 1 [2019-05-16 12:07:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07: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-16 12:07:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 12:07:29] UPDATE sales SET lastlogindate='2019-05-16 12:07:29' WHERE Sid='87' LIMIT 1 [2019-05-16 12:07:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 12:07: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-16 12:07:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 12:07: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-16 12:07: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-16 14:33:56] UPDATE sales SET login_ip='192.168.31.36', lastlogindate='2019-05-16 14:33:56', logined=1 WHERE Sid='90' LIMIT 1 [2019-05-16 14:33:56] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 14:33:56',90,'192.168.31.36',1,2) [2019-05-16 14:33:56] UPDATE sales SET lastlogindate='2019-05-16 14:33:56' WHERE Sid='90' LIMIT 1 [2019-05-16 14:33:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:33:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:33: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-16 14:33:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:33:57] UPDATE sales SET lastlogindate='2019-05-16 14:33:57' WHERE Sid='90' LIMIT 1 [2019-05-16 14:33:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:33:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:33: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-16 14:33:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:57:45] UPDATE sales SET login_ip='192.168.31.199', lastlogindate='2019-05-16 14:57:45', logined=1 WHERE Sid='1' LIMIT 1 [2019-05-16 14:57:45] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 14:57:45',1,'192.168.31.199',1,2) [2019-05-16 14:57:45] UPDATE sales SET lastlogindate='2019-05-16 14:57:45' WHERE Sid='1' LIMIT 1 [2019-05-16 14:57:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57: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-16 14:57:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:57:46] UPDATE sales SET lastlogindate='2019-05-16 14:57:46' WHERE Sid='1' LIMIT 1 [2019-05-16 14:57:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57: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-16 14:57:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:57:48] UPDATE sales SET lastlogindate='2019-05-16 14:57:48' WHERE Sid='1' LIMIT 1 [2019-05-16 14:57:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57: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-16 14:57:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:57:50] UPDATE sales SET lastlogindate='2019-05-16 14:57:50' WHERE Sid='1' LIMIT 1 [2019-05-16 14:57:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 14:57: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-16 14:57:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3357.5',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=48 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='6715',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=51 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9500',PSPoutperc='50.00%',PSPoutprice='4750' WHERE PSPid=63 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3600',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=74 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='7200',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=77 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='6250',PSPoutperc='50.00%',PSPoutprice='3125' WHERE PSPid=83 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='17500',PSPoutperc='50.00%',PSPoutprice='5625' WHERE PSPid=86 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9750',PSPoutperc='50.00%',PSPoutprice='4875' WHERE PSPid=115 [2019-05-16 14:57:51] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='24750',PSPoutperc='50.00%',PSPoutprice='7500' WHERE PSPid=109 [2019-05-16 14:57:51] UPDATE salary SET SAnewcom=8750 WHERE Sid=2 AND SAdate='2019-05-01' [2019-05-16 15:53:14] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '87', '192.168.31.95', '9', '2' ) [2019-05-16 15:53:14] UPDATE sales SET logined=2 WHERE Sid='87' LIMIT 1 [2019-05-16 15:53:24] UPDATE sales SET login_ip='192.168.31.95', lastlogindate='2019-05-16 15:53:24', logined=1 WHERE Sid='87' LIMIT 1 [2019-05-16 15:53:24] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 15:53:24',87,'192.168.31.95',1,2) [2019-05-16 15:53:24] UPDATE sales SET lastlogindate='2019-05-16 15:53:24' WHERE Sid='87' LIMIT 1 [2019-05-16 15:53:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15:53:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15: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-16 15: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-16 15:53:25] UPDATE sales SET lastlogindate='2019-05-16 15:53:25' WHERE Sid='87' LIMIT 1 [2019-05-16 15:53:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15:53:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15:53: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-16 15:53:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 15:53:29] UPDATE sales SET lastlogindate='2019-05-16 15:53:29' WHERE Sid='87' LIMIT 1 [2019-05-16 15:53:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15:53:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 15:53: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-16 15:53:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 15:53: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-16 15:53: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-16 16:17:08] UPDATE admin SET login_ip='192.168.31.199', lastlogindate='2019-05-16 16:17:08', logined=1 WHERE id='0' LIMIT 1 [2019-05-16 16:17:08] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 16:17:08',0,'192.168.31.199',1,1) [2019-05-16 16:17:08] UPDATE admin SET lastlogindate='2019-05-16 16:17:08' WHERE id='-1' LIMIT 1 [2019-05-16 16:17:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17: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-16 16:17:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:17:09] UPDATE admin SET lastlogindate='2019-05-16 16:17:09' WHERE id='-1' LIMIT 1 [2019-05-16 16:17:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17: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-16 16:17:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:17:11] UPDATE admin SET lastlogindate='2019-05-16 16:17:11' WHERE id='-1' LIMIT 1 [2019-05-16 16:17:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:12] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 16:17:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:17: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-16 16:17: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-16 16:17:32] UPDATE admin SET lastlogindate='2019-05-16 16:17:32' WHERE id='-1' LIMIT 1 [2019-05-16 16:17:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17: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-16 16:17:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:17:54] UPDATE admin SET lastlogindate='2019-05-16 16:17:54' WHERE id='-1' LIMIT 1 [2019-05-16 16:17:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:17: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-16 16:17:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:18:12] UPDATE admin SET lastlogindate='2019-05-16 16:18:12' WHERE id='-1' LIMIT 1 [2019-05-16 16:18:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:18:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16: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-16 16:18:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:18: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-16 16:18: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-16 16:30:48] UPDATE admin SET lastlogindate='2019-05-16 16:30:48' WHERE id='-1' LIMIT 1 [2019-05-16 16:30:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:30:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:30: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-16 16:30:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:30:49] UPDATE admin SET lastlogindate='2019-05-16 16:30:49' WHERE id='-1' LIMIT 1 [2019-05-16 16:30:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:30:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:30: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-16 16:30:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:36:19] UPDATE admin SET lastlogindate='2019-05-16 16:36:19' WHERE id='-1' LIMIT 1 [2019-05-16 16:36:19] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:36:19] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:36: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-16 16:36:19] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:36:19] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 16:36:19] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:50:57] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '90', '192.168.31.36', '9', '2' ) [2019-05-16 16:50:57] UPDATE sales SET logined=2 WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:07] UPDATE sales SET login_ip='192.168.31.36', lastlogindate='2019-05-16 16:51:07', logined=1 WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:07] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 16:51:07',90,'192.168.31.36',1,2) [2019-05-16 16:51:07] UPDATE sales SET lastlogindate='2019-05-16 16:51:07' WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:07] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51:08] UPDATE sales SET lastlogindate='2019-05-16 16:51:08' WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51:11] UPDATE admin SET lastlogindate='2019-05-16 16:51:11' WHERE id='-1' LIMIT 1 [2019-05-16 16:51:11] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:11] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51: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-16 16:51: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-16 16:51:12] UPDATE admin SET lastlogindate='2019-05-16 16:51:12' WHERE id='-1' LIMIT 1 [2019-05-16 16:51:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51:13] UPDATE sales SET lastlogindate='2019-05-16 16:51:13' WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:13] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:13] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:13] 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-16 16:51:13] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51:26] UPDATE sales SET lastlogindate='2019-05-16 16:51:26' WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:26] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:26] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:26] 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-16 16:51:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:51:48] UPDATE sales SET lastlogindate='2019-05-16 16:51:48' WHERE Sid='90' LIMIT 1 [2019-05-16 16:51:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:51: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-16 16:51:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:52:14] UPDATE admin SET lastlogindate='2019-05-16 16:52:14' WHERE id='-1' LIMIT 1 [2019-05-16 16:52:14] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52:14] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52:14] 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-16 16:52:14] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:52:14] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 16:52:14] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:52:15] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 16:52:22] UPDATE admin SET lastlogindate='2019-05-16 16:52:22' WHERE id='-1' LIMIT 1 [2019-05-16 16:52:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52: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-16 16:52:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:52:22] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES ('2019-05-03',NULL,NULL,NULL,NULL,NULL,'3,500.00','0.00','1750.00',NULL,NULL,NULL,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'2019-05-03','2019-05-03',NULL,NULL,NULL,NULL,'107',NULL,NULL,NULL,NULL,NULL,NULL,'8','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B場','40','A',NULL,'4',NULL,NULL,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,'5',NULL,'B場 (近康華) A層是第一層(最近出口樓層) B層是第二層(要落一層) C場 A層是第一層(最近出口樓層) B層是第二層(要落一層) C層是第三層(要落兩層) D層是第四層(要落三層)','RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'1','73',NULL,NULL,'6',NULL,'|2019-05-04 18:15:54::2::73::更正 : RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 15:57:12::2::73::RENT OUT BY FIONA $3500- FROM 01 MAY 2019 TO 40 APR 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 14:59:41::2::73::$3500 , CO-OP WITH YI LAM MS CHAN, OPEN FOR RENT BY FIONA 3%, ADD TEL BY FIONA 2%|',NULL,NULL,NULL,'3500',NULL,NULL,NULL,NULL,NULL,NULL,'2019-05-16 16:52:22','2019-05-16 16:52:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8602','GRAND HOME',NULL,NULL,NULL,'YI LAM MS CHAN ####::(手提)65762168',NULL,NULL,'1',NULL,NULL,'24') [2019-05-16 16:52:23] UPDATE admin SET lastlogindate='2019-05-16 16:52:23' WHERE id='-1' LIMIT 1 [2019-05-16 16:52:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:52: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-16 16:52:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:52: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-16 16:52: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-16 16:52:23] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 16:55:15] UPDATE sales SET lastlogindate='2019-05-16 16:55:15' WHERE Sid='90' LIMIT 1 [2019-05-16 16:55:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:55:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:55: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-16 16: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-16 16:56:29] UPDATE admin SET lastlogindate='2019-05-16 16:56:29' WHERE id='-1' LIMIT 1 [2019-05-16 16:56:29] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:56:29] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:56: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-16 16:56:29] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57:07] UPDATE admin SET lastlogindate='2019-05-16 16:57:07' WHERE id='-1' LIMIT 1 [2019-05-16 16:57:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:07] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57: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-16 16:57: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-16 16:57:08] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 16:57:15] UPDATE admin SET lastlogindate='2019-05-16 16:57:15' WHERE id='-1' LIMIT 1 [2019-05-16 16:57:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:15] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57:15] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES ('2019-05-03',NULL,NULL,NULL,NULL,NULL,'3,500.00','0.00','1750.00',NULL,NULL,NULL,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'2019-05-03','2019-05-03',NULL,NULL,NULL,NULL,'107',NULL,NULL,NULL,NULL,NULL,NULL,'8','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B場','40','A',NULL,'4',NULL,NULL,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,'5',NULL,'B場 (近康華) A層是第一層(最近出口樓層) B層是第二層(要落一層) C場 A層是第一層(最近出口樓層) B層是第二層(要落一層) C層是第三層(要落兩層) D層是第四層(要落三層)','RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'1','73',NULL,NULL,'6',NULL,'|2019-05-04 18:15:54::2::73::更正 : RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 15:57:12::2::73::RENT OUT BY FIONA $3500- FROM 01 MAY 2019 TO 40 APR 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 14:59:41::2::73::$3500 , CO-OP WITH YI LAM MS CHAN, OPEN FOR RENT BY FIONA 3%, ADD TEL BY FIONA 2%|',NULL,NULL,NULL,'3500',NULL,NULL,NULL,NULL,NULL,NULL,'2019-05-16 16:57:15','2019-05-16 16:57:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8602','GRAND HOME',NULL,NULL,NULL,'YI LAM MS CHAN ####::(手提)65762168',NULL,NULL,'1',NULL,NULL,'24') [2019-05-16 16:57:15] UPDATE admin SET lastlogindate='2019-05-16 16:57:15' WHERE id='-1' LIMIT 1 [2019-05-16 16:57:15] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:15] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57: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-16 16:57: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-16 16:57:16] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 16:57:49] UPDATE admin SET lastlogindate='2019-05-16 16:57:49' WHERE id='-1' LIMIT 1 [2019-05-16 16:57:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57:50] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES ('2019-05-03',NULL,NULL,NULL,NULL,NULL,'3,500.00','0.00','1750.00',NULL,NULL,NULL,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'2019-05-03','2019-05-03',NULL,NULL,NULL,NULL,'107',NULL,NULL,NULL,NULL,NULL,NULL,'8','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B場','40','A',NULL,'4',NULL,NULL,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,'5',NULL,'B場 (近康華) A層是第一層(最近出口樓層) B層是第二層(要落一層) C場 A層是第一層(最近出口樓層) B層是第二層(要落一層) C層是第三層(要落兩層) D層是第四層(要落三層)','RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'1','73',NULL,NULL,'6',NULL,'|2019-05-04 18:15:54::2::73::更正 : RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 15:57:12::2::73::RENT OUT BY FIONA $3500- FROM 01 MAY 2019 TO 40 APR 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 14:59:41::2::73::$3500 , CO-OP WITH YI LAM MS CHAN, OPEN FOR RENT BY FIONA 3%, ADD TEL BY FIONA 2%|',NULL,NULL,NULL,'3500',NULL,NULL,NULL,NULL,NULL,NULL,'2019-05-16 16:57:50','2019-05-16 16:57:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8602','GRAND HOME',NULL,NULL,NULL,'YI LAM MS CHAN ####::(手提)65762168',NULL,NULL,'1',NULL,NULL,'24') [2019-05-16 16:57:50] UPDATE admin SET lastlogindate='2019-05-16 16:57:50' WHERE id='-1' LIMIT 1 [2019-05-16 16:57:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57: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-16 16:57: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-16 16:57:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 16:57:51] UPDATE sales SET lastlogindate='2019-05-16 16:57:51' WHERE Sid='90' LIMIT 1 [2019-05-16 16:57:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:57:55] UPDATE sales SET lastlogindate='2019-05-16 16:57:55' WHERE Sid='90' LIMIT 1 [2019-05-16 16:57:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:57: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-16 16:57:55] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 16:58:04] UPDATE sales SET lastlogindate='2019-05-16 16:58:04' WHERE Sid='90' LIMIT 1 [2019-05-16 16:58:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:58:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 16:58: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-16 16:58:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:02:55] UPDATE sales SET lastlogindate='2019-05-16 17:02:55' WHERE Sid='90' LIMIT 1 [2019-05-16 17:02:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:02:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:02: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-16 17:02:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03:16] UPDATE sales SET lastlogindate='2019-05-16 17:03:16' WHERE Sid='90' LIMIT 1 [2019-05-16 17:03:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03: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-16 17:03:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03: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-16 17:03: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-16 17:03:17] UPDATE sales SET lastlogindate='2019-05-16 17:03:17' WHERE Sid='90' LIMIT 1 [2019-05-16 17:03:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03:17] 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-16 17:03:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03:17] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 17:03:17] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03:56] UPDATE admin SET lastlogindate='2019-05-16 17:03:56' WHERE id='-1' LIMIT 1 [2019-05-16 17:03:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03: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-16 17:03:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03:56] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2019-05-16 17:03:56] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES ('2019-05-03',NULL,NULL,NULL,NULL,NULL,'3,500.00','0.00','1750.00',NULL,NULL,NULL,'8',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',NULL,NULL,'2019-05-03','2019-05-03',NULL,NULL,NULL,NULL,'107',NULL,NULL,NULL,NULL,NULL,NULL,'8','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B場','40','A',NULL,'4',NULL,NULL,NULL,NULL,NULL,'37',NULL,NULL,NULL,NULL,NULL,'5',NULL,'B場 (近康華) A層是第一層(最近出口樓層) B層是第二層(要落一層) C場 A層是第一層(最近出口樓層) B層是第二層(要落一層) C層是第三層(要落兩層) D層是第四層(要落三層)','RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'3',NULL,NULL,NULL,'1','73',NULL,NULL,'6',NULL,'|2019-05-04 18:15:54::2::73::更正 : RENT OUT BY FIONA $3500- FROM 04 MAY 2019 TO 03 MAY 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 15:57:12::2::73::RENT OUT BY FIONA $3500- FROM 01 MAY 2019 TO 40 APR 2021, CO-OP WITH YI LAM MS CHAN||2019-05-04 14:59:41::2::73::$3500 , CO-OP WITH YI LAM MS CHAN, OPEN FOR RENT BY FIONA 3%, ADD TEL BY FIONA 2%|',NULL,NULL,NULL,'3500',NULL,NULL,NULL,NULL,NULL,NULL,'2019-05-16 17:03:56','2019-05-16 17:03:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'8602','GRAND HOME',NULL,NULL,NULL,'YI LAM MS CHAN ####::(手提)65762168',NULL,NULL,'1',NULL,NULL,'93') [2019-05-16 17:03:56] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2019-05-16 17:03:56] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`) VALUE ('8671','2019-05-16 17:03:56','-1','1','1','Prent','','3500') [2019-05-16 17:03:56] UPDATE project SET Pprice_old='2019-05-16 17:03:56::0::3500' WHERE Pid='8671' LIMIT 1 [2019-05-16 17:03:56] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-16 17:03:56',-1,'192.168.31.199',2,'project','項目 : ',8671,'1') [2019-05-16 17:03:57] UPDATE admin SET lastlogindate='2019-05-16 17:03:57' WHERE id='-1' LIMIT 1 [2019-05-16 17:03:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:03: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-16 17:03:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:03:57] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 17:03:57] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:04:32] UPDATE admin SET lastlogindate='2019-05-16 17:04:32' WHERE id='-1' LIMIT 1 [2019-05-16 17:04:32] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04:32] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04: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-16 17:04:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:04:36] UPDATE admin SET lastlogindate='2019-05-16 17:04:36' WHERE id='-1' LIMIT 1 [2019-05-16 17:04:36] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04:36] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04: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-16 17:04:36] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:04:56] UPDATE admin SET lastlogindate='2019-05-16 17:04:56' WHERE id='-1' LIMIT 1 [2019-05-16 17:04:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:04: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-16 17:04:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='6000',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=22 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='12000',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=23 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='59500',PSPoutperc='50.00%',PSPoutprice='23750' WHERE PSPid=104 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='337.5',PSPoutperc='50.00%',PSPoutprice='168.75' WHERE PSPid=31 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='782.5',PSPoutperc='50.00%',PSPoutprice='222.5' WHERE PSPid=38 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1185',PSPoutperc='50.00%',PSPoutprice='592.5' WHERE PSPid=49 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='2370',PSPoutperc='50.00%',PSPoutprice='592.5' WHERE PSPid=52 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='8370',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=40 [2019-05-16 17:04:56] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='9170',PSPoutperc='50.00%',PSPoutprice='400' WHERE PSPid=42 [2019-05-16 17:04:57] UPDATE projectsharepayment SET PSPoutsort='5',PSPoutacc='9770',PSPoutperc='50.00%',PSPoutprice='300' WHERE PSPid=44 [2019-05-16 17:04:57] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3825',PSPoutperc='50.00%',PSPoutprice='1912.5' WHERE PSPid=92 [2019-05-16 17:04:57] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='10625',PSPoutperc='50.00%',PSPoutprice='3400' WHERE PSPid=121 [2019-05-16 17:04:57] UPDATE salary SET SAnewcom=5312.5 WHERE Sid=87 AND SAdate='2019-05-01' [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='6000',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=22 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='12000',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=23 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='59500',PSPoutperc='50.00%',PSPoutprice='23750' WHERE PSPid=104 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='337.5',PSPoutperc='50.00%',PSPoutprice='168.75' WHERE PSPid=31 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='782.5',PSPoutperc='50.00%',PSPoutprice='222.5' WHERE PSPid=38 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1185',PSPoutperc='50.00%',PSPoutprice='592.5' WHERE PSPid=49 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='2370',PSPoutperc='50.00%',PSPoutprice='592.5' WHERE PSPid=52 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='8370',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=40 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='9170',PSPoutperc='50.00%',PSPoutprice='400' WHERE PSPid=42 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='5',PSPoutacc='9770',PSPoutperc='50.00%',PSPoutprice='300' WHERE PSPid=44 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3825',PSPoutperc='50.00%',PSPoutprice='1912.5' WHERE PSPid=92 [2019-05-16 17:05:00] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='10625',PSPoutperc='50.00%',PSPoutprice='3400' WHERE PSPid=121 [2019-05-16 17:05:00] UPDATE salary SET SAnewcom=391.25 WHERE Sid=87 AND SAdate='2019-04-01' [2019-05-16 17:05:02] UPDATE sales SET lastlogindate='2019-05-16 17:05:02' WHERE Sid='90' LIMIT 1 [2019-05-16 17:05:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05: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-16 17:05:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05: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-16 17:05: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-16 17:05:03] UPDATE sales SET lastlogindate='2019-05-16 17:05:03' WHERE Sid='90' LIMIT 1 [2019-05-16 17:05:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05: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-16 17:05:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05: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-16 17:05: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-16 17:05:39] UPDATE admin SET lastlogindate='2019-05-16 17:05:39' WHERE id='-1' LIMIT 1 [2019-05-16 17:05:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:40] 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-16 17:05:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 17:05:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05:47] UPDATE admin SET lastlogindate='2019-05-16 17:05:47' WHERE id='-1' LIMIT 1 [2019-05-16 17:05:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05: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-16 17:05:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05: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-16 17:05: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-16 17:05:50] UPDATE admin SET lastlogindate='2019-05-16 17:05:50' WHERE id='-1' LIMIT 1 [2019-05-16 17:05:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:05: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-16 17:05:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:05: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-16 17:05: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-16 17:05:51] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1750',PSPoutperc='50.00%',PSPoutprice='875' WHERE PSPid=119 [2019-05-16 17:23:54] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '87', '192.168.31.95', '9', '2' ) [2019-05-16 17:23:54] UPDATE sales SET logined=2 WHERE Sid='87' LIMIT 1 [2019-05-16 17:24:45] UPDATE admin SET lastlogindate='2019-05-16 17:24:45' WHERE id='-1' LIMIT 1 [2019-05-16 17:24:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:24:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:24: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-16 17:24:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:24: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-16 17:24: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-16 17:24:45] UPDATE admin SET lastlogindate='2019-05-16 17:24:45' WHERE id='-1' LIMIT 1 [2019-05-16 17:24:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:24:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:24: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-16 17:24:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:24: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-16 17:24: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-16 17:26:19] UPDATE admin SET login_ip='' WHERE id='-1' LIMIT 1 [2019-05-16 17:26:19] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '-1', '192.168.31.199', '9', '1' ) [2019-05-16 17:28:59] UPDATE sales SET login_ip='192.168.31.95', lastlogindate='2019-05-16 17:28:59', logined=1 WHERE Sid='1' LIMIT 1 [2019-05-16 17:28:59] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 17:28:59',1,'192.168.31.95',1,2) [2019-05-16 17:28:59] UPDATE sales SET lastlogindate='2019-05-16 17:28:59' WHERE Sid='1' LIMIT 1 [2019-05-16 17:28:59] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( '2019-05-16 17:27:08', '0', '192.168.31.199', '9', '1' ) [2019-05-16 17:28:59] UPDATE admin SET logined=2 WHERE id='0' LIMIT 1 [2019-05-16 17:28:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:28:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:28: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-16 17:28:59] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:29:00] UPDATE sales SET lastlogindate='2019-05-16 17:29:00' WHERE Sid='1' LIMIT 1 [2019-05-16 17:29:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29: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-16 17:29:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:29:02] UPDATE sales SET lastlogindate='2019-05-16 17:29:02' WHERE Sid='1' LIMIT 1 [2019-05-16 17:29:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29: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-16 17:29:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:29: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-16 17:29: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-16 17:29:52] UPDATE sales SET lastlogindate='2019-05-16 17:29:52' WHERE Sid='1' LIMIT 1 [2019-05-16 17:29:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:29: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-16 17:29:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:29: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-16 17:29: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-16 17:30:00] UPDATE sales SET lastlogindate='2019-05-16 17:30:00' WHERE Sid='90' LIMIT 1 [2019-05-16 17:30:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30: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-16 17:30:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:30:01] UPDATE sales SET lastlogindate='2019-05-16 17:30:01' WHERE Sid='90' LIMIT 1 [2019-05-16 17:30:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 17:30:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:30:03] UPDATE sales SET lastlogindate='2019-05-16 17:30:03' WHERE Sid='90' LIMIT 1 [2019-05-16 17:30:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30: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-16 17:30:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:30:05] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '1', '192.168.31.95', '8', 'project', '樓盤︰藍田 - 康柏苑 座: F, 單位: 01, 層: 21, 地段編號: *', '8170', '2' ) [2019-05-16 17:30:51] UPDATE sales SET lastlogindate='2019-05-16 17:30:51' WHERE Sid='1' LIMIT 1 [2019-05-16 17:30:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:30: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-16 17:30:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:31:08] UPDATE sales SET lastlogindate='2019-05-16 17:31:08' WHERE Sid='1' LIMIT 1 [2019-05-16 17:31:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:31:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:31: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-16 17:31:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:31: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-16 17:31: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-16 17:42:52] UPDATE sales SET lastlogindate='2019-05-16 17:42:52' WHERE Sid='1' LIMIT 1 [2019-05-16 17:42:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:42:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:42: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-16 17:42:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:42: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-16 17:42: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-16 17:44:51] UPDATE sales SET login_ip='192.168.31.198', lastlogindate='2019-05-16 17:44:51', logined=1 WHERE Sid='89' LIMIT 1 [2019-05-16 17:44:51] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 17:44:51',89,'192.168.31.198',1,2) [2019-05-16 17:44:51] UPDATE sales SET lastlogindate='2019-05-16 17:44:51' WHERE Sid='89' LIMIT 1 [2019-05-16 17:44:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:44:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:44: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-16 17:44:51] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:44:51] UPDATE sales SET lastlogindate='2019-05-16 17:44:51' WHERE Sid='89' LIMIT 1 [2019-05-16 17:44:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:44:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:44: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-16 17:44:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:45:02] UPDATE sales SET lastlogindate='2019-05-16 17:45:02' WHERE Sid='89' LIMIT 1 [2019-05-16 17:45:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:45:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17: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-16 17:45:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:45: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-16 17:45: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-16 17:45:43] UPDATE sales SET lastlogindate='2019-05-16 17:45:43' WHERE Sid='89' LIMIT 1 [2019-05-16 17:45:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:45:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:45:43] 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-16 17:45:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:45: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-16 17:45: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-16 17:46:44] UPDATE sales SET lastlogindate='2019-05-16 17:46:44' WHERE Sid='89' LIMIT 1 [2019-05-16 17:46:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:46:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:46: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-16 17:46:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:46: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-16 17:46: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-16 17:46:44] UPDATE sales SET lastlogindate='2019-05-16 17:46:44' WHERE Sid='89' LIMIT 1 [2019-05-16 17:46:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:46:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:46: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-16 17:46:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:46: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-16 17:46: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-16 17:47:38] UPDATE sales SET lastlogindate='2019-05-16 17:47:38' WHERE Sid='90' LIMIT 1 [2019-05-16 17:47:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:47:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17: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-16 17: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-16 17:47:39] UPDATE sales SET lastlogindate='2019-05-16 17:47:39' WHERE Sid='90' LIMIT 1 [2019-05-16 17:47:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:47:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:47: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-16 17:47:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 17:47:44] UPDATE sales SET lastlogindate='2019-05-16 17:47:44' WHERE Sid='90' LIMIT 1 [2019-05-16 17:47:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:47:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 17:47: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-16 17:47:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:08] UPDATE sales SET login_ip='192.168.31.199', lastlogindate='2019-05-16 18:01:08', logined=1 WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:08] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 18:01:08',1,'192.168.31.199',1,2) [2019-05-16 18:01:09] UPDATE sales SET lastlogindate='2019-05-16 18:01:09' WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 18:01:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:09] UPDATE sales SET lastlogindate='2019-05-16 18:01:09' WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:09] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:09] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:09] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 18:01:10] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:22] UPDATE sales SET lastlogindate='2019-05-16 18:01:22' WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01: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-16 18:01:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:25] UPDATE sales SET lastlogindate='2019-05-16 18:01:25' WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:25] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:25] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01: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-16 18:01:26] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3357.5',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=48 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='6715',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=51 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9500',PSPoutperc='50.00%',PSPoutprice='4750' WHERE PSPid=63 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3600',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=74 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='7200',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=77 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='6250',PSPoutperc='50.00%',PSPoutprice='3125' WHERE PSPid=83 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='17500',PSPoutperc='50.00%',PSPoutprice='5625' WHERE PSPid=86 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9750',PSPoutperc='50.00%',PSPoutprice='4875' WHERE PSPid=115 [2019-05-16 18:01:26] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='24750',PSPoutperc='50.00%',PSPoutprice='7500' WHERE PSPid=109 [2019-05-16 18:01:26] UPDATE salary SET SAnewcom=8750 WHERE Sid=2 AND SAdate='2019-05-01' [2019-05-16 18:01:51] UPDATE sales SET lastlogindate='2019-05-16 18:01:51' WHERE Sid='1' LIMIT 1 [2019-05-16 18:01:51] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01:51] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:01: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-16 18:01:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='36000',PSPoutperc='50.00%',PSPoutprice='18000' WHERE PSPid=12 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='85500',PSPoutperc='50.00%',PSPoutprice='24750' WHERE PSPid=34 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='127500',PSPoutperc='50.00%',PSPoutprice='21000' WHERE PSPid=81 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9100',PSPoutperc='50.00%',PSPoutprice='4550' WHERE PSPid=20 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='18200',PSPoutperc='50.00%',PSPoutprice='4550' WHERE PSPid=21 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='27700',PSPoutperc='50.00%',PSPoutprice='4750' WHERE PSPid=62 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='27782.8',PSPoutperc='50.00%',PSPoutprice='41.4' WHERE PSPid=117 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3357.5',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=47 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='6715',PSPoutperc='50.00%',PSPoutprice='1678.75' WHERE PSPid=50 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='35215',PSPoutperc='50.00%',PSPoutprice='14250' WHERE PSPid=32 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='96205',PSPoutperc='50.00%',PSPoutprice='30495' WHERE PSPid=57 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='3600',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=73 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='7200',PSPoutperc='50.00%',PSPoutprice='1800' WHERE PSPid=76 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='6250',PSPoutperc='50.00%',PSPoutprice='3125' WHERE PSPid=82 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='17500',PSPoutperc='50.00%',PSPoutprice='5625' WHERE PSPid=85 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='60500',PSPoutperc='50.00%',PSPoutprice='21500' WHERE PSPid=89 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='82000',PSPoutperc='50.00%',PSPoutprice='10750' WHERE PSPid=98 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9750',PSPoutperc='50.00%',PSPoutprice='4875' WHERE PSPid=114 [2019-05-16 18:01:52] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='24750',PSPoutperc='50.00%',PSPoutprice='7500' WHERE PSPid=108 [2019-05-16 18:01:52] UPDATE salary SET SAnewcom=62000 WHERE Sid=1 AND SAdate='2019-05-01' [2019-05-16 18:03:08] UPDATE sales SET lastlogindate='2019-05-16 18:03:08' WHERE Sid='1' LIMIT 1 [2019-05-16 18:03:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:03:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:03: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-16 18:03:09] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:03: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-16 18:03: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-16 18:16:22] UPDATE sales SET lastlogindate='2019-05-16 18:16:22' WHERE Sid='90' LIMIT 1 [2019-05-16 18:16:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:16:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:16: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-16 18:16:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:16: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-16 18:16: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-16 18:16:33] UPDATE sales SET lastlogindate='2019-05-16 18:16:33' WHERE Sid='90' LIMIT 1 [2019-05-16 18:16:33] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:16:33] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:16: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-16 18:16:33] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:16:44] UPDATE sales SET lastlogindate='2019-05-16 18:16:44' WHERE Sid='90' LIMIT 1 [2019-05-16 18:16:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:16:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18: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-16 18:16:44] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:16: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-16 18:16: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-16 18:17:01] UPDATE sales SET lastlogindate='2019-05-16 18:17:01' WHERE Sid='90' LIMIT 1 [2019-05-16 18:17:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17:01] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 18:17:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:17:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 18:17:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:17:01] UPDATE sales SET lastlogindate='2019-05-16 18:17:01' WHERE Sid='90' LIMIT 1 [2019-05-16 18:17:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17: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-16 18:17:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:17: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-16 18:17: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-16 18:17:41] UPDATE sales SET lastlogindate='2019-05-16 18:17:41' WHERE Sid='90' LIMIT 1 [2019-05-16 18:17:41] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17:41] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17: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-16 18:17:42] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:17:49] UPDATE sales SET lastlogindate='2019-05-16 18:17:49' WHERE Sid='90' LIMIT 1 [2019-05-16 18:17:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:17: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-16 18:17:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:55:04] UPDATE sales SET lastlogindate='2019-05-16 18:55:04' WHERE Sid='1' LIMIT 1 [2019-05-16 18:55:04] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:55:04] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:55: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-16 18:55:04] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:55:08] UPDATE sales SET lastlogindate='2019-05-16 18:55:08' WHERE Sid='1' LIMIT 1 [2019-05-16 18:55:08] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:55:08] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 18:55: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-16 18:55:08] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='53200',PSPoutperc='50.00%',PSPoutprice='26600' WHERE PSPid=61 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='95320',PSPoutperc='50.00%',PSPoutprice='21060' WHERE PSPid=14 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='99320',PSPoutperc='50.00%',PSPoutprice='2000' WHERE PSPid=13 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='104720',PSPoutperc='50.00%',PSPoutprice='2700' WHERE PSPid=102 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='5',PSPoutacc='112145',PSPoutperc='50.00%',PSPoutprice='3712.5' WHERE PSPid=100 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='9000',PSPoutperc='50.00%',PSPoutprice='4500' WHERE PSPid=28 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='18000',PSPoutperc='50.00%',PSPoutprice='4500' WHERE PSPid=29 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='18412.5',PSPoutperc='50.00%',PSPoutprice='206.25' WHERE PSPid=24 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='18825',PSPoutperc='50.00%',PSPoutprice='206.25' WHERE PSPid=26 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='5',PSPoutacc='25237.5',PSPoutperc='50.00%',PSPoutprice='3206.25' WHERE PSPid=30 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='7310',PSPoutperc='50.00%',PSPoutprice='3655' WHERE PSPid=69 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='14620',PSPoutperc='50.00%',PSPoutprice='3655' WHERE PSPid=71 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='20620',PSPoutperc='50.00%',PSPoutprice='3000' WHERE PSPid=65 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='7250',PSPoutperc='50.00%',PSPoutprice='3625' WHERE PSPid=90 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='19750',PSPoutperc='50.00%',PSPoutprice='6250' WHERE PSPid=84 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='42250',PSPoutperc='50.00%',PSPoutprice='11250' WHERE PSPid=87 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='4',PSPoutacc='94450',PSPoutperc='50.00%',PSPoutprice='26100' WHERE PSPid=88 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='5',PSPoutacc='103950',PSPoutperc='50.00%',PSPoutprice='4750' WHERE PSPid=95 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='337.5',PSPoutperc='50.00%',PSPoutprice='168.75' WHERE PSPid=111 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='47637.5',PSPoutperc='50.00%',PSPoutprice='23650' WHERE PSPid=112 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='3',PSPoutacc='94937.5',PSPoutperc='50.00%',PSPoutprice='23650' WHERE PSPid=113 [2019-05-16 18:55:09] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='1717.2',PSPoutperc='50.00%',PSPoutprice='858.6' WHERE PSPid=118 [2019-05-16 18:55:09] UPDATE salary SET SAnewcom=58387.5 WHERE Sid=83 AND SAdate='2019-05-01' [2019-05-16 19:10:44] UPDATE sales SET lastlogindate='2019-05-16 19:10:44' WHERE Sid='1' LIMIT 1 [2019-05-16 19:10:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:10:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19: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-16 19: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-16 19:10:45] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='7837.5',PSPoutperc='15.00%',PSPoutprice='1175.63' WHERE PSPid=25 [2019-05-16 19:10:45] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='15675',PSPoutperc='18.62%',PSPoutprice='1459.38' WHERE PSPid=27 [2019-05-16 19:10:45] UPDATE projectsharepayment SET PSPoutsort='1',PSPoutacc='8750',PSPoutperc='15.00%',PSPoutprice='1312.5' WHERE PSPid=93 [2019-05-16 19:10:45] UPDATE projectsharepayment SET PSPoutsort='2',PSPoutacc='16750',PSPoutperc='19.22%',PSPoutprice='1537.5' WHERE PSPid=94 [2019-05-16 19:10:45] UPDATE salary SET SAnewcom=2850 WHERE Sid=89 AND SAdate='2019-05-01' [2019-05-16 19:16:09] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '89', '192.168.31.198', '9', '2' ) [2019-05-16 19:16:09] UPDATE sales SET logined=2 WHERE Sid='89' LIMIT 1 [2019-05-16 19:16:20] UPDATE sales SET login_ip='192.168.31.198', lastlogindate='2019-05-16 19:16:20', logined=1 WHERE Sid='89' LIMIT 1 [2019-05-16 19:16:20] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 19:16:20',89,'192.168.31.198',1,2) [2019-05-16 19:16:20] UPDATE sales SET lastlogindate='2019-05-16 19:16:20' WHERE Sid='89' LIMIT 1 [2019-05-16 19:16:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16:21] 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-16 19:16:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:16:21] UPDATE sales SET lastlogindate='2019-05-16 19:16:21' WHERE Sid='89' LIMIT 1 [2019-05-16 19:16:21] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16:21] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16:21] 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-16 19:16:21] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:16:24] UPDATE sales SET lastlogindate='2019-05-16 19:16:24' WHERE Sid='89' LIMIT 1 [2019-05-16 19:16:24] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16:24] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:16: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-16 19:16:24] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:16: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-16 19:16: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-16 19:17:16] UPDATE sales SET lastlogindate='2019-05-16 19:17:16' WHERE Sid='89' LIMIT 1 [2019-05-16 19:17:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:17:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:17: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-16 19:17:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:17:16] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:17:16] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:17:34] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '89', '192.168.31.198', '8', 'project', '樓盤︰藍田 - 康田苑 座: B, 單位: 05, 層: 29, 地段編號: ', '8536', '2' ) [2019-05-16 19:19:49] UPDATE sales SET lastlogindate='2019-05-16 19:19:49' WHERE Sid='89' LIMIT 1 [2019-05-16 19:19:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:19:49] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:19: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-16 19:19:49] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:19: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-16 19:19:49] 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-16 19:22:45] UPDATE sales SET lastlogindate='2019-05-16 19:22:45' WHERE Sid='1' LIMIT 1 [2019-05-16 19:22:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:22:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:22: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-16 19:22:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:22: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-16 19:22: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-16 19:22:56] UPDATE sales SET lastlogindate='2019-05-16 19:22:56' WHERE Sid='1' LIMIT 1 [2019-05-16 19:22:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:22:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:22: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-16 19:22:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:22:56] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:22:56] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:22:59] UPDATE sales SET lastlogindate='2019-05-16 19:22:59' WHERE Sid='1' LIMIT 1 [2019-05-16 19:22:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:23:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:23:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:23:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:23: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-16 19:23: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-16 19:23:00] UPDATE sales SET lastlogindate='2019-05-16 19:23:00' WHERE Sid='1' LIMIT 1 [2019-05-16 19:23:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:23:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:23:00] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:23:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:23:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:23:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27:39] UPDATE sales SET lastlogindate='2019-05-16 19:27:39' WHERE Sid='1' LIMIT 1 [2019-05-16 19:27:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27: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-16 19:27:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27:39] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:27:39] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27:40] UPDATE sales SET lastlogindate='2019-05-16 19:27:40' WHERE Sid='1' LIMIT 1 [2019-05-16 19:27:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27:40] 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-16 19:27:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:27:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27:44] UPDATE sales SET lastlogindate='2019-05-16 19:27:44' WHERE Sid='1' LIMIT 1 [2019-05-16 19:27:44] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27:44] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:27: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-16 19:27:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:27: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-16 19:27: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-16 19:28:40] UPDATE sales SET lastlogindate='2019-05-16 19:28:40' WHERE Sid='89' LIMIT 1 [2019-05-16 19:28:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:28:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:28:40] 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-16 19:28:40] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:28:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:28:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:28:40] UPDATE sales SET lastlogindate='2019-05-16 19:28:40' WHERE Sid='89' LIMIT 1 [2019-05-16 19:28:40] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:28:40] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:28: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-16 19:28:41] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:28: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-16 19:28: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-16 19:31:57] UPDATE sales SET lastlogindate='2019-05-16 19:31:57' WHERE Sid='89' LIMIT 1 [2019-05-16 19:31:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:31:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:31: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-16 19:31:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:31: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-16 19:31: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-16 19:31:58] UPDATE sales SET lastlogindate='2019-05-16 19:31:58' WHERE Sid='89' LIMIT 1 [2019-05-16 19:31:58] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:31:58] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:31: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-16 19:31:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:31: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-16 19:31: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-16 19:32:16] UPDATE sales SET lastlogindate='2019-05-16 19:32:16' WHERE Sid='89' LIMIT 1 [2019-05-16 19:32:16] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:16] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32: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-16 19:32:16] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32: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-16 19:32: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-16 19:32:31] UPDATE sales SET lastlogindate='2019-05-16 19:32:31' WHERE Sid='1' LIMIT 1 [2019-05-16 19:32:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:31] 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-16 19:32:31] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32:31] INSERT INTO project (`Pdate`,`Pname`,`Poname`,`Poremark`,`Pbname`,`Pbremark`,`Pprice`,`Popay`,`Pbpay`,`Premark`,`Bid`,`Sid`,`Pstatus`,`Porecedate`,`Potype`,`Popaytype`,`Popaydate`,`Popaymethod`,`Pobankno`,`Popayremark`,`Pbrecedate`,`Pbtype`,`Pbpaytype`,`Pbpaydate`,`Pbpaymethod`,`Pbbankno`,`Pbpayremark`,`Ptype`,`Pexdate1`,`Pexdate2`,`Poexdate1`,`Pbexdate1`,`Polawyer`,`Pblawyer`,`Pocheque`,`Pbcheque`,`BDid`,`Poadminid`,`Pbadminid`,`Poreceived`,`Pbreceived`,`Pocooperate`,`Pbcooperate`,`Pstatus2`,`Pstepcount`,`Polawyermore`,`Pblawyermore`,`Pextra1`,`Pextra2`,`Pextra3`,`Pextra4`,`Pextra5`,`Pextra6`,`Pextra7`,`Pextra8`,`Pextra9`,`Pextra10`,`Pextra11`,`Pname2`,`Pflat`,`Pfloor`,`Pcar`,`Plivestatus`,`Pkeyno`,`Pnumber`,`Potel`,`Poctel`,`Pomtel`,`Plocid`,`PBDcarea`,`PBDsarea`,`PBDinterval`,`PBDmfees`,`PBDrfees`,`PBDtype`,`PBDlandscape`,`PBDdecorating`,`PBDdescription`,`Pcustom`,`PBDaddress`,`PBDroom`,`PBDhall`,`PBDsuite`,`PBDcarspac`,`PBDmaidroom`,`PBDtoilet`,`PBDstorerooms`,`PBDkitchen`,`PBDwindowsill`,`PBDrooftop`,`PBDgarden`,`PBDstatus`,`PBDexclusive`,`PBDlistings`,`PBDkey`,`PtmpBid`,`PtmpSid`,`Cid`,`Oid`,`PBDsources`,`Prpice`,`Poremarkmulti`,`Pocontact`,`Pocontacttel`,`Ppprice`,`Prent`,`Ppprice_s`,`Ppprice_t`,`Prent_s`,`Prent_t`,`Plot_no`,`Pexdate3`,`Pcreatedate`,`Pmodifydate`,`Pmobile_status`,`Pmobile_pprice`,`Pmobile_pprice_s`,`Pmobile_pprice_t`,`Pmobiler_rent`,`Pmobiler_rent_s`,`Pmobiler_rent_t`,`Pmobile_top`,`PBDterrace`,`PBDwork_platform`,`PBDcarspac_no`,`PBDkey_no`,`PBDmobiler_desc`,`PBDyoutube`,`Pmobile_sno`,`PBDopeninterval`,`PBDceiling`,`PBDdoorwidth`,`PBDpoweredby`,`PBDgas`,`Prpice2`,`PgroupID`,`Pcompany`,`Pbrname`,`Pbrtel`,`Pdirection`,`Pocontactmulti`,`Pccontactmulti`,`Pcremarkmulti`,`Pttype`,`Pdcontactmulti`,`Pdremarkmulti`,`Padnumber`) VALUES (NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B','08','29',NULL,'3',NULL,NULL,NULL,NULL,NULL,'38',NULL,'400',NULL,NULL,NULL,'1','企理裝修','出售期數： 出售剩餘居屋單位第5期及第6期 落成年份： 2002 入伙日期 : E座2009年12月、BCD座2010年8月 樓宇類型： 新十字型 樓宇座數： 4 樓宇名稱： B沃美閣 C漾美閣 D溢美閣 E泳美閣 單位數目： 1480 單位建築面積 (平方米)： 49 - 79 單位實用面積 (平方米)： 37 - 59 首次推出售價 ($)： 984900 - 2295500 業主立案法團： 已成立 區域物業管理辦事處 / 分區租約事務： 房屋署東九龍(八)區租約事務管理處 九龍坪石邨玉石樓一樓 電話：2323 8121 傳真：2351 4367 屋苑物業管理： 創毅物業服務顧問有限公司 Tel : 27270882 保安室 : 34176096 C座漾美閣座頭：27270893 停車場管理： 新昌管理集團有限公司 香港九龍觀塘偉業街107-109號新昌中心 電話: 2579 8313 傳真: 2751 8784 電郵: hacp@synergis.com.hk 屋苑網站： - 首次出售時大約折扣率：33% ******凶宅******* 2011年12月16日 一個女人星期六清晨，在油塘油翠苑E座泳美閣住所，用皮帶吊頸自殺，送院搶救證實不治，死者姓黃（卅六歲），生前與家人居於油塘油翠苑一單位。昨凌晨四時許，黃女的胞弟（卅二歲）返回住所時，驚見胞姊於雜物房內，用皮帶吊頸自殺，將她救下及報警求助。 2012年11月23日 油翠苑C座漾美閣一名老翁，下午1時許，被人發現在大廈梯間吊頸自殺，報警昏迷送院，搶救不治。 2014年06月05日 油翠苑男墮樓亡無留低遺書 凌晨近2時，油塘油翠苑B座沃美閣，一名年約60多歲男子，從11樓單位大廳墮下，倒卧地下。救護員到場證實已經死亡。警方沒有撿獲遺書，調查懷疑因病厭世，事件無可疑。','新收油翠苑B2908 實用400\" 綠表510萬，，業主唔鐘意其他人打電話比佢，指定要我一個人聯絡，如同事有客約睇樓聯絡我Free Help',NULL,NULL,'2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,'1','1',NULL,NULL,'6',NULL,'|2019-05-16 19:32:29::2::1::OS 綠表510萬，企理裝修，可約睇樓，業主唔鐘意其他人打電話比佢，指定要我一個人聯絡，如同事有客約睇樓聯絡我Free Help|',NULL,NULL,NULL,'510',NULL,NULL,NULL,NULL,'*',NULL,'2019-05-16 19:32:31','2019-05-16 19:32:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'陳生##搵GARY聯絡##',NULL,NULL,NULL,NULL,NULL,'94') [2019-05-16 19:32:31] UPDATE setting SET propertyadno=propertyadno+1 WHERE id=1 LIMIT 1 [2019-05-16 19:32:31] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`f1_title`,`f1_a`,`f1_b`) VALUE ('8672','2019-05-16 19:32:31','1','2','1','Prent','','510') [2019-05-16 19:32:31] UPDATE project SET Pprice_old='2019-05-16 19:32:31::0::510' WHERE Pid='8672' LIMIT 1 [2019-05-16 19:32:31] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-16 19:32:31',1,'192.168.31.199',2,'project','項目 : ',8672,'2') [2019-05-16 19:32:31] UPDATE sales SET lastlogindate='2019-05-16 19:32:31' WHERE Sid='1' LIMIT 1 [2019-05-16 19:32:31] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:31] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:31] 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-16 19:32:32] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32:32] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 19:32:32] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32:49] UPDATE sales SET lastlogindate='2019-05-16 19:32:49' WHERE Sid='1' LIMIT 1 [2019-05-16 19:32:49] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32: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-16 19:32:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32:50] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='1',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-05-16',`Pbexdate1`='2019-05-16',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='14',`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`='08',`Pfloor`='29',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='38',`PBDcarea`=NULL,`PBDsarea`='400',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`='企理裝修',`PBDdecorating`='出售期數： 出售剩餘居屋單位第5期及第6期 落成年份： 2002 入伙日期 : E座2009年12月、BCD座2010年8月 樓宇類型： 新十字型 樓宇座數： 4 樓宇名稱： B沃美閣 C漾美閣 D溢美閣 E泳美閣 單位數目： 1480 單位建築面積 (平方米)： 49 - 79 單位實用面積 (平方米)： 37 - 59 首次推出售價 ($)： 984900 - 2295500 業主立案法團： 已成立 區域物業管理辦事處 / 分區租約事務： 房屋署東九龍(八)區租約事務管理處 九龍坪石邨玉石樓一樓 電話：2323 8121 傳真：2351 4367 屋苑物業管理： 創毅物業服務顧問有限公司 Tel : 27270882 保安室 : 34176096 C座漾美閣座頭：27270893 停車場管理： 新昌管理集團有限公司 香港九龍觀塘偉業街107-109號新昌中心 電話: 2579 8313 傳真: 2751 8784 電郵: hacp@synergis.com.hk 屋苑網站： - 首次出售時大約折扣率：33% ******凶宅******* 2011年12月16日 一個女人星期六清晨，在油塘油翠苑E座泳美閣住所，用皮帶吊頸自殺，送院搶救證實不治，死者姓黃（卅六歲），生前與家人居於油塘油翠苑一單位。昨凌晨四時許，黃女的胞弟（卅二歲）返回住所時，驚見胞姊於雜物房內，用皮帶吊頸自殺，將她救下及報警求助。 2012年11月23日 油翠苑C座漾美閣一名老翁，下午1時許，被人發現在大廈梯間吊頸自殺，報警昏迷送院，搶救不治。 2014年06月05日 油翠苑男墮樓亡無留低遺書 凌晨近2時，油塘油翠苑B座沃美閣，一名年約60多歲男子，從11樓單位大廳墮下，倒卧地下。救護員到場證實已經死亡。警方沒有撿獲遺書，調查懷疑因病厭世，事件無可疑。',`PBDdescription`=NULL,`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`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='1',`PtmpSid`='1',`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`='|2019-05-16 19:32:29::2::1::OS 綠表510萬，企理裝修，可約睇樓，業主唔鐘意其他人打電話比佢，指定要我一個人聯絡，如同事有客約睇樓聯絡我Free Help|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='510',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2019-05-16 19:32:31',`Pmodifydate`='2019-05-16 19:32:50',`Pmobile_status`=NULL,`Pmobile_pprice`=NULL,`Pmobile_pprice_s`=NULL,`Pmobile_pprice_t`=NULL,`Pmobiler_rent`=NULL,`Pmobiler_rent_s`=NULL,`Pmobiler_rent_t`=NULL,`Pmobile_top`=NULL,`PBDterrace`=NULL,`PBDwork_platform`=NULL,`PBDcarspac_no`=NULL,`PBDkey_no`=NULL,`PBDmobiler_desc`=NULL,`PBDyoutube`=NULL,`Pmobile_sno`=NULL,`PBDopeninterval`=NULL,`PBDceiling`=NULL,`PBDdoorwidth`=NULL,`PBDpoweredby`=NULL,`PBDgas`=NULL,`Prpice2`=NULL,`PgroupID`=NULL,`Pcompany`=NULL,`Pbrname`=NULL,`Pbrtel`=NULL,`Pdirection`=NULL,`Pocontactmulti`='陳生##搵GARY聯絡##',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='94' WHERE Pid=8672 [2019-05-16 19:32:50] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('8672','2019-05-16 19:32:50','1','2','1','Popay,Pbpay,Poexdate1,Pbexdate1') [2019-05-16 19:32:50] DELETE FROM projectalert WHERE PAPid='8672' && PAadmin='1' && PAtype='2' && PAalert=1 [2019-05-16 19:32:50] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-16 19:32:50',1,'192.168.31.199',3,'project','樓盤︰油塘/住宅 - 油翠苑 座: B, 單位: 08, 層: 29, 地段編號: *',8672,2) [2019-05-16 19:32:50] UPDATE projectshare SET Pname='' WHERE Pid=8672 [2019-05-16 19:32:50] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=8672 [2019-05-16 19:32:50] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=8672 [2019-05-16 19:32:50] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-16 19:32:50] UPDATE project SET Pstatus=2 WHERE Pid=8672 [2019-05-16 19:32:50] UPDATE project SET Pstatus2=2 WHERE Pid=8672 [2019-05-16 19:32:50] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-16 19:32:50] UPDATE sales SET lastlogindate='2019-05-16 19:32:50' WHERE Sid='1' LIMIT 1 [2019-05-16 19:32:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32: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-16 19:32:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32: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-16 19:32:51] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:32:54] UPDATE sales SET lastlogindate='2019-05-16 19:32:54' WHERE Sid='1' LIMIT 1 [2019-05-16 19:32:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:32: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-16 19:32:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:33:12] INSERT INTO `message`(`Mdate`, `Madmin`, `Madmintype`, `Mcontent`, `Mstatus`) VALUES ( NOW(), '1', '2', '* OS 油翠苑B2908 實用400\" 綠表510萬', '1' ) [2019-05-16 19:33:12] UPDATE sales SET lastlogindate='2019-05-16 19:33:12' WHERE Sid='1' LIMIT 1 [2019-05-16 19:33:12] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:33:12] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:33: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-16 19:33:12] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:35:45] UPDATE sales SET lastlogindate='2019-05-16 19:35:45' WHERE Sid='1' LIMIT 1 [2019-05-16 19:35:45] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:35:45] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:35: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-16 19:35:45] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:35: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-16 19:35: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-16 19:43:46] UPDATE sales SET lastlogindate='2019-05-16 19:43:46' WHERE Sid='1' LIMIT 1 [2019-05-16 19:43:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:43:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:43: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-16 19:43:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:43:47] UPDATE project SET `Pdate`=NULL,`Pname`=NULL,`Poname`=NULL,`Poremark`=NULL,`Pbname`=NULL,`Pbremark`=NULL,`Pprice`='0.00',`Popay`='0.00',`Pbpay`='0.00',`Premark`=NULL,`Bid`=NULL,`Sid`=NULL,`Pstatus`=NULL,`Potype`=NULL,`Popaytype`=NULL,`Popaydate`=NULL,`Popaymethod`=NULL,`Pobankno`=NULL,`Popayremark`=NULL,`Pbtype`=NULL,`Pbpaytype`=NULL,`Pbpaydate`=NULL,`Pbpaymethod`=NULL,`Pbbankno`=NULL,`Pbpayremark`=NULL,`Ptype`='1',`Pexdate1`=NULL,`Pexdate2`=NULL,`Poexdate1`='2019-05-16',`Pbexdate1`='2019-05-16',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='14',`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`='08',`Pfloor`='29',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='38',`PBDcarea`=NULL,`PBDsarea`='400',`PBDinterval`=NULL,`PBDmfees`=NULL,`PBDrfees`=NULL,`PBDtype`='1',`PBDlandscape`='企理裝修 , 折扣率33.8%',`PBDdecorating`='出售期數： 出售剩餘居屋單位第5期及第6期 落成年份： 2002 入伙日期 : E座2009年12月、BCD座2010年8月 樓宇類型： 新十字型 樓宇座數： 4 樓宇名稱： B沃美閣 C漾美閣 D溢美閣 E泳美閣 單位數目： 1480 單位建築面積 (平方米)： 49 - 79 單位實用面積 (平方米)： 37 - 59 首次推出售價 ($)： 984900 - 2295500 業主立案法團： 已成立 區域物業管理辦事處 / 分區租約事務： 房屋署東九龍(八)區租約事務管理處 九龍坪石邨玉石樓一樓 電話：2323 8121 傳真：2351 4367 屋苑物業管理： 創毅物業服務顧問有限公司 Tel : 27270882 保安室 : 34176096 C座漾美閣座頭：27270893 停車場管理： 新昌管理集團有限公司 香港九龍觀塘偉業街107-109號新昌中心 電話: 2579 8313 傳真: 2751 8784 電郵: hacp@synergis.com.hk 屋苑網站： - 首次出售時大約折扣率：33% ******凶宅******* 2011年12月16日 一個女人星期六清晨，在油塘油翠苑E座泳美閣住所，用皮帶吊頸自殺，送院搶救證實不治，死者姓黃（卅六歲），生前與家人居於油塘油翠苑一單位。昨凌晨四時許，黃女的胞弟（卅二歲）返回住所時，驚見胞姊於雜物房內，用皮帶吊頸自殺，將她救下及報警求助。 2012年11月23日 油翠苑C座漾美閣一名老翁，下午1時許，被人發現在大廈梯間吊頸自殺，報警昏迷送院，搶救不治。 2014年06月05日 油翠苑男墮樓亡無留低遺書 凌晨近2時，油塘油翠苑B座沃美閣，一名年約60多歲男子，從11樓單位大廳墮下，倒卧地下。救護員到場證實已經死亡。警方沒有撿獲遺書，調查懷疑因病厭世，事件無可疑。',`PBDdescription`='可約睇樓 當初市值$1,389,100 當時購入價$2,098,900',`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`='1',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='1',`PtmpSid`='1',`Cid`=NULL,`Oid`=NULL,`PBDsources`='6',`Prpice`=NULL,`Poremarkmulti`='|2019-05-16 19:43:45::2::1::傢俬都可以比埋買家||2019-05-16 19:40:27::2::1::業主要求3個月成交期||2019-05-16 19:39:51::2::1::証已申請,預計月尾會收到||2019-05-16 19:38:51::2::1::當初市值$1,389,100 當時購入價$2,098,900 , 折扣率33.8%||2019-05-16 19:32:29::2::1::OS 綠表510萬，企理裝修，可約睇樓，業主唔鐘意其他人打電話比佢，指定要我一個人聯絡，如同事有客約睇樓聯絡我Free Help|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`=NULL,`Prent`='510',`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2019-05-16 19:32:31',`Pmodifydate`='2019-05-16 19:43:47',`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`='陳生##搵GARY聯絡##',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`='94' WHERE Pid=8672 [2019-05-16 19:43:47] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('8672','2019-05-16 19:43:47','1','2','1','Poremarkmulti') [2019-05-16 19:43:47] DELETE FROM projectalert WHERE PAPid='8672' && PAadmin='1' && PAtype='2' && PAalert=1 [2019-05-16 19:43:47] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-16 19:43:47',1,'192.168.31.199',3,'project','樓盤︰油塘/住宅 - 油翠苑 座: B, 單位: 08, 層: 29, 地段編號: *',8672,2) [2019-05-16 19:43:47] UPDATE projectshare SET Pname='' WHERE Pid=8672 [2019-05-16 19:43:47] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=8672 [2019-05-16 19:43:47] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=8672 [2019-05-16 19:43:47] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-16 19:43:47] UPDATE project SET Pstatus=2 WHERE Pid=8672 [2019-05-16 19:43:47] UPDATE project SET Pstatus2=2 WHERE Pid=8672 [2019-05-16 19:43:47] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-16 19:43:47] UPDATE sales SET lastlogindate='2019-05-16 19:43:47' WHERE Sid='1' LIMIT 1 [2019-05-16 19:43:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:43:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 19:43: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-16 19:43:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 19:43: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-16 19:43: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-16 20:00:22] UPDATE sales SET login_ip='192.168.31.13', lastlogindate='2019-05-16 20:00:22', logined=1 WHERE Sid='77' LIMIT 1 [2019-05-16 20:00:22] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 20:00:22',77,'192.168.31.13',1,2) [2019-05-16 20:00:22] UPDATE sales SET lastlogindate='2019-05-16 20:00:22' WHERE Sid='77' LIMIT 1 [2019-05-16 20:00:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:00:22] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:00: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-16 20:00:22] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:00:23] UPDATE sales SET lastlogindate='2019-05-16 20:00:23' WHERE Sid='77' LIMIT 1 [2019-05-16 20:00:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:00:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:00: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-16 20:00:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:01:23] UPDATE sales SET lastlogindate='2019-05-16 20:01:23' WHERE Sid='77' LIMIT 1 [2019-05-16 20:01:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:01:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20: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-16 20: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-16 20: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-16 20: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-16 20:01:37] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - 油翠苑 座: B, 單位: 08, 層: 29, 地段編號: *', '8672', '2' ) [2019-05-16 20:12:50] UPDATE sales SET lastlogindate='2019-05-16 20:12:50' WHERE Sid='77' LIMIT 1 [2019-05-16 20:12:50] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:12:50] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:12: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-16 20:12:50] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:12: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-16 20:12: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-16 20:12:52] UPDATE sales SET lastlogindate='2019-05-16 20:12:52' WHERE Sid='77' LIMIT 1 [2019-05-16 20:12:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:12:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:12: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-16 20:12:52] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:12: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-16 20:12: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-16 20:13:28] UPDATE sales SET lastlogindate='2019-05-16 20:13:28' WHERE Sid='77' LIMIT 1 [2019-05-16 20:13:28] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:13:28] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:13: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-16 20:13:28] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:13:28] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:13:28] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:19:18] UPDATE sales SET lastlogindate='2019-05-16 20:19:18' WHERE Sid='77' LIMIT 1 [2019-05-16 20:19:18] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:19:18] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:19: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-16 20:19:18] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:19:18] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:19:18] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:20:07] UPDATE sales SET lastlogindate='2019-05-16 20:20:07' WHERE Sid='77' LIMIT 1 [2019-05-16 20:20:07] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:20:07] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:20: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-16 20:20:07] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:20: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-16 20:20: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-16 20:20:43] UPDATE sales SET lastlogindate='2019-05-16 20:20:43' WHERE Sid='77' LIMIT 1 [2019-05-16 20:20:43] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:20:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:20:43] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:20:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:20:43] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:20:43] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:21:02] UPDATE sales SET lastlogindate='2019-05-16 20:21:02' WHERE Sid='77' LIMIT 1 [2019-05-16 20:21:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:21:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:21: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-16 20:21:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:21: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-16 20:21: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-16 20:50:39] UPDATE sales SET lastlogindate='2019-05-16 20:50:39' WHERE Sid='77' LIMIT 1 [2019-05-16 20:50:39] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:50:39] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:50: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-16 20:50:39] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:50:40] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:50:40] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:52:03] UPDATE sales SET lastlogindate='2019-05-16 20:52:03' WHERE Sid='77' LIMIT 1 [2019-05-16 20:52:03] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:52:03] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:52: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-16 20:52:03] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:52: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-16 20:52: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-16 20:54:55] UPDATE sales SET lastlogindate='2019-05-16 20:54:55' WHERE Sid='77' LIMIT 1 [2019-05-16 20:54:55] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:54:55] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:54: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-16 20:54:56] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:55:57] UPDATE sales SET lastlogindate='2019-05-16 20:55:57' WHERE Sid='77' LIMIT 1 [2019-05-16 20:55:57] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:55:57] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:55: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-16 20:55:58] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:55: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-16 20:55: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-16 20:55:59] UPDATE sales SET lastlogindate='2019-05-16 20:55:59' WHERE Sid='77' LIMIT 1 [2019-05-16 20:55:59] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:55:59] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:55: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-16 20:56:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:56:00] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:56:00] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:56:01] UPDATE sales SET lastlogindate='2019-05-16 20:56:01' WHERE Sid='77' LIMIT 1 [2019-05-16 20:56:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:56:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:56: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-16 20:56:02] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:56: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-16 20:56: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-16 20:56:17] UPDATE sales SET lastlogindate='2019-05-16 20:56:17' WHERE Sid='77' LIMIT 1 [2019-05-16 20:56:17] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:56:17] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:56:17] 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-16 20:56:17] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:56:17] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:56:18] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:56:34] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `field`, `remark`, `r`, `type` ) VALUES ( NOW(), '77', '192.168.31.13', '8', 'project', '樓盤︰油塘/住宅 - PENINSULA EAST 座: , 單位: P11, 層: 5, 地段編號: *', '7405', '2' ) [2019-05-16 20:58:25] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '90', '192.168.31.36', '9', '2' ) [2019-05-16 20:58:25] UPDATE sales SET logined=2 WHERE Sid='90' LIMIT 1 [2019-05-16 20:58:46] UPDATE sales SET login_ip='192.168.31.36', lastlogindate='2019-05-16 20:58:46', logined=1 WHERE Sid='90' LIMIT 1 [2019-05-16 20:58:46] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`type`) VALUES ('2019-05-16 20:58:46',90,'192.168.31.36',1,2) [2019-05-16 20:58:46] UPDATE sales SET lastlogindate='2019-05-16 20:58:46' WHERE Sid='90' LIMIT 1 [2019-05-16 20:58:46] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:58:46] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:58: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-16 20:58:46] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:58:47] UPDATE sales SET lastlogindate='2019-05-16 20:58:47' WHERE Sid='90' LIMIT 1 [2019-05-16 20:58:47] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:58:47] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:58: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-16 20:58:47] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59:00] UPDATE sales SET lastlogindate='2019-05-16 20:59:00' WHERE Sid='90' LIMIT 1 [2019-05-16 20:59:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59: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-16 20:59:00] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:59:01] UPDATE project SET Pstatus2=2 WHERE (Pstatus2 IS NULL OR Pstatus2 NOT IN (2,4,8)) AND (IF(Pbpay IS NULL,0,Pbpay)!=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59:01] UPDATE sales SET lastlogindate='2019-05-16 20:59:01' WHERE Sid='90' LIMIT 1 [2019-05-16 20:59:01] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59:01] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59: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-16 20:59:01] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59:01] UPDATE project SET Pstatus=2 WHERE (Pstatus IS NULL OR Pstatus NOT IN (2,4,8)) AND (IF(Popay IS NULL,0,Popay)!=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 20:59: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-16 20:59:22] UPDATE sales SET lastlogindate='2019-05-16 20:59:22' WHERE Sid='77' LIMIT 1 [2019-05-16 20:59:22] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59: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-16 20:59:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59:23] UPDATE project SET `Pdate`='2018-10-19',`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-16',`Pbexdate1`='2019-05-16',`Polawyer`=NULL,`Pblawyer`=NULL,`Pocheque`=NULL,`Pbcheque`=NULL,`BDid`='175',`Poadminid`=NULL,`Pbadminid`=NULL,`Pocooperate`=NULL,`Pbcooperate`=NULL,`Pstatus2`=NULL,`Pstepcount`='1',`Polawyermore`=NULL,`Pblawyermore`=NULL,`Pextra1`=NULL,`Pextra2`=NULL,`Pextra3`=NULL,`Pextra4`=NULL,`Pextra5`=NULL,`Pextra6`=NULL,`Pextra7`=NULL,`Pextra8`=NULL,`Pextra9`=NULL,`Pextra10`=NULL,`Pextra11`=NULL,`Pname2`=NULL,`Pflat`='P11',`Pfloor`='5',`Pcar`=NULL,`Plivestatus`='3',`Pkeyno`=NULL,`Pnumber`=NULL,`Potel`=NULL,`Poctel`=NULL,`Pomtel`=NULL,`Plocid`='38',`PBDcarea`=NULL,`PBDsarea`=NULL,`PBDinterval`=NULL,`PBDmfees`='4.15',`PBDrfees`=NULL,`PBDtype`='5',`PBDlandscape`=NULL,`PBDdecorating`='地址: 崇耀街9號 入伙日期: 8/2017 單位數目: 128 層數: 32 每層伙數: 4 所屬校網: 九龍區48號校網 管理公司: 夏利文物業管理有限公司 寵物 : NO',`PBDdescription`='月租5000，11月底生約',`Pcustom`=NULL,`PBDaddress`='崇耀街9號',`PBDroom`=NULL,`PBDhall`=NULL,`PBDsuite`=NULL,`PBDcarspac`=NULL,`PBDmaidroom`=NULL,`PBDtoilet`=NULL,`PBDstorerooms`=NULL,`PBDkitchen`=NULL,`PBDwindowsill`=NULL,`PBDrooftop`=NULL,`PBDgarden`=NULL,`PBDstatus`='7',`PBDexclusive`=NULL,`PBDlistings`=NULL,`PBDkey`=NULL,`PtmpBid`='1',`PtmpSid`='73',`Cid`=NULL,`Oid`=NULL,`PBDsources`='4',`Prpice`='2200000',`Poremarkmulti`='|2019-05-16 20:59:22::2::77::12月完死約||2019-05-16 20:59:01::2::77::KP||2018-10-25 20:44:28::2::77::*PE 5P11 車位$2.38M,OPEN BY RICKY 3%, ADD TEL 2% ||2018-10-16 16:19:29::2::73::$2.40M 連約, CO-OP WITH 環球 VICKY LAU, OPEN FOR SELL BY FIONA 3%, ADD TEL BY FIONA 2%|',`Pocontact`=NULL,`Pocontacttel`=NULL,`Ppprice`='2250000',`Prent`=NULL,`Ppprice_s`=NULL,`Ppprice_t`=NULL,`Prent_s`=NULL,`Prent_t`=NULL,`Plot_no`='*',`Pexdate3`=NULL,`Pcreatedate`='2018-10-16 16:19:31',`Pmodifydate`='2019-05-16 20:59:23',`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`='姚先生####::(手提)90364627',`Pccontactmulti`=NULL,`Pcremarkmulti`=NULL,`Pttype`=NULL,`Pdcontactmulti`=NULL,`Pdremarkmulti`=NULL,`Padnumber`=NULL WHERE Pid=7405 [2019-05-16 20:59:23] INSERT INTO projectalert (`PAPid`,`PAdate`,`PAadmin`,`PAtype`,`PAstatus`,`other`) VALUE ('7405','2019-05-16 20:59:23','77','2','1','Popay,Pbpay,Poexdate1,Pbexdate1,Poremarkmulti') [2019-05-16 20:59:23] DELETE FROM projectalert WHERE PAPid='7405' && PAadmin='77' && PAtype='2' && PAalert=1 [2019-05-16 20:59:23] INSERT INTO `adminlog` (`logintime`,`id`,`ip`,`status`,`field`,`remark`,`r`,`type`) VALUES ('2019-05-16 20:59:23',77,'192.168.31.13',3,'project','樓盤︰油塘/住宅 - PENINSULA EAST 座: , 單位: P11, 層: 5, 地段編號: *',7405,2) [2019-05-16 20:59:23] UPDATE projectshare SET Pname='' WHERE Pid=7405 [2019-05-16 20:59:23] UPDATE projectshare SET Pprice='0.00',Popay='0.00',Pbpay='0.00' WHERE Pid=7405 [2019-05-16 20:59:23] UPDATE projectshare SET PSprice=ROUND((0)*PSperc/100,2) WHERE Pid=7405 [2019-05-16 20:59:23] UPDATE projectshare AS A SET A.Pdate = (SELECT B.Pdate FROM project AS B WHERE A.Pid=B.Pid) [2019-05-16 20:59:23] UPDATE project SET Pstatus=2 WHERE Pid=7405 [2019-05-16 20:59:23] UPDATE project SET Pstatus2=2 WHERE Pid=7405 [2019-05-16 20:59:23] UPDATE projectsharepayment SET PSPsalrealdate=PSPsaldate WHERE PSPsalrealdate IS NULL OR PSPsalrealdate='' [2019-05-16 20:59:23] UPDATE sales SET lastlogindate='2019-05-16 20:59:23' WHERE Sid='77' LIMIT 1 [2019-05-16 20:59:23] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59:23] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 20:59: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-16 20:59:23] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 20:59: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-16 20:59: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-16 21:00:48] UPDATE sales SET lastlogindate='2019-05-16 21:00:48' WHERE Sid='90' LIMIT 1 [2019-05-16 21:00:48] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:00:48] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:00:48] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 21:00:48] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:01:02] UPDATE sales SET lastlogindate='2019-05-16 21:01:02' WHERE Sid='90' LIMIT 1 [2019-05-16 21:01:02] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:01:02] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:01: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-16 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-16 21:08:00] UPDATE sales SET lastlogindate='2019-05-16 21:08:00' WHERE Sid='77' LIMIT 1 [2019-05-16 21:08:00] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:08:00] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21: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-16 21: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-16 21:08: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-16 21:08: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-16 21:08:05] UPDATE sales SET lastlogindate='2019-05-16 21:08:05' WHERE Sid='77' LIMIT 1 [2019-05-16 21:08:05] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:08:05] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:08: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-16 21:08:05] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:08: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-16 21:08: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-16 21:08:20] UPDATE sales SET lastlogindate='2019-05-16 21:08:20' WHERE Sid='77' LIMIT 1 [2019-05-16 21:08:20] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:08:20] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:08:20] 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-16 21:08:20] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:08: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-16 21:08: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-16 21:10:42] UPDATE sales SET lastlogindate='2019-05-16 21:10:42' WHERE Sid='77' LIMIT 1 [2019-05-16 21:10:42] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:10:43] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:10:43] 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-16 21:10:43] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:12:38] UPDATE sales SET lastlogindate='2019-05-16 21:12:38' WHERE Sid='77' LIMIT 1 [2019-05-16 21:12:38] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:12:38] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:12: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-16 21:12:38] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:12: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-16 21:12: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-16 21:27:54] UPDATE sales SET lastlogindate='2019-05-16 21:27:54' WHERE Sid='90' LIMIT 1 [2019-05-16 21:27:54] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:27:54] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:27:54] UPDATE project SET Pstatus=4 WHERE Pstatus=2 AND Poexdate18 AND (IF(Popay IS NULL,0,Popay)=IF(Poreceived IS NULL,0,Poreceived)) [2019-05-16 21:27:54] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:27:56] UPDATE sales SET lastlogindate='2019-05-16 21:27:56' WHERE Sid='90' LIMIT 1 [2019-05-16 21:27:56] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:27:56] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:27: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-16 21:27:57] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:30:24] UPDATE admin SET login_ip='' WHERE id='90' LIMIT 1 [2019-05-16 21:30:24] INSERT INTO adminlog ( `logintime`, `id`, `ip`, `status`, `type` ) VALUES ( NOW(), '90', '192.168.31.36', '9', '2' ) [2019-05-16 21:58:52] UPDATE sales SET lastlogindate='2019-05-16 21:58:52' WHERE Sid='77' LIMIT 1 [2019-05-16 21:58:52] UPDATE project SET Pstatus=2 WHERE Pstatus=4 AND Poexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:58:52] UPDATE project SET Pstatus2=2 WHERE Pstatus2=4 AND Pbexdate1>=NOW() AND Pstepcount=2 [2019-05-16 21:58: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-16 21:58:53] UPDATE project SET Pstatus2=8 WHERE Pstatus2<>8 AND (IF(Pbpay IS NULL,0,Pbpay)=IF(Pbreceived IS NULL,0,Pbreceived)) [2019-05-16 21:58: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-16 21:58: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))