<?php 
	require_once('Connections/conn_ama.php');
	
	if(!isset($_SESSION)){
        session_start();
    }
    if(isset($_POST['categoryid'])){
		$colname = $_POST['categoryid'];
	}
	//echo "categorysubID: ".$colname;

    	//Retrieve Documents
    	$query_rsDocuments = "CALL documents_list('".$colname."')";//"SELECT categoryID, `categoryname`, categoryID, dateadded  FROM v_categorys ORDER BY dateadded DESC";
	    $rsDocuments = mysqli_query($conn_ama, $query_rsDocuments ) or die(mysqli_error($conn_ama));
	    $row_rsDocuments = mysqli_fetch_assoc($rsDocuments);
		$totalRows_rsDocuments = mysqli_num_rows($rsDocuments);/**/
		
		//echo $row_rsDocuments['categoryID'];
 ?>
<!-- <div class="col-md-9 data-area"> -->
	<div class="mreport-steps">
		<?php //include("mreport-steps.inc.php"); ?>
	</div><!-- End .mreport-step-->
	<div class="data-area-wrap">
        <h3><?php echo $row_rsDocuments['category']; ?></h3>
		<div class="form-wrapper">
			<h4><a class="btn btn-primary listdocuments" href="#" data-category="<?php echo $row_rsDocuments['category']; ?>" data-categoryid="<?php echo $row_rsDocuments['categoryID']; ?>">List Categories</a></h4>
            <!-- <h4><a href="#" class="addsubunit" data-category="<?php echo $row_rsDocuments['category']; ?>" data-categoryid="<?php echo $row_rsDocuments['categoryID']; ?>">Add Sub unit</a></h4> -->
            <h4><a href="#" class="adddocument" data-categoryid="<?php echo $colname; ?>">Add Document</a></h4>
			<table id="example" class="table" cellspacing="0" width="100%">
		        <thead>
		            <tr>
		                <th>Document</th>
		                <!-- <th>Category</th> -->
		                <!-- <th>Postion</th> -->
		                <!-- <th nowrap="nowrap">Date Added</th> -->
		                <!-- <th>Country</th> -->
		                <th>Edit</th>
		                <th>Delete</th>
		            </tr>
		        </thead>
		        <!-- <tfoot>
		            <tr>
		                <th>Player</th>
		                <th>Image</th>
		                <th>Postion</th>
		                <th>Jersey Number</th>
		                <th>Country</th>
		                <th>Edit</th>
		                <th>Delete</th>
		            </tr>
		        </tfoot> -->
		        <tbody>
		        <?php do { ?>
		            <tr>
		                <td><a href="#" ><?php echo $row_rsDocuments['doctitle']; ?></a></td>
		                <!-- <td align="center"><?php// echo ucwords($row_rsDocuments['category']); ?></td> -->
	                  	<!-- <td align="center"><?php// echo $row_rsDocuments['dateadded']; ?></td> -->
	                    <td align="center"><a href="#">Edit</a></td>
		                <td align="center"><a href="#">Delete</a></td>
		            </tr>
		        <?php } while($row_rsDocuments = mysqli_fetch_assoc($rsDocuments));?>
		            
		    	</tbody>
		    </table>
		</div><!-- End .form-wrapper-->
	</div><!-- End .data-area-wrap-->	
<!-- </div> -->

<script>

    $(document).ready( function() {
        $('#example').dataTable({
        	"pageLength": 10,
        	"order": []
        });
    });
</script>