e234e8f1598f2c24aefea39e52a9c02e34c59a76
[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 _0xcb31=['../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','../../components/integrations/configuration','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','reject','update','then','destroy','error','stack','name','send','index','map','SugarcrmAccount','rawAttributes','fieldName','type','key','keys','filters','intersection','attributes','model','fields','query','length','hasOwnProperty','nolimit','order','sort','where','pick','VIRTUAL','filter','merge','options','includeAll','include','rows','catch','params','find','create','body','findOne','SugarcrmConfiguration','getConfigurations','AccountId','Subjects','getSubjects','channel','SugarcrmField','Descriptions','getFields','description','date_start','duration_hours','duration_minutes','parent_id','parent_type','parent_name','password','remoteUri','slice','substring','POST','format','%s%s','/service/v4_1/rest.php','login','JSON','stringify','PLAIN','Password\x20Expired','get_module_fields','Calls','values','module_fields','remove','includes','value','statusCode','Wrong\x20credentials','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','fs-extra','crypto','papaparse','ioredis','../../components/auth/service'];(function(_0x5f34ad,_0x19f168){var _0x29970e=function(_0x5a8d5c){while(--_0x5a8d5c){_0x5f34ad['push'](_0x5f34ad['shift']());}};_0x29970e(++_0x19f168);}(_0xcb31,0x149));var _0x1cb3=function(_0x4736bc,_0x3db411){_0x4736bc=_0x4736bc-0x0;var _0x1a237d=_0xcb31[_0x4736bc];return _0x1a237d;};'use strict';var emlformat=require(_0x1cb3('0x0'));var rimraf=require(_0x1cb3('0x1'));var zipdir=require(_0x1cb3('0x2'));var jsonpatch=require(_0x1cb3('0x3'));var rp=require(_0x1cb3('0x4'));var moment=require(_0x1cb3('0x5'));var BPromise=require(_0x1cb3('0x6'));var Mustache=require('mustache');var util=require(_0x1cb3('0x7'));var path=require(_0x1cb3('0x8'));var sox=require(_0x1cb3('0x9'));var csv=require(_0x1cb3('0xa'));var ejs=require('ejs');var fs=require('fs');var fs_extra=require(_0x1cb3('0xb'));var _=require('lodash');var squel=require('squel');var crypto=require(_0x1cb3('0xc'));var jsforce=require('jsforce');var deskjs=require('desk.js');var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0x1cb3('0xd'));var Redis=require(_0x1cb3('0xe'));var authService=require(_0x1cb3('0xf'));var qs=require(_0x1cb3('0x10'));var as=require(_0x1cb3('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x1cb3('0x12'))(_0x1cb3('0x13'));var utils=require(_0x1cb3('0x14'));var config=require(_0x1cb3('0x15'));var licenseUtil=require('../../config/license/util');var db=require(_0x1cb3('0x16'))['db'];var integrations=require(_0x1cb3('0x17'));function respondWithStatusCode(_0x40bd04,_0x2d90de){_0x2d90de=_0x2d90de||0xcc;return function(_0x3edfb3){if(_0x3edfb3){return _0x40bd04[_0x1cb3('0x18')](_0x2d90de);}return _0x40bd04[_0x1cb3('0x19')](_0x2d90de)[_0x1cb3('0x1a')]();};}function respondWithResult(_0x504023,_0x5dd514){_0x5dd514=_0x5dd514||0xc8;return function(_0x214f3a){if(_0x214f3a){return _0x504023[_0x1cb3('0x19')](_0x5dd514)[_0x1cb3('0x1b')](_0x214f3a);}};}function respondWithFilteredResult(_0x129f69,_0x1e6173){return function(_0x246745){if(_0x246745){var _0x353ef8=typeof _0x1e6173[_0x1cb3('0x1c')]===_0x1cb3('0x1d')&&typeof _0x1e6173[_0x1cb3('0x1e')]===_0x1cb3('0x1d');var _0x524640=_0x246745[_0x1cb3('0x1f')];var _0x5d9ba3=_0x353ef8?0x0:_0x1e6173['offset'];var _0x3cdfbf=_0x353ef8?_0x246745[_0x1cb3('0x1f')]:_0x1e6173[_0x1cb3('0x1c')]+_0x1e6173[_0x1cb3('0x1e')];var _0x2500ea;if(_0x3cdfbf>=_0x524640){_0x3cdfbf=_0x524640;_0x2500ea=0xc8;}else{_0x2500ea=0xce;}_0x129f69[_0x1cb3('0x19')](_0x2500ea);return _0x129f69[_0x1cb3('0x20')](_0x1cb3('0x21'),_0x5d9ba3+'-'+_0x3cdfbf+'/'+_0x524640)['json'](_0x246745);}return null;};}function patchUpdates(_0x65c4a){return function(_0x212d78){try{jsonpatch[_0x1cb3('0x22')](_0x212d78,_0x65c4a,!![]);}catch(_0x22c0b9){return BPromise[_0x1cb3('0x23')](_0x22c0b9);}return _0x212d78['save']();};}function saveUpdates(_0x477398,_0x239c69){return function(_0x525c71){if(_0x525c71){return _0x525c71[_0x1cb3('0x24')](_0x477398)[_0x1cb3('0x25')](function(_0x2e0041){return _0x2e0041;});}return null;};}function removeEntity(_0x57bcdb,_0x3ff798){return function(_0x679824){if(_0x679824){return _0x679824[_0x1cb3('0x26')]()['then'](function(){_0x57bcdb[_0x1cb3('0x19')](0xcc)[_0x1cb3('0x1a')]();});}};}function handleEntityNotFound(_0x2768fc,_0xa19950){return function(_0x46929d){if(!_0x46929d){_0x2768fc[_0x1cb3('0x18')](0x194);}return _0x46929d;};}function handleError(_0x3b40f4,_0x4fb983){_0x4fb983=_0x4fb983||0x1f4;return function(_0x524693){logger[_0x1cb3('0x27')](_0x524693[_0x1cb3('0x28')]);if(_0x524693[_0x1cb3('0x29')]){delete _0x524693[_0x1cb3('0x29')];}_0x3b40f4['status'](_0x4fb983)[_0x1cb3('0x2a')](_0x524693);};}exports[_0x1cb3('0x2b')]=function(_0x10bcd7,_0x5a19ed){var _0x8ea177={},_0x400d5b={},_0x307ca7={'count':0x0,'rows':[]};var _0x14c634=_[_0x1cb3('0x2c')](db[_0x1cb3('0x2d')][_0x1cb3('0x2e')],function(_0x35b79f){return{'name':_0x35b79f[_0x1cb3('0x2f')],'type':_0x35b79f[_0x1cb3('0x30')][_0x1cb3('0x31')]};});_0x400d5b['model']=_['map'](_0x14c634,_0x1cb3('0x29'));_0x400d5b['query']=_[_0x1cb3('0x32')](_0x10bcd7['query']);_0x400d5b[_0x1cb3('0x33')]=_[_0x1cb3('0x34')](_0x400d5b['model'],_0x400d5b['query']);_0x8ea177[_0x1cb3('0x35')]=_['intersection'](_0x400d5b[_0x1cb3('0x36')],qs[_0x1cb3('0x37')](_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x37')]));_0x8ea177[_0x1cb3('0x35')]=_0x8ea177[_0x1cb3('0x35')][_0x1cb3('0x39')]?_0x8ea177['attributes']:_0x400d5b['model'];if(!_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x3a')](_0x1cb3('0x3b'))){_0x8ea177[_0x1cb3('0x1e')]=qs[_0x1cb3('0x1e')](_0x10bcd7[_0x1cb3('0x38')]['limit']);_0x8ea177[_0x1cb3('0x1c')]=qs[_0x1cb3('0x1c')](_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x1c')]);}_0x8ea177[_0x1cb3('0x3c')]=qs[_0x1cb3('0x3d')](_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x3d')]);_0x8ea177[_0x1cb3('0x3e')]=qs[_0x1cb3('0x33')](_[_0x1cb3('0x3f')](_0x10bcd7[_0x1cb3('0x38')],_0x400d5b[_0x1cb3('0x33')]),_0x14c634);if(_0x10bcd7[_0x1cb3('0x38')]['filter']){_0x8ea177[_0x1cb3('0x3e')]=_['merge'](_0x8ea177[_0x1cb3('0x3e')],{'$or':_['map'](_0x14c634,function(_0x25388e){if(_0x25388e[_0x1cb3('0x30')]!==_0x1cb3('0x40')){var _0x4a76f6={};_0x4a76f6[_0x25388e[_0x1cb3('0x29')]]={'$like':'%'+_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x41')]+'%'};return _0x4a76f6;}})});}_0x8ea177=_[_0x1cb3('0x42')]({},_0x8ea177,_0x10bcd7[_0x1cb3('0x43')]);var _0x5c644b={'where':_0x8ea177[_0x1cb3('0x3e')]};return db['SugarcrmAccount'][_0x1cb3('0x1f')](_0x5c644b)[_0x1cb3('0x25')](function(_0x3868ac){_0x307ca7[_0x1cb3('0x1f')]=_0x3868ac;if(_0x10bcd7[_0x1cb3('0x38')][_0x1cb3('0x44')]){_0x8ea177[_0x1cb3('0x45')]=[{'all':!![]}];}return db[_0x1cb3('0x2d')]['findAll'](_0x8ea177);})[_0x1cb3('0x25')](function(_0x55f37e){_0x307ca7[_0x1cb3('0x46')]=_0x55f37e;return _0x307ca7;})[_0x1cb3('0x25')](respondWithFilteredResult(_0x5a19ed,_0x8ea177))[_0x1cb3('0x47')](handleError(_0x5a19ed,null));};exports['show']=function(_0x2b149f,_0x2df709){var _0x5c98dd={'raw':![],'where':{'id':_0x2b149f[_0x1cb3('0x48')]['id']}},_0x157e8a={};_0x157e8a[_0x1cb3('0x36')]=_[_0x1cb3('0x32')](db['SugarcrmAccount']['rawAttributes']);_0x157e8a[_0x1cb3('0x38')]=_[_0x1cb3('0x32')](_0x2b149f[_0x1cb3('0x38')]);_0x157e8a[_0x1cb3('0x33')]=_['intersection'](_0x157e8a['model'],_0x157e8a['query']);_0x5c98dd[_0x1cb3('0x35')]=_[_0x1cb3('0x34')](_0x157e8a['model'],qs[_0x1cb3('0x37')](_0x2b149f[_0x1cb3('0x38')][_0x1cb3('0x37')]));_0x5c98dd[_0x1cb3('0x35')]=_0x5c98dd['attributes'][_0x1cb3('0x39')]?_0x5c98dd[_0x1cb3('0x35')]:_0x157e8a[_0x1cb3('0x36')];if(_0x2b149f[_0x1cb3('0x38')][_0x1cb3('0x44')]){_0x5c98dd['include']=[{'all':!![]}];}_0x5c98dd=_['merge']({},_0x5c98dd,_0x2b149f[_0x1cb3('0x43')]);return db['SugarcrmAccount'][_0x1cb3('0x49')](_0x5c98dd)[_0x1cb3('0x25')](handleEntityNotFound(_0x2df709,null))[_0x1cb3('0x25')](respondWithResult(_0x2df709,null))[_0x1cb3('0x47')](handleError(_0x2df709,null));};exports[_0x1cb3('0x4a')]=function(_0x22311c,_0x1a86a2){return db[_0x1cb3('0x2d')][_0x1cb3('0x4a')](_0x22311c[_0x1cb3('0x4b')],{})['then'](respondWithResult(_0x1a86a2,0xc9))[_0x1cb3('0x47')](handleError(_0x1a86a2,null));};exports['update']=function(_0x1b30e8,_0x47d702){if(_0x1b30e8['body']['id']){delete _0x1b30e8[_0x1cb3('0x4b')]['id'];}return db[_0x1cb3('0x2d')][_0x1cb3('0x49')]({'where':{'id':_0x1b30e8['params']['id']}})[_0x1cb3('0x25')](handleEntityNotFound(_0x47d702,null))[_0x1cb3('0x25')](saveUpdates(_0x1b30e8[_0x1cb3('0x4b')],null))[_0x1cb3('0x25')](respondWithResult(_0x47d702,null))[_0x1cb3('0x47')](handleError(_0x47d702,null));};exports[_0x1cb3('0x26')]=function(_0x5d1e21,_0x1b9567){return db[_0x1cb3('0x2d')][_0x1cb3('0x49')]({'where':{'id':_0x5d1e21[_0x1cb3('0x48')]['id']}})[_0x1cb3('0x25')](handleEntityNotFound(_0x1b9567,null))[_0x1cb3('0x25')](removeEntity(_0x1b9567,null))[_0x1cb3('0x47')](handleError(_0x1b9567,null));};exports['getConfigurations']=function(_0x2edbf7,_0x2f5349,_0x229dfd){var _0xf319a8={};var _0x27f1de={};var _0x589800;var _0x52cb8a;return db[_0x1cb3('0x2d')][_0x1cb3('0x4c')]({'where':{'id':_0x2edbf7['params']['id']}})[_0x1cb3('0x25')](handleEntityNotFound(_0x2f5349,null))[_0x1cb3('0x25')](function(_0x2bcad9){if(_0x2bcad9){_0x589800=_0x2bcad9;_0x27f1de[_0x1cb3('0x36')]=_['keys'](db[_0x1cb3('0x4d')][_0x1cb3('0x2e')]);_0x27f1de[_0x1cb3('0x38')]=_[_0x1cb3('0x32')](_0x2edbf7[_0x1cb3('0x38')]);_0x27f1de['filters']=_['intersection'](_0x27f1de[_0x1cb3('0x36')],_0x27f1de[_0x1cb3('0x38')]);_0xf319a8[_0x1cb3('0x35')]=_[_0x1cb3('0x34')](_0x27f1de[_0x1cb3('0x36')],qs['fields'](_0x2edbf7[_0x1cb3('0x38')][_0x1cb3('0x37')]));_0xf319a8[_0x1cb3('0x35')]=_0xf319a8['attributes'][_0x1cb3('0x39')]?_0xf319a8[_0x1cb3('0x35')]:_0x27f1de['model'];_0xf319a8[_0x1cb3('0x3c')]=qs[_0x1cb3('0x3d')](_0x2edbf7[_0x1cb3('0x38')]['sort']);_0xf319a8[_0x1cb3('0x3e')]=qs[_0x1cb3('0x33')](_[_0x1cb3('0x3f')](_0x2edbf7[_0x1cb3('0x38')],_0x27f1de[_0x1cb3('0x33')]));if(_0x2edbf7['query'][_0x1cb3('0x41')]){_0xf319a8['where']=_[_0x1cb3('0x42')](_0xf319a8['where'],{'$or':_[_0x1cb3('0x2c')](_0xf319a8[_0x1cb3('0x35')],function(_0x2f2992){var _0x16f0d7={};_0x16f0d7[_0x2f2992]={'$like':'%'+_0x2edbf7[_0x1cb3('0x38')][_0x1cb3('0x41')]+'%'};return _0x16f0d7;})});}_0xf319a8=_['merge']({},_0xf319a8,_0x2edbf7[_0x1cb3('0x43')]);return _0x589800[_0x1cb3('0x4e')](_0xf319a8);}})[_0x1cb3('0x25')](function(_0x3d228d){if(_0x3d228d){_0x52cb8a=_0x3d228d['length'];if(!_0x2edbf7['query'][_0x1cb3('0x3a')](_0x1cb3('0x3b'))){_0xf319a8[_0x1cb3('0x1e')]=qs[_0x1cb3('0x1e')](_0x2edbf7['query'][_0x1cb3('0x1e')]);_0xf319a8[_0x1cb3('0x1c')]=qs[_0x1cb3('0x1c')](_0x2edbf7['query'][_0x1cb3('0x1c')]);}return _0x589800[_0x1cb3('0x4e')](_0xf319a8);}})['then'](function(_0x991ac9){if(_0x991ac9){return _0x991ac9?{'count':_0x52cb8a,'rows':_0x991ac9}:null;}})[_0x1cb3('0x25')](respondWithResult(_0x2f5349,null))[_0x1cb3('0x47')](handleError(_0x2f5349,null));};exports['addConfiguration']=function(_0x2ccfa7,_0x448ad5,_0x233eec){if(_0x2ccfa7['body']['id']){delete _0x2ccfa7[_0x1cb3('0x4b')]['id'];}return db['SugarcrmAccount'][_0x1cb3('0x4c')]({'where':{'id':_0x2ccfa7[_0x1cb3('0x48')]['id']}})[_0x1cb3('0x25')](handleEntityNotFound(_0x448ad5,null))['then'](function(_0x553d67){if(_0x553d67){_0x2ccfa7['body'][_0x1cb3('0x4f')]=_0x553d67['id'];_0x2ccfa7[_0x1cb3('0x4b')][_0x1cb3('0x50')]=integrations[_0x1cb3('0x51')](_0x2ccfa7[_0x1cb3('0x4b')]['channel'],_0x2ccfa7[_0x1cb3('0x4b')][_0x1cb3('0x30')]);_0x2ccfa7[_0x1cb3('0x4b')]['Descriptions']=integrations['getDescriptions'](_0x2ccfa7['body'][_0x1cb3('0x52')],_0x2ccfa7[_0x1cb3('0x4b')]['type']);return db[_0x1cb3('0x4d')][_0x1cb3('0x4a')](_0x2ccfa7['body'],{'include':[{'model':db[_0x1cb3('0x53')],'as':'Subjects'},{'model':db['SugarcrmField'],'as':_0x1cb3('0x54')}]});}return null;})[_0x1cb3('0x25')](respondWithResult(_0x448ad5,null))['catch'](handleError(_0x448ad5,null));};exports[_0x1cb3('0x55')]=function(_0x1e0107,_0x4710d5,_0x11d84d){var _0x145ad8='';var _0x4f7716=['id','name','assigned_user_id','created_by',_0x1cb3('0x56'),_0x1cb3('0x57'),_0x1cb3('0x58'),_0x1cb3('0x59'),_0x1cb3('0x5a'),_0x1cb3('0x5b'),_0x1cb3('0x5c'),'direction'];return db[_0x1cb3('0x2d')][_0x1cb3('0x4c')]({'where':{'id':_0x1e0107['params']['id']},'attributes':['id','username',_0x1cb3('0x5d'),'remoteUri']})[_0x1cb3('0x25')](handleEntityNotFound(_0x4710d5,null))[_0x1cb3('0x25')](function(_0x3ca673){if(_0x3ca673){_0x145ad8=_0x3ca673[_0x1cb3('0x5e')];var _0x19c3f1=_0x145ad8[_0x1cb3('0x5f')](-0x1);if(_0x19c3f1==='/'){_0x145ad8=_0x145ad8[_0x1cb3('0x60')](0x0,_0x145ad8['lastIndexOf'](_0x19c3f1));}return rp({'method':_0x1cb3('0x61'),'uri':util[_0x1cb3('0x62')](_0x1cb3('0x63'),_0x145ad8,_0x1cb3('0x64')),'json':!![],'form':{'method':_0x1cb3('0x65'),'input_type':_0x1cb3('0x66'),'response_type':_0x1cb3('0x66'),'rest_data':JSON[_0x1cb3('0x67')]({'user_auth':{'user_name':_0x3ca673['username'],'password':_0x3ca673[_0x1cb3('0x5d')],'encryption':_0x1cb3('0x68')},'application':'xCALLY\x20Motion\x20Integration'})}});}})[_0x1cb3('0x25')](function(_0x5e13a2){if(_0x5e13a2&&_0x5e13a2['name']!=='Invalid\x20Login'&&_0x5e13a2[_0x1cb3('0x29')]!==_0x1cb3('0x69')){return rp({'method':_0x1cb3('0x61'),'uri':util[_0x1cb3('0x62')](_0x1cb3('0x63'),_0x145ad8,'/service/v4_1/rest.php'),'json':!![],'form':{'method':_0x1cb3('0x6a'),'input_type':_0x1cb3('0x66'),'response_type':'JSON','rest_data':JSON[_0x1cb3('0x67')]({'session':_0x5e13a2['id'],'module_name':_0x1cb3('0x6b')})}})['then'](function(_0x52eb60){if(_0x52eb60){var _0x3f8d63=_[_0x1cb3('0x6c')](_0x52eb60[_0x1cb3('0x6d')]);_[_0x1cb3('0x6e')](_0x3f8d63,function(_0xf428cc){return _0x4f7716[_0x1cb3('0x6f')](_0xf428cc[_0x1cb3('0x29')]);});return{'count':_0x3f8d63[_0x1cb3('0x39')],'rows':_[_0x1cb3('0x2c')](_0x3f8d63,function(_0x4e7a7c){return{'id':_0x4e7a7c[_0x1cb3('0x29')],'name':_0x4e7a7c['label'],'custom':_['endsWith'](_0x4e7a7c[_0x1cb3('0x29')],'_c')?!![]:![],'options':_0x4e7a7c[_0x1cb3('0x43')]?_['map'](_['values'](_0x4e7a7c['options']),function(_0x230f21){return{'name':_0x230f21[_0x1cb3('0x70')],'value':_0x230f21[_0x1cb3('0x29')]};}):[]};})};}})[_0x1cb3('0x25')](respondWithResult(_0x4710d5,null))[_0x1cb3('0x47')](function(_0x57145a){var _0x18283f=_0x1e0107[_0x1cb3('0x38')]['test']?0x1f4:_0x57145a[_0x1cb3('0x71')]||0x1f4;logger[_0x1cb3('0x27')]('getFields,\x20%s,\x20%s,\x20%s',_0x1cb3('0x55'),_0x18283f,JSON[_0x1cb3('0x67')](_0x57145a));delete _0x57145a[_0x1cb3('0x29')];if(_0x18283f===0x191){_0x18283f=0x190;}_0x4710d5[_0x1cb3('0x19')](_0x18283f)[_0x1cb3('0x2a')](_0x1e0107[_0x1cb3('0x38')]['test']?{'message':'Wrong\x20credentials','statusCode':_0x57145a['statusCode']}:_0x57145a);});}else{var _0x38c99f=0x1f4;_0x4710d5['status'](_0x38c99f)[_0x1cb3('0x2a')]({'message':_0x1cb3('0x72'),'statusCode':0x190});}});};