{"created_at":"2019-12-11 10:54:15","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=INVOICE&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":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":435,"customer_code":"C170435","identity_type":"PERSONAL","identity_id":"P813459(A)","title":"Ms","lastname":"Pudwill","firstname":"Vipa","companyname":"","email":"vpudwill@hotmail.com","tel":"93330979","address":"36B,Tower 6,Phase1 Bel-Air,Cyber Port ,HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1169.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-19","renew_room_key":"054,57460","renew_remark":"12 months contract. change unit from N20 to L19. Storage deposit $1337 transferred from agreement SD14-CT182216 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183634, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2596.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"541","room_code":"L19(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14496,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1208.00","warehousing_date":"2019-11-19","rent_from":"2019-11-19","rent_to":"2020-12-18","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on December 11, 2019. Storage deposit $2596 transferred from agreement A14-CT183634 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1208,"order_total":15704,"final_order_total":14496,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,57460","order_product":[],"pass":true}},"first_order_id":3634,"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>
L19(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t	4X4X8 <\/td>\r\n\t\t\t\t\t	$1342.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":"16","total_discounted_price":"1208.00","deposit":"0.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",435,"NEW","A14-CT196667",1342,1208,0,0,"13","13",14496,15704,14496,"2019-12-11 10:54:16","0",null,null,null,"2019-11-19","2020-12-18","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on December 11, 2019. Storage deposit $2596 transferred from agreement A14-CT183634 to this agreement. ","2019-11-19","16",0,null,1208,"1208.00","2","2019-12-11 10:54:15","2","2019-12-11 10:54:15","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,57460","C170435","PERSONAL","Ms","1mp51PEAuVsP0XgRjL566A==","84OL9jCFtBu4xi63lmrd3w==","","Rnr7qJkPvCFjdyftldG0Wisvv1kdm82Ld2tBhGAgTzxCJ8k9p5utBns1CKKMoNgB","mZv5tWNmuR94VHMJ+8weBw==","4u74JlLeyE+JaBJzw3vCYvXlTyFVnF+eKJ4dNDZzH7Y=","nJ7o+GZJxflbl0paKgvPZw==",null,1,3634]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6667","541","1342.0","1342.00","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-19","2020-12-18","541"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6667",435,"SETTLED","A14-I196995","2019-12-11 10:54:15","2019-11-19","2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",3,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",4,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",7,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",8,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",9,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",10,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",11,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",12,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6995","RENT","\u9810\u7e73\u79df\u91d1",13,1208,"MO","1",1208,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14496,0,"6995"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[435,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196645","2019-12-11 10:54:15",14496,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6645","DEPOSIT",null,"PAID","2019-12-11 10:54:15",0,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 10:54:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6645","INVOICE","6995","PAID","2019-12-11 10:54:15",14496,"2","2019-12-11 10:54:15","2","2019-12-11 10:54:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:06:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:25:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&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","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":574,"customer_code":"C170574","identity_type":"BUSINESS","identity_id":"67544417-000","title":"Ms","lastname":"Kwok","firstname":"Yuet Wah Albertina","companyname":"Boba Cafe 128","email":"tinaywk33@hotmail.com","tel":"66871716","address":"G\/F, Shop 1, 128 Ap Lei Chau Main Road, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-03","renew_room_key":"055,07586","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 22, 2019. Storage deposit transferred from agreement A12-CT195973 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196220, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"144","room_code":"C20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-03","rent_from":"2019-11-03","rent_to":"2019-12-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A12-CT196220 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,07586","order_product":[],"pass":true}},"first_order_id":"4722","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> C20 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",574,"NEW","A12-CT196668",1098,1038,0,0,"1","1",1038,1038,1038,"2019-12-11 11:58:16","0",null,null,null,"2019-11-03","2019-12-02","1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A12-CT196220 to this agreement.","2019-11-03","16",0,null,0,"0","2","2019-12-11 11:58:16","2","2019-12-11 11:58:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,07586","C170574","BUSINESS","Ms","A+uRj8p7tDqEbQijhd95GjDFnFB7Op1AqPZ9q\/ChjGU=","+pNULpsInm3siHASV0hIrg==","Boba Cafe 128","Isk4kzOjkF6xeDXceSf25KVcGBgp\/FxQCSbLWl0WDEisZ9I5jVSpGA0hu4eHP+cqW9lXYIwIK1KYgWa8VI8QkA==","cqSYrPZcLGU6olheKS6TwQ==","HyiE2BUsNgIyg65jh\/6C9e6snrjutNDWNVbS\/MDm\/20=",null,"O33I8t0JzOwsECFDTsBzRw==",1,"4722"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6668","144","1098.0","1098.00","2","2019-12-11 11:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-03","2019-12-02","144"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6668",574,"SETTLED","A12-I196996","2019-12-11 11:58:16","2019-11-03","2","2019-12-11 11:58:16","2","2019-12-11 11:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6996","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-11 11:58:16","2","2019-12-11 11:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"6996"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[574,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196646","2019-12-11 11:58:16",1038,"2","2019-12-11 11:58:16","2","2019-12-11 11:58:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6646","DEPOSIT",null,"PAID","2019-12-11 11:58:16",0,"2","2019-12-11 11:58:16","2","2019-12-11 11:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 11:58:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6646","INVOICE","6996","PAID","2019-12-11 11:58:16",1038,"2","2019-12-11 11:58:16","2","2019-12-11 11:58:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:04:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08:41","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=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":673,"customer_code":"C170673","identity_type":"PERSONAL","identity_id":"Y085423(7)","title":"Mr","lastname":"Li","firstname":"Pui Wing","companyname":"","email":"wing022090@hotmail.com","tel":"65002249","address":"Flat A, 6\/F. Albert House, 26 Cheng Tu Rd, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"2","renew_warehousing_date":"2019-12-01","renew_room_key":"054,58226,076,35816","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 8, 2019. Storage deposit transferred from agreement A14-CT195953 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196103, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"28","order_discount":[],"order_room":[{"room_id":"620","room_code":"M31","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2019-12-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A14-CT196103 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,58226,076,35816","order_product":[],"pass":true}},"first_order_id":"4685","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> M31 <\/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-11 12:08: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",673,"NEW","A14-CT196669",598,598,0,0,"1","1",598,598,598,"2019-12-11 12:08:41","0",null,null,null,"2019-12-01","2019-12-31","1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A14-CT196103 to this agreement.","2019-12-01","12",0,null,0,"0","2","2019-12-11 12:08:41","2","2019-12-11 12:08:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,58226,076,35816","C170673","PERSONAL","Mr","ITD2Z30msP76kNRsYAQJdA==","7KCehmxbvwRMb+U8lHGoVA==","","HdXbjSMvv+ZR14503QlGfIIJx53YwiSYo18C3zg2iAsoCVGYQ5WI8DdHfRG1zNaPWkGvmtKZhfECBhHRiUVkSg==","7i41GG+VMMQ0anZ5o5qU1A==","CYmwmTN8U9iiSrWcIU95bF9znWI7Bh\/wdBd3p1sJ\/Ew=","V8J6VCsbvmxznZr8ycizJA==",null,1,"4685"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08: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":["6669","620","598.0","598.00","2","2019-12-11 12:08:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08: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-12-01","2019-12-31","620"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 12:08: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":["6669",673,"SETTLED","A14-I196997","2019-12-11 12:08:41","2019-12-01","2","2019-12-11 12:08:41","2","2019-12-11 12:08:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08: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":["6997","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2019-12-11 12:08:41","2","2019-12-11 12:08:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"6997"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 12:08: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":[673,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196647","2019-12-11 12:08:41",598,"2","2019-12-11 12:08:41","2","2019-12-11 12:08:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08: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":["6647","DEPOSIT",null,"PAID","2019-12-11 12:08:41",0,"2","2019-12-11 12:08:41","2","2019-12-11 12:08:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:08: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":["6647","INVOICE","6997","PAID","2019-12-11 12:08:41",598,"2","2019-12-11 12:08:41","2","2019-12-11 12:08:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":488,"customer_code":"C170488","identity_type":"PERSONAL","identity_id":"D517675(2)","title":"Ms","lastname":"Lau","firstname":"Wing Yi","companyname":"","email":"jinnyslau@gmail.com","tel":"91921743","address":"Block 22,11\/F,Flat B,South Horizons,Apleichau,H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4074.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-13","renew_room_key":"054,13342,136,62583,054,57704","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 9, 2019.Storage Deposit transferred from A14-CT183861 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195185, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"783","room_code":"P17","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"782","room_code":"P16","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"},{"room_id":"781","room_code":"P15","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"72","total_retail_price":5304,"total_discounted_price":4074,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":24444,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-13","rent_from":"2019-12-13","rent_to":"2020-06-12","delivery_service":"0","remark":"6 months contract. Storage rental $24282 paid by bank transfer on December 10, 2019. Remaining balance $162 will be paid by next contract or deducted from deposit. Storage Deposit transferred from A14-CT195185 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":24444,"final_order_total":24444,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,13342,136,62583,054,57704","order_product":[],"pass":true}},"first_order_id":"3861","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 \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> P17 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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> P16 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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> P15 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.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":"72","total_discounted_price":"4074.0","deposit":"0","total_retail_price":"5304.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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",488,"NEW","A14-CT196670",5304,4074,0,0,"6","6",24444,24444,24444,"2019-12-11 12:14:51","0",null,null,null,"2019-12-13","2020-06-12","6 months contract. Storage rental $24282 paid by bank transfer on December 10, 2019. Remaining balance $162 will be paid by next contract or deducted from deposit. Storage Deposit transferred from A14-CT195185 to this agreement. ","2019-12-13","72",0,null,0,"0","2","2019-12-11 12:14:51","2","2019-12-11 12:14:51","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,13342,136,62583,054,57704","C170488","PERSONAL","Ms","opzZOgkRjypyoX+pYMFoUg==","oe4emdjBwqJ3qUpOcI17hw==","","5AFD0BgDnfntmAGfFM1WzcfF4M\/IwcroqKsAfGpekz6KNB76xa4J7oefAQXqxPKi5pZz+ZEEGZlpVwQlcLUSjg==","tHfCDsB+dYIdqt7OpQA6PA==","EOIulWnRvAl3RsbWX0zWUolYv+dzseEMH0pWXTJtr+I=","o\/WxdQRLzRO4zD5PM+qtjw==",null,1,"3861"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6670","783","1768.0","1768.00","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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-13","2020-06-12","783"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 12:14:51","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":["6670","782","1768.0","1768.00","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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-13","2020-06-12","782"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 12:14:51","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":["6670","781","1768.0","1768.00","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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-13","2020-06-12","781"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 12:14:51","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":["6670",488,"SETTLED","A14-I196998","2019-12-11 12:14:51","2019-12-13","2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",1,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",2,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",3,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",4,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",5,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6998","RENT","\u9810\u7e73\u79df\u91d1",6,4074,"MO","1",4074,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[24444,0,"6998"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 12:14:51","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":[488,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196648","2019-12-11 12:14:51",24444,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6648","DEPOSIT",null,"PAID","2019-12-11 12:14:51",0,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 12:14:51","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":["6648","INVOICE","6998","PAID","2019-12-11 12:14:51",24444,"2","2019-12-11 12:14:51","2","2019-12-11 12:14:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 13:54:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 13:59:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":"filter1=1&filter2=1121&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1467","master_room_id":"162","room_code":"C15-161"}],"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> C15-161 <\/td>\r\n\t\t\t\t\t 4X2X6.5 <\/td>\r\n\t\t\t\t\t $692.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D651948(3)","title":"Mr","lastname":"HO","firstname":"Fu Tak","companyname":"","email":"hofutak@gmail.com","tel":"90262951","address":"Flat 804, BLK M, Kornhill, Quarry Bay, Hong Kong","pass":true,"customer_id":"1267","customer_code":"C191267","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"437","master_room_id":"162","discount_type":"%","price":"692.00","disocunted_price":"520.00","discount":"24.86","monthly_deduct":172.0312,"room_id":"1467","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1467","room_code":"C15-161","retail_price":"692.0","discounted_price":520,"location_id":"6"}],"roughly_size":"8","total_retail_price":692,"total_discounted_price":623,"deposit":692,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":6922,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1246.00","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-12-20","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by bank transfer on Dec 09,2019. Smartcard provided on May 11, 2019.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1246,"order_total":9368,"final_order_total":8122,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005795993","order_product":[{"product_id":"14","product_name":"5\u5c64\u7f6e\u7269\u67b6(\u53ef\u8abf\u7bc0) - \u552e:$600\/\u500b","qty":"2","price":"600.0"}],"pass":true}},"roughly_size":"8","total_discounted_price":"623.00","deposit":"692","total_retail_price":"692.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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` = ?","parameters":["1","3","6","1267","NEW","C15-CT196671",692,623,692,0,"12","12",6922,9368,8122,"2019-12-11 14:13:37","0",null,null,null,"2019-12-21","2020-12-20","12 months contract. Special offer the 11th and 12th month free. Storage rental and deposit paid by bank transfer on Dec 09,2019. Smartcard provided on May 11, 2019.","2019-12-21","8",0,null,1246,"1246.00","2","2019-12-11 14:13:37","2","2019-12-11 14:13:37","BANKIN","","","","BANKIN","","","",null,0,"0005795993","C191267","PERSONAL","Mr","hrf74OM27DUPsJJUru68xw==","Zzv1eRCimQisUlUlw\/fpjg==","","j4PGnQQIBsivUF7FOiRVcvdR9yzYxHQDxPJEWYRVOtgo4FRar8E8JP8hsWEjf4\/QLDzzHnNBKdFnkyFwkwFiWQ==","ZCcZMvTjxRk2NnQuXoKN9Q==","NdDzt\/YvXBzrnwKGdhstzBa30RCugRGfpxO0M+SxagQ=","soE6NG7I5hlIIeBClBBOwg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6671","437","162","1467","%","24.86",172.0312,"2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6671","1267","14","2","600.0",1200,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[1200,"6671"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2019-12-11 14:13: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":["6671","1467","692.0",520,"2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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-12-21","2020-12-20","1467"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 14:13:37","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":["6671","C15-D195212","PAID",692,0,"2020-12-20","2019-12-11 14:13:37","2019-12-11 14:13:37","2","2019-12-11 14:13:37","2","2019-12-11 14:13:37","1267"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6671","1267","SETTLED","C15-I196999","2019-12-11 14:13:37","2019-12-21","2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",4,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",5,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",6,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",7,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",8,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",9,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",10,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",11,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6999","RENT","\u9810\u7e73\u79df\u91d1",12,623,"MO","1",623,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6999","ORDER_PRODUCT","600.0","PCS","2",1200,"14","2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7430,0,"6999"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 14:13: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":["1267","BANKIN","","","","BANKIN","","","","PAID","P196649","2019-12-11 14:13:37",8122,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6649","DEPOSIT","5212","PAID","2019-12-11 14:13:37",692,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 14:13: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":["6649","INVOICE","6999","PAID","2019-12-11 14:13:37",7430,"2","2019-12-11 14:13:37","2","2019-12-11 14:13:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:00:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1110&filter3=undefined","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1110,"customer_code":"C181110","identity_type":"PERSONAL","identity_id":"Z905411(2)","title":"Ms","lastname":"Chong","firstname":"Sau Man","companyname":"","email":"michelle0806hk@yahoo.com.hk","tel":"64073552","address":"Rm1809, 18\/F, Sui Hei Hse, Siu Sai Wan Est, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"724.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-25","renew_room_key":"0012420957","renew_remark":"12 month contract.Special promotion offered, 2 months free of charge. Storage rental and deposit paid by EPS on 20 NOV 2018. Smart card provided on 20 NOV 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT183663, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2224.0","renew_master_room_id":"146","order_discount":[],"order_room":[{"room_id":"1273","room_code":"B01-083","retail_price":"1198.0","discounted_price":"1198.00","location_id":"5"}],"roughly_size":"18","total_retail_price":1198,"total_discounted_price":868,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10416,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-25","rent_from":"2019-11-25","rent_to":"2020-11-24","delivery_service":"0","remark":"12 month contract. Storage rental paid by PPS on December 10, 2019. Storage deposit $2224 transferred from agreement B01-CT183663 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":10416,"final_order_total":10416,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012420957","order_product":[],"pass":true}},"first_order_id":3663,"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> B01-083 <\/td>\r\n\t\t\t\t\t 4.5X4X7 <\/td>\r\n\t\t\t\t\t $1198.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":"18","total_discounted_price":"868.00","deposit":"0.00","total_retail_price":"1198.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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","2","5",1110,"NEW","B01-CT196672",1198,868,0,0,"12","12",10416,10416,10416,"2019-12-11 15:48:35","0",null,null,null,"2019-11-25","2020-11-24","12 month contract. Storage rental paid by PPS on December 10, 2019. Storage deposit $2224 transferred from agreement B01-CT183663 to this agreement. ","2019-11-25","18",0,null,0,"0","2","2019-12-11 15:48:34","2","2019-12-11 15:48:34","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012420957","C181110","PERSONAL","Ms","jqj780Uc5vHrwRXwkPiv7Q==","xoslI7xaq8EyGcHiI7WJHQ==","","kY+LH3qpjgokC5Ql8LStmt4RTNRPfjkZrmx4UMtGvPxxpSIAYJabVDZZypPVHpaQ","AagMgVcNiYGDPX8Jj8YwfQ==","Z85IUY9qoldbbIIkcEU31j5iZFVbP9SD4Qukcgq0sis=","SISSVH42PGWYutRBDEZwAw==",null,1,3663]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["6672","1273","1198.0","1198.00","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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-25","2020-11-24","1273"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 15:48:35","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":["6672",1110,"SETTLED","B01-I197000","2019-12-11 15:48:34","2019-11-25","2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",1,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",2,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",3,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",4,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",5,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",6,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",7,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",8,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",9,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",10,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",11,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["7000","RENT","\u9810\u7e73\u79df\u91d1",12,868,"MO","1",868,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10416,0,"7000"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 15:48:35","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":[1110,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196650","2019-12-11 15:48:34",10416,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["6650","DEPOSIT",null,"PAID","2019-12-11 15:48:34",0,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:48:35","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":["6650","INVOICE","7000","PAID","2019-12-11 15:48:34",10416,"2","2019-12-11 15:48:34","2","2019-12-11 15:48:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1110&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1049,"customer_code":"C181049","identity_type":"PERSONAL","identity_id":"G693071(8)","title":"Mr","lastname":"Hui","firstname":"Pak Shing","companyname":"","email":"ps.hui02@gmail.com","tel":"94267858","address":"Flat 7, 27\/F, Shan On House, Yue On Court, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"730.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-17","renew_room_key":"0012474005","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by EPS on November 10, 2018. Smartcard provided on November 10, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183541, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1622.0","renew_master_room_id":"111","order_discount":[],"order_room":[{"room_id":"1181","room_code":"A05-179","retail_price":"965.0","discounted_price":"965.00","location_id":"4"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":730,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":8760,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-17","rent_from":"2019-11-17","rent_to":"2020-11-16","delivery_service":"0","remark":"12 months contract. Storage rental paid by PPS on December 10, 2019. Storage deposit $1622 transferred from agreement A05-CT183541 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":8760,"final_order_total":8760,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012474005","order_product":[],"pass":true}},"first_order_id":3541,"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-179 <\/td>\r\n\t\t\t\t\t 4X2X7 <\/td>\r\n\t\t\t\t\t $965.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":"8","total_discounted_price":"730.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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",1049,"NEW","A05-CT196673",965,730,0,0,"12","12",8760,8760,8760,"2019-12-11 15:52:13","0",null,null,null,"2019-11-17","2020-11-16","12 months contract. Storage rental paid by PPS on December 10, 2019. Storage deposit $1622 transferred from agreement A05-CT183541 to this agreement.","2019-11-17","8",0,null,0,"0","2","2019-12-11 15:52:13","2","2019-12-11 15:52:13","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012474005","C181049","PERSONAL","Mr","PB54B4CEd+zSv\/7jTIQgyQ==","Uu\/X0ZeZROrQW5FJIWd7Ww==","","VoGC8WJ9qRVaev5j08SMUpKMldhQ82an3mvtLJQ0VCZ4JkqZCijd33bsK7nJQab3Z3kKeBSGzZmfllv2K+caLQ==","PCnlcR5mD\/WwPjwWEuEjUQ==","f6p3C\/wXiv\/zljWINPl9+r5YNSNaWhrS5krAwWZA32Q=","wDMrhSevniOZmAy2fRTRGA==",null,1,3541]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["6673","1181","965.0","965.00","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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-17","2020-11-16","1181"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 15:52:13","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":["6673",1049,"SETTLED","A05-I197001","2019-12-11 15:52:13","2019-11-17","2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",1,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",2,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",3,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",4,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",5,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",6,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",7,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",8,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",9,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",10,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",11,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["7001","RENT","\u9810\u7e73\u79df\u91d1",12,730,"MO","1",730,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8760,0,"7001"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 15:52:13","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":[1049,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196651","2019-12-11 15:52:13",8760,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["6651","DEPOSIT",null,"PAID","2019-12-11 15:52:13",0,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 15:52:13","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":["6651","INVOICE","7001","PAID","2019-12-11 15:52:13",8760,"2","2019-12-11 15:52:13","2","2019-12-11 15:52:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:06:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1110&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1286,"customer_code":"C191286","identity_type":"PERSONAL","identity_id":"K299542(5)","title":"Mr","lastname":"WAN","firstname":"Siu Chuen","companyname":"","email":"norki525@yahoo.com.hk","tel":"92389437","address":"Rm 2603, Wu On House, Yue On Court, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-09","renew_room_key":"076,58166","renew_remark":"6 months contract. Special "Rent Now" 5% off and $500 coupon discount. Storage rental and deposit paid by cash on June 6, 2019. Smartcard provided on June 6, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195163, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"200","order_discount":[{"master_room_discount_id":"474","master_room_id":"200","discount_type":"%","price":"668.00","disocunted_price":"600.90","discount":"10.04","monthly_deduct":67.0672,"room_id":"1496","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1496","room_code":"A16-005","retail_price":"668.0","discounted_price":600.9,"location_id":"7"}],"roughly_size":"12","total_retail_price":668,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-09","rent_from":"2019-12-09","rent_to":"2020-06-08","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on December 11, 2019. Storage deposit $1196 transferred from agreement A16-CT195163 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,58166","order_product":[],"pass":true}},"first_order_id":5163,"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> A16-005 <\/td>\r\n\t\t\t\t\t 4X3X3.5 <\/td>\r\n\t\t\t\t\t $668.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"538.0","deposit":"0","total_retail_price":"668.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1286,"NEW","A16-CT196674",668,538,0,0,"6","6",3228,3228,3228,"2019-12-11 16:23:01","0",null,null,null,"2019-12-09","2020-06-08","6 months contract. Storage rental paid by cash on December 11, 2019. Storage deposit $1196 transferred from agreement A16-CT195163 to this agreement. ","2019-12-09","12",0,null,0,"0","2","2019-12-11 16:23:00","2","2019-12-11 16:23:00","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"076,58166","C191286","PERSONAL","Mr","\/vSa70zhic2PBI3\/SYA9hg==","2+HhFlKBGl3L\/0uDqNi5+g==","","90hiaCa3Ox\/aQSXnM\/CKz2KFaqLAzp+M6PDFO7O4QJBYbbOMkB00wKM1iR2tXveP","eK+vnDTqwMWXbLLlPuYW9Q==","RCAA9oqQn4aU7kXNIDRBSoB0gExzyePtfqGgJHtCC\/g=","zJEGcYRJWhy2wnkEkrgXOg==",null,1,5163]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","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":["6674","474","200","1496","%","10.04",67.0672,"2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6674","1496","668.0",600.9,"2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-09","2020-06-08","1496"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6674",1286,"SETTLED","A16-I197002","2019-12-11 16:23:00","2019-12-09","2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7002","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"7002"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1286,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196652","2019-12-11 16:23:00",3228,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6652","DEPOSIT",null,"PAID","2019-12-11 16:23:00",0,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 16:23:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6652","INVOICE","7002","PAID","2019-12-11 16:23:00",3228,"2","2019-12-11 16:23:00","2","2019-12-11 16:23:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":357,"customer_code":"C170357","identity_type":"PERSONAL","identity_id":"K200528(A)","title":"Ms","lastname":"So","firstname":"Bik Yan","companyname":"","email":"Bettyso2010@hotmail.com","tel":"61890200","address":"\u9999\u6e2f\u4ed4\u9d28\u8137\u6d32\u897f\u6751\u5229\u798f\u6a13\u9ad8\u5ea79\u6a1312\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-14","renew_room_key":"052,56559\/054,01889","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 12, 2019. Storage deposit transferred from agreement A14-CT194950 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196384, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"514","room_code":"K51","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-14","rent_from":"2019-12-14","rent_to":"2020-01-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit transferred from agreement A14-CT196384 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"2","branch_id":"1","company_id":"1","room_key":"052,56559\/054,01889","order_product":[],"pass":true}},"first_order_id":"3602","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> K51 <\/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":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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",357,"NEW","A14-CT196675",1098,1038,0,0,"1","1",1038,1038,1038,"2019-12-11 17:31:15","0",null,null,null,"2019-12-14","2020-01-13","1 month contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit transferred from agreement A14-CT196384 to this agreement.","2019-12-14","16",0,null,0,"0","2","2019-12-11 17:31:15","2","2019-12-11 17:31:15","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,56559\/054,01889","C170357","PERSONAL","Ms","Xm\/QexF8eZtTsSb8L38jDQ==","4x5vYEKSVRSuDm5I8YHOGA==","","iaMKHy8smhToDNlD2lpct7apbVifxmEzETQX4zzdkIWbv1n1\/bqXIgSPJ9SuXJYQpspqWP8NAGG1MTx8\/3lieQ==","+3tfr98clfpe3pm59uql3Q==","oYq5\/GECL57LsJqAl8dH7KilbaFGbc5z+OZxfLZDi7A=","LEynVVsVuI2leNikh3mN3A==",null,1,"3602"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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":["6675","514","1098.0","1098.00","2","2019-12-11 17:31:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-14","2020-01-13","514"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 17:31:15","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":["6675",357,"SETTLED","A14-I197003","2019-12-11 17:31:15","2019-12-14","2","2019-12-11 17:31:15","2","2019-12-11 17:31:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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":["7003","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-11 17:31:15","2","2019-12-11 17:31:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7003"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 17:31:15","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":[357,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196653","2019-12-11 17:31:15",1038,"2","2019-12-11 17:31:15","2","2019-12-11 17:31:15","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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":["6653","DEPOSIT",null,"PAID","2019-12-11 17:31:15",0,"2","2019-12-11 17:31:15","2","2019-12-11 17:31:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:31:15","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":["6653","INVOICE","7003","PAID","2019-12-11 17:31:15",1038,"2","2019-12-11 17:31:15","2","2019-12-11 17:31:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1340,"customer_code":"C191340","identity_type":"PERSONAL","identity_id":"D804254(4)","title":"Ms","lastname":"Li","firstname":"Kam Ying","companyname":"","email":"kyli70@yahoo.com.hk","tel":"91846991","address":"21\/F, Cityplaza Three, 14 Taikoo Shing Road, Taikoo Shing, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2088.0","renew_rent_month":"1","renew_warehousing_date":"2019-10-23","renew_room_key":"190,26383","renew_remark":"1 month contract. Storage rental paid by PayMe on October 8, 2019. Storage deposit $4176 transferred from agreement WC-CT195521 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: WC-CT196097, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"242","order_discount":[],"order_room":[{"room_id":"1726","room_code":"WC-43","retail_price":"2088.0","discounted_price":"2088.00","location_id":"8"}],"roughly_size":"21","total_retail_price":2088,"total_discounted_price":1984,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5952,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-23","rent_from":"2019-10-23","rent_to":"2020-01-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit $4176 transferred from agreement WC-CT196097 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5952,"final_order_total":5952,"location_id":"8","branch_id":"1","company_id":"1","room_key":"190,26383","order_product":[],"pass":true}},"first_order_id":"5521","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> WC-43 <\/td>\r\n\t\t\t\t\t 3.5X6X8 <\/td>\r\n\t\t\t\t\t $2088.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":"21","total_discounted_price":"1984.00","deposit":"0.00","total_retail_price":"2088.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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","8",1340,"NEW","WC-CT196676",2088,1984,0,0,"3","3",5952,5952,5952,"2019-12-11 17:49:43","0",null,null,null,"2019-10-23","2020-01-22","3 months contract. Storage rental paid by bank transfer on December 11, 2019. Storage deposit $4176 transferred from agreement WC-CT196097 to this agreement.","2019-10-23","21",0,null,0,"0","2","2019-12-11 17:49:43","2","2019-12-11 17:49:43","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,26383","C191340","PERSONAL","Ms","JdQzQv+uksVt7YfqRkcs2g==","7KCehmxbvwRMb+U8lHGoVA==","","Hk9QjTXPPZugpENsJNJVRFjDshAXCfqBJdXMP\/Va7d3Z2K\/aCGuUUGkjQYrRlPUPOZljB3ovRTE6wx9XrkHxgBiZiPEw1x7TWdiJCF8+iP8=","u\/RO33AxBdDZLcxr\/eihQw==","rD9Syyb4nHCPJX+uzCXhPgdBRpQS4iLmKGxvb8tt99M=","pljIbpMDyGb8muJ6+q40Nw==",null,1,"5521"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["6676","1726","2088.0","2088.00","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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-23","2020-01-22","1726"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 17:49:43","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":["6676",1340,"SETTLED","WC-I197004","2019-12-11 17:49:43","2019-10-23","2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["7004","RENT","\u9810\u7e73\u79df\u91d1",1,1984,"MO","1",1984,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["7004","RENT","\u9810\u7e73\u79df\u91d1",2,1984,"MO","1",1984,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["7004","RENT","\u9810\u7e73\u79df\u91d1",3,1984,"MO","1",1984,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5952,0,"7004"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 17:49:43","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":[1340,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196654","2019-12-11 17:49:43",5952,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["6654","DEPOSIT",null,"PAID","2019-12-11 17:49:43",0,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:49:43","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":["6654","INVOICE","7004","PAID","2019-12-11 17:49:43",5952,"2","2019-12-11 17:49:43","2","2019-12-11 17:49:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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=INVOICE&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&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","floor_plan_rent_room":[{"room_id":"656","master_room_id":"30","room_code":"M67"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1134,"customer_code":"C181134","identity_type":"PERSONAL","identity_id":"Z017853(6)","title":"Mr","lastname":"Leung","firstname":"Wai Tat","companyname":"","email":"victorleung345@gmail.com","tel":"52255418","address":"Flat 06, 2\/F Yuet Chui Court 9, Yan Tsui St, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"356.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-10","renew_room_key":"0012472672","renew_remark":"1 months contract. Storage rental paid by Bank Transfer on Nov 08, 2019 and October 10, 2019. Storage deposit transferred from agreement C15-CT196114 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196342, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1452","room_code":"C15-146","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":356,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":356,"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-01-09","delivery_service":"0","remark":"1 months contract. Storage rental paid by PayMe on December 11, 2019. Storage deposit transferred from agreement C15-CT196342 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":356,"final_order_total":356,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012472672","order_product":[],"pass":true}},"first_order_id":"4805","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> C15-146 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.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.1","total_discounted_price":"356.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1134,"NEW","C15-CT196677",510,356,0,0,"1","1",356,356,356,"2019-12-11 17:54:22","0",null,null,null,"2019-12-10","2020-01-09","1 months contract. Storage rental paid by PayMe on December 11, 2019. Storage deposit transferred from agreement C15-CT196342 to this agreement.","2019-12-10","8.1",0,null,0,"0","2","2019-12-11 17:54:22","2","2019-12-11 17:54:22","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012472672","C181134","PERSONAL","Mr","S1eQwXaAsUdtzc1Ymck8Jg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","596Kcg0kSfbD85GNFxMa7h8CY7zKszjQ7hj4A6ucjRZeYl+TO11xTTCVesXiaJ\/pTZeIYxCHmr9rgYiIkihiFg==","50+huvkYI7Tn4ZAWxVwcPw==","FRHJOJDYd5XByaT89nynmQawjlXgI0AS4R5zIEqR4E0=","XQVqohimdZ7JoGvCaH2ATQ==",null,1,"4805"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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":["6677","1452","510.0","510.00","2","2019-12-11 17:54:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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-01-09","1452"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-11 17:54:22","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":["6677",1134,"SETTLED","C15-I197005","2019-12-11 17:54:22","2019-12-10","2","2019-12-11 17:54:22","2","2019-12-11 17:54:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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":["7005","RENT","\u9810\u7e73\u79df\u91d1",1,356,"MO","1",356,"2","2019-12-11 17:54:22","2","2019-12-11 17:54:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[356,0,"7005"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-11 17:54:22","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":[1134,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196655","2019-12-11 17:54:22",356,"2","2019-12-11 17:54:22","2","2019-12-11 17:54:22","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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":["6655","DEPOSIT",null,"PAID","2019-12-11 17:54:22",0,"2","2019-12-11 17:54:22","2","2019-12-11 17:54:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-11 17:54:22","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":["6655","INVOICE","7005","PAID","2019-12-11 17:54:22",356,"2","2019-12-11 17:54:22","2","2019-12-11 17:54:22"]},"data_before":[],"data_after":[],"step":1} *****