Built motion from commit 13c3002c.|2.6.9
[motion2.git] / server / api / cmHopperHistory / cmHopperHistory.rpc.js
index 847167e..2fb7786 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x30fe=['findAll','col','`state`\x20=\x204,\x201,\x20null','ivrAnswerCallsDay','util','bluebird','ioredis','../../mysqldb','../../config/utils','../../config/logger','rpc','jayson/promise','client','http','request','then','info','CmHopperHistory,\x20%s,\x20%s','debug','CmHopperHistory,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','result','CreateCmHopperHistory','create','options','raw','catch','AvgHandleTime','where','sequelize','COUNT','predictiveIntervalTotalCalls','literal','`state`\x20=\x2010,\x201,\x20null','`state`\x20=\x2011,\x201,\x20null','AVG','predictiveIntervalAvgHoldtime','`state`\x20=\x204,\x20`talktime`,\x20null','predictiveIntervalAvgTalktime','GetVoiceQueueHopperHistory','CmHopperHistory','name','`state`\x20=\x200,\x201,\x20null','outboundNoAnswerCallsDay','outboundAnswerCallsDay','`state`\x20=\x205,\x201,\x20null','outboundBusyCallsDay','`state`\x20=\x2010\x20,\x201,\x20null','outboundDropCallsDayTimeout','`state`\x20=\x2011\x20,\x201,\x20null','outboundDropCallsDayCallersExit','`state`\x20=\x2012,\x201,\x20null','`state`\x20=\x2013,\x201,\x20null','`state`\x20=\x2014,\x201,\x20null','`state`\x20=\x2018,\x201,\x20null','`state`\x20=\x2020,\x201,\x20null','outboundRejectCallsDay','`state`\x20=\x2022\x20or\x20`state`\x20=\x2023,\x201,\x20null','outboundReCallsDay','campaign','GetCampaignHopperHistory'];(function(_0x2892da,_0x191a40){var _0x28cff2=function(_0x57023d){while(--_0x57023d){_0x2892da['push'](_0x2892da['shift']());}};_0x28cff2(++_0x191a40);}(_0x30fe,0x149));var _0xe30f=function(_0xb509c2,_0xc778dd){_0xb509c2=_0xb509c2-0x0;var _0x1a63e1=_0x30fe[_0xb509c2];return _0x1a63e1;};'use strict';var _=require('lodash');var util=require(_0xe30f('0x0'));var moment=require('moment');var BPromise=require(_0xe30f('0x1'));var rs=require('randomstring');var fs=require('fs');var Redis=require(_0xe30f('0x2'));var db=require(_0xe30f('0x3'))['db'];var utils=require(_0xe30f('0x4'));var logger=require(_0xe30f('0x5'))(_0xe30f('0x6'));var config=require('../../config/environment');var jayson=require(_0xe30f('0x7'));var client=jayson[_0xe30f('0x8')][_0xe30f('0x9')]({'port':0x232a});function respondWithRpcPromise(_0x346a51,_0x442a51,_0x3af889){return new BPromise(function(_0x2f94d2,_0x2243f2){return client[_0xe30f('0xa')](_0x346a51,_0x3af889)[_0xe30f('0xb')](function(_0x5ab6b8){logger[_0xe30f('0xc')](_0xe30f('0xd'),_0x442a51,'request\x20sent');logger[_0xe30f('0xe')](_0xe30f('0xf'),_0x442a51,_0xe30f('0x10'),JSON[_0xe30f('0x11')](_0x5ab6b8));if(_0x5ab6b8['error']){if(_0x5ab6b8[_0xe30f('0x12')][_0xe30f('0x13')]===0x1f4){logger[_0xe30f('0x12')]('CmHopperHistory,\x20%s,\x20%s',_0x442a51,_0x5ab6b8[_0xe30f('0x12')][_0xe30f('0x14')]);return _0x2243f2(_0x5ab6b8[_0xe30f('0x12')]['message']);}logger[_0xe30f('0x12')](_0xe30f('0xd'),_0x442a51,_0x5ab6b8[_0xe30f('0x12')][_0xe30f('0x14')]);return _0x2f94d2(_0x5ab6b8['error']['message']);}else{logger['info'](_0xe30f('0xd'),_0x442a51,_0xe30f('0x10'));_0x2f94d2(_0x5ab6b8[_0xe30f('0x15')][_0xe30f('0x14')]);}})['catch'](function(_0x1f19bf){logger['error'](_0xe30f('0xd'),_0x442a51,_0x1f19bf);_0x2243f2(_0x1f19bf);});});}exports[_0xe30f('0x16')]=function(_0x406c98){var _0x20c2a5=this;return new Promise(function(_0x17024a,_0x5ae935){return db['CmHopperHistory'][_0xe30f('0x17')](_0x406c98['body'],{'raw':_0x406c98[_0xe30f('0x18')]?_0x406c98['options'][_0xe30f('0x19')]===undefined?!![]:![]:!![]})[_0xe30f('0xb')](function(_0x2c4d1f){logger[_0xe30f('0xc')](_0xe30f('0x16'),_0x406c98);logger['debug'](_0xe30f('0x16'),_0x406c98,JSON['stringify'](_0x2c4d1f));_0x17024a(_0x2c4d1f);})[_0xe30f('0x1a')](function(_0x5af7b5){logger[_0xe30f('0x12')](_0xe30f('0x16'),_0x5af7b5[_0xe30f('0x14')],_0x406c98);_0x5ae935(_0x20c2a5[_0xe30f('0x12')](0x1f4,_0x5af7b5[_0xe30f('0x14')]));});});};exports[_0xe30f('0x1b')]=function(_0x50bca4){var _0x2f0eef=this;return new Promise(function(_0x5e517b,_0xa9a4b5){return db['CmHopperHistory']['findAll']({'raw':_0x50bca4['options']?_0x50bca4[_0xe30f('0x18')]['raw']===undefined?!![]:![]:!![],'where':_0x50bca4[_0xe30f('0x18')]?_0x50bca4[_0xe30f('0x18')][_0xe30f('0x1c')]||null:null,'attributes':[[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['col']('id')),_0xe30f('0x1f')],[db[_0xe30f('0x1d')]['fn']('COUNT',db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')]['literal']('`state`\x20=\x204,\x201,\x20null'))),'predictiveIntervalAnsweredCalls'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x21')))),'predictiveIntervalDroppedCallsTimeout'],[db[_0xe30f('0x1d')]['fn']('COUNT',db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x22')))),'predictiveIntervalDroppedCallsCallersExit'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x23'),db[_0xe30f('0x1d')]['fn']('IF',db['sequelize'][_0xe30f('0x20')]('`state`\x20=\x204,\x20`holdtime`,\x20null'))),_0xe30f('0x24')],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x23'),db[_0xe30f('0x1d')]['fn']('IF',db['sequelize'][_0xe30f('0x20')](_0xe30f('0x25')))),_0xe30f('0x26')]]})[_0xe30f('0xb')](function(_0x33331b){logger[_0xe30f('0xc')](_0xe30f('0x1b'),_0x50bca4);logger['debug'](_0xe30f('0x1b'),_0x50bca4,JSON[_0xe30f('0x11')](_0x33331b));_0x5e517b(_0x33331b);})[_0xe30f('0x1a')](function(_0x489abb){logger[_0xe30f('0x12')](_0xe30f('0x1b'),_0x489abb['message'],_0x50bca4);_0xa9a4b5(_0x2f0eef[_0xe30f('0x12')](0x1f4,_0x489abb['message']));});});};exports[_0xe30f('0x27')]=function(_0x4efad3){var _0x47aac8=this;return new Promise(function(_0x5afd8b,_0xf09327){return db[_0xe30f('0x28')]['findAll']({'raw':_0x4efad3[_0xe30f('0x18')]?_0x4efad3['options'][_0xe30f('0x19')]===undefined?!![]:![]:!![],'where':_0x4efad3[_0xe30f('0x18')]?_0x4efad3[_0xe30f('0x18')][_0xe30f('0x1c')]||null:null,'attributes':[['campaign',_0xe30f('0x29')],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')]['literal'](_0xe30f('0x2a')))),'outboundNoSuchCallsDay'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')]['literal']('`state`\x20=\x203,\x201,\x20null'))),_0xe30f('0x2b')],[db['sequelize']['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')]('`state`\x20=\x204,\x201,\x20null'))),_0xe30f('0x2c')],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x2d')))),_0xe30f('0x2e')],[db['sequelize']['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')]('`state`\x20=\x208,\x201,\x20null'))),'outboundCongestionCallsDay'],[db[_0xe30f('0x1d')]['fn']('COUNT',db[_0xe30f('0x1d')]['fn']('IF',db['sequelize'][_0xe30f('0x20')](_0xe30f('0x2f')))),_0xe30f('0x30')],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')]['literal'](_0xe30f('0x31')))),_0xe30f('0x32')],[db[_0xe30f('0x1d')]['fn']('COUNT',db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x33')))),'outboundUnknownCallsDay'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x34')))),'outboundBlacklistCallsDay'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')]['literal'](_0xe30f('0x35')))),'outboundOriginateFailureCallsDay'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db['sequelize']['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x36')))),'outboundRejectCallsDay'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')]('`state`\x20=\x2016,\x201,\x20null'))),'outboundAnswerAgiCallsDay'],[db['sequelize']['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x37')))),_0xe30f('0x38')],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db[_0xe30f('0x1d')][_0xe30f('0x20')](_0xe30f('0x39')))),_0xe30f('0x3a')]],'group':[_0xe30f('0x3b')]})[_0xe30f('0xb')](function(_0x2c720d){logger['info'](_0xe30f('0x27'),_0x4efad3);logger['debug'](_0xe30f('0x27'),_0x4efad3,JSON[_0xe30f('0x11')](_0x2c720d));_0x5afd8b(_0x2c720d);})['catch'](function(_0x285507){logger['error'](_0xe30f('0x27'),_0x285507['message'],_0x4efad3);_0xf09327(_0x47aac8[_0xe30f('0x12')](0x1f4,_0x285507[_0xe30f('0x14')]));});});};exports[_0xe30f('0x3c')]=function(_0x5cfe95){var _0x321e8f=this;return new Promise(function(_0x516f6a,_0x2edfb6){return db[_0xe30f('0x28')][_0xe30f('0x3d')]({'raw':_0x5cfe95[_0xe30f('0x18')]?_0x5cfe95[_0xe30f('0x18')]['raw']===undefined?!![]:![]:!![],'where':_0x5cfe95[_0xe30f('0x18')]?_0x5cfe95[_0xe30f('0x18')][_0xe30f('0x1c')]||null:null,'attributes':[['campaign',_0xe30f('0x29')],[db[_0xe30f('0x1d')]['fn']('COUNT',db[_0xe30f('0x1d')][_0xe30f('0x3e')]('id')),'ivrTotalCallsDays'],[db[_0xe30f('0x1d')]['fn'](_0xe30f('0x1e'),db[_0xe30f('0x1d')]['fn']('IF',db['sequelize']['literal'](_0xe30f('0x3f')))),_0xe30f('0x40')]],'group':['campaign']})['then'](function(_0x514564){logger['info'](_0xe30f('0x3c'),_0x5cfe95);logger[_0xe30f('0xe')](_0xe30f('0x3c'),_0x5cfe95,JSON[_0xe30f('0x11')](_0x514564));_0x516f6a(_0x514564);})[_0xe30f('0x1a')](function(_0x2f60c9){logger[_0xe30f('0x12')](_0xe30f('0x3c'),_0x2f60c9[_0xe30f('0x14')],_0x5cfe95);_0x2edfb6(_0x321e8f[_0xe30f('0x12')](0x1f4,_0x2f60c9[_0xe30f('0x14')]));});});};
\ No newline at end of file
+var _0xd110=['CmHopperHistory,\x20%s,\x20%s,\x20%s','stringify','error','code','message','CmHopperHistory,\x20%s,\x20%s','CreateCmHopperHistory','create','body','options','raw','debug','AvgHandleTime','CmHopperHistory','where','COUNT','col','sequelize','literal','`state`\x20=\x204,\x201,\x20null','predictiveIntervalAnsweredCalls','predictiveIntervalDroppedCallsTimeout','`state`\x20=\x2011,\x201,\x20null','predictiveIntervalDroppedCallsCallersExit','AVG','`state`\x20=\x204,\x20`holdtime`,\x20null','`state`\x20=\x204,\x20`talktime`,\x20null','predictiveIntervalAvgTalktime','catch','GetVoiceQueueHopperHistory','findAll','campaign','name','`state`\x20=\x200,\x201,\x20null','outboundNoSuchCallsDay','outboundNoAnswerCallsDay','outboundAnswerCallsDay','`state`\x20=\x205,\x201,\x20null','outboundBusyCallsDay','`state`\x20=\x208,\x201,\x20null','outboundCongestionCallsDay','`state`\x20=\x2010\x20,\x201,\x20null','outboundDropCallsDayTimeout','`state`\x20=\x2012,\x201,\x20null','`state`\x20=\x2013,\x201,\x20null','outboundOriginateFailureCallsDay','`state`\x20=\x2018,\x201,\x20null','outboundRejectCallsDay','`state`\x20=\x2016,\x201,\x20null','outboundAnswerAgiCallsDay','`state`\x20=\x2020,\x201,\x20null','`state`\x20=\x2022\x20or\x20`state`\x20=\x2023,\x201,\x20null','outboundReCallsDay','GetCampaignHopperHistory','ivrTotalCallsDays','ivrAnswerCallsDay','lodash','util','moment','randomstring','ioredis','../../mysqldb','../../config/utils','../../config/logger','rpc','../../config/environment','jayson/promise','http','request','then','info','request\x20sent'];(function(_0x3bb831,_0x2cdb3c){var _0x512bd0=function(_0x218766){while(--_0x218766){_0x3bb831['push'](_0x3bb831['shift']());}};_0x512bd0(++_0x2cdb3c);}(_0xd110,0x1e8));var _0x0d11=function(_0x2c0e49,_0x3aa066){_0x2c0e49=_0x2c0e49-0x0;var _0x295adc=_0xd110[_0x2c0e49];return _0x295adc;};'use strict';var _=require(_0x0d11('0x0'));var util=require(_0x0d11('0x1'));var moment=require(_0x0d11('0x2'));var BPromise=require('bluebird');var rs=require(_0x0d11('0x3'));var fs=require('fs');var Redis=require(_0x0d11('0x4'));var db=require(_0x0d11('0x5'))['db'];var utils=require(_0x0d11('0x6'));var logger=require(_0x0d11('0x7'))(_0x0d11('0x8'));var config=require(_0x0d11('0x9'));var jayson=require(_0x0d11('0xa'));var client=jayson['client'][_0x0d11('0xb')]({'port':0x232a});function respondWithRpcPromise(_0x5a889c,_0x33c46e,_0x4f3f3f){return new BPromise(function(_0x47a493,_0x3f9f5a){return client[_0x0d11('0xc')](_0x5a889c,_0x4f3f3f)[_0x0d11('0xd')](function(_0x4c6a59){logger[_0x0d11('0xe')]('CmHopperHistory,\x20%s,\x20%s',_0x33c46e,_0x0d11('0xf'));logger['debug'](_0x0d11('0x10'),_0x33c46e,_0x0d11('0xf'),JSON[_0x0d11('0x11')](_0x4c6a59));if(_0x4c6a59[_0x0d11('0x12')]){if(_0x4c6a59['error'][_0x0d11('0x13')]===0x1f4){logger[_0x0d11('0x12')]('CmHopperHistory,\x20%s,\x20%s',_0x33c46e,_0x4c6a59[_0x0d11('0x12')][_0x0d11('0x14')]);return _0x3f9f5a(_0x4c6a59[_0x0d11('0x12')]['message']);}logger[_0x0d11('0x12')](_0x0d11('0x15'),_0x33c46e,_0x4c6a59['error'][_0x0d11('0x14')]);return _0x47a493(_0x4c6a59[_0x0d11('0x12')][_0x0d11('0x14')]);}else{logger[_0x0d11('0xe')](_0x0d11('0x15'),_0x33c46e,'request\x20sent');_0x47a493(_0x4c6a59['result'][_0x0d11('0x14')]);}})['catch'](function(_0x46aa4f){logger[_0x0d11('0x12')]('CmHopperHistory,\x20%s,\x20%s',_0x33c46e,_0x46aa4f);_0x3f9f5a(_0x46aa4f);});});}exports[_0x0d11('0x16')]=function(_0x57df83){var _0x2e4c05=this;return new Promise(function(_0x2a29db,_0x5e3bd3){return db['CmHopperHistory'][_0x0d11('0x17')](_0x57df83[_0x0d11('0x18')],{'raw':_0x57df83[_0x0d11('0x19')]?_0x57df83[_0x0d11('0x19')][_0x0d11('0x1a')]===undefined?!![]:![]:!![]})[_0x0d11('0xd')](function(_0x575ea3){logger[_0x0d11('0xe')](_0x0d11('0x16'),_0x57df83);logger[_0x0d11('0x1b')](_0x0d11('0x16'),_0x57df83,JSON[_0x0d11('0x11')](_0x575ea3));_0x2a29db(_0x575ea3);})['catch'](function(_0x38955b){logger['error'](_0x0d11('0x16'),_0x38955b[_0x0d11('0x14')],_0x57df83);_0x5e3bd3(_0x2e4c05[_0x0d11('0x12')](0x1f4,_0x38955b['message']));});});};exports[_0x0d11('0x1c')]=function(_0xc4c278){var _0x4a6839=this;return new Promise(function(_0x34edec,_0x483ae7){return db[_0x0d11('0x1d')]['findAll']({'raw':_0xc4c278['options']?_0xc4c278[_0x0d11('0x19')][_0x0d11('0x1a')]===undefined?!![]:![]:!![],'where':_0xc4c278[_0x0d11('0x19')]?_0xc4c278[_0x0d11('0x19')][_0x0d11('0x1e')]||null:null,'attributes':[[db['sequelize']['fn'](_0x0d11('0x1f'),db['sequelize'][_0x0d11('0x20')]('id')),'predictiveIntervalTotalCalls'],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x23')))),_0x0d11('0x24')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')]('`state`\x20=\x2010,\x201,\x20null'))),_0x0d11('0x25')],[db[_0x0d11('0x21')]['fn']('COUNT',db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x26')))),_0x0d11('0x27')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x28'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x29')))),'predictiveIntervalAvgHoldtime'],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x28'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x2a')))),_0x0d11('0x2b')]]})[_0x0d11('0xd')](function(_0x1c340f){logger[_0x0d11('0xe')](_0x0d11('0x1c'),_0xc4c278);logger['debug']('AvgHandleTime',_0xc4c278,JSON[_0x0d11('0x11')](_0x1c340f));_0x34edec(_0x1c340f);})[_0x0d11('0x2c')](function(_0x219e80){logger[_0x0d11('0x12')]('AvgHandleTime',_0x219e80[_0x0d11('0x14')],_0xc4c278);_0x483ae7(_0x4a6839[_0x0d11('0x12')](0x1f4,_0x219e80['message']));});});};exports[_0x0d11('0x2d')]=function(_0x15e36a){var _0x2222be=this;return new Promise(function(_0x848c8e,_0x2bd01f){return db[_0x0d11('0x1d')][_0x0d11('0x2e')]({'raw':_0x15e36a[_0x0d11('0x19')]?_0x15e36a[_0x0d11('0x19')][_0x0d11('0x1a')]===undefined?!![]:![]:!![],'where':_0x15e36a[_0x0d11('0x19')]?_0x15e36a[_0x0d11('0x19')][_0x0d11('0x1e')]||null:null,'attributes':[[_0x0d11('0x2f'),_0x0d11('0x30')],[db['sequelize']['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x31')))),_0x0d11('0x32')],[db['sequelize']['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')]('`state`\x20=\x203,\x201,\x20null'))),_0x0d11('0x33')],[db['sequelize']['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')]('`state`\x20=\x204,\x201,\x20null'))),_0x0d11('0x34')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x35')))),_0x0d11('0x36')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x37')))),_0x0d11('0x38')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x39')))),_0x0d11('0x3a')],[db['sequelize']['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db['sequelize'][_0x0d11('0x22')]('`state`\x20=\x2011\x20,\x201,\x20null'))),'outboundDropCallsDayCallersExit'],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')]['literal'](_0x0d11('0x3b')))),'outboundUnknownCallsDay'],[db['sequelize']['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x3c')))),'outboundBlacklistCallsDay'],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db['sequelize']['literal']('`state`\x20=\x2014,\x201,\x20null'))),_0x0d11('0x3d')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db['sequelize'][_0x0d11('0x22')](_0x0d11('0x3e')))),_0x0d11('0x3f')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db['sequelize']['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x40')))),_0x0d11('0x41')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x42')))),_0x0d11('0x3f')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x43')))),_0x0d11('0x44')]],'group':[_0x0d11('0x2f')]})[_0x0d11('0xd')](function(_0x5b28ce){logger[_0x0d11('0xe')]('GetVoiceQueueHopperHistory',_0x15e36a);logger[_0x0d11('0x1b')]('GetVoiceQueueHopperHistory',_0x15e36a,JSON['stringify'](_0x5b28ce));_0x848c8e(_0x5b28ce);})[_0x0d11('0x2c')](function(_0xf3f79d){logger[_0x0d11('0x12')](_0x0d11('0x2d'),_0xf3f79d[_0x0d11('0x14')],_0x15e36a);_0x2bd01f(_0x2222be[_0x0d11('0x12')](0x1f4,_0xf3f79d[_0x0d11('0x14')]));});});};exports[_0x0d11('0x45')]=function(_0x5d3958){var _0x491bc3=this;return new Promise(function(_0x5628d9,_0x16c2a8){return db[_0x0d11('0x1d')][_0x0d11('0x2e')]({'raw':_0x5d3958[_0x0d11('0x19')]?_0x5d3958[_0x0d11('0x19')][_0x0d11('0x1a')]===undefined?!![]:![]:!![],'where':_0x5d3958[_0x0d11('0x19')]?_0x5d3958['options'][_0x0d11('0x1e')]||null:null,'attributes':[[_0x0d11('0x2f'),_0x0d11('0x30')],[db['sequelize']['fn']('COUNT',db[_0x0d11('0x21')]['col']('id')),_0x0d11('0x46')],[db[_0x0d11('0x21')]['fn'](_0x0d11('0x1f'),db[_0x0d11('0x21')]['fn']('IF',db[_0x0d11('0x21')][_0x0d11('0x22')](_0x0d11('0x23')))),_0x0d11('0x47')]],'group':[_0x0d11('0x2f')]})[_0x0d11('0xd')](function(_0x431224){logger[_0x0d11('0xe')](_0x0d11('0x45'),_0x5d3958);logger[_0x0d11('0x1b')](_0x0d11('0x45'),_0x5d3958,JSON[_0x0d11('0x11')](_0x431224));_0x5628d9(_0x431224);})[_0x0d11('0x2c')](function(_0x3a1175){logger[_0x0d11('0x12')](_0x0d11('0x45'),_0x3a1175[_0x0d11('0x14')],_0x5d3958);_0x16c2a8(_0x491bc3[_0x0d11('0x12')](0x1f4,_0x3a1175[_0x0d11('0x14')]));});});};
\ No newline at end of file