// ! Support file only, run Schools.html instead !
//. This file is used as both data url and SaveUrl
//. Generates data by get() function, updates changes, by set() function, adds new users by add() function, reads reviews by getratings() function and saves one review back to database by setreview() function
// -----------------------------------------------------------------------------------------------------------------------------
//. Reads data from database and returns them in JSON
function get(req,res){
var sql = require('better-sqlite3'), db = new sql('SQLite.db'); //. It uses SQLite3 database engine on database in file SQLite.sb
var qstr = require('querystring'), body = "";
req.on('data',function(data){ body += data.toString(); });
req.on('end', function(){
var P = qstr.parse(body);
var User = P.User ? P.User.toLowerCase() : "", NewUser = P.New!=null && P.New!="0"; //. Input parameters initalization
var s = "FGrid.Data = {\n";
//. --- Adding new user ---
if(NewUser){
var rows = db.prepare("SELECT Pass FROM Schools_Users WHERE Name='" + User.replace(/'/g,"''") + "'").all();
if(!rows.length){ //. Ok, possible
db.prepare("INSERT INTO Schools_Users(Name,Pass) VALUES ('" + User.replace(/'/g,"''") + "','" + (P.Pass||"").replace(/'/g,"''") + "')").run();
s += "IO:{Message:'User " + User.replace(/\\/g,"\\\\").replace(/'/g,"\\'") + " has been added successfuly'},";
}
else { end(s+"IO:{Result:-1,Message:'User name already exists !'}}",res); return; }
}
//. --- Password verification ---
if(User){
var rows = db.prepare("SELECT Pass FROM Schools_Users WHERE Name='" + User.replace(/'/g,"''") + "'").all();
if(!rows.length || P.Pass!=rows[0].Pass){ end(s+"IO:{Result:-1,Message:'Wrong user name or password !'}}",res); return; }
}
var Admin = User=="admin"; // @@@ Or change this code to another admin
//. --- Read data ---
if(!User) s += "Cfg:{AddingRows:0,DeletingRows:0,Editing:0},Cols:[{id:'CPanel',Hidden:1}],";
else s += "RightCols:[{id:'CButton',Hidden:1}],";
if(!Admin) s += "RightCols:[{id:'CUser',Hidden:1,NoHide:1,NoPrint:1,NoExport:1}],";
s += "\nBody:[\n";
var SQL = "SELECT * FROM Schools_Schools"; if(User && !Admin) SQL += " WHERE Owner='" + User.replace(/'/g,"''") + "'";
var rows = db.prepare(SQL).all();
for(var i=0;i