protected function Form_Create()
{
// Define the DataGrid -- note that the Meta DataGrid is a DataGrid, itself --
// so let's just use it as a datagrid
$this->dtgProjects = new ProjectDataGrid($this);
// DataBinding is already configured -- so we do not need to worry about it
// But remember that dtgProjects is just a regular datagrid, as well
// So we can configure as we see fit, e.g. adding pagination or styling
$this->dtgProjects->Paginator = new QPaginator($this->dtgProjects);
$this->dtgProjects->ItemsPerPage = 6;
$this->dtgProjects->AlternateRowStyle->CssClass = 'alternate';
// All we need to do is to utilize the ProjectDataGrid built-in functionality
// to create, define and setup the various columns that WE choose, in the order
// that WE want. NOTE that we use simple string-based property names, OR QQuery
// node descriptors to specify what we want for each column.
$this->dtgProjects->MetaAddColumn('Name');
$this->dtgProjects->MetaAddColumn('StartDate');
$this->dtgProjects->MetaAddColumn(QQN::Project()->EndDate);
// We can easily add columns from linked/related tables. However, to do this
// you MUST use a QQuery node descriptor. No string-based properties allowed.
// Bonus: the Meta DataGrid will even automatically add sorting for columns in related tables.
$colUsername = $this->dtgProjects->MetaAddColumn(QQN::Project()->ManagerPerson->Login->Username);
// And remember, since it's a regular datagrid with regular columns,
// we can stylize as we see fit
$colUsername->BackColor = '#cef';
$colUsername->Name = 'Manager\'s Username';
// Also, note that MetaAddColumn and MetaAddTypeColumn can use attribute overriding as well
$this->dtgProjects->MetaAddTypeColumn('ProjectStatusTypeId', 'ProjectStatusType', 'FontBold=true');
$this->pxyExample = new QControlProxy($this);
$this->pxyExample->AddAction(new QClickEvent(), new QAjaxAction('pxyExample_Click'));
// FInally, there are even Meta methods to add an Edit Button column
$this->dtgProjects->MetaAddEditProxyColumn($this->pxyExample, 'Click Me', 'Faux Edit Column');
}
/**
* Bind the Projects table to the html table.
*
* @throws QCallerException
*/
protected function tblProjects_Bind()
{
// Expand the PersonAsTeamMember node as an array so that it will be included in each item sent to the columns.
$clauses = QQ::ExpandAsArray(QQN::Project()->PersonAsTeamMember);
// We load the data source, and set it to the datagrid's DataSource parameter
$this->tblProjects->DataSource = Project::LoadAll($clauses);
}
protected function Form_Create()
{
// Instantiate the DataGrid
$this->dtgProjects = new QDataGrid($this);
// Style the DataGrid
//$this->dtgProjects->CssClass = 'datagrid';
$this->dtgProjects->AlternateRowCssClass = 'alternate';
// Add Pagination
$this->dtgProjects->Paginator = new QPaginator($this->dtgProjects);
$this->dtgProjects->ItemsPerPage = 3;
// Add columns
// Create a column that will hold a toggle button. We will need to manually draw the content of the cell.
$col = $this->dtgProjects->CreateCallableColumn('', [$this, 'render_btnToggleRecordsSummary']);
$col->HtmlEntities = false;
$col->CellStyler->Width = "1%";
$this->dtgProjects->CreateNodeColumn('Id', QQN::Project()->Id);
$this->dtgProjects->CreateNodeColumn('Name', QQN::Project()->Name);
$this->dtgProjects->CreateNodeColumn('Status', QQN::Project()->ProjectStatusType);
$this->dtgProjects->CreateNodeColumn('Description', QQN::Project()->Description);
$this->dtgProjects->CreateNodeColumn('Start Date', QQN::Project()->StartDate);
$this->dtgProjects->CreateNodeColumn('End Date', QQN::Project()->EndDate);
$this->dtgProjects->CreateNodeColumn('Budget', QQN::Project()->Budget);
$this->dtgProjects->CreateNodeColumn('Spent', QQN::Project()->Spent);
// Create a column that will hold a child datagrid
$col = $this->dtgProjects->CreateCallableColumn('', [$this, 'render_ucRecordsSummary']);
$col->HtmlEntities = false;
$col->CellStyler->Width = 0;
// Specify the Datagrid's Data Binder method
$this->dtgProjects->SetDataBinder('dtgProjects_Bind');
// For purposes of this example, add a css file that styles the table.
// Normally you would include your global style sheets in your tpl file or header.inc.php file.
$this->dtgProjects->AddCssFile(__QCUBED_ASSETS__ . '/php/examples/master_detail/styles.css');
}
/**
* This constructor will only be executed once - afterwards,
* the state of the control will be stored into the $_SESSION
* and, on future loads, populated from the session state.
*/
public function __construct($objParentObject)
{
parent::__construct($objParentObject);
$projects = Project::QueryArray(QQ::All(), QQ::OrderBy(QQN::Project()->Name));
foreach ($projects as $project) {
$this->AddItem($project->Name, $project->Id);
}
}
protected function dtgProjects_Create()
{
// Define the DataGrid
$this->dtgProjects = new QDataGrid($this);
$this->dtgProjects->ShowFilter = true;
// To create pagination, we will create a new paginator, and specify the datagrid
// as the paginator's parent. (We do this because the datagrid is the control
// who is responsible for rendering the paginator, as opposed to the form.)
$objPaginator = new QPaginator($this->dtgProjects);
$this->dtgProjects->Paginator = $objPaginator;
// Now, with a paginator defined, we can set up some additional properties on
// the datagrid. For purposes of this example, let's make the datagrid show
// only 5 items per page.
$this->dtgProjects->ItemsPerPage = 20;
// Define Columns
//Project Name
$colName = new QDataGridColumn('Project', '<?= $_ITEM->Name?>');
$colName->OrderByClause = QQ::OrderBy(QQN::Project()->Name);
$colName->ReverseOrderByClause = QQ::OrderBy(QQN::Project()->Name, false);
$this->dtgProjects->AddColumn($colName);
//Project type - filtered
$colType = new QDataGridColumn('Type', '<?= ProjectStatusType::ToString($_ITEM->ProjectStatusTypeId) ?>');
$colType->OrderByClause = QQ::OrderBy(QQN::Project()->ProjectStatusTypeId);
$colType->ReverseOrderByClause = QQ::OrderBy(QQN::Project()->ProjectStatusTypeId, false);
$colType->FilterType = QFilterType::ListFilter;
foreach (ProjectStatusType::$NameArray as $value => $name) {
$colType->FilterAddListItem($name, QQ::Equal(QQN::Project()->ProjectStatusTypeId, $value));
}
$this->dtgProjects->AddColumn($colType);
//Manager First Name
$colFName = new QDataGridColumn('First Name', '<?= $_ITEM->ManagerPerson->FirstName ?>');
$colFName->OrderByClause = QQ::OrderBy(QQN::Project()->ManagerPerson->FirstName);
$colFName->ReverseOrderByClause = QQ::OrderBy(QQN::Project()->ManagerPerson->FirstName, false);
$this->dtgProjects->AddColumn($colFName);
//Manager Last Name - filtered, only show with enabled logins
$colLName = new QDataGridColumn('Last Name', '<?= $_ITEM->ManagerPerson->LastName ?>');
$colLName->OrderByClause = QQ::OrderBy(QQN::Project()->ManagerPerson->LastName);
$colLName->ReverseOrderByClause = QQ::OrderBy(QQN::Project()->ManagerPerson->LastName, false);
QQN::Project()->ManagerPerson->LastName->SetFilteredDataGridColumnFilter($colLName);
$colLName->FilterConstant = QQ::Equal(QQN::Project()->ManagerPerson->Login->IsEnabled, true);
$this->dtgProjects->AddColumn($colLName);
// Specify the Datagrid's Data Binder method
$this->dtgProjects->SetDataBinder('dtgProjects_Bind');
/* * *********************** */
// Make the DataGrid look nice
$objStyle = $this->dtgProjects->RowStyle;
$objStyle->FontSize = 12;
$objStyle = $this->dtgProjects->AlternateRowStyle;
$objStyle->BackColor = '#f6f6f6';
$objStyle = $this->dtgProjects->HeaderRowStyle;
$objStyle->ForeColor = 'white';
$objStyle->BackColor = '#780000';
// Because browsers will apply different styles/colors for LINKs
// We must explicitly define the ForeColor for the HeaderLink.
// The header row turns into links when the column can be sorted.
$objStyle = $this->dtgProjects->HeaderLinkStyle;
$objStyle->ForeColor = 'white';
}
protected function Go_Click()
{
QApplication::$blnLocalCache = false;
$timeNoCache = -microtime(true);
$a = Person::LoadAll();
// noncached loads
$timeNoCache += microtime(true);
QApplication::$blnLocalCache = true;
$timeLoad1Cached = -microtime(true);
$a = Person::LoadAll();
// noncached loads
$timeLoad1Cached += microtime(true);
$timeLoad2Cached = -microtime(true);
$a = Person::LoadAll();
// cached loads
$timeLoad2Cached += microtime(true);
QApplication::$blnLocalCache = new QCacheProviderLocalMemory(array());
$timeLoad3Cached = -microtime(true);
$a = Person::LoadAll();
// noncached loads
$timeLoad3Cached += microtime(true);
$timeLoad4Cached = -microtime(true);
$a = Person::LoadAll();
// cached loads
$timeLoad4Cached += microtime(true);
$this->pnlTiny->Text = sprintf("Load No Cache: %2.1f%% \n", 100 * $timeNoCache / $timeNoCache) . sprintf("Populate Cache: %2.1f%% \n", 100 * $timeLoad1Cached / $timeNoCache) . sprintf("Load With Cache: %2.1f%% \n", 100 * $timeLoad2Cached / $timeNoCache) . sprintf("Populate LocalCacheProvider: %2.1f%% \n", 100 * $timeLoad3Cached / $timeNoCache) . sprintf("Load LocalCacheProvider: %2.1f%% \n", 100 * $timeLoad4Cached / $timeNoCache);
$cond = QQ::Equal(QQN::Project()->ProjectStatusTypeId, ProjectStatusType::Open);
$clauses[] = QQ::Expand(QQN::Project()->ManagerPerson);
Project::ClearCache();
Person::ClearCache();
QApplication::$blnLocalCache = false;
$timeNoCache = -microtime(true);
$a = Project::QueryArray($cond, $clauses);
// noncached loads
$timeNoCache += microtime(true);
QApplication::$blnLocalCache = true;
$timeLoad1Cached = -microtime(true);
$a = Project::QueryArray($cond, $clauses);
// noncached loads
$timeLoad1Cached += microtime(true);
$timeLoad2Cached = -microtime(true);
$a = Project::QueryArray($cond, $clauses);
// cached loads
$timeLoad2Cached += microtime(true);
QApplication::$blnLocalCache = new QCacheProviderLocalMemory(array());
$timeLoad3Cached = -microtime(true);
$a = Project::QueryArray($cond, $clauses);
// noncached loads
$timeLoad3Cached += microtime(true);
$timeLoad4Cached = -microtime(true);
$a = Project::QueryArray($cond, $clauses);
// cached loads
$timeLoad4Cached += microtime(true);
$this->pnlBig->Text = sprintf("Load No Cache: %2.1f%% \n", 100 * $timeNoCache / $timeNoCache) . sprintf("Populate Cache: %2.1f%% \n", 100 * $timeLoad1Cached / $timeNoCache) . sprintf("Load With Cache: %2.1f%% \n", 100 * $timeLoad2Cached / $timeNoCache) . sprintf("Populate LocalCacheProvider: %2.1f%% \n", 100 * $timeLoad3Cached / $timeNoCache) . sprintf("Load LocalCacheProvider: %2.1f%% \n", 100 * $timeLoad4Cached / $timeNoCache);
}
public function testGroupBy()
{
$objItems = Project::QueryArray(QQ::All(), QQ::Clause(QQ::GroupBy(QQN::Project()->Id), QQ::Count(QQN::Project()->PersonAsTeamMember->PersonId, 'team_member_count')));
$this->assertEqual(sizeof($objItems), 4, "4 projects found");
$this->assertEqual($objItems[0]->Name, "ACME Website Redesign", "Project " . $objItems[0]->Name . " found");
$this->assertEqual($objItems[0]->GetVirtualAttribute('team_member_count'), 5, "5 team members found for project " . $objItems[0]->Name);
$this->assertEqual($objItems[1]->Name, "State College HR System", "Project " . $objItems[1]->Name . " found");
$this->assertEqual($objItems[1]->GetVirtualAttribute('team_member_count'), 6, "6 team members found for project " . $objItems[1]->Name);
$this->assertEqual($objItems[2]->Name, "Blueman Industrial Site Architecture", "Project " . $objItems[2]->Name . " found");
$this->assertEqual($objItems[2]->GetVirtualAttribute('team_member_count'), 5, "5 team members found for project " . $objItems[2]->Name);
}
/**
* This constructor will only be executed once - afterwards,
* the state of the control will be stored into the $_SESSION
* and, on future loads, populated from the session state.
*/
public function __construct($objParentObject, $strControlId)
{
parent::__construct($objParentObject, $strControlId);
$projects = Project::QueryArray(QQ::All(), QQ::OrderBy(QQN::Project()->Name));
foreach ($projects as $project) {
$this->AddItem($project->Name, $project->Id);
}
// Reset the status of the parent form's label to indicate
// that the query was actually run
$objParentObject->lblStatus->Text = "The query was executed";
}
public function testDbTypeCasting()
{
$dt1 = new QDateTime('Jan 15 2006');
$dt2 = new QDateTime('Mar 15 2006');
$cond = QQ::Between(QQN::Project()->StartDate, $dt1, $dt2);
$a = Project::QueryArray($cond);
$this->assertEquals(2, count($a), "Between 2 QDateTime types works");
$cond = QQ::Between(QQN::Project()->Budget, 2000, 3000);
$a = Project::QueryArray($cond);
$this->assertEquals(1, count($a), "Between 2 int types works");
$cond = QQ::Between(QQN::Project()->Name, 'A', 'C');
$a = Project::QueryArray($cond);
$this->assertEquals(3, count($a), "Between 2 string types works");
}
/**
* Add the items to the project list.
*/
public function lstProjects_Bind()
{
$clauses[] = QQ::ExpandAsArray(QQN::Project()->PersonAsTeamMember);
$objProjects = Project::QueryArray(QQ::All(), $clauses);
foreach ($objProjects as $objProject) {
$item = new QHListItem($objProject->Name);
$item->Tag = 'ol';
$item->GetSubTagStyler()->OrderedListType = QOrderedListType::LowercaseRoman;
foreach ($objProject->_PersonAsTeamMemberArray as $objPerson) {
/****
* Here we add a sub-item to each item before adding the item to the main list.
*/
$item->AddItem($objPerson->FirstName . ' ' . $objPerson->LastName);
}
$this->lstProjects->AddItem($item);
}
}
protected function Form_Create()
{
// Setup the Dropdown of Project Names
$this->lstProjects = new QListBox($this);
$this->lstProjects->AddItem('- Select One -', null, true);
foreach (Project::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Project()->Name))) as $objProject) {
$this->lstProjects->AddItem($objProject->Name, $objProject->Id);
}
$this->lstProjects->AddAction(new QChangeEvent(), new QAjaxAction('lstProjects_Change'));
// Setup our Left and Right Panel Placeholders
// Notice that both panels have "AutoRenderChildren" set to true so that
// instantiated child panels will automatically get displayed
$this->pnlLeft = new QPanel($this);
$this->pnlLeft->Position = QPosition::Relative;
$this->pnlLeft->CssClass = 'panelDefault';
$this->pnlLeft->AutoRenderChildren = true;
$this->pnlRight = new QPanel($this);
$this->pnlRight->Position = QPosition::Relative;
$this->pnlRight->CssClass = 'panelDefault panelRight';
$this->pnlRight->AutoRenderChildren = true;
$this->objDefaultWaitIcon = new QWaitIcon($this);
}
protected function Form_Create()
{
// Define the DataGrid -- note that the DataGrid Connector is a DataGrid, itself --
// so let's just use it as a datagrid
$this->dtgProjects = new ProjectList($this);
$this->dtgProjects->SetDataBinder('DefaultDataBinder', $this);
// Only show projects whose status is "open"
$this->objAdditionalConditions = QQ::Equal(QQN::Project()->ProjectStatusTypeId, ProjectStatusType::Open);
//expand on the ManagerPerson's login, since we're displaying it
$this->objAdditionalClauses = array(QQ::Expand(QQN::Project()->ManagerPerson), QQ::Expand(QQN::Project()->ManagerPerson->Login));
// DataBinding is already configured -- so we do not need to worry about it
// But remember that dtgProjects is just a regular datagrid, as well
// So we can configure as we see fit, e.g. adding pagination or styling
$this->dtgProjects->Paginator = new QPaginator($this->dtgProjects);
$this->dtgProjects->ItemsPerPage = 6;
$this->dtgProjects->AlternateRowCssClass = 'alternate';
// All we need to do is to utilize the ProjectDataGrid built-in functionality
// to create, define and setup the various columns that WE choose, in the order
// that WE want.
$this->dtgProjects->CreateNodeColumn('Name', QQN::Project()->Name);
$this->dtgProjects->CreateNodeColumn('StartDate', QQN::Project()->StartDate);
$this->dtgProjects->CreateNodeColumn("EndDate", QQN::Project()->EndDate);
// We can easily add columns from linked/related tables. However, to do this
// you MUST use a QQuery node descriptor. No string-based properties allowed.
// Bonus: the DataGrid Connector will even automatically add sorting for columns in related tables.
$colUsername = $this->dtgProjects->CreateNodeColumn('Username', QQN::Project()->ManagerPerson->Login->Username);
// And remember, since it's a regular datagrid with regular columns,
// we can stylize as we see fit
$colUsername->CellParamsCallback = [$this, 'GetUserNameCellParams'];
$colUsername->Name = 'Manager\'s Username';
$colStatus = $this->dtgProjects->CreateNodeColumn('ProjectStatusType', QQN::Project()->ProjectStatusType);
$colStatus->HtmlEntities = false;
$colStatus->Format = '<strong>%s</strong>';
$this->pxyExample = new QControlProxy($this);
$this->pxyExample->AddAction(new QClickEvent(), new QAjaxAction('pxyExample_Click'));
}
public function dtgProjects_Bind()
{
// Get Total Count b/c of Pagination
$this->dtgProjects->TotalItemCount = Project::CountAll();
$objClauses = array();
if ($objClause = $this->dtgProjects->OrderByClause) {
$objClauses[] = $objClause;
}
if ($objClause = $this->dtgProjects->LimitClause) {
$objClauses[] = $objClause;
}
// Create a virtual attribute that lets us know if this Project is related to ACME
$objClauses[] = QQ::Expand(QQ::Virtual('assn_item', QQ::SubSql('select
project_id
from
related_project_assn
where
child_project_id = {1}
and project_id = 1', QQN::Project()->Id)));
$this->dtgProjects->DataSource = Project::LoadAll($objClauses);
}
<h3>Custom Load Query: Select all Projects with Budgets over $5000, ordered by Descending Budget</h3>
<?php
// Custom Load Queries must have a resultset that returns all the fields of the
// table which corresponds to the ORM class you want to instantiate
// Note that because the InstantiateDb* methods in your ORM classes are code generated
// it is actually safe to use "SELECT *" for your Custom Load Queries.
$strQuery = 'SELECT project.* FROM project WHERE budget > 5000 ORDER BY budget DESC';
// perform the query
$objDbResult = $objDatabase->Query($strQuery);
// Use the Project::InstantiateDbResult on the $objDbResult to get an array of Project objects
$objProjectArray = Project::InstantiateDbResult($objDbResult);
// Iterate through the Project Array as you would any other ORM object
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . ' has a budget of $' . $objProject->Budget);
_p('<br/>', false);
}
?>
<h3>Qcodo Query: Select all Projects which have a Budget over $5000 and under $10000, ordered by Descending Budget</h3>
<?php
// Perform the Query using Project::QueryArray, which will return an array of Project objects
// given a QQ Condition, and any optional QQ Clauses.
$objProjectArray = Project::QueryArray(QQ::AndCondition(QQ::GreaterThan(QQN::Project()->Budget, 5000), QQ::LessThan(QQN::Project()->Budget, 10000)), QQ::Clause(QQ::OrderBy(QQN::Project()->Budget, false)));
// Iterate through the Project Array like last time
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . ' has a budget of $' . $objProject->Budget);
_p('<br/>', false);
}
require '../includes/footer.inc.php';
<?php
require_once '../qcubed.inc.php';
// Setup the Feed, itself
$objRss = new QRssFeed('Examples Site Projects', 'http://examples.qcu.be/', 'An Example RSS feed of the Qcubed Examples Site Projects');
$objRss->Image = new QRssImage('http://www.qcu.be/sites/all/themes/qcubednew/images/QCubed.png');
$objRss->PubDate = new QDateTime(QDateTime::Now);
// Iterate through all the projects, and setup a QRssItem per project
// Limit it to the "10 most recently started projects"
foreach ($objProjects = Project::LoadAll(QQ::Clause(QQ::OrderBy(QQN::Project()->StartDate, false), QQ::LimitInfo(10))) as $objProject) {
$objItem = new QRssItem($objProject->Name, 'http://examples.qcu.be/examples/communication/rss.php/' . $objProject->Id, $objProject->Description);
$objItem->Author = $objProject->ManagerPerson->FirstName . ' ' . $objProject->ManagerPerson->LastName;
$objItem->PubDate = $objProject->StartDate;
$objItem->Guid = $objItem->Link;
$objItem->GuidPermaLink = true;
$objItem->AddCategory(new QRssCategory('Some Project Category 1'));
$objItem->AddCategory(new QRssCategory('Some Project Category 2'));
$objRss->AddItem($objItem);
}
// Output/Run the feed
// Note that the Run method will reset the output buffer and setup the Headers to output XML,
// so any HTML or Text outputted until now will be lost. If for whatever reason you just
// want the XML, you can call $objRss->GetXml(), which will return the XML string.
// Also, if you need to change the encoding of the XML, you can do so in QApplication::$EncodingType.
$objRss->Run();
public static function LoadArrayByBudgetMinimum($fltBudgetMinimum, $objOptionalClauses = null)
{
return Project::QueryArray(QQ::GreaterOrEqual(QQN::Project()->Budget, $fltBudgetMinimum), $objOptionalClauses);
}
public function testHaving()
{
$objItems = Project::QueryArray(QQ::All(), QQ::Clause(QQ::GroupBy(QQN::Project()->Id), QQ::Count(QQN::Project()->PersonAsTeamMember->PersonId, 'team_member_count'), QQ::Having(QQ::SubSql('COUNT({1}) > 5', QQN::Project()->PersonAsTeamMember->PersonId))));
$this->assertEqual(sizeof($objItems), 2, "2 projects found");
$this->assertEqual($objItems[0]->Name, "State College HR System", "Project " . $objItems[0]->Name . " found");
$this->assertEqual($objItems[0]->GetVirtualAttribute('team_member_count'), 6, "6 team members found for project " . $objItems[0]->Name);
}
<h2>Select all People where: the first name is alphabetically "greater than" the last name</h2>
<ul>
<?php
$objPersonArray = Person::QueryArray(QQ::GreaterThan(QQN::Person()->FirstName, QQN::Person()->LastName));
foreach ($objPersonArray as $objPerson) {
_p('<li>' . $objPerson->FirstName . ' ' . $objPerson->LastName . '</li>', false);
}
?>
</ul>
<h2>Select all Projects where: the manager's first name is alphabetically "greater than" the last name, or who's name contains "Website"</h2>
<ul>
<?php
$objProjectArray = Project::QueryArray(QQ::OrCondition(QQ::GreaterThan(QQN::Project()->ManagerPerson->FirstName, QQN::Project()->ManagerPerson->LastName), QQ::Like(QQN::Project()->Name, '%Website%')));
foreach ($objProjectArray as $objProject) {
_p(sprintf('<li>%s (managed by %s %s)</li>', $objProject->Name, $objProject->ManagerPerson->FirstName, $objProject->ManagerPerson->LastName), false);
}
?>
</ul>
<h2>Select all Projects where: the Project ID <= 2 AND (the manager's first name is alphabetically "greater than" the last name, or who's name contains "Website")</h2>
<ul>
<?php
$objProjectArray = Project::QueryArray(QQ::AndCondition(QQ::OrCondition(QQ::GreaterThan(QQN::Project()->ManagerPerson->FirstName, QQN::Project()->ManagerPerson->LastName), QQ::Like(QQN::Project()->Name, '%Website%')), QQ::LessOrEqual(QQN::Project()->Id, 2)));
foreach ($objProjectArray as $objProject) {
_p(sprintf('<li>%s (managed by %s %s)</li>', $objProject->Name, $objProject->ManagerPerson->FirstName, $objProject->ManagerPerson->LastName), false);
}
?>
</ul>
</div>
<?php
require '../includes/footer.inc.php';
public function testMultiLevel()
{
$arrPeople = Person::LoadAll(self::getTestClauses());
$this->assertEquals(12, sizeof($arrPeople), "12 Person objects found");
$targetPerson = $this->verifyObjectPropertyHelper($arrPeople, 'LastName', 'Wolfe');
$this->helperVerifyKarenWolfe($targetPerson);
$objProjectArray = $targetPerson->_ProjectAsManagerArray;
$this->assertEquals(2, sizeof($objProjectArray), "2 projects found");
foreach ($objProjectArray as $objProject) {
$objMilestoneArray = $objProject->_MilestoneArray;
switch ($objProject->Id) {
case 1:
$this->assertEquals(3, sizeof($objMilestoneArray), "3 milestones found");
break;
case 4:
$this->assertEquals(4, sizeof($objMilestoneArray), "4 milestones found");
break;
default:
$this->assertTrue(false, 'Unexpected project found, id: ' . $objProject->Id);
break;
}
}
// Now test a multilevel expansion where first level does not expand by array. Should get duplicate entries at that level.
$clauses = QQ::Clause(QQ::ExpandAsArray(QQN::Person()->Address), QQ::Expand(QQN::Person()->ProjectAsManager), QQ::ExpandAsArray(QQN::Person()->ProjectAsManager->Milestone));
$arrPeople = Person::LoadAll($clauses);
// Karen Wolfe should duplicate, since she is managing two projects
$this->assertEquals(13, sizeof($arrPeople), "13 Person objects found");
$targetPerson = $this->verifyObjectPropertyHelper($arrPeople, 'LastName', 'Wolfe');
$objProjectArray = $targetPerson->_ProjectAsManagerArray;
$this->assertNull($objProjectArray, "No project array found");
$objProject = $targetPerson->_ProjectAsManager;
$this->assertNotNull($objProject, "Project found");
$objMilestoneArray = $objProject->_MilestoneArray;
// since we didn't specify the order, not sure which one we will get, so check for either
switch ($objProject->Id) {
case 1:
$this->assertEquals(3, sizeof($objMilestoneArray), "3 milestones found");
break;
case 4:
$this->assertEquals(4, sizeof($objMilestoneArray), "4 milestones found");
break;
default:
$this->assertTrue(false, 'Unexpected project found, id: ' . $objProject->Id);
break;
}
// test that querying for expanded objects will return the cached version
$objProject2 = Project::Load($objProject->Id, array(QQ::Select(QQN::Project()->Name)));
// even though we only selected a name, we still get the other items in the cached object
$this->assertNotNull($objProject2->ManagerPersonId, "ManagerPersonId found");
}
public function testConditionalExpansionAssociation()
{
// Conditional expansion on association nodes really can only work with the PK of the join.
// Get all projects, and also expand on related projects if the id is 1
$a = Project::QueryArray(QQ::All(), [QQ::ExpandAsArray(QQN::Project()->ParentProjectAsRelated, QQ::Equal(QQN::Project()->ParentProjectAsRelated->ProjectId, 1)), QQ::ExpandAsArray(QQN::Project()->ProjectAsRelated, QQ::Equal(QQN::Project()->ProjectAsRelated->Project->Id, 1)), QQ::OrderBy(QQN::Project()->Id)]);
$this->assertEquals(1, $a[2]->_ParentProjectAsRelatedArray[0]->Id);
}
public function btnGo_Click($strFormId, $strControlId, $strParameter)
{
//get a list of project ids that have had their status changed
$changedIds = $this->colProjectSelected->GetChangedIds();
//load all the changed project objects at once so we can avoid multiple DB hits
$temp = Project::QueryArray(QQ::In(QQN::Project()->Id, array_keys($changedIds)));
//Put them in an associated list so we can find the needed ones easily later
$changedItems = array();
foreach ($temp as $item) {
$changedItems[$item->Id] = $item;
}
foreach ($changedIds as $id => $blnSelected) {
//look up the appropriate item using the handily indexed array we built earlier
$item = $changedItems[$id];
if ($blnSelected) {
//Associate this Project
QApplication::DisplayAlert('Associating ' . $item->Name);
} else {
//Unassociate this Project
QApplication::DisplayAlert('Unassociating ' . $item->Name);
}
}
}
}
?>
<h2>Example 3: Managers having one least a project with a conson milestone, and for each manager, the first voyel milestone and the first conson one</h2>
<?php
$emptySelect = QQ::Select();
$emptySelect->SetSkipPrimaryKey(true);
$nVoyel = QQ::Alias(QQN::Person()->ProjectAsManager->Milestone, 'voyel');
$nConson = QQ::Alias(QQN::Person()->ProjectAsManager->Milestone, 'conson');
$objPersonArray = Person::QueryArray(QQ::IsNotNull($nConson->Id), QQ::Clause(QQ::Expand(QQN::Person()->ProjectAsManager, null, $emptySelect), QQ::Expand($nVoyel, QQ::In($nVoyel->Name, array('Milestone A', 'Milestone E', 'Milestone I')), $emptySelect), QQ::Expand($nConson, QQ::NotIn($nConson->Name, array('Milestone A', 'Milestone E', 'Milestone I')), $emptySelect), QQ::GroupBy(QQN::Person()->Id), QQ::Minimum($nVoyel->Name, 'min_voyel'), QQ::Minimum($nConson->Name, 'min_conson'), QQ::Expand(QQN::Person()->ProjectAsManager, null, $emptySelect), QQ::Minimum(QQN::Person()->ProjectAsManager->Id, 'dummy'), QQ::Select(QQN::Person()->FirstName, QQN::Person()->LastName)));
foreach ($objPersonArray as $objManager) {
_p($objManager->FirstName . ' ' . $objManager->LastName . " (" . $objManager->GetVirtualAttribute('min_voyel') . ', ' . $objManager->GetVirtualAttribute('min_conson') . ")");
_p('<br/>', false);
}
?>
<h2>Example 4: Projects with, for each one, the "min" city from the addresses containing 'r' and the "min" city from the addresses NOT containing 'r' </h2>
<?php
$nWithR = QQ::Alias(QQN::Project()->PersonAsTeamMember->Person->Address, 'with_r');
$nWithoutR = QQ::Alias(QQN::Project()->PersonAsTeamMember->Person->Address, 'without_r');
$objProjectArray = Project::QueryArray(QQ::All(), QQ::Clause(QQ::Expand($nWithR, QQ::Like($nWithR->Street, '%r%')), QQ::Expand($nWithoutR, QQ::NotLike($nWithoutR->Street, '%r%')), QQ::GroupBy(QQN::Project()->Id), QQ::Minimum($nWithR->City, 'min_city_r'), QQ::Minimum($nWithoutR->City, 'min_city_wor')));
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . " (" . $objProject->GetVirtualAttribute('min_city_r') . ', ' . $objProject->GetVirtualAttribute('min_city_wor') . ")");
_p('<br/>', false);
}
QApplication::$Database[1]->OutputProfiling();
?>
</div>
<?php
require '../includes/footer.inc.php';
public function testSubSql()
{
$objProject = Project::QuerySingle(QQ::All(), QQ::Clause(QQ::Count(QQ::SubSql('DISTINCT {1}', QQN::Project()->ManagerPersonId), "manager_count")));
$this->assertEquals(3, $objProject->GetVirtualAttribute("manager_count"), "Project manager count is 3");
}
_p('<li>' . $objPerson->FirstName . ' ' . $objPerson->LastName . '</li>', false);
}
?>
</ul>
<h2>Select all Projects and the Count of Team Members (if applicable)</h2>
<p><em>GROUP BY in action</em></p>
<ul>
<?php
$objProjectArray = Project::QueryArray(QQ::All(), QQ::Clause(QQ::GroupBy(QQN::Project()->Id), QQ::Count(QQN::Project()->PersonAsTeamMember->PersonId, 'team_member_count')));
foreach ($objProjectArray as $objProject) {
_p('<li>' . $objProject->Name . ' (' . $objProject->GetVirtualAttribute('team_member_count') . ' team members)' . '</li>', false);
}
?>
</ul>
<h2>Select all Projects with more than 5 team members. </h2>
<p><em>Using a Having clause to further limit group functions</em></p>
<ul>
<?php
$objProjectArray = Project::QueryArray(QQ::All(), QQ::Clause(QQ::GroupBy(QQN::Project()->Id), QQ::Count(QQN::Project()->PersonAsTeamMember->PersonId, 'team_member_count'), QQ::Having(QQ::SubSql('COUNT({1}) > 5', QQN::Project()->PersonAsTeamMember->PersonId))));
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . ' (' . $objProject->GetVirtualAttribute('team_member_count') . ' team members)');
_p('<br/>', false);
}
?>
</ul>
</div>
<?php
require '../includes/footer.inc.php';
<p>In a slightly more complex example 2 below, we are looking for all projects that
are associated with two other projects (each is specified by name). We use the
same technique with <b>QQ::Alias()</b> as in example 1, except that we now
mix it in with relationships expanded to other tables.</p>
</div>
<div id="demoZone">
<h2>Example 1: Project members whose are in both project 1 and 2</h2>
<?php
QApplication::$Database[1]->EnableProfiling();
$objPersonArray = Person::QueryArray(QQ::AndCondition(QQ::Equal(QQ::Alias(QQN::Person()->ProjectAsTeamMember, 'pm1')->ProjectId, 1), QQ::Equal(QQ::Alias(QQN::Person()->ProjectAsTeamMember, 'pm2')->ProjectId, 2)));
foreach ($objPersonArray as $objPerson) {
_p($objPerson->FirstName . ' ' . $objPerson->LastName);
_p('<br/>', false);
}
?>
<h2>Example 2: Projects that are related to both 'Blueman Industrial Site Architecture' and 'ACME Payment System' projects</h2>
<?php
$objProjectArray = Project::QueryArray(QQ::AndCondition(QQ::Equal(QQ::Alias(QQN::Project()->ProjectAsRelated, 'related1')->Project->Name, 'Blueman Industrial Site Architecture'), QQ::Equal(QQ::Alias(QQN::Project()->ProjectAsRelated, 'related2')->Project->Name, 'ACME Payment System')));
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . " (" . $objProject->Description . ")");
_p('<br/>', false);
}
QApplication::$Database[1]->OutputProfiling();
?>
</div>
<?php
require '../includes/footer.inc.php';
public function testEmptyColumns()
{
$objItem = Login::QuerySingle(QQ::Equal(QQN::Login()->Id, 1));
$this->assertTrue($objItem->IsEnabled === 0, "Zero column does not return null.");
$objItem = Project::QuerySingle(QQ::Equal(QQN::Project()->Id, 2));
$this->assertTrue($objItem->EndDate === null, "Null date column returns a null.");
}
$objPersonArray = Person::QueryArray(QQ::All(), QQ::Clause(QQ::OrderBy(QQN::Person()->LastName, QQN::Person()->FirstName)));
foreach ($objPersonArray as $objPerson) {
_p($objPerson->FirstName . ' ' . $objPerson->LastName);
_p('<br/>', false);
}
?>
<h3>Select all People, Ordered by Last Name then First Name, Limited to the first 4 results</h3>
<?php
$objPersonArray = Person::QueryArray(QQ::All(), QQ::Clause(QQ::OrderBy(QQN::Person()->LastName, QQN::Person()->FirstName), QQ::LimitInfo(4)));
foreach ($objPersonArray as $objPerson) {
_p($objPerson->FirstName . ' ' . $objPerson->LastName);
_p('<br/>', false);
}
?>
<h3>Select all Projects and the Count of Team Members (if applicable)</h3>
<?php
$objProjectArray = Project::QueryArray(QQ::All(), QQ::Clause(QQ::GroupBy(QQN::Project()->Id), QQ::Count(QQN::Project()->PersonAsTeamMember->PersonId, 'team_member_count')));
foreach ($objProjectArray as $objProject) {
_p($objProject->Name . ' (' . $objProject->GetVirtualAttribute('team_member_count') . ' team members)');
_p('<br/>', false);
}
?>
<?php
require __INCLUDES__ . '/examples/footer.inc.php';
and in doing so they can unnecessarily overengineer some pieces of functionality.
If the focus is on getting the application functional, first, then after the application is in
a usable state, you can profile the functionality that tends to get used more often and simply
focus on optimizing this smaller subset of heavily-used functionality.</p>
<p>For information about Expanding through Association Tables, please refer to the
<a href="../qcubed_query/association.php">Handling Association Tables example</a>.</p>
</div>
<div id="demoZone">
<h2>List All Projects and its Manager</h2>
<?php
// Enable Profiling (we're assuming the Examples Site Database is at index 1)
// NOTE: Profiling should only be enabled when you are actively wanting to profile a specific PHP script.
// Because of SIGNIFICANT performance degradation, it should otherwise always be off.
QApplication::$Database[1]->EnableProfiling();
// Load the Project array
// The following line of code is the ONLY line of code we will modify
$objProjectArray = Project::LoadAll(QQ::Clause(QQ::Expand(QQN::Project()->ManagerPerson)));
foreach ($objProjectArray as $objProject) {
_p(QApplication::HtmlEntities($objProject->Name) . ' is managed by ' . $objProject->ManagerPerson->FirstName . ' ' . $objProject->ManagerPerson->LastName);
_p('<br/>', false);
}
_p('<br/>', false);
// Output Profiling Data
QApplication::$Database[1]->OutputProfiling();
?>
</div>
<?php
require '../includes/footer.inc.php';
public function testAlias2()
{
$objProjectArray = Project::QueryArray(QQ::AndCondition(QQ::Equal(QQ::Alias(QQN::Project()->ProjectAsRelated, 'related1')->Project->Name, 'Blueman Industrial Site Architecture'), QQ::Equal(QQ::Alias(QQN::Project()->ProjectAsRelated, 'related2')->Project->Name, 'ACME Payment System')));
$this->assertEquals(1, sizeof($objProjectArray));
$this->verifyObjectPropertyHelper($objProjectArray, 'Name', 'ACME Website Redesign');
}
