DEV Community: mostafalaravel

Laravel local scopes: easy, simple and clear.

mostafalaravel — Fri, 12 Mar 2021 13:41:34 +0000

Scopes allow you to define prebuilt scopes(filters) that you can use either every time your query a model with a specific method chain (Local Scope).

Let's take this example:

$newBlackCars = Car::where('type' , 'like' , 'manual')->where('color' , 'like' , 'black')->get();

The request above will return all black cars where the type is manual.

But what if we could make it more simple and shorter?

Something like:

$blackManualCars = Car::blackManuals()->get();

Yes we can! Thanks to the local scope :

class Car
{
    public function scopeBlackManuals($query){
          return $query->where('type' , 'like' , 'manual')->where('color' , 'like' , 'black')->get();
    }

To define a local scope, we add a method to the Eloquent class that begins with scope then the title-cased version of the scope name. Also as you can see this method is passed a query builder that you can modify before returning and of course needs to return a query builder.

Also, It's possible to define scope that accept parameters:

class Car
{
    public function scopeBlackType($query, $type){
          return $query->where('type' , 'like' , $type)->where('color' , 'like' , 'black')->get();
    }

Then you can use this like :

$blackTypeCars = Car::blacktype()->get();

Vue js: Child component's CSS is overridden by the parent tag

mostafalaravel — Wed, 03 Mar 2021 15:44:05 +0000

Hello ,

First let me show you the parent component :

(...)
<div class="card-header">
                            <h1>
                                <company-edit :id="companyId" :key="companyId"></company-edit>
                            </h1>
</div>

(...)


<style scoped></style>

`
As you can see there is no specific styles.

component :

 <div class="form-group row">
        <label class="col-4 col-form-label pr-0" :for="'companyNameI"> Company name in-              
                 house</label>
     <div class="col">
            <input (...)

<style scoped></style>

The problem is when I put <company-edit> inside <h1></h1> tag all the content of the <company-edit> is overridden by H1 style, and all the form labels are on H1 style!

Is there a way to "scope" the CSS of child component ?

Thanks

Laravel how to apply a validation on a json_decode content ?

mostafalaravel — Thu, 25 Feb 2021 13:21:10 +0000

Hello , I receive the form data via as a blob type

$companyDetail = request()->file('companyDetail');
$companyDetailJson = json_decode($companyDetail->getContent(),true);

How to apply a validation on $companyDetailJson ?

For example how to make : $companyDetailJson ["director"]["name"] required ?

Thanks

the route /email/resend returns : The GET method is not supported for this route

mostafalaravel — Tue, 19 Jan 2021 10:46:31 +0000

After the upgrade from larave 5.8 to 6 then to Laravel 7 , when I try to resend the password , this link http://localhost:3000/email/resend

return me the error bellow :

Symfony\Component\HttpKernel\Exception\MethodNotAllowedHttpException
The GET method is not supported for this route. Supported methods: POST.

Should I create it manually ?

Every new day I have this error : failed to open stream: Permission denied

mostafalaravel — Thu, 14 Jan 2021 10:24:26 +0000

Hello ,

I have this error

The stream or file "/data/www/site.com/storage/logs/laravel-2021-01-14.log" could not be opened in append mode: failed to open stream: Permission denied


-rw-r--r-- 1 root        root       30833 Jan 14 09:00 laravel-2021-01-14.log

When I change the directory permission it works BUT after one day I got the same error again!

How to convert this sql query to Eloquent ?

mostafalaravel — Tue, 12 Jan 2021 12:01:15 +0000

How to convert this sql query to Eloquent ?

SELECT user_id, company_id, MAX(date) date 
FROM careers 
GROUP BY user_id, comapany_id;

Why whereHas is very slow ?

mostafalaravel — Tue, 05 Jan 2021 12:07:08 +0000

Hello ,

let me fist show you a part of my code :

case 'first_name':
                        $eml = ($rule == 'or')
                            ? $eml->orWhereHas('user', function ($q) use ($condition) {
                                $q->where(
                                    'first_name','ilike','%bra%'
                                )->withTrashed();
                            })
                            : $eml->whereHas('user', function ($q) use ($condition) {
                                $q->where(
                                     'first_name','ilike','%bra%'
                                )->withTrashed();
                            });
                        break;

The code above works but very slow , the sql output is using EXISTS :

time response 25 seconds !!!!

(...)
LEFT OUTER JOIN "work_regimes" 
ON              "wra1"."work_regime_id" = "work_regimes"."id" 
WHERE           EXISTS 
                ( 
                       SELECT * 
                       FROM   "users" 
                       WHERE  "emls"."user_id" = "users"."id" 
                       AND    "first_name"::text ilike ?) 
AND             "users"."is_activated" = ? 
AND             "emls"."deleted_at" IS NULL 
ORDER BY        "id" ASC

When I replaceEXISTSbyIN` the response time is very very fast 0.3 second !

I replaced whereHas by wherIn but it's not working !

How to find a child (not direct child) of a specific element by Id(parent Id)?

mostafalaravel — Wed, 23 Dec 2020 09:44:18 +0000

Hello ,

<parent id="abc-1">

  <child-1>
    <child-2></child-2>
        <child-3>
            <child-4 class="my-class">Hey my data</child-4>
    </child-3>
   </child-1>

  <child-5></child-5>

</parent>

I would like to get the content of the element where the class name is my-class

This element exists inside parent with the id="abc-1" but we don't know on which level, maybe child or child of child or ... but we are sure that the class name is my-class

VueJS: what's the best npm image resizer ?

mostafalaravel — Mon, 21 Dec 2020 08:44:05 +0000

Hello ,

I'm looking for a tool to resize the picture before the upload.

I'm using vuejs 2.6.

With this tool I can (using the mouse) resize the picture move it into a frame ...

Thanks

Xdebug is installed but impossible to debug in PHPStorm and homestead

mostafalaravel — Wed, 16 Dec 2020 08:44:43 +0000

Hello ,

let me first introduce my work environment;

I use Vagrant, homestead and Laravel.

I installed the xdebug and when I vagrant ssh and php -v I see this result :

vagrant@homestead:~$ php -v
PHP 7.4.10 (cli) (built: Sep  9 2020 06:36:14) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Xdebug v3.0.0, Copyright (c) 2002-2020, by Derick Rethans
    with Zend OPcache v7.4.10, Copyright (c), by Zend Technologies
vagrant@homestead:~$

also when I phpinfo()

I also installed the Xdebug on my chrome browser

The problem now is how to configure the PHPStrom? because I tried all tutorials and nothing happened !

my current configuration :

Thanks.

Vue-table-2 : how to customize the filter input search?

mostafalaravel — Tue, 15 Dec 2020 12:54:05 +0000

Hello,

I'm using the matfish2/vue-table-2 (server side),

<v-server-table
                    :columns="columns"
                    :options="options"
                    :url="'my-url/api/'"
                    ref="segmentTable"

                    @loading="onTableLoad"
                    @loaded="onTableLoaded"
            >

current situation : when user search (filter) something it sends requests on every keyboard type,

Example: id user types hello it will search for h and he and hel and hell and hello

Question: how to send search request only when user type Enter ?

Thanks

homestead: The setting 'xdebug.remote_connect_back' has been renamed

mostafalaravel — Mon, 14 Dec 2020 14:34:29 +0000

Hello,

I try to configure xDebug on the homestead,

Now I receive this message when I run php -v

vagrant@homestead:/$ php -v
Xdebug: [Config] The setting 'xdebug.remote_connect_back' has been renamed, see the upgrading guide at https://xdebug.org/docs/upgrade_guide#changed-xdebug.remote_connect_back (See: https://xdebug.org/docs/errors#CFG-C-CHANGED)
Xdebug: [Config] The setting 'xdebug.remote_enable' has been renamed, see the upgrading guide at https://xdebug.org/docs/upgrade_guide#changed-xdebug.remote_enable (See: https://xdebug.org/docs/errors#CFG-C-CHANGED)
Xdebug: [Config] The setting 'xdebug.remote_port' has been renamed, see the upgrading guide at https://xdebug.org/docs/upgrade_guide#changed-xdebug.remote_port (See: https://xdebug.org/docs/errors#CFG-C-CHANGED)
PHP 7.4.10 (cli) (built: Sep  9 2020 06:36:14) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Xdebug v3.0.0, Copyright (c) 2002-2020, by Derick Rethans
    with Zend OPcache v7.4.10, Copyright (c), by Zend Technologies

How can I fix this ?