{"created_at":"2019-12-07 10:02:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 10:05:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 10:12:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:18:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1128,"customer_code":"C181128","identity_type":"PERSONAL","identity_id":"D693697(1)","title":"Mr","lastname":"Cheung","firstname":"Yiu Chung","companyname":"","email":"vincent_cheung1207@yahoo.com.hk","tel":"96264550","address":"Rm 1714, Wah Hing House, Wah Fu Est. H.K.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"698.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-28","renew_room_key":"189,02161","renew_remark":"12 months contract, storage rental and deposit paid by Cash on Nov 28,2018; Smart Card provided on Nov 28,2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183776, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","renew_master_room_id":"2","order_discount":[{"master_room_discount_id":"60","master_room_id":"2","discount_type":"%","price":"814.00","disocunted_price":"732.60","discount":"10.00","monthly_deduct":81.4,"room_id":"299","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"299","room_code":"E26","retail_price":"814.0","discounted_price":732.6,"location_id":"1"}],"roughly_size":"9","total_retail_price":814,"total_discounted_price":689,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":4134,"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-05-27","delivery_service":"0","remark":"6 months contract, storage rental paid by cash on Dec 07,2019; Deposit $1550 transferred from agreement A12-CT183776 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":4134,"final_order_total":4134,"location_id":"1","branch_id":"1","company_id":"1","room_key":"189,02161","order_product":[],"pass":true}},"first_order_id":3776,"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>
E26 <\/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":"689.00","deposit":"0.00","total_retail_price":"814.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1128,"NEW","A12-CT196625",814,689,0,0,"6","6",4134,4134,4134,"2019-12-07 11:33:01","0",null,null,null,"2019-11-28","2020-05-27","6 months contract, storage rental paid by cash on Dec 07,2019; Deposit $1550 transferred from agreement A12-CT183776 to this agreement.","2019-11-28","9",0,null,0,"0","2","2019-12-07 11:33:01","2","2019-12-07 11:33:01","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"189,02161","C181128","PERSONAL","Mr","NULh+sl2lJu5iiFCcrRT8w==","vCxOlXQuvOQaoL822H2o\/Q==","","0Wo4YbB5nah1HkbAgepLO22c7gWx2GVI164ijFtcFY0HFk+16jodIsuaV70S8s45","GmP73ZMJGut+JjoxWeiKeQ==","UfP9y7Wiv9rHXwCjc5e+M2ymk2sXUqxQm9P65GPPWaw=","FAsq55gWbL6qPzlzlmfzFg==",null,1,3776]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6625","60","2","299","%","10.00",81.4,"2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6625","299","814.0",732.6,"2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-28","2020-05-27","299"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6625",1128,"SETTLED","A12-I196953","2019-12-07 11:33:01","2019-11-28","2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",1,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",2,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",3,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",4,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",5,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6953","RENT","\u9810\u7e73\u79df\u91d1",6,689,"MO","1",689,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4134,0,"6953"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1128,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196603","2019-12-07 11:33:01",4134,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6603","DEPOSIT",null,"PAID","2019-12-07 11:33:01",0,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:33:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6603","INVOICE","6953","PAID","2019-12-07 11:33:01",4134,"2","2019-12-07 11:33:01","2","2019-12-07 11:33:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":863,"customer_code":"C180863","identity_type":"PERSONAL","identity_id":"D4081820","title":"Mr","lastname":"Lui","firstname":"Yik Kwan","companyname":"","email":"luiyk80586@yahoo.com.hk","tel":"93826500","address":"Flat F, 10\/F, Block2 South Horizons Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1592.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-20","renew_room_key":"190,37050","renew_remark":"12 months contract. Storage rental paid by cash on November 10, 2018. Storage deposit transferred from agreement SD12-CT182507 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183531, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"11","order_discount":[],"order_room":[{"room_id":"367","room_code":"G08","retail_price":"1768.0","discounted_price":"1768.00","location_id":"1"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1592,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":19104,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1592.00","warehousing_date":"2019-12-20","rent_from":"2019-12-20","rent_to":"2021-01-19","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cash on December 7, 2019. Storage deposit transferred from agreement A12-CT183531 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":1592,"order_total":20696,"final_order_total":19104,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,37050","order_product":[],"pass":true}},"first_order_id":3531,"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> G08 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\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":"24","total_discounted_price":"1592.00","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",863,"NEW","A12-CT196626",1768,1592,0,0,"13","13",19104,20696,19104,"2019-12-07 11:42:54","0",null,null,null,"2019-12-20","2021-01-19","13 months contract. Special offer the 13th month free. Storage rental paid by cash on December 7, 2019. Storage deposit transferred from agreement A12-CT183531 to this agreement.","2019-12-20","24",0,null,1592,"1592.00","2","2019-12-07 11:42:54","2","2019-12-07 11:42:54","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,37050","C180863","PERSONAL","Mr","293kYxZiUsTyVGcMHJNNWQ==","vyCKi4IYWx3VnCZylJM1yA==","","X5vsC106+bzu3r1gY9m87vNsBFO9G2qfLc9GzO8ceNitOqmTf0juQp5qngRgOAojW7SdViG5C7JpCVhh68RZzg==","fNqg+fuPO3bHWX\/75wcQbg==","+1zwQDc+HJrwRCTpDKQw\/PP\/BoVYO1VG4w0zUHfEUmA=","z+19Fx1uGxbTfIf\/TuBZpA==",null,1,3531]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6626","367","1768.0","1768.00","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-20","2021-01-19","367"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6626",863,"SETTLED","A12-I196954","2019-12-07 11:42:54","2019-12-20","2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",3,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",4,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",5,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",6,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",7,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",8,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",9,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",10,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",11,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",12,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6954","RENT","\u9810\u7e73\u79df\u91d1",13,1592,"MO","1",1592,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[19104,0,"6954"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[863,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196604","2019-12-07 11:42:54",19104,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6604","DEPOSIT",null,"PAID","2019-12-07 11:42:54",0,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:42:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6604","INVOICE","6954","PAID","2019-12-07 11:42:54",19104,"2","2019-12-07 11:42:54","2","2019-12-07 11:42:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":445,"customer_code":"C170445","identity_type":"PERSONAL","identity_id":"K738319(3)","title":"Mr","lastname":"Sin","firstname":"Dai Chuen Sunny","companyname":"","email":"sindaichuen@netvigator.com","tel":"93632429","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3K\u5ea7\u6d77\u6676\u95a313\u6a134\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1198.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-10","renew_room_key":"054,60440","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 08, 2019. Storage deposit transferred from agreement A14-CT196087 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196324, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"70","order_discount":[],"order_room":[{"room_id":"722","room_code":"N39","retail_price":"1318.0","discounted_price":"1318.00","location_id":"2"}],"roughly_size":"18","total_retail_price":1318,"total_discounted_price":1198,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1198,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-10","rent_from":"2019-12-10","rent_to":"2020-01-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 07, 2019. Storage deposit transferred from agreement A14-CT196324 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1198,"final_order_total":1198,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60440","order_product":[],"pass":true}},"first_order_id":"4712","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> N39 <\/td>\r\n\t\t\t\t\t 3X6X8 <\/td>\r\n\t\t\t\t\t $1318.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"18","total_discounted_price":"1198.0","deposit":"0","total_retail_price":"1318.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","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",445,"NEW","A14-CT196627",1318,1198,0,0,"1","1",1198,1198,1198,"2019-12-07 11:57:30","0",null,null,null,"2019-12-10","2020-01-09","1 month contract. Storage rental paid by bank transfer on December 07, 2019. Storage deposit transferred from agreement A14-CT196324 to this agreement.","2019-12-10","18",0,null,0,"0","2","2019-12-07 11:57:30","2","2019-12-07 11:57:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60440","C170445","PERSONAL","Mr","9L2K7wn1Opvr3WQ4vJABDA==","995YTEe316mZ2NiY\/8o00g==","","mvDoTgHRyEEzx3aiSCEV4DxQZHD5YYGgvyNzPm1QCr\/nAPIFPb3QfWTpiQPnxKX2","QrHnF9IXwKZ9qN6l8eYD5g==","A+zYSJpoRkceQYWowNFQUv3ec39gnccN6z82YnuKfNw=","d5o++GGoW7Lf\/yZcJ7PGQw==",null,1,"4712"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","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":["6627","722","1318.0","1318.00","2","2019-12-07 11:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-10","2020-01-09","722"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 11:57:30","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":["6627",445,"SETTLED","A14-I196955","2019-12-07 11:57:30","2019-12-10","2","2019-12-07 11:57:30","2","2019-12-07 11:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6955","RENT","\u9810\u7e73\u79df\u91d1",1,1198,"MO","1",1198,"2","2019-12-07 11:57:30","2","2019-12-07 11:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1198,0,"6955"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 11:57:30","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":[445,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196605","2019-12-07 11:57:30",1198,"2","2019-12-07 11:57:30","2","2019-12-07 11:57:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","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":["6605","DEPOSIT",null,"PAID","2019-12-07 11:57:30",0,"2","2019-12-07 11:57:30","2","2019-12-07 11:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 11:57:30","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":["6605","INVOICE","6955","PAID","2019-12-07 11:57:30",1198,"2","2019-12-07 11:57:30","2","2019-12-07 11:57:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:41","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":298,"customer_code":"C170298","identity_type":"PERSONAL","identity_id":"k484939(6)","title":"Mr","lastname":"Cheng","firstname":"Man Ho","companyname":"","email":null,"tel":"91305008","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a13410\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"989.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-05","renew_room_key":"054,60335","renew_remark":"3 months contract. Storage rental paid by PPS on September 2, 2019. Storage deposit transferred from agreement A14-CT195148 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195868, \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":"741","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"741","room_code":"O17","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"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-12-05","rent_from":"2019-12-05","rent_to":"2020-03-04","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A14-CT195868 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2967,"final_order_total":2967,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60335","order_product":[],"pass":true}},"first_order_id":"4491","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> O17 <\/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":"989.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",298,"NEW","A14-CT196628",1098,989,0,0,"3","3",2967,2967,2967,"2019-12-07 12:06:42","0",null,null,null,"2019-12-05","2020-03-04","3 months contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A14-CT195868 to this agreement.","2019-12-05","16",0,null,0,"0","2","2019-12-07 12:06:41","2","2019-12-07 12:06:41","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,60335","C170298","PERSONAL","Mr","jGP6SPxDvmecJxk7lZKF\/A==","UCPBCXrBLI9U7KKsPqgmNA==","","JP4Rs\/ygk7B5+4qY1O\/77sO4cSgE6DyV78DXbBtpGzLv1kaM0\/v3Sy90AKoVl6+m","wTaA4qMQYmlEjCjDpDuThA==",null,"v4paaOPw\/N97VaGmBv\/AGw==",null,1,"4491"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","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":["6628","434","35","741","%","4.97",54.5706,"2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6628","741","1098.0",1043.4,"2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-05","2020-03-04","741"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6628",298,"SETTLED","A14-I196956","2019-12-07 12:06:41","2019-12-05","2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6956","RENT","\u9810\u7e73\u79df\u91d1",1,989,"MO","1",989,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6956","RENT","\u9810\u7e73\u79df\u91d1",2,989,"MO","1",989,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6956","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2967,0,"6956"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[298,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196606","2019-12-07 12:06:41",2967,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6606","DEPOSIT",null,"PAID","2019-12-07 12:06:41",0,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:06:42","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6606","INVOICE","6956","PAID","2019-12-07 12:06:41",2967,"2","2019-12-07 12:06:41","2","2019-12-07 12:06:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:00","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1105,"customer_code":"C181105","identity_type":"PERSONAL","identity_id":"D594748(1)","title":"Ms","lastname":"CHEUNG","firstname":"Mo Yi Sandy","companyname":"","email":"moyisandy@yahoo.com.hk","tel":"90461212","address":"Flat H, 26\/F, BLK 2, Sham Wan Tower, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"953.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-24","renew_room_key":"12421231","renew_remark":"12 months contract, Storage rental and deposit paid by EPS on Nov 19,2018; Smart Card provided on Nov 19,2018\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183646, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2116.0","renew_master_room_id":"112","order_discount":[],"order_room":[{"room_id":"1101","room_code":"A05-099(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"4"}],"roughly_size":"10","total_retail_price":1058,"total_discounted_price":953,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11436,"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-11-23","delivery_service":"0","remark":"12 months contract. Storage rental paid by PPS on December 03, 2019. Storage deposit $2116 transferred from agreement A05-CT183646 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":11436,"final_order_total":11436,"location_id":"4","branch_id":"1","company_id":"1","room_key":"12421231","order_product":[],"pass":true}},"first_order_id":3646,"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-099(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X2.5X7 <\/td>\r\n\t\t\t\t\t $1058.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":"10","total_discounted_price":"953.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1105,"NEW","A05-CT196629",1058,953,0,0,"12","12",11436,11436,11436,"2019-12-07 12:10:01","0",null,null,null,"2019-11-24","2020-11-23","12 months contract. Storage rental paid by PPS on December 03, 2019. Storage deposit $2116 transferred from agreement A05-CT183646 to this agreement. ","2019-11-24","10",0,null,0,"0","2","2019-12-07 12:10:00","2","2019-12-07 12:10:00","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"12421231","C181105","PERSONAL","Ms","JSQ+iiG5A7FOkKdXKwB0SA==","ts1WQ6NWxfSAyKGz8YWojw==","","1W91I5+xPx1+c6xw0ZrayTpNagJx0tZC36cRFk0vbBbxiMqviNKYS55jPEwecr24","JY\/TCp03ILkFSXTOVmqAGQ==","vMxMNWPGhNYbN0RMccILDyG4vQPztm6GvWqo5HL+Wd4=","o5t4PT057bLd7JKazb5a5A==",null,1,3646]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6629","1101","1058.0","1058.00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-11-24","2020-11-23","1101"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6629",1105,"SETTLED","A05-I196957","2019-12-07 12:10:00","2019-11-24","2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",1,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",2,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",3,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",4,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",5,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",6,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",7,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",8,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",9,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",10,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",11,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6957","RENT","\u9810\u7e73\u79df\u91d1",12,953,"MO","1",953,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11436,0,"6957"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1105,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196607","2019-12-07 12:10:00",11436,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6607","DEPOSIT",null,"PAID","2019-12-07 12:10:00",0,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:10:01","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6607","INVOICE","6957","PAID","2019-12-07 12:10:00",11436,"2","2019-12-07 12:10:00","2","2019-12-07 12:10:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":681,"customer_code":"C180681","identity_type":"PERSONAL","identity_id":"K087413(2)","title":"Mr","lastname":"Chung","firstname":"Ka Po","companyname":"","email":"patrickbobofamily@gmail.com","tel":"63336887","address":"3\/F, Siu Fung Hong Building, 239-241 Wing Lok Street, Sheung Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"965.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-02","renew_room_key":"056,05555","renew_remark":"1 month contract. Storage rental paid by PPS on November 4, 2019. Storage deposit transferred from agreement A18-CT196077 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196317, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"103","order_discount":[],"order_room":[{"room_id":"906","room_code":"U07","retail_price":"965.0","discounted_price":"965.00","location_id":"3"}],"roughly_size":"8","total_retail_price":965,"total_discounted_price":965,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":965,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-02","rent_from":"2019-12-02","rent_to":"2020-01-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A18-CT196317 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":965,"final_order_total":965,"location_id":"3","branch_id":"1","company_id":"1","room_key":"056,05555","order_product":[],"pass":true}},"first_order_id":"4704","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> U07 <\/td>\r\n\t\t\t\t\t 2X4X7 <\/td>\r\n\t\t\t\t\t $965.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"965.0","deposit":"0","total_retail_price":"965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",681,"NEW","A18-CT196630",965,965,0,0,"1","1",965,965,965,"2019-12-07 12:12:24","0",null,null,null,"2019-12-02","2020-01-01","1 month contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A18-CT196317 to this agreement.","2019-12-02","8",0,null,0,"0","2","2019-12-07 12:12:24","2","2019-12-07 12:12:24","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"056,05555","C180681","PERSONAL","Mr","WpXUsGIV5ZMagl9ab+XsmA==","ThKwrAIcvgN3JqAg+7\/isg==","","MfbxfJxu6rnCI3QT7TKkp941rf6ZLqXK4FI5VbVzAJiJni8uQnXc2gGJQSsyflI200jM1kVIWfocMiR8ixEVuOtN59H0aUN3N6cpSW\/Zb8g=","uk+aBM1pdnZq7uENadbWLg==","AlXt3dY1\/1B81wXwqLajny8WQO2W1oXWizWY\/cvTtlY=","ikLrZy69X3qkMVAoKWXxnQ==",null,1,"4704"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6630","906","965.0","965.00","2","2019-12-07 12:12:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-02","2020-01-01","906"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6630",681,"SETTLED","A18-I196958","2019-12-07 12:12:24","2019-12-02","2","2019-12-07 12:12:24","2","2019-12-07 12:12:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6958","RENT","\u9810\u7e73\u79df\u91d1",1,965,"MO","1",965,"2","2019-12-07 12:12:24","2","2019-12-07 12:12:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[965,0,"6958"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[681,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196608","2019-12-07 12:12:24",965,"2","2019-12-07 12:12:24","2","2019-12-07 12:12:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6608","DEPOSIT",null,"PAID","2019-12-07 12:12:24",0,"2","2019-12-07 12:12:24","2","2019-12-07 12:12:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:12:24","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6608","INVOICE","6958","PAID","2019-12-07 12:12:24",965,"2","2019-12-07 12:12:24","2","2019-12-07 12:12:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":319,"customer_code":"C170319","identity_type":"PERSONAL","identity_id":"D666363(0)","title":"Mr","lastname":"Chau","firstname":"Johnny","companyname":"","email":"yochau@gmail.com","tel":"91220103","address":"F6,9\/F,Block A, Hoi Chun Court ,Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2018.0","renew_rent_month":"6","renew_warehousing_date":"2019-12-01","renew_room_key":"054,20556","renew_remark":"6 months contract. Storage rental paid by bank transfer on May 28, 2019. Storage deposit transferred from agreement A14-CT183746 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195085, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"57","order_discount":[{"master_room_discount_id":"457","master_room_id":"57","discount_type":"%","price":"2598.00","disocunted_price":"2338.20","discount":"10.00","monthly_deduct":259.8,"room_id":"771","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"771","room_code":"P05","retail_price":"2598.0","discounted_price":2338.2,"location_id":"2"}],"roughly_size":"36","total_retail_price":2598,"total_discounted_price":2018,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":12108,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-05-31","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on December 04, 2019. Storage deposit transferred from agreement A14-CT195085 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":12108,"final_order_total":12108,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,20556","order_product":[],"pass":true}},"first_order_id":"3746","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> P05 <\/td>\r\n\t\t\t\t\t 6X6X8 <\/td>\r\n\t\t\t\t\t $2598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\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":"36","total_discounted_price":"2018.0","deposit":"0","total_retail_price":"2598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",319,"NEW","A14-CT196631",2598,2018,0,0,"6","6",12108,12108,12108,"2019-12-07 12:17:03","0",null,null,null,"2019-12-01","2020-05-31","6 months contract. Storage rental paid by PPS on December 04, 2019. Storage deposit transferred from agreement A14-CT195085 to this agreement.","2019-12-01","36",0,null,0,"0","2","2019-12-07 12:17:03","2","2019-12-07 12:17:03","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,20556","C170319","PERSONAL","Mr","gB3lOIKGw08oQZ3wGQ6W1A==","kOK3vHUlGE9qjoVnzYRDGA==","","+LY9jXB08\/ROlmf4tzd27P8Mkuaz0h1tHAIFO8mmunmtAR9jFk\/vMM7p017YOl0w","mnS\/3SejyDp+HtKK62q4bg==","6Z6kRGeB+1Bh1yVv\/7xDR221AjEyh33x40NlFt8RDPo=","n49aoPqb+ZhlfDpx0SZV3Q==",null,1,"3746"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6631","457","57","771","%","10.00",259.8,"2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6631","771","2598.0",2338.2,"2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-05-31","771"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6631",319,"SETTLED","A14-I196959","2019-12-07 12:17:03","2019-12-01","2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",1,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",2,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",3,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",4,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",5,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6959","RENT","\u9810\u7e73\u79df\u91d1",6,2018,"MO","1",2018,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12108,0,"6959"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[319,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196609","2019-12-07 12:17:03",12108,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6609","DEPOSIT",null,"PAID","2019-12-07 12:17:03",0,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:17:03","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6609","INVOICE","6959","PAID","2019-12-07 12:17:03",12108,"2","2019-12-07 12:17:03","2","2019-12-07 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":695,"customer_code":"C180695","identity_type":"PERSONAL","identity_id":"Z025957(9)","title":"Mr","lastname":"Yiu","firstname":"Hoo Ming","companyname":"","email":"allenmailbox2003@gmail.com","tel":"97703578","address":"Rm 205, 2\/F, Hoi Ying Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"986.0","renew_rent_month":"3","renew_warehousing_date":"2019-12-12","renew_room_key":"055,33053","renew_remark":"1 month contract. Storage rental paid by PPS on October 2, 2019. Storage deposit transferred from agreement A18-CT195696 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196094, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"950","room_code":"V24","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":986,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2958,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-12","rent_from":"2019-12-12","rent_to":"2020-03-11","delivery_service":"0","remark":"3 month contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A18-CT196094 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2958,"final_order_total":2958,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,33053","order_product":[],"pass":true}},"first_order_id":"4794","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> V24 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"986.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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",695,"NEW","A18-CT196632",1090,986,0,0,"3","3",2958,2958,2958,"2019-12-07 12:21:30","0",null,null,null,"2019-12-12","2020-03-11","3 month contract. Storage rental paid by PPS on December 3, 2019. Storage deposit transferred from agreement A18-CT196094 to this agreement.","2019-12-12","12",0,null,0,"0","2","2019-12-07 12:21:30","2","2019-12-07 12:21:30","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,33053","C180695","PERSONAL","Mr","aiBrQy4UPMcgguO0jLV1sg==","izJVo3RcQVJ02PBMypGKnQ==","","VkFWuPbK1ApFCfJ3gIQYOEDA988JA0rHubF\/t6zhIkMsMmiMOGmY2ATv34a1hE+E9e0hsR4sk+eQtG89WXm74SjxXmFrpc2Sx7v7irPjvrY=","CopQCWtiLmk22\/02l9sl6Q==","kk0UIrQ1brq5tEccbYkGJfqJ+ohMJxyjLqd7O9BnG0Y=","64Hv+qZtHob+EjHFcODB1Q==",null,1,"4794"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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":["6632","950","1090.0","1090.00","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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-12","2020-03-11","950"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:21:30","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":["6632",695,"SETTLED","A18-I196960","2019-12-07 12:21:30","2019-12-12","2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960","RENT","\u9810\u7e73\u79df\u91d1",1,986,"MO","1",986,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960","RENT","\u9810\u7e73\u79df\u91d1",2,986,"MO","1",986,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6960","RENT","\u9810\u7e73\u79df\u91d1",3,986,"MO","1",986,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2958,0,"6960"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:21:30","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":[695,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196610","2019-12-07 12:21:30",2958,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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":["6610","DEPOSIT",null,"PAID","2019-12-07 12:21:30",0,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:21:30","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":["6610","INVOICE","6960","PAID","2019-12-07 12:21:30",2958,"2","2019-12-07 12:21:30","2","2019-12-07 12:21:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":888,"customer_code":"C180888","identity_type":"PERSONAL","identity_id":"K099955(5)","title":"Ms","lastname":"Ho","firstname":"Man Yee Cherie","companyname":"","email":"cheriehmy@gmail.com","tel":"90575456","address":"Flat A, 1\/F, Block 9, Fullview Garden, 18 Siu Sai Wan Road, Siu Sai Wan, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1488.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-06","renew_room_key":"0005763937","renew_remark":"1 month contract. Storage rental paid by PPS on November 5, 2019. Storage deposit $2976 transferred from agreement B01-CT196096 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT196331, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"143","order_discount":[],"order_room":[{"room_id":"1274","room_code":"B01-084","retail_price":"1488.0","discounted_price":"1488.00","location_id":"5"}],"roughly_size":"24","total_retail_price":1488,"total_discounted_price":1488,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1488,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-06","rent_from":"2019-12-06","rent_to":"2020-01-05","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on December 6, 2019. Storage deposit $2976 transferred from agreement B01-CT196331 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1488,"final_order_total":1488,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0005763937","order_product":[],"pass":true}},"first_order_id":"4797","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-084 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1488.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1488.0","deposit":"0","total_retail_price":"1488.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","2","5",888,"NEW","B01-CT196633",1488,1488,0,0,"1","1",1488,1488,1488,"2019-12-07 12:26:52","0",null,null,null,"2019-12-06","2020-01-05","1 month contract. Storage rental paid by PPS on December 6, 2019. Storage deposit $2976 transferred from agreement B01-CT196331 to this agreement.","2019-12-06","24",0,null,0,"0","2","2019-12-07 12:26:52","2","2019-12-07 12:26:52","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005763937","C180888","PERSONAL","Ms","B6XcmzmDA9cWki+qLStEaA==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","zb+wEJU2BcjiqagYCnyRNQzS3jTcz1KQCkGgLWtY\/y+C8KU+srfsdCNTrRUrjSHTpRbkV0JFumXQh3K4klaHUNKIaPzoQH6Ro1qQAUtDwWHyil1VPuPOWLDOdLKNt30K","Mv9sZMBZUVgbHGVZIxyZfQ==","d8Ms1Ternr8fasYV7yyV8x0bubUdhthIhbdOyphH3tQ=","b0wVwk81Vh1dF13X\/TkOaw==",null,1,"4797"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6633","1274","1488.0","1488.00","2","2019-12-07 12:26:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-06","2020-01-05","1274"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6633",888,"SETTLED","B01-I196961","2019-12-07 12:26:52","2019-12-06","2","2019-12-07 12:26:52","2","2019-12-07 12:26:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6961","RENT","\u9810\u7e73\u79df\u91d1",1,1488,"MO","1",1488,"2","2019-12-07 12:26:52","2","2019-12-07 12:26:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1488,0,"6961"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[888,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196611","2019-12-07 12:26:52",1488,"2","2019-12-07 12:26:52","2","2019-12-07 12:26:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6611","DEPOSIT",null,"PAID","2019-12-07 12:26:52",0,"2","2019-12-07 12:26:52","2","2019-12-07 12:26:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:26:52","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6611","INVOICE","6961","PAID","2019-12-07 12:26:52",1488,"2","2019-12-07 12:26:52","2","2019-12-07 12:26:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1071,"customer_code":"C181071","identity_type":"PERSONAL","identity_id":"V003756(7)","title":"Mr","lastname":"Ho","firstname":"Wai Pan","companyname":"","email":"gogeescat@yahoo.com.hk","tel":"91285345","address":"Room 1, 6\/F, Kong Wing Court, 15 Nam Ning St.","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1106.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"190,37151","renew_remark":"12 months contract, Storage Rental and deposit paid by Cheque on Nov 12,2018; Smart Card provided by Nov 12, 2018\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT183568, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2456.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"72","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"989.00","discount":"9.93","monthly_deduct":109.0314,"room_id":"140","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"140","room_code":"C16","retail_price":"1098.0","discounted_price":989,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1106,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6636,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-05-31","delivery_service":"0","remark":"6 months contract, Storage Rental paid by PPS on December 06, 2019. Storage deposit $2456 transferred from agreement A12-CT183568 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6636,"final_order_total":6636,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,37151","order_product":[],"pass":true}},"first_order_id":3568,"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> C16 <\/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":"1106.00","deposit":"0.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1071,"NEW","A12-CT196634",1098,1106,0,0,"6","6",6636,6636,6636,"2019-12-07 12:30:46","0",null,null,null,"2019-12-01","2020-05-31","6 months contract, Storage Rental paid by PPS on December 06, 2019. Storage deposit $2456 transferred from agreement A12-CT183568 to this agreement. ","2019-12-01","16",0,null,0,"0","2","2019-12-07 12:30:46","2","2019-12-07 12:30:46","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"190,37151","C181071","PERSONAL","Mr","O58BD0EWHd8PIPxr+IqSvg==","D\/skxQ5s\/L5yyRWaDK\/iSg==","","sAcs00V1xs6ZqRWKToY+WeGi5gNAyeaijZzS0yFycfTU703yJk78rEeiKz+IF\/xB","4SthcwW2GT3PjivNHNj2jQ==","2fxbkkKOI3zz18OegBN4ysYbzFSZncWngEwC2UmJL3A=","APypfr2l17f0BGx4KByXDA==",null,1,3568]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["6634","72","8","140","%","9.93",109.0314,"2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6634","140","1098.0",989,"2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-05-31","140"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6634",1071,"SETTLED","A12-I196962","2019-12-07 12:30:46","2019-12-01","2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",1,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",2,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",3,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",4,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",5,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6962","RENT","\u9810\u7e73\u79df\u91d1",6,1106,"MO","1",1106,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6636,0,"6962"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1071,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196612","2019-12-07 12:30:46",6636,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6612","DEPOSIT",null,"PAID","2019-12-07 12:30:46",0,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:30:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6612","INVOICE","6962","PAID","2019-12-07 12:30:46",6636,"2","2019-12-07 12:30:46","2","2019-12-07 12:30:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":724,"customer_code":"C180724","identity_type":"PERSONAL","identity_id":"D488390(0)","title":"Mr","lastname":"Chan","firstname":"Kai Ming Johnny","companyname":"","email":"ckmjohnny@gmail.com","tel":"92855920","address":"Room 922, Wah Cheong House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2058.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on November 4, 2019. Storage deposit transferred from agreement A12-CT196100 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196316, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"321","room_code":"F06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"332","room_code":"F17","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"28","total_retail_price":2096,"total_discounted_price":2058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-05","rent_from":"2019-12-05","rent_to":"2020-01-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on December 06, 2019. Storage deposit transferred from agreement A12-CT196316 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2058,"final_order_total":2058,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,32853","order_product":[],"pass":true}},"first_order_id":"4888","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> F06 <\/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> F17 <\/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":"28","total_discounted_price":"2058.0","deposit":"0","total_retail_price":"2096.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",724,"NEW","A12-CT196635",2096,2058,0,0,"1","1",2058,2058,2058,"2019-12-07 12:32:54","0",null,null,null,"2019-12-05","2020-01-04","1 month contract. Storage rental paid by PPS on December 06, 2019. Storage deposit transferred from agreement A12-CT196316 to this agreement.","2019-12-05","28",0,null,0,"0","2","2019-12-07 12:32:54","2","2019-12-07 12:32:54","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,32853","C180724","PERSONAL","Mr","S2Y\/+hrua6snugCiRVXC+g==","U9yoE9KqV1v8YlRkf7Q2yg==","","k+e0QYxm9l5HuoQuXakgBNnw8UW4n+ZLcCG9eEWYCG3GGUVs8OcyHqJxZXBRIAQ7e4G25Jwv46TjFMKIeqmD6Q==","uIJTfVK37Ukw\/PebwnT1DA==","HVGIbYlde5F3OKyLRPpR9QsuoR+xNkr5wlpbBQugV6E=","tHG2eMtIkTmRjccZ2JJ3PQ==",null,1,"4888"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6635","321","998.0","998.00","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-05","2020-01-04","321"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6635","332","1098.0","1098.00","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-05","2020-01-04","332"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6635",724,"SETTLED","A12-I196963","2019-12-07 12:32:54","2019-12-05","2","2019-12-07 12:32:54","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6963","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2019-12-07 12:32:54","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"6963"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P196613","2019-12-07 12:32:54",2058,"2","2019-12-07 12:32:54","2","2019-12-07 12:32:54","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6613","DEPOSIT",null,"PAID","2019-12-07 12:32:54",0,"2","2019-12-07 12:32:54","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 12:32:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6613","INVOICE","6963","PAID","2019-12-07 12:32:54",2058,"2","2019-12-07 12:32:54","2","2019-12-07 12:32:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1052,"customer_code":"C181052","identity_type":"PERSONAL","identity_id":"D287482(3)","title":"Ms","lastname":"Yuen","firstname":"Wai Man","companyname":"","email":"nikeyan223@yahoo.com.hk","tel":"93553283","address":"7D, Evergreen Tower, 83 Second Street, Western Garden, Sai Ying Pun, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1672.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-01","renew_room_key":"0012401480","renew_remark":"12 months contract. Special \u8f49\u5009 offer, one month free. Storage rental and deposit paid by EPS on November 10, 2018. Smartcard provided on November 10, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183544, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $3714.0","renew_master_room_id":"117","order_discount":[],"order_room":[{"room_id":"1175","room_code":"A05-173","retail_price":"1857.0","discounted_price":"1857.00","location_id":"4"}],"roughly_size":"24","total_retail_price":1857,"total_discounted_price":1672,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":20064,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1672.00","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-12-31","delivery_service":"0","remark":"13 months contract. Storage rental paid by cheque on Dec 07,2019. Deposit $3714 transferred A05-CT183544 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1672,"order_total":21736,"final_order_total":20064,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012401480","order_product":[],"pass":true}},"first_order_id":3544,"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-173 <\/td>\r\n\t\t\t\t\t 4X6X7 <\/td>\r\n\t\t\t\t\t $1857.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":"24","total_discounted_price":"1672.00","deposit":"0.00","total_retail_price":"1857.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1052,"NEW","A05-CT196636",1857,1672,0,0,"13","13",20064,21736,20064,"2019-12-07 13:43:56","0",null,null,null,"2019-12-01","2020-12-31","13 months contract. Storage rental paid by cheque on Dec 07,2019. Deposit $3714 transferred A05-CT183544 to this agreement.","2019-12-01","24",0,null,1672,"1672.00","2","2019-12-07 13:43:56","2","2019-12-07 13:43:56","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0012401480","C181052","PERSONAL","Ms","fVWUbMaE2hC6HYSPwkdCdQ==","DtbrOSvE4C7BOu5x4dBFtg==","","PyqDojJBjj1dTfgxBz\/WYvGbqayeF9HRMgivb\/O8xWECNXCs6srsXoegGwiprV7i2ffNNSW0YyihRQzU4cNxcnwEneYQc6XSu1I0cTdicrE=","dwNnvu7v3tdh7oCm63BoJw==","e656BdxAmJY\/3Agzb4nDou0vFcjh3ViCZTiNts0iPwk=","eaUtKp5DXv4qPPIbxDVj6Q==",null,1,3544]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6636","1175","1857.0","1857.00","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-12-31","1175"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6636",1052,"SETTLED","A05-I196964","2019-12-07 13:43:56","2019-12-01","2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",3,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",4,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",5,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",6,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",7,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",8,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",9,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",10,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",11,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",12,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6964","RENT","\u9810\u7e73\u79df\u91d1",13,1672,"MO","1",1672,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20064,0,"6964"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1052,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196614","2019-12-07 13:43:56",20064,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6614","DEPOSIT",null,"PAID","2019-12-07 13:43:56",0,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:43:56","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6614","INVOICE","6964","PAID","2019-12-07 13:43:56",20064,"2","2019-12-07 13:43:56","2","2019-12-07 13:43:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55:57","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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1041,"customer_code":"C181041","identity_type":"PERSONAL","identity_id":"G275461(3)","title":"Ms","lastname":"Wong","firstname":"Chi Ha","companyname":"","email":null,"tel":"92698558","address":"Flat E, 20\/F, Block 31, South Horizons, Apleichau, 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-12-01","renew_room_key":"0005832389","renew_remark":"12 months contract. Special Offer, one month free. Storage rental and deposit paid by EPS on November 10, 2018. Smartcard provided on November 10, 2018.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT183529, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1011","room_code":"A05-009","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-01","rent_from":"2019-12-01","rent_to":"2020-11-30","delivery_service":"0","remark":"12 months contract. Storage rental paid by cheque on Dec 07,2019. Deposit $2580 transferred from agreement A05-CT183529 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":13944,"final_order_total":13944,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005832389","order_product":[],"pass":true}},"first_order_id":3529,"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-009 <\/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.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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","4",1041,"NEW","A05-CT196637",1290,1162,0,0,"12","12",13944,13944,13944,"2019-12-07 13:55:57","0",null,null,null,"2019-12-01","2020-11-30","12 months contract. Storage rental paid by cheque on Dec 07,2019. Deposit $2580 transferred from agreement A05-CT183529 to this agreement.","2019-12-01","16",0,null,0,"0","2","2019-12-07 13:55:57","2","2019-12-07 13:55:57","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"0005832389","C181041","PERSONAL","Ms","xEVgbljqMs0nAPqKa+mTTw==","hULSwM2MvFtpeV9\/z+er8Q==","","zBTnyUYMW94ayokK\/IAP\/7WBRIEyfp2iP092q3ikij8RZxFQpbqCGMystqzhB73Dsz4tUj6I17rKtkMvWz9qYg==","ttmx5K0i1pvzyo0xs9mLLg==",null,"yMSmszAelC8H4PnUEkEehA==",null,1,3529]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6637","1011","1290.0","1290.00","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-01","2020-11-30","1011"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-07 13:55: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":["6637",1041,"SETTLED","A05-I196965","2019-12-07 13:55:57","2019-12-01","2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6965","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"6965"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-07 13:55: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":[1041,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196615","2019-12-07 13:55:57",13944,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6615","DEPOSIT",null,"PAID","2019-12-07 13:55:57",0,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-07 13:55: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":["6615","INVOICE","6965","PAID","2019-12-07 13:55:57",13944,"2","2019-12-07 13:55:57","2","2019-12-07 13:55:57"]},"data_before":[],"data_after":[],"step":1} *****