Define DB/ Datasource

[john20xdoe]

Define datasource

• Define datasource (JSON served by existing MIS?)
• Create new database?
  • define domain models (i.e. entities)

[lamerock]

For login:

Select * from kioskuser u where u.studid = '$userName' and u.password ='$userPass'

For setting the cookies and sessions

Select p.studfname, p.studmname, p.studlname from studpersonalinfotbl p where studid = '$userRef'

For Student's grades"

SELECT o.syear, o.semno, c.subjname, c.subjtitle, s.subjfgrade, s.subjcomp, s.creditearned FROM studidsubjid s, subjcodtbl c, subjectsoffered o where studid = '$studID' and s.subjid = o.subjectid and o.subjectcode = c.subjcod order by o.syear, o.semno

For Student's Payment:

Select studid, sy, term, fund, account, round(amount,2) as amount from tblstudappraisal where studid = '$studID' order by sy, term, fund, account

[john20xdoe]

Nice sir, iupdate ko ja sa code later

[john20xdoe]

We have a mock database at

Server: us-cdbr-iron-east-04.cleardb.net 
User: bb05a115f1d478 
Password: (can be provided by direct message)
Database name: heroku_61da0b5d0ab399av

[lamerock]

I'm still using the old code on the website. However, I tested the master branch locally and it works fine. I will upload the latest update later since the website is currently down.