<?php	
	@require_once("header.php");

define("PAGE_TITLE", "NEWSLETTER");
	define("TABLE_NAME", "site_newsletter");
	define("FILE_NAME", router(1));

nivel(FILE_NAME);

<a href="model/<?php echo FILE_NAME; ?>/export" target="_blank" class="btn btn-info btn-sm btns-mobile"><i class="fa fa-cloud-download"></i> BAIXAR .CSV</a>

</div>
	</div>
	<br />

<?php 
	if(router(2) == "lista" or router(2) == "list" or router(2) == ""):

$sql	= mysql_query("SELECT * FROM ".TABLE_NAME." ORDER BY data DESC");
	$result = mysql_num_rows($sql);
	
	if($result > 0):
		?>
		<div class="result-ordem" style="position: fixed; width: 100%; bottom: 0px; left: 0px; z-index: 3;"></div>
		<table id="tableList" class="table table-striped table-hover" cellspacing="0" width="100%">
			<thead>
				<tr>
					
					<th>E-mail</th>
					<th>Data</th>
				</tr>
			</thead>
			
			<tbody>
				<?php
				while($ln = mysql_fetch_object($sql)):
				?>
				<tr id="widgetArray_<?php echo $ln->ID; ?>" <?php //echo ($ln->status == "2") ? 'class="warning"' : ''; ?>>
					
					<td><?php echo $ln->email; ?></td>
					<td><?php echo date("d/m/Y", strtotime($ln->data)); ?></td>
				</tr>
				<?php
				endwhile;
				?>
			</tbody>
		</table>
		<?php
		else:
			echo '
				<br />
				<div class="alert text-center alert-info">
					Nenhum registro cadastrado para ser exibido.
				</div>
			';
		endif;
		?>
	
		<script>
		$(document).ready(function(){

$('#tableList').dataTable( {
				columnDefs: [{ type: 'chinese-string', targets: '_all' }],
				aaSorting: []
			});
			
		});
		</script>

<?php 
	endif; // List
	?>

</div>

<?php 
	@require_once("footer.php");
?>