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 _0x8b28=['desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','sendStatus','status','json','undefined','limit','count','offset','set','Content-Range','apply','reject','save','then','destroy','get','ODBC','UserProfileResource','end','error','stack','name','send','index','map','rawAttributes','query','filters','intersection','model','attributes','fields','hasOwnProperty','order','sort','where','pick','filter','merge','type','VIRTUAL','options','includeAll','SquareOdbc','rows','catch','params','include','find','create','body','Unable\x20to\x20retrieve\x20the\x20current\x20user','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','update','dsn','odbc','openSync','closeSync','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce'];(function(_0x237fea,_0x1ff78a){var _0x2a04f1=function(_0x4518c3){while(--_0x4518c3){_0x237fea['push'](_0x237fea['shift']());}};_0x2a04f1(++_0x1ff78a);}(_0x8b28,0x194));var _0x88b2=function(_0x14add3,_0x13ce8d){_0x14add3=_0x14add3-0x0;var _0x4a174f=_0x8b28[_0x14add3];return _0x4a174f;};'use strict';var emlformat=require(_0x88b2('0x0'));var rimraf=require(_0x88b2('0x1'));var zipdir=require(_0x88b2('0x2'));var jsonpatch=require(_0x88b2('0x3'));var rp=require(_0x88b2('0x4'));var moment=require(_0x88b2('0x5'));var BPromise=require(_0x88b2('0x6'));var Mustache=require(_0x88b2('0x7'));var util=require('util');var path=require(_0x88b2('0x8'));var sox=require('sox');var csv=require(_0x88b2('0x9'));var ejs=require(_0x88b2('0xa'));var fs=require('fs');var fs_extra=require(_0x88b2('0xb'));var _=require(_0x88b2('0xc'));var squel=require(_0x88b2('0xd'));var crypto=require(_0x88b2('0xe'));var jsforce=require(_0x88b2('0xf'));var deskjs=require(_0x88b2('0x10'));var toCsv=require(_0x88b2('0x9'));var querystring=require(_0x88b2('0x11'));var Papa=require(_0x88b2('0x12'));var Redis=require(_0x88b2('0x13'));var authService=require(_0x88b2('0x14'));var qs=require(_0x88b2('0x15'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x88b2('0x16'));var logger=require(_0x88b2('0x17'))('api');var utils=require('../../config/utils');var config=require(_0x88b2('0x18'));var licenseUtil=require('../../config/license/util');var db=require(_0x88b2('0x19'))['db'];function respondWithStatusCode(_0x3bbf73,_0x1467f3){_0x1467f3=_0x1467f3||0xcc;return function(_0x2227c3){if(_0x2227c3){return _0x3bbf73[_0x88b2('0x1a')](_0x1467f3);}return _0x3bbf73[_0x88b2('0x1b')](_0x1467f3)['end']();};}function respondWithResult(_0x1535d0,_0x5da595){_0x5da595=_0x5da595||0xc8;return function(_0x56e6f3){if(_0x56e6f3){return _0x1535d0[_0x88b2('0x1b')](_0x5da595)[_0x88b2('0x1c')](_0x56e6f3);}};}function respondWithFilteredResult(_0xa68909,_0x3f1fb6){return function(_0x290978){if(_0x290978){var _0x7b0c6c=typeof _0x3f1fb6['offset']===_0x88b2('0x1d')&&typeof _0x3f1fb6[_0x88b2('0x1e')]===_0x88b2('0x1d');var _0x206755=_0x290978[_0x88b2('0x1f')];var _0x3126fc=_0x7b0c6c?0x0:_0x3f1fb6[_0x88b2('0x20')];var _0x4c1a18=_0x7b0c6c?_0x290978[_0x88b2('0x1f')]:_0x3f1fb6[_0x88b2('0x20')]+_0x3f1fb6[_0x88b2('0x1e')];var _0x681df8;if(_0x4c1a18>=_0x206755){_0x4c1a18=_0x206755;_0x681df8=0xc8;}else{_0x681df8=0xce;}_0xa68909[_0x88b2('0x1b')](_0x681df8);return _0xa68909[_0x88b2('0x21')](_0x88b2('0x22'),_0x3126fc+'-'+_0x4c1a18+'/'+_0x206755)[_0x88b2('0x1c')](_0x290978);}return null;};}function patchUpdates(_0x53bf25){return function(_0x43cba3){try{jsonpatch[_0x88b2('0x23')](_0x43cba3,_0x53bf25,!![]);}catch(_0x2237ed){return BPromise[_0x88b2('0x24')](_0x2237ed);}return _0x43cba3[_0x88b2('0x25')]();};}function saveUpdates(_0x3175a6,_0x5628a3){return function(_0x407fd8){if(_0x407fd8){return _0x407fd8['update'](_0x3175a6)[_0x88b2('0x26')](function(_0x128ebe){return _0x128ebe;});}return null;};}function removeEntity(_0x9ffb2,_0x5cd07a){return function(_0x3e801b){if(_0x3e801b){return _0x3e801b[_0x88b2('0x27')]()[_0x88b2('0x26')](function(){var _0x2d467e=_0x3e801b[_0x88b2('0x28')]({'plain':!![]});var _0x342c3f=_0x88b2('0x29');return db[_0x88b2('0x2a')][_0x88b2('0x27')]({'where':{'type':_0x342c3f,'resourceId':_0x2d467e['id']}})['then'](function(){return _0x3e801b;});})['then'](function(){_0x9ffb2[_0x88b2('0x1b')](0xcc)[_0x88b2('0x2b')]();});}};}function handleEntityNotFound(_0xcc1ea0,_0x29dd24){return function(_0x5ee644){if(!_0x5ee644){_0xcc1ea0[_0x88b2('0x1a')](0x194);}return _0x5ee644;};}function handleError(_0x55b569,_0x5cd09a){_0x5cd09a=_0x5cd09a||0x1f4;return function(_0x3c3d6a){logger[_0x88b2('0x2c')](_0x3c3d6a[_0x88b2('0x2d')]);if(_0x3c3d6a[_0x88b2('0x2e')]){delete _0x3c3d6a['name'];}_0x55b569['status'](_0x5cd09a)[_0x88b2('0x2f')](_0x3c3d6a);};}exports[_0x88b2('0x30')]=function(_0x15a696,_0x5646da){var _0x17fc63={},_0x4788bd={},_0x2ffaa6={'count':0x0,'rows':[]};var _0xe764ed=_[_0x88b2('0x31')](db['SquareOdbc'][_0x88b2('0x32')],function(_0x45c4b8){return{'name':_0x45c4b8['fieldName'],'type':_0x45c4b8['type']['key']};});_0x4788bd['model']=_[_0x88b2('0x31')](_0xe764ed,_0x88b2('0x2e'));_0x4788bd[_0x88b2('0x33')]=_['keys'](_0x15a696[_0x88b2('0x33')]);_0x4788bd[_0x88b2('0x34')]=_[_0x88b2('0x35')](_0x4788bd[_0x88b2('0x36')],_0x4788bd[_0x88b2('0x33')]);_0x17fc63[_0x88b2('0x37')]=_[_0x88b2('0x35')](_0x4788bd[_0x88b2('0x36')],qs[_0x88b2('0x38')](_0x15a696[_0x88b2('0x33')][_0x88b2('0x38')]));_0x17fc63[_0x88b2('0x37')]=_0x17fc63['attributes']['length']?_0x17fc63[_0x88b2('0x37')]:_0x4788bd['model'];if(!_0x15a696[_0x88b2('0x33')][_0x88b2('0x39')]('nolimit')){_0x17fc63[_0x88b2('0x1e')]=qs[_0x88b2('0x1e')](_0x15a696[_0x88b2('0x33')][_0x88b2('0x1e')]);_0x17fc63['offset']=qs[_0x88b2('0x20')](_0x15a696[_0x88b2('0x33')][_0x88b2('0x20')]);}_0x17fc63[_0x88b2('0x3a')]=qs['sort'](_0x15a696['query'][_0x88b2('0x3b')]);_0x17fc63[_0x88b2('0x3c')]=qs[_0x88b2('0x34')](_[_0x88b2('0x3d')](_0x15a696[_0x88b2('0x33')],_0x4788bd['filters']),_0xe764ed);if(_0x15a696[_0x88b2('0x33')][_0x88b2('0x3e')]){_0x17fc63[_0x88b2('0x3c')]=_[_0x88b2('0x3f')](_0x17fc63[_0x88b2('0x3c')],{'$or':_['map'](_0xe764ed,function(_0x275ef4){if(_0x275ef4[_0x88b2('0x40')]!==_0x88b2('0x41')){var _0x3f8f54={};_0x3f8f54[_0x275ef4['name']]={'$like':'%'+_0x15a696[_0x88b2('0x33')][_0x88b2('0x3e')]+'%'};return _0x3f8f54;}})});}_0x17fc63=_['merge']({},_0x17fc63,_0x15a696[_0x88b2('0x42')]);var _0x173f5d={'where':_0x17fc63[_0x88b2('0x3c')]};return db['SquareOdbc'][_0x88b2('0x1f')](_0x173f5d)['then'](function(_0x324e97){_0x2ffaa6[_0x88b2('0x1f')]=_0x324e97;if(_0x15a696[_0x88b2('0x33')][_0x88b2('0x43')]){_0x17fc63['include']=[{'all':!![]}];}return db[_0x88b2('0x44')]['findAll'](_0x17fc63);})[_0x88b2('0x26')](function(_0x2eb7f1){_0x2ffaa6[_0x88b2('0x45')]=_0x2eb7f1;return _0x2ffaa6;})[_0x88b2('0x26')](respondWithFilteredResult(_0x5646da,_0x17fc63))[_0x88b2('0x46')](handleError(_0x5646da,null));};exports['show']=function(_0x385999,_0x1bf5a8){var _0x243bed={'raw':!![],'where':{'id':_0x385999[_0x88b2('0x47')]['id']}},_0x2a96ce={};_0x2a96ce['model']=_['keys'](db[_0x88b2('0x44')]['rawAttributes']);_0x2a96ce[_0x88b2('0x33')]=_['keys'](_0x385999[_0x88b2('0x33')]);_0x2a96ce['filters']=_[_0x88b2('0x35')](_0x2a96ce[_0x88b2('0x36')],_0x2a96ce[_0x88b2('0x33')]);_0x243bed[_0x88b2('0x37')]=_[_0x88b2('0x35')](_0x2a96ce[_0x88b2('0x36')],qs[_0x88b2('0x38')](_0x385999[_0x88b2('0x33')][_0x88b2('0x38')]));_0x243bed['attributes']=_0x243bed[_0x88b2('0x37')]['length']?_0x243bed[_0x88b2('0x37')]:_0x2a96ce[_0x88b2('0x36')];if(_0x385999[_0x88b2('0x33')][_0x88b2('0x43')]){_0x243bed[_0x88b2('0x48')]=[{'all':!![]}];}_0x243bed=_[_0x88b2('0x3f')]({},_0x243bed,_0x385999[_0x88b2('0x42')]);return db['SquareOdbc'][_0x88b2('0x49')](_0x243bed)[_0x88b2('0x26')](handleEntityNotFound(_0x1bf5a8,null))['then'](respondWithResult(_0x1bf5a8,null))[_0x88b2('0x46')](handleError(_0x1bf5a8,null));};exports[_0x88b2('0x4a')]=function(_0x246c0e,_0x346880){return db[_0x88b2('0x44')][_0x88b2('0x4a')](_0x246c0e[_0x88b2('0x4b')],{})[_0x88b2('0x26')](function(_0x4bb7f1){var _0x213766=_0x246c0e['user'][_0x88b2('0x28')]({'plain':!![]});if(!_0x213766)throw new Error(_0x88b2('0x4c'));if(_0x213766['role']==='user'){var _0x3a49b3=_0x4bb7f1[_0x88b2('0x28')]({'plain':!![]});var _0x4d40f9=_0x88b2('0x29');return db['UserProfileSection'][_0x88b2('0x49')]({'where':{'name':_0x4d40f9,'userProfileId':_0x213766['userProfileId']},'raw':!![]})[_0x88b2('0x26')](function(_0x26ad60){if(_0x26ad60&&_0x26ad60[_0x88b2('0x4d')]===0x0){return db['UserProfileResource'][_0x88b2('0x4a')]({'name':_0x3a49b3[_0x88b2('0x2e')],'resourceId':_0x3a49b3['id'],'type':_0x26ad60[_0x88b2('0x2e')],'sectionId':_0x26ad60['id']},{})[_0x88b2('0x26')](function(){return _0x4bb7f1;});}else{return _0x4bb7f1;}})[_0x88b2('0x46')](function(_0x3acd9d){logger['error'](_0x88b2('0x4e'),_0x3acd9d);throw _0x3acd9d;});}return _0x4bb7f1;})[_0x88b2('0x26')](respondWithResult(_0x346880,0xc9))[_0x88b2('0x46')](handleError(_0x346880,null));};exports[_0x88b2('0x4f')]=function(_0x11c23b,_0x5c0e40){if(_0x11c23b[_0x88b2('0x4b')]['id']){delete _0x11c23b[_0x88b2('0x4b')]['id'];}return db[_0x88b2('0x44')][_0x88b2('0x49')]({'where':{'id':_0x11c23b['params']['id']}})[_0x88b2('0x26')](handleEntityNotFound(_0x5c0e40,null))[_0x88b2('0x26')](saveUpdates(_0x11c23b['body'],null))[_0x88b2('0x26')](respondWithResult(_0x5c0e40,null))['catch'](handleError(_0x5c0e40,null));};exports[_0x88b2('0x27')]=function(_0x5ba348,_0x3a969b){return db[_0x88b2('0x44')][_0x88b2('0x49')]({'where':{'id':_0x5ba348[_0x88b2('0x47')]['id']}})['then'](handleEntityNotFound(_0x3a969b,null))[_0x88b2('0x26')](removeEntity(_0x3a969b,null))[_0x88b2('0x46')](handleError(_0x3a969b,null));};exports['test']=function(_0x5ed8a9,_0x2ec657,_0x56d1a3){var _0x13ddc3;return db[_0x88b2('0x44')][_0x88b2('0x49')]({'where':{'id':_0x5ed8a9[_0x88b2('0x47')]['id']},'attributes':['id',_0x88b2('0x50')]})['then'](handleEntityNotFound(_0x2ec657,null))[_0x88b2('0x26')](function(_0x459f24){if(_0x459f24){var _0x1e4e61=require(_0x88b2('0x51'))();_0x1e4e61[_0x88b2('0x52')](_0x459f24['dsn']);_0x1e4e61[_0x88b2('0x53')]();return _0x459f24;}})[_0x88b2('0x26')](respondWithResult(_0x2ec657,null))[_0x88b2('0x46')](handleError(_0x2ec657,null));};