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

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

class Deliverychallan extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Deliverychallan_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Customer_model'));
    $this->load->model(array('Purchase_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', 'Delivery Challan');
  }

public function deliverychallan_export()
  {
    $dtrange = isset($_SESSION['dcdtrange'])?$_SESSION['dcdtrange']:'';
    $schange = isset($_SESSION['dcschange'])?$_SESSION['dcschange']:'';
    $locchange = isset($_SESSION['dcfilterloc'])?$_SESSION['dcfilterloc']:'';
    $dcsearch_change = isset($_SESSION['dcsearch_change'])?$_SESSION['dcsearch_change']:'';
    $statuschange = isset($_SESSION['dcfilterstatus'])?$_SESSION['dcfilterstatus']:'all';

if ($dcsearch_change != '') {
      $sc = 'AND (dc.delivery_challan_no LIKE "%'.$dcsearch_change.'%" OR c.customer_name LIKE "%'.$dcsearch_change.'%")';
      //$sc = 'AND (dc.delivery_challan_no LIKE "%'.$dcsearch_change.'%")';
    }
    else {
      $sc = '';
    }

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

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

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

$data['order_list'] = $this->Deliverychallan_model->get_wl_order_list();
      }
      else
      {
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND wl.created_by='.$_SESSION['user_id'];
          $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['order_list'] = $this->Deliverychallan_model->get_wl_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->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
      }
      else
      {
        $issu = '';
        $data['order_list'] = $this->Deliverychallan_model->get_super_user_wl_order_list($_SESSION['company_id']);
      }
    }

$issu = '';
    $compId = '';

if($schange == '')
    {
      $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');
      }

$deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();
 }
 elseif($schange == 'today')
 {
 $deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();
 }
 else if($schange == 'thisweek')
 {
 $deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();
 } 
 else if($schange == 'thismonth')
 {
 $deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();
 }
 else if($schange == 'thisyear')
 {

$finstart = $_SESSION['finstart'];
      $finend = $_SESSION['finend'];

$deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_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];
 $deliverychallan_list = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_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', 'Delivery Challan No');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Order No');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Date');
    $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 ($deliverychallan_list as $u_list ) {

if($u_list['customer_id'] == 0)
      {
        $order_list = $this->Order_model->get_order_by_id($u_list['order_id']);
        $cusid = $order_list->customer_id;
        $ordno = $order_list->order_no;
        $clist = $this->Deliverychallan_model->get_customer_by_id($cusid);
      }
      else
      {
        $cusid = $u_list['customer_id'];
        $ordno = '-';
        $clist = $this->Deliverychallan_model->get_customer_by_id($cusid);
      }
      
      $cusDetails = $this->Deliverychallan_model->get_customer_contact_details($cusid);
      $pno = $cusDetails->phone_no;
      $cusfdet = $clist->customer_code.' - '.$clist->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;

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

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['delivery_challan_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $ordno);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, date_format(date_create($u_list['delivery_challan_date']),$g_settings->date_format));
      $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, $status);

$i++;
    }

