<?
/**
 * Get Category and Brand for list items
 * 
 * 
 */
function getCategoryBrandRelated($itemID, $category, $brand, $lang = 'EN')
{

    $numRelateds = 4;
    $category;
    $brand;
    $brandArray = array();
    $categoryArray = array();


    if (isset($itemID) and ($itemID != "")) {
        // we have an item view
        $category = GetItemCategory($itemID, $lang);
        $brand = GetItemBrand($itemID);
        $brandArray = GetRelatedBrandsSimple($brand, $numRelateds, "brand", $lang);
        $categoryArray = GetRelatedCategoriesSimple($category, $numRelateds, "category", $lang);
    } elseif ($category) { // we have a category view
        $brandArray = GetRelatedBrandsSimple($category, $numRelateds, "category");
        $categoryArray = GetRelatedCategoriesSimple($category, $numRelateds, "category");
    } elseif ($brand) { //we have a brand view
        $brandArray = GetRelatedBrandsSimple($brand, $numRelateds, "brand");
        $categoryArray = GetRelatedCategoriesSimple($brand, $numRelateds, "brand");
    }

    return array('categoryArray' => $categoryArray, 'brandArray' => $brandArray);
}
/**
 * Get Brand Info
 * @author: clifton
 * @date: 14/04/2021
 */
function GetBrandInfoByBrandList($brand)
{
    global $config, $inventoryPDO;

    $sql = "SELECT * FROM brands WHERE brandlist='" . $brand . "'";

    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $brandCount = $cmd->rowCount();
    if ($brandCount > 0)
        return $row = $cmd->fetch(PDO::FETCH_OBJ);
    else
        return;

}

/**
 * Get Category Info
 * @author: clifton
 * @date: 14/04/2021
 */
function GetCatInfoByCatList($cat)
{
    global $config, $inventoryPDO;

    $sql = "SELECT * FROM category WHERE category_list='" . $cat . "'";

    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $brandCount = $cmd->rowCount();
    if ($brandCount > 0)
        return $row = $cmd->fetch(PDO::FETCH_OBJ);
    else
        return;
}

