📄 File: Alldata.php

Path: /home2/outerorb/crm.outerorbittech.com/application/libraries/Alldata.php

Size: 9.71 KB

Permissions: 0664

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

class Alldata {
	protected $CI;
	protected $default_controller='';
	protected $default_controller_file='';
	
	protected $config=false;

	// We'll use a constructor, as you can't directly call a function
	// from a property definition.
	public function __construct(){
		// Assign the CodeIgniter super-object
		$this->CI =& get_instance();
        $this->addcontrollermethod();
		
        if(!is_dir('./application/views/alldata')){
			mkdir('./application/views/alldata');
		}
		$data=$this->alldataview();
		write_file('./application/views/alldata/all.php',$data);
		$data=$this->datatableview();
		write_file('./application/views/alldata/table.php',$data);
	}
	
	
	public function viewall($auth=''){
		if($auth!='superadmin'){ redirect('home/');}
		$data['title']="All Data";
		$data['datatable']=true;
		$tables=$this->gettables();
		$option['']="Select Table";
		if(is_array($tables)){
			foreach($tables as $table){
				$key = key($table);
				$option[$table[$key]]=$table[$key];
			}
		}
		$data['tables']=$option;
		$this->CI->template->load('alldata','all',$data);
	}
	
	public function gettable(){
		$table=$this->CI->input->post('table');
		if($table!=''){
			$data['columns']=$this->getcolumns($table);
			$data['data']=$this->getdata($table);
		}
		else{
			$data['columns'][]=array("Field"=>"Columns in Table");
			$data['data']=array();
		}
		$this->CI->load->view("alldata/table",$data);
	}
	
	public function updatedata(){
		if($this->CI->input->post('table')!==NULL){
			$table=$this->CI->input->post('table');
			$id=$this->CI->input->post('id');
			$where['id']=$id;
			unset($_POST['table']);
			unset($_POST['id']);
			$this->update($table,$_POST,$where);
		}
	}
    
    public function addcontrollermethod(){
        
        $file=fopen(APPPATH.'config/routes.php','r');
        while(! feof($file)) {
            $line = fgets($file);
            if(strpos($line,'default_controller')!==false && strpos($line,'|')===false){
                $this->default_controller=str_replace('$route[\'default_controller\']','',$line);
                $this->default_controller=str_replace('=','',$this->default_controller);
                $this->default_controller=str_replace(';','',$this->default_controller);
                $this->default_controller=trim($this->default_controller);
                $this->default_controller=trim($this->default_controller,"'");
                $this->default_controller_file= ucfirst($this->default_controller).'.php';
            }
            
        }
        fclose($file);
        
        $toadd=true;
        $controller_contents=array();
        $file=fopen(APPPATH.'controllers/'.$this->default_controller_file,'r');
        while(! feof($file)) {
            $line = fgets($file);
            if(strpos($line,'public function alldata')!==false){ $toadd=false; break; }
            $controller_contents[]=$line;
        }
        fclose($file);
        
        if($toadd===true){
            $last=end($controller_contents);
            while(strpos($last,'}')===false){
                array_pop($controller_contents);
                $last=end($controller_contents);
            }
            $file=fopen(APPPATH.'controllers/'.$this->default_controller_file,'w');
            $count=count($controller_contents);
            $count--;
            foreach($controller_contents as $key=>$controller_content){
                
                if($key==$count){
                    $functions="    
    public function alldata(\$token=''){
		\$this->load->library('alldata');
		\$this->alldata->viewall(\$token);
	}
	
	public function gettable(){
		\$this->load->library('alldata');
		\$this->alldata->gettable();
	}
	
	public function updatedata(){
		\$this->load->library('alldata');
		\$this->alldata->updatedata();
	}
";
                    fwrite($file,$functions);
                }
                fwrite($file,$controller_content);
            }
            fclose($file);
        }
    }
	
	public function alldataview(){
		$html="
<section class=\"content\">
	<div class=\"container-fluid\">
		<div class=\"row\">
			<div class=\"col-md-12\">
				<div class=\"card\">
					<div class=\"card-header\">
						<h3 class=\"card-title\"><?php echo \$title; ?></h3>
					</div>
					<!-- /.card-header -->
					<div class=\"card-body\">
						<div class=\"row\">
							<div class=\"col-md-12\">
								<div class=\"row\">
									<div class=\"col-md-4\">
										<div class=\"form-group\">
											<label class=\"col-form-label\">Select Table</label>
											<?php 
												echo form_dropdown('table', \$tables,'',array('id'=>'table', 'class'=>'form-control'));
											?>
										</div>
									</div>
									<div class=\"col-md-4\"><br><br>
										<button type=\"button\" class=\"btn btn-info btn-sm\" onClick=\"$('#table').trigger('change');$(this).next().toggleClass('btn-primary btn-danger');\">Refresh</button>
										<button type=\"button\" class=\"btn btn-primary btn-sm\" onClick=\"$('#bootstrap-data-table-export tfoot').toggleClass('hidden');$(this).toggleClass('btn-primary btn-danger');$('.search-col').val('').trigger('keyup');\">
											Toggle Search
										</button>
									</div>
								</div><br>
				
								<div class=\"row\">
									<div class=\"col-md-12\">
										<div class=\"table-responsive\" id=\"datatable\">
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>  
</section>
<input type=\"hidden\" name=\"table\" id=\"uptable\">
<input type=\"hidden\" name=\"id\" id=\"id\">
<input type=\"hidden\" id=\"temp_val\">
<input type=\"submit\" value=\"save\" class=\"hidden\">
        <script>
        	
			$(document).ready(function(e) {
                createTable();
				$('#table').change(function(){
					var table=$(this).val();
					$.ajax({
						type:\"POST\",
						url:\"<?php echo site_url(\"".$this->default_controller."/gettable/\"); ?>\",
						data:{table:table},
						success: function(data){
							$('#datatable').html(data);
							createTable();
						}
					});
				});
				$('body').on('dblclick','.editable',function(e){
					if(e.target.id==\"column\"){ return false; }
					//var prevVal=$('#column').val();
					//$('#column').closest('td').text(prevVal);
					var id=$(this).parent().children(\":eq(0)\").html();
					var column=$(this).attr('data-column');
					var value=$(this).text();
					var table=$('#table').val();
					$('#uptable').val(table);
					$('#id').val(id);
					$(this).html('<input type=\"text\" id=\"column\" value=\"\">');
					$('#column').attr(\"name\",column);
					$('#column').val(value).focus();
					$('#temp_val').val(value);
				});
				$('body').on('keyup',function(e){
					if(e.which==13){
						if($('#column').length==1){
							var table=$('#uptable').val();
							var id=$('#id').val();
							var column=$('#column').attr(\"name\");
							var value=$('#column').val();
							var data = {};
							data['table']=table;
							data['id']=id;
							data[column] = value;
							$.ajax({
								type:\"POST\",
								url:\"<?php echo base_url('".$this->default_controller."/updatedata'); ?>\",
								data:data,
								success: function(data){
									$('#table').trigger('change');
								}
							});
						}
					}
				});
				$('body').on('click',function(e){
					if(e.target.classList!='editable' && e.target.nodeName!='INPUT'){	
						var value=$('#temp_val').val();
						$('#column').closest('td').text(value);
					}
				});
            });
			
			function createTable(){
				$('#bootstrap-data-table-export tfoot th').each( function () {
					var title = $(this).text();
					$(this).html( '<input type=\"text\" class=\"search-col\" placeholder=\"Search '+title+'\" />' );
				} );
				var table = $('#bootstrap-data-table-export').DataTable();
				table.columns().every( function () {
					var that = this;
			 
					$( 'input', this.footer() ).on( 'keyup change clear', function () {
						if ( that.search() !== this.value ) {
							that
								.search( this.value )
								.draw();
						}
					} );
				} );
			}
        </script>";
		return $html;
	}
	
	public function datatableview(){
		$html="
<table class=\"table data-table\" id=\"bootstrap-data-table-export\">
    <thead>
        <tr>
        	<?php
            	if(!empty(\$columns)){
					foreach(\$columns as \$column){
						echo \"<th>\$column[Field]</th>\";
					}
				}
			?>
        </tr>
    </thead>
    <tbody>
        <?php
        if(is_array(\$data)){
            foreach(\$data as \$row):
        ?>
        <tr>
        	<?php
            	if(!empty(\$columns)){
					foreach(\$columns as \$column){
						\$field=\$column['Field'];
			?>
            <td class=\"editable \" data-column=\"<?php echo \$field ?>\"><?php echo \$row[\$field]; ?></td>
            <?php
					}
				}
			?>
        </tr>
        <?php
            endforeach; 
        } 
        ?> 
    </tbody>
    <tfoot class=\"hidden\">
        <tr>
        	<?php
            	if(!empty(\$columns)){
					foreach(\$columns as \$column){
						echo \"<th>\$column[Field]</th>\";
					}
				}
			?>
        </tr>
    </tfoot>
</table>";
		return $html;
	}
	
	public function gettables(){
		$query=$this->CI->db->query("Show Tables");
		$tables=[];
		if($query->num_rows()>0){
			$tables=$query->result_array();
		}
		return $tables;
	}
	
	public function getcolumns($table){
		$query=$this->CI->db->query("Show Columns from $table");
		$columns=[];
		if($query->num_rows()>0){
			$columns=$query->result_array();
		}
		return $columns;
	}
	
	public function getdata($table){
		$query=$this->CI->db->get($table);
		$data=[];
		if($query->num_rows()>0){
			$data=$query->result_array();
		}
		return $data;
	}
	
	public function update($table,$data,$where){
		$this->CI->db->where($where);
		$this->CI->db->update($table,$data);
	}
	
	
}

← Back to Directory Edit File 🔒 Chmod