$filename='Delivery_Challan.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() . "deliverychallan";
 $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['dcschange']) || isset($_SESSION['dcdtrange']) || isset($_SESSION['dcsearch_change']) || isset($_SESSION['dcfilterloc']) || isset($_SESSION['dcfilterstatus']))))
    {

$btn = $this->input->post('goButton');
      $schange = $this->input->post('searchChange');
      $dtrange = $this->input->post('dtrange');
      $locchange = $this->input->post('filterloc');
      $statuschange = $this->input->post('filterstatus');

$this->session->set_userdata('dcschange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['dcschange']);
      $this->session->set_userdata('dcdtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['dcdtrange']);
      // $this->session->set_userdata('dcsearch_change', $this->input->post('dc_search')!=''?$this->input->post('dc_search'):$_SESSION['dcsearch_change']);
      if($_SERVER['REQUEST_METHOD'] == 'POST')
        $this->session->set_userdata('dcsearch_change', $this->input->post('dc_search'));
      $this->session->set_userdata('dcfilterloc', $this->input->post('filterloc')!=''?$this->input->post('filterloc'):$_SESSION['dcfilterloc']);
      $this->session->set_userdata('dcfilterstatus', $this->input->post('filterstatus')!=''?$this->input->post('filterstatus'):$_SESSION['dcfilterstatus']);

$dtrange = isset($_SESSION['dcdtrange'])?$_SESSION['dcdtrange']:$this->input->post('dtrange');
      $schange = isset($_SESSION['dcschange'])?$_SESSION['dcschange']:$this->input->post('searchChange');
      $locchange = isset($_SESSION['dcfilterloc'])?$_SESSION['dcfilterloc']:$this->input->post('filterloc');
      $dcsearch_change = isset($_SESSION['dcsearch_change'])?$_SESSION['dcsearch_change']:$this->input->post('dc_search');
      $statuschange = isset($_SESSION['dcfilterstatus'])?$_SESSION['dcfilterstatus']:$this->input->post('filterstatus');

if ($dcsearch_change != '') {
        //$sc = 'AND (dc.delivery_challan_no LIKE "%'.$dcsearch_change.'%")';
        $sc = 'AND (dc.delivery_challan_no LIKE "%'.$dcsearch_change.'%" OR c.customer_name LIKE "%'.$dcsearch_change.'%")';
      }
      else {
        $sc = '';
      }

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

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

// if($btn=='')
      // {
      //   $dtrange='';
      // }
      if($schange == '')
        $schange='';
      $data['locchange'] = $locchange;
      $data['statuschange'] = $statuschange;
      $data['dcsearch_change'] = $dcsearch_change;
      if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';

$data['order_list'] = $this->Deliverychallan_model->get_wl_order_list();
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND wl.created_by='.$_SESSION['user_id'];
            $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
          }
          else
          {
            $issu = '';
            $data['order_list'] = $this->Deliverychallan_model->get_wl_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->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['order_list'] = $this->Deliverychallan_model->get_super_user_wl_order_list($_SESSION['company_id']);
        }
      }

$compId = '';
      $issu = '';

if($schange == '')
      {
        $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 dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id ORDER BY dc.delivery_challan_id DESC

//SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

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

$data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC Limit $page, $perpage")->result_array();
 }
 elseif($schange == 'today')
 {
 $data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') = CURDATE() $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

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

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

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

$data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND YEARWEEK(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC Limit $page, $perpage")->result_array();
      }      
      else if($schange == 'thismonth')
      {

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

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

$data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND MONTH(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = MONTH(CURDATE()) $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC $page, $perpage")->result_array();
      }
      else if($schange == 'thisyear')
      {
        //$data['deliverychallan_list'] = $this->db->query("SELECT dc.* FROM delivery_challan dc WHERE $compId $issu $loc $sc and YEAR(STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY dc.delivery_challan_id DESC")->result_array();
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);
 
 $data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC Limit $page, $perpage")->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];

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);
 
 $data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC Limit $page, $perpage")->result_array();
 }
 $data['purchasesearch'] = $schange;
 $data['drnge'] = $dtrange;

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['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);
 
 $data['deliverychallan_list'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status) UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(dc.delivery_challan_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') $compId $issu $loc $sc $status)) s ORDER BY s.delivery_challan_id DESC Limit $page, $perpage")->result_array();
 }
 }
 else
 {
 $this->session->unset_userdata('dcdtrange');
 $this->session->unset_userdata('dcschange');
 $this->session->unset_userdata('dcfilterloc');
 $this->session->unset_userdata('dcsearch_change');
 $this->session->unset_userdata('dcfilterstatus');

$data['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['locchange'] = '';
      $data['dcsearch_change'] = '';
      $data['statuschange'] = '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');
      }

/*if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        {
          //$data['deliverychallan_list'] = $this->Deliverychallan_model->get_delivery_challan_list($fdate,$tdate);

$data['clist'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC")->result_array();

$data['clist'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND dc.created_by=uid AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);
 
 $data['deliverychallan_list'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND dc.created_by=uid AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC Limit $page, $perpage")->result_array(); 
 
 $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
 }
 }
 else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
 {
 //$data['deliverychallan_list'] = $this->Deliverychallan_model->get_user_delivery_challan_list($_SESSION['user_id'],$fdate,$tdate);
 $data['clist'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND dc.created_by=uid AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC")->result_array();

$config["total_rows"] = count($data['clist']);
 
 $data['deliverychallan_list'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND dc.created_by=uid AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC Limit $page, $perpage")->result_array(); 
 $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
 }
 else
 {
 //$data['deliverychallan_list'] = $this->Deliverychallan_model->get_super_user_delivery_challan_list($_SESSION['company_id'],$fdate,$tdate);
 $data['clist'] = $this->db->query("SELECT dc.*,o.order_no,c.customer_name,c.customer_id,c.customer_code FROM delivery_challan dc,`order` o,customer c WHERE dc.order_id = o.order_id AND o.customer_id = c.customer_id AND o.location_id=cid AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' ORDER BY dc.delivery_challan_id DESC")->result_array();

$data['clist'] = $this->db->query("SELECT s.* FROM ((SELECT dc.* FROM delivery_challan dc,`order` o,customer c WHERE o.order_id = dc.order_id AND o.customer_id = c.customer_id AND dc.customer_id=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate') UNION (SELECT dc.* FROM delivery_challan dc,customer c WHERE dc.customer_id = c.customer_id AND dc.customer_id!=0 AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate')) s ORDER BY s.delivery_challan_id DESC")->result_array();

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

public function wo_list()
  {
    //$data['work_log'] = $this->Deliverychallan_model->get_wl_order_list();

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['work_log'] = $this->Deliverychallan_model->get_wl_order_list();
      }
      else
      {
        $data['work_log'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['work_log'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['work_log'] = $this->Deliverychallan_model->get_super_user_wl_order_list($_SESSION['company_id']);
    }

$this->load->view('deliverychallan/pending_work_log',$data);
  }

public function deliverychallan_add()
  {

$last_id_value = $this->Deliverychallan_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['delivery_challan_no'] = date("Y").'/'.date('m').'/DC001';
    }
    else
    {
      $lno = $last_id_value->delivery_challan_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['delivery_challan_no'] = date("Y").'/'.date('m').'/DC'.$nval;
    }

//$data['order_list'] = $this->Deliverychallan_model->get_wl_order_list();
    $data['transport_list'] = $this->Deliverychallan_model->get_active_transport_list();
    $data['purpose_of_transport_list'] = $this->Deliverychallan_model->get_active_purpose_of_transport_list();

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['order_list'] = $this->Deliverychallan_model->get_wl_order_list();
      }
      else
      {
        $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['order_list'] = $this->Deliverychallan_model->get_user_wl_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['order_list'] = $this->Deliverychallan_model->get_super_user_wl_order_list($_SESSION['company_id']);
    }

$this->load->view('deliverychallan/deliverychallan_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['user_list'] = $this->Worklog_model->user_active_list();
    $data['order_issue_weight'] = $this->Deliverychallan_model->get_order_issue_weight_by_id($pt_id);
    //$data['order_product_list'] = $this->Deliverychallan_model->get_order_product_by_id($pt_id);
    $data['order_product_list'] = $this->Deliverychallan_model->get_work_order_product_for_dc_by_id($pt_id);

$this->load->view('deliverychallan/deliverychallan_product_detail',$data);
  }

public function getCustomerDetails()
  {
    $oid = $_POST['id'];
    $order_list = $this->Deliverychallan_model->get_order_view_by_id($oid);
    $customer_details = $this->Deliverychallan_model->get_customer_contact_details($order_list->customer_id);
    $plist = $this->Deliverychallan_model->get_payment_by_order_id($oid);

$paid_amount = $plist->paid_amount;
    if($paid_amount==null)
      $paid_amount = 0;
    $pamt = $paid_amount+$order_list->advance_amount;
    $tamt = $order_list->grand_total;

if($pamt == 0)
 {
 $psts = 'Un Paid';
 }
 else if($tamt == $pamt)
 {
 $psts = 'Paid';
 }
 else
 {
 $psts = 'Partially Paid';
 }

echo $order_list->customer_name.'|'.$customer_details->phone_no.'|'.$psts;
  }

public function create_deliverychallan()
  {  
    $data['delivery_challan_no']=$this->input->post('delivery_challan_no');
    $ddt = explode('/', $this->input->post('delivery_challan_date'));
    $data['delivery_challan_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    $exp = explode('-', $this->input->post('order_id'));
    $ordId = $data['order_id']=$exp[0];
    $wodrId = $data['work_order_id']=$exp[1];
    $data['purpose_of_transport']=$this->input->post('purpose_of_transport');
    $data['mode_of_transport']=$this->input->post('mode_of_transport');
    $data['vehicle_no']=$this->input->post('vehicle_no');
    $data['remarks']=$this->input->post('remarks');
    $data['no_of_boxes']=$this->input->post('no_of_boxes');
    $data['weight']=$this->input->post('weight');
    //$data['total_value_of_goods']=$this->input->post('total_value_of_goods');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['issue_weight']=$this->input->post('issue_weight');
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['destination_point']=$this->input->post('destination_point');

$data['customer_id']=0;
    $data['is_direct'] = 0;

$odrView = $this->Order_model->get_order_view_by_id($ordId);
    $cusid = $odrView->customer_id;
    $locId = $odrView->location_id;
    $customer_list = $this->Customer_model->get_customer_view_by_id($cusid);
    
    $result = $this->Deliverychallan_model->create_deliverychallan($data);
    //$result=1;

if ($result) {
      $last_id_value = $this->Deliverychallan_model->last_id();
      $last_value=$last_id_value->count_val;
      $delivery_challan_id = $last_value;

if($this->input->post('product_id')!='')
      {
        $pid = explode(",",implode(",",$this->input->post('product_id')));
        $uom = explode(",",implode(",",$this->input->post('uom_id')));
        $rpsf = explode(",",implode(",",$this->input->post('rate_per_sqft')));
        $csl = explode(",",implode(",",$this->input->post('cut_size_length')));
        $csw = explode(",",implode(",",$this->input->post('cut_size_width')));
        $csh = explode(",",implode(",",$this->input->post('cut_size_height')));
        $fsl = explode(",",implode(",",$this->input->post('finish_size_length')));
        $fsw = explode(",",implode(",",$this->input->post('finish_size_width')));
        $fsh = explode(",",implode(",",$this->input->post('finish_size_height')));
        $qty = explode(",",implode(",",$this->input->post('quantity')));
        $rt = explode(",",implode(",",$this->input->post('rate')));
        $dis = explode(",",implode(",",$this->input->post('disc')));
        $amt = explode(",",implode(",",$this->input->post('amount')));

$subcount = count($this->input->post('product_id')); 
 $data1['delivery_challan_id'] = $delivery_challan_id;
 for($i=0;$i<$subcount;$i++)
 {
 if($pid[$i] != ''){
 $data1['product_id'] = $pid[$i];
 $data1['uom_id'] = $uom[$i];
 $data1['rate_per_sqft'] = $rpsf[$i];
 $data1['cut_size_length'] = $csl[$i];
 $data1['cut_size_width'] = $csw[$i];
 $data1['cut_size_height'] = $csh[$i];
 $data1['finish_size_length'] = $fsl[$i];
 $data1['finish_size_width'] = $fsw[$i];
 $data1['finish_size_height'] = $fsh[$i];
 $data1['quantity'] = $qty[$i];
 $data1['rate'] = $rt[$i];
 $data1['disc'] = $dis[$i];
 $data1['amount'] = $amt[$i];
 $this->Deliverychallan_model->create_delivery_challan_product($data1);
 if($customer_list->is_self==1)
 {
 $pstock = $this->Purchase_model->get_product_stock_by_location_id($pid[$i],$locId);
 if(count($pstock)>0)
 {
 $ostk = $pstock->stock;
 $upstk['stock'] = $ostk+$qty[$i];
 $upstk['booked'] = $pstock->booked;
 $upstk['need_production'] = $pstock->need_production;
 $upstk['modified_on'] = date('Y-m-d H:i:s');
 $upstk['modified_by'] = $_SESSION['user_id'];
 $this->Purchase_model->update_product_stock_by_location_id($locId,$pid[$i],$upstk);
 /*echo "UPDATE `product_stock` SET `stock`=".$upstk['stock'].",`booked`=".$upstk['booked'].",`need_production`=".$upstk['need_production'].",`modified_on`='".$upstk['modified_on']."',`modified_by`=".$upstk['modified_by']." WHERE `location_id`=".$locId." AND `product_id`=".$pid[$i];
 print_r($upstk);
 echo " ".$locId." ";
 echo " ".$pid[$i]." ";
 exit;die();*/
 }
 else
 { 
 $upstkadd['location_id']=$locId;
 $upstkadd['product_id'] = $pid[$i]; 
 $upstkadd['stock'] = $qty[$i];
 $upstkadd['created_on'] = date('Y-m-d H:i:s');
 $upstkadd['created_by'] = $_SESSION['user_id'];
 $this->Purchase_model->add_product_stock_by_location_id($upstkadd);
 //print_r($upstkadd);
 }
 }
 }
 }
 }
 //exit;

$workLog = $this->Deliverychallan_model->get_work_log_by_woid($wodrId);
      $wlId = $workLog->work_log_id;
      $woId = $workLog->work_order_id;

if($customer_list->is_self==0)
      {
        $ordsts['status']=1;
        $this->Deliverychallan_model->update_work_log_status($ordsts,$wlId);

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

$wosts['status']=3;
        $this->Deliverychallan_model->update_work_order_status($wosts,$woId);

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

$ordsts['status']=4;
        $this->Deliverychallan_model->update_order_status($ordsts,$ordId);
      }
      else
      {
        $dcsts['status'] = 15;
        $this->Deliverychallan_model->update_delivery_challan_status($dcsts,$delivery_challan_id);

$ordsts['status']=15;
        $this->Deliverychallan_model->update_work_log_status($ordsts,$wlId);

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

$wosts['status']=15;
        $this->Deliverychallan_model->update_work_order_status($wosts,$woId);

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

$ordsts['status']=15;
        $this->Deliverychallan_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;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

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

$badd='';
      $sadd = '';
      foreach($cus_address as $cadd)
      {
        if($cadd['address_type_id']==1)
        {
          $badd = $cadd['address'];
        }
        if($cadd['address_type_id']==2)
        {
          $sadd = $cadd['address'];
        }
      }
      if($badd=='')
      {
        $pdata['badd'] = $badd = $sadd;
      }
      else
      {
        $pdata['badd'] = $badd = $badd;
      }
      if($sadd=='')
      {
        $pdata['sadd'] = $sadd = $badd;
      }
      else
      {
        $pdata['sadd'] = $sadd = $sadd;
      }

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan'] = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);

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

public function deliverychallan_print($delivery_challan_id)
  {

$deliverychallan = $pdata['delivery_challan'] = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);
      $order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($deliverychallan->order_id);

$cus_id = $order_list->customer_id;
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

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

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);
    
    $this->load->view('deliverychallan/printview',$pdata);
  }

public function deliverychallan_edit($delivery_challan_id)
  {
    $delivery_challan = $data['delivery_challan'] = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);
    $data['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);
    $data['transport_list'] = $this->Deliverychallan_model->get_active_transport_list();
    $data['purpose_of_transport_list'] = $this->Deliverychallan_model->get_active_purpose_of_transport_list();

$order_list = $this->Deliverychallan_model->get_order_view_by_id($delivery_challan->order_id);
    $customer_details = $this->Deliverychallan_model->get_customer_contact_details($order_list->customer_id);
    /*$plist = $this->Deliverychallan_model->get_payment_by_order_id($delivery_challan->order_id);

$paid_amount = $plist->paid_amount;
 if($paid_amount==null)
 $paid_amount = 0;
 $pamt = $paid_amount+$order_list->advance_amount;
 $tamt = $order_list->grand_total;
 if($pamt == 0)
 {
 $psts = 'Un Paid';
 }
 else if($tamt == $pamt)
 {
 $psts = 'Paid';
 }
 else
 {
 $psts = 'Partially paid';
 }

$data['cus_details'] = $order_list->customer_name.'|'.$customer_details->phone_no.'|'.$psts;*/

$this->load->view('deliverychallan/deliverychallan_edit',$data);
  }

public function update_deliverychallan()
  {  
    $ordId=$this->input->post('order_id');
    $delivery_challan_id = $data['delivery_challan_id']=$this->input->post('delivery_challan_id');
    $delivery_challan = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);
    if($delivery_challan->status==0)
    {
      $data['purpose_of_transport']=$this->input->post('purpose_of_transport');
      $data['mode_of_transport']=$this->input->post('mode_of_transport');
      $data['vehicle_no']=$this->input->post('vehicle_no');
      $data['remarks']=$this->input->post('remarks');
      $data['no_of_boxes']=$this->input->post('no_of_boxes');
      $data['weight']=$this->input->post('weight');
      //$data['total_value_of_goods']=$this->input->post('total_value_of_goods');
      $data['modified_on'] = date('Y-m-d H:i:s');
      $data['modified_by'] = $_SESSION['user_id'];
      $data['issue_weight']=$this->input->post('issue_weight');
      $data['gross_weight']=$this->input->post('gross_weight');
      $data['destination_point']=$this->input->post('destination_point');
      
      $result = $this->Deliverychallan_model->update_deliverychallan($data);

if ($result) {

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

$cus_id = $order_list->customer_id;
        $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

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

$badd='';
        $sadd = '';
        foreach($cus_address as $cadd)
        {
          if($cadd['address_type_id']==1)
          {
            $badd = $cadd['address'];
          }
          if($cadd['address_type_id']==2)
          {
            $sadd = $cadd['address'];
          }
        }
        if($badd=='')
        {
          $pdata['badd'] = $badd = $sadd;
        }
        else
        {
          $pdata['badd'] = $badd = $badd;
        }
        if($sadd=='')
        {
          $pdata['sadd'] = $sadd = $badd;
        }
        else
        {
          $pdata['sadd'] = $sadd = $sadd;
        }

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan'] = $this->Deliverychallan_model->get_delivery_challan_by_id($delivery_challan_id);

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);

$this->session->set_flashdata('add_success', 'Delivery Challan has been Updated successfully.');
      }
      else{
        $this->session->set_flashdata('add_err', 'Something went wrong');
      }
      $this->load->view('deliverychallan/printview',$pdata);
    }
    else
    {
      $this->session->set_flashdata('add_success', 'Already Invoice Created. Not able to edit this DC!');
      redirect('/deliverychallan');
    }
    //redirect('/deliverychallan');
  }

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

public function short_close()
  {
    $dcId = $this->input->post('dc_id');
    
    $dclist = $this->Deliverychallan_model->get_delivery_challan_by_id($dcId);
    if($dclist->status==0)
    {
      $ordId = $dclist->order_id;
      $woId = $dclist->work_order_id;

$wlsts['status']=0;
      $this->Deliverychallan_model->update_work_log_status_by_woid($wlsts,$woId);

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

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

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

$this->Deliverychallan_model->delete_dc_product_by_id($dcId);
      $this->Deliverychallan_model->delete_dc_by_id($dcId);

$this->session->set_flashdata('add_success', 'Delivery Challan has been Deleted successfully.');
    }
    else
    {
      $this->session->set_flashdata('add_success', 'Already Invoice Created. Not able to delete this DC!');
    }
    redirect('/deliverychallan');

}

public function direct_deliverychallan_add()
  {

$data['transport_list'] = $this->Deliverychallan_model->get_active_transport_list();
    $data['purpose_of_transport_list'] = $this->Deliverychallan_model->get_active_purpose_of_transport_list();

$data['product_list'] = $this->Deliverychallan_model->get_subhiksha_products();

$this->load->view('deliverychallan/direct_deliverychallan_add',$data);
  }

public function getProductDetails()
  {
    $prod_id = $_POST['prod_id'];
    $product = $this->Deliverychallan_model->get_product_uom_by_product_id($prod_id);
    echo $product->uom."|".$product->uom_id;
  }

