public function actionTyres()
 {
     $sizes = array();
     $form = $_GET;
     $selection = new TyreSelectionForm();
     $pages = null;
     if (!empty($form)) {
         $selection->attributes = $form;
         if ($selection->validate()) {
             $criteria = new CDbCriteria();
             $criteria->with = array('tyre');
             if (!empty($selection->producers)) {
                 $crit0 = new CDbCriteria();
                 $crit0->with = array('producer');
                 $crit0->compare('producer.alias', $selection->producers);
                 // Собираю шины производителей подходящих под условия фильтра
                 $tyres = CHtml::listData(Tyre::model()->findAll($crit0), 'id', 'id');
                 $criteria->compare('tyre_id', $tyres);
             }
             #$criteria->compare('code',$this->code,true);
             $criteria->compare('width', $selection->width, true);
             $criteria->compare('height', $selection->height, true);
             $criteria->compare('diameter', $selection->diameter, true);
             $criteria->compare('tyre.season', $selection->season);
             $criteria->compare('tyre.stud', $selection->puncture);
             $criteria->compare('price', '>=' . $selection->price_from, false);
             $criteria->compare('price', '<=' . $selection->price_until, false);
             $criteria->compare('price', '<>0');
             $criteria->mergeWith(TyreSizes::model()->inSight()->getDbCriteria());
             $data = new CActiveDataProvider('TyreSizes', array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->params['selection.resultsPerPage'])));
         }
     }
     $this->render('tyres', array('selection' => $selection, 'data' => $data));
 }
 public function run()
 {
     if (Yii::app()->request->isAjaxRequest && isset($_GET['producer_id'])) {
         $producer_id = Yii::app()->request->getParam('producer_id');
         // this was set with the "max" attribute of the CAutoComplete widget
         $limit = Yii::app()->request->getParam('limit', 50);
         $limit = min($limit, 50);
         $criteria = new CDbCriteria();
         $criteria->condition = "producer_id = :sterm";
         $criteria->params = array(":sterm" => $producer_id);
         $criteria->limit = $limit;
         $criteria->order = 'title';
         echo CJavaScript::jsonEncode(CHtml::listData(Tyre::model()->findAll($criteria), 'id', 'title'));
     }
 }
 private function showTyresByModel($alias, $season = null, $stud = null)
 {
     $criteria = new CDbCriteria();
     $criteria->condition = 'tyre.alias = :alias';
     $criteria->params = array(':alias' => $alias);
     if (!($model = Tyre::model()->find('alias = :alias', array(':alias' => $alias)))) {
         throw new CHttpException(400, 'Такой страницы нет');
     }
     // Сезонность
     if ($season && L::r_item('tyreSeason', $season)) {
         $criteria->addCondition('tyre.season = ' . L::r_item('tyreSeason', $season));
     }
     // Шипованность
     if ($stud == 'studded') {
         $criteria->addCondition('tyre.stud = 1');
     }
     if ($stud == 'not_studded') {
         $criteria->addCondition('tyre.stud = 0');
     }
     $criteria->addCondition('t.rest <> "0"');
     $criteria->with = array('tyre');
     $dataProvider = new CActiveDataProvider('TyreSizes', array('criteria' => $criteria));
     $this->addComment($model);
     $this->render('tyres/sizes', array('dataProvider' => $dataProvider, 'season' => $season, 'stud' => $stud, 'model' => $model));
 }
 public function actionNomenclature()
 {
     ini_set('memory_limit', '650M');
     set_time_limit(0);
     $tyresForm = new ImportForm();
     $result = array();
     // Uncomment the following line if AJAX validation is needed
     // $this->performAjaxValidation($model);
     if (isset($_POST['ImportForm'])) {
         $tyresForm->attributes = $_POST['ImportForm'];
         if ($tyresForm->validate()) {
             # Вот тут начинается импорт
             Yii::import('ext.markdown.*');
             Yii::import('ext.markdownify.*');
             Yii::import('webroot.helpers.*');
             #$tyresForm->file = CUploadedFile::getInstance($tyresForm, 'file');
             /* Первая страница
              * 1. CAI
              * 2. Производитель
              * 3. Модель
              * 4. Сезон
              * 5. Применяемость
              * 6. Тип протектора
              * 7. Шипованность
              * 8. Ширина профиля(мм)
              * 9. Высота профиля (%)
              * 10. Диаметр (,R)
              * 11. Индекс скорости
              * 12. Индекс нагрузки
              * 13. Цена
              * 14. Фото, большое
              * 15. Фото, мелкое
             */
             $uploaded = Yii::app()->file->set('ImportForm[file]');
             Yii::app()->file->set(Yii::getPathOfAlias('webroot.files.' . $this->id . '.' . $this->action->id))->createDir();
             $newfile = $uploaded->copy(strtolower(Yii::getPathOfAlias('webroot.files.' . $this->id . '.' . $this->action->id)) . '/' . $uploaded->basename);
             $newfile->filename = $newfile->filename . '.' . date('YmdHis');
             Yii::import('ext.phpexcelreader.EPhpExcelReader');
             $data = new EPhpExcelReader($newfile->realpath, false);
             $rowcount = $data->rowcount();
             #$colcount = $data->colcount();
             #$rowcount = 3;
             $r = 2;
             while ($r <= $rowcount) {
                 $producer_alias = EString::strtolower(EString::sanitize($data->val($r, 2)));
                 if (!($producer = TyreProducers::model()->find('alias=:alias', array(':alias' => $producer_alias)))) {
                     $producer = new TyreProducers();
                     @($result['new_producers'] += 1);
                 } else {
                     @($result['old_producers'] += 1);
                 }
                 $producer->title = $data->val($r, 2);
                 $producer->alias = $producer_alias;
                 if (!$producer->save()) {
                     $result['errors']['producer:' . $data->val($r, 1)] = $producer->errors;
                 }
                 $tyre_alias = EString::strtolower(EString::sanitize($data->val($r, 3)));
                 if (!($tyre = Tyre::model()->find('alias=:alias', array(':alias' => $tyre_alias)))) {
                     $tyre = new Tyre();
                     @($result['new_tyres'] += 1);
                 } else {
                     @($result['old_tyres'] += 1);
                 }
                 $tyre->producer_id = $producer->id;
                 $tyre->title = $data->val($r, 3);
                 $tyre->alias = $tyre_alias;
                 $tyre->new = true;
                 $tyre->currency = L::r_item('tyreCurrency', $data->val($r, 5)) ? L::r_item('tyreCurrency', $data->val($r, 5)) : 0;
                 if ($data->val($r, 4) == 'зимние') {
                     $tyre->season = L::r_item('tyreSeason', 'winter');
                 }
                 if ($data->val($r, 4) == 'летние') {
                     $tyre->season = L::r_item('tyreSeason', 'summer');
                 }
                 if ($data->val($r, 4) == 'всесезонные') {
                     $tyre->season = L::r_item('tyreSeason', 'yearround');
                 }
                 $tyre->stud = $data->val($r, 7) ? 1 : 0;
                 $tyre->construction_type = 1;
                 $tyre->runflat_type = 0;
                 // загрузка картинок...
                 $alias = EString::sanitize($producer_alias . '_' . $tyre_alias);
                 $path0 = Yii::getPathOfAlias('webroot.files.' . EString::strtolower('Tyre') . '.' . 'photo') . DIRECTORY_SEPARATOR;
                 $f = false;
                 $tmp_image = str_replace('.jpg', '.png', $data->val($r, 14));
                 if (!empty($tmp_image) && empty($tyre->photo)) {
                     #d($tmp_image);
                     #d($tyre->photo);
                     foreach (Tyre::model()->images['photo']['sizes'] as $key => $size) {
                         $pic = null;
                         // папка в которой будет хранится картинка
                         $path = $path0 . $key . DIRECTORY_SEPARATOR;
                         // создаю папку если ее не было
                         EFile::set($path)->createDir();
                         $pic = @file_get_contents('http://www.4tochki.ru' . $tmp_image);
                         $info = pathinfo($tmp_image);
                         #$row['pic_file'] - 117*(65-88) (лента слева)
                         if (empty($pic)) {
                             continue;
                         }
                         $fullpath = $path . $alias . '.jpg';
                         file_put_contents($fullpath, $pic);
                         $pic = Yii::app()->image->load($fullpath);
                         $pic->thumb(isset($size[0]) ? $size[0] : 0, isset($size[1]) ? $size[1] : 0, true, '#FFFFFF');
                         if ($key == 'big') {
                             $pic->watermark(Yii::getPathOfAlias('webroot') . Yii::app()->params['watermark'], 5);
                         }
                         $pic->save($fullpath);
                         $f = true;
                     }
                     if ($f) {
                         if (!($image = Image::model()->find('filename=:alias', array(':alias' => '/files/tyre/photo/::size::/' . $alias . '.jpg')))) {
                             $image = new Image();
                         }
                         $image->created = date('Y-m-d H:i:s', strtotime($row['add_date']));
                         $image->filename = '/files/tyre/photo/::size::/' . $alias . '.jpg';
                         $image->title = $producer->title . ' ' . $tyre->title;
                         $image->alt = $producer->title . ' ' . $tyre->title;
                         $image->save();
                         $tyre->photo = '/files/tyre/photo/::size::/' . $alias . '.jpg';
                     } else {
                         $tyre->photo = null;
                     }
                 }
                 if (!$tyre->save()) {
                     $result['errors']['tyre:' . $data->val($r, 1)] = $tyre->errors;
                 }
                 $cai = $data->val($r, 1);
                 if (!($size = TyreSizes::model()->find('code=:code', array(':code' => $cai)))) {
                     $size = new TyreSizes();
                     $size->alias = uniqid();
                     $size->save(false);
                     @($result['new_size'] += 1);
                 } else {
                     @($result['old_size'] += 1);
                 }
                 $size->tyre_id = $tyre->id;
                 $size->code = $cai;
                 $size->width = $data->val($r, 8);
                 $size->height = $data->val($r, 9);
                 $size->diameter = $data->val($r, 10);
                 $size->speed_rating = preg_replace('/[0-9]/isU', '', $data->val($r, 11));
                 $size->load_index = preg_replace('/[a-z]/isU', '', $data->val($r, 12));
                 $size->price = 0;
                 $size->rest = 0;
                 #d($size->attributes);
                 $size->alias = $size->id . '-' . $size->width . '-' . $size->height . '-' . $size->diameter . '-' . $size->speed_rating . $size->load_index;
                 # Сохраняю...
                 if (!$size->save()) {
                     $result['errors']['size:' . $data->val($r, 1)] = $size->errors;
                 }
                 $r++;
             }
             #$this->redirect(array('view','id'=>$model->id));
         }
     }
     $this->render('nomenclature', array('model' => $tyresForm, 'results' => $result));
 }
