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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Accountpayment extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->model(array('Accountpayment_model'));
    $this->load->model(array('Daybook_model'));
    $this->load->model(array('Accountjournal_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->model(array('Voucher_model'));
    $this->load->model(array('Accountreceipt_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', 'Payment');
  }

public function index()
  {
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();
    if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      if($this->input->post('searchChange')=='curdate')
      {
        $curdate = date('Y-m-d');
        $data['dtrange'] = '';
        $data['drnge'] = '';
        $data['purchasesearch'] = 'curdate';
        //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
        if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_date($curdate,$_SESSION['company_id']);
        }
      }
      elseif($this->input->post('searchChange')=='date')
      {
        if($this->input->post('dtrange')!='')
        {
          $odt = explode('/', $this->input->post('dtrange'));
          $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
        }
        else
        {
          $curdate = date('Y-m-d');
        }
        $data['dtrange'] = $this->input->post('dtrange');
        $data['drnge'] = '';
        $data['purchasesearch'] = 'date';
        //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
        if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_date($curdate,$_SESSION['company_id']);
        }
      }
      else
      {
        $dtrange = $this->input->post('dtrangepicker');
        $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['dtrange'] = '';
        $data['drnge'] = $dtrange;
        $data['purchasesearch'] = 'daterange';
        //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange($fdate,$tdate);
        if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange($fdate,$tdate);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['user_id']);
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['user_id']);
        }
        else
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['company_id']);
        }
      }

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'; 
          if($_SESSION['company_id']==0)
          {
            if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
              $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange($fdate,$tdate);
            else
              $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['user_id']);
          }
          else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
          {
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['user_id']);
          }
          else
          {
            $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_daterange($fdate,$tdate,$_SESSION['company_id']);
          }
        }
        else
        {
          $data['purchasesearch'] = 'curdate';
          $curdate = date('Y-m-d');

/*if($this->input->post('account_type')!='')
      {
        $data['atype'] = $this->input->post('account_type');
        $aaid = $this->input->post('account_attributes_list_id');
        if($aaid!='')
        {
          //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date_and_aaid($curdate,$aaid);

if($this->input->post('searchChange')!='daterange')
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date_and_aaid($curdate,$aaid);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange_and_aaid($fdate,$tdate,$aaid);

//print_r($data['day_book_list']);exit;
          $data['aatri'] = $this->input->post('account_attributes_list_id');
        }
        else
        {
          //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
          if($this->input->post('searchChange')!='daterange')
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange($fdate,$tdate);
          $data['aatri'] = '';
        }

if($this->input->post('account_type') == 'assets')
        {
          $atid=1;
        }
        else
        {
          $atid=2;
        }
        $asscat = $this->Daybook_model->get_account_category_by_atype_id($atid);
        $option = "<option value=''>Select Attributes</option>";
        foreach($asscat as $acat)
        {
          $assattri = $this->Daybook_model->get_account_attributes_by_acat_id($acat['account_category_id']);
          $option.="<optgroup label='".$acat['account_category']."'>";
          foreach($assattri as $aattri)
          {
            $sel = $aaid==$aattri['account_attributes_id']?'selected':'';
            $option.="<option value=".$aattri['account_attributes_id']." ".$sel.">".$aattri['account_attributes']."</option>";
          }
          $option.="</optgroup>";
        }
        $data['opt'] = $option;
        //$data['opt'] = $atid;
        //print_r($data);exit;
      }
      else
      {
        $data['atype'] = '';
        $data['aatri'] = '';
        $data['opt']= '';
        //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
        if($this->input->post('searchChange')!='daterange')
          $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
        else
          $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_daterange($fdate,$tdate);
      }*/
    }
    else
    {
      $curdate = date('Y-m-d');
      $data['dtrange'] = '';
      $data['atype'] = '';
      $data['aatri'] = '';
      $data['opt']= '';
      $data['drnge'] = '';
      $data['purchasesearch'] = 'curdate';
      //$data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);

if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31';

if($_SESSION['company_id']==0)
          {
            if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
              $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
            else
              $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
          }
          else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
          {
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
          }
          else
          {
            $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_date($curdate,$_SESSION['company_id']);
          }
        }
      }
      else
      {
        if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_date($curdate);
          else
            $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_user_account_payment_by_date($curdate,$_SESSION['user_id']);
        }
        else
        {
          $data['account_payment_list'] = $this->Accountpayment_model->get_super_user_account_payment_by_date($curdate,$_SESSION['company_id']);
        }
      }
    }
    //$data['vendor_list'] = $this->Accountjournal_model->get_active_vendor();
    //$data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    //$data['vouchersubgroup_list'] = $this->Voucher_model->get_ledgersubgroup_list();

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['purchase_list'] = $this->Accountpayment_model->get_purchase_list();
        $data['expense_list'] = $this->Accountpayment_model->get_expense_list();
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
      }
      else
      {        
        $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
        $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
    else
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
        $data['staff_expense_list'] = $this->Accountpayment_model->get_staff_expense_list();

$this->load->view('accountpayment/accountpayment_list',$data);
  }

