/**
* 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);
}