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

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

class Worklog extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Worklog_model'));
    $this->load->model(array('Issueregister_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Workorder_model'));
    $this->load->model(array('Invoice_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 Log');
  }

public function worklog_export()
  {
    $dtrange = isset($_SESSION['wldtrange'])?$_SESSION['wldtrange']:'';
    $schange = isset($_SESSION['wlschange'])?$_SESSION['wlschange']:'all';
    $wlsearch_change = isset($_SESSION['wlsearch_change'])?$_SESSION['wlsearch_change']:'';
    $locchange = isset($_SESSION['wlfilterloc'])?$_SESSION['wlfilterloc']:'all';
    $statuschange = isset($_SESSION['wlfilterstatus'])?$_SESSION['wlfilterstatus']:'all';

if ($wlsearch_change != '') {
      $sc = 'AND (wo.work_order_no LIKE "%'.$wlsearch_change.'%" OR c.customer_name LIKE "%'.$wlsearch_change.'%" OR o.order_no LIKE "%'.$wlsearch_change.'%" OR wl.work_log_no LIKE "%'.$wlsearch_change.'%")';
    }
    else {
      $sc = '';
    }
    if($locchange!='all')
      $loc = 'AND o.location_id='.$locchange;
    else
      $loc = '';

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

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

if($_SESSION['company_id']==0)
    {
      $compId = '';
      if($_SESSION['role_id']==1)
      {
        $issu = '';

$data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
      }
      else
      {
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND wl.created_by='.$_SESSION['user_id'];
          $data['work_log_list'] = $this->Worklog_model->get_user_work_log_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
        }
      }
    }
    else
    {
      $compId = 'AND o.location_id='.$_SESSION['company_id'];
      if($_SESSION['is_super_user']==0)
      {
        $issu = 'AND wl.created_by='.$_SESSION['user_id'];
        $data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
      }
      else
      {
        $issu = '';
        $data['issue_register'] = $this->Worklog_model->get_super_user_pending_issue_register($_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');
      }

$work_log_list = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $compId $issu $loc $sc $status ORDER BY wl.work_log_id DESC")->result_array();
    }
    elseif($schange == 'today')
    {
      $work_log_list = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and STR_TO_DATE(wl.work_log_date, '%Y-%m-%d') = CURDATE() ORDER BY wl.work_log_id DESC")->result_array();
    }
    else if($schange == 'thisweek')
    {
      $work_log_list = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and YEARWEEK(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY wl.work_log_id DESC")->result_array();
    }      
    else if($schange == 'thismonth')
    {
      $work_log_list = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and MONTH(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY wl.work_log_id DESC")->result_array();
    }
    else if($schange == 'thisyear')
    {
      $finstart = $_SESSION['finstart'];
      $finend = $_SESSION['finend'];
      $work_log_list = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and  STR_TO_DATE(wl.work_log_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(wl.work_log_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY wl.work_log_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];

$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 Log No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Work Order No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Order No');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Customer Info');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Last Updated On');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Last Updated By');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Stage');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($work_log_list as $u_list ) { 
      $cusDetails = $this->Worklog_model->get_customer_contact_details($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;
      $g_settings = general_setting_details();

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;

if($u_list['status']==0)
        $stg = 'Open';
      else if($u_list['status']==1)
        $stg = 'Delivery Challan';
      else if($u_list['status']==15)
        $stg = 'Completed';
      else
        $stg = 'Invoice';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['work_log_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['work_order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $u_list['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $cusfdet);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, date_format(date_create($lmdate),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $lmbyname);
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $stg);

$i++;
    }

$filename='Worklog.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() . "worklog";
    $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($_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['wlschange']) || isset($_SESSION['wldtrange']) || isset($_SESSION['wlsearch_change']) || isset($_SESSION['wlfilterloc']) || isset($_SESSION['wlfilterstatus']))))
    {
      $btn = $this->input->post('goButton');
      // $schange = $this->input->post('searchChange');
      // $dtrange = $this->input->post('dtrange');
      // $locchange = $this->input->post('filterloc');
      $this->session->set_userdata('wlschange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['wlschange']);
      $this->session->set_userdata('wldtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['wldtrange']);
      // $this->session->set_userdata('wlsearch_change', $this->input->post('wl_search')!=''?$this->input->post('wl_search'):$_SESSION['wlsearch_change']);
      $this->session->set_userdata('wlsearch_change', $this->input->post('wl_search'));
      $this->session->set_userdata('wlfilterloc', $this->input->post('filterloc')!=''?$this->input->post('filterloc'):$_SESSION['wlfilterloc']);
      $this->session->set_userdata('wlfilterstatus', $this->input->post('filterstatus')!=''?$this->input->post('filterstatus'):$_SESSION['wlfilterstatus']);

$dtrange = isset($_SESSION['wldtrange'])?$_SESSION['wldtrange']:$this->input->post('dtrange');
      $schange = isset($_SESSION['wlschange'])?$_SESSION['wlschange']:$this->input->post('searchChange');
      $wlsearch_change = isset($_SESSION['wlsearch_change'])?$_SESSION['wlsearch_change']:$this->input->post('wl_search');
      $locchange = isset($_SESSION['wlfilterloc'])?$_SESSION['wlfilterloc']:$this->input->post('filterloc');
      $statuschange = isset($_SESSION['wlfilterstatus'])?$_SESSION['wlfilterstatus']:$this->input->post('filterstatus');

if ($wlsearch_change != '') {
        $sc = 'AND (wo.work_order_no LIKE "%'.$wlsearch_change.'%" OR c.customer_name LIKE "%'.$wlsearch_change.'%" OR o.order_no LIKE "%'.$wlsearch_change.'%" OR wl.work_log_no LIKE "%'.$wlsearch_change.'%")';
      }
      else {
        $sc = '';
      }
      if($locchange!='all')
        $loc = 'AND o.location_id='.$locchange;
      else
        $loc = '';

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

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

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';

$data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND wl.created_by='.$_SESSION['user_id'];
            $data['work_log_list'] = $this->Worklog_model->get_user_work_log_list($_SESSION['user_id']);
          }
          else
          {
            $issu = '';
            $data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
          }
        }
      }
      else
      {
        $compId = 'AND o.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND wl.created_by='.$_SESSION['user_id'];
          $data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['issue_register'] = $this->Worklog_model->get_super_user_pending_issue_register($_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 wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id ORDER BY wl.work_log_id DESC
        $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $compId $issu $loc $sc $status ORDER BY wl.work_log_id DESC")->result_array();

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

$data['work_log_list'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and YEARWEEK(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY wl.work_log_id DESC LIMIT $page, $perpage")->result_array();
      }      
      else if($schange == 'thismonth')
      {
        // echo "SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc and MONTH(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY wl.work_log_id DESC";
        // die();
        $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and MONTH(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY wl.work_log_id DESC")->result_array();

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

$data['work_log_list'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and MONTH(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = MONTH(CURDATE()) ORDER BY wl.work_log_id DESC LIMIT $page, $perpage")->result_array();
      }
      else if($schange == 'thisyear')
      {
        //$data['work_log_list'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc and YEAR(STR_TO_DATE(wl.work_log_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY wl.work_log_id DESC")->result_array();
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc $sc $status and  STR_TO_DATE(wl.work_log_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(wl.work_log_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY wl.work_log_id DESC")->result_array();

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

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

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

$data['purchasesearch'] = $schange;
      $data['drnge'] = $dtrange;
      $data['wlsearch_change'] = $wlsearch_change;
      $data['statuschange'] = $statuschange;
    }
    else
    {
      $this->session->unset_userdata('wlschange');
      $this->session->unset_userdata('wldtrange');
      $this->session->unset_userdata('wlsearch_change');
      $this->session->unset_userdata('wlfilterloc');
      $this->session->unset_userdata('wlfilterstatus');

$data['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['locchange'] = '';
      $data['wlsearch_change'] = '';
      $data['statuschange'] = 'all';

/*$fdate = '2019-04-01';
      $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');
      }
      $uid = $_SESSION['user_id'];
      if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        {
          // $data['work_log_list'] = $this->Worklog_model->get_work_log_list($fdate,$tdate);
          $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $sc ORDER BY wl.work_log_id DESC")->result_array();

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

$data['work_log_list'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.created_by='$uid' AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $sc ORDER BY wl.work_log_id DESC LIMIT $page, $perpage")->result_array();
          // $data['work_log_list'] = $this->Worklog_model->get_user_work_log_list($_SESSION['user_id'],$fdate,$tdate);
          //$data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
          $data['issue_register'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
        }
      }
      else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
      {
          $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.created_by='$uid' AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $sc ORDER BY wl.work_log_id DESC")->result_array();

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

$data['work_log_list'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND wl.created_by='$uid' AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $sc ORDER BY wl.work_log_id DESC LIMIT $page, $perpage")->result_array();
        // $data['work_log_list'] = $this->Worklog_model->get_user_work_log_list($_SESSION['user_id'],$fdate,$tdate);
        //$data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
        $data['issue_register'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
      }
      else
      {
          $data['wl_list_count'] = $this->db->query("SELECT wl.*,wo.work_order_no,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM work_log wl,work_order wo,`order` o,customer c WHERE wl.work_order_id = wo.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND o.location_id='".$_SESSION['company_id']."' AND wl.work_log_date>='$fdate' AND wl.work_log_date<='$tdate' $sc ORDER BY wl.work_log_id DESC")->result_array();

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

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

public function wo_list()
  {
    //$data['issue_register'] = $this->Worklog_model->get_pending_issue_register();

/*if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['issue_register'] = $this->Worklog_model->get_pending_issue_register();
      }
      else
      {
        $data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['issue_register'] = $this->Worklog_model->get_user_pending_issue_register($_SESSION['user_id']);
    }
    else
    {
      $data['issue_register'] = $this->Worklog_model->get_super_user_pending_issue_register($_SESSION['company_id']);
    }*/

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['issue_register'] = $this->Issueregister_model->get_open_work_order_list();
      }
      else
      {
        $data['issue_register'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['issue_register'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['issue_register'] = $this->Issueregister_model->get_super_user_open_work_order_list($_SESSION['company_id']);
    }

$this->load->view('worklog/pending_issue_register',$data);
  }

public function worklog_add()
  {

$last_id_value = $this->Worklog_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['work_log_no'] = date("Y").'/'.date('m').'/WL001';
    }
    else
    {
      $lno = $last_id_value->work_log_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_log_no'] = date("Y").'/'.date('m').'/WL'.$nval;
    }

//$data['work_order_list'] = $this->Worklog_model->get_issue_work_order_list();

/*if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['work_order_list'] = $this->Worklog_model->get_issue_work_order_list();
      }
      else
      {
        $data['work_order_list'] = $this->Worklog_model->get_user_issue_work_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['work_order_list'] = $this->Worklog_model->get_user_issue_work_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['work_order_list'] = $this->Worklog_model->get_super_user_issue_work_order_list($_SESSION['company_id']);
    }*/

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
      }
      else
      {
        $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['work_order_list'] = $this->Issueregister_model->get_super_user_open_work_order_list($_SESSION['company_id']);
    }

$this->load->view('worklog/worklog_add',$data);
  }

public function getProduct()
  {
    $pt_id = $_POST['id'];
    $work_order = $data['work_order'] = $this->Worklog_model->get_work_order_by_id($pt_id);
    $data['wo_product'] = $this->Worklog_model->get_work_order_product_by_id($pt_id);
    $data['order'] = $this->Workorder_model->get_order_view_by_id($work_order->order_id);
    $data['employee_list'] = $this->Worklog_model->employee_active_list();

$this->load->view('worklog/worklog_product_detail',$data);
  }

public function create_worklog()
  {

$wlno = $data['work_log_no']=$this->input->post('work_log_no');
    //$ordId = $data['order_id']=$this->input->post('order_id');
    $ddt = explode('/', $this->input->post('work_log_date'));
    $data['work_log_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    $woId = $data['work_order_id'] = $this->input->post('work_order_id');
    $gwgt = $data['gross_weight'] = $this->input->post('gross_weight');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];

$location_id = $this->input->post('location_id');
    
    $result = $this->Worklog_model->create_worklog($data);

if ($result) {
      $last_id_value = $this->Worklog_model->last_id();
      $last_value=$last_id_value->count_val;
      $work_log_id = $last_value;

if($this->input->post('product_id')!='')
      {
        $pid = explode(",",implode(",",$this->input->post('product_id')));
        $spec = explode(",",implode(",",$this->input->post('specification')));
        $uom = explode(",",implode(",",$this->input->post('uom')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $wgt = explode(",",implode(",",$this->input->post('weight')));
        $uid = explode(",",implode(",",$this->input->post('user_id')));
        $fdt = explode(",",implode(",",$this->input->post('finish_date_time')));
        $nwgt = explode(",",implode(",",$this->input->post('net_weight')));
        $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));

$subcount = count($this->input->post('product_id'));      
          $data1['work_log_id'] =  $work_log_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($pid[$i] != ''){
            $data1['product_id'] = $pid[$i];
            $data1['specification'] = $spec[$i];
            $data1['uom'] = $uom[$i];
            $data1['quantity'] = $qty[$i];
            $data1['weight'] = $wgt[$i];
            $data1['user_id'] = $uid[$i];
            $data1['finish_date_time'] = $fdt[$i];
            $data1['net_weight'] = $nwgt[$i];
            $data1['rawmaterial_id'] = $rmid[$i];

$stockdet = $this->Workorder_model->get_rawmaterial_stock_by_location_rawmaterial_id($location_id,$rmid[$i]);
            $reqstock = $wgt[$i];
            $s=0;
            foreach($stockdet as $rmsdet)
            {
              if($rmsdet['stock']>=$reqstock)
              {
                $stk = $reqstock;
                $s=1;
              }
              else
              {
                $reqstock = $reqstock - $rmsdet['stock'];
                $stk = $rmsdet['stock'];
              }

$stcid = $rmsdet['rawmaterial_stock_id'];
              $stok = $rmsdet['stock'];
              $fstk = $stok-$stk;
              $rmstk['stock'] = $fstk;

$this->Issueregister_model->update_rawmaterial_stock_by_id($rmstk,$stcid);
              if($s==1)
                break;
            }

$data1['rawmaterial_stock_id'] = $stcid;

$this->Worklog_model->create_work_log_product($data1);

}
        }
      }

$wordsts['status']=2;
      $this->Worklog_model->update_work_order_status($wordsts,$woId);

$irsts['status']=1;
      $this->Worklog_model->update_issue_register_status($irsts,$woId);

$workorder = $this->Worklog_model->get_work_order_by_id($woId);
      $ordId = $workorder->order_id;

$ordsts['status']=3;
      $this->Worklog_model->update_order_status($ordsts,$ordId);

$pdata['work_log_details'] = $this->Worklog_model->get_work_log_by_id($work_log_id);
    $pdata['work_log_product_details'] = $this->Worklog_model->get_work_log_product_by_id($work_log_id);

$rmnorep = str_replace('/', '-', $wlno);
      $this->load->library('zend');
      $this->zend->load('Zend/Barcode');
   
      $file = Zend_Barcode::draw('code128', 'image', array('text' => $rmnorep), array());
      $store_image = imagepng($file,"./wlbarcode/{$rmnorep}.png");

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

public function worklog_print($id)
  {   
    $pdata['work_log_details'] = $this->Worklog_model->get_work_log_by_id($id);
    $pdata['work_log_product_details'] = $this->Worklog_model->get_work_log_product_by_id($id);
    
    $this->load->view('worklog/printview',$pdata);
  }

public function worklog_edit($id)
  {   
    $data['work_log_details'] = $this->Worklog_model->get_work_log_by_id($id);
    $data['work_log_product_details'] = $this->Worklog_model->get_work_log_product_by_id($id);
    $data['employee_list'] = $this->Worklog_model->employee_active_list();
    
    $this->load->view('worklog/worklog_edit',$data);
  }

public function update_worklog()
  {  
      $wlid = $this->input->post('work_log_id');
      $gwgt = $this->input->post('gross_weight');
      $mon = date('Y-m-d H:i:s');
      $mby = $_SESSION['user_id'];
      $this->Worklog_model->update_work_log($gwgt,$mon,$mby,$wlid);
      if($this->input->post('product_id')!='')
      {
        $pid = explode(",",implode(",",$this->input->post('product_id')));
        $spec = explode(",",implode(",",$this->input->post('specification')));
        $uom = explode(",",implode(",",$this->input->post('uom')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $wgt = explode(",",implode(",",$this->input->post('weight')));
        $uid = explode(",",implode(",",$this->input->post('user_id')));
        $fdt = explode(",",implode(",",$this->input->post('finish_date_time')));
        //$fwgt = explode(",",implode(",",$this->input->post('finish_weight')));
        $wlpid = explode(",",implode(",",$this->input->post('wlp_id')));
        $nwgt = explode(",",implode(",",$this->input->post('net_weight')));

$subcount = count($this->input->post('product_id'));   
        for($i=0;$i<$subcount;$i++)
        {
          if($pid[$i] != ''){
            $data1['product_id'] = $pid[$i];
            $data1['specification'] = $spec[$i];
            $data1['uom'] = $uom[$i];
            $data1['quantity'] = $qty[$i];
            $data1['weight'] = $wgt[$i];
            $data1['user_id'] = $uid[$i];
            $data1['finish_date_time'] = $fdt[$i];
            //$data1['finish_weight'] = $fwgt[$i];
            $data1['work_log_product_id'] = $wlpid[$i];
            $data1['net_weight'] = $nwgt[$i];
            $this->Worklog_model->update_work_log_product($data1);

}
        }
      }

$pdata['work_log_details'] = $this->Worklog_model->get_work_log_by_id($wlid);
      $pdata['work_log_product_details'] = $this->Worklog_model->get_work_log_product_by_id($wlid);

$this->session->set_flashdata('add_success', 'Work Log has been updated successfully.');
    //redirect('/worklog');
    $this->load->view('worklog/printview',$pdata);
  }

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

public function short_close()
  {
    $wlId = $this->input->post('wl_id');
    
    $wllist = $this->Worklog_model->get_work_log_by_id($wlId);
    $ordId = $wllist->order_id;
    $woId = $wllist->work_order_id;

$irsts['status']=0;
    $this->Invoice_model->update_issue_register_status($irsts,$woId);

/*$wosts['status']=1;
    $this->Invoice_model->update_work_order_status($wosts,$woId);

$ordsts['status']=2;
    $this->Invoice_model->update_order_status($ordsts,$ordId);*/
    $wosts['status']=0;
    $this->Invoice_model->update_work_order_status($wosts,$woId);

$ordsts['status']=1;
    $this->Invoice_model->update_order_status($ordsts,$ordId);

$this->Worklog_model->delete_wl_product_by_id($wlId);
    $this->Worklog_model->delete_wl_by_id($wlId);

$this->session->set_flashdata('add_success', 'Work Log has been Deleted successfully.');
    redirect('/worklog');

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Worklog.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation