12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507 |
- 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 querycount= "select COUNT(*) as count from contact_master where first_name='" + req.body.first_name + "' and last_name='" + req.body.last_name + "' and mobile_number ='" + req.body.mobile_no + "'";
- console.log("querycount",querycount);
- const querycountresult = await db.executequery(querycount);
- console.log("querycountresult", querycountresult);
-
- console.log("querycountresult1",querycountresult[0].count);
- if (querycountresult[0].count > 0) {
- console.log("duplicate entry present");
- res.send({
- status: true,
- data: [{
- message: "",
- createStatus: "1",
- exception: {
- errorid: "400",
- errormessage: "Duplicate Entry: This contact alrady exists in the database."
- }
- }],
- error: ""
- })
- } else {
- console.log("new contact details")
- 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 order by first_name";
- 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 + "' order by first_name";
- 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 order by first_name";
- 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 + "' order by first_name";
- 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;
- }
|