SilenceBringer

Hi @extjac

Route::group(['prefix' => '{organization}'], function () {
	Route::get('/invoices, '[email protected]');
});

class InoviceController extends Controller
{
    public function index($organization)
    {
        dd($organization);
    }
}

this will returns organization id. Or, if you use model binding

class InoviceController extends Controller
{
    public function index(Organization $organization)
    {
        dd($organization);
    }
}

this should returns Organization model

@letmeknow you use date_default_timezone_get() function, which returns current timezone and accepts no arguments. If you want to set specific, timezone, you need to use date_default_timezone_set, which accepts argument

date_default_timezone_set('Asia/Jakarta');

Hi @obink you use attach method wrong. In case you have additional fields in pivot table, it should looks like:

for ($product=0; $product < count($products); $product++) {
    if ($products[$product] != '') {
        $order->products()->attach([
            $products[$product] => [
                'quantity' => $quantities[$product],
                'orderPrice' => $pricing[$product],
            ]
        ]);

        Product::where('id', $products[$product])->increment('qty',$quantities[$product]);
    }
}

also, possible it should decrement instead of increment? It make more sence to reduce product quantity after order creation

@loyd ok, this way dump

dd($p->subcategory);

possible, you have wrong defined relations, possible it should be named subCategory (because of _ in sub_categories table name), or you need to define foreign keys explicitly

@loyd ok, this way dump

dd($p->subcategory);

possible, you have wrong defined relations, possible it should be named subCategory (because of _ in sub_categories table name), or you need to define foreign keys explicitly

@loyd check that your subcategory exists. In controller

dd(SubCategory::find(2));

possible it's soft deleted?

Hi @loyd do

@dd($p->subcategory)

and check waht you have. Possible, subcategory can be null? this way

{{ optional($p->subcategory)->name }}

@kikogyh

        $request->validate([
            'news' => ['required', 'string', 'max:2500', 'min:30'],
            'terms' => ['required'],
        ]);

Hi @pveltrop at least show waht response you have from the server

fetch(pageUrl).then(response => response.json()).then(response => {
    console.log(response);
})

Hi @coola you can try something like:

$post->contributors()->syncWithoutDetaching([
    $request->user()->id => ['updated_at' => now()]
]);

Hi @mvnobrega you cn use eager loading (assuming you have defined belongsTo deUser relations on your Message model)

public function msgs(Request $request) {

      $msg = Message::with('deUser')->where('para_user_id', $request->user()->id)->get();

      return view('msgs',compact('msg'));
        
    }

this way 1 additional call will be executed to the database and user who sent the message will be attached to every message, so, you'll be able to access it.

Hi @datanorte I think your problem is in id you try to exclude from validation. Try like so:

'name_category' => "required|unique:categories,name_category," . $this->route('category'),

instead of category put your attribute name from route, so, if your route like

Route::put('/category/{category}', [CategoryController::class, 'update']);

param name will be category

Hi @extjac

Route::group(['prefix' => '{organization}'], function () {
	Route::get('/invoices, '[email protected]');
});

class InoviceController extends Controller
{
    public function index($organization)
    {
        dd($organization);
    }
}

this will returns organization id. Or, if you use model binding

class InoviceController extends Controller
{
    public function index(Organization $organization)
    {
        dd($organization);
    }
}

this should returns Organization model

@saurav77 no. If you want to sum by multiple years you'll need to use in or between

DB::raw('sum(if(year(sales.purchase_date) BETWEEN "' . $startFrom . '" AND "' . $endTo . '", quantity, 0)) AS yearly'))

// or


DB::raw('sum(if(year(sales.purchase_date) IN ("' . $startFrom . '", "' . $endTo . '"), quantity, 0)) AS yearly'))

@saurav77 of course

$date = now(); // or another Carbon instance

DB::table('products')
    ->select(
        'products.*',
        DB::raw('sum(if(sales.purchase_date = "' . $date->format('Y-m-d') . '", quantity, 0)) as today'),
        DB::raw('sum(if(year(sales.purchase_date) = "' . $date->format('Y') . '", quantity, 0)) AS yearly'))
    )
    ->leftJoin('sales', 'sales.product_id', '=', 'products.id')
    ->groupBy('products.id')
    ->get();

@saurav77 of course

$date = now(); // or another Carbon instance

DB::table('products')
    ->select(
        'products.*',
        DB::raw('sum(if(sales.purchase_date = "' . $date->format('Y-m-d') . '", quantity, 0)) as today'),
        DB::raw('sum(if(year(sales.purchase_date) = "' . $date->format('Y') . '", quantity, 0)) AS yearly'))
    )
    ->leftJoin('sales', 'sales.product_id', '=', 'products.id')
    ->groupBy('products.id')
    ->get();

@saurav77 sure

@saurav77 do you need to output it in blade? try like so

<table>
<thead>
    <tr>
        <th></th>
        @foreach ($results as $result)
            <th>{{ $result->product }}</th>
        @endforeach
    </tr>
</thead>
<tbody>
    @foreach (['yearly', 'today'] as $period)
        <tr>
            <td>{{ $period }}</td>
            @foreach ($results as $result)
                <td>{{ $result->$period }}</td>
            @endforeach
        </tr>
    @endforeach
</tbody>
</table>

Hi @ethar

@foreach(LaravelLocalization::getSupportedLocales()->filter(fn ($props, $localeCode) => $localeCode != LaravelLocalization::getCurrentLocale()) as $localeCode => $properties)
    <li>
        <a rel="alternate" hreflang="{{ $localeCode }}"
            href="{{ LaravelLocalization::getLocalizedURL($localeCode, null, [], true) }}">
            {{ $properties['native'] }}
        </a>
    </li>
@endforeach

or

@foreach(LaravelLocalization::getSupportedLocales() as $localeCode => $properties)
    @if ($localeCode != LaravelLocalization::getCurrentLocale())
        <li>
            <a rel="alternate" hreflang="{{ $localeCode }}"
                href="{{ LaravelLocalization::getLocalizedURL($localeCode, null, [], true) }}">
                {{ $properties['native'] }}
            </a>
        </li>
    @endif
@endforeach

Hi @saurav77 try like so:

DB::table('products')
    ->select(
        'products.*',
        DB::raw('sum(if(date(curdate()) = sales.purchase_date, quantity, 0)) as today'),
        DB::raw('sum(if(year(curdate()) = year(sales.purchase_date), quantity, 0)) AS yearly'))
    )
    ->leftJoin('sales', 'sales.product_id', '=', 'products.id)
    ->groupBy('products.id')
    ->get();

Hi @vitorenes I think whereHas condition is what you looking for.

So, you can grab all the contents which have specific subcategory like

App\Content::whereHas('subcategories', function ($query) {
    $query->where('id', 3);
})->get();

and even more filter by category and subcategory

App\Content::whereHas('subcategories', function ($query) {
    $query->where('id', 3);
})
    ->whereHas('categories', function ($query) {
        $query->where('id', 1);
    })
    ->get();

@webfuelcode you can try like so:

// in controller
public function settings()
    {
        $settings = AdminSet::settings();

        return view('admin.settings', compact('settings'));
    }

class AdminSet extends Model
{
    public function settings()
    {
        $data = static::all();

        return $data->count() ? $data : collect([
            new static([
                'title' => 'SiteTITLE',
                // other fields
            ])
        ]);
    }
}

or (if really you'll have just 1 row), replace all with first

    public function settings()
    {
        return static::first() ?: new static([
            'title' => 'SiteTITLE',
            // other fields
        ]);
    }

@shuvobhai becuase in your code you try to put into products table. For working with pivot table you need to use sync, attach or detach methods

Can you show your migrations for sell table, pivot table and products table?

Hi @shuvobhai possible your key has name supplier_product_id, not product_id

 $sell->Products()->updateOrCreate(['supplier_product_id' => $request->product_id[$i]],
                [
                    'cartoon' => $request->cartoon[$i],
                    'qty' => $request->qty[$i],
                    'rate' => $request->rate[$i],
                    'total' => $request->total[$i],
                ]
            );

Hi @webfuelcode can you explain little more? Do you have table like settings with key => value pairs, or it's model like description with title, keywords, etc?

Hi @yoman this way I think you can re-write the \App\Middleware\VerifyCsrfToken to redirect to previous page instead of throwing an exception

Hi @kikogyh you need to create separated migration for it

https://laravel.com/docs/8.x/migrations#creating-columns

Hi @mimiloca try something like

public function add(User $users, Request $request)
    {
        $users->update(['is_admin'=> $requist->is_admin == 0 ? 0 : 1]);
       
        return redirect('admin.users')->with('success', 'Admin Added!');
    }

Here i suggest that if your input == 0 user will not be an admin, and if any other value - it should

Hi @webfuelcode If your target is to minimize the count of db calls, I can't imagine another way than using unions here, like so:

$postsQuery = null;

$categories = Category::take(5)->get();

$categories->each(function ($category) use (&$postsQuery) {
    $query = Post::where('category_id', $category->id)->take(5);

    $postsQuery = $postsQuery ? $postsQuery->union($query) : $query;
))

$posts = $postsQuery->get()->groupBy('category_id');

and then in your view file you can use it like

@foreach ($categories as $category)
    <div>{{ $category->name }}</div>

    @if ($posts->has($category->id))
        <ul>
            @foreach ($posts->get($category->id, []) as $post)
                <li><a href="{{ $post->url }}">{{ $post->title }}</a></li>
            @endforeach
        </ul>
    @endif
@endforeach

this way you'll have just 2 db calls

I do not think there is any convention about it, so, each developer selects his own solution. As for me, if I have a property like user, and I want to have editable user, I just prepend init to the property name. so

props: {
  initUser: Object
}
data () {
    return {
        user: {},
    }
}

Hi @grozavule try this:

$validStatuses = array_keys(self::CUSTOMER_ORDER_STATUS);
            $validInput = $request->validate([
                'customer_id' => ['nullable', 'required_without_all:order_number,order_status', 'alpha_num'],
                'order_number' => ['nullable', 'required_without_all:customer_id,order_status', 'string'],
                'order_status' => ['nullable', 'required_without_all:order_number,customer_id', Rule::in($validStatuses)]
            ]);

Hi @afoysal I think your problem is in space at the end of $last_word

<a href="{{route('start' . trim($last_word))}}">

because here

Route [startRun ] not defined.

I see space at the end of route name

Hi @grozavule try this:

$validStatuses = array_keys(self::CUSTOMER_ORDER_STATUS);
            $validInput = $request->validate([
                'customer_id' => ['nullable', 'required_without_all:order_number,order_status', 'alpha_num'],
                'order_number' => ['nullable', 'required_without_all:customer_id,order_status', 'string'],
                'order_status' => ['nullable', 'required_without_all:order_number,customer_id', Rule::in($validStatuses)]
            ]);

Hi @afoysal I think your problem is in space at the end of $last_word

<a href="{{route('start' . trim($last_word))}}">

because here

Route [startRun ] not defined.

I see space at the end of route name

Hi @ethar

@foreach(LaravelLocalization::getSupportedLocales()->filter(fn ($props, $localeCode) => $localeCode != LaravelLocalization::getCurrentLocale()) as $localeCode => $properties)
    <li>
        <a rel="alternate" hreflang="{{ $localeCode }}"
            href="{{ LaravelLocalization::getLocalizedURL($localeCode, null, [], true) }}">
            {{ $properties['native'] }}
        </a>
    </li>
@endforeach

or

@foreach(LaravelLocalization::getSupportedLocales() as $localeCode => $properties)
    @if ($localeCode != LaravelLocalization::getCurrentLocale())
        <li>
            <a rel="alternate" hreflang="{{ $localeCode }}"
                href="{{ LaravelLocalization::getLocalizedURL($localeCode, null, [], true) }}">
                {{ $properties['native'] }}
            </a>
        </li>
    @endif
@endforeach

Hi @vitorenes I think whereHas condition is what you looking for.

So, you can grab all the contents which have specific subcategory like

App\Content::whereHas('subcategories', function ($query) {
    $query->where('id', 3);
})->get();

and even more filter by category and subcategory

App\Content::whereHas('subcategories', function ($query) {
    $query->where('id', 3);
})
    ->whereHas('categories', function ($query) {
        $query->where('id', 1);
    })
    ->get();

User::whereHas('follows', function ($query) use ($locationId) {
    $query->where('location_id', $locationId);
})->get();

Hi @coola your validation rules should looks like

[
    'field.*.content' => 'nullable|required_with:field.*.name,field.*.alias'
]

User::whereHas('follows', function ($query) use ($locationId) {
    $query->where('location_id', $locationId);
})->get();

@loomix oh... possible, DB::commit() is missing

@loomix oh... possible, DB::commit() is missing

Hi @pickab00 you have json encoded object. So, you need to decode it

you can set cast in your model like so

class Message extends Model
{
    protected $casts = [
        'body' => 'array',
    ];
}

then you'll be able to work with body as with array

$message->body['id'];

try{
    foreach($resources as $resource){
        dump('before: ' . DB::table('tool_user')
            ->where('tool_id', strval($resource['id'])) 
            ->where('user_id', Auth::id())
            ->first()
            ->tool_order);
        dump('New value: ' . $resource['order']);
        $query = DB::table('tool_user')
            ->where('tool_id', strval($resource['id'])) 
            ->where('user_id', Auth::id())
            ->update(['tool_order' => $resource['order']]);
        dump('after: ' . DB::table('tool_user')
            ->where('tool_id', strval($resource['id'])) 
            ->where('user_id', Auth::id())
            ->first()
            ->tool_order);
catch(\Exception $e){
    // ...
}

Hi @loomix try to dump number of rows which should be affected by every query, possible something wrong with your condition, so really 0 rows matches the query

try{
    foreach($resources as $resource){
        dump($resource['id'].' '.Auth::id().' '.$resource['order']);
        dump(DB::table('tool_user')
            ->where('tool_id', strval($resource['id'])) 
            ->where('user_id', Auth::id())
            ->count());
        $query = DB::table('tool_user')
            ->where('tool_id', strval($resource['id'])) 
            ->where('user_id', Auth::id())
            ->update(['tool_order' => $resource['order']]);
catch(\Exception $e){
    // ...
}

@codus you're welcome

@codus try raw

BooksSet::join('books', function ($join) {
    $join->on(function ($on) {
        $on->whereRaw('JSON_CONTAINS(books_sets.books, books.id)');
    });
});

@codus try raw

BooksSet::join('books', function ($join) {
    $join->on(function ($on) {
        $on->whereRaw('JSON_CONTAINS(books_sets.books, books.id)');
    });
});

@gianmarx no

to used to specify recipient name for all the methods raw|send|html|plain

raw used to specify the type of message - raw content

@pickab00 show the output of

dd($message->body);

Hi @pickab00 you have json encoded object. So, you need to decode it

you can set cast in your model like so

class Message extends Model
{
    protected $casts = [
        'body' => 'array',
    ];
}

then you'll be able to work with body as with array

$message->body['id'];