protected function GetAssetLog()
{
$objClauses = array();
array_push($objClauses, QQ::OrderBy(QQN::Assetsauditlog()->RealReturnDate));
if ($this->txtSearchTerm->Text == "") {
$condition = QQ::Equal(QQN::Assetsauditlog()->Owner, $_SESSION['User']);
$myassets = Assetsauditlog::QueryArray($condition, $objClauses);
} else {
$objCondition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Assetsauditlog()->Asin, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Assetsauditlog()->Email, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Assetsauditlog()->Title, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Assetsauditlog()->FullName, '%' . $this->txtSearchTerm->Text . '%')), QQ::Equal(QQN::Assetsauditlog()->Owner, $_SESSION['User']));
$objDbResult = Assetsauditlog::QueryArray($objCondition, $objClauses);
$myassets = $objDbResult;
}
return $myassets;
}
protected function btnDelete_Click($strFormId, $strControlId, $strParameter)
{
$objAssetAuditLog = new Assetsauditlog();
$objAssetAuditLog->Asin = $this->txtAsin->Text;
$objAssetAuditLog->Email = $this->txtEmail->Text;
$objAssetAuditLog->TakenDate = $this->calTakenDate->DateTime;
$objAssetAuditLog->ActualReturnDate = $this->calReturnDate->DateTime;
$objAssetAuditLog->Title = $this->txtTitle->Text;
$objAssetAuditLog->FullName = $this->txtFullName->Text;
$objAssetAuditLog->RealReturnDate = $this->calActualReturnDate->DateTime;
$objAssetAuditLog->Save();
// Delegate "Delete" processing to the SharedetailsMetaControl
$this->mctSharedetails->DeleteSharedetails();
$this->RedirectToListPage();
}
/**
* Static Helper Method to Create using PK arguments
* You must pass in the PK arguments on an object to load, or leave it blank to create a new one.
* If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo
* static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to
* edit, or if we are also allowed to create a new one, etc.
*
* @param mixed $objParentObject QForm or QPanel which will be using this AssetsauditlogMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing Assetsauditlog object creation - defaults to CreateOrEdit
* @return AssetsauditlogMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objAssetsauditlog = Assetsauditlog::Load($intId);
// Assetsauditlog was found -- return it!
if ($objAssetsauditlog) {
return new AssetsauditlogMetaControl($objParentObject, $objAssetsauditlog);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a Assetsauditlog object with PK arguments: ' . $intId);
}
}
// If EditOnly is specified, throw an exception
} else {
if ($intCreateType == QMetaControlCreateType::EditOnly) {
throw new QCallerException('No PK arguments specified');
}
}
// If we are here, then we need to create a new record
return new AssetsauditlogMetaControl($objParentObject, new Assetsauditlog());
}
/**
* Default / simple DataBinder for this Meta DataGrid. This can easily be overridden
* by calling SetDataBinder() on this DataGrid with another DataBinder of your choice.
*
* 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).
*/
public function MetaDataBinder()
{
// Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = Assetsauditlog::CountAll();
}
// Setup the $objClauses Array
$objClauses = array();
// 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 Assetsauditlog, given the clauses above
$this->DataSource = Assetsauditlog::LoadAll($objClauses);
}
