private function loadModel($id) { $model=Custom::model()->findByPk($id); if($model===null) throw new CHttpException(404,'The requested page does not exist.'); return $model; }
public function actionList($company_id = 0) { if ($company_id == 0) { $company_id = Yii::app()->getUser()->getProfile()->company_id; } Yii::import('customs.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' => Custom::DEL_SATUS_DELETED]; $criteria->order = 'custom_id DESC'; $this->render('list', ['customs' => Custom::model()->findAll($criteria), 'company_id' => $company_id]); }
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 actionActivate($id) { $model = Custom::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->customs != '1' || $model->user_id != Yii::app()->user->id)) { throw new CHttpException(403); } if ($model === null) { throw new CHttpException(404, 'Указанная запись не найдена'); } $model->deleted_status = Custom::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/customs'); }
private function deleteCustom(\User $user) { $data = 'user_id = :user_id'; $param = array(':user_id' => $user->id); if ($this->debug) { echo " ... Custom: del " . Custom::model()->count($data, $param) . " \n"; } else { Custom::model()->deleteAll($data, $param); } // @TODO есть ещё таблица связи - надо разобраться с ней... }
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)); } }