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 _0x4128=['crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/environment','sendStatus','status','end','json','undefined','limit','offset','count','Content-Range','reject','save','update','then','destroy','get','ODBC','UserProfileResource','error','name','send','index','map','SquareOdbc','rawAttributes','fieldName','type','query','intersection','model','attributes','fields','length','hasOwnProperty','nolimit','sort','where','filters','filter','options','findAll','rows','catch','show','params','keys','includeAll','merge','find','create','body','user','autoAssociation','Unable\x20to\x20associate\x20the\x20resource\x20to\x20the\x20User\x20Profile:\x20%s','test','dsn','closeSync','eml-format','moment','bluebird','path','sox','to-csv','ejs','lodash','squel'];(function(_0x71c2ac,_0x32eb1f){var _0x47582e=function(_0x2365f8){while(--_0x2365f8){_0x71c2ac['push'](_0x71c2ac['shift']());}};_0x47582e(++_0x32eb1f);}(_0x4128,0x178));var _0x8412=function(_0x5614fb,_0x40331e){_0x5614fb=_0x5614fb-0x0;var _0x58a63a=_0x4128[_0x5614fb];return _0x58a63a;};'use strict';var emlformat=require(_0x8412('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x8412('0x1'));var BPromise=require(_0x8412('0x2'));var Mustache=require('mustache');var util=require('util');var path=require(_0x8412('0x3'));var sox=require(_0x8412('0x4'));var csv=require(_0x8412('0x5'));var ejs=require(_0x8412('0x6'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0x8412('0x7'));var squel=require(_0x8412('0x8'));var crypto=require(_0x8412('0x9'));var jsforce=require(_0x8412('0xa'));var deskjs=require(_0x8412('0xb'));var toCsv=require(_0x8412('0x5'));var querystring=require(_0x8412('0xc'));var Papa=require(_0x8412('0xd'));var Redis=require(_0x8412('0xe'));var authService=require(_0x8412('0xf'));var qs=require(_0x8412('0x10'));var as=require(_0x8412('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x8412('0x12'))(_0x8412('0x13'));var utils=require('../../config/utils');var config=require(_0x8412('0x14'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x26b15b,_0x2b15d2){_0x2b15d2=_0x2b15d2||0xcc;return function(_0x5f5a60){if(_0x5f5a60){return _0x26b15b[_0x8412('0x15')](_0x2b15d2);}return _0x26b15b[_0x8412('0x16')](_0x2b15d2)[_0x8412('0x17')]();};}function respondWithResult(_0x434c7f,_0x10d042){_0x10d042=_0x10d042||0xc8;return function(_0x131729){if(_0x131729){return _0x434c7f['status'](_0x10d042)[_0x8412('0x18')](_0x131729);}};}function respondWithFilteredResult(_0x3e5082,_0x11aab9){return function(_0x45775d){if(_0x45775d){var _0x457ea9=typeof _0x11aab9['offset']===_0x8412('0x19')&&typeof _0x11aab9[_0x8412('0x1a')]==='undefined';var _0x4cbe2d=_0x45775d['count'];var _0x128f9d=_0x457ea9?0x0:_0x11aab9[_0x8412('0x1b')];var _0x254ff1=_0x457ea9?_0x45775d[_0x8412('0x1c')]:_0x11aab9[_0x8412('0x1b')]+_0x11aab9['limit'];var _0x4a3f0b;if(_0x254ff1>=_0x4cbe2d){_0x254ff1=_0x4cbe2d;_0x4a3f0b=0xc8;}else{_0x4a3f0b=0xce;}_0x3e5082['status'](_0x4a3f0b);return _0x3e5082['set'](_0x8412('0x1d'),_0x128f9d+'-'+_0x254ff1+'/'+_0x4cbe2d)[_0x8412('0x18')](_0x45775d);}return null;};}function patchUpdates(_0x57a64f){return function(_0x56e167){try{jsonpatch['apply'](_0x56e167,_0x57a64f,!![]);}catch(_0x4476b1){return BPromise[_0x8412('0x1e')](_0x4476b1);}return _0x56e167[_0x8412('0x1f')]();};}function saveUpdates(_0x1a565f,_0x1c4570){return function(_0xc784eb){if(_0xc784eb){return _0xc784eb[_0x8412('0x20')](_0x1a565f)[_0x8412('0x21')](function(_0x5b02df){return _0x5b02df;});}return null;};}function removeEntity(_0x405d8b,_0x1a1c24){return function(_0x54984d){if(_0x54984d){return _0x54984d[_0x8412('0x22')]()[_0x8412('0x21')](function(){var _0x56cdd0=_0x54984d[_0x8412('0x23')]({'plain':!![]});var _0x3ba044=_0x8412('0x24');return db[_0x8412('0x25')][_0x8412('0x22')]({'where':{'type':_0x3ba044,'resourceId':_0x56cdd0['id']}})['then'](function(){return _0x54984d;});})[_0x8412('0x21')](function(){_0x405d8b[_0x8412('0x16')](0xcc)['end']();});}};}function handleEntityNotFound(_0x2b9181,_0xd7d3eb){return function(_0x2daa76){if(!_0x2daa76){_0x2b9181['sendStatus'](0x194);}return _0x2daa76;};}function handleError(_0x3b1af8,_0x514614){_0x514614=_0x514614||0x1f4;return function(_0x12db70){logger[_0x8412('0x26')](_0x12db70['stack']);if(_0x12db70[_0x8412('0x27')]){delete _0x12db70[_0x8412('0x27')];}_0x3b1af8[_0x8412('0x16')](_0x514614)[_0x8412('0x28')](_0x12db70);};}exports[_0x8412('0x29')]=function(_0x3b4db4,_0x292cd3){var _0x5a12bc={},_0x32951c={},_0x5454a0={'count':0x0,'rows':[]};var _0x11c382=_[_0x8412('0x2a')](db[_0x8412('0x2b')][_0x8412('0x2c')],function(_0x39b2cd){return{'name':_0x39b2cd[_0x8412('0x2d')],'type':_0x39b2cd[_0x8412('0x2e')]['key']};});_0x32951c['model']=_[_0x8412('0x2a')](_0x11c382,_0x8412('0x27'));_0x32951c[_0x8412('0x2f')]=_['keys'](_0x3b4db4[_0x8412('0x2f')]);_0x32951c['filters']=_[_0x8412('0x30')](_0x32951c[_0x8412('0x31')],_0x32951c[_0x8412('0x2f')]);_0x5a12bc[_0x8412('0x32')]=_[_0x8412('0x30')](_0x32951c[_0x8412('0x31')],qs[_0x8412('0x33')](_0x3b4db4[_0x8412('0x2f')][_0x8412('0x33')]));_0x5a12bc['attributes']=_0x5a12bc[_0x8412('0x32')][_0x8412('0x34')]?_0x5a12bc[_0x8412('0x32')]:_0x32951c[_0x8412('0x31')];if(!_0x3b4db4[_0x8412('0x2f')][_0x8412('0x35')](_0x8412('0x36'))){_0x5a12bc[_0x8412('0x1a')]=qs[_0x8412('0x1a')](_0x3b4db4[_0x8412('0x2f')][_0x8412('0x1a')]);_0x5a12bc[_0x8412('0x1b')]=qs[_0x8412('0x1b')](_0x3b4db4[_0x8412('0x2f')][_0x8412('0x1b')]);}_0x5a12bc['order']=qs['sort'](_0x3b4db4['query'][_0x8412('0x37')]);_0x5a12bc[_0x8412('0x38')]=qs[_0x8412('0x39')](_['pick'](_0x3b4db4['query'],_0x32951c[_0x8412('0x39')]),_0x11c382);if(_0x3b4db4[_0x8412('0x2f')]['filter']){_0x5a12bc['where']=_['merge'](_0x5a12bc[_0x8412('0x38')],{'$or':_['map'](_0x11c382,function(_0x5f2ff3){if(_0x5f2ff3[_0x8412('0x2e')]!=='VIRTUAL'){var _0x29bb5b={};_0x29bb5b[_0x5f2ff3['name']]={'$like':'%'+_0x3b4db4[_0x8412('0x2f')][_0x8412('0x3a')]+'%'};return _0x29bb5b;}})});}_0x5a12bc=_['merge']({},_0x5a12bc,_0x3b4db4[_0x8412('0x3b')]);var _0x2c304c={'where':_0x5a12bc[_0x8412('0x38')]};return db[_0x8412('0x2b')][_0x8412('0x1c')](_0x2c304c)['then'](function(_0x3220cf){_0x5454a0['count']=_0x3220cf;if(_0x3b4db4[_0x8412('0x2f')]['includeAll']){_0x5a12bc['include']=[{'all':!![]}];}return db[_0x8412('0x2b')][_0x8412('0x3c')](_0x5a12bc);})[_0x8412('0x21')](function(_0x70bf17){_0x5454a0[_0x8412('0x3d')]=_0x70bf17;return _0x5454a0;})[_0x8412('0x21')](respondWithFilteredResult(_0x292cd3,_0x5a12bc))[_0x8412('0x3e')](handleError(_0x292cd3,null));};exports[_0x8412('0x3f')]=function(_0x9f1069,_0x30070a){var _0x2104ec={'raw':!![],'where':{'id':_0x9f1069[_0x8412('0x40')]['id']}},_0x247182={};_0x247182[_0x8412('0x31')]=_[_0x8412('0x41')](db[_0x8412('0x2b')][_0x8412('0x2c')]);_0x247182[_0x8412('0x2f')]=_[_0x8412('0x41')](_0x9f1069[_0x8412('0x2f')]);_0x247182[_0x8412('0x39')]=_[_0x8412('0x30')](_0x247182['model'],_0x247182[_0x8412('0x2f')]);_0x2104ec[_0x8412('0x32')]=_[_0x8412('0x30')](_0x247182['model'],qs[_0x8412('0x33')](_0x9f1069[_0x8412('0x2f')][_0x8412('0x33')]));_0x2104ec[_0x8412('0x32')]=_0x2104ec['attributes']['length']?_0x2104ec['attributes']:_0x247182[_0x8412('0x31')];if(_0x9f1069[_0x8412('0x2f')][_0x8412('0x42')]){_0x2104ec['include']=[{'all':!![]}];}_0x2104ec=_[_0x8412('0x43')]({},_0x2104ec,_0x9f1069[_0x8412('0x3b')]);return db['SquareOdbc'][_0x8412('0x44')](_0x2104ec)[_0x8412('0x21')](handleEntityNotFound(_0x30070a,null))[_0x8412('0x21')](respondWithResult(_0x30070a,null))['catch'](handleError(_0x30070a,null));};exports[_0x8412('0x45')]=function(_0x534158,_0x1c9122){return db[_0x8412('0x2b')][_0x8412('0x45')](_0x534158[_0x8412('0x46')],{})[_0x8412('0x21')](function(_0x3cab9a){var _0x4eb717=_0x534158[_0x8412('0x47')]['get']({'plain':!![]});if(!_0x4eb717)throw new Error('Unable\x20to\x20retrieve\x20the\x20current\x20user');if(_0x4eb717['role']===_0x8412('0x47')){var _0x43272a=_0x3cab9a[_0x8412('0x23')]({'plain':!![]});var _0x1101a2=_0x8412('0x24');return db['UserProfileSection']['find']({'where':{'name':_0x1101a2,'userProfileId':_0x4eb717['userProfileId']},'raw':!![]})['then'](function(_0x107688){if(_0x107688&&_0x107688[_0x8412('0x48')]===0x0){return db[_0x8412('0x25')][_0x8412('0x45')]({'name':_0x43272a[_0x8412('0x27')],'resourceId':_0x43272a['id'],'type':_0x107688['name'],'sectionId':_0x107688['id']},{})['then'](function(){return _0x3cab9a;});}else{return _0x3cab9a;}})['catch'](function(_0x2c5642){logger[_0x8412('0x26')](_0x8412('0x49'),_0x2c5642);throw _0x2c5642;});}return _0x3cab9a;})[_0x8412('0x21')](respondWithResult(_0x1c9122,0xc9))['catch'](handleError(_0x1c9122,null));};exports[_0x8412('0x20')]=function(_0x385153,_0xa9b16e){if(_0x385153[_0x8412('0x46')]['id']){delete _0x385153[_0x8412('0x46')]['id'];}return db[_0x8412('0x2b')]['find']({'where':{'id':_0x385153[_0x8412('0x40')]['id']}})['then'](handleEntityNotFound(_0xa9b16e,null))['then'](saveUpdates(_0x385153[_0x8412('0x46')],null))[_0x8412('0x21')](respondWithResult(_0xa9b16e,null))[_0x8412('0x3e')](handleError(_0xa9b16e,null));};exports['destroy']=function(_0x4a7281,_0x51cc41){return db[_0x8412('0x2b')][_0x8412('0x44')]({'where':{'id':_0x4a7281[_0x8412('0x40')]['id']}})[_0x8412('0x21')](handleEntityNotFound(_0x51cc41,null))[_0x8412('0x21')](removeEntity(_0x51cc41,null))[_0x8412('0x3e')](handleError(_0x51cc41,null));};exports[_0x8412('0x4a')]=function(_0x2bb675,_0x34a276,_0x36b41f){var _0x2060d9;return db[_0x8412('0x2b')]['find']({'where':{'id':_0x2bb675[_0x8412('0x40')]['id']},'attributes':['id',_0x8412('0x4b')]})[_0x8412('0x21')](handleEntityNotFound(_0x34a276,null))[_0x8412('0x21')](function(_0x58a4ed){if(_0x58a4ed){var _0x29ef95=require('odbc')();_0x29ef95['openSync'](_0x58a4ed[_0x8412('0x4b')]);_0x29ef95[_0x8412('0x4c')]();return _0x58a4ed;}})[_0x8412('0x21')](respondWithResult(_0x34a276,null))[_0x8412('0x3e')](handleError(_0x34a276,null));};