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 _0x1f5d=['SquareOdbc','rawAttributes','fieldName','type','model','query','keys','filters','intersection','fields','attributes','length','hasOwnProperty','nolimit','where','pick','merge','VIRTUAL','filter','includeAll','include','catch','show','options','find','get','Unable\x20to\x20retrieve\x20the\x20current\x20user','role','user','autoAssociation','create','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','body','params','test','dsn','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','moment','bluebird','util','path','sox','ejs','fs-extra','squel','jsforce','desk.js','to-csv','querystring','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','offset','undefined','limit','count','set','Content-Range','json','apply','reject','save','then','destroy','ODBC','UserProfileResource','error','name','index','map'];(function(_0x2d15bf,_0x4ae38f){var _0x222e16=function(_0x10fd0b){while(--_0x10fd0b){_0x2d15bf['push'](_0x2d15bf['shift']());}};_0x222e16(++_0x4ae38f);}(_0x1f5d,0x7a));var _0xd1f5=function(_0x47a7d0,_0x4e182d){_0x47a7d0=_0x47a7d0-0x0;var _0xb9bd08=_0x1f5d[_0x47a7d0];return _0xb9bd08;};'use strict';var emlformat=require(_0xd1f5('0x0'));var rimraf=require(_0xd1f5('0x1'));var zipdir=require(_0xd1f5('0x2'));var jsonpatch=require(_0xd1f5('0x3'));var rp=require('request-promise');var moment=require(_0xd1f5('0x4'));var BPromise=require(_0xd1f5('0x5'));var Mustache=require('mustache');var util=require(_0xd1f5('0x6'));var path=require(_0xd1f5('0x7'));var sox=require(_0xd1f5('0x8'));var csv=require('to-csv');var ejs=require(_0xd1f5('0x9'));var fs=require('fs');var fs_extra=require(_0xd1f5('0xa'));var _=require('lodash');var squel=require(_0xd1f5('0xb'));var crypto=require('crypto');var jsforce=require(_0xd1f5('0xc'));var deskjs=require(_0xd1f5('0xd'));var toCsv=require(_0xd1f5('0xe'));var querystring=require(_0xd1f5('0xf'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0xd1f5('0x10'));var qs=require(_0xd1f5('0x11'));var as=require(_0xd1f5('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')(_0xd1f5('0x13'));var utils=require('../../config/utils');var config=require(_0xd1f5('0x14'));var licenseUtil=require(_0xd1f5('0x15'));var db=require(_0xd1f5('0x16'))['db'];function respondWithStatusCode(_0x4423e4,_0x1412da){_0x1412da=_0x1412da||0xcc;return function(_0x3ad573){if(_0x3ad573){return _0x4423e4[_0xd1f5('0x17')](_0x1412da);}return _0x4423e4['status'](_0x1412da)[_0xd1f5('0x18')]();};}function respondWithResult(_0x431d2d,_0x200519){_0x200519=_0x200519||0xc8;return function(_0x2561df){if(_0x2561df){return _0x431d2d[_0xd1f5('0x19')](_0x200519)['json'](_0x2561df);}};}function respondWithFilteredResult(_0x46075f,_0x42b7dc){return function(_0x3fc971){if(_0x3fc971){var _0x24e8cc=typeof _0x42b7dc[_0xd1f5('0x1a')]===_0xd1f5('0x1b')&&typeof _0x42b7dc[_0xd1f5('0x1c')]===_0xd1f5('0x1b');var _0x4a2fe1=_0x3fc971[_0xd1f5('0x1d')];var _0x5e523d=_0x24e8cc?0x0:_0x42b7dc[_0xd1f5('0x1a')];var _0x135479=_0x24e8cc?_0x3fc971[_0xd1f5('0x1d')]:_0x42b7dc['offset']+_0x42b7dc['limit'];var _0x44bc96;if(_0x135479>=_0x4a2fe1){_0x135479=_0x4a2fe1;_0x44bc96=0xc8;}else{_0x44bc96=0xce;}_0x46075f[_0xd1f5('0x19')](_0x44bc96);return _0x46075f[_0xd1f5('0x1e')](_0xd1f5('0x1f'),_0x5e523d+'-'+_0x135479+'/'+_0x4a2fe1)[_0xd1f5('0x20')](_0x3fc971);}return null;};}function patchUpdates(_0x495a11){return function(_0x5170d1){try{jsonpatch[_0xd1f5('0x21')](_0x5170d1,_0x495a11,!![]);}catch(_0x3c86d1){return BPromise[_0xd1f5('0x22')](_0x3c86d1);}return _0x5170d1[_0xd1f5('0x23')]();};}function saveUpdates(_0x283c33,_0x25729a){return function(_0x289123){if(_0x289123){return _0x289123['update'](_0x283c33)[_0xd1f5('0x24')](function(_0x16b780){return _0x16b780;});}return null;};}function removeEntity(_0x1c6a8f,_0x11e673){return function(_0x10682c){if(_0x10682c){return _0x10682c[_0xd1f5('0x25')]()[_0xd1f5('0x24')](function(){var _0x317a41=_0x10682c['get']({'plain':!![]});var _0x19b800=_0xd1f5('0x26');return db[_0xd1f5('0x27')][_0xd1f5('0x25')]({'where':{'type':_0x19b800,'resourceId':_0x317a41['id']}})[_0xd1f5('0x24')](function(){return _0x10682c;});})['then'](function(){_0x1c6a8f[_0xd1f5('0x19')](0xcc)[_0xd1f5('0x18')]();});}};}function handleEntityNotFound(_0x6b5218,_0x1d0e9e){return function(_0x2198a6){if(!_0x2198a6){_0x6b5218[_0xd1f5('0x17')](0x194);}return _0x2198a6;};}function handleError(_0xa91f89,_0x4241a2){_0x4241a2=_0x4241a2||0x1f4;return function(_0x4c5c99){logger[_0xd1f5('0x28')](_0x4c5c99['stack']);if(_0x4c5c99[_0xd1f5('0x29')]){delete _0x4c5c99[_0xd1f5('0x29')];}_0xa91f89[_0xd1f5('0x19')](_0x4241a2)['send'](_0x4c5c99);};}exports[_0xd1f5('0x2a')]=function(_0x4ee375,_0x15f92b){var _0x22d7b0={},_0x4499fe={},_0x3739d2={'count':0x0,'rows':[]};var _0x47ec37=_[_0xd1f5('0x2b')](db[_0xd1f5('0x2c')][_0xd1f5('0x2d')],function(_0x455b5f){return{'name':_0x455b5f[_0xd1f5('0x2e')],'type':_0x455b5f[_0xd1f5('0x2f')]['key']};});_0x4499fe[_0xd1f5('0x30')]=_['map'](_0x47ec37,_0xd1f5('0x29'));_0x4499fe[_0xd1f5('0x31')]=_[_0xd1f5('0x32')](_0x4ee375[_0xd1f5('0x31')]);_0x4499fe[_0xd1f5('0x33')]=_['intersection'](_0x4499fe[_0xd1f5('0x30')],_0x4499fe[_0xd1f5('0x31')]);_0x22d7b0['attributes']=_[_0xd1f5('0x34')](_0x4499fe[_0xd1f5('0x30')],qs[_0xd1f5('0x35')](_0x4ee375[_0xd1f5('0x31')][_0xd1f5('0x35')]));_0x22d7b0[_0xd1f5('0x36')]=_0x22d7b0[_0xd1f5('0x36')][_0xd1f5('0x37')]?_0x22d7b0['attributes']:_0x4499fe[_0xd1f5('0x30')];if(!_0x4ee375[_0xd1f5('0x31')][_0xd1f5('0x38')](_0xd1f5('0x39'))){_0x22d7b0[_0xd1f5('0x1c')]=qs[_0xd1f5('0x1c')](_0x4ee375[_0xd1f5('0x31')]['limit']);_0x22d7b0['offset']=qs[_0xd1f5('0x1a')](_0x4ee375[_0xd1f5('0x31')][_0xd1f5('0x1a')]);}_0x22d7b0['order']=qs['sort'](_0x4ee375[_0xd1f5('0x31')]['sort']);_0x22d7b0[_0xd1f5('0x3a')]=qs[_0xd1f5('0x33')](_[_0xd1f5('0x3b')](_0x4ee375['query'],_0x4499fe['filters']),_0x47ec37);if(_0x4ee375['query']['filter']){_0x22d7b0[_0xd1f5('0x3a')]=_[_0xd1f5('0x3c')](_0x22d7b0[_0xd1f5('0x3a')],{'$or':_[_0xd1f5('0x2b')](_0x47ec37,function(_0x3068a3){if(_0x3068a3['type']!==_0xd1f5('0x3d')){var _0x9761e={};_0x9761e[_0x3068a3['name']]={'$like':'%'+_0x4ee375['query'][_0xd1f5('0x3e')]+'%'};return _0x9761e;}})});}_0x22d7b0=_[_0xd1f5('0x3c')]({},_0x22d7b0,_0x4ee375['options']);var _0x40b8a4={'where':_0x22d7b0['where']};return db[_0xd1f5('0x2c')][_0xd1f5('0x1d')](_0x40b8a4)['then'](function(_0x3870f5){_0x3739d2[_0xd1f5('0x1d')]=_0x3870f5;if(_0x4ee375[_0xd1f5('0x31')][_0xd1f5('0x3f')]){_0x22d7b0[_0xd1f5('0x40')]=[{'all':!![]}];}return db['SquareOdbc']['findAll'](_0x22d7b0);})[_0xd1f5('0x24')](function(_0x101171){_0x3739d2['rows']=_0x101171;return _0x3739d2;})[_0xd1f5('0x24')](respondWithFilteredResult(_0x15f92b,_0x22d7b0))[_0xd1f5('0x41')](handleError(_0x15f92b,null));};exports[_0xd1f5('0x42')]=function(_0x2f3a74,_0x1dda4b){var _0x18202c={'raw':!![],'where':{'id':_0x2f3a74['params']['id']}},_0x581d81={};_0x581d81[_0xd1f5('0x30')]=_['keys'](db[_0xd1f5('0x2c')]['rawAttributes']);_0x581d81['query']=_[_0xd1f5('0x32')](_0x2f3a74[_0xd1f5('0x31')]);_0x581d81[_0xd1f5('0x33')]=_[_0xd1f5('0x34')](_0x581d81['model'],_0x581d81[_0xd1f5('0x31')]);_0x18202c[_0xd1f5('0x36')]=_[_0xd1f5('0x34')](_0x581d81[_0xd1f5('0x30')],qs[_0xd1f5('0x35')](_0x2f3a74[_0xd1f5('0x31')]['fields']));_0x18202c[_0xd1f5('0x36')]=_0x18202c['attributes']['length']?_0x18202c[_0xd1f5('0x36')]:_0x581d81[_0xd1f5('0x30')];if(_0x2f3a74[_0xd1f5('0x31')][_0xd1f5('0x3f')]){_0x18202c[_0xd1f5('0x40')]=[{'all':!![]}];}_0x18202c=_[_0xd1f5('0x3c')]({},_0x18202c,_0x2f3a74[_0xd1f5('0x43')]);return db['SquareOdbc'][_0xd1f5('0x44')](_0x18202c)[_0xd1f5('0x24')](handleEntityNotFound(_0x1dda4b,null))[_0xd1f5('0x24')](respondWithResult(_0x1dda4b,null))[_0xd1f5('0x41')](handleError(_0x1dda4b,null));};exports['create']=function(_0x1cb0af,_0x1bc0d6){return db[_0xd1f5('0x2c')]['create'](_0x1cb0af['body'],{})[_0xd1f5('0x24')](function(_0x5a30b2){var _0x4aa54a=_0x1cb0af['user'][_0xd1f5('0x45')]({'plain':!![]});if(!_0x4aa54a)throw new Error(_0xd1f5('0x46'));if(_0x4aa54a[_0xd1f5('0x47')]===_0xd1f5('0x48')){var _0x33ea77=_0x5a30b2[_0xd1f5('0x45')]({'plain':!![]});var _0x1c063e=_0xd1f5('0x26');return db['UserProfileSection'][_0xd1f5('0x44')]({'where':{'name':_0x1c063e,'userProfileId':_0x4aa54a['userProfileId']},'raw':!![]})[_0xd1f5('0x24')](function(_0x442ccd){if(_0x442ccd&&_0x442ccd[_0xd1f5('0x49')]===0x0){return db[_0xd1f5('0x27')][_0xd1f5('0x4a')]({'name':_0x33ea77[_0xd1f5('0x29')],'resourceId':_0x33ea77['id'],'type':_0x442ccd[_0xd1f5('0x29')],'sectionId':_0x442ccd['id']},{})[_0xd1f5('0x24')](function(){return _0x5a30b2;});}else{return _0x5a30b2;}})[_0xd1f5('0x41')](function(_0x40f0f0){logger[_0xd1f5('0x28')](_0xd1f5('0x4b'),_0x40f0f0);throw _0x40f0f0;});}return _0x5a30b2;})[_0xd1f5('0x24')](respondWithResult(_0x1bc0d6,0xc9))[_0xd1f5('0x41')](handleError(_0x1bc0d6,null));};exports[_0xd1f5('0x4c')]=function(_0x432f8,_0x1e9268){if(_0x432f8['body']['id']){delete _0x432f8[_0xd1f5('0x4d')]['id'];}return db[_0xd1f5('0x2c')][_0xd1f5('0x44')]({'where':{'id':_0x432f8[_0xd1f5('0x4e')]['id']}})[_0xd1f5('0x24')](handleEntityNotFound(_0x1e9268,null))[_0xd1f5('0x24')](saveUpdates(_0x432f8[_0xd1f5('0x4d')],null))[_0xd1f5('0x24')](respondWithResult(_0x1e9268,null))[_0xd1f5('0x41')](handleError(_0x1e9268,null));};exports[_0xd1f5('0x25')]=function(_0x1623cd,_0x821329){return db[_0xd1f5('0x2c')][_0xd1f5('0x44')]({'where':{'id':_0x1623cd['params']['id']}})[_0xd1f5('0x24')](handleEntityNotFound(_0x821329,null))[_0xd1f5('0x24')](removeEntity(_0x821329,null))[_0xd1f5('0x41')](handleError(_0x821329,null));};exports[_0xd1f5('0x4f')]=function(_0x255267,_0x605424,_0x40c00f){var _0x186e06;return db[_0xd1f5('0x2c')][_0xd1f5('0x44')]({'where':{'id':_0x255267['params']['id']},'attributes':['id',_0xd1f5('0x50')]})['then'](handleEntityNotFound(_0x605424,null))[_0xd1f5('0x24')](function(_0x1ff1ce){if(_0x1ff1ce){var _0x1d032b=require('odbc')();_0x1d032b[_0xd1f5('0x51')](_0x1ff1ce[_0xd1f5('0x50')]);_0x1d032b[_0xd1f5('0x52')]();return _0x1ff1ce;}})[_0xd1f5('0x24')](respondWithResult(_0x605424,null))[_0xd1f5('0x41')](handleError(_0x605424,null));};