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 _0x2a2e=['then','destroy','ODBC','UserProfileResource','error','name','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','VIRTUAL','filter','merge','options','includeAll','include','findAll','rows','catch','show','params','keys','find','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','dsn','openSync','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','fs-extra','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/license/util','../../mysqldb','sendStatus','status','end','json','undefined','limit','offset','count','set','Content-Range','reject','update'];(function(_0x476b5f,_0x1f9952){var _0x5a23d8=function(_0x50b464){while(--_0x50b464){_0x476b5f['push'](_0x476b5f['shift']());}};_0x5a23d8(++_0x1f9952);}(_0x2a2e,0x1e5));var _0xe2a2=function(_0x214cbb,_0x40c21f){_0x214cbb=_0x214cbb-0x0;var _0x1495c1=_0x2a2e[_0x214cbb];return _0x1495c1;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xe2a2('0x0'));var zipdir=require(_0xe2a2('0x1'));var jsonpatch=require(_0xe2a2('0x2'));var rp=require(_0xe2a2('0x3'));var moment=require(_0xe2a2('0x4'));var BPromise=require(_0xe2a2('0x5'));var Mustache=require('mustache');var util=require(_0xe2a2('0x6'));var path=require(_0xe2a2('0x7'));var sox=require(_0xe2a2('0x8'));var csv=require(_0xe2a2('0x9'));var ejs=require(_0xe2a2('0xa'));var fs=require('fs');var fs_extra=require(_0xe2a2('0xb'));var _=require(_0xe2a2('0xc'));var squel=require(_0xe2a2('0xd'));var crypto=require('crypto');var jsforce=require(_0xe2a2('0xe'));var deskjs=require(_0xe2a2('0xf'));var toCsv=require(_0xe2a2('0x9'));var querystring=require(_0xe2a2('0x10'));var Papa=require('papaparse');var Redis=require(_0xe2a2('0x11'));var authService=require(_0xe2a2('0x12'));var qs=require(_0xe2a2('0x13'));var as=require(_0xe2a2('0x14'));var hardwareService=require(_0xe2a2('0x15'));var logger=require('../../config/logger')('api');var utils=require(_0xe2a2('0x16'));var config=require('../../config/environment');var licenseUtil=require(_0xe2a2('0x17'));var db=require(_0xe2a2('0x18'))['db'];function respondWithStatusCode(_0x4cf55d,_0x5ca3d7){_0x5ca3d7=_0x5ca3d7||0xcc;return function(_0xa03ec7){if(_0xa03ec7){return _0x4cf55d[_0xe2a2('0x19')](_0x5ca3d7);}return _0x4cf55d[_0xe2a2('0x1a')](_0x5ca3d7)[_0xe2a2('0x1b')]();};}function respondWithResult(_0xa7a693,_0x5cc133){_0x5cc133=_0x5cc133||0xc8;return function(_0x2a217f){if(_0x2a217f){return _0xa7a693[_0xe2a2('0x1a')](_0x5cc133)[_0xe2a2('0x1c')](_0x2a217f);}};}function respondWithFilteredResult(_0x4bf7fc,_0x555410){return function(_0x24534f){if(_0x24534f){var _0x567a7c=typeof _0x555410['offset']===_0xe2a2('0x1d')&&typeof _0x555410[_0xe2a2('0x1e')]===_0xe2a2('0x1d');var _0x557fa2=_0x24534f['count'];var _0x332e19=_0x567a7c?0x0:_0x555410[_0xe2a2('0x1f')];var _0x478472=_0x567a7c?_0x24534f[_0xe2a2('0x20')]:_0x555410['offset']+_0x555410[_0xe2a2('0x1e')];var _0x1c7d7d;if(_0x478472>=_0x557fa2){_0x478472=_0x557fa2;_0x1c7d7d=0xc8;}else{_0x1c7d7d=0xce;}_0x4bf7fc[_0xe2a2('0x1a')](_0x1c7d7d);return _0x4bf7fc[_0xe2a2('0x21')](_0xe2a2('0x22'),_0x332e19+'-'+_0x478472+'/'+_0x557fa2)[_0xe2a2('0x1c')](_0x24534f);}return null;};}function patchUpdates(_0x52adfa){return function(_0xe462c8){try{jsonpatch['apply'](_0xe462c8,_0x52adfa,!![]);}catch(_0x19bca8){return BPromise[_0xe2a2('0x23')](_0x19bca8);}return _0xe462c8['save']();};}function saveUpdates(_0x1efa66,_0x177eab){return function(_0x2b725a){if(_0x2b725a){return _0x2b725a[_0xe2a2('0x24')](_0x1efa66)[_0xe2a2('0x25')](function(_0x11c881){return _0x11c881;});}return null;};}function removeEntity(_0x4e93f6,_0x3e40f0){return function(_0xe94a9b){if(_0xe94a9b){return _0xe94a9b[_0xe2a2('0x26')]()['then'](function(){var _0x7f634=_0xe94a9b['get']({'plain':!![]});var _0x5f673d=_0xe2a2('0x27');return db[_0xe2a2('0x28')]['destroy']({'where':{'type':_0x5f673d,'resourceId':_0x7f634['id']}})[_0xe2a2('0x25')](function(){return _0xe94a9b;});})['then'](function(){_0x4e93f6[_0xe2a2('0x1a')](0xcc)[_0xe2a2('0x1b')]();});}};}function handleEntityNotFound(_0x5aa89f,_0x2c0952){return function(_0x3e75b9){if(!_0x3e75b9){_0x5aa89f[_0xe2a2('0x19')](0x194);}return _0x3e75b9;};}function handleError(_0x14e6e5,_0x642c39){_0x642c39=_0x642c39||0x1f4;return function(_0x186463){logger[_0xe2a2('0x29')](_0x186463['stack']);if(_0x186463[_0xe2a2('0x2a')]){delete _0x186463[_0xe2a2('0x2a')];}_0x14e6e5[_0xe2a2('0x1a')](_0x642c39)['send'](_0x186463);};}exports['index']=function(_0x52e2a8,_0xa4de39){var _0x1a6c7b={},_0x5b9455={},_0x25f3ca={'count':0x0,'rows':[]};var _0x1303af=_[_0xe2a2('0x2b')](db[_0xe2a2('0x2c')][_0xe2a2('0x2d')],function(_0x537ee9){return{'name':_0x537ee9[_0xe2a2('0x2e')],'type':_0x537ee9[_0xe2a2('0x2f')][_0xe2a2('0x30')]};});_0x5b9455[_0xe2a2('0x31')]=_[_0xe2a2('0x2b')](_0x1303af,_0xe2a2('0x2a'));_0x5b9455[_0xe2a2('0x32')]=_['keys'](_0x52e2a8[_0xe2a2('0x32')]);_0x5b9455['filters']=_[_0xe2a2('0x33')](_0x5b9455[_0xe2a2('0x31')],_0x5b9455[_0xe2a2('0x32')]);_0x1a6c7b[_0xe2a2('0x34')]=_[_0xe2a2('0x33')](_0x5b9455['model'],qs[_0xe2a2('0x35')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x35')]));_0x1a6c7b[_0xe2a2('0x34')]=_0x1a6c7b['attributes'][_0xe2a2('0x36')]?_0x1a6c7b[_0xe2a2('0x34')]:_0x5b9455[_0xe2a2('0x31')];if(!_0x52e2a8['query'][_0xe2a2('0x37')](_0xe2a2('0x38'))){_0x1a6c7b['limit']=qs[_0xe2a2('0x1e')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x1e')]);_0x1a6c7b['offset']=qs[_0xe2a2('0x1f')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x1f')]);}_0x1a6c7b[_0xe2a2('0x39')]=qs[_0xe2a2('0x3a')](_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x3a')]);_0x1a6c7b[_0xe2a2('0x3b')]=qs[_0xe2a2('0x3c')](_[_0xe2a2('0x3d')](_0x52e2a8[_0xe2a2('0x32')],_0x5b9455['filters']),_0x1303af);if(_0x52e2a8[_0xe2a2('0x32')]['filter']){_0x1a6c7b['where']=_['merge'](_0x1a6c7b['where'],{'$or':_[_0xe2a2('0x2b')](_0x1303af,function(_0x502a50){if(_0x502a50[_0xe2a2('0x2f')]!==_0xe2a2('0x3e')){var _0x5c7948={};_0x5c7948[_0x502a50['name']]={'$like':'%'+_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x3f')]+'%'};return _0x5c7948;}})});}_0x1a6c7b=_[_0xe2a2('0x40')]({},_0x1a6c7b,_0x52e2a8[_0xe2a2('0x41')]);var _0x442a4c={'where':_0x1a6c7b[_0xe2a2('0x3b')]};return db[_0xe2a2('0x2c')][_0xe2a2('0x20')](_0x442a4c)[_0xe2a2('0x25')](function(_0xc2257){_0x25f3ca[_0xe2a2('0x20')]=_0xc2257;if(_0x52e2a8[_0xe2a2('0x32')][_0xe2a2('0x42')]){_0x1a6c7b[_0xe2a2('0x43')]=[{'all':!![]}];}return db[_0xe2a2('0x2c')][_0xe2a2('0x44')](_0x1a6c7b);})[_0xe2a2('0x25')](function(_0x2709c9){_0x25f3ca[_0xe2a2('0x45')]=_0x2709c9;return _0x25f3ca;})['then'](respondWithFilteredResult(_0xa4de39,_0x1a6c7b))[_0xe2a2('0x46')](handleError(_0xa4de39,null));};exports[_0xe2a2('0x47')]=function(_0x18599c,_0x294892){var _0x44fc53={'raw':!![],'where':{'id':_0x18599c[_0xe2a2('0x48')]['id']}},_0x349164={};_0x349164[_0xe2a2('0x31')]=_['keys'](db['SquareOdbc'][_0xe2a2('0x2d')]);_0x349164['query']=_[_0xe2a2('0x49')](_0x18599c[_0xe2a2('0x32')]);_0x349164[_0xe2a2('0x3c')]=_[_0xe2a2('0x33')](_0x349164['model'],_0x349164[_0xe2a2('0x32')]);_0x44fc53[_0xe2a2('0x34')]=_[_0xe2a2('0x33')](_0x349164['model'],qs[_0xe2a2('0x35')](_0x18599c[_0xe2a2('0x32')][_0xe2a2('0x35')]));_0x44fc53['attributes']=_0x44fc53[_0xe2a2('0x34')]['length']?_0x44fc53[_0xe2a2('0x34')]:_0x349164[_0xe2a2('0x31')];if(_0x18599c[_0xe2a2('0x32')][_0xe2a2('0x42')]){_0x44fc53[_0xe2a2('0x43')]=[{'all':!![]}];}_0x44fc53=_[_0xe2a2('0x40')]({},_0x44fc53,_0x18599c[_0xe2a2('0x41')]);return db['SquareOdbc'][_0xe2a2('0x4a')](_0x44fc53)[_0xe2a2('0x25')](handleEntityNotFound(_0x294892,null))[_0xe2a2('0x25')](respondWithResult(_0x294892,null))['catch'](handleError(_0x294892,null));};exports[_0xe2a2('0x4b')]=function(_0x36518c,_0x5a9ab7){return db[_0xe2a2('0x2c')][_0xe2a2('0x4b')](_0x36518c[_0xe2a2('0x4c')],{})[_0xe2a2('0x25')](function(_0x454bfa){var _0x41bb6d=_0x36518c[_0xe2a2('0x4d')][_0xe2a2('0x4e')]({'plain':!![]});if(!_0x41bb6d)throw new Error(_0xe2a2('0x4f'));if(_0x41bb6d[_0xe2a2('0x50')]===_0xe2a2('0x4d')){var _0x120835=_0x454bfa[_0xe2a2('0x4e')]({'plain':!![]});var _0x9035b6='ODBC';return db[_0xe2a2('0x51')][_0xe2a2('0x4a')]({'where':{'name':_0x9035b6,'userProfileId':_0x41bb6d[_0xe2a2('0x52')]},'raw':!![]})[_0xe2a2('0x25')](function(_0x48d081){if(_0x48d081&&_0x48d081[_0xe2a2('0x53')]===0x0){return db['UserProfileResource'][_0xe2a2('0x4b')]({'name':_0x120835[_0xe2a2('0x2a')],'resourceId':_0x120835['id'],'type':_0x48d081[_0xe2a2('0x2a')],'sectionId':_0x48d081['id']},{})['then'](function(){return _0x454bfa;});}else{return _0x454bfa;}})[_0xe2a2('0x46')](function(_0x7f01dd){logger[_0xe2a2('0x29')](_0xe2a2('0x54'),_0x7f01dd);throw _0x7f01dd;});}return _0x454bfa;})[_0xe2a2('0x25')](respondWithResult(_0x5a9ab7,0xc9))[_0xe2a2('0x46')](handleError(_0x5a9ab7,null));};exports['update']=function(_0x189ac0,_0x288a61){if(_0x189ac0[_0xe2a2('0x4c')]['id']){delete _0x189ac0[_0xe2a2('0x4c')]['id'];}return db['SquareOdbc'][_0xe2a2('0x4a')]({'where':{'id':_0x189ac0['params']['id']}})['then'](handleEntityNotFound(_0x288a61,null))[_0xe2a2('0x25')](saveUpdates(_0x189ac0[_0xe2a2('0x4c')],null))[_0xe2a2('0x25')](respondWithResult(_0x288a61,null))['catch'](handleError(_0x288a61,null));};exports[_0xe2a2('0x26')]=function(_0x55f1dc,_0x6c2d9){return db[_0xe2a2('0x2c')][_0xe2a2('0x4a')]({'where':{'id':_0x55f1dc[_0xe2a2('0x48')]['id']}})[_0xe2a2('0x25')](handleEntityNotFound(_0x6c2d9,null))[_0xe2a2('0x25')](removeEntity(_0x6c2d9,null))[_0xe2a2('0x46')](handleError(_0x6c2d9,null));};exports['test']=function(_0x7788f1,_0x37de97,_0x4a7680){var _0x5cbb72;return db[_0xe2a2('0x2c')][_0xe2a2('0x4a')]({'where':{'id':_0x7788f1['params']['id']},'attributes':['id',_0xe2a2('0x55')]})[_0xe2a2('0x25')](handleEntityNotFound(_0x37de97,null))['then'](function(_0x43d908){if(_0x43d908){var _0x66bf98=require('odbc')();_0x66bf98[_0xe2a2('0x56')](_0x43d908[_0xe2a2('0x55')]);_0x66bf98['closeSync']();return _0x43d908;}})[_0xe2a2('0x25')](respondWithResult(_0x37de97,null))[_0xe2a2('0x46')](handleError(_0x37de97,null));};