public function actionGoods($category_id)
{
$this->pageTitle = 'Мобильный мир - ' . ($category_id == 1 ? 'телефоны' : ($category_id == 2 ? 'планшеты' : ($category_id == 3 ? 'ноутбуки' : ($category_id == 4 ? 'портативная техника' : ($category_id == 5 ? 'аксессуары' : 'услуги')))));
if ($category_id == 1) {
$cat = $category_id;
//главное меню
$this->menu = Category::model()->findAll();
$criteria = new CDbCriteria();
if (isset($_GET)) {
if (key($_GET) == 'common') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['id'];
}
}
} else {
if (key($_GET) == 'brand') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'type' || key($_GET) == 'form' || key($_GET) == 'os' || key($_GET) == 'sim' || key($_GET) == 'protection' || key($_GET) == 'screen' || key($_GET) == 'core' || key($_GET) == 'core_frequency' || key($_GET) == 'wifi' || key($_GET) == 'GPS') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $item . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'diagonal') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 12';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'camera') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 21';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'front_camera') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
if ($item == 'нет') {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 22';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 22';
}
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'ram') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 25';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'rom') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
if ($item == '0.1-4') {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 26';
} else {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item . ') AND characteristic_id = 26';
}
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'battery') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 41';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
}
}
}
}
}
}
}
}
}
$i = 0;
foreach ($_GET as $k => $items) {
$i++;
if ($i == 2) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 12';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 21';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 22';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 22';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 25';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 41';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 3) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 12';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 21';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 22';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 22';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 25';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 41';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t3 = array();
foreach ($model as $item) {
$t3[] = $item['model_id'];
}
}
}
}
if ($i == 4) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 12';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 21';
}
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 22';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 22';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 25';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 41';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t4 = array();
foreach ($model as $item) {
$t4[] = $item['model_id'];
}
}
}
}
if ($i == 5) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 12';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 21';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 22';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 22';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 25';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 26';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 41';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t5 = array();
foreach ($model as $item) {
$t5[] = $item['model_id'];
}
}
}
}
}
}
if (isset($t1) && isset($t2)) {
$z = array_intersect($t1, $t2);
}
if (isset($z) && isset($t3)) {
$z = array_intersect($z, $t3);
}
if (isset($z) && isset($t4)) {
$z = array_intersect($z, $t4);
}
if (isset($z) && isset($t5)) {
$z = array_intersect($z, $t5);
}
$a = Yii::app()->getRequest()->getQueryString();
if (Yii::app()->request->isAjaxRequest) {
Yii::app()->shoppingCart->put(Models::model()->findByPk($_POST['id']));
$data[0] = Yii::app()->shoppingCart->getCost();
$data[1] = Yii::app()->shoppingCart->getCount();
echo json_encode($data);
// Завершаем приложение
Yii::app()->end();
}
$brand = ModelCategory::model()->findAll('category_id = :category_id', array(':category_id' => $cat));
$array = array();
foreach ($brand as $item) {
$array[] = $item->brand_id;
}
//Бренды для фильтров
//$criter = new CDbCriteria;
//$criter->addInCondition('id', $array);
//$brands = Brand::model()->findAll($criter);
//Товары
if (isset($z)) {
$criteria->addInCondition('t.id', $z);
}
if (!isset($z) && isset($t1)) {
$criteria->addInCondition('t.id', $t1);
}
$criteria->addInCondition('t.brand_id', $array);
/*
if(isset($modelId[0])){
$criteria->addInCondition('id', $modelId);
}
*/
//пагинация
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
$ids = array();
if (!isset($z)) {
foreach ($model as $item) {
$ids[] = $item->id;
}
} else {
if (!isset($z) && isset($t1)) {
$ids = $t1;
} else {
if (isset($z)) {
$ids = $z;
}
}
}
$ids_query = implode(', ', $ids);
//sql запрос - возвращает количество моделей по каждой характеристике в фильтре
$count = Models::filterCategory($ids_query, $category_id);
//подсчет количества производителей
$count_maker_arr = array();
foreach ($model as $item) {
$count_maker_arr[] = $item->brand_id;
}
$count_maker = array_count_values($count_maker_arr);
// подсчет количества моделей "топ продаж"
$count_top = 0;
foreach ($model as $item) {
if ($item->top == 1) {
$count_top++;
}
}
// подсчет количества моделей "Акция"
$count_promotion = 0;
foreach ($model as $item) {
if ($item->promotion == 1) {
$count_promotion++;
}
}
// подсчет количества моделей "Новинки"
$count_novelty = 0;
foreach ($model as $item) {
if ($item->novelty == 1) {
$count_novelty++;
}
}
// подсчет количества моделей "Лучшая цена"
$count_bestPrice = 0;
foreach ($model as $item) {
if ($item->bestPrice == 1) {
$count_bestPrice++;
}
}
$brand_name = Models::model()->cache(1000, null, 2)->with('brandModel')->findAll($criteria);
$count1 = Models::model()->count($criteria);
$pages = new CPagination($count1);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
if (isset($_GET['desc']) && $_GET['desc'] == 1) {
$criteria->order = 'price DESC';
} else {
if (isset($_GET['desc']) && $_GET['desc'] == 2) {
$criteria->order = 'price ASC';
} else {
$criteria->order = 'model_name ASC';
}
}
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
} elseif ($category_id == 2) {
$cat = $category_id;
//главное меню
$this->menu = Category::model()->findAll();
$criteria = new CDbCriteria();
if (isset($_GET)) {
if (key($_GET) == 'common') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['id'];
}
}
} else {
if (key($_GET) == 'brand') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'type' || key($_GET) == 'os' || key($_GET) == 'sim' || key($_GET) == 'screen' || key($_GET) == 'core' || key($_GET) == 'core_frequency' || key($_GET) == 'GPS') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $item . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'diagonal') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 57';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'camera') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 65';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'front_camera') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
if ($item == 'нет') {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 66';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 66';
}
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'ram') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 68';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'rom') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
if ($item == '0.1-4') {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 69';
} else {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item . ') AND characteristic_id = 69';
}
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'battery') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 80';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
}
}
}
}
}
}
}
}
}
$i = 0;
foreach ($_GET as $k => $items) {
$i++;
if ($i == 2) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 57';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 65';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 66';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 66';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 68';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 80';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 3) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 57';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 65';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 66';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 66';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 68';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 80';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 4) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 57';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 65';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 66';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 66';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 68';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 80';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 5) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 57';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 65';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'front_camera') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
if ($item == 'нет') {
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = "' . $item . '") AND characteristic_id = 66';
} else {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 66';
}
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 68';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'rom') {
$querys = $items;
if ($querys[0] == '0.1-4') {
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
if (is_array($querys)) {
foreach ($querys as $item2) {
$filter6[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value = ' . $item2 . ') AND characteristic_id = 69';
}
$sql = implode(' UNION ', $filter6);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
} elseif ($k == 'battery') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter7[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 80';
}
$sql = implode(' UNION ', $filter7);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
}
}
if (isset($t1) && isset($t2)) {
$z = array_intersect($t1, $t2);
}
if (isset($z) && isset($t3)) {
$z = array_intersect($z, $t3);
}
if (isset($z) && isset($t4)) {
$z = array_intersect($z, $t4);
}
if (isset($z) && isset($t5)) {
$z = array_intersect($z, $t5);
}
$a = Yii::app()->getRequest()->getQueryString();
if (Yii::app()->request->isAjaxRequest) {
Yii::app()->shoppingCart->put(Models::model()->findByPk($_POST['id']));
$data[0] = Yii::app()->shoppingCart->getCost();
$data[1] = Yii::app()->shoppingCart->getCount();
echo json_encode($data);
// Завершаем приложение
Yii::app()->end();
}
$brand = ModelCategory::model()->findAll('category_id = :category_id', array(':category_id' => $cat));
$array = array();
foreach ($brand as $item) {
$array[] = $item->brand_id;
}
//Бренды для фильтров
//$criter = new CDbCriteria;
//$criter->addInCondition('id', $array);
//$brands = Brand::model()->findAll($criter);
//Товары
if (isset($z)) {
$criteria->addInCondition('t.id', $z);
}
if (!isset($z) && isset($t1)) {
$criteria->addInCondition('t.id', $t1);
}
$criteria->addInCondition('t.brand_id', $array);
/*
if(isset($modelId[0])){
$criteria->addInCondition('id', $modelId);
}
*/
//пагинация
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
$ids = array();
if (!isset($z)) {
foreach ($model as $item) {
$ids[] = $item->id;
}
} else {
if (!isset($z) && isset($t1)) {
$ids = $t1;
} else {
if (isset($z)) {
$ids = $z;
}
}
}
$ids_query = implode(', ', $ids);
//sql запрос - возвращает количество моделей по каждой характеристике в фильтре
$count = Models::filterCategory($ids_query, $category_id);
//подсчет количества производителей
$count_maker_arr = array();
foreach ($model as $item) {
$count_maker_arr[] = $item->brand_id;
}
$count_maker = array_count_values($count_maker_arr);
// подсчет количества моделей "топ продаж"
$count_top = 0;
foreach ($model as $item) {
if ($item->top == 1) {
$count_top++;
}
}
// подсчет количества моделей "Акция"
$count_promotion = 0;
foreach ($model as $item) {
if ($item->promotion == 1) {
$count_promotion++;
}
}
// подсчет количества моделей "Новинки"
$count_novelty = 0;
foreach ($model as $item) {
if ($item->novelty == 1) {
$count_novelty++;
}
}
// подсчет количества моделей "Лучшая цена"
$count_bestPrice = 0;
foreach ($model as $item) {
if ($item->bestPrice == 1) {
$count_bestPrice++;
}
}
$brand_name = Models::model()->cache(1000, null, 2)->with('brandModel')->findAll($criteria);
$count1 = Models::model()->count($criteria);
$pages = new CPagination($count1);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
if (isset($_GET['desc']) && $_GET['desc'] == 1) {
$criteria->order = 'price DESC';
} else {
if (isset($_GET['desc']) && $_GET['desc'] == 2) {
$criteria->order = 'price ASC';
} else {
$criteria->order = 'model_name ASC';
}
}
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
} elseif ($category_id == 3) {
$cat = $category_id;
//главное меню
$this->menu = Category::model()->findAll();
$criteria = new CDbCriteria();
if (isset($_GET)) {
if (key($_GET) == 'common') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['id'];
}
}
} else {
if (key($_GET) == 'brand') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'type' || key($_GET) == 'os' || key($_GET) == 'cpu_type' || key($_GET) == 'core' || key($_GET) == 'video' || key($_GET) == 'rom') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $item . '" AND characteristic_id > 88';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'diagonal') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 94';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'ram') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 106';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'HDD') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 109';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
} else {
if (key($_GET) == 'SSD') {
$bz = key($_GET);
foreach ($_GET as $items) {
$query = $items;
break;
}
if (is_array($query)) {
$filter = array();
foreach ($query as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 110';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t1[] = $item['model_id'];
}
}
}
}
}
}
}
}
}
$i = 0;
foreach ($_GET as $k => $items) {
$i++;
if ($i == 2) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 94';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 106';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'HDD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 109';
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'SSD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 110';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"AND characteristic_id > 88';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 3) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 94';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 106';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'HDD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 109';
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'SSD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 110';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"AND characteristic_id > 88';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 4) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 94';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 106';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'HDD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 109';
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'SSD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 110';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"AND characteristic_id > 88';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
if ($i == 5) {
if ($k == 'common') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$filter2[] = 'SELECT id FROM {{models}} WHERE ' . $item . '=1';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['id'];
}
}
} elseif ($k == 'brand') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT cms_models.id as model_id FROM cms_models JOIN cms_brand ON brand_id = cms_brand.id WHERE brand = "' . $item . '"';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'diagonal') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter2[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 94';
}
$sql = implode(' UNION ', $filter2);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'ram') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter3[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 106';
}
$sql = implode(' UNION ', $filter3);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'HDD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter4[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 109';
}
$sql = implode(' UNION ', $filter4);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} elseif ($k == 'SSD') {
$querys = $items;
if (is_array($querys)) {
foreach ($querys as $item) {
$items = explode('-', $item);
$item_finish = implode(' AND ', $items);
$filter5[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE (value BETWEEN ' . $item_finish . ') AND characteristic_id = 110';
}
$sql = implode(' UNION ', $filter5);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
} else {
$querys = $items;
if (is_array($querys)) {
$filter = array();
foreach ($querys as $itemt) {
$filter[] = 'SELECT DISTINCT model_id FROM {{characteristicValue}} WHERE value="' . $itemt . '"AND characteristic_id > 88';
}
$sql = implode(' UNION ', $filter);
$connection = Yii::app()->db;
$model = $connection->createCommand($sql)->queryAll();
$t2 = array();
foreach ($model as $item) {
$t2[] = $item['model_id'];
}
}
}
}
}
}
if (isset($t1) && isset($t2)) {
$z = array_intersect($t1, $t2);
}
if (isset($z) && isset($t3)) {
$z = array_intersect($z, $t3);
}
if (isset($z) && isset($t4)) {
$z = array_intersect($z, $t4);
}
if (isset($z) && isset($t5)) {
$z = array_intersect($z, $t5);
}
$a = Yii::app()->getRequest()->getQueryString();
if (Yii::app()->request->isAjaxRequest) {
Yii::app()->shoppingCart->put(Models::model()->findByPk($_POST['id']));
$data[0] = Yii::app()->shoppingCart->getCost();
$data[1] = Yii::app()->shoppingCart->getCount();
echo json_encode($data);
// Завершаем приложение
Yii::app()->end();
}
$brand = ModelCategory::model()->findAll('category_id = :category_id', array(':category_id' => $cat));
$array = array();
foreach ($brand as $item) {
$array[] = $item->brand_id;
}
//Бренды для фильтров
//$criter = new CDbCriteria;
//$criter->addInCondition('id', $array);
//$brands = Brand::model()->findAll($criter);
//Товары
if (isset($z)) {
$criteria->addInCondition('t.id', $z);
}
if (!isset($z) && isset($t1)) {
$criteria->addInCondition('t.id', $t1);
}
$criteria->addInCondition('t.brand_id', $array);
/*
if(isset($modelId[0])){
$criteria->addInCondition('id', $modelId);
}
*/
//пагинация
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
$ids = array();
if (!isset($z)) {
foreach ($model as $item) {
$ids[] = $item->id;
}
} else {
if (!isset($z) && isset($t1)) {
$ids = $t1;
} else {
if (isset($z)) {
$ids = $z;
}
}
}
$ids_query = implode(', ', $ids);
//sql запрос - возвращает количество моделей по каждой характеристике в фильтре
$count = Models::filterCategory($ids_query, $category_id);
//подсчет количества производителей
$count_maker_arr = array();
foreach ($model as $item) {
$count_maker_arr[] = $item->brand_id;
}
$count_maker = array_count_values($count_maker_arr);
// подсчет количества моделей "топ продаж"
$count_top = 0;
foreach ($model as $item) {
if ($item->top == 1) {
$count_top++;
}
}
// подсчет количества моделей "Акция"
$count_promotion = 0;
foreach ($model as $item) {
if ($item->promotion == 1) {
$count_promotion++;
}
}
// подсчет количества моделей "Новинки"
$count_novelty = 0;
foreach ($model as $item) {
if ($item->novelty == 1) {
$count_novelty++;
}
}
// подсчет количества моделей "Лучшая цена"
$count_bestPrice = 0;
foreach ($model as $item) {
if ($item->bestPrice == 1) {
$count_bestPrice++;
}
}
$brand_name = Models::model()->cache(1000, null, 2)->with('brandModel')->findAll($criteria);
$count1 = Models::model()->count($criteria);
$pages = new CPagination($count1);
$pages->pageSize = 10;
$pages->applyLimit($criteria);
if (isset($_GET['desc']) && $_GET['desc'] == 1) {
$criteria->order = 'price DESC';
} else {
if (isset($_GET['desc']) && $_GET['desc'] == 2) {
$criteria->order = 'price ASC';
} else {
$criteria->order = 'model_name ASC';
}
}
$model = Models::model()->cache(1000, null, 2)->with('categoryId')->findAll($criteria);
}
$category = Category::model()->find('id = :id', array(':id' => $category_id));
$this->render('goods', array('model' => $model, 'pages' => $pages, 'category_id' => $category_id, 'brand_name' => $brand_name, 'a' => $a, 'count' => isset($count) ? $count : '', 'count_maker' => $count_maker, 'count_top' => $count_top, 'count_promotion' => $count_promotion, 'count_novelty' => $count_novelty, 'count_bestPrice' => $count_bestPrice, 'category' => $category));
}
