{"created_at":"2020-04-18 11:33:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 11:49:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:28:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:21","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1505","master_room_id":"205","room_code":"A16-014"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1134,"customer_code":"C181134","identity_type":"PERSONAL","identity_id":"Z017853(6)","title":"Mr","lastname":"Leung","firstname":"Wai Tat","companyname":"","email":"victorleung345@gmail.com","tel":"52255418","address":"Flat 06, 2\/F Yuet Chui Court 9, Yan Tsui St, Chai Wan, HK","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"356.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-10","renew_room_key":"0012472672","renew_remark":"1 month contract. Storage rental paid by PPS on March 9,2020. Storage deposit transferred from agreement C15-CT207158 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207383, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"158","order_discount":[],"order_room":[{"room_id":"1452","room_code":"C15-146","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":356,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":356,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-10","rent_from":"2020-04-10","rent_to":"2020-05-09","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on March 17, 2020. Storage deposit transferred from agreement C15-CT207383 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":356,"final_order_total":356,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012472672","order_product":[],"pass":true}},"first_order_id":"4805","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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
C15-146
<\/td>\r\n\t\t\t\t\t
3X2.7X3
<\/td>\r\n\t\t\t\t\t
$510.00
<\/td>\r\n\t\t\t\t
N\/A <\/td>
<\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\r\n\t\t\t\t\t<\/td>
\r\n\t\t\t\t\t\t
\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"8.1","total_discounted_price":"356.0","deposit":"0","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1134,"NEW","C15-CT207667",510,356,0,0,"1","1",356,356,356,"2020-04-18 13:45:21","0",null,null,null,"2020-04-10","2020-05-09","1 month contract. Storage rental paid by PPS on March 17, 2020. Storage deposit transferred from agreement C15-CT207383 to this agreement.\r\n","2020-04-10","8.1",0,null,0,"0","2","2020-04-18 13:45:21","2","2020-04-18 13:45:21","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"0012472672","C181134","PERSONAL","Mr","S1eQwXaAsUdtzc1Ymck8Jg==","xEf2h2aoyRQ71ZVgBH+9WQ==","","596Kcg0kSfbD85GNFxMa7h8CY7zKszjQ7hj4A6ucjRZeYl+TO11xTTCVesXiaJ\/pTZeIYxCHmr9rgYiIkihiFg==","50+huvkYI7Tn4ZAWxVwcPw==","FRHJOJDYd5XByaT89nynmQawjlXgI0AS4R5zIEqR4E0=","XQVqohimdZ7JoGvCaH2ATQ==",null,1,"4805"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:21","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":["7667","1452","510.0","510.00","2","2020-04-18 13:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:21","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-10","2020-05-09","1452"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-18 13:45:21","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":["7667",1134,"SETTLED","C15-I207995","2020-04-18 13:45:21","2020-04-10","2","2020-04-18 13:45:21","2","2020-04-18 13:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:21","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":["7995","RENT","\u9810\u7e73\u79df\u91d1",1,356,"MO","1",356,"2","2020-04-18 13:45:21","2","2020-04-18 13:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:22","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[356,0,"7995"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-18 13:45:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1134,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207642","2020-04-18 13:45:21",356,"2","2020-04-18 13:45:21","2","2020-04-18 13:45:21","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7642","DEPOSIT",null,"PAID","2020-04-18 13:45:21",0,"2","2020-04-18 13:45:21","2","2020-04-18 13:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 13:45:22","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7642","INVOICE","7995","PAID","2020-04-18 13:45:21",356,"2","2020-04-18 13:45:21","2","2020-04-18 13:45:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 14:57:54","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:24:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"61","master_room_id":"10","room_code":"B09"}],"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
\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
\r\n\t\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>
\r\n\t\t\t\t\t
B09
<\/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","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"D231595(6)","title":"Ms","lastname":"LIU","firstname":"Pui Yee","companyname":"","email":"tammgliu888@yahoo.com","tel":"94016895","address":"Flat 914, Wah Kin House, Wah Fu Est, Pok Fu Lam, South District.","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"61","room_code":"B09","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":2572,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3858,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2020-05-19","delivery_service":"0","remark":"1 month contract. Storage rental and deposit paid by cash on Apr 18,2020. Smart card and padlock provided on the same day.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":3858,"final_order_total":3858,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26664","order_product":[],"pass":true}},"roughly_size":"20","total_discounted_price":"1286.00","deposit":"2572.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:20","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":["C201564","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","wtXe3F1rqyx\/NkkNOLs7pg==","","5MBoUUrP0SuSZ8JjZjyPvw==","VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","BgslglUH0r+MGDNMVR4ODLjLIekcdNYutpHNMKcJTdrat5CTYwp+Fhe5w6yhrvR0cHFxKswLh535kpcAoSEfSvDIf7aqVNHnYcIjpS7j\/kY=","5e+N+acflaaaW7mYFvh\/JQ==",null,"VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","0DSkgfTjjOsi2fvj4Xv33w==","2","2020-04-18 15:28:19","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1",1564,"NEW","A12-CT207668",1528,1286,2572,0,"1","1",3858,3858,3858,"2020-04-18 15:28:21","0",null,null,null,"2020-04-20","2020-05-19","1 month contract. Storage rental and deposit paid by cash on Apr 18,2020. Smart card and padlock provided on the same day.","2020-04-20","20",0,null,0,"0","2","2020-04-18 15:28:19","2","2020-04-18 15:28:19","CASH","","","","CASH","","","",null,0,"190,26664","C201564","PERSONAL","Ms","pW1T\/bCpncDmYxmrSj5N3Q==","wtXe3F1rqyx\/NkkNOLs7pg==","","BgslglUH0r+MGDNMVR4ODLjLIekcdNYutpHNMKcJTdrat5CTYwp+Fhe5w6yhrvR0cHFxKswLh535kpcAoSEfSvDIf7aqVNHnYcIjpS7j\/kY=","5MBoUUrP0SuSZ8JjZjyPvw==","VpKfghnYmCAk6qGCqxoxbQJSaV0E+kVERKvj9qrtcLU=","5e+N+acflaaaW7mYFvh\/JQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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":["7668","61","1528.0","1528.00","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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-20","2020-05-19","61"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-18 15:28:21","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":["7668","A12-D205376","PAID",2572,0,"2020-05-19","2020-04-18 15:28:19","2020-04-18 15:28:19","2","2020-04-18 15:28:19","2","2020-04-18 15:28:19",1564]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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":["7668",1564,"SETTLED","A12-I207996","2020-04-18 15:28:19","2020-04-20","2","2020-04-18 15:28:19","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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":["7996","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2020-04-18 15:28:19","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7996"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-18 15:28:21","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":[1564,"CASH","","","","CASH","","","","PAID","P207643","2020-04-18 15:28:19",3858,"2","2020-04-18 15:28:19","2","2020-04-18 15:28:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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":["7643","DEPOSIT","5376","PAID","2020-04-18 15:28:19",2572,"2","2020-04-18 15:28:19","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:28:21","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":["7643","INVOICE","7996","PAID","2020-04-18 15:28:19",1286,"2","2020-04-18 15:28:19","2","2020-04-18 15:28:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:46:58","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 15:49:15","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":["C201565","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","PZ03d73OXJZeHAlNLPF\/zA==","Advanced Therapy Center Limited","TOhEkNTAbHXDOF3w5ZqUXQ==",null,"rVMZFcDXyY2EKmNqsjGP+baAGw0IflBQPS3oBDxPJnqrm6PLWhYXyKyrrZdyRDi76D22pUVQVlNNH+QVnPrpNJ+ruNhCndzFtPrJwnHs\/40=","","JAvjxhZxPumbXRpj2+2pxQ==",null,"PRvCV\/ybnLPNLSyVxmIQbA==","2","2020-04-18 15:49:12","2","2020-04-18 15:49:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"filter1=3&filter2=438","warehousing":{"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"P489618(5)","title":"Ms","lastname":"Pak ","firstname":"Ah Mei","companyname":"Yu On Curtain Co","email":"","tel":"25530398","address":"\u9999\u6e2f\u4ed4\u5927\u9053201\u865f\u73cd\u5bf6\u5546\u58343\/F,20\u81f321\u865f\u92ea","pass":true,"customer_id":"438","customer_code":"C170438","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"74","room_code":"B22","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":2572,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":16240,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1139.00","warehousing_date":"2020-04-23","rent_from":"2020-04-23","rent_to":"2021-05-22","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental and deposit paid by cheque on Apr 18,2020. Smart card provided on Apr 18,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":1139,"order_total":17379,"final_order_total":16240,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26602","order_product":[],"pass":true}},"selected_room_tr":"\n
\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n
\n
\n\n
\n
\u5df2\u9078\u53d6\u5009\u5eab\n
\n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n
\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>
\n\t\t\t\t\t
B22
<\/td>\n\t\t\t\t\t
4X5X8
<\/td>\n\t\t\t\t\t
$1528.00
<\/td>\n\t\t\t\t
- <\/td>
\u9810\u4ed86\u500b\u6708
% \u6298\u6263 \/
\u9810\u4ed812\u500b\u6708
% \u6298\u6263 <\/td>
\n\t\t\t\t\t\t
\n\t\t\t\t\t<\/td>
\n\t\t\t\t\t\t
\n\t\t\t\t\t<\/td>
\u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"20","total_discounted_price":"1139.00","deposit":"2572.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","1","438","NEW","A12-CT207669",1528,1139,2572,0,"13","13",16240,17379,16240,"2020-04-18 16:07:39","0",null,null,null,"2020-04-23","2021-05-22","13 months contract. Special offer the 13th month free. Storage rental and deposit paid by cheque on Apr 18,2020. Smart card provided on Apr 18,2020.","2020-04-23","20",0,null,1139,"1139.00","2","2020-04-18 16:07:39","2","2020-04-18 16:07:39","CHEQUE","","","","CHEQUE","","","",null,0,"190,26602","C170438","BUSINESS","Ms","9puP0hhCGTyWjmLYbsvUTQ==","h4sjD32CyEMKjSkmXqz3Ug==","Yu On Curtain Co","+UJOG4CCqRbsW8fPhm6qoyVCv1u\/KXfyy6WyeSzTZJQmCZ3bl2Z7kOuIsPqzvth1h6vWhWW4wqfuT\/GfLKUOBA==","l+1soRDGYfvFqU80LabDMQ==",null,null,"9eoivOG0E5N1gaVezyKwNA=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7669","74","1528.0","1528.00","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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-23","2021-05-22","74"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-18 16:07:39","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":["7669","A12-D205377","PAID",2572,0,"2021-05-22","2020-04-18 16:07:39","2020-04-18 16:07:39","2","2020-04-18 16:07:39","2","2020-04-18 16:07:39","438"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7669","438","SETTLED","A12-I207997","2020-04-18 16:07:39","2020-04-23","2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",7,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",8,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",9,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",10,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",11,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",12,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7997","RENT","\u9810\u7e73\u79df\u91d1",13,1139,"MO","1",1139,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[13668,0,"7997"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-18 16:07:39","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":["438","CHEQUE","","","","CHEQUE","","","","PAID","P207644","2020-04-18 16:07:39",16240,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7644","DEPOSIT","5377","PAID","2020-04-18 16:07:39",2572,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:07:39","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":["7644","INVOICE","7997","PAID","2020-04-18 16:07:39",13668,"2","2020-04-18 16:07:39","2","2020-04-18 16:07:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[],"index_url_parameter":"filter1=3&filter2=438","warehousing":{"2":{"order_discount":[],"order_room":[{"room_id":"1310","room_code":"C15-004","retail_price":"773.0","discounted_price":"773.00","location_id":"6"}],"roughly_size":"10","total_retail_price":773,"total_discounted_price":696,"deposit":773,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":7733,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1392.00","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2021-04-19","delivery_service":"0","remark":"12 months contract. Special offer the 11th and 12th months free. Storage rental and deposit paid by bank transfer on Apr 18,2020. Smart card paid on the same day.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1392,"order_total":9185,"final_order_total":7793,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012444558","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true},"1":{"new_customer":"0","identity_type":"BUSINESS","identity_id":"71641104","title":"Ms","lastname":"Ma","firstname":"Ms","companyname":"Advanced Therapy Center Limited","email":"","tel":"61952020","address":"Suite 502, Chuang's Tower, 30 Connaught Road, Central, Hong Kong","pass":true,"customer_id":"1565","customer_code":"C201565","customer_first_order":true}},"selected_room_tr":"\n
\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n
\n
\n\n
\n
\u5df2\u9078\u53d6\u5009\u5eab\n
\n \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab\n <\/button>\n <\/caption>\n
\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>
\n\t\t\t\t\t
C15-004
<\/td>\n\t\t\t\t\t
4X2.5X6.5
<\/td>\n\t\t\t\t\t
$773.00
<\/td>\n\t\t\t\t
- <\/td>
<\/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":"10","total_discounted_price":"696.00","deposit":"773.00","total_retail_price":"773.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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","1565","NEW","C15-CT207670",773,696,773,0,"12","12",7733,9185,7793,"2020-04-18 16:19:51","0",null,null,null,"2020-04-20","2021-04-19","12 months contract. Special offer the 11th and 12th months free. Storage rental and deposit paid by bank transfer on Apr 18,2020. Smart card paid on the same day.","2020-04-20","10",0,null,1392,"1392.00","2","2020-04-18 16:19:50","2","2020-04-18 16:19:50","BANKIN","","","","BANKIN","","","",null,0,"'0012444558","C201565","BUSINESS","Ms","VEr4RtjrPyCEI5wmpFKxTA==","PZ03d73OXJZeHAlNLPF\/zA==","Advanced Therapy Center Limited","rVMZFcDXyY2EKmNqsjGP+baAGw0IflBQPS3oBDxPJnqrm6PLWhYXyKyrrZdyRDi76D22pUVQVlNNH+QVnPrpNJ+ruNhCndzFtPrJwnHs\/40=","TOhEkNTAbHXDOF3w5ZqUXQ==",null,null,"JAvjxhZxPumbXRpj2+2pxQ=="]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7670","1565","11","1","60.0",60,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"7670"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-04-18 16:19:51","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":["7670","1310","773.0","773.00","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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-20","2021-04-19","1310"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-04-18 16:19:51","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":["7670","C15-D205378","PAID",773,0,"2021-04-19","2020-04-18 16:19:50","2020-04-18 16:19:50","2","2020-04-18 16:19:50","2","2020-04-18 16:19:50","1565"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7670","1565","SETTLED","C15-I207998","2020-04-18 16:19:50","2020-04-20","2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",4,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",5,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",6,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",7,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",8,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",9,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",10,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",11,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","RENT","\u9810\u7e73\u79df\u91d1",12,696,"MO","1",696,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7998","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7020,0,"7998"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-04-18 16:19:51","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":["1565","BANKIN","","","","BANKIN","","","","PAID","P207645","2020-04-18 16:19:50",7793,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7645","DEPOSIT","5378","PAID","2020-04-18 16:19:50",773,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:19:51","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":["7645","INVOICE","7998","PAID","2020-04-18 16:19:50",7020,"2","2020-04-18 16:19:50","2","2020-04-18 16:19:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-04-18 16:22:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****