Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/public_html/crm/crm_2020_11_03/application/modules/bugfix/controllers

Free Space:

4.03 TB

🔧 Quick Actions

✏️ Editing: Bugfix.php

<?php
if ( !defined( 'BASEPATH' ) )
    exit( 'No direct script access allowed' );
class Bugfix extends CI_Controller {
    function __construct() {
        parent::__construct();
        $this->load->model( array( 'bugfix_model') );
        $this->load->helper( array(
             'form' 
        ) );
        $session_data       = $this->session->userdata( 'logged_in' );
        $data['permission'] = $this->session->userdata(SESSION_LOGIN . 'user_permission');
        $data[ 'username' ] = $session_data[ 'username' ];
        $data['title'] = 'Bug Details';
        $this->load->view( 'common/header', $data );
       
    }
    function hasPermission( $page ) {
        $res_permission = $this->session->userdata(SESSION_LOGIN . 'user_permission');
        if($res_permission && !empty($res_permission)){
			if ( !in_array( $page, $res_permission ) ) {
				redirect( 'access_denied', 'refresh' );
			}
		}else{
			redirect( 'home');
		}
    }
    function index() {        
        $this->getList();
        
    }
    
	function getList(){
            $this->hasPermission( 'bugfix_view' );
			$filter_data ='';
			if ( $this->input->server( 'REQUEST_METHOD' ) == 'POST' ){
				 $filter_data = $this->input->post();
				 $reset_data = $this->input->post('reset');
				 if(isset($reset_data)){
					$this->session->unset_userdata( 'filter_data' );
				 }else{
					$this->session->set_userdata( 'filter_data', $filter_data );
				 }
			}else{
				$session_filter_data = $this->session->userdata('filter_data');
				if(isset($session_filter_data)){
					$filter_data = $session_filter_data;
				}else{
					$filter_data ='';
				}
			}
			$data = array();
			$segment_3 = $this->uri->segment( 3 );
			$segment_4 = $this->uri->segment( 4 );
			$segment_5 = $this->uri->segment( 5 );			
			
			 // If not pagination page remove filter data from session
            if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
                $data['filter_data'] = '';
            }
			
			if(isset($segment_3)){
				$page = $segment_3;
			}else{
				$page = '1';
			}
			
			if(isset($segment_4)){
				$sort = $segment_4;
			}else{
				$sort = 'bug_raise_date';
			}
			
			if(isset($segment_5)){
				$order = $segment_5;
			}else{
				$order = 'DESC';
			}
			
            $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
            $filter_query_data      = array();
            $data['limit'] = '';
            if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
                $start                     = (($page - 1) * $_REQUEST['limit']);
                $filter_query_data['limit'] = $_REQUEST['limit'];
                $data['limit'] = '?limit='.$_REQUEST['limit'];
            }else{
                $start                     = (($page - 1) * RPP);
            }
            
            $data['start']             = $start; // Generate SNO in result table based on page number
            $filter_query_data['start']             = $start;
            $filter_query_data['sort']              = $sort;
            $filter_query_data['order']             = $order;
        
			// $start = (($page-1)*RPP);
			// $data['start'] = $start;
			// $data['sort'] = $sort;
			// $data['order'] = $order;
			$table['tbl_main']  = 'bug_fix';
			
			$data[ 'mainlist_count' ] = $this->Common_model->getListCount($table,$filter_data);
			$data[ 'mainlist' ] = $this->Common_model->getList($table,$filter_query_data,$filter_data);
			$data[ 'tablefields' ] = $this->Common_model->getTableFields('bug_fix');
			$data[ 'operations' ] = $this->Common_model->getFilterOperation();
			$data[ 'init_listing_page' ] = 'bugfix/menuList/'; 
			$data[ 'listing_page' ] = $data[ 'init_listing_page' ].$page.'/';
            $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
			$data['action'] = site_url('bugfix/addBug');
			$this->load->view( 'common/menu' );
			$this->load->view( 'bugfix/bugfix_list_view',$data );
			$this->load->view( 'common/footer' );
	 }
	 
	function addBug(){
		$this->hasPermission( 'bugfix_add' );
		$data['action'] = site_url('bugfix/addBug');
		if ( $this->input->server( 'REQUEST_METHOD' ) == 'POST' ) {
			   $data = $this->input->post();
			   
            if (isset($_FILES['bug_screenshot_file']['name']) && !empty($_FILES['bug_screenshot_file']['name'])) {
                $config['upload_path']   = './uploads/bugfix';
                $config['allowed_types'] = '*';
                $config['max_size']      = '10000';
                $new_name                = time().'_'.$_FILES['bug_screenshot_file']['name'];
                $config['file_name']     = $new_name;
                $this->load->library('upload', $config);
                if (!$this->upload->do_upload('bug_screenshot_file')) {
                    $upload_error = array(
                        'error' => $this->upload->display_errors()
                    );
                    print_r($upload_error);
                    $this->load->view('bugfix/bugfix_form_view', $upload_error);
                } else {
                    $upload_data            = $this->upload->data();
                    $file_name              = $upload_data['file_name'];
                    $data['bug_screenshot_file'] = 'uploads/bugfix/'.$file_name;
                }
            } else {
                $data['bug_screenshot_file'] = '';
            }
              //~ echo '<pre>';
			   //~ print_r($data);
			   //~ echo '</pre>';
			   //~ exit;
			   $res = $this->Common_model->addRecord('bug_fix',$data);
			
				if($res){
					$this->Common_model->TxnCommit();
					$this->Common_model->addUserActivity('bugfix_add',$res); // Record User Activity
					$_SESSION['success_msg'] = 'Company successfully added ...';
				}else{
					$this->Common_model->TxnRollBack();
					$_SESSION['error_msg'] = 'Error occurred please try again...';
				}  
              redirect('bugfix');
			  
		}else{
			$this->load->view( 'common/menu' );
			$this->load->view( 'bugfix/bugfix_form_view',$data );
			$this->load->view( 'common/footer' );
		}
	}
	
	
	function editBug()
    {
        $this->hasPermission( 'bugfix_edit' ); 
        $id  = $this->uri->segment(3);
        $data['action'] = site_url('bugfix/editBug/'.$id);
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
			$udata = $this->input->post();
			
			if (isset($_FILES['bug_reference_file']['name']) && !empty($_FILES['bug_reference_file']['name'])) {
                $config['upload_path']   = './uploads/bugfix';
                $config['allowed_types'] = '*';
                $config['max_size']      = '10000';
                $new_name                = time().'_'.$_FILES['bug_reference_file']['name'];
                $config['file_name']     = $new_name;
                $this->load->library('upload', $config);
                if (!$this->upload->do_upload('bug_reference_file')) {
                    $upload_error = array(
                        'error' => $this->upload->display_errors()
                    );
                    print_r($upload_error);
                    $this->load->view('bugfix/bugfix_edit_view', $upload_error);
                } else {
                    $upload_data            = $this->upload->data();
                    $file_name              = $upload_data['file_name'];
                    $udata['bug_reference_file'] = 'uploads/bugfix/'.$file_name;
                }
            } else {
                $udata['bug_reference_file'] = '';
            }
           unset($udata['redirect_to']);
/*
            print_r($udata);
            exit;
*/
			
            $res = $this->bugfix_model->updateRecord('bug_fix',$udata, $id);
            redirect('bugfix/getList');
        } else {
            $data['bug']        = $this->Common_model->getDetails('bug_fix','bug_fix_id',$id);
            $this->load->view('common/menu');
            $this->load->view('bugfix/bugfix_edit_view', $data);
            $this->load->view('common/footer');
        }
    }
    
    function deleteBug()
    {
        $this->hasPermission('bugfix_delete');
		$delete_id = $this->input->post('checkbox'); 
		if(!empty($delete_id)){
			 foreach($delete_id as $key => $id){
				 $this->Common_model->removeRecord('bug_fix', 'bug_fix_id', $id);
			 }
		}
		redirect('bugfix/getList');
    }
    
    function exportBugfix()
    {
        $this->hasPermission('bugfix_view');
        $filter_data         = '';
        $session_filter_data = $this->session->userdata('filter_data');
        if (isset($session_filter_data)) {
            $filter_data = $session_filter_data;
        } else {
            $filter_data = '';
        }
        $data          = array();
        $data['sort']  = 'bug_fix_id';
        $data['order'] = 'ASC';
        $table['tbl_main']           = 'bug_fix';
        $mainlist      = $this->Common_model->getList($table, $data, $filter_data,'bug_fix_id');
        foreach ($mainlist as $key => $val) {
			
			$export_list[] = array(
					$val->bug_category_name,
					$val->bug_name,
					$this->Common_model->getDateFormat($val->bug_raise_date),
					strip_tags($val->bug_details),
					$this->Common_model->getDateFormat($val->bug_completed_date),
					strip_tags($val->bug_fix_details),
					$val->bug_status_name
            );

}
        
        $export_column = array(
            'Category',
            'Bug Name',
            'Raise Date',
            'Details',
            'Fixed Date',
            'Solution',
            'Status'
        );
        
        $export        = array();
        $export[0]     = $export_column;
        foreach ($export_list as $key => $export_row) {
            $export[] = $export_row;
        }
        
        $this->Common_model->generateExcel($export,'Bugfix_List_' . date('Y-m-d_H:i:s'));
        
    }
    
    public function exportBugfixPDF()
    {
		
        $filter_data         = '';
        $session_filter_data = $this->session->userdata('filter_data');
        if (isset($session_filter_data)) {
            $filter_data = $session_filter_data;
        } else {
            $filter_data = '';
        }
        $data             = array();
        $data['sort']     = 'bug_fix_id';
        $data['order']    = 'ASC';
        $table['tbl_main']  = 'bug_fix';
        $mainlist = $this->Common_model->getList($table, $data, $filter_data);
          
        $data['title'] = 'Bugfix List';
        // Row Header
		$data['row_header'] = array();
		$data['row_header'][] = array(
			'name'		=> 'S.No',
			'width'		=> '5%',
			'align'		=> 'center'
		);
		
		$data['row_header'][] = array(
			'name'		=> 'Category',
			'width'		=> '10%',
			'align'		=> 'left'
		);
		
		$data['row_header'][] = array(
			'name'		=> 'Bug Name',
			'width'		=> '10%',
			'align'		=> 'left'
		);
		
		$data['row_header'][] = array(
			'name'		=> 'Raise Date',
			'width'		=> '10%',
			'align'		=> 'left'
		);
		
		$data['row_header'][] = array(
			'name'		=> 'Bug details',
			'width'		=> '25%',
			'align'		=> 'left'
		);
		
		 $data['row_header'][] = array(
			'name'		=> 'Fixed Date',
			'width'		=> '10%',
			'align'		=> 'left'
		);
		
		 $data['row_header'][] = array(
			'name'		=> 'Solution',
			'width'		=> '20%',
			'align'		=> 'left'
		);
		
		$data['row_header'][] = array(
			'name'		=> 'Status',
			'width'		=> '10%',
			'align'		=> 'left'
		);
		
			   
		// Row Data
		$data['row_data'] = array();
		if(isset($mainlist) && !empty($mainlist)){
			$i = 1;
			foreach($mainlist as $key => $val){
								
				 $data['row_data'][] = array(
					$i,
					$val->bug_category_name,
					$val->bug_name,
					$this->Common_model->getDateFormat($val->bug_raise_date),
					strip_tags($val->bug_details),
					$this->Common_model->getDateFormat($val->bug_completed_date),
					strip_tags($val->bug_fix_details),
					$val->bug_status_name
				);
				$i++;
			}
				
		}
			
        $this->load->library('parser');
        $header_html = $this->parser->parse('template/pdf/pdf_header',$data);
		$footer_html = $this->parser->parse('template/pdf/pdf_footer',$data);
        $html = $this->parser->parse('template/pdf/list_tmp', $data);
        
        $file_name = 'Bugfix_list_' . date('Y-m-d _ H:i:s') . '.pdf';
        //$this->Common_model->exportPdf($html,$file_name,'L');
        $this->Common_model->exportPdf($header_html,$footer_html,$html,$file_name,'P','I');
        
    }
    
    
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Bugfix.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation