<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
// +----------------------------------------------------------------------+
// | PHP version 4/5                                                      |
// +----------------------------------------------------------------------+
// | This source file is a part of iScripts Multicart                     |
// +----------------------------------------------------------------------+
// | Authors: Programmer<programmer@armia.com>        		              |
// +----------------------------------------------------------------------+
// | Copyrights Armia Systems, Inc and iScripts.com � 2005                |
// | All rights reserved                                                  |
// +----------------------------------------------------------------------+
// | This script may not be distributed, sold, given away for free to     |
// | third party, or used as a part of any internet services such as      |
// | webdesign etc.                                                       |
// +----------------------------------------------------------------------+
?>
<?php
include "../includes/config.php";
include "../includes/session.php";
include "../includes/functions.php";

if (isset($_SESSION["sess_adminname"]) and $_SESSION["sess_adminname"] != "") {
    $adminname = $_SESSION["sess_adminname"];
} else {
    header("Location:login.php");
    exit;
}


if ($_GET["begin"] == "") {
    $begin = 0;
    $num = 1;
    $numBegin = 1;
}

if (isset($_GET["txtSearch"]) and $_GET["txtSearch"] != "") {
    $txtSearch = $_GET["txtSearch"];
    $cmbSearchType = $_GET["cmbSearchType"];
} else if (isset($_POST["txtSearch"]) and $_POST["txtSearch"] != "") {
    $txtSearch = $_POST["txtSearch"];
    $cmbSearchType = $_POST["cmbSearchType"];
}


/* ---------Patch----------- */


if (isset($_GET['msg'])) {
    $message = OPTION_UPDTD."!!";
}
if ($_GET["msg1"]) {
    $message = $_GET["msg1"];
}

/* ---------Patch----------- */

if ($_GET['delete_permanent'] == 'Y') {

    //check whether option is assigned to a category
    $query_assigned_check = "SELECT category_option_id,category_id FROM " . $tableprefix . "category_options WHERE option_id = '" . $_GET['del_id'] . "'";
    //echo $query_assigned_check;
    $query_assigned_checkR = mysql_query($query_assigned_check);

    /////////////////////////////////////////////////////////////////modification on 04012013 starts
    $query_assigned_checkR1 = mysql_query($query_assigned_check);
    $optionCat = array();
    if (mysql_num_rows($query_assigned_checkR1) > 0) {
        while ($row = mysql_fetch_array($query_assigned_checkR1)) {
            $optionCat[] = $row['category_id'];
        }
    }
    $optionsList = implode(',', $optionCat);

    //check if products are assigned to any categories containing this option;
    $checkSql = "SELECT product_id FROM " . $tableprefix . "products WHERE product_category IN (" . $optionsList . ") AND deleted = 'N' ";

    $checkRes = mysql_query($checkSql);

    if (mysql_num_rows($checkRes) > 0) { //if yes,restrict delete option
        header('Location:options.php?msg1=Sorry, This Option is already assigned to some category which has products !!');
    } else {
        $delete_options = "DELETE FROM " . $tableprefix . "options WHERE option_id = " . $_GET['del_id'];
        mysql_query($delete_options) or die(mysql_error());
        header('Location:options.php?msg1=Option is deleted successfully !!');
    }
    /////////////////////////////////////////////////////modification on 04012013 ends
}

if (isset($_POST['gotoPage'])) {

    header("Location:" . $_SERVER['PHP_SELF'] . "?page=" . $_POST['gotoPage']);
}

$qryopt = "";
if ($txtSearch != "") {

    $qryopt .= "  AND option_name  like '" . addslashes($txtSearch) . "%'";
}
$sql = " SELECT * FROM " . $tableprefix . "options WHERE 1=1 " . $qryopt . " ORDER BY option_id DESC ";

if (!(isset($pagenum))) {
    $pagenum = 1;
}

$limit = getSettingsValue('npagination_limit');

$page = isset($_GET['page']) ? trim($_GET['page']) : 1;


$page = $_GET['page'];

if (empty($page)) {
    $page = 1;
}

$result = mysql_query($sql) or die(mysql_error());

$totalrows = mysql_num_rows($result);

$limitvalue = ($page - 1) * $limit;

$query_string = " LIMIT $limitvalue, $limit";

$sql = $sql . $query_string;

$rs = mysql_query($sql) or die(mysql_error());

$numofpages = ceil($totalrows / $limit);

include "../includes/htmltop.php";
?>
<script language="JavaScript" type="text/JavaScript">
    function clickSearch()
    {

        var form_name = new Array('txtSearch');
        var display_name = new Array('Option Name');
        var count = 1;

        if(check_fields('frmOption',form_name,display_name,count))
        {

            document.frmOption.submit();

        }
        else
        {

            return false;

        }

    }
    function deleteOption()
    {

        return confirm('<?php echo ARE_YOU_SURE_DEL_OPT;?>')

    }
</script>
<body>
<center>
    <div align="left" id="layout">
        <!--header area start -->
        <?php
        include_once("../includes/topheader_admin.php")
        ?>
        <!--header area end -->
        <div align="left" class="main_body">
            <!--main body start -->
            <?php
            include_once("../includes/admintopmenu.php")
            ?>
            <div align="left" class="content_area">
                <!--content area start -->
                <div align="left" class="page_title"><?php echo OPTIONS;?></div>
                <div align="center" class="text_information grey_tr"><?php echo $message ?></div>
                <br>
                <div align="left">
                    <form action="" method="get" name="frmOption">
                        <table width="100%" border="0" cellpadding="0" cellspacing="0" class="manage_top">
                            <tr>
                                <td width="75%" align="left" valign="middle" class=''><?php echo SEARCH_OPTNAME;?>
                                    <input type="text" name="txtSearch" size="20" maxlength="50" value="<?php echo(htmlentities($txtSearch)); ?>" class="textarea">
                                    &nbsp;
                                    <a onClick="return clickSearch();" class="search_button"><?php echo BTN_SEARCH; ?></a>
                                </td>
                                <td align="right"><a href="optionsadd.php?form_id=1" style="cursor:pointer" class="add_new_button"><?php echo BTN_ADD_NEW; ?></a></td>
                            </tr>
                        </table>
                    </form>
                </div>
                <div align="left">
                    <form action="" method="post" name="frmOption1">
                        <table width="100%" border="0" cellpadding="0" cellspacing="0" class="manage_table">
                            <tr class="form_header">
                                <th width="4%" align="left">#</th>
                                <th width="74%" align="left" class=""><?php echo OPTION_NAME;?></th>
                                <th width="22%" align="left"><?php echo ACTION;?></th>
                            </tr>
                            <?php
                            if (mysql_num_rows($result) > 0) {
                                $i = 1;

                                while ($row = mysql_fetch_array($rs)) {
                                    ?>
                                    <tr class="">
                                        <td><?php echo (($page * $limit) + $i - $limit) ?></td>
                                        <td align="left"><?php echo htmlentities($row["option_name"]) . "</a>"; ?></td>
                                        <td align="left">
                                            <a href="optionsedit.php?edit_id=<?php echo $row["option_id"] ?>&qstring=<?php echo $_SERVER['QUERY_STRING'] ?>"><img src="../images/btn_edit.gif" border="0" title="<?php echo TITLE_EDIT_OPTION; ?>"></a>&nbsp;/&nbsp;<a href="options.php?del_id=<?php echo $row["option_id"] ?>&delete_status=&delete_permanent=Y" style="cursor:pointer" onClick="return deleteOption()"><img src="../images/btn_del.gif" border="0" title="<?php echo TITLE_DELETE_OPTION; ?>"></a>&nbsp;
                                        </td>

                                    </tr>
                                    <?php
                                    $i++;
                                }
                            } else {
                                ?>
                                <tr>
                                    <td align="center" valign="middle" colspan="3"  class="text_information"><?php echo NO_RECORDS_FOUND;?></td>
                                </tr>
                                <?php
                            }
                            if ($page > 1) {
                                $pageprev = $page - 1;

                                $previous_page = "<a href=" . $_SERVER['PHP_SELF'] . "?page=$pageprev alt='Previous' border='0' class='small_gray_button'>prev</a>";
                            }

                            if ($page < $numofpages) {
                                $pagenext = ($page + 1);

                                $next = "<a href=" . $_SERVER['PHP_SELF'] . "?page=$pagenext alt='Next' border='0' class='small_gray_button'>next</a>";
                            }
                            ?>
                            <tr>
                                <td class="page_nos"  align="center">&nbsp;</td>
                                <td align="right" valign="middle" class="page_nos">&nbsp;</td>
                                <td align="left" class="btn_gotbl" valign="middle">&nbsp;</td>
                            </tr> <?php
                            if ($page < $numofpages || $page > 1) {
                                ?>
                                <tr>
                                    <td colspan="3"  align="center">
									<table width="100%" border="0" cellspacing="10" cellpadding="0">
										<tr align="left" valign="middle">
											<td width="21%" align="right"><?php echo $previous_page ?></td>
											<td width="23%" align="right">
												<?php echo PAGE."(".S.")";?> <?php echo $page ?>/<?php echo $numofpages ?>&nbsp;&nbsp;
												<?php echo GO_TO;?>
											</td>
											<td width="8%" align="right">
												<select class="textarea2" name="gotoPage" style="padding:4px 5px; margin-bottom:1px; ">
													<?php
													for ($i = 1; $i <= $numofpages; $i++) {
													if ($i == $_GET['page']) {
													$page_selected = "selected";
													} else {
													$page_selected = "";
													}
													?>
													<option value="<?php echo $i ?>" <?php echo $page_selected ?>><?php echo $i ?></option>
													<?php
													}
													?>
												</select>
											</td>
											<td width="7%">
												<a onClick="Javascript:document.frmOption1.submit();" class="go_button_2">Go</a>
											</td>
											<td width="41%" align="center"><?php echo $next ?></td>
										</tr>
									</table>
								  </td>
                               </tr>
                                <?php
                            }
                            ?>
                        </table>
                    </form>
                </div>
                <!--content area end-->

            </div>
            <div align="left" class="clear_float"><img src="<?php echo $imagefolder; ?>/clear.gif" alt="" width="1" height="1" /></div>
            <!--main body end -->
        </div>


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