芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/holidays.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_holiday_master where id='".$_REQUEST['delete_id']."'");

//mysql_query("delete from  sat_users_history where user_id='".$_REQUEST['delete_id']."'");

$delmsg="Holiday details deleted successfully";

}

<?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>

<?php if($delmsg!=''){ ?>

<?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;">Holiday 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 */?>

<a href="holidayform.php" class="require org" style="margin-right:5px; margin-bottom:5px;"><i class="fa fa-plus"></i> Add Holiday</a>

<?php } ?>

<?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">

<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>

<tr>

</tr>

<tr>

<td width="10%" height="25" class="require_table_search">Holiday Name:</td>

</td>

</tr>

</table>

</form>

</div>

<tr>

<td width="119" class="head_text">Holiday Name</td>

<td width="101" class="head_text">Holiday Date</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_holiday_master where 1 ";

if($_REQUEST['name']!=''){

$qry_contact .= " and holiday_name like '%".$_REQUEST['name']."%'";

}

if($_REQUEST['year']!=''){

$qry_contact .= " and year like '%".$_REQUEST['year']."%'";

}

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=\"holidays.php?page=$prev&name=".$_REQUEST['name']."&year=".$_REQUEST['year']."&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=\"holidays.php?page=$i&name=".$_REQUEST['name']."&year=".$_REQUEST['year']."&order=".$_REQUEST['order']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination\">$i</a>";

$pagination.='   ';

}

if($page < $total_pages)

{

$pagination .= "<a href=\"holidays.php?page=$next&name=".$_REQUEST['name']."&year=".$_REQUEST['year']."&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))

{

$holiday_name = $row_contact_details['holiday_name'];

$year = $row_contact_details['year'];

//$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-------*/

$holiday_date = $row_contact_details['holiday_date'];

$status = $row_contact_details['status'];

<tr>

<?php echo $year; ?>

</td>

<?php echo $holiday_name; ?>

</td>

<?php if($level==1){ ?>
	<td class="head_text2 text-center">
	
    <a href="holidays.php?delete=del&delete_id=<?php echo $row_contact_details['id'];?>&page=<?=$_REQUEST['page']?>&name=<?=$_REQUEST['name']?>&year=<?=$_REQUEST['year']?>&submit2=<?=$_REQUEST['submit2']?>" onclick="return confirm('Are you sure you want to delete this Holiday?');" style="text-decoration:none;">

<img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" />
    
    <a href="holidayform_edit.php?id=<?php echo $row_contact_details['id'];?>&page=<?php echo $_REQUEST['page']; ?>&name=<?=$_REQUEST['name']?>&year=<?=$_REQUEST['year']?>&submit2=<?=$_REQUEST['submit2']?>" id="edit" class="info_link"><img src="images/edit.png" alt="Edit" title="Edit" /></a>

</a>

</td>
    <?php } ?>

</tr>

<?php

}

<?php

}

else

{

<tr>

<td colspan="11" class="head_text" style="background-color:#B2CEFC;">No Holidays Found.</td>

</tr>

<?php

}

</table>

</div>

<?php include("includes/footer.php"); ?>