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 _0xc2d3=['undefined','limit','count','set','Content-Range','reject','update','destroy','then','get','ODBC','UserProfileResource','error','stack','name','send','map','SquareOdbc','fieldName','key','model','query','keys','filters','attributes','intersection','fields','hasOwnProperty','order','sort','pick','filter','merge','where','type','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params','rawAttributes','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','autoAssociation','test','odbc','openSync','closeSync','rimraf','zip-dir','fast-json-patch','request-promise','mustache','util','path','sox','fs-extra','squel','crypto','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','end','json','offset'];(function(_0x3db5cb,_0x5e6725){var _0x44c52e=function(_0x3d3a4c){while(--_0x3d3a4c){_0x3db5cb['push'](_0x3db5cb['shift']());}};_0x44c52e(++_0x5e6725);}(_0xc2d3,0x138));var _0x3c2d=function(_0x44a94d,_0x412ed0){_0x44a94d=_0x44a94d-0x0;var _0x4b0282=_0xc2d3[_0x44a94d];return _0x4b0282;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x3c2d('0x0'));var zipdir=require(_0x3c2d('0x1'));var jsonpatch=require(_0x3c2d('0x2'));var rp=require(_0x3c2d('0x3'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x3c2d('0x4'));var util=require(_0x3c2d('0x5'));var path=require(_0x3c2d('0x6'));var sox=require(_0x3c2d('0x7'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x3c2d('0x8'));var _=require('lodash');var squel=require(_0x3c2d('0x9'));var crypto=require(_0x3c2d('0xa'));var jsforce=require('jsforce');var deskjs=require(_0x3c2d('0xb'));var toCsv=require(_0x3c2d('0xc'));var querystring=require(_0x3c2d('0xd'));var Papa=require(_0x3c2d('0xe'));var Redis=require(_0x3c2d('0xf'));var authService=require(_0x3c2d('0x10'));var qs=require(_0x3c2d('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x3c2d('0x12'));var logger=require(_0x3c2d('0x13'))('api');var utils=require(_0x3c2d('0x14'));var config=require(_0x3c2d('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x3c2d('0x16'))['db'];function respondWithStatusCode(_0x3f46b0,_0x2fbb18){_0x2fbb18=_0x2fbb18||0xcc;return function(_0x3d7988){if(_0x3d7988){return _0x3f46b0[_0x3c2d('0x17')](_0x2fbb18);}return _0x3f46b0[_0x3c2d('0x18')](_0x2fbb18)[_0x3c2d('0x19')]();};}function respondWithResult(_0x49eba5,_0x11ae1b){_0x11ae1b=_0x11ae1b||0xc8;return function(_0x46babc){if(_0x46babc){return _0x49eba5[_0x3c2d('0x18')](_0x11ae1b)[_0x3c2d('0x1a')](_0x46babc);}};}function respondWithFilteredResult(_0x472693,_0xcdec3d){return function(_0x47d2c3){if(_0x47d2c3){var _0x140696=typeof _0xcdec3d[_0x3c2d('0x1b')]===_0x3c2d('0x1c')&&typeof _0xcdec3d[_0x3c2d('0x1d')]===_0x3c2d('0x1c');var _0x36b7dc=_0x47d2c3['count'];var _0x169a43=_0x140696?0x0:_0xcdec3d[_0x3c2d('0x1b')];var _0x2258fd=_0x140696?_0x47d2c3[_0x3c2d('0x1e')]:_0xcdec3d[_0x3c2d('0x1b')]+_0xcdec3d[_0x3c2d('0x1d')];var _0x4cf47b;if(_0x2258fd>=_0x36b7dc){_0x2258fd=_0x36b7dc;_0x4cf47b=0xc8;}else{_0x4cf47b=0xce;}_0x472693[_0x3c2d('0x18')](_0x4cf47b);return _0x472693[_0x3c2d('0x1f')](_0x3c2d('0x20'),_0x169a43+'-'+_0x2258fd+'/'+_0x36b7dc)['json'](_0x47d2c3);}return null;};}function patchUpdates(_0x4fc9d7){return function(_0x281d28){try{jsonpatch['apply'](_0x281d28,_0x4fc9d7,!![]);}catch(_0x28fad5){return BPromise[_0x3c2d('0x21')](_0x28fad5);}return _0x281d28['save']();};}function saveUpdates(_0x2c153b,_0x262bfa){return function(_0x159118){if(_0x159118){return _0x159118[_0x3c2d('0x22')](_0x2c153b)['then'](function(_0xe0a758){return _0xe0a758;});}return null;};}function removeEntity(_0x9109ca,_0x3930bc){return function(_0x24620e){if(_0x24620e){return _0x24620e[_0x3c2d('0x23')]()[_0x3c2d('0x24')](function(){var _0x496403=_0x24620e[_0x3c2d('0x25')]({'plain':!![]});var _0x4be893=_0x3c2d('0x26');return db[_0x3c2d('0x27')][_0x3c2d('0x23')]({'where':{'type':_0x4be893,'resourceId':_0x496403['id']}})[_0x3c2d('0x24')](function(){return _0x24620e;});})[_0x3c2d('0x24')](function(){_0x9109ca['status'](0xcc)[_0x3c2d('0x19')]();});}};}function handleEntityNotFound(_0x1bd28a,_0x132199){return function(_0x245d4a){if(!_0x245d4a){_0x1bd28a[_0x3c2d('0x17')](0x194);}return _0x245d4a;};}function handleError(_0x4a0ee2,_0x440001){_0x440001=_0x440001||0x1f4;return function(_0x2f76fe){logger[_0x3c2d('0x28')](_0x2f76fe[_0x3c2d('0x29')]);if(_0x2f76fe[_0x3c2d('0x2a')]){delete _0x2f76fe[_0x3c2d('0x2a')];}_0x4a0ee2['status'](_0x440001)[_0x3c2d('0x2b')](_0x2f76fe);};}exports['index']=function(_0x1c988d,_0x3f4897){var _0x12c056={},_0x1e2a6e={},_0x9dff4b={'count':0x0,'rows':[]};var _0x248b3d=_[_0x3c2d('0x2c')](db[_0x3c2d('0x2d')]['rawAttributes'],function(_0x32190b){return{'name':_0x32190b[_0x3c2d('0x2e')],'type':_0x32190b['type'][_0x3c2d('0x2f')]};});_0x1e2a6e[_0x3c2d('0x30')]=_['map'](_0x248b3d,_0x3c2d('0x2a'));_0x1e2a6e[_0x3c2d('0x31')]=_[_0x3c2d('0x32')](_0x1c988d[_0x3c2d('0x31')]);_0x1e2a6e[_0x3c2d('0x33')]=_['intersection'](_0x1e2a6e[_0x3c2d('0x30')],_0x1e2a6e[_0x3c2d('0x31')]);_0x12c056[_0x3c2d('0x34')]=_[_0x3c2d('0x35')](_0x1e2a6e[_0x3c2d('0x30')],qs['fields'](_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x36')]));_0x12c056['attributes']=_0x12c056[_0x3c2d('0x34')]['length']?_0x12c056[_0x3c2d('0x34')]:_0x1e2a6e['model'];if(!_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x37')]('nolimit')){_0x12c056['limit']=qs[_0x3c2d('0x1d')](_0x1c988d['query'][_0x3c2d('0x1d')]);_0x12c056[_0x3c2d('0x1b')]=qs[_0x3c2d('0x1b')](_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x1b')]);}_0x12c056[_0x3c2d('0x38')]=qs[_0x3c2d('0x39')](_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x39')]);_0x12c056['where']=qs[_0x3c2d('0x33')](_[_0x3c2d('0x3a')](_0x1c988d[_0x3c2d('0x31')],_0x1e2a6e[_0x3c2d('0x33')]),_0x248b3d);if(_0x1c988d['query'][_0x3c2d('0x3b')]){_0x12c056['where']=_[_0x3c2d('0x3c')](_0x12c056[_0x3c2d('0x3d')],{'$or':_[_0x3c2d('0x2c')](_0x248b3d,function(_0x3f96c8){if(_0x3f96c8[_0x3c2d('0x3e')]!==_0x3c2d('0x3f')){var _0x53b824={};_0x53b824[_0x3f96c8[_0x3c2d('0x2a')]]={'$like':'%'+_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x3b')]+'%'};return _0x53b824;}})});}_0x12c056=_[_0x3c2d('0x3c')]({},_0x12c056,_0x1c988d[_0x3c2d('0x40')]);var _0x30a8d9={'where':_0x12c056[_0x3c2d('0x3d')]};return db['SquareOdbc'][_0x3c2d('0x1e')](_0x30a8d9)[_0x3c2d('0x24')](function(_0x3cc727){_0x9dff4b['count']=_0x3cc727;if(_0x1c988d[_0x3c2d('0x31')][_0x3c2d('0x41')]){_0x12c056[_0x3c2d('0x42')]=[{'all':!![]}];}return db[_0x3c2d('0x2d')][_0x3c2d('0x43')](_0x12c056);})[_0x3c2d('0x24')](function(_0x5b9575){_0x9dff4b[_0x3c2d('0x44')]=_0x5b9575;return _0x9dff4b;})[_0x3c2d('0x24')](respondWithFilteredResult(_0x3f4897,_0x12c056))[_0x3c2d('0x45')](handleError(_0x3f4897,null));};exports[_0x3c2d('0x46')]=function(_0x203527,_0x2d8a8f){var _0x4ac419={'raw':!![],'where':{'id':_0x203527[_0x3c2d('0x47')]['id']}},_0x54074c={};_0x54074c[_0x3c2d('0x30')]=_['keys'](db['SquareOdbc'][_0x3c2d('0x48')]);_0x54074c[_0x3c2d('0x31')]=_[_0x3c2d('0x32')](_0x203527[_0x3c2d('0x31')]);_0x54074c['filters']=_[_0x3c2d('0x35')](_0x54074c[_0x3c2d('0x30')],_0x54074c['query']);_0x4ac419[_0x3c2d('0x34')]=_[_0x3c2d('0x35')](_0x54074c[_0x3c2d('0x30')],qs[_0x3c2d('0x36')](_0x203527[_0x3c2d('0x31')]['fields']));_0x4ac419['attributes']=_0x4ac419[_0x3c2d('0x34')][_0x3c2d('0x49')]?_0x4ac419[_0x3c2d('0x34')]:_0x54074c[_0x3c2d('0x30')];if(_0x203527[_0x3c2d('0x31')][_0x3c2d('0x41')]){_0x4ac419[_0x3c2d('0x42')]=[{'all':!![]}];}_0x4ac419=_[_0x3c2d('0x3c')]({},_0x4ac419,_0x203527[_0x3c2d('0x40')]);return db[_0x3c2d('0x2d')][_0x3c2d('0x4a')](_0x4ac419)['then'](handleEntityNotFound(_0x2d8a8f,null))[_0x3c2d('0x24')](respondWithResult(_0x2d8a8f,null))[_0x3c2d('0x45')](handleError(_0x2d8a8f,null));};exports[_0x3c2d('0x4b')]=function(_0x36700f,_0x547f41){return db[_0x3c2d('0x2d')][_0x3c2d('0x4b')](_0x36700f[_0x3c2d('0x4c')],{})[_0x3c2d('0x24')](function(_0x371ecf){var _0x5dafeb=_0x36700f[_0x3c2d('0x4d')]['get']({'plain':!![]});if(!_0x5dafeb)throw new Error(_0x3c2d('0x4e'));if(_0x5dafeb['role']===_0x3c2d('0x4d')){var _0x7c90e4=_0x371ecf['get']({'plain':!![]});var _0x587f4f='ODBC';return db[_0x3c2d('0x4f')][_0x3c2d('0x4a')]({'where':{'name':_0x587f4f,'userProfileId':_0x5dafeb['userProfileId']},'raw':!![]})[_0x3c2d('0x24')](function(_0x66b0e1){if(_0x66b0e1&&_0x66b0e1[_0x3c2d('0x50')]===0x0){return db[_0x3c2d('0x27')][_0x3c2d('0x4b')]({'name':_0x7c90e4[_0x3c2d('0x2a')],'resourceId':_0x7c90e4['id'],'type':_0x66b0e1[_0x3c2d('0x2a')],'sectionId':_0x66b0e1['id']},{})[_0x3c2d('0x24')](function(){return _0x371ecf;});}else{return _0x371ecf;}})[_0x3c2d('0x45')](function(_0x1ab7fc){logger[_0x3c2d('0x28')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x1ab7fc);throw _0x1ab7fc;});}return _0x371ecf;})['then'](respondWithResult(_0x547f41,0xc9))[_0x3c2d('0x45')](handleError(_0x547f41,null));};exports[_0x3c2d('0x22')]=function(_0x3d1ca9,_0x349b0a){if(_0x3d1ca9[_0x3c2d('0x4c')]['id']){delete _0x3d1ca9[_0x3c2d('0x4c')]['id'];}return db[_0x3c2d('0x2d')]['find']({'where':{'id':_0x3d1ca9[_0x3c2d('0x47')]['id']}})[_0x3c2d('0x24')](handleEntityNotFound(_0x349b0a,null))[_0x3c2d('0x24')](saveUpdates(_0x3d1ca9[_0x3c2d('0x4c')],null))[_0x3c2d('0x24')](respondWithResult(_0x349b0a,null))[_0x3c2d('0x45')](handleError(_0x349b0a,null));};exports[_0x3c2d('0x23')]=function(_0xe901c1,_0x22d763){return db[_0x3c2d('0x2d')][_0x3c2d('0x4a')]({'where':{'id':_0xe901c1[_0x3c2d('0x47')]['id']}})[_0x3c2d('0x24')](handleEntityNotFound(_0x22d763,null))[_0x3c2d('0x24')](removeEntity(_0x22d763,null))[_0x3c2d('0x45')](handleError(_0x22d763,null));};exports[_0x3c2d('0x51')]=function(_0x3680b8,_0x2f7dc6,_0x2b84e6){var _0x2ace11;return db['SquareOdbc'][_0x3c2d('0x4a')]({'where':{'id':_0x3680b8['params']['id']},'attributes':['id','dsn']})[_0x3c2d('0x24')](handleEntityNotFound(_0x2f7dc6,null))['then'](function(_0x31270f){if(_0x31270f){var _0x23adf0=require(_0x3c2d('0x52'))();_0x23adf0[_0x3c2d('0x53')](_0x31270f['dsn']);_0x23adf0[_0x3c2d('0x54')]();return _0x31270f;}})['then'](respondWithResult(_0x2f7dc6,null))[_0x3c2d('0x45')](handleError(_0x2f7dc6,null));};