public function getUser()
  {
    $type = $_POST['value'];
    if($type == 'vendor')
    {
      $option = "<option value=''>Select Vendor</option>";
      $actvendor = $this->Accountjournal_model->get_active_vendor();
      foreach($actvendor as $aattri)
      {
        $option.="<option value=".$aattri['vendor_id'].">".$aattri['vendor_name']." - ".$aattri['contact_no']."</option>";
      }
    }
    elseif($type == 'employee')
    {
      $option = "<option value=''>Select Employee</option>";
      $actvendor = $this->Accountjournal_model->get_active_employee();
      foreach($actvendor as $aattri)
      {
        $option.="<option value=".$aattri['employee_id'].">".$aattri['display_name']." - ".$aattri['contact_no']."</option>";
      }
    }
    else
    {
      $option = "<option value=''>Select Customer</option>";
      $actvendor = $this->Accountjournal_model->get_customer_list();
      foreach($actvendor as $aattri)
      {
        $cusDetails = $this->Accountjournal_model->get_customer_contact_details($aattri['customer_id']);
        $pno = $cusDetails->phone_no;
        $option.="<option value=".$aattri['customer_id'].">".$aattri['customer_name']." - ".$pno."</option>";
      }
    }
    echo $option;
  }

public function accountjournalpaytype()
  {
    $option = "<option value=''>Select Attributes</option>";
    $type = $_POST['value'];
    if($type == 'credit' || $type == 'assets')
    {
      $atid=1;
      //$atid1=2;
    }
    else
    {
      $atid=2;
      //$atid1=1;
    }
    $asscat = $this->Accountjournal_model->get_account_category_by_atype_id($atid);
    foreach($asscat as $acat)
    {
      $assattri = $this->Accountjournal_model->get_account_attributes_by_acat_id($acat['account_category_id']);
      $option.="<optgroup label='".$acat['account_category']."'>";
      foreach($assattri as $aattri)
      {
        $option.="<option value=".$aattri['account_attributes_id'].">".$aattri['account_attributes']."</option>";
      }
      $option.="</optgroup>";
    }

/*$asscat1 = $this->Daybook_model->get_account_category_by_atype_id($atid1);
    foreach($asscat1 as $acat1)
    {
      $assattri1 = $this->Daybook_model->get_account_attributes_by_acat_id($acat1['account_category_id']);
      $option1.="<optgroup label='".$acat1['account_category']."'>";
      foreach($assattri1 as $aattri1)
      {
        $option1.="<option value=".$aattri1['account_attributes_id'].">".$aattri1['account_attributes']."</option>";
      }
      $option1.="</optgroup>";
    }*/

//echo $option."|".$option1;
    echo $option;
  }

/*public function create_accountpayment()
  {

//print_r($_POST);exit;
    //$cnt = count($this->input->post('payment_type'));
    //for($i=0;$i<$cnt;$i++)
    //{
      //$ldb = $this->Daybook_model->last_id();
      $odt = explode('/', $this->input->post('account_payment_date'));
      $data['account_payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $data['user_type'] = $this->input->post('user_type');
      $data['user_id'] = $this->input->post('user_id');
      $data['payment_type'] = strtolower($this->input->post('payment_type'));
      $data['account_attributes_id'] = $this->input->post('account_attributes_id');
      $data['amount'] = $this->input->post('amount');
      $pby = $data['payment_mode'] = $this->input->post('payment_mode');

if($pby=='cheque')
      {
        $data['cheque_no'] = $this->input->post('cheque_no');
        $data['bank_name'] = $this->input->post('bank_name');
        $data['branch_name'] = $this->input->post('branch_name');
      }
      else
      {
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
      }
      $data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];
      $data['expense_type'] = strtolower($this->input->post('expense_type'));

$result = $this->Accountpayment_model->create_accountpayment($data);

//}

if ($result) {
      $this->session->set_flashdata('add_success', 'Payment has been added successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    redirect('/accountpayment');

}*/

public function accountpayment_create()
  {
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();
    if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['purchase_list'] = $this->Accountpayment_model->get_purchase_list();
        $data['expense_list'] = $this->Accountpayment_model->get_expense_list();
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
      }
      else
      {        
        $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
        $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
    else
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
        $data['staff_expense_list'] = $this->Accountpayment_model->get_staff_expense_list();

$this->load->view('accountpayment/accountpayment_create',$data);
  }

