Built motion from commit 19a84241.|2.5.34
[motion2.git] / server / api / intZohoConfiguration / intZohoConfiguration.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 _0x116a=['findOne','ZohoField','sort','getSubjects','hasOwnProperty','getDescriptions','eml-format','fast-json-patch','request-promise','bluebird','path','sox','to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','end','status','json','offset','undefined','limit','count','set','Content-Range','apply','save','update','then','destroy','stack','name','send','ZohoConfiguration','type','key','model','map','query','keys','intersection','attributes','fields','length','nolimit','order','filters','pick','merge','where','VIRTUAL','filter','options','includeAll','include','findAll','rows','params','rawAttributes','find','catch','create','body','getFields'];(function(_0x46d1e8,_0x27577e){var _0x10a8cb=function(_0x44803e){while(--_0x44803e){_0x46d1e8['push'](_0x46d1e8['shift']());}};_0x10a8cb(++_0x27577e);}(_0x116a,0xf6));var _0xa116=function(_0x142e01,_0x5922f4){_0x142e01=_0x142e01-0x0;var _0x378ddb=_0x116a[_0x142e01];return _0x378ddb;};'use strict';var emlformat=require(_0xa116('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xa116('0x1'));var rp=require(_0xa116('0x2'));var moment=require('moment');var BPromise=require(_0xa116('0x3'));var Mustache=require('mustache');var util=require('util');var path=require(_0xa116('0x4'));var sox=require(_0xa116('0x5'));var csv=require(_0xa116('0x6'));var ejs=require(_0xa116('0x7'));var fs=require('fs');var fs_extra=require(_0xa116('0x8'));var _=require(_0xa116('0x9'));var squel=require('squel');var crypto=require(_0xa116('0xa'));var jsforce=require(_0xa116('0xb'));var deskjs=require(_0xa116('0xc'));var toCsv=require(_0xa116('0x6'));var querystring=require(_0xa116('0xd'));var Papa=require(_0xa116('0xe'));var Redis=require(_0xa116('0xf'));var authService=require(_0xa116('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0xa116('0x11'));var hardwareService=require(_0xa116('0x12'));var logger=require(_0xa116('0x13'))(_0xa116('0x14'));var utils=require(_0xa116('0x15'));var config=require(_0xa116('0x16'));var licenseUtil=require(_0xa116('0x17'));var db=require(_0xa116('0x18'))['db'];function respondWithStatusCode(_0x257dc4,_0x292f7a){_0x292f7a=_0x292f7a||0xcc;return function(_0x18d93b){if(_0x18d93b){return _0x257dc4[_0xa116('0x19')](_0x292f7a);}return _0x257dc4['status'](_0x292f7a)[_0xa116('0x1a')]();};}function respondWithResult(_0x5cf03b,_0x5ce0e9){_0x5ce0e9=_0x5ce0e9||0xc8;return function(_0x10d599){if(_0x10d599){return _0x5cf03b[_0xa116('0x1b')](_0x5ce0e9)[_0xa116('0x1c')](_0x10d599);}};}function respondWithFilteredResult(_0xdc9f37,_0x3b31e2){return function(_0x332dd6){if(_0x332dd6){var _0x4dbc10=typeof _0x3b31e2[_0xa116('0x1d')]===_0xa116('0x1e')&&typeof _0x3b31e2[_0xa116('0x1f')]===_0xa116('0x1e');var _0x213bed=_0x332dd6[_0xa116('0x20')];var _0x4c560c=_0x4dbc10?0x0:_0x3b31e2[_0xa116('0x1d')];var _0x99ce78=_0x4dbc10?_0x332dd6[_0xa116('0x20')]:_0x3b31e2[_0xa116('0x1d')]+_0x3b31e2['limit'];var _0x1e646c;if(_0x99ce78>=_0x213bed){_0x99ce78=_0x213bed;_0x1e646c=0xc8;}else{_0x1e646c=0xce;}_0xdc9f37[_0xa116('0x1b')](_0x1e646c);return _0xdc9f37[_0xa116('0x21')](_0xa116('0x22'),_0x4c560c+'-'+_0x99ce78+'/'+_0x213bed)[_0xa116('0x1c')](_0x332dd6);}return null;};}function patchUpdates(_0x305f5a){return function(_0x4753be){try{jsonpatch[_0xa116('0x23')](_0x4753be,_0x305f5a,!![]);}catch(_0x585e97){return BPromise['reject'](_0x585e97);}return _0x4753be[_0xa116('0x24')]();};}function saveUpdates(_0x4237e3,_0x566b87){return function(_0x25d03a){if(_0x25d03a){return _0x25d03a[_0xa116('0x25')](_0x4237e3)[_0xa116('0x26')](function(_0x21361e){return _0x21361e;});}return null;};}function removeEntity(_0x256139,_0x32fa4a){return function(_0x323526){if(_0x323526){return _0x323526[_0xa116('0x27')]()[_0xa116('0x26')](function(){_0x256139[_0xa116('0x1b')](0xcc)[_0xa116('0x1a')]();});}};}function handleEntityNotFound(_0x4b353d,_0x553805){return function(_0x2afd04){if(!_0x2afd04){_0x4b353d['sendStatus'](0x194);}return _0x2afd04;};}function handleError(_0x142971,_0x57d4d3){_0x57d4d3=_0x57d4d3||0x1f4;return function(_0x5bc132){logger['error'](_0x5bc132[_0xa116('0x28')]);if(_0x5bc132[_0xa116('0x29')]){delete _0x5bc132[_0xa116('0x29')];}_0x142971[_0xa116('0x1b')](_0x57d4d3)[_0xa116('0x2a')](_0x5bc132);};}exports['index']=function(_0x52ed39,_0x3c2f20){var _0x3c67d0={},_0x5da262={},_0x49eff9={'count':0x0,'rows':[]};var _0x431367=_['map'](db[_0xa116('0x2b')]['rawAttributes'],function(_0x49583a){return{'name':_0x49583a['fieldName'],'type':_0x49583a[_0xa116('0x2c')][_0xa116('0x2d')]};});_0x5da262[_0xa116('0x2e')]=_[_0xa116('0x2f')](_0x431367,_0xa116('0x29'));_0x5da262[_0xa116('0x30')]=_[_0xa116('0x31')](_0x52ed39[_0xa116('0x30')]);_0x5da262['filters']=_[_0xa116('0x32')](_0x5da262[_0xa116('0x2e')],_0x5da262[_0xa116('0x30')]);_0x3c67d0[_0xa116('0x33')]=_['intersection'](_0x5da262[_0xa116('0x2e')],qs[_0xa116('0x34')](_0x52ed39[_0xa116('0x30')][_0xa116('0x34')]));_0x3c67d0[_0xa116('0x33')]=_0x3c67d0[_0xa116('0x33')][_0xa116('0x35')]?_0x3c67d0['attributes']:_0x5da262[_0xa116('0x2e')];if(!_0x52ed39['query']['hasOwnProperty'](_0xa116('0x36'))){_0x3c67d0['limit']=qs[_0xa116('0x1f')](_0x52ed39[_0xa116('0x30')][_0xa116('0x1f')]);_0x3c67d0[_0xa116('0x1d')]=qs['offset'](_0x52ed39['query'][_0xa116('0x1d')]);}_0x3c67d0[_0xa116('0x37')]=qs['sort'](_0x52ed39[_0xa116('0x30')]['sort']);_0x3c67d0['where']=qs[_0xa116('0x38')](_[_0xa116('0x39')](_0x52ed39[_0xa116('0x30')],_0x5da262['filters']),_0x431367);if(_0x52ed39[_0xa116('0x30')]['filter']){_0x3c67d0['where']=_[_0xa116('0x3a')](_0x3c67d0[_0xa116('0x3b')],{'$or':_[_0xa116('0x2f')](_0x431367,function(_0x57d624){if(_0x57d624[_0xa116('0x2c')]!==_0xa116('0x3c')){var _0x40d399={};_0x40d399[_0x57d624[_0xa116('0x29')]]={'$like':'%'+_0x52ed39['query'][_0xa116('0x3d')]+'%'};return _0x40d399;}})});}_0x3c67d0=_[_0xa116('0x3a')]({},_0x3c67d0,_0x52ed39[_0xa116('0x3e')]);var _0x473d74={'where':_0x3c67d0[_0xa116('0x3b')]};return db['ZohoConfiguration'][_0xa116('0x20')](_0x473d74)['then'](function(_0x39c9ed){_0x49eff9[_0xa116('0x20')]=_0x39c9ed;if(_0x52ed39[_0xa116('0x30')][_0xa116('0x3f')]){_0x3c67d0[_0xa116('0x40')]=[{'all':!![]}];}return db[_0xa116('0x2b')][_0xa116('0x41')](_0x3c67d0);})[_0xa116('0x26')](function(_0xe5b5ec){_0x49eff9[_0xa116('0x42')]=_0xe5b5ec;return _0x49eff9;})[_0xa116('0x26')](respondWithFilteredResult(_0x3c2f20,_0x3c67d0))['catch'](handleError(_0x3c2f20,null));};exports['show']=function(_0x3ceaac,_0x3fb8d4){var _0x47a54b={'raw':![],'where':{'id':_0x3ceaac[_0xa116('0x43')]['id']}},_0x118916={};_0x118916['model']=_[_0xa116('0x31')](db[_0xa116('0x2b')][_0xa116('0x44')]);_0x118916[_0xa116('0x30')]=_[_0xa116('0x31')](_0x3ceaac[_0xa116('0x30')]);_0x118916[_0xa116('0x38')]=_[_0xa116('0x32')](_0x118916[_0xa116('0x2e')],_0x118916[_0xa116('0x30')]);_0x47a54b['attributes']=_[_0xa116('0x32')](_0x118916[_0xa116('0x2e')],qs[_0xa116('0x34')](_0x3ceaac[_0xa116('0x30')][_0xa116('0x34')]));_0x47a54b['attributes']=_0x47a54b[_0xa116('0x33')]['length']?_0x47a54b[_0xa116('0x33')]:_0x118916[_0xa116('0x2e')];if(_0x3ceaac[_0xa116('0x30')]['includeAll']){_0x47a54b['include']=[{'all':!![]}];}_0x47a54b=_['merge']({},_0x47a54b,_0x3ceaac['options']);return db[_0xa116('0x2b')][_0xa116('0x45')](_0x47a54b)[_0xa116('0x26')](handleEntityNotFound(_0x3fb8d4,null))[_0xa116('0x26')](respondWithResult(_0x3fb8d4,null))[_0xa116('0x46')](handleError(_0x3fb8d4,null));};exports['create']=function(_0xca1a7e,_0x10aa7e){return db[_0xa116('0x2b')][_0xa116('0x47')](_0xca1a7e[_0xa116('0x48')],{})['then'](respondWithResult(_0x10aa7e,0xc9))[_0xa116('0x46')](handleError(_0x10aa7e,null));};exports[_0xa116('0x25')]=function(_0xb457e4,_0x355f77){if(_0xb457e4[_0xa116('0x48')]['id']){delete _0xb457e4[_0xa116('0x48')]['id'];}return db[_0xa116('0x2b')][_0xa116('0x45')]({'where':{'id':_0xb457e4[_0xa116('0x43')]['id']}})[_0xa116('0x26')](handleEntityNotFound(_0x355f77,null))[_0xa116('0x26')](saveUpdates(_0xb457e4['body'],null))[_0xa116('0x26')](respondWithResult(_0x355f77,null))[_0xa116('0x46')](handleError(_0x355f77,null));};exports[_0xa116('0x27')]=function(_0xb50453,_0x4795ec){return db[_0xa116('0x2b')]['find']({'where':{'id':_0xb50453[_0xa116('0x43')]['id']}})[_0xa116('0x26')](handleEntityNotFound(_0x4795ec,null))[_0xa116('0x26')](removeEntity(_0x4795ec,null))[_0xa116('0x46')](handleError(_0x4795ec,null));};exports[_0xa116('0x49')]=function(_0x339cf4,_0x3232ca,_0x7c6349){var _0x4a8016={};var _0x246b80={};var _0xb2b486;var _0x2641a4;return db[_0xa116('0x2b')][_0xa116('0x4a')]({'where':{'id':_0x339cf4['params']['id']}})[_0xa116('0x26')](handleEntityNotFound(_0x3232ca,null))[_0xa116('0x26')](function(_0x4638a2){if(_0x4638a2){_0xb2b486=_0x4638a2;_0x246b80[_0xa116('0x2e')]=_['keys'](db[_0xa116('0x4b')][_0xa116('0x44')]);_0x246b80[_0xa116('0x30')]=_[_0xa116('0x31')](_0x339cf4[_0xa116('0x30')]);_0x246b80['filters']=_[_0xa116('0x32')](_0x246b80[_0xa116('0x2e')],_0x246b80['query']);_0x4a8016[_0xa116('0x33')]=_[_0xa116('0x32')](_0x246b80[_0xa116('0x2e')],qs[_0xa116('0x34')](_0x339cf4[_0xa116('0x30')][_0xa116('0x34')]));_0x4a8016['attributes']=_0x4a8016[_0xa116('0x33')]['length']?_0x4a8016[_0xa116('0x33')]:_0x246b80['model'];_0x4a8016[_0xa116('0x37')]=qs[_0xa116('0x4c')](_0x339cf4[_0xa116('0x30')][_0xa116('0x4c')]);_0x4a8016['where']=qs[_0xa116('0x38')](_[_0xa116('0x39')](_0x339cf4[_0xa116('0x30')],_0x246b80[_0xa116('0x38')]));if(_0x339cf4[_0xa116('0x30')][_0xa116('0x3d')]){_0x4a8016['where']=_[_0xa116('0x3a')](_0x4a8016[_0xa116('0x3b')],{'$or':_[_0xa116('0x2f')](_0x4a8016[_0xa116('0x33')],function(_0x42eff3){var _0x325b67={};_0x325b67[_0x42eff3]={'$like':'%'+_0x339cf4['query'][_0xa116('0x3d')]+'%'};return _0x325b67;})});}_0x4a8016=_[_0xa116('0x3a')]({},_0x4a8016,_0x339cf4[_0xa116('0x3e')]);return _0xb2b486[_0xa116('0x49')](_0x4a8016);}})[_0xa116('0x26')](function(_0x1ced33){if(_0x1ced33){_0x2641a4=_0x1ced33[_0xa116('0x35')];if(!_0x339cf4[_0xa116('0x30')]['hasOwnProperty'](_0xa116('0x36'))){_0x4a8016[_0xa116('0x1f')]=qs[_0xa116('0x1f')](_0x339cf4[_0xa116('0x30')][_0xa116('0x1f')]);_0x4a8016[_0xa116('0x1d')]=qs[_0xa116('0x1d')](_0x339cf4[_0xa116('0x30')][_0xa116('0x1d')]);}return _0xb2b486[_0xa116('0x49')](_0x4a8016);}})[_0xa116('0x26')](function(_0x2d236a){if(_0x2d236a){return _0x2d236a?{'count':_0x2641a4,'rows':_0x2d236a}:null;}})[_0xa116('0x26')](respondWithResult(_0x3232ca,null))[_0xa116('0x46')](handleError(_0x3232ca,null));};exports[_0xa116('0x4d')]=function(_0x5e2507,_0x1d596a,_0x5e64cf){var _0x2ebce6={};var _0x3b6b94={};var _0x55eddb;var _0x4d509d;return db[_0xa116('0x2b')]['findOne']({'where':{'id':_0x5e2507[_0xa116('0x43')]['id']}})[_0xa116('0x26')](handleEntityNotFound(_0x1d596a,null))[_0xa116('0x26')](function(_0x416ae8){if(_0x416ae8){_0x55eddb=_0x416ae8;_0x3b6b94[_0xa116('0x2e')]=_[_0xa116('0x31')](db[_0xa116('0x4b')][_0xa116('0x44')]);_0x3b6b94['query']=_['keys'](_0x5e2507[_0xa116('0x30')]);_0x3b6b94[_0xa116('0x38')]=_[_0xa116('0x32')](_0x3b6b94['model'],_0x3b6b94[_0xa116('0x30')]);_0x2ebce6[_0xa116('0x33')]=_[_0xa116('0x32')](_0x3b6b94[_0xa116('0x2e')],qs[_0xa116('0x34')](_0x5e2507[_0xa116('0x30')][_0xa116('0x34')]));_0x2ebce6[_0xa116('0x33')]=_0x2ebce6[_0xa116('0x33')][_0xa116('0x35')]?_0x2ebce6[_0xa116('0x33')]:_0x3b6b94[_0xa116('0x2e')];_0x2ebce6[_0xa116('0x37')]=qs[_0xa116('0x4c')](_0x5e2507[_0xa116('0x30')][_0xa116('0x4c')]);_0x2ebce6[_0xa116('0x3b')]=qs[_0xa116('0x38')](_[_0xa116('0x39')](_0x5e2507[_0xa116('0x30')],_0x3b6b94[_0xa116('0x38')]));if(_0x5e2507['query'][_0xa116('0x3d')]){_0x2ebce6['where']=_['merge'](_0x2ebce6['where'],{'$or':_['map'](_0x2ebce6[_0xa116('0x33')],function(_0x32259e){var _0x4a8c4a={};_0x4a8c4a[_0x32259e]={'$like':'%'+_0x5e2507[_0xa116('0x30')]['filter']+'%'};return _0x4a8c4a;})});}_0x2ebce6=_['merge']({},_0x2ebce6,_0x5e2507[_0xa116('0x3e')]);return _0x55eddb['getSubjects'](_0x2ebce6);}})['then'](function(_0x3cf8a4){if(_0x3cf8a4){_0x4d509d=_0x3cf8a4[_0xa116('0x35')];if(!_0x5e2507[_0xa116('0x30')][_0xa116('0x4e')]('nolimit')){_0x2ebce6[_0xa116('0x1f')]=qs[_0xa116('0x1f')](_0x5e2507[_0xa116('0x30')]['limit']);_0x2ebce6[_0xa116('0x1d')]=qs['offset'](_0x5e2507['query'][_0xa116('0x1d')]);}return _0x55eddb[_0xa116('0x4d')](_0x2ebce6);}})[_0xa116('0x26')](function(_0x1f8212){if(_0x1f8212){return _0x1f8212?{'count':_0x4d509d,'rows':_0x1f8212}:null;}})['then'](respondWithResult(_0x1d596a,null))[_0xa116('0x46')](handleError(_0x1d596a,null));};exports['getDescriptions']=function(_0x2305b9,_0x5a4cd8,_0x52df75){var _0x5c8c78={};var _0x2392d9={};var _0x4f6ff8;var _0x2dc8bf;return db['ZohoConfiguration'][_0xa116('0x4a')]({'where':{'id':_0x2305b9[_0xa116('0x43')]['id']}})[_0xa116('0x26')](handleEntityNotFound(_0x5a4cd8,null))['then'](function(_0x136edb){if(_0x136edb){_0x4f6ff8=_0x136edb;_0x2392d9[_0xa116('0x2e')]=_[_0xa116('0x31')](db[_0xa116('0x4b')][_0xa116('0x44')]);_0x2392d9[_0xa116('0x30')]=_['keys'](_0x2305b9[_0xa116('0x30')]);_0x2392d9[_0xa116('0x38')]=_[_0xa116('0x32')](_0x2392d9['model'],_0x2392d9[_0xa116('0x30')]);_0x5c8c78[_0xa116('0x33')]=_['intersection'](_0x2392d9[_0xa116('0x2e')],qs['fields'](_0x2305b9[_0xa116('0x30')]['fields']));_0x5c8c78[_0xa116('0x33')]=_0x5c8c78[_0xa116('0x33')][_0xa116('0x35')]?_0x5c8c78[_0xa116('0x33')]:_0x2392d9[_0xa116('0x2e')];_0x5c8c78[_0xa116('0x37')]=qs[_0xa116('0x4c')](_0x2305b9[_0xa116('0x30')][_0xa116('0x4c')]);_0x5c8c78[_0xa116('0x3b')]=qs[_0xa116('0x38')](_[_0xa116('0x39')](_0x2305b9['query'],_0x2392d9[_0xa116('0x38')]));if(_0x2305b9['query'][_0xa116('0x3d')]){_0x5c8c78[_0xa116('0x3b')]=_[_0xa116('0x3a')](_0x5c8c78[_0xa116('0x3b')],{'$or':_[_0xa116('0x2f')](_0x5c8c78[_0xa116('0x33')],function(_0x354a1a){var _0x26b7cc={};_0x26b7cc[_0x354a1a]={'$like':'%'+_0x2305b9[_0xa116('0x30')]['filter']+'%'};return _0x26b7cc;})});}_0x5c8c78=_[_0xa116('0x3a')]({},_0x5c8c78,_0x2305b9['options']);return _0x4f6ff8[_0xa116('0x4f')](_0x5c8c78);}})['then'](function(_0xfb6d52){if(_0xfb6d52){_0x2dc8bf=_0xfb6d52[_0xa116('0x35')];if(!_0x2305b9['query'][_0xa116('0x4e')](_0xa116('0x36'))){_0x5c8c78[_0xa116('0x1f')]=qs[_0xa116('0x1f')](_0x2305b9[_0xa116('0x30')][_0xa116('0x1f')]);_0x5c8c78[_0xa116('0x1d')]=qs[_0xa116('0x1d')](_0x2305b9['query'][_0xa116('0x1d')]);}return _0x4f6ff8[_0xa116('0x4f')](_0x5c8c78);}})[_0xa116('0x26')](function(_0x4d957e){if(_0x4d957e){return _0x4d957e?{'count':_0x2dc8bf,'rows':_0x4d957e}:null;}})[_0xa116('0x26')](respondWithResult(_0x5a4cd8,null))[_0xa116('0x46')](handleError(_0x5a4cd8,null));};