{"created_at":"2020-07-24 09:23:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 09:30:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 10:25:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 10:26:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 10:37:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 10:39:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 11:57:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 11:57:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 11:57:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"page=5&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":452,"customer_code":"C170452","identity_type":"PERSONAL","identity_id":"D707578(3)","title":"Mr","lastname":"Szeto","firstname":"Wang","companyname":"","email":null,"tel":"96404178","address":"\u9999\u6e2f\u4ed4\u5927\u9053\u798f\u7fa4\u5927\u5ec8B\u5ea72407\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1430.0","renew_rent_month":"12","renew_warehousing_date":"2020-05-23","renew_room_key":"056,16409","renew_remark":"12 months contract. Special renewal offer, $100 cake voucher offered. Storage rental paid by cheque deposit on May 31, 2019. Storage deposit transferred from agreement A14-CT183848 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195123, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"49","order_discount":[],"order_room":[{"room_id":"446","room_code":"J28","retail_price":"1838.0","discounted_price":"1838.00","location_id":"2"}],"roughly_size":"25","total_retail_price":1838,"total_discounted_price":1430,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":8580,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-23","rent_from":"2020-05-23","rent_to":"2020-11-22","delivery_service":"0","remark":"6 months contract. Storage rental paid by cheque deposit on Jul 06, 2020. Storage deposit transferred from agreement A14-CT195123 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":8580,"final_order_total":8580,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,16409","order_product":[],"pass":true}},"first_order_id":"3848","selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

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

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

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
J28 <\/td>\r\n\t\t\t\t\t	5X5X8 <\/td>\r\n\t\t\t\t\t	$1838.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"25","total_discounted_price":"1430.00","deposit":"0.00","total_retail_price":"1838.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",452,"NEW","A14-CT208454",1838,1430,0,0,"6","6",8580,8580,8580,"2020-07-24 12:11:23","0",null,null,null,"2020-05-23","2020-11-22","6 months contract. Storage rental paid by cheque deposit on Jul 06, 2020. Storage deposit transferred from agreement A14-CT195123 to this agreement.","2020-05-23","25",0,null,0,"0","2","2020-07-24 12:11:23","2","2020-07-24 12:11:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"056,16409","C170452","PERSONAL","Mr","Kwr4lhwTrRo\/YfVMh3nHuw==","1UqKnhC2qf0fkyXoPk21YA==","","ow908ba+wGomZSW5GQlfm+5qz065tc5vb5\/b\/fAUNMHtAU5B6Cobu+uF+eeMAoZY","2MdGTeOoSMJ5S5jKcWFnWA==",null,"KuM5aNaNomeYPNO88\/MvLQ==",null,1,"3848"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8454","446","1838.0","1838.00","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-23","2020-11-22","446"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8454",452,"SETTLED","A14-I208783","2020-07-24 12:11:23","2020-05-23","2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",1,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",2,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",3,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",4,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",5,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8783","RENT","\u9810\u7e73\u79df\u91d1",6,1430,"MO","1",1430,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[8580,0,"8783"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[452,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208426","2020-07-24 12:11:23",8580,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","DEPOSIT",null,"PAID","2020-07-24 12:11:23",0,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:11:23","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8426","INVOICE","8783","PAID","2020-07-24 12:11:23",8580,"2","2020-07-24 12:11:23","2","2020-07-24 12:11:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:15:45","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:04","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=8381&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"313","master_room_id":"6","room_code":"E40"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":409,"customer_code":"C170409","identity_type":"PERSONAL","identity_id":"D505846(6)","title":"Ms","lastname":"So ","firstname":"Yuk Fong","companyname":"","email":null,"tel":"60143731","address":"Flat B ,27\/F ,Block T ,Yee Court, South Horizons,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-04","renew_room_key":"137,09030","renew_remark":"6 months contract. Storage rental paid by bank transfer on November 28, 2019. Storage deposit transferred from agreement A14-CT195011 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196523, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"495","room_code":"K32","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1433,"deposit":0,"rent_month":"5","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"5","prepaid_amount":7165,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-04","rent_from":"2020-05-04","rent_to":"2020-10-03","delivery_service":"0","remark":"5 months contract. Storage rental paid by cheque on Jul 11, 2020. Storage deposit transferred from agreement A14-CT196523 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7165,"final_order_total":7165,"location_id":"2","branch_id":"1","company_id":"1","room_key":"137,09030","order_product":[],"pass":true}},"first_order_id":"3791","selected_room_tr":"	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> K32 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1433.00","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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",409,"NEW","A14-CT208455",1768,1433,0,0,"5","5",7165,7165,7165,"2020-07-24 12:17:05","0",null,null,null,"2020-05-04","2020-10-03","5 months contract. Storage rental paid by cheque on Jul 11, 2020. Storage deposit transferred from agreement A14-CT196523 to this agreement.","2020-05-04","24",0,null,0,"0","2","2020-07-24 12:17:04","2","2020-07-24 12:17:04","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"137,09030","C170409","PERSONAL","Ms","iDfH3Ryza9\/4Ntcd5NJyeg==","NwetNJkzGkmRzh66GYn4rQ==","","yWo2S17\/sb6dbTizPGahnEqQvgzIjeCVW7nDqnuRtmnPZKWTtbuNck43iC43AmDBxCoow4lqwHfYJa1\/drPrtA==","CpPZKGthr8YunreqzUUZYw==",null,"Nw1iJnTAlSZAq1JDA8RVEA==",null,1,"3791"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8455","495","1768.0","1768.00","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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-05-04","2020-10-03","495"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 12:17:05","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":["8455",409,"SETTLED","A14-I208784","2020-07-24 12:17:04","2020-05-04","2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8784","RENT","\u9810\u7e73\u79df\u91d1",1,1433,"MO","1",1433,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8784","RENT","\u9810\u7e73\u79df\u91d1",2,1433,"MO","1",1433,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8784","RENT","\u9810\u7e73\u79df\u91d1",3,1433,"MO","1",1433,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8784","RENT","\u9810\u7e73\u79df\u91d1",4,1433,"MO","1",1433,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8784","RENT","\u9810\u7e73\u79df\u91d1",5,1433,"MO","1",1433,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7165,0,"8784"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 12:17:05","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":[409,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208427","2020-07-24 12:17:04",7165,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8427","DEPOSIT",null,"PAID","2020-07-24 12:17:04",0,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:17:05","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":["8427","INVOICE","8784","PAID","2020-07-24 12:17:04",7165,"2","2020-07-24 12:17:04","2","2020-07-24 12:17:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":"page=5&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1435,"customer_code":"C191435","identity_type":"PERSONAL","identity_id":"Z600823(3)","title":"Ms","lastname":"SO","firstname":"Ching Man","companyname":"","email":"manman_615@gmail.com","tel":"66857798","address":"\u9d28\u8137\u6d32\u5229\u6771\u90a8\u6771\u5e73\u6a133209\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-05","renew_room_key":"190,25713","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 24, 2020. Storage deposit $1996 transferred from agreement A14-CT207616 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207986, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"562","room_code":"L40","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1996,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-05","rent_from":"2020-06-05","rent_to":"2020-08-04","delivery_service":"0","remark":"2 months contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit $1996 transferred from agreement A14-CT207986 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1996,"final_order_total":1996,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,25713","order_product":[],"pass":true}},"first_order_id":"6294","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> L40 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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",1435,"NEW","A14-CT208456",998,998,0,0,"2","2",1996,1996,1996,"2020-07-24 12:21:38","0",null,null,null,"2020-06-05","2020-08-04","2 months contract. Storage rental paid by bank transfer on Jul 23, 2020. Storage deposit $1996 transferred from agreement A14-CT207986 to this agreement.","2020-06-05","12",0,null,0,"0","2","2020-07-24 12:21:38","2","2020-07-24 12:21:38","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"190,25713","C191435","PERSONAL","Ms","knZMm9GAZID7Lv+9MLc5ZA==","mOWsGT2TzOPDdjq14yV0zw==","","JP4Rs\/ygk7B5+4qY1O\/77mUgOqLhOV7RAed2ioH8C+7gkcorV\/Bk82G90L53vhh8","95CDSt30lRyCZEH4n270nw==","bE\/Jfb0PyFebKTBoaLQMLuSWgoH2ygJQ\/KlmIxPGGno=","v8f4b0Nv2Vl1ElMKQ09dDQ==",null,1,"6294"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":["8456","562","998.0","998.00","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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-05","2020-08-04","562"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 12:21:38","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":["8456",1435,"SETTLED","A14-I208785","2020-07-24 12:21:38","2020-06-05","2","2020-07-24 12:21:38","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":["8785","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-07-24 12:21:38","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":["8785","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-07-24 12:21:38","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1996,0,"8785"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 12:21:38","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":[1435,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208428","2020-07-24 12:21:38",1996,"2","2020-07-24 12:21:38","2","2020-07-24 12:21:38","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":["8428","DEPOSIT",null,"PAID","2020-07-24 12:21:38",0,"2","2020-07-24 12:21:38","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:21:38","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":["8428","INVOICE","8785","PAID","2020-07-24 12:21:38",1996,"2","2020-07-24 12:21:38","2","2020-07-24 12:21:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:22:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 12:59:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:07","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=0&filter2=8381&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[{"room_id":"313","master_room_id":"6","room_code":"E40"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1335,"customer_code":"C191335","identity_type":"PERSONAL","identity_id":"D306799(9)","title":"Mr","lastname":"LI","firstname":"Man Kong Vincent","companyname":"","email":"vincentmkli@yahoo.com.hk","tel":"63306619","address":"13A, Block 2, Blessings Garden, Conduit Road, Mid-Level, Hong Kong.","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"868.0","renew_rent_month":"12","renew_warehousing_date":"2020-07-20","renew_room_key":"0012388408","renew_remark":"12 months contract. Special offer 2 months free and $200 discount. Storage rental and deposit paid by EPS on 18 July, 2019. Smartcard provided on July 18, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: B01-CT195506, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $2224.0","renew_master_room_id":"140","order_discount":[{"master_room_discount_id":"315","master_room_id":"140","discount_type":"%","price":"1112.00","disocunted_price":"816.00","discount":"26.62","monthly_deduct":296.0144,"room_id":"1229","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"1229","room_code":"B01-039","retail_price":"1112.0","discounted_price":816,"location_id":"5"}],"roughly_size":"16","total_retail_price":1112,"total_discounted_price":979,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5874,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-20","rent_from":"2020-07-20","rent_to":"2021-01-19","delivery_service":"0","remark":"6 months contract. Storage rental and deposit paid by bank transfer on 24 July, 2020. Storage deposit $2224 transferred from agreement B01-CT195506 to this agreement. Smart card provided on July 18, 2019. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5874,"final_order_total":5874,"location_id":"5","branch_id":"2","company_id":"1","room_key":"0012388408","order_product":[],"pass":true}},"first_order_id":5506,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-039 <\/td>\r\n\t\t\t\t\t 4X4X7 <\/td>\r\n\t\t\t\t\t $1112.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"16","total_discounted_price":"979.00","deposit":"0.00","total_retail_price":"1112.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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","2","5",1335,"NEW","B01-CT208457",1112,979,0,0,"6","6",5874,5874,5874,"2020-07-24 13:00:08","0",null,null,null,"2020-07-20","2021-01-19","6 months contract. Storage rental and deposit paid by bank transfer on 24 July, 2020. Storage deposit $2224 transferred from agreement B01-CT195506 to this agreement. Smart card provided on July 18, 2019. \r\n","2020-07-20","16",0,null,0,"0","2","2020-07-24 13:00:07","2","2020-07-24 13:00:07","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012388408","C191335","PERSONAL","Mr","NbGbWQaHFG5GIdGaf0RZ04Bpgb0RlwmwCrfhkAGM9cw=","hbkan9PC5SCnBxQh2lhA4w==","","fJY1TRB71Tru5168xGu\/0P71EzYEjfgjR6mwB+O6roALQM9d\/q94PSwCZO58NjRbmY5RueDu1fwSWFCSfi0wkR1XYwW+d83sdk1mSgFtUgE=","QQLaFw2MfAqQ0Q3j+NtK6g==","L\/YkHitiDh+fdpXp71HCWS+JKyOHCMciN8Tl14of6vM=","6fERhUQ4Ik66BlAwxqXtuQ==",null,1,5506]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8457","315","140","1229","%","26.62",296.0144,"2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8457","1229","1112.0",816,"2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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-20","2021-01-19","1229"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 13:00:08","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":["8457",1335,"SETTLED","B01-I208786","2020-07-24 13:00:07","2020-07-20","2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",1,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",2,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",3,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",4,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",5,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8786","RENT","\u9810\u7e73\u79df\u91d1",6,979,"MO","1",979,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5874,0,"8786"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 13:00:08","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":[1335,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208429","2020-07-24 13:00:07",5874,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8429","DEPOSIT",null,"PAID","2020-07-24 13:00:07",0,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:00:08","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":["8429","INVOICE","8786","PAID","2020-07-24 13:00:07",5874,"2","2020-07-24 13:00:07","2","2020-07-24 13:00:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:06:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 13:35:42","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":["C201685","PERSONAL","Ms","4QMnxddJdslJoypyVtWPyw==","fwsebH2az17gKNdZ18K8Cg==","","a2IWvXZ1FGKF7JMCbKiy0w==","gzzQWKTJ6NR68JO3U6qnptyActWEjzpzcyaIOKwMDM4=","YqyR\/ljTxjPy9Kcb5Y7KhHjFHcwbri6DcbAUsyrBFqStAAs6z1ZMV52UW8dmbiKQdOP70X1VRszKGtlxm3GUjw==","AgwQy3Oo272aCE7M6GbUFQ==","","gzzQWKTJ6NR68JO3U6qnptyActWEjzpzcyaIOKwMDM4=","bBeHaVkUZ86OpTA+A+Qa6Q==","2","2020-07-24 13:35:39","2","2020-07-24 13:35:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 14:56:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 15:23:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 15:24:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:03:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:23:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:28","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","floor_plan_rent_room":[{"room_id":"1449","master_room_id":"158","room_code":"C15-143"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-143 <\/td>\r\n\t\t\t\t\t 3X2.7X3 <\/td>\r\n\t\t\t\t\t $510.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"G462179(3)","title":"Mr","lastname":"FUNG","firstname":"Chi Yuen","companyname":"","email":"vincent7072@gmail.com","tel":"63701121","address":"Rm 1408, Sui Hei House, Sui Sai Wan Estate, Chai Wan, HK","pass":true,"customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1449","room_code":"C15-143","retail_price":"510.0","discounted_price":"510.00","location_id":"6"}],"roughly_size":"8.1","total_retail_price":510,"total_discounted_price":510,"deposit":510,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1020,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-27","rent_from":"2020-07-27","rent_to":"2020-08-26","delivery_service":"0","remark":"1 month contract. Storage rental and deposit, smart card and padlock paid by EPS on Jul 24, 2020. Smart card and padlock provided on the same day.","paymethod":"EPS","paymethod2":"EPS","discount_deduct":0,"order_total":1140,"final_order_total":1140,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012453324","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"},{"product_id":"12","product_name":"\u5009\u9396\u5319","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"8.1","total_discounted_price":"510.00","deposit":"510.00","total_retail_price":"510.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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":["C201686","PERSONAL","Mr","zwFahw6gw13hO3IcISft2w==","cyZbjLKMtXmsqxQPpU0UpA==","","+22K61eYX1JCu9nvP12qxg==","WYwCndrNbsniawBLPMNctw5biwuQbQO\/WGyZlMQ24BY=","KmHk4W0fiXFI0PV\/jmuX4JUbI1pr\/RpO7lidQTZX9ltCdhuq1\/hNa1azcOB9nYjMCTNw5J79uO7PZIzBONdU8Q==","o\/NQaof9YXPL7tmOqz54kw==",null,"WYwCndrNbsniawBLPMNctw5biwuQbQO\/WGyZlMQ24BY=","YJoAG2MecafDBBpOKSF9EQ==","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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",1686,"NEW","C15-CT208458",510,510,510,0,"1","1",1020,1140,1140,"2020-07-24 16:40:30","0",null,null,null,"2020-07-27","2020-08-26","1 month contract. Storage rental and deposit, smart card and padlock paid by EPS on Jul 24, 2020. Smart card and padlock provided on the same day.","2020-07-27","8.1",0,null,0,"0","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28","EPS","","","","EPS","","","",null,0,"'0012453324","C201686","PERSONAL","Mr","zwFahw6gw13hO3IcISft2w==","cyZbjLKMtXmsqxQPpU0UpA==","","KmHk4W0fiXFI0PV\/jmuX4JUbI1pr\/RpO7lidQTZX9ltCdhuq1\/hNa1azcOB9nYjMCTNw5J79uO7PZIzBONdU8Q==","+22K61eYX1JCu9nvP12qxg==","WYwCndrNbsniawBLPMNctw5biwuQbQO\/WGyZlMQ24BY=","o\/NQaof9YXPL7tmOqz54kw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8458",1686,"11","1","60.0",60,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8458",1686,"12","1","60.0",60,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[120,"8458"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-07-24 16:40:30","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":["8458","1449","510.0","510.00","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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-27","2020-08-26","1449"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 16:40:30","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":["8458","C15-D205562","PAID",510,0,"2020-08-26","2020-07-24 16:40:28","2020-07-24 16:40:28","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28",1686]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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":["8458",1686,"SETTLED","C15-I208787","2020-07-24 16:40:28","2020-07-27","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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":["8787","RENT","\u9810\u7e73\u79df\u91d1",1,510,"MO","1",510,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8787","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8787","ORDER_PRODUCT","60.0","PCS","1",60,"12","2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[630,0,"8787"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 16:40:30","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":[1686,"EPS","","","","EPS","","","","PAID","P208430","2020-07-24 16:40:28",1140,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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":["8430","DEPOSIT","5562","PAID","2020-07-24 16:40:28",510,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 16:40:30","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":["8430","INVOICE","8787","PAID","2020-07-24 16:40:28",630,"2","2020-07-24 16:40:28","2","2020-07-24 16:40:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 17:14:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:12:13","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16: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":"all=1&page=2","floor_plan_rent_room":[{"room_id":"1191","master_room_id":"141","room_code":"B01-001"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> B01-001 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1308.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"1","identity_type":"PERSONAL","identity_id":"Y249466(1)","title":"Mr","lastname":"WONG","firstname":"Kenneth Stuyvesant","companyname":"","email":"jeanxrogue@gmail.com","tel":"98297823","address":"Flat C, 12F, Block A, Chong Yip Center, 402-404 Dex Voeus Road West, Sai Ying Pun, H.K.","pass":true,"customer_first_order":true},"2":{"order_discount":[{"master_room_discount_id":"342","master_room_id":"141","discount_type":"%","price":"1308.00","disocunted_price":"851.00","discount":"34.94","monthly_deduct":457.0152,"room_id":"1191","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"1191","room_code":"B01-001","retail_price":"1308.0","discounted_price":851,"location_id":"5"}],"roughly_size":"20","total_retail_price":1308,"total_discounted_price":1021,"deposit":2616,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":14056,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"812.00","warehousing_date":"2020-08-01","rent_from":"2020-08-01","rent_to":"2021-07-31","delivery_service":"0","remark":"12 months contract. Special offer 5% \"rent now\" discount and $200 \"Come to Us\"discount. Storage rental and deposit paid by post-dated cheque on July 24, 2020. ","paymethod":"CHEQUE","bank_name":"","cheque_num":"","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":812,"order_total":14928,"final_order_total":14116,"location_id":"5","branch_id":"2","company_id":"1","room_key":"'0012491561","order_product":[{"product_id":"11","product_name":"\u667a\u80fd\u9580\u5361","qty":"1","price":"60.0"}],"pass":true}},"roughly_size":"20","total_discounted_price":"1021.00","deposit":"2616.00","total_retail_price":"1308.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","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":["C201687","PERSONAL","Mr","1WrfPGJo2sgwjLx59rm4h4pqn7kv5JEJ9P6sZ9vSE28=","ddrfzAYTmkL\/QNu3psjONQ==","","BsVq7M4UkufP9ajSZbaCUQ==","NZQ8O+ZytfM4kWH7QKqVZRZymPzzxvUbDE\/29iW1rY0=","W0lITIwB8owccDxCd0iR2etoJcjmaKb8l7Z\/fY2R6rqjebGTXICovQaTVNiWb2nbVd15DxtkPlxKETOcOYlivsoRR7dNN8CflOKg4Y3yNb931TrWaCpoO+6WB+6IjP02","ub1HgB7cQQau46CvPMxIFg==",null,"NZQ8O+ZytfM4kWH7QKqVZRZymPzzxvUbDE\/29iW1rY0=","7zOaI+IvrTFME6LokMLXBQ==","2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","2","5",1687,"NEW","B01-CT208459",1308,1021,2616,0,"12","12",14056,14928,14116,"2020-07-24 18:16:19","0",null,null,null,"2020-08-01","2021-07-31","12 months contract. Special offer 5% \"rent now\" discount and $200 \"Come to Us\"discount. Storage rental and deposit paid by post-dated cheque on July 24, 2020. ","2020-08-01","20",0,null,812,"812.00","2","2020-07-24 18:16:17","2","2020-07-24 18:16:17","CHEQUE","","","","CHEQUE","","","",null,0,"'0012491561","C201687","PERSONAL","Mr","1WrfPGJo2sgwjLx59rm4h4pqn7kv5JEJ9P6sZ9vSE28=","ddrfzAYTmkL\/QNu3psjONQ==","","W0lITIwB8owccDxCd0iR2etoJcjmaKb8l7Z\/fY2R6rqjebGTXICovQaTVNiWb2nbVd15DxtkPlxKETOcOYlivsoRR7dNN8CflOKg4Y3yNb931TrWaCpoO+6WB+6IjP02","BsVq7M4UkufP9ajSZbaCUQ==","NZQ8O+ZytfM4kWH7QKqVZRZymPzzxvUbDE\/29iW1rY0=","ub1HgB7cQQau46CvPMxIFg==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","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":["8459","342","141","1191","%","34.94",457.0152,"2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_product` set `order_id` = ?, `customer_id` = ?, `product_id` = ?, `qty` = ?, `price` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459",1687,"11","1","60.0",60,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update `order` set total_order_product = ? where id = ?","parameters":[60,"8459"]},"data_before":[],"data_after":[],"step":4} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8459","1191","1308.0",851,"2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-01","2021-07-31","1191"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-24 18:16:19","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":["8459","B01-D205563","PAID",2616,0,"2021-07-31","2020-07-24 18:16:17","2020-07-24 18:16:17","2","2020-07-24 18:16:17","2","2020-07-24 18:16:17",1687]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8459",1687,"SETTLED","B01-I208788","2020-07-24 18:16:17","2020-08-01","2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,209,"MO","1",209,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",2,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",3,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",4,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",5,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",6,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",7,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",8,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",9,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",10,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",11,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","RENT","\u9810\u7e73\u79df\u91d1",12,1021,"MO","1",1021,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `order_dtl_id` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8788","ORDER_PRODUCT","60.0","PCS","1",60,"11","2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11500,0,"8788"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1687,"CHEQUE","","","","CHEQUE","","","","PAID","P208431","2020-07-24 18:16:17",14116,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8431","DEPOSIT","5563","PAID","2020-07-24 18:16:17",2616,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-24 18:16:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8431","INVOICE","8788","PAID","2020-07-24 18:16:17",11500,"2","2020-07-24 18:16:17","2","2020-07-24 18:16:17"]},"data_before":[],"data_after":[],"step":1} *****