Пример #1
0
function searchDetail($pp_kod)
{
    $product = "SELECT * FROM p_product\n              WHERE pp_kod='{$pp_kod}'";
    $p_result = selQuery($product);
    $p_row = mysqli_fetch_assoc($p_result);
    $manu = "SELECT * FROM p_product_manu\n           WHERE ppm_pp_kod='{$pp_kod}' AND ppm_rmr_kod=1";
    $m_result = selQuery($manu);
    $m_row = mysqli_fetch_assoc($m_result);
    $manu = $m_row['ppm_osa_kod'];
    $m_sykt = "SELECT os_sykt,osa_alamat1,osa_alamat2,osa_alamat3,osa_poskod,osa_email,osa_notel FROM o_syarikat_add\n             JOIN o_syarikat ON o_syarikat.os_kod=o_syarikat_add.osa_os_kod\n             WHERE osa_kod='{$manu}'";
    $ms_result = selQuery($m_sykt);
    $ms_row = mysqli_fetch_assoc($ms_result);
    $holder = $p_row['pp_osa_kod_holder'];
    $h_sykt = "SELECT os_sykt,osa_alamat1,osa_alamat2,osa_alamat3,osa_poskod,osa_email,osa_notel FROM o_syarikat_add\n             JOIN o_syarikat ON o_syarikat.os_kod=o_syarikat_add.osa_os_kod\n             WHERE osa_kod='{$holder}'";
    $hs_result = selQuery($h_sykt);
    $hs_row = mysqli_fetch_assoc($hs_result);
    $dca = "SELECT pskm_no_msykt,pskm_tkh_msykt FROM p_product,p_skr_kmesyuarat\n          WHERE pp_kod='{$pp_kod}' AND p_product.pp_pskm_no_msykt=p_skr_kmesyuarat.pskm_kod";
    $dca_result = selQuery($dca);
    $dca_row = mysqli_fetch_assoc($dca_result);
    ?>
<div class="row" id="preview">
  <div class="tab-content pn br-n admin-form">
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Product Details</blockquote>
    </div>
    <div class="col-md-12">
      <div class="panel">
        <div class="panel-body">
          <table width="100%" class="table" cellpadding="5">
            <tr>
              <td width="24%">DCA Meeting No</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo isEmpty($dca_row['pskm_no_msykt']);
    ?>
</td>
              <td width="24%">Product Name</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo isEmpty($p_row['pp_nama']);
    ?>
</td>
            </tr>
            <tr>
              <td>DCA Meeting Date</td>
              <td>:</td>
              <td><?php 
    echo displayDate($dca_row['pskm_tkh_msykt']);
    ?>
</td>
              <td>Registration Date</td>
              <td>:</td>
              <td><?php 
    echo displayDate($p_row['pp_tkh_reg']);
    ?>
</td>
            </tr>
            <tr>
              <td>Registration No</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($p_row['pp_reg_no']);
    ?>
</td>
              <td>Dosage Form</td>
              <td>:</td>
              <td><?php 
    echo isEmpty(getSelDosage($p_row['pp_rd_kod']));
    ?>
</td>
            </tr>
            <tr>
              <td>Reference No</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($p_row['pp_ref_no']);
    ?>
</td>
              <td>Registration Status</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($p_row['pp_reg_no']);
    ?>
</td>
            </tr>
            <tr>
              <td>Product Classification</td>
              <td>:</td>
              <td><?php 
    echo productClass($p_row['pp_rkatp_kod']);
    ?>
</td>
              <td>Product Category</td>
              <td>:</td>
              <td><?php 
    echo productCategory($p_row['pp_rkatp_kod']);
    ?>
</td>
            </tr>
            <tr>
              <td>Product Status</td>
              <td>:</td>
              <td><?php 
    echo getAllStatus($p_row['pp_rs_kod'], $p_row['pp_status_nopayment']);
    ?>
</td>
              <td>Lab Status</td>
              <td>:</td>
              <td><?php 
    echo getAllStatus($p_row['pp_rs_kod_lab'], $p_row['pp_status_nopayment']);
    ?>
</td>
            </tr>
          </table>
        </div>
      </div>
    </div>
    <div class="col-md-12">
      <div class="panel">
        <div class="panel-body">
          <table width="100%" class="table" cellpadding="5">
            <tr>
              <td width="24%">Manufacturer</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo $ms_row['os_sykt'];
    ?>
</td>
              <td width="24%">Holder</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo $hs_row['os_sykt'];
    ?>
</td>
            </tr>
            <tr>
              <td>Address Manufacturer</td>
              <td>:</td>
              <td><?php 
    echo $ms_row['osa_alamat1'] . "<br/>" . $ms_row['osa_alamat2'] . "<br/>" . $ms_row['osa_alamat3'] . "<br/>" . $ms_row['osa_poskod'];
    ?>
</td>
              <td>Address Holder</td>
              <td>:</td>
              <td><?php 
    echo $hs_row['osa_alamat1'] . "<br/>" . $hs_row['osa_alamat2'] . "<br/>" . $hs_row['osa_alamat3'] . "<br/>" . $hs_row['osa_poskod'];
    ?>
</td>
            </tr>
            <tr>
              <td>Email Manufacturer</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($ms_row['osa_email']);
    ?>
</td>
              <td>Email Holder</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($hs_row['osa_email']);
    ?>
</td>
            </tr>
            <tr>
              <td>Phone No Manufacturer</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($ms_row['osa_notel']);
    ?>
</td>
              <td>Phone No Holder</td>
              <td>:</td>
              <td><?php 
    echo isEmpty($hs_row['osa_notel']);
    ?>
</td>
            </tr>
            <tr>
              <td>Contract Manufacturer</td>
              <td>:</td>
              <td>
                <?php 
    if ($m_row['ppm_contract'] == "Y") {
        echo "<i class='fa fa-check text-success'></i>'";
    } else {
        echo "<i class='fa fa-close text-danger'></i>";
    }
    ?>
              </td>
              <td>Repacker</td>
              <td>:</td>
              <td>
                <?php 
    if ($p_row['pp_repacker'] == "Y") {
        echo "<i class='fa fa-check text-success'></i>";
    } else {
        echo "<i class='fa fa-close text-danger'></i>";
    }
    ?>
              </td>
            </tr>
          </table>
        </div>
      </div>
    </div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Attachment</blockquote>
    </div>
    <div class="col-md-12">
      <div class="panel panel-primary">
        <div class="panel-body">
          <table width="100%" class="table" cellpadding="5">
            <tr>
              <td width="24%">COA Finished Product</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
              <td width="24%">Protocol of Analysis</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
            </tr>
            <tr>
              <td>COA API</td>
              <td>:</td>
              <td><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
              <td>Summary of Validation</td>
              <td>:</td>
              <td><?php 
    echo getAttachment($pp_kod, "sumofMethod");
    ?>
</td>
            </tr>
            <tr>
              <td>Additional Info</td>
              <td>:</td>
              <td colspan="4"><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
            </tr>
          </table>
        </div>
      </div>
    </div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Active Ingredient</blockquote>
    </div>
    <div class="col-md-12">
      <table id="tbl_ai" class="table table-striped table-hover" width="100%" cellspacing="0">
        <thead>
          <tr align="center" class="primary">
            <td width="5%">No</td>
            <td width="60%">Active Ingredient</td>
            <td width="15%">Strength</td>
            <td width="20%">Remarks</td>
          </tr>
        </thead>
        <tbody>
          <?php 
    $count = 1;
    $the = "SELECT ras_desc,pba_kekuatan,rbab_desc,pba_catatan\n            FROM p_bhn_aktif\n          \tLEFT JOIN ref_aktif_substance ON ras_kod = pba_ras_kod\n          \tLEFT JOIN ref_bhn_aktif_bhgn ON rbab_kod = pba_rbab_kod\n            WHERE pba_pp_kod ='{$pp_kod}'";
    $t_result = selQuery($the);
    while ($t_row = mysqli_fetch_assoc($t_result)) {
        ?>
            <tr align="center">
              <td><?php 
        echo $count++;
        ?>
</td>
              <td align="left"><?php 
        echo $t_row['ras_desc'];
        ?>
</td>
              <td><?php 
        echo $t_row['pba_kekuatan'];
        ?>
</td>
              <td align="left"><?php 
        echo $t_row['pba_catatan'];
        ?>
</td>
            </tr>
            <?php 
    }
    ?>
        </tbody>
      </table>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Excipient</blockquote>
    </div>
    <div class="col-md-12">
      <table id="tbl_exp" class="table table-striped table-hover" width="100%" cellspacing="0">
        <thead>
          <tr align="center" class="primary">
            <td width="5%">No</td>
            <td width="40%">Excipients</td>
            <td width="15%">Strength</td>
            <td width="20%">Function</td>
            <td width="20%">Remarks</td>
          </tr>
        </thead>
        <tbody>
          <?php 
    $count = 1;
    $query = "SELECT res_desc,ref_desc,pe_kekuatan,pe_remarks FROM p_eksipien\n                      LEFT JOIN ref_eksipien_substance ON res_kod = pe_res_kod\n                      LEFT JOIN ref_eksipien_fungsi ON ref_kod = pe_ref_kod\n                      WHERE pe_pp_kod='{$pp_kod}'";
    $t_result = selQuery($query);
    while ($t_row = mysqli_fetch_assoc($t_result)) {
        ?>
            <tr align="center">
              <td><?php 
        echo $count++;
        ?>
</td>
              <td align="left"><?php 
        echo $t_row['res_desc'];
        ?>
</td>
              <td><?php 
        echo $t_row['pe_kekuatan'];
        ?>
</td>
              <td align="left"><?php 
        echo $t_row['ref_desc'];
        ?>
</td>
              <td align="left"><?php 
        echo $t_row['pe_remarks'];
        ?>
</td>
            </tr>
            <?php 
    }
    ?>
        </tbody>
      </table>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Therapeutical</blockquote>
    </div>
    <div class="col-md-12">
      <table id="tbl_the" class="table table-striped table-hover" width="100%" cellspacing="0">
        <thead>
          <tr align="center" class="primary">
            <td width="5%">No</td>
            <td width="25%">Therapeutical Code</td>
            <td width="70%">Therapeutical Description</td>
          </tr>
        </thead>
        <tbody>
          <?php 
    $count = 1;
    $the = "SELECT pth_kod,pth_thera_code FROM p_therapeutical";
    $the .= " WHERE pth_pp_kod='{$pp_kod}'";
    $t_result = selQuery($the);
    while ($t_row = mysqli_fetch_assoc($t_result)) {
        ?>
            <tr align="center">
              <td><?php 
        echo $count++;
        ?>
</td>
              <td><?php 
        echo $t_row['pth_kod'];
        ?>
</td>
              <td><?php 
        echo $t_row['pth_thera_code'];
        ?>
</td>
            </tr>
            <?php 
    }
    ?>
        </tbody>
      </table>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Product Indication</blockquote>
    </div>
    <div class="col-md-12">
      <div class="section">
        <?php 
    $ind = "SELECT pp_indication FROM p_product_sec_a";
    $ind .= " WHERE ppa_pp_kod='{$pp_kod}'";
    $i_result = selQuery($ind);
    $i_row = mysqli_fetch_assoc($i_result);
    ?>
        <label class="field prepend-icon">
          <textarea class="gui-textarea" readonly=""></textarea>
          <label for="comment" class="field-icon">
            <i class="fa fa-comments"></i>
          </label>
            <span class="input-footer">Product Indication</span>
        </label>
      </div>
    </div>
    <div class="col-md-12">
      <blockquote class="blockquote-primary">Packaging Details</blockquote>
    </div>
    <div class="col-md-12">
      <div class="panel panel-primary">
        <div class="panel-body">
          <table width="100%" class="table" cellpadding="5">
            <tr>
              <td width="24%">Pack Size</td>
              <td width="1%">:</td>
              <td width="25%"></td>
              <td width="24%">Package Insert</td>
              <td width="1%">:</td>
              <td width="25%"><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
            </tr>
            <tr>
              <td>Container Type</td>
              <td>:</td>
              <td></td>
              <td>Mockup Label</td>
              <td>:</td>
              <td><?php 
    echo getAttachment($pp_kod, 34);
    ?>
</td>
            </tr>
            <tr>
              <td>Container Description</td>
              <td>:</td>
              <td colspan="4"></td>
            </tr>
          </table>
        </div>
      </div>
    </div>
  </div>
</div>
<?php 
}
Пример #2
0
function sampleDetail($id, $code, $sampleID)
{
    $status = 2;
    if ($id == 16) {
        if ($code == 1) {
            $status = screenStatus($sampleID);
            if ($status == 0) {
                $sql = "SELECT pp_nama AS sampleName,pp_kod AS sampleCode,rkatp_class,rkatp_desc,pp_osa_kod_holder,pp_osa_kod_owner FROM p_product\n              LEFT JOIN ref_kat_produk ON pp_rkatp_kod = rkatp_kod\n              WHERE pp_kod='{$sampleID}'";
            } else {
                $sql = "SELECT pp_nama AS sampleName,pp_kod AS sampleCode,rkatp_class,rkatp_desc,pp_osa_kod_holder,pp_osa_kod_owner FROM p_product,ref_kat_produk\n                WHERE pp_kod='{$sampleID}' AND pp_rkatp_kod=rkatp_kod";
            }
        } elseif ($code == 2) {
            $sql = "SELECT product_name AS sampleName,adrSampleID  AS sampleCode,remarks AS remark\n              ,quantity,batchno FROM adr_sample WHERE adrSampleID='{$sampleID}'";
        } elseif ($code == 3 || $code == 4) {
            $sql = "SELECT product_name AS sampleName,pSampleID AS sampleCode,remarks_to_lab AS remark\n              ,quantity,batchno FROM c_surv_sample WHERE pSampleID='{$sampleID}'";
        } elseif ($code == 6) {
            $sql = "SELECT *,kp_kuantiti_htr AS quantity,kp_batch_no AS batchno FROM k_produk WHERE kp_id='{$sampleID}'";
        }
    } else {
        $sql = "SELECT * FROM k_produk WHERE kp_id='{$sampleID}'";
    }
    ///echo $sql;
    $result = selQuery($sql);
    $row = mysqli_fetch_assoc($result);
    if ($id == 20) {
        $title = "Redistribute";
    } else {
        $title = sampleTitle($code);
    }
    ?>
<div class="tab-content pn br-n admin-form">
  <div class="row">
    <input type="hidden" id="mainTitle" value="<?php 
    echo $title;
    ?>
" />
    <input type="hidden" id="sampleID" value="<?php 
    echo $sampleID;
    ?>
">
    <div class="alert alert-sm alert-border-left alert-alert">Sample Information</div>
  </div>
  <div class="row">
    <?php 
    if ($id != 16) {
        ?>
    <div class="col-md-12" align="right">
      <?php 
        getBarcode($row['kp_sampel_no']);
        ?>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <?php 
    }
    if ($code == 1 and $id == 16) {
        ?>
      <div class="col-md-3">Call No</div>
      <div class="col-md-1">:</div>
      <div class="col-md-5"><?php 
        echo $sampleID;
        ?>
</div>
      <div class="col-md-12">&nbsp;</div>
    <?php 
    }
    if ($id != 16) {
        ?>
      <div class="col-md-3">Sample No</div>
      <div class="col-md-1">:</div>
      <div class="col-md-4"><?php 
        echo $row['kp_sampel_no'];
        ?>
</div>
      <div class="col-md-2" align="right">Store Status :</div>
      <div class="col-md-2" align="left">
        <?php 
        if ($row['kp_requestSpl'] == 0) {
            echo "<i class='fa fa-close text-danger'></i> Not Available";
        } else {
            echo "<i class='fa fa-check text-success'></i> Ready to collect";
        }
        ?>
      </div>
      <div class="col-md-12">&nbsp;</div>
    <?php 
    }
    ?>
      <div class="col-md-3">Product Name</div>
      <div class="col-md-1">:</div>
      <div class="col-md-8">
      <?php 
    if ($id == 16) {
        if ($code == 6) {
            echo $row['kp_product_name'];
            echo "<input type=\"hidden\" id=\"txt_code\" value=\"" . $row['kp_id'] . "\">";
            echo "<input type=\"hidden\" id=\"txt_name\" value=\"" . $row['kp_product_name'] . "\">";
        } else {
            echo $row['sampleName'];
            echo "<input type=\"hidden\" id=\"txt_code\" value=\"" . $row['sampleCode'] . "\">";
            echo "<input type=\"hidden\" id=\"txt_name\" value=\"" . $row['sampleName'] . "\">";
        }
    } else {
        echo $row['kp_product_name'];
    }
    ?>
    </div>
  <?php 
    if ($code == 1) {
        ?>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Product Category</div>
    <div class="col-md-1">:</div>
    <div class="col-md-5"><?php 
        echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Manufacturer</div>
    <div class="col-md-1">:</div>
    <div class="col-md-5"><?php 
        echo isempty(osaDetail($row['pp_osa_kod_owner']));
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Holder</div>
    <div class="col-md-1">:</div>
    <div class="col-md-5"><?php 
        echo isempty(osaDetail($row['pp_osa_kod_holder']));
        ?>
</div>
  <?php 
    }
    if ($code == 2 || $code == 3 || $code == 4) {
        ?>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Remarks</div>
    <div class="col-md-1">:</div>
    <div class="col-md-6">
      <label class="field prepend-icon">
        <textarea class="gui-textarea" id="txt_remark" readonly><?php 
        echo $row['remark'];
        ?>
</textarea>
        <label for="comment" class="field-icon">
          <i class="fa fa-comments"></i>
        </label>
        <span class="input-footer">Remarks from Pasca</span>
      </label>
    </div>
  <?php 
    }
    if ($id == 16) {
        ?>
    <div class="col-md-12">
      <div class="section-divider mb40">
        <span><b>To be filled by QCC Officer</b></span>
      </div>
    </div>
    <div class="col-md-3">Batch No <font style="color:red;">*</font></div>
    <div class="col-md-1">:</div>
    <div class="col-md-3">
      <label class="field prepend-icon">
        <input type="text" name="txt_batch" id="txt_batch" class="gui-input"  value="<?php 
        echo $row['batchno'];
        ?>
">
        <label for="txt_batch" class="field-icon">
          <i class="fa fa-calculator"></i>
        </label>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Quantity Received <font style="color:red;">*</font></div>
    <div class="col-md-1">:</div>
    <div class="col-md-3">
      <label class="field prepend-icon">
        <input type="text" name="txt_quantity" id="txt_quantity" class="gui-input" value="<?php 
        echo $row['quantity'];
        ?>
">
        <label for="txt_quantity" class="field-icon">
          <i class="fa fa-calculator"></i>
        </label>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Dosage</div>
    <div class="col-md-1">:</div>
    <div class="col-md-4">
      <label class="field select">
        <select id="txt_dosage">
          <?php 
        getDosage();
        ?>
        </select>
        <i class="arrow"></i>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Unit</div>
    <div class="col-md-1">:</div>
    <div class="col-md-4">
      <label class="field select">
        <select id="txt_unit">
          <?php 
        getSukatan();
        ?>
        </select>
        <i class="arrow"></i>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Expiry Date</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3">
      <label class="field prepend-icon">
        <input type="text" name="txt_expiry" id="txt_expiry" class="gui-input" readonly <?php 
        if ($code == 6) {
            echo "value=\"" . displayDate($row['kp_tkh_luput']) . "\"";
        }
        ?>
>
        <label for="txt_expiry" class="field-icon">
          <i class="fa fa-calendar"></i>
        </label>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Received Date <font style="color:red;">*</font></div>
    <div class="col-md-1">:</div>
    <div class="col-md-3">
      <label class="field prepend-icon">
        <input type="text" name="txt_received" id="txt_received" class="gui-input" readonly <?php 
        if ($code == 6) {
            echo "value=\"" . displayDate($row['kp_tkh_htr']) . "\"";
        }
        ?>
>
        <label for="txt_received" class="field-icon">
          <i class="fa fa-calendar"></i>
        </label>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Expected Complete Day(s) <font style="color:red;">*</font></div>
    <div class="col-md-1">:</div>
    <div class="col-md-3">
      <label class="field prepend-icon">
        <input type="number" name="txt_complete" id="txt_complete" class="gui-input" <?php 
        if ($code == 6) {
            echo "value=\"" . $row['kp_complete_day'] . "\"";
        }
        ?>
>
        <label for="txt_complete" class="field-icon">
          <i class="fa fa-calculator"></i>
        </label>
      </label>
    </div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Sender <font style="color:red;">*</font></div>
    <div class="col-md-1">:</div>
    <div class="col-md-4">
      <label class="field prepend-icon">
        <input type="text" name="txt_sender" id="txt_sender" class="gui-input" <?php 
        if ($code == 6) {
            echo "value=\"" . $row['kp_sender'] . "\"";
        }
        ?>
>
        <label for="txt_sender" class="field-icon">
          <i class="fa fa-user"></i>
        </label>
      </label>
    </div>
  <?php 
    } else {
        ?>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Batch No</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3"><?php 
        echo $row['kp_batch_no'];
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Quantity Received</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3"><?php 
        echo $row['kp_kuantiti_htr'];
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Dosage</div>
    <div class="col-md-1">:</div>
    <div class="col-md-4"><?php 
        echo getSelDosage($row['kp_rdk_kod']);
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Unit</div>
    <div class="col-md-1">:</div>
    <div class="col-md-4"><?php 
        echo getSukatan($row['kp_rskt_kod']);
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Expiry Date</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3"><?php 
        echo displayDate($row['kp_tkh_luput']);
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Received Date</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3"><?php 
        echo displayDate($row['kp_tkh_terima']);
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Expected Complete Date</div>
    <div class="col-md-1">:</div>
    <div class="col-md-3"><?php 
        echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']) . " (" . $row['kp_complete_day'] . " days)";
        ?>
</div>
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-3">Sender</div>
    <div class="col-md-1">:</div>
    <div class="col-md-4"><?php 
        echo $row['kp_sender'];
        ?>
</div>
  <?php 
    }
    ?>
  </div>
  <div class="row">
    <?php 
    if ($id == 19 || $id == 20) {
        ?>
      <div class="col-md-12">
        <div class="alert alert-sm alert-border-left alert-alert">Assign Sample</div>
      </div>
      <div class="col-md-3">Lab <font color="red">*</font></div>
      <div class="col-md-1">:</div>
      <div class="col-md-6">
        <select id="txt_lab" class="form-control">
            <option value='0'>-- Please Select --</option>
            <?php 
        getLab();
        ?>
        </select>
      </div>
      <div class="col-md-12">&nbsp;</div>
      <div class="col-md-3">Quantity <font color="red">*</font></div>
      <div class="col-md-1">:</div>
      <div class="col-md-3">
        <label class="field prepend-icon">
          <input type="text" name="txt_assign" id="txt_assign" class="gui-input">
          <label for="txt_assign" class="field-icon">
            <i class="fa fa-calculator"></i>
          </label>
        </label>
      </div>
      <div class="col-md-5">
        <button class="btn btn-alert" onclick="balance('<?php 
        echo $row['kp_id'];
        ?>
')"><i class="fa fa-plus"></i> Balance</button>
        <button class="btn btn-alert" onclick="assignSample('<?php 
        echo $sampleID;
        ?>
')"><i class="fa fa-pencil"></i> Assign Sample</button>
      </div>
      <div class="col-md-12">&nbsp;</div>
      <div class="col-md-12" id="sampleAssign"><?php 
        showTask($sampleID);
        ?>
</div>
      <div class="col-md-12">&nbsp;</div>
    <?php 
    } elseif ($id == 21 || $id == 23 || $id == 25 || $id == 27) {
        assignedTask($id, $sampleID, $_SESSION['ru_kod']);
    }
    if ($id != 27) {
        ?>
      <div class="col-md-12">&nbsp;</div>
      <div class="col-md-3"><?php 
        echo getComment($id);
        ?>
</div>
      <div class="col-md-1">:</div>
      <div class="col-md-6">
        <label class="field prepend-icon">
          <textarea class="gui-textarea" id="txt_comment" placeholder="Enter Comment..."><?php 
        echo getComments($id, $sampleID, $_SESSION['us_id']);
        ?>
</textarea>
          <label for="comment" class="field-icon">
            <i class="fa fa-comments"></i>
          </label>
          <span class="input-footer"><?php 
        echo getComment($id);
        ?>
</span>
        </label>
      </div>
      <div class="col-md-12"><font color="red">*</font> required field</div>
    <?php 
    }
    ?>
  </div>
  <div class="row">
    <div class="col-md-12">&nbsp;</div>
    <div class="col-md-12">
      <button class="btn btn-alert" onclick="content('<?php 
    echo $code;
    ?>
')"><i class="fa fa-arrow-left"></i> Back</button>
      <button class="btn btn-alert" onclick="showProduct('<?php 
    echo $code;
    ?>
')"><i class="fa fa-desktop"></i> Product Detail</button>
    <?php 
    if ($id == 16) {
        if (screenStatus($sampleID) != 1) {
            ?>
      <button class="btn btn-alert" onclick="receiveSample('<?php 
            echo $code;
            ?>
','<?php 
            echo $status;
            ?>
')"><i class="fa fa-check"></i> Receive Sample</button>
    <?php 
            if ($code == 1) {
                ?>
      <button class="btn btn-alert" onclick="rejectSample('<?php 
                echo $code;
                ?>
')"><i class="fa fa-close"></i> Reject Sample</button>
    <?php 
            }
        }
    } else {
        ?>
      <button class="btn btn-alert" onclick="printBarcode('<?php 
        echo $row['kp_sampel_no'];
        ?>
')"><i class="fa fa-print"></i> Print Barcode</button>
    <?php 
        if ($id == 23 and checkPharma($row['kp_id'], $_SESSION['ru_kod']) == 1) {
            ?>
      <button class="btn btn-alert" onclick="submitSample('<?php 
            echo $sampleID;
            ?>
','<?php 
            echo $row['kp_sampel_no'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-reply"></i> Send Back to Pharmacist</button>
    <?php 
        } elseif ($id == 25 and checkAssist($row['kp_id'], $_SESSION['ru_kod']) == 1) {
            ?>
      <button class="btn btn-alert" onclick="submitSample('<?php 
            echo $sampleID;
            ?>
','<?php 
            echo $row['kp_sampel_no'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-reply"></i> Send Back to Assistant Pharmacist</button>
    <?php 
        }
        ?>
      <button class="btn btn-alert" onclick="chronology(1,'<?php 
        echo $sampleID;
        ?>
')"><i class="fa fa-sort-alpha-asc"></i> Chronology</button>
    <?php 
        if ($id == 25 and checkAssist($row['kp_id'], $_SESSION['ru_kod']) == 1) {
            ?>
      <button class="btn btn-alert" onclick="approveAssist('<?php 
            echo $row['kp_id'];
            ?>
','<?php 
            echo $_SESSION['ru_kod'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-check"></i> Approve</button>
    <?php 
        } elseif ($id == 23 and checkPharma($row['kp_id'], $_SESSION['ru_kod']) == 1) {
            ?>
      <button class="btn btn-alert" onclick="approvePharma('<?php 
            echo $row['kp_id'];
            ?>
','<?php 
            echo $_SESSION['ru_kod'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-check"></i> Approve</button>
    <?php 
        } elseif ($id == 21) {
            ?>
      <button class="btn btn-alert" onclick="approveKU('<?php 
            echo $row['kp_id'];
            ?>
','<?php 
            echo $_SESSION['ru_kod'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-check"></i> Approve</button>
    <?php 
        } else {
            ?>
      <button class="btn btn-alert" onclick="submitSample('<?php 
            echo $sampleID;
            ?>
','<?php 
            echo $row['kp_sampel_no'];
            ?>
','<?php 
            echo $code;
            ?>
')"><i class="fa fa-send"></i> Submit</button>
    <?php 
        }
    }
    ?>
    </div>
  </div>
</div>
<?php 
}