function GetRelatedBrands($brand, $showOriginalBrand = TRUE)
{
    global $config, $inventoryPDO;
    $prefix = $config->cat_brand_prefix;
    if ($prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT  brands1." . $config->cat_brand_prefix . "brandlist AS relatedBrand1Name, 
                    brands1." . $prefix . "alias AS alias1, 
                    brands1." . $prefix . "url AS url1, 
                    brands2." . $config->cat_brand_prefix . "brandlist AS relatedBrand2Name, 
                    brands2." . $prefix . "alias AS alias2, 
                    brands2." . $prefix . "url AS url2, 
                    brands3." . $config->cat_brand_prefix . "brandlist AS relatedBrand3Name, 
                    brands3." . $prefix . "alias AS alias3, 
                    brands3." . $prefix . "url AS url3, 
                    brands." . $prefix . "alias AS alias, 
                    brands." . $prefix . "url AS url, 
                    brands." . $config->cat_brand_prefix . "brandlist AS brandLang, 
                    brands.* 
            FROM brands 
             join brands as brands1 on brands.relatedbrand1 = brands1.id 
             join brands as brands2 on brands.relatedbrand2 = brands2.id 
             join brands as brands3 on brands.relatedbrand3 = brands3.id 
            WHERE brands.brandlist = '" . $brand . "'";
    $stmt = $inventoryPDO->prepare($sql);
    $stmt->execute();
    $relatedBrand = $stmt->fetchObject();
    $isFirst = true;
    if ($stmt->rowCount() > 0 && (strlen($brand) > 0 || strlen($relatedBrand->relatedBrand1Name) > 0 || strlen($relatedBrand->relatedBrand2Name) > 0 || strlen($relatedBrand->relatedBrand3Name) > 0)) {
        $brandLang = $relatedBrand->brandLang;
        if (isset($relatedBrand->url) && strlen($relatedBrand->url) > 0) {
            $url = $relatedBrand->url;
        } else {
            $url = "machinebrandview.php?mybrand=" . $brand;
        }
        if (isset($relatedBrand->url1) && strlen($relatedBrand->url1) > 0) {
            $url1 = $relatedBrand->url1;
        } else {
            $url1 = "machinebrandview.php?mybrand=" . $relatedBrand->relatedBrand1Name;
        }
        if (isset($relatedBrand->url2) && strlen($relatedBrand->url2) > 0) {
            $url2 = $relatedBrand->url2;
        } else {
            $url2 = "machinebrandview.php?mybrand=" . $relatedBrand->relatedBrand2Name;
        }
        if (isset($relatedBrand->url3) && strlen($relatedBrand->url3) > 0) {
            $url3 = $relatedBrand->url3;
        } else {
            $url3 = "machinebrandview.php?mybrand=" . $relatedBrand->relatedBrand3Name;
        }
        if (isset($relatedBrand->alias) && strlen($relatedBrand->alias) > 0) {
            $alias = $relatedBrand->alias;
        } else {
            $alias = $brandLang;
        }
        if (isset($relatedBrand->alias1) && strlen($relatedBrand->alias1) > 0) {
            $alias1 = $relatedBrand->alias1;
        } else {
            $alias1 = $relatedBrand->relatedBrand1Name;
        }
        if (isset($relatedBrand->alias2) && strlen($relatedBrand->alias2) > 0) {
            $alias2 = $relatedBrand->alias2;
        } else {
            $alias2 = $relatedBrand->relatedBrand2Name;
        }
        if (isset($relatedBrand->alias3) && strlen($relatedBrand->alias3) > 0) {
            $alias3 = $relatedBrand->alias3;
        } else {
            $alias3 = $relatedBrand->relatedBrand3Name;
        }
        $result = "<div class='hidden-xs hidden-sm viewMore alsoConsider'>\n";
        //$result .= "<div class='viewMoreTitle'>" . GetTranslation("also_consider") . ":</div>\n";
        if ($showOriginalBrand) {
            $isFirst = false;
            $result .= "<a href='" . $url . "'>" . $alias . "</a><br/>\n";
        }
        if ($relatedBrand->relatedbrand1 != 0) {
            $result .= "<a href='" . $url1 . "'>" . $alias1 . "</a><br/>\n";
        }
        if ($relatedBrand->relatedbrand2 != 0) {
            $result .= "<a href='" . $url2 . "'>" . $alias2 . "</a><br/>\n";
        }
        if ($relatedBrand->relatedbrand3 != 0) {
            $result .= "<a href='" . $url3 . "'>" . $alias3 . "</a><br/>\n";
        }
        $result .= "</div>";
        $result .= "<center><div class='visible-xs visible-sm viewMore viewMoreSmall'>\n";
        $result .= "<span class='viewMoreTitleSmall'>" . GetTranslation("consider") . ": </span> ";
        if ($showOriginalBrand) {
            $isFirst = false;
            $result .= "<a href='" . $url . "'>" . $alias . "</a>";
        }
        if ($relatedBrand->relatedbrand1 != 0) {
            if ($showOriginalBrand)
                $result .= ", ";
            $result .= "<a href='" . $url1 . "'>" . $alias1 . "</a>";
        }
        if ($relatedBrand->relatedbrand2 != 0) {
            $result .= ", <a href='" . $url2 . "'>" . $alias2 . "</a>";
        }
        if ($relatedBrand->relatedbrand3 != 0) {
            $result .= ", <a href='" . $url3 . "'>" . $alias3 . "</a>\n";
        }
        $result .= "</div></center>";
        return $result;
    }
}
function GetBrandURL($brand, $useAlias = true, $newWindow = false)
{
    global $config, $inventoryPDO;
    $prefix = $config->cat_brand_prefix;
    if ($prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT " . $prefix . "alias AS alias, 
                   " . $prefix . "url AS url
            FROM brands WHERE brandlist = '" . $brand . "'";
    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $brandCount = $cmd->rowCount();
    if ($brandCount > 0) {
        $row = $cmd->fetch(PDO::FETCH_OBJ);
        if ($newWindow) {
            $newWindowText = 'target="_blank"';
        } else {
            $newWindowText = '';
        }
        if (isset($row->url) && (strlen($row->url) > 0)) {
            if ($useAlias) {
                $url = "<a href='" . $row->url . "' " . $newWindowText . ">" . $row->alias . "</a>";
            } else {
                $url = "<a href='" . $row->url . "' " . $newWindowText . ">" . $brand . "</a>";
            }
        } else {
            $url = "<a href='machinebrandview.php?mybrand=" . $brand . "' " . $newWindowText . ">" . $brand . "</a>";
        }
    } else {
        $url = $brand;
    }
    return $url;
}
function GetBrandURLSimple($brand, $useAlias = true, $newWindow = false)
{
    global $config, $inventoryPDO;
    $prefix = $config->cat_brand_prefix;
    if ($prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT " . $prefix . "alias AS alias, 
                   " . $prefix . "url AS url
            FROM brands WHERE brandlist = '" . $brand . "'";
    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $brandCount = $cmd->rowCount();
    if ($brandCount > 0) {
        $row = $cmd->fetch(PDO::FETCH_OBJ);
        if ($newWindow) {
            $newWindowText = 'target="_blank"';
        } else {
            $newWindowText = '';
        }
        if (isset($row->url) && (strlen($row->url) > 0)) {
            if ($useAlias) {
                $url = $row->url;
            } else {
                $url = $row->url;
            }
        } else {
            $url = "machinebrandview.php?mybrand=" . $brand;
        }
    } else {
        $url = $brand;
    }
    return $url;
}
function GetCategoryURL($category, $useAlias = true, $newWindow = false)
{
    global $config, $inventoryPDO;
    $prefix = $config->cat_brand_prefix;
    $newWindowText = '';
    if ($prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT " . $prefix . "alias AS alias, 
                   " . $prefix . "url AS url
            FROM category WHERE category_list = '" . $category . "'";
    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $categoryCount = $cmd->rowCount();
    if ($categoryCount > 0) {
        $row = $cmd->fetch(PDO::FETCH_OBJ);
        if (isset($row->url) && strlen($row->url) > 0) {
            if ($newWindow) {
                $newWindowText = 'target="_blank"';
            }
            if ($useAlias && strlen($row->alias) > 0) {
                $url = "<a href='" . $row->url . "' " . $newWindowText . ">" . $row->alias . "</a>";
            } else {
                $url = "<a href='" . $row->url . "' " . $newWindowText . ">" . $category . "</a>";
            }
        } else {
            $url = "<a href='used_diecasting_equipment.php?mycat=" . $category . "' " . $newWindowText . ">" . $category . "</a>";
        }
    } else {
        $url = $category;
    }
    return $url;
}
function GetCategoryURLSimple($category, $useAlias = true, $newWindow = false)
{
    global $config, $inventoryPDO;
    $prefix = $config->cat_brand_prefix;
    $newWindowText = '';
    if ($prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT " . $prefix . "alias AS alias, 
                   " . $prefix . "url AS url
            FROM category WHERE category_list = '" . $category . "'";
    $cmd = $inventoryPDO->prepare($sql);
    $cmd->execute();
    $categoryCount = $cmd->rowCount();
    if ($categoryCount > 0) {
        $row = $cmd->fetch(PDO::FETCH_OBJ);
        if (isset($row->url) && strlen($row->url) > 0) {
            if ($newWindow) {
                $newWindowText = 'target="_blank"';
            }
            if ($useAlias && strlen($row->alias) > 0) {
                $url = $row->url;
            } else {
                $url = $row->url;
            }
        } else {
            $url = "used_diecasting_equipment.php?mycat=" . $category;
        }
    } else {
        $url = $category;
    }
    return $url;
}

function GetRelatedCategories($category, $showOriginalCategory = TRUE)
{
    global $config, $inventoryDb;
    $prifix = $config->cat_brand_prefix;
    if (!isset($prefix) || $prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    $sql = "SELECT  cat.*, 
                    cat." . $config->cat_brand_prefix . "category_list AS categoryLang, 
                    cat." . $prefix . "alias AS alias, 
                    cat." . $prefix . "url AS url, 
                    cat1." . $config->cat_brand_prefix . "category_list AS relatedCategory1Name, 
                    cat1." . $prefix . "alias AS alias1, 
                    cat1." . $prefix . "url AS url1, 
                    cat2." . $config->cat_brand_prefix . "category_list AS relatedCategory2Name, 
                    cat2." . $prefix . "alias AS alias2, 
                    cat2." . $prefix . "url AS url2, 
                    cat3." . $config->cat_brand_prefix . "category_list AS relatedCategory3Name, 
                    cat3." . $prefix . "alias AS alias3, 
                    cat3." . $prefix . "url AS url3 
            FROM category AS cat
                left outer join category AS cat1 on cat.relatedcategory1 = cat1.id 
                left outer join category AS cat2 on cat.relatedcategory2 = cat2.id 
                left outer join category AS cat3 on cat.relatedcategory3 = cat3.id 
            WHERE cat.category_list = '" . $category . "'";
    //echo $sql;
    $categoryQuery = $inventoryDb->query($sql);
    $categoryResult = $categoryQuery->fetch_object();
    if (isset($categoryResult)) {
        $categoryLang = $categoryResult->categoryLang;
        if ((strlen($categoryLang) > 0 && $showOriginalCategory) || strlen($categoryResult->relatedCategory1Name) > 0 || strlen($categoryResult->relatedCategory2Name) > 0 || strlen($categoryResult->relatedCategory3Name) > 0) {
            if (isset($categoryResult->url) && strlen($categoryResult->url) > 0) {
                $url = $categoryResult->url;
            } else {
                $url = "used_diecasting_equipment.php?mycat=" . $category;
            }
            if (isset($categoryResult->url1) && strlen($categoryResult->url1) > 0) {
                $url1 = $categoryResult->url1;
            } else {
                $url1 = "used_diecasting_equipment.php?mycat=" . $categoryResult->relatedCategory1Name;
            }
            if (isset($categoryResult->url2) && strlen($categoryResult->url2) > 0) {
                $url2 = $categoryResult->url2;
            } else {
                $url2 = "used_diecasting_equipment.php?mycat=" . $categoryResult->relatedCategory2Name;
            }
            if (isset($categoryResult->url3) && strlen($categoryResult->url3) > 0) {
                $url3 = $categoryResult->url3;
            } else {
                $url3 = "used_diecasting_equipment.php?mycat=" . $categoryResult->relatedCategory3Name;
            }
            if (isset($categoryResult->alias) && strlen($categoryResult->alias) > 0) {
                $alias = $categoryResult->alias;
            } else {
                $alias = $categoryLang;
            }
            if (isset($categoryResult->alias1) && strlen($categoryResult->alias1) > 0) {
                $alias1 = $categoryResult->alias1;
            } else {
                $alias1 = $categoryResult->relatedCategory1Name;
            }
            if (isset($categoryResult->alias2) && strlen($categoryResult->alias2) > 0) {
                $alias2 = $categoryResult->alias2;
            } else {
                $alias2 = $categoryResult->relatedCategory2Name;
            }
            if (isset($categoryResult->alias3) && strlen($categoryResult->alias3) > 0) {
                $alias3 = $categoryResult->alias3;
            } else {
                $alias3 = $categoryResult->relatedCategory3Name;
            }
            $result = "<div class='hidden-xs hidden-sm viewMore alsoConsider'>\n";
            //$result .= "<div class='viewMoreTitle'>" . GetTranslation("also_consider") . ":</div>\n";
            if ($showOriginalCategory) {
                $result .= "<a href='" . $url . "'>" . $alias . "</a><br/>\n";
            }
            if ($categoryResult->relatedcategory1 != 0) {
                $result .= "<a href='" . $url1 . "'>" . $alias1 . "</a><br/>\n";
            }
            if ($categoryResult->relatedcategory2 != 0) {
                $result .= "<a href='" . $url2 . "'>" . $alias2 . "</a><br/>\n";
            }
            if ($categoryResult->relatedcategory3 != 0) {
                $result .= "<a href='" . $url3 . "'>" . $alias3 . "</a><br/>\n";
            }
            $result .= "</div>";
            $result .= "<center><div class='visible-xs visible-sm viewMore viewMoreSmall'>\n";
            $result .= "<span class='viewMoreTitleSmall'>" . GetTranslation("consider") . ": </span> ";
            if ($showOriginalCategory) {
                $result .= "<a href='" . $url . "'>" . $alias . "</a>";
            }
            if ($categoryResult->relatedcategory1 != 0) {
                if ($showOriginalCategory)
                    $result .= ", ";
                $result .= "<a href='" . $url1 . "'>" . $alias1 . "</a>";
            }
            if ($categoryResult->relatedcategory2 != 0) {
                $result .= ", <a href='" . $url2 . "'>" . $alias2 . "</a>";
            }
            if ($categoryResult->relatedcategory3 != 0) {
                // $result .= ", <a href='" . $url3 . "'>" . $alias3 . "</a>\n";
            }
            $result .= "</div></center>";
            return $result;
        }
    } else {
        return "";
    }
}
function GetRelatedCategoriesSimple($wherestring, $returnQty, $based, $language = 'EN')
{
    global $config, $inventoryDb;
    $lang = new Language();
    $prefix = $config->cat_brand_prefix;
    $aliasLanguagePrefix = "en_";
    if (!isset($prefix) || $prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }
    //$language ='ES';
    if ($lang->getLanguageSession() == "ES" or $language == 'ES') {
        $aliasLanguagePrefix = "sp_";
        $prefix = 'sp_';
    }
    if ($based == "brand") {
        $sql = "SELECT  
                    cat1." . $config->cat_brand_prefix . "category_list AS relatedCategoryName4, 
                    cat1." . $aliasLanguagePrefix . "alias AS alias4, 
                    cat1." . $prefix . "url AS url4, 
                    cat2." . $config->cat_brand_prefix . "category_list AS relatedCategoryName2, 
                    cat2." . $aliasLanguagePrefix . "alias AS alias2, 
                    cat2." . $prefix . "url AS url2, 
                    cat3." . $config->cat_brand_prefix . "category_list AS relatedCategoryName3, 
                    cat3." . $aliasLanguagePrefix . "alias AS alias3, 
                    cat3." . $prefix . "url AS url3,
                    cat4." . $config->cat_brand_prefix . "category_list AS relatedCategoryName1, 
                    cat4." . $aliasLanguagePrefix . "alias AS alias1, 
                    cat4." . $prefix . "url AS url1  
            FROM brands
                left outer join category AS cat1 on brands.relatedcategory1 = cat1.id 
                left outer join category AS cat2 on brands.relatedcategory2 = cat2.id 
                left outer join category AS cat3 on brands.relatedcategory3 = cat3.id 
                left outer join category AS cat4 on brands.relatedcategory4 = cat4.id 
            WHERE brands.brandlist = '" . $wherestring . "'";

    } elseif ($based == "category") {
        $sql = "SELECT  
                    cat1." . $config->cat_brand_prefix . "category_list AS relatedCategoryName4, 
                    cat1." . $aliasLanguagePrefix . "alias AS alias4, 
                    cat1." . $prefix . "url AS url4, 
                    cat2." . $config->cat_brand_prefix . "category_list AS relatedCategoryName2, 
                    cat2." . $aliasLanguagePrefix . "alias AS alias2, 
                    cat2." . $prefix . "url AS url2, 
                    cat3." . $config->cat_brand_prefix . "category_list AS relatedCategoryName3, 
                    cat3." . $aliasLanguagePrefix . "alias AS alias3, 
                    cat3." . $prefix . "url AS url3,
                    cat." . $config->cat_brand_prefix . "category_list AS relatedCategoryName1, 
                    cat." . $aliasLanguagePrefix . "alias AS alias1, 
                    cat." . $prefix . "url AS url1  
            FROM category as cat
                left outer join category AS cat1 on cat.relatedcategory1 = cat1.id 
                left outer join category AS cat2 on cat.relatedcategory2 = cat2.id 
                left outer join category AS cat3 on cat.relatedcategory3 = cat3.id 
                
            WHERE cat.category_list = '" . $wherestring . "'";
        //echo $sql;
    } elseif ($based == "item") {
        //item query here
    }

    //echo $sql;die;
    $categoryQuery = $inventoryDb->query($sql);
    $categoryResult = $categoryQuery->fetch_object();

    if (isset($categoryResult)) {
        //if we are showing the source category, let's add it first.
        $i = 0;
        //     if($showOriginalCategory){
        //         $categoryArray[] = array("name" => ChooseCategoryLabel($categoryResult->categoryLang,$categoryResult->alias), "url" => $categoryResult->url);
        //         $i = 1; //we need to advance this by 1
        //     }
        for ($i = $i; $i < $returnQty + 1; $i++) {
            $catName = "relatedCategoryName" . $i;
            $alias = "alias" . $i;
            $url = "url" . $i;
            if (isset($categoryResult->$url) && (isset($categoryResult->$catName))) {
                $categoryArray[] = array("name" => ChooseCategoryLabel($categoryResult->$catName, $categoryResult->$alias), "url" => $categoryResult->$url);
            }
        }
        //var_dump($categoryArray);
        return array($categoryArray);
    }
}
function ChooseCategoryLabel($categoryName, $categoryAlias)
{
    $return = $categoryName;
    if (isset($categoryAlias) && strlen($categoryAlias) > 0) {
        $return = $categoryAlias;
    }
    return $return;
}
//GetRelatedBrandsSimple
//Author: Matthew Penn
//Date: July 25, 2018
//Summary: This "GetRelatedBrands" function bases it's query on the passed in Category, instead of brand.
//This query matches the older related sidebar better.
function GetRelatedBrandsSimple($wherestring, $returnQty, $based, $lang = 'EN')
{
    global $config, $inventoryDb;
    $lang = new Language();
    //$wherestring = $inventoryDb->real_escape_string($wherestring);
    $prefix = $config->cat_brand_prefix;
    if (!isset($prefix) || $prefix == "") {
        $prefix = "en_";
    } else {
        $prefix .= "_";
    }

    if ($lang->getLanguageSession() == "ES" or $lang == 'ES') {
        $alias = 'sp_alias';
        //$brandlist = 'spbrandlist'; //to-do add in spanish brand names when they are finished populating.
        $url = 'sp_url';
    } else {
        $url = 'en_url';
        //$brandlist = 'brandlist';
        $alias = 'en_alias';
    }


    if ($based == "brand") {
        $sql = "
                SELECT
            brands1.brandlist AS relatedBrandName4,
            brands1.$alias AS alias4,
            brands1.$url AS url4,
            brands2.brandlist AS relatedBrandName2,
            brands2.$alias AS alias2,
            brands2.$url AS url2,
            brands3.brandlist AS relatedBrandName3,
            brands3.$alias AS alias3,
            brands3.$url AS url3,
            brands.$alias AS alias1,
            brands.$url AS url1,
            brands.brandlist AS relatedBrandName1
        FROM
            brands
        JOIN brands AS brands1 ON brands.relatedbrand1 = brands1.id
        JOIN brands AS brands2 ON brands.relatedbrand2 = brands2.id
        JOIN brands AS brands3 ON brands.relatedbrand3 = brands3.id
        
        WHERE
            brands.brandlist = '" . $wherestring . "'";
        //echo $sql;
    } elseif ($based == "category") {
        $sql = "SELECT 
                    brands1." . $config->cat_brand_prefix . "brandlist AS relatedBrandName4, 
                    brands1." . $prefix . "alias AS alias4, 
                    brands1." . $prefix . "url AS url4, 
                    brands2." . $config->cat_brand_prefix . "brandlist AS relatedBrandName2, 
                    brands2." . $prefix . "alias AS alias2, 
                    brands2." . $prefix . "url AS url2, 
                    brands3." . $config->cat_brand_prefix . "brandlist AS relatedBrandName3, 
                    brands3." . $prefix . "alias AS alias3, 
                    brands3." . $prefix . "url AS url3, 
                    brands4." . $config->cat_brand_prefix . "brandlist AS relatedBrandName1, 
                    brands4." . $prefix . "alias AS alias1, 
                    brands4." . $prefix . "url AS url1
            FROM category as cat
             join brands as brands1 on cat.relatedbrand1 = brands1.id 
             join brands as brands2 on cat.relatedbrand2 = brands2.id 
             join brands as brands3 on cat.relatedbrand3 = brands3.id
             join brands as brands4 on cat.relatedbrand4 = brands4.id  
            WHERE cat.category_list = '" . $wherestring . "'";
        //echo $sql;
    } elseif ($based == "item") {
        echo "item query here";
    }
    $brandQuery = $inventoryDb->query($sql);
    $brandResult = $brandQuery->fetch_object();
    if (isset($brandResult)) {
        //if we are showing the source category, let's add it first.
        $i = 0;
        for ($i = $i; $i < $returnQty + 1; $i++) {
            $brandName = "relatedBrandName" . $i;
            $alias = "alias" . $i;
            $url = "url" . $i;
            if (isset($brandResult->$url) && (isset($brandResult->$brandName))) {
                $brandArray[] = array("name" => ChooseCategoryLabel($brandResult->$brandName, $brandResult->$alias), "url" => $brandResult->$url);
            }
        }
        return array($brandArray);
    }
}
function GetItemUrl($itemId, $lang = 'EN')
{
    global $inventoryPDO;
    $url = "";

    if ($lang == "ES") {
        $size_unit = "size_unit_es";
        $suffix = "_es";
    } else {
        $size_unit = "size_unit";
        $suffix = "";
    }
    if (isset($itemId)) {
        //$sqlQuery = "SELECT id, brand, model, $size_unit AS size_unit, list1 FROM inven WHERE id = :id";
        $sqlQuery = "
        SELECT
            inven.id, 
            brand, 
            model, 
            $size_unit AS size_unit, 
            list1, 
            category.spcategory_list
        FROM
            inven
            LEFT JOIN
            category
            ON 
                inven.list1 = category.category_list
        WHERE
            inven.id = :id";
        $stmt = $inventoryPDO->prepare($sqlQuery);
        $stmt->bindParam(":id", $itemId);
        $stmt->execute();
        $item = $stmt->fetch(PDO::FETCH_OBJ);
        $brand = $item->brand;
        $size = $item->model;
        $sizeUnit = $item->size_unit;
        if ($lang == "ES") {
            $cat = $item->spcategory_list;
        } else {
            $cat = $item->list1;
        }

        $url = "id";
        $url .= "_" . $itemId;
        $url .= "_" . $brand;
        $url .= "_" . str_replace("#", "", $size);
        $url .= "_" . $sizeUnit;
        $url .= "_" . $cat;
        $url .= $suffix;
        $url = str_replace(" ", "+", $url);
        $url = str_replace("/", "+", $url);
        return $url;
    } else {
        return false;
    }
}
function CreateItemPDFrfq($itemId, $quotePrice, $quoteId, $includeSearchAssistText = true)
{
    ini_set("memory_limit", "128M");
    error_log('CreateItemPDFrfq for ' . $itemId . 'for ' . $quotePrice);
    global $config, $pdfFilepath2;
    $filePath = $_SERVER['DOCUMENT_ROOT'] . $pdfFilepath2;
    $uid = md5(uniqid(time()));
    $filename = 'DieCastMachinery-' . $itemId . "-" . $uid . '.pdf';
    ob_clean();
    $mpdf = new \Mpdf\Mpdf();
    //$mpdf = new mPDF('', 'Letter', 0, '', 13, 13, 0, 13, 10, 10);
    $mpdf->packTableData = true; //added DEc. 29 2016
    $htmlHeader = '<table width="100%"><tr>';
    $htmlHeader .= '<td width="50%" style="font-size: 9pt;"><a href="' . $config->baseURL . '"><img src="' . $config->baseURL . '/images/dcm-logo.png" height="300px"/><br>www.diecastmachinery.com</a></td>';
    $htmlHeader .= '<td width="50%" style="text-align: right; font-size: 9pt;"><span style="text-align: right;">3246 West Monroe Street<br>Waukegan, IL 60085-3029 USA<br>1-847-360-9170 Phone<br>1-847-360-9189 Fax</td>';
    $htmlHeader .= '</tr><tr><td colspan="2"><hr style="height:45px;"></td></tr></table>';
    $mpdf->SetHTMLHeader($htmlHeader);
    $mpdf->pagenumPrefix = 'Page ';
    $mpdf->pagenumSuffix = ' ';
    $mpdf->nbpgPrefix = ' of ';
    $mpdf->nbpgSuffix = '';
    $htmlFooter = '<table border="0" cellpadding="0" cellspacing="0" width="100%" style="border-top: solid 1px #000000;"><tr>';
    $htmlFooter .= '<td width="25%" style="text-align: left; font-size: 9pt; font-style: italic;"><a href="' . $config->baseURL . '">www.diecastmachinery.com</a></td>';
    $htmlFooter .= '<td style="text-align: center; font-size: 9pt; font-style: italic;">{PAGENO}{nbpg}</td>';
    $htmlFooter .= '<td></td>';
    $htmlFooter .= '</tr></table>';
    $mpdf->SetHTMLFooter("<div style='height: 60px;'></div>" . $htmlFooter);
    include_once("functions.itemprint.inc.php"); //for printing product PDFs - Matt Added 4/29/2016    
    $itemHtml = GetItemHtml4PrintPagePDF($itemId, true, $quotePrice, $includeSearchAssistText);
    $mpdf->WriteHTML($itemHtml);
    $mpdf->Output($filePath . $filename);
    error_log($filename);
    return $filename;
}
function ReturnItemData($itemId)
{
    global $inventoryDb, $detect, $purchaseAgreement, $config;
    $debug = false;
    //$sql = "SELECT * FROM inven WHERE id = " . $itemId;
    $sql = "SELECT *
            FROM
            inven
            LEFT JOIN inven_machine_type ON inven.machine_type_id = inven_machine_type.id
            WHERE inven.id = $itemId";
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = get_object_vars($machineResult);
    return $result;
}
function ReturnSeoData($itemId)
{
    global $inventoryDb, $detect, $purchaseAgreement, $config;
    $itemSEO = InventoryPatternMerge($itemId, false);
    //var_dump($itemSEO);
    //die;
    $result = get_object_vars($itemSEO);
    return $result;
    //var_dump($result);
}
function GetItemCategory($itemId, $lang = 'EN')
{
    global $inventoryDb;
    $sql = "SELECT list1 FROM inven WHERE id = " . $itemId;
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = get_object_vars($machineResult);
    $list1 = $machineResult->list1;
    return $list1;
}
function GetItemBrand2($itemId)
{
    global $inventoryDb;
    $sql = "SELECT brand FROM inven WHERE id = " . $itemId;
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = $machineResult->brand;
    return $result;
}
function CategorySellBoxYN($category)
{
    global $inventoryDb;
    $sql = "SELECT sellboxYN, sellboxURL, sellboxText FROM category WHERE category_list = '" . $category . "'";
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    return $machineResult;
}
/*
function GetItemBrand ($itemId)
{
     global $inventoryDb;
    $sql = "SELECT brand FROM inven WHERE id = " . $itemId;
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = get_object_vars($machineResult);
    $brand = $machineResult->brand;
    return $list1;
}
*/
function GetItemHtmlDisplay($itemId, $quotePrice)
{
    global $inventoryDb, $inventoryImagesPath, $infoEmail, $webaddress, $purchaseAgreement, $config;
    $merge = InventoryPatternMerge($itemId, false);
    $sql = "SELECT * FROM inven WHERE id = " . $itemId;
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = get_object_vars($machineResult);
    // Section Titles
    $titleSpecifications = GetTranslation("item-title-specifications");
    $titleMeasurements = GetTranslation("item-title-measurements");
    $titleOptionalEquip = GetTranslation("item-title-optional-equipment");
    $titleTermsOfSale = GetTranslation("item-title-terms-of-sale");
    $titleDescription = GetTranslation("item-title-description");
    $titleFeaturesAccessories = GetTranslation("item-title-features-and-accessories");
    $titleDocuments = GetTranslation("item-title-documents");
    $titleCADDocuments = GetTranslation("item-title-cad-documents");
    $titlePrice = GetTranslation("item-title-price");
    $titleShippingTerms = GetTranslation("item-title-shipping-terms");
    $titleIdPrefix = GetTranslation("item-title-id-prefix");
    $titleStatus = GetTranslation("item-title-status");
    $titleStatusAvailable = GetTranslation("item-title-status-available");
    $titleStatusSold = GetTranslation("item-title-status-sold");
    $titleClickImage = GetTranslation("item-title-click-image");
    $titleForSale = GetTranslation("we_offer_for_sale");
    $shortdesc = $merge->short_desc; //$machineResult->shortdesc;
    $catdesc = $merge->catalog_desc; //$machineResult->catdesc;
    $title1 = $merge->title_line1; //$machineResult->title1;
    $title2 = $merge->title_line2; //$machineResult->title2;
    $title3 = $machineResult->title3;
    $searchAssisstTitle = GetTranslation("item-title-search-assist");
    $feature1 = $machineResult->feature1;
    $feature2 = $machineResult->feature2;
    $feature3 = $machineResult->feature3;
    $feature4 = $machineResult->feature4;
    $feature5 = $machineResult->feature5;
    $feature6 = $machineResult->feature6;
    $id = $machineResult->id;
    $picid = $machineResult->id;
    $contact1 = $machineResult->contact1;
    $contactid = $machineResult->contactid;
    $sellparty1 = $machineResult->sellparty1;
    $sellpartyid = $machineResult->sellpartyid;
    $jointventure = $machineResult->jointventure;
    $jointventureid = $machineResult->jointventureid;
    $jointpercent = $machineResult->jointpercent;
    $list1 = $machineResult->list1;
    $list2 = $machineResult->list2;
    $list3 = $machineResult->list3;
    $list4 = $machineResult->list4;
    $list5 = $machineResult->list5;
    $list6 = $machineResult->list6;
    $list7 = $machineResult->list7;
    $list8 = $machineResult->list8;
    $status = $machineResult->status;
    $shipterms = $machineResult->shipterms;
    $saletype = $machineResult->saletype;
    $stockdate = $machineResult->stockdate;
    $askprice = $machineResult->askprice;
    $minprice = $machineResult->minprice;
    $quoteprice = $machineResult->quoteprice;
    $soldprice = $machineResult->soldprice;
    $solddate = $machineResult->solddate;
    $soldtocontact = $machineResult->soldtocontact;
    $soldtoid = $machineResult->soldtoid;
    $brand = $machineResult->brand;
    $model = $machineResult->model;
    $showweb = $machineResult->showweb;
    $privatenotes = $machineResult->privatenotes;
    $catalogshow = $machineResult->catalogshow;
    $spectext1 = $machineResult->spectext1;
    $spectext2 = $machineResult->spectext2;
    $spectext3 = $machineResult->spectext3;
    $spectext4 = $machineResult->spectext4;
    $spectext5 = $machineResult->spectext5;
    $spectext6 = $machineResult->spectext6;
    $spectext7 = $machineResult->spectext7;
    $spectext8 = $machineResult->spectext8;
    $spectext9 = $machineResult->spectext9;
    $spectext10 = $machineResult->spectext10;
    $spectext11 = $machineResult->spectext11;
    $spectext12 = $machineResult->spectext12;
    $specus1 = $machineResult->specus1;
    $specus2 = $machineResult->specus2;
    $specus3 = $machineResult->specus3;
    $specus4 = $machineResult->specus4;
    $specus5 = $machineResult->specus5;
    $specus6 = $machineResult->specus6;
    $specus7 = $machineResult->specus7;
    $specus8 = $machineResult->specus8;
    $specus9 = $machineResult->specus9;
    $specus10 = $machineResult->specus10;
    $specus11 = $machineResult->specus11;
    $specus12 = $machineResult->specus12;
    $specmetric1 = $machineResult->specmetric1;
    $specmetric2 = $machineResult->specmetric2;
    $specmetric3 = $machineResult->specmetric3;
    $specmetric4 = $machineResult->specmetric4;
    $specmetric5 = $machineResult->specmetric5;
    $specmetric6 = $machineResult->specmetric6;
    $specmetric7 = $machineResult->specmetric7;
    $specmetric8 = $machineResult->specmetric8;
    $specmetric9 = $machineResult->specmetric9;
    $specmetric10 = $machineResult->specmetric10;
    $specmetric11 = $machineResult->specmetric11;
    $specmetric12 = $machineResult->specmetric12;
    $pictures = $machineResult->pictures;
    $webprice = $machineResult->webprice;
    $webpricedesc = $machineResult->webpricedesc;
    $contacttest = $machineResult->contacttest;
    $boxlength = $machineResult->boxlength;
    $boxwidth = $machineResult->boxwidth;
    $boxsqft = $machineResult->boxsqft;
    $warehousedate = $machineResult->warehousedate;
    $datepurchased = $machineResult->datepurchased;
    $pricepaid = $machineResult->pricepaid;
    $rigging = $machineResult->rigging;
    $optionalequip1 = $machineResult->optionalequip1;
    $optionalequip2 = $machineResult->optionalequip2;
    $optionalequip3 = $machineResult->optionalequip3;
    $optionalequip4 = $machineResult->optionalequip4;
    $optionalequip5 = $machineResult->optionalequip5;
    $optionalequip6 = $machineResult->optionalequip6;
    $optionalequiplink1 = $machineResult->optionalequiplink1;
    $optionalequiplink2 = $machineResult->optionalequiplink2;
    $optionalequiplink3 = $machineResult->optionalequiplink3;
    $optionalequiplink4 = $machineResult->optionalequiplink4;
    $optionalequiplink5 = $machineResult->optionalequiplink5;
    $optionalequiplink6 = $machineResult->optionalequiplink6;
    if ($status == "Available") {
        $status = "<span style='color: green; font-weight: bold;'>" . $titleStatusAvailable . "</span>";
    } else {
        $status = "<span style='color: red; font-weight: bold;'>" . $titleStatusSold . "</span>";
    }
    $tableHeaderColor = "#5A5B5B";
    $tableHeaderTextColor = "#FFFFFF";
    $tableCellColor1 = "#DAD8D8";
    $tableCellColor2 = "#FFE157";
    $itemHtml = "<script src='js/jquery.unveil.js'></script>\n";
    $itemHtml .= "\n" . '<table class="table table-condensed" border="0" width="99%" cellpadding="2" cellmargin="2" style="margin: 0px; border-spacing: 2px !IMPORTANT; border-collapse: separate !IMPORTANT;">' . "\n";
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><div class="itemTitle22">' . $titleIdPrefix . ' ' . $id . '</div></td></tr>' . "\n";
    if (strlen($titleForSale) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titleForSale . '</td></tr>' . "\n";
    }
    if (strlen($title1) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle1"><h1>' . $title1 . '</h1></td></tr>' . "\n";
    }
    if (strlen($title2) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle2"><h2>' . $title2 . '</h2></td></tr>' . "\n";
    }
    if (strlen($title3) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle3"><h3>' . $title3 . '</h3></td></tr>' . "\n";
    }
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><span style="font-weight: bold;">' . $titleStatus . '</span> ' . $status . '</td></tr>' . "\n";
    if (strlen($spectext1) > 0) {
        $itemHtml .= '<tr><td width="40%" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleSpecifications . '</td>' . "\n";
        $itemHtml .= '<td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleMeasurements . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["spectext" . $i])) {
                $itemHtml .= '<tr><td style="text-align: left; background-color: ' . $tableCellColor1 . '; vertical-align: top;">' . $result["spectext" . $i] . '</td>' . "\n";
                $itemHtml .= '<td style="text-align: left; background-color: ' . $tableCellColor2 . ';">' . $result["specmetric" . $i] . ' <span style="color: red;">/</span> <span style="color: darkblue;">' . $result["specus" . $i] . '</span></td></tr>' . "\n";
            }
        }
    }
    if (strlen($result["feature1"]) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleFeaturesAccessories . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["feature" . $i])) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $result["feature" . $i] . '</td></tr>' . "\n";
            }
        }
    }
    if (
        strlen($result["optionalequip1"]) > 0 ||
        strlen($result["optionalequip2"]) > 0 ||
        strlen($result["optionalequip3"]) > 0 ||
        strlen($result["optionalequip4"]) > 0 ||
        strlen($result["optionalequip5"]) > 0 ||
        strlen($result["optionalequip6"]) > 0
    ) {
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleOptionalEquip . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["optionalequip" . $i]) > 0) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a href="' . $config->baseURL . '/machineshow.php?id=' . $result["optionalequiplink" . $i] . '">' . $result["optionalequip" . $i] . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** PDF DOCUMENTS ROW ***
    if (itemHasFilesWithExtension($itemId, ".pdf")) {
        $fileQuery = GetAttachedFiles($itemId);
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleDocuments . '</td></tr>' . "\n";
        while ($file = $fileQuery->fetch_object()) {
            if (endsWith($file->file_name, ".pdf")) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a target="_blank" href="' . $config->baseURL . '/UserFiles/InventoryFiles/' . $file->file_path . '/' . $file->file_name . '">' . $file->file_name . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** CAD DOCUMENTS ROW ***
    if (itemHasFilesWithExtension($itemId, ".skp")) {
        $fileQuery = GetAttachedFiles($itemId);
        $itemHtml .= '<tr><td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleCADDocuments . '</td>' . "\n";
        $itemHtml .= '<td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none; text-align: right;"><a href="http://www.sketchup.com" style="color: white;" target="_blank">Download Google SketchUp</a></td></tr>' . "\n";
        while ($file = $fileQuery->fetch_object()) {
            if (endsWith($file->file_name, ".skp")) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a target="_blank" href="' . $config->baseURL . '/UserFiles/InventoryFiles/' . $file->file_path . '/' . $file->file_name . '">' . $file->file_name . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** TERMS OF SALE ***
    $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleTermsOfSale . '</td></tr>' . "\n";
    if ($webprice) {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' ' . $askprice . '</td></tr>' . "\n";
    } else {
        //$itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' <a href="additem.php?id=' . $id . '" style="text-decoration: underline;"><b>request quotation</b></a></td></tr>' . "\n";

        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' <a data-itemid=' . $id . '" class="linkShowItemCart"  style="text-decoration: underline;"><b>request quotation</b></a></td></tr>' . "\n";
    }
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titleShippingTerms . ' ' . $shipterms . "\n";
    $itemHtml .= "<p>" . $merge->international_shipping . '</p></td></tr>' . "\n";
    $itemHtml .= '</table>' . "\n";
    if (isset($machineResult->youtube) && strlen($machineResult->youtube) > 0) {
        $itemHtml .= "<br/><div class='embed-responsive embed-responsive-16by9' style='text-align: center;'>" . $machineResult->youtube . "</div>" . "\n";
    }
    if ($machineResult->pictures == "yes") {
        $itemHtml .= "<br/><div class='row'>\n";
        $itemHtml .= "<div class='col-lg-offset-2 col-lg-8 pictureList'>\n";
        $itemHtml .= "<div style='text-align: center;'>" . $titleClickImage . "</div>" . "\n<br\><center><br\>\n";
        for ($i = 1; $i < 25; $i = $i + 2) {
            $picUrl = $config->inventoryImagesPath;
            $picFilename1 = $id . '-' . $i . '.jpg';
            $picFilename2 = $id . '-' . ($i + 1) . '.jpg';
            $pic1Exists = false;
            if (file_exists("." . $config->inventoryImagesPath . $picFilename1) || file_exists("../.." . $config->inventoryImagesPath . $picFilename1) || file_exists(".." . $config->inventoryImagesPath . $picFilename1)) {
                $pic1Exists = true;
                $itemHtml .= "<a href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-" . $i . "&itemid=" . $id . "&picnum=1' target='_blank'>";
                $itemHtml .= '<img class="lazyLoad" src="includes/loading.gif" data-src="' . $picUrl . $picFilename1 . '" alt="' . $shortdesc . ' used 1" style="min-width: 275px; padding: 4px;" />' . "</a>\n&nbsp;&nbsp;\n";
            }
            if (file_exists("." . $config->inventoryImagesPath . $picFilename2) || file_exists("../.." . $config->inventoryImagesPath . $picFilename2) || file_exists(".." . $config->inventoryImagesPath . $picFilename2)) {
                $itemHtml .= "<a href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-" . ($i + 1) . "&itemid=" . $id . "&picnum=1' target='_blank'>";
                $itemHtml .= '<img class="lazyLoad" src="includes/loading.gif" data-src="' . $picUrl . $picFilename2 . '" alt="' . $shortdesc . ' used 1" style="min-width: 275px; padding: 4px;" />' . "</a><br\>\n";
            }
        }
        $itemHtml .= "</center>\n";
        $itemHtml .= "</div>\n";
        $itemHtml .= "</div>\n";
    }
    $itemHtml .= "<p><div style='text-align: left;'>" . $titleDescription . $catdesc . "</div>" . "\n";
    if (strlen($merge->search_assist) > 0) {
        $itemHtml .= "<br/><div style='text-align: left; margin-top=: 5px;'>";
        $itemHtml .= $searchAssisstTitle . $merge->search_assist;
        $itemHtml .= "</div>" . "\n";
    }
    $itemHtml .= "<div style='text-align: left; margin-top=: 5px;'>";
    $itemHtml .= '<br/><p>' . $purchaseAgreement . '</p>';
    $itemHtml .= "</div>" . "\n";
    $itemHtml .= "<script>\n";
    $itemHtml .= "$(function() {\n";
    $itemHtml .= '  $("img").unveil();';
    $itemHtml .= "});\n";
    $itemHtml .= "</script>\n";
    return $itemHtml;
}
function InventoryPatternMerge($id, $debug)
{
    global $inventoryDb, $config, $inventoryPDO;
    $itemSEO = new ItemSeoObj();
    $itemSEO->seo_page_title = "";
    $itemSEO->pdf_title = "";
    $itemSEO->pdf_subject = "";
    $itemSEO->pdf_keywords = "";
    $itemSEO->seo_meta_desc = "";
    $itemSEO->seo_meta_keywords = "";
    $itemSEO->seo_meta_header = "";
    $itemSEO->seo_meta_footer = "";
    $itemSEO->short_desc = "";
    $itemSEO->catalog_desc = "";
    $itemSEO->search_assist = "";
    $itemSEO->international_shipping = "";
    $itemSEO->title_line1 = "";
    $itemSEO->title_line2 = "";
    $itemSEO->title_line3 = "";
    $itemSEO->picture_page_title = "";
    $itemSEO->picture_meta_desc = "";
    $itemSEO->picture_meta_header = "";
    $itemSEO->picture_meta_keywords = "";
    $itemSEO->picture_1_alt_text = "";
    $itemSEO->picture_2_alt_text = "";
    $itemSEO->picture_3_alt_text = "";
    $itemSEO->picture_4_alt_text = "";
    $itemSEO->picture_5_alt_text = "";
    $itemSEO->picture_6_alt_text = "";
    $itemSEO->picture_caption = "";
    $itemSEO->item_size = "";
    $sqlQuery = "SELECT inven_machine_type_category.name as category, inven_machine_type.short_desc, inven_machine_type.long_desc, inven.* 
                 FROM inven 
                    left outer join inven_machine_type on inven.machine_type_id = inven_machine_type.id 
                    left outer join inven_machine_type_category on inven_machine_type.category_id = inven_machine_type_category.id 
                 WHERE inven.id = " . $id;
    // error_log($sqlQuery);
    $stmt = $inventoryPDO->prepare($sqlQuery);
    $stmt->execute();
    $item = $stmt->fetch(PDO::FETCH_BOTH);
    if (!isset($item))
        return $itemSEO;
    $sqlQuery = "SELECT * FROM inven_global_patterns WHERE id=1";
    $stmt = $inventoryPDO->prepare($sqlQuery);
    $stmt->execute();
    $patterns = $stmt->fetch(PDO::FETCH_BOTH);
    if (!isset($patterns)) {
        return $itemSEO;
    }
    $useMachineType = $item["use_machine_type"];
    if (!isset($useMachineType) || $useMachineType == 0) {
        // Pattern codes
        $itemSEO->seo_page_title_code = "[page_title]";
        $itemSEO->pdf_title_code = "[pdf_title]";
        $itemSEO->pdf_subject_code = "[pdf_subject]";
        $itemSEO->pdf_keywords_code = "[pdf_keywords]";
        $itemSEO->pdf_title = $item["page_title"];
        $itemSEO->pdf_subject = $item["meta_desc"];
        $itemSEO->pdf_keywords = $item["meta_keywords"];
        $itemSEO->seo_meta_desc_code = "[meta_desc]";
        $itemSEO->seo_meta_keywords_code = "[meta_keywords]";
        $itemSEO->seo_meta_header_code = "[head_alt_tag]";
        $itemSEO->seo_meta_footer_code = "";
        $itemSEO->short_desc_code = "[shortdesc]";
        $itemSEO->catalog_desc_code = "[catdesc]";
        $itemSEO->search_assist_code = "";
        $itemSEO->international_shipping_code = "";
        $itemSEO->title_line1_code = "[title1]";
        $itemSEO->title_line2_code = "[title2]";
        $itemSEO->title_line3_code = "[title3]";
        $itemSEO->picture_page_title_code = "[page_title]";
        $itemSEO->picture_meta_desc_code = "[head_alt_tag]";
        $itemSEO->picture_meta_header_code = "[head_alt_tag]";
        $itemSEO->picture_meta_keywords_code = "[meta_keywords]";
        $itemSEO->picture_1_alt_text_code = "[shortdesc]";
        $itemSEO->picture_2_alt_text_code = "[shortdesc]";
        $itemSEO->picture_3_alt_text_code = "[shortdesc]";
        $itemSEO->picture_4_alt_text_code = "[shortdesc]";
        $itemSEO->picture_5_alt_text_code = "[shortdesc]";
        $itemSEO->picture_6_alt_text_code = "[shortdesc]";
        $itemSEO->picture_caption_code = "";
        $itemSEO->seo_page_title = $item["page_title"];
        $itemSEO->seo_meta_desc = $item["meta_desc"];
        $itemSEO->seo_meta_keywords = $item["meta_keywords"];
        $itemSEO->seo_meta_header = $item["head_alt_tag"];
        $itemSEO->seo_meta_footer = "";
        $itemSEO->short_desc = $item["shortdesc"];
        $itemSEO->catalog_desc = $item["catdesc"];
        $itemSEO->search_assist = "";
        $itemSEO->international_shipping = "";
        $itemSEO->title_line1 = $item["title1"];
        $itemSEO->title_line2 = $item["title2"];
        $itemSEO->title_line3 = $item["title3"];
        $itemSEO->picture_page_title = $item["meta_desc"];
        $itemSEO->picture_meta_desc = $item["meta_desc"];
        $itemSEO->picture_meta_header = $item["head_alt_tag"];
        $itemSEO->picture_meta_keywords = $item["meta_keywords"];
        $itemSEO->picture_1_alt_text = $item["shortdesc"];
        $itemSEO->picture_2_alt_text = $item["shortdesc"];
        $itemSEO->picture_3_alt_text = $item["shortdesc"];
        $itemSEO->picture_4_alt_text = $item["shortdesc"];
        $itemSEO->picture_5_alt_text = $item["shortdesc"];
        $itemSEO->picture_6_alt_text = $item["shortdesc"];
        $itemSEO->picture_caption = $item["meta_keywords"];
        $itemSEO->item_size = $item["model"] . " " . $item['size_unit'];
    } else {
        // Pattern codes
        $itemSEO->seo_page_title_code = $patterns["seo_page_title"];
        $itemSEO->pdf_title_code = $patterns["pdf_title"];
        $itemSEO->pdf_subject_code = $patterns["pdf_subject"];
        $itemSEO->pdf_keywords_code = $patterns["pdf_keywords"];
        $itemSEO->seo_meta_desc_code = $patterns["seo_meta_desc"];
        $itemSEO->seo_meta_keywords_code = $patterns["seo_meta_keywords"];
        $itemSEO->seo_meta_header_code = $patterns["seo_meta_header"];
        $itemSEO->seo_meta_footer_code = $patterns["seo_meta_footer"];
        $itemSEO->short_desc_code = $patterns["short_desc"];
        $itemSEO->catalog_desc_code = $patterns["catalog_desc"];
        $itemSEO->search_assist_code = $patterns["search_assist"];
        $itemSEO->international_shipping_code = $patterns["international_shipping"];
        $itemSEO->title_line1_code = $patterns["title_line1"];
        $itemSEO->title_line2_code = $patterns["title_line2"];
        $itemSEO->title_line3_code = $patterns["title_line3"];
        $itemSEO->picture_page_title_code = $patterns["picture_page_title"];
        $itemSEO->picture_meta_desc_code = $patterns["picture_meta_desc"];
        $itemSEO->picture_meta_header_code = $patterns["picture_meta_header"];
        $itemSEO->picture_meta_keywords_code = $patterns["picture_meta_keywords"];
        $itemSEO->picture_1_alt_text_code = $patterns["picture_1_alt_text"];
        $itemSEO->picture_2_alt_text_code = $patterns["picture_2_alt_text"];
        $itemSEO->picture_3_alt_text_code = $patterns["picture_3_alt_text"];
        $itemSEO->picture_4_alt_text_code = $patterns["picture_4_alt_text"];
        $itemSEO->picture_5_alt_text_code = $patterns["picture_5_alt_text"];
        $itemSEO->picture_6_alt_text_code = $patterns["picture_6_alt_text"];
        $itemSEO->picture_caption_code = $patterns["picture_caption"];
        // Replace [column_name]
        $itemSEO->seo_page_title = SubInvenTableColumns($patterns["seo_page_title"], $item, $debug);
        $itemSEO->pdf_title = SubInvenTableColumns($patterns["pdf_title"], $item, $debug);
        $itemSEO->pdf_subject = SubInvenTableColumns($patterns["pdf_subject"], $item, $debug);
        $itemSEO->pdf_keywords = SubInvenTableColumns($patterns["pdf_keywords"], $item, $debug);
        $itemSEO->seo_meta_desc = SubInvenTableColumns($patterns["seo_meta_desc"], $item, $debug);
        $itemSEO->seo_meta_keywords = SubInvenTableColumns($patterns["seo_meta_keywords"], $item, $debug);
        $itemSEO->seo_meta_header = SubInvenTableColumns($patterns["seo_meta_header"], $item, $debug);
        $itemSEO->seo_meta_footer = SubInvenTableColumns($patterns["seo_meta_footer"], $item, $debug);
        $itemSEO->short_desc = SubInvenTableColumns($patterns["short_desc"], $item, $debug);
        $itemSEO->catalog_desc = SubInvenTableColumns($patterns["catalog_desc"], $item, $debug);
        $itemSEO->search_assist = SubInvenTableColumns($patterns["search_assist"], $item, $debug);
        $itemSEO->international_shipping = SubInvenTableColumns($patterns["international_shipping"], $item, $debug);
        $itemSEO->title_line1 = SubInvenTableColumns($patterns["title_line1"], $item, $debug);
        $itemSEO->title_line2 = SubInvenTableColumns($patterns["title_line2"], $item, $debug);
        $itemSEO->title_line3 = SubInvenTableColumns($patterns["title_line3"], $item, $debug);
        $itemSEO->picture_page_title = SubInvenTableColumns($patterns["picture_page_title"], $item, $debug);
        $itemSEO->picture_meta_desc = SubInvenTableColumns($patterns["picture_meta_desc"], $item, $debug);
        $itemSEO->picture_meta_header = SubInvenTableColumns($patterns["picture_meta_header"], $item, $debug);
        $itemSEO->picture_meta_keywords = SubInvenTableColumns($patterns["picture_meta_keywords"], $item, $debug);
        $itemSEO->picture_1_alt_text = SubInvenTableColumns($patterns["picture_1_alt_text"], $item, $debug);
        $itemSEO->picture_2_alt_text = SubInvenTableColumns($patterns["picture_2_alt_text"], $item, $debug);
        $itemSEO->picture_3_alt_text = SubInvenTableColumns($patterns["picture_3_alt_text"], $item, $debug);
        $itemSEO->picture_4_alt_text = SubInvenTableColumns($patterns["picture_4_alt_text"], $item, $debug);
        $itemSEO->picture_5_alt_text = SubInvenTableColumns($patterns["picture_5_alt_text"], $item, $debug);
        $itemSEO->picture_6_alt_text = SubInvenTableColumns($patterns["picture_6_alt_text"], $item, $debug);
        $itemSEO->picture_caption = SubInvenTableColumns($patterns["picture_caption"], $item, $debug);
        // Replace {translation_text}
        $itemSEO->seo_page_title = SubTranslations($itemSEO->seo_page_title, $debug);
        $itemSEO->pdf_title = SubTranslations($itemSEO->pdf_title, $debug);
        $itemSEO->pdf_subject = SubTranslations($itemSEO->pdf_subject, $debug);
        $itemSEO->pdf_keywords = SubTranslations($itemSEO->pdf_keywords, $debug);
        $itemSEO->seo_meta_desc = SubTranslations($itemSEO->seo_meta_desc, $debug);
        $itemSEO->seo_meta_keywords = SubTranslations($itemSEO->seo_meta_keywords, $debug);
        $itemSEO->seo_meta_header = SubTranslations($itemSEO->seo_meta_header, $debug);
        $itemSEO->seo_meta_footer = SubTranslations($itemSEO->seo_meta_footer, $debug);
        $itemSEO->short_desc = SubTranslations($itemSEO->short_desc, $debug);
        $itemSEO->catalog_desc = SubTranslations($itemSEO->catalog_desc, $debug);
        $itemSEO->search_assist = SubTranslations($itemSEO->search_assist, $debug);
        $itemSEO->international_shipping = SubTranslations($itemSEO->international_shipping, $debug);
        $itemSEO->title_line1 = SubTranslations($itemSEO->title_line1, $debug);
        $itemSEO->title_line2 = SubTranslations($itemSEO->title_line2, $debug);
        $itemSEO->title_line3 = SubTranslations($itemSEO->title_line3, $debug);
        $itemSEO->picture_page_title = SubTranslations($itemSEO->picture_page_title, $debug);
        $itemSEO->picture_meta_desc = SubTranslations($itemSEO->picture_meta_desc, $debug);
        $itemSEO->picture_meta_header = SubTranslations($itemSEO->picture_meta_header, $debug);
        $itemSEO->picture_meta_keywords = SubTranslations($itemSEO->picture_meta_keywords, $debug);
        $itemSEO->picture_1_alt_text = SubTranslations($itemSEO->picture_1_alt_text, $debug);
        $itemSEO->picture_2_alt_text = SubTranslations($itemSEO->picture_2_alt_text, $debug);
        $itemSEO->picture_3_alt_text = SubTranslations($itemSEO->picture_3_alt_text, $debug);
        $itemSEO->picture_4_alt_text = SubTranslations($itemSEO->picture_4_alt_text, $debug);
        $itemSEO->picture_5_alt_text = SubTranslations($itemSEO->picture_5_alt_text, $debug);
        $itemSEO->picture_6_alt_text = SubTranslations($itemSEO->picture_6_alt_text, $debug);
        $itemSEO->picture_caption = SubTranslations($itemSEO->picture_caption, $debug);
        if (isset($item["model"])) {
            $itemSEO->item_size = $item["model"] . " " . $item['size_unit'];
        }
        if ($debug) {
            $leftBracket = '<span style="color: red;">(</span>';
            $rightBracket = '<span style="color: red;">)</span>';
        } else {
            $leftBracket = "";
            $rightBracket = "";
        }
        // Replace (Machine_Type_Long)
        $itemSEO->seo_page_title = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->seo_page_title);
        $itemSEO->pdf_title = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->pdf_title);
        //$itemSEO->pdf_subject = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->pdf_subject);
        //$itemSEO->pdf_keywords = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->pdf_keywords);
        $itemSEO->seo_meta_desc = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->seo_meta_desc);
        $itemSEO->seo_meta_keywords = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->seo_meta_keywords);
        $itemSEO->seo_meta_header = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->seo_meta_header);
        $itemSEO->seo_meta_footer = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->seo_meta_footer);
        $itemSEO->short_desc = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->short_desc);
        $itemSEO->catalog_desc = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->catalog_desc);
        $itemSEO->search_assist = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->search_assist);
        $itemSEO->international_shipping = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->international_shipping);
        $itemSEO->title_line1 = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->title_line1);
        $itemSEO->title_line2 = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->title_line2);
        $itemSEO->title_line3 = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->title_line3);
        $itemSEO->picture_page_title = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_page_title);
        $itemSEO->picture_meta_desc = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_meta_desc);
        $itemSEO->picture_meta_header = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_meta_header);
        $itemSEO->picture_meta_keywords = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_meta_keywords);
        $itemSEO->picture_1_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_1_alt_text);
        $itemSEO->picture_2_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_2_alt_text);
        $itemSEO->picture_3_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_3_alt_text);
        $itemSEO->picture_4_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_4_alt_text);
        $itemSEO->picture_5_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_5_alt_text);
        $itemSEO->picture_6_alt_text = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_6_alt_text);
        $itemSEO->picture_caption = str_replace("(Machine_Type_Long)", $leftBracket . $item["long_desc"] . $rightBracket, $itemSEO->picture_caption);
        // Replace (Machine_Type_Short)
        $itemSEO->seo_page_title = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->seo_page_title);
        //$itemSEO->pdf_title = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->pdf_title);
        //$itemSEO->pdf_subject = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->pdf_subject);
        //$itemSEO->pdf_keywords = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->pdf_keywords);
        $itemSEO->seo_meta_desc = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->seo_meta_desc);
        $itemSEO->seo_meta_keywords = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->seo_meta_keywords);
        $itemSEO->seo_meta_header = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->seo_meta_header);
        $itemSEO->seo_meta_footer = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->seo_meta_footer);
        $itemSEO->short_desc = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->short_desc);
        $itemSEO->catalog_desc = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->catalog_desc);
        $itemSEO->search_assist = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->search_assist);
        $itemSEO->international_shipping = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->international_shipping);
        $itemSEO->title_line1 = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->title_line1);
        $itemSEO->title_line2 = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->title_line2);
        $itemSEO->title_line3 = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->title_line3);
        $itemSEO->picture_page_title = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_page_title);
        $itemSEO->picture_meta_desc = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_meta_desc);
        $itemSEO->picture_meta_header = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_meta_header);
        $itemSEO->picture_meta_keywords = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_meta_keywords);
        $itemSEO->picture_1_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_1_alt_text);
        $itemSEO->picture_2_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_2_alt_text);
        $itemSEO->picture_3_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_3_alt_text);
        $itemSEO->picture_4_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_4_alt_text);
        $itemSEO->picture_5_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_5_alt_text);
        $itemSEO->picture_6_alt_text = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_6_alt_text);
        $itemSEO->picture_caption = str_replace("(Machine_Type_Short)", $leftBracket . $item["short_desc"] . $rightBracket, $itemSEO->picture_caption);
    }
    return $itemSEO;
}
function SubInvenTableColumns($pattern, $item, $debug)
{
    $returnString = "";
    if ($debug) {
        $leftBracket = '<span style="color: red;">[</span>';
        $rightBracket = '<span style="color: red;">]</span>';
    } else {
        $leftBracket = "";
        $rightBracket = "";
    }
    $patternArray = explode("[", $pattern);
    if (count($patternArray) > 1) {
        $arrayCount = 0;
        foreach ($patternArray as $text) {
            if ($arrayCount != 0) {
                $column = substr($text, 0, strpos($text, "]"));
                $returnString .= $leftBracket . $item[$column] . $rightBracket . substr($text, strpos($text, "]") + 1);
            } else {
                if (substr($pattern, 0, 0) == "[") {
                    $column = substr($text, 0, strpos($text, "]"));
                    $returnString .= $leftBracket . $item[$column] . $rightBracket . substr($text, strpos($text, "]") + 1);
                } else {
                    $returnString .= $text;
                }
            }
            $arrayCount++;
        }
        return $returnString;
    } else {
        return $pattern;
    }
}
function SubTranslations($pattern, $debug)
{
    $returnString = "";
    if ($debug) {
        $leftBracket = '<span style="color: red;">{</span>';
        $rightBracket = '<span style="color: red;">}</span>';
    } else {
        $leftBracket = "";
        $rightBracket = "";
    }
    $patternArray = explode("{", $pattern);
    if (count($patternArray) > 1) {
        $arrayCount = 0;
        foreach ($patternArray as $text) {
            if ($arrayCount != 0) {
                $subKey = substr($text, 0, strpos($text, "}"));
                $returnString .= $leftBracket . GetInvenTranslation($subKey) . $rightBracket . substr($text, strpos($text, "}") + 1);
            } else {
                if (substr($pattern, 0, 0) == "{") {
                    $subKey = substr($text, 0, strpos($text, "}") - 1);
                    $returnString .= $leftBracket . GetInvenTranslation($subKey) . $rightBracket . substr($text, strpos($text, "}") + 1);
                } else {
                    $returnString .= $text;
                }
            }
            $arrayCount++;
        }
        return $returnString;
    } else {
        return $pattern;
    }
}
function GetInvenTranslation($key)
{
    global $inventoryPDO, $config;
    $sqlQuery = "SELECT * FROM inven_general_terms WHERE shortname = '" . $key . "'";
    $stmt = $inventoryPDO->prepare($sqlQuery);
    $stmt->execute();
    $row = $stmt->fetch();
    return $row[$config->country_code] ?? '';
}
function GetItemHtmlrfq($itemId, $isPdf, $quotePrice)
{
    global $inventoryDb, $detect, $purchaseAgreement, $config;
    //echo "Item ID: ".$itemId;
    $merge = InventoryPatternMerge($itemId, false);
    $sql = "SELECT * FROM inven WHERE id = " . $itemId;
    $machineQuery = $inventoryDb->query($sql);
    $machineResult = $machineQuery->fetch_object();
    $result = get_object_vars($machineResult);
    // if ($config->country_code != "en-US") {
    //     $prefix = $config->country_code . "_";
    // } else {
    //     $prefix = "";
    // }
    // Section Titles
    $titleSpecifications = GetTranslation("item-title-specifications");
    $titleMeasurements = GetTranslation("item-title-measurements");
    $titleOptionalEquip = GetTranslation("item-title-optional-equipment");
    $titleTermsOfSale = GetTranslation("item-title-terms-of-sale");
    $titleDescription = GetTranslation("item-title-description");
    $titleFeaturesAccessories = GetTranslation("item-title-features-and-accessories");
    $titleDocuments = GetTranslation("item-title-documents");
    $titleCADDocuments = GetTranslation("item-title-cad-documents");
    $titlePrice = GetTranslation("item-title-price");
    $titleShippingTerms = GetTranslation("item-title-shipping-terms");
    $titleIdPrefix = GetTranslation("item-title-id-prefix");
    $titleStatus = GetTranslation("item-title-status");
    $titleStatusAvailable = GetTranslation("item-title-status-available");
    $titleStatusSold = GetTranslation("item-title-status-sold");
    $titleClickImage = GetTranslation("item-title-click-image");
    $shortdesc = $merge->short_desc; //$machineResult->shortdesc;
    $catdesc = $merge->catalog_desc; //$machineResult->catdesc;
    $titleForSale = GetTranslation("we_offer_for_sale");
    $title1 = $merge->title_line1; //$machineResult->title1;	
    $title2 = $merge->title_line2; //$machineResult->title2;
    $title3 = $machineResult->title3;
    $searchAssisstTitle = GetTranslation("item-title-search-assist");
    $feature1 = $machineResult->feature1;
    $feature2 = $machineResult->feature2;
    $feature3 = $machineResult->feature3;
    $feature4 = $machineResult->feature4;
    $feature5 = $machineResult->feature5;
    $feature6 = $machineResult->feature6;
    $id = $machineResult->id;
    $picid = $machineResult->id;
    $contact1 = $machineResult->contact1;
    $contactid = $machineResult->contactid;
    $sellparty1 = $machineResult->sellparty1;
    $sellpartyid = $machineResult->sellpartyid;
    $jointventure = $machineResult->jointventure;
    $jointventureid = $machineResult->jointventureid;
    $jointpercent = $machineResult->jointpercent;
    $list1 = $machineResult->list1;
    $list2 = $machineResult->list2;
    $list3 = $machineResult->list3;
    $list4 = $machineResult->list4;
    $list5 = $machineResult->list5;
    $list6 = $machineResult->list6;
    $list7 = $machineResult->list7;
    $list8 = $machineResult->list8;
    $status = $machineResult->status;
    $shipterms = $machineResult->shipterms;
    $saletype = $machineResult->saletype;
    $stockdate = $machineResult->stockdate;
    $askprice = $machineResult->askprice;
    $minprice = $machineResult->minprice;
    $quoteprice = $machineResult->quoteprice;
    $soldprice = $machineResult->soldprice;
    $solddate = $machineResult->solddate;
    $soldtocontact = $machineResult->soldtocontact;
    $soldtoid = $machineResult->soldtoid;
    $brand = $machineResult->brand;
    $model = $machineResult->model;
    $showweb = $machineResult->showweb;
    $privatenotes = $machineResult->privatenotes;
    $catalogshow = $machineResult->catalogshow;
    $spectext1 = $machineResult->spectext1;
    $spectext2 = $machineResult->spectext2;
    $spectext3 = $machineResult->spectext3;
    $spectext4 = $machineResult->spectext4;
    $spectext5 = $machineResult->spectext5;
    $spectext6 = $machineResult->spectext6;
    $spectext7 = $machineResult->spectext7;
    $spectext8 = $machineResult->spectext8;
    $spectext9 = $machineResult->spectext9;
    $spectext10 = $machineResult->spectext10;
    $spectext11 = $machineResult->spectext11;
    $spectext12 = $machineResult->spectext12;
    $specus1 = $machineResult->specus1;
    $specus2 = $machineResult->specus2;
    $specus3 = $machineResult->specus3;
    $specus4 = $machineResult->specus4;
    $specus5 = $machineResult->specus5;
    $specus6 = $machineResult->specus6;
    $specus7 = $machineResult->specus7;
    $specus8 = $machineResult->specus8;
    $specus9 = $machineResult->specus9;
    $specus10 = $machineResult->specus10;
    $specus11 = $machineResult->specus11;
    $specus12 = $machineResult->specus12;
    $specmetric1 = $machineResult->specmetric1;
    $specmetric2 = $machineResult->specmetric2;
    $specmetric3 = $machineResult->specmetric3;
    $specmetric4 = $machineResult->specmetric4;
    $specmetric5 = $machineResult->specmetric5;
    $specmetric6 = $machineResult->specmetric6;
    $specmetric7 = $machineResult->specmetric7;
    $specmetric8 = $machineResult->specmetric8;
    $specmetric9 = $machineResult->specmetric9;
    $specmetric10 = $machineResult->specmetric10;
    $specmetric11 = $machineResult->specmetric11;
    $specmetric12 = $machineResult->specmetric12;
    $pictures = $machineResult->pictures;
    $webprice = $machineResult->webprice;
    $webpricedesc = $machineResult->webpricedesc;
    $contacttest = $machineResult->contacttest;
    $boxlength = $machineResult->boxlength;
    $boxwidth = $machineResult->boxwidth;
    $boxsqft = $machineResult->boxsqft;
    $warehousedate = $machineResult->warehousedate;
    $datepurchased = $machineResult->datepurchased;
    $pricepaid = $machineResult->pricepaid;
    $rigging = $machineResult->rigging;
    $optionalequip1 = $machineResult->optionalequip1;
    $optionalequip2 = $machineResult->optionalequip2;
    $optionalequip3 = $machineResult->optionalequip3;
    $optionalequip4 = $machineResult->optionalequip4;
    $optionalequip5 = $machineResult->optionalequip5;
    $optionalequip6 = $machineResult->optionalequip6;
    $optionalequiplink1 = $machineResult->optionalequiplink1;
    $optionalequiplink2 = $machineResult->optionalequiplink2;
    $optionalequiplink3 = $machineResult->optionalequiplink3;
    $optionalequiplink4 = $machineResult->optionalequiplink4;
    $optionalequiplink5 = $machineResult->optionalequiplink5;
    $optionalequiplink6 = $machineResult->optionalequiplink6;
    if ($status == "Available") {
        //$status = $titleStatusAvailable;
        $status = "<span style='color: green; font-weight: bold;'>" . $titleStatusAvailable . "</span>";
    } else {
        $status = "<span style='color: red; font-weight: bold;'>" . $titleStatusSold . "</span>";
    }
    $tableHeaderColor = "#5A5B5B";
    $tableHeaderTextColor = "#FFFFFF";
    $tableCellColor1 = "#DAD8D8";
    $tableCellColor2 = "#FFE157";
    //   $arr = get_defined_vars();
//    echo '<pre>';
//    print_r($arr);
//    echo '</pre>';
//    die;
    $itemHtml = "";
    if (!$isPdf) {
        $itemHtml .= "\n\n";
        $itemHtml .= '<style> .productMarkup { display: none; }</style>' . "\n\n";
        $itemHtml .= '<div itemscope itemtype="http://schema.org/Product" class="productMarkup">' . "\n";
        $itemHtml .= '  <span itemprop="category">' . $list1 . '</span>' . "\n";
        $itemHtml .= '  <span itemprop="name">' . $title2 . '</span>' . "\n";
        $itemHtml .= '  <link itemprop="url" href="' . $config->baseURL . '/' . GetItemUrl($id) . '" />' . "\n";
        $itemHtml .= '  <span itemprop="description">' . $title1 . '</span>' . "\n";
        $itemHtml .= '  Inventory #: <span itemprop="sku">' . $id . '</span>' . "\n";
        $itemHtml .= '  Condition: <span itemprop="itemCondition">Used</span>' . "\n";
        $itemHtml .= '<span itemprop="offers" itemscope itemtype="http://schema.org/Offer">';
        $itemHtml .= '  <link itemprop="availability" ' . (($machineResult->status == 'Available') ? 'href="http://schema.org/InStock"' : 'href="http://schema.org/OutOfStock"') . '/>' . $status . "\n";
        //        $itemHtml .= '  <span itemprop="price"></span>';
        $itemHtml .= '</span>';
        if ($machineResult->pictures == "yes") {
            $itemHtml .= '  <img itemprop="image" src="' . $config->baseURLPictures . $config->inventoryImagesPath . $id . '-1.jpg" alt="' . $shortdesc . ' used 1" />' . "\n";
        }
        $itemHtml .= '</div>' . "\n";
        $itemHtml .= "\n\n";
    }
    $itemHtml .= "\n" . '<table class="table table-condensed" border="0" width="99%" cellpadding="2" cellmargin="2" style="margin: 0px; border-spacing: 2px !IMPORTANT; border-collapse: separate !IMPORTANT;">' . "\n";
    // USED FOR INDEPENDENT PDF GENERATTION
    //  $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: '.$tableCellColor1.';"><h2><a href="http://www.used-trim-presses.com/">Trim Press</a> '.$id. '</td></tr>' . "\n";
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><div class="itemTitle22">' . $titleIdPrefix . ' ' . $id . '</div></td></tr>' . "\n";
    if (strlen($titleForSale) > 0) {
        if ($isPdf) {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle2"><a href="' . $config->baseURL . '/machineshow.php?id=' . $id . '" style="text-decoration: underline;"><b>' . $titleForSale . '</b></a></td></tr>' . "\n";
        } else {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titleForSale . '</td></tr>' . "\n";
        }
    }
    if (strlen($title1) > 0) {
        if ($isPdf) {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle1"><a href="' . $config->baseURL . '/machineshow.php?id=' . $id . '" style="text-decoration: underline;"><b>' . $title1 . '</b></a></td></tr>' . "\n";
        } else {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle1"><h1>' . $title1 . '</h1></td></tr>' . "\n";
        }
    }
    if (strlen($title2) > 0) {
        if ($isPdf) {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle2"><a href="' . $config->baseURL . '/machineshow.php?id=' . $id . '" style="text-decoration: underline;">' . $title2 . '</a></td></tr>' . "\n";
        } else {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle2"><h2>' . $title2 . '</h2></td></tr>' . "\n";
        }
    }
    if (strlen($title3) > 0) {
        if ($isPdf) {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle3"><a href="' . $config->baseURL . '/machineshow.php?id=' . $id . '" style="text-decoration: underline;">' . $title3 . '</a></td></tr>' . "\n";
        } else {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';" class="itemTitle3"><h3>' . $title3 . '</h3></td></tr>' . "\n";
        }
        // } else if (strlen($shortdesc) > 0) {
        //      $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: '.$tableCellColor1.';"><b>Model: </b>'.$shortdesc.'</td></tr>' . "\n";
    }
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><span style="font-weight: bold;">' . $titleStatus . '</span> ' . $status . '</td></tr>' . "\n";
    if (strlen($spectext1) > 0) {
        $itemHtml .= '<tr><td width="40%" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleSpecifications . '</td>' . "\n";
        $itemHtml .= '<td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleMeasurements . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["spectext" . $i])) {
                $itemHtml .= '<tr><td style="text-align: left; background-color: ' . $tableCellColor1 . '; vertical-align: top;">' . $result["spectext" . $i] . '</td>' . "\n";
                $itemHtml .= '<td style="text-align: left; background-color: ' . $tableCellColor2 . ';">' . $result["specmetric" . $i] . ' <span style="color: red;">/</span> <span style="color: darkblue;">' . $result["specus" . $i] . '</span></td></tr>' . "\n";
            }
        }
    }
    if (strlen($result["feature1"]) > 0) {
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleFeaturesAccessories . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["feature" . $i])) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $result["feature" . $i] . '</td></tr>' . "\n";
            }
        }
    }
    if (
        strlen($result["optionalequip1"]) > 0 ||
        strlen($result["optionalequip2"]) > 0 ||
        strlen($result["optionalequip3"]) > 0 ||
        strlen($result["optionalequip4"]) > 0 ||
        strlen($result["optionalequip5"]) > 0 ||
        strlen($result["optionalequip6"]) > 0
    ) {
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleOptionalEquip . '</td></tr>' . "\n";
        for ($i = 1; $i < 13; $i++) {
            if (strlen($result["optionalequip" . $i]) > 0) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a href="' . $config->baseURL . '/machineshow.php?id=' . $result["optionalequiplink" . $i] . '">' . $result["optionalequip" . $i] . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** PDF DOCUMENTS ROW ***
    if (itemHasFilesWithExtension($itemId, ".pdf")) {
        $fileQuery = GetAttachedFiles($itemId);
        $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleDocuments . '</td></tr>' . "\n";
        while ($file = $fileQuery->fetch_object()) {
            if (endsWith($file->file_name, ".pdf")) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a target="_blank" href="' . $config->baseURL . '/UserFiles/InventoryFiles/' . $file->file_path . '/' . $file->file_name . '">' . $file->file_name . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** CAD DOCUMENTS ROW ***
    if (itemHasFilesWithExtension($itemId, ".skp")) {
        $fileQuery = GetAttachedFiles($itemId);
        $itemHtml .= '<tr><td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleCADDocuments . '</td>' . "\n";
        $itemHtml .= '<td style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none; text-align: right;"><a href="http://www.sketchup.com" style="color: white;" target="_blank">Download Google SketchUp</a></td></tr>' . "\n";
        while ($file = $fileQuery->fetch_object()) {
            if (endsWith($file->file_name, ".skp")) {
                $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';"><a target="_blank" href="' . $config->baseURL . '/UserFiles/InventoryFiles/' . $file->file_path . '/' . $file->file_name . '">' . $file->file_name . '</a></td></tr>' . "\n";
            }
        }
    }
    // *** TERMS OF SALE ***
    $itemHtml .= '<tr><td colspan="2" style="font-size: .90em; text-align: left; background-color: ' . $tableHeaderColor . '; color: ' . $tableHeaderTextColor . '; text-decoration: none;">' . $titleTermsOfSale . '</td></tr>' . "\n";
    if ($isPdf && $quotePrice != 'info') {
        $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' ' . $quotePrice . '</td></tr>' . "\n";
    } else if ($isPdf && $quotePrice == 'info') {
        //$itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: '.$tableCellColor1.';">'.$titlePrice.' <a href="http://www.diecastmachinery.com/machineshow.php?id='.$id.'" style="text-decoration: underline;"><b>request quotation</b></a></td></tr>' . "\n";
    } else {
        if ($webprice) {
            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' ' . $askprice . '</td></tr>' . "\n";
        } else {
            //$itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' <a href="additem.php?id=' . $id . '" style="text-decoration: underline;"><b>request quotation</b></a></td></tr>' . "\n";

            $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titlePrice . ' <a data-itemid=' . $id . '" class="linkShowItemCart"  style="text-decoration: underline;"><b>request quotation</b></a></td></tr>' . "\n";
        }
    }
    $itemHtml .= '<tr><td colspan="2" style="text-align: left; background-color: ' . $tableCellColor1 . ';">' . $titleShippingTerms . ' ' . $shipterms . "\n";
    $itemHtml .= "<p>" . $merge->international_shipping . '</p></td></tr>' . "\n";
    $itemHtml .= '</table>' . "\n";
    if (isset($machineResult->youtube) && strlen($machineResult->youtube) > 0) {
        $itemHtml .= '<br/><div class="row"><div class="col-md-8 col-md-offset-2">';
        $itemHtml .= "<br/><div class='wrapper invenyoutube' style='text-align: center;'>" . $machineResult->youtube . "</div>" . "\n";
        $itemHtml .= '</div></div>';
    }

    if ($machineResult->pictures == "yes" and file_exists("machinepics/big/" . $id . "-1.jpg")) {
        if (!$isPdf) {
            $picUrl = $config->baseURLPictures . $config->inventoryImagesPath;
            $itemHtml .= "<link rel='stylesheet' type='text/css' href='css/carousel.css'>";
            $itemHtml .= "<div class='modal fade' id='imagemodal' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>";
            $itemHtml .= "  <div class='modal-dialog' data-dismiss='modal'>";
            $itemHtml .= "    <div class='modal-content'  >";
            $itemHtml .= "      <div class='modal-body'>";
            $itemHtml .= "      	<button type='button' class='close' data-dismiss='modal'><span aria-hidden='true'>&times;</span><span class='sr-only'>Close</span></button>";
            $itemHtml .= "        <img src='' class='imagepreview' style='' >";
            $itemHtml .= "      </div>";
            $itemHtml .= "    </div>";
            $itemHtml .= "  </div>";
            $itemHtml .= "</div>";
            //MATT DEMO
            $itemHtml .= "<div id='carousel-custom'><div class='demo'>";
            $itemHtml .= "<h2>Product Photos</h2>";
            $itemHtml .= "<div class='item'>";
            $itemHtml .= "    <div class='clearfix' style='max-width:600px;'>";
            $itemHtml .= "        <ul id='image-gallery' class='gallery list-unstyled cS-hidden'>";
            $i = 1; //loop thru the big images
            while (file_exists("machinepics/big/" . $id . "-" . $i . ".jpg")) {
                $itemHtml .= "<li data-thumb='" . $config->baseURL . "/machinepics/thumbs/" . $id . "-" . $i . ".jpg' />";
                $itemHtml .= "<img class='lazyload' src='" . $config->baseURL . "/machinepics/big/" . $id . "-" . $i . ".jpg' />";
                $itemHtml .= "            </li>\n";
                $i++;
            }
            $itemHtml .= "         </ul>";
            $itemHtml .= "            <div id='carouselButtons'><button class='btn btn-success' type='button' id='play'>Play</button>";
            $itemHtml .= "            <button class='btn btn-success' type='button' id='pause'>Pause</button></div>";
            $itemHtml .= "        <h4><span id='current'><span class='dumCurrent'>1</span></span> of <span id='total'></span> Images</h4>";
            $itemHtml .= "	</div>";
            $itemHtml .= "</div>";
            $itemHtml .= "</div></div>";

        } else { //if this IS a PDF
            $itemHtml .= "<br/><div class='row'>\n";
            $itemHtml .= "<div class='col-lg-offset-2 col-lg-8 pictureList'>\n";
            $itemHtml .= "<div style='text-align: center;'>" . $titleClickImage . "</div>" . "\n<br\><center><br\>\n";
            $picUrl = $config->baseURLPictures . $config->inventoryImagesPath;
            if ($detect->isMobile() && !$detect->isTablet()) {
                $picFilename1 = $id . '-1.jpg';
                if (file_exists("." . $config->inventoryImagesPath . $picFilename1) || file_exists("../.." . $config->inventoryImagesPath . $picFilename1) || file_exists(".." . $config->inventoryImagesPath . $picFilename1)) {
                    $pic1Exists = true;
                    $itemHtml .= "<a href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-1&itemid=" . $id . "&picnum=1' target='_blank'>";
                    $itemHtml .= '<img src="' . $picUrl . $picFilename1 . '" alt="' . $shortdesc . ' used 1" style="min-width: 275px; padding: 4px;" />' . "</a>\n&nbsp;&nbsp;\n";
                    $itemHtml .= "<a class='btn btn-primary' href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-1&itemid=" . $id . "&picnum=1' target='_blank'>More Images...</a>\n";
                }
            } else {
                for ($i = 1; $i < 25; $i = $i + 2) {
                    $picFilename1 = $id . '-' . $i . '.jpg';
                    $picFilename2 = $id . '-' . ($i + 1) . '.jpg';
                    $pic1Exists = false;
                    if (file_exists("." . $config->inventoryImagesPath . $picFilename1) || file_exists("../.." . $config->inventoryImagesPath . $picFilename1) || file_exists(".." . $config->inventoryImagesPath . $picFilename1)) {
                        $pic1Exists = true;
                        $itemHtml .= "<a href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-" . $i . "&itemid=" . $id . "&picnum=1' target='_blank'>";
                        $itemHtml .= '<img src="' . $picUrl . $picFilename1 . '" alt="' . $shortdesc . ' used 1" style="min-width: 275px; padding: 4px;" />' . "</a>\n&nbsp;&nbsp;\n";
                    }
                    if (file_exists("." . $config->inventoryImagesPath . $picFilename2) || file_exists("../.." . $config->inventoryImagesPath . $picFilename2) || file_exists(".." . $config->inventoryImagesPath . $picFilename2)) {
                        $itemHtml .= "<a href='" . $config->baseURL . "/showpic.php?picid=" . $id . "-" . ($i + 1) . "&itemid=" . $id . "&picnum=1' target='_blank'>";
                        $itemHtml .= '<img src="' . $picUrl . $picFilename2 . '" alt="' . $shortdesc . ' used 1" style="min-width: 275px; padding: 4px;" />' . "</a><br\>\n";
                    }
                }
            }
            $itemHtml .= "</center>\n";
            $itemHtml .= "</div>\n";
            $itemHtml .= "</div>\n";
        }
    }
    $itemHtml .= "<p><div style='text-align: left;'>" . $titleDescription . $catdesc . "</div>" . "\n";
    if (strlen($merge->search_assist) > 0) {
        $itemHtml .= "<br/><div style='text-align: left; margin-top=: 5px;'>";
        $itemHtml .= $searchAssisstTitle . $merge->search_assist;
        $itemHtml .= "</div>" . "\n";
    }
    $itemHtml .= "<div style='text-align: left; margin-top=: 5px;'><p>";
    $itemHtml .= $purchaseAgreement;
    $itemHtml .= "</div>" . "\n";
    return $itemHtml;
}
?><?
class ItemSeoObj {
	public $id = 0;
	public $seo_page_title = "";
	public $seo_meta_desc = "";
	public $seo_meta_keywords = "";
	public $seo_meta_header = "";
	public $seo_meta_footer = "";
	public $short_desc = "";
	public $catalog_desc = "";
	public $search_assist = "";
	public $international_shipping = "";
	public $title_line1 = "";
	public $title_line2 = "";
	public $title_line3 = "";
	public $picture_page_title = "";
	public $picture_meta_desc = "";
	public $picture_meta_header = "";
	public $picture_meta_keywords = "";
	public $picture_1_alt_text = "";
	public $picture_2_alt_text = "";
	public $picture_3_alt_text = "";
	public $picture_4_alt_text = "";
	public $picture_5_alt_text = "";
	public $picture_6_alt_text = "";
	public $picture_caption = "";
}
?><br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/diecastm/public_html/includes/diecast/functions.itemdisplay.inc.php:1) in <b>/home/diecastm/public_html/includes/diecast/functions.recent.items.inc.php</b> on line <b>47</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/diecastm/public_html/includes/diecast/functions.itemdisplay.inc.php:1) in <b>/home/diecastm/public_html/includes/diecast/functions.recent.items.inc.php</b> on line <b>50</b><br />
<!DOCTYPE html>
<!-- Home.tmp.php -->
<html lang="en">

<head>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">

  <link rel="icon" type="image/svg+xml" href="images/favicon/favicon.svg">
  <link rel="icon" type="image/png" sizes="32x32" href="images/favicon/favicon-32x32.png">
  <link rel="apple-touch-icon" sizes="180x180" href="images/favicon/apple-icon-180x180.png">
  <meta name="theme-color" content="#FFFFFF">

    
    <title>Conair Aceite Caliente Unidades | Ahorre 35% | Envío el Mismo Día </title>
<meta name="description" content="Usado Conair Aceite Caliente Unidades De Venta, Conair Sistemas de Calefacción de Paquete de Aceite Caliente y Termorreguladores de Control de Temperatura a la venta, tamaños disponibles 6kw, 12kw, 24kw, 36kw, 48kw 96 tamaños"/>
<meta name="keywords" content="Conair Aceite Caliente Unidades De Venta | Ahorre 35% | Envío el Mismo Día , Usado Conair Unidades de Control de Temperatura a la Venta"/>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<meta name="googlebot" content="noarchive"/>
<meta name="robots" content="index,follow"/>
<meta name="revisit-after" content="7 Days"/>
<meta name="language" content="en-us"/>
<meta name="copyright" content="(C) Copyright 2015"/>
<meta name="ahrefs-site-verification" content="2f180acc89d41af1aa6aac53d3c15790ce34652015b4fe4e8d26be417a39e284">
<meta name="google-site-verification" content="ixpLJ6GdtlWR8jE6jyp6fm9nXRZlM6OaQDgn2Li2OiQ" />
<meta name="google-site-verification" content="I_mbozZzLQSLWBlmuXHniea-Zson3z3H10BBDmeApfM" />
<meta name="google-site-verification" content="YWBX4nXSzI2zv-QTh6KQkSEn2BlvBTe9AhrblvS0YOU" />


    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous">
    <!-- <link href="libraries/jquery-ui-1.13.1/jquery-ui.css" rel="stylesheet" /> -->
    <!-- <link href="./css/content.css" rel="stylesheet" /> -->
    <link rel="stylesheet" href="https://code.jquery.com/ui/1.14.1/themes/base/jquery-ui.min.css">

    <style>
.navbar,body{font-family:Helvetica,sans-serif}.navbar-nav>li>a,.navbar-nav>li>a:hover{padding-top:10px!important;padding-bottom:10px!important}.home-menu,.topmenubar,.youtube{margin-left:auto;margin-right:auto}.headerLinks,.picturePage h1,.picturePage h2,.picturePageItems{text-align:center}.captionTitle,.h4,.itemTitle1 h1,.itemTitle22,.nav-link,.nav-tabs>li>a,.nav>li>a,.picturePage h1,.viewMoreTitleSmall,h4{font-weight:700}#alsoConsider .btn,.nav-tabs>li>a{font-size:14px}body{font-size:16px;background-repeat:repeat-x;background-position:left top;margin-left:0;margin-right:0;padding-bottom:0;padding-top:0;margin-top:0;line-height:1.3}#termsAndtube,.row.status-gallery{display:flex}.btn.btn-md.btn-default.btn-call:hover{color:#333;background-color:#e6e6e6;border-color:#adadad}.bootgrid-table td{overflow:visible!important;-ms-text-overflow:ellipsis;text-overflow:ellipsis;white-space:normal}.modal-ajax-spinner{position:absolute;background-color:#000;width:100%;height:100%;opacity:.2;padding-top:15%;text-align:center;color:#fff;z-index:100}.myheader,.navbar,.viewMore{position:relative}/*!
 * content.css
 *
 */h1,h2,h3,h4,h5,h6{color:#5e5e45}@media only screen and (max-width:640px){#grid{font-size:.8em}.hideonmobile{display:none}}.btn-cont,.picturePageItem,.viewMore a{display:inline-block}.topmenubar .container-fluid,.topmenubar .navbar-collapse{padding:0!important}.h1,h1{font-size:24px}.h2,h2{font-size:20px}.h3,h3{font-size:18px}.h4,h4{font-size:16px;margin-bottom:4px}.well{background-color:#dde1e3}.homebox{border:2px solid #86a3c3;padding:10px 40px;border-radius:8px;background-color:#86a3c3;color:#fff}.breadcrumb{text-transform:uppercase;font-size:.75em;background:0 0;padding:0;margin-top:-.8em;margin-bottom:1em}.home-menu,.smallmenu,.topmenubar{background-color:#757676}.home-menu,.topmenubar{border-bottom:2px solid #c80000;letter-spacing:2px}.navbar{min-height:10px;border:1px solid transparent}.nav>li>a{color:#fff}.nav-tabs,.navbar-nav{border-bottom:0 solid #ddd}.nav-tabs>li>a{color:#fff;font-family:Verdana,Geneva,sans-serif;line-height:.25}.navbar-nav>li>a{color:#fff!important;font-size:16px;line-height:.5}.navbar-nav>li>a:hover{background-color:#c80000!important;border:none!important}.dropdown,.momenu{padding-right:1em}.nav>li>a:focus,.nav>li>a:hover{color:#fff;text-decoration:none;background-color:#b40d02;border:0 solid #b40d02}.nav .open>a,.nav .open>a:focus,.nav .open>a:hover{background-color:#c80000;border-color:#428bca}.dropdown-menu>li>a:hover,.nav>li>a:focus{background-color:#c80000;color:#fff;white-space:nowrap}@media screen and (min-width:1200px){.grmenu{width:920px;padding:15px}.grmenuitem{width:220px;float:left;padding-right:12px;padding-bottom:25px}.grmenupic,.grmenutext{width:100px;float:left;vertical-align:top}.grmenutext{font-size:14px;font-family:"Helvetica Neue",Helvetica,Arial,sans-serif}}@media screen and (max-width:1200px){.grmenu{width:640px;padding:4px}.grmenuitem{width:208px;float:left;padding-right:4px;padding-bottom:20px}.grmenupic,.grmenutext{width:100px;float:left;vertical-align:top}.grmenupic{min-height:80px}.grmenutext{font-size:14px;font-family:"Helvetica Neue",Helvetica,Arial,sans-serif}}.grmenu a,.grmenu a:visited{color:#000}.grmenu span a,.grmenu span a:visited{color:#00f}.picturePage h1{font-size:1.1em}.picturePage h2{font-size:.9em}.headerLinks,.youtube{margin-bottom:15px}.picturePageItem{vertical-align:top;width:280px;min-height:275px;margin-left:10px;margin-bottom:20px}.picturePageItem img{width:100%}.captionHyperlink{margin-top:6px}.search-block-container,.search-block-container-mobile{position:relative;padding:0;width:288px;height:auto;border:2px solid #c80000}.article,.topnews{border:1px solid silver}.search-block-container input:focus,.search-block-container-mobile input:focus{border:1px solid #c80000}.search-block-container .navbar-form,.search-block-container-mobile .navbar-form{padding:0;margin:0;border:0;-webkit-box-shadow:none;box-shadow:none}#youtubeImageBox #play,.youtube-player .play{height:72px;width:72px;left:50%;top:50%;margin-left:-36px;margin-top:-36px;cursor:pointer}.pictureList img:hover{cursor:url(/css/images/zoom_in.cur),auto}.myheader{margin-top:0;background-color:transparent;margin-left:0;margin-right:0;padding-bottom:0;padding-top:0}.footer{background-color:#292929;font-size:11px;color:#fff;padding-top:5px}.article{background-color:#f6f6f6;padding:6px}.topnews{background-color:#d9e9e8;color:#000;padding-left:6px;max-height:120px;overflow:auto}.mainContent,.mainContentHome{min-height:200px;background-color:#fff;border:0 solid #000;margin-bottom:10px}.mainContentHome{padding-top:0;padding-bottom:0}.mainContent{padding:0}.testimonialEntry{font-family:verdana;font-size:8pt;color:grey;border:1px solid silver;background-color:#f6f6f6;padding:8px}.testimonialQuote{padding-top:4px;text-align:left;padding-bottom:4px;border-bottom:1px dotted #b0b0b0}.testimonialName{padding-top:4px;color:#5e636c}.itemTitle1 h1,.itemTitle2 h2,.itemTitle22,.itemTitle3 h3{text-align:left;vertical-align:top;color:#000;padding:0;margin:0;font-size:.9em}.itemTitle2 h2,.itemTitle3 h3{font-weight:400}.invenList h1,.invenList h2,.invenList h3,.invenList h5{font-family:Arial,Helvetica Neue,Helvetica,sans-serif;text-align:center}.invenList{margin-bottom:1em;margin-top:1em}.invenList h1,.invenList h2{font-size:1.1em;font-weight:700}.invenList h3,.invenList h5{font-size:1em;font-weight:700}.formTable{border:0 solid #d3d3d3}.formLabel,.formSubLabel{border:1px solid #fff;vertical-align:top}.formTable td{padding:2px}.formFooter,.formFooter td,.formHeader,.formHeader td{text-align:left;background-color:#d3d3d3;font-weight:700}.deleteFooter,.deleteFooter td,.deleteHeader,.deleteHeader td{background-color:#8b0000;color:#fff}.editFooter,.editFooter td,.editHeader,.editHeader td{background-color:#d3d3d3}.addFooter,.addFooter td,.addHeader,.addHeader td{background-color:#006400;color:#fff}.formLabel{text-align:right;background-color:#d3d3d3;color:#000}.formSubLabel{text-align:left;background-color:#f0f0f0;color:#000}.formField{text-align:left;vertical-align:top;border:0 solid #d3d3d3;color:#000!important}.formCheckbox{text-align:left;vertical-align:top;border:1px solid #d3d3d3;color:#b0b0b0;width:20px}.viewMore{line-height:16px;font-size:.9em;padding-top:14px;padding-right:6px;margin-top:14px}.viewMoreSmall{text-align:center;padding-top:0;padding-right:0;margin-top:0!important}.viewMoreTitle{font-weight:700;position:absolute;top:-3px;left:-5px;right:0;height:14px;margin-bottom:4px;width:175px}.viewMore a{margin-bottom:4px}#alertMsgClose:hover,.linkShowItemCart{cursor:pointer}#alertMsg,#alertMsg2{display:none;background-color:#e7e3e3;width:260px;padding:5px 5px 5px 15px;color:#000;position:fixed;bottom:200px;left:0;border-radius:0 20px 20px 0;-moz-border-radius:0 20px 20px 0;-webkit-border-radius:0px 20px 20px 0px;border:5px solid #bd0318;border-left:0;z-index:1}.youtube-player{position:relative;padding-bottom:56.23%;height:0;overflow:hidden;max-width:100%;background:#000;margin:5px}.youtube-player iframe{position:absolute;top:0;left:0;width:100%;height:100%;z-index:100;background:0 0}.youtube-player img{bottom:0;display:block;left:0;margin:auto;max-width:100%;width:100%;position:absolute;right:0;top:0;border:none;height:auto;cursor:pointer;-webkit-transition:.4s;-moz-transition:.4s;transition:.4s}.youtube-player img:hover{-webkit-filter:brightness(75%)}.youtube-player .play{position:absolute;background:url("images/play-btn.png") no-repeat}.btn.btn-basic,.btn.btn-lg.btn-basic{background-color:#929292;color:#fff}#youtubeImageBox #play{position:absolute;color:#fff}.alsoConsider{padding:0;margin:0}.btn.btn-lg.btn-basic{margin-bottom:10px;width:99%;white-space:normal}.row.buttons::after,.row.buttons::before{font-family:fontAwesome;display:inline;top:0;border-right:2px solid #777;height:100%;line-height:70px;margin:auto;padding-right:3px;position:absolute;color:#777;font-size:30px;cursor:pointer}.btn.btn-basic:hover,.btn.btn-lg.btn-basic:hover{background-color:#b22222}#featureSpecBox,#invenSpecBox{border:1px solid #757575}#featureSpecBox .columns{column-count:2}.specButtonBox{float:right;margin-top:1em}#invenTerms{border-radius:20px;-moz-border-radius:20px;-webkit-border-radius:20px 20px 20px 20px;background-color:#e7e3e3}.RelatedNav{padding-bottom:.5em;width:100%}.RelatedNav .titles{text-align:center;font-weight:700}.carousel-control-next-icon:after,.carousel-control-prev-icon:after,.lslide.active a::before{font-family:"Font Awesome 5 Free";font-weight:900}.RelatedNav .buttons{text-align:center;border-radius:10px;-moz-border-radius:10px;-webkit-border-radius:10px 10px 10px 10px;border:1px solid #5c5c5c;padding-top:.5em;position:relative;padding-left:16px;padding-right:16px;height:auto;overflow:hidden}.relatedbtn{white-space:normal;width:1%;height:50px;vertical-align:middle}.btn-cont{width:48%}.RelatedNav .buttons .col-md-4{padding-top:9px;padding-bottom:5px}.btn.relatedbtn{display:table-cell;line-height:normal}.row.buttons::before{left:24px}.row.buttons::after{right:24px}.icon-nav{position:absolute;color:#777;font-size:30px;margin-top:17px}.icon-nav.btn-prev{left:-14px;top:-10px;cursor:default}.icon-nav.btn-next{right:-14px;top:-10px;cursor:default}#invenSpecBox ul{height:230px;overflow-y:auto}#youtubeImageBox img{width:100%;height:auto;border-radius:20px}.affix-bottom,.lslide.active a{position:relative}.lslide.active a::before{position:absolute;z-index:99999;top:-650%;color:#fff;font-size:40px;width:100%;right:-44%!important;content:"\f00e"}#slides,.ui-helper-hidden-accessible,.visible-lg,.visible-md,.visible-sm,.visible-xs{display:none}.col-lg-3.col-md-3.visible-md.visible-lg.text-right{display:block}.col-md-2.col-sm-2.col-xs-2.text-center{text-align:right!important}.btn-default{color:#333;background-color:fff;border-color:#ccc}.navbar.navbar-expand-lg.bg-dark.navbar-dark{padding-top:2px;padding-bottom:2px}.btn.btn-md.btn-default.btn-call{font-size:13px}@media screen and (min-width:992px){.col-md-4.mid{width:22.8%;padding-left:3px;padding-right:3px}.col-md-4.brands,.col-md-4.categories{width:38.6%}.col-md-4.categories{padding-right:2px;padding-left:15px}.col-md-4.brands{padding-left:2px;padding-right:11px}.btn-cont{width:49%}.button-text{display:none}}a:link,a:visited{color:#337ab7}.btn-primary.btn-sm,.btn-sm.btn-success,.formCartLinks a:link,.formCartLinks a:visited{color:#fff}.btn-primary{color:#fff!important;background-color:#337ab7;border-color:#2e6da4}.btn-primary.active,.btn-primary:active,.btn-primary:focus,.btn-primary:hover{color:#fff;background-color:#2e6da4;border-color:#285e8e}#rfqCartDiv{margin-left:10px;margin-right:10px}.panel{border:1px solid silver;padding:0}.panel-heading{background-color:#f5f5f5;height:60px;padding:10px}.panel-body{padding:10px}.carousel-control-next,.carousel-control-prev{opacity:1;color:#fff}.carousel-control-next-icon,.carousel-control-prev-icon{background:0 0!important;color:#fff;font-size:2em;text-shadow:0 0 3px #000}.carousel-control-next-icon:after{content:"\f138"}.carousel-control-prev-icon:after{content:"\f137"}.carouselButtons,.magglass a:link,.magglass a:visited{color:#fff!important}.magglass{position:absolute;color:#fff;z-index:100;right:1em;top:1em;text-shadow:0 0 3px #000}#sideMenuSlide,.sidenavslide{position:fixed;z-index:9999;top:0}.carousel-item{background-color:#ececec}@media (max-width:576px){.modal-dialog.modal-dialog-slideout{width:80%}}.modal.fade .modal-dialog.modal-dialog-slideout{-webkit-transform:translate(100%,0) scale(1);transform:translate(100%,0) scale(1)}.modal.fade.show .modal-dialog.modal-dialog-slideout{-webkit-transform:translate(0,0);transform:translate(0,0);display:flex;align-items:stretch;-webkit-box-align:stretch;height:100%}.modal-dialog-slideout .modal-content{border:0}.modal-dialog-slideout{min-height:100%;margin:0 0 0 auto!important;background:#fff}.modal.fade.show .modal-dialog.modal-dialog-slideout .modal-body{overflow-y:auto;overflow-x:hidden}@media screen and (max-width:990px){#invenSpecBox,#invenTerms{margin-bottom:30px}#collapsibleNavbar .navbar-nav{padding-top:5px;margin-top:10px;border-top:1px solid #222}.navbar.navbar-expand-lg.bg-dark.navbar-dark{padding-top:5px;padding-bottom:5px}.navbar-dark .navbar-toggler{border-color:#333;padding:3px 10px!important}.button-text{color:#fff}.myheader .col-xs-12.col-sm-6.visible-xs.visible-sm{display:block;text-align:right;max-width:100%;flex:content}#termsAndtube,.row.status-gallery{display:block}.myheader .col-md-4.col-sm-4.col-xs-12{width:100%;float:none;max-width:100%;flex:auto;padding:0}.myheader .col-md-2.col-sm-2.col-xs-2.text-center{float:right;width:auto;margin-right:20px;padding:0!important}.myheader .col-md-5.col-sm-10.col-xs-10.text-center{max-width:100%;flex:content}.status-gallery .col-md-6{width:100%;float:none}#invenSpecBox ul{height:auto;overflow-y:hidden}div.item .clearfix{width:100%;max-width:100%!important}#invenTerms{padding-top:2px;padding-bottom:10px}#termsAndtube .col-md-6:last-child{padding:0}#cartModalLink{padding:7px 12px 7px 8px}}@media screen and (max-width:768px){.btn-cont{display:table;width:100%;margin:0 auto 10px}.btn.relatedbtn{display:table-cell;margin:0 auto}.col-md-4:nth-child(2){border:none}.row.buttons::after,.row.buttons::before{top:50%;border:none;line-height:normal}body #image-gallery{height:100%!important}.icon-nav.btn-prev{top:100%;margin-top:28px}.icon-nav.btn-next{top:-100%;margin-top:28px}body #carousel-custom{width:100%!important}}@media screen and (max-width:400px){.myheader .col-md-5.col-sm-10.col-xs-10.text-center{max-width:100%;flex:inherit;width:80%!important}.myheader .searchmodule input{margin-left:14px!important}}@media screen and (max-width:320px){.myheader .col-md-5.col-sm-10.col-xs-10.text-center{max-width:100%;flex:inherit;width:85%!important;padding:0!important}.myheader .col-md-2.col-sm-2.col-xs-2.text-center{float:right;width:auto;margin-right:0;padding:0!important}}.sidenavslide{height:100%;width:0;left:0;background-color:#d8d8d8;overflow-x:hidden;transition:.5s;padding-top:1px}.sidenavslide a{text-decoration:none;display:block;transition:.3s}.sidenavslide a:hover{color:#f1f1f1}.sidenavslide .closebtn{position:absolute;top:0;right:25px;font-size:36px;margin-left:50px}.closebox{padding:1em;align-content:right;text-align:right;color:#2e6da4}.filterslidelink{background-color:#000;width:28px;height:auto;position:fixed;left:0;z-index:95;border-radius:0 10px 10px 0;-moz-border-radius:0 10px 10px 0;-webkit-border-radius:0px 10px 10px 0px;border-top:2px solid #000;border-right:2px solid #000;border-bottom:2px solid #000;border-left:0 solid #000;padding:10px 10px 0;color:#fff;cursor:pointer;top:250px;vertical-align:middle;text-align:center;opacity:.7}.filterslidelink .filtertext{text-transform:uppercase;width:5px;word-wrap:break-word;margin-left:6px}@media screen and (max-height:450px){.sidenavslide{padding-top:15px}.sidenavslide a{font-size:18px}}#sideMenuSlide{display:none;padding:4px;right:0;bottom:0;background-color:#d3d3d3}#sideMenuCloseBtn{text-align:left;padding-right:6px}#filterMenuCloseBtn a,#sideMenuCloseBtn a{color:#fff;font-size:18pt}.home-short{background-color:#fff;margin-left:-15px;margin-right:-15px}.home-left{background-color:#eae8e8}.home-footer{background-color:#292929;height:180px;color:#fff;padding-top:5px}.ui-autocomplete{position:absolute;z-index:1000;cursor:default;padding:0;margin-top:2px;list-style:none;background-color:#fff;border:1px solid #ccc;-webkit-border-radius:5px;-moz-border-radius:5px;border-radius:5px;-webkit-box-shadow:0 5px 10px rgba(0,0,0,.2);-moz-box-shadow:0 5px 10px rgba(0,0,0,.2);box-shadow:0 5px 10px rgba(0,0,0,.2)}.ui-autocomplete>li{padding:3px 20px}.ui-autocomplete>li.ui-state-focus,.ui-autocomplete>li:hover{background-color:#ddd}.navbar{margin:0!important;background:0 0!important}
    </style>


    <?
    // if (($pagerow->page_style == "") || ($pagerow->page_style == "Default")) {
    //     echo "<link href='./css/layout-default.css' rel='stylesheet' type='text/css'/>";
    // }
    // if ($pagerow->page_style == "Single_Column") {
    //     echo "<link href='./css/layout-single.css' rel='stylesheet' type='text/css'/>";
    // }
    // if ($pagerow->page_style == "Two_Column") {
    //     echo "<link href='./css/layout-default.css' rel='stylesheet' type='text/css'/>";
    // }
    // if ($pagerow->page_style == "Three_Column") {
    //     echo "<link href='./css/layout-three.css' rel='stylesheet' type='text/css'/>";
    // }
    // if ($pagerow->page_style == "Home") {
    //     echo "<link href='./css/home.css' rel='stylesheet' type='text/css'/>";
    // }
    ?>

    <script src="https://code.jquery.com/jquery-3.7.1.min.js"
        integrity="sha256-/JqT3SQfawRcv/BIHPThkBvs0OEvtFFmqPF/lYI/Cxo=" crossorigin="anonymous"></script>


</head>

<body>
    <!-- Header -->
    <div class="container" style="margin-top: 0px;">
        <div id="hits" style="display: none;"></div>
        <input type="hidden" id="addMultiRFQ" name="addMultiRFQ" value="" />
        <style type="text/css">.myheader {
        font-family: lucida sans unicode, lucida grande, sans-serif;
        padding-top: 10px;
        font-size: .9em;
        
    }
    
    .myheader .logo {
        height: 70px;
        width: auto;
    }
    
    .myheader .searchmodule {
        margin-left: auto;
        margin-right: auto;
    }
    
    .myheader .searchmodule input {
        width: 90%;
    }
    
    .myheader #searchbox {
        padding-bottom: 1em;
		 }
		 .btn-call, #cartModalLink {margin-bottom: .5em}		

	.myheader .ais-SearchBox-submitIcon {
		left:-.5em;
		}
</style>
<div class="myheader">
<div>
<div class="row">
	<div class="col-sm-6 visible-sm">&nbsp;</div>

<!--	<div class="col-12 col-sm-12 d-block d-lg-none"><span class="btn btn-sm btn-outline-secondary float-right"><a href="tel:847-360-9170">Call (847) 360-9170</a></span></div>-->

	<div class="col-12 col-sm-4 col-md-4"><a href="Inicio_es"><img alt="Die Cast Machinery LLC Logo" class="img-fluid logo" src="https://cdn.diecastmachinery.com/images/dcm-logo.png" style="width: 291px; height: 70px;" /></a>

<div class="visible-md visible-lg">World Leader in Used Die Casting Machinery!</div>
</div>

<div class="col-12 col-sm-12 col-md-4 text-center">
<div class="searchmodule"><link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/instantsearch.css@8.5.1/themes/reset-min.css"
    integrity="sha256-KvFgFCzgqSErAPu6y9gz/AhZAvzK48VJASu3DpNLCEQ=" crossorigin="anonymous">

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/instantsearch.css@8.5.1/themes/satellite-min.css"
    integrity="sha256-woeV7a4SRDsjDc395qjBJ4+ZhDdFn8AqswN1rlTO64E=" crossorigin="anonymous">

<style>
    #hits {
        z-index: 100;
        position: absolute;
        background: white none repeat scroll 0% 0%;
        width: 95%;
        border-radius: 10px;
        border: 10px solid rgb(101, 101, 101);
        top: 50px;
        left: 0;
        right: 0;
        margin-left: auto;
        margin-right: auto;
        line-height: 1em;
        padding: 20px;
        margin-top: 10px;
    }

    .ais-Hits-list {
        display: flex;
        flex-wrap: wrap;
        gap: 10px;
    }

    .ais-Hits-item {
        font-size: 0.9em;
        text-align: left;
        border: 1px solid #C0C0C0;
        border-radius: 10px !important;
        box-shadow: 0 0 10px #C0C0C0;
        margin: 5px;
        display: block;
        padding: 10px;
    }

    .ais-Highlight-highlighted {
        font-size: 14px;
        text-align: left;
    }

    .searchdescription {
        display: -webkit-box;
        -webkit-line-clamp: 2;
        -webkit-box-orient: vertical;
        overflow: hidden;
    }

    .ais-SearchBox-input {
        font-size: 20px;
    }

    /* Extra small devices (phones, 600px and down) */
    @media only screen and (max-width: 600px) {
        .ais-Hits-item {
            width: 100%;
        }

        #hits {
            top: 140px;
        }
    }

    /* Small devices (portrait tablets and large phones, 600px and up) */
    @media only screen and (min-width: 600px) {
        .ais-Hits-item {
            width: 31%;
        }

        #hits {
            top: 140px;
        }
    }

    /* Medium devices (landscape tablets, 768px and up) */
    @media only screen and (min-width: 768px) {
        .ais-Hits-item {
            width: 23%;
        }

        #hits {
            top: 120px;
        }
    }

    @media only screen and (min-width: 992px) {
        #hits {
            top: 50px;
        }
    }
