\n \n \n\t\t\t\t\t

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
I02 <\/td>\n\t\t\t\t\t	4X3X8 <\/td>\n\t\t\t\t\t	$998.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"998.00","deposit":"1996.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1470","NEW","A14-CT196726",998,998,1996,0,"1","1",2994,2994,2994,"2019-12-18 11:16:24","0",null,null,null,"2019-12-13","2020-01-12","1 month contract. Storage rental and deposit paid by cheque on Dec 18,2019. Smartcard provided on Dec 13,2019.","2019-12-13","12",0,null,0,"0","2","2019-12-18 11:16:23","2","2019-12-18 11:16:23","CHEQUE","","","","CHEQUE","","","",null,0,"","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","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":["6726","411","998.0","998.00","2","2019-12-18 11:16:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","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-01-12","411"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 11:16:24","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":["6726","A14-D195224","PAID",1996,0,"2020-01-12","2019-12-18 11:16:23","2019-12-18 11:16:23","2","2019-12-18 11:16:23","2","2019-12-18 11:16:23","1470"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","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":["6726","1470","SETTLED","A14-I197054","2019-12-18 11:16:23","2019-12-13","2","2019-12-18 11:16:23","2","2019-12-18 11:16:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7054","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2019-12-18 11:16:23","2","2019-12-18 11:16:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"7054"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 11:16:24","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":["1470","CHEQUE","","","","CHEQUE","","","","PAID","P196704","2019-12-18 11:16:23",2994,"2","2019-12-18 11:16:23","2","2019-12-18 11:16:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","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":["6704","DEPOSIT","5224","PAID","2019-12-18 11:16:23",1996,"2","2019-12-18 11:16:23","2","2019-12-18 11:16:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:16:24","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":["6704","INVOICE","7054","PAID","2019-12-18 11:16:23",998,"2","2019-12-18 11:16:23","2","2019-12-18 11:16:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":"","tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true,"customer_id":"1470","customer_code":"C191470","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"410","room_code":"I01","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":7306,"deposit":14612,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":21918,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-16","rent_from":"2019-12-16","rent_to":"2020-01-15","delivery_service":"0","remark":"1 month contract. Storage rental and deposit of 14\/F office paid by bank transfer on Dec 18,2019. Smartcard provided on Dec 13,2019.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":21918,"final_order_total":21918,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"selected_room_tr":"\n	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n	\n \n\n \n \n \n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab\n \n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n \u5009\u5eab\u7de8\u865f<\/td>\n \u5c3a\u5bf8<\/td>\n \u539f\u50f9(\u6708)<\/td>\n \u512a\u60e0\u50f9(\u6708)<\/td>\n \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n \u50f9\u683c<\/td>\n \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n <\/td>\n <\/tr> I01 <\/td>\n\t\t\t\t\t 4X3X8 <\/td>\n\t\t\t\t\t $998.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"7306.00","deposit":"14612.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","2","1470","NEW","A14-CT196727",998,7306,14612,0,"1","1",21918,21918,21918,"2019-12-18 11:26:55","0",null,null,null,"2019-12-16","2020-01-15","1 month contract. Storage rental and deposit of 14\/F office paid by bank transfer on Dec 18,2019. Smartcard provided on Dec 13,2019.","2019-12-16","12",0,null,0,"0","2","2019-12-18 11:26:55","2","2019-12-18 11:26:55","BANKIN","","","","BANKIN","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6727","410","998.0","998.00","2","2019-12-18 11:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-16","2020-01-15","410"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6727","A14-D195225","PAID",14612,0,"2020-01-15","2019-12-18 11:26:55","2019-12-18 11:26:55","2","2019-12-18 11:26:55","2","2019-12-18 11:26:55","1470"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6727","1470","SETTLED","A14-I197055","2019-12-18 11:26:55","2019-12-16","2","2019-12-18 11:26:55","2","2019-12-18 11:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7055","RENT","\u9810\u7e73\u79df\u91d1",1,7306,"MO","1",7306,"2","2019-12-18 11:26:55","2","2019-12-18 11:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7306,0,"7055"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1470","BANKIN","","","","BANKIN","","","","PAID","P196705","2019-12-18 11:26:55",21918,"2","2019-12-18 11:26:55","2","2019-12-18 11:26:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6705","DEPOSIT","5225","PAID","2019-12-18 11:26:55",14612,"2","2019-12-18 11:26:55","2","2019-12-18 11:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:26:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6705","INVOICE","7055","PAID","2019-12-18 11:26:55",7306,"2","2019-12-18 11:26:55","2","2019-12-18 11:26:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:29:07","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_tel` = ?, `customer_address` = ?, `customer_companyname` = ? where id = ?","parameters":["NEW","190,38711","1 month contract. Storage rental and deposit paid by bank transfer on Dec 18,2019. Smartcard provided on Dec 13,2019.","2019-12-18 11:29:07","2","DQ14OHmVeYuzJuBkd+kFHg==","Ya9A\/ywtlmJRIDhH4X4NUQ==","jdhYGndgmFP0qhtFU\/MiJw==","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","STAR LIGHT R & D LTD",6726]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":603,"customer_code":"C170603","identity_type":"BUSINESS","identity_id":"tbc","title":"Mr","lastname":"Au Yeung","firstname":"Man Kei","companyname":"J & M Merchandising Ltd.","email":"jasonay0115@gmail.com","tel":"94939341","address":"Unit A, 14\/F, Vulcan House, 21-23 Leighton Road, Causeway Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1205.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-14","renew_room_key":"055,48768","renew_remark":"3 months contract. Storage rental paid by cheque deposit on September 20, 2019. Storage deposit transferred from agreement A12-CT195259 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196007, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"203","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1451.60","discount":"5.00","monthly_deduct":76.4,"room_id":"61","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":1451.6,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1205,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3615,"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-03-13","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque deposit on December 16, 2019. Storage deposit transferred from agreement A12-CT196007 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3615,"final_order_total":3615,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,48768","order_product":[],"pass":true}},"first_order_id":"4410","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> B09 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.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":"20","total_discounted_price":"1205.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33:37","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",603,"NEW","A12-CT196728",1528,1205,0,0,"3","3",3615,3615,3615,"2019-12-18 11:33:37","0",null,null,null,"2019-12-14","2020-03-13","3 months contract. Storage rental paid by cheque deposit on December 16, 2019. Storage deposit transferred from agreement A12-CT196007 to this agreement.\r\n","2019-12-14","20",0,null,0,"0","2","2019-12-18 11:33:37","2","2019-12-18 11:33:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,48768","C170603","BUSINESS","Mr","L8PefY4fO30Q8ah3IheR+A==","1uwueeCdnD7fsnq6HEHgPQ==","J & M Merchandising Ltd.","9\/RudMZtO+RooA3vr9b\/NCCHzAVNDStvj4j4iJD1YxTKOQ8r86iecTt50cG6gGCEy1loSGY7rt4TIYTAuK5A+nlO3Rw4ijsB2Ng4+H8BOOc=","Y4ETi6Z203ojuSPCkql+LA==","yGnTFVSy5GDdTFH1KsCbH8P3tH23+LqlW1MadmJKF9s=",null,"L\/L04tL1KwAXTf\/XIAPmWg==",1,"4410"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["6728","203","10","61","%","5.00",76.4,"2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["6728","61","1528.0",1451.6,"2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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-14","2020-03-13","61"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 11:33: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":["6728",603,"SETTLED","A12-I197056","2019-12-18 11:33:37","2019-12-14","2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["7056","RENT","\u9810\u7e73\u79df\u91d1",1,1205,"MO","1",1205,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["7056","RENT","\u9810\u7e73\u79df\u91d1",2,1205,"MO","1",1205,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["7056","RENT","\u9810\u7e73\u79df\u91d1",3,1205,"MO","1",1205,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33:37","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3615,0,"7056"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 11:33: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":[603,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196706","2019-12-18 11:33:37",3615,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["6706","DEPOSIT",null,"PAID","2019-12-18 11:33:37",0,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:33: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":["6706","INVOICE","7056","PAID","2019-12-18 11:33:37",3615,"2","2019-12-18 11:33:37","2","2019-12-18 11:33:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:36:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:36:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:37","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&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":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":525,"customer_code":"C170525","identity_type":"PERSONAL","identity_id":"G161193(2)","title":"Ms","lastname":"Man","firstname":"Fung Yi Roni","companyname":"","email":"manroni@kawinghong.com","tel":"54362045","address":"\u9999\u6e2f\u8d64\u67f1\u9f8d\u5fb7\u82d1\u6649\u5fb7\u95a32\u6a1313\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2336.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-21","renew_room_key":"056,13866","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 19, 2019. Storage deposit transferred from agreement A14-CT196230 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196456, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"544","room_code":"L22(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"545","room_code":"L23","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2440,"total_discounted_price":2336,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2336,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-01-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196456 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2336,"final_order_total":2336,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,13866","order_product":[],"pass":true}},"first_order_id":"4877","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L22(\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> L23 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2336.0","deposit":"0","total_retail_price":"2440.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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",525,"NEW","A14-CT196729",2440,2336,0,0,"1","1",2336,2336,2336,"2019-12-18 11:45:38","0",null,null,null,"2019-12-21","2020-01-20","1 month contract. Storage rental paid by bank transfer on December 17, 2019. Storage deposit transferred from agreement A14-CT196456 to this agreement.","2019-12-21","32",0,null,0,"0","2","2019-12-18 11:45:37","2","2019-12-18 11:45:37","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,13866","C170525","PERSONAL","Ms","ibYrH9hZ8AxKQwoDOyRf7g==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","6FEfBp4QinpFgaVk\/XySHjwYeKgnpkSt7nsZEe9qVfgX7gsIGumX1P5i\/O8D1hN0","kjGiWZ21y1YpwaPjV74WsA==","qyZUZxcd5Fov\/z6YWfj+Qzvwf4EvFlsT926fUqJ1c+g=","CTeh4\/H1iVpxG8qx2JRcpg==",null,1,"4877"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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":["6729","544","1342.0","1342.00","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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-01-20","544"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 11:45:38","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":["6729","545","1098.0","1098.00","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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-01-20","545"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 11:45:38","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":["6729",525,"SETTLED","A14-I197057","2019-12-18 11:45:37","2019-12-21","2","2019-12-18 11:45:37","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7057","RENT","\u9810\u7e73\u79df\u91d1",1,2336,"MO","1",2336,"2","2019-12-18 11:45:37","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2336,0,"7057"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 11:45:38","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":[525,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196707","2019-12-18 11:45:37",2336,"2","2019-12-18 11:45:37","2","2019-12-18 11:45:37","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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":["6707","DEPOSIT",null,"PAID","2019-12-18 11:45:37",0,"2","2019-12-18 11:45:37","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:45:38","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":["6707","INVOICE","7057","PAID","2019-12-18 11:45:37",2336,"2","2019-12-18 11:45:37","2","2019-12-18 11:45:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 11:46:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":502,"customer_code":"C170502","identity_type":"PERSONAL","identity_id":"K070694(9)","title":"Ms","lastname":"Tang","firstname":"Suet Fan","companyname":"","email":"suetfan168@hotmail.com","tel":"62283821","address":"Room 6, 5\/F , Blk B, ABBA House, 227 Aberdeen Main Road, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2668.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-29","renew_room_key":"055,48157","renew_remark":"12 months contract. Storage rental paid by bank transfer on December 18, 2018. Storage deposit transferred from agreement SD14-CT182506 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183951, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"68","order_discount":[],"order_room":[{"room_id":"540","room_code":"L18(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"539","room_code":"L17(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"538","room_code":"L16(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"48","total_retail_price":4026,"total_discounted_price":2668,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":32016,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-29","rent_from":"2019-12-29","rent_to":"2020-12-28","delivery_service":"0","remark":"12 months contract. $300 Maxsim coupon offered. Storage rental paid by cheque on December 18,2019. Storage deposit transferred from agreement A14-CT183951 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":32016,"final_order_total":32016,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,48157","order_product":[],"pass":true}},"first_order_id":3951,"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> L18(\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> L17(\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> L16(\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":"48","total_discounted_price":"2668.0","deposit":"0","total_retail_price":"4026.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",502,"NEW","A14-CT196730",4026,2668,0,0,"12","12",32016,32016,32016,"2019-12-18 14:29:57","0",null,null,null,"2019-12-29","2020-12-28","12 months contract. $300 Maxsim coupon offered. Storage rental paid by cheque on December 18,2019. Storage deposit transferred from agreement A14-CT183951 to this agreement.","2019-12-29","48",0,null,0,"0","2","2019-12-18 14:29:56","2","2019-12-18 14:29:56","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"055,48157","C170502","PERSONAL","Ms","fwS+OOppNdCM2tqpfUUxNw==","M7CfcmE2OSMlZOkNgaoDmQ==","","SaTgH8TExFazFwIsyyfT68qxDJ7NdRLCx+\/uLPpvf8Ah+RqoadYxNjxkOumPdviAZnp3J3pbJBGlfpSnqbX2Gix+36viAG4M1jJGG2AATRs=","haQqL\/EB6wuj5re2\/6VdXw==","3BxAfJGbpRAuUGaT6WBqdiBEnIKfX0n5FUcIrKyen7M=","KfRAfOaxzb57loCVrLVGMQ==",null,1,3951]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6730","540","1342.0","1342.00","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-29","2020-12-28","540"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6730","539","1342.0","1342.00","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-29","2020-12-28","539"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6730","538","1342.0","1342.00","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-29","2020-12-28","538"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6730",502,"SETTLED","A14-I197058","2019-12-18 14:29:56","2019-12-29","2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",1,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",2,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",3,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",4,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",5,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",6,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",7,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",8,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",9,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",10,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",11,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7058","RENT","\u9810\u7e73\u79df\u91d1",12,2668,"MO","1",2668,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[32016,0,"7058"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[502,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196708","2019-12-18 14:29:56",32016,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6708","DEPOSIT",null,"PAID","2019-12-18 14:29:56",0,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:29:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6708","INVOICE","7058","PAID","2019-12-18 14:29:56",32016,"2","2019-12-18 14:29:56","2","2019-12-18 14:29:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1021&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1246","master_room_id":"144","room_code":"B01-056"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1408,"customer_code":"C191408","identity_type":"PERSONAL","identity_id":"G124622(3)","title":"Mr","lastname":"LAM","firstname":"Ping Fai","companyname":"","email":null,"tel":"64168678","address":"Rm A, 31\/F, Flat 3, Ocean Court Aberdeen","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2468.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-03","renew_room_key":"190,26667","renew_remark":"3 months contract. Special offer 5% discount. $500 deposit paid on Sep 6,2019. Remaining balance $11731 paid by cash on Sep 28,2019. Smartcard provided on Sep 28,2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196034, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $5196.0","renew_master_room_id":"57","order_discount":[],"order_room":[{"room_id":"778","room_code":"P12","retail_price":"2598.0","discounted_price":"2598.00","location_id":"2"}],"roughly_size":"36","total_retail_price":2598,"total_discounted_price":2598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2020-02-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by EPS on Dec 18,2019. Deposit $5196 transferred from agreement A14-CT196034 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"EPS","discount_deduct":0,"order_total":2598,"final_order_total":2598,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,26667","order_product":[],"pass":true}},"first_order_id":6034,"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> P12 <\/td>\r\n\t\t\t\t\t 6X6X8 <\/td>\r\n\t\t\t\t\t $2598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"36","total_discounted_price":"2598.00","deposit":"0.00","total_retail_price":"2598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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",1408,"NEW","A14-CT196731",2598,2598,0,0,"1","1",2598,2598,2598,"2019-12-18 14:37:16","0",null,null,null,"2020-01-03","2020-02-02","1 month contract. Storage rental paid by EPS on Dec 18,2019. Deposit $5196 transferred from agreement A14-CT196034 to this agreement.","2020-01-03","36",0,null,0,"0","2","2019-12-18 14:37:16","2","2019-12-18 14:37:16","NO_NEED_PAID_RENEW","","","","EPS","","","",null,0,"190,26667","C191408","PERSONAL","Mr","ZznTJqU4lYVW67BI5cauZQ==","BLxWt7e4owYJMFkn6\/eeMQ==","","F90yJYJQE1YWNCheTItGezqFxHmPT4X8W0r1Qf37GjnCIbX01np9GuwkVfOGg5sG","XoKcRHoS13bHw\/Q8qkfTWg==",null,"w34QCv+4DQiCzr4lfVlW1A==",null,1,6034]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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":["6731","778","2598.0","2598.00","2","2019-12-18 14:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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":["2020-01-03","2020-02-02","778"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 14:37: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":["6731",1408,"SETTLED","A14-I197059","2019-12-18 14:37:16","2020-01-03","2","2019-12-18 14:37:16","2","2019-12-18 14:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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":["7059","RENT","\u9810\u7e73\u79df\u91d1",1,2598,"MO","1",2598,"2","2019-12-18 14:37:16","2","2019-12-18 14:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2598,0,"7059"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 14:37: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":[1408,"NO_NEED_PAID_RENEW","","","","EPS","","","","PAID","P196709","2019-12-18 14:37:16",2598,"2","2019-12-18 14:37:16","2","2019-12-18 14:37:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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":["6709","DEPOSIT",null,"PAID","2019-12-18 14:37:16",0,"2","2019-12-18 14:37:16","2","2019-12-18 14:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:37: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":["6709","INVOICE","7059","PAID","2019-12-18 14:37:16",2598,"2","2019-12-18 14:37:16","2","2019-12-18 14:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 14:43:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 15:12:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 15:51:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 16:42:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 16:43:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1399,"customer_code":"C191399","identity_type":"PERSONAL","identity_id":"E575975(0)","title":"Ms","lastname":"Chan","firstname":"Hay Lin Helina","companyname":"","email":null,"tel":"63338303","address":"Flat A, 5\/F, Lee Loy Building, 208-214 Jaffe Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1709.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-23","renew_room_key":"0012492259","renew_remark":"3 months contract. Special offer, 5% off and $200 discount from other storage change to our storage. Storage rental and deposit paid by EPS on September 18, 2019. Smartcard and padlock keys provided on September 18, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT195970, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1798.0","renew_master_room_id":"175","order_discount":[{"master_room_discount_id":"425","master_room_id":"175","discount_type":"%","price":"1798.00","disocunted_price":"1709.00","discount":"4.95","monthly_deduct":89.001,"room_id":"1336","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1336","room_code":"C15-030","retail_price":"1798.0","discounted_price":1709,"location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1709,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5127,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-23","rent_from":"2019-12-23","rent_to":"2020-03-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit $1798 transferred from agreement C15-CT195970 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5127,"final_order_total":5127,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012492259","order_product":[],"pass":true}},"first_order_id":5970,"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-030 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"1709.0","deposit":"0","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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",1399,"NEW","C15-CT196732",1798,1709,0,0,"3","3",5127,5127,5127,"2019-12-18 17:22:24","0",null,null,null,"2019-12-23","2020-03-22","3 months contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit $1798 transferred from agreement C15-CT195970 to this agreement. ","2019-12-23","32",0,null,0,"0","2","2019-12-18 17:22:24","2","2019-12-18 17:22:24","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012492259","C191399","PERSONAL","Ms","dgnQEcVZi1EZLjTWX+ppYw==","U9yoE9KqV1v8YlRkf7Q2yg==","","ywVxvk05TgD8Wb2m2UZRlq8FoT4im6LKUpPN8M3pTRVWzNO4mytYaNOMiLvHGM88TQIeUSx1LClBwD6L8rsOsrj7AvphN89zrg0I0JpT6Vg=","ReWy0y\/qiou4+0w7t2ORWQ==",null,"3qRHtmtirKwYMExOWh5yCg==",null,1,5970]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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":["6732","425","175","1336","%","4.95",89.001,"2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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":["6732","1336","1798.0",1709,"2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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-23","2020-03-22","1336"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 17:22:24","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":["6732",1399,"SETTLED","C15-I197060","2019-12-18 17:22:24","2019-12-23","2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7060","RENT","\u9810\u7e73\u79df\u91d1",1,1709,"MO","1",1709,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7060","RENT","\u9810\u7e73\u79df\u91d1",2,1709,"MO","1",1709,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7060","RENT","\u9810\u7e73\u79df\u91d1",3,1709,"MO","1",1709,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5127,0,"7060"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 17:22:24","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":[1399,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196710","2019-12-18 17:22:24",5127,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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":["6710","DEPOSIT",null,"PAID","2019-12-18 17:22:24",0,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:22:24","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":["6710","INVOICE","7060","PAID","2019-12-18 17:22:24",5127,"2","2019-12-18 17:22:24","2","2019-12-18 17:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":822,"customer_code":"C180822","identity_type":"PERSONAL","identity_id":"P536999(5)","title":"Mr","lastname":"LEI","firstname":"IOK I","companyname":"","email":"ioki@netvigator.com","tel":"61027222","address":"Flat 15B, Twin Brook, 43 Repulse Bay Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-20","renew_room_key":"053,50128","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit transferred from agreement A12-CT196208 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196450, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"337","room_code":"F22","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"326","room_code":"F11","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2020-01-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit transferred from agreement A12-CT196450 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,50128","order_product":[],"pass":true}},"first_order_id":"4843","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> F22 <\/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> F11 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26: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",822,"NEW","A12-CT196733",2096,2058,0,0,"1","1",2058,2058,2058,"2019-12-18 17:26:16","0",null,null,null,"2019-12-20","2020-01-19","1 month contract. Storage rental paid by bank transfer on December 18, 2019. Storage deposit transferred from agreement A12-CT196450 to this agreement.\r\n","2019-12-20","28",0,null,0,"0","2","2019-12-18 17:26:16","2","2019-12-18 17:26:16","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,50128","C180822","PERSONAL","Mr","ZARR3F9DLOjNhWXHL6JFWw==","T7yW\/GgDIBeB5D+4Gc1Low==","","hnzJCmTji9piYfzerefUu\/TJM7yQKQZ\/PbVcIOLxAT9UBe9irR\/dwTUmCzW2KngqC9NlM39pxcLMojd\/5VQoqA==","4crgvokPCzNQ8+tQ54dSnA==","CWE+zIdqCgJYA4ODEL3nC2Sl7MaIf8shJOmM5VxZrN8=","uk0qyjxHCwGFsgy\/rb\/L0g==",null,1,"4843"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26: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":["6733","337","1098.0","1098.00","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-20","2020-01-19","337"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 17:26: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":["6733","326","998.0","998.00","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-20","2020-01-19","326"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 17:26: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":["6733",822,"SETTLED","A12-I197061","2019-12-18 17:26:16","2019-12-20","2","2019-12-18 17:26:16","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26: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":["7061","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2019-12-18 17:26:16","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7061"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 17:26: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":[822,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196711","2019-12-18 17:26:16",2058,"2","2019-12-18 17:26:16","2","2019-12-18 17:26:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26: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":["6711","DEPOSIT",null,"PAID","2019-12-18 17:26:16",0,"2","2019-12-18 17:26:16","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:26: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":["6711","INVOICE","7061","PAID","2019-12-18 17:26:16",2058,"2","2019-12-18 17:26:16","2","2019-12-18 17:26:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 17:47:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1476","master_room_id":"173","room_code":"C15-170"}],"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-170 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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":"1","identity_type":"PERSONAL","identity_id":"Z809328(9)","title":"Mr","lastname":"WONG","firstname":"Chung Hang","companyname":"","email":"ansonwong26@gmail.com","tel":"97531463","address":"20\/F B, Wah Tong Bldg, Shan Kei Wan Road 28-44, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"443","master_room_id":"173","discount_type":"%","price":"1322.00","disocunted_price":"991.90","discount":"24.97","monthly_deduct":330.1034,"room_id":"1476","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1476","room_code":"C15-170","retail_price":"1322.0","discounted_price":991.9,"location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1190,"deposit":1322,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":12632,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2970.00","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-12-31","delivery_service":"0","remark":"12 months contract. Special offer 2 months free and 5% 'Rent Now' discount. Storage rental and deposit paid by EPS on December 18, 2019. Smartcard provided on December 18, 2019.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":2970,"order_total":15602,"final_order_total":12632,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012414153","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1190.00","deposit":"1322.00","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C191473","PERSONAL","Mr","npiHMr\/Z9wXMUADks\/OtaA==","ddrfzAYTmkL\/QNu3psjONQ==","","e8mlnqs9sIpQaVlRwemh\/A==","m5Q0PLhrwnNwnth0gummpX9ZikW0CR+PB+ifY5ZodbA=","KSCNr5kR\/e61yYYAjSfyuXMt7Fsb+7OScNv0YV8p3Tzuid8mEEE62GrYhTe1PrEwDyOPCxG05uVaMPW4VkAqog==","Uhc\/F+qt9qbAVE8lzGemrQ==",null,"m5Q0PLhrwnNwnth0gummpX9ZikW0CR+PB+ifY5ZodbA=","hoWoJFUOpfv0HfyBrCoGuA==","2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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",1473,"NEW","C15-CT196734",1322,1190,1322,0,"12","12",12632,15602,12632,"2019-12-18 19:05:58","0",null,null,null,"2020-01-01","2020-12-31","12 months contract. Special offer 2 months free and 5% 'Rent Now' discount. Storage rental and deposit paid by EPS on December 18, 2019. Smartcard provided on December 18, 2019.","2020-01-01","24",0,null,2970,"2970.00","2","2019-12-18 19:05:56","2","2019-12-18 19:05:56","EPS","","","","EPS","","","",null,0,"'0012414153","C191473","PERSONAL","Mr","npiHMr\/Z9wXMUADks\/OtaA==","ddrfzAYTmkL\/QNu3psjONQ==","","KSCNr5kR\/e61yYYAjSfyuXMt7Fsb+7OScNv0YV8p3Tzuid8mEEE62GrYhTe1PrEwDyOPCxG05uVaMPW4VkAqog==","e8mlnqs9sIpQaVlRwemh\/A==","m5Q0PLhrwnNwnth0gummpX9ZikW0CR+PB+ifY5ZodbA=","Uhc\/F+qt9qbAVE8lzGemrQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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":["6734","443","173","1476","%","24.97",330.1034,"2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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":["6734","1476","1322.0",991.9,"2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-12-31","1476"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-18 19:05:58","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":["6734","C15-D195226","PAID",1322,0,"2020-12-31","2019-12-18 19:05:56","2019-12-18 19:05:56","2","2019-12-18 19:05:56","2","2019-12-18 19:05:56",1473]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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":["6734",1473,"SETTLED","C15-I197062","2019-12-18 19:05:56","2020-01-01","2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,600,"MO","1",600,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",4,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",5,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",6,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",7,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",8,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",9,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",10,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",11,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7062","RENT","\u9810\u7e73\u79df\u91d1",12,1190,"MO","1",1190,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11310,0,"7062"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-18 19:05:58","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":[1473,"EPS","","","","EPS","","","","PAID","P196712","2019-12-18 19:05:56",12632,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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":["6712","DEPOSIT","5226","PAID","2019-12-18 19:05:56",1322,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-18 19:05:58","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":["6712","INVOICE","7062","PAID","2019-12-18 19:05:56",11310,"2","2019-12-18 19:05:56","2","2019-12-18 19:05:56"]},"data_before":[],"data_after":[],"step":1} *****