{"created_at":"2019-12-06 10:41:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1074,"customer_code":"C181074","identity_type":"PERSONAL","identity_id":"G563327(2)","title":"Mr","lastname":"Leung","firstname":"Kit Man Andy","companyname":"","email":"leungandy@rlphk.com","tel":"94601896","address":"28A, Block 3, Grand Garden, 61 South Bay Road, Repulse Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1445.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"0012488968","renew_remark":"12 months contract. Storage rental and deposit paid by EPS on November 13, 2018. Smartcard provided on November 13, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183571, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3210.0","renew_master_room_id":"116","order_discount":[],"order_room":[{"room_id":"1049","room_code":"A05-047","retail_price":"1605.0","discounted_price":"1605.00","location_id":"4"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1445,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":17340,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-11-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Dec 06, 2019. Deposit $3210 transferred from agreement A05-CT183571 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":17340,"final_order_total":17340,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012488968","order_product":[],"pass":true}},"first_order_id":3571,"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>
A05-047 <\/td>\r\n\t\t\t\t\t	4X5X7 <\/td>\r\n\t\t\t\t\t	$1605.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"20","total_discounted_price":"1445.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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","4",1074,"NEW","A05-CT196617",1605,1445,0,0,"12","12",17340,17340,17340,"2019-12-06 10:52:11","0",null,null,null,"2019-12-01","2020-11-30","12 months contract. Storage rental paid by bank transfer on Dec 06, 2019. Deposit $3210 transferred from agreement A05-CT183571 to this agreement.","2019-12-01","20",0,null,0,"0","2","2019-12-06 10:52:11","2","2019-12-06 10:52:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012488968","C181074","PERSONAL","Mr","+3mYrRR1Rd7GlGRapc5lXQ==","xEf2h2aoyRQ71ZVgBH+9WQ==","","hIVn28iANo\/R6vxlMhCfRDMsIF+wN7PdBRLv+HCGyU20ca033FCqulCbAPUgfiW31CF4FBGUDcVnN3bSt8LHReaGADT77seQ1VYzXA1QRzg=","1zsVxRXn3NUI1xt+VgFblA==","HRSpqbpIoqWCaDCaTU\/Od5PGiUVHzeImWKYkiCcXReY=","n3MRXN1Ir2\/P3Rmdy2iy0w==",null,1,3571]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6617","1049","1605.0","1605.00","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["2019-12-01","2020-11-30","1049"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 10:52:11","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":["6617",1074,"SETTLED","A05-I196945","2019-12-06 10:52:11","2019-12-01","2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",1,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",2,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",3,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",4,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",5,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",6,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",7,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",8,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",9,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",10,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",11,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6945","RENT","\u9810\u7e73\u79df\u91d1",12,1445,"MO","1",1445,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17340,0,"6945"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 10:52:11","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":[1074,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196595","2019-12-06 10:52:11",17340,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6595","DEPOSIT",null,"PAID","2019-12-06 10:52:11",0,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 10:52:11","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":["6595","INVOICE","6945","PAID","2019-12-06 10:52:11",17340,"2","2019-12-06 10:52:11","2","2019-12-06 10:52:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28: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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":397,"customer_code":"C170397","identity_type":"PERSONAL","identity_id":"D260015(4)","title":"Mr","lastname":"Wong","firstname":"Tat Ming","companyname":"","email":"Wongtatming@live.hk","tel":"63531531","address":"Rm 304,Tin Fai Hiuse,Yau Fai Court,Aberdeen ","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-01","renew_room_key":"055,12493","renew_remark":"12 months contract. Storage rental paid by EPS on Oct 25, 2018. Storage deposit transferred from agreement SD14-CT182191 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183368, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"480","room_code":"K17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"479","room_code":"K16","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":21456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-01","rent_from":"2019-11-01","rent_to":"2020-10-31","delivery_service":"0","remark":"12 months contract. Storage rental paid by EPS on Dec 06,2019. $300 Maxim coupon offered. Storage deposit transferred from agreement A14-CT183368 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":21456,"final_order_total":21456,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,12493","order_product":[],"pass":true}},"first_order_id":3368,"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\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> K17 <\/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> K16 <\/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":"32","total_discounted_price":"1788.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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",397,"NEW","A14-CT196618",2196,1788,0,0,"12","12",21456,21456,21456,"2019-12-06 12:28:30","0",null,null,null,"2019-11-01","2020-10-31","12 months contract. Storage rental paid by EPS on Dec 06,2019. $300 Maxim coupon offered. Storage deposit transferred from agreement A14-CT183368 to this agreement.","2019-11-01","32",0,null,0,"0","2","2019-12-06 12:28:30","2","2019-12-06 12:28:30","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"055,12493","C170397","PERSONAL","Mr","dtAl1rOu2Rzw+Ugg0QgN5w==","hULSwM2MvFtpeV9\/z+er8Q==","","1hOBDYFQI6xU9vsX\/Va9SiPL5Nc+888qyNP9j8isxCfaJXgEZLChcKN0gd6WNAyj","GkNiqIaYTqLCbdxmOuHhcw==","lgwmmGZOA73rFtDZfG5wY8OrgH+AHAF3F0TF1Fj8jEM=","lF2NcisZ\/ZkDOqXFs\/6EUQ==",null,1,3368]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6618","480","1098.0","1098.00","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["2019-11-01","2020-10-31","480"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 12:28:30","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":["6618","479","1098.0","1098.00","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["2019-11-01","2020-10-31","479"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 12:28:30","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":["6618",397,"SETTLED","A14-I196946","2019-12-06 12:28:30","2019-11-01","2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",7,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",8,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",9,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",10,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",11,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6946","RENT","\u9810\u7e73\u79df\u91d1",12,1788,"MO","1",1788,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[21456,0,"6946"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 12:28:30","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":[397,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196596","2019-12-06 12:28:30",21456,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6596","DEPOSIT",null,"PAID","2019-12-06 12:28:30",0,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 12:28:30","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":["6596","INVOICE","6946","PAID","2019-12-06 12:28:30",21456,"2","2019-12-06 12:28:30","2","2019-12-06 12:28:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1109,"customer_code":"C181109","identity_type":"PERSONAL","identity_id":"Z607406(6)","title":"Ms","lastname":"Wong","firstname":"Yuk Fun","companyname":"","email":"w.yukfun@yahoo.com.hk","tel":"68034311","address":"Flat 3A, Yee Tiam Building, 5-11 Ka Wo Street, Tin Wan, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-07","renew_room_key":"0012435028","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by EPS on November 20, 2018. Smartcard provided on November 20, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183658, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"110","order_discount":[{"master_room_discount_id":"476","master_room_id":"110","discount_type":"%","price":"598.00","disocunted_price":"497.00","discount":"16.89","monthly_deduct":101.0022,"room_id":"1092","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1092","room_code":"A05-090","retail_price":"598.0","discounted_price":497,"location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-07","rent_from":"2019-12-07","rent_to":"2020-12-06","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Dec 06,2019. Deposit $1196 transferred from agreement A05-CT183658 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012435028","order_product":[],"pass":true}},"first_order_id":3658,"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> A05-090 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"8","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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","4",1109,"NEW","A05-CT196619",598,538,0,0,"12","12",6456,6456,6456,"2019-12-06 13:59:00","0",null,null,null,"2019-12-07","2020-12-06","12 months contract. Storage rental paid by bank transfer on Dec 06,2019. Deposit $1196 transferred from agreement A05-CT183658 to this agreement.","2019-12-07","8",0,null,0,"0","2","2019-12-06 13:59:00","2","2019-12-06 13:59:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012435028","C181109","PERSONAL","Ms","nhXs54s8gzGO7+hLLpsjWw==","hULSwM2MvFtpeV9\/z+er8Q==","","wTSVV8xdJ4\/2G+0ALPw15Hukme6ZHyVeHi0nktH2Y0TPuXH53bmCp56E433RxfhtlLOpRArqKPqKHgSUvFifp\/zThlE3gdCv8sOEOEKL8Ls=","\/AcOuMJiosI2xbcEAPhYXw==","b2jUMXWWzGN72kV5D2Wpl\/xzpAucS24nJcvuZwk3ubE=","TOz0F6l9X6glbamdiCDemw==",null,1,3658]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6619","476","110","1092","%","16.89",101.0022,"2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6619","1092","598.0",497,"2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["2019-12-07","2020-12-06","1092"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 13:59:00","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":["6619",1109,"SETTLED","A05-I196947","2019-12-06 13:59:00","2019-12-07","2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6947","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"6947"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 13:59:00","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":[1109,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196597","2019-12-06 13:59:00",6456,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6597","DEPOSIT",null,"PAID","2019-12-06 13:59:00",0,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 13:59:00","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":["6597","INVOICE","6947","PAID","2019-12-06 13:59:00",6456,"2","2019-12-06 13:59:00","2","2019-12-06 13:59:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:00:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 06, 2019. Storage deposit transferred from agreement A12-CT196092 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196350, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"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":"2019-12-08","rent_from":"2019-12-08","rent_to":"2020-01-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 06,2019. Storage deposit transferred from agreement A12-CT196350 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","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> A09 <\/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\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":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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",197,"NEW","A12-CT196620",1098,1038,0,0,"1","1",1038,1038,1038,"2019-12-06 14:43:16","0",null,null,null,"2019-12-08","2020-01-07","1 month contract. Storage rental paid by bank transfer on Dec 06,2019. Storage deposit transferred from agreement A12-CT196350 to this agreement.","2019-12-08","16",0,null,0,"0","2","2019-12-06 14:43:16","2","2019-12-06 14:43:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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":["6620","9","1098.0","1098.00","2","2019-12-06 14:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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":["2019-12-08","2020-01-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 14:43:16","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":["6620",197,"SETTLED","A12-I196948","2019-12-06 14:43:16","2019-12-08","2","2019-12-06 14:43:16","2","2019-12-06 14:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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":["6948","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-06 14:43:16","2","2019-12-06 14:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"6948"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 14:43:16","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":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196598","2019-12-06 14:43:16",1038,"2","2019-12-06 14:43:16","2","2019-12-06 14:43:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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":["6598","DEPOSIT",null,"PAID","2019-12-06 14:43:16",0,"2","2019-12-06 14:43:16","2","2019-12-06 14:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:43:16","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":["6598","INVOICE","6948","PAID","2019-12-06 14:43:16",1038,"2","2019-12-06 14:43:16","2","2019-12-06 14:43:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1261,"customer_code":"C191261","identity_type":"PERSONAL","identity_id":"G285177(5)","title":"Mr","lastname":"Lee","firstname":"Pak Ho","companyname":"","email":null,"tel":"62037746","address":"Room 2510, Lei Fook House, Lower Block, Apleichau Estate, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"1","renew_warehousing_date":"2019-09-04","renew_room_key":"076,58156","renew_remark":"1 month contract. Storage rental paid by bank transfer on September 4, 2019. Storage deposit $2196 transferred from agreement A14-CT195685 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195878, \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":"742","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"742","room_code":"O18","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3294,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-09-04","rent_from":"2019-09-04","rent_to":"2019-12-03","delivery_service":"0","remark":"3 months contract. Storage rental ($1098\/mth) paid by bank transfer on Nov 10th, 12th and Dec 06,2019. Storage deposit $2196 transferred from agreement A14-CT195878 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3294,"final_order_total":3294,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,58156","order_product":[],"pass":true}},"first_order_id":"4872","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> O18 <\/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":"1098.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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","2",1261,"NEW","A14-CT196621",1098,1098,0,0,"3","3",3294,3294,3294,"2019-12-06 14:56:09","0",null,null,null,"2019-09-04","2019-12-03","3 months contract. Storage rental ($1098\/mth) paid by bank transfer on Nov 10th, 12th and Dec 06,2019. Storage deposit $2196 transferred from agreement A14-CT195878 to this agreement.","2019-09-04","16",0,null,0,"0","2","2019-12-06 14:56:08","2","2019-12-06 14:56:08","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,58156","C191261","PERSONAL","Mr","l497mGOiMNQGidT3z5xzAA==","kiriEIqhcx866RNZiMXdKQ==","","qHi3rsy91wJafe8aQmSjkmxOhUk0X6aK9VcTSc7yi\/AmaNRZB7kJOc\/zHJ5gm+eKW\/g5fEQeq8RrqyNpSUg9Gp\/65DlaMHcBxxfKpNEtdiupU2zfVkpLoVZKNjzC+yhw","JmEgNMwRplOvZMflhfIdgw==",null,"itGnrdkuMhaVMvNK+jHZew==",null,1,"4872"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56:09","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":["6621","434","35","742","%","4.97",54.5706,"2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6621","742","1098.0",1043.4,"2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["2019-09-04","2019-12-03","742"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 14:56: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":["6621",1261,"SETTLED","A14-I196949","2019-12-06 14:56:08","2019-09-04","2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6949","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6949","RENT","\u9810\u7e73\u79df\u91d1",2,1098,"MO","1",1098,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6949","RENT","\u9810\u7e73\u79df\u91d1",3,1098,"MO","1",1098,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3294,0,"6949"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 14:56: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":[1261,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196599","2019-12-06 14:56:08",3294,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6599","DEPOSIT",null,"PAID","2019-12-06 14:56:08",0,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 14:56: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":["6599","INVOICE","6949","PAID","2019-12-06 14:56:08",3294,"2","2019-12-06 14:56:08","2","2019-12-06 14:56:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00:45","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=616&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1261,"customer_code":"C191261","identity_type":"PERSONAL","identity_id":"G285177(5)","title":"Mr","lastname":"Lee","firstname":"Pak Ho","companyname":"","email":null,"tel":"62037746","address":"Room 2510, Lei Fook House, Lower Block, Apleichau Estate, Ap Lei Chau, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1098.0","renew_rent_month":"2","renew_warehousing_date":"2019-10-06","renew_room_key":"076,58156","renew_remark":"2 month contract. Storage rental paid by cash on Oct 25, 2019. Storage deposit transferred from agreement A14-CT195686 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196222, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"759","room_code":"O35","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1098,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":2196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-06","rent_from":"2019-10-06","rent_to":"2019-12-05","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on Nov 10th,12th and Dec 6th,2019. Storage deposit transferred from agreement A14-CT196222 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2196,"final_order_total":2196,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,58156","order_product":[],"pass":true}},"first_order_id":"3630","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> O35 <\/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":"1098.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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",1261,"NEW","A14-CT196622",1098,1098,0,0,"2","2",2196,2196,2196,"2019-12-06 15:00:45","0",null,null,null,"2019-10-06","2019-12-05","2 months contract. Storage rental paid by bank transfer on Nov 10th,12th and Dec 6th,2019. Storage deposit transferred from agreement A14-CT196222 to this agreement.","2019-10-06","16",0,null,0,"0","2","2019-12-06 15:00:45","2","2019-12-06 15:00:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,58156","C191261","PERSONAL","Mr","l497mGOiMNQGidT3z5xzAA==","kiriEIqhcx866RNZiMXdKQ==","","qHi3rsy91wJafe8aQmSjkmxOhUk0X6aK9VcTSc7yi\/AmaNRZB7kJOc\/zHJ5gm+eKW\/g5fEQeq8RrqyNpSUg9Gp\/65DlaMHcBxxfKpNEtdiupU2zfVkpLoVZKNjzC+yhw","JmEgNMwRplOvZMflhfIdgw==",null,"itGnrdkuMhaVMvNK+jHZew==",null,1,"3630"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["6622","759","1098.0","1098.00","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["2019-10-06","2019-12-05","759"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 15:00: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":["6622",1261,"SETTLED","A14-I196950","2019-12-06 15:00:45","2019-10-06","2","2019-12-06 15:00:45","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["6950","RENT","\u9810\u7e73\u79df\u91d1",1,1098,"MO","1",1098,"2","2019-12-06 15:00:45","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["6950","RENT","\u9810\u7e73\u79df\u91d1",2,1098,"MO","1",1098,"2","2019-12-06 15:00:45","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2196,0,"6950"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 15:00: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":[1261,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196600","2019-12-06 15:00:45",2196,"2","2019-12-06 15:00:45","2","2019-12-06 15:00:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["6600","DEPOSIT",null,"PAID","2019-12-06 15:00:45",0,"2","2019-12-06 15:00:45","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:00: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":["6600","INVOICE","6950","PAID","2019-12-06 15:00:45",2196,"2","2019-12-06 15:00:45","2","2019-12-06 15:00:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:14:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 15:17:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 16:30:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 17:12:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 17:24:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":"","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 06, 2019. Storage deposit $2580 transferred from agreement A05-CT196088 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196349, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-01-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit $2580 transferred from agreement A05-CT196349 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","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> A05-008 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\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":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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","4",1217,"NEW","A05-CT196623",1290,1290,0,0,"1","1",1290,1290,1290,"2019-12-06 18:26:59","0",null,null,null,"2019-12-14","2020-01-13","1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit $2580 transferred from agreement A05-CT196349 to this agreement.","2019-12-14","16",0,null,0,"0","2","2019-12-06 18:26:59","2","2019-12-06 18:26:59","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":["6623","1010","1290.0","1290.00","2","2019-12-06 18:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":["2019-12-14","2020-01-13","1010"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 18:26:59","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":["6623",1217,"SETTLED","A05-I196951","2019-12-06 18:26:59","2019-12-14","2","2019-12-06 18:26:59","2","2019-12-06 18:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":["6951","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2019-12-06 18:26:59","2","2019-12-06 18:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"6951"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 18:26:59","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":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196601","2019-12-06 18:26:59",1290,"2","2019-12-06 18:26:59","2","2019-12-06 18:26:59","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":["6601","DEPOSIT",null,"PAID","2019-12-06 18:26:59",0,"2","2019-12-06 18:26:59","2","2019-12-06 18:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:26:59","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":["6601","INVOICE","6951","PAID","2019-12-06 18:26:59",1290,"2","2019-12-06 18:26:59","2","2019-12-06 18:26:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":469,"customer_code":"C170469","identity_type":"PERSONAL","identity_id":"E562535(5)","title":"Mr","lastname":"Poon ","firstname":"Yin Ming","companyname":"","email":null,"tel":"67039272","address":"Rm1403,14\/F,Ming Cheun House,Shui Chuen O Estate,Sha Tin","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-24","renew_room_key":"133,33462","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 9, 2019. Storage deposit transferred from agreement A14-CT196269 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196337, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"625","room_code":"M36","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"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":"2019-11-24","rent_from":"2019-11-24","rent_to":"2019-12-23","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit transferred from agreement A14-CT196337 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,33462","order_product":[],"pass":true}},"first_order_id":"4725","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> M36 <\/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> <\/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":"2019-12-06 18:36:48","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",469,"NEW","A14-CT196624",598,598,0,0,"1","1",598,598,598,"2019-12-06 18:36:48","0",null,null,null,"2019-11-24","2019-12-23","1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit transferred from agreement A14-CT196337 to this agreement.","2019-11-24","12",0,null,0,"0","2","2019-12-06 18:36:48","2","2019-12-06 18:36:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,33462","C170469","PERSONAL","Mr","7zuhiU2fzaatGP2D2mnAJA==","c9CkZ4cZzKCidNu3YYjrkw==","","QJ5AY46e6jExLz0oVTYEajr8ICB272rxLBtUMHgM2LeYYJatyO4QCPJb6GJOXbbZ2qJarCJxAoCZti1Uif3gKw==","2+3VDW\/cQQxeWAv\/Fi3w0Q==",null,"So0zSsBwxE4\/4T3R4c76WA==",null,1,"4725"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":["6624","625","598.0","598.00","2","2019-12-06 18:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":["2019-11-24","2019-12-23","625"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-06 18:36:48","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":["6624",469,"SETTLED","A14-I196952","2019-12-06 18:36:48","2019-11-24","2","2019-12-06 18:36:48","2","2019-12-06 18:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":["6952","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2019-12-06 18:36:48","2","2019-12-06 18:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"6952"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-06 18:36:48","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":[469,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196602","2019-12-06 18:36:48",598,"2","2019-12-06 18:36:48","2","2019-12-06 18:36:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":["6602","DEPOSIT",null,"PAID","2019-12-06 18:36:48",0,"2","2019-12-06 18:36:48","2","2019-12-06 18:36:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-06 18:36:48","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":["6602","INVOICE","6952","PAID","2019-12-06 18:36:48",598,"2","2019-12-06 18:36:48","2","2019-12-06 18:36:48"]},"data_before":[],"data_after":[],"step":1} *****