[motion2.git] / server / api / intFreshsalesConfiguration / intFreshsalesConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x0d69=['order','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','catch','show','params','keys','rawAttributes','find','create','body','getSubjects','findOne','FreshsalesField','getDescriptions','getFields','eml-format','rimraf','fast-json-patch','moment','bluebird','mustache','util','path','to-csv','fs-extra','squel','crypto','jsforce','desk.js','querystring','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','json','offset','undefined','limit','count','set','Content-Range','apply','reject','save','update','then','destroy','end','error','stack','name','index','map','FreshsalesConfiguration','type','key','model','query','intersection','attributes','fields','length','hasOwnProperty','nolimit'];(function(_0x5486c0,_0x4079df){var _0x5df928=function(_0x2606bc){while(--_0x2606bc){_0x5486c0['push'](_0x5486c0['shift']());}};_0x5df928(++_0x4079df);}(_0x0d69,0x15d));var _0x90d6=function(_0x24fe3d,_0x1a7002){_0x24fe3d=_0x24fe3d-0x0;var _0x288684=_0x0d69[_0x24fe3d];return _0x288684;};'use strict';var emlformat=require(_0x90d6('0x0'));var rimraf=require(_0x90d6('0x1'));var zipdir=require('zip-dir');var jsonpatch=require(_0x90d6('0x2'));var rp=require('request-promise');var moment=require(_0x90d6('0x3'));var BPromise=require(_0x90d6('0x4'));var Mustache=require(_0x90d6('0x5'));var util=require(_0x90d6('0x6'));var path=require(_0x90d6('0x7'));var sox=require('sox');var csv=require(_0x90d6('0x8'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x90d6('0x9'));var _=require('lodash');var squel=require(_0x90d6('0xa'));var crypto=require(_0x90d6('0xb'));var jsforce=require(_0x90d6('0xc'));var deskjs=require(_0x90d6('0xd'));var toCsv=require('to-csv');var querystring=require(_0x90d6('0xe'));var Papa=require('papaparse');var Redis=require(_0x90d6('0xf'));var authService=require(_0x90d6('0x10'));var qs=require(_0x90d6('0x11'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x90d6('0x12'));var logger=require(_0x90d6('0x13'))(_0x90d6('0x14'));var utils=require('../../config/utils');var config=require(_0x90d6('0x15'));var licenseUtil=require(_0x90d6('0x16'));var db=require(_0x90d6('0x17'))['db'];function respondWithStatusCode(_0x21f462,_0x373a11){_0x373a11=_0x373a11||0xcc;return function(_0x2f2e17){if(_0x2f2e17){return _0x21f462[_0x90d6('0x18')](_0x373a11);}return _0x21f462[_0x90d6('0x19')](_0x373a11)['end']();};}function respondWithResult(_0x3a6e70,_0x1bb745){_0x1bb745=_0x1bb745||0xc8;return function(_0x3b0de2){if(_0x3b0de2){return _0x3a6e70[_0x90d6('0x19')](_0x1bb745)[_0x90d6('0x1a')](_0x3b0de2);}};}function respondWithFilteredResult(_0x499df4,_0x3ebe37){return function(_0x27d2f4){if(_0x27d2f4){var _0x52cee4=typeof _0x3ebe37[_0x90d6('0x1b')]===_0x90d6('0x1c')&&typeof _0x3ebe37[_0x90d6('0x1d')]==='undefined';var _0x5ef183=_0x27d2f4[_0x90d6('0x1e')];var _0x2043c2=_0x52cee4?0x0:_0x3ebe37['offset'];var _0x208403=_0x52cee4?_0x27d2f4[_0x90d6('0x1e')]:_0x3ebe37[_0x90d6('0x1b')]+_0x3ebe37[_0x90d6('0x1d')];var _0x53f9b7;if(_0x208403>=_0x5ef183){_0x208403=_0x5ef183;_0x53f9b7=0xc8;}else{_0x53f9b7=0xce;}_0x499df4['status'](_0x53f9b7);return _0x499df4[_0x90d6('0x1f')](_0x90d6('0x20'),_0x2043c2+'-'+_0x208403+'/'+_0x5ef183)['json'](_0x27d2f4);}return null;};}function patchUpdates(_0x5b5383){return function(_0x85f29d){try{jsonpatch[_0x90d6('0x21')](_0x85f29d,_0x5b5383,!![]);}catch(_0x5dd9f0){return BPromise[_0x90d6('0x22')](_0x5dd9f0);}return _0x85f29d[_0x90d6('0x23')]();};}function saveUpdates(_0x346ba9,_0xeefc3f){return function(_0x34a5e0){if(_0x34a5e0){return _0x34a5e0[_0x90d6('0x24')](_0x346ba9)[_0x90d6('0x25')](function(_0x1973ce){return _0x1973ce;});}return null;};}function removeEntity(_0x2e285a,_0x5bf7ae){return function(_0x502c46){if(_0x502c46){return _0x502c46[_0x90d6('0x26')]()[_0x90d6('0x25')](function(){_0x2e285a[_0x90d6('0x19')](0xcc)[_0x90d6('0x27')]();});}};}function handleEntityNotFound(_0x4cbff8,_0x49e263){return function(_0x594b7f){if(!_0x594b7f){_0x4cbff8['sendStatus'](0x194);}return _0x594b7f;};}function handleError(_0x15ae0d,_0x3a5bc9){_0x3a5bc9=_0x3a5bc9||0x1f4;return function(_0x1c772a){logger[_0x90d6('0x28')](_0x1c772a[_0x90d6('0x29')]);if(_0x1c772a[_0x90d6('0x2a')]){delete _0x1c772a[_0x90d6('0x2a')];}_0x15ae0d[_0x90d6('0x19')](_0x3a5bc9)['send'](_0x1c772a);};}exports[_0x90d6('0x2b')]=function(_0xf8c5cc,_0x105524){var _0x4bb1d2={},_0x44938f={},_0xea2234={'count':0x0,'rows':[]};var _0x5bc305=_[_0x90d6('0x2c')](db[_0x90d6('0x2d')]['rawAttributes'],function(_0x4d44d1){return{'name':_0x4d44d1['fieldName'],'type':_0x4d44d1[_0x90d6('0x2e')][_0x90d6('0x2f')]};});_0x44938f[_0x90d6('0x30')]=_[_0x90d6('0x2c')](_0x5bc305,_0x90d6('0x2a'));_0x44938f['query']=_['keys'](_0xf8c5cc[_0x90d6('0x31')]);_0x44938f['filters']=_[_0x90d6('0x32')](_0x44938f[_0x90d6('0x30')],_0x44938f[_0x90d6('0x31')]);_0x4bb1d2[_0x90d6('0x33')]=_[_0x90d6('0x32')](_0x44938f['model'],qs[_0x90d6('0x34')](_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x34')]));_0x4bb1d2[_0x90d6('0x33')]=_0x4bb1d2[_0x90d6('0x33')][_0x90d6('0x35')]?_0x4bb1d2[_0x90d6('0x33')]:_0x44938f[_0x90d6('0x30')];if(!_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x36')](_0x90d6('0x37'))){_0x4bb1d2[_0x90d6('0x1d')]=qs['limit'](_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x1d')]);_0x4bb1d2['offset']=qs[_0x90d6('0x1b')](_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x1b')]);}_0x4bb1d2[_0x90d6('0x38')]=qs[_0x90d6('0x39')](_0xf8c5cc['query'][_0x90d6('0x39')]);_0x4bb1d2[_0x90d6('0x3a')]=qs[_0x90d6('0x3b')](_[_0x90d6('0x3c')](_0xf8c5cc[_0x90d6('0x31')],_0x44938f['filters']),_0x5bc305);if(_0xf8c5cc['query'][_0x90d6('0x3d')]){_0x4bb1d2['where']=_[_0x90d6('0x3e')](_0x4bb1d2[_0x90d6('0x3a')],{'$or':_['map'](_0x5bc305,function(_0x3d141a){if(_0x3d141a[_0x90d6('0x2e')]!==_0x90d6('0x3f')){var _0x27a3c4={};_0x27a3c4[_0x3d141a[_0x90d6('0x2a')]]={'$like':'%'+_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x3d')]+'%'};return _0x27a3c4;}})});}_0x4bb1d2=_[_0x90d6('0x3e')]({},_0x4bb1d2,_0xf8c5cc[_0x90d6('0x40')]);var _0x10f4f7={'where':_0x4bb1d2['where']};return db[_0x90d6('0x2d')][_0x90d6('0x1e')](_0x10f4f7)[_0x90d6('0x25')](function(_0x14bc81){_0xea2234['count']=_0x14bc81;if(_0xf8c5cc[_0x90d6('0x31')][_0x90d6('0x41')]){_0x4bb1d2[_0x90d6('0x42')]=[{'all':!![]}];}return db[_0x90d6('0x2d')][_0x90d6('0x43')](_0x4bb1d2);})[_0x90d6('0x25')](function(_0x579cbf){_0xea2234['rows']=_0x579cbf;return _0xea2234;})[_0x90d6('0x25')](respondWithFilteredResult(_0x105524,_0x4bb1d2))[_0x90d6('0x44')](handleError(_0x105524,null));};exports[_0x90d6('0x45')]=function(_0x5b3f0,_0x3f532a){var _0x729630={'raw':![],'where':{'id':_0x5b3f0[_0x90d6('0x46')]['id']}},_0x3fc4e2={};_0x3fc4e2[_0x90d6('0x30')]=_[_0x90d6('0x47')](db['FreshsalesConfiguration'][_0x90d6('0x48')]);_0x3fc4e2[_0x90d6('0x31')]=_['keys'](_0x5b3f0['query']);_0x3fc4e2[_0x90d6('0x3b')]=_[_0x90d6('0x32')](_0x3fc4e2['model'],_0x3fc4e2[_0x90d6('0x31')]);_0x729630[_0x90d6('0x33')]=_[_0x90d6('0x32')](_0x3fc4e2['model'],qs[_0x90d6('0x34')](_0x5b3f0[_0x90d6('0x31')][_0x90d6('0x34')]));_0x729630[_0x90d6('0x33')]=_0x729630[_0x90d6('0x33')][_0x90d6('0x35')]?_0x729630[_0x90d6('0x33')]:_0x3fc4e2[_0x90d6('0x30')];if(_0x5b3f0['query'][_0x90d6('0x41')]){_0x729630['include']=[{'all':!![]}];}_0x729630=_[_0x90d6('0x3e')]({},_0x729630,_0x5b3f0['options']);return db[_0x90d6('0x2d')][_0x90d6('0x49')](_0x729630)[_0x90d6('0x25')](handleEntityNotFound(_0x3f532a,null))[_0x90d6('0x25')](respondWithResult(_0x3f532a,null))[_0x90d6('0x44')](handleError(_0x3f532a,null));};exports['create']=function(_0x2b98bf,_0x28e52a){return db[_0x90d6('0x2d')][_0x90d6('0x4a')](_0x2b98bf[_0x90d6('0x4b')],{})[_0x90d6('0x25')](respondWithResult(_0x28e52a,0xc9))[_0x90d6('0x44')](handleError(_0x28e52a,null));};exports[_0x90d6('0x24')]=function(_0x545e03,_0x3d7a3e){if(_0x545e03[_0x90d6('0x4b')]['id']){delete _0x545e03[_0x90d6('0x4b')]['id'];}return db[_0x90d6('0x2d')]['find']({'where':{'id':_0x545e03[_0x90d6('0x46')]['id']}})[_0x90d6('0x25')](handleEntityNotFound(_0x3d7a3e,null))[_0x90d6('0x25')](saveUpdates(_0x545e03[_0x90d6('0x4b')],null))['then'](respondWithResult(_0x3d7a3e,null))['catch'](handleError(_0x3d7a3e,null));};exports[_0x90d6('0x26')]=function(_0x5df63d,_0x5a5db8){return db['FreshsalesConfiguration'][_0x90d6('0x49')]({'where':{'id':_0x5df63d[_0x90d6('0x46')]['id']}})[_0x90d6('0x25')](handleEntityNotFound(_0x5a5db8,null))['then'](removeEntity(_0x5a5db8,null))['catch'](handleError(_0x5a5db8,null));};exports['getSubjects']=function(_0x1632d3,_0x4fdbaf,_0x4396fb){var _0x3b7217={};var _0x53ccc4={};var _0x1df455;var _0x20afc0;return db['FreshsalesConfiguration']['findOne']({'where':{'id':_0x1632d3[_0x90d6('0x46')]['id']}})['then'](handleEntityNotFound(_0x4fdbaf,null))[_0x90d6('0x25')](function(_0x5e31ed){if(_0x5e31ed){_0x1df455=_0x5e31ed;_0x53ccc4[_0x90d6('0x30')]=_['keys'](db['FreshsalesField'][_0x90d6('0x48')]);_0x53ccc4[_0x90d6('0x31')]=_[_0x90d6('0x47')](_0x1632d3[_0x90d6('0x31')]);_0x53ccc4['filters']=_[_0x90d6('0x32')](_0x53ccc4[_0x90d6('0x30')],_0x53ccc4[_0x90d6('0x31')]);_0x3b7217[_0x90d6('0x33')]=_['intersection'](_0x53ccc4[_0x90d6('0x30')],qs[_0x90d6('0x34')](_0x1632d3[_0x90d6('0x31')][_0x90d6('0x34')]));_0x3b7217['attributes']=_0x3b7217[_0x90d6('0x33')][_0x90d6('0x35')]?_0x3b7217[_0x90d6('0x33')]:_0x53ccc4[_0x90d6('0x30')];_0x3b7217['order']=qs['sort'](_0x1632d3[_0x90d6('0x31')]['sort']);_0x3b7217[_0x90d6('0x3a')]=qs[_0x90d6('0x3b')](_[_0x90d6('0x3c')](_0x1632d3['query'],_0x53ccc4['filters']));if(_0x1632d3[_0x90d6('0x31')][_0x90d6('0x3d')]){_0x3b7217[_0x90d6('0x3a')]=_[_0x90d6('0x3e')](_0x3b7217['where'],{'$or':_[_0x90d6('0x2c')](_0x3b7217[_0x90d6('0x33')],function(_0x4e9d0c){var _0x1fb1bb={};_0x1fb1bb[_0x4e9d0c]={'$like':'%'+_0x1632d3[_0x90d6('0x31')][_0x90d6('0x3d')]+'%'};return _0x1fb1bb;})});}_0x3b7217=_[_0x90d6('0x3e')]({},_0x3b7217,_0x1632d3[_0x90d6('0x40')]);return _0x1df455[_0x90d6('0x4c')](_0x3b7217);}})[_0x90d6('0x25')](function(_0x56f513){if(_0x56f513){_0x20afc0=_0x56f513[_0x90d6('0x35')];if(!_0x1632d3[_0x90d6('0x31')][_0x90d6('0x36')](_0x90d6('0x37'))){_0x3b7217[_0x90d6('0x1d')]=qs[_0x90d6('0x1d')](_0x1632d3[_0x90d6('0x31')][_0x90d6('0x1d')]);_0x3b7217[_0x90d6('0x1b')]=qs[_0x90d6('0x1b')](_0x1632d3['query'][_0x90d6('0x1b')]);}return _0x1df455['getSubjects'](_0x3b7217);}})[_0x90d6('0x25')](function(_0x295844){if(_0x295844){return _0x295844?{'count':_0x20afc0,'rows':_0x295844}:null;}})['then'](respondWithResult(_0x4fdbaf,null))[_0x90d6('0x44')](handleError(_0x4fdbaf,null));};exports['getDescriptions']=function(_0x4c41e0,_0x2eadf2,_0x19acb9){var _0x390a79={};var _0x51bf50={};var _0x1c1a5a;var _0x51ab07;return db[_0x90d6('0x2d')][_0x90d6('0x4d')]({'where':{'id':_0x4c41e0[_0x90d6('0x46')]['id']}})[_0x90d6('0x25')](handleEntityNotFound(_0x2eadf2,null))['then'](function(_0x2aaf28){if(_0x2aaf28){_0x1c1a5a=_0x2aaf28;_0x51bf50[_0x90d6('0x30')]=_[_0x90d6('0x47')](db[_0x90d6('0x4e')][_0x90d6('0x48')]);_0x51bf50[_0x90d6('0x31')]=_[_0x90d6('0x47')](_0x4c41e0[_0x90d6('0x31')]);_0x51bf50[_0x90d6('0x3b')]=_[_0x90d6('0x32')](_0x51bf50['model'],_0x51bf50['query']);_0x390a79[_0x90d6('0x33')]=_[_0x90d6('0x32')](_0x51bf50[_0x90d6('0x30')],qs['fields'](_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x34')]));_0x390a79[_0x90d6('0x33')]=_0x390a79[_0x90d6('0x33')][_0x90d6('0x35')]?_0x390a79[_0x90d6('0x33')]:_0x51bf50[_0x90d6('0x30')];_0x390a79[_0x90d6('0x38')]=qs[_0x90d6('0x39')](_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x39')]);_0x390a79[_0x90d6('0x3a')]=qs['filters'](_[_0x90d6('0x3c')](_0x4c41e0[_0x90d6('0x31')],_0x51bf50[_0x90d6('0x3b')]));if(_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x3d')]){_0x390a79[_0x90d6('0x3a')]=_['merge'](_0x390a79[_0x90d6('0x3a')],{'$or':_[_0x90d6('0x2c')](_0x390a79[_0x90d6('0x33')],function(_0x52f75c){var _0x3beeaa={};_0x3beeaa[_0x52f75c]={'$like':'%'+_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x3d')]+'%'};return _0x3beeaa;})});}_0x390a79=_['merge']({},_0x390a79,_0x4c41e0[_0x90d6('0x40')]);return _0x1c1a5a['getDescriptions'](_0x390a79);}})[_0x90d6('0x25')](function(_0x3c0ad8){if(_0x3c0ad8){_0x51ab07=_0x3c0ad8['length'];if(!_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x36')](_0x90d6('0x37'))){_0x390a79[_0x90d6('0x1d')]=qs['limit'](_0x4c41e0[_0x90d6('0x31')][_0x90d6('0x1d')]);_0x390a79[_0x90d6('0x1b')]=qs[_0x90d6('0x1b')](_0x4c41e0[_0x90d6('0x31')]['offset']);}return _0x1c1a5a[_0x90d6('0x4f')](_0x390a79);}})[_0x90d6('0x25')](function(_0x56e3fc){if(_0x56e3fc){return _0x56e3fc?{'count':_0x51ab07,'rows':_0x56e3fc}:null;}})['then'](respondWithResult(_0x2eadf2,null))['catch'](handleError(_0x2eadf2,null));};exports[_0x90d6('0x50')]=function(_0x3c5682,_0x37d429,_0x5539f5){var _0x1633e4={};var _0x4dbc3f={};var _0xeaed60;var _0x24ac41;return db[_0x90d6('0x2d')][_0x90d6('0x4d')]({'where':{'id':_0x3c5682['params']['id']}})[_0x90d6('0x25')](handleEntityNotFound(_0x37d429,null))[_0x90d6('0x25')](function(_0x156991){if(_0x156991){_0xeaed60=_0x156991;_0x4dbc3f[_0x90d6('0x30')]=_[_0x90d6('0x47')](db['FreshsalesField'][_0x90d6('0x48')]);_0x4dbc3f[_0x90d6('0x31')]=_[_0x90d6('0x47')](_0x3c5682[_0x90d6('0x31')]);_0x4dbc3f[_0x90d6('0x3b')]=_[_0x90d6('0x32')](_0x4dbc3f[_0x90d6('0x30')],_0x4dbc3f[_0x90d6('0x31')]);_0x1633e4[_0x90d6('0x33')]=_[_0x90d6('0x32')](_0x4dbc3f['model'],qs['fields'](_0x3c5682[_0x90d6('0x31')][_0x90d6('0x34')]));_0x1633e4['attributes']=_0x1633e4['attributes'][_0x90d6('0x35')]?_0x1633e4[_0x90d6('0x33')]:_0x4dbc3f[_0x90d6('0x30')];_0x1633e4[_0x90d6('0x38')]=qs[_0x90d6('0x39')](_0x3c5682['query'][_0x90d6('0x39')]);_0x1633e4[_0x90d6('0x3a')]=qs[_0x90d6('0x3b')](_[_0x90d6('0x3c')](_0x3c5682[_0x90d6('0x31')],_0x4dbc3f[_0x90d6('0x3b')]));if(_0x3c5682['query'][_0x90d6('0x3d')]){_0x1633e4[_0x90d6('0x3a')]=_[_0x90d6('0x3e')](_0x1633e4['where'],{'$or':_[_0x90d6('0x2c')](_0x1633e4[_0x90d6('0x33')],function(_0x57c656){var _0x198f99={};_0x198f99[_0x57c656]={'$like':'%'+_0x3c5682[_0x90d6('0x31')][_0x90d6('0x3d')]+'%'};return _0x198f99;})});}_0x1633e4=_[_0x90d6('0x3e')]({},_0x1633e4,_0x3c5682[_0x90d6('0x40')]);return _0xeaed60[_0x90d6('0x50')](_0x1633e4);}})['then'](function(_0x532b1e){if(_0x532b1e){_0x24ac41=_0x532b1e['length'];if(!_0x3c5682[_0x90d6('0x31')][_0x90d6('0x36')](_0x90d6('0x37'))){_0x1633e4['limit']=qs[_0x90d6('0x1d')](_0x3c5682[_0x90d6('0x31')][_0x90d6('0x1d')]);_0x1633e4['offset']=qs[_0x90d6('0x1b')](_0x3c5682[_0x90d6('0x31')]['offset']);}return _0xeaed60['getFields'](_0x1633e4);}})[_0x90d6('0x25')](function(_0x338b30){if(_0x338b30){return _0x338b30?{'count':_0x24ac41,'rows':_0x338b30}:null;}})[_0x90d6('0x25')](respondWithResult(_0x37d429,null))['catch'](handleError(_0x37d429,null));};