コード例 #1
0
ファイル: pkk.php プロジェクト: syafiqazwan/pharmaco
function content($id, $code, $unit)
{
    if (access($id, $_SESSION['us_id']) == true) {
        if ($id == 1 or $id == 4 or $id == 7 or $id == 10 or $id == 13) {
            if ($id == 1) {
                $query = "SELECT pp_kod,pp_nama,pp_tkh_submit,pp_rs_kod_lab,pp_rs_kod_api,pp_rs_kod_product,rkatp_desc,rkatp_class FROM p_product,ref_kat_produk\n                  WHERE pp_rkatp_kod=rkatp_kod AND pp_rs_kod=1105 AND pp_rkatp_kod IN(3,23,24,1,25,26,27,7,8,29,30,33)";
            } else {
                $query = "SELECT pp_kod,pp_nama,pp_tkh_submit,pp_rs_kod_lab,pp_rs_kod_api,pp_rs_kod_product,rkatp_desc,rkatp_class FROM p_product,ref_kat_produk\n                  WHERE pp_rkatp_kod=rkatp_kod AND pp_rs_kod IN(1107,1110,1111,1112) AND pp_rkatp_kod IN(3,23,24,1,25,26,27,7,8,29,30,33)";
            }
            ?>
  <div class="tab-content pn br-n admin-form">
    <div class="row">
      <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
        <thead>
          <tr class="primary" align="center">
            <td width="5%">No</td>
            <td width="10%">Call No</td>
            <td width="25%">Product Name</td>
            <td width="15%">Received  Date</td>
            <td width="15%">Lab Status</td>
            <td width="15%">API Status</td>
            <td width="15%">Product Status</td>
          </tr>
        </thead>
        <tbody>
          <?php 
            $count = 1;
            $result = selQuery($query);
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
            <tr align="center">
              <td><?php 
                echo $count++;
                ?>
</td>
              <td><?php 
                echo $row['pp_kod'];
                ?>
</td>
              <td align="left">
                <div class="text-primary">
                  <b><?php 
                echo $row['pp_nama'];
                ?>
</b>
                </div>
                <div class="text-muted">
                  <?php 
                echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                ?>
                </div>
              </td>
              <td><?php 
                echo displayDate($row['pp_tkh_submit']);
                ?>
</td>
              <td align="left"><?php 
                echo protocolStatus($row['pp_rs_kod_lab'], $id);
                ?>
</td>
              <td align="left"><?php 
                echo protocolStatus($row['pp_rs_kod_api'], $id);
                ?>
</td>
              <td align="left"><?php 
                echo protocolStatus($row['pp_rs_kod_product'], $id);
                ?>
</td>
            </tr>
          <?php 
            }
            ?>
        </tbody>
      </table>
    </div>
  </div>
<?php 
        } elseif ($id == 2) {
            ?>
  <div class="tab-content pn br-n admin-form">
    <div class="row">
      <input type="hidden" id="mainTitle" value="<?php 
            echo protocolTitle($code);
            ?>
">
      <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
        <thead>
          <tr class="primary" align="center">
            <td width="5%">No</td>
            <td width="10%">Call No</td>
            <td width="45%">Product Name</td>
            <td width="15%">Submission Date</td>
            <td width="10%">Aging</td>
            <td width="25%">Status</td>
          </tr>
        </thead>
        <tbody>
          <?php 
            $count = 1;
            //echo getProtocol($code,$id,"A");
            $result = selQuery(getProtocol($code, $id, "A"));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
          <tr align="center">
            <td><?php 
                echo $count++;
                ?>
</td>
            <td><?php 
                echo $row['pp_kod'];
                ?>
</td>
            <td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php 
                echo $code;
                ?>
','<?php 
                echo $row['pp_kod'];
                ?>
')"><?php 
                echo $row['pp_nama'];
                ?>
</a></b></div><div class="text-muted"><?php 
                echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                ?>
</div></td>
            <td><?php 
                echo displayDate($row['pp_tkh_submit']);
                ?>
</td>
            <td><?php 
                echo aging($row['pp_tkh_submit']);
                ?>
</td>
            <td align="left"><?php 
                echo getStatus($row['pp_rs_kod_lab']);
                ?>
</td>
          </tr>
          <?php 
            }
            ?>
        </tbody>
      </table>
    </div>
  </div>
  <?php 
        } elseif ($id == 5 or $id == 8 or $id == 11 or $id == 14) {
            ?>
<div class="tab-content pn br-n admin-form">
  <input type="hidden" id="mainTitle" value="<?php 
            echo protocolTitle($code);
            ?>
">
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
        <thead>
          <tr class="primary" align="center">
            <?php 
            if ($id == 5) {
                ?>
              <td width="2%">&nbsp;</td>
              <td width="2%">No</td>
              <td width="16%">Reference No</td>
              <td width="50%">Product Name</td>
              <td width="10%">Approve Date</td>
              <td width="5%">Aging</td>
              <td width="15%">Status</td>
            <?php 
            } else {
                ?>
              <td width="2%">No</td>
              <td width="18%">Reference No</td>
              <td width="50%">Product Name</td>
              <td width="10%">Approve Date</td>
              <td width="5%">Aging</td>
              <td width="15%">Status</td>
            <?php 
            }
            ?>
          </tr>
        </thead>
        <tbody>
          <?php 
            $count = 1;
            //echo getProtocol($id,$code,$_SESSION['ru_kod'],$_SESSION['us_id'],'P');
            $result = selQuery(getProtocol($code, $id, 'P'));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
          <tr align="center">
            <?php 
                if ($id == 5) {
                    ?>
              <td><input type="checkbox" value="<?php 
                    echo $row["pp_kod"];
                    ?>
"></td>
              <td><?php 
                    echo $count++;
                    ?>
</td>
              <td><?php 
                    echo $row['pp_ref_no'];
                    ?>
</td>
              <td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['pp_kod'];
                    ?>
')"><?php 
                    echo $row['pp_nama'];
                    ?>
</a></b></div><div class="text-muted"><?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
</div></td>
              <td><?php 
                    echo displayDate($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo aging($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo checkStatus($row['pp_kod']);
                    ?>
</td>
            <?php 
                } else {
                    ?>
              <td><?php 
                    echo $count++;
                    ?>
</td>
              <td align="left"><?php 
                    echo $row['pp_ref_no'];
                    ?>
</td>
              <td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['pp_kod'];
                    ?>
')"><?php 
                    echo $row['pp_nama'];
                    ?>
</a></b></div><div class="text-muted"><?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
</div></td>
              <td><?php 
                    echo displayDate($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo aging($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo checkStatus($row['pp_kod']);
                    ?>
</td>
            <?php 
                }
                ?>
          </tr>
          <?php 
            }
            ?>
        </tbody>
      </table>
  </div>
  <?php 
            if ($id == 5) {
                ?>
  <div class="row" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Move to
        <span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li>
          <a onclick="changePriority('primary','protocol','<?php 
                echo $code;
                ?>
')">Normal List</a>
        </li>
      </ul>
    </div>
  </div>
  <?php 
            }
            ?>
  <div class="row">
    <div class="section-divider"></div>
  </div>
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-primary"><b>Normal List</b></div>
    <table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
        <thead>
          <tr class="primary" align="center">
            <?php 
            if ($id == 5) {
                ?>
              <td width="2%">&nbsp;</td>
              <td width="2%">No</td>
              <td width="16%">Reference No</td>
              <td width="50%">Product Name</td>
              <td width="10%">Approve Date</td>
              <td width="5%">Aging</td>
              <td width="15%">Status</td>
            <?php 
            } else {
                ?>
              <td width="2%">No</td>
              <td width="18%">Reference No</td>
              <td width="50%">Product Name</td>
              <td width="10%">Approve Date</td>
              <td width="5%">Aging</td>
              <td width="15%">Status</td>
            <?php 
            }
            ?>
          </tr>
        </thead>
        <tbody>
          <?php 
            $count = 1;
            $result = selQuery(getProtocol($code, $id, 'N'));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
          <tr align="center">
            <?php 
                if ($id == 5) {
                    ?>
              <td><input type="checkbox" value="<?php 
                    echo $row["pp_kod"];
                    ?>
"></td>
              <td><?php 
                    echo $count++;
                    ?>
</td>
              <td align="left"><?php 
                    echo $row['pp_ref_no'];
                    ?>
</td>
              <td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['pp_kod'];
                    ?>
')"><?php 
                    echo $row['pp_nama'];
                    ?>
</a></b></div><div class="text-muted"><?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
</div></td>
              <td><?php 
                    echo displayDate($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo aging($row['pp_tkh_approve']);
                    ?>
</td>
              <td><?php 
                    echo checkStatus($row['pp_kod']);
                    ?>
</td>
            <?php 
                } else {
                    if ($row['la_rs_kod'] == 443 and $row['la_us_id'] == $_SESSION['ru_kod']) {
                        echo $row['la_rs_kod'] . $row['la_us_id'];
                    } else {
                        ?>
              <td><?php 
                        echo $count++;
                        ?>
</td>
              <td align="left"><?php 
                        echo $row['pp_ref_no'];
                        ?>
</td>
              <td align="left"><div><b><a style="cursor:pointer;" onclick="detail('<?php 
                        echo $code;
                        ?>
','<?php 
                        echo $row['pp_kod'];
                        ?>
')"><?php 
                        echo $row['pp_nama'];
                        ?>
</a></b></div><div class="text-muted"><?php 
                        echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                        ?>
</div></td>
              <td><?php 
                        echo displayDate($row['pp_tkh_approve']);
                        ?>
</td>
              <td><?php 
                        echo aging($row['pp_tkh_approve']);
                        ?>
</td>
              <td><?php 
                        echo checkStatus($row['pp_kod']);
                        ?>
</td>
            <?php 
                    }
                    ?>
          </tr>
          <?php 
                }
            }
            ?>
        </tbody>
      </table>
  </div>
  <?php 
            if ($id == 5) {
                ?>
  <div class="row" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-primary dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Move to
        <span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li>
          <a onclick="changePriority('second','protocol','<?php 
                echo $code;
                ?>
')">Priority List</a>
        </li>
      </ul>
    </div>
  </div>
  <?php 
            }
            ?>
</div>
<?php 
        } elseif ($id == 3 or $id == 6 or $id == 9 or $id == 12 or $id == 15) {
            ?>
  <div class="tab-content pn br-n admin-form">
    <div class="row">
      <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
        <thead>
          <tr class="primary" align="center">
            <td width="5%">No</td>
            <td width='15%'>
            <?php 
            if ($id == 3) {
                echo "Call No";
            } else {
                echo "Reference No";
            }
            ?>
            </td>
            <td width="35%">Product Name</td>
            <td width="15%">
              <?php 
            if ($id == 3) {
                echo "Screening Date";
            } else {
                echo "Approve Date";
            }
            ?>
            </td>
            <td width="15%">Status</td>
            <td width="20%">Action</td>
          </tr>
        </thead>
        <tbody>
          <?php 
            $count = 1;
            $query = "SELECT pp_kod,pp_ref_no,pp_nama,pp_pkk_screen_tkh,rkatp_desc,rkatp_class FROM p_product\n                      LEFT JOIN ref_kat_produk ON pp_rkatp_kod = rkatp_kod";
            if ($id == 12 || $id == 15) {
                $query .= " LEFT JOIN lab_assign ON la_pp_kod=pp_kod";
            }
            if ($id == 3) {
                $query .= " WHERE pp_rs_kod_lab in(9002,9003) AND pp_status_nopayment='1' AND pp_rs_kod in(1103,1105)";
            } elseif ($id == 6) {
                $query .= " WHERE pp_rs_kod_lab=402 AND pp_status_nopayment='2' AND pp_rs_kod=1103";
            } elseif ($id == 12) {
                $query .= " WHERE pp_rs_kod_lab=402 AND pp_status_nopayment='2' AND pp_rs_kod IN(1103,1110) AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN (403,443) GROUP BY pp_kod";
            } elseif ($id == 15) {
                $query .= " WHERE pp_rs_kod_lab IN('1111','1112') AND pp_status_nopayment='2' AND pp_rs_kod IN (1112,1111,1110,1103) AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN(408,1110) GROUP BY pp_kod";
            }
            $result = selQuery($query);
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
          <tr align="center">
            <td><?php 
                echo $count++;
                ?>
</td>
            <td>
              <?php 
                if ($id == 3) {
                    echo $row['pp_kod'];
                } else {
                    echo $row['pp_ref_no'];
                }
                ?>
            </td>
            <td align="left"><div><b><a style="cursor:pointer;" onclick="viewDetail('<?php 
                echo $row['pp_kod'];
                ?>
')"><?php 
                echo $row['pp_nama'];
                ?>
</a></b></div><div class="text-muted"><?php 
                echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                ?>
</td>
            <td><?php 
                echo displayDate($row['pp_pkk_screen_tkh']);
                ?>
</td>
            <td align="left"><?php 
                echo checkStatus($row['pp_kod']);
                ?>
</td>
            <td>
              <?php 
                if ($id == 6) {
                    ?>
                <a style="cursor:pointer;" title="Reassign Lab" onclick="viewLab('<?php 
                    echo $row['pp_kod'];
                    ?>
')"><i class="fa fa-random fa-lg"></i></a>
              <?php 
                } elseif ($id == 12) {
                    ?>
                <a style="cursor:pointer;" title="Reassign Pharmacist" onclick="viewPharmacist('<?php 
                    echo $row['pp_kod'];
                    ?>
')"><i class="fa fa-random fa-lg"></i></a>
              <?php 
                }
                ?>
              <a style="cursor:pointer;" title="View Checklist" class="ml10" data-toggle="popover" data-content="And here's some amazing content. It's very engaging. Right?" onclick="viewChecklist('<?php 
                echo $row['pp_kod'];
                ?>
')"><i class="fa fa-list fa-lg"></i></a>
			        <a style="cursor:pointer;" title="View Chronology" class="ml10" onclick="chronology(0,'<?php 
                echo $row['pp_kod'];
                ?>
')"><i class="fa fa-sort-alpha-asc fa-lg"></i></a>
            </td>
          </tr>
          <?php 
            }
            ?>
        </tbody>
      </table>
    </div>
  </div>
<?php 
        } elseif ($id == 16) {
            ?>
<div class="tab-content pn br-n admin-form">
  <input type="hidden" id="mainTitle" value="<?php 
            echo sampleTitle($code);
            ?>
">
  <?php 
            if ($code == 3 || $code == 4) {
                ?>
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-alert"><b>Pharma</b></div>
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <td width="5%">No</td>
          <td width="15%">
            <?php 
                if ($code == 3) {
                    echo "Complaint No";
                } else {
                    echo "Surveillance No";
                }
                ?>
          </td>
          <td width="15%">Registration No</td>
          <td width="35%">Product Name</td>
          <td width="15%">Send Date</td>
          <td width="15%">Aging</td>
        </tr>
      </thead>
      <tbody>
        <?php 
                $count = 1;
                $result = selQuery(getSample($code, $id, 1));
                while ($row = mysqli_fetch_assoc($result)) {
                    ?>
        <tr align="center">
          <td><?php 
                    echo $count++;
                    ?>
</td>
          <td><?php 
                    echo $row['ref'];
                    ?>
</td>
          <td><?php 
                    echo $row['reg'];
                    ?>
</td>
          <td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kod'];
                    ?>
')"><?php 
                    echo $row['product'];
                    ?>
</a></b></td>
          <td><?php 
                    echo displayDate($row['lab_sent_date']);
                    ?>
</td>
          <td><?php 
                    echo aging($row['lab_sent_date']);
                    ?>
</td>
        </tr>
        <?php 
                }
                ?>
      </tbody>
    </table>
  </div>
  <div class="row">
    <div class="section-divider"></div>
  </div>
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-alert"><b>Cosmetic</b></div>
    <table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <td width="5%">No</td>
          <td width="15%">
            <?php 
                if ($code == 3) {
                    echo "Complaint No";
                } else {
                    echo "Surveillance No";
                }
                ?>
          </td>
          <td width="15%">Registration No</td>
          <td width="35%">Product Name</td>
          <td width="15%">Send Date</td>
          <td width="15%">Aging</td>
        </tr>
      </thead>
      <tbody>
        <?php 
                $count = 1;
                $result = selQuery(getSample($code, $id, 2));
                while ($row = mysqli_fetch_assoc($result)) {
                    ?>
        <tr align="center">
          <td><?php 
                    echo $count++;
                    ?>
</td>
          <td><?php 
                    echo $row['ref'];
                    ?>
</td>
          <td><?php 
                    echo $row['reg'];
                    ?>
</td>
          <td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kod'];
                    ?>
')"><?php 
                    echo $row['product'];
                    ?>
</a></b></td>
          <td><?php 
                    echo displayDate($row['lab_sent_date']);
                    ?>
</td>
          <td><?php 
                    echo aging($row['lab_sent_date']);
                    ?>
</td>
        </tr>
        <?php 
                }
                ?>
      </tbody>
    </table>
  </div>
  <?php 
            } else {
                ?>
  <div class="row">
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <?php 
                if ($code == 1) {
                    ?>
            <td width="5%">No</td>
            <td width="10%">Call No</td>
            <td width="15%">Reference No</td>
            <td width="40%">Product Name</td>
            <td width="10%">Send Date</td>
            <td width="5%">Aging</td>
            <td width="15%">Status</td>
          <?php 
                } elseif ($code == 2) {
                    ?>
            <td width="5%">No</td>
            <td width="15%">ADR No</td>
            <td width="15%">Registration No</td>
            <td width="35%">Product Name</td>
            <td width="15%">Send Date</td>
            <td width="15%">Aging</td>
          <?php 
                } else {
                    ?>
            <td width="5%">No</td>
            <td width="65%">Product Name</td>
            <td width="15%">Send Date</td>
            <td width="15%">Aging</td>
          <?php 
                }
                ?>
        </tr>
      </thead>
      <tbody>
        <?php 
                $count = 1;
                //echo getSample($code,$id);
                $result = selQuery(getSample($code, $id, "A"));
                while ($row = mysqli_fetch_assoc($result)) {
                    ?>
        <tr align="center">
          <?php 
                    if ($code == 1) {
                        ?>
            <td><?php 
                        echo $count++;
                        ?>
</td>
            <td><?php 
                        echo $row['pp_kod'];
                        ?>
</td>
            <td><?php 
                        echo $row['pp_ref_no'];
                        ?>
</td>
            <td align="left"><div><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                        echo $code;
                        ?>
','<?php 
                        echo $row['pp_kod'];
                        ?>
')"><?php 
                        echo $row['pp_nama'];
                        ?>
</a></b></div><div class="text-muted"><?php 
                        echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                        ?>
</div></td>
            <td>-</td>
            <td>-</td>
            <td align="left"><?php 
                        echo screeningStatus($row['pp_kod']);
                        ?>
</td>
          <?php 
                    } elseif ($code == 2) {
                        ?>
            <td><?php 
                        echo $count++;
                        ?>
</td>
            <td>
              <?php 
                        if (!$row['Adrno']) {
                            echo $row['adrFormID'];
                        } else {
                            echo $row['Adrno'];
                        }
                        ?>
            </td>
            <td><?php 
                        echo $row['MALnum'];
                        ?>
</td>
            <td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                        echo $code;
                        ?>
','<?php 
                        echo $row['adrSampleID'];
                        ?>
')"><?php 
                        echo $row['product_name'];
                        ?>
</a></b></td>
            <td><?php 
                        echo displayDate($row['lab_sent_date']);
                        ?>
</td>
            <td><?php 
                        echo aging($row['lab_sent_date']);
                        ?>
</td>
          <?php 
                    } elseif ($code == 5) {
                        ?>
            <td><?php 
                        echo $count++;
                        ?>
</td>
            <td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                        echo $code;
                        ?>
','<?php 
                        echo $row['kp_id'];
                        ?>
')"><?php 
                        echo $row['kp_product_name'];
                        ?>
</a></b></td>
            <td>-</td>
            <td>-</td>
          <?php 
                    } elseif ($code == 6) {
                        ?>
            <td><?php 
                        echo $count++;
                        ?>
</td>
            <td align="left"><b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                        echo $code;
                        ?>
','<?php 
                        echo $row['kp_id'];
                        ?>
')"><?php 
                        echo $row['kp_product_name'];
                        ?>
</a></b></td>
            <td><?php 
                        echo displayDate($row['kp_tkh_terima']);
                        ?>
</td>
            <td><?php 
                        echo aging($row['kp_tkh_terima']);
                        ?>
</td>
          <?php 
                    }
                    ?>
        </tr>
        <?php 
                }
                ?>
      </tbody>
    </table>
  </div>
  <?php 
            }
            ?>
  <?php 
            if ($code == 1) {
                ?>
    <div class="col-md-12">&nbsp;</div>
    <div class="row" align="right">
      <div class="btn-group">
        <button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
          Action
          <span class="caret ml5"></span>
        </button>
        <ul class="dropdown-menu" role="menu">
          <li><a style="cursor:pointer" onclick="screenList(1)">In Tray</a></li>
          <li><a style="cursor:pointer" onclick="screenList(2)">Rejected List</a></li>
        </ul>
      </div>
    </div>
  <?php 
            }
            ?>
  <?php 
            if ($code == 6) {
                ?>
  <div class="col-md-12">&nbsp;</div>
  <div class="row" align="right"><button class="btn btn-alert" onclick="newSample()"><i class="fa fa-plus"></i> New</button></div>
  <?php 
            }
            ?>
</div>
<?php 
        } elseif ($id == 19 or $id == 21 or $id == 23 or $id == 25 or $id == 27) {
            ?>
<div class="tab-content pn br-n admin-form">
  <div class="row">
    <input type="hidden" id="mainTitle" value="<?php 
            echo sampleTitle($code);
            ?>
">
    <div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <?php 
            if ($id == 19) {
                ?>
            <td width="5%">&nbsp;</td>
            <td width="5%">No</td>
            <td width="10%">Sample No</td>
            <td width="20%">Product Name</td>
            <td width="10%">Approved Date</td>
            <td width="10%">Expected Date</td>
            <td width="5%">Aging</td>
            <td width="15%">Status</td>
          <?php 
            } else {
                ?>
          <td width="5%">No</td>
          <td width="10%">Sample No</td>
          <td width="25%">Product Name</td>
          <td width="10%">Received Date</td>
          <td width="10%">Expected Date</td>
          <td width="5%">Aging</td>
          <td width="15%">Status</td>
          <?php 
            }
            ?>
        </tr>
      </thead>
      <tbody>
        <?php 
            $count = 1;
            //echo getSample($code,$id,'P');
            $result = selQuery(getSample($code, $id, 'P'));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
        <tr align="center">
          <?php 
                if ($id == 19) {
                    ?>
            <td>
              <input type="checkbox" value="<?php 
                    echo $row['kp_id'];
                    ?>
">
            </td>
            <td><?php 
                    echo $count++;
                    ?>
</td>
            <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
            <td align="left">
              <b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</a></b>
              <div><?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
</div>
            </td>
            <td><?php 
                    echo displayDate($row['kp_tkh_approve']);
                    ?>
</td>
            <td><?php 
                    echo addDayswithdate($row['kp_tkh_approve'], $row['kp_complete_day']);
                    ?>
</td>
            <td><?php 
                    echo aging($row['kp_tkh_terima']);
                    ?>
</td>
            <td align="left"><?php 
                    echo getStatus($row['kp_rs_level']);
                    ?>
</td>
          <?php 
                } else {
                    ?>
            <td><?php 
                    echo $count++;
                    ?>
</td>
            <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
            <td align="left">
              <b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</b></a>
            </td>
            <td><?php 
                    echo displayDate($row['kp_tkh_terima']);
                    ?>
</td>
            <td><?php 
                    echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
                    ?>
</td>
            <td><?php 
                    echo aging($row['kp_tkh_terima']);
                    ?>
</td>
            <td align="left"><?php 
                    echo getStatus($row['kp_rs_level']);
                    ?>
</td>
          <?php 
                }
                ?>
        </tr>
        <?php 
            }
            ?>
      </tbody>
    </table>
  </div>
  <?php 
            if ($id == 19) {
                ?>
  <div class="row" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Move to
        <span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li>
          <a onclick="changePriority('primary','sample','<?php 
                echo $code;
                ?>
')">Normal List</a>
        </li>
      </ul>
    </div>
  </div>
  <?php 
            }
            ?>
  <div class="row">
    <div class="section-divider"></div>
  </div>
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-alert"><b>Normal List</b></div>
    <table class="table table-striped table-bordered table-hover" id="second" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <?php 
            if ($id == 19) {
                ?>
            <td width="5%">&nbsp;</td>
            <td width="5%">No</td>
            <td width="10%">Sample No</td>
            <td width="20%">Product Name</td>
            <td width="10%">Received Date</td>
            <td width="10%">Expected Date</td>
            <td width="5%">Aging</td>
            <td width="15%">Status</td>
          <?php 
            } else {
                ?>
          <td width="5%">No</td>
          <td width="10%">Sample No</td>
          <td width="25%">Product Name</td>
          <td width="10%">Received Date</td>
          <td width="10%">Expected Date</td>
          <td width="5%">Aging</td>
          <td width="15%">Status</td>
          <?php 
            }
            ?>
        </tr>
      </thead>
      <tbody>
        <?php 
            $count = 1;
            $result = selQuery(getSample($code, $id, 'N'));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
        <tr align="center">
          <?php 
                if ($id == 19) {
                    ?>
            <td>
              <input type="checkbox" value="<?php 
                    echo $row['kp_id'];
                    ?>
">
            </td>
            <td><?php 
                    echo $count++;
                    ?>
</td>
            <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
            <td align="left">
              <b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</a></b>
              <div><?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
</div>
            </td>
            <td><?php 
                    echo displayDate($row['kp_tkh_terima']);
                    ?>
</td>
            <td><?php 
                    echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
                    ?>
</td>
            <td><?php 
                    echo aging($row['kp_tkh_terima']);
                    ?>
</td>
            <td><?php 
                    echo getStatus($row['kp_rs_level']);
                    ?>
</td>
          <?php 
                } else {
                    ?>
            <td><?php 
                    echo $count++;
                    ?>
</td>
            <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
            <td align="left">
              <b><a style="cursor:pointer;" onclick="sampleDetail('<?php 
                    echo $code;
                    ?>
','<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</a></b>
            </td>
            <td><?php 
                    echo displayDate($row['kp_tkh_terima']);
                    ?>
</td>
            <td><?php 
                    echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
                    ?>
</td>
            <td><?php 
                    echo aging($row['kp_tkh_terima']);
                    ?>
</td>
            <td><?php 
                    echo getStatus($row['kp_rs_level']);
                    ?>
</td>
          <?php 
                }
                ?>
        </tr>
        <?php 
            }
            ?>
      </tbody>
    </table>
  </div>
  <?php 
            if ($id == 19) {
                ?>
  <div class="row" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Move to
        <span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li>
          <a onclick="changePriority('second','sample','<?php 
                echo $code;
                ?>
')">Priority List</a>
        </li>
      </ul>
    </div>
  </div>
  <?php 
            }
            ?>
</div>
<?php 
        } elseif ($id == 17 or $id == 20 or $id == 22 or $id == 24 or $id == 26 or $id == 28) {
            ?>
<div class="tab-content pn br-n admin-form">
  <div class="row">
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <td width="5%">No</td>
          <td width="10%">Sample No</td>
          <td width="25%">Product Name</td>
          <td width="15%">Received Date</td>
          <td width="15%">Expected Date</td>
          <td width="10%">Aging</td>
          <td width="20%">Status</td>
        </tr>
      </thead>
      <tbody>
        <?php 
            $count = 1;
            $query = "SELECT kp_id,kp_sampel_no,kp_product_name,kp_tkh_terima,kp_complete_day,kp_rs_level FROM k_produk";
            if ($id == 17) {
                $query .= " WHERE kp_rs_level IN (401,402)";
            } elseif ($id == 20) {
                $query .= " WHERE kp_rs_level='402'";
            } elseif ($id == 22) {
                $query .= " WHERE kp_rs_level='411'";
            } elseif ($id == 24) {
                $query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n            WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "'";
            } elseif ($id == 26) {
                $query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n            WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "' AND klb_tp_kod='" . $_SESSION['us_id'] . "' AND klb_rs_level='404'";
            } elseif ($id == 28) {
                $query .= " JOIN k_lab ON k_lab.klb_kp_id=k_produk.kp_id\n            JOIN k_lab_task_test ON k_lab_task_test.kltt_kp_id=k_produk.kp_id\n            WHERE kp_rs_level='402' AND klb_ru_kod='" . $_SESSION['ru_kod'] . "' AND kltt_tp_kod='" . $_SESSION['us_id'] . "' AND klb_rs_level='405'\n            GROUP BY kp_id";
            }
            $result = selQuery($query);
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
        <tr align="center">
          <td><?php 
                echo $count++;
                ?>
</td>
          <td><?php 
                echo $row['kp_sampel_no'];
                ?>
</td>
          <td align="left"><a style="cursor:pointer;" onclick="viewSample('<?php 
                echo $row['kp_id'];
                ?>
')"><?php 
                echo $row['kp_product_name'];
                ?>
</a></td>
          <td><?php 
                echo displayDate($row['kp_tkh_terima']);
                ?>
</td>
          <td><?php 
                echo addDayswithdate($row['kp_tkh_terima'], $row['kp_complete_day']);
                ?>
</td>
          <td><?php 
                echo aging($row['kp_tkh_terima']);
                ?>
</td>
          <td align="left"><?php 
                echo getStatus($row['kp_rs_level']);
                ?>
</td>
        </tr>
        <?php 
            }
            ?>
      </tbody>
    </table>
  </div>
