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; }