<?php
/**
 * 各产品线车型占比趋势
 */
$sql = <<<EOFSQL
SELECT
DATE_FORMAT(model.create_time,'%Y') `year`,
DATE_FORMAT(model.create_time,'%m') `month`,
DATE_FORMAT(model.create_time,'%Y%m') `yearmonth`,
parent_id bigcate,
p_cate cate,
p_id sku
FROM gspcatalog.pro
JOIN gspcatalog.pro_cate cate ON cate.id = p_cate AND cate.is_moreline = 0
JOIN gspcatalog.pro_model_link model ON pml_p_id = p_id AND ckresult2 = {:ckresult2}
EOFSQL;
$sqlkeys = [
    'ckresult2'=>MODEL_CKRESULT2_OK,
];
$sql = qgprintf($sql,$sqlkeys);
return [
    'enable'=> true, //是否启用
    'table'=>'sum_pro_model',//表名
    'createTable'=>true,//是否创建表
    'dropTable'=>true,//创建表时是否删除表
    //'truncateTable'=>false,//写入数据是是否清空表
    'fields'=>[
        'year'=> $cols['year']['DDL'],
        'month'=> $cols['month']['DDL'],
        'yearmonth'=> $cols['yearmonth']['DDL'],
        'bigcate'=> $cols['bigcate']['DDL'],
        'cate'=> $cols['cate']['DDL'],
        'sku'=> $cols['sku']['DDL'],
    ],
    'keys'=>['year','month','yearmonth','bigcate','cate','sku'], //主键
    'indexs'=>[], //索引, ['aa',['b','c']]
    //指定表引擎与字符集,默认 InnoDB latin1 latin1_bin
    //'tableEnd'=>["ENGINE" => "InnoDB","DEFAULT CHARSET" => 'utf8mb4',"COLLATE" => 'utf8mb4_unicode_ci']
    //压入数据
    'pushData'=>[
        //默认值
        /*
        'default'=>[
            'year'=>date('Y'),
            'month'=>date('m'),
            'yearmonth'=>date('Ym')
        ],*/
         //插入数据不能有此处指定列的值,如果有整体操作放弃
         //'not'=>['yearmonth'=> date('Ym', strtotime(date('Y-m-01') . " - 1 month"))],
         //数据使用执行文件 /config/bi/php/{$key}.php
        'php'=>false,
         //数据使用SQL 优先 php
        'sql'=>$sql,
    ]
];