// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xaa16=['includes','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','replace','escapeLIKESpecialChars','split','length','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','sqlOperator','conditions','find','dateOfBirth','datetime','DATE','buildExpression','type','default','value','start','Tag','map','tags','clause','and','ids','uc.UserId\x20=\x20?','skip','keys','some','name','compact','Contact','push','User','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','resolve','then','fields','filter','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','attributes','c.id','limit','offset','subqry.id','order','DESC','subqry.','findAll','color','keyBy','Sequelize','QueryTypes','SELECT','sequelize','query','toString','Tags','COUNT(*)','getSelectedTags','isEmpty','t.id\x20IN\x20?','exports','lodash','../parsers/qs','../interaction/utils','role','agent','search','ListId','autocomplete','true','select','from','cm_contacts','where','c.deletedAt\x20IS\x20NULL','subqry','cm_user_has_contacts','uc.CmContactId\x20=\x20','left_join','cm_contact_has_tags','ct.CmContactId\x20=\x20','.id','tools_tags','t.id\x20=\x20ct.TagId','firstName','lastName','mobile','email','CompanyId','createdAt','updatedAt','deletedAt','TagIds'];(function(_0x40672d,_0x316df5){var _0x731e51=function(_0x103e27){while(--_0x103e27){_0x40672d['push'](_0x40672d['shift']());}};_0x731e51(++_0x316df5);}(_0xaa16,0x11b));var _0x6aa1=function(_0x3fb8d4,_0x50915d){_0x3fb8d4=_0x3fb8d4-0x0;var _0xa05e7c=_0xaa16[_0x3fb8d4];return _0xa05e7c;};'use strict';var _=require(_0x6aa1('0x0'));var squel=require('squel');var as=require('../parsers/advancedSearch');var qs=require(_0x6aa1('0x1'));var utils=require(_0x6aa1('0x2'));var db=require('../../mysqldb')['db'];function skipContactsQuery(_0x436b47,_0x4dd9f0){var _0x391fa4=![];if(_0x436b47[_0x6aa1('0x3')]===_0x6aa1('0x4')&&!_0x4dd9f0[_0x6aa1('0x5')]&&!_0x4dd9f0[_0x6aa1('0x6')]&&_0x4dd9f0[_0x6aa1('0x7')]!==_0x6aa1('0x8')){_0x391fa4=!![];}return _0x391fa4;}function getContactsSubquery(){return squel[_0x6aa1('0x9')]()[_0x6aa1('0xa')](_0x6aa1('0xb'),'c')[_0x6aa1('0xc')](_0x6aa1('0xd'));}function applyJoinClauses(_0x21373b,_0x4aa054){var _0x4196d4=_0x4aa054?'c':_0x6aa1('0xe');_0x21373b['left_join'](_0x6aa1('0xf'),'uc',_0x6aa1('0x10')+_0x4196d4+'.id')[_0x6aa1('0x11')](_0x6aa1('0x12'),'ct',_0x6aa1('0x13')+_0x4196d4+_0x6aa1('0x14'))[_0x6aa1('0x11')](_0x6aa1('0x15'),'t',_0x6aa1('0x16'));return _0x21373b;}function addFieldsToQuery(_0x129efa,_0x43c717,_0x4e6329,_0x5023d9,_0x4841c1){var _0x1d87a6=_0x4841c1?'c':'subqry';if(!_0x43c717){_0x43c717=['id',_0x6aa1('0x17'),_0x6aa1('0x18'),'phone',_0x6aa1('0x19'),'fax',_0x6aa1('0x1a'),_0x6aa1('0x6'),_0x6aa1('0x1b'),_0x6aa1('0x1c'),_0x6aa1('0x1d'),_0x6aa1('0x1e'),_0x6aa1('0x1f')];}else if(!_0x43c717[_0x6aa1('0x20')]('id')){_0x43c717['push']('id');}var _0x911c23=_0x4e6329&&_0x4841c1||!_0x4e6329&&!_0x4841c1;if(_0x5023d9){_0x911c23=_0x5023d9&&_0x4841c1||!_0x5023d9&&!_0x4841c1;}_0x43c717[_0x6aa1('0x21')](function(_0x1633ee){if(_0x1633ee===_0x6aa1('0x1f')){if(_0x911c23){_0x129efa[_0x6aa1('0x22')](_0x6aa1('0x23'),_0x1633ee);}else if(_0x4e6329||_0x5023d9){_0x129efa['field'](_0x1d87a6+'.'+_0x1633ee);}}else{_0x129efa[_0x6aa1('0x22')](_0x1d87a6+'.'+_0x1633ee);}});return _0x129efa;}function getSqlClauses(){var _0x2172ae={'default':squel[_0x6aa1('0x24')](),'fields':squel['expr'](),'filter':squel[_0x6aa1('0x24')](),'tags':{'clause':squel[_0x6aa1('0x24')](),'ids':null},'user':{'clause':squel['expr'](),'skip':![]}};return _0x2172ae;}function parseTagParameter(_0x1fc028){var _0x5560d6=squel[_0x6aa1('0x24')]();if(_0x1fc028){var _0x50fed3=utils['getSelectedTags'](_0x1fc028);_0x50fed3['forEach'](function(_0x53dac8){_0x5560d6['or']('CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x53dac8+',%');});}return _0x5560d6;}function parseSearchFilter(_0x32537c){var _0x5d191f=squel[_0x6aa1('0x24')]();if(_0x32537c){var _0x18fcb8=_0x32537c[_0x6aa1('0x25')]('\x5c','\x5c\x5c')[_0x6aa1('0x25')](/'/g,'\x27\x27');var _0x4b5264=qs[_0x6aa1('0x26')](_0x18fcb8);if(_0x18fcb8[_0x6aa1('0x27')]('\x20')[_0x6aa1('0x28')]>0x1){_0x5d191f['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x6aa1('0x29')](_0x18fcb8,!![]),null);}else{if(qs[_0x6aa1('0x2a')](_0x18fcb8)){_0x5d191f['or'](_0x6aa1('0x2b'),_0x4b5264+'%');_0x5d191f['or']('c.phone\x20LIKE\x20?',_0x4b5264+'%');_0x5d191f['or'](_0x6aa1('0x2c'),_0x4b5264+'%');_0x5d191f['or']('c.fax\x20LIKE\x20?',_0x4b5264+'%');}else if(qs[_0x6aa1('0x2d')](_0x18fcb8)){_0x5d191f['or'](_0x6aa1('0x2e'),_0x4b5264+'%');}else{_0x5d191f['or']('c.firstName\x20LIKE\x20?','%'+_0x4b5264+'%');_0x5d191f['or']('c.lastName\x20LIKE\x20?','%'+_0x4b5264+'%');_0x5d191f['or'](_0x6aa1('0x2e'),'%'+_0x4b5264+'%');}}}return _0x5d191f;}function parseAdvancedSearchFilter(_0x490da0,_0xfe4c17){var _0x2279f7=getSqlClauses();var _0x5d88f0=as['parseSearch'](_0x490da0);var _0x7a2e04=_0x5d88f0[_0x6aa1('0x2f')];for(var _0xc5c158=0x0;_0xc5c158<_0x5d88f0[_0x6aa1('0x30')][_0x6aa1('0x28')];_0xc5c158++){var _0x1cdc11=_0x5d88f0[_0x6aa1('0x30')][_0xc5c158];var _0x3b6b61='c';var _0x5dcf1a=_[_0x6aa1('0x31')](_0xfe4c17,['name',_0x1cdc11[_0x6aa1('0x22')]]);if(_0x5dcf1a){if(_0x1cdc11['field']===_0x6aa1('0x32')||_0x5dcf1a['fieldType']===_0x6aa1('0x33')){_0x1cdc11['castTo']=_0x6aa1('0x34');}var _0x64eb8d=as[_0x6aa1('0x35')](_0x3b6b61,_0x5dcf1a[_0x6aa1('0x36')],_0x1cdc11);_0x2279f7[_0x6aa1('0x37')][_0x7a2e04](_0x64eb8d['text'],_0x64eb8d[_0x6aa1('0x38')][_0x6aa1('0x39')],_0x64eb8d[_0x6aa1('0x38')]['end']);}else{if(_0x1cdc11[_0x6aa1('0x22')]===_0x6aa1('0x3a')){var _0x3df7ca=_0x1cdc11[_0x6aa1('0x38')]['split'](',')[_0x6aa1('0x3b')](function(_0x5bfa0d){return Number(_0x5bfa0d);});var _0x39823e=parseTagParameter(_0x3df7ca);_0x2279f7[_0x6aa1('0x3c')][_0x6aa1('0x3d')][_0x6aa1('0x3e')](_0x39823e);_0x2279f7['tags'][_0x6aa1('0x3f')]=_0x3df7ca;}else if(_0x1cdc11[_0x6aa1('0x22')]==='User'){_0x2279f7['user'][_0x6aa1('0x3d')][_0x6aa1('0x3e')](_0x6aa1('0x40'),_0x1cdc11[_0x6aa1('0x38')]);_0x2279f7['user'][_0x6aa1('0x41')]=!![];}}}return _0x2279f7;}function parseModelFields(_0x181165,_0x305483){var _0x43b9a6=squel[_0x6aa1('0x24')]();var _0x1ac14e=_(_0x181165)[_0x6aa1('0x42')]()[_0x6aa1('0x3b')](function(_0x29edff){return _[_0x6aa1('0x43')](_0x305483,[_0x6aa1('0x44'),_0x29edff])?_0x29edff:undefined;})[_0x6aa1('0x45')]()[_0x6aa1('0x38')]();if(_0x181165[_0x6aa1('0x46')]){_0x1ac14e[_0x6aa1('0x47')]('Contact');}if(_0x181165[_0x6aa1('0x48')]){_0x1ac14e[_0x6aa1('0x47')](_0x6aa1('0x48'));}if(_0x1ac14e[_0x6aa1('0x28')]>0x0){_0x1ac14e['forEach'](function(_0x17adaf){if(_0x17adaf===_0x6aa1('0x6')){_0x43b9a6[_0x6aa1('0x3e')]('c.ListId\x20IN\x20?',[][_0x6aa1('0x49')](_0x181165[_0x17adaf]));}else if(_0x17adaf==='Contact'){var _0x2dec75='%'+_0x181165[_0x17adaf]+'%';_0x43b9a6[_0x6aa1('0x3e')](_0x6aa1('0x4a'),_0x2dec75);}else if(_0x17adaf===_0x6aa1('0x48')){_0x43b9a6[_0x6aa1('0x3e')]('uc.UserId\x20=\x20?',_0x181165[_0x17adaf]);}else{_0x43b9a6[_0x6aa1('0x3e')]('c.'+_0x17adaf+_0x6aa1('0x4b'),_0x181165[_0x17adaf]);}});}return _0x43b9a6;}function parseQueryParameters(_0x45aafc,_0x49f4b7){var _0x4ad279=getSqlClauses();return Promise[_0x6aa1('0x4c')]()[_0x6aa1('0x4d')](function(){return parseModelFields(_0x45aafc,_0x49f4b7);})[_0x6aa1('0x4d')](function(_0x1689cd){_0x4ad279[_0x6aa1('0x4e')][_0x6aa1('0x3e')](_0x1689cd);return parseTagParameter(_0x45aafc['tag']);})[_0x6aa1('0x4d')](function(_0x2e2881){_0x4ad279[_0x6aa1('0x3c')][_0x6aa1('0x3d')][_0x6aa1('0x3e')](_0x2e2881);return parseSearchFilter(_0x45aafc[_0x6aa1('0x4f')]);})[_0x6aa1('0x4d')](function(_0x1d5c2c){_0x4ad279[_0x6aa1('0x4f')]=_0x1d5c2c;return _0x4ad279;});}function checkListsRestrictions(_0x3abbe1,_0x361dbe,_0x11b5c9){var _0x108219=squel[_0x6aa1('0x24')]();return Promise[_0x6aa1('0x4c')]()[_0x6aa1('0x4d')](function(){if(_0x361dbe[_0x6aa1('0x5')]&&_0x3abbe1[_0x6aa1('0x3')]===_0x6aa1('0x4')&&!_0x11b5c9){return _0x3abbe1['getLists']({'attributes':['id'],'raw':!![]});}})['then'](function(_0x5a8ff6){if(_0x5a8ff6){if(_0x5a8ff6[_0x6aa1('0x28')]===0x0){_0x108219[_0x6aa1('0x3e')](_0x6aa1('0x50'));}else{_0x108219[_0x6aa1('0x3e')](_0x6aa1('0x51'),_[_0x6aa1('0x3b')](_0x5a8ff6,'id'));}}})[_0x6aa1('0x4d')](function(){return _0x108219;});}function buildContactsQuery(_0x1068d3,_0x1cec22,_0x49f64f,_0x271898,_0x45d711,_0x3f39f5){if(_0x1cec22){_0x1cec22=_0x49f64f[_0x6aa1('0x52')];}_0x1068d3=addFieldsToQuery(_0x1068d3,_0x1cec22,_0x271898,_0x3f39f5,!![]);var _0x232537=squel[_0x6aa1('0x9')]();_0x232537=addFieldsToQuery(_0x232537,_0x1cec22,_0x271898,_0x3f39f5,![]);if(_0x271898||_0x3f39f5){_0x1068d3=applyJoinClauses(_0x1068d3,!![]);_0x1068d3['group'](_0x6aa1('0x53'));if(_0x49f64f[_0x6aa1('0x54')]){_0x232537[_0x6aa1('0x54')](_0x49f64f[_0x6aa1('0x54')]);}if(_0x49f64f[_0x6aa1('0x55')]){_0x232537['offset'](_0x49f64f[_0x6aa1('0x55')]);}}else{_0x232537=applyJoinClauses(_0x232537,![]);_0x232537['group'](_0x6aa1('0x56'));if(_0x49f64f['limit']){_0x1068d3[_0x6aa1('0x54')](_0x49f64f[_0x6aa1('0x54')]);}if(_0x49f64f[_0x6aa1('0x55')]){_0x1068d3[_0x6aa1('0x55')](_0x49f64f['offset']);}}_0x232537['having'](_0x45d711);if(_0x49f64f[_0x6aa1('0x57')]){_0x49f64f['order'][_0x6aa1('0x21')](function(_0x12307b){_0x1068d3['order']('c.'+_0x12307b[0x0],_0x12307b[0x1]===_0x6aa1('0x58')?![]:!![]);_0x232537[_0x6aa1('0x57')](_0x6aa1('0x59')+_0x12307b[0x0],_0x12307b[0x1]==='DESC'?![]:!![]);});}_0x232537['from'](_0x1068d3,_0x6aa1('0xe'));return _0x232537;}function getFilteredContacts(_0xb3129f){var _0x53db3d=[];return db[_0x6aa1('0x3a')][_0x6aa1('0x5a')]({'attributes':['id',_0x6aa1('0x44'),_0x6aa1('0x5b')],'raw':!![]})[_0x6aa1('0x4d')](function(_0x26dc30){_0x53db3d=_[_0x6aa1('0x5c')](_0x26dc30,'id');var _0x506585={'type':db[_0x6aa1('0x5d')][_0x6aa1('0x5e')][_0x6aa1('0x5f')],'model':db['CmContact'],'mapToModel':!![],'nest':!![],'raw':!![]};return db[_0x6aa1('0x60')][_0x6aa1('0x61')](_0xb3129f[_0x6aa1('0x62')](),_0x506585);})[_0x6aa1('0x4d')](function(_0x3755e1){_0x3755e1[_0x6aa1('0x21')](function(_0x3171d5){if(_0x3171d5['TagIds']){_0x3171d5['Tags']=[];_0x3171d5[_0x6aa1('0x1f')][_0x6aa1('0x27')](',')[_0x6aa1('0x21')](function(_0x7cc38b){_0x3171d5[_0x6aa1('0x63')][_0x6aa1('0x47')](_0x53db3d[_0x7cc38b]);});}delete _0x3171d5[_0x6aa1('0x1f')];});return _0x3755e1;});}function countFilteredContacts(_0x1a8698,_0x1e2df4){var _0xf1928d=_0x1a8698['clone']();_0xf1928d[_0x6aa1('0x22')](_0x6aa1('0x64'));_0xf1928d=applyJoinClauses(_0xf1928d,!![]);_0x1a8698['group'](_0x6aa1('0x53'));var _0x4efaac=utils[_0x6aa1('0x65')](_0x1e2df4);if(!_[_0x6aa1('0x66')](_0x4efaac)){_0xf1928d[_0x6aa1('0xc')](_0x6aa1('0x67'),_0x4efaac);}var _0x38f673={'type':db[_0x6aa1('0x5d')]['QueryTypes'][_0x6aa1('0x5f')],'raw':!![]};return db['sequelize'][_0x6aa1('0x61')](_0xf1928d[_0x6aa1('0x62')](),_0x38f673)[_0x6aa1('0x4d')](function(_0x47b0a6){return _0x47b0a6[0x0][_0x6aa1('0x64')];});}module[_0x6aa1('0x68')]={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
+var _0x67af=['name','dateOfBirth','fieldType','castTo','DATE','buildExpression','type','default','text','value','start','end','Tag','map','tags','clause','and','ids','User','user','uc.UserId\x20=\x20?','skip','keys','some','compact','Contact','c.ListId\x20IN\x20?','resolve','then','fields','tag','filter','role','getLists','c.ListId\x20IS\x20NULL','group','limit','offset','subqry.id','having','order','DESC','subqry.','Sequelize','QueryTypes','SELECT','CmContact','sequelize','query','toString','Tags','clone','COUNT(*)','isEmpty','t.id\x20IN\x20?','exports','lodash','../parsers/qs','../interaction/utils','../../mysqldb','agent','search','true','select','from','cm_contacts','where','subqry','left_join','uc.CmContactId\x20=\x20','.id','cm_contact_has_tags','ct.CmContactId\x20=\x20','t.id\x20=\x20ct.TagId','firstName','lastName','phone','mobile','fax','email','CompanyId','createdAt','TagIds','includes','push','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','escapeLIKESpecialChars','split','length','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','sqlOperator','conditions'];(function(_0x25f334,_0x44aab9){var _0x11fb6e=function(_0x15a527){while(--_0x15a527){_0x25f334['push'](_0x25f334['shift']());}};_0x11fb6e(++_0x44aab9);}(_0x67af,0x110));var _0xf67a=function(_0x4653f7,_0x3d3ae3){_0x4653f7=_0x4653f7-0x0;var _0x5454da=_0x67af[_0x4653f7];return _0x5454da;};'use strict';var _=require(_0xf67a('0x0'));var squel=require('squel');var as=require('../parsers/advancedSearch');var qs=require(_0xf67a('0x1'));var utils=require(_0xf67a('0x2'));var db=require(_0xf67a('0x3'))['db'];function skipContactsQuery(_0xd1b641,_0x21a3dc){var _0x498662=![];if(_0xd1b641['role']===_0xf67a('0x4')&&!_0x21a3dc[_0xf67a('0x5')]&&!_0x21a3dc['ListId']&&_0x21a3dc['autocomplete']!==_0xf67a('0x6')){_0x498662=!![];}return _0x498662;}function getContactsSubquery(){return squel[_0xf67a('0x7')]()[_0xf67a('0x8')](_0xf67a('0x9'),'c')[_0xf67a('0xa')]('c.deletedAt\x20IS\x20NULL');}function applyJoinClauses(_0x26bb53,_0x570eef){var _0xdd86b6=_0x570eef?'c':_0xf67a('0xb');_0x26bb53[_0xf67a('0xc')]('cm_user_has_contacts','uc',_0xf67a('0xd')+_0xdd86b6+_0xf67a('0xe'))[_0xf67a('0xc')](_0xf67a('0xf'),'ct',_0xf67a('0x10')+_0xdd86b6+_0xf67a('0xe'))[_0xf67a('0xc')]('tools_tags','t',_0xf67a('0x11'));return _0x26bb53;}function addFieldsToQuery(_0x3ea49e,_0x2650a7,_0x43e428,_0x1def50,_0x491a7c){var _0x1423cc=_0x491a7c?'c':_0xf67a('0xb');if(!_0x2650a7){_0x2650a7=['id',_0xf67a('0x12'),_0xf67a('0x13'),_0xf67a('0x14'),_0xf67a('0x15'),_0xf67a('0x16'),_0xf67a('0x17'),'ListId',_0xf67a('0x18'),_0xf67a('0x19'),'updatedAt','deletedAt',_0xf67a('0x1a')];}else if(!_0x2650a7[_0xf67a('0x1b')]('id')){_0x2650a7[_0xf67a('0x1c')]('id');}var _0x1bed3f=_0x43e428&&_0x491a7c||!_0x43e428&&!_0x491a7c;if(_0x1def50){_0x1bed3f=_0x1def50&&_0x491a7c||!_0x1def50&&!_0x491a7c;}_0x2650a7[_0xf67a('0x1d')](function(_0x1e0de7){if(_0x1e0de7===_0xf67a('0x1a')){if(_0x1bed3f){_0x3ea49e[_0xf67a('0x1e')](_0xf67a('0x1f'),_0x1e0de7);}else if(_0x43e428||_0x1def50){_0x3ea49e['field'](_0x1423cc+'.'+_0x1e0de7);}}else{_0x3ea49e[_0xf67a('0x1e')](_0x1423cc+'.'+_0x1e0de7);}});return _0x3ea49e;}function getSqlClauses(){var _0x5dd647={'default':squel[_0xf67a('0x20')](),'fields':squel['expr'](),'filter':squel[_0xf67a('0x20')](),'tags':{'clause':squel[_0xf67a('0x20')](),'ids':null},'user':{'clause':squel[_0xf67a('0x20')](),'skip':![]}};return _0x5dd647;}function parseTagParameter(_0x3ac1fa){var _0x220dd0=squel[_0xf67a('0x20')]();if(_0x3ac1fa){var _0x32f5df=utils[_0xf67a('0x21')](_0x3ac1fa);_0x32f5df[_0xf67a('0x1d')](function(_0xd4869e){_0x220dd0['or'](_0xf67a('0x22'),'%,'+_0xd4869e+',%');});}return _0x220dd0;}function parseSearchFilter(_0x4543cc){var _0x1986ae=squel[_0xf67a('0x20')]();if(_0x4543cc){var _0x1916a2=_0x4543cc['replace']('\x5c','\x5c\x5c')[_0xf67a('0x23')](/'/g,'\x27\x27');var _0x2faa96=qs[_0xf67a('0x24')](_0x1916a2);if(_0x1916a2[_0xf67a('0x25')]('\x20')[_0xf67a('0x26')]>0x1){_0x1986ae['or'](_0xf67a('0x27'),qs[_0xf67a('0x28')](_0x1916a2,!![]),null);}else{if(qs[_0xf67a('0x29')](_0x1916a2)){_0x1986ae['or'](_0xf67a('0x2a'),_0x2faa96+'%');_0x1986ae['or'](_0xf67a('0x2b'),_0x2faa96+'%');_0x1986ae['or'](_0xf67a('0x2c'),_0x2faa96+'%');_0x1986ae['or'](_0xf67a('0x2d'),_0x2faa96+'%');}else if(qs[_0xf67a('0x2e')](_0x1916a2)){_0x1986ae['or'](_0xf67a('0x2f'),_0x2faa96+'%');}else{_0x1986ae['or'](_0xf67a('0x30'),'%'+_0x2faa96+'%');_0x1986ae['or'](_0xf67a('0x31'),'%'+_0x2faa96+'%');_0x1986ae['or'](_0xf67a('0x2f'),'%'+_0x2faa96+'%');}}}return _0x1986ae;}function parseAdvancedSearchFilter(_0x3f6916,_0x302330){var _0x4bfd99=getSqlClauses();var _0x479960=as['parseSearch'](_0x3f6916);var _0x32d66b=_0x479960[_0xf67a('0x32')];for(var _0x192c77=0x0;_0x192c77<_0x479960[_0xf67a('0x33')][_0xf67a('0x26')];_0x192c77++){var _0x3345ee=_0x479960[_0xf67a('0x33')][_0x192c77];var _0x289b5b='c';var _0x3ead18=_['find'](_0x302330,[_0xf67a('0x34'),_0x3345ee[_0xf67a('0x1e')]]);if(_0x3ead18){if(_0x3345ee[_0xf67a('0x1e')]===_0xf67a('0x35')||_0x3ead18[_0xf67a('0x36')]==='datetime'){_0x3345ee[_0xf67a('0x37')]=_0xf67a('0x38');}var _0x4d8214=as[_0xf67a('0x39')](_0x289b5b,_0x3ead18[_0xf67a('0x3a')],_0x3345ee);_0x4bfd99[_0xf67a('0x3b')][_0x32d66b](_0x4d8214[_0xf67a('0x3c')],_0x4d8214[_0xf67a('0x3d')][_0xf67a('0x3e')],_0x4d8214['value'][_0xf67a('0x3f')]);}else{if(_0x3345ee['field']===_0xf67a('0x40')){var _0x55f3ab=_0x3345ee[_0xf67a('0x3d')]['split'](',')[_0xf67a('0x41')](function(_0x3bc686){return Number(_0x3bc686);});var _0x2c87d6=parseTagParameter(_0x55f3ab);_0x4bfd99[_0xf67a('0x42')][_0xf67a('0x43')][_0xf67a('0x44')](_0x2c87d6);_0x4bfd99['tags'][_0xf67a('0x45')]=_0x55f3ab;}else if(_0x3345ee[_0xf67a('0x1e')]===_0xf67a('0x46')){_0x4bfd99[_0xf67a('0x47')][_0xf67a('0x43')]['and'](_0xf67a('0x48'),_0x3345ee[_0xf67a('0x3d')]);_0x4bfd99[_0xf67a('0x47')][_0xf67a('0x49')]=!![];}}}return _0x4bfd99;}function parseModelFields(_0x164593,_0x37db0e){var _0x235b34=squel[_0xf67a('0x20')]();var _0x2df777=_(_0x164593)[_0xf67a('0x4a')]()[_0xf67a('0x41')](function(_0x20c489){return _[_0xf67a('0x4b')](_0x37db0e,['name',_0x20c489])?_0x20c489:undefined;})[_0xf67a('0x4c')]()[_0xf67a('0x3d')]();if(_0x164593[_0xf67a('0x4d')]){_0x2df777[_0xf67a('0x1c')]('Contact');}if(_0x164593['User']){_0x2df777['push'](_0xf67a('0x46'));}if(_0x2df777[_0xf67a('0x26')]>0x0){_0x2df777[_0xf67a('0x1d')](function(_0x534684){if(_0x534684==='ListId'){_0x235b34[_0xf67a('0x44')](_0xf67a('0x4e'),[]['concat'](_0x164593[_0x534684]));}else if(_0x534684===_0xf67a('0x4d')){var _0x5d7e04='%'+_0x164593[_0x534684]+'%';_0x235b34[_0xf67a('0x44')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x5d7e04);}else if(_0x534684==='User'){_0x235b34[_0xf67a('0x44')](_0xf67a('0x48'),_0x164593[_0x534684]);}else{_0x235b34[_0xf67a('0x44')]('c.'+_0x534684+'\x20=\x20?',_0x164593[_0x534684]);}});}return _0x235b34;}function parseQueryParameters(_0x3666e6,_0x352f88){var _0x164787=getSqlClauses();return Promise[_0xf67a('0x4f')]()[_0xf67a('0x50')](function(){return parseModelFields(_0x3666e6,_0x352f88);})[_0xf67a('0x50')](function(_0x210048){_0x164787[_0xf67a('0x51')][_0xf67a('0x44')](_0x210048);return parseTagParameter(_0x3666e6[_0xf67a('0x52')]);})[_0xf67a('0x50')](function(_0x436e13){_0x164787['tags'][_0xf67a('0x43')][_0xf67a('0x44')](_0x436e13);return parseSearchFilter(_0x3666e6['filter']);})[_0xf67a('0x50')](function(_0x45f0bc){_0x164787[_0xf67a('0x53')]=_0x45f0bc;return _0x164787;});}function checkListsRestrictions(_0xc01de0,_0x214e8f,_0x494108){var _0x382330=squel[_0xf67a('0x20')]();return Promise['resolve']()[_0xf67a('0x50')](function(){if(_0x214e8f[_0xf67a('0x5')]&&_0xc01de0[_0xf67a('0x54')]===_0xf67a('0x4')&&!_0x494108){return _0xc01de0[_0xf67a('0x55')]({'attributes':['id'],'raw':!![]});}})[_0xf67a('0x50')](function(_0x2fa816){if(_0x2fa816){if(_0x2fa816['length']===0x0){_0x382330['and'](_0xf67a('0x56'));}else{_0x382330[_0xf67a('0x44')](_0xf67a('0x4e'),_[_0xf67a('0x41')](_0x2fa816,'id'));}}})[_0xf67a('0x50')](function(){return _0x382330;});}function buildContactsQuery(_0x424d9a,_0x333c3d,_0x1b9522,_0x467ea2,_0x481a85,_0x3fb960){if(_0x333c3d){_0x333c3d=_0x1b9522['attributes'];}_0x424d9a=addFieldsToQuery(_0x424d9a,_0x333c3d,_0x467ea2,_0x3fb960,!![]);var _0x5cd249=squel['select']();_0x5cd249=addFieldsToQuery(_0x5cd249,_0x333c3d,_0x467ea2,_0x3fb960,![]);if(_0x467ea2||_0x3fb960){_0x424d9a=applyJoinClauses(_0x424d9a,!![]);_0x424d9a[_0xf67a('0x57')]('c.id');if(_0x1b9522[_0xf67a('0x58')]){_0x5cd249[_0xf67a('0x58')](_0x1b9522[_0xf67a('0x58')]);}if(_0x1b9522[_0xf67a('0x59')]){_0x5cd249['offset'](_0x1b9522[_0xf67a('0x59')]);}}else{_0x5cd249=applyJoinClauses(_0x5cd249,![]);_0x5cd249[_0xf67a('0x57')](_0xf67a('0x5a'));if(_0x1b9522[_0xf67a('0x58')]){_0x424d9a[_0xf67a('0x58')](_0x1b9522[_0xf67a('0x58')]);}if(_0x1b9522[_0xf67a('0x59')]){_0x424d9a['offset'](_0x1b9522['offset']);}}_0x5cd249[_0xf67a('0x5b')](_0x481a85);if(_0x1b9522[_0xf67a('0x5c')]){_0x1b9522[_0xf67a('0x5c')][_0xf67a('0x1d')](function(_0x3de736){_0x424d9a[_0xf67a('0x5c')]('c.'+_0x3de736[0x0],_0x3de736[0x1]===_0xf67a('0x5d')?![]:!![]);_0x5cd249['order'](_0xf67a('0x5e')+_0x3de736[0x0],_0x3de736[0x1]===_0xf67a('0x5d')?![]:!![]);});}_0x5cd249[_0xf67a('0x8')](_0x424d9a,_0xf67a('0xb'));return _0x5cd249;}function getFilteredContacts(_0x1318c9){var _0x332173=[];return db[_0xf67a('0x40')]['findAll']({'attributes':['id',_0xf67a('0x34'),'color'],'raw':!![]})[_0xf67a('0x50')](function(_0x20a088){_0x332173=_['keyBy'](_0x20a088,'id');var _0x6caa42={'type':db[_0xf67a('0x5f')][_0xf67a('0x60')][_0xf67a('0x61')],'model':db[_0xf67a('0x62')],'mapToModel':!![],'nest':!![],'raw':!![]};return db[_0xf67a('0x63')][_0xf67a('0x64')](_0x1318c9[_0xf67a('0x65')](),_0x6caa42);})['then'](function(_0xe074c0){_0xe074c0[_0xf67a('0x1d')](function(_0x301f96){if(_0x301f96[_0xf67a('0x1a')]){_0x301f96[_0xf67a('0x66')]=[];_0x301f96[_0xf67a('0x1a')][_0xf67a('0x25')](',')[_0xf67a('0x1d')](function(_0x43f690){_0x301f96['Tags'][_0xf67a('0x1c')](_0x332173[_0x43f690]);});}delete _0x301f96['TagIds'];});return _0xe074c0;});}function countFilteredContacts(_0x48879a,_0x526b0d){var _0x1aaa34=_0x48879a[_0xf67a('0x67')]();_0x1aaa34[_0xf67a('0x1e')](_0xf67a('0x68'));_0x1aaa34=applyJoinClauses(_0x1aaa34,!![]);_0x48879a[_0xf67a('0x57')]('c.id');var _0x16b387=utils[_0xf67a('0x21')](_0x526b0d);if(!_[_0xf67a('0x69')](_0x16b387)){_0x1aaa34[_0xf67a('0xa')](_0xf67a('0x6a'),_0x16b387);}var _0x241a2b={'type':db[_0xf67a('0x5f')][_0xf67a('0x60')][_0xf67a('0x61')],'raw':!![]};return db[_0xf67a('0x63')]['query'](_0x1aaa34['toString'](),_0x241a2b)[_0xf67a('0x50')](function(_0x4b7971){return _0x4b7971[0x0]['COUNT(*)'];});}module[_0xf67a('0x6b')]={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
git://repos.xcallymotion.com / motion2.git / blobdiff