18 var _0x48a8=['Contact.mobile','c.fax','o.fullname','Owner.fullname','o.internal','Owner.internal','GROUP_CONCAT(DISTINCT\x20t.id)','TagIds','limit','offset','toString','groupBy','Setting','enableEmailPreview','all','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','lodash','squel','../parsers/qs','./update-interaction','updateInteraction','./utils','../../mysqldb','role','agent','search','select','field','color','from','tools_tags','getInteractionFK','user_has_','_interactions','u.id','u.fullname','ui.','left_join','users','length','where','\x20IN\x20?','map','getInteractionsTables','interactions','c.id\x20=\x20i.ContactId\x20AND\x20c.deletedAt\x20IS\x20NULL','o.id\x20=\x20i.UserId','accounts','messages','me.','interactionsTags','\x20=\x20i.id','t.id\x20=\x20it.TagId','expr','getSelectedTags','unreadMessages\x20{OPERATOR}\x200','replace','escapeLIKESpecialChars','isNumeric','i.id\x20LIKE\x20?','sms','whatsapp','i.phone\x20LIKE\x20?','fax','isEmail','mail','MATCH\x20(i.to,\x20i.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','MATCH\x20(me.body)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','sqlOperator','conditions','find','name','buildExpression','type','default','start','value','end','unreadMessages','read','and','Contact','operator','$substring','contact','c.firstName\x20LIKE\x20?\x20OR\x20c.lastName\x20LIKE\x20?\x20OR\x20c.email\x20LIKE\x20?','ContactId','text','Tag','split','tags','clause','ids','User','user','CONCAT_WS(\x27\x20\x27,\x20o.name,\x20o.fullname,\x20o.internal)\x20LIKE\x20?','UserId','body','plainBody','getAccountFK','keys','some','forEach','concat','createdAt','$gte','$lte','i.createdAt\x20BETWEEN\x20?\x20AND\x20?','null','\x20IS\x20NULL','\x20=\x20?','resolve','then','tag','filter','get','capitalize','chat','Websites','Accounts','\x20IS\x20NOT\x20NULL','i.secondDisposition','i.disposition','unshift','i.substatus','closed','shift','CONCAT_WS(\x27\x27,\x20','join','Interaction','Sequelize','QueryTypes','SELECT','sequelize','query','keyBy','merge','fields','attributes','SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)','a.key','Account.key','a.mandatoryDisposition','Account.mandatoryDisposition','Account.email','contactName','i.id','i.createdAt','i.updatedAt','i.closed','i.closedAt','i.attach','i.lastMsgAt','i.lastMsgDirection','i.subject','i.ContactId','i.MailAccountId','openchannel','CASE\x20WHEN\x20i.from\x20IS\x20NOT\x20NULL\x20AND\x20i.from\x20<>\x20\x27\x27\x20THEN\x20i.from\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','CASE\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END','i.*','c.firstName','Contact.firstName','c.lastName','Contact.lastName','c.email','Contact.email','Contact.phone','c.mobile'];(function(_0x5ddb1c,_0x5ea4df){var _0x354adc=function(_0x2dfb1f){while(--_0x2dfb1f){_0x5ddb1c['push'](_0x5ddb1c['shift']());}};_0x354adc(++_0x5ea4df);}(_0x48a8,0xc3));var _0x848a=function(_0x578ceb,_0x485037){_0x578ceb=_0x578ceb-0x0;var _0x3d8725=_0x48a8[_0x578ceb];return _0x3d8725;};'use strict';var _=require(_0x848a('0x0'));var squel=require(_0x848a('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0x848a('0x2'));var updateInteraction=require(_0x848a('0x3'))[_0x848a('0x4')];var utils=require(_0x848a('0x5'));var db=require(_0x848a('0x6'))['db'];function skipInteractionsQuery(_0x8a369,_0x2cb5f5,_0x536b40){var _0xbbe1d=![];var _0x58dd4f=utils['getAccountFK'](_0x8a369);if(_0x2cb5f5[_0x848a('0x7')]===_0x848a('0x8')&&!_0x536b40[_0x848a('0x9')]&&!_0x536b40[_0x58dd4f]){_0xbbe1d=!![];}return _0xbbe1d;}function getTagsQuery(){return squel[_0x848a('0xa')]()[_0x848a('0xb')]('id')[_0x848a('0xb')]('name')['field'](_0x848a('0xc'))[_0x848a('0xd')](_0x848a('0xe'));}function getUsersQuery(_0x1eb3e2,_0x1914a9){var _0x5b8eca=utils[_0x848a('0xf')](_0x1eb3e2);var _0x3d506c=_0x848a('0x10')+_0x1eb3e2+_0x848a('0x11');var _0x350f5d=squel[_0x848a('0xa')]()[_0x848a('0xb')](_0x848a('0x12'))[_0x848a('0xb')](_0x848a('0x13'))[_0x848a('0xb')](_0x848a('0x14')+_0x5b8eca)[_0x848a('0xd')](_0x3d506c,'ui')[_0x848a('0x15')](_0x848a('0x16'),'u','u.id\x20=\x20ui.UserId');if(_0x1914a9[_0x848a('0x17')]>0x0){_0x350f5d[_0x848a('0x18')](_0x848a('0x14')+_0x5b8eca+_0x848a('0x19'),_[_0x848a('0x1a')](_0x1914a9,'id'));}return _0x350f5d;}function getInteractionsQuery(_0x120636){var _0x365be9=utils[_0x848a('0x1b')](_0x120636);var _0x512ccc=utils['getAccountFK'](_0x120636);var _0x15c7a0=utils[_0x848a('0xf')](_0x120636);return squel[_0x848a('0xa')]()['from'](_0x365be9[_0x848a('0x1c')],'i')['left_join']('cm_contacts','c',_0x848a('0x1d'))[_0x848a('0x15')](_0x848a('0x16'),'o',_0x848a('0x1e'))['left_join'](_0x365be9[_0x848a('0x1f')],'a','a.id\x20=\x20i.'+_0x512ccc)[_0x848a('0x15')](_0x365be9[_0x848a('0x20')],'me',_0x848a('0x21')+_0x15c7a0+'\x20=\x20i.id')[_0x848a('0x15')](_0x365be9[_0x848a('0x22')],'it','it.'+_0x15c7a0+_0x848a('0x23'))[_0x848a('0x15')](_0x848a('0xe'),'t',_0x848a('0x24'));}function getSqlClauses(){var _0x5a7e69={'body':squel['expr'](),'contact':squel['expr'](),'default':squel[_0x848a('0x25')](),'fields':squel[_0x848a('0x25')](),'filter':squel[_0x848a('0x25')](),'read':squel[_0x848a('0x25')](),'tags':{'clause':squel['expr'](),'ids':null},'user':squel['expr']()};return _0x5a7e69;}function parseTagParameter(_0x22e55b){var _0x42d3eb=squel['expr']();if(_0x22e55b){var _0xd897be=utils[_0x848a('0x26')](_0x22e55b);_0xd897be['forEach'](function(_0x1b15bd){_0x42d3eb['or']('CONCAT(\x27,\x27,\x20`TagIds`,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x1b15bd+',%');});}return _0x42d3eb;}function parseReadParameter(_0x735c80){var _0x4cba99='';if(_0x735c80){_0x4cba99=_0x848a('0x27');if(_0x735c80==='1'){_0x4cba99=_0x4cba99[_0x848a('0x28')]('{OPERATOR}','=');}else{_0x4cba99=_0x4cba99[_0x848a('0x28')]('{OPERATOR}','>');}}return _0x4cba99;}function parseSearchFilter(_0x574844,_0x490cf3){var _0xe9e11b=squel[_0x848a('0x25')]();if(_0x490cf3){var _0xb05177=_0x490cf3[_0x848a('0x28')]('\x5c','\x5c\x5c')[_0x848a('0x28')](/'/g,'\x27\x27');var _0x45e4e5=qs[_0x848a('0x29')](_0xb05177);if(qs[_0x848a('0x2a')](_0xb05177)){_0xe9e11b['or'](_0x848a('0x2b'),_0x45e4e5+'%');if([_0x848a('0x2c'),_0x848a('0x2d')]['includes'](_0x574844)){_0xe9e11b['or'](_0x848a('0x2e'),_0x45e4e5+'%');}else if(_0x574844===_0x848a('0x2f')){_0xe9e11b['or']('i.fax\x20LIKE\x20?',_0x45e4e5+'%');}else if(_0x574844==='openchannel'){_0xe9e11b['or']('i.from\x20LIKE\x20?',_0x45e4e5+'%');}}else if(_0x574844==='mail'&&qs[_0x848a('0x30')](_0xb05177)){_0xe9e11b['or']('c.email\x20LIKE\x20?',_0x45e4e5+'%');}else{if(_0x574844===_0x848a('0x31')){_0xe9e11b['or'](_0x848a('0x32'),qs[_0x848a('0x33')](_0xb05177,!![]))['or']('MATCH\x20(me.plainBody,\x20me.subject)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0xb05177));}else if(_0x574844!==_0x848a('0x2f')){_0xe9e11b['or'](_0x848a('0x34'),qs[_0x848a('0x33')](_0xb05177));}_0xe9e11b['or'](_0x848a('0x35'),qs[_0x848a('0x33')](_0xb05177,!![]),null);}}return _0xe9e11b;}function parseAdvancedSearchFilter(_0xa34035,_0x371daa){var _0x13c3dd=getSqlClauses();var _0x5e4e8d=as['parseSearch'](_0xa34035);var _0x12b692=_0x5e4e8d[_0x848a('0x36')];for(var _0x59a0ab=0x0;_0x59a0ab<_0x5e4e8d[_0x848a('0x37')][_0x848a('0x17')];_0x59a0ab++){var _0x275613=_0x5e4e8d['conditions'][_0x59a0ab];var _0x26f472='i';var _0x120229=_[_0x848a('0x38')](_0x371daa,[_0x848a('0x39'),_0x275613[_0x848a('0xb')]]);if(_0x120229){var _0x22868a=as[_0x848a('0x3a')](_0x26f472,_0x120229[_0x848a('0x3b')],_0x275613);_0x13c3dd[_0x848a('0x3c')][_0x12b692](_0x22868a['text'],_0x22868a['value'][_0x848a('0x3d')],_0x22868a[_0x848a('0x3e')][_0x848a('0x3f')]);}else{switch(_0x275613[_0x848a('0xb')]){case _0x848a('0x40'):var _0xb8f9a8=parseReadParameter(_0x275613[_0x848a('0x3e')]);_0x13c3dd[_0x848a('0x41')][_0x848a('0x42')](_0xb8f9a8);break;case _0x848a('0x43'):if(_0x275613[_0x848a('0x44')]===_0x848a('0x45')){if(_0x275613[_0x848a('0x3e')]['split']('\x20')[_0x848a('0x17')]>0x1){_0x13c3dd[_0x848a('0x46')][_0x12b692]('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x848a('0x33')](_0x275613[_0x848a('0x3e')],!![]),null);}else{var _0x2ac1c0='%'+_0x275613[_0x848a('0x3e')]+'%';_0x13c3dd[_0x848a('0x46')][_0x12b692](_0x848a('0x47'),_0x2ac1c0,_0x2ac1c0,_0x2ac1c0);}}else{_0x120229=_[_0x848a('0x38')](_0x371daa,[_0x848a('0x39'),_0x848a('0x48')]);_0x275613[_0x848a('0xb')]='ContactId';_0x22868a=as['buildExpression'](_0x26f472,_0x120229[_0x848a('0x3b')],_0x275613);_0x13c3dd[_0x848a('0x46')][_0x12b692](_0x22868a[_0x848a('0x49')],_0x22868a[_0x848a('0x3e')][_0x848a('0x3d')],_0x22868a[_0x848a('0x3e')]['end']);}break;case _0x848a('0x4a'):var _0x1c70a2=_0x275613[_0x848a('0x3e')][_0x848a('0x4b')](',')[_0x848a('0x1a')](function(_0x4b3d47){return Number(_0x4b3d47);});var _0x322852=parseTagParameter(_0x1c70a2);_0x13c3dd[_0x848a('0x4c')][_0x848a('0x4d')][_0x848a('0x42')](_0x322852);_0x13c3dd[_0x848a('0x4c')][_0x848a('0x4e')]=_0x1c70a2;break;case _0x848a('0x4f'):if(_0x275613[_0x848a('0x44')]===_0x848a('0x45')){_0x13c3dd[_0x848a('0x50')][_0x12b692](_0x848a('0x51'),'%'+_0x275613[_0x848a('0x3e')]+'%',null);}else{_0x120229=_['find'](_0x371daa,[_0x848a('0x39'),_0x848a('0x52')]);_0x275613[_0x848a('0xb')]='UserId';_0x22868a=as[_0x848a('0x3a')](_0x26f472,_0x120229[_0x848a('0x3b')],_0x275613);_0x13c3dd[_0x848a('0x50')][_0x12b692](_0x22868a[_0x848a('0x49')],_0x22868a['value'][_0x848a('0x3d')],_0x22868a[_0x848a('0x3e')][_0x848a('0x3f')]);}break;case _0x848a('0x53'):case _0x848a('0x54'):_0x22868a=as['buildExpression']('me',null,_0x275613);_0x13c3dd[_0x848a('0x53')][_0x12b692](_0x22868a[_0x848a('0x49')],_0x22868a['value']['start'],_0x22868a['value'][_0x848a('0x3f')]);break;}}}return _0x13c3dd;}function parseModelFields(_0x4d3a4e,_0x355f29,_0x50fe03){var _0x3a05e4=utils[_0x848a('0x55')](_0x4d3a4e);var _0x2d6a56=squel[_0x848a('0x25')]();var _0x1d4f59=_(_0x355f29)[_0x848a('0x56')]()[_0x848a('0x1a')](function(_0x21a15c){return _[_0x848a('0x57')](_0x50fe03,[_0x848a('0x39'),_0x21a15c])?_0x21a15c:undefined;})['compact']()['value']();if(_0x1d4f59['length']>0x0){_0x1d4f59[_0x848a('0x58')](function(_0x41d87e){if(_0x41d87e===_0x3a05e4){_0x2d6a56[_0x848a('0x42')]('i.'+_0x3a05e4+_0x848a('0x19'),[][_0x848a('0x59')](_0x355f29[_0x41d87e]));}else if(_0x41d87e===_0x848a('0x5a')){var _0x5aa88c=JSON['parse'](_0x355f29[_0x41d87e])[_0x848a('0x5b')];var _0x5160bd=JSON['parse'](_0x355f29[_0x41d87e])[_0x848a('0x5c')];_0x2d6a56[_0x848a('0x42')](_0x848a('0x5d'),_0x5aa88c,_0x5160bd);}else{if(_0x355f29[_0x41d87e]===_0x848a('0x5e')){_0x2d6a56['and']('i.'+_0x41d87e+_0x848a('0x5f'));}else{_0x2d6a56[_0x848a('0x42')]('i.'+_0x41d87e+_0x848a('0x60'),_0x355f29[_0x41d87e]);}}});}return _0x2d6a56;}function parseQueryParameters(_0x14d3fc,_0x36f392,_0x1ab714){var _0x524a0c=getSqlClauses();return Promise[_0x848a('0x61')]()[_0x848a('0x62')](function(){return parseModelFields(_0x14d3fc,_0x36f392,_0x1ab714);})[_0x848a('0x62')](function(_0x2828c8){_0x524a0c['fields'][_0x848a('0x42')](_0x2828c8);return parseReadParameter(_0x36f392[_0x848a('0x41')]);})[_0x848a('0x62')](function(_0x1efe2d){_0x524a0c[_0x848a('0x41')][_0x848a('0x42')](_0x1efe2d);return parseTagParameter(_0x36f392[_0x848a('0x63')]);})[_0x848a('0x62')](function(_0x3b6a52){_0x524a0c[_0x848a('0x4c')][_0x848a('0x4d')][_0x848a('0x42')](_0x3b6a52);return parseSearchFilter(_0x14d3fc,_0x36f392[_0x848a('0x64')]);})[_0x848a('0x62')](function(_0x264790){_0x524a0c[_0x848a('0x64')]=_0x264790;return _0x524a0c;});}function checkAccountsRestrictions(_0x466157,_0x4c5fd5,_0x4fefaf){var _0x47e23e=utils[_0x848a('0x55')](_0x466157);var _0x50c2db=_0x848a('0x65')+_[_0x848a('0x66')](_0x466157)+(_0x466157===_0x848a('0x67')?_0x848a('0x68'):_0x848a('0x69'));var _0x584ba7=squel[_0x848a('0x25')]();return Promise['resolve']()['then'](function(){if(_0x4fefaf[_0x848a('0x9')]&&_0x4c5fd5[_0x848a('0x7')]===_0x848a('0x8')){return _0x4c5fd5[_0x50c2db]({'attributes':['id'],'raw':!![]});}})[_0x848a('0x62')](function(_0x8c742c){if(_0x8c742c){if(_0x8c742c['length']===0x0){_0x584ba7['and']('i.'+_0x47e23e+_0x848a('0x5f'));}else{_0x584ba7['and']('i.'+_0x47e23e+_0x848a('0x19'),_[_0x848a('0x1a')](_0x8c742c,'id'));}}else if(!_0x4fefaf[_0x47e23e]){_0x584ba7['and']('i.'+_0x47e23e+_0x848a('0x6a'));}})[_0x848a('0x62')](function(){return _0x584ba7;});}function getClosedOrderClause(_0x18675c,_0x3aa109){var _0x2f8d50='';var _0xebeff8=['i.thirdDisposition',_0x848a('0x6b'),_0x848a('0x6c')];if(_0x18675c==='mail'){_0xebeff8[_0x848a('0x6d')](_0x848a('0x6e'));}if(_0x3aa109[_0x848a('0x6f')]==='0'&&_0x18675c===_0x848a('0x31')){_0x2f8d50=_0x848a('0x6e');}else{if(_0x3aa109['closed']==='1'){_0xebeff8[_0x848a('0x70')]();}_0x2f8d50=_0x848a('0x71')+_0xebeff8[_0x848a('0x72')](',\x20')+')';}return _0x2f8d50;}function getFilteredInteractions(_0x4abd69,_0x2dbb70,_0x64d04,_0x414107){var _0x464189=utils['getInteractionFK'](_0x4abd69);var _0x443eca=_[_0x848a('0x66')](_0x4abd69)+_0x848a('0x73');var _0x5e9cca=[];var _0x5778e1=getTagsQuery();var _0x413923={'type':db[_0x848a('0x74')][_0x848a('0x75')][_0x848a('0x76')],'raw':!![]};var _0x34bdc7=[];var _0x3bdcca=[];return db[_0x848a('0x77')][_0x848a('0x78')](_0x5778e1['toString'](),_0x413923)['then'](function(_0x475985){_0x5e9cca=_[_0x848a('0x79')](_0x475985,'id');_0x413923=_[_0x848a('0x7a')](_0x413923,{'model':db[_0x443eca],'mapToModel':!![],'nest':!![]});if(_0x64d04[_0x848a('0x7b')]){_0x414107[_0x848a('0x7c')][_0x848a('0x58')](function(_0xc1ad0d){_0x2dbb70[_0x848a('0xb')]('i.'+_0xc1ad0d);});}else{_0x2dbb70['field'](_0x848a('0x7d'),'unreadMessages');_0x2dbb70[_0x848a('0xb')](_0x848a('0x7e'),_0x848a('0x7f'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x80'),_0x848a('0x81'));if(_0x4abd69===_0x848a('0x31')){_0x2dbb70['field']('a.email',_0x848a('0x82'));_0x2dbb70['field']('CASE\x20WHEN\x20i.to\x20IS\x20NOT\x20NULL\x20AND\x20i.to\x20<>\x20\x27\x27\x20AND\x20i.to\x20NOT\x20LIKE\x20CONCAT(\x27%\x27,\x20a.email,\x20\x27%\x27)\x20THEN\x20TRIM(SUBSTRING_INDEX(i.to,\x20\x27<\x27,\x201))\x20WHEN\x20(c.firstName\x20IS\x20NOT\x20NULL\x20AND\x20c.firstName\x20<>\x20\x27\x27)\x20OR\x20(c.lastName\x20IS\x20NOT\x20NULL\x20AND\x20c.lastName\x20<>\x20\x27\x27)\x20THEN\x20CONCAT(IFNULL(c.firstName,\x20\x27\x27),\x20\x27\x20\x27,\x20IFNULL(c.lastName,\x20\x27\x27))\x20ELSE\x20\x27Unknown\x27\x20END',_0x848a('0x83'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x84'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x85'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x86'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x87'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x88'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x89'));_0x2dbb70['field'](_0x848a('0x8a'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x8b'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x8c'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x6c'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x6b'));_0x2dbb70['field']('i.thirdDisposition');_0x2dbb70['field'](_0x848a('0x6e'));_0x2dbb70[_0x848a('0xb')]('i.to');_0x2dbb70[_0x848a('0xb')](_0x848a('0x8d'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x8e'));_0x2dbb70['field']('i.UserId');}else if(_0x4abd69===_0x848a('0x8f')){_0x2dbb70['field'](_0x848a('0x90'),_0x848a('0x83'));}else{_0x2dbb70[_0x848a('0xb')](_0x848a('0x91'),_0x848a('0x83'));}if(_0x4abd69!==_0x848a('0x31')){_0x2dbb70[_0x848a('0xb')](_0x848a('0x92'));}_0x2dbb70[_0x848a('0xb')](_0x848a('0x93'),_0x848a('0x94'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x95'),_0x848a('0x96'));_0x2dbb70['field'](_0x848a('0x97'),_0x848a('0x98'));_0x2dbb70[_0x848a('0xb')]('c.phone',_0x848a('0x99'));_0x2dbb70['field'](_0x848a('0x9a'),_0x848a('0x9b'));_0x2dbb70['field'](_0x848a('0x9c'),'Contact.fax');_0x2dbb70[_0x848a('0xb')](_0x848a('0x9d'),_0x848a('0x9e'));_0x2dbb70[_0x848a('0xb')](_0x848a('0x9f'),_0x848a('0xa0'));_0x2dbb70[_0x848a('0xb')](_0x848a('0xa1'),_0x848a('0xa2'));}if(_0x414107[_0x848a('0xa3')]){_0x2dbb70['limit'](_0x414107['limit']);}if(_0x414107[_0x848a('0xa4')]){_0x2dbb70[_0x848a('0xa4')](_0x414107['offset']);}return db[_0x848a('0x77')][_0x848a('0x78')](_0x2dbb70[_0x848a('0xa5')](),_0x413923);})[_0x848a('0x62')](function(_0x42bf7c){_0x34bdc7=_0x42bf7c;var _0x523a4d=getUsersQuery(_0x4abd69,_0x34bdc7);return db[_0x848a('0x77')][_0x848a('0x78')](_0x523a4d[_0x848a('0xa5')](),_0x413923);})[_0x848a('0x62')](function(_0x687092){_0x3bdcca=_[_0x848a('0xa6')](_0x687092,_0x464189);if(_0x4abd69===_0x848a('0x31')){return db[_0x848a('0xa7')]['findOne']({'attributes':[_0x848a('0xa8')],'raw':!![]});}})[_0x848a('0x62')](function(_0x513bc9){var _0x3bd8b8=_0x513bc9?_0x513bc9[_0x848a('0xa8')]:undefined;var _0x4412d2=_0x34bdc7['map'](function(_0x26504d){return updateInteraction(_0x26504d,_0x5e9cca,_0x3bdcca,_0x3bd8b8);});return Promise[_0x848a('0xa9')](_0x4412d2);});}function countFilteredInteractions(_0xff429c,_0x4ca96f){var _0x379bb8=_0xff429c[_0x848a('0xaa')]();_0x379bb8[_0x848a('0xb')](_0x848a('0xab'));_0x379bb8[_0x848a('0xb')]('SUM(me.read\x20=\x200\x20AND\x20me.direction\x20=\x20\x27in\x27)',_0x848a('0x40'));var _0x9d1d05=utils[_0x848a('0x26')](_0x4ca96f);if(!_[_0x848a('0xac')](_0x9d1d05)){_0x379bb8['where'](_0x848a('0xad'),_0x9d1d05);}var _0xb58085={'type':db[_0x848a('0x74')]['QueryTypes'][_0x848a('0x76')],'raw':!![]};return db[_0x848a('0x77')][_0x848a('0x78')](_0x379bb8[_0x848a('0xa5')](),_0xb58085);}module[_0x848a('0xae')]={'checkAccountsRestrictions':checkAccountsRestrictions,'countFilteredInteractions':countFilteredInteractions,'getClosedOrderClause':getClosedOrderClause,'getFilteredInteractions':getFilteredInteractions,'getInteractionsQuery':getInteractionsQuery,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipInteractionsQuery':skipInteractionsQuery};
git://repos.xcallymotion.com / motion2.git / blob