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

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

<?php

///////////////Add Events///////////////////////////////////////////////	

if($_REQUEST['add']=="ADD" && count($_POST)>0 && $_REQUEST['main_activity_id']=='' && $_REQUEST['action']!="edit")

{
	$catname=mysql_real_escape_string($_REQUEST['main_activityname']);
	$recordexsist=dupcheck('sat_main_activity','main_activity',$catname);
	if($recordexsist>0){
		$msg = 4;
		header("location:manage_main_activity.php?msg=$msg");
	}else{
		mysql_query("insert into sat_main_activity set main_activity='".$catname."'");
	
		$msg = 1;
	
		header("location:manage_main_activity.php?msg=$msg");
	}
}

	

/////////////End Add//////////////////////////////////////////////



///////////////////////////Edit Events////////////////////////////

if($_REQUEST['edit']=="EDIT" && count($_POST)>0 && $_REQUEST['main_activity_id']!='' && $_REQUEST['action']=="edit")

{
	mysql_query("update sat_main_activity set main_activity='".mysql_real_escape_string($_REQUEST['main_activityname'])."' where main_activity_id=".$_REQUEST['main_activity_id']."");

	$msg = 2;

	header("location:manage_main_activity.php?msg=$msg&page=".$_REQUEST['page_hide']."");

}



///////////////////////////End edit events////////////////////////



///////////////////////////For Edit////////////////////////////////////////////////

$array_product_details="";

if($_REQUEST['action']=="edit" && $_REQUEST['main_activity_id']!='' && !$_REQUEST['edit'])

{

	$array_product_details=mysql_fetch_array(mysql_query("select * from sat_main_activity where main_activity_id=".$_REQUEST['main_activity_id']." order by main_activity"));

	$_REQUEST['main_activityname']=$array_product_details['main_activity'];

}

//////////////////////End for edit///////////////////////////////////////////

///////////////////For Delete//////////////////////////////////////////////

if($_REQUEST['delete']=="del" && $_REQUEST['delete_id']!='')

{

	mysql_query("delete from sat_main_activity where main_activity_id=".$_REQUEST['delete_id']."");

	mysql_query("delete from abs_exhibit where main_activity_id=".$_REQUEST['delete_id']."");

	$msg = 3;

	header("location:manage_main_activity.php?msg=$msg&page=".$_REQUEST['page_hide']."");

}

///////////////////////End for delete//////////////////////////////////

if(!$_REQUEST['page'])	

{

	$_SESSION['srchstr']="";

	$_SESSION['srchkey']="";

}		

?>

<script>

jQuery.noConflict();

(function($) {jQuery(document).ready(function(){

	// binds form submission and fields to the validation engine

	jQuery("#formID").validationEngine();

});})(jQuery);

</script>

<script type="text/javascript" language="javascript">

function validate()

{

	if(document.frmproduct.main_activityname.value=='')

	{

		alert("Please enter exhibit main_activity name");

		document.frmproduct.main_activityname.focus();

		return false;

	}

	return true();

}

function open_src(val){
	if(val==''){
		$('#div_add_task').toggle("slow");
	}
	else{
		$('#div_src_req').toggle("slow");
	}
}

function open_src_src(val){
	if(val==''){
		$('#div_src').toggle("slow");
	}
	else{
		$('#div_src').toggle("slow");
	}
}

$(document).ready(function(){
	setTimeout(function(){
		$(".mydiv").fadeOut("slow", function () {
			$(".mydiv").remove("slow");
		});
	}, 4000);
});
</script>
<font color="#009933"></font>
<?php
$msg=$_REQUEST['msg'];
if($msg == 1){

	$msg = '<font color="#009933">Activity added successfully</font>';

}

if($msg == 2){

	$msg = '<font color="#009933">Activity updated successfully</font>';

}

if($msg == 3){

	$msg = "Activity deleted successfully";

}

if($msg == 4){

	$msg = "Activity already exsists";

}


?>

