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

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

public function getledgercustomerList(){
    // POST data
    $postData = $this->input->post();

// Get data
    $data = $this->Accountreceipt_model->getledgercustomerList($postData);

echo json_encode($data);
  }

public function getBillByCompany()
  {
    $cid = $_POST['cid'];
    $fyear = $_POST['fyear'];

$fyearlist = $this->Accountreceipt_model->get_financial_year_by_id($fyear);
    $finyear = $fyearlist->financial_year;
    $finexp = explode('-', $finyear);

$finstart = $finexp[0].'-04-01';
    $finend = $finexp[1].'-03-31';

// POST data
    $postData = $this->input->post();

// Get data
    $data = $this->Accountreceipt_model->getBillByCompany($postData,$finstart,$finend);

/*$so_list = $this->Accountreceipt_model->get_super_user_account_order_list($cid);
    $inv_list = $this->Accountreceipt_model->get_super_user_account_invoice_list($cid);
    $direct_invoice = $this->Accountreceipt_model->get_super_user_direct_invoice($cid);*/

/*$so_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id AND o.location_id=$cid AND STR_TO_DATE(o.order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(o.order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    //print_r($so_list);exit;
    $inv_list = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,`order` o,customer c WHERE i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.order_id!=0 AND o.location_id=$cid AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY i.invoice_id DESC")->result_array();
    //print_r($so_list);exit;
    $direct_invoice = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,customer c WHERE i.customer_id = c.customer_id AND i.customer_id!=0 AND i.location_id=$cid AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY i.invoice_id DESC")->result_array();

$option = '';
    foreach($so_list as $vlist){
      $soreceiptTot = $this->Accountreceipt_model->get_so_receipt_total_by_so_id($vlist['order_id']);
      if($soreceiptTot->amt<$vlist['grand_total']){
        $option.="<option value=".$vlist['order_id']."-SO>".$vlist['order_no']." - ".$vlist['customer_name']."</option>";
      }
    }

if(count($inv_list)>0)
    {
      foreach($inv_list as $vlist)
      {
        $invreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($vlist['invoice_id']);
        if($invreceiptTot->amt<$vlist['grand_total'])
        {
          $option.="<option value=".$vlist['invoice_id']."-INVC>".$vlist['invoice_no']." - ".$vlist['customer_name']."</option>";
        }
      }
    }

if(count($direct_invoice)>0)
    {
      foreach($direct_invoice as $vlist)
      {
        $invreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($vlist['invoice_id']);
        if($invreceiptTot->amt<$vlist['grand_total'])
        {
          $option.="<option value=".$vlist['invoice_id']."-INV>".$vlist['invoice_no']." - ".$vlist['customer_name']."</option>";
        }
      }
    }
    echo $option;*/
    echo json_encode($data);

}

public function getBillDetails()
  {
    // POST data
    $postData = $this->input->post();

// Get data
    $data = $this->Accountreceipt_model->getBillDetails($postData);
    echo json_encode($data);

}

public function index()
  {
    $data['customer_list'] = $this->Accountjournal_model->get_customer_list();
    $data['financial_year_list'] = $this->Accountreceipt_model->get_active_financial_year();
    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_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
      }
      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_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
      }
      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_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_daterange($fdate,$tdate);
      }

$company_id = $this->input->post('company_id');
      $ledger_id = $this->input->post('ledger_id');
      $receipt_type = $this->input->post('receipt_type');
      $receipt_mode = $this->input->post('receipt_mode');

$data['company_id'] = $company_id;
      $data['ledger_id'] = $ledger_id;
      $data['receipt_type'] = $receipt_type;
      $data['receipt_mode'] = $receipt_mode;

if($company_id!='')
        $cid = 'AND ll.location_id='.$company_id;
      else
        $cid = '';

if($ledger_id!='')
        $lid = 'AND ar.ledger_list_id='.$ledger_id;
      else
        $lid = '';

