<?php
namespace app\products\controller;



use app\common\model\serviceapi\Product as ProductModel;
use app\common\model\serviceapi\ProductUser as ProductUserModel;
use app\common\model\serviceapi\ProductOrder as ProductOrderModel;


use app\web\controller\BaseController;
use think\Log;
use think\Request;
use util\MCurl;
use think\Cookie;
use think\Session;
header("Content-type: text/html; charset=utf-8");
header('Access-Control-Allow-Origin:*');
header('Content-Type: application/json; charset=utf-8');
header('Access-Control-Allow-Methods: GET, POST, PUT, DELETE, OPTIONS');
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");
/**
 * 功能描述  产品管理
 * Class Product
 * @package app\products\controller
 * Date: 2020/11/2
 * Time: 10:00
 * @author nyq
 */
class Product extends BaseController
{

    private $api_back_url = "http://sosapi.com/commapi/generator_data/sosBxCarInfoAdd";


    public function carOrder()
    {

        //$res = MCurl::instance($this->api_back_url)->post($data);
            $data=[];
        $res=[];
         for($i=0;$i<10;$i++){
             $res[$i] = json_decode(MCurl::instance($this->api_back_url)->post($data),true);
         }




        $this->to($res);

        var_dump($res);
        die;
        //var_dump();
        //echo 111;die;

        return $res;
    }


    public function to($json)
    {



        ob_end_clean();//清除缓冲区,避免乱码
        Vendor('PHPExcel.PHPExcel');
        $objPHPExcel=new \PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', '用户名')
            ->setCellValue('B1', '车牌')
            ->setCellValue('C1', '身份证')
            ->setCellValue('D1', '电话')
            ->setCellValue('E1', '年龄')
            ->setCellValue('F1', '性别');

        $rowIndex = 2;

        foreach ($json as $k => $v) {

            $objPHPExcel->getActiveSheet()
                ->setCellValue('A' . $rowIndex, $v['uname'])
                ->setCellValue('B' . $rowIndex, $v['pai'])
                ->setCellValue('C' . $rowIndex, $v['shen'])
                ->setCellValue('D' . $rowIndex, $v['tel'])
                ->setCellValue('E' . $rowIndex, $v['age'])
                ->setCellValue('F' . $rowIndex, $v['sex']);
            $rowIndex++;
        }
//        echo 3321;die;
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(100
        );
       // $objPHPExcel->getActiveSheet()->getStyle('C')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);

        $filename = '用户数据表';
        header('Content-Type: application/vnd.ms-excel');

        $ua = $_SERVER["HTTP_USER_AGENT"];
        header('Content-type: text/html; charset=gbk');
        header("Content-type:application/vnd.ms-excel;charset=gbk");
        //兼容IE11
        if (preg_match("/MSIE/", $ua) || preg_match("/Trident\/7.0/", $ua)) {
            header('Content-Disposition: attachment;filename="' . urlencode($filename) . '.xls"');
        } else if (preg_match("/Firefox/", $ua)) {
            header('Content-Disposition: attachment;filename*="' . $filename . '.xls"');
        } else {
            header('Content-Disposition: attachment; filename="' . $filename . '.xls"');
        }
        header('Cache-Control: max-age=0');
        header('Cache-Control: max-age=1');
        header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
        header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
        header('Cache-Control: cache, must-revalidate');
        header('Pragma: public');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output');

    }



    /**
     * 函数功能描述  删除订单
     * Date: 2020/8/07
     * Time: 10:00
     * @author nyq
     */
    public function order_del()
    {
        $data = $this->request->post();
        $product_order_model = new ProductOrderModel();
        $res = $product_order_model->orderDel($data);
        $json=json_decode($res,true);
        if(is_numeric($json)){
            $data=[
                'code'=>200,
                'msg'=>'删除成功'
            ];
        }else{
            $data=[
                'code'=>100,
                'msg'=>'删除失败'
            ];
        }
        return $data;
    }



    /**
     * 函数功能描述   生成订单
     * Date: 2020/11/2
     * Time: 10:00
     * @author nyq
     */
    public function addOrde(Request $request)
    {






        $data = $request->param();
        //用户信息
        $user['name']=$data['name'];
        $user['phone']=$data['phone'];
//        $user['sheng']=$data['sheng'];
//        $user['shi']=$data['shi'];
//        $user['qu']=$data['qu'];
        $user['address']=$data['address'];
        $user['addTime']=time();

        $product_user_model = new ProductUserModel();
        $res = $product_user_model->add($user);

        //订单信息
        $order['order_code']=time().mt_rand(999, 9999);
        $order['user_id']=$res;
        $order['goods_id']=$data['goods_id'];
        $order['num']=$data['num'];
        $order['price']=$data['price'];
//        $order['sheng']=$data['sheng'];
//        $order['shi']=$data['shi'];
//        $order['qu']=$data['qu'];
        $order['address']=$data['address'];
        $order['addTime']=time();
        $order['upTime']=time();
        $product_order_model = new ProductOrderModel();
        $order_res = $product_order_model->add($order);

        $json=json_decode($order_res,true);
        if(is_numeric($json)){
            $data=[
                'code'=>200,
                'msg'=>'成功'
            ];
        }else{
            $data=[
                'code'=>100,
                'msg'=>'失败'
            ];
        }
        return $data;
    }
    /**
     * 函数功能描述   获取订单列表
     * Date: 2020/11/2
     * Time: 10:00
     * @author nyq
     */
    public function get_order_list(Request $request)
    {
        $data = $request->param();
        $page = isset($_POST['page']) ? intval($_POST['page']) : 1;
        $rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
        $offset=($page-1)*$rows;
        $data['offset']=$offset;
        $data['rows']=$rows;
        $where=[];
        $product_user_model = new ProductUserModel();
        $res = $product_user_model->getUserlist($where,$data['offset'],$data['rows']);
        $json=json_decode($res,true);


        foreach($json  as $key=>$val ){

            $json[$key]['addTime']=date('Y-m-d H:i:s',$val['addTime']);
            //$json[$key]['address']=$json[$key]['sheng'].$json[$key]['shi'].$json[$key]['qu'].$json[$key]['address'];
        }

        $result["total"] =count($json);
        $result['rows']=$json;
        echo json_encode($result);
        //return $json;
    }


    /**
     * 函数功能描述   根据id查询商品信息
     * Date: 2020/11/2
     * Time: 10:00
     * @author nyq
     */
    public function get_one_list(Request $request)
    {
        $data = $request->param();
        $product_model = new ProductModel();
        $res = $product_model->getGoodsList($data);


        $res['content'] = htmlspecialchars_decode($res['content']);


        $img[]=explode(',',$res['images']);
        $res['img']=$img[0][0];
        $res['img2']=$img[0][1];
        $res['img3']=$img[0][2];

        unset($res['images']);
        return $res;
    }


    /**
     * 函数功能描述   获取商品列表
     * Date: 2020/11/2
     * Time: 10:00
     * @author nyq
     */
    public function goods_list(Request $request)
    {
        $data = $request->param();
        $page = isset($_POST['page']) ? intval($_POST['page']) : 1;
        $rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
        $offset=($page-1)*$rows;
        $data['offset']=$offset;
        $data['rows']=$rows;
        $product_model = new ProductModel();
        $where=[];
        $res = $product_model->goodsList($where,$data['offset'],$data['rows']);
        $json=json_decode($res,true);
        foreach($json  as $key=>$val ){
            $json[$key]['addTime']=date('Y-m-d H:i:s',$val['addTime']);
        }

        $result["total"] =count($json);
        $result['rows']=$json;
        echo json_encode($result);
        //return $json;
    }



    /**
     * 函数功能描述   添加商品
     * Date: 2020/11/02
     * Time: 10:00
     * @author nyq
     */
    public function goods_add(Request $request)
    {
        $data = $request->param();

        $data['images']=$data['img'].','.$data['img2'].','.$data['img3'];

        unset($data['img'],$data['img2'],$data['img3']);
        $product_model = new ProductModel();
        if(isset($data['goods_id']) && !empty($data['goods_id'])){
            $data['upTime']=time();
            $where['id']=$data['goods_id'];
            unset($data['goods_id']);
            $res = $product_model->productUp($where,$data);
        }else{
            unset($data['goods_id']);
            $data['addTime']=time();
            $data['upTime']=time();

            $res = $product_model->add($data);
        }
        $json=json_decode($res,true);
        if(is_numeric($json)){
            $data=[
                'code'=>200,
                'msg'=>'成功'
            ];
        }else{
            $data=[
                'code'=>100,
                'msg'=>'失败'
            ];
        }
        return $data;
    }




