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/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Grn.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Grn extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Grn_model'));
    $this->load->library('pagination');
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'GRN');
  }

public function mno_print($id)
  {
    $data['rm_stock'] = $this->Grn_model->get_rm_stock_by_grn_id($id);
    $this->load->view('grn/printview',$data);
  }

public function grn_export()
  {
    $grnsearch_change = isset($_SESSION['grnsearch_change'])?$_SESSION['grnsearch_change']:'';
    $grnfilterstatus = isset($_SESSION['grnfilterstatus'])?$_SESSION['grnfilterstatus']:'all';
    if ($grnsearch_change != '') {
      $sc = 'AND (l.location_name LIKE "%'.$grnsearch_change.'%" OR g.transport_name LIKE "%'.$grnsearch_change.'%" OR g.grn_no LIKE "%'.$grnsearch_change.'%" OR g.lr_no LIKE "%'.$grnsearch_change.'%")';
    }
    else {
      $sc = '';
    }

if($grnfilterstatus!='all'){
        $gsts = 'AND g.status='.$grnfilterstatus;
      }
      else{
        $gsts = '';
      }

$grn_list = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 $sc $gsts ORDER BY g.grn_id DESC")->result_array();

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
        'font' => array(
            'bold' => true,
            'color' => array('rgb' => '000000')
        )/*,
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )*/
    );

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Customer Code');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Customer Name');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Type');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Category');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Opening Balance');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Created By');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Created On');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($grn_list as $u_list ) { 
      if($u_list['receipt_date_time']!='')
        $rdate = explode(' ', $u_list['receipt_date_time']);

if($u_list['status']==0)
        $sts = 'Pending';
      else
        $sts = 'Approved';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['grn_no']);
      //$objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['customer_name'].' - '.$cusDetails->phone_no);
      if($u_list['receipt_date_time']!='')
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, date_format(date_create($rdate[0]),$g_settings->date_format).' '.$rdate[1]);
      else
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $u_list['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['transport_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['lr_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $u_list['no_of_bundles']);
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $sts);

$i++;
    }

$filename='GRN.xlsx'; //save our workbook as this file name
    header('Content-Type: application/vnd.ms-excel'); //mime type
    header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
    header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
    //if you want to save it as .XLSX Excel 2007 format
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
    $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
        //force user to download the Excel file without writing it to server's HD
        $objWriter->save('php://output');

}

public function index()
  { 
    //$data['grn_list'] = $this->Grn_model->get_grn_list();    
    $config = array();
    $config["base_url"] = base_url() . "grn";
    $config["per_page"] = 10;
    $config["uri_segment"] = 2;
    $config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
    $config['full_tag_close'] = '</ul></div>';
    $config['num_tag_open'] = '<li class="page-item">';
    $config['num_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="page-item active"><a class="page-link" href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['next_tag_open'] = '<li class="page-item">';
    $config['next_tagl_close'] = '</a></li>';
    $config['prev_tag_open'] = '<li class="page-item">';
    $config['prev_tagl_close'] = '</li>';
    $config['first_tag_open'] = '<li class="page-item">';
    $config['first_tagl_close'] = '</li>';
    $config['last_tag_open'] = '<li class="page-item">';
    $config['last_tagl_close'] = '</a></li>';
    $config['attributes'] = array('class' => 'page-link');
    $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
    
    $perpage = $config['per_page'];

if ($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['grnsearch_change']) || isset($_SESSION['grnfilterstatus'])))) {
      // $this->session->set_userdata('grnsearch_change', $this->input->post('grn_search')!=''?$this->input->post('grn_search'):$_SESSION['grnsearch_change']);
      $this->session->set_userdata('grnsearch_change', $this->input->post('grn_search'));
      $this->session->set_userdata('grnfilterstatus', $this->input->post('grnfilterstatus')!=''?$this->input->post('grnfilterstatus'):$_SESSION['grnfilterstatus']);
      $grnsearch_change = isset($_SESSION['grnsearch_change'])?$_SESSION['grnsearch_change']:$this->input->post('grn_search');
      $grnfilterstatus = isset($_SESSION['grnfilterstatus'])?$_SESSION['grnfilterstatus']:$this->input->post('grnfilterstatus');

if ($grnsearch_change != '') {
        $sc = 'AND (l.location_name LIKE "%'.$grnsearch_change.'%" OR g.transport_name LIKE "%'.$grnsearch_change.'%" OR g.grn_no LIKE "%'.$grnsearch_change.'%" OR g.lr_no LIKE "%'.$grnsearch_change.'%")';
      }
      else {
        $sc = '';
      }

if($grnfilterstatus!='all'){
        $gsts = 'AND g.status='.$grnfilterstatus;
      }
      else{
        $gsts = '';
      }
      $data['grnsearch_change'] = $grnsearch_change;
      $data['statuschange'] = $grnfilterstatus;

$data['grn_list_count'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 $sc $gsts ORDER BY g.grn_id DESC")->result_array();
      $config['total_rows'] = count($data['grn_list_count']);

$data['grn_list'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 $sc $gsts ORDER BY g.grn_id DESC LIMIT $page, $perpage")->result_array();
    }
    else {
      $data['grnsearch_change'] = '';
      $data['statuschange'] = 'all';
      $this->session->unset_userdata('grnsearch_change');
      if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        {
          $data['grn_list_count'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 ORDER BY g.grn_id DESC")->result_array();
          $config['total_rows'] = count($data['grn_list_count']);

$data['grn_list'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 ORDER BY g.grn_id DESC LIMIT $page, $perpage")->result_array();
        }
        else
        {
          // $data['grn_list'] = $this->Grn_model->get_user_grn_list($_SESSION['user_id']);

$data['grn_list_count'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND g.created_by='".$_SESSION['user_id']."' ORDER BY g.grn_id DESC")->result_array();
          $config['total_rows'] = count($data['grn_list_count']);
          
          $data['grn_list'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND g.created_by='".$_SESSION['user_id']."' ORDER BY g.grn_id DESC LIMIT $page, $perpage")->result_array();
        }
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        // $data['grn_list'] = $this->Grn_model->get_user_grn_list($_SESSION['user_id']);
        $data['grn_list_count'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND g.created_by='".$_SESSION['user_id']."' ORDER BY g.grn_id DESC")->result_array();
        $config['total_rows'] = count($data['grn_list_count']);
        
        $data['grn_list'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND g.created_by='".$_SESSION['user_id']."' ORDER BY g.grn_id DESC LIMIT $page, $perpage")->result_array();
      }
      else
      {
        // $data['grn_list'] = $this->Grn_model->get_super_user_grn_list($_SESSION['company_id']);
        $data['grn_list_count'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND l.location_id='".$_SESSION['company_id']."' ORDER BY g.grn_id DESC")->result_array();
        $config['total_rows'] = count($data['grn_list_count']);
        
        $data['grn_list'] = $this->db->query("SELECT g.*,l.location_name FROM grn g,location l WHERE g.location_id = l.location_id AND g.status!=5 AND l.location_id='".$_SESSION['company_id']."' ORDER BY g.grn_id DESC LIMIT $page, $perpage")->result_array();
      }
    }
    $this->pagination->initialize($config);
    $data['links'] = $this->pagination->create_links();
    $this->load->view('grn/grn_list',$data);
  }

public function grn_add()
  {
    //$data['location_list'] = $this->Grn_model->get_active_location();
    if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Grn_model->get_active_location();
    else
      $data['location_list'] = $this->Grn_model->get_location_by_comp_id($_SESSION['company_id']);
    $data['rawmaterial_list'] = $this->Grn_model->get_active_rawmaterials();
    $data['purchase_product_list'] = $this->Grn_model->get_active_purchase_product_list();
    $this->load->view('grn/grn_add',$data);
  }

public function checkBillNoUnique()
  {
    $val = $_POST['value'];
    $result = $this->Grn_model->checkBillNoUnique($val);
    echo count($result);
  }

public function create_grn()
  {
    /*$lid = $data['location_id']=$this->input->post('location_id');
    $ddt = explode('/', $this->input->post('grn_date'));
    $data['grn_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['transport_name']=$this->input->post('transport_name');
    $data['vehicle_no']=$this->input->post('vehicle_no');
    $data['bill_no'] = $this->input->post('bill_no');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $type = $data['type'] = $this->input->post('type');*/

$lid = $data['location_id']=$this->input->post('location_id');
    $data['receipt_date_time']=$this->input->post('receipt_date_time'); 
    $data['transport_name']=$this->input->post('transport_name');
    $data['lr_no']=$this->input->post('lr_no');
    $data['no_of_bundles'] = $this->input->post('no_of_bundles');
    $data['remarks'] = $this->input->post('remarks');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $type = $data['type'] = $this->input->post('type');

$last_id_value = $this->Grn_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['grn_no'] = date("Y").'/'.date('m').'/GRN001';
    }
    else
    {
      $lno = $last_id_value->grn_no;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      //$ono = $ord['order_no'] = date("Y").'/'.date('m').'/SO'.$nval;
      $data['grn_no'] = date("Y").'/'.date('m').'/GRN'.$nval;
    }

$result = $this->Grn_model->create_grn($data);
    if ($result) {
      $last_id_value = $this->Grn_model->last_id();
      $last_value=$last_id_value->grn_id;
      $data1['grn_id'] = $last_value;
      if($type=='raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $stk = explode(",",implode(",",$this->input->post('net_weight')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $subcount = count($this->input->post('rawmaterial_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($pid[$i] != 0){
              $data1['rawmaterial_id'] = $pid[$i];
              $data1['net_weight'] = $stk[$i];
              $data1['quantity'] = $qty[$i];
              $this->Grn_model->create_grn_product($data1);
            }
          }
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('product_id')));
          $stk = explode(",",implode(",",$this->input->post('prnet_weight')));
          $qty = explode(",",implode(",",$this->input->post('prquantity')));
          $subcount = count($this->input->post('product_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($pid[$i] != 0){
              $data1['product_id'] = $pid[$i];
              $data1['net_weight'] = $stk[$i];
              $data1['quantity'] = $qty[$i];
              $this->Grn_model->create_grn_product_by_product($data1);
            }
          }
        }
      }
      $this->session->set_flashdata('add_success', 'GRN has been added successfully.');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Something Went Wrong.');
    }
    redirect('/grn');
  }

public function grn_view($id)
  {
    $pod = $data['grn_details'] = $this->Grn_model->get_grn_by_id($id);
    if($pod->type=='raw material')
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_id($id);
    else
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_product_id($id);
    $this->load->view('grn/grn_view',$data);
  }

public function grn_delete()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('grn/grn_delete',$data);
  }

public function grnDelete(){ 
    $bid=$_POST['field'];
    $result = $this->Grn_model->grn_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'GRN has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function grn_edit($id)
  {
    //$data['location_list'] = $this->Grn_model->get_active_location();

if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Grn_model->get_active_location();
    else
      $data['location_list'] = $this->Grn_model->get_location_by_comp_id($_SESSION['company_id']);

$data['rawmaterial_list'] = $this->Grn_model->get_active_rawmaterials();
    $data['purchase_product_list'] = $this->Grn_model->get_active_purchase_product_list();

$pod = $data['grn_details'] = $this->Grn_model->get_grn_by_id($id);
    if($pod->type=='raw material')
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_id($id);
    else
      $data['grn_products'] = $this->Grn_model->get_grn_product_by_product_id($id);

$this->load->view('grn/grn_edit',$data);
  }

public function update_grn()
  {
    $grn_id = $data['grn_id'] = $this->input->post('grn_id');
    $lid = $data['location_id']=$this->input->post('location_id');
    $data['receipt_date_time']=$this->input->post('receipt_date_time'); 
    $data['transport_name']=$this->input->post('transport_name');
    $data['lr_no']=$this->input->post('lr_no');
    $data['no_of_bundles'] = $this->input->post('no_of_bundles');
    $data['remarks'] = $this->input->post('remarks');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $type = $data['type'] = $this->input->post('type');

$result = $this->Grn_model->update_grn($data);
    if ($result) {
     $this->Grn_model->delete_grn_product_by_id($grn_id);
      $data1['grn_id'] = $grn_id;
      if($type=='raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $stk = explode(",",implode(",",$this->input->post('net_weight')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));
          $subcount = count($this->input->post('rawmaterial_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($pid[$i] != 0){
              $data1['rawmaterial_id'] = $pid[$i];
              $data1['net_weight'] = $stk[$i];
              $data1['quantity'] = $qty[$i];
              $this->Grn_model->create_grn_product($data1);
            }
          }
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('product_id')));
          $stk = explode(",",implode(",",$this->input->post('prnet_weight')));
          $qty = explode(",",implode(",",$this->input->post('prquantity')));
          $subcount = count($this->input->post('product_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($pid[$i] != 0){
              $data1['product_id'] = $pid[$i];
              $data1['net_weight'] = $stk[$i];
              $data1['quantity'] = $qty[$i];
              $this->Grn_model->create_grn_product_by_product($data1);
            }
          }
        }
      }
      $this->session->set_flashdata('add_success', 'GRN has been added successfully.');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Something Went Wrong.');
    }
    redirect('/grn');
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Grn.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation