Skip to end of metadata
Go to start of metadata

菜鸟云打印提示:

 

第一先确认配置

店铺和仓库的设置,仓库要设置物流公司启动电子面单

第二确认一下打印机配置

确认打印机的设置是否正确

 

第三步确认打印视图

CREATE OR REPLACE VIEW T_V_OMSCNCUSTOM AS
SELECT o.id AS onlineorderid, o.shipperid, wh.warehousename,sh.shoptitle,o.paytime, o.ordershopname, p.title, p.sku, p.num,
p.skuspec, p.storesite, l.template_url, c.custom_area_url,
(SELECT orderno
FROM t_omspickinglistitem y
WHERE y.omsonlineorderid = o.id
GROUP BY omsonlineorderid, orderno) AS orderno
FROM t_omsonlineorder o
LEFT JOIN t_omsonlineorderproduct p
ON p.omsonlineorderid = o.id
left join t_ieswarehouse wh
on wh.id=o.ieswarehouseid
left join t_iesshop sh
on sh.id=o.ordershopid
LEFT JOIN t_omslogisticscompany l
ON l.id = o.shipperid
AND l.isactive = 1
LEFT JOIN (SELECT MAX(cc.custom_area_url) custom_area_url, cc.logisticscompanyid
FROM t_omscustomtemplate cc
WHERE cc.isactive = 1
GROUP BY logisticscompanyid) c
ON o.shipperid = c.logisticscompanyid
WHERE nvl(p.refundstatus, 0) <> 6;

 

Labels
  • None
Write a comment…