/bbcsadmin/modules/tools/view-homebanners.php

<?
$ssql = "";

$alp = $_REQUEST['alp'];
$option = $_REQUEST['option'];
$keyword = $_REQUEST['keyword'];
if($_REQUEST['sortby'] == ''){
  $sortby = 1;
}else{
  $sortby = $_REQUEST['sortby'];
}
if($_REQUEST['order'] == ''){
  $order = 0;
}else{
  $order = $_REQUEST['order'];
}

if($option != '' && $keyword != ''){
    $ssql.= " AND ".stripslashes($option)." LIKE '%".stripslashes($keyword)."%'";
}

if($alp != ''){
    $ssql.= " AND vTitle LIKE '".stripslashes($alp)."%'";
}
if($sortby == 1){

  if($order == 0)
  $ord.= " order by vTitle ASC";
  else
  $ord.= " order by vTitle DESC";
}
// sortby 3 for dDate On

if($sortby == 3){ 
  if($order == 0)
  $ord.= " order by dDate ASC";
  else
  $ord.= " order by dDate DESC";
}
if($sortby == 4){ 
  if($order == 0)
  $ord.= " order by iDisplayOrder ASC";
  else
  $ord.= " order by iDisplayOrder DESC";
}
if($sortby == 5){ 
  if($order == 0)
  $ord.= " order by eStatus ASC";
  else
  $ord.= " order by eStatus DESC";
}
$sql = "SELECT iBannerId FROM home_banners  WHERE 1=1  $ssql $ord";	
$db_totrec = $obj->MySQLSelect($sql);


$num_totrec = count($db_totrec);

include(TPATH_CLASS_GEN."admin.paging.inc.php");

$sql = "SELECT iBannerId, vTitle, vImage, iDisplayOrder, dDate, eStatus, eType FROM home_banners WHERE 1=1 $ssql $ord $var_limit";	
$db_rec_all = $obj->MySQLSelect($sql);

if(!isset($start))
	$start = 1;
	$num_limit = ($start-1)*$rec_limit;
	$startrec = $num_limit;
	
	$lastrec = $startrec + $rec_limit;
	$startrec = $startrec + 1;
	if($lastrec > $num_totrec)
		$lastrec = $num_totrec;
		if($num_totrec > 0 )
		{
			$recmsg = "Showing ".$startrec." - ".$lastrec." Records Of ".$num_totrec;
		}
		else
		{
			$recmsg="No Records Found.";
		}

if(!count($db_rec_all)>0 && $keyword != ""){
	$var_msg_new = "Your search for <font color=#2e71b3>$keyword</font> has found <font color=#2e71b3>0</font> matches:";
}else if($keyword != ""){
	$var_msg_new = "Your search for <font color=#2e71b3>$keyword</font> has found <font color=#2e71b3>$num_totrec</font> matches:";
}else if($alp !=''){
    $var_msg_new = "Your search for <font color=#2e71b3>$alp</font> has found <font color=#2e71b3>$num_totrec</font> matches:";
}

$sql_alp = "select vTitle from home_banners where 1=1";
$db_alp = $obj->MySQLSelect($sql_alp);
for($i=0;$i<count($db_alp);$i++){
    $db_alp[$i] = strtoupper(substr($db_alp[$i]['vTitle'], 0,1));
}

$alpha_rs =implode(",",$db_alp);
$AlphaChar = @explode(',',$alpha_rs);
$AlphaBox.='<ul class="pagination">';
for($i=65;$i<=90;$i++){
	
	if(!@in_array(chr($i),$AlphaChar)){
		$AlphaBox.= '<li ><a href="#" onclick="return false;"  id="alch_'.$i.'">'.chr($i).'</a></li>';
	}else{
		$AlphaBox.= '<li class="page"><a  href="javascript:void(0);" onclick="AlphaSearch(\''.chr($i).'\');" id="alch_'.$i.'" >'.chr($i).'</a></li>';
	}
}
$AlphaBox.='</ul>';


$smarty->assign("db_rec_all",$db_rec_all);
$smarty->assign("AlphaBox",$AlphaBox);
$smarty->assign("recmsg",$recmsg);
$smarty->assign("var_msg",$var_msg);
$smarty->assign("keyword",$keyword);
$smarty->assign("option",$option);
$smarty->assign("page_link",$page_link);
$smarty->assign("var_msg_new",$var_msg_new);
$smarty->assign("sortby",$sortby);
$smarty->assign("order",$order);
?>