搜索新增说明
>s 字段,between 代表传值类型为数值,数值，如money,between，传值0,100
字段,date 代表传值为时间区间,如createtime,date，传值1668578498000-166857896000
1.供应商管理
>d [
'id','name,like','cate_id','no,like','mobile,like','contact,like','address,like', 'reg_money,between','staff_count,like','tax_count,like','tax_desc,like','tax_rate,between','deposit,between',
'company,like','bank_account,like','bank_name,like','bank_code,like','company_user,like','company_mobile,like','rate_qua,between','rate_sam,between','label,like','level,like','createtime,date'
]
2.采购订单-采购单查询-采购中
>d 'order_no,like','date,date,createtime','supply_user_id','pay_num,between',
'buyer_id','stime,date','etime,date','contract,like'
total_pay_price,total_price,total_tex_price
3.采购订单-采购单执行表
>d 'num,between','price,between','arrive_num,between','in_num,between,arrive_num',
'total_price,between','in_price,between','not_num,between','not_price',
'order_no','date,date,createtime','supply_user_id','buyer_id','pay_num,between'
'goods_name,like','goods_no,like','cate_name,like','unit,like'
4.采购付款
>d'order_no', 'supply_user_id', 'date,date,between', 'company_id', 'pay_num'
goods_no，goods_name，pay_time，price，total_price，pay_price，pay_total_price，arrive_num
5.退库管理-入库前
>d 'state_time,between,a.state_time','order_no,like,c.order_no','info_no,=,d.id','date,between,a.createtime', 'goods_no,like,f.goods_no','goods_name,like,f.goods_name','cate_name,like,f.cate_name','num,between,a.num',
'price,between,d.price','supply_user_id,=,c.supply_user_id'
tex_price,total_price
6.退库管理-入库后
>d 'date,date,createtime','order_no,like','num,between','storage_code,like'
'goods_name,like,','goods_no,like','cate_name,like'
7.库存管理-库存管理-库存预警-库存预警
>d usable_num可用库存
8.库存管理-库存预警-批次预警
9.样品库-样品出库
10.报表生成-待发货
type:店铺 1=千年葫芦 2=百艾云集 3=线下
订单状态 $_erp_status = [
0=>'订单审核',
1=>'打单配货',
2=>'验货',
3=>'称重',
4=>'待发货',
5=>'财审',
8=>'已发货',
9=>'交易成功',
11=>'异常结束',
12=>'异常处理',
13=>'配货中',
14=>'预售',
15=>'打包',
16=>'待处理',
10=>'交易关闭',
];
11.报表生成-高层领用
>d goods_price:单价 goods_total_price:金额 lead_price:总经理单价 lead_total_price:总经理金额
12.报表生成-月度销售报表 - 出库报表
>d order_status:订单状态 1=待发货 2=已发货 3=已收货
13.物流费用统计
>d express_rules:物流单价 0=首重 6 续重 1 1= 首重 90 续重 1.5
14.采购差额统计
15.营销方案-营销方案
16.订单中心-订单信息
>d 'form,=,type','order_no,like', 'erp_no,like',
'user_name,like,','user_mobile,like','user_level','user_label,like',
'name,like','mobile,like','address,like','rename,like','remobile,like','topname,like',
'pay_time,date','createtime,date','erp_status'
'goods_name,like,b.goods_name', 'goods_no,like,a.goods_no','goods_num,between,a.num'
17.销售统计汇总
>d 
18.预警提醒-任务下发
>d 'name,like','content,like','createtime,date','end_time,date','group_id'
type,status
19.预警提醒-个人预警
>d 'status','name,like','content,like','noticy_time,date'
20.权限管理-菜单管理
21.权限管理-用户管理
22.个人中心操作日志
>d 'username,like','title,like','url,like','ip,like','useragent,like','createtime,date'
23.数据看板-进销存看板
>d 'goods_name,like', 'goods_no,like', 'goods_num,between'
date,sell_num,in_num
24.会计管理-采购付款明细
25.订单中心-数据汇总-线上商城/线下商城
>d 接口修改为 api/main/statistic/data_list type=1 线上 type=2线下
cate_name=分类名称，total_num=销售总数，total_price=销售总金额，total_num_rate=销售数量占比，total_money_rate=销售金额占比
详情数据修改为 api/main/statistic/data_detail 列表字段类型goods_no=商品编码，goods_name=商品名称，其他同上边
26.订单中心-数据汇总-退换补统计
>d 接口修改为 api/main/statistic/sale_data_list
显示字段 goods_no=商品编码 goods_name=商品名称 sale_type=售后类型 total_num=总数量
total_price =总金额 total_num_rate=总数量占比 total_price_rate= 总金额占比
26.订单中心-售后订单
> 导出接口 api/export/main_sale_order
'form', 'order_no,like', 'sale_type'
'erp_no,like', 'user_name,like,', 'user_mobile,like', 'user_level', 'user_label,like',
'name,like', 'mobile,like', 'address,like'
'goods_name,like,goods_no,like'
status