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: Order-new.php

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

require_once 'dompdf/autoload.inc.php';

/* reference the Dompdf namespace */

use Dompdf\Dompdf;

class Order extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Order_model'));
    $this->load->model(array('Customer_model'));
    $this->load->model(array('Workorder_model'));
    $this->load->model(array('Issueregister_model'));
    $this->load->model(array('Worklog_model'));
    $this->load->model(array('Deliverychallan_model'));
    $this->load->model(array('Invoice_model'));
    $this->load->model(array('Producttype_model'));
    $this->load->model(array('Application_model'));
    $this->load->model(array('Product_model'));
    $this->load->model(array('Deliverypermission_model'));
    $this->load->model(array('Reference_model'));
    $this->load->model(array('Paymentterm_model'));
    $this->load->model(array('Deliveryterm_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
            $data = array();
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Sale Order');
  }

/*function aes128Decrypt($key, $data) {
$data = base64_decode($data);
if(16 !== strlen($key)) $key = hash('MD5', $key, true);
$data = mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $key, $data, MCRYPT_MODE_CBC, str_repeat("\0", 16));
$padding = ord($data[strlen($data) - 1]); 
return substr($data, 0, -$padding); 
}*/

public function getcustomerlist(){
    // POST dataHi
    $postData = $this->input->post();

// Get data
    $data = $this->Order_model->getcustomerlist($postData);

echo json_encode($data);
  }

public function order_export()
  {
    $typchange = isset($_SESSION['ord_otypechange'])?$_SESSION['ord_otypechange']:'';
    $applichange = isset($_SESSION['ord_applichange'])?$_SESSION['ord_applichange']:'all';
    $refchange = isset($_SESSION['ord_refchange'])?$_SESSION['ord_refchange']:'all';
    $locchange = isset($_SESSION['ord_locchange'])?$_SESSION['ord_locchange']:'all';
    $unitchange = isset($_SESSION['ord_unitchange'])?$_SESSION['ord_unitchange']:'all';
    $schange = isset($_SESSION['ord_schange'])?$_SESSION['ord_schange']:'all';
    $dtrange = isset($_SESSION['ord_dtrange'])?$_SESSION['ord_dtrange']:'';
    $statuschange = isset($_SESSION['ord_statuschange'])?$_SESSION['ord_statuschange']:'all';

if($osearch_change!='') {
      $sc = 'AND (o.order_no LIKE "%'.$osearch_change.'%" OR au.displayname LIKE "%'.$osearch_change.'%")';
    }
    else {
      $sc = '';
    }

if($typchange!='')
      $ct = 'AND o.customer_id='.$typchange;
    else
      $ct = '';

if($applichange!='all')
      $app = 'AND o.application_id='.$applichange;
    else
      $app = '';

if($refchange!='all')
      $ref = 'AND o.reference_id='.$refchange;
    else
      $ref = '';

if($locchange!='all')
      $loc = 'AND o.location_id='.$locchange;
    else
      $loc = '';

if($unitchange!='all')
      $unit = 'AND o.prod_unit="'.$unitchange.'"';
    else
      $unit = '';

if($statuschange!='all')
      $status = 'AND o.status="'.$statuschange.'"';
    else
      $status = '';

if($schange == 'all'){
      $schange='all';
    }

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

if($schange == 'all')
    {      
      if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31'; 
        }
        else
        {
          $fdate = '2019-04-01';
          $tdate = date('Y-m-d');
        }
      }
      else
      {
        $fdate = '2019-04-01';
        $tdate = date('Y-m-d');
      }

$data['drnge'] = '';
      $order_list = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_date>='$fdate' AND o.order_date<='$tdate' $ct $app $sc $ref $loc $unit $compId $issu $status GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    }
    elseif($schange == 'today')
    {
      $order_list = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $sc $ref $loc $unit $compId $issu $status and STR_TO_DATE(order_date, '%Y-%m-%d') = CURDATE() GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    }
    else if($schange == 'thisweek')
    {
      $order_list = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $sc $ref $loc $unit $compId $issu $status and YEARWEEK(STR_TO_DATE(order_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    }      
    else if($schange == 'thismonth')
    {
      $order_list = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id $ct $app $sc $ref $loc $unit $compId $issu $status and MONTH(STR_TO_DATE(order_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(order_date, '%Y-%m-%d')) = YEAR(CURDATE()) GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    }
    else if($schange == 'thisyear')
    {
      $finstart = $_SESSION['finstart'];
      $finend = $_SESSION['finend'];
      $order_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id $ct $app $sc $ref $loc $unit $compId $issu $status and  STR_TO_DATE(order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    }
    else
    {
      $dt_filt = $dtrange;
      $dr = explode(' - ', $dt_filt);

$fd = explode('/', $dr[0]);
      $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
      $tdate = $td[2].'-'.$td[0].'-'.$td[1];
      $order_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id $ct $app $sc $ref $loc $unit $compId $issu $status and  STR_TO_DATE(order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.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', 'SO No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'SO Date');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Customer / Dealer Info');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Stock Location');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Incharge');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Grand Total');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Last Updated On');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Last Updated By');
    $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('I1', 'Stage');
    $objPHPExcel->getActiveSheet()->getStyle('I1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($order_list as $u_list ) { 
      if($u_list['customer_id']!=0)
      {
        $cusDetails = $this->Order_model->get_customer_contact_details($u_list['customer_id']);

$customerDetails = $this->Order_model->get_customer_view_by_id($u_list['customer_id']);
        $cusfdet = $customerDetails->customer_code.' - '.$customerDetails->customer_name.' - '.$cusDetails->phone_no;
      }
      else
      {
        $customerDetails = $this->Order_model->get_dealer_view_by_id($u_list['dealer_id']);
        //$cusdetails = $cusdet;
        $cusfdet = $customerDetails->dealer_no.' - '.$customerDetails->dealer_name.' - '.$customerDetails->phone_no;
      }

if($u_list['status']==0){
        $sts = 'Open';
        $row_color = '';
        $wocount = '';
      }else{
        $wolist = $this->Order_model->get_work_order_count_by_order_id($u_list['order_id']);
        if(count($wolist)>1)
          $wocount = count($wolist);
        else
          $wocount = '';

if($u_list['status']==1){
          $sts = 'Work Order';
          $row_color = '';
        }else if($u_list['status']==2){
          $sts = 'Issue Register';
          $row_color = '';
        }else if($u_list['status']==3){
          $sts = 'Work Log';
          $row_color = '';
        }else if($u_list['status']==4){
          $sts = 'Delivery Challan';
          $row_color = '';
        }else if($u_list['status']==5){
          $sts = 'Invoice';
          $row_color = '';
        }else if($u_list['status']==15){
          $sts = 'Completed';
          $row_color = '#e6ffe6';
        }else{
          $sts = 'Short Close';
          $row_color = '#ffe6e6';
        }
      }

if($u_list['modified_by']==0)
      {
        $lfdate = $u_list['created_on'];
        $lfby = $u_list['created_by'];
      }
      else
      {
        $lfdate = $u_list['modified_on'];
        $lfby = $u_list['modified_by'];
      }

$lfbydet = $this->Order_model->get_admin_user_by_id($lfby);
      $lfbyname = $lfbydet->displayname;

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, date_format(date_create($u_list['order_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $cusfdet);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['incharge']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($u_list['grand_total'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, date_format(date_create($u_list['created_on']),$g_settings->date_format.' H:i:s'));
      $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $u_list['displayname']);
      $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $sts);

$i++;
    }

$filename='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()
  {

$data['customer_list'] = $this->Order_model->get_customer_list();
    $data['application'] = $this->Order_model->get_active_application();
    $data['reference'] = $this->Order_model->get_active_reference();
    //$data['location'] = $this->Order_model->get_location();

// print_r($data['customer_list']);
// print_r($data['application']);
// print_r($data['reference']);
    if($_SESSION['company_id']==0)
      $data['location'] = $this->Order_model->get_location();
    else
      $data['location'] = $this->Order_model->get_location_by_comp_id($_SESSION['company_id']);

/*$_SESSION['fin2cstart'] = $_SESSION['fin2ostart'];
    $_SESSION['fin2cend'] = $_SESSION['fin2oend'];*/
    //$data['order_list'] = $this->Order_model->get_order_list();

$config = array();
    $config["base_url"] = base_url() . "order";
    $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'];
    // $typchange = '';
    // $applichange = '';
    // $refchange = '';
    // $locchange = '';
    // $unitchange = '';
    // $schange = '';
    // $dtrange = '';

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['ord_otypechange']) || isset($_SESSION['ord_applichange']) || isset($_SESSION['ord_refchange']) || isset($_SESSION['ord_locchange']) || isset($_SESSION['ord_unitchange']) || isset($_SESSION['ord_statuschange']) || isset($_SESSION['ord_schange']) || isset($_SESSION['ord_dtrange']))))
    {
      $this->session->set_userdata('ord_ocusname', $this->input->post('ofilterctype_name')!=''?$this->input->post('ofilterctype_name'):'');
      $this->session->set_userdata('ord_otypechange', $this->input->post('ofilterctype_name')!=''?$this->input->post('ofilterctype'):'');
      $this->session->set_userdata('ord_applichange', $this->input->post('filterappli')!=''?$this->input->post('filterappli'):$_SESSION['ord_applichange']);
      $this->session->set_userdata('ord_refchange', $this->input->post('filterref')!=''?$this->input->post('filterref'):$_SESSION['ord_refchange']);
      $this->session->set_userdata('ord_locchange', $this->input->post('filterloc')!=''?$this->input->post('filterloc'):$_SESSION['ord_locchange']);
      $this->session->set_userdata('ord_unitchange', $this->input->post('filterunit')!=''?$this->input->post('filterunit'):$_SESSION['ord_unitchange']);
      $this->session->set_userdata('ord_schange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['ord_schange']);
      $this->session->set_userdata('ord_dtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['ord_dtrange']);
      $this->session->set_userdata('ord_statuschange', $this->input->post('filterstatus')!=''?$this->input->post('filterstatus'):$_SESSION['ord_statuschange']);

$this->session->set_userdata('ord_osearch_change', $this->input->post('ord_search'));

// $this->session->set_userdata('otypechange', $this->input->post('ofilterctype'));
      // $this->session->set_userdata('applichange', $this->input->post('filterappli'));
      // $this->session->set_userdata('refchange', $this->input->post('filterref'));
      // $this->session->set_userdata('locchange', $this->input->post('filterloc'));
      // $this->session->set_userdata('unitchange', $this->input->post('filterunit'));
      // $this->session->set_userdata('schange', $this->input->post('searchChange'));
      // $this->session->set_userdata('dtrange', $this->input->post('dtrange'));
      $typcusname = isset($_SESSION['ord_ocusname'])?$_SESSION['ord_ocusname']:$this->input->post('ofilterctype_name');
      $typchange = isset($_SESSION['ord_otypechange'])?$_SESSION['ord_otypechange']:$this->input->post('ofilterctype');
      //$catchange = $this->input->post('filterccat');
      $applichange = isset($_SESSION['ord_applichange'])?$_SESSION['ord_applichange']:$this->input->post('filterappli');
      $refchange = isset($_SESSION['ord_refchange'])?$_SESSION['ord_refchange']:$this->input->post('filterref');
      $locchange = isset($_SESSION['ord_locchange'])?$_SESSION['ord_locchange']:$this->input->post('filterloc');
      $unitchange = isset($_SESSION['ord_unitchange'])?$_SESSION['ord_unitchange']:$this->input->post('filterunit');
      $statuschange = isset($_SESSION['ord_statuschange'])?$_SESSION['ord_statuschange']:$this->input->post('filterstatus');

$osearch_change = isset($_SESSION['ord_osearch_change'])?$_SESSION['ord_osearch_change']:$this->input->post('ord_search');

if($osearch_change!='') {
        $sc = 'AND (o.order_no LIKE "%'.$osearch_change.'%" OR au.displayname LIKE "%'.$osearch_change.'%")';
      }
      else {
        $sc = '';
      }

if($typchange!='')
        $ct = 'AND o.customer_id='.$typchange;
      else
        $ct = '';

if($applichange!='all')
        $app = 'AND o.application_id='.$applichange;
      else
        $app = '';

if($refchange!='all')
        $ref = 'AND o.reference_id='.$refchange;
      else
        $ref = '';

if($locchange!='all')
        $loc = 'AND o.location_id='.$locchange;
      else
        $loc = '';

if($unitchange!='all')
        $unit = 'AND o.prod_unit="'.$unitchange.'"';
      else
        $unit = '';

if($statuschange!='all')
        $status = 'AND o.status="'.$statuschange.'"';
      else
        $status = '';

$btn = $this->input->post('goButton');
      $schange = isset($_SESSION['ord_schange'])?$_SESSION['ord_schange']:$this->input->post('searchChange');
      //echo $schange;
      $dtrange = isset($_SESSION['ord_dtrange'])?$_SESSION['ord_dtrange']:$this->input->post('dtrange');

//if($btn=='Go')
        //$schange='';
      /*if($btn=='')
        $dtrange='';*/

if($btn=='')
      {
        $dtrange='';
      }
      if($schange == 'all'){
        $schange='all';
      }

$data['typchange'] = $typchange;
      $data['typcusname'] = $typcusname;
      $data['applichange'] = $applichange;
      $data['refchange'] = $refchange;
      $data['locchange'] = $locchange;
      $data['unitchange'] = $unitchange;
      $data['statuschange'] = $statuschange;
      //$data['catchange'] = $catchange;

// echo '<pre>';
// print_r($data['typchange']);
// print_r($data['typcusname']);
// print_r($data['applichange']);
// print_r($data['refchange']);
// print_r($data['locchange']);
// print_r($data['unitchange']);
// print_r($data['statuschange']);
// echo 'Sigma';
// print_r($data);
// exit;

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

if($schange == 'all')
      {
        /*$fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');*/
        
        if(isset($_SESSION['fin2cstart']))
        {
          if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
          {
            $fdate = $_SESSION['fin2cstart'].'-04-01';
            $tdate = $_SESSION['fin2cend'].'-03-31'; 
          }
          else
          {
            $fdate = '2019-04-01';
            $tdate = date('Y-m-d');
          }
        }
        else
        {
          $fdate = '2019-04-01';
          $tdate = date('Y-m-d');
        }

$data['drnge'] = '';
        $data['clist'] = $this->db->query("SELECT o.*,l.location_name,au.displayname FROM `order` o,location l,admin_users au WHERE o.location_id = l.location_id AND o.created_by = au.id AND o.order_date>='$fdate' AND o.order_date<='$tdate' $ct $app $sc $ref $loc $unit $compId $issu $status GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();