public function actionStudbatch($id) { $rows = \app\modules\course\models\Batches::find()->where(['batch_course_id' => $id, 'is_status' => 0])->all(); echo "<option value=''>---Select Batch---</option>"; if (count($rows) > 0) { foreach ($rows as $row) { echo "<option value='{$row->batch_id}'>{$row->batch_name}</option>"; } } else { echo ""; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Batches::find()->where(['<>', 'is_status', 2]); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['batch_id' => SORT_DESC]]]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['batch_id' => $this->batch_id, 'batch_course_id' => $this->batch_course_id, 'start_date' => $this->dbDateSearch($this->start_date), 'end_date' => $this->dbDateSearch($this->end_date), 'created_at' => $this->created_at, 'created_by' => $this->created_by, 'updated_at' => $this->updated_at, 'updated_by' => $this->updated_by, 'is_status' => $this->is_status]); $query->andFilterWhere(['like', 'batch_name', $this->batch_name])->andFilterWhere(['like', 'batch_alias', $this->batch_alias]); unset($_SESSION['exportData']); $_SESSION['exportData'] = $dataProvider; return $dataProvider; }
/** * @return all batches */ public static function getStuBatches() { $dataTmp = Batches::find()->where(['is_status' => 0])->orderBy('batch_name')->all(); $result = yii\helpers\ArrayHelper::map($dataTmp, 'batch_id', 'batch_name'); return $result; }
?> </span> </div><!-- /.info-box-content --> </div><!-- /.info-box --> </div> <div class="col-md-4 col-sm-6 col-xs-12"> <div class="edusec-link-box"> <span class="edusec-link-box-icon bg-teal"><i class="fa fa-users"></i></span> <div class="edusec-link-box-content"> <span class="edusec-link-box-text"><?php echo Html::a(Yii::t('course', 'Manage Batches'), ['/course/batches']); ?> </span> <span class="edusec-link-box-number"><?php echo app\modules\course\models\Batches::find()->where(['is_status' => 0])->count(); ?> </span> <span class="edusec-link-box-desc"></span> <span class="edusec-link-box-bottom"><?php echo Html::a('<i class="fa fa-plus-square"></i> ' . Yii::t('course', 'Create New'), ['/course/batches/create']); ?> </span> </div><!-- /.info-box-content --> </div><!-- /.info-box --> </div> <div class="col-md-4 col-sm-6 col-xs-12"> <div class="edusec-link-box"> <span class="edusec-link-box-icon bg-green"><i class="fa fa-sitemap"></i></span> <div class="edusec-link-box-content">
/** * Deletes an existing Courses model. * If deletion is successful, the browser will be redirected to the 'index' page. * @param integer $id * @return mixed */ public function actionDelete($id) { $batch = Batches::find()->where('batch_course_id=' . $id . ' AND is_status!=2')->exists(); if ($batch) { $err_msg = 'Batch'; } else { $err_msg = ''; } if (!empty($err_msg)) { throw new HttpException(400, 'You can not delete this record because it is used in ' . $err_msg . ' table.'); } else { $model = Courses::findOne($id); $model->is_status = 2; $model->update(); } return $this->redirect(['index']); }