18 var _0xda46=['json','count','limit','set','Content-Range','apply','reject','save','update','then','name','send','model','keys','OpenchannelInteraction','rawAttributes','query','dateStart','dateEnd','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','offset','sort','where','pick','day','filter','map','merge','options','include','tag','push','Tag','Tags','distinct','OpenchannelMessage','Messages','read','User','Users','Contact','Owner','fullname','internal','OpenchannelAccount','Account','key','direction','createdAt','ThroughTags','color','findAll','catch','params','find','create','body','destroy','describe','addMessage','omit','ids','getMessages','findOne','$gte','split','format','YYYY-MM-DD\x20HH:mm:ss','includeAll','setTags','emit','openchannelInteractionTags:save','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','lodash','desk.js','papaparse','../../components/parsers/qs','../../config/logger','api','../../config/utils','../../config/environment','../../mysqldb','socket.io-emitter','localhost','sendStatus','end','status'];(function(_0x3070dc,_0x40cf11){var _0x431489=function(_0x49bc2a){while(--_0x49bc2a){_0x3070dc['push'](_0x3070dc['shift']());}};_0x431489(++_0x40cf11);}(_0xda46,0x118));var _0x6da4=function(_0x4d5015,_0xd336c3){_0x4d5015=_0x4d5015-0x0;var _0x1e9c12=_0xda46[_0x4d5015];return _0x1e9c12;};'use strict';var jsonpatch=require('fast-json-patch');var rp=require(_0x6da4('0x0'));var moment=require(_0x6da4('0x1'));var BPromise=require(_0x6da4('0x2'));var Mustache=require(_0x6da4('0x3'));var util=require(_0x6da4('0x4'));var path=require(_0x6da4('0x5'));var sox=require(_0x6da4('0x6'));var csv=require(_0x6da4('0x7'));var ejs=require(_0x6da4('0x8'));var fs=require('fs');var _=require(_0x6da4('0x9'));var squel=require('squel');var crypto=require('crypto');var jsforce=require('jsforce');var deskjs=require(_0x6da4('0xa'));var toCsv=require(_0x6da4('0x7'));var querystring=require('querystring');var Papa=require(_0x6da4('0xb'));var qs=require(_0x6da4('0xc'));var logger=require(_0x6da4('0xd'))(_0x6da4('0xe'));var utils=require(_0x6da4('0xf'));var config=require(_0x6da4('0x10'));var db=require(_0x6da4('0x11'))['db'];var socket=require(_0x6da4('0x12'))({'host':_0x6da4('0x13'),'port':0x18eb});require('./openchannelInteraction.socket')['register'](socket);function respondWithStatusCode(_0x2ee971,_0x50c275){_0x50c275=_0x50c275||0xcc;return function(_0xb3c31a){if(_0xb3c31a){return _0x2ee971[_0x6da4('0x14')](_0x50c275);}return _0x2ee971['status'](_0x50c275)[_0x6da4('0x15')]();};}function respondWithResult(_0x2a63c8,_0x590ff1){_0x590ff1=_0x590ff1||0xc8;return function(_0x4236e8){if(_0x4236e8){return _0x2a63c8[_0x6da4('0x16')](_0x590ff1)[_0x6da4('0x17')](_0x4236e8);}};}function respondWithFilteredResult(_0x2303d5,_0x1b68c5){return function(_0x377f5e){if(_0x377f5e){var _0xa79002=_0x377f5e[_0x6da4('0x18')],_0x2ba25f=_0x1b68c5['offset'],_0x293d7b=_0x1b68c5['offset']+_0x1b68c5[_0x6da4('0x19')],_0xbaaaec;if(_0x293d7b>=_0xa79002){_0x293d7b=_0xa79002;_0xbaaaec=0xc8;}else{_0xbaaaec=0xce;}_0x2303d5[_0x6da4('0x16')](_0xbaaaec);return _0x2303d5[_0x6da4('0x1a')](_0x6da4('0x1b'),_0x2ba25f+'-'+_0x293d7b+'/'+_0xa79002)[_0x6da4('0x17')](_0x377f5e);}return null;};}function patchUpdates(_0x2699aa){return function(_0x25e6b9){try{jsonpatch[_0x6da4('0x1c')](_0x25e6b9,_0x2699aa,!![]);}catch(_0x3a83d1){return BPromise[_0x6da4('0x1d')](_0x3a83d1);}return _0x25e6b9[_0x6da4('0x1e')]();};}function saveUpdates(_0x3798b6,_0x1da4eb){return function(_0x56be4d){if(_0x56be4d){return _0x56be4d[_0x6da4('0x1f')](_0x3798b6)[_0x6da4('0x20')](function(_0x4b797b){return _0x4b797b;});}return null;};}function removeEntity(_0x2e52c1,_0x1e7385){return function(_0x160f4e){if(_0x160f4e){return _0x160f4e['destroy']()['then'](function(){_0x2e52c1[_0x6da4('0x16')](0xcc)[_0x6da4('0x15')]();});}};}function handleEntityNotFound(_0x389dd3,_0x5da9ff){return function(_0x3eff22){if(!_0x3eff22){_0x389dd3[_0x6da4('0x14')](0x194);}return _0x3eff22;};}function handleError(_0x52faee,_0x1baecc){_0x1baecc=_0x1baecc||0x1f4;return function(_0x24225b){logger['error'](_0x24225b['stack']);if(_0x24225b['name']){delete _0x24225b[_0x6da4('0x21')];}_0x52faee[_0x6da4('0x16')](_0x1baecc)[_0x6da4('0x22')](_0x24225b);};}exports['index']=function(_0x2428d1,_0x53161e){var _0x5137ac={},_0x57e7bd={},_0x33a0a9={'count':0x0,'rows':[]};_0x57e7bd[_0x6da4('0x23')]=_[_0x6da4('0x24')](db[_0x6da4('0x25')][_0x6da4('0x26')]);var _0xa96e04={'dateStart':_0x2428d1[_0x6da4('0x27')][_0x6da4('0x28')],'dateEnd':_0x2428d1['query'][_0x6da4('0x29')]};delete _0x2428d1[_0x6da4('0x27')][_0x6da4('0x28')];delete _0x2428d1['query'][_0x6da4('0x29')];_0x57e7bd[_0x6da4('0x27')]=_[_0x6da4('0x24')](_0x2428d1[_0x6da4('0x27')]);_0x57e7bd[_0x6da4('0x2a')]=_[_0x6da4('0x2b')](_0x57e7bd['model'],_0x57e7bd[_0x6da4('0x27')]);_0x5137ac[_0x6da4('0x2c')]=_[_0x6da4('0x2b')](_0x57e7bd[_0x6da4('0x23')],qs[_0x6da4('0x2d')](_0x2428d1[_0x6da4('0x27')][_0x6da4('0x2d')]));_0x5137ac['attributes']=_0x5137ac[_0x6da4('0x2c')][_0x6da4('0x2e')]?_0x5137ac[_0x6da4('0x2c')]:_0x57e7bd[_0x6da4('0x23')];if(!_0x2428d1[_0x6da4('0x27')][_0x6da4('0x2f')](_0x6da4('0x30'))){_0x5137ac[_0x6da4('0x19')]=qs[_0x6da4('0x19')](_0x2428d1[_0x6da4('0x27')][_0x6da4('0x19')]);_0x5137ac[_0x6da4('0x31')]=qs[_0x6da4('0x31')](_0x2428d1[_0x6da4('0x27')][_0x6da4('0x31')]);}_0x5137ac['order']=qs['sort'](_0x2428d1['query'][_0x6da4('0x32')]);_0x5137ac[_0x6da4('0x33')]=qs['filters'](_[_0x6da4('0x34')](_0x2428d1[_0x6da4('0x27')],_0x57e7bd[_0x6da4('0x2a')]));if(_0xa96e04[_0x6da4('0x28')]){if(_0xa96e04[_0x6da4('0x29')]){_0xa96e04['dateEnd']=moment(_0xa96e04[_0x6da4('0x29')])['add'](0x1,_0x6da4('0x35'));}else{_0xa96e04['dateEnd']=moment(_0xa96e04[_0x6da4('0x28')])['add'](0x1,'day');}_['merge'](_0x5137ac['where'],{'createdAt':{'$gte':_0xa96e04[_0x6da4('0x28')],'$lte':_0xa96e04[_0x6da4('0x29')]}});}if(_0x2428d1[_0x6da4('0x27')][_0x6da4('0x36')]){_0x5137ac[_0x6da4('0x33')]=_['merge'](_0x5137ac['where'],{'$or':_[_0x6da4('0x37')](_0x5137ac[_0x6da4('0x2c')],function(_0x4a636e){var _0x70b828={};_0x70b828[_0x4a636e]={'$like':'%'+_0x2428d1['query'][_0x6da4('0x36')]+'%'};return _0x70b828;})});}_0x5137ac=_[_0x6da4('0x38')]({},_0x5137ac,_0x2428d1[_0x6da4('0x39')]);var _0x10facf={'where':_0x5137ac[_0x6da4('0x33')]};_0x10facf[_0x6da4('0x3a')]=[];if(_0x2428d1['query'][_0x6da4('0x3b')]){_0x10facf[_0x6da4('0x3a')][_0x6da4('0x3c')]({'model':db[_0x6da4('0x3d')],'as':_0x6da4('0x3e'),'attributes':['id'],'where':{'id':_0x2428d1[_0x6da4('0x27')][_0x6da4('0x3b')]},'required':!![]});_0x10facf[_0x6da4('0x3f')]=!![];}if(_0x2428d1[_0x6da4('0x27')]['read']){_0x10facf[_0x6da4('0x3a')][_0x6da4('0x3c')]({'model':db[_0x6da4('0x40')],'as':_0x6da4('0x41'),'attributes':['id','direction','createdAt',_0x6da4('0x42')],'where':{'direction':'in','read':_0x2428d1[_0x6da4('0x27')]['read']||![]},'required':!![]});_0x10facf['distinct']=!![];}return db['OpenchannelInteraction'][_0x6da4('0x18')](_0x10facf)[_0x6da4('0x20')](function(_0x72006d){_0x33a0a9['count']=_0x72006d;if(_0x2428d1[_0x6da4('0x27')]['includeAll']){_0x5137ac[_0x6da4('0x3a')]=[{'model':db[_0x6da4('0x43')],'as':_0x6da4('0x44'),'required':![],'attributes':['id',_0x6da4('0x21'),'fullname']},{'model':db['CmContact'],'as':_0x6da4('0x45'),'required':![]},{'model':db[_0x6da4('0x43')],'as':_0x6da4('0x46'),'attributes':[_0x6da4('0x21'),_0x6da4('0x47'),_0x6da4('0x48')],'required':![]},{'model':db[_0x6da4('0x49')],'as':_0x6da4('0x4a'),'attributes':[_0x6da4('0x21'),_0x6da4('0x4b')],'required':![]},{'model':db['OpenchannelMessage'],'as':_0x6da4('0x41'),'attributes':['id',_0x6da4('0x4c'),_0x6da4('0x4d'),_0x6da4('0x42')],'where':{'direction':'in','read':_0x2428d1[_0x6da4('0x27')][_0x6da4('0x42')]||![]},'required':_0x2428d1['query'][_0x6da4('0x42')]||![]},{'model':db[_0x6da4('0x3d')],'as':_0x6da4('0x3e'),'attributes':['id',_0x6da4('0x21'),'color'],'required':_0x2428d1['query'][_0x6da4('0x3b')]?!![]:![]},{'model':db['Tag'],'as':_0x6da4('0x4e'),'attributes':['id',_0x6da4('0x21'),_0x6da4('0x4f')],'through':_0x2428d1['query'][_0x6da4('0x3b')]?{'attributes':[],'where':{'TagId':_0x2428d1[_0x6da4('0x27')][_0x6da4('0x3b')]||undefined}}:{},'required':_0x2428d1[_0x6da4('0x27')][_0x6da4('0x3b')]?!![]:![]}];}return db[_0x6da4('0x25')][_0x6da4('0x50')](_0x5137ac);})['then'](function(_0x30bf40){_0x33a0a9['rows']=_0x30bf40;return _0x33a0a9;})[_0x6da4('0x20')](respondWithFilteredResult(_0x53161e,_0x5137ac))[_0x6da4('0x51')](handleError(_0x53161e,null));};exports['show']=function(_0x4ffd44,_0x421343){var _0xf3e0a9={'raw':![],'where':{'id':_0x4ffd44[_0x6da4('0x52')]['id']}},_0x4e88d9={};_0x4e88d9[_0x6da4('0x23')]=_['keys'](db['OpenchannelInteraction'][_0x6da4('0x26')]);_0x4e88d9[_0x6da4('0x27')]=_[_0x6da4('0x24')](_0x4ffd44[_0x6da4('0x27')]);_0x4e88d9[_0x6da4('0x2a')]=_[_0x6da4('0x2b')](_0x4e88d9[_0x6da4('0x23')],_0x4e88d9['query']);_0xf3e0a9['attributes']=_[_0x6da4('0x2b')](_0x4e88d9[_0x6da4('0x23')],qs[_0x6da4('0x2d')](_0x4ffd44[_0x6da4('0x27')][_0x6da4('0x2d')]));_0xf3e0a9['attributes']=_0xf3e0a9[_0x6da4('0x2c')][_0x6da4('0x2e')]?_0xf3e0a9[_0x6da4('0x2c')]:_0x4e88d9[_0x6da4('0x23')];if(_0x4ffd44['query']['includeAll']){_0xf3e0a9['include']=[{'all':!![]}];}_0xf3e0a9=_[_0x6da4('0x38')]({},_0xf3e0a9,_0x4ffd44[_0x6da4('0x39')]);return db['OpenchannelInteraction'][_0x6da4('0x53')](_0xf3e0a9)[_0x6da4('0x20')](handleEntityNotFound(_0x421343,null))[_0x6da4('0x20')](respondWithResult(_0x421343,null))[_0x6da4('0x51')](handleError(_0x421343,null));};exports['create']=function(_0x4c8e48,_0x14a007){return db[_0x6da4('0x25')][_0x6da4('0x54')](_0x4c8e48[_0x6da4('0x55')],{})[_0x6da4('0x20')](respondWithResult(_0x14a007,0xc9))[_0x6da4('0x51')](handleError(_0x14a007,null));};exports[_0x6da4('0x1f')]=function(_0x5f4e08,_0x48f427){if(_0x5f4e08[_0x6da4('0x55')]['id']){delete _0x5f4e08[_0x6da4('0x55')]['id'];}return db[_0x6da4('0x25')][_0x6da4('0x53')]({'where':{'id':_0x5f4e08['params']['id']}})['then'](handleEntityNotFound(_0x48f427,null))[_0x6da4('0x20')](saveUpdates(_0x5f4e08[_0x6da4('0x55')],null))[_0x6da4('0x20')](respondWithResult(_0x48f427,null))['catch'](handleError(_0x48f427,null));};exports[_0x6da4('0x56')]=function(_0x1c1c0c,_0x559e09){return db[_0x6da4('0x25')][_0x6da4('0x53')]({'where':{'id':_0x1c1c0c['params']['id']}})[_0x6da4('0x20')](handleEntityNotFound(_0x559e09,null))['then'](removeEntity(_0x559e09,null))['catch'](handleError(_0x559e09,null));};exports[_0x6da4('0x57')]=function(_0x446aca,_0x29b16b){return db[_0x6da4('0x25')][_0x6da4('0x57')]()[_0x6da4('0x20')](respondWithResult(_0x29b16b,null))[_0x6da4('0x51')](handleError(_0x29b16b,null));};exports[_0x6da4('0x58')]=function(_0x3fba67,_0x38e8d2,_0x2d5e0f){return db[_0x6da4('0x40')][_0x6da4('0x53')]({'where':{'id':_0x3fba67[_0x6da4('0x52')]['id']}})['then'](handleEntityNotFound(_0x38e8d2,null))[_0x6da4('0x20')](function(_0x4dd904){if(_0x4dd904){return _0x4dd904[_0x6da4('0x58')](_0x3fba67['body']['ids'],_[_0x6da4('0x59')](_0x3fba67[_0x6da4('0x55')],[_0x6da4('0x5a'),'id'])||{});}})[_0x6da4('0x20')](respondWithResult(_0x38e8d2,null))[_0x6da4('0x51')](handleError(_0x38e8d2,null));};exports[_0x6da4('0x5b')]=function(_0x464255,_0x4cd915,_0x8ed067){var _0x312d12={'raw':![],'where':{}};var _0x104312={};var _0x3277f7={'count':0x0,'rows':[]};return db[_0x6da4('0x25')][_0x6da4('0x5c')]({'where':{'id':_0x464255[_0x6da4('0x52')]['id']}})['then'](handleEntityNotFound(_0x4cd915,null))[_0x6da4('0x20')](function(_0xa8c18a){if(_0xa8c18a){_0x104312[_0x6da4('0x23')]=_['keys'](db[_0x6da4('0x40')][_0x6da4('0x26')]);_0x104312[_0x6da4('0x27')]=_['keys'](_0x464255[_0x6da4('0x27')]);_0x104312[_0x6da4('0x2a')]=_[_0x6da4('0x2b')](_0x104312[_0x6da4('0x23')],_0x104312['query']);_0x312d12[_0x6da4('0x2c')]=_['intersection'](_0x104312[_0x6da4('0x23')],qs['fields'](_0x464255[_0x6da4('0x27')][_0x6da4('0x2d')]));_0x312d12[_0x6da4('0x2c')]=_0x312d12[_0x6da4('0x2c')][_0x6da4('0x2e')]?_0x312d12['attributes']:_0x104312[_0x6da4('0x23')];if(!_0x464255[_0x6da4('0x27')]['hasOwnProperty'](_0x6da4('0x30'))){_0x312d12[_0x6da4('0x19')]=qs[_0x6da4('0x19')](_0x464255[_0x6da4('0x27')][_0x6da4('0x19')]);_0x312d12[_0x6da4('0x31')]=qs[_0x6da4('0x31')](_0x464255[_0x6da4('0x27')][_0x6da4('0x31')]);}_0x312d12['order']=qs['sort'](_0x464255[_0x6da4('0x27')]['sort']);_0x312d12[_0x6da4('0x33')]=qs[_0x6da4('0x2a')](_['pick'](_0x464255[_0x6da4('0x27')],_0x104312['filters']));_0x312d12[_0x6da4('0x33')]['OpenchannelInteractionId']=_0xa8c18a['id'];if(_0x464255['query'][_0x6da4('0x36')]){_0x312d12['where']=_['merge'](_0x312d12['where'],{'$or':_[_0x6da4('0x37')](_0x312d12['attributes'],function(_0x3c120f){var _0x4a202f={};_0x4a202f[_0x3c120f]={'$like':'%'+_0x464255[_0x6da4('0x27')][_0x6da4('0x36')]+'%'};return _0x4a202f;})});}if(_0x464255['query']['$gte']){var _0x56ad17=_0x464255[_0x6da4('0x27')][_0x6da4('0x5d')][_0x6da4('0x5e')](',');var _0x3ba77d={};_0x3ba77d[_0x56ad17[0x0]]={'$gte':moment(_0x56ad17[0x1])[_0x6da4('0x5f')](_0x6da4('0x60'))};_0x312d12[_0x6da4('0x33')]=_[_0x6da4('0x38')](_0x312d12['where'],_0x3ba77d);}_0x312d12=_[_0x6da4('0x38')]({},_0x312d12,_0x464255['options']);return db[_0x6da4('0x40')][_0x6da4('0x18')]({'where':_0x312d12['where']})[_0x6da4('0x20')](function(_0x1c50ed){_0x3277f7[_0x6da4('0x18')]=_0x1c50ed;if(_0x464255[_0x6da4('0x27')][_0x6da4('0x61')]){_0x312d12[_0x6da4('0x3a')]=[{'all':!![]}];}return db[_0x6da4('0x40')]['findAll'](_0x312d12);})[_0x6da4('0x20')](function(_0x370cdb){_0x3277f7['rows']=_0x370cdb;return _0x3277f7;});}})[_0x6da4('0x20')](respondWithFilteredResult(_0x4cd915,_0x312d12))['catch'](handleError(_0x4cd915,null));};exports['addTags']=function(_0x4b9610,_0x1e4359,_0x259e39){return db[_0x6da4('0x25')]['find']({'where':{'id':_0x4b9610[_0x6da4('0x52')]['id']}})['then'](handleEntityNotFound(_0x1e4359,null))[_0x6da4('0x20')](function(_0x174667){if(_0x174667){return _0x174667[_0x6da4('0x62')](_0x4b9610[_0x6da4('0x55')][_0x6da4('0x5a')],_[_0x6da4('0x59')](_0x4b9610[_0x6da4('0x55')],['ids','id'])||{})['spread'](function(){return db['Tag'][_0x6da4('0x50')]({'attributes':['id','name',_0x6da4('0x4f')],'where':{'id':_0x4b9610['body'][_0x6da4('0x5a')]}});})[_0x6da4('0x20')](function(_0x599e33){socket[_0x6da4('0x63')](_0x6da4('0x64'),{'id':Number(_0x4b9610[_0x6da4('0x52')]['id']),'tags':_0x599e33||[]});return{'id':Number(_0x4b9610[_0x6da4('0x52')]['id']),'tags':_0x599e33||[]};});}})[_0x6da4('0x20')](respondWithResult(_0x1e4359,null))[_0x6da4('0x51')](handleError(_0x1e4359,null));};exports['removeTags']=function(_0x5f376b,_0x4aa530,_0x3cd0c2){var _0x42b1d4;return db[_0x6da4('0x25')][_0x6da4('0x53')]({'where':{'id':_0x5f376b[_0x6da4('0x52')]['id']}})['then'](handleEntityNotFound(_0x4aa530,null))['then'](function(_0x3e2922){if(_0x3e2922){return _0x3e2922['removeTags'](_0x5f376b[_0x6da4('0x27')]['ids']);}})[_0x6da4('0x20')](respondWithStatusCode(_0x4aa530,null))[_0x6da4('0x51')](handleError(_0x4aa530,null));};
git://repos.xcallymotion.com / motion2.git / blob