/** * Creates a new Ruta model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Ruta(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id]); } else { $connection = \Yii::$app->db; $sql = 'SELECT * FROM user WHERE id in (Select user_id FROM auth_assignment WHERE item_name = "relevador")'; $modelo = \common\models\User::findBySql($sql)->all(); $dataUsuarios = ArrayHelper::map($modelo, 'id', 'username'); $rutarel = new RutaRelevador(); return $this->render('create', ['model' => $model, 'users' => $dataUsuarios, 'rutarel' => $rutarel]); } }
public function actionView($id) { $sql = "SELECT u.id, u.username, u.email, u.status, u.full_name, u.business_name, u.phone_number, u.business_address, u.status, s.store_name as store_name FROM `user` u join user_store us on us.user_id = u.id join store s on s.store_id = us.store_id"; return $this->render('view', ['model' => User::findBySql($sql)->one()]); }
/* @var $this yii\web\View */ /* @var $model backend\modules\user\models\ActivityHistorySearch */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="activity-history-search"> <?php $form = ActiveForm::begin(['action' => ['log'], 'method' => 'get']); ?> <?php if (Yii::$app->user->usermode != 'developer') { $dataSql = User::findBySql('SELECT DISTINCT username FROM user WHERE usermode !="developer"')->asArray()->all(); } else { $dataSql = User::findBySql('SELECT DISTINCT username FROM user')->asArray()->all(); } foreach ($dataSql as $row) { $CT_IDS[] = $row['username']; } ?> <?php echo $form->field($model, 'username')->widget(TypeaheadBasic::classname(), ['data' => $CT_IDS, 'pluginOptions' => ['highlight' => true], 'options' => ['placeholder' => 'All']]); ?> <?php echo $form->field($model, 'start_date', ['addon' => ['prepend' => ['content' => '<i class="glyphicon glyphicon-calendar"></i>']], 'options' => ['class' => 'drp-container form-group', 'readonly' => 'readonly']])->widget(DateRangePicker::classname(), ['useWithAddon' => true, 'convertFormat' => true, 'pluginOptions' => ['locale' => ['format' => 'Y-m-d']]]); ?> <div class="form-group">