<div class="container_bottom_section">
<?php if($_REQUEST['msg']=='3'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='1'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='2'){ ?>
<p class="mydiv" style="color:#090; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<?php if($_REQUEST['msg']=='4'){ ?>
<p class="mydiv" style="color:#F00; float:left; font-family:Verdana, Geneva, sans-serif; font-size:13px; text-align:left;"><?php echo $msg; ?></p>
<?php } ?>
<!--<a href="javascript:window.history.back();" class="require" style="margin-right:5px; margin-bottom:5px;">Back</a>-->
<?php if($_REQUEST['action']=="" && $_REQUEST['main_activity_id']==''){ ?>
<a href="javascript:open_src_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Search</a>
<a href="javascript:open_src('');" class="require" style="margin-right:5px; margin-bottom:5px;">Add Activity</a>
<?php } ?>
<div class="clear"></div>
<!--search-->
<div 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;">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="14" height="10"></td>

  </tr>

  <tr>

    <td width="10%" height="25" valign="top" class="require_table_search">Activity Name:</td>

    <td colspan="4" align="left" valign="top">

      <input name="main_activityname" size="25" maxlength="255" type="text" value="<?php echo $_REQUEST['main_activityname']?>" class="validate[required] textfield" />

    </td>

    <td width="5%"><span style="float:left;">
      <input name="submit2" type="submit" value="Search" class="submit" style="margin-top:0px;"  />
    </span></td>

    <td width="1%" valign="top" class="require_table_search">&nbsp;</td>

    <td width="31%" align="left" valign="top"><span style="float:left;">
        <a href="manage_main_activity.php" style="text-decoration:none;">
          <input name="submit3" type="button" value="Show All" class="submit" style="margin-top:0px;"  />
          </a>
        </span></td>

    <td width="2%">&nbsp;</td>

    <td width="14%" valign="top" class="require_table_search">&nbsp;</td>

    <td width="1%" colspan="4" align="left" valign="top">&nbsp;</td>

  </tr>

  

  

  <tr>

    <td colspan="14" height="10"></td>

  </tr>

  

</table>

</form>



</div>
<!--search-->
<!--content-->
<div>
<form name="frmproduct" id="formID" action="manage_main_activity.php" method="post" >

<input type="hidden" name="main_activity_id" value="<?php echo $_REQUEST['main_activity_id']?>" />

<input type="hidden" name="action" value="<?php echo $_REQUEST['action']?>" />

<input type="hidden" name="page_hide" value="<?php echo $_REQUEST['page']?>" />

<input type="hidden" name="search_market" value="<?php echo $_REQUEST['search_market']?>" />

	<table width="100%" border="0" cellspacing="0" cellpadding="0">

           <tr>

             <td><table width="100%" border="0" cellspacing="0" cellpadding="0">

               <tr>

                 <td width="86%" align="center">
				<div id="div_add_task" style="display:<?php if($_REQUEST['action']=="edit" && $_REQUEST['main_activity_id']!='' && !$_REQUEST['edit']){ ?>block<?php }else{ ?>none<?php } ?>;">
                 <table width="531" height="161" border="0" cellpadding="0" cellspacing="0" align="center" style="border:1px solid #CCCCCC;">

                 	  

                 

                   <tr>

                     <td align="center" valign="middle" colspan="5" height="10" class="head_text" ><?php if($_REQUEST['action']=="edit" && $_REQUEST['main_activity_id']!='' && !$_REQUEST['edit']){ ?>Edit<?php }else{ ?>Add<?php } ?> Activity</td>

                   </tr>

                   

                   <tr class="smalltext">

                     <td height="28" colspan="5" align="left" valign="middle" class="enquiery"><table width="100%" border="0" cellspacing="0" cellpadding="0">

                   <tr class="smalltext">
                     <td height="10" colspan="3" align="center" valign="top" class="head_text2">&nbsp;</td>
                     </tr>
                   <tr class="smalltext">

                     <td width="131" height="22" align="center" valign="top" class="head_text2">Activity Name </td>

                     <td width="12" align="left" valign="top" class="enquiery">:</td>

                     <td align="left" valign="top"><input name="main_activityname" size="25" style="width:360px;" maxlength="255" type="text" value="<?php echo $_REQUEST['main_activityname']?>" class="validate[required] textfield" /></td>

                     </tr>

                   <tr>

                     <td height="30" align="left" valign="top" class="enquiery">&nbsp;</td>

                     <td align="left" valign="top" class="enquiery"></td>

                     <td valign="top" class="button" aign="left">
                       
                       <? if($_REQUEST['action']=="edit")

					 {

					 ?>
                       
                       <input type="submit" name="edit" class="newadd" value="EDIT" border="0" style="margin:0px;" />
                       <a href="manage_main_activity.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" /></a>
                       <?

					 }

					 else

					 {

					 ?>
                       
                       <input type="submit" name="add" class="newadd" value="ADD" border="0" style="margin:0px;" />
                       <a href="manage_main_activity.php"><input type="button" name="back" id="back" class="newadd" value="Cancel" style=" margin-bottom:10px;" /></a>
                       <?

					 }

					 ?>                     </td>

                     </tr>

                   <tr class="smalltext">

                     <td height="10" colspan="3" align="left" valign="middle" class="enquiery"></td>

                   </tr>

</table></td>

                   </tr>

                 </table>
                 </div>
                 </td>

               </tr>

             </table></td>

           </tr>

           <tr>

             <td>&nbsp;</td>

           </tr>

           <tr>

             <td><table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">

              

             </table></td>

           </tr>

           <tr>

             <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">

               

               <tr>

                 <td align="center" valign="top" class="smalltext">

                 <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" style="border-collapse:collapse;">

                   <tr class="smalltexthead">

                     <td width="25%" height="22" align="center" class="head_text">No</td>

                     <td width="52%" align="center" class="head_text">Activity</td>

                     <td width="23%" align="center" class="head_text">Action</td>

                   </tr>

                  <?php

				   $query_res="select * from sat_main_activity where main_activity_id!=''";

					

					if($_REQUEST['main_activityname']!='')

						{

							$query_res.=" and main_activity like '%".$_REQUEST['main_activityname']."%'";

						}

						

						$query_res.=" order by main_activity_id DESC";

						//echo $query_res;

					

					$sel_product=mysql_query($query_res);

					

					//////////////////////start pagination/////////////////////////

		

		$page=$_REQUEST['page'];

		

		if($_REQUEST['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_product); 

		$total_pages = ceil($total_results / $max_results); 

		

		$pagination = ''; 

		



		if($page > 1) 

		{ 

		$pagination .= "<a href=\"manage_main_activity.php?page=$prev&main_activityname=".$_REQUEST['main_activityname']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination_prev\">Previous</a>"; 

		$pagination.="&nbsp;&nbsp;&nbsp;";

		} 

		

		for($i = 1; $i <=$total_pages; $i++) 

		{ 

		if(($page) == $i) 

		{ 

		$pagination .= $i; 

		$pagination.='&nbsp;&nbsp;&nbsp;';

		} 

		else 

		{ 

		$pagination .= "<a href=\"manage_main_activity.php?page=$i&main_activityname=".$_REQUEST['main_activityname']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination\">$i</a>"; 

		$pagination.='&nbsp;&nbsp;&nbsp;';

		} 

		} 

		

		if($page < $total_pages) 

		{ 

		$pagination .= "<a href=\"manage_main_activity.php?page=$next&main_activityname=".$_REQUEST['main_activityname']."&submit2=".$_REQUEST['submit2']."\" class=\"more_link_pagination_prev\">Next</a>"; 

		$pagination.="&nbsp;&nbsp;&nbsp;";

		} 

		

		$query_res.=" limit $from,$max_results";

		//echo $query_res;

		$query_products=mysql_query($query_res);

		////////////////////////////////End pagination////////////////////////////////////

					if(mysql_num_rows($query_products)>0)

					{

						$inc=1;

						while($array_products=mysql_fetch_array($query_products))

						{

							if($inc%2==0)

                        	{

					?><tr bgcolor="#eeeeee" class="newtxt">

                    <?

							}

							if($_REQUEST['page']!="")

							{

								$j=($_REQUEST['page']-1)*10;

							}

					?>

				    <td align="center" valign="middle" class="head_text2"><?php echo $a=($j+$inc); ?></td>

				    <td align="center" valign="middle" class="head_text2"><?php echo $array_products['main_activity']?></td>

				    <td align="center" valign="middle" class="head_text2"><a href="manage_main_activity.php?action=edit&main_activity_id=<?php echo $array_products['main_activity_id'];?>&page=<?=$_REQUEST['page']?>"><img src="images/1304761512_pen.png" alt="Edit" title="Edit" border="0" /></a>&nbsp;&nbsp;
                    <?php /*?><a href="manage_main_activity.php?delete=del&delete_id=<?php echo $array_products['main_activity_id'];?>&page=<?=$_REQUEST['page']?>" onClick="return confirm('Are you sure?');"><img src="images/1304761651_DeleteRed.png" alt="Delete" title="Delete" border="0" /></a><?php */?>
                    </td>

					</tr>

					<?php

						$inc++;}

					}
					else{
					?>
                    <tr>

                 <td align="center" colspan="3" valign="middle" height="30" style="color:#666; font-weight:bold; font-family:Verdana, Geneva, sans-serif; font-size:13px;">Sorry, no result found</td>

               </tr>
                    <?php
					}
					?>

             </table></td>

           </tr>

               <tr>

                 <td align="center" valign="top">&nbsp;</td>

               </tr>

               <tr>

                 <td height="20" colspan="10" align="center" valign="middle" bgcolor="#B2CEFC" class="head_text"><?=$pagination;?></td>

               </tr>

      </table></td></tr></table>

</form>
</div>
<!--content-->
<div class="clear"></div>
</div>

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