ethar

i used this and worked successfully, but i dont know if this way cause loading in database

        $orders=Orders::select('id','products_id','users_id','addresses_id','price','status')
            ->with('users:id,fname,lname,telno')
            ->with('products:id,name_ar,img')
            ->with(['address'=>function($q){
                $q->select('id','cities_id','address')->with('city:id,city_name_ar,price');
            }])
            ->paginate(20);

its not working

model function

    public function city(){
        return $this->hasManyThrough(
            'App\City',
            'App\Address'
        );
    }

controller function

    public function index()
    {
        $orders=Orders::select('id','products_id','users_id','addresses_id','price','status')
            ->with('users:id,fname,lname,telno')
            ->with('products:id,name_ar,img')
            ->with('address:id,cities_id,address')
            ->with('city:id,city_name_ar,price')
            ->paginate(20);
        return view('admin.orders.indexorder',compact('orders'));
    }

its not working,

sql error

 inner join `addresses` on `addresses`.`id` = `cities`.`addresses_id` 

but must be

inner join `addresses` on `addresses`.`cities_id` = `cities`.`id`

i have City Model (id,name),

and

Address Model (id,cities_id,users_id)

and

Orders Model (id,products_id,addresses_id).

in Orders Model i wrote this function to get city Name

    public function cities(){
        return $this->hasOneThrough(
            'App\City',
            'App\Address',
            'cities_id',
            'addresses_id',
            'id',
            'id'
        );
    }

but i got this error

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in field list is ambiguous (SQL: select `id`, `city_name_ar`, `price`, `addresses`.`cities_id` as `laravel_through_key` from `cities` inner join `addresses` on `addresses`.`id` = `cities`.`addresses_id` where `addresses`.`cities_id` in (1, 2, 3, 4))

@sinnbeck thanks but i replaced $product with $this, thanks working successfully.

I have product price, first I check if the deal exists will discount deal discount from product price, then check if a discount exists will apply the discount.

this work successfully, but I do this in blade file, any way to write this in model

@if($product->coupouns)
    {{number_format($product->price -( $product->price * $product->coupouns->discount / 100)) }}
@elseif($product->discount)
    {{number_format($product->price -( $product->price * $product->discount / 100)) }}
@else
    {{$product->price}}
@endif

from cookies, I get (item_id, item_qty), depend on item_id I make a select statement to return data,

I want to send item_qty with this statement to the blade

