?>
</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>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'];
$db = connectDb();
$sql = "select max(id) from reference_increment";
$rs = $db->query($sql);
$nm = $rs->num_rows;
if ($nm > 0) {
    $row = $rs->fetch_assoc();
    $controlId = $row['id'] * 1 + 1;
} else {
    $controlId = 1;
}
?>
												<label class='control-label pull-left' ><span id='reference_stamp' name='reference_stamp'><?php 
echo $reference_stamp;
?>
</span>.<?php 
echo adjustControlNumber($controlId);
?>
.<?php 
echo $_SESSION['division_code'];
?>
</label>

												</div>
                                            </div>
										</fieldset>
										<fieldset title="Step 2">
                                            <legend>Provide Routing Details</legend>
                                            <?php 
$db = connectDb();
?>
<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 
    ?>
<tr>
	<td><?php 
    echo $row['sending_office'];
    ?>
</td>
	<td><?php 
    echo $row['document_date'];
    ?>
</td>
	<td><?php 
    echo $row['subject'];
    ?>
</td>
	<td><?php 
    echo adjustControlNumber($row['ref_id']);
    ?>
</td>
	<td><?php 
    echo $row['status'];
    ?>
</td>
	<td><a style='color:red' href='download.php?refId=<?php 
    echo $row['ref_id'];
    ?>
'>Link</a></td>
</tr>
<?php 
}
?>
</table>
<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'];
			$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);