e60e81c4cbe5171cd654662d9887aec2

View file

File name : wholesale_functions.php
Content :
<?php
function generateRandomPassword() {
$chars = "ABCDEFGHJKLMNPQRSTUVWXYZ";
srand((double)microtime()*1000000);
$i = 0;
$randno = '' ;

while ($i < 6) {
$num = rand() % 24;
$tmp = substr($chars, $num, 1);
$randno = $randno . $tmp;
$i++;
}
return strtoupper($randno);
}
function getCategoryTree($cat_id,$array){

	  $array[]=$cat_id;

	  $parent=getParent($cat_id);

	  if($parent!=0){

		  $array[]=$parent;

	     return( getCategoryTree($parent,$array)); 

		   

	  }else{

		  $tree='';

		  if($array!=''){

		  $array=array_unique($array);

		  $array=array_reverse($array);

		  foreach($array as $key=>$val){

			  $tree= $tree.getMainCategory($val)." >>";

		  }

		  return( substr( $tree,0,-2));

		  }else{

			  return( 'Main Category');

			  }

	  }

	  		

}



function getCategoryIDTree($cat_id,$array){

	  $array[]=$cat_id;

	  $parent=getParent($cat_id);

	  if($parent!=0){

		  $array[]=$parent;

	     return( getCategoryIDTree($parent,$array)); 

		   

	  }else{

		  $tree='';

		  if($array!=''){

		  $array=array_unique($array);

		  $array=array_reverse($array);

		  //print_r($array);

		  foreach($array as $key=>$val){

			  $tree= $tree.$val.",";

		  }

		  return( substr( $tree,0,-1));

		  }else{

			  return( 'Main Category');

			  }

	  }

	  		

}





function getCategoryArray($cat_id,$array){

	  $array[]=$cat_id;

	  $parent=getParent($cat_id);

	  if($parent!=0){

		  $array[]=$parent;

	    return(  getCategoryArray($parent,$array)); 

		   

	  }else{

		  

		  $array=array_unique($array);

		  $array=array_reverse($array);

		  return($array);

	  }

	  		

}

function getMainParent($cat_id){

	$arr=getCategoryArray($cat_id,$array='');

	return ($arr[0]); 		

}

function getParent($pid){

	$sql=mysql_query("select parent_id from  wholesale_maincategory where id='$pid'");

	$result=mysql_fetch_assoc($sql);

	return ($result['parent_id']);

}

function getParentname($p_id){

	$sql=mysql_query("select maincategory from  wholesale_maincategory where id='$p_id'");

	$result=mysql_fetch_assoc($sql);

	return ($result['maincategory']);

}

function getgrandParent($p_id){

	$sql=mysql_query("select maincategory from  wholesale_maincategory where id='$p_id'");

	$result=mysql_fetch_assoc($sql);

	return ($result['maincategory']);

}

function getMainCategory($catid){

	$sql=mysql_query("select maincategory from  wholesale_maincategory where id='$catid'");
	
	$result=mysql_fetch_assoc($sql);

	return ($result['maincategory']);
}

function getDeliveryEstimate($cat_id){

	

	$sql=mysql_query("select min_days,max_days,dayshour from  tbl_deliveryestimate where cat_id='$cat_id'");

	$rs=mysql_fetch_assoc($sql);

	if($rs[min_days]==0 && $rs[max_days]==0 ){

	$str='';

	}else{

	$str="Typically delivered in ";

	if($rs[max_days]!=0){

	$str.=$rs[min_days]." - ".$rs[max_days];

	}else{

	$str.=$rs[min_days];	

	}
	$str.=" Business";
	
	if($rs[dayshour]==1){
		$str.=" Days";
	}else{
		$str.=" Hours";
	}
	
	$str.="";	

	}	

	

	return ($str);

}

function CalculateOrderTime($order_date){

	$order_time='';

$diff = abs(time() - strtotime($order_date));

$years = floor($diff / (365*60*60*24));

$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));

$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

$hours = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24)/ (60*60));

$minutes = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24-$hours*60*60)/ (60));

$seconds = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24-$hours*60*60-$minutes*60));

if($years>0){$order_time.=$years." Years ";}

if($months>0){$order_time.=$months." Months ";}

if($days>0){$order_time.=$days." Days ";}

if($hours>0){$order_time.=$hours." Hours ";}

if($minutes>0){$order_time.=$minutes." Min ";}

if($seconds>0){$order_time.=$seconds." Sec ";}



	$order_time.="  Ago ";

	return($order_time);

}

function OrderTimedifference($order_date,$order_date1){

	$order_time='';

$diff = abs(strtotime($order_date1) - strtotime($order_date));

$years = floor($diff / (365*60*60*24));

$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));

$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));

$hours = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24)/ (60*60));

$minutes = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24-$hours*60*60)/ (60));

$seconds = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 -$days*60*60*24-$hours*60*60-$minutes*60));

if($years>0){$order_time.=$years." Years ";}

if($months>0){$order_time.=$months." Months ";}

if($days>0){$order_time.=$days." Days ";}

if($hours>0){$order_time.=$hours." Hours ";}

if($minutes>0){$order_time.=$minutes." Min ";}

if($seconds>0){$order_time.=$seconds." Sec ";}



	$order_time.="  Ago ";

	return($order_time);

}

function getRewardPoints($user_id){

	

	$pointArr=mysql_query("select sum(reward_point) as credit from tbl_reward_history where user_id='".$user_id."' and type='Cr'");

	$rs=mysql_fetch_object($pointArr);

	$total_cr=$rs->credit;

	$pointArr=mysql_query("select sum(reward_point) as debit from tbl_reward_history where user_id='".$user_id."' and type='Dr'");

	$rs=mysql_fetch_object($pointArr);

	$total_dr=$rs->debit;

	$current_points=$total_cr-$total_dr; 

	return($current_points);

}

function getwallet($user_id){

	

	$pointArr=mysql_query("select sum(wallet_balance) as credit from tbl_wallet where user_id='".$user_id."' and type='Cr'");

	$rs=mysql_fetch_object($pointArr);

	$total_cr=$rs->credit;

	$pointArr=mysql_query("select sum(wallet_balance) as debit from tbl_wallet where user_id='".$user_id."' and type='Dr'");

	$rs=mysql_fetch_object($pointArr);

	$total_dr=$rs->debit;

	$current_balance=$total_cr-$total_dr; 

	return($current_balance);

}

function getwalletstore($user_id,$storeid){

	$pointArr=mysql_query("select sum(wallet_balance) as credit from tbl_wallet where user_id='".$user_id."' and storeid='".$storeid."' and type='Cr'");
	$rs=mysql_fetch_object($pointArr);

	$total_cr=$rs->credit;

	$pointArr=mysql_query("select sum(wallet_balance) as debit from tbl_wallet where user_id='".$user_id."' and storeid='".$storeid."' and type='Dr'");

	$rs=mysql_fetch_object($pointArr);

	$total_dr=$rs->debit;

	$current_balance=$total_cr-$total_dr; 

	return($current_balance);

}

function generateCouponCode() {

$chars = "ABCDEFGHJKLMNOPQRSRTUVWXYZ123456789";

srand((double)microtime()*1000000);

$i = 0;

$randno = '' ;



while ($i < 6) {

$num = rand() % 33;

$tmp = substr($chars, $num, 1);

$randno = $randno . $tmp;

$i++;

}

return strtoupper($randno);

}



function getYouTubeVideo($url){

$a=explode('v=',$url);

$b=explode('&',$a[1]);

return ("http://www.youtube.com/embed/".$b[0]);

}

function generateSlug($name,$tbl,$id){

	$newurl=str_replace(" - "," ",$name);

	$newurl=str_replace("&","",$newurl);

	$newurl=str_replace(","," ",$newurl);

	$myurl=str_replace("--","-",str_replace("%","",str_replace(" ","-",str_replace("-"," ",trim(str_replace("/"," ",str_replace(".","",$newurl)))))));

	$myurl=strtolower($myurl);

	$query=mysql_query("select id from $tbl where slug='$myurl' ");

	if(mysql_num_rows($query)>0){

        $myurl=$myurl.$id;

		mysql_query("update $tbl set  slug='$myurl'  where id='$id' ");

	}else{

		mysql_query("update $tbl set  slug='$myurl'  where id='$id' ");

	 }

	

}

function buildURL($url){

	$newurl=str_replace(" - "," ",$url);

	$myurl=str_replace("--","-",str_replace("%","",str_replace(" ","-",str_replace("-"," ",trim(str_replace("/"," ",str_replace(",","",str_replace(".","",$newurl))))))));

	return stripslashes(strtolower($myurl));

}

function parseInput($val) {

	return mysql_real_escape_string(stripslashes($val));

}

function encryptPassword($val) {

	return sha1($val);

}

function getAdminEmail(){

$sql=mysql_query("select email from tbl_admin  where id=1");

$result=mysql_fetch_assoc($sql);

return ($result['email']);

}

function getFieldWhere($filed,$tbl,$where,$id){

$sql=mysql_query("select $filed as field from $tbl  where $where='".$id."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['field']));	

}

function getTotalCredit($user_id){

$sql=mysql_query("select sum(credit_points) as tot_credit from tbl_credit_points  where user_id='".$user_id."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['tot_credit']));

} 



function getCategory($cat_id){

$sql=mysql_query("select * from tbl_category  where id='".$cat_id."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['category']));

} 

function getProductListingName($pname){

	$pname=stripslashes(trim($pname));

	/*$spos=strpos($pname," ");

	$pfname=substr($pname,0,$spos);

	$plname=substr($pname,$spos);

$pname="<span>".$pfname."</span><br>".$plname;*/

if(strlen($pname)>20){

	$pname=substr($pname,0,20)."..";

return(ucwords(strtolower($pname)));

}

return(ucwords(strtolower($pname)));

	

} 

function getSubcategory($cat_id){

$sql=mysql_query("select * from tbl_subcategory  where id='".$cat_id."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['subcategory']));

} 

function getFAQCategory($cat_id){

$sql=mysql_query("select * from tbl_faqcategory  where id='".$cat_id."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['faqcategory']));	

}

function getUser($uid){

$sql=mysql_query("select uname from tbl_user  where id='".$uid."'");

$result=mysql_fetch_assoc($sql);

return (stripslashes(ucfirst($result['uname'])));

} 

 

function getContent($title) {

$sql=mysql_query("select * from tbl_content where title='$title' ");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['content']));

}

function getField($filed,$table,$id) {

	

$sql=mysql_query("select $filed as field from $table where id='$id' ");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['field']));

}

function getFieldid($filed,$table,$id) {

	

$sql=mysql_query("select $filed as field from $table where id='$id' ");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['field']));

}

function getpriceField($filed,$table,$id) {

	

$sql=mysql_query("select $filed as field from $table where product_id='$id' ");

$result=mysql_fetch_assoc($sql);

return (stripslashes($result['field']));

}
function clearCache() {

	header("Cache-Control: no-cache, must-revalidate");

	header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

}

function redirect($url) {

	header("location:$url");

	exit();

}

function validateAdminSession() {

	if(trim($_SESSION["sess_admin_id"])=="" && trim($_SESSION["sess_admin_logged"])!="true") {

		$_SESSION["sess_msg"] = "Session expired. Please login again to continue";

		redirect("index.php");

	}

}

function showSessionMsg() {

	if(trim($_SESSION["sess_msg"])) {

		echo $_SESSION["sess_msg"];

		$_SESSION["sess_msg"] = "";

	}

}
function validate_user()

{

	if($_SESSION['sess_uid']=='')

	{

		ms_redirect("index.php?back=$_SERVER[REQUEST_URI]");

	}

}

function validate_admin()

{

	if($_SESSION['sess_admin_id']=='')

	{

		ms_redirect("index.php?back=$_SERVER[REQUEST_URI]");

	}

}

