opencart - Adding links directly to downloads to order.tpl -
i installed (fresh) opencart version 1.5.6.1.
i have been following advice given @ post: http://forum.opencart.com/viewtopic.php?t=11056 how add links directly items downloaded opencart.
i have updated order.tpl looks (below). when create new order, order confirmation email not going out @ after add code recommended post above. when use original version of order.tpl file email goes out no problems. new opencart , php, can't see why not working. can give me hints might need @ working? appreciated.
thanks!
<!doctype html public "-//w3c//dtd html 4.01//en" "http://www.w3.org/tr/1999/rec-html401-19991224/strict.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title><?php echo $title; ?></title> </head> <body style="font-family: arial, helvetica, sans-serif; font-size: 12px; color: #000000;"> <div style="width: 680px;"><a href="<?php echo $store_url; ?>" title="<?php echo $store_name; ?>"><img src="<?php echo $logo; ?>" alt="<?php echo $store_name; ?>" style="margin-bottom: 20px; border: none;" /></a> <p style="margin-top: 0px; margin-bottom: 20px;"><?php echo $text_greeting; ?></p> <?php if ($customer_id) { ?> <p style="margin-top: 0px; margin-bottom: 20px;"><?php echo $text_link; ?></p> <p style="margin-top: 0px; margin-bottom: 20px;"><a href="<?php echo $link; ?>"><?php echo $link; ?></a></p> <?php } ?> <?php if ($download) { ?> <p style="margin-top: 0px; margin-bottom: 20px;"><?php echo $text_download; ?></p> <p style="margin-top: 0px; margin-bottom: 20px;"><a href="<?php echo $download; ?>"><?php echo $download; ?></a></p> <?php } ?> <table style="border-collapse: collapse; width: 100%; border-top: 1px solid #dddddd; border-left: 1px solid #dddddd; margin-bottom: 20px;"> <thead> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;" colspan="2"><?php echo $text_order_detail; ?></td> </tr> </thead> <tbody> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><b><?php echo $text_order_id; ?></b> <?php echo $order_id; ?><br /> <b><?php echo $text_date_added; ?></b> <?php echo $date_added; ?><br /> <b><?php echo $text_payment_method; ?></b> <?php echo $payment_method; ?><br /> <?php if ($shipping_method) { ?> <b><?php echo $text_shipping_method; ?></b> <?php echo $shipping_method; ?> <?php } ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><b><?php echo $text_email; ?></b> <?php echo $email; ?><br /> <b><?php echo $text_telephone; ?></b> <?php echo $telephone; ?><br /> <b><?php echo $text_ip; ?></b> <?php echo $ip; ?><br /></td> </tr> </tbody> </table> <?php if ($comment) { ?> <table style="border-collapse: collapse; width: 100%; border-top: 1px solid #dddddd; border-left: 1px solid #dddddd; margin-bottom: 20px;"> <thead> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;"><?php echo $text_instruction; ?></td> </tr> </thead> <tbody> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $comment; ?></td> </tr> </tbody> </table> <?php } ?> <table style="border-collapse: collapse; width: 100%; border-top: 1px solid #dddddd; border-left: 1px solid #dddddd; margin-bottom: 20px;"> <thead> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;"><?php echo $text_payment_address; ?></td> <?php if ($shipping_address) { ?> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;"><?php echo $text_shipping_address; ?></td> <?php } ?> </tr> </thead> <tbody> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $payment_address; ?></td> <?php if ($shipping_address) { ?> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $shipping_address; ?></td> <?php } ?> </tr> </tbody> </table> <table style="border-collapse: collapse; width: 100%; border-top: 1px solid #dddddd; border-left: 1px solid #dddddd; margin-bottom: 20px;"> <thead> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;"><?php echo $text_product; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: left; padding: 7px; color: #222222;"><?php echo $text_model; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: right; padding: 7px; color: #222222;"><?php echo $text_quantity; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: right; padding: 7px; color: #222222;"><?php echo $text_price; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; background-color: #efefef; font-weight: bold; text-align: right; padding: 7px; color: #222222;"><?php echo $text_total; ?></td> </tr> </thead> <tbody> <?php foreach ($products $product) { ?> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $product['name']; ?> <?php foreach ($product['option'] $option) { ?> <br /> <small> - <?php echo $option['name']; ?>: <?php echo $option['value']; ?></small> <?php } ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $product['model']; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $product['quantity']; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $product['price']; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $product['total']; ?></td> </tr> <?php } ?> <?php foreach ($vouchers $voucher) { ?> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"><?php echo $voucher['description']; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: left; padding: 7px;"></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;">1</td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $voucher['amount']; ?></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $voucher['amount']; ?></td> </tr> <?php } ?> </tbody> <tfoot> <?php foreach ($totals $total) { ?> <tr> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;" colspan="4"><b><?php echo $total['title']; ?>:</b></td> <td style="font-size: 12px; border-right: 1px solid #dddddd; border-bottom: 1px solid #dddddd; text-align: right; padding: 7px;"><?php echo $total['text']; ?></td> </tr> <!--//q: bof add download links email --> <?php global $db, $language, $loader; $loader->language('account/download'); $query = $db->query("select order_download_id, name " . db_prefix . "order_download order_id = '" . $order_id . "'"); ?> <?php if ($query->num_rows) { ?> <tr> <td align="left" style="background-color: #069; color: #fff; font-size: 12px; font-weight: bold; padding: 0.5em 1em;"><?php echo $language->get('text_downloads'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td align="left"> <?php foreach ($query->rows $download) { ?> <a href="<?php echo $store_url; ?>index.php?route=account/download/download&order_download_id=<?php echo $download['order_download_id']; ?>"><?php echo $download['name']; ?></a><br/> <?php } ?> </td> </tr> <tr> <td> </td> </tr> <?php } ?> <!--//q: eof add download links email --> <?php } ?> </tfoot> </table> <p style="margin-top: 0px; margin-bottom: 20px;"><?php echo $text_footer; ?></p> </div> </body> </html> this part added per forum post mentioned above:
enter code <!--//q: bof add download links email --> <?php global $db, $language, $loader; $loader->language('account/download'); $query = $db->query("select order_download_id, name " . db_prefix . "order_download order_id = '" . $order_id . "'"); ?> <?php if ($query->num_rows) { ?> <tr> <td align="left" style="background-color: #069; color: #fff; font-size: 12px; font-weight: bold; padding: 0.5em 1em;"><?php echo $language->get('text_downloads'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td align="left"> <?php foreach ($query->rows $download) { ?> <a href="<?php echo $store_url; ?>index.php?route=account/download/download&order_download_id=<?php echo $download['order_download_id']; ?>"><?php echo $download['name']; ?></a><br/> <?php } ?> </td> </tr> <tr> <td> </td> </tr> <?php } ?> <!--//q: eof add download links email --> <!--//q: bof add download links email --> <?php global $db, $language, $loader; $loader->language('account/download'); $query = $db->query("select order_download_id, name " . db_prefix . "order_download order_id = '" . $order_id . "'"); ?> <?php if ($query->num_rows) { ?> <tr> <td align="left" style="background-color: #069; color: #fff; font-size: 12px; font-weight: bold; padding: 0.5em 1em;"><?php echo $language->get('text_downloads'); ?></td> </tr> <tr> <td> </td> </tr> <tr> <td align="left"> <?php foreach ($query->rows $download) { ?> <a href="<?php echo $store_url; ?>index.php?route=account/download/download&order_download_id=<?php echo $download['order_download_id']; ?>"><?php echo $download['name']; ?></a><br/> <?php } ?> </td> </tr> <tr> <td> </td> </tr> <?php } ?> <!--//q: eof add download links email -->
this simple can it.
<?php $query = $db->query("select order_download_id, name " . db_prefix . "order_download order_id = '" . $order_id . "'"); ?> header(‘content-type: text/plain’); header("content-disposition: attachment; filename=orderconfirmation.txt"); foreach ($query->rows $temp) { echo $temp['order_download_id']; echo $temp['name']; } ?> 
Comments
Post a Comment