private function GetAssetsData()
{
$objClauses = array();
array_push($objClauses, QQ::OrderBy(QQN::Myassets()->Title));
if ($objClause = $this->dtrAssets->LimitClause) {
array_push($objClauses, $this->dtrAssets->LimitClause);
}
if ($this->txtSearchAssets->Text != '') {
$condition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Myassets()->Title, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Author, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Artist, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Actor, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Director, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Publisher, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Label, '%' . $this->txtSearchAssets->Text . '%'), QQ::Like(QQN::Myassets()->Isbn, '%' . $this->txtSearchAssets->Text . '%')), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
} else {
$condition = QQ::AndCondition(QQ::NotEqual(QQN::Myassets()->Asin, ''), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
}
$arrResult = Myassets::QueryArray($condition, $objClauses);
$this->dtrAssets->TotalItemCount = Myassets::QueryCount($condition);
$this->dtrAssets->DataSource = $arrResult;
}
<?php
include_once 'prepend.inc.php';
$cndASIN = QQ::AndCondition(QQ::Equal(QQN::Myassets()->Asin, $_ITEM->ASIN), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
$cndTitle = QQ::AndCondition(QQ::Equal(QQN::Myassets()->Title, $_ITEM->ASIN), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
$cntASIN = Myassets::QueryCount($cndASIN);
$cntTitle = Myassets::QueryCount($cndTitle);
if ($cntASIN != 0 || $cntTitle != 0) {
$owned = true;
} else {
$owned = false;
}
?>
<table>
<tr>
<td><?php
try {
if (isset($_ITEM->MediumImage->Url)) {
$img = $_ITEM->MediumImage->Url;
} else {
$img = '../assets/images/48x48/help.png';
}
} catch (Exception $e) {
$img = '../../assets/images/48x48/help.png';
}
?>
<img src='<?php
_p($img);
?>
' width=108px height=160px></img></td>
<td>
/**
* Count all Myassetses
* @return int
*/
public static function CountAll()
{
// Call Myassets::QueryCount to perform the CountAll query
return Myassets::QueryCount(QQ::All());
}
private function GetAssetsData($productgroup)
{
$objClauses = array();
array_push($objClauses, QQ::OrderBy(QQN::Myassets()->Title));
if ($objClause = $this->dtrMyLibrary->LimitClause) {
array_push($objClauses, $this->dtrMyLibrary->LimitClause);
}
if ($this->txtSearchTerm->Text == "") {
$condition = QQ::AndCondition(QQ::Equal(QQN::Myassets()->ProductGroup, $productgroup), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
$arrResult = Myassets::QueryArray($condition, $objClauses);
$this->dtrMyLibrary->TotalItemCount = Myassets::QueryCount($condition);
$this->dtrMyLibrary->DataSource = $arrResult;
} else {
$objCondition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Myassets()->Title, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Author, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Artist, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Actor, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Director, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Publisher, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Label, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Myassets()->Isbn, '%' . $this->txtSearchTerm->Text . '%')), QQ::Equal(QQN::Myassets()->ProductGroup, $productgroup), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
$objDbResult = Myassets::QueryArray($objCondition, $objClauses);
$myassets = $objDbResult;
$this->dtrMyLibrary->TotalItemCount = Myassets::QueryCount($objCondition);
if ($this->dtrMyLibrary->TotalItemCount > 0) {
$this->dtrMyLibrary->DataSource = $myassets;
} else {
QApplicationBase::DisplayAlert('No ' . $productgroup . 's exists for the searched term');
}
}
}