Scaffolding.php

Go to the documentation of this file.

<?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 */