santino

Please do not make an answear, I just figure it out and I cant cancel the question, end with this

        return $this->clientOrders()
        ->where(function (Builder $query) {
            return $query->where('signed', 0)
            ->orWhere('finished', 0);
        })
        ->get();

same as laravel documentation = https://laravel.com/docs/7.x/eloquent-relationships#querying-relations

Please do not make an answear, I just figure it out and I cant cancel the question, end with this

        return $this->clientOrders()
        ->where(function (Builder $query) {
            return $query->where('signed', 0)
            ->orWhere('finished', 0);
        })
        ->get();

same as laravel documentation = https://laravel.com/docs/7.x/eloquent-relationships#querying-relations

Hi, I am trying to use orWhere in this code ,

    public function clientOrders()
    {
        return $this->hasManyThrough(
            'App\Order',
            'App\UserProvider',
            'user_id', // Foreign key on UserProvider table...
            'portfolio_id', // Foreign key on User table...
            'id', // Local key on Order table...
            'id', // Foreign key on UserProvider table...
        );
    }


    public function clientOrdersOnReview()
    {
        return $this->clientOrders()->where( 'signed' , 0 );
    }

this code is working fine but I want to do something like this

     return $this->clientOrders()->where( 'signed' , 0 )->orWhere( 'finished' , 0 );

But it RETURNs all the orders from all the users....

I am trying to recreate this same laravel code

		return user()->clientOrders()
		->where('signed', 0)
		->orWhere('finished', 0)
		->get();

this return all the orders...

BUT it weird because I can do this double where

		return user()->clientOrders()
		->where('signed', 1)->where('finished', 0)
		->get();

and actually the code runs perfectly and makes the query!!! thanks for any help or hint

--------- AM ON WINDOWS 10 ----- Hi , I want to give a stupid solution... but some one can run into it, after trying to update to PHP 7.4.10 the last version, I uncomment and made A LOT OF THINGS... I was reading the files inside the PHP and just came out that there wasent a php.ini file so I copy the file called

php.ini-development -> to php.ini make a copy // I DID NOT HAVE THAT FILE!!! check your folder!!

copy and paste and rename it to php.ini ---------- this file was the one I modify , after that I re run all and that make the magic :) so --------- AM ON WINDOWS 10 ----- HOPE SOME ONE HELPS THIS

thanks Sr.

HOW to RETURN the attached object created?

return user()->providerConnections()->attach( $provider );

this code creates a new record on the database, but I can't return the object and I need it to know the actual ID created with this attachment, therefore make another action...

thanks in advance

GET THIS ERROR

Trying to get property 'pivot' of non-object

@bugsysha itt seems expensive, I mean each time a letter is typed , it made the charge... ? am correct?

I am using Nova, And I feel very good working with the search engine, and it's okay for me to use the same method of search on my front end BUT, I am wondering how I can get the same speed result?

How can I make the same but in my front end, I am new at this with laravel, I understand that I must do some queries with the SQL but HOW??

can you give me a hint? I think it's okay to go with Vue Axios call on real-time each time I type on the search bar??? thanks for the advice...

Hi, @bobbybouwmann I was just reading this post with your comments on it, and read this

Well Nova is using normal SQL queries to perform searches on your models

I am using Nova , And I feel very good working with the search engine, and its okay for me to use the same method of search on my front end BUT, I am wondering how I can get the same speed result?

How can I make the same but in my front end, I am new at this with laravel, I understand that I must do some queries with the SQL but HOW??

can you give me a hint? I think it's okay to go with Vue Axios call on real-time each time I type on the search bar??? thanks for an advice...

Just do the helper, like it, because you can call this inside the controller, I can't do it with the View facade, thanks!!

thanks you @michaloravec for your feedback on this matter! really appreciate it!

@michaloravec , Hi Michael, yes I haad been using the Auth::User() but don't you feel that is too much large to type it every time ... don't you feel its better to call

$user.......
$user->account
$user->profile
$user->wallet()

BUT - all this above dont have to been called before, just on the appProvider

I think it is faster to do it with the View facade, or what do you think?

Hi, laracast community I have been thinking about what's the best way to call a User in laravel projects, I think that there is no app if there is no USER , because you have the landing page where all are GUEST, But when we are really into the THING there must be a user, so my thoughts are that in all VIEWS and CONTROLLERS must be the instance of the USER , so in the app service provider I create this:

    public function boot()
    {
        View::composer( [ 'pages.*' ] , UserComposer::class );
    }

//// on UserComposer class got thiss

$view->with( 'user', Auth::user() );

So... now I can access all the pages to the instance $user, I want to have this instance in my controllers to... but I don't know how to do it, now I ask my self... This is the right way to do it? , I mean should I call this instance in the controllers too, and can be called in the MODELS?

I end up with this because I see that I have to call this Auth::user() in all the controller's methods and then in the view blade the same thing, so I want to know how do you manage this? whats the best way to affront this.

Very grateful to count with this excellent laracast forum community Thanks in advance for your feedback

Regards Santino

Found an exellent video of how to manage view composers

https://www.youtube.com/watch?v=7QWZxjgvEQc

very good video

use TERMINUS I use it is wonderful

https://packagecontrol.io/packages/Terminus

Mail::send(...)

if( count(Mail::failures()) > 0 ) {

   echo "There was one or more failures. They were: <br />";

   foreach(Mail::failures() as $email_address) {
       echo " - $email_address <br />";
    }

} else {
    echo "No errors, all sent successfully!";
}

Got this code from https://stackoverflow.com/questions/32882357/check-mail-is-sent-successfully-or-not-on-laravel-5

thanks @piljac1 I will do the modification base in this!

never mind, just got the answer, But if someone has a better way please point It out, thanks

		$products = collect( [
			Product::where('slug' , 'Client-Licence')->first(  ),
			Product::where('slug' , 'Provider-Licence')->first(  ),
] );

Or whats the way to create a new collection with this 2 models calling them by the slug? that's the other option but I don't know how to do it...

Hi, I want to know whats the best way to make this action, I am calling all the products of a model table like this and get this object model

return $products = Product::all();

[
{
"id": 1,
"icon": "fa fa-house-user",
"name": "Client Licence",
"slug": "Client-Licence",
"value": 25,
"income": 0.1,
"description": "A client Licence is an user that only can hire services on TradeLinn, also can upgrade his account to service provider or to Independent Distributor.",
"created_at": "2020-08-08T23:53:56.000000Z",
"updated_at": "2020-08-08T23:53:56.000000Z"
},
{
"id": 2,
"icon": "fa fa-house-user",
"name": "Distributor Licence",
"slug": "Distributor-Licence",
"value": 90,
"income": 0.45,
"description": "A Independent Distributor Licence is an user that can affiliate Clients, Service Providers and Independent Distributors, also can hire and offer services on TradeLinn",
"created_at": "2020-08-08T23:53:56.000000Z",
"updated_at": "2020-08-08T23:53:56.000000Z"
},
{
"id": 3,
"icon": "fa fa-users",
"name": "Provider Licence",
"slug": "Provider-Licence",
"value": 45,
"income": 0.25,
"description": "A Service Provider Licence is an user that can hire and offer services on TradeLinn, also can upgrade his account for Independent Distributor Licence.",
"created_at": "2020-08-08T23:53:56.000000Z",
"updated_at": "2020-08-08T23:53:56.000000Z"
},
{
"id": 4,
"icon": "fas fa",
"name": "new product",
"slug": "new-product",
"value": 43,
"income": 0.45,
"description": "soy un boton de pruebas",
"created_at": "2020-08-08T23:57:08.000000Z",
"updated_at": "2020-08-08T23:57:08.000000Z"
}
]

nothing fancy, it returns all the products , BUT now I want to remove all products EXEPT

Client-Licence - want to call this from its slug no from ID

Provider-Licence - want to call this from its slug no from ID

so what is the correct way to say like, okay got the collection now remove all exept->( 'slug' , Client-Licence )

Any help is well received

Regards Daniel

thanks @michaloravec !!!! really appreciate it

thanks so much for each one sharing an answer for this. I really appreciate it and helps a lot!

@snapey @martinbean @wilk_randall @jlrdw @deepu07 , thanks

@michaloravec... I understand, thank for helping me, look why this don't work?

Route:is('lesson', [$course->slug, $lesson->slug]) ...

@michaloravec , I end up with this and works, but is so damn ugly ... can you clean it?

	<a href="{{ route('lesson' , [ $course->slug , $lesson->slug ] ) }}" class="
		{{ request()->path() == 'courses/'.$course->slug ."/". $lesson->slug  ? 'text-primary font-weight-bold' : 'text-danger' }}
		">
		<i class="bx bxs-videos"></i>
		{{ $lesson->tittle }}
	</a>

Please I am trying to use

<a href="{{ route('lesson' , [ $course->slug , $lesson->slug ] ) }}" class="
	{{ Route::is('lesson', [ $course->slug , $lesson->slug ] ) ? 'text-primary font-weight-bold' : 'text-danger' }}
	">
	<i class="bx bxs-videos"></i>
	{{ $lesson->tittle }}
</a>

,y final URL is this one http://localhost:3000/courses/sopas-de-la-abuela-felices/gracias-por-venir

enter course name slug then lesson slug, and is the same but nothing happens the Route do not match...

This is inside a FOREACH because this render a list of links video lesson

MY SOLUTION WINDOWS 10 x 64 bits WAMP user with Laravel, after weeks of slow composer update and composer require

you need a thing called cacert.pem

https://curl.haxx.se/docs/caextract.html

then paste that file in your wamp main directory C:\wamp64\cacert.pem

then in the search tab search for php.ini open all the files with that name on sublime or any text editor

find a line called curl.cainfo and openssl.cafile

PUT YOUR PATH TO THIS FILE - see the example on my case:

curl.cainfo="C:\wamp64\cacert.pem"

and

openssl.cafile="C:\wamp64\cacert.pem"

do this on all the php.ini files you search before, in all the files!

OKAY RESTART SERVER that works for me, hope for you I wish someone before would make this comment! so I would not spend 2 weeks fixing it

I think this solves the problem because you need to match HTTPS with HTTPS communication, I think.... each time I run composer Update got the 60ERROR called no SSL so hope this helps someone

@martinbean , well I pass the user variable to the whole view because I think am inyecting an instance , But got a question each time I use Auth::user()->name am not calling the data base? or just hit an instance on the blade page, I mean I don't want to overload the calls to the server requesting the user on each view

What is the best way to manage this? just calling this way?

You are logged in as {{ Auth::user()->name }}

or with the view composer? thanks , Really appreciate it.

thanks @snapey and @martinbean , well is true better is this auth()->user()!!! thanks, both I just realize I can end up with this

        return view('pages.welcome', [
            'user' => auth()->user(),
            'page_title' => 'welcome',
            'page_description' => '• this is the main web page',
        ]  );

no compact just the variables with the data !! Thanks really appreciate the help

thanks, martin for the view composer, Am going to read about it!

Hi, some one can give me a hit with this...

    public function __construct()
    {
        $this->middleware('auth');
        $this->user = Auth::user();
    }

am trying to make a global variable of USER inside the controller, but I cant get any ressult

when I call this

 return $this->user; 

nothing happens if I call like this

return Auth::user();

I got the user... Some one know how to manage this?

the thing is I end up with this

    public function welcome()
    {

        $page_title = 'welcome';
        $page_description = '• this is the main web page';
        $user = Auth::user();
       // return $this->user;

        return view('pages.welcome', compact('page_title', 'page_description' , 'user'  ));

    }

BUT I DONT WANT TO CALL user auth::users on each single function to call each next pages... that is repeating and repeting

hope this helps someone :)

hope this helps someone :)

After spending a lot of time I end up exploring NOVA INLINE RELATIONSHIP

Thanks, people of KIRSCHBAUM DEVELOPMENT, This pack is mind-blowing if you are a programmer and you are reading this and you want a nested relationship, go with this pack is so awesome! , so easy to use and so damn goooooood!!!! love it - TAKE A TRY I RECOMMENDED for creating your resources and inside of it nest another resource inside that tab is so well done. Even you can sort order the tables

https://novapackages.com/packages/kirschbaum-development/nova-inline-relationship

woooooooowwwwwwwwwwww mennnnnnnn you did it!! @jlrdw thank you very much for taking some time on this!!, really appreciate it!!

I read all the post you reply to me and get the idea , and end with this

        $info = $curso->sections->first();

        $decoded = json_decode($info, true);

        dd($decoded["information"][0]["tittle"]);

thanks, that make the trick

come on @jlrdw men how can I get out this info with my own code...? // sorry for my response , its been like 8 hours trying to get it , and reading a lot on forums a no way getting a start, but after read all you post all makes sense

I use this code and get this

return $info = $curso->sections->first();

{
	"id": 1,
	"course_id": 1,
	"sort_order": 1,
	"tittle": "introduccion",
	"information": [
		{
		"tittle": "soy el titulo del video 1",
		"video": "432423"
		}
	],
	"created_at": "2020-07-09T01:53:48.000000Z",
	"updated_at": "2020-07-09T01:53:48.000000Z"
}

How to get information -> Tittle? thanks in advance

Protected $casts=[
		'information' =>'array'
	] ;

got this, I need to save the information as a text and then load it as an array, but how can I do it? am asking because I use this plugin with laravel novel

https://whitecube.github.io/nova-flexible-content/#/

this save the model as a text, but is a confusing json array don't have any idea how to decode...

this is the example on the format it save as a string

[{"layout":"information","key":"j8rMdCccjHHJI5ih","attributes":{"tittle":"asdfasfd","video":"234234"}},{"layout":"information","key":"X3ClC6W357d44kIC","attributes":{"tittle":"otro video","video":"aqui"}},{"layout":"information","key":"soBDv8tgqLuufYWR","attributes":{"tittle":"aewer","video":"wer"}}]

got another problem with this...

I use this to make information field an array,

Protected $casts=[
		'information' =>'array'
	] ;

all was perfect working excellent, but I am using laravel NOVA when it goes to save the information into this field as a string it does get a crash error because this got the cast array

So I comment it out, enter into the laravel view, changed the foreach from this

