/**
* @author chenliujin <*****@*****.**>
* @since 2016-10-09
*/
public static function GetAllProducts()
{
$sql = "\n\t\t\tSELECT \n\t\t\t\tp.products_type, \n\t\t\t\tp.products_id, \n\t\t\t\tpd.products_name, \n\t\t\t\tp.products_image, \n\t\t\t\tp.products_price, \n\t\t\t\tp.products_tax_class_id, \n\t\t\t\tp.products_date_added, \n\t\t\t\tm.manufacturers_name, \n\t\t\t\tp.products_model, \n\t\t\t\tp.products_quantity, \n\t\t\t\tp.products_weight, \n\t\t\t\tp.product_is_call, \n\t\t\t\tp.product_is_always_free_shipping, \n\t\t\t\tp.products_qty_box_status, \n\t\t\t\tp.master_categories_id \n\t\t\tFROM " . self::GetTableName() . " p LEFT JOIN " . TABLE_MANUFACTURERS . " m ON (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd \n\t\t\tWHERE \n\t\t\t\tp.products_status = 1 AND \n\t\t\t\tp.products_id = pd.products_id AND \n\t\t\t\tpd.language_id = ? \n\t\t\t";
$params = [$_SESSION['languages_id']];
$page = new \Page($sql, $params);
$page->per_page_rows(15);
$page->order_by('ORDER BY products_id DESC');
return $page;
}