Built motion from commit (unavailable).|2.4.19
[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 _0x67fd=['result','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','destroy','then','name','send','index','map','VtigerConfiguration','rawAttributes','fieldName','type','key','model','keys','query','intersection','attributes','length','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','includeAll','include','findAll','rows','show','fields','options','find','catch','create','body','update','params','findOne','VtigerField','merge','getFields','getSubjects','getDescriptions','html-pdf','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../mysqldb','jayson/promise','client','http','Sequelize','request','VtigerConfiguration,\x20%s,\x20%s','VtigerConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','message','info','request\x20sent'];(function(_0x27d2bf,_0x27ec74){var _0x5498a=function(_0x128d58){while(--_0x128d58){_0x27d2bf['push'](_0x27d2bf['shift']());}};_0x5498a(++_0x27ec74);}(_0x67fd,0x98));var _0xd67f=function(_0xe9787d,_0x5e8b54){_0xe9787d=_0xe9787d-0x0;var _0x2dd2d6=_0x67fd[_0xe9787d];return _0x2dd2d6;};'use strict';var pdf=require(_0xd67f('0x0'));var emlformat=require('eml-format');var rimraf=require(_0xd67f('0x1'));var zipdir=require(_0xd67f('0x2'));var jsonpatch=require(_0xd67f('0x3'));var rp=require(_0xd67f('0x4'));var moment=require(_0xd67f('0x5'));var BPromise=require(_0xd67f('0x6'));var Mustache=require(_0xd67f('0x7'));var util=require('util');var path=require(_0xd67f('0x8'));var sox=require(_0xd67f('0x9'));var csv=require(_0xd67f('0xa'));var ejs=require(_0xd67f('0xb'));var fs=require('fs');var _=require(_0xd67f('0xc'));var squel=require('squel');var crypto=require('crypto');var jsforce=require(_0xd67f('0xd'));var deskjs=require(_0xd67f('0xe'));var toCsv=require(_0xd67f('0xa'));var querystring=require(_0xd67f('0xf'));var Papa=require(_0xd67f('0x10'));var Redis=require(_0xd67f('0x11'));var authService=require(_0xd67f('0x12'));var qs=require(_0xd67f('0x13'));var as=require(_0xd67f('0x14'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xd67f('0x15'))(_0xd67f('0x16'));var utils=require(_0xd67f('0x17'));var config=require('../../config/environment');var db=require(_0xd67f('0x18'))['db'];var jayson=require(_0xd67f('0x19'));var client=jayson[_0xd67f('0x1a')][_0xd67f('0x1b')]({'port':0x232a});function checkPasswordPattern(_0x2d4c12,_0x49aa55,_0x33eda4){if(_0x33eda4){var _0x47bc29=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x47bc29['test'](_0x49aa55)){return _0x2d4c12;}else{throw new db[(_0xd67f('0x1c'))]['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~!@#$%^&-_=+[{]}.');}}else{return _0x2d4c12;}}function respondWithRpcPromise(_0x2e8c83,_0x4b08a5,_0x272bc7,_0x603e78){return new BPromise(function(_0x55bfcb,_0x3d265d){var _0x586c5a=_0x603e78||client;return _0x586c5a[_0xd67f('0x1d')](_0x2e8c83,_0x272bc7)['then'](function(_0x4daace){logger['info'](_0xd67f('0x1e'),_0x4b08a5,'request\x20sent');logger['debug'](_0xd67f('0x1f'),_0x4b08a5,'request\x20sent',JSON[_0xd67f('0x20')](_0x4daace));if(_0x4daace['error']){if(_0x4daace[_0xd67f('0x21')][_0xd67f('0x22')]===0x1f4){logger[_0xd67f('0x21')](_0xd67f('0x1e'),_0x4b08a5,_0x4daace[_0xd67f('0x21')]['message']);return _0x3d265d(_0x4daace[_0xd67f('0x21')]['message']);}logger[_0xd67f('0x21')](_0xd67f('0x1e'),_0x4b08a5,_0x4daace[_0xd67f('0x21')][_0xd67f('0x23')]);return _0x55bfcb(_0x4daace[_0xd67f('0x21')][_0xd67f('0x23')]);}else{logger[_0xd67f('0x24')]('VtigerConfiguration,\x20%s,\x20%s',_0x4b08a5,_0xd67f('0x25'));_0x55bfcb(_0x4daace[_0xd67f('0x26')]['message']);}})['catch'](function(_0x58c7c0){logger[_0xd67f('0x21')]('VtigerConfiguration,\x20%s,\x20%s',_0x4b08a5,_0x58c7c0);_0x3d265d(_0x58c7c0);});});}function respondWithStatusCode(_0x4f6197,_0x4a8781){_0x4a8781=_0x4a8781||0xcc;return function(_0x377d76){if(_0x377d76){return _0x4f6197[_0xd67f('0x27')](_0x4a8781);}return _0x4f6197[_0xd67f('0x28')](_0x4a8781)[_0xd67f('0x29')]();};}function respondWithResult(_0x3f8a27,_0x8099a0){_0x8099a0=_0x8099a0||0xc8;return function(_0xa14f4f){if(_0xa14f4f){return _0x3f8a27[_0xd67f('0x28')](_0x8099a0)[_0xd67f('0x2a')](_0xa14f4f);}};}function respondWithFilteredResult(_0x5b5545,_0x3aa824){return function(_0x34376a){if(_0x34376a){var _0x203cf5=_0x34376a[_0xd67f('0x2b')],_0x573bcf=_0x3aa824[_0xd67f('0x2c')],_0x1c7701=_0x3aa824[_0xd67f('0x2c')]+_0x3aa824[_0xd67f('0x2d')],_0x51e003;if(_0x1c7701>=_0x203cf5){_0x1c7701=_0x203cf5;_0x51e003=0xc8;}else{_0x51e003=0xce;}_0x5b5545[_0xd67f('0x28')](_0x51e003);return _0x5b5545[_0xd67f('0x2e')](_0xd67f('0x2f'),_0x573bcf+'-'+_0x1c7701+'/'+_0x203cf5)[_0xd67f('0x2a')](_0x34376a);}return null;};}function patchUpdates(_0x1dc9eb){return function(_0x3eb516){try{jsonpatch[_0xd67f('0x30')](_0x3eb516,_0x1dc9eb,!![]);}catch(_0x4ba44b){return BPromise[_0xd67f('0x31')](_0x4ba44b);}return _0x3eb516[_0xd67f('0x32')]();};}function saveUpdates(_0x1acf49,_0x3c148b){return function(_0x398724){if(_0x398724){return _0x398724['update'](_0x1acf49)['then'](function(_0x5f34cf){return _0x5f34cf;});}return null;};}function removeEntity(_0x5ab47b,_0x1cb105){return function(_0x1e50cb){if(_0x1e50cb){return _0x1e50cb[_0xd67f('0x33')]()[_0xd67f('0x34')](function(){_0x5ab47b['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x59070f,_0x30cda5){return function(_0x78581b){if(!_0x78581b){_0x59070f[_0xd67f('0x27')](0x194);}return _0x78581b;};}function handleError(_0x11c347,_0x4fd947){_0x4fd947=_0x4fd947||0x1f4;return function(_0x3e5a1d){logger['error'](_0x3e5a1d['stack']);if(_0x3e5a1d[_0xd67f('0x35')]){delete _0x3e5a1d[_0xd67f('0x35')];}_0x11c347[_0xd67f('0x28')](_0x4fd947)[_0xd67f('0x36')](_0x3e5a1d);};}exports[_0xd67f('0x37')]=function(_0x432002,_0x4417de){var _0x1e2070={},_0xbe4e97={},_0x12730c={'count':0x0,'rows':[]};var _0x9483f1=_[_0xd67f('0x38')](db[_0xd67f('0x39')][_0xd67f('0x3a')],function(_0x19ced1){return{'name':_0x19ced1[_0xd67f('0x3b')],'type':_0x19ced1[_0xd67f('0x3c')][_0xd67f('0x3d')]};});_0xbe4e97[_0xd67f('0x3e')]=_['map'](_0x9483f1,'name');_0xbe4e97['query']=_[_0xd67f('0x3f')](_0x432002[_0xd67f('0x40')]);_0xbe4e97['filters']=_[_0xd67f('0x41')](_0xbe4e97[_0xd67f('0x3e')],_0xbe4e97[_0xd67f('0x40')]);_0x1e2070[_0xd67f('0x42')]=_[_0xd67f('0x41')](_0xbe4e97[_0xd67f('0x3e')],qs['fields'](_0x432002[_0xd67f('0x40')]['fields']));_0x1e2070[_0xd67f('0x42')]=_0x1e2070[_0xd67f('0x42')][_0xd67f('0x43')]?_0x1e2070[_0xd67f('0x42')]:_0xbe4e97['model'];if(!_0x432002[_0xd67f('0x40')][_0xd67f('0x44')](_0xd67f('0x45'))){_0x1e2070[_0xd67f('0x2d')]=qs[_0xd67f('0x2d')](_0x432002[_0xd67f('0x40')][_0xd67f('0x2d')]);_0x1e2070['offset']=qs['offset'](_0x432002[_0xd67f('0x40')][_0xd67f('0x2c')]);}_0x1e2070[_0xd67f('0x46')]=qs[_0xd67f('0x47')](_0x432002[_0xd67f('0x40')]['sort']);_0x1e2070[_0xd67f('0x48')]=qs[_0xd67f('0x49')](_[_0xd67f('0x4a')](_0x432002['query'],_0xbe4e97[_0xd67f('0x49')]));if(_0x432002['query']['filter']){_0x1e2070['where']=_['merge'](_0x1e2070[_0xd67f('0x48')],{'$or':_[_0xd67f('0x38')](_0x9483f1,function(_0x3accaa){if(_0x3accaa[_0xd67f('0x3c')]!=='VIRTUAL'){var _0x579f85={};_0x579f85[_0x3accaa[_0xd67f('0x35')]]={'$like':'%'+_0x432002[_0xd67f('0x40')][_0xd67f('0x4b')]+'%'};return _0x579f85;}})});}_0x1e2070=_['merge']({},_0x1e2070,_0x432002['options']);var _0x59f392={'where':_0x1e2070[_0xd67f('0x48')]};return db[_0xd67f('0x39')][_0xd67f('0x2b')](_0x59f392)[_0xd67f('0x34')](function(_0x418bd0){_0x12730c['count']=_0x418bd0;if(_0x432002[_0xd67f('0x40')][_0xd67f('0x4c')]){_0x1e2070[_0xd67f('0x4d')]=[{'all':!![]}];}return db[_0xd67f('0x39')][_0xd67f('0x4e')](_0x1e2070);})[_0xd67f('0x34')](function(_0x3d15ec){_0x12730c[_0xd67f('0x4f')]=_0x3d15ec;return _0x12730c;})[_0xd67f('0x34')](respondWithFilteredResult(_0x4417de,_0x1e2070))['catch'](handleError(_0x4417de,null));};exports[_0xd67f('0x50')]=function(_0x3360a3,_0x4948b0){var _0x5bc58a={'raw':![],'where':{'id':_0x3360a3['params']['id']}},_0x4c2a44={};_0x4c2a44[_0xd67f('0x3e')]=_[_0xd67f('0x3f')](db[_0xd67f('0x39')][_0xd67f('0x3a')]);_0x4c2a44[_0xd67f('0x40')]=_[_0xd67f('0x3f')](_0x3360a3['query']);_0x4c2a44[_0xd67f('0x49')]=_[_0xd67f('0x41')](_0x4c2a44[_0xd67f('0x3e')],_0x4c2a44[_0xd67f('0x40')]);_0x5bc58a[_0xd67f('0x42')]=_[_0xd67f('0x41')](_0x4c2a44['model'],qs[_0xd67f('0x51')](_0x3360a3[_0xd67f('0x40')]['fields']));_0x5bc58a['attributes']=_0x5bc58a['attributes']['length']?_0x5bc58a[_0xd67f('0x42')]:_0x4c2a44[_0xd67f('0x3e')];if(_0x3360a3['query'][_0xd67f('0x4c')]){_0x5bc58a['include']=[{'all':!![]}];}_0x5bc58a=_['merge']({},_0x5bc58a,_0x3360a3[_0xd67f('0x52')]);return db[_0xd67f('0x39')][_0xd67f('0x53')](_0x5bc58a)['then'](handleEntityNotFound(_0x4948b0,null))[_0xd67f('0x34')](respondWithResult(_0x4948b0,null))[_0xd67f('0x54')](handleError(_0x4948b0,null));};exports[_0xd67f('0x55')]=function(_0x239d90,_0x2be6d4){return db[_0xd67f('0x39')]['create'](_0x239d90[_0xd67f('0x56')],{})[_0xd67f('0x34')](respondWithResult(_0x2be6d4,0xc9))[_0xd67f('0x54')](handleError(_0x2be6d4,null));};exports[_0xd67f('0x57')]=function(_0x31b1a0,_0x22db2a){if(_0x31b1a0[_0xd67f('0x56')]['id']){delete _0x31b1a0[_0xd67f('0x56')]['id'];}return db[_0xd67f('0x39')][_0xd67f('0x53')]({'where':{'id':_0x31b1a0['params']['id']}})[_0xd67f('0x34')](handleEntityNotFound(_0x22db2a,null))[_0xd67f('0x34')](saveUpdates(_0x31b1a0[_0xd67f('0x56')],null))[_0xd67f('0x34')](respondWithResult(_0x22db2a,null))[_0xd67f('0x54')](handleError(_0x22db2a,null));};exports[_0xd67f('0x33')]=function(_0x21eca0,_0x4b91c2){return db[_0xd67f('0x39')][_0xd67f('0x53')]({'where':{'id':_0x21eca0[_0xd67f('0x58')]['id']}})['then'](handleEntityNotFound(_0x4b91c2,null))['then'](removeEntity(_0x4b91c2,null))['catch'](handleError(_0x4b91c2,null));};exports['getFields']=function(_0x3b65c0,_0x410e2e,_0x45690a){var _0x1f939b={};var _0x1cbc55={};var _0x1859f2;var _0x1f40f0;return db[_0xd67f('0x39')][_0xd67f('0x59')]({'where':{'id':_0x3b65c0[_0xd67f('0x58')]['id']}})[_0xd67f('0x34')](handleEntityNotFound(_0x410e2e,null))['then'](function(_0x5cc4bf){if(_0x5cc4bf){_0x1859f2=_0x5cc4bf;_0x1cbc55['model']=_[_0xd67f('0x3f')](db[_0xd67f('0x5a')][_0xd67f('0x3a')]);_0x1cbc55[_0xd67f('0x40')]=_[_0xd67f('0x3f')](_0x3b65c0[_0xd67f('0x40')]);_0x1cbc55['filters']=_['intersection'](_0x1cbc55[_0xd67f('0x3e')],_0x1cbc55[_0xd67f('0x40')]);_0x1f939b[_0xd67f('0x42')]=_[_0xd67f('0x41')](_0x1cbc55[_0xd67f('0x3e')],qs[_0xd67f('0x51')](_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x51')]));_0x1f939b[_0xd67f('0x42')]=_0x1f939b[_0xd67f('0x42')]['length']?_0x1f939b[_0xd67f('0x42')]:_0x1cbc55[_0xd67f('0x3e')];_0x1f939b['order']=qs[_0xd67f('0x47')](_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x47')]);_0x1f939b[_0xd67f('0x48')]=qs[_0xd67f('0x49')](_[_0xd67f('0x4a')](_0x3b65c0['query'],_0x1cbc55[_0xd67f('0x49')]));if(_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x4b')]){_0x1f939b[_0xd67f('0x48')]=_['merge'](_0x1f939b[_0xd67f('0x48')],{'$or':_[_0xd67f('0x38')](_0x1f939b['attributes'],function(_0x4bd432){var _0x3c8846={};_0x3c8846[_0x4bd432]={'$like':'%'+_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x4b')]+'%'};return _0x3c8846;})});}_0x1f939b=_[_0xd67f('0x5b')]({},_0x1f939b,_0x3b65c0['options']);return _0x1859f2[_0xd67f('0x5c')](_0x1f939b);}})['then'](function(_0x5ac715){if(_0x5ac715){_0x1f40f0=_0x5ac715[_0xd67f('0x43')];if(!_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x44')](_0xd67f('0x45'))){_0x1f939b[_0xd67f('0x2d')]=qs[_0xd67f('0x2d')](_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x2d')]);_0x1f939b[_0xd67f('0x2c')]=qs[_0xd67f('0x2c')](_0x3b65c0[_0xd67f('0x40')][_0xd67f('0x2c')]);}return _0x1859f2[_0xd67f('0x5c')](_0x1f939b);}})[_0xd67f('0x34')](function(_0x5b2bd8){if(_0x5b2bd8){return _0x5b2bd8?{'count':_0x1f40f0,'rows':_0x5b2bd8}:null;}})[_0xd67f('0x34')](respondWithResult(_0x410e2e,null))['catch'](handleError(_0x410e2e,null));};exports['getSubjects']=function(_0x52bcfa,_0x18787c,_0x1ace10){var _0x198c70={};var _0x13fb6f={};var _0x5f0eb6;var _0x2d1fb6;return db[_0xd67f('0x39')][_0xd67f('0x59')]({'where':{'id':_0x52bcfa[_0xd67f('0x58')]['id']}})['then'](handleEntityNotFound(_0x18787c,null))[_0xd67f('0x34')](function(_0x2d7d08){if(_0x2d7d08){_0x5f0eb6=_0x2d7d08;_0x13fb6f[_0xd67f('0x3e')]=_[_0xd67f('0x3f')](db[_0xd67f('0x5a')][_0xd67f('0x3a')]);_0x13fb6f[_0xd67f('0x40')]=_['keys'](_0x52bcfa['query']);_0x13fb6f['filters']=_[_0xd67f('0x41')](_0x13fb6f['model'],_0x13fb6f[_0xd67f('0x40')]);_0x198c70[_0xd67f('0x42')]=_['intersection'](_0x13fb6f[_0xd67f('0x3e')],qs[_0xd67f('0x51')](_0x52bcfa['query'][_0xd67f('0x51')]));_0x198c70[_0xd67f('0x42')]=_0x198c70['attributes']['length']?_0x198c70[_0xd67f('0x42')]:_0x13fb6f[_0xd67f('0x3e')];_0x198c70['order']=qs[_0xd67f('0x47')](_0x52bcfa['query'][_0xd67f('0x47')]);_0x198c70['where']=qs['filters'](_['pick'](_0x52bcfa[_0xd67f('0x40')],_0x13fb6f[_0xd67f('0x49')]));if(_0x52bcfa[_0xd67f('0x40')][_0xd67f('0x4b')]){_0x198c70['where']=_[_0xd67f('0x5b')](_0x198c70['where'],{'$or':_[_0xd67f('0x38')](_0x198c70[_0xd67f('0x42')],function(_0xcef7c0){var _0x5500dc={};_0x5500dc[_0xcef7c0]={'$like':'%'+_0x52bcfa[_0xd67f('0x40')][_0xd67f('0x4b')]+'%'};return _0x5500dc;})});}_0x198c70=_['merge']({},_0x198c70,_0x52bcfa[_0xd67f('0x52')]);return _0x5f0eb6[_0xd67f('0x5d')](_0x198c70);}})['then'](function(_0x14b3ba){if(_0x14b3ba){_0x2d1fb6=_0x14b3ba[_0xd67f('0x43')];if(!_0x52bcfa[_0xd67f('0x40')][_0xd67f('0x44')]('nolimit')){_0x198c70[_0xd67f('0x2d')]=qs[_0xd67f('0x2d')](_0x52bcfa[_0xd67f('0x40')][_0xd67f('0x2d')]);_0x198c70['offset']=qs['offset'](_0x52bcfa[_0xd67f('0x40')]['offset']);}return _0x5f0eb6[_0xd67f('0x5d')](_0x198c70);}})[_0xd67f('0x34')](function(_0x107b05){if(_0x107b05){return _0x107b05?{'count':_0x2d1fb6,'rows':_0x107b05}:null;}})[_0xd67f('0x34')](respondWithResult(_0x18787c,null))[_0xd67f('0x54')](handleError(_0x18787c,null));};exports[_0xd67f('0x5e')]=function(_0xe7d392,_0x27ced6,_0x363ce3){var _0x216613={};var _0x186990={};var _0x4efd76;var _0xe8ec5a;return db[_0xd67f('0x39')][_0xd67f('0x59')]({'where':{'id':_0xe7d392['params']['id']}})[_0xd67f('0x34')](handleEntityNotFound(_0x27ced6,null))[_0xd67f('0x34')](function(_0x12904f){if(_0x12904f){_0x4efd76=_0x12904f;_0x186990[_0xd67f('0x3e')]=_[_0xd67f('0x3f')](db[_0xd67f('0x5a')][_0xd67f('0x3a')]);_0x186990[_0xd67f('0x40')]=_['keys'](_0xe7d392[_0xd67f('0x40')]);_0x186990[_0xd67f('0x49')]=_[_0xd67f('0x41')](_0x186990[_0xd67f('0x3e')],_0x186990[_0xd67f('0x40')]);_0x216613['attributes']=_[_0xd67f('0x41')](_0x186990['model'],qs[_0xd67f('0x51')](_0xe7d392['query'][_0xd67f('0x51')]));_0x216613['attributes']=_0x216613[_0xd67f('0x42')][_0xd67f('0x43')]?_0x216613[_0xd67f('0x42')]:_0x186990[_0xd67f('0x3e')];_0x216613[_0xd67f('0x46')]=qs['sort'](_0xe7d392[_0xd67f('0x40')]['sort']);_0x216613['where']=qs[_0xd67f('0x49')](_[_0xd67f('0x4a')](_0xe7d392['query'],_0x186990[_0xd67f('0x49')]));if(_0xe7d392[_0xd67f('0x40')][_0xd67f('0x4b')]){_0x216613[_0xd67f('0x48')]=_[_0xd67f('0x5b')](_0x216613[_0xd67f('0x48')],{'$or':_[_0xd67f('0x38')](_0x216613['attributes'],function(_0x8cb7c){var _0x523690={};_0x523690[_0x8cb7c]={'$like':'%'+_0xe7d392[_0xd67f('0x40')]['filter']+'%'};return _0x523690;})});}_0x216613=_[_0xd67f('0x5b')]({},_0x216613,_0xe7d392[_0xd67f('0x52')]);return _0x4efd76[_0xd67f('0x5e')](_0x216613);}})[_0xd67f('0x34')](function(_0x3133a6){if(_0x3133a6){_0xe8ec5a=_0x3133a6[_0xd67f('0x43')];if(!_0xe7d392['query'][_0xd67f('0x44')](_0xd67f('0x45'))){_0x216613[_0xd67f('0x2d')]=qs[_0xd67f('0x2d')](_0xe7d392[_0xd67f('0x40')][_0xd67f('0x2d')]);_0x216613[_0xd67f('0x2c')]=qs[_0xd67f('0x2c')](_0xe7d392[_0xd67f('0x40')]['offset']);}return _0x4efd76['getDescriptions'](_0x216613);}})[_0xd67f('0x34')](function(_0xc19e90){if(_0xc19e90){return _0xc19e90?{'count':_0xe8ec5a,'rows':_0xc19e90}:null;}})['then'](respondWithResult(_0x27ced6,null))[_0xd67f('0x54')](handleError(_0x27ced6,null));};