$res = "Минимальные цены обновленны успешно."; break; case 'get_prods': $avaliable_fields = array("category" => array("filter_type" => "text", "column_name" => "categories"), "brand" => array("filter_type" => "text", "column_name" => "manufacturer"), "sku" => array("filter_type" => "text", "column_name" => "e.sku"), "price" => array("filter_type" => "text", "column_name" => "min_price")); $provs =& Providers::getProviders(); foreach ($provs as $id => $prov) { $avaliable_fields["providers_products_{$id}_price"] = array("filter_type" => "float", "column_name" => "providers_products_{$id}.price"); } $filter_str = ""; if (isset($_REQUEST["filter_compare"]) && isset($_REQUEST["filter_values"]) && count($_REQUEST["filter_compare"]) && count($_REQUEST["filter_values"])) { $filter_str = buildFilterStr($avaliable_fields, $_REQUEST["filter_compare"], $_REQUEST["filter_values"]); } if ($_REQUEST['subaction']) { switch ($_REQUEST['subaction']) { case 'getcount': $res = Product::getOurProductsCount($filter_str); break; } } else { $start = (int) $_REQUEST['start']; $count = (int) $_REQUEST['count']; $order_str = ""; if (isset($_REQUEST["sort_column_name"]) && isset($avaliable_fields[$_REQUEST["sort_column_name"]])) { $order_str = " order by " . $avaliable_fields[$_REQUEST["sort_column_name"]]["column_name"]; if (isset($_REQUEST["sort_order"]) && (strtolower($_REQUEST["sort_order"]) == 'asc' || strtolower($_REQUEST["sort_order"]) == 'desc')) { $order_str .= " " . strtolower($_REQUEST["sort_order"]); } } if ($count > 0) { $res = Product::getOurProdsByPage($start, $count, $filter_str, $order_str); }