Ejemplo n.º 1
0
    /**
     * 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) . '
			');
    }
Ejemplo n.º 2
0
 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);
     }
 }
Ejemplo n.º 3
0
 /**
  * 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);
 }