public static function findBusiness($strLink, $strSQL)
{
$curPage = 1;
if (isset($_REQUEST['page'])) {
$curPage = $_REQUEST['page'];
}
$maxItems = 5;
$maxPages = 25;
$offset = ($curPage - 1) * $maxItems;
$strCountSQL = str_replace("*", " count(*) ", $strSQL);
$totalItems = DichVuBUS::countAllBySQL($strCountSQL);
$strSQL .= " limit {$offset},{$maxItems}";
$business = DichVuBUS::getAllBySQL($strSQL);
if (isset($_REQUEST['cbbGia']) && $_REQUEST['cbbGia'] != -1) {
$array = null;
switch ($_REQUEST['cbbGia']) {
case 1:
$array = BusinessProcessor::findPrice($business, 0, 5000000);
break;
case 2:
$array = BusinessProcessor::findPrice($business, 5000000, 50000000);
break;
case 3:
$array = BusinessProcessor::findPrice($business, 50000000, 500000000);
break;
case 4:
$array = BusinessProcessor::findPrice($business, 500000000, 1000000000);
break;
case 5:
$array = BusinessProcessor::findPrice($business, 1000000000, 1500000000);
break;
case 6:
$array = BusinessProcessor::findPrice($business, 1500000000, 3000000000.0);
break;
case 7:
$array = BusinessProcessor::findPrice($business, 3000000000.0, 10000000000.0);
break;
case 8:
$array = BusinessProcessor::findPrice($business, 10000000000.0, 999999999999999.0);
break;
}
$business = $array;
$totalItems = count($business);
}
return BusinessProcessor::display($strLink, $business, $totalItems, $curPage, $maxPages, $maxItems);
}
