server/api/squareOdbc/squareOdbc.controller.js

   1 // *************************************************************************
   2 // *                                                                       *
   3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
   4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
   5 // *                                                                       *
   6 // *************************************************************************
   7 // *                                                                       *
   8 // * Email: info@xcally.com                                                *
   9 // * Website: https://www.xcally.com                                       *
  10 // *                                                                       *
  11 // *************************************************************************
  12 // *                                                                       *
  13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
  14 // * copyright treaties, as well as other intellectual property laws and   *
  15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
  16 // *                                                                       *
  17 // *************************************************************************
  18 var _0x76d4=['count','offset','set','apply','reject','save','update','then','destroy','UserProfileResource','sendStatus','error','stack','name','send','index','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','fields','attributes','nolimit','order','sort','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','find','create','body','user','get','role','ODBC','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','odbc','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/license/util','../../mysqldb','end','status','json','limit'];(function(_0x138adb,_0x193fee){var _0x1b27f2=function(_0x5e97a2){while(--_0x5e97a2){_0x138adb['push'](_0x138adb['shift']());}};_0x1b27f2(++_0x193fee);}(_0x76d4,0x8c));var _0x476d=function(_0xb86e02,_0x2732b5){_0xb86e02=_0xb86e02-0x0;var _0x464761=_0x76d4[_0xb86e02];return _0x464761;};'use strict';var emlformat=require(_0x476d('0x0'));var rimraf=require(_0x476d('0x1'));var zipdir=require(_0x476d('0x2'));var jsonpatch=require(_0x476d('0x3'));var rp=require(_0x476d('0x4'));var moment=require(_0x476d('0x5'));var BPromise=require('bluebird');var Mustache=require(_0x476d('0x6'));var util=require(_0x476d('0x7'));var path=require(_0x476d('0x8'));var sox=require(_0x476d('0x9'));var csv=require(_0x476d('0xa'));var ejs=require(_0x476d('0xb'));var fs=require('fs');var fs_extra=require(_0x476d('0xc'));var _=require('lodash');var squel=require(_0x476d('0xd'));var crypto=require(_0x476d('0xe'));var jsforce=require(_0x476d('0xf'));var deskjs=require(_0x476d('0x10'));var toCsv=require(_0x476d('0xa'));var querystring=require(_0x476d('0x11'));var Papa=require(_0x476d('0x12'));var Redis=require(_0x476d('0x13'));var authService=require(_0x476d('0x14'));var qs=require(_0x476d('0x15'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x476d('0x16'));var logger=require(_0x476d('0x17'))(_0x476d('0x18'));var utils=require(_0x476d('0x19'));var config=require('../../config/environment');var licenseUtil=require(_0x476d('0x1a'));var db=require(_0x476d('0x1b'))['db'];function respondWithStatusCode(_0x2608ba,_0x555ca3){_0x555ca3=_0x555ca3||0xcc;return function(_0x2aa34e){if(_0x2aa34e){return _0x2608ba['sendStatus'](_0x555ca3);}return _0x2608ba['status'](_0x555ca3)[_0x476d('0x1c')]();};}function respondWithResult(_0x49b716,_0x5dd816){_0x5dd816=_0x5dd816||0xc8;return function(_0x46d3df){if(_0x46d3df){return _0x49b716[_0x476d('0x1d')](_0x5dd816)[_0x476d('0x1e')](_0x46d3df);}};}function respondWithFilteredResult(_0x9c236a,_0x1dbce5){return function(_0x7cfffe){if(_0x7cfffe){var _0x5873f3=typeof _0x1dbce5['offset']==='undefined'&&typeof _0x1dbce5[_0x476d('0x1f')]==='undefined';var _0x62c37e=_0x7cfffe[_0x476d('0x20')];var _0x52084c=_0x5873f3?0x0:_0x1dbce5[_0x476d('0x21')];var _0x1bcfef=_0x5873f3?_0x7cfffe[_0x476d('0x20')]:_0x1dbce5[_0x476d('0x21')]+_0x1dbce5['limit'];var _0x5225e1;if(_0x1bcfef>=_0x62c37e){_0x1bcfef=_0x62c37e;_0x5225e1=0xc8;}else{_0x5225e1=0xce;}_0x9c236a[_0x476d('0x1d')](_0x5225e1);return _0x9c236a[_0x476d('0x22')]('Content-Range',_0x52084c+'-'+_0x1bcfef+'/'+_0x62c37e)[_0x476d('0x1e')](_0x7cfffe);}return null;};}function patchUpdates(_0x1cb85b){return function(_0x5d99a4){try{jsonpatch[_0x476d('0x23')](_0x5d99a4,_0x1cb85b,!![]);}catch(_0x228cb2){return BPromise[_0x476d('0x24')](_0x228cb2);}return _0x5d99a4[_0x476d('0x25')]();};}function saveUpdates(_0x13bc00,_0x2ceae3){return function(_0x1ace2f){if(_0x1ace2f){return _0x1ace2f[_0x476d('0x26')](_0x13bc00)[_0x476d('0x27')](function(_0x449354){return _0x449354;});}return null;};}function removeEntity(_0x31b52f,_0x5890e6){return function(_0x4a8173){if(_0x4a8173){return _0x4a8173[_0x476d('0x28')]()[_0x476d('0x27')](function(){var _0x4f277b=_0x4a8173['get']({'plain':!![]});var _0x534280='ODBC';return db[_0x476d('0x29')][_0x476d('0x28')]({'where':{'type':_0x534280,'resourceId':_0x4f277b['id']}})[_0x476d('0x27')](function(){return _0x4a8173;});})[_0x476d('0x27')](function(){_0x31b52f[_0x476d('0x1d')](0xcc)['end']();});}};}function handleEntityNotFound(_0x7dcd89,_0x4fae7c){return function(_0x39b41f){if(!_0x39b41f){_0x7dcd89[_0x476d('0x2a')](0x194);}return _0x39b41f;};}function handleError(_0x2600f1,_0x181265){_0x181265=_0x181265||0x1f4;return function(_0x55a96e){logger[_0x476d('0x2b')](_0x55a96e[_0x476d('0x2c')]);if(_0x55a96e['name']){delete _0x55a96e[_0x476d('0x2d')];}_0x2600f1[_0x476d('0x1d')](_0x181265)[_0x476d('0x2e')](_0x55a96e);};}exports[_0x476d('0x2f')]=function(_0x1f4395,_0x15783c){var _0x2594b2={},_0x2b5d7c={},_0x39e188={'count':0x0,'rows':[]};var _0x2acda6=_[_0x476d('0x30')](db[_0x476d('0x31')][_0x476d('0x32')],function(_0x4d4e07){return{'name':_0x4d4e07[_0x476d('0x33')],'type':_0x4d4e07[_0x476d('0x34')][_0x476d('0x35')]};});_0x2b5d7c[_0x476d('0x36')]=_['map'](_0x2acda6,'name');_0x2b5d7c[_0x476d('0x37')]=_[_0x476d('0x38')](_0x1f4395['query']);_0x2b5d7c[_0x476d('0x39')]=_[_0x476d('0x3a')](_0x2b5d7c[_0x476d('0x36')],_0x2b5d7c[_0x476d('0x37')]);_0x2594b2['attributes']=_['intersection'](_0x2b5d7c['model'],qs['fields'](_0x1f4395[_0x476d('0x37')][_0x476d('0x3b')]));_0x2594b2[_0x476d('0x3c')]=_0x2594b2[_0x476d('0x3c')]['length']?_0x2594b2[_0x476d('0x3c')]:_0x2b5d7c[_0x476d('0x36')];if(!_0x1f4395[_0x476d('0x37')]['hasOwnProperty'](_0x476d('0x3d'))){_0x2594b2['limit']=qs[_0x476d('0x1f')](_0x1f4395[_0x476d('0x37')][_0x476d('0x1f')]);_0x2594b2[_0x476d('0x21')]=qs['offset'](_0x1f4395[_0x476d('0x37')]['offset']);}_0x2594b2[_0x476d('0x3e')]=qs[_0x476d('0x3f')](_0x1f4395['query'][_0x476d('0x3f')]);_0x2594b2[_0x476d('0x40')]=qs[_0x476d('0x39')](_['pick'](_0x1f4395[_0x476d('0x37')],_0x2b5d7c['filters']),_0x2acda6);if(_0x1f4395[_0x476d('0x37')][_0x476d('0x41')]){_0x2594b2[_0x476d('0x40')]=_[_0x476d('0x42')](_0x2594b2['where'],{'$or':_['map'](_0x2acda6,function(_0x126b0d){if(_0x126b0d[_0x476d('0x34')]!==_0x476d('0x43')){var _0x2bcc8c={};_0x2bcc8c[_0x126b0d[_0x476d('0x2d')]]={'$like':'%'+_0x1f4395[_0x476d('0x37')][_0x476d('0x41')]+'%'};return _0x2bcc8c;}})});}_0x2594b2=_[_0x476d('0x42')]({},_0x2594b2,_0x1f4395[_0x476d('0x44')]);var _0x5cdb38={'where':_0x2594b2[_0x476d('0x40')]};return db['SquareOdbc'][_0x476d('0x20')](_0x5cdb38)[_0x476d('0x27')](function(_0x5e1392){_0x39e188[_0x476d('0x20')]=_0x5e1392;if(_0x1f4395[_0x476d('0x37')][_0x476d('0x45')]){_0x2594b2[_0x476d('0x46')]=[{'all':!![]}];}return db[_0x476d('0x31')][_0x476d('0x47')](_0x2594b2);})[_0x476d('0x27')](function(_0x40a93c){_0x39e188[_0x476d('0x48')]=_0x40a93c;return _0x39e188;})[_0x476d('0x27')](respondWithFilteredResult(_0x15783c,_0x2594b2))[_0x476d('0x49')](handleError(_0x15783c,null));};exports[_0x476d('0x4a')]=function(_0x3acb2c,_0x3556eb){var _0x190e97={'raw':!![],'where':{'id':_0x3acb2c[_0x476d('0x4b')]['id']}},_0x543583={};_0x543583[_0x476d('0x36')]=_[_0x476d('0x38')](db['SquareOdbc']['rawAttributes']);_0x543583['query']=_[_0x476d('0x38')](_0x3acb2c[_0x476d('0x37')]);_0x543583[_0x476d('0x39')]=_['intersection'](_0x543583[_0x476d('0x36')],_0x543583['query']);_0x190e97['attributes']=_['intersection'](_0x543583[_0x476d('0x36')],qs['fields'](_0x3acb2c[_0x476d('0x37')][_0x476d('0x3b')]));_0x190e97[_0x476d('0x3c')]=_0x190e97[_0x476d('0x3c')]['length']?_0x190e97['attributes']:_0x543583[_0x476d('0x36')];if(_0x3acb2c[_0x476d('0x37')]['includeAll']){_0x190e97[_0x476d('0x46')]=[{'all':!![]}];}_0x190e97=_[_0x476d('0x42')]({},_0x190e97,_0x3acb2c[_0x476d('0x44')]);return db[_0x476d('0x31')][_0x476d('0x4c')](_0x190e97)[_0x476d('0x27')](handleEntityNotFound(_0x3556eb,null))['then'](respondWithResult(_0x3556eb,null))['catch'](handleError(_0x3556eb,null));};exports[_0x476d('0x4d')]=function(_0x267a3f,_0x4cbc37){return db[_0x476d('0x31')][_0x476d('0x4d')](_0x267a3f[_0x476d('0x4e')],{})['then'](function(_0x465022){var _0x202712=_0x267a3f[_0x476d('0x4f')][_0x476d('0x50')]({'plain':!![]});if(!_0x202712)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x202712[_0x476d('0x51')]==='user'){var _0x395916=_0x465022[_0x476d('0x50')]({'plain':!![]});var _0x5615e4=_0x476d('0x52');return db['UserProfileSection'][_0x476d('0x4c')]({'where':{'name':_0x5615e4,'userProfileId':_0x202712['userProfileId']},'raw':!![]})[_0x476d('0x27')](function(_0x3f86d3){if(_0x3f86d3&&_0x3f86d3['autoAssociation']===0x0){return db[_0x476d('0x29')][_0x476d('0x4d')]({'name':_0x395916[_0x476d('0x2d')],'resourceId':_0x395916['id'],'type':_0x3f86d3[_0x476d('0x2d')],'sectionId':_0x3f86d3['id']},{})[_0x476d('0x27')](function(){return _0x465022;});}else{return _0x465022;}})[_0x476d('0x49')](function(_0x3bd85c){logger[_0x476d('0x2b')](_0x476d('0x53'),_0x3bd85c);throw _0x3bd85c;});}return _0x465022;})['then'](respondWithResult(_0x4cbc37,0xc9))[_0x476d('0x49')](handleError(_0x4cbc37,null));};exports[_0x476d('0x26')]=function(_0x268255,_0x2758e9){if(_0x268255[_0x476d('0x4e')]['id']){delete _0x268255[_0x476d('0x4e')]['id'];}return db[_0x476d('0x31')]['find']({'where':{'id':_0x268255['params']['id']}})[_0x476d('0x27')](handleEntityNotFound(_0x2758e9,null))[_0x476d('0x27')](saveUpdates(_0x268255['body'],null))['then'](respondWithResult(_0x2758e9,null))[_0x476d('0x49')](handleError(_0x2758e9,null));};exports[_0x476d('0x28')]=function(_0x263f66,_0x269e7a){return db[_0x476d('0x31')][_0x476d('0x4c')]({'where':{'id':_0x263f66[_0x476d('0x4b')]['id']}})[_0x476d('0x27')](handleEntityNotFound(_0x269e7a,null))['then'](removeEntity(_0x269e7a,null))[_0x476d('0x49')](handleError(_0x269e7a,null));};exports['test']=function(_0x1e987a,_0x29dfeb,_0xb6935d){var _0x10bdb9;return db[_0x476d('0x31')]['find']({'where':{'id':_0x1e987a['params']['id']},'attributes':['id','dsn']})[_0x476d('0x27')](handleEntityNotFound(_0x29dfeb,null))['then'](function(_0x5524f9){if(_0x5524f9){var _0x4720d6=require(_0x476d('0x54'))();_0x4720d6['openSync'](_0x5524f9['dsn']);_0x4720d6[_0x476d('0x55')]();return _0x5524f9;}})[_0x476d('0x27')](respondWithResult(_0x29dfeb,null))[_0x476d('0x49')](handleError(_0x29dfeb,null));};