http://wiki.blueidea.com/index.php?action=history&feed=atom&title=%E4%BA%BA%E4%BA%BA%E5%95%86%E5%9F%8E%2F%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%97%E5%85%B8%2Fims_ewei_shop_supplier_order_goods 2026-05-08T06:16:54Z 本wiki的该页面的版本历史 MediaWiki 1.24.1 http://wiki.blueidea.com/index.php?title=%E4%BA%BA%E4%BA%BA%E5%95%86%E5%9F%8E/%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%97%E5%85%B8/ims_ewei_shop_supplier_order_goods&diff=10727&oldid=prev 2017-06-29T14:04:53Z

<p>从ims_ewei_shop_order_goods表复制过来，增加了几个字段</p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black; text-align: center;">←上一版本</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">2017-06-29T14:04:53的版本</td> </tr><tr><td colspan="2" class="diff-lineno">第11行：</td> <td colspan="2" class="diff-lineno">第11行：</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|goodsid||商品ID</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|goodsid||商品ID</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|orderids || 订单id集</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|supplierid || 供应商id</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|thumb || 缩略图</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|title || 商品标题</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|optionname || 规格名称</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|unit || 商品单位</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|-</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|costprice || 商品成本价</ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|price||订单价格</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|price||订单价格</div></td></tr> </table>

wangyue88 http://wiki.blueidea.com/index.php?title=%E4%BA%BA%E4%BA%BA%E5%95%86%E5%9F%8E/%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%97%E5%85%B8/ims_ewei_shop_supplier_order_goods&diff=10725&oldid=prev 2017-06-29T13:49:50Z

<p>创建页面，内容为“ {|class=Tablelist |- !字段名!!功能 |- |id|| |- |uniacid|| |- |orderid||订单ID |- |goodsid||商品ID |- |price||订单价格 |- |oldprice||原价格 |- |chang...”</p> <p><b>新页面</b></p><div><br /> {|class=Tablelist<br /> |-<br /> !字段名!!功能<br /> |-<br /> |id||<br /> |-<br /> |uniacid||<br /> |-<br /> |orderid||订单ID<br /> |-<br /> |goodsid||商品ID<br /> |-<br /> |price||订单价格<br /> |-<br /> |oldprice||原价格<br /> |-<br /> |changeprice||修改价格<br /> |-<br /> |total||订单总价<br /> |-<br /> |optionid||选项ID<br /> |-<br /> |createtime||建立时间<br /> |-<br /> |optionname||选项名<br /> |-<br /> |commissions||实际佣金，可以通过后台调整<br /> |-<br /> |commission1||应得佣金，分销级别一，分成比率<br /> |-<br /> |applytime1||申请时间<br /> |-<br /> |checktime1||审核时间<br /> |-<br /> |paytime1||打款时间<br /> |-<br /> |invalidtime1||拒绝时间<br /> |-<br /> |deletetime1||删除<br /> |-<br /> |status1||申请状态，-2删除，-1无效，0未申请，1申请，2审核通过 3已打款<br /> |-<br /> |content1||内容<br /> |-<br /> |commission2||<br /> |-<br /> |applytime2||<br /> |-<br /> |checktime2||<br /> |-<br /> |paytime2||<br /> |-<br /> |invalidtime2||<br /> |-<br /> |deletetime2||<br /> |-<br /> |status2||<br /> |-<br /> |content2||<br /> |-<br /> |commission3||<br /> |-<br /> |applytime3||<br /> |-<br /> |checktime3||<br /> |-<br /> |paytime3||<br /> |-<br /> |invalidtime3||<br /> |-<br /> |deletetime3||<br /> |-<br /> |status3||<br /> |-<br /> |content3||<br /> |-<br /> |realprice||实际价格<br /> |-<br /> |goodssn||商品编码<br /> |-<br /> |productsn||产品条码<br /> |-<br /> |nocommission||不参与分销<br /> |-<br /> |diyformid||<br /> |-<br /> |diyformdataid||<br /> |-<br /> |diyformdata||<br /> |-<br /> |diyformfields||<br /> |-<br /> |openid||<br /> |-<br /> |printstate||快递单打印状态 0 未 &gt;0 多次<br /> |-<br /> |printstate2||发货单打印状态 0 未 &gt;0 多次<br /> |-<br /> |rstate||v2 退款状态<br /> |-<br /> |refundtime||v2 退款时间<br /> |-<br /> |merchid||v2 商户ID<br /> |-<br /> |parentorderid||v2 父订单id<br /> |-<br /> |merchsale||v2 商户销售<br /> |-<br /> |isdiscountprice||v2 是否折扣价格<br /> |-<br /> |canbuyagain||v2 可以复购<br /> |-<br /> |sendtype||v2 <br /> |-<br /> |expresscom||v2 <br /> |-<br /> |expresssn||v2 <br /> |-<br /> |express||v2 <br /> |-<br /> |sendtime||v2 <br /> |-<br /> |finishtime||v2 <br /> |-<br /> |remarksend||v2 <br /> |-<br /> |*paymerchid||支付供应商ID<br /> |-<br /> |*payrealname||供应商收款人名<br /> |-<br /> |*paybankname||供应商收款银行<br /> |-<br /> |*paybankcard||供应商收款卡号<br /> |-<br /> |*costprice||成本价<br /> |-<br /> |*otherprice||其他费用<br /> |}</div>

wangyue88