<?php
	require_once('source/session.php');
	require_once('source/error.php');
	require_once('source/dbconfig.php');
	require_once('source/function.php');
	require_once('source/restrict_admin.php');
	
	if($_GET['msg'] == "refered"){
		$msg = "<h5 class='alert alert-success'>Refered successfully</h5>";
	}else if($_GET['msg'] == "failed"){
		$msg = "<h5 class='alert alert-warning'>Something went wrong, please try again</h5>";
	}
?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <meta name="description" content="">
  <meta name="author" content="">
  <title>American Jet Cargo</title>
  <!-- Bootstrap core CSS-->
  <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <!-- Custom fonts for this template-->
  <link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
  <!-- Page level plugin CSS-->
  <link href="vendor/datatables/dataTables.bootstrap4.css" rel="stylesheet">
  <!-- Custom styles for this template-->
  <link href="css/sb-admin.css" rel="stylesheet">
  <link href="css/user_profile.css" rel="stylesheet">
  
  <!-- select-->
  <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
  
</head>

<body class="fixed-nav sticky-footer bg-dark" id="page-top">
  <!-- Navigation-->
  <nav class="navbar navbar-expand-lg navbar-dark bg-dark fixed-top" id="mainNav">
  
<?php
            	
            	$rows = sql($DBH, "SELECT * FROM tbl_admin where status = ?", 
            	array("Active"), "rows");							
            	foreach($rows as $row)
            	{
            		$admin_name 		= $row['username'];
            	}
		
      if (isset($_SESSION['SESS_HASH_ADMIN'])) {
		$user_true 			 = "<img class='user one' src='profile_pic/$profile_pic' width='200px'><a class='navbar-brand' href='index.php' style='font-weight: bold; color: gold'> $fullname</a>";
		
}
		echo "$user_true ";
?>
    <button class="navbar-toggler navbar-toggler-right" type="button" data-toggle="collapse" data-target="#navbarResponsive" aria-controls="navbarResponsive" aria-expanded="false" aria-label="Toggle navigation">
      <span class="navbar-toggler-icon"></span>
    </button>
    <div class="collapse navbar-collapse" id="navbarResponsive">
      <ul class="navbar-nav navbar-sidenav" id="exampleAccordion">
        <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Dashboard">
          <a class="nav-link" href="main.php">
            <i class="fa fa-fw fa-dashboard fa-spin" style="color: #3498db"></i>
            <span class="nav-link-text" style="color: yellow">Dashboard</span>
          </a>
        </li>
        <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Charts">
          <a class="nav-link" href="sales_rep.php">
            <i class="fa fa-fw fa-user-o fa-spin" style="color: #3498db"></i>
            <span class="nav-link-text" style="color: yellow">Sale's Rep</span>
          </a>
        </li>
        <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Tables">
          <a class="nav-link" href="notice.php">
            <i class="fa fa-fw fa-money fa-spin" style="color: #3498db"></i>
            <span class="nav-link-text" style="color: yellow">Post Message (PM)</span>
          </a>
        </li>
        <li class="nav-item" data-toggle="tooltip" data-placement="right" title="Tables">
          <a class="nav-link" href="logout.php">
            <i class="fa fa-fw fa-money fa-spin" style="color: #3498db"></i>
            <span class="nav-link-text" style="color: yellow">Logout</span>
          </a>
        </li>
      </ul>
      <ul class="navbar-nav ml-auto">
        <li class="nav-item">
          <a class="nav-link" data-toggle="modal" href="logout.php" style="color: yellow">
            <i class="fa fa-fw fa-sign-out"></i>Logout</a>
        </li>
      </ul>
    </div>
  </nav>
            <?php
				$rows = sql($DBH, "SELECT * FROM tbl_user where hash = ?", array($SESS_HASH_USER), "rows");							
                foreach($rows as $row)
                {	
					$profile_pic	   = $row['profile_pic'];
					$fullname 		   = $row['fullname'];
					$email 			   = $row['email'];
					$password 		   = $row['password'];
					$bitcoin_wallet    = $row['bitcoin_wallet'];
					$bank_name 		   = $row['bank_name'];
					$account_name 	   = $row['account_name'];
					$account_number    = $row['account_number'];
					$phone 			   = $row['phone'];
					$country 		   = $row['country'];
					$state 		   = $row['state'];
					$city 		   = $row['city'];
					$registration_date = $row['registration_date'];
					$registration_date = $row['registration_date'];
					$email_verified    = $row['email_verified'];
					$hash    		   = $row['hash'];
				}
				if($email_verified == "true")
				{
					$email_box = "<input style='border: 1px solid #00b300 !important' class='w3-input w3-border' type='email' title='Verified Email'
					value='$email' readonly disabled>";
				}
				else
				{
					$email_box = "<input style='border: 1px solid #ff0000 !important' class='w3-input w3-border' type='email' title='Un-Verified Email'
                    value='$email' name='email' autocomplete='off' disabled>";
				}
			?>
  <div class="content-wrapper">
    <div class="container-fluid">
      <!-- Breadcrumbs-->
      <ol class="breadcrumb" style="background: gold">
        <li class="breadcrumb-item">
          <a href="index.php" style="color: black; font-weight: bold">Notification</a>
        </li>
        <li class="breadcrumb-item active" style="color: black">Notification</li>
      </ol>
      <div class="row">
        <div class="col-lg-12">
              <?php
                  if($_GET['msg'] == "post")
				  {
					  echo "<div class='alert alert-success'>
								<strong> News </strong> has been posted successfully.
							</div>";
				  }
                  if($_GET['msg'] == "failed")
				  {
					  echo "<div class='alert alert-danger'>
								<strong>News </strong> posting failed, please try again thanks.
							</div>";
				  }
			  ?>
          <!-- Example Bar Chart Card-->
      <ol class="breadcrumb"style="background: #3498db">
                                    <h6 align="center"><strong>DASHBOARD</strong></h6>
                                    </ol>
                <hr>
                <form method="post" action="exe_post_news.php" class="form-horizontal" enctype="multipart/form-data">
                  <div class="form-group">
                    <label class="col-sm-2 control-label">Recipient Email<span class="text-danger">*</span></label>
                    <div class="col-sm-8">
                      <input type="email" class="form-control" name="email" placeholder="Enter Email Address" required />
                    </div>
                  </div>
                  <div class="form-group">
                    <label class="col-sm-2 control-label">Message Title<span class="text-danger">*</span></label>
                    <div class="col-sm-8">
                      <input type="text" class="form-control" name="news_title" placeholder="your message title..." required />
                    </div>
                  </div>

                  <div class="form-group">
                    <label class="col-sm-2 control-label">Message <span class="text-danger">*</span></label>
                    <div class="col-sm-8">
                      <textarea rows="5" class="form-control" name="news" placeholder="Enter your message to post..." required></textarea>
                    </div>
                  </div>

                  <hr>

                  <div class="row">
                    <div class="col-sm-10 col-sm-offset-2">
                      <button class="btn btn-success btn-quirk btn-wide mr5" name="post_news">Send Message</button>
                      <button type="reset" class="btn btn-quirk btn-wide btn-default">Reset</button>
                    </div>
                  </div>

                </form>
                
                
                <table class="table table-bordered table-inverse table-striped nomargin">
                  <thead>
                    <tr>
                        <th>Email</th>
                        <th>Message</th>
                        <th>Date</th>
                        <th></th>
                    </tr>
                  </thead>
                  <tbody>       
