<?php
/*
可操作内容
$pd = model\pdflib\pdfData

$cateStyle,$cateTitle,$cateRemark,$cateList,$cateArea,$cateVer,
$type,$typeName,$cols,
$id,$code,$key,$name,$title,$remark,$tplCates,$jsonArr,$hasIndex

*/
// 轮毂附件-Hub Assemblies
if(empty($tplCates)) msgJson($name.' 未绑定品名');

$sql = <<<EOF
SELECT
p_id,
p_seq seq,
p_cate,
p_outnum outnum,
pro_attaqty.*
%s
FROM pro_attaqty
JOIN pro ON pa_p_id = p_id 
JOIN pro_cate ON id = p_cate 
%s
WHERE p_cate IN ($tplCates) %s
%s
%s
EOF;

/** G 品牌*/
if($gspband=='g'){
$sql = <<<EOF
SELECT
p_id,
p_seq seq,
p_cate,
num.pn_number outnum,
pro_attaqty.*
%s
FROM pro_attaqty
JOIN pro ON pa_p_id = p_id 
JOIN pro_numidx num ON num.pn_p_id = p_id AND num.pn_pf_id = $g_brand_id
JOIN pro_cate ON id = p_cate 
%s
WHERE p_cate IN ($tplCates) %s
%s
%s
EOF;
}//G 品牌


/***********************************************************/
$fileds = '';
$join = '';
$where = '';
$group = '';
$order = 'ORDER BY outnum';
if(!empty($cateVer)){
	$join = " JOIN tags_link ON p_id=tl_value_id AND tl_type='pro'";
	if($cateVer=="2") $join .= "JOIN p_code ON pc_p_id = p_id AND (pc_release_vers='' OR CONCAT(',',pc_release_vers,',') like '%,".$newVerName.",%')";
	$where = sprintf("AND tl_t_id > tl_t_id ^ %d",$cateVer);
}
$sql = sprintf($sql,$fileds,$join,$where,$group,$order);
/***********************************************************/

$items = [];
$rows  = $pd->db->query($sql)->fetchAll(PDO::FETCH_ASSOC);
$colRegI = 1;
foreach($rows as &$row){
	array_push($items,[
		'col1'=> sprintf("%s",$colRegI),
		'col2'=> sprintf("%s",$row['outnum']),
		
		'col3' => sprintf("%s",$row['pa_1']),
		'col4' => sprintf("%s",$row['pa_2']),
		'col5' => sprintf("%s",$row['pa_3']),
		'col6' => sprintf("%s",$row['pa_4']),
		'col7' => sprintf("%s",$row['pa_5']),
		'col8' => sprintf("%s",$row['pa_6']),
		'col9' => sprintf("%s",$row['pa_7']),
		'col10'=> sprintf("%s",$row['pa_8']),
		'col11'=> sprintf("%s",$row['pa_9']),
		'col12'=> sprintf("%s",$row['pa_10']),
		'col13'=> sprintf("%s",$row['pa_11']),
		'col14'=> sprintf("%s",$row['pa_12']),
		'col15'=> sprintf("%s",$row['pa_13']),
		'col16'=> sprintf("%s",$row['pa_14']),
	]);
	$colRegI++;
}

$data = [
	'style' => 'tools2Guide',
	'title' => $title,
	'remark' => $remark,
	'compute' => $hasIndex, // 是否需要计算页码
	'value' => $items
];
return !empty($items) ? $data : [];