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

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Tdsreport extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Tdsreport_model'));
    $this->load->model(array('Dashboard_model'));
    $this->load->model(array('Order_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', 'Report');
  }

public function index()
  {
    $sdate = $this->Dashboard_model->get_start_date();
    $diff = date('Y') - $sdate->year;
    $opt = "";
    for($i=$diff;$i>=0;$i--)
    {
      $y = date('Y') - $i;
      if($y==date('Y'))
        $opt.="<option value=".$y." selected>".$y."</option>";
      else
        $opt.="<option value=".$y.">".$y."</option>";
    }
    $data['yearList'] = $opt;

if($sdate->year == date('Y'))
    {
      $syearmonth = $this->Dashboard_model->get_start_year_months($sdate->month);
    }
    else
    {
      $syearmonth = $this->Dashboard_model->get_other_year_months();
    }
    $data['monthList'] = $syearmonth;

$data['location_list'] = $this->Order_model->get_location();

$this->load->view('tdsreport/tds_report',$data);
  }

public function getYearMonth()
  {
    $year = $_POST['year'];

$sdate = $this->Dashboard_model->get_start_date();

if($sdate->year == $year)
    {
      $syearmonth = $this->Dashboard_model->get_start_year_change_months($sdate->month);
    }
    else if($year<date('Y'))
    {
      $syearmonth = $this->Dashboard_model->get_other_year_change_months();
    }
    else
    {
      $syearmonth = $this->Dashboard_model->get_other_year_months();
    }

$monthList = $syearmonth;
    $option ="<option value=''>Select Month</option>";
    foreach($monthList as $schart)
    {
      $option.="<option value=".$schart['month'].">".$schart['name']."</option>";
    }
    echo $option;
  }

public function tds_report_export()
  {
    $syear = isset($_SESSION['tdsreportsyear'])?$_SESSION['tdsreportsyear']:'';
    $smonth = isset($_SESSION['tdsreportsmonth'])?$_SESSION['tdsreportsmonth']:'';
    $cid = isset($_SESSION['tdsreportcid'])?$_SESSION['tdsreportcid']:'';

if($cid=='0')
      $tds_report = $this->Tdsreport_model->get_tds_report_by_year_month($syear,$smonth);
    else
      $tds_report = $this->Tdsreport_model->get_tds_report_by_year_month_cid($syear,$smonth,$cid);

$g_settings = general_setting_details();

$dateObj   = DateTime::createFromFormat('!m', $smonth);
    $monthName = $dateObj->format('F');
    if($cid!='0')
    {
      $loclist = $this->Tdsreport_model->get_location_by_id($cid);
      $locationName = $loclist->location_name;
    }
    else
      $locationName = 'All Company';

$reptitle = 'TDS DETAILS - '.$locationName.' '.$monthName.' '.$syear;

$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()->mergeCells('A1:H1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'SL.NO');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Month');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', '');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'PAYEE DETAILS');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'PAN DETAIL');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'TOTAL VALUE');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'TDS');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H2', 'BALANCE PAID');
    $objPHPExcel->getActiveSheet()->getStyle('H2')->applyFromArray($styleArray);

$i=3;$tottds = 0;$j=1;
    foreach ($tds_report as $tns) { 
      $bpaid = $tns['totval']-$tns['tdsval'];
      $objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $j);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $monthName.' '.$syear);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $tns['ledger_group']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $tns['vendor_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $tns['pan_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($tns['totval'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($tns['tdsval'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, round($bpaid,2));

$i++;$j++;
      $tottds+=$tns['tdsval'];
    }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, 'TOTAL TDS PAYABLE');
    $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($tottds,2));
    $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, '');

$filename='TDS_Report.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 working_report()
  {
    $data['syear'] = $syear = $_POST['syear'];
    $data['smonth'] = $smonth = $_POST['smonth'];
    $data['cid'] = $cid = $_POST['cid'];

$this->session->set_userdata('tdsreportsyear', $_POST['syear']!=''?$syear:'');
    $this->session->set_userdata('tdsreportsmonth', $_POST['smonth']!=''?$smonth:'');
    $this->session->set_userdata('tdsreportcid', $_POST['cid']!=''?$_POST['cid']:'');

if($cid=='0')
      $data['tds_report'] = $this->Tdsreport_model->get_tds_report_by_year_month($syear,$smonth);
    else
      $data['tds_report'] = $this->Tdsreport_model->get_tds_report_by_year_month_cid($syear,$smonth,$cid);

$this->load->view('tdsreport/working_report',$data);
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Tdsreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation