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

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

if (!$objDB) {
	$message	= "Unable to Locate Database Server.";
} else {
	$objM		= new miscellaneous($objDB);
	
	if (isset($_POST['DelNow'])) {
		$message	= $objM->change_service_status($_POST);
	}
	
	if (isset($_POST['SearchNow'])) {
		$array		= $objM->search_services($_POST, true);
	} else {
		$array		= $objM->search_services($_SESSION);
	}
//	$array		= $objM->get_all_payments();
	$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" type="text/javascript">
function confirm_check()
{
 var where_to= confirm("Do you really want to change the status for permenantly??");
 if (where_to== true)
 {
   return true;
 }
 else
 {
  return false;
  }
}
</script>
<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"><?php include_once('tophtml.php');?>
			<table width="100%"  border="0" cellspacing="0" cellpadding="5">
          <tr>
            <td><table width="100%"  border="0" cellspacing="0" cellpadding="5">
              <tr>
                <td width="41%" class="headings1">Services List</td>
                <td width="59%" class="headings1">&nbsp;</td>
              </tr>
              <tr>
                <td class="headings1">&nbsp;</td>
                <td align="right" class="maintext"><table width="76%" border="0" cellpadding="0" cellspacing="0" class="maintext">
                        <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post" name="frmSearch">
						<tr>
                          <th align="left" scope="col">User </th>
                          <th align="left" scope="col">Trans ID</th>
                          <th align="left" scope="col">Date</th>
                          <th scope="col">&nbsp;</th>
                        </tr>
                        <tr>
                          <td scope="col"> <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"><input name="trans" type="text" maxlength="100" value="<?php echo isset($objM->arrSearch['trans'])?stripslashes($objM->arrSearch['trans']):""?>" class="textbox"></td>
                          <td scope="col"> <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="signupbutton" style=" width:30px;">                            <script type="text/javascript" language="javascript">
															  Calendar.setup({
																inputField    : "date",
																button        : "button1",
																ifFormat      : "%Y-%m-%d",       // format of the input field
																showsTime     : false,
																timeFormat    : "24"
															  });
														</script>   </td>
                          <td scope="col">  <input name="imageField" type="image" class="nuller" src="../images/search.gif" width="63" height="20" 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></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="0" cellpadding="0">
					<?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">
                  <td height="40" align="center" class="maintext2"><strong class="boldtext">#</strong></td>
                  <td class="maintext2"><strong class="boldtext">User</strong></td>
                  <td class="maintext2"><strong class="boldtext">Amount</strong></td>
                  <td class="maintext2"><strong class="boldtext">Transaction ID</strong></td>
                  <td class="maintext2"><strong class="boldtext">Date</strong></td>
                  <td class="maintext2"><strong class="boldtext">Reason</strong></td>
                  <td class="maintext2"><strong class="boldtext">Status</strong></td>
                  <td class="maintext2">&nbsp;</td>
                </tr>
					<?php  	
							foreach ($data as $key => $value) 
							{ 
				?>
                <tr align="left">
                  <td width="3%" align="center" class="maintext2"><?php echo $key+1;?></td>
                  <td width="18%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vLogin']))?></td>
                  <td width="11%" class="maintext2"><?php echo $value['fAmount']?></td>
                  <td width="17%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vTxn_Id']))?></td>
                  <td width="15%" class="maintext2"><?php echo $value['dDay']?></td>
                  <td width="25%" class="maintext2"><?php echo (stripslashes($value['vReason']))?></td>
                  <td width="7%" align="center" class="maintext2"><?php echo $value['vOrdStatus']=="N"?"Pending":"Finished"?></td>
                  <td width="4%" align="center" class="maintext2"><input name="ids[]" type="checkbox" value="<?php echo $value['nOrdId']?>" <?php echo $value['vOrdStatus']=="N"?"":"disabled"?>></td>
                </tr>
				<?php 			}//end foreach
				?>
                <tr align="left">
                  <td align="center" class="maintext2">&nbsp;</td>
                  <td colspan="6" class="maintext2">&nbsp;</td>
                  <td align="center" class="maintext2"><input type="submit" name="DelNow" value="Set As Finished" class="loginbutton"></td>
                </tr>
				<?php
					 		}//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="2" cellpadding="0">
                        <tr align="center" class="textbox">
                          <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></td>
        </tr>
    </table>      
    </td>
  </tr>
</table>
<div class="calendar_widget" id="calendar_widget" style="display:none "><iframe id='calendar_widget_iframe' name='calendar_widget_iframe' style="border: none;" width=100% height=100% src="../date/calendar_widget.html" /></div>
<?php include_once('bottomhtml.php');?>