// * treaties. The SOFTWARE PRODUCT is licensed, not sold. *
// * *
// *************************************************************************
-var _0xc143=['split','tags','clause','and','User','user','skip','keys','some','compact','Contact','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','uc.UserId\x20=\x20?','then','fields','filter','role','agent','getLists','c.ListId\x20IS\x20NULL','map','group','limit','offset','subqry.id','order','DESC','color','keyBy','Sequelize','QueryTypes','SELECT','query','toString','Tags','COUNT(*)','c.id','isEmpty','sequelize','exports','lodash','../parsers/advancedSearch','../parsers/qs','../../mysqldb','search','select','cm_contacts','where','c.deletedAt\x20IS\x20NULL','subqry','cm_user_has_contacts','uc.CmContactId\x20=\x20','.id','left_join','cm_contact_has_tags','tools_tags','t.id\x20=\x20ct.TagId','fax','email','ListId','CompanyId','updatedAt','includes','push','forEach','TagIds','GROUP_CONCAT(DISTINCT\x20t.id)','field','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','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?','parseSearch','sqlOperator','conditions','find','name','dateOfBirth','fieldType','DATE','buildExpression','default','value','end','Tag'];(function(_0x3fa37f,_0x397f16){var _0x5a01d5=function(_0xa23c65){while(--_0xa23c65){_0x3fa37f['push'](_0x3fa37f['shift']());}};_0x5a01d5(++_0x397f16);}(_0xc143,0x147));var _0x3c14=function(_0x573f1b,_0x22ebf4){_0x573f1b=_0x573f1b-0x0;var _0x1d6ecf=_0xc143[_0x573f1b];return _0x1d6ecf;};'use strict';var _=require(_0x3c14('0x0'));var squel=require('squel');var as=require(_0x3c14('0x1'));var qs=require(_0x3c14('0x2'));var utils=require('../interaction/utils');var db=require(_0x3c14('0x3'))['db'];function skipContactsQuery(_0x515f1f,_0x322b5f){var _0x587edc=![];if(_0x515f1f['role']==='agent'&&!_0x322b5f[_0x3c14('0x4')]&&!_0x322b5f['ListId']&&_0x322b5f['autocomplete']!=='true'){_0x587edc=!![];}return _0x587edc;}function getContactsSubquery(){return squel[_0x3c14('0x5')]()['from'](_0x3c14('0x6'),'c')[_0x3c14('0x7')](_0x3c14('0x8'));}function applyJoinClauses(_0x189db1,_0x288db4){var _0x1157bc=_0x288db4?'c':_0x3c14('0x9');_0x189db1['left_join'](_0x3c14('0xa'),'uc',_0x3c14('0xb')+_0x1157bc+_0x3c14('0xc'))[_0x3c14('0xd')](_0x3c14('0xe'),'ct','ct.CmContactId\x20=\x20'+_0x1157bc+_0x3c14('0xc'))['left_join'](_0x3c14('0xf'),'t',_0x3c14('0x10'));return _0x189db1;}function addFieldsToQuery(_0x36977c,_0x215511,_0x1ba586,_0x6d74f2,_0x17c8ee){var _0x5c193a=_0x17c8ee?'c':'subqry';if(!_0x215511){_0x215511=['id','firstName','lastName','phone','mobile',_0x3c14('0x11'),_0x3c14('0x12'),_0x3c14('0x13'),_0x3c14('0x14'),'createdAt',_0x3c14('0x15'),'deletedAt','TagIds'];}else if(!_0x215511[_0x3c14('0x16')]('id')){_0x215511[_0x3c14('0x17')]('id');}var _0x32e77=_0x1ba586&&_0x17c8ee||!_0x1ba586&&!_0x17c8ee;if(_0x6d74f2){_0x32e77=_0x6d74f2&&_0x17c8ee||!_0x6d74f2&&!_0x17c8ee;}_0x215511[_0x3c14('0x18')](function(_0x546438){if(_0x546438===_0x3c14('0x19')){if(_0x32e77){_0x36977c['field'](_0x3c14('0x1a'),_0x546438);}else if(_0x1ba586||_0x6d74f2){_0x36977c[_0x3c14('0x1b')](_0x5c193a+'.'+_0x546438);}}else{_0x36977c[_0x3c14('0x1b')](_0x5c193a+'.'+_0x546438);}});return _0x36977c;}function getSqlClauses(){var _0x32484={'default':squel['expr'](),'fields':squel['expr'](),'filter':squel['expr'](),'tags':{'clause':squel['expr'](),'ids':null},'user':{'clause':squel[_0x3c14('0x1c')](),'skip':![]}};return _0x32484;}function parseTagParameter(_0x4d921a){var _0x21afda=squel[_0x3c14('0x1c')]();if(_0x4d921a){var _0x4adbe0=utils[_0x3c14('0x1d')](_0x4d921a);_0x4adbe0[_0x3c14('0x18')](function(_0x57bcad){_0x21afda['or'](_0x3c14('0x1e'),'%,'+_0x57bcad+',%');});}return _0x21afda;}function parseSearchFilter(_0x3b11a1){var _0x5633cb=squel[_0x3c14('0x1c')]();if(_0x3b11a1){var _0x57fdbf=_0x3b11a1[_0x3c14('0x1f')]('\x5c','\x5c\x5c')['replace'](/'/g,'\x27\x27');if(_0x57fdbf['split']('\x20')['length']>0x1){_0x5633cb['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0x3c14('0x20')](_0x57fdbf,!![]),null);}else{if(qs['isNumeric'](_0x57fdbf)){_0x5633cb['or'](_0x3c14('0x21'),_0x57fdbf+'%');_0x5633cb['or']('c.phone\x20LIKE\x20?',_0x57fdbf+'%');_0x5633cb['or'](_0x3c14('0x22'),_0x57fdbf+'%');_0x5633cb['or'](_0x3c14('0x23'),_0x57fdbf+'%');}else if(qs[_0x3c14('0x24')](_0x57fdbf)){_0x5633cb['or'](_0x3c14('0x25'),_0x57fdbf+'%');}else{_0x5633cb['or'](_0x3c14('0x26'),'%'+_0x57fdbf+'%');_0x5633cb['or'](_0x3c14('0x27'),'%'+_0x57fdbf+'%');_0x5633cb['or'](_0x3c14('0x25'),'%'+_0x57fdbf+'%');}}}return _0x5633cb;}function parseAdvancedSearchFilter(_0x3ebec8,_0x2b6775){var _0x2d8c29=getSqlClauses();var _0x36b00a=as[_0x3c14('0x28')](_0x3ebec8);var _0x27c5ff=_0x36b00a[_0x3c14('0x29')];for(var _0x2beac6=0x0;_0x2beac6<_0x36b00a['conditions']['length'];_0x2beac6++){var _0x5f219e=_0x36b00a[_0x3c14('0x2a')][_0x2beac6];var _0x5a1e18='c';var _0x40f483=_[_0x3c14('0x2b')](_0x2b6775,[_0x3c14('0x2c'),_0x5f219e[_0x3c14('0x1b')]]);if(_0x40f483){if(_0x5f219e[_0x3c14('0x1b')]===_0x3c14('0x2d')||_0x40f483[_0x3c14('0x2e')]==='datetime'){_0x5f219e['castTo']=_0x3c14('0x2f');}var _0x11fa50=as[_0x3c14('0x30')](_0x5a1e18,_0x40f483['type'],_0x5f219e);_0x2d8c29[_0x3c14('0x31')][_0x27c5ff](_0x11fa50['text'],_0x11fa50[_0x3c14('0x32')]['start'],_0x11fa50['value'][_0x3c14('0x33')]);}else{if(_0x5f219e['field']===_0x3c14('0x34')){var _0x2aad9d=_0x5f219e[_0x3c14('0x32')][_0x3c14('0x35')](',')['map'](function(_0x183684){return Number(_0x183684);});var _0x15f60b=parseTagParameter(_0x2aad9d);_0x2d8c29[_0x3c14('0x36')][_0x3c14('0x37')][_0x3c14('0x38')](_0x15f60b);_0x2d8c29['tags']['ids']=_0x2aad9d;}else if(_0x5f219e[_0x3c14('0x1b')]===_0x3c14('0x39')){_0x2d8c29[_0x3c14('0x3a')]['clause']['and']('uc.UserId\x20=\x20?',_0x5f219e[_0x3c14('0x32')]);_0x2d8c29['user'][_0x3c14('0x3b')]=!![];}}}return _0x2d8c29;}function parseModelFields(_0x27912f,_0xda6b4){var _0x1689f0=squel['expr']();var _0x4edd41=_(_0x27912f)[_0x3c14('0x3c')]()['map'](function(_0x3a49ac){return _[_0x3c14('0x3d')](_0xda6b4,[_0x3c14('0x2c'),_0x3a49ac])?_0x3a49ac:undefined;})[_0x3c14('0x3e')]()[_0x3c14('0x32')]();if(_0x27912f[_0x3c14('0x3f')]){_0x4edd41['push'](_0x3c14('0x3f'));}if(_0x27912f[_0x3c14('0x39')]){_0x4edd41[_0x3c14('0x17')](_0x3c14('0x39'));}if(_0x4edd41['length']>0x0){_0x4edd41['forEach'](function(_0x5bcda1){if(_0x5bcda1==='ListId'){_0x1689f0[_0x3c14('0x38')](_0x3c14('0x40'),[][_0x3c14('0x41')](_0x27912f[_0x5bcda1]));}else if(_0x5bcda1==='Contact'){var _0x8da5da='%'+_0x27912f[_0x5bcda1]+'%';_0x1689f0[_0x3c14('0x38')](_0x3c14('0x42'),_0x8da5da);}else if(_0x5bcda1===_0x3c14('0x39')){_0x1689f0[_0x3c14('0x38')](_0x3c14('0x43'),_0x27912f[_0x5bcda1]);}else{_0x1689f0[_0x3c14('0x38')]('c.'+_0x5bcda1+'\x20=\x20?',_0x27912f[_0x5bcda1]);}});}return _0x1689f0;}function parseQueryParameters(_0x367dd8,_0x31cdd4){var _0x480653=getSqlClauses();return Promise['resolve']()[_0x3c14('0x44')](function(){return parseModelFields(_0x367dd8,_0x31cdd4);})[_0x3c14('0x44')](function(_0x4f9c1c){_0x480653[_0x3c14('0x45')]['and'](_0x4f9c1c);return parseTagParameter(_0x367dd8['tag']);})[_0x3c14('0x44')](function(_0x235e41){_0x480653[_0x3c14('0x36')]['clause'][_0x3c14('0x38')](_0x235e41);return parseSearchFilter(_0x367dd8[_0x3c14('0x46')]);})[_0x3c14('0x44')](function(_0x18e167){_0x480653[_0x3c14('0x46')]=_0x18e167;return _0x480653;});}function checkListsRestrictions(_0x190fe4,_0x4c2d0b,_0x9e79b1){var _0x491a0a=squel[_0x3c14('0x1c')]();return Promise['resolve']()[_0x3c14('0x44')](function(){if(_0x4c2d0b['search']&&_0x190fe4[_0x3c14('0x47')]===_0x3c14('0x48')&&!_0x9e79b1){return _0x190fe4[_0x3c14('0x49')]({'attributes':['id'],'raw':!![]});}})[_0x3c14('0x44')](function(_0x25cc9e){if(_0x25cc9e){if(_0x25cc9e['length']===0x0){_0x491a0a[_0x3c14('0x38')](_0x3c14('0x4a'));}else{_0x491a0a['and'](_0x3c14('0x40'),_[_0x3c14('0x4b')](_0x25cc9e,'id'));}}})[_0x3c14('0x44')](function(){return _0x491a0a;});}function buildContactsQuery(_0x41d252,_0x55c3e2,_0x1e501a,_0x242122,_0x2f01b4,_0x386e73){if(_0x55c3e2){_0x55c3e2=_0x1e501a['attributes'];}_0x41d252=addFieldsToQuery(_0x41d252,_0x55c3e2,_0x242122,_0x386e73,!![]);var _0x475e43=squel[_0x3c14('0x5')]();_0x475e43=addFieldsToQuery(_0x475e43,_0x55c3e2,_0x242122,_0x386e73,![]);if(_0x242122||_0x386e73){_0x41d252=applyJoinClauses(_0x41d252,!![]);_0x41d252[_0x3c14('0x4c')]('c.id');if(_0x1e501a[_0x3c14('0x4d')]){_0x475e43[_0x3c14('0x4d')](_0x1e501a['limit']);}if(_0x1e501a[_0x3c14('0x4e')]){_0x475e43[_0x3c14('0x4e')](_0x1e501a[_0x3c14('0x4e')]);}}else{_0x475e43=applyJoinClauses(_0x475e43,![]);_0x475e43['group'](_0x3c14('0x4f'));if(_0x1e501a[_0x3c14('0x4d')]){_0x41d252[_0x3c14('0x4d')](_0x1e501a['limit']);}if(_0x1e501a['offset']){_0x41d252[_0x3c14('0x4e')](_0x1e501a[_0x3c14('0x4e')]);}}_0x475e43['having'](_0x2f01b4);if(_0x1e501a[_0x3c14('0x50')]){_0x1e501a[_0x3c14('0x50')][_0x3c14('0x18')](function(_0x2fa0a8){_0x41d252[_0x3c14('0x50')]('c.'+_0x2fa0a8[0x0],_0x2fa0a8[0x1]===_0x3c14('0x51')?![]:!![]);_0x475e43[_0x3c14('0x50')]('subqry.'+_0x2fa0a8[0x0],_0x2fa0a8[0x1]===_0x3c14('0x51')?![]:!![]);});}_0x475e43['from'](_0x41d252,_0x3c14('0x9'));return _0x475e43;}function getFilteredContacts(_0x124c08){var _0x504f59=[];return db['Tag']['findAll']({'attributes':['id',_0x3c14('0x2c'),_0x3c14('0x52')],'raw':!![]})[_0x3c14('0x44')](function(_0x445cb4){_0x504f59=_[_0x3c14('0x53')](_0x445cb4,'id');var _0x19baae={'type':db[_0x3c14('0x54')][_0x3c14('0x55')][_0x3c14('0x56')],'model':db['CmContact'],'mapToModel':!![],'nest':!![],'raw':!![]};return db['sequelize'][_0x3c14('0x57')](_0x124c08[_0x3c14('0x58')](),_0x19baae);})[_0x3c14('0x44')](function(_0x101b2c){_0x101b2c[_0x3c14('0x18')](function(_0x45ffaf){if(_0x45ffaf[_0x3c14('0x19')]){_0x45ffaf[_0x3c14('0x59')]=[];_0x45ffaf['TagIds'][_0x3c14('0x35')](',')[_0x3c14('0x18')](function(_0x20b238){_0x45ffaf[_0x3c14('0x59')][_0x3c14('0x17')](_0x504f59[_0x20b238]);});}delete _0x45ffaf[_0x3c14('0x19')];});return _0x101b2c;});}function countFilteredContacts(_0x2f2799,_0x1d40e7){var _0x1df19c=_0x2f2799['clone']();_0x1df19c[_0x3c14('0x1b')](_0x3c14('0x5a'));_0x1df19c=applyJoinClauses(_0x1df19c,!![]);_0x2f2799['group'](_0x3c14('0x5b'));var _0xab2d88=utils[_0x3c14('0x1d')](_0x1d40e7);if(!_[_0x3c14('0x5c')](_0xab2d88)){_0x1df19c[_0x3c14('0x7')]('t.id\x20IN\x20?',_0xab2d88);}var _0x2c85bd={'type':db['Sequelize']['QueryTypes'][_0x3c14('0x56')],'raw':!![]};return db[_0x3c14('0x5d')][_0x3c14('0x57')](_0x1df19c[_0x3c14('0x58')](),_0x2c85bd)[_0x3c14('0x44')](function(_0x34420f){return _0x34420f[0x0][_0x3c14('0x5a')];});}module[_0x3c14('0x5e')]={'buildContactsQuery':buildContactsQuery,'checkListsRestrictions':checkListsRestrictions,'countFilteredContacts':countFilteredContacts,'getContactsSubquery':getContactsSubquery,'getFilteredContacts':getFilteredContacts,'parseAdvancedSearchFilter':parseAdvancedSearchFilter,'parseQueryParameters':parseQueryParameters,'skipContactsQuery':skipContactsQuery};
\ No newline at end of file
+var _0xbf8d=['group','c.id','limit','offset','subqry.id','having','order','DESC','subqry.','Tag','findAll','color','Sequelize','CmContact','sequelize','query','Tags','push','clone','COUNT(*)','isEmpty','QueryTypes','SELECT','toString','exports','lodash','../parsers/advancedSearch','../interaction/utils','role','agent','search','ListId','autocomplete','from','cm_contacts','where','subqry','left_join','cm_user_has_contacts','uc.CmContactId\x20=\x20','cm_contact_has_tags','ct.CmContactId\x20=\x20','.id','tools_tags','t.id\x20=\x20ct.TagId','phone','mobile','email','CompanyId','createdAt','updatedAt','deletedAt','TagIds','includes','forEach','field','GROUP_CONCAT(DISTINCT\x20t.id)','expr','getSelectedTags','CONCAT(\x27,\x27,\x20subqry.TagIds,\x20\x27,\x27)\x20LIKE\x20?','replace','length','getFullTextValue','isNumeric','c.fax\x20LIKE\x20?','c.email\x20LIKE\x20?','c.firstName\x20LIKE\x20?','c.lastName\x20LIKE\x20?','parseSearch','sqlOperator','conditions','dateOfBirth','fieldType','castTo','DATE','buildExpression','type','default','text','value','start','end','split','map','tags','clause','and','user','keys','some','name','compact','Contact','User','c.ListId\x20IN\x20?','concat','CONCAT_WS(\x27\x20\x27,\x20c.firstName,\x20c.lastName,\x20c.email)\x20LIKE\x20?','\x20=\x20?','resolve','then','tag','filter','getLists','c.ListId\x20IS\x20NULL','select'];(function(_0x52270c,_0x2cc8b4){var _0x24700f=function(_0x1a714b){while(--_0x1a714b){_0x52270c['push'](_0x52270c['shift']());}};_0x24700f(++_0x2cc8b4);}(_0xbf8d,0x1bd));var _0xdbf8=function(_0x3c6626,_0x524a6f){_0x3c6626=_0x3c6626-0x0;var _0xee83de=_0xbf8d[_0x3c6626];return _0xee83de;};'use strict';var _=require(_0xdbf8('0x0'));var squel=require('squel');var as=require(_0xdbf8('0x1'));var qs=require('../parsers/qs');var utils=require(_0xdbf8('0x2'));var db=require('../../mysqldb')['db'];function skipContactsQuery(_0x3bfbd3,_0x557386){var _0xc8623f=![];if(_0x3bfbd3[_0xdbf8('0x3')]===_0xdbf8('0x4')&&!_0x557386[_0xdbf8('0x5')]&&!_0x557386[_0xdbf8('0x6')]&&_0x557386[_0xdbf8('0x7')]!=='true'){_0xc8623f=!![];}return _0xc8623f;}function getContactsSubquery(){return squel['select']()[_0xdbf8('0x8')](_0xdbf8('0x9'),'c')[_0xdbf8('0xa')]('c.deletedAt\x20IS\x20NULL');}function applyJoinClauses(_0x31d3d7,_0x19513e){var _0x21572f=_0x19513e?'c':_0xdbf8('0xb');_0x31d3d7[_0xdbf8('0xc')](_0xdbf8('0xd'),'uc',_0xdbf8('0xe')+_0x21572f+'.id')[_0xdbf8('0xc')](_0xdbf8('0xf'),'ct',_0xdbf8('0x10')+_0x21572f+_0xdbf8('0x11'))[_0xdbf8('0xc')](_0xdbf8('0x12'),'t',_0xdbf8('0x13'));return _0x31d3d7;}function addFieldsToQuery(_0x40afa9,_0x1e2560,_0x1f6587,_0x323ea1,_0x10627b){var _0x4e6e7e=_0x10627b?'c':'subqry';if(!_0x1e2560){_0x1e2560=['id','firstName','lastName',_0xdbf8('0x14'),_0xdbf8('0x15'),'fax',_0xdbf8('0x16'),_0xdbf8('0x6'),_0xdbf8('0x17'),_0xdbf8('0x18'),_0xdbf8('0x19'),_0xdbf8('0x1a'),_0xdbf8('0x1b')];}else if(!_0x1e2560[_0xdbf8('0x1c')]('id')){_0x1e2560['push']('id');}var _0x576dcd=_0x1f6587&&_0x10627b||!_0x1f6587&&!_0x10627b;if(_0x323ea1){_0x576dcd=_0x323ea1&&_0x10627b||!_0x323ea1&&!_0x10627b;}_0x1e2560[_0xdbf8('0x1d')](function(_0x4cc898){if(_0x4cc898==='TagIds'){if(_0x576dcd){_0x40afa9[_0xdbf8('0x1e')](_0xdbf8('0x1f'),_0x4cc898);}else if(_0x1f6587||_0x323ea1){_0x40afa9[_0xdbf8('0x1e')](_0x4e6e7e+'.'+_0x4cc898);}}else{_0x40afa9[_0xdbf8('0x1e')](_0x4e6e7e+'.'+_0x4cc898);}});return _0x40afa9;}function getSqlClauses(){var _0x39555f={'default':squel[_0xdbf8('0x20')](),'fields':squel[_0xdbf8('0x20')](),'filter':squel['expr'](),'tags':{'clause':squel[_0xdbf8('0x20')](),'ids':null},'user':{'clause':squel[_0xdbf8('0x20')](),'skip':![]}};return _0x39555f;}function parseTagParameter(_0x4240bf){var _0x2dca78=squel[_0xdbf8('0x20')]();if(_0x4240bf){var _0x58c13d=utils[_0xdbf8('0x21')](_0x4240bf);_0x58c13d[_0xdbf8('0x1d')](function(_0x121105){_0x2dca78['or'](_0xdbf8('0x22'),'%,'+_0x121105+',%');});}return _0x2dca78;}function parseSearchFilter(_0x404a90){var _0x40d344=squel[_0xdbf8('0x20')]();if(_0x404a90){var _0x191ee8=_0x404a90[_0xdbf8('0x23')]('\x5c','\x5c\x5c')[_0xdbf8('0x23')](/'/g,'\x27\x27');if(_0x191ee8['split']('\x20')[_0xdbf8('0x24')]>0x1){_0x40d344['or']('MATCH\x20(c.firstName,\x20c.lastName,\x20c.phone,\x20c.mobile,\x20c.fax,\x20c.email)\x20AGAINST\x20(?\x20IN\x20BOOLEAN\x20MODE)',qs[_0xdbf8('0x25')](_0x191ee8,!![]),null);}else{if(qs[_0xdbf8('0x26')](_0x191ee8)){_0x40d344['or']('c.id\x20LIKE\x20?',_0x191ee8+'%');_0x40d344['or']('c.phone\x20LIKE\x20?',_0x191ee8+'%');_0x40d344['or']('c.mobile\x20LIKE\x20?',_0x191ee8+'%');_0x40d344['or'](_0xdbf8('0x27'),_0x191ee8+'%');}else if(qs['isEmail'](_0x191ee8)){_0x40d344['or'](_0xdbf8('0x28'),_0x191ee8+'%');}else{_0x40d344['or'](_0xdbf8('0x29'),'%'+_0x191ee8+'%');_0x40d344['or'](_0xdbf8('0x2a'),'%'+_0x191ee8+'%');_0x40d344['or']('c.email\x20LIKE\x20?','%'+_0x191ee8+'%');}}}return _0x40d344;}function parseAdvancedSearchFilter(_0x2bf80b,_0x4ed516){var _0x7b4c93=getSqlClauses();var _0x2c8a01=as[_0xdbf8('0x2b')](_0x2bf80b);var _0x109597=_0x2c8a01[_0xdbf8('0x2c')];for(var _0x582c26=0x0;_0x582c26<_0x2c8a01['conditions'][_0xdbf8('0x24')];_0x582c26++){var _0x537b56=_0x2c8a01[_0xdbf8('0x2d')][_0x582c26];var _0x3b6473='c';var _0x3d274e=_['find'](_0x4ed516,['name',_0x537b56[_0xdbf8('0x1e')]]);if(_0x3d274e){if(_0x537b56['field']===_0xdbf8('0x2e')||_0x3d274e[_0xdbf8('0x2f')]==='datetime'){_0x537b56[_0xdbf8('0x30')]=_0xdbf8('0x31');}var _0x66ebbd=as[_0xdbf8('0x32')](_0x3b6473,_0x3d274e[_0xdbf8('0x33')],_0x537b56);_0x7b4c93[_0xdbf8('0x34')][_0x109597](_0x66ebbd[_0xdbf8('0x35')],_0x66ebbd[_0xdbf8('0x36')][_0xdbf8('0x37')],_0x66ebbd[_0xdbf8('0x36')][_0xdbf8('0x38')]);}else{if(_0x537b56[_0xdbf8('0x1e')]==='Tag'){var _0xbe8f13=_0x537b56[_0xdbf8('0x36')][_0xdbf8('0x39')](',')[_0xdbf8('0x3a')](function(_0x15cbd9){return Number(_0x15cbd9);});var _0x5260b5=parseTagParameter(_0xbe8f13);_0x7b4c93[_0xdbf8('0x3b')][_0xdbf8('0x3c')][_0xdbf8('0x3d')](_0x5260b5);_0x7b4c93['tags']['ids']=_0xbe8f13;}else if(_0x537b56[_0xdbf8('0x1e')]==='User'){_0x7b4c93[_0xdbf8('0x3e')][_0xdbf8('0x3c')][_0xdbf8('0x3d')]('uc.UserId\x20=\x20?',_0x537b56[_0xdbf8('0x36')]);_0x7b4c93[_0xdbf8('0x3e')]['skip']=!![];}}}return _0x7b4c93;}function parseModelFields(_0x9a69e8,_0x2e9d20){var _0x10a5bb=squel[_0xdbf8('0x20')]();var _0x58088c=_(_0x9a69e8)[_0xdbf8('0x3f')]()[_0xdbf8('0x3a')](function(_0x3dd9d3){return _[_0xdbf8('0x40')](_0x2e9d20,[_0xdbf8('0x41'),_0x3dd9d3])?_0x3dd9d3:undefined;})[_0xdbf8('0x42')]()[_0xdbf8('0x36')]();if(_0x9a69e8[_0xdbf8('0x43')]){_0x58088c['push']('Contact');}if(_0x9a69e8[_0xdbf8('0x44')]){_0x58088c['push'](_0xdbf8('0x44'));}if(_0x58088c[_0xdbf8('0x24')]>0x0){_0x58088c[_0xdbf8('0x1d')](function(_0x39dcff){if(_0x39dcff==='ListId'){_0x10a5bb[_0xdbf8('0x3d')](_0xdbf8('0x45'),[][_0xdbf8('0x46')](_0x9a69e8[_0x39dcff]));}else if(_0x39dcff===_0xdbf8('0x43')){var _0x27f606='%'+_0x9a69e8[_0x39dcff]+'%';_0x10a5bb[_0xdbf8('0x3d')](_0xdbf8('0x47'),_0x27f606);}else if(_0x39dcff===_0xdbf8('0x44')){_0x10a5bb['and']('uc.UserId\x20=\x20?',_0x9a69e8[_0x39dcff]);}else{_0x10a5bb[_0xdbf8('0x3d')]('c.'+_0x39dcff+_0xdbf8('0x48'),_0x9a69e8[_0x39dcff]);}});}return _0x10a5bb;}function parseQueryParameters(_0x2cabc5,_0x1ee835){var _0xde608e=getSqlClauses();return Promise[_0xdbf8('0x49')]()['then'](function(){return parseModelFields(_0x2cabc5,_0x1ee835);})[_0xdbf8('0x4a')](function(_0x464c0b){_0xde608e['fields'][_0xdbf8('0x3d')](_0x464c0b);return parseTagParameter(_0x2cabc5[_0xdbf8('0x4b')]);})[_0xdbf8('0x4a')](function(_0x3ccf8b){_0xde608e[_0xdbf8('0x3b')][_0xdbf8('0x3c')][_0xdbf8('0x3d')](_0x3ccf8b);return parseSearchFilter(_0x2cabc5[_0xdbf8('0x4c')]);})['then'](function(_0x299eaa){_0xde608e[_0xdbf8('0x4c')]=_0x299eaa;return _0xde608e;});}function checkListsRestrictions(_0x218010,_0x5aef50,_0x2e1fe5){var _0x39f1cb=squel[_0xdbf8('0x20')]();return Promise[_0xdbf8('0x49')]()[_0xdbf8('0x4a')](function(){if(_0x5aef50[_0xdbf8('0x5')]&&_0x218010[_0xdbf8('0x3')]==='agent'&&!_0x2e1fe5){return _0x218010[_0xdbf8('0x4d')]({'attributes':['id'],'raw':!![]});}})[_0xdbf8('0x4a')](function(_0x2337b9){if(_0x2337b9){if(_0x2337b9[_0xdbf8('0x24')]===0x0){_0x39f1cb['and'](_0xdbf8('0x4e'));}else{_0x39f1cb[_0xdbf8('0x3d')](_0xdbf8('0x45'),_[_0xdbf8('0x3a')](_0x2337b9,'id'));}}})[_0xdbf8('0x4a')](function(){return _0x39f1cb;});}function buildContactsQuery(_0x214ff4,_0x3e8361,_0x5efd4b,_0xa1ad9c,_0x37e24f,_0x4dbf7a){if(_0x3e8361){_0x3e8361=_0x5efd4b['attributes'];}_0x214ff4=addFieldsToQuery(_0x214ff4,_0x3e8361,_0xa1ad9c,_0x4dbf7a,!![]);var _0x4279ce=squel[_0xdbf8('0x4f')]();_0x4279ce=addFieldsToQuery(_0x4279ce,_0x3e8361,_0xa1ad9c,_0x4dbf7a,![]);if(_0xa1ad9c||_0x4dbf7a){_0x214ff4=applyJoinClauses(_0x214ff4,!![]);_0x214ff4[_0xdbf8('0x50')](_0xdbf8('0x51'));if(_0x5efd4b[_0xdbf8('0x52')]){_0x4279ce[_0xdbf8('0x52')](_0x5efd4b[_0xdbf8('0x52')]);}if(_0x5efd4b[_0xdbf8('0x53')]){_0x4279ce[_0xdbf8('0x53')](_0x5efd4b[_0xdbf8('0x53')]);}}else{_0x4279ce=applyJoinClauses(_0x4279ce,![]);_0x4279ce[_0xdbf8('0x50')](_0xdbf8('0x54'));if(_0x5efd4b['limit']){_0x214ff4[_0xdbf8('0x52')](_0x5efd4b[_0xdbf8('0x52')]);}if(_0x5efd4b[_0xdbf8('0x53')]){_0x214ff4['offset'](_0x5efd4b['offset']);}}_0x4279ce[_0xdbf8('0x55')](_0x37e24f);if(_0x5efd4b['order']){_0x5efd4b[_0xdbf8('0x56')][_0xdbf8('0x1d')](function(_0x27218b){_0x214ff4[_0xdbf8('0x56')]('c.'+_0x27218b[0x0],_0x27218b[0x1]===_0xdbf8('0x57')?![]:!![]);_0x4279ce['order'](_0xdbf8('0x58')+_0x27218b[0x0],_0x27218b[0x1]===_0xdbf8('0x57')?![]:!![]);});}_0x4279ce[_0xdbf8('0x8')](_0x214ff4,_0xdbf8('0xb'));return _0x4279ce;}function getFilteredContacts(_0x41c2c1){var _0x38bb99=[];return db[_0xdbf8('0x59')][_0xdbf8('0x5a')]({'attributes':['id',_0xdbf8('0x41'),_0xdbf8('0x5b')],'raw':!![]})[_0xdbf8('0x4a')](function(_0x53e389){_0x38bb99=_['keyBy'](_0x53e389,'id');var _0x47d0fc={'type':db[_0xdbf8('0x5c')]['QueryTypes']['SELECT'],'model':db[_0xdbf8('0x5d')],'mapToModel':!![],'nest':!![],'raw':!![]};return db[_0xdbf8('0x5e')][_0xdbf8('0x5f')](_0x41c2c1['toString'](),_0x47d0fc);})['then'](function(_0x2b7a63){_0x2b7a63[_0xdbf8('0x1d')](function(_0x25931d){if(_0x25931d[_0xdbf8('0x1b')]){_0x25931d[_0xdbf8('0x60')]=[];_0x25931d[_0xdbf8('0x1b')]['split'](',')[_0xdbf8('0x1d')](function(_0x4da3d0){_0x25931d[_0xdbf8('0x60')][_0xdbf8('0x61')](_0x38bb99[_0x4da3d0]);});}delete _0x25931d[_0xdbf8('0x1b')];});return _0x2b7a63;});}function countFilteredContacts(_0x3c40fe,_0x1e2b53){var _0x1b9d6e=_0x3c40fe[_0xdbf8('0x62')]();_0x1b9d6e[_0xdbf8('0x1e')](_0xdbf8('0x63'));_0x1b9d6e=applyJoinClauses(_0x1b9d6e,!![]);_0x3c40fe['group'](_0xdbf8('0x51'));var _0x2f0d79=utils[_0xdbf8('0x21')](_0x1e2b53);if(!_[_0xdbf8('0x64')](_0x2f0d79)){_0x1b9d6e[_0xdbf8('0xa')]('t.id\x20IN\x20?',_0x2f0d79);}var _0x5b6201={'type':db[_0xdbf8('0x5c')][_0xdbf8('0x65')][_0xdbf8('0x66')],'raw':!![]};return db[_0xdbf8('0x5e')][_0xdbf8('0x5f')](_0x1b9d6e[_0xdbf8('0x67')](),_0x5b6201)[_0xdbf8('0x4a')](function(_0x3d55ae){return _0x3d55ae[0x0][_0xdbf8('0x63')];});}module[_0xdbf8('0x68')]={'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