$column_data = Db::name('column')->where('id', $pid)->find();
if (!empty($column_data)) {
$series = $column_data['name'];
$recommend[$key]['series'] = $series;
} else {
$recommend[$key]['series'] = '';
}
}
//上一个产品
$res_prev = Db::name('product')->where('pId', $pro_pid)->where('FIND_IN_SET(:id,pro_parameter)', ['id' => $size_id])
->where('isDisable', '<>', 1)->where('intOrder', '<', $int_id)->order('intOrder desc, id desc')->find();
//下一个产品
$res_next = Db::name('product')->where('pId', $pro_pid)->where('FIND_IN_SET(:id,pro_parameter)', ['id' => $size_id])
->where('isDisable', '<>', 1)->where('intOrder', '>', $int_id)->order('intOrder asc, id asc')->find();
$this->assign('recommend_items', $recommend);
$this->assign('res_next', $res_next);
$this->assign('res_prev', $res_prev);
$this->assign('products_detail_data', $products_detail_data);
return $this->fetch('products/products_detail');