SilenceBringer

@dani94 ok, just replace ->join with ->joinLeft https://laravel.com/docs/8.x/queries#left-join-right-join-clause

@fanpero87 just mark any of replies as best answer to mark conversation as closed

@dani94 ok, just replace ->join with ->joinLeft https://laravel.com/docs/8.x/queries#left-join-right-join-clause

@eyantra

<div class="text-red-400 mt-2" v-if="team.errors['members.' +index +'.name']">
	<p class="text-sm">
		Please enter your full name. <br>									
		{{ team.errors['members.' +index +'.name'] }}
	</p>
</div>

@eyantra

<div class="text-red-400 mt-2" v-if="team.errors['members.' +index +'.name']">
	<p class="text-sm">
		Please enter your full name. <br>									
		{{ team.errors['members.' +index +'.name'] }}
	</p>
</div>

@eyantra members instead of member?

@aung htet paing javascript do not support array with numeric keys not in default order (staring from 0, one by one), so, it's used as object.

Do not use product id as array key (you have it in item and can use it for seraching)

Or you can do the following, for example

in Api\CartController

public function index()
    {
        return array_values(session("cart"));
    }

in cart.vue

                            <div v-for="(product, index) in products" :key="product.id">
                                <h2>
                                    {{product.name}} - {{product.id}}
                                </h2>
                                <button @click="removeFromCart(index)">Delete</button>
                            </div>
// ...

            removeFromCart(index){
                let _this = this;
                let product = this.products[index]
                // console.log(this.products);
                this.products.splice(id, 1);
                axios.delete(`/cart/${product.id}`)
                  .then(response => {
                    _this.products.splice(index, 1)
                  });
            }

@kxh no, I didn't use any shopping cart packages

@eyantra possible, errors instead of error? what is the name of object which contains the errors?

{{ errors.members[index].name }}

@kxh this package has last update 4 years ago. And it require illuminate/support v 5.*

Current laravel version in 8, and it require illuminate/support with the same version

You can't solve this problem. Package is outdated.

You can make fork on github, change dependencies and check compatibility with v8. But really it make more sence to search more up-to-date package

@eyantra

{{ error.members[index].name }}

@kxh this package has last update 4 years ago. And it require illuminate/support v 5.*

Current laravel version in 8, and it require illuminate/support with the same version

You can't solve this problem. Package is outdated.

You can make fork on github, change dependencies and check compatibility with v8. But really it make more sence to search more up-to-date package

@aung htet paing javascript do not support array with numeric keys not in default order (staring from 0, one by one), so, it's used as object.

Do not use product id as array key (you have it in item and can use it for seraching)

Or you can do the following, for example

in Api\CartController

public function index()
    {
        return array_values(session("cart"));
    }

in cart.vue

                            <div v-for="(product, index) in products" :key="product.id">
                                <h2>
                                    {{product.name}} - {{product.id}}
                                </h2>
                                <button @click="removeFromCart(index)">Delete</button>
                            </div>
// ...

            removeFromCart(index){
                let _this = this;
                let product = this.products[index]
                // console.log(this.products);
                this.products.splice(id, 1);
                axios.delete(`/cart/${product.id}`)
                  .then(response => {
                    _this.products.splice(index, 1)
                  });
            }

@fanpero87 bin model to - component? field?

can you show your code, not just an error

@aung htet paing this

{
"1": {

do you store product id as array keys? Do you need it?

otherwise, you can do

public function index()
    {
        return array_values(session("cart"));
    }

and it should fix the problem

@aung htet paing please show this

public function index()
    {
dd(session("cart"));
        return session("cart");
    }

@phpmick still not clear what you want

@phpmick

I want to get the most recent record for each user.

It's what you asked in original post

@aung htet paing can you show 'Api\[email protected]' method?

i figured out that response from api is returning object

can you show the object?

@amitshahc something like

public function scopeByProject($query, $id)
    {
        return $query->whereHas('site', function ($q) use ($id) {
            $q->where('project_id', $id);
        });
    }

https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence

@amitshahc something like

public function scopeByProject($query, $id)
    {
        return $query->whereHas('site', function ($q) use ($id) {
            $q->where('project_id', $id);
        });
    }

https://laravel.com/docs/8.x/eloquent-relationships#querying-relationship-existence

@phpmick use recently added hasOne ofMany relationship https://laravel.com/docs/8.x/eloquent-relationships#has-one-of-many

public function things()
{
    return $this->hasOne(Thing::class)->latestOfMany();
}

@deekshith if you need the list of permissions, you can get it like this:

return Permission::whereHas('roles.users', function ($query) {
    $query->where('id', Auth::id());
})->get();

@deekshith if you need the list of permissions, you can get it like this:

return Permission::whereHas('roles.users', function ($query) {
    $query->where('id', Auth::id());
})->get();

@forrestedw look at recently added hasOne()->ofMany relationship type https://laravel.com/docs/8.x/eloquent-relationships#has-one-of-many

@dani94

return $this->reports()
    ->select('reports.*', 'events.*', DB::raw('if(events.date, events.date, reports.date) as order_date'))
    ->join('events', 'events.report_id', '=', 'reports.id') // put your join conditions here
    ->orderBy('order_date', 'desc');

@lacoder ok, another solution:

app(BladeCompiler::class)->directive('moneyInt', function ($expression) {
            return "<?php echo moneyInt(${expression}); ?>";
        });

and in your helpers file define moneyInt function

if (!function_exists('money')) {
    /**
     * money.
     *
     * @param int|string $amount
     * @param string     $currency
     *
     * @return \Cknow\Money\Money
     */
    function money($amount, $currency = null)
    {
        return new Cknow\Money\Money(
            $amount * 100,
            new Money\Currency($currency ?: Cknow\Money\Money::getDefaultCurrency())
        );
    }
}

just in case - https://laravel-news.com/creating-helpers

@lacoder far from ideal, but should works:

Declare moneyInt blade directive

    app(BladeCompiler::class)->directive('moneyInt', function ($expression) {
            $params = array_map(fn ($item) => trim($item), explode(',', $expression));
            $amount = $params[0] * 100;
            $currency = isset($params[1]) ? ', ' . $params[1] : '';
            return "<?php echo money({$amount}{$currency}); ?>";
        });

and call it instead

@moneyInt(17000, 'INR')

@lacoder yes. Just look to docs https://github.com/cknow/laravel-money#usage

@lacoder looks like you simple need to multiply it by 100. Accepted value is in paisa

@philippehong by the way, I think it's wrong to update users by using get requests

@philippehong try to refactor

    public function update($id, $action)
    {
        if (in_array($action, ['du', 'au'])) {
            if (Seller::whereId($id)->update(['active' => $action == 'au' ? 1 : 0])) {
                return $this->responseRedirect('admin.accounts', 'Account status changed successfully.' ,'success',false, false);
            } else {
                return $this->responseRedirect('admin.accounts', 'Action could not be completed.' ,'error',false, false);
            }
        } elseif ($action == 0) {
            Seller::whereId($id)->delete();

            return $this->responseRedirect('admin.accounts', 'Account successfully deleted', 'success', false, false);
        }else{
            return redirect()->back();
        }
    }

@head0nf1re type php artisan route:list in terminal and see

Your cart.store url is post request to '/cart' it do not accept any params. You need to define it by yourself

Route::post('cart/{product}', [CartController::class, 'store'])->name('cart.store');
Route::resource('cart', CartController::class)->except(['show', 'store']);

@head0nf1re type php artisan route:list in terminal and see

Your cart.store url is post request to '/cart' it do not accept any params. You need to define it by yourself

Route::post('cart/{product}', [CartController::class, 'store'])->name('cart.store');
Route::resource('cart', CartController::class)->except(['show', 'store']);

@tomasosho sweet alert returns promise

swal({
                                                title:'Are you sure?',
                                                text:"You won't be able to revert this!",
                                                type:'warning',
                                                showCancelButton:true,
                                                confirmButtonColor:'#3085d6',
                                                cancelButtonColor:'#d33',
                                                confirmButtonText:'Yes, delete it!',
                                                cancelButtonText:'No, cancel!',
                                                confirmButtonClass:'btn btn-success',
                                                cancelButtonClass:'btn btn-danger',
                                                buttonsStyling:false,
                                                reverseButtons:true
                                            })
    .then((value) => {
        if (value) {
            window.location.href="/"+deleteFunction+"/"+id;
        }
    });;

@head0nf1re show routes file. Does url contains product param for store? Because default one store url doesn't

@vkronlein some thing to try

let _this = this;

this.emitter.on('set:returning', (returning) => {
    console.log('onSetReturning: ' + returning)
    _this.setReturn(returning)
})

setReturn(returning) {
    console.log('setReturning: ' + returning);
    this.returnTo = returning
}

also can you show hwhere you define returnTo?

@ilex01 so... it tells you do not have api.php file inside routes directory. Do you have it?

@ilex01 so... it tells you do not have api.php file inside routes directory. Do you have it?

@ehsanquddusi model has getTable method, you can use it

public function scopeWithAvailableQuantity($query)
{
    return $query->selectRaw('COALESCE((SELECT SUM(quantity) 
    FROM ecom_inventory ei2 WHERE ei2.purchase_item_id = ' . $this->getTable() . '.movement_item_id), 0)) 
    AS `quantity`'
    )->where($this->getTable() . '.movement_item_type', \Ecommerce\PurchaseItem::class)
        ->groupBy($this->getTable() . '.movement_item_id');
}

@roughlik is Files instance of Eloquent Model class?

this way you can replace

Files::getFileById($id);

with

Files::find($id);

@roughlik

 $file = Files::getFileById($id);
dd($file);

What you see? Ideally - show your getFileById method. If you get it via DB facade - you'll have stdClass instance. If youget it via Eloquent - you'll have Files instance and be able to update it

@nafeeur10 the order is the following:

1. drop customer_id foreign key in orders table https://laravel.com/docs/master/migrations#dropping-foreign-keys
2. change column type in both tables. They should be the same
3. create foreign key in orders table again

@drwhat I think you use some of deleted models in the __construct method of one of your commands. Remove it first

@rodrigog I got it from your original post =)) I think you have public property term binded via wire:model on your front?

@rodrigog you are doing it completely wrong.

$details = [];

foreach ($this->term as $key => $value) {
    $details[] = [
        'term' => $this->term[$key],
        'price' => $this->price[$key],
        'quantity' => $this->quantity[$key],
    ];
}

$invoice->details()->createMany($details);

@rodrigog you are doing it completely wrong.

$details = [];

foreach ($this->term as $key => $value) {
    $details[] = [
        'term' => $this->term[$key],
        'price' => $this->price[$key],
        'quantity' => $this->quantity[$key],
    ];
}

$invoice->details()->createMany($details);

@maltekiefer put appropriate table name before every column, like this

$data = Address::where(function ($query) use ($deletegateid){
    $query->where('addresses.delegatesid', $deletegateid)
    ->orWhereRaw('addresses.id IN (SELECT addressvisibilities.addressid FROM addressvisibilities WHERE addressvisibilities.delegatesid = '.$deletegateid.')');
        })->get();

@maltekiefer put appropriate table name before every column, like this

$data = Address::where(function ($query) use ($deletegateid){
    $query->where('addresses.delegatesid', $deletegateid)
    ->orWhereRaw('addresses.id IN (SELECT addressvisibilities.addressid FROM addressvisibilities WHERE addressvisibilities.delegatesid = '.$deletegateid.')');
        })->get();

@ehsanquddusi possible it make sence to look at withSum method for laravel relationships? https://laravel.com/docs/8.x/eloquent-relationships#other-aggregate-functions