{"created_at":"2019-12-09 10:16:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:02","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=1142&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1142,"customer_code":"C181142","identity_type":"BUSINESS","identity_id":"5301367200008188","title":"Mr","lastname":"LI","firstname":"Douglas","companyname":"East Oriental Limited","email":"hkdougli@gmail.com","tel":"90184563","address":"Flat\/Rm 502, 5\/F, Hing Yip Commercial Centre","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-10","renew_room_key":"7315674","renew_remark":"12 months contract, storage rental and deposit paid by EPS on Dec 4, 2018. Smart Card provided on Dec 4,2018\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183860, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"110","order_discount":[{"master_room_discount_id":"476","master_room_id":"110","discount_type":"%","price":"598.00","disocunted_price":"497.00","discount":"16.89","monthly_deduct":101.0022,"room_id":"1085","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1085","room_code":"A05-083","retail_price":"598.0","discounted_price":497,"location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6456,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-10","rent_from":"2019-12-10","rent_to":"2020-12-09","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on December 9, 2019. Storage deposit $1196 transferred from agreement A05-CT183860 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":6456,"final_order_total":6456,"location_id":"4","branch_id":"1","company_id":"1","room_key":"7315674","order_product":[],"pass":true}},"first_order_id":3860,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-083 <\/td>\r\n\t\t\t\t\t	4X2X3.5 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"538.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1142,"NEW","A05-CT196638",598,538,0,0,"12","12",6456,6456,6456,"2019-12-09 10:19:03","0",null,null,null,"2019-12-10","2020-12-09","12 months contract. Storage rental paid by cheque on December 9, 2019. Storage deposit $1196 transferred from agreement A05-CT183860 to this agreement. ","2019-12-10","8",0,null,0,"0","2","2019-12-09 10:19:02","2","2019-12-09 10:19:02","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"7315674","C181142","BUSINESS","Mr","u5M1NXJIjztdYYHk7Vwmrg==","hbkan9PC5SCnBxQh2lhA4w==","East Oriental Limited","mbd6d22LzsoYeO6I3CPKClNDas+myViO5lyEXF\/a7G\/ghCr+fRc2kyiAmiDJJSTd","5NsypTXMPdzdYwRktvxtcg==","Mi\/PlBRvEn5Ku8k9CI0uYJyGWOcT0aNDkEhHSRNcnbQ=",null,"\/fJNrB3RVTitNCE2HZnniH5lnhsAvQn93h825JXIprU=",1,3860]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6638","476","110","1085","%","16.89",101.0022,"2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6638","1085","598.0",497,"2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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-10","2020-12-09","1085"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 10:19:03","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":["6638",1142,"SETTLED","A05-I196966","2019-12-09 10:19:02","2019-12-10","2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",7,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",8,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",9,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",10,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",11,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6966","RENT","\u9810\u7e73\u79df\u91d1",12,538,"MO","1",538,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6456,0,"6966"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 10:19:03","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":[1142,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196616","2019-12-09 10:19:02",6456,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6616","DEPOSIT",null,"PAID","2019-12-09 10:19:02",0,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 10:19:03","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":["6616","INVOICE","6966","PAID","2019-12-09 10:19:02",6456,"2","2019-12-09 10:19:02","2","2019-12-09 10:19:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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=1142&filter3=undefined&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":601,"customer_code":"C170601","identity_type":"PERSONAL","identity_id":"D430946(5)","title":"Mr","lastname":"Lee","firstname":"Kim Wah","companyname":"","email":"shaunlee231@hotmail.com","tel":"92603657","address":"Flat D, 9\/F, Block 6, East Point City, Chung Wah Road, Tseung Kwan O, New Territories, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-08","renew_room_key":"054,47534","renew_remark":"12 months contract. Storage rental paid by bank transfer on December 7, 2018. Storage deposit transferred form agreement SD18-CT182258 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT183847, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"850","room_code":"S09","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2019-12-08","rent_from":"2019-12-08","rent_to":"2021-01-07","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred form agreement A18-CT183847 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,47534","order_product":[],"pass":true}},"first_order_id":3847,"selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> S09 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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","3",601,"NEW","A18-CT196639",1290,1162,0,0,"13","13",13944,15106,13944,"2019-12-09 11:56:42","0",null,null,null,"2019-12-08","2021-01-07","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred form agreement A18-CT183847 to this agreement.","2019-12-08","16",0,null,1162,"1162.00","2","2019-12-09 11:56:42","2","2019-12-09 11:56:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,47534","C170601","PERSONAL","Mr","SM\/lo7FmXd4FLKHbntdnZg==","kiriEIqhcx866RNZiMXdKQ==","","TiHfFzXYIEBQVJJKJPz\/eqGtm\/Q+PejZVOYfbd7Gya+UFg4vX2\/Vuzvs03lstNs4HSbm16IIHPJXtUH3F4SkgX5b5XWAxKmyWGGj\/XRjHKARfw5jvB4s4P7qtkD8uN1X","619Ra9DlZ7kR2R\/lyuquRQ==","v16XV87KdtCSlKcZfA5Um9Wj5x4X0MezfSUhfUXPmkg=","Yi77IggaZqgVF0IvHvuakg==",null,1,3847]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6639","850","1290.0","1290.00","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-08","2021-01-07","850"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 11:56:42","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":["6639",601,"SETTLED","A18-I196967","2019-12-09 11:56:42","2019-12-08","2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6967","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"6967"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 11:56:42","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":[601,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196617","2019-12-09 11:56:42",13944,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6617","DEPOSIT",null,"PAID","2019-12-09 11:56:42",0,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 11:56:42","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":["6617","INVOICE","6967","PAID","2019-12-09 11:56:42",13944,"2","2019-12-09 11:56:42","2","2019-12-09 11:56:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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=1142&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":379,"customer_code":"C170379","identity_type":"PERSONAL","identity_id":"D555977(5)","title":"Ms","lastname":"Yuen","firstname":"Fung Ha Karen","companyname":"","email":null,"tel":"91300308","address":"17E Block1, Ocean Court, 3 Aberdeen Praya Rd HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2843.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-03","renew_room_key":"052,33383,189,02122","renew_remark":"6 months contract. Storage rental paid by cheque on May 2, 2019 Storage deposit transferred from agreement A14-CT183438 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194899, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"675","room_code":"M86","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"674","room_code":"M85","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"664","room_code":"M75","retail_price":"998.0","discounted_price":"998.00","location_id":"2"},{"room_id":"663","room_code":"M74","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"48","total_retail_price":3992,"total_discounted_price":2843,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":17058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-03","rent_from":"2019-11-03","rent_to":"2020-05-02","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on November 7, 2019 Storage deposit transferred from agreement A14-CT194899 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":17058,"final_order_total":17058,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,33383,189,02122","order_product":[],"pass":true}},"first_order_id":"3438","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M86 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M85 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M75 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> M74 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"48","total_discounted_price":"2843.0","deposit":"0","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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",379,"NEW","A14-CT196640",3992,2843,0,0,"6","6",17058,17058,17058,"2019-12-09 12:26:05","0",null,null,null,"2019-11-03","2020-05-02","6 months contract. Storage rental paid by bank transfer on November 7, 2019 Storage deposit transferred from agreement A14-CT194899 to this agreement.","2019-11-03","48",0,null,0,"0","2","2019-12-09 12:26:05","2","2019-12-09 12:26:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,33383,189,02122","C170379","PERSONAL","Ms","ni+qPf73wjcZnPbVR\/7E8A==","DtbrOSvE4C7BOu5x4dBFtg==","","VEbgw0ofsh3mTWSdMwGnnZRca7CDvNbzucQw9EsCNKcl3ez0efcX77jUiAkFnkhl","nCmEpjNq7exSxaQGv0GSHw==",null,"gm6fURx1\/Hi1kWQBp0ULng==",null,1,"3438"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6640","675","998.0","998.00","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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-03","2020-05-02","675"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 12:26:05","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":["6640","674","998.0","998.00","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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-03","2020-05-02","674"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 12:26:05","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":["6640","664","998.0","998.00","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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-03","2020-05-02","664"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 12:26:05","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":["6640","663","998.0","998.00","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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-03","2020-05-02","663"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 12:26:05","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":["6640",379,"SETTLED","A14-I196968","2019-12-09 12:26:05","2019-11-03","2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",1,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",2,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",3,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",4,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",5,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6968","RENT","\u9810\u7e73\u79df\u91d1",6,2843,"MO","1",2843,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[17058,0,"6968"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 12:26:05","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":[379,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196618","2019-12-09 12:26:05",17058,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6618","DEPOSIT",null,"PAID","2019-12-09 12:26:05",0,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:26:05","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":["6618","INVOICE","6968","PAID","2019-12-09 12:26:05",17058,"2","2019-12-09 12:26:05","2","2019-12-09 12:26:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 12:54:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:40","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=1142&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":835,"customer_code":"C180835","identity_type":"PERSONAL","identity_id":"Z785866(4)","title":"Mr","lastname":"Wong","firstname":"Ka Hei","companyname":"","email":"sai_56@hotmail.com","tel":"61288759","address":"Room 2501, Hoi Tsing Court, Aberdeen Centre, Aberdeen, Hong Kong ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"986.0","renew_rent_month":"3","renew_warehousing_date":"2019-10-27","renew_room_key":"089,52338","renew_remark":"3 months contract. Storage rental paid by bank transfer on August 13, 2019. Storage deposit transferred from agreement A14-CT194984 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195713, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"728","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"728","room_code":"O04","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":986,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2958,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-27","rent_from":"2019-10-27","rent_to":"2020-01-26","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit transferred from agreement A14-CT195713 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2958,"final_order_total":2958,"location_id":"2","branch_id":"1","company_id":"1","room_key":"089,52338","order_product":[],"pass":true}},"first_order_id":"4316","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> O04 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"986.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",835,"NEW","A14-CT196641",998,986,0,0,"3","3",2958,2958,2958,"2019-12-09 13:32:41","0",null,null,null,"2019-10-27","2020-01-26","3 months contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit transferred from agreement A14-CT195713 to this agreement.","2019-10-27","12",0,null,0,"0","2","2019-12-09 13:32:40","2","2019-12-09 13:32:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"089,52338","C180835","PERSONAL","Mr","LFqFMec3FCZ8GhmGz5D8+g==","hULSwM2MvFtpeV9\/z+er8Q==","","YGGMv9qKSb2ZjuAc\/sccX3viQczI4UQgTDR1vnw1jZr1IsHI46aAzj8FoOEvmFBf3xid\/KPjKyMskq8nOAaxJP+T1Hiw+JblMx6sijbULuU=","WWWWtU89uJSFycKhvaRqjg==","ZsJ+TIjyArNzTB8u3qB6S4HXPjhNu85zzCV3p8sv97U=","+cVFuhdEwVJmEcDzIH6zTg==",null,1,"4316"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","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":["6641","470","34","728","%","4.91",49.0018,"2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6641","728","998.0",949,"2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-27","2020-01-26","728"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6641",835,"SETTLED","A14-I196969","2019-12-09 13:32:40","2019-10-27","2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6969","RENT","\u9810\u7e73\u79df\u91d1",1,986,"MO","1",986,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6969","RENT","\u9810\u7e73\u79df\u91d1",2,986,"MO","1",986,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6969","RENT","\u9810\u7e73\u79df\u91d1",3,986,"MO","1",986,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2958,0,"6969"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[835,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196619","2019-12-09 13:32:40",2958,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6619","DEPOSIT",null,"PAID","2019-12-09 13:32:40",0,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:32:41","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6619","INVOICE","6969","PAID","2019-12-09 13:32:40",2958,"2","2019-12-09 13:32:40","2","2019-12-09 13:32:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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=1142&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1255,"customer_code":"C191255","identity_type":"PERSONAL","identity_id":"R857926(0)","title":"Ms","lastname":"Mostashari","firstname":"Yas","companyname":"","email":"yass@mostashari.co.uk","tel":"96873290","address":"Flat A6, Guildford Court, 5 Guildford Road, The Peak, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3724.0","renew_rent_month":"6","renew_warehousing_date":"2019-10-29","renew_room_key":"076,34807","renew_remark":"6 months contract. Special offer of using prepay 6 months rate for monthly payment. First payment and storage deposit pay by bank transfer on or before April 29, 2019. Remaining storage rental $3724 will be paid by bank transfer on or before every 28th of month. Smartcard provided on April 26, 2019. Padlock keys provided on April 29, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194818, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $8276.0","renew_master_room_id":"34","order_discount":[{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"749","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"750","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"760","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"761","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"761","room_code":"O37","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"760","room_code":"O36","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"750","room_code":"O26","retail_price":"998.0","discounted_price":949,"location_id":"2"},{"room_id":"749","room_code":"O25","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3932,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":11796,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-29","rent_from":"2019-10-29","rent_to":"2020-01-28","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit $8276 transferred from agreement A14-CT194818 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11796,"final_order_total":11796,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,34807","order_product":[],"pass":true}},"first_order_id":4818,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> O37 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> O36 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> O26 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> O25 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"56","total_discounted_price":"3932.00","deposit":"0.00","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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",1255,"NEW","A14-CT196642",4192,3932,0,0,"3","3",11796,11796,11796,"2019-12-09 13:35:33","0",null,null,null,"2019-10-29","2020-01-28","3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit $8276 transferred from agreement A14-CT194818 to this agreement.","2019-10-29","56",0,null,0,"0","2","2019-12-09 13:35:33","2","2019-12-09 13:35:33","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,34807","C191255","PERSONAL","Ms","ATneOtMIe0LYAurw32wHyQ==","8fTzWS+7t1nmEnG1fQtiRw==","","JuoZJFFpvrPqF\/07IdfIHtLby15JiIS13nkfz0Bi3G3Ij\/lO63BV2WemTW4T97d1hLIoJeuGN4NgiOa9lHKg9w==","wLWBoYhI1qKia2rkJxrObg==","nW1wxJuhGSp1hffXbm1TmkEK7G4kgckFWfZtR+HR6Hk=","qCm4RuBGDh5cFKNczNFPwQ==",null,1,4818]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","470","34","749","%","4.91",49.0018,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","470","34","750","%","4.91",49.0018,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","434","35","760","%","4.97",54.5706,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","434","35","761","%","4.97",54.5706,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","761","1098.0",1043.4,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-29","2020-01-28","761"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","760","1098.0",1043.4,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-29","2020-01-28","760"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","750","998.0",949,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-29","2020-01-28","750"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 13:35:33","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":["6642","749","998.0",949,"2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-29","2020-01-28","749"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 13:35:33","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":["6642",1255,"SETTLED","A14-I196970","2019-12-09 13:35:33","2019-10-29","2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6970","RENT","\u9810\u7e73\u79df\u91d1",1,3932,"MO","1",3932,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6970","RENT","\u9810\u7e73\u79df\u91d1",2,3932,"MO","1",3932,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6970","RENT","\u9810\u7e73\u79df\u91d1",3,3932,"MO","1",3932,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11796,0,"6970"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 13:35:33","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":[1255,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196620","2019-12-09 13:35:33",11796,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6620","DEPOSIT",null,"PAID","2019-12-09 13:35:33",0,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 13:35:33","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":["6620","INVOICE","6970","PAID","2019-12-09 13:35:33",11796,"2","2019-12-09 13:35:33","2","2019-12-09 13:35:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 14:00:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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&page=2&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":788,"customer_code":"C180788","identity_type":"PERSONAL","identity_id":"P344596(1)","title":"Ms","lastname":"Wong","firstname":"Lai Kuen","companyname":"","email":null,"tel":"97555160","address":"\u9999\u6e2f\u9d28\u8137\u6d32\u6df1\u7063\u8ed23\u5ea78\/C","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2019-09-12","renew_room_key":"055,38723","renew_remark":"6 months contract. Storage rental paid by cheque on May 20, 2019. Storage deposit transferred from agreement A14-CT183149 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194978, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"691","room_code":"N08","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-09-12","rent_from":"2019-09-12","rent_to":"2019-12-11","delivery_service":"0","remark":"3 months contract. Storage rental $1072 paid by bank transfer on December 2, 2019. Remaining balance $722 will deducted from deposit. Storage deposit transferred from agreement A14-CT194978 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,38723","order_product":[],"pass":true}},"first_order_id":"3149","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> N08 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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",788,"NEW","A14-CT196643",598,598,0,0,"3","3",1794,1794,1794,"2019-12-09 15:46:14","0",null,null,null,"2019-09-12","2019-12-11","3 months contract. Storage rental $1072 paid by bank transfer on December 2, 2019. Remaining balance $722 will deducted from deposit. Storage deposit transferred from agreement A14-CT194978 to this agreement.","2019-09-12","12",0,null,0,"0","2","2019-12-09 15:46:14","2","2019-12-09 15:46:14","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,38723","C180788","PERSONAL","Ms","JphGS\/brYQPKm9VXMi77qA==","hULSwM2MvFtpeV9\/z+er8Q==","","kPp6q6TlAQRNluMi8NITvhBbq2icI2MlN4339\/stV10=","Xqxb5xtEpoR7frNmBOm3Ag==",null,"HH8bjsFxzIPy5YyzMXS8lQ==",null,1,"3149"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6643","691","598.0","598.00","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-09-12","2019-12-11","691"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 15:46:14","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":["6643",788,"SETTLED","A14-I196971","2019-12-09 15:46:14","2019-09-12","2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6971","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6971","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6971","RENT","\u9810\u7e73\u79df\u91d1",3,598,"MO","1",598,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1794,0,"6971"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 15:46:14","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":[788,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196621","2019-12-09 15:46:14",1794,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6621","DEPOSIT",null,"PAID","2019-12-09 15:46:14",0,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:46:14","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":["6621","INVOICE","6971","PAID","2019-12-09 15:46:14",1794,"2","2019-12-09 15:46:14","2","2019-12-09 15:46:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:55","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&page=2&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":[{"room_id":"691","master_room_id":"28","room_code":"N08"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> N08 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D220013(A)","title":"Ms","lastname":"LI","firstname":"Siu Wai","companyname":"","email":"","tel":"96519538","address":"Room 1711, Lei Fook House, Ap Lei Chau Estate, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"691","room_code":"N08","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-03-15","delivery_service":"0","remark":"3 months contract. Storage deposit $1196 paid by cash on December 9, 2019. Storage rental will be paid by cash by December 13, 2019. Smartcard provided on December 9, 2019. ","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":2900,"final_order_total":2900,"location_id":"2","branch_id":"1","company_id":"1","room_key":"191,03202","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["C191465","PERSONAL","Ms","mMV5J7Rfft6JJpDQA9XypQ==","hbkan9PC5SCnBxQh2lhA4w==","","i\/BmJzfAYHQhqO729B169g==",null,"ndrMXaztbuQP7T8uCyHRnOyurfT2y4sf\/jx2AIc7bGspwBCrXx+4YbHXJCUaZk7XLaiiTnUMrBBH2FuyQijETw==","35L1qgja4P8n9h9z15n1ZQ==",null,null,"dEjqZtqO+R+BELLPAI3BZQ==","2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2",1465,"NEW","A14-CT196644",598,568,1196,0,"3","3",2900,2900,2900,"2019-12-09 15:56:56","0",null,null,null,"2019-12-16","2020-03-15","3 months contract. Storage deposit $1196 paid by cash on December 9, 2019. Storage rental will be paid by cash by December 13, 2019. Smartcard provided on December 9, 2019. ","2019-12-16","12",0,null,0,"0","2","2019-12-09 15:56:55","2","2019-12-09 15:56:55","CASH","","","","CASH","","","",null,0,"191,03202","C191465","PERSONAL","Ms","mMV5J7Rfft6JJpDQA9XypQ==","hbkan9PC5SCnBxQh2lhA4w==","","ndrMXaztbuQP7T8uCyHRnOyurfT2y4sf\/jx2AIc7bGspwBCrXx+4YbHXJCUaZk7XLaiiTnUMrBBH2FuyQijETw==","i\/BmJzfAYHQhqO729B169g==",null,"35L1qgja4P8n9h9z15n1ZQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6644","691","598.0","598.00","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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-16","2020-03-15","691"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 15:56:56","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":["6644","A14-D195209","PAID",1196,0,"2020-03-15","2019-12-09 15:56:55","2019-12-09 15:56:55","2","2019-12-09 15:56:55","2","2019-12-09 15:56:55",1465]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6644",1465,"SETTLED","A14-I196972","2019-12-09 15:56:55","2019-12-16","2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6972","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6972","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6972","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"6972"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 15:56:56","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":[1465,"CASH","","","","CASH","","","","PAID","P196622","2019-12-09 15:56:55",2900,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6622","DEPOSIT","5209","PAID","2019-12-09 15:56:55",1196,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 15:56:56","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":["6622","INVOICE","6972","PAID","2019-12-09 15:56:55",1704,"2","2019-12-09 15:56:55","2","2019-12-09 15:56:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:04","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":"type=DEPOSIT&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"691","master_room_id":"28","room_code":"N08"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":212,"customer_code":"C160212","identity_type":"PERSONAL","identity_id":"D285534(9)","title":"Mr","lastname":"Mak","firstname":"Che Yan","companyname":"","email":"davidcy.mak@gmail.com","tel":"90435747","address":"13A, Block 23, Baguio Villa, 555 Victoria Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"949.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-10","renew_room_key":"054,43821","renew_remark":"3 months contract. Storage rental paid by bank transfer on Sep 9, 2019. Storage deposit transferred from agreement A12-CT195200 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195908, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[{"master_room_discount_id":"469","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"220","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"220","room_code":"D24","retail_price":"998.0","discounted_price":949,"location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-10","rent_from":"2019-12-10","rent_to":"2020-03-09","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A12-CT195908 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43821","order_product":[],"pass":true}},"first_order_id":"4549","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> D24 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"949.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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",212,"NEW","A12-CT196645",998,949,0,0,"3","3",2847,2847,2847,"2019-12-09 16:20:05","0",null,null,null,"2019-12-10","2020-03-09","3 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A12-CT195908 to this agreement.","2019-12-10","12",0,null,0,"0","2","2019-12-09 16:20:04","2","2019-12-09 16:20:04","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43821","C160212","PERSONAL","Mr","QMdo4NmpjqV\/3s1QKx1gOQ==","DGNg\/pKHJ\/mTaSVRFTWCKw==","","81v4Ds3okvpkyWWGB85n4xU+OGL3XTVm52q2rAuaYfRkwNVWuNcSFXbV5+CxdL+5DkE0fx06BlYm2oRHyzW2QQ==","HYnJYtaUMZQPiLVK4mRPsw==","3d9EX5\/c7dA6NvE2V921JGQiwkORAbLjhJZwk0bpolI=","kimoPHeAaNKLapbOk2eYCQ==",null,1,"4549"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6645","469","6","220","%","4.91",49.0018,"2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6645","220","998.0",949,"2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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-10","2020-03-09","220"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 16:20:05","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":["6645",212,"SETTLED","A12-I196973","2019-12-09 16:20:04","2019-12-10","2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6973","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6973","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6973","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"6973"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 16:20:05","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":[212,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196623","2019-12-09 16:20:04",2847,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6623","DEPOSIT",null,"PAID","2019-12-09 16:20:04",0,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:20:05","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":["6623","INVOICE","6973","PAID","2019-12-09 16:20:04",2847,"2","2019-12-09 16:20:04","2","2019-12-09 16:20:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22:11","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=DEPOSIT&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"691","master_room_id":"28","room_code":"N08"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":348,"customer_code":"C170348","identity_type":"PERSONAL","identity_id":"D473611181","title":"Ms","lastname":"Hon","firstname":"Shuk Ying","companyname":"","email":null,"tel":"93301967","address":"\u6d77\u6021\u534a\u5cf66\u5ea716\/F C\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","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-01","renew_room_key":"055,50917,054,31716","renew_remark":"6 months contract. Storage rental paid by bank transfer on April 29, 2019. Storage deposit transferred from agreement A14-CT183358 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT194847, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"483","room_code":"K20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"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":"2019-11-01","rent_from":"2019-11-01","rent_to":"2020-04-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT194847 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5610,"final_order_total":5610,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,50917,054,31716","order_product":[],"pass":true}},"first_order_id":4847,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"935.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",348,"NEW","A14-CT196646",1098,935,0,0,"6","6",5610,5610,5610,"2019-12-09 16:22:11","0",null,null,null,"2019-11-01","2020-04-30","6 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A14-CT194847 to this agreement.","2019-11-01","16",0,null,0,"0","2","2019-12-09 16:22:11","2","2019-12-09 16:22:11","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,50917,054,31716","C170348","PERSONAL","Ms","E3z3oKs4elpnhMw\/x9fxGw==","EoaUEoejMbsPJ+HqYaK40Q==","","pFiElyn3vmOO6EWq\/oTpI8vVJblsM2\/6QjyupDZWBRA=","NDsRE8jK4qicbGnM2FDjeA==",null,"LFVA0nP98c3ZiUQbjA5dhQ==",null,1,4847]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6646","483","1098.0","1098.00","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-01","2020-04-30","483"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 16:22: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":["6646",348,"SETTLED","A14-I196974","2019-12-09 16:22:11","2019-11-01","2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",1,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",2,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",3,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",4,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",5,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6974","RENT","\u9810\u7e73\u79df\u91d1",6,935,"MO","1",935,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5610,0,"6974"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 16:22: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":[348,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196624","2019-12-09 16:22:11",5610,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6624","DEPOSIT",null,"PAID","2019-12-09 16:22:11",0,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:22: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":["6624","INVOICE","6974","PAID","2019-12-09 16:22:11",5610,"2","2019-12-09 16:22:11","2","2019-12-09 16:22:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":"all=1","floor_plan_rent_room":[{"room_id":"691","master_room_id":"28","room_code":"N08"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":895,"customer_code":"C180895","identity_type":"PERSONAL","identity_id":"Z134328(A)","title":"Ms","lastname":"Yuen","firstname":"Hor Yun Queenie","companyname":"","email":"queenieyuen@gmail.com","tel":"60482884","address":"Flat E, 20\/F, Tower 18, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2019-09-13","renew_room_key":"0005763913","renew_remark":"1 month contract. Storage rental paid by bank transfer on August 31, 2019. Storage deposit transferred from agreement A05-CT195328 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195851, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1012","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1012","room_code":"A05-010","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-09-13","rent_from":"2019-09-13","rent_to":"2020-03-12","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A05-CT195851 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005763913","order_product":[],"pass":true}},"first_order_id":"4446","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-010 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",895,"NEW","A05-CT196647",1290,1162,0,0,"6","6",6972,6972,6972,"2019-12-09 16:46:37","0",null,null,null,"2019-09-13","2020-03-12","6 months contract. Storage rental paid by bank transfer on December 9, 2019. Storage deposit transferred from agreement A05-CT195851 to this agreement.","2019-09-13","16",0,null,0,"0","2","2019-12-09 16:46:37","2","2019-12-09 16:46:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005763913","C180895","PERSONAL","Ms","JOsz1XBDqKUTUhMVAYNJzA==","DtbrOSvE4C7BOu5x4dBFtg==","","AS1LBHRguAAbvJTqVEGw5Gja69Yx4JubzyTOj7hCJeTm5MtYI4wKt5m5Bh0XXhOgoyThgna+5iwvHWf6MvCrZg==","doR4bo+YlfAmaGDszNSJeg==","d3UvMnMcP7YjxM\/IZ\/okSjnj07Mb+2713r177aD5UUg=","EgrrIlMeWDHxp7jp2JE3uA==",null,1,"4446"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6647","251","114","1012","%","10.00",129,"2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6647","1012","1290.0",1161,"2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-09-13","2020-03-12","1012"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 16:46:37","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":["6647",895,"SETTLED","A05-I196975","2019-12-09 16:46:37","2019-09-13","2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6975","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"6975"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 16:46:37","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":[895,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196625","2019-12-09 16:46:37",6972,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6625","DEPOSIT",null,"PAID","2019-12-09 16:46:37",0,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 16:46:37","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":["6625","INVOICE","6975","PAID","2019-12-09 16:46:37",6972,"2","2019-12-09 16:46:37","2","2019-12-09 16:46:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19:50","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":"all=1&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"691","master_room_id":"28","room_code":"N08"}],"_payment_type":"DEPOSIT","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1024,"customer_code":"C181024","identity_type":"PERSONAL","identity_id":"D344353(3)","title":"Ms","lastname":"Lee","firstname":"Yuk Ling","companyname":"","email":null,"tel":"51000440","address":"Flat 1517, Pik Yuet House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"670.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-05","renew_room_key":"189,58255","renew_remark":"12 months contract. Storage rental and deposit paid by cheque on November 7, 2018. Smartcard provided on November 7, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT183481, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1622.0","renew_master_room_id":"103","order_discount":[],"order_room":[{"room_id":"908","room_code":"U09","retail_price":"965.0","discounted_price":"965.00","location_id":"3"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-05","rent_from":"2019-12-05","rent_to":"2020-01-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by cheque on December 9, 2019. Storage deposit $1622 transferred from agreement A18-CT183481 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":965,"final_order_total":965,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,58255","order_product":[],"pass":true}},"first_order_id":3481,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> U09 <\/td>\r\n\t\t\t\t\t 2X4X7 <\/td>\r\n\t\t\t\t\t $965.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"965.00","deposit":"0.00","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",1024,"NEW","A18-CT196648",965,965,0,0,"1","1",965,965,965,"2019-12-09 17:19:50","0",null,null,null,"2019-12-05","2020-01-04","1 month contract. Storage rental paid by cheque on December 9, 2019. Storage deposit $1622 transferred from agreement A18-CT183481 to this agreement. ","2019-12-05","8",0,null,0,"0","2","2019-12-09 17:19:50","2","2019-12-09 17:19:50","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"189,58255","C181024","PERSONAL","Ms","ZzRtsket6p7WIKEqrfiAQw==","kiriEIqhcx866RNZiMXdKQ==","","P9o5xBN8f7x3IPxq7suZeUet6xs2JQboY\/5QBQJEHM3p3nIXgC73HCiMJkjiM7jGNdGvRkylnku8ZKe2jY3GCOs2VnVAGDTK7i\/qOjRI6bQ=","8Hqk74sppfjBwfsDxMPlvw==",null,"3v4hGu4VFbOMrjL2M3GmLA==",null,1,3481]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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":["6648","908","965.0","965.00","2","2019-12-09 17:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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":["2019-12-05","2020-01-04","908"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-09 17:19: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":["6648",1024,"SETTLED","A18-I196976","2019-12-09 17:19:50","2019-12-05","2","2019-12-09 17:19:50","2","2019-12-09 17:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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":["6976","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2019-12-09 17:19:50","2","2019-12-09 17:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"6976"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-09 17:19: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":[1024,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196626","2019-12-09 17:19:50",965,"2","2019-12-09 17:19:50","2","2019-12-09 17:19:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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":["6626","DEPOSIT",null,"PAID","2019-12-09 17:19:50",0,"2","2019-12-09 17:19:50","2","2019-12-09 17:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:19: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":["6626","INVOICE","6976","PAID","2019-12-09 17:19:50",965,"2","2019-12-09 17:19:50","2","2019-12-09 17:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:24:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:29:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-09 17:29:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****