Creating a product html generator for emails

**smithdp1** · 31 Jul 2012, 11:42 PM

Here I go again getting out of my comfort zone of knowledge. What I am trying to do is, in the admin I want to be able to input product id's into an input field and clcik a button and have html generated with that product(s) image(href linked to product), title(href linked to product), description and price. I found an old script that someone did for os commerce and I am trying to make it work for zen cart. THIS COULD BE A NICE MOD RELEASE!

There are 2 files:

1. generate_email.php
2. email.tpl.php

Here is the code for generate_email.php

Code:

<?php

//
// Email Generator V1.00
//
// This script generates an HTML email from a list of product IDs for
// use in an email campaign.
//
// 
// 
//

$template_file = "/catalog/zcadmin/email.tpl.php";

require('includes/application_top.php');
//require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

// Check login

//
// Get the action, either from the form that was posted or from the URL.
//

if (isset($_GET['action'])) {

    $action = $_GET['action'];

} else {

    $action = $_REQUEST['form']['action'];

}

//
// Perform based on the particular action that was defined.
//

if ($action == "generateemail") {

    $form = $_REQUEST['form'];

    //
    // Clean the product list that the user submitted by removing and carriage returns
    // or line feeds.  Also replace and commas with spaces and kick out multiple spaces
    // from the string.  Finally, we trim any spaces from the beginning or end of the
    // string and strip out any values that are not numeric (since all of the product
    // IDs are numeric).
    //

    $form['productlist'] = preg_replace("/[\r\n\,]/", " ", $form['productlist']);
    $form['productlist'] = preg_replace("/\s+/", " ", $form['productlist']);
    $form['productlist'] = trim($form['productlist']);

    //
    // If the product list was defined, then we split it out into an array at the spaces.
    //

    if (strlen($form['productlist']) > 0) {

        $product_ids = explode(" ", $form['productlist']);

    }

    //
    // If we have product IDs, then we need to get the necessary product information from
    // the database.  We store the product information from the database into an array for
    // reference in the output.  For compatability, we use the same functions that are
    // used by OScommerce.
    //

    if (count($product_ids) > 0) {

        $sql = "SELECT p.products_id, p.products_status, pd.products_name, pd.products_description,
                  p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price,
                  p.products_tax_class_id, p.products_date_added, p.products_date_available,
                  p.manufacturers_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                WHERE p.products_id IN ('".implode("','", $product_ids)."') AND pd.products_id = p.products_id
                  AND pd.language_id = '" . $languages_id . "'";


        $results = $db->Execute($sql);

        if ($results->RecordCount() > 0) {

            while ($row = $db->Execute($results)) {

                $product['id'.$row['products_id']] = $row;

            }

        }

        unset($sql, $row, $results);

        //
        // Get the output template information from the file and store the data for
        // reference.
        //

        $fhandle = fopen($template_file, "r");
        $content = fread($fhandle, filesize($template_file));
        fclose($fhandle);

        $lines = preg_split("/[\r\n]/", $content);

        if (count($lines) > 0) {

            foreach ($lines as $line) {

                if (preg_match("/\\$\\$(\S+)/", $line, $matches)) {

                    $section = strtolower($matches[1]);

                } elseif (isset($section)) {

                    $template[$section] .= $line."\n";

                }

            }

        }

        unset($content, $sections, $section);

        $page = 2;

    }

    $edit = $form;

    unset($form, $action);

}

?>
<html>
<head>
<title>Email Generator V1.00</title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<style type="text/css">
<!--
body {
	background-color: #FFFFFF;
	font-family: tahoma;
	font-size: 11px;
}

label {
	margin: 3px 0 0 0;
	display: block;
	width: 130px;
	float: left;
	padding: 3px 0 0 0;
	clear: both;
}

label.required {
	font-weight: bold;
}

