public function actionList($company_id = 0)
 {
     if ($company_id == 0) {
         $company_id = Yii::app()->getUser()->getProfile()->company_id;
     }
     Yii::import('reis.models.*');
     $criteria = new CDbCriteria();
     $criteria->with = ['user' => ['joinType' => 'INNER JOIN', 'condition' => 'user.company_id = :company_id']];
     $criteria->addCondition('deleted_status != :deleted_status');
     $criteria->params = [':company_id' => $company_id, ':deleted_status' => Reis::DEL_SATUS_DELETED];
     $criteria->order = 'reis_id DESC';
     $this->render('list', ['reis' => Reis::model()->findAll($criteria), 'company_id' => $company_id]);
 }
예제 #2
0
 public function actionDeactivate()
 {
     Yii::app()->setImport(['application.modules.cargo.models.*']);
     $condition = new CDbCriteria();
     $condition->addCondition('TO_DAYS(NOW()) - TO_DAYS(`deleted_status_date`) > 15');
     Product::model()->updateAll(['deleted_status' => Product::DEL_SATUS_ARCHIVE], $condition);
     Cargo::model()->updateAll(['deleted_status' => Cargo::DEL_SATUS_ARCHIVE], $condition);
     Reis::model()->updateAll(['deleted_status' => Reis::DEL_SATUS_ARCHIVE], $condition);
     Sklad::model()->updateAll(['deleted_status' => Sklad::DEL_SATUS_ARCHIVE], $condition);
     Custom::model()->updateAll(['deleted_status' => Custom::DEL_SATUS_ARCHIVE], $condition);
     Insurance::model()->updateAll(['deleted_status' => Insurance::DEL_SATUS_ARCHIVE], $condition);
     SpecialTechnique::model()->updateAll(['deleted_status' => SpecialTechnique::DEL_SATUS_ARCHIVE], $condition);
 }
 /**
  * Запуск виджета
  */
 public function run()
 {
     switch ($this->type) {
         case 'store_add':
             $product = Product::model()->find('t.slug = "' . $this->record_id . '"');
             $criteria = new CDbCriteria();
             $product->category_id = isset($product->category_id) ? $product->category_id : 1;
             $criteria->condition = 't.category_id = ' . $product->category_id . ' AND t.status ="active"';
             $criteria->limit = 5;
             $storecalls = StoreCall::model()->findAll($criteria);
             $this->render('store_add', ['storecalls' => $storecalls]);
             break;
         case 'store_call_add':
             $storecall = StoreCall::model()->findByPk($this->record_id);
             $criteria = new CDbCriteria();
             $storecall->category_id = isset($storecall->category_id) ? $storecall->category_id : 1;
             $criteria->condition = 't.category_id =' . $storecall->category_id . ' AND t.status ="1"';
             $criteria->limit = 5;
             $products = Product::model()->findAll($criteria);
             $this->render('store_call_add', ['products' => $products]);
             break;
         case 'cargo_add':
             $cargo = Cargo::model()->with('address_from', 'address_to')->findByPk($this->record_id);
             $reissearchform = new ReisSearchForm();
             $reissearchform->from_name = $cargo->address_from[0]->name;
             $reissearchform->from_address_lat = $cargo->address_from[0]->lat;
             $reissearchform->from_address_long = $cargo->address_from[0]->long;
             $reissearchform->from_radius = $this->radius;
             $reissearchform->to_name = $cargo->address_to[0]->name;
             $reissearchform->to_address_lat = $cargo->address_to[0]->lat;
             $reissearchform->to_address_long = $cargo->address_to[0]->long;
             $reissearchform->to_radius = $this->radius;
             $reisIds = $reissearchform->relatedReis();
             if (!empty($reisIds)) {
                 $reis = Reis::model()->findAllByAttributes(array('reis_id' => $reisIds), array('order' => 'reis_id desc', 'limit' => 5));
             } else {
                 $reis = array();
             }
             $this->render('cargo_add', ['reis' => $reis]);
             break;
         case 'transport_add':
             $transport = Reis::model()->findByPk($this->record_id);
             $transport->address_from;
             $transport->address_to;
             $cargosearchform = new CargoSearchForm();
             $cargosearchform->from_name = $transport->address_from[0]->name;
             $cargosearchform->from_address_lat = $transport->address_from[0]->lat;
             $cargosearchform->from_address_long = $transport->address_from[0]->long;
             $cargosearchform->from_radius = $this->radius;
             if (!empty($transport->address_to)) {
                 $cargosearchform->to_name = $transport->address_to[0]->name;
                 $cargosearchform->to_address_lat = $transport->address_to[0]->lat;
                 $cargosearchform->to_address_long = $transport->address_to[0]->long;
                 $cargosearchform->to_radius = $this->radius;
             }
             $cargoIds = $cargosearchform->relatedCargo();
             if (!empty($cargoIds)) {
                 $cargo = Cargo::model()->findAllByAttributes(array('cargo_id' => $cargoIds), array('order' => 'cargo_id desc', 'limit' => 5));
             } else {
                 $cargo = array();
             }
             $this->render('transport_add', ['cargo' => $cargo]);
             break;
         case 'sklad_call_add':
             $skladcall = SkladCall::model()->with('address')->findByPk($this->record_id);
             if ($skladcall->address->name && $skladcall->address->lat && $skladcall->address->long) {
                 $skladsearchform = new SkladSearchForm();
                 $skladsearchform->from_name = $skladcall->address->name;
                 $skladsearchform->from_address_lat = $skladcall->address->lat;
                 $skladsearchform->from_address_long = $skladcall->address->long;
                 $skladsearchform->from_radius = $this->radius;
                 $criteria = $skladsearchform->getCriteria();
                 $criteria->limit = 5;
                 $sklads = Sklad::model()->findAll($criteria);
             } else {
                 $sklads = array();
             }
             $this->render('sklad_call', ['sklads' => $sklads]);
             break;
         case 'sklad_add':
             $sklad = Sklad::model()->with('address')->findByPk($this->record_id);
             if ($sklad->address->name && $sklad->address->lat && $sklad->address->long) {
                 $skladcallsearchform = new SkladCallSearchForm();
                 $skladcallsearchform->from_name = $sklad->address->name;
                 $skladcallsearchform->from_address_lat = $sklad->address->lat;
                 $skladcallsearchform->from_address_long = $sklad->address->long;
                 $skladcallsearchform->from_radius = $this->radius;
                 $criteria = $skladcallsearchform->getCriteria();
                 $criteria->limit = 5;
                 $skladcalls = SkladCall::model()->findAll($criteria);
             } else {
                 $skladcalls = array();
             }
             $this->render('sklad_add', ['skladcalls' => $skladcalls]);
             break;
         case 'specialtechnique_call_add':
             $specialTechniqueCall = SpecialTechnique::model()->with('address')->findByPk($this->record_id);
             if ($specialTechniqueCall->address->name && $specialTechniqueCall->address->lat && $specialTechniqueCall->address->long) {
                 $specialtechniqueform = new SpecialTechniqueForm();
                 $specialtechniqueform->from_name = $specialTechniqueCall->address->name;
                 $specialtechniqueform->from_address_lat = $specialTechniqueCall->address->lat;
                 $specialtechniqueform->from_address_long = $specialTechniqueCall->address->long;
                 $specialtechniqueform->from_radius = $this->radius;
                 $specialtechniqueform->type_request = 'offer';
                 $specialtechniqueform->category_id = $specialTechniqueCall->category_id;
                 $criteria = $specialtechniqueform->getCriteria();
                 $criteria->limit = 5;
                 $specialtechnique = SpecialTechnique::model()->findAll($criteria);
             } else {
                 $specialtechnique = array();
             }
             $this->render('specialtechnique_call_add', ['specialtechnique' => $specialtechnique]);
             break;
         case 'specialtechnique_add':
             $specialTechnique = SpecialTechnique::model()->with('address')->findByPk($this->record_id);
             if ($specialTechnique->address->name && $specialTechnique->address->lat && $specialTechnique->address->long) {
                 $specialtechniqueform = new SpecialTechniqueForm();
                 $specialtechniqueform->from_name = $specialTechnique->address->name;
                 $specialtechniqueform->from_address_lat = $specialTechnique->address->lat;
                 $specialtechniqueform->from_address_long = $specialTechnique->address->long;
                 $specialtechniqueform->from_radius = $this->radius;
                 $specialtechniqueform->type_request = 'request';
                 $specialtechniqueform->category_id = $specialTechnique->category_id;
                 $criteria = $specialtechniqueform->getCriteria();
                 $criteria->limit = 5;
                 $specialtechniquecall = SpecialTechnique::model()->findAll($criteria);
             } else {
                 $specialtechniquecall = array();
             }
             $this->render('specialtechnique_add', ['specialtechniquecall' => $specialtechniquecall]);
             break;
         default:
             break;
     }
 }
예제 #4
0
 public function actionActivate($id)
 {
     $model = Reis::model()->findByPk($id);
     if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $model->user->company_id) && (Yii::app()->getUser()->getProfile()->modules->transport != '1' || $model->user_id != Yii::app()->user->id)) {
         throw new CHttpException(403);
     }
     if ($model === null) {
         throw new CHttpException(404, 'Указанная запись не найдена');
     }
     $model->deleted_status = Reis::DEL_SATUS_ACTIVE;
     $model->deleted_status_date = date('Y-m-d H:i:s');
     $model->update();
     Yii::app()->user->setFlash('success', Yii::t('CabinetModule.default', 'Предложение успешно активированно.'));
     $this->redirect('/cabinet/transport');
 }
 /**
  * Удаляем из раздела Reis model - modules/reis/model/Reis, controller modules/reis/controllers/DefaultController
  *
  * @param User $user
  */
 private function deleteReis(\User $user)
 {
     $data = 'user_id = :user_id';
     $param = array(':user_id' => $user->id);
     $count = Reis::model()->count($data, $param);
     $reiss = Reis::model()->findAll($data, $param);
     foreach ($reiss as $reis) {
         /*    $adreses =  Yii::app()->db->createCommand('select address_id from site_reis_address WHERE reis_id = '.$reis->reis_id)->queryAll();
               foreach ($adreses as $adres) {
                   $this->deleteAddress($adres['address_id']);
               }*/
         $this->deleteRelationsAll($reis->reis_id, 'reis_id', 'site_reis_address', 'address_id', 'site_address');
         //$this->deleteRelation($reis->reis_id,'reis_id','site_reis_address');
         $this->deleteRelationsAll($reis->reis_id, 'reis_id', 'site_reis_cost', 'cost_id', 'site_cost');
     }
     if ($this->debug) {
         echo "    ... Reis  del " . $count . " \n";
     } else {
         Reis::model()->deleteAll($data, $param);
     }
 }
예제 #6
0
 public function actionDelete($id)
 {
     $user = User::model()->find(array('condition' => 'id = :id', 'params' => array(':id' => $id)));
     if (isset($user)) {
         if (!Yii::app()->user->checkAccess('admin') && (Yii::app()->getUser()->getProfile()->modules->head != UserModules::DIRECTOR_COMPANY || Yii::app()->user->getProfile()->company_id != $user->company_id || Yii::app()->user->id == $id)) {
             throw new CHttpException(403);
         }
         $users = User::getUserList($id);
         $model = new ModuleAccess();
         if (isset($_POST['ModuleAccess'])) {
             $userId = $_POST['ModuleAccess']['user'];
             Transport::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Product::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Cargo::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Reis::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Sklad::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Custom::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             Insurance::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             SpecialTechnique::model()->updateAll(array('user_id' => $userId), 'user_id=' . $id);
             if ($user->delete()) {
                 $this->redirect('/cabinet/staff/list');
             }
         }
         $this->render('delete', array('model' => $model, 'user' => $user, 'users' => $users));
     }
 }