</div>
<?php 
        } elseif ($id == 18 or $id == 34) {
            ?>
<div class="tab-content pn br-n admin-form">
  <input type="hidden" id="mainTitle" value="<?php 
            echo sampleTitle($code);
            ?>
">
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-danger"><b>Priority List</b></div>
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <td width="5%">&nbsp;</td>
          <td width="10%">Sample No</td>
          <td width="45%">Product Name</td>
          <td width="15%">Received Date</td>
          <td width="10%">Aging</td>
          <td width="15%">Approve Date</td>
        </tr>
      </thead>
      <tbody>
        <?php 
            $count = 1;
            $result = selQuery(getSample($code, $id, "P"));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
        <tr align="center">
          <td>
            <input type="checkbox" value="<?php 
                echo $row['kp_sampel_no'];
                ?>
">
          </td>
          <td><?php 
                echo $row['kp_sampel_no'];
                ?>
</td>
          <td align="left">
            <div><b><a style="cursor:pointer;" onclick="sampleResult('<?php 
                echo $row['kp_id'];
                ?>
','<?php 
                echo $row['kp_sampel_no'];
                ?>
')"><?php 
                echo $row['kp_product_name'];
                ?>
</a></b></div><div class="text-muted"><?php 
                echo sampleCategory($row['kp_rsc_kod']);
                ?>
</div>
          </td>
          <td><?php 
                echo $row['kp_tkh_terima'];
                ?>
</td>
          <td><?php 
                echo aging($row['kp_tkh_terima']);
                ?>
</td>
          <td><?php 
                echo $row[''];
                ?>
</td>
        </tr>
        <?php 
            }
            ?>
      </tbody>
    </table>
  </div>
  <div class="row">
    <div class="section-divider"></div>
  </div>
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-alert"><b>Normal List</b></div>
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="alert" align="center">
          <td width="5%">&nbsp;</td>
          <td width="10%">Sample No</td>
          <td width="45%">Product Name</td>
          <td width="15%">Received Date</td>
          <td width="10%">Aging</td>
          <td width="15%">Approve Date</td>
        </tr>
      </thead>
      <tbody>
        <?php 
            $count = 1;
            $result = selQuery(getSample($code, $id, "N"));
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
        <tr align="center">
          <td>
            <input type="checkbox" value="<?php 
                echo $row['kp_sampel_no'];
                ?>
