function getAudience()
{
$status = MAILBEEZ_TRUSTPILOT_ORDER_STATUS_ID;
// early check to avoid processing when email was already sent
$mb_chk = new mailbeez_mailer($this);
// MAILBEEZ_TRUSTPILOT_PASSED_DAYS
// MAILBEEZ_TRUSTPILOT_PASSED_DAYS_SKIP
$date_skip = $this->dbdate(MAILBEEZ_TRUSTPILOT_PASSED_DAYS_SKIP);
$date_passed = $this->dbdate(MAILBEEZ_TRUSTPILOT_PASSED_DAYS);
$query_raw = "select c.customers_firstname, c.customers_lastname, o.orders_id, o.customers_name,\n o.customers_id, o.customers_email_address, o.date_purchased, s.date_added as status_date\n from " . TABLE_ORDERS . " o\n left join " . TABLE_CUSTOMERS . " c\n on (o.customers_id = c.customers_id)\n left join " . TABLE_ORDERS_STATUS_HISTORY . " s\n on (o.orders_id = s.orders_id)\n where o.orders_status = s.orders_status_id\n and s.orders_status_id = '" . (int) $status . "'\n and s.date_added <= '" . $date_passed . "'\n and s.date_added > '" . $date_skip . "'\n order by o.orders_id DESC";
$query = mh_db_query($query_raw);
while ($item = mh_db_fetch_array($query)) {
// mandatory fields:
// - firstname
// - lastname
// - email_address
// - customers-id -> block
// other keys are replaced while sending: $<key>
// early check to avoid processing when email was already sent
$chk_result = $mb_chk->check($this->module, $this->iteration, $item['customers_id'], $item['orders_id']);
if ($chk_result != false) {
// this iteration was already sent -> skip
continue;
}
$tp_block_token = base64_encode($mail['customers_id'] . '|' . $item['customers_email_address']);
$tp_block_url = HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_HIVE . '?ma=block&m=' . $this->module . '&mp=' . $tp_block_token;
$this->audience[$item['customers_id']] = array('firstname' => $item['customers_firstname'], 'lastname' => $item['customers_lastname'], 'customers_email_address' => $item['customers_email_address'], 'email_address' => MAILBEEZ_TRUSTPILOT_TRIGGER_EMAIL, 'customers_id' => $item['customers_id'], 'order_id' => $item['orders_id'], 'order_date' => mh_date_short($item['date_purchased']), 'status_date' => mh_date_short($item['status_date']), 'language' => MAILBEEZ_TRUSTPILOT_LANGUAGE, 'tp_block_url' => $tp_block_url);
}
return $this->audience;
}
?>
)
<br>
<?php
echo defined('PROJECT_VERSION') ? PROJECT_VERSION : '';
?>
<table>
<tr>
<td>Constant</td>
<td>loaded value</td>
<td>Database value</td>
</tr>
<?php
$configuration_query = mh_db_query("select configuration_key as cfgKey, configuration_value as cfgValue from " . TABLE_CONFIGURATION . " where configuration_key like 'MAILBEEZ%' order by configuration_key ");
while ($configuration = mh_db_fetch_array($configuration_query)) {
?>
<tr bgcolor="<?php
echo constant($configuration['cfgKey']) !== $configuration['cfgValue'] ? '#f8933c' : '#abd37f';
?>
">
<td style="word-wrap: normal"><?php
echo $configuration['cfgKey'];
?>
</td>
<td><?php
echo constant($configuration['cfgKey']);
?>
</span></td>
<td><?php
echo $configuration['cfgValue'];