</style>
<div id="searchbox"></div></div>
</div>

<div class="col-12 col-sm-2 col-md-4 text-center">
	<div class="row" style="text-align: right;">
		<div class="col-6 col-sm-12">
			<a href="tel:847-360-9170">Teléfono: (847) 360-9170</a>&nbsp;|&nbsp;
			    <i class="fas fa-globe" style="cursor: pointer;" data-bs-toggle="modal" data-bs-target="#languageModal"></i><span data-bs-target="#languageModal" data-bs-toggle="modal" style="cursor: pointer;">&nbsp; Espanol</span>
					
		</div>
		<div class="col-6 col-sm-12">
			<a class="btn btn-sm btn-success float-right" href="#" aria-label='Shopping Cart' id="cartModalLink"><i class="fas fa-shopping-cart"></i> <?
$count = GetCartCount();

$postFix = (strlen($parameters) > 0) ? $parameters : '';

if ($count > 1)
{
	echo "<span id='cartCountText".$postFix."'>- " . $count . " items</span>";
} else if ($count == 1) {
	echo "<span id='cartCountText".$postFix."'>- " . $count . " item</span>";
} else {
    echo "<span id='cartCountText".$postFix."'></span>";
}</a>
		</div>
	</div>
</div>


</div>
</div>
</div>
    </div>
    <!-- END Header -->

    <!-- Menu -->
    <div class="container-fluid home-menu">
        <div class="container">
            <? if ($pagerow->menubar != "NO") { ?>
                <div>
<!-- START MENU -->
<nav class="navbar navbar-expand-lg bg-dark navbar-dark">   <div class="container-fluid">
      <span class="button-text">M E N U</span>      <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#collapsibleNavbar" aria-label="View Full Menu">
                               <span class="navbar-toggler-icon"></span>
                            </button>    <div class="collapse navbar-collapse" id="collapsibleNavbar">
        <ul class="navbar-nav">
  
   <li class="nav-item"> <a class="nav-link" href="Inicio_es" title="Máquinas de Fundición a Presión y Equipo Usado a la Venta" >INICIO</a></li>
 
  
   <li class="nav-item"> <a class="nav-link" href="Inventario_es" title="" >INVENTARIO</a></li>
 
  
   <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false" href="#" title="All of our Die Cast Industry Services">SERVICIOS <b class="caret"></b></a>
    <ul class="dropdown-menu" role="menu">
        <li><a class="dropdown-item" href="Servicios_es" title="All of our Die Cast Industry Services">SERVICIOS</a></li>
     <li><a class='dropdown-item' href='Servicios_de_Tasación_es' title='Die Cast Machinery, LLC Servicios de Tasaciones para la Industria de Fundicion a Presion'>Servicios de Tasaciones</a></li>
     <li><a class='dropdown-item' href='Servicios_Financieros_es' title='Servicios financieros ofrecidos por Die Cast Machinery, LLC a sus clientes'>Servicios Financieros</a></li>
     <li><a class='dropdown-item' href='Servicios_de_Consignacion_es' title='Die Casting Machinery, LLC Servicios de Consignación'>Servicios de Consignación </a></li>
     <li><a class='dropdown-item' href='Liquidación_de_fábrica_de_fundición_a_presión_es' title=' Liquidaciones de Empresas'> Liquidaciones de Empresas</a></li>
     <li><a class='dropdown-item' href='Subasta_de_fábrica_de_fundición_a_presión_es' title='Subasta de fábrica de fundición a presión'>Suscríbase</a></li>
     <li><a class='dropdown-item' href='Servicio_Gratuito_de_Localización_de_Máquinas_en_Todo_el-Mundo_es' title='Servicio Gratuito de Localización de Máquinas en Todo el Mundo'>Gratis - Servicio Gratuito de Localización de Máquinas en Todo el Mundo</a></li>
     <li><a class='dropdown-item' href='Reciba_notificaciones_de_máquinas_coincidentes_es' title='Reciba notificaciones gratuitas por correo electrónico de las máquinas que se ajustan a sus requisitos'>Gratis - Reciba notificaciones de máquinas coincidentes</a></li>
     <li><a class='dropdown-item' href='Boot-Strap-Test' title=''></a></li>
    </ul>
 
  
   <li class="nav-item"> <a class="nav-link" href="Liquidaciones_es" title="Vea nuestras liquidaciones actuales y pasadas de fábricas de fundición a presión" >LIQUIDACIONES</a></li>
 
  
   <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false" href="#" title="">ACERCA DE <b class="caret"></b></a>
    <ul class="dropdown-menu" role="menu">
        <li><a class="dropdown-item" href="Acerca_De_es" title="">ACERCA DE</a></li>
     <li><a class='dropdown-item' href='Biografía_es' title='  Biografía'>  Biografía</a></li>
     <li><a class='dropdown-item' href='Visitando_Chicago_es' title='Visitando Chicago'>Visitando Chicago</a></li>
    </ul>
 
  
   <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" role="button" data-bs-toggle="dropdown" aria-expanded="false" href="#" title="Contactos">CONTACTOS <b class="caret"></b></a>
    <ul class="dropdown-menu" role="menu">
        <li><a class="dropdown-item" href="Contactos_es" title="Contactos">CONTACTOS</a></li>
     <li><a class='dropdown-item' href='Suscríbase_a_nuestra_lista_de_correo_es' title='Suscríbase a nuestra lista de correo'>Suscríbase a nuestra lista de correo</a></li>
     <li><a class='dropdown-item' href='Compramos_su_excedente_de_maquinaria_es' title=' Compra de Maquinaria'> Compra de Maquinaria</a></li>
     <li><a class='dropdown-item' href='Sistema_de_Alerta_de_Artículos_es' title='Sistema de Alerta de Artículos'>Sistema de Alerta de Artículos</a></li>
     <li><a class='dropdown-item' href='Lista_de_posibilidades_de_fundicion_a_presion_es' title='Lista de posibilidades de fundición a presión'>Lista de posibilidades de fundición a presión</a></li>
     <li><a class='dropdown-item' href='Venta_rentable_del_sur_de_EE.UU_Die_Caster_es' title='Venta rentable del sur de EE.UU Die Caster'>Venta rentable del sur de EE.UU Die Caster</a></li>
    </ul>
 
        </ul>
      </div>
    </div>
</nav>
<!-- END MENU -->
</div>
            <? } ?>
        </div>
    </div>
    <!-- END Menu -->

    <!-- Short Text (Lead In) -->
    <div class="container-fluid home-short">
            </div>
    <!-- END Short Text (Lead In) -->

    <div class="container" style="margin-top: 0px; background-color: #FFFFFF">

        <!-- Main Content -->
        <div class="row">
            <div class='col-xs-12 col-sm-12 col-lg-12 col-md-12'>

                <!-- MAIN PAGE CONTENT -->
                <div class="mainContentHome">
                    <div class="d-none d-lg-block"><img alt="Used Conair Thermolator TW-P Series Hot Oil Temperature Control Units" class="img-responsive, hidden-xs" src="https://cdn.diecastmachinery.com/images/brand_images/Conair-Brand-Hot-Oil-Units-For-Sale.jpg" style="width: 166px; height: 102px; float: right;" /></div>

<p><br />
<b>Parse error</b>:  Unclosed '{' on line 372 in <b>/home/diecastm/public_html/modules/inventory_grids.php</b> on line <b>840</b><br />