<?php
			$rows1 = sql($DBH, "SELECT * FROM tbl_news where id >= ?", array(1), "rows");							
			foreach($rows1 as $row1)
			{	
				$news_id		= $row1['id'];
				$email			= $row1['email'];
				$news_title	   		= $row1['news_title'];
				$news 		   	= $row1['news'];
				$date 			= $row1['date'];
				$news_status 		= $row1['news_status'];
				
				if($news_status == "RECEIVED MESSAGE"){
				$news_s = "$news_status<br/><a href='read.php?id=$news_id'>
														<button class='btn btn-primary btn-sm'>DONE</button>
													</a>";
				}else if($news_status == "READ"){
				$news_s =  "$news_status";
				}
				
		echo "
		<tr $color>
                        <th><small>$email</small></th>
                        <th><small><b>Title: $news_title<b></small><br/><small>$news</small><br/></th>
                        <th><small>$date</small></th>
                        <th><small>$news_s</small></th>
		</tr>";
	}
?>  
                  </tbody>
                </table>
                              </div>
          </div>
    <!-- /.container-fluid-->
    <!-- /.content-wrapper-->
    <footer class="sticky-footer" style="background: gold">
      <div class="container">
        <div class="text-center">
          <small><strong>Copyright © Reserved! American Jet Cargo Developement Theme.</strong></small>
        </div>
      </div>
    </footer>
    <!-- Scroll to Top Button-->
    <a class="scroll-to-top rounded" href="#page-top">
      <i class="fa fa-angle-up"></i>
    </a>
    <!-- Logout Modal-->
    <div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
      <div class="modal-dialog" role="document">
        <div class="modal-content">
          <div class="modal-header">
            <h5 class="modal-title" id="exampleModalLabel">Ready to Leave?</h5>
            <button class="close" type="button" data-dismiss="modal" aria-label="Close">
              <span aria-hidden="true">×</span>
            </button>
          </div>
          <div class="modal-body">Select "Logout" below if you are ready to end your current session.</div>
          <div class="modal-footer">
            <button class="btn btn-secondary" type="button" data-dismiss="modal">Cancel</button>
            <a class="btn btn-primary" href="Sign_in.php">Logout</a>
          </div>
        </div>
      </div>
    </div>
    <!-- Bootstrap core JavaScript-->
    <script src="vendor/jquery/jquery.min.js"></script>
    <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
    <!-- Core plugin JavaScript-->
    <script src="vendor/jquery-easing/jquery.easing.min.js"></script>
    <!-- Page level plugin JavaScript-->
    <script src="vendor/chart.js/Chart.min.js"></script>
    <script src="vendor/datatables/jquery.dataTables.js"></script>
    <script src="vendor/datatables/dataTables.bootstrap4.js"></script>
    <!-- Custom scripts for all pages-->
    <script src="js/sb-admin.min.js"></script>
    <!-- Custom scripts for this page-->
    <script src="js/sb-admin-datatables.min.js"></script>
    <script src="js/sb-admin-charts.min.js"></script>
  </div>
</body>

</html>
