\r\n\t\t\t\t\tL49 4X4X8 $1098.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\tL48 4X4X8 $1098.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","index_url_parameter":"","roughly_size":"32","total_discounted_price":"1887.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",422,"NEW","A14-CT207470",2196,1887,0,0,"3","3",5661,5661,5661,"2020-03-23 11:08:20","0",null,null,null,"2020-03-06","2020-06-05","3 months contract. Storage rental paid by bank transfer on Mar 20, 2020. Storage deposit transferred from agreement A14-CT206918 to this agreement.","2020-03-06","32",0,null,0,"0","2","2020-03-23 11:08:20","2","2020-03-23 11:08:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60331,054,46800","C170422","PERSONAL","Ms","xYi2pwRevSHfV5czTkolJ7KAgbpNCBYwTee28I\/M54o=","AmePxSuzgSRLGutACC9bnA==","","FJ9ZDY8\/7kA8A+te5iy9YqoyRYpOU3Bmu0epfxVEGBZDwhm\/CmuQLqsktSokLLwP","8XqrRRnMV+GmztFyZOdQwA==","PLmzzbYEBFtGoiJmp\/XL7iWspjMaTej8bBZte\/60rbY=","NE7TBy05SBIIdbS3hOb6DQ==",null,1,"4885"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08:20","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":["7470","434","35","570","%","4.97",54.5706,"2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08:20","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":["7470","434","35","571","%","4.97",54.5706,"2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7470","571","1098.0",1043.4,"2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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-03-06","2020-06-05","571"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 11:08: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":["7470","570","1098.0",1043.4,"2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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-03-06","2020-06-05","570"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 11:08: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":["7470",422,"SETTLED","A14-I207798","2020-03-23 11:08:20","2020-03-06","2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7798","RENT","\u9810\u7e73\u79df\u91d1",1,1887,"MO","1",1887,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7798","RENT","\u9810\u7e73\u79df\u91d1",2,1887,"MO","1",1887,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7798","RENT","\u9810\u7e73\u79df\u91d1",3,1887,"MO","1",1887,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08:20","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5661,0,"7798"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-23 11:08: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":[422,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207446","2020-03-23 11:08:20",5661,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7446","DEPOSIT",null,"PAID","2020-03-23 11:08:20",0,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 11:08: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":["7446","INVOICE","7798","PAID","2020-03-23 11:08:20",5661,"2","2020-03-23 11:08:20","2","2020-03-23 11:08:20"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 14:50:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","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&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"458","master_room_id":"38","room_code":"J40"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1470,"customer_code":"C191470","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":null,"tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"7306.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-16","renew_room_key":"190,38711","renew_remark":"1 month contract. Storage rental of 14\/F office paid by cheque on Jan 13,2020. Deposit $14612 transferred from agreement to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206964, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"410","room_code":"I01","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":7306,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":14612,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-02-16","rent_from":"2020-02-16","rent_to":"2020-04-15","delivery_service":"0","remark":"2 month contract. Storage rental of 14\/F office paid by cheque on March 23,2020. Deposit $14612 transferred from agreement A14-CT206964 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":14612,"final_order_total":14612,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"first_order_id":"6727","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\tI01 4X3X8 $998.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":"12","total_discounted_price":"7306.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",1470,"NEW","A14-CT207471",998,7306,0,0,"2","2",14612,14612,14612,"2020-03-23 16:02:58","0",null,null,null,"2020-02-16","2020-04-15","2 month contract. Storage rental of 14\/F office paid by cheque on March 23,2020. Deposit $14612 transferred from agreement A14-CT206964 to this agreement.","2020-02-16","12",0,null,0,"0","2","2020-03-23 16:02:58","2","2020-03-23 16:02:58","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg==",1,"6727"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7471","410","998.0","998.00","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-02-16","2020-04-15","410"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7471",1470,"SETTLED","A14-I207799","2020-03-23 16:02:58","2020-02-16","2","2020-03-23 16:02:58","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7799","RENT","\u9810\u7e73\u79df\u91d1",1,7306,"MO","1",7306,"2","2020-03-23 16:02:58","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7799","RENT","\u9810\u7e73\u79df\u91d1",2,7306,"MO","1",7306,"2","2020-03-23 16:02:58","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[14612,0,"7799"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1470,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207447","2020-03-23 16:02:58",14612,"2","2020-03-23 16:02:58","2","2020-03-23 16:02:58","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7447","DEPOSIT",null,"PAID","2020-03-23 16:02:58",0,"2","2020-03-23 16:02:58","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:02:58","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7447","INVOICE","7799","PAID","2020-03-23 16:02:58",14612,"2","2020-03-23 16:02:58","2","2020-03-23 16:02:58"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"458","master_room_id":"38","room_code":"J40"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1470,"customer_code":"C191470","identity_type":"BUSINESS","identity_id":"1850482","title":"Mr","lastname":"LAU","firstname":"Kevin","companyname":"STAR LIGHT R & D LTD","email":null,"tel":"34711355","address":"5\/F Shing Dao Industrial Building 232 Aberdeen Main Road Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-02-13","renew_room_key":"190,38711","renew_remark":"1 month contract. Storage rental paid by cheque on Jan 13,2020. Deposit $1996 transferred from agreement A14-CT196726 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT206963, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"411","room_code":"I02","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-02-13","rent_from":"2020-02-13","rent_to":"2020-04-12","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on March 23, 2020. Deposit $1996 transferred from agreement A14-CT206963 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":1996,"final_order_total":1996,"location_id":"2","branch_id":"1","company_id":"1","room_key":"190,38711","order_product":[],"pass":true}},"first_order_id":"6726","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\tI02 4X3X8 $998.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":"12","total_discounted_price":"998.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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","2",1470,"NEW","A14-CT207472",998,998,0,0,"2","2",1996,1996,1996,"2020-03-23 16:06:13","0",null,null,null,"2020-02-13","2020-04-12","2 months contract. Storage rental paid by cheque on March 23, 2020. Deposit $1996 transferred from agreement A14-CT206963 to this agreement.\r\n","2020-02-13","12",0,null,0,"0","2","2020-03-23 16:06:13","2","2020-03-23 16:06:13","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"190,38711","C191470","BUSINESS","Mr","Ya9A\/ywtlmJRIDhH4X4NUQ==","DQ14OHmVeYuzJuBkd+kFHg==","STAR LIGHT R & D LTD","RMk2HFaOIu\/0kDQ3httlkl+nHFgGwCElRnO8ppImjH9dsUITdobnSjeHnsPgiJryoZs+GAuWBjvP13vD90Vf+3FPtjDmCNz9Cr\/JxE\/6OFc=","jdhYGndgmFP0qhtFU\/MiJw==",null,null,"8oF8VHM1sampIinI0bkByg==",1,"6726"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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":["7472","411","998.0","998.00","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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-02-13","2020-04-12","411"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 16:06: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":["7472",1470,"SETTLED","A14-I207800","2020-03-23 16:06:13","2020-02-13","2","2020-03-23 16:06:13","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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":["7800","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-03-23 16:06:13","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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":["7800","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-03-23 16:06:13","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1996,0,"7800"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-23 16:06: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":[1470,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207448","2020-03-23 16:06:13",1996,"2","2020-03-23 16:06:13","2","2020-03-23 16:06:13","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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":["7448","DEPOSIT",null,"PAID","2020-03-23 16:06:13",0,"2","2020-03-23 16:06:13","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:06: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":["7448","INVOICE","7800","PAID","2020-03-23 16:06:13",1996,"2","2020-03-23 16:06:13","2","2020-03-23 16:06:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:21:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 16:38:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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=4801&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":713,"customer_code":"C180713","identity_type":"PERSONAL","identity_id":"C572643(1)","title":"Ms","lastname":"Kwan","firstname":"Yuet Ying","companyname":"","email":"vivianyykwan@gmail.com","tel":"90909699","address":"5B Honey Court, 88 Pokfulam Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"EPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4534.0","renew_rent_month":"6","renew_warehousing_date":"2020-01-17","renew_room_key":"054,12115","renew_remark":"6 months contract. Storage rental paid by EPS on August 30, 2019. Storage deposit transferred from agreement A18-CT194671 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195834, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"85","order_discount":[],"order_room":[{"room_id":"885","room_code":"Y14","retail_price":"2434.0","discounted_price":"2434.00","location_id":"3"},{"room_id":"884","room_code":"Y13","retail_price":"2434.0","discounted_price":"2434.00","location_id":"3"}],"roughly_size":"64","total_retail_price":4868,"total_discounted_price":4534,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":54408,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"4534.00","warehousing_date":"2020-01-17","rent_from":"2020-01-17","rent_to":"2021-02-16","delivery_service":"0","remark":"13 months contract. Storage rental paid by cheque on Mar 23,2020. Storage deposit transferred from agreement A18-CT195834 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":4534,"order_total":58942,"final_order_total":54408,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,12115","order_product":[],"pass":true}},"first_order_id":"4671","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\tY14 8X4X7 $2434.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\tY13 8X4X7 $2434.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":"64","total_discounted_price":"4534.00","deposit":"0.00","total_retail_price":"4868.00"}},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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",713,"NEW","A18-CT207473",4868,4534,0,0,"13","13",54408,58942,54408,"2020-03-23 17:23:44","0",null,null,null,"2020-01-17","2021-02-16","13 months contract. Storage rental paid by cheque on Mar 23,2020. Storage deposit transferred from agreement A18-CT195834 to this agreement.","2020-01-17","64",0,null,4534,"4534.00","2","2020-03-23 17:23:44","2","2020-03-23 17:23:44","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,12115","C180713","PERSONAL","Ms","58IhlrjFeQp8XTQfqZm0mQ==","iNwdG3Dj3OBaAQ6MRfBM1w==","","p0Af\/Y6AXAxEibMRfB1qrh9rXrg1\/GdZDJx+OsAs1QDET1mCkXNCbYe2A7WDWi9\/","bdO0rmK\/zuNCbJQMicVIaw==","qfec0qSC868QcikEpTPkCg8ehKMQx1UjTXfZmoY\/Muk=","mEQIFmhaNngVvo2qXiWw7w==",null,1,"4671"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7473","885","2434.0","2434.00","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2021-02-16","885"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 17:23:44","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":["7473","884","2434.0","2434.00","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-01-17","2021-02-16","884"]},"data_before":[],"data_after":[],"step":5}
*****
{"created_at":"2020-03-23 17:23:44","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":["7473",713,"SETTLED","A18-I207801","2020-03-23 17:23:44","2020-01-17","2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",3,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",4,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",5,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",6,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",7,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",8,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",9,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",10,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",11,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",12,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7801","RENT","\u9810\u7e73\u79df\u91d1",13,4534,"MO","1",4534,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[54408,0,"7801"]},"data_before":[],"data_after":[],"step":6}
*****
{"created_at":"2020-03-23 17:23:44","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":[713,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P207449","2020-03-23 17:23:44",54408,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44","ALL"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7449","DEPOSIT",null,"PAID","2020-03-23 17:23:44",0,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 17:23:44","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":["7449","INVOICE","7801","PAID","2020-03-23 17:23:44",54408,"2","2020-03-23 17:23:44","2","2020-03-23 17:23:44"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-03-23 18:18:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****