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

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

public function change_notification_read()
  {
    $noti_id = $_POST['id'];
    /*$cond = " * FROM notification WHERE notification_id = $noti_id ";
    $get_user = select_table_with_condition('notification', $cond);*/
    $get_user = $this->db->query("SELECT * FROM notification WHERE notification_id = ".$noti_id)->result();
    $user_id = $get_user[0]->read_status_id;

/*if($user_id != '')
    {
      $users = array_unique(explode(",",$user_id));
     $ruid='';
      foreach ($users as $user) {
         if($user == $_SESSION['user_id'])
         {
           // nothing
         }
         else{
          $ruid.=$user.",";
         }
      }
      $rstid = $ruid.$_SESSION['user_id'];
    }
    else{*/
      $rstid = $_SESSION['user_id'];
    //}
    $nid = $get_user[0]->notification_id;
    /*$stval = " read_status_id = '$rstid' ";
    $cond = " notification_id = $nid ";
    update_table('notification', $stval, $cond);*/
    $this->db->query("UPDATE notification SET read_status_id='".$rstid."' WHERE notification_id=".$nid);
    echo 1;
  }

public function index()
  {
    $data['liabilities_list'] = $this->Balancesheet_model->get_liabilities_list();
    $data['assets_list'] = $this->Balancesheet_model->get_assets_list();
    $data['location_list'] = $this->Balancesheet_model->get_location_list();

if($_SERVER['REQUEST_METHOD'] == 'POST')
    {
      if($this->input->post('searchChange')=='all')
      {
        $curdate = '';
        $data['dtrange'] = '';
        $data['drnge'] = '';
        $data['purchasesearch'] = 'all';
        //$data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
      }
      elseif($this->input->post('searchChange')=='date')
      {
        if($this->input->post('dtrange')!='')
        {
          $odt = explode('/', $this->input->post('dtrange'));
          $curdate = $odt[2].'-'.$odt[0].'-'.$odt[1];
        }
        else
        {
          $curdate = date('Y-m-d');
        }
        $data['dtrange'] = $this->input->post('dtrange');
        $data['drnge'] = '';
        $data['purchasesearch'] = 'date';
        //$data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_date($curdate);
      }
      else
      {
        $dtrange = $this->input->post('dtrangepicker');
        $dr = explode(' - ', $dtrange);

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

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];
        $data['dtrange'] = '';
        $data['drnge'] = $dtrange;
        $data['purchasesearch'] = 'daterange';
        //$data['account_receipt_list'] = $this->Accountreceipt_model->get_account_receipt_by_daterange($fdate,$tdate);
      }
      $company_id = $this->input->post('filter_company_id');
      $filter_accounts_module = $this->input->post('filter_accounts_module');
      $data['company_id'] = $company_id;
      $data['filter_accounts_module'] = $filter_accounts_module;

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

if($filter_accounts_module!='')
        $fam = 'AND acj.accounts_module="'.$filter_accounts_module.'"';
      else
        $fam = '';

if($this->input->post('searchChange')=='all')
      {
        $data['account_job_list'] = $this->db->query("SELECT acj.*,l.location_name FROM accounts_cron_job acj,location l WHERE l.location_id = acj.company_id $cid $fam ORDER BY acj.accounts_cron_job_id DESC")->result_array();
      }
      elseif($this->input->post('searchChange')=='date')
      {
        $data['account_job_list'] = $this->db->query("SELECT acj.*,l.location_name FROM accounts_cron_job acj,location l WHERE l.location_id = acj.company_id AND DATE(acj.created_on) = '$curdate' $cid $fam ORDER BY acj.accounts_cron_job_id DESC")->result_array();
      }
      else
      {
        $data['account_job_list'] = $this->db->query("SELECT acj.*,l.location_name FROM accounts_cron_job acj,location l WHERE l.location_id = acj.company_id AND DATE(acj.created_on) >= '$fdate' AND DATE(acj.created_on) <= '$tdate' $cid $fam ORDER BY acj.accounts_cron_job_id DESC")->result_array();
      }

}
    else
    {
      $data['company_id'] = '';
      $data['filter_accounts_module'] = '';
      $data['dtrange'] = '';
      $data['drnge'] = '';
      $data['purchasesearch'] = 'all';

$data['account_job_list'] = $this->Accountsjob_model->get_account_job_list();
    }

//$data['processing_account_job_list'] = $this->Accountsjob_model->get_processing_account_job_list();
    $data['processing_account_job_list'] = $this->db->query("SELECT * FROM accounts_cron_job WHERE status!=2")->row();

$this->load->view('accountsjob/accountsjob_list',$data);
  }

public function create()
  {
    $data['accounts_module'] = $this->input->post('accounts_module');
    $data['company_id'] = $this->input->post('company_id');
    $fdate = $this->input->post('from_date');
    $fd = explode('/', $fdate);
    $data['from_date'] = $fd[2].'-'.$fd[0].'-'.$fd[1];
    $tdate = $this->input->post('to_date');
    $td = explode('/', $tdate);
    $data['to_date'] = $td[2].'-'.$td[0].'-'.$td[1];
    $data['opening_stock'] = $this->input->post('opening_stock');
    $data['closing_stock'] = $this->input->post('closing_stock');
    $data['profit_and_loss'] = $this->input->post('profit_and_loss');
    $data['status'] = 0;
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id'];
    $data['balance_type'] = $this->input->post('balance_type');
    $data['with_zero_balance'] = $this->input->post('with_zero_balance');

$check_record = $this->db->query("SELECT * FROM accounts_cron_job WHERE accounts_module='".$data['accounts_module']."' AND company_id='".$data['company_id']."' AND from_date='".$data['from_date']."' AND to_date='".$data['to_date']."'")->row();
    if(count($check_record)==0)
    {    
      $check_record1 = $this->db->query("SELECT * FROM accounts_cron_job WHERE status=0")->row();
      if(count($check_record1)==0)
      {
        $result = $this->Accountsjob_model->create_accounts_job($data);
        if ($result) {
          $this->session->set_flashdata('add_success', 'Job added.');
        }
        else{
          $this->session->set_flashdata('add_err', 'Something went wrong');
        }
      }
      else
      {
        $this->session->set_flashdata('add_err', 'Already Process in Queue!');
      }
    }
    else
    {
      $this->session->set_flashdata('add_err', 'Record Already Available!');
    }
    redirect('/accountsjob');
  }

public function view($acjid)
  {
    $data['account_job_list'] = $this->Accountsjob_model->get_account_job_by_id($acjid);
    $this->load->view('accountsjob/accountsjob_view',$data);
  }

public function accountsjob_export($acjid)
  {
    $account_job_list = $this->Accountsjob_model->get_account_job_by_id($acjid);

//Balance Sheet Start
    if($account_job_list->accounts_module=='Balance Sheet')
    {
      $liabilities_list = $this->Accountsjob_model->get_accounts_job_left_result($account_job_list->accounts_cron_job_id);
      $assets_list = $this->Accountsjob_model->get_accounts_job_right_result($account_job_list->accounts_cron_job_id);

$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', 'Liabilities');
        $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Amount');
        $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$var = 'B';$j=2; $gvar = 'B';$svar = 'E';$ltot=0;foreach($liabilities_list as $llist){
          if($llist['main_title']!=''){
            $objPHPExcel->getActiveSheet()->setCellValue('B'.$j, $llist['main_title']);
              $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
              $j++;
          }
          if($llist['sub_title']!=''){
          $inner_title_list = $this->db->query("SELECT * FROM accounts_cron_job_result WHERE parent_id = ".$llist['accounts_cron_job_result_id'])->result_array();

$objPHPExcel->getActiveSheet()->setCellValue('C'.$j, $llist['sub_title']);
                $objPHPExcel->getActiveSheet()->getStyle('C'.$j)->applyFromArray($styleArray);
                $objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $llist['amount_1']);
                $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);

foreach($inner_title_list as $itlist){
                $j++;
                  $objPHPExcel->getActiveSheet()->setCellValue('D'.$j, $itlist['inner_title']);
                    $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('E'.$j, round($itlist['amount_1']));
                    $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);
                }
                $ltot+=$llist['amount_1'];
        $j++;}
      $gvar = 'B';$svar = 'E';}
      $j++;
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$j, 'Total');
        $objPHPExcel->getActiveSheet()->getStyle('C'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $ltot);
        $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('H1', 'Assets');
        $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Amount');
        $objPHPExcel->getActiveSheet()->getStyle('M1')->applyFromArray($styleArray);

$var = 'I';$j=2; $gvar = 'I';$svar = 'L';$altot=0;foreach($assets_list as $llist){
          if($llist['main_title']!=''){
            $objPHPExcel->getActiveSheet()->setCellValue('I'.$j, $llist['main_title']);
              $objPHPExcel->getActiveSheet()->getStyle('I'.$j)->applyFromArray($styleArray);
              $j++;
          }
          if($llist['sub_title']!=''){
          $inner_title_list = $this->db->query("SELECT * FROM accounts_cron_job_result WHERE parent_id = ".$llist['accounts_cron_job_result_id'])->result_array();

$objPHPExcel->getActiveSheet()->setCellValue('J'.$j, $llist['sub_title']);
                $objPHPExcel->getActiveSheet()->getStyle('J'.$j)->applyFromArray($styleArray);
                $objPHPExcel->getActiveSheet()->setCellValue('M'.$j, $llist['amount_1']);
                $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray);

foreach($inner_title_list as $itlist){
                $j++;
                  $objPHPExcel->getActiveSheet()->setCellValue('K'.$j, $itlist['inner_title']);
                    $objPHPExcel->getActiveSheet()->getStyle('K'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('L'.$j, round($itlist['amount_1']));
                    $objPHPExcel->getActiveSheet()->getStyle('L'.$j)->applyFromArray($styleArray);
                }
                $altot+=$llist['amount_1'];
        $j++;}
      $gvar = 'I';$svar = 'L';}
      $j++;
        $objPHPExcel->getActiveSheet()->setCellValue('J'.$j, 'Total');
        $objPHPExcel->getActiveSheet()->getStyle('J'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('M'.$j, $altot);
        $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray);

$filename='Balancesheet.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');  
    }
    //Balance Sheet End

//Trial Balance Start
    if($account_job_list->accounts_module=='Trial Balance')
    {
      $g_settings = general_setting_details();
      $reptitle = 'Trial Balance For '.$$account_job_list->location_name.' From '.date_format(date_create($account_job_list->from_date),$g_settings->date_format).' To '.date_format(date_create($account_job_list->to_date),$g_settings->date_format);

$liabilities_list = $this->Accountsjob_model->get_accounts_job_left_result($account_job_list->accounts_cron_job_id);

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

$styleArrayNormal = array(
              'font' => array(
                  'color' => array('rgb' => '000000')
              ),
              'alignment' => array(
                  'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
              )
          );

$objPHPExcel->getActiveSheet()->mergeCells('A1:H1');
          $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
          $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('A3', 'Particulars');
          $objPHPExcel->getActiveSheet()->getStyle('A3')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->mergeCells('D3:H3');
          $objPHPExcel->getActiveSheet()->setCellValue('D3', 'Closing Balance');
          $objPHPExcel->getActiveSheet()->getStyle('D3')->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('G4', 'Debit');
          $objPHPExcel->getActiveSheet()->getStyle('G4')->applyFromArray($styleArrayNormal);

$objPHPExcel->getActiveSheet()->setCellValue('H4', 'Credit');
          $objPHPExcel->getActiveSheet()->getStyle('H4')->applyFromArray($styleArrayNormal);

$acdeb=0;
          $accre=0;
          $j=5;$ltot=0;foreach($liabilities_list as $llist){
                if($llist['main_title']!=''){
                  $objPHPExcel->getActiveSheet()->setCellValue('A'.$j, $llist['main_title']);
                    $objPHPExcel->getActiveSheet()->getStyle('A'.$j)->applyFromArray($styleArray);
                    $j++;
                }
                if($llist['sub_title']!=''){
                $inner_title_list = $this->db->query("SELECT * FROM accounts_cron_job_result WHERE parent_id = ".$llist['accounts_cron_job_result_id'])->result_array();

$objPHPExcel->getActiveSheet()->setCellValue('B'.$j, $llist['sub_title']);
                      $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
                      $objPHPExcel->getActiveSheet()->setCellValue('G'.$j, round($llist['amount_1']));
                      $objPHPExcel->getActiveSheet()->getStyle('G'.$j)->applyFromArray($styleArray);
                      $objPHPExcel->getActiveSheet()->setCellValue('H'.$j, round($llist['amount_2']));
                      $objPHPExcel->getActiveSheet()->getStyle('H'.$j)->applyFromArray($styleArray);

foreach($inner_title_list as $itlist){
                      $j++;
                        $objPHPExcel->getActiveSheet()->setCellValue('C'.$j, $itlist['inner_title']);
                          $objPHPExcel->getActiveSheet()->getStyle('C'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('D'.$j, $itlist['amount_1']);
                          $objPHPExcel->getActiveSheet()->getStyle('D'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('E'.$j, $itlist['amount_2']);
                          $objPHPExcel->getActiveSheet()->getStyle('E'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('F'.$j, round($itlist['amount_3']));
                          $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);
                      }
                      $ltot+=$llist['amount_1'];
              $j++;}
            }
            $j++;

$filename='Trialbalance.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');

} 
    //Trial Balance End

//Opening Balance Sheet Start
    if($account_job_list->accounts_module=='Opening Balance Sheet')
    {
      $liabilities_list = $this->Accountsjob_model->get_accounts_job_left_result($account_job_list->accounts_cron_job_id);
      $assets_list = $this->Accountsjob_model->get_accounts_job_right_result($account_job_list->accounts_cron_job_id);

$objPHPExcel->getActiveSheet()->setCellValue('F'.$j, $ltot);
        $objPHPExcel->getActiveSheet()->getStyle('F'.$j)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('M'.$j, $altot);
        $objPHPExcel->getActiveSheet()->getStyle('M'.$j)->applyFromArray($styleArray);

$filename='OpeningBalancesheet.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

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');  
    }
    //Opening Balance Sheet End

//Profit & Loss Start
    if($account_job_list->accounts_module=='Profit & Loss')
    {
      $liabilities_list = $this->Accountsjob_model->get_accounts_job_left_result($account_job_list->accounts_cron_job_id);
      $assets_list = $this->Accountsjob_model->get_accounts_job_right_result($account_job_list->accounts_cron_job_id);

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Particulars');
        $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Amount');
        $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$var = 'B';$j=2; $gvar = 'B';$svar = 'E';$pprof0;foreach($liabilities_list as $llist){
          if($llist['main_title']!=''){
            $objPHPExcel->getActiveSheet()->setCellValue('B'.$j, $llist['main_title']);
              $objPHPExcel->getActiveSheet()->getStyle('B'.$j)->applyFromArray($styleArray);
              $j++;
          }
          if($llist['sub_title']!=''){
          $inner_title_list = $this->db->query("SELECT * FROM accounts_cron_job_result WHERE parent_id = ".$llist['accounts_cron_job_result_id'])->result_array();

$k=$j;

$objPHPExcel->getActiveSheet()->setCellValue('H1', 'Particulars');
        $objPHPExcel->getActiveSheet()->getStyle('H1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('M1', 'Amount');
        $objPHPExcel->getActiveSheet()->getStyle('M1')->applyFromArray($styleArray);

$var = 'I';$j=2; $gvar = 'I';$svar = 'L';$sprof=0;foreach($assets_list as $llist){
          if($llist['main_title']!=''){
            $objPHPExcel->getActiveSheet()->setCellValue('I'.$j, $llist['main_title']);
              $objPHPExcel->getActiveSheet()->getStyle('I'.$j)->applyFromArray($styleArray);
              $j++;
          }
          if($llist['sub_title']!=''){
          $inner_title_list = $this->db->query("SELECT * FROM accounts_cron_job_result WHERE parent_id = ".$llist['accounts_cron_job_result_id'])->result_array();

$nprof = $sprof-$pprof;
      if($nprof>0){        
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$k, 'Net Profit');
        $objPHPExcel->getActiveSheet()->getStyle('C'.$k)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('F'.$k, $nprof);
        $objPHPExcel->getActiveSheet()->getStyle('F'.$k)->applyFromArray($styleArray);
      }
      else
      {
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$k, 'Net Profit');
        $objPHPExcel->getActiveSheet()->getStyle('C'.$k)->applyFromArray($styleArray);

$objPHPExcel->getActiveSheet()->setCellValue('F'.$k, abs($nprof));
        $objPHPExcel->getActiveSheet()->getStyle('F'.$k)->applyFromArray($styleArray);
      }

$filename='Profitloss.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

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');  
    }
    //Profit & Loss End

//Debtors Start
    if($account_job_list->accounts_module=='Debtors')
    {
      $debtor_creditor_list = $this->Accountsjob_model->get_accounts_job_debtor_creditor_result($account_job_list->accounts_cron_job_id);

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sundry Debtors');
        $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Debit');
        $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Credit');
        $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Balance');
        $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);

$i=2;foreach($debtor_creditor_list as $llist){
          if(round($llist['amount_3'])!=0){
            $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $llist['inner_title']);
            $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, round($llist['amount_1'],2));
            $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, round($llist['amount_2'],2));
            $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, round($llist['amount_3'],2));
            $i++;
          }
        }

$filename='Sundry_Debtors.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

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');  
    }
    //Debtors End

//Creditors Start
    if($account_job_list->accounts_module=='Creditors')
    {
      $debtor_creditor_list = $this->Accountsjob_model->get_accounts_job_debtor_creditor_result($account_job_list->accounts_cron_job_id);

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Sundry Creditors');
        $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Debit');
        $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Credit');
        $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
        $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Balance');
        $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);

$filename='Sundry_Creditors.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

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');  
    }
    //Creditors End

}

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

public function delete(){ 
    $bid=$_POST['field'];
    $this->db->query("DELETE FROM `notification` WHERE `accounts_cron_job_id`=$bid");
    $this->Accountsjob_model->accounts_job_result_delete($bid);
    $result = $this->Accountsjob_model->accounts_job_delete($bid);
    if ($result) {
      $this->session->set_flashdata('add_success', 'Job has been Deleted successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
  }

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Accountsjob.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation