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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Creditdebit extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Creditdebit_model','Customer_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->library("pagination");
    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', 'Credit / Debit Note');
  }

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

// Get data
    $data = $this->Creditdebit_model->getinvoicelist($postData);

echo json_encode($data);
  }

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

// Get data
    $data = $this->Creditdebit_model->getpurchaselist($postData);

echo json_encode($data);
  }

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

// Get data
    $data = $this->Creditdebit_model->getcustomerlist($postData);

echo json_encode($data);
  }

public function creditdebit_export()
  {
    $cdsearchChange = isset($_SESSION['cdsearchChange'])?$_SESSION['cdsearchChange']:'curdate';
    $cddtrange = isset($_SESSION['cddtrange'])?$_SESSION['cddtrange']:'';
    $cddtrangepicker = isset($_SESSION['cddtrangepicker'])?$_SESSION['cddtrangepicker']:'';
    $cdcompany_id = isset($_SESSION['cdcompany_id'])?$_SESSION['cdcompany_id']:'';

if($cdsearchChange=='curdate')
    {
        $curdate = date('Y-m-d');
        $data['dtrange'] = $cddtrange;
        $data['drnge'] = $cddtrangepicker;
        $data['purchasesearch'] = $cdsearchChange;
    }
    elseif($cdsearchChange=='date')
    {
        if($cddtrange!='')
        {
          $odt = explode('/', $cddtrange);
          $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
        }
        else
        {
          $curdate = date('Y-m-d');
        }
        $data['dtrange'] = $cddtrange;
        $data['drnge'] = '';
        $data['purchasesearch'] = $cdsearchChange;
    }
    else
    {
        $dtrange = $cddtrangepicker;
        $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'] = $cddtrange;
        $data['drnge'] = $cddtrangepicker;
        $data['purchasesearch'] = $cdsearchChange;
    }

if($cdcompany_id!='')
      $cid = 'AND cd.location_id='.$cdcompany_id;
    else
      $cid = '';

if($cdsearchChange!='daterange')
    {
      $credit_debit_list = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();
    }
    else
    {
      $credit_debit_list = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date >= '$fdate' AND cd.credit_debit_note_date<='$tdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();
    }

$objPHPExcel = new PHPExcel();
    $activeSheet = $objPHPExcel->getActiveSheet();
    $styleArray = array(
        'font' => array(
            'bold' => true,
            'color' => array('rgb' => '000000')
        )/*,
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
        )*/
    );

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Type');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Particulars');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Ledger');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Amount');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($credit_debit_list as $u_list ) { 
      if($u_list['ledger_list_id']!=0)
      {
        $llist = $this->Creditdebit_model->get_ledger_list_by_id($u_list['ledger_list_id']);
        $ledgerlist = $llist->location_name.' '.$llist->ledger_list;
      }
      else
      {
        $ledgerlist = '-';
      }
      if(strtolower($u_list['credit_debit'])=='credit' || strtolower($u_list['credit_debit'])=='payment')
      {
        if($u_list['particulars'] == '')
        {
          $invoice = $this->Creditdebit_model->get_invoice_by_invoice_id($u_list['type_id']);
          $parti = 'Invoice -> '.$invoice->invoice_no;
        }
        else
        {
          $customer = $this->Creditdebit_model->get_customer_by_id($u_list['customer_id']);
          $parti = $customer->customer_name.' -> '.$u_list['particulars'];
        }
      }
      else
      {
        if($u_list['particulars'] == '')
        {
          $purchase = $this->Creditdebit_model->get_purchase_by_id($u_list['type_id']);
          $parti = 'Purchase -> '.$purchase->purchase_no;
        }
        else
        {
          $vendor = $this->Creditdebit_model->get_vendor_by_id($u_list['vendor_id']);
          $parti = $vendor->vendor_name.' -> '.$u_list['particulars'];
        }
      }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($u_list['credit_debit_note_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['credit_debit']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $parti);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $ledgerlist);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['amount']);

$i++;
    }

$filename='Credit_Debit.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() . "creditdebit";
    $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['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['customer_list'] = $this->Creditdebit_model->get_customer_list();
    $data['vendor_list'] = $this->Creditdebit_model->get_vendor_list();
    $data['invoice_list'] = $this->Creditdebit_model->get_full_invoice_list();
    $data['purchase_list'] = $this->Creditdebit_model->get_purchase_list();
    $data['location_list'] = $this->Ledger_model->get_location_list();
    if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['cdsearchChange']) || isset($_SESSION['cddtrange']) || isset($_SESSION['cddtrangepicker']))))
    {

$this->session->set_userdata('cdsearchChange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['cdsearchChange']);
      $this->session->set_userdata('cddtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['cddtrange']);
      $this->session->set_userdata('cddtrangepicker', $this->input->post('dtrangepicker')!=''?$this->input->post('dtrangepicker'):$_SESSION['cddtrangepicker']);

$this->session->set_userdata('cdcompany_id', $this->input->post('company_id')!=''?$this->input->post('company_id'):$_SESSION['cdcompany_id']);
      //$this->session->set_userdata('cdsearch_change', $this->input->post('cd_search')!=''?$this->input->post('cd_search'):$_SESSION['cdsearch_change']);

$cdsearchChange = isset($_SESSION['cdsearchChange'])?$_SESSION['cdsearchChange']:$this->input->post('searchChange');
      $cddtrange = isset($_SESSION['cddtrange'])?$_SESSION['cddtrange']:$this->input->post('dtrange');
      $cddtrangepicker = isset($_SESSION['cddtrangepicker'])?$_SESSION['cddtrangepicker']:$this->input->post('dtrangepicker');
      $cdcompany_id = isset($_SESSION['cdcompany_id'])?$_SESSION['cdcompany_id']:$this->input->post('company_id');
      //$cdsearch_change = isset($_SESSION['cdsearch_change'])?$_SESSION['cdsearch_change']:$this->input->post('cd_search');

if($cdsearchChange=='curdate')
        {
            $curdate = date('Y-m-d');
            $data['dtrange'] = $cddtrange;
            $data['drnge'] = $cddtrangepicker;
            $data['purchasesearch'] = $cdsearchChange;
        }
        elseif($cdsearchChange=='date')
        {
            if($cddtrange!='')
            {
              $odt = explode('/', $cddtrange);
              $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
            }
            else
            {
              $curdate = date('Y-m-d');
            }
            $data['dtrange'] = $cddtrange;
            $data['drnge'] = '';
            $data['purchasesearch'] = $cdsearchChange;
        }
        else
        {
            $dtrange = $cddtrangepicker;
            $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'] = $cddtrange;
            $data['drnge'] = $cddtrangepicker;
            $data['purchasesearch'] = $cdsearchChange;
        }

$company_id = $this->input->post('company_id');
        $data['company_id'] = $company_id;

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

if($cdsearchChange!='daterange')
        {
            //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_date($curdate);

$data['cdlist'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();

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

$data['credit_debit_list'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC Limit $page, $perpage")->result_array();
        }
        else
        {
          //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_daterange($fdate,$tdate);

$data['cdlist'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date >= '$fdate' AND cd.credit_debit_note_date<='$tdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();

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

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['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_daterange($fdate,$tdate);

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

$data['credit_debit_list'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date >= '$fdate' AND cd.credit_debit_note_date<='$tdate' $cid ORDER BY cd.credit_debit_note_id DESC Limit $page, $perpage")->result_array();
        }
        else
        {
          $data['purchasesearch'] = $cdsearchChange;
          $curdate = date('Y-m-d');
          //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_date($curdate);

$data['cdlist'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();

$config["total_rows"] = count($data['cdlist']);
          
          $data['credit_debit_list'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC Limit $page, $perpage")->result_array();
        }
      }          
    }
    else
    {

$this->session->unset_userdata('cdsearchChange');
      $this->session->unset_userdata('cddtrange');
      $this->session->unset_userdata('cddtrangepicker');
        $curdate = date('Y-m-d');
        $data['dtrange'] = '';
        $data['drnge'] = '';
        $data['purchasesearch'] = 'curdate';
        $data['company_id'] = '';
        if(isset($_SESSION['fin2cstart']))
        {
          if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
          {
            $fdate = $_SESSION['fin2cstart'].'-04-01';
            $tdate = $_SESSION['fin2cend'].'-03-31'; 
            //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_daterange($fdate,$tdate);

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

$data['credit_debit_list'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date >= '$fdate' AND cd.credit_debit_note_date<='$tdate' $cid ORDER BY cd.credit_debit_note_id DESC Limit $page, $perpage")->result_array();
          }
          else
          {
            $curdate = date('Y-m-d');
            //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_date($curdate);

$data['cdlist'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();

$config["total_rows"] = count($data['cdlist']);
            
            $data['credit_debit_list'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else
        {
          //$data['credit_debit_list'] = $this->Creditdebit_model->get_credit_debit_list_by_date($curdate);

$data['cdlist'] = $this->db->query("SELECT cd.* FROM credit_debit_note cd WHERE cd.status!=2 AND cd.credit_debit_note_date = '$curdate' $cid ORDER BY cd.credit_debit_note_id DESC")->result_array();

$this->load->view('creditdebit/creditdebit_list',$data);
  }

public function creditdebit_create()
  {
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['customer_list'] = $this->Creditdebit_model->get_customer_list();
    $data['vendor_list'] = $this->Creditdebit_model->get_vendor_list();
    $data['invoice_list'] = $this->Creditdebit_model->get_full_invoice_list();
    $data['purchase_list'] = $this->Creditdebit_model->get_purchase_list();
    $data['location_list'] = $this->Ledger_model->get_location_list();

$this->load->view('creditdebit/creditdebit_create',$data);
  }

public function create_creditdebit()
  {
      $odt = explode('/', $this->input->post('credit_debit_note_date'));
      $data['credit_debit_note_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $crdr = $data['credit_debit'] = $this->input->post('credit_debit');
      if($crdr == 'Credit' || $crdr == 'Payment')
      {
        $invid = $this->input->post('invoice_type_id');
        if($invid=='others')
        {
            $data['debit_type'] = '';
            $data['type_id'] = 0;
            $data['other_type'] = 'Others';
            $data['customer_id'] = $this->input->post('customer_id');
            $data['vendor_id'] = 0;
            $data['particulars'] = $this->input->post('particulars');
            $data['ledger_list_id'] = $this->input->post('ledger_list_id');
            $data['location_id'] = $this->input->post('location_id');
            $data['cr_dr'] = 0;
        }
        else
        {
            $invid = $this->input->post('invoice_type_id');
            $invlist = $this->Creditdebit_model->get_invoice_by_invoice_id($invid);
            if($invlist->order_id==0)
            {
              $data['location_id'] = $invlist->location_id;
            }
            else
            {
              $ordlist = $this->Creditdebit_model->get_order_by_id($invlist->order_id);
              $data['location_id'] = $ordlist->location_id;
            }
            $data['debit_type'] = '';
            $data['type_id'] = $this->input->post('invoice_type_id');
            $data['other_type'] = '';
            $data['customer_id'] = 0;
            $data['vendor_id'] = 0;
            $data['particulars'] = '';
            $data['ledger_list_id'] = 0;
            $data['cr_dr'] = 0;
        }
      }
      elseif($crdr == 'Debit' || $crdr == 'Receipt')
      {
        $invid = $this->input->post('purchase_type_id');
        if($invid=='others')
        {
            $data['debit_type'] = '';
            $data['type_id'] = 0;
            $data['other_type'] = 'Others';
            $data['customer_id'] = 0;
            $data['vendor_id'] = $this->input->post('vendor_id');
            $data['particulars'] = $this->input->post('particulars');
            $data['ledger_list_id'] = $this->input->post('ledger_list_id');
            $data['location_id'] = $this->input->post('location_id');
            $data['cr_dr'] = 0;
        }
        else
        {
            $purid = $this->input->post('purchase_type_id');

$puridexp = explode('-', $purid);

$purlist = $this->Creditdebit_model->get_purchase_by_id($puridexp[1]);

$grnlist = $this->Creditdebit_model->get_grn_by_id($purlist->grn_id);
            $data['location_id'] = $grnlist->location_id;
            $data['debit_type'] = $puridexp[0];
            $data['type_id'] = $puridexp[1];
            $data['other_type'] = '';
            $data['customer_id'] = 0;
            $data['vendor_id'] = 0;
            $data['particulars'] = '';
            $data['ledger_list_id'] = 0;
            $data['cr_dr'] = 0;
        }
      }
      else
      {
        $ledgerlist = $this->Creditdebit_model->get_ledger_list_by_id($this->input->post('ledger_list_id'));
        $data['location_id'] = $ledgerlist->location_id;
        $data['debit_type'] = '';
        $data['type_id'] = 0;
        $data['other_type'] = '';
        $data['customer_id'] = 0;
        $data['vendor_id'] = 0;
        $data['particulars'] = '';
        $data['ledger_list_id'] = $this->input->post('ledger_list_id');
        $data['cr_dr'] = $this->input->post('cr_dr');
      }
      //$data['ledger_list_id'] = $this->input->post('ledger_list_id');
      $data['amount'] = $this->input->post('amount');
      $data['remarks'] = $this->input->post('remarks');
      $data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];

$result = $this->Creditdebit_model->create_creditdebit($data);

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

}

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

public function delete(){ 
    $bid=$_POST['field'];
    $result = $this->Creditdebit_model->creditdebit_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Credit / Debit Note has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

public function creditdebit_edit()
  {
    $cdnid=$_POST['id'];
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['customer_list'] = $this->Creditdebit_model->get_customer_list();
    $data['vendor_list'] = $this->Creditdebit_model->get_vendor_list();
    $data['invoice_list'] = $this->Creditdebit_model->get_full_invoice_list();
    $data['purchase_list'] = $this->Creditdebit_model->get_purchase_list();
    $data['location_list'] = $this->Ledger_model->get_location_list();

$data['credit_debit_note_list'] = $this->Creditdebit_model->get_credit_debit_note_by_id($cdnid);
    $this->load->view('creditdebit/creditdebit_edit',$data);
  }

public function update_creditdebit()
  {
      $data['credit_debit_note_id'] = $this->input->post('credit_debit_note_id');
      $odt = explode('/', $this->input->post('credit_debit_note_date'));
      $data['credit_debit_note_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $crdr = $data['credit_debit'] = $this->input->post('credit_debit');
      if($crdr == 'Credit' || $crdr == 'Payment')
      {
        $invid = $this->input->post('invoice_type_id');
        if($invid=='others')
        {
            $data['debit_type'] = '';
            $data['type_id'] = 0;
            $data['other_type'] = 'Others';
            $data['customer_id'] = $this->input->post('customer_id');
            $data['vendor_id'] = 0;
            $data['particulars'] = $this->input->post('particulars');
            $data['ledger_list_id'] = $this->input->post('ledger_list_id');
            $data['location_id'] = $this->input->post('location_id');
            $data['cr_dr'] = 0;
        }
        else
        {
            $invid = $this->input->post('invoice_type_id');
            $invlist = $this->Creditdebit_model->get_invoice_by_invoice_id($invid);
            if($invlist->order_id==0)
            {
              $data['location_id'] = $invlist->location_id;
            }
            else
            {
              $ordlist = $this->Creditdebit_model->get_order_by_id($invlist->order_id);
              $data['location_id'] = $ordlist->location_id;
            }
            $data['debit_type'] = '';
            $data['type_id'] = $this->input->post('invoice_type_id');
            $data['other_type'] = '';
            $data['customer_id'] = 0;
            $data['vendor_id'] = 0;
            $data['particulars'] = '';
            $data['ledger_list_id'] = 0;
            $data['cr_dr'] = 0;
        }
      }
      elseif($crdr == 'Debit' || $crdr == 'Receipt')
      {
        $invid = $this->input->post('purchase_type_id');
        if($invid=='others')
        {
            $data['debit_type'] = '';
            $data['type_id'] = 0;
            $data['other_type'] = 'Others';
            $data['customer_id'] = 0;
            $data['vendor_id'] = $this->input->post('vendor_id');
            $data['particulars'] = $this->input->post('particulars');
            $data['ledger_list_id'] = $this->input->post('ledger_list_id');
            $data['location_id'] = $this->input->post('location_id');
            $data['cr_dr'] = 0;
        }
        else
        {
            $purid = $this->input->post('purchase_type_id');

$puridexp = explode('-', $purid);

$purlist = $this->Creditdebit_model->get_purchase_by_id($puridexp[1]);

$grnlist = $this->Creditdebit_model->get_grn_by_id($purlist->grn_id);
            $data['location_id'] = $grnlist->location_id;
            $data['debit_type'] = $puridexp[0];
            $data['type_id'] = $puridexp[1];
            $data['other_type'] = '';
            $data['customer_id'] = 0;
            $data['vendor_id'] = 0;
            $data['particulars'] = '';
            $data['ledger_list_id'] = 0;
            $data['cr_dr'] = 0;
        }
      }
      else
      {
        $ledgerlist = $this->Creditdebit_model->get_ledger_list_by_id($this->input->post('ledger_list_id'));
        $data['location_id'] = $ledgerlist->location_id;
        $data['debit_type'] = '';
        $data['type_id'] = 0;
        $data['other_type'] = '';
        $data['customer_id'] = 0;
        $data['vendor_id'] = 0;
        $data['particulars'] = '';
        $data['ledger_list_id'] = $this->input->post('ledger_list_id');
        $data['cr_dr'] = $this->input->post('cr_dr');
      }
      //$data['ledger_list_id'] = $this->input->post('ledger_list_id');
      $data['amount'] = $this->input->post('amount');
      $data['remarks'] = $this->input->post('remarks');
      $data['modified_on'] = date('Y-m-d H:i:s');
      $data['modified_by'] = $_SESSION['user_id'];

$result = $this->Creditdebit_model->update_creditdebit($data);

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

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Creditdebit.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation