<?php

namespace admin\action\grid;
use \model\grid\basic;
use \action;

/**
 * Class basicAction
 * @package admin\action\grid
 */
class basicAction  extends action{

    public function list()
    {
        $req = \mvc::$req;
        $where = [];
        if($req['filters']){
            $where = $this->filter2medoo($req['filters']);
        }
        $basic = new basic();
        $data = $basic->lists('demo',$where, $req['page'], $req['rows'], $req['sidx'], $req['sord'],"id desc");
        $this->successJson($data);
    }

    public function list1()
    {
        $req = \mvc::$req;
        $where = [];
        if($req['filters']){
            $where = $this->filter2medoo($req['filters']);
        }

        $basic = new basic();
        $data = $basic->lists('demo1',$where, $req['page'], $req['rows'], $req['sidx'], $req['sord'],"id desc");
        $this->successJson($data);
    }

    public function list2()
    {
        $req = \mvc::$req;
        $where = [];
        if($req['filters']){
            $where = $this->filter2medoo($req['filters']);
        }

        $basic = new basic();
        $data = $basic->lists('demo2',$where, $req['page'], $req['rows'], $req['sidx'], $req['sord'],"id desc");
        $this->successJson($data);
    }

    public function list3()
    {
        $req = \mvc::$req;
        $where = [];
        if($req['filters']){
            $where = $this->filter2medoo($req['filters']);
        }

        $basic = new basic();
        $data = $basic->lists('models_dai',$where, $req['page'], $req['rows'], $req['sidx'], $req['sord'],"md_id desc");
        $this->successJson($data);
    }

    function detail($id){
        $carmodel = new basic();
        $row = $carmodel->getByID($id,'demo');
        $data = [];
        $html ="";
        $i=0;
        $field = [
            'ID' => 'id',
             'CCU预编码' => 'a',
             '申请日期' => 'c',
             '样品预编码'=> 'b',
             '申请人' => 'd',
             '单号' => 'e',
             '申请部门' => 'f',
             '区域' => 'g',
             '终止标记' => 'aa',
             '申请原因' => 'bb',
             '申请类型' => 'cc',
             '产品线' => 'dd',
             '小类' => 'ee',
             '客户代码' => 'ff',
             '客户名称' => 'gg',
             '核对备注' => 'aaa',
             '照片' => 'bbb',
             '申请(样品品牌)' => 'ccc',
             '申请(样品编码)' => 'ddd',
             '参考号' => 'eee',
             'KTYPE' => 'ggg',
             '车型来源' => 'aaaa',
             '保有量' => 'cccc',
             '保有量来源' => 'bbbb',
             '可销售区域' => 'dddd',
             '车型' => 'eeee',
             '备注' => 'ffff'
       ];

        foreach($field as $k => $v){
            $data[$i]['caption'] = $k;
            if($v == 'bbb'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }
            if ($v == 'eee'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }

            $data[$i]['value'] = $row[$v];
            $i++;
        }

        \view::set('data',$data);
        \view::put('carmodel.detail');
    }

    function detail1($id){
        $carmodel = new basic();
        $row = $carmodel->getByID($id,'demo1');
        $data = [];
        $html ="";
        $i=0;
        $field = [
            'ID' => 'id',
             '单号'=>'a',
			 '样品预编码'=>'b',
			 '申请日期'=>'c',
			 '申请人'=>'d',
            '区域'=>'e',
            '申请原因'=>'f',
            '申请类型'=>'g',
            '产品线'=>'aa',
            '小类'=>'bb',
            '申请样品品牌'=>'cc',
            '申请样品编码'=>'dd',
            '参考号'=>'ee',
            '配对产品'=>'ff',
            '车型'=>'gg',
            '下单日期'=>'aaa',
            '到样日期'=>'bbb',
            '采购价'=>'ccc',
            '币种'=>'ddd',
            '汇率'=>'eee',
            '采购渠道'=>'fff',
            '采购状态'=>'ggg',
            '供应商'=>'aaaa',
            '报价'=>'bbbb',
            '停购原因'=>'cccc',
            '操作人'=>'dddd',
            '指定采购人'=>'eeee',
        ];

        foreach($field as $k => $v){
            $data[$i]['caption'] = $k;
            if($v == 'bbb'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }
            if ($v == 'eee'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }

            $data[$i]['value'] = $row[$v];
            $i++;
        }
        \view::set('data',$data);
        \view::put('carmodel.detail');
    }

