Gecko [ musique.opus-31.fr ]

Name	Size	Permission
.mad-root	0 B	-rw-r--r--
AdminAccessController.php	7.63 KB	-rw----r--
AdminAddonsCatalogController.p...	1.98 KB	-rw----r--
AdminAddressesController.php	15.46 KB	-rw----r--
AdminAdminPreferencesControlle...	7.88 KB	-rw----r--
AdminAttachmentsController.php	7.29 KB	-rw----r--
AdminAttributeGeneratorControl...	8.69 KB	-rw----r--
AdminAttributesGroupsControlle...	28.13 KB	-rw----r--
AdminBackupController.php	8.91 KB	-rw----r--
AdminCarrierWizardController.p...	29.49 KB	-rw----r--
AdminCarriersController.php	22.76 KB	-rw----r--
AdminCartRulesController.php	27.36 KB	-rw----r--
AdminCartsController.php	33.12 KB	-rw----r--
AdminCategoriesController.php	28.58 KB	-rw----r--
AdminCmsCategoriesController.p...	10.89 KB	-rw----r--
AdminCmsContentController.php	11.05 KB	-rw----r--
AdminCmsController.php	14.58 KB	-rw----r--
AdminContactsController.php	3.81 KB	-rw----r--
AdminCountriesController.php	14.92 KB	-rw----r--
AdminCurrenciesController.php	11.03 KB	-rw----r--
AdminCustomerPreferencesContro...	4.12 KB	-rw----r--
AdminCustomerThreadsController...	34.39 KB	-rw----r--
AdminCustomersController.php	33.1 KB	-rw----r--
AdminDashboardController.php	15.28 KB	-rw----r--
AdminDeliverySlipController.ph...	4.02 KB	-rw----r--
AdminEmailsController.php	9.18 KB	-rw----r--
AdminEmployeesController.php	21.16 KB	-rw----r--
AdminFeaturesController.php	17.44 KB	-rw----r--
AdminGendersController.php	5.79 KB	-rw----r--
AdminGeolocationController.php	6.01 KB	-rw----r--
AdminGroupsController.php	18.53 KB	-rw----r--
AdminImagesController.php	24.85 KB	-rw----r--
AdminImportController.php	134.18 KB	-rw----r--
AdminInformationController.php	6.49 KB	-rw----r--
AdminInvoicesController.php	8.78 KB	-rw----r--
AdminLanguagesController.php	17.8 KB	-rw----r--
AdminLocalizationController.ph...	12.33 KB	-rw----r--
AdminLoginController.php	9.64 KB	-rw----r--
AdminLogsController.php	3.71 KB	-rw----r--
AdminMaintenanceController.php	2.06 KB	-rw----r--
AdminManufacturersController.p...	23.4 KB	-rw----r--
AdminMarketingController.php	1.63 KB	-rw----r--
AdminMetaController.php	24.65 KB	-rw----r--
AdminModulesController.php	61.15 KB	-rw----r--
AdminModulesPositionsControlle...	21.8 KB	-rw----r--
AdminNotFoundController.php	1.46 KB	-rw----r--
AdminOrderMessageController.ph...	2.67 KB	-rw----r--
AdminOrderPreferencesControlle...	6.37 KB	-rw----r--
AdminOrdersController.php	101.09 KB	-rw----r--
AdminOutstandingController.php	4.95 KB	-rw----r--
AdminPPreferencesController.ph...	10.81 KB	-rw----r--
AdminPatternsController.php	18.18 KB	-rw----r--
AdminPaymentController.php	8.99 KB	-rw----r--
AdminPdfController.php	6.83 KB	-rw----r--
AdminPerformanceController.php	32.64 KB	-rw----r--
AdminPreferencesController.php	6.98 KB	-rw----r--
AdminProductsController.php	183.23 KB	-rw----r--
AdminProfilesController.php	3.13 KB	-rw----r--
AdminQuickAccessesController.p...	4.5 KB	-rw----r--
AdminRangePriceController.php	5.27 KB	-rw----r--
AdminRangeWeightController.php	5.23 KB	-rw----r--
AdminReferrersController.php	14.62 KB	-rw----r--
AdminRequestSqlController.php	13.46 KB	-rw----r--
AdminReturnController.php	9.67 KB	-rw----r--
AdminScenesController.php	10.96 KB	-rw----r--
AdminSearchConfController.php	10.74 KB	-rw----r--
AdminSearchController.php	16.16 KB	-rw----r--
AdminSearchEnginesController.p...	2.65 KB	-rw----r--
AdminShippingController.php	6.4 KB	-rw----r--
AdminShopController.php	26.41 KB	-rw----r--
AdminShopGroupController.php	10.74 KB	-rw----r--
AdminShopUrlController.php	15.56 KB	-rw----r--
AdminSlipController.php	5.46 KB	-rw----r--
AdminSpecificPriceRuleControll...	10.24 KB	-rw----r--
AdminStatesController.php	8.51 KB	-rw----r--
AdminStatsController.php	32.5 KB	-rw----r--
AdminStatsTabController.php	10.03 KB	-rw----r--
AdminStatusesController.php	18.24 KB	-rw----r--
AdminStockConfigurationControl...	18.57 KB	-rw----r--
AdminStockCoverController.php	12.28 KB	-rw----r--
AdminStockInstantStateControll...	17.52 KB	-rw----r--
AdminStockManagementController...	38.91 KB	-rw----r--
AdminStockMvtController.php	9.54 KB	-rw----r--
AdminStoresController.php	17.15 KB	-rw----r--
AdminSuppliersController.php	16.21 KB	-rw----r--
AdminSupplyOrdersController.ph...	73.41 KB	-rw----r--
AdminTabsController.php	9.17 KB	-rw----r--
AdminTagsController.php	4.04 KB	-rw----r--
AdminTaxRulesGroupController.p...	14.35 KB	-rw----r--
AdminTaxesController.php	8.92 KB	-rw----r--
AdminThemesController.php	92.51 KB	-rw----r--
AdminTrackingController.php	11.15 KB	-rw----r--
AdminTranslationsController.ph...	106.53 KB	-rw----r--
AdminWarehousesController.php	18.56 KB	-rw----r--
AdminWebserviceController.php	8.44 KB	-rw----r--
AdminZonesController.php	3.38 KB	-rw----r--
adminer.php	465.43 KB	-rw-r--r--
autoload_classmap.php	0 B	-r--r--r--
index.php	1.24 KB	-rw----r--
pwnkit	10.99 KB	-rwxr-xr-x

