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

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

class Workorder extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Workorder_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Quotation_model'));
    $this->load->model(array('Issueregister_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', 'Work Order');
  }

public function workorder_export()
  {
    $dtrange = isset($_SESSION['wodtrange'])?$_SESSION['wodtrange']:'';
    $schange = isset($_SESSION['woschange'])?$_SESSION['woschange']:'all';
    $wosearch_change = isset($_SESSION['wosearch_change'])?$_SESSION['wosearch_change']:'';
    $locchange = isset($_SESSION['wofilterloc'])?$_SESSION['wofilterloc']:'all';
    $typchange = isset($_SESSION['wofilterctype'])?$_SESSION['wofilterctype']:'';
    $unitchange = isset($_SESSION['wofilterunit'])?$_SESSION['wofilterunit']:'all';
    $statuschange = isset($_SESSION['wofilterstatus'])?$_SESSION['wofilterstatus']:'all';

if ($wosearch_change != '') {
      $sc = 'AND (wo.work_order_no LIKE "%'.$wosearch_change.'%" OR c.customer_name LIKE "%'.$wosearch_change.'%" OR o.order_no LIKE "%'.$wosearch_change.'%")';
    }
    else {
      $sc = '';
    }

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

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

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

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

if($dtrange!='')
    {
      $btn = 'Go';
    }

if($schange == 'all'){
      $schange='all';
    }
    $data['locchange'] = $locchange;

if($_SESSION['company_id']==0)
    {
      $compId = '';
      if($_SESSION['role_id']==1)
      {
        $issu = '';          
        $data['order_list'] = $this->Workorder_model->get_open_order_list();
      }
      else
      {
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND wl.created_by='.$_SESSION['user_id'];
          $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          
        $data['order_list'] = $this->Workorder_model->get_open_order_list();
        }
      }
    }
    else
    {
      $compId = 'AND o.location_id='.$_SESSION['company_id'];
      if($_SESSION['is_super_user']==0)
      {
        $issu = 'AND wl.created_by='.$_SESSION['user_id'];
        $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
      }
      else
      {
        $issu = '';
        $data['order_list'] = $this->Workorder_model->get_super_user_open_order_list($_SESSION['company_id']);
      }
    }

if($schange == 'all')
    {
      $data['drnge'] = '';
      
      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');
      }

$workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $compId $issu $loc $ct $unit $sc $status ORDER BY work_order_id DESC")->result_array();
    }
    elseif($schange == 'today')
    {
      $workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') = CURDATE() ORDER BY work_order_id DESC ")->result_array();
    }
    else if($schange == 'thisweek')
    {
      $workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and YEARWEEK(STR_TO_DATE(wo.work_order_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY work_order_id DESC")->result_array();
    }      
    else if($schange == 'thismonth')
    {
      $workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and MONTH(STR_TO_DATE(wo.work_order_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(wo.work_order_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY work_order_id DESC")->result_array();
    }
    else if($schange == 'thisyear')
    {
      $finstart = $_SESSION['finstart'];
      $finend = $_SESSION['finend'];
      $workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
    }
    else if($schange == 'thisDate')
    {
      $data['drnge'] = $dtrange;
      $dr = explode(' - ', $dtrange);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
      $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
    }
    else
    {
      $data['drnge'] = $dtrange;
      $dr = explode(' - ', $dtrange);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
      $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$workorder_list = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.delivery_date_time, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.delivery_date_time, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_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', 'Work Order No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Order No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Customer Info');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Incharge');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Delivery Date & Time');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Last Updated On');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Last Updated By');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H1', 'Stage');
    $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($workorder_list as $u_list ) {        
      $cusDetails = $this->Workorder_model->get_customer_contact_details($u_list['customer_id']);
      $customerDetails = $this->Order_model->get_customer_view_by_id($u_list['customer_id']);
      $pno = $cusDetails->phone_no;
      $cusdet = $u_list['customer_name'].' - '.$pno;
      $cusdetails = strlen($cusdet) > 15 ? substr($cusdet,0,15)."..." : $cusdet;
      $cusfdet = $u_list['customer_code'].' - '.$u_list['customer_name'].' - '.$cusDetails->phone_no;

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

$ludet = login_user_details($lmby);
      $lmbyname = $ludet->displayname;

$ddatetime = explode(' ', $u_list['delivery_date_time']);

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

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['work_order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $cusfdet);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['incharge']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, date_format(date_create($ddatetime[0]),$g_settings->date_format).' '.$ddatetime[1]);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, date_format(date_create($lmdate),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $lmbyname);
      $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, $sts);

$i++;
    }

$filename='Workorder.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() . "workorder";
    $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['customer_list'] = $this->Order_model->get_customer_list();

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']);

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['woschange']) || isset($_SESSION['wodtrange']) || isset($_SESSION['wosearch_change']) || isset($_SESSION['wofilterloc']) || isset($_SESSION['wofilterctype']) || isset($_SESSION['wofilterunit']) || isset($_SESSION['wofilterstatus']))))
    {
      $btn = $this->input->post('goButton');
      // $schange = $this->input->post('searchChange');
      // $dtrange = $this->input->post('dtrange');
      // $locchange = $this->input->post('filterloc');
      // $typchange = $this->input->post('filterctype');
      // $unitchange = $this->input->post('filterunit');

$this->session->set_userdata('woschange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['woschange']);
      $this->session->set_userdata('wodtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['wodtrange']);
      //$this->session->set_userdata('wosearch_change', $this->input->post('wo_search')!=''?$this->input->post('wo_search'):$_SESSION['wosearch_change']);
      $this->session->set_userdata('wosearch_change', $this->input->post('wo_search'));
      $this->session->set_userdata('wofilterloc', $this->input->post('filterloc')!=''?$this->input->post('filterloc'):$_SESSION['wofilterloc']);
      $this->session->set_userdata('wofilterctypename', $this->input->post('filterctype_name')!=''?$this->input->post('filterctype_name'):'');
      $this->session->set_userdata('wofilterctype', $this->input->post('filterctype_name')!=''?$this->input->post('filterctype'):'');
      $this->session->set_userdata('wofilterunit', $this->input->post('filterunit')!=''?$this->input->post('filterunit'):$_SESSION['wofilterunit']);
      $this->session->set_userdata('wofilterstatus', $this->input->post('filterstatus')!=''?$this->input->post('filterstatus'):$_SESSION['wofilterstatus']);

$dtrange = isset($_SESSION['wodtrange'])?$_SESSION['wodtrange']:$this->input->post('dtrange');
      $schange = isset($_SESSION['woschange'])?$_SESSION['woschange']:$this->input->post('searchChange');
      $wosearch_change = isset($_SESSION['wosearch_change'])?$_SESSION['wosearch_change']:$this->input->post('wo_search');
      $locchange = isset($_SESSION['wofilterloc'])?$_SESSION['wofilterloc']:$this->input->post('filterloc');
      $typcusname = isset($_SESSION['wofilterctypename'])?$_SESSION['wofilterctypename']:$this->input->post('filterctype_name');
      $typchange = isset($_SESSION['wofilterctype'])?$_SESSION['wofilterctype']:$this->input->post('filterctype');
      $unitchange = isset($_SESSION['wofilterunit'])?$_SESSION['wofilterunit']:$this->input->post('filterunit');
      $statuschange = isset($_SESSION['wofilterstatus'])?$_SESSION['wofilterstatus']:$this->input->post('filterstatus');

if ($wosearch_change != '') {
        $sc = 'AND (wo.work_order_no LIKE "%'.$wosearch_change.'%" OR c.customer_name LIKE "%'.$wosearch_change.'%" OR o.order_no LIKE "%'.$wosearch_change.'%")';
      }
      else {
        $sc = '';
      }

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

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

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

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

if($dtrange!='')
      {
        $btn = 'Go';
      }

// if($btn=='')
      // {
      //   $dtrange='';
      // }
      if($schange == 'all'){
        $schange='all';
      }
      $data['locchange'] = $locchange;

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';          
          $data['order_list'] = $this->Workorder_model->get_open_order_list();
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND wl.created_by='.$_SESSION['user_id'];
            $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
          }
          else
          {
            $issu = '';
            
          $data['order_list'] = $this->Workorder_model->get_open_order_list();
          }
        }
      }
      else
      {
        $compId = 'AND o.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND wl.created_by='.$_SESSION['user_id'];
          $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['order_list'] = $this->Workorder_model->get_super_user_open_order_list($_SESSION['company_id']);
        }
      }

if($schange == 'all')
      {
        $data['drnge'] = '';
        /*$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');
        }

//SELECT wo.*,o.order_no,o.customer_id,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id ORDER BY work_order_id DESC

$data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $compId $issu $loc $ct $unit $sc $status ORDER BY work_order_id DESC")->result_array();

$config["total_rows"] = count($data['wo_list_count']);

$data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' $compId $issu $loc $ct $unit $sc $status ORDER BY work_order_id DESC Limit $page, $perpage")->result_array();
      }
      elseif($schange == 'today')
      {
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') = CURDATE() ORDER BY work_order_id DESC ")->result_array();

$config["total_rows"] = count($data['wo_list_count']);

$data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and MONTH(STR_TO_DATE(wo.work_order_date, '%Y-%m-%d')) = MONTH(CURDATE()) ORDER BY work_order_id DESC Limit $page, $perpage")->result_array();
      }
      else if($schange == 'thisyear')
      {
        //$data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc and YEAR(STR_TO_DATE(wo.work_order_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY work_order_id DESC")->result_array();
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
        $config["total_rows"] = count($data['wo_list_count']);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        // echo "SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_order_id DESC";
        // die();
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
        $config["total_rows"] = count($data['wo_list_count']);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.delivery_date_time, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.delivery_date_time, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
        $config["total_rows"] = count($data['wo_list_count']);

if($this->input->post('top_fin_year')!='')
      {
        $topfin = explode('-', $this->input->post('top_fin_year'));
        $_SESSION['fin2cstart'] = $topfin[0];
        $_SESSION['fin2cend'] = $topfin[1];

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');
        }
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id $compId $issu $loc $ct $unit $sc $status and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(wo.work_order_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY work_order_id DESC")->result_array();
        $config["total_rows"] = count($data['wo_list_count']);

$data['purchasesearch'] = $schange;
      $data['wosearch_change'] = $wosearch_change;
      $data['drnge'] = $dtrange;
      $data['typchange'] = $typchange;
      $data['typcusname'] = $typcusname;
      $data['unitchange'] = $unitchange;
      $data['statuschange'] = $statuschange;
    }
    else
    {
      $this->session->unset_userdata('woschange');
      $this->session->unset_userdata('wodtrange');
      $this->session->unset_userdata('wosearch_change');
      $this->session->unset_userdata('wofilterloc');
      $this->session->unset_userdata('wofilterctype');
      $this->session->unset_userdata('wofilterunit');
      $this->session->unset_userdata('wofilterstatus');
      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['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['locchange'] = '';
      $data['typchange'] = '';
      $data['typcusname'] = '';
      $data['unitchange'] = '';
      $data['statuschange'] = 'all';

/*$fdate = date('Y-m-d', strtotime('-7 days'));
      $tdate = date('Y-m-d');*/
      $uid = $_SESSION['user_id'];
      if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        {
          $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' ORDER BY work_order_id DESC")->result_array();
          $config["total_rows"] = count($data['wo_list_count']);
          // $data['workorder_list'] = $this->Workorder_model->get_work_order_list($fdate,$tdate);
          $data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' ORDER BY work_order_id DESC Limit $page, $perpage")->result_array();
          $data['order_list'] = $this->Workorder_model->get_open_order_list();
        }
        else
        {
          $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' AND wo.created_by='$uid' ORDER BY work_order_id DESC")->result_array();
          $config["total_rows"] = count($data['wo_list_count']);

$data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' AND wo.created_by='$uid' ORDER BY work_order_id DESC Limit $page, $perpage")->result_array();
          // $data['workorder_list'] = $this->Workorder_model->get_user_work_order_list($_SESSION['user_id'],$fdate,$tdate);
          $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
        }
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' AND wo.created_by='$uid' ORDER BY work_order_id DESC")->result_array();
          $config["total_rows"] = count($data['wo_list_count']);

$data['workorder_list'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' AND wo.created_by='$uid' ORDER BY work_order_id DESC Limit $page, $perpage")->result_array();
        $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
      }
      else
      {
        $data['wo_list_count'] = $this->db->query("SELECT wo.*,o.order_no,o.customer_id,o.incharge,c.customer_name,c.customer_code FROM work_order wo, `order` o,customer c WHERE o.order_id = wo.order_id AND o.customer_id = c.customer_id AND o.location_id = '".$_SESSION['company_id']."' AND wo.work_order_date>='$fdate' AND wo.work_order_date<='$tdate' ORDER BY work_order_id DESC")->result_array();
          $config["total_rows"] = count($data['wo_list_count']);

$data['workorder_list'] = $this->Workorder_model->get_super_user_work_order_list($_SESSION['company_id'],$fdate,$tdate);
        $data['order_list'] = $this->Workorder_model->get_super_user_open_order_list($_SESSION['company_id']);
      }

}

$this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    $this->load->view('workorder/workorder_list',$data);
  }

public function so_list()
  {
    //$data['order_list'] = $this->Workorder_model->get_open_order_list();
    if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['order_list'] = $this->Workorder_model->get_open_order_list();
      }
      else
      {
        $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['order_list'] = $this->Workorder_model->get_super_user_open_order_list($_SESSION['company_id']);
    }
    $this->load->view('workorder/pending_sale_order',$data);
  }

public function workorder_add()
  {
    //$data['order_list'] = $this->Workorder_model->get_open_order_list();
    
    if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['order_list'] = $this->Workorder_model->get_open_order_list();
      }
      else
      {
        $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['order_list'] = $this->Workorder_model->get_user_open_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['order_list'] = $this->Workorder_model->get_super_user_open_order_list($_SESSION['company_id']);
    }

$this->load->view('workorder/workorder_add',$data);
  }

public function getProduct()
  {
    $pt_id = $_POST['id'];
    $product = $this->Workorder_model->get_pending_wo_order_product_by_id($pt_id);
    $order = $this->Workorder_model->get_order_view_by_id($pt_id);
    $orderprod = $this->Workorder_model->get_order_product_by_id($pt_id);

$qty=0;
    foreach($orderprod as $oprod)
    {
      $qty+=$oprod['quantity'];
    }

if(count($product)>0)
    {
      $st = '<option value="">Select Product</option>';
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'-'.$prod["order_product_id"].'>'.$prod["product_code"].' '.$prod["product_name"].'</option>';
      }
    }
    else
    {
      $st = '<option value="">No Products Available</option>';
    }
    echo $st.'||'.$order->location_id.'||'.str_replace('-', '/', $order->del_date).'||'.$qty;
  }

public function getProductDetails()
  {
    $prod_id = $_POST['prod_id'];
    $pid = explode('-', $prod_id);
    $prod_id = $pid[0];
    $op_id = $pid[1];
    $order_id = $_POST['order_id'];
    $product = $this->Workorder_model->get_order_product_details_by_op_id($prod_id,$order_id,$op_id);

$gsm = $product->rawmaterial_gsm;
    $wfid = $product->weight_formula_id;
    $uom_id = $product->uom_id;
    $widt = $product->width;
    /*if($product->type_id==1)
    {
      $len = $product->pcsl;
      $wid = $product->pcsw;
    }
    else
    {
      $len = $product->cut_size_length;
      $wid = $product->cut_size_width;
    }
    $pgsm='0.'.$gsm;
    if($wfid==1)
    {
      $wit = (($len*$wid)/10.76)*$pgsm;
    }
    else if($wfid==2)
    {
      $wit = ($len*$wid)*$pgsm;
    }
    else
    {
      $wit = (($len*$wid)/1549.44)*$pgsm;
    }*/
    if($product->type_id==1)
    {
      $wit = $product->rawmaterial_quantity;
    }
    else
    {
      $len = $product->cut_size_length;
      $wid = $product->cut_size_width;

$gsmlen = strlen($gsm);

if($gsmlen==1)
        $pgsm = '0.00'.$gsm;
      else if($gsmlen==2)
        $pgsm = '0.0'.$gsm;
      else
        $pgsm='0.'.$gsm;
      /*if($wfid==1)
      {
        $wit = (($len*$wid)/10.76)*$pgsm;
      }
      else if($wfid==2)
      {
        $wit = ($len*$wid)*$pgsm;
      }
      else
      {
        $wit = (($len*$wid)/1549.44)*$pgsm;
      }*/

$ppw = $this->Quotation_model->get_product_price_weight_by_prod_uom_id($prod_id,$uom_id);
      if(count($ppw)>0)
      {
        $wit = $ppw->weight;
        $wit = str_replace('X', '*', $wit);
        $wit = str_replace('WIDTH OF THE TARPAULIN', $widt, $wit);
        $wit = str_replace('L', $len, $wit);
        $wit = str_replace('W', $wid, $wit);
        $wit = str_replace('0.GSM', $pgsm, $wit);
        eval( '$wit = (' . $wit. ');' );
        //$qty = floatval($qty);
        //$price = floatval($price);
        //$rate = $price*$qty;
      }
      else
      {
        //$rate = $rpsf*$qty;
        $wit = 0;
      }
    }
//echo $wit;exit;
    $remqty = $product->quantity - $product->wo_quantity;
    $rmwgt = $wit*$remqty;

echo $product->specification."|".$product->uom."|".$remqty."|".$product->rawmaterial."|".$product->rawmaterial_id."|".round($rmwgt,3)."|".$remqty."|".round($wit,3)."|".$op_id;
  }

public function getworm()
  {
    $rmid = $_POST['rmid'];
    $rmqty = $_POST['rmqty'];
    $location_id = $_POST['location_id'];

$rid = explode(',', $rmid);
    $rqty = explode(',', $rmqty);

/*print_r($rid);
    echo "<br>";
    print_r($rqty);
    echo "<br>";
    asort($rid);
    print_r($rid);
    echo "<br>";*/

$val='';
    $valid=[];
    $valqty=[];
    $vqty=0;
    foreach($rid as $key=>$value)
    {
      if($val!=$value)
      {
        array_push($valid, $value);
        $val=$value;
        $vqty = $rqty[$key];
        array_push($valqty, $vqty);
      }
      else
      {
        $vqty+=$rqty[$key];
        array_pop($valqty);
        array_push($valqty, $vqty);
      }
    }

/*print_r($valid);
    echo "<br>";
    print_r($valqty);
    echo "<br>";*/
sort($valid);
   /* print_r($valid);
    echo "<br>";*/
    sort($valqty);
    /*print_r($valqty);
    echo "<br>";*/

$val1='';
    $valid1=[];
    $valqty1=[];
    $vqty1=0;
    foreach($valid as $key=>$value)
    {
      if($val1!=$value)
      {
        array_push($valid1, $value);
        $val1=$value;
        $vqty1 = $valqty[$key];
        array_push($valqty1, $vqty1);
      }
      else
      {
        $vqty1+=$valqty[$key];
        array_pop($valqty1);
        array_push($valqty1, $vqty1);
      }
    }

$impvalid = implode(',', $valid1);
    $impvalqty = implode(',', $valqty1);

/*echo $impvalid;
    echo "<br>";
    echo $impvalqty;
    echo "<br>";*/

$rawmaterial = get_rawmaterial_details_by_ids($impvalid);
    $data['rawmaterial_details'] = $rawmaterial;
    $data['total_rawmaterial_weight'] = $impvalqty;
    $data['location_id'] = $location_id;

$this->load->view('workorder/workorder_detail_table',$data);
    /*print_r($rawmaterial);
    exit;*/
  }

public function create_workorder()
  {

$last_id_value = $this->Workorder_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['work_order_no'] = date("Y").'/'.date('m').'/WO001';
    }
    else
    {
      /*$lno = $last_id_value->work_order_no;
      $exlno = explode('/', $lno);
      $next_value = $exlno[3] + 1;
      $data['work_order_no'] = date("Y").'/'.date('m').'/WO00'.$next_value;*/

$lno = $last_id_value->work_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;
      $data['work_order_no'] = date("Y").'/'.date('m').'/WO'.$nval;
    }
//print_r(str_replace('/', '-', $this->input->post('delivery_date_time')).':00');