if($receipt_type!='')
        $rtype = "AND ar.expense_type='".$receipt_type."'";
      else
        $rtype = '';

if($receipt_mode!='')
        $rmode = "AND ar.payment_mode='".$receipt_mode."'";
      else
        $rmode = '';

if($_SESSION['company_id']==0)
      {
        $compId = '';
        if($_SESSION['role_id']==1)
        {
          $issu = '';
        }
        else
        {
          if($_SESSION['is_super_user']==0)
          {
            $issu = 'AND ar.created_by='.$_SESSION['user_id'];
          }
          else
          {
            $issu = '';
          }
        }
      }
      else
      {
        $compId = 'AND ll.location_id='.$_SESSION['company_id'];
        if($_SESSION['is_super_user']==0)
        {
          $issu = 'AND ar.created_by='.$_SESSION['user_id'];
        }
        else
        {
          $issu = '';
        }
      }

if($this->input->post('searchChange')!='daterange')
        $data['account_receipt_list'] = $this->db->query("SELECT ar.* FROM account_receipt ar,ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date = '$curdate' $cid $lid $rtype $rmode $compId $issu ORDER BY ar.account_receipt_date DESC, ar.account_receipt_id DESC")->result_array();
      else
        $data['account_receipt_list'] = $this->db->query("SELECT ar.* FROM account_receipt ar,ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date >= '$fdate' AND ar.account_receipt_date <= '$tdate' $cid $lid $rtype $rmode $compId $issu ORDER BY ar.account_receipt_date DESC, ar.account_receipt_id DESC")->result_array();

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'; 
            $data['account_receipt_list'] = $this->db->query("SELECT ar.* FROM account_receipt ar,ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date >= '$fdate' AND ar.account_receipt_date <= '$tdate' $cid $lid $rtype $rmode $compId $issu ORDER BY ar.account_receipt_date DESC, ar.account_receipt_id DESC")->result_array();
          }
          else
          {
            $data['purchasesearch'] = 'curdate';
            $curdate = date('Y-m-d');

$data['account_receipt_list'] = $this->db->query("SELECT ar.* FROM account_receipt ar,ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date = '$curdate' $cid $lid $rtype $rmode $compId $issu ORDER BY ar.account_receipt_date DESC, ar.account_receipt_id DESC")->result_array();
          }
        }

}
    else
    {
      $curdate = date('Y-m-d');
      $data['dtrange'] = '';
      $data['atype'] = '';
      $data['aatri'] = '';
      $data['opt']= '';
      $data['drnge'] = '';
      $data['purchasesearch'] = 'curdate';
      $data['company_id'] = '';
      $data['ledger_id'] = '';
      $data['receipt_type'] = '';
      $data['receipt_mode'] = '';
      //$data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
      if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31';

$data['account_receipt_list'] = $this->db->query("SELECT ar.* FROM account_receipt ar,ledger_list ll WHERE ar.ledger_list_id = ll.ledger_list_id AND ar.account_receipt_date >= '$fdate' AND ar.account_receipt_date <= '$tdate' $cid $lid $rtype $rmode $compId $issu ORDER BY ar.account_receipt_date DESC, ar.account_receipt_id DESC")->result_array();
        }
        else
        {
          $curdate = date('Y-m-d');

if($_SESSION['company_id']==0)
          {
            if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
              $data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
            else
              $data['account_receipt_list'] = $this->Accountreceipt_model->get_user_account_receipt_by_date($curdate,$_SESSION['user_id']);
          }
          else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
          {
            $data['account_receipt_list'] = $this->Accountreceipt_model->get_user_account_receipt_by_date($curdate,$_SESSION['user_id']);
          }
          else
          {
            $data['account_receipt_list'] = $this->Accountreceipt_model->get_super_user_account_receipt_by_date($curdate,$_SESSION['company_id']);
          }
        }
      }
      else
      {
        if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            $data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
          else
            $data['account_receipt_list'] = $this->Accountreceipt_model->get_user_account_receipt_by_date($curdate,$_SESSION['user_id']);
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['account_receipt_list'] = $this->Accountreceipt_model->get_user_account_receipt_by_date($curdate,$_SESSION['user_id']);
        }
        else
        {
          $data['account_receipt_list'] = $this->Accountreceipt_model->get_super_user_account_receipt_by_date($curdate,$_SESSION['company_id']);
        }
      }
    }

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
        $data['location_list'] = $this->Ledger_model->get_location_list();
      }
      else
      {
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
        $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
    }
    else
    {
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
    }

