query($q); $browsepage = $db->f("product_type_browsepage"); $mainframe->setPageTitle( $VM_LANG->_PHPSHOP_PARAMETER_SEARCH ); $mainframe->appendPathWay( $VM_LANG->_PHPSHOP_PARAMETER_SEARCH ); echo "

".$VM_LANG->_PHPSHOP_PARAMETER_SEARCH."

"; if (!$db->next_record()) { // There is no published Product Type echo $VM_LANG->_PHPSHOP_PARAMETER_SEARCH_BAD_PRODUCT_TYPE; } else { echo "\n
"; echo $VM_LANG->_PHPSHOP_PARAMETER_SEARCH_IN_CATEGORY.": ".$db->f("product_type_name"); // Reset form echo ""; echo "
url( $mm_action_url.basename($_SERVER['PHP_SELF']). "?page=shop.parameter_search_form&product_type_id=". $product_type_id ). "\" method=\"post\" name=\"reset\">\n"; echo "_PHPSHOP_PARAMETER_SEARCH_RESET_FORM ."\">\n
"; echo "
 
\n"; ?>

query($q); echo "\n"; /******************************************************** ** BrowsePage - You can use your tepmlate for searching: ** 1) write file with html table (without tags
and
) and ** take its name into variable browsepage in Product Type ** 2) You can use this page from tag to ** tag and changed it. ** 3) tag {product_type__} will be replaced input field, or select field ** tag {product_type___comp} will be replaced comparison ** for this parameter. It is important for correct SQL question. ** tag {product_type___value} will be replaced value for this ** parameter (when you click on button "Change Parametes" in Browse page). ********************************************************/ if (!empty($browsepage)) { // show browsepage /** * Read the template file into a String variable. * * function read_file( $file, $defaultfile='') ***/ $template = read_file( PAGEPATH."templates/".$browsepage.".php"); //$template = str_replace( "{product_type_id}", $product_type_id, $template ); // If you need this, use it... while ($db->next_record()) { $item_name = "product_type_$product_type_id"."_".$db->f("parameter_name"); $parameter_values=$db->f("parameter_values"); $get_item_value = mosgetparam($_REQUEST, $item_name, ""); $get_item_value_comp = mosgetparam($_REQUEST, $item_name."_comp", ""); $parameter_type = $db->f("parameter_type"); // Replace parameter value $template = str_replace( "{".$item_name."_value}", $get_item_value, $template ); // comparison if (!empty($parameter_values) && $db->f("parameter_multiselect")=="Y") { if ($parameter_type == "V") { // type: Multiple Values // Multiple section List of values - comparison FIND_IN_SET $comp = "\n"; $comp .= ""; } else { // type: all other // Multiple section List of values - no comparison $comp = "\n\n"; } } else { switch( $parameter_type ) { case "C": // Char if (!empty($parameter_values)) { // List of values - no comparison $comp = "\n"; break; } case "I": // Integer case "F": // Float case "D": // Date & Time case "A": // Date case "M": // Time $comp = "\n"; break; case "T": // Text if (!empty($parameter_values)) { // List of values - no comparison $comp = "\n"; break; } $comp = ""; break; case "S": // Short Text default: // Default type Short Text if (!empty($parameter_values)) { // List of values - no comparison $comp = "\n"; break; } $comp = ""; } } // Relace parameter comparison $template = str_replace( "{".$item_name."_comp}", $comp, $template ); // Parameter field if (!empty($parameter_values)) { // List of values $fields=explode(";",$parameter_values); $attr = ""; } else { // Input field switch( $parameter_type ) { case "I": // Integer case "F": // Float case "D": // Date & Time case "A": // Date case "M": // Time $attr = ""; break; case "T": // Text $attr = ""; break; case "C": // Char $attr = ""; break; case "S": // Short Text default: // Default type Short Text $attr = ""; } } // Relace parameter $template = str_replace( "{".$item_name."}", $attr, $template ); } echo $template; } else { // show default list of parameters echo "\n\n\n"; while ($db->next_record()) { $parameter_type = $db->f("parameter_type"); if ($parameter_type!="B") { echo "\n
"; echo $db->f("parameter_label"); if ($db->f("parameter_description")) { echo " "; echo mm_ToolTip($db->f("parameter_description"),$VM_LANG->_PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_DESCRIPTION); } echo " :
\n \n"; $parameter_values=$db->f("parameter_values"); $item_name = "product_type_$product_type_id"."_".$db->f("parameter_name"); $get_item_value = mosgetparam($_REQUEST, $item_name, ""); $get_item_value_comp = mosgetparam($_REQUEST, $item_name."_comp", ""); // comparison if (!empty($parameter_values) && $db->f("parameter_multiselect")=="Y") { if ($parameter_type == "V") { // type: Multiple Values // Multiple section List of values - comparison FIND_IN_SET echo "\n"; echo ""; } else { // type: all other // Multiple section List of values - no comparison echo "\n\n"; } } else { switch( $parameter_type ) { case "C": // Char if (!empty($parameter_values)) { // List of values - no comparison echo "\n\n"; break; } case "I": // Integer case "F": // Float case "D": // Date & Time case "A": // Date case "M": // Time echo "\n"; echo ""; break; case "T": // Text if (!empty($parameter_values)) { // List of values - no comparison echo "\n\n"; break; } echo "\n"; echo ""; break; case "V": // Multiple Value echo "\n\n"; break; case "S": // Short Text default: // Default type Short Text if (!empty($parameter_values)) { // List of values - no comparison echo "\n\n"; break; } echo "\n"; echo ""; } } if (!empty($parameter_values)) { // List of values $fields=explode(";",$parameter_values); echo "\n"; echo ""; } else { // Input field echo "\n"; switch( $parameter_type ) { case "I": // Integer case "F": // Float case "D": // Date & Time case "A": // Date case "M": // Time echo ""; break; case "T": // Text echo ""; break; case "C": // Char echo ""; break; case "S": // Short Text default: // Default type Short Text echo ""; } } echo " ".$db->f("parameter_unit"); switch( $parameter_type ) { case "D": // Date & Time echo " (".$VM_LANG->_PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_TYPE_DATE_FORMAT." "; echo $VM_LANG->_PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_TYPE_TIME_FORMAT.")"; break; case "A": // Date echo " (".$VM_LANG->_PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_TYPE_DATE_FORMAT.")"; break; case "M": // Time echo " (".$VM_LANG->_PHPSHOP_PRODUCT_TYPE_PARAMETER_FORM_TYPE_TIME_FORMAT.")"; break; } } else { // Break line (type == "B") echo "\n
"; } echo " \n"; } echo "\n\n\n"; } // Add search according to price: $item_name = "price"; $get_item_value = mosgetparam($_REQUEST, $item_name, ""); $get_item_value_comp = mosgetparam($_REQUEST, $item_name."_comp", ""); echo "\n
"; echo $VM_LANG->_PHPSHOP_CART_PRICE." :
\n \n"; // comparison echo "\n"; echo ""; // input text echo "\n \n"; // Search Button ?>