d8058c30cc2fa0abb46d68ffdd7f8be4ac059bbe
[motion2.git] / server / api / intDynamics365Configuration / intDynamics365Configuration.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 _0x97d2=['util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../mysqldb','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','info','request\x20sent','debug','Dynamics365Configuration,\x20%s,\x20%s,\x20%s','stringify','error','message','Dynamics365Configuration,\x20%s,\x20%s','result','catch','sendStatus','status','json','count','offset','limit','set','reject','update','then','destroy','end','stack','name','send','map','Dynamics365Configuration','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','hasOwnProperty','nolimit','sort','pick','where','merge','VIRTUAL','filter','options','includeAll','include','findAll','rows','params','length','find','create','body','getFields','findOne','Dynamics365Field','getSubjects','order','getDescriptions','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache'];(function(_0x3dd15e,_0x1f0015){var _0x231fd0=function(_0x4f680a){while(--_0x4f680a){_0x3dd15e['push'](_0x3dd15e['shift']());}};_0x231fd0(++_0x1f0015);}(_0x97d2,0x10d));var _0x297d=function(_0x4d16d7,_0x166fab){_0x4d16d7=_0x4d16d7-0x0;var _0x4ee235=_0x97d2[_0x4d16d7];return _0x4ee235;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x297d('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x297d('0x1'));var jsonpatch=require(_0x297d('0x2'));var rp=require(_0x297d('0x3'));var moment=require(_0x297d('0x4'));var BPromise=require(_0x297d('0x5'));var Mustache=require(_0x297d('0x6'));var util=require(_0x297d('0x7'));var path=require(_0x297d('0x8'));var sox=require(_0x297d('0x9'));var csv=require(_0x297d('0xa'));var ejs=require(_0x297d('0xb'));var fs=require('fs');var _=require(_0x297d('0xc'));var squel=require(_0x297d('0xd'));var crypto=require(_0x297d('0xe'));var jsforce=require(_0x297d('0xf'));var deskjs=require(_0x297d('0x10'));var toCsv=require(_0x297d('0xa'));var querystring=require('querystring');var Papa=require(_0x297d('0x11'));var Redis=require(_0x297d('0x12'));var authService=require('../../components/auth/service');var qs=require(_0x297d('0x13'));var as=require(_0x297d('0x14'));var hardwareService=require(_0x297d('0x15'));var logger=require('../../config/logger')('api');var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0x297d('0x16'))['db'];var jayson=require(_0x297d('0x17'));var client=jayson[_0x297d('0x18')][_0x297d('0x19')]({'port':0x232a});function checkPasswordPattern(_0x3a348e,_0x48de3e,_0x607158){if(_0x607158){var _0x24b3db=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x24b3db[_0x297d('0x1a')](_0x48de3e)){return _0x3a348e;}else{throw new db[(_0x297d('0x1b'))]['ValidationError'](_0x297d('0x1c'));}}else{return _0x3a348e;}}function respondWithRpcPromise(_0x215b0a,_0x10bd61,_0x5127d0,_0xe7d76a){return new BPromise(function(_0x2a0d5e,_0x4834de){var _0x48aa28=_0xe7d76a||client;return _0x48aa28[_0x297d('0x1d')](_0x215b0a,_0x5127d0)['then'](function(_0x7d8830){logger[_0x297d('0x1e')]('Dynamics365Configuration,\x20%s,\x20%s',_0x10bd61,_0x297d('0x1f'));logger[_0x297d('0x20')](_0x297d('0x21'),_0x10bd61,_0x297d('0x1f'),JSON[_0x297d('0x22')](_0x7d8830));if(_0x7d8830[_0x297d('0x23')]){if(_0x7d8830[_0x297d('0x23')]['code']===0x1f4){logger[_0x297d('0x23')]('Dynamics365Configuration,\x20%s,\x20%s',_0x10bd61,_0x7d8830['error'][_0x297d('0x24')]);return _0x4834de(_0x7d8830[_0x297d('0x23')][_0x297d('0x24')]);}logger[_0x297d('0x23')](_0x297d('0x25'),_0x10bd61,_0x7d8830[_0x297d('0x23')][_0x297d('0x24')]);return _0x2a0d5e(_0x7d8830[_0x297d('0x23')][_0x297d('0x24')]);}else{logger[_0x297d('0x1e')]('Dynamics365Configuration,\x20%s,\x20%s',_0x10bd61,_0x297d('0x1f'));_0x2a0d5e(_0x7d8830[_0x297d('0x26')]['message']);}})[_0x297d('0x27')](function(_0x4e3b53){logger['error'](_0x297d('0x25'),_0x10bd61,_0x4e3b53);_0x4834de(_0x4e3b53);});});}function respondWithStatusCode(_0x334628,_0x5c34dc){_0x5c34dc=_0x5c34dc||0xcc;return function(_0x877fc8){if(_0x877fc8){return _0x334628[_0x297d('0x28')](_0x5c34dc);}return _0x334628[_0x297d('0x29')](_0x5c34dc)['end']();};}function respondWithResult(_0x5cd576,_0x4e8195){_0x4e8195=_0x4e8195||0xc8;return function(_0x3bac89){if(_0x3bac89){return _0x5cd576['status'](_0x4e8195)[_0x297d('0x2a')](_0x3bac89);}};}function respondWithFilteredResult(_0x2eb665,_0x28c767){return function(_0x1e98ed){if(_0x1e98ed){var _0xacb907=_0x1e98ed[_0x297d('0x2b')],_0x567711=_0x28c767[_0x297d('0x2c')],_0x37c16d=_0x28c767['offset']+_0x28c767[_0x297d('0x2d')],_0x32b147;if(_0x37c16d>=_0xacb907){_0x37c16d=_0xacb907;_0x32b147=0xc8;}else{_0x32b147=0xce;}_0x2eb665['status'](_0x32b147);return _0x2eb665[_0x297d('0x2e')]('Content-Range',_0x567711+'-'+_0x37c16d+'/'+_0xacb907)[_0x297d('0x2a')](_0x1e98ed);}return null;};}function patchUpdates(_0x272457){return function(_0x42f291){try{jsonpatch['apply'](_0x42f291,_0x272457,!![]);}catch(_0x216fe7){return BPromise[_0x297d('0x2f')](_0x216fe7);}return _0x42f291['save']();};}function saveUpdates(_0x5b168f,_0x29dc43){return function(_0x2d1ed5){if(_0x2d1ed5){return _0x2d1ed5[_0x297d('0x30')](_0x5b168f)[_0x297d('0x31')](function(_0x4af62e){return _0x4af62e;});}return null;};}function removeEntity(_0x5be5f5,_0x521495){return function(_0x1ee50b){if(_0x1ee50b){return _0x1ee50b[_0x297d('0x32')]()['then'](function(){_0x5be5f5[_0x297d('0x29')](0xcc)[_0x297d('0x33')]();});}};}function handleEntityNotFound(_0x321b4b,_0x6ac1fe){return function(_0x24f035){if(!_0x24f035){_0x321b4b[_0x297d('0x28')](0x194);}return _0x24f035;};}function handleError(_0x5d29c4,_0x30e646){_0x30e646=_0x30e646||0x1f4;return function(_0x15905c){logger[_0x297d('0x23')](_0x15905c[_0x297d('0x34')]);if(_0x15905c[_0x297d('0x35')]){delete _0x15905c[_0x297d('0x35')];}_0x5d29c4[_0x297d('0x29')](_0x30e646)[_0x297d('0x36')](_0x15905c);};}exports['index']=function(_0x3d448a,_0x23752d){var _0x1ac15a={},_0x440ddf={},_0x40e68a={'count':0x0,'rows':[]};var _0x31e8c1=_[_0x297d('0x37')](db[_0x297d('0x38')][_0x297d('0x39')],function(_0x43a3c4){return{'name':_0x43a3c4[_0x297d('0x3a')],'type':_0x43a3c4[_0x297d('0x3b')][_0x297d('0x3c')]};});_0x440ddf[_0x297d('0x3d')]=_[_0x297d('0x37')](_0x31e8c1,'name');_0x440ddf[_0x297d('0x3e')]=_[_0x297d('0x3f')](_0x3d448a[_0x297d('0x3e')]);_0x440ddf[_0x297d('0x40')]=_[_0x297d('0x41')](_0x440ddf['model'],_0x440ddf[_0x297d('0x3e')]);_0x1ac15a[_0x297d('0x42')]=_[_0x297d('0x41')](_0x440ddf[_0x297d('0x3d')],qs[_0x297d('0x43')](_0x3d448a[_0x297d('0x3e')]['fields']));_0x1ac15a[_0x297d('0x42')]=_0x1ac15a[_0x297d('0x42')]['length']?_0x1ac15a[_0x297d('0x42')]:_0x440ddf[_0x297d('0x3d')];if(!_0x3d448a[_0x297d('0x3e')][_0x297d('0x44')](_0x297d('0x45'))){_0x1ac15a[_0x297d('0x2d')]=qs[_0x297d('0x2d')](_0x3d448a[_0x297d('0x3e')][_0x297d('0x2d')]);_0x1ac15a['offset']=qs[_0x297d('0x2c')](_0x3d448a[_0x297d('0x3e')][_0x297d('0x2c')]);}_0x1ac15a['order']=qs['sort'](_0x3d448a[_0x297d('0x3e')][_0x297d('0x46')]);_0x1ac15a['where']=qs[_0x297d('0x40')](_[_0x297d('0x47')](_0x3d448a['query'],_0x440ddf[_0x297d('0x40')]),_0x31e8c1);if(_0x3d448a[_0x297d('0x3e')]['filter']){_0x1ac15a[_0x297d('0x48')]=_[_0x297d('0x49')](_0x1ac15a[_0x297d('0x48')],{'$or':_[_0x297d('0x37')](_0x31e8c1,function(_0x1cbe45){if(_0x1cbe45['type']!==_0x297d('0x4a')){var _0x32d6a2={};_0x32d6a2[_0x1cbe45[_0x297d('0x35')]]={'$like':'%'+_0x3d448a[_0x297d('0x3e')][_0x297d('0x4b')]+'%'};return _0x32d6a2;}})});}_0x1ac15a=_[_0x297d('0x49')]({},_0x1ac15a,_0x3d448a[_0x297d('0x4c')]);var _0x356409={'where':_0x1ac15a[_0x297d('0x48')]};return db[_0x297d('0x38')][_0x297d('0x2b')](_0x356409)[_0x297d('0x31')](function(_0x345a1c){_0x40e68a['count']=_0x345a1c;if(_0x3d448a[_0x297d('0x3e')][_0x297d('0x4d')]){_0x1ac15a[_0x297d('0x4e')]=[{'all':!![]}];}return db[_0x297d('0x38')][_0x297d('0x4f')](_0x1ac15a);})[_0x297d('0x31')](function(_0x4fff71){_0x40e68a[_0x297d('0x50')]=_0x4fff71;return _0x40e68a;})[_0x297d('0x31')](respondWithFilteredResult(_0x23752d,_0x1ac15a))[_0x297d('0x27')](handleError(_0x23752d,null));};exports['show']=function(_0x5b963c,_0x9d7385){var _0x22385b={'raw':![],'where':{'id':_0x5b963c[_0x297d('0x51')]['id']}},_0x54a6da={};_0x54a6da['model']=_[_0x297d('0x3f')](db[_0x297d('0x38')][_0x297d('0x39')]);_0x54a6da[_0x297d('0x3e')]=_[_0x297d('0x3f')](_0x5b963c[_0x297d('0x3e')]);_0x54a6da[_0x297d('0x40')]=_['intersection'](_0x54a6da['model'],_0x54a6da['query']);_0x22385b['attributes']=_['intersection'](_0x54a6da['model'],qs[_0x297d('0x43')](_0x5b963c['query'][_0x297d('0x43')]));_0x22385b['attributes']=_0x22385b[_0x297d('0x42')][_0x297d('0x52')]?_0x22385b[_0x297d('0x42')]:_0x54a6da[_0x297d('0x3d')];if(_0x5b963c[_0x297d('0x3e')]['includeAll']){_0x22385b[_0x297d('0x4e')]=[{'all':!![]}];}_0x22385b=_[_0x297d('0x49')]({},_0x22385b,_0x5b963c['options']);return db[_0x297d('0x38')][_0x297d('0x53')](_0x22385b)['then'](handleEntityNotFound(_0x9d7385,null))[_0x297d('0x31')](respondWithResult(_0x9d7385,null))[_0x297d('0x27')](handleError(_0x9d7385,null));};exports[_0x297d('0x54')]=function(_0x7167f1,_0x35ce9b){return db['Dynamics365Configuration'][_0x297d('0x54')](_0x7167f1[_0x297d('0x55')],{})['then'](respondWithResult(_0x35ce9b,0xc9))[_0x297d('0x27')](handleError(_0x35ce9b,null));};exports['update']=function(_0x49d737,_0x45c6bd){if(_0x49d737[_0x297d('0x55')]['id']){delete _0x49d737[_0x297d('0x55')]['id'];}return db['Dynamics365Configuration'][_0x297d('0x53')]({'where':{'id':_0x49d737[_0x297d('0x51')]['id']}})['then'](handleEntityNotFound(_0x45c6bd,null))[_0x297d('0x31')](saveUpdates(_0x49d737['body'],null))[_0x297d('0x31')](respondWithResult(_0x45c6bd,null))[_0x297d('0x27')](handleError(_0x45c6bd,null));};exports[_0x297d('0x32')]=function(_0x51d18d,_0x24445f){return db[_0x297d('0x38')]['find']({'where':{'id':_0x51d18d[_0x297d('0x51')]['id']}})[_0x297d('0x31')](handleEntityNotFound(_0x24445f,null))[_0x297d('0x31')](removeEntity(_0x24445f,null))['catch'](handleError(_0x24445f,null));};exports[_0x297d('0x56')]=function(_0x251d7a,_0x212e96,_0x296f8d){var _0x3cae14={};var _0x2e78c6={};var _0x6138e;var _0x6af2c5;return db[_0x297d('0x38')][_0x297d('0x57')]({'where':{'id':_0x251d7a['params']['id']}})[_0x297d('0x31')](handleEntityNotFound(_0x212e96,null))['then'](function(_0x26c9bf){if(_0x26c9bf){_0x6138e=_0x26c9bf;_0x2e78c6[_0x297d('0x3d')]=_[_0x297d('0x3f')](db[_0x297d('0x58')]['rawAttributes']);_0x2e78c6['query']=_[_0x297d('0x3f')](_0x251d7a['query']);_0x2e78c6[_0x297d('0x40')]=_[_0x297d('0x41')](_0x2e78c6[_0x297d('0x3d')],_0x2e78c6[_0x297d('0x3e')]);_0x3cae14[_0x297d('0x42')]=_[_0x297d('0x41')](_0x2e78c6[_0x297d('0x3d')],qs['fields'](_0x251d7a[_0x297d('0x3e')]['fields']));_0x3cae14[_0x297d('0x42')]=_0x3cae14[_0x297d('0x42')][_0x297d('0x52')]?_0x3cae14[_0x297d('0x42')]:_0x2e78c6['model'];_0x3cae14['order']=qs['sort'](_0x251d7a[_0x297d('0x3e')][_0x297d('0x46')]);_0x3cae14[_0x297d('0x48')]=qs['filters'](_[_0x297d('0x47')](_0x251d7a[_0x297d('0x3e')],_0x2e78c6[_0x297d('0x40')]));if(_0x251d7a[_0x297d('0x3e')]['filter']){_0x3cae14[_0x297d('0x48')]=_['merge'](_0x3cae14[_0x297d('0x48')],{'$or':_[_0x297d('0x37')](_0x3cae14[_0x297d('0x42')],function(_0x4628ce){var _0x43ea6a={};_0x43ea6a[_0x4628ce]={'$like':'%'+_0x251d7a[_0x297d('0x3e')][_0x297d('0x4b')]+'%'};return _0x43ea6a;})});}_0x3cae14=_['merge']({},_0x3cae14,_0x251d7a[_0x297d('0x4c')]);return _0x6138e[_0x297d('0x56')](_0x3cae14);}})[_0x297d('0x31')](function(_0x20baa4){if(_0x20baa4){_0x6af2c5=_0x20baa4['length'];if(!_0x251d7a['query'][_0x297d('0x44')]('nolimit')){_0x3cae14[_0x297d('0x2d')]=qs[_0x297d('0x2d')](_0x251d7a['query'][_0x297d('0x2d')]);_0x3cae14['offset']=qs[_0x297d('0x2c')](_0x251d7a[_0x297d('0x3e')]['offset']);}return _0x6138e[_0x297d('0x56')](_0x3cae14);}})[_0x297d('0x31')](function(_0x4f77fb){if(_0x4f77fb){return _0x4f77fb?{'count':_0x6af2c5,'rows':_0x4f77fb}:null;}})[_0x297d('0x31')](respondWithResult(_0x212e96,null))[_0x297d('0x27')](handleError(_0x212e96,null));};exports[_0x297d('0x59')]=function(_0x2322f3,_0x4864e0,_0x303271){var _0x1a5f7a={};var _0x3ed9bf={};var _0x1ee3a0;var _0x13b806;return db[_0x297d('0x38')][_0x297d('0x57')]({'where':{'id':_0x2322f3['params']['id']}})[_0x297d('0x31')](handleEntityNotFound(_0x4864e0,null))[_0x297d('0x31')](function(_0x3d361f){if(_0x3d361f){_0x1ee3a0=_0x3d361f;_0x3ed9bf[_0x297d('0x3d')]=_[_0x297d('0x3f')](db[_0x297d('0x58')]['rawAttributes']);_0x3ed9bf['query']=_[_0x297d('0x3f')](_0x2322f3['query']);_0x3ed9bf[_0x297d('0x40')]=_['intersection'](_0x3ed9bf[_0x297d('0x3d')],_0x3ed9bf[_0x297d('0x3e')]);_0x1a5f7a[_0x297d('0x42')]=_[_0x297d('0x41')](_0x3ed9bf['model'],qs[_0x297d('0x43')](_0x2322f3['query']['fields']));_0x1a5f7a[_0x297d('0x42')]=_0x1a5f7a['attributes']['length']?_0x1a5f7a[_0x297d('0x42')]:_0x3ed9bf[_0x297d('0x3d')];_0x1a5f7a[_0x297d('0x5a')]=qs[_0x297d('0x46')](_0x2322f3[_0x297d('0x3e')][_0x297d('0x46')]);_0x1a5f7a[_0x297d('0x48')]=qs[_0x297d('0x40')](_[_0x297d('0x47')](_0x2322f3[_0x297d('0x3e')],_0x3ed9bf[_0x297d('0x40')]));if(_0x2322f3[_0x297d('0x3e')][_0x297d('0x4b')]){_0x1a5f7a['where']=_['merge'](_0x1a5f7a['where'],{'$or':_[_0x297d('0x37')](_0x1a5f7a[_0x297d('0x42')],function(_0x5e4700){var _0x39a69d={};_0x39a69d[_0x5e4700]={'$like':'%'+_0x2322f3['query'][_0x297d('0x4b')]+'%'};return _0x39a69d;})});}_0x1a5f7a=_[_0x297d('0x49')]({},_0x1a5f7a,_0x2322f3[_0x297d('0x4c')]);return _0x1ee3a0['getSubjects'](_0x1a5f7a);}})[_0x297d('0x31')](function(_0xdc96ac){if(_0xdc96ac){_0x13b806=_0xdc96ac[_0x297d('0x52')];if(!_0x2322f3[_0x297d('0x3e')][_0x297d('0x44')]('nolimit')){_0x1a5f7a[_0x297d('0x2d')]=qs[_0x297d('0x2d')](_0x2322f3[_0x297d('0x3e')][_0x297d('0x2d')]);_0x1a5f7a['offset']=qs[_0x297d('0x2c')](_0x2322f3[_0x297d('0x3e')][_0x297d('0x2c')]);}return _0x1ee3a0['getSubjects'](_0x1a5f7a);}})[_0x297d('0x31')](function(_0x5d51dc){if(_0x5d51dc){return _0x5d51dc?{'count':_0x13b806,'rows':_0x5d51dc}:null;}})['then'](respondWithResult(_0x4864e0,null))['catch'](handleError(_0x4864e0,null));};exports[_0x297d('0x5b')]=function(_0x1fbe4e,_0x40e480,_0x2c04d6){var _0x2d6a0e={};var _0x1c4b9b={};var _0x573403;var _0x31e112;return db[_0x297d('0x38')][_0x297d('0x57')]({'where':{'id':_0x1fbe4e['params']['id']}})[_0x297d('0x31')](handleEntityNotFound(_0x40e480,null))[_0x297d('0x31')](function(_0x2bca2a){if(_0x2bca2a){_0x573403=_0x2bca2a;_0x1c4b9b[_0x297d('0x3d')]=_['keys'](db[_0x297d('0x58')]['rawAttributes']);_0x1c4b9b[_0x297d('0x3e')]=_['keys'](_0x1fbe4e[_0x297d('0x3e')]);_0x1c4b9b[_0x297d('0x40')]=_[_0x297d('0x41')](_0x1c4b9b['model'],_0x1c4b9b[_0x297d('0x3e')]);_0x2d6a0e[_0x297d('0x42')]=_[_0x297d('0x41')](_0x1c4b9b[_0x297d('0x3d')],qs[_0x297d('0x43')](_0x1fbe4e['query'][_0x297d('0x43')]));_0x2d6a0e[_0x297d('0x42')]=_0x2d6a0e['attributes'][_0x297d('0x52')]?_0x2d6a0e[_0x297d('0x42')]:_0x1c4b9b['model'];_0x2d6a0e[_0x297d('0x5a')]=qs[_0x297d('0x46')](_0x1fbe4e['query'][_0x297d('0x46')]);_0x2d6a0e['where']=qs['filters'](_['pick'](_0x1fbe4e[_0x297d('0x3e')],_0x1c4b9b[_0x297d('0x40')]));if(_0x1fbe4e[_0x297d('0x3e')]['filter']){_0x2d6a0e[_0x297d('0x48')]=_['merge'](_0x2d6a0e[_0x297d('0x48')],{'$or':_['map'](_0x2d6a0e[_0x297d('0x42')],function(_0x267917){var _0x1bfcd6={};_0x1bfcd6[_0x267917]={'$like':'%'+_0x1fbe4e[_0x297d('0x3e')][_0x297d('0x4b')]+'%'};return _0x1bfcd6;})});}_0x2d6a0e=_[_0x297d('0x49')]({},_0x2d6a0e,_0x1fbe4e['options']);return _0x573403['getDescriptions'](_0x2d6a0e);}})[_0x297d('0x31')](function(_0xf67e89){if(_0xf67e89){_0x31e112=_0xf67e89[_0x297d('0x52')];if(!_0x1fbe4e[_0x297d('0x3e')][_0x297d('0x44')](_0x297d('0x45'))){_0x2d6a0e[_0x297d('0x2d')]=qs[_0x297d('0x2d')](_0x1fbe4e[_0x297d('0x3e')][_0x297d('0x2d')]);_0x2d6a0e[_0x297d('0x2c')]=qs['offset'](_0x1fbe4e['query']['offset']);}return _0x573403['getDescriptions'](_0x2d6a0e);}})[_0x297d('0x31')](function(_0x26d3ce){if(_0x26d3ce){return _0x26d3ce?{'count':_0x31e112,'rows':_0x26d3ce}:null;}})[_0x297d('0x31')](respondWithResult(_0x40e480,null))[_0x297d('0x27')](handleError(_0x40e480,null));};