KonaKart Community Forum

Installation / Configuration => Installation of KonaKart => Topic started by: ryanlynch on October 03, 2008, 11:10:06 pm

Title: OrderStatus ids
Post by: ryanlynch on October 03, 2008, 11:10:06 pm
Hi there -

Is there documentation anywhere that states what the different orderstatus id's represent??

For example.. I see this in my console:

The order with id = 123 has just changed state from stateId = 4 to stateId = 5

What I would like to know is what is the orderstatus id that represents a new payment received order

Thanks!
Title: Re: OrderStatus ids
Post by: Brian on October 04, 2008, 05:59:34 am
These can be defined by KonaKart Administrators so you should look in the Admin App or in your database:

SELECT * FROM orders_status;

--Brian
Title: Re: OrderStatus ids
Post by: ryanlynch on October 04, 2008, 10:20:54 am
Thank you, I found them.

Also, if I could inquire about AdminOrderSearch in the API -- there is a orderBy field (int), and I am wondering if you can tell me how the int relates to the data... in another words, how do I know what int relates to the possible orderBy values
Title: Re: OrderStatus ids
Post by: ryanlynch on October 04, 2008, 10:30:09 am
Nevermind -- I misread it -- my mistake
Title: Re: OrderStatus ids
Post by: Brian on October 04, 2008, 10:35:19 am
I think it's a good question Ryan!, and since I've looked it up, here is the answer:

You can use these constants:

AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_ASCENDING
AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_ID_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_ID_DESCENDING
AdminDataDescriptor.ORDER_BY_DATE_PURCHASED_ASCENDING
AdminDataDescriptor.ORDER_BY_DATE_PURCHASED_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_TOTAL_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_TOTAL_DESCENDING
AdminDataDescriptor.ORDER_BY_ORDER_STATUS_ASCENDING
AdminDataDescriptor.ORDER_BY_ORDER_STATUS_DESCENDING

Default is:

AdminDataDescriptor.ORDER_BY_CUSTOMERS_NAME_ASCENDING and then
AdminDataDescriptor.ORDER_BY_ORDER_ID_ASCENDING

--Brian
Title: Re: OrderStatus ids
Post by: ryanlynch on October 04, 2008, 10:36:07 am
Thank you! This will save me some time :)