DEV Community: Jitesh Dhamaniya

Jobs not picking up new .env values

Jitesh Dhamaniya — Thu, 02 Sep 2021 09:35:16 +0000

if you change env, make sure to restart your supervisor or queue worker so jobs can use new .env values too.

Use @entangle to get Pikaday date value on button click in Laravel Livewire.

Jitesh Dhamaniya — Thu, 03 Jun 2021 14:49:51 +0000

Recently i wanted to get Pikaday value to livewire component property on seperate action, rather than onSelect event of Pikaday. But i could not find a solution online and had to do it myself hence writing to help somebody looking for something in future.

And this is the code i used in a blade component e.g

@props(['id'])

<div wire:ignore>
    <input
        class="border"
        x-data="{
       // entangle local variable to component property.
        variable: @entangle($id).defer 
        }"
        x-ref="input"
        x-init="
        new Pikaday({
            field: $refs.input,
            format:'M/D/YYYY',
            toString(date, format) {
                // you should do formatting based on the passed format,
                // but we will just return 'D/M/YYYY' for simplicity
                const day = date.getDate();
                const month = date.getMonth() + 1;
                const year = date.getFullYear();
                return `${year}-${month}-${day}`;
            },
            onSelect: function() {
                // assign selected value to variable 
                variable = this.toString();
            }
        })"
        type="text"
        {{ $attributes }}
    >
</div>

And this is how you going to call this component.

  <x-date-picker                    
                    id="startDate" // this does the thing
                    autocomplete="off"
                    placeholder="Date"
                />

the benefit of this approch is that, this does not fire any livewire event on select, so no trip to server untill i fire using another button like this.

<x-button wire:click="$refresh" secondary class="text-xs"> Search </x-buttons.link>

Parse Cookies in Next.js

Jitesh Dhamaniya — Thu, 03 Jun 2021 14:46:29 +0000

One thing i love and hate at the same time about node eco-system is, that there is always a package for everything and you have to use npm package/module for everything. Apparently that was also behind the success of nodejs and Ryan hated it and he said it repeatedly. Personally i don't like to use package until it is very essential.

Anyways so recently i was implementing session in nextjs app and i had to parse cookies to get the token which i did set from my login api Route. I used querystring module from nodejs default modules to parse it. Node has some very useful modules and they come along with node, so you always have them with you, whether you use them or not.

Anyways long story short, this is what i used to parse query string.

import qs from 'querystring';

const cookies = qs.decode(ctx.req.headers.cookie, "; ")

ctx.req.headers.cookie would have something like this

token: 'token_cookie_value; Proxy_session=e05hujj6o8k6j9r'

so anything, in this form can be parsed with this code and it would look like this after parsing.

{
  token: 'token_cookie_value',
  Proxy_session: 'e05hujj6o8k6j9r'
}

So thats it. Simple and to the point. You can read more about querystring.parse here
https://nodejs.org/api/querystring.html#querystring_querystring_parse_str_sep_eq_options

Take care till next time.

Queues not running in laravel

Jitesh Dhamaniya — Fri, 14 May 2021 06:21:07 +0000

Hi, Recently when i tried to run queues on localhost, i encountered very strange problem. the command for running a queue in laravel

php artisan queue:listen

stopped working for me. i tried QUEUE_CONNECTION=SYNC which worked but any other connection would not.

Later i realised it was because apparently my application was in maintenance mode or i had run php artisan down command and never did this up. So even my application was running, it was according to kernel was in down or maintenance mode. once i ran command php artisan up, it started working again.

just wanted to write this down here, if anybody else encounter same problem.

UPDATE

upon investigation i realised down command creates a file storage/framework/down which apparently tell application its in maintenance mode. php artisan up simply delete this file, which let the whole application know its up.

UPDATE

Documentation says --force flag should make it work in maintenance mode but it does not seems to work for me.

Get Nested Property from a Object in JS

Jitesh Dhamaniya — Sat, 24 Apr 2021 11:41:34 +0000

Recently Stumbled upon this nice snippet for accessing Nested property using String.

/**
 * get property of object
 * @param obj object
 * @param path e.g user.name
 */
function getProperty(obj, path, defaultValue = '-') {
    const value = path.split('.').reduce((o, p) => o && o[p], obj);

    return value ? value : defaultValue;
  }

and this how you use it

getProperty(object, 'passengerDetails.data.driverInfo.currentVehicle.vehicleType')

Reference
https://stackoverflow.com/a/64239231/11164153

Would be interested to learn if there is any other easier or better way.

Generate Different Background color based on ul depth using css variable

Jitesh Dhamaniya — Sat, 13 Mar 2021 02:54:12 +0000

So Recently i have come across a requirement where i had to create separate background-color based on ul deptt, i had html like this

To do so i used two CSS Magical things. For Background color when we use hsl to define a color we can control a color based on a number. like this

