process_sheet/fastadmin/application/sql/ps_market_seed.sql

-- 官方模板 + 商城在售商品（可重复执行）
INSERT INTO `fa_ps_template` (`factory_id`,`creator_user_id`,`name`,`cover`,`source`,`license_type`,`locked`,`source_template_id`,`source_version_id`,`current_version_id`,`is_system`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, '标准生产流程单', '', 'system', 'self', 0, 0, 0, 0, 1, 'normal', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `fa_ps_template` WHERE `is_system`=1 AND `name`='标准生产流程单');

INSERT INTO `fa_ps_template` (`factory_id`,`creator_user_id`,`name`,`cover`,`source`,`license_type`,`locked`,`source_template_id`,`source_version_id`,`current_version_id`,`is_system`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, '带工序质检流程单', '', 'system', 'self', 0, 0, 0, 0, 1, 'normal', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `fa_ps_template` WHERE `is_system`=1 AND `name`='带工序质检流程单');

INSERT INTO `fa_ps_template` (`factory_id`,`creator_user_id`,`name`,`cover`,`source`,`license_type`,`locked`,`source_template_id`,`source_version_id`,`current_version_id`,`is_system`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, '简版投料流程单', '', 'system', 'self', 0, 0, 0, 0, 1, 'normal', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM `fa_ps_template` WHERE `is_system`=1 AND `name`='简版投料流程单');

INSERT INTO `fa_ps_market_goods` (`factory_id`,`seller_user_id`,`template_id`,`template_version_id`,`title`,`cover`,`category`,`intro`,`price_single`,`price_buyout`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, t.id, t.current_version_id, '标准生产流程单', '', '通用', '含工厂、工单、产品、数量与工序列表，适合日常套打。', 20, 80, 'on_sale', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_ps_template` t
WHERE t.name='标准生产流程单' AND t.is_system=1
  AND NOT EXISTS (SELECT 1 FROM `fa_ps_market_goods` g WHERE g.template_id=t.id);

INSERT INTO `fa_ps_market_goods` (`factory_id`,`seller_user_id`,`template_id`,`template_version_id`,`title`,`cover`,`category`,`intro`,`price_single`,`price_buyout`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, t.id, t.current_version_id, '带工序质检流程单', '', '质检', '突出工位、标准工时和质检要点，适合需要过程记录的车间。', 30, 120, 'on_sale', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_ps_template` t
WHERE t.name='带工序质检流程单' AND t.is_system=1
  AND NOT EXISTS (SELECT 1 FROM `fa_ps_market_goods` g WHERE g.template_id=t.id);

INSERT INTO `fa_ps_market_goods` (`factory_id`,`seller_user_id`,`template_id`,`template_version_id`,`title`,`cover`,`category`,`intro`,`price_single`,`price_buyout`,`status`,`createtime`,`updatetime`)
SELECT 0, 0, t.id, t.current_version_id, '简版投料流程单', '', '投料', '按投料大箱拆张，字段精简，适合快速出单。', 10, 50, 'on_sale', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
FROM `fa_ps_template` t
WHERE t.name='简版投料流程单' AND t.is_system=1
  AND NOT EXISTS (SELECT 1 FROM `fa_ps_market_goods` g WHERE g.template_id=t.id);

UPDATE `fa_ps_factory` SET `score`=1000 WHERE `id`=1 AND `score`<1000;