Built motion from commit (unavailable).|2.4.18
[motion2.git] / server / api / intSugarcrmConfiguration / intSugarcrmConfiguration.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 _0x2a20=['filters','filter','merge','VIRTUAL','count','includeAll','include','findAll','catch','show','params','options','find','create','body','destroy','getFields','findOne','getSubjects','hasOwnProperty','getDescriptions','SugarcrmField','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','jsforce','desk.js','querystring','papaparse','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/utils','../../config/environment','jayson/promise','client','http','test','Sequelize','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','SugarcrmConfiguration,\x20%s,\x20%s','request\x20sent','error','code','message','status','end','offset','Content-Range','json','reject','save','update','sendStatus','name','index','SugarcrmConfiguration','rawAttributes','fieldName','key','model','map','keys','intersection','query','fields','attributes','length','nolimit','limit','order','sort','where','pick'];(function(_0xfae23b,_0x2be4ba){var _0x200640=function(_0x4ae258){while(--_0x4ae258){_0xfae23b['push'](_0xfae23b['shift']());}};_0x200640(++_0x2be4ba);}(_0x2a20,0x11e));var _0x02a2=function(_0x4d0382,_0x52b330){_0x4d0382=_0x4d0382-0x0;var _0x47b142=_0x2a20[_0x4d0382];return _0x47b142;};'use strict';var pdf=require(_0x02a2('0x0'));var emlformat=require(_0x02a2('0x1'));var rimraf=require(_0x02a2('0x2'));var zipdir=require(_0x02a2('0x3'));var jsonpatch=require(_0x02a2('0x4'));var rp=require(_0x02a2('0x5'));var moment=require(_0x02a2('0x6'));var BPromise=require(_0x02a2('0x7'));var Mustache=require('mustache');var util=require(_0x02a2('0x8'));var path=require(_0x02a2('0x9'));var sox=require(_0x02a2('0xa'));var csv=require(_0x02a2('0xb'));var ejs=require(_0x02a2('0xc'));var fs=require('fs');var _=require(_0x02a2('0xd'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0x02a2('0xe'));var deskjs=require(_0x02a2('0xf'));var toCsv=require(_0x02a2('0xb'));var querystring=require(_0x02a2('0x10'));var Papa=require(_0x02a2('0x11'));var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x02a2('0x12'));var as=require(_0x02a2('0x13'));var hardwareService=require(_0x02a2('0x14'));var logger=require('../../config/logger')('api');var utils=require(_0x02a2('0x15'));var config=require(_0x02a2('0x16'));var db=require('../../mysqldb')['db'];var jayson=require(_0x02a2('0x17'));var client=jayson[_0x02a2('0x18')][_0x02a2('0x19')]({'port':0x232a});function checkPasswordPattern(_0x153bd5,_0x184e4c,_0x18a863){if(_0x18a863){var _0x294767=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x294767[_0x02a2('0x1a')](_0x184e4c)){return _0x153bd5;}else{throw new db[(_0x02a2('0x1b'))]['ValidationError'](_0x02a2('0x1c'));}}else{return _0x153bd5;}}function respondWithRpcPromise(_0x4626fc,_0x3d4728,_0x363b75,_0x41c581){return new BPromise(function(_0x49c41b,_0x331dbf){var _0x50363e=_0x41c581||client;return _0x50363e[_0x02a2('0x1d')](_0x4626fc,_0x363b75)[_0x02a2('0x1e')](function(_0x50dc5d){logger[_0x02a2('0x1f')](_0x02a2('0x20'),_0x3d4728,_0x02a2('0x21'));logger['debug']('SugarcrmConfiguration,\x20%s,\x20%s,\x20%s',_0x3d4728,_0x02a2('0x21'),JSON['stringify'](_0x50dc5d));if(_0x50dc5d['error']){if(_0x50dc5d[_0x02a2('0x22')][_0x02a2('0x23')]===0x1f4){logger[_0x02a2('0x22')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x3d4728,_0x50dc5d[_0x02a2('0x22')][_0x02a2('0x24')]);return _0x331dbf(_0x50dc5d[_0x02a2('0x22')][_0x02a2('0x24')]);}logger[_0x02a2('0x22')](_0x02a2('0x20'),_0x3d4728,_0x50dc5d['error'][_0x02a2('0x24')]);return _0x49c41b(_0x50dc5d['error'][_0x02a2('0x24')]);}else{logger[_0x02a2('0x1f')]('SugarcrmConfiguration,\x20%s,\x20%s',_0x3d4728,_0x02a2('0x21'));_0x49c41b(_0x50dc5d['result'][_0x02a2('0x24')]);}})['catch'](function(_0x3b340f){logger[_0x02a2('0x22')](_0x02a2('0x20'),_0x3d4728,_0x3b340f);_0x331dbf(_0x3b340f);});});}function respondWithStatusCode(_0x4c16c4,_0x357a69){_0x357a69=_0x357a69||0xcc;return function(_0x4a6139){if(_0x4a6139){return _0x4c16c4['sendStatus'](_0x357a69);}return _0x4c16c4[_0x02a2('0x25')](_0x357a69)[_0x02a2('0x26')]();};}function respondWithResult(_0x5390d5,_0x4223a9){_0x4223a9=_0x4223a9||0xc8;return function(_0x1c21f5){if(_0x1c21f5){return _0x5390d5[_0x02a2('0x25')](_0x4223a9)['json'](_0x1c21f5);}};}function respondWithFilteredResult(_0x1c06ef,_0x532800){return function(_0x1647eb){if(_0x1647eb){var _0x152798=_0x1647eb['count'],_0x4e6ae8=_0x532800[_0x02a2('0x27')],_0xcbcee9=_0x532800[_0x02a2('0x27')]+_0x532800['limit'],_0x4afab4;if(_0xcbcee9>=_0x152798){_0xcbcee9=_0x152798;_0x4afab4=0xc8;}else{_0x4afab4=0xce;}_0x1c06ef['status'](_0x4afab4);return _0x1c06ef['set'](_0x02a2('0x28'),_0x4e6ae8+'-'+_0xcbcee9+'/'+_0x152798)[_0x02a2('0x29')](_0x1647eb);}return null;};}function patchUpdates(_0x5046be){return function(_0x33c8fe){try{jsonpatch['apply'](_0x33c8fe,_0x5046be,!![]);}catch(_0x239e31){return BPromise[_0x02a2('0x2a')](_0x239e31);}return _0x33c8fe[_0x02a2('0x2b')]();};}function saveUpdates(_0x33c924,_0x1bce6c){return function(_0x45469f){if(_0x45469f){return _0x45469f[_0x02a2('0x2c')](_0x33c924)['then'](function(_0x4e7703){return _0x4e7703;});}return null;};}function removeEntity(_0x52a676,_0x2d2695){return function(_0x456c06){if(_0x456c06){return _0x456c06['destroy']()[_0x02a2('0x1e')](function(){_0x52a676[_0x02a2('0x25')](0xcc)[_0x02a2('0x26')]();});}};}function handleEntityNotFound(_0x2de9bf,_0x128fb8){return function(_0x2affb8){if(!_0x2affb8){_0x2de9bf[_0x02a2('0x2d')](0x194);}return _0x2affb8;};}function handleError(_0x1b7531,_0x5c1ab7){_0x5c1ab7=_0x5c1ab7||0x1f4;return function(_0x57f930){logger['error'](_0x57f930['stack']);if(_0x57f930['name']){delete _0x57f930[_0x02a2('0x2e')];}_0x1b7531[_0x02a2('0x25')](_0x5c1ab7)['send'](_0x57f930);};}exports[_0x02a2('0x2f')]=function(_0x5f1791,_0x43a4b9){var _0xfa13bc={},_0xf08e1e={},_0x197041={'count':0x0,'rows':[]};var _0x1f86e9=_['map'](db[_0x02a2('0x30')][_0x02a2('0x31')],function(_0x16c272){return{'name':_0x16c272[_0x02a2('0x32')],'type':_0x16c272['type'][_0x02a2('0x33')]};});_0xf08e1e[_0x02a2('0x34')]=_[_0x02a2('0x35')](_0x1f86e9,'name');_0xf08e1e['query']=_[_0x02a2('0x36')](_0x5f1791['query']);_0xf08e1e['filters']=_[_0x02a2('0x37')](_0xf08e1e['model'],_0xf08e1e[_0x02a2('0x38')]);_0xfa13bc['attributes']=_[_0x02a2('0x37')](_0xf08e1e['model'],qs[_0x02a2('0x39')](_0x5f1791[_0x02a2('0x38')]['fields']));_0xfa13bc[_0x02a2('0x3a')]=_0xfa13bc[_0x02a2('0x3a')][_0x02a2('0x3b')]?_0xfa13bc[_0x02a2('0x3a')]:_0xf08e1e[_0x02a2('0x34')];if(!_0x5f1791['query']['hasOwnProperty'](_0x02a2('0x3c'))){_0xfa13bc[_0x02a2('0x3d')]=qs['limit'](_0x5f1791[_0x02a2('0x38')][_0x02a2('0x3d')]);_0xfa13bc[_0x02a2('0x27')]=qs[_0x02a2('0x27')](_0x5f1791['query'][_0x02a2('0x27')]);}_0xfa13bc[_0x02a2('0x3e')]=qs['sort'](_0x5f1791[_0x02a2('0x38')][_0x02a2('0x3f')]);_0xfa13bc[_0x02a2('0x40')]=qs['filters'](_[_0x02a2('0x41')](_0x5f1791[_0x02a2('0x38')],_0xf08e1e[_0x02a2('0x42')]));if(_0x5f1791[_0x02a2('0x38')][_0x02a2('0x43')]){_0xfa13bc[_0x02a2('0x40')]=_[_0x02a2('0x44')](_0xfa13bc[_0x02a2('0x40')],{'$or':_[_0x02a2('0x35')](_0x1f86e9,function(_0x47af27){if(_0x47af27['type']!==_0x02a2('0x45')){var _0x7ada07={};_0x7ada07[_0x47af27[_0x02a2('0x2e')]]={'$like':'%'+_0x5f1791['query'][_0x02a2('0x43')]+'%'};return _0x7ada07;}})});}_0xfa13bc=_['merge']({},_0xfa13bc,_0x5f1791['options']);var _0x15e598={'where':_0xfa13bc['where']};return db[_0x02a2('0x30')][_0x02a2('0x46')](_0x15e598)[_0x02a2('0x1e')](function(_0x1e96e9){_0x197041[_0x02a2('0x46')]=_0x1e96e9;if(_0x5f1791[_0x02a2('0x38')][_0x02a2('0x47')]){_0xfa13bc[_0x02a2('0x48')]=[{'all':!![]}];}return db[_0x02a2('0x30')][_0x02a2('0x49')](_0xfa13bc);})['then'](function(_0x2a541a){_0x197041['rows']=_0x2a541a;return _0x197041;})[_0x02a2('0x1e')](respondWithFilteredResult(_0x43a4b9,_0xfa13bc))[_0x02a2('0x4a')](handleError(_0x43a4b9,null));};exports[_0x02a2('0x4b')]=function(_0x559907,_0x1a034d){var _0x834eeb={'raw':![],'where':{'id':_0x559907[_0x02a2('0x4c')]['id']}},_0x42c087={};_0x42c087[_0x02a2('0x34')]=_[_0x02a2('0x36')](db[_0x02a2('0x30')][_0x02a2('0x31')]);_0x42c087[_0x02a2('0x38')]=_[_0x02a2('0x36')](_0x559907['query']);_0x42c087[_0x02a2('0x42')]=_[_0x02a2('0x37')](_0x42c087[_0x02a2('0x34')],_0x42c087[_0x02a2('0x38')]);_0x834eeb[_0x02a2('0x3a')]=_[_0x02a2('0x37')](_0x42c087['model'],qs[_0x02a2('0x39')](_0x559907[_0x02a2('0x38')][_0x02a2('0x39')]));_0x834eeb[_0x02a2('0x3a')]=_0x834eeb['attributes']['length']?_0x834eeb[_0x02a2('0x3a')]:_0x42c087[_0x02a2('0x34')];if(_0x559907['query'][_0x02a2('0x47')]){_0x834eeb[_0x02a2('0x48')]=[{'all':!![]}];}_0x834eeb=_['merge']({},_0x834eeb,_0x559907[_0x02a2('0x4d')]);return db[_0x02a2('0x30')][_0x02a2('0x4e')](_0x834eeb)[_0x02a2('0x1e')](handleEntityNotFound(_0x1a034d,null))[_0x02a2('0x1e')](respondWithResult(_0x1a034d,null))[_0x02a2('0x4a')](handleError(_0x1a034d,null));};exports[_0x02a2('0x4f')]=function(_0x1cab2c,_0x581600){return db[_0x02a2('0x30')][_0x02a2('0x4f')](_0x1cab2c[_0x02a2('0x50')],{})[_0x02a2('0x1e')](respondWithResult(_0x581600,0xc9))[_0x02a2('0x4a')](handleError(_0x581600,null));};exports['update']=function(_0x256e97,_0x2045bb){if(_0x256e97['body']['id']){delete _0x256e97[_0x02a2('0x50')]['id'];}return db[_0x02a2('0x30')][_0x02a2('0x4e')]({'where':{'id':_0x256e97[_0x02a2('0x4c')]['id']}})[_0x02a2('0x1e')](handleEntityNotFound(_0x2045bb,null))[_0x02a2('0x1e')](saveUpdates(_0x256e97[_0x02a2('0x50')],null))[_0x02a2('0x1e')](respondWithResult(_0x2045bb,null))['catch'](handleError(_0x2045bb,null));};exports[_0x02a2('0x51')]=function(_0x1df68a,_0x44a857){return db[_0x02a2('0x30')][_0x02a2('0x4e')]({'where':{'id':_0x1df68a[_0x02a2('0x4c')]['id']}})[_0x02a2('0x1e')](handleEntityNotFound(_0x44a857,null))[_0x02a2('0x1e')](removeEntity(_0x44a857,null))[_0x02a2('0x4a')](handleError(_0x44a857,null));};exports[_0x02a2('0x52')]=function(_0x3002a9,_0x3bd217,_0x2e9b46){var _0x240dc7={};var _0x4f7efb={};var _0x2da2c3;var _0x39060f;return db['SugarcrmConfiguration']['findOne']({'where':{'id':_0x3002a9['params']['id']}})['then'](handleEntityNotFound(_0x3bd217,null))[_0x02a2('0x1e')](function(_0x429d38){if(_0x429d38){_0x2da2c3=_0x429d38;_0x4f7efb[_0x02a2('0x34')]=_[_0x02a2('0x36')](db['SugarcrmField'][_0x02a2('0x31')]);_0x4f7efb[_0x02a2('0x38')]=_[_0x02a2('0x36')](_0x3002a9[_0x02a2('0x38')]);_0x4f7efb[_0x02a2('0x42')]=_['intersection'](_0x4f7efb[_0x02a2('0x34')],_0x4f7efb[_0x02a2('0x38')]);_0x240dc7[_0x02a2('0x3a')]=_[_0x02a2('0x37')](_0x4f7efb[_0x02a2('0x34')],qs[_0x02a2('0x39')](_0x3002a9['query'][_0x02a2('0x39')]));_0x240dc7[_0x02a2('0x3a')]=_0x240dc7[_0x02a2('0x3a')]['length']?_0x240dc7[_0x02a2('0x3a')]:_0x4f7efb[_0x02a2('0x34')];_0x240dc7[_0x02a2('0x3e')]=qs[_0x02a2('0x3f')](_0x3002a9[_0x02a2('0x38')][_0x02a2('0x3f')]);_0x240dc7[_0x02a2('0x40')]=qs['filters'](_[_0x02a2('0x41')](_0x3002a9[_0x02a2('0x38')],_0x4f7efb[_0x02a2('0x42')]));if(_0x3002a9['query'][_0x02a2('0x43')]){_0x240dc7[_0x02a2('0x40')]=_['merge'](_0x240dc7[_0x02a2('0x40')],{'$or':_['map'](_0x240dc7[_0x02a2('0x3a')],function(_0x5a2a1e){var _0x33a7df={};_0x33a7df[_0x5a2a1e]={'$like':'%'+_0x3002a9[_0x02a2('0x38')][_0x02a2('0x43')]+'%'};return _0x33a7df;})});}_0x240dc7=_[_0x02a2('0x44')]({},_0x240dc7,_0x3002a9['options']);return _0x2da2c3['getFields'](_0x240dc7);}})[_0x02a2('0x1e')](function(_0xfeeec0){if(_0xfeeec0){_0x39060f=_0xfeeec0['length'];if(!_0x3002a9[_0x02a2('0x38')]['hasOwnProperty'](_0x02a2('0x3c'))){_0x240dc7[_0x02a2('0x3d')]=qs[_0x02a2('0x3d')](_0x3002a9['query'][_0x02a2('0x3d')]);_0x240dc7['offset']=qs[_0x02a2('0x27')](_0x3002a9[_0x02a2('0x38')]['offset']);}return _0x2da2c3[_0x02a2('0x52')](_0x240dc7);}})[_0x02a2('0x1e')](function(_0x4817e6){if(_0x4817e6){return _0x4817e6?{'count':_0x39060f,'rows':_0x4817e6}:null;}})['then'](respondWithResult(_0x3bd217,null))[_0x02a2('0x4a')](handleError(_0x3bd217,null));};exports['getSubjects']=function(_0x18d2fb,_0x18f135,_0x41ee29){var _0x3ecd2d={};var _0x40d74d={};var _0x126773;var _0x1a38d7;return db['SugarcrmConfiguration'][_0x02a2('0x53')]({'where':{'id':_0x18d2fb[_0x02a2('0x4c')]['id']}})[_0x02a2('0x1e')](handleEntityNotFound(_0x18f135,null))[_0x02a2('0x1e')](function(_0x33a10c){if(_0x33a10c){_0x126773=_0x33a10c;_0x40d74d[_0x02a2('0x34')]=_[_0x02a2('0x36')](db['SugarcrmField'][_0x02a2('0x31')]);_0x40d74d[_0x02a2('0x38')]=_['keys'](_0x18d2fb[_0x02a2('0x38')]);_0x40d74d['filters']=_[_0x02a2('0x37')](_0x40d74d['model'],_0x40d74d[_0x02a2('0x38')]);_0x3ecd2d[_0x02a2('0x3a')]=_['intersection'](_0x40d74d[_0x02a2('0x34')],qs['fields'](_0x18d2fb[_0x02a2('0x38')]['fields']));_0x3ecd2d[_0x02a2('0x3a')]=_0x3ecd2d[_0x02a2('0x3a')]['length']?_0x3ecd2d[_0x02a2('0x3a')]:_0x40d74d['model'];_0x3ecd2d[_0x02a2('0x3e')]=qs[_0x02a2('0x3f')](_0x18d2fb[_0x02a2('0x38')]['sort']);_0x3ecd2d[_0x02a2('0x40')]=qs['filters'](_[_0x02a2('0x41')](_0x18d2fb[_0x02a2('0x38')],_0x40d74d[_0x02a2('0x42')]));if(_0x18d2fb[_0x02a2('0x38')][_0x02a2('0x43')]){_0x3ecd2d[_0x02a2('0x40')]=_[_0x02a2('0x44')](_0x3ecd2d[_0x02a2('0x40')],{'$or':_['map'](_0x3ecd2d[_0x02a2('0x3a')],function(_0x59a1b5){var _0x4d7120={};_0x4d7120[_0x59a1b5]={'$like':'%'+_0x18d2fb[_0x02a2('0x38')][_0x02a2('0x43')]+'%'};return _0x4d7120;})});}_0x3ecd2d=_[_0x02a2('0x44')]({},_0x3ecd2d,_0x18d2fb[_0x02a2('0x4d')]);return _0x126773[_0x02a2('0x54')](_0x3ecd2d);}})['then'](function(_0x4f1e8f){if(_0x4f1e8f){_0x1a38d7=_0x4f1e8f['length'];if(!_0x18d2fb['query'][_0x02a2('0x55')](_0x02a2('0x3c'))){_0x3ecd2d[_0x02a2('0x3d')]=qs['limit'](_0x18d2fb[_0x02a2('0x38')][_0x02a2('0x3d')]);_0x3ecd2d[_0x02a2('0x27')]=qs[_0x02a2('0x27')](_0x18d2fb['query'][_0x02a2('0x27')]);}return _0x126773[_0x02a2('0x54')](_0x3ecd2d);}})['then'](function(_0x1d6612){if(_0x1d6612){return _0x1d6612?{'count':_0x1a38d7,'rows':_0x1d6612}:null;}})[_0x02a2('0x1e')](respondWithResult(_0x18f135,null))['catch'](handleError(_0x18f135,null));};exports[_0x02a2('0x56')]=function(_0x5cbcc9,_0x569e6d,_0x18a9ee){var _0x28fb43={};var _0xbce9a4={};var _0x1f9ca5;var _0x3831d2;return db['SugarcrmConfiguration'][_0x02a2('0x53')]({'where':{'id':_0x5cbcc9['params']['id']}})[_0x02a2('0x1e')](handleEntityNotFound(_0x569e6d,null))['then'](function(_0x5d2eec){if(_0x5d2eec){_0x1f9ca5=_0x5d2eec;_0xbce9a4[_0x02a2('0x34')]=_[_0x02a2('0x36')](db[_0x02a2('0x57')]['rawAttributes']);_0xbce9a4['query']=_[_0x02a2('0x36')](_0x5cbcc9['query']);_0xbce9a4['filters']=_[_0x02a2('0x37')](_0xbce9a4[_0x02a2('0x34')],_0xbce9a4[_0x02a2('0x38')]);_0x28fb43['attributes']=_[_0x02a2('0x37')](_0xbce9a4['model'],qs[_0x02a2('0x39')](_0x5cbcc9['query'][_0x02a2('0x39')]));_0x28fb43[_0x02a2('0x3a')]=_0x28fb43[_0x02a2('0x3a')][_0x02a2('0x3b')]?_0x28fb43[_0x02a2('0x3a')]:_0xbce9a4[_0x02a2('0x34')];_0x28fb43[_0x02a2('0x3e')]=qs['sort'](_0x5cbcc9[_0x02a2('0x38')][_0x02a2('0x3f')]);_0x28fb43[_0x02a2('0x40')]=qs[_0x02a2('0x42')](_[_0x02a2('0x41')](_0x5cbcc9[_0x02a2('0x38')],_0xbce9a4[_0x02a2('0x42')]));if(_0x5cbcc9['query'][_0x02a2('0x43')]){_0x28fb43[_0x02a2('0x40')]=_['merge'](_0x28fb43[_0x02a2('0x40')],{'$or':_[_0x02a2('0x35')](_0x28fb43['attributes'],function(_0x314dd0){var _0x3ee8ce={};_0x3ee8ce[_0x314dd0]={'$like':'%'+_0x5cbcc9[_0x02a2('0x38')]['filter']+'%'};return _0x3ee8ce;})});}_0x28fb43=_[_0x02a2('0x44')]({},_0x28fb43,_0x5cbcc9[_0x02a2('0x4d')]);return _0x1f9ca5[_0x02a2('0x56')](_0x28fb43);}})[_0x02a2('0x1e')](function(_0x4c5b14){if(_0x4c5b14){_0x3831d2=_0x4c5b14[_0x02a2('0x3b')];if(!_0x5cbcc9[_0x02a2('0x38')]['hasOwnProperty'](_0x02a2('0x3c'))){_0x28fb43[_0x02a2('0x3d')]=qs['limit'](_0x5cbcc9['query'][_0x02a2('0x3d')]);_0x28fb43[_0x02a2('0x27')]=qs['offset'](_0x5cbcc9[_0x02a2('0x38')][_0x02a2('0x27')]);}return _0x1f9ca5[_0x02a2('0x56')](_0x28fb43);}})[_0x02a2('0x1e')](function(_0x3a7e2a){if(_0x3a7e2a){return _0x3a7e2a?{'count':_0x3831d2,'rows':_0x3a7e2a}:null;}})[_0x02a2('0x1e')](respondWithResult(_0x569e6d,null))[_0x02a2('0x4a')](handleError(_0x569e6d,null));};