本文整理汇总了PHP中Location::GetDatabase方法的典型用法代码示例。如果您正苦于以下问题:PHP Location::GetDatabase方法的具体用法?PHP Location::GetDatabase怎么用?PHP Location::GetDatabase使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Location
的用法示例。
在下文中一共展示了Location::GetDatabase方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: sprintf
<?php
/* This script allows to add new location 'Archived' (location_id=6)
* in the existing database
*/
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);
示例2: DeleteAllInventoryTransactionsAsDestination
/**
* Deletes all associated InventoryTransactionsAsDestination
* @return void
*/
public function DeleteAllInventoryTransactionsAsDestination()
{
if (is_null($this->intLocationId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateInventoryTransactionAsDestination on this unsaved Location.');
}
// Get the Database Object for this Class
$objDatabase = Location::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (InventoryTransaction::LoadArrayByDestinationLocationId($this->intLocationId) as $objInventoryTransaction) {
$objInventoryTransaction->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`inventory_transaction`
WHERE
`destination_location_id` = ' . $objDatabase->SqlVariable($this->intLocationId) . '
');
}
示例3: btnNext_Click
//.........这里部分代码省略.........
$objNewLocation->Save();
$this->objNewLocationArray[$objNewLocation->LocationId] = $objNewLocation->ShortDescription;
}
$this->objNewLocationArray = array();
$this->objNewCategoryArray = array();
$this->objNewManufacturerArray = array();
$this->objNewAssetModelArray = array();
$this->strModelValuesArray = array();
$this->blnImportEnd = false;
$j = 1;
$strLocationValuesArray = array();
// Add all unique locations in database
foreach ($this->strFilePathArray as $strFilePath) {
$this->FileCsvData->load($strFilePath);
if ($j != 1) {
//$this->FileCsvData->appendRow($this->FileCsvData->getHeaders());
}
// Location Import
for ($i = 0; $i < $this->FileCsvData->countRows(); $i++) {
$strRowArray = $this->FileCsvData->getRow($i);
if (trim($strRowArray[$this->intLocationKey]) && !$this->in_array_nocase(trim($strRowArray[$this->intLocationKey]), $strLocationArray)) {
$strLocationArray[] = trim($strRowArray[$this->intLocationKey]);
/*$objNewLocation = new Location();
$objNewLocation->ShortDescription = addslashes(trim($strRowArray[$this->intLocationKey]));
$objNewLocation->Save();*/
$strLocationValuesArray[] = sprintf("('%s', '%s', NOW())", addslashes(trim($strRowArray[$this->intLocationKey])), $_SESSION['intUserAccountId']);
$strNewLocation[] = addslashes(trim($strRowArray[$this->intLocationKey]));
//$this->objNewLocationArray[$objNewLocation->LocationId] = $objNewLocation->ShortDescription;
}
}
$j++;
}
if (count($strLocationValuesArray)) {
$objDatabase = Location::GetDatabase();
$objDatabase->NonQuery(sprintf("INSERT INTO `location` (`short_description`, `created_by`, `creation_date`) VALUES %s;", implode(", ", $strLocationValuesArray)));
$intStartId = $objDatabase->InsertId();
for ($i = 0; $i < count($strNewLocation); $i++) {
$this->objNewLocationArray[$intStartId + $i] = $strNewLocation[$i];
}
}
$this->btnNext->RemoveAllActions('onclick');
// Add new ajax actions for button
$this->btnNext->AddAction(new QClickEvent(), new QAjaxAction('btnNext_Click'));
$this->btnNext->AddAction(new QClickEvent(), new QToggleEnableAction($this->btnNext));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QAjaxAction('btnNext_Click'));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QToggleEnableAction($this->btnNext));
$this->btnNext->AddAction(new QEnterKeyEvent(), new QTerminateAction());
$this->btnNext->Warning = "Locations have been imported. Please wait...";
$this->intImportStep = 2;
$this->intCurrentFile = 0;
$this->strSelectedValueArray = array();
// New locations
$this->dtgLocation = new QDataGrid($this);
$this->dtgLocation->Name = 'location_list';
$this->dtgLocation->CellPadding = 5;
$this->dtgLocation->CellSpacing = 0;
$this->dtgLocation->CssClass = "datagrid";
$this->dtgLocation->UseAjax = true;
$this->dtgLocation->ShowColumnToggle = false;
$this->dtgLocation->ShowExportCsv = false;
$this->dtgLocation->ShowHeader = false;
$this->dtgLocation->AddColumn(new QDataGridColumnExt('Location', '<?= $_ITEM ?>', 'CssClass="dtg_column"', 'HtmlEntities="false"'));
// New categories
$this->dtgCategory = new QDataGrid($this);
$this->dtgCategory->Name = 'category_list';
$this->dtgCategory->CellPadding = 5;
示例4: btnNext_Click
//.........这里部分代码省略.........
$objLocation = null;
if ($this->lstImportAction->SelectedValue == 2) {
$intItemId = intval(trim($strRowArray[$this->intItemIdKey]));
foreach ($objLocationArray as $objItem) {
if ($objItem->LocationId == $intItemId) {
$objLocation = $objItem;
break;
}
}
} else {
$intItemId = 0;
}
// Create action
if (trim($strRowArray[$this->intLocationKey]) && (!$intItemId || !$objLocation) && !$this->in_array_nocase(trim($strRowArray[$this->intLocationKey]), $strLocationArray)) {
$strLocationArray[] = trim($strRowArray[$this->intLocationKey]);
$strLocationDescription = "";
if (isset($this->intLocationDescriptionKey)) {
if (trim($strRowArray[$this->intLocationDescriptionKey])) {
$strLocationDescription = trim($strRowArray[$this->intLocationDescriptionKey]);
} else {
$strLocationDescription = isset($this->txtMapDefaultValueArray[$this->intLocationDescriptionKey]) ? trim($this->txtMapDefaultValueArray[$this->intLocationDescriptionKey]->Text) : '';
}
}
$strLocationValuesArray[] = sprintf("('%s', '%s', '%s', NOW())", addslashes(trim($strRowArray[$this->intLocationKey])), addslashes($strLocationDescription), $_SESSION['intUserAccountId']);
$strNewLocationArray[] = addslashes(trim($strRowArray[$this->intLocationKey]));
/*$strCFVArray = array();
// Custom Field import
foreach ($arrItemCustomField as $objCustomField) {
if ($objCustomField->CustomFieldQtypeId != 2) {
$strShortDescription = (trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]])) ? addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]])) : addslashes($this->txtMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->Text);
$strCFVArray[$objCustomField->CustomFieldId] = ($strShortDescription) ? sprintf("'%s'", $strShortDescription) : "NULL";
}
else {
$objDatabase = CustomField::GetDatabase();
$strShortDescription = addslashes(trim($strRowArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]));
$blnInList = false;
foreach (CustomFieldValue::LoadArrayByCustomFieldId($objCustomField->CustomFieldId) as $objCustomFieldValue) {
if (strtolower($objCustomFieldValue->ShortDescription) == strtolower($strShortDescription)) {
$blnInList = true;
break;
}
}
// Add the CustomFieldValue
if (!$blnInList && !in_array($strShortDescription, $strAddedCFVArray)) {
$strQuery = sprintf("INSERT INTO custom_field_value (custom_field_id, short_description, created_by, creation_date) VALUES (%s, '%s', %s, NOW());", $objCustomField->CustomFieldId, $strShortDescription, $_SESSION['intUserAccountId']);
$objDatabase->NonQuery($strQuery);
$strAddedCFVArray[] = $strShortDescription;
}
elseif (!$blnInList && $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedValue != null) {
$strShortDescription = $this->lstMapDefaultValueArray[$intItemCustomFieldKeyArray[$objCustomField->CustomFieldId]]->SelectedName;
}
if ($strShortDescription/* && $intCustomFieldValueId*/
/*) {
$strCFVArray[$objCustomField->CustomFieldId] = sprintf("'%s'", $strShortDescription);
}
else {
$strCFVArray[$objCustomField->CustomFieldId] = "NULL";
}
}
}
if (isset($strCFVArray) && count($strCFVArray)) {
$strItemCFVArray[] = implode(', ', $strCFVArray);
}
else {
$strItemCFVArray[] = "";
}*/