<?php namespace backend/controllers;header("Content-type:text/html;charset=utf-8");use Yii;use yii/web/Controller; //超級控制器類use backend/models/BooksInfo; //表Model類use backend/models/InfoSearch; //引入搜索Model類use yii/data/ActiveDataProvider; //小部件數據源類use yii/grid/GridView; //查詢小部件/** *@abstract BooksController *@author NING <[email ning@163.com]> *@version [version 1.0] [書籍管理] */class BooksInfoController extends Controller{  //書籍列表 public function actionIndex() { $searchModel = new InfoSearch(); //實例化searchModel[搜索Model] if(!empty($_GET['InfoSearch'])){  $getSearch = Yii::$app->request->get(); //接收搜索字段  $data = $searchModel->search($getSearch); }else{  //小部件查詢數據  $data = new ActiveDataProvider([    'query' => BooksInfo::find(), //查詢數據    'pagination' => [      'pageSize' => 2, //每頁顯示條數    ],    'sort' => [      'defaultOrder' => [        // 'created_at' => SORT_DESC,        'id' => SORT_ASC, //[字段]設置排序?      ]    ],  ]); } //傳送查詢數據、搜素Model return $this->render('index',['data'=>$data,'searchModel'=>$searchModel]); }?>

<?php namespace backend/models;use Yii;use yii/db/ActiveRecord;/** *@abstract [BookForm] *@author NING <[email ning@163.com]> *@version [vector 1.0] [書籍詳情模型] */class BooksInfo extends ActiveRecord{ /**   * @設置表名   */  public static function tableName()  {    return '{{%books_info}}';  }  //關聯表  public function getBooksType(){    // hasOne要求返回兩個參數 第一個參數是關聯表的類名 第二個參數是兩張表的關聯關系     // 這里id是books_type表的id, 關聯books_info表的type_id     return $this->hasOne(BooksType::className(), ['id' => 'type_id']);  } public function attributeLabels() { return [  'id' => 'ID',  'book_name' => '書籍名稱',  'book_face' => '書籍封面',  'type_id' => '書籍分類ID',  'type_name' => '書籍分類', ]; }}?>

<?phpnamespace backend/models; //命名空間use Yii;use yii/base/Model; //引入基類Modeluse yii/data/ActiveDataProvider;  //引入數據源類/** *@abstract [搜索Model] *@return [type] *@author NING <[email ning@163.com]> */// 注意:此處繼承的是查詢Model--->BooksInfoclass InfoSearch extends BooksInfo{  public $type_name; //定義屬性變量  // 只有在 rules() 函數中聲明的字段才可以搜索  public function rules()  {    return [      // [['book_name','type_name'], 'safe'],      [['type_name'], 'safe'],    ];  }  public function scenarios()  {    // 旁路在父類中實現的 scenarios() 函數    return Model::scenarios();  }  public function search($params)  {    $query = BooksInfo::find();    $dataProvider = new ActiveDataProvider([      'query' => $query,      'pagination' => [        'pageSize' => 1,      ],    ]);    /*這里的articlecategory是article模型里面關聯的方法名，除了首字母，其他都要完全一樣，否則會報錯*/    $query->joinWith(['booksType']);    // 從參數的數據中加載過濾條件，并驗證    if (!($this->load($params) && $this->validate())) {      return $dataProvider;    }    // 增加過濾條件來調整查詢對象    $query->andFilterWhere(['like', 'book_name', $this->book_name]);    //添加關聯字段過濾條件[注意:此處books_type.type_name中books_type為分類表名]    $query->andFilterWhere(['like', 'books_type.type_name', $this->type_name]);    return $dataProvider;  }}?>

<?php use yii/grid/GridView;use yii/data/ActiveDataProvider;use yii/grid/ActionColumn;use yii/helpers/Html;$this->title = '圖書列表';?><!-- 面包屑 --><ol class="breadcrumb"> <li><a href="#" rel="external nofollow" rel="external nofollow" >Home</a></li> <li><a href="#" rel="external nofollow" rel="external nofollow" >圖書信息</a></li> <li class="active">圖書列表</li></ol><?phpecho GridView::widget([ 'dataProvider' => $data,  //數據源  'filterModel' => $searchModel, //搜索列 'columns' => [    // ['filterModel' => $searchModel],    ['class' => 'yii/grid/CheckboxColumn'], //復選框列    ['attribute' => 'id'],   ['attribute' => 'book_name',],    ['attribute' => 'book_face','content'=>function($model){     // 圖片顯示     return Html::img($model->book_face,['width'=>'50']);    }], [      'attribute' => 'type_name',      'value' => 'booksType.type_name', //兩表聯查[書籍類型]    ],    ['class' => 'yii/grid/ActionColumn','header'=>'操作'], //動作列 ],  'pager' => [//自定義分頁樣式以及顯示內容    'prevPageLabel'=>'上一頁',    'nextPageLabel'=>'下一頁',    'firstPageLabel' => '第一頁',    'lastPageLabel' => '最后一頁',    'options'=>['style'=>'margin-left:200px;','class'=>"pagination"],    ],]);?>