@extends('layouts/acc_layout') @section('title', '| FDR Report') @section('content') @php use Carbon\Carbon; $projectSelected = isset($_GET['searchProject']) ? $_GET['searchProject'] : null; $projectTypeSelected = isset($_GET['searchProjectType']) ? $_GET['searchProjectType'] : null; $branchSelected = isset($_GET['searchBranch']) ? $_GET['searchBranch'] : null; $fdrTypeSelected = isset($_GET['searchFdrType']) ? $_GET['searchFdrType'] : null; $bankSelected = isset($_GET['searchBank']) ? $_GET['searchBank'] : null; $bankBranchSelected = isset($_GET['searchBankBranch']) ? $_GET['searchBankBranch'] : null; $dateFromSelected = isset($_GET['dateFrom']) ? $_GET['dateFrom'] : null; $dateToSelected = isset($_GET['dateTo']) ? $_GET['dateTo'] : null; $firstRequest = isset($_GET['firstRequest']) ? '1' : null; $userBranchId = Auth::user()->branchId; @endphp
| SL# | Opening Date |
Account No | Account Name | Duration (Months) |
Mature Date | Interest Rate (%) |
FDR Amount (Tk) | Opening Balance | Addition | Deduction | Encashment | Closing Balance | {{--Interest | Bank Charge | Tax | Net Interest | Receiveable Amount | Closing Date | Closing Amount | Balance | --}}|||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Principal | Interest | Tax | Bank Charge | Date | Amount (TK) | ||||||||||||||||||
| {{$bankName.', '.$branch->name}} | |||||||||||||||||||||||
| {{$index}} | {{date('d-m-Y',strtotime($fdrAccount->openingDate))}} | {{$fdrAccount->accNo}} | {{$fdrAccount->accName}} | {{str_pad($fdrAccount->duration,2,'0',STR_PAD_LEFT)}}{{-- @if($fdrAccount->duration>1){{' Months'}}@else{{' Month'}} @endif --}} | {{date('d-m-Y',strtotime($fdrAccount->matureDate))}} | {{number_format($fdrAccount->interestRate,2)}} | {{number_format($fdrAccount->principalAmount,2,'.',',')}} | {{--{{number_format($interest,2,'.',',')}} | --}}{{number_format($openingBalance,2)}} | {{--{{number_format($receiveAbleAmount,2,'.',',')}} | --}}{{number_format($principaAmount,2,'.',',')}} | {{number_format($interest,2,'.',',')}} | {{number_format($taxAmount,2,'.',',')}} | {{number_format($bankChange,2,'.',',')}} | @if($closingDate==null) {{"-"}} @else {{date('d-m-Y',strtotime($closingDate))}} @endif | @if($closingDate==null) {{"-"}} @else {{number_format($closingAmount,2,'.',',')}} @endif | {{number_format($balance,2,'.',',')}} | ||||||
| Sub Total | {{number_format($tFDRAmount,2,'.',',')}} | {{number_format($tOpeingBalance,2,'.',',')}} | {{number_format($tPrincipal,2,'.',',')}} | {{number_format($tInterest,2,'.',',')}} | {{number_format($tTaxAmount,2,'.',',')}} | {{number_format($tBankCharge,2,'.',',')}} | @if($closingDate!=null) {{number_format($tEncashmentAmount,2,'.',',')}} @else {{"-"}} @endif | {{number_format($tClosingBalance,2,'.',',')}} | |||||||||||||||
| Total {{'('.$rowNumbers.')'}} | {{number_format($gtFDRAmount,2,'.',',')}} | {{number_format($gtOpeningBalance,2,'.',',')}} | {{number_format($gtPrincipal,2,'.',',')}} | {{number_format($gtInterest,2,'.',',')}} | {{number_format($gtTaxAmount,2,'.',',')}} | {{number_format($gtBankCharge,2,'.',',')}} | {{number_format($gtEncashmentAmount,2,'.',',')}} | {{number_format($gtClosingBalance,2,'.',',')}} | |||||||||||||||