Guest User

Untitled

a guest
Jan 18th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. $getSYList = loadSchoolYearList();
  2. $loadSemCount = getTotalStudListEverySem();
  3.  
  4. function loadSchoolYearList(){
  5. include '..assetsdatabaseconnect.php';
  6. $list = array();
  7. $i = 0;
  8. $query = "SELECT DISTINCT schoolYear FROM tblschoolyear";
  9. $result = $conn->query($query);
  10. if ($result->num_rows > 0) {
  11. while($row = $result->fetch_assoc()) {
  12. $list[$i][] = $row['schoolYear'];
  13. $i++;
  14. }
  15. }
  16. return $list;
  17. }
  18.  
  19. function getTotalStudListEverySem(){
  20. include '..assetsdatabaseconnect.php';
  21. $i = 0;
  22. $count = 1;
  23. $sem = 1;
  24. $semList = array();
  25. $schoolYearCount = 0;
  26.  
  27. // Count tblschoolyear record
  28. $query = "SELECT COUNT(syId) as totalSY FROM tblschoolyear";
  29. $stmt = $conn->prepare($query);
  30. $stmt->execute();
  31. $stmt->store_result();
  32.  
  33. if($stmt->num_rows > 0){
  34. $stmt->bind_result($schoolYearCount);
  35. while($stmt->fetch()) {
  36. $schoolYearCount=$schoolYearCount;
  37. }
  38. }
  39.  
  40. for($count;$count<=$schoolYearCount;$count++){
  41. $query = "SELECT COUNT(r.infoId) as totalSemCount FROM tblreg as r ";
  42. $query .= "INNER JOIN tblschoolyear as sy ON sy.syId=r.syId ";
  43. $query .= "INNER JOIN tblstudinfo as i ON r.infoID=i.infoID WHERE sy.syID=". $count ." AND sy.SchoolSem=". $sem ."";
  44. $result = $conn->query($query);
  45. if ($result->num_rows > 0) {
  46. while($row = $result->fetch_assoc()) {
  47. $semList[$i][] = $row['totalSemCount'];
  48. $i++;
  49. }
  50. }
  51. if ($sem==2){
  52. $sem = 1;
  53. }else{
  54. $sem++;
  55. }
  56. }
  57. $conn->close();
  58. return $semList;
  59. }
  60.  
  61. <?php
  62. $data = [[
  63. 'label' => "2017-2018-1",
  64. 'value' => 3000
  65. ], [
  66. 'label' => "2017-2018-2",
  67. 'value' => 4000
  68. ]];
  69. ?>
  70. <script>var chartData = <?=json_encode($data)?>;</script>
  71.  
  72. <?php
  73. $data = [[
  74. 'label' => "2017-2018-1",
  75. 'value' => 3000
  76. ], [
  77. 'label' => "2017-2018-2",
  78. 'value' => 4000
  79. ]];
  80. ?>
  81. <script>var chartData = <?=json_encode($data)?>;</script>
  82.  
  83. <?php
  84. $data = [[
  85. 'label' => "2017-2018-1",
  86. 'value' => 3000
  87. ], [
  88. 'label' => "2017-2018-2",
  89. 'value' => 4000
  90. ]];
  91. ?>
  92. <script>var chartData = <?=json_encode($data)?>;</script>
  93.  
  94. <?php
  95. $data = [[
  96. 'label' => "2017-2018-1",
  97. 'value' => 3000
  98. ], [
  99. 'label' => "2017-2018-2",
  100. 'value' => 4000
  101. ]];
  102. ?>
  103. <script>var chartData = <?=json_encode($data)?>;</script>
  104.  
  105. Morris.Donut({
  106. element: 'morris-donut-chart',
  107. data: chartData,
  108. resize: true
  109. });
Add Comment
Please, Sign In to add comment