1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476 |
- const db = require("../services/dbconnection");
- const validation = require("../controllers/validation")
- const moment = require("moment");
- const logger = require('../utils/logger');
- module.exports.createContactEntry = async (req, res) => {
- const validationResp = await validation.createContactentrycheck(req);
- const createdate = new Date();
- if (validationResp.status) {
- try {
- var stage_id;
- if (req.body.email_id == null || req.body.mobile_no == null) {
- //|| req.body.department == null || req.body.designation == null) {
- stage_id = 2;
- console.log(stage_id);
- } else {
- stage_id = 1;
- }
- const query = "INSERT INTO contact_master(first_name,last_name,mobile_number,email_id,designation,department,function_area,created_by,created_on,customer_id,stage_id)" +
- "VALUES(?,?,?,?,?,?,?,?,?,?,?)";
- const values = [req.body.first_name, req.body.last_name, req.body.mobile_no, req.body.email_id, req.body.designation, req.body.department, req.body.function, req.body.created_by, createdate, req.body.contact_for, stage_id]
- const res1 = await db.executevaluesquery(query, values);
- logger.info('log to file', res);
- if (res1) {
- const query = "select contact_id,customer_id,first_name,last_name from contact_master order by contact_id desc limit 1";
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- res.send({
- status: true,
- data: [{
- message: "Contact Entry created Successfully ",
- createStatus: "0",
- lastinsertedData: queryresult[0].first_name + " " + queryresult[0].last_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [{
- message: "",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: err
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.getdvrDetails = async (req, res) => {
- console.log("in dvr details for one id");
- const validationResp = await validation.getdvrDetailscheck(req);
- if (validationResp.status) {
- try {
- const query = "SELECT d.dvr_id,d.date_of_visit,d.customer_name,d.contact_name,d.physical_meeting,d.message,s.stage_desc,d.stage_id,d.created_on FROM dvr_report d JOIN stage_master s ON d.stage_id=s.stage_id WHERE d.dvr_id = '" + req.query.dvrid + "' and d.delete_id = 0";
- console.log("query", query)
- const queryresult = await db.executequery(query);
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [
- {
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- visit_date: queryresult[0].date_of_visit,
- customer_name: queryresult[0].customer_name,
- contact_name: queryresult[0].contact_name,
- mesasge: queryresult[0].message,
- physical_metting: queryresult[0].physical_meeting,
- stage_desc: queryresult[0].stage_desc,
- stage_id: queryresult[0].stage_id,
- created_on: queryresult[0].created_on
- }
- ],
- errors: ""
- })
- } else {
- res.send({
- status: false,
- data: [
- {
- getdvrDataStatus: '1',
- mesasge: "Data not Found"
- }
- ],
- errors: ""
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: []
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.getselectionData = async (req, res) => {
- try {
- var customerData = [];
- var contactData = [];
- var stageData = [];
- const query = "SELECT customer_id,customer_name FROM customer_master";
- const queryresult = await db.executequery(query);
- if (queryresult.length > 0) {
- for (var i = 0; i < queryresult.length; i++) {
- customerData.push(queryresult[i])
- }
- }
- const query1 = "SELECT contact_id,first_name,last_name FROM contact_master";
- const queryresult1 = await db.executequery(query1);
- if (queryresult1.length > 0) {
- for (var i = 0; i < queryresult1.length; i++) {
- contactData.push(queryresult1[i])
- }
- }
- const query2 = "SELECT stage_id,stage_desc FROM stage_master";
- const queryresult2 = await db.executequery(query2);
- if (queryresult2.length > 0) {
- for (var i = 0; i < queryresult2.length; i++) {
- stageData.push(queryresult2[i])
- }
- }
- res.send({
- status: true,
- data: [{
- customerData: customerData
- }, {
- contactData: contactData
- }, {
- stageData: stageData
- }
- ],
- error: ""
- })
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: [], error: err
- })
- }
- }
- module.exports.getdashboarddetails = async (req, res) => {
- try {
- var login_id = req.query.login_id;
- var sale_person = req.query.salePerson;
- var customer = req.query.customer;
- var customer_id = req.query.customerid;
- var rol_des;
- var dvrlist = [];
- var rolData;
- var rolData1;
- var dates, firstdate, seconddate;
- var user_id_for_mapp;
- var emai_id;
- const findRole = "call SP_roleidentify1('" + login_id + "')";
- const roleidentify = await db.executequery(findRole);
- rolData = roleidentify[0];
- console.log("findRole", findRole);
- rolData.forEach(function (item) {
- console.log(item.role_des);
- rolData1 = item.role_des;
- user_id_for_mapp = item.user_id11;
- });
- //console.log("item",item);
- rol_des = rolData1;
- console.log("user_id_for_mapp", user_id_for_mapp)
- if (rol_des == 'admin') {
- //admin
- console.log("req.query.searchfiltertype", req.query.searchfiltertype);
- if (req.query.searchfiltertype) {
- if (req.query.searchfiltertype.length > 1) {
- //date seach filter
- console.log("in ifffffffffffffffffffffffffffff");
- var searchfilter = req.query.searchfiltertype;
- console.log("searchfilter", searchfilter);
- if (searchfilter == "undefineddate") {
- console.log("date not pass");
- firstdate = '';
- seconddate = '';
- } else {
- dates = searchfilter.split("-");
- console.log("dates", dates)
- firstdate = dates[0] + ' 00:00:00';
- seconddate = dates[1] + ' 23:59:59';
- }
- var querydvr;
- var countquery;
- console.log("firstdate", firstdate);
- console.log("seconddate", seconddate);
- console.log("ooooooooooooo", sale_person);
- if (sale_person != undefined && sale_person != 'undefined' && sale_person != 'all') {
- var data = sale_person.split(" ");
- console.log("data----->", data)
- console.log("need to find sale person email id for cound data");
- var query = "select user_id,login_id from user_master where first_name like '%" + data[0] + "%' and last_name like '%" + data[1] + "%'";
- const res_user = await db.executequery(query);
- console.log("res_user", res_user);
- console.log("res_user----------->", res_user[0].login_id)
- emai_id = res_user[0].login_id;
- }
- console.log("customer", customer, "customer_id", customer_id, " email_id-->", emai_id);
- if (sale_person != undefined && customer == undefined && searchfilter == 'undefineddate' && sale_person != 'all') {
- console.log("only for sale_person");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + '' + "','" + '' + "')";
- } else if (sale_person == undefined && customer != undefined && searchfilter == 'undefineddate' && sale_person != 'all' && customer != 'all') {
- console.log("only for customer");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where customer_name like '%" + customer + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + customer + "','" + customer_id + "')";
- } else if (sale_person != undefined && customer != undefined && customer_id != undefined && sale_person != 'all') {
- console.log("for sales_person and Customer");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where customer_name like '%" + customer + "%' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + customer + "','" + customer_id + "')";
- } else if (sale_person != 'all' && firstdate != undefined && seconddate != undefined && sale_person != undefined) {
- console.log("date and sale_person");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + '' + "','" + '' + "')";
- } else if (customer != undefined && firstdate != undefined && seconddate != undefined && sale_person == undefined) {
- console.log("for date and customer");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and customer_name like '%" + customer + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + customer + "','" + customer_id + "')";
- } else if (customer != undefined && firstdate != undefined && seconddate != undefined && sale_person != undefined) {
- console.log("all filters");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and customer_name like '%" + customer + "%' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + customer + "','" + customer_id + "')";
- }
- else {
- console.log("only for date");
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + '' + "','" + '' + "')";
- }
- // if (sale_person == undefined && customer == undefined && searchfilter != "undefineddate" && sale_person == 'undefined') {
- // console.log("only for date")
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + '' + "','" + '' + "')";
- // } else if (sale_person != undefined && searchfilter == "undefineddate" && customer == undefined && sale_person !='undefined') {
- // console.log("for sale_peron only")
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + '' + "','" + '' + "')";
- // }else if(customer != undefined && customer_id !=undefined && searchfilter == "undefineddate" && sale_person !=undefined && sale_person != 'undefined'){
- // console.log("for customer only");
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where customer_name like '%" + customer + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + customer + "','" + customer_id + "')";
- // }else if(customer !=undefined && sale_person !='undefined' && sale_person !=undefined && searchfilter == "undefineddate"){
- // console.log("for customer and sale_person")
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where customer_name like '%" + customer + "%' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + customer + "','" + customer_id + "')";
- // }else if(customer !=undefined && searchfilter != "undefineddate" && sale_person ==undefined){
- // console.log("customer and date filter");
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and customer_name like '%" + customer + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + '' + "','" + customer + "','" + customer_id + "')";
- // }else if(customer !=undefined && searchfilter != "undefineddate" && sale_person !=undefined){
- // console.log("customer, sale person and date")
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and customer_name like '%" + customer + "%' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + customer + "','" + customer_id + "')";
- // }
- // else{
- // console.log("for date and sale_person filters");
- // querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and sale_person like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // countquery = "call SP_CountDashboard_admin ('" + firstdate + "','" + seconddate + "','" + emai_id + "','" + '' + "','" + '' + "')";
- // }
- console.log(querydvr);
- const queryresult = await db.executequery(querydvr);
- console.log("firstdate------>", firstdate, "seconddate-------->", seconddate)
- if (firstdate == undefined && seconddate == undefined) {
- } else {
- //date is request of api
- }
- console.log("countquery=========>", countquery)
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1========>", queryresult1)
- var countdata = queryresult1[0];
- console.log("countdata", countdata, queryresult.length);
- for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- dvrlist.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: (countdata == undefined ? queryresult.length : countdata[0].allcount),
- no_of_completed: (countdata == undefined ? 0 : countdata[0].completed),
- no_of_incompleted: (countdata == undefined ? 0 : countdata[0].incompleted),
- no_of_contact: (countdata == undefined ? 0 : countdata[0].contactcount)
- }],
- dvrlist,
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- } else {
- //last week, month,year searchfilter
- console.log("in admin else part")
- if (req.query.searchfiltertype == '0') {
- //for last week
- var dvrlist = [];
- const lastweek = await getLastWeeksDate();
- const currentDate = await getcurrentDate();
- console.log(lastweek)
- if (sale_person == undefined) {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastweek + "' and '" + currentDate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- } else {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastweek + "' and '" + currentDate + "' and contact_name like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- }
- const countquery = "call SP_CountDashboard ('" + lastweek + "','" + currentDate + "','" + '' + "')";
- const queryresult = await db.executequery(querydvr);
- console.log("countquery", countquery);
- const queryresult1 = await db.executequery(countquery);
- var countdata = queryresult1[0];
- for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- dvrlist.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist,
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- } else if (req.query.searchfiltertype == '2') {
- //for last year
- var dvrlist = [];
- const lastyeardate = await getLastYearDate();
- const currentDate = await getcurrentDate();
- if (sale_person == undefined) {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastyeardate + "' and '" + currentDate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- } else {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastyeardate + "' and '" + currentDate + "' and contact_name like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc ";
- }
- console.log("lastyeardate", lastyeardate, " ", currentDate);
- const countquery = "call SP_CountDashboard ('" + lastyeardate + "' , '" + currentDate + "','" + '' + "')";
- const queryresult = await db.executequery(querydvr);
- console.log("querydvr-------->", querydvr);
- const queryresult1 = await db.executequery(countquery);
- var countdata = queryresult1[0];
- for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- dvrlist.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- // res.send({
- // getdvrDataStatus: '0',
- // mesasge: "Data Found",
- // countdata: [{
- // no_of_visit: countdata[0].allcount,
- // no_of_completed: countdata[0].completed,
- // no_of_incompleted: countdata[0].incompleted,
- // no_of_contact: countdata[0].contactcount
- // }],
- // dvrlist
- // })
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist,
- }],
- error: " "
- })
- } else {
- // res.send({
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // })
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- } else {
- //by default for last month
- console.log("normal month");
- var dvrlist = [];
- const lastmonthDate = await getLastMonthDate();
- const currentDate = await getcurrentDate();
- console.log("lastmonthDate", lastmonthDate, "currentDate", currentDate);
- if (sale_person == undefined) {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- }
- else {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and contact_name like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- }
- const countquery = "call SP_CountDashboard ('" + lastmonthDate + "' , '" + currentDate + "','" + '' + "')";
- const queryresult = await db.executequery(querydvr);
- const queryresult1 = await db.executequery(countquery);
- var countdata = queryresult1[0];
- for (var i = 0; i < queryresult.length; i++) {
- dvrlist.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist,
- }],
- error: " "
- })
- } else {
- // res.send({
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // })
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- }
- } else {
- var dvrlist = [];
- console.log("in else latest condition")
- const lastmonthDate = await getLastMonthDate();
- const currentDate = await getcurrentDate();
- console.log("lastmonthDate ", lastmonthDate, " currentDate", currentDate)
- if (sale_person == undefined) {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- } else {
- querydvr = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and contact_name like '%" + sale_person + "%' and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc ";
- }
- const countquery = "call SP_CountDashboard ('" + lastmonthDate + "' , '" + currentDate + "' ,'" + '' + "')";
- console.log("countquery", countquery);
- console.log("querydvr", querydvr)
- const queryresult1 = await db.executequery(countquery);
- var countdata = queryresult1[0];
- console.log("countdata", countdata);
- const queryresult = await db.executequery(querydvr);
- for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- dvrlist.push(queryresult[i])
- }
- // if (dvrlist.length > 0) {
- // for (var i = 0; i < dvrlist.length; i++) {
- // }
- // }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist,
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- //other user
- console.log("in other users");
- var getcustomer_id = [];
- var getcustomer_name = [];
- if (user_id_for_mapp) {
- const query = "select customer_id,user_id from customer_user_mapping where user_id=" + user_id_for_mapp;
- const queryresult_id = await db.executequery(query);
- console.log("queryresult", queryresult_id);
- for (var i = 0; i < queryresult_id.length; i++) {
- getcustomer_id.push(queryresult_id[i].customer_id);
- }
- console.log(getcustomer_id);
- }
- if (req.query.searchfiltertype) {
- console.log("in searchfiltertype ");
- if (req.query.searchfiltertype.length > 1) {
- console.log("datafliter");
- //date seach filter
- var searchfilter = req.query.searchfiltertype;
- const dates = searchfilter.split("-");
- console.log("dates", dates)
- const firstdate = dates[0] + ' 00:00:01';
- const seconddate = dates[1] + ' 23:59:59';
- console.log(firstdate);
- console.log(seconddate);
- if (getcustomer_id.length > 0) {
- console.log("data present in custmer mapping table");
- const getcust_name = "select customer_id,customer_name from customer_master where customer_id in(" + getcustomer_id + ")";
- const getqueryresult1 = await db.executequery(getcust_name);
- console.log("getcust_name", getcust_name)
- console.log("getcust_name============>", getqueryresult1);
- for (var i = 0; i < getqueryresult1.length; i++) {
- getcustomer_name.push(getqueryresult1[i].customer_name);
- }
- console.log("getcustomer_name", getcustomer_name);
- if (getcustomer_name) {
- for (var i = 0; i < getcustomer_name.length; i++) {
- const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and customer_name in ('" + getcustomer_name[i] + "') and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- dvrlist[i] = await db.executequery(query);
- }
- var plano = dvrlist.reduce((acc, el) => acc.concat(el), []);
- //console.log("plano",plano)
- dvrlist = plano;
- console.log("finalResult=================>", dvrlist);
- const countquery = "call SP_CountDashboard ('" + firstdate + "' , '" + seconddate + "','" + login_id + "')";
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1", countquery);
- var countdata = queryresult1[0];
- if (dvrlist.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- console.log("data not present in custmer mapping table");
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- // const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + firstdate + "' and '" + seconddate + "' and login_id='" + login_id + "' order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // const countquery = "call SP_CountDashboard ('" + firstdate + "' , '" + seconddate + + "','" + login_id + "')";
- // const queryresult = await db.executequery(query);
- // const queryresult1 = await db.executequery(countquery);
- // var countdata = queryresult1[0];
- // for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- // dvrlist.push(queryresult[i])
- // }
- // if (queryresult.length > 0) {
- // res.send({
- // status: true,
- // data: [{
- // getdvrDataStatus: '0',
- // mesasge: "Data Found",
- // countdata: [{
- // no_of_visit: countdata[0].allcount,
- // no_of_completed: countdata[0].completed,
- // no_of_incompleted: countdata[0].incompleted,
- // no_of_contact: countdata[0].contactcount
- // }],
- // dvrlist,
- // }],
- // error: " "
- // })
- // } else {
- // res.send({
- // status: false,
- // data: [{
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // }],
- // error: " "
- // })
- // }
- } else {
- //last week, month,year searchfilter
- if (req.query.searchfiltertype == '0') {
- //for last week
- var dvrlist = [];
- const lastweek = await getLastWeeksDate();
- const currentDate = await getcurrentDate();
- if (getcustomer_id.length > 0) {
- console.log("data present in custmer mapping table");
- const getcust_name = "select customer_id,customer_name from customer_master where customer_id in(" + getcustomer_id + ")";
- const getqueryresult1 = await db.executequery(getcust_name);
- console.log("getcust_name", getcust_name)
- console.log("getcust_name============>", getqueryresult1);
- for (var i = 0; i < getqueryresult1.length; i++) {
- getcustomer_name.push(getqueryresult1[i].customer_name);
- }
- console.log("getcustomer_name", getcustomer_name);
- if (getcustomer_name) {
- for (var i = 0; i < getcustomer_name.length; i++) {
- const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastweek + "' and '" + currentDate + "' and customer_name in ('" + getcustomer_name[i] + "') and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- dvrlist[i] = await db.executequery(query);
- }
- var plano = dvrlist.reduce((acc, el) => acc.concat(el), []);
- //console.log("plano",plano)
- dvrlist = plano;
- console.log("finalResult=================>", dvrlist);
- const countquery = "call SP_CountDashboard ('" + lastweek + "' , '" + currentDate + "','" + login_id + "')";
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1", countquery);
- var countdata = queryresult1[0];
- if (dvrlist.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- console.log("data not present in custmer mapping table");
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- // const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastweek + "' and '" + currentDate + "' and login_id=" + login_id + "' order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // const countquery = "call SP_CountDashboard ('" + lastweek + "' , '" + currentDate + "','" + login_id + "')";
- // const queryresult = await db.executequery(query);
- // const queryresult1 = await db.executequery(countquery);
- // var countdata = queryresult1[0];
- // for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- // dvrlist.push(queryresult[i])
- // }
- // if (queryresult.length > 0) {
- // res.send({
- // status: true,
- // data: [{
- // getdvrDataStatus: '0',
- // mesasge: "Data Found",
- // countdata: [{
- // no_of_visit: countdata[0].allcount,
- // no_of_completed: countdata[0].completed,
- // no_of_incompleted: countdata[0].incompleted,
- // no_of_contact: countdata[0].contactcount
- // }],
- // dvrlist
- // }],
- // error: " "
- // })
- // } else {
- // res.send({
- // status: false,
- // data: [{
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // }],
- // error: " "
- // })
- // }
- } else if (req.query.searchfiltertype == '2') {
- //for last year
- var dvrlist = [];
- const lastyeardate = await getLastYearDate();
- const currentDate = await getcurrentDate();
- if (getcustomer_id.length > 0) {
- console.log("data present in custmer mapping table");
- const getcust_name = "select customer_id,customer_name from customer_master where customer_id in(" + getcustomer_id + ")";
- const getqueryresult1 = await db.executequery(getcust_name);
- console.log("getcust_name", getcust_name)
- console.log("getcust_name============>", getqueryresult1);
- for (var i = 0; i < getqueryresult1.length; i++) {
- getcustomer_name.push(getqueryresult1[i].customer_name);
- }
- console.log("getcustomer_name", getcustomer_name);
- if (getcustomer_name) {
- for (var i = 0; i < getcustomer_name.length; i++) {
- const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastyeardate + "' and '" + currentDate + "' and customer_name in ('" + getcustomer_name[i] + "') and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- dvrlist[i] = await db.executequery(query);
- }
- var plano = dvrlist.reduce((acc, el) => acc.concat(el), []);
- // console.log("plano",plano)
- dvrlist = plano;
- console.log("finalResult=================>", dvrlist);
- const countquery = "call SP_CountDashboard ('" + lastyeardate + "' , '" + currentDate + "','" + login_id + "')";
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1", countquery);
- var countdata = queryresult1[0];
- if (dvrlist.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- console.log("data not present in custmer mapping table");
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- // const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastyeardate + "' and '" + currentDate + "' and login_id=" + login_id + "' order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // const countquery = "call SP_CountDashboard ('" + lastyeardate + "' , '" + currentDate + "','" + login_id + "')";
- // const queryresult = await db.executequery(query);
- // const queryresult1 = await db.executequery(countquery);
- // var countdata = queryresult1[0];
- // for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- // dvrlist.push(queryresult[i])
- // }
- // if (queryresult.length > 0) {
- // res.send({
- // status: true,
- // data: [{
- // getdvrDataStatus: '0',
- // mesasge: "Data Found",
- // countdata: [{
- // no_of_visit: countdata[0].allcount,
- // no_of_completed: countdata[0].completed,
- // no_of_incompleted: countdata[0].incompleted,
- // no_of_contact: countdata[0].contactcount
- // }],
- // dvrlist
- // }],
- // error: " "
- // })
- // } else {
- // res.send({
- // status: false,
- // data: [{
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // }],
- // error: " "
- // })
- // }
- } else {
- //by default for last month
- console.log("users by last month", login_id);
- var dvrlist = [];
- const lastmonthDate = await getLastMonthDate();
- const currentDate = await getcurrentDate();
- if (getcustomer_id.length > 0) {
- console.log("data present in custmer mapping table");
- const getcust_name = "select customer_id,customer_name from customer_master where customer_id in(" + getcustomer_id + ")";
- const getqueryresult1 = await db.executequery(getcust_name);
- console.log("getcust_name", getcust_name)
- console.log("getcust_name============>", getqueryresult1);
- for (var i = 0; i < getqueryresult1.length; i++) {
- getcustomer_name.push(getqueryresult1[i].customer_name);
- }
- console.log("getcustomer_name", getcustomer_name);
- if (getcustomer_name) {
- for (var i = 0; i < getcustomer_name.length; i++) {
- const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and customer_name in ('" + getcustomer_name[i] + "') and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- dvrlist[i] = await db.executequery(query);
- }
- var plano = dvrlist.reduce((acc, el) => acc.concat(el), []);
- //console.log("plano",plano)
- dvrlist = plano;
- console.log("finalResult=================>", dvrlist);
- const countquery = "call SP_CountDashboard ('" + lastmonthDate + "' , '" + currentDate + "','" + login_id + "')";
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1", countquery);
- var countdata = queryresult1[0];
- if (dvrlist.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- console.log("data not present in custmer mapping table");
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- // const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and login_id=" + login_id + "' order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- // const countquery = "call SP_CountDashboard ('" + lastmonthDate + "' , '" + currentDate + "','" + login_id + "')";
- // const queryresult = await db.executequery(query);
- // const queryresult1 = await db.executequery(countquery);
- // var countdata = queryresult1[0];
- // for (var i = 0; i < queryresult.length; i++) {
- // console.log(queryresult[i]);
- // dvrlist.push(queryresult[i])
- // }
- // if (queryresult.length > 0) {
- // console.log("dvrlist12345", dvrlist);
- // res.send({
- // status: true,
- // data: [{
- // getdvrDataStatus: 0,
- // mesasge: "Data Found",
- // countdata: [{
- // no_of_visit: countdata[0].allcount,
- // no_of_completed: countdata[0].completed,
- // no_of_incompleted: countdata[0].incompleted,
- // no_of_contact: countdata[0].contactcount
- // }],
- // dvrlist
- // }],
- // error: " "
- // })
- // } else {
- // res.send({
- // status: false,
- // data: [{
- // getdvrDataStatus: '1',
- // mesasge: "Data Not Found"
- // }],
- // error: " "
- // })
- // }
- }
- }
- } else {
- console.log("in else part of bydefult");
- var dvrlist = [];
- const lastmonthDate = await getLastMonthDate();
- const currentDate = await getcurrentDate();
- console.log("lastmonthDate", lastmonthDate, "currentDate", currentDate);
- if (getcustomer_id.length > 0) {
- console.log("data present in custmer mapping table");
- const getcust_name = "select customer_id,customer_name from customer_master where customer_id in(" + getcustomer_id + ")";
- const getqueryresult1 = await db.executequery(getcust_name);
- console.log("getcust_name", getcust_name)
- console.log("getcust_name============>", getqueryresult1);
- for (var i = 0; i < getqueryresult1.length; i++) {
- getcustomer_name.push(getqueryresult1[i].customer_name);
- }
- console.log("getcustomer_name", getcustomer_name);
- if (getcustomer_name) {
- for (var i = 0; i < getcustomer_name.length; i++) {
- const query = "select dvr_id, date_of_visit,customer_name,contact_name,message,physical_meeting,sale_person from dvr_report where date_of_visit between'" + lastmonthDate + "' and '" + currentDate + "' and customer_name in ('" + getcustomer_name[i] + "') and delete_id=0 order by DATE_FORMAT(date_of_visit, '%Y%m%d') desc";
- dvrlist[i] = await db.executequery(query);
- }
- var plano = dvrlist.reduce((acc, el) => acc.concat(el), []);
- //console.log("plano",plano)
- dvrlist = plano;
- console.log("finalResult=================>", dvrlist);
- const countquery = "call SP_CountDashboard ('" + lastmonthDate + "' , '" + currentDate + "','" + login_id + "')";
- const queryresult1 = await db.executequery(countquery);
- console.log("queryresult1", countquery);
- var countdata = queryresult1[0];
- if (dvrlist.length > 0) {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '0',
- mesasge: "Data Found",
- countdata: [{
- no_of_visit: countdata[0].allcount,
- no_of_completed: countdata[0].completed,
- no_of_incompleted: countdata[0].incompleted,
- no_of_contact: countdata[0].contactcount
- }],
- dvrlist
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- } else {
- console.log("data not present in custmer mapping table");
- res.send({
- status: false,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: " "
- })
- }
- }
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- error: err,
- getdvrDataStatus: '1',
- })
- }
- }
- module.exports.createDvrEntry = async (req, res) => {
- const validationResp = await validation.createDvrentrycheck(req);
- const createdate = new Date();
- if (validationResp.status) {
- try {
- console.log(" req.body.login_id", req.body.created_by);
- const date_of_visit = new Date(req.body.visit_date);
- //const date_of_visit=req.body.visit_date;
- const query = "INSERT INTO dvr_report(date_of_visit,customer_name,contact_name,physical_meeting,message,created_by,created_on,stage_id,login_id,sale_person,delete_id)" +
- "VALUES(?,?,?,?,?,?,?,?,?,?,?)";
- const values = [date_of_visit, req.body.customer_name, req.body.contact_name, req.body.physical_metting, req.body.message, req.body.created_by, createdate, req.body.stage_id, req.body.created_by, req.body.sale_person, 0]
- // console.log("query",query);
- //console.log("values",values);
- const res1 = await db.executevaluesquery(query, values);
- console.log("res1", res1);
- if (res1) {
- res.send({
- status: true,
- data: [{
- message: "Daily visit Entry created Successfully.",
- createDvrStatus: "0",
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- errors: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "",
- createDvrStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- errors: ""
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: false,
- data: [{
- message: "",
- createDvrStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- errors: ""
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.updatedvrDetails = async (req, res) => {
- const validationResp = await validation.updatedvrDetailscheck(req);
- const updatedDate = await getcurrentDate();
- if (validationResp.status) {
- try {
- const query = "UPDATE dvr_report SET date_of_visit = '" + req.body.visit_date + "' ,customer_name= '" + req.body.customer_name + "',contact_name= '" + req.body.contact_name + "',message= '" + req.body.message + "' ,physical_meeting= '" + req.body.physical_metting + "' ,updated_by= '" + req.body.updated_by + "', updated_on= '" + updatedDate + "', stage_id= '" + req.body.stage_id + "' where dvr_id= '" + req.body.dvr_id + "'";
- console.log("query", query);
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- if (queryresult) {
- res.send({
- status: true,
- data: [
- {
- getdvrDataStatus: '0',
- message: "Daliy visit Report Entry updated suceesfully."
- }
- ],
- errors: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- message: "Daliy visit Report Entry not updated. Please try again after some time!"
- }],
- errors: ""
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: [], errors: err
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.createCustomerentry = async (req, res) => {
- const validationResp = await validation.createCustomerentrycheck(req);
- const createdate = new Date();
- if (validationResp.status) {
- try {
- const query = "INSERT INTO customer_master(customer_name,created_by,created_on)" +
- "VALUES(?,?,?)";
- const values = [req.body.customer_name, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- //console.log("res1", res1);
- if (res3) {
- res.send({
- message: "Customer Entry created Successfully ",
- createcustomerStatus: "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)
- }
- }
- module.exports.updateContactDetails = async (req, res) => {
- const validationResp = await validation.updateContactDetailscheck(req);
- const updatedDate = await getcurrentDate();
- if (validationResp.status) {
- try {
- const query = "UPDATE contact_master SET customer_id= '" + req.body.customer_id + "',first_name= '" + req.body.first_name + "',last_name= '" + req.body.last_name + "' ,mobile_number= '" + req.body.mobile_number + "' ,email_id= '" + req.body.email_id + "', designation= '" + req.body.designation + "', department= '" + req.body.department + "', updated_on= '" + updatedDate + "' where customer_id= '" + req.body.customer_id + "'";
- console.log("query", query);
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- if (queryresult) {
- res.send({
- updateContactStatus: '0',
- mesasge: "Contact Entry updated suceesfully."
- })
- } else {
- res.send({
- updateContactStatus: '1',
- mesasge: "Contact Entry not updated."
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: []
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.updateCustomerDetails = async (req, res) => {
- const validationResp = await validation.updateCustomerDetailscheck(req);
- const updatedDate = await getcurrentDate();
- if (validationResp.status) {
- try {
- const query = "UPDATE customer_master SET customer_id = '" + req.body.customer_id + "', updated_on= '" + updatedDate + "' where customer_master= '" + req.body.contact_master + "'";
- console.log("query", query);
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- if (queryresult) {
- res.send({
- updateCustomerStatus: '0',
- mesasge: "Customer Entry updated suceesfully."
- })
- } else {
- res.send({
- updateCustomerStatus: '1',
- mesasge: "Customer Entry not updated."
- })
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: []
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.getlastestdvr = async (req, res) => {
- try {
- var insertedRecord = [];
- var startdate = new Date();
- var enddate = new Date();
- const format2 = "YYYY-MM-DD";
- startdate = moment(startdate).format(format2) + ' 00:00:01';
- enddate = moment(enddate).format(format2) + ' 23:59:59';
- var person_role = req.query.role;
- var login_id = req.query.login_id;
- console.log("login_id", login_id);
- if (person_role == 'admin') {
- //admin show all data
- const query = "SELECT d.dvr_id,d.date_of_visit,d.customer_name,d.contact_name,d.physical_meeting,d.message,s.stage_desc,d.stage_id FROM dvr_report d JOIN stage_master s ON d.stage_id=s.stage_id where d.created_on between '" + startdate + "' and '" + enddate + "' and d.delete_id=0 order by d.date_of_visit desc";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- insertedRecord.push(queryresult[i])
- }
- //console.log("res1", res1);
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- dvrData: insertedRecord
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- } else {
- // other users
- console.log("other users");
- const query = "SELECT d.dvr_id,d.date_of_visit,d.customer_name,d.contact_name,d.physical_meeting,d.message,s.stage_desc,d.stage_id FROM dvr_report d JOIN stage_master s ON d.stage_id=s.stage_id where d.login_id='" + login_id + "' and d.created_on between '" + startdate + "' and '" + enddate + "' and d.delete_id=0 order by d.date_of_visit desc";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- insertedRecord.push(queryresult[i])
- }
- //console.log("res1", res1);
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- dvrData: insertedRecord
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- getdvrDataStatus: '1',
- })
- }
- }
- module.exports.getcontactDetails = async (req, res) => {
- try {
- var insertedRecord = [];
- var startdate = new Date();
- var enddate = new Date();
- const format2 = "YYYY-MM-DD";
- startdate = moment(startdate).format(format2) + ' 00:00:01';
- enddate = moment(enddate).format(format2) + ' 23:59:59';
- var person_role = req.query.role;
- var login_id = req.query.login_id;
- if (person_role == 'admin') {
- //admin show all data
- const query = "SELECT first_name,last_name,mobile_number,email_id,designation,department FROM contact_master where created_on between '" + startdate + "' and '" + enddate + "' order by contact_id desc";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- insertedRecord.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- conrtactData: insertedRecord
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- } else {
- //others users
- const query = "SELECT first_name,last_name,mobile_number,email_id,designation,department FROM contact_master where created_by= '" + login_id + "' and created_on between '" + startdate + "' and '" + enddate + "' order by contact_id desc";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- insertedRecord.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- conrtactData: insertedRecord
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- }
- } catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- getdvrDataStatus: '1',
- })
- }
- }
- module.exports.getsalePersonList = async (req, res) => {
- console.log("in getsalePersonList");
- try {
- var salePerson = [];
- var full_name = [];
- const query = "SELECT user_id,first_name,last_name from user_master;";
- const queryresult = await db.executequery(query);
- if (queryresult.length > 0) {
- for (var i = 0; i < queryresult.length; i++) {
- console.log("queryresult", queryresult[i])
- salePerson.push(queryresult[i]);
- }
- }
- console.log("salePerson", salePerson);
- res.send({
- status: true,
- data: [{
- salePerson: salePerson
- }],
- error: ""
- })
- } catch (err) {
- console.log(err)
- res.send({
- status: true, data: [], error: err
- })
- }
- }
- module.exports.getCustcontactDetails = async (req, res) => {
- try {
- var contactdetails = [];
- var customer_id = req.query.customer_id;
- var check_api = req.query.passid;
- var passing_id;
- console.log("customer_id", customer_id);
- console.log("check api", check_api);
- if (check_api == undefined) {
- console.log("pass customer name");
- const query = "SELECT customer_id,customer_name FROM customer_master where customer_name= '" + customer_id + "' ";
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- console.log("result------>", queryresult[0].customer_id);
- passing_id = queryresult[0].customer_id;
- const query_id = "SELECT first_name,last_name,mobile_number,email_id,designation,department,function_area FROM contact_master where customer_id= '" + passing_id + "' ";
- const queryresult_id = await db.executequery(query_id);
- console.log("query", query);
- for (var i = 0; i < queryresult_id.length; i++) {
- console.log(queryresult_id[i]);
- contactdetails.push(queryresult_id[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- conrtactData: contactdetails
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- } else {
- console.log("pass number");
- if (customer_id == 0) {
- console.log("getting all contact data");
- const query = "SELECT first_name,last_name,mobile_number,email_id,designation,department,function_area FROM contact_master";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- contactdetails.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- conrtactData: contactdetails
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- } else {
- console.log("getting only specific customer contact data");
- const query = "SELECT first_name,last_name,mobile_number,email_id,designation,department,function_area FROM contact_master where customer_id= '" + customer_id + "' ";
- const queryresult = await db.executequery(query);
- console.log("query", query);
- for (var i = 0; i < queryresult.length; i++) {
- console.log(queryresult[i]);
- contactdetails.push(queryresult[i])
- }
- if (queryresult.length > 0) {
- res.send({
- status: true,
- data: [{
- conrtactData: contactdetails
- }],
- error: ""
- })
- } else {
- res.send({
- status: true,
- data: [{
- getdvrDataStatus: '1',
- mesasge: "Data Not Found"
- }],
- error: ""
- })
- }
- }
- }
- } catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- getdvrDataStatus: '1',
- })
- }
- }
- module.exports.createUpdateCustomerentry = async (req, res) => {
- const validationResp = await validation.createCustomerentrycheck(req);
- const createdate = new Date();
- if (validationResp.status) {
- try {
- if (req.body.action == 'insert') {
- console.log("customer added");
- const checkdub = "select * from customer_master where customer_name='" + req.body.customer_name + "'";
- const checkqueryresult = await db.executequery(checkdub);
- console.log("checkqueryresult", checkqueryresult.length)
- if (checkqueryresult.length > 0) {
- //allready all present
- res.send({
- status: false,
- data: [],
- errors: "Customer Entry allready Exit ! Please Enter Correct Customer Name"
- })
- } else {
- //data not is present
- const query = "INSERT INTO customer_master(customer_name,created_by,created_on)" +
- "VALUES(?,?,?)";
- const values = [req.body.customer_name, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- console.log("response", res3);
- if (res3) {
- const query = "select customer_id from customer_master order by customer_id desc limit 1";
- const queryresult = await db.executequery(query);
- console.log("query result----->", queryresult);
- console.log("query result----->", queryresult[0].customer_id);
- if (queryresult) {
- // const query = "select customer_id from customer_master order by customer_id desc limit 1";
- // const queryresult = await db.executequery(query);
- var sale_person = req.body.sale_person;
- var name = sale_person.split(" ");
- console.log("name", name);
- var first_name = name[0];
- var last_name = name[1];
- console.log(first_name, last_name);
- const queryuserID = "SELECT user_id FROM user_master where first_name='" + first_name + "' and last_name= '" + last_name + "'";
- console.log("queryuserID", queryuserID);
- const queryresultID = await db.executequery(queryuserID);
- console.log("queryresultID", queryresultID);
- const finalquery = "INSERT INTO customer_user_mapping(customer_id,user_id,created_by,created_on)" +
- "VALUES(?,?,?,?)";
- const values = [queryresult[0].customer_id, queryresultID[0].user_id, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(finalquery, values);
- console.log("res3", res3);
- if (res3) {
- res.send({
- status: true,
- data: [{
- createcustomerStatus: "0",
- message: "Customer Entry created Successfully!",
- lastinsertedData: req.body.customer_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: false,
- data: [{
- message: "Customer Entry Not created",
- createcustomerStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- } else {
- res.send({
- status: true,
- data: [],
- errors: "Bad Request"
- })
- }
- }
- } else {
- console.log("customer update");
- const query = "UPDATE customer_master SET customer_name= '" + req.body.customer_name + "',updated_on= '" + createdate + "' ,updated_by= '" + req.body.created_by + "' where customer_id= '" + req.body.customer_id + "'";
- console.log("query", query);
- const queryresult = await db.executequery(query);
- console.log("queryresult", queryresult);
- //dates = searchfilter.split("-");
- var saleData = req.body.sale_person.split(" ");
- console.log("saleData");
- //select user_id from user_master where first_name= "" and last_name="";
- if (queryresult) {
- const getsaleperson = "select user_id from user_master where first_name= '" + saleData[0] + "' and last_name= '" + saleData[1] + "'";
- const getqueryresult = await db.executequery(getsaleperson);
- if (getqueryresult) {
- const checkdupli = "select * from customer_user_mapping where user_id=" + getqueryresult[0].user_id + " and customer_id= '" + req.body.customer_id + "' order by idcustCont_mapp desc limit 1";
- const checkexcutequer = await db.executequery(checkdupli);
- if (checkexcutequer[0].user_id == getqueryresult[0].user_id) {
- //same user for customer update
- console.log("same user for customer update");
- console.log("database date", formatDateAsPer(checkexcutequer[0].effectivedate_to));
- console.log("req body", req.body.effectivedate_to)
- if (req.body.effectivedate_to.length > 0) {
- if (req.body.effectivedate_from > req.body.effectivedate_to) {
- res.send({
- status: false,
- data: [],
- errors: "Please enter correct Effective From Date! Make sure Efffective From Date is less than Effective To Date"
- })
- } else {
- const query = "INSERT INTO customer_user_mapping(customer_id,user_id,effiectivedate_from,effectivedate_to,created_by,created_on)" +
- "VALUES(?,?,?,?,?,?)";
- const values = [req.body.customer_id, getqueryresult[0].user_id, req.body.effectivedate_from, req.body.effectivedate_to.length > 0 ? req.body.effectivedate_to : null, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- console.log("response--------->", res3);
- if (res3) {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Update Successfully!",
- createcustomerStatus: "0",
- lastinsertedData: req.body.customer_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Not Updated.",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- } else {
- //same user id for effective different date.
- const query = "INSERT INTO customer_user_mapping(customer_id,user_id,effiectivedate_from,effectivedate_to,created_by,created_on)" +
- "VALUES(?,?,?,?,?,?)";
- const values = [req.body.customer_id, getqueryresult[0].user_id, req.body.effectivedate_from, req.body.effectivedate_to.length > 0 ? req.body.effectivedate_to : null, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- console.log("response--------->", res3);
- if (res3) {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Update Successfully!",
- createcustomerStatus: "0",
- lastinsertedData: req.body.customer_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Not Updated.",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- } else {
- //other user for customer update
- if (req.body.effectivedate_to.length > 0 && checkexcutequer[0].effectivedate_to.length > 0) {
- if (req.body.effectivedate_to == formatDateAsPer(checkexcutequer[0].effectivedate_to)) {
- res.send({
- status: false,
- data: [],
- errors: "Please enter correct Effective To Date are same for other sales Person "
- })
- }
- } else if (req.body.effectivedate_to.length > 0) {
- if (req.body.effectivedate_from > req.body.effectivedate_to) {
- res.send({
- status: false,
- data: [],
- errors: "Please enter correct Effective From Date! Make sure Efffective From Date is less than Effective To Date"
- })
- } else if (req.body.effectivedate_from == req.body.effectivedate_to) {
- res.send({
- status: false,
- data: [],
- errors: "Please enter correct Effective From and Effection To Date ! Both Dates are same"
- })
- } else {
- const query = "INSERT INTO customer_user_mapping(customer_id,user_id,effiectivedate_from,effectivedate_to,created_by,created_on)" +
- "VALUES(?,?,?,?,?,?)";
- const values = [req.body.customer_id, getqueryresult[0].user_id, req.body.effectivedate_from, req.body.effectivedate_to.length > 0 ? req.body.effectivedate_to : null, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- console.log("response--------->", res3);
- if (res3) {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Update Successfully!",
- createcustomerStatus: "0",
- lastinsertedData: req.body.customer_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Not Updated",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- } else {
- //all ok
- const query = "INSERT INTO customer_user_mapping(customer_id,user_id,effiectivedate_from,effectivedate_to,created_by,created_on)" +
- "VALUES(?,?,?,?,?,?)";
- const values = [req.body.customer_id, getqueryresult[0].user_id, req.body.effectivedate_from, req.body.effectivedate_to.length > 0 ? req.body.effectivedate_to : null, req.body.created_by, createdate]
- const res3 = await db.executevaluesquery(query, values);
- console.log("response--------->", res3);
- if (res3) {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Update Successfully!",
- createcustomerStatus: "0",
- lastinsertedData: req.body.customer_name,
- exception: {
- errorid: "",
- errormessage: "No Errors"
- }
- }],
- error: " "
- })
- } else {
- res.send({
- status: true,
- data: [{
- message: "Customer Entry Not Updated",
- createStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- }
- }
- }
- }
- }
- }
- catch (err) {
- console.log(err)
- res.send({
- status: true, data: [],
- errors: err
- })
- }
- } else {
- res.send(validationResp)
- }
- }
- module.exports.deletedvrEntry = async (req, res) => {
- try {
- //DELETE FROM table_name WHERE condition;
- console.log("req.body", req.body);
- const updatedDate = await getcurrentDate();
- const query = "UPDATE dvr_report SET delete_id = 1,updated_by= '" + req.body.created_by + "', updated_on= '" + updatedDate + "' where dvr_id= " + req.body.dvr_id + "";
- const checkqueryresult = await db.executequery(query);
- console.log("checkqueryresult", checkqueryresult)
- console.log("eeeeeeee", checkqueryresult.affectedRows);
- if (checkqueryresult) {
- //entry not deleted
- res.send({
- status: true,
- data: [{
- message: "DVR Entry Deleted Successfully!",
- deleteStatus: "0"
- }],
- error: ""
- })
- } else {
- //entry deleted
- res.send({
- status: true,
- data: [{
- message: "DVR Entry Not Deleted.",
- deleteStatus: "1",
- exception: {
- errorid: "404",
- errormessage: "Bad request"
- }
- }],
- error: ""
- })
- }
- } catch (err) {
- console.log(err)
- res.send({
- status: true,
- data: [],
- getdvrDataStatus: '1',
- })
- }
- }
- function getLastWeeksDate() {
- const now = new Date();
- const format2 = "YYYY-MM-DD";
- const date = new Date(now.getTime() - 7 * 24 * 60 * 60 * 1000);
- // console.log("date", date);
- const dateTime2 = moment(date).format(format2) + ' 00:00:00';
- // console.log("date------>", dateTime2);
- return dateTime2;
- }
- function getcurrentDate() {
- const now = new Date();
- const format2 = "YYYY-MM-DD";
- const dateTime2 = moment(now).format(format2) + ' 23:59:59';
- // console.log("date------>", dateTime2);
- return dateTime2;
- }
- function getLastMonthDate() {
- const now = new Date();
- const format2 = "YYYY-MM-DD";
- const date = new Date(now.getFullYear(), now.getMonth() - 1, 1);
- // console.log("date", date);
- const dateTime2 = moment(date).format(format2) + ' 00:00:00';
- //console.log("date------>", dateTime2);
- return dateTime2;
- }
- function getLastYearDate() {
- const now = new Date();
- const format2 = "YYYY-MM-DD";
- const date = new Date(now.setFullYear(now.getFullYear() - 1));
- // console.log("date", date);
- const dateTime2 = moment(date).format(format2) + ' 00:00:00';
- //console.log("date------>", dateTime2);
- return dateTime2;
- }
|