{"created_at":"2019-12-23 10:31:07","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1415,"customer_code":"C191415","identity_type":"PERSONAL","identity_id":"Z130159(5)","title":"Mr","lastname":"Cheung","firstname":"Hiu Kan","companyname":"","email":null,"tel":"66320474","address":"FLT 3223, TUNG PING HSE, LEI TUNG EST, AP LEI CHAU, H.K.","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"775.0","renew_rent_month":"1","renew_warehousing_date":"2019-11-11","renew_room_key":"190,39669","renew_remark":"1 month contract. Special offer $500 coupon. Storage rental and deposit paid by cash on October 11, 2019. Smartcard paid on October 11, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196119, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1550.0","renew_master_room_id":"2","order_discount":[],"order_room":[{"room_id":"360","room_code":"G01","retail_price":"814.0","discounted_price":"814.00","location_id":"1"}],"roughly_size":"9","total_retail_price":814,"total_discounted_price":775,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":1550,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-11","rent_from":"2019-11-11","rent_to":"2020-01-10","delivery_service":"0","remark":"2 month contract. Storage rental paid by cash on December 23, 2019. Storage deposit $1550 transferred from agreement A12-CT196119 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":1550,"final_order_total":1550,"location_id":"1","branch_id":"1","company_id":"1","room_key":"190,39669","order_product":[],"pass":true}},"first_order_id":6119,"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>
G01 <\/td>\r\n\t\t\t\t\t	3X3X8 <\/td>\r\n\t\t\t\t\t	$814.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"9","total_discounted_price":"775.00","deposit":"0.00","total_retail_price":"814.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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","1","1",1415,"NEW","A12-CT196760",814,775,0,0,"2","2",1550,1550,1550,"2019-12-23 10:31:08","0",null,null,null,"2019-11-11","2020-01-10","2 month contract. Storage rental paid by cash on December 23, 2019. Storage deposit $1550 transferred from agreement A12-CT196119 to this agreement. ","2019-11-11","9",0,null,0,"0","2","2019-12-23 10:31:07","2","2019-12-23 10:31:07","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"190,39669","C191415","PERSONAL","Mr","MBVGD1z\/5+ulK7qC7WU9qA==","vCxOlXQuvOQaoL822H2o\/Q==","","y5zdgwMtjgYho16fug9uDqHmCP7\/mKnFl5rZhfGXIy8dGrDlwPO+bHx0RQj6UUXcaLVEv0V41tskv4g0XWD4EA==","mOFb6or1GPMXOxAIZsqelg==",null,"12tx8J6WUF2ErnADrFLsXA==",null,1,6119]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["6760","360","814.0","814.00","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["2019-11-11","2020-01-10","360"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 10:31: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":["6760",1415,"SETTLED","A12-I197088","2019-12-23 10:31:07","2019-11-11","2","2019-12-23 10:31:07","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["7088","RENT","\u9810\u7e73\u79df\u91d1",1,775,"MO","1",775,"2","2019-12-23 10:31:07","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["7088","RENT","\u9810\u7e73\u79df\u91d1",2,775,"MO","1",775,"2","2019-12-23 10:31:07","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31:08","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1550,0,"7088"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 10:31: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":[1415,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196738","2019-12-23 10:31:07",1550,"2","2019-12-23 10:31:07","2","2019-12-23 10:31:07","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["6738","DEPOSIT",null,"PAID","2019-12-23 10:31:07",0,"2","2019-12-23 10:31:07","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 10:31: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":["6738","INVOICE","7088","PAID","2019-12-23 10:31:07",1550,"2","2019-12-23 10:31:07","2","2019-12-23 10:31:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17:19","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":335,"customer_code":"C170335","identity_type":"BUSINESS","identity_id":"CP\/LIC\/SO\/19\/28860","title":"Mr","lastname":"Lo","firstname":"Tat Chuen","companyname":"ISLAND LAWN BOWLS CLUB","email":"ilbc2003@yahoo.com.hk","tel":"92155893","address":"Flat C, 10\/F, NEICH TOWER, 123 GLOUCESTER ROAD, WANCHAI, HONG KONG","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"12","renew_warehousing_date":"2019-12-18","renew_room_key":"056,07128,076,29312,190,62117","renew_remark":"12 months contract. Storage rental paid by CHEQUE on December 11, 2018. Storage deposit transferred from agreement SD14-CT182333 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT183873, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"733","room_code":"O09","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":899,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":10788,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-18","rent_from":"2019-12-18","rent_to":"2020-12-17","delivery_service":"0","remark":"12 months contract. Special offer $300 Maxim's Coupon. Storage rental paid by CHEQUE on December 23, 2019. Storage deposit transferred from agreement A14-CT183873 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":10788,"final_order_total":10788,"location_id":"2","branch_id":"1","company_id":"1","room_key":"056,07128,076,29312,190,62117","order_product":[],"pass":true}},"first_order_id":3873,"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> O09 <\/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":"899.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",335,"NEW","A14-CT196761",998,899,0,0,"12","12",10788,10788,10788,"2019-12-23 11:17:19","0",null,null,null,"2019-12-18","2020-12-17","12 months contract. Special offer $300 Maxim's Coupon. Storage rental paid by CHEQUE on December 23, 2019. Storage deposit transferred from agreement A14-CT183873 to this agreement.","2019-12-18","12",0,null,0,"0","2","2019-12-23 11:17:19","2","2019-12-23 11:17:19","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"056,07128,076,29312,190,62117","C170335","BUSINESS","Mr","hvBOBa4QbqkT\/az4ZwtriQ==","4w4biS+jM\/Q3DAzxHdf3pA==","ISLAND LAWN BOWLS CLUB","PHCNoz7QVEgiGpzAPlGU7IuXZBoHXkk0PqpECSm4pudwsKxfGlyIqkM5xhad7X\/PQzdQB8jVK4h9YnoG6GEdPMkQsrV0DIsLo7fMT7FF8Ho=","8kHMx2gHjIUenzARACBWeg==","RjRzp9GluvGxtO4QUqfIbFv4cRRLjnSNMzlctceCCNs=",null,"T4d96P4H0waNRGM5d2SskopONi3K1WcAAsQFCzExkRU=",1,3873]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["6761","733","998.0","998.00","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["2019-12-18","2020-12-17","733"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 11:17: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":["6761",335,"SETTLED","A14-I197089","2019-12-23 11:17:19","2019-12-18","2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",1,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",2,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",3,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",4,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",5,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",6,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",7,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",8,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",9,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",10,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",11,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["7089","RENT","\u9810\u7e73\u79df\u91d1",12,899,"MO","1",899,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[10788,0,"7089"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 11:17: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":[335,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196739","2019-12-23 11:17:19",10788,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["6739","DEPOSIT",null,"PAID","2019-12-23 11:17:19",0,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:17: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":["6739","INVOICE","7089","PAID","2019-12-23 11:17:19",10788,"2","2019-12-23 11:17:19","2","2019-12-23 11:17:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:25:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 11:42:38","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:15:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:41:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=5&filter2=2019-10-29&filter3=2019-12-19&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":654,"customer_code":"C170654","identity_type":"PERSONAL","identity_id":"D262052(A)","title":"Ms","lastname":"Leung ","firstname":"Lai Sim ","companyname":"","email":"alex1719971122@gmail.com","tel":"93682369","address":"Flat 5, 6\/F, Block D, 14 Nam Ning Street, Aberdeen Centre, Hong Kong ","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"981.0","renew_rent_month":"6","renew_warehousing_date":"2020-12-29","renew_room_key":"055,21009","renew_remark":"6 months contract. Storage rental paid by cash on June 25, 2019. Storage deposit transferred from agreement A18-CT183950 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT195319, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"77","order_discount":[],"order_room":[{"room_id":"883","room_code":"Y12","retail_price":"1090.0","discounted_price":"1090.00","location_id":"3"}],"roughly_size":"12","total_retail_price":1090,"total_discounted_price":981,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":5886,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-12-29","rent_from":"2020-12-29","rent_to":"2021-06-28","delivery_service":"0","remark":"6 months contract. Storage rental paid by cash on December 23, 2019. Storage deposit transferred from agreement A18-CT195319 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":5886,"final_order_total":5886,"location_id":"3","branch_id":"1","company_id":"1","room_key":"055,21009","order_product":[],"pass":true}},"first_order_id":"3950","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> Y12 <\/td>\r\n\t\t\t\t\t 3X4X7 <\/td>\r\n\t\t\t\t\t $1090.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":"12","total_discounted_price":"981.0","deposit":"0","total_retail_price":"1090.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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",654,"NEW","A18-CT196762",1090,981,0,0,"6","6",5886,5886,5886,"2019-12-23 12:42:42","0",null,null,null,"2020-12-29","2021-06-28","6 months contract. Storage rental paid by cash on December 23, 2019. Storage deposit transferred from agreement A18-CT195319 to this agreement.","2020-12-29","12",0,null,0,"0","2","2019-12-23 12:42:42","2","2019-12-23 12:42:42","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"055,21009","C170654","PERSONAL","Ms","MOSClpJj5as3RXhHins3wg==","EU9enA5\/vY58OMUDrd7sSw==","","qBXHZDuwONF14CIqfr9zbQPYC39nysRRkIt4yBySAMUGParaYTbGDzvL6giYK11DpktuED8YkBToD2SavAVqZHCydarpCc0X+VXP5DURZYs=","8qSLYTaCdkRF13xkgzofBA==","mMRoKN7dyNkD5422RLIjB4FKUkcoCNWqh6oCUMj6TRc=","GZdnwyBg7e5cmXI4vLzh3w==",null,1,"3950"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["6762","883","1090.0","1090.00","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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-12-29","2021-06-28","883"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 12:42:42","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":["6762",654,"SETTLED","A18-I197090","2019-12-23 12:42:42","2020-12-29","2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",1,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",2,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",3,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",4,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",5,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["7090","RENT","\u9810\u7e73\u79df\u91d1",6,981,"MO","1",981,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5886,0,"7090"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 12:42:42","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":[654,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P196740","2019-12-23 12:42:42",5886,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["6740","DEPOSIT",null,"PAID","2019-12-23 12:42:42",0,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:42:42","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":["6740","INVOICE","7090","PAID","2019-12-23 12:42:42",5886,"2","2019-12-23 12:42:42","2","2019-12-23 12:42:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:43:23","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:49:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 12:53:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=5&filter2=2019-10-29&filter3=2019-12-19&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":485,"customer_code":"C170485","identity_type":"BUSINESS","identity_id":"05770131","title":"Mr","lastname":"Cheung","firstname":"Tsun Hin Nicholas","companyname":"Hong Kong Ten Pin Bowling Congress Ltd","email":"hktbc@netvigator.com","tel":"28919786","address":"Rm 2004,Olympic House,1 Stadium Path,So Kon Po,Causeway Bay","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3792.0","renew_rent_month":"1","renew_warehousing_date":"2019-10-10","renew_room_key":"054,46461","renew_remark":"1 month contract. Storage rental paid by cheque on September 20, 2019. Storage deposit transferred from agreement A12-CT195798 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195993, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"194","room_code":"C70","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"193","room_code":"C69","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"183","room_code":"C59","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"},{"room_id":"182","room_code":"C58","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"64","total_retail_price":4392,"total_discounted_price":3792,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":7584,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-10-10","rent_from":"2019-10-10","rent_to":"2019-12-09","delivery_service":"0","remark":"2 months contract. Storage rental paid by cheque on December 23, 2019. Storage deposit transferred from agreement A12-CT195993 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":7584,"final_order_total":7584,"location_id":"1","branch_id":"1","company_id":"1","room_key":"054,46461","order_product":[],"pass":true}},"first_order_id":"4867","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C70 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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> C69 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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> C59 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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> C58 <\/td>\r\n\t\t\t\t\t 4X4X8 <\/td>\r\n\t\t\t\t\t $1098.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"64","total_discounted_price":"3792.00","deposit":"0.00","total_retail_price":"4392.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",485,"NEW","A12-CT196763",4392,3792,0,0,"2","2",7584,7584,7584,"2019-12-23 14:11:16","0",null,null,null,"2019-10-10","2019-12-09","2 months contract. Storage rental paid by cheque on December 23, 2019. Storage deposit transferred from agreement A12-CT195993 to this agreement.","2019-10-10","64",0,null,0,"0","2","2019-12-23 14:11:16","2","2019-12-23 14:11:16","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"054,46461","C170485","BUSINESS","Mr","qVM+uTcKf4Y9E8s+eih0BbUwgmcs8Dolhv8i5LsTMY4=","vCxOlXQuvOQaoL822H2o\/Q==","Hong Kong Ten Pin Bowling Congress Ltd","R44stv6Dyr9kiU5+jHXzVDEMmdwWNMFGMGD1lN3Z8BcE3\/gfhLYqETOPf5gC7n6eD58k\/jkIWG2yqeoObII72Q==","bk3wscMyfpIXu3yUbW0Avw==","BnxhYhAuTFtuOn0lnUjJwAs5l\/FZMq2vjXv1muEvLVM=",null,"Sd\/ri5Dfmc9LZnNS5Qw5OQ==",1,"4867"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["6763","194","1098.0","1098.00","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["2019-10-10","2019-12-09","194"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 14:11:16","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":["6763","193","1098.0","1098.00","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["2019-10-10","2019-12-09","193"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 14:11:16","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":["6763","183","1098.0","1098.00","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["2019-10-10","2019-12-09","183"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 14:11:16","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":["6763","182","1098.0","1098.00","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["2019-10-10","2019-12-09","182"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 14:11:16","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":["6763",485,"SETTLED","A12-I197091","2019-12-23 14:11:16","2019-10-10","2","2019-12-23 14:11:16","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["7091","RENT","\u9810\u7e73\u79df\u91d1",1,3792,"MO","1",3792,"2","2019-12-23 14:11:16","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["7091","RENT","\u9810\u7e73\u79df\u91d1",2,3792,"MO","1",3792,"2","2019-12-23 14:11:16","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[7584,0,"7091"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 14:11:16","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":[485,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P196741","2019-12-23 14:11:16",7584,"2","2019-12-23 14:11:16","2","2019-12-23 14:11:16","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["6741","DEPOSIT",null,"PAID","2019-12-23 14:11:16",0,"2","2019-12-23 14:11:16","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:11:16","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":["6741","INVOICE","7091","PAID","2019-12-23 14:11:16",7584,"2","2019-12-23 14:11:16","2","2019-12-23 14:11:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:32:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 14:36:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1272,"customer_code":"C191272","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2862.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-22","renew_room_key":"076,32309,076,34777","renew_remark":"6 months contract. Storage rental and deposit paid by bank transfer on May 23, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195065, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $6360.0","renew_master_room_id":"220","order_discount":[],"order_room":[{"room_id":"1641","room_code":"A16-150","retail_price":"3180.0","discounted_price":"3180.00","location_id":"7"}],"roughly_size":"42","total_retail_price":3180,"total_discounted_price":3180,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":6360,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-22","rent_from":"2019-11-22","rent_to":"2020-01-21","delivery_service":"0","remark":"2 months contact. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $6360 transferred from agreement A16-CT195065 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6360,"final_order_total":6360,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"first_order_id":5065,"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> A16-150 <\/td>\r\n\t\t\t\t\t 6X7X7 <\/td>\r\n\t\t\t\t\t $3180.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":"42","total_discounted_price":"3180.00","deposit":"0.00","total_retail_price":"3180.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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","7",1272,"NEW","A16-CT196764",3180,3180,0,0,"2","2",6360,6360,6360,"2019-12-23 15:37:07","0",null,null,null,"2019-11-22","2020-01-21","2 months contact. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $6360 transferred from agreement A16-CT195065 to this agreement. ","2019-11-22","42",0,null,0,"0","2","2019-12-23 15:37:06","2","2019-12-23 15:37:06","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null,1,5065]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["6764","1641","3180.0","3180.00","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["2019-11-22","2020-01-21","1641"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 15:37:07","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":["6764",1272,"SETTLED","A16-I197092","2019-12-23 15:37:06","2019-11-22","2","2019-12-23 15:37:06","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["7092","RENT","\u9810\u7e73\u79df\u91d1",1,3180,"MO","1",3180,"2","2019-12-23 15:37:06","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["7092","RENT","\u9810\u7e73\u79df\u91d1",2,3180,"MO","1",3180,"2","2019-12-23 15:37:06","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6360,0,"7092"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 15:37:07","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":[1272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196742","2019-12-23 15:37:06",6360,"2","2019-12-23 15:37:06","2","2019-12-23 15:37:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["6742","DEPOSIT",null,"PAID","2019-12-23 15:37:06",0,"2","2019-12-23 15:37:06","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 15:37:07","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":["6742","INVOICE","7092","PAID","2019-12-23 15:37:06",6360,"2","2019-12-23 15:37:06","2","2019-12-23 15:37:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:44","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":798,"customer_code":"C180798","identity_type":"PERSONAL","identity_id":"Z916749(9)","title":"Mr","lastname":"Lo","firstname":"Ka Chun","companyname":"","email":"loka0039@gmai.com","tel":"96670730","address":"Flat 3107, 31\/F, Tin Chak House, Tin Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-21","renew_room_key":"055,32980","renew_remark":"1 month contract. Storage rental paid by bank transfer on November 20, 2019. Storage deposit transferred from agreement A12-CT196190 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196457, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"279","room_code":"E06","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-21","rent_from":"2019-12-21","rent_to":"2020-01-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 22, 2019. Storage deposit transferred from agreement A12-CT196457 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,32980","order_product":[],"pass":true}},"first_order_id":"4789","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> E06 <\/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\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"1038.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",798,"NEW","A12-CT196765",998,1038,0,0,"1","1",1038,1038,1038,"2019-12-23 16:17:45","0",null,null,null,"2019-12-21","2020-01-20","1 month contract. Storage rental paid by bank transfer on December 22, 2019. Storage deposit transferred from agreement A12-CT196457 to this agreement.","2019-12-21","12",0,null,0,"0","2","2019-12-23 16:17:44","2","2019-12-23 16:17:44","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,32980","C180798","PERSONAL","Mr","51MA8AWBJt370WUqsUeCnw==","4w4biS+jM\/Q3DAzxHdf3pA==","","mMzQ1c7IXnG31el3pMn+cAlVmwOEO8RAHQZJFRSLNV\/SmYFvT5hQ\/KG4Is71QjPxXCoAkN9ubgFw5NXyRPui2oMB3Uo2T5sIHAA\/TnArqac=","iu3rJGYyixnPHEo1U9vPkA==","vSxCV4H9VfvlX9eKdpf+03ZOzigLaCc\/nH8UtdLNTfM=","L8wtX\/W+agotXtDfSAWTVA==",null,1,"4789"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6765","279","998.0","998.00","2","2019-12-23 16:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-21","2020-01-20","279"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6765",798,"SETTLED","A12-I197093","2019-12-23 16:17:44","2019-12-21","2","2019-12-23 16:17:44","2","2019-12-23 16:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7093","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2019-12-23 16:17:44","2","2019-12-23 16:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"7093"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[798,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196743","2019-12-23 16:17:44",1038,"2","2019-12-23 16:17:44","2","2019-12-23 16:17:44","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6743","DEPOSIT",null,"PAID","2019-12-23 16:17:44",0,"2","2019-12-23 16:17:44","2","2019-12-23 16:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:17:45","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6743","INVOICE","7093","PAID","2019-12-23 16:17:44",1038,"2","2019-12-23 16:17:44","2","2019-12-23 16:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1272,"customer_code":"C191272","identity_type":"PERSONAL","identity_id":"D037112(3)","title":"Mr","lastname":"Wen","firstname":"Kung Kit","companyname":"","email":"alanw@berkswick.com.hk","tel":"94841155","address":"8\/F, Jade House, 47C Stubbs Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"7170.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-22","renew_room_key":"076,32309,076,34777","renew_remark":"6 months contract. Storage rental and deposit paid by cheque on May 18, 2019. Smartcards provided on May 18, 2019.\\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT195001, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $15930.0","renew_master_room_id":"215","order_discount":[],"order_room":[{"room_id":"1640","room_code":"A16-149","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1639","room_code":"A16-148","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"},{"room_id":"1637","room_code":"A16-146","retail_price":"2655.0","discounted_price":"2655.00","location_id":"7"}],"roughly_size":"105","total_retail_price":7965,"total_discounted_price":7965,"deposit":0,"rent_month":"2","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"2","prepaid_amount":15930,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-22","rent_from":"2019-11-22","rent_to":"2020-01-21","delivery_service":"0","remark":"2 months deposit. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $15930 transferred from agreement A16-CT195001 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":15930,"final_order_total":15930,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,32309,076,34777","order_product":[],"pass":true}},"first_order_id":5001,"selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \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> A16-149 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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> A16-148 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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> A16-146 <\/td>\r\n\t\t\t\t\t 5X7X7 <\/td>\r\n\t\t\t\t\t $2655.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \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":"105","total_discounted_price":"7965.00","deposit":"0.00","total_retail_price":"7965.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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","7",1272,"NEW","A16-CT196766",7965,7965,0,0,"2","2",15930,15930,15930,"2019-12-23 16:24:48","0",null,null,null,"2019-11-22","2020-01-21","2 months deposit. Storage rental paid by bank transfer on November 29, 2019. Storage deposit $15930 transferred from agreement A16-CT195001 to this agreement. ","2019-11-22","105",0,null,0,"0","2","2019-12-23 16:24:48","2","2019-12-23 16:24:48","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,32309,076,34777","C191272","PERSONAL","Mr","5yHI1OrI3jP1fHk6WMQJzQ==","p4JywTf1\/0TJX08VPtGmtA==","","auQltLH+RaRzeqbXMpVO9q3a8pWRYuoNR711jhONrrJgy8Hl3NzJwzVu2+7bgGOw","FIJj6HVSEufhFOUGXjlfgA==","wPVw2D2eb7Y+t\/KyTQ8Kw8rTyyU2\/csMiv1Qy+fvDVA=","83nBRHGiDiwO\/0E4dwcPKQ==",null,1,5001]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["6766","1640","2655.0","2655.00","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["2019-11-22","2020-01-21","1640"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:24:48","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":["6766","1639","2655.0","2655.00","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["2019-11-22","2020-01-21","1639"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:24:48","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":["6766","1637","2655.0","2655.00","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["2019-11-22","2020-01-21","1637"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:24:48","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":["6766",1272,"SETTLED","A16-I197094","2019-12-23 16:24:48","2019-11-22","2","2019-12-23 16:24:48","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["7094","RENT","\u9810\u7e73\u79df\u91d1",1,7965,"MO","1",7965,"2","2019-12-23 16:24:48","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["7094","RENT","\u9810\u7e73\u79df\u91d1",2,7965,"MO","1",7965,"2","2019-12-23 16:24:48","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[15930,0,"7094"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 16:24:48","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":[1272,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196744","2019-12-23 16:24:48",15930,"2","2019-12-23 16:24:48","2","2019-12-23 16:24:48","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["6744","DEPOSIT",null,"PAID","2019-12-23 16:24:48",0,"2","2019-12-23 16:24:48","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:24:48","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":["6744","INVOICE","7094","PAID","2019-12-23 16:24:48",15930,"2","2019-12-23 16:24:48","2","2019-12-23 16:24:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&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":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1057,"customer_code":"C181057","identity_type":"PERSONAL","identity_id":"D308847(3)","title":"Ms","lastname":"Lam ","firstname":"Shun Wai, Annie","companyname":"","email":"annielam2009@gmail.com","tel":"96813840","address":"Flat 5, 4\/F, Kong Fu Court, Aberdeen Centre, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4106.0","renew_rent_month":"3","renew_warehousing_date":"2019-11-16","renew_room_key":"0006005603","renew_remark":"3 months contract. Storage rental paid by Bank Transfer on September 4, 2019. Storage deposit transferred from agreement A05-CT195050 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT195884, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"118","order_discount":[{"master_room_discount_id":"258","master_room_id":"118","discount_type":"%","price":"2161.00","disocunted_price":"2053.00","discount":"5.00","monthly_deduct":108.05,"room_id":"1156","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"258","master_room_id":"118","discount_type":"%","price":"2161.00","disocunted_price":"2053.00","discount":"5.00","monthly_deduct":108.05,"room_id":"1155","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1156","room_code":"A05-154","retail_price":"2161.0","discounted_price":2053,"location_id":"4"},{"room_id":"1155","room_code":"A05-153","retail_price":"2161.0","discounted_price":2053,"location_id":"4"}],"roughly_size":"56","total_retail_price":4322,"total_discounted_price":4106,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":12318,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-16","rent_from":"2019-11-16","rent_to":"2020-02-15","delivery_service":"0","remark":"3 months contract. Storage rental paid by Bank Transfer on December 22, 2019. Storage deposit transferred from agreement A05-CT195884 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":12318,"final_order_total":12318,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0006005603","order_product":[],"pass":true}},"first_order_id":"3553","selected_room_tr":" \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> A05-154 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> A05-153 <\/td>\r\n\t\t\t\t\t 4X7X7 <\/td>\r\n\t\t\t\t\t $2161.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"56","total_discounted_price":"4106.0","deposit":"0","total_retail_price":"4322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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","4",1057,"NEW","A05-CT196767",4322,4106,0,0,"3","3",12318,12318,12318,"2019-12-23 16:36:55","0",null,null,null,"2019-11-16","2020-02-15","3 months contract. Storage rental paid by Bank Transfer on December 22, 2019. Storage deposit transferred from agreement A05-CT195884 to this agreement.","2019-11-16","56",0,null,0,"0","2","2019-12-23 16:36:55","2","2019-12-23 16:36:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0006005603","C181057","PERSONAL","Ms","1j\/EaXCwy81\/xtzbEcCIFg==","QW3H3bgt0C82y0s8QGTa0Q==","","f1Otee2exetSDY63KBCMB5p99mgzhZTcsXOUKcOm9HaGtL064AfZdfe5l6eIALO\/p8OTtANqNTg0DUdmmdQX\/I8owGh\/TPajPJqQ7N4t7i4=","g0N0c22b7twgi3MLXRIFsA==","M7r\/KEoRB4HilLKSFse6TNWqfcF7SJDkKhW++\/2WmZg=","TkzecISdNbJR\/TrRV20KnA==",null,1,"3553"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["6767","258","118","1156","%","5.00",108.05,"2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["6767","258","118","1155","%","5.00",108.05,"2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["6767","1156","2161.0",2053,"2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["2019-11-16","2020-02-15","1156"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:36:55","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":["6767","1155","2161.0",2053,"2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["2019-11-16","2020-02-15","1155"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:36:55","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":["6767",1057,"SETTLED","A05-I197095","2019-12-23 16:36:55","2019-11-16","2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["7095","RENT","\u9810\u7e73\u79df\u91d1",1,4106,"MO","1",4106,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["7095","RENT","\u9810\u7e73\u79df\u91d1",2,4106,"MO","1",4106,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["7095","RENT","\u9810\u7e73\u79df\u91d1",3,4106,"MO","1",4106,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[12318,0,"7095"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 16:36:55","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":[1057,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196745","2019-12-23 16:36:55",12318,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["6745","DEPOSIT",null,"PAID","2019-12-23 16:36:55",0,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:36:55","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":["6745","INVOICE","7095","PAID","2019-12-23 16:36:55",12318,"2","2019-12-23 16:36:55","2","2019-12-23 16:36:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:20","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":352,"customer_code":"C170352","identity_type":"PERSONAL","identity_id":"D191319(1)","title":"Mr","lastname":"Wong","firstname":"Wai Tung","companyname":"","email":null,"tel":"93328739","address":"\u9999\u6e2f\u4ed4\u7530\u7063\u6f01\u7372\u88571B\u5730\u4e0b","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1286.0","renew_rent_month":"1","renew_warehousing_date":"2019-12-19","renew_room_key":"137,15409","renew_remark":"1 month contract. Storage rental paid by bank transfer on Nov 19, 2019. Storage deposit transferred from agreement A12-CT196180 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196445, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"363","room_code":"G04","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1286,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1286,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-12-19","rent_from":"2019-12-19","rent_to":"2020-01-18","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196445 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1286,"final_order_total":1286,"location_id":"1","branch_id":"1","company_id":"1","room_key":"137,15409","order_product":[],"pass":true}},"first_order_id":"4204","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> G04 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\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":"20","total_discounted_price":"1286.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",352,"NEW","A12-CT196768",1528,1286,0,0,"1","1",1286,1286,1286,"2019-12-23 16:40:21","0",null,null,null,"2019-12-19","2020-01-18","1 month contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A12-CT196445 to this agreement.\r\n","2019-12-19","20",0,null,0,"0","2","2019-12-23 16:40:20","2","2019-12-23 16:40:20","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"137,15409","C170352","PERSONAL","Mr","pWrJOV90xuuT\/EsMi5zpRQ==","hULSwM2MvFtpeV9\/z+er8Q==","","43c0wx7jnHnQaf25o1D24omsNW+NEZgIX2w74kCKE40OIxx1GWQaur5hnqjVXQj2","H2VJhOiErpJD6+CKFX26Dg==",null,"XHOvAEI8sL85yYAiFwYkGw==",null,1,"4204"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["6768","363","1528.0","1528.00","2","2019-12-23 16:40:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2019-12-19","2020-01-18","363"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6768",352,"SETTLED","A12-I197096","2019-12-23 16:40:20","2019-12-19","2","2019-12-23 16:40:20","2","2019-12-23 16:40:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7096","RENT","\u9810\u7e73\u79df\u91d1",1,1286,"MO","1",1286,"2","2019-12-23 16:40:20","2","2019-12-23 16:40:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1286,0,"7096"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[352,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196746","2019-12-23 16:40:20",1286,"2","2019-12-23 16:40:20","2","2019-12-23 16:40:20","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6746","DEPOSIT",null,"PAID","2019-12-23 16:40:20",0,"2","2019-12-23 16:40:20","2","2019-12-23 16:40:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 16:40:21","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["6746","INVOICE","7096","PAID","2019-12-23 16:40:20",1286,"2","2019-12-23 16:40:20","2","2019-12-23 16:40:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:01:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":631,"customer_code":"C170631","identity_type":"PERSONAL","identity_id":"Z709965(8)","title":"Mr","lastname":"Li","firstname":"Suet Ying","companyname":"","email":"michelle_li215@yahoo.com.hk","tel":"63734583","address":"Flat 1, 7\/F, Block A, Ka Lung Court, No.33 Tin Wan Praya Road, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1376.0","renew_rent_month":"6","renew_warehousing_date":"2020-12-30","renew_room_key":"055,06051","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 27, 2019. Storage deposit transferred from agreement A14-CT183962 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195338, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"41","order_discount":[],"order_room":[{"room_id":"426","room_code":"J08","retail_price":"1250.0","discounted_price":"1250.00","location_id":"2"}],"roughly_size":"20","total_retail_price":1250,"total_discounted_price":1376,"deposit":0,"rent_month":"13","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"13","prepaid_amount":16512,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"1376.00","warehousing_date":"2020-12-30","rent_from":"2020-12-30","rent_to":"2021-01-29","delivery_service":"0","remark":"13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A14-CT195338 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":1376,"order_total":17888,"final_order_total":16512,"location_id":"2","branch_id":"1","company_id":"1","room_key":"055,06051","order_product":[],"pass":true}},"first_order_id":"3962","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> J08 <\/td>\r\n\t\t\t\t\t 3.5X5X8 <\/td>\r\n\t\t\t\t\t $1250.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":"20","total_discounted_price":"1376.00","deposit":"0.00","total_retail_price":"1250.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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",631,"NEW","A14-CT196769",1250,1376,0,0,"13","13",16512,17888,16512,"2019-12-23 17:02:53","0",null,null,null,"2020-12-30","2021-01-29","13 months contract. Special offer the 13th month free. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A14-CT195338 to this agreement. ","2020-12-30","20",0,null,1376,"1376.00","2","2019-12-23 17:02:52","2","2019-12-23 17:02:52","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,06051","C170631","PERSONAL","Mr","T7WnBeMDd\/+h07cV6s1ICg==","7KCehmxbvwRMb+U8lHGoVA==","","JFBpfQn\/bOgduhtfPyJruSRXc78Cb9sxpNMqgy1Bz\/Iq7bMyfPKQjfrDLTL8Yxasu68IGcwR7LxfPTeYlYsjOudEIceYIWax2R9lvR5C+wc=","CZD4OOAOfqyWbL3tTmSeig==","Tc+lHQ5UlQPkefojlzkH3pjr\/sKw+vTBF9jod+WnJ0A=","eXRl4fC0aoYnxqfas9M4Ow==",null,1,"3962"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["6769","426","1250.0","1250.00","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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-12-30","2021-01-29","426"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 17:02:53","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":["6769",631,"SETTLED","A14-I197097","2019-12-23 17:02:52","2020-12-30","2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",3,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",4,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",5,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",6,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",7,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",8,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",9,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",10,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",11,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",12,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["7097","RENT","\u9810\u7e73\u79df\u91d1",13,1376,"MO","1",1376,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16512,0,"7097"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 17:02:53","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":[631,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196747","2019-12-23 17:02:52",16512,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["6747","DEPOSIT",null,"PAID","2019-12-23 17:02:52",0,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:02:53","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":["6747","INVOICE","7097","PAID","2019-12-23 17:02:52",16512,"2","2019-12-23 17:02:52","2","2019-12-23 17:02:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:03:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06:05","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=456&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1574","master_room_id":"203","room_code":"A16-083"}],"_payment_type":"INVOICE","loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":429,"customer_code":"C170429","identity_type":"PERSONAL","identity_id":"D701200(A)","title":"Ms","lastname":"Lau","firstname":"Ching Yee Camilla","companyname":"","email":null,"tel":"54028235","address":"Flat 7, 21\/F, Yee Hong House, Hong Wah Court, 2 Lin Tak Road, Lam Tin, Kowloon","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"6","renew_warehousing_date":"2019-11-12","renew_room_key":"133,31933","renew_remark":"6 months contract. Storage rental paid by bank transfer on June 3, 2019. Storage deposit transferred from agreement A14-CT184007 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT195162, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[{"master_room_discount_id":"470","master_room_id":"34","discount_type":"%","price":"998.00","disocunted_price":"949.00","discount":"4.91","monthly_deduct":49.0018,"room_id":"748","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"748","room_code":"O24","retail_price":"998.0","discounted_price":949,"location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":949,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":2847,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2019-11-12","rent_from":"2019-11-12","rent_to":"2020-02-11","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A14-CT195162 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2847,"final_order_total":2847,"location_id":"2","branch_id":"1","company_id":"1","room_key":"133,31933","order_product":[],"pass":true}},"first_order_id":"4007","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> O24 <\/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":"949.00","deposit":"0.00","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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",429,"NEW","A14-CT196770",998,949,0,0,"3","3",2847,2847,2847,"2019-12-23 17:06:05","0",null,null,null,"2019-11-12","2020-02-11","3 months contract. Storage rental paid by bank transfer on December 23, 2019. Storage deposit transferred from agreement A14-CT195162 to this agreement.","2019-11-12","12",0,null,0,"0","2","2019-12-23 17:06:05","2","2019-12-23 17:06:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,31933","C170429","PERSONAL","Ms","yq94NVeoeX9jcQoo5V+k7uIokK796dSEWe+sS0IW50Y=","oe4emdjBwqJ3qUpOcI17hw==","","DM7yxTtohyGTbGNePDGNakub+skxtq4\/+vS0JwykSd6Ts34VhrLbPhIsq2UNAmboV2LG\/ir1iGELd4rhVc+XHjwq1eNzCYa\/skfwZPq62FA=","9k1gV3KPXFWWMUITVh8EIg==",null,"aP+LOVIwBPQQ+i8sD3+I+g==",null,1,"4007"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06:05","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":["6770","470","34","748","%","4.91",49.0018,"2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["6770","748","998.0",949,"2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["2019-11-12","2020-02-11","748"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2019-12-23 17:06: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":["6770",429,"SETTLED","A14-I197098","2019-12-23 17:06:05","2019-11-12","2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["7098","RENT","\u9810\u7e73\u79df\u91d1",1,949,"MO","1",949,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["7098","RENT","\u9810\u7e73\u79df\u91d1",2,949,"MO","1",949,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["7098","RENT","\u9810\u7e73\u79df\u91d1",3,949,"MO","1",949,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06:05","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2847,0,"7098"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2019-12-23 17:06: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":[429,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P196748","2019-12-23 17:06:05",2847,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["6748","DEPOSIT",null,"PAID","2019-12-23 17:06:05",0,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 17:06: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":["6748","INVOICE","7098","PAID","2019-12-23 17:06:05",2847,"2","2019-12-23 17:06:05","2","2019-12-23 17:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 18:55:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2019-12-23 18:56:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****