\r\n\t\t\t\t\tB58 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tB57 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tB48 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tB47 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tB46 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"100","total_discounted_price":"5551.00","deposit":"0.00","total_retail_price":"7640.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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",515,"NEW","A12-CT207026",7640,5551,0,0,"7","7",33306,38857,33306,"2020-01-23 10:53:26","0",null,null,null,"2020-02-07","2020-09-06","7 months contract. Special offer the 7th month FREE. Storage rental paid by cheque on January 23, 2020. Storage deposit transferred from agreement A12-CT195574 to this agreement.","2020-02-07","100",0,null,5551,"5551.00","2","2020-01-23 10:53:26","2","2020-01-23 10:53:26","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,46971","C170515","PERSONAL","Ms","hJrq78+YLLannhuYKzwzBQ==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","EdP6IMLC6eiY3Cv9SL\/MQYNas4wUI34NSZUHH9Pqsel+EOAdXreihK4r0QxtBEUwWy7qgWWndiDg63eVgDt7grGAjKCyKiDPGYnzwxpGXWU=","HeeIULtFLOwl6\/a44Z71Ag==",null,"NqxCn2ry\/boq5JFtUOsqBg==",null,1,"4263"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026","110","1528.0","1528.00","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-07","2020-09-06","110"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026","109","1528.0","1528.00","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-07","2020-09-06","109"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026","100","1528.0","1528.00","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-07","2020-09-06","100"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026","99","1528.0","1528.00","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-07","2020-09-06","99"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026","98","1528.0","1528.00","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-07","2020-09-06","98"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 10:53:26","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":["7026",515,"SETTLED","A12-I207354","2020-01-23 10:53:26","2020-02-07","2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u9810\u7e73\u79df\u91d1",3,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u9810\u7e73\u79df\u91d1",4,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u9810\u7e73\u79df\u91d1",5,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u9810\u7e73\u79df\u91d1",6,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7354","RENT","\u9810\u7e73\u79df\u91d1",7,5551,"MO","1",5551,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[33306,0,"7354"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 10:53:26","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":[515,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207003","2020-01-23 10:53:26",33306,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7003","DEPOSIT",null,"PAID","2020-01-23 10:53:26",0,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 10:53:26","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":["7003","INVOICE","7354","PAID","2020-01-23 10:53:26",33306,"2","2020-01-23 10:53:26","2","2020-01-23 10:53:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4400.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"191,03185","renew_remark":"1 month contract. Special offer $4400\/mth. Storage rental and deposit paid by bank transfer on Oct 30,2019. Smartcard provided on Oct 30,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196263, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4400.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"579","room_code":"L57","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"578","room_code":"L56","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"577","room_code":"L55","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"589","room_code":"L67","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"588","room_code":"L66","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"587","room_code":"L65","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"96","total_retail_price":6588,"total_discounted_price":4400,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4400,"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":"2019-12-31","delivery_service":"0","remark":"1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on Jan 23,2020. Deposit $4400 transferred from A14-CT196263 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4400,"final_order_total":4400,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":6263,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tL57 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tL56 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tL55 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tL67 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tL66 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tL65 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"96","total_discounted_price":"4400.0","deposit":"0","total_retail_price":"6588.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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","2",1433,"NEW","A14-CT207027",6588,4400,0,0,"1","1",4400,4400,4400,"2020-01-23 11:42:16","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Special offer $4400\/mth. Storage rental paid by bank transfer on Jan 23,2020. Deposit $4400 transferred from A14-CT196263 to this agreement.","2019-12-01","96",0,null,0,"0","2","2020-01-23 11:42:16","2","2020-01-23 11:42:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,6263]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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":["7027","579","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","579"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027","578","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","578"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027","577","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","577"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027","589","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","589"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027","588","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","588"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027","587","1098.0","1098.00","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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-01","2019-12-31","587"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:42: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":["7027",1433,"SETTLED","A14-I207355","2020-01-23 11:42:16","2019-12-01","2","2020-01-23 11:42:16","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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":["7355","RENT","\u9810\u7e73\u79df\u91d1",1,4400,"MO","1",4400,"2","2020-01-23 11:42:16","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4400,0,"7355"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 11:42: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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207004","2020-01-23 11:42:16",4400,"2","2020-01-23 11:42:16","2","2020-01-23 11:42:16","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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":["7004","DEPOSIT",null,"PAID","2020-01-23 11:42:16",0,"2","2020-01-23 11:42:16","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:42: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":["7004","INVOICE","7355","PAID","2020-01-23 11:42:16",4400,"2","2020-01-23 11:42:16","2","2020-01-23 11:42:16"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46: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":"&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":1433,"customer_code":"C191433","identity_type":"PERSONAL","identity_id":"K186942(6)","title":"Ms","lastname":"CHONG","firstname":"Hiu Sai Stephanie","companyname":"","email":"kaczorowski@netvigator.com","tel":"96159015","address":"Flat B, 18\/F, TWR 10, Larvotto, 8 Ap Lei Chau Praya Rd, Ap Lei Chau, HK.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3920.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"","renew_remark":"1 month contract. Special price $3920\/mth. Storage rental and deposit paid by EPS on Oct 31,2019. Padlock provided on Oct 31,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196272, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3920.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"683","room_code":"M94","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"682","room_code":"M93","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"681","room_code":"M92","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"672","room_code":"M83","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"671","room_code":"M82","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"670","room_code":"M81","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5988,"total_discounted_price":3920,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3920,"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":"2019-12-31","delivery_service":"0","remark":"1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on Jan 23,2020. Deposit $3920 transferred from agreement A14-CT196272 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3920,"final_order_total":3920,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03185","order_product":[],"pass":true}},"first_order_id":6272,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tM94 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM93 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM92 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM83 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM82 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tM81 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"72","total_discounted_price":"3920.0","deposit":"0","total_retail_price":"5988.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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",1433,"NEW","A14-CT207028",5988,3920,0,0,"1","1",3920,3920,3920,"2020-01-23 11:46:01","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Special price $3920\/mth. Storage rental paid by bank transfer on Jan 23,2020. Deposit $3920 transferred from agreement A14-CT196272 to this agreement.","2019-12-01","72",0,null,0,"0","2","2020-01-23 11:46:00","2","2020-01-23 11:46:00","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"191,03185","C191433","PERSONAL","Ms","jvk7zrBnQZbXfX1dgEQlHe0RI1vs\/c8ofCzDIiHPduw=","sFvIMVuF8ZsYisXFtwlNOg==","","voDtSK9PGGTovDOARqXC4\/CqVs\/FW\/EFt+7Y8XgoNXnKX\/oYLjrZhZIszuJBDn5WLlxnxR+ombwIyw2An8MxBSJza\/jcybdtGn9ZStmQV6U=","WkO2u9lqQEjRnfUKLBy+6Q==","WfnjLYwTfgHTPaehcdhvGWTDmhNfxmwxxekvQ0TBxrg=","F4vjEMLSruInVObtV1LPJw==",null,1,6272]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","683","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","683"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","682","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","682"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","681","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","681"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","672","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","672"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","671","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","671"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028","670","998.0","998.00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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","2019-12-31","670"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:46:01","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":["7028",1433,"SETTLED","A14-I207356","2020-01-23 11:46:00","2019-12-01","2","2020-01-23 11:46:00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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":["7356","RENT","\u9810\u7e73\u79df\u91d1",1,3920,"MO","1",3920,"2","2020-01-23 11:46:00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3920,0,"7356"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 11:46:01","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":[1433,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207005","2020-01-23 11:46:00",3920,"2","2020-01-23 11:46:00","2","2020-01-23 11:46:00","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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":["7005","DEPOSIT",null,"PAID","2020-01-23 11:46:00",0,"2","2020-01-23 11:46:00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:46:01","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":["7005","INVOICE","7356","PAID","2020-01-23 11:46:00",3920,"2","2020-01-23 11:46:00","2","2020-01-23 11:46:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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=786&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":444,"customer_code":"C170444","identity_type":"BUSINESS","identity_id":"1662647","title":"Ms","lastname":"Dale","firstname":"Sangeeta","companyname":"Cambodian Children's Fund (HK) Ltd.","email":"sangeeta.dale@cambodianchildrensfund.org","tel":"67407450","address":"Unit A-C, 16\/F, Tak Lee Comm Bldg, 113-117 Wanchai Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-18","renew_room_key":"054,03671,055,13304","renew_remark":"6 months contract. Storage rental paid by cheque deposit on May 22, 2019. Storage deposit $1856 transferred from agreement A12-CT183590 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195057, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"15","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"15","room_code":"A15","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11220,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2019-11-18","rent_from":"2019-11-18","rent_to":"2020-11-17","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 22, 2020. Storage deposit $1856 transferred from agreement A12-CT195057 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":11220,"final_order_total":11220,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,03671,055,13304","order_product":[],"pass":true}},"first_order_id":"3590","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA15 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"935.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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",444,"NEW","A12-CT207029",1098,935,0,0,"12","12",11220,11220,11220,"2020-01-23 11:47:26","0",null,null,null,"2019-11-18","2020-11-17","12 months contract. Special offer $300 Maxim's voucher. Storage rental paid by cheque deposit on January 22, 2020. Storage deposit $1856 transferred from agreement A12-CT195057 to this agreement.","2019-11-18","16",0,null,0,"0.00","2","2020-01-23 11:47:26","2","2020-01-23 11:47:26","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,03671,055,13304","C170444","BUSINESS","Ms","baqPHkhyjA+gb5jcNH6kYw==","8ctkNG8Qgdbh3xTuOMkQcg==","Cambodian Children's Fund (HK) Ltd.","Kw7rp5IomU+CcsEyt4WEU5YTqu4DtDu1s1mdMV5R6Fy6zOHoIRzjMBMdXWe2kS5aoM2sJ7Nbot6tkKQlJSTpanr8auq2ISnINmRqQhmq\/0Q=","ArHjWrLaeo\/vHHKM7fVv8Q==","DTcQapAEnTC0j91WOLKFUnw8RcNA+Dz\/Om+ej1ciyTgWD1JRL9JdUmSKBIcaSBpT",null,"v2fM8fRRNgWmY38DHfeaBQ==",1,"3590"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7029","73","8","15","%","16.85",185.013,"2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7029","15","1098.0",913,"2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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-18","2020-11-17","15"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 11:47:26","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":["7029",444,"SETTLED","A12-I207357","2020-01-23 11:47:26","2019-11-18","2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",7,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",8,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",9,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",10,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",11,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7357","RENT","\u9810\u7e73\u79df\u91d1",12,935,"MO","1",935,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11220,0,"7357"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 11:47:26","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":[444,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207006","2020-01-23 11:47:26",11220,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7006","DEPOSIT",null,"PAID","2020-01-23 11:47:26",0,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 11:47:26","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":["7006","INVOICE","7357","PAID","2020-01-23 11:47:26",11220,"2","2020-01-23 11:47:26","2","2020-01-23 11:47:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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=786&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":352,"customer_code":"C170352","identity_type":"PERSONAL","identity_id":"D191319(1)","title":"Mr","lastname":"Wong","firstname":"Wai Tung","companyname":"","email":null,"tel":"93328739","address":"\u9999\u6e2f\u4ed4\u7530\u7063\u6f01\u7372\u88571B\u5730\u4e0b","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-19","renew_room_key":"137,15409","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196445 to this agreement.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tG04 4X5X8 $1528.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"1205.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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",352,"NEW","A12-CT207030",1528,1205,0,0,"3","3",3615,3615,3615,"2020-01-23 12:06:36","0",null,null,null,"2020-01-19","2020-04-18","3 month contract. Storage rental paid by bank transfer on January 23, 2020. Storage deposit transferred from agreement A12-CT196768 to this agreement.\r\n","2020-01-19","20",0,null,0,"0","2","2020-01-23 12:06:36","2","2020-01-23 12:06:36","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,15409","C170352","PERSONAL","Mr","pWrJOV90xuuT\/EsMi5zpRQ==","hULSwM2MvFtpeV9\/z+er8Q==","","43c0wx7jnHnQaf25o1D24omsNW+NEZgIX2w74kCKE40OIxx1GWQaur5hnqjVXQj2","H2VJhOiErpJD6+CKFX26Dg==",null,"XHOvAEI8sL85yYAiFwYkGw==",null,1,"4204"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7030","203","10","363","%","5.00",76.4,"2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7030","363","1528.0",1451.6,"2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-19","2020-04-18","363"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 12:06:36","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":["7030",352,"SETTLED","A12-I207358","2020-01-23 12:06:36","2020-01-19","2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7358","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7358","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7358","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"7358"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 12:06:36","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":[352,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207007","2020-01-23 12:06:36",3615,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7007","DEPOSIT",null,"PAID","2020-01-23 12:06:36",0,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 12:06:36","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":["7007","INVOICE","7358","PAID","2020-01-23 12:06:36",3615,"2","2020-01-23 12:06:36","2","2020-01-23 12:06:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32:10","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&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1170,"customer_code":"C191170","identity_type":"PERSONAL","identity_id":"K426537(8)","title":"Mr","lastname":"Leung","firstname":"Cheuk Kin Peter","companyname":"","email":"ckpleung@gmail.com","tel":"91956031","address":"Flat 415, Blk. D, Kornhill, 19 Hong Shing St, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"HSBC","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"578.0","renew_rent_month":"12","renew_warehousing_date":"2020-01-09","renew_room_key":"0005796879","renew_remark":"12 months contract. Special promotion offered, 2 months free of charge. Storage rental and deposit paid by Cheque on 8 JAN 2019. Smartcard provided on 8 JAN 2019.\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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tC15-020 4X3X6.5 $810.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"729.00","deposit":"0.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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","3","6",1170,"NEW","C15-CT207031",810,729,0,0,"6","6",4374,4374,4374,"2020-01-23 13:32:11","0",null,null,null,"2020-01-09","2020-07-08","6 months contract. Storage rental paid by bank transfer on Jan 23,2020. Deposit $810 transferred from agreement C15-CT194127 to this agreement.","2020-01-09","12",0,null,0,"0","2","2020-01-23 13:32:10","2","2020-01-23 13:32:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005796879","C191170","PERSONAL","Mr","onFpygDlp7QMdiHELSDrtw==","xEf2h2aoyRQ71ZVgBH+9WQ==","","W6Cb+QcuqMkU1Lk8zZT9NEQwlFLuG+vNTTbabAvD1ZofvXgVxA4Xzl78kA4dHtXbL8Y4TANJaAebQFao8Ga\/Vg==","mdIZh4C4CIGu799lBnyElw==","1M\/dd65p5lwuK+EOCSCR+YmZ5bIukEhicMk+wYxfH00=","Xkrqdqh3gtr\/asAhkX26Ug==",null,1,4127]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32:11","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":["7031","407","167","1326","%","24.84",201.204,"2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7031","1326","810.0",608.8,"2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["2020-01-09","2020-07-08","1326"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 13:32: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":["7031",1170,"SETTLED","C15-I207359","2020-01-23 13:32:10","2020-01-09","2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7359","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4374,0,"7359"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 13:32: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":[1170,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207008","2020-01-23 13:32:10",4374,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7008","DEPOSIT",null,"PAID","2020-01-23 13:32:10",0,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:32: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":["7008","INVOICE","7359","PAID","2020-01-23 13:32:10",4374,"2","2020-01-23 13:32:10","2","2020-01-23 13:32:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:58:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 13:58:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:02:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:53","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","floor_plan_rent_room":[{"room_id":"1477","master_room_id":"173","room_code":"C15-171"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tC15-171 4X6X6.5 $1322.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"R932091(0)","title":"Ms","lastname":"Saeyang","firstname":"Ninratt","companyname":"","email":"ninratt@hotmail.com","tel":"97612944","address":"Flat F, 7\/F, King's House, 971 King'd Rd","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"443","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"991.90","discount":"24.97","monthly_deduct":330.1034,"room_id":"1477","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1477","room_code":"C15-171","retail_price":"1322.0","discounted_price":991.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1190,"deposit":1322,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12432,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3170","warehousing_date":"2020-02-29","rent_from":"2020-02-29","rent_to":"2021-02-28","delivery_service":"1","delivery_date":"2020-02-29","delivery_from":"Flat F, 7\/F, King's House, 971 King'd Rd","delivery_to":"\u7063\u5229\u773e\u885734\u865f\u5bf6\u6e90(\u6771\u4e1e)\u5de5\u696d\u5927\u5ec815\u6a13","remark":"12 months contract. Special offer the 11th and 12th month free. 5% rent now discount and $200 referral bonus. Storage rental and deposit paid by EPS on Jan23,2020. Smart card paid by EPS on Jan23,2020.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":3170,"order_total":15722,"final_order_total":12552,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012488468, 000576009","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"2","price":"60.0"}],"pass":true}},"roughly_size":"24","total_discounted_price":"1190.00","deposit":"1322.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201495","PERSONAL","Ms","Vbgo4+Abf\/JTpFzErCiDFg==","T5sXoMUcJ\/tE6wGD440NWw==","","vTKfo48S1zFtJ3NPpirQMw==","7\/uC\/bALaYpZYGeIcALdJ0ikNuS5Pc4270JDECQiRIo=","HCHWe3rWbFoiEjFiJretn0\/o8BodaVuCKQE9jmpK9ue2Dnevzf9N1woZNggV6xqy","HdXBbarO6alJKx5zDwzxiA==",null,"7\/uC\/bALaYpZYGeIcALdJ0ikNuS5Pc4270JDECQiRIo=","Fg2eacxQni2KMv4vd9g4gA==","2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6",1495,"NEW","C15-CT207032",1322,1190,1322,0,"12","12",12432,15722,12552,"2020-01-23 14:07:55","1","2020-02-29","Flat F, 7\/F, King's House, 971 King'd Rd","\u7063\u5229\u773e\u885734\u865f\u5bf6\u6e90(\u6771\u4e1e)\u5de5\u696d\u5927\u5ec815\u6a13","2020-02-29","2021-02-28","12 months contract. Special offer the 11th and 12th month free. 5% rent now discount and $200 referral bonus. Storage rental and deposit paid by EPS on Jan23,2020. Smart card paid by EPS on Jan23,2020.","2020-02-29","24",0,null,3170,"3170","2","2020-01-23 14:07:53","2","2020-01-23 14:07:53","EPS","","","","EPS","","","",null,0,"0012488468, 000576009","C201495","PERSONAL","Ms","Vbgo4+Abf\/JTpFzErCiDFg==","T5sXoMUcJ\/tE6wGD440NWw==","","HCHWe3rWbFoiEjFiJretn0\/o8BodaVuCKQE9jmpK9ue2Dnevzf9N1woZNggV6xqy","vTKfo48S1zFtJ3NPpirQMw==","7\/uC\/bALaYpZYGeIcALdJ0ikNuS5Pc4270JDECQiRIo=","HdXBbarO6alJKx5zDwzxiA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7032","443","173","1477","%","24.97",330.1034,"2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7032",1495,"11","2","60.0",120,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[120,"7032"]},"data_before":[],"data_after":[],"step":4}
*****
{"created_at":"2020-01-23 14:07:55","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":["7032","1477","1322.0",991.9,"2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-29","2021-02-28","1477"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7032","C15-D205265","PAID",1322,0,"2021-02-28","2020-01-23 14:07:53","2020-01-23 14:07:53","2","2020-01-23 14:07:53","2","2020-01-23 14:07:53",1495]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7032",1495,"SETTLED","C15-I207360","2020-01-23 14:07:53","2020-02-29","2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,400,"MO","1",400,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",4,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",5,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",6,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",7,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",8,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",9,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",10,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",11,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7360","RENT","\u9810\u7e73\u79df\u91d1",12,1190,"MO","1",1190,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7360","ORDER_PRODUCT","60.0","PCS","2",120,"11","2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11230,0,"7360"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 14:07:55","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":[1495,"EPS","","","","EPS","","","","PAID","P207009","2020-01-23 14:07:53",12552,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7009","DEPOSIT","5265","PAID","2020-01-23 14:07:53",1322,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:07:55","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":["7009","INVOICE","7360","PAID","2020-01-23 14:07:53",11230,"2","2020-01-23 14:07:53","2","2020-01-23 14:07:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 14:39:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:02:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:40:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:54:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:46","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=1&filter2=246&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":246,"customer_code":"C160246","identity_type":"PERSONAL","identity_id":"E669410(5)","title":"Ms","lastname":"Wong","firstname":"Yin Ping","companyname":"","email":"julianawyp@Yahoo.com.hk","tel":"90323387","address":"Flat H,5\/F Block 17,Mei Fai Court South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-22","renew_room_key":"052,34362","renew_remark":"6 months contract. Storage rental paid by PPS on July 22, 2019. Storage deposit transferred from agreement A12-CT194191 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195547, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"66","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"66","room_code":"B14","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":935,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5610,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-07-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195547 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,34362","order_product":[],"pass":true}},"first_order_id":"4191","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tB14 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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",246,"NEW","A12-CT207033",1098,935,0,0,"6","6",5610,5610,5610,"2020-01-23 16:56:47","0",null,null,null,"2020-01-22","2020-07-21","6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195547 to this agreement.","2020-01-22","16",0,null,0,"0","2","2020-01-23 16:56:46","2","2020-01-23 16:56:46","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,34362","C160246","PERSONAL","Ms","LCid1COB1tg1mUcapCB6rQ==","hULSwM2MvFtpeV9\/z+er8Q==","","mIObWhb+7J95Mma1wUdAxoEb8M1GhMGp+3ltd6fEdjXnp1Ej3W+y+RlXRHD43h49kFRl88dNpK7qn8uKBVI1Aw==","yUxNpsMAehInxJPXm3Rl+w==","3ehLEnyTfV7S1FEVZ79XrDueuYsRx3WCndmjcVkU8ng=","5TdeaNCK8VIoKrSgD46SvA==",null,1,"4191"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7033","72","8","66","%","9.93",109.0314,"2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7033","66","1098.0",989,"2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-07-21","66"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 16:56:47","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":["7033",246,"SETTLED","A12-I207361","2020-01-23 16:56:46","2020-01-22","2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7361","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"7361"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 16:56:47","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":[246,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207010","2020-01-23 16:56:46",5610,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7010","DEPOSIT",null,"PAID","2020-01-23 16:56:46",0,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:56:47","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":["7010","INVOICE","7361","PAID","2020-01-23 16:56:46",5610,"2","2020-01-23 16:56:46","2","2020-01-23 16:56:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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=1&filter2=246&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":246,"customer_code":"C160246","identity_type":"PERSONAL","identity_id":"E669410(5)","title":"Ms","lastname":"Wong","firstname":"Yin Ping","companyname":"","email":"julianawyp@Yahoo.com.hk","tel":"90323387","address":"Flat H,5\/F Block 17,Mei Fai Court South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1788.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-22","renew_room_key":"052,34362","renew_remark":"6 months contract. Storage rental paid by PPS on July 22, 2019. Storage deposit transferred from agreement A12-CT194190 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195548, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"188","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"177","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"177","room_code":"C53","retail_price":"1098.0","discounted_price":989,"location_id":"1"},{"room_id":"188","room_code":"C64","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1788,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10728,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-22","rent_from":"2020-01-22","rent_to":"2020-07-21","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195548 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10728,"final_order_total":10728,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,34362","order_product":[],"pass":true}},"first_order_id":"4190","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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tC53 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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\tC64 4X4X8 $1098.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"2020-01-23 16:58:46","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",246,"NEW","A12-CT207034",2196,1788,0,0,"6","6",10728,10728,10728,"2020-01-23 16:58:46","0",null,null,null,"2020-01-22","2020-07-21","6 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit transferred from agreement A12-CT195548 to this agreement.","2020-01-22","32",0,null,0,"0","2","2020-01-23 16:58:46","2","2020-01-23 16:58:46","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"052,34362","C160246","PERSONAL","Ms","LCid1COB1tg1mUcapCB6rQ==","hULSwM2MvFtpeV9\/z+er8Q==","","mIObWhb+7J95Mma1wUdAxoEb8M1GhMGp+3ltd6fEdjXnp1Ej3W+y+RlXRHD43h49kFRl88dNpK7qn8uKBVI1Aw==","yUxNpsMAehInxJPXm3Rl+w==","3ehLEnyTfV7S1FEVZ79XrDueuYsRx3WCndmjcVkU8ng=","5TdeaNCK8VIoKrSgD46SvA==",null,1,"4190"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7034","72","8","188","%","9.93",109.0314,"2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7034","72","8","177","%","9.93",109.0314,"2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7034","177","1098.0",989,"2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-07-21","177"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 16:58:46","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":["7034","188","1098.0",989,"2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-22","2020-07-21","188"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 16:58:46","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":["7034",246,"SETTLED","A12-I207362","2020-01-23 16:58:46","2020-01-22","2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",1,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",2,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",3,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",4,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",5,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7362","RENT","\u9810\u7e73\u79df\u91d1",6,1788,"MO","1",1788,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10728,0,"7362"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 16:58:46","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":[246,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207011","2020-01-23 16:58:46",10728,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7011","DEPOSIT",null,"PAID","2020-01-23 16:58:46",0,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 16:58:46","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":["7011","INVOICE","7362","PAID","2020-01-23 16:58:46",10728,"2","2020-01-23 16:58:46","2","2020-01-23 16:58:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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=1&filter2=246&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1190,"customer_code":"C191190","identity_type":"PERSONAL","identity_id":"Y542390(0)","title":"Ms","lastname":"YAU","firstname":"Hoi Ching","companyname":"","email":"hoichingyau@yahoo.com.hk","tel":"98286010","address":"Flat 2703, 27\/F, Hoi Tin Court, Aberdeen Centre, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1342.0","renew_rent_month":"3","renew_warehousing_date":"2019-11-02","renew_room_key":"088,29636","renew_remark":"3 months contract. Storage rental and deposit paid by bank transfer on October 18,2019. Storage deposit $2684 transferred from agreement A14-CT195363 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196197, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"471","room_code":"K08(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1342,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4026,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-02","rent_from":"2019-11-02","rent_to":"2020-02-01","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by PPS on January 21, 2020. Storage deposit transferred from agreement A14-CT196197 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4026,"final_order_total":4026,"location_id":"2","branch_id":"1","company_id":"1","room_key":"088,29636","order_product":[],"pass":true}},"first_order_id":6197,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tK08(\u670d\u88dd\u5009) 4X4X8 $1342.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"1342.0","deposit":"0","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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",1190,"NEW","A14-CT207035",1342,1342,0,0,"3","3",4026,4026,4026,"2020-01-23 17:04:52","0",null,null,null,"2019-11-02","2020-02-01","3 months contract. Storage rental and deposit paid by PPS on January 21, 2020. Storage deposit transferred from agreement A14-CT196197 to this agreement.","2019-11-02","16",0,null,0,"0","2","2020-01-23 17:04:52","2","2020-01-23 17:04:52","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"088,29636","C191190","PERSONAL","Ms","6xj4DbIC8gpxDREqt\/B+EA==","UVY\/HEZSKUPvom9zK4XPwQ==","","2DxST9L++AVFDrp9kqOR+yNcCTgvrEFAbuJgJ13c5xMM6Bt6nxgGJLr69i4wti8HSiFkei69OG3Sr5mAjbh9ww==","iYQqKb+DhKHyc7lRAXgFTQ==","ta5gSuJOiqrW0ihrVIPASVaAT6MyRLxzqFuCiH8tgNQ=","KjAi6kd8noXu\/72l80Vugg==",null,1,6197]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7035","471","1342.0","1342.00","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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-02","2020-02-01","471"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 17:04:52","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":["7035",1190,"SETTLED","A14-I207363","2020-01-23 17:04:52","2019-11-02","2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7363","RENT","\u9810\u7e73\u79df\u91d1",1,1342,"MO","1",1342,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7363","RENT","\u9810\u7e73\u79df\u91d1",2,1342,"MO","1",1342,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7363","RENT","\u9810\u7e73\u79df\u91d1",3,1342,"MO","1",1342,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4026,0,"7363"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 17:04:52","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":[1190,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207012","2020-01-23 17:04:52",4026,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7012","DEPOSIT",null,"PAID","2020-01-23 17:04:52",0,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:04:52","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":["7012","INVOICE","7363","PAID","2020-01-23 17:04:52",4026,"2","2020-01-23 17:04:52","2","2020-01-23 17:04:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:28","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=1&filter2=246&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1190,"customer_code":"C191190","identity_type":"PERSONAL","identity_id":"Y542390(0)","title":"Ms","lastname":"YAU","firstname":"Hoi Ching","companyname":"","email":"hoichingyau@yahoo.com.hk","tel":"98286010","address":"Flat 2703, 27\/F, Hoi Tin Court, Aberdeen Centre, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1857.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-01","renew_room_key":"","renew_remark":"1 month contract. Change unit from K08 to A16-033. Storage deposit $2684 transferred from agreement A14-CT196197 to this agreement. Remaining balance $2887 paid by bank transfer on Nov 01,2019. Padlock provided on Oct 30,2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT196282, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"205","order_discount":[],"order_room":[{"room_id":"1524","room_code":"A16-033","retail_price":"1857.0","discounted_price":"1857.00","location_id":"7"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1857,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5571,"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-02-29","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit $3714 transferred from agreement A16-CT196282 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":5571,"final_order_total":5571,"location_id":"7","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":6282,"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\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA16-033 4X6X7 $1857.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"24","total_discounted_price":"1857.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:28","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","7",1190,"NEW","A16-CT207036",1857,1857,0,0,"3","3",5571,5571,5571,"2020-01-23 17:09:28","0",null,null,null,"2019-12-01","2020-02-29","3 months contract. Storage rental paid by PPS on January 21, 2020. Storage deposit $3714 transferred from agreement A16-CT196282 to this agreement. ","2019-12-01","24",0,null,0,"0","2","2020-01-23 17:09:28","2","2020-01-23 17:09:28","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"","C191190","PERSONAL","Ms","6xj4DbIC8gpxDREqt\/B+EA==","UVY\/HEZSKUPvom9zK4XPwQ==","","2DxST9L++AVFDrp9kqOR+yNcCTgvrEFAbuJgJ13c5xMM6Bt6nxgGJLr69i4wti8HSiFkei69OG3Sr5mAjbh9ww==","iYQqKb+DhKHyc7lRAXgFTQ==","ta5gSuJOiqrW0ihrVIPASVaAT6MyRLxzqFuCiH8tgNQ=","KjAi6kd8noXu\/72l80Vugg==",null,1,6282]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:28","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":["7036","1524","1857.0","1857.00","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:28","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-02-29","1524"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 17:09:29","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":["7036",1190,"SETTLED","A16-I207364","2020-01-23 17:09:28","2019-12-01","2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","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":["7364","RENT","\u9810\u7e73\u79df\u91d1",1,1857,"MO","1",1857,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","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":["7364","RENT","\u9810\u7e73\u79df\u91d1",2,1857,"MO","1",1857,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","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":["7364","RENT","\u9810\u7e73\u79df\u91d1",3,1857,"MO","1",1857,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5571,0,"7364"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 17:09:29","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":[1190,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207013","2020-01-23 17:09:28",5571,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","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":["7013","DEPOSIT",null,"PAID","2020-01-23 17:09:28",0,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:09:29","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":["7013","INVOICE","7364","PAID","2020-01-23 17:09:28",5571,"2","2020-01-23 17:09:28","2","2020-01-23 17:09:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:16:01","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:43:49","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["VOID","189,51803","13 months contract. special offer the 13th month free. First month storage rental and deposit $1734 paid by cash on 9 January 2020. Balance $7652 paid by cash on 10 January 2020. Smart card provided on Jan 10,2020.\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n","2020-01-23 17:43:49","2","Q+PorclQj7jE8TlwKMO7YA==","K2KrE1o44++lBMjvhOt77g==","YMxM5yBElK7kyXIRndAgGQ==","5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5M76ndaBdCu2lZX45PANDQV3YsCZ5P2jerPOmNGH414JQ==","Galiat Electronics Limited",6911]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:53","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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\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\r\n\t\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> \r\n\t\t\t\t\tA16-017 4X2X3.5 $598.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"70722040-000-05-19-3","title":"Mr","lastname":"Lika","firstname":"Mr","companyname":"Galiat Electronics Limited","email":"","tel":"+33762106242","address":"Flat C, Level 7 World Trust Tower, 50 Stanley Street, Central","pass":true,"customer_id":"1486","customer_code":"C201486","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1508","room_code":"A16-017","retail_price":"598.0","discounted_price":"598.00","location_id":"7"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":7652,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"538.00","warehousing_date":"2020-01-09","rent_from":"2020-01-09","rent_to":"2021-02-08","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage $250 paid by cash on January 9, 2020. Remaining balance $7402 paid by bank transfer on January 23, 2020. Smartcard and padlock provided on January 9, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":538,"order_total":8190,"final_order_total":7652,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,51803","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1486","NEW","A16-CT207037",598,538,1196,0,"13","13",7652,8190,7652,"2020-01-23 17:49:54","0",null,null,null,"2020-01-09","2021-02-08","13 months contract. Special offer the 13th month free. Storage $250 paid by cash on January 9, 2020. Remaining balance $7402 paid by bank transfer on January 23, 2020. Smartcard and padlock provided on January 9, 2020. ","2020-01-09","8",0,null,538,"538.00","2","2020-01-23 17:49:53","2","2020-01-23 17:49:53","BANKIN","","","","BANKIN","","","",null,0,"189,51803","C201486","BUSINESS","Mr","uUmG+7bwaQqrpbWycwrVZg==","Q+PorclQj7jE8TlwKMO7YA==","Galiat Electronics Limited","5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5M76ndaBdCu2lZX45PANDQV3YsCZ5P2jerPOmNGH414JQ==","x1hUiho17\/Bu1ANX2tAO1A==",null,null,"\/uxtJWJNOACYEDwuMgubWnrjg2EH+Cw\/lre3fq03Fmk="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7037","1508","598.0","598.00","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2021-02-08","1508"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 17:49:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7037","A16-D205266","PAID",1196,0,"2021-02-08","2020-01-23 17:49:53","2020-01-23 17:49:53","2","2020-01-23 17:49:53","2","2020-01-23 17:49:53","1486"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7037","1486","SETTLED","A16-I207365","2020-01-23 17:49:53","2020-01-09","2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7365","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7365"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 17:49:54","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":["1486","BANKIN","","","","BANKIN","","","","PAID","P207014","2020-01-23 17:49:53",7652,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7014","DEPOSIT","5266","PAID","2020-01-23 17:49:53",1196,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:49:54","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":["7014","INVOICE","7365","PAID","2020-01-23 17:49:53",6456,"2","2020-01-23 17:49:53","2","2020-01-23 17:49:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59: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=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1508","master_room_id":"196","room_code":"A16-017"}],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"1","identity_type":"BUSINESS","identity_id":"70743694","title":"Mr","lastname":"Lika","firstname":"Mr","companyname":"Avptech Innovation Limited","email":"","tel":"33762106242","address":"Flat C, Level 7 World Trust Tower, 20 Stanley Street, Central, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1516","room_code":"A16-025","retail_price":"598.0","discounted_price":"598.00","location_id":"7"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":1196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":7652,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"538.00","warehousing_date":"2020-01-09","rent_from":"2020-01-09","rent_to":"2021-02-08","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage $250 paid by cash on January 9, 2020. Remaining balance $7402 paid by bank transfer on January 23, 2020. Smartcard and padlock provided on January 9, 2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":538,"order_total":8190,"final_order_total":7652,"location_id":"7","branch_id":"1","company_id":"1","room_key":"189,51803","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n \n \n \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> \n\t\t\t\t\tA16-025 4X2X3.5 $598.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"8","total_discounted_price":"538.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:49","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201496","BUSINESS","Mr","uUmG+7bwaQqrpbWycwrVZg==","Q+PorclQj7jE8TlwKMO7YA==","Avptech Innovation Limited","YMxM5yBElK7kyXIRndAgGQ==",null,"5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5OdeUznxZ6OWF3SntF8oSOQJ8yrZ1+BpOYqB2Vj7kQjDSUgq8Bg9UYGCnX1h4tskfM=",null,"yatl19aJCvGO52TbeWlLMA==",null,"ZBK3y35sLDcfdW6p+Jlmig==","2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1496,"NEW","A16-CT207038",598,538,1196,0,"13","13",7652,8190,7652,"2020-01-23 17:59:50","0",null,null,null,"2020-01-09","2021-02-08","13 months contract. Special offer the 13th month free. Storage $250 paid by cash on January 9, 2020. Remaining balance $7402 paid by bank transfer on January 23, 2020. Smartcard and padlock provided on January 9, 2020. ","2020-01-09","8",0,null,538,"538.00","2","2020-01-23 17:59:48","2","2020-01-23 17:59:48","BANKIN","","","","BANKIN","","","",null,0,"189,51803","C201496","BUSINESS","Mr","uUmG+7bwaQqrpbWycwrVZg==","Q+PorclQj7jE8TlwKMO7YA==","Avptech Innovation Limited","5mrb3JNeyV477mH0\/O\/jIZrjrJEPQ5B\/Oax+Fv1fX5OdeUznxZ6OWF3SntF8oSOQJ8yrZ1+BpOYqB2Vj7kQjDSUgq8Bg9UYGCnX1h4tskfM=","YMxM5yBElK7kyXIRndAgGQ==",null,null,"yatl19aJCvGO52TbeWlLMA=="]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7038","1516","598.0","598.00","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-09","2021-02-08","1516"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-01-23 17:59:50","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["7038","A16-D205267","PAID",1196,0,"2021-02-08","2020-01-23 17:59:48","2020-01-23 17:59:48","2","2020-01-23 17:59:48","2","2020-01-23 17:59:48",1496]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7038",1496,"SETTLED","A16-I207366","2020-01-23 17:59:48","2020-01-09","2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7366","RENT","\u9810\u7e73\u79df\u91d1",13,538,"MO","1",538,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"7366"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-01-23 17:59:50","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":[1496,"BANKIN","","","","BANKIN","","","","PAID","P207015","2020-01-23 17:59:48",7652,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7015","DEPOSIT","5267","PAID","2020-01-23 17:59:48",1196,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-01-23 17:59:50","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":["7015","INVOICE","7366","PAID","2020-01-23 17:59:48",6456,"2","2020-01-23 17:59:48","2","2020-01-23 17:59:48"]},"data_before":[],"data_after":[],"step":1}
*****