<?php

$objGet = System::genObject('get');
list($objMinDate, $objMaxDate, $tableName) = System::GetRange($objGet->range, 'HmisPatientNursing', 'HmisPatientNursingActive');

function getDatesFromRange($start, $end, $format = 'Y-m-d') {
    $array = array();
    $interval = new DateInterval('P1D');

    $realEnd = new DateTime($end);
    $realEnd->add($interval);

    $period = new DatePeriod(new DateTime($start), $interval, $realEnd);

    foreach($period as $date) { 
        $array[] = $date->format($format); 
    }

    return $array;
}

$arrDataRange = getDatesFromRange($objMinDate->PhpDate('Y-m-d'), $objMaxDate->PhpDate('Y-m-d'));

$objDb = QApplication::$Database[1];

$strSQL = "
        SELECT 
                *	    
        FROM
            activity_nursing_adm_billing
	WHERE
	    activity_nursing_adm_billing.state = 'A'
            AND activity_nursing_adm_billing.product_name LIKE '%VISITE%' 
        ORDER BY billing_id, billing_group ASC
        ";
$objDbResult = $objDb->Query($strSQL);

if($objGet->Excel == 'Excel'){
    header("Content-type: application/vnd-ms-excel");
    header("Content-Disposition: attachment; filename=laporan-ruangan.xls");
}
$objUser = SystemUser::LoadById($objHmisPatientNursingAdmBilling->CreateUser);
$objProduct = HmisRefProduct::LoadById($objHmisPatientNursingAdmBilling->ProductName);

?>
<!DOCTYPE html>
<html>

<head>
    <meta charset='utf-8'>
    <meta http-equiv='X-UA-Compatible' content='IE=edge'>
    <title>Laporan Ruangan</title>
    <style>

.table {
  font-family: Arial, Helvetica, sans-serif;
  border-collapse: collapse;
  width: 100%;
}

.table td, .table th {
  border: 1px solid #ddd;
  padding: 8px;
}

/* .table tr:nth-child(even){background-color: #f2f2f2;} */

.table tr:hover {background-color: #ddd;}

.table th {
  padding-top: 12px;
  padding-bottom: 12px;
  text-align: center;
  background-color: #222;
  color: white;
}

    </style>
</head>

<body>

<?php
if($objGet->Excel != 'Excel'){
?>
<div class="noprint">
    <a href="#" onclick="window.close()">
    <img src="/promedika/assets/user/images/arrow.jpg" title="print" width="30" height="30">
    </a>
</div>
<?php
}
?>
<div class="container" style="margin-top: 20px; padding: 20px 40px">
<table id="tableLaporan" class="table">
      
    <thead>
      <tr>
            <th colspan="48">Laporan Jasa Pelayanan</th>
      </tr>
      <tr>
            <th></th>
            <th>PERIODE:</th>
            <th colspan="46" style="text-align: left"><?= $objGet->range ?></th>
      </tr>

      <tr>
            <th>NO.</th>
            <th>MR</th>
            <th>NAMA PASIEN</th>
            <th>LAYANAN ASAL</th>
            <th>JAMINAN</th>
	    <th>KODE</th>
            <th>KETERANGAN</th>
            <th>WAKTU</th>
	    <th>DOKTER PELAKSANAN</th>
	    
      </tr>
    </thead>
    <tbody>
<?php
    $no = 1;
    while($row = $objDbResult->FetchArray())
	
    {
	$objUser = SystemUser::LoadById($row['create_user']);
        $objProduct = HmisRefProduct::LoadById($row['product_id']);
        if($objProduct){
            $valJasaSarana = $objProduct->JasaSarana;
            $valJasaPelayanan = $objProduct->JasaPelayanan;
            $valJasaAdmin = $objProduct->JasaPelayanan * $objProduct->JasaAdmin;
            if($objProduct->RequestServiceToDepartmentId) {
               $objDepartment = SystemDepartment::LoadById($objProduct->RequestServiceToDepartmentId);
	       // $objDepartment = $objGet->departmentId;
            } 
	    else {
		$objDepartment = 0;
	    }
	    // $valJasaSarana = 1;
        }
	// $valJasaSarana = 1;

?>
        <tr>
            <td><?= $no ?></td>
            <td><?= $row['patient_code'] ?></td>
            <td><?= $row['patient_name'] ?></td>
	    <td><?= $row['patient_department_name'] ?></td>
            <td><?= $row['contract_service_name'] ?></td>
            <!--<td><?= $row['doctor_name'] ?></td>-->
	    <td><?= $row['product_code'] ?></td>
            <td><?= $row['product_name'] ?></td>
            <td><?= $row['create_time'] ?></td>
	    <td><?= $row['mediator_name'] ?></td>
        </tr>
<?php
        $strLastPatientNama = $row['patient_name'];
        $no++;
    }
// }
?>
</tbody>
</table>
<?php //echo nl2br($sqlPxDirawat) ?>
</body>
</html>