One Hat Cyber Team

View File Name : mg_eqmsg.php

<? error_reporting(0);
session_start();
include 'config.php';

$_POST['username']=$_SESSION['username'];	
$_POST['password']=$_SESSION['password'];

$sql=mysql_query("select * from admin where USERNAME='".$_POST['username']."' and PASSWORD='".$_POST['password']."'");	
if(mysql_num_rows($sql)==1)
{

date_default_timezone_set("Asia/Kolkata");
$todate = date("Y-m-d H:i:s");

if($_GET['SAI']){

$STS = $_GET['EQ_STS'];

if($STS == 0){

 $upd_sts =  mysql_query("UPDATE enquiry SET EQ_STS ='0' WHERE EQ_NO ='".$_GET['SAI']."'");  //for changing status

}

else{

$upd_sts =  mysql_query("UPDATE enquiry SET EQ_STS ='1' WHERE EQ_NO ='".$_GET['SAI']."'");

}	

}



if (isset($_POST['submit'])) 
	{
	$msg = mysql_real_escape_string($_POST['msg']);
	$year= mysql_real_escape_string($_POST['year']);	
	if($msg)
	{
	$table2 = mysql_query("select * from enquiry WHERE  EQ_DATE like '$year-%-%' AND EQ_STS='1'");


	while($row2=mysql_fetch_array($table2)) 
	{

	$username = 'SHAHAJ';
	$key = '9fc19b3ab1XX';
	$mobile = $row2['EQ_MOBILE'];
	$sender = 'SHAHAJ';
	$accusage = '1';					
	$smstext   =   $msg;	
	$message = urlencode($smstext);
	$data1 = 'user='.$username.'&key='.$key."&mobile=".$mobile."&message=".$message."&senderid=".$sender."&accusage=".$accusage ;
	$ch = curl_init('http://mobicomm.dove-sms.com/submitsms.jsp?'.$data1);
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
	$response = curl_exec($ch);
	curl_close($ch);
	
	$emailfrom ="postmaster@shahajservice.com";
	$to = $row2['EQ_MAIL']; 
	$subject = "Email from Sha Haj Service";
	$message = "
				<p>$msg</p>
				<h2 style='color:#9EC35C;'>SHA HAJ SERVICE (INDIA) PRIVATE LIMITED</h2><h4>APPROVED BY GOVT OF INDIA AND KSA  |  ISO CERTIFIED COMPANY</h4>
				<label>Website: www.shahajservice.com </label> &nbsp; &nbsp;<label>E-mail:</label> info@shahajservice.com
				";
	// Always set content-type when sending HTML email
	$headers = "MIME-Version: 1.0" . "\r\n";
	$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
	// More headers
	$headers .= 'From:'. $emailfrom . "\r\n";
	$send = mail($to,$subject,$message,$headers);
	}
	}
	
	$to="";
	$subject = "Email from Sha Haj Service";
	$message = "
				<p>$msg</p><br>
<h2 style='color:#00407f;'>SHA HAJ SERVICE (INDIA) PRIVATE LIMITED</h2>
<p>APPROVED BY GOVT OF INDIA AND KSA  |  ISO CERTIFIED COMPANY</p>
<h4 style='color:#8fca40;'><b>HAJ | UMRAH | ZIYARAH</b></h4>
<p><j style='color:#00407f;'>REGISTRATION OFFICE</j> <br>
OLD NO: 35 NEW NO: 71 | SRI VENKATESH BHAVAN | <br>
PORTION-D THIRD FLOOR | ARMENIAN STREET | <br>
CHENNAI -600 001 | TAMIL NADU | INDIA. <br>
PHONE: 044 2524 0888 | 2525 0888 | 4511 8006 | FAX: 044 2523 0888. <br>
MOBILE: 94451 50009 | 94455 51940 | 94430 10287. <br>
SAUDI MOBILE: 05018 71553 | 05528 49970 | 05528 49833.</p>
<label>Website: <u style='color:#234786;'> https://www.shahajservice.com </u> </label> &nbsp; &nbsp;<label>E-mail:</label> <u style='color:#234786;'> info@shahajservice.com |
shahajservice@yahoo.com | shahajservice@gmail.com </u>
";
	// Always set content-type when sending HTML email
	$headers = "MIME-Version: 1.0" . "\r\n";
	$headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
	// More headers
	$headers .= 'From:'. $emailfrom . "\r\n";
	$headers .= 'Cc:'. $emailfrom . "\r\n";
	$send = mail($to,$subject,$message,$headers);						
	}	
?>		           


<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin Panel</title>

<link href="css/bootstrap.min.css" rel="stylesheet">

<link href="css/datepicker3.css" rel="stylesheet">
<link href="css/bootstrap-table.css" rel="stylesheet">
<link href="css/styles.css" rel="stylesheet">

</head>

    <script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>

    <script type="text/javascript">

    tinymce.init({

        selector: "textarea",

        themes: "modern",   

		forced_root_block : 'p'
		
        plugins: [

            "advlist autolink lists link image charmap print preview anchor",

            "searchreplace visualblocks code fullscreen",

            "insertdatetime media table contextmenu paste"

        ],

        toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image"   
 
    });

    </script>



<body>

	<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">

		<div class="container-fluid">

			<div class="navbar-header">

				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse">
	<a href="#">
					<span class="sr-only">Toggle navigation</span>

					<span class="icon-bar"></span>

					<span class="icon-bar"></span>

					<span class="icon-bar"></span>
	</a>
				</button>

				<a class="navbar-brand" href="#">Admin</a>

				<ul class="user-menu">

					<li class="dropdown pull-right">

						<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user"></span> User <span class="caret"></span></a>

						<ul class="dropdown-menu" role="menu">

							<li><a href="#"><span class="glyphicon glyphicon-user"></span> Profile</a></li>

							<li><a href="#"><span class="glyphicon glyphicon-cog"></span> Settings</a></li>

							<li><a href="logou.php"><span class="glyphicon glyphicon-log-out"></span> Logout</a></li>

						</ul>

					</li>

				</ul>

			</div>

		</div><!-- /.container-fluid -->

	</nav>

		

	<div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar">
		<form role="search">
			<div class="form-group">
				<input type="text" class="form-control" placeholder="Search">
			</div>
		</form>
	 <? include('header.php');?>  


	</div><!--/.sidebar-->
		
	<div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">			
		<div class="row">
			<ol class="breadcrumb">
				<li><a href="dash.php"><span class="glyphicon glyphicon-home"></span></a></li>

				<li class="active">Manage SMS & E-mail</li>

			</ol>

		</div><!--/.row-->



		
		<div class="row">

			<div class="col-lg-12">

				<h2 class="page-header">For Enquired Customer</h2>

			</div>

		</div><!--/.row-->

		<section class="content">

			<div class="row">

            <!-- left column -->

            <div class="col-xs-12">

              <!-- general form elements -->

              <div class="box box-primary">



                <!-- form start -->

				<div class="container">

		



				</div>

			  </div>

			</div>

			</div>

		</section>		

	<hr>
		<div class="row">

			<div class="col-lg-12 col-sm-12">

				<div class="panel panel-default">

					<div class="panel-heading">Enquired Customer Table</div>

					<div class="container">			
					<?php 
					$queryear=mysql_query("select *  from year ORDER BY Y_LIST DESC");
					while($rowyear=mysql_fetch_array($queryear)) {?>		
					
					<div class="box">
					<div class="top">
					<?php echo $yr=$rowyear['Y_LIST'];?>
					</div>
					<hr>
					<?php 
					$querypak=mysql_query("select *  from package");
					if($rowpak=mysql_fetch_array($querypak)) {?>	

			
					<div class="panel-body bottom">
				
				<form role="form" method="post" action="" enctype="multipart/form-data">

                  <div class="box-body">

                    <div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Type your Message</label>
					  
                     <textarea class="form-control" rows="4" name="msg" placeholder="Enter your msg" required></textarea>					  

                    </div>


<input type="hidden" name="year" value="<?php echo $rowyear['Y_LIST'];?>">
                  <div class="box-footer col-sm-11">

			        

                    <button type="submit" name="submit" value="submit" class="btn btn-primary">Submit</button>

					<button type="reset" class="btn btn-primary">Reset</button>

			

                  </div>

				  </div>


                </form>
		
						<table data-toggle="table"  data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc"> 
							
							<thead>

						    <tr>

						        <th data-field="state" data-checkbox="true" >Item ID</th>
						        <th data-field="id" data-sortable="true">Item ID</th>
						        <th data-field="fname"  data-sortable="true">Name</th>								
						        <th data-field="fmob"  data-sortable="true">Mobile No</th>	
						        <th data-field="fmail"  data-sortable="true">Email</th>									
								<th data-field="status" data-sortable="true">Select</th>

						    </tr>

						    </thead>

							<tbody>

							<?php 

							

                            $table = mysql_query("select * from enquiry where EQ_DATE like '$yr-%-%' ORDER BY EQ_NO DESC");

							$EQ_NO=1;

							while($row=mysql_fetch_array($table))

							{

							?>

							   <tr> <td></td>


							   <td><?php echo $EQ_NO;?></td>
	

							   <td><?php echo $row['EQ_NAME'];?></td>		

							   <td><?php echo $row['EQ_MOBILE'];?></td>								   
							   
							   <td><?php echo $row['EQ_MAIL'];?></td>									   

							   <td><?php if($row['EQ_STS']==1) {?> <a href = "mg_eqmsg.php?EQ_STS=0&SAI=<?php echo $row['EQ_NO'];?>">Selected</a> <?php } else {?> <a href = "mg_eqmsg.php?EQ_STS=1&SAI=<?php echo $row['EQ_NO'];?>">Unselect</a> <?php } ?></td>
							  

							  </tr>


                            <?php

							  $EQ_NO++;

							 }?>

							</tbody>
							
						</table>

					</div>
					
					<? } ?>
					</div>
					<? } ?>
					

					
					</div>					

				</div>

			</div>

		</div>



	</div>	<!--/.main-->

</body>



</html>

<script src="js/jquery-1.11.1.min.js"></script>

<script src="js/bootstrap.min.js"></script>

<script src="js/chart.min.js"></script>

<script src="js/chart-data.js"></script>

<script src="js/easypiechart.js"></script>

<script src="js/easypiechart-data.js"></script>

<script src="js/bootstrap-datepicker.js"></script>

<script src="js/bootstrap-table.js"></script>

<script>
	$(document).ready(function() {
    $('ul.subcat').hide();

    $('li').click(function(event) {
        event.stopPropagation();
        $('> ul', this).toggle();

    });
	});
</script>
<script>
$('.top').on('click', function() {
	$parent_box = $(this).closest('.box');
	$parent_box.siblings().find('.bottom').hide();
	$parent_box.find('.bottom').toggle();
});

</script>
<style>

.container .box .top {
  padding: 12px;
  background-color: blue;
  color: white;
  cursor: pointer;
}

.container .box .bottom {

  display: none;
}

@media (min-width: 501px) and (max-width: 2000px){
.container .box {
width:auto;
max-width:900px;
}


}

@media (min-width: 5px) and (max-width: 500px){
.container .box {
width:100%;
max-width:350px;
}


}
</style>

<? } 
else
{
$queryu=mysql_query("select * from admin where ID='1'");
$rowu=mysql_fetch_array($queryu); 		
		
if($rowu)
{
$rowu['A_LOG'];	
$log = $rowu['A_LOG'] - 1;
$upd_sts =  mysql_query("UPDATE admin SET A_LOG ='$log' where ID='1'"); 
}
header("Location: home.php");
}
?>