Built motion from commit (unavailable).|2.2.0
[motion2.git] / server / api / intVtigerConfiguration / intVtigerConfiguration.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 _0xde1b=['nolimit','limit','order','sort','where','filters','pick','add','day','merge','filter','map','type','key','field','options','includeAll','findAll','rows','show','params','include','create','body','find','getFields','findOne','VtigerField','length','hasOwnProperty','getSubjects','getDescriptions','eml-format','fast-json-patch','request-promise','mustache','util','path','ejs','lodash','jsforce','desk.js','to-csv','papaparse','../../components/parsers/qs','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','jayson/promise','client','http','request','then','info','VtigerConfiguration,\x20%s,\x20%s','VtigerConfiguration,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','error','code','message','result','catch','status','end','json','count','offset','set','Content-Range','reject','save','update','destroy','sendStatus','stack','name','send','index','VtigerConfiguration','rawAttributes','keys','query','dateEnd','dateStart','intersection','model','attributes','fields'];(function(_0x4a8c3b,_0x3d6be9){var _0xfe6c2e=function(_0x5b8756){while(--_0x5b8756){_0x4a8c3b['push'](_0x4a8c3b['shift']());}};_0xfe6c2e(++_0x3d6be9);}(_0xde1b,0x12e));var _0xbde1=function(_0x2c0a06,_0x5bae1b){_0x2c0a06=_0x2c0a06-0x0;var _0x386ab7=_0xde1b[_0x2c0a06];return _0x386ab7;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xbde1('0x0'));var rimraf=require('rimraf');var zipdir=require('zip-dir');var jsonpatch=require(_0xbde1('0x1'));var rp=require(_0xbde1('0x2'));var moment=require('moment');var BPromise=require('bluebird');var Mustache=require(_0xbde1('0x3'));var util=require(_0xbde1('0x4'));var path=require(_0xbde1('0x5'));var sox=require('sox');var csv=require('to-csv');var ejs=require(_0xbde1('0x6'));var fs=require('fs');var _=require(_0xbde1('0x7'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xbde1('0x8'));var deskjs=require(_0xbde1('0x9'));var toCsv=require(_0xbde1('0xa'));var querystring=require('querystring');var Papa=require(_0xbde1('0xb'));var Redis=require('ioredis');var qs=require(_0xbde1('0xc'));var logger=require(_0xbde1('0xd'))('api');var utils=require(_0xbde1('0xe'));var config=require(_0xbde1('0xf'));var db=require(_0xbde1('0x10'))['db'];var jayson=require(_0xbde1('0x11'));var client=jayson[_0xbde1('0x12')][_0xbde1('0x13')]({'port':0x232a});function respondWithRpcPromise(_0x58be2c,_0x4de586,_0x204a04,_0x2b191f){return new BPromise(function(_0x508776,_0x2db61c){var _0xd990a=_0x2b191f||client;return _0xd990a[_0xbde1('0x14')](_0x58be2c,_0x204a04)[_0xbde1('0x15')](function(_0x54fe3b){logger[_0xbde1('0x16')](_0xbde1('0x17'),_0x4de586,'request\x20sent');logger['debug'](_0xbde1('0x18'),_0x4de586,_0xbde1('0x19'),JSON[_0xbde1('0x1a')](_0x54fe3b));if(_0x54fe3b['error']){if(_0x54fe3b[_0xbde1('0x1b')][_0xbde1('0x1c')]===0x1f4){logger['error'](_0xbde1('0x17'),_0x4de586,_0x54fe3b['error'][_0xbde1('0x1d')]);return _0x2db61c(_0x54fe3b[_0xbde1('0x1b')][_0xbde1('0x1d')]);}logger[_0xbde1('0x1b')](_0xbde1('0x17'),_0x4de586,_0x54fe3b['error'][_0xbde1('0x1d')]);return _0x508776(_0x54fe3b['error'][_0xbde1('0x1d')]);}else{logger[_0xbde1('0x16')]('VtigerConfiguration,\x20%s,\x20%s',_0x4de586,_0xbde1('0x19'));_0x508776(_0x54fe3b[_0xbde1('0x1e')][_0xbde1('0x1d')]);}})[_0xbde1('0x1f')](function(_0x1ad183){logger['error']('VtigerConfiguration,\x20%s,\x20%s',_0x4de586,_0x1ad183);_0x2db61c(_0x1ad183);});});}function respondWithStatusCode(_0x3621bf,_0x321d1e){_0x321d1e=_0x321d1e||0xcc;return function(_0x10b32e){if(_0x10b32e){return _0x3621bf['sendStatus'](_0x321d1e);}return _0x3621bf[_0xbde1('0x20')](_0x321d1e)[_0xbde1('0x21')]();};}function respondWithResult(_0x4bdbea,_0x1320df){_0x1320df=_0x1320df||0xc8;return function(_0x1e6c54){if(_0x1e6c54){return _0x4bdbea[_0xbde1('0x20')](_0x1320df)[_0xbde1('0x22')](_0x1e6c54);}};}function respondWithFilteredResult(_0x12b62b,_0x540b17){return function(_0x459942){if(_0x459942){var _0x29e796=_0x459942[_0xbde1('0x23')],_0x4e672a=_0x540b17[_0xbde1('0x24')],_0x22abd8=_0x540b17[_0xbde1('0x24')]+_0x540b17['limit'],_0x1c7d5d;if(_0x22abd8>=_0x29e796){_0x22abd8=_0x29e796;_0x1c7d5d=0xc8;}else{_0x1c7d5d=0xce;}_0x12b62b[_0xbde1('0x20')](_0x1c7d5d);return _0x12b62b[_0xbde1('0x25')](_0xbde1('0x26'),_0x4e672a+'-'+_0x22abd8+'/'+_0x29e796)['json'](_0x459942);}return null;};}function patchUpdates(_0xf9f6dc){return function(_0x2f2bfe){try{jsonpatch['apply'](_0x2f2bfe,_0xf9f6dc,!![]);}catch(_0x3dc597){return BPromise[_0xbde1('0x27')](_0x3dc597);}return _0x2f2bfe[_0xbde1('0x28')]();};}function saveUpdates(_0x48a71e,_0x7651aa){return function(_0x5d04c7){if(_0x5d04c7){return _0x5d04c7[_0xbde1('0x29')](_0x48a71e)[_0xbde1('0x15')](function(_0x10d89e){return _0x10d89e;});}return null;};}function removeEntity(_0x3d9b9a,_0x14b04b){return function(_0x3f3024){if(_0x3f3024){return _0x3f3024[_0xbde1('0x2a')]()[_0xbde1('0x15')](function(){_0x3d9b9a['status'](0xcc)[_0xbde1('0x21')]();});}};}function handleEntityNotFound(_0x1829e6,_0x55d3eb){return function(_0x27d323){if(!_0x27d323){_0x1829e6[_0xbde1('0x2b')](0x194);}return _0x27d323;};}function handleError(_0x492f4f,_0xa19f57){_0xa19f57=_0xa19f57||0x1f4;return function(_0x5042aa){logger[_0xbde1('0x1b')](_0x5042aa[_0xbde1('0x2c')]);if(_0x5042aa[_0xbde1('0x2d')]){delete _0x5042aa[_0xbde1('0x2d')];}_0x492f4f[_0xbde1('0x20')](_0xa19f57)[_0xbde1('0x2e')](_0x5042aa);};}exports[_0xbde1('0x2f')]=function(_0x4e2e11,_0xb2fa57){var _0x256a2e={},_0x29426c={},_0x5a89c9={'count':0x0,'rows':[]};var _0x13dfa8=db[_0xbde1('0x30')][_0xbde1('0x31')];_0x29426c['model']=_[_0xbde1('0x32')](_0x13dfa8);var _0x6a3e85={'dateStart':_0x4e2e11[_0xbde1('0x33')]['dateStart'],'dateEnd':_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x34')]};delete _0x4e2e11[_0xbde1('0x33')][_0xbde1('0x35')];delete _0x4e2e11[_0xbde1('0x33')]['dateEnd'];_0x29426c[_0xbde1('0x33')]=_[_0xbde1('0x32')](_0x4e2e11[_0xbde1('0x33')]);_0x29426c['filters']=_[_0xbde1('0x36')](_0x29426c[_0xbde1('0x37')],_0x29426c[_0xbde1('0x33')]);_0x256a2e[_0xbde1('0x38')]=_[_0xbde1('0x36')](_0x29426c[_0xbde1('0x37')],qs[_0xbde1('0x39')](_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x39')]));_0x256a2e['attributes']=_0x256a2e[_0xbde1('0x38')]['length']?_0x256a2e['attributes']:_0x29426c['model'];if(!_0x4e2e11['query']['hasOwnProperty'](_0xbde1('0x3a'))){_0x256a2e[_0xbde1('0x3b')]=qs[_0xbde1('0x3b')](_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x3b')]);_0x256a2e[_0xbde1('0x24')]=qs[_0xbde1('0x24')](_0x4e2e11[_0xbde1('0x33')]['offset']);}_0x256a2e[_0xbde1('0x3c')]=qs['sort'](_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x3d')]);_0x256a2e[_0xbde1('0x3e')]=qs[_0xbde1('0x3f')](_[_0xbde1('0x40')](_0x4e2e11[_0xbde1('0x33')],_0x29426c[_0xbde1('0x3f')]));if(_0x6a3e85['dateStart']){if(_0x6a3e85[_0xbde1('0x34')]){_0x6a3e85[_0xbde1('0x34')]=moment(_0x6a3e85[_0xbde1('0x34')])[_0xbde1('0x41')](0x1,'day');}else{_0x6a3e85[_0xbde1('0x34')]=moment(_0x6a3e85[_0xbde1('0x35')])[_0xbde1('0x41')](0x1,_0xbde1('0x42'));}_[_0xbde1('0x43')](_0x256a2e[_0xbde1('0x3e')],{'createdAt':{'$gte':_0x6a3e85[_0xbde1('0x35')],'$lte':_0x6a3e85['dateEnd']}});}if(_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x44')]){_0x256a2e['where']=_['merge'](_0x256a2e['where'],{'$or':_[_0xbde1('0x45')](_0x13dfa8,function(_0x185c97){if(_0x185c97[_0xbde1('0x46')][_0xbde1('0x47')]!=='VIRTUAL'){var _0xf75bcc={};_0xf75bcc[_0x185c97[_0xbde1('0x48')]]={'$like':'%'+_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x44')]+'%'};return _0xf75bcc;}})});}_0x256a2e=_[_0xbde1('0x43')]({},_0x256a2e,_0x4e2e11[_0xbde1('0x49')]);var _0x4c9474={'where':_0x256a2e[_0xbde1('0x3e')]};return db['VtigerConfiguration'][_0xbde1('0x23')](_0x4c9474)[_0xbde1('0x15')](function(_0x40ecbb){_0x5a89c9[_0xbde1('0x23')]=_0x40ecbb;if(_0x4e2e11[_0xbde1('0x33')][_0xbde1('0x4a')]){_0x256a2e['include']=[{'all':!![]}];}return db[_0xbde1('0x30')][_0xbde1('0x4b')](_0x256a2e);})[_0xbde1('0x15')](function(_0x5a532e){_0x5a89c9[_0xbde1('0x4c')]=_0x5a532e;return _0x5a89c9;})['then'](respondWithFilteredResult(_0xb2fa57,_0x256a2e))[_0xbde1('0x1f')](handleError(_0xb2fa57,null));};exports[_0xbde1('0x4d')]=function(_0x4c3c62,_0x5adca4){var _0x1db878={'raw':![],'where':{'id':_0x4c3c62[_0xbde1('0x4e')]['id']}},_0x21f25b={};_0x21f25b[_0xbde1('0x37')]=_[_0xbde1('0x32')](db['VtigerConfiguration'][_0xbde1('0x31')]);_0x21f25b[_0xbde1('0x33')]=_['keys'](_0x4c3c62[_0xbde1('0x33')]);_0x21f25b['filters']=_[_0xbde1('0x36')](_0x21f25b[_0xbde1('0x37')],_0x21f25b[_0xbde1('0x33')]);_0x1db878[_0xbde1('0x38')]=_[_0xbde1('0x36')](_0x21f25b['model'],qs[_0xbde1('0x39')](_0x4c3c62[_0xbde1('0x33')][_0xbde1('0x39')]));_0x1db878[_0xbde1('0x38')]=_0x1db878[_0xbde1('0x38')]['length']?_0x1db878[_0xbde1('0x38')]:_0x21f25b[_0xbde1('0x37')];if(_0x4c3c62[_0xbde1('0x33')][_0xbde1('0x4a')]){_0x1db878[_0xbde1('0x4f')]=[{'all':!![]}];}_0x1db878=_[_0xbde1('0x43')]({},_0x1db878,_0x4c3c62['options']);return db[_0xbde1('0x30')]['find'](_0x1db878)[_0xbde1('0x15')](handleEntityNotFound(_0x5adca4,null))[_0xbde1('0x15')](respondWithResult(_0x5adca4,null))['catch'](handleError(_0x5adca4,null));};exports[_0xbde1('0x50')]=function(_0x2b1652,_0x4afbed){return db['VtigerConfiguration']['create'](_0x2b1652[_0xbde1('0x51')],{})[_0xbde1('0x15')](respondWithResult(_0x4afbed,0xc9))['catch'](handleError(_0x4afbed,null));};exports['update']=function(_0x59994e,_0x57bb4c){if(_0x59994e[_0xbde1('0x51')]['id']){delete _0x59994e[_0xbde1('0x51')]['id'];}return db[_0xbde1('0x30')][_0xbde1('0x52')]({'where':{'id':_0x59994e[_0xbde1('0x4e')]['id']}})[_0xbde1('0x15')](handleEntityNotFound(_0x57bb4c,null))['then'](saveUpdates(_0x59994e[_0xbde1('0x51')],null))[_0xbde1('0x15')](respondWithResult(_0x57bb4c,null))[_0xbde1('0x1f')](handleError(_0x57bb4c,null));};exports[_0xbde1('0x2a')]=function(_0x46b424,_0x4fa1bf){return db[_0xbde1('0x30')][_0xbde1('0x52')]({'where':{'id':_0x46b424['params']['id']}})[_0xbde1('0x15')](handleEntityNotFound(_0x4fa1bf,null))['then'](removeEntity(_0x4fa1bf,null))[_0xbde1('0x1f')](handleError(_0x4fa1bf,null));};exports[_0xbde1('0x53')]=function(_0x3efe07,_0x30dcce,_0x315931){var _0x260dc2={};var _0x26be64={};var _0x1934fa;var _0x2ab018;return db[_0xbde1('0x30')][_0xbde1('0x54')]({'where':{'id':_0x3efe07['params']['id']}})[_0xbde1('0x15')](handleEntityNotFound(_0x30dcce,null))['then'](function(_0x2e45ae){if(_0x2e45ae){_0x1934fa=_0x2e45ae;_0x26be64[_0xbde1('0x37')]=_[_0xbde1('0x32')](db[_0xbde1('0x55')][_0xbde1('0x31')]);_0x26be64[_0xbde1('0x33')]=_[_0xbde1('0x32')](_0x3efe07[_0xbde1('0x33')]);_0x26be64[_0xbde1('0x3f')]=_[_0xbde1('0x36')](_0x26be64[_0xbde1('0x37')],_0x26be64[_0xbde1('0x33')]);_0x260dc2['attributes']=_[_0xbde1('0x36')](_0x26be64['model'],qs[_0xbde1('0x39')](_0x3efe07[_0xbde1('0x33')][_0xbde1('0x39')]));_0x260dc2['attributes']=_0x260dc2[_0xbde1('0x38')]['length']?_0x260dc2[_0xbde1('0x38')]:_0x26be64[_0xbde1('0x37')];_0x260dc2[_0xbde1('0x3c')]=qs[_0xbde1('0x3d')](_0x3efe07[_0xbde1('0x33')][_0xbde1('0x3d')]);_0x260dc2['where']=qs[_0xbde1('0x3f')](_[_0xbde1('0x40')](_0x3efe07[_0xbde1('0x33')],_0x26be64[_0xbde1('0x3f')]));if(_0x3efe07[_0xbde1('0x33')]['filter']){_0x260dc2[_0xbde1('0x3e')]=_[_0xbde1('0x43')](_0x260dc2[_0xbde1('0x3e')],{'$or':_[_0xbde1('0x45')](_0x260dc2[_0xbde1('0x38')],function(_0x3b193a){var _0x1756ab={};_0x1756ab[_0x3b193a]={'$like':'%'+_0x3efe07[_0xbde1('0x33')][_0xbde1('0x44')]+'%'};return _0x1756ab;})});}_0x260dc2=_[_0xbde1('0x43')]({},_0x260dc2,_0x3efe07[_0xbde1('0x49')]);return _0x1934fa[_0xbde1('0x53')](_0x260dc2);}})[_0xbde1('0x15')](function(_0xa4868c){if(_0xa4868c){_0x2ab018=_0xa4868c[_0xbde1('0x56')];if(!_0x3efe07[_0xbde1('0x33')][_0xbde1('0x57')](_0xbde1('0x3a'))){_0x260dc2[_0xbde1('0x3b')]=qs['limit'](_0x3efe07['query']['limit']);_0x260dc2['offset']=qs[_0xbde1('0x24')](_0x3efe07['query'][_0xbde1('0x24')]);}return _0x1934fa[_0xbde1('0x53')](_0x260dc2);}})['then'](function(_0x321c77){if(_0x321c77){return _0x321c77?{'count':_0x2ab018,'rows':_0x321c77}:null;}})[_0xbde1('0x15')](respondWithResult(_0x30dcce,null))[_0xbde1('0x1f')](handleError(_0x30dcce,null));};exports[_0xbde1('0x58')]=function(_0x54556c,_0x4d22fb,_0x3dd9c4){var _0xd712c8={};var _0x1a931a={};var _0x14f0c4;var _0x98a4ac;return db['VtigerConfiguration'][_0xbde1('0x54')]({'where':{'id':_0x54556c[_0xbde1('0x4e')]['id']}})[_0xbde1('0x15')](handleEntityNotFound(_0x4d22fb,null))[_0xbde1('0x15')](function(_0xb0d70f){if(_0xb0d70f){_0x14f0c4=_0xb0d70f;_0x1a931a[_0xbde1('0x37')]=_[_0xbde1('0x32')](db[_0xbde1('0x55')]['rawAttributes']);_0x1a931a['query']=_[_0xbde1('0x32')](_0x54556c[_0xbde1('0x33')]);_0x1a931a[_0xbde1('0x3f')]=_['intersection'](_0x1a931a[_0xbde1('0x37')],_0x1a931a['query']);_0xd712c8[_0xbde1('0x38')]=_['intersection'](_0x1a931a[_0xbde1('0x37')],qs[_0xbde1('0x39')](_0x54556c[_0xbde1('0x33')]['fields']));_0xd712c8['attributes']=_0xd712c8[_0xbde1('0x38')][_0xbde1('0x56')]?_0xd712c8[_0xbde1('0x38')]:_0x1a931a[_0xbde1('0x37')];_0xd712c8[_0xbde1('0x3c')]=qs[_0xbde1('0x3d')](_0x54556c[_0xbde1('0x33')][_0xbde1('0x3d')]);_0xd712c8[_0xbde1('0x3e')]=qs[_0xbde1('0x3f')](_[_0xbde1('0x40')](_0x54556c[_0xbde1('0x33')],_0x1a931a['filters']));if(_0x54556c['query'][_0xbde1('0x44')]){_0xd712c8['where']=_[_0xbde1('0x43')](_0xd712c8[_0xbde1('0x3e')],{'$or':_[_0xbde1('0x45')](_0xd712c8[_0xbde1('0x38')],function(_0x3e23c6){var _0x49b282={};_0x49b282[_0x3e23c6]={'$like':'%'+_0x54556c['query'][_0xbde1('0x44')]+'%'};return _0x49b282;})});}_0xd712c8=_[_0xbde1('0x43')]({},_0xd712c8,_0x54556c['options']);return _0x14f0c4[_0xbde1('0x58')](_0xd712c8);}})[_0xbde1('0x15')](function(_0x472951){if(_0x472951){_0x98a4ac=_0x472951[_0xbde1('0x56')];if(!_0x54556c[_0xbde1('0x33')]['hasOwnProperty'](_0xbde1('0x3a'))){_0xd712c8[_0xbde1('0x3b')]=qs['limit'](_0x54556c['query'][_0xbde1('0x3b')]);_0xd712c8['offset']=qs[_0xbde1('0x24')](_0x54556c[_0xbde1('0x33')][_0xbde1('0x24')]);}return _0x14f0c4[_0xbde1('0x58')](_0xd712c8);}})[_0xbde1('0x15')](function(_0x3ecad2){if(_0x3ecad2){return _0x3ecad2?{'count':_0x98a4ac,'rows':_0x3ecad2}:null;}})[_0xbde1('0x15')](respondWithResult(_0x4d22fb,null))[_0xbde1('0x1f')](handleError(_0x4d22fb,null));};exports[_0xbde1('0x59')]=function(_0x2e8962,_0x26e2da,_0x339e5a){var _0x4436ad={};var _0x6b34df={};var _0x106c8a;var _0x1db2c4;return db[_0xbde1('0x30')][_0xbde1('0x54')]({'where':{'id':_0x2e8962['params']['id']}})['then'](handleEntityNotFound(_0x26e2da,null))[_0xbde1('0x15')](function(_0x53e380){if(_0x53e380){_0x106c8a=_0x53e380;_0x6b34df[_0xbde1('0x37')]=_[_0xbde1('0x32')](db[_0xbde1('0x55')][_0xbde1('0x31')]);_0x6b34df['query']=_['keys'](_0x2e8962[_0xbde1('0x33')]);_0x6b34df[_0xbde1('0x3f')]=_[_0xbde1('0x36')](_0x6b34df[_0xbde1('0x37')],_0x6b34df['query']);_0x4436ad[_0xbde1('0x38')]=_[_0xbde1('0x36')](_0x6b34df[_0xbde1('0x37')],qs[_0xbde1('0x39')](_0x2e8962[_0xbde1('0x33')]['fields']));_0x4436ad[_0xbde1('0x38')]=_0x4436ad[_0xbde1('0x38')]['length']?_0x4436ad[_0xbde1('0x38')]:_0x6b34df[_0xbde1('0x37')];_0x4436ad[_0xbde1('0x3c')]=qs['sort'](_0x2e8962['query'][_0xbde1('0x3d')]);_0x4436ad[_0xbde1('0x3e')]=qs['filters'](_[_0xbde1('0x40')](_0x2e8962[_0xbde1('0x33')],_0x6b34df[_0xbde1('0x3f')]));if(_0x2e8962[_0xbde1('0x33')][_0xbde1('0x44')]){_0x4436ad[_0xbde1('0x3e')]=_['merge'](_0x4436ad[_0xbde1('0x3e')],{'$or':_[_0xbde1('0x45')](_0x4436ad[_0xbde1('0x38')],function(_0x558521){var _0x11ef7f={};_0x11ef7f[_0x558521]={'$like':'%'+_0x2e8962[_0xbde1('0x33')][_0xbde1('0x44')]+'%'};return _0x11ef7f;})});}_0x4436ad=_[_0xbde1('0x43')]({},_0x4436ad,_0x2e8962[_0xbde1('0x49')]);return _0x106c8a[_0xbde1('0x59')](_0x4436ad);}})[_0xbde1('0x15')](function(_0xa2d9b2){if(_0xa2d9b2){_0x1db2c4=_0xa2d9b2[_0xbde1('0x56')];if(!_0x2e8962['query'][_0xbde1('0x57')](_0xbde1('0x3a'))){_0x4436ad['limit']=qs[_0xbde1('0x3b')](_0x2e8962[_0xbde1('0x33')]['limit']);_0x4436ad['offset']=qs[_0xbde1('0x24')](_0x2e8962[_0xbde1('0x33')][_0xbde1('0x24')]);}return _0x106c8a[_0xbde1('0x59')](_0x4436ad);}})['then'](function(_0x26f94c){if(_0x26f94c){return _0x26f94c?{'count':_0x1db2c4,'rows':_0x26f94c}:null;}})['then'](respondWithResult(_0x26e2da,null))[_0xbde1('0x1f')](handleError(_0x26e2da,null));};