Question

zen cart导出订单图片

使用ordersExporter可以导出订单相关信息，我想在导出的excel中增加导出产品的图片一栏，即导出products表products_image的数据，我在ordersExport.php中相应位置增加
'v_producs_images' => $iii++,

producs_images as v_producs_images

FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_PRODUCTS.TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zos.orders_status_id != '3'
AND zo.orders_status = zos.orders_status_id

这样修改后导出来的是空白，我想应该是第三段FROM里没写对把，请教如何修改

Answer 1

第一producs_images as v_producs_images 中的producs_images 应该为 products_image
第二 查询的表都没有产品表 怎么会有图片？

改成这样试试

SELECT p.products_image AS v_producs_images
FROM ORDERS_PRODUCTS zop
LEFT JOIN ORDERS_PRODUCTS_ATTRIBUTES opa ON ( zop.orders_products_id = opa.orders_products_id ) , products p,
orders o,
ORDERS_STATUS zos
WHERE o.orders_id = zop.orders_id
AND zos.orders_status_id != '3'
AND o.orders_status = zos.orders_status_id

还不行 就加我哭哭： heiman8@qq.com

追问

producs_images as v_producs_images 这个是手打失误，查询的表有产品表TABLE_PRODUCTS，还是不行，很感谢你的耐心回答