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 _0xe84b=['../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','offset','limit','undefined','count','set','apply','reject','update','destroy','then','UserProfileResource','error','name','send','rawAttributes','fieldName','type','key','map','query','filters','intersection','model','fields','attributes','length','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','options','SquareOdbc','includeAll','include','findAll','catch','params','keys','find','create','body','user','get','ODBC','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','test','dsn','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api'];(function(_0x37ff4b,_0x41ab92){var _0xb0c813=function(_0xfa1743){while(--_0xfa1743){_0x37ff4b['push'](_0x37ff4b['shift']());}};_0xb0c813(++_0x41ab92);}(_0xe84b,0x1ec));var _0xbe84=function(_0x4875e5,_0x5bbd05){_0x4875e5=_0x4875e5-0x0;var _0xeb2871=_0xe84b[_0x4875e5];return _0xeb2871;};'use strict';var emlformat=require(_0xbe84('0x0'));var rimraf=require(_0xbe84('0x1'));var zipdir=require(_0xbe84('0x2'));var jsonpatch=require(_0xbe84('0x3'));var rp=require(_0xbe84('0x4'));var moment=require(_0xbe84('0x5'));var BPromise=require(_0xbe84('0x6'));var Mustache=require(_0xbe84('0x7'));var util=require('util');var path=require('path');var sox=require(_0xbe84('0x8'));var csv=require(_0xbe84('0x9'));var ejs=require(_0xbe84('0xa'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xbe84('0xb'));var squel=require(_0xbe84('0xc'));var crypto=require(_0xbe84('0xd'));var jsforce=require(_0xbe84('0xe'));var deskjs=require(_0xbe84('0xf'));var toCsv=require('to-csv');var querystring=require(_0xbe84('0x10'));var Papa=require(_0xbe84('0x11'));var Redis=require(_0xbe84('0x12'));var authService=require(_0xbe84('0x13'));var qs=require(_0xbe84('0x14'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbe84('0x15'));var logger=require(_0xbe84('0x16'))(_0xbe84('0x17'));var utils=require(_0xbe84('0x18'));var config=require(_0xbe84('0x19'));var licenseUtil=require(_0xbe84('0x1a'));var db=require(_0xbe84('0x1b'))['db'];function respondWithStatusCode(_0x566ff0,_0x3ca0ed){_0x3ca0ed=_0x3ca0ed||0xcc;return function(_0x353038){if(_0x353038){return _0x566ff0[_0xbe84('0x1c')](_0x3ca0ed);}return _0x566ff0[_0xbe84('0x1d')](_0x3ca0ed)[_0xbe84('0x1e')]();};}function respondWithResult(_0x3e4fb4,_0x45f75c){_0x45f75c=_0x45f75c||0xc8;return function(_0x16356c){if(_0x16356c){return _0x3e4fb4[_0xbe84('0x1d')](_0x45f75c)['json'](_0x16356c);}};}function respondWithFilteredResult(_0x2f812f,_0x129587){return function(_0x3b9213){if(_0x3b9213){var _0x13dae4=typeof _0x129587[_0xbe84('0x1f')]==='undefined'&&typeof _0x129587[_0xbe84('0x20')]===_0xbe84('0x21');var _0x8f65b7=_0x3b9213[_0xbe84('0x22')];var _0x462025=_0x13dae4?0x0:_0x129587[_0xbe84('0x1f')];var _0x27bc58=_0x13dae4?_0x3b9213['count']:_0x129587[_0xbe84('0x1f')]+_0x129587[_0xbe84('0x20')];var _0x152d53;if(_0x27bc58>=_0x8f65b7){_0x27bc58=_0x8f65b7;_0x152d53=0xc8;}else{_0x152d53=0xce;}_0x2f812f['status'](_0x152d53);return _0x2f812f[_0xbe84('0x23')]('Content-Range',_0x462025+'-'+_0x27bc58+'/'+_0x8f65b7)['json'](_0x3b9213);}return null;};}function patchUpdates(_0x43f845){return function(_0xf0bb63){try{jsonpatch[_0xbe84('0x24')](_0xf0bb63,_0x43f845,!![]);}catch(_0x5d5bd5){return BPromise[_0xbe84('0x25')](_0x5d5bd5);}return _0xf0bb63['save']();};}function saveUpdates(_0x101b80,_0x1c18cc){return function(_0x1fbd90){if(_0x1fbd90){return _0x1fbd90[_0xbe84('0x26')](_0x101b80)['then'](function(_0x127cca){return _0x127cca;});}return null;};}function removeEntity(_0x31ac09,_0x439f2c){return function(_0x20d3fd){if(_0x20d3fd){return _0x20d3fd[_0xbe84('0x27')]()[_0xbe84('0x28')](function(){var _0x5454c9=_0x20d3fd['get']({'plain':!![]});var _0x4b48f6='ODBC';return db[_0xbe84('0x29')][_0xbe84('0x27')]({'where':{'type':_0x4b48f6,'resourceId':_0x5454c9['id']}})[_0xbe84('0x28')](function(){return _0x20d3fd;});})[_0xbe84('0x28')](function(){_0x31ac09[_0xbe84('0x1d')](0xcc)[_0xbe84('0x1e')]();});}};}function handleEntityNotFound(_0x11936a,_0x28e2aa){return function(_0x315fe8){if(!_0x315fe8){_0x11936a[_0xbe84('0x1c')](0x194);}return _0x315fe8;};}function handleError(_0xa079a6,_0x1c8a92){_0x1c8a92=_0x1c8a92||0x1f4;return function(_0x115990){logger[_0xbe84('0x2a')](_0x115990['stack']);if(_0x115990[_0xbe84('0x2b')]){delete _0x115990[_0xbe84('0x2b')];}_0xa079a6[_0xbe84('0x1d')](_0x1c8a92)[_0xbe84('0x2c')](_0x115990);};}exports['index']=function(_0x1f6bfa,_0x4ac916){var _0x30f333={},_0x4e11ce={},_0x271de3={'count':0x0,'rows':[]};var _0x9cd288=_['map'](db['SquareOdbc'][_0xbe84('0x2d')],function(_0x2b6126){return{'name':_0x2b6126[_0xbe84('0x2e')],'type':_0x2b6126[_0xbe84('0x2f')][_0xbe84('0x30')]};});_0x4e11ce['model']=_[_0xbe84('0x31')](_0x9cd288,_0xbe84('0x2b'));_0x4e11ce[_0xbe84('0x32')]=_['keys'](_0x1f6bfa['query']);_0x4e11ce[_0xbe84('0x33')]=_['intersection'](_0x4e11ce['model'],_0x4e11ce['query']);_0x30f333['attributes']=_[_0xbe84('0x34')](_0x4e11ce[_0xbe84('0x35')],qs[_0xbe84('0x36')](_0x1f6bfa['query'][_0xbe84('0x36')]));_0x30f333[_0xbe84('0x37')]=_0x30f333['attributes'][_0xbe84('0x38')]?_0x30f333[_0xbe84('0x37')]:_0x4e11ce[_0xbe84('0x35')];if(!_0x1f6bfa['query'][_0xbe84('0x39')](_0xbe84('0x3a'))){_0x30f333[_0xbe84('0x20')]=qs['limit'](_0x1f6bfa['query'][_0xbe84('0x20')]);_0x30f333['offset']=qs[_0xbe84('0x1f')](_0x1f6bfa[_0xbe84('0x32')][_0xbe84('0x1f')]);}_0x30f333['order']=qs[_0xbe84('0x3b')](_0x1f6bfa[_0xbe84('0x32')][_0xbe84('0x3b')]);_0x30f333[_0xbe84('0x3c')]=qs[_0xbe84('0x33')](_[_0xbe84('0x3d')](_0x1f6bfa[_0xbe84('0x32')],_0x4e11ce['filters']),_0x9cd288);if(_0x1f6bfa[_0xbe84('0x32')]['filter']){_0x30f333[_0xbe84('0x3c')]=_[_0xbe84('0x3e')](_0x30f333[_0xbe84('0x3c')],{'$or':_['map'](_0x9cd288,function(_0x33c146){if(_0x33c146[_0xbe84('0x2f')]!==_0xbe84('0x3f')){var _0x32bcd6={};_0x32bcd6[_0x33c146[_0xbe84('0x2b')]]={'$like':'%'+_0x1f6bfa['query']['filter']+'%'};return _0x32bcd6;}})});}_0x30f333=_['merge']({},_0x30f333,_0x1f6bfa[_0xbe84('0x40')]);var _0xc2f86a={'where':_0x30f333[_0xbe84('0x3c')]};return db[_0xbe84('0x41')]['count'](_0xc2f86a)['then'](function(_0x3f407f){_0x271de3[_0xbe84('0x22')]=_0x3f407f;if(_0x1f6bfa[_0xbe84('0x32')][_0xbe84('0x42')]){_0x30f333[_0xbe84('0x43')]=[{'all':!![]}];}return db[_0xbe84('0x41')][_0xbe84('0x44')](_0x30f333);})['then'](function(_0x6706af){_0x271de3['rows']=_0x6706af;return _0x271de3;})['then'](respondWithFilteredResult(_0x4ac916,_0x30f333))[_0xbe84('0x45')](handleError(_0x4ac916,null));};exports['show']=function(_0xe007ad,_0x598d7c){var _0xa6edfe={'raw':!![],'where':{'id':_0xe007ad[_0xbe84('0x46')]['id']}},_0x22d2a7={};_0x22d2a7[_0xbe84('0x35')]=_[_0xbe84('0x47')](db[_0xbe84('0x41')][_0xbe84('0x2d')]);_0x22d2a7[_0xbe84('0x32')]=_['keys'](_0xe007ad[_0xbe84('0x32')]);_0x22d2a7['filters']=_[_0xbe84('0x34')](_0x22d2a7[_0xbe84('0x35')],_0x22d2a7[_0xbe84('0x32')]);_0xa6edfe['attributes']=_[_0xbe84('0x34')](_0x22d2a7[_0xbe84('0x35')],qs[_0xbe84('0x36')](_0xe007ad[_0xbe84('0x32')][_0xbe84('0x36')]));_0xa6edfe[_0xbe84('0x37')]=_0xa6edfe[_0xbe84('0x37')][_0xbe84('0x38')]?_0xa6edfe[_0xbe84('0x37')]:_0x22d2a7[_0xbe84('0x35')];if(_0xe007ad[_0xbe84('0x32')]['includeAll']){_0xa6edfe[_0xbe84('0x43')]=[{'all':!![]}];}_0xa6edfe=_['merge']({},_0xa6edfe,_0xe007ad[_0xbe84('0x40')]);return db[_0xbe84('0x41')][_0xbe84('0x48')](_0xa6edfe)[_0xbe84('0x28')](handleEntityNotFound(_0x598d7c,null))['then'](respondWithResult(_0x598d7c,null))[_0xbe84('0x45')](handleError(_0x598d7c,null));};exports[_0xbe84('0x49')]=function(_0x49330a,_0x102f16){return db[_0xbe84('0x41')][_0xbe84('0x49')](_0x49330a[_0xbe84('0x4a')],{})['then'](function(_0x2a8d38){var _0x43d01c=_0x49330a[_0xbe84('0x4b')][_0xbe84('0x4c')]({'plain':!![]});if(!_0x43d01c)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x43d01c['role']==='user'){var _0x493704=_0x2a8d38[_0xbe84('0x4c')]({'plain':!![]});var _0x2ebf0=_0xbe84('0x4d');return db[_0xbe84('0x4e')][_0xbe84('0x48')]({'where':{'name':_0x2ebf0,'userProfileId':_0x43d01c[_0xbe84('0x4f')]},'raw':!![]})[_0xbe84('0x28')](function(_0x2f49eb){if(_0x2f49eb&&_0x2f49eb[_0xbe84('0x50')]===0x0){return db[_0xbe84('0x29')][_0xbe84('0x49')]({'name':_0x493704['name'],'resourceId':_0x493704['id'],'type':_0x2f49eb['name'],'sectionId':_0x2f49eb['id']},{})[_0xbe84('0x28')](function(){return _0x2a8d38;});}else{return _0x2a8d38;}})[_0xbe84('0x45')](function(_0x1a1af3){logger[_0xbe84('0x2a')](_0xbe84('0x51'),_0x1a1af3);throw _0x1a1af3;});}return _0x2a8d38;})[_0xbe84('0x28')](respondWithResult(_0x102f16,0xc9))[_0xbe84('0x45')](handleError(_0x102f16,null));};exports[_0xbe84('0x26')]=function(_0x1443fd,_0x1b6e38){if(_0x1443fd[_0xbe84('0x4a')]['id']){delete _0x1443fd[_0xbe84('0x4a')]['id'];}return db['SquareOdbc'][_0xbe84('0x48')]({'where':{'id':_0x1443fd['params']['id']}})[_0xbe84('0x28')](handleEntityNotFound(_0x1b6e38,null))['then'](saveUpdates(_0x1443fd['body'],null))['then'](respondWithResult(_0x1b6e38,null))[_0xbe84('0x45')](handleError(_0x1b6e38,null));};exports[_0xbe84('0x27')]=function(_0x1712ce,_0x176321){return db[_0xbe84('0x41')][_0xbe84('0x48')]({'where':{'id':_0x1712ce['params']['id']}})[_0xbe84('0x28')](handleEntityNotFound(_0x176321,null))[_0xbe84('0x28')](removeEntity(_0x176321,null))[_0xbe84('0x45')](handleError(_0x176321,null));};exports[_0xbe84('0x52')]=function(_0x29c070,_0x1b7142,_0x563a76){var _0x4daef7;return db[_0xbe84('0x41')][_0xbe84('0x48')]({'where':{'id':_0x29c070['params']['id']},'attributes':['id',_0xbe84('0x53')]})[_0xbe84('0x28')](handleEntityNotFound(_0x1b7142,null))[_0xbe84('0x28')](function(_0x1340f3){if(_0x1340f3){var _0x365e79=require('odbc')();_0x365e79[_0xbe84('0x54')](_0x1340f3[_0xbe84('0x53')]);_0x365e79[_0xbe84('0x55')]();return _0x1340f3;}})[_0xbe84('0x28')](respondWithResult(_0x1b7142,null))['catch'](handleError(_0x1b7142,null));};