PHP 7.4.33
Preview: functions.php Size: 25.88 KB
/home/godevadmin/public_html/include/functions.php

<?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 = 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=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=mysqli_query($GLOBALS['conn'],"select parent_id from  tbl_maincategory where id='$pid'");



	$result=mysqli_fetch_assoc($sql);



	return ($result['parent_id']);



}



function getParentname($p_id){



	$sql=mysqli_query($GLOBALS['conn'],"select maincategory from  tbl_maincategory where id='$p_id'");



	$result=mysqli_fetch_assoc($sql);



	return ($result['maincategory']);



}



function getgrandParent($p_id){



	$sql=mysqli_query($GLOBALS['conn'],"select maincategory from  tbl_maincategory where id='$p_id'");



	$result=mysqli_fetch_assoc($sql);



	return ($result['maincategory']);



}



function getMainCategory($catid){



	$sql=mysqli_query($GLOBALS['conn'],"select maincategory from  tbl_maincategory where id='$catid'");

	

	$result=mysqli_fetch_assoc($sql);



	return ($result['maincategory']);

}



function getDeliveryEstimate($cat_id){



	



	$sql=mysqli_query($GLOBALS['conn'],"select min_days,max_days,dayshour from  tbl_deliveryestimate where cat_id='$cat_id'");



	$rs=mysqli_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=mysqli_query($GLOBALS['conn'],"select sum(reward_point) as credit from tbl_reward_history where user_id='".$user_id."' and type='Cr'");



	$rs=mysqli_fetch_object($pointArr);



	$total_cr=$rs->credit;



	$pointArr=mysqli_query($GLOBALS['conn'],"select sum(reward_point) as debit from tbl_reward_history where user_id='".$user_id."' and type='Dr'");



	$rs=mysqli_fetch_object($pointArr);



	$total_dr=$rs->debit;



	$current_points=$total_cr-$total_dr; 



	return($current_points);



}



function getwallet($user_id){



	



	$pointArr=mysqli_query($GLOBALS['conn'],"select sum(wallet_balance) as credit from tbl_wallet where user_id='".$user_id."' and type='Cr'");



	$rs=mysqli_fetch_object($pointArr);



	$total_cr=$rs->credit;



	$pointArr=mysqli_query($GLOBALS['conn'],"select sum(wallet_balance) as debit from tbl_wallet where user_id='".$user_id."' and type='Dr'");



	$rs=mysqli_fetch_object($pointArr);



	$total_dr=$rs->debit;



	$current_balance=$total_cr-$total_dr; 



	return($current_balance);



}



function getwalletstore($user_id,$storeid){



	$pointArr=mysqli_query($GLOBALS['conn'],"select sum(wallet_balance) as credit from tbl_wallet where user_id='".$user_id."' and storeid='".$storeid."' and type='Cr'");

	$rs=mysqli_fetch_object($pointArr);



	$total_cr=$rs->credit;



	$pointArr=mysqli_query($GLOBALS['conn'],"select sum(wallet_balance) as debit from tbl_wallet where user_id='".$user_id."' and storeid='".$storeid."' and type='Dr'");



	$rs=mysqli_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=mysqli_query($GLOBALS['conn'],"select id from $tbl where slug='$myurl' ");



	if(mysqli_num_rows($query)>0){



        $myurl=$myurl.$id;



		mysqli_query($GLOBALS['conn'],"update $tbl set  slug='$myurl'  where id='$id' ");



	}else{



		mysqli_query($GLOBALS['conn'],"update $tbl set  slug='$myurl'  where id='$id' ");



	 }



	



}



function buildURL($url){



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



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



	return stripslashes(strtolower($myurl));



}

function buildURLAlcohol($url) {



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



    $myurl = str_replace("--", "-", str_replace("?", "", str_replace("!", "", str_replace("&", "", str_replace("%", "", str_replace(" ", "-", str_replace("-", " ", trim(str_replace("/", " ", str_replace(",", "", $newurl))))))))));
     return stripslashes(strtolower($myurl));
}

