/down_reports.php

http://swifttide.googlecode.com/ · PHP · 110 lines · 85 code · 14 blank · 11 comment · 9 complexity · 5470c95004e09802911c5bb050a8e3bf MD5 · raw file 

    

  1. <?php
    2. 

  2. 

  3. /**********************************************/
    4. 

  4. /*				Coded by NubKnacker
    5. 

  5. /**********************************************/
    6. 

  6. // Last edit 11-24-2005, removed Report Cards.  they are now a separate 
    7. 

  7. // link on the main menu.
    8. 

  8. 

  9. //Include global functions
    10. 

  10. include_once "common.php";
    11. 

  11. //Initiate database functions
    12. 

  12. include_once "ez_sql.php";
    13. 

  13. //Include paging class
    14. 

  14. include_once "ez_results.php";
    15. 

  15. // config
    16. 

  16. include_once "configuration.php";
    17. 

  17. 

  18. $report = get_param("report");
    19. 

  19. $sort1 = get_param("sort1");
    20. 

  20. $sort2 = get_param("sort2");
    21. 

  21. // echo "sort1=$sort1";
    22. 

  22. // echo "sort2=$sort2";
    23. 

  23. 

  24. session_start();
    25. 

  25. if(!session_is_registered('UserId') || $_SESSION['UserType'] != "A")
    26. 

  26. {
    27. 

  27. 	header ("Location: index.php?action=notauth");
    28. 

  28. 	exit;
    29. 

  29. }
    30. 

  30. 

  31. if ($sort1) {
    32. 

  32. 	if ($_POST['report'] == 'discipline' || $_POST['report'] == 'attendance') {
    33. 

  33. 		header("Location: makereport.php?report_type=".$_POST['report']."&sort1=".$_POST['sort1']."&sort2=".$_POST['sort2']."&start_db_date=".$_POST['start_date']."&end_db_date=".$_POST['end_date']);
    34. 

  34. 	} else {
    35. 

  35. 		header("Location: makereport.php?report_type=".$_POST['report']."&sort1=".$_POST['sort1']."&sort2=".$_POST['sort2']);
    36. 

  36. 	}
    37. 

  37. 	exit;
    38. 

  38. }
    39. 

  39. 

  40. ?>
    41. 

  41. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
    42. 

  42. 

  43. <html xmlns="http://www.w3.org/1999/xhtml">
    44. 

  44. 

  45. <head>
    46. 

  46. <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
    47. 

  47. <title><?php echo _BROWSER_TITLE?></title>
    48. 

  48. <style type="text/css" media="all">@import "student-admin.css";</style>
    49. 

  49. <script language="JavaScript" src="datepicker.js"></script>
    50. 

  50. </head>
    51. 

  51. <body><img src="images/<?php echo _LOGO?>" border="0">
    52. 

  52. 

  53. <div id="Header">
    54. 

  54. <table width="100%">
    55. 

  55.   <tr>
    56. 

  56.     <td width="50%" align="left"><font size="2"><b>&nbsp;&nbsp;<?php echo date(_DATE_FORMAT); ?></b></font></td>
    57. 

  57.     <td width="50%" align="right"><b><?php echo _DOWN_REPORTS_ADMIN_AREA?></b></td>
    58. 

  58.   </tr>
    59. 

  59. </table>
    60. 

  60. </div>
    61. 

  61. 

  62. <div id="Content">
    63. 

  63. <h1><?php echo _DOWN_REPORTS_TITLE?></h1>
    64. 

  64. <br>
    65. 

  65. <form name="report_selection" method="POST" action="<?echo($_SERVER['PHP_SELF']);?>">
    66. 

  66. <table border="0" cellpadding="1" cellspacing="1" width="100%">
    67. 

  67. <tr class="trform">
    68. 

  68. <td width="100%">
    69. 

  69. <select name="report" onChange="javascript: changeReport()">
    70. 

  70. <option value="students" selected="selected"><?php echo _DOWN_REPORTS_STUDENTS?></option>
    71. 

  71. <option value="attendance"><?php echo _DOWN_REPORTS_ATTENDANCE?></option>
    72. 

  72. <option value="discipline"><?php echo _DOWN_REPORTS_DISCIPLINE?></option>
    73. 

  73. <!-- <option value="grades"><?php echo _DOWN_REPORTS_GRADES?></option> -->
    74. 

  74. </select>
    75. 

  75. <?php echo _DOWN_REPORTS_SORTED?>
    76. 

  76. <select name="sort1">
    77. 

  77. <option value="school_names_desc"><?php echo _DOWN_REPORTS_SCHOOL?></option>
    78. 

  78. <option value="grades_id"><?php echo _DOWN_REPORTS_GRADES?></option>
    79. 

  79. <option value="studentbio_ethnicity"><?php echo _DOWN_REPORTS_ETH?></option>
    80. 

  80. <option value="studentbio_gender"><?php echo _DOWN_REPORTS_GENDER?></option>
    81. 

  81. <option value="studentbio_bus"><?php echo _DOWN_REPORTS_ROUTE?></option>
    82. 

  82. <option value="studentbio_homeroom"><?php echo _DOWN_REPORTS_HOME?></option>
    83. 

  83. </select>
    84. 

  84. <?php echo _DOWN_REPORTS_BY?>
    85. 

  85. <select name="sort2">
    86. 

  86. <option value="none"><?php echo _ADMIN_REPORTS_NONE?></option>
    87. 

  87. <option value="school_names_desc"><?php echo _DOWN_REPORTS_SCHOOL?></option>
    88. 

  88. <option value="grades_id"><?php echo _DOWN_REPORTS_GRADES?></option>
    89. 

  89. <option value="studentbio_ethnicity"><?php echo _DOWN_REPORTS_ETH?></option>
    90. 

  90. <option value="studentbio_gender"><?php echo _DOWN_REPORTS_GENDER?></option>
    91. 

  91. <option value="studentbio_bus"><?php echo _DOWN_REPORTS_ROUTE?></option>
    92. 

  92. <option value="studentbio_homeroom"><?php echo _DOWN_REPORTS_HOME?></option>
    93. 

  93. </select>
    94. 

  94. </td>
    95. 

  95. </tr>
    96. 

  96. <tr class="trform"><td><?php echo _DOWN_REPORTS_FROM?><input type="text" size=10 name="start_date" READONLY onclick="javascript:show_calendar('report_selection.start_date');"><a href="javascript:show_calendar('report_selection.start_date');"><img src="cal.gif" border="0" class="imma"></a> 
    97. 

  97. 

  98. <?php echo _DOWN_REPORTS_TO?><input type="text" size=10 name="end_date" READONLY onclick="javascript:show_calendar('report_selection.end_date');"><a href="javascript:show_calendar('report_selection.end_date');"><img src="cal.gif" border="0" class="imma"></a>
    99. 

  99. 

  100. </td></tr><tr>
    101. 

  101. <td width="100%" align="left"><input type="submit" name="submit" value="<?php echo _DOWN_REPORTS_DOWNLOAD?>" class="frmbut">
    102. 

  102. </td></tr>
    103. 

  103. </table>
    104. 

  104. </form>
    105. 

  105. 

  106. </div>
    107. 

  107. <?php include "admin_menu.inc.php"; ?>
    108. 

  108. </body>
    109. 

  109. 

  110. </html>
    111.