Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function actionMyTerminals() {
- Yii::app()->getModule('coupon');
- $uid = Yii::app()->user->getID();
- $criteria = new CDbCriteria;
- // $criteria->distinct = true;
- $criteria->select = "t.*";
- $criteria->join = "JOIN tbl_coupon_terminal ON t.terminal_id = t.id_terminal
- JOIN tbl_coupon ON tbl_coupon.id_coupon = tbl_coupon_terminal.id_coupon";
- $criteria->condition = "tbl_coupon.user_id = $uid";
- $criteria->group = "t.terminal_id";
- $dataProvider = new CActiveDataProvider('Terminals', array(
- 'criteria' => $criteria,
- 'pagination'=>array(
- 'pageSize'=>6,
- ))
- );
- $this->render('myterminals', array(
- 'dataProvider' => $dataProvider,
- ));
- }
Add Comment
Please, Sign In to add comment