@foreach( $seccion->information as $info)

<div> {{ $info["attributes"]["tittle"] }}</div>

@endforeach

to this

@foreach(   explode( ',' , $seccion->information) as $info)

{{  $info }}

@endforeach

but now I can't get out the information of attributes tittle I get this long text...

[{"layout":"information" "key":"j8rMdCccjHHJI5ih" "attributes":{"tittle":"asdfasfd" "video":"234234"}} {"layout":"information" "key":"X3ClC6W357d44kIC" "attributes":{"tittle":"otro video" "video":"aqui"}} {"layout":"information" "key":"soBDv8tgqLuufYWR" "attributes":{"tittle":"aewer" "video":"wer"}}]

Do you know How I can get the information about these fields?? I got no idea thanks to @jamalroger @romain @jlrdw for helping me in this issue, I am new at this

O MY GOD!!! you are a genius @jamalroger this was making me crazy!!! dude!!!!!!! THANK A LOT REALLY APPRECIATE IT ALL DAY TRYING TO GET THE INFO

Thanks, Sr!!

and @romain thanks for your feed back Too

@romain @jamalroger Jussst add the model array cast, so now I don't nee do to convert to Json, but HOW I CAN ENTER INTO THE ARRAY I don't have access I don't know how to get any value...

can you teach me how??

@romain thankss look, I advance a bit , look I uses

json_decode($info);

got this

[
	{
		"layout": "information",
		"key": "phjxcw98rGBxz9TC",
		"attributes": {
		"tittle": "bienvenida",
		"video": "23483"
		}
	},
		{
		"layout": "information",
		"key": "2Wf2vWG0wMwdgkcy",
		"attributes": {
		"tittle": "ingredientes",
		"video": "1239891283"
		}
	},
		{
		"layout": "information",
		"key": "w0BOvHFBrUvkSatU",
		"attributes": {
		"tittle": "recomendaciones",
		"video": "12391283"
		}
	}
]

BUT CANT ACCESSS THE INFO,,,, HOW???? thanks in advance

HI, please I am trying to get out the information of this string

I save this string in a field of my data base

[{"layout":"information","key":"phjxcw98rGBxz9TC","attributes":{"tittle":"bienvenida","video":"23483"}},{"layout":"information","key":"2Wf2vWG0wMwdgkcy","attributes":{"tittle":"ingredientes","video":"1239891283"}},{"layout":"information","key":"w0BOvHFBrUvkSatU","attributes":{"tittle":"recomendaciones","video":"12391283"}}]

when I call this on a laravel view

{{ $seccion->information }}

got the information of the top, BUT HOW I CAN ENTER INTO attributes->tittle ???????????

Thanks in advance

after I create a record in a general resourse view, nova enters into it, I don't want to enter, I want to get back to the model general view, someone knows how to do it?

Hi community, please I want to implement sspatie ssortable pack but am tuck with this instruction

Usage

To add sortable behaviour to your model you must:

Implement the Spatie\EloquentSortable\Sortable interface. Use the trait Spatie\EloquentSortable\SortableTrait. Optionally specify which column will be used as the order column. The default is order_column. Example

Example
use Spatie\EloquentSortable\Sortable;
use Spatie\EloquentSortable\SortableTrait;



class MyModel extends Eloquent implements Sortable
{

    use SortableTrait;

    public $sortable = [
        'order_column_name' => 'order_column',
        'sort_when_creating' => true,
    ];
    
    ...
}

can you help?

https://github.com/spatie/eloquent-sortable

thanks

MY MODEL =

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Section extends Model
{

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

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



}

Thanks @michaelk That's the right solution, please the owner of the post MARK IT as ANSWER.

I want to include for laravel 7 if you don't have the command folder juts type

php artisan make:command ModelMake

That will creates @michaelk directory, copy its code and replace it on top of the created script.

@fam85 I am going to try Nova And will tell you the features of using it

thanks

thanks, Mr. @martinbean , much more clear, please I want to ask for Nova, Works as a CRUD service for my models Can you let me know if you have used it, if yes do you recommend it more than BackPack? am trying to figure out the best start for my project with the best tools on my hand

I really appreciate it, I will take very seriously your advice Regards Santino

Hi, Laracast community - Can someone that has use SPARK could share with me the benefits of using it? I understand that it got features like the subscriptions but want to know if that's it or If I am missing something

thanks in advance, am very new at this

@deepu07 Thanks for your response, I will check both - There are others called voyager , laravel admin, crud generator, what do you think about the others... Do you thing backPack is more complete Or why you use it? thanks a lot in advance Mr. @deepu07

Hi Laracast comunity , what to know some opinions about people that use Crud packages

Wish Pack do you thing is the best to implement in a new laravel proyect app?? an Why you use this Drud Package...??

thanks in advance this will help me a lot on my research