blob: 2a1a95b1631ce39d4ec0ce89488681856644b2e3 [file] [log] [blame]
Derek Allard2067d1a2008-11-13 22:59:24 +00001<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
2/**
3 * CodeIgniter
4 *
Greg Aker741de1c2010-11-10 14:52:57 -06005 * An open source application development framework for PHP 5.1.6 or newer
Derek Allard2067d1a2008-11-13 22:59:24 +00006 *
7 * @package CodeIgniter
8 * @author ExpressionEngine Dev Team
Greg Aker0711dc82011-01-05 10:49:40 -06009 * @copyright Copyright (c) 2008 - 2011, EllisLab, Inc.
Derek Allard2067d1a2008-11-13 22:59:24 +000010 * @license http://codeigniter.com/user_guide/license.html
11 * @link http://codeigniter.com
12 * @since Version 1.3.1
13 * @filesource
14 */
15
16// ------------------------------------------------------------------------
17
18/**
19 * HTML Table Generating Class
20 *
21 * Lets you create tables manually or from database result objects, or arrays.
22 *
23 * @package CodeIgniter
24 * @subpackage Libraries
25 * @category HTML Tables
26 * @author ExpressionEngine Dev Team
27 * @link http://codeigniter.com/user_guide/libraries/uri.html
28 */
29class CI_Table {
30
31 var $rows = array();
32 var $heading = array();
Barry Mienydd671972010-10-04 16:33:58 +020033 var $auto_heading = TRUE;
34 var $caption = NULL;
35 var $template = NULL;
Derek Allard2067d1a2008-11-13 22:59:24 +000036 var $newline = "\n";
37 var $empty_cells = "";
Derek Jones7b5b0e22010-03-02 22:48:53 -060038 var $function = FALSE;
Barry Mienydd671972010-10-04 16:33:58 +020039
Greg Akera9263282010-11-10 15:26:43 -060040 public function __construct()
Derek Allard2067d1a2008-11-13 22:59:24 +000041 {
42 log_message('debug', "Table Class Initialized");
43 }
44
45 // --------------------------------------------------------------------
46
47 /**
48 * Set the template
49 *
50 * @access public
51 * @param array
52 * @return void
53 */
54 function set_template($template)
55 {
56 if ( ! is_array($template))
57 {
58 return FALSE;
59 }
Barry Mienydd671972010-10-04 16:33:58 +020060
Derek Allard2067d1a2008-11-13 22:59:24 +000061 $this->template = $template;
62 }
63
64 // --------------------------------------------------------------------
65
66 /**
67 * Set the table heading
68 *
69 * Can be passed as an array or discreet params
70 *
71 * @access public
72 * @param mixed
73 * @return void
74 */
75 function set_heading()
76 {
77 $args = func_get_args();
Derek Jones7b5b0e22010-03-02 22:48:53 -060078 $this->heading = $this->_prep_args($args);
Derek Allard2067d1a2008-11-13 22:59:24 +000079 }
80
81 // --------------------------------------------------------------------
82
83 /**
84 * Set columns. Takes a one-dimensional array as input and creates
85 * a multi-dimensional array with a depth equal to the number of
86 * columns. This allows a single array with many elements to be
87 * displayed in a table that has a fixed column count.
88 *
89 * @access public
90 * @param array
91 * @param int
92 * @return void
93 */
94 function make_columns($array = array(), $col_limit = 0)
95 {
96 if ( ! is_array($array) OR count($array) == 0)
97 {
98 return FALSE;
99 }
Barry Mienydd671972010-10-04 16:33:58 +0200100
101 // Turn off the auto-heading feature since it's doubtful we
Derek Allard2067d1a2008-11-13 22:59:24 +0000102 // will want headings from a one-dimensional array
103 $this->auto_heading = FALSE;
Barry Mienydd671972010-10-04 16:33:58 +0200104
Derek Allard2067d1a2008-11-13 22:59:24 +0000105 if ($col_limit == 0)
106 {
107 return $array;
108 }
Barry Mienydd671972010-10-04 16:33:58 +0200109
Derek Allard2067d1a2008-11-13 22:59:24 +0000110 $new = array();
Pascal Kriete14287f32011-02-14 13:39:34 -0500111 while (count($array) > 0)
Barry Mienydd671972010-10-04 16:33:58 +0200112 {
113 $temp = array_splice($array, 0, $col_limit);
114
Derek Allard2067d1a2008-11-13 22:59:24 +0000115 if (count($temp) < $col_limit)
116 {
117 for ($i = count($temp); $i < $col_limit; $i++)
118 {
119 $temp[] = '&nbsp;';
120 }
121 }
Barry Mienydd671972010-10-04 16:33:58 +0200122
Derek Allard2067d1a2008-11-13 22:59:24 +0000123 $new[] = $temp;
124 }
Barry Mienydd671972010-10-04 16:33:58 +0200125
Derek Allard2067d1a2008-11-13 22:59:24 +0000126 return $new;
127 }
128
129 // --------------------------------------------------------------------
130
131 /**
132 * Set "empty" cells
133 *
134 * Can be passed as an array or discreet params
135 *
136 * @access public
137 * @param mixed
138 * @return void
139 */
140 function set_empty($value)
141 {
142 $this->empty_cells = $value;
143 }
Barry Mienydd671972010-10-04 16:33:58 +0200144
Derek Allard2067d1a2008-11-13 22:59:24 +0000145 // --------------------------------------------------------------------
146
147 /**
148 * Add a table row
149 *
150 * Can be passed as an array or discreet params
151 *
152 * @access public
153 * @param mixed
154 * @return void
155 */
156 function add_row()
157 {
158 $args = func_get_args();
Derek Jones7b5b0e22010-03-02 22:48:53 -0600159 $this->rows[] = $this->_prep_args($args);
Derek Allard2067d1a2008-11-13 22:59:24 +0000160 }
161
162 // --------------------------------------------------------------------
Barry Mienydd671972010-10-04 16:33:58 +0200163
Derek Jones7b5b0e22010-03-02 22:48:53 -0600164 /**
165 * Prep Args
166 *
167 * Ensures a standard associative array format for all cell data
168 *
169 * @access public
170 * @param type
171 * @return type
172 */
173 function _prep_args($args)
174 {
175 // If there is no $args[0], skip this and treat as an associative array
176 // This can happen if there is only a single key, for example this is passed to table->generate
177 // array(array('foo'=>'bar'))
178 if (isset($args[0]) AND (count($args) == 1 && is_array($args[0])))
179 {
180 // args sent as indexed array
181 if ( ! isset($args[0]['data']))
182 {
183 foreach ($args[0] as $key => $val)
184 {
185 if (is_array($val) && isset($val['data']))
186 {
187 $args[$key] = $val;
188 }
189 else
190 {
Barry Mienydd671972010-10-04 16:33:58 +0200191 $args[$key] = array('data' => $val);
Derek Jones7b5b0e22010-03-02 22:48:53 -0600192 }
Barry Mienydd671972010-10-04 16:33:58 +0200193 }
Derek Jones7b5b0e22010-03-02 22:48:53 -0600194 }
195 }
196 else
197 {
198 foreach ($args as $key => $val)
199 {
200 if ( ! is_array($val))
201 {
202 $args[$key] = array('data' => $val);
203 }
204 }
205 }
Barry Mienydd671972010-10-04 16:33:58 +0200206
Derek Jones7b5b0e22010-03-02 22:48:53 -0600207 return $args;
208 }
Derek Allard2067d1a2008-11-13 22:59:24 +0000209
Derek Jones7b5b0e22010-03-02 22:48:53 -0600210 // --------------------------------------------------------------------
Barry Mienydd671972010-10-04 16:33:58 +0200211
Derek Allard2067d1a2008-11-13 22:59:24 +0000212 /**
213 * Add a table caption
214 *
215 * @access public
216 * @param string
217 * @return void
218 */
219 function set_caption($caption)
220 {
221 $this->caption = $caption;
Barry Mienydd671972010-10-04 16:33:58 +0200222 }
Derek Allard2067d1a2008-11-13 22:59:24 +0000223
224 // --------------------------------------------------------------------
225
226 /**
227 * Generate the table
228 *
229 * @access public
230 * @param mixed
231 * @return string
232 */
233 function generate($table_data = NULL)
234 {
235 // The table data can optionally be passed to this function
236 // either as a database result object or an array
237 if ( ! is_null($table_data))
238 {
239 if (is_object($table_data))
240 {
241 $this->_set_from_object($table_data);
242 }
243 elseif (is_array($table_data))
244 {
245 $set_heading = (count($this->heading) == 0 AND $this->auto_heading == FALSE) ? FALSE : TRUE;
246 $this->_set_from_array($table_data, $set_heading);
247 }
248 }
Barry Mienydd671972010-10-04 16:33:58 +0200249
Derek Allard2067d1a2008-11-13 22:59:24 +0000250 // Is there anything to display? No? Smite them!
251 if (count($this->heading) == 0 AND count($this->rows) == 0)
252 {
253 return 'Undefined table data';
254 }
Barry Mienydd671972010-10-04 16:33:58 +0200255
Derek Allard2067d1a2008-11-13 22:59:24 +0000256 // Compile and validate the template date
257 $this->_compile_template();
Barry Mienydd671972010-10-04 16:33:58 +0200258
Derek Jones7b5b0e22010-03-02 22:48:53 -0600259 // set a custom cell manipulation function to a locally scoped variable so its callable
260 $function = $this->function;
Barry Mienydd671972010-10-04 16:33:58 +0200261
Derek Allard2067d1a2008-11-13 22:59:24 +0000262 // Build the table!
Barry Mienydd671972010-10-04 16:33:58 +0200263
Derek Allard2067d1a2008-11-13 22:59:24 +0000264 $out = $this->template['table_open'];
Barry Mienydd671972010-10-04 16:33:58 +0200265 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000266
267 // Add any caption here
268 if ($this->caption)
269 {
270 $out .= $this->newline;
271 $out .= '<caption>' . $this->caption . '</caption>';
272 $out .= $this->newline;
273 }
274
275 // Is there a table heading to display?
276 if (count($this->heading) > 0)
277 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600278 $out .= $this->template['thead_open'];
279 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000280 $out .= $this->template['heading_row_start'];
Derek Jones7b5b0e22010-03-02 22:48:53 -0600281 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000282
Pascal Kriete14287f32011-02-14 13:39:34 -0500283 foreach ($this->heading as $heading)
Derek Allard2067d1a2008-11-13 22:59:24 +0000284 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600285 $temp = $this->template['heading_cell_start'];
Barry Mienydd671972010-10-04 16:33:58 +0200286
Derek Jones7b5b0e22010-03-02 22:48:53 -0600287 foreach ($heading as $key => $val)
288 {
289 if ($key != 'data')
290 {
291 $temp = str_replace('<th', "<th $key='$val'", $temp);
Barry Mienydd671972010-10-04 16:33:58 +0200292 }
Derek Jones7b5b0e22010-03-02 22:48:53 -0600293 }
294
Barry Mienydd671972010-10-04 16:33:58 +0200295 $out .= $temp;
Derek Jones7b5b0e22010-03-02 22:48:53 -0600296 $out .= isset($heading['data']) ? $heading['data'] : '';
Derek Allard2067d1a2008-11-13 22:59:24 +0000297 $out .= $this->template['heading_cell_end'];
298 }
299
300 $out .= $this->template['heading_row_end'];
Derek Jones7b5b0e22010-03-02 22:48:53 -0600301 $out .= $this->newline;
302 $out .= $this->template['thead_close'];
303 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000304 }
Barry Mienydd671972010-10-04 16:33:58 +0200305
Derek Allard2067d1a2008-11-13 22:59:24 +0000306 // Build the table rows
307 if (count($this->rows) > 0)
308 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600309 $out .= $this->template['tbody_open'];
310 $out .= $this->newline;
Barry Mienydd671972010-10-04 16:33:58 +0200311
Derek Allard2067d1a2008-11-13 22:59:24 +0000312 $i = 1;
Pascal Kriete14287f32011-02-14 13:39:34 -0500313 foreach ($this->rows as $row)
Derek Allard2067d1a2008-11-13 22:59:24 +0000314 {
315 if ( ! is_array($row))
316 {
317 break;
318 }
Barry Mienydd671972010-10-04 16:33:58 +0200319
Derek Allard2067d1a2008-11-13 22:59:24 +0000320 // We use modulus to alternate the row colors
321 $name = (fmod($i++, 2)) ? '' : 'alt_';
Barry Mienydd671972010-10-04 16:33:58 +0200322
Derek Allard2067d1a2008-11-13 22:59:24 +0000323 $out .= $this->template['row_'.$name.'start'];
Barry Mienydd671972010-10-04 16:33:58 +0200324 $out .= $this->newline;
325
Pascal Kriete14287f32011-02-14 13:39:34 -0500326 foreach ($row as $cell)
Derek Allard2067d1a2008-11-13 22:59:24 +0000327 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600328 $temp = $this->template['cell_'.$name.'start'];
Barry Mienydd671972010-10-04 16:33:58 +0200329
Derek Jones7b5b0e22010-03-02 22:48:53 -0600330 foreach ($cell as $key => $val)
331 {
332 if ($key != 'data')
333 {
334 $temp = str_replace('<td', "<td $key='$val'", $temp);
Barry Mienydd671972010-10-04 16:33:58 +0200335 }
Derek Jones7b5b0e22010-03-02 22:48:53 -0600336 }
Barry Mienydd671972010-10-04 16:33:58 +0200337
Derek Jones7b5b0e22010-03-02 22:48:53 -0600338 $cell = isset($cell['data']) ? $cell['data'] : '';
339 $out .= $temp;
340
Derek Allardd8270582010-01-15 17:10:56 +0000341 if ($cell === "" OR $cell === NULL)
Derek Allard2067d1a2008-11-13 22:59:24 +0000342 {
343 $out .= $this->empty_cells;
344 }
345 else
346 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600347 if ($function !== FALSE && is_callable($function))
348 {
Phil Sturgeon6c597f82010-12-27 17:35:35 +0000349 $out .= call_user_func($function, $cell);
Derek Jones7b5b0e22010-03-02 22:48:53 -0600350 }
351 else
352 {
353 $out .= $cell;
354 }
Derek Allard2067d1a2008-11-13 22:59:24 +0000355 }
Barry Mienydd671972010-10-04 16:33:58 +0200356
Derek Allard2067d1a2008-11-13 22:59:24 +0000357 $out .= $this->template['cell_'.$name.'end'];
358 }
Barry Mienydd671972010-10-04 16:33:58 +0200359
Derek Allard2067d1a2008-11-13 22:59:24 +0000360 $out .= $this->template['row_'.$name.'end'];
Barry Mienydd671972010-10-04 16:33:58 +0200361 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000362 }
Barry Mienydd671972010-10-04 16:33:58 +0200363
Derek Jones7b5b0e22010-03-02 22:48:53 -0600364 $out .= $this->template['tbody_close'];
365 $out .= $this->newline;
Derek Allard2067d1a2008-11-13 22:59:24 +0000366 }
367
368 $out .= $this->template['table_close'];
Barry Mienydd671972010-10-04 16:33:58 +0200369
Derek Allard2067d1a2008-11-13 22:59:24 +0000370 return $out;
371 }
Barry Mienydd671972010-10-04 16:33:58 +0200372
Derek Allard2067d1a2008-11-13 22:59:24 +0000373 // --------------------------------------------------------------------
374
375 /**
376 * Clears the table arrays. Useful if multiple tables are being generated
377 *
378 * @access public
379 * @return void
380 */
381 function clear()
382 {
383 $this->rows = array();
384 $this->heading = array();
Barry Mienydd671972010-10-04 16:33:58 +0200385 $this->auto_heading = TRUE;
Derek Allard2067d1a2008-11-13 22:59:24 +0000386 }
Barry Mienydd671972010-10-04 16:33:58 +0200387
Derek Allard2067d1a2008-11-13 22:59:24 +0000388 // --------------------------------------------------------------------
389
390 /**
391 * Set table data from a database result object
392 *
393 * @access public
394 * @param object
395 * @return void
396 */
397 function _set_from_object($query)
398 {
399 if ( ! is_object($query))
400 {
401 return FALSE;
402 }
Barry Mienydd671972010-10-04 16:33:58 +0200403
Derek Allard2067d1a2008-11-13 22:59:24 +0000404 // First generate the headings from the table column names
405 if (count($this->heading) == 0)
406 {
407 if ( ! method_exists($query, 'list_fields'))
408 {
409 return FALSE;
410 }
Barry Mienydd671972010-10-04 16:33:58 +0200411
Derek Jones7b5b0e22010-03-02 22:48:53 -0600412 $this->heading = $this->_prep_args($query->list_fields());
Derek Allard2067d1a2008-11-13 22:59:24 +0000413 }
Barry Mienydd671972010-10-04 16:33:58 +0200414
Derek Allard2067d1a2008-11-13 22:59:24 +0000415 // Next blast through the result array and build out the rows
Barry Mienydd671972010-10-04 16:33:58 +0200416
Derek Allard2067d1a2008-11-13 22:59:24 +0000417 if ($query->num_rows() > 0)
418 {
419 foreach ($query->result_array() as $row)
420 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600421 $this->rows[] = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000422 }
423 }
424 }
425
426 // --------------------------------------------------------------------
427
428 /**
429 * Set table data from an array
430 *
431 * @access public
432 * @param array
433 * @return void
434 */
435 function _set_from_array($data, $set_heading = TRUE)
436 {
437 if ( ! is_array($data) OR count($data) == 0)
438 {
439 return FALSE;
440 }
Barry Mienydd671972010-10-04 16:33:58 +0200441
Derek Allard2067d1a2008-11-13 22:59:24 +0000442 $i = 0;
443 foreach ($data as $row)
Barry Mienydd671972010-10-04 16:33:58 +0200444 {
Derek Allard2067d1a2008-11-13 22:59:24 +0000445 // If a heading hasn't already been set we'll use the first row of the array as the heading
446 if ($i == 0 AND count($data) > 1 AND count($this->heading) == 0 AND $set_heading == TRUE)
447 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600448 $this->heading = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000449 }
450 else
451 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600452 $this->rows[] = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000453 }
Barry Mienydd671972010-10-04 16:33:58 +0200454
Derek Allard2067d1a2008-11-13 22:59:24 +0000455 $i++;
456 }
457 }
458
459 // --------------------------------------------------------------------
460
461 /**
462 * Compile Template
463 *
464 * @access private
465 * @return void
466 */
Barry Mienydd671972010-10-04 16:33:58 +0200467 function _compile_template()
468 {
469 if ($this->template == NULL)
470 {
471 $this->template = $this->_default_template();
472 return;
473 }
474
Derek Allard2067d1a2008-11-13 22:59:24 +0000475 $this->temp = $this->_default_template();
Derek Jones7b5b0e22010-03-02 22:48:53 -0600476 foreach (array('table_open', 'thead_open', 'thead_close', 'heading_row_start', 'heading_row_end', 'heading_cell_start', 'heading_cell_end', 'tbody_open', 'tbody_close', 'row_start', 'row_end', 'cell_start', 'cell_end', 'row_alt_start', 'row_alt_end', 'cell_alt_start', 'cell_alt_end', 'table_close') as $val)
Derek Allard2067d1a2008-11-13 22:59:24 +0000477 {
478 if ( ! isset($this->template[$val]))
479 {
480 $this->template[$val] = $this->temp[$val];
481 }
Barry Mienydd671972010-10-04 16:33:58 +0200482 }
483 }
484
Derek Allard2067d1a2008-11-13 22:59:24 +0000485 // --------------------------------------------------------------------
486
487 /**
488 * Default Template
489 *
490 * @access private
491 * @return void
492 */
493 function _default_template()
494 {
495 return array (
Barry Mienydd671972010-10-04 16:33:58 +0200496 'table_open' => '<table border="0" cellpadding="4" cellspacing="0">',
497
Derek Jones7b5b0e22010-03-02 22:48:53 -0600498 'thead_open' => '<thead>',
499 'thead_close' => '</thead>',
Barry Mienydd671972010-10-04 16:33:58 +0200500
501 'heading_row_start' => '<tr>',
502 'heading_row_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000503 'heading_cell_start' => '<th>',
504 'heading_cell_end' => '</th>',
505
Derek Jones7b5b0e22010-03-02 22:48:53 -0600506 'tbody_open' => '<tbody>',
507 'tbody_close' => '</tbody>',
Barry Mienydd671972010-10-04 16:33:58 +0200508
509 'row_start' => '<tr>',
510 'row_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000511 'cell_start' => '<td>',
512 'cell_end' => '</td>',
513
Barry Mienydd671972010-10-04 16:33:58 +0200514 'row_alt_start' => '<tr>',
515 'row_alt_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000516 'cell_alt_start' => '<td>',
517 'cell_alt_end' => '</td>',
518
Barry Mienydd671972010-10-04 16:33:58 +0200519 'table_close' => '</table>'
520 );
Derek Allard2067d1a2008-11-13 22:59:24 +0000521 }
Barry Mienydd671972010-10-04 16:33:58 +0200522
Derek Allard2067d1a2008-11-13 22:59:24 +0000523
524}
525
526
527/* End of file Table.php */
Derek Jonesa3ffbbb2008-05-11 18:18:29 +0000528/* Location: ./system/libraries/Table.php */