<?php
require_once ("../config.inc.php");
require_once ("../includes/adminlogincheck.inc.php");
require_once ("../includes/mysql.inc.php");
require_once ("../includes/arrays.inc.php");
require_once ("../classes/miscellaneous.class.php");
require_once ("../includes/Pager/Pager.php");

$message	= "";
$pages		= "";
$data		= array();
$array		= array();
$page		= isset($_REQUEST['page'])	?	trim($_REQUEST['page'])	:	"1";
$title		= isset($_REQUEST['title'])	?	trim($_REQUEST['title'])	:	"";
$order		= isset($_REQUEST['order'])	?	trim($_REQUEST['order'])	:	"";
$image='<img src="../images/bgar.gif"></img>';
if($order=='DESC') {

    $image='<img src="../images/descar.gif"></img>';
}

else if($order=='ASC') {

    $image='<img src="../images/ascrar.gif" ></img>';

}
if (!isset($_REQUEST['page'])) {
	$_SESSION['api_search']	= "";
}

	
if (!$objDB) {
	$message	= "Unable to Locate Database Server.";
} else {
	$objM		= new miscellaneous($objDB);

	if (isset($_POST['SearchNow'])) {
		$array		= $objM->search_apicalls($_POST, true);
	} else {
		$array		= $objM->search_apicalls($_SESSION,false,$sort=$title.' '.$order);
	}

	$params 	= array(
		'mode'      => 'Sliding',
		'perPage'   => PAGESIZE,
		'urlVar'    => 'page',
		'extraVars' => array(),
		'itemData'  => $array
	);

	$objP 		= & Pager::factory($params);
	$data  		= $objP->getPageData();

	if (empty($data))
		$message	.= "No record(s) exists.<br>";
}

include_once('title.inc.php');
?>
<script type="text/javascript" src="../scripts/calendar.js"></script>
<script type="text/javascript" src="../scripts/calendar-setup.js"></script>
<script type="text/javascript" src="../scripts/calendar-en.js"></script>
<link href="../scripts/calendar.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../js/jquery.js"></script>
<script type="text/javascript" src="../js/jquery.autocomplete.js"></script>
<link href="../js/searchstyle.css" rel="stylesheet" type="text/css">
<script language="javascript">
function confirm_check()
{
 	var where_to= confirm("Do you really want to delete these success stories for permenantly??");
	 if (where_to== true)
	 {
	   return true;
	 }
 	else
 	{
  		return false;
  }
}
</script>
<?php include_once('tophtml.php');?>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" class="white"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="72%" valign="top">
			<table width="100%"  border="0" cellspacing="0" cellpadding="5">
          <tr>
            <td><table width="100%"  border="0" cellspacing="0" cellpadding="5">
              <tr>
                    <td height="10">&nbsp;</td>
               </tr>      
              <tr>
                <td width="41%" class="headings1" colspan="2">Security API Calls List</td>
              </tr>
			  </table>
			  <div class="bordernew padding2">
			<table width="100%" cellspacing="0" cellpadding="0" border="0">
              <tr>
                <td class="">&nbsp;</td>
                <td align="right" class="maintext"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="search_wrapper_tbl_admin">

                        <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post" name="frmSearch">

						<!--tr>

                          <th align="left" scope="col"> </th>

                          <th align="left" scope="col"></th>

                          <th align="left" scope="col"></th>

                          <th align="left" scope="col"></th>

                          <th scope="col">&nbsp;</th>


                        </tr-->

                        <tr>

                          <td scope="col" width="18%">User<input name="user" id="user" type="text" maxlength="100" value="<?php echo isset($objM->arrSearch['user'])?stripslashes($objM->arrSearch['user']):""?>" class="textbox"> </td>

                          <td scope="col" width="15%">Type<select name="type" class="textbox">

                                <?php foreach ($arrAPITYpeSearch as $keys => $values) { ?>

                                <option value="<?php echo $keys?>" <?php echo isset($objM->arrSearch['type'])&&($objM->arrSearch['type']==$keys)?"selected":""?>>

                                <?php echo $values?>

                                </option>

                                <?php } ?> </select>

						 </td>

                          <td scope="col" width="19%">From<input name="date" id="date" type="text" value="<?php echo isset($objM->arrSearch['date'])?stripslashes($objM->arrSearch['date']):""?>" maxlength="50" readonly class="textbox">                            <input type="button" value="v" id="button1" name="button1"  class="button_stylenew" style=" width:30px;">                            <script type="text/javascript" language="javascript">

															  Calendar.setup({

																inputField    : "date",

																button        : "button1",

																ifFormat      : "%m/%d/%Y",       // format of the input field

																showsTime     : false,

																timeFormat    : "24"

															  });

														</script>   </td>

                          <td scope="col" width="16%">Status<select name="status" class="textbox">

                                <?php foreach ($arrIDVerifiedSearch as $keys => $values) { ?>

                                <option value="<?php echo $keys?>" <?php echo isset($objM->arrSearch['status'])&&($objM->arrSearch['status']==$keys)?"selected":""?>>

                                <?php echo $values?>

                                </option>

                                <?php } ?>

								 </select> 

					       </td>

                          <td scope="col"><input name="imageField" type="image" class="nuller" src="../images/search.gif" border="0">                            <input type="hidden" name="SearchNow" value="SearchNow">                          </td>

                        </tr>

