<?

class Console extends Controller {

    function Console() {
        parent::Controller();
        $this->load->helper(array('form', 'url', 'html'));
        $this->load->library('Creater');
    }

    function index() {
        $action = $this->input->post('action');
        echo form_open('console');
        echo form_input('action', '', 'style="font-size:22px; width:85%;"');
        echo form_submit('submit', 'ok', 'style="font-size:22px;width:15%;"');
        echo 'Ex.: create mvc post title:string content:text';
        echo '<br/>';
        echo 'Ex.: create mvc post';
        echo '<br/>';
        echo 'Ex.: create all';
        echo form_close();
        echo '<br/><br/>';
        echo $this->creater->mvc($action);


    }

}

<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

/*
 * Davi Macêdo Tapajós
 * davitapajos@gmail.com
 * @davitapajos
 */

class Creater {

    var $ci;
    var $table = '';
    var $fields = array();
    var $fields_types = array();
    var $stop = false;
    var $result_message = '';
    var $primary_key = 'id';
    var $create_date_fields = false;
    var $lang = array();
    var $create_date = '';
    var $update_date = '';
    var $file_content = '';
    var $permission = 0;
    var $main_view = '';
    var $has_date_field = false;

    function Creater() {
        $this->ci =& get_instance();
        $this->ci->load->dbforge();
        $this->ci->load->database();
        $this->ci->load->helper('file');
        $this->ci->load->helper(array('url', 'html'));

        // Config vars --------------------

        $this->file_permission = 0777;
        $this->main_view = 'main_view';
        $this->create_date = 'created_at';
        $this->update_date = 'updated_at';
        $this->lang['back'] = 'voltar';
        $this->lang['save'] = 'salvar';
        $this->lang['show'] = 'detalhes';
        $this->lang['destroy'] = 'excluir';
        $this->lang['new'] = 'novo';
        $this->lang['create'] = 'novo';
        $this->lang['edit'] = 'editar';
        $this->lang['listing'] = 'listando';
    }

    function _reset(){
        $this->table = '';
        $this->fields = array();
        $this->fields_types = array();
        $this->stop = false;
        $this->create_date_fields = false;
        $this->has_date_field = false;
        $this->_clean_file_content();
    }

    function _result_message($tab = 0, $message = ''){
        $this->result_message .= $message."<br/>";
    }

    function _add_line($tab = 0, $string = '') {
        for ($i=0;$i<$tab;$i++){
            $this->file_content .= "\t";
        }
        $this->file_content .= $string."\n";
    }

    function _clean_file_content(){
        $this->file_content = '';
    }

    function _has_date_field($field_type){
        if ($field_type == 'date') {
            $this->has_date_field = true;
        }
    }

    function _write_content_in_file($file, $stuff) {
        if (write_file($file, $this->file_content, 'x+')) {
            chmod($file, $this->file_permission);
            $this->_result_message(1, $this->table.' '.$stuff.' created');
        } else {
            $this->_result_message(1, 'Unable to write the '.$this->table.' '.$stuff);
        }
    }

    function mvc($string) {
        $this->ci->benchmark->mark('code_start');

        $this->_reset();

        if($string != '') {
            $action = explode(' ', trim($string));
            $length = count($action);

            if ($action[0] == 'create') {
                if ($action[1] == 'mvc') {
                    if (isset($action[2])) {
                        // se for passado algum campo da tabela na string, então é subentendido que a tabela não existe e ela deve ser criada
                        // caso contrário a tabela será lida e os campos serão obtidos
                        $have_fields = isset($action[3]);
                        $this->_build_mvc($action, $have_fields);
                    } else {
                        $this->_result_message(0, 'Impossible to execute the action');
                    }
                } elseif ($action[1] == 'all') {
                    $this->_build_all_from_db();
                } else {
                    $this->_result_message(0, 'Impossible to execute the action');
                }
            } else {
                $this->_result_message(0, 'Impossible to execute the action');
            }
        } else {
            $this->_result_message(0, 'Parameter undefined');
        }
        $this->ci->benchmark->mark('code_end');
        $this->_result_message(0, '<strong>Process time: '.$this->ci->benchmark->elapsed_time('code_start', 'code_end').'</strong>');
        return $this->result_message;
    }



    function _build_all_from_db() {
        $tables = $this->ci->db->list_tables();

        foreach ($tables as $table) {
           $this->mvc('create mvc '.$table);
        }

    }

    function _build_mvc($action, $have_fields) {
        $this->table = $action[2];

        if ($have_fields) {
            $fields = array_splice($action, 3);
            foreach ($fields as $field){
                $field = explode(':', $field);
                $this->_has_date_field($field[1]);
                array_push($this->fields_types, $field[1]);
                array_push($this->fields, $field[0]);
            }

            $this->_build_table();
        } else {
            $this->_read_table();
        }

        if ( ! $this->stop) {
            $this->_build_controller();
            $this->_build_views();
            $this->_build_model();
        }
    }

    function _read_table() {
        if ($this->ci->db->table_exists($this->table)) {
            $fields = $this->ci->db->field_data($this->table);

            foreach ($fields as $field) {
                if ( ! $field->primary_key) {
                    $this->_has_date_field($field->type);
                    array_push($this->fields_types, $field->type);
                    array_push($this->fields, $field->name);
                } else {
                    $this->primary_key = $field->name;
                }
            }
           
            // (we assume that the primary key is named as "id")');
            $this->_result_message(0, 'table '.$this->table.' readed');

            // NOTE: a linha abaixo é pra uso aqui na empresa :)
            // $this->table = str_replace("tribo_", "", $this->table);
        } else {
            $this->_result_message(0, 'table '.$this->table.' not exists');
            $this->stop = true;
        }

    }

    function _build_table() {
        if ( ! $this->ci->db->table_exists($this->table)) {
            $fields = array(
                    'id' => array(
                            'type' => 'INT',
                            'constraint' => 11,
                            'auto_increment' => TRUE
                    )
            );

            foreach ($this->fields as $key => $each_field) {

                if ($this->fields_types[$key] == 'string' || $this->fields_types[$key] == 'varchar') {
                    $type = 'varchar';
                    $constraint = 100;
                } elseif ($this->fields_types[$key] == 'int') {
                    $type = 'INT';
                    $constraint = 11;
                } elseif ($this->fields_types[$key] == 'text') {
                    $type = 'TEXT';
                } elseif ($this->fields_types[$key] == 'date') {
                    $type = 'DATE';
                    unset($constraint);
                } elseif ($this->fields_types[$key] == 'datetime') {
                    $type = 'DATETIME';
                    unset($constraint);
                }

                $field['type'] = strtoupper($type);
                if (isset($constraint)) {
                    $field['constraint'] = $constraint;
                }

                if (isset($null)) {
                    $field['null'] = $null;
                }

                $fields[$this->fields[$key]] = $field;
                $field = null;
            }

            $field['type'] = 'datetime';
            $fields[$this->create_date] = $field;
            $fields[$this->update_date] = $field;
            $this->create_date_fields = true;
            $field = null;

            $this->ci->dbforge->add_key('id', TRUE);
            $this->ci->dbforge->add_field($fields);
            $this->ci->dbforge->create_table($this->table, TRUE);

            $this->_result_message(0, 'table '.$this->table.' created');

        } else {
            $this->_result_message(0, 'table '.$this->table.' exists. Is not possible to ensure that the fields passed in the string are the same fields from the table of the database');
            $this->stop = true;
        }

    }


