HaaseIT /
HCSF
| @@ 436-456 (lines=21) @@ | ||
| 433 | * @param string $iGID |
|
| 434 | * @return mixed |
|
| 435 | */ |
|
| 436 | private function 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 | ||
| @@ 284-304 (lines=21) @@ | ||
| 281 | * @param string $iGID |
|
| 282 | * @return mixed |
|
| 283 | */ |
|
| 284 | private function getItemgroups($iGID = '') |
|
| 285 | { |
|
| 286 | $querybuilder = $this->dbal->createQueryBuilder(); |
|
| 287 | $querybuilder |
|
| 288 | ->select('*') |
|
| 289 | ->from('itemgroups_base', 'b') |
|
| 290 | ->leftJoin('b', 'itemgroups_text', 't', 'b.itmg_id = t.itmgt_pid AND t.itmgt_lang = ?') |
|
| 291 | ->setParameter(0, HelperConfig::$lang) |
|
| 292 | ->orderBy('itmg_no') |
|
| 293 | ; |
|
| 294 | ||
| 295 | if ($iGID != '') { |
|
| 296 | $querybuilder |
|
| 297 | ->where('itmg_id = ?') |
|
| 298 | ->setParameter(1, $iGID) |
|
| 299 | ; |
|
| 300 | } |
|
| 301 | $stmt = $querybuilder->execute(); |
|
| 302 | ||
| 303 | return $stmt->fetchAll(); |
|
| 304 | } |
|
| 305 | ||
| 306 | /** |
|
| 307 | * @param $aGroups |
|
