<tr> <th>Office Code</th> <th>Document Date</th> <th>Subject</th> <th>Reference Number</th> <th>Action Taken</th> <th>Action Date</th> <th>Status</th> <th>Download</th> </tr> </thead> <tbody> <?php for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); $referenceNumber = calculateReferenceNumber($db, $row, adjustControlNumber($row['ref_id'])); $sql2 = "select * from document_routing where reference_no='" . $row['ref_id'] . "' order by request_date desc"; $rs2 = $db->query($sql2); $row2 = $rs2->fetch_assoc(); $sql3 = "select * from routing_targets where routing_id='" . $row2["id"] . "'"; $rs3 = $db->query($sql3); $row3 = $rs3->fetch_assoc(); $action = getAction($db, $row3['action_id']); ?> <tr> <td><?php echo $row['sending_office']; ?> </td> <td><?php echo $row['document_date'];
?> </td> <td><?php echo getOriginatingOffice($db, $searchRow['originating_office']); ?> </td> <td><?php echo $searchRow['document_date']; ?> </td> <td><?php echo $searchRow['receive_date']; ?> </td> <td><?php echo calculateReferenceNumber($db, $searchRow, adjustControlNumber($searchRow['ref_id'])); ?> </td> </tr> <?php } ?> </tbody> <tfoot> <tr> <th>Subject</th> <th>Originating Office</th> <th>Document Date</th> <th>Received Date</th> <th>Reference Number</th> </tr>
<tr> <th>Office Code</th> <th>Document Date</th> <th>Subject</th> <th>Status</th> </tr> </thead> <tbody> <?php $routing_Option = "<select class='form-control' name='reference_number'>"; for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); $document_type = getDocumentType($db, $row['document_type']); $docId = $row['ref_id']; $reference_number = calculateReferenceNumber($db, $row, adjustControlNumber($docId)); ?> <tr> <td><?php echo $row['sending_office']; ?> </td> <td><?php echo date("Y-m-d", strtotime($row['document_date'])); ?> </td> <td><a href='submit.php?reference_number=<?php echo $reference_number; ?> '><?php echo $row['subject'];
<tr> <th>Subject</th> <th>Classification</th> <th>Document Date</th> <th>Originating Office</th> <th>Information</th> </tr> </thead> <tbody> <?php $routing_Option = "<select class='form-control' name='reference_number'>"; for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); $row2 = getDocumentDetails($db, $row['reference_no']); $reference = calculateReferenceNumber($db2, $row2, adjustControlNumber($row['reference_no'])); ?> <tr> <td><?php echo $row2['subject'] . " " . $reference; ?> <a style="color:red" href='download.php?refId=<?php echo $row2['ref_id']; ?> ' target='window'>[Link]</a></td> <td>Office Order</td> <td><?php echo date("Y-m-d", strtotime($row2['document_date'])); ?> </td> <td><?php
$rr[0]="a".$i; $rr[1]="b".$i; addContent($rr,$excel,getOriginatingOffice($db, $row['originating_office']),"true",$ExWs); setCellArea($rr,$excel,$ExWs,$excel); styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel); $rr[0]="c".$i; $rr[1]="d".$i; addContent($rr,$excel,$row['subject'],"true",$ExWs); setCellArea($rr,$excel,$ExWs,$excel); styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel); $rr[0]="e".$i; $rr[1]="f".$i; addContent($rr,$excel,calculateReferenceNumber($db,$row,adjustControlNumber($row['ref_id'])),"true",$ExWs); setCellArea($rr,$excel,$ExWs,$excel); styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel); $rr[0]="g".$i; $rr[1]="g".$i; addContent($rr,$excel,$row['document_type'],"true",$ExWs); setCellArea($rr,$excel,$ExWs,$excel); styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel); $rr[0]="h".$i; $rr[1]="i".$i; addContent($rr,$excel,date("Y-m-d", strtotime($row['document_date'])),"true",$ExWs); setCellArea($rr,$excel,$ExWs,$excel); styleCellArea(setRange($rr[0],$rr[1]),"false","true",$ExWs,$excel);