<?php
namespace model;
use \model;
/**
 * Class procate
 * @package model
 */
class table extends model
{
	/**
	  * @method 获取表数据
	  * @param $table string [必填]  m_series|m_model|pro_model_link...
	  * @param $dataArr array [必填]  字段信息
	  * @param $idArr array [选填] 指定ID查询
	  * @author soul
	  * @return []
	  */
	public function getData($tag, $idArr = null)
	{
		$cofAllArr = [
			'getColl'=>[
				'name'=>lg('关联属性'),
				'table'=>'object',
				'idkey'=>'o_id',
				'fileds'=>['o_id', 'cn_name', 'en_name']
			],
			'getMake'=>[
				'name'=>lg('大车型'),
				'table'=>'m_make',
				'idkey'=>'mk_id',
				'fileds'=>['mk_id', 'name']
			],
			'getSeries'=>[
				'name'=>lg('小车型'),
				'table'=>'m_series LEFT JOIN m_make AS mk ON mm.mm_mk_id = mk.mk_id',
				'idkey'=>'ms_id',
				'fileds'=>['mk.mk_id', 'mk.name mk_name', 'ms_id', 'ms_mk_id', 'name', 'region_s', 'region_c']
			],
			'getModel'=>[
				'name'=>lg('国际车型'),
				'table'=>'m_model AS mm LEFT JOIN m_series AS ms ON mm.mm_ms_id = ms.ms_id LEFT JOIN m_make AS mk ON mm.mm_mk_id = mk.mk_id',
				'idkey'=>'mm_id',
				'fileds'=>['mm.*','mk.mk_id', 'mk.name mk_name', 'ms.ms_id', 'ms.name ms_name','mm.name mm_name', 'region_s', 'region_c']
			],
			'getModelSource'=>[
				'name'=>lg('国际车型关联ID'),
				'table'=>'m_model_source',
				'idkey'=>'mms_mm_id',
				'fileds'=>['*']
			],
			'getCnModel'=>[
				'name'=>lg('中国车型'),
				'table'=>'m_cn_model',
				'idkey'=>'mod3_id',
				'fileds'=>['*']
			],
			'getProModelArea'=>[
				'name'=>lg('国际通用库适用于及备注'),
				'table'=>'pro_model_area_link pml JOIN m_area ma ON ma_id = pma_ma_id',
				'idkey'=>'pma_pml_id',
				'idname'=>'pml_id',
				'fileds'=>['ma_id', 'ma.name ma_name', 'pml.*']
			]
		];
		if(empty($cofAllArr[$tag])) exitJson('规则尚未配置');
		$cofArr = $cofAllArr[$tag];
		$table = $cofArr['table'];
		if(!empty($idArr))
		{
			if(!is_array($idArr)) $idArr = explode(',', $idArr);
			foreach($idArr as $k=>$v)
			{
				$idArr[$k] = (int) $v;
			}
			$sql = sprintf("select %s from %s where %s in (%s)", implode(',', $cofArr['fileds']), $table, implode(',', $idArr));
		}
		else
		{
			$sql = sprintf("select %s from %s", implode(',', $cofArr['fileds']), $table);
		}
		$data = $this->db->query($sql)->fetchAll();
        if(empty($data)) $data = [];
		return $data;
	}
}