    function detail2($id){
        $carmodel = new basic();
        $row = $carmodel->getByID($id,'demo2');
        $data = [];
        $html ="";
        $i=0;
        $field = [
             '单号'=>'a',
			 '申请日期'=>'b',
			 '申请人'=>'c',
			 '申请部门'=>'d',
            '客户名称'=>'e',
            '区域'=>'f',
            '产品线'=>'g',
            '小类'=>'aa',
            '配对产品'=>'bb',
            '参考号'=>'cc',
            '车型'=>'dd',
            '备注'=>'ff',
            '来样方式'=>'gg',
            '样品所在地'=>'aaa',
            '客户要求'=>'bbb',
            '需求量'=>'ccc',
            '预计下单日期'=>'ddd',
            '产品主状态'=>'eee',
            '产品子状态'=>'fff',
            '核对类型'=>'aaaa',
            '完成时间'=>'bbbb',
            '到样样品品牌'=>'cccc',
            '到样样品号码'=>'dddd',
            '登记日期'=>'eeee',
            '是否编北美码'=>'ffff',
        ];

        foreach($field as $k => $v){
            $data[$i]['caption'] = $k;
            if($v == 'bbb'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }
            if ($v == 'eee'){
                if($row[$v] == 1){
                    $row[$v] = 'Yes';
                }else{
                    $row[$v] = 'No';
                }
            }

            $data[$i]['value'] = $row[$v];
            $i++;
        }
        \view::set('data',$data);
        \view::put('carmodel.detail');
    }

    public function numberList()
    {
        $data = [
            ['name' => 'STP','number' => 'GDB900', 'source' => 'CUU','people' => 'KangKang'],
            ['name' => 'STP','number' => 'GDB900', 'source' => 'FREAY','people' => 'KangKang'],
            ['name' => 'GD','number' => 'GDB900', 'source' => 'FREAY','people' => 'KangKang'],
            ['name' => 'GD','number' => 'GDB900', 'source' => 'CUU','people' => 'KangKang'],
        ];
        $this->successJson($data);
    }
    public function addNumberPage()
    {
        \view::put('grid.basic.addNumberPage');
    }

	public function lists(){
        $arr = [
            'id' => 'ID',
            'model_data_source' => '车型数据源',
            'model_category' => '车型类别',
            'stock' => '保有量',
            'car_series' => '车系',
            'country' => '国家',
            'saleable_area' => '可销售区域',
            'publishing_platform' => '发布平台',
            'gsp_model_year' => 'FREAY车型年代',
            'big_model' => '大车型',
            'small_model' => '小车型',
            'model_vehicle_name' => '车型别名',
            'style' => '款式',
            'fuel_mode' => '燃油方式',
            'displacement' => '排量',
            'chassis_number' => '底盘号',
            'engine_number' => '发动机号',
            'pressurization_method' => '增压方法',
            'power' => '功率',
            'horsepower' => '马力',
            'arrangement_of_engine_cylinders' => '发动机气缸排列方式',
            'number_of_valves' => '阀门数(相同气缸出现不同阀门)',
            'driving_mode' => '驱动方式',
            'body' => '车身',
            'number_of_doors' => '门数',
            'production_platform' => '生产平台',
            'installation_position_transmission' => '安装位置(变速箱)',
            'installation_position_front_and_rear' => '安装位置(前后)',
            'installation_position_left_and_right' => '安装位置(左右)',
            'installation_position_ws_outer_gs_inner_middle' => '安装位置(ws外/GS/内中)',
            'installation_position_upper_middle_lower' => '安装位置(上中下)',
            'installation_position_synthesis' => '安装位置(综合)',
            'other_model_remarks' => '其它车型备注',
            'catalog_remarks' => '目录备注',
            'reserve_remarks_1' => '预留备注1',
            'reserve_remarks_2' => '预留备注2'
        ];

       $req = \mvc::$req;
        $field = array_keys($arr);
        $result = [];
        for ($i = 0; $i <= $req['rows'] -1; $i++)
        {
            foreach ($arr as $k => $v)
            {
                $result[$i][$k] = $v;
            }
        }
        $data = [
            'page' => 1,
            'total' => 1000,
            'records' => 10,
            'rows' => $result,
            'field' => $field
        ];

//		$where = [];
//		if($req['filters']){
//			$where = $this->filter2medoo($req['filters']);
//		}
//		$basic = new basic();
//		$data = $basic->list($where, $req['page'], $req['rows'], $req['sidx'], $req['sord'],"no desc");
//		var_dump($data);exit;
		$this->successJson($data);
	}
}