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

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

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

// Get data
    $data = $this->Paymentreport_model->getcustomerList($postData);

echo json_encode($data);
  }

public function index()
  {
    $data['customer_list'] = $this->Paymentreport_model->get_customer_list();
    //$data['location_list'] = $this->Paymentreport_model->get_active_location();
    if($_SESSION['company_id']==0)
      $data['location_list'] = $this->Quotation_model->get_location();
    else
      $data['location_list'] = $this->Quotation_model->get_location_by_comp_id($_SESSION['company_id']);

$this->load->view('paymentreport/payment_report',$data);
  }

public function debtors_pending_report_export()
  {
    $fdate = isset($_SESSION['paydreportfdate'])?$_SESSION['paydreportfdate']:'';
    $tdate = isset($_SESSION['paydreporttdate'])?$_SESSION['paydreporttdate']:'';
    $cus = isset($_SESSION['paydreportcus'])?$_SESSION['paydreportcus']:'';
    $cid = isset($_SESSION['paydreportcid'])?$_SESSION['paydreportcid']:'';
    $uid = isset($_SESSION['paydreportuid'])?$_SESSION['paydreportuid']:'';
    $pmode = isset($_SESSION['paydreportpmode'])?$_SESSION['paydreportpmode']:'';

if($cus=='' && $cid=='' && $uid=='')
    {
      $resqry = $this->db->query("SELECT account_receipt_date,payment_mode,order_no,invoice_no,customer_code,customer_name,grand_total,amount,created_on,user_id,user_id as order_id,sum(amount) as paidamt,user_id FROM ((SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar, `order` o, customer c WHERE ar.user_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Sales') UNION (SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, o.order_id as order_id FROM account_receipt ar,invoice i, `order` o, customer c WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice') UNION (SELECT ar.account_receipt_date,ar.payment_mode,'' as order_no,i.invoice_no,c.customer_code,c.customer_name,i.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar,invoice i, customer c WHERE ar.user_id = i.invoice_id AND i.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice')  ORDER BY created_on ASC) t GROUP BY t.order_id ORDER BY t.account_receipt_date");
      $pending_report_list = $resqry->result_array();
    }
    else
    {
      if($cus!='')
      {
        $cusqry = " AND o.customer_id='".$cus."'";
        $cusqry1 = " AND i.customer_id='".$cus."'";
      }
      else
      {
        $cusqry = '';
        $cusqry1 = '';
      }

if($cid!='')
      {
        $compqry = " AND o.location_id='".$cid."'";
        $compqry1 = " AND i.location_id='".$cid."'";
      }
      else
      {
        $compqry = '';
        $compqry1 = '';
      }

if($uid!='')
      {
        $unitqry = " AND o.prod_unit='".$uid."'";
        $unitqry1 = " AND i.prod_unit='".$uid."'";
      }
      else
      {
        $unitqry = '';
        $unitqry1 = '';
      }

if($pmode!='')
      { 
        $pmodeqry = " AND ar.payment_mode='".$pmode."'";
      }
      else
      {
        $pmodeqry = '';
      }

$resqry = $this->db->query("SELECT account_receipt_date,payment_mode,order_no,invoice_no,customer_code,customer_name,grand_total,amount,created_on,user_id,user_id as order_id,sum(amount) as paidamt,user_id FROM ((SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar, `order` o, customer c WHERE ar.user_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Sales' $cusqry $compqry $unitqry $pmodeqry) UNION (SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, o.order_id as order_id FROM account_receipt ar,invoice i, `order` o, customer c WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice' $cusqry $compqry $unitqry $pmodeqry) UNION (SELECT ar.account_receipt_date,ar.payment_mode,'' as order_no,i.invoice_no,c.customer_code,c.customer_name,i.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar,invoice i, customer c WHERE ar.user_id = i.invoice_id AND i.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice' $cusqry1 $compqry1 $unitqry1 $pmodeqry)  ORDER BY created_on ASC) t GROUP BY t.order_id ORDER BY t.account_receipt_date");
      $pending_report_list = $resqry->result_array();
    }

$g_settings = general_setting_details();

if($cid!='')
    {
      $locationlist = $this->Invoice_model->get_location_by_id($cid);
      $locationName = $locationlist->location_name;
      $reptitle = 'Debtors Pending Report For '.$locationName.' From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }
    else
    {
      $locationName = '';
      $reptitle = 'Debtors Pending Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }

$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:I1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Payment Mode');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'SO No');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Invoice No');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Customer');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Total Amount');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'Paid Amount');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('H2', 'Pending Amount');
    $objPHPExcel->getActiveSheet()->getStyle('H2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('I2', 'Status');
    $objPHPExcel->getActiveSheet()->getStyle('I2')->applyFromArray($styleArray);

$i=3;$nw=0;$bval=0;$trec=0;$tbal=0;$tot=0;$pamt=0;$penamt=0;
    foreach ($pending_report_list as $prlist ) { 
      $bal = $prlist['grand_total'] - $prlist['paidamt'];
      if($bal!=0)
      {
        if($prlist['paidamt']==0)
          $sts = 'Approved';
        else if($bal==0)
          $sts = 'Paid';
        else
          $sts = 'Partly Paid';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($prlist['account_receipt_date']),$g_settings->date_format));
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $prlist['payment_mode']);
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prlist['order_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $prlist['invoice_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $prlist['customer_code'].' - '.$prlist['customer_name']);
        $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($prlist['grand_total'],2));
        $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($prlist['paidamt'],2));
        $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, round($bal,2));
        $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, $sts);

