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 _0xc6e9=['end','json','offset','set','Content-Range','reject','save','then','ODBC','UserProfileResource','destroy','error','stack','name','send','index','map','SquareOdbc','fieldName','type','key','model','query','keys','filters','fields','attributes','length','limit','where','filter','merge','VIRTUAL','options','count','includeAll','include','findAll','rows','catch','params','intersection','create','body','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','get','UserProfileSection','find','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','test','odbc','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','crypto','desk.js','papaparse','ioredis','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../mysqldb','sendStatus','status'];(function(_0x2e9601,_0x44ca90){var _0x40fa31=function(_0x214321){while(--_0x214321){_0x2e9601['push'](_0x2e9601['shift']());}};_0x40fa31(++_0x44ca90);}(_0xc6e9,0xe2));var _0x9c6e=function(_0x3085be,_0x5425c8){_0x3085be=_0x3085be-0x0;var _0x535384=_0xc6e9[_0x3085be];return _0x535384;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x9c6e('0x0'));var rimraf=require(_0x9c6e('0x1'));var zipdir=require(_0x9c6e('0x2'));var jsonpatch=require(_0x9c6e('0x3'));var rp=require(_0x9c6e('0x4'));var moment=require(_0x9c6e('0x5'));var BPromise=require(_0x9c6e('0x6'));var Mustache=require(_0x9c6e('0x7'));var util=require(_0x9c6e('0x8'));var path=require(_0x9c6e('0x9'));var sox=require(_0x9c6e('0xa'));var csv=require(_0x9c6e('0xb'));var ejs=require(_0x9c6e('0xc'));var fs=require('fs');var _=require(_0x9c6e('0xd'));var squel=require('squel');var crypto=require(_0x9c6e('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x9c6e('0xf'));var toCsv=require(_0x9c6e('0xb'));var querystring=require('querystring');var Papa=require(_0x9c6e('0x10'));var Redis=require(_0x9c6e('0x11'));var authService=require('../../components/auth/service');var qs=require('../../components/parsers/qs');var as=require(_0x9c6e('0x12'));var hardwareService=require(_0x9c6e('0x13'));var logger=require(_0x9c6e('0x14'))(_0x9c6e('0x15'));var utils=require(_0x9c6e('0x16'));var config=require('../../config/environment');var db=require(_0x9c6e('0x17'))['db'];function respondWithStatusCode(_0x480048,_0x50a96b){_0x50a96b=_0x50a96b||0xcc;return function(_0xa4d63a){if(_0xa4d63a){return _0x480048[_0x9c6e('0x18')](_0x50a96b);}return _0x480048[_0x9c6e('0x19')](_0x50a96b)[_0x9c6e('0x1a')]();};}function respondWithResult(_0x5e3e37,_0x61aa84){_0x61aa84=_0x61aa84||0xc8;return function(_0x1bb064){if(_0x1bb064){return _0x5e3e37[_0x9c6e('0x19')](_0x61aa84)[_0x9c6e('0x1b')](_0x1bb064);}};}function respondWithFilteredResult(_0x36a3fe,_0x25eede){return function(_0x1cf2bf){if(_0x1cf2bf){var _0x5b3f80=_0x1cf2bf['count'],_0x19fc70=_0x25eede[_0x9c6e('0x1c')],_0x359736=_0x25eede[_0x9c6e('0x1c')]+_0x25eede['limit'],_0xc20d35;if(_0x359736>=_0x5b3f80){_0x359736=_0x5b3f80;_0xc20d35=0xc8;}else{_0xc20d35=0xce;}_0x36a3fe[_0x9c6e('0x19')](_0xc20d35);return _0x36a3fe[_0x9c6e('0x1d')](_0x9c6e('0x1e'),_0x19fc70+'-'+_0x359736+'/'+_0x5b3f80)['json'](_0x1cf2bf);}return null;};}function patchUpdates(_0x11a53f){return function(_0x2c078a){try{jsonpatch['apply'](_0x2c078a,_0x11a53f,!![]);}catch(_0x5ca781){return BPromise[_0x9c6e('0x1f')](_0x5ca781);}return _0x2c078a[_0x9c6e('0x20')]();};}function saveUpdates(_0x2bacb3,_0x45a795){return function(_0x1e66e9){if(_0x1e66e9){return _0x1e66e9['update'](_0x2bacb3)['then'](function(_0x4bda34){return _0x4bda34;});}return null;};}function removeEntity(_0x14573a,_0x38166f){return function(_0x4980f2){if(_0x4980f2){return _0x4980f2['destroy']()[_0x9c6e('0x21')](function(){var _0x2df472=_0x4980f2['get']({'plain':!![]});var _0x4cddd4=_0x9c6e('0x22');return db[_0x9c6e('0x23')][_0x9c6e('0x24')]({'where':{'type':_0x4cddd4,'resourceId':_0x2df472['id']}})['then'](function(){return _0x4980f2;});})['then'](function(){_0x14573a[_0x9c6e('0x19')](0xcc)[_0x9c6e('0x1a')]();});}};}function handleEntityNotFound(_0x5ec6fb,_0x5b0996){return function(_0x5e0165){if(!_0x5e0165){_0x5ec6fb['sendStatus'](0x194);}return _0x5e0165;};}function handleError(_0x1e2b6d,_0x2441f8){_0x2441f8=_0x2441f8||0x1f4;return function(_0x18d489){logger[_0x9c6e('0x25')](_0x18d489[_0x9c6e('0x26')]);if(_0x18d489[_0x9c6e('0x27')]){delete _0x18d489[_0x9c6e('0x27')];}_0x1e2b6d[_0x9c6e('0x19')](_0x2441f8)[_0x9c6e('0x28')](_0x18d489);};}exports[_0x9c6e('0x29')]=function(_0x28b120,_0x51420e){var _0x56dfac={},_0x3714a3={},_0x497ee7={'count':0x0,'rows':[]};var _0x1f907a=_[_0x9c6e('0x2a')](db[_0x9c6e('0x2b')]['rawAttributes'],function(_0x976d85){return{'name':_0x976d85[_0x9c6e('0x2c')],'type':_0x976d85[_0x9c6e('0x2d')][_0x9c6e('0x2e')]};});_0x3714a3[_0x9c6e('0x2f')]=_['map'](_0x1f907a,'name');_0x3714a3[_0x9c6e('0x30')]=_[_0x9c6e('0x31')](_0x28b120[_0x9c6e('0x30')]);_0x3714a3[_0x9c6e('0x32')]=_['intersection'](_0x3714a3['model'],_0x3714a3[_0x9c6e('0x30')]);_0x56dfac['attributes']=_['intersection'](_0x3714a3[_0x9c6e('0x2f')],qs[_0x9c6e('0x33')](_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x33')]));_0x56dfac[_0x9c6e('0x34')]=_0x56dfac[_0x9c6e('0x34')][_0x9c6e('0x35')]?_0x56dfac[_0x9c6e('0x34')]:_0x3714a3[_0x9c6e('0x2f')];if(!_0x28b120[_0x9c6e('0x30')]['hasOwnProperty']('nolimit')){_0x56dfac[_0x9c6e('0x36')]=qs[_0x9c6e('0x36')](_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x36')]);_0x56dfac[_0x9c6e('0x1c')]=qs['offset'](_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x1c')]);}_0x56dfac['order']=qs['sort'](_0x28b120[_0x9c6e('0x30')]['sort']);_0x56dfac[_0x9c6e('0x37')]=qs[_0x9c6e('0x32')](_['pick'](_0x28b120[_0x9c6e('0x30')],_0x3714a3[_0x9c6e('0x32')]),_0x1f907a);if(_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x38')]){_0x56dfac[_0x9c6e('0x37')]=_[_0x9c6e('0x39')](_0x56dfac[_0x9c6e('0x37')],{'$or':_[_0x9c6e('0x2a')](_0x1f907a,function(_0xf4306e){if(_0xf4306e[_0x9c6e('0x2d')]!==_0x9c6e('0x3a')){var _0x5919ec={};_0x5919ec[_0xf4306e['name']]={'$like':'%'+_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x38')]+'%'};return _0x5919ec;}})});}_0x56dfac=_[_0x9c6e('0x39')]({},_0x56dfac,_0x28b120[_0x9c6e('0x3b')]);var _0x36f189={'where':_0x56dfac[_0x9c6e('0x37')]};return db[_0x9c6e('0x2b')]['count'](_0x36f189)['then'](function(_0x5e2a36){_0x497ee7[_0x9c6e('0x3c')]=_0x5e2a36;if(_0x28b120[_0x9c6e('0x30')][_0x9c6e('0x3d')]){_0x56dfac[_0x9c6e('0x3e')]=[{'all':!![]}];}return db[_0x9c6e('0x2b')][_0x9c6e('0x3f')](_0x56dfac);})[_0x9c6e('0x21')](function(_0x4059b9){_0x497ee7[_0x9c6e('0x40')]=_0x4059b9;return _0x497ee7;})[_0x9c6e('0x21')](respondWithFilteredResult(_0x51420e,_0x56dfac))[_0x9c6e('0x41')](handleError(_0x51420e,null));};exports['show']=function(_0x5590aa,_0x4438ad){var _0x24cd28={'raw':!![],'where':{'id':_0x5590aa[_0x9c6e('0x42')]['id']}},_0xc677e8={};_0xc677e8[_0x9c6e('0x2f')]=_[_0x9c6e('0x31')](db[_0x9c6e('0x2b')]['rawAttributes']);_0xc677e8[_0x9c6e('0x30')]=_[_0x9c6e('0x31')](_0x5590aa[_0x9c6e('0x30')]);_0xc677e8[_0x9c6e('0x32')]=_[_0x9c6e('0x43')](_0xc677e8[_0x9c6e('0x2f')],_0xc677e8[_0x9c6e('0x30')]);_0x24cd28['attributes']=_[_0x9c6e('0x43')](_0xc677e8[_0x9c6e('0x2f')],qs[_0x9c6e('0x33')](_0x5590aa[_0x9c6e('0x30')][_0x9c6e('0x33')]));_0x24cd28[_0x9c6e('0x34')]=_0x24cd28[_0x9c6e('0x34')][_0x9c6e('0x35')]?_0x24cd28[_0x9c6e('0x34')]:_0xc677e8[_0x9c6e('0x2f')];if(_0x5590aa['query'][_0x9c6e('0x3d')]){_0x24cd28[_0x9c6e('0x3e')]=[{'all':!![]}];}_0x24cd28=_[_0x9c6e('0x39')]({},_0x24cd28,_0x5590aa[_0x9c6e('0x3b')]);return db['SquareOdbc']['find'](_0x24cd28)[_0x9c6e('0x21')](handleEntityNotFound(_0x4438ad,null))[_0x9c6e('0x21')](respondWithResult(_0x4438ad,null))[_0x9c6e('0x41')](handleError(_0x4438ad,null));};exports[_0x9c6e('0x44')]=function(_0x16fa1a,_0x58c522){return db[_0x9c6e('0x2b')][_0x9c6e('0x44')](_0x16fa1a[_0x9c6e('0x45')],{})[_0x9c6e('0x21')](function(_0x248a51){var _0x42c53a=_0x16fa1a[_0x9c6e('0x46')]['get']({'plain':!![]});if(!_0x42c53a)throw new Error(_0x9c6e('0x47'));if(_0x42c53a[_0x9c6e('0x48')]===_0x9c6e('0x46')){var _0x2507f0=_0x248a51[_0x9c6e('0x49')]({'plain':!![]});var _0x161bd7=_0x9c6e('0x22');return db[_0x9c6e('0x4a')][_0x9c6e('0x4b')]({'where':{'name':_0x161bd7,'userProfileId':_0x42c53a[_0x9c6e('0x4c')]},'raw':!![]})[_0x9c6e('0x21')](function(_0x430eeb){if(_0x430eeb&&_0x430eeb[_0x9c6e('0x4d')]===0x0){return db[_0x9c6e('0x23')][_0x9c6e('0x44')]({'name':_0x2507f0[_0x9c6e('0x27')],'resourceId':_0x2507f0['id'],'type':_0x430eeb[_0x9c6e('0x27')],'sectionId':_0x430eeb['id']},{})[_0x9c6e('0x21')](function(){return _0x248a51;});}else{return _0x248a51;}})[_0x9c6e('0x41')](function(_0x5ea7dd){logger['error'](_0x9c6e('0x4e'),_0x5ea7dd);throw _0x5ea7dd;});}return _0x248a51;})[_0x9c6e('0x21')](respondWithResult(_0x58c522,0xc9))[_0x9c6e('0x41')](handleError(_0x58c522,null));};exports[_0x9c6e('0x4f')]=function(_0x23f950,_0x1b608c){if(_0x23f950[_0x9c6e('0x45')]['id']){delete _0x23f950[_0x9c6e('0x45')]['id'];}return db['SquareOdbc'][_0x9c6e('0x4b')]({'where':{'id':_0x23f950[_0x9c6e('0x42')]['id']}})[_0x9c6e('0x21')](handleEntityNotFound(_0x1b608c,null))['then'](saveUpdates(_0x23f950[_0x9c6e('0x45')],null))[_0x9c6e('0x21')](respondWithResult(_0x1b608c,null))[_0x9c6e('0x41')](handleError(_0x1b608c,null));};exports[_0x9c6e('0x24')]=function(_0x2310d5,_0x2bece3){return db[_0x9c6e('0x2b')][_0x9c6e('0x4b')]({'where':{'id':_0x2310d5[_0x9c6e('0x42')]['id']}})['then'](handleEntityNotFound(_0x2bece3,null))[_0x9c6e('0x21')](removeEntity(_0x2bece3,null))[_0x9c6e('0x41')](handleError(_0x2bece3,null));};exports[_0x9c6e('0x50')]=function(_0x5581e,_0x1e5e7a,_0x1f55dc){var _0x5faed9;return db[_0x9c6e('0x2b')]['find']({'where':{'id':_0x5581e[_0x9c6e('0x42')]['id']},'attributes':['id','dsn']})['then'](handleEntityNotFound(_0x1e5e7a,null))[_0x9c6e('0x21')](function(_0x480cc8){if(_0x480cc8){var _0x557693=require(_0x9c6e('0x51'))();_0x557693[_0x9c6e('0x52')](_0x480cc8['dsn']);_0x557693[_0x9c6e('0x53')]();return _0x480cc8;}})[_0x9c6e('0x21')](respondWithResult(_0x1e5e7a,null))[_0x9c6e('0x41')](handleError(_0x1e5e7a,null));};