{"created_at":"2020-04-25 13:40:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 13:40:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:08","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1425,"customer_code":"C191425","identity_type":"BUSINESS","identity_id":"2519978","title":"Mr","lastname":"Wong ","firstname":"Man Cheung","companyname":"Serene Capital Limited","email":"philipwong@certproperty.co.uk","tel":"90941892","address":"16A, 16\/F Chung Hing Commercial Building, 62 Connaught Road Central, Central, H.K.","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-17","renew_room_key":"0012450069","renew_remark":"1 month contract. Storage rental paid by PPS on March 19, 2020. Storage deposit $1196 transferred from agreement A12-CT207217 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207459, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"213","room_code":"D17","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-17","rent_from":"2020-04-17","rent_to":"2020-05-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 22, 2020. Storage deposit $1196 transferred from agreement A12-CT207459 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"0012450069","order_product":[],"pass":true}},"first_order_id":"3347","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
D17 <\/td>\r\n\t\t\t\t\t	4X3X4 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1425,"NEW","A12-CT207720",598,598,0,0,"1","1",598,598,598,"2020-04-25 15:02:09","0",null,null,null,"2020-04-17","2020-05-16","1 month contract. Storage rental paid by PPS on April 22, 2020. Storage deposit $1196 transferred from agreement A12-CT207459 to this agreement. \r\n","2020-04-17","12",0,null,0,"0","2","2020-04-25 15:02:08","2","2020-04-25 15:02:08","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012450069","C191425","BUSINESS","Mr","G+w65JkR7AS+JT7hCDD+yg==","DgLsCGM4faTvgwjKBW9M0A==","Serene Capital Limited","S4o9AXA7eRky9fl+GI6ii2+TMoCmBDuByzpKzUF7jpxGD0QmypETmhNR0PVTCj612a7mYANU+Sc3i0encOiszMwjCriyODNCJhdNRzJhCfKfqggF6Ry9Getc\/0LKYKRN","CL6e4EkMiRzRr0Rve85mrw==","eLkWayCc4RkCZg6CrTQmBSr+4xmx9fTzOhnQ35wQOzA=",null,"JdjeYwtWISTCzDjjVIKzVw==",1,"3347"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7720","213","598.0","598.00","2","2020-04-25 15:02:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-17","2020-05-16","213"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7720",1425,"SETTLED","A12-I208048","2020-04-25 15:02:08","2020-04-17","2","2020-04-25 15:02:08","2","2020-04-25 15:02:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8048","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-04-25 15:02:08","2","2020-04-25 15:02:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8048"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1425,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207694","2020-04-25 15:02:08",598,"2","2020-04-25 15:02:08","2","2020-04-25 15:02:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7694","DEPOSIT",null,"PAID","2020-04-25 15:02:08",0,"2","2020-04-25 15:02:08","2","2020-04-25 15:02:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:02:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7694","INVOICE","8048","PAID","2020-04-25 15:02:08",598,"2","2020-04-25 15:02:08","2","2020-04-25 15:02:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":569,"customer_code":"C170569","identity_type":"PERSONAL","identity_id":"Z110604(0)","title":"Ms","lastname":"Tsu","firstname":"Pui Yu Jade","companyname":"","email":"jadevanness@gmail.com","tel":"97224016","address":"Flat 3, 4\/F, 165 King's Road, North Point, HK","pass":true},"2":{"renew_paymethod2":"OTHER","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-26","renew_room_key":"055,44582","renew_remark":"6 months contract. Storage rental paid by PayMe on October 14, 2019. Storage deposit transferred from agreement A14-CT194905 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196142, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"415","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"415","room_code":"I06","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-26","rent_from":"2020-04-26","rent_to":"2020-07-25","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on April 24, 2020. Storage deposit transferred from agreement A14-CT196142 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,44582","order_product":[],"pass":true}},"first_order_id":"3426","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> I06 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",569,"NEW","A14-CT207721",1098,989,0,0,"3","3",2967,2967,2967,"2020-04-25 15:06:45","0",null,null,null,"2020-04-26","2020-07-25","3 months contract. Storage rental paid by PPS on April 24, 2020. Storage deposit transferred from agreement A14-CT196142 to this agreement.\r\n","2020-04-26","16",0,null,0,"0","2","2020-04-25 15:06:44","2","2020-04-25 15:06:44","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,44582","C170569","PERSONAL","Ms","6rs5oz7KJ5FTjRyZHmt6Zg==","xC1f7YThUB5wSSw6xmERYg==","","nFAll8o2ZD\/PP8QO\/kSGQq+Z3J2F1+BvC15J7r+64A2tR5EHey5h2ap0MDabo1yi","yxqZ2Bs7k2NfzbdKvK8bPA==","NaRCcE6MCx\/e\/vidIa8QG37gxTCJTYszCxKMBh9UVUw=","CtB5KMCaI2Mdjnfs8h1bQQ==",null,1,"3426"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7721","434","35","415","%","4.97",54.5706,"2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7721","415","1098.0",1043.4,"2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-26","2020-07-25","415"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7721",569,"SETTLED","A14-I208049","2020-04-25 15:06:44","2020-04-26","2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8049","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"8049"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[569,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207695","2020-04-25 15:06:44",2967,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","DEPOSIT",null,"PAID","2020-04-25 15:06:44",0,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:06:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7695","INVOICE","8049","PAID","2020-04-25 15:06:44",2967,"2","2020-04-25 15:06:44","2","2020-04-25 15:06:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":874,"customer_code":"C180874","identity_type":"PERSONAL","identity_id":"K451268(5)","title":"Mr","lastname":"Lui","firstname":"Chun Hung","companyname":"","email":"patpat9413888@yahoo.com.hk","tel":"90301273","address":"Room 403, Low Block, Lei Fook House, Apleichau Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-22","renew_room_key":"076,32357","renew_remark":"1 month contract. Storage rental paid by PPS on March 30, 2020. Storage deposit transferred from agreement A12-CT207264 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207534, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"241","room_code":"D45","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-22","rent_from":"2020-04-22","rent_to":"2020-05-21","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on April 24, 2020. Storage deposit transferred from agreement A12-CT207534 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"076,32357","order_product":[],"pass":true}},"first_order_id":"4854","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D45 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",874,"NEW","A12-CT207722",998,1038,0,0,"1","1",1038,1038,1038,"2020-04-25 15:08:57","0",null,null,null,"2020-04-22","2020-05-21","1 month contract. Storage rental paid by PPS on April 24, 2020. Storage deposit transferred from agreement A12-CT207534 to this agreement.\r\n","2020-04-22","12",0,null,0,"0","2","2020-04-25 15:08:57","2","2020-04-25 15:08:57","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"076,32357","C180874","PERSONAL","Mr","8E6nLeLaS+nuXxUNvooxGQ==","vyCKi4IYWx3VnCZylJM1yA==","","t2fcXTNQ5zXw41HK7XLxjgpqs4CAbleDk0AZC75MEKtw5ZsokMMh80cI\/IUaR9tYbJXdnEldy\/dOlMJjVNoCJBK+BLg2Hq37YGStg4SRRpc=","v99UbwvGk\/IX8Amdc7pe+Q==","93qNDvLNra1NfZlAUamtzf14nbvapEp9X2o2aos8F7w=","fzIJnHKlsYW3ETkg3nSzoQ==",null,1,"4854"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7722","241","998.0","998.00","2","2020-04-25 15:08:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-04-22","2020-05-21","241"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7722",874,"SETTLED","A12-I208050","2020-04-25 15:08:57","2020-04-22","2","2020-04-25 15:08:57","2","2020-04-25 15:08:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8050","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-04-25 15:08:57","2","2020-04-25 15:08:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8050"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[874,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207696","2020-04-25 15:08:57",1038,"2","2020-04-25 15:08:57","2","2020-04-25 15:08:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7696","DEPOSIT",null,"PAID","2020-04-25 15:08:57",0,"2","2020-04-25 15:08:57","2","2020-04-25 15:08:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:08:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7696","INVOICE","8050","PAID","2020-04-25 15:08:57",1038,"2","2020-04-25 15:08:57","2","2020-04-25 15:08:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:30","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":319,"customer_code":"C170319","identity_type":"PERSONAL","identity_id":"D666363(0)","title":"Mr","lastname":"Chau","firstname":"Johnny","companyname":"","email":"yochau@gmail.com","tel":"91220103","address":"F6,9\/F,Block A, Hoi Chun Court ,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-03","renew_room_key":"054,20556","renew_remark":"6 months contract. Storage rental paid by PPS on November 4, 2018. Storage deposit transferred from agreement A14-CT183412 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196315, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"57","order_discount":[],"order_room":[{"room_id":"780","room_code":"P14","retail_price":"2598.0","discounted_price":"2598.00","location_id":"2"}],"roughly_size":"36","total_retail_price":2598,"total_discounted_price":2018,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-03","rent_from":"2020-05-03","rent_to":"2020-11-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by credit card on April 24, 2020. Storage deposit transferred from agreement A14-CT196315 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":12108,"final_order_total":12108,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,20556","order_product":[],"pass":true}},"first_order_id":"3412","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> P14 <\/td>\r\n\t\t\t\t\t 6X6X8 <\/td>\r\n\t\t\t\t\t $2598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"36","total_discounted_price":"2018.0","deposit":"0","total_retail_price":"2598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",319,"NEW","A14-CT207723",2598,2018,0,0,"6","6",12108,12108,12108,"2020-04-25 15:59:31","0",null,null,null,"2020-05-03","2020-11-02","6 months contract. Storage rental paid by credit card on April 24, 2020. Storage deposit transferred from agreement A14-CT196315 to this agreement.","2020-05-03","36",0,null,0,"0","2","2020-04-25 15:59:30","2","2020-04-25 15:59:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,20556","C170319","PERSONAL","Mr","gB3lOIKGw08oQZ3wGQ6W1A==","kOK3vHUlGE9qjoVnzYRDGA==","","+LY9jXB08\/ROlmf4tzd27P8Mkuaz0h1tHAIFO8mmunmtAR9jFk\/vMM7p017YOl0w","mnS\/3SejyDp+HtKK62q4bg==","6Z6kRGeB+1Bh1yVv\/7xDR221AjEyh33x40NlFt8RDPo=","n49aoPqb+ZhlfDpx0SZV3Q==",null,1,"3412"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7723","780","2598.0","2598.00","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-03","2020-11-02","780"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7723",319,"SETTLED","A14-I208051","2020-04-25 15:59:30","2020-05-03","2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8051","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12108,0,"8051"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[319,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207697","2020-04-25 15:59:30",12108,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7697","DEPOSIT",null,"PAID","2020-04-25 15:59:30",0,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 15:59:31","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7697","INVOICE","8051","PAID","2020-04-25 15:59:30",12108,"2","2020-04-25 15:59:30","2","2020-04-25 15:59:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:02:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1552&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"496","master_room_id":"35","room_code":"K33"},{"room_id":"497","master_room_id":"35","room_code":"K34"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K33 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> K34 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"K130991(9)","title":"Ms","lastname":"LI","firstname":"Wing Kit","companyname":"","email":"kittyli113@gmail.com","tel":"92601615","address":"9A, Tower 3, Robinson Heights, 8 Robinson Road, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"496","room_code":"K33","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"497","room_code":"K34","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":4044,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":24432,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2856.00","warehousing_date":"2020-05-01","rent_from":"2020-05-01","rent_to":"2021-05-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on April 25, 2020. Smartcard provided on April 25, 2020. ","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2856,"order_total":27288,"final_order_total":24432,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 29053","order_product":[],"pass":true}},"roughly_size":"32","total_discounted_price":"1788.00","deposit":"4044.00","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201572","PERSONAL","Ms","lGSA6mhK3fUmMdlvd20tEA==","hbkan9PC5SCnBxQh2lhA4w==","","zcATs8zk7vmVUKNbbeZC9Q==","u5eCfzFIjQ3j2eB8Fi1Nsb7xeQebhQnZSEHFi+s5Hag=","hQVWaBhiY0QsCRpM593VKykvHE8\/TtZAUEobNvl3I5g2rOhSWe2qrIsCjVFgjM8LYPzXr7XSYA3PYj5PoFqlog==","hXniU+M+iRC+aJ4UtiuJPQ==",null,"u5eCfzFIjQ3j2eB8Fi1Nsb7xeQebhQnZSEHFi+s5Hag=","akpJN2F7GIDBK8peUV6asA==","2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1572,"NEW","A14-CT207724",2196,1788,4044,0,"13","13",24432,27288,24432,"2020-04-25 16:36:41","0",null,null,null,"2020-05-01","2021-05-31","13 months contract. Special offer the 13th month free and 5% \"Rent Now\" discount. Storage rental and deposit paid by EPS on April 25, 2020. Smartcard provided on April 25, 2020. ","2020-05-01","32",0,null,2856,"2856.00","2","2020-04-25 16:36:39","2","2020-04-25 16:36:39","EPS","","","","EPS","","","",null,0,"189, 29053","C201572","PERSONAL","Ms","lGSA6mhK3fUmMdlvd20tEA==","hbkan9PC5SCnBxQh2lhA4w==","","hQVWaBhiY0QsCRpM593VKykvHE8\/TtZAUEobNvl3I5g2rOhSWe2qrIsCjVFgjM8LYPzXr7XSYA3PYj5PoFqlog==","zcATs8zk7vmVUKNbbeZC9Q==","u5eCfzFIjQ3j2eB8Fi1Nsb7xeQebhQnZSEHFi+s5Hag=","hXniU+M+iRC+aJ4UtiuJPQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7724","496","1098.0","1098.00","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2021-05-31","496"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7724","497","1098.0","1098.00","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-01","2021-05-31","497"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7724","A14-D205391","PAID",4044,0,"2021-05-31","2020-04-25 16:36:39","2020-04-25 16:36:39","2","2020-04-25 16:36:39","2","2020-04-25 16:36:39",1572]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7724",1572,"SETTLED","A14-I208052","2020-04-25 16:36:39","2020-05-01","2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,720,"MO","1",720,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8052","RENT","\u9810\u7e73\u79df\u91d1",13,1788,"MO","1",1788,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20388,0,"8052"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1572,"EPS","","","","EPS","","","","PAID","P207698","2020-04-25 16:36:39",24432,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7698","DEPOSIT","5391","PAID","2020-04-25 16:36:39",4044,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:36:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7698","INVOICE","8052","PAID","2020-04-25 16:36:39",20388,"2","2020-04-25 16:36:39","2","2020-04-25 16:36:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 16:37:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 17:05:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 17:06:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-25 22:43:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****