public static function LoadArrayDepreciatedByAssetModelId($intAssetModelId)
{
try {
return Asset::QueryArray(QQ::AndCondition(QQ::Equal(QQN::Asset()->AssetModelId, $intAssetModelId), QQ::Equal(QQN::Asset()->DepreciationFlag, 1)));
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
public function btnAssetSearchToolAdd_Click()
{
$this->ctlAssetSearchTool->lblWarning->Text = "";
$intSelectedAssetId = $this->ctlAssetSearchTool->ctlAssetSearch->dtgAsset->GetSelected("AssetId");
if (count($intSelectedAssetId) < 1) {
$this->ctlAssetSearchTool->lblWarning->Text = "No selected assets.";
} else {
$lblNewWarning = "";
foreach (Asset::QueryArray(QQ::In(QQN::Asset()->AssetId, $intSelectedAssetId)) as $objAsset) {
$this->txtNewAssetCode->Text = $objAsset->AssetCode;
$this->btnAddAsset_Click($this, null, null);
if ($this->txtNewAssetCode->Warning) {
$lblNewWarning .= sprintf("<br />%s - %s", $objAsset->AssetCode, $this->txtNewAssetCode->Warning);
$this->txtNewAssetCode->Warning = "";
}
}
$this->txtNewAssetCode->Warning = $lblNewWarning;
$this->ctlAssetSearchTool->dlgAssetSearchTool->HideDialogBox();
}
// Uncheck all items but SelectAll checkbox
$this->UncheckAllItems();
}
public function btnAssetSearchToolAdd_Click()
{
$intSelectedAssetId = $this->ctlAssetSearchTool->ctlAssetSearch->dtgAsset->GetSelected("AssetId");
if (count($intSelectedAssetId) < 1) {
$this->ctlAssetSearchTool->lblWarning->Text = "No selected assets.";
} else {
$lblNewWarning = "";
if (count($intSelectedAssetId) > 100) {
$currentLimit = ini_get('max_execution_time');
set_time_limit(0);
$this->ctlAssetSearchTool->lblWarning->Text = "This may take several minutes.";
}
foreach (Asset::QueryArray(QQ::In(QQN::Asset()->AssetId, $intSelectedAssetId)) as $objAsset) {
$this->txtNewAssetCode->Text = $objAsset->AssetCode;
$this->btnAdd_Click($this, null, null);
if ($this->txtNewAssetCode->Warning) {
$lblNewWarning .= sprintf("<br />%s - %s", $objAsset->AssetCode, $this->txtNewAssetCode->Warning);
$this->txtNewAssetCode->Warning = "";
}
}
if (count($intSelectedAssetId) > 100) {
set_time_limit($currentLimit);
$this->ctlAssetSearchTool->lblWarning->Text = "";
}
$this->txtNewAssetCode->Warning = $lblNewWarning;
$this->UncheckAllItems();
$this->ctlAssetSearchTool->dlgAssetSearchTool->HideDialogBox();
}
// Uncheck all items but SelectAll checkbox
}
/**
* Load an array of Asset objects,
* by ModifiedBy Index(es)
* @param integer $intModifiedBy
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return Asset[]
*/
public static function LoadArrayByModifiedBy($intModifiedBy, $objOptionalClauses = null)
{
// Call Asset::QueryArray to perform the LoadArrayByModifiedBy query
try {
return Asset::QueryArray(QQ::Equal(QQN::Asset()->ModifiedBy, $intModifiedBy), $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
protected function btnPrintLabels_Click()
{
//if ($this->blnPrintLabels) {
$this->strBarCodeArray = array();
$this->strTablesBufferArray = array();
$this->intCurrentBarCodeLabel = 0;
// Set start value for PDF generation progress bar
$_SESSION["intGeneratingStatus"] = 0;
set_time_limit(0);
$blnError = false;
// Array[0] - DataGrid Object name; array[1] - Id; array[2] - used for Bar Code Label Generation
$arrDataGridObjectNameId = $this->ctlSearchMenu->GetDataGridObjectNameId();
$this->intObjectIdArray = $this->ctlSearchMenu->{$arrDataGridObjectNameId}[0]->GetSelected($arrDataGridObjectNameId[1]);
$objCheckedArray = array();
if (count($this->intObjectIdArray)) {
// Switch statement for all four entity types
switch ($this->lstLabelTypeControl->SelectedValue) {
case 1:
// Load an array of Assets by AssetId
$objCheckedArray = Asset::QueryArray(QQ::In(QQN::Asset()->AssetId, $this->intObjectIdArray));
break;
case 2:
// Load an array of Inventories by InventoryModelId
$objCheckedArray = InventoryModel::QueryArray(QQ::In(QQN::InventoryModel()->InventoryModelId, $this->intObjectIdArray));
break;
case 3:
// Load an array of Locations by LocationId
$objCheckedArray = Location::QueryArray(QQ::In(QQN::Location()->LocationId, $this->intObjectIdArray));
break;
case 4:
$objCheckedArray = UserAccount::QueryArray(QQ::In(QQN::UserAccount()->UserAccountId, $this->intObjectIdArray));
break;
default:
$this->btnPrintLabels->Warning = "Please select Label Type.<br/>";
$this->intObjectIdArray = array();
$blnError = true;
break;
}
$objArrayById = array();
// Create array of objects where the key is Id
foreach ($objCheckedArray as $objChecked) {
$objArrayById[$objChecked->{$arrDataGridObjectNameId}[1]] = $objChecked;
}
// Fill the BarCodeArray in the order items sorted in the datagrid
foreach ($this->intObjectIdArray as $intObjectId) {
$this->strBarCodeArray[] = $objArrayById[$intObjectId]->{$arrDataGridObjectNameId}[2];
}
} else {
$blnError = true;
}
if (!$blnError) {
$this->btnPrintLabels->Warning = "";
$this->lstLabelStock->SelectedValue = 0;
$this->lstLabelOffset->RemoveAllItems();
$this->lstLabelOffset->AddItem(new QListItem('None', 0, 1));
$this->lstLabelStock->Enabled = true;
$this->lstLabelOffset->Enabled = true;
$this->dlgPrintLabels->ShowDialogBox();
} else {
// If we have no checked items
$this->btnPrintLabels->Warning .= "You must check at least one item.";
}
// Enable Print Labels button
$this->btnPrintLabels->Enabled = true;
//$this->blnPrintLabels = false;
/*}
else {
$this->btnPrintLabels->Warning = "Please wait... loading.";
$this->blnPrintLabels = true;
QApplication::ExecuteJavaScript("document.getElementById('".$this->btnPrintLabels->ControlId."').click(); document.getElementById('warning_loading').innerHTML = '';");
}*/
QApplication::ExecuteJavaScript("document.getElementById('warning_loading').innerHTML = '';");
}
/**
* Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but
* could and should be used by any custom databind methods that would be used for instances of this
* MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause.
*
* If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used.
* It will also perform any sorting (if applicable).
*
* @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
* @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query
* @return void
*/
public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null)
{
// Setup input parameters to default values if none passed in
if (!$objCondition) {
$objCondition = QQ::All();
}
$objClauses = $objOptionalClauses ? $objOptionalClauses : array();
// We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = Asset::QueryCount($objCondition, $objClauses);
}
// If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
// the OrderByClause to the $objClauses array
if ($objClause = $this->OrderByClause) {
array_push($objClauses, $objClause);
}
// Add the LimitClause information, as well
if ($objClause = $this->LimitClause) {
array_push($objClauses, $objClause);
}
// Set the DataSource to be a Query result from Asset, given the clauses above
$this->DataSource = Asset::QueryArray($objCondition, $objClauses);
}
/**
* Load an array of Asset objects,
* by ParentAssetId, LinkedFlag Index(es)
* @param integer $intParentAssetId
* @param boolean $blnLinkedFlag
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return Asset[]
*/
public static function LoadArrayByParentAssetIdLinkedFlag($intParentAssetId, $blnLinkedFlag, $objOptionalClauses = null)
{
// Call Asset::QueryArray to perform the LoadArrayByParentAssetIdLinkedFlag query
try {
return Asset::QueryArray(QQ::AndCondition(QQ::Equal(QQN::Asset()->ParentAssetId, $intParentAssetId), QQ::Equal(QQN::Asset()->LinkedFlag, $blnLinkedFlag)), $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}