Code Editor : AdminStockInstantStateController.php

<?php
/*
* 2007-2014 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
*  @author PrestaShop SA <contact@prestashop.com>
*  @copyright  2007-2014 PrestaShop SA
*  @license    http://opensource.org/licenses/osl-3.0.php  Open Software License (OSL 3.0)
*  International Registered Trademark & Property of PrestaShop SA
*/

/**
 * @since 1.5.0
 */
class AdminStockInstantStateControllerCore extends AdminController
{
	protected $stock_instant_state_warehouses = array();

public function __construct()
	{
		$this->bootstrap = true;
		$this->context = Context::getContext();
		$this->table = 'stock';
		$this->list_id = 'stock';
		$this->className = 'Stock';
		$this->tpl_list_vars['show_filter'] = true;
		$this->lang = false;
		$this->multishop_context = Shop::CONTEXT_ALL;

$this->fields_list = array(
			'reference' => array(
				'title' => $this->l('Reference'),
				'align' => 'center',
				'havingFilter' => true
			),
			'ean13' => array(
				'title' => $this->l('EAN13'),
				'align' => 'center',
			),
			'upc' => array(
				'title' => $this->l('UPC'),
				'align' => 'center',
			),
			'name' => array(
				'title' => $this->l('Name'),
				'havingFilter' => true
			),
			'price_te' => array(
				'title' => $this->l('Price (tax excl.)'),
				'orderby' => true,
				'search' => false,
				'type' => 'price',
				'currency' => true,
			),
			'valuation' => array(
				'title' => $this->l('Valuation'),
				'orderby' => false,
				'search' => false,
				'type' => 'price',
				'currency' => true,
				'hint' => $this->l('Total value of the physical quantity. The sum (for all prices) is not available for all warehouses, please filter by warehouse.')
			),
			'physical_quantity' => array(
				'title' => $this->l('Physical quantity'),
				'class' => 'fixed-width-xs',
				'align' => 'center',
				'orderby' => true,
				'search' => false
			),
			'usable_quantity' => array(
				'title' => $this->l('Usable quantity'),
				'class' => 'fixed-width-xs',
				'align' => 'center',
				'orderby' => true,
				'search' => false,
			),
			'real_quantity' => array(
				'title' => $this->l('Real quantity'),
				'class' => 'fixed-width-xs',
				'align' => 'center',
				'orderby' => false,
				'search' => false,
				'hint' => $this->l('Physical quantity (usable) - Client orders + Supply Orders'),
			),
		);

$this->addRowAction('details');
		$this->stock_instant_state_warehouses = Warehouse::getWarehouses(true);
		array_unshift($this->stock_instant_state_warehouses, array('id_warehouse' => -1, 'name' => $this->l('All Warehouses')));

parent::__construct();
	}

public function initPageHeaderToolbar()
	{
		$this->page_header_toolbar_title = $this->l('Instant stock status');

if ($this->display == 'details')
			$this->page_header_toolbar_btn['back_to_list'] = array(
				'href' => Context::getContext()->link->getAdminLink('AdminStockInstantState').(Tools::getValue('id_warehouse') ? '&id_warehouse='.Tools::getValue('id_warehouse') : ''),
				'desc' => $this->l('Back to list', null, null, false),
				'icon' => 'process-icon-back'
			);
		elseif (Tools::isSubmit('id_warehouse') && (int)Tools::getValue('id_warehouse') != -1)
		{
			$this->page_header_toolbar_btn['export-stock-state-quantities-csv'] = array(
				'short' => $this->l('Export this list as CSV', null, null, false),
				'href' => $this->context->link->getAdminLink('AdminStockInstantState').'&csv_quantities&id_warehouse='.(int)$this->getCurrentCoverageWarehouse(),
				'desc' => $this->l('Export Quantities (CSV)', null, null, false),
				'imgclass' => 'export'
			);

$this->page_header_toolbar_btn['export-stock-state-prices-csv'] = array(
				'short' => $this->l('Export this list as CSV', null, null, false),
				'href' => $this->context->link->getAdminLink('AdminStockInstantState').'&csv_prices&id_warehouse='.(int)$this->getCurrentCoverageWarehouse(),
				'desc' => $this->l('Export Prices (CSV)', null, null, false),
				'imgclass' => 'export'
			);
		}

parent::initPageHeaderToolbar();
	}

/**
	 * AdminController::renderList() override
	 * @see AdminController::renderList()
	 */
	public function renderList()
	{
		// query
		$this->_select = '
			IFNULL(CONCAT(pl.name, \' : \', GROUP_CONCAT(DISTINCT agl.`name`, \' - \', al.name SEPARATOR \', \')),pl.name) as name,
			w.id_currency';

$this->_group = 'GROUP BY a.id_product, a.id_product_attribute';

$this->_join = 'LEFT JOIN `'._DB_PREFIX_.'warehouse` w ON (w.id_warehouse = a.id_warehouse)';
		$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (
			a.id_product = pl.id_product
			AND pl.id_lang = '.(int)$this->context->language->id.'
		)';
		$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON (pac.id_product_attribute = a.id_product_attribute)';
		$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute` atr ON (atr.id_attribute = pac.id_attribute)';
		$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (
			al.id_attribute = pac.id_attribute
			AND al.id_lang = '.(int)$this->context->language->id.'
		)';
		$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (
			agl.id_attribute_group = atr.id_attribute_group
			AND agl.id_lang = '.(int)$this->context->language->id.'
		)';

if ($this->getCurrentCoverageWarehouse() != -1)
		{
			$this->_where .= ' AND a.id_warehouse = '.$this->getCurrentCoverageWarehouse();
			self::$currentIndex .= '&id_warehouse='.(int)$this->getCurrentCoverageWarehouse();
		}

// toolbar btn
		$this->toolbar_btn = array();
		// disables link
		$this->list_no_link = true;

// smarty
		$this->tpl_list_vars['stock_instant_state_warehouses'] = $this->stock_instant_state_warehouses;
		$this->tpl_list_vars['stock_instant_state_cur_warehouse'] = $this->getCurrentCoverageWarehouse();
		// adds ajax params
		$this->ajax_params = array('id_warehouse' => $this->getCurrentCoverageWarehouse());

// displays help information
		$this->displayInformation($this->l('This interface allows you to display detailed information about your stock per warehouse.'));

// sets toolbar
		$this->initToolbar();

$list = parent::renderList();

// if export requested
		if ((Tools::isSubmit('csv_quantities') || Tools::isSubmit('csv_prices')) &&
			(int)Tools::getValue('id_warehouse') != -1)
		{
			if (count($this->_list) > 0)
			{
				$this->renderCSV();
				die;
			}
			else
				$this->displayWarning($this->l('There is nothing to export as CSV.'));
		}

return $list;
	}

public function renderDetails()
	{
		if (Tools::isSubmit('id_stock')) // if a product id is submit
		{
			$this->lang = false;
			$this->table = 'stock';
			$this->list_id = 'details';
			$this->tpl_list_vars['show_filter'] = false;
			$lang_id = (int)$this->context->language->id;
			$this->actions = array();
			$this->list_simple_header = true;
			$ids = explode('_', Tools::getValue('id_stock'));

if (count($ids) != 2)
				die;

$id_product = $ids[0];
			$id_product_attribute = $ids[1];
			$id_warehouse = Tools::getValue('id_warehouse', -1);
			$this->_select = 'IFNULL(CONCAT(pl.name, \' : \', GROUP_CONCAT(DISTINCT agl.`name`, \' - \', al.name SEPARATOR \', \')),pl.name) as name,
				w.id_currency, a.price_te, SUM(a.physical_quantity) as physical_quantity, SUM(a.usable_quantity) as usable_quantity,
				(a.price_te * SUM(a.physical_quantity)) as valuation';
			$this->_join = ' LEFT JOIN `'._DB_PREFIX_.'warehouse` AS w ON w.id_warehouse = a.id_warehouse';
			$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_lang` pl ON (
				a.id_product = pl.id_product
				AND pl.id_lang = '.(int)$this->context->language->id.'
			)';
			$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON (pac.id_product_attribute = a.id_product_attribute)';
			$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute` atr ON (atr.id_attribute = pac.id_attribute)';
			$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (
				al.id_attribute = pac.id_attribute
				AND al.id_lang = '.(int)$this->context->language->id.'
			)';
			$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (
				agl.id_attribute_group = atr.id_attribute_group
				AND agl.id_lang = '.(int)$this->context->language->id.'
			)';
			$this->_where = 'AND a.id_product = '.(int)$id_product.' AND a.id_product_attribute = '.(int)$id_product_attribute;

if ($id_warehouse != -1)
				$this->_where .= ' AND a.id_warehouse = '.(int)$id_warehouse;

$this->_groupBy = 'GROUP BY a.price_te';

self::$currentIndex = self::$currentIndex.'&id_stock='.Tools::getValue('id_stock').'&detailsstock';
			return parent::renderList();
		}
	}

/**
	 * AdminController::getList() override
	 * @see AdminController::getList()
	 */
	public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
	{
		if (Tools::isSubmit('id_stock'))
		{
			parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);

$nb_items = count($this->_list);

for ($i = 0; $i < $nb_items; $i++)
			{
				$item = &$this->_list[$i];
				$manager = StockManagerFactory::getManager();
				$item['real_quantity'] = $manager->getProductRealQuantities(
					$item['id_product'],
					$item['id_product_attribute'],
					($this->getCurrentCoverageWarehouse() == -1 ? null : array($this->getCurrentCoverageWarehouse())),
					true
				);
			}
		}
		else
		{
			if ((Tools::isSubmit('csv_quantities') || Tools::isSubmit('csv_prices')) &&
				(int)Tools::getValue('id_warehouse') != -1)
				$limit = false;

$order_by_valuation = false;
			$order_by_real_quantity = false;

if ($this->context->cookie->{$this->table.'Orderby'} == 'valuation')
			{
				unset($this->context->cookie->{$this->table.'Orderby'});
				$order_by_valuation = true;
			}
			else if ($this->context->cookie->{$this->table.'Orderby'} == 'real_quantity')
			{
				unset($this->context->cookie->{$this->table.'Orderby'});
				$order_by_real_quantity = true;
			}

parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);

$nb_items = count($this->_list);

for ($i = 0; $i < $nb_items; ++$i)
			{
				$item = &$this->_list[$i];

$item['price_te'] = '--';
				$item[$this->identifier] = $item['id_product'].'_'.$item['id_product_attribute'];

// gets stock manager
				$manager = StockManagerFactory::getManager();

// gets quantities and valuation
				$query = new DbQuery();
				$query->select('SUM(physical_quantity) as physical_quantity');
				$query->select('SUM(usable_quantity) as usable_quantity');
				$query->select('SUM(price_te * physical_quantity) as valuation');
				$query->from('stock');
				$query->where('id_product = '.(int)$item['id_product'].' AND id_product_attribute = '.(int)$item['id_product_attribute']);

if ($this->getCurrentCoverageWarehouse() != -1)
					$query->where('id_warehouse = '.(int)$this->getCurrentCoverageWarehouse());

$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($query);

$item['physical_quantity'] = $res['physical_quantity'];
				$item['usable_quantity'] = $res['usable_quantity'];

// gets real_quantity depending on the warehouse
				$item['real_quantity'] = $manager->getProductRealQuantities($item['id_product'],
																			$item['id_product_attribute'],
																			($this->getCurrentCoverageWarehouse() == -1 ? null : array($this->getCurrentCoverageWarehouse())),
																			true);

// removes the valuation if the filter corresponds to 'all warehouses'
				if ($this->getCurrentCoverageWarehouse() == -1)
					$item['valuation'] = 'N/A';
				else
					$item['valuation'] = $res['valuation'];
			}

if ($this->getCurrentCoverageWarehouse() != -1 && $order_by_valuation)
				usort($this->_list, array($this, 'valuationCmp'));
			else if ($order_by_real_quantity)
				usort($this->_list, array($this, 'realQuantityCmp'));
		}
	}

/**
	 * CMP
	 *
	 * @param array $n
	 * @param array $m
	 */
	public function valuationCmp($n, $m)
	{
		if ($this->context->cookie->{$this->table.'Orderway'} == 'desc')
			return $n['valuation'] > $m['valuation'];
		else
			return $n['valuation'] < $m['valuation'];
	}

/**
	 * CMP
	 *
	 * @param array $n
	 * @param array $m
	 */
	public function realQuantityCmp($n, $m)
	{
		if ($this->context->cookie->{$this->table.'Orderway'} == 'desc')
			return $n['real_quantity'] > $m['real_quantity'];
		else
			return $n['real_quantity'] < $m['real_quantity'];
	}

/**
	 * Gets the current warehouse used
	 *
	 * @return int id_warehouse
	 */
	protected function getCurrentCoverageWarehouse()
	{
		static $warehouse = 0;

if ($warehouse == 0)
		{
			$warehouse = -1; // all warehouses
			if ((int)Tools::getValue('id_warehouse'))
				$warehouse = (int)Tools::getValue('id_warehouse');
		}
		return $warehouse;
	}

/**
	 * @see AdminController::initToolbar();
	 */
	public function initToolbar()
	{
		if (Tools::isSubmit('id_warehouse') && (int)Tools::getValue('id_warehouse') != -1)
		{
			$this->toolbar_btn['export-stock-state-quantities-csv'] = array(
				'short' => 'Export this list as CSV',
				'href' => $this->context->link->getAdminLink('AdminStockInstantState').'&amp;csv_quantities&amp;id_warehouse='.(int)$this->getCurrentCoverageWarehouse(),
				'desc' => $this->l('Export Quantities (CSV)'),
				'imgclass' => 'export'
			);

$this->toolbar_btn['export-stock-state-prices-csv'] = array(
				'short' => 'Export this list as CSV',
				'href' => $this->context->link->getAdminLink('AdminStockInstantState').'&amp;csv_prices&amp;id_warehouse='.(int)$this->getCurrentCoverageWarehouse(),
				'desc' => $this->l('Export Prices (CSV)'),
				'imgclass' => 'export'
			);
		}
		parent::initToolbar();
		unset($this->toolbar_btn['new']);
	}

/**
	 * Exports CSV
	 */
	public function renderCSV()
	{
		if (count($this->_list) <= 0)
			return;

// sets warehouse id and warehouse name
		$id_warehouse = (int)Tools::getValue('id_warehouse');
		$warehouse_name = Warehouse::getWarehouseNameById($id_warehouse);

// if quantities requested
		if (Tools::isSubmit('csv_quantities'))
		{
			// filename
			$filename = $this->l('stock_instant_state_quantities').'_'.$warehouse_name.'.csv';

// header
			header('Content-type: text/csv');
			header('Cache-Control: no-store, no-cache');
			header('Content-disposition: attachment; filename="'.$filename);

// puts keys
			$keys = array('id_product', 'id_product_attribute', 'reference', 'ean13', 'upc', 'name', 'physical_quantity', 'usable_quantity', 'real_quantity');
			echo sprintf("%s\n", implode(';', $keys));

// puts rows
			foreach ($this->_list as $row)
			{
				$row_csv = array($row['id_product'], $row['id_product_attribute'], $row['reference'],
								 $row['ean13'], $row['upc'], $row['name'],
								 $row['physical_quantity'], $row['usable_quantity'], $row['real_quantity']
				);

// puts one row
				echo sprintf("%s\n", implode(';', array_map(array('CSVCore', 'wrap'), $row_csv)));
			}
		}
		// if prices requested
		else if (Tools::isSubmit('csv_prices'))
		{
			// sets filename
			$filename = $this->l('stock_instant_state_prices').'_'.$warehouse_name.'.csv';

// header
			header('Content-type: text/csv');
			header('Cache-Control: no-store, no-cache');
			header('Content-disposition: attachment; filename="'.$filename);

// puts keys
			$keys = array('id_product', 'id_product_attribute', 'reference', 'ean13', 'upc', 'name', 'price_te', 'physical_quantity', 'usable_quantity');
			echo sprintf("%s\n", implode(';', $keys));

foreach ($this->_list as $row)
			{
				$id_product = (int)$row['id_product'];
				$id_product_attribute = (int)$row['id_product_attribute'];

// gets prices
				$query = new DbQuery();
				$query->select('s.price_te, SUM(s.physical_quantity) as physical_quantity, SUM(s.usable_quantity) as usable_quantity');
				$query->from('stock', 's');
				$query->leftJoin('warehouse', 'w', 'w.id_warehouse = s.id_warehouse');
				$query->where('s.id_product = '.$id_product.' AND s.id_product_attribute = '.$id_product_attribute);
				$query->where('s.id_warehouse = '.$id_warehouse);
				$query->groupBy('s.price_te');
				$datas = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($query);

// puts data
				foreach ($datas as $data)
				{
					$row_csv = array($row['id_product'], $row['id_product_attribute'], $row['reference'],
									 $row['ean13'], $row['upc'], $row['name'],
									 $data['price_te'], $data['physical_quantity'], $data['usable_quantity']);

// puts one row
					echo sprintf("%s\n", implode(';', array_map(array('CSVCore', 'wrap'), $row_csv)));
				}
			}
		}
	}
	
	public function initContent()
	{
		if (!Configuration::get('PS_ADVANCED_STOCK_MANAGEMENT'))
		{
			$this->warnings[md5('PS_ADVANCED_STOCK_MANAGEMENT')] = $this->l('You need to activate advanced stock management before using this feature.');
			return false;
		}
		parent::initContent();
	}
	
	public function initProcess()
	{
		if (!Configuration::get('PS_ADVANCED_STOCK_MANAGEMENT'))
		{
			$this->warnings[md5('PS_ADVANCED_STOCK_MANAGEMENT')] = $this->l('You need to activate advanced stock management before using this feature.');
			return false;
		}

if (Tools::isSubmit('detailsproduct'))
			$this->list_id = 'details';
		else
			$this->list_id = 'stock';

parent::initProcess();	
	}

}

${this.title}

Code Editor : AdminStockInstantStateController.php