Lines Matching refs:col

106 													foreach($cols as $col){
107 															$col = trim($col);
108 															if(!$col) continue;
109 															list($key,$type) = $this->dthlp->_column($col);
127 														foreach($cols as $col){
128 																$col = trim($col);
129 																$col = trim($col);
130 																if(!$col) continue;
131 																list($key,$type) = $this->dthlp->_column($col);
183 							foreach(array_keys($data['cols']) as $col){
184 									if($col == '%pageid%'){
186 									}elseif($col == '%title%'){
189 											$data['headers'][] = $col;
305 										foreach($row as $num => $col){
308 											$xValue =  $this->dthlp->_formatData($cols[$num],$col,$types[$num],$renderer);
404         foreach (array_keys($data['cols']) as $col){
405             if($col == '%pageid%'){
407             }elseif($col == '%title%'){
410                 if(!$tables[$col]){
411                     $tables[$col] = 'T'.(++$cnt);
412 …             $from  .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
413                     $from  .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
415                 $select[] = 'group_concat('.$tables[$col].".value,'\n')";
421             $col = $data['sort'][0];
423             if($col == '%pageid%'){
425             }elseif($col == '%title%'){
429                 if(!$tables[$col]){
430                     $tables[$col] = 'T'.(++$cnt);
431 …             $from  .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
432                     $from  .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
435                 $order = 'ORDER BY '.$tables[$col].'.value '.$data['sort'][1];
446                 $col = $filter['key'];
448                 if($col == '%pageid%'){
450                 }elseif($col == '%title%'){
454                     if(!$tables[$col]){
455                         $tables[$col] = 'T'.(++$cnt);
456 …             $from  .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
457                         $from  .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
460                     $where .= ' '.$filter['logic'].' '.$tables[$col].'.value '.$filter['compare'].
470             list($col,$val) = split(':',$_GET['dataflt'],2);
471             if(!$tables[$col]){
472                 $tables[$col] = 'T'.(++$cnt);
473 …             $from  .= ' LEFT JOIN data AS '.$tables[$col].' ON '.$tables[$col].'.pid = pages.pid';
474                 $from  .= ' AND '.$tables[$col].".key = '".sqlite_escape_string($col)."'";
477             $where .= ' AND '.$tables[$col].".value = '".sqlite_escape_string($val)."'";