default:
$customer_status = oos_get_customers_status ($cID);
$cs_id = $customer_status['customers_status'];
$cs_name = $customer_status['customers_status_name'];
$cs_image = $customer_status['customers_status_image'];
$cs_discount = $customer_status['customers_status_discount'];
$cs_ot_discount_flag = $customer_status['customers_status_ot_discount_flag'];
$cs_ot_discount = $customer_status['customers_status_ot_discount'];
$cs_qty_discounts = $customer_status['customers_status_qty_discounts'];
$cs_payment = $customer_status['customers_status_payment'];
if (isset($cInfo) && is_object($cInfo)) {
$heading[] = array('text' => '<b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
$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);
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<?php
if ($messageStack->size > 0) {
echo $messageStack->output();
}
?>
<table border="0" width="600" height="100%" cellspacing="0" cellpadding="0" align="center" valign="middle">
<tr>
<td><table border="0" width="600" height="440" cellspacing="0" cellpadding="1" align="center" valign="middle">
<tr bgcolor="#000000">
<td><table border="0" width="600" height="440" cellspacing="0" cellpadding="0">
<tr bgcolor="#ffffff" height="50">
<td height="50"></td>
<td align="right" class="text" nowrap><?php
echo '<a href="' . oos_href_link_admin($aFilename['default']) . '">' . HEADER_TITLE_ADMINISTRATION . '</a> | <a href="' . oos_catalog_link($aCatalogPage['default']) . '">' . HEADER_TITLE_ONLINE_CATALOG . '</a> | <a href="http://www.oos-shop.de/" target="_blank">' . HEADER_TITLE_SUPPORT_SITE . '</a>';
?>
</td>
</tr>
<tr bgcolor="#8C8E8F">
<td colspan="2"><table border="0" width="460" height="390" cellspacing="0" cellpadding="2">
<tr>
<td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2">
<tr>
<td valign="center">
<?php
$heading = array();
$contents = array();
$heading[] = array('params' => 'class="menuBoxHeading"', 'text' => 'OSIS online Shop');
$contents[] = array('params' => 'class="infoBox"', 'text' => '<a href="http://www.oos-shop.de/" target="_blank">' . BOX_ENTRY_HAMPEAGE . '</a><br />' . '<a href="http://developer.berlios.de/mail/?group_id=814" target="_blank">' . BOX_ENTRY_MAILING_LISTS . '</a><br />' . '<a href="http://foren.myoos.de/" target="_blank">Support Board</a><br />');
$box = new box();
if ($no_js_general == '1') {
?>
<link rel="StyleSheet" href="includes/stylesheet.css" type="text/css" >
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<?php
} else {
?>
<script type="text/javascript" src="includes/general.js"></script>
<link rel="StyleSheet" href="includes/stylesheet.css" type="text/css" >
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">
<?php
}
?>
<?php
if ($messageStack->size > 0) {
echo $messageStack->output();
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td align="right"><?php echo '<a href="http://www.oos-shop.de/" target="_blank">' . oos_image(OOS_IMAGES . 'support.png', HEADER_TITLE_SUPPORT_SITE, '50', '50') . '</a> <a href="' . oos_catalog_link($aCatalogPage['default']) . '">' . oos_image(OOS_IMAGES . 'checkout.png', HEADER_TITLE_ONLINE_CATALOG, '50', '50') . '</a> <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '">' . oos_image(OOS_IMAGES . 'administration.png', HEADER_TITLE_ADMINISTRATION, '50', '50') . '</a>'; ?> </td>
</tr>
<tr class="headerBar">
<td class="headerBarContent"> <?php if (isset($_SESSION['login_id'])) { echo '<a href="' . oos_href_link_admin($aFilename['admin_account'], '', 'SSL') . '" class="headerLink">' . HEADER_TITLE_ACCOUNT . '</a> | <a href="' . oos_href_link_admin($aFilename['logoff'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_LOGOFF . '</a>'; } else { echo '<a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_TOP . '</a>'; }?></td>
<td class="headerBarContent" align="right"><?php echo '<a href="http://www.oos-shop.de/" class="headerLink">' . HEADER_TITLE_SUPPORT_SITE . '</a> | <a href="' . oos_catalog_link($aCatalogPage['default']) . '" class="headerLink">' . HEADER_TITLE_ONLINE_CATALOG . '</a> | <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_ADMINISTRATION . '</a>'; ?> </td>
</tr>
</table>
/**
* Output a login form
*
* @param $name
* @param $modul
* @param $page
* @param $parameters
* @param $method
* @param $params
* @return string
*/
function oos_draw_login_form($name, $page, $parameters = '', $method = 'post', $params = '') {
$loginform = '<form name="' . $name . '" action="';
if ($parameters) {
$loginform .= oos_catalog_link($page, $parameters);
} else {
$loginform .= oos_catalog_link($page, $parameters);
}
$loginform .= '" method="' . $method . '"';
if ($params) {
$loginform .= ' ' . $params;
}
$loginform .= '>';
return $loginform;
}
if (RCS_EMAIL_FRIENDLY == '1'){
$email .= EMAIL_TEXT_SALUTATION . $inrec['fname'] . ',';
} else {
$email .= STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n";
}
if ($result3->RecordCount() < 1) {
$email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline);
} else {
$email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline);
}
$email .= EMAIL_TEXT_BODY_HEADER . $mline . EMAIL_TEXT_BODY_FOOTER;
if (EMAIL_USE_HTML == '1') {
$email .= '<a href="' . oos_catalog_link($aCatalogPage['default']) . '">' . STORE_OWNER . "\n" . OOS_HTTP_SERVER . OOS_SHOP . '</a>';
} else {
$email .= STORE_OWNER . "\n" . OOS_HTTP_SERVER . OOS_SHOP;
}
$email .= "\n\n" . $_POST['message'];
$custname = $inrec['fname'] . ' ' . $inrec['lname'];
$outEmailAddr = '"' . $custname . '" <' . $inrec['email'] . '>';
if (oos_is_not_null(RCS_EMAIL_COPIES_TO)) {
$outEmailAddr .= ', ' . RCS_EMAIL_COPIES_TO;
}
oos_mail($custname, $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$mline = '';
}
$UpdateOrders .= " where orders_id = '" . oos_db_input($oID) . "';";
$dbconn->Execute($UpdateOrders);
$order_updated = true;
$check_status_result = $dbconn->Execute("select customers_name, customers_email_address, orders_status, date_purchased from " . $oostable['orders'] . " where orders_id = '" . (int) $oID . "'");
$check_status = $check_status_result->fields;
// Update Status History & Email Customer if Necessary
if ($order->info['orders_status'] != $status) {
// Notify Customer
$customer_notified = '0';
if (isset($_POST['notify']) && $_POST['notify'] == 'on') {
$notify_comments = '';
if (isset($_POST['notify_comments']) && $_POST['notify_comments'] == 'on') {
$notify_comments = sprintf(EMAIL_TEXT_COMMENTS_UPDATE, $comments) . "\n\n";
}
$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . oos_catalog_link($aFilename['catalog_account_history_info'], 'order_id=' . $oID, 'SSL') . "\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . oos_date_long($check_status['date_purchased']) . "\n\n" . $notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]);
oos_mail($check_status['customers_name'], $check_status['customers_email_address'], EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$customer_notified = '1';
}
// "Status History" table has gone through a few
// different changes, so here are different versions of
// the status update.
// NOTE: Theoretically, there shouldn't be a
// orders_status field in the ORDERS table. It
// should really just use the latest value from
// this status history table.
if ($CommentsWithStatus) {
$dbconn->Execute("insert into " . $oostable['orders_status_history'] . "\n (orders_id, orders_status_id, date_added, customer_notified, comments)\n values ('" . oos_db_input($oID) . "', '" . oos_db_input($status) . "', '" . date("Y-m-d H:i:s", time()) . "', " . oos_db_input($customer_notified) . ", '" . oos_db_input($comments) . "')");
} else {
if ($OldNewStatusValues) {
$dbconn->Execute("insert into " . $oostable['orders_status_history'] . "\n (orders_id, new_value, old_value, date_added, customer_notified)\n values ('" . oos_db_input($oID) . "', '" . oos_db_input($status) . "', '" . $order->info['orders_status'] . "', '" . date("Y-m-d H:i:s", time()) . "', " . oos_db_input($customer_notified) . ")");
// 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;
echo $currencies->format($info[0]['shipping']) . SR_NEWLINE;
}
if ($srDetail) {
for ($i = 0; $i < $last; $i++) {
if ($srMax == 0 or $i < $srMax) {
if ($srExp < 2) {
?>
<tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<td class="dataTableContent"> </td>
<td class="dataTableContent" align="left"><a href="<?php
echo oos_catalog_link($aCatalogPage['product_info'], 'products_id=' . $info[$i]['pid']);
?>
" target="_blank"><?php
echo $info[$i]['pname'];
?>
</a>
<?php
if (is_array($info[$i]['attr'])) {
$attr_info = $info[$i]['attr'];
foreach ($attr_info as $attr) {
echo '<div style="font-style:italic;"> ' . $attr['quant'] . 'x ';
// $attr['options'] . ': '
$flag = 0;
foreach ($attr['options_values'] as $value) {
if ($flag > 0) {
echo "," . $value;
$email .= ' (' . oos_catalog_link($oosModules['user'], $oosCatalogFilename['user_login'], '', 'SSL') . ')';
}
$email .= "\n" . EMAIL_SEPARATOR . "\n\n";
if (RCS_EMAIL_FRIENDLY == '1') {
$email .= EMAIL_TEXT_SALUTATION . $inrec['fname'] . ',';
} else {
$email .= STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n";
}
if ($result3->RecordCount() < 1) {
$email .= sprintf(EMAIL_TEXT_NEWCUST_INTRO, $mline);
} else {
$email .= sprintf(EMAIL_TEXT_CURCUST_INTRO, $mline);
}
$email .= EMAIL_TEXT_BODY_HEADER . $mline . EMAIL_TEXT_BODY_FOOTER;
if (EMAIL_USE_HTML == '1') {
$email .= '<a href="' . oos_catalog_link($oosModules['main'], $oosCatalogFilename['default']) . '">' . STORE_OWNER . "\n" . OOS_HTTP_SERVER . OOS_SHOP . '</a>';
} else {
$email .= STORE_OWNER . "\n" . OOS_HTTP_SERVER . OOS_SHOP;
}
$email .= "\n\n" . $_POST['message'];
$custname = $inrec['fname'] . ' ' . $inrec['lname'];
$outEmailAddr = '"' . $custname . '" <' . $inrec['email'] . '>';
if (oos_is_not_null(RCS_EMAIL_COPIES_TO)) {
$outEmailAddr .= ', ' . RCS_EMAIL_COPIES_TO;
}
oos_mail($custname, $outEmailAddr, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$mline = '';
// See if a record for this customer already exists; if not create one and if so update it
$recovercartsalestable = $oostable['recovercartsales'];
$done_result = $dbconn->Execute("SELECT customers_id FROM {$recovercartsalestable} WHERE customers_id = '" . $cid . "'");
if ($done_result->RecordCount() == 0) {
// 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;
echo $currencies->format($info[0]['shipping']) . SR_NEWLINE;
}
if ($srDetail) {
for ($i = 0; $i < $last; $i++) {
if ($srMax == 0 or $i < $srMax) {
if ($srExp < 2) {
?>
<tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<td class="dataTableContent"> </td>
<td class="dataTableContent" align="left"><a href="<?php
echo oos_catalog_link($oosModules['products'], $oosCatalogFilename['product_info'], 'products_id=' . $info[$i]['pid']);
?>
" target="_blank"><?php
echo $info[$i]['pname'];
?>
</a>
<?php
if (is_array($info[$i]['attr'])) {
$attr_info = $info[$i]['attr'];
foreach ($attr_info as $attr) {
echo '<div style="font-style:italic;"> ' . $attr['quant'] . 'x ';
// $attr['options'] . ': '
$flag = 0;
foreach ($attr['options_values'] as $value) {
if ($flag > 0) {
echo "," . $value;
}
?>
<script language="javascript" src="includes/menu.js"></script>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td></td>
<td align="right"><?php
echo '<a href="http://www.oos-shop.de/" target="_blank">' . oos_image(OOS_IMAGES . 'support.png', HEADER_TITLE_SUPPORT_SITE, '50', '50') . '</a> <a href="' . oos_catalog_link($oosModules['main'], $oosCatalogFilename['default']) . '">' . oos_image(OOS_IMAGES . 'checkout.png', HEADER_TITLE_ONLINE_CATALOG, '50', '50') . '</a> <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '">' . oos_image(OOS_IMAGES . 'administration.png', HEADER_TITLE_ADMINISTRATION, '50', '50') . '</a>';
?>
</td>
</tr>
<tr class="headerBar">
<td class="headerBarContent"> <?php
if (isset($_SESSION['login_id'])) {
echo '<a href="' . oos_href_link_admin($aFilename['admin_account'], '', 'SSL') . '" class="headerLink">' . HEADER_TITLE_ACCOUNT . '</a> | <a href="' . oos_href_link_admin($aFilename['logoff'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_LOGOFF . '</a>';
} else {
echo '<a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_TOP . '</a>';
}
?>
</td>
<td class="headerBarContent" align="right"><?php
echo '<a href="http://www.oos-shop.de/" class="headerLink">' . HEADER_TITLE_SUPPORT_SITE . '</a> | <a href="' . oos_catalog_link($oosModules['main'], $oosCatalogFilename['default']) . '" class="headerLink">' . HEADER_TITLE_ONLINE_CATALOG . '</a> | <a href="' . oos_href_link_admin($aFilename['default'], '', 'NONSSL') . '" class="headerLink">' . HEADER_TITLE_ADMINISTRATION . '</a>';
?>
</td>
</tr>
</table>
<?php
if (MENU_DHTML == true) {
require 'includes/header_navigation.php';
}
// Check if Ticket exists
$ticket_tickettable = $oostable['ticket_ticket'];
$ticket_update_result = $dbconn->Execute("SELECT ticket_customers_email, ticket_customers_name, ticket_link_id FROM {$ticket_tickettable} WHERE ticket_id = '" . $tID . "'");
$ticket_update = $ticket_update_result->fields;
if (!$ticket_update['ticket_customers_email']) {
$error = true;
$messageStack->add_session(WARNING_TICKET_NOT_UPDATED . "AA", 'warning');
}
if ($error == false) {
$sql_data_array = array('ticket_id' => $tID, 'ticket_status_id' => $status, 'ticket_priority_id' => $priority, 'ticket_department_id' => $department, 'ticket_date_modified' => 'now()', 'ticket_customer_notified' => '0', 'ticket_edited_by' => $ticket_admin_array[$admin], 'ticket_comments' => $enquiry);
oos_db_perform($oostable['ticket_status_history'], $sql_data_array);
$sql_data_array = array('ticket_date_last_modified' => 'now()', 'ticket_status_id' => $status, 'ticket_priority_id' => $priority, 'ticket_department_id' => $department, 'ticket_login_required' => $ticket_login_required);
oos_db_perform($oostable['ticket_ticket'], $sql_data_array, 'update', 'ticket_id=\'' . $tID . '\'');
// Email Customer doesn't get the Message cause he should use the web
$ticket_email_subject = TICKET_EMAIL_SUBJECT . $subject;
$ticket_email_message = TICKET_EMAIL_message_HEADER . "\n\n" . oos_catalog_link($oosModules['ticket'], $oosCatalogFilename['ticket_view'], 'tlid=' . $ticket_update['ticket_link_id'], 'NONSSL', false, false) . "\n\n" . TICKET_EMAIL_message_FOOTER;
oos_mail($ticket_update['ticket_customers_name'], $ticket_update['ticket_customers_email'], $ticket_email_subject, nl2br($ticket_email_message), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$ticket_updated = true;
}
if ($ticket_updated) {
$messageStack->add_session(SUCCESS_TICKET_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_TICKET_NOT_UPDATED, 'warning');
}
oos_redirect_admin(oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('action')) . 'action=edit'));
break;
case 'deleteconfirm':
$tID = oos_db_prepare_input($_GET['tID']);
$ticket_tickettable = $oostable['ticket_ticket'];
$dbconn->Execute("DELETE FROM {$ticket_tickettable} WHERE ticket_id='" . $tID . "'");
oos_redirect_admin(oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action'))));
} 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;
echo $currencies->format($info[0]['shipping']) . SR_NEWLINE;
}
if ($srDetail) {
for ($i = 0; $i < $last; $i++) {
if ($srMax == 0 or $i < $srMax) {
if ($srExp < 2) {
?>
<tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'">
<td class="dataTableContent"> </td>
<td class="dataTableContent" align="left"><a href="<?php echo oos_catalog_link($aCatalogPage['product_info'], 'products_id=' . $info[$i]['pid']) ?>" target="_blank"><?php echo $info[$i]['pname']; ?></a>
<?php
if (is_array($info[$i]['attr'])) {
$attr_info = $info[$i]['attr'];
foreach ($attr_info as $attr) {
echo '<div style="font-style:italic;"> ' . $attr['quant'] . 'x ' ;
// $attr['options'] . ': '
$flag = 0;
foreach ($attr['options_values'] as $value) {
if ($flag > 0) {
echo "," . $value;
} else {
echo $value;
$flag = 1;
}
}
if (isset($_GET['sort_name'])) {
$search_queries_sortedtable = $oostable['search_queries_sorted'];
$pw_sql = "SELECT search_text, search_count FROM $search_queries_sortedtable ORDER BY search_text ASC" ;
} elseif (isset($_GET['sort_total'])) {
$search_queries_sortedtable = $oostable['search_queries_sorted'];
$pw_sql = "SELECT search_text, search_count FROM $search_queries_sortedtable ORDER BY search_count DESC" ;
} else {
$search_queries_sortedtable = $oostable['search_queries_sorted'];
$pw_sql = "SELECT search_text, search_count FROM $search_queries_sortedtable ORDER BY search_text ASC" ;
}
$result = $dbconn->Execute($pw_sql);
while ($sql_q_result = $result->fields) {
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php echo oos_catalog_link($aCatalogPage['advanced_search_result'], 'keywords=' . urlencode($sql_q_result['search_text']). '&search_in_description=1' ); ?>'" >
<td class="dataTableContent"><a target="_blank" href="<?php echo oos_catalog_link($aCatalogPage['advanced_search_result'], 'keywords=' . urlencode($sql_q_result['search_text']). '&search_in_description=1' ); ?>"><?php echo $sql_q_result['search_text']; ?></a></td>
<td class="dataTableContent"><?php echo $sql_q_result['search_count']; ?></td>
</tr>
<?php
// Move that ADOdb pointer!
$result->MoveNext();
}
?>
</td></tr></table>
<?php } ?>
</td>
</tr>
</table>
</td>
<!-- body_eof //-->
$pw_sql = "SELECT search_text, search_count FROM {$search_queries_sortedtable} ORDER BY search_count DESC";
break;
default:
$search_queries_sortedtable = $oostable['search_queries_sorted'];
$pw_sql = "SELECT search_text, search_count FROM {$search_queries_sortedtable} ORDER BY search_text ASC";
break;
}
$result = $dbconn->Execute($pw_sql);
while ($sql_q_result = $result->fields) {
?>
<tr class="dataTableRow" onmouseover="this.className='dataTableRowOver';this.style.cursor='hand'" onmouseout="this.className='dataTableRow'" onclick="document.location.href='<?php
echo oos_catalog_link($oosModules['search'], $aCatalogPage['advanced_search_result'], 'keywords=' . urlencode($sql_q_result['search_text']) . '&search_in_description=1');
?>
'" >
<td class="dataTableContent"><a target="_blank" href="<?php
echo oos_catalog_link($oosModules['search'], $aCatalogPage['advanced_search_result'], 'keywords=' . urlencode($sql_q_result['search_text']) . '&search_in_description=1');
?>
"><?php
echo $sql_q_result['search_text'];
?>
</a></td>
<td class="dataTableContent"><?php
echo $sql_q_result['search_count'];
?>
</td>
</tr>
<?php
// Move that ADOdb pointer!
$result->MoveNext();
}
// Close result set
// Check if Ticket exists
$ticket_tickettable = $oostable['ticket_ticket'];
$ticket_update_result = $dbconn->Execute("SELECT ticket_customers_email, ticket_customers_name, ticket_link_id FROM {$ticket_tickettable} WHERE ticket_id = '" . $tID . "'");
$ticket_update = $ticket_update_result->fields;
if (!$ticket_update['ticket_customers_email']) {
$error = true;
$messageStack->add_session(WARNING_TICKET_NOT_UPDATED . "AA", 'warning');
}
if ($error == false) {
$sql_data_array = array('ticket_id' => $tID, 'ticket_status_id' => $status, 'ticket_priority_id' => $priority, 'ticket_department_id' => $department, 'ticket_date_modified' => '" . date("Y-m-d H:i:s", time()) . "', 'ticket_customer_notified' => '0', 'ticket_edited_by' => $ticket_admin_array[$admin], 'ticket_comments' => $enquiry);
oos_db_perform($oostable['ticket_status_history'], $sql_data_array);
$sql_data_array = array('ticket_date_last_modified' => '" . date("Y-m-d H:i:s", time()) . "', 'ticket_status_id' => $status, 'ticket_priority_id' => $priority, 'ticket_department_id' => $department, 'ticket_login_required' => $ticket_login_required);
oos_db_perform($oostable['ticket_ticket'], $sql_data_array, 'update', 'ticket_id=\'' . $tID . '\'');
// Email Customer doesn't get the Message cause he should use the web
$ticket_email_subject = TICKET_EMAIL_SUBJECT . $subject;
$ticket_email_message = TICKET_EMAIL_message_HEADER . "\n\n" . oos_catalog_link($aCatalogPage['ticket_view'], 'tlid=' . $ticket_update['ticket_link_id'], 'NONSSL', false, false) . "\n\n" . TICKET_EMAIL_message_FOOTER;
oos_mail($ticket_update['ticket_customers_name'], $ticket_update['ticket_customers_email'], $ticket_email_subject, nl2br($ticket_email_message), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
$ticket_updated = true;
}
if ($ticket_updated) {
$messageStack->add_session(SUCCESS_TICKET_UPDATED, 'success');
} else {
$messageStack->add_session(WARNING_TICKET_NOT_UPDATED, 'warning');
}
oos_redirect_admin(oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('action')) . 'action=edit'));
break;
case 'deleteconfirm':
$tID = oos_db_prepare_input($_GET['tID']);
$ticket_tickettable = $oostable['ticket_ticket'];
$dbconn->Execute("DELETE FROM {$ticket_tickettable} WHERE ticket_id='" . $tID . "'");
oos_redirect_admin(oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action'))));
