Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public with sharing class IITDeanDashBoardController {
- public List<AggregateResult> BadgeList {
- get
- {
- List<AggregateResult> badges= [
- SELECT TargetX_SRMb__College__c
- , Department__c
- , IIT_Program__r.Name ccc
- , count(Id) bbb
- FROM TargetX_SRMb__Application__c
- WHERE TargetX_SRMb__College__c = 'Chicago-Kent College of Law'
- And TargetX_SRMb__Start_Term_Year__c = '2019'
- And TargetX_SRMb__Start_Term__c = 'Fall'
- And TargetX_SRMb__Level__c = 'Graduate'
- And TargetX_App__Is_Test_Record__c = False
- And TargetX_SRMb__Application_Submit_Date__c != Null
- GROUP BY IIT_Program__r.Name, Department__c, TargetX_SRMb__College__c
- Order By IIT_Program__r.Name
- ];
- return badges;
- }
- set;
- }
- public List<AggregateResult> InQueueDecision {
- get
- {
- List<AggregateResult> QueueDecisions= [
- SELECT IIT_Program__r.Name ccc,
- count(Id) InDecision
- FROM TargetX_SRMb__Application__c
- WHERE TargetX_SRMb__College__c = 'Chicago-Kent College of Law'
- And TargetX_SRMb__Start_Term_Year__c = '2019'
- And TargetX_SRMb__Start_Term__c = 'Fall'
- And TargetX_SRMb__Level__c = 'Graduate'
- And TargetX_App__Is_Test_Record__c = False
- And TargetX_SRMb__Application_Submit_Date__c != Null
- And IIT_Sent_For_Faculty_Decision__c = Null
- And TargetX_SRMb__Application_Decision__c = Null
- GROUP BY IIT_Program__r.Name, Department__c, TargetX_SRMb__College__c
- ];
- return QueueDecisions;
- }
- set;
- }
- }
- <apex:page controller="IITDeanDashBoardController" >
- <apex:pageBlock >
- <apex:pageBlockTable value="{!BadgeList}" var="a" title="My Badges" columns="4" align="center" styleClass="table table-striped">
- <apex:facet name="header">Chicago-Kent College of Law DashBoard </apex:facet>
- <apex:column >
- <apex:facet name="header">College</apex:facet>
- {!a['TargetX_SRMb__College__c']}</apex:column>
- <apex:column > <apex:facet name="header">Department</apex:facet>
- {!a['Department__c']}</apex:column>
- <apex:column > <apex:facet name="header">Program</apex:facet>
- {!a['ccc']}</apex:column>
- <apex:column > <apex:facet name="header">Total Apps</apex:facet>
- {!a['bbb']}</apex:column>
- </apex:pageBlockTable>
- </apex:pageBlock>
- <apex:pageBlock >
- <apex:pageBlockTable value="{!InQueueDecision}" var="n" title="InqueueProcess" columns="4" align="center" styleClass="table table-striped">
- <apex:facet name="header">Chicago-Kent College of Law DashBoard </apex:facet>
- <apex:column >
- <apex:facet name="header">Program</apex:facet>
- {!n['ccc']}</apex:column>
- <apex:column > <apex:facet name="header">Number of app status InProcess</apex:facet>
- {!n['InDecision']}</apex:column>
- </apex:pageBlockTable>
- </apex:pageBlock>
- </apex:page>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement