tisuchi

Show us, what's it returning...

$setting->where('namesetting' , $key)->first();

You better use ``` before and after your code block.

Your code is not readable.

I guess, the problem is in this line-

$siteSettingUpdate = $setting->where('namesetting' , $key)->get()[0]; 

You can do this way-

$siteSettingUpdate = $setting->where('namesetting' , $key)->first();

Hope it will be working.

Here could be the process-

• Get all the completed tasks this week. This could be found based on the updated_at column or if you have a separate column for tracking the completion time.
• Then do calculation completed / total * 100.

@mattb

Once you turn strict to false, it shouldn't break your code. It should work fine. Try first.

BTW, have you checked this? https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error

Basically it will grab all the records from the DB but load 100 records in the memory. It's kind of limit and offset in pagination.

You better read the chunk part here. http://laravel-school.com/posts/laravel-pagination-vs-chunk-51

I think adding @ simply in front of your slug will solve your issue.

Route::get('@{slug}', '[email protected]');

Try.

Then maybe you can use any local calendar to get the local holidays. Then you can apply your logic on that based on working days.

I am not sure, you can try google calendar also if it supports.

So far I can understand that, the major changes between two projects are the value for the present, half-day and absent. So, in that case, why not you just count how many present and half day to get the total present in a month. Isn't that working for you?

Suggestion: To be honest, it is advisable to store a numeric number for your present, half day and absent value in db. It will be easier for handling.

Personally I recommend you not to store in another table. If you store in another table, you need to update relative tables also once the data has changed in the main table.

So, it is advisable to retrieve data based on your demand.

If you change your route order a bit, I guess it will work for you.

Route::get('contact/', '[email protected]');
Route::get('/{slug}', '[email protected]');

Order slug in the bottom.

If you have the same properties for your forms for creating and updating, then you just need to change the form action only.

In that case, you can try this way-

<form action="@if(Route::currentRouteName() == 'something.create') 'something.create' @else 'something.update' @end" method="POST" />

Here, something.create or something.update is the name of your create and update route accordingly.

Nope. The answer is bit different than him.

Anyways, thank you.

First of all, make sure your $id is returning the data.

Then try this. It should work.

Products::with('company', function($q){
    $q->where('visible', 0);
})->where('category_id', $id)
->groupBy('company_id')->get()

Have you tried this way?

return taskStatus::orderBy('order', 'asc')
    ->take(1)
    ->whereIn('id', [3,5,6,7,1,2])->get();

You can achieve this by using a relationship.

Products::with('visible', function($q){
    $q->where('visible', 0);
})->where('category_id', $id->id)
->groupBy('company_id')->get()

Now, you have to make sure that you have a relationship between products and companies tables. It should be an a company has many products.

Ref: https://laravel.com/docs/6.x/eloquent-relationships#one-to-many

Have you tried with str_plural()?

In your view, you can try this way.

{{ $users }} {{ str_plural('user', $users) }}

Ref: https://laravel.com/docs/6.x/helpers#method-str-plural

Maybe you can use whereHas().

$customer_ledger=Sales::whereHas('customer')
        ->with('customer')
        -> select('invoice_no','customer_id','created_at',DB::raw('sum(amount) as totalM'))
        ->where('customer_id', $id)
        ->groupby('invoice_no','customer_id','created_at')
        ->get();

That suppose to be one to many, as of I am thinking right now. Again it depends on your plan, to be honest.

@engrlaravel

Have you tried this?

$plans = Plan::with('positions')
        ->doesnthave('vacancy')
        ->where('created_by', 7)
        ->get();

You have to make sure that, you have the proper relationship with plan, positions and vacancy tables.

@hasibweb

Actually I was facing this issue also. Mainly I found this issue for not having an updated version of google chrome. I believe, if you update your chrome version, you won't see this anymore.

Still, if you are facing this issue, check out this discussion. https://github.com/laravel/dusk/issues/641

@pnandu1990

As per I know, there is no dedicated series about API for the mobile client in Laravel.

However, you can check it out this- https://laracasts.com/series/laravel-vue-and-spas

Yeah, correct. I didn't know that. Thank you, guys.

@kankai the best approach for your issue is @martinbean solution.

He is trying to apply to the relationship. Can we do like that way also?

Wouldn't be applied to the $game_id?

$game_id->detail()->whereDate('created_at', '=' $date)->get();

@matildah

In general, I have a suggestion about your code.

It is highly recommended to avoid put logical code in your view. It doesn't look good at all.

<?php $total += (int)$details['price'] *(int)$details['quantity'] ?>

@conixs

I believe, this discussion is closed to your issue. Maybe it will helpful for you. https://stackoverflow.com/questions/23336145/laravel-how-to-use-multiple-pivot-table-relationships

@engrlaravel

There are probably two options I can think of right now.

1. You need to write a regular expression then check whether it return value or not. In that case, you can easily handle without using many built-in functions.

2. By somehow if you need to use built-in functions, I believe you have to use at least two functions to cover all . of your criteria.

Now choose is yours, which one you will pick up.

@mostafalaravel

It's because of the following code in your model-

public static function boot()
    {
        static::creating(function ($user) {
            //$fullName = explode('.',strstr($user->email, '@', true));
            $user->first_name = "";
            $user->last_name = "";
        });

        parent::boot();
    }

If you take it off, it should work fine.

@engrlaravel

If this data comes from the user form, you can define everything in form validation part. It will be easier for you to handle.

@mstdmstd I believe you will get a lot of tutorials online.

Have you checked this? https://demonuts.com/laravel-google-login/

@kanchan186

I think the line of 83 should be like this-

$subcategory= \DB::table('subcategories')
          ->join('products','subcategories.p_id','=','products.p_id')
          ->join('categories','subcategories.c_id','=','categories.c_id')
          ->get();

You need to use DB to join tables instead of eloquent.

I just reindent the whole code because it's not readable. It should be like this-

<?php
namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\product;
use App\category;
use App\subcategory;
use File;

class SubcategoryController extends CategoryController {
    
    public function addstg() {
        $product = product::get();
        $category = category::get();
        $subcategory = subcategory::get();
        return view('addstg', compact('product', 'category', 'subcategory'));
    }
    
    public function store2(Request $request) {
        if ($request->hasFile('s_image')) {
            $file = $request->file('s_image');
            $destinationPath = public_path() . "/sub_img";
            $filename = $file->getClientOriginalName();

            if (!File::exists($destinationPath)) {
                File::makeDirectory($destinationPath, $mode = 0777, true);
                $file->move($destinationPath, $filename);
            } else {
                $file->move($destinationPath, $filename);
            }
        }

        subcategory::create([
          'p_id' => request('p_id'), 
          'c_id' => request('c_id'), 
          's_name' => request('s_name'), 
          's_image' => $filename
        ]);

        $product = product::get();
        $category = category::get();
        $subcategory = subcategory::get();

        return redirect('viewsub');
    }

    public function show2() {
        $product = product::get();
        $category = category::get();
        $subcategory = subcategory::get();

        $subcategory= \DB::table('subcategories')
          ->join('products','subcategories.p_id','=','products.p_id')
          ->join('categories','subcategories.c_id','=','categories.c_id')
          ->get();

        return view('subview', compact('category', 'product', 'subcategory'));
        return redirect('subview');
    }
}

@kanchan186

There should be a line number in this test Symfony \ Component \ Debug \ Exception \ FatalThrowableError (E_PARSE) syntax error, unexpected '$subcategory' (T_VARIABLE).

Show the line number.

The Google Plus service is shut down only. The rest of the services from Google is working perfectly. For example Gmail, you can use it smoothly.

Have you tried with attachFromStorage() since you are trying to attach the file from the public path?

Check the Attaching Files from Disk https://laravel.com/docs/5.8/mail#attachments

Instead of using relationship in the detail() method, may be you can use Local Scope to fix this issue. I believe you can easily pass parameter in scope.

Ref: https://laravel.com/docs/5.8/eloquent#local-scopes

Just to inform you that-

Legacy Google+ APIs have been shut down as of March 7, 2019. Changes to the shutdown plan have been made recently which may mitigate its effect on some developers. Learn more. Google+ integrations for web and mobile apps have also stopped functioning as of March 7, 2019. Learn more.

Reference: https://developers.google.com/+/web/api/rest/

If I understand you properly, it's called installation PHP globally. Of course, there are many tutorials around, however, I wrote tips on how to upgrade PHP version on Mac. Check this post. http://laravel-school.com/posts/macbook-update-php-version-globally-35

If I am not mistaken, it conflicts with links() from pagination. I am not sure whether you can use it or not. But since it works changing the name a bit, better use changed name.

https://laravel.com/api/5.8/Illuminate/Pagination/Paginator.html#method_links

In your post, you can create a new method like this way-

public function setSlugAttribute($value)
    {
        if (static::whereSlug($slug = str_slug($value))->exists()) {
            $slug = "{$slug}-{$this->id}";
        }
        $this->attributes['slug'] = $slug;
    }

Have you tried by fetching relationship data?

Category::with('subcategories')->whereNull('is_parrent')->get();

It should return you sub-categories for each category.

You need to run php artisan make:migration add_profile_photo_to_users in your .terminal. It will create a migration file that you need to update.

Read this: http://laravel-school.com/posts/how-to-add-new-columns-to-the-existing-table-in-laravel-migration-24

What you are getting now in this code?

You may check this. This discussion may help you- https://github.com/laravel/framework/issues/26843

@LARAVEL007 - Yes, that's what I mean.

Security shoudn't be the biggest concern here because you are just getting a hash to cross-check with DB and then update the data, nothing else.

I believe in that case, you need to put your activate-manager route code in web since you are trying to access this via web browser.

@laravel007

If your intention is to show comma after each element except the last one, you can easily use $loop->last() inside your foreach. I think it will help to fix your issue.

Check this code-

@foreach(explode(', ', $scholarship->selected_subjects) as $subject)
    <a href="{{ route('subjects.show', $subject) }}">
        {{ $subject }} ,
    </a>

    @if( !$loop->last)
        ,
    @endif
@endforeach

Read more: https://laravel.com/docs/5.8/blade#the-loop-variable

@CAC - Actually, you are right. It supposes to be \\ but it shows single only. I already update my code. Make sure that you have the same code now.

@laravel007

There can be few ways to solve your issue. However, I think the easiest way is to add a random temporary number in the view part while you are not storing this data anywhere else.

For example, if you have a users collection in your view, the code can be like this-

@foreach($users as $user)
    {{ $user->temp_code .'-'. \Str::random(4) }}
    // other code inside the loop
@endforeach

@MOHAMMADBASIR - There are two issues here-

1. You haven't use the get() so that you are getting this error.

2. whereIn() allows the integer value only, you have passed the string. You need to work with id instead of name here.

So, the right code should be like this-

public function index(Request $request)
{
        return \App\User::whereIn('id', [1, 2])->get();
}

Here, I assume the user id of username1 is 1 and username2 is 2.

Check More: https://laravel.com/docs/5.8/collections#method-wherein

It's because you probably pass a string instead of integer in the whereIn().

You better show your whereIn code.