    function _build_controller() {
        $file = './system/application/controllers/'.$this->table.'.php';

        if ( ! file_exists($file)) {
            $this->_clean_file_content();
            $this->_add_line(0, '<?php');
            $this->_add_line();
            $this->_add_line(1, 'class '.ucwords($this->table).' extends Controller {');
            $this->_add_line();
            $this->_add_line(2, 'function '.ucwords($this->table).'() {');
            $this->_add_line(3, 'parent::Controller();');
            $this->_add_line(3, '$this->load->helper("url");');
            $this->_add_line(3, '$this->load->model("'.$this->table.'_model", "model", TRUE);');
            $this->_add_line(2, '}');

            // function index
            $this->_add_line();
            $this->_add_line(2, 'function index() {');
            $this->_add_line(3, '$data["list"] = $this->model->get_all();');
            $this->_add_line(3, '$data["content"] = $this->load->view("'.$this->table.'/index_view.php", $data, TRUE);');
            $this->_add_line(3, '$this->load->view("main_view.php", $data);');
            $this->_add_line(2, '}');

            // function show
            $this->_add_line();
            $this->_add_line(2, 'function '.$this->lang['show'].'($id) {');
            $this->_add_line(3, '$data["'.$this->table.'"] = $this->model->get_by_id($id);');
            $this->_add_line(3, '$data["content"] = $this->load->view("'.$this->table.'/'.$this->lang['show'].'_view.php", $data, TRUE);');
            $this->_add_line(3, '$this->load->view("main_view.php", $data);');
            $this->_add_line(2, '}');
            $this->_add_line(2, 'function '.$this->lang['create'].'() {');

            foreach($this->fields as $field) {
                $this->_add_line(3, '$data["'.$field.'"] = "";');
            }

            $this->_add_line(3, '$data["'.$this->primary_key.'"] = "";');
            $this->_add_line(3, '$data["form_type"] = "add";');
            $this->_add_line(3, '$data["content"] = $this->load->view("'.$this->table.'/form_view.php", $data, TRUE);');
            $this->_add_line(3, '$this->load->view("main_view.php", $data);');
            $this->_add_line(2, '}');

            // function edit
            $this->_add_line();
            $this->_add_line(2, 'function '.$this->lang['edit'].'($id) {');
            $this->_add_line(3, '$'.$this->table.' = $this->model->get_by_id($id);');

            foreach($this->fields as $field) {
                $this->_add_line(3, '$data["'.$field.'"] = $'.$this->table.'->'.$field.';');
            }
            $this->_add_line(3, '$data["'.$this->primary_key.'"] = $id;');
            $this->_add_line(3, '$data["form_type"] = "edit";');
            $this->_add_line(3, '$data["content"] = $this->load->view("'.$this->table.'/form_view.php", $data, TRUE);');
            $this->_add_line(3, '$this->load->view("main_view.php", $data);');
            $this->_add_line(2, '}');

            // function save
            $this->_add_line();
            $this->_add_line(2, 'function '.$this->lang['save'].'() {');
            $this->_add_line(3, '$data = array(');

            foreach($this->fields as $field) {
                $this->_add_line(4, '"'.$field.'" => $this->input->post("'.$field.'"),');
            }
            $this->_add_line(3, ');');

            $this->_add_line(3, 'if ($this->input->post("form_type") == "add") {');
            if ($this->create_date_fields) {
                $this->_add_line(4, '$data["'.$this->create_date.'"] = date("Y-m-d H:i:s");');
                $this->_add_line(4, '$data["'.$this->update_date.'"] = date("Y-m-d H:i:s");');
            }
            $this->_add_line(4, '$this->model->insert($data);');
            $this->_add_line(3, '} elseif ($this->input->post("form_type") == "edit") {');
            if ($this->create_date_fields) {
                $this->_add_line(4, '$data["'.$this->update_date.'"] = date("Y-m-d H:i:s");');
            }
            $this->_add_line(4, '$this->model->update($data, $this->input->post("'.$this->primary_key.'"));');
            $this->_add_line(3, '}');
            $this->_add_line(3, 'redirect("'.$this->table.'/index", "refresh");');
            $this->_add_line(2, '}');

            // function delete
            $this->_add_line();
            $this->_add_line(2, 'function delete($id) {');
            $this->_add_line(3, 'if(is_numeric($id) && $id > 0) {');
            $this->_add_line(4, '$this->model->delete($id);');
            $this->_add_line(4, 'redirect("'.$this->table.'/index", "refresh");');
            $this->_add_line(3, '}');
            $this->_add_line(2, '}');
            $this->_add_line(1, '} // end of controller');


            $this->_write_content_in_file($file, 'controller');

        } else {
            $this->_result_message(1, 'controller exists');
        }

    }

    function _build_views() {
        $this->_build_table_dir();
        $this->_build_view_show();
        $this->_build_view_index();
        $this->_build_view_form();
        $this->_build_view_main();
    }

    function _build_table_dir() {
        $file = './system/application/views/'.$this->table;

        if ( ! is_dir($file)) {
            if (mkdir ($file)) {
                chmod($file, $this->file_permission);
                $this->_result_message(1, 'folder '.$this->table.' created');
            } else {
                $this->_result_message(1, 'Unable to write the folder '.$this->table);
            }

        } else {
            $this->_result_message(1, 'folder '.$this->table.' exists');
        }
    }

    function _build_view_form() {
        $file = './system/application/views/'.$this->table.'/form_view.php';

        if ( ! file_exists($file)) {
            $this->_clean_file_content();

            if ($this->has_date_field) {
                $this->_add_line(0, '<script type="text/javascript">');
                $this->_add_line(1, '<!--');
                $this->_add_line(2, '$(function() {');

                foreach($this->fields as $key => $field) {
                    if ($this->fields_types[$key] == 'date') {
                        $this->_add_line(3, '$("#'.$field.'").datepicker({ dateFormat: "yy-mm-dd" });');
                    }
                }

                $this->_add_line(2, '});');
                $this->_add_line(1, '-->');
                $this->_add_line(0, '</script>');
                $this->_add_line();
            }

            $this->_add_line(0, '<h1>'.$this->table.'</h1>');
            $this->_add_line(0, '<p><a href="<?= site_url(\''.$this->table.'\') ?>">'.$this->lang['back'].'</a></p>');
            $this->_add_line(0, '<form action="<?= site_url(\''.$this->table.'/'.$this->lang['save'].'\') ?>" method="POST">');

            $this->_add_line(1, '<input type="hidden" name="'.$this->primary_key.'" id="'.$this->primary_key.'" value="<?=$'.$this->primary_key.'?>"/>');
            $this->_add_line(1, '<input type="hidden" name="form_type" id="form_type" value="<?=$form_type?>" />');

            foreach($this->fields as $key => $field) {
                $this->_add_line(1, '<p>');
                $this->_add_line(2, '<label>'.$field.': </label>');
                $this->_add_line(2, '<br/>');
                if ($this->fields_types[$key] == 'text' || $this->fields_types[$key] == 'blob') {
                    $this->_add_line(2, '<textarea name="'.$field.'" id="'.$field.'" ><?=$'.$field.'?></textarea>');
                } else {
                    $this->_add_line(2, '<input type="text" name="'.$field.'" id="'.$field.'" value="<?=$'.$field.'?>" />');
                }
                $this->_add_line(1, '</p>');
            }
            $this->_add_line(1, '<p>');
            $this->_add_line(2, '<label></label>');
            $this->_add_line(2, '<input type="submit" value="'.$this->lang['save'].'" />');
            $this->_add_line(1, '</p>');
            $this->_add_line(0, '</form>');

            $this->_add_line(0, '<p><a href="<?= site_url(\''.$this->table.'\') ?>">'.$this->lang['back'].'</a></p>');


            $this->_write_content_in_file($file, 'form view');

        } else {
            $this->_result_message(2, 'form view exists');
        }
    }

    function _build_view_index() {
        $file = './system/application/views/'.$this->table.'/index_view.php';

        if ( ! file_exists($file)) {
            $this->_clean_file_content();
            $this->_add_line(0, '<h1>'.$this->lang['listing'].' '.$this->table.'</h1>');
            $this->_add_line(0, '<p><a href="<?= site_url(\''.$this->table.'/'.$this->lang['create'].'\') ?>">'.$this->lang['new'].'</a></p>');
            $this->_add_line(0, '<table>');
            $this->_add_line(1, '<tr>');
            foreach($this->fields as $field) {
                $this->_add_line(2, '<th>'.$field.'</th>');
            }
            $this->_add_line(2, '<th></th>');
            $this->_add_line(2, '<th></th>');
            $this->_add_line(2, '<th></th>');
            $this->_add_line(1, '</tr>');

            $this->_add_line(1, '<? foreach($list as $item) { ?>');
            $this->_add_line(2, '<tr>');
            foreach($this->fields as $field) {
                $this->_add_line(3, '<td><?=$item->'.$field.' ?></td>');
            }
            $this->_add_line(3, '<td><a href="<?= site_url(\''.$this->table.'/'.$this->lang['show'].'/\'.$item->'.$this->primary_key.') ?>">'.$this->lang['show'].'</a></td>');
            $this->_add_line(3, '<td><a href="<?= site_url(\''.$this->table.'/'.$this->lang['edit'].'/\'.$item->'.$this->primary_key.') ?>">'.$this->lang['edit'].'</a></td>');
            $this->_add_line(3, '<td><a style="text-decoration: underline; color:blue; cursor:pointer;" onclick="del(\''.$this->table.'\', <?= $item->'.$this->primary_key.' ?>);">'.$this->lang['destroy'].'</a></td>');
            $this->_add_line(2, '</tr>');
            $this->_add_line(1, '<? } ?>');

            $this->_add_line(0, '</table>');

            $this->_add_line(0, '<p><a href="<?= site_url(\''.$this->table.'/'.$this->lang['create'].'\') ?>">'.$this->lang['new'].'</a></p>');


            $this->_write_content_in_file($file, 'index view');

        } else {
            $this->_result_message(2, 'index view exists');
        }

    }

    function _build_view_show() {
        $file = './system/application/views/'.$this->table.'/'.$this->lang['show'].'_view.php';

        if ( ! file_exists($file)) {
            $this->_clean_file_content();
            $this->_add_line(0, '<h1>'.$this->lang['show'].' '.$this->table.'</h1>');
            foreach($this->fields as $field) {
                $this->_add_line(0, '<p>');
                $this->_add_line(1, '<label><strong>'.$field.': </strong></label>');
                $this->_add_line(1, '<?=$'.$this->table.'->'.$field.' ?>');
                $this->_add_line(0, '</p>');
            }

            $this->_add_line(0, '<p><a href="<?= site_url(\''.$this->table.'\') ?>">'.$this->lang['back'].'</a></p>');

            $this->_write_content_in_file($file, $this->lang['show'].' view');

        } else {
            $this->_result_message(2, $this->lang['show'].' view exists');
        }

    }

    function _build_view_main() {
        $file = './system/application/views/main_view.php';

        if ( ! file_exists($file)) {
            $this->_clean_file_content();
            $this->_add_line(0, '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">');
            $this->_add_line(0, '<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">');
            $this->_add_line(1, '<head>');
            $this->_add_line(2, '<meta http-equiv="Content-type" content="text/html; charset=utf-8" />');

            // Calendario
            $this->_add_line(2, '<link type="text/css" href="http://jqueryui.com/themes/base/jquery.ui.all.css" rel="stylesheet" />');
            $this->_add_line(2, '<script type="text/javascript" src="http://jqueryui.com/jquery-1.4.2.js"></script>');
            $this->_add_line(2, '<script type="text/javascript" src="http://jqueryui.com/ui/jquery.ui.core.js"></script>');
            $this->_add_line(2, '<script type="text/javascript" src="http://jqueryui.com/ui/jquery.ui.widget.js"></script>');
            $this->_add_line(2, '<script type="text/javascript" src="http://jqueryui.com/ui/jquery.ui.datepicker.js"></script>');

            $this->_add_line(2, '<script type="text/javascript">');
            $this->_add_line(3, '<!--');
            $this->_add_line(3, 'function del(table, id) {');
            $this->_add_line(4, 'var answer = confirm("Delete?")');
            $this->_add_line(4, 'if (answer) {');
            $this->_add_line(5, 'window.location = "'.base_url().'index.php/"+table+"/delete/"+id');
            $this->_add_line(4, '}');
            $this->_add_line(3, '}');
            $this->_add_line(3, '//-->');
            $this->_add_line(2, '</script>');
            $this->_add_line(1, '</head>');
            $this->_add_line(1, '<body>');
            $this->_add_line(2, '<?=$content?>');
            $this->_add_line(1, '</body>');
            $this->_add_line(0, '</html>');

            $this->_write_content_in_file($file, $this->main_view.' view');

        } else {
            $this->_result_message(1, $this->main_view.' exists');
        }
    }

    function _build_model() {
        $file = './system/application/models/'.$this->table.'_model.php';
        if ( ! file_exists($file)) {
            $this->_clean_file_content();
            $this->_add_line(0, '<?php');
            $this->_add_line();
            $this->_add_line(1, 'class '.ucwords($this->table).'_model extends Model {');

            $this->_add_line();
            foreach($this->fields as $field) {
                $this->_add_line(2, 'var $'.$field.';');
            }
            $this->_add_line();
            $this->_add_line(2, 'function '.ucwords($this->table).'_model() {');
            $this->_add_line(3, 'parent::Model();');
            $this->_add_line(2, '}');

            // function get_all
            $this->_add_line();
            $this->_add_line(2, 'function get_all() {');
            $this->_add_line(3, '$query = $this->db->get("'.$this->table.'");');
            $this->_add_line(3, 'return $query->result();');
            $this->_add_line(2, '}');

            // function get_by_id
            $this->_add_line();
            $this->_add_line(2, 'function get_by_id($id) {');
            $this->_add_line(3, '$this->db->where("'.$this->primary_key.'", $id);');
            $this->_add_line(3, '$query = $this->db->get("'.$this->table.'");');
            $this->_add_line(3, 'return $query->row();');
            $this->_add_line(2, '}');

            // function insert
            $this->_add_line();
            $this->_add_line(2, 'function insert($data) {');
            $this->_add_line(3, 'return $this->db->insert("'.$this->table.'", $data);');
            $this->_add_line(2, '}');

            // function update
            $this->_add_line();
            $this->_add_line(2, 'function update($data, $id) {');
            $this->_add_line(3, '$this->db->where("'.$this->primary_key.'", $id);');
            $this->_add_line(3, 'return $this->db->update("'.$this->table.'", $data);');
            $this->_add_line(2, '}');

            // function delete
            $this->_add_line();
            $this->_add_line(2, 'function delete($id) {');
            $this->_add_line(3, '$this->db->where("'.$this->primary_key.'", $id);');
            $this->_add_line(3, 'return $this->db->delete("'.$this->table.'");');
            $this->_add_line(2, '}');

            $this->_add_line();
            $this->_add_line(1, '}');


            $this->_write_content_in_file($file, 'model');

        } else {
            $this->_result_message(1, 'model exists');
        }

    }



}

// END Creater class

/* End of file Creater.php */
/* Location: ./system/application/libraries/Creater.php */