/**
*
* @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);
}
