/** * 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; }
<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'); ?>