' . "Room Energy Usage" . '
';
$msg .= '
' . TABLE_VIEW_BY . ': ' . "Room Energy Usage" . '';
$excelContent .= "Customer Check In/Out" . "\n";
$excelContent .= TABLE_VIEW_BY . ": Room Energy Usage\n\n";
if ($_POST['date_from'] != '') {
$msg .= REPORT_FROM . ': ' . $_POST['date_from'];
$excelContent .= REPORT_FROM . ': ' . $_POST['date_from'];
}
if ($_POST['date_to'] != '') {
$msg .= ' ' . REPORT_TO . ': ' . $_POST['date_to'];
$excelContent .= ' ' . REPORT_TO . ': ' . $_POST['date_to'] . "\n\n";
}
echo $this->element('/print/header-report', array('msg' => $msg));
?>
|
|
|
|
|
|
|
|
|
|
|
|
|
= DATE(on_date)';
}
$condition != '' ? $condition .= ' AND ' : '';
if ($col[3] == '') {
$condition .= 'room_control_logs.status>=0';
} else {
$condition .= 'room_control_logs.status=' . $col[3];
}
if ($col[4] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'room_control_logs.room_type_id =' . $col[4] . '';
}
if ($col[5] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'room_control_logs.floor_id =' . $col[5] . '';
}
if ($col[6] != '') {
$condition != '' ? $condition .= ' AND ' : '';
$condition .= 'room_control_logs.is_clean =' . $col[6] . '';
}
// if ($col[5] != '') {
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'company_id=' . $col[5];
// }else{
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'company_id IN (SELECT company_id FROM user_companies WHERE user_id = '.$user['User']['id'].')';
// }
// if ($col[6] != '') {
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'branch_id=' . $col[6];
// }else{
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'branch_id IN (SELECT branch_id FROM user_branches WHERE user_id = '.$user['User']['id'].')';
// }
// if ($col[7] != '') {
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'created_by=' . $col[7];
// }
// if ($col[8] != '') {
// $condition != '' ? $condition .= ' AND ' : '';
// $condition .= 'customer_id=' . $col[8];
// }
// declare
$grandTotalAmount = 0;
$excelContent .= "\n" . 'Product'; ?>
| |
| Service |
diff($endDate);
$consumed = $data['consumed'];
$range = "";
$energyCal = "";
if ($consumed > 0 && $consumed <= 10) {
$range = "Tier 1";
$energyCal = ($consumed * 380) + ($consumed * 480) + ($consumed * 610);
} elseif ($consumed <= 50) {
$range = "Tier 2";
$energyCal = ($consumed * 380) + ($consumed * 480) + ($consumed * 610);
} elseif ($consumed <= 200) {
$range = "Tier 3";
$energyCal = ($consumed * 380) + ($consumed * 480) + ($consumed * 610);
} else {
$range = "Tier 4";
$energyCal = ($consumed * 380) + ($consumed * 480) + ($consumed * 610);
}
$energyConsumeRates = mysql_query("SELECT rate FROM energy_consume_rates WHERE name = LIKE '".$range."' AND is_active = 1");
$fetchEnergyConsumeRate = mysql_fetch_array($energyConsumeRates);
?>
|
|
|
|
|
|
|
format('%H h, %I mn, %S s'); ?>
|
|
|
|
|
|
|