function screening($pp_kod) { $query = "SELECT protocol_id FROM p_protocol\n WHERE pp_kod='{$pp_kod}' AND (protocol_category NOT IN('sumofMethod','otherDoc'))"; $result = selQuery($query); $str = array(); while ($row = mysqli_fetch_assoc($result)) { array_push($str, checkingTest($row['protocol_id'])); } $label = '<font color="red"><i class="fa fa-close" title="Not Complete"></i></font>'; $query = "SELECT protocol_id,screen_y ,screen_n FROM p_protocol\n WHERE pp_kod='{$pp_kod}' AND (protocol_category IN('sumofMethod','otherDoc'))\n AND (screen_y IS NOT NULL OR screen_n IS NOT NULL)"; while ($row = mysqli_fetch_assoc($result)) { array_push($str, checkingTest($row['protocol_id'])); } if (in_array($label, $str) == false and countRow($query) == 2) { return "true"; } else { return "false"; } }
function getValidList($id, $pp_kod) { $query = "SELECT protocol_id,protocol_category,protocol_desc,screen_y,screen_n FROM p_protocol\n WHERE pp_kod='{$pp_kod}' AND protocol_category!='sumofMethod' AND protocol_category!='otherDoc'"; ?> <div class="row"> <div class="alert alert-sm alert-border-left alert-primary"><b>Supporting Documents</b></div> <?php if (countRow($query) > 0) { ?> <table class="table table-striped table-bordered table-hover" cellspacing="0" width="100%" id="testList"> <thead> <?php if ($id == 2) { ?> <tr class="primary" align="center"> <td width="25%">Category</td> <td width="30%">Description</td> <td width="30%">Action</td> <td width="5%"><i class="fa fa-check" title="Acceptable"></i></td> <td width="5%"><i class="fa fa-close" title="Not Acceptable"></i></td> <td width="5%"> </td> </tr> <?php } elseif ($id == 5 || $id == 6) { ?> <tr class="primary" align="center"> <td width="5%"> </td> <td width="20%">Category</td> <td width="35%">Description</td> <td width="30%">Action</td> <td width="5%"><i class="fa fa-check" title="Acceptable"></i></td> <td width="5%"><i class="fa fa-close" title="Not Acceptable"></i></td> </tr> <?php } ?> </thead> <tbody> <?php $count = 1; $result = selQuery($query); while ($row = mysqli_fetch_assoc($result)) { ?> <?php if ($id == 2) { ?> <tr align="center"> <td align="left"><?php echo $row['protocol_category']; ?> </td> <td align="left"><?php echo isEmpty($row['protocol_desc']); ?> </td> <td> <button class="btn btn-system btn-sm" onclick="helpTest('<?php echo $row['protocol_id']; ?> ')"><i class="fa fa-question"></i> Guide</button> <button class="btn btn-primary btn-sm" onclick="viewList('<?php echo $row['protocol_id']; ?> ')"><i class="fa fa-paperclip"></i> Attachment</button> </td> <td><?php echo countArray("screen", $row['screen_y']); ?> </td> <td><?php echo countArray("screen", $row['screen_n']); ?> </td> <td><?php echo checkingTest($row['protocol_id']); ?> </td> </tr> <?php } elseif ($id == 5 || $id == 6) { if (checkAssign($row['protocol_id']) == true) { ?> <tr align="center"> <td> <input type="checkbox" value="<?php echo $row['protocol_id']; ?> "/> </td> <td align="left"><?php echo $row['protocol_category']; ?> </td> <td align="left"><?php echo $row['protocol_desc']; ?> </td> <td> <button class="btn btn-system btn-sm" onclick="helpTest('<?php echo $row['protocol_id']; ?> ')"><i class="fa fa-question"></i> Guide</button> <button class="btn btn-primary btn-sm" onclick="viewList('<?php echo $row['protocol_id']; ?> ')"><i class="fa fa-paperclip"></i> Attachment</button> </td> <td><?php echo countArray("screen", $row['screen_y']); ?> </td> <td><?php echo countArray("screen", $row['screen_n']); ?> </td> </tr> <?php } } } ?> </tbody> </table> <?php } else { echo "<span class='text-danger'>NO SUPPORTING DOCUMENTS REGISTERED</span>"; } ?> </div> <div class="row"> <div class="section-divider"></div> </div> <?php }