function getGraph($X) { // Validate parameters if ($X < 1 || $X > 9) { http_response_code(400); echo "invalid values \n"; exit; } $sample = getSample(); // Results return $sample[$X - 1]; }
<?php session_start(); require_once 'connect.php'; require_once 'data.php'; # Available worksheets $sample = getSample(); # Determine the commands if (isset($_GET['cmd'])) { # Generate a new graph if ($_GET['cmd'] == 'generate') { if (isset($_GET['graph_id'])) { $graph = getGraph($_GET['graph_id']); $_SESSION['visittime'] = time(); echo json_encode($graph); } else { http_response_code(400); echo "invalid parameter"; exit; } # Find optimal solution from given graph } else { if ($_GET['cmd'] == 'solve') { if (isset($_GET['graph'])) { $graph = json_decode($_GET['graph'], true); $n = $graph['N']; $m = $graph['M']; $edges = $graph['E']; $result = findOptimalSolution($n, 0, 0, array(), $edges, 0); echo json_encode($result); } else {
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%"> </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%"> </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"> </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"> </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%"> </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%"> </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%"> </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%"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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"> </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%"> </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%"> </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"> </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"> </div> <div class="col-md-12" id="showReport"></div> </div> <?php } } }