/**
* Retreive server information
*
* @return array
*/
function oosGetSystemInformation() {
// Get database information
$dbconn =& oosDBGetConn();
$oostable =& oosDBGetTables();
$db_host = $dbconn->host;
$db_database = $dbconn->database;
$phpv = phpversion();
$db_result = $dbconn->ServerInfo($oostable['countries']);
list($system, $host, $kernel) = preg_split('/[\s,]+/', @exec('uname -a'), 5);
return array('date' => oos_datetime_short(date('Y-m-d H:i:s')),
'system' => $_ENV["OS"],
'kernel' => $kernel,
'host' => $host,
'ip' => gethostbyname($host),
'uptime' => @exec('uptime'),
'HTTP_SERVER' => $_SERVER['SERVER_SOFTWARE'],
'php' => $phpv,
'zend' => (function_exists('zend_version') ? zend_version() : ''),
'db_server' => $db_host,
'db_ip' => gethostbyname(OOS_DB_SERVER),
'db_version' => OOS_DB_TYPE . $db_result['description'],
'db_database' => $db_database);
}
case 'editstatus':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_STATUS_CUSTOMER . '</b>');
$contents = array('form' => oos_draw_form('customers', $aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=statusconfirm'));
$contents[] = array('text' => '<br />' . oos_draw_pull_down_menu('pdm_status', array_merge(array(array('id' => '0', 'text' => PULL_DOWN_DEFAULT)), $customers_statuses_array), $cInfo->customers_status) );
$contents[] = array('text' => '<table border="0" cellspacing="0" cellpadding="5"><tr><td class="smallText" align="center">' . TABLE_HEADING_NEW_VALUE .' </td><td class="smallText" align="center">' . TABLE_HEADING_DATE_ADDED . '</td></tr>');
$customers_status_historytable = $oostable['customers_status_history'];
$customers_history_sql = "SELECT new_value, old_value, date_added, customer_notified
FROM $customers_status_historytable
WHERE customers_id = '" . oos_db_input($cID) . "'
ORDER BY customers_status_history_id DESC";
$customers_history_result = $dbconn->Execute($customers_history_sql);
if ($customers_history_result->RecordCount()) {
while ($customers_history = $customers_history_result->fields) {
$contents[] = array('text' => '<tr>' . "\n" . '<td class="smallText">' . $customers_statuses_array[$customers_history['new_value']]['text'] . '</td>' . "\n" .'<td class="smallText" align="center">' . oos_datetime_short($customers_history['date_added']) . '</td>' . "\n" .'<td class="smallText" align="center">');
$contents[] = array('text' => '</tr>' . "\n");
// Move that ADOdb pointer!
$customers_history_result->MoveNext();
}
} else {
$contents[] = array('text' => '<tr>' . "\n" . ' <td class="smallText" colspan="2">' . TEXT_NO_CUSTOMER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n");
}
$contents[] = array('text' => '</table>');
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('update', 'update_off.gif', IMAGE_UPDATE) . ' <a href="' . oos_href_link_admin($aFilename['customers'], oos_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
$customer_status = oos_get_customers_status ($cID);
$cs_id = $customer_status['customers_status'];
<?php
if ($CommentsWithStatus) {
?>
<td class="smallText" align="center"><b><?php
echo TABLE_HEADING_COMMENTS;
?>
</b></td>
<?php
}
?>
</tr>
<?php
$orders_history_result = $dbconn->Execute("select * from " . $oostable['orders_status_history'] . " WHERE orders_id = '" . oos_db_input($oID) . "' order by date_added");
if ($orders_history_result->RecordCount()) {
while ($orders_history = $orders_history_result->fields) {
echo ' <tr>' . "\n" . ' <td class="smallText" align="center">' . oos_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">';
if ($orders_history['customer_notified'] == '1') {
echo oos_image(OOS_IMAGES . 'icons/tick.gif', ICON_TICK) . "</td>\n";
} else {
echo oos_image(OOS_IMAGES . 'icons/cross.gif', ICON_CROSS) . "</td>\n";
}
echo ' <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n";
if ($CommentsWithStatus) {
echo ' <td class="smallText">' . nl2br(oosDBOutput($orders_history['comments'])) . ' </td>' . "\n";
}
echo ' </tr>' . "\n";
// Move that ADOdb pointer!
$orders_history_result->MoveNext();
}
} else {
echo ' <tr>' . "\n" . ' <td class="smallText" colspan="5">' . TEXT_NO_ORDER_HISTORY . '</td>' . "\n" . ' </tr>' . "\n";
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($action) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');
$contents = array('form' => oos_draw_form('orders', $aFilename['orders'], oos_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br /><br /><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
$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 (oos_is_not_null($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 (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";
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" cellspacing="0" cellpadding="2">
<tr>
<td class="main"><b><?php echo ENTRY_ORDER_NUMBER; ?></b></td>
<td class="main"><?php echo intval($oID); ?></td>
<tr>
<tr>
<td class="main"><b><?php echo ENTRY_ORDER_DATE; ?></b></td>
<td class="main"><?php echo oos_datetime_short($order->info['date_purchased']); ?></td>
<tr>
<tr>
<td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td>
<td class="main"><?php echo $order->info['payment_method']; ?></td>
</tr>
</table></td>
</tr>
<tr>
<td><?php echo oos_draw_separator('trans.gif', '1', '10'); ?></td>
</tr>
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr class="dataTableHeadingRow">
<td class="dataTableHeadingContent" colspan="2"><?php echo TABLE_HEADING_PRODUCTS; ?></td>
<td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS_SERIAL_NUMBER; ?></td>
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_TICKET . '</b>');
$contents = array('form' => oos_draw_form('orders', $aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action')) . 'tID=' . $tInfo->ticket_id . '&action=deleteconfirm'));
$contents[] = array('align' => 'left', 'text' => $tInfo->ticket_subject);
$contents[] = array('align' => 'center', 'text' => '<br />' . oos_image_swap_submits('delete', 'delete_off.gif', IMAGE_DELETE) . ' <a href="' . oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action')) . 'tID=' . $tInfo->ticket_id) . '">' . oos_image_swap_button('cancel', 'cancel_off.gif', IMAGE_CANCEL) . '</a>');
$contents[] = array('form' => '</form>');
break;
default:
if (isset($tInfo) && is_object($tInfo)) {
$heading[] = array('text' => '<b>[' . $tInfo->ticket_id . '] ' . $tInfo->ticket_subject . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action')) . 'tID=' . $tInfo->ticket_id . '&action=edit') . '">' . oos_image_swap_button('edit', 'edit_off.gif', IMAGE_EDIT) . '</a> <a href="' . oos_href_link_admin($aFilename['ticket_view'], oos_get_all_get_params(array('tID', 'action')) . 'tID=' . $tInfo->ticket_id . '&action=delete') . '">' . oos_image_swap_button('delete', 'delete_off.gif', IMAGE_DELETE) . '</a>');
$contents[] = array('text' => '<br />' . TEXT_DATE_TICKET_CREATED . ' ' . oos_datetime_short($tInfo->ticket_date_created));
if (oos_is_not_null($tInfo->ticket_date_last_modified)) {
$contents[] = array('text' => TEXT_DATE_TICKET_LAST_MODIFIED . ' ' . oos_datetime_short($tInfo->ticket_date_last_modified));
}
if (oos_is_not_null($tInfo->ticket_date_last_customer_modified)) {
$contents[] = array('text' => TEXT_DATE_TICKET_LAST_CUSTOMER_MODIFIED . ' ' . oos_datetime_short($tInfo->ticket_date_last_customer_modified));
}
if (TICKET_USE_STATUS == '1') {
$contents[] = array('text' => '<br />' . TEXT_STATUS . ' ' . $ticket_status_array[$tInfo->ticket_status_id]);
}
if (TICKET_USE_PRIORITY == '1') {
$contents[] = array('text' => '<br />' . TEXT_PRIORITY . ' ' . $ticket_priority_array[$tInfo->ticket_priority_id]);
}
if (TICKET_USE_DEPARTMENT == '1') {
$contents[] = array('text' => '<br />' . TEXT_DEPARTMENT . ' ' . $ticket_department_array[$tInfo->ticket_department_id]);
}
$contents[] = array('text' => '<br />' . TEXT_TICKET_NR . ' ' . $tInfo->ticket_link_id);
$contents[] = array('text' => '<br />' . TEXT_CUSTOMERS_NAME . ' ' . $tInfo->ticket_customers_name);
$contents[] = array('text' => '<br />' . TEXT_CUSTOMERS_EMAIL . ' ' . $tInfo->ticket_customers_email);
if ($tInfo->ticket_customers_id > 0) {
$contents[] = array('text' => TEXT_CUSTOMERS_ID . ' ' . '<a href="' . oos_href_link_admin($aFilename['customers'], "cID=" . $tInfo->ticket_customers_id . "&action=edit") . '" target="' . TICKET_LINK_TARGET . '">' . $tInfo->ticket_customers_id . '</a>');
<td class="main"><b><?php
echo ENTRY_ORDER_NUMBER;
?>
</b></td>
<td class="main"><?php
echo intval($oID);
?>
</td>
<tr>
<tr>
<td class="main"><b><?php
echo ENTRY_ORDER_DATE;
?>
</b></td>
<td class="main"><?php
echo oos_datetime_short($order->info['date_purchased']);
?>
</td>
<tr>
<tr>
<td class="main"><b><?php
echo ENTRY_PAYMENT_METHOD;
?>
</b></td>
<td class="main"><?php
echo $order->info['payment_method'];
?>
</td>
</tr>
</table></td>
</tr>
</tr>
</table></td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($action) {
case 'release':
$heading[] = array('text' => '[' . $gInfo->unique_id . '] ' . oos_datetime_short($gInfo->date_created) . ' ' . $currencies->format($gInfo->amount));
$contents[] = array('align' => 'center', 'text' => '<a href="' . oos_href_link_admin('gv_queue.php','action=confirmrelease&gid='.$gInfo->unique_id,'NONSSL').'">'.oos_image_swap_button('confirm_red','confirm_red_off.gif', IMAGE_CONFIRM) . '</a> <a href="' . oos_href_link_admin('gv_queue.php','action=cancel&gid=' . $gInfo->unique_id,'NONSSL') . '">' . oos_image_swap_button('cancel','cancel_off.gif', IMAGE_CANCEL) . '</a>');
break;
default:
$heading[] = array('text' => '[' . $gInfo->unique_id . '] ' . oos_datetime_short($gInfo->date_created) . ' ' . $currencies->format($gInfo->amount));
$contents[] = array('align' => 'center','text' => '<a href="' . oos_href_link_admin('gv_queue.php','action=release&gid=' . $gInfo->unique_id,'NONSSL'). '">' . oos_image_swap_button('release','release_off.gif', IMAGE_RELEASE) . '</a>');
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>
