HaaseIT /
HCSF
| @@ 436-456 (lines=21) @@ | ||
| 433 | * @param string $iGID |
|
| 434 | * @return mixed |
|
| 435 | */ |
|
| 436 | private function admin_getItemgroups($iGID = '') // this function should be outsourced, a duplicate is used in admin itemgroups! |
|
| 437 | { |
|
| 438 | $querybuilder = $this->dbal->createQueryBuilder(); |
|
| 439 | $querybuilder |
|
| 440 | ->select('*') |
|
| 441 | ->from('itemgroups_base', 'b') |
|
| 442 | ->leftJoin('b', 'itemgroups_text', 't', 'b.itmg_id = t.itmgt_pid AND t.itmgt_lang = ?') |
|
| 443 | ->setParameter(0, HelperConfig::$lang) |
|
| 444 | ->orderBy('itmg_no') |
|
| 445 | ; |
|
| 446 | ||
| 447 | if ($iGID != '') { |
|
| 448 | $querybuilder |
|
| 449 | ->where('itmg_id = :gid') |
|
| 450 | ->setParameter(1, $iGID) |
|
| 451 | ; |
|
| 452 | } |
|
| 453 | $stmt = $querybuilder->execute(); |
|
| 454 | ||
| 455 | return $stmt->fetchAll(); |
|
| 456 | } |
|
| 457 | } |
|
| 458 | ||
| @@ 266-286 (lines=21) @@ | ||
| 263 | * @param string $iGID |
|
| 264 | * @return mixed |
|
| 265 | */ |
|
| 266 | private function admin_getItemgroups($iGID = '') |
|
| 267 | { |
|
| 268 | $querybuilder = $this->dbal->createQueryBuilder(); |
|
| 269 | $querybuilder |
|
| 270 | ->select('*') |
|
| 271 | ->from('itemgroups_base', 'b') |
|
| 272 | ->leftJoin('b', 'itemgroups_text', 't', 'b.itmg_id = t.itmgt_pid AND t.itmgt_lang = ?') |
|
| 273 | ->setParameter(0, HelperConfig::$lang) |
|
| 274 | ->orderBy('itmg_no') |
|
| 275 | ; |
|
| 276 | ||
| 277 | if ($iGID != '') { |
|
| 278 | $querybuilder |
|
| 279 | ->where('itmg_id = ?') |
|
| 280 | ->setParameter(1, $iGID) |
|
| 281 | ; |
|
| 282 | } |
|
| 283 | $stmt = $querybuilder->execute(); |
|
| 284 | ||
| 285 | return $stmt->fetchAll(); |
|
| 286 | } |
|
| 287 | ||
| 288 | /** |
|
| 289 | * @param $aGroups |
|
