{"created_at":"2020-01-04 11:27: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":"filter1=2&filter2=1171&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1314","master_room_id":"164","room_code":"C15-008"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":978,"customer_code":"C180978","identity_type":"PERSONAL","identity_id":"E408602(4)","title":"Mr","lastname":"Wong","firstname":"Kai Wai Martin","companyname":"","email":null,"tel":"63831437","address":"Flat G, 20\/F, Block 6, Greenwood TCE, Chai Wan","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1177.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-06","renew_room_key":"0005798792","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 09, 2019. Storage deposit $2476 transferred from agreement C15-CT195393 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT196335, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"172","order_discount":[{"master_room_discount_id":"417","master_room_id":"172","discount_type":"%","price":"1115.00","disocunted_price":"1059.90","discount":"4.94","monthly_deduct":55.081,"room_id":"1342","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1342","room_code":"C15-036","retail_price":"1115.0","discounted_price":1059.9,"location_id":"6"}],"roughly_size":"20","total_retail_price":1115,"total_discounted_price":1177,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3531,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-04-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jan 03,2020. Storage deposit $2476 transferred from agreement C15-CT196335 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3531,"final_order_total":3531,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0005798792","order_product":[],"pass":true}},"first_order_id":"4856","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-036 <\/td>\r\n\t\t\t\t\t	4X5X6.5 <\/td>\r\n\t\t\t\t\t	$1115.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":"20","total_discounted_price":"1177.0","deposit":"0","total_retail_price":"1115.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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","3","6",978,"NEW","C15-CT206857",1115,1177,0,0,"3","3",3531,3531,3531,"2020-01-04 11:27:42","0",null,null,null,"2020-01-06","2020-04-05","3 months contract. Storage rental paid by bank transfer on Jan 03,2020. Storage deposit $2476 transferred from agreement C15-CT196335 to this agreement. ","2020-01-06","20",0,null,0,"0","2","2020-01-04 11:27:41","2","2020-01-04 11:27:41","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0005798792","C180978","PERSONAL","Mr","B4DvkaXR+2uW4nB0kNvBxw==","hULSwM2MvFtpeV9\/z+er8Q==","","0B8cLHOf6C\/Kvk83A2p19oDSz7o4mfYZd7BQKEzYdvyxARKYEv33Ku9dE3mmPEht","lK2kPobp9I3q15oR22TAYg==",null,"x6+djBnhvNr3E7FYmFG0Rw==",null,1,"4856"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["6857","417","172","1342","%","4.94",55.081,"2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["6857","1342","1115.0",1059.9,"2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["2020-01-06","2020-04-05","1342"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 11:27: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":["6857",978,"SETTLED","C15-I207185","2020-01-04 11:27:41","2020-01-06","2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["7185","RENT","\u9810\u7e73\u79df\u91d1",1,1177,"MO","1",1177,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["7185","RENT","\u9810\u7e73\u79df\u91d1",2,1177,"MO","1",1177,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["7185","RENT","\u9810\u7e73\u79df\u91d1",3,1177,"MO","1",1177,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3531,0,"7185"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 11:27: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":[978,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206835","2020-01-04 11:27:41",3531,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["6835","DEPOSIT",null,"PAID","2020-01-04 11:27:41",0,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:27: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":["6835","INVOICE","7185","PAID","2020-01-04 11:27:41",3531,"2","2020-01-04 11:27:41","2","2020-01-04 11:27:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1217,"customer_code":"C191217","identity_type":"PERSONAL","identity_id":"D447759(7)","title":"Ms","lastname":"HUI","firstname":"Mei Ying","companyname":"","email":"florahui23@gmail.com","tel":"91760388","address":"21B, Kam Fat Bldg, 145 Lee Chi Rd, Apleichau, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-14","renew_room_key":"'0006047753","renew_remark":"1 month contract. Storage rental paid by bank transfer on Dec 06, 2019. Storage deposit $2580 transferred from agreement A05-CT196349 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196623, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"114","order_discount":[],"order_room":[{"room_id":"1010","room_code":"A05-008","retail_price":"1290.0","discounted_price":"1290.00","location_id":"4"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1290,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1290,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-14","rent_from":"2020-01-14","rent_to":"2020-02-13","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on January 4\uff0c 2020. Storage deposit $2580 transferred from agreement A05-CT196623 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"4","branch_id":"1","company_id":"1","room_key":"'0006047753","order_product":[],"pass":true}},"first_order_id":"4509","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-008 <\/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":"1290.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","4",1217,"NEW","A05-CT206858",1290,1290,0,0,"1","1",1290,1290,1290,"2020-01-04 11:29:22","0",null,null,null,"2020-01-14","2020-02-13","1 month contract. Storage rental paid by bank transfer on January 4\uff0c 2020. Storage deposit $2580 transferred from agreement A05-CT196623 to this agreement.","2020-01-14","16",0,null,0,"0","2","2020-01-04 11:29:21","2","2020-01-04 11:29:21","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"'0006047753","C191217","PERSONAL","Ms","itB3q7EVO34a2hxkwiPhKw==","SLPJ+c2smshjwdK17xoj0w==","","ueCxoUZm7SuNCZWvZfej2KDREwW7lwoKDTTNZzTAoaO5sqnLfLBRCkfNGM8f7yinGogt7bT6sVG5LxuicUK9\/w==","6zI+PZPtByw9BmzFx6tCzA==","YTLujwAtYb1\/RI+1mL1DaVX7TvWW5ErARjMcxpk9WYA=","vm7DP84yeg7qminXe9MP\/Q==",null,1,"4509"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6858","1010","1290.0","1290.00","2","2020-01-04 11:29:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-14","2020-02-13","1010"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6858",1217,"SETTLED","A05-I207186","2020-01-04 11:29:21","2020-01-14","2","2020-01-04 11:29:21","2","2020-01-04 11:29:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7186","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-01-04 11:29:21","2","2020-01-04 11:29:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7186"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1217,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206836","2020-01-04 11:29:21",1290,"2","2020-01-04 11:29:21","2","2020-01-04 11:29:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6836","DEPOSIT",null,"PAID","2020-01-04 11:29:21",0,"2","2020-01-04 11:29:21","2","2020-01-04 11:29:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:29:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6836","INVOICE","7186","PAID","2020-01-04 11:29:21",1290,"2","2020-01-04 11:29:21","2","2020-01-04 11:29:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":690,"customer_code":"C180690","identity_type":"PERSONAL","identity_id":"D705175(2)","title":"Mr","lastname":"Won","firstname":"Siu Fai","companyname":"","email":"cwsfz01@ha.org.hk","tel":"91225716","address":"Room 511, Wah Mei House, Wah Fu Estate, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-06","renew_room_key":"134,25576","renew_remark":"3 months contract. Storage rental paid by bank transfer on October 4, 2019. Storage deposit transferred from agreement A18-CT195433 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT196081, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[{"master_room_discount_id":"248","master_room_id":"91","discount_type":"%","price":"1290.00","disocunted_price":"1225.90","discount":"4.97","monthly_deduct":64.113,"room_id":"958","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"958","room_code":"W03","retail_price":"1290.0","discounted_price":1225.9,"location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-06","rent_from":"2020-01-06","rent_to":"2020-04-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A18-CT196081 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"3","branch_id":"1","company_id":"1","room_key":"134,25576","order_product":[],"pass":true}},"first_order_id":"4695","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> W03 <\/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":"1226.0","deposit":"0","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","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",690,"NEW","A18-CT206859",1290,1226,0,0,"3","3",3678,3678,3678,"2020-01-04 11:36:10","0",null,null,null,"2020-01-06","2020-04-05","3 months contract. Storage rental paid by bank transfer on January 4, 2020. Storage deposit transferred from agreement A18-CT196081 to this agreement.\r\n","2020-01-06","16",0,null,0,"0","2","2020-01-04 11:36:10","2","2020-01-04 11:36:10","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"134,25576","C180690","PERSONAL","Mr","oMVGeCm8WBCR2o0n0feOIA==","qpk4ojzePwRudjj9aJKrXw==","","7xSGioytLcEU12Rk9BKOgR87yALsOrFitCmjogNY1TKJKAMhVU7acUwfpCUyoZsBFOpPFSijnS1N8IN8ErkAag==","RWNAm\/lx9kQBOf03gYh1\/g==","i6mloX6eyZE8uEg94TGtWDRJeSKUjYDwskVYR7fURWo=","1e3Wb4gTw9zwpSjLHWvFbg==",null,1,"4695"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","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":["6859","248","91","958","%","4.97",64.113,"2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","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":["6859","958","1290.0",1225.9,"2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-06","2020-04-05","958"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 11:36:10","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":["6859",690,"SETTLED","A18-I207187","2020-01-04 11:36:10","2020-01-06","2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7187","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7187","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7187","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7187"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[690,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206837","2020-01-04 11:36:10",3678,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6837","DEPOSIT",null,"PAID","2020-01-04 11:36:10",0,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 11:36:10","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6837","INVOICE","7187","PAID","2020-01-04 11:36:10",3678,"2","2020-01-04 11:36:10","2","2020-01-04 11:36:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"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","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":119,"customer_code":"C160119","identity_type":"PERSONAL","identity_id":"Z912847(7)","title":"Mr","lastname":"Lau","firstname":"Yu Tung","companyname":"","email":"chengby@netvigator.com","tel":"98706021","address":"24B, South Bay Tower, 59 South Bay Road, Repulse Bay, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3301.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-08","renew_room_key":"053, 35040","renew_remark":"6 months contract. Storage rental paid by cheque on July 12, 2019. Storage deposit transferred from agreement A12-CT194132 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195460, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"307","room_code":"E34","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"306","room_code":"E33","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"296","room_code":"E23","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"295","room_code":"E22","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"48","total_retail_price":3992,"total_discounted_price":3301,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":42913,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-08","rent_from":"2020-01-08","rent_to":"2021-02-07","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on January 3, 2020. Storage deposit transferred from agreement A12-CT195460 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":42913,"final_order_total":42913,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053, 35040","order_product":[],"pass":true}},"first_order_id":"4132","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> E34 <\/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> E33 <\/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> E23 <\/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> E22 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"48","total_discounted_price":"3301.00","deposit":"0.00","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",119,"NEW","A12-CT206860",3992,3301,0,0,"13","13",42913,42913,42913,"2020-01-04 12:07:19","0",null,null,null,"2020-01-08","2021-02-07","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on January 3, 2020. Storage deposit transferred from agreement A12-CT195460 to this agreement.\r\n","2020-01-08","48",0,null,0,"0","2","2020-01-04 12:07:18","2","2020-01-04 12:07:18","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053, 35040","C160119","PERSONAL","Mr","F\/11s9o6vYB6gGHlB09BDQ==","oe4emdjBwqJ3qUpOcI17hw==","","07TyYzIE1cpZBSkh1vEBDQkEpN9RO+76JwCeTNbKNxaifc8il5SZGGCKLIQCram2ATNEoNBLKn1v3EpxVKZzLQ==","1nfZOwPdVcfV6\/KJNJ+ZBg==","Zi8cukugrIzT2VMibRsLX6+H8unZw4T94fRTme4CA\/U=","Wf3jTp5oOt0MaNTk5GDCjg==",null,1,"4132"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6860","307","998.0","998.00","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2021-02-07","307"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6860","306","998.0","998.00","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2021-02-07","306"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6860","296","998.0","998.00","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2021-02-07","296"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6860","295","998.0","998.00","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-08","2021-02-07","295"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6860",119,"SETTLED","A12-I207188","2020-01-04 12:07:18","2020-01-08","2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",1,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",2,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",3,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",4,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",5,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",6,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",7,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",8,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",9,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",10,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",11,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",12,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7188","RENT","\u9810\u7e73\u79df\u91d1",13,3301,"MO","1",3301,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[42913,0,"7188"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[119,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206838","2020-01-04 12:07:18",42913,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6838","DEPOSIT",null,"PAID","2020-01-04 12:07:18",0,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:07:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6838","INVOICE","7188","PAID","2020-01-04 12:07:18",42913,"2","2020-01-04 12:07:18","2","2020-01-04 12:07:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:12:04","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["VOID","053, 35040","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on January 3, 2020. Storage deposit transferred from agreement A12-CT195460 to this agreement.\r\n","2020-01-04 12:12:04","2","oe4emdjBwqJ3qUpOcI17hw==","F\/11s9o6vYB6gGHlB09BDQ==","Zi8cukugrIzT2VMibRsLX6+H8unZw4T94fRTme4CA\/U=","1nfZOwPdVcfV6\/KJNJ+ZBg==","07TyYzIE1cpZBSkh1vEBDQkEpN9RO+76JwCeTNbKNxaifc8il5SZGGCKLIQCram2ATNEoNBLKn1v3EpxVKZzLQ==",6860]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:16:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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","floor_plan_rent_room":[{"room_id":"295","master_room_id":"6","room_code":"E22"},{"room_id":"296","master_room_id":"6","room_code":"E23"},{"room_id":"306","master_room_id":"6","room_code":"E33"},{"room_id":"307","master_room_id":"6","room_code":"E34"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> E22 <\/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> E23 <\/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> E33 <\/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> E34 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"Z912847(7)","title":"Mr","lastname":"Lau","firstname":"Yu Tung","companyname":"","email":"chengby@netvigator.com","tel":"98706021","address":"24B, South Bay Tower, 59 South Bay Road, Repulse Bay, Hong Kong","pass":true,"customer_id":"119","customer_code":"C160119","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"295","room_code":"E22","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"296","room_code":"E23","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"306","room_code":"E33","retail_price":"998.0","discounted_price":"998.00","location_id":"1"},{"room_id":"307","room_code":"E34","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"48","total_retail_price":3992,"total_discounted_price":3301,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":39612,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3301.00","warehousing_date":"2020-01-08","rent_from":"2020-01-08","rent_to":"2021-02-07","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by cheque on January 3, 2020. Storage deposit transferred from agreement A12-CT195460 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":3301,"order_total":42913,"final_order_total":39612,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053, 35040","order_product":[],"pass":true}},"roughly_size":"48","total_discounted_price":"3301.00","deposit":"0.00","total_retail_price":"3992.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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` = ?","parameters":["1","1","1","119","NEW","A12-CT206861",3992,3301,0,0,"13","13",39612,42913,39612,"2020-01-04 12:17:03","0",null,null,null,"2020-01-08","2021-02-07","13 months contract. Special offer the 13th month free. Storage rental paid by cheque on January 3, 2020. Storage deposit transferred from agreement A12-CT195460 to this agreement.\r\n","2020-01-08","48",0,null,3301,"3301.00","2","2020-01-04 12:17:03","2","2020-01-04 12:17:03","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"053, 35040","C160119","PERSONAL","Mr","F\/11s9o6vYB6gGHlB09BDQ==","oe4emdjBwqJ3qUpOcI17hw==","","07TyYzIE1cpZBSkh1vEBDQkEpN9RO+76JwCeTNbKNxaifc8il5SZGGCKLIQCram2ATNEoNBLKn1v3EpxVKZzLQ==","1nfZOwPdVcfV6\/KJNJ+ZBg==","Zi8cukugrIzT2VMibRsLX6+H8unZw4T94fRTme4CA\/U=","Wf3jTp5oOt0MaNTk5GDCjg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["6861","295","998.0","998.00","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["2020-01-08","2021-02-07","295"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 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":["6861","296","998.0","998.00","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["2020-01-08","2021-02-07","296"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 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":["6861","306","998.0","998.00","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["2020-01-08","2021-02-07","306"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 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":["6861","307","998.0","998.00","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["2020-01-08","2021-02-07","307"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 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":["6861","119","SETTLED","A12-I207189","2020-01-04 12:17:03","2020-01-08","2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",3,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",4,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",5,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",6,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",7,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",8,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",9,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",10,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",11,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",12,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["7189","RENT","\u9810\u7e73\u79df\u91d1",13,3301,"MO","1",3301,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:17:03","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[39612,0,"7189"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 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":["119","NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206839","2020-01-04 12:17:03",39612,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["6839","DEPOSIT",null,"PAID","2020-01-04 12:17:03",0,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 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":["6839","INVOICE","7189","PAID","2020-01-04 12:17:03",39612,"2","2020-01-04 12:17:03","2","2020-01-04 12:17:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"295","master_room_id":"6","room_code":"E22"},{"room_id":"296","master_room_id":"6","room_code":"E23"},{"room_id":"306","master_room_id":"6","room_code":"E33"},{"room_id":"307","master_room_id":"6","room_code":"E34"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":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":"2020-01-05","renew_room_key":"054,32853","renew_remark":"1 month contract. Storage rental paid by PPS on December 06, 2019. Storage deposit transferred from agreement A12-CT196316 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196635, \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":"2020-01-05","rent_from":"2020-01-05","rent_to":"2020-02-04","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 3. Storage deposit transferred from agreement A12-CT196635 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":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",724,"NEW","A12-CT206862",2096,2058,0,0,"1","1",2058,2058,2058,"2020-01-04 12:26:19","0",null,null,null,"2020-01-05","2020-02-04","1 month contract. Storage rental paid by PPS on January 3. Storage deposit transferred from agreement A12-CT196635 to this agreement.","2020-01-05","28",0,null,0,"0","2","2020-01-04 12:26:19","2","2020-01-04 12:26:19","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":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6862","321","998.0","998.00","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2020-02-04","321"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6862","332","1098.0","1098.00","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2020-02-04","332"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6862",724,"SETTLED","A12-I207190","2020-01-04 12:26:19","2020-01-05","2","2020-01-04 12:26:19","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7190","RENT","\u9810\u7e73\u79df\u91d1",1,2058,"MO","1",2058,"2","2020-01-04 12:26:19","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2058,0,"7190"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[724,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206840","2020-01-04 12:26:19",2058,"2","2020-01-04 12:26:19","2","2020-01-04 12:26:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6840","DEPOSIT",null,"PAID","2020-01-04 12:26:19",0,"2","2020-01-04 12:26:19","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:26:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6840","INVOICE","7190","PAID","2020-01-04 12:26:19",2058,"2","2020-01-04 12:26:19","2","2020-01-04 12:26:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"295","master_room_id":"6","room_code":"E22"},{"room_id":"296","master_room_id":"6","room_code":"E23"},{"room_id":"306","master_room_id":"6","room_code":"E33"},{"room_id":"307","master_room_id":"6","room_code":"E34"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":448,"customer_code":"C170448","identity_type":"PERSONAL","identity_id":"Z011806(1)","title":"Mr","lastname":"Hau","firstname":"Hil Yeung","companyname":"","email":"hermannhau@gmail.com","tel":"97139457","address":"Flat H,2\/F,Block 2,Chi Fu Fa Yuen,Pok Fu Lam,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2022.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-15","renew_room_key":"053,46811","renew_remark":"1 month contract. Storage rental paid by PPS on November 21, 2019. Storage deposit transferred from agreement A14-CT196200 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196475, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"549","room_code":"L27","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"548","room_code":"L26","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2022,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2022,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-15","rent_from":"2019-12-15","rent_to":"2020-01-14","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A14-CT196475 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":2022,"final_order_total":2022,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,46811","order_product":[],"pass":true}},"first_order_id":"4790","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> L27 <\/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> L26 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2022.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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",448,"NEW","A14-CT206863",2196,2022,0,0,"1","1",2022,2022,2022,"2020-01-04 12:30:06","0",null,null,null,"2019-12-15","2020-01-14","1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A14-CT196475 to this agreement.\r\n","2019-12-15","32",0,null,0,"0","2","2020-01-04 12:30:06","2","2020-01-04 12:30:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,46811","C170448","PERSONAL","Mr","NVv9pRh+D1VmYB2XsurgEQ==","8OcLe\/VzxU\/Xek1BNlpsfQ==","","0QpZaBXqoW5CgaBIwDwpjWtY5YJYGo9YtwWqdo6IK1Fg9YHW9ZmtiUF11gEm1OcOe3VhZDJuL+H\/IV+pZmf2Kw==","tujHTZIsGcqjKeaOnttAvg==","jGafPuxpS3yTCisx0O3a7o2TE03wjvCrNp2lr0gCkFw=","y4ZDYxl9X3dwkt7\/dDApww==",null,1,"4790"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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":["6863","549","1098.0","1098.00","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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-15","2020-01-14","549"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:30:06","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":["6863","548","1098.0","1098.00","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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-15","2020-01-14","548"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:30:06","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":["6863",448,"SETTLED","A14-I207191","2020-01-04 12:30:06","2019-12-15","2","2020-01-04 12:30:06","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7191","RENT","\u9810\u7e73\u79df\u91d1",1,2022,"MO","1",2022,"2","2020-01-04 12:30:06","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2022,0,"7191"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 12:30:06","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":[448,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206841","2020-01-04 12:30:06",2022,"2","2020-01-04 12:30:06","2","2020-01-04 12:30:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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":["6841","DEPOSIT",null,"PAID","2020-01-04 12:30:06",0,"2","2020-01-04 12:30:06","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:30:06","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":["6841","INVOICE","7191","PAID","2020-01-04 12:30:06",2022,"2","2020-01-04 12:30:06","2","2020-01-04 12:30:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1079","master_room_id":"110","room_code":"A05-077"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-077 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"E553119(9)","title":"Ms","lastname":"WONG","firstname":"Fung Ling","companyname":"","email":"","tel":"65586997","address":"Room 506, Pik Long House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1079","room_code":"A05-077","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2400,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"500.00","warehousing_date":"2020-01-05","rent_from":"2020-01-05","rent_to":"2020-04-04","delivery_service":"0","remark":"3 months contract. Special offer $500 discount from leaflet. Storage rental and deposit paid by cash on January 4, 2019. Smartcard and padlock provided on January 4, 2019.\r\n3 \u500b\u6708\u5408\u7d04\uff0c\u79df\u91d1\u548c\u6309\u91d1\u7528\u73fe\u91d1\u4ed8\u6b3e\uff0c\u5df2\u63d0\u4f9b\u667a\u80fd\u5361\u548c\u9396\u982d\u3002","paymethod":"CASH","paymethod2":"CASH","discount_deduct":500,"order_total":2900,"final_order_total":2400,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012514063","order_product":[],"pass":true}},"roughly_size":"8","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201483","PERSONAL","Ms","IfiE1xgG+48MJ3aoMyxpQg==","ddrfzAYTmkL\/QNu3psjONQ==","","zuB\/hHIRW2P6YaLfVNtYIw==",null,"R\/2wriCDq\/N8LhUZKFF2zg09LOa7snApSNleutWtP8fMk4tZCy+xQQjYsZEzZjSbzw\/fXJESZxdC3o5OjM6C7VeYDQVXo1\/Vfo4O0q+\/7Zc=","Rowwx6DiPIs66pPyG8irNg==",null,null,"zaHhlgzKijj+WM91R84TyA==","2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","4",1483,"NEW","A05-CT206864",598,568,1196,0,"3","3",2400,2900,2400,"2020-01-04 12:45:06","0",null,null,null,"2020-01-05","2020-04-04","3 months contract. Special offer $500 discount from leaflet. Storage rental and deposit paid by cash on January 4, 2019. Smartcard and padlock provided on January 4, 2019.\r\n3 \u500b\u6708\u5408\u7d04\uff0c\u79df\u91d1\u548c\u6309\u91d1\u7528\u73fe\u91d1\u4ed8\u6b3e\uff0c\u5df2\u63d0\u4f9b\u667a\u80fd\u5361\u548c\u9396\u982d\u3002","2020-01-05","8",0,null,500,"500.00","2","2020-01-04 12:45:04","2","2020-01-04 12:45:04","CASH","","","","CASH","","","",null,0,"0012514063","C201483","PERSONAL","Ms","IfiE1xgG+48MJ3aoMyxpQg==","ddrfzAYTmkL\/QNu3psjONQ==","","R\/2wriCDq\/N8LhUZKFF2zg09LOa7snApSNleutWtP8fMk4tZCy+xQQjYsZEzZjSbzw\/fXJESZxdC3o5OjM6C7VeYDQVXo1\/Vfo4O0q+\/7Zc=","zuB\/hHIRW2P6YaLfVNtYIw==",null,"Rowwx6DiPIs66pPyG8irNg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","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":["6864","1079","598.0","598.00","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-05","2020-04-04","1079"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["6864","A05-D205238","PAID",1196,0,"2020-04-04","2020-01-04 12:45:04","2020-01-04 12:45:04","2","2020-01-04 12:45:04","2","2020-01-04 12:45:04",1483]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","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":["6864",1483,"SETTLED","A05-I207192","2020-01-04 12:45:04","2020-01-05","2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7192","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,68,"MO","1",68,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7192","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7192","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1204,0,"7192"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 12:45:06","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":[1483,"CASH","","","","CASH","","","","PAID","P206842","2020-01-04 12:45:04",2400,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","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":["6842","DEPOSIT","5238","PAID","2020-01-04 12:45:04",1196,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 12:45:06","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":["6842","INVOICE","7192","PAID","2020-01-04 12:45:04",1204,"2","2020-01-04 12:45:04","2","2020-01-04 12:45:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1079","master_room_id":"110","room_code":"A05-077"}],"index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":582,"customer_code":"C170582","identity_type":"PERSONAL","identity_id":"Z064837(0)","title":"Ms","lastname":"Chan","firstname":"Wing Sze","companyname":"","email":"swinzec@yahoo.com","tel":"92378835","address":"Flat D, 19\/F, Block 2, Sham Wan Towers, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"935.0","renew_rent_month":"12","renew_warehousing_date":"2019-11-18","renew_room_key":"054,06821,052,32100","renew_remark":"12 months contract. Storage rental paid by EPS on November 10, 2018. Storage deposit transferred from agreement SD18-CT182200 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT183539, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"982","room_code":"X07","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"roughly_size":"16","total_retail_price":1290,"total_discounted_price":1162,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13944,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1162.00","warehousing_date":"2019-11-18","rent_from":"2019-11-18","rent_to":"2020-12-17","delivery_service":"0","remark":"13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Jan 04,2020. Storage deposit transferred from agreement A18-CT183539 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1162,"order_total":15106,"final_order_total":13944,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,06821,052,32100","order_product":[],"pass":true}},"first_order_id":3539,"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> X07 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1290.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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","3",582,"NEW","A18-CT206865",1290,1162,0,0,"13","13",13944,15106,13944,"2020-01-04 13:00:56","0",null,null,null,"2019-11-18","2020-12-17","13 months contract. Special renewal offer the 13th month free. Storage rental paid by cheque on Jan 04,2020. Storage deposit transferred from agreement A18-CT183539 to this agreement.","2019-11-18","16",0,null,1162,"1162.00","2","2020-01-04 13:00:55","2","2020-01-04 13:00:55","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,06821,052,32100","C170582","PERSONAL","Ms","tvlahPc3bnH\/bIjpFpqEMA==","U9yoE9KqV1v8YlRkf7Q2yg==","","vGZMHTcTMwSglCRe0fbKaP+p0PeXuUdEH+awiC0a7QUllyrHQo8+fahHgisrsqW0zoqUiEsJhwzXCSLe6nMO3w==","vC8w8tt7co9eVNpSmmB7Ag==","IRe6w77xR9qfsNwbUE7AbQkjx+9MKjaEhWGTpuANzFU=","UWtMSjR\/09Re07JwJXrjBA==",null,1,3539]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["6865","982","1290.0","1290.00","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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-11-18","2020-12-17","982"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 13:00: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":["6865",582,"SETTLED","A18-I207193","2020-01-04 13:00:55","2019-11-18","2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",7,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",8,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",9,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",10,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",11,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",12,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["7193","RENT","\u9810\u7e73\u79df\u91d1",13,1162,"MO","1",1162,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13944,0,"7193"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 13:00: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":[582,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P206843","2020-01-04 13:00:55",13944,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["6843","DEPOSIT",null,"PAID","2020-01-04 13:00:55",0,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:00: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":["6843","INVOICE","7193","PAID","2020-01-04 13:00:55",13944,"2","2020-01-04 13:00:55","2","2020-01-04 13:00:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1079","master_room_id":"110","room_code":"A05-077"}],"index_url_parameter":"msg=%E4%BF%AE%E6%94%B9%E6%88%90%E5%8A&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1131,"customer_code":"C181131","identity_type":"PERSONAL","identity_id":"Z345376(7)","title":"Mr","lastname":"Chan","firstname":"Siu Cheung","companyname":"","email":"siucheung2004@yahoo.com.hk","tel":"98251393","address":"Room 2204, Tung On House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-01-03","renew_room_key":"0005012995","renew_remark":"1 month contract. Storage rental paid by PPS on December 9, 2019. Storage deposit transferred from agreement A05-CT196318 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT196661, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1077","room_code":"A05-075","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-03","rent_from":"2020-01-03","rent_to":"2020-02-02","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A05-CT196661 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0005012995","order_product":[],"pass":true}},"first_order_id":"4845","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-075 <\/td>\r\n\t\t\t\t\t 4X2X3.5 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","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",1131,"NEW","A05-CT206866",598,598,0,0,"1","1",598,598,598,"2020-01-04 13:37:06","0",null,null,null,"2020-01-03","2020-02-02","1 month contract. Storage rental paid by PPS on January 3, 2020. Storage deposit transferred from agreement A05-CT196661 to this agreement.\r\n","2020-01-03","8",0,null,0,"0","2","2020-01-04 13:37:05","2","2020-01-04 13:37:05","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0005012995","C181131","PERSONAL","Mr","fGcZizJCatuKFWu4ZRrKSA==","U9yoE9KqV1v8YlRkf7Q2yg==","","CQCYoAe3GOoadJVRzLyv+sNtTDGIle0HVMeR83McsJynyrP8tFX204cW64FCZ5NA5j\/z2cPdugPvlnA2Si9a8Q==","9k5P13X5Z+o0UYFE5+2bdg==","ApBLMJPz\/Z49uwpRoZz00ngQMrV7EI2jJmIQp3ku3DM=","EdsRFjojZ1QPZDY\/kWek4g==",null,1,"4845"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","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":["6866","1077","598.0","598.00","2","2020-01-04 13:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-03","2020-02-02","1077"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 13:37:06","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":["6866",1131,"SETTLED","A05-I207194","2020-01-04 13:37:05","2020-01-03","2","2020-01-04 13:37:05","2","2020-01-04 13:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7194","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-01-04 13:37:05","2","2020-01-04 13:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"7194"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 13:37:06","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":[1131,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P206844","2020-01-04 13:37:05",598,"2","2020-01-04 13:37:05","2","2020-01-04 13:37:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","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":["6844","DEPOSIT",null,"PAID","2020-01-04 13:37:05",0,"2","2020-01-04 13:37:05","2","2020-01-04 13:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 13:37:06","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":["6844","INVOICE","7194","PAID","2020-01-04 13:37:05",598,"2","2020-01-04 13:37:05","2","2020-01-04 13:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1079","master_room_id":"110","room_code":"A05-077"}],"index_url_parameter":"filter1=2&filter2=701&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":921,"customer_code":"C180921","identity_type":"PERSONAL","identity_id":"K417766(5)","title":"Mr","lastname":"Ng","firstname":"Chi Fai","companyname":"","email":null,"tel":"91249410","address":"Flat 2113, Tung Sing House, Lei Tung Estate, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1226.0","renew_rent_month":"3","renew_warehousing_date":"2019-10-06","renew_room_key":"190,01480","renew_remark":"3 months contract. Storage rental paid by cash deposit on September 4, 2019. Storage deposit transferred from agreement A18-CT195250 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195872, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"83","order_discount":[],"order_room":[{"room_id":"899","room_code":"T16","retail_price":"2161.0","discounted_price":"2161.00","location_id":"3"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":1226,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3678,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-06","rent_from":"2019-10-06","rent_to":"2020-01-05","delivery_service":"0","remark":"3 months contract. Storage rental $3700 paid by cash deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195872 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3678,"final_order_total":3678,"location_id":"3","branch_id":"1","company_id":"1","room_key":"190,01480","order_product":[],"pass":true}},"first_order_id":"4788","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> T16 <\/td>\r\n\t\t\t\t\t 7X4X7 <\/td>\r\n\t\t\t\t\t $2161.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":"28","total_discounted_price":"1226.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","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",921,"NEW","A18-CT206867",2161,1226,0,0,"3","3",3678,3678,3678,"2020-01-04 15:33:23","0",null,null,null,"2019-10-06","2020-01-05","3 months contract. Storage rental $3700 paid by cash deposit on January 4, 2020. Storage deposit transferred from agreement A18-CT195872 to this agreement.\r\n","2019-10-06","28",0,null,0,"0","2","2020-01-04 15:33:23","2","2020-01-04 15:33:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,01480","C180921","PERSONAL","Mr","T6CMUvuyn65mo6INgFCWzA==","cxr02xsD1tXvJ4ihJHZKWw==","","4znSbYd2s1aZ81dZq578PUvuG6t5gn7Wvo046vo69wOr5+Yn\/UcwqGGNnSqQuRprN3f78Ab6nHhpSMoUNGAeNlkoMcu03jx6nUdtx5r4eL0=","vaRRqw3IbVZCu9ZmNJ74hQ==",null,"CKUOunaeCUaWfDSGC807sg==",null,1,"4788"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","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":["6867","899","2161.0","2161.00","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-10-06","2020-01-05","899"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-01-04 15:33:23","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":["6867",921,"SETTLED","A18-I207195","2020-01-04 15:33:23","2019-10-06","2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7195","RENT","\u9810\u7e73\u79df\u91d1",1,1226,"MO","1",1226,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7195","RENT","\u9810\u7e73\u79df\u91d1",2,1226,"MO","1",1226,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7195","RENT","\u9810\u7e73\u79df\u91d1",3,1226,"MO","1",1226,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3678,0,"7195"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-01-04 15:33:23","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":[921,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P206845","2020-01-04 15:33:23",3678,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","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":["6845","DEPOSIT",null,"PAID","2020-01-04 15:33:23",0,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-01-04 15:33:23","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":["6845","INVOICE","7195","PAID","2020-01-04 15:33:23",3678,"2","2020-01-04 15:33:23","2","2020-01-04 15:33:23"]},"data_before":[],"data_after":[],"step":1} *****