/** * Load a single AssetTransactionCheckout object, * by AssetId * @param integer $intAssetId * @return object $objAssetTransactionCheckout */ public function LoadAssetTransactionCheckoutByAssetId($intAssetId = null) { // Loads objAssetTransaction $objClauses = array(); $objOrderByClause = QQ::OrderBy(QQN::AssetTransaction()->Transaction->CreationDate, false); $objLimitClause = QQ::LimitInfo(1, 0); array_push($objClauses, $objOrderByClause); array_push($objClauses, $objLimitClause); $AssetTransactionArray = AssetTransaction::LoadArrayByAssetId($this->AssetId, $objClauses); $intLastAssetTransactionId = $AssetTransactionArray[0]->AssetTransactionId; $objAssetTransactionCheckout = AssetTransactionCheckout::LoadByAssetTransactionId($intAssetLastTransactionId); return $objAssetTransactionCheckout; }
/** * Returns an array of objects that created the most recent transaction for this asset * * @return array of Object Account, Object AssetTransactionCheckout, string Note */ public function GetLastTransactionCheckoutObjectArray() { $objClauses = array(); $objExpansionClause = QQ::Expand(QQN::AssetTransaction()->Transaction->CreatedByObject); $objOrderByClause = QQ::OrderBy(QQN::AssetTransaction()->Transaction->CreationDate, false); $objLimitClause = QQ::LimitInfo(1, 0); array_push($objClauses, $objExpansionClause); array_push($objClauses, QQ::Expand(QQN::AssetTransaction()->AssetTransactionCheckout->AssetTransactionCheckoutId)); array_push($objClauses, $objOrderByClause); array_push($objClauses, $objLimitClause); $AssetTransactionArray = AssetTransaction::LoadArrayByAssetId($this->AssetId, $objClauses); /*$intLastAssetTransactionId = $AssetTransactionArray[0]->AssetTransactionId; $objClauses = array(); array_push($objClauses, QQ::Expand(QQN::AssetTransactionCheckout()->ToContact)); array_push($objClauses, QQ::Expand(QQN::AssetTransactionCheckout()->ToUser)); $objAssetTransactionCheckout = AssetTransactionCheckout::QuerySingle(QQ::Equal(QQN::AssetTransactionCheckout()->AssetTransactionId, $intLastAssetTransactionId), $objClauses);*/ $objAssetTransactionCheckout = $AssetTransactionArray[0]->AssetTransactionCheckout; $objAccount = $AssetTransactionArray[0]->Transaction->CreatedByObject; $strReason = $AssetTransactionArray[0]->Transaction->Note; return array("objAssetTransactionCheckout" => $objAssetTransactionCheckout, "objAccount" => $objAccount, "strNote" => $strReason); }
/** * Gets all associated AssetTransactions as an array of AssetTransaction objects * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query * @return AssetTransaction[] */ public function GetAssetTransactionArray($objOptionalClauses = null) { if (is_null($this->intAssetId)) { return array(); } try { return AssetTransaction::LoadArrayByAssetId($this->intAssetId, $objOptionalClauses); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } }
protected function btnCompleteShipment_Click($strFormId, $strControlId, $strParameter) { $blnError = false; if ($this->objAssetTransactionArray && $this->objInventoryTransactionArray) { $intEntityQtypeId = EntityQtype::AssetInventory; } elseif ($this->objAssetTransactionArray) { $intEntityQtypeId = EntityQtype::Asset; } elseif ($this->objInventoryTransactionArray) { $intEntityQtypeId = EntityQtype::Inventory; } else { $blnError = true; $this->btnCompleteShipment->Warning = 'There are no assets or inventory in this shipment.'; } if ($this->objAssetTransactionArray) { foreach ($this->objAssetTransactionArray as $objAssetTransaction) { if ($objAssetTransaction->Asset instanceof Asset) { $arrAssetTransactions = AssetTransaction::LoadArrayByAssetId($objAssetTransaction->Asset->AssetId, array(QQ::OrderBy(QQN::AssetTransaction()->CreationDate, false))); if (count($arrAssetTransactions) > 0) { $intLastTransactionId = $arrAssetTransactions[0]->TransactionId; $transaction = Transaction::load($intLastTransactionId); if ($transaction->TransactionTypeId == 6 && $transaction->Shipment->ShippedFlag) { $blnError = true; $this->btnCompleteShipment->Warning = $objAssetTransaction->Asset->__toStringWithLink() . ' already shipped.'; } } } } } if (!$blnError) { try { // Get an instance of the database $objDatabase = QApplication::$Database[1]; // Begin a MySQL Transaction to be either committed or rolled back $objDatabase->TransactionBegin(); if (!$this->blnEditMode) { // this is a new shipment so save the transaction & shipment before completing // Create the new transaction object and save it $this->objTransaction = new Transaction(); $this->objTransaction->EntityQtypeId = $intEntityQtypeId; $this->objTransaction->TransactionTypeId = 6; $this->objTransaction->Note = $this->txtNote->Text; $this->objTransaction->Save(); $this->UpdateShipmentFields(); $this->objShipment->Save(true); if ($this->arrCustomFields) { // Save the values from all of the custom field controls to save the shipment CustomField::SaveControls($this->objShipment->objCustomFieldArray, $this->blnEditMode, $this->arrCustomFields, $this->objShipment->ShipmentId, 10); } } // Create receipt transaction for internal shipment if ($this->objShipment->ToCompanyId == $this->objShipment->FromCompanyId) { $this->receiveInternalShipmentTransaction = new Transaction(); $this->receiveInternalShipmentTransaction->EntityQtypeId = $intEntityQtypeId; $this->receiveInternalShipmentTransaction->TransactionTypeId = 7; $note = sprintf('This receipt was automatically created when creating internal shipment Number %s. ', $this->objShipment->ShipmentNumber); $this->receiveInternalShipmentTransaction->Note = $note . $this->txtNote->Text; $this->receiveInternalShipmentTransaction->Save(); // Create a new receipt $objInternalReceipt = new Receipt(); $objInternalReceipt->TransactionId = $this->receiveInternalShipmentTransaction->TransactionId; // The receipt will mimic the shipment information $objInternalReceipt->FromCompanyId = $this->objShipment->FromCompanyId; $objInternalReceipt->FromContactId = $this->objShipment->FromContactId; $objInternalReceipt->ToContactId = $this->objShipment->ToContactId; $objInternalReceipt->ToAddressId = $this->objShipment->ToAddressId; $objInternalReceipt->ReceivedFlag = 0; $objInternalReceipt->ReceiptNumber = Receipt::LoadNewReceiptNumber(); $objInternalReceipt->Save(); } if ($intEntityQtypeId == EntityQtype::AssetInventory || $intEntityQtypeId == EntityQtype::Asset) { $objTransaction = ''; $objReceipt = ''; $objNewAssetTransactionArray = array(); foreach ($this->objAssetTransactionArray as $objAssetTransaction) { $objNewAssetTransactionArray[$objAssetTransaction->Asset->AssetCode] = $objAssetTransaction; } // Assign a destinationLocation to the AssetTransaction, and change the Location of the asset foreach ($this->objAssetTransactionArray as $objAssetTransaction) { if ($objAssetTransaction->Asset instanceof Asset) { // LocationId #2 == Shipped $DestinationLocationId = 2; if ($objAssetTransaction->ScheduleReceiptFlag && $objAssetTransaction->Asset->LinkedFlag) { $objAssetTransaction = $objNewAssetTransactionArray[$objAssetTransaction->Asset->AssetCode]; } $objAssetTransaction->Asset->LocationId = $DestinationLocationId; $objAssetTransaction->Asset->Save(); if (!$this->blnEditMode) { // Assign the TransactionId $objAssetTransaction->TransactionId = $this->objTransaction->TransactionId; } $objAssetTransaction->DestinationLocationId = $DestinationLocationId; // No any actions with linked items (LinkedFlag = 1) which have been scheduled for receipt if ($objAssetTransaction->ScheduleReceiptFlag && !$objAssetTransaction->Asset->LinkedFlag) { if ($objAssetTransaction->NewAsset && $objAssetTransaction->NewAsset instanceof Asset && $objAssetTransaction->NewAsset->AssetId == null) { // We have to create the new asset before we can $objReceiptAsset = new Asset(); $objReceiptAsset->AssetModelId = $objAssetTransaction->NewAsset->AssetModelId; $objReceiptAsset->LocationId = $objAssetTransaction->NewAsset->LocationId; if ($objAssetTransaction->NewAsset->AssetCode == '') { $objReceiptAsset->AssetCode = Asset::GenerateAssetCode(); } else { $objReceiptAsset->AssetCode = $objAssetTransaction->NewAsset->AssetCode; } $objReceiptAsset->Save(); // Assign any default custom field values CustomField::AssignNewEntityDefaultValues(1, $objReceiptAsset->AssetId); // Associate the new Asset with the AssetTransaction $objAssetTransaction->NewAsset = $objReceiptAsset; } // If it doesn't exist, create a new transaction object and receipt object if (!$objTransaction instanceof Transaction && !$objReceipt instanceof Receipt) { $objTransaction = new Transaction(); // Transaction is asset only $objTransaction->EntityQtypeId = 1; // Transaction is a receipt $objTransaction->TransactionTypeId = 7; // Set a note showing how this receipt was created if (!$objAssetTransaction->NewAssetId) { $strTransactionType = 'return'; } else { $strTransactionType = 'exchange'; } $objTransaction->Note = sprintf('This %s receipt was automatically created when creating Shipment Number %s.', $strTransactionType, $this->objShipment->ShipmentNumber); // Save the transaction $objTransaction->Save(); // Create a new receipt $objReceipt = new Receipt(); $objReceipt->TransactionId = $objTransaction->TransactionId; // The receipt will be coming from the company that was shipped to $objReceipt->FromCompanyId = $this->objShipment->ToCompanyId; $objReceipt->FromContactId = $this->objShipment->ToContactId; $objReceipt->ToContactId = $this->objShipment->FromContactId; $objReceipt->ToAddressId = $this->objShipment->FromAddressId; $objReceipt->ReceivedFlag = 0; $objReceipt->ReceiptNumber = Receipt::LoadNewReceiptNumber(); if ($objAssetTransaction->ScheduleReceiptDueDate) { $objReceipt->DueDate = $objAssetTransaction->ScheduleReceiptDueDate; } $objReceipt->Save(); } $objReceiptAssetTransaction = new AssetTransaction(); // If this is a return if (!$objAssetTransaction->NewAssetId) { $objReceiptAssetTransaction->AssetId = $objAssetTransaction->AssetId; } else { // Both the shipmentAssetTranscation (objAssetTransaction and the objReceiptAssetTransaction were involved in creating a new asset // Asset Transactions where NewAssetFlag = true but AssetId is NULL are receipt asset transactions for exchanges. $objReceiptAssetTransaction->AssetId = $objAssetTransaction->NewAssetId; $objReceiptAssetTransaction->NewAssetFlag = true; $objAssetTransaction->NewAssetFlag = true; $objAssetTransaction->Save(); } $objReceiptAssetTransaction->TransactionId = $objTransaction->TransactionId; $objReceiptAssetTransaction->SourceLocationId = $objAssetTransaction->DestinationLocationId; // This is not right. NewAssetFlag should be set only if a new asset was created when creating this AssetTransaction // It should not be true on the new AssetTransaction, but only on the AssetTransaction that caused the new asset to be created. // $objReceiptAssetTransaction->NewAssetFlag = true; $objReceiptAssetTransaction->Save(); // Load all child assets if ($objLinkedAssetCodeArray = Asset::LoadChildLinkedArrayByParentAssetId($objAssetTransaction->Asset->AssetId)) { foreach ($objLinkedAssetCodeArray as $objLinkedAssetCode) { $objLinkedAssetTransaction = $objNewAssetTransactionArray[$objLinkedAssetCode->AssetCode]; $objLinkedReceiptAssetTransaction = new AssetTransaction(); // If this is a return if (!$objAssetTransaction->NewAssetId) { $objLinkedReceiptAssetTransaction->AssetId = $objLinkedAssetTransaction->AssetId; $objLinkedReceiptAssetTransaction->TransactionId = $objTransaction->TransactionId; $objLinkedReceiptAssetTransaction->SourceLocationId = $objAssetTransaction->DestinationLocationId; $objLinkedReceiptAssetTransaction->Save(); } else { // Both the shipmentAssetTranscation (objAssetTransaction and the objReceiptAssetTransaction were involved in creating a new asset // Asset Transactions where NewAssetFlag = true but AssetId is NULL are receipt asset transactions for exchanges. $objLinkedReceiptAssetTransaction->AssetId = $objAssetTransaction->NewAssetId; } $objNewAssetTransactionArray[$objLinkedAssetCode->AssetCode] = $objLinkedAssetTransaction; } } } $objAssetTransaction->Save(); if ($objAssetTransaction->ScheduleReceiptFlag) { // Set the Receipt Asset Transaction as child of the Shipment Asset Transaction $objAssetTransaction->AssociateChildAssetTransaction($objReceiptAssetTransaction); } if ($this->objShipment->ToCompanyId == $this->objShipment->FromCompanyId && !$objAssetTransaction->Asset->LinkedFlag) { $objReceiptAssetTransaction = new AssetTransaction(); $objReceiptAssetTransaction->AssetId = $objAssetTransaction->AssetId; $objReceiptAssetTransaction->TransactionId = $this->receiveInternalShipmentTransaction->TransactionId; $objReceiptAssetTransaction->SourceLocationId = $objAssetTransaction->SourceLocationId; $objReceiptAssetTransaction->Save(); // Load all child assets if ($objLinkedAssetCodeArray = Asset::LoadChildLinkedArrayByParentAssetId($objAssetTransaction->Asset->AssetId)) { foreach ($objLinkedAssetCodeArray as $objLinkedAssetCode) { $objLinkedAssetTransaction = $objNewAssetTransactionArray[$objLinkedAssetCode->AssetCode]; $objLinkedReceiptAssetTransaction = new AssetTransaction(); // add data to linked asset $objLinkedReceiptAssetTransaction->AssetId = $objLinkedAssetTransaction->AssetId; $objLinkedReceiptAssetTransaction->TransactionId = $this->receiveInternalShipmentTransaction->TransactionId; $objLinkedReceiptAssetTransaction->SourceLocationId = $objAssetTransaction->SourceLocationId; $objLinkedReceiptAssetTransaction->Save(); } } } $objReceipt = null; $objTransaction = null; } } } if ($intEntityQtypeId == EntityQtype::AssetInventory || $intEntityQtypeId == EntityQtype::Inventory) { // Assign different source and destinations depending on transaction type foreach ($this->objInventoryTransactionArray as $objInventoryTransaction) { // LocationId #2 == Shipped $DestinationLocationId = 2; if (!$this->blnEditMode) { $objInventoryTransaction->TransactionId = $this->objTransaction->TransactionId; } // Remove the inventory quantity from the source $objInventoryTransaction->InventoryLocation->Quantity = $objInventoryTransaction->InventoryLocation->Quantity - $objInventoryTransaction->Quantity; $objInventoryTransaction->InventoryLocation->Save(); // Finish the InventoryTransaction and save it $objInventoryTransaction->DestinationLocationId = $DestinationLocationId; $objInventoryTransaction->Save(); // Add Inventory to receipt if this is an internal shipment if ($this->objShipment->ToCompanyId == $this->objShipment->FromCompanyId) { $objReceiptInventoryLocation = InventoryLocation::LoadByLocationIdInventoryModelId(5, $objInventoryTransaction->InventoryLocation->InventoryModelId); if (!$objReceiptInventoryLocation) { // First create the inventory location if it doesn't exist $objReceiptInventoryLocation = new InventoryLocation(); $objReceiptInventoryLocation->InventoryModelId = $objInventoryTransaction->InventoryLocation->InventoryModelId; $objReceiptInventoryLocation->LocationId = 5; $objReceiptInventoryLocation->Quantity = 0; } // Set the To Be Received quantity $objReceiptInventoryLocation->Quantity += $objInventoryTransaction->Quantity; $objReceiptInventoryLocation->Save(); // Create the inventory transaction $objReceiptInventoryTransaction = new InventoryTransaction(); $objReceiptInventoryTransaction->TransactionId = $this->receiveInternalShipmentTransaction->TransactionId; $objReceiptInventoryTransaction->InventoryLocationId = $objReceiptInventoryLocation->InventoryLocationId; $objReceiptInventoryTransaction->Quantity = $objInventoryTransaction->Quantity; $objReceiptInventoryTransaction->SourceLocationId = 5; $objReceiptInventoryTransaction->Save(); } } } if ($this->blnEditMode) { $this->UpdateShipmentFields(); } $this->objShipment->ShippedFlag = true; // $this->objShipment->Save(false, true); $this->objShipment->Save(); $objDatabase->TransactionCommit(); QApplication::Redirect(sprintf('../shipping/shipment_edit.php?intShipmentId=%s', $this->objShipment->ShipmentId)); } catch (QExtendedOptimisticLockingException $objExc) { $objDatabase->TransactionRollback(); if ($objExc->Class == 'Shipment') { $this->btnCancelShipment->Warning = sprintf('This shipment has been modified by another user. You must <a href="shipment_edit.php?intShipmentId=%s">Refresh</a> to complete this shipment.', $this->objShipment->ShipmentId); } else { throw new QOptimisticLockingException($objExc->Class); } } } }
/** * Deletes all associated AssetTransactions * @return void */ public function DeleteAllAssetTransactions() { if (is_null($this->intAssetId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAssetTransaction on this unsaved Asset.'); } // Get the Database Object for this Class $objDatabase = Asset::GetDatabase(); // Journaling if ($objDatabase->JournalingDatabase) { foreach (AssetTransaction::LoadArrayByAssetId($this->intAssetId) as $objAssetTransaction) { $objAssetTransaction->Journal('DELETE'); } } // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `asset_transaction` WHERE `asset_id` = ' . $objDatabase->SqlVariable($this->intAssetId) . ' '); }