protected function GetShareDetails()
{
$objClauses = array();
array_push($objClauses, QQ::OrderBy(QQN::Sharedetails()->ReturnDate));
if ($objClause = $this->dtrShareDetails->LimitClause) {
array_push($objClauses, $this->dtrShareDetails->LimitClause);
}
if ($this->txtSearchTerm->Text == "") {
$objCondition = QQ::Equal(QQN::Sharedetails()->Owner, $_SESSION['User']);
$myassets = Sharedetails::QueryArray($objCondition, $objClauses);
} else {
$objCondition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Sharedetails()->Asin, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Sharedetails()->Email, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Sharedetails()->TakenDate, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Sharedetails()->ReturnDate, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Sharedetails()->Title, '%' . $this->txtSearchTerm->Text . '%'), QQ::Like(QQN::Sharedetails()->FullName, '%' . $this->txtSearchTerm->Text . '%')), QQ::Equal(QQN::Myassets()->Owner, $_SESSION['User']));
$objDbResult = Sharedetails::QueryArray($objCondition, $objClauses);
$myassets = $objDbResult;
}
//$this->dtrShareDetails->TotalItemCount = Sharedetails::QueryCount($condition);
$this->arrShareDetails = $myassets;
return $objCondition;
}
<br/>
<?php
include_once 'prepend.inc.php';
$name = '';
$chkCondition = new QQConditionEqual(QQN::Sharedetails()->Asin, $_ITEM->Asin);
$cnt = Sharedetails::QueryCount($chkCondition);
$objShare = Sharedetails::QueryArray($chkCondition);
foreach ($objShare as $val) {
$name = $val->FullName;
}
/*
* If the item is shared so not show it.
*/
if ($cnt == 0) {
?>
<table>
<tr>
<td>
<div>
<?php
if ($_ITEM->ImageURL != '') {
$img = $_ITEM->ImageURL;
} else {
$img = '../assets/images/48x48/help.png';
}
?>
<img src='<?php
_p($img);
?>
/**
* Load all Sharedetailses
* @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query
* @return Sharedetails[]
*/
public static function LoadAll($objOptionalClauses = null)
{
if (func_num_args() > 1) {
throw new QCallerException("LoadAll must be called with an array of optional clauses as a single argument");
}
// Call Sharedetails::QueryArray to perform the LoadAll query
try {
return Sharedetails::QueryArray(QQ::All(), $objOptionalClauses);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
