新客户变成业务流程用的的私有参数
<pre><code class="language-sql"></code></pre>
<p>--全局参数
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','fanh_recalc_order','0','客户退货需要重新计算订单');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','order_saleplan_def','1','订单--上货计划默认值');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','chuzk_debit_mode','2','储值卡金额扣除方式，1为先扣除赠送部分，2为先扣除实充部分，3为按金额比例扣');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_yinglk_type1','乐收银','收银银联卡卡别1');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_yinglk_type2','快钱','收银银联卡卡别2');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_yinglk_type3','VISA','收银银联卡卡别3');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_yinglk_type4','银联','收银银联卡卡别4');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_shiwlq_type1','生日优惠券','收银实物礼券券别1');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_shiwlq_type2','抵用券','收银实物礼券券别2');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_shiwlq_type3','实物礼券','收银实物礼券券别3');
insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','retail_shiwlq_type4','礼品卡','收银实物礼券券别4');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','ckscan_chukfah','0','是否启用仓库扫描发货流程中出库发货环节');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','sales_diaobsq_autoverify','1','外部调拨申请是否自动确认');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_display_custinfo','1','POS界面默认采集顾客信息');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_vip_xf_sale','0','会员积分兑换消分分数能否超过本单金额');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_scan_mobilefix','139,138,137,136,135,134,159,158,152,151,150,157,188,187,130,131,132,155,156,186,185,133,153,189,180,','POS扫描手机号段检测(,分隔)');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pand_tz_havenopand','0','盘点调整是否包含未盘点的款');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','rpt_shopmonthlook_msgurl','','店铺月看板任务消息URL');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_tuih_haveselectdoc','1','POS退换货是否需要选择历史小票');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_shop_haverj','1','POS是否必须日结');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','scanbarcode_checkrepeat','0','条码是否能重复扫描');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','storemonth_auto_check','1','月结是否自动审核');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pand_txt_format','','盘点导入盘点枪文件的格式');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_sendshortmsg_viphavewx','1','会员已绑定微信是否发送短信');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','r_sizeadd_autoaddspdm','1','尺码组增加尺码后自动增加商品明细表');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_mobile_dpp_vipkk','0','是否允许同一手机号在不同品牌店开卡');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','pose_vipkk_canrepvip','0','POS会员开卡是否允许填写介绍会员');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','vip_set_sleep_days','180','沉睡会员时间设置(XX天未消费)');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','upgrade_downloadurl','','自动升级下载地址');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','storemonth_calcqc_autochk','0','期初计算是否审核');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','companyname','','公司名称');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes)
values('00000','print_showdialog','1','打印前是否弹出选择打印机对话框');</p>
<p>--私有参数
insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'shopid','','组织默认店仓',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='shopid');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'parentid','','外部调拨、返货出库时上级组织',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='parentid');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'inner_diaob_type','2','0:仓库到仓库间调拨;1:店铺到店铺间调拨;2:仓库到店铺间调拨',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='inner_diaob_type');</p>
<p>--insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
--select companyid,'fhtzTfhrk','','返货入库通知直接转到返货入库,参数填V1',0
--from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='fhtzTfhrk');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'fhtzTfhrk_autork','0','返货入库通知直接转到返货入库并自动入库',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='fhtzTfhrk_autork');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_peih_autoverify','1','配货单验收后是否自动审核',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_peih_autoverify');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_buh_autoverify','0','补货(发货申请、补货商城、补货APP)单验收后是否自动审核',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_buh_autoverify');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_tuihtz_autoverify','1','退货通知单(扫描)验收后是否自动审核',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_tuihtz_autoverify');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_fanhsq_sh_to_fhrk','','退货通知单流程(0:店铺先出V1:店铺仓库同时出入V2:仓库先入)',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_fanhsq_sh_to_fhrk');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_peih1_self_way','1','直营客户订单配货方式(1:按店 2:按客户)',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_peih1_self_way');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'sales_peih1_cust_way','1','加盟客户订单配货方式(1:按店 2:按客户)',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='sales_peih1_cust_way');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'ware_fanhruk_boh_crtchuk','1','客户退货入库驳回商品是否生成出库单(1生成 0不生成)',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='ware_fanhruk_boh_crtchuk');</p>
<p>insert into s_argutbl(companyid,arguid,arguname,notes,n_leix)
select companyid,'samecompany_shop_cgordb','1','同组织下店仓发货走采购还是调拨流程(1采购 0调拨)',0
from s_company where companyid not in (select distinct companyid from s_argutbl where companyid<>'00000' and arguid='samecompany_shop_cgordb');</p>
<p>insert into g_inputdict(c_biaom,c_zidm,c_zidz)
select 'g_dict','c_xilbh','大类' union all
select 'g_dict','c_kuansbh','小类' union all
select 'g_dict','c_nianfbh','年份' union all
select 'g_dict','c_jijbh','季节' union all
select 'g_dict','c_kuanlb','版型' union all
select 'g_dict','c_xiaojj','波段' union all
select 'g_dict','source','风格' union all
select 'g_dict','c_baozfs','薄厚' union all
select 'g_dict','c_sejsxm','成份' union all
select 'g_dict','item21','五金件' union all
select 'g_dict','item22','功能' union all
select 'g_dict','item24','价格段' union all
select 'g_dict','item25','品类' union all
select 'g_dict','btnSave','提交' union all
select 'g_dict','btnTempPost','存成草稿' union all
select 'g_dict','btnLoadTemp','载入草稿' union all
select 'g_dict','btnClearData','清空';
``</p>
<pre><code></code></pre>