/**
* 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">
