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 _0x1a58=['then','destroy','get','UserProfileResource','end','error','name','send','index','map','SquareOdbc','rawAttributes','fieldName','key','query','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','filter','type','VIRTUAL','merge','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','ODBC','userProfileId','autoAssociation','test','dsn','odbc','openSync','eml-format','rimraf','bluebird','mustache','util','path','sox','to-csv','fs-extra','lodash','squel','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','offset','undefined','limit','count','set','Content-Range','json','reject','save','update'];(function(_0x32edbf,_0x4fda99){var _0xb6bdf5=function(_0x3b4fd2){while(--_0x3b4fd2){_0x32edbf['push'](_0x32edbf['shift']());}};_0xb6bdf5(++_0x4fda99);}(_0x1a58,0x1e1));var _0x81a5=function(_0xb53ca5,_0x435d3f){_0xb53ca5=_0xb53ca5-0x0;var _0x11f18e=_0x1a58[_0xb53ca5];return _0x11f18e;};'use strict';var emlformat=require(_0x81a5('0x0'));var rimraf=require(_0x81a5('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require('moment');var BPromise=require(_0x81a5('0x2'));var Mustache=require(_0x81a5('0x3'));var util=require(_0x81a5('0x4'));var path=require(_0x81a5('0x5'));var sox=require(_0x81a5('0x6'));var csv=require(_0x81a5('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x81a5('0x8'));var _=require(_0x81a5('0x9'));var squel=require(_0x81a5('0xa'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x81a5('0xb'));var toCsv=require(_0x81a5('0x7'));var querystring=require(_0x81a5('0xc'));var Papa=require(_0x81a5('0xd'));var Redis=require(_0x81a5('0xe'));var authService=require(_0x81a5('0xf'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x81a5('0x10'));var logger=require(_0x81a5('0x11'))(_0x81a5('0x12'));var utils=require(_0x81a5('0x13'));var config=require(_0x81a5('0x14'));var licenseUtil=require(_0x81a5('0x15'));var db=require(_0x81a5('0x16'))['db'];function respondWithStatusCode(_0x1769f0,_0x9b28da){_0x9b28da=_0x9b28da||0xcc;return function(_0x32c499){if(_0x32c499){return _0x1769f0[_0x81a5('0x17')](_0x9b28da);}return _0x1769f0[_0x81a5('0x18')](_0x9b28da)['end']();};}function respondWithResult(_0x1b5816,_0x22eac2){_0x22eac2=_0x22eac2||0xc8;return function(_0x228bc1){if(_0x228bc1){return _0x1b5816[_0x81a5('0x18')](_0x22eac2)['json'](_0x228bc1);}};}function respondWithFilteredResult(_0x33ff2b,_0x100c10){return function(_0x254fcd){if(_0x254fcd){var _0x34302e=typeof _0x100c10[_0x81a5('0x19')]===_0x81a5('0x1a')&&typeof _0x100c10[_0x81a5('0x1b')]===_0x81a5('0x1a');var _0x49cd49=_0x254fcd['count'];var _0x2148a1=_0x34302e?0x0:_0x100c10[_0x81a5('0x19')];var _0x11766b=_0x34302e?_0x254fcd[_0x81a5('0x1c')]:_0x100c10[_0x81a5('0x19')]+_0x100c10['limit'];var _0x12fe3b;if(_0x11766b>=_0x49cd49){_0x11766b=_0x49cd49;_0x12fe3b=0xc8;}else{_0x12fe3b=0xce;}_0x33ff2b['status'](_0x12fe3b);return _0x33ff2b[_0x81a5('0x1d')](_0x81a5('0x1e'),_0x2148a1+'-'+_0x11766b+'/'+_0x49cd49)[_0x81a5('0x1f')](_0x254fcd);}return null;};}function patchUpdates(_0x7a0f71){return function(_0x3faa73){try{jsonpatch['apply'](_0x3faa73,_0x7a0f71,!![]);}catch(_0x5bc073){return BPromise[_0x81a5('0x20')](_0x5bc073);}return _0x3faa73[_0x81a5('0x21')]();};}function saveUpdates(_0x27ef50,_0x1804d1){return function(_0x3109e7){if(_0x3109e7){return _0x3109e7[_0x81a5('0x22')](_0x27ef50)[_0x81a5('0x23')](function(_0x4ece17){return _0x4ece17;});}return null;};}function removeEntity(_0x4461cd,_0x4ac377){return function(_0x45c781){if(_0x45c781){return _0x45c781[_0x81a5('0x24')]()['then'](function(){var _0x3fd5cd=_0x45c781[_0x81a5('0x25')]({'plain':!![]});var _0x56169d='ODBC';return db[_0x81a5('0x26')]['destroy']({'where':{'type':_0x56169d,'resourceId':_0x3fd5cd['id']}})['then'](function(){return _0x45c781;});})[_0x81a5('0x23')](function(){_0x4461cd[_0x81a5('0x18')](0xcc)[_0x81a5('0x27')]();});}};}function handleEntityNotFound(_0x419d27,_0x466046){return function(_0x39a959){if(!_0x39a959){_0x419d27[_0x81a5('0x17')](0x194);}return _0x39a959;};}function handleError(_0x32e1d8,_0x3217eb){_0x3217eb=_0x3217eb||0x1f4;return function(_0x432ffc){logger[_0x81a5('0x28')](_0x432ffc['stack']);if(_0x432ffc['name']){delete _0x432ffc[_0x81a5('0x29')];}_0x32e1d8[_0x81a5('0x18')](_0x3217eb)[_0x81a5('0x2a')](_0x432ffc);};}exports[_0x81a5('0x2b')]=function(_0x5d0c20,_0x15e887){var _0x8bc634={},_0x2a6c47={},_0x26aa11={'count':0x0,'rows':[]};var _0x30e8f5=_[_0x81a5('0x2c')](db[_0x81a5('0x2d')][_0x81a5('0x2e')],function(_0x32ffc7){return{'name':_0x32ffc7[_0x81a5('0x2f')],'type':_0x32ffc7['type'][_0x81a5('0x30')]};});_0x2a6c47['model']=_['map'](_0x30e8f5,_0x81a5('0x29'));_0x2a6c47['query']=_['keys'](_0x5d0c20[_0x81a5('0x31')]);_0x2a6c47['filters']=_[_0x81a5('0x32')](_0x2a6c47[_0x81a5('0x33')],_0x2a6c47[_0x81a5('0x31')]);_0x8bc634[_0x81a5('0x34')]=_[_0x81a5('0x32')](_0x2a6c47[_0x81a5('0x33')],qs[_0x81a5('0x35')](_0x5d0c20[_0x81a5('0x31')][_0x81a5('0x35')]));_0x8bc634['attributes']=_0x8bc634[_0x81a5('0x34')][_0x81a5('0x36')]?_0x8bc634[_0x81a5('0x34')]:_0x2a6c47['model'];if(!_0x5d0c20['query'][_0x81a5('0x37')](_0x81a5('0x38'))){_0x8bc634[_0x81a5('0x1b')]=qs['limit'](_0x5d0c20[_0x81a5('0x31')][_0x81a5('0x1b')]);_0x8bc634[_0x81a5('0x19')]=qs[_0x81a5('0x19')](_0x5d0c20['query'][_0x81a5('0x19')]);}_0x8bc634[_0x81a5('0x39')]=qs[_0x81a5('0x3a')](_0x5d0c20['query'][_0x81a5('0x3a')]);_0x8bc634[_0x81a5('0x3b')]=qs['filters'](_['pick'](_0x5d0c20['query'],_0x2a6c47[_0x81a5('0x3c')]),_0x30e8f5);if(_0x5d0c20[_0x81a5('0x31')][_0x81a5('0x3d')]){_0x8bc634[_0x81a5('0x3b')]=_['merge'](_0x8bc634[_0x81a5('0x3b')],{'$or':_['map'](_0x30e8f5,function(_0x150af6){if(_0x150af6[_0x81a5('0x3e')]!==_0x81a5('0x3f')){var _0x2f0e14={};_0x2f0e14[_0x150af6[_0x81a5('0x29')]]={'$like':'%'+_0x5d0c20[_0x81a5('0x31')][_0x81a5('0x3d')]+'%'};return _0x2f0e14;}})});}_0x8bc634=_[_0x81a5('0x40')]({},_0x8bc634,_0x5d0c20[_0x81a5('0x41')]);var _0x444d93={'where':_0x8bc634[_0x81a5('0x3b')]};return db[_0x81a5('0x2d')][_0x81a5('0x1c')](_0x444d93)[_0x81a5('0x23')](function(_0x590556){_0x26aa11[_0x81a5('0x1c')]=_0x590556;if(_0x5d0c20[_0x81a5('0x31')][_0x81a5('0x42')]){_0x8bc634[_0x81a5('0x43')]=[{'all':!![]}];}return db[_0x81a5('0x2d')][_0x81a5('0x44')](_0x8bc634);})[_0x81a5('0x23')](function(_0x391523){_0x26aa11[_0x81a5('0x45')]=_0x391523;return _0x26aa11;})[_0x81a5('0x23')](respondWithFilteredResult(_0x15e887,_0x8bc634))[_0x81a5('0x46')](handleError(_0x15e887,null));};exports[_0x81a5('0x47')]=function(_0x58e492,_0x2b16f1){var _0x2f8b0d={'raw':!![],'where':{'id':_0x58e492[_0x81a5('0x48')]['id']}},_0x2c2e64={};_0x2c2e64[_0x81a5('0x33')]=_[_0x81a5('0x49')](db[_0x81a5('0x2d')]['rawAttributes']);_0x2c2e64['query']=_[_0x81a5('0x49')](_0x58e492['query']);_0x2c2e64[_0x81a5('0x3c')]=_[_0x81a5('0x32')](_0x2c2e64[_0x81a5('0x33')],_0x2c2e64[_0x81a5('0x31')]);_0x2f8b0d[_0x81a5('0x34')]=_['intersection'](_0x2c2e64[_0x81a5('0x33')],qs['fields'](_0x58e492['query'][_0x81a5('0x35')]));_0x2f8b0d['attributes']=_0x2f8b0d[_0x81a5('0x34')][_0x81a5('0x36')]?_0x2f8b0d[_0x81a5('0x34')]:_0x2c2e64['model'];if(_0x58e492['query'][_0x81a5('0x42')]){_0x2f8b0d[_0x81a5('0x43')]=[{'all':!![]}];}_0x2f8b0d=_[_0x81a5('0x40')]({},_0x2f8b0d,_0x58e492[_0x81a5('0x41')]);return db[_0x81a5('0x2d')][_0x81a5('0x4a')](_0x2f8b0d)[_0x81a5('0x23')](handleEntityNotFound(_0x2b16f1,null))[_0x81a5('0x23')](respondWithResult(_0x2b16f1,null))[_0x81a5('0x46')](handleError(_0x2b16f1,null));};exports[_0x81a5('0x4b')]=function(_0x27233e,_0x29c661){return db[_0x81a5('0x2d')][_0x81a5('0x4b')](_0x27233e[_0x81a5('0x4c')],{})[_0x81a5('0x23')](function(_0x15cbc4){var _0x43cb33=_0x27233e[_0x81a5('0x4d')]['get']({'plain':!![]});if(!_0x43cb33)throw new Error(_0x81a5('0x4e'));if(_0x43cb33['role']===_0x81a5('0x4d')){var _0x21abcd=_0x15cbc4[_0x81a5('0x25')]({'plain':!![]});var _0xfba403=_0x81a5('0x4f');return db['UserProfileSection'][_0x81a5('0x4a')]({'where':{'name':_0xfba403,'userProfileId':_0x43cb33[_0x81a5('0x50')]},'raw':!![]})[_0x81a5('0x23')](function(_0x201c10){if(_0x201c10&&_0x201c10[_0x81a5('0x51')]===0x0){return db[_0x81a5('0x26')][_0x81a5('0x4b')]({'name':_0x21abcd[_0x81a5('0x29')],'resourceId':_0x21abcd['id'],'type':_0x201c10[_0x81a5('0x29')],'sectionId':_0x201c10['id']},{})[_0x81a5('0x23')](function(){return _0x15cbc4;});}else{return _0x15cbc4;}})[_0x81a5('0x46')](function(_0x34b3e1){logger['error']('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x34b3e1);throw _0x34b3e1;});}return _0x15cbc4;})['then'](respondWithResult(_0x29c661,0xc9))[_0x81a5('0x46')](handleError(_0x29c661,null));};exports[_0x81a5('0x22')]=function(_0x20bc06,_0x2e4379){if(_0x20bc06[_0x81a5('0x4c')]['id']){delete _0x20bc06[_0x81a5('0x4c')]['id'];}return db[_0x81a5('0x2d')][_0x81a5('0x4a')]({'where':{'id':_0x20bc06[_0x81a5('0x48')]['id']}})[_0x81a5('0x23')](handleEntityNotFound(_0x2e4379,null))['then'](saveUpdates(_0x20bc06[_0x81a5('0x4c')],null))[_0x81a5('0x23')](respondWithResult(_0x2e4379,null))['catch'](handleError(_0x2e4379,null));};exports[_0x81a5('0x24')]=function(_0x3fe4ef,_0x1f8254){return db['SquareOdbc'][_0x81a5('0x4a')]({'where':{'id':_0x3fe4ef['params']['id']}})['then'](handleEntityNotFound(_0x1f8254,null))[_0x81a5('0x23')](removeEntity(_0x1f8254,null))[_0x81a5('0x46')](handleError(_0x1f8254,null));};exports[_0x81a5('0x52')]=function(_0x282505,_0x4d77ad,_0xb944bb){var _0x3ff0b4;return db[_0x81a5('0x2d')]['find']({'where':{'id':_0x282505['params']['id']},'attributes':['id',_0x81a5('0x53')]})[_0x81a5('0x23')](handleEntityNotFound(_0x4d77ad,null))[_0x81a5('0x23')](function(_0xc6dc3){if(_0xc6dc3){var _0x344ed3=require(_0x81a5('0x54'))();_0x344ed3[_0x81a5('0x55')](_0xc6dc3['dsn']);_0x344ed3['closeSync']();return _0xc6dc3;}})[_0x81a5('0x23')](respondWithResult(_0x4d77ad,null))['catch'](handleError(_0x4d77ad,null));};