function parseInput($val) {



	return mysqli_real_escape_string(stripslashes($GLOBALS['conn'],$val));



}



function encryptPassword($val) {



	return sha1($val);



}



function getAdminEmail(){



$sql=mysqli_query($GLOBALS['conn'],"select email from tbl_admin  where id=1");



$result=mysqli_fetch_assoc($sql);



return ($result['email']);



}



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



$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $tbl  where $where='".$id."'");



$result=mysqli_fetch_assoc($sql);



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



}



function getTotalCredit($user_id){



$sql=mysqli_query($GLOBALS['conn'],"select sum(credit_points) as tot_credit from tbl_credit_points  where user_id='".$user_id."'");



$result=mysqli_fetch_assoc($sql);



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



} 







function getCategory($cat_id){



$sql=mysqli_query($GLOBALS['conn'],"select * from tbl_category  where id='".$cat_id."'");



$result=mysqli_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=mysqli_query($GLOBALS['conn'],"select * from tbl_subcategory  where id='".$cat_id."'");



$result=mysqli_fetch_assoc($sql);



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



} 



function getFAQCategory($cat_id){



$sql=mysqli_query($GLOBALS['conn'],"select * from tbl_faqcategory  where id='".$cat_id."'");



$result=mysqli_fetch_assoc($sql);



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



}



function getUser($uid){



$sql=mysqli_query($GLOBALS['conn'],"select uname from tbl_user  where id='".$uid."'");



$result=mysqli_fetch_assoc($sql);



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



} 


function getSection($id){

$sql=mysqli_query($GLOBALS['conn'],"select section_id,parent_id from tbl_maincategory  where id='".$id."'");
$result=mysqli_fetch_assoc($sql);

if($result['section_id']==0)
{
    
$sql=mysqli_query($GLOBALS['conn'],"select section_id,parent_id from tbl_maincategory  where id='".$result['parent_id']."'");
$result=mysqli_fetch_assoc($sql);
return (stripslashes(ucfirst($result['section_id'])));
}
else
{
return (stripslashes(ucfirst($result['section_id'])));
}


} 

function clearlaravelcache($section,$parameter)
{
    $url = 'https://ormwebapi.quicklly.com/cache/'.$section.'/'.$parameter;

                           // Create a new cURL resource
                           $ch = curl_init($url);

                           // Setup request to send json via POST

                          // $payload =$data;

                          // Attach encoded JSON string to the POST fields
                         //curl_setopt($ch, CURLOPT_POSTFIELDS, $payload);

                          // Set the content type to application/json
                         curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type:application/json'));

                          // Return response instead of outputting
                         curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

                          // Execute the POST request
                   $result = curl_exec($ch);
}


 



function getContent($title) {



$sql=mysqli_query($GLOBALS['conn'],"select * from tbl_content where title='$title' ");



$result=mysqli_fetch_assoc($sql);



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



}



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



	



$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $table where id='$id' ");



$result=mysqli_fetch_assoc($sql);



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



}



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



	



$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $table where id='$id' ");



$result=mysqli_fetch_assoc($sql);



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



}



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



	



$sql=mysqli_query($GLOBALS['conn'],"select $filed as field from $table where product_id='$id' ");



$result=mysqli_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=mysqli_query($GLOBALS['conn'],"select avg(rating_score) as rating from tbl_rating  where status=1 and product_id='$id' ");

$result=mysqli_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=mysqli_query($GLOBALS['conn'],"select storeid from stores where status=1 and zip like '%".$zip."%'");

		if(mysqli_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 must_input($data) {

  $data = trim($data);

  $data = stripslashes($data);

  $data = htmlspecialchars($data);

  return $data;

}



function rounder($num){

     $fln= $num-floor($num);

    if ($fln>0.00 and $fln<0.1){ $fln=0.09; }

    if ($fln>0.10 and $fln<0.2){ $fln=0.19; }

	if ($fln>0.20 and $fln<0.3){ $fln=0.29; }

	if ($fln>0.30 and $fln<0.4){ $fln=0.39; }

	if ($fln>0.40 and $fln<0.5){ $fln=0.49; }

	if ($fln>0.50 and $fln<0.6){ $fln=0.59; }

	if ($fln>0.60 and $fln<0.7){ $fln=0.69; }

	if ($fln>0.70 and $fln<0.8){ $fln=0.79; }

	if ($fln>0.80 and $fln<0.9){ $fln=0.89; }

	if ($fln>0.90 and $fln<0.99){ $fln=0.99; }



    return floor($num)+$fln;

    }



function username($name){



if(strlen($name)>8){



	$name=substr($name,0,8)."..";



return(ucwords($name));



}



return(ucwords($name));



}

function CompressImage($source, $destination, $quality) {

		$info = getimagesize($source);

		if ($info['mime'] == 'image/jpeg') 
			$image = imagecreatefromjpeg($source);

		elseif ($info['mime'] == 'image/gif') 
			$image = imagecreatefromgif($source);

		elseif ($info['mime'] == 'image/png') 
			$image = imagecreatefrompng($source);

		imagejpeg($image, $destination, $quality);

		return $destination;
	}

//Get notification type
function getNotificationType(){

	$sql=mysqli_query($GLOBALS['conn'],"select * from  tbl_notification_type order by id");	
	while($result=mysqli_fetch_assoc($sql)) {
		$notification[]=$result;
	}
	return ($notification);
}
//Get notification type
function getAllCities(){

	$sql=mysqli_query($GLOBALS['conn'],"select * from  tbl_city order by city");	
	while($result=mysqli_fetch_assoc($sql)) {
		$cities[]=$result;
	}
	return ($cities);
}

//Method to get all ordered items details
function orderItemInfo($order_id) {
    $order_update = array();
    $sql = mysqli_query($GLOBALS['conn'],"select oi.order_id ,oi.product_id,oi.product_name,oi.qty,oi.sell_price,oi.order_status,oi.tracking_urls,oi.tracking_urls2,pp.in_stock,
	       ic_status.ic_status_val,ic_status.order_status from 
           insta_order_itmes oi join insta_productprice pp on oi.product_id=pp.product_id 
		   join insta_order_status ic_status on ic_status.id=oi.order_status
		   where oi.order_id ='$order_id' ");
    $resultItem=mysqli_fetch_assoc($sql);
    
		if(!empty($currStatus)) {
				$order_update["status"] = $currStatus;
			}else{
				$order_update["status"] = $resultItem['ic_status_val'];
			}
			//$order_update["tracking_urls"] = [$resultItem['tracking_urls']]; 
			
			$enyptOrderId = sha1($order_id);
			$instaMultiTrackUrl = "https://www.quicklly.com/qc-insta-track-order/".$order_id."/".$enyptOrderId;  
			$order_update["tracking_urls"] = [$instaMultiTrackUrl];  
    
    while($resultItem=mysqli_fetch_assoc($sql)) {

 
		if($resultItem['in_stock'] ==0 || $resultItem['in_stock'] ==NULL) {
            $itemId = $resultItem['product_id'];

            $order_update['updated_items'][] = [  // Optional if some items are not found. If blank all items assumed found
                "id"=> $resultItem['product_id'],
                "qty"=> $resultItem['qty'],
                "found_qty"=> $resultItem['qty'],
                "name"=> $resultItem['product_name'], // Name of the item
                "price"=>[
                "amount"=> $resultItem['sell_price'], // Amount in cents. Price the customers saw as  configured
                "currency"=> "USD", // Currency        
                ],
                "selected_option_groups"=> [],
            ];
        }  
        /*$sqlAddOn = mysqli_query($GLOBALS['conn'], "SELECT * FROM `insta_order_itmes_addon` where item_id ='$itemId' ");
        while($resultItemAddOn=mysqli_fetch_assoc($sqlAddOn)) {
        }*/
        if(count($order_update['updated_items']==0)) {
            $order_update['updated_items'] =array(); 
        }
	}
    return $order_update;
}
//Get notification frequency
function getNotificationFrequency(){

	$sql=mysqli_query($GLOBALS['conn'],"select * from  tbl_notification_frequency WHERE status=1 order by id");	
	while($result=mysqli_fetch_assoc($sql)) {
		$notification[]=$result;
	}
	return ($notification);
}
//Get notification frequency
function getAllStore(){

	$sql=mysqli_query($GLOBALS['conn'],"SELECT storeid,storename,state,city FROM `stores` where status=1 order by storename");	
	while($result=mysqli_fetch_assoc($sql)) {
		$storeList[]=$result;
	}
	return ($storeList);
}
function getAllSection(){

	$sql=mysqli_query($GLOBALS['conn'],"SELECT * FROM tbl_section WHERE status=1");	
	while($result=mysqli_fetch_assoc($sql)) {
		$sectionList[]=$result;
	}
	
	return ($sectionList);
}

function check_storefront_stock($productid, $order_from = 'quicklly')
{
	if($order_from == 'quickllygo')
	{
	  $qry = mysqli_query($GLOBALS['conn'],"SELECT stock_quantity FROM go_product tpd JOIN go_productprice tpr ON tpd.id = tpr.product_id where tpr.id = '$productid' ");
	}
	else if($order_from == 'instacart')
	{
	  $qry = mysqli_query($GLOBALS['conn'],"SELECT stock_quantity FROM go_product WHERE FIND_IN_SET($productid, insta_pids) ");
	}
	else 
	{
	  $qry = mysqli_query($GLOBALS['conn'],"SELECT stock_quantity FROM go_product WHERE FIND_IN_SET($productid, quicklly_pids) ");
	}
	
	$stock_quantity = 0;
  if(mysqli_num_rows($qry) > 0)
  {
		$data = mysqli_fetch_assoc($qry); 
		$stock_quantity = $data['stock_quantity'];
	}
  return 	$stock_quantity;
}


function coupon_source_name($id)
{
	
  $qry = mysqli_query($GLOBALS['conn'],"SELECT id,name FROM `coupon_source` where id=$id ");
	
  if(mysqli_num_rows($qry) > 0)
  {
		$data = mysqli_fetch_assoc($qry); 
		$cpName = $data['name'];
  }
  return 	$cpName;
}

function callAPI($method, $url, $data = false){
    
    $curl = curl_init();

    switch ($method)
    {
        case "POST":
            curl_setopt($curl, CURLOPT_POST, 1);

            if ($data)
                curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
            break;
        case "PUT":
            curl_setopt($curl, CURLOPT_PUT, 1);
            break;
        default:
            if ($data)
                $url = sprintf("%s?%s", $url, http_build_query($data));
    }

    // Optional Authentication:
    curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
    curl_setopt($curl, CURLOPT_USERPWD, "username:password");

    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);

    $result = curl_exec($curl);
    $result = json_decode($result);
    curl_close($curl);

    return $result;
}
?>





Directory Contents

Dirs: 1 × Files: 25

Name Size Perms Modified Actions
ckeditor DIR
- drwxrwxr-x 2023-11-07 20:00:00
Edit Download
649 B lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
649 B lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
4.71 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
4.10 KB lrwxrwxr-x 2025-01-22 14:39:16
Edit Download
3.97 KB lrwxrwxr-x 2023-11-22 20:59:28
Edit Download
4.04 KB lrwxrwxr-x 2024-02-22 09:17:20
Edit Download
73.66 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
46.75 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
1.79 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
1.79 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
69.77 KB lrwxrwxr-x 2023-11-07 19:59:58
Edit Download
11.18 KB lrwxrwxr-x 2023-11-18 00:41:42
Edit Download
25.88 KB lrwxrwxr-x 2025-12-08 14:24:06
Edit Download
14.21 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
4.54 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
43.90 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
6.63 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
554 B lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
3.36 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
3.28 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
1.08 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
3.35 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
2.18 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
2.39 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download
15.41 KB lrwxrwxr-x 2023-11-07 20:00:00
Edit Download

If ZipArchive is unavailable, a .tar will be created (no compression).