/** * 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>