143 lines
4.0 KiB
PHP
143 lines
4.0 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="<?php echo trans('cldr'); ?>">
|
|
<head>
|
|
<title><?php echo trans('sales_by_date'); ?></title>
|
|
<link rel="stylesheet"
|
|
href="<?php echo base_url(); ?>assets/<?php echo get_setting('system_theme', 'invoiceplane'); ?>/css/reports.css"
|
|
type="text/css">
|
|
|
|
</head>
|
|
|
|
<body>
|
|
<h3 class="report_title">
|
|
<?php echo trans('sales_by_date'); ?>
|
|
<br/>
|
|
<small><?php echo $from_date . ' - ' . $to_date ?></small>
|
|
</h3>
|
|
|
|
<table class="table table-striped table-condensed no-margin">
|
|
|
|
<tr>
|
|
<th style="width:15%;text-align:center;border-bottom: none;"> <?php echo trans('vat_id'); ?> </th>
|
|
<th style="width:50%;text-align:center;border-bottom: none;"> <?php echo trans('name'); ?> </th>
|
|
<th style="width:15%;text-align:center;border-bottom: none;"> <?php echo trans('period'); ?> </th>
|
|
<th style="width:20%;text-align:center;border-bottom: none;"> <?php echo trans('quantity'); ?> </th>
|
|
</tr>
|
|
|
|
<tr>
|
|
<td colspan="4" style="border-bottom: none;">
|
|
<hr/>
|
|
</td>
|
|
</tr>
|
|
|
|
<?php
|
|
$initial_year = 0;
|
|
$final_year = 0;
|
|
$numYears = 1;
|
|
$numRows = 1;
|
|
$contRows = 0;
|
|
$contYears = 0;
|
|
$pattern = '/^payment_*/i';
|
|
$tr1=0;
|
|
foreach ($results as $result) {
|
|
|
|
if ($final_year == 0) {
|
|
|
|
foreach ($result as $index => $value) {
|
|
|
|
if ($initial_year == 0) {
|
|
$initial_year = intval(substr($index, 11, 4));
|
|
};
|
|
|
|
$aux = intval(substr($index, 11, 4));
|
|
|
|
if ($aux > $final_year) {
|
|
$final_year = $aux;
|
|
}
|
|
|
|
}
|
|
}
|
|
|
|
if ($contYears == 0 && ($final_year - $initial_year) > 0) {
|
|
$numYears = $final_year - $initial_year + 1;
|
|
$contYears = 1;
|
|
}
|
|
|
|
if ($contRows == 0) {
|
|
$numRows = $numRows + ($numYears * 4);
|
|
$contRows = 1;
|
|
}
|
|
?>
|
|
|
|
<tr>
|
|
<td style="border-bottom: none;text-align:center;"><?php echo $result->VAT_ID; ?></td>
|
|
<td style="border-bottom: none;text-align:center;" rowspan="<?php echo $numRows; ?>"
|
|
valign="top"><?php _htmlsc($result->Name); ?></td>
|
|
<td style="border-bottom: none;text-align:center;"><?php echo trans('annual'); ?></td>
|
|
<td style="border-bottom: none;text-align:center;"><?php
|
|
$tr1= $tr1 + $result->total_payment;
|
|
echo format_currency($result->total_payment); ?></td>
|
|
</tr>
|
|
|
|
<?php
|
|
|
|
foreach ($result as $index => $value) {
|
|
|
|
$quarter = substr($index, 8, 2);
|
|
$year = substr($index, 11, 4);
|
|
|
|
if (preg_match($pattern, $index)) {
|
|
?>
|
|
|
|
<tr>
|
|
<td style="border-bottom: none;"> </td>
|
|
<td style="border-bottom: none;text-align:center;"><?php
|
|
if ($quarter == "t1") {
|
|
echo trans('Q1') . "/" . $year;
|
|
} else if ($quarter == "t2") {
|
|
echo trans('Q2') . "/" . $year;
|
|
} else if ($quarter == "t3") {
|
|
echo trans('Q3') . "/" . $year;
|
|
} else if ($quarter == "t4") {
|
|
echo trans('Q4') . "/" . $year;
|
|
}
|
|
?></td>
|
|
<td style="border-bottom: none;text-align:center;"><?php if ($value > 0) {
|
|
echo format_currency($value);
|
|
} ?></td>
|
|
</tr>
|
|
|
|
<?php }
|
|
} ?>
|
|
<tr>
|
|
<td colspan="4" style="border-bottom: none;">
|
|
<hr/>
|
|
</td>
|
|
</tr>
|
|
|
|
<?php } ?>
|
|
<tr>
|
|
<td style="text-align:center;"><strong>Total</strong></td>
|
|
<td class="amount"><strong>
|
|
|
|
</strong>
|
|
</td>
|
|
<td class="amount"><strong>
|
|
|
|
</strong>
|
|
</td>
|
|
<td><strong><center>
|
|
<?php
|
|
{
|
|
echo format_currency($tr1,2,'.','');
|
|
|
|
}
|
|
?>
|
|
</center>
|
|
</strong>
|
|
</td>
|
|
</table>
|
|
|
|
</body>
|
|
</html>
|