if(isset($_COOKIE["shopping_cart_panorama"])){
    $cookie_data = stripslashes($_COOKIE["shopping_cart_panorama"]);
    $cart_data=json_decode($cookie_data,true);
    $products=[];
    $qty=[];
    foreach ($cart_data as $key=>$values){
        array_push($products,$values['item_id']);
        array_push($qty,$values['item_qty']);//how send quantity with query result
    }
    $cart_product=Products::select('id','img', productName','price')
        ->whereIn('id',$products)
        ->where('active',1)
        ->get();
}
return view('front.cart',compact('cart_product'));

in the blade, I wat to show data get from the eloquent query, with the quantity of each product that comes from cookies

i try to get all product where id in array

 if(isset($_COOKIE["shopping_cart_panorama"])){
   $cookie_data = stripslashes($_COOKIE["shopping_cart_panorama"]);
   $cart_data=json_decode($cookie_data,true);
   $products=[];
   foreach ($cart_data as $key=>$values){
       $products=Products::select('id','img','slug_'.getLange().' as slug','name_'.getLange().' as productName','price')
                    ->where('active',1)
                    ->where('id',$values['item_id'])
                    ->take(5)
                    ->get();
            }
  return $products;
        }

but its return just first result (id)

{message: "Call to undefined function App\Http\Controllers\collec()", exception: "Error",…} exception: "Error" file: "C:\xampp\htdocs\site\panorama\app\Http\Controllers\HomeController.php" line: 106 message: "Call to undefined function App\Http\Controllers\collec()"

hi, I'm PHP developer, but newbie in Laravel, I used this code (Pure PHP), to store products in cookies,

if cookies not exist, will create it and store product_id, qty.
if cookies exist, will add product_id, qty to cookies.
if cookies exist and product_id exist, will update qty.

I want to ask if in laravel can improve or simplify this code

    public function addToCart($pid,$qty){
        if(isset($_COOKIE["shopping_cart_panorama"])){
            $cookie_data=stripslashes($_COOKIE["shopping_cart_panorama"]);
            $cart_data=json_decode($cookie_data,true);
        }else{
            $cart_data = array();
        }
        $item_id_list=array_column($cart_data,'item_id');
        if(in_array($pid,$item_id_list)){
            foreach ($cart_data as $keys => $values){
                if($cart_data[$keys]["item_id"] == $pid){
                    $cart_data[$keys]["item_qty"] = $cart_data[$keys]["item_qty"] + $qty;
                }
            }
        }else{
            $item_array = array(
                'item_id' => $pid,
                'item_qty' =>$qty,
            );
            $cart_data[] = $item_array;
        }
        $item_data = json_encode($cart_data);
        $setCookies = @setcookie('shopping_cart_panorama', $item_data, time() + (3600 * 24 * 30),"/");
    }

hi when user add the item to cookies its add successfully but when add another item its deleted old cookies and add just new item how to add the item to existing cookies

Cookie::queue(Cookie::make('product', $pid . "," . $qty, 3600));

hi i want to store product_id, quentity to Cookies, but not work public function addToCart($pid,$qty){ $data = [ ['pid'=>$pid, 'qty'=> $qty], ]; Cookie::queue(Cookie::make('product',$pid,3600)); }

and how check if pid is already exist

hi I used ajax to add the item to cart, but I got an error (Missing Parameter) any help

ajax code

        $('#button-cart').on('click', function () {
            var productId= $("#product_id").val();
            var qty= $("#input-quantity").val();
            $.ajax({
                headers: {
                    'X-CSRF-TOKEN': "{{ csrf_token() }}"
                },
                type:'get',
                data : { productId : productId, qty : qty },
                url:'{{ route('addtocard') }}',
                beforeSend: function () {
                    $('#button-cart').button('loading');
                },
                complete: function () {
                    $('#button-cart').button('reset');
                },
            })
        });

route file

Route::get('/addtocart/{productId}/{qty}', '[email protected]')->name('addtocard');

thanks @marianomoreyra for your reply but still not working

httpd-vhosts.conf file

# Use name-based virtual hosting.
#
NameVirtualHost *:80
#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ##ServerName or ##ServerAlias in any <VirtualHost> block.
#
##<VirtualHost *:80>
    ##ServerAdmin [email protected]
    ##DocumentRoot "C:/xampp/htdocs/dummy-host.example.com"
    ##ServerName dummy-host.example.com
    ##ServerAlias www.dummy-host.example.com
    ##ErrorLog "logs/dummy-host.example.com-error.log"
    ##CustomLog "logs/dummy-host.example.com-access.log" common
##</VirtualHost>

##<VirtualHost *:80>
    ##ServerAdmin [email protected]
    ##DocumentRoot "C:/xampp/htdocs/dummy-host2.example.com"
    ##ServerName dummy-host2.example.com
    ##ErrorLog "logs/dummy-host2.example.com-error.log"
    ##CustomLog "logs/dummy-host2.example.com-access.log" common
##</VirtualHost>

<VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs/site/hebron/public"
    ServerName hebron
    ServerAlias *.hebron.test
    <Directory "C:/xampp/htdocs/site/hebron/public">
        Options Indexes FollowSymLinks
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

<VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs/site/blog/public"
    ServerName blog
    ServerAlias *.blog.test
    <Directory "C:/xampp/htdocs/site/blog/public">
        Options Indexes FollowSymLinks
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

hosts file

# For example:
#
#      102.54.94.97     rhino.acme.com          # source server
#       38.25.63.10     x.acme.com              # x client host

# localhost name resolution is handled within DNS itself.
127.0.0.1           localhost
#::1                 localhost
127.0.0.1			 hebron.test
127.0.0.1			 blog.test

I used Laravel, Xampp in windows 10 I created a virtual host

<VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs/site/hebron/public"
    Servername hebron
    ServerAlias www.hebron.test
    <Directory "C:/xampp/htdocs/site/hebron/public">
        Options Indexes FollowSymLinks
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

in hosts file

127.0.0.1	hebron.test 

until now it's working perfectly, but when creating another one

<VirtualHost *:80>
    DocumentRoot "C:/xampp/htdocs/site/blog/public"
    Servername blog
    ServerAlias www.blog.test
    <Directory "C:/xampp/htdocs/site/blog/public">
        Options Indexes FollowSymLinks
        AllowOverride All
        Order allow,deny
        Allow from all
    </Directory>
</VirtualHost>

in hosts file

127.0.0.1 blog.test

the problem when visit blog.test , or hebron.test its redirect to same (hebron.test)

Hellow and welcome

plz how to check if URL has a parameter e.x http://panorama.test/en/cat or http://panorama.test/en/cat/1/data

I use optional id (1), slug(data), I want to check if id or slug exists in URL or not. how in controller make eloquent to get all data if id or slug not exist, how to get data related to id if id sent.

when i perform any of above commands I got

Mcamara\LaravelLocalization\Exceptions\SupportedLocalesNotDefined

Supported locales must be defined.

at C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalization.php:470 466| 467| $locales = $this->configRepository->get('laravellocalization.supportedLocales'); 468| 469| if (empty($locales) || !\is_array($locales)) {

470| throw new SupportedLocalesNotDefined(); 471| } 472| 473| $this->supportedLocales = $locales; 474|

1 C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalization.php:141 Mcamara\LaravelLocalization\LaravelLocalization::getSupportedLocales()

2 C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalizationServiceProvider.php:55 Mcamara\LaravelLocalization\LaravelLocalization::__construct()

when i perform any of above commands I got

Mcamara\LaravelLocalization\Exceptions\SupportedLocalesNotDefined

Supported locales must be defined.

at C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalization.php:470 466| 467| $locales = $this->configRepository->get('laravellocalization.supportedLocales'); 468| 469| if (empty($locales) || !\is_array($locales)) {

470| throw new SupportedLocalesNotDefined(); 471| } 472| 473| $this->supportedLocales = $locales; 474|

1 C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalization.php:141 Mcamara\LaravelLocalization\LaravelLocalization::getSupportedLocales()

2 C:\xampp\htdocs\site\panorama\vendor\mcamara\laravel-localization\src\Mcamara\LaravelLocalization\LaravelLocalizationServiceProvider.php:55 Mcamara\LaravelLocalization\LaravelLocalization::__construct()

hi after install Mcamara Package i got this Error Mcamara\LaravelLocalization\Exceptions\SupportedLocalesNotDefined Supported locales must be defined.

any solution to solve this problem

products table have forieng_key brands_id, every product related to one brand. i make the relation but in select product with brands I got error Call to undefined relationship [brands] on model [App\Products].

productsModel

class Products extends Model{
    protected $table = 'products';
    protected $fillable = [
        'cats_id','brands_id','name_ar','name_en','slug_ar','slug_en','tags_ar','tags_en','code','qty','color' 'size','price','copouns_id','discount','video','hot_deal','img','sm_img','active','admins_id','discription' ];

    public function brands(){
        return $this->belongsTo('App\Brands');
    }
}

BrandsModel

class Brands extends Model
{
    protected $table = 'brands';
    protected $fillable = [
        'brands_name_ar','brands_name_en', 'slug_ar', 'slug_en', 'photo', 'active', 'admin_id'
    ];
    public function products(){
        return $this->hasMany('App\Products');
    }

}

ProductsController

    public function index(){
        $product = Products::select('id','name_ar','qty','code','price','img','active','admins_id','brands_id')
            ->with('brands:id,brands_name_ar')
            ->orderBy('id','DESC')->paginate(20);
        return view ('admin.product.indexproduct',compact('product'));
    }

plz how get products with brand related to it

i use class.upload.php to upload files in laravel using ajax I try to upload multi-file ajax code

$("#uploadMultiFiles").change(function () { var formData = new FormData(); var filesLength=document.getElementById('uploadMultiFiles').files.length; for(var i=0;i<filesLength;i++){ formData.append('file[]',document.getElementById("uploadMultiFiles").files[i].name); } $.ajax({ headers: { 'X-CSRF-TOKEN': "{{ csrf_token() }}" }, url: "{{ route('uploadfiles') }}", method: "POST", data: formData, processData: false, contentType: false, cache: false, }); }); laravel upload function public function upload(Request $request){

    $files = array();
    $f=$request->file;
    foreach ($_files['file'] as $k => $l) {
        foreach ($l as $i => $v) {
            if (!array_key_exists($i, $files))
                $files[$i] = array();
            $files[$i][$k] = $v;
        }
    }

    foreach ($files as $file) {
        $handle = new \Verot\Upload\Upload($file);
        if ($handle->uploaded) {
            $handle->process(public_path('images').'/cats/');
            if ($handle->processed) {
                return $handle->file_dst_name;
            } else {
                return 'error : ' . $handle->error;
            }

        } else {
            return 'Error: Error Here Cn Do Any Things' . $handle->error;
        }
        unset($handle);
    }
}

i got error Undefined index: file" I TRY TO USE

i got this error "Invalid argument supplied for foreach()"

when i print dd(($request->file) uploaded file printed successfully

thanks

this means I must create a new function to determine Limit, there is another way to do it from eloquent

Track Model

    public function Course(){
        return $this->hasMany('App\Course');
    }

Course Model

    public function Track(){
        return $this->belongsTo('App\Track');
    }

eloquent Code

$track=Track::select('id','track_name')->with(['Course'=>function($q){
    $q->select('id', 'course_title', 'track_id', 'link', 'num_student','status')->orderBy('id','DESC')->take(4);
}])->orderBy('id','DESC')->take(4)->get();

I want to retrieve track and course if the track has a course when I use has that gives me an error

Thx

in example i want to get Tracks, if (Tracks have Course), plz how do that

$track=Track::select('id','track_name')->with(['Course'=>function($q){
    $q->select('id', 'course_title', 'track_id', 'link')->where('status',1)->orderBy('id','DESC')->limit(4);
}])->orderBy('id','DESC')->limit(4)->get();

i try to use whereHas but dosent work

hi i want to get just 4 Course, but this code not working, working just on Track

$track=Track::select('id','track_name')->with(['Course'=>function($q){
      $q->select('id', 'course_title', 'track_id', 'link')->where('status',1)->orderBy('id','DESC')->limit(4);
}])->orderBy('id','DESC')->limit(4)->get();