Showing Stock Level in Product List

Code: Select all

    	$cols[] = array(
      		'name'  => $language->get('column_model'),
      		'sort'  => 'p.model',
      		'align' => 'left'
    	);
		
[NEW]    	$cols[] = array(
      		'name'  => $language->get('column_stock'),
      		'sort'  => 'p.quantity',
      		'align' => 'left'
    	);[/NEW]
  
    	$cols[] = array(
      		'name'  => $language->get('column_status'),
      		'sort'  => 'p.status',
      		'align' => 'center'
    	);

Code: Select all

    	if (!$session->get('product.search')) {
      		$sql = "select p.product_id, pd.name[NEW], p.quantity[/NEW], p.model, p.sort_order, p.status from product p left join product_description pd on (p.product_id = pd.product_id) where pd.language_id = '" . (int)$language->getId() . "'";
    	} else {
      		$sql = "select p.product_id, pd.name[NEW], p.quantity[/NEW], p.model, p.sort_order, p.status from product p left join product_description pd on (p.product_id = pd.product_id) where pd.language_id = '" . (int)$language->getId() . "' and pd.name like '?'";
    	}

Code: Select all

		$sort = array(
	  		'pd.name', 
			'p.model',
 [NEW]			'p.quantity', [/NEW]
	  		'p.sort_order', 
	  		'p.status'
		);

Code: Select all

      		$cell[] = array(
        		'value' => $result['model'],
        		'align' => 'left'
      		);

[NEW]      		$cell[] = array(
        		'value' => $result['quantity'],
        		'align' => 'left'
      		);[/NEW]
			
      		$cell[] = array(
        		'icon'  => ($result['status'] ? 'enabled.png' : 'disabled.png'),
        		'align' => 'center'
      		);

Code: Select all

$_['column_model']         = 'Model';
[NEW]$_['column_stock']         = 'Stock';[/NEW]
$_['column_sort_order']    = 'Sort Order';