<?php
|
/*
|
* $Author ：PHPYUN开发团队
|
*
|
* 官网: http://www.phpyun.com
|
*
|
* 版权所有 2009-2021 宿迁鑫潮信息技术有限公司，并保留所有权利。
|
*
|
* 软件声明：未经授权前提下，不得用于商业运营、二次开发以及任何形式的再次发布。
|
*/
|
class redeem_model extends model
|
{
|
/**
|
* @desc 引用log类，添加用户日志
|
*/
|
private function addMemberLog($uid,$usertype,$content,$opera='',$type='') {
|
require_once ('log.model.php');
|
$LogM = new log_model($this->db, $this->def);
|
return $LogM -> addMemberLog($uid,$usertype,$content,$opera='',$type='');
|
}
|
//查询单条商品
|
function getInfo($where=array(),$data=array()){
|
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$info = $this -> select_once('reward',$where,$data['field']);
|
if(!empty($info)){
|
if($info['pic']){
|
$info['pic'] = checkpic($info['pic']);
|
}
|
if($info['content']){
|
$content=htmlspecialchars_decode($info['content']);
|
$info['content_n'] = $content;
|
preg_match_all('/<img(.*?)src=("|\'|\s)?(.*?)(?="|\'|\s)/',$content,$res);
|
if(!empty($res[3])){
|
foreach($res[3] as $v){
|
if(strpos($v,'http:')===false && strpos($v,'https:')===false){
|
$ossv = checkpic($v);
|
$info['content_n'] = str_replace($v,$ossv,$content);
|
}
|
}
|
}
|
}
|
}
|
return $info;
|
}
|
|
//查询商品列表
|
function getList($whereData,$data=array()){
|
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this->select_all("reward",$whereData,$data['field']);
|
|
if(!empty( $List )){
|
|
foreach($List as $key=>$val){
|
$nids[] = $val['nid'];
|
$tnids[] = $val['tnid'];
|
}
|
|
$classWhere['id'] = array('>',0);
|
$class = $this->select_all("redeem_class",$classWhere);
|
|
$classname='';
|
foreach($List as $k=>$v){
|
foreach($class as $val){
|
if($v['nid']==$val['id']){
|
$classname = $val['name'];
|
}
|
|
if($v['tnid']==$val['id']){
|
$classname = $List[$k]['classname'].'-'.$val['name'];
|
}
|
|
$List[$k]['classname'] = $classname;
|
}
|
}
|
}
|
|
return $List;
|
}
|
|
function upInfo($data = array(),$whereData)
|
{
|
if(!empty($whereData)){
|
$nid = $this -> update_once('reward',$data,$whereData);
|
}
|
return $nid;
|
}
|
|
function delReward($whereData,$data){
|
|
if($data['type']=='one'){//单个删除
|
|
$limit = 'limit 1';
|
}
|
|
if($data['type']=='all'){//多个删除
|
|
$limit = '';
|
}
|
|
$result = $this -> delete_all('reward',$whereData,$limit);
|
|
return $result;
|
|
}
|
|
function addInfo($setData){
|
|
if(!empty($setData)){
|
|
$nid = $this -> insert_into('reward',$setData);
|
|
}
|
|
return $nid;
|
}
|
function getChangeList($whereData,$data=array()){
|
$ListNew = array();
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
$List = $this -> select_all('change',$whereData,$data['field']);
|
|
if(!empty( $List )){
|
|
$gid = array();
|
|
foreach($List as $key=>$val){
|
|
$gid[] = $val['gid'];
|
|
}
|
|
require_once ('redeem.model.php');
|
$redeemM = new redeem_model($this->db, $this->def);
|
$gift = $redeemM->getList(array('id'=>array('in',pylode(',', $gid))),array('field'=>'id,pic'));
|
|
$dh = $sh = $wtg =0;
|
foreach($List as $key=>$val){
|
$List[$key]['wapredeem_url'] = Url('wap',array('c'=>'redeem','a'=>'show','id'=>$val['gid']));
|
$List[$key]['ctime_n'] = date('Y-m-d h:i',$val['ctime']);
|
if($val['body']){
|
$List[$key]['address'] = mb_substr($val['body'],5,-1);
|
}else{
|
$List[$key]['address']="";
|
}
|
foreach ($gift as $v){
|
if($val['gid']==$v['id']){
|
$List[$key]['pic'] = checkpic($v['pic'],$this->config['sy_imgsc_mr']);
|
}
|
}
|
|
if($data['utype']=='wap'){
|
|
|
if($val['status']==0){
|
$sh = $sh + 1;
|
}
|
|
if($val['status']==2){
|
$wtg = $wtg + 1;
|
}
|
if($val['status']==1){
|
$dh = $dh + 1;
|
}
|
}
|
}
|
$ListNew['dh'] = $dh;
|
$ListNew['wtg'] = $wtg;
|
$ListNew['sh'] = $sh;
|
$ListNew['list'] = $List;
|
|
}
|
|
return $ListNew;
|
}
|
|
function getChangeInfo($whereData, $data = array()){
|
|
if($whereData){
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this -> select_once('change',$whereData,$data['field']);
|
}
|
|
return $List;
|
|
}
|
function AddChange($data = array()){
|
$num = (int)$data['num'];
|
$id = (int)$data['id'];
|
|
$info = $this->select_once('member',array("uid"=>$data['uid']),'`password`,`salt`');
|
|
require_once ('statis.model.php');
|
$statisM = new statis_model($this->db, $this->def);
|
$statis = $statisM->getInfo($data['uid'],array("usertype"=>$data['usertype'],"field"=>"`integral`"));
|
|
$gift = $this->getInfo(array("id"=>(int)$data['id']));
|
|
$nums = $this->select_num('change',array("gid"=>$gift['id'],"uid"=>$data['uid']));
|
|
$integral = $gift['integral']*$num;
|
|
if(!$data['uid'] && !$data['username']){
|
$return['msg'] = '您还没有登录，请先登录！';
|
$return['errcode'] = '8';
|
}elseif(!$data['linkman'] || !$data['linktel'] ){
|
$return['msg'] = '收件人和手机号码不能为空！';
|
$return['errcode'] = '8';
|
}elseif($data['linktel']&&CheckMobile($data['linktel'])==false){
|
$return['msg'] = '手机格式错误！';
|
$return['errcode'] = '8';
|
}elseif(!$data['password']){
|
$return['msg'] = '密码不能为空！';
|
$return['errcode'] = '8';
|
}elseif(!passCheck($data['password'],$info['salt'],$info['password'])){
|
$return['msg'] = '用户名或密码不正确！';
|
$return['errcode'] = '8';
|
}elseif($num<1){
|
$return['msg'] = '请填写正确的数量！';
|
$return['errcode'] = '8';
|
}elseif($num>$gift['stock']){
|
$return['msg'] = '已超出库存数量！';
|
$return['errcode'] = '8';
|
}elseif($gift['restriction']!='0' && $nums+$num>$gift['restriction']){
|
$return['msg'] = '已超出限购数量！';
|
$return['errcode'] = '8';
|
}elseif($statis['integral']<$integral){
|
$return['msg'] = '您的'.$this->config['integral_pricename'].'不足！';
|
$return['errcode'] = '8';
|
}else{
|
require_once ('integral.model.php');
|
$integralM = new integral_model($this->db, $this->def);
|
//积分操作记录
|
$integralM->company_invtal($data['uid'],$data['usertype'],$integral,false,"".$this->config['integral_pricename']."兑换",true,2,'integral',24);
|
if($data['bodyt']){
|
$data['body']=$data['bodyt'];
|
}else{
|
$data['body']='收货地址：'.$data['provinceid'].' '.$data['cityid'].' '.$data['three_cityid'];
|
if($data['address']){
|
$data['body'].=' '.$data['address'];
|
}
|
if($data['other']){
|
$data['body'].=' 用户留言：'.$data['other'];
|
}
|
}
|
|
|
$post=array(
|
'uid' => $data['uid'],
|
'username' => $data['username'],
|
'usertype' => $data['usertype'],
|
'name' => $gift['name'],
|
'gid' => $gift['id'],
|
'linkman' => $data['linkman'],
|
'linktel' => $data['linktel'],
|
'body' => $data['body'],
|
'integral' => $integral,
|
'num' => $num,
|
'ctime' => time()
|
);
|
$this->insert_into('change',$post);
|
|
$this->update_once('reward',array('num'=>array('+',$num),'stock'=>array('-',$num)),array("id"=>$data['id']));
|
|
$this -> addMemberLog($data['uid'], $data['usertype'],$this->config['integral_pricename']."兑换，商品ID：".$gift['id'],17,1);
|
|
require_once('admin.model.php');
|
$adminM = new admin_model($this->db,$this->def);
|
|
$adminM->sendAdminMsg(array(
|
'first'=>'有新的商品兑换需要审核，用户《'.$data['username'].'》花费'.$integral.$this->config['integral_pricename'].'兑换了'.$num.'个'.$gift['name'].'。',
|
'type'=>18
|
));
|
|
$return['msg']='兑换成功，请等待管理员审核！';
|
$return['errcode']='9';
|
if($data['utype']=='pc'){
|
$return['url']=Url('redeem',array('c'=>'show','id'=>$id));
|
}
|
if($data['utype']=='wap'){
|
$return['url']=Url('wap',array('c'=>'redeem','a'=>'show','id'=>$id));
|
}
|
}
|
return $return;
|
}
|
|
function getChangeNum($whereData, $data = array()){
|
|
if($whereData){
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this -> select_num('change',$whereData,$data['field']);
|
}
|
|
return $List;
|
|
}
|
|
function addChangeInfo($setData){
|
|
if(!empty($setData)){
|
|
$nid = $this -> insert_into('change',$setData);
|
|
}
|
|
return $nid;
|
|
}
|
|
function upChangeInfo($whereData, $data = array()){
|
|
if(!empty($whereData)){
|
|
$nid = $this -> update_once('change',$data,$whereData);
|
|
}
|
|
return $nid;
|
|
}
|
|
function delChange($whereData,$data=array())
|
{
|
$limit = "";//多个删除
|
if(!is_array($whereData['id'])){
|
$limit = 'limit 1';
|
}
|
|
/**$data['member'] :会员中心执行删除，member为user表示个人会员，com表示企业会员
|
* $data['uid'] :用户uid
|
* $data['usertype']:用户usertype
|
* $data['id'] :change表id
|
*/
|
|
if($data['member']){
|
if($data['uid']==''
|
||($data['member']=='com'&&$data['usertype']!='2')
|
||($data['member']=='user'&&$data['usertype']!='1')){
|
|
$result['msg'] = '登录超时';
|
$result['cod'] = 8;
|
}else{
|
$rows = $this -> getChangeInfo(array('uid'=>$data['uid'],'id'=>$data['id']));
|
if($rows['id']){
|
require_once('integral.model.php');
|
$IntegralM = new integral_model($this->db,$this->def);
|
|
$this -> update_once('reward',array('num'=>array('-',$rows['num']),'stock'=>array('+',$rows['num'])),array('id'=>$rows['gid']));
|
|
$IntegralM -> company_invtal($data['uid'],$data['usertype'],$rows['integral'],true,"取消商品兑换",true,2,'integral',24);
|
$this -> delete_all('change',array('uid'=>$data['uid'],'id'=>$data['id']),$limit);
|
}
|
$this -> addMemberLog($data['uid'],$data['usertype'],"取消兑换",17,3);//会员日志
|
$result['msg'] = '取消成功！';
|
$result['cod'] = 9;
|
}
|
}else{
|
$result = $this -> delete_all('change',$whereData,$limit);
|
}
|
|
return $result;
|
|
}
|
//************************end************************
|
|
|
//*********************redeem_class******************
|
//查询商品分类
|
function GetRewardClass($whereData,$data=array()){
|
$ListNew = array();
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
$List = $this -> select_all('redeem_class',$whereData,$data['field']);
|
|
if(!empty( $List )){
|
|
$ListNew['list'] = $List;
|
}
|
|
return $ListNew;
|
|
}
|
|
function getRedeemClassInfo($whereData, $data = array()){
|
|
if($whereData){
|
$data['field'] = empty($data['field']) ? '*' : $data['field'];
|
|
$List = $this -> select_once('redeem_class',$whereData,$data['field']);
|
}
|
|
return $List;
|
|
}
|
|
function addRedeemClassInfo($setData){
|
|
if(!empty($setData)){
|
|
$nid = $this -> insert_into('redeem_class',$setData);
|
|
}
|
|
return $nid;
|
|
}
|
|
function upRedeemClassInfo($whereData, $data = array()){
|
|
if(!empty($whereData)){
|
|
$nid = $this -> update_once('redeem_class',$data,$whereData);
|
|
}
|
|
return $nid;
|
|
}
|
|
|
function delRedeemClass($whereData,$data){
|
|
if($data['type']=='one'){//单个删除
|
|
$limit = 'limit 1';
|
|
}
|
|
if($data['type']=='all'){//多个删除
|
|
$limit = '';
|
|
}
|
|
$result = $this -> delete_all('redeem_class',$whereData,$limit);
|
|
return $result;
|
|
}
|
//************************end************************
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
?>
|