Example #5
0
<?php

$this->breadcrumbs = array('Типоразмеры' => array('index'), 'Управление типоразмерами');
$this->menu = array(array('label' => 'Обзор типоразмеров', 'url' => array('index')), array('label' => 'Добавить типоразмер', 'url' => array('create')));
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$.fn.yiiGridView.update('tyre-sizes-grid', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>

<h1>Управление типоразмерами</h1>

<p>
Можно использовать операторы сравнения (<b>&lt;</b>, <b>&lt;=</b>, <b>&gt;</b>, <b>&gt;=</b>, <b>&lt;&gt;</b>
или <b>=</b>) в начале запроса.
</p>

<?php 
echo CHtml::link('Расширенный поиск', '#', array('class' => 'search-button'));
?>
<div class="search-form" style="display:none">
<?php 
$this->renderPartial('_search', array('model' => $model));
?>
</div><!-- search-form -->

<?php 
$this->widget('zii.widgets.grid.CGridView', array('id' => 'tyre-sizes-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('code', array('name' => 'producer', 'value' => '$data->tyre->producer->title', 'filter' => CHtml::listData(TyreProducers::model()->findAll(), 'id', 'title')), array('name' => 'tyre_id', 'value' => '$data->tyre->title', 'filter' => CHtml::listData(Tyre::model()->findAll('producer_id=:id', array(':id' => $model->producer)), 'id', 'title')), 'width', 'height', 'diameter', 'load_index', 'speed_rating', 'price', 'rest', array('class' => 'CButtonColumn'))));
 /**
  * Returns the data model based on the primary key given in the GET variable.
  * If the data model is not found, an HTTP exception will be raised.
  * @param integer the ID of the model to be loaded
  */
 public function loadModel($id)
 {
     $model = Tyre::model()->findByPk((int) $id);
     if ($model === null) {
         throw new CHttpException(404, 'Запрашиваемая страница не существует.');
     }
     return $model;
 }
Example #7
0
	<div class="row">
		<?php 
Yii::app()->clientScript->registerScriptFile($this->assets . '/js/jquery.selectboxes.min.js');
?>
		<?php 
echo $form->labelEx($model, 'tyre_id');
?>
		<div class='input'>
			<div>Производитель<br />
			<?php 
echo CHtml::dropDownList(null, $model->isNewRecord ? null : $model->tyre->producer_id, CHtml::listData(TyreProducers::model()->findAll(), 'id', 'title'), array('id' => 'tyreProducersList', 'ajax' => array('url' => CHtml::normalizeUrl(array('tyres/sizes/ajaxTyres')), 'dataType' => 'json', 'data' => 'js:"producer_id="+$(this).val()', 'success' => 'function(data){ jQuery(\'#' . get_class($model) . '_tyre_id\').html("").addOption(data, false); }')));
?>
			</div>
			<div>Шина<br />
			<?php 
echo $form->dropDownList($model, 'tyre_id', $model->isNewRecord ? array() : CHtml::listData(Tyre::model()->findAll('producer_id=' . $model->tyre->producer_id), 'id', 'title'));
?>
			</div>
			<?php 
if ($model->isNewRecord) {
    Yii::app()->clientScript->registerScript(get_class($model) . '#tyreProducersList', '$("#' . get_class($model) . '_tyre_id").ajaxAddOption("' . CHtml::normalizeUrl(array('tyres/sizes/ajaxTyres')) . '", {producer_id: $("#tyreProducersList").val()});');
}
?>
		</div>
		<?php 
echo $form->error($model, 'tyre_id');
?>
	</div>

	<div class="row">
		<?php 
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     if (Yii::app()->request->isAjaxRequest) {
         if ($model = Yii::app()->request->getParam('TyreSizes', false)) {
             // Обработка условий фильтра выбора производителя
             $this->producer = $model['producer'];
             // Собираю шины производителей подходящих под условия фильтра
             $tyres = CHtml::listData(Tyre::model()->findAll('producer_id=:producer_id', array(':producer_id' => $model['producer'])), 'id', 'id');
             // Подкидываю к фильтру новое условие
             $criteria->compare('tyre_id', $tyres);
         }
     }
     $criteria->compare('id', $this->id);
     $criteria->compare('tyre_id', $this->tyre_id, true);
     $criteria->compare('code', $this->code, true);
     $criteria->compare('alias', $this->alias, true);
     $criteria->compare('width', $this->width, true);
     $criteria->compare('height', $this->height, true);
     $criteria->compare('diameter', $this->diameter, true);
     $criteria->compare('load_index', $this->load_index, true);
     $criteria->compare('speed_rating', $this->speed_rating, true);
     $criteria->compare('price', $this->price, true);
     $criteria->compare('rest', $this->rest, true);
     return new CActiveDataProvider(get_class($this), array('criteria' => $criteria));
 }