<?php
return [
    'id'=>  [
        'caption'=>lg('ID'),
		"DDL"=>[
		    "INT",
    		"NOT NULL",
    		"AUTO_INCREMENT"
		]
	],
    'year'=>  [
        'caption'=>lg('年'),
		"DDL"=>[
    		"SMALLINT",
    		"NOT NULL",
		],
        'dimension'=>true,
	],
    'month'=>  [
        'caption'=>lg('月'),
		"DDL"=>[
    		"SMALLINT",
    		"NOT NULL",
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            $data = [
		        '1'=>  ['cn_name'=>'一月'  ,'en_name'=>'Jan.'],
		        '2'=>  ['cn_name'=>'二月'  ,'en_name'=>'Feb.'],
		        '3'=>  ['cn_name'=>'三月'  ,'en_name'=>'Mar.'],
		        '4'=>  ['cn_name'=>'四月'  ,'en_name'=>'Apr.'],
		        '5'=>  ['cn_name'=>'五月'  ,'en_name'=>'May.'],
		        '6'=>  ['cn_name'=>'六月'  ,'en_name'=>'Jun.'],
		        '7'=>  ['cn_name'=>'七月'  ,'en_name'=>'Jul.'],
		        '8'=>  ['cn_name'=>'八月'  ,'en_name'=>'Aug.'],
		        '9'=>  ['cn_name'=>'九月'  ,'en_name'=>'Sept.'],
		        '10'=> ['cn_name'=>'十月'  ,'en_name'=>'Oct.'],
		        '11'=> ['cn_name'=>'十一月','en_name'=>'Nov.'],
		        '12'=> ['cn_name'=>'十二月','en_name'=>'Dec.'],
		    ];
		    return $data[$key];
        }
	],
    'yearmonth'=>  [
        'caption'=>lg('年月'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
		],
        'dimension'=>true,
	],
    'bigcate'=>  [
        'caption'=>lg('产品线'),
		"DDL"=>[
    		"INT",
    		"NOT NULL"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('pro_cate',['cn_name','en_name'],['id'=>$key]);
        }
	],
    'cate'=>  [
        'caption'=>lg('品名'),
		"DDL"=>[
    		"INT",
    		"NOT NULL"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('pro_cate',['parent_id(parent)','cn_name','en_name'],['id'=>$key]);
        },
        'parent'=>'bigcate',
        'getValuesByParent'=> <<<Javascript
            function (id) {
                var data = [];
                qg.ajaxS(HOST+'/pro/cate/getChilds',{id:id},function(res){
                    $.each(res.rows,function(i,v){
                        data.push(v.id);
                    });
                });
                return data;
            }
        Javascript,
	],
    'state'=>  [
        'caption'=>lg('状态'),
		"DDL"=>[
    		"enum('YJ','Y0','Y1','Y2','Y3','Y4','Y5','Y6')",
    		"NOT NULL"
		],
        'dimension'=>true,
	],
    'state1'=>  [
        'caption'=>lg('状态1'),
		"DDL"=>[
    		"enum('YJ','Y0','Y1','Y2','Y3','Y4','Y5','Y6')",
    		"NOT NULL"
		],
        'dimension'=>true,
	],
    'state2'=>  [
        'caption'=>lg('状态2'),
		"DDL"=>[
    		"enum('YJ','Y0','Y1','Y2','Y3','Y4','Y5','Y6')",
    		"NOT NULL"
		],
        'dimension'=>true,
	],
    'factory'=>  [
        'caption'=>lg('竞品品牌'),
		"DDL"=>[
    		"INT",
    		"NOT NULL"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('pro_factory',
                ['cn_name'=>raw('IFNULL(cn_name,pf_name)'),'en_name'=>raw('IFNULL(en_name,pf_name)')],
                ['pf_id'=>$key]
            );
        }
	],
    'region_s'=>  [
        'caption'=>lg('车系'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('object',['cn_name','en_name'],['o_id'=>$key]);
        }
	],
    'make'=>  [
        'caption'=>lg('大车型'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('m_make',['region_s(parent)','name(cn_name)','name(en_name)'],['mk_id'=>$key]);
        },
        'parent'=>'region_s',
        'getValuesByParent'=> <<<Javascript
            function (id) {
                var data = [];
                qg.ajaxS(HOST+'/carmodel/getMakeIds',{regionids:id},function(res){
                    data = res.rows;
                });
                return data;
            }
        Javascript,
	],
    'mms_source'=>  [
        'caption'=>lg('车型来源'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('object',['cn_name','en_name'],['o_id'=>$key]);
        }
	],
    'oeresult'=>  [
        'caption'=>lg('OE'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'",
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('object',['cn_name','en_name'],['o_id'=>$key]);
        }
	],
    'numidxresult'=>  [
        'caption'=>lg('号码核对结论'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'",
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('object',['cn_name','en_name'],['o_id'=>$key]);
        }
	],
    'ppic_type'=>  [
        'caption'=>lg('产品图片'),
		"DDL"=>[
    		"enum('0','init','init_add','init_back','init_replay','init_del','beautify','beautify_add','beautify_back','beautify_replay','beautify_del','tecdoc','catalog_g','catalog_gsp','usa','attach','notcattle','360','catalog','other')",
    		"NOT NULL",
    		"DEFAULT '0'",
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            $data = [
		        'init'=>  ['cn_name'=>'原始图'  ,'en_name'=>'Original Picture'],
		        'beautify'=>  ['cn_name'=>'精修图'  ,'en_name'=>'Refinement Picture'],
		    ];
		    return $data[$key];
        }
	],
    'lineimg'=>  [
        'caption'=>lg('图纸'),
		"DDL"=>[
    		"TINYINT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            $data = [
		        '0'=>  ['cn_name'=>'无'  ,'en_name'=>'Yes'],
		        '1'=>  ['cn_name'=>'有'  ,'en_name'=>'No'],
		    ];
		    return $data[$key];
        }
	],
    'param'=>  [
        'caption'=>lg('参数'),
		"DDL"=>[
    		"TINYINT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            $data = [
		        '0'=>  ['cn_name'=>'无'  ,'en_name'=>'Yes'],
		        '1'=>  ['cn_name'=>'有'  ,'en_name'=>'No'],
		    ];
		    return $data[$key];
        }
	],
    'pack'=>  [
        'caption'=>lg('包装'),
		"DDL"=>[
    		"TINYINT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            $data = [
		        '0'=>  ['cn_name'=>'无'  ,'en_name'=>'Yes'],
		        '1'=>  ['cn_name'=>'有'  ,'en_name'=>'No'],
		    ];
		    return $data[$key];
        }
	],
    's_form'=>  [
        'caption'=>lg('样品类型'),
        'dimension'=>true,
	],
    's_apply_area'=>  [
        'caption'=>lg('申请区域'),
        'dimension'=>true,
	],
    's_apply_type'=>  [
        'caption'=>lg('申请类型'),
        'dimension'=>true,
	],
    's_state_sub'=>  [
        'caption'=>lg('子状态'),
        'dimension'=>true,
	],
    'opuser'=>  [
        'caption'=>lg('人员'),
		"DDL"=>[
    		"VARCHAR(20)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('gsp_adm_user',['au_name(cn_name)','au_name(en_name)'],['au_id'=>$key]);
        }
	],
    's_apply_user'=>  [
        'caption'=>lg('申请人'),
		"DDL"=>[
    		"VARCHAR(20)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
        'dimension'=>true,
        'getValue'=> function($key,$db,$cols,$col){
            return $this->db->get('gsp_adm_user',['au_name(cn_name)','au_name(en_name)'],['au_id'=>$key]);
        }
	],
    'sku'=>  [
        'caption'=>lg('SKU'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		]
	],
	'vio_typeid'=>  [
        'caption'=>lg('TYPE ID'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		]
	],
	'vio_fac'=>  [
        'caption'=>lg('数据源'),
		"DDL"=>[
    		"VARCHAR(32)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
		'dimension'=>true
	],
	'vio_type'=>  [
        'caption'=>lg('VIO类型'),
		"DDL"=>[
    		"VARCHAR(32)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
		'dimension'=>true
	],
	'vio_country'=>  [
        'caption'=>lg('国家'),
		"DDL"=>[
    		"VARCHAR(64)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
		'dimension'=>true
	],
	'vio_region_s'=>  [
        'caption'=>lg('车系'),
		"DDL"=>[
    		"VARCHAR(32)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
		'dimension'=>true
	],
	'vio_make'=>  [
        'caption'=>lg('大车型'),
		"DDL"=>[
    		"VARCHAR(128)",
    		"NOT NULL",
    		"DEFAULT ''"
		]
	],
	'vio_model_range'=>  [
        'caption'=>lg('小车型'),
		"DDL"=>[
    		"VARCHAR(128)",
    		"NOT NULL",
    		"DEFAULT ''"
		],
		'dimension'=>true
	],
	'vio_age'=>  [
        'caption'=>lg('车龄'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
		'dimension'=>true
	],
	'vio_qty'=>  [
        'caption'=>lg('保有量'),
		"DDL"=>[
    		"INT",
    		"NOT NULL",
    		"DEFAULT '0'"
		],
	],
    'area'=>['caption'=>lg('区域'),'dimension'=>true],
    'country'=>['caption'=>lg('国家'),'dimension'=>true],
    'brand'=>['caption'=>lg('品牌'),'dimension'=>true],
    'empname'=>['caption'=>lg('业务员'),'dimension'=>true],
    'custnumber'=>['caption'=>lg('客户代码'),'dimension'=>true],
    'custname'=>['caption'=>lg('客户名称'),'dimension'=>true],
];