[motion2.git] / server / api / intFreshdeskConfiguration / intFreshdeskConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x4d14=['getFields','FreshdeskField','getSubjects','findOne','getDescriptions','Tag','getTags','setTags','rimraf','fast-json-patch','request-promise','moment','bluebird','mustache','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/environment','../../mysqldb','sendStatus','end','status','limit','undefined','offset','count','set','Content-Range','json','apply','save','then','destroy','stack','name','send','index','map','FreshdeskConfiguration','rawAttributes','fieldName','type','key','model','query','keys','intersection','fields','attributes','length','hasOwnProperty','nolimit','order','sort','pick','filters','filter','where','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','create','body','find','params'];(function(_0x5c6e79,_0x5e3dc8){var _0x4fdfda=function(_0x128163){while(--_0x128163){_0x5c6e79['push'](_0x5c6e79['shift']());}};_0x4fdfda(++_0x5e3dc8);}(_0x4d14,0xaa));var _0x44d1=function(_0x1a7846,_0x59723e){_0x1a7846=_0x1a7846-0x0;var _0x48049=_0x4d14[_0x1a7846];return _0x48049;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x44d1('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x44d1('0x1'));var rp=require(_0x44d1('0x2'));var moment=require(_0x44d1('0x3'));var BPromise=require(_0x44d1('0x4'));var Mustache=require(_0x44d1('0x5'));var util=require(_0x44d1('0x6'));var path=require('path');var sox=require(_0x44d1('0x7'));var csv=require(_0x44d1('0x8'));var ejs=require(_0x44d1('0x9'));var fs=require('fs');var fs_extra=require(_0x44d1('0xa'));var _=require(_0x44d1('0xb'));var squel=require(_0x44d1('0xc'));var crypto=require(_0x44d1('0xd'));var jsforce=require(_0x44d1('0xe'));var deskjs=require(_0x44d1('0xf'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require('papaparse');var Redis=require('ioredis');var authService=require(_0x44d1('0x10'));var qs=require('../../components/parsers/qs');var as=require(_0x44d1('0x11'));var hardwareService=require(_0x44d1('0x12'));var logger=require(_0x44d1('0x13'))('api');var utils=require('../../config/utils');var config=require(_0x44d1('0x14'));var licenseUtil=require('../../config/license/util');var db=require(_0x44d1('0x15'))['db'];function respondWithStatusCode(_0x54508b,_0xb4bb3b){_0xb4bb3b=_0xb4bb3b||0xcc;return function(_0x27915b){if(_0x27915b){return _0x54508b[_0x44d1('0x16')](_0xb4bb3b);}return _0x54508b['status'](_0xb4bb3b)[_0x44d1('0x17')]();};}function respondWithResult(_0x3164e0,_0x3b9eb8){_0x3b9eb8=_0x3b9eb8||0xc8;return function(_0x53fee7){if(_0x53fee7){return _0x3164e0[_0x44d1('0x18')](_0x3b9eb8)['json'](_0x53fee7);}};}function respondWithFilteredResult(_0x5828eb,_0x2704a2){return function(_0x512d70){if(_0x512d70){var _0x5709d9=typeof _0x2704a2['offset']==='undefined'&&typeof _0x2704a2[_0x44d1('0x19')]===_0x44d1('0x1a');var _0x405ba8=_0x512d70['count'];var _0x828170=_0x5709d9?0x0:_0x2704a2[_0x44d1('0x1b')];var _0x4c07c9=_0x5709d9?_0x512d70[_0x44d1('0x1c')]:_0x2704a2[_0x44d1('0x1b')]+_0x2704a2['limit'];var _0x2b4b72;if(_0x4c07c9>=_0x405ba8){_0x4c07c9=_0x405ba8;_0x2b4b72=0xc8;}else{_0x2b4b72=0xce;}_0x5828eb[_0x44d1('0x18')](_0x2b4b72);return _0x5828eb[_0x44d1('0x1d')](_0x44d1('0x1e'),_0x828170+'-'+_0x4c07c9+'/'+_0x405ba8)[_0x44d1('0x1f')](_0x512d70);}return null;};}function patchUpdates(_0xc4e532){return function(_0xe4e887){try{jsonpatch[_0x44d1('0x20')](_0xe4e887,_0xc4e532,!![]);}catch(_0x339b46){return BPromise['reject'](_0x339b46);}return _0xe4e887[_0x44d1('0x21')]();};}function saveUpdates(_0x20ea5e,_0x421e7a){return function(_0x29c8f3){if(_0x29c8f3){return _0x29c8f3['update'](_0x20ea5e)[_0x44d1('0x22')](function(_0x3d398d){return _0x3d398d;});}return null;};}function removeEntity(_0x24ae10,_0x4f05a4){return function(_0x19f6d0){if(_0x19f6d0){return _0x19f6d0[_0x44d1('0x23')]()['then'](function(){_0x24ae10[_0x44d1('0x18')](0xcc)[_0x44d1('0x17')]();});}};}function handleEntityNotFound(_0x39e014,_0x5338d4){return function(_0x76f8f2){if(!_0x76f8f2){_0x39e014[_0x44d1('0x16')](0x194);}return _0x76f8f2;};}function handleError(_0x389181,_0x1ceaa5){_0x1ceaa5=_0x1ceaa5||0x1f4;return function(_0x1b65f7){logger['error'](_0x1b65f7[_0x44d1('0x24')]);if(_0x1b65f7['name']){delete _0x1b65f7[_0x44d1('0x25')];}_0x389181['status'](_0x1ceaa5)[_0x44d1('0x26')](_0x1b65f7);};}exports[_0x44d1('0x27')]=function(_0x3176ff,_0x410208){var _0x41efc0={},_0x3080f1={},_0x17a77b={'count':0x0,'rows':[]};var _0x24b463=_[_0x44d1('0x28')](db[_0x44d1('0x29')][_0x44d1('0x2a')],function(_0x55c830){return{'name':_0x55c830[_0x44d1('0x2b')],'type':_0x55c830[_0x44d1('0x2c')][_0x44d1('0x2d')]};});_0x3080f1[_0x44d1('0x2e')]=_['map'](_0x24b463,_0x44d1('0x25'));_0x3080f1[_0x44d1('0x2f')]=_[_0x44d1('0x30')](_0x3176ff[_0x44d1('0x2f')]);_0x3080f1['filters']=_[_0x44d1('0x31')](_0x3080f1['model'],_0x3080f1[_0x44d1('0x2f')]);_0x41efc0['attributes']=_[_0x44d1('0x31')](_0x3080f1[_0x44d1('0x2e')],qs[_0x44d1('0x32')](_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x32')]));_0x41efc0[_0x44d1('0x33')]=_0x41efc0[_0x44d1('0x33')][_0x44d1('0x34')]?_0x41efc0['attributes']:_0x3080f1['model'];if(!_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x35')](_0x44d1('0x36'))){_0x41efc0[_0x44d1('0x19')]=qs[_0x44d1('0x19')](_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x19')]);_0x41efc0['offset']=qs[_0x44d1('0x1b')](_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x1b')]);}_0x41efc0[_0x44d1('0x37')]=qs[_0x44d1('0x38')](_0x3176ff['query'][_0x44d1('0x38')]);_0x41efc0['where']=qs['filters'](_[_0x44d1('0x39')](_0x3176ff[_0x44d1('0x2f')],_0x3080f1[_0x44d1('0x3a')]),_0x24b463);if(_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x3b')]){_0x41efc0[_0x44d1('0x3c')]=_[_0x44d1('0x3d')](_0x41efc0['where'],{'$or':_['map'](_0x24b463,function(_0x1a9e9d){if(_0x1a9e9d[_0x44d1('0x2c')]!==_0x44d1('0x3e')){var _0x2a1438={};_0x2a1438[_0x1a9e9d[_0x44d1('0x25')]]={'$like':'%'+_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x3b')]+'%'};return _0x2a1438;}})});}_0x41efc0=_['merge']({},_0x41efc0,_0x3176ff[_0x44d1('0x3f')]);var _0x21d081={'where':_0x41efc0[_0x44d1('0x3c')]};return db[_0x44d1('0x29')][_0x44d1('0x1c')](_0x21d081)[_0x44d1('0x22')](function(_0x32f5e0){_0x17a77b['count']=_0x32f5e0;if(_0x3176ff[_0x44d1('0x2f')][_0x44d1('0x40')]){_0x41efc0[_0x44d1('0x41')]=[{'all':!![]}];}return db[_0x44d1('0x29')][_0x44d1('0x42')](_0x41efc0);})['then'](function(_0x1a2aac){_0x17a77b[_0x44d1('0x43')]=_0x1a2aac;return _0x17a77b;})[_0x44d1('0x22')](respondWithFilteredResult(_0x410208,_0x41efc0))[_0x44d1('0x44')](handleError(_0x410208,null));};exports['show']=function(_0x4ac2a5,_0x207ded){var _0x7215d8={'raw':![],'where':{'id':_0x4ac2a5['params']['id']}},_0x156acb={};_0x156acb[_0x44d1('0x2e')]=_['keys'](db[_0x44d1('0x29')][_0x44d1('0x2a')]);_0x156acb[_0x44d1('0x2f')]=_[_0x44d1('0x30')](_0x4ac2a5[_0x44d1('0x2f')]);_0x156acb[_0x44d1('0x3a')]=_[_0x44d1('0x31')](_0x156acb['model'],_0x156acb[_0x44d1('0x2f')]);_0x7215d8[_0x44d1('0x33')]=_[_0x44d1('0x31')](_0x156acb['model'],qs['fields'](_0x4ac2a5[_0x44d1('0x2f')][_0x44d1('0x32')]));_0x7215d8[_0x44d1('0x33')]=_0x7215d8[_0x44d1('0x33')][_0x44d1('0x34')]?_0x7215d8[_0x44d1('0x33')]:_0x156acb[_0x44d1('0x2e')];if(_0x4ac2a5['query'][_0x44d1('0x40')]){_0x7215d8[_0x44d1('0x41')]=[{'all':!![]}];}_0x7215d8=_['merge']({},_0x7215d8,_0x4ac2a5[_0x44d1('0x3f')]);return db[_0x44d1('0x29')]['find'](_0x7215d8)[_0x44d1('0x22')](handleEntityNotFound(_0x207ded,null))['then'](respondWithResult(_0x207ded,null))[_0x44d1('0x44')](handleError(_0x207ded,null));};exports[_0x44d1('0x45')]=function(_0x14f7d9,_0x335d43){return db[_0x44d1('0x29')][_0x44d1('0x45')](_0x14f7d9[_0x44d1('0x46')],{})[_0x44d1('0x22')](respondWithResult(_0x335d43,0xc9))[_0x44d1('0x44')](handleError(_0x335d43,null));};exports['update']=function(_0x1a120b,_0x5db219){if(_0x1a120b[_0x44d1('0x46')]['id']){delete _0x1a120b[_0x44d1('0x46')]['id'];}return db['FreshdeskConfiguration'][_0x44d1('0x47')]({'where':{'id':_0x1a120b[_0x44d1('0x48')]['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0x5db219,null))[_0x44d1('0x22')](saveUpdates(_0x1a120b[_0x44d1('0x46')],null))[_0x44d1('0x22')](respondWithResult(_0x5db219,null))[_0x44d1('0x44')](handleError(_0x5db219,null));};exports[_0x44d1('0x23')]=function(_0x284670,_0x1733ce){return db[_0x44d1('0x29')][_0x44d1('0x47')]({'where':{'id':_0x284670[_0x44d1('0x48')]['id']}})['then'](handleEntityNotFound(_0x1733ce,null))[_0x44d1('0x22')](removeEntity(_0x1733ce,null))[_0x44d1('0x44')](handleError(_0x1733ce,null));};exports[_0x44d1('0x49')]=function(_0x52241f,_0x35e251,_0x28250a){var _0x5ec934={};var _0x298267={};var _0x1ddc3d;var _0x29e3fd;return db[_0x44d1('0x29')]['findOne']({'where':{'id':_0x52241f['params']['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0x35e251,null))[_0x44d1('0x22')](function(_0x49d01a){if(_0x49d01a){_0x1ddc3d=_0x49d01a;_0x298267[_0x44d1('0x2e')]=_[_0x44d1('0x30')](db[_0x44d1('0x4a')][_0x44d1('0x2a')]);_0x298267[_0x44d1('0x2f')]=_['keys'](_0x52241f[_0x44d1('0x2f')]);_0x298267[_0x44d1('0x3a')]=_[_0x44d1('0x31')](_0x298267[_0x44d1('0x2e')],_0x298267[_0x44d1('0x2f')]);_0x5ec934['attributes']=_['intersection'](_0x298267[_0x44d1('0x2e')],qs[_0x44d1('0x32')](_0x52241f['query'][_0x44d1('0x32')]));_0x5ec934[_0x44d1('0x33')]=_0x5ec934[_0x44d1('0x33')][_0x44d1('0x34')]?_0x5ec934['attributes']:_0x298267[_0x44d1('0x2e')];_0x5ec934[_0x44d1('0x37')]=qs[_0x44d1('0x38')](_0x52241f[_0x44d1('0x2f')][_0x44d1('0x38')]);_0x5ec934[_0x44d1('0x3c')]=qs[_0x44d1('0x3a')](_[_0x44d1('0x39')](_0x52241f[_0x44d1('0x2f')],_0x298267[_0x44d1('0x3a')]));if(_0x52241f[_0x44d1('0x2f')][_0x44d1('0x3b')]){_0x5ec934[_0x44d1('0x3c')]=_['merge'](_0x5ec934['where'],{'$or':_['map'](_0x5ec934[_0x44d1('0x33')],function(_0xfc301d){var _0x40fae5={};_0x40fae5[_0xfc301d]={'$like':'%'+_0x52241f[_0x44d1('0x2f')][_0x44d1('0x3b')]+'%'};return _0x40fae5;})});}_0x5ec934=_['merge']({},_0x5ec934,_0x52241f[_0x44d1('0x3f')]);return _0x1ddc3d[_0x44d1('0x49')](_0x5ec934);}})[_0x44d1('0x22')](function(_0x41f531){if(_0x41f531){_0x29e3fd=_0x41f531[_0x44d1('0x34')];if(!_0x52241f['query'][_0x44d1('0x35')](_0x44d1('0x36'))){_0x5ec934[_0x44d1('0x19')]=qs[_0x44d1('0x19')](_0x52241f[_0x44d1('0x2f')][_0x44d1('0x19')]);_0x5ec934[_0x44d1('0x1b')]=qs['offset'](_0x52241f[_0x44d1('0x2f')][_0x44d1('0x1b')]);}return _0x1ddc3d[_0x44d1('0x49')](_0x5ec934);}})[_0x44d1('0x22')](function(_0xf52ff3){if(_0xf52ff3){return _0xf52ff3?{'count':_0x29e3fd,'rows':_0xf52ff3}:null;}})[_0x44d1('0x22')](respondWithResult(_0x35e251,null))[_0x44d1('0x44')](handleError(_0x35e251,null));};exports[_0x44d1('0x4b')]=function(_0xdd90d7,_0x349378,_0x34050d){var _0x40d883={};var _0x48bfa8={};var _0x45da12;var _0x432c81;return db[_0x44d1('0x29')][_0x44d1('0x4c')]({'where':{'id':_0xdd90d7[_0x44d1('0x48')]['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0x349378,null))[_0x44d1('0x22')](function(_0x1adf5b){if(_0x1adf5b){_0x45da12=_0x1adf5b;_0x48bfa8['model']=_[_0x44d1('0x30')](db['FreshdeskField'][_0x44d1('0x2a')]);_0x48bfa8[_0x44d1('0x2f')]=_[_0x44d1('0x30')](_0xdd90d7[_0x44d1('0x2f')]);_0x48bfa8['filters']=_[_0x44d1('0x31')](_0x48bfa8[_0x44d1('0x2e')],_0x48bfa8[_0x44d1('0x2f')]);_0x40d883['attributes']=_[_0x44d1('0x31')](_0x48bfa8[_0x44d1('0x2e')],qs[_0x44d1('0x32')](_0xdd90d7[_0x44d1('0x2f')][_0x44d1('0x32')]));_0x40d883['attributes']=_0x40d883[_0x44d1('0x33')][_0x44d1('0x34')]?_0x40d883['attributes']:_0x48bfa8[_0x44d1('0x2e')];_0x40d883[_0x44d1('0x37')]=qs[_0x44d1('0x38')](_0xdd90d7[_0x44d1('0x2f')][_0x44d1('0x38')]);_0x40d883[_0x44d1('0x3c')]=qs[_0x44d1('0x3a')](_[_0x44d1('0x39')](_0xdd90d7[_0x44d1('0x2f')],_0x48bfa8[_0x44d1('0x3a')]));if(_0xdd90d7[_0x44d1('0x2f')][_0x44d1('0x3b')]){_0x40d883['where']=_[_0x44d1('0x3d')](_0x40d883[_0x44d1('0x3c')],{'$or':_[_0x44d1('0x28')](_0x40d883[_0x44d1('0x33')],function(_0x49d5b0){var _0x2f1b11={};_0x2f1b11[_0x49d5b0]={'$like':'%'+_0xdd90d7[_0x44d1('0x2f')][_0x44d1('0x3b')]+'%'};return _0x2f1b11;})});}_0x40d883=_[_0x44d1('0x3d')]({},_0x40d883,_0xdd90d7['options']);return _0x45da12[_0x44d1('0x4b')](_0x40d883);}})['then'](function(_0x376966){if(_0x376966){_0x432c81=_0x376966[_0x44d1('0x34')];if(!_0xdd90d7[_0x44d1('0x2f')]['hasOwnProperty'](_0x44d1('0x36'))){_0x40d883[_0x44d1('0x19')]=qs[_0x44d1('0x19')](_0xdd90d7['query'][_0x44d1('0x19')]);_0x40d883[_0x44d1('0x1b')]=qs[_0x44d1('0x1b')](_0xdd90d7['query'][_0x44d1('0x1b')]);}return _0x45da12[_0x44d1('0x4b')](_0x40d883);}})[_0x44d1('0x22')](function(_0x253d34){if(_0x253d34){return _0x253d34?{'count':_0x432c81,'rows':_0x253d34}:null;}})[_0x44d1('0x22')](respondWithResult(_0x349378,null))[_0x44d1('0x44')](handleError(_0x349378,null));};exports[_0x44d1('0x4d')]=function(_0x25b8fb,_0x2a1613,_0x8d59ce){var _0x5607d6={};var _0x5a15f1={};var _0x36d06a;var _0x2ee3a1;return db[_0x44d1('0x29')][_0x44d1('0x4c')]({'where':{'id':_0x25b8fb[_0x44d1('0x48')]['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0x2a1613,null))[_0x44d1('0x22')](function(_0x47a827){if(_0x47a827){_0x36d06a=_0x47a827;_0x5a15f1[_0x44d1('0x2e')]=_[_0x44d1('0x30')](db['FreshdeskField'][_0x44d1('0x2a')]);_0x5a15f1['query']=_[_0x44d1('0x30')](_0x25b8fb[_0x44d1('0x2f')]);_0x5a15f1[_0x44d1('0x3a')]=_['intersection'](_0x5a15f1[_0x44d1('0x2e')],_0x5a15f1['query']);_0x5607d6[_0x44d1('0x33')]=_[_0x44d1('0x31')](_0x5a15f1['model'],qs[_0x44d1('0x32')](_0x25b8fb[_0x44d1('0x2f')][_0x44d1('0x32')]));_0x5607d6[_0x44d1('0x33')]=_0x5607d6[_0x44d1('0x33')]['length']?_0x5607d6[_0x44d1('0x33')]:_0x5a15f1['model'];_0x5607d6[_0x44d1('0x37')]=qs[_0x44d1('0x38')](_0x25b8fb[_0x44d1('0x2f')][_0x44d1('0x38')]);_0x5607d6['where']=qs[_0x44d1('0x3a')](_['pick'](_0x25b8fb[_0x44d1('0x2f')],_0x5a15f1[_0x44d1('0x3a')]));if(_0x25b8fb['query'][_0x44d1('0x3b')]){_0x5607d6[_0x44d1('0x3c')]=_[_0x44d1('0x3d')](_0x5607d6[_0x44d1('0x3c')],{'$or':_[_0x44d1('0x28')](_0x5607d6[_0x44d1('0x33')],function(_0xdbec18){var _0x13342e={};_0x13342e[_0xdbec18]={'$like':'%'+_0x25b8fb[_0x44d1('0x2f')][_0x44d1('0x3b')]+'%'};return _0x13342e;})});}_0x5607d6=_[_0x44d1('0x3d')]({},_0x5607d6,_0x25b8fb[_0x44d1('0x3f')]);return _0x36d06a[_0x44d1('0x4d')](_0x5607d6);}})['then'](function(_0x339858){if(_0x339858){_0x2ee3a1=_0x339858[_0x44d1('0x34')];if(!_0x25b8fb['query'][_0x44d1('0x35')](_0x44d1('0x36'))){_0x5607d6['limit']=qs[_0x44d1('0x19')](_0x25b8fb[_0x44d1('0x2f')][_0x44d1('0x19')]);_0x5607d6[_0x44d1('0x1b')]=qs[_0x44d1('0x1b')](_0x25b8fb[_0x44d1('0x2f')]['offset']);}return _0x36d06a[_0x44d1('0x4d')](_0x5607d6);}})[_0x44d1('0x22')](function(_0x5da6e4){if(_0x5da6e4){return _0x5da6e4?{'count':_0x2ee3a1,'rows':_0x5da6e4}:null;}})[_0x44d1('0x22')](respondWithResult(_0x2a1613,null))[_0x44d1('0x44')](handleError(_0x2a1613,null));};exports['getTags']=function(_0x1aa106,_0xea2623,_0x445b16){var _0x36d911={};var _0x24e128={};var _0x3f58b4;var _0x20f028;return db[_0x44d1('0x29')]['findOne']({'where':{'id':_0x1aa106[_0x44d1('0x48')]['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0xea2623,null))[_0x44d1('0x22')](function(_0x33b254){if(_0x33b254){_0x3f58b4=_0x33b254;_0x24e128[_0x44d1('0x2e')]=_[_0x44d1('0x30')](db[_0x44d1('0x4e')]['rawAttributes']);_0x24e128[_0x44d1('0x2f')]=_[_0x44d1('0x30')](_0x1aa106['query']);_0x24e128[_0x44d1('0x3a')]=_[_0x44d1('0x31')](_0x24e128[_0x44d1('0x2e')],_0x24e128[_0x44d1('0x2f')]);_0x36d911[_0x44d1('0x33')]=_['intersection'](_0x24e128[_0x44d1('0x2e')],qs[_0x44d1('0x32')](_0x1aa106['query'][_0x44d1('0x32')]));_0x36d911[_0x44d1('0x33')]=_0x36d911[_0x44d1('0x33')]['length']?_0x36d911['attributes']:_0x24e128[_0x44d1('0x2e')];_0x36d911[_0x44d1('0x37')]=qs[_0x44d1('0x38')](_0x1aa106[_0x44d1('0x2f')][_0x44d1('0x38')]);_0x36d911[_0x44d1('0x3c')]=qs['filters'](_['pick'](_0x1aa106['query'],_0x24e128[_0x44d1('0x3a')]));if(_0x1aa106['query'][_0x44d1('0x3b')]){_0x36d911['where']=_['merge'](_0x36d911[_0x44d1('0x3c')],{'$or':_[_0x44d1('0x28')](_0x36d911[_0x44d1('0x33')],function(_0x1efec6){var _0x276ec2={};_0x276ec2[_0x1efec6]={'$like':'%'+_0x1aa106[_0x44d1('0x2f')][_0x44d1('0x3b')]+'%'};return _0x276ec2;})});}_0x36d911=_[_0x44d1('0x3d')]({},_0x36d911,_0x1aa106[_0x44d1('0x3f')]);return _0x3f58b4[_0x44d1('0x4f')](_0x36d911);}})[_0x44d1('0x22')](function(_0x66f09e){if(_0x66f09e){_0x20f028=_0x66f09e[_0x44d1('0x34')];if(!_0x1aa106[_0x44d1('0x2f')]['hasOwnProperty']('nolimit')){_0x36d911[_0x44d1('0x19')]=qs[_0x44d1('0x19')](_0x1aa106['query'][_0x44d1('0x19')]);_0x36d911['offset']=qs[_0x44d1('0x1b')](_0x1aa106['query'][_0x44d1('0x1b')]);}return _0x3f58b4[_0x44d1('0x4f')](_0x36d911);}})[_0x44d1('0x22')](function(_0x19f10a){if(_0x19f10a){return _0x19f10a?{'count':_0x20f028,'rows':_0x19f10a}:null;}})[_0x44d1('0x22')](respondWithResult(_0xea2623,null))[_0x44d1('0x44')](handleError(_0xea2623,null));};exports[_0x44d1('0x50')]=function(_0x2fe8a3,_0x1ed08a,_0xba7f63){if(_0x2fe8a3[_0x44d1('0x46')]['id']){delete _0x2fe8a3[_0x44d1('0x46')]['id'];}return db[_0x44d1('0x29')][_0x44d1('0x4c')]({'where':{'id':_0x2fe8a3[_0x44d1('0x48')]['id']}})[_0x44d1('0x22')](handleEntityNotFound(_0x1ed08a,null))[_0x44d1('0x22')](function(_0x413cff){if(_0x413cff){return _0x413cff[_0x44d1('0x50')](_0x2fe8a3[_0x44d1('0x46')]['ids']||[]);}return null;})[_0x44d1('0x22')](respondWithResult(_0x1ed08a,null))[_0x44d1('0x44')](handleError(_0x1ed08a,null));};