/**
* Modifying initial getList method to display position feature (drag and drop)
*/
public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
{
if ($order_by && $this->context->cookie->__get($this->table . 'Orderby')) {
$order_by = $this->context->cookie->__get($this->table . 'Orderby');
} else {
$order_by = 'position';
}
parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
}
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->_list && is_array($this->_list)) {
foreach ($this->_list as $key => $list) {
if ($list['carrier_name'] == '0') {
$this->_list[$key]['carrier_name'] = Carrier::getCarrierNameFromShopName();
}
}
}
}
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->_list && is_array($this->_list)) {
foreach ($this->_list as $key => $list) {
if ($list['carrier_name'] == '0') {
$this->_list[$key]['carrier_name'] = Configuration::get('PS_SHOP_NAME');
}
}
}
}
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 (isset($this->_virtual_item_list) && !empty($this->_virtual_item_list)) {
foreach ($this->_list as &$item) {
foreach ($this->_virtual_item_list as $key) {
$item[$key] = '';
}
}
}
}
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);
foreach ($this->_list as $k => $list) {
if ($list['reduction_type'] == 'amount') {
$this->_list[$k]['reduction_type'] = $this->list_reduction_type['amount'];
} elseif ($list['reduction_type'] == 'percentage') {
$this->_list[$k]['reduction_type'] = $this->list_reduction_type['percentage'];
}
}
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = null)
{
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, 0);
if (!empty($this->_list)) {
$nb = count($this->_list);
for ($i = 0; $i < $nb; $i++) {
if (Configuration::get('APH_PROFILE_STORE_EMPLOYEE') == $this->_list[$i]['id_profile']) {
$this->_list[$i]['email'] = '-';
}
}
}
}
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);
$shop_group_delete_list = array();
// test store authorized to remove
foreach ($this->_list as $shop_group) {
$shops = Shop::getShops(true, $shop_group['id_shop_group']);
if (!empty($shops)) {
$shop_group_delete_list[] = $shop_group['id_shop_group'];
}
}
$this->addRowActionSkipList('delete', $shop_group_delete_list);
}
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);
foreach ($this->_list as $k => $list) {
$currency = $this->cldr->getCurrency($this->_list[$k]['currency_iso_code']);
$this->_list[$k]['currency_name'] = ucfirst($currency['name']);
if ($list['reduction_type'] == 'amount') {
$this->_list[$k]['reduction_type'] = $this->list_reduction_type['amount'];
} elseif ($list['reduction_type'] == 'percentage') {
$this->_list[$k]['reduction_type'] = $this->list_reduction_type['percentage'];
}
}
}
public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
{
parent::getList((int) $id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
if (count($this->_list)) {
$this->product_attachements = Attachment::getProductAttached((int) $id_lang, $this->_list);
$list_product_list = array();
foreach ($this->_list as $list) {
$product_list = '';
if (isset($this->product_attachements[$list['id_attachment']])) {
foreach ($this->product_attachements[$list['id_attachment']] as $product) {
$product_list .= $product . ', ';
}
}
$list_product_list[$list['id_attachment']] = $product_list;
}
// Assign array in list_action_delete.tpl
$this->tpl_delete_link_vars = array('product_list' => $list_product_list, 'product_attachements' => $this->product_attachements);
}
}
/**
* Modifying initial getList method to display position feature (drag and drop)
*/
public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
{
if (Tools::isSubmit($this->table . 'Orderby') || Tools::isSubmit($this->table . 'Orderway')) {
$this->filter = true;
}
if ($order_by && $this->context->cookie->__get($this->table . 'Orderby')) {
$order_by = $this->context->cookie->__get($this->table . 'Orderby');
} else {
$order_by = 'position';
}
if (is_null($order_way)) {
$order_way = Tools::getValue($this->table . 'Orderway', 'ASC');
}
parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
}
public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
{
if (Shop::getContext() == Shop::CONTEXT_GROUP) {
$this->_where .= ' AND a.id_shop_group = ' . (int) Shop::getContextShopGroupID();
}
parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
$shop_delete_list = array();
// don't allow to remove shop which have dependencies (customers / orders / ... )
foreach ($this->_list as &$shop) {
if (Shop::hasDependency($shop['id_shop'])) {
$shop_delete_list[] = $shop['id_shop'];
}
}
$this->context->smarty->assign('shops_having_dependencies', $shop_delete_list);
}
/**
* AdminController::getList() override
* @see AdminController::getList()
*
* @param int $id_lang
* @param string|null $order_by
* @param string|null $order_way
* @param int $start
* @param int|null $limit
* @param int|bool $id_lang_shop
*
* @throws PrestaShopException
*/
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);
// foreach item in the list to render
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
// depending on the management type, translates the management type
$item =& $this->_list[$i];
switch ($item['management_type']) {
// management type can be either WA/FIFO/LIFO
case 'WA':
$item['management_type'] = $this->l('WA: Weighted Average');
break;
case 'FIFO':
$item['management_type'] = $this->l('FIFO: First In, First Out');
break;
case 'LIFO':
$item['management_type'] = $this->l('LIFO: Last In, First Out');
break;
}
}
}
/**
* 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->ajax) {
foreach ($this->_list as &$list) {
if (file_exists(_PS_IMG_DIR_ . $this->fieldImageSettings['dir'] . '/' . (int) $list['id_attribute'] . '.jpg')) {
if (!isset($list['color']) || !is_array($list['color'])) {
$list['color'] = array();
}
$list['color']['texture'] = '../img/' . $this->fieldImageSettings['dir'] . '/' . (int) $list['id_attribute'] . '.jpg';
}
}
} else {
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
$item =& $this->_list[$i];
$query = new DbQuery();
$query->select('COUNT(a.id_attribute) as count_values');
$query->from('attribute', 'a');
$query->join(Shop::addSqlAssociation('attribute', 'a'));
$query->where('a.id_attribute_group =' . (int) $item['id_attribute_group']);
$query->groupBy('attribute_shop.id_shop');
$query->orderBy('count_values DESC');
$item['count_values'] = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
unset($query);
}
}
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = null)
{
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, 0);
$currency = $this->context->currency;
if (!empty($this->_list)) {
$nb = count($this->_list);
for ($i = 0; $i < $nb; $i++) {
//$image = new AphOfferImage((int)$this->_list[$i]['id_image']);
//$this->_list[$i]['image'] = AphOfferImage::getImgFolderStatic((int)$this->_list[$i]['id_image']).$this->_list[$i]['id_image'].'.jpg';
$this->_list[$i]['available'] = 'Dal ' . Tools::displayDate($this->_list[$i]['available_from_date'], (int) Context::getContext()->language->id, false) . ' al ' . Tools::displayDate($this->_list[$i]['available_to_date'], (int) Context::getContext()->language->id, false);
$this->_list[$i]['visible'] = 'Dal ' . Tools::displayDate($this->_list[$i]['visible_from_date'], (int) Context::getContext()->language->id, false) . ' al ' . Tools::displayDate($this->_list[$i]['visible_to_date'], (int) Context::getContext()->language->id, false);
$this->_list[$i]['new_price'] = $this->_list[$i]['price_wt'] < 0 ? $this->_list[$i]['reduction_type'] == 'percentage' ? '-' . intval(round($this->_list[$i]['reduction'])) . '%' : '-' . Tools::displayPrice($this->_list[$i]['reduction'], (int) Context::getContext()->currency->id) : Tools::displayPrice($this->_list[$i]['price_wt'], (int) Context::getContext()->currency->id) . ' ';
}
}
}
/**
* 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);
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
if (isset($this->_list[$i]['messages'])) {
$this->_list[$i]['messages'] = Tools::htmlentitiesDecodeUTF8($this->_list[$i]['messages']);
}
}
}
/**
* AdminController::getList() override
* @see AdminController::getList()
*
* @param int $id_lang
* @param string|null $order_by
* @param string|null $order_way
* @param int $start
* @param int|null $limit
* @param int|bool $id_lang_shop
*
* @throws PrestaShopException
*/
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);
// Check each row to see if there are combinations and get the correct action in consequence
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; $i++) {
$item =& $this->_list[$i];
// if it's an ajax request we have to consider manipulating a product variation
if (Tools::isSubmit('id_product')) {
$item['name'] = Product::getProductName($item['id_product'], $item['id']);
// no details for this row
$this->addRowActionSkipList('details', array($item['id']));
// specify actions in function of stock
$this->skipActionByStock($item, true);
} elseif (array_key_exists('variations', $item) && (int) $item['variations'] > 0) {
// we have to desactivate stock actions on current row
$this->addRowActionSkipList('addstock', array($item['id']));
$this->addRowActionSkipList('removestock', array($item['id']));
$this->addRowActionSkipList('transferstock', array($item['id']));
// does not display these informaions because this product has combinations
$item['reference'] = '--';
$item['ean13'] = '--';
$item['upc'] = '--';
} else {
//there are no variations of current product, so we don't want to show details action
$this->addRowActionSkipList('details', array($item['id']));
// specify actions in function of stock
$this->skipActionByStock($item, false);
}
// Checks access
if (!($this->tabAccess['add'] === '1')) {
$this->addRowActionSkipList('addstock', array($item['id']));
}
if (!($this->tabAccess['delete'] === '1')) {
$this->addRowActionSkipList('removestock', array($item['id']));
}
if (!($this->tabAccess['edit'] === '1')) {
$this->addRowActionSkipList('transferstock', array($item['id']));
}
}
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = null)
{
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, $id_lang_shop);
if ($this->_list) {
foreach ($this->_list as &$row) {
$row['badge_success'] = $row['total_spent'] > 0;
}
}
}
/**
* 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('csv_orders') || Tools::isSubmit('csv_orders_details') || Tools::isSubmit('csv_order_details')) {
$limit = false;
}
// defines button specific for non-template supply orders
if (!$this->is_template_list && $this->display != 'details') {
// adds export csv buttons
$this->toolbar_btn['export-csv-orders'] = array('short' => 'Export Orders', 'href' => $this->context->link->getAdminLink('AdminSupplyOrders') . '&csv_orders&id_warehouse=' . $this->getCurrentWarehouse(), 'desc' => $this->l('Export Orders (CSV)'), 'class' => 'process-icon-export');
$this->toolbar_btn['export-csv-details'] = array('short' => 'Export Orders Details', 'href' => $this->context->link->getAdminLink('AdminSupplyOrders') . '&csv_orders_details&id_warehouse=' . $this->getCurrentWarehouse(), 'desc' => $this->l('Export Orders Details (CSV)'), 'class' => 'process-icon-export');
unset($this->toolbar_btn['new']);
if ($this->tabAccess['add'] === '1') {
$this->toolbar_btn['new'] = array('href' => self::$currentIndex . '&add' . $this->table . '&token=' . $this->token, 'desc' => $this->l('Add New'));
}
}
parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
// adds colors depending on the receipt state
if ($order_by == 'quantity_expected') {
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
$item =& $this->_list[$i];
if ($item['quantity_received'] == $item['quantity_expected']) {
$item['color'] = '#00bb35';
} elseif ($item['quantity_received'] > $item['quantity_expected']) {
$item['color'] = '#fb0008';
}
}
}
// actions filters on supply orders list
if ($this->table == 'supply_order') {
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; $i++) {
// if the current state doesn't allow order edit, skip the edit action
if ($this->_list[$i]['editable'] == 0) {
$this->addRowActionSkipList('edit', $this->_list[$i]['id_supply_order']);
}
if ($this->_list[$i]['enclosed'] == 1 && $this->_list[$i]['receipt_state'] == 0) {
$this->addRowActionSkipList('changestate', $this->_list[$i]['id_supply_order']);
}
if (1 != $this->_list[$i]['pending_receipt']) {
$this->addRowActionSkipList('updatereceipt', $this->_list[$i]['id_supply_order']);
}
}
}
}
/**
* AdminController::getList() override
* @see AdminController::getList()
*
* @param int $id_lang
* @param string|null $order_by
* @param string|null $order_way
* @param int $start
* @param int|null $limit
* @param int|bool $id_lang_shop
*
* @throws PrestaShopException
*/
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();
// 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'];
$item['valuation'] = $res['valuation'];
$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;
} elseif ($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'));
} elseif ($order_by_real_quantity) {
usort($this->_list, array($this, 'realQuantityCmp'));
}
}
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = false)
{
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, Context::getContext()->shop->id);
}
public function getList($id_lang, $orderBy = null, $orderWay = null, $start = 0, $limit = null, $id_lang_shop = null)
{
$orderByPriceFinal = empty($orderBy) ? $this->context->cookie->__get($this->table . 'Orderby') ? $this->context->cookie->__get($this->table . 'Orderby') : 'id_' . $this->table : $orderBy;
$orderWayPriceFinal = empty($orderWay) ? $this->context->cookie->__get($this->table . 'Orderway') ? $this->context->cookie->__get($this->table . 'Orderby') : 'ASC' : $orderWay;
if ($orderByPriceFinal == 'price_final') {
$orderBy = 'id_' . $this->table;
$orderWay = 'ASC';
}
parent::getList($id_lang, $orderBy, $orderWay, $start, $limit, $this->context->shop->id);
/* update product quantity with attributes ...*/
$nb = count($this->_list);
if ($this->_list) {
$context = $this->context->cloneContext();
$context->shop = clone $context->shop;
/* update product final price */
for ($i = 0; $i < $nb; $i++) {
if (Context::getContext()->shop->getContext() != Shop::CONTEXT_SHOP) {
$context->shop = new Shop((int) $this->_list[$i]['id_shop_default']);
}
// convert price with the currency from context
$this->_list[$i]['price'] = Tools::convertPrice($this->_list[$i]['price'], $this->context->currency, true, $this->context);
$this->_list[$i]['price_tmp'] = Product::getPriceStatic($this->_list[$i]['id_product'], true, null, 2, null, false, true, 1, true, null, null, null, $nothing, true, true, $context);
}
}
if ($orderByPriceFinal == 'price_final') {
if (strtolower($orderWayPriceFinal) == 'desc') {
uasort($this->_list, 'cmpPriceDesc');
} else {
uasort($this->_list, 'cmpPriceAsc');
}
}
for ($i = 0; $this->_list && $i < $nb; $i++) {
$this->_list[$i]['price_final'] = $this->_list[$i]['price_tmp'];
unset($this->_list[$i]['price_tmp']);
}
}
public function getList($id_lang, $order_by = null, $order_way = null, $start = 0, $limit = null, $id_lang_shop = false)
{
$alias = 'sa';
parent::getList($id_lang, $alias . '.position', $order_way, $start, $limit, Context::getContext()->shop->id);
// Check each row to see if there are combinations and get the correct action in consequence
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; $i++) {
$item =& $this->_list[$i];
$category_tree = Category::getChildren((int) $item['id_category'], $this->context->language->id);
if (!count($category_tree)) {
$this->addRowActionSkipList('view', array($item['id_category']));
}
}
}
/**
* AdminController::getList() override
* @see AdminController::getList()
*
* @param int $id_lang
* @param string|null $order_by
* @param string|null $order_way
* @param int $start
* @param int|null $limit
* @param int|bool $id_lang_shop
*
* @throws PrestaShopException
*/
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'] = '--';
}
}
}
}
/**
* 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 there is a field product_name in the list, check if this field is null and display standard message
foreach ($this->fields_list as $key => $value) {
if ($key == 'product_name') {
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
$item =& $this->_list[$i];
if (empty($item['product_name'])) {
$item['product_name'] = $this->l('The name of this product is not available. It may have been deleted from the system.');
}
}
}
}
}
/**
* 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 ($this->table == 'feature_value') {
$this->_where .= ' AND (a.custom = 0 OR a.custom IS NULL)';
}
parent::getList($id_lang, $order_by, $order_way, $start, $limit, $id_lang_shop);
if ($this->table == 'feature') {
$nb_items = count($this->_list);
for ($i = 0; $i < $nb_items; ++$i) {
$item =& $this->_list[$i];
$query = new DbQuery();
$query->select('COUNT(fv.id_feature_value) as count_values');
$query->from('feature_value', 'fv');
$query->where('fv.id_feature =' . (int) $item['id_feature']);
$query->where('(fv.custom=0 OR fv.custom IS NULL)');
$res = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($query);
$item['value'] = (int) $res;
unset($query);
}
}
}
