1: <?php
  2:     // Load the QCubed Development Framework
  3:     require('../qcubed.inc.php');
  4:     
  5:     // our child QPanel
  6:     require ('./records.summary.php');
  7:         
  8:     class ProjectListForm extends QForm {
  9:         // Local instance of the Meta DataGrid to list Projects
 10:         protected $dtgProjects;
 11:                     
 12:         protected function Form_Create() {
 13:             // Instantiate the DataGrid
 14:             $this->dtgProjects = new QDataGrid($this);
 15: 
 16:             // Style the DataGrid
 17:             //$this->dtgProjects->CssClass = 'datagrid';
 18:             $this->dtgProjects->AlternateRowCssClass = 'alternate';
 19: 
 20:             // Add Pagination
 21:             $this->dtgProjects->Paginator = new QPaginator($this->dtgProjects);
 22:             $this->dtgProjects->ItemsPerPage = 3;
 23: 
 24:             // Add columns
 25:             
 26:             // Create a column that will hold a toggle button. We will need to manually draw the content of the cell.
 27:             $col = $this->dtgProjects->CreateCallableColumn('', [$this, 'render_btnToggleRecordsSummary']);
 28:             $col->HtmlEntities = false;
 29:             $col->CellStyler->Width = "1%";
 30: 
 31:             $this->dtgProjects->CreateNodeColumn('Id', QQN::Project()->Id);
 32:             $this->dtgProjects->CreateNodeColumn('Name', QQN::Project()->Name);
 33:             $this->dtgProjects->CreateNodeColumn('Status', QQN::Project()->ProjectStatusType);
 34:             $this->dtgProjects->CreateNodeColumn('Description', QQN::Project()->Description);
 35:             $this->dtgProjects->CreateNodeColumn('Start Date', QQN::Project()->StartDate);
 36:             $this->dtgProjects->CreateNodeColumn('End Date', QQN::Project()->EndDate);
 37:             $this->dtgProjects->CreateNodeColumn('Budget', QQN::Project()->Budget);
 38:             $this->dtgProjects->CreateNodeColumn('Spent', QQN::Project()->Spent);
 39: 
 40:             // Create a column that will hold a child datagrid
 41: 
 42:             $col = $this->dtgProjects->CreateCallableColumn('', [$this, 'render_ucRecordsSummary']);
 43:             $col->HtmlEntities = false;
 44:             $col->CellStyler->Width = 0;
 45: 
 46:             // Specify the Datagrid's Data Binder method
 47:             $this->dtgProjects->SetDataBinder('dtgProjects_Bind');
 48: 
 49:             // For purposes of this example, add a css file that styles the table.
 50:             // Normally you would include your global style sheets in your tpl file or header.inc.php file.
 51:             $this->dtgProjects->AddCssFile(__QCUBED_ASSETS__ . '/php/examples/master_detail/styles.css');
 52:         }
 53: 
 54:         protected function dtgProjects_Bind() {
 55:             $this->dtgProjects->TotalItemCount = Project::QueryCount(QQ::All());
 56: 
 57:             // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add
 58:             // the OrderByClause to the $objClauses array
 59:             if ($objClause = $this->dtgProjects->OrderByClause) {
 60:                 $objClauses[] = $objClause;
 61:             }
 62: 
 63:             // Add the LimitClause information, as well
 64:             if ($objClause = $this->dtgProjects->LimitClause) {
 65:                 $objClauses[] = $objClause;
 66:             }
 67: 
 68:             $this->dtgProjects->DataSource = Project::LoadAll($objClauses);
 69:         }
 70:         
 71:         // Function to render our toggle button column
 72:         // As you can see we pass as a parameter the item binded in the
 73:         // row of QDataGrid
 74:         public function render_btnToggleRecordsSummary(Project $objProject) {
 75:             // Create their unique id...
 76:             $objControlId = 'btnToggleRecordsSummary' . $objProject->Id;
 77:             
 78:             if (!$objControl = $this->GetControl($objControlId)) {          
 79:                 $intTeamMemberCount = Person::CountByProjectAsTeamMember($objProject->Id);
 80:                 if ($intTeamMemberCount > 0) {
 81: 
 82:                     // If not exists create our toggle button who his parent
 83:                     // is our master QDataGrid...
 84:                     $objControl = new QButton($this->dtgProjects, $objControlId);
 85:                     $objControl->Width = 25;
 86:                     $objControl->Text = '+' . $intTeamMemberCount;
 87:                     $objControl->CssClass = 'inputbutton';
 88:                 
 89:                     // Pass the id of the bounded item just for other process
 90:                     // on click event
 91:                 
 92:                     $objControl->ActionParameter = $objProject->Id;
 93:                 
 94:                     // Add event on click the toogle button
 95:                     $objControl->AddAction(new QClickEvent(), new QAjaxAction( 'btnToggleRecordsSummary_Click'));
 96:                 }
 97:             }
 98:             // We pass the parameter of "false" to make sure the control doesn't render
 99:             // itself RIGHT HERE - that it instead returns its string rendering result.
100:             return $objControl->Render(false);
101:         }
102:             
103:             
104:         // Clicking the toogle button...
105:         public function btnToggleRecordsSummary_Click($strFormId, $strControlId, $strParameter) {
106:             // First get the button himself for change '+' to '-'
107:             $srcControl = $this->GetControl($strControlId);
108:             
109:             $intProjectId = intval($strParameter);
110:             
111:             // Look for our child datagrid if is render...
112:             $objControlId = 'ucRecordsSummary' . $intProjectId;
113:             $objControl = $this->GetControl($objControlId);
114: 
115:             $intTeamMemberCount = Person::CountByProjectAsTeamMember($intProjectId);
116:             if ($intTeamMemberCount > 0) {
117:                 if ($objControl) {
118:                 // Ask if our child datagrid is visible...
119:                     if ($objControl->Visible) {
120:                         // Make it desapear ...
121:                         $objControl->Visible = false;
122:                         $srcControl->Text = '+';
123:                     } else {
124:                         // Or make it appear...
125:                         $objControl->Visible = true;
126:                         $srcControl->Text = '-';
127:                     }
128: 
129:                     // Important! Refresh the parent QDataGrid...
130:                     $this->dtgProjects->Refresh();
131:                 }
132:             }
133:         }
134:             
135:         // Draw the child datagrid inside of a cell of the parent datagrid
136:         public function render_ucRecordsSummary(Project $objProject) {
137:             $objControlId = 'ucRecordsSummary' . $objProject->Id;
138:             
139:             if (!$objControl = $this->GetControl($objControlId)) {
140:                 // Create the User Control Child QDataGrid passing the
141:                 // parent, in this case Master QDataGrid and the unique id.
142:                 $objControl = new RecordsSummary($this->dtgProjects, $objProject, $objControlId);
143:                 
144:                 // Put invisible at the begging, the toogle button is gonna do the job
145:                 // test - $objControl->Visible = true;
146:                 $objControl->Visible = false;
147:             }
148:             
149:             return $objControl->Render(false);
150:         }   
151:     }
152: 
153:     // Go ahead and run this form object to generate the page and event handlers, 
154:     // implicitly using project_list.tpl.php as the included HTML template file
155:     ProjectListForm::Run('ProjectListForm');
156: ?>