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 _0xd772=['where','pick','merge','name','filter','options','includeAll','include','findAll','rows','show','params','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','find','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','openSync','dsn','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','sox','ejs','fs-extra','lodash','crypto','to-csv','querystring','papaparse','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','get','error','stack','map','SquareOdbc','rawAttributes','fieldName','type','key','model','keys','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort'];(function(_0x2797c5,_0x1eed11){var _0x18b956=function(_0x54464b){while(--_0x54464b){_0x2797c5['push'](_0x2797c5['shift']());}};_0x18b956(++_0x1eed11);}(_0xd772,0x67));var _0x2d77=function(_0x5b2907,_0x91946c){_0x5b2907=_0x5b2907-0x0;var _0x5f40e1=_0xd772[_0x5b2907];return _0x5f40e1;};'use strict';var emlformat=require(_0x2d77('0x0'));var rimraf=require(_0x2d77('0x1'));var zipdir=require(_0x2d77('0x2'));var jsonpatch=require(_0x2d77('0x3'));var rp=require(_0x2d77('0x4'));var moment=require('moment');var BPromise=require(_0x2d77('0x5'));var Mustache=require('mustache');var util=require(_0x2d77('0x6'));var path=require('path');var sox=require(_0x2d77('0x7'));var csv=require('to-csv');var ejs=require(_0x2d77('0x8'));var fs=require('fs');var fs_extra=require(_0x2d77('0x9'));var _=require(_0x2d77('0xa'));var squel=require('squel');var crypto=require(_0x2d77('0xb'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0x2d77('0xc'));var querystring=require(_0x2d77('0xd'));var Papa=require(_0x2d77('0xe'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x2d77('0xf'));var hardwareService=require(_0x2d77('0x10'));var logger=require('../../config/logger')(_0x2d77('0x11'));var utils=require(_0x2d77('0x12'));var config=require(_0x2d77('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x2d77('0x14'))['db'];function respondWithStatusCode(_0x1e4269,_0x4fbb71){_0x4fbb71=_0x4fbb71||0xcc;return function(_0x3786c0){if(_0x3786c0){return _0x1e4269[_0x2d77('0x15')](_0x4fbb71);}return _0x1e4269['status'](_0x4fbb71)[_0x2d77('0x16')]();};}function respondWithResult(_0x3754c0,_0x547c05){_0x547c05=_0x547c05||0xc8;return function(_0x3e3d45){if(_0x3e3d45){return _0x3754c0[_0x2d77('0x17')](_0x547c05)[_0x2d77('0x18')](_0x3e3d45);}};}function respondWithFilteredResult(_0x27b213,_0x3c44a9){return function(_0x558193){if(_0x558193){var _0x35e37d=typeof _0x3c44a9[_0x2d77('0x19')]===_0x2d77('0x1a')&&typeof _0x3c44a9[_0x2d77('0x1b')]===_0x2d77('0x1a');var _0x459143=_0x558193[_0x2d77('0x1c')];var _0x3902fe=_0x35e37d?0x0:_0x3c44a9['offset'];var _0x238cf3=_0x35e37d?_0x558193[_0x2d77('0x1c')]:_0x3c44a9['offset']+_0x3c44a9[_0x2d77('0x1b')];var _0x30cd60;if(_0x238cf3>=_0x459143){_0x238cf3=_0x459143;_0x30cd60=0xc8;}else{_0x30cd60=0xce;}_0x27b213[_0x2d77('0x17')](_0x30cd60);return _0x27b213[_0x2d77('0x1d')](_0x2d77('0x1e'),_0x3902fe+'-'+_0x238cf3+'/'+_0x459143)[_0x2d77('0x18')](_0x558193);}return null;};}function patchUpdates(_0x54a6e9){return function(_0x3250bc){try{jsonpatch[_0x2d77('0x1f')](_0x3250bc,_0x54a6e9,!![]);}catch(_0x303efb){return BPromise[_0x2d77('0x20')](_0x303efb);}return _0x3250bc[_0x2d77('0x21')]();};}function saveUpdates(_0x449639,_0x5c94ba){return function(_0x404f9e){if(_0x404f9e){return _0x404f9e[_0x2d77('0x22')](_0x449639)[_0x2d77('0x23')](function(_0x276488){return _0x276488;});}return null;};}function removeEntity(_0x342a2b,_0x15601f){return function(_0x2a1a60){if(_0x2a1a60){return _0x2a1a60[_0x2d77('0x24')]()[_0x2d77('0x23')](function(){var _0x4e410e=_0x2a1a60[_0x2d77('0x25')]({'plain':!![]});var _0x3e7f32='ODBC';return db['UserProfileResource'][_0x2d77('0x24')]({'where':{'type':_0x3e7f32,'resourceId':_0x4e410e['id']}})['then'](function(){return _0x2a1a60;});})[_0x2d77('0x23')](function(){_0x342a2b[_0x2d77('0x17')](0xcc)[_0x2d77('0x16')]();});}};}function handleEntityNotFound(_0x19dad5,_0x36d48b){return function(_0x5da109){if(!_0x5da109){_0x19dad5['sendStatus'](0x194);}return _0x5da109;};}function handleError(_0x406550,_0x20280e){_0x20280e=_0x20280e||0x1f4;return function(_0x328fac){logger[_0x2d77('0x26')](_0x328fac[_0x2d77('0x27')]);if(_0x328fac['name']){delete _0x328fac['name'];}_0x406550['status'](_0x20280e)['send'](_0x328fac);};}exports['index']=function(_0x5ac10d,_0xd46861){var _0x5c36a7={},_0x2c6c91={},_0x5bf779={'count':0x0,'rows':[]};var _0x5cad74=_[_0x2d77('0x28')](db[_0x2d77('0x29')][_0x2d77('0x2a')],function(_0x44a349){return{'name':_0x44a349[_0x2d77('0x2b')],'type':_0x44a349[_0x2d77('0x2c')][_0x2d77('0x2d')]};});_0x2c6c91[_0x2d77('0x2e')]=_[_0x2d77('0x28')](_0x5cad74,'name');_0x2c6c91['query']=_[_0x2d77('0x2f')](_0x5ac10d[_0x2d77('0x30')]);_0x2c6c91[_0x2d77('0x31')]=_[_0x2d77('0x32')](_0x2c6c91[_0x2d77('0x2e')],_0x2c6c91['query']);_0x5c36a7[_0x2d77('0x33')]=_[_0x2d77('0x32')](_0x2c6c91[_0x2d77('0x2e')],qs[_0x2d77('0x34')](_0x5ac10d[_0x2d77('0x30')]['fields']));_0x5c36a7['attributes']=_0x5c36a7[_0x2d77('0x33')][_0x2d77('0x35')]?_0x5c36a7['attributes']:_0x2c6c91[_0x2d77('0x2e')];if(!_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x36')](_0x2d77('0x37'))){_0x5c36a7['limit']=qs['limit'](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x1b')]);_0x5c36a7['offset']=qs['offset'](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x19')]);}_0x5c36a7['order']=qs[_0x2d77('0x38')](_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x38')]);_0x5c36a7[_0x2d77('0x39')]=qs[_0x2d77('0x31')](_[_0x2d77('0x3a')](_0x5ac10d['query'],_0x2c6c91['filters']),_0x5cad74);if(_0x5ac10d[_0x2d77('0x30')]['filter']){_0x5c36a7[_0x2d77('0x39')]=_[_0x2d77('0x3b')](_0x5c36a7[_0x2d77('0x39')],{'$or':_[_0x2d77('0x28')](_0x5cad74,function(_0x552c16){if(_0x552c16[_0x2d77('0x2c')]!=='VIRTUAL'){var _0x34c7bb={};_0x34c7bb[_0x552c16[_0x2d77('0x3c')]]={'$like':'%'+_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x3d')]+'%'};return _0x34c7bb;}})});}_0x5c36a7=_[_0x2d77('0x3b')]({},_0x5c36a7,_0x5ac10d[_0x2d77('0x3e')]);var _0x3ad04f={'where':_0x5c36a7[_0x2d77('0x39')]};return db[_0x2d77('0x29')][_0x2d77('0x1c')](_0x3ad04f)[_0x2d77('0x23')](function(_0x2b2e2b){_0x5bf779[_0x2d77('0x1c')]=_0x2b2e2b;if(_0x5ac10d[_0x2d77('0x30')][_0x2d77('0x3f')]){_0x5c36a7[_0x2d77('0x40')]=[{'all':!![]}];}return db[_0x2d77('0x29')][_0x2d77('0x41')](_0x5c36a7);})[_0x2d77('0x23')](function(_0x357023){_0x5bf779[_0x2d77('0x42')]=_0x357023;return _0x5bf779;})[_0x2d77('0x23')](respondWithFilteredResult(_0xd46861,_0x5c36a7))['catch'](handleError(_0xd46861,null));};exports[_0x2d77('0x43')]=function(_0x192894,_0x117a5f){var _0x58d844={'raw':!![],'where':{'id':_0x192894[_0x2d77('0x44')]['id']}},_0x2eb803={};_0x2eb803[_0x2d77('0x2e')]=_[_0x2d77('0x2f')](db[_0x2d77('0x29')][_0x2d77('0x2a')]);_0x2eb803[_0x2d77('0x30')]=_[_0x2d77('0x2f')](_0x192894['query']);_0x2eb803['filters']=_[_0x2d77('0x32')](_0x2eb803[_0x2d77('0x2e')],_0x2eb803[_0x2d77('0x30')]);_0x58d844['attributes']=_[_0x2d77('0x32')](_0x2eb803[_0x2d77('0x2e')],qs[_0x2d77('0x34')](_0x192894['query']['fields']));_0x58d844[_0x2d77('0x33')]=_0x58d844[_0x2d77('0x33')][_0x2d77('0x35')]?_0x58d844[_0x2d77('0x33')]:_0x2eb803[_0x2d77('0x2e')];if(_0x192894['query'][_0x2d77('0x3f')]){_0x58d844[_0x2d77('0x40')]=[{'all':!![]}];}_0x58d844=_[_0x2d77('0x3b')]({},_0x58d844,_0x192894[_0x2d77('0x3e')]);return db[_0x2d77('0x29')]['find'](_0x58d844)[_0x2d77('0x23')](handleEntityNotFound(_0x117a5f,null))[_0x2d77('0x23')](respondWithResult(_0x117a5f,null))[_0x2d77('0x45')](handleError(_0x117a5f,null));};exports[_0x2d77('0x46')]=function(_0x2be34c,_0x2bbd8b){return db[_0x2d77('0x29')][_0x2d77('0x46')](_0x2be34c['body'],{})['then'](function(_0x10f3e8){var _0x19ceb9=_0x2be34c[_0x2d77('0x47')][_0x2d77('0x25')]({'plain':!![]});if(!_0x19ceb9)throw new Error(_0x2d77('0x48'));if(_0x19ceb9[_0x2d77('0x49')]==='user'){var _0x2f9a93=_0x10f3e8[_0x2d77('0x25')]({'plain':!![]});var _0x3983aa='ODBC';return db['UserProfileSection'][_0x2d77('0x4a')]({'where':{'name':_0x3983aa,'userProfileId':_0x19ceb9['userProfileId']},'raw':!![]})['then'](function(_0xdae7a8){if(_0xdae7a8&&_0xdae7a8['autoAssociation']===0x0){return db['UserProfileResource']['create']({'name':_0x2f9a93[_0x2d77('0x3c')],'resourceId':_0x2f9a93['id'],'type':_0xdae7a8[_0x2d77('0x3c')],'sectionId':_0xdae7a8['id']},{})['then'](function(){return _0x10f3e8;});}else{return _0x10f3e8;}})[_0x2d77('0x45')](function(_0x3ee162){logger['error'](_0x2d77('0x4b'),_0x3ee162);throw _0x3ee162;});}return _0x10f3e8;})[_0x2d77('0x23')](respondWithResult(_0x2bbd8b,0xc9))[_0x2d77('0x45')](handleError(_0x2bbd8b,null));};exports[_0x2d77('0x22')]=function(_0x783537,_0x127b0d){if(_0x783537['body']['id']){delete _0x783537['body']['id'];}return db['SquareOdbc'][_0x2d77('0x4a')]({'where':{'id':_0x783537[_0x2d77('0x44')]['id']}})['then'](handleEntityNotFound(_0x127b0d,null))[_0x2d77('0x23')](saveUpdates(_0x783537[_0x2d77('0x4c')],null))[_0x2d77('0x23')](respondWithResult(_0x127b0d,null))[_0x2d77('0x45')](handleError(_0x127b0d,null));};exports[_0x2d77('0x24')]=function(_0xe8271f,_0x3ca8a0){return db[_0x2d77('0x29')][_0x2d77('0x4a')]({'where':{'id':_0xe8271f[_0x2d77('0x44')]['id']}})[_0x2d77('0x23')](handleEntityNotFound(_0x3ca8a0,null))[_0x2d77('0x23')](removeEntity(_0x3ca8a0,null))['catch'](handleError(_0x3ca8a0,null));};exports['test']=function(_0x2effc8,_0x404c33,_0x3a3b8b){var _0x347016;return db[_0x2d77('0x29')]['find']({'where':{'id':_0x2effc8['params']['id']},'attributes':['id','dsn']})[_0x2d77('0x23')](handleEntityNotFound(_0x404c33,null))[_0x2d77('0x23')](function(_0x573e1a){if(_0x573e1a){var _0x52436d=require('odbc')();_0x52436d[_0x2d77('0x4d')](_0x573e1a[_0x2d77('0x4e')]);_0x52436d[_0x2d77('0x4f')]();return _0x573e1a;}})[_0x2d77('0x23')](respondWithResult(_0x404c33,null))[_0x2d77('0x45')](handleError(_0x404c33,null));};