Built motion from commit (unavailable).|2.5.13
[motion2.git] / server / api / intSugarcrmAccount / intSugarcrmAccount.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 _0x89c8=['SugarcrmField','Subjects','description','date_start','duration_hours','duration_minutes','parent_id','parent_type','parent_name','direction','username','password','remoteUri','slice','substring','lastIndexOf','POST','%s%s','/service/v4_1/rest.php','login','JSON','PLAIN','xCALLY\x20Motion\x20Integration','Invalid\x20Login','Password\x20Expired','get_module_fields','Calls','values','module_fields','remove','label','endsWith','test','statusCode','Wrong\x20credentials','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','mustache','path','sox','ejs','lodash','squel','jsforce','desk.js','to-csv','papaparse','ioredis','../../components/auth/service','../../config/license/hardware','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','jayson/promise','client','request','SugarcrmAccount,\x20%s,\x20%s','request\x20sent','SugarcrmAccount,\x20%s,\x20%s,\x20%s','stringify','error','message','catch','end','status','json','count','offset','limit','Content-Range','save','update','then','destroy','stack','name','send','index','SugarcrmAccount','rawAttributes','model','map','query','filters','intersection','attributes','fields','hasOwnProperty','where','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','keys','create','body','find','params','getConfigurations','findOne','SugarcrmConfiguration','length','order','sort','pick','nolimit','getSubjects','Descriptions','getDescriptions','type'];(function(_0x1869ec,_0x5a8db2){var _0x370f4f=function(_0x6f8e22){while(--_0x6f8e22){_0x1869ec['push'](_0x1869ec['shift']());}};_0x370f4f(++_0x5a8db2);}(_0x89c8,0x185));var _0x889c=function(_0x1d352a,_0x5b9b85){_0x1d352a=_0x1d352a-0x0;var _0x441f49=_0x89c8[_0x1d352a];return _0x441f49;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x889c('0x0'));var rimraf=require(_0x889c('0x1'));var zipdir=require(_0x889c('0x2'));var jsonpatch=require(_0x889c('0x3'));var rp=require(_0x889c('0x4'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0x889c('0x5'));var util=require('util');var path=require(_0x889c('0x6'));var sox=require(_0x889c('0x7'));var csv=require('to-csv');var ejs=require(_0x889c('0x8'));var fs=require('fs');var _=require(_0x889c('0x9'));var squel=require(_0x889c('0xa'));var crypto=require('crypto');var jsforce=require(_0x889c('0xb'));var deskjs=require(_0x889c('0xc'));var toCsv=require(_0x889c('0xd'));var querystring=require('querystring');var Papa=require(_0x889c('0xe'));var Redis=require(_0x889c('0xf'));var authService=require(_0x889c('0x10'));var qs=require('../../components/parsers/qs');var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0x889c('0x11'));var logger=require('../../config/logger')('api');var utils=require(_0x889c('0x12'));var config=require(_0x889c('0x13'));var licenseUtil=require('../../config/license/util');var db=require(_0x889c('0x14'))['db'];var integrations=require(_0x889c('0x15'));var jayson=require(_0x889c('0x16'));var client=jayson[_0x889c('0x17')]['http']({'port':0x232a});function respondWithRpcPromise(_0x538a96,_0x4b92f8,_0x132881,_0x2c7087){return new BPromise(function(_0x5893c1,_0x1be3b){var _0x4f10cf=_0x2c7087||client;return _0x4f10cf[_0x889c('0x18')](_0x538a96,_0x132881)['then'](function(_0x1b6967){logger['info'](_0x889c('0x19'),_0x4b92f8,_0x889c('0x1a'));logger['debug'](_0x889c('0x1b'),_0x4b92f8,_0x889c('0x1a'),JSON[_0x889c('0x1c')](_0x1b6967));if(_0x1b6967['error']){if(_0x1b6967[_0x889c('0x1d')]['code']===0x1f4){logger['error'](_0x889c('0x19'),_0x4b92f8,_0x1b6967[_0x889c('0x1d')][_0x889c('0x1e')]);return _0x1be3b(_0x1b6967[_0x889c('0x1d')]['message']);}logger[_0x889c('0x1d')](_0x889c('0x19'),_0x4b92f8,_0x1b6967[_0x889c('0x1d')][_0x889c('0x1e')]);return _0x5893c1(_0x1b6967[_0x889c('0x1d')]['message']);}else{logger['info'](_0x889c('0x19'),_0x4b92f8,_0x889c('0x1a'));_0x5893c1(_0x1b6967['result'][_0x889c('0x1e')]);}})[_0x889c('0x1f')](function(_0x580b81){logger['error'](_0x889c('0x19'),_0x4b92f8,_0x580b81);_0x1be3b(_0x580b81);});});}function respondWithStatusCode(_0x14e7fd,_0x26c9cb){_0x26c9cb=_0x26c9cb||0xcc;return function(_0x3b2abd){if(_0x3b2abd){return _0x14e7fd['sendStatus'](_0x26c9cb);}return _0x14e7fd['status'](_0x26c9cb)[_0x889c('0x20')]();};}function respondWithResult(_0x40cbe3,_0x3eb8ee){_0x3eb8ee=_0x3eb8ee||0xc8;return function(_0x4f16c1){if(_0x4f16c1){return _0x40cbe3[_0x889c('0x21')](_0x3eb8ee)[_0x889c('0x22')](_0x4f16c1);}};}function respondWithFilteredResult(_0x332af3,_0x2dcf9b){return function(_0xbfdadb){if(_0xbfdadb){var _0x17abb4=_0xbfdadb[_0x889c('0x23')],_0x3d846a=_0x2dcf9b[_0x889c('0x24')],_0x28a0f5=_0x2dcf9b[_0x889c('0x24')]+_0x2dcf9b[_0x889c('0x25')],_0xe6834d;if(_0x28a0f5>=_0x17abb4){_0x28a0f5=_0x17abb4;_0xe6834d=0xc8;}else{_0xe6834d=0xce;}_0x332af3['status'](_0xe6834d);return _0x332af3['set'](_0x889c('0x26'),_0x3d846a+'-'+_0x28a0f5+'/'+_0x17abb4)['json'](_0xbfdadb);}return null;};}function patchUpdates(_0xe0ab7c){return function(_0x3cbd3f){try{jsonpatch['apply'](_0x3cbd3f,_0xe0ab7c,!![]);}catch(_0x829c1d){return BPromise['reject'](_0x829c1d);}return _0x3cbd3f[_0x889c('0x27')]();};}function saveUpdates(_0x51c5ea,_0x2eebf5){return function(_0x27637c){if(_0x27637c){return _0x27637c[_0x889c('0x28')](_0x51c5ea)[_0x889c('0x29')](function(_0x2ca488){return _0x2ca488;});}return null;};}function removeEntity(_0x5ea4ae,_0xf01fac){return function(_0x2ecf7b){if(_0x2ecf7b){return _0x2ecf7b[_0x889c('0x2a')]()['then'](function(){_0x5ea4ae['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x18058b,_0x4199c7){return function(_0x4ad854){if(!_0x4ad854){_0x18058b['sendStatus'](0x194);}return _0x4ad854;};}function handleError(_0x3b0698,_0x18c6c4){_0x18c6c4=_0x18c6c4||0x1f4;return function(_0x22c9e8){logger[_0x889c('0x1d')](_0x22c9e8[_0x889c('0x2b')]);if(_0x22c9e8[_0x889c('0x2c')]){delete _0x22c9e8['name'];}_0x3b0698[_0x889c('0x21')](_0x18c6c4)[_0x889c('0x2d')](_0x22c9e8);};}exports[_0x889c('0x2e')]=function(_0x3723b0,_0x4ce379){var _0x26ef92={},_0x24cc23={},_0x2f79ea={'count':0x0,'rows':[]};var _0x4924b6=_['map'](db[_0x889c('0x2f')][_0x889c('0x30')],function(_0x50d5b0){return{'name':_0x50d5b0['fieldName'],'type':_0x50d5b0['type']['key']};});_0x24cc23[_0x889c('0x31')]=_[_0x889c('0x32')](_0x4924b6,'name');_0x24cc23[_0x889c('0x33')]=_['keys'](_0x3723b0[_0x889c('0x33')]);_0x24cc23[_0x889c('0x34')]=_[_0x889c('0x35')](_0x24cc23[_0x889c('0x31')],_0x24cc23[_0x889c('0x33')]);_0x26ef92[_0x889c('0x36')]=_['intersection'](_0x24cc23[_0x889c('0x31')],qs[_0x889c('0x37')](_0x3723b0[_0x889c('0x33')][_0x889c('0x37')]));_0x26ef92[_0x889c('0x36')]=_0x26ef92[_0x889c('0x36')]['length']?_0x26ef92['attributes']:_0x24cc23['model'];if(!_0x3723b0[_0x889c('0x33')][_0x889c('0x38')]('nolimit')){_0x26ef92[_0x889c('0x25')]=qs['limit'](_0x3723b0['query'][_0x889c('0x25')]);_0x26ef92[_0x889c('0x24')]=qs[_0x889c('0x24')](_0x3723b0[_0x889c('0x33')][_0x889c('0x24')]);}_0x26ef92['order']=qs['sort'](_0x3723b0['query']['sort']);_0x26ef92[_0x889c('0x39')]=qs[_0x889c('0x34')](_['pick'](_0x3723b0['query'],_0x24cc23['filters']),_0x4924b6);if(_0x3723b0[_0x889c('0x33')][_0x889c('0x3a')]){_0x26ef92[_0x889c('0x39')]=_[_0x889c('0x3b')](_0x26ef92[_0x889c('0x39')],{'$or':_['map'](_0x4924b6,function(_0xa15f03){if(_0xa15f03['type']!==_0x889c('0x3c')){var _0x415969={};_0x415969[_0xa15f03[_0x889c('0x2c')]]={'$like':'%'+_0x3723b0[_0x889c('0x33')][_0x889c('0x3a')]+'%'};return _0x415969;}})});}_0x26ef92=_[_0x889c('0x3b')]({},_0x26ef92,_0x3723b0[_0x889c('0x3d')]);var _0x2039db={'where':_0x26ef92[_0x889c('0x39')]};return db[_0x889c('0x2f')][_0x889c('0x23')](_0x2039db)['then'](function(_0x1dc37){_0x2f79ea[_0x889c('0x23')]=_0x1dc37;if(_0x3723b0[_0x889c('0x33')][_0x889c('0x3e')]){_0x26ef92[_0x889c('0x3f')]=[{'all':!![]}];}return db[_0x889c('0x2f')][_0x889c('0x40')](_0x26ef92);})['then'](function(_0x4a036b){_0x2f79ea[_0x889c('0x41')]=_0x4a036b;return _0x2f79ea;})[_0x889c('0x29')](respondWithFilteredResult(_0x4ce379,_0x26ef92))[_0x889c('0x1f')](handleError(_0x4ce379,null));};exports['show']=function(_0x3449fc,_0x4e2485){var _0x1b3297={'raw':![],'where':{'id':_0x3449fc['params']['id']}},_0x115665={};_0x115665[_0x889c('0x31')]=_[_0x889c('0x42')](db[_0x889c('0x2f')]['rawAttributes']);_0x115665[_0x889c('0x33')]=_[_0x889c('0x42')](_0x3449fc['query']);_0x115665['filters']=_[_0x889c('0x35')](_0x115665[_0x889c('0x31')],_0x115665[_0x889c('0x33')]);_0x1b3297[_0x889c('0x36')]=_['intersection'](_0x115665[_0x889c('0x31')],qs[_0x889c('0x37')](_0x3449fc[_0x889c('0x33')][_0x889c('0x37')]));_0x1b3297[_0x889c('0x36')]=_0x1b3297[_0x889c('0x36')]['length']?_0x1b3297[_0x889c('0x36')]:_0x115665[_0x889c('0x31')];if(_0x3449fc['query'][_0x889c('0x3e')]){_0x1b3297[_0x889c('0x3f')]=[{'all':!![]}];}_0x1b3297=_['merge']({},_0x1b3297,_0x3449fc['options']);return db['SugarcrmAccount']['find'](_0x1b3297)[_0x889c('0x29')](handleEntityNotFound(_0x4e2485,null))[_0x889c('0x29')](respondWithResult(_0x4e2485,null))[_0x889c('0x1f')](handleError(_0x4e2485,null));};exports[_0x889c('0x43')]=function(_0x629a5c,_0x32d9cb){return db[_0x889c('0x2f')][_0x889c('0x43')](_0x629a5c[_0x889c('0x44')],{})['then'](respondWithResult(_0x32d9cb,0xc9))[_0x889c('0x1f')](handleError(_0x32d9cb,null));};exports['update']=function(_0x4a6241,_0x28f3e1){if(_0x4a6241[_0x889c('0x44')]['id']){delete _0x4a6241[_0x889c('0x44')]['id'];}return db[_0x889c('0x2f')][_0x889c('0x45')]({'where':{'id':_0x4a6241[_0x889c('0x46')]['id']}})['then'](handleEntityNotFound(_0x28f3e1,null))[_0x889c('0x29')](saveUpdates(_0x4a6241[_0x889c('0x44')],null))[_0x889c('0x29')](respondWithResult(_0x28f3e1,null))[_0x889c('0x1f')](handleError(_0x28f3e1,null));};exports['destroy']=function(_0x1a21be,_0x32785c){return db['SugarcrmAccount'][_0x889c('0x45')]({'where':{'id':_0x1a21be[_0x889c('0x46')]['id']}})['then'](handleEntityNotFound(_0x32785c,null))[_0x889c('0x29')](removeEntity(_0x32785c,null))[_0x889c('0x1f')](handleError(_0x32785c,null));};exports[_0x889c('0x47')]=function(_0x32b4c7,_0x124c5b,_0x2fa8ff){var _0x34608e={};var _0x852fa0={};var _0x1aa8c8;var _0x1d0eaf;return db['SugarcrmAccount'][_0x889c('0x48')]({'where':{'id':_0x32b4c7[_0x889c('0x46')]['id']}})['then'](handleEntityNotFound(_0x124c5b,null))[_0x889c('0x29')](function(_0x2c8c0b){if(_0x2c8c0b){_0x1aa8c8=_0x2c8c0b;_0x852fa0[_0x889c('0x31')]=_['keys'](db[_0x889c('0x49')][_0x889c('0x30')]);_0x852fa0[_0x889c('0x33')]=_[_0x889c('0x42')](_0x32b4c7[_0x889c('0x33')]);_0x852fa0[_0x889c('0x34')]=_[_0x889c('0x35')](_0x852fa0['model'],_0x852fa0[_0x889c('0x33')]);_0x34608e[_0x889c('0x36')]=_['intersection'](_0x852fa0['model'],qs[_0x889c('0x37')](_0x32b4c7[_0x889c('0x33')][_0x889c('0x37')]));_0x34608e['attributes']=_0x34608e['attributes'][_0x889c('0x4a')]?_0x34608e[_0x889c('0x36')]:_0x852fa0[_0x889c('0x31')];_0x34608e[_0x889c('0x4b')]=qs[_0x889c('0x4c')](_0x32b4c7[_0x889c('0x33')][_0x889c('0x4c')]);_0x34608e['where']=qs['filters'](_[_0x889c('0x4d')](_0x32b4c7[_0x889c('0x33')],_0x852fa0[_0x889c('0x34')]));if(_0x32b4c7[_0x889c('0x33')]['filter']){_0x34608e['where']=_[_0x889c('0x3b')](_0x34608e[_0x889c('0x39')],{'$or':_[_0x889c('0x32')](_0x34608e[_0x889c('0x36')],function(_0xa74de8){var _0x24286a={};_0x24286a[_0xa74de8]={'$like':'%'+_0x32b4c7[_0x889c('0x33')][_0x889c('0x3a')]+'%'};return _0x24286a;})});}_0x34608e=_['merge']({},_0x34608e,_0x32b4c7[_0x889c('0x3d')]);return _0x1aa8c8[_0x889c('0x47')](_0x34608e);}})[_0x889c('0x29')](function(_0x40f7b6){if(_0x40f7b6){_0x1d0eaf=_0x40f7b6['length'];if(!_0x32b4c7[_0x889c('0x33')][_0x889c('0x38')](_0x889c('0x4e'))){_0x34608e[_0x889c('0x25')]=qs['limit'](_0x32b4c7['query'][_0x889c('0x25')]);_0x34608e[_0x889c('0x24')]=qs[_0x889c('0x24')](_0x32b4c7[_0x889c('0x33')][_0x889c('0x24')]);}return _0x1aa8c8[_0x889c('0x47')](_0x34608e);}})[_0x889c('0x29')](function(_0x12366b){if(_0x12366b){return _0x12366b?{'count':_0x1d0eaf,'rows':_0x12366b}:null;}})[_0x889c('0x29')](respondWithResult(_0x124c5b,null))['catch'](handleError(_0x124c5b,null));};exports['addConfiguration']=function(_0x46a6c0,_0x28a118,_0x5b27b3){if(_0x46a6c0[_0x889c('0x44')]['id']){delete _0x46a6c0[_0x889c('0x44')]['id'];}return db['SugarcrmAccount']['findOne']({'where':{'id':_0x46a6c0[_0x889c('0x46')]['id']}})[_0x889c('0x29')](handleEntityNotFound(_0x28a118,null))[_0x889c('0x29')](function(_0x240b1e){if(_0x240b1e){_0x46a6c0['body']['AccountId']=_0x240b1e['id'];_0x46a6c0[_0x889c('0x44')]['Subjects']=integrations[_0x889c('0x4f')](_0x46a6c0['body']['channel'],_0x46a6c0['body']['type']);_0x46a6c0[_0x889c('0x44')][_0x889c('0x50')]=integrations[_0x889c('0x51')](_0x46a6c0[_0x889c('0x44')]['channel'],_0x46a6c0[_0x889c('0x44')][_0x889c('0x52')]);return db['SugarcrmConfiguration'][_0x889c('0x43')](_0x46a6c0[_0x889c('0x44')],{'include':[{'model':db[_0x889c('0x53')],'as':_0x889c('0x54')},{'model':db[_0x889c('0x53')],'as':_0x889c('0x50')}]});}return null;})['then'](respondWithResult(_0x28a118,null))[_0x889c('0x1f')](handleError(_0x28a118,null));};exports['getFields']=function(_0x2ef521,_0x320b94,_0x1936cb){var _0x53f782='';var _0x2744e4=['id',_0x889c('0x2c'),'assigned_user_id','created_by',_0x889c('0x55'),_0x889c('0x56'),_0x889c('0x57'),_0x889c('0x58'),_0x889c('0x59'),_0x889c('0x5a'),_0x889c('0x5b'),_0x889c('0x5c')];return db[_0x889c('0x2f')][_0x889c('0x48')]({'where':{'id':_0x2ef521[_0x889c('0x46')]['id']},'attributes':['id',_0x889c('0x5d'),_0x889c('0x5e'),_0x889c('0x5f')]})[_0x889c('0x29')](handleEntityNotFound(_0x320b94,null))[_0x889c('0x29')](function(_0x3d1f02){if(_0x3d1f02){_0x53f782=_0x3d1f02[_0x889c('0x5f')];var _0x551f70=_0x53f782[_0x889c('0x60')](-0x1);if(_0x551f70==='/'){_0x53f782=_0x53f782[_0x889c('0x61')](0x0,_0x53f782[_0x889c('0x62')](_0x551f70));}return rp({'method':_0x889c('0x63'),'uri':util['format'](_0x889c('0x64'),_0x53f782,_0x889c('0x65')),'json':!![],'form':{'method':_0x889c('0x66'),'input_type':_0x889c('0x67'),'response_type':_0x889c('0x67'),'rest_data':JSON[_0x889c('0x1c')]({'user_auth':{'user_name':_0x3d1f02['username'],'password':_0x3d1f02[_0x889c('0x5e')],'encryption':_0x889c('0x68')},'application':_0x889c('0x69')})}});}})[_0x889c('0x29')](function(_0x35e935){if(_0x35e935&&_0x35e935['name']!==_0x889c('0x6a')&&_0x35e935[_0x889c('0x2c')]!==_0x889c('0x6b')){return rp({'method':_0x889c('0x63'),'uri':util['format'](_0x889c('0x64'),_0x53f782,_0x889c('0x65')),'json':!![],'form':{'method':_0x889c('0x6c'),'input_type':_0x889c('0x67'),'response_type':_0x889c('0x67'),'rest_data':JSON[_0x889c('0x1c')]({'session':_0x35e935['id'],'module_name':_0x889c('0x6d')})}})[_0x889c('0x29')](function(_0x55f66c){if(_0x55f66c){var _0x138990=_[_0x889c('0x6e')](_0x55f66c[_0x889c('0x6f')]);_[_0x889c('0x70')](_0x138990,function(_0x541b90){return _0x2744e4['includes'](_0x541b90[_0x889c('0x2c')]);});return{'count':_0x138990[_0x889c('0x4a')],'rows':_[_0x889c('0x32')](_0x138990,function(_0x10dd84){return{'id':_0x10dd84[_0x889c('0x2c')],'name':_0x10dd84[_0x889c('0x71')],'custom':_[_0x889c('0x72')](_0x10dd84[_0x889c('0x2c')],'_c')?!![]:![],'options':_0x10dd84[_0x889c('0x3d')]?_[_0x889c('0x32')](_[_0x889c('0x6e')](_0x10dd84['options']),function(_0x505f34){return{'name':_0x505f34['value'],'value':_0x505f34[_0x889c('0x2c')]};}):[]};})};}})[_0x889c('0x29')](respondWithResult(_0x320b94,null))[_0x889c('0x1f')](function(_0xed999c){var _0x4e2ea4=_0x2ef521[_0x889c('0x33')][_0x889c('0x73')]?0x1f4:_0xed999c[_0x889c('0x74')]||0x1f4;logger['error']('getFields,\x20%s,\x20%s,\x20%s','getFields',_0x4e2ea4,JSON[_0x889c('0x1c')](_0xed999c));delete _0xed999c[_0x889c('0x2c')];if(_0x4e2ea4===0x191){_0x4e2ea4=0x190;}_0x320b94[_0x889c('0x21')](_0x4e2ea4)[_0x889c('0x2d')](_0x2ef521[_0x889c('0x33')][_0x889c('0x73')]?{'message':_0x889c('0x75'),'statusCode':_0xed999c[_0x889c('0x74')]}:_0xed999c);});}else{var _0x4f204e=0x1f4;_0x320b94[_0x889c('0x21')](_0x4f204e)[_0x889c('0x2d')]({'message':_0x889c('0x75'),'statusCode':0x190});}});};