/*$data['so_list'] = $this->Accountreceipt_model->get_account_order_list();
    $data['direct_invoice'] = $this->Accountreceipt_model->get_direct_invoice();
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['location_list'] = $this->Ledger_model->get_location_list();*/

$this->load->view('accountreceipt/accountreceipt_list',$data);
  }
  public function create_accountreceipt_page()
  {
    if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
        $data['location_list'] = $this->Ledger_model->get_location_list();
      }
      else
      {
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
        $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
    }
    else
    {
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      $data['location_list'] = $this->Accountreceipt_model->get_super_user_location_list($_SESSION['company_id']);
    }
    $data['get_all_other_ledgers'] = $this->Accountreceipt_model->get_all_other_ledgers();
    $data['get_all_other_customer'] = $this->Accountreceipt_model->get_all_other_customer();
    $data['financial_year_list'] = $this->Accountreceipt_model->get_active_financial_year();

$this->load->view('accountreceipt/create_receipt',$data);
  }
  /*public function getBillByCompany()
  {
    $cid = $_POST['cid'];
    $fyear = $_POST['fyear'];

$fyearlist = $this->Accountreceipt_model->get_financial_year_by_id($fyear);
    $finyear = $fyearlist->financial_year;
    $finexp = explode('-', $finyear);

$finstart = $finexp[0].'-04-01';
    $finend = $finexp[1].'-03-31';

$so_list = $this->db->query("SELECT o.*,c.customer_name,c.customer_code,l.location_name,au.displayname FROM `order` o,customer c,location l,admin_users au WHERE o.customer_id = c.customer_id AND o.location_id = l.location_id AND o.created_by = au.id AND o.location_id=$cid AND STR_TO_DATE(o.order_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(o.order_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') GROUP BY o.order_id ORDER BY o.order_id DESC")->result_array();
    //print_r($so_list);exit;
    $inv_list = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,`order` o,customer c WHERE i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.order_id!=0 AND o.location_id=$cid AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY i.invoice_id DESC")->result_array();
    //print_r($so_list);exit;
    $direct_invoice = $this->db->query("SELECT i.*,c.customer_name FROM invoice i,customer c WHERE i.customer_id = c.customer_id AND i.customer_id!=0 AND i.location_id=$cid AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') AND STR_TO_DATE(i.invoice_date, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') ORDER BY i.invoice_id DESC")->result_array();

}*/

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_accountreceipt()
  {

//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_receipt_date'));
      $data['account_receipt_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');

$result = $this->Accountreceipt_model->create_accountreceipt($data);

//}

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

}*/

