/** * Lists all SalesActivity models. * @return mixed */ public function actionIndex() { $resGroupsModel = \app\models\ResGroups::find()->where('name like :name')->addParams([':name' => 'All Sales User'])->one(); $salesData = new ArrayDataProvider(['allModels' => $resGroupsModel->users, 'sort' => ['attributes' => ['name'], 'defaultOrder' => ['name' => SORT_ASC]]]); $searchModel = new SalesActivitySearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider, 'salesData' => $salesData]); }
public function actionUserlist($search = null, $id = null) { $out = ['more' => false]; if (!is_null($search)) { $query = new Query(); $query->select('id, login AS text')->from('res_users')->where(['like', 'login', $search])->limit(20); $command = $query->createCommand(); $data = $command->queryAll(); $out['results'] = array_values($data); } elseif ($id > 0) { $out['results'] = ['id' => $id, 'text' => ResGroups::find($id)->login]; } else { $out['results'] = ['id' => 0, 'text' => 'No matching records found']; } echo Json::encode($out); }
use yii\helpers\Html; use yii\helpers\Url; use kartik\widgets\ActiveForm; use kartik\widgets\DatePicker; use kartik\widgets\Select2; use yii\web\JsExpression; /* @var $this yii\web\View */ /* @var $model app\models\SalesActivitySearch */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="sales-activity-search"> <?php $form = ActiveForm::begin(['action' => [''], 'method' => 'get']); $saleGroup = \app\models\ResGroups::find()->select('id')->with(['users', 'users.partner' => function ($query) { $query->orderBy('name ASC'); }])->where(['name' => 'All Sales User'])->asArray()->one(); $saleUsers = \yii\helpers\ArrayHelper::map($saleGroup['users'], 'id', 'partner.name'); // var_dump($saleGroup); ?> <div class="form-group"> <label class="controll-label" for="sales">Sales</label> <?php echo Select2::widget(['model' => $model, 'attribute' => 'sales', 'data' => $saleUsers, 'value' => Yii::$app->request->get('sales'), 'options' => ['placeholder' => 'Select Sales ...'], 'pluginOptions' => ['allowClear' => true]]); ?> </div> <div class="form-group"> <label class="controll-label" for="customer">Customer</label> <?php
/** * Get User who in Management User Group * @return Has Many Rel ResUsers of ResGroups */ private function getTrackOrderManagementUsers() { return \yii\helpers\ArrayHelper::map(ResGroups::find()->where(['name' => 'Management'])->one()->users, 'id', 'login'); }