public function create_direct_deliverychallan()
  {  
    $data['delivery_challan_no']=$this->input->post('delivery_challan_no');
    $ddt = explode('/', $this->input->post('delivery_challan_date'));
    $data['delivery_challan_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    //$exp = explode('-', $this->input->post('order_id'));
    $ordId = 0;
    $wodrId = 0;
    $data['purpose_of_transport']=$this->input->post('purpose_of_transport');
    $data['mode_of_transport']=$this->input->post('mode_of_transport');
    $data['vehicle_no']=$this->input->post('vehicle_no');
    $data['remarks']=$this->input->post('remarks');
    $data['no_of_boxes']=$this->input->post('no_of_boxes');
    $data['weight']=$this->input->post('weight');
    //$data['total_value_of_goods']=$this->input->post('total_value_of_goods');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['issue_weight']=$this->input->post('issue_weight');
    $data['gross_weight']=$this->input->post('gross_weight');
    $data['destination_point']=$this->input->post('destination_point');

$cusid = $data['customer_id']=$this->input->post('customer_id');
    $data['is_direct'] = 1;    
    $result = $this->Deliverychallan_model->create_deliverychallan($data);
    //$result=1;

if ($result) {
      $last_id_value = $this->Deliverychallan_model->last_id();
      $last_value=$last_id_value->count_val;
      $delivery_challan_id = $last_value;

}
        }
      }
      //exit;

$dcsts['status'] = 15;
      $this->Deliverychallan_model->update_delivery_challan_status($dcsts,$delivery_challan_id);

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

$cus_id = $cusid;
      $pdata['cus_details'] = $this->Order_model->get_customer_view_by_id($cus_id);
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

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

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan'] = $this->Deliverychallan_model->get_direct_delivery_challan_by_id($delivery_challan_id);

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);

public function direct_deliverychallan_print($delivery_challan_id)
  {

$deliverychallan = $pdata['delivery_challan'] = $this->Deliverychallan_model->get_direct_delivery_challan_by_id($delivery_challan_id);
      //$order_list = $pdata['order_list'] = $this->Order_model->get_order_view_by_id($deliverychallan->order_id);

$cus_id = $deliverychallan->customer_id;
      $pdata['cus_details'] = $this->Order_model->get_customer_view_by_id($cus_id);
      $cus_address = $pdata['cus_address'] = $this->Order_model->get_customer_address($cus_id);

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

$pdata['customer_phone'] = $cphone;

$pdata['delivery_challan_product'] = $this->Deliverychallan_model->get_delivery_challan_product_by_id($delivery_challan_id);
    
    $this->load->view('deliverychallan/printview',$pdata);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Deliverychallan.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation