| Server IP : 199.250.214.225 / Your IP : 3.145.80.92 Web Server : Apache System : Linux vps64074.inmotionhosting.com 3.10.0-1160.105.1.vz7.214.3 #1 SMP Tue Jan 9 19:45:01 MSK 2024 x86_64 User : nicngo5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /home/nicngo5/grp.nicn.gov.ng/storage/framework/views/ |
Upload File : |
<?php $__env->startSection('pageTitle'); ?>
<?php $__env->stopSection(); ?>
<?php $__env->startSection('content'); ?>
<div class="box box-default" style="border:none;">
<div class="box-body">
<?php echo $__env->make('layouts.allReportHeader', ['companyName'=>'defaultName', 'companyAddress'=>'defaultAddress', 'title1'=>'Votes Balance Report as at '.$period, 'title2'=>'', 'showOnlyTitle1'=>1, 'showOnlyTitle2'=>0, 'hideLogos'=>0, 'hideAddress'=>0], \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?>
<div class="box-header with-border hidden-print">
<h3 class="box-title"><?php echo $__env->yieldContent('pageTitle'); ?> <span id='processing'></span></h3>
</div>
<?php if($warning<>''): ?>
<div class="alert alert-dismissible alert-danger">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong><?php echo e($warning); ?></strong>
</div>
<?php endif; ?>
<?php if($success<>''): ?>
<div class="alert alert-dismissible alert-success">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong><?php echo e($success); ?></strong>
</div>
<?php endif; ?>
<?php if(count($errors) > 0): ?>
<div class="alert alert-danger alert-dismissible" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">×</span>
</button>
<strong>Error!</strong>
<?php $__currentLoopData = $errors->all(); $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $error): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<p><?php echo e($error); ?></p>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</div>
<?php endif; ?>
<form method="post" id="thisform1" name="thisform1">
<?php echo e(csrf_field()); ?>
<div class="box-body">
<div class="row hidden-print">
<div class="col-md-2">
<label>Period</label>
<select name="period" id="period" class="form-control" onchange ="ReloadForm();" >
<option value="" selected>-Select Year-</option>
<?php $__currentLoopData = $YearPeriod; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<option value="<?php echo e($b->Period); ?>" <?php echo e(($period) == $b->Period? "selected":""); ?>><?php echo e($b->Period); ?></option>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</select>
</div>
<div class="col-md-2">
<label>Allocation Source</label>
<select name="allocationsource" id="allocationsource" class="form-control" onchange ="ReloadForm();">
<option value="" selected>-All-</option>
<?php $__currentLoopData = $AllocationSource; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<option value="<?php echo e($b->ID); ?>" <?php echo e(($allocationsource) == $b->ID? "selected":""); ?>><?php echo e($b->allocation); ?></option>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</select>
</div>
<div class="col-md-2">
<label>Budget Type</label>
<select name="budgettype" id="budgettype" class="form-control" onchange ="ReloadForm();">
<option value="" selected>-All-</option>
<?php $__currentLoopData = $BudgetType; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<option value="<?php echo e($b->ID); ?>" <?php echo e(($budgettype) == $b->ID? "selected":""); ?>><?php echo e($b->contractType); ?></option>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</select>
</div>
<div class="col-md-2">
<label>Economic Head</label>
<select name="economichead" id="economichead" class="form-control" onchange ="ReloadForm();">
<option value="" selected>-All-</option>
<?php $__currentLoopData = $EconomicHead; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<option value="<?php echo e($b->ID); ?>" <?php echo e(($economichead) == $b->ID? "selected":""); ?>><?php echo e($b->economicHead); ?></option>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</select>
</div>
<div class="col-md-4">
<label>Economic Codes</label>
<select name="economiccode" id="economiccode" class="form-control" onchange ="ReloadForm();">
<option value="" selected>-All-</option>
<?php $__currentLoopData = $EconomicCode; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<option value="<?php echo e($b->ID); ?>" <?php echo e(($economiccode) == $b->ID? "selected":""); ?>><?php echo e($b->economicCode); ?>|<?php echo e($b->description); ?></option>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
</select>
</div>
</div>
<div class="row">
</div>
<input id ="delcode" type="hidden" name="delcode" >
<div class="table-responsive" style="font-size: 12px; padding:10px;">
<table class="table table-bordered table-striped table-highlight" id="mytable">
<thead>
<tr bgcolor="#c7c7c7">
<th width="1%">S/N</th>
<th >Economic Code</th>
<th >Vote Description</th>
<th >This year Budget</th>
<th >January</th>
<th >February</th>
<th >March</th>
<th >April</th>
<th >May</th>
<th >June</th>
<th >July</th>
<th >August</th>
<th >September</th>
<th >October</th>
<th >November</th>
<th >December</th>
<th >Total Received</th>
<th >Total Expended</th>
<th >Refunds</th>
<th >Actual Balance</th>
<th >Available Balance</th>
<th> Borrow/Lend</th>
</tr>
</thead>
<?php $serialNum = 1; ?>
<?php $grouphead = ""; ?>
<?php $tallo = 0; ?>
<?php $tjan = 0; ?>
<?php $tfeb = 0; ?>
<?php $tmar = 0; ?>
<?php $tapr = 0; ?>
<?php $tmay = 0; ?>
<?php $tjun = 0; ?>
<?php $tjul = 0; ?>
<?php $taug = 0; ?>
<?php $tsep = 0; ?>
<?php $toct = 0; ?>
<?php $tnov = 0; ?>
<?php $tdec = 0; ?>
<?php $t_r_all = 0; ?>
<?php $t_spent = 0; ?>
<?php $t_book_hold = 0; ?>
<?php $t_bal = 0; ?>
<?php $t_book_bal = 0; ?>
<?php $t_ava_bal = 0; ?>
<?php $t_refunds = 0; ?>
<?php $__currentLoopData = $QueryVoultReport; $__env->addLoop($__currentLoopData); foreach($__currentLoopData as $b): $__env->incrementLoopIndices(); $loop = $__env->getLastLoop(); ?>
<?php if($b->economicHeadID!=$grouphead): ?>
<tr>
<?php $grouphead = $b->economicHeadID; ?>
<td colspan=22><?php echo e($b->economichead); ?>-<?php echo e($b->economicgroup); ?></td>
</tr>
<?php endif; ?>
<tr>
<td><?php echo e($serialNum ++); ?> </td>
<td><?php echo e($b->economiccode); ?> </td>
<td><?php echo e($b->economicdisc); ?> </td>
<td class="align"><?php echo e(number_format($b->allocationValue, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->January, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->February, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->March, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->April, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->May, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->June, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->July, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->August, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->September, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->October, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->November, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->December, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->receivedallocation, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->receivedallocation-$b->bal+$b->refunds, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->refunds, 2)); ?> </td>
<td class="align"><?php echo e(number_format($b->bal, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($b->av_bal, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format(($b->bal-$b->av_bal), 2, '.', ',')); ?> </td>
</tr>
<?php $tallo += $b->allocationValue; ?>
<?php $tjan += $b->January; ?>
<?php $tfeb += $b->February; ?>
<?php $tmar += $b->March; ?>
<?php $tapr += $b->April; ?>
<?php $tmay += $b->May; ?>
<?php $tjun += $b->June; ?>
<?php $tjul += $b->July; ?>
<?php $taug += $b->August; ?>
<?php $tsep += $b->September; ?>
<?php $toct += $b->October; ?>
<?php $tnov += $b->November; ?>
<?php $tdec += $b->December; ?>
<?php $t_r_all += $b->receivedallocation; ?>
<?php $t_spent += $b->receivedallocation-$b->bal+$b->refunds; ?>
<?php $t_book_hold += $b->bookonhold; ?>
<?php $t_bal += $b->bal; ?>
<?php $t_book_bal += $b->bal-$b->bookonhold; ?>
<?php $t_ava_bal += $b->av_bal; ?>
<?php $t_refunds += $b->refunds; ?>
<?php endforeach; $__env->popLoop(); $loop = $__env->getLastLoop(); ?>
<tr>
<td>Total </td>
<td></td>
<td> </td>
<td class="align"><?php echo e(number_format($tallo, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tjan, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tfeb, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tmar, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tapr, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tmay, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tjun, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tjul, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($taug, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tsep, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($toct, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tnov, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($tdec, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($t_r_all, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($t_spent, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format($t_refunds,2)); ?> </td>
<td class="align"><?php echo e(number_format($t_bal, 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format(($t_ava_bal), 2, '.', ',')); ?> </td>
<td class="align"><?php echo e(number_format(($t_bal-$t_ava_bal), 2, '.', ',')); ?> </td>
</tr>
</table>
<button type="submit" class="print">Print</button>
</div>
</div>
</form>
</div>
<?php $__env->stopSection(); ?>
<?php $__env->startSection('styles'); ?>
<style>
<link rel="stylesheet" type="text/css" href="<?php echo e(asset('assets/css/datepicker.min.css')); ?>">
@media print{
.hidden-print{display:none!important}
.dt-buttons, .dataTables_info, .dataTables_paginate, .dataTables_filter
{
display:none!important
}
}
.align
{
text-align:right;
}
</style>
<?php $__env->stopSection(); ?>
<?php $__env->startSection('scripts'); ?>
<link rel="stylesheet" type="text/css" href="<?php echo e(asset('assets/css/datepicker.min.css')); ?>">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css">
<script type="text/javascript">
$('.print').click(function() {
window.print();
});
</script>
<script src="<?php echo e(asset('assets/js/jquery-ui.min.js')); ?>"></script>
<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('#fields').multiselect({
nonSelectedText: 'Select fields to view',
enableFiltering: true,
enableCaseInsensitiveFiltering: true,
buttonWidth:'400px',
includeSelectAllOption: true,
});
});
</script>
<script type="text/javascript">
function checkForm(){
var fields = document.getElementById('fields').value;
var form = document.getElementById('thisform1');
if(fields == ''){
alert('Please select fields to view');
return false;
} else{
form.submit();
}
return false;
}
function ReloadForm()
{
//alert("ururu") ;
document.getElementById('thisform1').submit();
return;
}
function DeletePromo(id)
{
var cmt = confirm('You are about to delete a record. Click OK to continue?');
if (cmt == true) {
document.getElementById('delcode').value=id;
document.getElementById('thisform1').submit();
return;
}
}
$( function() {
$( "#todate" ).datepicker({changeMonth: true,changeYear: true,dateFormat: 'yy-mm-dd'});
$( "#fromdate" ).datepicker({changeMonth: true,changeYear: true,dateFormat: 'yy-mm-dd'});
$( "#appointmentDate" ).datepicker({changeMonth: true,changeYear: true,dateFormat: 'yy-mm-dd'});
$( "#incrementalDate" ).datepicker({changeMonth: true,changeYear: true,dateFormat: 'yy-mm-dd'});
$( "#firstArrivalDate" ).datepicker({changeMonth: true,changeYear: true,dateFormat: 'yy-mm-dd'});
} );
</script>
<script>
$(document).ready(function() {
$('#mytable').DataTable( {
dom: 'mytable',
buttons: [
{
extend: 'print',
customize: function ( win ) {
$(win.document.body)
.css( 'font-size', '10pt' )
.prepend(
''
);
$(win.document.body).find( 'table' )
.addClass( 'compact' )
.css( 'font-size', 'inherit' );
}
}
]
} );
} );
</script>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.layout', \Illuminate\Support\Arr::except(get_defined_vars(), ['__data', '__path']))->render(); ?><?php /**PATH /home/nicngo5/grp.nicn.gov.ng/resources/views/Report/VoultBalance.blade.php ENDPATH**/ ?>