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

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

class Issueregister extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->model(array('Issueregister_model'));
    $this->load->model(array('Order_model'));
    $this->load->model(array('Workorder_model'));
    $this->load->model(array('Invoice_model'));
    //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', 'Issue Register');
  }

public function index()
  {
    /*$data['issue_register_list'] = $this->Issueregister_model->get_issue_register_list();
    $data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();*/
      /*$data['purchasesearch'] = '';
      $data['drnge'] = '';
    if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['issue_register_list'] = $this->Issueregister_model->get_issue_register_list();
        $data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
      }
      else
      {
        $data['issue_register_list'] = $this->Issueregister_model->get_user_issue_register_list($_SESSION['user_id']);
        $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['issue_register_list'] = $this->Issueregister_model->get_user_issue_register_list($_SESSION['user_id']);
      $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
    }
    else
    {
      $data['issue_register_list'] = $this->Issueregister_model->get_super_user_issue_register_list($_SESSION['company_id']);
      $data['work_order_list'] = $this->Issueregister_model->get_super_user_open_work_order_list($_SESSION['company_id']);
    }*/

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')
    {
      $btn = $this->input->post('goButton');
      $schange = $this->input->post('searchChange');
      $dtrange = $this->input->post('dtrange');
      $locchange = $this->input->post('filterloc');

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

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

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

$data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND ir.created_by='.$_SESSION['user_id'];
            $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
          }
          else
          {
            $issu = '';

$data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
          }
        }
      }
      else
      {
        $compId = 'AND o.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND ir.created_by='.$_SESSION['user_id'];
          $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
        }
        else
        {
          $issu = '';
          $data['work_order_list'] = $this->Issueregister_model->get_super_user_open_work_order_list($_SESSION['company_id']);
        }
      }

if($schange == '')
      {
        $data['drnge'] = '';
        $fdate = date('Y-m-d', strtotime('-7 days'));
        $tdate = date('Y-m-d');

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

$data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id AND ir.issue_date>='$fdate' AND ir.issue_date<='$tdate' $compId $issu $loc ORDER BY ir.issue_id DESC")->result_array();
      }
      elseif($schange == 'today')
      {
        $data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and STR_TO_DATE(ir.issue_date, '%Y-%m-%d') = CURDATE() ORDER BY ir.issue_id DESC")->result_array();
      }
      else if($schange == 'thisweek')
      {
        $data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and YEARWEEK(STR_TO_DATE(ir.issue_date, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) ORDER BY ir.issue_id DESC")->result_array();
      }      
      else if($schange == 'thismonth')
      {
        $data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and MONTH(STR_TO_DATE(ir.issue_date, '%Y-%m-%d')) = MONTH(CURDATE()) ORDER BY ir.issue_id DESC")->result_array();
      }
      else if($schange == 'thisyear')
      {
        //$data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and YEAR(STR_TO_DATE(ir.issue_date, '%Y-%m-%d')) = YEAR(CURDATE()) ORDER BY ir.issue_id DESC")->result_array();
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];
        $data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and  STR_TO_DATE(ir.issue_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(ir.issue_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY ir.issue_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];
        $data['issue_register_list'] = $this->db->query("SELECT ir.*,wo.work_order_no,o.customer_id,c.customer_name,c.customer_code FROM issue_register ir, work_order wo, `order` o, customer c WHERE wo.work_order_id = ir.work_order_id AND wo.order_id = o.order_id AND o.customer_id = c.customer_id $compId $issu $loc and  STR_TO_DATE(ir.issue_date, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(ir.issue_date, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') ORDER BY ir.issue_id DESC")->result_array();
      }
      $data['purchasesearch'] = $schange;
      $data['drnge'] = $dtrange;
    }
    else
    {
      $data['purchasesearch'] = '';
      $data['drnge'] = '';
      $data['locchange'] = '';

$fdate = date('Y-m-d', strtotime('-7 days'));
      $tdate = date('Y-m-d');

if($_SESSION['company_id']==0)
      {
        if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
        {
          $data['issue_register_list'] = $this->Issueregister_model->get_issue_register_list($fdate,$tdate);
          $data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
        }
        else
        {
          $data['issue_register_list'] = $this->Issueregister_model->get_user_issue_register_list($_SESSION['user_id'],$fdate,$tdate);
          $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['issue_register_list'] = $this->Issueregister_model->get_user_issue_register_list($_SESSION['user_id'],$fdate,$tdate);
        $data['work_order_list'] = $this->Issueregister_model->get_user_open_work_order_list($_SESSION['user_id']);
      }
      else
      {
        $data['issue_register_list'] = $this->Issueregister_model->get_super_user_issue_register_list($_SESSION['company_id'],$fdate,$tdate);
        $data['work_order_list'] = $this->Issueregister_model->get_super_user_open_work_order_list($_SESSION['company_id']);
      }

}

$this->load->view('issueregister/issueregister_list',$data);
  }

public function wo_list()
  {
    //$data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
    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('issueregister/pending_work_order',$data);
  }

public function issueregister_add()
  {

$last_id_value = $this->Issueregister_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['issue_no'] = date("Y").'/'.date('m').'/IR001';
    }
    else
    {
      /*$lno = $last_id_value->customer_code;
      $exlno = explode('/', $lno);
      $next_value = $exlno[3] + 1;
      $data['customer_code'] = date("Y").'/'.date('m').'/CUS/'.$next_value;*/

$lno = $last_id_value->issue_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['issue_no'] = date("Y").'/'.date('m').'/IR'.$nval;
    }

//$data['work_order_list'] = $this->Issueregister_model->get_open_work_order_list();
    
    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('issueregister/issueregister_add',$data);
  }

/*public function getProduct()
  {
    $pt_id = $_POST['id'];
    $work_order = $this->Issueregister_model->get_work_order_by_id($pt_id);
    $product = $this->Issueregister_model->get_work_order_product_by_id($pt_id);
    $order = $this->Workorder_model->get_order_view_by_id($work_order->order_id);
    if(count($product)>0)
    {
      $st = '<option value="">Select Product</option>';
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'>'.$prod["product_name"].'</option>';
      }
    }
    else
    {
      $st = '<option value="">No Products Available</option>';
    }
    echo $st.'||'.$order->location_id.'||'.$order->order_id;
  }*/

public function getProduct()
  {
    $pt_id = $_POST['id'];
    $work_order = $data['work_order'] = $this->Issueregister_model->get_work_order_by_id($pt_id);
    $data['wo_product'] = $this->Issueregister_model->get_work_order_product_by_id($pt_id);
    $data['order'] = $this->Workorder_model->get_order_view_by_id($work_order->order_id);
    /*if(count($product)>0)
    {
      $st = '<option value="">Select Product</option>';
      foreach ($product as $prod) {
          $st.='<option value='.$prod["product_id"].'>'.$prod["product_name"].'</option>';
      }
    }
    else
    {
      $st = '<option value="">No Products Available</option>';
    }
    echo $st.'||'.$order->location_id.'||'.$order->order_id;*/

$this->load->view('issueregister/issueregister_product_detail',$data);
  }

public function create_issueregister()
  {

$data['issue_no']=$this->input->post('issue_no');
    //$ordId = $data['order_id']=$this->input->post('order_id');
    $ddt = explode('/', $this->input->post('issue_date'));
    $data['issue_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];
    $woId = $data['work_order_id'] = $this->input->post('work_order_id');
    $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->Issueregister_model->create_issueregister($data);

if ($result) {
      $last_id_value = $this->Issueregister_model->last_id();
      $last_value=$last_id_value->count_val;
      $issue_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')));
        $rqty = explode(",",implode(",",$this->input->post('required_qty')));
        $iqty = explode(",",implode(",",$this->input->post('issue_qty')));
        $rmid = explode(",",implode(",",$this->input->post('rawmaterial_id')));
        $wopid = explode(",",implode(",",$this->input->post('work_order_product_id')));

$subcount = count($this->input->post('product_id'));      
          $data1['issue_id'] =  $issue_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($pid[$i] != ''){
            $data1['product_id'] = $pid[$i];
            $data1['specification'] = $spec[$i];
            $data1['uom'] = $uom[$i];
            $data1['required_qty'] = $rqty[$i];
            $data1['issue_qty'] = $iqty[$i];
            $data1['rawmaterial_id'] = $rmid[$i];
            $data1['work_order_product_id'] = $wopid[$i];
            //$this->db->insert('order_product',$op);

/*$stockdet = $this->Workorder_model->get_rawmaterial_stock_details_by_location_id($location_id,$rmid[$i],$iqty[$i]);
            $stcid = $stockdet->rawmaterial_stock_id;
            $stk = $stockdet->stock;
            $fstk = $stk-$iqty[$i];
            $rmstk['stock'] = $fstk;

$this->Issueregister_model->update_rawmaterial_stock_by_id($rmstk,$stcid);*/

$stockdet = $this->Workorder_model->get_rawmaterial_stock_by_location_rawmaterial_id($location_id,$rmid[$i]);
            $reqstock = $iqty[$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->Issueregister_model->create_issue_register_product($data1);

}
        }
      }

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

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

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

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

$cus_id = $order_list->customer_id;

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

$pdata['customer_phone'] = $cphone;

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

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

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

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

public function issueregister_view($id)
  {
    $data['issue_register'] = $this->Issueregister_model->get_issue_register_by_id($id);
    $data['issue_register_product'] = $this->Issueregister_model->get_issue_register_product_by_id($id);
    $this->load->view('issueregister/issueregister_view',$data);
  }

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

public function short_close()
  {
    $irId = $this->input->post('ir_id');
    
    $irlist = $this->Issueregister_model->get_issue_register_by_id ($irId);
    $ordId = $irlist->order_id;
    $woId = $irlist->work_order_id;

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

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

$irproduct = $this->Issueregister_model->get_issue_register_product_by_id($irId);
    foreach($irproduct as $irp)
    {
      $issqty = $irp['issue_qty'];
      $rmstkid = $irp['rawmaterial_stock_id'];
      $rmsstk = $this->Issueregister_model->get_rawmaterial_stock_by_id($rmstkid);

$fstk = $rmsstk->stock+$issqty;
      $rmstk['stock'] = $fstk;

$this->Issueregister_model->update_rawmaterial_stock_by_id($rmstk,$rmstkid);
    }

$this->Issueregister_model->delete_ir_product_by_id($irId);
    $this->Issueregister_model->delete_ir_by_id($irId);

$this->session->set_flashdata('add_success', 'Issue Register has been Deleted successfully.');
    redirect('/issueregister');

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Issueregister.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation