gaoyixia/application/common/service/UserSynth.php

<?php
namespace app\common\service;
use AlibabaCloud\Client\AlibabaCloud;
use AlibabaCloud\Client\Exception\ClientException;
use AlibabaCloud\Client\Exception\ServerException;
use app\common\model\ActivityApplyItem;
use app\common\model\ActivitySponsor;
use app\common\model\ArticleIntro;
use app\common\model\BillApply;
use app\common\model\BillHeader;
use app\common\model\DatumIntro;
use app\common\model\DeliveryAddress;
use app\common\model\SupplierGoods;
use app\common\model\UserSearch;
use app\common\model\UserVitality;
use app\common\model\VideoIntro;
use think\cache\driver\Redis;
use think\Db;
use Dm\Request\V20151123 as Dm;
/**
 * 会员身综合管理
 * Class UserIdentity
 */
class UserSynth extends SerBase
{
    public static  $ret_val = ['code' => 200 , 'msg'=>'ok','extend'=>''];
    // 会员活跃度
    public static function vitality($user_id,$type)
    {
        if($type === false) return false;
        $type++;
        $redis = new Redis();
        $check_key = date('Y-m-d').'_'.$user_id;
        // 当天是否登录
        if(!$redis->get($check_key)) {
            $redis->set($check_key,86400);
            $year = date('Y');
            $month = date('m');
            $day = date('d');
            $vitality_info= [
                'user_id'=>$user_id,
                'year'=>$year,
                'month'=>$month,
                'day'=>$day,
                'day_time'=>date('Y-m-d'),
                'create_at'=>date('Y-m-d H:i:s'),
                'type'=>$type
            ];
            UserVitality::create($vitality_info);
        }
    }


    /**
     * 创建申请发票申请记录【申请开票】
     * @param $user_id
     * @param $order_id
     * @param $order_type 订单类型
     * @param $bill_info  发票抬头id||发票详情
     * @param $add_id     售货地址id
     * @param $send_type  物流类型1点子发票2纸质发票
     * @param $remark     备注
     * @param $order_pay  订单是否完成支付
     * @return array
     */
    public static function buildBillApply($user_id, $order_id, $order_type,$bill_info,$add_id,$send_type,$remark,$order_pay = 1)
    {
        $order_table = [
            1=>'level_order',// 会员订单
            2=>'store_order',// 商品订单
            3=>'activity_apply',// 活动订单
        ];
        Db::startTrans();
        try {
            $apply_info = [
                'order_id' => $order_id,
                'table_name' => $order_table[$order_type],
                'user_id' => $user_id,
                'remark' => $remark,
                'send_type' =>  $send_type,
                'order_type' => $order_type,
                'create_at' => date("Y-m-d H:i:s"),
                'order_pay' => $order_pay,
            ];
            if($add_id) {
                $add_info = DeliveryAddress::field('id,pro_name,city_name,county_name,mer_name,detail,phone,name')->where('user_id',$user_id)->where('id',$add_id)->find();
                $apply_info['address_info'] = json_encode($add_info->toArray());
            }

            if(is_array($bill_info)){
                $apply_info['header']  = $bill_info['header'];
                $apply_info['type']  = $bill_info['type'];
                $apply_info['email']  =$bill_info['email'];
               // $apply_info['bank']  = $bill_info['bank'];
               // $apply_info['card_no']  = $bill_info['card_no'];
               // $apply_info['phone']  = $bill_info['phone'];
                $apply_info['identify_number']  = $bill_info['identify_number'];
               // $apply_info['address']  = $bill_info['address'];
            }else if($bill_info){
                $bill_header = BillHeader::where('id',$bill_info) ->where('user_id',$user_id)->find();
                if(empty($bill_header)) self::exception('发票抬头有误');
                $apply_info['header']  = $bill_header->header;
                $apply_info['email']  = $bill_header->email;
                $apply_info['type']  = $bill_header->type;
                $apply_info['identify_number']  = $bill_header->identify_number;
            }
            $order_info = Db::name($order_table[$order_type])
                ->where('user_id',$user_id)
                ->where('pay_state',1)
                ->where('id',$order_id)
                ->find();
            if(empty($order_info) && $order_type != 3)self::exception('订单有误');

            $check_info = BillApply::where('user_id',$user_id)
                ->where('order_id',$order_id)
                ->where('is_deleted',0)
                ->where('table_name',$order_table[$order_type])
                ->find();
            if(!empty($check_info) &&  $check_info->status == 1) self::exception('已开票');
            $apply_info = BillApply::create($apply_info);
            static::$ret_val['extend'] = $apply_info->id ;
            Db::commit();
        }catch (\Exception $e) {
            Db::rollback();
            static::$ret_val['code'] = 201 ;
            static::$ret_val['msg'] = $e->getMessage();
        }
        return static::$ret_val;
    }


    // 获取所有模块设置
    public static function getAllModuleTitle()
    {
        // 视频
        $video  = VideoIntro::field('id,title,IF(id,\'video\',0) module')->with(['videoArr'=>function($query){
            return $query->field('id,title,video_id');
        }])->where(['is_deleted'=>0])->order('id desc')->select()->toArray();
        array_walk($video,function (&$v){
            $v['children'] = $v['video_arr'];
            unset($v['video_arr']);
        });
        // 资料
        $datum  = DatumIntro::with(['urlArr'=>function($query){
            return $query->field('id,title,datum_id');
        }])->where(['is_deleted'=>0])->field('id,title,IF(id,\'datum\',0) module')->order('id desc')->select()->toArray();
        array_walk($datum,function (&$v){
            $v['children'] = $v['url_arr'];
            unset($v['url_arr']);
        });
        // 图文
        $article = ArticleIntro::with(['itemChildren'=>function($query){
            return $query->field('id,title,article_id');
        }])->field('id,title,IF(id,\'article\',0) module')->where(['is_deleted'=>0])->order('id asc')->select()->toArray();
        array_walk($article,function (&$v){
            $v['children'] = $v['item_children'];
            unset($v['item_children']);
        });
        $supplier_goods =  SupplierGoods::alias('g')->field('g.id,g.supplier_id,g.name title,IF(g.id,\'supplier\',0) module')->where(['g.is_deleted'=>0])
            ->leftJoin('Supplier s', 's.id = g.supplier_id')->select()->toArray();
        return array_merge($video,$datum,$article,$supplier_goods);
       // return compact(['video','datum','article','supplier_goods']);
    }

    // 推荐
    public static function getRecommendList($user_id,$module,$page,$page_num)
    {
          $module_set = [
              'press'=>[
                  'type'=> 4,
                  'table'=>'dd_press',
                  'index_field'=>'name',
                  'select_field'=>'a.id,a.title,a.label,a.images,a.read_num,a.transmit_num,a.user_id,a.create_at,IFNULL(is_recommend,0) is_recommend',
              ]
          ];
        $search_log =  UserSearch::getSearchTitle($user_id,$module_set[$module]['type']);
        $search_arr = [];
        $where_str = 'b.id > 0';
        foreach ($search_log as $t){
            $search_arr[] =  " b.$module_set[$module][\"index_field\"] like '".'%'.$t."%'" .' ';
            $search_arr[] =  " b.label like '".'%'.$t."%'" .' ';
        }
        if(!empty($search_arr)) $where_str  =  implode(' OR ',$search_arr);
          switch ($module)
          {
              case "press":

                  break;
          }


    }


    // 短信发送
    public static function phoneMessageSend($phone,$key,$data)
    {
        $mud_arr = [];
        $mud_arr[0] = [
            'name'=> '活动举办 会前1天',//模板名称
            'tem_code'=> 'SMS_460985703',// 模板code
            'param' => [
                'ActivityName'=>isset($data['ActivityName']) ? $data['ActivityName'] : '' ,
                'time'=>isset($data['time']) ? $data['time'] : '' ,
                'adress'=>isset($data['adress']) ? $data['adress'] : '' ,
                'url'=> isset($data['url']) ? $data['url'] : '' ,
            ]
        ];
        $mud_arr[1] = [
            'name'=> '免费票有审核，审核成功',//模板名称
            'tem_code'=> 'SMS_460970747',// 模板code
            'param' => [
                'ActivityName'=>isset($data['ActivityName']) ? $data['ActivityName'] : '' ,
                'url'=> isset($data['url']) ? $data['url'] : '' ,
            ]
        ];
        $mud_arr[2] = [
            'name'=> '	后台主动修改时间地点短信短信通知',//模板名称
            'tem_code'=> 'SMS_461030378',// 模板code
            'param' => [
                'ActivityName'=>isset($data['ActivityName']) ? $data['ActivityName'] : '' ,
                'time'=>isset($data['time']) ? $data['time'] : '' ,
                'adress'=>isset($data['adress']) ? $data['adress'] : '' ,
            ]
        ];

        AlibabaCloud::accessKeyClient('LTAI5tJ5p12drZegeWVG33xZ', '82UWAiY5e5wH8tSkRvMtqVoGO0h8SB')->regionId('cn-hangzhou')->asDefaultClient();
        try {
            $result = AlibabaCloud::rpc()
                ->product('Dysmsapi')
                ->version('2017-05-25')
                ->action('SendSms')
                ->method('POST')
                ->host('dysmsapi.aliyuncs.com')
                ->options([
                    'query' => [
                        'RegionId' => "cn-hangzhou",
                        'PhoneNumbers' => $phone,
                        'SignName' => "搞一下汽车电子",
                        'TemplateCode' => $mud_arr[$key]['tem_code'],
                        'TemplateParam' => json_encode($mud_arr[$key]['param']),
                    ],
                ])->request();
            $result = $result->toArray();
            if($result['Code'] != "OK") return ['code'=>201,'msg'=>'发送失败'];
        } catch (ClientException $e) {
            return ['code'=>201,'msg'=>$e->getErrorMessage().PHP_EOL];
        } catch (ServerException $e) {
            return ['code'=>201,'msg'=>$e->getErrorMessage().PHP_EOL];
        }catch (\Exception $e){
            return ['code'=>201,'msg'=>$e->getMessage()];
        }
        return ['code'=>200,'msg'=>'发送成功'];
    }


    // 邮件推送
    public static function emailSend($email,$title)
    {
        require_once env('root_path').'vendor/aliyunmail/aliyun-php-sdk-core/Config.php';
        $iClientProfile = \DefaultProfile::getProfile("cn-hangzhou", "LTAI5tJ5p12drZegeWVG33xZ", "82UWAiY5e5wH8tSkRvMtqVoGO0h8SB");
        $client = new \DefaultAcsClient($iClientProfile);
        $request = new Dm\SingleSendMailRequest();
        $request->setAccountName("gyx@yzm.gyxqcdz.com");
        $request->setFromAlias("活动提示");
        $request->setAddressType(1);
        $request->setTagName("activity");
        $request->setReplyToAddress("true");
        $request->setToAddress($email);
        $request->setSubject("活动提示");
        $html_body = '您报名的活动'.$title.'已发生变更。';
        $request->setHtmlBody($html_body);
        $send_res = $client->getAcsResponse($request);
        return ['code'=>200,'msg'=>'发送成功'];
    }

    //门票邮件推送
    public static function ticketSend($ticket_id)
    {
        $ticket_info = ActivityApplyItem::where('id',$ticket_id)->find()->toArray();
        if(!$ticket_info['email'])['code'=>201,'msg'=>'邮件为空'];
        $email = $ticket_info['email'];
        $act_info = \app\common\model\Activity::where('id',$ticket_info['act_id'])->find()->toArray();
        $sponsor_info = ActivitySponsor::where('id',$act_info['sponsor_id'])->find();

        require_once env('root_path').'vendor/aliyunmail/aliyun-php-sdk-core/Config.php';
        $iClientProfile = \DefaultProfile::getProfile("cn-hangzhou", "LTAI5tJ5p12drZegeWVG33xZ", "82UWAiY5e5wH8tSkRvMtqVoGO0h8SB");
        $client = new \DefaultAcsClient($iClientProfile);
        $request = new Dm\SingleSendMailRequest();
        $request->setAccountName("gyx@yzm.gyxqcdz.com");
        $request->setFromAlias("活动提示");
        $request->setAddressType(1);
        $request->setTagName("activity");
        $request->setReplyToAddress("true");
        $request->setToAddress($email);
        $request->setSubject("活动提示");

        $act_title = $act_info['title'];
        $user_name =$ticket_info['name'];
        $qr_code = $ticket_info['qr_code'];
        $qr_content= $ticket_info['qr_content'];
        $server_url1= 'https://'.$_SERVER['SERVER_NAME'].'static/t1.png';
        $server_url2= 'https://'.$_SERVER['SERVER_NAME'].'static/t2.png';
        $server_url3= 'https://'.$_SERVER['SERVER_NAME'].'static/t3.png';
        $sponsor_name = $sponsor_info  ? $sponsor_info->title : '官方主办';
        $time = $act_info['start_time'].'-'.$act_info['end_time'];
        $address = $act_info['province'].$act_info['city'].$act_info['county'].$act_info['address'];
        $html_body = "<html lang=\"en\">
<head>
    <meta charset=\"UTF-8\">
    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">
    <title></title>
    <style>
        *{
            padding: 0;
            margin: 0;
        }
        .imgBox {
            text-align: center;
            position: relative;
        }

        .bottomInfo {
            background-color: #fff;

            padding: 20px 10px;

        }

        .bottomInfo .content {
            display: flex;
            align-items: center;
            line-height: 36px;

            font-size: 13px;
        }

        .bottomInfo .content img {
            width: 20px;
            height: 20px;
            margin-right: 10px;
        }

        .bottom {
            font-size: 13px;
            text-align: center;
            margin-top: 18px;
        }

        .signInfo {
            background-color: #fff;

            border-bottom: 1px dotted #222;
            padding: 20px 10px;


        }
        .signInfo .qrBox {
            display: flex;
            flex-direction: column;
            justify-content: center;
            align-items: center;





        }
        .signInfo .qrTitle {
            font-size: 16px;
            font-weight: bold;
            margin-bottom: 12px;
        }

        .signInfo .qrCode {
            width: 211px;
            height: 211px;
        }

        .signInfo .warn {
            font-size: 12px;
            color: #666666;
        }

        .signInfo .code {
            width: 151px;
            height: 40px;
            line-height: 40px;
            text-align: center;
            border-radius: 6px;
            border: 1px solid #2A63F3;
            font-size: 14px;
            color: #2A63F3;
            margin: 16px 0 16px;
        }

        .titleBox {
            margin: 10px 0;
            padding: 0 10px;

            line-height: 39px;
            background: #FFFFFF;
            border-radius: 10px;



        }
        .titleBox  .title {
            font-size: 15px;
            font-weight: bold;
        }


        .tips  img {
            width: 14px;
            height: 14px;
            margin-right: 2px;
        }
        button {
            font-size: 18px;
            color: #fff;
            font-weight: bold;
            position: fixed;
            bottom: 34px;
            left: 50%;
            transform: translateX(-50%);
            width: 351px;
            height: 48px;
            line-height: 48px;
            text-align: center;
            background: #2A63F3;
            border-radius: 24px;
        }

        .info {
            padding: 0 12px;

        }

        .wrap {
            width: 700px;
            min-height: 100vh;
            display: flex;
            flex-direction: column;
            /* padding: 44px 0 83px; */
            box-sizing: border-box;
            background-color: #f4f4f4;


        }

        /* 头部样式 */
        .header-wrap {
            width: 100%;
            height: 44px;
            display: flex;
            flex-direction: column;
            position: fixed;
            top: 0;
            left: 0;
            z-index: 500;
            background-color: #ffffff;
        }

        .header {
            width: 100%;
            height: 44px;
            display: flex;
            align-items: center;
            justify-content: center;
            background-color: #ffffff;
            z-index: 999;
            padding: 0 15px;
            position: relative;
            box-sizing: border-box;
        }

        .return-img {
            position: absolute;
            left: 15px;
            top: 50%;
            transform: translate(0, -50%);
            width: 20px;
            height: 20px;
        }

        .header-title {
            /* flex: 1; */
            display: -webkit-box;
            -webkit-line-clamp: 1;
            overflow: hidden;
            text-overflow: ellipsis;
            -webkit-box-orient: vertical;
            color: #333333;
            font-size: 18px;
            font-weight: bold;
            box-sizing: border-box;
        }

        .header-btn-box {
            display: flex;
            align-items: center;
            position: absolute;
            right: 12px;
            top: 50%;
            transform: translate(0, -50%);
        }

        .header-btn-box>button {
            margin-right: 10px;
        }

        .header-btn-box>button:last-child {
            margin-right: 0;
        }

        .header-btn-box>button>img {
            height: 24px;
        }
    </style>
</head>
<body>
        <div class=\"wrap\">
            <div class=\"info\">
                <div class=\"titleBox\">
                    <div class=\"title\">
                     $act_title
                    </div>
                    <div class=\"person\">
                        参会者：$user_name
                    </div>
                </div>
                <div class=\"signInfo\">
                    <div class=\"qrBox\">
                        <div class=\"qrTitle\">
                            签到码-用于现场签到
                        </div>
                        <div class=\"imgBox\">
                            <img class=\"qrCode\" src=\"$qr_code\" alt=\"\">
                        </div>
                        <div class=\"code\">
                            签到码：$qr_content
                        </div>
                        <div class=\"warn\">
                            仅限本人使用
                        </div>
                    </div>
                </div>
                <div>
                    <div class=\"bottomInfo\">
                        <div class=\"content\">
                            <img src=\"$server_url1\" alt=\"\">
                            $sponsor_name
                        </div>
                        <div class=\"content\">
                            <img src=\"$server_url2\" alt=\"\">
                            $time
                        </div>
                        <div class=\"content\">
                            <img src=\"$server_url3\" alt=\"\">
                            $address
                        </div>
                    </div>
                </div>
            </div>
            <div class=\"bottom\">
                此二维码用于现场签到，请携带至会场
            </div>
        </div>

</body>
</html>";

        $request->setHtmlBody($html_body);
        $send_res = $client->getAcsResponse($request);
        return ['code'=>200,'msg'=>'发送成功'];


    }






}