/** * Deletes all associated FedexShipments * @return void */ public function DeleteAllFedexShipments() { if (is_null($this->intShipmentId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateFedexShipment on this unsaved Shipment.'); } // Get the Database Object for this Class $objDatabase = Shipment::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `fedex_shipment` WHERE `shipment_id` = ' . $objDatabase->SqlVariable($this->intShipmentId) . ' '); }
public function Save($blnForceInsert = false, $blnForceUpdate = false) { if (!$this->__blnRestored || $blnForceInsert) { $this->CreatedBy = QApplication::$objUserAccount->UserAccountId; $this->CreationDate = new QDateTime(QDateTime::Now); parent::Save($blnForceInsert, $blnForceUpdate); // If we have no errors then will add the data to the helper table $objDatabase = Shipment::GetDatabase(); $strQuery = sprintf('INSERT INTO `shipment_custom_field_helper` (`shipment_id`) VALUES (%s);', $this->ShipmentId); $objDatabase->NonQuery($strQuery); } else { $this->ModifiedBy = QApplication::$objUserAccount->UserAccountId; parent::Save($blnForceInsert, $blnForceUpdate); } }
/** * Gets the historical journal for an object from the log database. * Objects will have VirtualAttributes available to lookup login, date, and action information from the journal object. * @param integer intShipmentId * @return Shipment[] */ public static function GetJournalForId($intShipmentId) { $objDatabase = Shipment::GetDatabase()->JournalingDatabase; $objResult = $objDatabase->Query('SELECT * FROM shipment WHERE shipment_id = ' . $objDatabase->SqlVariable($intShipmentId) . ' ORDER BY __sys_date'); return Shipment::InstantiateDbResult($objResult); }