<?php $toandanhmuc = $_POST['CheckAllCate' . $idcommon] != '' ? 1 : 0; //NEU CHON TOAN BO DANH MUC //them moi vo bang tbl_module_pro_common $where11 = whereParentLevel($tableCategoryConfigId, $parent_categor); $sqlcommon_pro = "select * from {$tableConfigId} where {$where11} or id=" . $oldid . " and {$whereStatus}"; $resultcommon_pro = @mysql_query($sqlcommon_pro, $conn); while ($common_pro = @mysql_fetch_array($resultcommon_pro)) { if ($toandanhmuc == '0') { //KIEM TRA CO CHON TOAN BO DANH MUC HAY KHONG $commonDef = $common_pro['id'] == $oldid ? '1' : '0'; } elseif ($toandanhmuc == '1') { //NEU CHON TAON BO DANH MUC $commonDef = 1; } //KIEM TRA CO CHON TOAN BO DANH MUC HAY KHONG===KET THUC $id_common_pro = $common_pro['id']; $id_common_pro_parent = $common_pro['parent']; $fields_arrcommon_pro = array("id_parent" => "{$id_parent}", "id_code" => "'{$oldid}'", "id_pro_common" => "'{$id_common_pro}'", "id_common" => "'{$idcommon}'", "parent_categor" => "'{$id_common_pro_parent}'", "common" => "{$commonDef}", "status" => "0", "date_added" => "now()", "last_modified" => "now()"); if (!countRecord($tableConfigCommon_product, "id_code=" . $oldid . " and id_common=" . $idcommon . " and id_pro_common=" . $id_common_pro)) { //kiem tra neu trong bang chua co thi them moi $resultcommon_proInsertDD = insert($tableConfigCommon_product, $fields_arrcommon_pro); } } if ($toandanhmuc == '0') { //KIEM TRA CO CHON TOAN BO DANH MUC HAY KHONG //update them moi if ($_POST['common' . $idcommon] != '') { $wherecommon_pro = ''; foreach ($_POST['common' . $idcommon] as $idcommon_pro) {
</td> </tr> </table></td> </tr> <tr> <td align="left" colspan="2" valign="top" id="showComes_div"> <?php //echo $comes; if ($comes != '0' and $comes != '') { $whereComes = whereParentLevel($tableCategoryConfigId, $comes); $showComesAll = ' <div class="div_scroll" style="height:160px; width:95%; float:left"> <table border="0" cellspacing="0" cellpadding="0">'; $sqlComes = "select * from {$tableConfigId} where " . $whereComes; $resultComes = mysql_query($sqlComes, $conn); while ($Comes = mysql_fetch_array($resultComes)) { $id_common_pro_parent = $Comes['parent']; $CommonName1 = getRecord($tableConfig, 'id_code=' . $Comes['id'] . " and lang='" . $_lang_A . "'"); $checkeComesShow = countRecord($tableConfigComes_product, 'id_code=' . $oldid . ' and id_comes=' . $Comes['id'] . ' and comes=1'); $checkedshowCommonAllDefault = $checkeComesShow == 1 ? 'checked="checked"' : ''; $showComesAll .= ' <tr> <td align="left" valign="middle" class="smallfont" style="padding-left:2px; padding-right:4px;"> <input name="comesChack[]" id="comesChack' . $Comes['id'] . '" type="checkbox" value="' . $Comes['id'] . '" ' . $checkedshowCommonAllDefault . ' /> </td> <td align="left" valign="middle" class="smallfont" style="padding-left:0px; padding-right:4px;">' . $CommonName1['name'] . '</td>
$con_type4 = ''; //kiem tra danh muc nay co menu con khong $con_typeShow4 = ''; $keywords4 = strip_tags(str_replace('"', "", $rowMenuProductNam4['keywords'])); $description4 = strip_tags(str_replace('"', "", $rowMenuProductNam4['description'])); $array_where1 .= ",'" . $IdMenuProduct4 . "'"; $array_where2 .= ",'" . $IdMenuProduct4 . "'"; $array_where3 .= ",'" . $IdMenuProduct4 . "'"; $nameMenuProduct4 = str_replace($ojer, $ojers, $rowMenuProductNam4['name']); $titleMenuProduct4 = str_replace($ojer, $ojers, $rowMenuProductNam4['title_t']); $IdMenuProduct4 = $rowMenuProduct4['id']; $urlMenuProduct4 = $rowMenuProductNam4['url']; $parentMenuProduct4 = $rowMenuProduct4['parent']; $parentMenuProduct4_1 = $rowMenuProduct4['parent_1']; $imageProduct4 = $rowMenuProduct4['image']; $whereProduct4 = "(" . whereParentLevel($tableCategoryNewId, $IdMenuProduct4) . ")"; $totalProduct4 = countRecord($tableNewId, $whereProduct4); //tong sp muc nay $totalProductShow4 = $totalProduct4 > 0 ? $totalProduct4 : 0; $whereMenuCon_type4 = "parent=" . $IdMenuProduct4; $con_type4 = countRecord($tableCategoryNewId, $whereMenuCon_type4); //kiem tra danh muc nay co menu con khong $con_typeShow4 = $con_type4 > 0 ? $con_type4 : 0; //exp parent url=========================================1 $exp_parent4 = '<?php $' . 'url_c = "' . $urlMenuProduct4 . '"; $' . 'name_c = "' . $nameMenuProduct4 . '"; ?>'; $ft_p4 = "../inc/new/" . $IdMenuProduct4 . $ln . ".inc"; $ft_p4 = fopen($ft_p4, "w"); fwrite($ft_p4, $exp_parent4); @chmod($ft_p4, 0777); $urlCodeUpXml4 = trim(str_replace("-", "", $urlMenuProduct4)); $exp_url4 = '<?php $' . 'parent_1_c = "' . $parentMenuProduct4_1 . '"; $' . 'parent_c = "' . $IdMenuProduct4 . '"; $' . 'name_c = "' . $nameMenuProduct4 . '"; $' . 'title_c = "' . $titleMenuProduct4 . '"; $' . 'descriptionMeta_category = "' . $description4 . '"; $' . 'keywordsMeta_category = "' . $keywords4 . '"; ?>';
$whereNewAll = "parent_1=" . $parent_1_c . " and " . $whereLang; } else { if ($parent_1_c == 120) { $whereNewAll = "(parent2=" . $parent_c . " or type_search=" . $parent_c . ")"; } else { $array_search = explode('_', $code_frame); $type_seach = $array_search[1]; if ($type_seach != '') { $typeSearchAll = getRecord($tableCategoryNew, "url='" . $type_seach . "' and " . $whereLang); if ($typeSearchAll['parent'] == 346) { $whereNewAll = " and parent2=" . $typeSearchAll['id_code']; } else { $whereNewAll = " and type_search=" . $typeSearchAll['id_code']; } } $whereNewAll = whereParentLevel($tableCategoryNewId, $parent_c) . $whereNewAll; //"parent=".$parent_c." and ".$whereLang; } //$rowCategoryName = getRecord($tableCategoryNew,"id_code='".$parent_1_c."' and ".$whereLang); ///$showHtmlTitlePage = "<a href=\"".$serverName.$rowCategoryName['url']."/\" title=\"".$rowCategoryName['name']."\">".$rowCategoryName['name']."</a> / "; } $whereOthe = "parent_1=" . $parent_1 . " and id_code<>{$idProduct}"; //DANH MUC TITLE PAGE===========================================================TOP $titlePage = $name_title_c; $keywordsMeta = $keywordsMeta_category != '' ? $keywordsMeta_category : METAKEYWORDSHOME; $descriptionMeta = $descriptionMeta_category != '' ? $descriptionMeta_category : METADESCRIPTIONHOME; include $folderNew . "/home.php"; //DANH MUC TITLE PAGE===========================================================TOP-KET THUC } break; }
<?php $_lang = $_GET['lang']; require "../../qweasd/hoanghung.php"; require "../../qweasd/common_start.php"; include "../../lib/func.lib.php"; include 'table_act.php'; $idCategory = $_GET['idCategory']; $idType = $_GET['idType']; $idproduct = $_GET['idproduct']; ?> <?php $where = whereParentLevel($tableCategoryConfigId, $idCategory); $showCommonAll = ' <div class="div_scroll" style="height:160px; width:95%; float:left"> <table border="0" cellspacing="0" cellpadding="0">'; $sqlCommon1 = "select * from {$tableConfigId} where " . $where; $resultCommon1 = mysql_query($sqlCommon1, $conn); while ($Common = mysql_fetch_array($resultCommon1)) { $id_common_pro_parent = $Common['parent']; $CommonName = getRecord($tableConfig, 'id_code=' . $Common['id'] . " and lang='" . $_lang . "'"); $checkedshow = getRecord($tableConfigCommon_product, 'id_pro_common=' . $Common['id'] . " and id_common=" . $idType . " and parent_categor=" . $id_common_pro_parent . " and id_code=" . $idproduct); $checkedshowCommonAllDefault = $checkedshow['common'] == 1 ? 'checked="checked"' : ''; $showCommonAll .= ' <tr> <td align="left" valign="middle" class="smallfont" style="padding-left:2px; padding-right:4px;"> <input name="common' . $idType . '[]" type="checkbox" value="' . $Common['id'] . '" ' . $checkedshowCommonAllDefault . ' /> </td> <td align="left" valign="middle" class="smallfont" style="padding-left:0px; padding-right:4px;">' . $CommonName['name'] . '</td>
$urlMenuProduct1 = $rowMenuProduct1Nam['url']; $urlHrefMenuProduct1 = $serverName . $moduleProductName . "/" . $urlMenuProduct1 . "/" . $ln; //LAY DANH MUC MENU ref_type=library-booksCon============================ $whereProductLibrarybooks1 = "(" . whereParentLevel($tableCategoryProductId, $IdMenuProduct1) . ") and type_member=0"; $totalProductDanhmucLibrarybooks1 = countRecord($tableProductId, $whereProductLibrarybooks1); $totalProductDanhmucHtmlLibrarybooks1 = $totalProductDanhmucLibrarybooks1 > 0 ? '<span>(' . $totalProductDanhmucLibrarybooks1 . ')</span>' : '<span>(0)</span>'; $showHtmlMenuProductLibrarybooksCon .= '<li><a href=\\"' . $urlHrefMenuProduct1 . '?ref_type=librarybooks\\" title=\\"' . $nameMenuProduct1 . '\\">' . $nameMenuProduct1 . $totalProductDanhmucHtmlLibrarybooks1 . '</a></li>'; //LAY DANH MUC MENU ref_type=library-booksCon============================KET THUC //LAY DANH MUC MENU ref_type=library-sharebooks============================ $whereProductsharebooks1 = "(" . whereParentLevel($tableCategoryProductId, $IdMenuProduct1) . ") and type_member=1"; $totalProductDanhmucsharebooks1 = countRecord($tableProductId, $whereProductsharebooks1); $totalProductDanhmucHtmlsharebooks1 = $totalProductDanhmucsharebooks1 > 0 ? '<span>(' . $totalProductDanhmucsharebooks1 . ')</span>' : '<span>(0)</span>'; $showHtmlMenuProductsharebooksCon .= '<li><a href=\\"' . $urlHrefMenuProduct1 . '?ref_type=sharebooks\\" title=\\"' . $nameMenuProduct1 . '\\">' . $nameMenuProduct1 . $totalProductDanhmucHtmlsharebooks1 . '</a></li>'; //LAY DANH MUC MENU ref_type=library-sharebooks============================KET THUC //LAY DANH MUC MENU ref_type=library-audiobooks============================ $whereProductaudiobooks1 = "(" . whereParentLevel($tableCategoryProductId, $IdMenuProduct1) . ") and type_book=1"; $totalProductDanhmucaudiobooks1 = countRecord($tableProductId, $whereProductaudiobooks1); $totalProductDanhmucHtmlaudiobooks1 = $totalProductDanhmucaudiobooks1 > 0 ? '<span>(' . $totalProductDanhmucaudiobooks1 . ')</span>' : '<span>(0)</span>'; $showHtmlMenuProductaudiobooksCon .= '<li><a href=\\"' . $urlHrefMenuProduct1 . '?ref_type=audiobooks\\" title=\\"' . $nameMenuProduct1 . '\\">' . $nameMenuProduct1 . $totalProductDanhmucHtmlaudiobooks1 . '</a></li>'; //LAY DANH MUC MENU ref_type=library-audiobooks============================KET THUC } $showHtmlMenuProductLibrarybooksConView = '<span class=\\"submenu\\" id=\\"sub' . $IdMenuProduct . '\\"><ul>' . $showHtmlMenuProductLibrarybooksCon . '</ul></span>'; $showHtmlMenuProductLibrarybooksConSub = 'onmouseover=\\"SwitchMenu(' . "'sub" . $IdMenuProduct . "')" . '\\"'; $showHtmlMenuProductsharebooksConView = '<span class=\\"submenu\\" id=\\"sub' . $IdMenuProduct . '\\"><ul>' . $showHtmlMenuProductsharebooksCon . '</ul></span>'; $showHtmlMenuProductsharebooksConSub = 'onmouseover=\\"SwitchMenu(' . "'sub" . $IdMenuProduct . "')" . '\\"'; $showHtmlMenuProductaudiobooksConView = '<span class=\\"submenu\\" id=\\"sub' . $IdMenuProduct . '\\"><ul>' . $showHtmlMenuProductaudiobooksCon . '</ul></span>'; $showHtmlMenuProductaudiobooksConSub = 'onmouseover=\\"SwitchMenu(' . "'sub" . $IdMenuProduct . "')" . '\\"'; } else { $showHtmlMenuProductLibrarybooksConSub = ""; $showHtmlMenuProductLibrarybooksConView = ""; $showHtmlMenuProductLibrarybooksCon = "";
<tr> <td height="25" align="left" valign="middle" class="normalfont" style="border-bottom-color:#CCCCCC; font-weight:500; padding-left:' . $padding . 'px; padding-right:3px; background:#fff"> ' . $linkAllLeft1 . ' </td> </tr> '; ///lay con cua cap 1----------------------------------------------------------------- $sql2 = "select * from {$tableCategoryConfigId} where parent=" . $row1['id'] . " {$whereSachdient} and {$whereStatus} {$sortby} "; $result2 = @mysql_query($sql2, $conn); while ($row2 = @mysql_fetch_array($result2)) { //vong while lay tat cap 2 $defauName2 = getRecord($tableCategoryConfig, " id_code=" . $row2['id'] . " and lang='" . $_lang_A . "'"); $padding2 = 6; $totalProduct = countRecord($tableConfigId, $wherePostNew . "parent=" . $row2['id']); if ($totalProduct == 0) { $where = whereParentLevel($tableCategoryConfigId, $row2['id']); $sqlcount21 = "select count(id) as numrow1 from {$tableConfigId} where {$where}"; $querycount21 = @mysql_query($sqlcount21, $conn); $rowcount21 = @mysql_fetch_assoc($querycount21); $totalProduct = $rowcount21['numrow1']; } $sqlcount2 = "select count(id) as numrow from {$tableCategoryConfigId} where parent=" . $row2['id']; $rowcount2 = mysql_query($sqlcount2, $conn); $rowcount2 = mysql_fetch_assoc($rowcount2); $rowcount2 = $rowcount2['numrow']; if ((countRecord($tableUserLevel, $whereLevelId . " parent_level1=" . $row2['id']) > 0 or $rowcount > 0 or $_SESSION['level'] > 0) and $rowcount2 < 1) { $linkAllLeft2 = '<a href="./?act=' . $row2['code_module'] . '&codeParent=' . $row2['id'] . '&lang=' . $_lang_A . '">' . $defauName2['name'] . '</a>(' . $totalProduct . ')'; $linkAllLeftCate2 = '<b><a href="./?act=module_new_category&codeParent=' . $row2['id'] . '&typec=0&lang=' . $_lang_A . '">' . $defauName2['name'] . '</a></b>'; } else { $linkAllLeftCate2 = '<b><a href="./?act=module_new_category&codeParent=' . $row2['id'] . '&typec=0&lang=' . $_lang_A . '">' . $defauName2['name'] . '</a></b>'; $linkAllLeft2 = "<label style=\"color:#7E0101;font-weight:bold;\">" . $defauName2['name'] . "(" . $totalProduct . ")</label>";