[download] Модуль вывода товаров для VirtueMart (1.2.3 и 2.1) - страница 35 - [VM1] Дизайн, оформление

$lists[$i]->pname 		= $row->pname;

function list_product_type($product_id) {
		global $VM_LANG;
		$tpl = vmTemplate::getInstance();
		if (!$this->product_in_product_type($product_id)) {
			return "";
		}
		// $dbag = product_types;
		$dbag = new ps_DB;
		// $dba = Attributes of product_type param, holds product_id and values assign to each param;
		$dba = new ps_DB;
		// $dbp = Parameters of product_type, holds definitions of each parameter, but not value ;
		$dbp = new ps_DB;
		$html ="";
		$q  = "SELECT * FROM #__{vm}_product_product_type_xref ";
		$q .= "LEFT JOIN #__{vm}_product_type USING (product_type_id) ";
		$q .= "WHERE product_id='$product_id' AND product_type_publish='Y' ";
		$q .= "ORDER BY product_type_list_order";
		$dbag->query( $q );
		$q  = "SELECT * FROM #__{vm}_product_type_parameter ";
		$q .= "WHERE product_type_id=";
		$pt = 0; //product_type counter;
		while ($dbag->next_record()) { // Show all Product Type
			if ($dbag->f("product_type_flypage")) {
				$flypage_file = VM_THEMEPATH."templates/".$dbag->f("product_type_flypage").".php";
				if (file_exists($flypage_file)) {
					$html .= include($flypage_file);
					continue;
				}
			}
			$product_types[$pt]["product_type_name"] = $dbag->f("product_type_name");
			// SELECT parameter value of product
			$q2  = "SELECT * FROM #__{vm}_product_type_".$dbag->f("product_type_id");
			$q2 .= " WHERE product_id='$product_id'";
			$dbp->query($q2);
			// SELECT parameter of Product Type
			$dba->query($q.$dbag->f("product_type_id")." ORDER BY parameter_list_order");
			$i=0; // parameter counter;
			while ($dba->next_record()) {
				$product_type_param[$i]["parameter_label"] = $dba->f("parameter_label");
				$parameter_description = $dba->f("parameter_description");
				$product_type_param[$i]["parameter_description"] = $parameter_description;
				if (!empty($parameter_description)) {
					$product_type_param[$i]["tooltip"] = vmToolTip($parameter_description, $VM_LANG->_('PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_DESCRIPTION'));
				}
				$product_type_param[$i]["parameter_value"] = $dbp->f($dba->f("parameter_name"));
				$product_type_param[$i]["parameter_unit"] = $dba->f("parameter_unit");
				$i++;
			}
			$product_types[$pt]["product_type_count_params"] = $i;
			$product_types[$pt]["parameters"] = $product_type_param;
			$pt++;
		}
		
		$tpl->set( 'product_types', $product_types );
		$html .= $tpl->fetch( 'common/product_type.tpl.php' ) ;
			return $html;
}