SilenceBringer

Hi @felicia00 your functions contains the problem. When you search by element id ($('#carval') and $('#val_perc')) you get exact element (because id must be unique on the page). But then you try to use it as a collection of elements. Of course it not works. If you have several element to sub by values - use classes instead of id

Or show us your html code, so we can advise something more detailed

Tsk-tsk, edited your answer =) You answered wrong first =)

@felicia00 not sure I understand you correctly, can you explain please? Also, please, consider marking response as the best answer if it solved your problem

Hi @felicia00 your functions contains the problem. When you search by element id ($('#carval') and $('#val_perc')) you get exact element (because id must be unique on the page). But then you try to use it as a collection of elements. Of course it not works. If you have several element to sub by values - use classes instead of id

Or show us your html code, so we can advise something more detailed

Hi @godzilaravel you need to use whereColumn for this reason

case 'initialized':
                        $eml = ($rule == 'or')
                            ? $eml->orwhereColumn(
                                'emls.created_at', 'emls.updated_at'
                            )
                            : $eml->whereColumn(
                                'emls.created_at', 'emls.updated_at'
                            );
                        break;

Hi @iamkhan check 2 following links

Laravel Hashing for laravel

and

password_hash for vanilla php

both can use the same algorithms: bcrypt or argon. (bcrypt by default for both, I think)

@webfuelcode as simple as

    foreach (['img1', 'img2'] as $img) {
        if($request->hasFile($img)){
            $filename = time() . '.' . $request->{$img}->getClientOriginalExtension();
            if($post->{$img}){
                Storage::disk('my_files')->delete('post_img/' . $post->{$img});
            }
            $request->{$img}->storeAs('post_img', $filename, 'my_files');
            
            $validated[$img] = $filename;
        }
    }

Hi @r-dot really you are trying to do something strange...

UserAccountsModel::where($where_data)

this one returns query builder instance, not an array

'projects' => array(
                       "1234566"
                   )   

as far as projects is array (and looks like your project column is json in the database) in should be something like

               $projects => [
                   "1234566"
               ];
               $where = [
                   'role_id' => "5ba1ec5582539a8d5593e43d", 
                   'organization_id' => $organization_id,
               ];     
               $userAccountsModel = new UserAccountsModel();
               $pushProjectResult = $userAccountsModel->push_user_projects($projects, $where);

    public function push_user_projects($projects, $where) {
       return UserAccountsModel::where($where)->whereJsonContains('projects', $projects);
   } 

@yagrasdemonde ok, try this

return Session::
            with('steps')
            ->whereHas('steps', function ($query) use ($eventDate) {
                $query
                    ->whereBetween('date', [$eventDate->subMonths(4)->format('Y-m-d'), $eventDate->format('Y-m-d')]);
            })
            ->whereDoesntHave('steps', function ($query) use ($eventDate) {
                $query->where('date', '>=', $eventDate);
            })
            ->get();

@neeraj1005 I'm stupid =))

$tagIds = [];
if (request('tags') != '') {
            $tags = explode(',', request('tags'));
            // dd($tags);
            foreach ($tags as $tag_name) {
                $tag = Tag::updateOrCreate(['name' => $tag_name]);
                // dd($tag);
                $tagIds[] = $tag->id;
            }
        } 
                $post->tags()->sync($tagIds);

I created new variable and name it the same as you name yout tags from request

Hi @marcolino922 what the reason for using orWhere instead of where for searching?

Hi @baserider try this

class SeminarController extends Controller
{
    public function show($id)
    {
        $seminarDates = SeminarDate::with('seminar')->where('seminar_id', $id)->get();

        echo '<h1>' . ($seminarDates->count() ? $seminarDates->first()->seminar->title : Seminar::find($id)->title) . '</h1>';
        foreach ($seminarDates as $seminarDate) {
            echo '<h4>'.$seminar->title.' (' . $seminarDate->type . ')</h4>';
            echo $seminarDate->price . '<hr>';
        }

        return '';
    }
}

@baserider yes. with eager loads seminar for all the dates in 1 query

@neeraj1005 I'm stupid =))

$tagIds = [];
if (request('tags') != '') {
            $tags = explode(',', request('tags'));
            // dd($tags);
            foreach ($tags as $tag_name) {
                $tag = Tag::updateOrCreate(['name' => $tag_name]);
                // dd($tag);
                $tagIds[] = $tag->id;
            }
        } 
                $post->tags()->sync($tagIds);

I created new variable and name it the same as you name yout tags from request

@neeraj1005

$tags = [];
if (request('tags') != '') {
            $tags = explode(',', request('tags'));
            // dd($tags);
            foreach ($tags as $tag_name) {
                $tag = Tag::updateOrCreate(['name' => $tag_name]);
                // dd($tag);
                $tags[] = $tag->id;
            }
        } 
                $post->tags()->sync($tags);

@whoami1509 what you mean under adding the amount? In your code example you just create new earnings with appropriate amounts. do you have some field with total amount, or?

@ddsameera can you show your code where you call the api?

@whoami1509 did you try my code?

@neeraj1005

$tags = [];
if (request('tags') != '') {
            $tags = explode(',', request('tags'));
            // dd($tags);
            foreach ($tags as $tag_name) {
                $tag = Tag::updateOrCreate(['name' => $tag_name]);
                // dd($tag);
                $tags[] = $tag;
            }
        } 
                $post->tags()->sync($tags);

Hi @baserider try this

class SeminarController extends Controller
{
    public function show($id)
    {
        $seminarDates = SeminarDate::with('seminar')->where('seminar_id', $id)->get();

        echo '<h1>' . ($seminarDates->count() ? $seminarDates->first()->seminar->title : Seminar::find($id)->title) . '</h1>';
        foreach ($seminarDates as $seminarDate) {
            echo '<h4>'.$seminar->title.' (' . $seminarDate->type . ')</h4>';
            echo $seminarDate->price . '<hr>';
        }

        return '';
    }
}

Hi @neeraj1005 just replace this part

<input type="text" name="tags" class="form-control" 
   value="@foreach ($tags as $tag){{ $post->tags->contains($tag->id) ? $tag->name->implode(',') : '' }}@endforeach
                                            "
                                    />

with

<input type="text" name="tags" class="form-control" 
   value="{{ $post->tags->keyBy('name')->keys()->implode(', ') }} "
                                    />

@robinmvdoorn if you stay at the same page (form is not submitted) possible you have javascript code preventing default form submission? can you check your js console just in case?

@yagrasdemonde ok, try this

return Session::
            with('steps')
            ->whereHas('steps', function ($query) use ($eventDate) {
                $query
                    ->whereBetween('date', [$eventDate->subMonths(4)->format('Y-m-d'), $eventDate->format('Y-m-d')]);
            })
            ->whereDoesntHave('steps', function ($query) use ($eventDate) {
                $query->where('date', '>=', $eventDate);
            })
            ->get();

Hi @robinmvdoorn do you see eny errors, or - what's going wrong? Do not perform update? Or?

At least I can see this

return redirect(route('.books'));

Route name .books looks wrong

Hi @yagrasdemonde I think it should be something like:

return Session::
            with('steps')
            ->whereHas('steps', function ($query) use ($eventDate) {
                $query
                    ->whereBetween('date', [$eventDate->subMonths(4)->format('Y-m-d'), $eventDate->format('Y-m-d')]);
            })
            ->get();

@whoami1509 see this question not the first time, but it's still not clear for me. But - ok, let's try

$userId = 5; //jade

//call function with $user as argument
self::insertEarnings($userId);

use \Illuminate\Support\Arr;

protected $rankAmount = [
    'Junior' => 100,
    'Premium' => 150,
    'Advanced' => 200,
    'Senior' => 250,
];

private function insertEarnings($userId) {
    $user = User::get($userId);

    if ($user) {
        if (Arr::has($this->rankAmount, $user->rank)) {
            $earnings = new Earnings;
            $earnings->user_id = $user->id;
            $earnings->amount = Arr::get($this->rankAmount, $user->rank);
            $earnings->save();
        }

        if ($user->parent_id) {
            $this->insertEarnings($user->parent_id);
        }
    }
}

@ivan2nn try to remove this

       $this->withoutExceptionHandling();

@thebigk everythink works correctly

whereDate('subscription_valid_till', '>=', today())

// in result

subscription_valid_till: "2020-11-15 00:00:00",

date in result is 2020-11-15, it's less then 2020-11-09

whereTime('next_message_at', '<=', now())

// result 

 next_message_at: "2020-11-09 09:02:00"

so, the time pasrt of result is 09:02:00, and it's less then 12:06:39 in now

Your conditions looks wrong, but query works as expected. Tell us what you try to achieve and we will try to help you

@thebigk everythink works correctly

whereDate('subscription_valid_till', '>=', today())

// in result

subscription_valid_till: "2020-11-15 00:00:00",

date in result is 2020-11-15, it's less then 2020-11-09

whereTime('next_message_at', '<=', now())

// result 

 next_message_at: "2020-11-09 09:02:00"

so, the time pasrt of result is 09:02:00, and it's less then 12:06:39 in now

