{"created_at":"2020-03-26 10:19:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 10:19:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 10:19:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 10:38:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 11:48:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:15:24","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=972&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"939","master_room_id":"78","room_code":"V13"}],"_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>
V13 <\/td>\r\n\t\t\t\t\t	4X5X7 <\/td>\r\n\t\t\t\t\t	$1605.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D302826(8)","title":"Ms","lastname":"Chu","firstname":"Lai Ngan ","companyname":"","email":"","tel":"91216789","address":"Flat E, 13\/F, Tower 8, South Horizons, Ap Lei Chau","pass":true,"customer_id":"663","customer_code":"C170663","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"939","room_code":"V13","retail_price":"1605.0","discounted_price":"1605.00","location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1605,"deposit":3210,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2235,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"2580.00","warehousing_date":"2020-03-27","rent_from":"2020-03-27","rent_to":"2020-04-26","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by cheque on March 26,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":2580,"order_total":4815,"final_order_total":2235,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,06790","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1605.00","deposit":"3210.00","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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` = ?","parameters":["1","1","3","663","NEW","A18-CT207493",1605,1605,3210,0,"1","1",2235,4815,2235,"2020-03-26 15:15:25","0",null,null,null,"2020-03-27","2020-04-26","1 month contract. Storage rental and deposit paid by cheque on March 26,2020.","2020-03-27","20",0,null,2580,"2580.00","2","2020-03-26 15:15:24","2","2020-03-26 15:15:24","CHEQUE","","","","CHEQUE","","","",null,0,"055,06790","C170663","PERSONAL","Ms","+hf2BdEzeyuAlJ9o86BQkA==","uwdKi3S38jh5+tBibXKG4A==","","ZkyPYW\/X9p1lPTh\/bKU+\/PiAtXClt+yHReh+airMmSnG6Uwc2BRo5SF4sycqncKB\/EoNyhigJWrejarCTwNPAg==","q3\/rgHjoH\/vhcz82yJ8JGA==",null,"x7LEi0saK+ePsbHhJKXpDQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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":["7493","939","1605.0","1605.00","2","2020-03-26 15:15:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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-03-27","2020-04-26","939"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:15:25","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":["7493","A18-D205339","PAID",3210,0,"2020-04-26","2020-03-26 15:15:24","2020-03-26 15:15:24","2","2020-03-26 15:15:24","2","2020-03-26 15:15:24","663"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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":["7493","663","SETTLED","A18-I207821","2020-03-26 15:15:24","2020-03-27","2","2020-03-26 15:15:24","2","2020-03-26 15:15:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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":["7821","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-26 15:15:24","2","2020-03-26 15:15:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:15:25","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[0,0,"7821"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 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":["663","CHEQUE","","","","CHEQUE","","","","PAID","P207468","2020-03-26 15:15:24",3210,"2","2020-03-26 15:15:24","2","2020-03-26 15:15:24","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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":["7468","DEPOSIT","5339","PAID","2020-03-26 15:15:24",3210,"2","2020-03-26 15:15:24","2","2020-03-26 15:15:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 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":["7468","INVOICE","7821","PAID","2020-03-26 15:15:24",0,"2","2020-03-26 15:15:24","2","2020-03-26 15:15:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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=972&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"939","master_room_id":"78","room_code":"V13"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":75,"customer_code":"C160075","identity_type":"PERSONAL","identity_id":"P388174(5)","title":"Mr","lastname":"Yu","firstname":"Ben Ansheng","companyname":"","email":"cmcheung@bunkeeintl.com.hk","tel":"92666155","address":"12\/F Phase 1, Austin Tower, 22-26A Austin Avenue, Tsim Sha Tsui, HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4588.0","renew_rent_month":"6","renew_warehousing_date":"2020-04-01","renew_room_key":"136,64762","renew_remark":"6 months contract. Storage rental paid by cheque on October 2, 2019. Storage deposit transferred from agreement A12-CT194628 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196050, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"79","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"90","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"89","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"78","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"90","room_code":"B38","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"89","room_code":"B37","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"79","room_code":"B27","retail_price":"1528.0","discounted_price":1376,"location_id":"1"},{"room_id":"78","room_code":"B26","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"80","total_retail_price":6112,"total_discounted_price":4588,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":27528,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-09-30","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque deposit on March 26, 2020. Storage deposit transferred from agreement A12-CT196050 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":27528,"final_order_total":27528,"location_id":"1","branch_id":"1","company_id":"1","room_key":"136,64762","order_product":[],"pass":true}},"first_order_id":"4628","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> B38 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/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> B37 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/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> B27 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/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> B26 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/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":"80","total_discounted_price":"4588.0","deposit":"0","total_retail_price":"6112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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",75,"NEW","A12-CT207494",6112,4588,0,0,"6","6",27528,27528,27528,"2020-03-26 15:18:45","0",null,null,null,"2020-04-01","2020-09-30","6 months contract. Storage rental paid by cheque deposit on March 26, 2020. Storage deposit transferred from agreement A12-CT196050 to this agreement.","2020-04-01","80",0,null,0,"0","2","2020-03-26 15:18:45","2","2020-03-26 15:18:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"136,64762","C160075","PERSONAL","Mr","ViAZz904uiBVldL10gAtlg==","thtRZ5CDeQ9OOuodTdr1ng==","","n3twYLp1CxrYRThMTUZyNqCdHbnqdq+UldlYTrxaGx4URYRlLUtZR5LxZ+idAJlk3udQywXm3m1jA+achtRmmHUo+FeJT1TkdKW4hvZw900=","K7fTSLsRD1tLV0ZC+Zp+8Q==","SkXzpeBvqQirS3zD9aOcVVPaICJb4+n+7nAlFLsY9wY=","N7EztyTRRMnCcb35Bs7d\/A==",null,1,"4628"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","76","10","79","%","9.95",152.036,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","76","10","90","%","9.95",152.036,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","76","10","89","%","9.95",152.036,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","76","10","78","%","9.95",152.036,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","90","1528.0",1376,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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-04-01","2020-09-30","90"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","89","1528.0",1376,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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-04-01","2020-09-30","89"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","79","1528.0",1376,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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-04-01","2020-09-30","79"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:18:45","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":["7494","78","1528.0",1376,"2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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-04-01","2020-09-30","78"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:18:45","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":["7494",75,"SETTLED","A12-I207822","2020-03-26 15:18:45","2020-04-01","2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",1,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",2,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",3,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",4,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",5,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7822","RENT","\u9810\u7e73\u79df\u91d1",6,4588,"MO","1",4588,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[27528,0,"7822"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 15:18:45","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":[75,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207469","2020-03-26 15:18:45",27528,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7469","DEPOSIT",null,"PAID","2020-03-26 15:18:45",0,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:18:45","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":["7469","INVOICE","7822","PAID","2020-03-26 15:18:45",27528,"2","2020-03-26 15:18:45","2","2020-03-26 15:18:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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=972&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"939","master_room_id":"78","room_code":"V13"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1525,"customer_code":"C201525","identity_type":"PERSONAL","identity_id":"D627443(A)","title":"Mr","lastname":"CHOI","firstname":"Four Hing Franki","companyname":"","email":"cflgh@msn.com","tel":"90988941","address":"\u5357\u5be7\u88577-11\u865f\u9999\u6e2f\u4ed4\u4e2d\u5fc32\u671f2\/F, 7A","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1290.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-01","renew_room_key":"189,29014","renew_remark":"1 month contract. Special offer 5% discount. $500 deposit paid on Feb 26,2020. The balance of storage rental and deposit paid by cash on Feb 27,2020.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207268, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2580.0","renew_master_room_id":"91","order_discount":[],"order_room":[{"room_id":"961","room_code":"W06","retail_price":"1290.0","discounted_price":"1290.00","location_id":"3"}],"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-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 25, 2020. Storage deposit $2580 transferred from agreement A18-CT207268 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1290,"final_order_total":1290,"location_id":"3","branch_id":"1","company_id":"1","room_key":"189,29014","order_product":[],"pass":true}},"first_order_id":7268,"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> W06 <\/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-03-26 15:24:45","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",1525,"NEW","A18-CT207495",1290,1290,0,0,"1","1",1290,1290,1290,"2020-03-26 15:24:45","0",null,null,null,"2020-04-01","2020-04-30","1 month contract. Storage rental paid by PPS on March 25, 2020. Storage deposit $2580 transferred from agreement A18-CT207268 to this agreement. ","2020-04-01","16",0,null,0,"0","2","2020-03-26 15:24:45","2","2020-03-26 15:24:45","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"189,29014","C201525","PERSONAL","Mr","vIS8IXZkRCz\/4DSJEmIinoenG6ZUfvhRmXtzZy6KRoQ=","U3iGX7U0CkjAKcdgZ04K6A==","","20f7aMgpRV51FiOUQ6KXK6mkR6c4knVkEjw08eLXIZ9w9x4z60rU\/ZG\/wTtfSJoa","Qy93BhGnEO1KQrhkwq1v1A==","zHs7gYv08db9ZpNBd4xf+g==","QaEoWHg\/xDsQ4hnCUpRbZg==",null,1,7268]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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":["7495","961","1290.0","1290.00","2","2020-03-26 15:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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-04-01","2020-04-30","961"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:24:45","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":["7495",1525,"SETTLED","A18-I207823","2020-03-26 15:24:45","2020-04-01","2","2020-03-26 15:24:45","2","2020-03-26 15:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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":["7823","RENT","\u9810\u7e73\u79df\u91d1",1,1290,"MO","1",1290,"2","2020-03-26 15:24:45","2","2020-03-26 15:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1290,0,"7823"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 15:24:45","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":[1525,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207470","2020-03-26 15:24:45",1290,"2","2020-03-26 15:24:45","2","2020-03-26 15:24:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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":["7470","DEPOSIT",null,"PAID","2020-03-26 15:24:45",0,"2","2020-03-26 15:24:45","2","2020-03-26 15:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:24:45","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":["7470","INVOICE","7823","PAID","2020-03-26 15:24:45",1290,"2","2020-03-26 15:24:45","2","2020-03-26 15:24:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:13","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=972&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"939","master_room_id":"78","room_code":"V13"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1498,"customer_code":"C201498","identity_type":"PERSONAL","identity_id":"Z813062(1)","title":"Ms","lastname":"TSUI","firstname":"Wai Ting","companyname":"","email":"leila.tsui@yahoo.com.hk","tel":"92829889","address":"RM 103 Pick Shan House,Shek Pai Wan Estate H.K.","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-15","renew_room_key":"","renew_remark":"1 month contract. Storage rental and deposit paid by bank transfer on January 15,2020. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207048, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1196.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"198","room_code":"D02","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1196,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-15","rent_from":"2020-02-15","rent_to":"2020-04-14","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on March 26, 2020. Storage deposit $1196 transferred from agreement A12-CT207048 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1196,"final_order_total":1196,"location_id":"1","branch_id":"1","company_id":"1","room_key":"","order_product":[],"pass":true}},"first_order_id":7048,"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> D02 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"12","total_discounted_price":"598.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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",1498,"NEW","A12-CT207496",598,598,0,0,"2","2",1196,1196,1196,"2020-03-26 15:41:14","0",null,null,null,"2020-02-15","2020-04-14","2 months contract. Storage rental paid by bank transfer on March 26, 2020. Storage deposit $1196 transferred from agreement A12-CT207048 to this agreement. \r\n","2020-02-15","12",0,null,0,"0","2","2020-03-26 15:41:13","2","2020-03-26 15:41:13","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"","C201498","PERSONAL","Ms","JgAavgpIkIT+QrZDjc3BRA==","4zek2V6v+muRHEsNI7xEHw==","","PMn1p0oadyJx29V1OPiOSN\/BYn2sl3wPiJ9DdvSe3jCo8xHWlf6yiVjMvn60tn+k","kQeKRVYsl351hB8tSJajyg==","qkxnp5SHRu4Kc3Kv53ZfIb6\/ziTIdZr0R53qKZFrHLM=","JwsF7JQXZLJyMrrbcjBmIQ==",null,1,7048]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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":["7496","198","598.0","598.00","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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-15","2020-04-14","198"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:41:14","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":["7496",1498,"SETTLED","A12-I207824","2020-03-26 15:41:13","2020-02-15","2","2020-03-26 15:41:13","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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":["7824","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-03-26 15:41:13","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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":["7824","RENT","\u9810\u7e73\u79df\u91d1",2,598,"MO","1",598,"2","2020-03-26 15:41:13","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1196,0,"7824"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 15:41:14","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":[1498,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207471","2020-03-26 15:41:13",1196,"2","2020-03-26 15:41:13","2","2020-03-26 15:41:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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":["7471","DEPOSIT",null,"PAID","2020-03-26 15:41:13",0,"2","2020-03-26 15:41:13","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:41:14","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":["7471","INVOICE","7824","PAID","2020-03-26 15:41:13",1196,"2","2020-03-26 15:41:13","2","2020-03-26 15:41:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:45:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:28","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=972&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"939","master_room_id":"78","room_code":"V13"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":461,"customer_code":"C170461","identity_type":"PERSONAL","identity_id":"D551156(A)","title":"Ms","lastname":"Chang","firstname":"Nai Hwa Patsy","companyname":"","email":"patsychanglau@hotmail.com","tel":"95039948","address":"Flat 35, 6FL, BLK C&D,High Street ","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2206.0","renew_rent_month":"6","renew_warehousing_date":"2020-02-28","renew_room_key":"053,35042","renew_remark":"6 months contract. Storage rental paid by bank transfer on September 12, 2019. Storage deposit transferred from agreement A14-CT195151 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195946, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"38","order_discount":[],"order_room":[{"room_id":"436","room_code":"J18","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"},{"room_id":"435","room_code":"J17","retail_price":"1528.0","discounted_price":"1528.00","location_id":"2"}],"roughly_size":"40","total_retail_price":3056,"total_discounted_price":2328,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":6984,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-28","rent_from":"2020-02-28","rent_to":"2020-05-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on March 26, 2020. Storage deposit transferred from agreement A14-CT195946 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6984,"final_order_total":6984,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,35042","order_product":[],"pass":true}},"first_order_id":"3676","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> J18 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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> J17 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/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":"40","total_discounted_price":"2328.00","deposit":"0.00","total_retail_price":"3056.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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",461,"NEW","A14-CT207497",3056,2328,0,0,"3","3",6984,6984,6984,"2020-03-26 15:51:29","0",null,null,null,"2020-02-28","2020-05-27","3 months contract. Storage rental paid by bank transfer on March 26, 2020. Storage deposit transferred from agreement A14-CT195946 to this agreement.\r\n","2020-02-28","40",0,null,0,"0","2","2020-03-26 15:51:28","2","2020-03-26 15:51:28","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"053,35042","C170461","PERSONAL","Ms","iOLOVFk2xy+Y5cUO4STirw==","8biuvROOyoUh0fK62hac9A==","","6c55ivNHEsh4FDZHAscCeNaHrwiqmKBuSmcA4ZzFhM4ogOYVKi+IV6dQuE+9tV5Z","ZicxqO9CvUZeDs9DzNfASg==","etU4spI1gGhRHwRXJT\/HUGzALfrxJvVb\/kH7\/Dpt\/rs=","qSx1lAoxSiXUDpaEfGpQYw==",null,1,"3676"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7497","436","1528.0","1528.00","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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","436"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:51:29","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":["7497","435","1528.0","1528.00","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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","435"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 15:51:29","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":["7497",461,"SETTLED","A14-I207825","2020-03-26 15:51:28","2020-02-28","2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7825","RENT","\u9810\u7e73\u79df\u91d1",1,2328,"MO","1",2328,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7825","RENT","\u9810\u7e73\u79df\u91d1",2,2328,"MO","1",2328,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7825","RENT","\u9810\u7e73\u79df\u91d1",3,2328,"MO","1",2328,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6984,0,"7825"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 15:51:29","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":[461,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207472","2020-03-26 15:51:28",6984,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7472","DEPOSIT",null,"PAID","2020-03-26 15:51:28",0,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:51:29","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":["7472","INVOICE","7825","PAID","2020-03-26 15:51:28",6984,"2","2020-03-26 15:51:28","2","2020-03-26 15:51:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:59:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 15:59:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 16:59:08","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:01:21","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":["C201545","PERSONAL","Mr","Y++GISczwcWlx43u6svewQ==","ANeDwI8\/NwcNHrMn03wP3Q==","","4Y4rlnLRSoarWFyVBITTlA==","5MIHoeA7HhOjt7ipofrudw==","6F88GPSmmnGXsPk2ZyJKWg==","LnYwDg8RU1Z9jsUDzb3CTg==","","5MIHoeA7HhOjt7ipofrudw==","WOGbfjqSi29PpZ37UoO4aw==","2","2020-03-26 17:01:17","2","2020-03-26 17:01:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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=1545","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"1365","master_room_id":"171","room_code":"C15-059"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-059 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"E839145(2)","title":"Mr","lastname":"LI","firstname":"Chi Ming","companyname":"","email":"Icm839@yahoo.com.hk","tel":"90896946","address":"Rm 2006, Sheung Lai Hse, Sheung Tak Est, TKO.","pass":true,"customer_id":"1535","customer_code":"C201535","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1365","room_code":"C15-059","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"16","total_retail_price":1108,"total_discounted_price":998,"deposit":1108,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":2028,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"11056.00","warehousing_date":"2020-03-22","rent_from":"2020-03-22","rent_to":"2021-03-21","delivery_service":"0","remark":"12 months contract. Change unit from C15-093 to C15-059. Deposit and storage rental $9060 transferred from agreement C15-CT207441 to this agreement. The balance of storage rental and deposit $2088 paid by bank transfer on Mar 26,2020. Smart card paid on the same day and provided on Mar 14,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":11056,"order_total":13144,"final_order_total":2088,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449907","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"16","total_discounted_price":"998.00","deposit":"1108.00","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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` = ?","parameters":["1","3","6","1535","NEW","C15-CT207498",1108,998,1108,0,"12","12",2028,13144,2088,"2020-03-26 17:39:57","0",null,null,null,"2020-03-22","2021-03-21","12 months contract. Change unit from C15-093 to C15-059. Deposit and storage rental $9060 transferred from agreement C15-CT207441 to this agreement. The balance of storage rental and deposit $2088 paid by bank transfer on Mar 26,2020. Smart card paid on the same day and provided on Mar 14,2020.","2020-03-22","16",0,null,11056,"11056.00","2","2020-03-26 17:39:57","2","2020-03-26 17:39:57","BANKIN","","","","BANKIN","","","",null,0,"'0012449907","C201535","PERSONAL","Mr","85IYGmU7T42vA2xjCNQ\/9g==","hbkan9PC5SCnBxQh2lhA4w==","","v1uaESv8HAaPqw\/8Ej72t\/Rzj64\/i21NAf+DjL\/Qh4lDDFFaYQ3iMIzh4\/N909DY","Mv0z3K4f6C4VF\/G+LY\/SZw==","qv8f\/krFGh99P\/FudbY1Y1UeNKw8VGZpMdle2zbrzMo=","qSnufjHixqmeW9K\/8kA31A==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7498","1535","11","1","60.0",60,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7498"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-03-26 17:39: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":["7498","1365","1108.0","1108.00","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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-03-22","2021-03-21","1365"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-03-26 17:39:57","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":["7498","C15-D205340","PAID",1108,0,"2021-03-21","2020-03-26 17:39:57","2020-03-26 17:39:57","2","2020-03-26 17:39:57","2","2020-03-26 17:39:57","1535"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7498","1535","SETTLED","C15-I207826","2020-03-26 17:39:57","2020-03-22","2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",5,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",6,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",7,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",8,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",9,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",10,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",11,0,"MO","1",0,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7826","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",12,920,"MO","1",920,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39:57","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7826","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39:57","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[980,0,"7826"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-03-26 17:39: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":["1535","BANKIN","","","","BANKIN","","","","PAID","P207473","2020-03-26 17:39:57",2088,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7473","DEPOSIT","5340","PAID","2020-03-26 17:39:57",1108,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 17:39: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":["7473","INVOICE","7826","PAID","2020-03-26 17:39:57",980,"2","2020-03-26 17:39:57","2","2020-03-26 17:39:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 18:34:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 18:35:12","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","'0012449907","12 months contract. Deposit $500 paid by cash on Mar 14,2020. The balance of storage rental and deposit $8560 paid by bank transfer on Mar 18,2020. Smart card paid on the same day and provided on Mar 14,2020.","2020-03-26 18:35:12","2","hbkan9PC5SCnBxQh2lhA4w==","85IYGmU7T42vA2xjCNQ\/9g==","qv8f\/krFGh99P\/FudbY1Y1UeNKw8VGZpMdle2zbrzMo=","Mv0z3K4f6C4VF\/G+LY\/SZw==","v1uaESv8HAaPqw\/8Ej72t\/Rzj64\/i21NAf+DjL\/Qh4lDDFFaYQ3iMIzh4\/N909DY",7441]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-03-26 18:47:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****