echo "Order cancelled.";
}
if ($_REQUEST['mass_cancel'] != '') {
echo "cancelling...";
foreach ($_REQUEST[orders] as $oid) {
//echo "$order_id ";
cancel_order($oid);
}
}
if ($_REQUEST['action'] == 'delete') {
delete_order($_REQUEST[order_id]);
echo "Order deleted.";
}
if ($_REQUEST['mass_delete'] != '') {
foreach ($_REQUEST[orders] as $oid) {
delete_order($oid);
}
}
$q_aday = $_REQUEST['q_aday'];
$q_amon = $_REQUEST['q_amon'];
$q_ayear = $_REQUEST['q_ayear'];
$q_name = $_REQUEST['q_name'];
$q_username = $_REQUEST['q_username'];
$q_resumes = $_REQUEST['q_resumes'];
$q_news = $_REQUEST['q_news'];
$q_email = $_REQUEST['q_email'];
$q_company = $_REQUEST['q_company'];
$search = $_REQUEST['search'];
$q_string = "&q_name={$q_name}&q_username={$q_username}&q_email={$q_email}&q_aday={$q_aday}&q_amon={$q_amon}&q_ayear={$q_ayear}&search={$search}";
?>
$bill_state = $billing_address['state'];
$bill_zip = $billing_address['zipCode'];
$bill_phone = $billing_address['phone'];
include 'order.php';
break;
case 'set_ship_date':
$order_id = intval($_POST['order_id']);
set_ship_date($order_id);
$url = '?action=view_order&order_id=' . $order_id;
sendShippingConfirmEmail($order_id);
redirect($url);
case 'confirm_delete':
// Get order data
$order_id = intval($_POST['order_id']);
$order = get_order($order_id);
$order_date = date('M j, Y', strtotime($order['orderDate']));
// Get customer data
$customer = get_customer($order['customerID']);
$name = $customer['lastName'] . ', ' . $customer['firstName'];
$email = $customer['emailAddress'];
include 'confirm_delete.php';
break;
case 'delete':
$order_id = intval($_POST['order_id']);
delete_order($order_id);
redirect('.');
break;
default:
display_error("Unknown order action: " . $action);
break;
}
$portfolio = "liveportfolio";
$realtime_quote = "realtime_quote";
if ($_GET) {
if ($_GET['action'] == 'execute') {
$pid = 1;
execute_order($pid);
} elseif ($_GET['action'] == 'add') {
$pid = $_GET['pid'];
$pid = 1;
$order_type = $_GET['order_type'];
$symbol = $_GET['symbol'];
$shares = $_GET['shares'];
add_order($pid, $order_type, $symbol, $shares);
} elseif ($_GET['action'] == 'delete') {
$pid = 1;
delete_order($pid, 'BUY', 'AAPL');
} elseif ($_GET['action'] == 'update') {
$pid = 1;
update_order($pid, 'BUY', 'AAPL', 500);
} elseif ($_GET['action'] == 'get_order') {
$pid = 1;
get_open_order($pid);
} elseif ($_GET['action'] == 'get_quote') {
$pid = 1;
get_yahoo_quote("AAPL+IBM+GS+BAC+FB+WYNN+SZYM+DANG+TSLA+JCP+BIDU+CMG+V+LVS");
} elseif ($_GET['action'] == 'refresh_realtime_quotes') {
$pid = 1;
refresh_realtime_quotes($a);
}
}
function add_order($pid, $order_type, $symbol, $shares)
function expire_orders()
{
$now = gmdate("Y-m-d H:i:s");
$unix_time = time();
// get the time of last run
$sql = "SELECT * FROM `config` where `key` = 'LAST_EXPIRE_RUN' ";
$result = @mysql_query($sql) or $DB_ERROR = mysql_error();
$t_row = @mysql_fetch_array($result);
if ($DB_ERROR != '') {
return $DB_ERROR;
}
// Poor man's lock
$sql = "UPDATE `config` SET `val`='YES' WHERE `key`='EXPIRE_RUNNING' AND `val`='NO' ";
$result = @mysql_query($sql) or $DB_ERROR = mysql_error();
if (@mysql_affected_rows() == 0) {
// make sure it cannot be locked for more than 30 secs
// This is in case the proccess fails inside the lock
// and does not release it.
if ($unix_time > $t_row['val'] + 30) {
// release the lock
$sql = "UPDATE `config` SET `val`='NO' WHERE `key`='EXPIRE_RUNNING' ";
$result = @mysql_query($sql) or $DB_ERROR = mysql_error();
// update timestamp
$sql = "REPLACE INTO config (`key`, `val`) VALUES ('LAST_EXPIRE_RUN', '{$unix_time}') ";
$result = @mysql_query($sql) or $DB_ERROR = mysql_error();
}
return;
// this function is already executing in another process.
}
if ($unix_time > $t_row['val'] + 60) {
// did 1 minute elapse since last run?
// Delete Temp Orders
$session_duration = ini_get("session.gc_maxlifetime");
$sql = "SELECT session_id, order_date FROM `temp_orders` WHERE DATE_SUB('{$now}', INTERVAL {$session_duration} SECOND) >= temp_orders.order_date AND session_id <> '" . addslashes(session_id()) . "' ";
$result = mysql_query($sql);
while ($row = @mysql_fetch_array($result)) {
delete_temp_order($row['session_id']);
}
// COMPLTED Orders
$sql = "SELECT *, banners.banner_id as BID from orders, banners where status='completed' and orders.banner_id=banners.banner_id AND orders.days_expire <> 0 AND DATE_SUB('{$now}', INTERVAL orders.days_expire DAY) >= orders.date_published AND orders.date_published IS NOT NULL ";
//echo $sql;
$result = mysql_query($sql);
$affected_BIDs = array();
while ($row = @mysql_fetch_array($result)) {
$affected_BIDs[] = $row['BID'];
expire_order($row['order_id']);
}
if (sizeof($affected_BIDs) > 0) {
foreach ($affected_BIDs as $myBID) {
$b_row = load_banner_row($myBID);
if ($b_row['auto_publish'] == 'Y') {
process_image($myBID);
publish_image($myBID);
process_map($myBID);
}
}
}
process_paid_renew_orders();
unset($affected_BIDs);
// unconfirmed Orders
if (HOURS_UNCONFIRMED != 0) {
$sql = "SELECT * from orders where (status='new') AND DATE_SUB('{$now}',INTERVAL " . HOURS_UNCONFIRMED . " HOUR) >= date_stamp AND date_stamp IS NOT NULL ";
$result = @mysql_query($sql);
while ($row = @mysql_fetch_array($result)) {
delete_order($row['order_id']);
// Now really delete the order.
$sql = "delete from orders where order_id='" . $row['order_id'] . "'";
@mysql_query($sql);
mds_log("Deleted unconfirmed order - " . $sql);
}
}
// unpaid Orders
if (DAYS_CONFIRMED != 0) {
$sql = "SELECT * from orders where (status='new' OR status='confirmed') AND DATE_SUB('{$now}',INTERVAL " . DAYS_CONFIRMED . " DAY) >= date_stamp AND date_stamp IS NOT NULL ";
$result = @mysql_query($sql);
while ($row = @mysql_fetch_array($result)) {
expire_order($row['order_id']);
}
}
// EXPIRED Orders -> Cancel
if (DAYS_RENEW != 0) {
$sql = "SELECT * from orders where status='expired' AND DATE_SUB('{$now}',INTERVAL " . DAYS_RENEW . " DAY) >= date_stamp AND date_stamp IS NOT NULL ";
$result = @mysql_query($sql);
while ($row = @mysql_fetch_array($result)) {
cancel_order($row['order_id']);
}
}
// Cancelled Orders -> Delete
if (DAYS_CANCEL != 0) {
$sql = "SELECT * from orders where status='cancelled' AND DATE_SUB('{$now}',INTERVAL " . DAYS_CANCEL . " DAY) >= date_stamp AND date_stamp IS NOT NULL ";
$result = @mysql_query($sql);
while ($row = @mysql_fetch_array($result)) {
delete_order($row['order_id']);
}
}
// update last run time stamp
// update timestamp
$sql = "REPLACE INTO config (`key`, `val`) VALUES ('LAST_EXPIRE_RUN', '{$unix_time}') ";
$result = @mysql_query($sql) or die(mysql_error());
}
// release the poor man's lock
$sql = "UPDATE `config` SET `val`='NO' WHERE `key`='EXPIRE_RUNNING' ";
@mysql_query($sql) or die(mysql_error());
}
<?php
require_once '../../util/main.php';
require_once '../../model/database.php';
require_once '../../model/order_db.php';
$success_notification = '';
$error_notification = '';
if (isset($_POST['id'])) {
$ids = $_POST['id'];
try {
for ($count = 0; $count < count($ids); $count++) {
$orderID = $ids[$count];
delete_order($orderID);
}
} catch (Exception $e) {
$error_notification = $e->getMessage();
}
$success_notification = 'Successfully deleted';
require_once '../../util/notification.php';
}
/**
*从购物车中移除产品
* @param $row_id订单id
*@return bool
*/
function remove_to_cart($row_id)
{
if (!$row_id) {
$row_id = isset($_REQUEST['row_id']) ? $_REQUEST['row_id'] : false;
}
if ($row_id) {
$row_id = intval($row_id);
return delete_order($row_id);
//其实是根据id删除订单表中的数据
}
}
$isalter = 1;
}
if ($prod !== "") {
insert_order_res($_POST['oid'], $prod, $isalter);
}
}
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['sendemail'])) {
if ($_POST['email'] !== "") {
sendEmail($_POST['email'], $_POST['oid']);
}
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['delete'])) {
delete_order($_POST['oid']);
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['saver'])) {
$prod = $_POST['prodid'];
$isalter = 0;
if (isset($_POST['isalter'])) {
$isalter = 1;
}
update_order_res($_POST['orid'], $prod, $isalter);
header("location:" . $_SERVER['HTTP_REFERER']);
}
if (isset($_POST['deleter'])) {
delete_order_res($_POST['orid']);
header("location:" . $_SERVER['HTTP_REFERER']);
}
