hlm_pl_mall/app/common/model/Smslog.php

<?php

namespace app\common\model;


use think\facade\Db;

/**
 
 * 
 
 * 
 * ----------------------------------------------------------------------------
 * 
 
 * 数据层模型
 */
class Smslog extends BaseModel
{

    public $page_info;

    /**
     * 发送验证码
     * @author csdeshang
     * @param type $smslog_phone 手机号
     * @param type $smslog_param 短信参数
     * @param type $smslog_type 类型
     * @param type $smslog_captcha 验证码
     * @param type $member_id 会员ID
     * @param type $member_name 会员名
     * @param type $if_queue 是否放入队列
     * @return type
     */
    function sendSms($smslog_phone, $smslog_param, $smslog_type = '', $smslog_captcha = '', $member_id = '0', $member_name = '', $if_queue = false)
    {
        $smslog_msg = $smslog_param['message'];
        //通过手机号判断是否允许发送短信
        $begin_add_time = strtotime(date('Y-m-d', TIMESTAMP));
        $end_add_time = strtotime(date('Y-m-d', TIMESTAMP)) + 24 * 3600;

        //同一IP 每天只能发送20条短信
        $condition = array();
        $condition[] = array('smslog_ip', '=', request()->ip());
        $condition[] = array('smslog_smstime', 'between', array($begin_add_time, $end_add_time));
        if ($smslog_captcha && $this->getSmsCount($condition) > 20) {
            return array('state' => FALSE, 'code' => 10001, 'message' => '同一IP地址一天内只能发送20条短信，请勿多次获取动态码！');
        }

        //同一手机号,60秒才能提交发送一次
        $condition = array();
        $condition[] = array('smslog_phone', '=', $smslog_phone);
        $condition[] = array('smslog_smstime', 'between', array(TIMESTAMP - 30, TIMESTAMP));
        if ($smslog_captcha && $this->getSmsCount($condition) > 0) {
            return array('state' => FALSE, 'code' => 10001, 'message' => '同一手机30秒后才能再次发送短信，请勿多次获取动态码！');
        }

        //同一手机号,每天只能发送5条短信
        $condition = array();
        $condition[] = array('smslog_phone', '=', $smslog_phone);
        $condition[] = array('smslog_smstime', 'between', array($begin_add_time, $end_add_time));
        if ($smslog_captcha && $this->getSmsCount($condition) > 5) {
            return array('state' => FALSE, 'code' => 10001, 'message' => '同一手机一天内只能发送5条短信，请勿多次获取动态码！');
        }

        // 相同的短信内容，一天不能发送3次
        $condition = array();
        $condition[] = array('smslog_msg', '=', $smslog_msg);
        $condition[] = array('smslog_smstime', 'between', array($begin_add_time, $end_add_time));
        if ($this->getSmsCount($condition) > 3) {
            return array('state' => FALSE, 'code' => 10001, 'message' => '相同的短信内容，一天不能发送3次！');
        }

        //通过手机号获取现绑定的客户信息
        if (empty($member_id) || empty($member_name)) {
            //通过手机号查询用户名
            $member = model('member')->getMemberInfo(array('member_mobile' => $smslog_phone));
            $member_id = isset($member['member_id']) ? $member['member_id'] : '0';
            $member_name = isset($member['member_name']) ? $member['member_name'] : '';
        }
        $smslog_state = 0;
        if (!$if_queue) {
            $sms = new \sendmsg\Sms();
            $send_result = $sms->send($smslog_phone, $smslog_param);
            if ($send_result['code'] == true) {
                $smslog_state = 1;
            } else {
                return array('state' => FALSE, 'code' => 10001, 'message' => $send_result['msg']);
            }
        } else {
            $smslog_msg = json_encode($smslog_param);
        }
        $log['smslog_phone'] = $smslog_phone;
        $log['smslog_captcha'] = $smslog_captcha;
        $log['smslog_ip'] = request()->ip();
        $log['smslog_msg'] = $smslog_msg;
        $log['smslog_type'] = $smslog_type;
        $log['smslog_smstime'] = TIMESTAMP;
        $log['member_id'] = $member_id;
        $log['member_name'] = $member_name;
        $log['smslog_state'] = $smslog_state;
        $result = $this->addSms($log);
        if ($result >= 0) {
            return array('state' => TRUE, 'code' => 10000, 'message' => '');
        } else {
            return array('state' => FALSE, 'code' => 10001, 'message' => '手机短信发送失败');
        }
    }

    /**
     * 修改短信记录
     * @access public
     * @author csdeshang
     * @param type $log_array 日志数组
     * @return type
     */
    public function editSms($update, $condition)
    {
        return Db::name('smslog')->where($condition)->update($update);
    }

    /**
     * 增加短信记录
     * @access public
     * @author csdeshang
     * @param type $log_array 日志数组
     * @return type
     */
    public function addSms($log_array)
    {
        $log_id = Db::name('smslog')->insertGetId($log_array);
        return $log_id;
    }

    /**
     * 查询单条记录
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @return boolean
     */
    public function getSmsInfo($condition)
    {
        if (empty($condition)) {
            return false;
        }
        $result = Db::name('smslog')->where($condition)->order('smslog_id desc')->find();
        return $result;
    }

    /**
     * 查询记录
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @param type $pagesize 分页
     * @param type $limit 限制
     * @param type $order 排序
     * @return type
     */
    public function getSmsList($condition = array(), $pagesize = '', $limit = 0, $order = 'smslog_id desc')
    {
        if ($pagesize) {
            $result = Db::name('smslog')->where($condition)->order($order)->paginate(['list_rows' => $pagesize, 'query' => request()->param()], false);
            $this->page_info = $result;
            $result = $result->items();
        } else {
            $result = Db::name('smslog')->where($condition)->limit($limit)->order($order)->select()->toArray();
        }

        return $result;
    }

    /**
     * 获取数据条数
     * @access public
     * @author csdeshang
     * @param type $condition 条件
     * @return type
     */
    public function getSmsCount($condition)
    {
        return Db::name('smslog')->where($condition)->count();
    }

    /**
     * 删除短信记录
     */
    public function delSmsLog($condition)
    {
        return Db::name('smslog')->where($condition)->delete();
    }
}