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 _0x84e9=['user','Unable\x20to\x20retrieve\x20the\x20current\x20user','UserProfileSection','userProfileId','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','find','test','dsn','odbc','openSync','closeSync','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','path','ejs','lodash','squel','jsforce','desk.js','to-csv','querystring','papaparse','../../components/parsers/qs','../../config/environment','../../mysqldb','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','update','then','destroy','get','ODBC','UserProfileResource','error','stack','name','send','index','map','SquareOdbc','rawAttributes','fieldName','type','model','keys','query','filters','intersection','fields','attributes','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','include','findAll','rows','catch','params','length','create','body'];(function(_0x5e9997,_0x243fa6){var _0x959a8b=function(_0xd6f27f){while(--_0xd6f27f){_0x5e9997['push'](_0x5e9997['shift']());}};_0x959a8b(++_0x243fa6);}(_0x84e9,0x102));var _0x984e=function(_0xa079d4,_0x1f5079){_0xa079d4=_0xa079d4-0x0;var _0x4e141b=_0x84e9[_0xa079d4];return _0x4e141b;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x984e('0x0'));var rimraf=require(_0x984e('0x1'));var zipdir=require(_0x984e('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0x984e('0x3'));var moment=require(_0x984e('0x4'));var BPromise=require(_0x984e('0x5'));var Mustache=require(_0x984e('0x6'));var util=require('util');var path=require(_0x984e('0x7'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0x984e('0x8'));var fs=require('fs');var _=require(_0x984e('0x9'));var squel=require(_0x984e('0xa'));var crypto=require('crypto');var jsforce=require(_0x984e('0xb'));var deskjs=require(_0x984e('0xc'));var toCsv=require(_0x984e('0xd'));var querystring=require(_0x984e('0xe'));var Papa=require(_0x984e('0xf'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x984e('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require('../../config/license/hardware');var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require(_0x984e('0x11'));var db=require(_0x984e('0x12'))['db'];function respondWithStatusCode(_0x140120,_0x10e339){_0x10e339=_0x10e339||0xcc;return function(_0x299af5){if(_0x299af5){return _0x140120[_0x984e('0x13')](_0x10e339);}return _0x140120[_0x984e('0x14')](_0x10e339)[_0x984e('0x15')]();};}function respondWithResult(_0xac14ad,_0x190250){_0x190250=_0x190250||0xc8;return function(_0xb937df){if(_0xb937df){return _0xac14ad[_0x984e('0x14')](_0x190250)[_0x984e('0x16')](_0xb937df);}};}function respondWithFilteredResult(_0x142d30,_0x1efcd3){return function(_0x1f98eb){if(_0x1f98eb){var _0x2a0235=_0x1f98eb[_0x984e('0x17')],_0x1ef0f7=_0x1efcd3[_0x984e('0x18')],_0x38431c=_0x1efcd3[_0x984e('0x18')]+_0x1efcd3[_0x984e('0x19')],_0x2eb594;if(_0x38431c>=_0x2a0235){_0x38431c=_0x2a0235;_0x2eb594=0xc8;}else{_0x2eb594=0xce;}_0x142d30[_0x984e('0x14')](_0x2eb594);return _0x142d30[_0x984e('0x1a')](_0x984e('0x1b'),_0x1ef0f7+'-'+_0x38431c+'/'+_0x2a0235)[_0x984e('0x16')](_0x1f98eb);}return null;};}function patchUpdates(_0x623c2d){return function(_0x1f7a8d){try{jsonpatch[_0x984e('0x1c')](_0x1f7a8d,_0x623c2d,!![]);}catch(_0x10c169){return BPromise[_0x984e('0x1d')](_0x10c169);}return _0x1f7a8d['save']();};}function saveUpdates(_0x31f6c6,_0x536f29){return function(_0x4524c7){if(_0x4524c7){return _0x4524c7[_0x984e('0x1e')](_0x31f6c6)[_0x984e('0x1f')](function(_0x1ac3cb){return _0x1ac3cb;});}return null;};}function removeEntity(_0x3ee376,_0x4dece9){return function(_0x52db49){if(_0x52db49){return _0x52db49[_0x984e('0x20')]()[_0x984e('0x1f')](function(){var _0x1fac0b=_0x52db49[_0x984e('0x21')]({'plain':!![]});var _0xa7dbbd=_0x984e('0x22');return db[_0x984e('0x23')][_0x984e('0x20')]({'where':{'type':_0xa7dbbd,'resourceId':_0x1fac0b['id']}})['then'](function(){return _0x52db49;});})[_0x984e('0x1f')](function(){_0x3ee376['status'](0xcc)[_0x984e('0x15')]();});}};}function handleEntityNotFound(_0x1dbbf5,_0x439b0a){return function(_0x27574c){if(!_0x27574c){_0x1dbbf5[_0x984e('0x13')](0x194);}return _0x27574c;};}function handleError(_0x4f8ab8,_0x22aa91){_0x22aa91=_0x22aa91||0x1f4;return function(_0x5add2b){logger[_0x984e('0x24')](_0x5add2b[_0x984e('0x25')]);if(_0x5add2b[_0x984e('0x26')]){delete _0x5add2b['name'];}_0x4f8ab8['status'](_0x22aa91)[_0x984e('0x27')](_0x5add2b);};}exports[_0x984e('0x28')]=function(_0x14d4f5,_0xe6f217){var _0x55c000={},_0x4ab135={},_0x15e3d5={'count':0x0,'rows':[]};var _0x5f224a=_[_0x984e('0x29')](db[_0x984e('0x2a')][_0x984e('0x2b')],function(_0x19cfa2){return{'name':_0x19cfa2[_0x984e('0x2c')],'type':_0x19cfa2[_0x984e('0x2d')]['key']};});_0x4ab135[_0x984e('0x2e')]=_[_0x984e('0x29')](_0x5f224a,_0x984e('0x26'));_0x4ab135['query']=_[_0x984e('0x2f')](_0x14d4f5[_0x984e('0x30')]);_0x4ab135[_0x984e('0x31')]=_[_0x984e('0x32')](_0x4ab135[_0x984e('0x2e')],_0x4ab135[_0x984e('0x30')]);_0x55c000['attributes']=_[_0x984e('0x32')](_0x4ab135[_0x984e('0x2e')],qs[_0x984e('0x33')](_0x14d4f5[_0x984e('0x30')][_0x984e('0x33')]));_0x55c000[_0x984e('0x34')]=_0x55c000[_0x984e('0x34')]['length']?_0x55c000[_0x984e('0x34')]:_0x4ab135[_0x984e('0x2e')];if(!_0x14d4f5[_0x984e('0x30')][_0x984e('0x35')](_0x984e('0x36'))){_0x55c000[_0x984e('0x19')]=qs[_0x984e('0x19')](_0x14d4f5[_0x984e('0x30')][_0x984e('0x19')]);_0x55c000['offset']=qs[_0x984e('0x18')](_0x14d4f5[_0x984e('0x30')][_0x984e('0x18')]);}_0x55c000[_0x984e('0x37')]=qs[_0x984e('0x38')](_0x14d4f5[_0x984e('0x30')]['sort']);_0x55c000[_0x984e('0x39')]=qs['filters'](_[_0x984e('0x3a')](_0x14d4f5['query'],_0x4ab135[_0x984e('0x31')]),_0x5f224a);if(_0x14d4f5['query'][_0x984e('0x3b')]){_0x55c000['where']=_[_0x984e('0x3c')](_0x55c000[_0x984e('0x39')],{'$or':_[_0x984e('0x29')](_0x5f224a,function(_0x466724){if(_0x466724[_0x984e('0x2d')]!==_0x984e('0x3d')){var _0x5aff82={};_0x5aff82[_0x466724[_0x984e('0x26')]]={'$like':'%'+_0x14d4f5[_0x984e('0x30')][_0x984e('0x3b')]+'%'};return _0x5aff82;}})});}_0x55c000=_[_0x984e('0x3c')]({},_0x55c000,_0x14d4f5['options']);var _0x51192e={'where':_0x55c000[_0x984e('0x39')]};return db['SquareOdbc']['count'](_0x51192e)[_0x984e('0x1f')](function(_0x1b249e){_0x15e3d5['count']=_0x1b249e;if(_0x14d4f5[_0x984e('0x30')]['includeAll']){_0x55c000[_0x984e('0x3e')]=[{'all':!![]}];}return db['SquareOdbc'][_0x984e('0x3f')](_0x55c000);})['then'](function(_0x260232){_0x15e3d5[_0x984e('0x40')]=_0x260232;return _0x15e3d5;})['then'](respondWithFilteredResult(_0xe6f217,_0x55c000))[_0x984e('0x41')](handleError(_0xe6f217,null));};exports['show']=function(_0x35c5be,_0x15da25){var _0x1aeffc={'raw':!![],'where':{'id':_0x35c5be[_0x984e('0x42')]['id']}},_0x54f540={};_0x54f540[_0x984e('0x2e')]=_['keys'](db[_0x984e('0x2a')][_0x984e('0x2b')]);_0x54f540[_0x984e('0x30')]=_[_0x984e('0x2f')](_0x35c5be['query']);_0x54f540[_0x984e('0x31')]=_[_0x984e('0x32')](_0x54f540['model'],_0x54f540[_0x984e('0x30')]);_0x1aeffc['attributes']=_[_0x984e('0x32')](_0x54f540[_0x984e('0x2e')],qs[_0x984e('0x33')](_0x35c5be['query'][_0x984e('0x33')]));_0x1aeffc[_0x984e('0x34')]=_0x1aeffc[_0x984e('0x34')][_0x984e('0x43')]?_0x1aeffc[_0x984e('0x34')]:_0x54f540[_0x984e('0x2e')];if(_0x35c5be['query']['includeAll']){_0x1aeffc[_0x984e('0x3e')]=[{'all':!![]}];}_0x1aeffc=_[_0x984e('0x3c')]({},_0x1aeffc,_0x35c5be['options']);return db[_0x984e('0x2a')]['find'](_0x1aeffc)[_0x984e('0x1f')](handleEntityNotFound(_0x15da25,null))[_0x984e('0x1f')](respondWithResult(_0x15da25,null))['catch'](handleError(_0x15da25,null));};exports[_0x984e('0x44')]=function(_0x3e3fae,_0x5e425d){return db[_0x984e('0x2a')][_0x984e('0x44')](_0x3e3fae[_0x984e('0x45')],{})[_0x984e('0x1f')](function(_0x2f6feb){var _0x3eec22=_0x3e3fae[_0x984e('0x46')]['get']({'plain':!![]});if(!_0x3eec22)throw new Error(_0x984e('0x47'));if(_0x3eec22['role']===_0x984e('0x46')){var _0xf49577=_0x2f6feb[_0x984e('0x21')]({'plain':!![]});var _0x55d972=_0x984e('0x22');return db[_0x984e('0x48')]['find']({'where':{'name':_0x55d972,'userProfileId':_0x3eec22[_0x984e('0x49')]},'raw':!![]})[_0x984e('0x1f')](function(_0x1f748f){if(_0x1f748f&&_0x1f748f[_0x984e('0x4a')]===0x0){return db['UserProfileResource'][_0x984e('0x44')]({'name':_0xf49577[_0x984e('0x26')],'resourceId':_0xf49577['id'],'type':_0x1f748f[_0x984e('0x26')],'sectionId':_0x1f748f['id']},{})[_0x984e('0x1f')](function(){return _0x2f6feb;});}else{return _0x2f6feb;}})[_0x984e('0x41')](function(_0x110d0e){logger[_0x984e('0x24')](_0x984e('0x4b'),_0x110d0e);throw _0x110d0e;});}return _0x2f6feb;})['then'](respondWithResult(_0x5e425d,0xc9))['catch'](handleError(_0x5e425d,null));};exports['update']=function(_0x2ec49f,_0x447f60){if(_0x2ec49f[_0x984e('0x45')]['id']){delete _0x2ec49f['body']['id'];}return db[_0x984e('0x2a')][_0x984e('0x4c')]({'where':{'id':_0x2ec49f[_0x984e('0x42')]['id']}})[_0x984e('0x1f')](handleEntityNotFound(_0x447f60,null))[_0x984e('0x1f')](saveUpdates(_0x2ec49f[_0x984e('0x45')],null))[_0x984e('0x1f')](respondWithResult(_0x447f60,null))['catch'](handleError(_0x447f60,null));};exports[_0x984e('0x20')]=function(_0x37ffff,_0x5dfee9){return db[_0x984e('0x2a')]['find']({'where':{'id':_0x37ffff[_0x984e('0x42')]['id']}})[_0x984e('0x1f')](handleEntityNotFound(_0x5dfee9,null))[_0x984e('0x1f')](removeEntity(_0x5dfee9,null))['catch'](handleError(_0x5dfee9,null));};exports[_0x984e('0x4d')]=function(_0x5b9adf,_0x7f9cf6,_0x3c03f3){var _0x2ea2c7;return db['SquareOdbc'][_0x984e('0x4c')]({'where':{'id':_0x5b9adf['params']['id']},'attributes':['id',_0x984e('0x4e')]})['then'](handleEntityNotFound(_0x7f9cf6,null))[_0x984e('0x1f')](function(_0x2572e5){if(_0x2572e5){var _0x59b101=require(_0x984e('0x4f'))();_0x59b101[_0x984e('0x50')](_0x2572e5[_0x984e('0x4e')]);_0x59b101[_0x984e('0x51')]();return _0x2572e5;}})['then'](respondWithResult(_0x7f9cf6,null))['catch'](handleError(_0x7f9cf6,null));};