DFCH 分析

yxbj 禁用

cfp 下加光

jingpin 精品

tcbl 提成比例

zdzk 最低折扣

cgjg 采购价格

cbjg 成本价格

产品下加光xjg add ray logo

折射率 屈光 refractive

佣金 commission

精品 fine

单位 unit

材质 材料 stuff

折扣 lowest rebate 最低折扣销售部参与提成

goodsid type brand vendor vendorid firmname name py stock stockid refractive stuff origin model unit count cost cost_ave stock_sum buy sale sale_sum commission lowestrebate addraylogo fine

镜片信息

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,refractive,stuff,unit,fine,status,addraylogo,commission,lowestrebate) SELECT spqzid,LEFT(spqzid,1),gysid,pinpai,pinpai,pinyin,zheshelv,caizhi,danwei,jingpin,yxbj,cfp,tcbl,zdzk from gl.qianzhui_jp;

镜架信息

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,stuff,origin,unit,fine,status,commission,lowestrebate) SELECT spqzid,LEFT(spqzid,1),gysid,pinpai,pinpai,pinyin,caizhi,chandi,danwei,jingpin,yxbj,tcbl,zdzk from gl.qianzhui_jj;

隐形眼镜信息

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,model,size,unit,fine,status,addraylogo,commission,lowestrebate) SELECT spqzid,LEFT(spqzid,1),gysid,pinpai,pinpai,pinyin,leixing,guige,danwei,jingpin,yxbj,cfp,tcbl,zdzk from gl.qianzhui_yxyj;

老花镜信息

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,stuff,model,size,unit,fine,status,commission,lowestrebate) SELECT spqzid,LEFT(spqzid,1),gysid,pinpai,pinpai,pinyin,caizhi,xinghao,guige,danwei,jingpin,yxbj,tcbl,zdzk from gl.qianzhui_lhj;

太阳镜信息

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,stuff,origin,unit,fine,status,commission,lowestrebate) SELECT spqzid,LEFT(spqzid,1),gysid,pinpai,pinpai,pinyin,caizhi,chandi,danwei,jingpin,yxbj,tcbl,zdzk from gl.qianzhui_tyj;

护理产品信息 kcxx kcsx

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,model,size,unit,fine,status,commission,lowestrebate,sale,buy,buyave) SELECT spid,LEFT(spid,1),gysid,pinpai,pinpai,pinyin,xinghao,guige,danwei,jingpin,yxbj,tcbl,zdzk,lsjg,cgjg,cbjg from gl.hlcp;

其它产品信息 kcxx kcsx 还有材质和颜色 功能

insert into glg.glg_base_goods(goodsid,type,vendorid,brand,name,py,model,size,unit,fine,status,commission,lowestrebate,sale,buy,buyave) SELECT spid,LEFT(spid,1),gysid,pinpai,pinpai,pinyin,xinghao,guige,danwei,jingpin,yxbj,tcbl,zdzk,lsjg,cgjg,cbjg from gl.qtcp;

镜片产品A

insert into glg.glg_goods_jp(goodsname,goodsid,sph,cyl,cyla,xjg,axis,prism,zyy,yhl,sale,buy,buyave,kcxx,kcsx) SELECT spid,spqzid,sph,cyl,cyla,xjg,zhouwei,lenjing,zyy,yhl,lsjg,cgjg,cbjg,kcxx,kcsx from gl.jp;

镜架产品B

insert into glg.glg_goods_jj(goodsname,goodsid,model,color,yhl,sale,buy,buyave,status,kcxx,kcsx) SELECT spid,spqzid,xinghao,yanse,yhl,lsjg,cgjg,cbjg,yxbj,kcxx,kcsx from gl.jj;

隐形眼镜产品 C开头

insert into glg.glg_goods_yxyj(goodsname,goodsid,code,sph,cyl,cyla,xjg,axis,prism,zyy,yhl,sale,buy,buyave,kcxx,kcsx) SELECT spid,spqzid,code,sph,cyl,cyla,xjg,zhouwei,lenjing,zyy,yhl,lsjg,cgjg,cbjg,kcxx,kcsx from gl.yxyj;

老花镜产品 D开头老花镜

insert into glg.glg_goods_lhj(goodsname,goodsid,code,sph,yhl,sale,buy,buyave,kcxx,kcsx) SELECT spid,spqzid,code,sph,yhl,lsjg,cgjg,cbjg,kcxx,kcsx from gl.lhj;

太阳镜产品E

insert into glg.glg_goods_tyj(goodsname,goodsid,model,color,yhl,sale,buy,buyave,status,kcxx,kcsx) SELECT spid,spqzid,xinghao,yanse,yhl,lsjg,cgjg,cbjg,yxbj,kcxx,kcsx from gl.tyj;

员工 Culturedegree学历 deptid超级用户Z yxbj是否禁用1等于禁用

insert into glg.glg_base_staff(staff_id,staffid,name,sex,race,origin,hunyin,birthday,id_card,degree,address,zip,tel,phone,email,auth,office,indate,details,py,status) SELECT ygid,kahao,name,sex,minzu,jiguan,hunyin,birthdate,shenfenzheng,Culturedegree,address,youbian,phone,shouji,email,deptid,job,registerdate,beizhu,pinyin,yxbj from gl.yuangong;

顾客 zdkh自定卡号 fd不知道

insert into glg.glg_base_guests(name,card,cardtype,age,sex,yue,ri,count,amount,points,phone,tel,address,office,py,details) select name,kahao,hykmc,nian,sex,yue,ri,ljcs,ljje,kyjf,shouji,phone,address,zhiye,pinyin,beizhu from gl.guke;

供应商 qc qcye bqpf qmys qmye 都是钱

insert into glg.glg_base_vendor(uid,name,firmname,leader,area,city,phone,tel,zip,fax,email,address,topic,py,qc,qcye,qmye,bqpf,bqth,operating,banking,bank,details,status) select unitid,name,jiancheng,Linkman,province,city,shouji,phone,postalcode,fax,email,address,homepage,pinyin,qc,qcye,qmye,bqpf,bqth,leibie,bank,Accounts,beizhu,yxbj from gl.gongyingshang;

公司

insert into glg.glg_base_firm(firmname,name,tel,phone,fax,email,zip,address,type,corporatecode,creditcode,bank,bank_card,details) select gsmc,fuzeren,phone,phone,fax,email,youbian,address,qiyeleixing,qiyedaima,qiyedaima,bank,zh,beizhu from gl.gongsi;

库存 cangkuid spid sl pdsl pypk sx xx cbj kcje

insert into glg.glg_stock(stockid,goodsid,number,count,upper,lower,cost,sum) select cangkuid,spid,sl,pdsl,sx,xx,cbj,kcje from glg.kucun;

验光

yanguangid ygje kahao ygyyj rq ywyid dqjcrq c1_r c1_l c2_r c2_l c3_r c3_l c4_r c4_l c5_r c5_l c8_r c8_l c11_r c11_l yx_r yx_l djid1

insert into glg.glg_optometry(optometrynum,number,card,commission,sphericall,sphericalr,cylindricall,cylindricalr,axiall,axialr,nakedl,nakedr,correctionl,correctionr,prisml,prismr,basisl,basisr,addl,addr,originallightl,originallightr,pupilheightl,pupilheightr,pupildistancel,pupildistancer,invisiblel,invisibler,optometryid,optometrydate) select yanguangid,djid1,kahao,ygje,c1_l,c1_r,c2_l,c2_r,c3_l,c3_r,c4_l,c4_r,c5_l,c5_r,c6_l,c6_r,c7_l,c7_r,c8_l,c8_r,c9_l,c9_r,c10_l,c10_r,c11_l,c11_r,yx_l,yx_r,ywyid,STR_TO_DATE(SUBSTRING_INDEX(rq,'.',1),'%d/%m/%Y %H:%i:%s') from glg.yanguang;

副 片 瓶 个 套 盒 支

数据连表查询 程序里面

SELECT a.goodsid,a.brand,c.name,c.firmname,a.vendorid,a.py,a.unit,b.goodsname, b.model,b.yhl,b.sale,b.buy,b.buyave,b.status,d.stockid,d.number FROM glg_base_goods a JOIN glg_goods_readingglg b ON a.goodsid = b.goodsid JOIN glg_base_vendor c ON c.uid = a.vendorid JOIN glg_stock d ON d.goodsid = b.goodsname WHERE b.goodsid = 'D0069' AND a.status = '0' AND b.status = '0' AND D.number >= 0 ORDER BY d.stockid ASC , b.model ASC LIMIT 0 , 100;

仓库

insert into glg.glg_base_stores(sector,sotck,name,leader,phone,address,zip,py,details,status) select bumenid,CAST(cangkuid AS SIGNED),name,fuzeid,phone,address,youbian,pinyin,beizhu,yxbj from gl.cangku;

业务

insert into glg.glg_business(num,numtype,target,card,date,salesman,cashier,optometrist,returnnum,returnflag,groupflag,total,returnsflag,totalamount,rebate,freight,operating,refund,pay,paid,debt,notpay,returnamount,receiptspayments,subjects,details,serialnumber,zcb,hfbj,kdbj,billing,bdzjk,tcze) select djid,djlx,dxlx,dxid,STR_TO_DATE(SUBSTRING_INDEX(rq,'.',1),'%d/%m/%Y %H:%i:%s'),ywyid,syyid,ccyid,ghfs,ddclbj,bz,zsl,djzt,zje,zkje,yunfei,yyk,swfk,swfksk,fukuan,skje,wfk,thje,ysyfcx,kemuid,beizhu,xlh,zcb,hfbj,kdbj,yingfu,bdzjk,tcze from gl.yw;

业务详单

insert into glg.glg_businesslist(num,stocka,stockb,goodsid,total,price,sale,amount,stocknum,stockamount,cost,grossprofit,commission) select djid,cangkuid,cangkuid1,spid,sl,dj,yjg,je,cksl,ckje,cbj,mlr,tcje from gl.ywzb;

业务 djid单据ID ghfs退货单号 djzt退货标志 swfk有数值 mdh 费用支出 A 只有一条A mdh SELECT * FROM yw WHERE mdh = "C";

djid mdh djlx dxlx dxid riqi rq ghfs ywyid syyid ccyid ddclbj bz zsl djzt zje zkje yyk swfk swfksk fukuan skje wfk thje qtfy ysyfcx beizhu xlh zcb hfbj kdbj yingfu bdzjk tcze

业务详单 主仓库 操作仓库 商品ID 数量 单价 眼镜价 金额 仓库数量 仓库金额 成本价 毛利率 提成金额

djid cangkuid cangkuid1 spid sl dj yjg je cksl ckje cbj mlr tcje

djid单据ID xgjf都是0 djlx单据类型 dxlx业务对象 dxid业务ID rq日期 ghfs退货单号关联 ywyid业务员ID syyid收银员ID ccyid可能是验光员 ddclbj退货标记1是退货 bz班组 zsl总数量 djzt新已退货 ghzt都是空

zje单据销售总金额 zkje本单折扣金额 yunfei运费 sh为空 yyk实际收款 swfk退货入账金额 swfksk直接收钱 fukuan已付款 skje当前单需收款(还欠) wfk未付款 thje退货金额 qtfy其他费用空 ysyfcx应收应付查询

kemuid科目ID退货单号 beizhu备注 xlh序列号 xgfy为空 ml为空 zcb未知 gxhbj都是0 hfbj只有0和1 kdbj只有0和1 yingfu应付 bdzjk付款相关 tcze未知列 h为空 hflx都是0 dxqjbj都是0

insert into glg.glg_business(num,numtype,target,card,dates,salesman,cashier,optometrist,returnnum,returnflag,groupflag,total,returnsflag,totalamount,rebate,freight,operating,refund,pay,paid,debt,notpay,returnamount,receiptspayments,subjects,details,serialnumber,zcb,hfbj,kdbj,billing,bdzjk,tcze) select djid,djlx,dxlx,dxid,STR_TO_DATE(SUBSTRING_INDEX(rq,'.',1),'%d/%m/%Y %H:%i:%s'),ywyid,syyid,ccyid,ghfs,ddclbj,bz,zsl,djzt,zje,zkje,yunfei,yyk,swfk,swfksk,fukuan,skje,wfk,thje,ysyfcx,kemuid,beizhu,xlh,zcb,hfbj,kdbj,yingfu,bdzjk,tcze from gl.yw;

update glg.glg_business set dates = STR_TO_DATE(SUBSTRING_INDEX(dates,'.',1),'%d/%m/%Y %H:%i:%s') where id > 0;

djid mdh djlx dxlx dxid riqi rq ghfs ywyid syyid ccyid ddclbj bz zsl djzt zje zkje yyk swfk swfksk fukuan skje wfk thje qtfy ysyfcx beizhu xlh zcb hfbj kdbj yingfu bdzjk tcze

UA UB退货单

SC收款单

SA收款单 直接收 就一单

GA 采购单

LA LB 销售单

ZA费用支出

DA 调拨单

XA 商品信息转换

IA未查看

多级表头 1747

<table class="layui-table" lay-options="{height:'full',url:'/dcrb/apishylist',page:true,toolbar:'#toolbarDemo',totalRow:true,limit:30,limits:[15,30,60,90]}" id="table-demo">

<thead>

<tr>

<th lay-options="{field:'id',sort:true,width:70,totalRow:'合计'}" rowspan="3">ID</th>

<th lay-options="{field:'zgbh',totalRow:'-'}" rowspan="3">在岗编号</th>

<th lay-options="{field:'tjr',totalRow:'-'}" rowspan="3">提交人</th>

<th lay-options="{field:'banci',totalRow:'-'}" rowspan="3">班次</th>

<th lay-options="{field:'banzu',totalRow:'-'}" rowspan="3">班组</th>

<th lay-options="{field:'lrtime',totalRow:'-'}" rowspan="3">提交时间</th>

<th lay-options="{align:'center'}" colspan="4">给水</th>

<th lay-options="{align:'center'}" colspan="4">过热</th>

<th lay-options="{align:'center'}" colspan="2">除盐水</th>

</tr>

<tr>

<th lay-options="{align:'center'}" colspan="2">钠(ug/L)≤350</th>

<th lay-options="{align:'center'}" colspan="2">硅(ug/L)≤50</th>

<th lay-options="{align:'center'}" colspan="2">钠(ug/L)≤15</th>

<th lay-options="{align:'center'}" colspan="2">硅(ug/L)≤20</th>

<th lay-options="{align:'center'}" colspan="2">硅(ug/L)≤50</th>

</tr>

<tr>

<th lay-options="{align:'center',field:'gsnamax',totalRow:'-'}">最高</th>

<th lay-options="{align:'center',field:'gsnamin',totalRow:'{{= d.TOTAL_ROW.gsna}}'}">最低</th>

<th lay-options="{align:'center',field:'gsguimax',totalRow:'-'}">最高</th>

<th lay-options="{align:'center',field:'gsguimin',totalRow:'{{= d.TOTAL_ROW.gsgui}}'}">最低</th>

<th lay-options="{align:'center',field:'grnamax',totalRow:'-'}">最高</th>

<th lay-options="{align:'center',field:'grnamin',totalRow:'{{= d.TOTAL_ROW.grna}}'}">最低</th>

<th lay-options="{align:'center',field:'grguimax',totalRow:'-'}">最高</th>

<th lay-options="{align:'center',field:'grguimin',totalRow:'{{= d.TOTAL_ROW.grgui}}'}">最低</th>

<th lay-options="{align:'center',field:'cyguimax',totalRow:'-'}">最高</th>

<th lay-options="{align:'center',field:'cyguimin',totalRow:'{{= d.TOTAL_ROW.cygui}}'}">最低</th>

</tr>

</thead>

</table>