<?
/**
 * 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>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>Acerca De</title>
<meta name="description" content=""/>
<meta name="keywords" content=""/>
<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">
                    <h1>Acerda&nbsp;de Die Cast Machinery LLC</h1>

<table align="right" border="0" cellpadding="0" width="533">
	<tbody>
		<tr>
			<td align="right"><img alt="David Kaufman, Die Cast Machinery, LLC meets with Arpad Goncz, President of Hungary " longdesc="David Kaufman, Die Cast Machinery, LLC meets with Arpad Goncz, President of Hungary " src="../UserFiles/Image/GM-Hungary-About-Us-24Kb.jpg" style="width: 310px; height: 233px;" title="David Kaufman meets with Arpad Goncz, President of Hungary " /></td>
			<td align="left"><img alt="David Kaufman, Die Cast Machinery, LLC is a guest at the grand opening of General Motors engine manufacturing plant in Szt. Gotthard" longdesc="David Kaufman, Die Cast Machinery, LLC is a guest at the grand opening of General Motors engine manufacturing plant in Szt. Gotthard" src="../UserFiles/Image/GM-Hungary-Outside-24Kb.jpg" style="width: 220px; height: 234px;" title="David Kaufman, Die Cast Machinery, LLC is a guest at the grand opening of General Motors engine manufacturing plant in Szt. Gotthard" /></td>
		</tr>
		<tr>
			<td colspan="2" style="text-align: center; background-color: rgb(255, 255, 204);">David Kaufman se re&uacute;ne con Arpad Goncz (Presidente de Hungr&iacute;a) y Louis Hughes (Presidente de GM-Europa) en la inauguraci&oacute;n de la planta de motores de General Motors en Szt. San Gotardo.</td>
		</tr>
	</tbody>
</table>

<ul>
	<li>Bob Kaufman comienza su carrera en la fundici&oacute;n a presi&oacute;n en 1939 en Kux Machinery, un importante fabricante de m&aacute;quinas de fundici&oacute;n a presi&oacute;n.</li>
	<li>En 1964 Bob inicia Bob Kaufman Machinery, Corp.</li>
	<li>En 1966 David Kaufman se unne a Bob Kaufman Machinery, Corp.</li>
	<li>1972 Bob y David lanzan Die Casting Equipment Rebuilding, Inc. convirti&eacute;ndose en un importante reconstructor de m&aacute;quinas de fundici&oacute;n a presi&oacute;n.</li>
	<li>1986 David Kaufman es elegido Presidente Nacional de la Sociedad de Ingenieros de Fundici&oacute;n a Presi&oacute;n (SDCE).</li>
	<li>En 1988 con David en la Junta de Gobernadores, la SDCE se convierte en la Asociaci&oacute;n Norteamericana de Fundici&oacute;n a Presi&oacute;n (NADCA).</li>
	<li>Steve Cochran comienza su carrera en fundici&oacute;n a presi&oacute;n en 1989, Bob Kaufman Machinery,Corp.</li>
	<li>En el 2006, David y Steve crean Die Cast Machinery, LLC.</li>
</ul>

<table align="left" border="0" cellpadding="8" width="330">
	<tbody>
		<tr>
			<td><img alt="Premier Zhu Rongji of the People's Republic of China, 5th Premier of China, meets with David Kaufman " height="217" src="../UserFiles/Image/Zhu-Rongji---China-E-320-x-.jpg" title="Premier Zhu Rongji of the People's Republic of China, 5th Premier of China, meets with David Kaufman " width="325" /></td>
		</tr>
		<tr>
			<td style="text-align: center; background-color: rgb(255, 255, 204);"><span style="font-size:12px;">El Primer Ministro Zhu Rongj de la Rep&uacute;blica Popular de China se re&uacute;ne con David Kaufman y John Littler durante una reuni&oacute;n comercial de la industria en Beijing.</span></td>
		</tr>
	</tbody>
</table>

<p>Die Cast Machinery, LLC se fund&oacute; con la creencia de que si brinda a los clientes informaci&oacute;n honesta y f&aacute;ctica, podr&aacute;n tomar decisiones comerciales acertadas.Esta pr&aacute;ctica nos ha permitido desarrollar y mantener relaciones duraderas en todo el mundo. David Kaufman, Director Em&eacute;rito de Die Cast Machinery, LLC, ha practicado esta filosof&iacute;a durante m&aacute;s de 50 a&ntilde;os, tal como lo hizo su padre, Robert (Bob) Kaufman. Bob Kaufman fue uno de los iconos en los primeros d&iacute;as de la industria de la fundici&oacute;n a presi&oacute;n en Am&eacute;rica del Norte. Bob comenz&oacute; a vender m&aacute;quinas de fundici&oacute;n en 1939 mientras trabajaba para Kux Machinery en&nbsp;Chicago.</p>

<table align="right" border="0" width="287">
	<tbody>
		<tr>
			<td><img alt="Steve inspects 3000 ton die cast machine in Germany" src="../UserFiles/Image/W-Machine-19Kb.jpg" style="width: 287px; height: 169px;" title="Steve inspects 3000 ton die cast machine in Germany" /></td>
		</tr>
		<tr>
			<td style="text-align: center; background-color: rgb(255, 255, 204);"><span style="font-size:12px;">Steve inspecciona una m&aacute;quina de fundici&oacute;n a presi&oacute;n de aluminio de c&aacute;mara fr&iacute;a de 3000 toneladas que compr&oacute; en Alemania.</span></td>
		</tr>
	</tbody>
</table>

<p>A fines de la d&eacute;cada de 1980, Steve Cochran ingres&oacute; a la industria de la fundici&oacute;n a presi&oacute;n, trabajando y aprendiendo de Bob y David. Bob falleci&oacute; en 1999, aunque su filosof&iacute;a est&aacute; muy viva. Steve es ahora el Presidente y Director de Operaciones de Die Cast Machinery, LLC. Steve y David aportan a sus clientes una experiencia combinada en la industria de m&aacute;s de 60 a&ntilde;os.</p>

<p>Die Cast Machinery, LLC se especializa en una experiencia de servicio al cliente personalizada y nos enorgullecemos en ayudar a nuestros clientes durante todo el proceso de compra. Desde la inspecci&oacute;n hasta la compra y la entrega, estamos aqu&iacute; para ayudarle. Tenemos 60 a&ntilde;os de experiencia ayudando a clientes; &iexcl;Deje que nuestros a&ntilde;os de experiencia le ayuden!</p>

<p><br />
&nbsp;</p>

<p style="text-align: left;"><br />
<br />
&nbsp;</p>

<p style="text-align: left;">&nbsp;</p>
                </div>
                <!-- END MAIN PAGE CONTENT -->

                <!-- GLOBAL FOOTER -->
                <div class="col-xs-12 col-sm-12 col-lg-12 col-md-12">
                    <div class="d-none d-md-block">
                        <div center="" class="row justify-content-center" style="text-align: center; margin-bottom: 15px;&gt;
&lt;div style=" text-align:=""><span class="btn btn-lg btn-default"><a href="tel:847-360-9170">Call - (847) 360-9170</a></span></div>
                    </div>
                </div>
                <!-- END GLOBAL FOOTER -->

            </div>

            <!-- Global Modals -->
<div class="modal fade" id="languageModal" tabindex="-1" role="dialog" aria-labelledby="languageModalLabel"
    style="display: none;" aria-hidden="true">
    <div class="modal-dialog modal-dialog-slideout modal-sm" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="languageModalLabel">Seleccione el idioma</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body">
                <ul class="list-group">
                    <li class="list-group-item"><a href="/changelanguage.php?lang=EN">English</a></li>
                    <li class="list-group-item"><a href="/changelanguage.php?lang=ES">Espanol</a></li>
                </ul>
            </div>

        </div>
    </div>
</div>
<!-- RFQ Cart Modal -->
<div class="modal fade" id="rfq-cart" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-lg">
        <div class="modal-content">
            <div id="modal-ajax-spinner" class="modal-ajax-spinner" style="display: none;">
                <span class="fa fa-spinner fa-spin fa-3x"></span>
            </div>
            <div class="modal-header d-flex justify-content-between">
                <div>
                    <h4 class="modal-title">Carro de RFQ</h4>
                </div>
                <div>
                    <button type="button" class="btn btn-md btn-primary" id="closeCartModal" data-bs-dismiss="modal"
                        aria-label="Close">
                        CONTINUAR NAVEGANDO                        <span class="glyphicon glyphicon-remove" aria-hidden="true"></span>
                    </button>
                </div>
            </div>
            <div class="modal-body">
                <div id="cartTable">
                    <p>Tiene <span id='cartCount'></span> artículo(s)  en su carro; puede continuar agregando elementos haciendo clic en cualquiera de los botones de Elementos Relacionados en la parte inferior de la página. Si ha terminado, puede solicitar sus cotizaciones haciendo clic en el botón Solicitar Cotización Ahora. </p>
                    <p></p>
                    <div class="mb-4">
                        <div class="float-md-end d-grid d-md-block me-5 ms-5 me-md-0 ms-md-0">
                            <button type="button" class="btn btn-success "
                                id="btnRequestQuote">Solicitar Cotización Ahora</button>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                    <div id="rfqCartDiv"></div>
                    <div class="formCartLinks d-none d-md-block"></div>
                </div>
                <div id="emptyCartForm">
                    <i>You have no items in your cart.</i><br />
                    <br /><br />
                    <div style="text-align: center;">
                        <button type="button" class="btn btn-primary btn-sm" id="closeCartModal2"
                            data-bs-dismiss="modal">Continue Browsing</button>
                    </div>
                    <div class="clearfix"></div>
                </div>
                <div id="cartForm" class="mb-4">
                    <div class="mb-4">Su solicitud de más informacion se ha agregado a su carro de RFQ que contiene el <span id='cartCountForm'></span> aticulo(s) enumerado a continuacion. Puede continuar navegando por nuestro inventario para agregar artículos adicionales o enviar su solicitud ahora, completando la siguiente información y haciendo clic en Enviar. </div>
                    <?
$fullName = '';
$jobTitle = '';
$companyName = '';
$businessType = '';
$customerEmail = '';
$confirmEmail = '';
$officePhone = '';
$website = '';
$validatorMessage = '';
if (isset($_SESSION['fullName'])) $fullName = $_SESSION['fullName'];
if (isset($_SESSION['jobTitle'])) $jobTitle = $_SESSION['jobTitle'];
if (isset($_SESSION['companyName'])) $companyName = $_SESSION['companyName'];
if (isset($_SESSION['businessType'])) $businessType = $_SESSION['businessType'];
if (isset($_SESSION['customerEmail'])) $customerEmail = $_SESSION['customerEmail'];
if (isset($_SESSION['confirmEmail'])) $confirmEmail = $_SESSION['confirmEmail'];
if (isset($_SESSION['officePhone'])) $officePhone = $_SESSION['officePhone'];
if (isset($_SESSION['website'])) $website = $_SESSION['website'];
if (isset($_SESSION['rfqValidatorMessage'])) $validatorMessage = $_SESSION['rfqValidatorMessage'];
$cartList = GetCartCommaDelimited();
$form = '
<form method="post" class="form-horizontal" id="cartForm">
    <div class="alert alert-danger" id="validatorAlert">'.$validatorMessage.'</div>
    <div class="form-group mb-3">
        <label for="fullName" class="col-sm-2 control-label">' . $lang->fetchPhrase('phrase_full_name') . '</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="fullName" id="fullName" value="'.$fullName.'" />
        </div>
    </div>
    <div class="form-group mb-3">
        <label for="companyName" class="col-sm-2 control-label">' .  $lang->fetchPhrase('phrase_company_name') . '</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="companyName" id="companyName" value="'.$companyName.'" />
        </div>
    </div>
    <div class="form-group">
        <label for="customerEmail" class="col-sm-2 control-label">' .  $lang->fetchPhrase('phrase_contact_email') . '</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="customerEmail" id="customerEmail" value="'.$customerEmail.'" />
        </div>
    </div>
    <div id="formCartList" class="my-4"></div>
    <div class="row">
        <div class="col">
            &nbsp;
        </div>
        <div class="col d-grid d-md-block text-end">
            <input onclick="return gtag_report_conversion(\'http://diecastmachinery/cart_form_modal\')" class="btn btn-success btn-sm" type="submit" id="CartFormSubmit" name="CartFormSubmit"  value="' . $lang->fetchPhrase('phrase_submit') . '" >
        </div>
    </div>
    <div class="clearfix"></div>
    <input type="hidden" name="validateMsg1" id="validateMsg1" value="' . $lang->fetchPhrase('RFQ_Cart_ERROR_Message_1') . '">
    <input type="hidden" name="validateMsg2" id="validateMsg2" value="' . $lang->fetchPhrase('RFQ_Cart_ERROR_Message_2') . '">
    <input type="hidden" name="validateMsg3" id="validateMsg3" value="' . $lang->fetchPhrase('RFQ_Cart_ERROR_Message_3') . '">
    <input type="hidden" name="validateMsg4" id="validateMsg4" value="' . $lang->fetchPhrase('RFQ_Cart_ERROR_Message_4') . '">
</form>';
$pageHtml = $form;
echo $pageHtml;
?>                </div>
                <div id="askItemAlert">
                    <p>
                        <strong>¡Su petición esta siendo procesada!</strong>
                    </p>
                    <p>
                        ¿Le gustaría recibir alertas automaticas gratuitas por correo electronico cuando este disponible un nuevo inventario que coincida con esta máquina?                    </p>
                    <div class="row">
                        <div class="col-md-12 pull-right">
                            <input type="hidden" id="buyeremail" name="buyeremail"
                                value="" />
                            <button type="button" class="btn btn-success btn-sm"
                                id="btnAlertsYes">Si, envíeme Actualizaciones Gratuitas</button>
                            <button type="button" class="btn btn-warning btn-sm"
                                id="btnAlertsNo">No, Gracias</button>
                        </div>
                    </div>
                </div>
                <div id="itemAlertSignup">
                    <?
$fullName = '';
$companyName = '';
$customerEmail = '';
$validatorMessage = '';

if (isset($_SESSION['fullName']))
    $fullName = $_SESSION['fullName'];
if (isset($_SESSION['companyName']))
    $companyName = $_SESSION['companyName'];
if (isset($_SESSION['customerEmail']))
    $customerEmail = $_SESSION['customerEmail'];
if (isset($_SESSION['rfqValidatorMessage']))
    $validatorMessage = $_SESSION['rfqValidatorMessage'];
$cartList = GetTempCartCommaDelimited();
?>
<div class="alert alert-danger" id="validatorAlert" style="display: none">''</div>
<div class="alert alert-success" id="validatorAlertSuccess" style="display:none;"></div>


<div class="col-md-6" id="alertsignupsummary">
    <h2>Configuración De Su Cuenta De Alerta</h2>
    <p class="ps-3">
        Nombre: <span id="textFullName"><br />
<b>Warning</b>:  Undefined variable $fullName in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>24</b><br />
</span>
    </p>
    <p class="ps-3">
        Empresa: <span id="textCompanyName"><br />
<b>Warning</b>:  Undefined variable $companyName in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>27</b><br />
</span>
    </p>
    <p class="ps-3">
        Nombre de Usuario (Correo Electrónico):: <span id="textEmail"><br />
<b>Warning</b>:  Undefined variable $customerEmail in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>30</b><br />
</span>
    </p>
</div>
<div class="col-md-6" id="alertsignupform">
    <div class="alert alert-danger" id="validatorAlert2" style="display:none;"></div>

    <div class="mb-3">
        <label for="customerPwd" class="form-label">Contraseña</label>
        <input type="password" required class="form-control" name="customerPwd" id="customerPwd" />
    </div>

    <div class="mb-3">
        <label for="customerPwdMatch" class="form-label">Reingresar contraseña</label>
        <input type="password" required class="form-control" name="customerPwdMatch" id="customerPwdMatch" />

    </div>
</div>

<div>
    <div class="pull-right">
        <input type="hidden" name="tempCart" id="tempCart" value="<br />
<b>Warning</b>:  Undefined variable $cartList in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>50</b><br />
" />
        <input type="hidden" name="customerEmail" id="customerEmail" value="<br />
<b>Warning</b>:  Undefined variable $customerEmail in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>51</b><br />
" />
        <input type="hidden" name="customerName" id="customerName" value="<br />
<b>Warning</b>:  Undefined variable $fullName in <b>/home/diecastm/public_html/modules/cart_form_askalert.php</b> on line <b>52</b><br />
" />
        <input type="hidden" name="msgValidatePasswordMatch" id="msgValidatePasswordMatch"
            value="Las contraseñas deben coincidir" />
        <input type="hidden" name="msgSuccessNewAccount" id="msgSuccessNewAccount"
            value="Su cuenta se ha creado correctamente. Debería recibir un correo electrónico con un enlace para validar el correo electrónico que sometió. Deberá completar la validación para recibir alertas." />

        <button class="btn btn-success btn-sm mt-3" id="CartAlertSubmit"
            name="CartAlertSubmit">Enviar</button>

        <button class="btn btn-success btn-sm mt-3" id="AlertDoneSubmit" name="AlertDoneSubmit"
            style="display:none">Cerrar</button>
    </div>
</div>
<div class="clearfix"></div>                </div>
                <div id="itemAlertExistingUser">
                    <p><strong>Su correo electrónico ya está asociado con una cuenta.</strong></p>
                    <p>
                        <a href="itemalert.php">Haga clic aquí para iniciar sesión y agregar estas alertas a su cuenta existente.</a>
                    </p>
                </div>
                <div id="cartFormSubmitted">
                    <h2 style="text-align: center;">Gracias por visitar nuesto sitio web y por su interes en nuestra maquinaria.</h2>

<p style="text-align: center;">Nuestros profesionales le responderan con cotizaciones lo mas pronto posible.<br />
Puede ver todo nuestro inventario en: <a href="/diecastmachinery.com/Inventario_es">www.diecastmachinery.com</a><br />
Si tiene cualquier otra pregunta por favor cont&aacute;ctenos haciendo <a href="https://diecastmachinery.com/Contactos_es">clic aqu&iacute;</a>.&nbsp;<br />
<img alt="Gracias" src="/Company_Images/images/Foreign_Lang_Version/es/Gracias.jpg" style="width: 467px; height: 257px;" /></p>
                    <div style="text-align: center;">
                        <div class="formCartLinks"></div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
<!-- END RFQ Cart Modal -->
<!-- RFQ Cart Form Processing Modal -->
<div class="modal fade" id="rfq-cart-processing" tabindex="-1" role="dialog">
    <div class="modal-dialog modal-sm">
        <div class="modal-content">
            <div class="modal-body">
                <div>Please wait while we process your items.</div>
                <br />
                <div style="font-size: 1.8em; text-align: center;"><i class="fa fa-spinner fa-spin"
                        aria-hidden="true"></i></div>
            </div>
        </div>
    </div>
</div>        </div>
        <!-- END Main Content -->

        <!-- GLOBAL FOOTER COPYRIGHT -->
        <div class="container-fluid home-footer d-none d-md-block text-center">
                                    <p style="text-align: center;"><span style="color:#FFFFFF;">Die Cast Machinery, LLC with 60 plus years of Die Casting Industry Experience is your first choice to help you with your factory needs.</span></p>

<p style="text-align: center;">Die Cast Machinery, LLC</p>

<p style="text-align: center;">3246 W. Monroe Street Waukegan, Illinois 60085-3029 USA<br />
Phone: <a class="text-light" href="tel:18473609170">1-847-360-9170</a>&nbsp;<br />
Website Copyrights &copy; 2006 - 2026&nbsp;- All Rights Reserved - POWERED BY <a class="text-light" href="https://www.tntgroup.com">TNT Production Group</a></p>
            <? if (isset($globalresult->geotarget))
                echo "<br />" . $globalresult->geotarget; ?>
            <? // Service Area Links Goe Here
            $sql2 = "SELECT * FROM pages WHERE showit='Y' AND page_type='GEO-LANDING' ORDER BY myorder";
            if ($sql_result2 = $mysqli->query($sql2)) {
                while ($subrow = $sql_result2->fetch_object()) {
                    $my_title = str_replace("_", " ", $subrow->menutitle);
                    echo "<a href='serving-" . $subrow->page_filename . "'>" . $my_title . "</a>&nbsp;";
                }
            }
            ?>
        </div>
        <!-- END GLOBAL FOOTER COPYRIGHT -->
    </div>

    <script src="js/jquery.lazy.min.js" type="text/javascript"></script>
    <script src="https://cdn.jsdelivr.net/npm/instantsearch.js@4.77.3/dist/instantsearch.production.min.js"
        integrity="sha256-lOteBl/i/zTTeWI1iC+/s/eRPgFG3pNxRamGNbR5RX0=" crossorigin="anonymous"></script>

    <!-- <script src="libraries/jquery-ui-1.13.1/jquery-ui.min.js"></script> -->
    <script src="https://code.jquery.com/ui/1.14.1/jquery-ui.min.js"></script>

    <script src="js/app-v01292025.js"></script>

    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"
        integrity="sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz"
        crossorigin="anonymous"></script>

    <script src="https://cdn.jsdelivr.net/npm/algoliasearch@5.20.0/dist/lite/builds/browser.umd.js"
        integrity="sha256-tTO9F6qxGqS4rC8mKdz+oinKknz0JHPp1ZrGOeds+Uw=" crossorigin="anonymous"></script>

    <script>
        // DELAYEDALERT BOXES
        var seconds = 15;
        var alert1Interval = setInterval(countDownForAlert1, 1000);
        var seconds5 = 5;
        var alert2Interval = setInterval(countDownForAlert2, 1000);

        $(document).ready(function () {
            //for the 10-second delay alert box
            $("#alertMsgClose").click(function () {
                $("#alertMsg").fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100); //Flash DIV
                $("#alertMsg").hide()
            });

            //for the 10-second delay alert box
            $("#alertMsgClose").click(function () {
                $("#alertMsg2").fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100); //Flash DIV
                $("#alertMsg2").hide()
            });
        });
        function countDownForAlert1() {
            seconds--;
            //$("#seconds").text(seconds);
            if (seconds === 0) {
                $("#alertMsg").show(1000);
                $("#alertMsg").fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100); //Flash DIV
                clearInterval(alert1Interval);
            }
        }

        function countDownForAlert2() {
            seconds5--;
            //$("#seconds").text(seconds);
            if (seconds5 === 0) {
                $("#alertMsg2").show(1000);
                $("#alertMsg2").fadeIn(100).fadeOut(100).fadeIn(100).fadeOut(100).fadeIn(100); //Flash DIV
                clearInterval(alert2Interval);
            }
        }
    </script>


    <script>
        //Language Stuff
        $thelang = "ES";
        if ($thelang == 'ES') {
            $itemURL = 'itemURL_sp';
            $categoryLabel = 'category_es';
            $categoryURL = 'categoryURL_es';
            $description = 'description_es'
            $categoryText = 'Categoría';
            $brandText = 'Marca';
            $brandURL = 'brandURL_es';
            $searchText = 'Buscar inventario disponible';
        } else {
            $itemURL = 'itemURL';
            $categoryLabel = 'category';
            $categoryURL = 'categoryURL';
            $description = 'description'
            $categoryText = 'Category';
            $brandText = 'Brand';
            $brandURL = 'brandURL';
            $searchText = 'Search Our Inventory'
        }

        const { liteClient: algoliasearch } = window['algoliasearch/lite'];
        const searchClient = algoliasearch(
            'ZC9BZKZ9UX',
            'a9c0c0af73d229260d121f7594f61a7f'
        );

        const search = instantsearch({
            indexName: 'prod_INVENTORY',
            searchParameters: {
                hitsPerPage: 60,
                attributesToSnippet: ["description"]
            },
            searchClient: searchClient,
            searchFunction: function (helper) {
                if (helper.state.query === '') {
                    document.querySelector('#hits').innerHTML = '';
                    return;
                }
                helper.search();
            }
        });

        search.addWidgets([
            instantsearch.widgets.searchBox({
                container: '#searchbox',
            }),

            instantsearch.widgets.hits({
                container: '#hits',
                templates: {
                    item:
                        '<a href="{{' + $itemURL + '}}">\n' +
                        '   <div class="text-center"><img src="{{imageurl}}" class="search-image img-fluid" alt="{{name}}" /></div>\n' +
                        '</a>\n' +
                        '<a href="{{' + $itemURL + '}}">\n' +
                        '   <div class="searchdescription mt-2">\n' +
                        '       {{#helpers.highlight}}{ "attribute": "' + $description + '", "highlightedTagName": "mark" }{{/helpers.highlight}}\n' +
                        '   </div>\n' +
                        '</a>' +
                        '<div class="mt-2 mb-0">' +
                        '   <strong>' + $categoryText + ':</strong>' +
                        '   <a href="{{' + $categoryURL + '}}">\n' +
                        '       {{#helpers.highlight}}{ "attribute":  "' + $categoryLabel + '", "highlightedTagName": "mark" }{{/helpers.highlight}}\n' +
                        '   </a>\n' +
                        '</div>' +
                        '<div class="mt-1">\n' +
                        '   <strong>' + $brandText + ':</strong>\n' +
                        '   <a href="{{' + $brandURL + '}}">\n' +
                        '       {{#helpers.highlight}}{ "attribute": "brand", "highlightedTagName": "mark" }{{/helpers.highlight}}\n' +
                        '   </a>\n' +
                        '</div>'
                }
            })
        ]);

        // INSTANT SEARCH
        search.start();

        // SEARCHBOX
        $(document).ready(function () {
            $('.ais-SearchBox-input').attr('placeholder', $searchText);
            $('.ais-SearchBox-input').attr('aria-label', 'Click and type here to search our inventory');
            $('.ais-SearchBox-input').on('change keyup paste mouseup', function () {
                if ($('.ais-SearchBox-input').val().length > 1) {
                    $('#hits').show();
                } else {
                    $('#hits').hide();
                }
            });

            $('.ais-SearchBox-reset').on('click', function () {
                $('#hits').hide();
            });
        });

        var interval = setInterval(function () {
            if ($('.lazyme').length) {
                $('.lazyme').lazy(
                    {
                        effect: "fadeIn",
                        effectTime: 600,
                        threshold: 0,
                        onError: function (element) {
                            console.log('Error loading ' + element.data('src'));
                        }
                    });
            }
        }, 100);
    </script>

</body>

</html>