// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x2fa3=['keyBy','QueryTypes','SELECT','CmContact','query','toString','Tags','clone','Sequelize','sequelize','COUNT(*)','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','../interaction/utils','../../mysqldb','role','agent','search','ListId','autocomplete','true','select','from','cm_contacts','where','c.deletedAt\x20IS\x20NULL','subqry','left_join','uc.CmContactId\x20=\x20','.id','cm_contact_has_tags','ct.CmContactId\x20=\x20','tools_tags','t.id\x20=\x20ct.TagId','firstName','lastName','phone','mobile','fax','email','CompanyId','updatedAt','deletedAt','TagIds','includes','push','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','getFullTextValue','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?','parseSearch','sqlOperator','conditions','length','dateOfBirth','fieldType','castTo','DATE','buildExpression','default','start','value','end','Tag','map','tags','ids','User','user','clause','and','uc.UserId\x20=\x20?','skip','keys','some','compact','Contact','c.ListId\x20IN\x20?','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','resolve','then','fields','tag','filter','getLists','c.ListId\x20IS\x20NULL','attributes','group','limit','offset','subqry.id','having','order','DESC','subqry.','findAll','name','color'];(function(_0x284050,_0x3ea975){var _0x74e261=function(_0x3f9ace){while(--_0x3f9ace){_0x284050['push'](_0x284050['shift']());}};_0x74e261(++_0x3ea975);}(_0x2fa3,0xf4));var _0x32fa=function(_0x2efc25,_0x403b2f){_0x2efc25=_0x2efc25-0x0;var _0xe5238f=_0x2fa3[_0x2efc25];return _0xe5238f;};'use strict';var _=require(_0x32fa('0x0'));var squel=require(_0x32fa('0x1'));var as=require(_0x32fa('0x2'));var qs=require(_0x32fa('0x3'));var utils=require(_0x32fa('0x4'));var db=require(_0x32fa('0x5'))['db'];function skipContactsQuery(_0xbf4515,_0x16e3b9){var _0x59343b=![];if(_0xbf4515[_0x32fa('0x6')]===_0x32fa('0x7')&&!_0x16e3b9[_0x32fa('0x8')]&&!_0x16e3b9[_0x32fa('0x9')]&&_0x16e3b9[_0x32fa('0xa')]!==_0x32fa('0xb')){_0x59343b=!![];}return _0x59343b;}function getContactsSubquery(){return squel[_0x32fa('0xc')]()[_0x32fa('0xd')](_0x32fa('0xe'),'c')[_0x32fa('0xf')](_0x32fa('0x10'));}function applyJoinClauses(_0x18d807,_0x3364ac){var _0x122a4f=_0x3364ac?'c':_0x32fa('0x11');_0x18d807[_0x32fa('0x12')]('cm_user_has_contacts','uc',_0x32fa('0x13')+_0x122a4f+_0x32fa('0x14'))['left_join'](_0x32fa('0x15'),'ct',_0x32fa('0x16')+_0x122a4f+_0x32fa('0x14'))[_0x32fa('0x12')](_0x32fa('0x17'),'t',_0x32fa('0x18'));return _0x18d807;}function addFieldsToQuery(_0xe9f570,_0x2c00cc,_0x3f49b9,_0x187c96,_0x50aac5){var _0x43e62e=_0x50aac5?'c':_0x32fa('0x11');if(!_0x2c00cc){_0x2c00cc=['id',_0x32fa('0x19'),_0x32fa('0x1a'),_0x32fa('0x1b'),_0x32fa('0x1c'),_0x32fa('0x1d'),_0x32fa('0x1e'),_0x32fa('0x9'),_0x32fa('0x1f'),'createdAt',_0x32fa('0x20'),_0x32fa('0x21'),_0x32fa('0x22')];}else if(!_0x2c00cc[_0x32fa('0x23')]('id')){_0x2c00cc[_0x32fa('0x24')]('id');}var _0x36cde6=_0x3f49b9&&_0x50aac5||!_0x3f49b9&&!_0x50aac5;if(_0x187c96){_0x36cde6=_0x187c96&&_0x50aac5||!_0x187c96&&!_0x50aac5;}_0x2c00cc[_0x32fa('0x25')](function(_0x18ace7){if(_0x18ace7===_0x32fa('0x22')){if(_0x36cde6){_0xe9f570[_0x32fa('0x26')](_0x32fa('0x27'),_0x18ace7);}else if(_0x3f49b9||_0x187c96){_0xe9f570[_0x32fa('0x26')](_0x43e62e+'.'+_0x18ace7);}}else{_0xe9f570['field'](_0x43e62e+'.'+_0x18ace7);}});return _0xe9f570;}function getSqlClauses(){var _0x22615d={'default':squel[_0x32fa('0x28')](),'fields':squel[_0x32fa('0x28')](),'filter':squel[_0x32fa('0x28')](),'tags':{'clause':squel[_0x32fa('0x28')](),'ids':null},'user':{'clause':squel['expr'](),'skip':![]}};return _0x22615d;}function parseTagParameter(_0x4cfb08){var _0x35222e=squel['expr']();if(_0x4cfb08){var _0x63f43e=utils[_0x32fa('0x29')](_0x4cfb08);_0x63f43e[_0x32fa('0x25')](function(_0x3b8bd5){_0x35222e['or'](_0x32fa('0x2a'),'%,'+_0x3b8bd5+',%');});}return _0x35222e;}function parseSearchFilter(_0x3b380d){var _0x22854d=squel[_0x32fa('0x28')]();if(_0x3b380d){var _0x4fdbbb=_0x3b380d[_0x32fa('0x2b')]('\x5c','\x5c\x5c')[_0x32fa('0x2b')](/'/g,'\x27\x27');if(_0x4fdbbb[_0x32fa('0x2c')]('\x20')['length']>0x1){_0x22854d['or'](_0x32fa('0x2d'),qs[_0x32fa('0x2e')](_0x4fdbbb,!![]),null);}else{if(qs['isNumeric'](_0x4fdbbb)){_0x22854d['or'](_0x32fa('0x2f'),_0x4fdbbb+'%');_0x22854d['or'](_0x32fa('0x30'),_0x4fdbbb+'%');_0x22854d['or'](_0x32fa('0x31'),_0x4fdbbb+'%');_0x22854d['or'](_0x32fa('0x32'),_0x4fdbbb+'%');}else if(qs[_0x32fa('0x33')](_0x4fdbbb)){_0x22854d['or'](_0x32fa('0x34'),_0x4fdbbb+'%');}else{_0x22854d['or'](_0x32fa('0x35'),'%'+_0x4fdbbb+'%');_0x22854d['or'](_0x32fa('0x36'),'%'+_0x4fdbbb+'%');_0x22854d['or']('c.email\x20LIKE\x20?','%'+_0x4fdbbb+'%');}}}return _0x22854d;}function parseAdvancedSearchFilter(_0x2e1940,_0x1d47df){var _0x107b74=getSqlClauses();var _0x411217=as[_0x32fa('0x37')](_0x2e1940);var _0x116438=_0x411217[_0x32fa('0x38')];for(var _0x588526=0x0;_0x588526<_0x411217[_0x32fa('0x39')][_0x32fa('0x3a')];_0x588526++){var _0x11256d=_0x411217['conditions'][_0x588526];var _0x4c31c2='c';var _0x32272d=_['find'](_0x1d47df,['name',_0x11256d[_0x32fa('0x26')]]);if(_0x32272d){if(_0x11256d[_0x32fa('0x26')]===_0x32fa('0x3b')||_0x32272d[_0x32fa('0x3c')]==='datetime'){_0x11256d[_0x32fa('0x3d')]=_0x32fa('0x3e');}var _0xf7cbf6=as[_0x32fa('0x3f')](_0x4c31c2,_0x32272d['type'],_0x11256d);_0x107b74[_0x32fa('0x40')][_0x116438](_0xf7cbf6['text'],_0xf7cbf6['value'][_0x32fa('0x41')],_0xf7cbf6[_0x32fa('0x42')][_0x32fa('0x43')]);}else{if(_0x11256d['field']===_0x32fa('0x44')){var _0x4df33b=_0x11256d[_0x32fa('0x42')][_0x32fa('0x2c')](',')[_0x32fa('0x45')](function(_0x1dbe5e){return Number(_0x1dbe5e);});var _0xc7e71f=parseTagParameter(_0x4df33b);_0x107b74[_0x32fa('0x46')]['clause']['and'](_0xc7e71f);_0x107b74[_0x32fa('0x46')][_0x32fa('0x47')]=_0x4df33b;}else if(_0x11256d[_0x32fa('0x26')]===_0x32fa('0x48')){_0x107b74[_0x32fa('0x49')][_0x32fa('0x4a')][_0x32fa('0x4b')](_0x32fa('0x4c'),_0x11256d[_0x32fa('0x42')]);_0x107b74[_0x32fa('0x49')][_0x32fa('0x4d')]=!![];}}}return _0x107b74;}function parseModelFields(_0x3dd628,_0x1734d4){var _0xcbf681=squel[_0x32fa('0x28')]();var _0x13f1cc=_(_0x3dd628)[_0x32fa('0x4e')]()[_0x32fa('0x45')](function(_0x274369){return _[_0x32fa('0x4f')](_0x1734d4,['name',_0x274369])?_0x274369:undefined;})[_0x32fa('0x50')]()[_0x32fa('0x42')]();if(_0x3dd628[_0x32fa('0x51')]){_0x13f1cc[_0x32fa('0x24')](_0x32fa('0x51'));}if(_0x3dd628['User']){_0x13f1cc['push'](_0x32fa('0x48'));}if(_0x13f1cc[_0x32fa('0x3a')]>0x0){_0x13f1cc[_0x32fa('0x25')](function(_0x4e51ac){if(_0x4e51ac===_0x32fa('0x9')){_0xcbf681[_0x32fa('0x4b')](_0x32fa('0x52'),[]['concat'](_0x3dd628[_0x4e51ac]));}else if(_0x4e51ac===_0x32fa('0x51')){var _0x588156='%'+_0x3dd628[_0x4e51ac]+'%';_0xcbf681[_0x32fa('0x4b')](_0x32fa('0x53'),_0x588156);}else if(_0x4e51ac===_0x32fa('0x48')){_0xcbf681['and'](_0x32fa('0x4c'),_0x3dd628[_0x4e51ac]);}else{_0xcbf681[_0x32fa('0x4b')]('c.'+_0x4e51ac+_0x32fa('0x54'),_0x3dd628[_0x4e51ac]);}});}return _0xcbf681;}function parseQueryParameters(_0x5be13e,_0x3d1898){var _0x215f22=getSqlClauses();return Promise[_0x32fa('0x55')]()[_0x32fa('0x56')](function(){return parseModelFields(_0x5be13e,_0x3d1898);})[_0x32fa('0x56')](function(_0x5b6232){_0x215f22[_0x32fa('0x57')][_0x32fa('0x4b')](_0x5b6232);return parseTagParameter(_0x5be13e[_0x32fa('0x58')]);})[_0x32fa('0x56')](function(_0x4f36a3){_0x215f22[_0x32fa('0x46')][_0x32fa('0x4a')][_0x32fa('0x4b')](_0x4f36a3);return parseSearchFilter(_0x5be13e[_0x32fa('0x59')]);})[_0x32fa('0x56')](function(_0x40dcd3){_0x215f22[_0x32fa('0x59')]=_0x40dcd3;return _0x215f22;});}function checkListsRestrictions(_0x39bb2b,_0x225247,_0x1adb87){var _0x41e15b=squel[_0x32fa('0x28')]();return Promise[_0x32fa('0x55')]()[_0x32fa('0x56')](function(){if(_0x225247[_0x32fa('0x8')]&&_0x39bb2b[_0x32fa('0x6')]===_0x32fa('0x7')&&!_0x1adb87){return _0x39bb2b[_0x32fa('0x5a')]({'attributes':['id'],'raw':!![]});}})[_0x32fa('0x56')](function(_0x3d745e){if(_0x3d745e){if(_0x3d745e['length']===0x0){_0x41e15b[_0x32fa('0x4b')](_0x32fa('0x5b'));}else{_0x41e15b[_0x32fa('0x4b')](_0x32fa('0x52'),_['map'](_0x3d745e,'id'));}}})[_0x32fa('0x56')](function(){return _0x41e15b;});}function buildContactsQuery(_0x53a20b,_0x2b016f,_0x346528,_0x2aa51e,_0x2b1b98,_0x1468af){if(_0x2b016f){_0x2b016f=_0x346528[_0x32fa('0x5c')];}_0x53a20b=addFieldsToQuery(_0x53a20b,_0x2b016f,_0x2aa51e,_0x1468af,!![]);var _0x69306d=squel['select']();_0x69306d=addFieldsToQuery(_0x69306d,_0x2b016f,_0x2aa51e,_0x1468af,![]);if(_0x2aa51e||_0x1468af){_0x53a20b=applyJoinClauses(_0x53a20b,!![]);_0x53a20b[_0x32fa('0x5d')]('c.id');if(_0x346528[_0x32fa('0x5e')]){_0x69306d[_0x32fa('0x5e')](_0x346528['limit']);}if(_0x346528[_0x32fa('0x5f')]){_0x69306d['offset'](_0x346528[_0x32fa('0x5f')]);}}else{_0x69306d=applyJoinClauses(_0x69306d,![]);_0x69306d['group'](_0x32fa('0x60'));if(_0x346528['limit']){_0x53a20b['limit'](_0x346528[_0x32fa('0x5e')]);}if(_0x346528[_0x32fa('0x5f')]){_0x53a20b[_0x32fa('0x5f')](_0x346528['offset']);}}_0x69306d[_0x32fa('0x61')](_0x2b1b98);if(_0x346528[_0x32fa('0x62')]){_0x346528['order'][_0x32fa('0x25')](function(_0x212c6c){_0x53a20b['order']('c.'+_0x212c6c[0x0],_0x212c6c[0x1]===_0x32fa('0x63')?![]:!![]);_0x69306d['order'](_0x32fa('0x64')+_0x212c6c[0x0],_0x212c6c[0x1]===_0x32fa('0x63')?![]:!![]);});}_0x69306d['from'](_0x53a20b,_0x32fa('0x11'));return _0x69306d;}function getFilteredContacts(_0xb92c1a){var _0xc4cff6=[];return db['Tag'][_0x32fa('0x65')]({'attributes':['id',_0x32fa('0x66'),_0x32fa('0x67')],'raw':!![]})[_0x32fa('0x56')](function(_0x1cc980){_0xc4cff6=_[_0x32fa('0x68')](_0x1cc980,'id');var _0x4a5d3f={'type':db['Sequelize'][_0x32fa('0x69')][_0x32fa('0x6a')],'model':db[_0x32fa('0x6b')],'mapToModel':!![],'nest':!![],'raw':!![]};return db['sequelize'][_0x32fa('0x6c')](_0xb92c1a[_0x32fa('0x6d')](),_0x4a5d3f);})[_0x32fa('0x56')](function(_0xdc75fb){_0xdc75fb[_0x32fa('0x25')](function(_0x17a218){if(_0x17a218[_0x32fa('0x22')]){_0x17a218[_0x32fa('0x6e')]=[];_0x17a218[_0x32fa('0x22')][_0x32fa('0x2c')](',')[_0x32fa('0x25')](function(_0x5e8365){_0x17a218[_0x32fa('0x6e')][_0x32fa('0x24')](_0xc4cff6[_0x5e8365]);});}delete _0x17a218[_0x32fa('0x22')];});return _0xdc75fb;});}function countFilteredContacts(_0x83f963,_0x338f66){var _0x4697a7=_0x83f963[_0x32fa('0x6f')]();_0x4697a7[_0x32fa('0x26')]('COUNT(*)');_0x4697a7=applyJoinClauses(_0x4697a7,!![]);_0x83f963['group']('c.id');var _0x4912f4=utils[_0x32fa('0x29')](_0x338f66);if(!_['isEmpty'](_0x4912f4)){_0x4697a7[_0x32fa('0xf')]('t.id\x20IN\x20?',_0x4912f4);}var _0x4418b9={'type':db[_0x32fa('0x70')]['QueryTypes']['SELECT'],'raw':!![]};return db[_0x32fa('0x71')][_0x32fa('0x6c')](_0x4697a7[_0x32fa('0x6d')](),_0x4418b9)[_0x32fa('0x56')](function(_0x211c54){return _0x211c54[0x0][_0x32fa('0x72')];});}module[_0x32fa('0x73')]={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
+var _0xe39a=['text','value','start','end','Tag','map','tags','and','ids','User','user','skip','keys','some','compact','Contact','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','uc.UserId\x20=\x20?','\x20=\x20?','then','tag','clause','filter','resolve','search','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','attributes','group','c.id','limit','offset','subqry.id','having','order','DESC','subqry.','findAll','color','Sequelize','QueryTypes','SELECT','sequelize','query','toString','Tags','TagIds','COUNT(*)','where','t.id\x20IN\x20?','lodash','squel','../parsers/qs','../../mysqldb','role','agent','ListId','true','select','from','c.deletedAt\x20IS\x20NULL','subqry','left_join','uc.CmContactId\x20=\x20','cm_contact_has_tags','ct.CmContactId\x20=\x20','.id','tools_tags','firstName','lastName','phone','mobile','fax','email','CompanyId','createdAt','push','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','split','length','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?','parseSearch','sqlOperator','conditions','find','name','dateOfBirth','fieldType','datetime','castTo','buildExpression'];(function(_0x29e7f2,_0x22eff1){var _0x224079=function(_0x506002){while(--_0x506002){_0x29e7f2['push'](_0x29e7f2['shift']());}};_0x224079(++_0x22eff1);}(_0xe39a,0x1db));var _0xae39=function(_0x59531e,_0x5cde3d){_0x59531e=_0x59531e-0x0;var _0x24cdab=_0xe39a[_0x59531e];return _0x24cdab;};'use strict';var _=require(_0xae39('0x0'));var squel=require(_0xae39('0x1'));var as=require('../parsers/advancedSearch');var qs=require(_0xae39('0x2'));var utils=require('../interaction/utils');var db=require(_0xae39('0x3'))['db'];function skipContactsQuery(_0x4493ab,_0x45e815){var _0x36426e=![];if(_0x4493ab[_0xae39('0x4')]===_0xae39('0x5')&&!_0x45e815['search']&&!_0x45e815[_0xae39('0x6')]&&_0x45e815['autocomplete']!==_0xae39('0x7')){_0x36426e=!![];}return _0x36426e;}function getContactsSubquery(){return squel[_0xae39('0x8')]()[_0xae39('0x9')]('cm_contacts','c')['where'](_0xae39('0xa'));}function applyJoinClauses(_0x3856cf,_0x291de8){var _0x324258=_0x291de8?'c':_0xae39('0xb');_0x3856cf[_0xae39('0xc')]('cm_user_has_contacts','uc',_0xae39('0xd')+_0x324258+'.id')['left_join'](_0xae39('0xe'),'ct',_0xae39('0xf')+_0x324258+_0xae39('0x10'))[_0xae39('0xc')](_0xae39('0x11'),'t','t.id\x20=\x20ct.TagId');return _0x3856cf;}function addFieldsToQuery(_0x8ee1bf,_0x4a1d55,_0x2c9746,_0x53a84b,_0x54b832){var _0x3b43ae=_0x54b832?'c':_0xae39('0xb');if(!_0x4a1d55){_0x4a1d55=['id',_0xae39('0x12'),_0xae39('0x13'),_0xae39('0x14'),_0xae39('0x15'),_0xae39('0x16'),_0xae39('0x17'),_0xae39('0x6'),_0xae39('0x18'),_0xae39('0x19'),'updatedAt','deletedAt','TagIds'];}else if(!_0x4a1d55['includes']('id')){_0x4a1d55[_0xae39('0x1a')]('id');}var _0x10733a=_0x2c9746&&_0x54b832||!_0x2c9746&&!_0x54b832;if(_0x53a84b){_0x10733a=_0x53a84b&&_0x54b832||!_0x53a84b&&!_0x54b832;}_0x4a1d55[_0xae39('0x1b')](function(_0x77197f){if(_0x77197f==='TagIds'){if(_0x10733a){_0x8ee1bf[_0xae39('0x1c')](_0xae39('0x1d'),_0x77197f);}else if(_0x2c9746||_0x53a84b){_0x8ee1bf[_0xae39('0x1c')](_0x3b43ae+'.'+_0x77197f);}}else{_0x8ee1bf[_0xae39('0x1c')](_0x3b43ae+'.'+_0x77197f);}});return _0x8ee1bf;}function getSqlClauses(){var _0x3f2cf0={'default':squel[_0xae39('0x1e')](),'fields':squel[_0xae39('0x1e')](),'filter':squel['expr'](),'tags':{'clause':squel[_0xae39('0x1e')](),'ids':null},'user':{'clause':squel[_0xae39('0x1e')](),'skip':![]}};return _0x3f2cf0;}function parseTagParameter(_0x5130a6){var _0x174cc2=squel['expr']();if(_0x5130a6){var _0x519a29=utils[_0xae39('0x1f')](_0x5130a6);_0x519a29[_0xae39('0x1b')](function(_0x3d06ae){_0x174cc2['or'](_0xae39('0x20'),'%,'+_0x3d06ae+',%');});}return _0x174cc2;}function parseSearchFilter(_0x5d237b){var _0xf39c63=squel[_0xae39('0x1e')]();if(_0x5d237b){var _0x65ceb2=_0x5d237b[_0xae39('0x21')]('\x5c','\x5c\x5c')[_0xae39('0x21')](/'/g,'\x27\x27');if(_0x65ceb2[_0xae39('0x22')]('\x20')[_0xae39('0x23')]>0x1){_0xf39c63['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs['getFullTextValue'](_0x65ceb2,!![]),null);}else{if(qs[_0xae39('0x24')](_0x65ceb2)){_0xf39c63['or'](_0xae39('0x25'),_0x65ceb2+'%');_0xf39c63['or'](_0xae39('0x26'),_0x65ceb2+'%');_0xf39c63['or'](_0xae39('0x27'),_0x65ceb2+'%');_0xf39c63['or'](_0xae39('0x28'),_0x65ceb2+'%');}else if(qs[_0xae39('0x29')](_0x65ceb2)){_0xf39c63['or'](_0xae39('0x2a'),_0x65ceb2+'%');}else{_0xf39c63['or'](_0xae39('0x2b'),'%'+_0x65ceb2+'%');_0xf39c63['or'](_0xae39('0x2c'),'%'+_0x65ceb2+'%');_0xf39c63['or'](_0xae39('0x2a'),'%'+_0x65ceb2+'%');}}}return _0xf39c63;}function parseAdvancedSearchFilter(_0x41ca6e,_0x4e2711){var _0xb0ad6f=getSqlClauses();var _0x49f253=as[_0xae39('0x2d')](_0x41ca6e);var _0x1603e6=_0x49f253[_0xae39('0x2e')];for(var _0x47d536=0x0;_0x47d536<_0x49f253['conditions'][_0xae39('0x23')];_0x47d536++){var _0x53bffa=_0x49f253[_0xae39('0x2f')][_0x47d536];var _0x5d9840='c';var _0x28c581=_[_0xae39('0x30')](_0x4e2711,[_0xae39('0x31'),_0x53bffa[_0xae39('0x1c')]]);if(_0x28c581){if(_0x53bffa[_0xae39('0x1c')]===_0xae39('0x32')||_0x28c581[_0xae39('0x33')]===_0xae39('0x34')){_0x53bffa[_0xae39('0x35')]='DATE';}var _0x46578a=as[_0xae39('0x36')](_0x5d9840,_0x28c581['type'],_0x53bffa);_0xb0ad6f['default'][_0x1603e6](_0x46578a[_0xae39('0x37')],_0x46578a[_0xae39('0x38')][_0xae39('0x39')],_0x46578a[_0xae39('0x38')][_0xae39('0x3a')]);}else{if(_0x53bffa[_0xae39('0x1c')]===_0xae39('0x3b')){var _0x490402=_0x53bffa['value'][_0xae39('0x22')](',')[_0xae39('0x3c')](function(_0x1efb16){return Number(_0x1efb16);});var _0x5b7c5f=parseTagParameter(_0x490402);_0xb0ad6f[_0xae39('0x3d')]['clause'][_0xae39('0x3e')](_0x5b7c5f);_0xb0ad6f[_0xae39('0x3d')][_0xae39('0x3f')]=_0x490402;}else if(_0x53bffa[_0xae39('0x1c')]===_0xae39('0x40')){_0xb0ad6f[_0xae39('0x41')]['clause'][_0xae39('0x3e')]('uc.UserId\x20=\x20?',_0x53bffa[_0xae39('0x38')]);_0xb0ad6f[_0xae39('0x41')][_0xae39('0x42')]=!![];}}}return _0xb0ad6f;}function parseModelFields(_0x58f7ea,_0x4f2177){var _0x510117=squel[_0xae39('0x1e')]();var _0x17f826=_(_0x58f7ea)[_0xae39('0x43')]()['map'](function(_0x1ae212){return _[_0xae39('0x44')](_0x4f2177,[_0xae39('0x31'),_0x1ae212])?_0x1ae212:undefined;})[_0xae39('0x45')]()[_0xae39('0x38')]();if(_0x58f7ea[_0xae39('0x46')]){_0x17f826['push'](_0xae39('0x46'));}if(_0x58f7ea['User']){_0x17f826[_0xae39('0x1a')]('User');}if(_0x17f826[_0xae39('0x23')]>0x0){_0x17f826[_0xae39('0x1b')](function(_0x3bb14e){if(_0x3bb14e===_0xae39('0x6')){_0x510117[_0xae39('0x3e')]('c.ListId\x20IN\x20?',[][_0xae39('0x47')](_0x58f7ea[_0x3bb14e]));}else if(_0x3bb14e===_0xae39('0x46')){var _0x1bfaca='%'+_0x58f7ea[_0x3bb14e]+'%';_0x510117[_0xae39('0x3e')](_0xae39('0x48'),_0x1bfaca);}else if(_0x3bb14e===_0xae39('0x40')){_0x510117[_0xae39('0x3e')](_0xae39('0x49'),_0x58f7ea[_0x3bb14e]);}else{_0x510117[_0xae39('0x3e')]('c.'+_0x3bb14e+_0xae39('0x4a'),_0x58f7ea[_0x3bb14e]);}});}return _0x510117;}function parseQueryParameters(_0x4c05a8,_0x4b0b0c){var _0x58dab0=getSqlClauses();return Promise['resolve']()[_0xae39('0x4b')](function(){return parseModelFields(_0x4c05a8,_0x4b0b0c);})[_0xae39('0x4b')](function(_0x166c2e){_0x58dab0['fields']['and'](_0x166c2e);return parseTagParameter(_0x4c05a8[_0xae39('0x4c')]);})[_0xae39('0x4b')](function(_0x111f20){_0x58dab0[_0xae39('0x3d')][_0xae39('0x4d')][_0xae39('0x3e')](_0x111f20);return parseSearchFilter(_0x4c05a8[_0xae39('0x4e')]);})[_0xae39('0x4b')](function(_0x1f1614){_0x58dab0[_0xae39('0x4e')]=_0x1f1614;return _0x58dab0;});}function checkListsRestrictions(_0x22bfb3,_0x283c2b,_0x14a737){var _0x3273dc=squel['expr']();return Promise[_0xae39('0x4f')]()[_0xae39('0x4b')](function(){if(_0x283c2b[_0xae39('0x50')]&&_0x22bfb3[_0xae39('0x4')]===_0xae39('0x5')&&!_0x14a737){return _0x22bfb3['getLists']({'attributes':['id'],'raw':!![]});}})['then'](function(_0x43ae21){if(_0x43ae21){if(_0x43ae21[_0xae39('0x23')]===0x0){_0x3273dc[_0xae39('0x3e')](_0xae39('0x51'));}else{_0x3273dc['and'](_0xae39('0x52'),_[_0xae39('0x3c')](_0x43ae21,'id'));}}})[_0xae39('0x4b')](function(){return _0x3273dc;});}function buildContactsQuery(_0x4659f4,_0x85c39e,_0x1eb88d,_0x1fb288,_0x2dbe8f,_0x321392){if(_0x85c39e){_0x85c39e=_0x1eb88d[_0xae39('0x53')];}_0x4659f4=addFieldsToQuery(_0x4659f4,_0x85c39e,_0x1fb288,_0x321392,!![]);var _0x1f6d50=squel[_0xae39('0x8')]();_0x1f6d50=addFieldsToQuery(_0x1f6d50,_0x85c39e,_0x1fb288,_0x321392,![]);if(_0x1fb288||_0x321392){_0x4659f4=applyJoinClauses(_0x4659f4,!![]);_0x4659f4[_0xae39('0x54')](_0xae39('0x55'));if(_0x1eb88d[_0xae39('0x56')]){_0x1f6d50[_0xae39('0x56')](_0x1eb88d['limit']);}if(_0x1eb88d[_0xae39('0x57')]){_0x1f6d50[_0xae39('0x57')](_0x1eb88d[_0xae39('0x57')]);}}else{_0x1f6d50=applyJoinClauses(_0x1f6d50,![]);_0x1f6d50[_0xae39('0x54')](_0xae39('0x58'));if(_0x1eb88d[_0xae39('0x56')]){_0x4659f4[_0xae39('0x56')](_0x1eb88d[_0xae39('0x56')]);}if(_0x1eb88d[_0xae39('0x57')]){_0x4659f4[_0xae39('0x57')](_0x1eb88d[_0xae39('0x57')]);}}_0x1f6d50[_0xae39('0x59')](_0x2dbe8f);if(_0x1eb88d[_0xae39('0x5a')]){_0x1eb88d[_0xae39('0x5a')]['forEach'](function(_0x3ba214){_0x4659f4[_0xae39('0x5a')]('c.'+_0x3ba214[0x0],_0x3ba214[0x1]===_0xae39('0x5b')?![]:!![]);_0x1f6d50[_0xae39('0x5a')](_0xae39('0x5c')+_0x3ba214[0x0],_0x3ba214[0x1]===_0xae39('0x5b')?![]:!![]);});}_0x1f6d50[_0xae39('0x9')](_0x4659f4,_0xae39('0xb'));return _0x1f6d50;}function getFilteredContacts(_0x1502d2){var _0x3d8dd4=[];return db[_0xae39('0x3b')][_0xae39('0x5d')]({'attributes':['id',_0xae39('0x31'),_0xae39('0x5e')],'raw':!![]})[_0xae39('0x4b')](function(_0x29ec57){_0x3d8dd4=_['keyBy'](_0x29ec57,'id');var _0x30991f={'type':db[_0xae39('0x5f')][_0xae39('0x60')][_0xae39('0x61')],'model':db['CmContact'],'mapToModel':!![],'nest':!![],'raw':!![]};return db[_0xae39('0x62')][_0xae39('0x63')](_0x1502d2[_0xae39('0x64')](),_0x30991f);})['then'](function(_0x2e7432){_0x2e7432[_0xae39('0x1b')](function(_0x3fe76f){if(_0x3fe76f['TagIds']){_0x3fe76f[_0xae39('0x65')]=[];_0x3fe76f[_0xae39('0x66')][_0xae39('0x22')](',')[_0xae39('0x1b')](function(_0x32ee42){_0x3fe76f[_0xae39('0x65')][_0xae39('0x1a')](_0x3d8dd4[_0x32ee42]);});}delete _0x3fe76f[_0xae39('0x66')];});return _0x2e7432;});}function countFilteredContacts(_0x4a1174,_0x2be307){var _0x2a5c11=_0x4a1174['clone']();_0x2a5c11['field'](_0xae39('0x67'));_0x2a5c11=applyJoinClauses(_0x2a5c11,!![]);_0x4a1174[_0xae39('0x54')]('c.id');var _0x37afcf=utils[_0xae39('0x1f')](_0x2be307);if(!_['isEmpty'](_0x37afcf)){_0x2a5c11[_0xae39('0x68')](_0xae39('0x69'),_0x37afcf);}var _0x18f276={'type':db[_0xae39('0x5f')][_0xae39('0x60')][_0xae39('0x61')],'raw':!![]};return db[_0xae39('0x62')][_0xae39('0x63')](_0x2a5c11['toString'](),_0x18f276)[_0xae39('0x4b')](function(_0x630aba){return _0x630aba[0x0][_0xae39('0x67')];});}module['exports']={'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