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 _0x35ae=['rawAttributes','fieldName','key','model','map','query','keys','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','pick','filters','merge','where','type','VIRTUAL','filter','includeAll','findAll','rows','catch','show','params','include','options','find','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','test','dsn','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','status','offset','undefined','limit','count','set','Content-Range','json','reject','save','destroy','then','get','ODBC','end','error','stack','name','send','index','SquareOdbc'];(function(_0x1b9257,_0x238441){var _0x7fb9b7=function(_0x23441c){while(--_0x23441c){_0x1b9257['push'](_0x1b9257['shift']());}};_0x7fb9b7(++_0x238441);}(_0x35ae,0xe9));var _0xe35a=function(_0x1bda37,_0x239c41){_0x1bda37=_0x1bda37-0x0;var _0x51bf0f=_0x35ae[_0x1bda37];return _0x51bf0f;};'use strict';var emlformat=require(_0xe35a('0x0'));var rimraf=require(_0xe35a('0x1'));var zipdir=require(_0xe35a('0x2'));var jsonpatch=require(_0xe35a('0x3'));var rp=require(_0xe35a('0x4'));var moment=require(_0xe35a('0x5'));var BPromise=require(_0xe35a('0x6'));var Mustache=require('mustache');var util=require(_0xe35a('0x7'));var path=require(_0xe35a('0x8'));var sox=require(_0xe35a('0x9'));var csv=require(_0xe35a('0xa'));var ejs=require(_0xe35a('0xb'));var fs=require('fs');var fs_extra=require(_0xe35a('0xc'));var _=require(_0xe35a('0xd'));var squel=require(_0xe35a('0xe'));var crypto=require(_0xe35a('0xf'));var jsforce=require(_0xe35a('0x10'));var deskjs=require(_0xe35a('0x11'));var toCsv=require(_0xe35a('0xa'));var querystring=require('querystring');var Papa=require(_0xe35a('0x12'));var Redis=require(_0xe35a('0x13'));var authService=require('../../components/auth/service');var qs=require(_0xe35a('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xe35a('0x15'));var logger=require(_0xe35a('0x16'))(_0xe35a('0x17'));var utils=require(_0xe35a('0x18'));var config=require(_0xe35a('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0xe35a('0x1a'))['db'];function respondWithStatusCode(_0x28612c,_0x4623a0){_0x4623a0=_0x4623a0||0xcc;return function(_0x2f034f){if(_0x2f034f){return _0x28612c[_0xe35a('0x1b')](_0x4623a0);}return _0x28612c['status'](_0x4623a0)['end']();};}function respondWithResult(_0x542efa,_0x629376){_0x629376=_0x629376||0xc8;return function(_0x48e177){if(_0x48e177){return _0x542efa[_0xe35a('0x1c')](_0x629376)['json'](_0x48e177);}};}function respondWithFilteredResult(_0x28ad36,_0x3b6363){return function(_0x33e47a){if(_0x33e47a){var _0x2f14fe=typeof _0x3b6363[_0xe35a('0x1d')]===_0xe35a('0x1e')&&typeof _0x3b6363[_0xe35a('0x1f')]===_0xe35a('0x1e');var _0x32440e=_0x33e47a[_0xe35a('0x20')];var _0x5ea3a8=_0x2f14fe?0x0:_0x3b6363[_0xe35a('0x1d')];var _0x5a7047=_0x2f14fe?_0x33e47a[_0xe35a('0x20')]:_0x3b6363[_0xe35a('0x1d')]+_0x3b6363[_0xe35a('0x1f')];var _0xf8a606;if(_0x5a7047>=_0x32440e){_0x5a7047=_0x32440e;_0xf8a606=0xc8;}else{_0xf8a606=0xce;}_0x28ad36[_0xe35a('0x1c')](_0xf8a606);return _0x28ad36[_0xe35a('0x21')](_0xe35a('0x22'),_0x5ea3a8+'-'+_0x5a7047+'/'+_0x32440e)[_0xe35a('0x23')](_0x33e47a);}return null;};}function patchUpdates(_0x4e5561){return function(_0x4f37df){try{jsonpatch['apply'](_0x4f37df,_0x4e5561,!![]);}catch(_0xc2b243){return BPromise[_0xe35a('0x24')](_0xc2b243);}return _0x4f37df[_0xe35a('0x25')]();};}function saveUpdates(_0x357d5d,_0x37d31d){return function(_0x290fb0){if(_0x290fb0){return _0x290fb0['update'](_0x357d5d)['then'](function(_0x21d522){return _0x21d522;});}return null;};}function removeEntity(_0x4abf25,_0x346a05){return function(_0x49b8fb){if(_0x49b8fb){return _0x49b8fb[_0xe35a('0x26')]()[_0xe35a('0x27')](function(){var _0x4a1d76=_0x49b8fb[_0xe35a('0x28')]({'plain':!![]});var _0x5d2c94=_0xe35a('0x29');return db['UserProfileResource']['destroy']({'where':{'type':_0x5d2c94,'resourceId':_0x4a1d76['id']}})['then'](function(){return _0x49b8fb;});})[_0xe35a('0x27')](function(){_0x4abf25[_0xe35a('0x1c')](0xcc)[_0xe35a('0x2a')]();});}};}function handleEntityNotFound(_0xbd32c7,_0x5d4917){return function(_0xa0006a){if(!_0xa0006a){_0xbd32c7[_0xe35a('0x1b')](0x194);}return _0xa0006a;};}function handleError(_0x2b6ece,_0x134440){_0x134440=_0x134440||0x1f4;return function(_0x590e8a){logger[_0xe35a('0x2b')](_0x590e8a[_0xe35a('0x2c')]);if(_0x590e8a[_0xe35a('0x2d')]){delete _0x590e8a[_0xe35a('0x2d')];}_0x2b6ece[_0xe35a('0x1c')](_0x134440)[_0xe35a('0x2e')](_0x590e8a);};}exports[_0xe35a('0x2f')]=function(_0x4ab6a6,_0x496518){var _0x403a3a={},_0x3d8a11={},_0xeb3629={'count':0x0,'rows':[]};var _0x56631a=_['map'](db[_0xe35a('0x30')][_0xe35a('0x31')],function(_0x31f10a){return{'name':_0x31f10a[_0xe35a('0x32')],'type':_0x31f10a['type'][_0xe35a('0x33')]};});_0x3d8a11[_0xe35a('0x34')]=_[_0xe35a('0x35')](_0x56631a,_0xe35a('0x2d'));_0x3d8a11[_0xe35a('0x36')]=_[_0xe35a('0x37')](_0x4ab6a6[_0xe35a('0x36')]);_0x3d8a11['filters']=_[_0xe35a('0x38')](_0x3d8a11[_0xe35a('0x34')],_0x3d8a11[_0xe35a('0x36')]);_0x403a3a[_0xe35a('0x39')]=_[_0xe35a('0x38')](_0x3d8a11[_0xe35a('0x34')],qs[_0xe35a('0x3a')](_0x4ab6a6[_0xe35a('0x36')][_0xe35a('0x3a')]));_0x403a3a[_0xe35a('0x39')]=_0x403a3a[_0xe35a('0x39')][_0xe35a('0x3b')]?_0x403a3a[_0xe35a('0x39')]:_0x3d8a11[_0xe35a('0x34')];if(!_0x4ab6a6[_0xe35a('0x36')][_0xe35a('0x3c')](_0xe35a('0x3d'))){_0x403a3a['limit']=qs[_0xe35a('0x1f')](_0x4ab6a6['query'][_0xe35a('0x1f')]);_0x403a3a[_0xe35a('0x1d')]=qs['offset'](_0x4ab6a6[_0xe35a('0x36')][_0xe35a('0x1d')]);}_0x403a3a[_0xe35a('0x3e')]=qs['sort'](_0x4ab6a6['query'][_0xe35a('0x3f')]);_0x403a3a['where']=qs['filters'](_[_0xe35a('0x40')](_0x4ab6a6[_0xe35a('0x36')],_0x3d8a11[_0xe35a('0x41')]),_0x56631a);if(_0x4ab6a6[_0xe35a('0x36')]['filter']){_0x403a3a['where']=_[_0xe35a('0x42')](_0x403a3a[_0xe35a('0x43')],{'$or':_['map'](_0x56631a,function(_0x52ae17){if(_0x52ae17[_0xe35a('0x44')]!==_0xe35a('0x45')){var _0x5047ac={};_0x5047ac[_0x52ae17['name']]={'$like':'%'+_0x4ab6a6[_0xe35a('0x36')][_0xe35a('0x46')]+'%'};return _0x5047ac;}})});}_0x403a3a=_[_0xe35a('0x42')]({},_0x403a3a,_0x4ab6a6['options']);var _0x1c2d68={'where':_0x403a3a['where']};return db['SquareOdbc'][_0xe35a('0x20')](_0x1c2d68)[_0xe35a('0x27')](function(_0x536610){_0xeb3629[_0xe35a('0x20')]=_0x536610;if(_0x4ab6a6[_0xe35a('0x36')][_0xe35a('0x47')]){_0x403a3a['include']=[{'all':!![]}];}return db['SquareOdbc'][_0xe35a('0x48')](_0x403a3a);})[_0xe35a('0x27')](function(_0x465d45){_0xeb3629[_0xe35a('0x49')]=_0x465d45;return _0xeb3629;})[_0xe35a('0x27')](respondWithFilteredResult(_0x496518,_0x403a3a))[_0xe35a('0x4a')](handleError(_0x496518,null));};exports[_0xe35a('0x4b')]=function(_0x1446f5,_0xb45e02){var _0x35c328={'raw':!![],'where':{'id':_0x1446f5[_0xe35a('0x4c')]['id']}},_0x58dbe3={};_0x58dbe3[_0xe35a('0x34')]=_[_0xe35a('0x37')](db['SquareOdbc'][_0xe35a('0x31')]);_0x58dbe3[_0xe35a('0x36')]=_[_0xe35a('0x37')](_0x1446f5[_0xe35a('0x36')]);_0x58dbe3['filters']=_[_0xe35a('0x38')](_0x58dbe3[_0xe35a('0x34')],_0x58dbe3[_0xe35a('0x36')]);_0x35c328[_0xe35a('0x39')]=_[_0xe35a('0x38')](_0x58dbe3[_0xe35a('0x34')],qs[_0xe35a('0x3a')](_0x1446f5[_0xe35a('0x36')][_0xe35a('0x3a')]));_0x35c328[_0xe35a('0x39')]=_0x35c328[_0xe35a('0x39')]['length']?_0x35c328[_0xe35a('0x39')]:_0x58dbe3[_0xe35a('0x34')];if(_0x1446f5[_0xe35a('0x36')][_0xe35a('0x47')]){_0x35c328[_0xe35a('0x4d')]=[{'all':!![]}];}_0x35c328=_['merge']({},_0x35c328,_0x1446f5[_0xe35a('0x4e')]);return db['SquareOdbc'][_0xe35a('0x4f')](_0x35c328)[_0xe35a('0x27')](handleEntityNotFound(_0xb45e02,null))[_0xe35a('0x27')](respondWithResult(_0xb45e02,null))['catch'](handleError(_0xb45e02,null));};exports['create']=function(_0x429cd3,_0xfb559e){return db[_0xe35a('0x30')][_0xe35a('0x50')](_0x429cd3['body'],{})[_0xe35a('0x27')](function(_0x585228){var _0x50d3a7=_0x429cd3[_0xe35a('0x51')][_0xe35a('0x28')]({'plain':!![]});if(!_0x50d3a7)throw new Error(_0xe35a('0x52'));if(_0x50d3a7[_0xe35a('0x53')]===_0xe35a('0x51')){var _0x3dee96=_0x585228[_0xe35a('0x28')]({'plain':!![]});var _0x25c570=_0xe35a('0x29');return db[_0xe35a('0x54')][_0xe35a('0x4f')]({'where':{'name':_0x25c570,'userProfileId':_0x50d3a7['userProfileId']},'raw':!![]})[_0xe35a('0x27')](function(_0x211c65){if(_0x211c65&&_0x211c65[_0xe35a('0x55')]===0x0){return db[_0xe35a('0x56')][_0xe35a('0x50')]({'name':_0x3dee96[_0xe35a('0x2d')],'resourceId':_0x3dee96['id'],'type':_0x211c65[_0xe35a('0x2d')],'sectionId':_0x211c65['id']},{})[_0xe35a('0x27')](function(){return _0x585228;});}else{return _0x585228;}})[_0xe35a('0x4a')](function(_0xb90e41){logger['error'](_0xe35a('0x57'),_0xb90e41);throw _0xb90e41;});}return _0x585228;})[_0xe35a('0x27')](respondWithResult(_0xfb559e,0xc9))['catch'](handleError(_0xfb559e,null));};exports[_0xe35a('0x58')]=function(_0x56f2ea,_0x46b8f){if(_0x56f2ea[_0xe35a('0x59')]['id']){delete _0x56f2ea['body']['id'];}return db[_0xe35a('0x30')][_0xe35a('0x4f')]({'where':{'id':_0x56f2ea[_0xe35a('0x4c')]['id']}})[_0xe35a('0x27')](handleEntityNotFound(_0x46b8f,null))[_0xe35a('0x27')](saveUpdates(_0x56f2ea['body'],null))[_0xe35a('0x27')](respondWithResult(_0x46b8f,null))['catch'](handleError(_0x46b8f,null));};exports['destroy']=function(_0x3e93f5,_0x53ebda){return db[_0xe35a('0x30')]['find']({'where':{'id':_0x3e93f5[_0xe35a('0x4c')]['id']}})[_0xe35a('0x27')](handleEntityNotFound(_0x53ebda,null))[_0xe35a('0x27')](removeEntity(_0x53ebda,null))[_0xe35a('0x4a')](handleError(_0x53ebda,null));};exports[_0xe35a('0x5a')]=function(_0x1209af,_0x2d17cd,_0x56707e){var _0x1e22ad;return db[_0xe35a('0x30')][_0xe35a('0x4f')]({'where':{'id':_0x1209af['params']['id']},'attributes':['id',_0xe35a('0x5b')]})[_0xe35a('0x27')](handleEntityNotFound(_0x2d17cd,null))[_0xe35a('0x27')](function(_0x4fd735){if(_0x4fd735){var _0x2b9908=require('odbc')();_0x2b9908[_0xe35a('0x5c')](_0x4fd735[_0xe35a('0x5b')]);_0x2b9908[_0xe35a('0x5d')]();return _0x4fd735;}})[_0xe35a('0x27')](respondWithResult(_0x2d17cd,null))[_0xe35a('0x4a')](handleError(_0x2d17cd,null));};