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

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

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

// Get data
    $data = $this->Accountjournal_model->getledgercustomervendorList($postData);

echo json_encode($data);
  }

public function accountjournal_export()
  {
    $ajsearchChange = isset($_SESSION['ajsearchChange'])?$_SESSION['ajsearchChange']:'curdate';
    $ajdtrange = isset($_SESSION['ajdtrange'])?$_SESSION['ajdtrange']:'';
    $ajdtrangepicker = isset($_SESSION['ajdtrangepicker'])?$_SESSION['ajdtrangepicker']:'';
    $ajsearch_change = isset($_SESSION['ajsearch_change'])?$_SESSION['ajsearch_change']:'';
    $ajcomp_id = isset($_SESSION['ajcomp_id'])?$_SESSION['ajcomp_id']:'';

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

if ($ajsearch_change != '') {
      $sc = 'AND (l.location_name LIKE "%'.$ajsearch_change.'%")';
    }
    else {
      $sc = '';
    }

if($ajcomp_id!='all')
    {
      $cid = 'AND aj.location_id = '.$ajcomp_id;
    }
    else
    {
      $cid='';
    }

if($_SESSION['company_id']==0)
    {

if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
      {
        if($ajsearchChange!='daterange'){
          $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid ORDER BY aj.account_journal_id DESC")->result_array();
        }
        else {
          $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();
        }
      }
      else
      {
        if($ajsearchChange!='daterange'){
          $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();
        }
        else {
          $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();
        }
      }
    }

else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
    {

if($ajsearchChange!='daterange') {
        $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();
      }
      else {
        $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();
      }
    }
    else
    {
      if($ajsearchChange!='daterange') {
        $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC")->result_array();
      }
      else {
        $account_journal_list = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_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', 'Company');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'By Ledger');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'To 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 ($account_journal_list as $u_list ) { 
      if($u_list['ledger_list1_type']=='ledger')
      {
        $byledger = $this->Ledger_model->get_ledger_list_by_id($u_list['ledger_list1_id']);
        $bledger = $byledger->location_name.' - '.$byledger->ledger_list;
      }
      elseif($u_list['ledger_list1_type']=='customer')
      {
        $byledger = $this->Accountjournal_model->get_customer_view_by_id($u_list['ledger_list1_id']);
        $bledger = $byledger->customer_name;
      }
      else
      {
        $byledger = $this->Accountjournal_model->get_vendor_by_id($u_list['ledger_list1_id']);
        $bledger = $byledger->vendor_name.' - '.$byledger->contact_no;
      }

if($u_list['ledger_list2_type']=='ledger')
      {
        $toledger = $this->Ledger_model->get_ledger_list_by_id($u_list['ledger_list2_id']);
        $tledger = $toledger->location_name.' - '.$toledger->ledger_list;
      }
      elseif($u_list['ledger_list2_type']=='customer')
      {
        $toledger = $this->Accountjournal_model->get_customer_view_by_id($u_list['ledger_list2_id']);
        $tledger = $toledger->customer_name;
      }
      else
      {
        $toledger = $this->Accountjournal_model->get_vendor_by_id($u_list['ledger_list2_id']);
        $tledger = $toledger->vendor_name.' - '.$toledger->contact_no;
      }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($u_list['account_journal_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['location_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $bledger);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $tledger);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($u_list['amount'],2));

$i++;
    }

$filename='Account_Journal.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()
  {   
//$this->output->enable_profiler(TRUE);
    $config = array();
    $config["base_url"] = base_url() . "accountjournal";
    $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->Accountjournal_model->get_customer_list();
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();
    // echo "hii";
    // die();
    if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['ajsearchChange']) || isset($_SESSION['ajdtrange']) || isset($_SESSION['ajdtrangepicker']) || isset($_SESSION['ajsearch_change']) || isset($_SESSION['ajcomp_id']))))
    {

$this->session->set_userdata('ajsearchChange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['ajsearchChange']);
      $this->session->set_userdata('ajdtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['ajdtrange']);
      $this->session->set_userdata('ajdtrangepicker', $this->input->post('dtrangepicker')!=''?$this->input->post('dtrangepicker'):$_SESSION['ajdtrangepicker']);
      $this->session->set_userdata('ajcomp_id', $this->input->post('company_id')!=''?$this->input->post('company_id'):$_SESSION['ajcomp_id']);
      //$this->session->set_userdata('ajsearch_change', $this->input->post('aj_search')!=''?$this->input->post('aj_search'):$_SESSION['ajsearch_change']);
      $this->session->set_userdata('ajsearch_change', $this->input->post('aj_search'));

$ajsearchChange = isset($_SESSION['ajsearchChange'])?$_SESSION['ajsearchChange']:$this->input->post('searchChange');
      $ajdtrange = isset($_SESSION['ajdtrange'])?$_SESSION['ajdtrange']:$this->input->post('dtrange');
      $ajdtrangepicker = isset($_SESSION['ajdtrangepicker'])?$_SESSION['ajdtrangepicker']:$this->input->post('dtrangepicker');
      $ajsearch_change = isset($_SESSION['ajsearch_change'])?$_SESSION['ajsearch_change']:$this->input->post('aj_search');
      $ajcomp_id = isset($_SESSION['ajcomp_id'])?$_SESSION['ajcomp_id']:$this->input->post('company_id');

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

if ($ajsearch_change != '') {
        $sc = 'AND (l.location_name LIKE "%'.$ajsearch_change.'%")';
      }
      else {
        $sc = '';
      }

if($ajcomp_id!='all')
      {
        $cid = 'AND aj.location_id='.$ajcomp_id;
      }
      else
      {
        $cid = '';
      }

if($_SESSION['company_id']==0)
        {

if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
          {
            if($ajsearchChange!='daterange'){
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_date($curdate);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
            else {
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_daterange($fdate,$tdate);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
          }
          else
          {
            if($ajsearchChange!='daterange'){
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
            else {
              // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_daterange($fdate,$tdate,$_SESSION['user_id']);
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

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

$data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
          }
        }

else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {

if($ajsearchChange!='daterange') {
            // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
          else {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_daterange($fdate,$tdate,$_SESSION['user_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else
        {
          if($ajsearchChange!='daterange') {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_super_user_account_journal_by_date($curdate,$_SESSION['company_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
          else {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_super_user_account_journal_by_daterange($fdate,$tdate,$_SESSION['company_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->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($_SESSION['company_id']==0){
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_daterange($fdate,$tdate);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage ")->result_array();
            }
            else{
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_super_user_account_journal_by_daterange($fdate,$tdate,$_SESSION['company_id']);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
          }
          else
          {
            
            $curdate = date('Y-m-d');

if($_SESSION['company_id']==0)
            {
              if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
              {
                $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
                // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_date($curdate);
                $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
              }
              else
              {
                $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
                // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
                $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
              }
            }
            else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
            {
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
            else
            {
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc $cid AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

//}

$data['ajsearch_change']=$ajsearch_change;
    }
    else
    {
      $this->session->unset_userdata('ajsearchChange');
      $this->session->unset_userdata('ajdtrange');
      $this->session->unset_userdata('ajdtrangepicker');
      $this->session->unset_userdata('ajsearch_change');
      $this->session->unset_userdata('ajcomp_id');
      
      $curdate = date('Y-m-d');
      $data['dtrange'] = '';
      //$data['atype'] = '';
      //$data['aatri'] = '';
      //$data['opt']= '';
      $data['drnge'] = '';
      $data['purchasesearch'] = 'curdate';
      $data['ajsearch_change']='';
      $data['company_id']='';
      //$data['account_journal_list'] = $this->Accountjournal_model->get_accont_journal_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){
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_daterange($fdate,$tdate);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
          else{
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_super_user_account_journal_by_daterange($fdate,$tdate,$_SESSION['company_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date >= '$fdate' AND aj.account_journal_date <= '$tdate' $sc AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_date DESC, aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else
        {
          $curdate = date('Y-m-d');

if($_SESSION['company_id']==0)
          {
            if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
            {
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_date($curdate);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
            else
            {
              $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
              // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
              $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
            }
          }
          else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
          {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
          else
          {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

if($_SESSION['company_id']==0)
        {
          if($_SESSION['role_id']==1 || $_SESSION['is_super_user']==1)
          {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_date($curdate);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
          else
          {
            $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
            // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
            $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
          }
        }
        else if($_SESSION['company_id']!=0 && $_SESSION['is_super_user']==0)
        {
          $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

$config["total_rows"] = count($data['ajlist']);
          // $data['account_journal_list'] = $this->Accountjournal_model->get_user_account_journal_by_date($curdate,$_SESSION['user_id']);
          $data['account_journal_list'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.created_by='".$_SESSION['user_id']."' ORDER BY aj.account_journal_id DESC Limit $page, $perpage")->result_array();
        }
        else
        {
          $data['ajlist'] = $this->db->query("SELECT aj.*,l.location_name FROM account_journal aj,location l WHERE l.location_id = aj.location_id AND aj.account_journal_date = '$curdate' $sc AND aj.location_id = '".$_SESSION['company_id']."' ORDER BY aj.account_journal_id DESC")->result_array();

}

$data['vendor_list'] = $this->Accountjournal_model->get_active_vendor();
    //$data['location_list'] = $this->Accountjournal_model->get_location_list();
    if($_SESSION['company_id']==0){
      $data['location_list'] = $this->Accountjournal_model->get_location_list();
    }
    else{
      $data['location_list'] = $this->Accountjournal_model->get_location_by_comp_id($_SESSION['company_id']);
    }
    $this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    $this->load->view('accountjournal/accountjournal_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 == '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>";
    }
    echo $option;
  }

public function accountjournal_create()
  {
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();
    $data['customer_list'] = $this->Accountjournal_model->get_customer_list();
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();
    if($_SESSION['company_id']==0){
      $data['location_list'] = $this->Accountjournal_model->get_location_list();
    }
    else{
      $data['location_list'] = $this->Accountjournal_model->get_location_by_comp_id($_SESSION['company_id']);
    }
    $this->load->view('accountjournal/accountjournal_create',$data);
  }

public function create_accountjournal()
  {

//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_journal_date'));
      $data['account_journal_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $data['location_id'] = $this->input->post('location_id');
      $data['created_on'] = date('Y-m-d H:i:s');
      $data['created_by'] = $_SESSION['user_id'];
      $data['type'] = '';
      $data['account_attributes_id'] = '0';
      //$data['amount'] = $this->input->post('amount');
      $data['paid_status'] = 0;
      $pby = $data['payment_mode'] = '';
      //if($pby=='cheque')
      //{
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 0;
      /*}
      else if($pby=='cash')
      {
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 0;
      }
      else
      {        
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 0;
      }*/
      $data['remarks'] = $this->input->post('remarks');
      if($this->input->post('ledger_list1_id')!='')
      {
        $ll1id = explode(",",implode(",",$this->input->post('ledger_list1_id')));
        $ll2id = explode(",",implode(",",$this->input->post('ledger_list2_id')));
        $amt = explode(",",implode(",",$this->input->post('amount')));
        $subcount = count($this->input->post('ledger_list1_id')); 
        for($i=0;$i<$subcount;$i++)
        {
          $ll1 = explode('-', $ll1id[$i]);
          $ll2 = explode('-', $ll2id[$i]);
          //print_r($ll1);echo "<br><br>";print_r($ll2);echo "<br><br>";
          $data['ledger_list1_type'] = $ll1[0];
          $data['ledger_list1_id'] = $ll1[1];
          $data['ledger_list2_type'] = $ll2[0];
          $data['ledger_list2_id'] = $ll2[1];
          $data['amount'] = $amt[$i];
          $result = $this->Accountjournal_model->create_accountjournal($data);
        }
      }

//$result = $this->Accountjournal_model->create_accountjournal($data);

//}

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

}

public function accountjournal_edit()
  {
    $bid=$_POST['id'];
    //$data['vendor_list'] = $this->Accountjournal_model->get_active_vendor();
    $data['location_list'] = $this->Accountjournal_model->get_location_list();   
    $data['ledger_list'] = $this->Ledger_model->get_ledger_list_list();    
    $data['customer_list'] = $this->Accountjournal_model->get_customer_list();
    $data['vendor_list'] = $this->Accountjournal_model->get_vendor_list();

$ajlist = $data['account_journal_list'] = $this->Accountjournal_model->get_account_journal_by_id($bid);

$option = "<option value=''>Select Attributes</option>";
    $type = $ajlist->type;
    if($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)
      {
        if($aattri['account_attributes_id'] == $ajlist->account_attributes_id)
        {
          $sel = ' selected';
        }
        else
        {
          $sel = '';
        }
        $option.="<option value=".$aattri['account_attributes_id'].$sel.">".$aattri['account_attributes']."</option>";
      }
      $option.="</optgroup>";
    }
    $data['option'] = $option;

$this->load->view('accountjournal/accountjournal_edit',$data);
  }

public function update_accountjournal()
  {
      $data['account_journal_id'] = $this->input->post('account_journal_id');
      $odt = explode('/', $this->input->post('account_journal_date'));
      $data['account_journal_date'] = $odt[2].'-'.$odt[0].'-'.$odt[1];
      $data['type'] = '';
      $data['account_attributes_id'] = 0;
      $data['amount'] = $this->input->post('amount');
      $data['paid_status'] = 0;
      $pby = $data['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');
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 7;
      }
      else if($pby=='cash')
      {
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 6;
      }
      else
      {        
        $data['cheque_no'] = '';
        $data['bank_name'] = '';
        $data['branch_name'] = '';
        $data['vendor_id'] = 0;
        $data['others'] = '';
        $data['attributes_id'] = 0;
      }
      $data['remarks'] = $this->input->post('remarks');
      $data['location_id'] = $this->input->post('location_id');
      $data['modified_on'] = date('Y-m-d H:i:s');
      $data['modified_by'] = $_SESSION['user_id'];
      //$data['ledger_list1_id'] = $this->input->post('ledger_list1_id');
      //$data['ledger_list2_id'] = $this->input->post('ledger_list2_id');

$ll1 = explode('-', $this->input->post('ledger_list1_id'));
      $ll2 = explode('-', $this->input->post('ledger_list2_id'));
      $data['ledger_list1_type'] = $ll1[0];
      $data['ledger_list1_id'] = $ll1[1];
      $data['ledger_list2_type'] = $ll2[0];
      $data['ledger_list2_id'] = $ll2[1];

$result = $this->Accountjournal_model->update_accountjournal($data);

//}

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

}

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

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

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

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

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountjournal.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation