/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Customer::find();
$dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]]]);
$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(['id' => $this->id, 'phone_number' => $this->phone_number, 'dob' => $this->dob, 'gender' => $this->gender, 'language_id' => $this->language_id, 'is_active' => $this->is_active, 'status' => $this->status, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at, 'total_purchase_orders' => $this->total_purchase_orders, 'total_purchase_products' => $this->total_purchase_products, 'total_purchase_value' => $this->total_purchase_value]);
$query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'password_hash', $this->password_hash])->andFilterWhere(['like', 'password_reset_token', $this->password_reset_token])->andFilterWhere(['like', 'auth_key', $this->auth_key])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'firstname', $this->firstname])->andFilterWhere(['like', 'lastname', $this->lastname])->andFilterWhere(['like', 'image', $this->image])->andFilterWhere(['like', 'image_path', $this->image_path])->andFilterWhere(['like', 'zip_postal_code', $this->zip_postal_code]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Customer::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(['customer_birthdate' => $this->customer_birthdate]);
$query->andFilterWhere(['like', 'customer_user_name', $this->customer_user_name])->andFilterWhere(['like', 'customer_first_name', $this->customer_first_name])->andFilterWhere(['like', 'customer_last_name', $this->customer_last_name])->andFilterWhere(['like', 'customer_address1', $this->customer_address1])->andFilterWhere(['like', 'customer_address2', $this->customer_address2])->andFilterWhere(['like', 'customer_email', $this->customer_email])->andFilterWhere(['like', 'customer_gender', $this->customer_gender])->andFilterWhere(['like', 'customer_from', $this->customer_from])->andFilterWhere(['like', 'customer_favcolor', $this->customer_favcolor]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params, $pagination = 10)
{
$query = Customer::find();
// add conditions that should always apply here
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pagesize' => $pagination]]);
$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;
}
// grid filtering conditions
$query->andFilterWhere(['id' => $this->id, 'role' => $this->role, 'created_at' => $this->created_at, 'updated_at' => $this->updated_at]);
$query->andFilterWhere(['like', 'username', $this->username])->andFilterWhere(['like', 'tel', $this->tel])->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['like', 'postal', $this->postal])->andFilterWhere(['like', 'city', $this->city]);
return $dataProvider;
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Customer::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([
// 'ts_create' => $this->ts_create,
// 'ts_update' => $this->ts_update,
// 'IsDelete' => $this->IsDelete,
// ]);
$query->orFilterWhere(['like', 'Cus_id', $this->globalSearch])->orFilterWhere(['like', 'Cus_Name', $this->globalSearch])->orFilterWhere(['like', 'Cus_Nickname', $this->globalSearch])->orFilterWhere(['like', 'Cus_Phone', $this->globalSearch])->orFilterWhere(['like', 'Cus_Email', $this->globalSearch])->orFilterWhere(['like', 'Cus_Website', $this->globalSearch])->orFilterWhere(['like', 'Cus_Address', $this->globalSearch])->orFilterWhere(['like', 'Cus_Contactname', $this->globalSearch])->orFilterWhere(['like', 'Cus_Customeras', $this->globalSearch])->orFilterWhere(['like', 'Cus_Country', $this->globalSearch])->orFilterWhere(['like', 'ts_name', $this->globalSearch]);
return $dataProvider;
}
public function actionShowlist2($id)
{
$count = Customer::find()->where(['Cus_id' => $id])->count();
$model = Customer::find()->where(['Cus_id' => $id])->all();
if ($count > 0) {
foreach ($model as $value) {
$contry = \backend\models\Country::find()->where(['Cry_id' => $value->Cus_Country])->all();
$fullname2 = '';
foreach ($contry as $data2) {
$fullname2 = $data2->Cry_nameEN . " [" . $data2->Cry_nameTH . "]";
}
$session = new Session();
$session->open();
$session['shipto'] = $value->Cus_Country;
echo "<option value='" . $value->Cus_Country . "'>{$fullname2}</option>";
}
} else {
echo "<option>-</option>";
}
}
echo Yii::$app->urlManager->createUrl('noreply-email/create');
?>
"><i class="fa fa-circle-o"></i> Thêm mới</a></li>
</ul>
</li>
<!-- Khách hàng -->
<li class="treeview <?php
echo in_array(Yii::$app->controller->id, ['customer', 'customer-log']) ? 'active' : '';
?>
">
<a href="<?php
echo Yii::$app->urlManager->createUrl('customer/index');
?>
">
<i class="fa fa-user"></i> <span>Khách hàng</span> <span class="label label-danger pull-right"><?php
echo Customer::find()->where(['status' => Customer::STATUS_ACTIVE])->count();
?>
</span>
</a>
<!-- <ul class="treeview-menu">
<li class="<?php
echo Yii::$app->controller->id == 'customer' && Yii::$app->controller->action->id == 'index' ? 'active' : '';
?>
"><a href="<?php
echo Yii::$app->urlManager->createUrl('customer/index');
?>
"><i class="fa fa-circle-o"></i> Danh sách</a></li>
<li class="<?php
echo Yii::$app->controller->id == 'customer-log' && Yii::$app->controller->action->id == 'index' ? 'active' : '';
?>
"><a href="<?php
public function actionEditpoint()
{
$user = new AdminUser();
if (!$user->checkUserIsLogin()) {
$this->redirect(Variable::$home_url);
return;
}
// $form=new CustomerForm();
// $req=Yii::$app->request;//创建一个请求对象
// $form->setScenario('update');
// if($form->load($req->post()) && $form->validate()){
// print_r($form);
// }
// $form->setScenario('update');
$req = Yii::$app->request;
//创建一个请求对象
$id = trim($req->get('id'));
if (!is_numeric($id) || $id == 0) {
$this->redirect(Variable::$barIndex_url);
return;
}
$brandModel = Customer::findOne($id);
$catModel = Customer::find()->where(['parentId' => $id])->all();
// $barListModel=Bar::find()->where(['parentBar'=>$id])->all();
return $this->render(Variable::$editPoint_view, ['catModel' => $catModel, 'brandModel' => $brandModel]);
}
