public function actionCodes($id)
{
$this->layout = '//layouts/memberList';
$type = Yii::app()->request->getParam('type', Globals::CODE_TYPE_LEGAL);
$codeTable = 'scratch_awards';
$whereSql = 'scratchId=' . $id . ' and type=' . $type;
$count = Yii::app()->db->createCommand('SELECT COUNT(*) FROM ' . $codeTable . ' where ' . $whereSql)->queryScalar();
$sql = 'SELECT * FROM ' . $codeTable . ' where ' . $whereSql;
$dataProvider = new CSqlDataProvider($sql, array('totalItemCount' => $count, 'sort' => array('attributes' => array('name')), 'pagination' => array('pageSize' => Page::SIZE)));
$this->render('code', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'scratchId' => $id, 'type' => $type));
}
public function actionGiftCodes($id)
{
$this->layout = '/layouts/memberList';
$codeTable = sprintf(GiftModel::CREATE_CODE_TABLE_NAME, $this->wechatInfo->id);
$whereSql = 'giftId=' . $id;
//DELET
$count = Yii::app()->db->createCommand('SELECT COUNT(*) FROM ' . $codeTable . ' where ' . $whereSql)->queryScalar();
$sql = 'SELECT * FROM ' . $codeTable . ' where ' . $whereSql;
$dataProvider = new CSqlDataProvider($sql, array('totalItemCount' => $count, 'sort' => array('attributes' => array('name')), 'pagination' => array('pageSize' => Page::SIZE)));
$this->render('giftCode', array('data' => $dataProvider->getData(), 'pages' => $dataProvider->getPagination(), 'giftId' => $id));
}
