Blame | Last modification | View Log | RSS feed
<?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) 2008, 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;}}/* End of file Scaffolding.php *//* Location: ./system/scaffolding/Scaffolding.php */