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 _0x98f1=['merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','params','keys','rawAttributes','length','find','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','test','dsn','odbc','closeSync','eml-format','rimraf','moment','bluebird','mustache','util','sox','to-csv','fs-extra','lodash','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','undefined','limit','count','set','Content-Range','json','reject','save','then','get','ODBC','destroy','error','stack','name','send','index','map','SquareOdbc','fieldName','key','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','where'];(function(_0x38a6c6,_0x4062ca){var _0x142f0a=function(_0x1531ce){while(--_0x1531ce){_0x38a6c6['push'](_0x38a6c6['shift']());}};_0x142f0a(++_0x4062ca);}(_0x98f1,0x11d));var _0x198f=function(_0x57b90c,_0x36d5e8){_0x57b90c=_0x57b90c-0x0;var _0x15eefd=_0x98f1[_0x57b90c];return _0x15eefd;};'use strict';var emlformat=require(_0x198f('0x0'));var rimraf=require(_0x198f('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x198f('0x2'));var BPromise=require(_0x198f('0x3'));var Mustache=require(_0x198f('0x4'));var util=require(_0x198f('0x5'));var path=require('path');var sox=require(_0x198f('0x6'));var csv=require(_0x198f('0x7'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x198f('0x8'));var _=require(_0x198f('0x9'));var squel=require('squel');var crypto=require(_0x198f('0xa'));var jsforce=require(_0x198f('0xb'));var deskjs=require(_0x198f('0xc'));var toCsv=require(_0x198f('0x7'));var querystring=require('querystring');var Papa=require(_0x198f('0xd'));var Redis=require(_0x198f('0xe'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x198f('0xf'));var hardwareService=require(_0x198f('0x10'));var logger=require('../../config/logger')(_0x198f('0x11'));var utils=require('../../config/utils');var config=require(_0x198f('0x12'));var licenseUtil=require(_0x198f('0x13'));var db=require(_0x198f('0x14'))['db'];function respondWithStatusCode(_0x17c418,_0x436e05){_0x436e05=_0x436e05||0xcc;return function(_0x5e3302){if(_0x5e3302){return _0x17c418[_0x198f('0x15')](_0x436e05);}return _0x17c418[_0x198f('0x16')](_0x436e05)[_0x198f('0x17')]();};}function respondWithResult(_0x9c9b00,_0x2068f7){_0x2068f7=_0x2068f7||0xc8;return function(_0x597c6b){if(_0x597c6b){return _0x9c9b00['status'](_0x2068f7)['json'](_0x597c6b);}};}function respondWithFilteredResult(_0x4df78a,_0x3d6029){return function(_0x103c59){if(_0x103c59){var _0x3721a3=typeof _0x3d6029[_0x198f('0x18')]===_0x198f('0x19')&&typeof _0x3d6029[_0x198f('0x1a')]==='undefined';var _0x160ea9=_0x103c59[_0x198f('0x1b')];var _0x5a6d4e=_0x3721a3?0x0:_0x3d6029[_0x198f('0x18')];var _0xbb25d=_0x3721a3?_0x103c59[_0x198f('0x1b')]:_0x3d6029[_0x198f('0x18')]+_0x3d6029[_0x198f('0x1a')];var _0x40131f;if(_0xbb25d>=_0x160ea9){_0xbb25d=_0x160ea9;_0x40131f=0xc8;}else{_0x40131f=0xce;}_0x4df78a[_0x198f('0x16')](_0x40131f);return _0x4df78a[_0x198f('0x1c')](_0x198f('0x1d'),_0x5a6d4e+'-'+_0xbb25d+'/'+_0x160ea9)[_0x198f('0x1e')](_0x103c59);}return null;};}function patchUpdates(_0x185c88){return function(_0x316d62){try{jsonpatch['apply'](_0x316d62,_0x185c88,!![]);}catch(_0x19b5e5){return BPromise[_0x198f('0x1f')](_0x19b5e5);}return _0x316d62[_0x198f('0x20')]();};}function saveUpdates(_0x15c157,_0xd8186c){return function(_0x2cc657){if(_0x2cc657){return _0x2cc657['update'](_0x15c157)[_0x198f('0x21')](function(_0x128e1c){return _0x128e1c;});}return null;};}function removeEntity(_0x47115f,_0x1a1c47){return function(_0x1e50c4){if(_0x1e50c4){return _0x1e50c4['destroy']()[_0x198f('0x21')](function(){var _0x4f7f70=_0x1e50c4[_0x198f('0x22')]({'plain':!![]});var _0x1cc0e1=_0x198f('0x23');return db['UserProfileResource'][_0x198f('0x24')]({'where':{'type':_0x1cc0e1,'resourceId':_0x4f7f70['id']}})[_0x198f('0x21')](function(){return _0x1e50c4;});})['then'](function(){_0x47115f[_0x198f('0x16')](0xcc)[_0x198f('0x17')]();});}};}function handleEntityNotFound(_0x21e4f2,_0x234a32){return function(_0x1be597){if(!_0x1be597){_0x21e4f2['sendStatus'](0x194);}return _0x1be597;};}function handleError(_0x54c355,_0x50c495){_0x50c495=_0x50c495||0x1f4;return function(_0x35a7bd){logger[_0x198f('0x25')](_0x35a7bd[_0x198f('0x26')]);if(_0x35a7bd[_0x198f('0x27')]){delete _0x35a7bd[_0x198f('0x27')];}_0x54c355[_0x198f('0x16')](_0x50c495)[_0x198f('0x28')](_0x35a7bd);};}exports[_0x198f('0x29')]=function(_0x2d1c14,_0x1ff775){var _0x3ae64d={},_0x2bc24a={},_0x512ccf={'count':0x0,'rows':[]};var _0x1ea539=_[_0x198f('0x2a')](db[_0x198f('0x2b')]['rawAttributes'],function(_0x520018){return{'name':_0x520018[_0x198f('0x2c')],'type':_0x520018['type'][_0x198f('0x2d')]};});_0x2bc24a[_0x198f('0x2e')]=_['map'](_0x1ea539,_0x198f('0x27'));_0x2bc24a[_0x198f('0x2f')]=_['keys'](_0x2d1c14['query']);_0x2bc24a[_0x198f('0x30')]=_[_0x198f('0x31')](_0x2bc24a[_0x198f('0x2e')],_0x2bc24a[_0x198f('0x2f')]);_0x3ae64d[_0x198f('0x32')]=_[_0x198f('0x31')](_0x2bc24a[_0x198f('0x2e')],qs['fields'](_0x2d1c14[_0x198f('0x2f')][_0x198f('0x33')]));_0x3ae64d[_0x198f('0x32')]=_0x3ae64d[_0x198f('0x32')]['length']?_0x3ae64d[_0x198f('0x32')]:_0x2bc24a[_0x198f('0x2e')];if(!_0x2d1c14[_0x198f('0x2f')][_0x198f('0x34')](_0x198f('0x35'))){_0x3ae64d['limit']=qs[_0x198f('0x1a')](_0x2d1c14['query'][_0x198f('0x1a')]);_0x3ae64d[_0x198f('0x18')]=qs[_0x198f('0x18')](_0x2d1c14[_0x198f('0x2f')][_0x198f('0x18')]);}_0x3ae64d[_0x198f('0x36')]=qs[_0x198f('0x37')](_0x2d1c14['query'][_0x198f('0x37')]);_0x3ae64d['where']=qs[_0x198f('0x30')](_[_0x198f('0x38')](_0x2d1c14[_0x198f('0x2f')],_0x2bc24a[_0x198f('0x30')]),_0x1ea539);if(_0x2d1c14['query'][_0x198f('0x39')]){_0x3ae64d[_0x198f('0x3a')]=_[_0x198f('0x3b')](_0x3ae64d['where'],{'$or':_['map'](_0x1ea539,function(_0x4071fc){if(_0x4071fc['type']!==_0x198f('0x3c')){var _0x19abb5={};_0x19abb5[_0x4071fc[_0x198f('0x27')]]={'$like':'%'+_0x2d1c14[_0x198f('0x2f')][_0x198f('0x39')]+'%'};return _0x19abb5;}})});}_0x3ae64d=_[_0x198f('0x3b')]({},_0x3ae64d,_0x2d1c14[_0x198f('0x3d')]);var _0x254687={'where':_0x3ae64d[_0x198f('0x3a')]};return db[_0x198f('0x2b')]['count'](_0x254687)[_0x198f('0x21')](function(_0xc2c294){_0x512ccf[_0x198f('0x1b')]=_0xc2c294;if(_0x2d1c14['query'][_0x198f('0x3e')]){_0x3ae64d[_0x198f('0x3f')]=[{'all':!![]}];}return db[_0x198f('0x2b')][_0x198f('0x40')](_0x3ae64d);})[_0x198f('0x21')](function(_0xeea6d3){_0x512ccf[_0x198f('0x41')]=_0xeea6d3;return _0x512ccf;})[_0x198f('0x21')](respondWithFilteredResult(_0x1ff775,_0x3ae64d))[_0x198f('0x42')](handleError(_0x1ff775,null));};exports['show']=function(_0x44fbb3,_0x5ff9d2){var _0xae67b={'raw':!![],'where':{'id':_0x44fbb3[_0x198f('0x43')]['id']}},_0x2292b4={};_0x2292b4['model']=_[_0x198f('0x44')](db[_0x198f('0x2b')][_0x198f('0x45')]);_0x2292b4[_0x198f('0x2f')]=_[_0x198f('0x44')](_0x44fbb3[_0x198f('0x2f')]);_0x2292b4['filters']=_['intersection'](_0x2292b4[_0x198f('0x2e')],_0x2292b4['query']);_0xae67b['attributes']=_[_0x198f('0x31')](_0x2292b4[_0x198f('0x2e')],qs['fields'](_0x44fbb3[_0x198f('0x2f')][_0x198f('0x33')]));_0xae67b[_0x198f('0x32')]=_0xae67b[_0x198f('0x32')][_0x198f('0x46')]?_0xae67b['attributes']:_0x2292b4['model'];if(_0x44fbb3['query']['includeAll']){_0xae67b[_0x198f('0x3f')]=[{'all':!![]}];}_0xae67b=_[_0x198f('0x3b')]({},_0xae67b,_0x44fbb3[_0x198f('0x3d')]);return db[_0x198f('0x2b')][_0x198f('0x47')](_0xae67b)[_0x198f('0x21')](handleEntityNotFound(_0x5ff9d2,null))[_0x198f('0x21')](respondWithResult(_0x5ff9d2,null))['catch'](handleError(_0x5ff9d2,null));};exports[_0x198f('0x48')]=function(_0xe02d0,_0x440907){return db[_0x198f('0x2b')][_0x198f('0x48')](_0xe02d0[_0x198f('0x49')],{})[_0x198f('0x21')](function(_0x1d5730){var _0xf326da=_0xe02d0[_0x198f('0x4a')][_0x198f('0x22')]({'plain':!![]});if(!_0xf326da)throw new Error(_0x198f('0x4b'));if(_0xf326da[_0x198f('0x4c')]==='user'){var _0x4b1277=_0x1d5730[_0x198f('0x22')]({'plain':!![]});var _0x24ddff='ODBC';return db[_0x198f('0x4d')]['find']({'where':{'name':_0x24ddff,'userProfileId':_0xf326da[_0x198f('0x4e')]},'raw':!![]})[_0x198f('0x21')](function(_0x138a70){if(_0x138a70&&_0x138a70[_0x198f('0x4f')]===0x0){return db['UserProfileResource']['create']({'name':_0x4b1277['name'],'resourceId':_0x4b1277['id'],'type':_0x138a70[_0x198f('0x27')],'sectionId':_0x138a70['id']},{})['then'](function(){return _0x1d5730;});}else{return _0x1d5730;}})[_0x198f('0x42')](function(_0x2f3c0a){logger[_0x198f('0x25')](_0x198f('0x50'),_0x2f3c0a);throw _0x2f3c0a;});}return _0x1d5730;})[_0x198f('0x21')](respondWithResult(_0x440907,0xc9))['catch'](handleError(_0x440907,null));};exports[_0x198f('0x51')]=function(_0x370143,_0x4e82b6){if(_0x370143[_0x198f('0x49')]['id']){delete _0x370143[_0x198f('0x49')]['id'];}return db[_0x198f('0x2b')][_0x198f('0x47')]({'where':{'id':_0x370143[_0x198f('0x43')]['id']}})[_0x198f('0x21')](handleEntityNotFound(_0x4e82b6,null))[_0x198f('0x21')](saveUpdates(_0x370143[_0x198f('0x49')],null))['then'](respondWithResult(_0x4e82b6,null))['catch'](handleError(_0x4e82b6,null));};exports[_0x198f('0x24')]=function(_0x353417,_0x33736a){return db[_0x198f('0x2b')][_0x198f('0x47')]({'where':{'id':_0x353417[_0x198f('0x43')]['id']}})[_0x198f('0x21')](handleEntityNotFound(_0x33736a,null))[_0x198f('0x21')](removeEntity(_0x33736a,null))[_0x198f('0x42')](handleError(_0x33736a,null));};exports[_0x198f('0x52')]=function(_0x177d6b,_0x197fe4,_0x5c02c6){var _0x362015;return db['SquareOdbc'][_0x198f('0x47')]({'where':{'id':_0x177d6b['params']['id']},'attributes':['id',_0x198f('0x53')]})[_0x198f('0x21')](handleEntityNotFound(_0x197fe4,null))[_0x198f('0x21')](function(_0x4f3206){if(_0x4f3206){var _0x4f8cd0=require(_0x198f('0x54'))();_0x4f8cd0['openSync'](_0x4f3206['dsn']);_0x4f8cd0[_0x198f('0x55')]();return _0x4f3206;}})[_0x198f('0x21')](respondWithResult(_0x197fe4,null))[_0x198f('0x42')](handleError(_0x197fe4,null));};