Your conditions looks wrong, but query works as expected. Tell us what you try to achieve and we will try to help you

Hi @coder72 use mzx

$maxDealerId=Product::max('dealer_id');

@ivan2nn try to remove this

       $this->withoutExceptionHandling();

Hi @coder72 use mzx

$maxDealerId=Product::max('dealer_id');

@ivan2nn don't see the mistake at first looks. Please, can you dump the data in 2 places

   public function a_project_requires_a_user()
   {
       $this->withoutExceptionHandling();

       $attributes = Project::factory()->raw(['user_id' => null]);
       dump($attributes);
       $this->post('/projects', $attributes)->assertSessionHasErrors('user_id');
   }

and second one

public function store() 
    {
        $attributes = request()->validate([
            'personal_code' => 'required',
            'code'        => 'required',
            'description'   => 'required',
            'user_id'       => 'required'
        ]);

    dd($attributes);
    Project::create($attributes);

    return redirect('/projects');
}

@mehrdad70 I think you can call sync with empty array do detach all existing tags, like

$article->tags()->sync([]);

Or you can do it at database layer, and specify onDelete('cascade') for tag_id in taggables table

@mehrdad70 I think you can call sync with empty array do detach all existing tags, like

$article->tags()->sync([]);

Or you can do it at database layer, and specify onDelete('cascade') for tag_id in taggables table

@beingsk try php artisan ui react --auth and check if it suits your needs

@beingsk use Laravel UI

@princeoo7 anyway, just to check, try to visa versa it. if it still not works, try something like:

$lang = 33.7490;
$long = -84.3880;

"langtitude" => $faker->latitude(
    $min = ($lang * 10000 - rand(0, 50)) / 10000,
    $max = ($lang * 10000 + rand(0, 50)) / 10000
),
"longitute" => $faker->longitude(
    $min = ($long * 10000 - rand(0, 50)) / 10000,
    $max = ($long * 10000 + rand(0, 50)) / 10000
),

@irankhosravi so, check where and how you get this $data. I think, it shouldn't be null to works correctly =) show us the code when you get the data from ajax call

Hi @newbie360 if you don't have direct relations to id in product_keywords table, it will be much simplier to remove all existing keywords and store new ones

        DB::beginTransaction();
        try{
            $product->productKeywords()->delete();

            $keywords = array_map(function ($keyword) {
                return ['keyword' => $keyword];
            }, $keywords);

            $product->productKeywords()->createMany($keywords);

            DB::commit();
        } catch (\Exception $e) {
            DB::rollBack();
            return back()->withErrors(['transaction_error' => $e->getMessage()]);
        }
        // End Transaction

@princeoo7 possible you set lat and lng visa versa? Because this

$lang = -84.3880;
$long = 33.7490;

points to the antarctica

@princeoo7 if you want point near your real coordinates, you need to change coordinates just about 0.001 or less. So, I can suggest something like

$lang = 33.7490;
$long = -84.3880;

"langtitude" => $faker->latitude($min = ($lang - (rand(0,20) / 1000)), $max = ($lang + (rand(0,20) / 1000))),
"longitute" => $faker->longitude($min = ($long - (rand(0,20) / 1000)), $max = ($long + (rand(0,20) / 1000))),

@maaz please show us your code

@irankhosravi just replace dd with var_dump to see data structure

function save($data)
{
    var_dump($data);exit;

@michaloravec I'm agree

@michaloravec I think he tries to append state and city names to state_id and city_id in form data

Hi @irankhosravi here

 data.push({'name':'state_name', 'value':state_name});

you specify the array, so, your $data array in php have something like:

['name' => 'state_name', 'value' => 'stateValue']

of course, you can't access it as

$data['state_name']

just dump the $data:

function save($data)
{
    dd($data);

to see the format

Hi @marcolino922 you have 2 places with php inserts

url:"{{ url('save-like') }}",

//and

_token:"{{ csrf_token() }}",

first one you can pass as data-attribute, like

<a href="#" data-url="{{ url('save-like') }}" id="saveLike">save like</a>

and then access it in js

var url=$(this).data('url');

second one can be solved as described in documentation

Hi @marcolino922 you have 2 places with php inserts

url:"{{ url('save-like') }}",

//and

_token:"{{ csrf_token() }}",

first one you can pass as data-attribute, like

<a href="#" data-url="{{ url('save-like') }}" id="saveLike">save like</a>

and then access it in js

var url=$(this).data('url');

second one can be solved as described in documentation

@newbie360 no problems id will keep growing. primary id is big int by default in laravel, so, you can use it for a very long time =)

about the order: keywords should come in the same order as you input it. so, what the problem here?