[EC-CUBE] 2.11.5 → 2.12.1
[レンタルサーバ] WADAX
[OS] Red Hat Linux
[PHP] PHP 5.1.6
[データベース] MySQL 5.0.95
[WEBサーバ] Apache
[ブラウザ] Firefox 14.0.1 Google Chrome 21.0.1180.83 IE9
開発環境
[EC-CUBE] 2.12.1
[レンタルサーバ] なし(XAMPP 1.7.7のため)
[OS] Windows7 Professional
[PHP] PHP 5.3.8
[データベース] MySQL 5.5.16
[WEBサーバ] Apache/2.2.21
[ブラウザ] Firefox 14.0.1 Google Chrome 21.0.1180.83 IE9
お世話になります。
当方、題記プラグインを導入してCSV出力を行ってみたのですが
全件取得されず、途中までしか出力されない状態です。
ちなみにSQLクエリは以下の通りです。
SELECT
NULL as addr_book_code,
(SELECT CONCAT(shipping_tel01, '-', shipping_tel02, '-', shipping_tel03) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_tel,
(SELECT CONCAT(shipping_zip01, '-', shipping_zip02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_zip,
substring((SELECT CONCAT((SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_shipping.shipping_pref), shipping_addr01, shipping_addr02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) from 1 for 16) as shipping_addr01,
substring((SELECT CONCAT((SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_shipping.shipping_pref), shipping_addr01, shipping_addr02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) from 17 for 16) as shipping_addr02,
substring((SELECT CONCAT((SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_shipping.shipping_pref), shipping_addr01, shipping_addr02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) from 33 for 16) as shipping_addr03,
substring((SELECT CONCAT(shipping_name01, ' ', shipping_name02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) from 1 for 16) as shipping_name01,
substring((SELECT CONCAT(shipping_name01, ' ', shipping_name02) FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) from 17 for 16) as shipping_name02,
NULL as cust_manager_no,
NULL as cust_code,
NULL as post,
NULL as shipp_tel,
CONCAT(order_tel01, '-', order_tel02, '-', order_tel03) AS order_tel,
CONCAT(order_zip01, '-', order_zip02) AS order_zip,
substring(CONCAT((SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_order.order_pref), order_addr01, order_addr02) from 1 for 16) as order_addr01,
substring(CONCAT((SELECT name FROM mtb_pref WHERE mtb_pref.id = dtb_order.order_pref), order_addr01, order_addr02) from 17 for 16) as order_addr02,
substring((SELECT CONCAT(order_name01, ' ', order_name02) FROM dtb_order dbo WHERE dbo.order_id = dtb_order.order_id) from 1 for 16) as order_name01,
substring((SELECT CONCAT(order_name01, ' ', order_name02) FROM dtb_order dbo WHERE dbo.order_id = dtb_order.order_id) from 17 for 16) as order_name02,
NULL as packing_code,
NULL as goods_name1,
NULL as goods_name2,
NULL as goods_name3,
NULL as goods_name4,
NULL as goods_name5,
NULL as shipping_num,
NULL as binsyu_speed,
NULL as binsyu_product,
(SELECT date_format(shipping_date,'%Y%m%d') from dtb_shipping where dtb_shipping.order_id = dtb_order.order_id ) as shipping_date,
NULL as shipping_time_id,
NULL as shipping_time,
(SELECT payment_total FROM dtb_order dbo WHERE dbo.order_id = dtb_order.order_id and dtb_order.payment_method like '代金引換') as cash_on_delivery,
NULL as tax,
NULL as payment_class,
NULL as insurance,
NULL as insurance_print,
(SELECT '005' FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id AND shipping_date IS NOT NULL) as specified_seal1,
NULL as specified_seal2,
NULL as specified_seal3,
NULL as shop_end_id,
NULL as src_class,
NULL as mse_code,
NULL as collect_class
FROM dtb_order
WHERE del_flg = 0
素の状態だと、サブクエリで重複レコードを持ってくる
箇所があったので、修正しています。
あと、mysqlなので一応CONCATで結合しています。
上記SQLでphpmyadminで実行するときちんと全レコード取得
できるのですが、csv出力を行うと途中までしか出力しない
という状況です。
どうもわからないので困っております。
どなたかプラグインで正常に取得できる方
ご助言等頂ければ幸いです。
どうぞよろしくお願いいたします。<(_ _)>