Exemple #1
0
 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;
 }
Exemple #2
0
 protected function LendBasket()
 {
     foreach ($this->objBasket->GetBasket() as $item) {
         $objItem = Myassets::QuerySingle(QQ::Equal(QQN::Myassets()->Id, $item->Id));
         $objPerson = Peopledetails::QuerySingle(QQ::Equal(QQN::Peopledetails()->Id, $this->strBorrower));
         $objShareDetails = new Sharedetails();
         $objShareDetails->Asin = $objItem->Asin;
         $objShareDetails->Email = $objPerson->Email;
         /*Logic to get the return date*/
         $today = new QDateTime(QDateTime::Now);
         $daySpan = new QDateTimeSpan();
         $daySpan->AddDays(30);
         $returnDate = $today->Add($daySpan);
         $objShareDetails->TakenDate = QDateTime::Now(false);
         $objShareDetails->ReturnDate = $returnDate;
         $objShareDetails->Title = $objItem->Title;
         $objShareDetails->FullName = $objPerson->FullName;
         $objShareDetails->Save();
     }
 }
Exemple #3
0
 /**
  * Load a single Myassets object,
  * by Id Index(es)
  * @param integer $intId
  * @return Myassets
  */
 public static function LoadById($intId)
 {
     return Myassets::QuerySingle(QQ::Equal(QQN::Myassets()->Id, $intId));
 }
 /**
  * Used internally by the Meta-based Add Column tools.
  *
  * Given a QQNode or a Text String, this will return a Myassets-based QQNode.
  * It will also verify that it is a proper Myassets-based QQNode, and will throw an exception otherwise.
  *
  * @param mixed $mixContent
  * @return QQNode
  */
 protected function ResolveContentItem($mixContent)
 {
     if ($mixContent instanceof QQNode) {
         if (!$mixContent->_ParentNode) {
             throw new QCallerException('Content QQNode cannot be a Top Level Node');
         }
         if ($mixContent->_RootTableName == 'myassets') {
             if ($mixContent instanceof QQReverseReferenceNode && !$mixContent->_PropertyName) {
                 throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
             }
             $objCurrentNode = $mixContent;
             while ($objCurrentNode = $objCurrentNode->_ParentNode) {
                 if (!$objCurrentNode instanceof QQNode) {
                     throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
                 }
                 if ($objCurrentNode instanceof QQReverseReferenceNode && !$objCurrentNode->_PropertyName) {
                     throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
                 }
             }
             return $mixContent;
         } else {
             throw new QCallerException('Content QQNode has a root table of "' . $mixContent->_RootTableName . '". Must be a root of "myassets".');
         }
     } else {
         if (is_string($mixContent)) {
             switch ($mixContent) {
                 case 'Id':
                     return QQN::Myassets()->Id;
                 case 'Asin':
                     return QQN::Myassets()->Asin;
                 case 'DetailPageURL':
                     return QQN::Myassets()->DetailPageURL;
                 case 'Title':
                     return QQN::Myassets()->Title;
                 case 'ProductGroup':
                     return QQN::Myassets()->ProductGroup;
                 case 'ImageURL':
                     return QQN::Myassets()->ImageURL;
                 case 'Author':
                     return QQN::Myassets()->Author;
                 case 'NumberOfPages':
                     return QQN::Myassets()->NumberOfPages;
                 case 'Publisher':
                     return QQN::Myassets()->Publisher;
                 case 'Isbn':
                     return QQN::Myassets()->Isbn;
                 case 'Actor':
                     return QQN::Myassets()->Actor;
                 case 'Director':
                     return QQN::Myassets()->Director;
                 case 'RunningTime':
                     return QQN::Myassets()->RunningTime;
                 case 'Artist':
                     return QQN::Myassets()->Artist;
                 case 'Label':
                     return QQN::Myassets()->Label;
                 case 'NumberOfDiscs':
                     return QQN::Myassets()->NumberOfDiscs;
                 case 'Tracks':
                     return QQN::Myassets()->Tracks;
                 case 'Language':
                     return QQN::Myassets()->Language;
                 case 'Genre':
                     return QQN::Myassets()->Genre;
                 case 'Owner':
                     return QQN::Myassets()->Owner;
                 default:
                     throw new QCallerException('Simple Property not found in MyassetsDataGrid content: ' . $mixContent);
             }
         } else {
             if ($mixContent instanceof QQAssociationNode) {
                 throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
             } else {
                 throw new QCallerException('Invalid Content type');
             }
         }
     }
 }
Exemple #5
0
<?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>
Exemple #6
0
 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');
         }
     }
 }