{"created_at":"2019-12-31 09:36:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1094,"customer_code":"C181094","identity_type":"PERSONAL","identity_id":"D582520(3)","title":"Ms","lastname":"Tang","firstname":"Man Wah","companyname":"","email":"hkmstang@yahoo.com.hk","tel":"96660097","address":"Flat 16B, Block 8, Chi Fu Fa Yuen, Pok Fu Lam, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1162.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-29","renew_room_key":"0012474097","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by EPS on November 15, 2018. Smartcard provided on November 15, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183620, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[{"master_room_discount_id":"251","master_room_id":"114","discount_type":"%","price":"1290.00","disocunted_price":"1161.00","discount":"10.00","monthly_deduct":129,"room_id":"1134","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1134","room_code":"A05-132","retail_price":"1290.0","discounted_price":1161,"location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6972,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-29","rent_from":"2019-11-29","rent_to":"2020-05-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $2580 transferred from agreement A05-CT183620 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6972,"final_order_total":6972,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012474097","order_product":[],"pass":true}},"first_order_id":3620,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
A05-132 <\/td>\r\n\t\t\t\t\t	4X4X7 <\/td>\r\n\t\t\t\t\t	$1290.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1094,"NEW","A05-CT196810",1290,1162,0,0,"6","6",6972,6972,6972,"2019-12-31 10:23:09","0",null,null,null,"2019-11-29","2020-05-28","6 months contract. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $2580 transferred from agreement A05-CT183620 to this agreement. \r\n","2019-11-29","16",0,null,0,"0","2","2019-12-31 10:23:09","2","2019-12-31 10:23:09","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012474097","C181094","PERSONAL","Ms","m8IyXQKrF2ZOZb2XRwl5kA==","M7CfcmE2OSMlZOkNgaoDmQ==","","DrHf\/dQXfJcK8fP1acYDYDu\/fI2CG1L4wcGspIGn+T0kzEtSQE2JqUlyG0GuIFGjAgC9cTKy\/zPLQo0nOjJ8Bg==","sQXz0YH\/39L8UM8GZhhUZg==","Um+L\/mlFBNLFjQLQAewPKJDjTGmboWyZ2k0iqLEkfGc=","F\/4+rVVGZz0finaD4SDL\/g==",null,1,3620]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6810","251","114","1134","%","10.00",129,"2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6810","1134","1290.0",1161,"2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-29","2020-05-28","1134"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6810",1094,"SETTLED","A05-I197138","2019-12-31 10:23:09","2019-11-29","2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7138","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:09","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"7138"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 10:23:10","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":[1094,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196788","2019-12-31 10:23:09",6972,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:10","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":["6788","DEPOSIT",null,"PAID","2019-12-31 10:23:09",0,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:23:10","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":["6788","INVOICE","7138","PAID","2019-12-31 10:23:09",6972,"2","2019-12-31 10:23:09","2","2019-12-31 10:23:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"473","master_room_id":"68","room_code":"K10"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":23,"customer_code":"C150023","identity_type":"PERSONAL","identity_id":"K474882(4)","title":"Mr","lastname":"Chau","firstname":"Pak Wing","companyname":"","email":"ryuchau2002@yahoo.com.hk","tel":"93430664","address":"3102 ,Tung Ping House Lei Tung Estate ,Aplei chau","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"2","renew_warehousing_date":"2019-11-01","renew_room_key":"054,43987","renew_remark":"2 months contract. Storage rental paid by bank transfer on October 9, 2019. Storage deposit transferred from agreement A12-CT195584 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196102, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"11","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"11","room_code":"A11","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2967,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-01","rent_from":"2019-11-01","rent_to":"2020-01-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 30, 2019. Storage deposit transferred from agreement A12-CT196102 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,43987","order_product":[],"pass":true}},"first_order_id":"4412","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> A11 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",23,"NEW","A12-CT196811",1098,989,0,0,"3","3",2967,2967,2967,"2019-12-31 10:47:43","0",null,null,null,"2019-11-01","2020-01-31","3 months contract. Storage rental paid by bank transfer on December 30, 2019. Storage deposit transferred from agreement A12-CT196102 to this agreement.","2019-11-01","16",0,null,0,"0","2","2019-12-31 10:47:42","2","2019-12-31 10:47:42","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,43987","C150023","PERSONAL","Mr","B0ssw1oIHiki\/Mlb0\/ZDSA==","kOK3vHUlGE9qjoVnzYRDGA==","","PMBzwNQFgvH59lb5Tkl4pvuUMLbNYb\/kdCEBfa2Rd1BuIU1Im27uZJ2kVFx8y4u9KSaRxbwqsPYl3\/wAUgZh7A==","bdymBw6yNxCy25GcBqnAeg==","Yy\/IhnBFwxEgMvMojm6H7pEUv5uRc+ZriXItPiCRhkk=","rpqpQ1cQv7jbufDPn4zVZw==",null,1,"4412"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","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":["6811","433","8","11","%","4.97",54.5706,"2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6811","11","1098.0",1043.4,"2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-01","2020-01-31","11"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6811",23,"SETTLED","A12-I197139","2019-12-31 10:47:42","2019-11-01","2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7139","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7139","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7139","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"7139"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[23,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196789","2019-12-31 10:47:42",2967,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6789","DEPOSIT",null,"PAID","2019-12-31 10:47:42",0,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 10:47:43","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6789","INVOICE","7139","PAID","2019-12-31 10:47:42",2967,"2","2019-12-31 10:47:42","2","2019-12-31 10:47:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 11:05:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 11:40:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 11:40:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 12:27:33","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 12:28:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 12:29:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 12:30:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 12:53:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 14:35:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 14:36:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 14:38:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=655&filter3=undefined","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":"1","customer_id":61,"customer_code":"C160061","identity_type":"PERSONAL","identity_id":"D702193(4)","title":"Ms","lastname":"SHIU","firstname":"Man Kei","companyname":"","email":"m138sk@yahoo.com.hk","tel":"91927282","address":"Room 807, Wah Sang House, Wah Fu Estate, Hong Kong","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"12","renew_warehousing_date":"2020-11-28","renew_room_key":"055,53772 ","renew_remark":"12 months contract. Storage rental $11220 and lovebox rental $80 paid by cheque on Nov 23,2019. $300 Maxim coupon offered. Storage deposit transferred from agreement A12-CT183841 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196482, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72 available_room_list_input","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1098.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"30","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"30","room_code":"A30","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":2196,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":7836,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"294.00","warehousing_date":"2019-12-31","rent_from":"2019-12-31","rent_to":"2020-06-30","delivery_service":"0","remark":"6 months contract. Special offer 5% discount. Storage rental and deposit paid by EPS on Dec 31,2019. Smartcard and padlock provided on Dec 31,2019.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":294,"order_total":8130,"final_order_total":7836,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":"3841","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A30 <\/td>\n\t\t\t\t\t 4X4X8 <\/td>\n\t\t\t\t\t $1098.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed812\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\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21:55","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":["C191482","PERSONAL","Ms","L8PefY4fO30Q8ah3IheR+A==","mXmv4d2bSmE7+n+365XfYQ==","","dSHIBeqt\/av13mpmHd6hrA==","gDtbDEe43SHyUhihZ+3ytyqV\/MGSHmDb3179QS+ow4k=","YTm5N207ixGS8o+cFdUkcNUFK3PoWMJhJkhUFIli6FNuGHEz9IPuEWdt0y4AGgjmBKz\/tFHB0e5BujMB8hiLlg==","o3R20+m8xBw1se2kLP\/1rw==",null,"gDtbDEe43SHyUhihZ+3ytyqV\/MGSHmDb3179QS+ow4k=","pVwUkCgNyOP6RC9r\/\/ohQg==","2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1482,"NEW","A12-CT196812",1098,989,2196,0,"6","6",7836,8130,7836,"2019-12-31 15:21:55","0",null,null,null,"2019-12-31","2020-06-30","6 months contract. Special offer 5% discount. Storage rental and deposit paid by EPS on Dec 31,2019. Smartcard and padlock provided on Dec 31,2019.","2019-12-31","16",0,null,294,"294.00","2","2019-12-31 15:21:53","2","2019-12-31 15:21:53","EPS","","","","EPS","","","",null,0,"","C191482","PERSONAL","Ms","L8PefY4fO30Q8ah3IheR+A==","mXmv4d2bSmE7+n+365XfYQ==","","YTm5N207ixGS8o+cFdUkcNUFK3PoWMJhJkhUFIli6FNuGHEz9IPuEWdt0y4AGgjmBKz\/tFHB0e5BujMB8hiLlg==","dSHIBeqt\/av13mpmHd6hrA==","gDtbDEe43SHyUhihZ+3ytyqV\/MGSHmDb3179QS+ow4k=","o3R20+m8xBw1se2kLP\/1rw==",null,1,"3841"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21:55","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6812","72 available_room_list_input","8","30","%","9.93",109.0314,"2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["6812","30","1098.0",989,"2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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-31","2020-06-30","30"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 15:21: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":["6812","A12-D195236","PAID",2196,0,"2020-06-30","2019-12-31 15:21:53","2019-12-31 15:21:53","2","2019-12-31 15:21:53","2","2019-12-31 15:21:53",1482]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["6812",1482,"SETTLED","A12-I197140","2019-12-31 15:21:53","2019-12-31","2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,695,"MO","1",695,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["7140","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5640,0,"7140"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 15:21: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":[1482,"EPS","","","","EPS","","","","PAID","P196790","2019-12-31 15:21:53",7836,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["6790","DEPOSIT","5236","PAID","2019-12-31 15:21:53",2196,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 15:21: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":["6790","INVOICE","7140","PAID","2019-12-31 15:21:53",5640,"2","2019-12-31 15:21:53","2","2019-12-31 15:21:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":"filter1=2&filter2=655&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":675,"customer_code":"C170675","identity_type":"PERSONAL","identity_id":"D219583(7)","title":"Mr","lastname":"Pun","firstname":"Wing Cheong","companyname":"","email":null,"tel":"93211435","address":"Flat 3413, Tung Ping House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1605.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-01","renew_room_key":"055,43050","renew_remark":"1 month contract. Storage rental paid by bank transfer on October 17, 2019, 2019. Storage deposit transferred from agreement A18-CT195594 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196165, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"252","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"922","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"922","room_code":"U23","retail_price":"1605.0","discounted_price":1524.8,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-01","rent_from":"2019-11-01","rent_to":"2020-01-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT196165 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,43050","order_product":[],"pass":true}},"first_order_id":"4424","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> U23 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1525.00","deposit":"0.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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","3",675,"NEW","A18-CT196813",1605,1525,0,0,"3","3",4575,4575,4575,"2019-12-31 16:18:57","0",null,null,null,"2019-11-01","2020-01-31","3 months contract. Storage rental paid by bank transfer on Dec 30, 2019. Storage deposit transferred from agreement A18-CT196165 to this agreement.","2019-11-01","20",0,null,0,"0","2","2019-12-31 16:18:56","2","2019-12-31 16:18:56","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,43050","C170675","PERSONAL","Mr","zRl2wRT0bzGoBjayPtj0bg==","\/jZHfDSzBL6DMeP8beh11g==","","rQco+JL2vKS2IoKrZwA1yaG3nzWq9+b9wc4T7W6Yt5olYDVZu54iSWq\/s0b5tugnFNud6gxx+RBPNAHg26JO7xa3o0irEl2KUDPUiuatuPs=","8b1BJH8lCd7DJqxRE314HA==",null,"Od0RWXaEAXXPAqK4kTG2DQ==",null,1,"4424"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18:57","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":["6813","252","78","922","%","5.00",80.25,"2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["6813","922","1605.0",1524.8,"2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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-11-01","2020-01-31","922"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 16:18: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":["6813",675,"SETTLED","A18-I197141","2019-12-31 16:18:56","2019-11-01","2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["7141","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["7141","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["7141","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"7141"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 16:18: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":[675,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196791","2019-12-31 16:18:56",4575,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["6791","DEPOSIT",null,"PAID","2019-12-31 16:18:56",0,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:18: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":["6791","INVOICE","7141","PAID","2019-12-31 16:18:56",4575,"2","2019-12-31 16:18:56","2","2019-12-31 16:18:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=655&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":318,"customer_code":"C170318","identity_type":"BUSINESS","identity_id":"39005532","title":"Mr","lastname":"KWONG","firstname":"Hing Yu","companyname":"TESTIME","email":"eleph@testime.com","tel":"69937113","address":"16\/F,Cornwall House ,979 Kings Road ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"775.0","renew_rent_month":"2","renew_warehousing_date":"2019-11-24","renew_room_key":"055,55271","renew_remark":"2 months contract. Storage rental paid by bank transfer on November 8, 2019. Storage deposit transferred from agreement A12-CT195794 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A12-CT195794, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196332, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"2","order_discount":[{"master_room_discount_id":"400","master_room_id":"2","discount_type":"%","price":"814.00","disocunted_price":"773.00","discount":"5.04","monthly_deduct":41.0256,"room_id":"291","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"291","room_code":"E18","retail_price":"814.0","discounted_price":773,"location_id":"1"}],"roughly_size":"9","total_retail_price":814,"total_discounted_price":775,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2325,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-24","rent_from":"2019-11-24","rent_to":"2020-02-23","delivery_service":"0","remark":"3 months contract. Storage rental $775\/month paid by bank transfer on Dec 31, 2019. Storage deposit transferred from agreement A12-CT196332 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2325,"final_order_total":2325,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,55271","order_product":[],"pass":true}},"first_order_id":"3087","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> E18 <\/td>\r\n\t\t\t\t\t 3X3X8 <\/td>\r\n\t\t\t\t\t $814.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":"9","total_discounted_price":"775.00","deposit":"0.00","total_retail_price":"814.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","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",318,"NEW","A12-CT196814",814,775,0,0,"3","3",2325,2325,2325,"2019-12-31 16:23:44","0",null,null,null,"2019-11-24","2020-02-23","3 months contract. Storage rental $775\/month paid by bank transfer on Dec 31, 2019. Storage deposit transferred from agreement A12-CT196332 to this agreement.","2019-11-24","9",0,null,0,"0","2","2019-12-31 16:23:44","2","2019-12-31 16:23:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,55271","C170318","BUSINESS","Mr","S0as6uZW15WoTuSpn5+5OA==","A56wv0bn2sxwj32M4vQv7w==","TESTIME","bq6yEKbGLjVPnDLwPodYatE\/jCeU+4vjFWjWb2ioaJ83e2A8P9m5XZxMQuFgzPQf","AkMgb+SSpa6aRBPJv2715w==","kPKIeax9Qp5drcJ0ZHlyW0nsgaTHHmqBftyOzQNUihE=",null,"KgX5oWIK9K5qs+V5NXOnwg==",1,"3087"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","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":["6814","400","2","291","%","5.04",41.0256,"2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","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":["6814","291","814.0",773,"2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-24","2020-02-23","291"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 16:23:44","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":["6814",318,"SETTLED","A12-I197142","2019-12-31 16:23:44","2019-11-24","2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7142","RENT","\u9810\u7e73\u79df\u91d1",1,775,"MO","1",775,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7142","RENT","\u9810\u7e73\u79df\u91d1",2,775,"MO","1",775,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7142","RENT","\u9810\u7e73\u79df\u91d1",3,775,"MO","1",775,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2325,0,"7142"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 16:23:44","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":[318,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196792","2019-12-31 16:23:44",2325,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","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":["6792","DEPOSIT",null,"PAID","2019-12-31 16:23:44",0,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:23:44","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":["6792","INVOICE","7142","PAID","2019-12-31 16:23:44",2325,"2","2019-12-31 16:23:44","2","2019-12-31 16:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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":"filter1=2&filter2=655&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":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":441,"customer_code":"C170441","identity_type":"PERSONAL","identity_id":"K187210(9)","title":"Mr","lastname":"Leung","firstname":"Kwong Chi","companyname":"","email":"kckelvin@gmail.com","tel":"94625268","address":"Flat 3113,Pik Yuet House,Shek Pai Wan Estate","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-17","renew_room_key":"053,48941","renew_remark":"1 month contract. Storage rental paid by bank transfer on December 10, 2019. Storage deposit transferred from agreement A12-CT196237 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196656, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"101","room_code":"B49","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-17","rent_from":"2020-01-17","rent_to":"2020-02-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 31, 2019. Storage deposit transferred from agreement A12-CT196656 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,48941","order_product":[],"pass":true}},"first_order_id":"4848","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> B49 <\/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":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",441,"NEW","A12-CT196815",1528,1286,0,0,"1","1",1286,1286,1286,"2019-12-31 16:37:55","0",null,null,null,"2020-01-17","2020-02-16","1 month contract. Storage rental paid by bank transfer on December 31, 2019. Storage deposit transferred from agreement A12-CT196656 to this agreement.","2020-01-17","20",0,null,0,"0","2","2019-12-31 16:37:55","2","2019-12-31 16:37:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,48941","C170441","PERSONAL","Mr","+dEjQsGfUIM77pS0ke1UNg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","WXAxv4MtPIFgHWZXkMsPE5BEGcBZNXBFpYp6GbukVe41gB3Im3As7f4Wn1yvLqKB","3XEnDPIYj\/Bc8Nw\/mL4YlA==","HqPua0wMa9D6F9q3F52tnLhm3HWWBu1s1N0CWtgara4=","n8KZV65hrsIsZlgzHveC2A==",null,1,"4848"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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":["6815","101","1528.0","1528.00","2","2019-12-31 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2020-02-16","101"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 16:37: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":["6815",441,"SETTLED","A12-I197143","2019-12-31 16:37:55","2020-01-17","2","2019-12-31 16:37:55","2","2019-12-31 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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":["7143","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2019-12-31 16:37:55","2","2019-12-31 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7143"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 16:37: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":[441,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196793","2019-12-31 16:37:55",1286,"2","2019-12-31 16:37:55","2","2019-12-31 16:37:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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":["6793","DEPOSIT",null,"PAID","2019-12-31 16:37:55",0,"2","2019-12-31 16:37:55","2","2019-12-31 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:37: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":["6793","INVOICE","7143","PAID","2019-12-31 16:37:55",1286,"2","2019-12-31 16:37:55","2","2019-12-31 16:37:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=655&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":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":259,"customer_code":"C160259","identity_type":"PERSONAL","identity_id":"D649664(5)","title":"Mr","lastname":"Tsang ","firstname":"Kwok Hung","companyname":"","email":"kevintsang18@yahoo.com.hk","tel":"91072185","address":"Room 1514, Wah Sang House,Wah Fu Estate,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"980.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-29","renew_room_key":"055,14473","renew_remark":"12 months contract. Storage rental paid by bank transfer on December 27, 2018. Storage deposit transferred from agreement A12-CT182553 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT184010, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"73","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"913.00","discount":"16.85","monthly_deduct":185.013,"room_id":"29","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"29","room_code":"A29","retail_price":"1098.0","discounted_price":913,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":980,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11760,"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. Storage rental paid by bank transfer on December 30,2019. Storage deposit transferred from agreement A12-CT184010 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11760,"final_order_total":11760,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,14473","order_product":[],"pass":true}},"first_order_id":4010,"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> A29 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"980.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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",259,"NEW","A12-CT196816",1098,980,0,0,"12","12",11760,11760,11760,"2019-12-31 16:41:19","0",null,null,null,"2019-12-29","2020-12-28","12 months contract. Storage rental paid by bank transfer on December 30,2019. Storage deposit transferred from agreement A12-CT184010 to this agreement.","2019-12-29","16",0,null,0,"0","2","2019-12-31 16:41:19","2","2019-12-31 16:41:19","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,14473","C160259","PERSONAL","Mr","DoW4hDPdUAaMpZ9A8BCrvg==","vZe9OfIpjS77qE3gIHndlQ==","","4td4TiyLV4ZPVQc3dOuJ5oqEikFIyHlRXH9B5bNydbmWYuJkmT4kJwa1w6TSC\/y5s6X9TEYkIASm6myGqstwOQ==","3SnNEs1hx6+DBSkiQCVskA==","mVES2VFjZEZXD9nYIQhStcyLWVu+kUUhrrEGwtNARBA=","RHVzfZTqOmVB5QjNhcmTHg==",null,1,4010]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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":["6816","73","8","29","%","16.85",185.013,"2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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":["6816","29","1098.0",913,"2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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","29"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 16:41:19","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":["6816",259,"SETTLED","A12-I197144","2019-12-31 16:41:19","2019-12-29","2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",1,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",2,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",3,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",4,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",5,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",6,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",7,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",8,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",9,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",10,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",11,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7144","RENT","\u9810\u7e73\u79df\u91d1",12,980,"MO","1",980,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11760,0,"7144"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 16:41:19","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":[259,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196794","2019-12-31 16:41:19",11760,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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":["6794","DEPOSIT",null,"PAID","2019-12-31 16:41:19",0,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 16:41:19","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":["6794","INVOICE","7144","PAID","2019-12-31 16:41:19",11760,"2","2019-12-31 16:41:19","2","2019-12-31 16:41:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:40:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":904,"customer_code":"C180904","identity_type":"PERSONAL","identity_id":"D513677(7)","title":"Mr","lastname":"Lee","firstname":"Kim Hung","companyname":"","email":"luplus@hgcbroadband.com","tel":"98657033","address":"Flat C, 8\/F, Block 29, Fung King Court, South Horizon, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-28","renew_room_key":"190,40459,190,26677","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 18, 2019. Deposit $2456 transferred from agreement A14-CT195656 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196428, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"501","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"501","room_code":"K38","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1167,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3501,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-28","rent_from":"2019-11-28","rent_to":"2020-02-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Deposit $2456 transferred from agreement A14-CT196428 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3501,"final_order_total":3501,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,40459,190,26677","order_product":[],"pass":true}},"first_order_id":"4261","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> K38 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1167.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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",904,"NEW","A14-CT196817",1098,1167,0,0,"3","3",3501,3501,3501,"2019-12-31 17:53:12","0",null,null,null,"2019-11-28","2020-02-27","3 months contract. Storage rental paid by bank transfer on Dec 03, 2019. Deposit $2456 transferred from agreement A14-CT196428 to this agreement.","2019-11-28","16",0,null,0,"0","2","2019-12-31 17:53:12","2","2019-12-31 17:53:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,40459,190,26677","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4261"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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":["6817","434","35","501","%","4.97",54.5706,"2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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":["6817","501","1098.0",1043.4,"2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-28","2020-02-27","501"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 17:53:12","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":["6817",904,"SETTLED","A14-I197145","2019-12-31 17:53:12","2019-11-28","2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7145","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7145","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7145","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"7145"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 17:53:12","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196795","2019-12-31 17:53:12",3501,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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":["6795","DEPOSIT",null,"PAID","2019-12-31 17:53:12",0,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:53:12","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":["6795","INVOICE","7145","PAID","2019-12-31 17:53:12",3501,"2","2019-12-31 17:53:12","2","2019-12-31 17:53:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":904,"customer_code":"C180904","identity_type":"PERSONAL","identity_id":"D513677(7)","title":"Mr","lastname":"Lee","firstname":"Kim Hung","companyname":"","email":"luplus@hgcbroadband.com","tel":"98657033","address":"Flat C, 8\/F, Block 29, Fung King Court, South Horizon, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1228.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-30","renew_room_key":"076,28245","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 17, 2019. Deposit $2456 transferred from agreement A14-CT195655 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196429, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"505","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"505","room_code":"K42","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1167,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3501,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-30","rent_from":"2019-11-30","rent_to":"2020-02-29","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Dec 31, 2019. Deposit $2456 transferred from agreement A14-CT196429 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3501,"final_order_total":3501,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,28245","order_product":[],"pass":true}},"first_order_id":"4262","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> K42 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1167.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","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",904,"NEW","A14-CT196818",1098,1167,0,0,"3","3",3501,3501,3501,"2019-12-31 17:57:40","0",null,null,null,"2019-11-30","2020-02-29","3 months contract. Storage rental paid by bank transfer on Dec 31, 2019. Deposit $2456 transferred from agreement A14-CT196429 to this agreement.","2019-11-30","16",0,null,0,"0","2","2019-12-31 17:57:40","2","2019-12-31 17:57:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,28245","C180904","PERSONAL","Mr","GqH+t4D4XqDN5Gx3zJwoLQ==","kiriEIqhcx866RNZiMXdKQ==","","iHpVrORte32amFa0iA2m3loee1+zslqIL\/7FP2fxc0DcV2T8K6RpbNnKzf8+y3YX\/HSrJ9HIQxVivWaX+vYSfPnGcbPVUj+QrNNyAeaF4No=","xblDSif\/OxScVYnZ8ntRGw==","j4azBMg4uFIF0TmQ06Wk1A\/5a8goLVmCGncsLq4iJqM=","n1gCvw4+mkHcKV9r39Ub7A==",null,1,"4262"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","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":["6818","434","35","505","%","4.97",54.5706,"2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","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":["6818","505","1098.0",1043.4,"2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-30","2020-02-29","505"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 17:57:40","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":["6818",904,"SETTLED","A14-I197146","2019-12-31 17:57:40","2019-11-30","2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7146","RENT","\u9810\u7e73\u79df\u91d1",1,1167,"MO","1",1167,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7146","RENT","\u9810\u7e73\u79df\u91d1",2,1167,"MO","1",1167,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7146","RENT","\u9810\u7e73\u79df\u91d1",3,1167,"MO","1",1167,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3501,0,"7146"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 17:57:40","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":[904,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196796","2019-12-31 17:57:40",3501,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","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":["6796","DEPOSIT",null,"PAID","2019-12-31 17:57:40",0,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 17:57:40","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":["6796","INVOICE","7146","PAID","2019-12-31 17:57:40",3501,"2","2019-12-31 17:57:40","2","2019-12-31 17:57:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:32","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&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":560,"customer_code":"C170560","identity_type":"PERSONAL","identity_id":"C454277(9)","title":"Mr","lastname":"Li","firstname":"Kwok Choi","companyname":"","email":"benjaminkcli@gmail.com","tel":"91211868","address":"Tower 20-D,34\/F,South Horizons,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1860.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-01","renew_room_key":"054,16918","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 30, 2019. Storage deposit transferred from agreement A12-CT196277 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196575, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"335","room_code":"F20","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"324","room_code":"F09","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":1860,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1860,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-01","rent_from":"2020-01-01","rent_to":"2020-01-31","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Dec 31, 2019. Storage deposit transferred from agreement A12-CT196575 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1860,"final_order_total":1860,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,16918","order_product":[],"pass":true}},"first_order_id":"4811","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> F20 <\/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> F09 <\/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":"1860.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",560,"NEW","A12-CT196819",2096,1860,0,0,"1","1",1860,1860,1860,"2019-12-31 18:03:33","0",null,null,null,"2020-01-01","2020-01-31","1 month contract. Storage rental paid by bank transfer on Dec 31, 2019. Storage deposit transferred from agreement A12-CT196575 to this agreement.","2020-01-01","28",0,null,0,"0","2","2019-12-31 18:03:32","2","2019-12-31 18:03:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,16918","C170560","PERSONAL","Mr","K1x\/9w0o0rKJd7wz8qK7pg==","7KCehmxbvwRMb+U8lHGoVA==","","FtBAyqdJB9YVbXi504FRZc\/Jt3mzCqv\/xe\/RY0+A7wVOOPyXv8dxE4H5XZLFEXzC","4QMR+NS4lG0kYGIev9anRw==","ZR5GFjUu0SZOy4e7QYAXd00ul0qCow7bN10OYhy9E+I=","Yd8HrzCK1iQ9KWTKpSyu0w==",null,1,"4811"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6819","335","1098.0","1098.00","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","335"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6819","324","998.0","998.00","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-01","2020-01-31","324"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6819",560,"SETTLED","A12-I197147","2019-12-31 18:03:32","2020-01-01","2","2019-12-31 18:03:32","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7147","RENT","\u9810\u7e73\u79df\u91d1",1,1860,"MO","1",1860,"2","2019-12-31 18:03:32","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1860,0,"7147"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[560,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196797","2019-12-31 18:03:32",1860,"2","2019-12-31 18:03:32","2","2019-12-31 18:03:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6797","DEPOSIT",null,"PAID","2019-12-31 18:03:32",0,"2","2019-12-31 18:03:32","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-31 18:03:33","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6797","INVOICE","7147","PAID","2019-12-31 18:03:32",1860,"2","2019-12-31 18:03:32","2","2019-12-31 18:03:32"]},"data_before":[],"data_after":[],"step":1} *****