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

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

\u5009\u5eab\u7de8\u865f<\/td>\n	\u5c3a\u5bf8<\/td>\n	\u539f\u50f9(\u6708)<\/td>\n	\u512a\u60e0\u50f9(\u6708)<\/td>\n	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n	\u50f9\u683c<\/td>\n	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n	<\/td>\n <\/tr>
A05-145 <\/td>\n\t\t\t\t\t	4X3X7 <\/td>\n\t\t\t\t\t	$1090.00 <\/td>\n\t\t\t\t	- <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\n\t\t\t\t\t\t\n\t\t\t\t\t<\/td>	\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"12","total_discounted_price":"1036.00","deposit":"2180.00","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["C201516","PERSONAL","Ms","KrUWcmrrreWoFN9TjxoGzw==","20knVHhKlM9kB5wugwP3yQ==","","kgvNMTVjGcOPQJaDELmQMA==","mrVhJvnc6Edpn4QrNIijqpcpgtuNjOqgWuk3Z\/LOWhc=","hpfUUMdffOkfcUNjfg9BTYMiC6L5Jagp3mi5Te5C4jZxAxOpIS8lj+YSUxl1DOjU","a2ZqY5osJ94\/47L3WupKig==",null,"mrVhJvnc6Edpn4QrNIijqpcpgtuNjOqgWuk3Z\/LOWhc=","9kPQ1xprO\/72ja3Pc4+J6g==","2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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",1516,"NEW","A05-CT207239",1090,1036,2180,0,"3","3",5135,5288,5135,"2020-02-21 14:54:11","0",null,null,null,"2020-02-28","2020-05-27","3 months contract. Special offer 5% 'rent now' discount. Storage rental and deposit paid by EPS on Feb 21,2020. ","2020-02-28","12",0,null,153,"153.00","2","2020-02-21 14:54:10","2","2020-02-21 14:54:10","EPS","","","","EPS","","","",null,0,"189,51765","C201516","PERSONAL","Ms","KrUWcmrrreWoFN9TjxoGzw==","20knVHhKlM9kB5wugwP3yQ==","","hpfUUMdffOkfcUNjfg9BTYMiC6L5Jagp3mi5Te5C4jZxAxOpIS8lj+YSUxl1DOjU","kgvNMTVjGcOPQJaDELmQMA==","mrVhJvnc6Edpn4QrNIijqpcpgtuNjOqgWuk3Z\/LOWhc=","a2ZqY5osJ94\/47L3WupKig==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["7239","244 available_room_list_input","113","1147","%","4.91",53.519,"2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["7239","1147","1090.0",1036.5,"2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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-02-28","2020-05-27","1147"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 14:54:11","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":["7239","A05-D205294","PAID",2180,0,"2020-05-27","2020-02-21 14:54:10","2020-02-21 14:54:10","2","2020-02-21 14:54:10","2","2020-02-21 14:54:10",1516]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["7239",1516,"SETTLED","A05-I207567","2020-02-21 14:54:10","2020-02-28","2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7567","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,883,"MO","1",883,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7567","RENT","\u9810\u7e73\u79df\u91d1",2,1036,"MO","1",1036,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7567","RENT","\u9810\u7e73\u79df\u91d1",3,1036,"MO","1",1036,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2955,0,"7567"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 14:54:11","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":[1516,"EPS","","","","EPS","","","","PAID","P207215","2020-02-21 14:54:10",5135,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["7215","DEPOSIT","5294","PAID","2020-02-21 14:54:10",2180,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 14:54:11","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":["7215","INVOICE","7567","PAID","2020-02-21 14:54:10",2955,"2","2020-02-21 14:54:10","2","2020-02-21 14:54:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=278&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":818,"customer_code":"C180818","identity_type":"PERSONAL","identity_id":"D703992(2)","title":"Ms","lastname":"Fung","firstname":"Wai Ching","companyname":"","email":"chip_n_dale166@yahoo.com.hk","tel":"98125760","address":"Room 4, 3\/F, Kong Tai Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2202.0","renew_rent_month":"3","renew_warehousing_date":"2020-01-16","renew_room_key":"054,17784","renew_remark":"3 months contract. Storage rental paid by bank transfer on Nov 05, 2019. Storage deposit transferred from agreement A14-CT195494 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196348, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"516","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"803","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"803","room_code":"K61","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"516","room_code":"K53","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":2202,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6606,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-01-16","rent_from":"2020-01-16","rent_to":"2020-04-15","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on February 20, 2020. Storage deposit transferred from agreement A14-CT196348 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6606,"final_order_total":6606,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,17784","order_product":[],"pass":true}},"first_order_id":"4838","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> K61 <\/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> K53 <\/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":"2202.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",818,"NEW","A14-CT207240",2196,2202,0,0,"3","3",6606,6606,6606,"2020-02-21 15:07:58","0",null,null,null,"2020-01-16","2020-04-15","3 months contract. Storage rental paid by PPS on February 20, 2020. Storage deposit transferred from agreement A14-CT196348 to this agreement.\r\n","2020-01-16","32",0,null,0,"0","2","2020-02-21 15:07:57","2","2020-02-21 15:07:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,17784","C180818","PERSONAL","Ms","yu\/0S+RF2RRsi8jECHi7sQ==","fw9NU0t2sgJqYX3ZpxPMlA==","","aaFSbXHSM+gPlOwdl71kBt7soBX\/1aneMHEJOQYEO6L+eTZCyEdmviQxuPN7ErkMp8jCZMURTq8BYQgvLiGXScTEP6pC0Wf9Qm9V\/ZEYNWo=","2XbqO7eDKwpKi\/y4qvPGdQ==","RSOrop83aKNG+aZKY\/WBkseqisNlK416aa5o4eaZ8qM=","zaMy9FDDPHyrX0QJz9TXhA==",null,1,"4838"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7240","434","35","516","%","4.97",54.5706,"2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7240","434","35","803","%","4.97",54.5706,"2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7240","803","1098.0",1043.4,"2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-16","2020-04-15","803"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7240","516","1098.0",1043.4,"2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-16","2020-04-15","516"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7240",818,"SETTLED","A14-I207568","2020-02-21 15:07:57","2020-01-16","2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7568","RENT","\u9810\u7e73\u79df\u91d1",1,2202,"MO","1",2202,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7568","RENT","\u9810\u7e73\u79df\u91d1",2,2202,"MO","1",2202,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7568","RENT","\u9810\u7e73\u79df\u91d1",3,2202,"MO","1",2202,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6606,0,"7568"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[818,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207216","2020-02-21 15:07:57",6606,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","DEPOSIT",null,"PAID","2020-02-21 15:07:57",0,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:07:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7216","INVOICE","7568","PAID","2020-02-21 15:07:57",6606,"2","2020-02-21 15:07:57","2","2020-02-21 15:07:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=278&filter3=undefined&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":852,"customer_code":"C180852","identity_type":"BUSINESS","identity_id":"33657674-000-03-18-7","title":"Mr","lastname":"Lau","firstname":"Gerald","companyname":"Pacific Sky Holdings Limited","email":"phoenix@laufamilyoffice.com","tel":"98809440","address":"Flat 1604, Tai Tung Bldg., 8 Fleming Road, Wan Chai, H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3931.0","renew_rent_month":"3","renew_warehousing_date":"2020-02-17","renew_room_key":"190,39679 , 191 05287","renew_remark":"3 months contract. Storage rental paid by cheque deposit on November 20, 2019. Storage deposit transferred from agreement A12-CT183670 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196460, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"751","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"752","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"762","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"763","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"763","room_code":"O39","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"762","room_code":"O38","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"752","room_code":"O28","retail_price":"998.0","discounted_price":949,"location_id":"2"},{"room_id":"751","room_code":"O27","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"56","total_retail_price":4192,"total_discounted_price":3931,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":11793,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-17","rent_from":"2020-02-17","rent_to":"2020-05-16","delivery_service":"0","remark":"3 months contract. Storage rental paid by cheque deposit on February 21, 2020. Storage deposit transferred from agreement A14-CT196460 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11793,"final_order_total":11793,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39679 , 191 05287","order_product":[],"pass":true}},"first_order_id":"3672","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> O39 <\/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> O38 <\/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> O28 <\/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\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> O27 <\/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\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":"56","total_discounted_price":"3931.0","deposit":"0","total_retail_price":"4192.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",852,"NEW","A14-CT207241",4192,3931,0,0,"3","3",11793,11793,11793,"2020-02-21 15:12:57","0",null,null,null,"2020-02-17","2020-05-16","3 months contract. Storage rental paid by cheque deposit on February 21, 2020. Storage deposit transferred from agreement A14-CT196460 to this agreement.","2020-02-17","56",0,null,0,"0","2","2020-02-21 15:12:57","2","2020-02-21 15:12:57","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,39679 , 191 05287","C180852","BUSINESS","Mr","8Sg5HEYOjjrQdMyK1+QWDA==","oe4emdjBwqJ3qUpOcI17hw==","Pacific Sky Holdings Limited","IIKRaaGPL2HpnfgJAUJhCj8+x0hKi5DNcx6YIYwtlZEVlqlzxdoWKu0w1522L4DfmIdFoJkBhGa6ZfmacJM6dg==","c1K4BLKclEz9E3nuvvIo3A==","\/nCaUx+Hqmx6yjXW1XYmc6GmvIbzzej1NbJ+mu4tneg=",null,"LrVQNy2nb4HilGXMHPXLx0dpSDyGUkQVOQmMveXzVow=",1,"3672"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","470","34","751","%","4.91",49.0018,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","470","34","752","%","4.91",49.0018,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","434","35","762","%","4.97",54.5706,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_discount` set `order_id` = ?, `master_room_discount_id` = ?, `master_room_id` = ?, `room_id` = ?, `discount_type` = ?, `discount` = ?, `monthly_deduct` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","434","35","763","%","4.97",54.5706,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","763","1098.0",1043.4,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-05-16","763"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","762","1098.0",1043.4,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-05-16","762"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","752","998.0",949,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-05-16","752"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7241","751","998.0",949,"2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-17","2020-05-16","751"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7241",852,"SETTLED","A14-I207569","2020-02-21 15:12:57","2020-02-17","2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7569","RENT","\u9810\u7e73\u79df\u91d1",1,3931,"MO","1",3931,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7569","RENT","\u9810\u7e73\u79df\u91d1",2,3931,"MO","1",3931,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7569","RENT","\u9810\u7e73\u79df\u91d1",3,3931,"MO","1",3931,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11793,0,"7569"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[852,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207217","2020-02-21 15:12:57",11793,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7217","DEPOSIT",null,"PAID","2020-02-21 15:12:57",0,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:12:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7217","INVOICE","7569","PAID","2020-02-21 15:12:57",11793,"2","2020-02-21 15:12:57","2","2020-02-21 15:12:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=278&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":525,"customer_code":"C170525","identity_type":"PERSONAL","identity_id":"G161193(2)","title":"Ms","lastname":"Man","firstname":"Fung Yi Roni","companyname":"","email":"manroni@kawinghong.com","tel":"54362045","address":"\u9999\u6e2f\u8d64\u67f1\u9f8d\u5fb7\u82d1\u6649\u5fb7\u95a32\u6a1313\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2336.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-21","renew_room_key":"056,13866","renew_remark":"1 month contract. Storage rental paid by bank transfer on January 20, 2020. Storage deposit transferred from agreement A14-CT196729 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207021, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[],"order_room":[{"room_id":"544","room_code":"L22(\u670d\u88dd\u5009)","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"},{"room_id":"545","room_code":"L23","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"32","total_retail_price":2440,"total_discounted_price":2336,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2336,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-21","rent_from":"2020-02-21","rent_to":"2020-03-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on February 19, 2020. Storage deposit transferred from agreement A14-CT207021 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2336,"final_order_total":2336,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,13866","order_product":[],"pass":true}},"first_order_id":"4877","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L22(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1342.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> L23 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"32","total_discounted_price":"2336.0","deposit":"0","total_retail_price":"2440.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",525,"NEW","A14-CT207242",2440,2336,0,0,"1","1",2336,2336,2336,"2020-02-21 15:15:25","0",null,null,null,"2020-02-21","2020-03-20","1 month contract. Storage rental paid by bank transfer on February 19, 2020. Storage deposit transferred from agreement A14-CT207021 to this agreement.\r\n","2020-02-21","32",0,null,0,"0","2","2020-02-21 15:15:25","2","2020-02-21 15:15:25","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,13866","C170525","PERSONAL","Ms","ibYrH9hZ8AxKQwoDOyRf7g==","1iB+Fi5mVPBhoP\/ei\/0Bag==","","6FEfBp4QinpFgaVk\/XySHjwYeKgnpkSt7nsZEe9qVfgX7gsIGumX1P5i\/O8D1hN0","kjGiWZ21y1YpwaPjV74WsA==","qyZUZxcd5Fov\/z6YWfj+Qzvwf4EvFlsT926fUqJ1c+g=","CTeh4\/H1iVpxG8qx2JRcpg==",null,1,"4877"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","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":["7242","544","1342.0","1342.00","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","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-02-21","2020-03-20","544"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:15:25","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":["7242","545","1098.0","1098.00","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","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-02-21","2020-03-20","545"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:15:25","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":["7242",525,"SETTLED","A14-I207570","2020-02-21 15:15:25","2020-02-21","2","2020-02-21 15:15:25","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7570","RENT","\u9810\u7e73\u79df\u91d1",1,2336,"MO","1",2336,"2","2020-02-21 15:15:25","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2336,0,"7570"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 15:15:25","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[525,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207218","2020-02-21 15:15:25",2336,"2","2020-02-21 15:15:25","2","2020-02-21 15:15:25","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","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":["7218","DEPOSIT",null,"PAID","2020-02-21 15:15:25",0,"2","2020-02-21 15:15:25","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:15:25","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":["7218","INVOICE","7570","PAID","2020-02-21 15:15:25",2336,"2","2020-02-21 15:15:25","2","2020-02-21 15:15:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:34","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=278&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1272,"customer_code":"C191272","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3180.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-22","renew_room_key":"076,32309,076,34777","renew_remark":"1 months contact. Storage rental paid by bank transfer on January 10, 2020. Storage deposit $6360 transferred from agreement A16-CT196764 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT206926, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"220","order_discount":[],"order_room":[{"room_id":"1641","room_code":"A16-150","retail_price":"3180.0","discounted_price":"3180.00","location_id":"7"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3180,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-22","rent_from":"2020-02-22","rent_to":"2020-03-21","delivery_service":"0","remark":"1 months contact. Storage rental paid by bank transfer on January 21, 2020. Storage deposit $6360 transferred from agreement A16-CT206926 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3180,"final_order_total":3180,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"first_order_id":"5065","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-150 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3180.0","deposit":"0","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1272,"NEW","A16-CT207243",3180,3180,0,0,"1","1",3180,3180,3180,"2020-02-21 15:17:35","0",null,null,null,"2020-02-22","2020-03-21","1 months contact. Storage rental paid by bank transfer on January 21, 2020. Storage deposit $6360 transferred from agreement A16-CT206926 to this agreement. ","2020-02-22","42",0,null,0,"0","2","2020-02-21 15:17:34","2","2020-02-21 15:17:34","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null,1,"5065"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7243","1641","3180.0","3180.00","2","2020-02-21 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-22","2020-03-21","1641"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7243",1272,"SETTLED","A16-I207571","2020-02-21 15:17:34","2020-02-22","2","2020-02-21 15:17:34","2","2020-02-21 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7571","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2020-02-21 15:17:34","2","2020-02-21 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3180,0,"7571"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207219","2020-02-21 15:17:34",3180,"2","2020-02-21 15:17:34","2","2020-02-21 15:17:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7219","DEPOSIT",null,"PAID","2020-02-21 15:17:34",0,"2","2020-02-21 15:17:34","2","2020-02-21 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:17:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7219","INVOICE","7571","PAID","2020-02-21 15:17:34",3180,"2","2020-02-21 15:17:34","2","2020-02-21 15:17:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1272&filter3=undefined","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1639","master_room_id":"215","room_code":"A16-148"},{"room_id":"1640","master_room_id":"215","room_code":"A16-149"}],"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 \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A16-148 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.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> A16-149 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.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":"0","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true,"customer_id":"1272","customer_code":"C191272","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1639","room_code":"A16-148","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1640","room_code":"A16-149","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"}],"roughly_size":"70","total_retail_price":5310,"total_discounted_price":5310,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":5310,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-22","rent_from":"2020-02-22","rent_to":"2020-03-21","delivery_service":"0","remark":"1 months contact. Storage rental paid by bank transfer on January 21, 2020. Storage deposit $15930 transferred from agreement A16-CT206924 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5310,"final_order_total":5310,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"roughly_size":"70","total_discounted_price":"5310.00","deposit":"0.00","total_retail_price":"5310.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7","1272","NEW","A16-CT207244",5310,5310,0,0,"1","1",5310,5310,5310,"2020-02-21 15:21:40","0",null,null,null,"2020-02-22","2020-03-21","1 months contact. Storage rental paid by bank transfer on January 21, 2020. Storage deposit $15930 transferred from agreement A16-CT206924 to this agreement. ","2020-02-22","70",0,null,0,"0","2","2020-02-21 15:21:40","2","2020-02-21 15:21:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7244","1639","2655.0","2655.00","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-22","2020-03-21","1639"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7244","1640","2655.0","2655.00","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-22","2020-03-21","1640"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7244","1272","SETTLED","A16-I207572","2020-02-21 15:21:40","2020-02-22","2","2020-02-21 15:21:40","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7572","RENT","\u9810\u7e73\u79df\u91d1",1,5310,"MO","1",5310,"2","2020-02-21 15:21:40","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5310,0,"7572"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1272","NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207220","2020-02-21 15:21:40",5310,"2","2020-02-21 15:21:40","2","2020-02-21 15:21:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7220","DEPOSIT",null,"PAID","2020-02-21 15:21:40",0,"2","2020-02-21 15:21:40","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 15:21:40","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7220","INVOICE","7572","PAID","2020-02-21 15:21:40",5310,"2","2020-02-21 15:21:40","2","2020-02-21 15:21:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 18:06:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 18:34:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 18:45:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 19:29:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-02-21 21:15:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****