Putting Sale text in header from Sales manager

[Fjolsvith]

Okay, so I have my store running. I am running a sale right now, but I want a snippet of code put into my header.php that will:

1. Parse the sales list in the database (that are defined in the Sales Manager).
2. Gets sale information for the sale with the lowest ZOrder.
3. Defines HEADER_SALES_TEXT with the following "Take advantage of our " + Sales Name + " Sale and save " + Sale Amount Off + " through " + End of Sale Date + "!"


This would allow my sales in my Sales manager to automatically update the header as sales are created and deleted.

Anyone have an idea of how to do this?

[DrByte]

In your template's tpl_header.php there is a section of code similar to this:

<?php              if (HEADER_SALES_TEXT != '') {
?>
      <div id="tagline"><?php echo HEADER_SALES_TEXT;?></div>
<?php
              }
?>

You could change it to something like this:

<?php
$saleDetails = $db->Execute("select * from " . TABLE_SALEMAKER_SALES . " where sale_status=1 order by sale_date_end asc, sale_id asc");
if ($saleDetails->RecordCount()) {
  $saleTitle = $saleDetails->fields['sale_name'];
  $saleAmount = number_format($saleDetails->fields['sale_deduction_value'], 2); // might have to adjust depending on sale_deduction_type setting
  $saleExpiry = $saleDetails->fields['sale_date_end']; // might have to adjust if you forget to set an expiry date
?>
      <div id="tagline">Take advantage of our <?php echo $saleTitle;?> Sale and save <?php echo $saleAmount;?> through <?php echo $saleExpiry;?>!</div>
<?php
              }
?>

[Fjolsvith]

Okay, I figured out what should be inserted:

<?php
$saleDetails = $db->Execute("select * from " . TABLE_SALEMAKER_SALES . " where sale_status=1 order by sale_date_end asc, sale_id asc");
if ($saleDetails->RecordCount()) {
$saleTitle = $saleDetails->fields['sale_name'];
$saleAmount = number_format($saleDetails->fields['sale_deduction_value'], 2); // might have to adjust depending on sale_deduction_type setting
$saleExpiry = $saleDetails->fields['sale_date_end']; // might have to adjust if you forget to set an expiry date
?>
      <div id="tagline">Take advantage of our <?php echo $saleTitle;?> Sale and save <?php 
if ($saleDetails->fields['sale_deduction_type'] == 2) echo '$';
echo round($saleAmount); 
if ($saleDetails->fields['sale_deduction_type'] == 1) echo '%';
?> through <?php echo $saleExpiry;?>!</div>