public function create_accountreceipt()
  {
      $odt = explode('/', $this->input->post('account_receipt_date'));
      $data['account_receipt_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $data['payment_type'] = 'credit';
      $etype = $data['expense_type'] = $this->input->post('expense_type');
      //$data['particulars'] = $this->input->post('particulars');

if($etype=='others')
      {
        $pltype = explode('-', $this->input->post('parti_ledger_list_id'));
        $data['particulars'] = $this->input->post('particulars');
        //$data['parti_ledger_list_id'] = $this->input->post('parti_ledger_list_id');
        $data['parti_ledger_list_type'] = $pltype[0];
        $data['parti_ledger_list_id'] = $pltype[1];
        $data['user_id'] = 0;
        $data['user_type'] = '';
        $data['amount'] = $this->input->post('oamount');
        $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');

$result = $this->Accountreceipt_model->create_accountreceipt($data);
      }
      else
      {
        $data['particulars'] = '';
        $data['parti_ledger_list_type'] = '';
        $data['parti_ledger_list_id'] = 0;
        $amt = $this->input->post('amount');
        //print_r($this->input->post('user_id'));
        $usid = explode(",",implode(",",$this->input->post('user_id')));
        $amt = explode(",",implode(",",$this->input->post('amount')));
        //print_r($usid);exit;die();
        $subcount = count($usid);  
        for($i=0;$i<$subcount;$i++)
        {
          if($amt[$i]>0)
          {
            $uid = explode('-', $usid[$i]);
            $data['user_id'] = $uid[0];
            if($uid[1]=='SO')
            {
              $data['user_type'] = 'Sales';
              $ordList = $this->Accountreceipt_model->get_order_view_by_id($uid[0]);
              $soreceiptTot = $this->Accountreceipt_model->get_so_receipt_total_by_so_id($uid[0]);
              $tot = $ordList->grand_total - $soreceiptTot->amt;
            }
            elseif($uid[1]=='INVC')
            {
              $data['user_type'] = 'Invoice';
              $ordList = $this->Accountreceipt_model->get_invoice_view_by_id($uid[0]);
              $soreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($uid[0]);
              $tot = $ordList->grand_total - $soreceiptTot->amt;
            }
            else
            {
              $data['user_type'] = 'Invoice';
              $invList = $this->Accountreceipt_model->get_direct_invoice_view_by_id($uid[0]);
              $invreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($uid[0]);
              $tot = $invList->grand_total - $invreceiptTot->amt;
            }

/*if($amt>$tot)
            {
              $amt = $amt-$tot;
              $data['amount'] = $tot;
            }
            else
            {
              $data['amount'] = $amt;
              $amt = 0;
            }*/
            $data['amount'] = $amt[$i];

//$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');

$result = $this->Accountreceipt_model->create_accountreceipt($data);
          }
        }
      }

/*$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');

$result = $this->Accountreceipt_model->create_accountreceipt($data);*/

//}

}

public function receipt_edit()
  {
    $bid=$_POST['id'];
    /*$data['so_list'] = $this->Accountreceipt_model->get_account_order_list();
    $data['direct_invoice'] = $this->Accountreceipt_model->get_direct_invoice();
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();*/
    $data['customer_list'] = $this->Accountjournal_model->get_customer_list();

if($_SESSION['company_id']==0)
    {
      if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        $data['so_list'] = $this->Accountreceipt_model->get_account_order_list();
        $data['inv_list'] = $this->Accountreceipt_model->get_account_invoice_list();
        $data['direct_invoice'] = $this->Accountreceipt_model->get_direct_invoice();
        $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
      }
      else
      {
        $data['so_list'] = $this->Accountreceipt_model->get_user_account_order_list($_SESSION['user_id']);
        $data['inv_list'] = $this->Accountreceipt_model->get_user_account_invoice_list($_SESSION['user_id']);
        $data['direct_invoice'] = $this->Accountreceipt_model->get_user_direct_invoice($_SESSION['user_id']);
        $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
        //$data['overall_quotation'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
      }
    }
    else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {
      $data['so_list'] = $this->Accountreceipt_model->get_user_account_order_list($_SESSION['user_id']);
      $data['inv_list'] = $this->Accountreceipt_model->get_user_account_invoice_list($_SESSION['user_id']);
      $data['direct_invoice'] = $this->Accountreceipt_model->get_user_direct_invoice($_SESSION['user_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      //$data['overall_quotation'] = $this->Quotation_model->get_user_quotation_list($_SESSION['user_id']);
    }
    else
    {
      $data['so_list'] = $this->Accountreceipt_model->get_super_user_account_order_list($_SESSION['company_id']);
      $data['inv_list'] = $this->Accountreceipt_model->get_super_user_account_invoice_list($_SESSION['company_id']);
      $data['direct_invoice'] = $this->Accountreceipt_model->get_super_user_direct_invoice($_SESSION['company_id']);
      $data['ledger_list'] = $this->Accountreceipt_model->get_super_user_ledger_list_list($_SESSION['company_id']);
      //$data['overall_quotation'] = $this->Quotation_model->get_super_user_quotation_list($_SESSION['company_id']);
    }

$data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_id($bid);

$this->load->view('accountreceipt/accountreceipt_edit',$data);
  }

public function update_accountreceipt()
  {
    $data['account_receipt_id'] = $this->input->post('account_receipt_id');
    $odt = explode('/', $this->input->post('account_receipt_date'));
    $data['account_receipt_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
    $data['payment_type'] = 'credit';
    $etype = $data['expense_type'] = $this->input->post('expense_type');
    //$data['particulars'] = $this->input->post('particulars');

if($etype=='others')
    {
      $data['particulars'] = $this->input->post('particulars');
      $pltype = explode('-', $this->input->post('parti_ledger_list_id'));
      //$data['parti_ledger_list_id'] = $this->input->post('parti_ledger_list_id');
      $data['parti_ledger_list_type'] = $pltype[0];
      $data['parti_ledger_list_id'] = $pltype[1];
      $data['user_id'] = 0;
      $data['user_type'] = '';
    }
    else
    {
      $data['parti_ledger_list_type'] = '';
      $data['particulars'] = '';
      $data['parti_ledger_list_id'] = 0;
      $uid = explode('-', $this->input->post('user_id'));
      $data['user_id'] = $uid[0];
      if($uid[1]=='SO')
      {
        $data['user_type'] = 'Sales';
      }
      else
      {
        $data['user_type'] = 'Invoice';
      }
    }

$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');
//print_r($data);exit;
    $result = $this->Accountreceipt_model->update_accountreceipt($data);

//}

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

}

public function receipt_delete()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('accountreceipt/accountreceipt_delete',$data);
  }

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

public function getRemainingAmount()
  {
    $val = $_POST['id'];
    $valsplit = explode('-', $val);
    if($valsplit[1]=='SO')
    {
      $ordList = $this->Accountreceipt_model->get_order_view_by_id($valsplit[0]);
      $soreceiptTot = $this->Accountreceipt_model->get_so_receipt_total_by_so_id($valsplit[0]);
      $tot = $ordList->grand_total - $soreceiptTot->amt;
    }
    elseif($valsplit[1]=='INVC')
    {
      $ordList = $this->Accountreceipt_model->get_invoice_view_by_id($valsplit[0]);
      $soreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($valsplit[0]);
      $ssoreceiptTot = $this->Accountreceipt_model->get_so_receipt_total_by_so_id($ordList->order_id);
      $tot = $ordList->grand_total - $soreceiptTot->amt - $ssoreceiptTot->amt;
    }
    else
    {
      $invList = $this->Accountreceipt_model->get_direct_invoice_view_by_id($valsplit[0]);
      $invreceiptTot = $this->Accountreceipt_model->get_inv_receipt_total_by_inv_id($valsplit[0]);
      $tot = $invList->grand_total - $invreceiptTot->amt;
    }
    echo $tot;
  }

public function accountreceipt_print($id)
  {
    $data['accountreceipt_details'] = $this->Accountreceipt_model->get_account_receipt_by_id($id);
    $this->load->view('accountreceipt/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_rec_approve()
  {
    $data['bid']=$_POST['id'];
    $this->load->view('accountreceipt/accountreciept_approve',$data);
  }

public function AccountReceiptApprove()
  {
    $arid = $_POST['field'];
    $result = $this->Accountreceipt_model->account_receipt_approve($arid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Receipt has been Approved successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountreceipt.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation