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 _0x08fd=['zip-dir','fast-json-patch','moment','util','path','sox','to-csv','ejs','fs-extra','squel','crypto','querystring','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','count','offset','limit','Content-Range','apply','reject','then','get','ODBC','error','name','index','map','SquareOdbc','rawAttributes','fieldName','type','key','model','query','filters','intersection','attributes','fields','hasOwnProperty','nolimit','sort','where','pick','filter','VIRTUAL','merge','options','includeAll','include','findAll','rows','show','params','keys','length','find','catch','create','user','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','autoAssociation','UserProfileResource','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','destroy','test','dsn','odbc','openSync','closeSync','eml-format','rimraf'];(function(_0x21c225,_0x531849){var _0x539351=function(_0x48fef3){while(--_0x48fef3){_0x21c225['push'](_0x21c225['shift']());}};_0x539351(++_0x531849);}(_0x08fd,0xa6));var _0xd08f=function(_0x43fd4e,_0x52c4a6){_0x43fd4e=_0x43fd4e-0x0;var _0x456822=_0x08fd[_0x43fd4e];return _0x456822;};'use strict';var emlformat=require(_0xd08f('0x0'));var rimraf=require(_0xd08f('0x1'));var zipdir=require(_0xd08f('0x2'));var jsonpatch=require(_0xd08f('0x3'));var rp=require('request-promise');var moment=require(_0xd08f('0x4'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0xd08f('0x5'));var path=require(_0xd08f('0x6'));var sox=require(_0xd08f('0x7'));var csv=require(_0xd08f('0x8'));var ejs=require(_0xd08f('0x9'));var fs=require('fs');var fs_extra=require(_0xd08f('0xa'));var _=require('lodash');var squel=require(_0xd08f('0xb'));var crypto=require(_0xd08f('0xc'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require(_0xd08f('0x8'));var querystring=require(_0xd08f('0xd'));var Papa=require(_0xd08f('0xe'));var Redis=require(_0xd08f('0xf'));var authService=require(_0xd08f('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd08f('0x11'));var logger=require('../../config/logger')(_0xd08f('0x12'));var utils=require('../../config/utils');var config=require(_0xd08f('0x13'));var licenseUtil=require(_0xd08f('0x14'));var db=require(_0xd08f('0x15'))['db'];function respondWithStatusCode(_0x3e8c38,_0x3f6136){_0x3f6136=_0x3f6136||0xcc;return function(_0x15664b){if(_0x15664b){return _0x3e8c38[_0xd08f('0x16')](_0x3f6136);}return _0x3e8c38[_0xd08f('0x17')](_0x3f6136)[_0xd08f('0x18')]();};}function respondWithResult(_0x59c987,_0x4c2fc3){_0x4c2fc3=_0x4c2fc3||0xc8;return function(_0x1bc5a0){if(_0x1bc5a0){return _0x59c987['status'](_0x4c2fc3)[_0xd08f('0x19')](_0x1bc5a0);}};}function respondWithFilteredResult(_0x136dbe,_0x58fd99){return function(_0x2027db){if(_0x2027db){var _0x36299d=_0x2027db[_0xd08f('0x1a')],_0x4c9e40=_0x58fd99[_0xd08f('0x1b')],_0x668607=_0x58fd99['offset']+_0x58fd99[_0xd08f('0x1c')],_0x1efc45;if(_0x668607>=_0x36299d){_0x668607=_0x36299d;_0x1efc45=0xc8;}else{_0x1efc45=0xce;}_0x136dbe['status'](_0x1efc45);return _0x136dbe['set'](_0xd08f('0x1d'),_0x4c9e40+'-'+_0x668607+'/'+_0x36299d)[_0xd08f('0x19')](_0x2027db);}return null;};}function patchUpdates(_0x217bfe){return function(_0x29bdc9){try{jsonpatch[_0xd08f('0x1e')](_0x29bdc9,_0x217bfe,!![]);}catch(_0x3a953b){return BPromise[_0xd08f('0x1f')](_0x3a953b);}return _0x29bdc9['save']();};}function saveUpdates(_0x52622b,_0x7032c1){return function(_0x366758){if(_0x366758){return _0x366758['update'](_0x52622b)[_0xd08f('0x20')](function(_0x552e22){return _0x552e22;});}return null;};}function removeEntity(_0x66f5d2,_0x480465){return function(_0x304c84){if(_0x304c84){return _0x304c84['destroy']()[_0xd08f('0x20')](function(){var _0x2a86aa=_0x304c84[_0xd08f('0x21')]({'plain':!![]});var _0x94940b=_0xd08f('0x22');return db['UserProfileResource']['destroy']({'where':{'type':_0x94940b,'resourceId':_0x2a86aa['id']}})[_0xd08f('0x20')](function(){return _0x304c84;});})['then'](function(){_0x66f5d2[_0xd08f('0x17')](0xcc)[_0xd08f('0x18')]();});}};}function handleEntityNotFound(_0x1fe448,_0x46bc2a){return function(_0x14010d){if(!_0x14010d){_0x1fe448[_0xd08f('0x16')](0x194);}return _0x14010d;};}function handleError(_0x2d9dc5,_0x4cd769){_0x4cd769=_0x4cd769||0x1f4;return function(_0x150af3){logger[_0xd08f('0x23')](_0x150af3['stack']);if(_0x150af3[_0xd08f('0x24')]){delete _0x150af3['name'];}_0x2d9dc5[_0xd08f('0x17')](_0x4cd769)['send'](_0x150af3);};}exports[_0xd08f('0x25')]=function(_0x27d048,_0xde2de4){var _0x39b86a={},_0x1786ae={},_0x31ce0e={'count':0x0,'rows':[]};var _0x1b9c51=_[_0xd08f('0x26')](db[_0xd08f('0x27')][_0xd08f('0x28')],function(_0x4cc291){return{'name':_0x4cc291[_0xd08f('0x29')],'type':_0x4cc291[_0xd08f('0x2a')][_0xd08f('0x2b')]};});_0x1786ae[_0xd08f('0x2c')]=_[_0xd08f('0x26')](_0x1b9c51,_0xd08f('0x24'));_0x1786ae[_0xd08f('0x2d')]=_['keys'](_0x27d048[_0xd08f('0x2d')]);_0x1786ae[_0xd08f('0x2e')]=_[_0xd08f('0x2f')](_0x1786ae['model'],_0x1786ae[_0xd08f('0x2d')]);_0x39b86a[_0xd08f('0x30')]=_[_0xd08f('0x2f')](_0x1786ae['model'],qs[_0xd08f('0x31')](_0x27d048[_0xd08f('0x2d')][_0xd08f('0x31')]));_0x39b86a[_0xd08f('0x30')]=_0x39b86a['attributes']['length']?_0x39b86a[_0xd08f('0x30')]:_0x1786ae[_0xd08f('0x2c')];if(!_0x27d048['query'][_0xd08f('0x32')](_0xd08f('0x33'))){_0x39b86a[_0xd08f('0x1c')]=qs[_0xd08f('0x1c')](_0x27d048['query'][_0xd08f('0x1c')]);_0x39b86a[_0xd08f('0x1b')]=qs[_0xd08f('0x1b')](_0x27d048[_0xd08f('0x2d')][_0xd08f('0x1b')]);}_0x39b86a['order']=qs[_0xd08f('0x34')](_0x27d048[_0xd08f('0x2d')][_0xd08f('0x34')]);_0x39b86a[_0xd08f('0x35')]=qs[_0xd08f('0x2e')](_[_0xd08f('0x36')](_0x27d048[_0xd08f('0x2d')],_0x1786ae['filters']),_0x1b9c51);if(_0x27d048[_0xd08f('0x2d')][_0xd08f('0x37')]){_0x39b86a[_0xd08f('0x35')]=_['merge'](_0x39b86a['where'],{'$or':_[_0xd08f('0x26')](_0x1b9c51,function(_0x10100b){if(_0x10100b[_0xd08f('0x2a')]!==_0xd08f('0x38')){var _0x517dd2={};_0x517dd2[_0x10100b['name']]={'$like':'%'+_0x27d048[_0xd08f('0x2d')][_0xd08f('0x37')]+'%'};return _0x517dd2;}})});}_0x39b86a=_[_0xd08f('0x39')]({},_0x39b86a,_0x27d048[_0xd08f('0x3a')]);var _0x583d3d={'where':_0x39b86a['where']};return db[_0xd08f('0x27')][_0xd08f('0x1a')](_0x583d3d)[_0xd08f('0x20')](function(_0x54409a){_0x31ce0e[_0xd08f('0x1a')]=_0x54409a;if(_0x27d048['query'][_0xd08f('0x3b')]){_0x39b86a[_0xd08f('0x3c')]=[{'all':!![]}];}return db[_0xd08f('0x27')][_0xd08f('0x3d')](_0x39b86a);})['then'](function(_0x4b598f){_0x31ce0e[_0xd08f('0x3e')]=_0x4b598f;return _0x31ce0e;})['then'](respondWithFilteredResult(_0xde2de4,_0x39b86a))['catch'](handleError(_0xde2de4,null));};exports[_0xd08f('0x3f')]=function(_0x3ca9ef,_0x19d207){var _0x7f6aa9={'raw':!![],'where':{'id':_0x3ca9ef[_0xd08f('0x40')]['id']}},_0x1b52e7={};_0x1b52e7[_0xd08f('0x2c')]=_[_0xd08f('0x41')](db[_0xd08f('0x27')][_0xd08f('0x28')]);_0x1b52e7[_0xd08f('0x2d')]=_[_0xd08f('0x41')](_0x3ca9ef[_0xd08f('0x2d')]);_0x1b52e7[_0xd08f('0x2e')]=_[_0xd08f('0x2f')](_0x1b52e7[_0xd08f('0x2c')],_0x1b52e7['query']);_0x7f6aa9[_0xd08f('0x30')]=_[_0xd08f('0x2f')](_0x1b52e7[_0xd08f('0x2c')],qs[_0xd08f('0x31')](_0x3ca9ef['query'][_0xd08f('0x31')]));_0x7f6aa9[_0xd08f('0x30')]=_0x7f6aa9['attributes'][_0xd08f('0x42')]?_0x7f6aa9[_0xd08f('0x30')]:_0x1b52e7[_0xd08f('0x2c')];if(_0x3ca9ef[_0xd08f('0x2d')]['includeAll']){_0x7f6aa9[_0xd08f('0x3c')]=[{'all':!![]}];}_0x7f6aa9=_['merge']({},_0x7f6aa9,_0x3ca9ef['options']);return db[_0xd08f('0x27')][_0xd08f('0x43')](_0x7f6aa9)[_0xd08f('0x20')](handleEntityNotFound(_0x19d207,null))['then'](respondWithResult(_0x19d207,null))[_0xd08f('0x44')](handleError(_0x19d207,null));};exports[_0xd08f('0x45')]=function(_0x2de5fe,_0x4c0958){return db['SquareOdbc'][_0xd08f('0x45')](_0x2de5fe['body'],{})[_0xd08f('0x20')](function(_0x4e1ef8){var _0x583981=_0x2de5fe[_0xd08f('0x46')]['get']({'plain':!![]});if(!_0x583981)throw new Error(_0xd08f('0x47'));if(_0x583981[_0xd08f('0x48')]==='user'){var _0x472a58=_0x4e1ef8['get']({'plain':!![]});var _0x5573de=_0xd08f('0x22');return db['UserProfileSection'][_0xd08f('0x43')]({'where':{'name':_0x5573de,'userProfileId':_0x583981['userProfileId']},'raw':!![]})[_0xd08f('0x20')](function(_0x2f818f){if(_0x2f818f&&_0x2f818f[_0xd08f('0x49')]===0x0){return db[_0xd08f('0x4a')]['create']({'name':_0x472a58[_0xd08f('0x24')],'resourceId':_0x472a58['id'],'type':_0x2f818f[_0xd08f('0x24')],'sectionId':_0x2f818f['id']},{})['then'](function(){return _0x4e1ef8;});}else{return _0x4e1ef8;}})[_0xd08f('0x44')](function(_0x2c50f3){logger[_0xd08f('0x23')](_0xd08f('0x4b'),_0x2c50f3);throw _0x2c50f3;});}return _0x4e1ef8;})[_0xd08f('0x20')](respondWithResult(_0x4c0958,0xc9))['catch'](handleError(_0x4c0958,null));};exports[_0xd08f('0x4c')]=function(_0xa8c800,_0x3da7ed){if(_0xa8c800['body']['id']){delete _0xa8c800[_0xd08f('0x4d')]['id'];}return db[_0xd08f('0x27')][_0xd08f('0x43')]({'where':{'id':_0xa8c800[_0xd08f('0x40')]['id']}})[_0xd08f('0x20')](handleEntityNotFound(_0x3da7ed,null))['then'](saveUpdates(_0xa8c800[_0xd08f('0x4d')],null))['then'](respondWithResult(_0x3da7ed,null))[_0xd08f('0x44')](handleError(_0x3da7ed,null));};exports[_0xd08f('0x4e')]=function(_0x2f1306,_0x50fd47){return db[_0xd08f('0x27')][_0xd08f('0x43')]({'where':{'id':_0x2f1306[_0xd08f('0x40')]['id']}})[_0xd08f('0x20')](handleEntityNotFound(_0x50fd47,null))[_0xd08f('0x20')](removeEntity(_0x50fd47,null))[_0xd08f('0x44')](handleError(_0x50fd47,null));};exports[_0xd08f('0x4f')]=function(_0x2b0496,_0x1424c2,_0x4262f7){var _0x5e9917;return db[_0xd08f('0x27')][_0xd08f('0x43')]({'where':{'id':_0x2b0496[_0xd08f('0x40')]['id']},'attributes':['id',_0xd08f('0x50')]})[_0xd08f('0x20')](handleEntityNotFound(_0x1424c2,null))[_0xd08f('0x20')](function(_0x3b62ef){if(_0x3b62ef){var _0x4ca48b=require(_0xd08f('0x51'))();_0x4ca48b[_0xd08f('0x52')](_0x3b62ef[_0xd08f('0x50')]);_0x4ca48b[_0xd08f('0x53')]();return _0x3b62ef;}})['then'](respondWithResult(_0x1424c2,null))[_0xd08f('0x44')](handleError(_0x1424c2,null));};