/** * Returns all objects of this repository. * * @param \Woehrl\WoehrlMarkenverwaltung\Domain\Model\Category $category * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array * @api */ public function findByCategory(\Woehrl\WoehrlMarkenverwaltung\Domain\Model\Category $category) { $sql = " SELECT\n tx_woehrlmarkenverwaltung_domain_model_marke.marke as marke,\n tx_woehrlmarkenverwaltung_domain_model_marke.markelink as link,\n UPPER(SUBSTRING(marke,1,1)) as anfangsbuchstabe\n FROM tx_woehrlmarkenverwaltung_domain_model_marke\n WHERE tx_woehrlmarkenverwaltung_domain_model_marke.hidden = 0 AND tx_woehrlmarkenverwaltung_domain_model_marke.deleted = 0 AND tx_woehrlmarkenverwaltung_domain_model_marke.categorys = " . $category->getUid() . "\n GROUP BY marke\n ORDER BY marke"; $query = $this->createQuery(); $query->getQuerySettings()->setReturnRawQueryResult(TRUE); $query->statement($sql); return $query->execute(); }
/** * action list * @param \Woehrl\WoehrlMarkenverwaltung\Domain\Model\Category $category * @return void */ public function listAction(\Woehrl\WoehrlMarkenverwaltung\Domain\Model\Category $category = NULL) { switch ($this->settings['markenverwaltung']) { case 1: if ($this->settings['markenverwaltung']) { $modehaus = $this->settings['modehaus']; $categories = $this->categoryRepository->findAll(); //$this->contentObj = $this->configurationManager->getContentObject(); foreach ($categories as $category) { $categoryId = $category->getUid(); $categoryName = strtolower($category->getKategoriename()) . 'marken'; $marken = $this->markeRepository->getMarkenFromMMTabeles($modehaus, $categoryName, $categoryId); if ($marken) { $sort = array(); foreach ($marken as $marke) { $sort[$marke['anfangsbuchstabe']][] = $marke; } $markes[$categoryName] = $sort; } } } //$this->view->assign('markes', $markes); break; case 0: if ($this->settings['category']) { $category = $this->categoryRepository->findByUid($this->settings['category']); $marken = $this->markeRepository->findByCategory($category); $sort = array(); foreach ($marken as $marke) { $sort[$marke['anfangsbuchstabe']][] = $marke; } $markes = $sort; } else { $categories = $this->categoryRepository->findAll(); foreach ($categories as $category) { $categoryId = $category->getUid(); $categoryName = strtolower($category->getKategoriename()) . 'marken'; $marken = $this->markeRepository->getMarkenFromMMTabeles($modehaus = NULL, $categoryName, $categoryId); $sort = array(); foreach ($marken as $marke) { $sort[$marke['anfangsbuchstabe']][] = $marke; } $markes[$categoryName] = $sort; } $categories = $this->categoryRepository->findAll(); //\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($markes, 'markes'); //\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($this->settings, 'markes'); } //$this->view->assign('requestCategory', $category->getUid()); //\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($marken, 'markes'); break; } //\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($markes, 'markes'); //$markes = $this->markeRepository->findAll(); $this->view->assign('markes', $markes); }
/** * @test */ public function setKategorienameForStringSetsKategoriename() { $this->subject->setKategoriename('Conceived at T3CON10'); $this->assertAttributeEquals('Conceived at T3CON10', 'kategoriename', $this->subject); }