s.xmzhy.com 更新价格

2019-04-23 15:58:07 阅读:4 编辑
SQL 语句:
UPDATE branches SET mp_price='5099',saas_mp_price='3999',service_price='1799' WHERE project_id in (31,32,34,33,53,35);
UPDATE branches SET mp_price='4099',saas_mp_price='2999',service_price='1299' WHERE project_id not in (31,32,34,33,53,35) and project_id in (select id from projects where is_plugins=0);
UPDATE branches SET mp_price='699',saas_mp_price='',service_price='209' WHERE project_id in (select id from projects where is_plugins=1);
清除 branch_prices 数据
运行命令
PHP artisan sync_branch_prices