NEED HELP!

[Worrom]

Please help, I'm desperate! I've been working on this for days but I've come to realize my abilities are not enough for this task, or I'm just missing something ridiculous.

 

Here's the background info.

The cart I work on is for a resort. We utilise the online cart to sell just about everything we can think of including food and wine(for room delivery only). We also offer gift certificates of monetary values, but would like to step this up to a higher level. Before we go any further, any previous contribution dealing with gift cards or vouchers (that I have found) are only redeemable through the shopping cart itself, unless anyone knows otherwise. Our gift certificates need to be redeemable anywhere throughout our resort.

What we are trying to accomplish is purchase a gift certificate from our site and have the ability to print it at the end of their session. A simple downloadable file will not be sufficient because each certificate requires a unique identifier for tracking purposes.

 

Now, having our needs explained, here's what I have done so far. I've installed the 'Print Order Receipt' contribution (http://www.oscommerce.com/community/contributions,2379) because it only appears in the checkout_success and account_history_info areas, after payment is confirmed. There is a thread for this contribution, but since I plan to mod the hell out of the receipt page, I don't feel this belongs as part of that thread.

 

My dillema is having the 'Print Order/Certificate' button appear only when that particular product has been purchased. What I believe I need is a command or function that will poll only products related to a particular order id rather than the entire database. I need the page to know that in Order#3, products_id#28 was purchased and therefore display the desired button. Currently, because item28 has been orders previously and is in the table the button is always displayed.

 

I will be glad to go into further detail later if anyone thinks that this query is possible and they might be able to help.

[satish]

Hello,

If there is logic at data base level,there is always a way to do it.

If there is no logic then we will need to apply some patch of code to createa logic and get the things implemented the way we want it to.

 

Satish

[Worrom]

Hello,

If there is logic at data base level,there is always a way to do it.

If there is no logic then we will need to apply some patch of code to createa logic and get the things implemented the way we want it to.

 

Satish

The database remains as it was installed, I have not altered anything. I think everything I need would be in the 'ORDERS_PRODUCTS' table. If I could only filter by 'order_id' of the active order either in checkout_success.php or account_history_info.php. And from that filter determine if a particular product was purchased (i.e. products_id=28), and if this statement is true then 'echo....<a href blah, blah,>...button.gif'.....if that makes sense.

I just don't know how to properly command this.