Home Explore Help
Sign In
zhangtao
/
programs_info
Watch 1
Star 0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
programs_info
/
苏南邮递项目
/
删除前备份
/
2024年5月9日刘琳琳要求删除
/
3.txt

3.txt 8.9 KB
Permalink History Raw

1234567891011 
  1. INSERT INTO `sunan_industry_park`.`park_contract_manage` (`id`, `project_id`, `project_name`, `enterprise_id`, `enterprise_name`, `examine_id`, `credit_code`, `party_c`, `contract_no`, `contract_no_lease`, `contract_no_property`, `estate_building_room_no`, `contract_type`, `template_type`, `area`, `pay_type`, `start_date`, `end_date`, `retreat_date`, `limit_date`, `limit_month`, `preparation_period`, `signing_date`, `signing_name`, `remark`, `price`, `month_price`, `lease_cycle`, `total_rent`, `first_rent`, `property_management_fee_price`, `monthly_property_management_fee`, `property_cycle`, `total_property_cost`, `bond`, `first_property_management_fee`, `settlement_payment`, `settlement_payment_deadline`, `contract_status`, `settle_in_status`, `bond_status`, `contract_original`, `contract_other`, `project_signing_materials`, `is_renewal`, `renewal_type`, `is_renting_out`, `is_wait_read`, `is_send`, `send_type`, `enterprise_legal_person`, `enterprise_contact_person`, `old_contract_id`, `contract_template_path`, `property_template_path`, `data_source`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES ('1228381669220679680', '', '', 'lGdbYVvymxpU48KWito', '小施测试企业', NULL, '112323456', '', 'HT2024040001', 'HT2024040001-租赁', 'HT2024040001-物业', '1228011574334062592/1228011845080580096/128012915412434944/1228033145878609920', '1', '1', '100', '1', '2024-01-01 00:00:00', '2024-06-30 00:00:00', '2024-06-30 00:00:00', 182, 6.07, '0', '2024-01-01 00:00:00', '小施', '', 10.00, 1000.00, 6.07, 0.6070, 3000.00, 1.00, 100.00, '6.07', 0.0607, 2000.00, 300.00, 5300.00, '2024-01-01 00:00:00', '2', NULL, NULL, '[{\"msg\":\"Success\",\"code\":200,\"data\":\"1228382030807433216\",\"key\":200,\"name\":\"测试上传文件测试测试测试测试.pdf\",\"size\":1978,\"url\":\"https://snkd.idea-sf.com/industryParkApi//FileController/download/1228382030807433216\",\"uid\":1712910700852,\"status\":\"success\"}]', '[]', '[]', '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '/home/project/industry_park/upload/contract/小施测试企业2024041216301220租赁合同.docx', '/home/project/industry_park/upload/property/小施测试企业2024041216301295物业合同.docx', NULL, NULL, '2024-04-12 16:30:12', NULL, '2024-05-09 01:00:00');
    2. 

  2. 

  3. 

  4. INSERT INTO `sunan_industry_park`.`park_contract_manage` (`id`, `project_id`, `project_name`, `enterprise_id`, `enterprise_name`, `examine_id`, `credit_code`, `party_c`, `contract_no`, `contract_no_lease`, `contract_no_property`, `estate_building_room_no`, `contract_type`, `template_type`, `area`, `pay_type`, `start_date`, `end_date`, `retreat_date`, `limit_date`, `limit_month`, `preparation_period`, `signing_date`, `signing_name`, `remark`, `price`, `month_price`, `lease_cycle`, `total_rent`, `first_rent`, `property_management_fee_price`, `monthly_property_management_fee`, `property_cycle`, `total_property_cost`, `bond`, `first_property_management_fee`, `settlement_payment`, `settlement_payment_deadline`, `contract_status`, `settle_in_status`, `bond_status`, `contract_original`, `contract_other`, `project_signing_materials`, `is_renewal`, `renewal_type`, `is_renting_out`, `is_wait_read`, `is_send`, `send_type`, `enterprise_legal_person`, `enterprise_contact_person`, `old_contract_id`, `contract_template_path`, `property_template_path`, `data_source`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES ('1229447760999088128', '', '', 'nkLlEmgPOD07TT3qLa5', '小于测试企业集成有限公司', NULL, 'vghff855544555', '', 'HT2024040002', 'HT2024040002-租赁', 'HT2024040002-物业', '1228011574334062592/1228011845080580096/128012915412434944/1228033145878609920', '2', '1', '100', '1', '2024-01-01 00:00:00', '2024-12-31 00:00:00', '2024-12-31 00:00:00', 366, 12.20, '0', '2024-01-01 00:00:00', '小王', '', 10.00, 1000.00, 12.20, 1.2200, 3000.00, 1.00, 100.00, '12.20', 0.1220, 2000.00, 300.00, 5300.00, '2024-01-01 00:00:00', '2', NULL, NULL, '[{\"msg\":\"Success\",\"code\":200,\"data\":\"1229447838644043776\",\"key\":200,\"name\":\"测试上传文件.docx\",\"size\":10198,\"url\":\"https://snkd.idea-sf.com/industryParkApi//FileController/download/1229447838644043776\",\"uid\":1713164815888,\"status\":\"success\"}]', '[]', '[{\"msg\":\"Success\",\"code\":200,\"data\":\"1229447743307513856\",\"key\":200,\"name\":\"测试上传文件测试测试测试测试.pdf\",\"size\":1978,\"url\":\"https://snkd.idea-sf.com/industryParkApi//FileController/download/1229447743307513856\",\"uid\":1713164793183,\"status\":\"success\"}]', '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '/home/project/industry_park/upload/contract/小于测试企业集成有限公司2024041515062898租赁合同.docx', '/home/project/industry_park/upload/property/小于测试企业集成有限公司2024041515062921物业合同.docx', NULL, NULL, '2024-04-15 15:06:28', NULL, '2024-05-09 01:00:00');
    5. 

  5. 

  6. 

  7. INSERT INTO `sunan_industry_park`.`park_contract_manage` (`id`, `project_id`, `project_name`, `enterprise_id`, `enterprise_name`, `examine_id`, `credit_code`, `party_c`, `contract_no`, `contract_no_lease`, `contract_no_property`, `estate_building_room_no`, `contract_type`, `template_type`, `area`, `pay_type`, `start_date`, `end_date`, `retreat_date`, `limit_date`, `limit_month`, `preparation_period`, `signing_date`, `signing_name`, `remark`, `price`, `month_price`, `lease_cycle`, `total_rent`, `first_rent`, `property_management_fee_price`, `monthly_property_management_fee`, `property_cycle`, `total_property_cost`, `bond`, `first_property_management_fee`, `settlement_payment`, `settlement_payment_deadline`, `contract_status`, `settle_in_status`, `bond_status`, `contract_original`, `contract_other`, `project_signing_materials`, `is_renewal`, `renewal_type`, `is_renting_out`, `is_wait_read`, `is_send`, `send_type`, `enterprise_legal_person`, `enterprise_contact_person`, `old_contract_id`, `contract_template_path`, `property_template_path`, `data_source`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES ('1229448216412422144', '', '', 'lGdbYVvymxpU48KWito', '小施测试企业', NULL, '112323456', '', 'HT2024040003', 'HT2024040003-租赁', 'HT2024040003-物业', '1228011574334062592/1228011845080580096/128012915412434944/1228033145878609920', '2', '1', '100', '1', '2024-01-01 00:00:00', '2024-12-31 00:00:00', '2024-12-31 00:00:00', 366, 12.20, '0', '2024-01-01 00:00:00', '小施', '', 0.00, 0.00, 12.20, 0.0000, 0.00, 1.00, 100.00, '12.20', 0.1220, 0.00, 300.00, 300.00, '2024-04-15 00:00:00', '7', NULL, NULL, '[]', '[]', '[]', '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '/home/project/industry_park/upload/contract/小施测试企业2024041515081655租赁合同.docx', '/home/project/industry_park/upload/property/小施测试企业2024041515081629物业合同.docx', NULL, NULL, '2024-04-15 15:08:17', NULL, '2024-04-15 15:08:25');
    8. 

  8. 

  9. 

  10. INSERT INTO `sunan_industry_park`.`park_contract_manage` (`id`, `project_id`, `project_name`, `enterprise_id`, `enterprise_name`, `examine_id`, `credit_code`, `party_c`, `contract_no`, `contract_no_lease`, `contract_no_property`, `estate_building_room_no`, `contract_type`, `template_type`, `area`, `pay_type`, `start_date`, `end_date`, `retreat_date`, `limit_date`, `limit_month`, `preparation_period`, `signing_date`, `signing_name`, `remark`, `price`, `month_price`, `lease_cycle`, `total_rent`, `first_rent`, `property_management_fee_price`, `monthly_property_management_fee`, `property_cycle`, `total_property_cost`, `bond`, `first_property_management_fee`, `settlement_payment`, `settlement_payment_deadline`, `contract_status`, `settle_in_status`, `bond_status`, `contract_original`, `contract_other`, `project_signing_materials`, `is_renewal`, `renewal_type`, `is_renting_out`, `is_wait_read`, `is_send`, `send_type`, `enterprise_legal_person`, `enterprise_contact_person`, `old_contract_id`, `contract_template_path`, `property_template_path`, `data_source`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES ('1229448471027646464', '', '', 'lGdbYVvymxpU48KWito', '小施测试企业', NULL, '112323456', '', 'HT2024040004', 'HT2024040004-租赁', 'HT2024040004-物业', '1228011574334062592/1228011845080580096/128012915412434944/1228033145878609920', '2', '1', '100', '1', '2024-01-01 00:00:00', '2024-12-31 00:00:00', '2024-12-31 00:00:00', 366, 12.20, '0', '2024-04-15 00:00:00', '小王', '', 0.00, 0.00, 12.20, 0.0000, 0.00, 1.00, 100.00, '12.20', 0.1220, 0.00, 300.00, 300.00, '2024-04-15 00:00:00', '2', NULL, NULL, '[{\"msg\":\"Success\",\"code\":200,\"data\":\"1229448518616219648\",\"key\":200,\"name\":\"测试上传文件测试测试测试测试.pdf\",\"size\":1978,\"url\":\"https://snkd.idea-sf.com/industryParkApi//FileController/download/1229448518616219648\",\"uid\":1713164978004,\"status\":\"success\"}]', '[]', '[]', '0', NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, '/home/project/industry_park/upload/contract/小施测试企业2024041515091761租赁合同.docx', '/home/project/industry_park/upload/property/小施测试企业2024041515091712物业合同.docx', NULL, NULL, '2024-04-15 15:09:18', NULL, '2024-05-09 01:00:00');
    11. 

  11.