server/api/intFreshsalesConfiguration/intFreshsalesConfiguration.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 _0xa50d=['show','params','rawAttributes','create','body','find','destroy','getSubjects','FreshsalesField','hasOwnProperty','getDescriptions','getFields','findOne','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','ejs','lodash','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','count','limit','set','Content-Range','reject','save','update','then','end','error','stack','name','send','index','map','FreshsalesConfiguration','fieldName','model','query','keys','intersection','fields','attributes','length','nolimit','order','sort','where','filters','pick','filter','merge','type','VIRTUAL','options','includeAll','include','findAll','catch'];(function(_0x26c9c5,_0x5440b9){var _0x29fc87=function(_0x3d3839){while(--_0x3d3839){_0x26c9c5['push'](_0x26c9c5['shift']());}};_0x29fc87(++_0x5440b9);}(_0xa50d,0x15d));var _0xda50=function(_0x35b44b,_0x2d33b8){_0x35b44b=_0x35b44b-0x0;var _0x1ccf6a=_0xa50d[_0x35b44b];return _0x1ccf6a;};'use strict';var emlformat=require(_0xda50('0x0'));var rimraf=require(_0xda50('0x1'));var zipdir=require(_0xda50('0x2'));var jsonpatch=require(_0xda50('0x3'));var rp=require(_0xda50('0x4'));var moment=require(_0xda50('0x5'));var BPromise=require(_0xda50('0x6'));var Mustache=require(_0xda50('0x7'));var util=require(_0xda50('0x8'));var path=require(_0xda50('0x9'));var sox=require(_0xda50('0xa'));var csv=require('to-csv');var ejs=require(_0xda50('0xb'));var fs=require('fs');var fs_extra=require('fs-extra');var _=require(_0xda50('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xda50('0xd'));var deskjs=require(_0xda50('0xe'));var toCsv=require(_0xda50('0xf'));var querystring=require(_0xda50('0x10'));var Papa=require(_0xda50('0x11'));var Redis=require(_0xda50('0x12'));var authService=require(_0xda50('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0xda50('0x14'));var hardwareService=require(_0xda50('0x15'));var logger=require('../../config/logger')(_0xda50('0x16'));var utils=require(_0xda50('0x17'));var config=require(_0xda50('0x18'));var licenseUtil=require(_0xda50('0x19'));var db=require(_0xda50('0x1a'))['db'];function respondWithStatusCode(_0x5d4ba4,_0x1b0cb4){_0x1b0cb4=_0x1b0cb4||0xcc;return function(_0x44ecb6){if(_0x44ecb6){return _0x5d4ba4[_0xda50('0x1b')](_0x1b0cb4);}return _0x5d4ba4[_0xda50('0x1c')](_0x1b0cb4)['end']();};}function respondWithResult(_0x51c77d,_0x11ab6c){_0x11ab6c=_0x11ab6c||0xc8;return function(_0xc19927){if(_0xc19927){return _0x51c77d[_0xda50('0x1c')](_0x11ab6c)[_0xda50('0x1d')](_0xc19927);}};}function respondWithFilteredResult(_0x3f5a32,_0x5114d5){return function(_0x3e2e27){if(_0x3e2e27){var _0x117f7e=typeof _0x5114d5[_0xda50('0x1e')]===_0xda50('0x1f')&&typeof _0x5114d5['limit']===_0xda50('0x1f');var _0x58d1d4=_0x3e2e27[_0xda50('0x20')];var _0x3c9dbf=_0x117f7e?0x0:_0x5114d5['offset'];var _0xa4ecaf=_0x117f7e?_0x3e2e27[_0xda50('0x20')]:_0x5114d5[_0xda50('0x1e')]+_0x5114d5[_0xda50('0x21')];var _0x5cac34;if(_0xa4ecaf>=_0x58d1d4){_0xa4ecaf=_0x58d1d4;_0x5cac34=0xc8;}else{_0x5cac34=0xce;}_0x3f5a32['status'](_0x5cac34);return _0x3f5a32[_0xda50('0x22')](_0xda50('0x23'),_0x3c9dbf+'-'+_0xa4ecaf+'/'+_0x58d1d4)[_0xda50('0x1d')](_0x3e2e27);}return null;};}function patchUpdates(_0x37364b){return function(_0x2b6ae0){try{jsonpatch['apply'](_0x2b6ae0,_0x37364b,!![]);}catch(_0x374e38){return BPromise[_0xda50('0x24')](_0x374e38);}return _0x2b6ae0[_0xda50('0x25')]();};}function saveUpdates(_0x5daea4,_0x4c74c5){return function(_0x4908f8){if(_0x4908f8){return _0x4908f8[_0xda50('0x26')](_0x5daea4)[_0xda50('0x27')](function(_0x4e1178){return _0x4e1178;});}return null;};}function removeEntity(_0x4ff5bc,_0x352a50){return function(_0x59166e){if(_0x59166e){return _0x59166e['destroy']()[_0xda50('0x27')](function(){_0x4ff5bc['status'](0xcc)[_0xda50('0x28')]();});}};}function handleEntityNotFound(_0x3b3143,_0x3102e5){return function(_0x2eeb27){if(!_0x2eeb27){_0x3b3143['sendStatus'](0x194);}return _0x2eeb27;};}function handleError(_0x4804e6,_0x1a9ca6){_0x1a9ca6=_0x1a9ca6||0x1f4;return function(_0x3a6f4b){logger[_0xda50('0x29')](_0x3a6f4b[_0xda50('0x2a')]);if(_0x3a6f4b[_0xda50('0x2b')]){delete _0x3a6f4b['name'];}_0x4804e6[_0xda50('0x1c')](_0x1a9ca6)[_0xda50('0x2c')](_0x3a6f4b);};}exports[_0xda50('0x2d')]=function(_0x146016,_0x35285b){var _0x3c3484={},_0x9ccaf0={},_0x4aaff6={'count':0x0,'rows':[]};var _0x2bd947=_[_0xda50('0x2e')](db[_0xda50('0x2f')]['rawAttributes'],function(_0x50d43c){return{'name':_0x50d43c[_0xda50('0x30')],'type':_0x50d43c['type']['key']};});_0x9ccaf0[_0xda50('0x31')]=_[_0xda50('0x2e')](_0x2bd947,_0xda50('0x2b'));_0x9ccaf0[_0xda50('0x32')]=_[_0xda50('0x33')](_0x146016[_0xda50('0x32')]);_0x9ccaf0['filters']=_[_0xda50('0x34')](_0x9ccaf0['model'],_0x9ccaf0[_0xda50('0x32')]);_0x3c3484['attributes']=_[_0xda50('0x34')](_0x9ccaf0[_0xda50('0x31')],qs[_0xda50('0x35')](_0x146016[_0xda50('0x32')][_0xda50('0x35')]));_0x3c3484[_0xda50('0x36')]=_0x3c3484[_0xda50('0x36')][_0xda50('0x37')]?_0x3c3484[_0xda50('0x36')]:_0x9ccaf0[_0xda50('0x31')];if(!_0x146016[_0xda50('0x32')]['hasOwnProperty'](_0xda50('0x38'))){_0x3c3484[_0xda50('0x21')]=qs[_0xda50('0x21')](_0x146016[_0xda50('0x32')]['limit']);_0x3c3484[_0xda50('0x1e')]=qs[_0xda50('0x1e')](_0x146016[_0xda50('0x32')]['offset']);}_0x3c3484[_0xda50('0x39')]=qs[_0xda50('0x3a')](_0x146016[_0xda50('0x32')][_0xda50('0x3a')]);_0x3c3484[_0xda50('0x3b')]=qs[_0xda50('0x3c')](_[_0xda50('0x3d')](_0x146016['query'],_0x9ccaf0[_0xda50('0x3c')]),_0x2bd947);if(_0x146016['query'][_0xda50('0x3e')]){_0x3c3484['where']=_[_0xda50('0x3f')](_0x3c3484[_0xda50('0x3b')],{'$or':_['map'](_0x2bd947,function(_0x5f0e8c){if(_0x5f0e8c[_0xda50('0x40')]!==_0xda50('0x41')){var _0x3fca2c={};_0x3fca2c[_0x5f0e8c[_0xda50('0x2b')]]={'$like':'%'+_0x146016[_0xda50('0x32')]['filter']+'%'};return _0x3fca2c;}})});}_0x3c3484=_[_0xda50('0x3f')]({},_0x3c3484,_0x146016[_0xda50('0x42')]);var _0x169787={'where':_0x3c3484[_0xda50('0x3b')]};return db['FreshsalesConfiguration']['count'](_0x169787)[_0xda50('0x27')](function(_0x455213){_0x4aaff6[_0xda50('0x20')]=_0x455213;if(_0x146016['query'][_0xda50('0x43')]){_0x3c3484[_0xda50('0x44')]=[{'all':!![]}];}return db[_0xda50('0x2f')][_0xda50('0x45')](_0x3c3484);})[_0xda50('0x27')](function(_0x26e5e3){_0x4aaff6['rows']=_0x26e5e3;return _0x4aaff6;})[_0xda50('0x27')](respondWithFilteredResult(_0x35285b,_0x3c3484))[_0xda50('0x46')](handleError(_0x35285b,null));};exports[_0xda50('0x47')]=function(_0xf66909,_0x1c38fe){var _0x2c77fe={'raw':![],'where':{'id':_0xf66909[_0xda50('0x48')]['id']}},_0x467b2f={};_0x467b2f[_0xda50('0x31')]=_[_0xda50('0x33')](db[_0xda50('0x2f')][_0xda50('0x49')]);_0x467b2f[_0xda50('0x32')]=_[_0xda50('0x33')](_0xf66909[_0xda50('0x32')]);_0x467b2f['filters']=_[_0xda50('0x34')](_0x467b2f[_0xda50('0x31')],_0x467b2f[_0xda50('0x32')]);_0x2c77fe[_0xda50('0x36')]=_['intersection'](_0x467b2f['model'],qs[_0xda50('0x35')](_0xf66909[_0xda50('0x32')]['fields']));_0x2c77fe['attributes']=_0x2c77fe[_0xda50('0x36')][_0xda50('0x37')]?_0x2c77fe[_0xda50('0x36')]:_0x467b2f['model'];if(_0xf66909['query'][_0xda50('0x43')]){_0x2c77fe[_0xda50('0x44')]=[{'all':!![]}];}_0x2c77fe=_[_0xda50('0x3f')]({},_0x2c77fe,_0xf66909[_0xda50('0x42')]);return db[_0xda50('0x2f')]['find'](_0x2c77fe)[_0xda50('0x27')](handleEntityNotFound(_0x1c38fe,null))[_0xda50('0x27')](respondWithResult(_0x1c38fe,null))[_0xda50('0x46')](handleError(_0x1c38fe,null));};exports['create']=function(_0x4f115b,_0xf9f75f){return db[_0xda50('0x2f')][_0xda50('0x4a')](_0x4f115b[_0xda50('0x4b')],{})[_0xda50('0x27')](respondWithResult(_0xf9f75f,0xc9))[_0xda50('0x46')](handleError(_0xf9f75f,null));};exports['update']=function(_0x327c47,_0x2ed606){if(_0x327c47[_0xda50('0x4b')]['id']){delete _0x327c47['body']['id'];}return db['FreshsalesConfiguration'][_0xda50('0x4c')]({'where':{'id':_0x327c47[_0xda50('0x48')]['id']}})[_0xda50('0x27')](handleEntityNotFound(_0x2ed606,null))[_0xda50('0x27')](saveUpdates(_0x327c47[_0xda50('0x4b')],null))[_0xda50('0x27')](respondWithResult(_0x2ed606,null))[_0xda50('0x46')](handleError(_0x2ed606,null));};exports[_0xda50('0x4d')]=function(_0x3f262e,_0x56f8f2){return db['FreshsalesConfiguration'][_0xda50('0x4c')]({'where':{'id':_0x3f262e[_0xda50('0x48')]['id']}})[_0xda50('0x27')](handleEntityNotFound(_0x56f8f2,null))[_0xda50('0x27')](removeEntity(_0x56f8f2,null))['catch'](handleError(_0x56f8f2,null));};exports[_0xda50('0x4e')]=function(_0x14ef4a,_0x567626,_0x3e8f28){var _0x742321={};var _0x3a9fbd={};var _0x1050e3;var _0x55c3ed;return db[_0xda50('0x2f')]['findOne']({'where':{'id':_0x14ef4a[_0xda50('0x48')]['id']}})[_0xda50('0x27')](handleEntityNotFound(_0x567626,null))[_0xda50('0x27')](function(_0x5ef03d){if(_0x5ef03d){_0x1050e3=_0x5ef03d;_0x3a9fbd[_0xda50('0x31')]=_['keys'](db[_0xda50('0x4f')]['rawAttributes']);_0x3a9fbd[_0xda50('0x32')]=_[_0xda50('0x33')](_0x14ef4a['query']);_0x3a9fbd[_0xda50('0x3c')]=_[_0xda50('0x34')](_0x3a9fbd[_0xda50('0x31')],_0x3a9fbd[_0xda50('0x32')]);_0x742321[_0xda50('0x36')]=_[_0xda50('0x34')](_0x3a9fbd['model'],qs[_0xda50('0x35')](_0x14ef4a[_0xda50('0x32')][_0xda50('0x35')]));_0x742321[_0xda50('0x36')]=_0x742321[_0xda50('0x36')][_0xda50('0x37')]?_0x742321['attributes']:_0x3a9fbd[_0xda50('0x31')];_0x742321[_0xda50('0x39')]=qs[_0xda50('0x3a')](_0x14ef4a['query']['sort']);_0x742321[_0xda50('0x3b')]=qs[_0xda50('0x3c')](_[_0xda50('0x3d')](_0x14ef4a[_0xda50('0x32')],_0x3a9fbd[_0xda50('0x3c')]));if(_0x14ef4a[_0xda50('0x32')]['filter']){_0x742321[_0xda50('0x3b')]=_[_0xda50('0x3f')](_0x742321[_0xda50('0x3b')],{'$or':_[_0xda50('0x2e')](_0x742321[_0xda50('0x36')],function(_0x5a270d){var _0x59303b={};_0x59303b[_0x5a270d]={'$like':'%'+_0x14ef4a['query'][_0xda50('0x3e')]+'%'};return _0x59303b;})});}_0x742321=_['merge']({},_0x742321,_0x14ef4a[_0xda50('0x42')]);return _0x1050e3[_0xda50('0x4e')](_0x742321);}})[_0xda50('0x27')](function(_0x5f5170){if(_0x5f5170){_0x55c3ed=_0x5f5170[_0xda50('0x37')];if(!_0x14ef4a[_0xda50('0x32')][_0xda50('0x50')](_0xda50('0x38'))){_0x742321[_0xda50('0x21')]=qs[_0xda50('0x21')](_0x14ef4a[_0xda50('0x32')][_0xda50('0x21')]);_0x742321['offset']=qs[_0xda50('0x1e')](_0x14ef4a[_0xda50('0x32')][_0xda50('0x1e')]);}return _0x1050e3[_0xda50('0x4e')](_0x742321);}})[_0xda50('0x27')](function(_0x13b82e){if(_0x13b82e){return _0x13b82e?{'count':_0x55c3ed,'rows':_0x13b82e}:null;}})[_0xda50('0x27')](respondWithResult(_0x567626,null))[_0xda50('0x46')](handleError(_0x567626,null));};exports[_0xda50('0x51')]=function(_0x4d758e,_0x365b37,_0x1634e7){var _0x192a28={};var _0x3578e2={};var _0x3882be;var _0x286ecd;return db[_0xda50('0x2f')]['findOne']({'where':{'id':_0x4d758e[_0xda50('0x48')]['id']}})[_0xda50('0x27')](handleEntityNotFound(_0x365b37,null))[_0xda50('0x27')](function(_0x124c45){if(_0x124c45){_0x3882be=_0x124c45;_0x3578e2[_0xda50('0x31')]=_[_0xda50('0x33')](db[_0xda50('0x4f')][_0xda50('0x49')]);_0x3578e2[_0xda50('0x32')]=_[_0xda50('0x33')](_0x4d758e[_0xda50('0x32')]);_0x3578e2['filters']=_[_0xda50('0x34')](_0x3578e2[_0xda50('0x31')],_0x3578e2['query']);_0x192a28[_0xda50('0x36')]=_[_0xda50('0x34')](_0x3578e2[_0xda50('0x31')],qs[_0xda50('0x35')](_0x4d758e[_0xda50('0x32')][_0xda50('0x35')]));_0x192a28[_0xda50('0x36')]=_0x192a28['attributes'][_0xda50('0x37')]?_0x192a28['attributes']:_0x3578e2['model'];_0x192a28['order']=qs[_0xda50('0x3a')](_0x4d758e[_0xda50('0x32')][_0xda50('0x3a')]);_0x192a28[_0xda50('0x3b')]=qs[_0xda50('0x3c')](_[_0xda50('0x3d')](_0x4d758e[_0xda50('0x32')],_0x3578e2[_0xda50('0x3c')]));if(_0x4d758e['query']['filter']){_0x192a28[_0xda50('0x3b')]=_[_0xda50('0x3f')](_0x192a28['where'],{'$or':_[_0xda50('0x2e')](_0x192a28['attributes'],function(_0x33e28b){var _0x427b80={};_0x427b80[_0x33e28b]={'$like':'%'+_0x4d758e['query'][_0xda50('0x3e')]+'%'};return _0x427b80;})});}_0x192a28=_[_0xda50('0x3f')]({},_0x192a28,_0x4d758e[_0xda50('0x42')]);return _0x3882be[_0xda50('0x51')](_0x192a28);}})[_0xda50('0x27')](function(_0x40484f){if(_0x40484f){_0x286ecd=_0x40484f[_0xda50('0x37')];if(!_0x4d758e['query'][_0xda50('0x50')](_0xda50('0x38'))){_0x192a28[_0xda50('0x21')]=qs['limit'](_0x4d758e[_0xda50('0x32')][_0xda50('0x21')]);_0x192a28[_0xda50('0x1e')]=qs[_0xda50('0x1e')](_0x4d758e['query']['offset']);}return _0x3882be[_0xda50('0x51')](_0x192a28);}})[_0xda50('0x27')](function(_0x1281cb){if(_0x1281cb){return _0x1281cb?{'count':_0x286ecd,'rows':_0x1281cb}:null;}})['then'](respondWithResult(_0x365b37,null))[_0xda50('0x46')](handleError(_0x365b37,null));};exports[_0xda50('0x52')]=function(_0x4ee2b3,_0x151600,_0x7c978f){var _0x319a2f={};var _0x3054f2={};var _0x107b3f;var _0x7a8258;return db['FreshsalesConfiguration'][_0xda50('0x53')]({'where':{'id':_0x4ee2b3['params']['id']}})['then'](handleEntityNotFound(_0x151600,null))['then'](function(_0x1c63fb){if(_0x1c63fb){_0x107b3f=_0x1c63fb;_0x3054f2['model']=_[_0xda50('0x33')](db[_0xda50('0x4f')]['rawAttributes']);_0x3054f2[_0xda50('0x32')]=_[_0xda50('0x33')](_0x4ee2b3[_0xda50('0x32')]);_0x3054f2['filters']=_[_0xda50('0x34')](_0x3054f2['model'],_0x3054f2['query']);_0x319a2f[_0xda50('0x36')]=_['intersection'](_0x3054f2[_0xda50('0x31')],qs[_0xda50('0x35')](_0x4ee2b3[_0xda50('0x32')][_0xda50('0x35')]));_0x319a2f['attributes']=_0x319a2f['attributes'][_0xda50('0x37')]?_0x319a2f[_0xda50('0x36')]:_0x3054f2[_0xda50('0x31')];_0x319a2f[_0xda50('0x39')]=qs[_0xda50('0x3a')](_0x4ee2b3[_0xda50('0x32')][_0xda50('0x3a')]);_0x319a2f['where']=qs[_0xda50('0x3c')](_[_0xda50('0x3d')](_0x4ee2b3[_0xda50('0x32')],_0x3054f2[_0xda50('0x3c')]));if(_0x4ee2b3[_0xda50('0x32')][_0xda50('0x3e')]){_0x319a2f['where']=_[_0xda50('0x3f')](_0x319a2f[_0xda50('0x3b')],{'$or':_[_0xda50('0x2e')](_0x319a2f[_0xda50('0x36')],function(_0x27ed5d){var _0x5275ed={};_0x5275ed[_0x27ed5d]={'$like':'%'+_0x4ee2b3[_0xda50('0x32')][_0xda50('0x3e')]+'%'};return _0x5275ed;})});}_0x319a2f=_['merge']({},_0x319a2f,_0x4ee2b3[_0xda50('0x42')]);return _0x107b3f[_0xda50('0x52')](_0x319a2f);}})['then'](function(_0x59fb61){if(_0x59fb61){_0x7a8258=_0x59fb61[_0xda50('0x37')];if(!_0x4ee2b3['query'][_0xda50('0x50')]('nolimit')){_0x319a2f[_0xda50('0x21')]=qs[_0xda50('0x21')](_0x4ee2b3['query'][_0xda50('0x21')]);_0x319a2f[_0xda50('0x1e')]=qs['offset'](_0x4ee2b3[_0xda50('0x32')][_0xda50('0x1e')]);}return _0x107b3f[_0xda50('0x52')](_0x319a2f);}})['then'](function(_0x39b357){if(_0x39b357){return _0x39b357?{'count':_0x7a8258,'rows':_0x39b357}:null;}})[_0xda50('0x27')](respondWithResult(_0x151600,null))[_0xda50('0x46')](handleError(_0x151600,null));};