background-color: hsl(100, 100%, 50%);

HSL is literally stands for Hue, Saturation, Lightness, so does the parameters. So changing hue will change the color.

Now second part is to figuring out dynamic number. Thanks to CSS variables we can define variables in css now. but i don't wanted to define hue number in css rather wanted to do using depth number which we can then convert to hue number using another css magic function which is calc. let me show you what i mean.

html {
/* Define a variable /
--depth:0;
}
ul {
/ Define background color */
background-color:hsl(calc(100 + var(--depth, 1) * 40 ), 100%, 50%);
}

here calc returns 100 for --depth:0 and 140 for --depth:1.

Now css part is done, in html we will override --depth variable value based on ul depth.

so now html would look like this

thats it. You will see different background colours all done in css.

You can check working snippet here.
https://codepen.io/jiteshdhamaniya/pen/NWboMKZ

Let me know if anyone does have better solution. See you next time.

P.S. - was having hard time, formatting ul, li code here, hence did the images.

Create Family Tree with just CSS and HTML

Jitesh Dhamaniya — Fri, 05 Mar 2021 07:01:25 +0000

This is great.
https://codepen.io/ross-angus/pen/jwxMjL

Validate a local Variable in Laravel Livewire.

Jitesh Dhamaniya — Mon, 01 Mar 2021 07:11:18 +0000

Laravel LiveWire is a phenomenal framework for Laravel. Using it for 1 hour makes you fall in love with it. I use nowadays for any project i am doing in Laravel. Anyways recently i had to validate a variable which was not a public one.

for Public variables its straightforward you define

protected $rules = []

or define

protected function rules(){
    return []
}

and then call $this->validate(). Simple.

But my requirement was to validate a variable which i was getting on click call (wire.click).

<a wire:click="changeStatus({{ $row->id }},4)">Mark as Approve</a>

little did i know Livewire does have solution for it as well for validating a local variable you do something like this

 $validate = Validator::make(
            ['status' => $status], // here you assign value for validation
            ['status' => 'required|integer|min:1|max:2'],
            ['required' => 'The :attribute field is required'],
        )->validate();

This is my complete code if you interested.

public function changeStatus($id, $status){
        $request = PayoutRequest::find($id);

        $validate = Validator::make(
            ['status' => $status],
            ['status' => 'required|integer|min:1|max:2'],
            ['required' => 'The :attribute field is required'],
        )->validate();

        $request->status = $status;
        $request->save();
        session()->flash('status', "Status has been updated.");
    }

hope this will help someone save some time.

Dispatch a job from tinker in Laravel

Jitesh Dhamaniya — Thu, 31 Dec 2020 10:06:01 +0000

When you need to dispatch job from tinker, the normal command which is

App\Jobs\YourJob::dispatch();

would not work in tinker because dispatch helper function depends on garbage collection. Hence to dispatch a job from tinker, use any of the following commands

\Bus::dispatch(new App\Jobs\YourJob($someArgument));

\Queue::push(new App\Jobs\YourJob($someArgument));

Reference - https://github.com/laravel/tinker/commit/1baadfe1721f85cd4e776aa323128dcd329f170d#diff-04c6e90faac2675aa89e2176d2eec7d8

SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

Jitesh Dhamaniya — Sat, 05 Dec 2020 04:53:35 +0000

When joining more than two tables and you want to do some operator thing such as SUM from one table column, you have to make sure joining table query return only one result, else you would find some weird behaviour such as concat instead of sum.

Have a look on this query

select sum(payments.amount), users.id, channels.channel_name , channels.channel_id from users
left join payments on payments.user_id = users.id 
left join channels on channels.user_id = users.id and channels.id = (select id from channels where channels.user_id = users.id limit 0,1) 
group by users.id

if i don't add

channels.id = (select id from channels where channels.user_id = users.id limit 0,1)

when joining channels table, it might fetch more than one results of channels for that user and it would make sql to behave weirdly and it ends up concating payments.amount instead of sum(payments.amount).

Advance Searching in Laravel for JSON Column type and using WHEN Method

Jitesh Dhamaniya — Tue, 22 Sep 2020 06:23:50 +0000

As a Regular Programmer Advance Searching is something you encounter once in a while. I recently implemented it in Laravel. Which i am going to explain here.

Prerequisite - it’s assumed that you do have basic knowledge of Laravel Architecture and its functionality such as how model, controller and routing works.

Okay so we do have a biodata table as the name represents it saves the biodata of a user. And this is how its migration looks like

Migration

$table->id();
$table->enum('gender',['boy','girl']);
$table->string('name',255);
$table->json('biodata');
$table->timestamps();

As you can see, we do have a table column biodata which is JSON type. This allows us to save JSON in our db. And we are going to use attribute casting to convert it to object automatically when fetching. So our Biodata model would look like this

Model

namespace App;

use Illuminate\Database\Eloquent\Model;

class Biodata extends Model
{
    protected $guarded = [];

    protected $casts = [
       'biodata' => object
    ];

    protected $perPage = 10;

}

Now before going further let’s see what our Biodata object would look like

Factory

return [
            'gender' => $this->faker->randomElement($this->gender),
            'name'=> $this->faker->name(),
            'biodata' => [
                'personal'=>[
                    'qualification' => $this->faker->randomElement($this->qualification),
                    'height'=>$this->faker->randomElement($this->height),
                    'income'=>$this->faker->numberBetween(100000,1000000),
                    'occupation' => $this->faker->randomElement($this->jobs),
                ],
                'family'=>[
                    'father_gotra' => $this->faker->randomElement($this->gotra),
                    'mother_gotra' => $this->faker->randomElement($this->gotra),
                ],
                'contact'=>[
                    'state' => $this->faker->randomElement($this->indianStates),
                ]
            ],
        ];

And on all these fields we are going to run a search.
Now It’s time to discuss what we want to get out of our search function. So here our all optional search parameters

Gender
- Single Value
- field type - ENUM
Qualification
- Could be Multiple Values
- field type - JSON Key
Min Height
- Single Value
- field type - JSON Key
Income
- Single Value
- field type - JSON Key
Occupation
- Single Value
- field type - JSON Key
Gotra
- Multiple Value
- field type - JSON Key

Now this might seem very straightforward to you, all you have to use is where statement and you should be okay BUT hold your horses and Let’s go over some obvious problems first

Searching in JSON field ?

So how are we going to search in JSON ? well apparently that's not hard with MYSQL and even better with Laravel, in nutshell this is how you search in a JSON field provided its key

return $query->where('biodata->personal->income', '>=', $minIncome);

Check Biodata object above to understand.

Multiple Values

Now before jumping into code to write search function, the one question you might be asking is how you are supposed to send multiple values in a query string ? well glad you asked, we will simply add them with comma like this

http:://url.com/?qualification=MBA,BA&gender=boy

Now we can simply explode them using “,” and it will give us an array of values for that parameter.

How to add multiple queries to where statements ?

So this is a standard where statement from Laravel docs

DB::table('users')->where('votes', 100)->get();

And we do have a better one too

$users = DB::table('users')->where([
    ['status', '=', '1'],
    ['subscribed', '<>', '1'],
])->get();

Here you can add multiple arguments to where statement,
But We need to have some kind of validation before we actually jump to running any query, Because all parameters are optional, so user might not provide all or any input to add to query.

And hence we need to write extra code when searching with where and that’s where when comes to save us. This is what official documentation says about it

Sometimes you may want clauses to apply to a query only when something else is true. For instance you may only want to apply a where statement if a given input value is present on the incoming request. You may accomplish this using the when method:

And this is how you write it

$users = DB::table('users')
                ->when($role, function ($query, $role) {
                    return $query->where('role_id', $role);
                })
                ->get();

But we have one more problem, how do we go about adding multiple values for the same parameter, well the second argument of when is a function and we can do anything in this function :) keep reading

So for checking multiple values for the same parameter we are going to use a loop in it and this is how it's going to look like.

->when($gotra, function ($query, $gotra) {
               foreach($gotra as $g){
                   $query->where('biodata->family->father_gotra', '<>' ,$g);
               }
               return $query;
           })

So that’s it. we covered all the basics we going to need to write search function. and this is how it’s going to look like

public function search(){

       $gender = request('gender');
       $state = request('state');

       $minIncome = (int)request('minIncome');
       $minHeight = (int)request('minHeight');

       $qualifications = request('qualification') != '' ? explode(",", request('qualification') ) : false;

       $gotra = request('gotra') != '' ? explode(",", request('gotra') ) : false;

       $results = Biodata::
           when($gender, function ($query, $gender) {
               return $query->where('gender', $gender);
           })
           ->when($state, function ($query, $state) {
               return $query->where('biodata->contact->state', $state);
           })
           ->when($qualifications, function ($query, $minQualification) {

               foreach($qualifications as $qualification){
                   $query->where('biodata->personal->qualification', '=', $qualification);
               }
               return $query;

           })
           ->when($minIncome, function ($query, $minIncome) {
               return $query->where('biodata->personal->income', '>=', $minIncome);
           })
           ->when($minHeight, function ($query, $minHeight) {
               return $query->where('biodata->personal->height', '>=' , $minHeight);
           })
           ->when($gotra, function ($query, $gotra) {
               foreach($gotra as $g){
                   $query->where('biodata->family->father_gotra', '<>' ,$g);
               }
               return $query;
           })
           ->paginate(10);

          return response($results,200);

I followed TDD approach while developing this so i created tests first, let me know if anyone of you want to check them out. Send me msg and i will share code.

So i will leave you guys with this today, let me know what you think.