<?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";
$flag		= isset($_REQUEST['act'])	?	trim($_REQUEST['act'])	:	"0";
$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 ($flag == "1") {
        $message	= "<font color='green'>You have successfully saved the details.</font><br>";
    }
    if (isset($_POST['DelNow'])) {
        $message	= $objM->delete_free_codes($_POST);
    }
    /*
	if (isset($_POST['DelNow'])) {
		$message	= $objM->delete_testimonials($_POST);
	} */
    if (isset($_POST['SearchNow'])) {
        $array		= $objM->search_free_codes($_POST, true);
    } else {
        $array		= $objM->search_free_codes($_SESSION,false,$sort=$title.' '.$order);
    }
    //$array		= $objM->get_all_free_codes();
    $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 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 want to permanently delete this free code ?");
            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><table width="100%"  border="0" cellspacing="0" cellpadding="5">
                                        <tr>
                                            <td height="10">&nbsp;</td>
                                        </tr>
                                        <tr>
                                            <td width="32%" class="headings1" colspan="2">Free Codes</td>
                                            <!--td width="68%" align="right" class="headings1"><a href="freecode_report.php" class="signupbuttonlink">Free Code Report</a>&nbsp;<a href="manage_freecodes.php" class="signupbuttonlink">Add New Free Codes</a></td-->
                                        </tr>
                                    </table>
                                    <div class="bordernew padding2">
                                        <table class="search_wrapper_tbl_admin" width="100%" cellpadding="0" cellspacing="0" border="0">
                                            <tr>
                                                <td align="right" class="maintext"><table width="100%" 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"></th>
                                      <th align="left" scope="col"> </th>
                                      <th align="left" scope="col"></th>
                                      <th scope="col">&nbsp;</th>
                                    </tr-->
                                                            <tr>
                                                                <td scope="col" width="17%">Code <input name="code" type="text" maxlength="100" value="<?php echo isset($objM->arrSearch['code'])?stripslashes($objM->arrSearch['code']):""?>" class="textbox"> </td>
                                                                <td scope="col" width="21%">Start Date<input name="datef" id="datef" type="text" value="<?php echo isset($objM->arrSearch['datef'])?stripslashes($objM->arrSearch['datef']):""?>" 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    : "datef",
                                                                            button        : "button1",
                                                                            ifFormat      : "%m/%d/%Y",       // format of the input field
                                                                            showsTime     : false,
                                                                            timeFormat    : "24"
                                                                        });
                                                                    </script>  </td>
                                                                <td scope="col" width="22%"> End Date <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="button2" name="button2"  class="button_stylenew" style=" width:30px;">
                                                                    <script type="text/javascript" language="javascript">
                                                                        Calendar.setup({
                                                                            inputField    : "date",
                                                                            button        : "button2",
                                                                            ifFormat      : "%m/%d/%Y",       // format of the input field
                                                                            showsTime     : false,
                                                                            timeFormat    : "24"
                                                                        });
                                                                    </script>   </td>
                                                                <td scope="col" width="16%">
                                                                <input name="imageField" type="image" class="nuller" src="../images/search.gif"  border="0">
                                                                <input style="background-color: #999; vertical-align: top;" class="add-btn" type="reset" name="ClearData" value="Clear Data">
                                                                <input type="hidden" name="SearchNow" value="SearchNow">
                                                                
                                                                </td>
                                                                <td align="right"><a href="freecode_report.php" class="add-btn">Free Code Report</a>&nbsp;
                                                                    <a href="manage_freecodes.php" class="add-btn">Add New Free Codes</a></td>
                                                            </tr>
                                                        </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 class="maintext2" align="center"><input type="checkbox" id="checkAll" name="checkAll" title="Check All / Uncheck All"/></th>
                                                                <th align="center" class="maintext2">#</td>
                                                                <th class="maintext2">Code<a href="freecodes.php?title=vCode&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                                                                <th class="maintext2">Start Date<a href="freecodes.php?title=dStart&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                                                                <th class="maintext2">End Date<a href="freecodes.php?title=dEnd&order=<?php echo $order == 'ASC' ? 'DESC' : 'ASC'?>"><?php echo $image ?></a></th>
                                                                <th class="maintext2" align="center">Action</strong></td>

                                                            </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['nFreeCode_Id']?>"></td>
                                                                <td width="2%" align="center" class="maintext2"><?php echo $key+1;?></td>
                                                                <td width="26%" class="maintext2"><?php echo htmlspecialchars(stripslashes($value['vCode']))?></td>
                                                                <td width="15%" class="maintext2"><?php echo date("m/d/Y",strtotime($value['dStart']))?></td>
                                                                <td width="15%" class="maintext2"><?php echo date("m/d/Y",strtotime($value['dEnd']))?></td>
                                                                <td width="9%" align="center" class="maintext2"><a href="manage_freecodes.php?id=<?php echo $value['nFreeCode_Id']?>&page=<?php echo $objP->getCurrentPageID()?>" class="signupbuttonlink">Edit</a></td>

                                                            </tr>
            <?php 			}//end foreach
        ?>
                                                                   <!--  <tr align="left">
                                                            <td align="center" class="maintext2">&nbsp;</td>
                                                            <td colspan="4" class="maintext2">&nbsp;</td>
                                                            <td align="center" class="maintext2"><input type="submit" name="DelNow" value="Delete" class="loginbutton"></td>
                                                          </tr>-->
        <?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>
                                                        <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');?>