function ms_redirect($file, $exit=true, $sess_msg='')

{

	header("Location: $file");

	exit();

	

}
function sort_arrows($column){

	global $_SERVER;

	return '<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'asc')).'"><IMG SRC="images/white_up.gif" BORDER="0"></A> <A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'desc')).'"><IMG SRC="images/white_down.gif" BORDER="0"></A>';

}

function sort_arrows1($column){

	global $_SERVER;

	return '<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'asc')).'"><IMG SRC="simg/white_up.gif" BORDER="0"></A> <A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'desc')).'"><IMG SRC="simg/white_down.gif" BORDER="0"></A>';

}



function sort_arrows_front($column,$heading){

	global $_SERVER;

	return '<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'asc')).'"><img src="simg/sort_up.gif" alt="Sort Up" border="0" title="Sort Up"></A>&nbsp;'.$heading.'&nbsp;<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'desc')).'"><img src="simg/sort_down.gif" alt="Sort Down" border="0" title="Sort Down"></A>';

}

function sort_arrows_front1($column,$heading){

	global $_SERVER;

	return '<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'asc')).'"><img src="simg/sort_up.gif" alt="Sort Up" border="0" title="Sort Up"></A>&nbsp;'.$heading.'&nbsp;<A HREF="'.$_SERVER['PHP_SELF'].get_qry_str(array('order_by','order_by2'), array($column,'desc')).'"><img src="simg/sort_down.gif" alt="Sort Down" border="0" title="Sort Down"></A>';

}





function get_qry_str($over_write_key = array(), $over_write_value= array())

{

	global $_GET;

	$m = $_GET;

	if(is_array($over_write_key)){

		$i=0;

		foreach($over_write_key as $key){

			$m[$key] = $over_write_value[$i];

			$i++;

		}

	}else{

		$m[$over_write_key] = $over_write_value;

	}

	$qry_str = qry_str($m);

	return $qry_str;

} 



function qry_str($arr, $skip = '')

{

	$s = "?";

	$i = 0;

	foreach($arr as $key => $value) {

		if ($key != $skip) {

			if(is_array($value)){

				foreach($value as $value2){

					if ($i == 0) {

						$s .= "$key%5B%5D=$value2";

					$i = 1;

					} else {

						$s .= "&$key%5B%5D=$value2";

					} 

				}		

			}else{

				if ($i == 0) {

					$s .= "$key=$value";

					$i = 1;

				} else {

					$s .= "&$key=$value";

				} 

			}

		} 

	} 

	return $s;

} 

function getBusinessRating($id){
$sql=mysql_query("select avg(rating_score) as rating from tbl_rating  where status=1 and product_id='$id' ");
$result=mysql_fetch_assoc($sql);
return (stripslashes($result['rating']));
}

function cookiezip(){
	//if(!isset($_COOKIE[myvalue365zipcode])) {
	$zip=$_POST['zip'];
	if($_POST['submit']=='FIND STORES' || $_POST['go']=='Go'){
	$recstorequery=mysql_query("select storeid from wholesale_stores where status=1 and zip like '%".$zip."%'");
		if(mysql_num_rows($recstorequery)>0){
			$cookie_name = "myvalue365zipcode";
			$cookie_value = $_POST['zip'];
				setcookie($cookie_name, $cookie_value, time() + (86400 * 365) , "/"); // 86400 = 1 day
				$_SESSION['browserzipcode']=$cookie_value;
				 header("Location:".SITE_URL);
				 exit();
		} else {
			$_SESSION['zipcode-request']=$zip;
			header("Location:".SITE_URL."zipcode-error/$zip");
		}
			
	}
}

function rounder($num){
     $fln= $num-floor($num);
    if ($fln>0 and $fln<0.5){ $fln=0.49; }
    if ($fln>=0.5 and $fln<=0.99){ $fln=0.99; }

    return floor($num)+$fln;
    }

?>
Gel4y Mini Shell

View file
