seafood/app/Http/Controllers/Admin/CustReportCo...

<?php
/**
 * Created by Sublime.
 * User: hao
 * Date: 19/08/30
 * Time: 上午11:20
 */
namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Logs;
use App\CustTotal;
use App\CustDetail;
use App\AdCost;
use App\Oplog;
use App\Order;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

use PHPExcel_Reader_Excel2007;
use PHPExcel_Reader_Excel5;
use PHPExcel_Reader_CSV;

class custReportController extends Controller
{
	public function totalindex(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $team_id = (int)$request->input('team_id');
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $count = CustTotal::where(function($query) use($team_id, $stime, $etime){
            if($team_id) $query->where('team_id', $team_id);
            if($stime) $query->where('dtime', '>=', $stime);
            if($etime) $query->where('dtime', '<=', $etime);
        })->where('is_del',0)->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = CustTotal::where(function($query) use($team_id, $stime, $etime){
            if($team_id) $query->where('team_id', $team_id);
            if($stime) $query->where('dtime', '>=', $stime);
            if($etime) $query->where('dtime', '<=', $etime);
        })->where('is_del',0)->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);

        foreach($result as $k=>&$v){
            if($v['team_id']>0){
                $team = DB::table('teams')->select('name')->where('id', $v['team_id'])->first();
                $v['team_name'] = isset($team->name) ? $team->name : '';
            }else{
                $v['team_name'] = '';
            }
        }

        $teamList = DB::table('teams')->select('id', 'name')->get();
        $teamList = json_decode(json_encode($teamList), true);
        return view('custreport/totallist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,          
            'teamlist'          =>$teamList,          
            'stime'             =>$stime,
            'etime'             =>$etime,
            'team_id'           =>$team_id,
            ]);
    }

    /**
     * 添加订单
     * @return \Illuminate\View\View
     */
    public function totalcreate(Request $request)
    {
        $teamList = DB::table('teams')->select('id', 'name')->get();
        $teamList = json_decode(json_encode($teamList), true);
        return view('custreport/totalcreate',['teamlist'=>$teamList]);
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function totalstore(Request $request)
    {       
        $team_id = (int)$request->input('team_id');
        $this->validate($request, [
            'total_cost'           => 'required', 
            'total_fan_add'           => 'required',   
            'team_id'           => 'required',   
            'dtime'           => 'required|unique:cust_day_total,dtime,1,is_del,team_id,'.$team_id,   
        ], [                  
            'total_cost.required'           => '总成本不能为空',                   
            'total_fan_add.required'           => '总加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空',
            'team_id.required'           => '团队不能为空',
            'dtime.unique'           => '指定日期已经添加过',                                    
        ]);
        //数据库-新增数据
        $custreport = array();
       
        $custreport['total_cost'] = $request->input('total_cost'); 
        $custreport['total_fan_add'] = $request->input('total_fan_add'); 
        $custreport['dtime'] = $request->input('dtime'); 
        $custreport['team_id'] = $team_id; 
                
        $res = DB::table('cust_day_total')->insertGetId($custreport); 
        if($res){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');
            $context = "运营上报投放数据";
            $type = 0; 
            $tables = 'cust_day_total';
            $data_id = $res;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
        }           
        return redirect('/admin/custreport/totalindex')->with('info', '添加成功'); 
       
    }

    /**
     * 分组管理-编辑分组界面
     * @param $id
     * @return \Illuminate\View\View
     */
    public function totaledit($id,Request $request)
    {
        
        $data = CustTotal::where('id', $id)->first();
        $teamList = DB::table('teams')->select('id', 'name')->get();
        $teamList = json_decode(json_encode($teamList), true);
        return view('custreport/totaledit', [       
            'custreport' => $data,
            'teamlist' => $teamList,
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function totalupdate(Request $request)
    {    
        $team_id = (int)$request->input('team_id');
        $id = (int)$request->input('id');        
        $this->validate($request, [
            'id'                  => 'required',
            'total_cost'          => 'required', 
            'total_fan_add'       => 'required',   
            'team_id'             => 'required',   
            'dtime'               => 'required|unique:cust_day_total,dtime,'.$id.',id,team_id,'.$team_id,   
        ], [                  
            'id.required'              => 'id不能为空',                   
            'total_cost.required'      => '总成本不能为空',                   
            'total_fan_add.required'   => '总加粉数不能为空',                                    
            'team_id.required'           => '团队不能为空',
            'dtime.required'           => '日期不能为空',
            'dtime.unique'           => '指定日期已存在',                                    
        ]);
       
        $custreport = array();
        $custreport['total_cost'] = $request->input('total_cost'); 
        $custreport['total_fan_add'] = $request->input('total_fan_add'); 
        $custreport['dtime'] = $request->input('dtime'); 
        $custreport['team_id'] = $team_id; 

        $res = DB::table('cust_day_total')->where('id', $id)->update($custreport);
        if($res){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "修改运营上报数据";
            $type = 0; 
            $tables = 'cust_day_total';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
        }        
        return redirect('/admin/custreport/totalindex')->with('info', '更新成功');         
    }

    /**
     * 分组管理-进行删除操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function totaldelete($id)
    {
        $custreport = CustTotal::find($id);
        $custreport->is_del = 1;
        if ($custreport ->save()){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "删除运营上报数据";
            $type = 0; 
            $tables = 'cust_day_total';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            return redirect('/admin/custreport/totalindex')->with('info', '删除成功');
        }
    }

    public function total_export(Request $request){
        
        $self_role = session('role_name');
        if($self_role == '超级管理员' || $self_role == '团队主管'  || $self_role == '售后管理员'){
            $admin_id = $request->input('admin_id');
        }else{
            $admin_id = session('admin_id');
        }
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $result = custreport::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id',  $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->where('is_del',0)->custreportBy('id', 'desc')->get();
        $result = json_decode(json_encode($result),true);


        $filename="订单数据.xls";
        header("Content-type:application/vnd.ms-excel");
        Header("Accept-Ranges:bytes");
        Header("Content-Disposition:attachment;filename=".$filename); //$filename导出的文件名
        header("Pragma: no-cache");
        header("Expires: 0");

    $data_str = '<html xmlns:o="urn:schemas-microsoft-com:office:office"
            xmlns:x="urn:schemas-microsoft-com:office:excel"
            xmlns="http://www.w3.org/TR/REC-html40">
            <head>
            <meta http-equiv="expires" content="Mon, 06 Jan 1999 00:00:01 GMT">
            <meta http-equiv=Content-Type content="text/html; charset=gb2312">
            <!--[if gte mso 9]><xml>
            <x:ExcelWorkbook>
            <x:ExcelWorksheets>
            <x:ExcelWorksheet>
            <x:Name></x:Name>
            <x:WorksheetOptions>
            <x:DisplayGridlines/>
            </x:WorksheetOptions>
            </x:ExcelWorksheet>
            </x:ExcelWorksheets>
            </x:ExcelWorkbook>
            </xml><![endif]-->
            </head>';

    $data_str .= "
            <table>
            <tr>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售微信号")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售团队")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单时间")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","加粉时间")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","是否复购")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单金额")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单商品")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","是否退补单")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送地址")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送姓名")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送电话")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","供应商成本")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","顺丰单号")."</th>                

            </tr>";
            foreach ($result as $k => $v)
            {
                #销售
                $admin = DB::table('admin')->where('id', $v['admin_id'])->first();
                $v['wx_id'] = isset($admin->wx_id) ? $admin->wx_id : '';
                #team
                $team = DB::table('teams')->where('id', $v['team_id'])->first();
                $v['team_name'] = isset($team->name) ? $team->name : '';
                #加粉时间
                $customr = DB::table('customers')->where('phone', $v['receiverMobile'])->first();
                $v['fanTime'] = isset($customr->fanTime) ? $customr->fanTime : '';

                $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);

                $fugou = $v['is_fugou']==1? '是' : '否';
                $is_refund = $v['is_refund']==1? '是' : '否';
                $address = $v['receiverState'].$v['receiverCity'].$v['receiverDistrict'].$v['receiverAddress'];
                $data_str .= "<tr>";
                $data_str .= "<td>".$v['wx_id']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["team_name"])."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["admin_name"])."</td>";
                $data_str .= "<td>".$v['createTime']."</td>";
                $data_str .= "<td>".$v['fanTime']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $fugou)."</td>";
                $data_str .= "<td>".$v['receivedAmount']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["goods_note"])."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $is_refund)."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $address)."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["receiverName"])."</td>";
                $data_str .= "<td>".$v['receiverMobile']."</td>";
                $data_str .= "<td>".$v['cost']."</td>";
                $data_str .= "<td style='vnd.ms-excel.numberformat:@'>".$v["logistics_id"]."</td>";
                $data_str .= "</tr>";
            }

        $data_str .= "</table>";
        echo $data_str;
        exit;       
    }

    public function detailindex(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $team_id = (int)$request->input('team_id');
        $admin_id = (int)$request->input('admin_id');

        $search_admin = 1;
        #只能看自己团队的
        $self_role = session('role_name');
        if($self_role != '超级管理员' && $self_role != '售后管理员'){
            $self_id = session('admin_id');
            $team_id = DB::table('admin')->where('id', $self_id)->pluck('team_id');                  
        }

        if($admin_id>0 && !$team_id){
            $team_id = DB::table('admin')->where('id', $admin_id)->pluck('team_id');
        }

        if($self_role == '销售'){
            $search_admin = 0;
            $admin_id = $self_id;
        }

        //假如有团队筛选，检索销售队员
        $sale_ids = null;
        if($team_id>0 && !$admin_id){
            $sale_ids = DB::table('admin')->where('team_id', $team_id)->lists('id');
        }
        

        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $count = CustDetail::where(function($query) use($admin_id, $stime, $etime, $sale_ids){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('dtime', '>=', $stime);
            if($etime) $query->where('dtime', '<=', $etime);
            if($sale_ids !== null) $query->whereIn('admin_id', $sale_ids);
        })->where('is_del',0)->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = CustDetail::where(function($query) use($admin_id, $stime, $etime, $sale_ids){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('dtime', '>=', $stime);
            if($etime) $query->where('dtime', '<=', $etime);
            if($sale_ids !== null) $query->whereIn('admin_id', $sale_ids);
        })->where('is_del',0)->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);

        $teamList = DB::table('teams')->select('id', 'name')->where(function($query) use($self_role, $team_id){
            if($team_id>0 && $self_role != '超级管理员' && $self_role != '售后管理员') $query->where('id', $team_id);
        })->get();
        $teamList = json_decode(json_encode($teamList), true);
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->where(function($query) use($self_role, $team_id){
            if($team_id>0 && $self_role != '超级管理员' && $self_role != '售后管理员') $query->where('team_id', $team_id);
        })->get();
        $adminList = json_decode(json_encode($adminList), true);

        //未上报数据销售
        $noReportSaler = $this->noReportSaler();
        $no_height = '100';
        if($no_num = count($noReportSaler)) $no_height += round($no_num * 37);
        return view('custreport/detaillist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,          
            'stime'             =>$stime,
            'etime'             =>$etime,
            'admin_id'          =>$admin_id,
            'team_id'          =>$team_id,
            'search_admin'      =>$search_admin,
            'adminlist'         =>$adminList,
            'teamlist'         =>$teamList,
            'noReportSaler'         =>$noReportSaler,
            'no_height'         =>$no_height,
            ]);
    }

    /**
     * 添加订单
     * @return \Illuminate\View\View
     */
    public function detailcreate(Request $request)
    {
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        $teamList = DB::table('teams')->select('id', 'name')->get();
        $teamList = json_decode(json_encode($teamList), true);
        $self_role = session('role_name');
        return view('custreport/detailcreate',['adminlist'=>$adminList, 'teamlist'=>$teamList, 'self_role'=>$self_role]);
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function detailstore(Request $request)
    {       
        $admin_id = (int)$request->input('admin_id');
        if(!$admin_id){
            $admin_id = session('admin_id');
        }
        $this->validate($request, [
            'old_consult'           => 'required', 
            'new_consult'           => 'required', 
            'fan_add'           => 'required',   
            'dtime'           => 'required|unique:cust_day_detail,dtime,1,is_del,admin_id,'.$admin_id,   
        ], [                  
            'old_consult.required'           => '老粉咨询不能为空',                   
            'new_consult.required'           => '新粉咨询数不能为空',                                    
            'fan_add.required'           => '加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空',                                    
            'dtime.unique'           => '指定日期已经添加过',                                    
        ]);
        //数据库-新增数据
        $custreport = array();
       
        $custreport['old_consult'] = $request->input('old_consult'); 
        $custreport['new_consult'] = $request->input('new_consult'); 
        $custreport['fan_add'] = $request->input('fan_add'); 
        $custreport['new_reply'] = $request->input('new_reply'); 
        $custreport['dtime'] = $request->input('dtime'); 
   
        if($admin_id>0){
            $admin_info = DB::table('admin')->select('realname', 'team_id')->where('id', $admin_id)->first();
            $custreport['admin_id'] = $admin_id;
            $custreport['admin_name'] = $admin_info->realname;
        }else{
            $custreport['admin_id'] = session('admin_id'); 
            $custreport['admin_name'] = session('real_name'); 
        }  
        $custreport['reporter_id'] = session('admin_id');
        $res = DB::table('cust_day_detail')->insertGetId($custreport);   
        if($res){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');
            $context = "销售上报加粉数据";
            $type = 0; 
            $tables = 'cust_day_detail';
            $data_id = $res;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
        }           
        return redirect('/admin/custreport/detailindex')->with('info', '添加成功'); 
       
    }

    /**
     * 分组管理-编辑分组界面
     * @param $id
     * @return \Illuminate\View\View
     */
    public function detailedit($id,Request $request)
    {
        
        $data = CustDetail::where('id', $id)->first();
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        $teamList = DB::table('teams')->select('id', 'name')->get();
        $teamList = json_decode(json_encode($teamList), true);
        $self_role = session('role_name');
        return view('custreport/detailedit', [       
            'custreport' => $data,
            'adminlist'  => $adminList,
            'teamlist'  => $teamList,
            'self_role'  => $self_role,
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function detailupdate(Request $request)
    {            
        $id = (int)$request->input('id');
        $admin_id = (int)$request->input('admin_id');
        if(!$admin_id){
            $admin_id = session('admin_id');
        }
        $this->validate($request, [
            'id'           => 'required', 
            'old_consult'           => 'required', 
            'new_consult'           => 'required', 
            'fan_add'           => 'required',   
            'dtime'           => 'required|unique:cust_day_detail,dtime,'.$id.',id,admin_id,'.$admin_id,   
        ], [                  
            'id.required'           => 'id不能为空',                   
            'old_consult.required'           => '老粉咨询不能为空',                   
            'new_consult.required'           => '新粉咨询数不能为空',                                    
            'fan_add.required'           => '加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空', 
            'dtime.unique'           => '指定日期已经存在',                                   
        ]);
        //数据库-新增数据
        $custreport = array();       
        $custreport['old_consult'] = $request->input('old_consult'); 
        $custreport['new_consult'] = $request->input('new_consult'); 
        $custreport['fan_add'] = $request->input('fan_add'); 
        $custreport['new_reply'] = $request->input('new_reply'); 
        $custreport['dtime'] = $request->input('dtime'); 

        $admin_id = (int)$request->input('admin_id');   
        if($admin_id>0){
            $admin_info = DB::table('admin')->select('realname', 'team_id')->where('id', $admin_id)->first();
            $custreport['admin_id'] = $admin_id;
            $custreport['admin_name'] = $admin_info->realname;
        } 

        $res = DB::table('cust_day_detail')->where('id', $id)->update($custreport);    
        if($res){
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "修改销售上报数据";
            $type = 0; 
            $tables = 'cust_day_detail';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
        }      
        return redirect('/admin/custreport/detailindex')->with('info', '更新成功');         
    }

    /**
     * 分组管理-进行删除操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function detaildelete($id)
    {
        $custreport = CustDetail::find($id);
        $custreport->is_del = 1;
        if ($custreport ->save()){
            
            #记录操作日志
            $self_id = session('admin_id');
            $self_name = session('real_name');            
            $context = "删除销售上报数据";
            $type = 0; 
            $tables = 'cust_day_detail';
            $data_id = $id;
            Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            
            return redirect('/admin/custreport/detailindex')->with('info', '删除成功');
        }
    }

    public function detail_export(Request $request){       
       
        $team_id = (int)$request->input('team_id');
        $admin_id = (int)$request->input('admin_id');
        $search_admin = 1;
        #只能看自己团队的
        $self_role = session('role_name');
        if($self_role != '超级管理员' && $self_role != '售后管理员'){
            $self_id = session('admin_id');
            $team_id = DB::table('admin')->where('id', $self_id)->pluck('team_id');                  
        }

        if($admin_id>0 && !$team_id){
            $team_id = DB::table('admin')->where('id', $admin_id)->pluck('team_id');
        }

        if($self_role == '销售'){
            $search_admin = 0;
            $admin_id = $self_id;
        }

        //假如有团队筛选，检索销售队员
        $sale_ids = null;
        if($team_id>0 && !$admin_id){
            $sale_ids = DB::table('admin')->where('team_id', $team_id)->lists('id');
        }

        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $result = CustDetail::where(function($query) use($admin_id, $stime, $etime, $sale_ids){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('dtime', '>=', $stime);
            if($etime) $query->where('dtime', '<=', $etime);
            if($sale_ids !== null) $query->whereIn('admin_id', $sale_ids);
        })->where('is_del',0)->orderBy('id', 'desc')->get();
        $result = json_decode(json_encode($result),true);  

        $indexKey = ['dtime','fan_add','new_reply','old_consult','new_consult','admin_name'];
        $title = ['日期', '加粉数', '新粉回复数', '老粉询价数', '新粉询价数','所属销售'];
        
        $filename = 'xiaoshoushangbao_'.date('Y-m-d_H').'.xlsx';
        return Order::export_excel($result, $filename, $indexKey, $title);        
    }

    /**
     * 地域投入数据
     */
    public function disCostList(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $count = AdCost::where(function($query) use($stime, $etime){
            if($stime) $query->where('ad_time', '>=', $stime);
            if($etime) $query->where('ad_time', '<=', $etime);
        })->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = AdCost::where(function($query) use($stime, $etime){
            if($stime) $query->where('ad_time', '>=', $stime);
            if($etime) $query->where('ad_time', '<=', $etime);
        })->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);

        $today = date('Y-m-d');
        return view('custreport/discostlist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,                           
            'stime'             =>$stime,
            'etime'             =>$etime,
            'today'             =>$today,
            ]);
    }

    /**
     * excel导入每日地域投入信息
     * @param Request $request
     */
    public function importDisCost(Request $request) {
        $wexin_appid = trim($request->input('wexin_appid'));
        $ad_time = $request->input('ad_time');

        $excelFile = $request->file('dataFile');
        //实例化Excel读取类
        $objReader = new PHPExcel_Reader_Excel2007();

        if(!$objReader->canRead($excelFile)){
            $objReader = new PHPExcel_Reader_Excel5();
            if(!$objReader->canRead($excelFile)){
                $objReader = new PHPExcel_Reader_CSV();
                $objReader->setInputEncoding('UTF-8');
                $objReader->setDelimiter(',');
                if(!$objReader->canRead($excelFile)){
                    echo "\n".'无法识别的Excel文件！';
                    return false;
                }
            }
        }
        $objPHPExcel=$objReader->load($excelFile);
        $worksheet=$objPHPExcel->getSheet(0);//获取第一个工作表
        $highestRow=$worksheet->getHighestRow();//取得总行数
        $highestColumn=$worksheet->getHighestColumn(); //取得总列数

        $lines = $highestRow - 1;
        if ($lines <= 0) {
            //'Excel表格中没有数据';
            return false;
        }

        $errorArr=[];
        $okStr = '';
        for ($row = 2; $row <= $highestRow; ++$row) {
            $params  = array(); 
            $params['wexin_appid'] = $wexin_appid;
            $params['ad_time'] = $ad_time;
            $params['city'] = trim($worksheet->getCellByColumnAndRow(0, $row)->getValue());
            $params['cost'] = trim($worksheet->getCellByColumnAndRow(1, $row)->getValue());
            $params['exposure_times'] = intval($worksheet->getCellByColumnAndRow(2, $row)->getValue());
            $params['click_times'] = intval($worksheet->getCellByColumnAndRow(3, $row)->getValue());
            $params['click_rate'] = trim($worksheet->getCellByColumnAndRow(4, $row)->getValue());
            $params['conversion_times'] = intval($worksheet->getCellByColumnAndRow(5, $row)->getValue());
            $params['conversion_cost'] = trim($worksheet->getCellByColumnAndRow(6, $row)->getValue());

            //判断是否已存在
            $if_data = AdCost::where('wexin_appid', $params['wexin_appid'])->where('ad_time', $params['ad_time'])->where('city', $params['city'])->first();
            if(isset($if_data->id)){
                $result = AdCost::where('id', $if_data->id)->update($params);
            }else{
                $result = AdCost::insert($params);
            }
        }

        return redirect('admin/custreport/disCostList')->with('info','导入成功');       

    }

    /**
     * 未上报数据销售
     */
    public function noReportSaler(){
        $today = date('Y-m-d');
        //销售列表
        $ids = DB::table('admin_role')->where('user_id','!=',3)->where('role_name', '销售')->lists('user_id');
        $ids = DB::table('admin')->whereIn('id', $ids)->where('is_use', 1)->lists('id');
        //销售名字
        $salers = DB::table('admin')->whereIn('id', $ids)->lists('realname', 'id');
 
        //查每日上报数据销售
        $result = DB::table('cust_day_detail')->select('admin_id', 'dtime')->where('dtime','<',$today)->where('dtime','>=','2019-09-04')->where('is_del', 0)->orderBy('dtime', 'desc')->get();
        $result = json_decode(json_encode($result), true);

        $data = array();
        foreach($result as $k=>$v){
            $data[$v['dtime']][] = $v['admin_id'];
        }

        $ret = array();
        foreach($data as $k=>$v){
            $diff = array_diff($ids, $v);
            if(!empty($diff)){
                //名字带入
                foreach($diff as &$nid){
                    $nid = $salers[$nid];
                }
                $ret[$k] = implode(',', $diff);
            }
        } 

        return $ret;  
    }
}