/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Companies::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(['company_id' => $this->company_id, 'company_country_id' => $this->company_country_id, 'company_province_id' => $this->company_province_id, 'company_city_id' => $this->company_city_id, 'company_zipcode' => $this->company_zipcode]); $query->andFilterWhere(['like', 'company_name', $this->company_name])->andFilterWhere(['like', 'company_address', $this->company_address])->andFilterWhere(['like', 'company_email', $this->company_email])->andFilterWhere(['like', 'company_phone', $this->company_phone])->andFilterWhere(['like', 'company_phone_ii', $this->company_phone_ii])->andFilterWhere(['like', 'company_contact_person', $this->company_contact_person])->andFilterWhere(['like', 'company_website', $this->company_website])->andFilterWhere(['like', 'company_status', $this->company_status])->andFilterWhere(['like', 'company_key', $this->company_key])->andFilterWhere(['like', 'company_logo', $this->company_logo]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Companies::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(['company_id' => $this->company_id]); $query->andFilterWhere(['like', 'company_name', $this->company_name]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Companies::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => array('pageSize' => 2)]); $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; } if (isset($params['CompaniesSearch']['search']) && $params['CompaniesSearch']['search'] != '') { if ($params['CompaniesSearch']['field'] == '') { $query->orFilterWhere(['=', 'id', $params['CompaniesSearch']['search']])->orFilterWhere(['=', 'status', $params['CompaniesSearch']['search']])->orFilterWhere(['like', 'company_name', $params['CompaniesSearch']['search']])->orFilterWhere(['like', 'company_address', $params['CompaniesSearch']['search']])->orFilterWhere(['like', 'created_dt', $params['CompaniesSearch']['search']])->orFilterWhere(['like', 'company_email', $params['CompaniesSearch']['search']]); } else { $query->andFilterWhere(['like', $params['CompaniesSearch']['field'], $params['CompaniesSearch']['search']]); } } else { $query->andFilterWhere(['id' => $this->id, 'created_dt' => $this->created_dt, 'company_name' => $this->status]); $query->andFilterWhere(['like', 'company_name', $this->company_name])->andFilterWhere(['like', 'company_address', $this->company_address])->andFilterWhere(['like', 'company_email', $this->company_email]); } return $dataProvider; }
/** * @return \yii\db\ActiveQuery */ public function getCompany() { return $this->hasOne(Companies::className(), ['id' => 'company_id']); }
/** * Logs in a user using the provided username and password. * * @return boolean whether the user is logged in successfully */ public function getuserCompany() { //$company = User::findAllByAttributes(['company_id']) return $this->hasMany(Companies::className(), ['company_id' => 'company_id']); }
/** * Finds the Companies model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Companies the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Companies::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
<p>Please fill out the following fields to signup:</p> <div class="row"> <div class="col-lg-5"> <?php $form = ActiveForm::begin(['id' => 'form-signup']); ?> <?php echo $form->field($model, 'username'); ?> <?php echo $form->field($model, 'first_name'); ?> <?php echo $form->field($model, 'company_id')->dropDownList(ArrayHelper::map(Companies::find()->all(), 'company_id', 'company_name'), ['prompt' => 'Select Company'])->label('Company'); ?> <?php echo $form->field($model, 'last_name'); ?> <?php echo $form->field($model, 'email'); ?> <?php echo $form->field($model, 'password')->passwordInput(); ?> <?php $authItems = ArrayHelper::map($authItems, 'name', 'name'); ?>