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 _0xa55f=['to-csv','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','api','../../config/utils','../../config/license/util','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','then','destroy','UserProfileResource','error','stack','name','send','SquareOdbc','rawAttributes','fieldName','type','query','filters','model','attributes','intersection','fields','hasOwnProperty','sort','pick','filter','where','map','VIRTUAL','options','includeAll','findAll','rows','catch','keys','length','include','create','body','user','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','ODBC','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','params','test','dsn','openSync','closeSync','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path'];(function(_0x659004,_0x4f3962){var _0x539c22=function(_0x39d6d5){while(--_0x39d6d5){_0x659004['push'](_0x659004['shift']());}};_0x539c22(++_0x4f3962);}(_0xa55f,0x1ea));var _0xfa55=function(_0x2f8507,_0x2c0357){_0x2f8507=_0x2f8507-0x0;var _0x3c91ee=_0xa55f[_0x2f8507];return _0x3c91ee;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xfa55('0x0'));var zipdir=require(_0xfa55('0x1'));var jsonpatch=require('fast-json-patch');var rp=require(_0xfa55('0x2'));var moment=require(_0xfa55('0x3'));var BPromise=require(_0xfa55('0x4'));var Mustache=require(_0xfa55('0x5'));var util=require(_0xfa55('0x6'));var path=require(_0xfa55('0x7'));var sox=require('sox');var csv=require(_0xfa55('0x8'));var ejs=require(_0xfa55('0x9'));var fs=require('fs');var fs_extra=require(_0xfa55('0xa'));var _=require('lodash');var squel=require(_0xfa55('0xb'));var crypto=require(_0xfa55('0xc'));var jsforce=require(_0xfa55('0xd'));var deskjs=require(_0xfa55('0xe'));var toCsv=require(_0xfa55('0x8'));var querystring=require(_0xfa55('0xf'));var Papa=require('papaparse');var Redis=require(_0xfa55('0x10'));var authService=require(_0xfa55('0x11'));var qs=require('../../components/parsers/qs');var as=require(_0xfa55('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xfa55('0x13'));var utils=require(_0xfa55('0x14'));var config=require('../../config/environment');var licenseUtil=require(_0xfa55('0x15'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xc7cae4,_0x36a7d9){_0x36a7d9=_0x36a7d9||0xcc;return function(_0x131c52){if(_0x131c52){return _0xc7cae4[_0xfa55('0x16')](_0x36a7d9);}return _0xc7cae4[_0xfa55('0x17')](_0x36a7d9)[_0xfa55('0x18')]();};}function respondWithResult(_0x23fc82,_0x449a65){_0x449a65=_0x449a65||0xc8;return function(_0x4ddd5c){if(_0x4ddd5c){return _0x23fc82['status'](_0x449a65)[_0xfa55('0x19')](_0x4ddd5c);}};}function respondWithFilteredResult(_0x44901e,_0x34fd49){return function(_0x4a34cf){if(_0x4a34cf){var _0x4ac1b2=typeof _0x34fd49[_0xfa55('0x1a')]===_0xfa55('0x1b')&&typeof _0x34fd49[_0xfa55('0x1c')]===_0xfa55('0x1b');var _0x416bb7=_0x4a34cf[_0xfa55('0x1d')];var _0x48de6b=_0x4ac1b2?0x0:_0x34fd49[_0xfa55('0x1a')];var _0x4cccba=_0x4ac1b2?_0x4a34cf[_0xfa55('0x1d')]:_0x34fd49[_0xfa55('0x1a')]+_0x34fd49[_0xfa55('0x1c')];var _0xa7af54;if(_0x4cccba>=_0x416bb7){_0x4cccba=_0x416bb7;_0xa7af54=0xc8;}else{_0xa7af54=0xce;}_0x44901e[_0xfa55('0x17')](_0xa7af54);return _0x44901e[_0xfa55('0x1e')](_0xfa55('0x1f'),_0x48de6b+'-'+_0x4cccba+'/'+_0x416bb7)['json'](_0x4a34cf);}return null;};}function patchUpdates(_0xe060f0){return function(_0x35121d){try{jsonpatch[_0xfa55('0x20')](_0x35121d,_0xe060f0,!![]);}catch(_0x32c9fd){return BPromise[_0xfa55('0x21')](_0x32c9fd);}return _0x35121d[_0xfa55('0x22')]();};}function saveUpdates(_0x5bf8da,_0x38064a){return function(_0x6ca9dc){if(_0x6ca9dc){return _0x6ca9dc['update'](_0x5bf8da)[_0xfa55('0x23')](function(_0x47415f){return _0x47415f;});}return null;};}function removeEntity(_0x3b7a72,_0x211f80){return function(_0x2d025d){if(_0x2d025d){return _0x2d025d[_0xfa55('0x24')]()[_0xfa55('0x23')](function(){var _0x3a360f=_0x2d025d['get']({'plain':!![]});var _0x5147a3='ODBC';return db[_0xfa55('0x25')][_0xfa55('0x24')]({'where':{'type':_0x5147a3,'resourceId':_0x3a360f['id']}})['then'](function(){return _0x2d025d;});})[_0xfa55('0x23')](function(){_0x3b7a72[_0xfa55('0x17')](0xcc)[_0xfa55('0x18')]();});}};}function handleEntityNotFound(_0x4f87c9,_0x533956){return function(_0x21357a){if(!_0x21357a){_0x4f87c9['sendStatus'](0x194);}return _0x21357a;};}function handleError(_0x5631fb,_0x29ced4){_0x29ced4=_0x29ced4||0x1f4;return function(_0x3dd24d){logger[_0xfa55('0x26')](_0x3dd24d[_0xfa55('0x27')]);if(_0x3dd24d['name']){delete _0x3dd24d[_0xfa55('0x28')];}_0x5631fb[_0xfa55('0x17')](_0x29ced4)[_0xfa55('0x29')](_0x3dd24d);};}exports['index']=function(_0x3da8b3,_0x4d4320){var _0x432c15={},_0x4917da={},_0xfaf293={'count':0x0,'rows':[]};var _0x1ac70a=_['map'](db[_0xfa55('0x2a')][_0xfa55('0x2b')],function(_0x431446){return{'name':_0x431446[_0xfa55('0x2c')],'type':_0x431446[_0xfa55('0x2d')]['key']};});_0x4917da['model']=_['map'](_0x1ac70a,_0xfa55('0x28'));_0x4917da['query']=_['keys'](_0x3da8b3[_0xfa55('0x2e')]);_0x4917da[_0xfa55('0x2f')]=_['intersection'](_0x4917da[_0xfa55('0x30')],_0x4917da[_0xfa55('0x2e')]);_0x432c15[_0xfa55('0x31')]=_[_0xfa55('0x32')](_0x4917da[_0xfa55('0x30')],qs[_0xfa55('0x33')](_0x3da8b3[_0xfa55('0x2e')][_0xfa55('0x33')]));_0x432c15[_0xfa55('0x31')]=_0x432c15[_0xfa55('0x31')]['length']?_0x432c15['attributes']:_0x4917da[_0xfa55('0x30')];if(!_0x3da8b3[_0xfa55('0x2e')][_0xfa55('0x34')]('nolimit')){_0x432c15['limit']=qs[_0xfa55('0x1c')](_0x3da8b3['query']['limit']);_0x432c15[_0xfa55('0x1a')]=qs[_0xfa55('0x1a')](_0x3da8b3[_0xfa55('0x2e')][_0xfa55('0x1a')]);}_0x432c15['order']=qs['sort'](_0x3da8b3['query'][_0xfa55('0x35')]);_0x432c15['where']=qs['filters'](_[_0xfa55('0x36')](_0x3da8b3[_0xfa55('0x2e')],_0x4917da[_0xfa55('0x2f')]),_0x1ac70a);if(_0x3da8b3[_0xfa55('0x2e')][_0xfa55('0x37')]){_0x432c15[_0xfa55('0x38')]=_['merge'](_0x432c15['where'],{'$or':_[_0xfa55('0x39')](_0x1ac70a,function(_0x4e6ed9){if(_0x4e6ed9[_0xfa55('0x2d')]!==_0xfa55('0x3a')){var _0x334513={};_0x334513[_0x4e6ed9[_0xfa55('0x28')]]={'$like':'%'+_0x3da8b3['query'][_0xfa55('0x37')]+'%'};return _0x334513;}})});}_0x432c15=_['merge']({},_0x432c15,_0x3da8b3[_0xfa55('0x3b')]);var _0x1d9d60={'where':_0x432c15[_0xfa55('0x38')]};return db[_0xfa55('0x2a')]['count'](_0x1d9d60)[_0xfa55('0x23')](function(_0x5a8c01){_0xfaf293[_0xfa55('0x1d')]=_0x5a8c01;if(_0x3da8b3[_0xfa55('0x2e')][_0xfa55('0x3c')]){_0x432c15['include']=[{'all':!![]}];}return db[_0xfa55('0x2a')][_0xfa55('0x3d')](_0x432c15);})[_0xfa55('0x23')](function(_0x4127c1){_0xfaf293[_0xfa55('0x3e')]=_0x4127c1;return _0xfaf293;})[_0xfa55('0x23')](respondWithFilteredResult(_0x4d4320,_0x432c15))[_0xfa55('0x3f')](handleError(_0x4d4320,null));};exports['show']=function(_0x1ff7cd,_0x4b978a){var _0x4ce094={'raw':!![],'where':{'id':_0x1ff7cd['params']['id']}},_0x26c449={};_0x26c449[_0xfa55('0x30')]=_[_0xfa55('0x40')](db['SquareOdbc'][_0xfa55('0x2b')]);_0x26c449[_0xfa55('0x2e')]=_[_0xfa55('0x40')](_0x1ff7cd[_0xfa55('0x2e')]);_0x26c449['filters']=_[_0xfa55('0x32')](_0x26c449[_0xfa55('0x30')],_0x26c449[_0xfa55('0x2e')]);_0x4ce094[_0xfa55('0x31')]=_['intersection'](_0x26c449[_0xfa55('0x30')],qs[_0xfa55('0x33')](_0x1ff7cd[_0xfa55('0x2e')]['fields']));_0x4ce094['attributes']=_0x4ce094['attributes'][_0xfa55('0x41')]?_0x4ce094[_0xfa55('0x31')]:_0x26c449[_0xfa55('0x30')];if(_0x1ff7cd[_0xfa55('0x2e')][_0xfa55('0x3c')]){_0x4ce094[_0xfa55('0x42')]=[{'all':!![]}];}_0x4ce094=_['merge']({},_0x4ce094,_0x1ff7cd[_0xfa55('0x3b')]);return db['SquareOdbc']['find'](_0x4ce094)['then'](handleEntityNotFound(_0x4b978a,null))['then'](respondWithResult(_0x4b978a,null))[_0xfa55('0x3f')](handleError(_0x4b978a,null));};exports[_0xfa55('0x43')]=function(_0x51a747,_0x1ac18a){return db[_0xfa55('0x2a')][_0xfa55('0x43')](_0x51a747[_0xfa55('0x44')],{})[_0xfa55('0x23')](function(_0x4fd6d2){var _0x5434c6=_0x51a747[_0xfa55('0x45')][_0xfa55('0x46')]({'plain':!![]});if(!_0x5434c6)throw new Error(_0xfa55('0x47'));if(_0x5434c6[_0xfa55('0x48')]===_0xfa55('0x45')){var _0x29e7c1=_0x4fd6d2[_0xfa55('0x46')]({'plain':!![]});var _0x2fb67e=_0xfa55('0x49');return db['UserProfileSection']['find']({'where':{'name':_0x2fb67e,'userProfileId':_0x5434c6[_0xfa55('0x4a')]},'raw':!![]})['then'](function(_0x5bf7a4){if(_0x5bf7a4&&_0x5bf7a4[_0xfa55('0x4b')]===0x0){return db[_0xfa55('0x25')][_0xfa55('0x43')]({'name':_0x29e7c1[_0xfa55('0x28')],'resourceId':_0x29e7c1['id'],'type':_0x5bf7a4[_0xfa55('0x28')],'sectionId':_0x5bf7a4['id']},{})['then'](function(){return _0x4fd6d2;});}else{return _0x4fd6d2;}})[_0xfa55('0x3f')](function(_0x21555d){logger[_0xfa55('0x26')](_0xfa55('0x4c'),_0x21555d);throw _0x21555d;});}return _0x4fd6d2;})['then'](respondWithResult(_0x1ac18a,0xc9))[_0xfa55('0x3f')](handleError(_0x1ac18a,null));};exports['update']=function(_0x5e7986,_0x2ed0db){if(_0x5e7986[_0xfa55('0x44')]['id']){delete _0x5e7986[_0xfa55('0x44')]['id'];}return db[_0xfa55('0x2a')][_0xfa55('0x4d')]({'where':{'id':_0x5e7986['params']['id']}})['then'](handleEntityNotFound(_0x2ed0db,null))['then'](saveUpdates(_0x5e7986['body'],null))[_0xfa55('0x23')](respondWithResult(_0x2ed0db,null))[_0xfa55('0x3f')](handleError(_0x2ed0db,null));};exports[_0xfa55('0x24')]=function(_0x498038,_0x5e1888){return db[_0xfa55('0x2a')]['find']({'where':{'id':_0x498038[_0xfa55('0x4e')]['id']}})['then'](handleEntityNotFound(_0x5e1888,null))[_0xfa55('0x23')](removeEntity(_0x5e1888,null))[_0xfa55('0x3f')](handleError(_0x5e1888,null));};exports[_0xfa55('0x4f')]=function(_0xa74175,_0x5437d6,_0x18495c){var _0x5245b;return db[_0xfa55('0x2a')]['find']({'where':{'id':_0xa74175[_0xfa55('0x4e')]['id']},'attributes':['id',_0xfa55('0x50')]})[_0xfa55('0x23')](handleEntityNotFound(_0x5437d6,null))[_0xfa55('0x23')](function(_0x16d212){if(_0x16d212){var _0x4beca0=require('odbc')();_0x4beca0[_0xfa55('0x51')](_0x16d212[_0xfa55('0x50')]);_0x4beca0[_0xfa55('0x52')]();return _0x16d212;}})['then'](respondWithResult(_0x5437d6,null))[_0xfa55('0x3f')](handleError(_0x5437d6,null));};