table {
	font-size: 11px;
}
-->
</style>
</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php //require(DIR_WS_INCLUDES . 'column_left.php'); THIS WAS CAUSING ERRORS SO I COMMENTED OUT FOR NOW ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading">Email Generator V1.00</td>
            <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>
<?php

//
// The output depends on what page is currently being displayed.
//

if ($page == 2) {
?>
<br>
<b>Results</b><br>
<?php
    if (count($product_ids) > 0) {
?>
<table cellpadding="2" cellspacing="0">
<tr style="font-weight: bold;"><td>Product ID</td><td>Status</td><td>Name</td></tr>
<?php

        $html_string = $template['header'];

        foreach ($product_ids as $product_id) {

            if (isset($product['id'.$product_id])) {

                $template_data = $product['id'.$product_id];
                $template_data['products_price'] = number_format($template_data['products_price'], 2);

                $html_string .= preg_replace("/\<\<(.*?)\>\>/e", "\$template_data['\\1']", $template['content']);

?>
<tr><td><?=$product_id?></td><td>Found</td><td><?=htmlentities($product['id'.$product_id]['products_name'])?></td></tr>
<?php
            } else {
?>
<tr><td><?=$product_id?></td><td>Not Found</td><td>N/A</td></tr>
<?php
            }

        }

        $html_string .= $template['footer'];
?>
</table>
<?php
    }
?>
<br>
<b>HTML Code</b><br>
<form>
<textarea cols="60" rows="10">
<?=htmlentities($html_string)?>
</textarea>
</form>
<br>
<?php
}
?>
Enter the product IDs in the order in which you'd like for them to appear in the email.
<br>
<form method="post" action="generate_email2.php">
<input type="hidden" name="form[action]" value="generateemail">
<label class="required" for="productlist">Product IDs</label><textarea id="productlist" name="form[productlist]" cols="30" rows="5"><?=$edit['productlist']?></textarea>
<br>&nbsp;<br>
<input type="submit" value="Generate">
</form>
</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php

require(DIR_WS_INCLUDES . 'application_bottom.php');

//
// Functions
//

function convertHTMLArray($array)
{
    // This function accepts a single-dimensional array, runs through the elements
    // and converts special characters to HTML tags.

    if (is_array($array)) {
        foreach ($array as $key => $val) {
            $array[$key] = htmlspecialchars(stripslashes($val));
        }
    } else {
        $array = NULL;
    }
    return $array;

}
?>

Here is the code for email.tpl.php:

Code:

$$HEADER
<TABLE CELLPADDING="15" CELLSPACING="0">
$$CONTENT
<TR>
<TD VALIGN="top" WIDTH="1%"><A HREF="http://www.feelgoodwatches.com/product_info.php/manufacturers_id/<<manufacturers_id>>/products_id/<<products_id>>" TARGET="_blank"><IMG SRC="http://www.feelgoodwatches.com/catalog/images/<<products_image>>" BORDER="0" ALT="<<products_name>>" WIDTH="125"></A></TD>
<TD VALIGN="top" WIDTH="99%"><FONT COLOR="#000000" FACE="Arial" SIZE=2><A HREF="http://www.feelgoodwatches.com/catalog/product_info.php/manufacturers_id/<<manufacturers_id>>/products_id/<<products_id>>" TARGET="_blank"><FONT COLOR="#6868C9" FACE="Arial" SIZE=3><B><<products_name>></B></FONT></A><BR>
<<products_description>>
<BR><FONT COLOR="#FF0000" FACE="Arial" SIZE=3><B>Price:</B> <B>$<<products_price>></B></FONT>
</FONT></TD>
</TR>
<TR>
<TD COLSPAN="2"><HR WIDTH="100%" SIZE="1" COLOR="#7777D8" NOSHADE></TD>
</TR>
$$FOOTER
</TABLE>

As it sits I am getting this error:

PHP Catchable fatal error: Object of class queryFactoryResult could not be converted to string in /includes/classes/db/mysql/query_factory.php on line 101

Please Help????

**smithdp1** · 31 Jul 2012, 11:50 PM

