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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Accountcontra extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Accountcontra_model'));
    $this->load->model(array('Ledger_model'));
    $this->load->library("pagination");
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Contra');
  }

public function accountcontra_export()
  {
    $acsearchChange = isset($_SESSION['acsearchChange'])?$_SESSION['acsearchChange']:'curdate';
    $acdtrange = isset($_SESSION['acdtrange'])?$_SESSION['acdtrange']:'';
    $acdtrangepicker = isset($_SESSION['acdtrangepicker'])?$_SESSION['acdtrangepicker']:'';
    $acbid = isset($_SESSION['acbid'])?$_SESSION['acbid']:'';
    $acsearch_change = isset($_SESSION['acsearch_change'])?$_SESSION['acsearch_change']:'';

if($acsearchChange=='curdate')
    {
      $curdate = date('Y-m-d');
    }
    elseif($acsearchChange=='date')
    {
      if($acdtrange!='')
      {
        $odt = explode('/', $acdtrange);
        $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
      }
      else
      {
        $curdate = date('Y-m-d');
      }
    }
    else
    {
      $dtrange = $acdtrangepicker;
      $dr = explode(' - ', $acdtrangepicker);

$fd = explode('/', $dr[0]);
      $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
      $tdate = $td[2].'-'.$td[0].'-'.$td[1];
    }

if ($acsearch_change != '') {
      $sc = 'AND ((ac.account_contra_type LIKE "%'.$acsearch_change.'%") OR (l1.location_name LIKE "%'.$acsearch_change.'%") OR (l2.location_name LIKE "%'.$acsearch_change.'%") OR (ll1.ledger_list LIKE "%'.$acsearch_change.'%") OR (ll2.ledger_list LIKE "%'.$acsearch_change.'%"))';
    }
    else {
      $sc = '';
    }

if($acbid!='')
    {
      $bid = $data['bid'] = $acbid;
      if($acsearchChange!='daterange')
      {
        $account_contra_list = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date='$curdate' $sc ORDER BY  ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();
      }
      else
      {
        $account_contra_list = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();
      }
    }
    else
    {
      $data['bid'] = $acbid;
      if($acsearchChange!='daterange')
      {
        $account_contra_list = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date='$curdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();
      }
      else
      {
        $account_contra_list = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_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', 'Bank');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'By Ledger');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'To Ledger');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Debit');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Credit');
    $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($account_contra_list as $u_list ) { 
      if($u_list['bank1_id']!=0)
      {
        $fbank = $this->Accountcontra_model->get_bank_by_id($u_list['bank1_id']);
        $bname = $fbank->bank_name.' - '.$fbank->account_no;
      }
      else
      {
        $bname = '-';
      }
      if($u_list['bank2_id']!=0)
      {
        $tbank = $this->Accountcontra_model->get_bank_by_id($u_list['bank2_id']);
        $bname = $fbank->bank_name.' - '.$fbank->account_no.' to '.$tbank->bank_name.' - '.$tbank->account_no;
      }
      if($u_list['account_contra_type']=='withdraw' || $u_list['account_contra_type']=='transfer' || $u_list['account_contra_type']=='cash transfer'){
        $deb = $u_list['amount'];
      }
      else
      {
        $deb = '0';
      }

if($u_list['account_contra_type']=='deposit'){
        $cre = $u_list['amount'];
      }
      else
      {
        $cre = '0';
      }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($u_list['account_contra_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, ucfirst($u_list['account_contra_type']));
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $bname);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['location_name'].' - '.$u_list['ledger_list']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['l2_location_name'].' - '.$u_list['ll2_ledger_list']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($deb,2));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($cre,2));

$i++;
    }

$filename='Account_Contra.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() . "accountcontra";
    $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['bank_list'] = $this->Accountcontra_model->get_active_bank_list();    
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['acsearchChange']) || isset($_SESSION['acdtrange']) || isset($_SESSION['acdtrangepicker']) || isset($_SESSION['acbid']) || isset($_SESSION['acsearch_change']))))
    {
      //echo $this->input->post('ac_search');exit;
      $this->session->set_userdata('acsearchChange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['acsearchChange']);
      $this->session->set_userdata('acdtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['acdtrange']);
      $this->session->set_userdata('acdtrangepicker', $this->input->post('dtrangepicker')!=''?$this->input->post('dtrangepicker'):$_SESSION['acdtrangepicker']);
      $this->session->set_userdata('acbid', $this->input->post('bank_id')!=''?$this->input->post('bank_id'):$_SESSION['acbid']);
      // $this->session->set_userdata('acsearch_change', $this->input->post('ac_search')!=''?$this->input->post('ac_search'):$_SESSION['acsearch_change']);
      //$this->session->set_userdata('acsearch_change', $this->input->post('ac_search'));
      $this->session->set_userdata('acsearch_change', $this->input->post('ac_search')!=''?$this->input->post('ac_search'):$_SESSION['acsearch_change']);

$acsearchChange = isset($_SESSION['acsearchChange'])?$_SESSION['acsearchChange']:$this->input->post('searchChange');
      $acdtrange = isset($_SESSION['acdtrange'])?$_SESSION['acdtrange']:$this->input->post('dtrange');
      $acdtrangepicker = isset($_SESSION['acdtrangepicker'])?$_SESSION['acdtrangepicker']:$this->input->post('dtrangepicker');
      $acbid = isset($_SESSION['acbid'])?$_SESSION['acbid']:$this->input->post('bank_id');
      $acsearch_change = isset($_SESSION['acsearch_change'])?$_SESSION['acsearch_change']:$this->input->post('ac_search');
//echo $acsearch_change;exit;
      if($acsearchChange=='curdate')
      {
        $curdate = date('Y-m-d');
        $data['dtrange'] = $acdtrange;
        $data['drnge'] = $acdtrangepicker;
        $data['purchasesearch'] = $acsearchChange;
      }
      elseif($acsearchChange=='date')
      {
        if($acdtrange!='')
        {
          $odt = explode('/', $acdtrange);
          $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
        }
        else
        {
          $curdate = date('Y-m-d');
        }
        $data['dtrange'] = $acdtrange;
        $data['drnge'] = $acdtrangepicker;
        $data['purchasesearch'] = $acsearchChange;
      }
      else
      {
        $dtrange = $acdtrangepicker;
        $dr = explode(' - ', $acdtrangepicker);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $data['dtrange'] = $acdtrange;
        $data['drnge'] = $acdtrangepicker;
        $data['purchasesearch'] = $acsearchChange;
      }
      $data['acsearch_change'] = $acsearch_change;

if ($acsearch_change != '') {
        $sc = 'AND ((ac.account_contra_type LIKE "%'.$acsearch_change.'%") OR (l1.location_name LIKE "%'.$acsearch_change.'%") OR (l2.location_name LIKE "%'.$acsearch_change.'%") OR (ll1.ledger_list LIKE "%'.$acsearch_change.'%") OR (ll2.ledger_list LIKE "%'.$acsearch_change.'%"))';
      }
      else {
        $sc = '';
      }

if($acbid!='')
      {
        $bid = $data['bid'] = $acbid;
        if($acsearchChange!='daterange')
        {
          //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date_and_bank_id($curdate,$bid);
          $data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date='$curdate' $sc ORDER BY  ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$config["total_rows"] = count($data['aclist']);
          
          $data['account_contra_list'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC Limit $page, $perpage")->result_array();
        }
      }
      else
      {
        //$data['dtrange'] = '';
        $data['bid'] = $acbid;
        //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date($curdate);
        if($acsearchChange!='daterange')
        {
          //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date($curdate);

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date='$curdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_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'; 
          if($acbid!='')
          {
            $bid = $data['bid'] = $acbid;
            //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_daterange_and_bank_id($fdate,$tdate,$bid);

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$config["total_rows"] = count($data['aclist']);
          
          $data['account_contra_list'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else
        {
          $curdate = date('Y-m-d');
          if($acbid!='')
          {
            $bid = $data['bid'] = $acbid;
            //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date_and_bank_id($curdate,$bid);

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND (ac.bank1_id=$bid OR ac.bank2_id=$bid) AND ac.account_contra_date='$curdate' $sc ORDER BY  ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date='$curdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$curdate = date('Y-m-d');
      $data['dtrange'] = '';
      $data['drnge'] = '';
      $data['bid'] = '';
      $data['purchasesearch'] = 'curdate';
      $data['acsearch_change']='';

if(isset($_SESSION['fin2cstart']))
      {
        if($_SESSION['fin2cstart'] != $_SESSION['fin2ostart'])
        {
          $fdate = $_SESSION['fin2cstart'].'-04-01';
          $tdate = $_SESSION['fin2cend'].'-03-31'; 
          if($acbid!='')
          {
            $bid = $data['bid'] = $acbid;
            //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_daterange_and_bank_id($fdate,$tdate,$bid);

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$config["total_rows"] = count($data['aclist']);
          
          $data['account_contra_list'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date>='$fdate' AND ac.account_contra_date<='$tdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else
        {
          //$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date($curdate);
 
          $data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date='$curdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

$data['aclist'] = $this->db->query("SELECT ac.*,l1.location_name,ll1.ledger_list,l2.location_name as l2_location_name,ll2.ledger_list as ll2_ledger_list FROM `account_contra` ac, location l1,ledger_list ll1,location l2,ledger_list ll2 WHERE ac.ledger_list1_id = ll1.ledger_list_id AND ll1.location_id = l1.location_id AND ac.ledger_list2_id = ll2.ledger_list_id AND ll2.location_id = l2.location_id AND ac.account_contra_date='$curdate' $sc ORDER BY ac.account_contra_date DESC, ac.account_contra_id DESC")->result_array();

//$data['account_contra_list'] = $this->Accountcontra_model->get_account_contra_by_date($curdate);
    }
    $this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    $this->load->view('accountcontra/accountcontra_list',$data);
  }

public function accountcontra_create()
  {    
    $data['bank_list'] = $this->Accountcontra_model->get_active_bank_list();    
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $this->load->view('accountcontra/accountcontra_create',$data);
  }

public function create_accountcontra()
  {

//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_contra_date'));
      $data['account_contra_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $act = $data['account_contra_type'] = $this->input->post('account_contra_type');
      //$data['bank1_id'] = $this->input->post('bank1_id');
      if($act == 'cash transfer')
      {
        $data['bank1_id'] = 0;
        $data['bank2_id'] = 0;
      }
      else
      {
        if($act == 'transfer')
        {
          $data['bank1_id'] = $this->input->post('bank1_id');
          $data['bank2_id'] = $this->input->post('bank2_id');
        }
        else
        {
          $data['bank1_id'] = $this->input->post('bank1_id');
          $data['bank2_id'] = 0;
        }
      }
      $data['amount'] = $this->input->post('amount');
      $data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];
      $data['remarks'] = $this->input->post('remarks');
      $data['ledger_list1_id'] = $this->input->post('ledger_list1_id');
      /*if($act == 'transfer')
      {
        $data['ledger_list2_id'] = $this->input->post('ledger_list2_id');
      }
      else
      {
        $data['ledger_list2_id'] = 0;
      }*/
      $data['ledger_list2_id'] = $this->input->post('ledger_list2_id');

$result = $this->Accountcontra_model->create_accountcontra($data);

//}

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

}

public function accountcontra_edit()
  {
    $bid=$_POST['id'];
    $data['bank_list'] = $this->Accountcontra_model->get_active_bank_list();   
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['contra_list'] = $this->Accountcontra_model->get_account_contra_by_id($bid);

$this->load->view('accountcontra/accountcontra_edit',$data);
  }

public function update_accountcontra()
  {
      $odt = explode('/', $this->input->post('account_contra_date'));
      $data['account_contra_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $act = $data['account_contra_type'] = $this->input->post('account_contra_type');
      /*$data['bank1_id'] = $this->input->post('bank1_id');
      if($act == 'transfer')
      {
        $data['bank2_id'] = $this->input->post('bank2_id');
      }
      else
      {
        $data['bank2_id'] = 0;
      }*/
      if($act == 'cash transfer')
      {
        $data['bank1_id'] = 0;
        $data['bank2_id'] = 0;
      }
      else
      {
        if($act == 'transfer')
        {
          $data['bank1_id'] = $this->input->post('bank1_id');
          $data['bank2_id'] = $this->input->post('bank2_id');
        }
        else
        {
          $data['bank1_id'] = $this->input->post('bank1_id');
          $data['bank2_id'] = 0;
        }
      }
      $data['amount'] = $this->input->post('amount');
      $data['modified_on'] = date('Y-m-d H:i:s');
      $data['modified_by'] = $_SESSION['user_id'];
      $data['remarks'] = $this->input->post('remarks');
      $data['account_contra_id'] = $this->input->post('account_contra_id');
      $data['ledger_list1_id'] = $this->input->post('ledger_list1_id');
      /*if($act == 'transfer')
      {
        $data['ledger_list2_id'] = $this->input->post('ledger_list2_id');
      }
      else
      {
        $data['ledger_list2_id'] = 0;
      }*/
      $data['ledger_list2_id'] = $this->input->post('ledger_list2_id');

$result = $this->Accountcontra_model->update_accountcontra($data);

//}

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

}

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

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

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

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountcontra.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation