screen/application/api/controller/MobileController.php

<?php

namespace app\api\controller;

use addons\epay\library\Service;
use app\common\controller\UserApi;
use app\common\library\MobileConstant;
use app\common\model\Area;
use app\common\model\Mobile;
use app\common\model\MobileInfo;
use app\common\model\MobileOrder;
use app\common\service\SmsSend;
use think\Db;
use think\db\Query;

/**
 * 靓号管理
 */
class MobileController extends UserApi
{
    protected $noNeedLogin = "*";
    protected $noNeedRight = '*';

    /**
     * 列表
     * @ApiMethod (POST)
     * @ApiParams (name="type",description="1靓号，2流量卡,默认1")
     * @ApiParams (name="search_type",description="fuzzy模糊，precise精准")
     * @ApiParams (name="search_last",description="0,1是否搜索尾部")
     * @ApiParams (name="city_id",description="地区id")
     * @ApiParams (name="keyword",description="搜索内容,模糊就是字符串，精准就是数组")
     * @ApiParams (name="sort",description="price_asc价格从低到高,price_desc价格从高到低")
     * @ApiParams (name="network",description="网络")
     * @ApiParams (name="price_min",description="价格最低数字")
     * @ApiParams (name="price_max",description="价格最高数字")
     * @ApiParams (name="exclude_num",description="排除数字")
     * @ApiParams (name="num_max",description="数字较多，传数字")
     * @ApiParams (name="rule_position",description="规律位置,middle中间，tail尾部")
     * @ApiParams (name="rule_name",description="规律名，设计图字母变小写传过来")
     * @ApiParams (name="limit",description="limit")
     * @ApiParams (name="page",description="page")
     * @ApiReturnParams (name=id,description=id)
     * @ApiReturnParams  (name="type",description="1靓号，2流量卡")
     * @ApiReturnParams (name=logo,description=缩略图)
     * @ApiReturnParams (name=name,description=号码名称)
     * @ApiReturnParams (name=no,description=手机号)
     * @ApiReturnParams (name=type,description=1靓号2流量卡)
     * @ApiReturnParams (name=network,description=运营商)
     * @ApiReturnParams (name=city,description=城市)
     * @ApiReturnParams (name=privince,description=省份)
     * @ApiReturnParams (name=amount,description=售价)
     * @ApiReturnParams (name=amount_original,description=原价)
     * @ApiReturnParams (name=amount_exists,description=含话费)
     * @ApiReturnParams (name=amount_base,description=售价)
     * @ApiReturnParams (name=amount_charge,description=预充)
     * @ApiReturnParams (name=summary,description=简介)
     * @ApiReturnParams (name=saled,description=是否已出售)
     * @ApiReturnParams (name=status,description=0正常1已售2已下架)
     * @ApiReturnParams (name=is_activity,description=是否特价号)
     * @ApiReturnParams (name=activity_time_end,description=特价过期时间null永不过期)
     * @ApiReturnParams (name="info.free_app",description=免流APP列表)
     * @ApiReturnParams (name="info.describe",description="套餐说明|资费详情")
     * @ApiReturnParams (name="info.content",description="详细内容|注意事项")
     * @ApiReturnParams (name="info.flow_year",description="每年流量(G)")
     * @ApiReturnParams (name="info.fee",description="资费")
     * @ApiReturnParams (name="info.first_month_free",description="首月是否免月租")
     * @ApiReturnParams (name="info.discount_title",description="简要优惠介绍")
     */
    public function list(){
        $model=Mobile::show();
        $data=input();
        $this->validate($data,[
            'keyword'=>['max:11'],
            'num_max'=>['integer','between:0,9'],
            'rule_position'=>['in:middle,tail'],
        ]);
        if(empty($data['type'])){
            $data['type']=1;
        }
        $model->where('type',$data['type']);
        if(!empty($data['search_type']) && !empty($data['keyword'])){
            if($data['search_type']=='fuzzy'){
                if(isset($data['search_last']) && $data['search_last']==1){
                    $no=str_pad($data['keyword'],11,'-',STR_PAD_LEFT);
                    for ($i=1;$i<=11;$i++){
                        if(substr($no,$i-1,1)=='-'){
                            continue;
                        }
                        $model->where("filter_no_pos_{$i}",substr($no,$i-1,1));
                    }
                }else {
                    $model->where('no', 'like', "%{$data['keyword']}%");
                }
            }elseif ($data['search_type']=='precise'){
                foreach ($data['keyword'] as $k=>$v){
                    $pos=$k+1;
                    if($pos==1||is_null($v))continue;
                    $model->where("filter_no_pos_{$pos}",$v);
                }
            }
        }
        if(!empty($data['city_id'])){
            $model->where('city_id',$data['city_id']);
        }
        if(!empty($data['sort'])){
            if($data['sort']=='price_asc'){
                $model->order('amount','asc');
            }elseif($data['sort']=='price_desc'){
                $model->order('amount','desc');
            }
        }else{
            $model->order('activity_time','desc')->order('create_time','desc');
        }
        if(!empty($data['network'])){
            $network=array_column(MobileConstant::getNetwork(),'search','name');
            $model->whereIn('network',$network[$data['network']]??[0]);
        }
        if(!empty($data['price_min']) && is_numeric($data['price_min'])){
            $model->where('amount','>=',$data['price_min']);
        }
        if(!empty($data['price_max']) && is_numeric($data['price_max'])){
            $model->where('amount','>=',$data['price_max']);
        }
        if(!empty($data['exclude_num'])){
            $model->whereNotLike('no',"%{$data['exclude_num']}%");
        }
        if(!empty($data['num_max'])){
            $model->where("filter_num_{$data['num_max']}",'>',3);
        }
        $rules=MobileConstant::getFilters();
        if(!empty($data['rule_name'])){
            if (!isset($rules[$data['rule_name']])) {
                $this->error('规律规则不支持');
            }
            $rule=$rules[$data['rule_name']];
            if(!empty($data['rule_position'])) {
                $model->where($rule[$data['rule_position']], 1);
            }else{
                $model->where(function (Query $query)use ($rule){
                    $query->where($rule['middle'],1)->whereOr($rule['tail'],1);
                });
            }
        }

        $list=$model->paginate(input('limit',15));
        $this->success('',$list);
    }
    /**
     * 号码详情
     * @ApiParams (name=id,description=号码id)
     */
    public function show(){
        $data=$this->_validate([
            'id'=>['require']
        ]);
        $mobile=Mobile::where('id','id')->with(['info'])->findOrFail($data['id']);
        $this->success('',$mobile);
    }
    /**
     * 下单
     * @ApiMethod (POST)
     * @ApiParams (name=mobile_id,description=手机号ID)
     * @ApiParams (name=name,description=姓名)
     * @ApiParams (name=phone,description=手机号)
     * @ApiParams (name=sms_code,description=验证码)
     * @ApiParams (name=id_no,description=身份号码)
     * @ApiParams (name=county,description="城市ID,区县id")
     * @ApiParams (name=address,description=详细地址)
     * @ApiParams (name=remark,description=备注)
     * @ApiParams (name=pay_type,description="1微信2支付宝3京东")
     * @ApiParams (name=return_url,description="支付完成回调页面链接")
     * @ApiReturnParams (name=pay_url,description="支付链接")
     *
     */
    public function apply(){
        $data=$this->_validate([
            'mobile_id'=>'require',
            'name'=>'require',
            'phone'=>'require',
            'id_no'=>'require',
            'county'=>'require|integer',
            'address'=>'require',
            'pay_type'=>'require|in:1,2,3',
        ]);
        $mobile=Mobile::where('status',0)->findOrFail($data['mobile_id']);

        Db::startTrans();
        SmsSend::setMobile($data['phone'])->setCode($data['sms_code']??'')->setEvent('order')->check();
        $order=$data;
        $order['admin_id']=$mobile['proxy_id'];
        $order['no']=$mobile['no'];
        $order['city']=implode(',',Area::getTreeId($data['county']));
        $order['amount_original']=$mobile['amount_original'];
        $order['amount_hd']=$mobile['amount'];
        $order['amount_charge']=$mobile['amount_charge'];
        $order['amount']=$mobile['amount'];
        unset($order['county'],$order['status'],$order['sms_code']);
        $mobileOrder=(new MobileOrder);
        $mobileOrder->allowField(true)->save($order);
        $succ=[
            'pay_url'=>'',
        ];
        if($data['pay_type']==1){
            $info=Service::submitOrder($mobileOrder['amount'],
                $mobileOrder['order_no'],'wechat',"购买手机号{$mobileOrder['no']}",
                Service::notifyUrl('wechat',$mobileOrder['no']),$data['return_url']??'','wap');
            $succ['pay_url']=$info->getTargetUrl();
        }elseif ($data['pay_type']==2){
            $info=Service::submitOrder($mobileOrder['amount'],
                $mobileOrder['order_no'],'alipay',"购买手机号{$mobileOrder['no']}",
                Service::notifyUrl('alipay',$mobileOrder['no']),$data['return_url']??'','wap');
            $succ['pay_url']=$info->getTargetUrl();
        }elseif ($data['pay_type']==3){
        }
        Db::commit();
        $this->success('',$succ);
    }

