GX-Bug #48826 » CategoriesDropDownCustomersStatusGroupCheckFix.patch
| src/templates/Honeygrid/smarty/function.categories.php (revision ) | ||
|---|---|---|
| 18 | 18 |
function getCategories() |
| 19 | 19 |
{
|
| 20 | 20 |
$arrTemp = array(); |
| 21 |
|
|
| 22 |
if(GROUP_CHECK == 'true') |
|
| 23 |
{
|
|
| 24 |
$groupCheck = " AND c.group_permission_" . (int)$_SESSION['customers_status']['customers_status_id'] . " = 1 "; |
|
| 25 |
} |
|
| 26 |
|
|
| 21 | 27 |
$strSql = "select * from categories c, categories_description cd |
| 22 | 28 |
where c.categories_id = cd.categories_id |
| 23 | 29 |
and c.parent_id = 0 |
| 24 | 30 |
and c.categories_status = 1 |
| 25 |
and cd.language_id = " . $_SESSION['languages_id'] . " |
|
| 31 |
" . $groupCheck . " AND |
|
| 32 |
cd.language_id = " . $_SESSION['languages_id'] . " |
|
| 26 | 33 |
order by c.sort_order"; |
| 27 | 34 |
$result = xtc_db_query($strSql); |
| 28 | 35 |
while ($item = xtc_db_fetch_array($result)) |