controller.js

'use strict';

var response = require('./res');
var Connection = require('./connection');

exports.index = function (req, res) {
    response.ok('REST API Executed Properly', res)
};

//showing data from database
exports.tampilsemuadatasiswa = function (req, res) {
    Connection.query('SELECT * FROM mahasiswa', function (error, rows, fields) {
        if (error) {
            console.log(error);
        } else {
            response.ok(rows, res)
        }
    });
}

// Showing all id from database
exports.tampilberdasarkanid = function (req, res) {
    let id = req.params.id;
    Connection.query('SELECT * FROM mahasiswa WHERE id_mahasiswa = ?', [id],
        function (error, rows, fields) {
            if (error) {
                console.log(error);
            } else {
                response.ok(rows, res)
            }
        });
}

//Adding data to database
exports.tambahmahasiswa = function (req, res) {
    var id_mahasiswa = req.body.id_mahasiswa;
    var nim = req.body.nim;
    var nama = req.body.nama;
    var jurusan = req.body.jurusan;

    Connection.query("INSERT INTO mahasiswa (id_mahasiswa,nim,nama,jurusan) VALUES(?,?,?,?)",
        [id_mahasiswa, nim, nama, jurusan],
        function (error, rows, fields) {
            if (error) {
                console.log(error);
            } else {
                response.ok("Added sucsessfuly", res)
            }
        });
}

//Change data from database (update)
exports.ubahMahasiswa = function (req, res) {
    var id = req.body.id_mahasiswa;
    var nim = req.body.nim;
    var nama = req.body.nama;
    var jurusan = req.body.jurusan;

    Connection.query('UPDATE mahasiswa SET nim=?, nama=?, jurusan=? WHERE id_mahasiswa=?', [nim, nama, jurusan, id],
        function (error, rows, fields) {
            if (error) {
                console.log(error);
            } else {
                response.ok("Changed Succsessfuly", res)
            }
        });

}

//Delete data From database based on id
exports.hapusMahasiswa = function (req, res) {
    var id = req.body.id_mahasiswa;
    Connection.query('DELETE FROM mahasiswa WHERE id_mahasiswa=?', [id],
        function (error, rows, fields) {
            if (error) {
                console.log(error);
            } else {
                response.ok("Deleted Succsessfuly", res)
            }
        });
}

//showing matakuliah group
exports.tampilgroupmatakuliah = function (req, res) {
    Connection.query('SELECT mahasiswa.id_mahasiswa,mahasiswa.nim,mahasiswa.nama,mahasiswa.jurusan,matakuliah.matakuliah,matakuliah.sks FROM krs JOIN matakuliah JOIN mahasiswa WHERE krs.id_matakuliah = matakuliah.id_matakuliah AND krs.id_mahasiswa = mahasiswa.id_mahasiswa ORDER BY mahasiswa.id_mahasiswa',
        function (error, rows, fields) {
            if (error) {
                console.log(error);
            } else {
                response.oknested(rows, res);
            }

        }
    )

}