打开Navicat👉查询👉粘贴SQL语句👉运行👉导出👉Excel
博浩商贸通
商品表
SET @has_positive = (SELECT COUNT(*) FROM articulo WHERE PrecioMayor > 0); SET @has_descuento = (SELECT COUNT(*) FROM articulo WHERE Descuento > 0); SELECT p.ArticuloID, p.CodigoBarra, CASE WHEN p.DescuentoCambioProhibido = -1 THEN CONCAT('*', CAST(CAST(p.NombreES AS BINARY) AS CHAR CHARACTER SET gbk)) ELSE CAST(CAST(p.NombreES AS BINARY) AS CHAR CHARACTER SET gbk) END AS 商品名称, p.PrecioCoste, CASE WHEN p.PrecioDetalle != 0 THEN p.PrecioDetalle WHEN p.PrecioDetalle = 0 AND p.PrecioMayor != 0 THEN p.PrecioMayor WHEN p.PrecioDetalle = 0 AND p.PrecioMayor = 0 THEN NULL END AS 售价, NULL, NULL, NULLIF(COALESCE(s.Stock, 0), 0) AS 数量, CASE WHEN @has_positive = 0 THEN NULL WHEN p.PrecioMayor IS NULL OR p.PrecioMayor = 0 THEN 0 WHEN p.PrecioMayor > 0 THEN p.PrecioMayor ELSE NULL END AS 售价2,CASE WHEN @has_descuento = 0 THEN NULL WHEN p.Descuento IS NULL OR p.Descuento = 0 THEN 0 WHEN p.Descuento > 0 THEN p.Descuento ELSE NULL END AS 折扣, NULL, NULL, NULL, i.IVA/100 AS 税率, NULL, NULL, NULLIF(CAST(CAST(p.NombreCN AS BINARY) AS CHAR CHARACTER SET gbk), '') AS 名称2 FROM articulo p LEFT JOIN articuloclase c ON p.ClaseID = c.ClaseID LEFT JOIN (SELECT ArticuloID, SUM(Stock) AS Stock FROM stock WHERE ArticuloID != 0 GROUP BY ArticuloID HAVING SUM(Stock) != 0) s ON p.ArticuloID = s.ArticuloID LEFT JOIN ivatipo i ON c.IVAID = i.IVAID WHERE p.ArticuloID != '0';