It is safe to drop these in the root of admin to test.

**smithdp1** · 1 Aug 2012, 02:43 AM

Help Ajeh!!!

**rstevenson** · 1 Aug 2012, 11:07 AM

She doesn't usually need help.

Rob

**DrByte** · 1 Aug 2012, 06:12 PM

Originally Posted by smithdp1

while ($row = $db->Execute($results)) {
$product['id'.$row['products_id']] = $row;
}

Can't do that.

**smithdp1** · 1 Aug 2012, 08:12 PM

Here is the original osc code. Sorry DrByte...i tried to convert some of the code myself to zen.

Thanks for looking!

Code:

<?php

//
// Email Generator V1.00
//
// This script generates an HTML email from a list of product IDs for
// use in an email campaign.
//


$template_file = "/catalog/admin/email.tpl.php";

require('includes/application_top.php');
//require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

// Check login

//
// Get the action, either from the form that was posted or from the URL.
//

if (isset($_GET['action'])) {

    $action = $_GET['action'];

} else {

    $action = $_REQUEST['form']['action'];

}

//
// Perform based on the particular action that was defined.
//

if ($action == "generateemail") {

    $form = $_REQUEST['form'];

    //
    // Clean the product list that the user submitted by removing and carriage returns
    // or line feeds.  Also replace and commas with spaces and kick out multiple spaces
    // from the string.  Finally, we trim any spaces from the beginning or end of the
    // string and strip out any values that are not numeric (since all of the product
    // IDs are numeric).
    //

    $form['productlist'] = preg_replace("/[\r\n\,]/", " ", $form['productlist']);
    $form['productlist'] = preg_replace("/\s+/", " ", $form['productlist']);
    $form['productlist'] = trim($form['productlist']);

    //
    // If the product list was defined, then we split it out into an array at the spaces.
    //

    if (strlen($form['productlist']) > 0) {

        $product_ids = explode(" ", $form['productlist']);

    }

    //
    // If we have product IDs, then we need to get the necessary product information from
    // the database.  We store the product information from the database into an array for
    // reference in the output.  For compatability, we use the same functions that are
    // used by OScommerce.
    //

    if (count($product_ids) > 0) {

        $sql = "SELECT p.products_id, p.products_status, pd.products_name, pd.products_description,
                  p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price,
                  p.products_tax_class_id, p.products_date_added, p.products_date_available,
                  p.manufacturers_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                WHERE p.products_id IN ('".implode("','", $product_ids)."') AND pd.products_id = p.products_id
                  AND pd.language_id = '" . $languages_id . "'";

        $results = tep_db_query($sql);

        if (tep_db_num_rows($results) > 0) {

            while ($row = tep_db_fetch_array($results)) {

                $product['id'.$row['products_id']] = $row;

            }

        }

        unset($sql, $row, $results);

        //
        // Get the output template information from the file and store the data for
        // reference.
        //

        $fhandle = fopen($template_file, "r");
        $content = fread($fhandle, filesize($template_file));
        fclose($fhandle);

        $lines = preg_split("/[\r\n]/", $content);

        if (count($lines) > 0) {

            foreach ($lines as $line) {

                if (preg_match("/\\$\\$(\S+)/", $line, $matches)) {

                    $section = strtolower($matches[1]);

                } elseif (isset($section)) {

                    $template[$section] .= $line."\n";

                }

            }

        }

        unset($content, $sections, $section);

        $page = 2;

    }

    $edit = $form;

    unset($form, $action);

}

?>
<html>
<head>
<title>Email Generator V1.00</title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<style type="text/css">
<!--
body {
	background-color: #FFFFFF;
	font-family: tahoma;
	font-size: 11px;
}

label {
	margin: 3px 0 0 0;
	display: block;
	width: 130px;
	float: left;
	padding: 3px 0 0 0;
	clear: both;
}

label.required {
	font-weight: bold;
}

table {
	font-size: 11px;
}
-->
</style>
</head>
<body>
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <tr>
        <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading">Email Generator V1.00.1</td>
            <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td>
<?php

//
// The output depends on what page is currently being displayed.
//

if ($page == 2) {
?>
<br>
<b>Results</b><br>
<?php
    if (count($product_ids) > 0) {
?>
<table cellpadding="2" cellspacing="0">
<tr style="font-weight: bold;"><td>Product ID</td><td>Status</td><td>Name</td></tr>
<?php

        $html_string = $template['header'];

        foreach ($product_ids as $product_id) {

            if (isset($product['id'.$product_id])) {

                $template_data = $product['id'.$product_id];
                $template_data['products_price'] = number_format($template_data['products_price'], 2);

                $html_string .= preg_replace("/\<\<(.*?)\>\>/e", "\$template_data['\\1']", $template['content']);

?>
<tr><td><?=$product_id?></td><td>Found</td><td><?=htmlentities($product['id'.$product_id]['products_name'])?></td></tr>
<?php
            } else {
?>
<tr><td><?=$product_id?></td><td>Not Found</td><td>N/A</td></tr>
<?php
            }

        }

        $html_string .= $template['footer'];
?>
</table>
<?php
    }
?>
<br>
<b>HTML Code</b><br>
<form>
<textarea cols="60" rows="10">
<?=htmlentities($html_string)?>
</textarea>
</form>
<br>
<?php
}
?>
Enter the product IDs in the order in which you'd like for them to appear in the email.
<br>
<form method="post" action="generate_email.php">
<input type="hidden" name="form[action]" value="generateemail">
<label class="required" for="productlist">Product IDs</label><textarea id="productlist" name="form[productlist]" cols="30" rows="5"><?=$edit['productlist']?></textarea>
<br>&nbsp;<br>
<input type="submit" value="Generate">
</form>
</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- body_eof //-->
<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php

require(DIR_WS_INCLUDES . 'application_bottom.php');

//
// Functions

//

function convertHTMLArray($array)
{
    // This function accepts a single-dimensional array, runs through the elements
    // and converts special characters to HTML tags.

    if (is_array($array)) {
        foreach ($array as $key => $val) {
            $array[$key] = htmlspecialchars(stripslashes($val));
        }
    } else {
        $array = NULL;
    }
    return $array;

}
?>

**smithdp1** · 1 Aug 2012, 10:51 PM

rstevenson - yes I know she needs no help haha. All of you guys have really been a great help. I am now totally converted to zen. I have been using other carts for years but to be honest after seeing the support and all of the free add-ons for zen cart i will never install anything different for sure!

So what do you think...is this even possible? I was trying to use this section for some of the code changes...but DrBytes says one of them is not possible...or i just kinda messed it up.

http://www.zen-cart.com/wiki/index.p...dules_from_osC

**DrByte** · 2 Aug 2012, 08:53 PM

Guessing that it might be better to replace this:

Code:

        if ($results->RecordCount() > 0) {
            while ($row = $db->Execute($results)) {
                $product['id'.$row['products_id']] = $row;
            }
        }

with this:

Code:

while (!$results->EOF) {
  $product['id'.$row->fields['products_id']] = $row->fields;
  $results->MoveNext();
}

**smithdp1** · 2 Aug 2012, 09:31 PM

DrByte now I am getting this error:

PHP Fatal error: Cannot use object of type template_func as array in /nfs/c02/h06/mnt/19739/domains/feelgoodwatches.com/html/catalog/zcadmin/generate_email2.php on line 111

**DrByte** · 2 Aug 2012, 11:05 PM

Your script is clashing with the $template variable that Zen Cart uses.

You have two options:
a) in your script rename the handful of references to $template to something else
or
b) possibly move the line (near the top of your script) that declares the $template variable to a lower line after application_top is loaded. But this may break the calls your script does to other core Zen Cart components like header.php. So I'd suggest using (a) instead.