">
          </td>
          <td><?php 
                echo $row['kp_sampel_no'];
                ?>
</td>
          <td align="left">
            <div><b><a style="cursor:pointer;" onclick="sampleResult('<?php 
                echo $row['kp_id'];
                ?>
','<?php 
                echo $row['kp_sampel_no'];
                ?>
')"><?php 
                echo $row['kp_product_name'];
                ?>
</a></b></div><div class="text-muted"><?php 
                echo sampleCategory($row['kp_rsc_kod']);
                ?>
</div>
          </td>
          <td><?php 
                echo $row['kp_tkh_terima'];
                ?>
</td>
          <td><?php 
                echo aging($row['kp_tkh_terima']);
                ?>
</td>
          <td><?php 
                echo $row[''];
                ?>
</td>
        </tr>
        <?php 
            }
            ?>
      </tbody>
    </table>
  </div>
  <!-- <div class="col-md-12">&nbsp;</div>
  <div class="col-md-12" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-alert dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Action
        <span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li><a style="cursor:pointer" onclick="selectPrint()">Print Selected</a></li>
      </ul>
    </div>
  </div> -->
</div>
<?php 
        } elseif ($id == 29) {
            ?>
<div class="tab-content pn br-n admin-form">
<?php 
            if ($code == 1) {
                ?>
<input type="hidden" id="mainTitle" value="General Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-4">
  <select class="form-control" id="searchBy" onchange="changeSearch(1)">
    <option value="0">-- Please Select --</option>
    <option value="1">Product Name</option>
    <option value="11">Protocol Number</option>
    <option value="2">Reference Number</option>
    <option value="3">Registration Number</option>
    <option value="4">Product Category</option>
    <option value="5">Holder</option>
    <option value="6">Manufacturer</option>
    <option value="7">Active Substance</option>
    <option value="8">Received Date</option>
    <option value="9">Approval Date</option>
    <option value="10">Reject Date</option>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">Search</div>
<div class="col-md-1">:</div>
<div class="col-md-4" id="changeSearch">
  <label for="searchTxt" class="field prepend-icon">
    <input type="text" id="searchTxt" class="gui-input" placeholder="Search">
      <label class="field-icon">
        <i class="fa fa-search"></i>
      </label>
  </label>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-12" align="right">
  <button class="btn btn-primary btn-sm" onclick="carian(1)"><i class="fa fa-search"></i> Search</button>
</div>
<?php 
            } else {
                ?>
<input type="hidden" id="mainTitle" value="Status Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-9" id="ProtocolStatus">
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_01" name="ProtocolStatus" checked="true" onclick="changeSearching(3)">
    <label for="ProtocolStatus_01">Protocol Under Evaluation</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_02" name="ProtocolStatus" onclick="changeSearching(3)">
    <label for="ProtocolStatus_02">Waiting for Approval</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_03" name="ProtocolStatus" onclick="changeSearching(3)">
    <label for="ProtocolStatus_03">Approval Protocol</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_04" name="ProtocolStatus" onclick="changeSearching(3)">
    <label for="ProtocolStatus_04">Rejected Protocol</label>
  </div>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">
  <label>Lab</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-7">
  <select id="txt_lab" class="form-control" onchange="changeSearching(3)">
      <option value='0'>-- Please Select --</option>
      <option value='All'>All Unit</option>
      <?php 
                getLab();
                ?>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">
  <label>Year</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-2">
  <select id="txt_year" class="form-control" onchange="changeSearching(3)">
      <option value='0'>-- Please Select --</option>
      <option value='All'>All Years</option>
      <?php 
                $year = "2000";
                $curYear = date("Y");
                while ($curYear >= $year) {
                    echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
                    $curYear--;
                }
                ?>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-12" align="right">
  <button class="btn btn-primary btn-sm" onclick="carian(3)"><i class="fa fa-search"></i> Search</button>
</div>
<?php 
            }
            ?>
  <div class="col-md-12" id="viewSearch"></div>
</div>
<?php 
        } elseif ($id == 30) {
            ?>
<div class="tab-content pn br-n admin-form">
<?php 
            if ($code == 1) {
                ?>
  <input type="hidden" id="mainTitle" value="General Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-4">
  <select class="form-control" id="searchBy" onchange="changeSearch(2)">
    <option value="0">-- Please Select --</option>
    <option value="1">Product Name</option>
    <option value="2">Sample Number</option>
    <option value="3">Batch Number</option>
    <option value="4">Reference Number</option>
    <option value="5">Registration Number</option>
    <option value="6">Product Category</option>
    <option value="7">Holder</option>
    <option value="8">Manufacturer</option>
    <option value="9">Active Substance</option>
    <option value="10">Received Date</option>
    <option value="11">Approval Date</option>
    <option value="12">Reject Date</option>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">Search</div>
<div class="col-md-1">:</div>
<div class="col-md-4" id="changeSearch">
  <label for="searchTxt" class="field prepend-icon">
    <input type="text" id="searchTxt" class="gui-input" placeholder="Search">
      <label class="field-icon">
        <i class="fa fa-search"></i>
      </label>
  </label>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-12" align="right">
  <button class="btn btn-alert btn-sm" onclick="carian(2)"><i class="fa fa-search"></i> Search</button>
</div>
<?php 
            } else {
                ?>
<input type="hidden" id="mainTitle" value="Status Search" />
<div class="col-md-2">Search By</div>
<div class="col-md-1">:</div>
<div class="col-md-9" id="ProtocolStatus">
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_01" name="ProtocolStatus" checked="true" onclick="changeSearching(4)">
    <label for="ProtocolStatus_01">Sample Under Testing</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_02" name="ProtocolStatus" onclick="changeSearching(4)">
    <label for="ProtocolStatus_02">Waiting for Result Approval</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_03" name="ProtocolStatus" onclick="changeSearching(4)">
    <label for="ProtocolStatus_03">Pass Samples</label>
  </div>
  <div class="radio-custom mb5">
    <input type="radio" id="ProtocolStatus_04" name="ProtocolStatus" onclick="changeSearching(4)">
    <label for="ProtocolStatus_04">Fail Samples</label>
  </div>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">
  <label>Lab</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-7">
  <select id="txt_lab" class="form-control" onchange="changeSearching(4)">
      <option value='0'>-- Please Select --</option>
      <option value='All'>All Unit</option>
      <?php 
                getLab();
                ?>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-2">
  <label>Year</label>
</div>
<div class="col-md-1">:</div>
<div class="col-md-2">
  <select id="txt_year" class="form-control" onchange="changeSearching(4)">
      <option value='0'>-- Please Select --</option>
      <option value='All'>All Years</option>
      <?php 
                $year = "2000";
                $curYear = date("Y");
                while ($curYear >= $year) {
                    echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
                    $curYear--;
                }
                ?>
  </select>
</div>
<div class="col-md-12">&nbsp;</div>
<div class="col-md-12" align="right">
  <button class="btn btn-alert btn-sm" onclick="carian(4)"><i class="fa fa-search"></i> Search</button>
</div>
<?php 
            }
            ?>
  <div class="col-md-12" id="viewSearch"></div>
</div>
<?php 
        } elseif ($id == 31) {
            $query = "SELECT pp_kod,pp_ref_no,pp_nama,pp_tkh_approve,pp_rs_kod,rkatp_class,rkatp_desc,pp_correspondence_counter,pp_correspondence_counter_max FROM p_product\n              LEFT JOIN ref_kat_produk ON pp_rkatp_kod = rkatp_kod\n              LEFT JOIN p_product_manu ON p_product_manu.ppm_pp_kod = p_product.pp_kod AND ppm_rmr_kod=1\n              LEFT JOIN o_syarikat_add ON o_syarikat_add.osa_kod = p_product_manu.ppm_osa_kod\n              LEFT JOIN o_syarikat ON o_syarikat.os_kod = o_syarikat_add.osa_os_kod\n              LEFT JOIN lab_assign ON la_pp_kod=pp_kod\n              WHERE pp_status_nopayment=2 AND pp_rs_kod IN (1110,1103,1107)\n              AND la_ru_kod='" . $_SESSION['ru_kod'] . "' AND la_rs_kod IN (1110) AND la_us_id='" . $_SESSION['us_id'] . "' GROUP BY pp_kod";
            $result = selQuery($query);
            ?>
<table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
  <thead>
    <tr class="primary" align="center">
      <td width="15%">Reference No</td>
      <td width="45%">Product Name</td>
      <td width="30%">Status</td>
      <td width="10%">&nbsp;</td>
    </tr>
  </thead>
  <tbody>
    <?php 
            while ($row = mysqli_fetch_assoc($result)) {
                ?>
    <tr align="center">
      <td><?php 
                echo $row['pp_ref_no'];
                ?>
</td>
      <td align="left">
        <div class="text-primary">
          <b><?php 
                if ($row['pp_rs_kod'] == 1110) {
                    echo $row['pp_nama'];
                } else {
                    ?>
              <a style="cursor:pointer;" onclick="corrDetail('<?php 
                    echo $row['pp_kod'];
                    ?>
')"><?php 
                    echo $row['pp_nama'];
                    ?>
</a>
              <?php 
                }
                ?>
          </b>
        </div>
        <div class="text-muted"><?php 
                echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                ?>
</div>
      </td>
      <td>
        <?php 
                if ($row['pp_rs_kod'] == 1110) {
                    echo "WAITING FOR USER REPLY";
                } elseif ($row['pp_rs_kod'] == 1107) {
                    echo "USER CORRESPOND";
                } else {
                    echo "WAITING FOR OTHER DEPARTMENT";
                }
                ?>
      </td>
      <td>
        <?php 
                echo $row['pp_correspondence_counter'] . " of " . $row['pp_correspondence_counter_max'];
                ?>
      </td>
    </tr>
    <?php 
            }
            ?>
  </tbody>
</table>
<?php 
        } elseif ($id == 32) {
            // $query = "SELECT kpd_kp_id,kpd_pp_kod,kpd_sender_name FROM k_produk_det limit 15000";
            // $result = selQuery($query);
            // $count = 0;
            // while($row = mysqli_fetch_assoc($result)) {
            //   $upd = "UPDATE k_produk SET kp_sampleID='".$row['kpd_pp_kod']."',kp_sender='".$row['kpd_sender_name']."' WHERE kp_id='".$row['kpd_kp_id']."'";
            //   executeQuery($upd);
            //   $count++;
            // }
            // echo $count;
            if ($code == 1) {
                //       $query = "SELECT kp_id,kp_rpjp_id FROM k_produk WHERE kp_rpjp_id IS NOT NULL order by kp_id asc LIMIT 10000";
                //       $result = selQuery($query);
                //       while($row = mysqli_fetch_assoc($result)) {
                //         $upd = "UPDATE k_produk SET kp_rsc_kod='".$row['kp_rpjp_id']."' WHERE kp_id='".$row['kp_id']."'";
                // //echo $upd;
                //         executeQuery($upd);
                //
                //       }
                //       echo $query;
                // $query = "SELECT kpd_kp_id,kpd_pp_kod,kpd_sender_name FROM k_produk_det order by kpd_id ASC LIMIT 1500";
                // $result = selQuery($query);
                // while($row = mysqli_fetch_assoc($result)) {
                //   $upd = "UPDATE k_produk SET kp_sampleID='".$row['kpd_pp_kod']."',kp_sender='".$row['kpd_sender_name']."'
                //           WHERE kp_id='".$row['kpd_kp_id']."'";
                //   executeQuery($upd);
                //
                // }
                //echo $upd;
                ?>
<div class="tab-content pn br-n admin-form">
  <input type="hidden" id="mainTitle" value="Home" />
  <div class="row">
    <label class="field prepend-icon">
      <input type="text" id="txt_scan" class="gui-input" placeholder="Scan Barcode" onchange="scanItem()">
      <label for="txt_scan" class="field-icon">
        <i class="fa fa-barcode"></i>
      </label>
    </label>
  </div>
  <div class="row" id="storeList">
    <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
      <thead>
        <tr class="system" align="center">
          <td width="2%">&nbsp;</td>
          <td width="10%">Sample No</td>
          <td width="45%">Product Name</td>
          <td width="8%">Batch No</td>
          <td width="10%">Quantity</td>
          <td width="10%">Unit</td>
          <td width="15%">Status</td>
        </tr>
      </thead>
      <tbody>
        <?php 
                $query = "SELECT kp_id,kp_sampel_no,kp_batch_no,kp_product_name,kp_kuantiti_htr,\n                    kp_rskt_kod,kp_rkatp_kod,kp_requestSpl FROM k_lab\n                    LEFT JOIN k_produk ON kp_id=klb_kp_id\n                    WHERE klb_rlog_id IS NULL\n                    GROUP BY klb_ru_kod,klb_kp_id";
                $result = selQuery($query);
                while ($row = mysqli_fetch_assoc($result)) {
                    ?>
        <tr align="center">
          <td><input type="checkbox" value="<?php 
                    echo $row["kp_id"];
                    ?>
"></td>
          <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
          <td align="left">
            <div class="text-primary">
              <b><a style="cursor:pointer;" onclick="viewSample('<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</a></b>
            </div>
            <div class="text-muted">
              <?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
            </div>
          </td>
          <td align="left"><?php 
                    echo $row['kp_batch_no'];
                    ?>
</td>
          <td align="left"><?php 
                    echo $row['kp_kuantiti_htr'];
                    ?>
</td>
          <td align="left"><?php 
                    echo getSukatan($row['kp_rskt_kod'], 1);
                    ?>
</td>
          <td align="left">
            <?php 
                    if ($row['kp_requestSpl'] == 0) {
                        echo "New Sample";
                    } else {
                        echo "Ready to Collect";
                    }
                    ?>
          </td>
        </tr>
        <?php 
                }
                ?>
      </tbody>
    </table>
  </div>
  <div class="row" align="right">
    <div class="btn-group">
      <button type="button" class="btn btn-system dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
        Action<span class="caret ml5"></span>
      </button>
      <ul class="dropdown-menu" role="menu">
        <li><a onclick="readyCollect()">Ready to Collect</a></li>
      </ul>
    </div>
  </div>
  <div class="row" id="scanList"><?php 
                scanList();
                ?>
</div>
</div>
<?php 
            } else {
                ?>
<input type="hidden" id="mainTitle" value="Collection History" />
<div class="row">
  <table class="table table-striped table-bordered table-hover" id="primary" cellspacing="0" width="100%">
    <thead>
      <tr class="system" align="center">
        <td width="10%">Sample No</td>
        <td width="40%">Product Name</td>
        <td width="30%">Lab</td>
        <td width="10%">Date Collect</td>
        <td width="10%">Collect By</td>
      </tr>
    </thead>
    <tbody>
      <?php 
                $query = "SELECT kp_id,kp_sampel_no,kp_product_name,kp_batch_no,kp_kuantiti_htr,\n                  kp_rskt_kod,kst_ru_kod,kst_tkh_ambil,kst_collect_by,rkatp_class,rkatp_desc FROM k_stor\n                  LEFT JOIN k_produk ON k_produk.kp_id=k_stor.kst_kp_id\n                  LEFT JOIN ref_kat_produk ON rkatp_kod=kp_rkatp_kod\n                  ORDER BY kst_tkh_ambil";
                $result = selQuery($query);
                while ($row = mysqli_fetch_assoc($result)) {
                    ?>
      <tr align="center">
        <td><?php 
                    echo $row['kp_sampel_no'];
                    ?>
</td>
        <td align="left">
          <div class="text-primary">
          <b><a style="cursor:pointer;" onclick="viewSample('<?php 
                    echo $row['kp_id'];
                    ?>
')"><?php 
                    echo $row['kp_product_name'];
                    ?>
</a></b>
          </div>
          <div class="text-muted">
            <?php 
                    echo $row['rkatp_desc'] . " - " . $row['rkatp_class'];
                    ?>
          </div>
        </td>
        <td align="left"><?php 
                    echo retriveLab($row['kst_ru_kod']);
                    ?>
</td>
        <td><?php 
                    echo displayDate($row['kst_tkh_ambil']);
                    ?>
</td>
        <td align="left"><?php 
                    echo $row['kst_collect_by'];
                    ?>
</td>
      </tr>
      <?php 
                }
                ?>
    </tbody>
  </table>
</div>
<?php 
            }
        } elseif ($id == 33) {
            ?>
<div class="tab-content pn br-n admin-form">
  <?php 
            if ($code == 1) {
                $title = "Protocol";
            } else {
                $title = "Sample";
            }
            ?>
  <input type="hidden" id="mainTitle" value="<?php 
            echo $title;
            ?>
" />
  <div class="col-md-12">&nbsp;</div>
  <div class="col-md-6">
    <label for="reportName" class="field-label">Report Name</label>
    <select id="reportName" class="form-control" onchange="viewReport()">
        <option value="0" >-- Please Select --</option>
        <?php 
            if ($code == 1) {
                $query = "SELECT report_id,report_name FROM ref_lab_report\n                    WHERE report_type=1 AND report_active=1";
            } else {
                $query = "SELECT report_id,report_name FROM ref_lab_report\n                    WHERE report_type=2 AND report_active=1";
            }
            $result = selQuery($query);
            while ($row = mysqli_fetch_assoc($result)) {
                echo "<option value='" . $row['report_id'] . "'>" . $row['report_id'] . $row['report_name'] . "</option>";
            }
            ?>
    </select>
  </div>
  <div class="col-md-2">
    <label for="reportYear" class="field-label">Year</label>
    <select id="reportYear" class="form-control" onchange="viewReport()">
        <?php 
            $year = "2000";
            $curYear = date("Y");
            while ($curYear >= $year) {
                echo "<option value='" . $curYear . "'>" . $curYear . "</option>";
                $curYear--;
            }
            ?>
    </select>
  </div>
  <div class="col-md-12">&nbsp;</div>
  <div class="col-md-12" id="showReport"></div>
</div>
<?php 
        }
    }
}
コード例 #2
0
ファイル: pkk-bkp.php プロジェクト: syafiqazwan/pharmaco
function chronology($type, $product_id)
{
    if ($type == 0) {
        $query = "SELECT pp_ref_no,pp_nama_brand,pp_nama_generic,pp_nama,\n              DATE_FORMAT(pp_pkk_screen_tkh,'%d/%m/%Y %h:%i:%s %p') AS pp_pkk_screen_tkh FROM p_product\n              WHERE pp_kod='{$product_id}'";
        $result = selQuery($query);
        $row = mysqli_fetch_assoc($result);
        $query = "SELECT la_ru_kod,DATE_FORMAT(lab_assign_date,'%d/%m/%Y %h:%i:%s %p') AS lab_assign_date FROM lab_assign WHERE la_pp_kod='{$product_id}'";
        $result = selQuery($query);
        $assign = mysqli_fetch_assoc($result);
        ?>
<div class="admin-form" id="previewChrono">
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-primary"><b>Product Information</b></div>
    <div class="col-md-6">
    <b>Reference No : </b>
    <p><?php 
        echo isEmpty($row['pp_ref_no']);
        ?>
</p>
    </div>
    <div class="col-md-6">
    <b>Brand Name : </b>
    <p><?php 
        echo isEmpty($row["pp_nama_brand"]);
        ?>
</p>
    </div>
    <div class="col-md-6">
    <b>Generic Name : </b>
    <p><?php 
        echo isEmpty($row["pp_nama_generic"]);
        ?>
</p>
    </div>
    <div class="col-md-6">
    <b>Full product name : </b>
    <p><?php 
        echo isEmpty($row["pp_nama"]);
        ?>
</p>
    </div>
  </div>
  <div class="row">
    <div class="section-divider mb40"></div>
  </div>
  <div class="row">
    <ol class="timeline-list">
      <li class="timeline-item">
        <div class="timeline-icon bg-warning">
          <span class="fa fa-calendar"></span>
        </div>
        <div class="timeline-desc">
          <p>Screening Date</p>
        </div>
        <div class="timeline-date"><?php 
        echo $row['pp_pkk_screen_tkh'];
        ?>
</div>
      </li>
      <li class="timeline-item">
        <div class="timeline-icon bg-warning">
          <span class="fa fa-calendar"></span>
        </div>
        <div class="timeline-desc">
          <p>Product Distribution</p>
          <?php 
        $labs = "";
        while ($lab = mysqli_fetch_assoc($result)) {
            $labs = $labs . "<small>" . retriveLab($lab['la_ru_kod']) . "</small><br />";
        }
        echo $labs;
        ?>
        </div>
        <div class="timeline-date"><?php 
        echo $assign['lab_assign_date'];
        ?>
</div>
      </li>
      <!-- <li class="timeline-item">
        <div class="timeline-icon bg-warning">
          <span class="fa fa-calendar"></span>
        </div>
        <div class="timeline-desc">
          <p>Assign Evaluator</p>
        </div>
        <div class="timeline-date"><?php 
        //echo $row['pp_pkk_screen_tkh'];
        ?>
</div>
      </li> -->
      <?php 
        $query = "SELECT plc_user,plc_comment,plc_location,DATE_FORMAT(plc_tkh_upd,'%d/%m/%Y %h:%i:%s %p') AS plc_tkh_upd FROM p_lab_comment\n                  WHERE plc_product_id='{$product_id}' ORDER BY plc_location ASC";
        $result = selQuery($query);
        while ($rows = mysqli_fetch_assoc($result)) {
            ?>
      <li class="timeline-item">
        <div class="timeline-icon bg-primary light">
          <span class="fa fa-comments-o"></span>
        </div>
        <div class="timeline-desc">
          <p><?php 
            echo $rows['plc_comment'];
            ?>
</p>
          <small><?php 
            echo getUsername($rows['plc_user']) . " / " . getRole($rows['plc_location']);
            ?>
</small>
        </div>
        <div class="timeline-date"><?php 
            echo $rows['plc_tkh_upd'];
            ?>
</div>
      </li>
      <?php 
        }
        ?>
    </ol>
  </div>
</div>
<?php 
    } else {
        $query = "SELECT kp_sampel_no,kp_product_name FROM k_produk\n              WHERE kp_id='{$product_id}'";
        $result = selQuery($query);
        $row = mysqli_fetch_assoc($result);
        ?>
<div class="admin-form" id="previewChrono">
  <div class="row">
    <div class="alert alert-sm alert-border-left alert-alert"><b>Sample Information</b></div>
    <div class="col-md-6">
    <b>Sample No : </b>
    <p><?php 
        echo isEmpty($row['kp_sampel_no']);
        ?>
</p>
    </div>
    <div class="col-md-6">
    <b>Product Name : </b>
    <p><?php 
        echo isEmpty($row['kp_product_name']);
        ?>
</p>
    </div>
  </div>
  <div class="row">
    <div class="section-divider mb40"></div>
  </div>
  <div class="row">
    <ol class="timeline-list">
      <?php 
        $query = "SELECT plc_user,plc_comment,plc_location,DATE_FORMAT(plc_tkh_upd,'%d/%m/%Y %h:%i:%s %p') AS plc_tkh_upd FROM p_lab_comment\n                  WHERE plc_product_id='{$product_id}' ORDER BY plc_location ASC";
        $result = selQuery($query);
        while ($rows = mysqli_fetch_assoc($result)) {
            ?>
      <li class="timeline-item">
        <div class="timeline-icon bg-primary light">
          <span class="fa fa-comments-o"></span>
        </div>
        <div class="timeline-desc">
          <p><?php 
            echo $rows['plc_comment'];
            ?>
</p>
          <small><?php 
            echo getUsername($rows['plc_user']) . " / " . getRole($rows['plc_location']);
            ?>
</small>
        </div>
        <div class="timeline-date"><?php 
            echo $rows['plc_tkh_upd'];
            ?>
</div>
      </li>
      <?php 
        }
        ?>
    </ol>
  </div>
</div>
<?php 
    }
}