Today I worked on Google SSO integration, fixed the sidebar visibility for Academic Coordinator modules, improved error handling in Google Sign-in and import functions, added safe schema checks, updated the NDMU email import service, enhanced the bulk student merge validation, added pfile preview, updated the Registrar Faculty Load, and refined E-Class grade submission rules for subject coordinators.
Accomplishments
Updated the NDMU email import service to handle schema changes safely.
Updated the NDMU Google SSO service to improve integration.
Enhanced the error handler in Google Sign-in to provide clearer feedback.
Refined the Google Account Sign-in flow to reject invalid addresses earlier, match only NDMU and university emails, and show a proper error message when sign-in fails.
Fixed the bulk student merge function to handle unique grade constraints and added tighter validation.
Fixed the sidebar so Academic Coordinator modules now appear when the user has the correct role and module assigned.
Added a preview feature for pfile attachments.
Updated the Registrar Faculty Load screen with new data and layout.
Added an error handler to the user import function to catch and report issues.
Updated the user controller to support import changes.
Added a safe schema check for the NDMU email import to avoid MySQL driver compatibility issues.
Updated the Manage Admission Applicant Controller to support new workflows.
Added safe schema checks to the login process to prevent errors.
Enabled subject coordinators to verify other teachers' classes in their assigned subjects, but not their own.
Integrated NDMU Google SSO for students, including import functions that use a new template layout and store the student number from the spreadsheet.
Features
2 commits
Updated the subject coordinators who also teach should be able to verify other teachers’ classes in their assigned subjects, updated the but not their own, and updated the i’ll look through the grade-checking and coordinator assignment flow so that rule can be applied for the : eclass record grade submission - subject coordinator.
+136 · -49
Updated the integrate NDMU google SSO for student, added the import functions the NDMU email template now uses the student columns from your sheet, updated the and a matching student row stores the spreadsheet student number in student.ndmu student no, updated the template columns STUDENT NUMBER, updated the LAST NAME, updated the FIRST NAME, updated the MIDDLE NAME, updated the BIRTHDAY, updated the COURSE, updated the NDMU EMAIL the download and the error file both use that layout, updated the the import preview shows student number, updated the name, updated the birthday, updated the course, updated the NDMU email, updated the and the result, updated the import a row is applied only when last name, updated the first name, updated the and birthday match one student account, updated the if a course is filled in, updated the it must match that student's course, updated the the NDMU email is saved as before, and updated the and the student number from the sheet is written to ndmu student no for the google SSO.
+7,101 · -456
Fixes
1 commit
Updated the the sidebar never lists a module just because it exists on the modules page, updated the it only shows a module when both of these are true for the signed-in user: the user has that module’s role, updated the the module is checked on that user’s account, updated the creating a role or a module did not do either step, updated the so the new item stayed off the menu, updated the a module saved with “no parent module” was also stored as parent 0, updated the and the sidebar only treated a blank parent as a top-level item, updated the that is now connected, updated the assigning a role checks that role’s active modules onto the user, updated the saving a module checks it onto everyone who already has that role, updated the a parent of “none” is stored as a real top-level module, updated the i also checked the database, updated the there is no role named academic coordinator, updated the and there are no modules named configuration (acad-coor) or academic coordinator, updated the the closest records are the acad heads role and the modules configurations, updated the set school days, updated the and academic coordinators, updated the the account PALMA MFL only has teacher, updated the enrollment, updated the and admission, updated the so acad heads does not appear in that sidebar, updated the assign academic coordinator (after it is saved under roles) to the user, updated the or assign acad heads if that is the role you meant, and updated the refresh the home page and the module should be in the sidebar for the hotfix: academic coordinator modules are saved, but they are not showing in the sidebar. i’ll trace how roles and modules are loaded for navigation.
+69 · -5
Maintenance
17 commits
Updated ndmuemailimportservice.php.
+34 · -16
Updated ndmugooglessoservice.php.
+7
Enhanced error handler in google signin.
+38 · -1
Updated the the google button rejects the sign-in before it uses the saved address, updated the and a matched account can still be blocked after it is found, updated the i’ll match only ndmu email and uni email, updated the then sign that account in when it is already registered, updated the continue with NDMU google account now looks up only gen user.ndmu email and gen user.uni email, updated the if that google address is already saved on one account, updated the sign-in continues, updated the the message in your screenshot still means the google account you picked is not an @ndmu.edu.ph mailbox, updated the saving test@ndmu.edu.ph in the database does not change that, updated the choose the google account test@ndmu.edu.ph, updated the that address is already on this user, updated the so the login will go through, updated the if google cannot finish the sign-in, and updated the the page now says “ndmu google sign-in could not be completed” instead of the official-account message for the google account sign in.
+15 · -44
Updated ndmuemailimportservice.php.
+5 · -2
Updated ndmuemailimportservice.php.
+121 · -3
Updated the the merge fails on a unique grade constraint when enrollment rows are moved onto the kept student, updated the i’ll trace the merge flow and make enrollment updates follow the parent record, updated the with tighter validation, and enhanced the the validation functionality for the bulk student merge function.
+145 · -8
Updated ndmuemailimportservice.php.
+129 · -46
Added pfile preview.
+47 · -3
Updated ndmuemailimportservice.php.
+199 · -44
Updated ndmuemailimportservice.php.
+107 · -7
Added the error handler for import for the add error handler in import function.
+27 · -4
Updated usercontroller.php.
+2 · -2
Updated user control import function.
+31 · -7
Updated the import NDMU email calls schema::hascolumn, updated the and this mysql driver returns column names in a form laravel 5 cannot read, and updated the i’ll use the existing safe column check instead for the add safescheme for ndmu email import.
+6 · -6
Updated manageadmissionapplicantcontroller.php.
+94
Added safe schema in login.
+18 · -17
Other work
1 commit
Updated updat: registrar faculty load.
+387 · -700
Comments
No comments yet. Be the first to leave a note.
Public report for Wendel Luche - Fullstack Developer. Generated Oct 10, 2026, 9:44 AM.
