67 		$data = array('classes' => $class,
93 						$data['cols'][$column['key']] = $column;
97 					$data['title'] = $line[1];
105 						$data['headers'][] = $col;
109 					$data['min']   = abs((int) $line[1]);
113 					$data['limit'] = abs((int) $line[1]);
120 						$data['sort'] = array(substr($sort,1),'DESC');
122 						$data['sort'] = array($sort,'ASC');
136 						$data['filter'][] = $flt;
141 					$data['page'] = cleanID($line[1]);
149 		if(!is_array($data['cols']) || !count($data['cols'])){
155 		$data['headers'] = (array) $data['headers'];
156 		$cnth = count($data['headers']);
157 		$cntf = count($data['cols']);
159 			$item = array_pop(array_slice($data['cols'],$i,1));
160 			$data['headers'][] = $item['title'];
163 		$data['sql'] = $this->_buildSQL($data);
164 		return $data;
175 	function render($format, &$R, $data) {  argument
177 		if(is_null($data)) return false;
186 		$this->updateSQLwithQuery($data); // handles request params
189 		$clist = array_keys($data['cols']);
191 		$res = $store->query($data['sql'],$resultFormat, $lang, $infer);
196 			$R->doc .= $this->preList($clist, $data);
206 					$data['cols'][$clist[$num]],implode(",",$values),$R);
211 			$R->doc .= $this->postList($data, $cnt);
214 			$this->nullList($data, $clist, $R);
219 		if ($data['limit'] && $cnt > $data['limit']) {
220 			$rows = array_slice($rows, 0, $data['limit']);
227 	function preList($clist, $data) {  argument
231 		. '<table class="inline dataplugin_table '.$data['classes'].'">';
234 		foreach($data['headers'] as $num => $head){
240 			if(isset($data['sort']) && $ckey == $data['sort'][0]){
241 				if($data['sort'][1] == 'ASC'){
264 	function nullList($data, $clist, &$R) {  argument
265 		$R->doc .= $this->preList($clist, $data);
274 	function postList($data, $rowcnt) {  argument
278 		if($data['limit']){
279 			$text .= '<tr><th colspan="'.count($data['cols']).'">';
282 				$prev = $offset - $data['limit'];
297 			if($rowcnt > $data['limit']){
298 				$next = $offset + $data['limit'];
319 	function _buildSQL(&$data){  argument
329 		foreach ($data['cols'] as &$col){
363 		if(isset($data['sort'])){
364 			$col = $data['sort'][0];
367 				$order = 'ORDER BY '.$data['sort'][1].'(?page)';
369 				$order = 'ORDER BY '.$data['sort'][1].'(?class)';
371 				$order = 'ORDER BY '.$data['sort'][1].'(?title)';
380 				$order = sprintf('ORDER BY %s(?%ss)',$data['sort'][1],$tables[$col]);
388 		if (!isset($data['filter'])) $data['filter'] = array();
389 		$data['filter'] = array_merge($data['filter'], $this->dthlp->_get_filters());
392 		if(is_array($data['filter']) && count($data['filter'])){
394 			foreach($data['filter'] as $filter){
448 		if($data['limit']){
449 			$sql .= ' LIMIT '.($data['limit'] + 1);
455 	function updateSQLwithQuery(&$data) {  argument
459 				$data['sort'] = array(substr($_REQUEST['datasrt'],1),'DESC');
461 				$data['sort'] = array($_REQUEST['datasrt'],'ASC');
464 			$data['sql'] = $this->_buildSQL($data);
467 		if($data['limit'] && (int) $_REQUEST['dataofs']){
468 			$data['sql'] .= ' OFFSET '.((int) $_REQUEST['dataofs']);