public static function GetLatestItems($number)
{
//$sql = 'UPDATE products SET pack_size = '.$packsize.', featured = '.$featured.', availability = '.$availability.', catalog_bal = '.$openstock.', stock_bal = '.$openstock.', optimum_bal = '.$optstock.', low_bal = '.$lowstock.' WHERE id = '.$item->itemId;
$stock_accounts = array();
$sql = 'SELECT * FROM stock_accounts ORDER BY tstamp DESC LIMIT 0,' . intval($number);
$stocks = DatabaseHandler::GetAll($sql);
foreach ($stocks as $stock) {
$sql = 'SELECT * FROM products WHERE resource_id = ' . $stock['resource_id'];
$sqlf = 'SELECT * FROM features WHERE resource_id = ' . $stock['resource_id'];
$product = DatabaseHandler::GetRow($sql);
$features = DatabaseHandler::GetAll($sqlf);
//$sqlf = 'SELECT * FROM item_features WHERE item_id = '.$product['id'];
$typedata = ResourceType::GetTypeData($product['type_id']);
$unit = Unit::GetUnitById($typedata['unit_id']);
$item = new Product($product['resource_id'], $product['type_id'], $typedata['type'], $product['name'], $product['reference'], $unit, $product['description'], $features, $product['manufacturer'], $product['retail_price'], $product['wholesale_price'], $product['tax_code'], $product['img_url'], $product['plength'], $product['pwidth'], $product['pheight'], $product['pweight'], $product['pshape']);
$stockAccount = new StockAccount($stock['account_id'], $item, $stock['pack_size'], $stock['featured'], $stock['availability'], $stock['catalog_bal'], $stock['stock_bal'], $stock['optimum_bal'], $stock['low_bal'], $stock['cost_price'], $stock['retail_price'], $stock['wholesale_price'], $stock['vat_code'], $stock['date_added'], $stock['tstamp']);
$stock_accounts[] = $stockAccount;
}
//do something as an inventory objects
return $stock_accounts;
}
