DeXun/fad_oa
9
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
fad_oa/script/sql/20241120数据备份/sys_oa_contract.sql

42 lines
27 KiB
SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1745079840244228097, null, 'num20001', '*****项目', '***实业有限公司', '张三', '15609712255', '测试', '李四', '15609712299', '20000.00 贰万元整', '2024-10-01 11:40:32', '2024年10月至2025年9月', '0', '0', '1762094605965365249', '', 'admin', '2024-10-03 09:35:19', 'admin', '2024-10-12 17:23:13');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1763591844520939521, 1754790783681171457, '7666', '城东区区属学校网络提升改造、曹家寨学校智慧校园建设及设备购置项目', '城东区', '张老师', '13678093521', '青海澳达实业有限公司', '洪总', '13289753820', '4690000.00', '2024-03-19 11:40:08', '', '2', '0', '1770284713240866817', '', 'admin', '2024-10-03 09:35:19', 'zss', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1763873556433887233, 1757616490459336706, '000098', '某项目的合同3', '甲方公司名称', '张三', '15609872235', '乙方公司名称', '李四', '13299998888', '12.00', '2024-03-02 18:26:21', '六个月', '2', '0', null, '没有备注', 'admin', '2024-10-03 09:35:19', 'admin', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1763874853874720769, 1757616490459336706, 'r', '某项目的标题合同合同策划师', '4', 'r', 'r', 'r', 'r', 'r', '33.00', '2024-03-02 18:31:43', 'rr', '1', '0', null, '55', 'admin', '2024-10-03 09:35:19', 'admin', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1770282803121270786, 1754790783681171457, '', '课桌椅采购', '青海澳达实业有限公司', '洪总', '18194796720', '某某教学设备有限公司', '', '', '30000.00', '2024-03-12 00:00:00', '', '1', '0', '1770285161779736577', null, 'zss', '2024-10-03 09:35:19', 'zss', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1770285728786722817, 1754790783681171457, '', '饮水机采购', '青海澳达', '洪总', '123456677899', '某某饮水设备有限公司', '某某', '135775689399', '100000.00', null, '', '1', '0', '1770285719857049601', null, 'zss', '2024-10-03 09:35:19', 'zss', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772093816493748225, 1772091887814356994, 'qhzh2022-19', '2022年义务教育薄弱环节改善与能力提升教育装备及信息化项目   包一', '海东市平安区教育局', '王老师', '0972-8610977', '青海澳达实业有限公司', 'z', '15597014621', '1937000.00元 壹佰玖拾叁万柒仟元整', '2022-12-16 00:00:00', '2年', '2', '0', '1772098057782341633', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772100515774509058, 1772097437482528769, ' QHTX-2023-001', '循化县三级物流体系统仓共配建设运营项目', '循化撒拉族自治县工业商务和信息化局', '韩主任', '13909728811', '/', '/', '/', '967000.00元 玖拾陆万柒仟元整', '2023-03-09 00:00:00', '1年', '2', '0', '1772099847403778050', '/', 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772117419436191745, 1772116024616202242, 'QHZZ-2023-010', '民和回族土族自治县教育局民和县2023年义务教育薄弱环节改善与能力提升“因素法”项目 （包三）', '民和回族土族自治县教育局', '李老师', '0972-8516952', '青海澳达实业有限公司', 'z', '15597014621', '1760000.00元、壹佰柒拾陆万元整', '2023-07-11 00:00:00', '1年', '2', '0', '1797453484791377921', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772145772356612097, 1772143081001758722, '', '西宁市世纪职业技术学校信息技术建设项目', '西宁市世纪职业技术学校', '池老师', '0971-4710522', '青海澳达实业有限公司', 'z', '15597014621', '3338700.00元、叁佰叁拾叁万捌仟柒佰元整', '2023-11-01 00:00:00', '1年', '2', '0', '1797455337948131330', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772147224219136001, 1772143887566417921, '', '西宁市沈那中学多功能厅电子显示屏及录播教室建设项目', '西宁市沈那中学', '王老师', '0971-4290360', '青海澳达实业有限公司', 'z', '15597014621', '115.8万 、壹佰壹拾伍万捌仟元整', '2023-10-28 00:00:00', '3年', '2', '0', '1797455509126066178', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772153173856137217, 1772091887814356994, 'H2310200091', '教学平台-购销合同', '青海澳达实业有限公司', 'z', '15597014621', '杭州海康威视科技有限公司', '鲍金鑫', '17280750081', '145940.00元 壹拾肆万伍仟玖佰肆拾元整', '2023-10-20 00:00:00', '', '1', '0', '1772153075524874242', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772156467957641218, 1772091887814356994, 'SSJC20230613-02', '智慧黑板-购销合同书', '青海澳达实业有限公司', 'z', '15597014621', '青海盛视佳创商贸有限公司', 'x', '123', '1082600.00元 壹佰零捌万贰仟陆佰元整', '2023-06-14 00:00:00', '3年', '1', '0', '1789857736654557185', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772182913165996033, 1772097437482528769, 'HBTJ20230311A-1', '老虎车-推车合同', '青海澳达实业有限公司', 'z', '15597014621', '湖北晨奕辰科技有限公司', '/', '07283325570', '3058.00元 叁仟零伍拾捌元整', '2023-03-11 00:00:00', '', '1', '0', '1772182855490121730', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772186143438581761, 1772097437482528769, '', '自动分拣设备项目合同', '青海澳达实业有限公司', 'z', '15597014621', '杭州溪鸟物流科技有限公司', '贺松旺', '15536527416', '470000.00元 肆拾柒万元整', '2023-04-26 00:00:00', '2年', '1', '0', '1772186068155019266', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772456545519841282, 1772097437482528769, '', '安检机设备购销合同', '青海澳达实业有限公司', 'z', '15597014621', '东莞市金眼智能科技有限公司', '/', '/', '52000.00元 伍万贰仟元整', '2023-03-08 00:00:00', '1年', '1', '0', '1772456509616599042', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772465182178979842, 1772097437482528769, 'LXD20230308002', '两节伸缩机-设备买卖合同', '青海澳达实业有限公司', 'z', '15597014621', '河南硕礼自动化设备有限公司', '李笑地', '15838010961', '50000.00元 伍万元整', '2023-03-08 00:00:00', '1年', '1', '0', '1772465152265203713', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772470968703692802, 1772097437482528769, '2303013', '护栏网-销售合同', '青海澳达实业有限公司', 'z', '15597014621', '安平县烩烁丝网制品有限公司', '/', '15369851010', '10082.00元 壹万零捌拾贰元整', '2023-04-17 00:00:00', '', '1', '0', '1772470958310207490', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772506911661797378, 1772091887814356994, 'H2309122770', '录播课堂-购销合同', '青海澳达实业有限公司', 'z', '15597014621', '杭州海康威视科技有限公司', '鲍金鑫', '17280750081', '211233.00元 贰拾壹万壹仟贰佰叁拾叁元整', '2023-09-14 00:00:00', '', '1', '0', '1772506893072642049', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772511746264051713, 1772116024616202242, '', '实验室设备-购销合同', '青海澳达实业有限公司', 'z', '15597014621', '浙江东一实验室设备有限公司', '/', '/', '100880.00元 壹拾万零捌佰捌拾元整', '2023-07-14 00:00:00', '', '1', '0', '1772511719395340290', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772528498360365058, 1772116024616202242, '', '升降桌椅、高低床-供销定购合同', '青海澳达实业有限公司', 'z', '15597014621', '浙江旺力教学设备有限公司', '丁宁', '18157888978', '141000.00元 壹拾肆万壹仟元整', '2023-07-13 00:00:00', '', '1', '0', '1772528489682350082', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772530352293064705, 1772116024616202242, 'SY-20230822', '地理-销售合同', '青海澳达实业有限公司', 'z', '15597014621', '甘肃思源网络科技有限公司', '杨飞雄', '/', '84000.00元 捌万肆仟元整', '2023-08-22 00:00:00', '1年', '1', '0', '1772530343795404802', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772796124865146882, 1772116024616202242, 'JSH-AD-20230822-01', '音乐-销售合同', '青海澳达实业有限公司', 'Z', '15597014621', '金三惠（青岛）科技有限公司', '/', '17710875603', '79000.00元 柒万玖仟元整', '2023-08-22 00:00:00', '1年', '1', '0', '1779683693452214273', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772797725864538113, 1772116024616202242, 'GCSM-2023071101', '美术-销售合同', '青海澳达实业有限公司', 'z', '15597014621', '甘肃共创数煤科技有限公司', '杨', '0931-8896285', '74000.00元 柒万肆仟元整', '2023-08-22 00:00:00', '1年', '1', '0', '1772797713105465345', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772799238150205441, 1772116024616202242, '', '朗威数字化信息系统实验室销售合同', '青海澳达实业有限公司', 'z', '15597014621', '山东远大朗威教育科技股份有限公司', '董星才', '0531-88565204', '97000.00元 玖万柒仟元整', '2023-08-24 00:00:00', '3年', '1', '0', '1772799212636254209', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772800509359861761, 1772116024616202242, 'DHDZ20231130', '电脑-产品购买合同', '青海澳达实业有限公司', 'Z', '15597014621', '青海得华电子有限公司', '/', '0971-6111011', '35280.00元 叁万伍仟贰佰捌拾元整', '2023-11-30 00:00:00', '3年', '1', '0', '1772800494419750914', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772808773048905729, 1772143081001758722, 'DHDZ20231106', '电脑-产品购买合同', '青海澳达实业有限公司', 'z', '15597014621', '青海得华电子有限公司', '/', '0971-6111011', '1563650.00元、壹佰伍拾陆万叁仟陆佰伍拾元整', '2023-11-06 00:00:00', '3年', '1', '0', '1772808759895568386', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772810141109235713, 1772143081001758722, '', '大疆无人机采购合同', '青海澳达实业有限公司', 'z', '15597014621', '西宁王府井海湖购物中心有限责任公司', '/', '0971-4311206', '6572.00元、陆仟伍佰柒拾贰元整', '2023-11-11 00:00:00', '1年 ', '1', '0', '1772810125649031169', '保险：2年', 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772810982956380161, 1772143081001758722, '', '打印机-供货合同', '青海澳达实业有限公司', 'z', '15597014621', '西宁智博电子科技有限公司', '党永娟', '0971-6113371', '2700.00元、贰仟柒佰元整', '2023-11-13 00:00:00', '1年', '1', '0', '1772810970763538434', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772870644078653442, 1772143081001758722, '', '虚拟现实内容制作软件-销售合同', '青海澳达实业有限公司', 'z', '15597014621', '青海微阿信息科技有限公司', '金恒宇', '15735117196', '165000.00元、壹拾陆万伍仟元整', '2023-12-02 00:00:00', '1年', '1', '0', '1772870627968331778', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772872521495261185, 1772143887566417921, 'SSJC20231107-02', '一体机-购销合同书', '青海澳达实业有限公司', 'z', '15597014621', '青海盛视佳创商贸有限公司', '/', '/', '13500.00元、壹万叁仟伍佰元整', '2023-11-07 00:00:00', '3年', '1', '0', '1772872513446391809', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772874073270300673, 1772143887566417921, 'XSDD-V1820231103001', '录播系统-购销合同', '青海澳达实业有限公司', 'z', '15597014621', '广州市奥威亚电子科技有限公司', '李树娜', '020-37885228', '82400.00元、捌万贰仟肆佰元整', '2023-11-10 00:00:00', '3年', '1', '0', '1772874060297318401', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772875019626917890, 1772143887566417921, '2023111002', '鑫视丽讲台-产品买卖合同', '青海澳达实业有限公司', 'z', '15597014621', '河北恒鑫教学设备有限公司', '周建国', '18631881878', '1300.00元、壹仟叁佰元整', '2023-11-10 00:00:00', '1年', '1', '0', '1772875009002745858', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772876765489180674, 1772143887566417921, 'TYST-ADSY20231111', '题词软件-销售合同', '青海澳达实业有限公司', 'z', '15597014621', '北京天影视通科技有限公司', '李云霞', '151108248695', '850.00元捌佰伍拾元整', '2023-11-11 00:00:00', '1年', '1', '0', '1772876751228547073', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772877507407032322, 1772143887566417921, '', '创维电视-电子产品购销合同', '青海澳达实业有限公司', 'z', '15597014621', '西宁市城西区青宁电子产品经销部', '/', '13997201366', '3440.00元、叁仟肆佰肆拾元整', '2023-11-20 00:00:00', '', '1', '0', '1772877496078217217', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1772878347261882369, 1772143887566417921, '', '标准化考点设备及听力设备-产品供销合同', '青海澳达实业有限公司', 'z', '15597014621', '青海瑞众恒业信息技术有限公司', '焦成林', '111', '17890.00元、壹万柒仟捌佰玖拾元整', '2023-11-21 00:00:00', '', '1', '0', '1772878334154682370', null, 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1782246547833372673, null, '', '产品买卖合同', '*有限公司', 'ww', '/', '*实业有限公司', 'z', '15597014621', '23300.00', '2024-04-11 00:00:00', '', '0', '0', '1782244998885294082', '发票已开（4.19开进）', 'lmx', '2024-10-03 09:35:19', 'admin', '2024-10-12 17:23:46');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1795998688200867842, 1795992349147906049, '20240525001', '幼儿园设备-采购合同', '青海澳达实业有限公司', '郑建皖', '15597014621', '江苏玉河教玩具有限公司', '张文彬', '18066015888', '260179.9元，贰拾陆万零壹佰柒拾玖元玖角元整', '2024-05-25 00:00:00', '1年', '1', '0', '1795998681636782082,1796343813833699329', '发票已开260179.9元', 'lmx', '2024-10-03 09:35:19', 'lmx', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1797440563042529281, 1795992349147906049, ' CZ-2024-023', '项目合同书', '市教育局', '王老师', '0977-827777777', '实业有限公司', 'z', '15500008888', '126850 .00元', '2024-05-21 00:00:00', '1年', '2', '0', '1797438013086052354,1800719377084395521', '剩余合同总价款的5%', 'lmx', '2024-10-03 09:35:19', 'admin', '2024-10-03 09:35:19');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1848630326940610561, null, '2024-07-80001', '工矿产品购销合同', '看看', '李四', '456', '昆山', '张三', '123', '100', '2024-10-16 00:00:00', '', '0', '0', null, null, 'boss', '2024-10-22 15:39:50', 'boss', '2024-10-22 15:39:50');
INSERT INTO fad_oa.sys_oa_contract (contract_id, project_id, contract_num, contract_name, first_name, first_person, first_phone, second_name, second_person, second_phone, contract_price, sign_time, validity, contract_type, contract_status, accessory, remark, create_by, create_time, update_by, update_time) VALUES (1852590534812577793, 1852590281594056706, '', 'demo项目合同测试', '河北科技大学', 'hdka', '15690169553', 'fad', '吴', '15530663382', '200000', '2024-11-02 00:00:00', '12个月', '2', '0', null, '吴', 'admin', '2024-11-02 13:56:18', 'admin', '2024-11-02 13:56:18');
Reference in New Issue View Git Blame Copy Permalink