PHP Location::LoadByShortDescription方法代码示例

 protected function btnSave_Click($strFormId, $strControlId, $strParameter)
 {
     if ($objLocation = Location::LoadByShortDescription($this->txtShortDescription->Text)) {
         $this->txtShortDescription->Warning = 'This Location Name is already in use. Please try another.';
     } else {
         try {
             $this->UpdateLocationFields();
             $this->objLocation->Save();
             $this->RedirectToListPage();
         } catch (QExtendedOptimisticLockingException $objExc) {
             $this->btnCancel->Warning = sprintf('This location has been updated by another user. You must <a href="location_edit.php?intLocationId=%s">Refresh</a> to edit this location.', $this->objLocation->LocationId);
         }
     }
 }

require_once '../includes/prepend.inc.php';
QApplication::Authenticate();
$objDatabase = Location::GetDatabase();
// Load the Location Object by location_id=6
$objLocation = Location::Load(6);
// If the location exist or already updated
if ($objLocation && $objLocation->ShortDescription != 'Archived') {
    $objDatabase->NonQuery("SET FOREIGN_KEY_CHECKS = 0;");
    // Update location_id=6 to 'Archived'
    $strQuery = sprintf("UPDATE `location`\n                      SET `short_description`='Archived', `created_by`=NULL, `modified_by`=NULL, `creation_date`=NULL, `modified_date`=NULL, `long_description`=NULL\n                      WHERE `location_id`='6';");
    $objDatabase->NonQuery($strQuery);
    // Save existing location with new location_id
    $strQuery = sprintf("INSERT INTO `location` VALUES\n    (NULL, '{$objLocation->ShortDescription}', '{$objLocation->LongDescription}', '{$objLocation->CreatedBy}', '" . $objLocation->CreationDate->PHPDate('Y-m-d H:i:s') . "', '{$objLocation->ModifiedBy}', '{$objLocation->ModifiedDate}');");
    // Save and reload old location
    $objDatabase->NonQuery($strQuery);
    $objNewLocation = Location::LoadByShortDescription($objLocation->ShortDescription);
    // Get new location_id
    $objNewLocationId = $objNewLocation->LocationId;
    // Update all foreign keys and links
    // Added `modified_date`=`modified_date` to avoid the attribute "ON UPDATE CURRENT_TIMESTAMP"
    $strQuery = sprintf("UPDATE `asset`\n                      SET `location_id`='%s', `modified_date`=`modified_date`\n                      WHERE `location_id`='6';", $objNewLocationId);
    $objDatabase->NonQuery($strQuery);
    $strQuery = sprintf("UPDATE `audit_scan`\n                      SET `location_id`='%s'\n                      WHERE `location_id`='6';", $objNewLocationId);
    $objDatabase->NonQuery($strQuery);
    $strQuery = sprintf("UPDATE `inventory_location`\n                      SET `location_id`='%s', `modified_date`=`modified_date`\n                      WHERE `location_id`='6';", $objNewLocationId);
    $objDatabase->NonQuery($strQuery);
    $strQuery = sprintf("UPDATE `asset_transaction`\n                      SET `source_location_id`='%s', `modified_date`=`modified_date`\n                      WHERE `source_location_id`='6';", $objNewLocationId);
    $objDatabase->NonQuery($strQuery);
    $strQuery = sprintf("UPDATE `asset_transaction`\n                      SET `destination_location_id`='%s', `modified_date`=`modified_date`\n                      WHERE `destination_location_id`='6';", $objNewLocationId);
    $objDatabase->NonQuery($strQuery);
    $strQuery = sprintf("UPDATE `inventory_transaction`\n                      SET `source_location_id`='%s', `modified_date`=`modified_date`\n                      WHERE `source_location_id`='6';", $objNewLocationId);

             if (QApplication::$TracmorSettings->StrictCheckinPolicy == '1' && $objUserAccount->UserAccountId != QApplication::$objUserAccount->UserAccountId) {
                 $blnError = true;
                 $strWarning .= $strAssetCode . " - That asset was not checked out by the current user.<br />";
             } else {
                 $arrCheckedAssetCode[] = $strAssetCode;
             }
         }
         if (!$blnError && $objNewAsset instanceof Asset) {
             $objAssetArray[] = $objNewAsset;
         }
     } else {
         $strWarning .= "Please enter an asset tag.<br />";
     }
 }
 if (!$blnError) {
     $objDestinationLocation = Location::LoadByShortDescription($_POST['destination_location']);
     if (!$objDestinationLocation) {
         $blnError = true;
         $strWarning .= $_POST['destination_location'] . " - Destination Location does not exist.<br />";
     } else {
         $intDestinationLocationId = $objDestinationLocation->LocationId;
         // There is a 1 to Many relationship between Transaction and AssetTransaction so each Transaction can have many AssetTransactions.
         $objTransaction = new Transaction();
         $objTransaction->EntityQtypeId = EntityQtype::Asset;
         $objTransaction->TransactionTypeId = 2;
         // Check in
         $objTransaction->Save();
         foreach ($objAssetArray as $objAsset) {
             $objAssetTransaction = new AssetTransaction();
             $objAssetTransaction->AssetId = $objAsset->AssetId;
             $objAssetTransaction->TransactionId = $objTransaction->TransactionId;

 } elseif ($objNewAsset->LinkedFlag) {
     $blnError = true;
     $strWarning .= $strAssetCode . " - That asset is locked to a parent asset.";
 } elseif (!($objNewAsset->LocationId == 5 || $objNewAsset->LocationId == 2)) {
     $blnError = true;
     $strWarning .= $strAssetCode . " - That asset has already been received.<br />";
 } elseif (!($objPendingReceipt = AssetTransaction::PendingReceipt($objNewAsset->AssetId))) {
     $blnError = true;
     $strWarning .= $strAssetCode . " - That asset must be in a pending receipt.<br />";
 } elseif ($objNewAsset->CheckedOutFlag) {
     $blnError = true;
     $strWarning .= $strAssetCode . " - That asset is checked out.<br />";
 } elseif ($objNewAsset->ReservedFlag) {
     $blnError = true;
     $strWarning .= $strAssetCode . " - That asset is reserved.<br />";
 } elseif (!($objDestinationLocation = Location::LoadByShortDescription($strLocation))) {
     $blnError = true;
     $strWarning .= $strLocation . " - Destination Location does not exist.<br />";
 } else {
     if (!array_key_exists($objNewAsset->AssetId, $arrLocation)) {
         $arrLocation[$objNewAsset->AssetId] = $objDestinationLocation;
         $arrCheckedAssetCodeLocation[] = $strAssetCodeLocation;
     } else {
         $blnError = true;
         $strWarning .= $strAssetCode . " - That is a duplicate asset tag.<br />";
     }
 }
 if (!$blnError && $objNewAsset instanceof Asset) {
     $objAssetArray[] = $objNewAsset;
     $arrPendingReceiptId[] = $objPendingReceipt->Transaction->Receipt->ReceiptId;
     $objAssetTransactionArray[$objNewAsset->AssetId] = $objPendingReceipt;