/**
* Exports CSV
*/
protected function renderCSV()
{
// exports orders
if (Tools::isSubmit('csv_orders')) {
// header
header('Content-type: text/csv; charset=utf-8');
header('Cache-Control: no-store, no-cache');
header('Content-disposition: attachment; filename="supply_orders.csv"');
// write headers column
$keys = array('id_supplier', 'supplier_name', 'id_lang', 'id_warehouse', 'id_supply_order_state', 'id_currency', 'reference', 'date_add', 'date_upd', 'date_delivery_expected', 'total_te', 'total_with_discount_te', 'total_ti', 'total_tax', 'discount_rate', 'discount_value_te', 'is_template', 'escompte', 'invoice_number', 'date_to_invoice', 'global_discount_amount', 'global_discount_type', 'shipping_amount', 'description');
echo sprintf("%s\n", implode(';', $keys));
$query = null;
$query = new DbQuery();
$query->select('so.*, ipso.*');
$query->from('supply_order', 'so');
$query->leftjoin('erpip_supply_order', 'ipso', 'ipso.id_supply_order = so.id_supply_order');
if ($this->controller_status == STATUS1) {
$query->limit(ERP_STCKMGTFR);
}
// FILTERS SUPPLIER & WAREHOUSE
$id_warehouse = $this->getCurrentWarehouse();
if ($id_warehouse != -1) {
$query->where('so.id_warehouse = ' . (int) $id_warehouse);
}
$id_supplier = $this->getCurrentSupplier();
if ($id_supplier != -1) {
$query->where('so.id_supplier = ' . (int) $id_supplier);
}
// Execute query
$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);
// write datas
foreach ($res as $order) {
$content_csv = array($order['id_supplier'], self::transformText($order['supplier_name']), $order['id_lang'], $order['id_warehouse'], $order['id_supply_order_state'], $order['id_currency'], $order['reference'], $order['date_add'], $order['date_upd'], $order['date_delivery_expected'], $order['total_te'], $order['total_with_discount_te'], $order['total_ti'], $order['total_tax'], $order['discount_rate'], $order['discount_value_te'], $order['is_template'], $order['escompte'], $order['invoice_number'], $order['date_to_invoice'] == '0000-00-00' ? '' : $order['date_to_invoice'], $order['global_discount_amount'], $order['global_discount_type'], $order['shipping_amount'], self::transformText($order['description']), PHP_EOL);
echo implode(';', $content_csv);
}
if ($this->controller_status == STATUS1) {
echo sprintf($this->l('Your are using a free version of 1-Click ERP which limits the export to %d lines.'), ERP_STCKMGTFR);
}
die;
} else {
if (Tools::isSubmit('csv_orders_details')) {
// header
header('Content-type: text/csv');
header('Content-Type: application/force-download; charset=UTF-8');
header('Cache-Control: no-store, no-cache');
header('Content-disposition: attachment; filename="' . $this->l('supply_orders_details') . '.csv"');
// echoes details
$ids = array();
foreach ($this->_list as $entry) {
$ids[] = $entry['id_supply_order'];
}
if ($this->controller_status == STATUS1) {
$ids = array_splice($ids, 0, ERP_STCKMGTFR);
}
if (count($ids) <= 0) {
return;
}
// for each supply order
$keys = array('id_product', 'id_product_attribute', 'reference', 'supplier_reference', 'ean13', 'upc', 'name', 'unit_price_te', 'quantity_expected', 'quantity_received', 'price_te', 'discount_rate', 'discount_value_te', 'price_with_discount_te', 'tax_rate', 'tax_value', 'price_ti', 'tax_value_with_order_discount', 'price_with_order_discount_te', 'id_supply_order', 'comment');
echo sprintf("%s\n", implode(';', array_map(array('CSVCore', 'wrap'), $keys)));
// overrides keys (in order to add FORMAT calls)
$keys = array('sod.id_product', 'sod.id_product_attribute', 'sod.reference', 'sod.supplier_reference', 'sod.ean13', 'sod.upc', 'sod.name', 'FORMAT(sod.unit_price_te, 2)', 'sod.quantity_expected', 'sod.quantity_received', 'FORMAT(sod.price_te, 2)', 'FORMAT(sod.discount_rate, 2)', 'FORMAT(sod.discount_value_te, 2)', 'FORMAT(sod.price_with_discount_te, 2)', 'FORMAT(sod.tax_rate, 2)', 'FORMAT(sod.tax_value, 2)', 'FORMAT(sod.price_ti, 2)', 'FORMAT(sod.tax_value_with_order_discount, 2)', 'FORMAT(sod.price_with_order_discount_te, 2)', 'sod.id_supply_order', 'ipsod.comment');
foreach ($ids as $id) {
$query = new DbQuery();
$query->select(implode(', ', $keys));
$query->from('supply_order_detail', 'sod');
$query->leftJoin('supply_order', 'so', 'so.id_supply_order = sod.id_supply_order');
$query->leftJoin('erpip_supply_order_detail', 'ipsod', 'ipsod.id_supply_order_detail = sod.id_supply_order_detail');
// FILTERS SUPPLIER & WAREHOUSE
$id_warehouse = $this->getCurrentWarehouse();
if ($id_warehouse != -1) {
$query->where('so.id_warehouse = ' . (int) $id_warehouse);
}
$id_supplier = $this->getCurrentSupplier();
if ($id_supplier != -1) {
$query->where('so.id_supplier = ' . (int) $id_supplier);
}
$query->where('sod.id_supply_order = ' . (int) $id);
$query->orderBy('sod.id_supply_order_detail DESC');
$resource = Db::getInstance()->query($query);
// gets details
while ($row = Db::getInstance()->nextRow($resource)) {
$row = array_map(array('CSVCore', 'wrap'), $row);
$row['name'] = self::transformText($row['name']);
$row['reference'] = self::transformText($row['reference']);
$row['supplier_reference'] = self::transformText($row['supplier_reference']);
echo sprintf("%s\n", implode(';', $row));
}
}
if ($this->controller_status == STATUS1) {
echo sprintf($this->l('Your are using a free version of 1-Click ERP which limits the export to %d lines.'), ERP_STCKMGTFR);
}
} else {
if (Tools::isSubmit('csv_order_details') && Tools::getValue('id_supply_order')) {
$supply_order = new SupplyOrder((int) Tools::getValue('id_supply_order'));
if (Validate::isLoadedObject($supply_order)) {
$details = $supply_order->getEntriesCollection();
$details->getAll();
$csv = new CSV($details, $this->l('supply_order') . '_' . $supply_order->reference . '_details');
$csv->export();
}
} else {
if (Tools::isSubmit('export_csv')) {
// get id lang
$id_lang = Context::getContext()->language->id;
// header
header('Content-type: text/csv');
header('Cache-Control: no-store, no-cache');
header('Content-disposition: attachment; filename="Supply order detail.csv"');
// puts hearder of CSV
$keys = array('supplier_reference', 'quantity_expected');
echo sprintf("%s\n", implode(';', $keys));
// gets global order information
$supply_order = new SupplyOrder((int) Tools::getValue('id_supply_order'));
// get supply order detail
$supply_order_detail = $supply_order->getEntries($id_lang);
// puts data
foreach ($supply_order_detail as $product) {
$row_csv = array($product['supplier_reference'], $product['quantity_expected']);
// puts one row
echo sprintf("%s\n", implode(';', array_map(array('CSVCore', 'wrap'), $row_csv)));
}
if ($this->controller_status == STATUS1) {
echo sprintf($this->l('Your are using a free version of 1-Click ERP which limits the export to %d lines.'), ERP_STCKMGTFR);
}
die;
} else {
if (Tools::isSubmit('export_history')) {
// header
header('Content-type: text/csv; charset=utf-8');
header('Cache-Control: no-store, no-cache');
header('Content-disposition: attachment; filename="supply_orders_history.csv"');
// write headers column
$keys = array('id_supply_order_history', 'id_supply_order', 'id_employee', 'employee_lastname', 'employee_firstname', 'id_state', 'state', 'unit_price', 'discount_rate', 'is_canceled');
echo sprintf("%s\n", implode(';', $keys));
$query = null;
$query = new DbQuery();
$query->select('sorh.*, ipsorh.*, "state" as state');
$query->from('supply_order_receipt_history', 'sorh');
$query->leftjoin('erpip_supply_order_receipt_history', 'ipsorh', 'ipsorh.id_supply_order_receipt_history = sorh.id_supply_order_receipt_history');
$query->leftjoin('supply_order_detail', 'sod', 'sod.id_supply_order_detail = sorh.id_supply_order_detail');
$query->where('sod.id_supply_order = ' . (int) Tools::getValue('id_supply_order'));
if ($this->controller_status == STATUS1) {
$query->limit(ERP_STCKMGTFR);
}
// Execute query
$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);
// write datas
foreach ($res as $history) {
$content_csv = array($history['id_supply_order_history'], $history['id_supply_order'], $history['id_employee'], $history['employee_lastname'], $history['employee_firstname'], $history['id_state'], $history['state'], $history['unit_price'], $history['discount_rate'], $history['is_canceled'], PHP_EOL);
echo implode(';', $content_csv);
}
if ($this->controller_status == STATUS1) {
echo sprintf($this->l('Your are using a free version of 1-Click ERP which limits the export to %d lines.'), ERP_STCKMGTFR);
}
die;
}
}
}
}
}
}
