97344f26aa9d15aba7fa1a13cff444c6e07b0b7e
[motion2.git] / server / api / chatGroup / chatGroup.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 _0x1708=['ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../mysqldb','redis','localhost','./chatGroup.socket','register','jayson/promise','client','test','ValidationError','request','then','info','ChatGroup,\x20%s,\x20%s','debug','ChatGroup,\x20%s,\x20%s,\x20%s','request\x20sent','stringify','code','error','message','catch','sendStatus','status','end','count','offset','limit','set','Content-Range','json','apply','save','update','destroy','stack','name','index','ChatGroup','rawAttributes','fieldName','type','key','model','map','query','keys','intersection','attributes','fields','hasOwnProperty','nolimit','order','sort','where','filters','pick','filter','VIRTUAL','merge','includeAll','include','findAll','rows','show','params','options','find','create','body','describe','ChatInternalMessage','user','toInteger','addMembers','ids','omit','getMembers','findOne','length','removeMembers','addMessage','ChatGroupId','getMessages','format','YYYY-MM-DD\x20HH:mm:ss','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','squel','crypto','jsforce','desk.js','querystring'];(function(_0x229e62,_0x1dd3b){var _0x5b86b1=function(_0x3df13e){while(--_0x3df13e){_0x229e62['push'](_0x229e62['shift']());}};_0x5b86b1(++_0x1dd3b);}(_0x1708,0xc5));var _0x8170=function(_0x3a8789,_0x5bb70b){_0x3a8789=_0x3a8789-0x0;var _0x19e422=_0x1708[_0x3a8789];return _0x19e422;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0x8170('0x0'));var rimraf=require('rimraf');var zipdir=require(_0x8170('0x1'));var jsonpatch=require(_0x8170('0x2'));var rp=require(_0x8170('0x3'));var moment=require(_0x8170('0x4'));var BPromise=require(_0x8170('0x5'));var Mustache=require(_0x8170('0x6'));var util=require(_0x8170('0x7'));var path=require('path');var sox=require(_0x8170('0x8'));var csv=require(_0x8170('0x9'));var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0x8170('0xa'));var crypto=require(_0x8170('0xb'));var jsforce=require(_0x8170('0xc'));var deskjs=require(_0x8170('0xd'));var toCsv=require(_0x8170('0x9'));var querystring=require(_0x8170('0xe'));var Papa=require('papaparse');var Redis=require(_0x8170('0xf'));var authService=require(_0x8170('0x10'));var qs=require(_0x8170('0x11'));var as=require(_0x8170('0x12'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x8170('0x13'))(_0x8170('0x14'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require(_0x8170('0x15'))['db'];config[_0x8170('0x16')]=_['defaults'](config[_0x8170('0x16')],{'host':_0x8170('0x17'),'port':0x18eb});var socket=require('socket.io-emitter')(new Redis(config[_0x8170('0x16')]));require(_0x8170('0x18'))[_0x8170('0x19')](socket);var jayson=require(_0x8170('0x1a'));var client=jayson[_0x8170('0x1b')]['http']({'port':0x232a});function checkPasswordPattern(_0x24875a,_0x4b5f0a,_0x119957){if(_0x119957){var _0x182d2d=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x182d2d[_0x8170('0x1c')](_0x4b5f0a)){return _0x24875a;}else{throw new db['Sequelize'][(_0x8170('0x1d'))]('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 _0x24875a;}}function respondWithRpcPromise(_0x506d0a,_0x3206dc,_0x24b189,_0x1058bc){return new BPromise(function(_0xffafee,_0x39cff9){var _0x4e8a0c=_0x1058bc||client;return _0x4e8a0c[_0x8170('0x1e')](_0x506d0a,_0x24b189)[_0x8170('0x1f')](function(_0xa1098a){logger[_0x8170('0x20')](_0x8170('0x21'),_0x3206dc,'request\x20sent');logger[_0x8170('0x22')](_0x8170('0x23'),_0x3206dc,_0x8170('0x24'),JSON[_0x8170('0x25')](_0xa1098a));if(_0xa1098a['error']){if(_0xa1098a['error'][_0x8170('0x26')]===0x1f4){logger['error'](_0x8170('0x21'),_0x3206dc,_0xa1098a[_0x8170('0x27')][_0x8170('0x28')]);return _0x39cff9(_0xa1098a[_0x8170('0x27')]['message']);}logger[_0x8170('0x27')]('ChatGroup,\x20%s,\x20%s',_0x3206dc,_0xa1098a['error']['message']);return _0xffafee(_0xa1098a[_0x8170('0x27')][_0x8170('0x28')]);}else{logger[_0x8170('0x20')]('ChatGroup,\x20%s,\x20%s',_0x3206dc,_0x8170('0x24'));_0xffafee(_0xa1098a['result']['message']);}})[_0x8170('0x29')](function(_0x5beeb7){logger['error'](_0x8170('0x21'),_0x3206dc,_0x5beeb7);_0x39cff9(_0x5beeb7);});});}function respondWithStatusCode(_0x56e8bc,_0x41d53c){_0x41d53c=_0x41d53c||0xcc;return function(_0x390860){if(_0x390860){return _0x56e8bc[_0x8170('0x2a')](_0x41d53c);}return _0x56e8bc[_0x8170('0x2b')](_0x41d53c)[_0x8170('0x2c')]();};}function respondWithResult(_0x2d5df3,_0x7e346d){_0x7e346d=_0x7e346d||0xc8;return function(_0x22e101){if(_0x22e101){return _0x2d5df3[_0x8170('0x2b')](_0x7e346d)['json'](_0x22e101);}};}function respondWithFilteredResult(_0x26c308,_0xf03c5f){return function(_0x283676){if(_0x283676){var _0x86e442=_0x283676[_0x8170('0x2d')],_0x2d5f12=_0xf03c5f['offset'],_0x67e68c=_0xf03c5f[_0x8170('0x2e')]+_0xf03c5f[_0x8170('0x2f')],_0x347af6;if(_0x67e68c>=_0x86e442){_0x67e68c=_0x86e442;_0x347af6=0xc8;}else{_0x347af6=0xce;}_0x26c308[_0x8170('0x2b')](_0x347af6);return _0x26c308[_0x8170('0x30')](_0x8170('0x31'),_0x2d5f12+'-'+_0x67e68c+'/'+_0x86e442)[_0x8170('0x32')](_0x283676);}return null;};}function patchUpdates(_0x22b0ef){return function(_0xfc11bd){try{jsonpatch[_0x8170('0x33')](_0xfc11bd,_0x22b0ef,!![]);}catch(_0x8ddbab){return BPromise['reject'](_0x8ddbab);}return _0xfc11bd[_0x8170('0x34')]();};}function saveUpdates(_0x21464d,_0x6a7638){return function(_0xca1b7a){if(_0xca1b7a){return _0xca1b7a[_0x8170('0x35')](_0x21464d)[_0x8170('0x1f')](function(_0x53fe4f){return _0x53fe4f;});}return null;};}function removeEntity(_0x2ebc8b,_0x10b971){return function(_0x4a963a){if(_0x4a963a){return _0x4a963a[_0x8170('0x36')]()[_0x8170('0x1f')](function(){_0x2ebc8b['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x204fcf,_0x4a47e9){return function(_0x5eca57){if(!_0x5eca57){_0x204fcf['sendStatus'](0x194);}return _0x5eca57;};}function handleError(_0x1c6082,_0x21280b){_0x21280b=_0x21280b||0x1f4;return function(_0x2ed6cc){logger['error'](_0x2ed6cc[_0x8170('0x37')]);if(_0x2ed6cc[_0x8170('0x38')]){delete _0x2ed6cc['name'];}_0x1c6082[_0x8170('0x2b')](_0x21280b)['send'](_0x2ed6cc);};}exports[_0x8170('0x39')]=function(_0xb7e881,_0x4094b6){var _0x5beabf={},_0x173095={},_0x49a8d1={'count':0x0,'rows':[]};var _0x54ad22=_['map'](db[_0x8170('0x3a')][_0x8170('0x3b')],function(_0x4277d6){return{'name':_0x4277d6[_0x8170('0x3c')],'type':_0x4277d6[_0x8170('0x3d')][_0x8170('0x3e')]};});_0x173095[_0x8170('0x3f')]=_[_0x8170('0x40')](_0x54ad22,_0x8170('0x38'));_0x173095[_0x8170('0x41')]=_[_0x8170('0x42')](_0xb7e881[_0x8170('0x41')]);_0x173095['filters']=_[_0x8170('0x43')](_0x173095['model'],_0x173095['query']);_0x5beabf[_0x8170('0x44')]=_[_0x8170('0x43')](_0x173095[_0x8170('0x3f')],qs['fields'](_0xb7e881['query'][_0x8170('0x45')]));_0x5beabf[_0x8170('0x44')]=_0x5beabf[_0x8170('0x44')]['length']?_0x5beabf[_0x8170('0x44')]:_0x173095[_0x8170('0x3f')];if(!_0xb7e881[_0x8170('0x41')][_0x8170('0x46')](_0x8170('0x47'))){_0x5beabf[_0x8170('0x2f')]=qs[_0x8170('0x2f')](_0xb7e881['query']['limit']);_0x5beabf['offset']=qs[_0x8170('0x2e')](_0xb7e881['query'][_0x8170('0x2e')]);}_0x5beabf[_0x8170('0x48')]=qs[_0x8170('0x49')](_0xb7e881[_0x8170('0x41')][_0x8170('0x49')]);_0x5beabf[_0x8170('0x4a')]=qs[_0x8170('0x4b')](_[_0x8170('0x4c')](_0xb7e881[_0x8170('0x41')],_0x173095[_0x8170('0x4b')]),_0x54ad22);if(_0xb7e881[_0x8170('0x41')][_0x8170('0x4d')]){_0x5beabf[_0x8170('0x4a')]=_['merge'](_0x5beabf['where'],{'$or':_[_0x8170('0x40')](_0x54ad22,function(_0xf436b9){if(_0xf436b9['type']!==_0x8170('0x4e')){var _0x3ee396={};_0x3ee396[_0xf436b9[_0x8170('0x38')]]={'$like':'%'+_0xb7e881[_0x8170('0x41')]['filter']+'%'};return _0x3ee396;}})});}_0x5beabf=_[_0x8170('0x4f')]({},_0x5beabf,_0xb7e881['options']);var _0x487590={'where':_0x5beabf['where']};return db['ChatGroup']['count'](_0x487590)[_0x8170('0x1f')](function(_0x1f4756){_0x49a8d1[_0x8170('0x2d')]=_0x1f4756;if(_0xb7e881[_0x8170('0x41')][_0x8170('0x50')]){_0x5beabf[_0x8170('0x51')]=[{'all':!![]}];}return db['ChatGroup'][_0x8170('0x52')](_0x5beabf);})['then'](function(_0x3f9a25){_0x49a8d1[_0x8170('0x53')]=_0x3f9a25;return _0x49a8d1;})[_0x8170('0x1f')](respondWithFilteredResult(_0x4094b6,_0x5beabf))[_0x8170('0x29')](handleError(_0x4094b6,null));};exports[_0x8170('0x54')]=function(_0x2b88c7,_0x5a00df){var _0x53cf06={'raw':!![],'where':{'id':_0x2b88c7[_0x8170('0x55')]['id']}},_0x57b62d={};_0x57b62d['model']=_[_0x8170('0x42')](db[_0x8170('0x3a')][_0x8170('0x3b')]);_0x57b62d['query']=_[_0x8170('0x42')](_0x2b88c7[_0x8170('0x41')]);_0x57b62d[_0x8170('0x4b')]=_[_0x8170('0x43')](_0x57b62d[_0x8170('0x3f')],_0x57b62d[_0x8170('0x41')]);_0x53cf06[_0x8170('0x44')]=_['intersection'](_0x57b62d['model'],qs['fields'](_0x2b88c7[_0x8170('0x41')][_0x8170('0x45')]));_0x53cf06['attributes']=_0x53cf06[_0x8170('0x44')]['length']?_0x53cf06[_0x8170('0x44')]:_0x57b62d['model'];if(_0x2b88c7[_0x8170('0x41')]['includeAll']){_0x53cf06[_0x8170('0x51')]=[{'all':!![]}];}_0x53cf06=_['merge']({},_0x53cf06,_0x2b88c7[_0x8170('0x56')]);return db['ChatGroup'][_0x8170('0x57')](_0x53cf06)[_0x8170('0x1f')](handleEntityNotFound(_0x5a00df,null))[_0x8170('0x1f')](respondWithResult(_0x5a00df,null))[_0x8170('0x29')](handleError(_0x5a00df,null));};exports[_0x8170('0x58')]=function(_0x19664b,_0x21f0fc){return db['ChatGroup'][_0x8170('0x58')](_0x19664b[_0x8170('0x59')],{})['then'](respondWithResult(_0x21f0fc,0xc9))[_0x8170('0x29')](handleError(_0x21f0fc,null));};exports['update']=function(_0x9d2528,_0x3cc041){if(_0x9d2528['body']['id']){delete _0x9d2528[_0x8170('0x59')]['id'];}return db[_0x8170('0x3a')][_0x8170('0x57')]({'where':{'id':_0x9d2528['params']['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x3cc041,null))[_0x8170('0x1f')](saveUpdates(_0x9d2528[_0x8170('0x59')],null))[_0x8170('0x1f')](respondWithResult(_0x3cc041,null))[_0x8170('0x29')](handleError(_0x3cc041,null));};exports[_0x8170('0x36')]=function(_0x44abcf,_0x40e887){return db[_0x8170('0x3a')][_0x8170('0x57')]({'where':{'id':_0x44abcf[_0x8170('0x55')]['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x40e887,null))[_0x8170('0x1f')](removeEntity(_0x40e887,null))[_0x8170('0x29')](handleError(_0x40e887,null));};exports[_0x8170('0x5a')]=function(_0x3bd39f,_0x140da0){return db[_0x8170('0x3a')][_0x8170('0x5a')]()[_0x8170('0x1f')](respondWithResult(_0x140da0,null))[_0x8170('0x29')](handleError(_0x140da0,null));};exports['getUnread']=function(_0x1ee062,_0x4595d4,_0x35694c){return db[_0x8170('0x5b')][_0x8170('0x2d')]({'where':{'ChatGroupId':_0x1ee062[_0x8170('0x55')]['id'],'ToId':_0x1ee062[_0x8170('0x5c')]['id'],'read':![]}})['then'](function(_0x324041){return{'id':_[_0x8170('0x5d')](_0x1ee062[_0x8170('0x55')]['id']),'count':_0x324041};})[_0x8170('0x1f')](respondWithResult(_0x4595d4,null))['catch'](handleError(_0x4595d4,null));};exports[_0x8170('0x5e')]=function(_0x3e1776,_0x2331e2,_0x599d2f){return db[_0x8170('0x3a')][_0x8170('0x57')]({'where':{'id':_0x3e1776[_0x8170('0x55')]['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x2331e2,null))[_0x8170('0x1f')](function(_0x1be4b6){if(_0x1be4b6){return _0x1be4b6[_0x8170('0x5e')](_0x3e1776[_0x8170('0x59')][_0x8170('0x5f')],_[_0x8170('0x60')](_0x3e1776[_0x8170('0x59')],[_0x8170('0x5f'),'id'])||{});}})[_0x8170('0x1f')](respondWithResult(_0x2331e2,null))[_0x8170('0x29')](handleError(_0x2331e2,null));};exports[_0x8170('0x61')]=function(_0x2c6f9a,_0x48e536,_0x55a74a){var _0x41b220={};var _0x572687={};var _0x2c703a;var _0x3906f8;return db[_0x8170('0x3a')][_0x8170('0x62')]({'where':{'id':_0x2c6f9a[_0x8170('0x55')]['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x48e536,null))['then'](function(_0x3b7976){if(_0x3b7976){_0x2c703a=_0x3b7976;_0x572687['model']=_[_0x8170('0x42')](db['User'][_0x8170('0x3b')]);_0x572687[_0x8170('0x41')]=_['keys'](_0x2c6f9a[_0x8170('0x41')]);_0x572687[_0x8170('0x4b')]=_[_0x8170('0x43')](_0x572687['model'],_0x572687[_0x8170('0x41')]);_0x41b220['attributes']=_[_0x8170('0x43')](_0x572687[_0x8170('0x3f')],qs[_0x8170('0x45')](_0x2c6f9a[_0x8170('0x41')][_0x8170('0x45')]));_0x41b220[_0x8170('0x44')]=_0x41b220[_0x8170('0x44')][_0x8170('0x63')]?_0x41b220[_0x8170('0x44')]:_0x572687[_0x8170('0x3f')];_0x41b220['order']=qs[_0x8170('0x49')](_0x2c6f9a[_0x8170('0x41')][_0x8170('0x49')]);_0x41b220['where']=qs[_0x8170('0x4b')](_[_0x8170('0x4c')](_0x2c6f9a[_0x8170('0x41')],_0x572687[_0x8170('0x4b')]));if(_0x2c6f9a[_0x8170('0x41')]['filter']){_0x41b220['where']=_[_0x8170('0x4f')](_0x41b220[_0x8170('0x4a')],{'$or':_['map'](_0x41b220['attributes'],function(_0x72dda5){var _0x4932bb={};_0x4932bb[_0x72dda5]={'$like':'%'+_0x2c6f9a[_0x8170('0x41')][_0x8170('0x4d')]+'%'};return _0x4932bb;})});}_0x41b220=_[_0x8170('0x4f')]({},_0x41b220,_0x2c6f9a[_0x8170('0x56')]);return _0x2c703a[_0x8170('0x61')](_0x41b220);}})[_0x8170('0x1f')](function(_0x3c3cb8){if(_0x3c3cb8){_0x3906f8=_0x3c3cb8[_0x8170('0x63')];if(!_0x2c6f9a[_0x8170('0x41')][_0x8170('0x46')](_0x8170('0x47'))){_0x41b220[_0x8170('0x2f')]=qs[_0x8170('0x2f')](_0x2c6f9a['query'][_0x8170('0x2f')]);_0x41b220[_0x8170('0x2e')]=qs[_0x8170('0x2e')](_0x2c6f9a[_0x8170('0x41')][_0x8170('0x2e')]);}return _0x2c703a[_0x8170('0x61')](_0x41b220);}})[_0x8170('0x1f')](function(_0x547407){if(_0x547407){return _0x547407?{'count':_0x3906f8,'rows':_0x547407}:null;}})[_0x8170('0x1f')](respondWithResult(_0x48e536,null))['catch'](handleError(_0x48e536,null));};exports['removeMembers']=function(_0x49e3fd,_0x3314dd,_0x4977be){return db[_0x8170('0x3a')][_0x8170('0x57')]({'where':{'id':_0x49e3fd['params']['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x3314dd,null))[_0x8170('0x1f')](function(_0x33b005){if(_0x33b005){return _0x33b005[_0x8170('0x64')](_0x49e3fd[_0x8170('0x41')][_0x8170('0x5f')]);}})[_0x8170('0x1f')](respondWithStatusCode(_0x3314dd,null))['catch'](handleError(_0x3314dd,null));};exports[_0x8170('0x65')]=function(_0x5c3744,_0x21cb8e,_0x13cd77){if(_0x5c3744['body']['id']){delete _0x5c3744['body']['id'];}return db[_0x8170('0x3a')][_0x8170('0x57')]({'where':{'id':_0x5c3744[_0x8170('0x55')]['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x21cb8e,null))[_0x8170('0x1f')](function(_0x4782f0){if(_0x4782f0){_0x5c3744[_0x8170('0x59')][_0x8170('0x66')]=_0x4782f0['id'];return db[_0x8170('0x5b')][_0x8170('0x58')](_0x5c3744[_0x8170('0x59')]);}})[_0x8170('0x1f')](respondWithResult(_0x21cb8e,null))[_0x8170('0x29')](handleError(_0x21cb8e,null));};exports[_0x8170('0x67')]=function(_0x197a76,_0x38c278,_0x26a89e){var _0x13c392={};var _0xf8b468={};var _0x56ba41;var _0x44f061;return db[_0x8170('0x3a')]['findOne']({'where':{'id':_0x197a76['params']['id']}})[_0x8170('0x1f')](handleEntityNotFound(_0x38c278,null))[_0x8170('0x1f')](function(_0x23380a){if(_0x23380a){_0x56ba41=_0x23380a;_0xf8b468['model']=_[_0x8170('0x42')](db[_0x8170('0x5b')]['rawAttributes']);_0xf8b468[_0x8170('0x41')]=_[_0x8170('0x42')](_0x197a76[_0x8170('0x41')]);_0xf8b468[_0x8170('0x4b')]=_[_0x8170('0x43')](_0xf8b468['model'],_0xf8b468['query']);_0x13c392['attributes']=_[_0x8170('0x43')](_0xf8b468[_0x8170('0x3f')],qs[_0x8170('0x45')](_0x197a76[_0x8170('0x41')][_0x8170('0x45')]));_0x13c392['attributes']=_0x13c392[_0x8170('0x44')][_0x8170('0x63')]?_0x13c392[_0x8170('0x44')]:_0xf8b468['model'];_0x13c392[_0x8170('0x48')]=qs[_0x8170('0x49')](_0x197a76[_0x8170('0x41')][_0x8170('0x49')]);_0x13c392[_0x8170('0x4a')]=qs[_0x8170('0x4b')](_['pick'](_0x197a76[_0x8170('0x41')],_0xf8b468['filters']));if(_0x197a76[_0x8170('0x41')][_0x8170('0x4d')]){_0x13c392['where']=_[_0x8170('0x4f')](_0x13c392[_0x8170('0x4a')],{'$or':_[_0x8170('0x40')](_0x13c392[_0x8170('0x44')],function(_0x12ebdb){var _0xfd0e6e={};_0xfd0e6e[_0x12ebdb]={'$like':'%'+_0x197a76[_0x8170('0x41')][_0x8170('0x4d')]+'%'};return _0xfd0e6e;})});}if(_0x197a76['query']['$gte']){var _0x975d95=_0x197a76[_0x8170('0x41')]['$gte']['split'](',');var _0xf44dae={};_0xf44dae[_0x975d95[0x0]]={'$gte':moment(_0x975d95[0x1])[_0x8170('0x68')](_0x8170('0x69'))};_0x13c392[_0x8170('0x4a')]=_[_0x8170('0x4f')](_0x13c392['where'],_0xf44dae);}_0x13c392=_[_0x8170('0x4f')]({},_0x13c392,_0x197a76[_0x8170('0x56')]);return _0x56ba41['getMessages'](_0x13c392);}})[_0x8170('0x1f')](function(_0x222b12){if(_0x222b12){_0x44f061=_0x222b12[_0x8170('0x63')];if(!_0x197a76['query'][_0x8170('0x46')](_0x8170('0x47'))){_0x13c392[_0x8170('0x2f')]=qs[_0x8170('0x2f')](_0x197a76[_0x8170('0x41')][_0x8170('0x2f')]);_0x13c392[_0x8170('0x2e')]=qs[_0x8170('0x2e')](_0x197a76['query']['offset']);}return _0x56ba41[_0x8170('0x67')](_0x13c392);}})[_0x8170('0x1f')](function(_0x256e69){if(_0x256e69){return _0x256e69?{'count':_0x44f061,'rows':_0x256e69}:null;}})['then'](respondWithResult(_0x38c278,null))['catch'](handleError(_0x38c278,null));};