<?
require_once("../includes/dbsmain.inc.php");

if(is_post_back()) {
$arr_ids = $_REQUEST['arr_ids'];
if(is_array($arr_ids)) {
$str_ids = implode(',', $arr_ids);
if(isset($_REQUEST['Delete']) || isset($_REQUEST['Delete_x']) ) {
db_query("delete from tbl_enquiry where enquiry_id	 in ($str_ids)");
} else if(isset($_REQUEST['Activate']) || isset($_REQUEST['Activate_x']) ) {
db_query("update tbl_enquiry set mailed_status = 'Active' where enquiry_id	 in ($str_ids)");
} else if(isset($_REQUEST['Deactivate']) || isset($_REQUEST['Deactivate_x']) ) {
db_query("update tbl_enquiry set mailed_status = 'Inactive' where enquiry_id	 in ($str_ids)");
}
}
header("Location: ".$_SERVER['HTTP_REFERER']);
exit;
}




$start = intval($start);
$pagesize = intval($pagesize)==0?$pagesize=DEF_PAGE_SIZE:$pagesize;

$order_by == '' ? $order_by = 'enquiry_id	' : true;
$order_by2 == '' ? $order_by2 = 'desc' : true;

$sql = "select * from tbl_enquiry   where 1 and enquiry_type='Wholesale Enquiry'  ";
$sql = apply_filter($sql, $enquiry_name, 'like','enquiry_name');
$sql .= " order by $order_by $order_by2 ";
$sql .= " limit $start, $pagesize ";

$pager = new midas_pager_sql($sql, $pagesize, $start);
if($pager->total_records) {
$result = db_query($sql);
}

?>
<link href="styles.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/javascript" src="../includes/general.js"></script>
<? include("top.inc.php");?>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="pageHead"><div id="txtPageHead"> Wholesale Enquiry List </div></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td id="content"><form method="get" name="form2" id="form2" onSubmit="return confirm_submit(this)">
                    <br />
                    <table  border="0" width="300px;" align="center" cellpadding="3" cellspacing="0" class="tableSearch">
                      <tr align="center">
                        <th colspan="2">Search</th>
                      </tr>
                      <tr>
                        <td class="tdLabel"> Name</td>
                        <td><input name="enquiry_name" type="text" value="<?=$enquiry_name?>" size="40" /></td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td><input name="pagesize" type="hidden" id="pagesize" value="<?=$pagesize?>" />
                          <input type="image" name="imageField" src="images/buttons/search.gif" /></td>
                      </tr>
                    </table>
                  </form>
                  <br />
                  <div align="right"> </div>
                  <? if($pager->total_records==0) {?>
                  <div class="msg">Sorry, no records found.</div>
                  <? } else { ?>
                  <div align="right">
                    <? $pager->show_displaying()?>
                  </div>
                  <div>Records Per Page:
                    <?=pagesize_dropdown('pagesize', $pagesize);?>
                  </div>
                  <form method="post" name="form1" id="form1" onSubmit="confirm_submit(this)">
                    <table width="100%"  border="0" cellpadding="0" cellspacing="1" class="tableList">
                      <tr>
                        <th width="15%" nowrap="nowrap"> Name</th>
                        <th width="15%" nowrap="nowrap">Email-id</th>
                        <th width="10%" nowrap="nowrap">Mobile</th>
                        <th width="25%" nowrap="nowrap"> Message </th>
                        <th width="8%" nowrap="nowrap"> Date
                          <?=sort_arrows('enquiry_recve_date')?></th>
                        <?php /*?> <th width="7%" nowrap="nowrap"> Status  <?=sort_arrows('enquiry_status')?></th><?php */?>
                        <th width="4%"><input name="check_all" type="checkbox" id="check_all" value="1" onClick="checkall(this.form)" /></th>
                      </tr>
                      <?
while ($line_raw = mysqli_fetch_array($result)) {
$line = ms_display_value($line_raw);
@extract($line);

$css = ($css=='trOdd')?'trEven':'trOdd';
?>
                      <tr class="<?=$css?>" valign="top">
                        <td nowrap="nowrap" align="center"><?=$enquiry_name?></td>
                        <td nowrap="nowrap" align="center"><?=$enquiry_email?></td>
                        <td nowrap="nowrap" align="center"><?=$enquiry_mobile?></td>
                        <td align="center"><?=$enquiry_message?></td>
                        <td nowrap="nowrap" align="center"><?=$enquiry_recve_date?>
                          <?php /*?><br /><a href='javascript:;' onClick="window.open('message-reply.php?reply_id=<?=$enquiry_id?>','_blank','toolbar=no,menubar=no,scrollbars=yes,resizable=1,height=650,width=650');"><strong>Reply</strong></a><?php */?></td>
                        <?php /*?><td nowrap="nowrap" align="center"><strong><?=$enquiry_status?></strong></td><?php */?>
                        <td align="center"><input name="arr_ids[]" type="checkbox" id="arr_ids[]" value="<?=$enquiry_id?>" /></td>
                      </tr>
                      <? } ?>
                    </table>
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td align="right" style="padding:2px"><!--input type="submit" name="Activate" value="Activate" class="button"/-->
                          <!--input type="submit" name="Deactivate" value="Deactivate" class="button" /-->
                          <input type="submit" name="Delete" value="Delete" class="button" onClick="return select_chk()" style="font-size:12px; font-weight:bold; height:26px; background-color:#CA0000; border-radius:4px; cursor:pointer; width:100px;"/>
                        </td>
                      </tr>
                    </table>
                  </form>
                  <? $pager->show_pager();?>
                  <? } ?>
                </td>
              </tr>
            </table>
            <? include("bottom.inc.php");?>
<script language="javascript">
function select_chk(){
			var chks = document.getElementsByName('arr_ids[]');
			var hasChecked = false;
			for (var i = 0; i < chks.length; i++){
			if (chks[i].checked){
				hasChecked = true;
				break;
				}
			}
			if (hasChecked == false){
			alert("Please Select At Least One.");
			return false;
			}
}
</script>