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 _0xd56b=['../../mysqldb','sendStatus','status','end','json','undefined','limit','count','offset','Content-Range','apply','reject','save','update','then','get','ODBC','UserProfileResource','destroy','error','name','send','index','type','key','model','map','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','options','SquareOdbc','includeAll','catch','show','length','include','create','body','user','role','UserProfileSection','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','params','find','test','dsn','odbc','openSync','closeSync','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','sox','ejs','fs-extra','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment'];(function(_0x36ed48,_0x1ee0d4){var _0x51c63a=function(_0x2d0a40){while(--_0x2d0a40){_0x36ed48['push'](_0x36ed48['shift']());}};_0x51c63a(++_0x1ee0d4);}(_0xd56b,0x196));var _0xbd56=function(_0x31904b,_0x48100a){_0x31904b=_0x31904b-0x0;var _0x38b2a0=_0xd56b[_0x31904b];return _0x38b2a0;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0xbd56('0x0'));var zipdir=require(_0xbd56('0x1'));var jsonpatch=require(_0xbd56('0x2'));var rp=require(_0xbd56('0x3'));var moment=require(_0xbd56('0x4'));var BPromise=require(_0xbd56('0x5'));var Mustache=require('mustache');var util=require(_0xbd56('0x6'));var path=require('path');var sox=require(_0xbd56('0x7'));var csv=require('to-csv');var ejs=require(_0xbd56('0x8'));var fs=require('fs');var fs_extra=require(_0xbd56('0x9'));var _=require('lodash');var squel=require(_0xbd56('0xa'));var crypto=require(_0xbd56('0xb'));var jsforce=require(_0xbd56('0xc'));var deskjs=require(_0xbd56('0xd'));var toCsv=require('to-csv');var querystring=require(_0xbd56('0xe'));var Papa=require(_0xbd56('0xf'));var Redis=require(_0xbd56('0x10'));var authService=require(_0xbd56('0x11'));var qs=require(_0xbd56('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbd56('0x13'));var logger=require(_0xbd56('0x14'))(_0xbd56('0x15'));var utils=require(_0xbd56('0x16'));var config=require(_0xbd56('0x17'));var licenseUtil=require('../../config/license/util');var db=require(_0xbd56('0x18'))['db'];function respondWithStatusCode(_0x1071c1,_0x1cadef){_0x1cadef=_0x1cadef||0xcc;return function(_0x3f58c6){if(_0x3f58c6){return _0x1071c1[_0xbd56('0x19')](_0x1cadef);}return _0x1071c1[_0xbd56('0x1a')](_0x1cadef)[_0xbd56('0x1b')]();};}function respondWithResult(_0x454f2e,_0x10379f){_0x10379f=_0x10379f||0xc8;return function(_0x5751ff){if(_0x5751ff){return _0x454f2e[_0xbd56('0x1a')](_0x10379f)[_0xbd56('0x1c')](_0x5751ff);}};}function respondWithFilteredResult(_0x3c207e,_0x10c63e){return function(_0x4910cc){if(_0x4910cc){var _0x598204=typeof _0x10c63e['offset']===_0xbd56('0x1d')&&typeof _0x10c63e[_0xbd56('0x1e')]===_0xbd56('0x1d');var _0x466022=_0x4910cc[_0xbd56('0x1f')];var _0x4e9deb=_0x598204?0x0:_0x10c63e[_0xbd56('0x20')];var _0x5c7e18=_0x598204?_0x4910cc[_0xbd56('0x1f')]:_0x10c63e[_0xbd56('0x20')]+_0x10c63e[_0xbd56('0x1e')];var _0x8910ae;if(_0x5c7e18>=_0x466022){_0x5c7e18=_0x466022;_0x8910ae=0xc8;}else{_0x8910ae=0xce;}_0x3c207e[_0xbd56('0x1a')](_0x8910ae);return _0x3c207e['set'](_0xbd56('0x21'),_0x4e9deb+'-'+_0x5c7e18+'/'+_0x466022)[_0xbd56('0x1c')](_0x4910cc);}return null;};}function patchUpdates(_0x43e73c){return function(_0x17a468){try{jsonpatch[_0xbd56('0x22')](_0x17a468,_0x43e73c,!![]);}catch(_0x128bb5){return BPromise[_0xbd56('0x23')](_0x128bb5);}return _0x17a468[_0xbd56('0x24')]();};}function saveUpdates(_0x1db910,_0x4da1b9){return function(_0x14033d){if(_0x14033d){return _0x14033d[_0xbd56('0x25')](_0x1db910)[_0xbd56('0x26')](function(_0x39ab27){return _0x39ab27;});}return null;};}function removeEntity(_0x4bee88,_0x44f9f5){return function(_0x5e2b2b){if(_0x5e2b2b){return _0x5e2b2b['destroy']()[_0xbd56('0x26')](function(){var _0x151bf3=_0x5e2b2b[_0xbd56('0x27')]({'plain':!![]});var _0xb591f9=_0xbd56('0x28');return db[_0xbd56('0x29')][_0xbd56('0x2a')]({'where':{'type':_0xb591f9,'resourceId':_0x151bf3['id']}})[_0xbd56('0x26')](function(){return _0x5e2b2b;});})[_0xbd56('0x26')](function(){_0x4bee88[_0xbd56('0x1a')](0xcc)[_0xbd56('0x1b')]();});}};}function handleEntityNotFound(_0xa1024f,_0x3aae8d){return function(_0x38597d){if(!_0x38597d){_0xa1024f[_0xbd56('0x19')](0x194);}return _0x38597d;};}function handleError(_0x33d01c,_0x2c64fa){_0x2c64fa=_0x2c64fa||0x1f4;return function(_0x49c90a){logger[_0xbd56('0x2b')](_0x49c90a['stack']);if(_0x49c90a[_0xbd56('0x2c')]){delete _0x49c90a[_0xbd56('0x2c')];}_0x33d01c[_0xbd56('0x1a')](_0x2c64fa)[_0xbd56('0x2d')](_0x49c90a);};}exports[_0xbd56('0x2e')]=function(_0x793946,_0xa54687){var _0x1d08d1={},_0x2d72cd={},_0x5f235a={'count':0x0,'rows':[]};var _0x4bf77a=_['map'](db['SquareOdbc']['rawAttributes'],function(_0xbd5474){return{'name':_0xbd5474['fieldName'],'type':_0xbd5474[_0xbd56('0x2f')][_0xbd56('0x30')]};});_0x2d72cd[_0xbd56('0x31')]=_[_0xbd56('0x32')](_0x4bf77a,_0xbd56('0x2c'));_0x2d72cd[_0xbd56('0x33')]=_[_0xbd56('0x34')](_0x793946[_0xbd56('0x33')]);_0x2d72cd[_0xbd56('0x35')]=_[_0xbd56('0x36')](_0x2d72cd[_0xbd56('0x31')],_0x2d72cd[_0xbd56('0x33')]);_0x1d08d1[_0xbd56('0x37')]=_[_0xbd56('0x36')](_0x2d72cd[_0xbd56('0x31')],qs[_0xbd56('0x38')](_0x793946['query'][_0xbd56('0x38')]));_0x1d08d1['attributes']=_0x1d08d1[_0xbd56('0x37')]['length']?_0x1d08d1[_0xbd56('0x37')]:_0x2d72cd[_0xbd56('0x31')];if(!_0x793946[_0xbd56('0x33')][_0xbd56('0x39')](_0xbd56('0x3a'))){_0x1d08d1[_0xbd56('0x1e')]=qs['limit'](_0x793946[_0xbd56('0x33')][_0xbd56('0x1e')]);_0x1d08d1[_0xbd56('0x20')]=qs[_0xbd56('0x20')](_0x793946[_0xbd56('0x33')][_0xbd56('0x20')]);}_0x1d08d1[_0xbd56('0x3b')]=qs[_0xbd56('0x3c')](_0x793946['query']['sort']);_0x1d08d1[_0xbd56('0x3d')]=qs[_0xbd56('0x35')](_[_0xbd56('0x3e')](_0x793946[_0xbd56('0x33')],_0x2d72cd['filters']),_0x4bf77a);if(_0x793946['query'][_0xbd56('0x3f')]){_0x1d08d1[_0xbd56('0x3d')]=_[_0xbd56('0x40')](_0x1d08d1[_0xbd56('0x3d')],{'$or':_[_0xbd56('0x32')](_0x4bf77a,function(_0x48adb3){if(_0x48adb3[_0xbd56('0x2f')]!=='VIRTUAL'){var _0x3986e0={};_0x3986e0[_0x48adb3['name']]={'$like':'%'+_0x793946[_0xbd56('0x33')][_0xbd56('0x3f')]+'%'};return _0x3986e0;}})});}_0x1d08d1=_['merge']({},_0x1d08d1,_0x793946[_0xbd56('0x41')]);var _0x380442={'where':_0x1d08d1[_0xbd56('0x3d')]};return db[_0xbd56('0x42')][_0xbd56('0x1f')](_0x380442)['then'](function(_0x5b0a90){_0x5f235a[_0xbd56('0x1f')]=_0x5b0a90;if(_0x793946[_0xbd56('0x33')][_0xbd56('0x43')]){_0x1d08d1['include']=[{'all':!![]}];}return db[_0xbd56('0x42')]['findAll'](_0x1d08d1);})[_0xbd56('0x26')](function(_0x1b6a2c){_0x5f235a['rows']=_0x1b6a2c;return _0x5f235a;})[_0xbd56('0x26')](respondWithFilteredResult(_0xa54687,_0x1d08d1))[_0xbd56('0x44')](handleError(_0xa54687,null));};exports[_0xbd56('0x45')]=function(_0x153758,_0x2f5a82){var _0x234d7b={'raw':!![],'where':{'id':_0x153758['params']['id']}},_0x3840e6={};_0x3840e6[_0xbd56('0x31')]=_['keys'](db['SquareOdbc']['rawAttributes']);_0x3840e6['query']=_[_0xbd56('0x34')](_0x153758[_0xbd56('0x33')]);_0x3840e6[_0xbd56('0x35')]=_[_0xbd56('0x36')](_0x3840e6[_0xbd56('0x31')],_0x3840e6['query']);_0x234d7b[_0xbd56('0x37')]=_[_0xbd56('0x36')](_0x3840e6['model'],qs[_0xbd56('0x38')](_0x153758[_0xbd56('0x33')]['fields']));_0x234d7b[_0xbd56('0x37')]=_0x234d7b[_0xbd56('0x37')][_0xbd56('0x46')]?_0x234d7b[_0xbd56('0x37')]:_0x3840e6[_0xbd56('0x31')];if(_0x153758['query']['includeAll']){_0x234d7b[_0xbd56('0x47')]=[{'all':!![]}];}_0x234d7b=_[_0xbd56('0x40')]({},_0x234d7b,_0x153758[_0xbd56('0x41')]);return db[_0xbd56('0x42')]['find'](_0x234d7b)[_0xbd56('0x26')](handleEntityNotFound(_0x2f5a82,null))[_0xbd56('0x26')](respondWithResult(_0x2f5a82,null))[_0xbd56('0x44')](handleError(_0x2f5a82,null));};exports[_0xbd56('0x48')]=function(_0x284e54,_0x46d097){return db['SquareOdbc'][_0xbd56('0x48')](_0x284e54[_0xbd56('0x49')],{})[_0xbd56('0x26')](function(_0x5327ca){var _0x18f155=_0x284e54[_0xbd56('0x4a')][_0xbd56('0x27')]({'plain':!![]});if(!_0x18f155)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x18f155[_0xbd56('0x4b')]==='user'){var _0x578209=_0x5327ca[_0xbd56('0x27')]({'plain':!![]});var _0x49c92e='ODBC';return db[_0xbd56('0x4c')]['find']({'where':{'name':_0x49c92e,'userProfileId':_0x18f155['userProfileId']},'raw':!![]})[_0xbd56('0x26')](function(_0x3b9299){if(_0x3b9299&&_0x3b9299[_0xbd56('0x4d')]===0x0){return db[_0xbd56('0x29')][_0xbd56('0x48')]({'name':_0x578209[_0xbd56('0x2c')],'resourceId':_0x578209['id'],'type':_0x3b9299[_0xbd56('0x2c')],'sectionId':_0x3b9299['id']},{})[_0xbd56('0x26')](function(){return _0x5327ca;});}else{return _0x5327ca;}})[_0xbd56('0x44')](function(_0x7371cb){logger[_0xbd56('0x2b')](_0xbd56('0x4e'),_0x7371cb);throw _0x7371cb;});}return _0x5327ca;})['then'](respondWithResult(_0x46d097,0xc9))[_0xbd56('0x44')](handleError(_0x46d097,null));};exports[_0xbd56('0x25')]=function(_0x45d4d7,_0x27cd52){if(_0x45d4d7[_0xbd56('0x49')]['id']){delete _0x45d4d7[_0xbd56('0x49')]['id'];}return db[_0xbd56('0x42')]['find']({'where':{'id':_0x45d4d7[_0xbd56('0x4f')]['id']}})[_0xbd56('0x26')](handleEntityNotFound(_0x27cd52,null))[_0xbd56('0x26')](saveUpdates(_0x45d4d7['body'],null))[_0xbd56('0x26')](respondWithResult(_0x27cd52,null))[_0xbd56('0x44')](handleError(_0x27cd52,null));};exports[_0xbd56('0x2a')]=function(_0x29f2f3,_0x1f9e75){return db['SquareOdbc'][_0xbd56('0x50')]({'where':{'id':_0x29f2f3['params']['id']}})[_0xbd56('0x26')](handleEntityNotFound(_0x1f9e75,null))[_0xbd56('0x26')](removeEntity(_0x1f9e75,null))[_0xbd56('0x44')](handleError(_0x1f9e75,null));};exports[_0xbd56('0x51')]=function(_0x3ab30a,_0x5e6e9c,_0x50faf2){var _0x4cde70;return db['SquareOdbc'][_0xbd56('0x50')]({'where':{'id':_0x3ab30a[_0xbd56('0x4f')]['id']},'attributes':['id',_0xbd56('0x52')]})[_0xbd56('0x26')](handleEntityNotFound(_0x5e6e9c,null))['then'](function(_0x220759){if(_0x220759){var _0x202d79=require(_0xbd56('0x53'))();_0x202d79[_0xbd56('0x54')](_0x220759['dsn']);_0x202d79[_0xbd56('0x55')]();return _0x220759;}})[_0xbd56('0x26')](respondWithResult(_0x5e6e9c,null))[_0xbd56('0x44')](handleError(_0x5e6e9c,null));};