    /**
     * 函数功能描述   文件上传
     * Date: 2020/11/02
     * Time: 10:00
     * @author nyq
     */
    public function uploadFileImgs(){
        $files = request()->file('files');
        $path = input('path');
        if($files){
            $imgarr = [];
            foreach($files as $file){
                $info = $file->validate(['size'=>204800000,'ext'=>'jpg,png,gif'])->move(ROOT_PATH . 'public/web/' . DS . 'product');
                if($info){
                    $newurl = '/web/product/'.$info->getSaveName();
                    $img= str_replace('\\','/',$newurl);

                    $imgarr[]=$img;
                }
            }
            return json_encode($imgarr);
        }else{
            echo '没有图片上传';
        }
    }


    /**
     * 函数功能描述   导出数据到表格
     * Date: 2020/8/26
     * Time: 10:00
     * @author nyq
     */
    public function to_excel()
    {
        //$data = $this->request->Post();
//        $data= Cookie::get('data');
//        $data['to_excel']=1;
        $product_user_model = new ProductUserModel();
        $json = $product_user_model->getUserlistToEx();


        //$res = MCurl::instance($this->api_url."prizeUserList")->post($data);

        //$json=json_decode($res,true);

        foreach($json  as $key=>$val ){
            $json[$key]['addTime']=date('Y-m-d H:i:s',$val['addTime']);
            $json[$key]['address']=$json[$key]['sheng'].$json[$key]['shi'].$json[$key]['qu'].$json[$key]['address'];
        }

        ob_end_clean();//清除缓冲区,避免乱码
        Vendor('PHPExcel.PHPExcel');
        $objPHPExcel=new \PHPExcel();
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue('A1', '订单编号')
            ->setCellValue('B1', '商品名称')
            ->setCellValue('C1', '用户名')
            ->setCellValue('D1', '电话')
            ->setCellValue('E1', '详细地址')
            ->setCellValue('F1', '产品数量')
            ->setCellValue('G1', '总金额')
            ->setCellValue('H1', '下单时间');
        $rowIndex = 2;

        foreach ($json as $k => $v) {
            $objPHPExcel->getActiveSheet()
                ->setCellValue('A' . $rowIndex, $v['order_code'])
                ->setCellValue('B' . $rowIndex, $v['goods_name'])
                ->setCellValue('C' . $rowIndex, $v['name'])
                ->setCellValue('D' . $rowIndex, $v['phone'])
                ->setCellValue('E' . $rowIndex, $v['address'])
                ->setCellValue('F' . $rowIndex, $v['num'])
                ->setCellValue('G' . $rowIndex, $v['price'])
                ->setCellValue('H' . $rowIndex, $v['addTime']);
            $rowIndex++;
        }

        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(25);

        $filename = '产品订单列表';
        header('Content-Type: application/vnd.ms-excel');

        $ua = $_SERVER["HTTP_USER_AGENT"];
        header('Content-type: text/html; charset=gbk');
        header("Content-type:application/vnd.ms-excel;charset=gbk");
        //兼容IE11
        if (preg_match("/MSIE/", $ua) || preg_match("/Trident\/7.0/", $ua)) {
            header('Content-Disposition: attachment;filename="' . urlencode($filename) . '.xls"');
        } else if (preg_match("/Firefox/", $ua)) {
            header('Content-Disposition: attachment;filename*="' . $filename . '.xls"');
        } else {
            header('Content-Disposition: attachment; filename="' . $filename . '.xls"');
        }
        header('Cache-Control: max-age=0');
        header('Cache-Control: max-age=1');
        header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
        header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
        header('Cache-Control: cache, must-revalidate');
        header('Pragma: public');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output');

    }

}