$80 for 2hr job involving checkout and order table (PHP)

Please message me with your email if you're interested.

The job involves editing the PHP so that different values are added to the final ORDER table.

This job needs to be completed preferebly within 24 hours but no later than 36 hours from now, hence the good pay.

This job should only take a couple of hours, however I'm just having trouble parsing the required values.

If you think you can achieve this PM me your email and I will send you the full details.

Payment will be made to you via PayPal. If it only take you ten minutes, you will still recieve the full $80, I would just like to see the working solution.

Kind Regards,
Scott Lawrence

need more info

Hey Qphoria,

I think I spoke to you about this job a while back but you were busy at the time.

If you look here http://tinyurl.com/ygmgs6f

This is the product page. I've turned OpenCart into a restaurant booking system.

If you go to the URL i sent to you and check availability for Lunch (any date), you will see it shows Tables available for that day.

Each table (with time) is stored as an option_value

When you click book it takes you to checkout where it sends the option_value_id and booking date.

The order_option table rather than taking convention of name:value needs to just be viewed as two seperate variables

so the field 'name' should store the booking date in the format 2009-10-17 (I have managed to get this to work already)

and field' value' store the option_value_id e.g 159 (this is what I still need to achieve)

It needs to be stored as one record (one order) in the order_option table

Hope this makes sense to you

If you have any question at all let me know,

and thank you for your quick reply!

Kind Regards,
Scott Lawrence

To sum up, I basically need to get option_value_id inserted into the order_option table's value field after order

Kind Regards,
Scott Lawrence

I think the problem still stems from the reason I stopped trying. I still have no idea what you are describing or why.

From what I gather you want:

Instead of:
Time: 10/15/2009
Table: #156

You want:
10/15/2009 : 156 (or maybe vice versa)

?

Hey Qphoria,

OK so say normally if you set up a style Colour for a product and your ordered Blue

in the order_option table in the database usually it would store name as colour and value as blue

When you checkout I want it to put the product_option_value id in the value field of the order_option table of the database.

See this screenshot:
http://www.dizine.co.uk/shot.png
In the screenshot records 4,56,58 show how I would like the data to be stored in the order_option table

Record 60 shows how it is currently functioning, the date is correctly sent and stored, but the value field remains empty. That should store the selected option_value_id. When you hit 'Book A Table' it posts the option_value_id to checkout...I want it to be sent through on order and put in the 'value' field of order_option.

Is this more clear?

If I'm still not making sense I could phone or skype you?

Thanks again for your time I really appreciate it

Kind Regards,
Scott