示例#1
0
 /**
  * @param $id
  * @return string
  * @throws NotFoundHttpException
  * @throws \yii\web\ServerErrorHttpException
  */
 public function actionIndex()
 {
     $q = Partner::find()->join('JOIN', 'WPARTNERSERVICE', 'WPARTNERSERVICE.WPARTNER_ID = wpartner.id')->join('JOIN', 'WSERVICELIST', 'WSERVICELIST.ID = WPARTNERSERVICE.WSERVICELIST_ID')->where(['WPARTNERSERVICE.WSERVICETYPE_ID' => 1])->groupBy(['wpartner.id'])->with('hotels');
     if ($city = (int) Yii::$app->request->get('city')) {
         $q->andWhere(['wcity_id' => $city]);
     }
     $provider = new ActiveDataProvider(['query' => $q, 'pagination' => ['pageSize' => 10]]);
     return $this->render('hotelList', ['provider' => $provider]);
 }
示例#2
0
 /**
  * @param $id
  * @return string
  * @throws NotFoundHttpException
  * @throws \yii\web\ServerErrorHttpException
  */
 public function actionIndex()
 {
     $q = Partner::find()->join('JOIN', 'WPARTNERSERVICE', 'WPARTNERSERVICE.WPARTNER_ID = wpartner.id')->join('JOIN', 'WSERVICELIST', 'WSERVICELIST.ID = WPARTNERSERVICE.WSERVICELIST_ID')->where(['>', 'WPARTNERSERVICE.WSERVICETYPE_ID', 1])->groupBy(['wpartner.id'])->with('services');
     $provider = new ActiveDataProvider(['query' => $q, 'pagination' => ['pageSize' => 10]]);
     return $this->render('serviceList', ['provider' => $provider]);
 }