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 Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

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;
        
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $count = CustTotal::where(function($query) use($stime, $etime){
            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($stime, $etime){
            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);

        return view('custreport/totallist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,          
            'stime'             =>$stime,
            'etime'             =>$etime,
            ]);
    }

    /**
     * 添加订单
     * @return \Illuminate\View\View
     */
    public function totalcreate(Request $request)
    {
        return view('custreport/totalcreate');
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function totalstore(Request $request)
    {       
        $this->validate($request, [
            'total_cost'           => 'required', 
            'total_fan_add'           => 'required',   
            'dtime'           => 'required',   
        ], [                  
            'total_cost.required'           => '总成本不能为空',                   
            'total_fan_add.required'           => '总加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空',                                    
        ]);
        //数据库-新增数据
        $custreport = array();
       
        $custreport['total_cost'] = $request->input('total_cost'); 
        $custreport['total_fan_add'] = $request->input('total_fan_add'); 
        $custreport['dtime'] = $request->input('dtime'); 
                
        $res = DB::table('cust_day_total')->insert($custreport);            
        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();
        return view('custreport/totaledit', [       
            'custreport' => $data,
        ]);

    }

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

        $id = (int)$request->input('id');
        $res = DB::table('cust_day_total')->where('id', $id)->update($custreport);        
        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()){
            return redirect('/admin/custreport/totalindex')->with('info', '删除成功');
        }
    }

    public function total_export(Request $request){
        
        $self_role = session('role_name');
        if($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;
        
        $self_role = session('role_name');
        if($self_role == '超级管理员' || $self_role == '团队主管'){
            $admin_id = $request->input('admin_id');
            $search_admin = 1;
        }else{
            $admin_id = session('admin_id');
            $search_admin = 0;
        }

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

        $count = CustDetail::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id', $admin_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 = CustDetail::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id', $admin_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);

        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);

        return view('custreport/detaillist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,          
            'stime'             =>$stime,
            'etime'             =>$etime,
            'admin_id'          =>$admin_id,
            'search_admin'      =>$search_admin,
            'adminlist'         =>$adminList,
            ]);
    }

    /**
     * 添加订单
     * @return \Illuminate\View\View
     */
    public function detailcreate(Request $request)
    {
        return view('custreport/detailcreate');
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function detailstore(Request $request)
    {       
        $this->validate($request, [
            'old_consult'           => 'required', 
            'new_consult'           => 'required', 
            'fan_add'           => 'required',   
            'dtime'           => 'required',   
        ], [                  
            'old_consult.required'           => '老粉咨询不能为空',                   
            'new_consult.required'           => '新粉咨询数不能为空',                                    
            'fan_add.required'           => '加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空',                                    
        ]);
        //数据库-新增数据
        $custreport = array();
       
        $custreport['old_consult'] = $request->input('old_consult'); 
        $custreport['new_consult'] = $request->input('new_consult'); 
        $custreport['fan_add'] = $request->input('fan_add'); 
        $custreport['dtime'] = $request->input('dtime'); 
        $custreport['admin_id'] = session('admin_id'); 
        $custreport['admin_name'] = session('real_name'); 
                
        $res = DB::table('cust_day_detail')->insert($custreport);            
        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();
        return view('custreport/detailedit', [       
            'custreport' => $data,
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function detailupdate(Request $request)
    {            
        $this->validate($request, [
            'id'           => 'required', 
            'old_consult'           => 'required', 
            'new_consult'           => 'required', 
            'fan_add'           => 'required',   
            'dtime'           => 'required',   
        ], [                  
            'id.required'           => 'id不能为空',                   
            'old_consult.required'           => '老粉咨询不能为空',                   
            'new_consult.required'           => '新粉咨询数不能为空',                                    
            'fan_add.required'           => '加粉数不能为空',                                    
            'dtime.required'           => '日期不能为空',                                    
        ]);
        //数据库-新增数据
        $custreport = array();       
        $custreport['old_consult'] = $request->input('old_consult'); 
        $custreport['new_consult'] = $request->input('new_consult'); 
        $custreport['fan_add'] = $request->input('fan_add'); 
        $custreport['dtime'] = $request->input('dtime');  

        $id = (int)$request->input('id');
        $res = DB::table('cust_day_detail')->where('id', $id)->update($custreport);        
        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()){
            return redirect('/admin/custreport/detailindex')->with('info', '删除成功');
        }
    }

    public function detail_export(Request $request){
        
        $self_role = session('role_name');
        if($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 = CustDetail::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)->orderBy('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 = "
            <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;       
    }
}