<?php
/*////////////////////
PLATAFORMA: AVIVAR
ARQUIVO...: dashboard.php
AUTOR.....: MARLOS SANTANA
DESCRIÇÃO.: dashboard do Cliente
*/////////////////////
// define diretório de armazenamento da sessão e a inicia
ini_set('session.save_path',realpath(dirname($_SERVER['DOCUMENT_ROOT']) . '/..
/tmp'));
session_start();
if (!isset($_SESSION)) {//Verificar se a sessão não já está aberta.
	echo "<script>document.location='login.php'</script>";
  exit;
}
else
{

	if(isset($_SESSION['Nome']) ){
		include('paginas/funcoes/dbfunc.php');
		include('paginas/funcoes/funcoes.php');
		include('paginas/cmd/conecta.php');

// Abre a página adm

	}
	else
	{
		echo "<script>document.location='login.php'</script>";
	  exit;
	}
}
$_SESSION["Cor"]="ion ion-android-arrow-up text-success";
//$_SESSION["DATAAP"]= PSQ_TXDATA1AP();
?>
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
	<title>AVIVAR | ADM</title>
	<link rel="icon"  sizes="56x56" href="img/logo/sbl.png">
  <!-- Tell the browser to be responsive to screen width -->
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <!-- Font Awesome -->
  <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
  <!-- Tempusdominus Bbootstrap 4 -->
  <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css">
  <!-- iCheck -->
  <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css">
  <!-- JQVMap -->
  <link rel="stylesheet" href="plugins/jqvmap/jqvmap.min.css">
	<!-- DataTables -->
	<link rel="stylesheet" href="plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
	<link rel="stylesheet" href="plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="dist/css/adminlte.min.css">
  <!-- overlayScrollbars -->
  <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css">
  <!-- Daterange picker -->
  <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css">
  <!-- summernote -->
  <link rel="stylesheet" href="plugins/summernote/summernote-bs4.css">
  <!-- Google Font: Source Sans Pro -->
  <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
</head>
<body class="hold-transition sidebar-mini layout-fixed">
<div class="wrapper">

  <!-- Navbar -->
	<nav class="main-header navbar navbar-expand navbar-white navbar-light">
    <!-- Left navbar links -->
    <ul class="navbar-nav">
      <li class="nav-item">
        <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a>
      </li>
    </ul>
    <!-- Right navbar links -->
    <ul class="navbar-nav ml-auto">
      <!-- Messages Dropdown Menu -->
			<li class="nav-item d-none d-sm-inline-block">
				<?php
				$imguser =  $_SESSION["Foto"];
				//$imguser =  "1_hchome/img/user/user1.jpg";
				echo "
				<div class='image'>
					<img src='$imguser' class='img-circle elevation-2'  width='35' height='35'>
				</div>"
				?>
			</li>
      <li class="nav-item d-none d-sm-inline-block">
        <a href="#" class="nav-link"><?php echo $_SESSION['Nome'];?></a>
      </li>
      <li class="nav-item">
        <a class="nav-link" data-slide="true" href="#" role="button">
          <i class="fas fa-th-large"></i>
        </a>
      </li>
    </ul>
  </nav>
  <!-- /.navbar -->

  <!-- Main Sidebar Container -->
  <aside class="main-sidebar sidebar-dark-primary elevation-4">
    <!-- Brand Logo -->
		<div class="sidebar">
      <!-- Sidebar user (optional) -->
      <div class="user-panel mt-3 pb-3 mb-3 d-flex">
				<?php
				$imgig = $_SESSION["MKT_Dir_Nome"]."/img/logo/logosbl.png";
				echo "<div class='image'>
          <img src='$imgig' class='img-circle elevation-2'>
        </div> ";
				?>
        <div class="info">
          <a href="#" class="d-block"><?php echo $_SESSION['MKT_NomeAbv'];?></a>
        </div>

      </div>
      <!-- Sidebar Menu -->
      <?php
			 include("menu.php") ?>
      <!-- /.sidebar-menu -->
    </div>
    <!-- /.sidebar -->
  </aside>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
		<div class="content-header">
			<div class="container-fluid">
				<div class="row mb-2">
					<div class="col-sm-6">
						<h1 class="m-0 text-dark">DASH<strong>BOARD</strong></h1>
					</div><!-- /.col -->
				</div><!-- /.row -->
			</div><!-- /.container-fluid -->
		</div>
    <section class="content">

			<div class="row">
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-info elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">PASTORES</span>
							<span class="info-box-number"><h3><?PHP echo "C".contagem("PASTORES")."F".contagem("PASTORESF");?></span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-danger elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">PASTORAS	</span>
							<span class="info-box-number">
								<span class="info-box-number"><h3><?PHP  echo "C".contagem("PASTORAS")."F".contagem("PASTORASF")?></span>
							</span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-success elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">INSCRITOS</span>
							<span class="info-box-number">
								<span class="info-box-number"><h3><?PHP  echo contagem("INSCRITOS")?></span>
							</span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-warning elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">FILA DE ESPERA</span>
							<span class="info-box-number"><h3><?PHP   echo contagem("FILA")?></span>
							</span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-success elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">CANCELADOS</span>
							<span class="info-box-number"><h3><?PHP   echo contagem("CANCELADO")?></span>
							</span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
				<div class="col-12 col-sm-6 col-md-2">
					<div class="info-box">
						<span class="info-box-icon bg-danger elevation-1"><i class="fas fa-users"></i></span>
						<div class="info-box-content">
							<span class="info-box-text">NEGATIVADOS</span>
							<span class="info-box-number"><h3><?PHP   echo contagem("NEGATIVADO")?></span>
							</span>
						</div>
						<!-- /.info-box-content -->
					</div>
					<!-- /.info-box -->
				</div>
			</div>
			<div class="row">
				<div class="col-md-12">
				<div class="card">
					<div class="card card-blue card-outline">
								<div class="card-header">
									<h3 class="card-title">INSCRITOS <strong>AVIVAR 2025</strong></h3>
								</div>
								<div class="card-body">
									<div class="col-md- col-sm-12 ">
										<div class="x_panel">
											<div class="x_content">
												<form method = "POST" action = "crfnc_002.php"  enctype="multipart/form-data">
													<table id="Consulta" class="table table-bordered table-striped">
														<thead>
															<tr>
																<th>ID</th>
																<th>NOME</th>
																<th>GN.</th>
																<th>FC. </th>
																<th>IGREJA </th>
																<th>Celular</th>
																<th>CIDADE</th>
																<th>UF</th>
																<th>STATUS</th>
															</tr>
														</thead>
														<tbody>
															<?php
															 PSQ_PSTRSDSB();
															?>
														</tbody>
													</table>

												</form>
											</div>
										</div>
									</div>
								</div>
				<!-- /.nav-tabs-custom -->
		</div>
				</div>
			</div>
				<div class="col-md-6">
					<div class="card">
						<div class="card-header">
							<h3 class="card-title">ANIVER<strong>SARIANTES</strong></h3>
							<div class="card-tools">
								<span class="badge badge-info"><?php echo Mes_extenso(); ?></span>
								<button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
								</button>
								<button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
								</button>
							</div>
						</div>
						<!-- /.card-header -->
						<div class="card-body p-0">
							<div class="table-responsive">
								<table id="Niver" class="table m-0 table-bordered table-striped">
									<thead>
									<tr align = "center">
									 <th>NOME</th>
									 <th>ANIVERSÁRIO</th>
									 <th>STATUS</th>
									</tr>
									</thead>
									<tbody>
										<?php
											Niver();
										?>
									</tbody>
								</table>
							</div>
							<!-- /.table-responsive -->
						</div>

						<!-- /.card-body -->
						<div class="card-footer text-center">
						</div>
						<!-- /.card-footer -->
					</div>
				</div>
				<!-- /.col -->
				<!-- /.col -->
			</div>
    </section>
		<!-- Main content -->
 	<div class="content">

 </div>
 <!-- /.content -->
</div>
		<footer class="main-footer">
			<div class="float-right d-none d-sm-block">
				<b>Versão 1.0</b>
			</div>
				MINISTÉRIO<strong> AVIVAR  &copy;</strong>
		</footer>

  <!-- Control Sidebar -->
  <aside class="control-sidebar control-sidebar-dark">
    <!-- Control sidebar content goes here -->
  </aside>
  <!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->

<!-- jQuery -->
<script src="plugins/jquery/jquery.min.js"></script>
<!-- jQuery UI 1.11.4 -->
<script src="plugins/jquery-ui/jquery-ui.min.js"></script>
<!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
<script>
  $.widget.bridge('uibutton', $.ui.button)
</script>
<!-- Bootstrap 4 -->
<script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- ChartJS -->
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Sparkline -->
<script src="plugins/sparklines/sparkline.js"></script>
<!-- JQVMap -->
<script src="plugins/jqvmap/jquery.vmap.min.js"></script>
<script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
<!-- jQuery Knob Chart -->
<script src="plugins/jquery-knob/jquery.knob.min.js"></script>
<!-- daterangepicker -->
<script src="plugins/moment/moment.min.js"></script>
<script src="plugins/daterangepicker/daterangepicker.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Summernote -->
<script src="plugins/summernote/summernote-bs4.min.js"></script>
<!-- overlayScrollbars -->
<script src="plugins/datatables/jquery.dataTables.min.js"></script>
<script src="plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
<script src="plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
<script src="plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
<script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/adminlte.js"></script>
<!-- AdminLTE dashboard demo (This is only for demo purposes) -->
<script src="dist/js/pages/dashboard.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<!-- FLOT CHARTS -->
<script src="plugins/flot/jquery.flot.js"></script>
<!-- FLOT RESIZE PLUGIN - allows the chart to redraw when the window is resized -->
<script src="plugins/flot-old/jquery.flot.resize.min.js"></script>
<!-- FLOT PIE PLUGIN - also used to draw donut charts -->
<script src="plugins/flot-old/jquery.flot.pie.min.js"></script>
<script src="plugins/chart.js/Chart.min.js"></script>
<!-- Page script -->
<script>
  $(function () {
    $("#Consulta").DataTable({
      "responsive": true,
      "autoWidth": false,
      "scrollY":        "350px",
      "scrollCollapse": true,
      "ordering": true,
      "paging":         false,

    });
  });
</script>
</body>
</html>
