<?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/users.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 {
    $objU		= new users($objDB);

    if (isset($_POST['DelNow'])) {
    
        $message	= $objU->delete_interests($_POST);
    }
    if (isset($_POST['SearchNow'])) {
        $array		= $objU->search_interests($_POST, true);
    } else {
        $array		= $objU->search_interests($_SESSION,false,$sort=$title.' '.$order);
    }
//	$array		= $objU->get_all_interests();
    $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 chkVar;
        for (var i = 0; i < document.form1.elements.length; i++)
        {
            var e = document.form1.elements[i];
            if (e.name == "ids[]")
            {
                if(e.checked==true)
                {
                    chkVar=true;
                }//end if
            }//end if
        }//end for loop

        if(chkVar==true)
        {
            var where_to= confirm("Do you really want to delete these interests permenantly??");
            if (where_to== true)
            {
                return true;
            }
            else
            {
                return false;
            }
        }//end if
    }
    $(function(){
        // add multiple select / deselect functionality
        $("#checkAll").click(function () {
            $('.case').attr('checked', this.checked);
        });

        // if all checkbox are selected, check the selectall checkbox
        // and viceversa
        $(".case").click(function(){

            if($(".case").length == $(".case:checked").length) {
                $("#checkAll").attr("checked", "checked");
            } else {
                $("#checkAll").removeAttr("checked");
            }

        });
    });

</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 height="10">&nbsp;</td>
                            </tr>
                            <tr>
                                <td class="headings1">Interests</td>
                            </tr>
                        </table>
                        <div class="bordernew padding2">
                            <table width="100%"  border="0" cellspacing="0" cellpadding="0">

                                <tr>
                                    <td>
                                        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                                            <tr>
                                                <td >&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>
                                                                <td align="right">
                                                                    <label>From</label><input name="from" id="from" type="text" maxlength="100" value="<?php echo isset($objU->arrSearch['from'])?stripslashes($objU->arrSearch['from']):""?>" class="searchwidth1 ">
                                                                    <label>To</label><input name="to" id="to" type="text" maxlength="100" value="<?php echo isset($objU->arrSearch['to'])?stripslashes($objU->arrSearch['to']):""?>" class="searchwidth1 "> 
                                                                    <label>Date</label><input name="date" id="date" type="text" value="<?php echo isset($objU->arrSearch['date'])?stripslashes($objU->arrSearch['date']):""?>" maxlength="50" readonly class="searchwidth1 ">
                                                                    <input type="button" value="v" id="button1" name="button1"  class="button_stylenew" style=" width:30px;">
                                                                    <input name="imageField" type="image" class="nuller" src="../images/search.gif" width="63" height="27" align="absmiddle" border="0">
                                                                </td> </tr>
                                                            <tr>


                                                            <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">                             <input type="hidden" name="SearchNow" value="SearchNow">                          </td>
                                                            </tr>
                                                            <script type="text/javascript">
                                                                $(document).ready(function() {
                                                                    $("#from").autocomplete("takeusernames.php", { minChars:1, matchSubset:1, matchContains:1, selectOnly:1 });
                                                                });
                                                            </script>
                                                            <script type="text/javascript">
                                                                $(document).ready(function() {
                                                                    $("#to").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="1" cellpadding="0" class="listing_tbl_admin">
<?php 	if(isset($message) && $message!='') {
    ?>
                                                <tr align="left">
                                                    <td colspan="8" class="maintext2 warning"><?php echo $message;?></td>
                                                </tr>
    <?php  	}//end if
if ($objDB) {
    if (!empty($data)) {
                                                        ?>
                                                <tr align="left">
                                                    <th class="maintext2" align="center"><input type="checkbox" id="checkAll" name="checkAll" title="Check All / Uncheck All"/></th>
                                                    <th align="center" class="maintext2">#</th>
                                                    <th class="maintext2">From<a href="interests.php?title=vLogin_From&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                                                    <th class="maintext2">To<a href="interests.php?title=vLogin_To&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image?></a></th>
                                                    <th class="maintext2">Date<a href="interests.php?title=dDay&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image?></img></a></th>
                                                    <th class="maintext2">Status<a href="interests.php?title=vStatus&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image?></img></a></th>

                                                </tr>
        <?php
        foreach ($data as $key => $value) {
            ?>
                                                <tr align="left">
                                                    <td width="5%" align="center" class="maintext2"><input name="ids[]" class="case" type="checkbox" value="<?php echo $value['nInterest_Id']?>"></td>
                                                    <td width="5%" align="center" class="maintext2"><?php echo $key+1;?></td>
                                                    <td width="30%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vLogin_From']))?></td>
                                                    <td width="21%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vLogin_To']))?></td>
                                                    <td width="21%" class="maintext2"><?php echo date("m/d/Y",strtotime($value['dDay']))?></td>
                                                    <td width="10%" class="maintext2"><?php echo $arrIntrestStatus[$value['vStatus']]?></td>

                                                </tr>
            <?php 			}//end foreach
        ?>

        <?php
    }//end if
}//end first if
?>
                                            </table>
                                            <table width="100%" cellspacing="1" cellpadding="1" border="0" style="margin-top:10px;">
                                                <tr align="left">

                                                    <td align="left" >
                                                        <!--
                                                        <input type="button" name="DelNow" value="Delete" class="loginbutton" style="cursor:pointer" title="Delete Selected" onClick="deleteProducts(this.form);">
                                                        -->
                                                        <input type="submit" name="DelNow" value="Delete" class="loginbutton" style="cursor:pointer" title="Delete Selected" >

                                                    </td>
                                                    <td width="18%"><?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" class="pagination_style">
                                                                        <tr align="center" class="textbox">
                                                                            <td><?php echo $objP->links;?></td>
                                                                        </tr>
                                                                    </table></td>
                                                            </tr>
                                                        </table><?php }//end if?></td>
                                                </tr>

                                            </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">
                                                         <table border="0" cellspacing="0" cellpadding="5" class="pagination_style">
                                                         <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></div></td>
                </tr>
            </table>
        </td>
    </tr>
</table><?php include_once('bottomhtml.php');?>
<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>
