$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=confirm') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a> <a href="' . oos_href_link_admin($aFilename['orders'], 'cID=' . $cInfo->customers_id) . '">' . oos_image_swap_button('orders', 'orders_off.gif', IMAGE_ORDERS) . '</a> <a href="' . oos_href_link_admin($aFilename['mail'], 'selected_box=tools&customer=' . $cInfo->customers_email_address) . '">' . oos_image_swap_button('email', 'email_off.gif', IMAGE_EMAIL) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_catalog_link($aCatalogPage['wishlist'], 'wlid=' . $cInfo->customers_wishlist_link_id) . '">' . oos_image_swap_button('wishlist', 'wishlist_off.gif', IMAGE_WISHLIST) . '</a> <a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=editstatus') . '">' . oos_image_swap_button('status', 'status_off.gif', IMAGE_STATUS) . '</a>');
$manual_infotable = $oostable['manual_info'];
$sql = "SELECT man_info_id, man_key, status
FROM $manual_infotable
WHERE man_info_id = '1'";
$login_result = $dbconn->Execute($sql);
$login = $login_result->fields;
if ($login['status'] != '0') {
$contents[] = array('align' => 'center', 'text' => oos_draw_login_form('login', $aCatalogPage['login_admin'], 'action=login_admin', 'POST', 'target=_blank') . oos_draw_hidden_field('verif_key', $login['man_key']) . oos_draw_hidden_field('email_address', $cInfo->customers_email_address) . oos_image_swap_submits('login', 'login_off.gif', IMAGE_LOGIN) . '</form>');
}
$contents[] = array('text' => '<br />' . oos_customers_payment($customer_status['customers_status_payment']));
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_CREATED . ' ' . oos_date_short($cInfo->date_account_created));
$contents[] = array('text' => '<br />' . TEXT_DATE_ACCOUNT_LAST_MODIFIED . ' ' . oos_date_short($cInfo->date_account_last_modified));
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_LAST_LOGON . ' ' . oos_date_short($cInfo->date_last_logon));
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_LOGONS . ' ' . $cInfo->number_of_logons);
$contents[] = array('text' => '<br />' . TEXT_INFO_COUNTRY . ' ' . $cInfo->countries_name);
$contents[] = array('text' => '<br />' . TEXT_INFO_NUMBER_OF_REVIEWS . ' ' . $cInfo->number_of_reviews);
}
break;
}
if ( (!empty($heading)) && (!empty($contents) ) ) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
----------------------------------------------------------------------
Released under the GNU General Public License
---------------------------------------------------------------------- */
/** ensure this file is being included by a parent file */
defined('OOS_VALID_MOD') or die('Direct Access to this location is not allowed.');
if ($oEvent->installed_plugin('down_for_maintenance')) {
return false;
}
if ($sPage == $aPages['customers_image']) {
return false;
}
$myworld_block = '0';
if (isset($_SESSION['customer_id'])) {
$myworld_block = '1';
$customerstable = $oostable['customers'];
$address_bookstable = $oostable['address_book'];
$customers_infotable = $oostable['customers_info'];
$sql = "SELECT c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_image,\n a.entry_city, a.entry_country_id, ci.customers_info_date_account_created AS date_account_created\n FROM {$customerstable} c,\n {$address_bookstable} a,\n {$customers_infotable} ci\n WHERE c.customers_id = '" . intval($_SESSION['customer_id']) . "'\n AND a.customers_id = c.customers_id\n AND ci.customers_info_id = c.customers_id\n AND a.address_book_id = '" . intval($_SESSION['customer_default_address_id']) . "'";
$myworld = $dbconn->GetRow($sql);
if ($myworld['customers_gender'] == 'm') {
$myworld_gender = $aLang['male'];
} elseif ($account['customers_gender'] == 'f') {
$myworld_gender = $aLang['female'];
}
$sCountryName = oos_get_country_name($myworld['entry_country_id']);
$sAccountCreated = oos_date_short($myworld['date_account_created']);
// assign Smarty variables;
$oSmarty->assign(array('myworld' => $myworld, 'myworld_gender' => $myworld_gender, 'country_name' => $sCountryName, 'account_created' => $sAccountCreated));
}
$oSmarty->assign('block_heading_myworld', $block_heading);
$oSmarty->assign('myworld_block', $myworld_block);
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_FEATURED . '</b>');
$contents = array('form' => oos_draw_form('featured', $aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($sInfo) && is_object($sInfo)) {
$heading[] = array('text' => '<b>' . $sInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['featured'], 'page=' . $_GET['page'] . '&fID=' . $sInfo->featured_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . oos_date_short($sInfo->featured_date_added));
$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . oos_date_short($sInfo->featured_last_modified));
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_info_image($sInfo->products_image, $sInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
$contents[] = array('text' => '<br />' . TEXT_INFO_EXPIRES_DATE . ' <b>' . oos_date_short($sInfo->expires_date) . '</b>');
$contents[] = array('text' => '' . TEXT_INFO_STATUS_CHANGE . ' ' . oos_date_short($sInfo->date_status_change));
}
break;
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
}
?>
</tr>
</table></td>
</tr>
</table></td>
$contents[] = array('text' => TEXT_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $mInfo->manufacturers_name . '</b>');
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('delete_image', '', true) . ' ' . TEXT_DELETE_IMAGE);
if ($mInfo->products_count > 0) {
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS);
$contents[] = array('text' => '<br />' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $mInfo->products_count));
}
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($mInfo) && is_object($mInfo)) {
$heading[] = array('text' => '<b>' . $mInfo->manufacturers_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page'] . '&mID=' . $mInfo->manufacturers_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($mInfo->date_added));
if (oos_is_not_null($mInfo->last_modified)) {
$contents[] = array('text' => TEXT_LAST_MODIFIED . ' ' . oos_date_short($mInfo->last_modified));
}
$contents[] = array('text' => '<br />' . oos_info_image($mInfo->manufacturers_image, $mInfo->manufacturers_name));
$contents[] = array('text' => '<br />' . TEXT_PRODUCTS . ' ' . $mInfo->products_count);
}
break;
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_REVIEW . '</b>');
$contents = array('form' => oos_draw_form('reviews', $aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_REVIEW_INTRO);
$contents[] = array('text' => '<br /><b>' . $rInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($rInfo) && is_object($rInfo)) {
$heading[] = array('text' => '<b>' . $rInfo->products_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=edit') . '">' . oos_image_swap_button('edit','edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['reviews'], 'page=' . $_GET['page'] . '&rID=' . $rInfo->reviews_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . oos_date_short($rInfo->date_added));
if (!empty($rInfo->last_modified)) $contents[] = array('text' => TEXT_INFO_LAST_MODIFIED . ' ' . oos_date_short($rInfo->last_modified));
$contents[] = array('text' => '<br />' . oos_info_image($rInfo->products_image, $rInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT));
$contents[] = array('text' => '<br />' . TEXT_INFO_REVIEW_AUTHOR . ' ' . $rInfo->customers_name);
$contents[] = array('text' => TEXT_INFO_REVIEW_RATING . ' ' . oos_image(OOS_HTTP_SERVER . OOS_SHOP . OOS_IMAGES . 'stars_' . $rInfo->reviews_rating . '.gif'));
$contents[] = array('text' => TEXT_INFO_REVIEW_READ . ' ' . $rInfo->reviews_read);
$contents[] = array('text' => '<br />' . TEXT_INFO_REVIEW_SIZE . ' ' . $rInfo->reviews_text_size . ' bytes');
$contents[] = array('text' => '<br />' . TEXT_INFO_PRODUCTS_AVERAGE_RATING . ' ' . number_format($rInfo->average_rating, 2) . '%');
}
break;
}
if ( (!empty($heading)) && (!empty($contents) ) ) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
$amount = $currencies->format($amount);
}
if ($action == 'voucherdelete') {
$contents[] = array('text' => TEXT_CONFIRM_DELETE . '</br></br>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=confirmdelete&cID=' . $_GET['cID'], 'NONSSL') . '">' . oos_image_swap_button('confirm', 'confirm_off.gif', 'Confirm Delete Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', 'Cancel') . '</a>');
} else {
$prod_details = NONE;
if ($cInfo->restrict_to_products) {
$prod_details = '<a href="' . oos_href_link_admin($aFilename['listproducts'], 'cID=' . $cInfo->coupon_id) . '" TARGET="_blank" ONCLICK="window.open(\'' . $aFilename['listproducts'] . '?cID=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>';
}
$cat_details = NONE;
if ($cInfo->restrict_to_categories) {
$cat_details = '<a href="' . oos_href_link_admin($aFilename['listcategories'], 'cID=' . $cInfo->coupon_id) . '" TARGET="_blank" ONCLICK="window.open(\'' . $aFilename['listcategories'] . '?cID=' . $cInfo->coupon_id . '\', \'Valid_Categories\', \'scrollbars=yes,resizable=yes,menubar=yes,width=600,height=600\'); return false">View</A>';
}
$coupon_name_result = $dbconn->Execute("SELECT coupon_name\n FROM " . $oostable['coupons_description'] . "\n WHERE coupon_id = '" . $cInfo->coupon_id . "' AND\n coupon_languages_id = '" . intval($_SESSION['language_id']) . "'");
$coupon_name = $coupon_name_result->fields;
$contents[] = array('text' => COUPON_NAME . ' :: ' . $coupon_name['coupon_name'] . '<br />' . COUPON_AMOUNT . ' :: ' . $amount . '<br />' . COUPON_STARTDATE . ' :: ' . oos_date_short($cInfo->coupon_start_date) . '<br />' . COUPON_FINISHDATE . ' :: ' . oos_date_short($cInfo->coupon_expire_date) . '<br />' . COUPON_USES_COUPON . ' :: ' . $cInfo->uses_per_coupon . '<br />' . COUPON_USES_USER . ' :: ' . $cInfo->uses_per_user . '<br />' . COUPON_PRODUCTS . ' :: ' . $prod_details . '<br />' . COUPON_CATEGORIES . ' :: ' . $cat_details . '<br />' . DATE_CREATED . ' :: ' . oos_date_short($cInfo->date_created) . '<br />' . DATE_MODIFIED . ' :: ' . oos_date_short($cInfo->date_modified) . '<br /><br />' . '<center><a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=email&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('email', 'email_off.gif', 'Email Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucheredit&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('edit', 'edit_off.gif', 'Edit Voucher') . '</a>' . '<a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucherdelete&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('delete', 'delete_off.gif', 'Delete Voucher') . '</a>' . '<br /><a href="' . oos_href_link_admin($aFilename['coupon_admin'], 'action=voucherreport&cID=' . $cInfo->coupon_id, 'NONSSL') . '">' . oos_image_swap_button('report', 'report_off.gif', 'Voucher Report') . '</a></center>');
}
break;
}
?>
<td width="25%" valign="top">
<?php
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
$sql1 = "SELECT c.customers_firstname, c.customers_lastname FROM {$customerstable} c WHERE c.customers_id = '" . $cid . "'";
$result1 = $dbconn->Execute($sql1);
$crec = $result1->fields;
// Query DB for the FIRST order that matches this customer ID and came after the abandoned cart
$orderstable = $oostable['orders'];
$orders_totaltable = $oostable['orders_total'];
$orders_statustable = $oostable['orders_status'];
$orders_sql = "SELECT o.orders_id, o.customers_id, o.date_purchased,\n s.orders_status_name, ot.text as order_total, ot.value\n FROM {$orderstable} o\n LEFT JOIN {$orders_totaltable} ot ON (o.orders_id = ot.orders_id),\n {$orders_statustable} s\n WHERE (o.customers_id = '" . (int) $cid . "'\n OR o.customers_email_address like '" . $crec['customers_email_address'] . "'\n OR o.customers_name like '" . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . "')\n AND o.orders_status > " . RCS_PENDING_SALE_STATUS . "\n AND o.orders_status = s.orders_status_id\n AND o.date_purchased >= '" . $inrec['recovercartsales_date_added'] . "'\n AND ot.class = 'ot_total'";
$orders_result = $dbconn->Execute($orders_sql);
$orders = $orders_result->fields;
// If we got a match, create the table entry to display the information
if (isset($orders) && !empty($orders)) {
$custknt++;
$total_recovered += $orders['value'];
$custknt % 2 ? $class = RCS_REPORT_EVEN_STYLE : ($class = RCS_REPORT_ODD_STYLE);
$custlist .= '<tr class="' . $class . '">' . '<td class="datatablecontent" align="right">' . $inrec['recovercartsales_id'] . '</td>' . '<td> </td>' . '<td class="datatablecontent" align="center">' . oos_date_order_stat($inrec['recovercartsales_date_added']) . '</td>' . '<td> </td>' . '<td class="datatablecontent"><a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $crec['customers_lastname'], 'NONSSL') . '">' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '</a></td>' . '<td class="datatablecontent">' . oos_date_short($orders['date_purchased']) . '</td>' . '<td class="datatablecontent" align="center">' . $orders['orders_status_name'] . '</td>' . '<td class="datatablecontent" align="right">' . strip_tags($orders['order_total']) . '</td>' . '<td> </td>' . '</tr>';
}
// Move that ADOdb pointer!
$result->MoveNext();
}
// Close result set
$result->Close();
$cline = "<tr><td height=\"15\" COLSPAN=8> </td></tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_RECORDS . "</b></td>" . "<td> </td>" . "<td align=left COLSPAN=5 class=main>" . $rc_cnt . "</td>" . "</tr>" . "<tr>" . "<td align=right COLSPAN=3 class=main><b>" . TOTAL_SALES . "</b></td>" . "<td> </td>" . "<td align=left COLSPAN=5 class=main>" . $custknt . TOTAL_SALES_EXPLANATION . " </td>" . "</tr>" . "<tr><td height=\"12\" COLSPAN=6> </td></tr>";
echo $cline;
?>
<tr class="dataTableHeadingRow"> <!-- Header -->
<td width="7%" class="dataTableHeadingContent" align="right"><?php
echo TABLE_HEADING_SCART_ID;
?>
</td>
<td width="1%" class="dataTableHeadingContent"> </td>
$heading = array();
$contents = array();
switch ($action) {
case 'confirm':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_NEWSFEED . '</b>');
$contents = array('form' => oos_draw_form('newsfeed_manager', $aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_DELETE_INTRO . '<br /><br /><b>' . $nmInfo->newsfeed_manager_firstname . ' ' . $nmInfo->newsfeed_manager_lastname . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($nmInfo) && is_object($nmInfo)) {
$heading[] = array('text' => '<b>' . $nmInfo->newsfeed_manager_name . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['newsfeed_manager'], oos_get_all_get_params(array('nmID', 'action')) . 'nmID=' . $nmInfo->newsfeed_manager_id . '&action=confirm') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_URL . ' ' . $nmInfo->newsfeed_manager_link);
$contents[] = array('text' => '<br />' . TEXT_DATE_ADDED . ' ' . oos_date_short($nmInfo->newsfeed_manager_date_added));
$contents[] = array('text' => '<br />' . TEXT_LAST_MODIFIED . ' ' . oos_date_short($nmInfo->newsfeed_manager_last_modified));
$contents[] = array('text' => '<br />' . TEXT_CACHE_TIME . ' ' . $nmInfo->newsfeed_manager_refresh);
}
break;
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
<?php
$tax = $tax_result->fields;
$oosPrice = $oosPrice * ($tax[tax_rate] + 100) / 100;
$oosPriceList = $oosPriceList * ($tax[tax_rate] + 100) / 100;
if (isset($specials) && is_array($specials)) {
$oosSpecialsPriceNetto = round($specials['specials_new_products_price'], TAX_DECIMAL_PLACES);
$oosSpecialsPrice = round($specials['specials_new_products_price'] * ($tax[tax_rate] + 100) / 100, TAX_DECIMAL_PLACES);
}
}
$oosPrice = round($oosPrice, TAX_DECIMAL_PLACES);
$oosPriceList = round($oosPriceList, TAX_DECIMAL_PLACES);
if (isset($specials) && is_array($specials)) {
$contents[] = array('text' => '<br /><b>' . TEXT_PRODUCTS_PRICE_INFO . '</b> <span class="oldPrice">' . $currencies->format($oosPrice) . '</span> - ' . TEXT_TAX_INFO . '<span class="oldPrice">' . $currencies->format($oosPriceNetto) . '</span>');
$contents[] = array('text' => '<b>' . TEXT_PRODUCTS_PRICE_INFO . '</b> <span class="specialPrice">' . $currencies->format($oosSpecialsPrice) . '</span> - ' . TEXT_TAX_INFO . '<span class="specialPrice">' . $currencies->format($oosSpecialsPriceNetto) . '</span>');
$contents[] = array('text' => '' . TEXT_INFO_PERCENTAGE . ' ' . number_format(100 - $oosSpecialsPrice / $oosPrice * 100) . '%');
if (date('Y-m-d') < $specials['expires_date']) {
$contents[] = array('text' => '' . TEXT_INFO_EXPIRES_DATE . ' <b>' . oos_date_short($specials['expires_date']) . '</b>');
}
} else {
$contents[] = array('text' => '<br /><b>' . TEXT_PRODUCTS_PRICE_INFO . '</b> ' . $currencies->format($oosPrice) . ' - ' . TEXT_TAX_INFO . $currencies->format($oosPriceNetto));
}
$contents[] = array('text' => '' . CAT_LIST_PRICE_TEXT . $currencies->format($oosPriceList) . ' - ' . TEXT_TAX_INFO . $currencies->format($oosPriceListNetto) . '<br /><br /><b>' . TEXT_PRODUCTS_DISCOUNT_ALLOWED . '</b> ' . number_format($pInfo->products_discount_allowed, 2) . '%<br /><br />' . TEXT_PRODUCTS_QUANTITY_INFO . ' ' . $pInfo->products_quantity . CAT_QUANTITY_MIN_TEXT . $pInfo->products_quantity_order_min . CAT_QUANTITY_UNITS_TEXT . $pInfo->products_quantity_order_units);
if ($pInfo->products_discount1_qty > 0) {
$oosDiscount1 = $pInfo->products_discount1;
if (OOS_PRICE_IS_BRUTTO == '1') {
$oosDiscount1Netto = round($oosDiscount1, TAX_DECIMAL_PLACES);
$oosDiscount1 = $oosDiscount1 * ($tax[tax_rate] + 100) / 100;
}
$oosDiscount1 = round($oosDiscount1, TAX_DECIMAL_PLACES);
$contents[] = array('text' => '<br /><br /><b>' . TEXT_DISCOUNTS_TITLE . ':</b>');
$contents[] = array('text' => ' ' . ($pInfo->products_discount1_qty < 10 ? ' ' : '') . $pInfo->products_discount1_qty . ' ' . $currencies->format($oosDiscount1) . ' - ' . TEXT_TAX_INFO . $currencies->format($oosDiscount1Netto));
}
<tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<?php
switch ($srView) {
case '3':
?>
<td class="dataTableContent" align="right"><?php echo oos_date_long(date("Y-m-d\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\ H:i:s", $sr->showDateEnd)); ?></td>
<?php
break;
case '4':
?>
<td class="dataTableContent" align="right"><?php echo oos_date_long(date("Y-m-d\ H:i:s", $sr->showDate)); ?></td>
<?php
break;
default;
?>
<td class="dataTableContent" align="right"><?php echo oos_date_short(date("Y-m-d\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\ H:i:s", $sr->showDateEnd)); ?></td>
<?php
}
?>
<td class="dataTableContent" align="right"><?php echo $info[0]['order']; ?></td>
<td class="dataTableContent" align="right"><?php echo $info[$last - 1]['totitem']; ?></td>
<td class="dataTableContent" align="right"><?php echo $currencies->format($info[$last - 1]['totsum']);?></td>
<td class="dataTableContent" align="right"><?php echo $currencies->format($info[0]['shipping']);?></td>
</tr>
<?php
} else {
// csv export
echo date(DATE_FORMAT, $sr->showDate) . SR_SEPARATOR1 . date(DATE_FORMAT, $sr->showDateEnd) . SR_SEPARATOR1;
echo $info[0]['order'] . SR_SEPARATOR1;
echo $info[$last - 1]['totitem'] . SR_SEPARATOR1;
echo $currencies->format($info[$last - 1]['totsum']) . SR_SEPARATOR1;
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image(OOS_IMAGES . 'graphs/banner_infobox-' . $banner_id . '.' . $banner_extension));
} else {
include 'includes/functions/function_graphs.php';
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_banner_graph_info_box($bInfo->banners_id, '3'));
}
$contents[] = array('text' => oos_image(OOS_IMAGES . 'graph_hbar_blue.gif', 'Blue', '5', '5') . ' ' . TEXT_BANNERS_BANNER_VIEWS . '<br />' . oos_image(OOS_IMAGES . 'graph_hbar_red.gif', 'Red', '5', '5') . ' ' . TEXT_BANNERS_BANNER_CLICKS);
if ($bInfo->date_scheduled) {
$contents[] = array('text' => '<br />' . sprintf(TEXT_BANNERS_SCHEDULED_AT_DATE, oos_date_short($bInfo->date_scheduled)));
}
if ($bInfo->expires_date) {
$contents[] = array('text' => '<br />' . sprintf(TEXT_BANNERS_EXPIRES_AT_DATE, oos_date_short($bInfo->expires_date)));
} elseif ($bInfo->expires_impressions) {
$contents[] = array('text' => '<br />' . sprintf(TEXT_BANNERS_EXPIRES_AT_IMPRESSIONS, $bInfo->expires_impressions));
}
if ($bInfo->date_status_change) {
$contents[] = array('text' => '<br />' . sprintf(TEXT_BANNERS_STATUS_CHANGE, oos_date_short($bInfo->date_status_change)));
}
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
<?php
AND ot.class = 'ot_total'";
$orders_result = $dbconn->Execute($orders_sql);
$orders = $orders_result->fields;
// If we got a match, create the table entry to display the information
if (isset($orders) && !empty($orders)) {
$custknt++;
$total_recovered += $orders['value'];
$custknt % 2 ? $class = RCS_REPORT_EVEN_STYLE : $class = RCS_REPORT_ODD_STYLE;
$custlist .= '<tr class="' . $class . '">' .
'<td class="datatablecontent" align="right">' . $inrec['recovercartsales_id'] . '</td>' .
'<td> </td>' .
'<td class="datatablecontent" align="center">' . oos_date_order_stat($inrec['recovercartsales_date_added']) . '</td>' .
'<td> </td>' .
'<td class="datatablecontent"><a href="' . oos_href_link_admin($aFilename['customers'], 'search=' . $crec['customers_lastname'], 'NONSSL') . '">' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '</a></td>' .
'<td class="datatablecontent">' . oos_date_short($orders['date_purchased']) . '</td>' .
'<td class="datatablecontent" align="center">' . $orders['orders_status_name'] . '</td>' .
'<td class="datatablecontent" align="right">' . strip_tags($orders['order_total']) . '</td>' .
'<td> </td>'.
'</tr>';
}
// Move that ADOdb pointer!
$result->MoveNext();
}
// Close result set
$result->Close();
$cline = "<tr><td height=\"15\" COLSPAN=8> </td></tr>".
"<tr>".
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br /><br /><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
if (STOCK_CHECK == '1') {
$contents[] = array('text' => '<br />' . oos_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
}
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete','delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '">' . oos_image_swap_button('cancel','cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($oInfo) && is_object($oInfo)) {
$heading[] = array('text' => '<b>[' . $oInfo->orders_id . '] ' . oos_datetime_short($oInfo->date_purchased) . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '">' . oos_image_swap_button('edit','edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '">' . oos_image_swap_button('delete','delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['invoice'], 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . oos_image_swap_button('invoice','invoice_off.gif', IMAGE_ORDERS_INVOICE) . '</a> <a href="' . oos_href_link_admin($aFilename['packingslip'], 'oID=' . $oInfo->orders_id) . '" TARGET="_blank">' . oos_image_swap_button('packingslip','packingslip_off.gif', IMAGE_ORDERS_PACKINGSLIP) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_DATE_ORDER_CREATED . ' ' . oos_date_short($oInfo->date_purchased));
if (!empty($oInfo->last_modified)) $contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . oos_date_short($oInfo->last_modified));
$contents[] = array('text' => '<br />' . TEXT_INFO_PAYMENT_METHOD . ' ' . $oInfo->payment_method);
}
break;
}
if ( (!empty($heading)) && (!empty($contents) ) ) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
}
}
if (TICKET_USE_ORDER_IDS == '1' && isset($_SESSION['customer_id'])) {
$orders_id = array();
$orders_values = array();
$orderstable = $oostable['orders'];
$sql = "SELECT orders_id, date_purchased\n FROM {$orderstable}\n WHERE customers_id= '" . intval($_SESSION['customer_id']) . "'";
$customers_orders_result = $dbconn->Execute($sql);
if (isset($_GET['ticket_order_id'])) {
$ticket_preselected_order_id = oos_var_prep_for_os($_GET['ticket_order_id']);
}
$orders_id[] = '';
$orders_values[] = ' --- ';
while ($customers_orders = $customers_orders_result->fields) {
$orders_id[] = $customers_orders['orders_id'];
$orders_values[] = $customers_orders['orders_id'] . " (" . oos_date_short($customers_orders['date_purchased']) . ")";
$customers_orders_result->MoveNext();
}
}
// links breadcrumb
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['ticket_create']), bookmark);
$aOption['template_main'] = $sTheme . '/modules/ticket_create.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['breadcrumb'] = 'default/system/breadcrumb.html';
$nPageType = OOS_PAGE_TYPE_SERVICE;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
}
// assign Smarty variables;
switch ($coupon['coupon_type']) {
case 'F':
$text_coupon_help .= sprintf($aLang['text_coupon_help_fixed'], $oCurrencies->format($coupon['coupon_amount']));
break;
case 'P':
$text_coupon_help .= sprintf($aLang['text_coupon_help_fixed'], number_format($coupon['coupon_amount'], 2) . '%');
break;
case 'S':
$text_coupon_help .= $aLang['text_coupon_help_freeship'];
break;
default:
}
if ($coupon['coupon_minimum_order'] > 0) {
$text_coupon_help .= sprintf($aLang['text_coupon_help_minorder'], $oCurrencies->format($coupon['coupon_minimum_order']));
}
$text_coupon_help .= sprintf($aLang['text_coupon_help_date'], oos_date_short($coupon['coupon_start_date']), oos_date_short($coupon['coupon_expire_date']));
$text_coupon_help .= '<b>' . $aLang['text_coupon_help_restrict'] . '</b>';
$text_coupon_help .= '<br /><br />' . $aLang['text_coupon_help_categories'];
$couponstable = $oostable['coupons'];
$sql = "SELECT restrict_to_categories\n FROM {$couponstable}\n WHERE coupon_id = '" . intval($nCouponID) . "'";
$coupon_get = $dbconn->Execute($sql);
$get_result = $coupon_get->fields;
$cat_ids = preg_split("/[,]/", $get_result['restrict_to_categories']);
for ($i = 0; $i < count($cat_ids); $i++) {
$categoriestable = $oostable['categories'];
$categories_descriptiontable = $oostable['categories_description'];
$sql = "SELECT c.categories_id, c.categories_status, cd.categories_name\n FROM {$categoriestable} c,\n {$categories_descriptiontable} cd\n WHERE c.categories_status = '1'\n AND c.categories_id = cd.categories_id\n AND cd.categories_languages_id = '" . intval($nLanguageID) . "'\n AND cd.categories_id = '" . oos_db_input($cat_ids[$i]) . "'";
$result = $dbconn->Execute($sql);
if ($row = $result->fields) {
$cats .= '<br />' . $row["categories_name"];
}
?>
</td>
<?php
break;
case '4':
?>
<td class="dataTableContent" align="right"><?php
echo oos_date_long(date("Y-m-d\\ H:i:s", $sr->showDate));
?>
</td>
<?php
break;
default:
?>
<td class="dataTableContent" align="right"><?php
echo oos_date_short(date("Y-m-d\\ H:i:s", $sr->showDate)) . " - " . oos_date_short(date("Y-m-d\\ H:i:s", $sr->showDateEnd));
?>
</td>
<?php
}
?>
<td class="dataTableContent" align="right"><?php
echo $info[0]['order'];
?>
</td>
<td class="dataTableContent" align="right"><?php
echo $info[$last - 1]['totitem'];
?>
</td>
<td class="dataTableContent" align="right"><?php
echo $currencies->format($info[$last - 1]['totsum']);
if (!$product_info_result->RecordCount()) MyOOS_CoreApi::redirect(oos_href_link($aPages['reviews']));
$product_info = $product_info_result->fields;
$reviewstable = $oostable['reviews'];
$sql = "SELECT reviews_rating, reviews_id, customers_name, date_added, reviews_read
FROM $reviewstable
WHERE products_id = '" . intval($nProductsId) . "'
ORDER BY reviews_id DESC";
$reviews_result = $dbconn->Execute($sql);
$aReviews = array();
while ($reviews = $reviews_result->fields)
{
$aReviews[] = array('rating' => $reviews['reviews_rating'],
'id' => $reviews['reviews_id'],
'customers_name' => $reviews['customers_name'],
'date_added' => oos_date_short($reviews['date_added']),
'read' => $reviews['reviews_read']);
$reviews_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($product_info['products_name'], oos_href_link($aPages['product_info'], 'categories=' . $categories . '&products_id=' . $nProductsId));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aPages['product_reviews'], $get_params), bookmark);
$aOption['template_main'] = $sTheme . '/modules/product_reviews.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['page_navigation'] = $sTheme . '/heading/page_navigation.html';
$aOption['breadcrumb'] = 'default/system/breadcrumb.html';
$nPageType = OOS_PAGE_TYPE_REVIEWS;
$get_params = oos_get_all_get_parameters(array('reviews_id'));
$get_params = oos_remove_trailing($get_params);
$productstable = $oostable['products'];
$products_descriptiontable = $oostable['products_description'];
$sql = "SELECT pd.products_name, p.products_model\n FROM {$products_descriptiontable} pd LEFT JOIN\n {$productstable} p ON pd.products_id = p.products_id\n WHERE pd.products_languages_id = '" . intval($nLanguageID) . "'\n AND p.products_status >= '1'\n AND pd.products_id = '" . intval($nProductsId) . "'";
$product_info_result = $dbconn->Execute($sql);
if (!$product_info_result->RecordCount()) {
oos_redirect(oos_href_link($aModules['reviews'], $aFilename['reviews_reviews']));
}
$product_info = $product_info_result->fields;
$reviewstable = $oostable['reviews'];
$sql = "SELECT reviews_rating, reviews_id, customers_name, date_added, reviews_read\n FROM {$reviewstable}\n WHERE products_id = '" . intval($nProductsId) . "'\n ORDER BY reviews_id DESC";
$reviews_result = $dbconn->Execute($sql);
$aReviews = array();
while ($reviews = $reviews_result->fields) {
$aReviews[] = array('rating' => $reviews['reviews_rating'], 'id' => $reviews['reviews_id'], 'customers_name' => $reviews['customers_name'], 'date_added' => oos_date_short($reviews['date_added']), 'read' => $reviews['reviews_read']);
$reviews_result->MoveNext();
}
// links breadcrumb
$oBreadcrumb->add($product_info['products_name'], oos_href_link($aModules['products'], $aFilename['product_info'], 'categories=' . $categories . '&products_id=' . $nProductsId));
$oBreadcrumb->add($aLang['navbar_title'], oos_href_link($aModules['reviews'], $aFilename['product_reviews'], $get_params));
$aOption['template_main'] = $sTheme . '/modules/product_reviews.html';
$aOption['page_heading'] = $sTheme . '/heading/page_heading.html';
$aOption['page_navigation'] = $sTheme . '/heading/page_navigation.html';
$nPageType = OOS_PAGE_TYPE_REVIEWS;
require 'includes/oos_system.php';
if (!isset($option)) {
require 'includes/info_message.php';
require 'includes/oos_blocks.php';
require 'includes/oos_counter.php';
}
$contents = array('form' => oos_draw_form('newsletters', $aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $nInfo->title . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($nInfo) && is_object($nInfo)) {
$heading[] = array('text' => '<b>' . $nInfo->title . '</b>');
if ($nInfo->locked > 0) {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=new') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . oos_image_swap_button('preview', 'preview_off.gif', IMAGE_PREVIEW) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=send') . '">' . oos_image_swap_button('send', 'send_off.gif', IMAGE_SEND) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=unlock') . '">' . oos_image_swap_button('unlock', 'unlock_off.gif', IMAGE_UNLOCK) . '</a>');
} else {
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=preview') . '">' . oos_image_swap_button('preview', 'preview_off.gif', IMAGE_PREVIEW) . '</a> <a href="' . oos_href_link_admin($aFilename['newsletters'], 'page=' . $_GET['page'] . '&nID=' . $nInfo->newsletters_id . '&action=lock') . '">' . oos_image_swap_button('lock', 'lock_off.gif', IMAGE_LOCK) . '</a>');
}
$contents[] = array('text' => '<br />' . TEXT_NEWSLETTER_DATE_ADDED . ' ' . oos_date_short($nInfo->date_added));
if ($nInfo->status == '1') {
$contents[] = array('text' => TEXT_NEWSLETTER_DATE_SENT . ' ' . oos_date_short($nInfo->date_sent));
}
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
<?php
$heading = array();
$contents = array();
$heading[] = array('text' => '[' . $gInfo->coupon_id . '] ' . ' ' . $currencies->format($gInfo->coupon_amount));
$redeem_result = $dbconn->Execute("SELECT * FROM " . $oostable['coupon_redeem_track'] . " WHERE coupon_id = '" . $gInfo->coupon_id . "'");
$redeemed = 'No';
if ($redeem_result->RecordCount() > 0) {
$redeemed = 'Yes';
}
$contents[] = array('text' => TEXT_INFO_SENDERS_ID . ' ' . $gInfo->customer_id_sent);
$contents[] = array('text' => TEXT_INFO_AMOUNT_SENT . ' ' . $currencies->format($gInfo->coupon_amount));
$contents[] = array('text' => TEXT_INFO_DATE_SENT . ' ' . oos_date_short($gInfo->date_sent));
$contents[] = array('text' => TEXT_INFO_VOUCHER_CODE . ' ' . $gInfo->coupon_code);
$contents[] = array('text' => TEXT_INFO_EMAIL_ADDRESS . ' ' . $gInfo->emailed_to);
if ($redeemed == 'Yes') {
$redeem = $redeem_result->fields;
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_REDEEMED . ' ' . oos_date_short($redeem['redeem_date']));
$contents[] = array('text' => TEXT_INFO_IP_ADDRESS . ' ' . $redeem['redeem_ip']);
$contents[] = array('text' => TEXT_INFO_CUSTOMERS_ID . ' ' . $redeem['customer_id']);
} else {
$contents[] = array('text' => '<br />' . TEXT_INFO_NOT_REDEEMED);
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $cInfo->title . '</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . ($remove_currency ? '<a href="' . oos_href_link_admin($aFilename['currencies'], 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=deleteconfirm') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>' : '') . ' <a href="' . oos_href_link_admin($aFilename['currencies'], 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($cInfo) && is_object($cInfo)) {
$heading[] = array('text' => '<b>' . $cInfo->title . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['currencies'], 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['currencies'], 'page=' . $_GET['page'] . '&cID=' . $cInfo->currencies_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_CURRENCY_TITLE . ' ' . $cInfo->title);
$contents[] = array('text' => TEXT_INFO_CURRENCY_CODE . ' ' . $cInfo->code);
$contents[] = array('text' => '<br />' . TEXT_INFO_CURRENCY_SYMBOL_LEFT . ' ' . $cInfo->symbol_left);
$contents[] = array('text' => TEXT_INFO_CURRENCY_SYMBOL_RIGHT . ' ' . $cInfo->symbol_right);
$contents[] = array('text' => '<br />' . TEXT_INFO_CURRENCY_DECIMAL_POINT . ' ' . $cInfo->decimal_point);
$contents[] = array('text' => TEXT_INFO_CURRENCY_THOUSANDS_POINT . ' ' . $cInfo->thousands_point);
$contents[] = array('text' => TEXT_INFO_CURRENCY_DECIMAL_PLACES . ' ' . $cInfo->decimal_places);
$contents[] = array('text' => '<br />' . TEXT_INFO_CURRENCY_LAST_UPDATED . ' ' . oos_date_short($cInfo->last_updated));
$contents[] = array('text' => TEXT_INFO_CURRENCY_VALUE . ' ' . number_format($cInfo->value, 8));
$contents[] = array('text' => '<br />' . TEXT_INFO_CURRENCY_EXAMPLE . '<br />' . $currencies->format('30', false, DEFAULT_CURRENCY) . ' = ' . $currencies->format('30', true, $cInfo->code));
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
$contents[] = array('text' => '<br />' . TEXT_INFO_TAX_RATE_PRIORITY . '<br />' . oos_draw_input_field('tax_priority', $trInfo->tax_priority));
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('update', 'update_off.gif', IMAGE_UPDATE) . ' <a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_TAX_RATE . '</b>');
$contents = array('form' => oos_draw_form('rates', $aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
$contents[] = array('text' => '<br /><b>' . $trInfo->tax_class_title . ' ' . number_format($trInfo->tax_rate, TAX_DECIMAL_PLACES) . '%</b>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
if (isset($trInfo) && is_object($trInfo)) {
$heading[] = array('text' => '<b>' . $trInfo->tax_class_title . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['tax_rates'], 'page=' . $_GET['page'] . '&tID=' . $trInfo->tax_rates_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_ADDED . ' ' . oos_date_short($trInfo->date_added));
$contents[] = array('text' => '' . TEXT_INFO_LAST_MODIFIED . ' ' . oos_date_short($trInfo->last_modified));
$contents[] = array('text' => '<br />' . TEXT_INFO_RATE_DESCRIPTION . '<br />' . $trInfo->tax_description);
}
break;
}
if (oos_is_not_null($heading) && oos_is_not_null($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
</table></td>
<td class="smallText" align="right"><?php
echo $products_split->display_links($products_result_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']);
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
if (isset($pInfo) && is_object($pInfo)) {
$heading[] = array('text' => '<b>' . $pInfo->products_name . '</b>');
$categories = oos_get_product_path($pInfo->products_id);
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['categories'], 'pID=' . $pInfo->products_id . '&categories=' . $categories . '&action=new_product') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_INFO_DATE_EXPECTED . ' ' . oos_date_short($pInfo->products_date_available));
}
if (!empty($heading) && !empty($contents)) {
echo ' <td width="25%" valign="top">' . "\n";
$box = new box();
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
?>
</tr>
</table></td>
</tr>
</table></td>
<!-- body_text_eof //-->
</tr>
</table>
}
$coupon_name_result = $dbconn->Execute("SELECT coupon_name
FROM " . $oostable['coupons_description'] . "
WHERE coupon_id = '" . $cInfo->coupon_id . "' AND
coupon_languages_id = '" . intval($_SESSION['language_id']) . "'");
$coupon_name = $coupon_name_result->fields;
$contents[] = array('text'=>COUPON_NAME . ' :: ' . $coupon_name['coupon_name'] . '<br />' .
COUPON_AMOUNT . ' :: ' . $amount . '<br />' .
COUPON_STARTDATE . ' :: ' . oos_date_short($cInfo->coupon_start_date) . '<br />' .
COUPON_FINISHDATE . ' :: ' . oos_date_short($cInfo->coupon_expire_date) . '<br />' .
COUPON_USES_COUPON . ' :: ' . $cInfo->uses_per_coupon . '<br />' .
COUPON_USES_USER . ' :: ' . $cInfo->uses_per_user . '<br />' .
COUPON_PRODUCTS . ' :: ' . $prod_details . '<br />' .
COUPON_CATEGORIES . ' :: ' . $cat_details . '<br />' .
DATE_CREATED . ' :: ' . oos_date_short($cInfo->date_created) . '<br />' .
DATE_MODIFIED . ' :: ' . oos_date_short($cInfo->date_modified) . '<br /><br />' .
'<center><a href="' . oos_href_link_admin($aFilename['coupon_admin'],'action=email&cID='.$cInfo->coupon_id,'NONSSL').'">'.oos_image_swap_button('email', 'email_off.gif', 'Email Voucher').'</a>' .
'<a href="' . oos_href_link_admin($aFilename['coupon_admin'],'action=voucheredit&cID='.$cInfo->coupon_id,'NONSSL').'">'.oos_image_swap_button('edit', 'edit_off.gif', 'Edit Voucher').'</a>' .
'<a href="' . oos_href_link_admin($aFilename['coupon_admin'],'action=voucherdelete&cID='.$cInfo->coupon_id,'NONSSL').'">'.oos_image_swap_button('delete', 'delete_off.gif', 'Delete Voucher').'</a>' .
'<br /><a href="' . oos_href_link_admin($aFilename['coupon_admin'],'action=voucherreport&cID='.$cInfo->coupon_id,'NONSSL').'">'.oos_image_swap_button('report', 'report_off.gif', 'Voucher Report').'</a></center>'
);
}
break;
}
?>
<td width="25%" valign="top">
<?php
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' </td>' . "\n";
}
