Guest User

Untitled

a guest
Aug 25th, 2019
139
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. class AbstractSpreadsheetConnector
  2. {
  3. // column maps
  4. public static $studentColumns = [
  5. 'Key' => 'ForeignKey',
  6. 'School ID Number' => 'StudentNumber',
  7. 'Student ID' => 'StudentNumber',
  8. 'Username' => 'Username',
  9. 'Password' => 'Password',
  10. 'Email' => 'Email',
  11. 'First Name' => 'FirstName',
  12. 'First' => 'FirstName',
  13. 'Last Name' => 'LastName',
  14. 'Last' => 'LastName',
  15. 'Middle Name' => 'MiddleName',
  16. 'Middle' => 'MiddleName',
  17. 'Gender' => 'Gender',
  18. 'Sex' => 'Gender',
  19. 'Birth Date' => 'BirthDate',
  20. 'Birthday' => 'BirthDate',
  21. 'Graduation Year' => 'GraduationYear',
  22. 'Graduation' => 'GraduationYear',
  23. 'Grade' => 'Grade',
  24. 'School' => 'School',
  25. 'Cohort' => 'Group', 'Group' => 'Group',
  26. 'Advisor' => 'AdvisorUsername',
  27. # 'Assigned Password',
  28. # 'Email',
  29. # 'Phone',
  30. # 'Postal Address'
  31. ];
  32.  
  33. public static $alumniColumns = [
  34. 'Username' => 'Username',
  35. 'Password' => 'Password',
  36. 'Email' => 'Email',
  37. 'First Name' => 'FirstName',
  38. 'First' => 'FirstName',
  39. 'Last Name' => 'LastName',
  40. 'Last' => 'LastName',
  41. 'Middle Name' => 'MiddleName',
  42. 'Middle' => 'MiddleName',
  43. 'Gender' => 'Gender',
  44. 'Sex' => 'Gender',
  45. 'Birth Date' => 'BirthDate',
  46. 'Birthday' => 'BirthDate',
  47. 'Graduation Year' => 'GraduationYear',
  48. 'Graduation' => 'GraduationYear'
  49. ];
  50.  
  51. public static $staffColumns = [
  52. 'First Name' => 'FirstName',
  53. 'First' => 'FirstName',
  54. 'Last Name' => 'LastName',
  55. 'Last' => 'LastName',
  56. 'Middle Name' => 'MiddleName',
  57. 'Middle' => 'MiddleName',
  58. 'Gender' => 'Gender',
  59. 'Sex' => 'Gender',
  60. 'Birth Date' => 'BirthDate',
  61. 'Birthday' => 'BirthDate',
  62. # 'StaffID',
  63. 'Username' => 'Username',
  64. 'Password' => 'Password',
  65. 'Account Level' => 'AccountLevel',
  66. 'Account Type' => 'AccountLevel',
  67. 'Role / Job Title' => 'About',
  68. 'Email' => 'Email',
  69. 'School' => 'School',
  70. # 'Phone',
  71. # 'Postal Address'
  72. ];
  73.  
  74. public static $sectionColumns = [
  75. 'Section ID' => 'SectionExternal',
  76. 'Section Code' => 'SectionCode',
  77. 'Section code' => 'SectionCode',
  78. 'Title' => 'Title',
  79. 'Course Code' => 'CourseCode',
  80. 'Course code' => 'CourseCode',
  81. 'Teacher' => 'TeacherUsername',
  82. 'Term' => 'Term',
  83. 'Terms' => 'Term',
  84. 'Schedule' => 'Schedule',
  85. 'Location' => 'Location',
  86. 'Room' => 'Location',
  87. 'Students Capacity' => 'StudentsCapacity',
  88. '# of Students' => 'StudentsCapacity',
  89. 'Seats' => 'StudentsCapacity',
  90. 'Notes' => 'Notes'
  91. ];
  92.  
  93. public static $enrollmentColumns = [
  94. 'School ID Number' => 'StudentNumber',
  95. 'School ID' => 'StudentNumber',
  96. 'Student Number' => 'StudentNumber',
  97. 'Username' => 'Username'
  98. ];
  99.  
  100.  
  101. // minimum required columns
  102. public static $studentRequiredColumns = [
  103. 'StudentNumber',
  104. 'FirstName',
  105. 'LastName'
  106. ];
  107.  
  108. public static $alumniRequiredColumns = [
  109. 'FirstName',
  110. 'LastName'
  111. ];
  112.  
  113. public static $staffRequiredColumns = [
  114. 'FirstName',
  115. 'LastName'
  116. ];
  117.  
  118. public static $sectionRequiredColumns = [
  119. 'CourseCode'
  120. ];
  121.  
  122. public static $enrollmentRequiredColumns = [];
  123. }
RAW Paste Data