000

<?php
use Illuminate\Support\Facades\DB;

function prx($arr){
    echo "<pre>";
    print_r($arr);
    die();
}

function getTopNavCat() {
    // Fetch categories and their subcategories
    $categories = DB::table('categories')
        ->where(['status' => 1])
        ->get();
    
    $arr = [];
    foreach ($categories as $category) {
        $arr[$category->id]['CategoryName'] = $category->CategoryName;
        $arr[$category->id]['Category_Id'] = $category->id; // Assuming 'id' is the primary key
        // Fetch subcategories for this category
        $subcategories = DB::table('sub_category')
            ->where(['Category_Id' => $category->id, 'status' => 1])
            ->get();
        foreach ($subcategories as $subcategory) {
            $arr[$category->id]['subcategories'][] = [
                'Sub_Category_Name' => $subcategory->Sub_Category_Name,
                'Sub_Category_Id' => $subcategory->id, // Assuming 'id' is the primary key
            ];
        }
    }

// Initialize HTML variable
    $html = '<ul class="nav navbar-nav">';

// Home

// Shop
    $html .= '<li class="dropdown dropdown-slide">
                    <a href="#!" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-delay="350"
                            role="button" aria-haspopup="true" aria-expanded="false">All Category <span class="tf-ion-ios-arrow-down"></span></a>
                    <div class="dropdown-menu">
                        <div class="row">';
    foreach ($arr as $category) {
        $html .= '<div class="col-lg-6 col-md-6 mb-sm-3">';
        $html .= '<ul><li class="dropdown-header">' . $category['CategoryName'] . '</li>';
        if (isset($category['subcategories']) && !empty($category['subcategories'])) {
            foreach ($category['subcategories'] as $subcategory) {
                $url = url("/category/" . $subcategory['Sub_Category_Name']);
                $html .= '<li><a href="' . $url . '">' . $subcategory['Sub_Category_Name'] . '</a></li>';
            }
        }
        $html .= '</ul></div>';
    }
    $html .= '</div></div></li>';

// Pages

return $html;
}

function getAddToCartTotalItem(){
	if(session()->has('FRONT_USER_LOGIN')){
		$uid=session()->get('FRONT_USER_ID');
		$user_type="Reg";
	}else{
		$uid=getUserTempId();
		$user_type="Not-Reg";
	}
	$result=DB::table('cart')
            ->leftJoin('products','products.id','=','cart.product_id')
            ->leftJoin('products_attr','products_attr.id','=','cart.product_attr_id')
            ->leftJoin('sizes','sizes.id','=','products_attr.size_id')
            ->leftJoin('colors','colors.id','=','products_attr.color_id')
            ->where(['user_id'=>$uid])
            ->where(['user_type'=>$user_type])
            ->select('cart.qty','products.name','products.image','sizes.size','colors.color','products_attr.price','products.slug','products.id as pid','products_attr.id as attr_id')
            ->get();

return $result;
   
}

return json_encode(['status'=>$status,'msg'=>$msg,'totalPrice'=>$totalPrice,'coupon_code_value'=>$coupon_code_value]);
}

function getCustomDate($date){
	if($date!=''){
		$date=strtotime($date);
		return date('d-M Y',$date);
	}
}

function getAvaliableQty($product_id,$attr_id){
	$result=DB::table('orders_details')
            ->leftJoin('orders','orders.id','=','orders_details.orders_id')
			->leftJoin('products_attr','products_attr.id','=','orders_details.products_attr_id')
            ->where(['orders_details.product_id'=>$product_id])
            ->where(['orders_details.products_attr_id'=>$attr_id])
            ->select('orders_details.qty','products_attr.qty as pqty')
            ->get();

return $result;
}
?>