search

zak-hassan / WhoTeachsWhat

JBoss JSP Application for Data Management
0 stars 0 forks source link

Regarding the swift report #143

Closed ghost closed 10 years ago

ghost commented 10 years ago

I just wanted to make sure you are aware of the FacultyToCourseInSemesterYear page/table.

CREATE TABLE IF NOT EXISTS mydb.FacultyToCourseInSemesterYear ( cisy_id INT NOT NULL , faculty_id INT NOT NULL , course_id INT NOT NULL , prepType_id INT NOT NULL , addition_attribute FLOAT NOT NULL , compHour_id INT NOT NULL , compHour_allowance FLOAT NOT NULL , compHour_assigned FLOAT NOT NULL , section_number INT NOT NULL , year INT NOT NULL , semester_id INT NOT NULL , eval_1 INT NOT NULL , eval_2 INT NOT NULL , eval_3 INT NOT NULL , eval_1_ans FLOAT NOT NULL , eval_2_ans FLOAT NOT NULL , eval_3_ans FLOAT NOT NULL , factor_id INT NOT NULL ,

This table/page has most of the information needed for a swift report. If you filtered by semester, and faculty, you pretty much have the report.

The only fields it is missing is..

class_size from what I can see.

Hope this helps.

zak-hassan commented 10 years ago

HI Anil,

I setup the backend to integrate with UI. I also made a html page similiar to how the swift will look. I will be passing an object into the UI. Can you do a forEach loop and review this. This is basically the reason why marylynn has us working on this.

To generate this report:

See this page after you pull the latest code.

http://localhost:8080/WhoteachswhatJPA/facultyswiftreport?id=1

ghost commented 10 years ago

This will take a while as I have to update the AJAX with the new controllers.

zak-hassan commented 10 years ago

Hey Anil,

I pushed in the webservice code to generate the swift:

http://localhost:8080/WhoteachswhatJPA/api/facultyswiftreport?id=1&semester=1&year=1

ghost commented 10 years ago

Okay. I will take a look at it.

zak-hassan commented 10 years ago

I'm gonna work on this late through the night so if you want I can push everything up by like 1am I don't think he will really check. I will send an email asking for an extension to this deadline.

Thanks, Zak

On Sun, Apr 6, 2014 at 11:31 PM, Anil Santokhi notifications@github.comwrote:

Okay. I will take a look at it.

Reply to this email directly or view it on GitHubhttps://github.com/zmhassan/WhoTeachsWhat/issues/143#issuecomment-39693603 .

ghost commented 10 years ago

Let's aim for midnight for now. I'm sure he has a pretty easy way to check. Let's keep working though.

zak-hassan commented 10 years ago

Yea he could look at the logs on the server. Yea he could check but I sent him an email which I think is reasonable.

On Sun, Apr 6, 2014 at 11:40 PM, Anil Santokhi notifications@github.comwrote:

Let's aim for midnight for now. I'm sure he has a pretty easy way to check. Let's keep working though.

Reply to this email directly or view it on GitHubhttps://github.com/zmhassan/WhoTeachsWhat/issues/143#issuecomment-39693902 .

ghost commented 10 years ago

The suggestion has been integrated into the swiftreport model class. This issue is no longer relevant.