protected function getGoogleContacts()
{
$objContacts = new GetContacts();
$arrContacts = $objContacts->GetGContacts($this->txtUser, $this->txtPassword);
$contactCount = sizeof($arrContacts);
foreach ($arrContacts as $person) {
$count = Peopledetails::QueryCount(QQ::Equal(QQN::Peopledetails()->Email, $person['contactMail']));
if ($count != 0) {
$objPerson = Peopledetails::QuerySingle(QQ::Equal(QQN::Peopledetails()->Email, $person['contactMail']));
} else {
$objPerson = new Peopledetails();
}
$objPerson->FullName = $person['contactName'];
$objPerson->Phone = $person['contactPhone'];
$objPerson->Address = $person['contactAddr'];
$objPerson->Email = $person['contactMail'];
$objPerson->Save();
}
QApplication::DisplayAlert('Successfully imported ' . $contactCount . 'contacts from Google Contacts');
}
public function MetaDataBinder()
{
$condition = QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User']);
// Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below
if ($this->Paginator) {
$this->TotalItemCount = Peopledetails::QueryCount($condition);
}
// 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 Peopledetails, given the clauses above
//$condition = QQ::Equal(QQN::Peopledetails()->Owner,$_SESSION['User']);
$this->DataSource = Peopledetails::QueryArray($condition, $objClauses);
//$this->DataSource = Peopledetails::LoadAll($objClauses);
}
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();
}
}
/**
* Load a single Peopledetails object,
* by Id Index(es)
* @param integer $intId
* @return Peopledetails
*/
public static function LoadById($intId)
{
return Peopledetails::QuerySingle(QQ::Equal(QQN::Peopledetails()->Id, $intId));
}
public static function GetContacts($strKeyword = null)
{
if (!is_null($strKeyword)) {
$condition = QQ::AndCondition(QQ::OrCondition(QQ::Like(QQN::Peopledetails()->FullName, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Email, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Address, '%' . $strKeyword . '%'), QQ::Like(QQN::Peopledetails()->Phone, '%' . $strKeyword . '%')), QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User']));
$objPeopleArray = Peopledetails::QueryArray($condition);
return $objPeopleArray;
} else {
$condition = QQ::Equal(QQN::Peopledetails()->Owner, $_SESSION['User']);
$objPeopleArray = Peopledetails::QueryArray($condition);
return $objPeopleArray;
}
}
/**
* Used internally by the Meta-based Add Column tools.
*
* Given a QQNode or a Text String, this will return a Peopledetails-based QQNode.
* It will also verify that it is a proper Peopledetails-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 == 'peopledetails') {
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 "peopledetails".');
}
} else {
if (is_string($mixContent)) {
switch ($mixContent) {
case 'Id':
return QQN::Peopledetails()->Id;
case 'FullName':
return QQN::Peopledetails()->FullName;
case 'Address':
return QQN::Peopledetails()->Address;
case 'Phone':
return QQN::Peopledetails()->Phone;
case 'Email':
return QQN::Peopledetails()->Email;
case 'Owner':
return QQN::Peopledetails()->Owner;
default:
throw new QCallerException('Simple Property not found in PeopledetailsDataGrid 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');
}
}
}
}
