/**
* Auther:langxi
*
* 用户输入邀请码获取加息劵，需要改变activity_code的状态值，1为被领取,0为未领取
*/
public static function getCoupon($member_id, $name)
{
if (!$member_id || !is_numeric($member_id) || !is_int($member_id)) {
$result = array('errorNum' => '1', 'errorMsg' => '参数错误', 'data' => null);
return $result;
}
$name = Code::find()->where(['name' => $name, 'status' => '0'])->asArray()->one();
if (!$name) {
$result = array('errorNum' => '1', 'errorMsg' => '邀请码不存在或已被使用', 'data' => null);
return $result;
}
$id = $name['id'];
//邀请码对应的加息劵id（code表的id）
$coupon_id = $name['coupon_id'];
//加息劵id
//$validity_time = $name['validity_time']; //加息劵作用时间长度
$rate = $name['rate'];
//利率
$use_at = $name['use_at'];
//有效期时间起点
$use_end_time = $name['use_end_time'];
//有效期时间结束点
//事物回滚
$transaction = \Yii::$app->db->beginTransaction();
try {
//将邀请码获取到的加息劵放入到用户的加息劵中
$raise_card = new RaiseCard();
$raise_card->member_id = $member_id;
$raise_card->coupon_id = $coupon_id;
$raise_card->validity_start_at = $use_at;
$raise_card->validity_out_at = $use_end_time;
$raise_card->rate = $rate;
$raise_card = $raise_card->save();
if (!$raise_card) {
$result = array('errorNum' => '1', 'errorMsg' => '将邀请码获取到的加息劵放入到用户的加息劵中失败', 'data' => null);
return $result;
}
//改变邀请码对应的加息劵的状态为被领取
$code = Code::findOne($id);
$code->status = '1';
$code = $code->save();
if (!$code) {
$result = array('errorNum' => '1', 'errorMsg' => '改变邀请码状态失败', 'data' => null);
return $result;
}
$transaction->commit();
$result = array('errorNum' => '0', 'errorMsg' => 'success', 'data' => null);
return $result;
} catch (ErrorException $e) {
$transaction->rollBack();
$remark = $e->getMessage();
$result = array('errorNum' => '1', 'errorMsg' => $remark, 'data' => null);
return $result;
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Code::find()->orderBy('id DESC');
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'status' => $this->status, 'display' => $this->display]);
$query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'validity_time', $this->validity_time])->andFilterWhere(['like', 'rate', $this->rate])->andFilterWhere(['like', 'use_end_time', $this->use_end_time])->andFilterWhere(['like', 'created_at', $this->created_at])->andFilterWhere(['like', 'updated_at', $this->updated_at]);
return $dataProvider;
}
/**
* Auther:langxi
*
* 用户输入邀请码获取加息劵，需要改变activity_code的状态值，1为被领取,0为未领取
*/
public static function getCoupon($member_id, $name)
{
$name = Code::find()->where(['name' => $name, 'status' => '0'])->asArray()->one();
if (!$name) {
throw new ErrorException('邀请码不存在或已被使用', 7001);
}
$id = $name['id'];
//邀请码对应的加息劵id（code表的id）
$coupon_id = $name['coupon_id'];
//加息劵id
//$validity_time = $name['validity_time']; //加息劵作用时间长度
$rate = $name['rate'];
//利率
$use_at = $name['use_at'];
//有效期时间起点
$use_end_time = $name['use_end_time'];
//有效期时间结束点
//事物回滚
$transaction = \Yii::$app->db->beginTransaction();
try {
//将邀请码获取到的加息劵放入到用户的加息劵中
$raise_card = new RaiseCard();
$raise_card->member_id = $member_id;
$raise_card->coupon_id = $coupon_id;
$raise_card->validity_start_at = $use_at;
$raise_card->validity_out_at = $use_end_time;
$raise_card->rate = $rate;
$raise_card = $raise_card->save();
if (!$raise_card) {
throw new ErrorException('将邀请码获取到的加息劵放入到用户的加息劵中失败', 7001);
}
//改变邀请码对应的加息劵的状态为被领取
$code = Code::findOne($id);
$code->status = '1';
$code = $code->save();
if (!$code) {
throw new ErrorException('改变邀请码状态失败', 7001);
}
$transaction->commit();
return true;
} catch (ErrorException $e) {
$transaction->rollBack();
}
}
