Lines Matching refs:col

97                         foreach($cols as $col){
98 $col = trim($col);
99 if(!$col) continue;
100 list($key,$type) = $this->dthlp->_column($col);
118 foreach($cols as $col){
119 $col = trim($col);
120 $col = trim($col);
121 if(!$col) continue;
122 list($key,$type) = $this->dthlp->_column($col);
174 foreach(array_keys($data['cols']) as $col){
175 if($col == '%pageid%'){
177 }elseif($col == '%title%'){
180 $data['headers'][] = $col;
221 foreach($row as $num => $col){
227 … dataplugin_roll '.$cols[$num].'">'.$this->dthlp->_formatData($cols[$num],$col,$types[$num],$rende…
231 … dataplugin_roll '.$cols[$num].'">'.$this->dthlp->_formatData($cols[$num],$col,$types[$num],$rende…
288 foreach (array_keys($data['cols']) as $col){
289 if($col == '%pageid%'){
291 }elseif($col == '%title%'){
294 if(!$tables[$col]){
295 $tables[$col] = 'T'.(++$cnt);
296 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
297 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
299 $select[] = 'group_concat('.$tables[$col].".value,'\n')";
305 $col = $data['sort'][0];
307 if($col == '%pageid%'){
309 }elseif($col == '%title%'){
313 if(!$tables[$col]){
314 $tables[$col] = 'T'.(++$cnt);
315 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
316 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
319 $order = 'ORDER BY '.$tables[$col].'.value '.$data['sort'][1];
330 $col = $filter['key'];
332 if($col == '%pageid%'){
334 }elseif($col == '%title%'){
338 if(!$tables[$col]){
339 $tables[$col] = 'T'.(++$cnt);
340 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
341 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
344 $where .= ' '.$filter['logic'].' '.$tables[$col].'.value '.$filter['compare'].
354 list($col,$val) = split(':',$_GET['dataflt'],2);
355 if(!$tables[$col]){
356 $tables[$col] = 'T'.(++$cnt);
357 … $from .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
358 $from .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
361 $where .= ' AND '.$tables[$col].".value = '".sqlite_escape_string($val)."'";