/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Employee::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([ 'employee_id' => $this->employee_id, 'user_id' => $this->user_id, ]); $query->andFilterWhere(['like', 'emp_firstname', $this->emp_firstname]) ->andFilterWhere(['like', 'emp_lastname', $this->emp_lastname]) ->andFilterWhere(['like', 'emp_midname', $this->emp_midname]) ->andFilterWhere(['like', 'emp_position', $this->emp_position]) ->andFilterWhere(['like', 'emp_department', $this->emp_department]); return $dataProvider; }
//['label' => 'Migration', 'url' => ['/migrated-alumni/index']], ['label' => 'Testimonials', 'url' => ['/testimonials/index']], ['label' => 'Users', 'url' => ['/user/index']], [ 'label' => 'Logout (' . Yii::$app->user->identity->username . ')', 'url' => ['/site/logout'], 'linkOptions' => ['data-method' => 'post']], ]; }else if ($roles == 'user'){ $userid = ArrayHelper::getValue(User::find()->where(['username' => Yii::$app->user->identity->username])->one(), 'id'); $employeeid = ArrayHelper::getValue(Employee::find()->where(['user_id' => $userid])->one(), 'employee_id'); $menuItems =[ ['label' => 'Home', 'url' => ['/site/index']], ['label' => 'Alumni', 'url' => ['/alumni/index']], //['label' => 'City', 'url' => ['/city/index']], //['label' => 'Course', 'url' => ['/course/index']], //['label' => 'School', 'url' => ['/school/index']], //['label' => 'Province', 'url' => ['/province/index']], //['label' => 'Region', 'url' => ['/region/index']], //['label' => 'Employee', 'url' => ['/employee/view', 'id' => $employeeid]], ['label' => 'Event', 'url' => ['/event/index']], //['label' => 'Logs', 'url' => ['/logs/index']], //['label' => 'Migration', 'url' => ['/migration/index']], ['label' => 'Testimonials', 'url' => ['/testimonials/index']],
public function actionProspek() { $regional = Regional::find()->all(); $badanhukum = Employee::find()->select(['FIELD2'])->distinct('FIELD2')->all(); $bussiness = Employee::find()->select(['FIELD9'])->distinct('FIELD9')->all(); $query = new Query(); $data = array(); foreach ($regional as $rows) { $query->select('COUNT(*) AS JUMLAH')->from('TABLE2')->join('LEFT OUTER JOIN', 'TABLE3', 'TABLE3.FIELD2 = TABLE2.FIELD1')->where(['TABLE3.FIELD7' => $rows->FIELD1])->andWhere('TABLE3.FIELD3 IS NOT NULL')->all(); $handphone = $query->createCommand()->queryScalar(); $query->select('COUNT(*) AS JUMLAH')->from('TABLE2')->join('LEFT OUTER JOIN', 'TABLE3', 'TABLE3.FIELD2 = TABLE2.FIELD1')->where(['TABLE3.FIELD7' => $rows->FIELD1])->andWhere('TABLE3.FIELD6 IS NOT NULL')->all(); $email = $query->createCommand()->queryScalar(); $query->select('COUNT(*) AS JUMLAH')->from('TABLE2')->join('LEFT OUTER JOIN', 'TABLE3', 'TABLE3.FIELD2 = TABLE2.FIELD1')->where(['TABLE3.FIELD7' => $rows->FIELD1])->andWhere('TABLE2.FIELD7 IS NOT NULL')->all(); $phone = $query->createCommand()->queryScalar(); array_push($data, array('regional' => $rows->FIELD1, 'handphone' => $handphone, 'email' => $email, 'phone' => $phone)); } return $this->render('prospek', ['data' => $data, 'regional' => $regional, 'badanhukum' => $badanhukum, 'bussiness' => $bussiness]); }