{"created_at":"2020-06-05 11:11:55","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1","floor_plan_rent_room":[{"room_id":"1706","master_room_id":"205","room_code":"A16-215"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":629,"customer_code":"C170629","identity_type":"PERSONAL","identity_id":"D676258(2)","title":"Ms","lastname":"Chan","firstname":"Wai King Dicky","companyname":"","email":"kelly@tiptoptours.com.hk","tel":"91207071","address":"Flat C, 38\/F, Block 19, 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":"1195.0","renew_rent_month":"1","renew_warehousing_date":"2020-05-02","renew_room_key":"052,40523","renew_remark":"1 month contract. Storage rental paid by bank transfer on April 8, 2020. Storage deposit transferred from agreement A18-CT207339 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A18-CT207583, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"107","order_discount":[],"order_room":[{"room_id":"815","room_code":"Q12","retail_price":"1195.0","discounted_price":"1195.00","location_id":"3"}],"roughly_size":"18","total_retail_price":1195,"total_discounted_price":1195,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1195,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-05-02","rent_from":"2020-05-02","rent_to":"2020-06-01","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A18-CT207583 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1195,"final_order_total":1195,"location_id":"3","branch_id":"1","company_id":"1","room_key":"052,40523","order_product":[],"pass":true}},"first_order_id":"4694","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>
Q12 <\/td>\r\n\t\t\t\t\t	3X6X7 <\/td>\r\n\t\t\t\t\t	$1195.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":"1195.0","deposit":"0","total_retail_price":"1195.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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",629,"NEW","A18-CT208056",1195,1195,0,0,"1","1",1195,1195,1195,"2020-06-05 11:11:56","0",null,null,null,"2020-05-02","2020-06-01","1 month contract. Storage rental paid by bank transfer on June 5, 2020. Storage deposit transferred from agreement A18-CT207583 to this agreement.\r\n","2020-05-02","18",0,null,0,"0","2","2020-06-05 11:11:55","2","2020-06-05 11:11:55","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"052,40523","C170629","PERSONAL","Ms","RpXGKsWvjdIh2zpNpZGQoQ==","U9yoE9KqV1v8YlRkf7Q2yg==","","36wRGpAjwc\/0wlF+nTn2W4D7sbMVDfrQcRaUEETc94CbdXOD165sYiJ4w9a0XWwUmn9HdLUPAL5jHBLCynFDtA==","c1f20bJNL7v6HlqVb6xwiw==","09G8cY6xfbNmNlWHMFOaw2MNgdv38UQbp6+QiEm\/fmg=","fShBvH+qXdfrGzN7M8+\/Eg==",null,1,"4694"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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":["8056","815","1195.0","1195.00","2","2020-06-05 11:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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-02","2020-06-01","815"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-05 11:11:56","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":["8056",629,"SETTLED","A18-I208385","2020-06-05 11:11:55","2020-05-02","2","2020-06-05 11:11:55","2","2020-06-05 11:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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":["8385","RENT","\u9810\u7e73\u79df\u91d1",1,1195,"MO","1",1195,"2","2020-06-05 11:11:55","2","2020-06-05 11:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1195,0,"8385"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-05 11:11:56","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":[629,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208028","2020-06-05 11:11:55",1195,"2","2020-06-05 11:11:55","2","2020-06-05 11:11:55","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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":["8028","DEPOSIT",null,"PAID","2020-06-05 11:11:55",0,"2","2020-06-05 11:11:55","2","2020-06-05 11:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:11:56","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":["8028","INVOICE","8385","PAID","2020-06-05 11:11:55",1195,"2","2020-06-05 11:11:55","2","2020-06-05 11:11:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:21:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:23:49","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:06","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","index_url_parameter":"all=1&msg=%E5%8F%96%E6%B6%88","floor_plan_rent_room":[{"room_id":"1706","master_room_id":"205","room_code":"A16-215"}],"_payment_type":"INVOICE","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":246,"customer_code":"C160246","identity_type":"PERSONAL","identity_id":"E669410(5)","title":"Ms","lastname":"Wong","firstname":"Yin Ping","companyname":"","email":"julianawyp@Yahoo.com.hk","tel":"90323387","address":"Flat H,5\/F Block 17,Mei Fai Court South Horizons, Ap Lei Chau","pass":true},"2":{"renew_paymethod2":"PPS","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1139.0","renew_rent_month":"6","renew_warehousing_date":"2020-06-05","renew_room_key":"055,55509","renew_remark":"6 months contract. Storage rental paid by PPS on December 2, 2019. Storage deposit transferred from agreement A12-CT195149 to this agreement.\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT196593, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"10","order_discount":[{"master_room_discount_id":"76","master_room_id":"10","discount_type":"%","price":"1528.00","disocunted_price":"1376.00","discount":"9.95","monthly_deduct":152.036,"room_id":"56","is_final_discount":"0","payment_term":"PREPAID_6_MO"}],"order_room":[{"room_id":"56","room_code":"B04","retail_price":"1528.0","discounted_price":1376,"location_id":"1"}],"roughly_size":"20","total_retail_price":1528,"total_discounted_price":1139,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":6834,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-06-05","rent_from":"2020-06-05","rent_to":"2020-12-04","delivery_service":"0","remark":"6 months contract. Storage rental paid by PPS on June 4, 2020. Storage deposit transferred from agreement A12-CT196593 to this agreement.\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"PPS","discount_deduct":0,"order_total":6834,"final_order_total":6834,"location_id":"1","branch_id":"1","company_id":"1","room_key":"055,55509","order_product":[],"pass":true}},"first_order_id":"3814","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> B04 <\/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":"1139.0","deposit":"0","total_retail_price":"1528.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","1","1",246,"NEW","A12-CT208057",1528,1139,0,0,"6","6",6834,6834,6834,"2020-06-05 11:28:07","0",null,null,null,"2020-06-05","2020-12-04","6 months contract. Storage rental paid by PPS on June 4, 2020. Storage deposit transferred from agreement A12-CT196593 to this agreement.\r\n","2020-06-05","20",0,null,0,"0","2","2020-06-05 11:28:06","2","2020-06-05 11:28:06","NO_NEED_PAID_RENEW","","","","PPS","","","",null,0,"055,55509","C160246","PERSONAL","Ms","LCid1COB1tg1mUcapCB6rQ==","hULSwM2MvFtpeV9\/z+er8Q==","","mIObWhb+7J95Mma1wUdAxoEb8M1GhMGp+3ltd6fEdjXnp1Ej3W+y+RlXRHD43h49kFRl88dNpK7qn8uKBVI1Aw==","yUxNpsMAehInxJPXm3Rl+w==","3ehLEnyTfV7S1FEVZ79XrDueuYsRx3WCndmjcVkU8ng=","5TdeaNCK8VIoKrSgD46SvA==",null,1,"3814"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","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":["8057","76","10","56","%","9.95",152.036,"2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8057","56","1528.0",1376,"2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-05","2020-12-04","56"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8057",246,"SETTLED","A12-I208386","2020-06-05 11:28:06","2020-06-05","2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",1,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",2,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",3,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",4,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",5,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8386","RENT","\u9810\u7e73\u79df\u91d1",6,1139,"MO","1",1139,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[6834,0,"8386"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[246,"NO_NEED_PAID_RENEW","","","","PPS","","","","PAID","P208029","2020-06-05 11:28:06",6834,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8029","DEPOSIT",null,"PAID","2020-06-05 11:28:06",0,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:28:07","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8029","INVOICE","8386","PAID","2020-06-05 11:28:06",6834,"2","2020-06-05 11:28:06","2","2020-06-05 11:28:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:34:53","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:45:32","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 11:58:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 12:15:24","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 12:24:51","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 12:52:48","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","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=598&filter3=undefined&msg=%E5%8F%96%E6%B6%88&msg=%E5%8F%96%E6%B6%88","_payment_type":"INVOICE","floor_plan_rent_room":[],"warehousing":{"1":{"new_customer":0,"identity_type":"PERSONAL","identity_id":"D522909(0)","title":"Mr","lastname":"Lui","firstname":"Cheuk Ho","companyname":"","email":null,"tel":"60381903","address":"Flat\/Rm B, Mei Lun House, 2~4 Mei Lun Street, Central, HK","pass":true,"customer_first_order":true,"customer_id":1185,"customer_code":"C191185"},"2":{"order_discount":[],"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1322.0","renew_rent_month":"1","renew_warehousing_date":"2020-06-01","renew_room_key":"0012516868","renew_remark":"1 month contract. Storage rental paid by bank transfer on Apr 29,2020. Storage deposit $1322 transferred from agreement C15-CT207569 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT207745, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"173","order_room":[{"room_id":"1421","room_code":"C15-115","retail_price":"1322.0","discounted_price":"1322.00","location_id":"6"}],"roughly_size":"24","total_retail_price":1322,"total_discounted_price":1322,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":1322,"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-06-30","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on June 05,2020. Storage deposit $1322 transferred from agreement C15-CT207745 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":1322,"final_order_total":1322,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012516868","order_product":[],"pass":true}},"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-115 <\/td>\r\n\t\t\t\t\t 4X6X6.5 <\/td>\r\n\t\t\t\t\t $1322.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","renew":1,"first_order_id":"4243","roughly_size":"24","total_discounted_price":"1322.0","deposit":"0","total_retail_price":"1322.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1185,"NEW","C15-CT208058",1322,1322,0,0,"1","1",1322,1322,1322,"2020-06-05 14:22:30","0",null,null,null,"2020-06-01","2020-06-30","1 month contract. Storage rental paid by bank transfer on June 05,2020. Storage deposit $1322 transferred from agreement C15-CT207745 to this agreement.","2020-06-01","24",0,null,0,"0","2","2020-06-05 14:22:30","2","2020-06-05 14:22:30","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012516868","C191185","PERSONAL","Mr","\/JQwF1+M6FL7Yun0+bBCFg==","vyCKi4IYWx3VnCZylJM1yA==","","M40cxW4GMmuJRXhcXM+Wt7bO\/WDVLnPGUxgCIY4qYL\/XYrR2lvobKWJ1rPDsF3EoUQ75QxAufkpF6LMIzO2Rkg==","KUOWIMoqsVaNtCRfR6snnQ==",null,"QAJCjnmgSugLsyxdh+ZSuA==",null,1,"4243"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["8058","1421","1322.0","1322.00","2","2020-06-05 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-06-01","2020-06-30","1421"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8058",1185,"SETTLED","C15-I208387","2020-06-05 14:22:30","2020-06-01","2","2020-06-05 14:22:30","2","2020-06-05 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8387","RENT","\u9810\u7e73\u79df\u91d1",1,1322,"MO","1",1322,"2","2020-06-05 14:22:30","2","2020-06-05 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[1322,0,"8387"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1185,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208030","2020-06-05 14:22:30",1322,"2","2020-06-05 14:22:30","2","2020-06-05 14:22:30","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8030","DEPOSIT",null,"PAID","2020-06-05 14:22:30",0,"2","2020-06-05 14:22:30","2","2020-06-05 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 14:22:30","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["8030","INVOICE","8387","PAID","2020-06-05 14:22:30",1322,"2","2020-06-05 14:22:30","2","2020-06-05 14:22:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 15:27:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 15:27:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 15:28:57","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 15:35:09","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:05","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","_payment_type":"INVOICE","floor_plan_rent_room":[],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1239,"customer_code":"C191239","identity_type":"PERSONAL","identity_id":"D644796(2)","title":"Mr","lastname":"CHEW","firstname":"Lai Wing Teresa","companyname":"","email":"tchew9@gmail.com","tel":"67503217","address":"278 King's Road, B15, North Point, Hong Kong","pass":true},"2":{"renew_paymethod2":"CREDIT_CARD","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"998.0","renew_rent_month":"12","renew_warehousing_date":"2020-06-01","renew_room_key":"0012465699","renew_remark":"12 months contract. Storage rental and deposit paid by credit card on April 8, 2019. Additional charge $335. Smartcard provided on April 8, 2019. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT194706, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $1108.0","renew_master_room_id":"171","order_discount":[],"order_room":[{"room_id":"1464","room_code":"C15-158","retail_price":"1108.0","discounted_price":"1108.00","location_id":"6"}],"roughly_size":"16","total_retail_price":1108,"total_discounted_price":998,"deposit":0,"rent_month":"12","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"12","prepaid_amount":11976,"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":"2021-05-31","delivery_service":"0","remark":"12 months contract. Storage rental $11741 paid by wire transfer on May 29,2020. Outstanding $235 deducted from storage deposit. Deposit $873 (after deduction) transferred from agreement C15-CT194706 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":11976,"final_order_total":11976,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012465699","order_product":[],"pass":true}},"first_order_id":4706,"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-158 <\/td>\r\n\t\t\t\t\t 4X4X6.5 <\/td>\r\n\t\t\t\t\t $1108.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":"16","total_discounted_price":"998.0","deposit":"0","total_retail_price":"1108.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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",1239,"NEW","C15-CT208059",1108,998,0,0,"12","12",11976,11976,11976,"2020-06-05 18:35:06","0",null,null,null,"2020-06-01","2021-05-31","12 months contract. Storage rental $11741 paid by wire transfer on May 29,2020. Outstanding $235 deducted from storage deposit. Deposit $873 (after deduction) transferred from agreement C15-CT194706 to this agreement.","2020-06-01","16",0,null,0,"0","2","2020-06-05 18:35:05","2","2020-06-05 18:35:05","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012465699","C191239","PERSONAL","Mr","Gd2Jwnd4bDWB0W7DvFjD+A==","AvrgFmI5FANiXMfrwCf5qw==","","pZEhWY3xqurwEmOyAFbmKKl1Aa1YCcL61g\/C1YHEooNSx0OtYtb4rRFKCc6q12g\/","KWDGPBVWYHGaBEUq07FZ+g==","SoQ+NfzOaVZgpKW9sn0dfOXLc5SpPt8ZjKqQfPULgro=","qb1L0IcuaDjbp1f07h4sqA==",null,1,4706]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8059","1464","1108.0","1108.00","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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","2021-05-31","1464"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-05 18:35:06","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":["8059",1239,"SETTLED","C15-I208388","2020-06-05 18:35:05","2020-06-01","2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",2,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",3,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",4,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",5,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",6,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",7,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",8,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",9,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",10,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",11,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8388","RENT","\u9810\u7e73\u79df\u91d1",12,998,"MO","1",998,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[11976,0,"8388"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-05 18:35:06","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":[1239,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P208031","2020-06-05 18:35:05",11976,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8031","DEPOSIT",null,"PAID","2020-06-05 18:35:05",0,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 18:35:06","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":["8031","INVOICE","8388","PAID","2020-06-05 18:35:05",11976,"2","2020-06-05 18:35:05","2","2020-06-05 18:35:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","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=733&filter3=undefined&msg=%E5%8F%96%E6%B6%88&page=2","floor_plan_rent_room":[],"_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-06-09","renew_room_key":"054,47889","renew_remark":"1 month contract. Storage rental paid by bank transfer on May 7, 2020. Storage deposit transferred A14-CT207571 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: A14-CT207798, \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-06-09","rent_from":"2020-06-09","rent_to":"2020-07-08","delivery_service":"0","remark":"1 month contract. Storage rental paid by bank transfer on Jun 4, 2020. Storage deposit transferred A14-CT207798 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-06-05 19:13:36","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-CT208060",998,998,0,0,"1","1",998,998,998,"2020-06-05 19:13:36","0",null,null,null,"2020-06-09","2020-07-08","1 month contract. Storage rental paid by bank transfer on Jun 4, 2020. Storage deposit transferred A14-CT207798 to this agreement.\r\n","2020-06-09","12",0,null,0,"0","2","2020-06-05 19:13:36","2","2020-06-05 19:13:36","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-06-05 19:13:36","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":["8060","757","998.0","998.00","2","2020-06-05 19:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","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-09","2020-07-08","757"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-06-05 19:13:36","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":["8060",418,"SETTLED","A14-I208389","2020-06-05 19:13:36","2020-06-09","2","2020-06-05 19:13:36","2","2020-06-05 19:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","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":["8389","RENT","\u9810\u7e73\u79df\u91d1",1,998,"MO","1",998,"2","2020-06-05 19:13:36","2","2020-06-05 19:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[998,0,"8389"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-06-05 19:13:36","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","P208032","2020-06-05 19:13:36",998,"2","2020-06-05 19:13:36","2","2020-06-05 19:13:36","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","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":["8032","DEPOSIT",null,"PAID","2020-06-05 19:13:36",0,"2","2020-06-05 19:13:36","2","2020-06-05 19:13:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-06-05 19:13:36","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":["8032","INVOICE","8389","PAID","2020-06-05 19:13:36",998,"2","2020-06-05 19:13:36","2","2020-06-05 19:13:36"]},"data_before":[],"data_after":[],"step":1} *****