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 _0x97da=['save','update','then','destroy','error','stack','name','send','index','map','VtigerConfiguration','type','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','pick','filter','merge','includeAll','include','rows','catch','show','params','rawAttributes','options','find','create','body','getFields','VtigerField','nolimit','getSubjects','findOne','getDescriptions','eml-format','zip-dir','fast-json-patch','moment','mustache','util','path','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','count','limit','set','apply','reject'];(function(_0x8f3847,_0x144df9){var _0x50d9bb=function(_0x2c8a7d){while(--_0x2c8a7d){_0x8f3847['push'](_0x8f3847['shift']());}};_0x50d9bb(++_0x144df9);}(_0x97da,0x164));var _0xa97d=function(_0x8d3882,_0x4368cf){_0x8d3882=_0x8d3882-0x0;var _0xf99ea6=_0x97da[_0x8d3882];return _0xf99ea6;};'use strict';var emlformat=require(_0xa97d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xa97d('0x1'));var jsonpatch=require(_0xa97d('0x2'));var rp=require('request-promise');var moment=require(_0xa97d('0x3'));var BPromise=require('bluebird');var Mustache=require(_0xa97d('0x4'));var util=require(_0xa97d('0x5'));var path=require(_0xa97d('0x6'));var sox=require('sox');var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0xa97d('0x7'));var _=require(_0xa97d('0x8'));var squel=require(_0xa97d('0x9'));var crypto=require(_0xa97d('0xa'));var jsforce=require(_0xa97d('0xb'));var deskjs=require(_0xa97d('0xc'));var toCsv=require(_0xa97d('0xd'));var querystring=require('querystring');var Papa=require(_0xa97d('0xe'));var Redis=require(_0xa97d('0xf'));var authService=require('../../components/auth/service');var qs=require(_0xa97d('0x10'));var as=require(_0xa97d('0x11'));var hardwareService=require(_0xa97d('0x12'));var logger=require(_0xa97d('0x13'))(_0xa97d('0x14'));var utils=require('../../config/utils');var config=require(_0xa97d('0x15'));var licenseUtil=require(_0xa97d('0x16'));var db=require(_0xa97d('0x17'))['db'];function respondWithStatusCode(_0x30ea9d,_0x57400d){_0x57400d=_0x57400d||0xcc;return function(_0x202d5f){if(_0x202d5f){return _0x30ea9d[_0xa97d('0x18')](_0x57400d);}return _0x30ea9d['status'](_0x57400d)['end']();};}function respondWithResult(_0x2b1901,_0x4ee6c7){_0x4ee6c7=_0x4ee6c7||0xc8;return function(_0x16126c){if(_0x16126c){return _0x2b1901[_0xa97d('0x19')](_0x4ee6c7)[_0xa97d('0x1a')](_0x16126c);}};}function respondWithFilteredResult(_0xd23310,_0x2c94f6){return function(_0x185e62){if(_0x185e62){var _0xbe54ea=typeof _0x2c94f6[_0xa97d('0x1b')]===_0xa97d('0x1c')&&typeof _0x2c94f6['limit']===_0xa97d('0x1c');var _0x633c44=_0x185e62[_0xa97d('0x1d')];var _0x393229=_0xbe54ea?0x0:_0x2c94f6[_0xa97d('0x1b')];var _0x30fd0c=_0xbe54ea?_0x185e62[_0xa97d('0x1d')]:_0x2c94f6['offset']+_0x2c94f6[_0xa97d('0x1e')];var _0x71d415;if(_0x30fd0c>=_0x633c44){_0x30fd0c=_0x633c44;_0x71d415=0xc8;}else{_0x71d415=0xce;}_0xd23310[_0xa97d('0x19')](_0x71d415);return _0xd23310[_0xa97d('0x1f')]('Content-Range',_0x393229+'-'+_0x30fd0c+'/'+_0x633c44)[_0xa97d('0x1a')](_0x185e62);}return null;};}function patchUpdates(_0x3d3db9){return function(_0x1ac9d7){try{jsonpatch[_0xa97d('0x20')](_0x1ac9d7,_0x3d3db9,!![]);}catch(_0x1504da){return BPromise[_0xa97d('0x21')](_0x1504da);}return _0x1ac9d7[_0xa97d('0x22')]();};}function saveUpdates(_0x296dba,_0x3cf96f){return function(_0x24970f){if(_0x24970f){return _0x24970f[_0xa97d('0x23')](_0x296dba)[_0xa97d('0x24')](function(_0x347811){return _0x347811;});}return null;};}function removeEntity(_0x26b9eb,_0x70c127){return function(_0x563e42){if(_0x563e42){return _0x563e42[_0xa97d('0x25')]()[_0xa97d('0x24')](function(){_0x26b9eb[_0xa97d('0x19')](0xcc)['end']();});}};}function handleEntityNotFound(_0x1c44aa,_0x4e2cb4){return function(_0x37a495){if(!_0x37a495){_0x1c44aa[_0xa97d('0x18')](0x194);}return _0x37a495;};}function handleError(_0x5ea432,_0x4d9cce){_0x4d9cce=_0x4d9cce||0x1f4;return function(_0x481160){logger[_0xa97d('0x26')](_0x481160[_0xa97d('0x27')]);if(_0x481160['name']){delete _0x481160[_0xa97d('0x28')];}_0x5ea432['status'](_0x4d9cce)[_0xa97d('0x29')](_0x481160);};}exports[_0xa97d('0x2a')]=function(_0x38ffcf,_0x4d84e6){var _0x40a120={},_0x49d67b={},_0xac5f0e={'count':0x0,'rows':[]};var _0x351a98=_[_0xa97d('0x2b')](db[_0xa97d('0x2c')]['rawAttributes'],function(_0x17e483){return{'name':_0x17e483['fieldName'],'type':_0x17e483[_0xa97d('0x2d')]['key']};});_0x49d67b[_0xa97d('0x2e')]=_[_0xa97d('0x2b')](_0x351a98,_0xa97d('0x28'));_0x49d67b[_0xa97d('0x2f')]=_[_0xa97d('0x30')](_0x38ffcf['query']);_0x49d67b[_0xa97d('0x31')]=_['intersection'](_0x49d67b[_0xa97d('0x2e')],_0x49d67b['query']);_0x40a120[_0xa97d('0x32')]=_[_0xa97d('0x33')](_0x49d67b['model'],qs[_0xa97d('0x34')](_0x38ffcf[_0xa97d('0x2f')][_0xa97d('0x34')]));_0x40a120[_0xa97d('0x32')]=_0x40a120['attributes'][_0xa97d('0x35')]?_0x40a120['attributes']:_0x49d67b[_0xa97d('0x2e')];if(!_0x38ffcf[_0xa97d('0x2f')][_0xa97d('0x36')]('nolimit')){_0x40a120[_0xa97d('0x1e')]=qs[_0xa97d('0x1e')](_0x38ffcf[_0xa97d('0x2f')][_0xa97d('0x1e')]);_0x40a120[_0xa97d('0x1b')]=qs[_0xa97d('0x1b')](_0x38ffcf['query']['offset']);}_0x40a120[_0xa97d('0x37')]=qs['sort'](_0x38ffcf['query'][_0xa97d('0x38')]);_0x40a120[_0xa97d('0x39')]=qs[_0xa97d('0x31')](_[_0xa97d('0x3a')](_0x38ffcf[_0xa97d('0x2f')],_0x49d67b[_0xa97d('0x31')]),_0x351a98);if(_0x38ffcf['query'][_0xa97d('0x3b')]){_0x40a120['where']=_['merge'](_0x40a120[_0xa97d('0x39')],{'$or':_['map'](_0x351a98,function(_0x2b3241){if(_0x2b3241['type']!=='VIRTUAL'){var _0x371de7={};_0x371de7[_0x2b3241[_0xa97d('0x28')]]={'$like':'%'+_0x38ffcf['query'][_0xa97d('0x3b')]+'%'};return _0x371de7;}})});}_0x40a120=_[_0xa97d('0x3c')]({},_0x40a120,_0x38ffcf['options']);var _0x447495={'where':_0x40a120['where']};return db[_0xa97d('0x2c')][_0xa97d('0x1d')](_0x447495)[_0xa97d('0x24')](function(_0x533973){_0xac5f0e[_0xa97d('0x1d')]=_0x533973;if(_0x38ffcf['query'][_0xa97d('0x3d')]){_0x40a120[_0xa97d('0x3e')]=[{'all':!![]}];}return db[_0xa97d('0x2c')]['findAll'](_0x40a120);})[_0xa97d('0x24')](function(_0x23ef4c){_0xac5f0e[_0xa97d('0x3f')]=_0x23ef4c;return _0xac5f0e;})['then'](respondWithFilteredResult(_0x4d84e6,_0x40a120))[_0xa97d('0x40')](handleError(_0x4d84e6,null));};exports[_0xa97d('0x41')]=function(_0x175969,_0x3666ce){var _0x56afea={'raw':![],'where':{'id':_0x175969[_0xa97d('0x42')]['id']}},_0x3c7497={};_0x3c7497[_0xa97d('0x2e')]=_[_0xa97d('0x30')](db[_0xa97d('0x2c')][_0xa97d('0x43')]);_0x3c7497['query']=_[_0xa97d('0x30')](_0x175969['query']);_0x3c7497['filters']=_['intersection'](_0x3c7497[_0xa97d('0x2e')],_0x3c7497[_0xa97d('0x2f')]);_0x56afea['attributes']=_[_0xa97d('0x33')](_0x3c7497[_0xa97d('0x2e')],qs['fields'](_0x175969[_0xa97d('0x2f')]['fields']));_0x56afea[_0xa97d('0x32')]=_0x56afea[_0xa97d('0x32')][_0xa97d('0x35')]?_0x56afea[_0xa97d('0x32')]:_0x3c7497[_0xa97d('0x2e')];if(_0x175969[_0xa97d('0x2f')][_0xa97d('0x3d')]){_0x56afea['include']=[{'all':!![]}];}_0x56afea=_[_0xa97d('0x3c')]({},_0x56afea,_0x175969[_0xa97d('0x44')]);return db[_0xa97d('0x2c')][_0xa97d('0x45')](_0x56afea)[_0xa97d('0x24')](handleEntityNotFound(_0x3666ce,null))[_0xa97d('0x24')](respondWithResult(_0x3666ce,null))[_0xa97d('0x40')](handleError(_0x3666ce,null));};exports[_0xa97d('0x46')]=function(_0x22c410,_0x4365d1){return db[_0xa97d('0x2c')][_0xa97d('0x46')](_0x22c410['body'],{})[_0xa97d('0x24')](respondWithResult(_0x4365d1,0xc9))['catch'](handleError(_0x4365d1,null));};exports[_0xa97d('0x23')]=function(_0xbed933,_0x1e8240){if(_0xbed933[_0xa97d('0x47')]['id']){delete _0xbed933['body']['id'];}return db['VtigerConfiguration']['find']({'where':{'id':_0xbed933['params']['id']}})['then'](handleEntityNotFound(_0x1e8240,null))[_0xa97d('0x24')](saveUpdates(_0xbed933[_0xa97d('0x47')],null))[_0xa97d('0x24')](respondWithResult(_0x1e8240,null))[_0xa97d('0x40')](handleError(_0x1e8240,null));};exports[_0xa97d('0x25')]=function(_0x4770f0,_0x4abe97){return db['VtigerConfiguration']['find']({'where':{'id':_0x4770f0[_0xa97d('0x42')]['id']}})[_0xa97d('0x24')](handleEntityNotFound(_0x4abe97,null))[_0xa97d('0x24')](removeEntity(_0x4abe97,null))[_0xa97d('0x40')](handleError(_0x4abe97,null));};exports[_0xa97d('0x48')]=function(_0x521f88,_0x334d89,_0x5f5cc7){var _0x2487ec={};var _0x5a060f={};var _0x4852b9;var _0xf506a2;return db[_0xa97d('0x2c')]['findOne']({'where':{'id':_0x521f88[_0xa97d('0x42')]['id']}})[_0xa97d('0x24')](handleEntityNotFound(_0x334d89,null))['then'](function(_0x164a92){if(_0x164a92){_0x4852b9=_0x164a92;_0x5a060f[_0xa97d('0x2e')]=_[_0xa97d('0x30')](db[_0xa97d('0x49')]['rawAttributes']);_0x5a060f[_0xa97d('0x2f')]=_[_0xa97d('0x30')](_0x521f88[_0xa97d('0x2f')]);_0x5a060f[_0xa97d('0x31')]=_[_0xa97d('0x33')](_0x5a060f[_0xa97d('0x2e')],_0x5a060f[_0xa97d('0x2f')]);_0x2487ec[_0xa97d('0x32')]=_[_0xa97d('0x33')](_0x5a060f['model'],qs[_0xa97d('0x34')](_0x521f88['query'][_0xa97d('0x34')]));_0x2487ec[_0xa97d('0x32')]=_0x2487ec[_0xa97d('0x32')][_0xa97d('0x35')]?_0x2487ec['attributes']:_0x5a060f[_0xa97d('0x2e')];_0x2487ec[_0xa97d('0x37')]=qs[_0xa97d('0x38')](_0x521f88[_0xa97d('0x2f')][_0xa97d('0x38')]);_0x2487ec[_0xa97d('0x39')]=qs[_0xa97d('0x31')](_[_0xa97d('0x3a')](_0x521f88[_0xa97d('0x2f')],_0x5a060f[_0xa97d('0x31')]));if(_0x521f88[_0xa97d('0x2f')][_0xa97d('0x3b')]){_0x2487ec[_0xa97d('0x39')]=_[_0xa97d('0x3c')](_0x2487ec[_0xa97d('0x39')],{'$or':_[_0xa97d('0x2b')](_0x2487ec[_0xa97d('0x32')],function(_0x35d928){var _0x26ed2a={};_0x26ed2a[_0x35d928]={'$like':'%'+_0x521f88[_0xa97d('0x2f')]['filter']+'%'};return _0x26ed2a;})});}_0x2487ec=_[_0xa97d('0x3c')]({},_0x2487ec,_0x521f88[_0xa97d('0x44')]);return _0x4852b9[_0xa97d('0x48')](_0x2487ec);}})[_0xa97d('0x24')](function(_0xbeb690){if(_0xbeb690){_0xf506a2=_0xbeb690[_0xa97d('0x35')];if(!_0x521f88[_0xa97d('0x2f')]['hasOwnProperty'](_0xa97d('0x4a'))){_0x2487ec[_0xa97d('0x1e')]=qs[_0xa97d('0x1e')](_0x521f88['query'][_0xa97d('0x1e')]);_0x2487ec[_0xa97d('0x1b')]=qs['offset'](_0x521f88[_0xa97d('0x2f')]['offset']);}return _0x4852b9[_0xa97d('0x48')](_0x2487ec);}})[_0xa97d('0x24')](function(_0x5f0827){if(_0x5f0827){return _0x5f0827?{'count':_0xf506a2,'rows':_0x5f0827}:null;}})['then'](respondWithResult(_0x334d89,null))[_0xa97d('0x40')](handleError(_0x334d89,null));};exports[_0xa97d('0x4b')]=function(_0x32874a,_0x20481d,_0x5ad03a){var _0x36f968={};var _0x352356={};var _0x5ce470;var _0x50dfbd;return db['VtigerConfiguration'][_0xa97d('0x4c')]({'where':{'id':_0x32874a[_0xa97d('0x42')]['id']}})['then'](handleEntityNotFound(_0x20481d,null))['then'](function(_0x514c1f){if(_0x514c1f){_0x5ce470=_0x514c1f;_0x352356[_0xa97d('0x2e')]=_[_0xa97d('0x30')](db[_0xa97d('0x49')][_0xa97d('0x43')]);_0x352356[_0xa97d('0x2f')]=_[_0xa97d('0x30')](_0x32874a[_0xa97d('0x2f')]);_0x352356[_0xa97d('0x31')]=_[_0xa97d('0x33')](_0x352356[_0xa97d('0x2e')],_0x352356[_0xa97d('0x2f')]);_0x36f968[_0xa97d('0x32')]=_[_0xa97d('0x33')](_0x352356[_0xa97d('0x2e')],qs[_0xa97d('0x34')](_0x32874a[_0xa97d('0x2f')][_0xa97d('0x34')]));_0x36f968[_0xa97d('0x32')]=_0x36f968[_0xa97d('0x32')][_0xa97d('0x35')]?_0x36f968[_0xa97d('0x32')]:_0x352356[_0xa97d('0x2e')];_0x36f968['order']=qs[_0xa97d('0x38')](_0x32874a['query'][_0xa97d('0x38')]);_0x36f968[_0xa97d('0x39')]=qs[_0xa97d('0x31')](_[_0xa97d('0x3a')](_0x32874a['query'],_0x352356['filters']));if(_0x32874a['query']['filter']){_0x36f968[_0xa97d('0x39')]=_[_0xa97d('0x3c')](_0x36f968[_0xa97d('0x39')],{'$or':_[_0xa97d('0x2b')](_0x36f968[_0xa97d('0x32')],function(_0x497ccd){var _0x52eea5={};_0x52eea5[_0x497ccd]={'$like':'%'+_0x32874a[_0xa97d('0x2f')][_0xa97d('0x3b')]+'%'};return _0x52eea5;})});}_0x36f968=_[_0xa97d('0x3c')]({},_0x36f968,_0x32874a[_0xa97d('0x44')]);return _0x5ce470['getSubjects'](_0x36f968);}})[_0xa97d('0x24')](function(_0x5228a0){if(_0x5228a0){_0x50dfbd=_0x5228a0['length'];if(!_0x32874a['query']['hasOwnProperty'](_0xa97d('0x4a'))){_0x36f968['limit']=qs[_0xa97d('0x1e')](_0x32874a[_0xa97d('0x2f')][_0xa97d('0x1e')]);_0x36f968[_0xa97d('0x1b')]=qs[_0xa97d('0x1b')](_0x32874a[_0xa97d('0x2f')][_0xa97d('0x1b')]);}return _0x5ce470['getSubjects'](_0x36f968);}})[_0xa97d('0x24')](function(_0x5d4283){if(_0x5d4283){return _0x5d4283?{'count':_0x50dfbd,'rows':_0x5d4283}:null;}})[_0xa97d('0x24')](respondWithResult(_0x20481d,null))[_0xa97d('0x40')](handleError(_0x20481d,null));};exports[_0xa97d('0x4d')]=function(_0x1b7a68,_0x1c55d2,_0x116061){var _0x21942c={};var _0x4de9c9={};var _0x176981;var _0xcca783;return db['VtigerConfiguration'][_0xa97d('0x4c')]({'where':{'id':_0x1b7a68['params']['id']}})['then'](handleEntityNotFound(_0x1c55d2,null))[_0xa97d('0x24')](function(_0x29f369){if(_0x29f369){_0x176981=_0x29f369;_0x4de9c9[_0xa97d('0x2e')]=_[_0xa97d('0x30')](db[_0xa97d('0x49')][_0xa97d('0x43')]);_0x4de9c9[_0xa97d('0x2f')]=_[_0xa97d('0x30')](_0x1b7a68[_0xa97d('0x2f')]);_0x4de9c9[_0xa97d('0x31')]=_[_0xa97d('0x33')](_0x4de9c9[_0xa97d('0x2e')],_0x4de9c9[_0xa97d('0x2f')]);_0x21942c[_0xa97d('0x32')]=_[_0xa97d('0x33')](_0x4de9c9[_0xa97d('0x2e')],qs[_0xa97d('0x34')](_0x1b7a68['query'][_0xa97d('0x34')]));_0x21942c['attributes']=_0x21942c[_0xa97d('0x32')]['length']?_0x21942c['attributes']:_0x4de9c9[_0xa97d('0x2e')];_0x21942c[_0xa97d('0x37')]=qs[_0xa97d('0x38')](_0x1b7a68['query'][_0xa97d('0x38')]);_0x21942c[_0xa97d('0x39')]=qs['filters'](_[_0xa97d('0x3a')](_0x1b7a68[_0xa97d('0x2f')],_0x4de9c9['filters']));if(_0x1b7a68[_0xa97d('0x2f')][_0xa97d('0x3b')]){_0x21942c['where']=_[_0xa97d('0x3c')](_0x21942c[_0xa97d('0x39')],{'$or':_[_0xa97d('0x2b')](_0x21942c[_0xa97d('0x32')],function(_0x2f7fbf){var _0x21fbdc={};_0x21fbdc[_0x2f7fbf]={'$like':'%'+_0x1b7a68['query'][_0xa97d('0x3b')]+'%'};return _0x21fbdc;})});}_0x21942c=_['merge']({},_0x21942c,_0x1b7a68['options']);return _0x176981[_0xa97d('0x4d')](_0x21942c);}})[_0xa97d('0x24')](function(_0x25ab01){if(_0x25ab01){_0xcca783=_0x25ab01[_0xa97d('0x35')];if(!_0x1b7a68[_0xa97d('0x2f')][_0xa97d('0x36')](_0xa97d('0x4a'))){_0x21942c[_0xa97d('0x1e')]=qs[_0xa97d('0x1e')](_0x1b7a68[_0xa97d('0x2f')]['limit']);_0x21942c[_0xa97d('0x1b')]=qs[_0xa97d('0x1b')](_0x1b7a68[_0xa97d('0x2f')][_0xa97d('0x1b')]);}return _0x176981[_0xa97d('0x4d')](_0x21942c);}})[_0xa97d('0x24')](function(_0x54ceac){if(_0x54ceac){return _0x54ceac?{'count':_0xcca783,'rows':_0x54ceac}:null;}})[_0xa97d('0x24')](respondWithResult(_0x1c55d2,null))[_0xa97d('0x40')](handleError(_0x1c55d2,null));};