$i++;
        $tot+=$prlist['grand_total'];$pamt+=$prlist['paidamt'];$penamt+=$bal;
      }
    }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, 'Total');
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($tot,2));
    $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($pamt,2));
    $objPHPExcel->getActiveSheet()->setCellValue('H'.$i, round($penamt,2));
    $objPHPExcel->getActiveSheet()->setCellValue('I'.$i, '');

$filename='Debtors_Pending_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 debtors_payment_register_export()
  {
    $fdate = isset($_SESSION['paydreportfdate'])?$_SESSION['paydreportfdate']:'';
    $tdate = isset($_SESSION['paydreporttdate'])?$_SESSION['paydreporttdate']:'';
    $cus = isset($_SESSION['paydreportcus'])?$_SESSION['paydreportcus']:'';
    $cid = isset($_SESSION['paydreportcid'])?$_SESSION['paydreportcid']:'';
    $uid = isset($_SESSION['paydreportuid'])?$_SESSION['paydreportuid']:'';
    $pmode = isset($_SESSION['paydreportpmode'])?$_SESSION['paydreportpmode']:'';

if($cus=='' && $cid=='' && $uid=='' && $pmode=='')
    {
      $resqry = $this->db->query("SELECT account_receipt_date,payment_mode,order_no,invoice_no,customer_code,customer_name,grand_total,amount,created_on,user_id,user_id as order_id,sum(amount) as paidamt,user_id FROM ((SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar, `order` o, customer c WHERE ar.user_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Sales') UNION (SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, o.order_id as order_id FROM account_receipt ar,invoice i, `order` o, customer c WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice') UNION (SELECT ar.account_receipt_date,ar.payment_mode,'' as order_no,i.invoice_no,c.customer_code,c.customer_name,i.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar,invoice i, customer c WHERE ar.user_id = i.invoice_id AND i.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice')  ORDER BY created_on ASC) t GROUP BY t.order_id ORDER BY t.account_receipt_date");
      $payment_register_list = $resqry->result_array();
    }
    else
    {
      if($cus!='')
      {
        $cusqry = " AND o.customer_id='".$cus."'";
        $cusqry1 = " AND i.customer_id='".$cus."'";
      }
      else
      {
        $cusqry = '';
        $cusqry1 = '';
      }

if($pmode!='')
      { 
        $pmodeqry = " AND ar.payment_mode='".$pmode."'";
      }
      else
      {
        $pmodeqry = '';
      }

$payment_register_list = $resqry->result_array();
    }

$g_settings = general_setting_details();

if($cid!='')
    {
      $locationlist = $this->Invoice_model->get_location_by_id($cid);
      $locationName = $locationlist->location_name;
      $reptitle = 'Debtors Payment Register Report For '.$locationName.' From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }
    else
    {
      $locationName = '';
      $reptitle = 'Debtors Payment Register Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);
    }

$objPHPExcel->getActiveSheet()->mergeCells('A1:G1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Payment Mode');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'SO No');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Invoice No');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Customer');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Total Amount');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'Paid Amount');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);

$i=3;$tot=0;$adv=0;$bal=0;$pamt = 0;
    foreach ($payment_register_list as $prlist ) { 
      $tot+=$prlist['grand_total'];
      $pamt+=$prlist['paidamt'];

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($prlist['account_receipt_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $prlist['payment_mode']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prlist['order_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $prlist['invoice_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $prlist['customer_code'].' - '.$prlist['customer_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($prlist['grand_total'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, round($prlist['paidamt'],2));

$i++;
    }

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

}

public function creditors_pending_report_export()
  {
    $fdate = isset($_SESSION['paycreportfdate'])?$_SESSION['paycreportfdate']:'';
    $tdate = isset($_SESSION['paycreporttdate'])?$_SESSION['paycreporttdate']:'';
    $ven = isset($_SESSION['paycreportven'])?$_SESSION['paycreportven']:'';
    $pmode = isset($_SESSION['paycreportpmode'])?$_SESSION['paycreportpmode']:'';

if($ven=='')
    {
      $creditors_pending_report_list = $this->Paymentreport_model->get_basic_creditors_pending_payment_list($fdate,$tdate);
    }
    else
    {
      if($ven!='')
        $venqry = " AND v.vendor_id='".$ven."'";
      else
        $venqry = '';

$resqry = $this->db->query("(SELECT p.purchase_no,p.purchase_date,p.invoice_no,p.purchase_id,v.vendor_name,v.vendor_id,p.total_amount,p.created_on,'vendor' as ptype FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.purchase_date>='$fdate' AND p.purchase_date<='$tdate' $venqry) UNION (SELECT e.expense_no as purchase_no,e.expense_date as purchase_date,e.invoice_no,e.expense_id as purchase_id,v.vendor_name,v.vendor_id,e.total_amount,e.created_on,'expense' as ptype FROM `expense` e,vendor v WHERE e.vendor_id = v.vendor_id AND e.expense_date>='$fdate' AND e.expense_date<='$tdate' $venqry) ORDER BY created_on ASC");
      $creditors_pending_report_list = $resqry->result_array();
    }

$g_settings = general_setting_details();
    $reptitle = 'Creditors Pending Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);

$objPHPExcel->getActiveSheet()->mergeCells('A1:G1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Invoice No');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'Vendor Name');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Bill Value');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Received');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Balance');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('G2', 'Status');
    $objPHPExcel->getActiveSheet()->getStyle('G2')->applyFromArray($styleArray);

$i=3;$bval=0;$trec=0;$tbal=0;
    foreach ($creditors_pending_report_list as $prlist ) {

if($prlist['ptype']=='vendor')
      {
          $opayment = $this->Paymentreport_model->get_pur_payment_total_by_pur_id($prlist['purchase_id']);
      }
      else
      {
          $opayment = $this->Paymentreport_model->get_exp_payment_total_by_exp_id($prlist['purchase_id']);
      }
      $pamt = $opayment->amt;
      $bal = $prlist['total_amount'] - $pamt;

if($pamt==0)
        $sts = 'Approved';
      elseif($bal==0)
        $sts = 'Paid';
      else
        $sts = 'Partly Paid';

if($bal!=0)
      {

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $prlist['invoice_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, date_format(date_create($prlist['purchase_date']),$g_settings->date_format));
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prlist['vendor_name']);
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, round($prlist['total_amount'],2));
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($pamt,2));
        $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($bal,2));
        $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $sts);

$i++;
        $bval+=$prlist['total_amount'];$trec+=$pamt;$tbal+=$bal;
      }
    }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, '');
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, 'Total');
    $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, round($bval,2));
    $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($trec,2));
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($tbal,2));
    $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, '');

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

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 creditors_payment_register_export()
  {
    $fdate = isset($_SESSION['paycreportfdate'])?$_SESSION['paycreportfdate']:'';
    $tdate = isset($_SESSION['paycreporttdate'])?$_SESSION['paycreporttdate']:'';
    $ven = isset($_SESSION['paycreportven'])?$_SESSION['paycreportven']:'';
    $pmode = isset($_SESSION['paycreportpmode'])?$_SESSION['paycreportpmode']:'';

if($ven=='' && $pmode=='')
    {
      $resqry = $this->db->query("(SELECT ap.account_payment_date,ap.payment_mode,p.invoice_no,v.vendor_name,v.vendor_id,p.purchase_id,p.total_amount,ap.amount,ap.created_on FROM account_payment ap,purchase p,vendor v WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate') UNION (SELECT ap.account_payment_date,ap.payment_mode,e.invoice_no,v.vendor_name,v.vendor_id,e.expense_id,e.total_amount,ap.amount,ap.created_on FROM account_payment ap,expense e,vendor v WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate') ORDER BY created_on ASC");
      $creditors_payment_register_list = $resqry->result_array();
    }
    else
    {
      if($ven!='')
        $venqry = " AND v.vendor_id='".$ven."'";

if($pmode!='')
      { 
        $pmodeqry = " AND ap.payment_mode='".$pmode."'";
      }
      else
      {
        $pmodeqry = '';
      }

$resqry = $this->db->query("(SELECT ap.account_payment_date,ap.payment_mode,p.invoice_no,v.vendor_name,v.vendor_id,p.purchase_id,p.total_amount,ap.amount,ap.created_on FROM account_payment ap,purchase p,vendor v WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' $venqry $pmodeqry) UNION (SELECT ap.account_payment_date,ap.payment_mode,e.invoice_no,v.vendor_name,v.vendor_id,e.expense_id,e.total_amount,ap.amount,ap.created_on FROM account_payment ap,expense e,vendor v WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' $venqry $pmodeqry) ORDER BY created_on ASC");
      $creditors_payment_register_list = $resqry->result_array();
    }

$g_settings = general_setting_details();
    $reptitle = 'Creditors Payment Register Report for All Company From '.date_format(date_create($fdate),$g_settings->date_format).' To '.date_format(date_create($tdate),$g_settings->date_format);

$objPHPExcel->getActiveSheet()->mergeCells('A1:F1');
    $objPHPExcel->getActiveSheet()->setCellValue('A1', $reptitle);
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('A2', 'Date');
    $objPHPExcel->getActiveSheet()->getStyle('A2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B2', 'Payment Mode');
    $objPHPExcel->getActiveSheet()->getStyle('B2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C2', 'Invoice No');
    $objPHPExcel->getActiveSheet()->getStyle('C2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D2', 'Vendor');
    $objPHPExcel->getActiveSheet()->getStyle('D2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E2', 'Total Amount');
    $objPHPExcel->getActiveSheet()->getStyle('E2')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F2', 'Paid Amount');
    $objPHPExcel->getActiveSheet()->getStyle('F2')->applyFromArray($styleArray);

$i=3;$tot=0;$bal=0;
    foreach ($creditors_payment_register_list as $prlist ) {

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, date_format(date_create($prlist['account_payment_date']),$g_settings->date_format));
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, ucwords($prlist['payment_mode']));
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $prlist['invoice_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $prlist['vendor_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, round($prlist['total_amount'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, round($prlist['amount'],2));

$i++;
      $tot+=$prlist['total_amount'];
      $bal+=$prlist['amount'];
    }

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

}

public function payment_report()
  {
    $fdate = $_POST['fdate'];
    $fd = explode('/', $fdate);
    $fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];

$tdate = $_POST['tdate'];
    $td = explode('/', $tdate);
    $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$rtype = $_POST['rtype'];
    $cus = $_POST['cus'];
    $cid = $_POST['cid'];
    $uid = $_POST['uid'];
    $pmode = $_POST['pmode'];

$this->session->set_userdata('paydreportfdate', $_POST['fdate']!=''?$fdate:'');
    $this->session->set_userdata('paydreporttdate', $_POST['tdate']!=''?$tdate:'');
    $this->session->set_userdata('paydreportcus', $_POST['cus']!=''?$_POST['cus']:'');
    $this->session->set_userdata('paydreportcid', $_POST['cid']!=''?$_POST['cid']:'');
    $this->session->set_userdata('paydreportuid', $_POST['uid']!=''?$_POST['uid']:'');
    $this->session->set_userdata('paydreportpmode', $_POST['pmode']!=''?$_POST['pmode']:'');

if($rtype == 'pending report')
    {
      if($cus=='' && $cid=='' && $uid=='')
      {
        //$data['pending_report_list'] = $this->Paymentreport_model->get_basic_pending_payment_list($fdate,$tdate);
        $resqry = $this->db->query("SELECT account_receipt_date,payment_mode,order_no,invoice_no,customer_code,customer_name,grand_total,amount,created_on,user_id,user_id as order_id,sum(amount) as paidamt,user_id FROM ((SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar, `order` o, customer c WHERE ar.user_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Sales') UNION (SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, o.order_id as order_id FROM account_receipt ar,invoice i, `order` o, customer c WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice') UNION (SELECT ar.account_receipt_date,ar.payment_mode,'' as order_no,i.invoice_no,c.customer_code,c.customer_name,i.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar,invoice i, customer c WHERE ar.user_id = i.invoice_id AND i.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice')  ORDER BY created_on ASC) t GROUP BY t.order_id ORDER BY t.account_receipt_date");
        $data['pending_report_list'] = $resqry->result_array();
      }
      else
      {
        /*if($cus!='')
          $cusqry = " AND o.customer_id='".$cus."'";
        else
          $cusqry = '';

if($cid!='')
          $compqry = " AND o.location_id='".$cid."'";
        else
          $compqry = '';

if($uid!='')
          $unitqry = " AND o.prod_unit='".$uid."'";
        else
          $unitqry = '';

$resqry = $this->db->query("SELECT i.invoice_no,i.invoice_date,c.customer_code,c.customer_name,i.net_weight,i.grand_total,o.advance_amount,o.order_id FROM `invoice` i,`order` o,customer c WHERE i.order_id = o.order_id AND o.customer_id = c.customer_id AND i.order_id!=0 AND i.invoice_date>='$fdate' AND i.invoice_date<='$tdate' $cusqry $compqry $unitqry");
        $data['pending_report_list'] = $resqry->result_array();*/
        if($cus!='')
        {
          $cusqry = " AND o.customer_id='".$cus."'";
          $cusqry1 = " AND i.customer_id='".$cus."'";
        }
        else
        {
          $cusqry = '';
          $cusqry1 = '';
        }

if($cid!='')
        {
          $compqry = " AND o.location_id='".$cid."'";
          $compqry1 = " AND i.location_id='".$cid."'";
        }
        else
        {
          $compqry = '';
          $compqry1 = '';
        }

if($uid!='')
        {
          $unitqry = " AND o.prod_unit='".$uid."'";
          $unitqry1 = " AND i.prod_unit='".$uid."'";
        }
        else
        {
          $unitqry = '';
          $unitqry1 = '';
        }

if($pmode!='')
        { 
          //$pmodeqry = " HAVING payment_mode='".$pmode."'";
          $pmodeqry = " AND ar.payment_mode='".$pmode."'";
        }
        else
        {
          //$pmodeqry = '';
          $pmodeqry = '';
        }

$data['pending_report_list'] = $resqry->result_array();
      }
      $this->load->view('paymentreport/pending_report_table',$data);
    }

if($rtype == 'payment register')
    {
        //(SELECT o.order_date,'Advance' as payment_type,'Cash' as payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,o.advance_amount,'' as balance_amount,o.created_on FROM `order` o,customer c WHERE o.customer_id = c.customer_id AND o.advance_amount!=0)UNION(SELECT o.order_date,'Balance' as payment_type,p.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,'' as advance_amount,p.payment_amount as balance_amount,p.created_on FROM payment p,`order` o,customer c,invoice i WHERE p.order_id = o.order_id AND o.customer_id = c.customer_id AND o.order_id = i.order_id) ORDER BY created_on ASC
      if($cus=='' && $cid=='' && $uid=='' && $pmode=='')
      {
        //$data['payment_register_list'] = $this->Productionreport_model->get_basic_production_register_list($fdate,$tdate);
        /*$resqry = $this->db->query("(SELECT o.order_date,'Advance' as payment_type,'Cash' as payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,o.advance_amount,'' as balance_amount,o.created_on FROM `order` o,customer c WHERE o.customer_id = c.customer_id AND o.advance_amount!=0 AND o.order_date>='$fdate' AND o.order_date<='$tdate')UNION(SELECT o.order_date,'Balance' as payment_type,p.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,'' as advance_amount,p.payment_amount as balance_amount,p.created_on FROM payment p,`order` o,customer c,invoice i WHERE p.order_id = o.order_id AND o.customer_id = c.customer_id AND o.order_id = i.order_id AND o.order_date>='$fdate' AND o.order_date<='$tdate') ORDER BY created_on ASC");*/

$resqry = $this->db->query("SELECT account_receipt_date,payment_mode,order_no,invoice_no,customer_code,customer_name,grand_total,amount,created_on,user_id,user_id as order_id,sum(amount) as paidamt,user_id FROM ((SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar, `order` o, customer c WHERE ar.user_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Sales') UNION (SELECT ar.account_receipt_date,ar.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,ar.amount,ar.created_on, ar.user_id, o.order_id as order_id FROM account_receipt ar,invoice i, `order` o, customer c WHERE ar.user_id = i.invoice_id AND i.order_id = o.order_id AND o.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice') UNION (SELECT ar.account_receipt_date,ar.payment_mode,'' as order_no,i.invoice_no,c.customer_code,c.customer_name,i.grand_total,ar.amount,ar.created_on, ar.user_id, ar.user_id as order_id FROM account_receipt ar,invoice i, customer c WHERE ar.user_id = i.invoice_id AND i.customer_id = c.customer_id AND ar.account_receipt_date>='$fdate' AND ar.account_receipt_date<='$tdate' AND ar.user_type = 'Invoice')  ORDER BY created_on ASC) t GROUP BY t.order_id ORDER BY t.account_receipt_date");
        $data['payment_register_list'] = $resqry->result_array();
      }
      else
      {
        if($cus!='')
        {
          $cusqry = " AND o.customer_id='".$cus."'";
          $cusqry1 = " AND i.customer_id='".$cus."'";
        }
        else
        {
          $cusqry = '';
          $cusqry1 = '';
        }

if($cid!='')
        {
          $compqry = " AND o.location_id='".$cid."'";
          $compqry1 = " AND i.location_id='".$cid."'";
        }
        else
        {
          $compqry = '';
          $compqry1 = '';
        }

if($uid!='')
        {
          $unitqry = " AND o.prod_unit='".$uid."'";
          $unitqry1 = " AND i.prod_unit='".$uid."'";
        }
        else
        {
          $unitqry = '';
          $unitqry1 = '';
        }

//$resqry = $this->db->query("SELECT o.order_date,c.customer_name,p.product_name,dcp.quantity,wlp.weight FROM `delivery_challan` dc,`order` o,customer c,work_order wo,product p,delivery_challan_product dcp,work_log wl,work_log_product wlp,product_category pc,product_attribute pa, attribute a WHERE dc.order_id = o.order_id AND o.order_id = wo.order_id AND wo.work_order_id = wl.work_order_id AND dc.delivery_challan_id = dcp.delivery_challan_id AND wl.work_log_id = wlp.work_log_id AND dcp.product_id = wlp.product_id AND o.customer_id = c.customer_id AND p.product_id = dcp.product_id AND p.category_id = pc.product_category_id AND pa.attribute_id = a.attribute_id AND p.product_id = pa.product_id AND dc.delivery_challan_date>='$fdate' AND dc.delivery_challan_date<='$tdate' $catqry $prodqry $gsmqry $colorqry GROUP BY dcp.delivery_challan_product_id");
        /*$resqry = $this->db->query("(SELECT o.order_date,'Advance' as payment_type,'Cash' as payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,o.advance_amount,'' as balance_amount,o.created_on FROM `order` o,customer c WHERE o.customer_id = c.customer_id AND o.advance_amount!=0 AND o.order_date>='$fdate' AND o.order_date<='$tdate' $cusqry $compqry $unitqry $pmodeqry)UNION(SELECT o.order_date,'Balance' as payment_type,p.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,'' as advance_amount,p.payment_amount as balance_amount,p.created_on FROM payment p,`order` o,customer c,invoice i WHERE p.order_id = o.order_id AND o.customer_id = c.customer_id AND o.order_id = i.order_id AND o.order_date>='$fdate' AND o.order_date<='$tdate' $cusqry $compqry $unitqry $pmodeqry1) ORDER BY created_on ASC");*/

$data['payment_register_list'] = $resqry->result_array();
      }
      $this->load->view('paymentreport/payment_register_table',$data);
    }

}

public function creditors_index()
  {
    $data['vendor_list'] = $this->Paymentreport_model->get_vendor_list();

$this->load->view('paymentreport/creditors_payment_report',$data);
  }

public function creditors_payment_report()
  {
    $fdate = $_POST['fdate'];
    $fd = explode('/', $fdate);
    $fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];

$tdate = $_POST['tdate'];
    $td = explode('/', $tdate);
    $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$rtype = $_POST['rtype'];
    $ven = $_POST['ven'];
    $pmode = $_POST['pmode'];

$this->session->set_userdata('paycreportfdate', $_POST['fdate']!=''?$fdate:'');
    $this->session->set_userdata('paycreporttdate', $_POST['tdate']!=''?$tdate:'');
    $this->session->set_userdata('paycreportven', $_POST['ven']!=''?$_POST['ven']:'');
    $this->session->set_userdata('paycreportpmode', $_POST['pmode']!=''?$_POST['pmode']:'');

if($rtype == 'pending report')
    {
      if($ven=='')
      {
        $data['creditors_pending_report_list'] = $this->Paymentreport_model->get_basic_creditors_pending_payment_list($fdate,$tdate);
      }
      else
      {
        if($ven!='')
          $venqry = " AND v.vendor_id='".$ven."'";
        else
          $venqry = '';

//(SELECT p.purchase_no,p.purchase_date,p.invoice_no,v.vendor_name,p.total_amount,p.created_on FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.purchase_date>=fdate AND p.purchase_date<=tdate $venqry) UNION (SELECT e.expense_no as purchase_no,e.expense_date as purchase_date,e.invoice_no,v.vendor_name,e.total_amount,e.created_on FROM `expense` e,vendor v WHERE e.vendor_id = v.vendor_id AND e.expense_date>=fdate AND e.expense_date<=tdate $venqry) ORDER BY created_on ASC

$resqry = $this->db->query("(SELECT p.purchase_no,p.purchase_date,p.invoice_no,p.purchase_id,v.vendor_name,v.vendor_id,p.total_amount,p.created_on,'vendor' as ptype FROM `purchase` p,vendor v WHERE p.vendor_id = v.vendor_id AND p.purchase_date>='$fdate' AND p.purchase_date<='$tdate' $venqry) UNION (SELECT e.expense_no as purchase_no,e.expense_date as purchase_date,e.invoice_no,e.expense_id as purchase_id,v.vendor_name,v.vendor_id,e.total_amount,e.created_on,'expense' as ptype FROM `expense` e,vendor v WHERE e.vendor_id = v.vendor_id AND e.expense_date>='$fdate' AND e.expense_date<='$tdate' $venqry) ORDER BY created_on ASC");
        $data['creditors_pending_report_list'] = $resqry->result_array();
      }
      $this->load->view('paymentreport/creditors_pending_report_table',$data);
    }

if($rtype == 'payment register')
    {
        //(SELECT ap.account_payment_date,ap.payment_mode,p.invoice_no,v.vendor_name,v.vendor_id,p.purchase_id,p.total_amount,ap.amount,ap.created_on FROM account_payment ap,purchase p,vendor v WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ap.account_payment_date>=fdate AND ap.account_payment_date<=tdate) UNION (SELECT ap.account_payment_date,ap.payment_mode,e.invoice_no,v.vendor_name,v.vendor_id,e.expense_id,e.total_amount,ap.amount,ap.created_on FROM account_payment ap,expense e,vendor v WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ap.account_payment_date>=fdate AND ap.account_payment_date<=tdate) ORDER BY created_on ASC
      if($ven=='' && $pmode=='')
      {
        //$data['payment_register_list'] = $this->Productionreport_model->get_basic_production_register_list($fdate,$tdate);
        $resqry = $this->db->query("(SELECT ap.account_payment_date,ap.payment_mode,p.invoice_no,v.vendor_name,v.vendor_id,p.purchase_id,p.total_amount,ap.amount,ap.created_on FROM account_payment ap,purchase p,vendor v WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate') UNION (SELECT ap.account_payment_date,ap.payment_mode,e.invoice_no,v.vendor_name,v.vendor_id,e.expense_id,e.total_amount,ap.amount,ap.created_on FROM account_payment ap,expense e,vendor v WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate') ORDER BY created_on ASC");
        $data['creditors_payment_register_list'] = $resqry->result_array();
      }
      else
      {
        if($ven!='')
          $venqry = " AND v.vendor_id='".$ven."'";

if($pmode!='')
        { 
          $pmodeqry = " AND ap.payment_mode='".$pmode."'";
        }
        else
        {
          $pmodeqry = '';
        }

//$resqry = $this->db->query("(SELECT o.order_date,'Advance' as payment_type,'Cash' as payment_mode,o.order_no,'' as invoice_no,c.customer_code,c.customer_name,o.grand_total,o.advance_amount,'' as balance_amount,o.created_on FROM `order` o,customer c WHERE o.customer_id = c.customer_id AND o.advance_amount!=0 AND o.order_date>='$fdate' AND o.order_date<='$tdate' $cusqry $compqry $unitqry $pmodeqry)UNION(SELECT o.order_date,'Balance' as payment_type,p.payment_mode,o.order_no,i.invoice_no,c.customer_code,c.customer_name,o.grand_total,'' as advance_amount,p.payment_amount as balance_amount,p.created_on FROM payment p,`order` o,customer c,invoice i WHERE p.order_id = o.order_id AND o.customer_id = c.customer_id AND o.order_id = i.order_id AND o.order_date>='$fdate' AND o.order_date<='$tdate' $cusqry $compqry $unitqry $pmodeqry1) ORDER BY created_on ASC");
        $resqry = $this->db->query("(SELECT ap.account_payment_date,ap.payment_mode,p.invoice_no,v.vendor_name,v.vendor_id,p.purchase_id,p.total_amount,ap.amount,ap.created_on FROM account_payment ap,purchase p,vendor v WHERE ap.user_id = p.purchase_id AND p.vendor_id = v.vendor_id AND ap.expense_type='vendor payment' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' $venqry $pmodeqry) UNION (SELECT ap.account_payment_date,ap.payment_mode,e.invoice_no,v.vendor_name,v.vendor_id,e.expense_id,e.total_amount,ap.amount,ap.created_on FROM account_payment ap,expense e,vendor v WHERE ap.user_id = e.expense_id AND e.vendor_id = v.vendor_id AND ap.expense_type='expense' AND ap.account_payment_date>='$fdate' AND ap.account_payment_date<='$tdate' $venqry $pmodeqry) ORDER BY created_on ASC");
        $data['creditors_payment_register_list'] = $resqry->result_array();
      }
      $this->load->view('paymentreport/creditors_payment_register_table',$data);
    }

}

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Paymentreport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation