range);
list($minDay,$minMonth,$minYear) = @explode('.',$minDate);
list($maxDay,$maxMonth,$maxYear) = @explode('.',$maxDate);
$objMinDate = new QDateTime($minYear.'-'.$minMonth.'-'.$minDay.'00:00:00');
$objMaxDate = new QDateTime($maxYear.'-'.$maxMonth.'-'.$maxDay.'23:59:59');
$now = QDateTime::Now();
$tableName = 'Activity';
$arrCondition = array();
$arrCondition[] = QQ::Equal(QQN::$tableName()->State,'A');
$arrCondition[] = QQ::GreaterOrEqual(QQN::$tableName()->ActivityDateTime, $objMinDate);
$arrCondition[] = QQ::LessOrEqual(QQN::$tableName()->ActivityDateTime, $objMaxDate);
// $arrCondition[] = QQ::Equal(QQN::$tableName()->ActivityName, 'PEMBELIAN-LANGSUNG');
$arrCondition[] = QQ::Equal(QQN::$tableName()->Actor, 'LAB-PK');
$condition = QQ::AndCondition($arrCondition);
$totalData = $tableName::QueryCount($condition);
$arrReturn['recordsTotal'] = $totalData;
$arrReturn['recordsFiltered'] = $totalData;
$objClauses = array();
$objClauses[] = QQ::OrderBy(QQN::$tableName()->Id,'desc');
$arrData = array();
?>
Laporan
range ?>
| Laporan Detail Pemeriksaan |
| PERIODE: |
range ?> |
Id'
AND on_timeline BETWEEN '" . $objMinDate->PhpDate('Y-m-d H:i:s') . "' AND '" . $objMaxDate->PhpDate('Y-m-d H:i:s') . "'
order by contract_service_name ASC
";
$objDbResult = $objDb->Query($strSQL);
$nomor = 0;
$subTotal = 0;
while ($row = $objDbResult->FetchArray()) {
$subTotal = $row['contract_service_name'];
$rm = $row['patient_code'];
$alamat = $row['patient_name']; $alamat1 = $row['patient_department_name'];
$totalKeseluruhan += round($row['current_price'],2);
?>
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL |
|
|
|