/******************************************
09/22/2006 - Paulo Kuong
- File Created
*******************************************/
require_once(__DIR__ . '/../../../vendor/autoload.php');
use Orchard\Mysqli\QueryData;
use Orchard\Mysqli\Wrapper as MysqliWrapper;
$wrapperObj = new MysqliWrapper($mysqli);
?>
$getdataq = 'SELECT we.date,email,we.upc,r.display_upc
FROM welcome_email we INNER JOIN releases r ON r.upc = we.upc
WHERE we.email_sent = "y" AND we.vendor_id = ?';
$dataParams = new QueryData();
$dataParams->addDataParam('i', $vendor_id);
if (!$viewall) {
$getdataq .= " limit 0,5";
}
$getdatars = $wrapperObj->executeQuery($getdataq, $dataParams);
if ($getdatars === false) {
showierror($getdataq);
}
if (count($getdatars)) { ?>
| Sent Date |
Recipient Email |
UPC |
$i=0;
foreach ($getdatars as $getdatarow) {
$row_class = (++$i & 1) ? '' : 'alt'; ?>
| =$getdatarow['date']?> |
=$getdatarow['email']?> |
=$getdatarow['display_upc']?> |
}
}
else { ?>
| No welcome email found. |
} ?>