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

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


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

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

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

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

}

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

    
    <title>Servicios de Consignación </title>
<meta name="description" content="Die Cast Machiney, LLC  Servicios de consignación para la industria de la fundición a presión"/>
<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">
                    <h3 style="text-align: center;"><span style="color:#FF0000;"><span style="font-size:16px;">Deje que Die Cast Machinery, LLC convierta su Maquinaria de Sobra en Efectivo<br />
Consigne su maquinaria hoy con Die Cast Machinery, LLC</span></span></h3>

<p>Die Cast Machinery, LLC es el distribuidor de consignaci&oacute;n mas grande en el mundo. T&iacute;picamente tenemos m&aacute;s de 100 m&aacute;quinas de consignaci&oacute;n en nuestro inventario.&nbsp;<br />
<br />
&iquest;Qu&eacute; significa &ldquo;consignar&rdquo; una maquina a Die Cast Machinery, LLC? Cuando consigna una m&aacute;quina a nosotros, nosotros nos encargamos de la venta de su m&aacute;quina. &nbsp;Comercializaremos la m&aacute;quina, contestaremos preguntas que los compradores puedan tener, y arreglamos para que los compradores puedan inspeccionar la m&aacute;quina. Tambi&eacute;n hacemos arreglos de aparejo y env&iacute;o. Maquinas consignadas pueden ser almacenadas en sus instalaciones, en uno de nuestros almacenes o de terceras personas.&nbsp;<br />
<br />
&iquest;Por qu&eacute; consignar una maquina? Seamos sinceros, esta en el negocio de fundici&oacute;n, no en el negocio de maquinaria. Hemos pasado a&ntilde;os desarrollando nuestro negocio de maquinaria. Le ofrecemos una pagina web excepcional, usamos la red social para comercializar nuestro inventario, producimos videos en tiempo real de maquinas y tenemos una base de datos de m&aacute;s de 8,000 personas trabajando en empresas de fundici&oacute;n mundialmente. Aparte, hemos pasado los &uacute;ltimos 30 a&ntilde;os vendiendo maquinaria. Si gusta recibir el mayor valor de sus m&aacute;quinas de exceso, denos la oportunidad que trabajemos para usted.&nbsp;<br />
<br />
&iquest;Cu&aacute;les son las diferentes maneras que puedo consignar una maquina? Una m&aacute;quina consignada puede seguir siendo almacenada en su almac&eacute;n hasta que se haya vendido. Si la m&aacute;quina es una de gran tama&ntilde;o, esto le disminuye el costo de aparejo y env&iacute;o de la m&aacute;quina y le deja m&aacute;s dinero en su bolsillo. En cualquier caso, vendremos a su empresa y tomaremos fotograf&iacute;as y videos de lo que su m&aacute;quina o empleados pueden hacer con ella. Necesitaremos la m&aacute;s informaci&oacute;n t&eacute;cnica que nos pueda dar acerca de la maquina para poder responder a preguntas que los compradores puedan tener. Dibujos de la m&aacute;quina, esquemas y manuales son muy importantes.&nbsp;<br />
<br />
&iquest;Qu&eacute; puedo hacer yo para ayudar el proceso? Los compradores han llegado a esperar fotograf&iacute;as detalladas, en cuanto m&aacute;s fotos y mejor informaci&oacute;n t&eacute;cnica pueda proveer, lo m&aacute;s f&aacute;cil que ser&aacute; el proceso de venta. T&oacute;mese el tiempo de limpiar alrededor de la m&aacute;quina, remueva el desorden del &aacute;rea, limpie la m&aacute;quina. Es mucho mejor si la m&aacute;quina esta en producci&oacute;n. Tome dos tipos de fotograf&iacute;as, primero tome fotograf&iacute;as en general. Me gusta empezar por detr&aacute;s de la m&aacute;quina, me gusta llamarle a esto la fotograf&iacute;a de las 12 de la tarde. Despu&eacute;s, tomo fotograf&iacute;as alrededor de la m&aacute;quina, es decir a la 1 de la tarde, 2 de la tarde, etc. Tome fotograf&iacute;as amplias, podemos recortar la fotograf&iacute;a si ensena mucha &aacute;rea, pero si no captura parte de la m&aacute;quina, no le podemos agregar esa informaci&oacute;n que le hace falta. &nbsp;Enseguida, tome fotograf&iacute;as detalladas. Si la maquina es de fundici&oacute;n, tome fotograf&iacute;as de la estaci&oacute;n de control de operaci&oacute;n (si es una maquina nueva con una pantalla t&aacute;ctil, tome fotograf&iacute;as de diferentes pantallas que ensenen las diferentes configuraciones y caracter&iacute;sticas de la m&aacute;quina). Tome fotograf&iacute;as por dentro y por fuera del panel de control, tome una foto cercana de PLC mostrando la marca y el modelo. Tome fotograf&iacute;as de las siguientes caracter&iacute;sticas: motor de altura de matriz, trinquete de seguridad a&eacute;rea, sistema de lubricaci&oacute;n, motor principal y bombas, unidad de inyecci&oacute;n (por enfrente y por detr&aacute;s), una toma cercana de la v&aacute;lvula de control de tiro/sistema. Tome fotograf&iacute;as de los rodillos m&oacute;viles y estacionarios; rodillos moviles skid-feet/machine ways. Si es posible, tome fotograf&iacute;as del sistema de expulsi&oacute;n. Nunca se puede tomar demasiadas fotograf&iacute;as. M&aacute;ndenos las im&aacute;genes originales de alta resoluci&oacute;n- no edite o reduzca el tama&ntilde;o del archivo. Si prefiere, nos puede mandar todos los dibujos y el manual del propietario y nosotros podemos digitalizar toda la informaci&oacute;n. Esto nos permite enviar un correo electr&oacute;nico a los compradores y el manual del propietario completo en formato PDF para su revisi&oacute;n.&nbsp;</p>

<p><br />
&nbsp;</p>

<p>&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>