{"created_at":"2020-07-29 10:00:15","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:05:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:06:25","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:08:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:10:31","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:17:50","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:17:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:32:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:45:43","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:45:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=5535&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1189,"customer_code":"C191189","identity_type":"PERSONAL","identity_id":"K071791(6)","title":"Mr","lastname":"LEUNG","firstname":"Wing Sun","companyname":"","email":null,"tel":"94692446","address":"Rm 1005, Tung Cheong HSE, Lei Tung Estate, 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":"1043.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-01","renew_room_key":"087,62387","renew_remark":"3 months contract. Storage rental paid by cash on April 16, 2020. Storage deposit transferred from agreement A12-CT206978 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207641, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[{"master_room_discount_id":"433","master_room_id":"8","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"8","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"8","room_code":"A08","retail_price":"1098.0","discounted_price":1043.4,"location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1043,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3129,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-01","rent_from":"2020-06-01","rent_to":"2020-08-31","delivery_service":"0","remark":"3 months contract. Storage rental paid by cash on Jul 29, 2020. Storage deposit transferred from agreement A12-CT207641 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CASH","discount_deduct":0,"order_total":3129,"final_order_total":3129,"location_id":"1","branch_id":"1","company_id":"1","room_key":"087,62387","order_product":[],"pass":true}},"first_order_id":"4770","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>
A08 <\/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":"16","total_discounted_price":"1043.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",1189,"NEW","A12-CT208491",1098,1043,0,0,"3","3",3129,3129,3129,"2020-07-29 10:47:46","0",null,null,null,"2020-06-01","2020-08-31","3 months contract. Storage rental paid by cash on Jul 29, 2020. Storage deposit transferred from agreement A12-CT207641 to this agreement.","2020-06-01","16",0,null,0,"0","2","2020-07-29 10:47:45","2","2020-07-29 10:47:45","NO_NEED_PAID_RENEW","","","","CASH","","","",null,0,"087,62387","C191189","PERSONAL","Mr","EjsWd\/EiwjEkCIXHJjBD5Q==","yXKc2lCF323ApRADrjNaSg==","","xKLuiq\/VjqZXfN2hMI3Sb2oU1J125te0UL6koWQvbLUOxLwDFI4X0601DYDHPBf1\/4zd2nKH+Kw+fNjwu5qwNQ==","O2uJzrdPT3sfj2Ey0Pw2uQ==",null,"21WbSDJ2tQwDEgbOvdVyvg==",null,1,"4770"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","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":["8491","433","8","8","%","4.97",54.5706,"2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8491","8","1098.0",1043.4,"2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-08-31","8"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8491",1189,"SETTLED","A12-I208820","2020-07-29 10:47:45","2020-06-01","2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8820","RENT","\u9810\u7e73\u79df\u91d1",1,1043,"MO","1",1043,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8820","RENT","\u9810\u7e73\u79df\u91d1",2,1043,"MO","1",1043,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8820","RENT","\u9810\u7e73\u79df\u91d1",3,1043,"MO","1",1043,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3129,0,"8820"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1189,"NO_NEED_PAID_RENEW","","","","CASH","","","","PAID","P208463","2020-07-29 10:47:45",3129,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","DEPOSIT",null,"PAID","2020-07-29 10:47:45",0,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:47:46","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8463","INVOICE","8820","PAID","2020-07-29 10:47:45",3129,"2","2020-07-29 10:47:45","2","2020-07-29 10:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:40","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":704,"customer_code":"C180704","identity_type":"PERSONAL","identity_id":"R858722(0)","title":"Ms","lastname":"Lim","firstname":"Serene Hwee Hoon","companyname":"","email":"serene_n_zach@yahoo.com","tel":"65741293","address":"33 Tai Tam Road, 16K The Manhattan, HK","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":"13","renew_warehousing_date":"2020-08-09","renew_room_key":"052,45647","renew_remark":"13 months contract. Special renewal offer, one month free. Storage rental paid by bank transfer on June 14, 2019. Storage deposit transferred from agreement A12-CT194044 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195242, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"77","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1528.00","discount":"16.82","monthly_deduct":257.0096,"room_id":"49","is_final_discount":"0","payment_term":"PREPAID_12_MO"}],"order_room":[{"room_id":"49","room_code":"A49","retail_price":"1528.0","discounted_price":1271,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1376,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":16512,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-09","rent_from":"2020-08-09","rent_to":"2021-08-08","delivery_service":"0","remark":"12 months contract. Storage rental paid by bank transfer on Jul 29, 2020. Storage deposit transferred from agreement A12-CT195242 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":16512,"final_order_total":16512,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,45647","order_product":[],"pass":true}},"first_order_id":"4044","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> A49 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"20","total_discounted_price":"1376.00","deposit":"0.00","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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",704,"NEW","A12-CT208492",1528,1376,0,0,"12","12",16512,16512,16512,"2020-07-29 10:49:41","0",null,null,null,"2020-08-09","2021-08-08","12 months contract. Storage rental paid by bank transfer on Jul 29, 2020. Storage deposit transferred from agreement A12-CT195242 to this agreement.\r\n","2020-08-09","20",0,null,0,"0","2","2020-07-29 10:49:40","2","2020-07-29 10:49:40","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,45647","C180704","PERSONAL","Ms","eSjTTMAF25hTCHMOlqmIpsuNWH76+9PXOgIVLgQze8o=","WCEL8nEjkO0P1E7kTUoqkQ==","","ejxe4QQIrseV4inbvb58mHWFpxKSOvzW2TL8DtaHLYqD4QztOsh9QZ+oYmO8m\/6O","PPqggiKse5UaK+uVR\/8H+Q==","FlMvp+d+Z3nlxh02G8umgNbXcW2A+j+ad5DMfwi\/oYI=","Y1LKWz9rDETutsi7QN7IqA==",null,1,"4044"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8492","77","10","49","%","16.82",257.0096,"2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8492","49","1528.0",1271,"2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-09","2021-08-08","49"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 10:49:41","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":["8492",704,"SETTLED","A12-I208821","2020-07-29 10:49:40","2020-08-09","2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",1,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",2,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",3,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",4,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",5,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",6,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",7,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",8,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",9,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",10,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",11,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8821","RENT","\u9810\u7e73\u79df\u91d1",12,1376,"MO","1",1376,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[16512,0,"8821"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 10:49:41","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":[704,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208464","2020-07-29 10:49:40",16512,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8464","DEPOSIT",null,"PAID","2020-07-29 10:49:40",0,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:49:41","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":["8464","INVOICE","8821","PAID","2020-07-29 10:49:40",16512,"2","2020-07-29 10:49:40","2","2020-07-29 10:49:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 10:50:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:01:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:01:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:02:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:06:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:08:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:39","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=1271&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":373,"customer_code":"C170373","identity_type":"PERSONAL","identity_id":"A810524(6)","title":"Ms","lastname":"Tang","firstname":"Wai Fong","companyname":"","email":"tang222888@hotmail.com","tel":"92668877","address":"Flat A,13\/F,Kaning Mansion,Aberdeen,Hong Kong","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"3784.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-20","renew_room_key":"055,46666","renew_remark":"1 month contract. Storage rental paid by PPS on June 29, 2020. Storage deposit transferred from agreement A12-CT207921 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208335, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[],"order_room":[{"room_id":"409","room_code":"H19","retail_price":"1938.0","discounted_price":"1938.00","location_id":"1"},{"room_id":"86","room_code":"B34","retail_price":"1528.0","discounted_price":"1528.00","location_id":"1"}],"roughly_size":"62.5","total_retail_price":3466,"total_discounted_price":3784,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":3784,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-20","rent_from":"2020-06-20","rent_to":"2020-07-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit transferred from agreement A12-CT208335 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3784,"final_order_total":3784,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,46666","order_product":[],"pass":true}},"first_order_id":"4881","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> H19 <\/td>\r\n\t\t\t\t\t 5X8.5X8 <\/td>\r\n\t\t\t\t\t $1938.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr> B34 <\/td>\r\n\t\t\t\t\t 4X5X8 <\/td>\r\n\t\t\t\t\t $1528.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"62.5","total_discounted_price":"3784.0","deposit":"0","total_retail_price":"3466.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","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",373,"NEW","A12-CT208493",3466,3784,0,0,"1","1",3784,3784,3784,"2020-07-29 11:15:40","0",null,null,null,"2020-06-20","2020-07-19","1 month contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit transferred from agreement A12-CT208335 to this agreement.\r\n","2020-06-20","62.5",0,null,0,"0","2","2020-07-29 11:15:39","2","2020-07-29 11:15:39","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,46666","C170373","PERSONAL","Ms","nTGfHLdEIudAzJAvttiE\/g==","M7CfcmE2OSMlZOkNgaoDmQ==","","BXgfEt9fXMpUNvxC+2X229VwwYS6rNmHtxMS+n23vDnbhk3n3xs6q6u0V\/EvTko5","HCKjEGhRJ8yb3ZyyPfmQag==","jQ4ob3N7+u9PyWPiMEH+PWHdZ55bC9BctdRu99koSsw=","QQr8JjuTNOLQNSu7eSLB1g==",null,1,"4881"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","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":["8493","409","1938.0","1938.00","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-20","2020-07-19","409"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 11:15:40","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":["8493","86","1528.0","1528.00","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-20","2020-07-19","86"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 11:15:40","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":["8493",373,"SETTLED","A12-I208822","2020-07-29 11:15:39","2020-06-20","2","2020-07-29 11:15:39","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","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":["8822","RENT","\u9810\u7e73\u79df\u91d1",1,3784,"MO","1",3784,"2","2020-07-29 11:15:39","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3784,0,"8822"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 11:15:40","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":[373,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208465","2020-07-29 11:15:39",3784,"2","2020-07-29 11:15:39","2","2020-07-29 11:15:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","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":["8465","DEPOSIT",null,"PAID","2020-07-29 11:15:39",0,"2","2020-07-29 11:15:39","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:40","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":["8465","INVOICE","8822","PAID","2020-07-29 11:15:39",3784,"2","2020-07-29 11:15:39","2","2020-07-29 11:15:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:15:47","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:19:29","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:49","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=1271&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":462,"customer_code":"C170462","identity_type":"PERSONAL","identity_id":"K360799(2)","title":"Mr","lastname":"Yu","firstname":"Wing Ho Peter","companyname":"","email":"vr2xbl@gmail.com","tel":"92533969","address":"FLT F, 19\/F ,BLK 1, 18 Tsui Wan Street","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1047.0","renew_rent_month":"3","renew_warehousing_date":"2020-07-22","renew_room_key":"053,37485, 191, 05433","renew_remark":"3 months contract. Storage rental paid by PPS on April 20, 2020. Storage deposit transferred from agreement A14-CT207042 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207687, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"67","order_discount":[],"order_room":[{"room_id":"423","room_code":"J05(\u670d\u88dd\u5009)","retail_price":"1118.0","discounted_price":"1118.00","location_id":"2"}],"roughly_size":"12","total_retail_price":1118,"total_discounted_price":1047,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3141,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-22","rent_from":"2020-07-22","rent_to":"2020-10-21","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit transferred from agreement A14-CT207687 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":3141,"final_order_total":3141,"location_id":"2","branch_id":"1","company_id":"1","room_key":"053,37485, 191, 05433","order_product":[],"pass":true}},"first_order_id":"4340","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> J05(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $1118.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":"1047.0","deposit":"0","total_retail_price":"1118.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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",462,"NEW","A14-CT208494",1118,1047,0,0,"3","3",3141,3141,3141,"2020-07-29 11:21:50","0",null,null,null,"2020-07-22","2020-10-21","3 months contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit transferred from agreement A14-CT207687 to this agreement.\r\n","2020-07-22","12",0,null,0,"0","2","2020-07-29 11:21:49","2","2020-07-29 11:21:49","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,37485, 191, 05433","C170462","PERSONAL","Mr","BYjifWmIFNENpUI6KijenQ==","thtRZ5CDeQ9OOuodTdr1ng==","","qFxWg6ty8YLT5usnC5rQpcVGyK8fcSAy3kOPLYCQSTBkdbKDaAwWSCGhAyWML\/ob","wNgcXUnmZ0eJG8XwVZF25A==","Fj34QP5je0a2jhCIbIxvfq1qLloGSLgQk4pOCLZMes0=","NSx+wI1\/3ifu25UJRr13xg==",null,1,"4340"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8494","423","1118.0","1118.00","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-22","2020-10-21","423"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 11:21:50","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":["8494",462,"SETTLED","A14-I208823","2020-07-29 11:21:49","2020-07-22","2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8823","RENT","\u9810\u7e73\u79df\u91d1",1,1047,"MO","1",1047,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8823","RENT","\u9810\u7e73\u79df\u91d1",2,1047,"MO","1",1047,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8823","RENT","\u9810\u7e73\u79df\u91d1",3,1047,"MO","1",1047,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3141,0,"8823"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 11:21:50","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":[462,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208466","2020-07-29 11:21:49",3141,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8466","DEPOSIT",null,"PAID","2020-07-29 11:21:49",0,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:21:50","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":["8466","INVOICE","8823","PAID","2020-07-29 11:21:49",3141,"2","2020-07-29 11:21:49","2","2020-07-29 11:21:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:27:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:32:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:33:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:03","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=0&filter2=1271&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1271,"customer_code":"C191271","identity_type":"PERSONAL","identity_id":"K712755(3)","title":"Mr","lastname":"LAM","firstname":"Chi Wai","companyname":"","email":null,"tel":"92164311","address":"Room 2101, Ching Fai House, Tsz Ching Estate, Tsz Wan Shan, Kowloon ","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1798.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-17","renew_room_key":"'0012449154","renew_remark":"1 month contract. Storage rental paid by PPS on June 16, 2020. Storage deposit $1798 transferred from agreement C15-CT207895 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208159, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"175","order_discount":[],"order_room":[{"room_id":"1352","room_code":"C15-046","retail_price":"1798.0","discounted_price":"1798.00","location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1798,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1798,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-17","rent_from":"2020-07-17","rent_to":"2020-08-16","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit $1798 transferred from agreement C15-CT208159 to this agreement. \r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":1798,"final_order_total":1798,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012449154","order_product":[],"pass":true}},"first_order_id":"4999","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> C15-046 <\/td>\r\n\t\t\t\t\t 4X8X6.5 <\/td>\r\n\t\t\t\t\t $1798.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":"32","total_discounted_price":"1798.0","deposit":"0","total_retail_price":"1798.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1271,"NEW","C15-CT208495",1798,1798,0,0,"1","1",1798,1798,1798,"2020-07-29 11:34:04","0",null,null,null,"2020-07-17","2020-08-16","1 month contract. Storage rental paid by PPS on Jul 22, 2020. Storage deposit $1798 transferred from agreement C15-CT208159 to this agreement. \r\n\r\n","2020-07-17","32",0,null,0,"0","2","2020-07-29 11:34:03","2","2020-07-29 11:34:03","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"'0012449154","C191271","PERSONAL","Mr","gRYbQt3pC62mUupe40WPwQ==","BLxWt7e4owYJMFkn6\/eeMQ==","","TRjEyvIacLdlB3\/BTvMBQ8s+Hedp2neB9QwS8\/VtPvYoFFhsPhCivmgyYY0I0p4pmtPDggtb2uBFb9BrJYjHC86L6DWB3nraLGtOU\/Zg+IA=","+Lhrg0tS4jJm1n1j9ILS9A==",null,"EqHubtgeNEG24y4Oi2L10g==",null,1,"4999"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","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":["8495","1352","1798.0","1798.00","2","2020-07-29 11:34:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-17","2020-08-16","1352"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 11:34:04","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":["8495",1271,"SETTLED","C15-I208824","2020-07-29 11:34:03","2020-07-17","2","2020-07-29 11:34:03","2","2020-07-29 11:34:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","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":["8824","RENT","\u9810\u7e73\u79df\u91d1",1,1798,"MO","1",1798,"2","2020-07-29 11:34:03","2","2020-07-29 11:34:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1798,0,"8824"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 11:34:04","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":[1271,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208467","2020-07-29 11:34:03",1798,"2","2020-07-29 11:34:03","2","2020-07-29 11:34:03","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","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":["8467","DEPOSIT",null,"PAID","2020-07-29 11:34:03",0,"2","2020-07-29 11:34:03","2","2020-07-29 11:34:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:34:04","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":["8467","INVOICE","8824","PAID","2020-07-29 11:34:03",1798,"2","2020-07-29 11:34:03","2","2020-07-29 11:34:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 11:45:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:11:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:23:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:23","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":950,"customer_code":"C180950","identity_type":"PERSONAL","identity_id":"M096081(6)","title":"Mr","lastname":"Vincelli","firstname":"Stefano","companyname":"","email":"sabiobra@hotmail.com","tel":"95652114","address":"35 Happy View Terrace, Happy Valley, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"4116.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-03","renew_room_key":"076,29154","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 20, 2020. Storage deposit transferred from agreement A14-CT207787 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT208041, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"58","order_discount":[],"order_room":[{"room_id":"417","room_code":"I08","retail_price":"1098.0","discounted_price":"1098.00","location_id":"2"},{"room_id":"424","room_code":"J06","retail_price":"2888.0","discounted_price":"2888.00","location_id":"2"}],"roughly_size":"56","total_retail_price":3986,"total_discounted_price":4116,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":4116,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-03","rent_from":"2020-06-03","rent_to":"2020-07-02","delivery_service":"0","remark":"1 month contract. Storage rental $4051 paid by bank transfer on Jul 02, 2020. Commission of the transaction $65 will be deducted from storage deposit. Storage deposit transferred from agreement A14-CT208041 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4116,"final_order_total":4116,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,29154","order_product":[],"pass":true}},"first_order_id":"4680","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> I08 <\/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\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> J06 <\/td>\r\n\t\t\t\t\t 5X8X8 <\/td>\r\n\t\t\t\t\t $2888.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":"56","total_discounted_price":"4116.0","deposit":"0","total_retail_price":"3986.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","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",950,"NEW","A14-CT208496",3986,4116,0,0,"1","1",4116,4116,4116,"2020-07-29 12:29:24","0",null,null,null,"2020-06-03","2020-07-02","1 month contract. Storage rental $4051 paid by bank transfer on Jul 02, 2020. Commission of the transaction $65 will be deducted from storage deposit. Storage deposit transferred from agreement A14-CT208041 to this agreement.","2020-06-03","56",0,null,0,"0","2","2020-07-29 12:29:23","2","2020-07-29 12:29:23","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,29154","C180950","PERSONAL","Mr","kBtwICYFFgkwWiGlHlA7Vg==","J9AQQ+eusxRuMi9Uwswx2w==","","xpCmz6ayhnKM9CeubIeX46ST4OH8jL8leoh\/7rF5LKq0NI4lQzsUw3z+sKEaA2Q2","HMxniP6OLhRLykg\/y72g1w==","G2oqjsMfynuJ5hF7HR+cYPuapiwUrw6QQkLUvHZtFiE=","LjEwev8Vn2pWAe0zRvbXAw==",null,1,"4680"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","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":["8496","417","1098.0","1098.00","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-03","2020-07-02","417"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 12:29:24","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":["8496","424","2888.0","2888.00","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-03","2020-07-02","424"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 12:29:24","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":["8496",950,"SETTLED","A14-I208825","2020-07-29 12:29:23","2020-06-03","2","2020-07-29 12:29:23","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","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":["8825","RENT","\u9810\u7e73\u79df\u91d1",1,4116,"MO","1",4116,"2","2020-07-29 12:29:23","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4116,0,"8825"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 12:29:24","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":[950,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208468","2020-07-29 12:29:23",4116,"2","2020-07-29 12:29:23","2","2020-07-29 12:29:23","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","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":["8468","DEPOSIT",null,"PAID","2020-07-29 12:29:23",0,"2","2020-07-29 12:29:23","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:29:24","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":["8468","INVOICE","8825","PAID","2020-07-29 12:29:23",4116,"2","2020-07-29 12:29:23","2","2020-07-29 12:29:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:37:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:39:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:47:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 12:52:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:11:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:43","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1276,"customer_code":"C191276","identity_type":"BUSINESS","identity_id":"67226140-002-02-19-5","title":"Ms","lastname":"Kwok","firstname":"Wancie","companyname":"Happy Concepts Asia Limited","email":"wancie@happy-concepts.com","tel":"92420692","address":"Room 2107, 21\/F, Fullagar Ind Building, 234 Aberdeen Main Road, Aberdeen, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2161.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-27","renew_room_key":"076,47844","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 16, 2020. Storage deposit $4322 transferred form agreement A16-CT207889 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A16-CT208162, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"206","order_discount":[],"order_room":[{"room_id":"1645","room_code":"A16-154","retail_price":"2161.0","discounted_price":"2161.00","location_id":"7"}],"roughly_size":"28","total_retail_price":2161,"total_discounted_price":2161,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2161,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-27","rent_from":"2020-06-27","rent_to":"2020-07-26","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 14, 2020. Storage deposit $4322 transferred form agreement A16-CT208162 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":2161,"final_order_total":2161,"location_id":"7","branch_id":"1","company_id":"1","room_key":"076,47844","order_product":[],"pass":true}},"first_order_id":"5067","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-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> <\/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":"28","total_discounted_price":"2161.0","deposit":"0","total_retail_price":"2161.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","7",1276,"NEW","A16-CT208497",2161,2161,0,0,"1","1",2161,2161,2161,"2020-07-29 13:26:44","0",null,null,null,"2020-06-27","2020-07-26","1 month contract. Storage rental paid by bank transfer on Jul 14, 2020. Storage deposit $4322 transferred form agreement A16-CT208162 to this agreement. \r\n","2020-06-27","28",0,null,0,"0","2","2020-07-29 13:26:43","2","2020-07-29 13:26:43","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"076,47844","C191276","BUSINESS","Ms","UnAuVv7vF8jhvFzl3xSCmg==","+pNULpsInm3siHASV0hIrg==","Happy Concepts Asia Limited","Vz2ejyARH5zcH5e4QlFSq51bZp23xF3kJ5RJpCNl57lAk8+AWULPwqnFcIQcG5ZBdUxERR9syaCIcEtZgd+HqAaztaF6lZ3cM+VjkllU2B0=","Gfho0rh19G9JYZxq3cLhUw==","YWYp2e5RTnHURnlliiVCoZfRQjqOlQ4Jschx6rAjv1w=",null,"emH+RX7ttsZFOmRnXIxwP9GHFJD2VTz2ibaI3AjX2ZU=",1,"5067"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8497","1645","2161.0","2161.00","2","2020-07-29 13:26:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-27","2020-07-26","1645"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8497",1276,"SETTLED","A16-I208826","2020-07-29 13:26:43","2020-06-27","2","2020-07-29 13:26:43","2","2020-07-29 13:26:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8826","RENT","\u9810\u7e73\u79df\u91d1",1,2161,"MO","1",2161,"2","2020-07-29 13:26:43","2","2020-07-29 13:26:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2161,0,"8826"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1276,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208469","2020-07-29 13:26:43",2161,"2","2020-07-29 13:26:43","2","2020-07-29 13:26:43","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8469","DEPOSIT",null,"PAID","2020-07-29 13:26:43",0,"2","2020-07-29 13:26:43","2","2020-07-29 13:26:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:26:44","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8469","INVOICE","8826","PAID","2020-07-29 13:26:43",2161,"2","2020-07-29 13:26:43","2","2020-07-29 13:26:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:28:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:29:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:39:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 13:41:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:02:35","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19:18","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=538&filter3=undefined","renew":1,"warehousing":{"1":{"new_customer":"1","customer_id":703,"customer_code":"C180703","identity_type":"PERSONAL","identity_id":"Y654213(A)","title":"Mr","lastname":"CHAN","firstname":"Hei Yeung","companyname":"","email":"collinscha01@gmail.com","tel":"54865669","address":"Flat 15B, Blk 20, South Horizon, Ap Lei Chau","pass":true,"customer_first_order":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"899.0","renew_rent_month":"13","renew_warehousing_date":"2020-08-13","renew_room_key":"052,43426","renew_remark":"13 months contract. change from unit G02 to D25. Special renewal offer, one month free. Storage deposit $2276 transferred from agreement A12-CT194135 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT195426, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1996.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"600","room_code":"M11","retail_price":"598.0","discounted_price":"598.00","location_id":"2"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":1196,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1794,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-29","rent_from":"2020-07-29","rent_to":"2020-08-28","delivery_service":"0","remark":"1 month contract. Storage rental, deposit($1794) and credit card charge ($54) ttl $1848 paid by credit card on July 29, 2020. Smart card provided on the same day.","paymethod":"CREDIT_CARD","paymethod2":"CREDIT_CARD","discount_deduct":0,"order_total":1794,"final_order_total":1794,"location_id":"2","branch_id":"1","company_id":"1","room_key":"189, 51978","order_product":[],"pass":true}},"first_order_id":5426,"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> M11 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.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","floor_plan_rent_room":[{"room_id":"600","master_room_id":"28","room_code":"M11"}],"roughly_size":"12","total_discounted_price":"598.00","deposit":"1196.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `customer` set `code` = ?, `typeid` = ?, `title` = ?, `firstname` = ?, `lastname` = ?, `companyname` = ?, `tel` = ?, `email` = ?, `address` = ?, `hkid` = ?, `hkbr` = ?, `loginid` = ?, `password` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["C201694","PERSONAL","Mr","9qV4cci3GZgh7V3aDsYK\/w==","8BEgNhGpCR8jGkzUtrIcXg==","","936rCpx+8VBnYT2fCT\/pyA==","4faooPLziDXuOMUJiPjs0el238vR+lfQCWudx8n9RtE=","F9eBCMAajy2k4sdAcREuGt6RALzuT0dYJcJ21ycyAaiKHCV+5J01WrzvbEB6MBse","AQJgvyLl1wwbA6KBiQmLLQ==",null,"4faooPLziDXuOMUJiPjs0el238vR+lfQCWudx8n9RtE=","WM3NnnLVSIJLIfsKDM\/JyQ==","2","2020-07-29 14:19:18","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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",1694,"NEW","A14-CT208498",598,598,1196,0,"1","1",1794,1794,1794,"2020-07-29 14:19:19","0",null,null,null,"2020-07-29","2020-08-28","1 month contract. Storage rental, deposit($1794) and credit card charge ($54) ttl $1848 paid by credit card on July 29, 2020. Smart card provided on the same day.","2020-07-29","12",0,null,0,"0","2","2020-07-29 14:19:18","2","2020-07-29 14:19:18","CREDIT_CARD","","","","CREDIT_CARD","","","",null,0,"189, 51978","C201694","PERSONAL","Mr","9qV4cci3GZgh7V3aDsYK\/w==","8BEgNhGpCR8jGkzUtrIcXg==","","F9eBCMAajy2k4sdAcREuGt6RALzuT0dYJcJ21ycyAaiKHCV+5J01WrzvbEB6MBse","936rCpx+8VBnYT2fCT\/pyA==","4faooPLziDXuOMUJiPjs0el238vR+lfQCWudx8n9RtE=","AQJgvyLl1wwbA6KBiQmLLQ==",null,1,5426]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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":["8498","600","598.0","598.00","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-29","2020-08-28","600"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 14:19:19","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8498","A14-D205577","PAID",1196,0,"2020-08-28","2020-07-29 14:19:18","2020-07-29 14:19:18","2","2020-07-29 14:19:18","2","2020-07-29 14:19:18",1694]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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":["8498",1694,"SETTLED","A14-I208827","2020-07-29 14:19:18","2020-07-29","2","2020-07-29 14:19:18","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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":["8827","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-29 14:19:18","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19:19","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8827"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 14:19: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":[1694,"CREDIT_CARD","","","","CREDIT_CARD","","","","PAID","P208470","2020-07-29 14:19:18",1794,"2","2020-07-29 14:19:18","2","2020-07-29 14:19:18","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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":["8470","DEPOSIT","5577","PAID","2020-07-29 14:19:18",1196,"2","2020-07-29 14:19:18","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:19: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":["8470","INVOICE","8827","PAID","2020-07-29 14:19:18",598,"2","2020-07-29 14:19:18","2","2020-07-29 14:19:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:32:44","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:33:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:58","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"type=INVOICE&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"600","master_room_id":"28","room_code":"M11"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":422,"customer_code":"C170422","identity_type":"PERSONAL","identity_id":"D707882(0)","title":"Ms","lastname":"Lun","firstname":"Kin Ting, Jennifer","companyname":"","email":"jenniferlun@netvigator.com","tel":"94601114","address":"13\/F, Flat D, 58 Aberdeen Main Road, HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1887.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-06","renew_room_key":"054,60331,054,46800","renew_remark":"3 months contract. Storage rental paid by bank transfer on Mar 20, 2020. Storage deposit transferred from agreement A14-CT206918 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207470, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"35","order_discount":[{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"570","is_final_discount":"0","payment_term":"PREPAID_3_MO"},{"master_room_discount_id":"434","master_room_id":"35","discount_type":"%","price":"1098.00","disocunted_price":"1043.40","discount":"4.97","monthly_deduct":54.5706,"room_id":"571","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"571","room_code":"L49","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"},{"room_id":"570","room_code":"L48","retail_price":"1098.0","discounted_price":1043.4,"location_id":"2"}],"roughly_size":"32","total_retail_price":2196,"total_discounted_price":1887,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5661,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-06","rent_from":"2020-06-06","rent_to":"2020-09-05","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT207470 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5661,"final_order_total":5661,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,60331,054,46800","order_product":[],"pass":true}},"first_order_id":"4885","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> L49 <\/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\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> L48 <\/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\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":"32","total_discounted_price":"1887.0","deposit":"0","total_retail_price":"2196.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",422,"NEW","A14-CT208499",2196,1887,0,0,"3","3",5661,5661,5661,"2020-07-29 14:53:59","0",null,null,null,"2020-06-06","2020-09-05","3 months contract. Storage rental paid by bank transfer on Jul 28, 2020. Storage deposit transferred from agreement A14-CT207470 to this agreement.\r\n","2020-06-06","32",0,null,0,"0","2","2020-07-29 14:53:58","2","2020-07-29 14:53:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,60331,054,46800","C170422","PERSONAL","Ms","xYi2pwRevSHfV5czTkolJ7KAgbpNCBYwTee28I\/M54o=","AmePxSuzgSRLGutACC9bnA==","","FJ9ZDY8\/7kA8A+te5iy9YqoyRYpOU3Bmu0epfxVEGBZDwhm\/CmuQLqsktSokLLwP","8XqrRRnMV+GmztFyZOdQwA==","PLmzzbYEBFtGoiJmp\/XL7iWspjMaTej8bBZte\/60rbY=","NE7TBy05SBIIdbS3hOb6DQ==",null,1,"4885"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8499","434","35","570","%","4.97",54.5706,"2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8499","434","35","571","%","4.97",54.5706,"2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8499","571","1098.0",1043.4,"2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-06","2020-09-05","571"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 14:53:59","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":["8499","570","1098.0",1043.4,"2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-06","2020-09-05","570"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 14:53:59","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":["8499",422,"SETTLED","A14-I208828","2020-07-29 14:53:58","2020-06-06","2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8828","RENT","\u9810\u7e73\u79df\u91d1",1,1887,"MO","1",1887,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8828","RENT","\u9810\u7e73\u79df\u91d1",2,1887,"MO","1",1887,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8828","RENT","\u9810\u7e73\u79df\u91d1",3,1887,"MO","1",1887,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5661,0,"8828"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 14:53:59","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[422,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208471","2020-07-29 14:53:58",5661,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8471","DEPOSIT",null,"PAID","2020-07-29 14:53:58",0,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:53:59","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":["8471","INVOICE","8828","PAID","2020-07-29 14:53:58",5661,"2","2020-07-29 14:53:58","2","2020-07-29 14:53:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:54:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 14:54:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 15:05:39","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 15:13:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:05:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1685&filter3=undefined","floor_plan_rent_room":[{"room_id":"1459","master_room_id":"181","room_code":"C15-153"},{"room_id":"1408","master_room_id":"172","room_code":"C15-102"}],"_payment_type":"INVOICE","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K044654(8)","title":"Ms","lastname":"SIU","firstname":"Sin Hung","companyname":"","email":"cunice338@gmail.com","tel":"93331759","address":"Rm 1817, 18\/F, Wah Fu House, Wah Kwai Estate, Aberdeen HK","pass":true,"customer_id":"1685","customer_code":"C201685","customer_first_order":true},"2":{"order_discount":[],"order_room":[{"room_id":"1459","room_code":"C15-153","retail_price":"1260.0","discounted_price":"1260.00","location_id":"6"},{"room_id":"1408","room_code":"C15-102","retail_price":"1115.0","discounted_price":"1115.00","location_id":"6"}],"roughly_size":"42.5","total_retail_price":2375,"total_discounted_price":2138,"deposit":2375,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":22695,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5336.00","warehousing_date":"2020-08-02","rent_from":"2020-08-02","rent_to":"2021-08-01","delivery_service":"0","remark":"12 months contract. Special offer 5% \"rent now\" offer, the 11th and 12th months free for the first contract. $1000 deposit paid on 25 May,2020. The balance of storage rental and deposit $21,695 paid by bank transfer on 29 Jul, 2020. Smart card provided on the same day. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5336,"order_total":28031,"final_order_total":22695,"location_id":"6","branch_id":"3","company_id":"1","room_key":"'0012438274","order_product":[],"pass":true}},"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-153 <\/td>\r\n\t\t\t\t\t 5X4.5X6.5 <\/td>\r\n\t\t\t\t\t $1260.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> C15-102 <\/td>\r\n\t\t\t\t\t 4X5X6.5 <\/td>\r\n\t\t\t\t\t $1115.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":"42.5","total_discounted_price":"2138.00","deposit":"2375.00","total_retail_price":"2375.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1685","NEW","C15-CT208500",2375,2138,2375,0,"12","12",22695,28031,22695,"2020-07-29 16:11:13","0",null,null,null,"2020-08-02","2021-08-01","12 months contract. Special offer 5% \"rent now\" offer, the 11th and 12th months free for the first contract. $1000 deposit paid on 25 May,2020. The balance of storage rental and deposit $21,695 paid by bank transfer on 29 Jul, 2020. Smart card provided on the same day. ","2020-08-02","42.5",0,null,5336,"5336.00","2","2020-07-29 16:11:13","2","2020-07-29 16:11:13","BANKIN","","","","BANKIN","","","",null,0,"'0012438274","C201685","PERSONAL","Ms","4QMnxddJdslJoypyVtWPyw==","fwsebH2az17gKNdZ18K8Cg==","","VW9+jvHNg2SpzBgrWYTEmhtsja0blukK1FfpVSOoYi39qUQhx9Z2VSKGopQV2zopCSO1J9HM87Gz88e+Vwe+0g==","a2IWvXZ1FGKF7JMCbKiy0w==","gzzQWKTJ6NR68JO3U6qnptyActWEjzpzcyaIOKwMDM4=","AgwQy3Oo272aCE7M6GbUFQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8500","1459","1260.0","1260.00","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-02","2021-08-01","1459"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8500","1408","1115.0","1115.00","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-08-02","2021-08-01","1408"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["8500","C15-D205578","PAID",2375,0,"2021-08-01","2020-07-29 16:11:13","2020-07-29 16:11:13","2","2020-07-29 16:11:13","2","2020-07-29 16:11:13","1685"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8500","1685","SETTLED","C15-I208829","2020-07-29 16:11:13","2020-08-02","2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,0,"MO","1",0,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",3,1078,"MO","1",1078,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",4,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",5,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",6,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",7,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",8,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",9,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",10,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",11,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8829","RENT","\u9810\u7e73\u79df\u91d1",12,2138,"MO","1",2138,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[20320,0,"8829"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1685","BANKIN","","","","BANKIN","","","","PAID","P208472","2020-07-29 16:11:13",22695,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8472","DEPOSIT","5578","PAID","2020-07-29 16:11:13",2375,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:11:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8472","INVOICE","8829","PAID","2020-07-29 16:11:13",20320,"2","2020-07-29 16:11:13","2","2020-07-29 16:11:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:16:59","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:17:19","login_id":"2","controller":"update_record","function":"","input":{"sql":"update `order` set `status` = ?, `room_key` = ?, `remark` = ?, `lastupdate` = ?, `lastupby` = ?, `customer_lastname` = ?, `customer_firstname` = ?, `customer_email` = ?, `customer_tel` = ?, `customer_address` = ? where id = ?","parameters":["NEW","'0012438274; '0012438066","12 months contract. Special offer 5% \"rent now\" offer, the 11th and 12th months free for the first contract. $1000 deposit paid on 25 May,2020. The balance of storage rental and deposit $21,695 paid by bank transfer on 29 Jul, 2020. Smart card provided on the same day. ","2020-07-29 16:17:19","2","fwsebH2az17gKNdZ18K8Cg==","4QMnxddJdslJoypyVtWPyw==","gzzQWKTJ6NR68JO3U6qnptyActWEjzpzcyaIOKwMDM4=","a2IWvXZ1FGKF7JMCbKiy0w==","VW9+jvHNg2SpzBgrWYTEmhtsja0blukK1FfpVSOoYi39qUQhx9Z2VSKGopQV2zopCSO1J9HM87Gz88e+Vwe+0g==",8500]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 16:44:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 17:03:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 17:30:56","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 17:55:02","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1175&filter3=undefined","floor_plan_rent_room":[{"room_id":"1459","master_room_id":"181","room_code":"C15-153"},{"room_id":"1408","master_room_id":"172","room_code":"C15-102"}],"_payment_type":"INVOICE","warehousing":{"2":{"order_discount":[{"master_room_discount_id":"282","master_room_id":"125","discount_type":"%","price":"1384.00","disocunted_price":"1314.80","discount":"5.00","monthly_deduct":69.2,"room_id":"1071","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"renew_paymethod2":"CHEQUE","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1316.0","renew_rent_month":"3","renew_warehousing_date":"2020-06-11","renew_room_key":"5031144","renew_remark":"3 month contract, storage rental paid by cheque on April 14, 2020. Storage deposit $2768 transferred from agreement A05-CT207291 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT207603, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"125","order_room":[{"room_id":"1071","room_code":"A05-069","retail_price":"1384.0","discounted_price":1314.8,"location_id":"4"}],"roughly_size":"18","total_retail_price":1384,"total_discounted_price":1316,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":3948,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-11","rent_from":"2020-06-11","rent_to":"2020-09-10","delivery_service":"0","remark":"3 month contract, storage rental paid by cheque on JUN 10, 2020. Storage deposit $2768 transferred from agreement A05-CT207603 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"CHEQUE","bank_name2":"","cheque_num2":"","discount_deduct":0,"order_total":3948,"final_order_total":3948,"location_id":"4","branch_id":"1","company_id":"1","room_key":"5031144","order_product":[],"pass":true},"1":{"new_customer":0,"customer_id":1144,"customer_code":"C181144","identity_type":"PERSONAL","identity_id":"P119862(2)","title":"Ms","lastname":"LYNCH","firstname":"Katherine Louise","companyname":"","email":"klynch@hku.hk","tel":"98612015","address":"B1 Rodrigues Court, 350 victoria road","pass":true}},"renew":1,"first_order_id":"3869","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> A05-069 <\/td>\r\n\t\t\t\t\t 6X3X7 <\/td>\r\n\t\t\t\t\t $1384.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":"18","total_discounted_price":"1316.0","deposit":"0","total_retail_price":"1384.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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",1144,"NEW","A05-CT208501",1384,1316,0,0,"3","3",3948,3948,3948,"2020-07-29 18:07:52","0",null,null,null,"2020-06-11","2020-09-10","3 month contract, storage rental paid by cheque on JUN 10, 2020. Storage deposit $2768 transferred from agreement A05-CT207603 to this agreement.\r\n","2020-06-11","18",0,null,0,"0","2","2020-07-29 18:07:52","2","2020-07-29 18:07:52","NO_NEED_PAID_RENEW","","","","CHEQUE","","","",null,0,"5031144","C181144","PERSONAL","Ms","pRvUckqUjedhSuP6hjHyd5QcjY8WOyYJRiCMTzrg9pE=","xVGlP\/lp0XHja2WftDhyNg==","","pYnB+qIPhSqfQ2JGXAdViVz+EXg\/ZsKZsp\/iIfVHhTTtjDLnDck+UXDdARxX7IYM","2+MoVDFHBMIU42dUrGhIfw==","yhgITzrJz7y3NuhRNEqCbg==","eToWdLrvi7IkAIlkcwzGQA==",null,1,"3869"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8501","282","125","1071","%","5.00",69.2,"2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8501","1071","1384.0",1314.8,"2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-11","2020-09-10","1071"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 18:07:52","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":["8501",1144,"SETTLED","A05-I208830","2020-07-29 18:07:52","2020-06-11","2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8830","RENT","\u9810\u7e73\u79df\u91d1",1,1316,"MO","1",1316,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8830","RENT","\u9810\u7e73\u79df\u91d1",2,1316,"MO","1",1316,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8830","RENT","\u9810\u7e73\u79df\u91d1",3,1316,"MO","1",1316,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3948,0,"8830"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 18:07:52","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":[1144,"NO_NEED_PAID_RENEW","","","","CHEQUE","","","","PAID","P208473","2020-07-29 18:07:52",3948,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8473","DEPOSIT",null,"PAID","2020-07-29 18:07:52",0,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:07:52","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":["8473","INVOICE","8830","PAID","2020-07-29 18:07:52",3948,"2","2020-07-29 18:07:52","2","2020-07-29 18:07:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:24:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:44:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=1&filter2=1175&filter3=undefined","floor_plan_rent_room":[{"room_id":"1459","master_room_id":"181","room_code":"C15-153"},{"room_id":"1408","master_room_id":"172","room_code":"C15-102"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":826,"customer_code":"C180826","identity_type":"PERSONAL","identity_id":"V120085(2)","title":"Ms","lastname":"Wong","firstname":"Lai Wing","companyname":"","email":"aslinnlaiwing@gmail.com","tel":"60823501","address":"Flat B, 23\/F, Yee Wan Court, South Horizons, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-07-21","renew_room_key":"052,37309","renew_remark":"1 month contract. Storage rental paid by bank transfer on June 29, 2020. Storage deposit transferred from agreement A12-CT207974 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208300, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"207","room_code":"D11","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-07-21","rent_from":"2020-07-21","rent_to":"2020-08-20","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jul 29, 2020. Storage deposit transferred from agreement A12-CT208300 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"052,37309","order_product":[],"pass":true}},"first_order_id":"4840","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> D11 <\/td>\r\n\t\t\t\t\t 4X3X4 <\/td>\r\n\t\t\t\t\t $598.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"598.0","deposit":"0","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","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",826,"NEW","A12-CT208502",598,598,0,0,"1","1",598,598,598,"2020-07-29 18:52:50","0",null,null,null,"2020-07-21","2020-08-20","1 month contract. Storage rental paid by bank transfer on Jul 29, 2020. Storage deposit transferred from agreement A12-CT208300 to this agreement.\r\n","2020-07-21","12",0,null,0,"0","2","2020-07-29 18:52:50","2","2020-07-29 18:52:50","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,37309","C180826","PERSONAL","Ms","AVQEhVbkdf0QwgZhPqTuvQ==","hULSwM2MvFtpeV9\/z+er8Q==","","VYTecHlXsAq2HU\/SK2vg0HE0ESjbB0AIG1TtdkNrHvzSOFADaqlQfFPEOwNTSSdXg5YSZtYVVGLVGFZuRQfF9AxsFxu92jPjM0q+fUqGSyI=","M\/mMkpABptC23N0qOMtMOA==","I+DcTUTCSlvqwNtqcfOhWkdyXo7XLnfkUFX2VHxYh3c=","d\/8HRqfi7sBcCF03ucfekg==",null,1,"4840"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","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":["8502","207","598.0","598.00","2","2020-07-29 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-07-21","2020-08-20","207"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-07-29 18:52:50","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":["8502",826,"SETTLED","A12-I208831","2020-07-29 18:52:50","2020-07-21","2","2020-07-29 18:52:50","2","2020-07-29 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","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":["8831","RENT","\u9810\u7e73\u79df\u91d1",1,598,"MO","1",598,"2","2020-07-29 18:52:50","2","2020-07-29 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[598,0,"8831"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-07-29 18:52:50","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":[826,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208474","2020-07-29 18:52:50",598,"2","2020-07-29 18:52:50","2","2020-07-29 18:52:50","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","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":["8474","DEPOSIT",null,"PAID","2020-07-29 18:52:50",0,"2","2020-07-29 18:52:50","2","2020-07-29 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:52:50","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":["8474","INVOICE","8831","PAID","2020-07-29 18:52:50",598,"2","2020-07-29 18:52:50","2","2020-07-29 18:52:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:53:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 18:56:30","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-07-29 21:50:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} *****