PHP(niushop框架)充值区间段获取积分
if($panduan['type']==4){
$data=Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->find();
$jifeng=$data['point'];
$list=Db::name('ns_member_czsongjifeng')->field('fanwei,songjifeng')->select();
$sjf=Db::name('ns_order_payment')->field('pay_type,original_money,out_trade_no')->where('out_trade_no',$out_trade_no)->find();
$djf=$sjf['original_money'];
foreach ($list as $key => $value) {
$fanwei=$value['fanwei'];
$fanwei = (str_replace('以上','',$fanwei));
$saifen=explode('~',$fanwei);
if(count($saifen)==2 && $djf>=$saifen[0] && $djf<=$saifen[1]){
$jifeng1=$value['songjifeng'];
$result=$jifeng+$jifeng1;
Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->update(['point'=>$result]);
}
else if(count($saifen)==1 && $saifen[0]<=$djf){
$jifeng1=$value['songjifeng'];
$result=$jifeng+$jifeng1;
Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->update(['point'=>$result]);
}
}
$lsit=array(
'uid'=>$this->uid,
'account_type'=>1,
'sign'=>1,
'number'=>$jifeng1,
'from_type'=>4,
'account_type'=>1,
'data_id'=>$order_id,
'text'=>'微信充值',
'create_time'=>time()
);
Db::name('ns_member_account_records')->field('uid,account_type,sign,number,from_type,data_id,text,create_time')->insert($lsit);
}
else{
$data=Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->find();
$jifeng=$data['point'];
$list=Db::name('ns_member_songjifeng')->field('fanwei,songjifeng')->select();
$sjf=Db::name('ns_order_payment')->field('pay_type,original_money,out_trade_no')->where('out_trade_no',$out_trade_no)->find();
$djf=$sjf['original_money'];
foreach ($list as $key => $value) {
$fanwei=$value['fanwei'];
$fanwei = (str_replace('以上','',$fanwei));
$saifen=explode('~',$fanwei);
if(count($saifen)==2 && $djf>=$saifen[0] && $djf<=$saifen[1]){
$jifeng1=$value['songjifeng'];
$result=$jifeng+$jifeng1;
Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->update(['point'=>$result]);
}
else if(count($saifen)==1 && $saifen[0]<=$djf){
$jifeng1=$value['songjifeng'];
$result=$jifeng+$jifeng1;
Db::name('ns_member_account')->field('uid,point')->where('uid',$this->uid)->update(['point'=>$result]);
}
}
$lsit=array(
'uid'=>$this->uid,
'account_type'=>1,
'sign'=>1,
'number'=>$jifeng1,
'from_type'=>1,
'account_type'=>1,
'data_id'=>$order_id,
'text'=>'购买商品赠送积分',
'create_time'=>time()
);
Db::name('ns_member_account_records')->field('uid,account_type,sign,number,from_type,data_id,text,create_time')->insert($lsit);
}
}