\r\n\t\t\t\t\tX18 4X4X7 $1290.00 N\/A <\/td> \u9810\u4ed83\u500b\u6708 \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"1162.00","deposit":"0.00","total_retail_price":"1290.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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",641,"NEW","A18-CT208213",1290,1162,0,0,"6","6",6972,6972,6972,"2020-06-24 10:18:13","0",null,null,null,"2020-06-30","2020-12-29","6 months contract. Storage rental paid by bank transfer on Jun 24, 2020. Storage deposit $2176 transferred from agreement A18-CT207487 to this agreement.","2020-06-30","16",0,null,0,"0","2","2020-06-24 10:18:12","2","2020-06-24 10:18:12","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,56155","C170641","PERSONAL","Mr","63mqRTB60+F8S2c3OwetCA==","U9yoE9KqV1v8YlRkf7Q2yg==","","mVxu34\/ADgIroa2ReV6UNfkRhQTfP2t1QMlYHDwC5ZECnVBQ0w7fwHSSTCc1HE46Vj2nWeh+3nvp5Trc8xnlmJ3ABStXSUSe0DlMVITvG6c=","bLtMq3KDaf9NP+w4BNhoWg==",null,"swkypxX0yaI5mXeeQxbC1A==",null,1,"4026"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8213","250","91","993","%","10.00",129,"2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8213","993","1290.0",1161,"2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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-06-30","2020-12-29","993"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 10:18:13","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":["8213",641,"SETTLED","A18-I208542","2020-06-24 10:18:12","2020-06-30","2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",1,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",2,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",3,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",4,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",5,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8542","RENT","\u9810\u7e73\u79df\u91d1",6,1162,"MO","1",1162,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6972,0,"8542"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 10:18:13","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":[641,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208185","2020-06-24 10:18:12",6972,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8185","DEPOSIT",null,"PAID","2020-06-24 10:18:12",0,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:18:13","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":["8185","INVOICE","8542","PAID","2020-06-24 10:18:12",6972,"2","2020-06-24 10:18:12","2","2020-06-24 10:18:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:53","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":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":857,"customer_code":"C180857","identity_type":"PERSONAL","identity_id":"K219532(1)","title":"Mr","lastname":"Kwok ","firstname":"Chi Yat","companyname":"","email":"dannykcy1107@yahoo.com.hk","tel":"93668421","address":"Flat 10,18\/F, Ka Ping House, Ka Lang Court, Kellett Bay, HK","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1592.0","renew_rent_month":"13","renew_warehousing_date":"2020-06-29","renew_room_key":"190,39794","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by EPS on May 27, 2019. Storage deposit $3536 transferred from agreement A14-CT183781 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195076, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"482","room_code":"K19","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1592,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":9552,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-29","rent_from":"2020-06-29","rent_to":"2020-12-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit $3536 transferred from agreement A14-CT195076 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":9552,"final_order_total":9552,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39794","order_product":[],"pass":true}},"first_order_id":"3781","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\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\tK19 4X6X8 $1768.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1592.00","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",857,"NEW","A14-CT208214",1768,1592,0,0,"6","6",9552,9552,9552,"2020-06-24 10:25:54","0",null,null,null,"2020-06-29","2020-12-28","6 months contract. Storage rental paid by bank transfer on June 24, 2020. Storage deposit $3536 transferred from agreement A14-CT195076 to this agreement. ","2020-06-29","24",0,null,0,"0","2","2020-06-24 10:25:53","2","2020-06-24 10:25:53","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,39794","C180857","PERSONAL","Mr","\/5428tBrkJl\/uPqVUtQgPg==","gibhZzjUr+EaJ4niaXaQGQ==","","S0T2lG485mNfneicu3oC11Khm3wRuP6t66g96F8ELCXYHFE5qdmr0B+j1mHzIV1fl5DZgl5BpvaVlOsjkm98PA==","sLesquY5KxWfbVBuPSLL3w==","XrwtP8GvYEiuKzeMgargV3fhy+fU9KvUTfZ74xRSzsw=","3IoXogXF25Xe2IR3QVf5wQ==",null,1,"3781"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8214","482","1768.0","1768.00","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-29","2020-12-28","482"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8214",857,"SETTLED","A14-I208543","2020-06-24 10:25:53","2020-06-29","2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",1,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",2,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",3,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",4,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",5,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8543","RENT","\u9810\u7e73\u79df\u91d1",6,1592,"MO","1",1592,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[9552,0,"8543"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[857,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208186","2020-06-24 10:25:53",9552,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8186","DEPOSIT",null,"PAID","2020-06-24 10:25:53",0,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:25:54","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8186","INVOICE","8543","PAID","2020-06-24 10:25:53",9552,"2","2020-06-24 10:25:53","2","2020-06-24 10:25:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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","index_url_parameter":"filter1=2&filter2=98&filter3=undefined","floor_plan_rent_room":[{"room_id":"282","master_room_id":"6","room_code":"E09"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t\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>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> \n\t\t\t\t\tE19 4X3X8 $998.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\tE09 4X3X8 $998.00 N\/A <\/td> \u9810\u4ed86\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Z035461(A)","title":"Mr","lastname":"WONG","firstname":"Chung Hang","companyname":"","email":"fred.ch.wong@gmail.com","tel":"96462673","address":"5\/F, Block F, 3 Robinson Road, Mid-Levels, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"70","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"282","is_final_discount":"0","payment_term":"PREPAID_6_MO"},{"master_room_discount_id":"70 available_room_list_input","master_room_id":"6","discount_type":"%","price":"998.00","disocunted_price":"898.60","discount":"9.96","monthly_deduct":99.4008,"room_id":"292","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"292","room_code":"E19","retail_price":"998.0","discounted_price":898.6,"location_id":"1"},{"room_id":"282","room_code":"E09","retail_price":"998.0","discounted_price":898.6,"location_id":"1"}],"roughly_size":"24","total_retail_price":1996,"total_discounted_price":1768,"deposit":3536,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":10964,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"3180.00","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2020-12-25","delivery_service":"0","remark":"6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by bank transfer on June 24, 2020. Smart card and padlock will be provided before move in.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":3180,"order_total":14144,"final_order_total":10964,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,26625","order_product":[],"pass":true}},"roughly_size":"24","total_discounted_price":"1768.00","deposit":"3536.00","total_retail_price":"1996.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["C201640","PERSONAL","Mr","npiHMr\/Z9wXMUADks\/OtaA==","ddrfzAYTmkL\/QNu3psjONQ==","","eY\/pJrM0jQu7tDmE3HqRBg==","kRXc4GFTsqnGJH4ZDDy4UXEciEAv+opBB\/DLhhQaunY=","739VEtzXtsJL\/wX6LudeCPNg\/zB5HH6CRmjt\/TJOwoC7\/7AShl1K\/kmn22gVYvnwUozDNgZ6lDR6IsYcT7NYbw==","Ebir7AnKDvQ\/BwoiivnURA==",null,"kRXc4GFTsqnGJH4ZDDy4UXEciEAv+opBB\/DLhhQaunY=","flNT62GqlXdcCDaT\/5fqfQ==","2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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",1640,"NEW","A12-CT208215",1996,1768,3536,0,"6","6",10964,14144,10964,"2020-06-24 10:59:21","0",null,null,null,"2020-06-26","2020-12-25","6 months contract. Special offer 50% off for the first 3 months. Storage rental and deposit paid by bank transfer on June 24, 2020. Smart card and padlock will be provided before move in.","2020-06-26","24",0,null,3180,"3180.00","2","2020-06-24 10:59:19","2","2020-06-24 10:59:19","BANKIN","","","","BANKIN","","","",null,0,"190,26625","C201640","PERSONAL","Mr","npiHMr\/Z9wXMUADks\/OtaA==","ddrfzAYTmkL\/QNu3psjONQ==","","739VEtzXtsJL\/wX6LudeCPNg\/zB5HH6CRmjt\/TJOwoC7\/7AShl1K\/kmn22gVYvnwUozDNgZ6lDR6IsYcT7NYbw==","eY\/pJrM0jQu7tDmE3HqRBg==","kRXc4GFTsqnGJH4ZDDy4UXEciEAv+opBB\/DLhhQaunY=","Ebir7AnKDvQ\/BwoiivnURA==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59:21","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":["8215","70","6","282","%","9.96",99.4008,"2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59:21","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":["8215","70 available_room_list_input","6","292","%","9.96",99.4008,"2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8215","292","998.0",898.6,"2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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-06-26","2020-12-25","292"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 10:59: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":["8215","282","998.0",898.6,"2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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-06-26","2020-12-25","282"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 10:59: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":["8215","A12-D205497","PAID",3536,0,"2020-12-25","2020-06-24 10:59:19","2020-06-24 10:59:19","2","2020-06-24 10:59:19","2","2020-06-24 10:59:19",1640]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8215",1640,"SETTLED","A12-I208544","2020-06-24 10:59:19","2020-06-26","2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,356,"MO","1",356,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u9810\u7e73\u79df\u91d1",3,1768,"MO","1",1768,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u9810\u7e73\u79df\u91d1",4,1768,"MO","1",1768,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u9810\u7e73\u79df\u91d1",5,1768,"MO","1",1768,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8544","RENT","\u9810\u7e73\u79df\u91d1",6,1768,"MO","1",1768,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7428,0,"8544"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 10:59: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":[1640,"BANKIN","","","","BANKIN","","","","PAID","P208187","2020-06-24 10:59:19",10964,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8187","DEPOSIT","5497","PAID","2020-06-24 10:59:19",3536,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 10:59: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":["8187","INVOICE","8544","PAID","2020-06-24 10:59:19",7428,"2","2020-06-24 10:59:19","2","2020-06-24 10:59:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:02:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K546420(A)","title":"Ms","lastname":"HSU","firstname":"Pei Ching Betty","companyname":"","email":"bettypchsu@gmail.com","tel":"91987901","address":"15\/F, DINA HOUSE, 11 DUDDELL STREET, CENTRAL.","pass":true,"customer_id":"1638","customer_code":"C201638","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"416","room_code":"I07","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":989,"deposit":2196,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":13476,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1577.00","warehousing_date":"2020-06-26","rent_from":"2020-06-26","rent_to":"2021-07-25","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free and 5% rent now discount. Storage rental and deposit paid by EPS on June 23,2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":1577,"order_total":15053,"final_order_total":13476,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,39795","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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\tI07 4X4X8 $1098.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"989.00","deposit":"2196.00","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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` = ?","parameters":["1","1","2","1638","NEW","A14-CT208216",1098,989,2196,0,"13","13",13476,15053,13476,"2020-06-24 13:19:29","0",null,null,null,"2020-06-26","2021-07-25","13 months contract. Special offer the 13th month free and 5% rent now discount. Storage rental and deposit paid by EPS on June 23,2020. Smart card and padlock provided on the same day.","2020-06-26","16",0,null,1577,"1577.00","2","2020-06-24 13:19:29","2","2020-06-24 13:19:29","EPS","","","","EPS","","","",null,0,"190,39795","C201638","PERSONAL","Ms","LCohVq7FQuoGpXsJ9zntow==","EFJ\/EVT44ongyRfYhod9mw==","","kzE27nGzYlLPmkRlipngIOpajWdnYIqAc89Y\/Y9ZfRGsE2Ui3\/WbjNVTCVqjLnrd","X160kdONhnM8Ty8tKpF2YA==","cebUU0KeGp9rv9lfVuKtSA4O3LkV09pPHvlOdrdw0wY=","KwEA0eZdOQlvjWlQHvaV9g==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8216","416","1098.0","1098.00","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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-06-26","2021-07-25","416"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 13:19:29","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":["8216","A14-D205498","PAID",2196,0,"2021-07-25","2020-06-24 13:19:29","2020-06-24 13:19:29","2","2020-06-24 13:19:29","2","2020-06-24 13:19:29","1638"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8216","1638","SETTLED","A14-I208545","2020-06-24 13:19:29","2020-06-26","2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,401,"MO","1",401,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",3,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",4,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",5,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",6,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",7,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",8,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",9,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",10,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",11,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",12,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8545","RENT","\u9810\u7e73\u79df\u91d1",13,989,"MO","1",989,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11280,0,"8545"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 13:19: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":["1638","EPS","","","","EPS","","","","PAID","P208188","2020-06-24 13:19:29",13476,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8188","DEPOSIT","5498","PAID","2020-06-24 13:19:29",2196,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:19: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":["8188","INVOICE","8545","PAID","2020-06-24 13:19:29",11280,"2","2020-06-24 13:19:29","2","2020-06-24 13:19:29"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 13:20:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 14:23:41","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","190,39795","13 months contract. Special offer the 13th month free and 5% rent now discount. Storage rental and deposit paid by EPS on June 23,2020. Smart card and padlock provided on the same day.","2020-06-24 14:23:41","2","EFJ\/EVT44ongyRfYhod9mw==","LCohVq7FQuoGpXsJ9zntow==","cebUU0KeGp9rv9lfVuKtSA4O3LkV09pPHvlOdrdw0wY=","X160kdONhnM8Ty8tKpF2YA==","kzE27nGzYlLPmkRlipngIOpajWdnYIqAc89Y\/Y9ZfRGsE2Ui3\/WbjNVTCVqjLnrd",8204]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 14:54:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:05:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:17","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=1637&filter3=undefined","floor_plan_rent_room":[{"room_id":"1714","master_room_id":"208","room_code":"A16-223"}],"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\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\tA16-223 5X2X7 $1028.00 N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t \r\n\t\t\t\t\t\t \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":"H485027(2)","title":"Mr","lastname":"LI","firstname":"Shing Wai","companyname":"","email":"","tel":"97895201","address":"Room 302, Nan Mai Building, 46-47 Kennedy Town Praya, Hong Kong","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1714","room_code":"A16-223","retail_price":"1028.0","discounted_price":"1028.00","location_id":"7"}],"roughly_size":"10","total_retail_price":1028,"total_discounted_price":568,"deposit":1196,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2900,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2020-09-30","delivery_service":"0","remark":"3 months contract. Storage rental and deposit paid by cash on June 24, 2020. Smart card provided on June 24,2020.","paymethod":"CASH","paymethod2":"CASH","discount_deduct":0,"order_total":2900,"final_order_total":2900,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,34795","order_product":[],"pass":true}},"roughly_size":"10","total_discounted_price":"568.00","deposit":"1196.00","total_retail_price":"1028.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["C201641","PERSONAL","Mr","+zNxSmf1OUig9Ga5\/4vO1Q==","hbkan9PC5SCnBxQh2lhA4w==","","Ovc7k9\/TCAcLGkAeH8F8VA==",null,"qp3u\/X\/W2Ou27nehok5nXLSbuwfERX2fN3mOhCP3HBRC\/u744N8hjCaDdj06HBUBGzuvIIjSMMXV4hKaX48Ufw==","zr+vRnfYt80CabxtagqjTQ==",null,null,"7XiqyjoqsQv62nVtMEABFg==","2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","1","7",1641,"NEW","A16-CT208217",1028,568,1196,0,"3","3",2900,2900,2900,"2020-06-24 15:09:18","0",null,null,null,"2020-07-01","2020-09-30","3 months contract. Storage rental and deposit paid by cash on June 24, 2020. Smart card provided on June 24,2020.","2020-07-01","10",0,null,0,"0","2","2020-06-24 15:09:17","2","2020-06-24 15:09:17","CASH","","","","CASH","","","",null,0,"076,34795","C201641","PERSONAL","Mr","+zNxSmf1OUig9Ga5\/4vO1Q==","hbkan9PC5SCnBxQh2lhA4w==","","qp3u\/X\/W2Ou27nehok5nXLSbuwfERX2fN3mOhCP3HBRC\/u744N8hjCaDdj06HBUBGzuvIIjSMMXV4hKaX48Ufw==","Ovc7k9\/TCAcLGkAeH8F8VA==",null,"zr+vRnfYt80CabxtagqjTQ==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8217","1714","1028.0","1028.00","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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-07-01","2020-09-30","1714"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 15:09:18","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":["8217","A16-D205499","PAID",1196,0,"2020-09-30","2020-06-24 15:09:17","2020-06-24 15:09:17","2","2020-06-24 15:09:17","2","2020-06-24 15:09:17",1641]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8217",1641,"SETTLED","A16-I208546","2020-06-24 15:09:17","2020-07-01","2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8546","RENT","\u9810\u7e73\u79df\u91d1",1,568,"MO","1",568,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8546","RENT","\u9810\u7e73\u79df\u91d1",2,568,"MO","1",568,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8546","RENT","\u9810\u7e73\u79df\u91d1",3,568,"MO","1",568,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1704,0,"8546"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 15:09:18","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":[1641,"CASH","","","","CASH","","","","PAID","P208189","2020-06-24 15:09:17",2900,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8189","DEPOSIT","5499","PAID","2020-06-24 15:09:17",1196,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:09:18","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":["8189","INVOICE","8546","PAID","2020-06-24 15:09:17",1704,"2","2020-06-24 15:09:17","2","2020-06-24 15:09:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:11:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:13:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 15:20:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:03:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16: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=969&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"A867583(2)","title":"Ms","lastname":"TANG","firstname":"Chui Wah","companyname":"","email":"","tel":"91407803","address":"6D, Siu Bo Building, 126-128 Tsat Tsz Mui Road, North Point, Hong Kong","pass":true,"customer_id":"1346","customer_code":"C191346","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1355","room_code":"C15-049","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":13084,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-10","rent_from":"2020-07-10","rent_to":"2021-07-09","delivery_service":"0","remark":"12 months contract. Storage rental and deposit paid by bank transfer on June 24,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":13084,"final_order_total":13084,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012385422","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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\tC15-049 4X4X6.5 $1108.00 - <\/td> \u9810\u4ed83\u500b\u6708 \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","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-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1346","NEW","C15-CT208218",1108,998,1108,0,"12","12",13084,13084,13084,"2020-06-24 16:16:46","0",null,null,null,"2020-07-10","2021-07-09","12 months contract. Storage rental and deposit paid by bank transfer on June 24,2020.","2020-07-10","16",0,null,0,"0","2","2020-06-24 16:16:45","2","2020-06-24 16:16:45","BANKIN","","","","BANKIN","","","",null,0,"'0012385422","C191346","PERSONAL","Ms","cgWH\/2TvmUG\/vFOv7s9fdg==","20knVHhKlM9kB5wugwP3yQ==","","G5DHBwpzijgPs+ZEbryTgsEycm4OFIFOByATA7UVl+RSBiCZKACfXI89utad6t4gyqDBMIFlGifCIUQODA+y4lbi4W\/VFW8qvp\/1+87ljlo=","kXrr4sCW7q\/RR6Jt+USjCA==",null,"U7TtAzQwpDkYkNXAIq9Ytg==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8218","1355","1108.0","1108.00","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-10","2021-07-09","1355"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 16:16:46","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":["8218","C15-D205500","PAID",1108,0,"2021-07-09","2020-06-24 16:16:45","2020-06-24 16:16:45","2","2020-06-24 16:16:45","2","2020-06-24 16:16:45","1346"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8218","1346","SETTLED","C15-I208547","2020-06-24 16:16:45","2020-07-10","2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8547","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11976,0,"8547"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1346","BANKIN","","","","BANKIN","","","","PAID","P208190","2020-06-24 16:16:45",13084,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8190","DEPOSIT","5500","PAID","2020-06-24 16:16:45",1108,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:16:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8190","INVOICE","8547","PAID","2020-06-24 16:16:45",11976,"2","2020-06-24 16:16:45","2","2020-06-24 16:16:45"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 16:19:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 17:18:46","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:05:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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=860&filter3=undefined","floor_plan_rent_room":[],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"M079390(1)","title":"Ms","lastname":"Sakurai","firstname":"Ayumi","companyname":"","email":"infopub.ayumi@gmail.com","tel":"95555960","address":"Room 1201-7, 12\/F, Chinachem Johnston Plaza, 178-186 Johnston Road, Wanchai, Hong Kong","pass":true,"customer_id":"860","customer_code":"C180860","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"542","room_code":"L20","retail_price":"1342.0","discounted_price":"1342.00","location_id":"2"}],"roughly_size":"16","total_retail_price":1342,"total_discounted_price":1208,"deposit":2684,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":14124,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4264.00","warehousing_date":"2020-07-01","rent_from":"2020-07-01","rent_to":"2021-07-31","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Changed unit from P02 to L20. Storage deposit of L20 $3056 transferred from agreement A14-CT195113 to this agreement. The balance of storage rental and deposit $14124 paid by cheque on June 24,2020.","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":4264,"order_total":18388,"final_order_total":14124,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189,51830,190,38851","order_product":[],"pass":true}},"selected_room_tr":"\n \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\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\tL20 4X4X8 $1342.00 - <\/td> <\/td> \n\t\t\t\t\t\t \n\t\t\t\t\t\t \u522a\u9664<\/button><\/td><\/tr>\n\n \n <\/tbody><\/table><\/div>\n\n\n <\/td>\n ","roughly_size":"16","total_discounted_price":"1208.00","deposit":"2684.00","total_retail_price":"1342.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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","2","860","NEW","A14-CT208219",1342,1208,2684,0,"13","13",14124,18388,14124,"2020-06-24 18:15:20","0",null,null,null,"2020-07-01","2021-07-31","13 months contract. Special offer the 13th month free. Changed unit from P02 to L20. Storage deposit of L20 $3056 transferred from agreement A14-CT195113 to this agreement. The balance of storage rental and deposit $14124 paid by cheque on June 24,2020.","2020-07-01","16",0,null,4264,"4264.00","2","2020-06-24 18:15:20","2","2020-06-24 18:15:20","CHEQUE","","","","CHEQUE","","","",null,0,"189,51830,190,38851","C180860","PERSONAL","Ms","J\/e54z9hpXzsVNuTcBCc0A==","\/B31MBXz3H6LEjSDnZcczA==","","iLIG9TQhLLrVAU8cKjhIbMy6+2O3JHFMoZ1i9yUUFTBYrX31YdaSO+5cmyzZFV7\/RsBBR1fx+EgEiQeOtL0q1hviLUoIoF\/ZIWaCHcK0DNiCsbLkHT\/tVRur6MAT7t0r","IKFWrbSmLQ8jWCUjoCIi\/w==","XAEikEAPIzt6Fot7UtyyxpLsNiWPQW6uzVvPESeS3pM=","cYYQ12\/qtNMGv+F\/BmMm8w==",null]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8219","542","1342.0","1342.00","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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-07-01","2021-07-31","542"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-06-24 18:15:20","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":["8219","A14-D205501","PAID",2684,0,"2021-07-31","2020-06-24 18:15:20","2020-06-24 18:15:20","2","2020-06-24 18:15:20","2","2020-06-24 18:15:20","860"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8219","860","SETTLED","A14-I208548","2020-06-24 18:15:20","2020-07-01","2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,0,"MO","1",0,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",4,568,"MO","1",568,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",5,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",6,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",7,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",8,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",9,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",10,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",11,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",12,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8548","RENT","\u9810\u7e73\u79df\u91d1",13,1208,"MO","1",1208,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11440,0,"8548"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-06-24 18:15:20","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":["860","CHEQUE","","","","CHEQUE","","","","PAID","P208191","2020-06-24 18:15:20",14124,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8191","DEPOSIT","5501","PAID","2020-06-24 18:15:20",2684,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:15:20","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":["8191","INVOICE","8548","PAID","2020-06-24 18:15:20",11440,"2","2020-06-24 18:15:20","2","2020-06-24 18:15:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:24:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 18:24:54","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":["NEW","189,51830,190,38851","13 months contract. Special offer the 13th month free. Changed unit from P02 to L20. Storage deposit of P02 $3056 transferred from agreement A14-CT195113 to this agreement. The balance of storage rental and deposit $14124 paid by cheque on June 24,2020.","2020-06-24 18:24:54","2","\/B31MBXz3H6LEjSDnZcczA==","J\/e54z9hpXzsVNuTcBCc0A==","XAEikEAPIzt6Fot7UtyyxpLsNiWPQW6uzVvPESeS3pM=","IKFWrbSmLQ8jWCUjoCIi\/w==","iLIG9TQhLLrVAU8cKjhIbMy6+2O3JHFMoZ1i9yUUFTBYrX31YdaSO+5cmyzZFV7\/RsBBR1fx+EgEiQeOtL0q1hviLUoIoF\/ZIWaCHcK0DNiCsbLkHT\/tVRur6MAT7t0r",8219]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 19:22:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 22:20:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-06-24 22:39:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****