<?php

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Request;
use Excel;
use DB;

class PaymentDaysModel extends Model
{
    protected $connection='order';
    protected $table='lie_payment_days';
    public $timestamps = false;
    public function ApiPaymentDaysList(){
        $collert=Request::only('user_id','ac_id','status','limit','p','Export');
        $limit=!empty($collert['limit'])?$collert['limit']:10;
        $p=!empty($collert['p'])?$collert['p']:1;
        $Select=['id','auth_cause','lie_payment_days.user_id','add_time','com_name','lie_payment_days.mobile','ac_id','lie_payment_days.status','lie_user_main.mobile as usmobile','email'];
        $list=$this->where(function($query) use ($collert){
            if(!empty($collert['ac_id'])) $query->where('ac_id','=',$collert['ac_id']);
            if(!empty($collert['status'])) $query->whereIn('lie_payment_days.status',explode(',',rtrim($collert['status'],',')));
        })->join('lie_user_main',function($join) use($collert){
            if(!empty($collert['user_id'])){
                $join->on('lie_payment_days.user_id','=','lie_user_main.user_id')
                    ->where('lie_user_main.mobile','=',$collert['user_id'])->orWhere('lie_user_main.email','=',$collert['user_id']);
            }else{
                $join->on('lie_payment_days.user_id','=','lie_user_main.user_id');
            }
        })->select($Select)->paginate($limit,['*'],'p',$p)->toArray();
        if(!empty($collert['Export']) && $collert['Export']==true){
            $cellData = [
                ['ID','会员账号','公司名称','联系方式','活动ID','申请时间','申请状态','审核原因']
            ];
            $Status=[1=>'待审核',2=>'审核通过',3=>'审核不通过'];
            foreach ($list['data'] as $k=>$v){
                $v['status_name']=empty($Status[$v['status']])?'未知':$Status[$v['status']];
                $info=[$v['id'],empty($v['usmobile'])?$v['email']:$v['usmobile'],$v['com_name'],$v['mobile'],$v['ac_id'],date('Y-m-d H:i',$v['add_time']),$v['status_name'],$v['auth_cause']];
                array_push($cellData,$info);
            }
            Excel::create("账期搜索结果",function ($excel) use ($cellData){
                $excel->sheet('账期搜索结果',function ($sheet) use ($cellData) {
                    $sheet->rows($cellData);
                });
            })->export('xls');
        }
        return [0,'成功',$list['data'],$list['total'],$limit];
    }

    public function AuthPaymentDays(){
        $collert=Request::only('id');
        $Select=['lie_payment_days.id','lie_payment_days.status','lie_payment_days.com_name','lie_payment_days.user_id','lie_payment_days.mobile','add_time',
            'lie_user_main.mobile as usmobile','email','company_id','com_telphone','tax_no','bank_name','com_area_id','com_address',
            'com_city_id','com_province_id','auth_cause'];
        $info=$this->where('id','=',$collert['id'])
            ->leftJoin('lie_user_main','lie_payment_days.user_id','=','lie_user_main.user_id')
            ->leftJoin('lie_user_company','lie_user_main.company_id','=','lie_user_company.com_id')
            ->leftJoin('lie_taxinfo',function($join){
                $join->on('lie_payment_days.user_id','=','lie_taxinfo.user_id')->where('is_default','=',1);
            })
            ->select($Select)->first()->toArray();
        if(!$info) return false;
        $address=DB::connection('order')->table('lie_region')->whereIn('region_id',[$info['com_area_id'],$info['com_city_id'],$info['com_province_id']])->lists('region_name','region_id');
        $info['address']=$address;
        return $info;
    }

    public function ApiAuthPaymentDays($AdminId){
        $collert=Request::only('id','status','auth_cause');
        if(empty($collert['id']) || empty($collert['status'])) return [10002,'审核失败'];
        $result=$this->where('id','=',$collert['id'])->update(['auth_cause'=>$collert['auth_cause'],'status'=>$collert['status'],'auth_id'=>$AdminId,'update_time'=>time()]);
        if(!$result) return [10001,'审核失败'];
        return [0,'审核成功'];
    }
}