New Zenner
- Join Date:
- Jul 2005
- Posts:
- 25
- Plugin Contributions:
- 0
Ticket printing - nearly there. Just need a little SQL help please
Like a number of previous posters I have been attempting to solve the problem of producing a viable way of getting event tickets to my customers.
Having played around with a number of options I have come back to the confirmation email as the most effective way of doing things - creating the ticket(s) on the bottom of the email for the customer to print. (We are a small enough venue - 150 seats - to not have to worry too much about duplication - we would spot it in the post event ticket count and quickly identify duplicates, together with the transgressor, as their name would be on the stub)
Anyway, I've modified the information/design of the confirmation email - Email_template_checkout - to my satisfaction, with the tickets listed at the bottom of the email.
I want to do two final tweaks and would be most grateful if anyone could help me please with the SQL. in the footer section shown below
-
I want to force a printer page break above the point that the list of sales begins. (ie where there is currently a dotted line saying 'tear off' )
-
At present, the email itemises the tickets for different events on a separate line which is good. HOWEVER, what I'd really like to do is where someone has ordered x tickets is to have a little loop which prints that line/ticket x times. The number of tickets purchased is contained (I think) as a part of $products_detail.
Many thanks in advance.
Tony
<!-- Footer Section --> <div class="footer"> <div class="copyright"> <p>$EXTRA_INFO</p> <p> <span class="style11"><span class="style12">THIS IS YOUR ON-LINE TICKET CONFIRMATION - </span> <p class="product-details style21"><span class="style20">YOU MAY NOW BRING WITH YOU TO AVOID QUEUING AT THE BOX OFFICE -</span><span class="style19"> </span> </p> </div> </div> </div> </div> <em>---------------------------------------- TEAR OFF --------------------------------------------------------</em> <p class="product-details"><span class="style11"><img src="email/logo.jpg" width="855" height="174"></span></p> <p class="product-details"><span class="style11">$EMAIL_FIRST_NAME $EMAIL_LAST_NAME, </span><span class="content-line"><span class="style11">$INTRO_ORDER_NUM_TITLE $INTRO_ORDER_NUMBER</span></span></p> <p class="style12"><span class="style16">$ORDER_COMMENTS</span></p> <div class="content-line-title"> <p>$PRODUCTS_DETAIL</p> <p><span class="order-detail-area">$ORDER_TOTALS</span></p> </div> </body> </html>