//$data['customer_code']=$this->input->post('customer_code');
    $ordId = $data['order_id']=$this->input->post('order_id');
    $ddt = explode('/', $this->input->post('order_date'));
    $data['work_order_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['delivery_date_time'] = str_replace('/', '-', $this->input->post('delivery_date_time')).':00';
    //print_r($data);exit;die();
    $result = $this->Workorder_model->create_workorder($data);

if ($result) {
      $last_id_value = $this->Workorder_model->last_id();
      $last_value=$last_id_value->count_val;
      $work_order_id = $last_value;

if($this->input->post('product_id')!='')
      {
        $pid = explode(",",implode(",",$this->input->post('product_id')));
        $spec = explode(",",implode(",",$this->input->post('spec')));
        $uom = explode(",",implode(",",$this->input->post('uom')));
        $oqty = explode(",",implode(",",$this->input->post('order_qty')));
        $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
        $rmqty = explode(",",implode(",",$this->input->post('rawmaterial_qty')));
        $opid = explode(",",implode(",",$this->input->post('order_product_id')));

$subcount = count($this->input->post('product_id'));      
          $data1['work_order_id'] =  $work_order_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($pid[$i] != ''){
            $data1['product_id'] = $pid[$i];
            $data1['spec'] = $spec[$i];
            $data1['uom'] = $uom[$i];
            $data1['order_qty'] = $oqty[$i];
            $data1['rawmaterial_id'] = $rmid[$i];
            $data1['rawmaterial_qty'] = $rmqty[$i];
            $data1['order_product_id'] = $opid[$i];
            //$this->db->insert('order_product',$op);
            $this->Workorder_model->create_work_order_product($data1);
            $soprod = $this->Workorder_model->get_so_product_by_oid_pid($ordId,$pid[$i]);
            $woqty = $soprod->wo_quantity;
            $upwoqty = $woqty+$oqty[$i];
            $this->Workorder_model->update_so_prod_for_wo($upwoqty,$ordId,$pid[$i]);
          }
        }
      }

$oprod = $this->Workorder_model->get_so_prod_qty_diff_by_oid($ordId);

if(count($oprod)==0)
      {
        $ordsts['status']=1;
        $this->Workorder_model->update_order_status($ordsts,$ordId);
      }

$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($ordId);

$cus_id = $order_list->customer_id;

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
      $cphone = $cusphone->phone_no;

$pdata['customer_phone'] = $cphone;

$pdata['workorder'] = $this->Workorder_model->get_work_order_by_id($work_order_id);

$pdata['workorder_product'] = $this->Workorder_model->get_work_order_product_by_id($work_order_id);

$pdata['workorder_rm_details'] = $this->Workorder_model->get_work_order_rm_details_by_id($work_order_id);

$this->session->set_flashdata('add_success', 'Work Order has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    $this->load->view('workorder/printview',$pdata);
    //redirect('/workorder/workorder_add');
  }

public function workorder_print($id)
  {

$workorder = $pdata['workorder'] = $this->Workorder_model->get_work_order_by_id($id);

$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($workorder->order_id);

$cus_id = $order_list->customer_id;

$cusphone = $this->Order_model->get_customer_phone_by_id($cus_id);
    $cphone = $cusphone->phone_no;

$pdata['customer_phone'] = $cphone;

$pdata['workorder_product'] = $this->Workorder_model->get_work_order_product_by_id($id);

$pdata['workorder_rm_details'] = $this->Workorder_model->get_work_order_rm_details_by_id($id);
    
    $this->load->view('workorder/printview',$pdata);
  }

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

public function short_close()
  {
    $wordId = $this->input->post('wo_id');
    $workorder = $this->Workorder_model->get_work_order_by_id($wordId);
    if($workorder->status==0)
    {
      $wordsts['status']=20;
      $this->Issueregister_model->update_work_order_status($wordsts,$wordId);

$woprod = $this->Workorder_model->get_work_order_product_by_id($wordId);
      foreach($woprod as $wop)
      {
        $opid = $wop['order_product_id'];
        $woqty = $wop['order_qty'];
        $opidlist = $this->Workorder_model->get_order_product_by_op_id($opid);
        $upwoqty = $opidlist->wo_quantity-$woqty;
        $this->Workorder_model->update_woq_by_op_id($upwoqty,$opid);
      }

$olist = $this->Workorder_model->get_order_by_work_order_id($wordId);

if(count($olist)>0)
      {
        $oId = $olist->order_id;
        $ordsts['status']=0;
        $this->Workorder_model->update_order_status($ordsts,$oId);
      }

$this->session->set_flashdata('add_success', 'Work Order has been Short Close successfully.');
      redirect('/workorder');
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Already worklog Created. Not able to delete this workorder!');
      redirect('/workorder');
    }

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Workorder.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation