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 _0x06b3=['rimraf','zip-dir','fast-json-patch','request-promise','moment','mustache','util','path','sox','to-csv','ejs','crypto','desk.js','querystring','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','Content-Range','save','then','destroy','get','stack','send','index','map','SquareOdbc','rawAttributes','fieldName','type','key','model','name','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','show','params','find','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','ODBC','UserProfileSection','userProfileId','autoAssociation','UserProfileResource','error','body','test','openSync','dsn','html-pdf','eml-format'];(function(_0x13cd39,_0xeab85e){var _0xb28ea=function(_0x1b4ebc){while(--_0x1b4ebc){_0x13cd39['push'](_0x13cd39['shift']());}};_0xb28ea(++_0xeab85e);}(_0x06b3,0x1f0));var _0x306b=function(_0x3b1c1d,_0x33e5e3){_0x3b1c1d=_0x3b1c1d-0x0;var _0x1bda8d=_0x06b3[_0x3b1c1d];return _0x1bda8d;};'use strict';var pdf=require(_0x306b('0x0'));var emlformat=require(_0x306b('0x1'));var rimraf=require(_0x306b('0x2'));var zipdir=require(_0x306b('0x3'));var jsonpatch=require(_0x306b('0x4'));var rp=require(_0x306b('0x5'));var moment=require(_0x306b('0x6'));var BPromise=require('bluebird');var Mustache=require(_0x306b('0x7'));var util=require(_0x306b('0x8'));var path=require(_0x306b('0x9'));var sox=require(_0x306b('0xa'));var csv=require(_0x306b('0xb'));var ejs=require(_0x306b('0xc'));var fs=require('fs');var _=require('lodash');var squel=require('squel');var crypto=require(_0x306b('0xd'));var jsforce=require('jsforce');var deskjs=require(_0x306b('0xe'));var toCsv=require(_0x306b('0xb'));var querystring=require(_0x306b('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x306b('0x10'));var as=require(_0x306b('0x11'));var hardwareService=require(_0x306b('0x12'));var logger=require(_0x306b('0x13'))(_0x306b('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x306b('0x15'));var db=require(_0x306b('0x16'))['db'];function respondWithStatusCode(_0x2b8540,_0x1abad6){_0x1abad6=_0x1abad6||0xcc;return function(_0x54e148){if(_0x54e148){return _0x2b8540[_0x306b('0x17')](_0x1abad6);}return _0x2b8540[_0x306b('0x18')](_0x1abad6)[_0x306b('0x19')]();};}function respondWithResult(_0x122a40,_0x30c9bf){_0x30c9bf=_0x30c9bf||0xc8;return function(_0x5ca08d){if(_0x5ca08d){return _0x122a40[_0x306b('0x18')](_0x30c9bf)[_0x306b('0x1a')](_0x5ca08d);}};}function respondWithFilteredResult(_0x10df79,_0x38a14c){return function(_0xa5f843){if(_0xa5f843){var _0xc64040=_0xa5f843[_0x306b('0x1b')],_0x542ab7=_0x38a14c['offset'],_0x281547=_0x38a14c[_0x306b('0x1c')]+_0x38a14c['limit'],_0x4ab6ed;if(_0x281547>=_0xc64040){_0x281547=_0xc64040;_0x4ab6ed=0xc8;}else{_0x4ab6ed=0xce;}_0x10df79[_0x306b('0x18')](_0x4ab6ed);return _0x10df79['set'](_0x306b('0x1d'),_0x542ab7+'-'+_0x281547+'/'+_0xc64040)[_0x306b('0x1a')](_0xa5f843);}return null;};}function patchUpdates(_0x51c9b3){return function(_0x394e33){try{jsonpatch['apply'](_0x394e33,_0x51c9b3,!![]);}catch(_0x5b23d9){return BPromise['reject'](_0x5b23d9);}return _0x394e33[_0x306b('0x1e')]();};}function saveUpdates(_0x5425a9,_0x3b6a66){return function(_0x2f8fd){if(_0x2f8fd){return _0x2f8fd['update'](_0x5425a9)[_0x306b('0x1f')](function(_0x37c2b6){return _0x37c2b6;});}return null;};}function removeEntity(_0x55295b,_0x11bd01){return function(_0x47e922){if(_0x47e922){return _0x47e922[_0x306b('0x20')]()[_0x306b('0x1f')](function(){var _0x12ada6=_0x47e922[_0x306b('0x21')]({'plain':!![]});var _0x191438='ODBC';return db['UserProfileResource'][_0x306b('0x20')]({'where':{'type':_0x191438,'resourceId':_0x12ada6['id']}})['then'](function(){return _0x47e922;});})[_0x306b('0x1f')](function(){_0x55295b[_0x306b('0x18')](0xcc)['end']();});}};}function handleEntityNotFound(_0x35b0af,_0x314a3d){return function(_0x5cf89b){if(!_0x5cf89b){_0x35b0af[_0x306b('0x17')](0x194);}return _0x5cf89b;};}function handleError(_0x10df93,_0x162de4){_0x162de4=_0x162de4||0x1f4;return function(_0x454075){logger['error'](_0x454075[_0x306b('0x22')]);if(_0x454075['name']){delete _0x454075['name'];}_0x10df93[_0x306b('0x18')](_0x162de4)[_0x306b('0x23')](_0x454075);};}exports[_0x306b('0x24')]=function(_0x4971bd,_0x43a214){var _0x2ec99f={},_0x5179ba={},_0x5c58d2={'count':0x0,'rows':[]};var _0x3f8161=_[_0x306b('0x25')](db[_0x306b('0x26')][_0x306b('0x27')],function(_0x10db51){return{'name':_0x10db51[_0x306b('0x28')],'type':_0x10db51[_0x306b('0x29')][_0x306b('0x2a')]};});_0x5179ba[_0x306b('0x2b')]=_['map'](_0x3f8161,_0x306b('0x2c'));_0x5179ba[_0x306b('0x2d')]=_[_0x306b('0x2e')](_0x4971bd[_0x306b('0x2d')]);_0x5179ba[_0x306b('0x2f')]=_[_0x306b('0x30')](_0x5179ba[_0x306b('0x2b')],_0x5179ba[_0x306b('0x2d')]);_0x2ec99f[_0x306b('0x31')]=_[_0x306b('0x30')](_0x5179ba[_0x306b('0x2b')],qs['fields'](_0x4971bd[_0x306b('0x2d')][_0x306b('0x32')]));_0x2ec99f['attributes']=_0x2ec99f['attributes'][_0x306b('0x33')]?_0x2ec99f[_0x306b('0x31')]:_0x5179ba['model'];if(!_0x4971bd[_0x306b('0x2d')][_0x306b('0x34')](_0x306b('0x35'))){_0x2ec99f[_0x306b('0x36')]=qs['limit'](_0x4971bd[_0x306b('0x2d')]['limit']);_0x2ec99f[_0x306b('0x1c')]=qs['offset'](_0x4971bd[_0x306b('0x2d')]['offset']);}_0x2ec99f[_0x306b('0x37')]=qs['sort'](_0x4971bd[_0x306b('0x2d')][_0x306b('0x38')]);_0x2ec99f[_0x306b('0x39')]=qs['filters'](_['pick'](_0x4971bd[_0x306b('0x2d')],_0x5179ba[_0x306b('0x2f')]),_0x3f8161);if(_0x4971bd[_0x306b('0x2d')][_0x306b('0x3a')]){_0x2ec99f[_0x306b('0x39')]=_['merge'](_0x2ec99f[_0x306b('0x39')],{'$or':_['map'](_0x3f8161,function(_0x5963d2){if(_0x5963d2['type']!==_0x306b('0x3b')){var _0x7d311a={};_0x7d311a[_0x5963d2[_0x306b('0x2c')]]={'$like':'%'+_0x4971bd['query']['filter']+'%'};return _0x7d311a;}})});}_0x2ec99f=_[_0x306b('0x3c')]({},_0x2ec99f,_0x4971bd[_0x306b('0x3d')]);var _0x1778a6={'where':_0x2ec99f[_0x306b('0x39')]};return db['SquareOdbc']['count'](_0x1778a6)[_0x306b('0x1f')](function(_0x1101b5){_0x5c58d2[_0x306b('0x1b')]=_0x1101b5;if(_0x4971bd[_0x306b('0x2d')][_0x306b('0x3e')]){_0x2ec99f[_0x306b('0x3f')]=[{'all':!![]}];}return db[_0x306b('0x26')][_0x306b('0x40')](_0x2ec99f);})[_0x306b('0x1f')](function(_0x45e507){_0x5c58d2[_0x306b('0x41')]=_0x45e507;return _0x5c58d2;})[_0x306b('0x1f')](respondWithFilteredResult(_0x43a214,_0x2ec99f))['catch'](handleError(_0x43a214,null));};exports[_0x306b('0x42')]=function(_0x28380c,_0x432de6){var _0x5adcd6={'raw':!![],'where':{'id':_0x28380c[_0x306b('0x43')]['id']}},_0x545405={};_0x545405['model']=_[_0x306b('0x2e')](db[_0x306b('0x26')][_0x306b('0x27')]);_0x545405[_0x306b('0x2d')]=_[_0x306b('0x2e')](_0x28380c[_0x306b('0x2d')]);_0x545405[_0x306b('0x2f')]=_[_0x306b('0x30')](_0x545405[_0x306b('0x2b')],_0x545405[_0x306b('0x2d')]);_0x5adcd6[_0x306b('0x31')]=_[_0x306b('0x30')](_0x545405['model'],qs[_0x306b('0x32')](_0x28380c['query'][_0x306b('0x32')]));_0x5adcd6['attributes']=_0x5adcd6[_0x306b('0x31')][_0x306b('0x33')]?_0x5adcd6['attributes']:_0x545405[_0x306b('0x2b')];if(_0x28380c[_0x306b('0x2d')][_0x306b('0x3e')]){_0x5adcd6[_0x306b('0x3f')]=[{'all':!![]}];}_0x5adcd6=_[_0x306b('0x3c')]({},_0x5adcd6,_0x28380c[_0x306b('0x3d')]);return db[_0x306b('0x26')][_0x306b('0x44')](_0x5adcd6)[_0x306b('0x1f')](handleEntityNotFound(_0x432de6,null))['then'](respondWithResult(_0x432de6,null))[_0x306b('0x45')](handleError(_0x432de6,null));};exports[_0x306b('0x46')]=function(_0x23f59d,_0x1d2270){return db[_0x306b('0x26')][_0x306b('0x46')](_0x23f59d['body'],{})[_0x306b('0x1f')](function(_0x2a7f66){var _0x146d05=_0x23f59d[_0x306b('0x47')]['get']({'plain':!![]});if(!_0x146d05)throw new Error(_0x306b('0x48'));if(_0x146d05['role']===_0x306b('0x47')){var _0x1fa569=_0x2a7f66[_0x306b('0x21')]({'plain':!![]});var _0x2e0585=_0x306b('0x49');return db[_0x306b('0x4a')][_0x306b('0x44')]({'where':{'name':_0x2e0585,'userProfileId':_0x146d05[_0x306b('0x4b')]},'raw':!![]})[_0x306b('0x1f')](function(_0xe8b8b2){if(_0xe8b8b2&&_0xe8b8b2[_0x306b('0x4c')]===0x0){return db[_0x306b('0x4d')][_0x306b('0x46')]({'name':_0x1fa569[_0x306b('0x2c')],'resourceId':_0x1fa569['id'],'type':_0xe8b8b2[_0x306b('0x2c')],'sectionId':_0xe8b8b2['id']},{})[_0x306b('0x1f')](function(){return _0x2a7f66;});}else{return _0x2a7f66;}})[_0x306b('0x45')](function(_0x4cab86){logger[_0x306b('0x4e')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x4cab86);throw _0x4cab86;});}return _0x2a7f66;})[_0x306b('0x1f')](respondWithResult(_0x1d2270,0xc9))[_0x306b('0x45')](handleError(_0x1d2270,null));};exports['update']=function(_0x381578,_0x8af322){if(_0x381578['body']['id']){delete _0x381578[_0x306b('0x4f')]['id'];}return db[_0x306b('0x26')][_0x306b('0x44')]({'where':{'id':_0x381578[_0x306b('0x43')]['id']}})['then'](handleEntityNotFound(_0x8af322,null))['then'](saveUpdates(_0x381578[_0x306b('0x4f')],null))[_0x306b('0x1f')](respondWithResult(_0x8af322,null))[_0x306b('0x45')](handleError(_0x8af322,null));};exports[_0x306b('0x20')]=function(_0x87530d,_0x319aa1){return db['SquareOdbc']['find']({'where':{'id':_0x87530d[_0x306b('0x43')]['id']}})[_0x306b('0x1f')](handleEntityNotFound(_0x319aa1,null))[_0x306b('0x1f')](removeEntity(_0x319aa1,null))['catch'](handleError(_0x319aa1,null));};exports[_0x306b('0x50')]=function(_0x265599,_0x154e3f,_0x2711a3){var _0x927756;return db[_0x306b('0x26')][_0x306b('0x44')]({'where':{'id':_0x265599[_0x306b('0x43')]['id']},'attributes':['id','dsn']})[_0x306b('0x1f')](handleEntityNotFound(_0x154e3f,null))[_0x306b('0x1f')](function(_0x4841e6){if(_0x4841e6){var _0x32778d=require('odbc')();_0x32778d[_0x306b('0x51')](_0x4841e6[_0x306b('0x52')]);_0x32778d['closeSync']();return _0x4841e6;}})['then'](respondWithResult(_0x154e3f,null))['catch'](handleError(_0x154e3f,null));};