8f4f9cb5be61edf666036ced410d45f7627bf64d
[motion2.git] / server / api / intVtigerConfiguration / intVtigerConfiguration.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 _0xa2ab=['getDescriptions','eml-format','rimraf','zip-dir','request-promise','moment','bluebird','mustache','util','path','sox','ejs','fs-extra','lodash','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','sendStatus','end','json','offset','undefined','count','status','Content-Range','apply','reject','save','update','then','destroy','stack','name','index','map','VtigerConfiguration','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','where','pick','filter','merge','options','include','findAll','rows','catch','show','params','includeAll','find','create','body','findOne','getFields','getSubjects','VtigerField'];(function(_0xba0ecf,_0x595808){var _0x3a66a7=function(_0x1d2687){while(--_0x1d2687){_0xba0ecf['push'](_0xba0ecf['shift']());}};_0x3a66a7(++_0x595808);}(_0xa2ab,0xa7));var _0xba2a=function(_0x5480e5,_0x52e354){_0x5480e5=_0x5480e5-0x0;var _0x20b7cc=_0xa2ab[_0x5480e5];return _0x20b7cc;};'use strict';var emlformat=require(_0xba2a('0x0'));var rimraf=require(_0xba2a('0x1'));var zipdir=require(_0xba2a('0x2'));var jsonpatch=require('fast-json-patch');var rp=require(_0xba2a('0x3'));var moment=require(_0xba2a('0x4'));var BPromise=require(_0xba2a('0x5'));var Mustache=require(_0xba2a('0x6'));var util=require(_0xba2a('0x7'));var path=require(_0xba2a('0x8'));var sox=require(_0xba2a('0x9'));var csv=require('to-csv');var ejs=require(_0xba2a('0xa'));var fs=require('fs');var fs_extra=require(_0xba2a('0xb'));var _=require(_0xba2a('0xc'));var squel=require('squel');var crypto=require(_0xba2a('0xd'));var jsforce=require(_0xba2a('0xe'));var deskjs=require(_0xba2a('0xf'));var toCsv=require(_0xba2a('0x10'));var querystring=require('querystring');var Papa=require(_0xba2a('0x11'));var Redis=require(_0xba2a('0x12'));var authService=require(_0xba2a('0x13'));var qs=require(_0xba2a('0x14'));var as=require(_0xba2a('0x15'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xba2a('0x16'))(_0xba2a('0x17'));var utils=require(_0xba2a('0x18'));var config=require(_0xba2a('0x19'));var licenseUtil=require('../../config/license/util');var db=require(_0xba2a('0x1a'))['db'];function respondWithStatusCode(_0x10bf76,_0x94b897){_0x94b897=_0x94b897||0xcc;return function(_0x2c850e){if(_0x2c850e){return _0x10bf76[_0xba2a('0x1b')](_0x94b897);}return _0x10bf76['status'](_0x94b897)[_0xba2a('0x1c')]();};}function respondWithResult(_0x44759c,_0xe2bbdb){_0xe2bbdb=_0xe2bbdb||0xc8;return function(_0x127c42){if(_0x127c42){return _0x44759c['status'](_0xe2bbdb)[_0xba2a('0x1d')](_0x127c42);}};}function respondWithFilteredResult(_0x1b3272,_0x261f90){return function(_0x4147a6){if(_0x4147a6){var _0x4b9f63=typeof _0x261f90[_0xba2a('0x1e')]===_0xba2a('0x1f')&&typeof _0x261f90['limit']===_0xba2a('0x1f');var _0x49c57e=_0x4147a6['count'];var _0x559c6e=_0x4b9f63?0x0:_0x261f90[_0xba2a('0x1e')];var _0xa56be8=_0x4b9f63?_0x4147a6[_0xba2a('0x20')]:_0x261f90[_0xba2a('0x1e')]+_0x261f90['limit'];var _0x437e4c;if(_0xa56be8>=_0x49c57e){_0xa56be8=_0x49c57e;_0x437e4c=0xc8;}else{_0x437e4c=0xce;}_0x1b3272[_0xba2a('0x21')](_0x437e4c);return _0x1b3272['set'](_0xba2a('0x22'),_0x559c6e+'-'+_0xa56be8+'/'+_0x49c57e)['json'](_0x4147a6);}return null;};}function patchUpdates(_0x3b3924){return function(_0x2ad68){try{jsonpatch[_0xba2a('0x23')](_0x2ad68,_0x3b3924,!![]);}catch(_0x1d4ba9){return BPromise[_0xba2a('0x24')](_0x1d4ba9);}return _0x2ad68[_0xba2a('0x25')]();};}function saveUpdates(_0x55565d,_0x2e0712){return function(_0x2cc3db){if(_0x2cc3db){return _0x2cc3db[_0xba2a('0x26')](_0x55565d)[_0xba2a('0x27')](function(_0x3bc8e1){return _0x3bc8e1;});}return null;};}function removeEntity(_0x56fa5e,_0xdfbf5c){return function(_0x4458cb){if(_0x4458cb){return _0x4458cb[_0xba2a('0x28')]()[_0xba2a('0x27')](function(){_0x56fa5e[_0xba2a('0x21')](0xcc)[_0xba2a('0x1c')]();});}};}function handleEntityNotFound(_0x24ee7d,_0x415dd7){return function(_0x4bba7a){if(!_0x4bba7a){_0x24ee7d[_0xba2a('0x1b')](0x194);}return _0x4bba7a;};}function handleError(_0x3d1a75,_0x1a0f21){_0x1a0f21=_0x1a0f21||0x1f4;return function(_0x2a001c){logger['error'](_0x2a001c[_0xba2a('0x29')]);if(_0x2a001c[_0xba2a('0x2a')]){delete _0x2a001c[_0xba2a('0x2a')];}_0x3d1a75['status'](_0x1a0f21)['send'](_0x2a001c);};}exports[_0xba2a('0x2b')]=function(_0x2f292b,_0x19c776){var _0x3bb5c3={},_0x3aa95a={},_0x403372={'count':0x0,'rows':[]};var _0x85d5a4=_[_0xba2a('0x2c')](db[_0xba2a('0x2d')][_0xba2a('0x2e')],function(_0x53f32d){return{'name':_0x53f32d[_0xba2a('0x2f')],'type':_0x53f32d[_0xba2a('0x30')][_0xba2a('0x31')]};});_0x3aa95a[_0xba2a('0x32')]=_['map'](_0x85d5a4,_0xba2a('0x2a'));_0x3aa95a[_0xba2a('0x33')]=_[_0xba2a('0x34')](_0x2f292b['query']);_0x3aa95a[_0xba2a('0x35')]=_[_0xba2a('0x36')](_0x3aa95a[_0xba2a('0x32')],_0x3aa95a[_0xba2a('0x33')]);_0x3bb5c3[_0xba2a('0x37')]=_[_0xba2a('0x36')](_0x3aa95a[_0xba2a('0x32')],qs[_0xba2a('0x38')](_0x2f292b['query'][_0xba2a('0x38')]));_0x3bb5c3[_0xba2a('0x37')]=_0x3bb5c3[_0xba2a('0x37')][_0xba2a('0x39')]?_0x3bb5c3[_0xba2a('0x37')]:_0x3aa95a['model'];if(!_0x2f292b[_0xba2a('0x33')][_0xba2a('0x3a')](_0xba2a('0x3b'))){_0x3bb5c3[_0xba2a('0x3c')]=qs['limit'](_0x2f292b[_0xba2a('0x33')][_0xba2a('0x3c')]);_0x3bb5c3[_0xba2a('0x1e')]=qs['offset'](_0x2f292b[_0xba2a('0x33')][_0xba2a('0x1e')]);}_0x3bb5c3[_0xba2a('0x3d')]=qs['sort'](_0x2f292b[_0xba2a('0x33')][_0xba2a('0x3e')]);_0x3bb5c3[_0xba2a('0x3f')]=qs[_0xba2a('0x35')](_[_0xba2a('0x40')](_0x2f292b[_0xba2a('0x33')],_0x3aa95a[_0xba2a('0x35')]),_0x85d5a4);if(_0x2f292b['query'][_0xba2a('0x41')]){_0x3bb5c3['where']=_[_0xba2a('0x42')](_0x3bb5c3[_0xba2a('0x3f')],{'$or':_['map'](_0x85d5a4,function(_0x5e4aa6){if(_0x5e4aa6['type']!=='VIRTUAL'){var _0x2402ff={};_0x2402ff[_0x5e4aa6['name']]={'$like':'%'+_0x2f292b[_0xba2a('0x33')][_0xba2a('0x41')]+'%'};return _0x2402ff;}})});}_0x3bb5c3=_['merge']({},_0x3bb5c3,_0x2f292b[_0xba2a('0x43')]);var _0x35a9c1={'where':_0x3bb5c3[_0xba2a('0x3f')]};return db['VtigerConfiguration'][_0xba2a('0x20')](_0x35a9c1)['then'](function(_0x34fbfb){_0x403372[_0xba2a('0x20')]=_0x34fbfb;if(_0x2f292b[_0xba2a('0x33')]['includeAll']){_0x3bb5c3[_0xba2a('0x44')]=[{'all':!![]}];}return db[_0xba2a('0x2d')][_0xba2a('0x45')](_0x3bb5c3);})['then'](function(_0xc184a6){_0x403372[_0xba2a('0x46')]=_0xc184a6;return _0x403372;})['then'](respondWithFilteredResult(_0x19c776,_0x3bb5c3))[_0xba2a('0x47')](handleError(_0x19c776,null));};exports[_0xba2a('0x48')]=function(_0x22a674,_0xc180a6){var _0x38d98c={'raw':![],'where':{'id':_0x22a674[_0xba2a('0x49')]['id']}},_0x3905d7={};_0x3905d7[_0xba2a('0x32')]=_[_0xba2a('0x34')](db['VtigerConfiguration'][_0xba2a('0x2e')]);_0x3905d7[_0xba2a('0x33')]=_['keys'](_0x22a674[_0xba2a('0x33')]);_0x3905d7[_0xba2a('0x35')]=_[_0xba2a('0x36')](_0x3905d7[_0xba2a('0x32')],_0x3905d7['query']);_0x38d98c['attributes']=_['intersection'](_0x3905d7['model'],qs[_0xba2a('0x38')](_0x22a674[_0xba2a('0x33')]['fields']));_0x38d98c['attributes']=_0x38d98c['attributes'][_0xba2a('0x39')]?_0x38d98c[_0xba2a('0x37')]:_0x3905d7['model'];if(_0x22a674['query'][_0xba2a('0x4a')]){_0x38d98c[_0xba2a('0x44')]=[{'all':!![]}];}_0x38d98c=_['merge']({},_0x38d98c,_0x22a674[_0xba2a('0x43')]);return db[_0xba2a('0x2d')][_0xba2a('0x4b')](_0x38d98c)['then'](handleEntityNotFound(_0xc180a6,null))[_0xba2a('0x27')](respondWithResult(_0xc180a6,null))['catch'](handleError(_0xc180a6,null));};exports[_0xba2a('0x4c')]=function(_0x574075,_0x317bd8){return db[_0xba2a('0x2d')][_0xba2a('0x4c')](_0x574075[_0xba2a('0x4d')],{})[_0xba2a('0x27')](respondWithResult(_0x317bd8,0xc9))[_0xba2a('0x47')](handleError(_0x317bd8,null));};exports['update']=function(_0x46d4f8,_0x5e7dbc){if(_0x46d4f8[_0xba2a('0x4d')]['id']){delete _0x46d4f8['body']['id'];}return db[_0xba2a('0x2d')][_0xba2a('0x4b')]({'where':{'id':_0x46d4f8[_0xba2a('0x49')]['id']}})['then'](handleEntityNotFound(_0x5e7dbc,null))[_0xba2a('0x27')](saveUpdates(_0x46d4f8['body'],null))['then'](respondWithResult(_0x5e7dbc,null))[_0xba2a('0x47')](handleError(_0x5e7dbc,null));};exports['destroy']=function(_0x4f16c2,_0x236a31){return db[_0xba2a('0x2d')]['find']({'where':{'id':_0x4f16c2[_0xba2a('0x49')]['id']}})[_0xba2a('0x27')](handleEntityNotFound(_0x236a31,null))[_0xba2a('0x27')](removeEntity(_0x236a31,null))['catch'](handleError(_0x236a31,null));};exports['getFields']=function(_0x243469,_0x3c1926,_0x9e7df5){var _0x2e38a3={};var _0x395d86={};var _0x2c51d1;var _0x88c057;return db[_0xba2a('0x2d')][_0xba2a('0x4e')]({'where':{'id':_0x243469[_0xba2a('0x49')]['id']}})['then'](handleEntityNotFound(_0x3c1926,null))[_0xba2a('0x27')](function(_0x4bec55){if(_0x4bec55){_0x2c51d1=_0x4bec55;_0x395d86[_0xba2a('0x32')]=_[_0xba2a('0x34')](db['VtigerField'][_0xba2a('0x2e')]);_0x395d86[_0xba2a('0x33')]=_[_0xba2a('0x34')](_0x243469[_0xba2a('0x33')]);_0x395d86[_0xba2a('0x35')]=_[_0xba2a('0x36')](_0x395d86['model'],_0x395d86[_0xba2a('0x33')]);_0x2e38a3['attributes']=_[_0xba2a('0x36')](_0x395d86[_0xba2a('0x32')],qs[_0xba2a('0x38')](_0x243469['query'][_0xba2a('0x38')]));_0x2e38a3[_0xba2a('0x37')]=_0x2e38a3[_0xba2a('0x37')]['length']?_0x2e38a3['attributes']:_0x395d86[_0xba2a('0x32')];_0x2e38a3[_0xba2a('0x3d')]=qs[_0xba2a('0x3e')](_0x243469[_0xba2a('0x33')][_0xba2a('0x3e')]);_0x2e38a3['where']=qs[_0xba2a('0x35')](_[_0xba2a('0x40')](_0x243469[_0xba2a('0x33')],_0x395d86[_0xba2a('0x35')]));if(_0x243469['query'][_0xba2a('0x41')]){_0x2e38a3[_0xba2a('0x3f')]=_[_0xba2a('0x42')](_0x2e38a3[_0xba2a('0x3f')],{'$or':_['map'](_0x2e38a3[_0xba2a('0x37')],function(_0x121e17){var _0x44ef91={};_0x44ef91[_0x121e17]={'$like':'%'+_0x243469['query'][_0xba2a('0x41')]+'%'};return _0x44ef91;})});}_0x2e38a3=_[_0xba2a('0x42')]({},_0x2e38a3,_0x243469[_0xba2a('0x43')]);return _0x2c51d1['getFields'](_0x2e38a3);}})['then'](function(_0x284399){if(_0x284399){_0x88c057=_0x284399[_0xba2a('0x39')];if(!_0x243469['query']['hasOwnProperty'](_0xba2a('0x3b'))){_0x2e38a3[_0xba2a('0x3c')]=qs[_0xba2a('0x3c')](_0x243469['query'][_0xba2a('0x3c')]);_0x2e38a3[_0xba2a('0x1e')]=qs['offset'](_0x243469[_0xba2a('0x33')]['offset']);}return _0x2c51d1[_0xba2a('0x4f')](_0x2e38a3);}})[_0xba2a('0x27')](function(_0x4f2ae7){if(_0x4f2ae7){return _0x4f2ae7?{'count':_0x88c057,'rows':_0x4f2ae7}:null;}})[_0xba2a('0x27')](respondWithResult(_0x3c1926,null))[_0xba2a('0x47')](handleError(_0x3c1926,null));};exports[_0xba2a('0x50')]=function(_0x3858a2,_0x6ed444,_0x7a7b8e){var _0x5cc5f9={};var _0x2f87e5={};var _0x330749;var _0x2266e2;return db[_0xba2a('0x2d')][_0xba2a('0x4e')]({'where':{'id':_0x3858a2[_0xba2a('0x49')]['id']}})['then'](handleEntityNotFound(_0x6ed444,null))[_0xba2a('0x27')](function(_0x20f33f){if(_0x20f33f){_0x330749=_0x20f33f;_0x2f87e5[_0xba2a('0x32')]=_['keys'](db['VtigerField'][_0xba2a('0x2e')]);_0x2f87e5[_0xba2a('0x33')]=_['keys'](_0x3858a2[_0xba2a('0x33')]);_0x2f87e5[_0xba2a('0x35')]=_['intersection'](_0x2f87e5[_0xba2a('0x32')],_0x2f87e5['query']);_0x5cc5f9['attributes']=_[_0xba2a('0x36')](_0x2f87e5[_0xba2a('0x32')],qs[_0xba2a('0x38')](_0x3858a2[_0xba2a('0x33')][_0xba2a('0x38')]));_0x5cc5f9[_0xba2a('0x37')]=_0x5cc5f9[_0xba2a('0x37')]['length']?_0x5cc5f9['attributes']:_0x2f87e5[_0xba2a('0x32')];_0x5cc5f9[_0xba2a('0x3d')]=qs['sort'](_0x3858a2['query']['sort']);_0x5cc5f9[_0xba2a('0x3f')]=qs['filters'](_[_0xba2a('0x40')](_0x3858a2[_0xba2a('0x33')],_0x2f87e5[_0xba2a('0x35')]));if(_0x3858a2[_0xba2a('0x33')][_0xba2a('0x41')]){_0x5cc5f9[_0xba2a('0x3f')]=_[_0xba2a('0x42')](_0x5cc5f9['where'],{'$or':_['map'](_0x5cc5f9[_0xba2a('0x37')],function(_0x3f1962){var _0x5efcbd={};_0x5efcbd[_0x3f1962]={'$like':'%'+_0x3858a2['query'][_0xba2a('0x41')]+'%'};return _0x5efcbd;})});}_0x5cc5f9=_[_0xba2a('0x42')]({},_0x5cc5f9,_0x3858a2[_0xba2a('0x43')]);return _0x330749[_0xba2a('0x50')](_0x5cc5f9);}})['then'](function(_0x4634cc){if(_0x4634cc){_0x2266e2=_0x4634cc[_0xba2a('0x39')];if(!_0x3858a2[_0xba2a('0x33')][_0xba2a('0x3a')]('nolimit')){_0x5cc5f9['limit']=qs[_0xba2a('0x3c')](_0x3858a2[_0xba2a('0x33')][_0xba2a('0x3c')]);_0x5cc5f9[_0xba2a('0x1e')]=qs[_0xba2a('0x1e')](_0x3858a2[_0xba2a('0x33')]['offset']);}return _0x330749[_0xba2a('0x50')](_0x5cc5f9);}})[_0xba2a('0x27')](function(_0x51b7e3){if(_0x51b7e3){return _0x51b7e3?{'count':_0x2266e2,'rows':_0x51b7e3}:null;}})[_0xba2a('0x27')](respondWithResult(_0x6ed444,null))[_0xba2a('0x47')](handleError(_0x6ed444,null));};exports['getDescriptions']=function(_0x2d6446,_0x4ec9ea,_0x6dcd7d){var _0x339bfb={};var _0x9b427b={};var _0x4df545;var _0x63dd2f;return db[_0xba2a('0x2d')]['findOne']({'where':{'id':_0x2d6446[_0xba2a('0x49')]['id']}})['then'](handleEntityNotFound(_0x4ec9ea,null))[_0xba2a('0x27')](function(_0x499f65){if(_0x499f65){_0x4df545=_0x499f65;_0x9b427b[_0xba2a('0x32')]=_[_0xba2a('0x34')](db[_0xba2a('0x51')][_0xba2a('0x2e')]);_0x9b427b[_0xba2a('0x33')]=_[_0xba2a('0x34')](_0x2d6446[_0xba2a('0x33')]);_0x9b427b[_0xba2a('0x35')]=_[_0xba2a('0x36')](_0x9b427b[_0xba2a('0x32')],_0x9b427b[_0xba2a('0x33')]);_0x339bfb[_0xba2a('0x37')]=_[_0xba2a('0x36')](_0x9b427b[_0xba2a('0x32')],qs['fields'](_0x2d6446[_0xba2a('0x33')][_0xba2a('0x38')]));_0x339bfb[_0xba2a('0x37')]=_0x339bfb['attributes'][_0xba2a('0x39')]?_0x339bfb[_0xba2a('0x37')]:_0x9b427b['model'];_0x339bfb['order']=qs['sort'](_0x2d6446[_0xba2a('0x33')][_0xba2a('0x3e')]);_0x339bfb[_0xba2a('0x3f')]=qs[_0xba2a('0x35')](_[_0xba2a('0x40')](_0x2d6446['query'],_0x9b427b[_0xba2a('0x35')]));if(_0x2d6446[_0xba2a('0x33')][_0xba2a('0x41')]){_0x339bfb[_0xba2a('0x3f')]=_[_0xba2a('0x42')](_0x339bfb['where'],{'$or':_[_0xba2a('0x2c')](_0x339bfb[_0xba2a('0x37')],function(_0x3624dc){var _0x1fbcef={};_0x1fbcef[_0x3624dc]={'$like':'%'+_0x2d6446['query']['filter']+'%'};return _0x1fbcef;})});}_0x339bfb=_[_0xba2a('0x42')]({},_0x339bfb,_0x2d6446[_0xba2a('0x43')]);return _0x4df545[_0xba2a('0x52')](_0x339bfb);}})['then'](function(_0x172c1e){if(_0x172c1e){_0x63dd2f=_0x172c1e[_0xba2a('0x39')];if(!_0x2d6446[_0xba2a('0x33')][_0xba2a('0x3a')](_0xba2a('0x3b'))){_0x339bfb['limit']=qs[_0xba2a('0x3c')](_0x2d6446[_0xba2a('0x33')][_0xba2a('0x3c')]);_0x339bfb['offset']=qs[_0xba2a('0x1e')](_0x2d6446['query']['offset']);}return _0x4df545[_0xba2a('0x52')](_0x339bfb);}})['then'](function(_0x836cc2){if(_0x836cc2){return _0x836cc2?{'count':_0x63dd2f,'rows':_0x836cc2}:null;}})[_0xba2a('0x27')](respondWithResult(_0x4ec9ea,null))[_0xba2a('0x47')](handleError(_0x4ec9ea,null));};