API Order hide once completed

yoursantu

Hi,
Is this possible to disappear orders from api/orders once completed!?
because i am trying to integrate orders to POS. the order should disappear once the order status completed.
Please help.

Thank you.

ryanmitchell

not by default - you would need to modify the api order transformer to restrict the items you want to return

yoursantu

ryanmitchell
Thank you for your response.
i have checked in /api/apiresources/transformers/OrderTransformer.php
containing a method
toArray()
should i restrict items within that method!?
please clear…

Thank you.

ryanmitchell

Yes thats where you should write the logic to exclude the statuses you want returned.

yoursantu

ryanmitchell
Okay,
to run my logic, i need to include statuses table and query ie:
WHERE status_id = 1
so is this possible to include statuses model within OrderTransformer.php ?
or any other way?

ryanmitchell

It should give you a laravel collection so you can do
->filter()
on that.

alternatively amend apiresources/orders to have a restExtendQuery() method and do your status limiting there using query->where()

yoursantu

ryanmitchell
$query->where('status_id', '!=', 1)
Is this right!?

ryanmitchell

Yep something like that should work in restExtendQuery()

yoursantu

ryanmitchell
Okay,
I have tried just like:

public function restExtendQuery($query) { if (($token = $this->getToken()) && $token->isForCustomer()) $query->where(['customer_id', $token->tokenable_id], ['status_id', '!=', 1]); return $query; }

`public function restExtendQuery($query)
{
    if (($token = $this->getToken()) && $token->isForCustomer())
        $query->where('customer_id', $token->tokenable_id)->whereNotIn('status_id', 1);

    return $query;
}`

but both of above not filtering the output!!

ryanmitchell

    public function restExtendQuery($query)
    {
        $query->whereNotIn('status_id', 1);
        if (($token = $this->getToken()) && $token->isForCustomer())
            $query->where('customer_id', $token->tokenable_id);

        return $query;
    }

yoursantu

$query->where('status_id', '!=', 1);
this is worked for me
$query->whereNotIn('status_id', 1);
throw error
status_code 500
message "Argument 1 passed to Illuminate\\Database\\Query\\Builder::cleanBindings() must be of the type array, int given, called in /opt/lampp/htdocs/ff/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php on line 908"

ryanmitchell

yep sorry whereNotIn('status_id', [1])should work

yoursantu

ryanmitchell
Yeah, now both are worked!
Thank you very much for your help!!

yoursantu

ryanmitchell
Hi,
I have to remap the Order API endpoint, i mean, i have to change some key name, and have to change some key value like order address instead of address_id for that how can i apply!?
please guide.

thank you.

ryanmitchell

You can use the order transformer to amend each individual order row returned.