Пример #1
0
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";
    }
}
Пример #2
0
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%">&nbsp;</td>
        </tr>
      <?php 
        } elseif ($id == 5 || $id == 6) {
            ?>
        <tr class="primary" align="center">
          <td width="5%">&nbsp;</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 
}