SHARE
TWEET

Untitled

a guest Aug 25th, 2019 124 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top