Built motion from commit 9d1906d1.|2.5.40
[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 _0xdba8=['desk.js','querystring','papaparse','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','update','then','destroy','error','stack','name','send','index','map','VtigerConfiguration','rawAttributes','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','sort','where','pick','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','show','params','find','catch','create','body','getFields','findOne','VtigerField','order','getSubjects','getDescriptions','eml-format','rimraf','zip-dir','moment','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto'];(function(_0x55f817,_0x1dce34){var _0x316b1b=function(_0x32a4ee){while(--_0x32a4ee){_0x55f817['push'](_0x55f817['shift']());}};_0x316b1b(++_0x1dce34);}(_0xdba8,0x179));var _0x8dba=function(_0x5aa159,_0x4c7c46){_0x5aa159=_0x5aa159-0x0;var _0x1e6131=_0xdba8[_0x5aa159];return _0x1e6131;};'use strict';var emlformat=require(_0x8dba('0x0'));var rimraf=require(_0x8dba('0x1'));var zipdir=require(_0x8dba('0x2'));var jsonpatch=require('fast-json-patch');var rp=require('request-promise');var moment=require(_0x8dba('0x3'));var BPromise=require('bluebird');var Mustache=require(_0x8dba('0x4'));var util=require(_0x8dba('0x5'));var path=require('path');var sox=require(_0x8dba('0x6'));var csv=require(_0x8dba('0x7'));var ejs=require(_0x8dba('0x8'));var fs=require('fs');var fs_extra=require(_0x8dba('0x9'));var _=require(_0x8dba('0xa'));var squel=require(_0x8dba('0xb'));var crypto=require(_0x8dba('0xc'));var jsforce=require('jsforce');var deskjs=require(_0x8dba('0xd'));var toCsv=require('to-csv');var querystring=require(_0x8dba('0xe'));var Papa=require(_0x8dba('0xf'));var Redis=require('ioredis');var authService=require(_0x8dba('0x10'));var qs=require(_0x8dba('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x8dba('0x12'));var logger=require('../../config/logger')(_0x8dba('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var licenseUtil=require(_0x8dba('0x14'));var db=require(_0x8dba('0x15'))['db'];function respondWithStatusCode(_0x49a991,_0x27606a){_0x27606a=_0x27606a||0xcc;return function(_0x49e947){if(_0x49e947){return _0x49a991[_0x8dba('0x16')](_0x27606a);}return _0x49a991[_0x8dba('0x17')](_0x27606a)[_0x8dba('0x18')]();};}function respondWithResult(_0x5d630d,_0x1dbfd3){_0x1dbfd3=_0x1dbfd3||0xc8;return function(_0x447beb){if(_0x447beb){return _0x5d630d['status'](_0x1dbfd3)[_0x8dba('0x19')](_0x447beb);}};}function respondWithFilteredResult(_0x4625f2,_0x121f07){return function(_0x4ad556){if(_0x4ad556){var _0x3ceaff=typeof _0x121f07[_0x8dba('0x1a')]===_0x8dba('0x1b')&&typeof _0x121f07[_0x8dba('0x1c')]===_0x8dba('0x1b');var _0xeecd9b=_0x4ad556[_0x8dba('0x1d')];var _0x58f09f=_0x3ceaff?0x0:_0x121f07[_0x8dba('0x1a')];var _0x31fb81=_0x3ceaff?_0x4ad556['count']:_0x121f07[_0x8dba('0x1a')]+_0x121f07[_0x8dba('0x1c')];var _0x2a38aa;if(_0x31fb81>=_0xeecd9b){_0x31fb81=_0xeecd9b;_0x2a38aa=0xc8;}else{_0x2a38aa=0xce;}_0x4625f2[_0x8dba('0x17')](_0x2a38aa);return _0x4625f2[_0x8dba('0x1e')](_0x8dba('0x1f'),_0x58f09f+'-'+_0x31fb81+'/'+_0xeecd9b)[_0x8dba('0x19')](_0x4ad556);}return null;};}function patchUpdates(_0x37f1f1){return function(_0x1c431f){try{jsonpatch['apply'](_0x1c431f,_0x37f1f1,!![]);}catch(_0xc098db){return BPromise['reject'](_0xc098db);}return _0x1c431f['save']();};}function saveUpdates(_0x4e864d,_0x5e27cc){return function(_0x13d737){if(_0x13d737){return _0x13d737[_0x8dba('0x20')](_0x4e864d)[_0x8dba('0x21')](function(_0xc33041){return _0xc33041;});}return null;};}function removeEntity(_0x139c1e,_0x1b6bd9){return function(_0x11a50e){if(_0x11a50e){return _0x11a50e[_0x8dba('0x22')]()['then'](function(){_0x139c1e[_0x8dba('0x17')](0xcc)['end']();});}};}function handleEntityNotFound(_0x3bb3d2,_0x5ba65e){return function(_0x1156c6){if(!_0x1156c6){_0x3bb3d2[_0x8dba('0x16')](0x194);}return _0x1156c6;};}function handleError(_0x5630a1,_0x55438e){_0x55438e=_0x55438e||0x1f4;return function(_0x122410){logger[_0x8dba('0x23')](_0x122410[_0x8dba('0x24')]);if(_0x122410[_0x8dba('0x25')]){delete _0x122410[_0x8dba('0x25')];}_0x5630a1[_0x8dba('0x17')](_0x55438e)[_0x8dba('0x26')](_0x122410);};}exports[_0x8dba('0x27')]=function(_0x357290,_0x409210){var _0x4fb611={},_0x5e1a4f={},_0x561dfb={'count':0x0,'rows':[]};var _0x5ed773=_[_0x8dba('0x28')](db[_0x8dba('0x29')][_0x8dba('0x2a')],function(_0xecf97e){return{'name':_0xecf97e['fieldName'],'type':_0xecf97e[_0x8dba('0x2b')][_0x8dba('0x2c')]};});_0x5e1a4f[_0x8dba('0x2d')]=_[_0x8dba('0x28')](_0x5ed773,_0x8dba('0x25'));_0x5e1a4f[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x357290[_0x8dba('0x2e')]);_0x5e1a4f[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x5e1a4f[_0x8dba('0x2d')],_0x5e1a4f[_0x8dba('0x2e')]);_0x4fb611[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x5e1a4f[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x4fb611[_0x8dba('0x32')]=_0x4fb611['attributes'][_0x8dba('0x34')]?_0x4fb611[_0x8dba('0x32')]:_0x5e1a4f[_0x8dba('0x2d')];if(!_0x357290['query'][_0x8dba('0x35')](_0x8dba('0x36'))){_0x4fb611['limit']=qs[_0x8dba('0x1c')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x1c')]);_0x4fb611[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x357290[_0x8dba('0x2e')][_0x8dba('0x1a')]);}_0x4fb611['order']=qs['sort'](_0x357290['query'][_0x8dba('0x37')]);_0x4fb611[_0x8dba('0x38')]=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x357290['query'],_0x5e1a4f[_0x8dba('0x30')]),_0x5ed773);if(_0x357290[_0x8dba('0x2e')]['filter']){_0x4fb611[_0x8dba('0x38')]=_[_0x8dba('0x3a')](_0x4fb611['where'],{'$or':_['map'](_0x5ed773,function(_0x328f25){if(_0x328f25[_0x8dba('0x2b')]!==_0x8dba('0x3b')){var _0x4827dc={};_0x4827dc[_0x328f25['name']]={'$like':'%'+_0x357290[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x4827dc;}})});}_0x4fb611=_[_0x8dba('0x3a')]({},_0x4fb611,_0x357290[_0x8dba('0x3d')]);var _0x5427bb={'where':_0x4fb611['where']};return db['VtigerConfiguration']['count'](_0x5427bb)[_0x8dba('0x21')](function(_0x5548ea){_0x561dfb['count']=_0x5548ea;if(_0x357290[_0x8dba('0x2e')][_0x8dba('0x3e')]){_0x4fb611[_0x8dba('0x3f')]=[{'all':!![]}];}return db['VtigerConfiguration'][_0x8dba('0x40')](_0x4fb611);})['then'](function(_0x140f87){_0x561dfb[_0x8dba('0x41')]=_0x140f87;return _0x561dfb;})[_0x8dba('0x21')](respondWithFilteredResult(_0x409210,_0x4fb611))['catch'](handleError(_0x409210,null));};exports[_0x8dba('0x42')]=function(_0x5ef390,_0x23e72d){var _0x95eaa={'raw':![],'where':{'id':_0x5ef390[_0x8dba('0x43')]['id']}},_0x6d3d87={};_0x6d3d87[_0x8dba('0x2d')]=_['keys'](db[_0x8dba('0x29')][_0x8dba('0x2a')]);_0x6d3d87[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x5ef390[_0x8dba('0x2e')]);_0x6d3d87[_0x8dba('0x30')]=_['intersection'](_0x6d3d87[_0x8dba('0x2d')],_0x6d3d87[_0x8dba('0x2e')]);_0x95eaa[_0x8dba('0x32')]=_['intersection'](_0x6d3d87[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x5ef390[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x95eaa[_0x8dba('0x32')]=_0x95eaa[_0x8dba('0x32')][_0x8dba('0x34')]?_0x95eaa['attributes']:_0x6d3d87[_0x8dba('0x2d')];if(_0x5ef390['query'][_0x8dba('0x3e')]){_0x95eaa[_0x8dba('0x3f')]=[{'all':!![]}];}_0x95eaa=_['merge']({},_0x95eaa,_0x5ef390['options']);return db[_0x8dba('0x29')][_0x8dba('0x44')](_0x95eaa)['then'](handleEntityNotFound(_0x23e72d,null))['then'](respondWithResult(_0x23e72d,null))[_0x8dba('0x45')](handleError(_0x23e72d,null));};exports[_0x8dba('0x46')]=function(_0x55701d,_0x3605e3){return db[_0x8dba('0x29')][_0x8dba('0x46')](_0x55701d['body'],{})[_0x8dba('0x21')](respondWithResult(_0x3605e3,0xc9))[_0x8dba('0x45')](handleError(_0x3605e3,null));};exports['update']=function(_0x265d99,_0x3b44b9){if(_0x265d99[_0x8dba('0x47')]['id']){delete _0x265d99['body']['id'];}return db[_0x8dba('0x29')][_0x8dba('0x44')]({'where':{'id':_0x265d99['params']['id']}})['then'](handleEntityNotFound(_0x3b44b9,null))[_0x8dba('0x21')](saveUpdates(_0x265d99[_0x8dba('0x47')],null))[_0x8dba('0x21')](respondWithResult(_0x3b44b9,null))[_0x8dba('0x45')](handleError(_0x3b44b9,null));};exports[_0x8dba('0x22')]=function(_0x3dda23,_0x7324e4){return db['VtigerConfiguration'][_0x8dba('0x44')]({'where':{'id':_0x3dda23[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x7324e4,null))['then'](removeEntity(_0x7324e4,null))['catch'](handleError(_0x7324e4,null));};exports[_0x8dba('0x48')]=function(_0x2c4915,_0x43c282,_0x2bb848){var _0x2cd506={};var _0x44dac8={};var _0x21c4b9;var _0x2900a6;return db[_0x8dba('0x29')][_0x8dba('0x49')]({'where':{'id':_0x2c4915[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x43c282,null))[_0x8dba('0x21')](function(_0x411dd6){if(_0x411dd6){_0x21c4b9=_0x411dd6;_0x44dac8[_0x8dba('0x2d')]=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')][_0x8dba('0x2a')]);_0x44dac8[_0x8dba('0x2e')]=_[_0x8dba('0x2f')](_0x2c4915[_0x8dba('0x2e')]);_0x44dac8['filters']=_[_0x8dba('0x31')](_0x44dac8[_0x8dba('0x2d')],_0x44dac8['query']);_0x2cd506[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x44dac8[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x33')]));_0x2cd506[_0x8dba('0x32')]=_0x2cd506['attributes'][_0x8dba('0x34')]?_0x2cd506[_0x8dba('0x32')]:_0x44dac8['model'];_0x2cd506[_0x8dba('0x4b')]=qs['sort'](_0x2c4915[_0x8dba('0x2e')]['sort']);_0x2cd506['where']=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x2c4915['query'],_0x44dac8[_0x8dba('0x30')]));if(_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x3c')]){_0x2cd506[_0x8dba('0x38')]=_[_0x8dba('0x3a')](_0x2cd506['where'],{'$or':_[_0x8dba('0x28')](_0x2cd506['attributes'],function(_0x6c6c7e){var _0x24c5f1={};_0x24c5f1[_0x6c6c7e]={'$like':'%'+_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x24c5f1;})});}_0x2cd506=_[_0x8dba('0x3a')]({},_0x2cd506,_0x2c4915[_0x8dba('0x3d')]);return _0x21c4b9[_0x8dba('0x48')](_0x2cd506);}})[_0x8dba('0x21')](function(_0x4fe516){if(_0x4fe516){_0x2900a6=_0x4fe516[_0x8dba('0x34')];if(!_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x35')](_0x8dba('0x36'))){_0x2cd506['limit']=qs[_0x8dba('0x1c')](_0x2c4915[_0x8dba('0x2e')][_0x8dba('0x1c')]);_0x2cd506['offset']=qs[_0x8dba('0x1a')](_0x2c4915['query'][_0x8dba('0x1a')]);}return _0x21c4b9[_0x8dba('0x48')](_0x2cd506);}})['then'](function(_0x489218){if(_0x489218){return _0x489218?{'count':_0x2900a6,'rows':_0x489218}:null;}})[_0x8dba('0x21')](respondWithResult(_0x43c282,null))[_0x8dba('0x45')](handleError(_0x43c282,null));};exports['getSubjects']=function(_0x541b1e,_0x1edf1e,_0x38c7ea){var _0x5eb6df={};var _0x4bae23={};var _0x4afb20;var _0x52bc7f;return db[_0x8dba('0x29')][_0x8dba('0x49')]({'where':{'id':_0x541b1e[_0x8dba('0x43')]['id']}})['then'](handleEntityNotFound(_0x1edf1e,null))[_0x8dba('0x21')](function(_0x3c4767){if(_0x3c4767){_0x4afb20=_0x3c4767;_0x4bae23['model']=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')]['rawAttributes']);_0x4bae23['query']=_[_0x8dba('0x2f')](_0x541b1e[_0x8dba('0x2e')]);_0x4bae23[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x4bae23[_0x8dba('0x2d')],_0x4bae23[_0x8dba('0x2e')]);_0x5eb6df[_0x8dba('0x32')]=_[_0x8dba('0x31')](_0x4bae23[_0x8dba('0x2d')],qs[_0x8dba('0x33')](_0x541b1e['query'][_0x8dba('0x33')]));_0x5eb6df['attributes']=_0x5eb6df[_0x8dba('0x32')][_0x8dba('0x34')]?_0x5eb6df[_0x8dba('0x32')]:_0x4bae23['model'];_0x5eb6df[_0x8dba('0x4b')]=qs[_0x8dba('0x37')](_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x37')]);_0x5eb6df[_0x8dba('0x38')]=qs[_0x8dba('0x30')](_[_0x8dba('0x39')](_0x541b1e[_0x8dba('0x2e')],_0x4bae23[_0x8dba('0x30')]));if(_0x541b1e['query'][_0x8dba('0x3c')]){_0x5eb6df['where']=_['merge'](_0x5eb6df[_0x8dba('0x38')],{'$or':_[_0x8dba('0x28')](_0x5eb6df[_0x8dba('0x32')],function(_0x35086f){var _0x100dfd={};_0x100dfd[_0x35086f]={'$like':'%'+_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x3c')]+'%'};return _0x100dfd;})});}_0x5eb6df=_[_0x8dba('0x3a')]({},_0x5eb6df,_0x541b1e[_0x8dba('0x3d')]);return _0x4afb20['getSubjects'](_0x5eb6df);}})[_0x8dba('0x21')](function(_0xa3b078){if(_0xa3b078){_0x52bc7f=_0xa3b078[_0x8dba('0x34')];if(!_0x541b1e[_0x8dba('0x2e')][_0x8dba('0x35')]('nolimit')){_0x5eb6df[_0x8dba('0x1c')]=qs[_0x8dba('0x1c')](_0x541b1e[_0x8dba('0x2e')]['limit']);_0x5eb6df[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x541b1e[_0x8dba('0x2e')]['offset']);}return _0x4afb20[_0x8dba('0x4c')](_0x5eb6df);}})[_0x8dba('0x21')](function(_0x5dfa1c){if(_0x5dfa1c){return _0x5dfa1c?{'count':_0x52bc7f,'rows':_0x5dfa1c}:null;}})[_0x8dba('0x21')](respondWithResult(_0x1edf1e,null))[_0x8dba('0x45')](handleError(_0x1edf1e,null));};exports[_0x8dba('0x4d')]=function(_0x58d207,_0x25c236,_0x29b2c1){var _0xb8de00={};var _0x35fda9={};var _0x3569d3;var _0x5adb8a;return db[_0x8dba('0x29')]['findOne']({'where':{'id':_0x58d207[_0x8dba('0x43')]['id']}})[_0x8dba('0x21')](handleEntityNotFound(_0x25c236,null))[_0x8dba('0x21')](function(_0x40d507){if(_0x40d507){_0x3569d3=_0x40d507;_0x35fda9[_0x8dba('0x2d')]=_[_0x8dba('0x2f')](db[_0x8dba('0x4a')]['rawAttributes']);_0x35fda9[_0x8dba('0x2e')]=_['keys'](_0x58d207[_0x8dba('0x2e')]);_0x35fda9[_0x8dba('0x30')]=_[_0x8dba('0x31')](_0x35fda9[_0x8dba('0x2d')],_0x35fda9[_0x8dba('0x2e')]);_0xb8de00[_0x8dba('0x32')]=_['intersection'](_0x35fda9['model'],qs['fields'](_0x58d207[_0x8dba('0x2e')][_0x8dba('0x33')]));_0xb8de00['attributes']=_0xb8de00[_0x8dba('0x32')][_0x8dba('0x34')]?_0xb8de00[_0x8dba('0x32')]:_0x35fda9[_0x8dba('0x2d')];_0xb8de00['order']=qs[_0x8dba('0x37')](_0x58d207[_0x8dba('0x2e')]['sort']);_0xb8de00['where']=qs['filters'](_[_0x8dba('0x39')](_0x58d207['query'],_0x35fda9[_0x8dba('0x30')]));if(_0x58d207[_0x8dba('0x2e')][_0x8dba('0x3c')]){_0xb8de00[_0x8dba('0x38')]=_['merge'](_0xb8de00[_0x8dba('0x38')],{'$or':_[_0x8dba('0x28')](_0xb8de00[_0x8dba('0x32')],function(_0x6e1cff){var _0x2d4ff2={};_0x2d4ff2[_0x6e1cff]={'$like':'%'+_0x58d207['query'][_0x8dba('0x3c')]+'%'};return _0x2d4ff2;})});}_0xb8de00=_[_0x8dba('0x3a')]({},_0xb8de00,_0x58d207['options']);return _0x3569d3['getDescriptions'](_0xb8de00);}})[_0x8dba('0x21')](function(_0x4ebc18){if(_0x4ebc18){_0x5adb8a=_0x4ebc18[_0x8dba('0x34')];if(!_0x58d207[_0x8dba('0x2e')][_0x8dba('0x35')](_0x8dba('0x36'))){_0xb8de00['limit']=qs['limit'](_0x58d207['query'][_0x8dba('0x1c')]);_0xb8de00[_0x8dba('0x1a')]=qs[_0x8dba('0x1a')](_0x58d207[_0x8dba('0x2e')][_0x8dba('0x1a')]);}return _0x3569d3[_0x8dba('0x4d')](_0xb8de00);}})['then'](function(_0x240355){if(_0x240355){return _0x240355?{'count':_0x5adb8a,'rows':_0x240355}:null;}})[_0x8dba('0x21')](respondWithResult(_0x25c236,null))[_0x8dba('0x45')](handleError(_0x25c236,null));};