123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265 |
- const db = require("../services/dbconnection");
- const validation = require("../controllers/validation")
- const config = require("../configs/config.json");
- const moment = require('moment');
- const createToken = require("../middlewares/createToken");
- const logger=require("../utils/logger");
- module.exports.loginUser = async (req, res) => {
- const validationResp = await validation.logindatacheck(req);
- if (validationResp.status) {
- try {
- const query = "select user_id,login_id,first_name,last_name,last_login_date,password from user_master where login_id='" + req.body.username + "' and password='" + req.body.password + "'";
- const result = await db.executequery(query);
- logger.info('log of login api search login user query result', result);
- if (result.length == '0') {
- res.send({
- status: true,
- data: [{
- message: "Invaild User",
- loginStatus: "1",
- logindata: {
- user_id: "",
- user_name: "",
- last_loginDate: ""
- },
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: ""
- })
- }
- else {
- var rolData1;
-
-
- const logindate = moment(new Date()).format("YYYY-MM-DD HH:mm");
- const login_id = result[0].login_id;
- const user_id = result[0].user_id;
- const createdtoken = await createToken.createToken(user_id);
- const findRole = "call SP_roleidentify1('" + login_id + "')";
- console.log("findRole", findRole);
- const roleidentify = await db.executequery(findRole);
- rolData = roleidentify[0];
- if (rolData != undefined) {
- rolData.forEach(function (item) {
- console.log(item.role_des);
- rolData1 = item.role_des;
- });
- console.log(rolData1);
- }
- //console.log("item",item);
- rol_des = rolData1;
- if(rol_des == undefined){
- rol_des="";
- }
- console.log("rol_des",rol_des);
- const query = "update user_master SET last_login_date='" + logindate + "' where login_id='" + login_id + "'";
- const queryresult = await db.executequery(query);
- logger.info('log of login api update user last_login_date query result', queryresult);
- // console.log("queryresult", queryresult);
- if (queryresult) {
- res.send({
- status: true,
- data: [{
- message: "Vaild User",
- loginStatus: "0",
- logindata: {
- user_id: login_id,
- user_name: result[0].first_name + " " + result[0].last_name,
- last_loginDate: result[0].last_login_date,
- role: rol_des
- },
- exception: {
- errorid: "",
- errormessage: "No Errors"
- },
- jwttoken: createdtoken
- }],
- error: ""
- })
- } else {
- res.send({
- status: false,
- data: [{
- message: "Invaild User",
- loginStatus: "1",
- logindata: {
- user_id: "",
- user_name: "",
- last_loginDate: ""
- },
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }]
- })
- }
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- error:err
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.changepassword = async (req, res) => {
- const validationResp = await validation.logindatacheck(req);
- const createdate = moment(new Date()).format("YYYY-MM-DD HH:mm");
- console.log("Before if condition");
- if (validationResp.status) {
- console.log("After if condition")
- try {
- const query = "select login_id, user_id from user_master where login_id= '" + req.body.username + "'";
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- if (queryresult.length > 0) {
- console.log("User present in database allow to change password");
- const query = "update user_master SET updated_on='" + createdate + "', password= '" + req.body.password + "' , updated_by= '" + req.body.username + "' where login_id='" + req.body.username + "'";
- const queryresult = await db.executequery(query);
- console.log("queryresult",queryresult)
- res.send({
- status: true,
- data: [
- {
- status: '0',
- message: "Password updated suceesfully."
- }
- ],
- errors: " "
- })
-
- } else {
- console.log("User not password in datbase");
- res.send({
- status: false,
- data: [{
- message: "Invaild User",
- loginStatus: "1",
- logindata: {
- user_id: "",
- user_name: "",
- last_loginDate: ""
- },
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }]
- })
- }
- } catch (err) {
- console.log(err)
- res.send({
- status: true, data: []
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.userrolemap = async (req, res) => {
- const validationResp = await validation.userrolemapcheck(req);
- const createdate = new Date();
- if (validationResp.status) {
- try {
- const query = "select user_id,login_id from user_master where login_id='" + req.body.login_id + "'";
- const result = await db.executequery(query);
- if (result.length == '0') {
- res.send({
- message: "Invaild User.Please enter valid login creditional!",
- userrolemapStatus: "1",
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- })
- }
- else {
- console.log("valid user", result);
- var login_id, user_id;
- login_id = result[0].login_id;
- console.log("login_id::", login_id);
- user_id = result[0].user_id;
- console.log("user_id::", user_id);
- const query1 = "INSERT INTO user_mapping(user_master_id,user_role_id,created_by,created_on)" +
- " VALUES(?,?,?,?)";
- const values = [user_id, req.body.user_role_id, req.body.login_id, createdate]
- const res2 = await db.executevaluesquery(query1, values);
- console.log("res2", res2);
- if (res2) {
- res.send({
- message: "User Role mapped Successfully. ",
- SingupStatus: "0",
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- })
- } else {
- res.send({
- message: "",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- })
- }
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: []
- })
- }
- } else {
- res.send(validationResp)
- }
- }
|