{"created_at":"2020-05-07 10:11:04","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"filter1=2&filter2=1032&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":733,"customer_code":"C180733","identity_type":"PERSONAL","identity_id":"G011129(4)","title":"Ms","lastname":"Kan","firstname":"Yim Ngan","companyname":"","email":"nellykan1128@yahoo.com.hk","tel":"94324063","address":"Rm 1613, Pik Long House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1058.0","renew_rent_month":"1","renew_warehousing_date":"2020-03-20","renew_room_key":"054,42661","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 15, 2020. Storage deposit $2096 transferred from agreement A18-CT207307 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207621, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"101","order_discount":[],"order_room":[{"room_id":"935","room_code":"V09(\u670d\u88dd\u5009)","retail_price":"1058.0","discounted_price":"1058.00","location_id":"3"}],"roughly_size":"9.6","total_retail_price":1058,"total_discounted_price":1058,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1058,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-20","rent_from":"2020-03-20","rent_to":"2020-04-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 7, 2020. Storage deposit $2096 transferred from agreement A18-CT207621 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1058,"final_order_total":1058,"location_id":"3","branch_id":"1","company_id":"1","room_key":"054,42661","order_product":[],"pass":true}},"first_order_id":"4514","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>
V09(\u670d\u88dd\u5009) <\/td>\r\n\t\t\t\t\t	4X2.4X7 <\/td>\r\n\t\t\t\t\t	$1058.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":"9.6","total_discounted_price":"1058.0","deposit":"0","total_retail_price":"1058.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",733,"NEW","A18-CT207793",1058,1058,0,0,"1","1",1058,1058,1058,"2020-05-07 10:21:29","0",null,null,null,"2020-03-20","2020-04-19","1 month contract. Storage rental paid by bank transfer on May 7, 2020. Storage deposit $2096 transferred from agreement A18-CT207621 to this agreement. \r\n","2020-03-20","9.6",0,null,0,"0","2","2020-05-07 10:21:29","2","2020-05-07 10:21:29","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,42661","C180733","PERSONAL","Ms","LuCmhx4vLIS+I2VRpkOJLw==","Oy7M11y4AYbqdsYthumGaw==","","pRevwfLH+V5p27KCzHhjJiFoLF+7KutuihUJaWarNVLL+Cfse1AKI58Qyx0LsGyvf51+AcKXq58wG9PBXHPRg8q+MOpswflvPznmtJYPHOM=","j+g19UGqLxVDE6Ev1Ki78g==","0QRC7C\/A8YfDBYxJnv35JgsmKRHtg1WHgToRbTKF+0Q=","\/4aTFzkJ3TQsDPebIexQkQ==",null,1,"4514"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["7793","935","1058.0","1058.00","2","2020-05-07 10:21:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-20","2020-04-19","935"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7793",733,"SETTLED","A18-I208122","2020-05-07 10:21:29","2020-03-20","2","2020-05-07 10:21:29","2","2020-05-07 10:21:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8122","RENT","\u9810\u7e73\u79df\u91d1",1,1058,"MO","1",1058,"2","2020-05-07 10:21:29","2","2020-05-07 10:21:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1058,0,"8122"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[733,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207767","2020-05-07 10:21:29",1058,"2","2020-05-07 10:21:29","2","2020-05-07 10:21:29","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7767","DEPOSIT",null,"PAID","2020-05-07 10:21:29",0,"2","2020-05-07 10:21:29","2","2020-05-07 10:21:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:21:29","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["7767","INVOICE","8122","PAID","2020-05-07 10:21:29",1058,"2","2020-05-07 10:21:29","2","2020-05-07 10:21:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:32:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:49:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51: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=2&filter2=1032&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":649,"customer_code":"C170649","identity_type":"PERSONAL","identity_id":"D658788(8)","title":"Mr","lastname":"Wong","firstname":"Shing Kwan Gordon ","companyname":"","email":"gq1310@yahoo.com.hk","tel":"53030469","address":"\u9999\u6e2f\u4ed4\u9038\u6e2f\u5c451\u5ea74\u6a13D\u5ea7","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1525.0","renew_rent_month":"3","renew_warehousing_date":"2020-03-28","renew_room_key":"133,32874","renew_remark":"3 months contract. Storage rental paid by bank transfer on February 14, 2020. Storage deposit transferred from agreement A18-CT196351 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207192, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"78","order_discount":[{"master_room_discount_id":"252","master_room_id":"78","discount_type":"%","price":"1605.00","disocunted_price":"1524.80","discount":"5.00","monthly_deduct":80.25,"room_id":"940","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"940","room_code":"V14","retail_price":"1605.0","discounted_price":1524.8,"location_id":"3"}],"roughly_size":"20","total_retail_price":1605,"total_discounted_price":1525,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4575,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-03-28","rent_from":"2020-03-28","rent_to":"2020-06-27","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on May 6, 2020. Storage deposit transferred from agreement A18-CT207192 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":4575,"final_order_total":4575,"location_id":"3","branch_id":"1","company_id":"1","room_key":"133,32874","order_product":[],"pass":true}},"first_order_id":"4409","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> V14 <\/td>\r\n\t\t\t\t\t 4X5X7 <\/td>\r\n\t\t\t\t\t $1605.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":"20","total_discounted_price":"1525.0","deposit":"0","total_retail_price":"1605.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","3",649,"NEW","A18-CT207794",1605,1525,0,0,"3","3",4575,4575,4575,"2020-05-07 10:51:39","0",null,null,null,"2020-03-28","2020-06-27","3 months contract. Storage rental paid by bank transfer on May 6, 2020. Storage deposit transferred from agreement A18-CT207192 to this agreement.\r\n","2020-03-28","20",0,null,0,"0","2","2020-05-07 10:51:39","2","2020-05-07 10:51:39","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"133,32874","C170649","PERSONAL","Mr","v4dwfZbWgztWwOO0+DKLqvngLlMYAWBIg5hFuO5UkcI=","hULSwM2MvFtpeV9\/z+er8Q==","","MzIxaThTlSRnM0LX9AJI\/z2u9jCD1+Cmf\/ICago4BP8=","DUwkHg2aCYBYFtwLlrWQSw==","0sqIy\/hJ4IVsR5jpqD48Fg3uig8eD35E9eH8wPbBohA=","wDbeWC0+yorX7t2b+1ST5g==",null,1,"4409"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["7794","252","78","940","%","5.00",80.25,"2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["7794","940","1605.0",1524.8,"2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-03-28","2020-06-27","940"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 10:51:39","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":["7794",649,"SETTLED","A18-I208123","2020-05-07 10:51:39","2020-03-28","2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["8123","RENT","\u9810\u7e73\u79df\u91d1",1,1525,"MO","1",1525,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["8123","RENT","\u9810\u7e73\u79df\u91d1",2,1525,"MO","1",1525,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["8123","RENT","\u9810\u7e73\u79df\u91d1",3,1525,"MO","1",1525,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4575,0,"8123"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 10:51:39","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":[649,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207768","2020-05-07 10:51:39",4575,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["7768","DEPOSIT",null,"PAID","2020-05-07 10:51:39",0,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:51:39","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":["7768","INVOICE","8123","PAID","2020-05-07 10:51:39",4575,"2","2020-05-07 10:51:39","2","2020-05-07 10:51:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 10:54:11","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 13:00:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 13:00:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 13:02:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 13:04:34","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 14:18:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 14:34:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39:12","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=503&filter3=undefined&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":434,"customer_code":"C170434","identity_type":"PERSONAL","identity_id":"D223171(A)","title":"Mr","lastname":"So","firstname":"Pun Shek Jack","companyname":"","email":"info@innoutstorage.com","tel":"90388727","address":"15A,Tower 1,Marina Habitat,Apleichau,HK","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1358.0","renew_rent_month":"6","renew_warehousing_date":"2020-05-09","renew_room_key":"054,43135","renew_remark":"6 months contract. Storage rental paid by bank trasfer on Nov 09, 2019. Storage deposit transferred from agreement A14-CT194916 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT196347, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"44","order_discount":[],"order_room":[{"room_id":"494","room_code":"K31","retail_price":"1768.0","discounted_price":"1768.00","location_id":"2"}],"roughly_size":"24","total_retail_price":1768,"total_discounted_price":1433,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":4299,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-09","rent_from":"2020-05-09","rent_to":"2020-08-08","delivery_service":"0","remark":"3 months contract. Storage rental paid by PPS on May 6, 2020. Storage deposit transferred from agreement A14-CT196347 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":4299,"final_order_total":4299,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,43135","order_product":[],"pass":true}},"first_order_id":"3478","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> K31 <\/td>\r\n\t\t\t\t\t 4X6X8 <\/td>\r\n\t\t\t\t\t $1768.00 <\/td>\r\n\t\t\t\t N\/A <\/td> <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"24","total_discounted_price":"1433.00","deposit":"0.00","total_retail_price":"1768.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39:13","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","2",434,"NEW","A14-CT207795",1768,1433,0,0,"3","3",4299,4299,4299,"2020-05-07 15:39:13","0",null,null,null,"2020-05-09","2020-08-08","3 months contract. Storage rental paid by PPS on May 6, 2020. Storage deposit transferred from agreement A14-CT196347 to this agreement.","2020-05-09","24",0,null,0,"0","2","2020-05-07 15:39:12","2","2020-05-07 15:39:12","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"054,43135","C170434","PERSONAL","Mr","T\/Q3qmuOOa4FMO1zzvBKTw==","4x5vYEKSVRSuDm5I8YHOGA==","","0447woLhqxWi2RCzAnOBwlINYiFSebLpXhIC6ugC0dL6BkLVMmg2IbqPevGQc8P0","Af7WgJd9hGJXbDBR\/aX96A==","AOtogTQpKsXPIJ5LCHb2jlbJmZNTejLdArgHP5WbXvU=","vN7KUc\/ElT\/XvNMYEjZ\/Lw==",null,1,"3478"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["7795","494","1768.0","1768.00","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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-05-09","2020-08-08","494"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 15:39: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":["7795",434,"SETTLED","A14-I208124","2020-05-07 15:39:12","2020-05-09","2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["8124","RENT","\u9810\u7e73\u79df\u91d1",1,1433,"MO","1",1433,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["8124","RENT","\u9810\u7e73\u79df\u91d1",2,1433,"MO","1",1433,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["8124","RENT","\u9810\u7e73\u79df\u91d1",3,1433,"MO","1",1433,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39:13","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[4299,0,"8124"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 15:39: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":[434,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207769","2020-05-07 15:39:12",4299,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["7769","DEPOSIT",null,"PAID","2020-05-07 15:39:12",0,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:39: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":["7769","INVOICE","8124","PAID","2020-05-07 15:39:12",4299,"2","2020-05-07 15:39:12","2","2020-05-07 15:39:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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=503&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":153,"customer_code":"C160153","identity_type":"PERSONAL","identity_id":"Z614380(7)","title":"Ms","lastname":"Au-Yeung","firstname":"Pik Kwan","companyname":"","email":"carol_85_2000@yahoo.com.hk","tel":"97502271","address":"\u9999\u6e2f\u77f3\u6392\u7063\u6751\u78a7\u8f1d\u6a137\u6a13706\u5ba4","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-04-20","renew_room_key":"053,63642","renew_remark":"1 month contract. Storage rental paid by PPS on April 6, 2020. Storage deposit transferred from agreement A12-CT207311 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207587, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"6","order_discount":[],"order_room":[{"room_id":"227","room_code":"D31","retail_price":"998.0","discounted_price":"998.00","location_id":"1"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-20","rent_from":"2020-04-20","rent_to":"2020-05-19","delivery_service":"0","remark":"1 month contract. Storage rental paid by PPS on May 6, 2020. Storage deposit transferred from agreement A12-CT207587 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"1","branch_id":"1","company_id":"1","room_key":"053,63642","order_product":[],"pass":true}},"first_order_id":"4883","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> D31 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed812\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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",153,"NEW","A12-CT207796",998,998,0,0,"1","1",998,998,998,"2020-05-07 15:40:51","0",null,null,null,"2020-04-20","2020-05-19","1 month contract. Storage rental paid by PPS on May 6, 2020. Storage deposit transferred from agreement A12-CT207587 to this agreement.\r\n","2020-04-20","12",0,null,0,"0","2","2020-05-07 15:40:51","2","2020-05-07 15:40:51","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"053,63642","C160153","PERSONAL","Ms","KkrSDrQ1H2C7AHMXanK04g==","5c4M0ZQmSIw3LaJy30yaLQ==","","VydP8q4rzuZV5xu3JM4S94+vjANpX0mSGFwOYMOB853mNnGiX4hnOAOtYB32IPMF","G4ql4s\/qkLFXwmJNbU6cdQ==","2yv4BPlbG\/\/YEJETfEEfNB1ddarjnzyQnu7bGnobgMM=","N0BX828OAg4Z6rH9GAZdUA==",null,1,"4883"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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":["7796","227","998.0","998.00","2","2020-05-07 15:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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-04-20","2020-05-19","227"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 15:40:51","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":["7796",153,"SETTLED","A12-I208125","2020-05-07 15:40:51","2020-04-20","2","2020-05-07 15:40:51","2","2020-05-07 15:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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":["8125","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-07 15:40:51","2","2020-05-07 15:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8125"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 15:40:51","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":[153,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P207770","2020-05-07 15:40:51",998,"2","2020-05-07 15:40:51","2","2020-05-07 15:40:51","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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":["7770","DEPOSIT",null,"PAID","2020-05-07 15:40:51",0,"2","2020-05-07 15:40:51","2","2020-05-07 15:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 15:40:51","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":["7770","INVOICE","8125","PAID","2020-05-07 15:40:51",998,"2","2020-05-07 15:40:51","2","2020-05-07 15:40:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:05:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:05:36","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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":"filter1=2&filter2=503&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1375,"customer_code":"C191375","identity_type":"PERSONAL","identity_id":"Z921640(6)","title":"Mr","lastname":"Cheung","firstname":"Kit Yu","companyname":"","email":null,"tel":"55445761","address":"Flat 206, 2\/F, Pik Luk House, Shek Pai Wan Estate, Aberdeen, Hong Kong","pass":true},"2":{"renew_paymethod2":"CASH","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"2188.0","renew_rent_month":"2","renew_warehousing_date":"2020-04-01","renew_room_key":"076,49779","renew_remark":"2\u500b\u6708\u5408\u7d04. \u79df\u91d1\u57282020\u5e744\u67088\u65e5\u4ee5\u73fe\u91d1\u7e73\u4ed8.\u820a\u5408\u7d04\u7de8\u865f: A14-CT206882, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $4376.0 2 months contract. Storage rental paid by cash on April 8, 2020. Storage deposit $4376 transferred from agreement A14-CT206882 to this agreement. \u820a\u5408\u7d04\u7de8\u865f: A14-CT206882, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207618, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"53","order_discount":[],"order_room":[{"room_id":"461","room_code":"J43","retail_price":"2188.0","discounted_price":"2188.00","location_id":"2"}],"roughly_size":"30","total_retail_price":2188,"total_discounted_price":2188,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":2188,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-04-01","rent_from":"2020-04-01","rent_to":"2020-04-30","delivery_service":"0","remark":"1 month contact. Storage rental paid by bank transfer on April 7, 2020. Storage deposit $4376 transferred from agreement A14-CT207618 to this agreement. \r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":2188,"final_order_total":2188,"location_id":"2","branch_id":"1","company_id":"1","room_key":"076,49779","order_product":[],"pass":true}},"first_order_id":"5778","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> J43 <\/td>\r\n\t\t\t\t\t 5X6X8 <\/td>\r\n\t\t\t\t\t $2188.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\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":"30","total_discounted_price":"2188.00","deposit":"0.00","total_retail_price":"2188.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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",1375,"NEW","A14-CT207797",2188,2188,0,0,"1","1",2188,2188,2188,"2020-05-07 16:08:59","0",null,null,null,"2020-04-01","2020-04-30","1 month contact. Storage rental paid by bank transfer on April 7, 2020. Storage deposit $4376 transferred from agreement A14-CT207618 to this agreement. \r\n","2020-04-01","30",0,null,0,"0","2","2020-05-07 16:08:58","2","2020-05-07 16:08:58","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"076,49779","C191375","PERSONAL","Mr","ksGbPh21wXxn8OkaY6lLfw==","vCxOlXQuvOQaoL822H2o\/Q==","","5LxpXhLiPD2WSK4Uthz9ZguOwD3uISNO\/bHbCtYORGGqf+NrT1VVRVXl3hOjxM0EWwptox0+0GANo7EzFCARudS+BCU3VcsM6kJM+VZKL0U=","xymPZ9tGDPharD71TGnWbw==",null,"EP5UJl7gfXqJy9lL5gT2jQ==",null,1,"5778"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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":["7797","461","2188.0","2188.00","2","2020-05-07 16:08:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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-04-01","2020-04-30","461"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 16:08: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":["7797",1375,"SETTLED","A14-I208126","2020-05-07 16:08:58","2020-04-01","2","2020-05-07 16:08:58","2","2020-05-07 16:08:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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":["8126","RENT","\u9810\u7e73\u79df\u91d1",1,2188,"MO","1",2188,"2","2020-05-07 16:08:58","2","2020-05-07 16:08:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[2188,0,"8126"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 16:08: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":[1375,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207771","2020-05-07 16:08:58",2188,"2","2020-05-07 16:08:58","2","2020-05-07 16:08:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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":["7771","DEPOSIT",null,"PAID","2020-05-07 16:08:58",0,"2","2020-05-07 16:08:58","2","2020-05-07 16:08:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:08: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":["7771","INVOICE","8126","PAID","2020-05-07 16:08:58",2188,"2","2020-05-07 16:08:58","2","2020-05-07 16:08:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:32","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=503&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":418,"customer_code":"C170418","identity_type":"PERSONAL","identity_id":"D254599(4)","title":"Ms","lastname":"Cheung","firstname":"Yee Man","companyname":"","email":null,"tel":"60159661","address":"\u9999\u6e2f\u4ed4\u4e2d\u5fc3\u6d77\u6676\u95a317\u6a131\u5ba4","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-09","renew_room_key":"054,47889","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 06, 2020. Storage deposit transferred A14-CT207308 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207571, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"34","order_discount":[],"order_room":[{"room_id":"757","room_code":"O33","retail_price":"998.0","discounted_price":"998.00","location_id":"2"}],"roughly_size":"12","total_retail_price":998,"total_discounted_price":998,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":998,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-09","rent_from":"2020-05-09","rent_to":"2020-06-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 7, 2020. Storage deposit transferred A14-CT207571 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":998,"final_order_total":998,"location_id":"2","branch_id":"1","company_id":"1","room_key":"054,47889","order_product":[],"pass":true}},"first_order_id":"4700","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> O33 <\/td>\r\n\t\t\t\t\t 4X3X8 <\/td>\r\n\t\t\t\t\t $998.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"12","total_discounted_price":"998.0","deposit":"0","total_retail_price":"998.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","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",418,"NEW","A14-CT207798",998,998,0,0,"1","1",998,998,998,"2020-05-07 16:15:33","0",null,null,null,"2020-05-09","2020-06-08","1 month contract. Storage rental paid by bank transfer on May 7, 2020. Storage deposit transferred A14-CT207571 to this agreement.\r\n","2020-05-09","12",0,null,0,"0","2","2020-05-07 16:15:32","2","2020-05-07 16:15:32","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"054,47889","C170418","PERSONAL","Ms","OSpwVZLaj11jKWHakE7sQg==","vCxOlXQuvOQaoL822H2o\/Q==","","hI6IrHjcy5pLAjEBRvfJ4609cWRuORlDVf1yu6P5hRnRjvCLtw+B8QJk\/h1VC39A","+X1wpo4tNWX3Q8nWqGEQTw==",null,"1j94IrN7Ua\/hHPZd+nL1Ig==",null,1,"4700"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","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":["7798","757","998.0","998.00","2","2020-05-07 16:15:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-09","2020-06-08","757"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 16:15:33","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":["7798",418,"SETTLED","A14-I208127","2020-05-07 16:15:32","2020-05-09","2","2020-05-07 16:15:32","2","2020-05-07 16:15:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","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":["8127","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-05-07 16:15:32","2","2020-05-07 16:15:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8127"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 16:15:33","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":[418,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207772","2020-05-07 16:15:32",998,"2","2020-05-07 16:15:32","2","2020-05-07 16:15:32","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","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":["7772","DEPOSIT",null,"PAID","2020-05-07 16:15:32",0,"2","2020-05-07 16:15:32","2","2020-05-07 16:15:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 16:15:33","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":["7772","INVOICE","8127","PAID","2020-05-07 16:15:32",998,"2","2020-05-07 16:15:32","2","2020-05-07 16:15:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:44:10","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":"filter1=2&filter2=1375&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1392","master_room_id":"191","room_code":"C15-086"}],"selected_room_tr":"\n\t\t\t\t\t\t\t\t\t\t\t \u9078\u64c7\u8ff7\u4f60\u5009<\/td>\n\n\t\t\t\t\t\t\t\t\t\t\t \n\t\t\t\t\t\t\t\t\t\t\t\t \n\n\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-168 <\/td>\n\t\t\t\t\t 4X3X6.5 <\/td>\n\t\t\t\t\t $810.00 <\/td>\n\t\t\t\t - <\/td> \u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ \u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr> C15-086 <\/td>\n\t\t\t\t\t 8.9X4.5X6.5 <\/td>\n\t\t\t\t\t $2168.00 <\/td>\n\t\t\t\t N\/A <\/td> <\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \n\t\t\t\t\t\t\n\t\t\t\t\t<\/td> \u522a\u9664<\/button><\/td><\/tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\n\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"D383352(7)","title":"Mr","lastname":"Wong","firstname":"Wah Chak William","companyname":"","email":"wahchakwong@yahoo.com.hk","tel":"97826638","address":"Flt 30, 7\/F Chun Tak Hse, Lung Tak Court, 52 Cape Road, Stanley. HK","pass":true,"customer_id":"990","customer_code":"C180990","customer_first_order":false},"2":{"order_discount":[{"master_room_discount_id":"408 available_room_list_input","master_room_id":"167","discount_type":"%","price":"810.00","disocunted_price":"770.00","discount":"4.94","monthly_deduct":40.014,"room_id":"1474","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1474","room_code":"C15-168","retail_price":"810.0","discounted_price":770,"location_id":"6"},{"room_id":"1392","room_code":"C15-086","retail_price":"2168.0","location_id":"6"}],"roughly_size":"52.05","total_retail_price":2978,"total_discounted_price":3936,"deposit":3936,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":9840,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"5904.00","warehousing_date":"2020-05-20","rent_from":"2020-05-20","rent_to":"2020-08-19","delivery_service":"0","remark":"3 months contract. Special offer 50% off for the first 3 months. $1968\/month. Deposit $1000 paid by bank transfer on Apr 08,2020. The balance of storage rental and deposit $8840 paid by bank transfer on May 06,2020.","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":5904,"order_total":15744,"final_order_total":9840,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012491589","order_product":[],"pass":true}},"roughly_size":"52.05","total_discounted_price":"3936.00","deposit":"3936.00","total_retail_price":"2978.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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` = ?","parameters":["1","3","6","990","NEW","C15-CT207799",2978,3936,3936,0,"3","3",9840,15744,9840,"2020-05-07 18:48:59","0",null,null,null,"2020-05-20","2020-08-19","3 months contract. Special offer 50% off for the first 3 months. $1968\/month. Deposit $1000 paid by bank transfer on Apr 08,2020. The balance of storage rental and deposit $8840 paid by bank transfer on May 06,2020.","2020-05-20","52.05",0,null,5904,"5904.00","2","2020-05-07 18:48:58","2","2020-05-07 18:48:58","BANKIN","","","","BANKIN","","","",null,0,"0012491589","C180990","PERSONAL","Mr","Lg4gDisiPu9XB4rIWAv2SO2CKFF6eFodTC9epVx8zAY=","hULSwM2MvFtpeV9\/z+er8Q==","","M7FmrjLZsKvgYn1vBCFSaRZ3CHXacdCHhz\/Xosd6K4WhgkP\/RJP98zy+KVfJGltT5A2iNjMja1nY8tKa660YltdaLMYdrS398HzFPzHP9KA=","jllZh8GcNSpS5sq8a16+lQ==","OErNiC+zqMy663Zzw89ivWNjHBphEr\/OhUy68\/WgC7o=","VIdCq9pvJl3JtXLm8AlfvQ==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["7799","408 available_room_list_input","167","1474","%","4.94",40.014,"2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["7799","1474","810.0",770,"2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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-05-20","2020-08-19","1474"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 18:48: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":["7799","1392","2168.0",null,"2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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-05-20","2020-08-19","1392"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 18:48:59","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":["7799","C15-D205400","PAID",3936,0,"2020-08-19","2020-05-07 18:48:58","2020-05-07 18:48:58","2","2020-05-07 18:48:58","2","2020-05-07 18:48:58","990"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["7799","990","SETTLED","C15-I208128","2020-05-07 18:48:58","2020-05-20","2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["8128","RENT","\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",1,0,"MO","1",0,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["8128","RENT","\u975e\u6574\u6578\u6263\u6e1b\u5df2\u4ed8\u6b3e\u9805",2,1968,"MO","1",1968,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["8128","RENT","\u9810\u7e73\u79df\u91d1",3,3936,"MO","1",3936,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48:59","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5904,0,"8128"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 18:48: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":["990","BANKIN","","","","BANKIN","","","","PAID","P207773","2020-05-07 18:48:58",9840,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["7773","DEPOSIT","5400","PAID","2020-05-07 18:48:58",3936,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:48: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":["7773","INVOICE","8128","PAID","2020-05-07 18:48:58",5904,"2","2020-05-07 18:48:58","2","2020-05-07 18:48:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:46","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=503&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1746","master_room_id":"233","room_code":"WC-23"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":197,"customer_code":"C160197","identity_type":"PERSONAL","identity_id":"Z085409(4)","title":"Mr","lastname":"Law","firstname":"Tsz Ching","companyname":"","email":"lawrickylaw@hotmail.com","tel":"67624616","address":"Room 1333, Wah Tai House, Wah Fu Estate,","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1038.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-08","renew_room_key":"055,49178","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 06, 2020. Storage deposit transferred from agreement A12-CT207341 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT207573, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"8","order_discount":[],"order_room":[{"room_id":"9","room_code":"A09","retail_price":"1098.0","discounted_price":"1098.00","location_id":"1"}],"roughly_size":"16","total_retail_price":1098,"total_discounted_price":1038,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1038,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-08","rent_from":"2020-05-08","rent_to":"2020-06-07","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on May 07, 2020. Storage deposit transferred from agreement A12-CT207573 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1038,"final_order_total":1038,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,49178","order_product":[],"pass":true}},"first_order_id":"4726","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> A09 <\/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":"1038.0","deposit":"0","total_retail_price":"1098.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","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",197,"NEW","A12-CT207800",1098,1038,0,0,"1","1",1038,1038,1038,"2020-05-07 18:54:47","0",null,null,null,"2020-05-08","2020-06-07","1 month contract. Storage rental paid by bank transfer on May 07, 2020. Storage deposit transferred from agreement A12-CT207573 to this agreement.\r\n","2020-05-08","16",0,null,0,"0","2","2020-05-07 18:54:46","2","2020-05-07 18:54:46","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"055,49178","C160197","PERSONAL","Mr","QdEpSylbNMmKejWwEKzDPw==","+moojSUkRE7zuOzLVjRSfQ==","","Nr+zhfcoLZkHs9ekiRB6i9AgkplBFpfkAfkodley4x6sTiCKQDPoQ4LUK0oajT+t","3D\/wzZyg4xuj9bzd1GAt9w==","Cbe7u6XSUPpS1n9ngHhxxux6MAYDMIc9OYuK+Y9HXRo=","2\/lw76RIZjw\/yt0JiFTl9A==",null,1,"4726"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","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":["7800","9","1098.0","1098.00","2","2020-05-07 18:54:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-05-08","2020-06-07","9"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-05-07 18:54:47","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":["7800",197,"SETTLED","A12-I208129","2020-05-07 18:54:46","2020-05-08","2","2020-05-07 18:54:46","2","2020-05-07 18:54:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","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":["8129","RENT","\u9810\u7e73\u79df\u91d1",1,1038,"MO","1",1038,"2","2020-05-07 18:54:46","2","2020-05-07 18:54:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1038,0,"8129"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-05-07 18:54:47","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":[197,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P207774","2020-05-07 18:54:46",1038,"2","2020-05-07 18:54:46","2","2020-05-07 18:54:46","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","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":["7774","DEPOSIT",null,"PAID","2020-05-07 18:54:46",0,"2","2020-05-07 18:54:46","2","2020-05-07 18:54:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-05-07 18:54:47","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":["7774","INVOICE","8129","PAID","2020-05-07 18:54:46",1038,"2","2020-05-07 18:54:46","2","2020-05-07 18:54:46"]},"data_before":[],"data_after":[],"step":1} *****