/** * * @param string $queryRaw * @param string $transform html|csv|none * @return array */ public function getListing($queryRaw, $transform = 'html') { $page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1; $rp = isset($_REQUEST['rp']) ? $_REQUEST['rp'] : 10; $sortname = isset($_REQUEST['sortname']) ? $_REQUEST['sortname'] : $this->handledObejct->getmyKeyColumn(); $sortorder = isset($_REQUEST['sortorder']) ? $_REQUEST['sortorder'] : 'desc'; $where = $this->getWhere(); $sort = " ORDER BY {$sortname} {$sortorder}"; $start = ($page - 1) * $rp; $limit = " LIMIT {$start}, {$rp}"; $query = "{$queryRaw} {$where} {$sort} {$limit}"; switch ($transform) { case 'csv': $resultRaw = $this->handledObejct->csvizeData($this->handledObejct->myDbLink->queryToArray($query)); break; case 'html': $resultRaw = $this->handledObejct->htmlizeData($this->handledObejct->myDbLink->queryToArray($query)); break; default: $resultRaw = $this->handledObejct->myDbLink->queryToArray($query); break; } if (!count($this->columns)) { return $resultRaw; } $result = array(); foreach ($resultRaw as $rrid => $resultRow) { foreach ($this->columns as $colKey => $colValue) { $result[$rrid][$colKey] = $resultRow[$colKey]; } } return $result; }
/** * Přěvede data do HTML. * * @covers IECfg::htmlizeData */ public function testHtmlizeData() { $htmlized = $this->object->htmlizeData([$this->testRowA, $this->testRowB]); $this->assertArrayHasKey('0', $htmlized); $this->assertArrayHasKey('1', $htmlized); }