<?php
if (!session_id()) {
    session_start();
}

require_once 'main.php';
require_once('SQLServerDb.php');

$db_pec = new SQLServerDb(
    $_ENV['PEC_DB_USER'],
    $_ENV['PEC_DB_PASS'],
    $_ENV['PEC_DB_NAME'],
    $_ENV['PEC_DB_HOST']
);
$post = $_REQUEST;

if (array_key_exists('rekap_poct', $post) && $post['rekap_poct'] == true) {
    global $db_pec;
    global $db;

    $is_time= false;
    if(!empty($post['time_order_start']) && !empty($post['time_order_end'])){
        $date_start = date_create($post['tanggal_order_start'] .' '. $post['time_order_start']);
        $date_start = date_format($date_start, "Y-m-d H:i:s");

        $date_end = date_create($post['tanggal_order_start'] .' '. $post['time_order_end']);
        $date_end = date_format($date_end, "Y-m-d H:i:s");

        $is_time = true;
    }

    if($is_time){
        $tmp_list_trans = $db_pec->get_results("SELECT  p.ID as p_id,p.Lab_PatientID as nomr,p.Location as ruang,r.ID as r_id,r.UnivTestName as DN,r.RValue as rvalue,
			r.Unit as unit,r.ANormalFlag as normalflah,convert(varchar, r.TestEndDate, 20) as specimen_dttm,op.FirstName,op.LastName, convert(varchar, p.lastUpdDatetime, 20) as lastUpdDatetime, r.InstrSectionID
			from Patient as p 
			left join Result as r on p.ID = r._PID
			left join Operator as op on r.OperatiorID = op.OperatorID
			where convert(datetime,r.TestEndDate) between CONVERT(datetime, '".$date_start."' ) and CONVERT(datetime, '".$date_end."')
			order by r.TestEndDate, p.Lab_PatientID desc", 'array');
    }else{
        $tmp_list_trans = $db_pec->get_results("SELECT  p.ID as p_id,p.Lab_PatientID as nomr,p.Location as ruang,r.ID as r_id,r.UnivTestName as DN,r.RValue as rvalue,
			r.Unit as unit,r.ANormalFlag as normalflah,convert(varchar, r.TestEndDate, 20) as specimen_dttm,op.FirstName,op.LastName, convert(varchar, p.lastUpdDatetime, 20) as lastUpdDatetime, r.InstrSectionID
			from Patient as p 
			left join Result as r on p.ID = r._PID
			left join Operator as op on r.OperatiorID = op.OperatorID
			where convert(date,r.TestEndDate) = '".$date_start."' 
			order by r.TestEndDate, p.Lab_PatientID desc", 'array');
    }

    $arr_pasien = [];
    if(count($tmp_list_trans) > 0){
        $no = 1;
        foreach($tmp_list_trans as $ind => $list){
            $is_data = false;
            $data_poct = '';
            if(strlen($list['nomr']) > 10){

                if(strlen($list['nomr']) == 20){
                    $order_poct_sql = $db->query("SELECT order_poct.*,m_pasien.nama as nama_pasien, m_ruang.nama as ruangan, m_ruang.no as kode_ruangan, m_perawat.nama as operator, m_pasien.tgllahir as tgl_lahir from order_poct
												join m_pasien on m_pasien.nomr  = order_poct.norm
												join m_ruang on m_ruang.no = order_poct.ruang_id
												join m_perawat on m_perawat.idperawat  = order_poct.operator_id
												where no_pemeriksaan = '{$list['nomr']}' 
												  --and (is_valid = 2 or is_valid = 0 or is_valid is null) 
												");
                }else{
                    $order_poct_sql = $db->query("SELECT order_poct.*,m_pasien.nama as nama_pasien, m_ruang.nama as ruangan, m_ruang.no as kode_ruangan, m_perawat.nama as operator, m_pasien.tgllahir as tgl_lahir from order_poct
												join m_pasien on m_pasien.nomr  = order_poct.norm
												join m_ruang on m_ruang.no = order_poct.ruang_id 
												join m_perawat on m_perawat.idperawat  = order_poct.operator_id 
												where upper(order_number) = '{$list['nomr']}' 
												  --and (is_valid = 2 or is_valid = 0 or is_valid is null) 
												");
                }
                $order_poct = $order_poct_sql->fetchAll()[0];
                if(!empty($order_poct)){
                    $is_data = true;
                    $data_poct = $order_poct;
                }
            }

            $arr_pasien[$ind]['no'] = $no++;
            $arr_pasien[$ind]['nomr'] = ($is_data) ? $data_poct['norm'] : $list['nomr'];
            $arr_pasien[$ind]['nama_pasien'] = ($is_data) ? $data_poct['nama_pasien'] : '';
            $arr_pasien[$ind]['no_billing'] = ($is_data) ? $data_poct['no_billing'] : '' ;
            $arr_pasien[$ind]['date'] = $list['specimen_dttm'];
            $arr_pasien[$ind]['InstrSectionID'] = $list['InstrSectionID'];
            $arr_pasien[$ind]['ruang'] = $list['ruang'];
            $arr_pasien[$ind]['hasil'] = $list['rvalue'];
            $arr_pasien[$ind]['unit'] = $list['unit'];
            $arr_pasien[$ind]['data_order'] = ($is_data) ? "ADA" :"TIDAK";
        }

    }

}
?>

<div class="row">
    <div class="col-md-12">
        <table class="table table-striped">
            <tr>
                <td>No</td>
                <td>Norm</td>
                <td>Nama</td>
                <td>No Billing</td>
                <td>Tanggal Pemeriksaan</td>
                <td>Analyser</td>
                <td>Hasil</td>
                <td>Ruangan</td>
                <td>Order</td>
            </tr>
            <?php
            $no = 1;
            foreach($arr_pasien as $ind => $item) : ?>
                <tr>
                    <td><?= $no++ ?></td>
                    <td><?= $item['nomr'] ?></td>
                    <td><?= $item['nama_pasien'] ?></td>
                    <td><?= $item['no_billing'] ?></td>
                    <td><?= $item['date'] ?></td>
                    <td><?= $item['InstrSectionID'] ?></td>
                    <td><?= $item['hasil'] .' ' . $item['unit']  ?></td>
                    <td><?= $item['ruang'] ?></td>
                    <td><?= $item['data_order'] ?></td>
                </tr>
            <?php endforeach ?>
        </table>
    </div>
</div>