Advertisement
Guest User

Untitled

a guest
Aug 18th, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.33 KB | None | 0 0
  1. public with sharing class IITDeanDashBoardController {
  2. public List<AggregateResult> BadgeList {
  3. get
  4. {
  5. List<AggregateResult> badges= [
  6. SELECT TargetX_SRMb__College__c
  7. , Department__c
  8. , IIT_Program__r.Name ccc
  9. , count(Id) bbb
  10. FROM TargetX_SRMb__Application__c
  11. WHERE TargetX_SRMb__College__c = 'Chicago-Kent College of Law'
  12. And TargetX_SRMb__Start_Term_Year__c = '2019'
  13. And TargetX_SRMb__Start_Term__c = 'Fall'
  14. And TargetX_SRMb__Level__c = 'Graduate'
  15. And TargetX_App__Is_Test_Record__c = False
  16. And TargetX_SRMb__Application_Submit_Date__c != Null
  17. GROUP BY IIT_Program__r.Name, Department__c, TargetX_SRMb__College__c
  18. Order By IIT_Program__r.Name
  19. ];
  20. return badges;
  21. }
  22. set;
  23. }
  24.  
  25. public List<AggregateResult> InQueueDecision {
  26. get
  27. {
  28. List<AggregateResult> QueueDecisions= [
  29. SELECT IIT_Program__r.Name ccc,
  30. count(Id) InDecision
  31. FROM TargetX_SRMb__Application__c
  32. WHERE TargetX_SRMb__College__c = 'Chicago-Kent College of Law'
  33. And TargetX_SRMb__Start_Term_Year__c = '2019'
  34. And TargetX_SRMb__Start_Term__c = 'Fall'
  35. And TargetX_SRMb__Level__c = 'Graduate'
  36. And TargetX_App__Is_Test_Record__c = False
  37. And TargetX_SRMb__Application_Submit_Date__c != Null
  38. And IIT_Sent_For_Faculty_Decision__c = Null
  39. And TargetX_SRMb__Application_Decision__c = Null
  40. GROUP BY IIT_Program__r.Name, Department__c, TargetX_SRMb__College__c
  41. ];
  42. return QueueDecisions;
  43. }
  44. set;
  45. }
  46.  
  47. }
  48.  
  49. <apex:page controller="IITDeanDashBoardController" >
  50. <apex:pageBlock >
  51. <apex:pageBlockTable value="{!BadgeList}" var="a" title="My Badges" columns="4" align="center" styleClass="table table-striped">
  52. <apex:facet name="header">Chicago-Kent College of Law DashBoard </apex:facet>
  53. <apex:column >
  54. <apex:facet name="header">College</apex:facet>
  55. {!a['TargetX_SRMb__College__c']}</apex:column>
  56. <apex:column > <apex:facet name="header">Department</apex:facet>
  57. {!a['Department__c']}</apex:column>
  58. <apex:column > <apex:facet name="header">Program</apex:facet>
  59. {!a['ccc']}</apex:column>
  60. <apex:column > <apex:facet name="header">Total Apps</apex:facet>
  61. {!a['bbb']}</apex:column>
  62. </apex:pageBlockTable>
  63. </apex:pageBlock>
  64.  
  65.  
  66. <apex:pageBlock >
  67. <apex:pageBlockTable value="{!InQueueDecision}" var="n" title="InqueueProcess" columns="4" align="center" styleClass="table table-striped">
  68. <apex:facet name="header">Chicago-Kent College of Law DashBoard </apex:facet>
  69. <apex:column >
  70. <apex:facet name="header">Program</apex:facet>
  71. {!n['ccc']}</apex:column>
  72. <apex:column > <apex:facet name="header">Number of app status InProcess</apex:facet>
  73. {!n['InDecision']}</apex:column>
  74. </apex:pageBlockTable>
  75. </apex:pageBlock>
  76. </apex:page>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement