yungifez / skuul Goto Github PK

I keep getting this error when I run npm run build or npm run dev

and the website displays:

Vite manifest not found at: /home/thebhcqm/portal2.thebadracademy.com.ng/public/build/manifest.json

Im no too techy on this, I will appreciate step by step guidline, Thank you!

Describe the bug
So, I've finally managed after lots of back and forth to get Skuul running on my system, great. The issue is that now, I want to login wit the super admin credentials of "[email protected]" and "password", buuuut it doesn't work for some reason. I get the following error:

Any solution? I checked my MySQL database, and the necessary entries are there. But in the "users" section, there's no users at all.

Can I get the login details for the demo?

It is more deductive to rename the column countries.region to countries.continent.
The country.subregion does make generic sense and can be kept as it is.

laravel/framework#33018

This can be useful on registration to prevent issues like

This might however make testing a little bit more difficult but ensures non existent emails cannot sign up

How this went unnoticed is kinda scary, check out the tests too to know why they still pass successfully

Student admission field has a typo in place holder

These properties are declared dynamically. Just a heads up in case you want to get ahead of this.

https://github.com/yungifez/schooldash/blob/147eb9fd644ccc1d8a52e6c88e67e596f7f1d4fa/app/Http/Livewire/ListTimetablesTable.php#L28-L30

Here is a link to the RFC:

https://wiki.php.net/rfc/deprecate_dynamic_properties

I'm getting this error when executing this command:

php artisan migrate

 Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:742
    738▕         // If an exception occurs when attempting to run a query, we'll format the error
    739▕         // message to include the bindings with SQL, which will make this exception a
    740▕         // lot more helpful to the developer instead of just the database's errors.
    741▕         catch (Exception $e) {
  ➜ 742▕             throw new QueryException(
    743▕                 $query, $this->prepareBindings($bindings), $e
    744▕             );
    745▕         }
    746▕     }

      +36 vendor frames 
  37  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

I have tried both
Password & helloworld
With [email protected] & admin

I didn't see student attendance that is very important for a school

There are many instances where the type and name of the parameters don't coincide (@param int $id 31 times).

https://github.com/yungifez/schooldash/blob/ffa14abc2feaf51fd6fbc0dcbcb794846c2bc942/app/Http/Controllers/AcademicYearController.php#L58-L62

In this case the casing of the parameters in the docblocks and the parameters in the method is different:

https://github.com/yungifez/schooldash/blob/ffa14abc2feaf51fd6fbc0dcbcb794846c2bc942/app/Services/User/UserService.php#L100-L108

My question is, are you using the docblocks? or are they just automatically generated.

Would you accept a PR fixing or deleting them?

Hi @yungifez,

The Nationality and States are not populating in the dropdown. I ran php artisan db:seed --class=WorldSeeder and re-run the application. In database we ave the records.

Is your feature request related to a problem? Please describe.
Suggestion 1:
A note section.

Suggestion 2:
A finances section.

Suggestion 3:
A books section.

Suggestion 4:
Default nation/country (or other default values) when creating a profile, and the ability to skip certain required fields.

Suggestion 5:
A "blog/feed" sort-of function for each class/student.

Describe the solution you'd like
Suggestion 1:
It would be great having the ability to add notes to teachers/students, both visible to them and private ones only visible to administration. For example, a note about x student that they come 15 minutes late every day, or whatever. Just the ability to create custom notes for and on any individual. Students can create notes for themselves, teachers for themselves and their students, and administration for everyone. Teachers can set the notes to be visible for either both student and teachers/administration, or only teachers/administration. And administration can set notes to only be visible/editable by administration, and teachers/administration. This section would help immensely with building the next two suggestions.

Suggestion 2:
A finance section, which functions similar to the notes section, but is displayed on the student's/parent's/teacher's profile with a total sum of what is owed, calculated by what has been added in the finance section. Let's say, a student buys a book or other materials. These are added in the finance section under new entries for each material, and a sum of said material (currency can be chosen/set, with a default currency that can be set in the settings of administration). This would make it so that parents or students have a way of seeing their total, and also where to pay it to (for example adding below said owed value a section with bank information, QR code, or other payment methods that can be added by administration with a custom note below their total sum).

Suggestion 3:
A way to add books, their cover images and names and price, and to then add these to students with a toggle for paid or unpaid. These can then be added to students individually to see which books they currently are using (maybe even a sub-section for each book with chapters to mark progress, but it isn't a requirement), that would be useful for seeing their curriculum progress and also to see if they have paid for a book yet or not. And once a book has been finished, a way to mark it as "Complete", which makes it grey out in the list/grid, and active ones are of course not greyed out.

Suggestion 4:
This one would help with selection really, because starting from "Afghanistan" or such is kind of annoying, as all we really need is a default set. It's fine having the ability to choose country, province, city, but there should be a default set system-wide (same goes for other values as well). Also, the ability to not fill in irrelevant stuff such as blood-type, religious belief, etc. would also be massively appreciated. Last but not least, the ability to not enter Email/Password when making a student profile would be beneficial so that it can be used for administrative purposes, because not every student will use the system or needs to use it, it is only being used to keep track of their information and curriculum. However, with Suggestion 5, it might be used for more than so.

Suggestion 5:
A "blog/feed" sort-of function for each class and/or student. Basically, when students or parents login to their accounts, on their dashboard, they see a "feed", kind of like Facebook feed, where they see posts by x teacher, with x content (today's homework, a link to materials, etc.). They see their class content maybe on one side (left side with their class feed), and personal notes on the opposite (personal notes left by teachers, maybe on the right side of their dashboard). This would make it so students have a reason to come to use the system as well, expanding the userbase, seeing their details, feed with class content and personal notes, their fees, book progress, etc.

when i login as super admin and admin it's working, but when i login as teacher and student it's showing error

User
Found the following N+1 queries in this request:

Model: App\Models\School => Relation: App\Models\ClassGroup - You should add "with('App\Models\MyClass')" to eager-load this relation.
Model: App\Models\School => Relation: myClasses - You should add "with('myClasses')" to eager-load this relation.
Model: App\Models\MyClass => Relation: App\Models\Subject - You should add "with('App\Models\Subject')" to eager-load this relation.
Model: App\Models\MyClass => Relation: App\Models\Section - You should add "with('App\Models\Section')" to eager-load this relation.

https://github.com/yungifez/schooldash/blob/7acc5f25b13fb5b638685a2eb8597f664090f070/app/Models/ClassGroup.php#L23

Probably should be MyClass.

The approval of users isn't giving options to accept or reject users or applicants

  2022_09_02_141457_correct_unique_key_in_subjects_table ......................................................................... 3ms FAIL

   Illuminate\Database\QueryException 

  SQLSTATE[42704]: Undefined object: 7 ERROR:  index "subjects_name_school_id_index" does not exist (SQL: drop index "subjects_name_school_id_index")

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:760
    756▕         // If an exception occurs when attempting to run a query, we'll format the error
    757▕         // message to include the bindings with SQL, which will make this exception a
    758▕         // lot more helpful to the developer instead of just the database's errors.
    759▕         catch (Exception $e) {
  ➜ 760▕             throw new QueryException(
    761▕                 $query, $this->prepareBindings($bindings), $e
    762▕             );
    763▕         }
    764▕     }

      +9 vendor frames 
  10  database/migrations/2022_09_02_141457_correct_unique_key_in_subjects_table.php:15
      Illuminate\Support\Facades\Facade::__callStatic()

      +37 vendor frames 
  48  artisan:37

this is one of the errors. I think it depends on your migration structure.

This project got complicated quickly so I haven't had a lot of time to fix grammar issues, if you happen to stumble on any grammar issues, you can comment it down here.

Thanks

Hello
If you can add an option to the configuration section, by activating it, the database type will be internal
And if we give it an off value, the data storage location will be changed to database amazon

In general, my applying for is to use our own hosting spaces to store the files and not have the trouble of accessing the apis of the storage location.

Thankful

Add rest api so that we can access it from other platform like Android or iOS apps

The country_code attribute already exists as the country.iso2 column and can be easily extracted with following SQL query

select * from countries join  states on countries.id = states.country_id where countries.iso2 <> "AF";

No need to denormalize the states table…

Description

When finishing the installation steps I tried to register a new account. And I received 8 validation messages/errors containing: "validation.required".

Screenshots

Files

No relevant files.

To Reproduce

Enter homepage, change url to /register.
Entered the following values for name, email and password respectively:

• root
• [email protected]
• root1234

Hi,
when trying to create the student, got the error
Undefined array key 0

    public function offsetGet($key): mixed

    {

        return $this->items[$key];

    }

do you've any idea, how can I solve the issue?

thanks

One student can study in many schools.

CREATE TABLE IF NOT EXISTS `skuul`.`users_schools` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `users_id` BIGINT UNSIGNED NOT NULL,
  `schools_id` BIGINT UNSIGNED NOT NULL,
  INDEX `fk_users_has_schools_schools1_idx` (`schools_id` ASC) VISIBLE,
  INDEX `fk_users_has_schools_users1_idx` (`users_id` ASC) VISIBLE,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_users_has_schools_users1`
    FOREIGN KEY (`users_id`)
    REFERENCES `skuul`.`users` (`id`)
    ON DELETE cascade
    ON UPDATE cascade,
  CONSTRAINT `fk_users_has_schools_schools1`
    FOREIGN KEY (`schools_id`)
    REFERENCES `skuul`.`schools` (`id`)
    ON DELETE cascade
    ON UPDATE cascade)

SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'timetable_time_slot_weekday_timetable_time_slot_weekdayable_id_foreign' is too long (Connection: mysql, SQL: alter table timetable_time_slot_weekday add constraint timetable_time_slot_weekday_timetable_time_slot_weekdayable_id_foreign foreign key (timetable_time_slot_weekdayable_id) references timetable_time_slot_weekdayables (id) on delete cascade on update cascade)

Actually above is second error, First error was column renaming, timetable_time_slot_weekday on this table, column renaming from subject_id to timetable_time_slot_weekdayable_id. Error said: key is required for foreign key and can not be renamed.
I solved that by alterting table migration,
After that above was second error.

To Reproduce
Steps to reproduce the behavior:

1. AFter completeing setup process, just start migration and you get error

Device:
Windows 10
Laragon
PHP 8.2
Apache