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; } }