/bbcsadmin/modules/tools/view-homebanners.php
PHP | 119 lines | 101 code | 17 blank | 1 comment | 41 complexity | 0c25eb630ffcf201e1693bd927de18a1 MD5 | raw file
- <?
- $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);
- ?>