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 _0xb878=['userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','test','dsn','odbc','openSync','closeSync','rimraf','fast-json-patch','moment','bluebird','mustache','path','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','json','offset','undefined','count','limit','status','set','Content-Range','reject','save','then','destroy','ODBC','error','stack','name','send','index','map','SquareOdbc','rawAttributes','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','include','findAll','rows','catch','show','params','includeAll','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','get','UserProfileSection'];(function(_0x429f8d,_0x304058){var _0x50fc79=function(_0x3a1570){while(--_0x3a1570){_0x429f8d['push'](_0x429f8d['shift']());}};_0x50fc79(++_0x304058);}(_0xb878,0x1cc));var _0x8b87=function(_0x3dd15e,_0x1f0015){_0x3dd15e=_0x3dd15e-0x0;var _0x231fd0=_0xb878[_0x3dd15e];return _0x231fd0;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x8b87('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x8b87('0x1'));var rp=require('request-promise');var moment=require(_0x8b87('0x2'));var BPromise=require(_0x8b87('0x3'));var Mustache=require(_0x8b87('0x4'));var util=require('util');var path=require(_0x8b87('0x5'));var sox=require(_0x8b87('0x6'));var csv=require('to-csv');var ejs=require(_0x8b87('0x7'));var fs=require('fs');var fs_extra=require(_0x8b87('0x8'));var _=require(_0x8b87('0x9'));var squel=require('squel');var crypto=require(_0x8b87('0xa'));var jsforce=require(_0x8b87('0xb'));var deskjs=require(_0x8b87('0xc'));var toCsv=require('to-csv');var querystring=require(_0x8b87('0xd'));var Papa=require(_0x8b87('0xe'));var Redis=require(_0x8b87('0xf'));var authService=require('../../components/auth/service');var qs=require(_0x8b87('0x10'));var as=require(_0x8b87('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x8b87('0x12'))(_0x8b87('0x13'));var utils=require(_0x8b87('0x14'));var config=require(_0x8b87('0x15'));var licenseUtil=require(_0x8b87('0x16'));var db=require(_0x8b87('0x17'))['db'];function respondWithStatusCode(_0xa1bd1c,_0x1c54c9){_0x1c54c9=_0x1c54c9||0xcc;return function(_0x2f3557){if(_0x2f3557){return _0xa1bd1c[_0x8b87('0x18')](_0x1c54c9);}return _0xa1bd1c['status'](_0x1c54c9)[_0x8b87('0x19')]();};}function respondWithResult(_0x520576,_0x3ff7b3){_0x3ff7b3=_0x3ff7b3||0xc8;return function(_0x2ed842){if(_0x2ed842){return _0x520576['status'](_0x3ff7b3)[_0x8b87('0x1a')](_0x2ed842);}};}function respondWithFilteredResult(_0xa5b935,_0x1e10a6){return function(_0x1c7118){if(_0x1c7118){var _0x44e1fb=typeof _0x1e10a6[_0x8b87('0x1b')]===_0x8b87('0x1c')&&typeof _0x1e10a6['limit']===_0x8b87('0x1c');var _0x1fbbbf=_0x1c7118[_0x8b87('0x1d')];var _0x3b901b=_0x44e1fb?0x0:_0x1e10a6[_0x8b87('0x1b')];var _0x4ad72d=_0x44e1fb?_0x1c7118['count']:_0x1e10a6[_0x8b87('0x1b')]+_0x1e10a6[_0x8b87('0x1e')];var _0x922fe3;if(_0x4ad72d>=_0x1fbbbf){_0x4ad72d=_0x1fbbbf;_0x922fe3=0xc8;}else{_0x922fe3=0xce;}_0xa5b935[_0x8b87('0x1f')](_0x922fe3);return _0xa5b935[_0x8b87('0x20')](_0x8b87('0x21'),_0x3b901b+'-'+_0x4ad72d+'/'+_0x1fbbbf)['json'](_0x1c7118);}return null;};}function patchUpdates(_0x57de67){return function(_0x4f6b91){try{jsonpatch['apply'](_0x4f6b91,_0x57de67,!![]);}catch(_0x56281c){return BPromise[_0x8b87('0x22')](_0x56281c);}return _0x4f6b91[_0x8b87('0x23')]();};}function saveUpdates(_0x5985cd,_0x11288b){return function(_0x7a15db){if(_0x7a15db){return _0x7a15db['update'](_0x5985cd)[_0x8b87('0x24')](function(_0x22b184){return _0x22b184;});}return null;};}function removeEntity(_0x4c8ba3,_0x5c9a99){return function(_0x3755cd){if(_0x3755cd){return _0x3755cd[_0x8b87('0x25')]()[_0x8b87('0x24')](function(){var _0x1b1c74=_0x3755cd['get']({'plain':!![]});var _0x5d24ad=_0x8b87('0x26');return db['UserProfileResource'][_0x8b87('0x25')]({'where':{'type':_0x5d24ad,'resourceId':_0x1b1c74['id']}})[_0x8b87('0x24')](function(){return _0x3755cd;});})[_0x8b87('0x24')](function(){_0x4c8ba3[_0x8b87('0x1f')](0xcc)[_0x8b87('0x19')]();});}};}function handleEntityNotFound(_0x26ef57,_0x4cf6a7){return function(_0x586bc4){if(!_0x586bc4){_0x26ef57[_0x8b87('0x18')](0x194);}return _0x586bc4;};}function handleError(_0x2dfc70,_0x5409b5){_0x5409b5=_0x5409b5||0x1f4;return function(_0x2ddb37){logger[_0x8b87('0x27')](_0x2ddb37[_0x8b87('0x28')]);if(_0x2ddb37[_0x8b87('0x29')]){delete _0x2ddb37[_0x8b87('0x29')];}_0x2dfc70[_0x8b87('0x1f')](_0x5409b5)[_0x8b87('0x2a')](_0x2ddb37);};}exports[_0x8b87('0x2b')]=function(_0x4d9538,_0x2a60f9){var _0x34efc6={},_0x45677b={},_0x564c4d={'count':0x0,'rows':[]};var _0x3f0cc1=_[_0x8b87('0x2c')](db[_0x8b87('0x2d')][_0x8b87('0x2e')],function(_0x5b404c){return{'name':_0x5b404c[_0x8b87('0x2f')],'type':_0x5b404c['type'][_0x8b87('0x30')]};});_0x45677b[_0x8b87('0x31')]=_[_0x8b87('0x2c')](_0x3f0cc1,_0x8b87('0x29'));_0x45677b[_0x8b87('0x32')]=_[_0x8b87('0x33')](_0x4d9538[_0x8b87('0x32')]);_0x45677b[_0x8b87('0x34')]=_[_0x8b87('0x35')](_0x45677b[_0x8b87('0x31')],_0x45677b[_0x8b87('0x32')]);_0x34efc6[_0x8b87('0x36')]=_['intersection'](_0x45677b['model'],qs['fields'](_0x4d9538[_0x8b87('0x32')][_0x8b87('0x37')]));_0x34efc6[_0x8b87('0x36')]=_0x34efc6['attributes'][_0x8b87('0x38')]?_0x34efc6[_0x8b87('0x36')]:_0x45677b[_0x8b87('0x31')];if(!_0x4d9538[_0x8b87('0x32')][_0x8b87('0x39')](_0x8b87('0x3a'))){_0x34efc6['limit']=qs[_0x8b87('0x1e')](_0x4d9538['query'][_0x8b87('0x1e')]);_0x34efc6[_0x8b87('0x1b')]=qs[_0x8b87('0x1b')](_0x4d9538[_0x8b87('0x32')][_0x8b87('0x1b')]);}_0x34efc6[_0x8b87('0x3b')]=qs[_0x8b87('0x3c')](_0x4d9538[_0x8b87('0x32')][_0x8b87('0x3c')]);_0x34efc6[_0x8b87('0x3d')]=qs['filters'](_[_0x8b87('0x3e')](_0x4d9538[_0x8b87('0x32')],_0x45677b[_0x8b87('0x34')]),_0x3f0cc1);if(_0x4d9538[_0x8b87('0x32')][_0x8b87('0x3f')]){_0x34efc6[_0x8b87('0x3d')]=_[_0x8b87('0x40')](_0x34efc6[_0x8b87('0x3d')],{'$or':_[_0x8b87('0x2c')](_0x3f0cc1,function(_0x5a1f55){if(_0x5a1f55['type']!==_0x8b87('0x41')){var _0x2c318a={};_0x2c318a[_0x5a1f55['name']]={'$like':'%'+_0x4d9538[_0x8b87('0x32')]['filter']+'%'};return _0x2c318a;}})});}_0x34efc6=_[_0x8b87('0x40')]({},_0x34efc6,_0x4d9538[_0x8b87('0x42')]);var _0x2bd816={'where':_0x34efc6['where']};return db[_0x8b87('0x2d')]['count'](_0x2bd816)['then'](function(_0x571e68){_0x564c4d['count']=_0x571e68;if(_0x4d9538[_0x8b87('0x32')]['includeAll']){_0x34efc6[_0x8b87('0x43')]=[{'all':!![]}];}return db['SquareOdbc'][_0x8b87('0x44')](_0x34efc6);})[_0x8b87('0x24')](function(_0x3a6ebc){_0x564c4d[_0x8b87('0x45')]=_0x3a6ebc;return _0x564c4d;})[_0x8b87('0x24')](respondWithFilteredResult(_0x2a60f9,_0x34efc6))[_0x8b87('0x46')](handleError(_0x2a60f9,null));};exports[_0x8b87('0x47')]=function(_0x416358,_0x5653a3){var _0x361827={'raw':!![],'where':{'id':_0x416358[_0x8b87('0x48')]['id']}},_0x1710bf={};_0x1710bf[_0x8b87('0x31')]=_[_0x8b87('0x33')](db['SquareOdbc']['rawAttributes']);_0x1710bf['query']=_['keys'](_0x416358[_0x8b87('0x32')]);_0x1710bf[_0x8b87('0x34')]=_[_0x8b87('0x35')](_0x1710bf[_0x8b87('0x31')],_0x1710bf['query']);_0x361827[_0x8b87('0x36')]=_['intersection'](_0x1710bf['model'],qs[_0x8b87('0x37')](_0x416358[_0x8b87('0x32')]['fields']));_0x361827[_0x8b87('0x36')]=_0x361827['attributes'][_0x8b87('0x38')]?_0x361827[_0x8b87('0x36')]:_0x1710bf[_0x8b87('0x31')];if(_0x416358[_0x8b87('0x32')][_0x8b87('0x49')]){_0x361827[_0x8b87('0x43')]=[{'all':!![]}];}_0x361827=_[_0x8b87('0x40')]({},_0x361827,_0x416358['options']);return db['SquareOdbc'][_0x8b87('0x4a')](_0x361827)['then'](handleEntityNotFound(_0x5653a3,null))[_0x8b87('0x24')](respondWithResult(_0x5653a3,null))[_0x8b87('0x46')](handleError(_0x5653a3,null));};exports['create']=function(_0x553ac6,_0x128069){return db[_0x8b87('0x2d')][_0x8b87('0x4b')](_0x553ac6['body'],{})['then'](function(_0x11c919){var _0x3a004b=_0x553ac6[_0x8b87('0x4c')]['get']({'plain':!![]});if(!_0x3a004b)throw new Error(_0x8b87('0x4d'));if(_0x3a004b['role']===_0x8b87('0x4c')){var _0x25d217=_0x11c919[_0x8b87('0x4e')]({'plain':!![]});var _0x2461dc='ODBC';return db[_0x8b87('0x4f')][_0x8b87('0x4a')]({'where':{'name':_0x2461dc,'userProfileId':_0x3a004b[_0x8b87('0x50')]},'raw':!![]})[_0x8b87('0x24')](function(_0x6e4ad1){if(_0x6e4ad1&&_0x6e4ad1[_0x8b87('0x51')]===0x0){return db['UserProfileResource'][_0x8b87('0x4b')]({'name':_0x25d217[_0x8b87('0x29')],'resourceId':_0x25d217['id'],'type':_0x6e4ad1[_0x8b87('0x29')],'sectionId':_0x6e4ad1['id']},{})[_0x8b87('0x24')](function(){return _0x11c919;});}else{return _0x11c919;}})[_0x8b87('0x46')](function(_0x132b23){logger[_0x8b87('0x27')](_0x8b87('0x52'),_0x132b23);throw _0x132b23;});}return _0x11c919;})['then'](respondWithResult(_0x128069,0xc9))[_0x8b87('0x46')](handleError(_0x128069,null));};exports[_0x8b87('0x53')]=function(_0x4bbee2,_0xa677ef){if(_0x4bbee2[_0x8b87('0x54')]['id']){delete _0x4bbee2[_0x8b87('0x54')]['id'];}return db['SquareOdbc']['find']({'where':{'id':_0x4bbee2[_0x8b87('0x48')]['id']}})[_0x8b87('0x24')](handleEntityNotFound(_0xa677ef,null))[_0x8b87('0x24')](saveUpdates(_0x4bbee2[_0x8b87('0x54')],null))[_0x8b87('0x24')](respondWithResult(_0xa677ef,null))[_0x8b87('0x46')](handleError(_0xa677ef,null));};exports['destroy']=function(_0x5e0218,_0x2480e4){return db[_0x8b87('0x2d')][_0x8b87('0x4a')]({'where':{'id':_0x5e0218[_0x8b87('0x48')]['id']}})['then'](handleEntityNotFound(_0x2480e4,null))['then'](removeEntity(_0x2480e4,null))[_0x8b87('0x46')](handleError(_0x2480e4,null));};exports[_0x8b87('0x55')]=function(_0x4363c6,_0x466b8e,_0x13a168){var _0x3ebadf;return db[_0x8b87('0x2d')]['find']({'where':{'id':_0x4363c6['params']['id']},'attributes':['id',_0x8b87('0x56')]})[_0x8b87('0x24')](handleEntityNotFound(_0x466b8e,null))['then'](function(_0x22417d){if(_0x22417d){var _0x2fbd1a=require(_0x8b87('0x57'))();_0x2fbd1a[_0x8b87('0x58')](_0x22417d[_0x8b87('0x56')]);_0x2fbd1a[_0x8b87('0x59')]();return _0x22417d;}})[_0x8b87('0x24')](respondWithResult(_0x466b8e,null))[_0x8b87('0x46')](handleError(_0x466b8e,null));};