For Velichkin - as Discussed :
Just wanted to know . Can you implement a simple php where users can read the data in loyalty and loyalty_orders tables . Basically only read , update and delete is needed . The view would be a bit master/detail ..like ..orderid in loyalty has product details in loyalty_orders . Just a very basic page to view ..pagination ..sorting and searching . Customise any open source free script available online . Let me know your quote for the same . This is a very simple thing ..not much complications .
1. Yes Show all columns ..except statusdate .
2 . Users could update ..status (with a list of predefined values only..dropdown ) ..message..waybill..
3. Users can sort data on orderid or delivery date(if specified) or status
[login to view URL] 10-15 items ..depending on how good it looks ..even more if possible
5. Users can perform search on orderid .
Hope thats sufficient . Could be minor changes here and there when its finalised...We can have a hardcoded username/password for users to enter to this page ..so that no one random can modify the data .
Let me know your quote . Basically there will be very less data in these tables so just need to view them once its inserted . :)
And we're not in a hurry for completion as such cause its gonna be long before data insertion in these tables commences .Let me know .