<script type="text/javascript">

$(document).ready(function() {

	$("#user").autocomplete("takeusernames.php", { minChars:1, matchSubset:1, matchContains:1, selectOnly:1 });

});

</script>

						

						</form>

                      </table></td>
              </tr>
            </table>
			<form name="form1" method="post" action="" onSubmit="return confirm_check();">
          <table width="100%"  border="0" cellspacing="0" cellpadding="5">
            <tr>
              <td><table width="100%"  border="0" cellspacing="1" cellpadding="0" class="listing_tbl_admin">
					<?php 	if(isset($message) && $message!='')
							{
					?>
                <tr align="left">
                  <td align="center" class="maintext2">&nbsp;</td>
                  <td colspan="8" class="maintext2 warning"><?php echo $message;?></td>
                  </tr>
					<?php  	}//end if
				      if ($objDB) 
					  { 
                 			if (!empty($data)) 
							{ 
				?>
                <tr align="left">
                  <th align="center" class="maintext2">#</td>
                  <th class="maintext2">User<a href="apicalls.php?title=vLogin&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                  <th class="maintext2">Type<a href="apicalls.php?title=vType&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                  <th class="maintext2">Date<a href="apicalls.php?title=dDay&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                  <th class="maintext2">Status<a href="apicalls.php?title=vStatus&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                  </tr>
					<?php  	
							foreach ($data as $key => $value) 
							{ 
				?>
                <tr align="left">
                  <td width="5%" align="center" class="maintext2"><?php echo $key+1;?></td>
                  <td width="27%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vLogin']))?></td>
                  <td width="27%" class="maintext2"><?php echo $arrAPITYpe[$value['vType']]?></td>
                  <td width="21%" class="maintext2"><?php echo date("m/d/Y",strtotime($value['dDay']))?></td>
                  <td width="20%" class="maintext2"><?php echo $arrIDVerified[$value['vStatus']]?></td>
                  </tr>
				<?php 			}//end foreach
					 		}//end if
						}//end first if
				?>
              </table>
				<?php if(!empty($data))
					  {
				?>
                <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="82%">&nbsp;</td>
                    <td width="18%">
						<table width="100%"  border="0" cellspacing="0" cellpadding="2" class="pagination_style">
							<tr><td>&nbsp;</td></tr>
							<tr align="center">
								<td><?php echo $objP->links;?></td>
							</tr>
						</table>
					</td>
                  </tr>
                </table><?php }//end if?>
                <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td align="right"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td>&nbsp;</td>
                      </tr>
                    </table>
                      </td>
                  </tr>
                </table></td>
            </tr>
          </table></form>
			</div>
			</td>
          </tr>
        </table>
		</td>
        </tr>
    </table>      
    </td>
  </tr>
</table>
<?php include_once('bottomhtml.php');?>