public function create_accountpayment()
  {
      $odt = explode('/', $this->input->post('account_payment_date'));
      $data['account_payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $data['payment_type'] = 'debit';
      $etype = $data['expense_type'] = $this->input->post('expense_type');
      if($etype=='others')
      {
        $pltype = explode('-', $this->input->post('parti_ledger_list_id'));
        $data['particulars'] = $this->input->post('particulars');
        $data['parti_ledger_list_type'] = $pltype[0];
        $data['parti_ledger_list_id'] = $pltype[1];
        $data['user_id'] = 0;
      }
      elseif($etype=='vendor payment')
      {
        $data['particulars'] = '';
        $data['parti_ledger_list_type'] = '';
        $data['parti_ledger_list_id'] = 0;
        $data['user_id'] = $this->input->post('user_id');
      }
      elseif($etype=='staff expense')
      {
        $data['particulars'] = '';
        $data['parti_ledger_list_type'] = '';
        $data['parti_ledger_list_id'] = 0;
        $data['user_id'] = $this->input->post('sexp_id');
      }
      else
      {
        $data['particulars'] = '';
        $data['parti_ledger_list_type'] = '';
        $data['parti_ledger_list_id'] = 0;
        $data['user_id'] = $this->input->post('exp_id');
      }
      $data['amount'] = $this->input->post('amount');
      $pby = $data['payment_mode'] = $this->input->post('payment_mode');

if($pby=='cheque')
      {
        $data['cheque_no'] = $this->input->post('cheque_no');
        $data['bank_name'] = $this->input->post('bank_name');
        $data['branch_name'] = $this->input->post('branch_name');
      }
      else
      {
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
      }
      $data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];
      $data['ledger_list_id'] = $this->input->post('ledger_list_id');
      $data['remarks'] = $this->input->post('remarks');
      //$data['expense_type'] = strtolower($this->input->post('expense_type'));

$result = $this->Accountpayment_model->create_accountpayment($data);

//}

}

public function payment_edit()
  {
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();
    $bid=$_POST['id'];
    //$data['vendor_list'] = $this->Accountjournal_model->get_active_vendor();
    //$data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    //$data['vouchersubgroup_list'] = $this->Voucher_model->get_ledgersubgroup_list();
    $data['account_payment_list'] = $this->Accountpayment_model->get_account_payment_by_id($bid);

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['purchase_list'] = $this->Accountpayment_model->get_purchase_list();
        $data['expense_list'] = $this->Accountpayment_model->get_expense_list();
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
      }
      else
      {
        $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
        $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
    else
    {
      $data['purchase_list'] = $this->Accountpayment_model->get_user_purchase_list($_SESSION['user_id']);
      $data['expense_list'] = $this->Accountpayment_model->get_user_expense_list($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
    }
        $data['staff_expense_list'] = $this->Accountpayment_model->get_staff_expense_list();

$this->load->view('accountpayment/accountpayment_edit',$data);
  }

public function update_accountpayment()
  {
    $data['account_payment_id'] = $this->input->post('account_payment_id');
    $odt = explode('/', $this->input->post('account_payment_date'));
    $data['account_payment_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
    $data['payment_type'] = 'debit';
    $etype = $data['expense_type'] = $this->input->post('expense_type');
    if($etype=='others')
    {
      /*$data['particulars'] = $this->input->post('particulars');
      $data['parti_ledger_list_id'] = $this->input->post('parti_ledger_list_id');
      $data['user_id'] = 0;*/

$pltype = explode('-', $this->input->post('parti_ledger_list_id'));
      $data['particulars'] = $this->input->post('particulars');
      $data['parti_ledger_list_type'] = $pltype[0];
      $data['parti_ledger_list_id'] = $pltype[1];
      $data['user_id'] = 0;
    }
    elseif($etype=='vendor payment')
    {
      $data['particulars'] = '';
      $data['parti_ledger_list_type'] = '';
      $data['parti_ledger_list_id'] = 0;
      $data['user_id'] = $this->input->post('user_id');
    }
    elseif($etype=='staff expense')
    {
      $data['particulars'] = '';
      $data['parti_ledger_list_type'] = '';
      $data['parti_ledger_list_id'] = 0;
      $data['user_id'] = $this->input->post('sexp_id');
    }
    else
    {
      $data['particulars'] = '';
      $data['parti_ledger_list_type'] = '';
      $data['parti_ledger_list_id'] = 0;
      $data['user_id'] = $this->input->post('exp_id');
    }
    $data['amount'] = $this->input->post('amount');
    $pby = $data['payment_mode'] = $this->input->post('payment_mode');

if($pby=='cheque')
    {
      $data['cheque_no'] = $this->input->post('cheque_no');
      $data['bank_name'] = $this->input->post('bank_name');
      $data['branch_name'] = $this->input->post('branch_name');
    }
    else
    {
      $data['cheque_no'] = '';
      $data['bank_name'] = '';
      $data['branch_name'] = '';
    }
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['ledger_list_id'] = $this->input->post('ledger_list_id');
    $data['remarks'] = $this->input->post('remarks');
    //$data['expense_type'] = strtolower($this->input->post('expense_type'));

$result = $this->Accountpayment_model->update_accountpayment($data);

//}

if ($result) {
      $this->session->set_flashdata('add_success', 'Payment has been updated successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    redirect('/accountpayment');

}

public function payment_delete()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('accountpayment/accountpayment_delete',$data);
  }

public function delete(){ 
    $bid=$_POST['field'];
    $result = $this->Accountpayment_model->accountpayment_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Payment has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function getPurchaseRemainingAmount()
  {
    $val = $_POST['id'];
    $ordList = $this->Accountpayment_model->get_purchase_by_id($val);
    $soreceiptTot = $this->Accountpayment_model->get_pur_payment_total_by_pur_id($val);
    $tot = $ordList->total_amount - $soreceiptTot->amt;
    echo $tot;
  }

public function getExpenseRemainingAmount()
  {
    $val = $_POST['id'];
    $ordList = $this->Accountpayment_model->get_expense_by_id($val);
    $soreceiptTot = $this->Accountpayment_model->get_exp_payment_total_by_exp_id($val);
    $tot = $ordList->total_amount -$ordList->tds_value - $soreceiptTot->amt;
    echo $tot;
  }

public function getStaffExpenseRemainingAmount()
  {
    $val = $_POST['id'];
    $ordList = $this->Accountpayment_model->get_staff_expense_by_id($val);
    $soreceiptTot = $this->Accountpayment_model->get_staffexp_payment_total_by_sexp_id($val);
    //$tot = $ordList->gross_salary - $soreceiptTot->amt;
    $tot = $ordList->net_salary - $soreceiptTot->amt;
    echo $tot;
  }

public function accountpayment_print($id)
  {
    $data['accountpayment_details'] = $this->Accountpayment_model->get_account_payment_by_id($id);
    $this->load->view('accountpayment/printview',$data);
  }

public function convertToIndianCurrency($number)
  {
    $no = round($number);
    $decimal = round($number - ($no = floor($number)), 2) * 100;    
    $digits_length = strlen($no);    
    $i = 0;
    $str = array();
    $words = array(
        0 => '',
        1 => 'One',
        2 => 'Two',
        3 => 'Three',
        4 => 'Four',
        5 => 'Five',
        6 => 'Six',
        7 => 'Seven',
        8 => 'Eight',
        9 => 'Nine',
        10 => 'Ten',
        11 => 'Eleven',
        12 => 'Twelve',
        13 => 'Thirteen',
        14 => 'Fourteen',
        15 => 'Fifteen',
        16 => 'Sixteen',
        17 => 'Seventeen',
        18 => 'Eighteen',
        19 => 'Nineteen',
        20 => 'Twenty',
        30 => 'Thirty',
        40 => 'Forty',
        50 => 'Fifty',
        60 => 'Sixty',
        70 => 'Seventy',
        80 => 'Eighty',
        90 => 'Ninety');
      $digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
      while ($i < $digits_length) {
        $divider = ($i == 2) ? 10 : 100;
        $number = floor($no % $divider);
        $no = floor($no / $divider);
        $i += $divider == 10 ? 1 : 2;
        if ($number) {
            $plural = (($counter = count($str)) && $number > 9) ? 's' : null;            
            $str [] = ($number < 21) ? $words[$number] . ' ' . $digits[$counter] . $plural : $words[floor($number / 10) * 10] . ' ' . $words[$number % 10] . ' ' . $digits[$counter] . $plural;
        } else {
            $str [] = null;
        }  
    }
    
    $Rupees = implode(' ', array_reverse($str));
    $paise = ($decimal) ? "And Paise " . ($words[$decimal - $decimal%10]) ." " .($words[$decimal%10])  : '';
    return ($Rupees ? 'Rupees ' . $Rupees : '') . $paise . " Only";
  }

public function acc_pay_approve()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('accountpayment/accountpayment_approve',$data);
  }

public function AccountPaymentApprove()
  {
    $apid = $_POST['field'];
    $result = $this->Accountpayment_model->account_payment_approve($apid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Payment has been Approved successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountpayment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation