function vam_get_system_information()
{
$db_query = vam_db_query("select now() as datetime");
$db = vam_db_fetch_array($db_query);
list($system, $host, $kernel) = preg_split('/[\\s,]+/', @exec('uname -a'), 5);
return array('date' => vam_datetime_short(date('Y-m-d H:i:s')), 'system' => $system, 'kernel' => $kernel, 'host' => $host, 'ip' => gethostbyname($host), 'uptime' => @exec('uptime'), 'http_server' => $_SERVER['SERVER_SOFTWARE'], 'php' => PHP_VERSION, 'zend' => function_exists('zend_version') ? zend_version() : '', 'db_server' => DB_SERVER, 'db_ip' => gethostbyname(DB_SERVER), 'db_version' => 'MySQL ' . (function_exists('mysql_get_server_info') ? mysql_get_server_info() : ''), 'db_date' => vam_datetime_short($db['datetime']));
}
</table></td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($_GET['action']) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PAYMENT . '</b>');
$contents = array('form' => vam_draw_form('payment', FILENAME_AFFILIATE_PAYMENT, vam_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id . '&action=deleteconfirm'));
$contents[] = array('text' => TEXT_INFO_DELETE_INTRO . '<br>');
$contents[] = array('align' => 'center', 'text' => '<br><span class="button"><button type="submit" value="' . BUTTON_DELETE . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</button></span><a class="button" href="' . vam_href_link(AFFILIATE_PAYMENT, vam_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id) . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>');
break;
default:
if (is_object($pInfo)) {
$heading[] = array('text' => '<b>[' . $pInfo->affiliate_payment_id . '] ' . vam_datetime_short($pInfo->affiliate_payment_date) . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_AFFILIATE_PAYMENT, vam_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id . '&action=edit') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a> <a class="button" href="' . vam_href_link(FILENAME_AFFILIATE_PAYMENT, vam_get_all_get_params(array('pID', 'action')) . 'pID=' . $pInfo->affiliate_payment_id . '&action=delete') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</span></a>');
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_AFFILIATE_INVOICE, 'pID=' . $pInfo->affiliate_payment_id) . '" TARGET="_blank"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/payment.png', '', '12', '12') . ' ' . BUTTON_INVOICE . '</span></a> ');
}
break;
}
if (vam_not_null($heading) && vam_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>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($_GET['action']) {
case 'delete':
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_ORDER . '</b>');
$contents = array('form' => vam_draw_form('orders', FILENAME_ORDERS, vam_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 />' . vam_draw_checkbox_field('restock') . ' ' . TEXT_INFO_RESTOCK_PRODUCT_QUANTITY);
$contents[] = array('align' => 'center', 'text' => '<br /><span class="button"><button type="submit" value="' . BUTTON_DELETE . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</button></span><a class="button" href="' . vam_href_link(FILENAME_ORDERS, vam_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id) . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>');
break;
default:
if (is_object($oInfo)) {
$heading[] = array('text' => '<b>[' . $oInfo->orders_id . '] ' . vam_datetime_short($oInfo->date_purchased) . '</b>');
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_ORDERS, vam_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=edit') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/edit.png', '', '12', '12') . ' ' . BUTTON_EDIT . '</span></a> <a class="button" href="' . vam_href_link(FILENAME_ORDERS, vam_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=delete') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</span></a> <a class="button" href="' . vam_href_link(FILENAME_PRINT_ORDER, 'oID=' . $oInfo->orders_id) . '" target="_blank"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/payment.png', '', '12', '12') . ' ' . BUTTON_INVOICE . '</span></a> <a class="button" href="' . vam_href_link(FILENAME_PRINT_PACKINGSLIP, 'oID=' . $oInfo->orders_id) . '" target="_blank"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/shipping.png', '', '12', '12') . ' ' . BUTTON_PACKINGSLIP . '</span></a>');
if (AFTERBUY_ACTIVATED == 'true') {
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link(FILENAME_ORDERS, vam_get_all_get_params(array('oID', 'action')) . 'oID=' . $oInfo->orders_id . '&action=afterbuy_send') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_AFTERBUY_SEND . '</span></a>');
}
//$contents[] = array('align' => 'center', 'text' => '');
$order_payment = $oInfo->payment_method;
require DIR_FS_LANGUAGES . $_SESSION['language'] . '/modules/payment/' . $order_payment . '.php';
$order_payment_text = constant(MODULE_PAYMENT_ . strtoupper($order_payment) . _TEXT_TITLE);
$contents[] = array('text' => '<br />' . TEXT_DATE_ORDER_CREATED . ' ' . vam_date_short($oInfo->date_purchased));
if (vam_not_null($oInfo->last_modified)) {
$contents[] = array('text' => TEXT_DATE_ORDER_LAST_MODIFIED . ' ' . vam_date_short($oInfo->last_modified));
}
$contents[] = array('text' => '<br />' . TEXT_INFO_PAYMENT_METHOD . ' ' . $order_payment_text);
$contents[] = array('text' => '<br />' . ENTRY_SHIPPING_METHOD . ' ' . $oInfo->shipping_method);
// elari added to display product list for selected order
</td>
<td class="dataTableHeadingContent" align="left"><?php
echo TABLE_HEADING_COMMENTS;
?>
</td>
</tr>
<?php
$orders_history_query = vam_db_query("SELECT orders_status_history_id, orders_status_id, date_added, customer_notified, comments \n FROM " . TABLE_ORDERS_STATUS_HISTORY . " \n\t\t\t\t\t\t\t\t\t WHERE orders_id = '" . (int) $oID . "' \n\t\t\t\t\t\t\t\t\t ORDER BY date_added");
if (vam_db_num_rows($orders_history_query)) {
while ($orders_history = vam_db_fetch_array($orders_history_query)) {
$r++;
$rowClass = $r / 2 == floor($r / 2) ? 'dataRowOver' : 'dataRow';
if (ORDER_EDITOR_USE_AJAX == 'true') {
echo ' <tr class="' . $rowClass . '" id="commentRow' . $orders_history['orders_status_history_id'] . '" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this, \'' . $rowClass . '\')">' . "\n" . ' <td class="smallText" align="center"><div id="do_not_delete"><input name="update_comments[' . $orders_history['orders_status_history_id'] . '][delete]" type="checkbox" onClick="updateCommentsField(\'delete\', \'' . $orders_history['orders_status_history_id'] . '\', this.checked, \'\', this)"></div></td>' . "\n" . ' <td class="smallText" align="center">' . vam_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">';
} else {
echo ' <tr class="' . $rowClass . '" id="commentRow' . $orders_history['orders_status_history_id'] . '" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this, \'' . $rowClass . '\')">' . "\n" . ' <td class="smallText" align="center"><div id="do_not_delete"><input name="update_comments[' . $orders_history['orders_status_history_id'] . '][delete]" type="checkbox"></div></td>' . "\n" . ' <td class="smallText" align="center">' . vam_datetime_short($orders_history['date_added']) . '</td>' . "\n" . ' <td class="smallText" align="center">';
}
if ($orders_history['customer_notified'] == '1') {
echo vam_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
} else {
echo vam_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
}
echo '<td class="smallText" align="left">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n";
echo '<td class="smallText" align="left">';
if (ORDER_EDITOR_USE_AJAX == 'true') {
echo vam_draw_textarea_field("update_comments[" . $orders_history['orders_status_history_id'] . "][comments]", "soft", "40", "5", "" . vam_db_output($orders_history['comments']) . "", "onChange=\"updateCommentsField('update', '" . $orders_history['orders_status_history_id'] . "', 'false', encodeURIComponent(this.value))\"") . '' . "\n" . ' </td>' . "\n";
} else {
echo vam_draw_textarea_field("update_comments[" . $orders_history['orders_status_history_id'] . "][comments]", "soft", "40", "5", "" . vam_db_output($orders_history['comments']) . "") . '' . "\n" . ' </td>' . "\n";
}
echo ' </tr>' . "\n";
}
$contents[] = array('text' => TEXT_DELETE_INTRO . '<br /><br /><b>' . $cInfo->customers_firstname . ' ' . $cInfo->customers_lastname . '</b>');
if ($cInfo->number_of_reviews > 0) {
$contents[] = array('text' => '<br />' . vam_draw_checkbox_field('delete_reviews', 'on', true) . ' ' . sprintf(TEXT_DELETE_REVIEWS, $cInfo->number_of_reviews));
}
$contents[] = array('align' => 'center', 'text' => '<br /><span class="button"><button type="submit" value="' . BUTTON_DELETE . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/delete.png', '', '12', '12') . ' ' . BUTTON_DELETE . '</button></span><a class="button" href="' . vam_href_link(FILENAME_CUSTOMERS, vam_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id) . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>');
break;
case 'editstatus':
if ($_GET['cID'] != 1) {
$customers_history_query = vam_db_query("select new_value, old_value, date_added, customer_notified from " . TABLE_CUSTOMERS_STATUS_HISTORY . " where customers_id = '" . vam_db_input($_GET['cID']) . "' order by customers_status_history_id desc");
$heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_STATUS_CUSTOMER . '</b>');
$contents = array('form' => vam_draw_form('customers', FILENAME_CUSTOMERS, vam_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id . '&action=statusconfirm'));
$contents[] = array('text' => '<br />' . vam_draw_pull_down_menu('status', $customers_statuses_array, $cInfo->customers_status));
$contents[] = array('text' => '<table nowrap border="0" cellspacing="0" cellpadding="0"><tr><td style="border-bottom: 1px solid; border-color: #000000;" nowrap class="smallText" align="center"><b>' . TABLE_HEADING_NEW_VALUE . ' </b></td><td style="border-bottom: 1px solid; border-color: #000000;" nowrap class="smallText" align="center"><b>' . TABLE_HEADING_DATE_ADDED . '</b></td></tr>');
if (vam_db_num_rows($customers_history_query)) {
while ($customers_history = vam_db_fetch_array($customers_history_query)) {
$contents[] = array('text' => '<tr>' . "\n" . '<td class="smallText">' . $customers_statuses_array[$customers_history['new_value']]['text'] . '</td>' . "\n" . '<td class="smallText" align="center">' . vam_datetime_short($customers_history['date_added']) . '</td>' . "\n" . '<td class="smallText" align="center">');
$contents[] = array('text' => '</tr>' . "\n");
}
} 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 /><span class="button"><button type="submit" value="' . BUTTON_UPDATE . '">' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_UPDATE . '</button></span><a class="button" href="' . vam_href_link(FILENAME_CUSTOMERS, vam_get_all_get_params(array('cID', 'action')) . 'cID=' . $cInfo->customers_id) . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>');
$status = vam_db_prepare_input($_POST['status']);
// maybe this line not needed to recheck...
}
break;
default:
$customer_status = vam_get_customer_status($_GET['cID']);
$cs_id = $customer_status['customers_status'];
$cs_member_flag = $customer_status['member_flag'];
?>
</td>
</tr>
</table></td>
</tr>
</table></td>
<?php
$heading = array();
$contents = array();
switch ($_GET['action']) {
case 'release':
$heading[] = array('text' => '[' . $gInfo->unique_id . '] ' . vam_datetime_short($gInfo->date_created) . ' ' . $currencies->format($gInfo->amount));
$contents[] = array('align' => 'center', 'text' => '<a class="button" style="font-color: red;" href="' . vam_href_link('gv_queue.php', 'action=confirmrelease&gid=' . $gInfo->unique_id, 'NONSSL') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/submit.png', '', '12', '12') . ' ' . BUTTON_CONFIRM . '</span></a> <a class="button" href="' . vam_href_link('gv_queue.php', 'action=cancel&gid=' . $gInfo->unique_id, 'NONSSL') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/cancel.png', '', '12', '12') . ' ' . BUTTON_CANCEL . '</span></a>');
break;
default:
$heading[] = array('text' => '[' . $gInfo->unique_id . '] ' . vam_datetime_short($gInfo->date_created) . ' ' . $currencies->format($gInfo->amount));
$contents[] = array('align' => 'center', 'text' => '<a class="button" href="' . vam_href_link('gv_queue.php', 'action=release&gid=' . $gInfo->unique_id, 'NONSSL') . '"><span>' . vam_image(DIR_WS_IMAGES . 'icons/buttons/add.png', '', '12', '12') . ' ' . BUTTON_RELEASE . '</span></a>');
break;
}
if (vam_not_null($heading) && vam_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>
<!-- body_text_eof //-->
" align="center"><?php
echo $orders['orders_id'];
?>
</td>
<td class="<?php
echo $css_class;
?>
"><?php
echo strip_tags($orders['order_total']);
?>
</td>
<td class="<?php
echo $css_class;
?>
"><?php
echo $orders['orders_status_name'];
?>
</td>
<td class="<?php
echo $css_class;
?>
"><?php
echo vam_datetime_short($orders['date_purchased']);
?>
</td>
</tr>
<?php
}
?>
</table>
