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 _0x6e7d=['status','count','offset','limit','set','json','reject','save','update','then','destroy','get','ODBC','end','error','stack','name','send','SquareOdbc','fieldName','type','model','map','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','params','rawAttributes','length','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','UserProfileSection','userProfileId','autoAssociation','catch','find','test','openSync','html-pdf','rimraf','zip-dir','fast-json-patch','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','squel','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus'];(function(_0x3e67c0,_0xa047a){var _0x3cbec7=function(_0x552027){while(--_0x552027){_0x3e67c0['push'](_0x3e67c0['shift']());}};_0x3cbec7(++_0xa047a);}(_0x6e7d,0x13a));var _0xd6e7=function(_0xbbcb36,_0x586383){_0xbbcb36=_0xbbcb36-0x0;var _0x4278ff=_0x6e7d[_0xbbcb36];return _0x4278ff;};'use strict';var pdf=require(_0xd6e7('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xd6e7('0x1'));var zipdir=require(_0xd6e7('0x2'));var jsonpatch=require(_0xd6e7('0x3'));var rp=require('request-promise');var moment=require(_0xd6e7('0x4'));var BPromise=require(_0xd6e7('0x5'));var Mustache=require(_0xd6e7('0x6'));var util=require(_0xd6e7('0x7'));var path=require(_0xd6e7('0x8'));var sox=require(_0xd6e7('0x9'));var csv=require(_0xd6e7('0xa'));var ejs=require(_0xd6e7('0xb'));var fs=require('fs');var _=require(_0xd6e7('0xc'));var squel=require(_0xd6e7('0xd'));var crypto=require('crypto');var jsforce=require(_0xd6e7('0xe'));var deskjs=require(_0xd6e7('0xf'));var toCsv=require(_0xd6e7('0xa'));var querystring=require(_0xd6e7('0x10'));var Papa=require('papaparse');var Redis=require(_0xd6e7('0x11'));var authService=require(_0xd6e7('0x12'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd6e7('0x13'));var logger=require(_0xd6e7('0x14'))(_0xd6e7('0x15'));var utils=require(_0xd6e7('0x16'));var config=require(_0xd6e7('0x17'));var db=require(_0xd6e7('0x18'))['db'];function respondWithStatusCode(_0x194cec,_0xde2da3){_0xde2da3=_0xde2da3||0xcc;return function(_0x3ae464){if(_0x3ae464){return _0x194cec[_0xd6e7('0x19')](_0xde2da3);}return _0x194cec[_0xd6e7('0x1a')](_0xde2da3)['end']();};}function respondWithResult(_0x4339d8,_0x2d0923){_0x2d0923=_0x2d0923||0xc8;return function(_0x58b4ab){if(_0x58b4ab){return _0x4339d8[_0xd6e7('0x1a')](_0x2d0923)['json'](_0x58b4ab);}};}function respondWithFilteredResult(_0x52492e,_0x354977){return function(_0x1ad410){if(_0x1ad410){var _0x1e9ed0=_0x1ad410[_0xd6e7('0x1b')],_0x307349=_0x354977[_0xd6e7('0x1c')],_0x37db03=_0x354977[_0xd6e7('0x1c')]+_0x354977[_0xd6e7('0x1d')],_0x908b46;if(_0x37db03>=_0x1e9ed0){_0x37db03=_0x1e9ed0;_0x908b46=0xc8;}else{_0x908b46=0xce;}_0x52492e[_0xd6e7('0x1a')](_0x908b46);return _0x52492e[_0xd6e7('0x1e')]('Content-Range',_0x307349+'-'+_0x37db03+'/'+_0x1e9ed0)[_0xd6e7('0x1f')](_0x1ad410);}return null;};}function patchUpdates(_0x58ebb2){return function(_0xbf5c2c){try{jsonpatch['apply'](_0xbf5c2c,_0x58ebb2,!![]);}catch(_0x3fa8ed){return BPromise[_0xd6e7('0x20')](_0x3fa8ed);}return _0xbf5c2c[_0xd6e7('0x21')]();};}function saveUpdates(_0x2916f8,_0x25c5e1){return function(_0x239687){if(_0x239687){return _0x239687[_0xd6e7('0x22')](_0x2916f8)[_0xd6e7('0x23')](function(_0x57ffce){return _0x57ffce;});}return null;};}function removeEntity(_0x2bb7a0,_0x53f9e6){return function(_0x571d1c){if(_0x571d1c){return _0x571d1c[_0xd6e7('0x24')]()[_0xd6e7('0x23')](function(){var _0x2c6e88=_0x571d1c[_0xd6e7('0x25')]({'plain':!![]});var _0x4fdd82=_0xd6e7('0x26');return db['UserProfileResource'][_0xd6e7('0x24')]({'where':{'type':_0x4fdd82,'resourceId':_0x2c6e88['id']}})[_0xd6e7('0x23')](function(){return _0x571d1c;});})[_0xd6e7('0x23')](function(){_0x2bb7a0[_0xd6e7('0x1a')](0xcc)[_0xd6e7('0x27')]();});}};}function handleEntityNotFound(_0x59a1e6,_0xbe87eb){return function(_0x2e069e){if(!_0x2e069e){_0x59a1e6['sendStatus'](0x194);}return _0x2e069e;};}function handleError(_0x41c0a5,_0x60d391){_0x60d391=_0x60d391||0x1f4;return function(_0x39b793){logger[_0xd6e7('0x28')](_0x39b793[_0xd6e7('0x29')]);if(_0x39b793[_0xd6e7('0x2a')]){delete _0x39b793[_0xd6e7('0x2a')];}_0x41c0a5[_0xd6e7('0x1a')](_0x60d391)[_0xd6e7('0x2b')](_0x39b793);};}exports['index']=function(_0xfd1539,_0x14aa76){var _0x524120={},_0x4d1c41={},_0x3b2435={'count':0x0,'rows':[]};var _0x4ce017=_['map'](db[_0xd6e7('0x2c')]['rawAttributes'],function(_0x5b868e){return{'name':_0x5b868e[_0xd6e7('0x2d')],'type':_0x5b868e[_0xd6e7('0x2e')]['key']};});_0x4d1c41[_0xd6e7('0x2f')]=_[_0xd6e7('0x30')](_0x4ce017,_0xd6e7('0x2a'));_0x4d1c41[_0xd6e7('0x31')]=_[_0xd6e7('0x32')](_0xfd1539[_0xd6e7('0x31')]);_0x4d1c41[_0xd6e7('0x33')]=_[_0xd6e7('0x34')](_0x4d1c41[_0xd6e7('0x2f')],_0x4d1c41['query']);_0x524120[_0xd6e7('0x35')]=_['intersection'](_0x4d1c41[_0xd6e7('0x2f')],qs[_0xd6e7('0x36')](_0xfd1539['query'][_0xd6e7('0x36')]));_0x524120[_0xd6e7('0x35')]=_0x524120[_0xd6e7('0x35')]['length']?_0x524120[_0xd6e7('0x35')]:_0x4d1c41['model'];if(!_0xfd1539[_0xd6e7('0x31')][_0xd6e7('0x37')](_0xd6e7('0x38'))){_0x524120[_0xd6e7('0x1d')]=qs[_0xd6e7('0x1d')](_0xfd1539[_0xd6e7('0x31')][_0xd6e7('0x1d')]);_0x524120[_0xd6e7('0x1c')]=qs[_0xd6e7('0x1c')](_0xfd1539['query'][_0xd6e7('0x1c')]);}_0x524120[_0xd6e7('0x39')]=qs['sort'](_0xfd1539['query'][_0xd6e7('0x3a')]);_0x524120['where']=qs['filters'](_[_0xd6e7('0x3b')](_0xfd1539[_0xd6e7('0x31')],_0x4d1c41[_0xd6e7('0x33')]));if(_0xfd1539[_0xd6e7('0x31')][_0xd6e7('0x3c')]){_0x524120[_0xd6e7('0x3d')]=_[_0xd6e7('0x3e')](_0x524120[_0xd6e7('0x3d')],{'$or':_[_0xd6e7('0x30')](_0x4ce017,function(_0x1f5596){if(_0x1f5596[_0xd6e7('0x2e')]!==_0xd6e7('0x3f')){var _0x1cf24b={};_0x1cf24b[_0x1f5596['name']]={'$like':'%'+_0xfd1539[_0xd6e7('0x31')]['filter']+'%'};return _0x1cf24b;}})});}_0x524120=_[_0xd6e7('0x3e')]({},_0x524120,_0xfd1539[_0xd6e7('0x40')]);var _0x5aa11c={'where':_0x524120[_0xd6e7('0x3d')]};return db[_0xd6e7('0x2c')][_0xd6e7('0x1b')](_0x5aa11c)[_0xd6e7('0x23')](function(_0x10bc8d){_0x3b2435[_0xd6e7('0x1b')]=_0x10bc8d;if(_0xfd1539[_0xd6e7('0x31')][_0xd6e7('0x41')]){_0x524120[_0xd6e7('0x42')]=[{'all':!![]}];}return db[_0xd6e7('0x2c')][_0xd6e7('0x43')](_0x524120);})[_0xd6e7('0x23')](function(_0x5c15ca){_0x3b2435[_0xd6e7('0x44')]=_0x5c15ca;return _0x3b2435;})[_0xd6e7('0x23')](respondWithFilteredResult(_0x14aa76,_0x524120))['catch'](handleError(_0x14aa76,null));};exports[_0xd6e7('0x45')]=function(_0x5c0dc2,_0x4921e3){var _0x4cdb62={'raw':!![],'where':{'id':_0x5c0dc2[_0xd6e7('0x46')]['id']}},_0x380b76={};_0x380b76[_0xd6e7('0x2f')]=_[_0xd6e7('0x32')](db[_0xd6e7('0x2c')][_0xd6e7('0x47')]);_0x380b76['query']=_[_0xd6e7('0x32')](_0x5c0dc2[_0xd6e7('0x31')]);_0x380b76[_0xd6e7('0x33')]=_[_0xd6e7('0x34')](_0x380b76[_0xd6e7('0x2f')],_0x380b76['query']);_0x4cdb62['attributes']=_[_0xd6e7('0x34')](_0x380b76['model'],qs[_0xd6e7('0x36')](_0x5c0dc2[_0xd6e7('0x31')]['fields']));_0x4cdb62[_0xd6e7('0x35')]=_0x4cdb62[_0xd6e7('0x35')][_0xd6e7('0x48')]?_0x4cdb62['attributes']:_0x380b76[_0xd6e7('0x2f')];if(_0x5c0dc2[_0xd6e7('0x31')][_0xd6e7('0x41')]){_0x4cdb62[_0xd6e7('0x42')]=[{'all':!![]}];}_0x4cdb62=_[_0xd6e7('0x3e')]({},_0x4cdb62,_0x5c0dc2['options']);return db[_0xd6e7('0x2c')]['find'](_0x4cdb62)['then'](handleEntityNotFound(_0x4921e3,null))['then'](respondWithResult(_0x4921e3,null))['catch'](handleError(_0x4921e3,null));};exports[_0xd6e7('0x49')]=function(_0x8ebeed,_0x4e42b8){return db[_0xd6e7('0x2c')]['create'](_0x8ebeed[_0xd6e7('0x4a')],{})[_0xd6e7('0x23')](function(_0x577529){var _0x6b0cfe=_0x8ebeed['user'][_0xd6e7('0x25')]({'plain':!![]});if(!_0x6b0cfe)throw new Error(_0xd6e7('0x4b'));if(_0x6b0cfe[_0xd6e7('0x4c')]===_0xd6e7('0x4d')){var _0x56e44c=_0x577529[_0xd6e7('0x25')]({'plain':!![]});var _0x407260=_0xd6e7('0x26');return db[_0xd6e7('0x4e')]['find']({'where':{'name':_0x407260,'userProfileId':_0x6b0cfe[_0xd6e7('0x4f')]},'raw':!![]})[_0xd6e7('0x23')](function(_0x484682){if(_0x484682&&_0x484682[_0xd6e7('0x50')]===0x0){return db['UserProfileResource']['create']({'name':_0x56e44c[_0xd6e7('0x2a')],'resourceId':_0x56e44c['id'],'type':_0x484682[_0xd6e7('0x2a')],'sectionId':_0x484682['id']},{})['then'](function(){return _0x577529;});}else{return _0x577529;}})[_0xd6e7('0x51')](function(_0x28cf9e){logger[_0xd6e7('0x28')]('Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s',_0x28cf9e);throw _0x28cf9e;});}return _0x577529;})['then'](respondWithResult(_0x4e42b8,0xc9))['catch'](handleError(_0x4e42b8,null));};exports[_0xd6e7('0x22')]=function(_0x5cf368,_0x4b5cf8){if(_0x5cf368['body']['id']){delete _0x5cf368[_0xd6e7('0x4a')]['id'];}return db[_0xd6e7('0x2c')][_0xd6e7('0x52')]({'where':{'id':_0x5cf368[_0xd6e7('0x46')]['id']}})[_0xd6e7('0x23')](handleEntityNotFound(_0x4b5cf8,null))[_0xd6e7('0x23')](saveUpdates(_0x5cf368[_0xd6e7('0x4a')],null))[_0xd6e7('0x23')](respondWithResult(_0x4b5cf8,null))[_0xd6e7('0x51')](handleError(_0x4b5cf8,null));};exports[_0xd6e7('0x24')]=function(_0x313f76,_0x383e91){return db[_0xd6e7('0x2c')][_0xd6e7('0x52')]({'where':{'id':_0x313f76[_0xd6e7('0x46')]['id']}})[_0xd6e7('0x23')](handleEntityNotFound(_0x383e91,null))['then'](removeEntity(_0x383e91,null))[_0xd6e7('0x51')](handleError(_0x383e91,null));};exports[_0xd6e7('0x53')]=function(_0x2302a2,_0x2410b4,_0x1a9ac5){var _0x4c6e7e;return db['SquareOdbc'][_0xd6e7('0x52')]({'where':{'id':_0x2302a2[_0xd6e7('0x46')]['id']},'attributes':['id','dsn']})[_0xd6e7('0x23')](handleEntityNotFound(_0x2410b4,null))[_0xd6e7('0x23')](function(_0x2d81f8){if(_0x2d81f8){var _0x1af6ed=require('odbc')();_0x1af6ed[_0xd6e7('0x54')](_0x2d81f8['dsn']);_0x1af6ed['closeSync']();return _0x2d81f8;}})['then'](respondWithResult(_0x2410b4,null))[_0xd6e7('0x51')](handleError(_0x2410b4,null));};