function suspendorder()
{
testremote();
$query_a = "select emp_no, trans_no from localtemptrans";
$db_a = tDataConnect();
$result_a = sql_query($query_a, $db_a);
$row_a = sql_fetch_array($result_a);
$cashier_no = substr("000" . $row_a["emp_no"], -2);
$trans_no = substr("0000" . $row_a["trans_no"], -4);
if ($_SESSION["standalone"] == 0) {
if ($_SESSION["remoteDBMS"] == "mssql") {
$query = "insert " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
} else {
$query = "insert suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
if (uploadtable("suspended") == 1) {
cleartemptrans();
}
}
} else {
$query = "insert suspended select * from localtemptrans";
$result = sql_query($query, $db_a);
}
$_SESSION["plainmsg"] = "transaction suspended";
$_SESSION["msg"] = 2;
receipt("suspended");
$recall_line = $_SESSION["standalone"] . " " . $_SESSION["laneno"] . " " . $cashier_no . " " . $trans_no;
gohome();
sql_close($db_a);
}
function uploadtoServer()
{
$uploaded = 0;
if ($_SESSION["DBMS"] == "mssql") {
$strUploadDTrans = "insert " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.dtransactions select * from dtransactions";
$strUploadAlog = "insert " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.alog select * from alog";
$strUploadsuspended = "insert " . trim($_SESSION["mServer"]) . "." . trim($_SESSION["mDatabase"]) . ".dbo.suspended select * from suspended";
$connect = tDataConnect();
if (sql_query($strUploadDTrans, $connect)) {
sql_query("truncate table dtransactions", $connect);
sql_query($strUploadAlog, $connect);
sql_query("truncate table alog", $connect);
sql_query($strUploadsuspended, $connect);
sql_query("truncate table suspended", $connect);
$uploaded = 1;
$_SESSION["standalone"] = 0;
} else {
$uploaded = 0;
$_SESSION["standalone"] = 1;
}
} else {
$uploaded = uploadtable("dtransactions");
if ($uploaded == 1) {
uploadtable("suspended");
uploadtable("activitylog");
$_SESSION["standalone"] = 0;
} else {
$uploaded = 0;
$_SESSION["standalone"] = 1;
}
}
return $uploaded;
}