    /**
     * 订单详情
     * @ApiParams (name=id,description=订单id)
     * @ApiReturnParams (name=no,description=手机号)
     * @ApiReturnParams (name=order_no,description=订单号)
     * @ApiReturnParams (name=amount_hd,description=活动价)
     * @ApiReturnParams (name=amount_original,description=原价)
     * @ApiReturnParams (name=amount_charge,description=预充)
     * @ApiReturnParams (name=describe,description=套餐说明)
     * @ApiReturnParams (name=proxy.wx_qr,description=客服二维码)
     * @ApiReturnParams (name=name,description=收货人)
     * @ApiReturnParams (name=address,description=收货地址)
     * @ApiReturnParams (name=remark,description=备注)
     * @ApiReturnParams (name=create_time,description=下单时间)
     * @ApiReturnParams (name=amount,description=订单金额)
     * @ApiReturnParams (name=trans_name,description=快递名称)
     * @ApiReturnParams (name=trans_no,description=快递单号)
     * @ApiReturnParams (name=status,description="0=>'待付款',10=>'待发货',20=>'待收货',30=>'退款待处理',40=>'已退款',50=>'已关闭',")
     */
    public function order_detail(){
        $order=MobileOrder::with(['proxy'])->findOrFail(input('id'));
        $order['admin']->hidden(['password']);
        $order['describe']=MobileInfo::where('mobile_id',$order['mobile_id'])->value('describe','');
        $this->success('',$order);
    }

    /**
     * 订单列表
     * @ApiParams (name=page,description=page)
     * @ApiParams (name=limit,description=limit)
     * @ApiParams (name=phone,description=手机号)
     */
    public function order_list(){
        $data=$this->_validate([
            'phone|参数'=>['require'],
        ]);
        $order=MobileOrder::with('proxy')->where('phone',$data['phone'])->order('id','desc')->paginate(input('limit',15));

        $this->success('',$order);
    }
    /**
     * 筛选配置
     *
     */
    public function config(){
        $config=[];
        $networks=array_column(MobileConstant::getNetwork(),'name');
        $config['network']=$networks;
        $config['rule']=[
            'AAA',
            'AAAA',
            'AAAAA',
            '6A',
            '7A',
            '8A',
            'ABC',
            'ABCD',
            'ABCDE',
            'ABCDEF',
            'AAAB',
            'AAAAB',
            'AAAAAB',
        ];

        $this->success('',$config);
    }
}