function m_showSitemap()
{
$libFunc = new c_libFunctions();
if (!isset($this->request['mode'])) {
$this->request['mode'] = 0;
}
$this->ObTpl = new template();
$this->ObTpl->set_file("TPL_SITEMAP_FILE", $this->siteMapTemplate);
$this->ObTpl->set_var("TPL_VAR_SITEURL", SITE_URL);
$this->ObTpl->set_var("TPL_VAR_GRAPHICSURL", GRAPHICS_PATH);
$siteMapUrl = SITE_URL . "index.php?action=sitemap";
$this->ObTpl->set_var("TPL_VAR_SITEMAPURL", $libFunc->m_safeUrl($siteMapUrl));
#SETTING TEMPLATE BLOCKS
$this->ObTpl->set_block("TPL_SITEMAP_FILE", "TPL_MAINDEPARTMENT_BLK", "maindept_blk");
$this->ObTpl->set_block("TPL_MAINDEPARTMENT_BLK", "TPL_DEPARTMENT_BLK", "dept_blk");
$this->ObTpl->set_block("TPL_DEPARTMENT_BLK", "TPL_MAINSUBDEPT_BLK", "mainSubDept_blk");
$this->ObTpl->set_block("TPL_MAINSUBDEPT_BLK", "TPL_SUBDEPT_BLK", "subDept_blk");
$this->ObTpl->set_block("TPL_DEPARTMENT_BLK", "TPL_MAINSUBPRODUCT_BLK", "mainSubProduct_blk");
$this->ObTpl->set_block("TPL_MAINSUBPRODUCT_BLK", "TPL_SUBPRODUCT_BLK", "subProduct_blk");
$this->ObTpl->set_block("TPL_DEPARTMENT_BLK", "TPL_MAINSUBCONTENT_BLK", "mainSubContent_blk");
$this->ObTpl->set_block("TPL_MAINSUBCONTENT_BLK", "TPL_SUBCONTENT_BLK", "subContent_blk");
$this->ObTpl->set_block("TPL_SITEMAP_FILE", "TPL_MENU_BLK", "menu_blk");
$this->ObTpl->set_block("TPL_MENU_BLK", "TPL_MENUITEM_BLK", "menuitem_blk");
$this->ObTpl->set_block("TPL_SITEMAP_FILE", "TPL_MAINCONTENT_BLK", "mainContent_blk");
$this->ObTpl->set_block("TPL_MAINCONTENT_BLK", "TPL_CONTENT_BLK", "content_blk");
#INTIALIZING
$this->ObTpl->set_var("maindept_blk", "");
$this->ObTpl->set_var("dept_blk", "");
$this->ObTpl->set_var("menu_blk", "");
$this->ObTpl->set_var("menuitem_blk", "");
$this->ObTpl->set_var("mainContent_blk", "");
$this->ObTpl->set_var("content_blk", "");
#QUERY TO GET DEPARTMENTS UNDER SELECTED DEPARTMENT
$this->obDb->query = "SELECT vTitle,vSeoTitle,iDeptid_PK FROM " . DEPARTMENTS . " D, " . FUSIONS . " F WHERE (iDeptid_PK=iSubId_FK AND vtype='department' AND iOwner_FK='0' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowDept = $this->obDb->fetchQuery();
$deptCount = $this->obDb->record_count;
if ($deptCount > 0) {
for ($i = 0; $i < $deptCount; $i++) {
$deptUrl = SITE_URL . "index.php?action=sitemap&mode=" . $rowDept[$i]->vSeoTitle;
$count = 0;
$this->ObTpl->set_var("mainSubDept_blk", "");
$this->ObTpl->set_var("subDept_blk", "");
$this->ObTpl->set_var("mainSubProduct_blk", "");
$this->ObTpl->set_var("subProduct_blk", "");
$this->ObTpl->set_var("mainSubContent_blk", "");
$this->ObTpl->set_var("subContent_blk", "");
# 15/02/2008 TO CHECK IF THERE ARE ANY PRODUCTS - DEPARTMENTS - CONTENTS UNDER DEPARTMENT
$this->obDb->query = "SELECT vTitle,vSeoTitle,iDeptid_PK FROM " . DEPARTMENTS . " D, " . FUSIONS . " F WHERE (iDeptid_PK=iSubId_FK AND vtype='department' AND iOwner_FK='" . $rowDept[$i]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowDepartment = $this->obDb->fetchQuery();
$departmentCount = $this->obDb->record_count;
if ($departmentCount > 0) {
$count++;
}
$this->obDb->query = "SELECT vTitle,vSeoTitle FROM " . PRODUCTS . " D, " . FUSIONS . " F WHERE (iProdid_PK=iSubId_FK AND vtype='product' AND iOwner_FK='" . $rowDept[$i]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowProduct = $this->obDb->fetchQuery();
$productCount = $this->obDb->record_count;
if ($productCount > 0) {
$count++;
}
$this->obDb->query = "SELECT vTitle,vSeoTitle FROM " . CONTENTS . " D, " . FUSIONS . " F WHERE (iContentid_PK=iSubId_FK AND vtype='content' AND iOwner_FK='" . $rowDept[$i]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowContent = $this->obDb->fetchQuery();
$contentCount = $this->obDb->record_count;
if ($contentCount > 0) {
$count++;
}
if ($count == 0) {
$deptUrl = SITE_URL . "ecom/index.php?action=ecom.details&mode=" . $rowDept[$i]->vSeoTitle;
}
$this->ObTpl->set_var("TPL_VAR_DEPTURL", $libFunc->m_safeUrl($deptUrl));
$this->ObTpl->set_var("TPL_VAR_DEPTTITLE", $libFunc->m_displayContent($rowDept[$i]->vTitle));
#SUB ITEMS
if (!empty($this->request['mode']) && $rowDept[$i]->vSeoTitle == $this->request['mode']) {
#TO GET OWNER
$this->obDb->query = "SELECT iDeptid_PK FROM " . DEPARTMENTS . " WHERE vSeoTitle='" . $this->request['mode'] . "'";
$rsDeptID = $this->obDb->fetchQuery();
$modeCount = $this->obDb->record_count;
if ($modeCount > 0) {
#QUERY TO GET DEPARTMENTS UNDER SELECTED DEPT
$this->obDb->query = "SELECT vTitle,vSeoTitle,iDeptid_PK FROM " . DEPARTMENTS . " D, " . FUSIONS . " F WHERE (iDeptid_PK=iSubId_FK AND vtype='department' AND iOwner_FK='" . $rsDeptID[0]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowDepartment = $this->obDb->fetchQuery();
$departmentCount = $this->obDb->record_count;
if ($departmentCount > 0) {
for ($d = 0; $d < $departmentCount; $d++) {
$productUrl = SITE_URL . "ecom/index.php?action=ecom.details&mode=" . $rowDepartment[$d]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_SUBDEPURL", $libFunc->m_safeUrl($productUrl));
$this->ObTpl->set_var("TPL_VAR_SUBDEPTTITLE", $libFunc->m_displayContent($rowDepartment[$d]->vTitle));
$this->ObTpl->parse("subDept_blk", "TPL_SUBDEPT_BLK", true);
}
$this->ObTpl->parse("mainSubDept_blk", "TPL_MAINSUBDEPT_BLK");
}
#QUERY TO GET PRODUCTS UNDER SELECTED DEPT
$this->obDb->query = "SELECT vTitle,vSeoTitle FROM " . PRODUCTS . " D, " . FUSIONS . " F WHERE (iProdid_PK=iSubId_FK AND vtype='product' AND iOwner_FK='" . $rsDeptID[0]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowProduct = $this->obDb->fetchQuery();
$productCount = $this->obDb->record_count;
if ($productCount > 0) {
for ($p = 0; $p < $productCount; $p++) {
$productUrl = SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $rowProduct[$p]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_SUBPRODUCTURL", $libFunc->m_safeUrl($productUrl));
$this->ObTpl->set_var("TPL_VAR_SUBPRODUCTTITLE", $libFunc->m_displayContent($rowProduct[$p]->vTitle));
$this->ObTpl->parse("subProduct_blk", "TPL_SUBPRODUCT_BLK", true);
}
$this->ObTpl->parse("mainSubProduct_blk", "TPL_MAINSUBPRODUCT_BLK");
}
#QUERY TO GET CONTENTS UNDER SELECTED DEPT
$this->obDb->query = "SELECT vTitle,vSeoTitle FROM " . CONTENTS . " D, " . FUSIONS . " F WHERE (iContentid_PK=iSubId_FK AND vtype='content' AND iOwner_FK='" . $rsDeptID[0]->iDeptid_PK . "' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowContent = $this->obDb->fetchQuery();
$contentCount = $this->obDb->record_count;
if ($contentCount > 0) {
for ($c = 0; $c < $contentCount; $c++) {
$contentUrl = SITE_URL . "ecom/index.php?action=ecom.cdetails&mode=" . $rowContent[$c]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_SUBCONTENTURL", $libFunc->m_safeUrl($contentUrl));
$this->ObTpl->set_var("TPL_VAR_SUBCONTENTTITLE", $libFunc->m_displayContent($rowContent[$c]->vTitle));
$this->ObTpl->parse("subContent_blk", "TPL_SUBCONTENT_BLK", true);
}
$this->ObTpl->parse("mainSubContent_blk", "TPL_MAINSUBCONTENT_BLK");
}
#END CONTENT COUNT
}
#END MODE COUNT
}
#END MODE CHECK
$this->ObTpl->parse("dept_blk", "TPL_DEPARTMENT_BLK", true);
}
$this->ObTpl->parse("maindept_blk", "TPL_MAINDEPARTMENT_BLK");
}
#QUERY TO GET MENU ITEMS
#QUERY MENU TABLE
$this->obDb->query = "SELECT iHeaderid_PK,vHeader,vImage FROM " . MENUHEADERS . " WHERE iState='1' ORDER BY iSort";
$rsMenuHead = $this->obDb->fetchQuery();
$rsMenuHeadCount = $this->obDb->record_count;
if ($rsMenuHeadCount > 0) {
for ($i = 0; $i < $rsMenuHeadCount; $i++) {
$this->obDb->query = "SELECT iMenuItemsId,vItemtitle,vLink,vHrefAttributes,vImage FROM " . MENUITEMS . " WHERE iState='1' AND iHeaderid_FK='" . $rsMenuHead[$i]->iHeaderid_PK . "' ORDER BY iSort";
$rsMenu = $this->obDb->fetchQuery();
$rsMenuCount = $this->obDb->record_count;
if ($rsMenuCount > 0) {
$this->ObTpl->set_var("menuitem_blk", "");
for ($j = 0; $j < $rsMenuCount; $j++) {
$this->ObTpl->set_var("TPL_VAR_MENUTITLE", $libFunc->m_displayContent($rsMenu[$j]->vItemtitle));
$this->ObTpl->set_var("TPL_VAR_MENUURL", $libFunc->m_displayContent($rsMenu[$j]->vLink));
$this->ObTpl->set_var("TPL_VAR_HREFATTRIBUTES", $libFunc->m_displayContent($rsMenu[$j]->vHrefAttributes));
$this->ObTpl->parse("menuitem_blk", "TPL_MENUITEM_BLK", true);
}
$this->ObTpl->set_var("TPL_VAR_MENUHEAD", $libFunc->m_displayContent($rsMenuHead[$i]->vHeader));
$this->ObTpl->parse("menu_blk", "TPL_MENU_BLK", true);
} else {
$this->ObTpl->set_var("menuitem_blk", "");
}
}
}
#QUERY TO GET CONTENTS UNDER SELECTED HOMEPAGE
$this->obDb->query = "SELECT vTitle,vSeoTitle FROM " . CONTENTS . " D, " . FUSIONS . " F WHERE (iContentid_PK=iSubId_FK AND vtype='content' AND iOwner_FK='0' AND vOwnerType='department' AND iState='1') ORDER BY iSort";
$rowContent = $this->obDb->fetchQuery();
$contentCount = $this->obDb->record_count;
if ($contentCount > 0) {
for ($c = 0; $c < $contentCount; $c++) {
$contentUrl = SITE_URL . "ecom/index.php?action=ecom.cdetails&mode=" . $rowContent[$c]->vSeoTitle;
$this->ObTpl->set_var("TPL_VAR_CONTENTURL", $libFunc->m_safeUrl($contentUrl));
$this->ObTpl->set_var("TPL_VAR_CONTENTTITLE", $libFunc->m_displayContent($rowContent[$c]->vTitle));
$this->ObTpl->parse("content_blk", "TPL_CONTENT_BLK", true);
}
$this->ObTpl->parse("mainContent_blk", "TPL_MAINCONTENT_BLK");
}
return $this->ObTpl->parse("return", "TPL_SITEMAP_FILE");
}
#======================== PRODUCTS LINKS=====================
# GETTING PRODUCTS FROM DATABASE
$obDatabase->query = " SELECT distinct vTitle,vSeoTitle,iProdid_PK,tmBuildDate,tmEditDate FROM " . PRODUCTS . " P, " . FUSIONS . " F " . " WHERE (P.iProdid_PK=F.iSubId_FK " . " AND vtype='product' " . " AND iState=1) ORDER BY tmBuildDate";
$prodRows = $obDatabase->fetchQuery();
$prodRowsRecord = $obDatabase->record_count;
#CHECK IF PRODUCT EXISTS
if ($prodRowsRecord > 0) {
#LOOP THROUGH ALL RECORDS
for ($i = 0; $i < $prodRowsRecord; $i++) {
$lastmod = "";
if ($prodRows[$i]->tmEditDate > 0) {
$lastmod = $s->searchEngineDateFormat($prodRows[$i]->tmEditDate);
} else {
$lastmod = $s->searchEngineDateFormat($prodRows[$i]->tmBuildDate);
}
$loc = $libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $prodRows[$i]->vSeoTitle);
#ADDING DEPARTMENT LINK INTO XML SITEMAP
$s->addItem($loc, $lastmod, PRODUCT_CHANGEFREQ, PRODUCT_PRIORITY);
}
}
#======================== CONTENTS LINKS=====================
# GETTING CONTENTS FROM DATABASE
$obDatabase->query = " SELECT distinct vTitle,vSeoTitle,iContentid_PK,tmBuildDate,tmEditDate FROM " . CONTENTS . " C, " . FUSIONS . " F " . " WHERE (C.iContentid_PK=F.iSubId_FK " . " AND vtype='content' " . " AND iState=1) ORDER BY tmBuildDate";
$contentRows = $obDatabase->fetchQuery();
$contentRowsRecord = $obDatabase->record_count;
#CHECK IF PRODUCT EXISTS
if ($prodRowsRecord > 0) {
#LOOP THROUGH ALL RECORDS
for ($i = 0; $i < $contentRowsRecord; $i++) {
$lastmod = "";
if ($contentRows[$i]->tmEditDate > 0) {
global $sModule;
switch ($sModule) {
case "ecom":
$obEcomAdmin = new c_ecomController($obDatabase, $obMainTemplate, $attributes);
break;
case "user":
$obUserAdmin = new c_userController($obDatabase, $obMainTemplate, $attributes);
break;
default:
$obHomeDisplay = new c_homeDisplay($obDatabase, $obMainTemplate, $attributes);
break;
}
}
$obMainTemplate->set_var("TPL_VAR_CURRENCY", CONST_CURRENCY);
$libFunc = new c_libFunctions();
$myShopUrl = $libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.viewcart");
$obMainTemplate->set_var("TPL_VAR_CARTLINK", $myShopUrl);
if (isset($_SESSION['grandTotal'])) {
$obMainTemplate->set_var("TPL_VAR_GRANDTOTAL", number_format($_SESSION['grandTotal'], 2, '.', ''));
$obMainTemplate->set_var("TPL_VAR_TOTALQTY", $_SESSION['totalQty']);
} else {
$obMainTemplate->set_var("TPL_VAR_GRANDTOTAL", '0.00');
$obMainTemplate->set_var("TPL_VAR_TOTALQTY", '0');
}
if ($libFunc->ifSet($_SESSION, "cssSelectedFile", "")) {
$obMainTemplate->set_var("TPL_VAR_CSSFILE", trim($_SESSION['cssSelectedFile']));
} else {
$obMainTemplate->set_var("TPL_VAR_CSSFILE", trim(DEFAULT_CSS));
}
$accessibility = $libFunc->m_safeUrl(SITE_URL . "index.php?action=cms&mode=accessibility");
$obMainTemplate->set_var("TPL_VAR_ACCESSIBILITY", $accessibility);
