Example #1
0
     $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);
         }