// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0x1275=['limit','offset','having','order','DESC','subqry','findAll','color','Sequelize','QueryTypes','CmContact','sequelize','query','toString','Tags','clone','COUNT(*)','getSelectedTags','isEmpty','SELECT','exports','squel','../parsers/advancedSearch','../parsers/qs','../../mysqldb','role','agent','autocomplete','true','select','from','cm_contacts','where','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20','.id','cm_contact_has_tags','ct.CmContactId\x20=\x20','t.id\x20=\x20ct.TagId','firstName','mobile','fax','email','ListId','CompanyId','updatedAt','deletedAt','TagIds','includes','push','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','escapeLIKESpecialChars','split','MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)','isNumeric','c.id\x20LIKE\x20?','c.phone\x20LIKE\x20?','c.mobile\x20LIKE\x20?','c.fax\x20LIKE\x20?','isEmail','sqlOperator','conditions','length','name','castTo','DATE','buildExpression','type','text','value','end','Tag','map','clause','and','tags','user','uc.UserId\x20=\x20?','skip','keys','compact','Contact','User','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','then','fields','tag','filter','search','getLists','c.ListId\x20IS\x20NULL','attributes','group','c.id'];(function(_0x3a73bc,_0x550aef){var _0x32891b=function(_0x20b4cb){while(--_0x20b4cb){_0x3a73bc['push'](_0x3a73bc['shift']());}};_0x32891b(++_0x550aef);}(_0x1275,0xe3));var _0x5127=function(_0x283646,_0x3130bb){_0x283646=_0x283646-0x0;var _0x25b72d=_0x1275[_0x283646];return _0x25b72d;};'use strict';var _=require('lodash');var squel=require(_0x5127('0x0'));var as=require(_0x5127('0x1'));var qs=require(_0x5127('0x2'));var utils=require('../interaction/utils');var db=require(_0x5127('0x3'))['db'];function skipContactsQuery(_0x2fb869,_0x58bbfc){var _0x6027f1=![];if(_0x2fb869[_0x5127('0x4')]===_0x5127('0x5')&&!_0x58bbfc['search']&&!_0x58bbfc['ListId']&&_0x58bbfc[_0x5127('0x6')]!==_0x5127('0x7')){_0x6027f1=!![];}return _0x6027f1;}function getContactsSubquery(){return squel[_0x5127('0x8')]()[_0x5127('0x9')](_0x5127('0xa'),'c')[_0x5127('0xb')]('c.deletedAt\x20IS\x20NULL');}function applyJoinClauses(_0x26d089,_0x1e0e07){var _0x4a53bb=_0x1e0e07?'c':'subqry';_0x26d089[_0x5127('0xc')](_0x5127('0xd'),'uc',_0x5127('0xe')+_0x4a53bb+_0x5127('0xf'))[_0x5127('0xc')](_0x5127('0x10'),'ct',_0x5127('0x11')+_0x4a53bb+'.id')[_0x5127('0xc')]('tools_tags','t',_0x5127('0x12'));return _0x26d089;}function addFieldsToQuery(_0x1cb8bc,_0x524c77,_0x59626d,_0x4b969f,_0x7ec3d6){var _0x1ad146=_0x7ec3d6?'c':'subqry';if(!_0x524c77){_0x524c77=['id',_0x5127('0x13'),'lastName','phone',_0x5127('0x14'),_0x5127('0x15'),_0x5127('0x16'),_0x5127('0x17'),_0x5127('0x18'),'createdAt',_0x5127('0x19'),_0x5127('0x1a'),_0x5127('0x1b')];}else if(!_0x524c77[_0x5127('0x1c')]('id')){_0x524c77[_0x5127('0x1d')]('id');}var _0x4f7c5e=_0x59626d&&_0x7ec3d6||!_0x59626d&&!_0x7ec3d6;if(_0x4b969f){_0x4f7c5e=_0x4b969f&&_0x7ec3d6||!_0x4b969f&&!_0x7ec3d6;}_0x524c77[_0x5127('0x1e')](function(_0x35b77f){if(_0x35b77f===_0x5127('0x1b')){if(_0x4f7c5e){_0x1cb8bc[_0x5127('0x1f')](_0x5127('0x20'),_0x35b77f);}else if(_0x59626d||_0x4b969f){_0x1cb8bc[_0x5127('0x1f')](_0x1ad146+'.'+_0x35b77f);}}else{_0x1cb8bc[_0x5127('0x1f')](_0x1ad146+'.'+_0x35b77f);}});return _0x1cb8bc;}function getSqlClauses(){var _0x308a4a={'default':squel[_0x5127('0x21')](),'fields':squel[_0x5127('0x21')](),'filter':squel['expr'](),'tags':{'clause':squel[_0x5127('0x21')](),'ids':null},'user':{'clause':squel[_0x5127('0x21')](),'skip':![]}};return _0x308a4a;}function parseTagParameter(_0x3967af){var _0x2cfaca=squel[_0x5127('0x21')]();if(_0x3967af){var _0x464f58=utils['getSelectedTags'](_0x3967af);_0x464f58['forEach'](function(_0x290e70){_0x2cfaca['or'](_0x5127('0x22'),'%,'+_0x290e70+',%');});}return _0x2cfaca;}function parseSearchFilter(_0x47db17){var _0x3d91a6=squel['expr']();if(_0x47db17){var _0x15b1b2=_0x47db17[_0x5127('0x23')]('\x5c','\x5c\x5c')[_0x5127('0x23')](/'/g,'\x27\x27');var _0x34191f=qs[_0x5127('0x24')](_0x15b1b2);if(_0x15b1b2[_0x5127('0x25')]('\x20')['length']>0x1){_0x3d91a6['or'](_0x5127('0x26'),qs['getFullTextValue'](_0x15b1b2,!![]),null);}else{if(qs[_0x5127('0x27')](_0x15b1b2)){_0x3d91a6['or'](_0x5127('0x28'),_0x34191f+'%');_0x3d91a6['or'](_0x5127('0x29'),_0x34191f+'%');_0x3d91a6['or'](_0x5127('0x2a'),_0x34191f+'%');_0x3d91a6['or'](_0x5127('0x2b'),_0x34191f+'%');}else if(qs[_0x5127('0x2c')](_0x15b1b2)){_0x3d91a6['or']('c.email\x20LIKE\x20?',_0x34191f+'%');}else{_0x3d91a6['or']('c.firstName\x20LIKE\x20?','%'+_0x34191f+'%');_0x3d91a6['or']('c.lastName\x20LIKE\x20?','%'+_0x34191f+'%');_0x3d91a6['or']('c.email\x20LIKE\x20?','%'+_0x34191f+'%');}}}return _0x3d91a6;}function parseAdvancedSearchFilter(_0x35c589,_0x242dcc){var _0x2f7747=getSqlClauses();var _0x69ba0f=as['parseSearch'](_0x35c589);var _0x3e23b7=_0x69ba0f[_0x5127('0x2d')];for(var _0x3273f9=0x0;_0x3273f9<_0x69ba0f[_0x5127('0x2e')][_0x5127('0x2f')];_0x3273f9++){var _0x585497=_0x69ba0f[_0x5127('0x2e')][_0x3273f9];var _0x2a6d82='c';var _0x4595b2=_['find'](_0x242dcc,[_0x5127('0x30'),_0x585497[_0x5127('0x1f')]]);if(_0x4595b2){if(_0x585497[_0x5127('0x1f')]==='dateOfBirth'||_0x4595b2['fieldType']==='datetime'){_0x585497[_0x5127('0x31')]=_0x5127('0x32');}var _0x3147e1=as[_0x5127('0x33')](_0x2a6d82,_0x4595b2[_0x5127('0x34')],_0x585497);_0x2f7747['default'][_0x3e23b7](_0x3147e1[_0x5127('0x35')],_0x3147e1['value']['start'],_0x3147e1[_0x5127('0x36')][_0x5127('0x37')]);}else{if(_0x585497[_0x5127('0x1f')]===_0x5127('0x38')){var _0x155c8f=_0x585497[_0x5127('0x36')][_0x5127('0x25')](',')[_0x5127('0x39')](function(_0x41128f){return Number(_0x41128f);});var _0xf1ea45=parseTagParameter(_0x155c8f);_0x2f7747['tags'][_0x5127('0x3a')][_0x5127('0x3b')](_0xf1ea45);_0x2f7747[_0x5127('0x3c')]['ids']=_0x155c8f;}else if(_0x585497[_0x5127('0x1f')]==='User'){_0x2f7747[_0x5127('0x3d')][_0x5127('0x3a')][_0x5127('0x3b')](_0x5127('0x3e'),_0x585497[_0x5127('0x36')]);_0x2f7747['user'][_0x5127('0x3f')]=!![];}}}return _0x2f7747;}function parseModelFields(_0x29d998,_0x59d2d1){var _0x4c2ad2=squel[_0x5127('0x21')]();var _0x27eb80=_(_0x29d998)[_0x5127('0x40')]()[_0x5127('0x39')](function(_0x1b9739){return _['some'](_0x59d2d1,[_0x5127('0x30'),_0x1b9739])?_0x1b9739:undefined;})[_0x5127('0x41')]()[_0x5127('0x36')]();if(_0x29d998[_0x5127('0x42')]){_0x27eb80['push'](_0x5127('0x42'));}if(_0x29d998[_0x5127('0x43')]){_0x27eb80[_0x5127('0x1d')](_0x5127('0x43'));}if(_0x27eb80[_0x5127('0x2f')]>0x0){_0x27eb80[_0x5127('0x1e')](function(_0xf5010d){if(_0xf5010d==='ListId'){_0x4c2ad2['and'](_0x5127('0x44'),[][_0x5127('0x45')](_0x29d998[_0xf5010d]));}else if(_0xf5010d===_0x5127('0x42')){var _0x305104='%'+_0x29d998[_0xf5010d]+'%';_0x4c2ad2[_0x5127('0x3b')](_0x5127('0x46'),_0x305104);}else if(_0xf5010d===_0x5127('0x43')){_0x4c2ad2['and'](_0x5127('0x3e'),_0x29d998[_0xf5010d]);}else{_0x4c2ad2[_0x5127('0x3b')]('c.'+_0xf5010d+_0x5127('0x47'),_0x29d998[_0xf5010d]);}});}return _0x4c2ad2;}function parseQueryParameters(_0x1f8278,_0x5d101e){var _0x5acc2e=getSqlClauses();return Promise['resolve']()[_0x5127('0x48')](function(){return parseModelFields(_0x1f8278,_0x5d101e);})['then'](function(_0x55b555){_0x5acc2e[_0x5127('0x49')][_0x5127('0x3b')](_0x55b555);return parseTagParameter(_0x1f8278[_0x5127('0x4a')]);})['then'](function(_0x4a7955){_0x5acc2e[_0x5127('0x3c')][_0x5127('0x3a')][_0x5127('0x3b')](_0x4a7955);return parseSearchFilter(_0x1f8278[_0x5127('0x4b')]);})[_0x5127('0x48')](function(_0x3d2dff){_0x5acc2e[_0x5127('0x4b')]=_0x3d2dff;return _0x5acc2e;});}function checkListsRestrictions(_0x538284,_0xb3a1b9,_0x394003){var _0x11ee64=squel[_0x5127('0x21')]();return Promise['resolve']()[_0x5127('0x48')](function(){if(_0xb3a1b9[_0x5127('0x4c')]&&_0x538284[_0x5127('0x4')]===_0x5127('0x5')&&!_0x394003){return _0x538284[_0x5127('0x4d')]({'attributes':['id'],'raw':!![]});}})[_0x5127('0x48')](function(_0x209ba5){if(_0x209ba5){if(_0x209ba5['length']===0x0){_0x11ee64[_0x5127('0x3b')](_0x5127('0x4e'));}else{_0x11ee64[_0x5127('0x3b')](_0x5127('0x44'),_[_0x5127('0x39')](_0x209ba5,'id'));}}})[_0x5127('0x48')](function(){return _0x11ee64;});}function buildContactsQuery(_0x348991,_0x2d8ced,_0xa3588a,_0x3da0b1,_0x5de2c0,_0x2fbd25){if(_0x2d8ced){_0x2d8ced=_0xa3588a[_0x5127('0x4f')];}_0x348991=addFieldsToQuery(_0x348991,_0x2d8ced,_0x3da0b1,_0x2fbd25,!![]);var _0x1c5654=squel[_0x5127('0x8')]();_0x1c5654=addFieldsToQuery(_0x1c5654,_0x2d8ced,_0x3da0b1,_0x2fbd25,![]);if(_0x3da0b1||_0x2fbd25){_0x348991=applyJoinClauses(_0x348991,!![]);_0x348991[_0x5127('0x50')](_0x5127('0x51'));if(_0xa3588a[_0x5127('0x52')]){_0x1c5654[_0x5127('0x52')](_0xa3588a[_0x5127('0x52')]);}if(_0xa3588a[_0x5127('0x53')]){_0x1c5654[_0x5127('0x53')](_0xa3588a['offset']);}}else{_0x1c5654=applyJoinClauses(_0x1c5654,![]);_0x1c5654['group']('subqry.id');if(_0xa3588a[_0x5127('0x52')]){_0x348991['limit'](_0xa3588a[_0x5127('0x52')]);}if(_0xa3588a['offset']){_0x348991['offset'](_0xa3588a[_0x5127('0x53')]);}}_0x1c5654[_0x5127('0x54')](_0x5de2c0);if(_0xa3588a[_0x5127('0x55')]){_0xa3588a['order']['forEach'](function(_0x584063){_0x348991[_0x5127('0x55')]('c.'+_0x584063[0x0],_0x584063[0x1]===_0x5127('0x56')?![]:!![]);_0x1c5654['order']('subqry.'+_0x584063[0x0],_0x584063[0x1]==='DESC'?![]:!![]);});}_0x1c5654[_0x5127('0x9')](_0x348991,_0x5127('0x57'));return _0x1c5654;}function getFilteredContacts(_0x4b2597){var _0x3ab969=[];return db['Tag'][_0x5127('0x58')]({'attributes':['id',_0x5127('0x30'),_0x5127('0x59')],'raw':!![]})[_0x5127('0x48')](function(_0x2f0ccb){_0x3ab969=_['keyBy'](_0x2f0ccb,'id');var _0x3ca1fd={'type':db[_0x5127('0x5a')][_0x5127('0x5b')]['SELECT'],'model':db[_0x5127('0x5c')],'mapToModel':!![],'nest':!![],'raw':!![]};return db[_0x5127('0x5d')][_0x5127('0x5e')](_0x4b2597[_0x5127('0x5f')](),_0x3ca1fd);})['then'](function(_0x193a4b){_0x193a4b[_0x5127('0x1e')](function(_0x3cc38a){if(_0x3cc38a[_0x5127('0x1b')]){_0x3cc38a['Tags']=[];_0x3cc38a['TagIds'][_0x5127('0x25')](',')['forEach'](function(_0x3fe6fb){_0x3cc38a[_0x5127('0x60')]['push'](_0x3ab969[_0x3fe6fb]);});}delete _0x3cc38a[_0x5127('0x1b')];});return _0x193a4b;});}function countFilteredContacts(_0x5a4646,_0x2ce94f){var _0x27abd1=_0x5a4646[_0x5127('0x61')]();_0x27abd1[_0x5127('0x1f')](_0x5127('0x62'));_0x27abd1=applyJoinClauses(_0x27abd1,!![]);_0x5a4646[_0x5127('0x50')]('c.id');var _0x55d677=utils[_0x5127('0x63')](_0x2ce94f);if(!_[_0x5127('0x64')](_0x55d677)){_0x27abd1[_0x5127('0xb')]('t.id\x20IN\x20?',_0x55d677);}var _0x28deea={'type':db[_0x5127('0x5a')][_0x5127('0x5b')][_0x5127('0x65')],'raw':!![]};return db[_0x5127('0x5d')][_0x5127('0x5e')](_0x27abd1[_0x5127('0x5f')](),_0x28deea)['then'](function(_0x4c79c3){return _0x4c79c3[0x0]['COUNT(*)'];});}module[_0x5127('0x66')]={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
+var _0x7312=['select','from','cm_contacts','where','c.deletedAt\x20IS\x20NULL','subqry','cm_user_has_contacts','uc.CmContactId\x20=\x20','.id','left_join','cm_contact_has_tags','t.id\x20=\x20ct.TagId','firstName','lastName','phone','mobile','email','CompanyId','createdAt','updatedAt','deletedAt','includes','push','TagIds','field','expr','replace','escapeLIKESpecialChars','length','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','find','name','dateOfBirth','fieldType','datetime','castTo','DATE','type','value','start','end','Tag','map','tags','clause','ids','user','and','uc.UserId\x20=\x20?','skip','some','Contact','forEach','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','User','\x20=\x20?','resolve','then','fields','tag','filter','getLists','c.ListId\x20IS\x20NULL','attributes','group','offset','subqry.id','limit','having','order','subqry.','DESC','color','keyBy','Sequelize','SELECT','CmContact','query','toString','Tags','split','clone','COUNT(*)','c.id','getSelectedTags','isEmpty','t.id\x20IN\x20?','QueryTypes','sequelize','exports','lodash','squel','../parsers/advancedSearch','../interaction/utils','../../mysqldb','role','agent','search','ListId','autocomplete','true'];(function(_0x512a22,_0x59d3ad){var _0x504680=function(_0x2705e5){while(--_0x2705e5){_0x512a22['push'](_0x512a22['shift']());}};_0x504680(++_0x59d3ad);}(_0x7312,0x14b));var _0x2731=function(_0x11c573,_0x9e7c6e){_0x11c573=_0x11c573-0x0;var _0x6b72de=_0x7312[_0x11c573];return _0x6b72de;};'use strict';var _=require(_0x2731('0x0'));var squel=require(_0x2731('0x1'));var as=require(_0x2731('0x2'));var qs=require('../parsers/qs');var utils=require(_0x2731('0x3'));var db=require(_0x2731('0x4'))['db'];function skipContactsQuery(_0x566640,_0x2a80e2){var _0x3729ad=![];if(_0x566640[_0x2731('0x5')]===_0x2731('0x6')&&!_0x2a80e2[_0x2731('0x7')]&&!_0x2a80e2[_0x2731('0x8')]&&_0x2a80e2[_0x2731('0x9')]!==_0x2731('0xa')){_0x3729ad=!![];}return _0x3729ad;}function getContactsSubquery(){return squel[_0x2731('0xb')]()[_0x2731('0xc')](_0x2731('0xd'),'c')[_0x2731('0xe')](_0x2731('0xf'));}function applyJoinClauses(_0x4fe091,_0x5d66bd){var _0x29a862=_0x5d66bd?'c':_0x2731('0x10');_0x4fe091['left_join'](_0x2731('0x11'),'uc',_0x2731('0x12')+_0x29a862+_0x2731('0x13'))[_0x2731('0x14')](_0x2731('0x15'),'ct','ct.CmContactId\x20=\x20'+_0x29a862+_0x2731('0x13'))[_0x2731('0x14')]('tools_tags','t',_0x2731('0x16'));return _0x4fe091;}function addFieldsToQuery(_0x52e3fb,_0x1f05b2,_0x23cde0,_0x3c2694,_0x227e91){var _0x47c843=_0x227e91?'c':'subqry';if(!_0x1f05b2){_0x1f05b2=['id',_0x2731('0x17'),_0x2731('0x18'),_0x2731('0x19'),_0x2731('0x1a'),'fax',_0x2731('0x1b'),_0x2731('0x8'),_0x2731('0x1c'),_0x2731('0x1d'),_0x2731('0x1e'),_0x2731('0x1f'),'TagIds'];}else if(!_0x1f05b2[_0x2731('0x20')]('id')){_0x1f05b2[_0x2731('0x21')]('id');}var _0x403ecb=_0x23cde0&&_0x227e91||!_0x23cde0&&!_0x227e91;if(_0x3c2694){_0x403ecb=_0x3c2694&&_0x227e91||!_0x3c2694&&!_0x227e91;}_0x1f05b2['forEach'](function(_0x2f4ffc){if(_0x2f4ffc===_0x2731('0x22')){if(_0x403ecb){_0x52e3fb[_0x2731('0x23')]('GROUP_CONCAT(DISTINCT\x20t.id)',_0x2f4ffc);}else if(_0x23cde0||_0x3c2694){_0x52e3fb[_0x2731('0x23')](_0x47c843+'.'+_0x2f4ffc);}}else{_0x52e3fb['field'](_0x47c843+'.'+_0x2f4ffc);}});return _0x52e3fb;}function getSqlClauses(){var _0x2301ff={'default':squel['expr'](),'fields':squel[_0x2731('0x24')](),'filter':squel[_0x2731('0x24')](),'tags':{'clause':squel[_0x2731('0x24')](),'ids':null},'user':{'clause':squel[_0x2731('0x24')](),'skip':![]}};return _0x2301ff;}function parseTagParameter(_0x587850){var _0x2a9f68=squel['expr']();if(_0x587850){var _0x28fec1=utils['getSelectedTags'](_0x587850);_0x28fec1['forEach'](function(_0x50e358){_0x2a9f68['or']('CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','%,'+_0x50e358+',%');});}return _0x2a9f68;}function parseSearchFilter(_0x2103fb){var _0x34eecd=squel['expr']();if(_0x2103fb){var _0x2ff7ac=_0x2103fb[_0x2731('0x25')]('\x5c','\x5c\x5c')[_0x2731('0x25')](/'/g,'\x27\x27');var _0x54c961=qs[_0x2731('0x26')](_0x2ff7ac);if(_0x2ff7ac['split']('\x20')[_0x2731('0x27')]>0x1){_0x34eecd['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x2731('0x28')](_0x2ff7ac,!![]),null);}else{if(qs[_0x2731('0x29')](_0x2ff7ac)){_0x34eecd['or'](_0x2731('0x2a'),_0x54c961+'%');_0x34eecd['or'](_0x2731('0x2b'),_0x54c961+'%');_0x34eecd['or'](_0x2731('0x2c'),_0x54c961+'%');_0x34eecd['or'](_0x2731('0x2d'),_0x54c961+'%');}else if(qs[_0x2731('0x2e')](_0x2ff7ac)){_0x34eecd['or'](_0x2731('0x2f'),_0x54c961+'%');}else{_0x34eecd['or'](_0x2731('0x30'),'%'+_0x54c961+'%');_0x34eecd['or'](_0x2731('0x31'),'%'+_0x54c961+'%');_0x34eecd['or'](_0x2731('0x2f'),'%'+_0x54c961+'%');}}}return _0x34eecd;}function parseAdvancedSearchFilter(_0x4c6eac,_0x4dc54a){var _0x37e5ce=getSqlClauses();var _0x3900f7=as['parseSearch'](_0x4c6eac);var _0x15473a=_0x3900f7[_0x2731('0x32')];for(var _0x3a51f4=0x0;_0x3a51f4<_0x3900f7[_0x2731('0x33')][_0x2731('0x27')];_0x3a51f4++){var _0x13e202=_0x3900f7[_0x2731('0x33')][_0x3a51f4];var _0x1a58bc='c';var _0x2d20b1=_[_0x2731('0x34')](_0x4dc54a,[_0x2731('0x35'),_0x13e202[_0x2731('0x23')]]);if(_0x2d20b1){if(_0x13e202['field']===_0x2731('0x36')||_0x2d20b1[_0x2731('0x37')]===_0x2731('0x38')){_0x13e202[_0x2731('0x39')]=_0x2731('0x3a');}var _0x5c2ef1=as['buildExpression'](_0x1a58bc,_0x2d20b1[_0x2731('0x3b')],_0x13e202);_0x37e5ce['default'][_0x15473a](_0x5c2ef1['text'],_0x5c2ef1[_0x2731('0x3c')][_0x2731('0x3d')],_0x5c2ef1[_0x2731('0x3c')][_0x2731('0x3e')]);}else{if(_0x13e202[_0x2731('0x23')]===_0x2731('0x3f')){var _0x248363=_0x13e202[_0x2731('0x3c')]['split'](',')[_0x2731('0x40')](function(_0x5910ec){return Number(_0x5910ec);});var _0x1906e0=parseTagParameter(_0x248363);_0x37e5ce[_0x2731('0x41')][_0x2731('0x42')]['and'](_0x1906e0);_0x37e5ce[_0x2731('0x41')][_0x2731('0x43')]=_0x248363;}else if(_0x13e202[_0x2731('0x23')]==='User'){_0x37e5ce[_0x2731('0x44')][_0x2731('0x42')][_0x2731('0x45')](_0x2731('0x46'),_0x13e202[_0x2731('0x3c')]);_0x37e5ce[_0x2731('0x44')][_0x2731('0x47')]=!![];}}}return _0x37e5ce;}function parseModelFields(_0xfa8203,_0xa7571b){var _0xba1645=squel[_0x2731('0x24')]();var _0x3554ba=_(_0xfa8203)['keys']()[_0x2731('0x40')](function(_0x222690){return _[_0x2731('0x48')](_0xa7571b,[_0x2731('0x35'),_0x222690])?_0x222690:undefined;})['compact']()[_0x2731('0x3c')]();if(_0xfa8203[_0x2731('0x49')]){_0x3554ba[_0x2731('0x21')]('Contact');}if(_0xfa8203['User']){_0x3554ba[_0x2731('0x21')]('User');}if(_0x3554ba[_0x2731('0x27')]>0x0){_0x3554ba[_0x2731('0x4a')](function(_0x2e0119){if(_0x2e0119===_0x2731('0x8')){_0xba1645['and'](_0x2731('0x4b'),[][_0x2731('0x4c')](_0xfa8203[_0x2e0119]));}else if(_0x2e0119==='Contact'){var _0x338c7d='%'+_0xfa8203[_0x2e0119]+'%';_0xba1645[_0x2731('0x45')](_0x2731('0x4d'),_0x338c7d);}else if(_0x2e0119===_0x2731('0x4e')){_0xba1645[_0x2731('0x45')]('uc.UserId\x20=\x20?',_0xfa8203[_0x2e0119]);}else{_0xba1645[_0x2731('0x45')]('c.'+_0x2e0119+_0x2731('0x4f'),_0xfa8203[_0x2e0119]);}});}return _0xba1645;}function parseQueryParameters(_0x55f3b3,_0x3b8537){var _0x3cab9b=getSqlClauses();return Promise[_0x2731('0x50')]()[_0x2731('0x51')](function(){return parseModelFields(_0x55f3b3,_0x3b8537);})[_0x2731('0x51')](function(_0xf5a641){_0x3cab9b[_0x2731('0x52')]['and'](_0xf5a641);return parseTagParameter(_0x55f3b3[_0x2731('0x53')]);})[_0x2731('0x51')](function(_0x232e16){_0x3cab9b[_0x2731('0x41')][_0x2731('0x42')]['and'](_0x232e16);return parseSearchFilter(_0x55f3b3['filter']);})[_0x2731('0x51')](function(_0x29de52){_0x3cab9b[_0x2731('0x54')]=_0x29de52;return _0x3cab9b;});}function checkListsRestrictions(_0x5ae939,_0x168219,_0x145b35){var _0x434e5d=squel[_0x2731('0x24')]();return Promise[_0x2731('0x50')]()[_0x2731('0x51')](function(){if(_0x168219['search']&&_0x5ae939[_0x2731('0x5')]==='agent'&&!_0x145b35){return _0x5ae939[_0x2731('0x55')]({'attributes':['id'],'raw':!![]});}})[_0x2731('0x51')](function(_0x58f43f){if(_0x58f43f){if(_0x58f43f[_0x2731('0x27')]===0x0){_0x434e5d[_0x2731('0x45')](_0x2731('0x56'));}else{_0x434e5d['and'](_0x2731('0x4b'),_['map'](_0x58f43f,'id'));}}})[_0x2731('0x51')](function(){return _0x434e5d;});}function buildContactsQuery(_0x4348e5,_0x100851,_0x4576cd,_0x4841d6,_0x5911bd,_0x2ac3d1){if(_0x100851){_0x100851=_0x4576cd[_0x2731('0x57')];}_0x4348e5=addFieldsToQuery(_0x4348e5,_0x100851,_0x4841d6,_0x2ac3d1,!![]);var _0x468886=squel[_0x2731('0xb')]();_0x468886=addFieldsToQuery(_0x468886,_0x100851,_0x4841d6,_0x2ac3d1,![]);if(_0x4841d6||_0x2ac3d1){_0x4348e5=applyJoinClauses(_0x4348e5,!![]);_0x4348e5[_0x2731('0x58')]('c.id');if(_0x4576cd['limit']){_0x468886['limit'](_0x4576cd['limit']);}if(_0x4576cd[_0x2731('0x59')]){_0x468886[_0x2731('0x59')](_0x4576cd[_0x2731('0x59')]);}}else{_0x468886=applyJoinClauses(_0x468886,![]);_0x468886[_0x2731('0x58')](_0x2731('0x5a'));if(_0x4576cd['limit']){_0x4348e5['limit'](_0x4576cd[_0x2731('0x5b')]);}if(_0x4576cd[_0x2731('0x59')]){_0x4348e5['offset'](_0x4576cd['offset']);}}_0x468886[_0x2731('0x5c')](_0x5911bd);if(_0x4576cd[_0x2731('0x5d')]){_0x4576cd[_0x2731('0x5d')][_0x2731('0x4a')](function(_0x282172){_0x4348e5[_0x2731('0x5d')]('c.'+_0x282172[0x0],_0x282172[0x1]==='DESC'?![]:!![]);_0x468886[_0x2731('0x5d')](_0x2731('0x5e')+_0x282172[0x0],_0x282172[0x1]===_0x2731('0x5f')?![]:!![]);});}_0x468886[_0x2731('0xc')](_0x4348e5,_0x2731('0x10'));return _0x468886;}function getFilteredContacts(_0x37edb3){var _0x47bbfe=[];return db['Tag']['findAll']({'attributes':['id',_0x2731('0x35'),_0x2731('0x60')],'raw':!![]})[_0x2731('0x51')](function(_0xd4cd40){_0x47bbfe=_[_0x2731('0x61')](_0xd4cd40,'id');var _0x168280={'type':db[_0x2731('0x62')]['QueryTypes'][_0x2731('0x63')],'model':db[_0x2731('0x64')],'mapToModel':!![],'nest':!![],'raw':!![]};return db['sequelize'][_0x2731('0x65')](_0x37edb3[_0x2731('0x66')](),_0x168280);})['then'](function(_0x5b2265){_0x5b2265[_0x2731('0x4a')](function(_0x3e29f7){if(_0x3e29f7[_0x2731('0x22')]){_0x3e29f7[_0x2731('0x67')]=[];_0x3e29f7['TagIds'][_0x2731('0x68')](',')[_0x2731('0x4a')](function(_0x5809ff){_0x3e29f7['Tags']['push'](_0x47bbfe[_0x5809ff]);});}delete _0x3e29f7['TagIds'];});return _0x5b2265;});}function countFilteredContacts(_0x3260fb,_0x2d5ca2){var _0xbda441=_0x3260fb[_0x2731('0x69')]();_0xbda441[_0x2731('0x23')](_0x2731('0x6a'));_0xbda441=applyJoinClauses(_0xbda441,!![]);_0x3260fb[_0x2731('0x58')](_0x2731('0x6b'));var _0x2a6071=utils[_0x2731('0x6c')](_0x2d5ca2);if(!_[_0x2731('0x6d')](_0x2a6071)){_0xbda441[_0x2731('0xe')](_0x2731('0x6e'),_0x2a6071);}var _0x4e92e9={'type':db[_0x2731('0x62')][_0x2731('0x6f')][_0x2731('0x63')],'raw':!![]};return db[_0x2731('0x70')][_0x2731('0x65')](_0xbda441[_0x2731('0x66')](),_0x4e92e9)[_0x2731('0x51')](function(_0x14c119){return _0x14c119[0x0]['COUNT(*)'];});}module[_0x2731('0x71')]={'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