fusioniiit/fusion

Currently merged : Ac-1 Ac-2 Ac-3 Ac-5 Ac-7 Os-1 Os-2 Os-3 Gad-1 Gad-2 Gad-6 Gad-7

fusion's Issues

Create Models - To be migrated

Group 12 AC-1 db_schema

Added a new table "AddCourse" in the database schema

Add jsonfield version specification in requirements

Error while running on local server-
Internal Server Error: /dashboard/ Traceback (most recent call last): File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\core\handlers\exception.py", line 41, in inner response = get_response(request) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\core\handlers\base.py", line 187, in _get_response response = self.process_exception_by_middleware(e, request) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\core\handlers\base.py", line 185, in _get_response response = wrapped_callback(request, *callback_args, **callback_kwargs) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\contrib\auth\decorators.py", line 23, in _wrapped_view return view_func(request, *args, **kwargs) File "C:\Users\Saumya\Downloads\Fusion\FusionIIIT\applications\globals\views.py", line 712, in dashboard return render(request, "dashboard/dashboard.html", context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\shortcuts.py", line 30, in render content = loader.render_to_string(template_name, context, request, using=using) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader.py", line 68, in render_to_string return template.render(context, request) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\backends\django.py", line 66, in render return self.template.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 207, in render return self._render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader_tags.py", line 177, in render return compiled_parent._render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader_tags.py", line 72, in render result = block.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader_tags.py", line 216, in render return template.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 209, in render return self._render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\test\utils.py", line 107, in instrumented_test_render return self.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\loader_tags.py", line 63, in render result = self.nodelist.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 990, in render bit = node.render_annotated(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\base.py", line 957, in render_annotated return self.render(context) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\template\defaulttags.py", line 173, in render len_values = len(values) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\db\models\query.py", line 232, in __len__ self._fetch_all() File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\db\models\query.py", line 1121, in _fetch_all self._result_cache = list(self._iterable_class(self)) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\db\models\query.py", line 62, in __iter__ for row in compiler.results_iter(results): File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\db\models\sql\compiler.py", line 847, in results_iter row = self.apply_converters(row, converters) File "C:\Users\Saumya\Downloads\Fusion\env\lib\site-packages\django\db\models\sql\compiler.py", line 832, in apply_converters value = converter(value, expression, self.connection, self.query.context) TypeError: from_db_value() takes 4 positional arguments but 5 were given

Alternative use pip install jsonfield==2.1.1
Or add jsonfield == 2.1.1 in requirements.txt

Group 21 Counselling Cell module UI Design and Database Schema

Counselling cell.pdf

Group #20, HA-1 Hostel Management Module, DB Schema

Group #17 Programme & Curriculum Module Database Schema

For our Programme & Curriculum module, we designed the following database schema.
Every COURSE belongs to a particular SEMESTER (or different semesters of other programmes), and every SEMESTER belongs to a particular CURRICULUM, and a CURRICULUM to a particular PROGRAMME. It is also required (by Dr.Atul Gupta) that Acadmic_Incharge should always able to see a history of past COURSES / SEMESTERS / CURRICULUMS / PROGRAMMES offered by the Institute.
Keeping these in mind, we designed this👇.

Complaint Module

Issues related to the Complaint Module

Central Mess Module

All the issues related to the Central Mess module

Please number the issues properly so that we can refer them while discussing to resolve the issues.

• 1. Cannot open "/mess".
  

Group-1 HR-1(LTC, CPDA, and Appraisal) Database Schema

The Database schema consists of the appraisal database records. Our module HR-1 consists of the LTC, CPDA, and Appraisal forms out of which the first two have been implemented.
For the appraisal implementation, we’ve identified the requirement of the records as shown below.

Group-4 income_expenditure UI Design

Group-4 Income and Expenditure UI Design

---

Three main core landing pages of the module's UI design are give below:

Income Landing Page

---

Details that are required to be filled :

• Selecting the income source from the dropdown list.
• Enter the amount granted or received through the mentioned Source.
• Mention the date of transaction or date received according to the convenience.
• Choose a receipt file if applicable or available.
• Add information regarding the details of how the money was received or granted.

Other Functionalities:

• By clicking on view history tab user can access the data which has been added previously.
• Add income source tab is used to add a new income source to the drop-down list.

Expenditure Landing Page

---

Details that are to be filled:

• Selecting the expenditure type from the dropdown list.
• Enter the amount spent on the mentioned type.
• Mention the date of transaction or date spent according to the convenience.
• Choose a receipt file if applicable or available.
• Add information regarding the details of to whom/what the money was spent or granted.

Other Functionalities:

• By clicking on view history tab user can access the data which has been added previously.
• Add Expenditure type tab is used to add a new expenditure type to the drop-down list.

View Stats and Download Balance Sheet :

---

Details to be filled:

• User is required to give the financial year for which he wanted stats or balance sheet
• On selecting the financial year from the dropdown the data gets processed and some pictorial summary of the financials come up for easy understanding.
• Download balance sheet tab helps to combine and process data into a balance sheet and will be downloaded.

Bugs and hardcoded values

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 790 in 910f9f8

temp = HoldsDesignation.objects.all().select_related().filter(designation = desig_id).first()

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 818 in 910f9f8

total_cse_seats = 100

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 819 in 910f9f8

total_ece_seats = 100

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 820 in 910f9f8

total_me_seats = 100

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 822 in 910f9f8

total_cse_filled_seats = 98

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 823 in 910f9f8

total_ece_filled_seats = 98

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 824 in 910f9f8

total_me_filled_seats = 98

Register model has no field with name 'r_id'

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 1202 in 910f9f8

r_id=last_id,

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 680 in 910f9f8

Register.objects.filter(r_id=rid).delete()

Group-1 HR-1(LTC, CPDA, and Appraisal) UI Design

Note: The UI designs are similar in most cases for Ltc, Cpda, and Appraisal.
We have created those designs which are different/unique and omitted some which are increasingly similar.
For some of the designs that are similar for the three forms, we've created one of the three designs to serve as an example for all three.

Actors

User

Cpda_user

Ltc_user

Appraisal User

Admin

Admin_appraisal

Admin_cpda

Admin_ltc

Assistant Registrar

Director

Group 2; HR-2(Employee Record, Joining, Leaving, Foreign Service, e-Service Book) ; UI design

Note: The UI designs contains the form for the employee to fill in all required details and submit it for review to the HR manager.
There is a status tab to check the status of the application and for an HR manager, there is the section to view pending applications and to review them and other section for reviewed applications.

Employee

HR Manager

DB Schema

Card 2

Function not used anywhere

This function is neither used in any view nor used in any urls

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 873 in 910f9f8

def phd_details(request):

Group #16 Academic Module

PhD students fill the Phd progress report form.
MTech student fills the MTech Seminar Report Form, All PhD and M tech students fill the assistantship claim form, concerned faculty reviews the M.Tech Seminar Form and PhD progress report.
Thesis and TA Supervisor review the Assistantship Claim Form.

Group #4 Income and Expenditure Module db_schema

PFA Database schema of income and expenditure module

final schema.pdf

Grp#22 Alumni Module UI Design

Grp#22 Alumni-module UI Design.pdf

Department Module

• 1. Profile card and content card can leak data in smaller windows as responsiveness is not implemented.
  

• 2. Faculty's personal details has not been updated and has some data inconsistency.
  

• 3. Back button provided in the student list may run in a loop due to internal logic issues.
  

• 4. Student list as well as their individual personal details has not been updated.
  

• 5. CSE department's content card has different margin specifications than the others, creating an exception in the default UI flow.
  

• 6.Top navigation bar is not responsive with the screen width.
  

Branch change flag is always true

Needs to be updated here.

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 199 in 17f0642

branchchange_flag=True # True for testing, to be initialised as False

Holds Designations delete error

Getting this error while deleting an entry from the holds designation table : ( here: from the admin panel kindly check )

Group #17 Programme & Curriculum Module Database Schema UI Design

We shall add more on these in the coming days👍

Group 9 RS-2 Procedures UI design

GROUP 9 - RS-2 PROCEDURES UI DESIGN.pdf

UI/UX designing (Login+Gymkhana Module)-

Hakim Singh

Academic Procedure Module (Issue#1)

Group 8 Rsc Activities

Ui_Rsc_II.pdf

Group 12 AC-1 UI Design

AC1.pdf

Datetime object provided as default value for date field

It should be date = models.DateField(default=timezone.now().date)

Fusion/FusionIIIT/applications/academic_procedures/models.py

Line 184 in 910f9f8

date = models.DateField(default=datetime.datetime.now)

Code optimization

card2

Jquery cdn

Jquery cdn is used in the modules and it doesn't work without internet.
Kindly download it and use it from globals or suggest an alternative.

Gymkhana Module

There are two more issues in this Gymkhana module. They are:

1. In the divison of member records, when we are interested in serching for records of a particular club with the dropdown menu, we are unable to get the data with single click, as it is taking two clicks to get the data except for the club "Saaz".
2. The second issue is when we click on any club except saaz its blank but once we click on saaz club, we are able to see record of one person, after that if we select any other club, the records of only "Saaz" was appearing as shown in the screenshot.

RS2

Cards can be added to your board to track the progress of issues and pull requests. You can also add note cards, like this one!

Redundant and breaking requirements

Why is there a requirement to pywin32 ?

Fusion/requirements.txt

Line 44 in f321736

pywin32==224

Fusion is primarily targeting a Linux environment, and trying to be cross-platform, why was this dependency added ?

This requirement also causes errors. Removing it doesn't seem to break anything. Why was this added ?

Fusion/requirements.txt

Line 34 in f321736

mysqlclient==1.3.12

@rohit427

Group-5 PS-1 Purchase and Store module UI design

Group-5

                            Group Members :-
                                                     Deepak Singh      (2018325)                         
                                                     Shubham Rajani  (2018239)
                                                     Suyash Khare      (2018257)
                                                     Pampati Varshith (2018346)

Module- PS1 (Purchase and Store)
Source file for UI design - UI (PS1 module).pdf

USER INTERFACE DESIGN

Details of item that are required to be filled :

• Name of the Item/Equipment needed
• Specification and Purpose of item
• Quantity needed and Estimated Cost of item
• Current reserved stock of that item
• Type and nature of equipment/item
• Possible sources where that item will be available with good quality in decent price
• Whether item available indegenously or to be imported

Senders and receivers details to be required :

• Name of the indenter
• Designation and Dept./Section of indenter(sender)
• ID of Dept./Section Head(receiver)
• Designation of receiver

Approver/Purchase Officer GUI:
Below is the UI of approver(HEAD/DIRECTOR) who will be responsible for approval of application

Approver will be able to view all the received indents in the
inbox section with proper details as shown above.

Approver can either accept or reject an application and can give remarks accordingly in the Remark field.

Finally the approver sents the accepted information to purchase officer

Dealing Assistant
Stock Entry of the items received.
Finally the bills will be processed.

Register model has no field with name 'r_id'

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 680 in 910f9f8

Register.objects.filter(r_id=rid).delete()

/media has tons of irrelevant media

I've added the directory to .gitignore to prevent further damage.
Please confirm if the directory has any useful data, otherwise, it would be purged from git (it won't be deleted from your local repo, it only needs to be untracked).

Function not working

This function is full of bugs and unnecessary code.

Fusion/FusionIIIT/applications/academic_procedures/views.py

Line 687 in 910f9f8

def verify_course(request):

Bug while adding skill in profile

When trying to add a skill with a name that is already present, intergrity error is thrown because a skill with that name and user id already exists. It can be corrected by adding a try except statement while creating the Has object for the user.

Bug with display of File in File Tracking System

The file uploaded in File model is not displayed anywhere but only the file uploaded in Tracking model is displayed.

The original file should be available at all times and the file field in Tracking model is for follow-up and not for containing the original file so the original file should not be saved in the Tracking model while sending the file for the first time. This specifically creates a problem when the file is initially saved as draft and then forwarded to the recipient after some time. If the same file is not uploaded again while forwarding the draft, no file is displayed to the user to whom it has been sent.

card1

Migrations for 'gymkhana' module

Observed Behaviour

Currently, even if you haven't changed the models for gymkhana module, still on makemigrations new migrations are created.

Expected Behaviour

If there is no change in the models, no migrations should be made.

Steps to reproduce the problem

Run(multiple times) python manage.py makemigrations

Gymkhana Module

In the module Gymkhana, the dropdown menu in club sessions and member records weren't getting closed when we click outside the divison as shown in the photos. But whereas in the apply divison, the dropdown menu was perfect and functionality was a bit different.

Group-8 Research(RS1)

Refactor File Tracking System code

There is a dire need to refactor the code written in File Tracking System.

• You should pass only that information to the context which is being used in the pages (and not the complete table).
• Use of proper variable names should be made.
• Remove all the useless comments and print statements. Those are meant for development purpose only and not for production.
• Proper coding practices should be followed in terms of indentations, newlines, maximum characters in a line, etc.
• Proper docstrings should be used at the start of each view explaining briefly what the view does.

This issue can be worked upon in a team where different people can refactor different views.

File which needs to be refactored: applications/filetracking/views.py.

Group #20, HA-1 Hostel Management Module, UI Design

We have made UI for some use-case, and we are working on other use cases, please find the attachment.
HostelManagementModuleUI.pdf

Group-5 PS-1 Purchase and Store module DB schema

Group-5

Group Members :-
Deepak Singh (2018325)
Shubham Rajani (2018239)
Suyash Khare (2018257)
Pampati Varshith (2018346)

Module - PS1 (Purchase and store)
DB schema source file - DB schema (1).pdf

Compile time warning in Gymkhana Module

We have a trivial compile-time warning in Gymkhana Module likely after #182

Fusion\FusionIIIT\applications\gymkhana\views.py:205: SyntaxWarning: "is not" with a literal. Did you mean "!="?
  if current_value is not "":

@zackaman request a fix with your next PR

Group 9 RS-2 Procedures Database_schema

database_schema(rs-2 procedures).pdf