(No direct script access allowed)

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["39"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 11:34:03","data":{"email":"timothyjames@mailinator.com"}},"Response":{"time":"2025-03-17 11:34:03","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["76"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 11:34:25","data":{"email":"timothyjames@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 11:34:25","data":{"status":true,"response":{"access_token":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiMDlmMjZhYTBlMDJlYzJjNWYyMWQ3ZjJkZDdmODU3YjViMjc5NGVmN2NhYjBlYWIzNmY3ODc4NzNiZWUwODBkNjllZGRjMjJjYTE5MmQ3ZTciLCJpYXQiOjE3NDIyMDc2NjUuMjQ2OTIzLCJuYmYiOjE3NDIyMDc2NjUuMjQ2OTI2LCJleHAiOjE3NzM3NDM2NjUuMjM5MzMsInN1YiI6IjQiLCJzY29wZXMiOltdfQ.F6iuEFeNWRoJW303Q5aKeM_2WQB2MrKOMYCiGEA16gRvqjwJfDCw-kwrdKghptEnSXmL__AQOvm1RwJ8mYCQfm0RamUi6F-_vuVZUmFfikJ2oCgN1MwUZqcJeCE6j-KmCgFqTeScMkWQjl9VTYPZGeH9-EPq5Yt4atWeg8LHuWEMiRKLXk0Ixuu_I7fCzzBr9oqPxUuGWXtShN_b4P-5JCY_pfhzKJO0pZMeXZhXt-O1twpxC-Hr7Tiw6it6LforQJjYd1UA7D0LmZcWwaCDh43BuV7mBTq9juTMt8BAdOMp8ljkYDSlHogZMNa44ZA151KgCVk80D8QjA7EdlHDlJOBHwebKqMpLzd3N62yJTYV-8bvzhnaCTJ-coN6M98MGVvvK373GQaUCdnio1seXYZLhw3vXNu04KAuDJCYsij9Yv8Wr8ZJjTL1NW63eUtoXAs8ned7CTQw5F-rZJICjYoSTyrPhQlStswf_D8Ovj3lAHOWAhMStqRcPXrlJpT34jeNR-plQNbHxuvsOaWZwyqtJg83oIBMK_Txxh2hcJX_e-BGa1tl6Jy61HY6US2GcY3EtpFHWUFSjECkMJN83SslSnVMq8ZQ7qSVlEqKB2KZuT6RZQMnmt-rL5G2Etpxmo_QU_ZqdD1JPymIcwwanyZbyG-3v-HqxGbrG9EqpcY","token_type":"Bearer","expires_at":"2026-03-17 11:34:25","user":{"last_name":"Timothy","middle_name":null,"first_name":"James","institution_id":null,"email":"timothyjames@mailinator.com","phone":null,"id":4,"last_login":"2025-03-17 11:34:25","login_count":8,"active":1,"changed_default_password":1},"role":{"id":9,"slug":"SUPER_ADMIN","name":"SUPER ADMIN"},"institution":null,"environment":"live"},"message":"Login successful"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get genders","Request":{"time":"2025-03-17 11:34:40","data":[]},"Response":{"time":"2025-03-17 11:34:40","data":{"status":true,"response":[{"id":2,"name":"FEMALE"},{"id":1,"name":"MALE"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve system roles","Request":{"time":"2025-03-17 11:34:40","data":[]},"Response":{"time":"2025-03-17 11:34:40","data":{"status":true,"response":[{"id":4,"slug":"ADMIN_ACADEMIC_STAFF","name":"ACADEMIC STAFF"},{"id":1,"slug":"ADMIN_ADMISSION_OFFICER","name":"ADMISSION OFFICER"},{"id":2,"slug":"ADMIN_CLEARANCE_OFFICER","name":"CLEARANCE OFFICER"},{"id":5,"slug":"ADMIN_COURSE_CORDINATOR","name":"COURSE CORDINATOR"},{"id":8,"slug":"ADMIN_DEAN","name":"DEAN"},{"id":3,"slug":"ADMIN_FINANCE_OFFICER","name":"FINANCE OFFICER"},{"id":7,"slug":"ADMIN_HOD","name":"HOD"},{"id":6,"slug":"ADMIN_LECTURER","name":"LECTURER"},{"id":10,"slug":"STUDENT","name":"STUDENT"},{"id":9,"slug":"SUPER_ADMIN","name":"SUPER ADMIN"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get institutions","Request":{"time":"2025-03-17 11:34:40","data":[]},"Response":{"time":"2025-03-17 11:34:40","data":{"status":true,"response":[{"id":1,"mda_id":68,"revenue_type_id":1,"name":"College of Education, Minna","code":"05819436254","reference":"3","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:41:50.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":11,"mda_item_id":2},{"id":2,"mda_id":62,"revenue_type_id":1,"name":"College of Legal Studies, Minna","code":"032600600100","reference":"4","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:06.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":5,"mda_item_id":29},{"id":3,"mda_id":78,"revenue_type_id":1,"name":"College of Nursing Sciences, Minna","code":"09330808721","reference":"6","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:08.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":2,"mda_item_id":null},{"id":4,"mda_id":80,"revenue_type_id":2,"name":"School of Health Technology","code":"052110600100","reference":"10","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:10.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":6,"mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/users?per_page=10","_Service":"fetch staff list","Request":{"time":"2025-03-17 11:34:40","data":{"per_page":"10"}},"Response":{"time":"2025-03-17 11:34:40","data":{"status":true,"response":{"current_page":1,"data":[{"staff_no":null,"institution_name":"College of Education, Minna","id":7,"name":"Adisa Williams","designation":null,"gender":null,"gender_id":null,"department_id":null,"institution_id":null,"phone":null,"email":"adisawilliams@mailinator.com","employment_date":null,"educational_level":null,"certification":null,"academic_rank":null,"active":1,"profile_image":null,"staff_created_at":null,"staff_updated_at":null},{"staff_no":null,"institution_name":"College of Education, Minna","id":8,"name":"Kennedy Ibe","designation":null,"gender":null,"gender_id":null,"department_id":null,"institution_id":null,"phone":null,"email":"kennedyibe@mailinator.com","employment_date":null,"educational_level":null,"certification":null,"academic_rank":null,"active":1,"profile_image":null,"staff_created_at":null,"staff_updated_at":null},{"staff_no":"CENG9039398","institution_name":"College of Education, Minna","id":1,"name":"Kren Jigani","designation":"Head Administration & Studies","gender":"MALE","gender_id":1,"department_id":1,"institution_id":1,"phone":null,"email":"krenjigani@mailinator.com","employment_date":"2022-03-11","educational_level":"Doctorate","certification":null,"academic_rank":"Senior Lecturer","active":1,"profile_image":null,"staff_created_at":"2025-03-11 11:41:50","staff_updated_at":"2025-03-11 11:41:50"},{"staff_no":null,"institution_name":"College of Education, Minna","id":2,"name":"Badmos Mathew","designation":null,"gender":null,"gender_id":null,"department_id":null,"institution_id":null,"phone":null,"email":"badmosmathew@mailinator.com","employment_date":null,"educational_level":null,"certification":null,"academic_rank":null,"active":1,"profile_image":null,"staff_created_at":null,"staff_updated_at":null},{"staff_no":"CENG9035621","institution_name":"College of Education, Minna","id":3,"name":"Bernard John","designation":"Head of Department","gender":"MALE","gender_id":1,"department_id":1,"institution_id":1,"phone":null,"email":"bernardjohn@mailinator.com","employment_date":"2022-03-11","educational_level":"Doctorate","certification":null,"academic_rank":"Senior Lecturer","active":1,"profile_image":null,"staff_created_at":"2025-03-11 11:41:50","staff_updated_at":"2025-03-11 11:41:50"},{"staff_no":"CENG9034413","institution_name":"College of Education, Minna","id":5,"name":"Paul Walker","designation":"Head of Department","gender":"MALE","gender_id":1,"department_id":1,"institution_id":1,"phone":null,"email":"paulwalker@mailinator.com","employment_date":"2022-03-11","educational_level":"Doctorate","certification":null,"academic_rank":"Senior Lecturer","active":1,"profile_image":null,"staff_created_at":"2025-03-11 11:41:50","staff_updated_at":"2025-03-11 11:41:50"},{"staff_no":null,"institution_name":null,"id":6,"name":"Wisdom James","designation":null,"gender":null,"gender_id":null,"department_id":null,"institution_id":null,"phone":null,"email":"wisdomjames@mailinator.com","employment_date":null,"educational_level":null,"certification":null,"academic_rank":null,"active":1,"profile_image":null,"staff_created_at":null,"staff_updated_at":null}],"from":1,"last_page":1,"per_page":10,"to":7,"total":7},"message":"Query ok"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["37"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Chromium\";v=\"134\", \"Not:A-Brand\";v=\"24\", \"Google Chrome\";v=\"134\""],"content-type":["application\/json"],"dnt":["1"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-NG,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6"],"cookie":["__gsas=ID=6f98668247d34286:T=1732289495:RT=1732289495:S=ALNI_MZvgAngwSU92jo1efsFV7TCbCEnOw; pvisitor=94541a86-0066-490e-97fe-cfa7668dcb56; connect.sid=s%3AoOEigzY6Q34JvZvRTpsVD5N1BgUz2O1d.Qv3L18D6bMatXOOmMyvHjeADI24VDdvg0rXy22FEY94"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 11:34:43","data":{"email":"krenjigani@mailinator.com"}},"Response":{"time":"2025-03-17 11:34:43","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["74"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Chromium\";v=\"134\", \"Not:A-Brand\";v=\"24\", \"Google Chrome\";v=\"134\""],"content-type":["application\/json"],"dnt":["1"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-NG,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6"],"cookie":["__gsas=ID=6f98668247d34286:T=1732289495:RT=1732289495:S=ALNI_MZvgAngwSU92jo1efsFV7TCbCEnOw; pvisitor=94541a86-0066-490e-97fe-cfa7668dcb56; connect.sid=s%3AoOEigzY6Q34JvZvRTpsVD5N1BgUz2O1d.Qv3L18D6bMatXOOmMyvHjeADI24VDdvg0rXy22FEY94"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 11:34:51","data":{"email":"krenjigani@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 11:34:51","data":{"status":true,"response":{"access_token":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiNjQyYWViOTA5ODdkOTVjMTcxNDhkOTJiNDEyMzVhYzE1YjcyNzliOTBmNjUwMTk1NWNkYThlMWY5Y2E1ZmIzYTQxYjM2Yzg0ZDcwODBjZTciLCJpYXQiOjE3NDIyMDc2OTEuNTIzMzY5LCJuYmYiOjE3NDIyMDc2OTEuNTIzMzcyLCJleHAiOjE3NzM3NDM2OTEuNTE4Nzk4LCJzdWIiOiIxIiwic2NvcGVzIjpbXX0.SNNvpS0sBHBwoijuSJw926-QnuMqg1_EhAmKtH2cauPk93HNgc85_zO910QJjnJu-AnWW2J-vy5aTGpt6jjyt_roK8nb21v7-7h0_Nll2S2nVX69ir3zcgz2GQVMK_X2czEBA2Sb2HTs8lR-7iBmmuAMbLc4S14NHxq4isZg68ktkQkbo0a6Yj1exvVhlYPaq8BKYFrBrj86i6INjYiPx9AkG4NOcCpTE1G3zHtrRxTW32JCuCIpVYW_UQxXszROTOFC0avi2mmJizDe23hUivSal7QQF8ZDRNmGDm7ud4bqJl0LcsADqKET_AKlYgoYMb1FBEoGH-TdTwmCRDGUeS7f5tr9kvm4hl9uOug1c1-hQCGWPNdPfcNzM-D2DU9GoqpacLlaa3FcLLPfAMGA_q6GpXprsaMA7ks4dCspQC7pvQiyQTNIVyis5Bi8-23OvzGDXtyS-Uv69sS7K3Er13kNrFbcaPl_htZShGrsNBSR5r3_AT7zwtq8AH9es-EWnoWPh4IgH16NKx4oM2oKMOjmGg1ZZv1ee8cXf_Yz3sYP1hfzpILPXuTxllJ6xfss2V6HNjSQNODq2R1PZORbWne4eANfygXIXvd8Mr1Mn-WWunJ0F_usEcckw69LBTMgCA0Zn5LksslJvw9w0cy1JOIESVkHRJQVm2CO7lAh2u8","token_type":"Bearer","expires_at":"2026-03-17 11:34:51","user":{"last_name":"Kren","middle_name":null,"first_name":"Jigani","institution_id":1,"email":"krenjigani@mailinator.com","phone":null,"id":1,"last_login":"2025-03-17 11:34:51","login_count":1,"active":1,"changed_default_password":1},"role":{"id":2,"slug":"ADMIN_CLEARANCE_OFFICER","name":"CLEARANCE OFFICER"},"institution":{"institution_name":"College of Education, Minna","institution_id":1},"environment":"live"},"message":"Login successful"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"sec-ch-ua":["\"Chromium\";v=\"134\", \"Not:A-Brand\";v=\"24\", \"Google Chrome\";v=\"134\""],"sec-ch-ua-mobile":["?0"],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"dnt":["1"],"content-type":["application\/json"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-NG,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6"],"cookie":["__gsas=ID=6f98668247d34286:T=1732289495:RT=1732289495:S=ALNI_MZvgAngwSU92jo1efsFV7TCbCEnOw; pvisitor=94541a86-0066-490e-97fe-cfa7668dcb56; connect.sid=s%3AoOEigzY6Q34JvZvRTpsVD5N1BgUz2O1d.Qv3L18D6bMatXOOmMyvHjeADI24VDdvg0rXy22FEY94"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 11:34:58","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 11:34:58","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"sec-ch-ua":["\"Chromium\";v=\"134\", \"Not:A-Brand\";v=\"24\", \"Google Chrome\";v=\"134\""],"sec-ch-ua-mobile":["?0"],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"dnt":["1"],"content-type":["application\/json"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-NG,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6"],"cookie":["__gsas=ID=6f98668247d34286:T=1732289495:RT=1732289495:S=ALNI_MZvgAngwSU92jo1efsFV7TCbCEnOw; pvisitor=94541a86-0066-490e-97fe-cfa7668dcb56; connect.sid=s%3AoOEigzY6Q34JvZvRTpsVD5N1BgUz2O1d.Qv3L18D6bMatXOOmMyvHjeADI24VDdvg0rXy22FEY94"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?institution_id=null&page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 11:35:03","data":{"institution_id":"null","page":"1","per_page":"10"}},"Response":{"time":"2025-03-17 11:35:03","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"sec-ch-ua":["\"Chromium\";v=\"134\", \"Not:A-Brand\";v=\"24\", \"Google Chrome\";v=\"134\""],"sec-ch-ua-mobile":["?0"],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"dnt":["1"],"content-type":["application\/json"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-NG,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6"],"cookie":["__gsas=ID=6f98668247d34286:T=1732289495:RT=1732289495:S=ALNI_MZvgAngwSU92jo1efsFV7TCbCEnOw; pvisitor=94541a86-0066-490e-97fe-cfa7668dcb56; connect.sid=s%3AoOEigzY6Q34JvZvRTpsVD5N1BgUz2O1d.Qv3L18D6bMatXOOmMyvHjeADI24VDdvg0rXy22FEY94"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 11:35:06","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 11:35:06","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"view institution","Request":{"time":"2025-03-17 11:35:09","data":[]},"Response":{"time":"2025-03-17 11:35:09","data":{"status":true,"response":[{"id":1,"mda_id":68,"revenue_type_id":1,"name":"College of Education, Minna","code":"05819436254","reference":"3","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:41:50.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","mda_item_id":2},{"id":2,"mda_id":62,"revenue_type_id":1,"name":"College of Legal Studies, Minna","code":"032600600100","reference":"4","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:06.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","mda_item_id":29},{"id":3,"mda_id":78,"revenue_type_id":1,"name":"College of Nursing Sciences, Minna","code":"09330808721","reference":"6","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:08.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","mda_item_id":null},{"id":4,"mda_id":80,"revenue_type_id":2,"name":"School of Health Technology","code":"052110600100","reference":"10","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:10.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get institutions","Request":{"time":"2025-03-17 11:35:23","data":[]},"Response":{"time":"2025-03-17 11:35:23","data":{"status":true,"response":[{"id":1,"mda_id":68,"revenue_type_id":1,"name":"College of Education, Minna","code":"05819436254","reference":"3","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:41:50.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":11,"mda_item_id":2},{"id":2,"mda_id":62,"revenue_type_id":1,"name":"College of Legal Studies, Minna","code":"032600600100","reference":"4","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:06.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":5,"mda_item_id":29},{"id":3,"mda_id":78,"revenue_type_id":1,"name":"College of Nursing Sciences, Minna","code":"09330808721","reference":"6","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:08.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":2,"mda_item_id":null},{"id":4,"mda_id":80,"revenue_type_id":2,"name":"School of Health Technology","code":"052110600100","reference":"10","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:10.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":6,"mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"admin fetch faculty list","Request":{"time":"2025-03-17 11:35:23","data":[]},"Response":{"time":"2025-03-17 11:35:23","data":{"status":true,"response":{"current_page":1,"data":[{"id":17,"name":"Midwifery","institution_id":3,"institution_name":"College of Nursing Sciences, Minna"},{"id":18,"name":"Nursing","institution_id":3,"institution_name":"College of Nursing Sciences, Minna"}],"from":1,"last_page":1,"per_page":10,"to":2,"total":2},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve departments","Request":{"time":"2025-03-17 11:54:07","data":[]},"Response":{"time":"2025-03-17 11:54:07","data":{"status":true,"response":[{"id":17,"name":"Midwifery","mda_item_id":null},{"id":18,"name":"Nursing","mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get institutions","Request":{"time":"2025-03-17 11:54:07","data":[]},"Response":{"time":"2025-03-17 11:54:07","data":{"status":true,"response":[{"id":1,"mda_id":68,"revenue_type_id":1,"name":"College of Education, Minna","code":"05819436254","reference":"3","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:41:50.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":11,"mda_item_id":2},{"id":2,"mda_id":62,"revenue_type_id":1,"name":"College of Legal Studies, Minna","code":"032600600100","reference":"4","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:06.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":5,"mda_item_id":29},{"id":3,"mda_id":78,"revenue_type_id":1,"name":"College of Nursing Sciences, Minna","code":"09330808721","reference":"6","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:08.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":2,"mda_item_id":null},{"id":4,"mda_id":80,"revenue_type_id":2,"name":"School of Health Technology","code":"052110600100","reference":"10","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:10.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":6,"mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"admin fetch department list","Request":{"time":"2025-03-17 11:54:07","data":[]},"Response":{"time":"2025-03-17 11:54:07","data":{"status":true,"response":{"current_page":1,"data":[],"from":null,"last_page":1,"per_page":10,"to":null,"total":0},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get institutions","Request":{"time":"2025-03-17 11:54:28","data":[]},"Response":{"time":"2025-03-17 11:54:28","data":{"status":true,"response":[{"id":1,"mda_id":68,"revenue_type_id":1,"name":"College of Education, Minna","code":"05819436254","reference":"3","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:41:50.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":11,"mda_item_id":2},{"id":2,"mda_id":62,"revenue_type_id":1,"name":"College of Legal Studies, Minna","code":"032600600100","reference":"4","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:06.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":5,"mda_item_id":29},{"id":3,"mda_id":78,"revenue_type_id":1,"name":"College of Nursing Sciences, Minna","code":"09330808721","reference":"6","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:08.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":2,"mda_item_id":null},{"id":4,"mda_id":80,"revenue_type_id":2,"name":"School of Health Technology","code":"052110600100","reference":"10","access_code":null,"webhook_url":null,"supervisory_ministry":null,"address":null,"created_at":"2025-03-11T10:42:10.000000Z","updated_at":"2025-03-11T10:42:13.000000Z","faculties_count":6,"mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve departments","Request":{"time":"2025-03-17 11:54:38","data":[]},"Response":{"time":"2025-03-17 11:54:38","data":{"status":true,"response":[{"id":1,"name":"Economics","mda_item_id":null},{"id":2,"name":"Education","mda_item_id":null},{"id":3,"name":"Geography","mda_item_id":null},{"id":4,"name":"History","mda_item_id":null},{"id":5,"name":"Languages","mda_item_id":null},{"id":6,"name":"Mathematics","mda_item_id":null},{"id":7,"name":"PES\/ECCE","mda_item_id":null},{"id":8,"name":"Religious Study","mda_item_id":null},{"id":9,"name":"Sciences","mda_item_id":null},{"id":10,"name":"Social Studies","mda_item_id":null},{"id":11,"name":"Vocational Education","mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["2"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/logout","_Service":"authentication failed","Request":{"time":"2025-03-17 11:56:08","data":[]},"Response":{"time":"2025-03-17 11:56:08","data":{"status":false,"response":null,"message":"Valid auth credentials required","code":401,"authenticated":false}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["38"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 11:58:26","data":{"email":"bernardjohn@mailinator.com"}},"Response":{"time":"2025-03-17 11:58:26","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["75"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 11:58:43","data":{"email":"bernardjohn@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 11:58:43","data":{"status":true,"response":{"access_token":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiYjkzZDU2ZWQxZmRhODc1MjIxMTUzZjRmZGFhM2Q1YmQ2MDEzN2FmODNkMDllNDUwYTM0Njc1ZWU0YzVmYTE1MDk0NmNhNjM5ODlkOGQwMDQiLCJpYXQiOjE3NDIyMDkxMjMuNjMzODA1LCJuYmYiOjE3NDIyMDkxMjMuNjMzODA4LCJleHAiOjE3NzM3NDUxMjMuNjI0MTYyLCJzdWIiOiIzIiwic2NvcGVzIjpbXX0.ExMpZx_-iQDpDyULs1CxMjHnCpjRAvF_rFO8tG64x-c6hq0GFfE1zOMdVyV0_0sTVDGic_ep646psyQEMWRiTgVSQaJSx9qbjm3iXmUWvCnjXdWDUzKrytzNRsJvn_bHxJYEzOwdu6w3TIebpx_aMMCJgS1AVTs4e87c5Ltvo7XORNaBMPkJL2Set3doCmG8rUBTnGj7WROXuH_AR26h5qoPOIpjz2B7TkDFNOcZ2rmf7unpBZw_zNQS5trfkpfHF4ysnD8l_IsmeQSEkufa5PmiJ1W9igQaeSHdwPQYvVuJUbGPlSUx2ZWCoUiL4wWgxGoW_zfr9NsnREYniz7ugZXz-H7hoBlUguOMwsaNduCPNtwNcfsl4i7nFi0M_NikszjkWr--uz7DfpGxS9wDFulxsZm5S58UZ39HVaO_2GuywQ8CzO6saHYudk3rzmPC8ddbiah0NtCCEtNvsXK99HpD7dVZsU3nk6A4HLXzjAi4-fLNeRpRSeMDQDl5MWA2N6Okt6jPrc4cWQEv3dNwQxIoMiMgP4Mr7D2qbRfi4qCwgVFov8E5Sa-58oxQ2_1VCI0hHTDFrhR8qNGKvmbL79nHCnvousSngK-LhV1eRxHeij-h5DMUQMQxDGtCPCWaD9Gl-ErZktKE11d2ayAQGml4V_qRCC1TcEEJcbhWGIw","token_type":"Bearer","expires_at":"2026-03-17 11:58:43","user":{"last_name":"Bernard","middle_name":null,"first_name":"John","institution_id":1,"email":"bernardjohn@mailinator.com","phone":null,"id":3,"last_login":"2025-03-17 11:58:43","login_count":2,"active":1,"changed_default_password":1},"role":{"id":1,"slug":"ADMIN_ADMISSION_OFFICER","name":"ADMISSION OFFICER"},"institution":{"institution_name":"College of Education, Minna","institution_id":1},"environment":"live"},"message":"Login successful"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get titles","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":10,"name":"Alhaja"},{"id":9,"name":"Alhaji"},{"id":7,"name":"Chief"},{"id":4,"name":"Dr."},{"id":13,"name":"Engineer"},{"id":6,"name":"Engr."},{"id":11,"name":"Imam"},{"id":2,"name":"Miss"},{"id":1,"name":"Mr."},{"id":3,"name":"Mrs."},{"id":12,"name":"Pastor"},{"id":5,"name":"Prof."},{"id":8,"name":"Rev."}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get countries","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":1,"name":"Nigerian"},{"id":2,"name":"Non Nigerian"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get educational levels","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":6,"name":"Bachelor's Degree"},{"id":8,"name":"Doctorate"},{"id":4,"name":"GED"},{"id":7,"name":"Master Degree"},{"id":1,"name":"No Formal Education"},{"id":2,"name":"Primary Education"},{"id":3,"name":"Secondary Education"},{"id":5,"name":"Vocational Qualification"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get academic years","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":1,"year":2020},{"id":2,"year":2021},{"id":3,"year":2022},{"id":4,"year":2023},{"id":5,"year":2024},{"id":6,"year":2025}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get genders","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":2,"name":"FEMALE"},{"id":1,"name":"MALE"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve departments","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":1,"name":"Economics","description":"--","faculty_id":1,"faculty_name":"Economics","institution_id":1,"institution_name":"College of Education, Minna"},{"id":2,"name":"Adult Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":3,"name":"Computer Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":4,"name":"Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":5,"name":"Physical and Health Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":6,"name":"Special Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":7,"name":"Technical Education","description":"--","faculty_id":2,"faculty_name":"Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":8,"name":"Geography","description":"--","faculty_id":3,"faculty_name":"Geography","institution_id":1,"institution_name":"College of Education, Minna"},{"id":9,"name":"History","description":"--","faculty_id":4,"faculty_name":"History","institution_id":1,"institution_name":"College of Education, Minna"},{"id":10,"name":"Arabic","description":"--","faculty_id":5,"faculty_name":"Languages","institution_id":1,"institution_name":"College of Education, Minna"},{"id":11,"name":"French","description":"--","faculty_id":5,"faculty_name":"Languages","institution_id":1,"institution_name":"College of Education, Minna"},{"id":12,"name":"Hausa","description":"--","faculty_id":5,"faculty_name":"Languages","institution_id":1,"institution_name":"College of Education, Minna"},{"id":13,"name":"Mathematics","description":"--","faculty_id":6,"faculty_name":"Mathematics","institution_id":1,"institution_name":"College of Education, Minna"},{"id":14,"name":"PES\/ECCE","description":"--","faculty_id":7,"faculty_name":"PES\/ECCE","institution_id":1,"institution_name":"College of Education, Minna"},{"id":15,"name":"Islamic Studies","description":"--","faculty_id":8,"faculty_name":"Religious Study","institution_id":1,"institution_name":"College of Education, Minna"},{"id":16,"name":"Biology","description":"--","faculty_id":9,"faculty_name":"Sciences","institution_id":1,"institution_name":"College of Education, Minna"},{"id":17,"name":"Chemistry","description":"--","faculty_id":9,"faculty_name":"Sciences","institution_id":1,"institution_name":"College of Education, Minna"},{"id":18,"name":"Integrated Science","description":"--","faculty_id":9,"faculty_name":"Sciences","institution_id":1,"institution_name":"College of Education, Minna"},{"id":19,"name":"Physics","description":"--","faculty_id":9,"faculty_name":"Sciences","institution_id":1,"institution_name":"College of Education, Minna"},{"id":20,"name":"Science","description":"--","faculty_id":9,"faculty_name":"Sciences","institution_id":1,"institution_name":"College of Education, Minna"},{"id":21,"name":"Social Studies","description":"--","faculty_id":10,"faculty_name":"Social Studies","institution_id":1,"institution_name":"College of Education, Minna"},{"id":22,"name":"Vocational Education","description":"--","faculty_id":11,"faculty_name":"Vocational Education","institution_id":1,"institution_name":"College of Education, Minna"},{"id":23,"name":"Business Administration","description":"--","faculty_id":12,"faculty_name":"Administration","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":24,"name":"Public Administration","description":"--","faculty_id":12,"faculty_name":"Administration","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":25,"name":"Arts","description":"--","faculty_id":13,"faculty_name":"Arts","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":26,"name":"Mass Communication","description":"--","faculty_id":14,"faculty_name":"Communication","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":27,"name":"Crime Management","description":"--","faculty_id":15,"faculty_name":"Crime Management","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":28,"name":"Law","description":"--","faculty_id":16,"faculty_name":"Legal Studies","institution_id":2,"institution_name":"College of Legal Studies, Minna"},{"id":29,"name":"Basic Midwifery","description":"--","faculty_id":17,"faculty_name":"Midwifery","institution_id":3,"institution_name":"College of Nursing Sciences, Minna"},{"id":30,"name":"Basic Nursing","description":"--","faculty_id":18,"faculty_name":"Nursing","institution_id":3,"institution_name":"College of Nursing Sciences, Minna"},{"id":31,"name":"Post Basic Nursing","description":"--","faculty_id":18,"faculty_name":"Nursing","institution_id":3,"institution_name":"College of Nursing Sciences, Minna"},{"id":32,"name":"Community Health","description":"--","faculty_id":19,"faculty_name":"Community Health","institution_id":4,"institution_name":"School of Health Technology"},{"id":33,"name":"Environmental Health Technology","description":"--","faculty_id":20,"faculty_name":"Environmental Health Technology","institution_id":4,"institution_name":"School of Health Technology"},{"id":34,"name":"Health Education and Promotion","description":"--","faculty_id":21,"faculty_name":"Health Education and Promotion","institution_id":4,"institution_name":"School of Health Technology"},{"id":35,"name":"Health Information Management ","description":"--","faculty_id":22,"faculty_name":"Health Information Management ","institution_id":4,"institution_name":"School of Health Technology"},{"id":36,"name":"Medical Laboratory Technician","description":"--","faculty_id":23,"faculty_name":"Medical Laboratory Technician","institution_id":4,"institution_name":"School of Health Technology"},{"id":37,"name":"Pharmacy Technician","description":"--","faculty_id":24,"faculty_name":"Pharmacy Technician","institution_id":4,"institution_name":"School of Health Technology"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/pre-admission-list?page=1&per_page=10","_Service":"admin pre admission list","Request":{"time":"2025-03-17 12:00:00","data":{"page":"1","per_page":"10"}},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":{"current_page":1,"data":[],"from":null,"last_page":1,"per_page":10,"to":null,"total":0},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve departments","Request":{"time":"2025-03-17 12:00:00","data":[]},"Response":{"time":"2025-03-17 12:00:00","data":{"status":true,"response":[{"id":17,"name":"Midwifery","mda_item_id":null},{"id":18,"name":"Nursing","mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/invitation-list?page=1&per_page=10","_Service":"admin invitation list","Request":{"time":"2025-03-17 12:00:05","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:00:05","data":{"status":true,"response":{"current_page":1,"data":[],"from":null,"last_page":1,"per_page":10,"to":null,"total":0},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/manage-offer-list?page=1&per_page=10","_Service":"admin manage offer list","Request":{"time":"2025-03-17 12:00:39","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:00:39","data":{"status":true,"response":{"current_page":1,"data":[],"from":null,"last_page":1,"per_page":10,"to":null,"total":0},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get titles","Request":{"time":"2025-03-17 12:00:53","data":[]},"Response":{"time":"2025-03-17 12:00:53","data":{"status":true,"response":[{"id":10,"name":"Alhaja"},{"id":9,"name":"Alhaji"},{"id":7,"name":"Chief"},{"id":4,"name":"Dr."},{"id":13,"name":"Engineer"},{"id":6,"name":"Engr."},{"id":11,"name":"Imam"},{"id":2,"name":"Miss"},{"id":1,"name":"Mr."},{"id":3,"name":"Mrs."},{"id":12,"name":"Pastor"},{"id":5,"name":"Prof."},{"id":8,"name":"Rev."}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get genders","Request":{"time":"2025-03-17 12:00:53","data":[]},"Response":{"time":"2025-03-17 12:00:53","data":{"status":true,"response":[{"id":2,"name":"FEMALE"},{"id":1,"name":"MALE"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get countries","Request":{"time":"2025-03-17 12:00:53","data":[]},"Response":{"time":"2025-03-17 12:00:53","data":{"status":true,"response":[{"id":1,"name":"Nigerian"},{"id":2,"name":"Non Nigerian"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get educational levels","Request":{"time":"2025-03-17 12:00:53","data":[]},"Response":{"time":"2025-03-17 12:00:53","data":{"status":true,"response":[{"id":6,"name":"Bachelor's Degree"},{"id":8,"name":"Doctorate"},{"id":4,"name":"GED"},{"id":7,"name":"Master Degree"},{"id":1,"name":"No Formal Education"},{"id":2,"name":"Primary Education"},{"id":3,"name":"Secondary Education"},{"id":5,"name":"Vocational Qualification"}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get academic years","Request":{"time":"2025-03-17 12:00:53","data":[]},"Response":{"time":"2025-03-17 12:00:53","data":{"status":true,"response":[{"id":1,"year":2020},{"id":2,"year":2021},{"id":3,"year":2022},{"id":4,"year":2023},{"id":5,"year":2024},{"id":6,"year":2025}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/students?page=1&per_page=10","_Service":"admin students list","Request":{"time":"2025-03-17 12:00:53","data":{"page":"1","per_page":"10"}},"Response":{"time":"2025-03-17 12:00:53","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'students.session_id' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `students`.`session_id` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where students.institution_id=1)","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"retrieve departments","Request":{"time":"2025-03-17 12:00:54","data":[]},"Response":{"time":"2025-03-17 12:00:54","data":{"status":true,"response":[{"id":17,"name":"Midwifery","mda_item_id":null},{"id":18,"name":"Nursing","mda_item_id":null}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get academic years","Request":{"time":"2025-03-17 12:01:58","data":[]},"Response":{"time":"2025-03-17 12:01:58","data":{"status":true,"response":[{"id":1,"year":2020},{"id":2,"year":2021},{"id":3,"year":2022},{"id":4,"year":2023},{"id":5,"year":2024},{"id":6,"year":2025}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/admission-sessions?page=1&per_page=10","_Service":"admin academic sessions list","Request":{"time":"2025-03-17 12:01:58","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:01:58","data":{"status":true,"response":{"current_page":1,"data":[{"id":1,"name":"2023\/2024","start_date":"2023-10-11","end_date":"2024-03-25","status":"OPEN","institution":"College of Education, Minna","academic_year":2024}],"from":1,"last_page":1,"per_page":10,"to":1,"total":1},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############"},"method":"GET","url":"http:\/\/:","_Service":"get academic years","Request":{"time":"2025-03-17 12:02:07","data":[]},"Response":{"time":"2025-03-17 12:02:07","data":{"status":true,"response":[{"id":1,"year":2020},{"id":2,"year":2021},{"id":3,"year":2022},{"id":4,"year":2023},{"id":5,"year":2024},{"id":6,"year":2025}],"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/admission-windows?page=1&per_page=10","_Service":"admin academic windows","Request":{"time":"2025-03-17 12:02:07","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:02:07","data":{"status":true,"response":{"current_page":1,"data":[{"id":1,"start_date":"2024-08-11","end_date":"2024-12-30","status":"OPEN","academic_year":2024,"session_name":"2023\/2024"}],"from":1,"last_page":1,"per_page":10,"to":1,"total":1},"message":"Query ok"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["2"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/logout","_Service":"authentication failed","Request":{"time":"2025-03-17 12:03:50","data":[]},"Response":{"time":"2025-03-17 12:03:50","data":{"status":false,"response":null,"message":"Valid auth credentials required","code":401,"authenticated":false}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["39"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 12:04:18","data":{"email":"badmosmathew@mailinator.com"}},"Response":{"time":"2025-03-17 12:04:18","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["76"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 12:08:18","data":{"email":"badmosmathew@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 12:08:18","data":{"status":false,"response":{"last_name":"Badmos","middle_name":null,"first_name":"Mathew","institution_id":1,"email":"badmosmathew@mailinator.com","phone":null,"id":2,"last_login":null,"login_count":0,"active":1,"changed_default_password":1},"message":"Sorry! You are not assigned to manage any institution yet!"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["76"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 12:08:43","data":{"email":"badmosmathew@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 12:08:43","data":{"status":false,"response":{"last_name":"Badmos","middle_name":null,"first_name":"Mathew","institution_id":1,"email":"badmosmathew@mailinator.com","phone":null,"id":2,"last_login":null,"login_count":0,"active":1,"changed_default_password":1},"message":"Sorry! You are not assigned to manage any institution yet!"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["2"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/logout","_Service":"authentication failed","Request":{"time":"2025-03-17 12:28:00","data":[]},"Response":{"time":"2025-03-17 12:28:00","data":{"status":false,"response":null,"message":"Valid auth credentials required","code":401,"authenticated":false}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["39"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 12:28:42","data":{"email":"bodmosmathew@mailinator.com"}},"Response":{"time":"2025-03-17 12:28:42","data":{"status":false,"response":null,"message":"Account with supplied email does not exists"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["39"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 12:29:22","data":{"email":"badmosmathew@mailinator.com"}},"Response":{"time":"2025-03-17 12:29:22","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["76"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 12:29:44","data":{"email":"badmosmathew@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 12:29:44","data":{"status":false,"response":{"last_name":"Badmos","middle_name":null,"first_name":"Mathew","institution_id":1,"email":"badmosmathew@mailinator.com","phone":null,"id":2,"last_login":null,"login_count":0,"active":1,"changed_default_password":1},"message":"Sorry! You are not assigned to manage any institution yet!"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["76"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 12:31:00","data":{"email":"badmosmathew@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 12:31:00","data":{"status":false,"response":{"last_name":"Badmos","middle_name":null,"first_name":"Mathew","institution_id":1,"email":"badmosmathew@mailinator.com","phone":null,"id":2,"last_login":null,"login_count":0,"active":1,"changed_default_password":1},"message":"Sorry! You are not assigned to manage any institution yet!"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["37"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/send-login-otp","_Service":"send login otp","Request":{"time":"2025-03-17 12:35:03","data":{"email":"krenjigani@mailinator.com"}},"Response":{"time":"2025-03-17 12:35:03","data":{"status":true,"response":null,"message":"Use default OTP"}},"extra":null}

{"header":{"host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["74"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"],"authorization":"############...*...secret...*...############"},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/login","_Service":"send default password","Request":{"time":"2025-03-17 12:35:18","data":{"email":"krenjigani@mailinator.com","otp":"123456"}},"Response":{"time":"2025-03-17 12:35:18","data":{"status":true,"response":{"access_token":"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiOTM5OWNmYzFhYmJkOTE5M2E5NWQ5ZWQ1NmQwMjQ4YmQwZTE0NTJiZGY1MTMwY2ZkMjI1YTM4YzY2N2U0MmYyMjlmMWQ5YjQwY2FkMmMxMTMiLCJpYXQiOjE3NDIyMTEzMTguOTA0OTY4LCJuYmYiOjE3NDIyMTEzMTguOTA0OTcyLCJleHAiOjE3NzM3NDczMTguODk4Mjg5LCJzdWIiOiIxIiwic2NvcGVzIjpbXX0.Hy1_e0RBAinfXbRvpVfgc8G03gxwkQnNi2YDabqbvb3IgGU8x_HF739Ja8GDkiarDeIrvz3gp_kjxH4OADAwUihUcWa_f0flR8YLlRGlY96QIx67ktDguzekejAH4dlWpodgeAFvXHLpNxgzWtHprVg50njRlBtSgFTPXiRfskAQoCqhK1_IUxrPkfhVERMhLSrucDv6v8B0J5LdY6yqh3jLEsbZhcl1rFvCT_0BBLfU0HkZfMFQsggs_jDABlWojvopOzvi8pSruz_PYHx4qUxEXOIdVwz1-g9RxumJD8cbV0WDJwcBPcBVLH2UyGFJscV1iJ8DknJgt-RpQi5uhnM6axQl-MhRha1tWl-BP5e9Yzc4rCHEa1Bq7LDR3kWoRJhs2w5jJlyUZmnaYgFGYTivFufUN3aooTAt24qrmVtvfN1WH4dMneH-gXCuwe-H-aOVPmP083kMhq8S9ty9zK2_QmCB8OZuwjCoVYahH-eomy6_mUpZZEJjRB3O0cvrQn_sifzwJHA8D2kivWvaGpDtpUiFALjQCs5rl2EBv0oeSNUQmGcgNsd5WgUvUbCHg0ps17YyL-n2_Jm83cPHXIQ5u3ZoghjaarhnB4qvo70JbsSDAYMlztWzrJrPl7K5oPyowhMZqIP7yi0i58aFycjtXcy_z6Rv40UKQyjVfEE","token_type":"Bearer","expires_at":"2026-03-17 12:35:18","user":{"last_name":"Kren","middle_name":null,"first_name":"Jigani","institution_id":1,"email":"krenjigani@mailinator.com","phone":null,"id":1,"last_login":"2025-03-17 12:35:18","login_count":2,"active":1,"changed_default_password":1},"role":{"id":2,"slug":"ADMIN_CLEARANCE_OFFICER","name":"CLEARANCE OFFICER"},"institution":{"institution_name":"College of Education, Minna","institution_id":1},"environment":"live"},"message":"Login successful"}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 12:35:33","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:35:33","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 12:35:43","data":{"per_page":"10","page":"1"}},"Response":{"time":"2025-03-17 12:35:43","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/student-list?institution_id=null&page=1&per_page=10","_Service":"admin student list","Request":{"time":"2025-03-17 12:35:49","data":{"institution_id":"null","page":"1","per_page":"10"}},"Response":{"time":"2025-03-17 12:35:49","data":{"exception ":"---------------------------->","msg":"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'on clause' (SQL: select count(*) as aggregate from `students` left join `institutions` on `institutions`.`id` = `students`.`institution_id` left join `faculties` on `faculties`.`id` = `students`.`faculty_id` left join `departments` on `departments`.`id` = `students`.`department_id` left join `academic_sessions` on `academic_sessions`.`id` = `` left join `genders` on `genders`.`id` = `students`.`gender_id` left join `titles` on `titles`.`id` = `students`.`title_id` left join `indigenes` on `indigenes`.`id` = `students`.`indigene_id` left join `academic_years` on `academic_years`.`id` = `students`.`registration_year_id` left join `admission_statuses` on `admission_statuses`.`id` = `students`.`admission_status_id` left join `states` on `states`.`id` = `students`.`state_id` left join `levels` on `levels`.`id` = `students`.`level_id` left join `local_governments` on `local_governments`.`id` = `students`.`lga_id` where (`students`.`institution_id` = 1))","file":"\/var\/www\/html\/SMS-API\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":712}},"extra":null}

{"header":{"authorization":"############...*...secret...*...############","host":["ustcdev.com"],"connection":["keep-alive"],"content-length":["2"],"sec-ch-ua-platform":["\"Windows\""],"user-agent":["Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/133.0.0.0 Safari\/537.36"],"accept":["application\/json, text\/plain, *\/*"],"sec-ch-ua":["\"Not(A:Brand\";v=\"99\", \"Google Chrome\";v=\"133\", \"Chromium\";v=\"133\""],"content-type":["application\/json"],"sec-ch-ua-mobile":["?0"],"origin":["https:\/\/ustcdev.com"],"sec-fetch-site":["same-origin"],"sec-fetch-mode":["cors"],"sec-fetch-dest":["empty"],"referer":["https:\/\/ustcdev.com\/school-ui\/"],"accept-encoding":["gzip, deflate, br, zstd"],"accept-language":["en-US,en;q=0.9"]},"method":"POST","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/admin\/logout","_Service":"authentication failed","Request":{"time":"2025-03-17 12:35:56","data":[]},"Response":{"time":"2025-03-17 12:35:56","data":{"status":false,"response":null,"message":"Valid auth credentials required","code":401,"authenticated":false}},"extra":null}

{"header":{"x-openai-host-hash":["244781903"],"accept":["*\/*"],"from":["gptbot(at)openai.com"],"user-agent":["Mozilla\/5.0 AppleWebKit\/537.36 (KHTML, like Gecko; compatible; GPTBot\/1.2; +https:\/\/openai.com\/gptbot)"],"accept-encoding":["gzip, br, deflate"],"host":["ustcdev.com"],"authorization":"############...*...secret...*...############"},"method":"GET","url":"https:\/\/ustcdev.com\/SMS-API\/public\/api\/common\/institute-academic-sessions?institution_id=%24","_Service":"get institute academic sessions","Request":{"time":"2025-03-17 15:20:38","data":{"institution_id":"$"}},"Response":{"time":"2025-03-17 15:20:38","data":{"status":true,"response":[],"message":"Query ok"}},"extra":null}