/**
*
* @param int $data
* @return type
*/
public static function findGift($data = array())
{
if (!isset($data['limit'])) {
$data['limit'] = 10;
}
$type = 1;
if (isset($data['get']['type'])) {
$type = intval($data['get']['type']);
}
$query = ViewGifts::find()->Where('user_id=:user_id AND ac_type=:actype', [':user_id' => $data['user_id'], ':actype' => $type])->orderBy(" id desc ");
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count(), 'pageSize' => $data['limit']]);
$models = $query->offset($pages->offset)->limit($pages->limit)->all();
return ['models' => $models, 'pages' => $pages];
}
/**
*
* @return type
*/
public function actionGetgift()
{
$user_id = \Yii::$app->user->getId();
#获得用户的可用资金
$p_param = \Yii::$app->request->get();
if (!isset($p_param['id']) || !isset($p_param['type'])) {
echo 1;
\Yii::$app->end();
}
$gift = ViewGifts::find()->where("id=:id AND user_id=:user_id AND ac_type=:type AND LENGTH(fittime)<5", [':id' => $p_param['id'], ':user_id' => $user_id, ':type' => $p_param['type']])->one();
if (!isset($gift)) {
echo 1;
\Yii::$app->end();
}
if (isset($p_param['sure']) && $p_param['sure'] == 1) {
$in_p_user_id = $gift->user_id;
$id = $gift->id;
#调有存储过程冻结资金并生成订单
$conn = \Yii::$app->db;
$trance = $conn->beginTransaction();
try {
$addip = \Yii::$app->request->userIP;
$user_id = \Yii::$app->user->getId();
$conn = \Yii::$app->db;
$command = $conn->createCommand('call p_get_Gift(:in_p_user_id,:id,:in_addip,@out_status,@out_remark)');
$command->bindParam(":in_p_user_id", $user_id, PDO::PARAM_INT);
$command->bindParam(":id", $id, PDO::PARAM_STR);
$command->bindParam(":in_addip", $addip, PDO::PARAM_STR, 50);
$command->execute();
$fit = $conn->createCommand("select @out_status as status,@out_remark as remark")->queryOne();
} catch (Exception $e) {
$trance->rollBack();
$fit = ['remark' => '领取失败', 'status' => 0];
}
} else {
$fit = [];
}
return $this->renderAjax('ajax_getgift', ['order' => $gift, 'p_param' => $p_param, 'fit' => $fit]);
}
