I have two Datetimepickera and a widget dependent dropdown kartik \ depdrop \ DepDrop; I need to get a request from the selected date and the first dropdown to the second dropdown. Therefore, I need to get the value from 2 datepickerov and send them to the controller, how to do it?
SELECT operators.id FROM user operators INNER JOIN categoryuser ON operators.category_user = categoryuser.id_catuser WHERE operators.id NOT IN (SELECT event.id_operator FROM event WHERE event.date_start < :end_date AND event.date_end > :start_date) public function actionSubcat() { \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON; if (isset(Yii::$app->request->post()['depdrop_parents'])) { $parents = Yii::$app->request->post('depdrop_parents'); if ($parents != null) { $cat_id = $parents[0]; return [ 'output' => \app\modules\admin\models\User::getSubCatList($cat_id, true), 'selected' => '', ]; } } return ['output' => '', 'selected' => '']; } public static function getSubCatList2($categoryID, $end_date,$start_date,$dependent = false) { $date_1='14-02-2019 10:55:00'; $date_2='14-02-2019 13:55:00'; $sub = Viewevent::find()->select('id_operator') ->andWhere(['<','date_start', $date_2]) ->andWhere(['>','date_end',$date_1]); $subCategory = Viewevent::find() ->Where(['op_depart_id' => $categoryID]) // ->andWhere(['category_user'=>2]) ->andWhere(['not in','id_operator',$sub]); if (Yii::$app->request->isAjax == true) { return $subCategory->select(['id_operator AS id', 'OperatorFio AS name'])->asArray()->all(); } else { return $subCategory->select(['OperatorFio AS name'])->indexBy('id_operator')->column(); } } <?= $form->field($model, 'id_operator')->widget(DepDrop::classname(), [ 'data' => User::getSubCatList($model->id_operator), 'options' => ['id' => 'id_operator'], 'pluginOptions' => [ 'depends' => ['cat-id'], 'placeholder' => 'Выберите оператора...', 'url'=Url::to(['/event/subcat2/','date_start'=>$date_1,'date_end'=>$date_2])] ])->label('Выберите оператора'); ?> 