Rimaa Order Status

[heldercervantes]

Hi guys / gals.

Rimaa deals with logistics and moving products around. They needed an interface for their clients to check the status on their orders and that's where I came in.

Not much you can see just by visiting the site, because this is actually a private mobile oriented web-app. But see some screenshots below.

This project features some cool things under the hood:

1. First, the content is managed from a Google Spreadsheet. PW connects to the spreadsheet on an interval (that can be configured), parses the sheet and updates the orders list. So the various people that share that spreadsheet and keep it updated for internal control, are also maintaining this platform without even knowing it.
    
2. PW users templates was modified to allow for this platform's different roles:
   • Client : only sees his orders
   • Agent : has a set of clients he can overview
   • Super-agent : sees all clients
      
3. Updated orders visual cue: Comparing the current version of an order (by $page->modified) with last viewed version's date (stored in an repeater on each client), the app turns on a visual cue that the order has been updated since it was last seen. Viewing an order is an accordion-style CSS toggle, so at that point an Ajax call tells PW to update the last version viewed by the current user.

All in all, a very little project that once more shows the flexibility we get from this awesome API. Being able to modify users to have the fields we need to get something like this working is a beautiful thing.

 

[Sergio]

Very cool project! That's a great use case for PW you got!

[gmclelland]

Quote

 

First, the content is managed from a Google Spreadsheet. PW connects to the spreadsheet on an interval (that can be configured), parses the sheet and updates the orders list. So the various people that share that spreadsheet and keep it updated for internal control, are also maintaining this platform without even knowing it.

 

I'd love to see the code that does this.  I have a Google Spreadsheet of all the employees with their contact information.  I would like to easily import and update each employees info so that each employee can have their own contact page on our site.

[heldercervantes]

I'll need some time for that. Let me see what I can do.

[gmclelland]

@heldercervantes Bump.  Any chance you could share the code for this?  Still interested