blob: def6967766e2d18e6145370a4cc0c1b0ff084d1a [file] [log] [blame]
Derek Jones4b9c6292011-07-01 17:40:48 -05001<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
Derek Allard2067d1a2008-11-13 22:59:24 +00002/**
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 /**
Derek Jones4b9c6292011-07-01 17:40:48 -050084 * Set columns. Takes a one-dimensional array as input and creates
Derek Allard2067d1a2008-11-13 22:59:24 +000085 * a multi-dimensional array with a depth equal to the number of
Derek Jones4b9c6292011-07-01 17:40:48 -050086 * columns. This allows a single array with many elements to be
Derek Allard2067d1a2008-11-13 22:59:24 +000087 * 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 Jones4b9c6292011-07-01 17:40:48 -0500250 // Is there anything to display? No? Smite them!
Derek Allard2067d1a2008-11-13 22:59:24 +0000251 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
Greg Aker02b3a5b2011-02-01 01:29:21 -0600370 // Clear table class properties before generating the table
371 $this->clear();
372
Derek Allard2067d1a2008-11-13 22:59:24 +0000373 return $out;
374 }
Barry Mienydd671972010-10-04 16:33:58 +0200375
Derek Allard2067d1a2008-11-13 22:59:24 +0000376 // --------------------------------------------------------------------
377
378 /**
Derek Jones4b9c6292011-07-01 17:40:48 -0500379 * Clears the table arrays. Useful if multiple tables are being generated
Derek Allard2067d1a2008-11-13 22:59:24 +0000380 *
381 * @access public
382 * @return void
383 */
384 function clear()
385 {
386 $this->rows = array();
387 $this->heading = array();
Barry Mienydd671972010-10-04 16:33:58 +0200388 $this->auto_heading = TRUE;
Derek Allard2067d1a2008-11-13 22:59:24 +0000389 }
Barry Mienydd671972010-10-04 16:33:58 +0200390
Derek Allard2067d1a2008-11-13 22:59:24 +0000391 // --------------------------------------------------------------------
392
393 /**
394 * Set table data from a database result object
395 *
396 * @access public
397 * @param object
398 * @return void
399 */
400 function _set_from_object($query)
401 {
402 if ( ! is_object($query))
403 {
404 return FALSE;
405 }
Barry Mienydd671972010-10-04 16:33:58 +0200406
Derek Allard2067d1a2008-11-13 22:59:24 +0000407 // First generate the headings from the table column names
408 if (count($this->heading) == 0)
409 {
410 if ( ! method_exists($query, 'list_fields'))
411 {
412 return FALSE;
413 }
Barry Mienydd671972010-10-04 16:33:58 +0200414
Derek Jones7b5b0e22010-03-02 22:48:53 -0600415 $this->heading = $this->_prep_args($query->list_fields());
Derek Allard2067d1a2008-11-13 22:59:24 +0000416 }
Barry Mienydd671972010-10-04 16:33:58 +0200417
Derek Allard2067d1a2008-11-13 22:59:24 +0000418 // Next blast through the result array and build out the rows
Barry Mienydd671972010-10-04 16:33:58 +0200419
Derek Allard2067d1a2008-11-13 22:59:24 +0000420 if ($query->num_rows() > 0)
421 {
422 foreach ($query->result_array() as $row)
423 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600424 $this->rows[] = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000425 }
426 }
427 }
428
429 // --------------------------------------------------------------------
430
431 /**
432 * Set table data from an array
433 *
434 * @access public
435 * @param array
436 * @return void
437 */
438 function _set_from_array($data, $set_heading = TRUE)
439 {
440 if ( ! is_array($data) OR count($data) == 0)
441 {
442 return FALSE;
443 }
Barry Mienydd671972010-10-04 16:33:58 +0200444
Derek Allard2067d1a2008-11-13 22:59:24 +0000445 $i = 0;
446 foreach ($data as $row)
Barry Mienydd671972010-10-04 16:33:58 +0200447 {
Derek Allard2067d1a2008-11-13 22:59:24 +0000448 // If a heading hasn't already been set we'll use the first row of the array as the heading
449 if ($i == 0 AND count($data) > 1 AND count($this->heading) == 0 AND $set_heading == TRUE)
450 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600451 $this->heading = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000452 }
453 else
454 {
Derek Jones7b5b0e22010-03-02 22:48:53 -0600455 $this->rows[] = $this->_prep_args($row);
Derek Allard2067d1a2008-11-13 22:59:24 +0000456 }
Barry Mienydd671972010-10-04 16:33:58 +0200457
Derek Allard2067d1a2008-11-13 22:59:24 +0000458 $i++;
459 }
460 }
461
462 // --------------------------------------------------------------------
463
464 /**
465 * Compile Template
466 *
467 * @access private
468 * @return void
469 */
Barry Mienydd671972010-10-04 16:33:58 +0200470 function _compile_template()
471 {
472 if ($this->template == NULL)
473 {
474 $this->template = $this->_default_template();
475 return;
476 }
477
Derek Allard2067d1a2008-11-13 22:59:24 +0000478 $this->temp = $this->_default_template();
Derek Jones7b5b0e22010-03-02 22:48:53 -0600479 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 +0000480 {
481 if ( ! isset($this->template[$val]))
482 {
483 $this->template[$val] = $this->temp[$val];
484 }
Barry Mienydd671972010-10-04 16:33:58 +0200485 }
486 }
487
Derek Allard2067d1a2008-11-13 22:59:24 +0000488 // --------------------------------------------------------------------
489
490 /**
491 * Default Template
492 *
493 * @access private
494 * @return void
495 */
496 function _default_template()
497 {
Derek Jones4b9c6292011-07-01 17:40:48 -0500498 return array (
Barry Mienydd671972010-10-04 16:33:58 +0200499 'table_open' => '<table border="0" cellpadding="4" cellspacing="0">',
500
Derek Jones7b5b0e22010-03-02 22:48:53 -0600501 'thead_open' => '<thead>',
502 'thead_close' => '</thead>',
Barry Mienydd671972010-10-04 16:33:58 +0200503
504 'heading_row_start' => '<tr>',
505 'heading_row_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000506 'heading_cell_start' => '<th>',
507 'heading_cell_end' => '</th>',
508
Derek Jones7b5b0e22010-03-02 22:48:53 -0600509 'tbody_open' => '<tbody>',
510 'tbody_close' => '</tbody>',
Barry Mienydd671972010-10-04 16:33:58 +0200511
512 'row_start' => '<tr>',
513 'row_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000514 'cell_start' => '<td>',
515 'cell_end' => '</td>',
516
Barry Mienydd671972010-10-04 16:33:58 +0200517 'row_alt_start' => '<tr>',
518 'row_alt_end' => '</tr>',
Derek Allard2067d1a2008-11-13 22:59:24 +0000519 'cell_alt_start' => '<td>',
520 'cell_alt_end' => '</td>',
521
Barry Mienydd671972010-10-04 16:33:58 +0200522 'table_close' => '</table>'
523 );
Derek Allard2067d1a2008-11-13 22:59:24 +0000524 }
Barry Mienydd671972010-10-04 16:33:58 +0200525
Derek Allard2067d1a2008-11-13 22:59:24 +0000526
527}
528
529
530/* End of file Table.php */
Derek Jonesa3ffbbb2008-05-11 18:18:29 +0000531/* Location: ./system/libraries/Table.php */