public function actionSelect()
{
$select = new ProductSelectForm();
//var_dump($_POST['ProductSelectForm']);
if (isset($_POST['ProductSelectForm'])) {
$select->attributes = $_POST['ProductSelectForm'];
$select->producer = $_POST['ProductSelectForm']['producer'];
$_GET['kindparent'] = $select->kindparent;
$_GET['inkind'] = $select->inkind;
$_GET['producer'] = $select->producer;
$_GET['min'] = $select->min;
$_GET['max'] = $select->max;
//$_GET['count']=count($_POST['ProductSelectForm']);
//var_dump($_GET);
} else {
$select->kindparent = $_GET['kindparent'];
$select->inkind = $_GET['inkind'];
$select->producer = $_GET['producer'];
$select->min = $_GET['min'];
$select->max = $_GET['max'];
//var_dump($_GET);
}
//var_dump($select->producer);
if ($select->validate()) {
$kindparent = '=tbl_kindparent.kindparent';
$inkind = '=tbl_inkind.inkind';
$producer = '=tbl_producer.producer';
//$producer1='Wilmar';
//$producer2='Марко';
//var_dump($producer1);
$min = '0';
$max = '100000';
$empty = 0;
$c = $select->kindparent;
if ($select->kindparent != 'unselectValue') {
$kindparent = "='{$select->kindparent}'";
} else {
$empty = $empty + 1;
}
//var_dump($c!='unselectValue');
if ($select->inkind != 'unselectValue') {
$inkind = "='{$select->inkind}'";
} else {
$empty = $empty + 1;
}
if (!empty($select->producer)) {
$a = $select->producer;
$producer = " in ('";
for ($i = 0; $i < count($select->producer); $i++) {
if ($i + 1 == count($select->producer)) {
$producer .= "{$a[$i]}')";
} else {
$producer .= "{$a[$i]}','";
}
}
//var_dump($producer);
} else {
$empty = $empty + 1;
}
//If (!empty($select->producer)) $producer=$select->producer;
if (!empty($select->min)) {
$min = $select->min;
} else {
$empty = $empty + 1;
}
if (!empty($select->max)) {
$max = $select->max;
} else {
$empty = $empty + 1;
}
//var_dump($kindparent);
//var_dump($inkind);
//var_dump($producer);
//var_dump($min);
//var_dump( $kindparent);
//var_dump($_POST['ProductSelectForm']);
//var_dump($empty);
//var_dump($select->kindparent);
if ($empty == 5) {
//throw new CHttpException(404, 'The requested page does not exist.');
///$this->redirect(array('site/index'));
} else {
$criteria = new CDbCriteria(array('condition' => "tbl_kindparent.kindparent {$kindparent} and tbl_inkind.inkind {$inkind} and tbl_producer.producer {$producer} and t.cost>=:min and t.cost<=:max", 'join' => ' INNER JOIN tbl_inkind on t.id_inkind=tbl_inkind.id_inkind INNER JOIN tbl_kindparent on tbl_kindparent.id_parent=tbl_inkind.id_parent INNER JOIN tbl_producer on t.id_producer=tbl_producer.id_producer ', 'params' => array(':min' => $min, ':max' => $max)));
//var_dump($criteria);
$dataProvider = new CActiveDataProvider('Product', array('pagination' => array('pageSize' => 6), 'criteria' => $criteria));
$this->render('index', array('dataProvider' => $dataProvider));
}
//$productCount = Product::model()->count($criteria);
// var_dump($productCount);
//$pages = new CPagination($productCount);
//$pages->pageSize = 5;
//$pages->applyLimit($criteria);
//$product = Product::model()->findAll($criteria);
//var_dump($product);
//$this->render('select', array(
// 'product' => $product,
// 'pages' => $pages
//));
} else {
//$error=$search->addError('jkhjh');
//$z=$search->addError('password','Incorrect username or password.');
//$search->getErrors();
//var_dump($z);
//$this->addError('password','Incorrect username or password.');
//var_dump($_POST['ProductSelectForm']);
throw new CHttpException(404, 'The requested page does not exist.');
}
}
