\application\member\modelspoint

<?php

namespace application\member\models;

use ticky\traits\call;

/**
 * 会员积分处理类
 */
class point {

    use call;

    //类型
    public $pay_type = array(
        0 => '每日登陆',
        1 => '评论奖励',
        2 => '投稿奖励',
        3 => '会员充值',
        4 => '后台充值',
        5 => '积分兑换',
        6 => '积分购买',
        7 => '阅读收费',
        8 => '下载收费',
        9 => '发表帖子',
        10 => '每日签到',
        11 => '其他'
    );

    /**
     * 添加积分/金钱记录
     * @param integer $type           添加类型 1积分,2金钱
     * @param integer $value          增加金额
     * @param integer $pay_type       类型代号
     * @param integer $userid         用户ID
     * @param integer $experience     当前经验
     * @param string $username        用户名
     * @param string $remarks         说明
     * @param string $adminnote     操作人用户名
     * @param string $mod_experience  是否修改经验【后台操作无需修改经验】
     */
    public function point_add($type, $value, $pay_type, $userid, $username, $experience = 0, $remarks = '', $adminnote = '', $mod_experience = true) {
        $data = array();
        $data['trade_sn'] = create_tradenum();
        $data['money'] = $value;
        $data['userid'] = $userid;
        $data['username'] = $username;
        $data['type'] = $type;
        $data['msg'] = $this->pay_type[$pay_type];
        $data['remarks'] = $remarks;
        $data['creat_time'] = NOW_TIME;
        $data['ip'] = getip();
        $data['adminnote'] = $adminnote;
        if ($type == 1)
            $data['status'] = 1;

        //自增积分/金钱或经验
        $update = $type == '1' ? '`point`=`point`+' . $value : '`amount`=`amount`+' . $value;

        //若有修改经验
        if ($mod_experience) {
            //增加经验数量
            $update .= ',`experience`=`experience`+' . $value;

            if (!$experience)
                $experience = db('member')->field('experience')->where(array('uid' => $userid))->one();
            //检查并更新会员组
            $this->_check_update_group($value, $experience, $userid);
        }

        db('member')->where(array('uid' => $userid))->update($update);
        db('pay')->add($data);
    }

    /**
     * 消费积分/金钱记录
     * @param integer $type           扣除类型 1积分,2金钱
     * @param integer $value          扣除金额
     * @param integer $pay_type       类型代号
     * @param integer $userid         用户ID
     * @param string $username        用户名
     * @param string $remarks         说明
     */
    public function point_spend($type, $value, $pay_type, $userid = '', $username = '', $remarks = '') {
        $data = array();
        $data['trade_sn'] = create_tradenum();
        $data['money'] = $value;
        $data['userid'] = $userid;
        $data['username'] = $username;
        $data['type'] = $type;
        $data['msg'] = $this->pay_type[$pay_type];
        $data['remarks'] = $remarks;
        $data['creat_time'] = NOW_TIME;
        $data['ip'] = getip();

        $update = $type == '1' ? '`point`=`point`-' . $value : '`amount`=`amount`-' . $value;

        db('member')->where(array('uid' => $userid))->update($update);  //自减积分/金钱，不减经验
        db('pay_spend')->add($data);
    }

    /**
     * 根据用户经验检查并更新用户组
     * @param integer $add           自增数量
     * @param integer $experience    当前经验
     * @param integer $userid        用户ID
     */
    protected function _check_update_group($add = 0, $experience, $userid) {
        $new_groupid = 1;
        $groupid = intval(cookie('_groupid'));

        $data = get_groupinfo();
        if (!$data)
            return false;
        $exp = $experience + $add;
        foreach ($data as $k => $v) {
            $experience_list[$k] = $v['experience'];
        }
        arsort($experience_list);

        //如果超出用户组积分设置则为积分最高的用户组
        if ($exp > max($experience_list)) {
            $new_groupid = key($experience_list);
        } else {
            foreach ($experience_list as $k => $v) {
                if ($exp >= $v) {
                    $new_groupid = $tmp_k;
                    break;
                }
                $tmp_k = $k;
            }
        }

        if ($new_groupid != $groupid) {
            cookie('_groupid', $new_groupid);
            db('member')->where(array('uid' => $userid))->update(array('groupid' => $new_groupid));
        }
    }

}