Built motion from commit (unavailable).|2.5.4
[motion2.git] / server / api / intZohoConfiguration / intZohoConfiguration.controller.js
1 // *************************************************************************
2 // *                                                                       *
3 // * xCALLY Motion -  The Omnichannel Contact Center                       *
4 // * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
5 // *                                                                       *
6 // *************************************************************************
7 // *                                                                       *
8 // * Email: info@xcally.com                                                *
9 // * Website: https://www.xcally.com                                       *
10 // *                                                                       *
11 // *************************************************************************
12 // *                                                                       *
13 // * The SOFTWARE PRODUCT is protected by copyright laws and international *
14 // * copyright treaties, as well as other intellectual property laws and   *
15 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
16 // *                                                                       *
17 // *************************************************************************
18 var _0xd60f=['../../config/utils','../../mysqldb','http','test','ValidationError','The\x20password\x20must\x20be\x20at\x20least\x208\x20characters\x20long\x20and\x20have\x201\x20lowercase\x20character,\x201\x20uppercase\x20character,\x201\x20number\x20and\x201\x20special\x20character\x20~!@#$%^&-_=+[{]}.','request','then','info','ZohoConfiguration,\x20%s,\x20%s','request\x20sent','debug','stringify','error','code','message','catch','sendStatus','status','end','json','count','offset','limit','set','Content-Range','reject','save','update','destroy','stack','map','rawAttributes','fieldName','type','key','model','name','keys','filters','intersection','query','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filter','where','merge','VIRTUAL','ZohoConfiguration','includeAll','include','show','params','options','find','create','body','getFields','findOne','ZohoField','getSubjects','getDescriptions','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','bluebird','util','path','sox','ejs','lodash','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','api'];(function(_0x1762b4,_0x33d836){var _0x29beda=function(_0x31c2fa){while(--_0x31c2fa){_0x1762b4['push'](_0x1762b4['shift']());}};_0x29beda(++_0x33d836);}(_0xd60f,0xf8));var _0xfd60=function(_0x29907a,_0x260772){_0x29907a=_0x29907a-0x0;var _0x21f2c7=_0xd60f[_0x29907a];return _0x21f2c7;};'use strict';var pdf=require(_0xfd60('0x0'));var emlformat=require(_0xfd60('0x1'));var rimraf=require(_0xfd60('0x2'));var zipdir=require(_0xfd60('0x3'));var jsonpatch=require(_0xfd60('0x4'));var rp=require(_0xfd60('0x5'));var moment=require('moment');var BPromise=require(_0xfd60('0x6'));var Mustache=require('mustache');var util=require(_0xfd60('0x7'));var path=require(_0xfd60('0x8'));var sox=require(_0xfd60('0x9'));var csv=require('to-csv');var ejs=require(_0xfd60('0xa'));var fs=require('fs');var _=require(_0xfd60('0xb'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xfd60('0xc'));var deskjs=require(_0xfd60('0xd'));var toCsv=require(_0xfd60('0xe'));var querystring=require(_0xfd60('0xf'));var Papa=require(_0xfd60('0x10'));var Redis=require(_0xfd60('0x11'));var authService=require(_0xfd60('0x12'));var qs=require(_0xfd60('0x13'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xfd60('0x14'));var logger=require('../../config/logger')(_0xfd60('0x15'));var utils=require(_0xfd60('0x16'));var config=require('../../config/environment');var db=require(_0xfd60('0x17'))['db'];var jayson=require('jayson/promise');var client=jayson['client'][_0xfd60('0x18')]({'port':0x232a});function checkPasswordPattern(_0x16e027,_0x358265,_0x5533ae){if(_0x5533ae){var _0x491b33=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x491b33[_0xfd60('0x19')](_0x358265)){return _0x16e027;}else{throw new db['Sequelize'][(_0xfd60('0x1a'))](_0xfd60('0x1b'));}}else{return _0x16e027;}}function respondWithRpcPromise(_0x456b63,_0x1748c9,_0x250105,_0x2491a4){return new BPromise(function(_0x3c6a12,_0x4db93f){var _0x5cf38d=_0x2491a4||client;return _0x5cf38d[_0xfd60('0x1c')](_0x456b63,_0x250105)[_0xfd60('0x1d')](function(_0x3c5aa0){logger[_0xfd60('0x1e')](_0xfd60('0x1f'),_0x1748c9,_0xfd60('0x20'));logger[_0xfd60('0x21')]('ZohoConfiguration,\x20%s,\x20%s,\x20%s',_0x1748c9,_0xfd60('0x20'),JSON[_0xfd60('0x22')](_0x3c5aa0));if(_0x3c5aa0[_0xfd60('0x23')]){if(_0x3c5aa0['error'][_0xfd60('0x24')]===0x1f4){logger['error']('ZohoConfiguration,\x20%s,\x20%s',_0x1748c9,_0x3c5aa0[_0xfd60('0x23')][_0xfd60('0x25')]);return _0x4db93f(_0x3c5aa0['error'][_0xfd60('0x25')]);}logger['error'](_0xfd60('0x1f'),_0x1748c9,_0x3c5aa0[_0xfd60('0x23')][_0xfd60('0x25')]);return _0x3c6a12(_0x3c5aa0[_0xfd60('0x23')][_0xfd60('0x25')]);}else{logger[_0xfd60('0x1e')](_0xfd60('0x1f'),_0x1748c9,_0xfd60('0x20'));_0x3c6a12(_0x3c5aa0['result']['message']);}})[_0xfd60('0x26')](function(_0x3378c8){logger[_0xfd60('0x23')](_0xfd60('0x1f'),_0x1748c9,_0x3378c8);_0x4db93f(_0x3378c8);});});}function respondWithStatusCode(_0xe65bb6,_0x575638){_0x575638=_0x575638||0xcc;return function(_0x39c651){if(_0x39c651){return _0xe65bb6[_0xfd60('0x27')](_0x575638);}return _0xe65bb6[_0xfd60('0x28')](_0x575638)[_0xfd60('0x29')]();};}function respondWithResult(_0xa41f5,_0x578ce9){_0x578ce9=_0x578ce9||0xc8;return function(_0x149d85){if(_0x149d85){return _0xa41f5[_0xfd60('0x28')](_0x578ce9)[_0xfd60('0x2a')](_0x149d85);}};}function respondWithFilteredResult(_0x5ba061,_0x46df06){return function(_0x197729){if(_0x197729){var _0x54b58e=_0x197729[_0xfd60('0x2b')],_0x5a4239=_0x46df06['offset'],_0x1887f8=_0x46df06[_0xfd60('0x2c')]+_0x46df06[_0xfd60('0x2d')],_0x2ddbd7;if(_0x1887f8>=_0x54b58e){_0x1887f8=_0x54b58e;_0x2ddbd7=0xc8;}else{_0x2ddbd7=0xce;}_0x5ba061['status'](_0x2ddbd7);return _0x5ba061[_0xfd60('0x2e')](_0xfd60('0x2f'),_0x5a4239+'-'+_0x1887f8+'/'+_0x54b58e)[_0xfd60('0x2a')](_0x197729);}return null;};}function patchUpdates(_0x1c5910){return function(_0x3875df){try{jsonpatch['apply'](_0x3875df,_0x1c5910,!![]);}catch(_0x27c1f3){return BPromise[_0xfd60('0x30')](_0x27c1f3);}return _0x3875df[_0xfd60('0x31')]();};}function saveUpdates(_0x3d583d,_0x2bffdb){return function(_0x3113fa){if(_0x3113fa){return _0x3113fa[_0xfd60('0x32')](_0x3d583d)[_0xfd60('0x1d')](function(_0xb3d2d4){return _0xb3d2d4;});}return null;};}function removeEntity(_0x36816b,_0x12d94d){return function(_0x481e8a){if(_0x481e8a){return _0x481e8a[_0xfd60('0x33')]()[_0xfd60('0x1d')](function(){_0x36816b[_0xfd60('0x28')](0xcc)[_0xfd60('0x29')]();});}};}function handleEntityNotFound(_0x51f591,_0x51a370){return function(_0x200b3f){if(!_0x200b3f){_0x51f591[_0xfd60('0x27')](0x194);}return _0x200b3f;};}function handleError(_0x3d5195,_0x387cf1){_0x387cf1=_0x387cf1||0x1f4;return function(_0x96437a){logger[_0xfd60('0x23')](_0x96437a[_0xfd60('0x34')]);if(_0x96437a['name']){delete _0x96437a['name'];}_0x3d5195['status'](_0x387cf1)['send'](_0x96437a);};}exports['index']=function(_0x366531,_0x1cfca6){var _0x378c15={},_0x2956a7={},_0x1334b6={'count':0x0,'rows':[]};var _0x1dbebb=_[_0xfd60('0x35')](db['ZohoConfiguration'][_0xfd60('0x36')],function(_0x4537aa){return{'name':_0x4537aa[_0xfd60('0x37')],'type':_0x4537aa[_0xfd60('0x38')][_0xfd60('0x39')]};});_0x2956a7[_0xfd60('0x3a')]=_['map'](_0x1dbebb,_0xfd60('0x3b'));_0x2956a7['query']=_[_0xfd60('0x3c')](_0x366531['query']);_0x2956a7[_0xfd60('0x3d')]=_[_0xfd60('0x3e')](_0x2956a7[_0xfd60('0x3a')],_0x2956a7[_0xfd60('0x3f')]);_0x378c15['attributes']=_[_0xfd60('0x3e')](_0x2956a7[_0xfd60('0x3a')],qs[_0xfd60('0x40')](_0x366531[_0xfd60('0x3f')]['fields']));_0x378c15['attributes']=_0x378c15[_0xfd60('0x41')][_0xfd60('0x42')]?_0x378c15[_0xfd60('0x41')]:_0x2956a7[_0xfd60('0x3a')];if(!_0x366531[_0xfd60('0x3f')][_0xfd60('0x43')](_0xfd60('0x44'))){_0x378c15[_0xfd60('0x2d')]=qs[_0xfd60('0x2d')](_0x366531[_0xfd60('0x3f')]['limit']);_0x378c15['offset']=qs[_0xfd60('0x2c')](_0x366531[_0xfd60('0x3f')][_0xfd60('0x2c')]);}_0x378c15[_0xfd60('0x45')]=qs[_0xfd60('0x46')](_0x366531[_0xfd60('0x3f')][_0xfd60('0x46')]);_0x378c15['where']=qs[_0xfd60('0x3d')](_[_0xfd60('0x47')](_0x366531['query'],_0x2956a7[_0xfd60('0x3d')]),_0x1dbebb);if(_0x366531['query'][_0xfd60('0x48')]){_0x378c15[_0xfd60('0x49')]=_[_0xfd60('0x4a')](_0x378c15[_0xfd60('0x49')],{'$or':_[_0xfd60('0x35')](_0x1dbebb,function(_0x2cf0e8){if(_0x2cf0e8[_0xfd60('0x38')]!==_0xfd60('0x4b')){var _0x171813={};_0x171813[_0x2cf0e8[_0xfd60('0x3b')]]={'$like':'%'+_0x366531[_0xfd60('0x3f')][_0xfd60('0x48')]+'%'};return _0x171813;}})});}_0x378c15=_[_0xfd60('0x4a')]({},_0x378c15,_0x366531['options']);var _0x47fd52={'where':_0x378c15['where']};return db[_0xfd60('0x4c')][_0xfd60('0x2b')](_0x47fd52)[_0xfd60('0x1d')](function(_0x55e020){_0x1334b6[_0xfd60('0x2b')]=_0x55e020;if(_0x366531['query'][_0xfd60('0x4d')]){_0x378c15[_0xfd60('0x4e')]=[{'all':!![]}];}return db[_0xfd60('0x4c')]['findAll'](_0x378c15);})[_0xfd60('0x1d')](function(_0x115fca){_0x1334b6['rows']=_0x115fca;return _0x1334b6;})['then'](respondWithFilteredResult(_0x1cfca6,_0x378c15))[_0xfd60('0x26')](handleError(_0x1cfca6,null));};exports[_0xfd60('0x4f')]=function(_0x31e4b3,_0x5b7752){var _0x3cb03e={'raw':![],'where':{'id':_0x31e4b3[_0xfd60('0x50')]['id']}},_0x18fd32={};_0x18fd32[_0xfd60('0x3a')]=_[_0xfd60('0x3c')](db[_0xfd60('0x4c')][_0xfd60('0x36')]);_0x18fd32['query']=_[_0xfd60('0x3c')](_0x31e4b3['query']);_0x18fd32[_0xfd60('0x3d')]=_['intersection'](_0x18fd32[_0xfd60('0x3a')],_0x18fd32['query']);_0x3cb03e[_0xfd60('0x41')]=_[_0xfd60('0x3e')](_0x18fd32['model'],qs[_0xfd60('0x40')](_0x31e4b3[_0xfd60('0x3f')]['fields']));_0x3cb03e[_0xfd60('0x41')]=_0x3cb03e[_0xfd60('0x41')][_0xfd60('0x42')]?_0x3cb03e[_0xfd60('0x41')]:_0x18fd32[_0xfd60('0x3a')];if(_0x31e4b3[_0xfd60('0x3f')]['includeAll']){_0x3cb03e['include']=[{'all':!![]}];}_0x3cb03e=_[_0xfd60('0x4a')]({},_0x3cb03e,_0x31e4b3[_0xfd60('0x51')]);return db['ZohoConfiguration'][_0xfd60('0x52')](_0x3cb03e)[_0xfd60('0x1d')](handleEntityNotFound(_0x5b7752,null))[_0xfd60('0x1d')](respondWithResult(_0x5b7752,null))[_0xfd60('0x26')](handleError(_0x5b7752,null));};exports['create']=function(_0x189068,_0x53d81a){return db[_0xfd60('0x4c')][_0xfd60('0x53')](_0x189068[_0xfd60('0x54')],{})[_0xfd60('0x1d')](respondWithResult(_0x53d81a,0xc9))[_0xfd60('0x26')](handleError(_0x53d81a,null));};exports[_0xfd60('0x32')]=function(_0x37f576,_0xb24a7e){if(_0x37f576[_0xfd60('0x54')]['id']){delete _0x37f576[_0xfd60('0x54')]['id'];}return db[_0xfd60('0x4c')][_0xfd60('0x52')]({'where':{'id':_0x37f576[_0xfd60('0x50')]['id']}})[_0xfd60('0x1d')](handleEntityNotFound(_0xb24a7e,null))['then'](saveUpdates(_0x37f576['body'],null))['then'](respondWithResult(_0xb24a7e,null))['catch'](handleError(_0xb24a7e,null));};exports[_0xfd60('0x33')]=function(_0x583b01,_0x110ff2){return db[_0xfd60('0x4c')][_0xfd60('0x52')]({'where':{'id':_0x583b01['params']['id']}})[_0xfd60('0x1d')](handleEntityNotFound(_0x110ff2,null))['then'](removeEntity(_0x110ff2,null))[_0xfd60('0x26')](handleError(_0x110ff2,null));};exports[_0xfd60('0x55')]=function(_0xde332b,_0x6a5094,_0x15bbb6){var _0x572dd0={};var _0x10dbbe={};var _0x3a11c4;var _0x59f883;return db['ZohoConfiguration'][_0xfd60('0x56')]({'where':{'id':_0xde332b[_0xfd60('0x50')]['id']}})['then'](handleEntityNotFound(_0x6a5094,null))[_0xfd60('0x1d')](function(_0x34abde){if(_0x34abde){_0x3a11c4=_0x34abde;_0x10dbbe[_0xfd60('0x3a')]=_[_0xfd60('0x3c')](db['ZohoField'][_0xfd60('0x36')]);_0x10dbbe['query']=_[_0xfd60('0x3c')](_0xde332b[_0xfd60('0x3f')]);_0x10dbbe['filters']=_[_0xfd60('0x3e')](_0x10dbbe[_0xfd60('0x3a')],_0x10dbbe[_0xfd60('0x3f')]);_0x572dd0[_0xfd60('0x41')]=_[_0xfd60('0x3e')](_0x10dbbe[_0xfd60('0x3a')],qs[_0xfd60('0x40')](_0xde332b[_0xfd60('0x3f')][_0xfd60('0x40')]));_0x572dd0[_0xfd60('0x41')]=_0x572dd0['attributes'][_0xfd60('0x42')]?_0x572dd0[_0xfd60('0x41')]:_0x10dbbe[_0xfd60('0x3a')];_0x572dd0[_0xfd60('0x45')]=qs['sort'](_0xde332b[_0xfd60('0x3f')][_0xfd60('0x46')]);_0x572dd0[_0xfd60('0x49')]=qs[_0xfd60('0x3d')](_[_0xfd60('0x47')](_0xde332b[_0xfd60('0x3f')],_0x10dbbe[_0xfd60('0x3d')]));if(_0xde332b[_0xfd60('0x3f')][_0xfd60('0x48')]){_0x572dd0[_0xfd60('0x49')]=_[_0xfd60('0x4a')](_0x572dd0[_0xfd60('0x49')],{'$or':_[_0xfd60('0x35')](_0x572dd0[_0xfd60('0x41')],function(_0x6e35cd){var _0x46bdd2={};_0x46bdd2[_0x6e35cd]={'$like':'%'+_0xde332b[_0xfd60('0x3f')][_0xfd60('0x48')]+'%'};return _0x46bdd2;})});}_0x572dd0=_[_0xfd60('0x4a')]({},_0x572dd0,_0xde332b[_0xfd60('0x51')]);return _0x3a11c4[_0xfd60('0x55')](_0x572dd0);}})[_0xfd60('0x1d')](function(_0x54d0a4){if(_0x54d0a4){_0x59f883=_0x54d0a4['length'];if(!_0xde332b[_0xfd60('0x3f')]['hasOwnProperty'](_0xfd60('0x44'))){_0x572dd0[_0xfd60('0x2d')]=qs[_0xfd60('0x2d')](_0xde332b['query']['limit']);_0x572dd0[_0xfd60('0x2c')]=qs['offset'](_0xde332b[_0xfd60('0x3f')]['offset']);}return _0x3a11c4[_0xfd60('0x55')](_0x572dd0);}})['then'](function(_0x1263cf){if(_0x1263cf){return _0x1263cf?{'count':_0x59f883,'rows':_0x1263cf}:null;}})[_0xfd60('0x1d')](respondWithResult(_0x6a5094,null))[_0xfd60('0x26')](handleError(_0x6a5094,null));};exports['getSubjects']=function(_0x402db2,_0x545751,_0x3f4597){var _0x27e65d={};var _0x107b83={};var _0x55e9c4;var _0x52f935;return db[_0xfd60('0x4c')][_0xfd60('0x56')]({'where':{'id':_0x402db2['params']['id']}})[_0xfd60('0x1d')](handleEntityNotFound(_0x545751,null))['then'](function(_0x5cb70c){if(_0x5cb70c){_0x55e9c4=_0x5cb70c;_0x107b83['model']=_[_0xfd60('0x3c')](db[_0xfd60('0x57')][_0xfd60('0x36')]);_0x107b83['query']=_[_0xfd60('0x3c')](_0x402db2[_0xfd60('0x3f')]);_0x107b83[_0xfd60('0x3d')]=_[_0xfd60('0x3e')](_0x107b83[_0xfd60('0x3a')],_0x107b83[_0xfd60('0x3f')]);_0x27e65d[_0xfd60('0x41')]=_[_0xfd60('0x3e')](_0x107b83['model'],qs['fields'](_0x402db2[_0xfd60('0x3f')][_0xfd60('0x40')]));_0x27e65d[_0xfd60('0x41')]=_0x27e65d[_0xfd60('0x41')]['length']?_0x27e65d[_0xfd60('0x41')]:_0x107b83['model'];_0x27e65d[_0xfd60('0x45')]=qs[_0xfd60('0x46')](_0x402db2[_0xfd60('0x3f')][_0xfd60('0x46')]);_0x27e65d[_0xfd60('0x49')]=qs[_0xfd60('0x3d')](_['pick'](_0x402db2[_0xfd60('0x3f')],_0x107b83[_0xfd60('0x3d')]));if(_0x402db2[_0xfd60('0x3f')][_0xfd60('0x48')]){_0x27e65d[_0xfd60('0x49')]=_['merge'](_0x27e65d[_0xfd60('0x49')],{'$or':_['map'](_0x27e65d[_0xfd60('0x41')],function(_0x270b62){var _0x2cdb6b={};_0x2cdb6b[_0x270b62]={'$like':'%'+_0x402db2['query']['filter']+'%'};return _0x2cdb6b;})});}_0x27e65d=_[_0xfd60('0x4a')]({},_0x27e65d,_0x402db2[_0xfd60('0x51')]);return _0x55e9c4[_0xfd60('0x58')](_0x27e65d);}})[_0xfd60('0x1d')](function(_0x6422c4){if(_0x6422c4){_0x52f935=_0x6422c4[_0xfd60('0x42')];if(!_0x402db2[_0xfd60('0x3f')][_0xfd60('0x43')](_0xfd60('0x44'))){_0x27e65d[_0xfd60('0x2d')]=qs[_0xfd60('0x2d')](_0x402db2[_0xfd60('0x3f')]['limit']);_0x27e65d[_0xfd60('0x2c')]=qs[_0xfd60('0x2c')](_0x402db2[_0xfd60('0x3f')][_0xfd60('0x2c')]);}return _0x55e9c4['getSubjects'](_0x27e65d);}})[_0xfd60('0x1d')](function(_0x40e032){if(_0x40e032){return _0x40e032?{'count':_0x52f935,'rows':_0x40e032}:null;}})[_0xfd60('0x1d')](respondWithResult(_0x545751,null))[_0xfd60('0x26')](handleError(_0x545751,null));};exports[_0xfd60('0x59')]=function(_0x227454,_0x3ed866,_0x57987a){var _0x58940e={};var _0x266989={};var _0x382875;var _0x1db4fe;return db[_0xfd60('0x4c')][_0xfd60('0x56')]({'where':{'id':_0x227454[_0xfd60('0x50')]['id']}})[_0xfd60('0x1d')](handleEntityNotFound(_0x3ed866,null))[_0xfd60('0x1d')](function(_0x1b4b3d){if(_0x1b4b3d){_0x382875=_0x1b4b3d;_0x266989[_0xfd60('0x3a')]=_[_0xfd60('0x3c')](db[_0xfd60('0x57')][_0xfd60('0x36')]);_0x266989[_0xfd60('0x3f')]=_['keys'](_0x227454[_0xfd60('0x3f')]);_0x266989[_0xfd60('0x3d')]=_[_0xfd60('0x3e')](_0x266989[_0xfd60('0x3a')],_0x266989[_0xfd60('0x3f')]);_0x58940e[_0xfd60('0x41')]=_[_0xfd60('0x3e')](_0x266989['model'],qs['fields'](_0x227454[_0xfd60('0x3f')][_0xfd60('0x40')]));_0x58940e['attributes']=_0x58940e[_0xfd60('0x41')][_0xfd60('0x42')]?_0x58940e[_0xfd60('0x41')]:_0x266989['model'];_0x58940e['order']=qs['sort'](_0x227454[_0xfd60('0x3f')]['sort']);_0x58940e[_0xfd60('0x49')]=qs[_0xfd60('0x3d')](_[_0xfd60('0x47')](_0x227454[_0xfd60('0x3f')],_0x266989[_0xfd60('0x3d')]));if(_0x227454[_0xfd60('0x3f')]['filter']){_0x58940e[_0xfd60('0x49')]=_[_0xfd60('0x4a')](_0x58940e[_0xfd60('0x49')],{'$or':_[_0xfd60('0x35')](_0x58940e[_0xfd60('0x41')],function(_0x717969){var _0x5c3c66={};_0x5c3c66[_0x717969]={'$like':'%'+_0x227454[_0xfd60('0x3f')][_0xfd60('0x48')]+'%'};return _0x5c3c66;})});}_0x58940e=_[_0xfd60('0x4a')]({},_0x58940e,_0x227454[_0xfd60('0x51')]);return _0x382875['getDescriptions'](_0x58940e);}})[_0xfd60('0x1d')](function(_0x1610aa){if(_0x1610aa){_0x1db4fe=_0x1610aa['length'];if(!_0x227454['query'][_0xfd60('0x43')](_0xfd60('0x44'))){_0x58940e['limit']=qs['limit'](_0x227454['query'][_0xfd60('0x2d')]);_0x58940e[_0xfd60('0x2c')]=qs['offset'](_0x227454['query'][_0xfd60('0x2c')]);}return _0x382875[_0xfd60('0x59')](_0x58940e);}})[_0xfd60('0x1d')](function(_0x315aa9){if(_0x315aa9){return _0x315aa9?{'count':_0x1db4fe,'rows':_0x315aa9}:null;}})[_0xfd60('0x1d')](respondWithResult(_0x3ed866,null))[_0xfd60('0x26')](handleError(_0x3ed866,null));};