// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x15fc=['user','uc.UserId\x20=\x20?','keys','Contact','\x20=\x20?','then','tag','filter','resolve','search','getLists','c.ListId\x20IS\x20NULL','c.ListId\x20IN\x20?','attributes','group','c.id','limit','offset','subqry.id','order','DESC','subqry.','from','findAll','color','keyBy','CmContact','query','Tags','COUNT(*)','isEmpty','t.id\x20IN\x20?','Sequelize','SELECT','sequelize','toString','squel','../parsers/advancedSearch','../parsers/qs','../interaction/utils','../../mysqldb','role','agent','ListId','autocomplete','true','select','cm_contacts','where','left_join','cm_user_has_contacts','.id','cm_contact_has_tags','ct.CmContactId\x20=\x20','tools_tags','t.id\x20=\x20ct.TagId','subqry','lastName','mobile','fax','email','CompanyId','createdAt','deletedAt','includes','push','forEach','TagIds','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','escapeLIKESpecialChars','split','length','getFullTextValue','c.id\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','name','dateOfBirth','fieldType','datetime','castTo','DATE','buildExpression','type','default','text','value','start','end','Tag','map','tags','clause','and','ids','User'];(function(_0x3ac79c,_0xa99790){var _0x15f124=function(_0x33799d){while(--_0x33799d){_0x3ac79c['push'](_0x3ac79c['shift']());}};_0x15f124(++_0xa99790);}(_0x15fc,0x8f));var _0xc15f=function(_0xe37cad,_0x9fcbdd){_0xe37cad=_0xe37cad-0x0;var _0x24593e=_0x15fc[_0xe37cad];return _0x24593e;};'use strict';var _=require('lodash');var squel=require(_0xc15f('0x0'));var as=require(_0xc15f('0x1'));var qs=require(_0xc15f('0x2'));var utils=require(_0xc15f('0x3'));var db=require(_0xc15f('0x4'))['db'];function skipContactsQuery(_0x469f9d,_0x3848b0){var _0x31ca0e=![];if(_0x469f9d[_0xc15f('0x5')]===_0xc15f('0x6')&&!_0x3848b0['search']&&!_0x3848b0[_0xc15f('0x7')]&&_0x3848b0[_0xc15f('0x8')]!==_0xc15f('0x9')){_0x31ca0e=!![];}return _0x31ca0e;}function getContactsSubquery(){return squel[_0xc15f('0xa')]()['from'](_0xc15f('0xb'),'c')[_0xc15f('0xc')]('c.deletedAt\x20IS\x20NULL');}function applyJoinClauses(_0x2d3788,_0x39510b){var _0x58d33a=_0x39510b?'c':'subqry';_0x2d3788[_0xc15f('0xd')](_0xc15f('0xe'),'uc','uc.CmContactId\x20=\x20'+_0x58d33a+_0xc15f('0xf'))[_0xc15f('0xd')](_0xc15f('0x10'),'ct',_0xc15f('0x11')+_0x58d33a+'.id')['left_join'](_0xc15f('0x12'),'t',_0xc15f('0x13'));return _0x2d3788;}function addFieldsToQuery(_0x317149,_0x16a3b2,_0x196bc8,_0x35cc4c,_0x45c65f){var _0x37f13e=_0x45c65f?'c':_0xc15f('0x14');if(!_0x16a3b2){_0x16a3b2=['id','firstName',_0xc15f('0x15'),'phone',_0xc15f('0x16'),_0xc15f('0x17'),_0xc15f('0x18'),_0xc15f('0x7'),_0xc15f('0x19'),_0xc15f('0x1a'),'updatedAt',_0xc15f('0x1b'),'TagIds'];}else if(!_0x16a3b2[_0xc15f('0x1c')]('id')){_0x16a3b2[_0xc15f('0x1d')]('id');}var _0x257dba=_0x196bc8&&_0x45c65f||!_0x196bc8&&!_0x45c65f;if(_0x35cc4c){_0x257dba=_0x35cc4c&&_0x45c65f||!_0x35cc4c&&!_0x45c65f;}_0x16a3b2[_0xc15f('0x1e')](function(_0x4abdc5){if(_0x4abdc5===_0xc15f('0x1f')){if(_0x257dba){_0x317149[_0xc15f('0x20')](_0xc15f('0x21'),_0x4abdc5);}else if(_0x196bc8||_0x35cc4c){_0x317149[_0xc15f('0x20')](_0x37f13e+'.'+_0x4abdc5);}}else{_0x317149[_0xc15f('0x20')](_0x37f13e+'.'+_0x4abdc5);}});return _0x317149;}function getSqlClauses(){var _0x4a6db2={'default':squel[_0xc15f('0x22')](),'fields':squel[_0xc15f('0x22')](),'filter':squel[_0xc15f('0x22')](),'tags':{'clause':squel[_0xc15f('0x22')](),'ids':null},'user':{'clause':squel[_0xc15f('0x22')](),'skip':![]}};return _0x4a6db2;}function parseTagParameter(_0x31de56){var _0x3ce885=squel['expr']();if(_0x31de56){var _0x30c8a0=utils[_0xc15f('0x23')](_0x31de56);_0x30c8a0[_0xc15f('0x1e')](function(_0x5d092e){_0x3ce885['or'](_0xc15f('0x24'),'%,'+_0x5d092e+',%');});}return _0x3ce885;}function parseSearchFilter(_0x327906){var _0xdea5=squel[_0xc15f('0x22')]();if(_0x327906){var _0x88832=_0x327906[_0xc15f('0x25')]('\x5c','\x5c\x5c')[_0xc15f('0x25')](/'/g,'\x27\x27');var _0x5cfb33=qs[_0xc15f('0x26')](_0x88832);if(_0x88832[_0xc15f('0x27')]('\x20')[_0xc15f('0x28')]>0x1){_0xdea5['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xc15f('0x29')](_0x88832,!![]),null);}else{if(qs['isNumeric'](_0x88832)){_0xdea5['or'](_0xc15f('0x2a'),_0x5cfb33+'%');_0xdea5['or']('c.phone\x20LIKE\x20?',_0x5cfb33+'%');_0xdea5['or'](_0xc15f('0x2b'),_0x5cfb33+'%');_0xdea5['or'](_0xc15f('0x2c'),_0x5cfb33+'%');}else if(qs[_0xc15f('0x2d')](_0x88832)){_0xdea5['or'](_0xc15f('0x2e'),_0x5cfb33+'%');}else{_0xdea5['or'](_0xc15f('0x2f'),'%'+_0x5cfb33+'%');_0xdea5['or'](_0xc15f('0x30'),'%'+_0x5cfb33+'%');_0xdea5['or'](_0xc15f('0x2e'),'%'+_0x5cfb33+'%');}}}return _0xdea5;}function parseAdvancedSearchFilter(_0x17495c,_0xd8bcb4){var _0x3b4d70=getSqlClauses();var _0x1b1f5e=as['parseSearch'](_0x17495c);var _0x1b708f=_0x1b1f5e[_0xc15f('0x31')];for(var _0x27d785=0x0;_0x27d785<_0x1b1f5e['conditions'][_0xc15f('0x28')];_0x27d785++){var _0x309fc8=_0x1b1f5e[_0xc15f('0x32')][_0x27d785];var _0x5c6f72='c';var _0x417eda=_['find'](_0xd8bcb4,[_0xc15f('0x33'),_0x309fc8[_0xc15f('0x20')]]);if(_0x417eda){if(_0x309fc8[_0xc15f('0x20')]===_0xc15f('0x34')||_0x417eda[_0xc15f('0x35')]===_0xc15f('0x36')){_0x309fc8[_0xc15f('0x37')]=_0xc15f('0x38');}var _0x73319c=as[_0xc15f('0x39')](_0x5c6f72,_0x417eda[_0xc15f('0x3a')],_0x309fc8);_0x3b4d70[_0xc15f('0x3b')][_0x1b708f](_0x73319c[_0xc15f('0x3c')],_0x73319c[_0xc15f('0x3d')][_0xc15f('0x3e')],_0x73319c[_0xc15f('0x3d')][_0xc15f('0x3f')]);}else{if(_0x309fc8[_0xc15f('0x20')]===_0xc15f('0x40')){var _0x661cf3=_0x309fc8[_0xc15f('0x3d')][_0xc15f('0x27')](',')[_0xc15f('0x41')](function(_0x89f100){return Number(_0x89f100);});var _0x5c20c8=parseTagParameter(_0x661cf3);_0x3b4d70[_0xc15f('0x42')][_0xc15f('0x43')][_0xc15f('0x44')](_0x5c20c8);_0x3b4d70[_0xc15f('0x42')][_0xc15f('0x45')]=_0x661cf3;}else if(_0x309fc8[_0xc15f('0x20')]===_0xc15f('0x46')){_0x3b4d70[_0xc15f('0x47')][_0xc15f('0x43')]['and'](_0xc15f('0x48'),_0x309fc8[_0xc15f('0x3d')]);_0x3b4d70['user']['skip']=!![];}}}return _0x3b4d70;}function parseModelFields(_0x4e37c1,_0x2b0e7e){var _0x48716d=squel['expr']();var _0xff4e1c=_(_0x4e37c1)[_0xc15f('0x49')]()[_0xc15f('0x41')](function(_0x1ef179){return _['some'](_0x2b0e7e,[_0xc15f('0x33'),_0x1ef179])?_0x1ef179:undefined;})['compact']()[_0xc15f('0x3d')]();if(_0x4e37c1[_0xc15f('0x4a')]){_0xff4e1c[_0xc15f('0x1d')](_0xc15f('0x4a'));}if(_0x4e37c1['User']){_0xff4e1c[_0xc15f('0x1d')](_0xc15f('0x46'));}if(_0xff4e1c[_0xc15f('0x28')]>0x0){_0xff4e1c[_0xc15f('0x1e')](function(_0x59c21e){if(_0x59c21e===_0xc15f('0x7')){_0x48716d[_0xc15f('0x44')]('c.ListId\x20IN\x20?',[]['concat'](_0x4e37c1[_0x59c21e]));}else if(_0x59c21e===_0xc15f('0x4a')){var _0x6d1ea8='%'+_0x4e37c1[_0x59c21e]+'%';_0x48716d[_0xc15f('0x44')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x6d1ea8);}else if(_0x59c21e===_0xc15f('0x46')){_0x48716d[_0xc15f('0x44')](_0xc15f('0x48'),_0x4e37c1[_0x59c21e]);}else{_0x48716d[_0xc15f('0x44')]('c.'+_0x59c21e+_0xc15f('0x4b'),_0x4e37c1[_0x59c21e]);}});}return _0x48716d;}function parseQueryParameters(_0x3becf5,_0x3e87b0){var _0x5cdf41=getSqlClauses();return Promise['resolve']()['then'](function(){return parseModelFields(_0x3becf5,_0x3e87b0);})[_0xc15f('0x4c')](function(_0x5a52dc){_0x5cdf41['fields'][_0xc15f('0x44')](_0x5a52dc);return parseTagParameter(_0x3becf5[_0xc15f('0x4d')]);})[_0xc15f('0x4c')](function(_0x4c6ba1){_0x5cdf41[_0xc15f('0x42')][_0xc15f('0x43')][_0xc15f('0x44')](_0x4c6ba1);return parseSearchFilter(_0x3becf5[_0xc15f('0x4e')]);})[_0xc15f('0x4c')](function(_0x3879bc){_0x5cdf41[_0xc15f('0x4e')]=_0x3879bc;return _0x5cdf41;});}function checkListsRestrictions(_0x259a32,_0x1b56e4,_0x3bb67d){var _0x3cef3c=squel[_0xc15f('0x22')]();return Promise[_0xc15f('0x4f')]()['then'](function(){if(_0x1b56e4[_0xc15f('0x50')]&&_0x259a32[_0xc15f('0x5')]==='agent'&&!_0x3bb67d){return _0x259a32[_0xc15f('0x51')]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x4733f3){if(_0x4733f3){if(_0x4733f3[_0xc15f('0x28')]===0x0){_0x3cef3c['and'](_0xc15f('0x52'));}else{_0x3cef3c[_0xc15f('0x44')](_0xc15f('0x53'),_[_0xc15f('0x41')](_0x4733f3,'id'));}}})[_0xc15f('0x4c')](function(){return _0x3cef3c;});}function buildContactsQuery(_0x17e5d2,_0x5008d8,_0x435c2b,_0x302ed4,_0x57b59e,_0x11c5e5){if(_0x5008d8){_0x5008d8=_0x435c2b[_0xc15f('0x54')];}_0x17e5d2=addFieldsToQuery(_0x17e5d2,_0x5008d8,_0x302ed4,_0x11c5e5,!![]);var _0x41b0f5=squel[_0xc15f('0xa')]();_0x41b0f5=addFieldsToQuery(_0x41b0f5,_0x5008d8,_0x302ed4,_0x11c5e5,![]);if(_0x302ed4||_0x11c5e5){_0x17e5d2=applyJoinClauses(_0x17e5d2,!![]);_0x17e5d2[_0xc15f('0x55')](_0xc15f('0x56'));if(_0x435c2b['limit']){_0x41b0f5['limit'](_0x435c2b[_0xc15f('0x57')]);}if(_0x435c2b[_0xc15f('0x58')]){_0x41b0f5[_0xc15f('0x58')](_0x435c2b[_0xc15f('0x58')]);}}else{_0x41b0f5=applyJoinClauses(_0x41b0f5,![]);_0x41b0f5[_0xc15f('0x55')](_0xc15f('0x59'));if(_0x435c2b[_0xc15f('0x57')]){_0x17e5d2[_0xc15f('0x57')](_0x435c2b[_0xc15f('0x57')]);}if(_0x435c2b['offset']){_0x17e5d2[_0xc15f('0x58')](_0x435c2b['offset']);}}_0x41b0f5['having'](_0x57b59e);if(_0x435c2b[_0xc15f('0x5a')]){_0x435c2b['order'][_0xc15f('0x1e')](function(_0x199210){_0x17e5d2['order']('c.'+_0x199210[0x0],_0x199210[0x1]===_0xc15f('0x5b')?![]:!![]);_0x41b0f5[_0xc15f('0x5a')](_0xc15f('0x5c')+_0x199210[0x0],_0x199210[0x1]==='DESC'?![]:!![]);});}_0x41b0f5[_0xc15f('0x5d')](_0x17e5d2,_0xc15f('0x14'));return _0x41b0f5;}function getFilteredContacts(_0x342474){var _0x25609b=[];return db[_0xc15f('0x40')][_0xc15f('0x5e')]({'attributes':['id',_0xc15f('0x33'),_0xc15f('0x5f')],'raw':!![]})[_0xc15f('0x4c')](function(_0x5aeb98){_0x25609b=_[_0xc15f('0x60')](_0x5aeb98,'id');var _0x4bd2fb={'type':db['Sequelize']['QueryTypes']['SELECT'],'model':db[_0xc15f('0x61')],'mapToModel':!![],'nest':!![],'raw':!![]};return db['sequelize'][_0xc15f('0x62')](_0x342474['toString'](),_0x4bd2fb);})[_0xc15f('0x4c')](function(_0x5aa359){_0x5aa359[_0xc15f('0x1e')](function(_0x2dc4f8){if(_0x2dc4f8[_0xc15f('0x1f')]){_0x2dc4f8[_0xc15f('0x63')]=[];_0x2dc4f8[_0xc15f('0x1f')][_0xc15f('0x27')](',')[_0xc15f('0x1e')](function(_0x4d0515){_0x2dc4f8['Tags'][_0xc15f('0x1d')](_0x25609b[_0x4d0515]);});}delete _0x2dc4f8[_0xc15f('0x1f')];});return _0x5aa359;});}function countFilteredContacts(_0x1f618a,_0x1ea910){var _0x3ecc2d=_0x1f618a['clone']();_0x3ecc2d[_0xc15f('0x20')](_0xc15f('0x64'));_0x3ecc2d=applyJoinClauses(_0x3ecc2d,!![]);_0x1f618a['group'](_0xc15f('0x56'));var _0x1436cb=utils[_0xc15f('0x23')](_0x1ea910);if(!_[_0xc15f('0x65')](_0x1436cb)){_0x3ecc2d[_0xc15f('0xc')](_0xc15f('0x66'),_0x1436cb);}var _0x10e554={'type':db[_0xc15f('0x67')]['QueryTypes'][_0xc15f('0x68')],'raw':!![]};return db[_0xc15f('0x69')]['query'](_0x3ecc2d[_0xc15f('0x6a')](),_0x10e554)[_0xc15f('0x4c')](function(_0x4a1db3){return _0x4a1db3[0x0][_0xc15f('0x64')];});}module['exports']={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
+var _0xe1c0=['push','field','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','escapeLIKESpecialChars','length','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','isEmail','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','parseSearch','sqlOperator','name','dateOfBirth','fieldType','castTo','DATE','buildExpression','type','default','text','value','start','Tag','map','tags','clause','ids','User','user','and','uc.UserId\x20=\x20?','skip','keys','compact','Contact','forEach','c.ListId\x20IN\x20?','\x20=\x20?','then','tag','filter','resolve','getLists','attributes','group','c.id','limit','offset','subqry.id','having','order','subqry.','DESC','findAll','color','keyBy','Sequelize','QueryTypes','SELECT','CmContact','query','Tags','split','clone','COUNT(*)','t.id\x20IN\x20?','sequelize','exports','lodash','squel','../parsers/advancedSearch','../parsers/qs','../interaction/utils','role','agent','search','ListId','select','from','cm_contacts','where','c.deletedAt\x20IS\x20NULL','subqry','left_join','cm_user_has_contacts','cm_contact_has_tags','ct.CmContactId\x20=\x20','.id','tools_tags','t.id\x20=\x20ct.TagId','firstName','lastName','phone','mobile','fax','email','CompanyId','createdAt','deletedAt','TagIds','includes'];(function(_0x21f11f,_0x30108e){var _0x401b06=function(_0x32d2c5){while(--_0x32d2c5){_0x21f11f['push'](_0x21f11f['shift']());}};_0x401b06(++_0x30108e);}(_0xe1c0,0x120));var _0x0e1c=function(_0x282292,_0x29f822){_0x282292=_0x282292-0x0;var _0x5312df=_0xe1c0[_0x282292];return _0x5312df;};'use strict';var _=require(_0x0e1c('0x0'));var squel=require(_0x0e1c('0x1'));var as=require(_0x0e1c('0x2'));var qs=require(_0x0e1c('0x3'));var utils=require(_0x0e1c('0x4'));var db=require('../../mysqldb')['db'];function skipContactsQuery(_0x5d7785,_0x552fcf){var _0x25dcd4=![];if(_0x5d7785[_0x0e1c('0x5')]===_0x0e1c('0x6')&&!_0x552fcf[_0x0e1c('0x7')]&&!_0x552fcf[_0x0e1c('0x8')]&&_0x552fcf['autocomplete']!=='true'){_0x25dcd4=!![];}return _0x25dcd4;}function getContactsSubquery(){return squel[_0x0e1c('0x9')]()[_0x0e1c('0xa')](_0x0e1c('0xb'),'c')[_0x0e1c('0xc')](_0x0e1c('0xd'));}function applyJoinClauses(_0x416bc6,_0x48d837){var _0x5b6b1b=_0x48d837?'c':_0x0e1c('0xe');_0x416bc6[_0x0e1c('0xf')](_0x0e1c('0x10'),'uc','uc.CmContactId\x20=\x20'+_0x5b6b1b+'.id')[_0x0e1c('0xf')](_0x0e1c('0x11'),'ct',_0x0e1c('0x12')+_0x5b6b1b+_0x0e1c('0x13'))[_0x0e1c('0xf')](_0x0e1c('0x14'),'t',_0x0e1c('0x15'));return _0x416bc6;}function addFieldsToQuery(_0x33f08f,_0x35ff22,_0x429aa4,_0x573ca1,_0x1da7cc){var _0x292b86=_0x1da7cc?'c':'subqry';if(!_0x35ff22){_0x35ff22=['id',_0x0e1c('0x16'),_0x0e1c('0x17'),_0x0e1c('0x18'),_0x0e1c('0x19'),_0x0e1c('0x1a'),_0x0e1c('0x1b'),_0x0e1c('0x8'),_0x0e1c('0x1c'),_0x0e1c('0x1d'),'updatedAt',_0x0e1c('0x1e'),_0x0e1c('0x1f')];}else if(!_0x35ff22[_0x0e1c('0x20')]('id')){_0x35ff22[_0x0e1c('0x21')]('id');}var _0xd8b252=_0x429aa4&&_0x1da7cc||!_0x429aa4&&!_0x1da7cc;if(_0x573ca1){_0xd8b252=_0x573ca1&&_0x1da7cc||!_0x573ca1&&!_0x1da7cc;}_0x35ff22['forEach'](function(_0x9202c4){if(_0x9202c4==='TagIds'){if(_0xd8b252){_0x33f08f[_0x0e1c('0x22')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x9202c4);}else if(_0x429aa4||_0x573ca1){_0x33f08f[_0x0e1c('0x22')](_0x292b86+'.'+_0x9202c4);}}else{_0x33f08f['field'](_0x292b86+'.'+_0x9202c4);}});return _0x33f08f;}function getSqlClauses(){var _0x43c1c6={'default':squel[_0x0e1c('0x23')](),'fields':squel[_0x0e1c('0x23')](),'filter':squel[_0x0e1c('0x23')](),'tags':{'clause':squel[_0x0e1c('0x23')](),'ids':null},'user':{'clause':squel[_0x0e1c('0x23')](),'skip':![]}};return _0x43c1c6;}function parseTagParameter(_0x3957c5){var _0x486055=squel[_0x0e1c('0x23')]();if(_0x3957c5){var _0x3544e3=utils[_0x0e1c('0x24')](_0x3957c5);_0x3544e3['forEach'](function(_0x50e632){_0x486055['or'](_0x0e1c('0x25'),'%,'+_0x50e632+',%');});}return _0x486055;}function parseSearchFilter(_0x2393bb){var _0x549599=squel[_0x0e1c('0x23')]();if(_0x2393bb){var _0x1a99b5=_0x2393bb['replace']('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');var _0x27c8f4=qs[_0x0e1c('0x26')](_0x1a99b5);if(_0x1a99b5['split']('\x20')[_0x0e1c('0x27')]>0x1){_0x549599['or'](_0x0e1c('0x28'),qs['getFullTextValue'](_0x1a99b5,!![]),null);}else{if(qs[_0x0e1c('0x29')](_0x1a99b5)){_0x549599['or']('c.id\x20LIKE\x20?',_0x27c8f4+'%');_0x549599['or'](_0x0e1c('0x2a'),_0x27c8f4+'%');_0x549599['or'](_0x0e1c('0x2b'),_0x27c8f4+'%');_0x549599['or']('c.fax\x20LIKE\x20?',_0x27c8f4+'%');}else if(qs[_0x0e1c('0x2c')](_0x1a99b5)){_0x549599['or'](_0x0e1c('0x2d'),_0x27c8f4+'%');}else{_0x549599['or'](_0x0e1c('0x2e'),'%'+_0x27c8f4+'%');_0x549599['or'](_0x0e1c('0x2f'),'%'+_0x27c8f4+'%');_0x549599['or'](_0x0e1c('0x2d'),'%'+_0x27c8f4+'%');}}}return _0x549599;}function parseAdvancedSearchFilter(_0x5f6bdc,_0xf659aa){var _0xc61ddc=getSqlClauses();var _0x45c9e1=as[_0x0e1c('0x30')](_0x5f6bdc);var _0x452061=_0x45c9e1[_0x0e1c('0x31')];for(var _0x474a7b=0x0;_0x474a7b<_0x45c9e1['conditions'][_0x0e1c('0x27')];_0x474a7b++){var _0x34af33=_0x45c9e1['conditions'][_0x474a7b];var _0x4a9999='c';var _0x3ae2ee=_['find'](_0xf659aa,[_0x0e1c('0x32'),_0x34af33['field']]);if(_0x3ae2ee){if(_0x34af33[_0x0e1c('0x22')]===_0x0e1c('0x33')||_0x3ae2ee[_0x0e1c('0x34')]==='datetime'){_0x34af33[_0x0e1c('0x35')]=_0x0e1c('0x36');}var _0x20444b=as[_0x0e1c('0x37')](_0x4a9999,_0x3ae2ee[_0x0e1c('0x38')],_0x34af33);_0xc61ddc[_0x0e1c('0x39')][_0x452061](_0x20444b[_0x0e1c('0x3a')],_0x20444b[_0x0e1c('0x3b')][_0x0e1c('0x3c')],_0x20444b[_0x0e1c('0x3b')]['end']);}else{if(_0x34af33[_0x0e1c('0x22')]===_0x0e1c('0x3d')){var _0x5a9dc4=_0x34af33[_0x0e1c('0x3b')]['split'](',')[_0x0e1c('0x3e')](function(_0x48f3ae){return Number(_0x48f3ae);});var _0x494122=parseTagParameter(_0x5a9dc4);_0xc61ddc[_0x0e1c('0x3f')][_0x0e1c('0x40')]['and'](_0x494122);_0xc61ddc[_0x0e1c('0x3f')][_0x0e1c('0x41')]=_0x5a9dc4;}else if(_0x34af33['field']===_0x0e1c('0x42')){_0xc61ddc[_0x0e1c('0x43')]['clause'][_0x0e1c('0x44')](_0x0e1c('0x45'),_0x34af33['value']);_0xc61ddc[_0x0e1c('0x43')][_0x0e1c('0x46')]=!![];}}}return _0xc61ddc;}function parseModelFields(_0x2d2dd6,_0x20f100){var _0x571795=squel[_0x0e1c('0x23')]();var _0x69b47b=_(_0x2d2dd6)[_0x0e1c('0x47')]()[_0x0e1c('0x3e')](function(_0x52a6fe){return _['some'](_0x20f100,[_0x0e1c('0x32'),_0x52a6fe])?_0x52a6fe:undefined;})[_0x0e1c('0x48')]()[_0x0e1c('0x3b')]();if(_0x2d2dd6[_0x0e1c('0x49')]){_0x69b47b['push']('Contact');}if(_0x2d2dd6[_0x0e1c('0x42')]){_0x69b47b[_0x0e1c('0x21')](_0x0e1c('0x42'));}if(_0x69b47b['length']>0x0){_0x69b47b[_0x0e1c('0x4a')](function(_0x4f1682){if(_0x4f1682===_0x0e1c('0x8')){_0x571795[_0x0e1c('0x44')](_0x0e1c('0x4b'),[]['concat'](_0x2d2dd6[_0x4f1682]));}else if(_0x4f1682===_0x0e1c('0x49')){var _0x403259='%'+_0x2d2dd6[_0x4f1682]+'%';_0x571795[_0x0e1c('0x44')]('CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?',_0x403259);}else if(_0x4f1682===_0x0e1c('0x42')){_0x571795[_0x0e1c('0x44')]('uc.UserId\x20=\x20?',_0x2d2dd6[_0x4f1682]);}else{_0x571795[_0x0e1c('0x44')]('c.'+_0x4f1682+_0x0e1c('0x4c'),_0x2d2dd6[_0x4f1682]);}});}return _0x571795;}function parseQueryParameters(_0x14f9b1,_0x48a710){var _0xb6fc43=getSqlClauses();return Promise['resolve']()[_0x0e1c('0x4d')](function(){return parseModelFields(_0x14f9b1,_0x48a710);})[_0x0e1c('0x4d')](function(_0x58e65a){_0xb6fc43['fields'][_0x0e1c('0x44')](_0x58e65a);return parseTagParameter(_0x14f9b1[_0x0e1c('0x4e')]);})[_0x0e1c('0x4d')](function(_0x4cc00c){_0xb6fc43[_0x0e1c('0x3f')][_0x0e1c('0x40')][_0x0e1c('0x44')](_0x4cc00c);return parseSearchFilter(_0x14f9b1['filter']);})[_0x0e1c('0x4d')](function(_0x26f3b6){_0xb6fc43[_0x0e1c('0x4f')]=_0x26f3b6;return _0xb6fc43;});}function checkListsRestrictions(_0x36f900,_0x2163fa,_0x3f030f){var _0x4334b1=squel[_0x0e1c('0x23')]();return Promise[_0x0e1c('0x50')]()[_0x0e1c('0x4d')](function(){if(_0x2163fa['search']&&_0x36f900['role']==='agent'&&!_0x3f030f){return _0x36f900[_0x0e1c('0x51')]({'attributes':['id'],'raw':!![]});}})['then'](function(_0x5e6624){if(_0x5e6624){if(_0x5e6624[_0x0e1c('0x27')]===0x0){_0x4334b1[_0x0e1c('0x44')]('c.ListId\x20IS\x20NULL');}else{_0x4334b1['and'](_0x0e1c('0x4b'),_[_0x0e1c('0x3e')](_0x5e6624,'id'));}}})[_0x0e1c('0x4d')](function(){return _0x4334b1;});}function buildContactsQuery(_0x5e5b5b,_0x3933ab,_0x34037f,_0x15c67e,_0x5eebbb,_0x31391d){if(_0x3933ab){_0x3933ab=_0x34037f[_0x0e1c('0x52')];}_0x5e5b5b=addFieldsToQuery(_0x5e5b5b,_0x3933ab,_0x15c67e,_0x31391d,!![]);var _0x214880=squel[_0x0e1c('0x9')]();_0x214880=addFieldsToQuery(_0x214880,_0x3933ab,_0x15c67e,_0x31391d,![]);if(_0x15c67e||_0x31391d){_0x5e5b5b=applyJoinClauses(_0x5e5b5b,!![]);_0x5e5b5b[_0x0e1c('0x53')](_0x0e1c('0x54'));if(_0x34037f[_0x0e1c('0x55')]){_0x214880[_0x0e1c('0x55')](_0x34037f[_0x0e1c('0x55')]);}if(_0x34037f[_0x0e1c('0x56')]){_0x214880['offset'](_0x34037f['offset']);}}else{_0x214880=applyJoinClauses(_0x214880,![]);_0x214880[_0x0e1c('0x53')](_0x0e1c('0x57'));if(_0x34037f['limit']){_0x5e5b5b[_0x0e1c('0x55')](_0x34037f[_0x0e1c('0x55')]);}if(_0x34037f[_0x0e1c('0x56')]){_0x5e5b5b[_0x0e1c('0x56')](_0x34037f[_0x0e1c('0x56')]);}}_0x214880[_0x0e1c('0x58')](_0x5eebbb);if(_0x34037f['order']){_0x34037f[_0x0e1c('0x59')][_0x0e1c('0x4a')](function(_0x1b0896){_0x5e5b5b[_0x0e1c('0x59')]('c.'+_0x1b0896[0x0],_0x1b0896[0x1]==='DESC'?![]:!![]);_0x214880[_0x0e1c('0x59')](_0x0e1c('0x5a')+_0x1b0896[0x0],_0x1b0896[0x1]===_0x0e1c('0x5b')?![]:!![]);});}_0x214880[_0x0e1c('0xa')](_0x5e5b5b,_0x0e1c('0xe'));return _0x214880;}function getFilteredContacts(_0x5c39db){var _0x4a0c84=[];return db[_0x0e1c('0x3d')][_0x0e1c('0x5c')]({'attributes':['id',_0x0e1c('0x32'),_0x0e1c('0x5d')],'raw':!![]})[_0x0e1c('0x4d')](function(_0x23e971){_0x4a0c84=_[_0x0e1c('0x5e')](_0x23e971,'id');var _0x11cf54={'type':db[_0x0e1c('0x5f')][_0x0e1c('0x60')][_0x0e1c('0x61')],'model':db[_0x0e1c('0x62')],'mapToModel':!![],'nest':!![],'raw':!![]};return db['sequelize'][_0x0e1c('0x63')](_0x5c39db['toString'](),_0x11cf54);})[_0x0e1c('0x4d')](function(_0x34b513){_0x34b513[_0x0e1c('0x4a')](function(_0x5468f7){if(_0x5468f7['TagIds']){_0x5468f7[_0x0e1c('0x64')]=[];_0x5468f7[_0x0e1c('0x1f')][_0x0e1c('0x65')](',')[_0x0e1c('0x4a')](function(_0xc0e8c6){_0x5468f7['Tags']['push'](_0x4a0c84[_0xc0e8c6]);});}delete _0x5468f7[_0x0e1c('0x1f')];});return _0x34b513;});}function countFilteredContacts(_0x1e4935,_0x528a94){var _0x2b5ca8=_0x1e4935[_0x0e1c('0x66')]();_0x2b5ca8[_0x0e1c('0x22')](_0x0e1c('0x67'));_0x2b5ca8=applyJoinClauses(_0x2b5ca8,!![]);_0x1e4935['group'](_0x0e1c('0x54'));var _0x506e13=utils['getSelectedTags'](_0x528a94);if(!_['isEmpty'](_0x506e13)){_0x2b5ca8[_0x0e1c('0xc')](_0x0e1c('0x68'),_0x506e13);}var _0x17f33f={'type':db[_0x0e1c('0x5f')][_0x0e1c('0x60')][_0x0e1c('0x61')],'raw':!![]};return db[_0x0e1c('0x69')]['query'](_0x2b5ca8['toString'](),_0x17f33f)['then'](function(_0x461fcf){return _0x461fcf[0x0][_0x0e1c('0x67')];});}module[_0x0e1c('0x6a')]={'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