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 = Receipt::GetDatabase();
$strQuery = sprintf('INSERT INTO `receipt_custom_field_helper` (`receipt_id`) VALUES (%s);', $this->ReceiptId);
$objDatabase->NonQuery($strQuery);
} else {
$this->ModifiedBy = QApplication::$objUserAccount->UserAccountId;
parent::Save($blnForceInsert, $blnForceUpdate);
}
}
/**
* Truncate receipt table
* @return void
*/
public static function Truncate()
{
// Get the Database Object for this Class
$objDatabase = Receipt::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
TRUNCATE `receipt`');
}
/**
* 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 intReceiptId
* @return Receipt[]
*/
public static function GetJournalForId($intReceiptId)
{
$objDatabase = Receipt::GetDatabase()->JournalingDatabase;
$objResult = $objDatabase->Query('SELECT * FROM receipt WHERE receipt_id = ' . $objDatabase->SqlVariable($intReceiptId) . ' ORDER BY __sys_date');
return Receipt::InstantiateDbResult($objResult);
}
