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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Staffexpense extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Staffexpense_model'));
    $this->load->model(array('Purchase_model'));
    $this->load->model(array('Invoice_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->model(array('Accountpayment_model'));
    $this->load->model(array('Expense_model'));
    $this->load->model(array('Staff_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', 'Staff Expense');
    $this->load->helper('download');
  }

public function staffexpense_export()
  {
    $staffchange = isset($_SESSION['staffchange'])?$_SESSION['staffchange']:'';
    $sexpsearch_change = isset($_SESSION['sexpsearch_change'])?$_SESSION['sexpsearch_change']:'';

if($staffchange!='')
      $ven = 'AND s.staff_id='.$staffchange;
    else
      $ven = '';
    $data['staffchange'] = $staffchange;

if ($sexpsearch_change != '') {
      $sc = 'AND (s.staff_name LIKE "%'.$sexpsearch_change.'%" OR lg.ledger_group LIKE "%'.$sexpsearch_change.'%" OR se.voucher_no LIKE "%'.$sexpsearch_change.'%")';
    }
    else {
      $sc = '';
    }

$staff_expense_list = $this->db->query("SELECT se.*,s.staff_name,lg.ledger_group FROM `staff_expense` se,staff s, ledger_group lg WHERE se.staff_id = s.staff_id AND se.ledger_group_id = lg.ledger_group_id AND se.status=0 $ven $sc ORDER BY se.staff_expense_date 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', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Staff');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Voucher No');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Nature of Expense');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Gross Salary');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Net Salary');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($staff_expense_list as $u_list ) {

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($u_list['staff_expense_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['staff_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $u_list['voucher_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['ledger_group']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($u_list['gross_salary'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($u_list['net_salary'],2));

$i++;
    }

$filename='Expense_Salary.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() . "staffexpense";
    $config["per_page"] = 10;
    $config["uri_segment"] = 2;
    $config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
    $config['full_tag_close'] = '</ul></div>';
    $config['num_tag_open'] = '<li class="page-item">';
    $config['num_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="page-item active"><a class="page-link" href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['next_tag_open'] = '<li class="page-item">';
    $config['next_tagl_close'] = '</a></li>';
    $config['prev_tag_open'] = '<li class="page-item">';
    $config['prev_tagl_close'] = '</li>';
    $config['first_tag_open'] = '<li class="page-item">';
    $config['first_tagl_close'] = '</li>';
    $config['last_tag_open'] = '<li class="page-item">';
    $config['last_tagl_close'] = '</a></li>';
    $config['attributes'] = array('class' => 'page-link');
    $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
    $perpage = $config['per_page'];

$data['staff_list'] = $this->Staffexpense_model->get_active_staff();

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['staffchange']) || isset($_SESSION['sexpsearch_change']))))
    {

$this->session->set_userdata('staffchange', $this->input->post('filterstaff')!=''?$this->input->post('filterstaff'):$_SESSION['staffchange']);
      // $this->session->set_userdata('sexpsearch_change', $this->input->post('sexp_search')!=''?$this->input->post('sexp_search'):$_SESSION['sexpsearch_change']);
      $this->session->set_userdata('sexpsearch_change', $this->input->post('sexp_search'));

$staffchange = isset($_SESSION['staffchange'])?$_SESSION['staffchange']:$this->input->post('filterstaff');
      $sexpsearch_change = isset($_SESSION['sexpsearch_change'])?$_SESSION['sexpsearch_change']:$this->input->post('sexp_search');

//$staffchange = $this->input->post('filterstaff');
      if($staffchange!='')
        $ven = 'AND s.staff_id='.$staffchange;
      else
        $ven = '';
      $data['staffchange'] = $staffchange;

if ($sexpsearch_change != '') {
        $sc = 'AND (s.staff_name LIKE "%'.$sexpsearch_change.'%" OR lg.ledger_group LIKE "%'.$sexpsearch_change.'%" OR se.voucher_no LIKE "%'.$sexpsearch_change.'%")';
      }
      else {
        $sc = '';
      }

$data['sexpsearch_change'] = $sexpsearch_change;

$data['aclist'] = $this->db->query("SELECT se.*,s.staff_name,lg.ledger_group FROM `staff_expense` se,staff s, ledger_group lg WHERE se.staff_id = s.staff_id AND se.ledger_group_id = lg.ledger_group_id AND se.status=0 $ven $sc ORDER BY se.staff_expense_date DESC")->result_array();

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

$data['staff_expense_list'] = $this->db->query("SELECT se.*,s.staff_name,lg.ledger_group FROM `staff_expense` se,staff s, ledger_group lg WHERE se.staff_id = s.staff_id AND se.ledger_group_id = lg.ledger_group_id AND se.status=0 $ven $sc ORDER BY se.staff_expense_date DESC Limit $page, $perpage")->result_array();
    }
    else
    {
      $this->session->unset_userdata('staffchange');
      $this->session->unset_userdata('sexpsearch_change');
      $data['staffchange'] = '';
      $data['sexpsearch_changes'] = '';
      //$data['staff_expense_list'] = $this->Staffexpense_model->get_staff_expense_list();

$data['aclist'] = $this->db->query("SELECT se.*,s.staff_name,lg.ledger_group FROM `staff_expense` se,staff s, ledger_group lg WHERE se.staff_id = s.staff_id AND se.ledger_group_id = lg.ledger_group_id AND se.status=0 ORDER BY se.staff_expense_date DESC")->result_array();

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

$data['staff_expense_list'] = $this->db->query("SELECT se.*,s.staff_name,lg.ledger_group FROM `staff_expense` se,staff s, ledger_group lg WHERE se.staff_id = s.staff_id AND se.ledger_group_id = lg.ledger_group_id AND se.status=0 ORDER BY se.staff_expense_date DESC Limit $page, $perpage")->result_array();
    }
    $this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    
    $this->load->view('staffexpense/staff_expense_list',$data);
  }

public function staff_expense_add()
  {
    $data['staff_list'] = $this->Staffexpense_model->get_active_staff();
    $data['exp_list'] = $this->Expense_model->get_ledgergroup_list();
    $data['location_list'] = $this->Expense_model->get_location_list();

$this->load->view('staffexpense/staff_expense_add',$data);
  }

public function getStaffDetails()
  {
    $vid = $_POST['value'];
    $venDet = $this->Staff_model->get_staff_by_id($vid);
    echo $venDet->is_esi."|".$venDet->is_epf."|".$venDet->salary_fixed."|".$venDet->basic;
  }

public function create_staff_expense()
  {
    $data['staff_id']=$this->input->post('staff_id');
    $data['salary_month'] = $this->input->post('salary_month');
    $ddt = explode('/', $this->input->post('staff_expense_date'));
    $expdate = $data['staff_expense_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['voucher_no']=$this->input->post('voucher_no'); 
    $data['ledger_group_id']=$this->input->post('ledger_group_id');
    $data['days_to_be_calculated']=$this->input->post('days_to_be_calculated');
    $data['gross_salary']=$this->input->post('gross_salary');
    $data['epf_wages']=$this->input->post('epf_wages');
    $esipay = $data['esi_amount']=$this->input->post('esi_amount');
    $epfpay = $data['epf_amount']=$this->input->post('epf_amount');
    $allow = $data['allowwance']=$this->input->post('allowance');
    $deduct = $data['deduction']=$this->input->post('deduction');
    $salpay = $data['net_salary']=$this->input->post('net_salary');
    $data['remarks']=$this->input->post('remarks');
    $lid = $data['location_id']=$this->input->post('location_id');

$last_id_value = $this->Staffexpense_model->last_id();
    if(count($last_id_value)==0)
    {
      $eno = $data['staff_expense_no'] = date("Y").'/'.date('m').'/STF-EXP001';
    }
    else
    {
      $lno = $last_id_value->staff_expense_no;
      $exlno = substr($lno,15);
      $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;
      $eno = $data['staff_expense_no'] = date("Y").'/'.date('m').'/STF-EXP'.$nval;
    }

$data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];

$result = $this->Staffexpense_model->create_staff_expense($data);

if($result)
    {
      $last_id_value = $this->Staffexpense_model->last_id();
      $last_value=$last_id_value->count_val;
      $staff_expense_id = $last_value;
      //$expense_id = $this->db->insert_id();
      if($lid == 1)
      {
        if($esipay>0)
        {
          $esipaya['staff_expense_payable_date'] = $expdate;
          $esipaya['ledger_list_id'] = 38;
          $esipaya['staff_expense_id'] = $staff_expense_id;
          $esipaya['amount'] = $esipay;
          $esipaya['created_on'] = date('Y-m-d H:i:s');
          $esipaya['created_by'] = $_SESSION['user_id'];
          $this->Staffexpense_model->insert_staff_expense_payable($esipaya);
        }

if($epfpay>0)
        {
          $epfpaya['staff_expense_payable_date'] = $expdate;
          $epfpaya['ledger_list_id'] = 39;
          $epfpaya['staff_expense_id'] = $staff_expense_id;
          $epfpaya['amount'] = $epfpay;
          $epfpaya['created_on'] = date('Y-m-d H:i:s');
          $epfpaya['created_by'] = $_SESSION['user_id'];
          $this->Staffexpense_model->insert_staff_expense_payable($epfpaya);
        }
      }

if($allow>0)
      {
        $salallow['staff_allowance_deduction_date'] = $expdate;
        if($lid==1)
          $salallow['ledger_list_id'] = 186;
        elseif($lid==2)
          $salallow['ledger_list_id'] = 227;
        else
          $salallow['ledger_list_id'] = 228;
        $salallow['staff_expense_id'] = $staff_expense_id;
        $salallow['type'] = 'Allowance';
        $salallow['amount'] = $allow;
        $salallow['created_on'] = date('Y-m-d H:i:s');
        $salallow['created_by'] = $_SESSION['user_id'];
        $this->Staffexpense_model->insert_staff_allowance_deduction($salallow);
      }

if($deduct>0)
      {
        $saldeduct['staff_allowance_deduction_date'] = $expdate;
        if($lid==1)
          $saldeduct['ledger_list_id'] = 40;
        elseif($lid==2)
          $saldeduct['ledger_list_id'] = 229;
        else
          $saldeduct['ledger_list_id'] = 230;
        $saldeduct['staff_expense_id'] = $staff_expense_id;
        $saldeduct['type'] = 'Deduction';
        $saldeduct['amount'] = $deduct;
        $saldeduct['created_on'] = date('Y-m-d H:i:s');
        $saldeduct['created_by'] = $_SESSION['user_id'];
        $this->Staffexpense_model->insert_staff_allowance_deduction($saldeduct);
      }

if($salpay>0)
      {
        $salpaya['staff_expense_payable_date'] = $expdate;
        if($lid==1)
          $salpaya['ledger_list_id'] = 22;
        elseif($lid==2)
          $salpaya['ledger_list_id'] = 177;
        else
          $salpaya['ledger_list_id'] = 226;
        $salpaya['staff_expense_id'] = $staff_expense_id;
        $salpaya['amount'] = $salpay;
        $salpaya['created_on'] = date('Y-m-d H:i:s');
        $salpaya['created_by'] = $_SESSION['user_id'];
        $this->Staffexpense_model->insert_staff_expense_payable($salpaya);
      }
      $this->session->set_flashdata('add_success', 'Expense Salary has been added successfully.');
      redirect('/staffexpense');
    }
  }

public function staff_expense_view($id)
  {
    $edpdet = $data['staff_expense_details'] = $this->Staffexpense_model->get_staff_expense_by_id($id);
    $data['location_details'] = $this->Staffexpense_model->get_location_by_id($edpdet->location_id);
    $this->load->view('staffexpense/staff_expense_view',$data);
  }

public function staff_expense_edit($id)
  {
    $data['staff_list'] = $this->Staffexpense_model->get_active_staff();
    $data['exp_list'] = $this->Expense_model->get_ledgergroup_list();
    $data['location_list'] = $this->Expense_model->get_location_list();
    $sedet = $data['staff_expense_details'] = $this->Staffexpense_model->get_staff_expense_by_id($id);
    $data['staff_details'] = $this->Staff_model->get_staff_by_id($sedet->staff_id);
    $this->load->view('staffexpense/staff_expense_edit',$data);
  }

public function update_staff_expense()
  {
    $seid = $data['staff_expense_id']=$this->input->post('staff_expense_id');
    $data['staff_id']=$this->input->post('staff_id');
    $data['salary_month'] = $this->input->post('salary_month');
    $ddt = explode('/', $this->input->post('staff_expense_date'));
    $expdate = $data['staff_expense_date'] = $ddt[2].'-'.$ddt[0].'-'.$ddt[1];  
    $data['voucher_no']=$this->input->post('voucher_no'); 
    $data['ledger_group_id']=$this->input->post('ledger_group_id');
    $data['days_to_be_calculated']=$this->input->post('days_to_be_calculated');
    $data['gross_salary']=$this->input->post('gross_salary');
    $data['epf_wages']=$this->input->post('epf_wages');
    $esipay = $data['esi_amount']=$this->input->post('esi_amount');
    $epfpay = $data['epf_amount']=$this->input->post('epf_amount');
    $allow = $data['allowwance']=$this->input->post('allowance');
    $deduct = $data['deduction']=$this->input->post('deduction');
    $salpay = $data['net_salary']=$this->input->post('net_salary');
    $data['remarks']=$this->input->post('remarks');
    $lid = $data['location_id']=$this->input->post('location_id');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];

$result = $this->Staffexpense_model->update_staff_expense($data);

if($result)
    {
      /*$last_id_value = $this->Staffexpense_model->last_id();
      $last_value=$last_id_value->count_val;*/
      $staff_expense_id = $seid;
      //$expense_id = $this->db->insert_id();
      $this->Staffexpense_model->delete_staff_expense_payable_by_staff_expense_id($staff_expense_id);
      $this->Staffexpense_model->delete_staff_allowance_deduction_by_staff_expense_id($staff_expense_id);
      if($lid == 1)
      {
        if($esipay>0)
        {
          $esipaya['staff_expense_payable_date'] = $expdate;
          $esipaya['ledger_list_id'] = 38;
          $esipaya['staff_expense_id'] = $staff_expense_id;
          $esipaya['amount'] = $esipay;
          $esipaya['created_on'] = date('Y-m-d H:i:s');
          $esipaya['created_by'] = $_SESSION['user_id'];
          $this->Staffexpense_model->insert_staff_expense_payable($esipaya);
        }

if($salpay>0)
      {
        $salpaya['staff_expense_payable_date'] = $expdate;
        if($lid==1)
          $salpaya['ledger_list_id'] = 22;
        elseif($lid==2)
          $salpaya['ledger_list_id'] = 177;
        else
          $salpaya['ledger_list_id'] = 226;
        $salpaya['staff_expense_id'] = $staff_expense_id;
        $salpaya['amount'] = $salpay;
        $salpaya['created_on'] = date('Y-m-d H:i:s');
        $salpaya['created_by'] = $_SESSION['user_id'];
        $this->Staffexpense_model->insert_staff_expense_payable($salpaya);
      }
      $this->session->set_flashdata('add_success', 'Expense Salary has been updated successfully.');
      redirect('/staffexpense');
    }
  }

public function staff_exp_delete()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('staffexpense/staff_expense_delete',$data);
  }

public function staffexpenseDelete(){ 
    $bid=$_POST['field'];
    $result = $this->Staffexpense_model->staff_expense_delete($bid);
    if ($result) {
      $this->Staffexpense_model->delete_staff_expense_payable_by_staff_expense_id($bid);
      $this->Staffexpense_model->delete_staff_allowance_deduction_by_staff_expense_id($bid);
      $this->session->set_flashdata('add_success', 'Expense Salary has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function staff_ledger($sid)
  {
    $data['staff_details'] = $this->Staff_model->get_staff_by_id($sid);
    $data['ledger_list'] = $this->db->query("(SELECT staff_expense_date as pdate,voucher_no,net_salary as amount,'credit' as payment_type FROM staff_expense WHERE staff_id=$sid AND status=0)UNION(SELECT ap.account_payment_date as pdate, '' as voucher_no, ap.amount,ap.payment_type FROM account_payment ap,staff_expense se WHERE ap.user_id = se.staff_expense_id AND se.staff_id = $sid AND ap.expense_type = 'staff expense' AND ap.status=0) ORDER BY pdate ASC")->result_array();

$this->load->view('staffexpense/staff_ledger',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Staffexpense.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation