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 _0x3467=['mustache','util','path','sox','to-csv','fs-extra','lodash','squel','desk.js','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','sendStatus','status','end','json','limit','undefined','count','offset','set','Content-Range','apply','reject','save','update','then','destroy','get','UserProfileResource','error','name','send','index','map','SquareOdbc','rawAttributes','type','key','model','query','keys','filters','intersection','fields','attributes','hasOwnProperty','nolimit','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','rows','catch','show','params','length','find','create','user','ODBC','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','body','test','odbc','openSync','closeSync','rimraf','zip-dir','fast-json-patch','request-promise','bluebird'];(function(_0x2136a6,_0x35af63){var _0x55b948=function(_0x288a75){while(--_0x288a75){_0x2136a6['push'](_0x2136a6['shift']());}};_0x55b948(++_0x35af63);}(_0x3467,0x1f3));var _0x7346=function(_0x42337c,_0x3afbe4){_0x42337c=_0x42337c-0x0;var _0x42e5ba=_0x3467[_0x42337c];return _0x42e5ba;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x7346('0x0'));var zipdir=require(_0x7346('0x1'));var jsonpatch=require(_0x7346('0x2'));var rp=require(_0x7346('0x3'));var moment=require('moment');var BPromise=require(_0x7346('0x4'));var Mustache=require(_0x7346('0x5'));var util=require(_0x7346('0x6'));var path=require(_0x7346('0x7'));var sox=require(_0x7346('0x8'));var csv=require(_0x7346('0x9'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x7346('0xa'));var _=require(_0x7346('0xb'));var squel=require(_0x7346('0xc'));var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x7346('0xd'));var toCsv=require('to-csv');var querystring=require(_0x7346('0xe'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x7346('0xf'));var qs=require(_0x7346('0x10'));var as=require(_0x7346('0x11'));var hardwareService=require(_0x7346('0x12'));var logger=require(_0x7346('0x13'))(_0x7346('0x14'));var utils=require('../../config/utils');var config=require(_0x7346('0x15'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x4bc90a,_0x1f10c1){_0x1f10c1=_0x1f10c1||0xcc;return function(_0x5176c9){if(_0x5176c9){return _0x4bc90a[_0x7346('0x16')](_0x1f10c1);}return _0x4bc90a[_0x7346('0x17')](_0x1f10c1)[_0x7346('0x18')]();};}function respondWithResult(_0x33e2dc,_0x1a3e6b){_0x1a3e6b=_0x1a3e6b||0xc8;return function(_0x444f82){if(_0x444f82){return _0x33e2dc[_0x7346('0x17')](_0x1a3e6b)[_0x7346('0x19')](_0x444f82);}};}function respondWithFilteredResult(_0x3b67f1,_0x50fa60){return function(_0x405284){if(_0x405284){var _0x53a75d=typeof _0x50fa60['offset']==='undefined'&&typeof _0x50fa60[_0x7346('0x1a')]===_0x7346('0x1b');var _0x13258b=_0x405284[_0x7346('0x1c')];var _0x1d99bd=_0x53a75d?0x0:_0x50fa60[_0x7346('0x1d')];var _0x4add6d=_0x53a75d?_0x405284[_0x7346('0x1c')]:_0x50fa60[_0x7346('0x1d')]+_0x50fa60[_0x7346('0x1a')];var _0x3c8a8d;if(_0x4add6d>=_0x13258b){_0x4add6d=_0x13258b;_0x3c8a8d=0xc8;}else{_0x3c8a8d=0xce;}_0x3b67f1[_0x7346('0x17')](_0x3c8a8d);return _0x3b67f1[_0x7346('0x1e')](_0x7346('0x1f'),_0x1d99bd+'-'+_0x4add6d+'/'+_0x13258b)[_0x7346('0x19')](_0x405284);}return null;};}function patchUpdates(_0x56e34a){return function(_0x11d0c8){try{jsonpatch[_0x7346('0x20')](_0x11d0c8,_0x56e34a,!![]);}catch(_0x4266af){return BPromise[_0x7346('0x21')](_0x4266af);}return _0x11d0c8[_0x7346('0x22')]();};}function saveUpdates(_0x55973a,_0x12aa64){return function(_0x2ee3cb){if(_0x2ee3cb){return _0x2ee3cb[_0x7346('0x23')](_0x55973a)[_0x7346('0x24')](function(_0x9d5f48){return _0x9d5f48;});}return null;};}function removeEntity(_0x2014d5,_0x2ed280){return function(_0x46e7ec){if(_0x46e7ec){return _0x46e7ec[_0x7346('0x25')]()[_0x7346('0x24')](function(){var _0x1fdac6=_0x46e7ec[_0x7346('0x26')]({'plain':!![]});var _0x45f45a='ODBC';return db[_0x7346('0x27')]['destroy']({'where':{'type':_0x45f45a,'resourceId':_0x1fdac6['id']}})[_0x7346('0x24')](function(){return _0x46e7ec;});})['then'](function(){_0x2014d5[_0x7346('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x428a7d,_0x4c2836){return function(_0x484b64){if(!_0x484b64){_0x428a7d['sendStatus'](0x194);}return _0x484b64;};}function handleError(_0x387bba,_0x5414c7){_0x5414c7=_0x5414c7||0x1f4;return function(_0x5821ae){logger[_0x7346('0x28')](_0x5821ae['stack']);if(_0x5821ae[_0x7346('0x29')]){delete _0x5821ae[_0x7346('0x29')];}_0x387bba[_0x7346('0x17')](_0x5414c7)[_0x7346('0x2a')](_0x5821ae);};}exports[_0x7346('0x2b')]=function(_0x487b75,_0x566539){var _0x5f2536={},_0x55681d={},_0x2bb81d={'count':0x0,'rows':[]};var _0x4d2347=_[_0x7346('0x2c')](db[_0x7346('0x2d')][_0x7346('0x2e')],function(_0x5c50ac){return{'name':_0x5c50ac['fieldName'],'type':_0x5c50ac[_0x7346('0x2f')][_0x7346('0x30')]};});_0x55681d[_0x7346('0x31')]=_[_0x7346('0x2c')](_0x4d2347,_0x7346('0x29'));_0x55681d[_0x7346('0x32')]=_[_0x7346('0x33')](_0x487b75[_0x7346('0x32')]);_0x55681d[_0x7346('0x34')]=_[_0x7346('0x35')](_0x55681d[_0x7346('0x31')],_0x55681d[_0x7346('0x32')]);_0x5f2536['attributes']=_[_0x7346('0x35')](_0x55681d['model'],qs['fields'](_0x487b75[_0x7346('0x32')][_0x7346('0x36')]));_0x5f2536[_0x7346('0x37')]=_0x5f2536[_0x7346('0x37')]['length']?_0x5f2536[_0x7346('0x37')]:_0x55681d[_0x7346('0x31')];if(!_0x487b75[_0x7346('0x32')][_0x7346('0x38')](_0x7346('0x39'))){_0x5f2536['limit']=qs[_0x7346('0x1a')](_0x487b75['query'][_0x7346('0x1a')]);_0x5f2536['offset']=qs[_0x7346('0x1d')](_0x487b75['query'][_0x7346('0x1d')]);}_0x5f2536['order']=qs['sort'](_0x487b75[_0x7346('0x32')][_0x7346('0x3a')]);_0x5f2536['where']=qs[_0x7346('0x34')](_[_0x7346('0x3b')](_0x487b75['query'],_0x55681d[_0x7346('0x34')]),_0x4d2347);if(_0x487b75['query'][_0x7346('0x3c')]){_0x5f2536[_0x7346('0x3d')]=_[_0x7346('0x3e')](_0x5f2536['where'],{'$or':_[_0x7346('0x2c')](_0x4d2347,function(_0x4f3e4e){if(_0x4f3e4e[_0x7346('0x2f')]!==_0x7346('0x3f')){var _0x2049f8={};_0x2049f8[_0x4f3e4e[_0x7346('0x29')]]={'$like':'%'+_0x487b75[_0x7346('0x32')][_0x7346('0x3c')]+'%'};return _0x2049f8;}})});}_0x5f2536=_[_0x7346('0x3e')]({},_0x5f2536,_0x487b75[_0x7346('0x40')]);var _0x2ed7c5={'where':_0x5f2536[_0x7346('0x3d')]};return db[_0x7346('0x2d')][_0x7346('0x1c')](_0x2ed7c5)[_0x7346('0x24')](function(_0x3f3cc6){_0x2bb81d[_0x7346('0x1c')]=_0x3f3cc6;if(_0x487b75[_0x7346('0x32')][_0x7346('0x41')]){_0x5f2536['include']=[{'all':!![]}];}return db[_0x7346('0x2d')]['findAll'](_0x5f2536);})[_0x7346('0x24')](function(_0x306b02){_0x2bb81d[_0x7346('0x42')]=_0x306b02;return _0x2bb81d;})[_0x7346('0x24')](respondWithFilteredResult(_0x566539,_0x5f2536))[_0x7346('0x43')](handleError(_0x566539,null));};exports[_0x7346('0x44')]=function(_0x2d4cd2,_0x18e9e8){var _0x3fcd93={'raw':!![],'where':{'id':_0x2d4cd2[_0x7346('0x45')]['id']}},_0x4a86e4={};_0x4a86e4['model']=_[_0x7346('0x33')](db[_0x7346('0x2d')][_0x7346('0x2e')]);_0x4a86e4[_0x7346('0x32')]=_['keys'](_0x2d4cd2[_0x7346('0x32')]);_0x4a86e4[_0x7346('0x34')]=_[_0x7346('0x35')](_0x4a86e4[_0x7346('0x31')],_0x4a86e4[_0x7346('0x32')]);_0x3fcd93['attributes']=_[_0x7346('0x35')](_0x4a86e4[_0x7346('0x31')],qs['fields'](_0x2d4cd2[_0x7346('0x32')]['fields']));_0x3fcd93['attributes']=_0x3fcd93[_0x7346('0x37')][_0x7346('0x46')]?_0x3fcd93['attributes']:_0x4a86e4[_0x7346('0x31')];if(_0x2d4cd2[_0x7346('0x32')][_0x7346('0x41')]){_0x3fcd93['include']=[{'all':!![]}];}_0x3fcd93=_[_0x7346('0x3e')]({},_0x3fcd93,_0x2d4cd2['options']);return db[_0x7346('0x2d')][_0x7346('0x47')](_0x3fcd93)[_0x7346('0x24')](handleEntityNotFound(_0x18e9e8,null))['then'](respondWithResult(_0x18e9e8,null))[_0x7346('0x43')](handleError(_0x18e9e8,null));};exports[_0x7346('0x48')]=function(_0x4245b0,_0x2dc1b1){return db[_0x7346('0x2d')][_0x7346('0x48')](_0x4245b0['body'],{})[_0x7346('0x24')](function(_0x2e9af0){var _0xce8ad8=_0x4245b0[_0x7346('0x49')][_0x7346('0x26')]({'plain':!![]});if(!_0xce8ad8)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0xce8ad8['role']==='user'){var _0x82fad5=_0x2e9af0[_0x7346('0x26')]({'plain':!![]});var _0x120629=_0x7346('0x4a');return db[_0x7346('0x4b')][_0x7346('0x47')]({'where':{'name':_0x120629,'userProfileId':_0xce8ad8[_0x7346('0x4c')]},'raw':!![]})[_0x7346('0x24')](function(_0x310776){if(_0x310776&&_0x310776[_0x7346('0x4d')]===0x0){return db[_0x7346('0x27')][_0x7346('0x48')]({'name':_0x82fad5[_0x7346('0x29')],'resourceId':_0x82fad5['id'],'type':_0x310776[_0x7346('0x29')],'sectionId':_0x310776['id']},{})[_0x7346('0x24')](function(){return _0x2e9af0;});}else{return _0x2e9af0;}})[_0x7346('0x43')](function(_0x555619){logger['error'](_0x7346('0x4e'),_0x555619);throw _0x555619;});}return _0x2e9af0;})[_0x7346('0x24')](respondWithResult(_0x2dc1b1,0xc9))[_0x7346('0x43')](handleError(_0x2dc1b1,null));};exports[_0x7346('0x23')]=function(_0x858925,_0x4ebfc3){if(_0x858925['body']['id']){delete _0x858925[_0x7346('0x4f')]['id'];}return db[_0x7346('0x2d')]['find']({'where':{'id':_0x858925['params']['id']}})['then'](handleEntityNotFound(_0x4ebfc3,null))[_0x7346('0x24')](saveUpdates(_0x858925[_0x7346('0x4f')],null))['then'](respondWithResult(_0x4ebfc3,null))[_0x7346('0x43')](handleError(_0x4ebfc3,null));};exports[_0x7346('0x25')]=function(_0x647d61,_0x3143ee){return db[_0x7346('0x2d')][_0x7346('0x47')]({'where':{'id':_0x647d61[_0x7346('0x45')]['id']}})[_0x7346('0x24')](handleEntityNotFound(_0x3143ee,null))['then'](removeEntity(_0x3143ee,null))[_0x7346('0x43')](handleError(_0x3143ee,null));};exports[_0x7346('0x50')]=function(_0xbacf50,_0x31e6d5,_0x253e2c){var _0x5f5374;return db[_0x7346('0x2d')]['find']({'where':{'id':_0xbacf50['params']['id']},'attributes':['id','dsn']})[_0x7346('0x24')](handleEntityNotFound(_0x31e6d5,null))[_0x7346('0x24')](function(_0x258771){if(_0x258771){var _0x1c5f9d=require(_0x7346('0x51'))();_0x1c5f9d[_0x7346('0x52')](_0x258771['dsn']);_0x1c5f9d[_0x7346('0x53')]();return _0x258771;}})[_0x7346('0x24')](respondWithResult(_0x31e6d5,null))[_0x7346('0x43')](handleError(_0x31e6d5,null));};