/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Advisor::find();
if (!isset($params['sort'])) {
$query->orderBy(['id_advisor' => SORT_DESC]);
}
$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_advisor' => $this->id_advisor, 'id_user' => $this->id_user, 'id_institution' => $this->id_institution, 'trained' => $this->trained, 'approved' => $this->approved, 'train_date' => $this->train_date, 'delete' => $this->delete, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'advisor_id', $this->advisor_id])->andFilterWhere(['like', 'phone', $this->phone]);
return $dataProvider;
}
/**
* Lists all Application models.
* @return mixed
*/
public function actionIndex()
{
$searchModel = new ApplicationSearch();
if ($this->user->id_user_role == Dict::USER_ROLE_ADVISOR) {
$advisor = Advisor::find()->andWhere(['id_user' => $this->user->id])->one();
//find related groups
$id_groups = AdvisorGroup::find()->andWhere(['id_advisor' => $advisor['id_advisor']])->all();
$ids = [];
foreach ($id_groups as $value) {
$ids[] = $value['id_group'];
}
$query = Application::find()->andWhere(['in', 'id_group', $ids]);
//->orderBy(['id_application' => SORT_DESC]);
$dataProvider = $searchModel->search(Yii::$app->request->get(), $query);
} else {
if ($this->user->id_user_role == Dict::USER_ROLE_BETTERDEBT) {
$query = Application::find();
$dataProvider = $searchModel->search(Yii::$app->request->get(), $query);
}
}
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
}
public static function getDate($id)
{
$model = new Advisor();
$group_arr = '';
if (!empty($_GET['id'])) {
$advisorid = is_numeric($_GET['id']) ? $_GET['id'] : '';
$advisorarr = $model->find()->where(['id_advisor' => $advisorid])->asArray()->one();
}
$train_date = empty($advisorarr['train_date']) ? date('Y-m-d') : date('Y-m-d', $advisorarr['train_date']);
return $train_date;
}
public function actionGetAdvisor($id)
{
$arrays = Advisor::find()->andWhere(['id_institution' => $id])->all();
$option = '';
if (!empty($arrays)) {
$result = ArrayHelper::map($arrays, 'id_advisor', 'advisor_id');
foreach ($result as $key => $value) {
$option .= "<option value='{$key}'>{$value}</option>";
}
}
echo $option;
exit;
}
}
}
SCRIPT;
$form = ActiveForm::begin(['enableClientScript' => false]);
?>
<section class="content-wrap">
<div class="container">
<div class="row pt50">
<main class="col-md-9 main-content">
<div class="new-application frame">
<h3 class="border-bottom h3">NEW APPLICATION</h3>
<div class="application-box">
<div class="clearfix">
<div class="form-group padding-left-Zero col-xs-6 mb0">
<?php
echo $form->field($model, 'id_group', ['options' => ['class' => 'form-group']])->label('Please select Master Account (group)')->dropDownList(ArrayHelper::map(Advisor::find()->where(['id_user' => Yii::$app->user->getIdentity()->id])->one()->groups, 'id_group', function ($model, $defaultValue) {
return $model->group_id;
}));
?>
</div>
<div class="col-xs-6 padding-right0">
<?php
echo $form->field($model, 'is_joint_application')->label('Select Application Type')->radioList(DictApplication::$applicationJoint, ['item' => function ($index, $label, $name, $checked, $value) {
$radio = Html::radio($name, $checked, ['value' => $value, 'id' => $name . $index]);
$label = Html::label($radio . $label);
return Html::tag('div', $label, ['class' => 'radio col-xs-6']);
}]);
?>
</div>
</div>
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'group_id')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'name')->textInput(['maxlength' => true]);
?>
<?php
echo $form->field($model, 'id_custodian')->dropDownList(ArrayHelper::map(Custodian::find()->all(), 'id_custodian', 'name'), ['id' => 'id_custodian', 'prompt' => 'Select...']);
?>
<div class="form-group field-advisorgroup-id_advisor required">
<label class="col-sm-3 control-label form-label" for="id_advisor">Id Advisor</label>
<div class="col-sm-8">
<?php
echo Select2::widget(['name' => 'id_advisor', 'value' => ArrayHelper::map($model->advisors, 'id_advisor', 'id_advisor'), 'data' => ArrayHelper::map(Advisor::find()->all(), 'id_advisor', function ($item) {
return $item->user->first_name;
}), 'options' => ['placeholder' => 'Select ...', 'multiple' => true], 'pluginOptions' => ['maximumInputLength' => 10, 'ajax' => ['url' => Url::to(['get-all-advisor-list']), 'dataType' => 'json', 'data' => new JsExpression('function(params) { return {q:params.term}; }')]]]);
?>
</div>
</div>
<div class="form-group">
<div class="col-sm-2"></div>
<div class="col-sm-10">
<?php
echo Html::button(Yii::t('app', 'Add Advisor'), ['class' => 'fa fa-plus btn btn-success "', 'data-toggle' => 'modal', 'data-target' => '#myModal']);
?>
<?php
echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']);
?>
</div>
