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: Purchaseorder.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Purchaseorder extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Purchaseorder_model'));
    $this->load->model(array('Quotation_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', 'Purchase Order');
  }

public function purchaseorder_export()
  {
    $purosearch_change = isset($_SESSION['purosearch_change'])?$_SESSION['purosearch_change']:'';
    $vendorchange = isset($_SESSION['purofiltervendor'])?$_SESSION['purofiltervendor']:'all';
    $locationchange = isset($_SESSION['purofilterlocation'])?$_SESSION['purofilterlocation']:'all';
    $statuschange = isset($_SESSION['purofilterstatus'])?$_SESSION['purofilterstatus']:'all';

if ($purosearch_change != '') {
      $sc = 'AND (po.purchase_order_no LIKE "%'.$purosearch_change.'%" OR v.vendor_name LIKE "%'.$purosearch_change.'%" OR l.location_name LIKE "%'.$purosearch_change.'%")';
    }
    else {
      $sc = '';
    }
    if($vendorchange!='all'){
      $ven = 'AND v.vendor_id='.$vendorchange;
    }
    else{
      $ven = '';
    }
    if($locationchange!='all'){
      $lcn = 'AND l.location_id='.$locationchange;
    }
    else{
      $lcn = '';
    }
    if($statuschange!='all'){
      $posts = 'AND po.status='.$statuschange;
    }
    else{
      $posts = '';
    }

if($_SESSION['company_id']==0)
    {
      $compId = '';
      if($_SESSION['role_id']==1)
      {
        $issu = '';
      }
      else
      {
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND po.created_by='.$_SESSION['user_id'];
        }
        else
        {
          $issu = '';
        }
      }
    }
    else
    {
      $compId = 'AND l.location_id='.$_SESSION['company_id'];
      if($_SESSION['is_super_user']==0)
      {
        $issu = 'AND po.created_by='.$_SESSION['user_id'];
      }
      else
      {
        $issu = '';
      }
    }

$purchaseorder_list = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 $lcn $ven $compId $issu $sc $posts ORDER BY po.purchase_order_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', 'Purchase Order No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Purchase No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Vendor');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Location');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Status');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($purchaseorder_list as $u_list ) {

$pur_list = $this->Purchaseorder_model->get_purchase_by_poid($u_list['purchase_order_id']);
      if(count($pur_list)>0)
        $purno = $pur_list->purchase_no;
      else
        $purno = '';

if($u_list['status']==0)
        $sts='Pending';
      else if($u_list['status']==1)
        $sts='Partialy Received';
      else
        $sts='Received';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['purchase_order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $purno);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $u_list['vendor_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, date_format(date_create($u_list['purchase_order_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $sts);

$i++;
    }

$filename='Purchase_Order.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()
  { 
    $config = array();
    $config["base_url"] = base_url() . "purchaseorder";
    $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'];

$data['vendor_list'] = $this->Purchaseorder_model->get_active_vendor();
    //$data['location_list'] = $this->Purchaseorder_model->get_active_location();
    if($_SESSION['company_id']==0){
      $data['location_list'] = $this->Quotation_model->get_location();
    }
    else{
      $data['location_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);
    }

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['purosearch_change']) || isset($_SESSION['purofiltervendor']) || isset($_SESSION['purofilterlocation']) || isset($_SESSION['purofilterstatus']))))
    {
      $vendorchange = $this->input->post('filtervendor');
      $locationchange = $this->input->post('filterlocation');
      // $this->session->set_userdata('purosearch_change', $this->input->post('puro_search')!=''?$this->input->post('puro_search'):$_SESSION['purosearch_change']);
      $this->session->set_userdata('purosearch_change', $this->input->post('puro_search'));
      $this->session->set_userdata('purofiltervendor', $this->input->post('filtervendor')!=''?$this->input->post('filtervendor'):$_SESSION['purofiltervendor']);
      $this->session->set_userdata('purofilterlocation', $this->input->post('filterlocation')!=''?$this->input->post('filterlocation'):$_SESSION['purofilterlocation']);
      $this->session->set_userdata('purofilterstatus', $this->input->post('pofilterstatus')!=''?$this->input->post('pofilterstatus'):$_SESSION['purofilterstatus']);

$purosearch_change = isset($_SESSION['purosearch_change'])?$_SESSION['purosearch_change']:$this->input->post('puro_search');
      $vendorchange = isset($_SESSION['purofiltervendor'])?$_SESSION['purofiltervendor']:$this->input->post('filtervendor');
      $locationchange = isset($_SESSION['purofilterlocation'])?$_SESSION['purofilterlocation']:$this->input->post('filterlocation');
      $statuschange = isset($_SESSION['purofilterstatus'])?$_SESSION['purofilterstatus']:$this->input->post('pofilterstatus');

if ($purosearch_change != '') {
        $sc = 'AND (po.purchase_order_no LIKE "%'.$purosearch_change.'%" OR v.vendor_name LIKE "%'.$purosearch_change.'%" OR l.location_name LIKE "%'.$purosearch_change.'%")';
      }
      else {
        $sc = '';
      }
      if($vendorchange!='all'){
        $ven = 'AND v.vendor_id='.$vendorchange;
      }
      else{
        $ven = '';
      }
      if($locationchange!='all'){
        $lcn = 'AND l.location_id='.$locationchange;
      }
      else{
        $lcn = '';
      }
      if($statuschange!='all'){
        $posts = 'AND po.status='.$statuschange;
      }
      else{
        $posts = '';
      }

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND po.created_by='.$_SESSION['user_id'];
          }
          else
          {
            $issu = '';
          }
        }
      }
      else
      {
        $compId = 'AND l.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND po.created_by='.$_SESSION['user_id'];
        }
        else
        {
          $issu = '';
        }
      }

$data['vendorchange'] = $vendorchange;
      $data['locationchange'] = $locationchange;
      $data['purosearch_change'] = $purosearch_change;
      $data['statuschange'] = $statuschange;
      $data['purchaseorder_list_count'] = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 $lcn $ven $compId $issu $sc $posts ORDER BY po.purchase_order_id DESC")->result_array();
      $config['total_rows'] = count($data['purchaseorder_list_count']);

$data['purchaseorder_list'] = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 $lcn $ven $compId $issu $sc $posts ORDER BY po.purchase_order_id DESC LIMIT $page, $perpage")->result_array();
    }
    else
    {
      $data['vendorchange'] = '';
      $data['locationchange'] = '';
      $data['statuschange'] = 'all';
      $data['purosearch_change'] = '';
      $this->session->unset_userdata('purofiltervendor');
      $this->session->unset_userdata('purofilterlocation');
      $this->session->unset_userdata('purosearch_change');
      $this->session->unset_userdata('purofilterstatus');
      //$data['purchaseorder_list'] = $this->Purchaseorder_model->get_purchase_order_list();
      if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1){
          $data['purchaseorder_list_count'] = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 ORDER BY po.purchase_order_id DESC")->result_array();
          $config['total_rows'] = count($data['purchaseorder_list_count']);

$data['purchaseorder_list'] = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 AND po.created_by='".$_SESSION['user_id']."' ORDER BY po.purchase_order_id DESC LIMIT $page, $perpage")->result_array();
          // $data['purchaseorder_list'] = $this->Purchaseorder_model->get_user_purchase_order_list($_SESSION['user_id']);
        }
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        $data['purchaseorder_list_count'] = $this->db->query("SELECT po.*,v.vendor_name,l.location_name FROM `purchase_order` po,vendor v,location l WHERE po.vendor_id = v.vendor_id AND po.location_id = l.location_id AND po.status!=5 AND po.created_by='".$_SESSION['user_id']."' ORDER BY po.purchase_order_id DESC")->result_array();
          $config['total_rows'] = count($data['purchaseorder_list_count']);

