function get_form_html($form_id, $date)
{
ob_start();
?>
<div id="head_div" style="padding: 5px 0; background-color: #ECECEC; color: #21ACD7;
border-radius: 5px;margin-left: auto; text-align: center; ">
MONTHLY REPORT OF
<input id="year_field" value="<?php
if ($date == 0) {
$year = date('Y', time());
} else {
$year = split('/', $date)[0];
}
echo $year;
?>
" onchange="load_monthly_report()" style="width: 55px;" min="2015" max="2065" required />
<select id="month_field" onchange="load_monthly_report()" >
<?php
if ($date == 0) {
$month = date('m', time());
} else {
$month = split('/', $date)[1];
}
?>
<option <?php
if ($month == 1) {
echo ' selected ';
}
?>
value="1">JANUARY</option>
<option <?php
if ($month == 2) {
echo ' selected ';
}
?>
value="2">FEBRUARY</option>
<option <?php
if ($month == 3) {
echo ' selected ';
}
?>
value="3">MARCH</option>
<option <?php
if ($month == 4) {
echo ' selected ';
}
?>
value="4">APRIL</option>
<option <?php
if ($month == 5) {
echo ' selected ';
}
?>
value="5">MAY</option>
<option <?php
if ($month == 6) {
echo ' selected ';
}
?>
value="6">JUNE</option>
<option <?php
if ($month == 7) {
echo ' selected ';
}
?>
value="7">JULY</option>
<option <?php
if ($month == 8) {
echo ' selected ';
}
?>
value="8">AUGUST</option>
<option <?php
if ($month == 9) {
echo ' selected ';
}
?>
value="9">SEPTEMBER</option>
<option <?php
if ($month == 10) {
echo ' selected ';
}
?>
value="10">OCTOBER</option>
<option <?php
if ($month == 11) {
echo ' selected ';
}
?>
value="11">NOVEMBER</option>
<option <?php
if ($month == 12) {
echo ' selected ';
}
?>
value="121">DECEMBER</option>
</select>
</div>
<div id="content_table" style="margin-top: 10px; background-color:transparent;padding-bottom: 30px;">
<style>
div#purchace_items td{
border: 1px solid #21ACD7;
}
div#purchace_items tbody td{
padding: 5px 0 5px 5px;
}
div#purchace_items tbody td input,div#purchace_items tbody td select{
padding: 0;
border: 0;
margin: 0;
height: 100%;
width: 100%;
background-color: transparent;
}
</style>
<div id="purchace_items" style="width: 100%; padding: 10px 0; color: #21ACD7;">
<table id="table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7;">
<thead style="text-align: center;">
<tr>
<td style="width: 5%;">
#
</td>
<td>
DESCRIPTION
</td>
<td style="width: 15%;">
INCOME
</td>
<td style="width: 15%;">
EXPENCE
</td>
<td style="width: 15%;">
BALANCE
</td>
</tr>
</thead>
<tbody style="padding-left: 3px; text-align: center; ">
<?php
$balance = 0;
$income_total = 0;
$expence_total = 0;
$user = new user();
$user->id = $_SESSION['user_id'];
$user->getUser();
$i = 0;
if ($year < 2015 || $year > 2065 || $month < 1 || $month > 12) {
echo '<tr><td colspan="8"> In Valid Month Found </td></tr>';
} else {
//$grand_total = $grand_total + $sales_item->total;
?>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<?php
$sale = new sales();
$vals = $sale->getOneMonthsSaleSummary($user->company_id, $month, $year);
?>
<td style="text-align: left;">
Sales
</td>
<td>
<?php
echo number_format($vals['amount'], 2, '.', '');
$income_total = $income_total + $vals['amount'];
?>
</td>
<td>
</td>
<td id="tax">
<?php
$balance = $income_total - $expence_total;
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<td style="text-align: left;">
Tax
</td>
<td>
</td>
<td>
<?php
echo number_format($vals['tax_amount'], 2, '.', '');
$expence_total = $expence_total + $vals['tax_amount'];
?>
</td>
<td id="tax">
<?php
$balance = $income_total - $expence_total;
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<?php
$purchace = new purchaces();
$vals = $purchace->getOneMonthsPurchaceSummary($user->company_id, $month, $year);
?>
<td style="text-align: left;">
Purchaces
</td>
<td>
</td>
<td>
<?php
echo number_format($vals['amount'], 2, '.', '');
$expence_total = $expence_total + $vals['amount'];
?>
</td>
<td id="tax">
<?php
$balance = $income_total - $expence_total;
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<?php
$expence = new expences();
$vals = $expence->getOneMonthsExpenceSummary($user->company_id, $month, $year);
?>
<td style="text-align: left;">
Expences
</td>
<td>
</td>
<td>
<?php
echo number_format($vals['amount'], 2, '.', '');
$expence_total = $expence_total + $vals['amount'];
?>
</td>
<td id="tax">
<?php
$balance = $income_total - $expence_total;
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
<tr>
<td style="text-align: center;">
<?php
echo ++$i;
?>
</td>
<?php
$bank_deposit = new bank_deposits();
$vals = $bank_deposit->getOneMonthsBankDepositsSummary($user->company_id, $month, $year);
?>
<td style="text-align: left;">
Bank Deposit
</td>
<td>
</td>
<td>
<?php
echo number_format($vals['amount'], 2, '.', '');
$expence_total = $expence_total + $vals['amount'];
?>
</td>
<td id="tax">
<?php
$balance = $income_total - $expence_total;
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
<?php
}
?>
<tr>
<td></td>
<td style="text-align: right;"> TOTAL </td>
<td><?php
echo number_format($income_total, 2, '.', '');
?>
</td>
<td><?php
echo number_format($expence_total, 2, '.', '');
?>
</td>
<td><?php
echo number_format($balance, 2, '.', '');
?>
</td>
</tr>
</tbody>
</table>
<?php
/* ?>
<table id="sales_statistics_table" style="border-collapse: collapse; width: 100%;
background-color: #fff; border-radius: 10px; color: #21ACD7; margin-top: 20px;">
<thead style="text-align: center;">
<tr>
<td style="width: 5%;">
#
</td>
<td>
STATISTICS
</td>
<td style="width: 15%;">
COUNT
</td>
<td style="width: 15%;">
TOTAL TAX
</td>
<td style="width: 15%;">
TOTAL NET. AMOUNT
</td>
<td style="width: 15%;">
TOTAL AMOUNT
</td>
</tr>
</thead>
<tbody style="text-align: center;">
<tr style="margin-top: 20px;">
<?php
$sale = new sales();
$vals = $sale->getOneDaysSaleStatistics($user->company_id, $date);
?>
<td>1</td>
<td style="text-align: left;">SALES</td>
<td><?php echo $vals['count']; ?></td>
<td><?php echo number_format($vals['tax_amount'], 2, '.',''); ?></td>
<td><?php echo number_format($vals['net_amount'], 2, '.',''); ?></td>
<td><?php echo number_format($vals['amount'], 2, '.',''); ?></td>
</tr>
</tbody>
</table>
<?php */
?>
</div>
</div>
<script type="text/javascript">
function load_monthly_report(){
var year = $('input#year_field').val();
if(year<2015 || year>2065){
alert('Enter a valid year !');
return;
}
var month = $('select#month_field').val();
get_form(33,
function(html, tools) {
$('div#form-body').html(html);
$('div#content-body-action-tools').html(tools);
}, function(message) {
$('font#section_heading').empty();
$('div#form-body').empty();
alert(message);
},
year+'/'+month);
}
function on_print_clicked() {
var year = $('input#year_field').val();
var month = $('select#month_field option:selected').html();
$('div#print_container_header')
.html('<font style="color:#21ACD7; font-size:20px; ">MONTHLY REPORT OF '+year+' '+month+'</font>');
var html = $('div#content_table').html();
$('div#print_container_body').html(html);
print();
$('div#print_container_header').empty();
$('div#print_container_body').empty();
$('div#print_container_footer').empty();
}
</script>
<?php
$form = ob_get_clean();
return $form;
}
