Guest User

Untitled

a guest
Dec 5th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.92 KB | None | 0 0
  1.  
  2.        public function actionMyTerminals() {
  3.                 Yii::app()->getModule('coupon');
  4.                
  5.            $uid = Yii::app()->user->getID();
  6.            $criteria = new CDbCriteria;
  7. //           $criteria->distinct = true;
  8.            $criteria->select = "t.*";
  9.            $criteria->join = "JOIN tbl_coupon_terminal ON t.terminal_id = t.id_terminal
  10.                             JOIN tbl_coupon ON tbl_coupon.id_coupon = tbl_coupon_terminal.id_coupon";
  11.            $criteria->condition = "tbl_coupon.user_id = $uid";
  12.            $criteria->group = "t.terminal_id";
  13.  
  14.         $dataProvider = new CActiveDataProvider('Terminals', array(
  15.                 'criteria' => $criteria,
  16.                 'pagination'=>array(
  17.                         'pageSize'=>6,
  18.                 ))
  19.                 );
  20.         $this->render('myterminals', array(
  21.             'dataProvider' => $dataProvider,
  22.              
  23.         ));
  24.     }
Add Comment
Please, Sign In to add comment