public function purchaseorder_add()
  {
    $data['rawmaterial_list'] = $this->Purchaseorder_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchaseorder_model->get_active_vendor();
    //$data['location_list'] = $this->Purchaseorder_model->get_active_location();
    $data['purchase_product_list'] = $this->Purchaseorder_model->get_active_purchase_product_list();
    if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Quotation_model->get_location();
    else
      $data['location_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);
    $this->load->view('purchaseorder/purchaseorder_add',$data);
  }

public function getRawMaterialDetails()
  {
    $rm_id = $_POST['rm_id'];
    $rmDetails = $this->Purchaseorder_model->get_rawmaterial_by_id($rm_id);
    echo $rmDetails->rawmaterial_gsm.'|'.$rmDetails->rawmaterial_color.'|'.$rmDetails->width;
  }

public function getcompanyproduct()
  {
    $cid = $_POST['cid'];
    if($cid!='')
    {
      $cprod = $this->Purchaseorder_model->get_product_by_company_id($cid);
      if(count($cprod)>0)
      {
        $st = '<option value="">Select Product</option>';
        foreach($cprod as $cp)
        {
          $st.='<option value="'.$cp['product_id'].'">'.$cp['product_name'].'</option>';
        }
      }
    }
    else
    {
      $st = '<option value="">Select Product</option>';
    }
    echo $st;
  }

public function create_purchaseorder()
  {
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_order_date'));
    $data['purchase_order_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['location_id']=$this->input->post('location_id');

$last_id_value = $this->Purchaseorder_model->last_id();
    if(count($last_id_value)==0)
    {
      $pno = $data['purchase_order_no'] = date("Y").'/'.date('m').'/PO001';
    }
    else
    {
      $lno = $last_id_value->purchase_order_no;
      $exlno = substr($lno,10);
      $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;
      $pno = $data['purchase_order_no'] = date("Y").'/'.date('m').'/PO'.$nval;
    }
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $type = $data['type'] = $this->input->post('type');

$result = $this->Purchaseorder_model->create_purchaseorder($data);

if($result)
    {
      $last_id_value = $this->Purchaseorder_model->last_id();
      $last_value=$last_id_value->count_val;
      $purproduct['purchase_order_id'] = $last_value;
      if($type=='raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $color = explode(",",implode(",",$this->input->post('color')));
          $width = explode(",",implode(",",$this->input->post('width')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));

$subcount = count($this->input->post('rawmaterial_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($rmid[$i] != ''){
              $purproduct['rawmaterial_id'] = $rmid[$i];
              $purproduct['gsm'] = $gsm[$i];
              $purproduct['color'] = $color[$i];
              $purproduct['width'] = $width[$i];
              $purproduct['quantity'] = $qty[$i];
              $this->Purchaseorder_model->create_purchaseorder_product($purproduct);
            }
          }
          
        }
      }
      else
      {
        if($this->input->post('product_id')!='')
        {
          $pid = explode(",",implode(",",$this->input->post('product_id')));
          $qty = explode(",",implode(",",$this->input->post('prquantity')));

$subcount = count($this->input->post('product_id')); 
          for($i=0;$i<$subcount;$i++)
          {
            if($pid[$i] != ''){
              $purproduct['product_id'] = $pid[$i];
              $purproduct['quantity'] = $qty[$i];
              $this->Purchaseorder_model->create_purchaseorder_product_by_product($purproduct);
            }
          }
          
        }
      }

$this->session->set_flashdata('add_success', 'Purchase Order has been added successfully.');
      redirect('/purchaseorder');
    }
  }

public function purchaseorder_view($id)
  {
    $pod = $data['purchase_order_details'] = $this->Purchaseorder_model->get_purchase_order_by_id($id);
    if($pod->type=='raw material')
      $data['purchase_order_product'] = $this->Purchaseorder_model->get_purchase_order_product_by_id($id);
    else
      $data['purchase_order_product'] = $this->Purchaseorder_model->get_purchase_order_product_by_product_id($id);
    $this->load->view('purchaseorder/purchaseorder_view',$data);
  }

public function purchaseorder_edit($id)
  {    
    /*$data['rawmaterial_list'] = $this->Purchaseorder_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchaseorder_model->get_active_vendor();
    $data['location_list'] = $this->Purchaseorder_model->get_active_location();*/
    $data['purchase_product_list'] = $this->Purchaseorder_model->get_active_purchase_product_list();

$data['rawmaterial_list'] = $this->Purchaseorder_model->get_active_rawmaterials();
    $data['vendor_list'] = $this->Purchaseorder_model->get_active_vendor();
    $data['location_list'] = $this->Purchaseorder_model->get_active_location();
    $podet = $data['purchase_order_details'] = $this->Purchaseorder_model->get_purchase_order_by_id($id);
    if($podet->type == 'raw material')
      $data['purchase_order_product'] = $this->Purchaseorder_model->get_purchase_order_product_by_id($id);
    else
      $data['purchase_order_product'] = $this->Purchaseorder_model->get_purchase_order_product_by_product_id($id);
    $this->load->view('purchaseorder/purchaseorder_edit',$data);
  }

public function update_purchaseorder()
  {
    $pid = $data['purchase_order_id']=$this->input->post('purchase_order_id');
    $data['vendor_id']=$this->input->post('vendor_id');
    $ddt = explode('/', $this->input->post('purchase_order_date'));
    $data['purchase_order_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['location_id']=$this->input->post('location_id');
    $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->Purchaseorder_model->update_purchaseorder($data);

if($result)
    {
      $this->Purchaseorder_model->delete_purchase_order_product_by_id($pid);
      $purproduct['purchase_order_id'] = $pid;
      if($type=='raw material')
      {
        if($this->input->post('rawmaterial_id')!='')
        {
          $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
          $gsm = explode(",",implode(",",$this->input->post('gsm')));
          $color = explode(",",implode(",",$this->input->post('color')));
          $width = explode(",",implode(",",$this->input->post('width')));
          $qty = explode(",",implode(",",$this->input->post('quantity')));

$this->session->set_flashdata('add_success', 'Purchase Order has been updated successfully.');
      redirect('/purchaseorder');
    }
  }

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

public function puchaseorderComplete(){ 
    $bid=$_POST['field'];
    $result = $this->Purchaseorder_model->purchase_order_complete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Purchase Order has been Completed successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

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

public function puchaseorderDelete(){ 
    $bid=$_POST['field'];
    $result = $this->Purchaseorder_model->purchase_order_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Purchase Order has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Purchaseorder.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation