Preview: manage_email.php
Size: 10.44 KB
/home/jambtst2015/public_html/giraffeng.com/admin/manage_email.php
<?php include("includes/head.php"); ?>
<?php include("includes/header.php"); ?>
<?php
if(empty($_REQUEST['delete'])){$_REQUEST['delete']='';}
if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')
{
mysql_query("delete from sat_email_master where id='".$_REQUEST['delete_id']."'");
//mysql_query("delete from sat_users_history where user_id='".$_REQUEST['delete_id']."'");
$delmsg="Email details deleted successfully";
}
?>
<script type="text/javascript" language="javascript">
<?php /*?>function view(userid)
{
window.open('view_user.php?userid='+userid+'&page=<?php echo $page; ?>&name=<?=$_REQUEST['name']?>&email=<?=$_REQUEST['email']?>&username=<?=$_REQUEST['username']?>&order=<?=$_REQUEST['order']?>&userclass=<?=$_REQUEST['userclass']?>&status=<?=$_REQUEST['status']?>&rcv_reqs_email=<?=$_REQUEST['rcv_reqs_email']?>&submittals_emails=<?=$_REQUEST['submittals_emails']?>&rvc_hotlist_email=<?=$_REQUEST['rvc_hotlist_email']?>&submit2=<?=$_REQUEST['submit2']?>','news view','height=400, width=1000, resizable=yes, scrollbars=yes');
}<?php */?>
function open_src(){
if(document.getElementById("div_src").style.display=='none'){
//document.getElementById("div_src").style.display='block';
$("#div_src").show("slow");
}
else{
//document.getElementById("div_src").style.display='none';
$("#div_src").hide("slow");
}
}
$(document).ready(function(){
setTimeout(function(){
$(".mydiv").fadeOut("slow", function () {
$(".mydiv").remove("slow");
});
}, 4000);
});
</script>
<div class="container_bottom_section">
<?php if($delmsg!=''){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $delmsg; ?></p>
<?php } ?>
<?php if($_REQUEST['success']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Email Added Successfully</p>
<?php } ?>
<?php if($_REQUEST['success']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">Details Updated Successfully</p>
<?php } ?>
<?php if($_REQUEST['success']=='4'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;">A/C Manager Transfered Successfully</p>
<?php } ?>
<a href="javascript:open_src();" class="require" style="margin-right:5px; margin-bottom:5px;"><i class="fa fa-search"></i> Search</a>
<?php if($level==1){ ?>
<?php /*?><a href="users_export_xls.php" class="require" style="margin-right:5px; margin-bottom:5px;">Export</a><?php */?>
<?php /*?><a href="emailform.php" class="require" style="margin-right:5px; margin-bottom:5px;">Add Email</a><?php */?>
<?php } ?>
<div class="clear"></div>
<?php
if(empty($_REQUEST['submit2'])){$_REQUEST['submit2']='';}
?>
<div class="search-box" style="padding:5px; <?php if($_REQUEST['submit2']=='') { ?>display:none;<?php } ?> border:1px solid #C4C4C4; margin-bottom:10px;" id="div_src">
<div class="require_add">
<h3 style="font-family:Arial, Helvetica, sans-serif; font-size:18px; float:left; color:#2597C9; padding-bottom:5px;"><i class="fa fa-search"></i> Search By</h3>
<div class="clear"></div>
</div>
<form name="myfrm" action="" method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="table_search">
<tr>
<td colspan="17" height="10"></td>
</tr>
<tr>
<td width="10%" height="25" class="require_table_search">Email Title:</td>
<td colspan="4" align="left" >
<input type="text" name="name" class="textfield require_field" value="<?php echo $_REQUEST['name']; ?>" />
</td>
<td width="10%" height="25" class="require_table_search">Email Address:</td>
<td colspan="4" align="left">
<input type="text" name="email_address" class="textfield require_field" value="<?php echo $_REQUEST['email_address']; ?>" />
</td>
<td>
<span style="float:right;">
<input name="submit2" type="submit" value="Search" class="require sm" style="margin-top:0px !important;"/>
<a href="manage_email.php" class="require org" style="text-decoration:none;"> Show All </a>
<!-- <a href="manage_email.php" style="text-decoration:none;">
<input name="submit3" type="button" value="Show All" class="submit" style="margin-top:0px;" />
</a> -->
</span>
</td>
</tr>
<!-- <tr>
<td> </td>
<td width="43"> </td>
<td width="40"> </td>
<td width="41"> </td>
<td width="158"> </td>
<td> </td>
<td> </td>
<td colspan="4">
<span style="float:left;">
<input name="submit2" type="submit" value="Search" class="submit" style="margin-top:0px;" />
<a href="manage_email.php" style="text-decoration:none;">
<input name="submit3" type="button" value="Show All" class="submit" style="margin-top:0px;" />
</a>
</span></td>
<td> </td>
<td> </td>
<td colspan="4"> </td>
</tr> -->
</table>
</form>
</div>
<table width="1100" class="list-table" border="1" cellspacing="0" cellpadding="0" bordercolor="#616161" style="border-collapse:collapse;">
<tr>
<td width="170" class="head_text">Title</td>
<td width="119" class="head_text">Email Address</td>
<td width="84" class="head_text text-center">Status</td>
<?php if($level==1){ ?>
<td width="84" class="head_text text-center">Action</td>
<?php } ?>
</tr>
<?php
if(empty($_REQUEST['order'])){ $_REQUEST['order']=''; }
$qry_contact = "select * from sat_email_master where 1 ";
if($_REQUEST['name']!=''){
$qry_contact .= " and title like '%".$_REQUEST['name']."%'";
}
if($_REQUEST['email_address']!=''){
$qry_contact .= " and email_address like '%".$_REQUEST['email_address']."%'";
}
if($_REQUEST['order']=="asc"){
$oredr = $_REQUEST['order'];
}
if($_REQUEST['order']=="desc"){
$oredr = $_REQUEST['order'];
}
if($_REQUEST['order']==""){
$oredr = 'desc';
}
$qry_contact .= " order by id ".$oredr;
//echo $qry_contact;
$_SESSION['sqlUser']='';
//$_SESSION['sqlUser'] = $qry_contact;
$sel_events=mysql_query($qry_contact);
////////////////////////////////Start pagination////////////////////////////////////
if(empty($_REQUEST['page'])) { $_REQUEST['page']=''; }
$page=$_REQUEST['page'];
if($page==""){
$page = 1;
}
if($_REQUEST['submit2']!='' && $page!=1){
$page = $page;
}
$max_results = 10;
$prev = ($page - 1);
$next = ($page + 1);
$from = (($page * $max_results) - $max_results);
$total_results = mysql_num_rows($sel_events);
$total_pages = ceil($total_results / $max_results);
$pagination = '';
if($page > 1)
{
$pagination .= "<a href=\"manage_email.php?page=$prev&name=".$_REQUEST['name']."&email_address=".$_REQUEST['email_address']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination_prev\">Previous</a>";
$pagination.=" ";
}
for($i = 1; $i <=$total_pages; $i++)
{
if(($page) == $i)
{
$pagination .= $i;
$pagination.=' ';
}
else
{
$pagination .= "<a href=\"manage_email.php?page=$i&name=".$_REQUEST['name']."&email_address=".$_REQUEST['email_address']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination\">$i</a>";
$pagination.=' ';
}
}
if($page < $total_pages)
{
$pagination .= "<a href=\"manage_email.php?page=$next&name=".$_REQUEST['name']."&email_address=".$_REQUEST['email_address']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination_prev\">Next</a>";
$pagination.=" ";
}
$qry_contact.=" limit $from,$max_results";
//echo $qry_contact;
$result=mysql_query($qry_contact);
////////////////////////////////End pagination////////////////////////////////////
if(mysql_num_rows($result)>0)
{
$inc=1;
while($row_contact_details=mysql_fetch_array($result))
{
$title = $row_contact_details['title'];
$email_address = $row_contact_details['email_address'];
//$userclass = $row_contact_details['userclass'];
/*---get userclass----*/
/*$sql_userclass = "select * from abs_user_level where id='".$userclass."'";
$qry_userclass = mysql_query($sql_userclass);
$arr_userclass = mysql_fetch_assoc($qry_userclass);
$userclassName = $arr_userclass['user_level'];*/
/*------end-------*/
$status = $row_contact_details['status'];
?>
<tr>
<td class="head_text2">
<?php echo $title; ?>
</td>
<td class="head_text2">
<?php echo $email_address; ?>
</td>
<td class="head_text2 text-center"><?php echo $status; ?></td>
<?php if($level==1){ ?>
<td class="head_text2 text-center">
<?php /*?><a href="manage_email.php?delete=del&delete_id=<?php echo $row_contact_details['id'];?>&page=<?=$_REQUEST['page']?>&name=<?=$_REQUEST['name']?>&email_address=<?=$_REQUEST['email_address']?>&submit2=<?=$_REQUEST['submit2']?>" onclick="return confirm('Are you sure you want to delete this Holiday?');">
<img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a><?php */?>
<a href="emailform_edit.php?id=<?php echo $row_contact_details['id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&email_address=<?=$_REQUEST['email_address']?>&submit2=<?=$_REQUEST['submit2']?>" id="edit" class="info_link"><img src="images/edit.png" alt="Edit" title="Edit" /></a>
</td>
<?php } ?>
</tr>
<?php
}
?>
<tr>
<td colspan="11" class="tbl-footer pagination-nw" style="background-color:;"><?php echo $pagination; ?></td>
</tr>
<?php
}
else
{
?>
<tr>
<td colspan="11" class="head_text" style="background-color:#B2CEFC;">No Email Address Found.</td>
</tr>
<?php
}
?>
</table>
<div class="clear"></div>
</div>
<?php include("includes/footer.php"); ?>
Directory Contents
Dirs: 17 × Files: 180