<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); /** * CodeIgniter * * An open source application development framework for PHP 4.3.2 or newer * * @package CodeIgniter * @author ExpressionEngine Dev Team * @copyright Copyright (c) 2006, EllisLab, Inc. * @license http://codeigniter.com/user_guide/license.html * @link http://codeigniter.com * @since Version 1.0 * @filesource */ // ------------------------------------------------------------------------ /** * Scaffolding Class * * Provides the Scaffolding framework * * @package CodeIgniter * @subpackage Scaffolding * @author ExpressionEngine Dev Team * @link http://codeigniter.com/user_guide/general/scaffolding.html */ class Scaffolding { var $CI; var $current_table; var $base_url = ''; var $lang = array(); function Scaffolding($db_table) { $this->CI =& get_instance(); $this->CI->load->database("", FALSE, TRUE); $this->CI->load->library('pagination'); // Turn off caching $this->CI->db->cache_off(); /** * Set the current table name * This is done when initializing scaffolding: * $this->load->scaffolding('table_name') * */ $this->current_table = $db_table; /** * Set the path to the "view" files * We'll manually override the "view" path so that * the load->view function knows where to look. */ $this->CI->load->_ci_view_path = BASEPATH.'scaffolding/views/'; // Set the base URL $this->base_url = $this->CI->config->site_url().'/'.$this->CI->uri->segment(1).$this->CI->uri->slash_segment(2, 'both'); $this->base_uri = $this->CI->uri->segment(1).$this->CI->uri->slash_segment(2, 'leading'); // Set a few globals $data = array( 'image_url' => $this->CI->config->system_url().'scaffolding/images/', 'base_uri' => $this->base_uri, 'base_url' => $this->base_url, 'title' => $this->current_table ); $this->CI->load->vars($data); // Load the language file and create variables $this->lang = $this->CI->load->scaffold_language('scaffolding', '', TRUE); $this->CI->load->vars($this->lang); // Load the helper files we plan to use $this->CI->load->helper(array('url', 'form')); log_message('debug', 'Scaffolding Class Initialized'); } // -------------------------------------------------------------------- /** * "Add" Page * * Shows a form representing the currently selected DB * so that data can be inserted * * @access public * @return string the HTML "add" page */ function add() { $data = array( 'title' => ( ! isset($this->lang['scaff_add'])) ? 'Add Data' : $this->lang['scaff_add'], 'fields' => $this->CI->db->field_data($this->current_table), 'action' => $this->base_uri.'/insert' ); $this->CI->load->view('add', $data); } // -------------------------------------------------------------------- /** * Insert the data * * @access public * @return void redirects to the view page */ function insert() { if ($this->CI->db->insert($this->current_table, $_POST) === FALSE) { $this->add(); } else { redirect($this->base_uri.'/view/'); } } // -------------------------------------------------------------------- /** * "View" Page * * Shows a table containing the data in the currently * selected DB * * @access public * @return string the HTML "view" page */ function view() { // Fetch the total number of DB rows $total_rows = $this->CI->db->count_all($this->current_table); if ($total_rows < 1) { return $this->CI->load->view('no_data'); } // Set the query limit/offset $per_page = 20; $offset = $this->CI->uri->segment(4, 0); // Run the query $query = $this->CI->db->get($this->current_table, $per_page, $offset); // Now let's get the field names $fields = $this->CI->db->list_fields($this->current_table); // We assume that the column in the first position is the primary field. $primary = current($fields); // Pagination! $this->CI->pagination->initialize( array( 'base_url' => $this->base_url.'/view', 'total_rows' => $total_rows, 'per_page' => $per_page, 'uri_segment' => 4, 'full_tag_open' => '<p>', 'full_tag_close' => '</p>' ) ); $data = array( 'title' => ( ! isset($this->lang['scaff_view'])) ? 'View Data' : $this->lang['scaff_view'], 'query' => $query, 'fields' => $fields, 'primary' => $primary, 'paginate' => $this->CI->pagination->create_links() ); $this->CI->load->view('view', $data); } // -------------------------------------------------------------------- /** * "Edit" Page * * Shows a form representing the currently selected DB * so that data can be edited * * @access public * @return string the HTML "edit" page */ function edit() { if (FALSE === ($id = $this->CI->uri->segment(4))) { return $this->view(); } // Fetch the primary field name $primary = $this->CI->db->primary($this->current_table); // Run the query $query = $this->CI->db->get_where($this->current_table, array($primary => $id)); $data = array( 'title' => ( ! isset($this->lang['scaff_edit'])) ? 'Edit Data' : $this->lang['scaff_edit'], 'fields' => $query->field_data(), 'query' => $query->row(), 'action' => $this->base_uri.'/update/'.$this->CI->uri->segment(4) ); $this->CI->load->view('edit', $data); } // -------------------------------------------------------------------- /** * Update * * @access public * @return void redirects to the view page */ function update() { // Fetch the primary key $primary = $this->CI->db->primary($this->current_table); // Now do the query $this->CI->db->update($this->current_table, $_POST, array($primary => $this->CI->uri->segment(4))); redirect($this->base_uri.'/view/'); } // -------------------------------------------------------------------- /** * Delete Confirmation * * @access public * @return string the HTML "delete confirm" page */ function delete() { if ( ! isset($this->lang['scaff_del_confirm'])) { $message = 'Are you sure you want to delete the following row: '.$this->CI->uri->segment(4); } else { $message = $this->lang['scaff_del_confirm'].' '.$this->CI->uri->segment(4); } $data = array( 'title' => ( ! isset($this->lang['scaff_delete'])) ? 'Delete Data' : $this->lang['scaff_delete'], 'message' => $message, 'no' => anchor(array($this->base_uri, 'view'), ( ! isset($this->lang['scaff_no'])) ? 'No' : $this->lang['scaff_no']), 'yes' => anchor(array($this->base_uri, 'do_delete', $this->CI->uri->segment(4)), ( ! isset($this->lang['scaff_yes'])) ? 'Yes' : $this->lang['scaff_yes']) ); $this->CI->load->view('delete', $data); } // -------------------------------------------------------------------- /** * Delete * * @access public * @return void redirects to the view page */ function do_delete() { // Fetch the primary key $primary = $this->CI->db->primary($this->current_table); // Now do the query $this->CI->db->where($primary, $this->CI->uri->segment(4)); $this->CI->db->delete($this->current_table); header("Refresh:0;url=".site_url(array($this->base_uri, 'view'))); exit; } } ?>