function createEmptyOrder()
{
global $FANNIE_OP_DB, $TRANS, $FANNIE_SERVER_DBMS, $FANNIE_TRANS_DB;
$dbc = FannieDB::get($FANNIE_OP_DB);
$user = checkLogin();
$orderID = 1;
$values = $FANNIE_SERVER_DBMS != "MSSQL" ? "VALUES()" : "DEFAULT VALUES";
$dbc->query('INSERT ' . $TRANS . 'SpecialOrders ' . $values);
$orderID = $dbc->insert_id();
/**
@deprecated 24Apr14
New SpecialOrders table is standard now
*/
if ($dbc->table_exists($TRANS . 'SpecialOrderID')) {
$soP = $dbc->prepare('INSERT INTO ' . $TRANS . 'SpecialOrderID (id) VALUES (?)');
$soR = $dbc->execute($soP, array($orderID));
}
$ins_array = genericRow($orderID);
$ins_array['numflag'] = 2;
$ins_array['mixMatch'] = $user;
$dbc->smart_insert("{$TRANS}PendingSpecialOrder", $ins_array);
$note_vals = array('order_id' => $orderID, 'notes' => "", 'superID' => 0);
$status_vals = array('order_id' => $orderID, 'status_flag' => 3, 'sub_status' => time());
$dbc = FannieDB::get($FANNIE_TRANS_DB);
$so = new SpecialOrdersModel($dbc);
$so->specialOrderID($orderID);
$so->statusFlag($status_vals['status_flag']);
$so->subStatus($status_vals['sub_status']);
$so->notes(trim($note_vals['notes'], "'"));
$so->noteSuperID($note_vals['superID']);
$so->save();
$dbc = FannieDB::get($FANNIE_OP_DB);
// switch back to previous
if ($dbc->table_exists($TRANS . 'SpecialOrderNotes')) {
$dbc->smart_insert("{$TRANS}SpecialOrderNotes", $note_vals);
}
if ($dbc->table_exists($TRANS . 'SpecialOrderStatus')) {
$dbc->smart_insert("{$TRANS}SpecialOrderStatus", $status_vals);
}
createContactRow($orderID);
return $orderID;
}
