PHP CodeIgniter, Ecommrce site small tasks.
in admin sales/orderlisting/orderdetailed page you have to add 4 dropdowns -
dropdown 1: vendor list - get from the customer table with role seller , but there is a condition, you need to leftjoin order items with vendorprice table and list vendors who have price and stock for all items in order and get the total order cost [update sd_orders table and add these 4 fields, follow same naming convention/style]
eg : vendor dropdown will be like this
Self <this will be there as default first option with value =0>
Estin Sunny (300$)
dropdown 2: vendor status, just add a dropdown with status Assigned,Rejected,Accepted,Packing,Ready,Cancelled,Delivered
dropdown 3: list all from customer table whose role is deliveryboy
this dropdown also have defaultoption <self with value=0>
dropdown 4: delivery status : New,Free,Requested,Assigned,Collected,Delivered,Returned,Cancelled,Rejected,DamageReturn
Task 2: Delivery Boy Dashboard
on front end login, now top bar checks if user type is vendor and adds vendor pages like wise check role=deliveryboy and add respective menus
order list: where it will list all orders assigned to them, or deliverystatus-Free [Please duplicate order listing done for vendor and while clicking order details, there the user will update the delivery status ], here the delivery boy can search order with customer name/address , order#, date from/to and status.
Task 3: in admin sales/orderlisting/orderdetailed page add the facility to add comment against an order,
at the bottom of order details page, add a section called messages, there will be a textarea and an add button, have the order_id in hidden fields and logged_in user from session. on add button call an ajax function and save the comment, this will return latest comments, list the latest comments in that orders,show the posted users name, datetime,message. row by row, keep this with a view file include the same view in deliveryboy/orderdetailed page and also in vendor/order detailed page.
[the same add comment functionality ,same view , same ajax function need to be called in these 3 places,
add a table sd_messages , with fields: id - int AI,userid-int,reftype- string,refid-int,message-string 7999,createddate-datetime,status-int ] inour case reftype will be 'order', refid will be orderid
only accept the project if you are 100% confident, and please keep time line[1 day], since its little urgent and so many other tasks