public function actionBrancheslist($id) { $branches = Branches::find()->where(['companies_company_id' => $id])->all(); echo "<option>Please Select Branch </option>"; foreach ($branches as $branches) { echo "<option value=" . $branches->branch_id . ">{$branches->branch_name}</option>"; } }
public function actionLists($id) { $countBranches = Branches::find()->where(['companies_company_id' => $id])->count(); $branches = Branches::find()->where(['companies_company_id' => $id])->all(); if ($countBranches > 0) { foreach ($branches as $branch) { echo "<option value='" . $branch->branch_id . "'>" . $branch->branch_name . "</option>"; } } else { echo "<option>-</option>"; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Branches::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->joinWith('companiesCompany'); $query->andFilterWhere(['branch_id' => $this->branch_id, 'branch_created_date' => $this->branch_created_date]); $query->andFilterWhere(['like', 'branch_name', $this->branch_name])->andFilterWhere(['like', 'branch_address', $this->branch_address])->andFilterWhere(['like', 'branch_status', $this->branch_status])->andFilterWhere(['like', 'companies.company_name', $this->companies_company_id]); return $dataProvider; }
public function actionLists($id) { $count = Branches::find()->where(['companies_company_id' => $id])->count(); if ($count > 0) { $branches = Branches::find()->where(['companies_company_id' => $id])->all(); $xhtml = "<option selected='selected'> - Select Branch - </option>"; foreach ($branches as $branch) { $xhtml .= "<option value='" . $branch->branch_id . "'>" . $branch->branch_name . "</option>"; } echo $xhtml; } else { echo "<option> - </option>"; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Branches::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['branch_id' => $this->branch_id, 'companies_company_id' => $this->companies_company_id, 'branch_created_date' => $this->branch_created_date]); $query->andFilterWhere(['like', 'branch_name', $this->branch_name])->andFilterWhere(['like', 'branch_address', $this->branch_address])->andFilterWhere(['like', 'branch_status', $this->branch_status]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Branches::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id]); $query->andFilterWhere(['like', 'branch_title', $this->branch_title])->andFilterWhere(['like', 'lannet', $this->lannet])->andFilterWhere(['like', 'city_address', $this->city_address]); return $dataProvider; }
<div class="departaments-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'companies_company_id')->dropDownList(ArrayHelper::map(Companies::find()->all(), 'company_id', 'company_name'), ['prompt' => 'Select Company', 'onchange' => ' $.post("index.php?r=branches/lists&id=' . '"+$(this).val(), function(data){ $("select#models-branch").html(data); });']); ?> <?php echo $form->field($model, 'branches_branch_id')->dropDownList(ArrayHelper::map(Branches::find()->all(), 'branch_id', 'branch_name'), ['prompt' => 'Select Branch', 'id' => 'models-branch']); ?> <?php echo $form->field($model, 'departament_name')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'departament_status')->dropDownList(['active' => 'Active', 'inactive' => 'Inactive'], ['prompt' => '']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div>
public function getDropDownBranch() { return ArrayHelper::map(Branches::find()->all(), 'branch_id', 'branch_name'); }
public static function arrayBranches() { return Branches::find()->select('branch_title as value, branch_title as label, id as id')->asArray()->all(); }
<div class="departments-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'companies_company_id')->dropDownList(ArrayHelper::map(\backend\models\Companies::find()->all(), 'company_id', 'company_name'), ['prompt' => 'Select Company', 'onchange' => ' $.post("index.php?r=branches/list&id="+$(this).val(), function(data){ $("select#departments-branches_branch_id").html(data); }) ']); ?> <?php echo $form->field($model, 'branches_branch_id')->dropDownList(ArrayHelper::map(\backend\models\Branches::find()->all(), 'branch_id', 'branch_name'), ['prompt' => 'Select Company']); ?> <?php echo $form->field($model, 'department_name')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'department_created_date')->textInput(); ?> <?php echo $form->field($model, 'department_status')->dropDownList(['active' => 'Active', 'inactive' => 'Inactive'], ['prompt' => '']); ?> <div class="form-group">
?> --> <?php echo $form->field($model, 'companies_company_id')->dropDownList(ArrayHelper::map(Companies::find()->all(), 'company_id', 'company_name'), ['prompt' => 'Please choose company', 'onchange' => ' $.post("index.php?r=branches/lists&id=' . '"+$(this).val(),function(data){ $("select#departments-branches_branch_id").html(data); });']); ?> <!-- <?php echo $form->field($model, 'branches_branch_id')->textInput(); ?> --> <?php echo $form->field($model, 'branches_branch_id')->dropDownList(ArrayHelper::map(Branches::find()->all(), 'branch_id', 'branch_name'), ['prompt' => 'Please choose branch']); ?> <?php echo $form->field($model, 'department_name')->textInput(['maxlength' => true]); ?> <!--<?php echo $form->field($model, 'department_create_data')->textInput(); ?> -->
?> <div class="departments-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'companies_company_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(Companies::find()->all(), 'company_id', 'company_name'), 'options' => ['placeholder' => 'Select a state ...', 'onchange' => '$.post("index.php?r=departments/brancheslist&id=' . '"+$(this).val(),function(data){ $("#departments-branches_branch_id").html(data); });'], 'pluginOptions' => ['allowClear' => true]]); ?> <?php echo $form->field($model, 'branches_branch_id')->widget(Select2::classname(), ['data' => ArrayHelper::map(Branches::find()->all(), 'branch_id', 'branch_name'), 'options' => ['placeholder' => 'Select a Branch ...'], 'pluginOptions' => ['allowClear' => true]]); ?> <?php // echo $form->field($model, 'companies_company_id')->dropDownList( // // ArrayHelper::map(Companies::find()->all(),'company_id','company_name'), // [ // 'prompt' => 'Select Company', // 'onchange'=>'$.post("index.php?r=departments/brancheslist&id='.'"+$(this).val(),function(data){ // $("#departments-branches_branch_id").html(data); // });', // // // ]);
public function actionList($company_id) { $countBranches = Branches::find()->where(['companies_company_id' => $company_id])->count(); $branches = Branches::find()->where(['companies_company_id' => $company_id])->all(); if ($countBranches > 0) { foreach ($branches as $branch) { echo '<option value="' . $branch->branch_id . '">' . $branch->branch_name . '</option>'; } } else { echo '<option>Select Branch</option>'; } }
?> <div class="departments-form"> <?php $form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'companies_company_id')->dropDownList(ArrayHelper::map(Companies::find()->all(), 'company_id', 'company_name'), ['prompt' => 'Выберите компанию', 'onchange' => '$.post("index.php?r=branches/lists&id=" + $(this).val(), function( data ){ $("select#departments-branches_branch_id").html( data ); });']); ?> <?php echo $form->field($model, 'branches_branch_id')->dropDownList(ArrayHelper::map(Branches::find()->all(), 'branch_id', 'branch_name'), ['prompt' => 'Выберите бранч']); ?> <?php echo $form->field($model, 'department_name')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'department_status')->dropDownList(['active' => 'Active', 'inactive' => 'Inactive'], ['prompt' => '']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div>
</div> <div class = "col-xs-12 col-md-7 col-md-pull-5"> <p> <b>Корпоративные сим-карты</b> <ul style="margin-left: 2px; padding-left: 2px;"> <li>Ежедневно проверяйте состояние счета командой: <b>*105*98#</b></li> <li>В случае утери сим-карты, сообщите в отдел информатизации.</li> <li>Не допускайте попадания корпоративной сим-карты в распоряжение третьих лиц!</li> <li>Не пополняйте счет самостоятельно!</li> <li>Не используйте передачу данных, если у вас не подключены опции безлимитного интернет.</li> <li>Не используйте передачу данных за пределами домашнего региона, если у вас не подключена опция Интернет по России. </li> </ul> </p> </div> </div> <?php echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'pager' => ['prevPageLabel' => 'Назад', 'nextPageLabel' => 'Далее', 'maxButtonCount' => 20], 'columns' => [['class' => 'yii\\grid\\SerialColumn'], ['attribute' => 'branch_title', 'value' => 'branch_title', 'filter' => ArrayHelper::map(Branches::find()->orderBy('id')->all(), 'branch_title', 'branch_title')], ['attribute' => 'snp', 'value' => function ($model) { //var_dump($model); return Html::a($model->snp, ['employees/view', 'id' => $model->emp_id, 'mode' => 'start']); }, 'format' => 'raw'], 'cell_number', 'voip_number', 'email_address', 'room_title', ['attribute' => 'workplaces_title', 'value' => function ($arr) { return Html::a($arr['wp_id'], ['workplaces/view', 'id' => $arr['wp_id']]); }, 'format' => 'raw'], 'job_title']]); ?>
<?php echo $form->field($model, 'patronymic')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'job_title')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'employee_number')->textInput(); ?> <?php echo $form->field($model, 'unique_1c_number')->textInput(); ?> <?php echo $form->field($model, 'branch_id')->dropDownList(ArrayHelper::map(Branches::find()->all(), 'id', 'branch_title'), ['prompt' => 'Выберите подразделение...']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Создать' : 'Редактировать', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?> </div>
use yii\jui\AutoComplete; /* @var $this yii\web\View */ /* @var $model backend\models\Devices */ /* @var $form yii\widgets\ActiveForm */ ?> <div class="devices-form"> <?php $form = ActiveForm::begin(); ?> <?php if ($mode !== 'update' && $id_wp == 0) { ?> <?php echo $form->field($model, 'branch_id')->dropDownList(ArrayHelper::map(Branches::find()->all(), 'id', 'branch_title'), ['prompt' => 'Выберите подраздление...', 'onchange' => '$.post("/admin/rooms/list?id=' . '"+$(this).val(), function(data) { var devRoom = $("select#devices-room_id"); devRoom.html(data); var devWork = $("select#devices-workplace_id"); devWork.html(\'<option value="0"> - </option>\'); });']); ?> <?php echo $form->field($model, 'room_id')->dropDownList(ArrayHelper::map(Rooms::find()->orderBy('room_title')->all(), 'id', 'room_title'), ['prompt' => 'Выберите отдел/кабинет...', 'onchange' => '$.post("/admin/workplaces/list?id=' . '"+$(this).val(), function(data) { $("select#devices-workplace_id").html(data); });']); ?> <?php } if ($id_wp > 0) { $model->workplace_id = $id_wp;