Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / intFreshdeskConfiguration / intFreshdeskConfiguration.controller.js
index e4d1866..012283f 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0xeb9f=['desk.js','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','jayson/promise','request','info','FreshdeskConfiguration,\x20%s,\x20%s','request\x20sent','debug','FreshdeskConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','message','result','catch','end','status','count','offset','limit','set','Content-Range','apply','save','update','then','destroy','sendStatus','name','send','map','FreshdeskConfiguration','key','model','query','filters','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','pick','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','show','params','keys','rawAttributes','intersection','find','create','body','getFields','findOne','FreshdeskField','getSubjects','getDescriptions','getTags','Tag','setTags','ids','eml-format','rimraf','request-promise','bluebird','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce'];(function(_0x4cf98e,_0xba4b79){var _0x1623ac=function(_0x459bc0){while(--_0x459bc0){_0x4cf98e['push'](_0x4cf98e['shift']());}};_0x1623ac(++_0xba4b79);}(_0xeb9f,0x15c));var _0xfeb9=function(_0x318840,_0x561b1e){_0x318840=_0x318840-0x0;var _0x223da4=_0xeb9f[_0x318840];return _0x223da4;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xfeb9('0x0'));var rimraf=require(_0xfeb9('0x1'));var zipdir=require('zip-dir');var jsonpatch=require('fast-json-patch');var rp=require(_0xfeb9('0x2'));var moment=require('moment');var BPromise=require(_0xfeb9('0x3'));var Mustache=require('mustache');var util=require('util');var path=require(_0xfeb9('0x4'));var sox=require(_0xfeb9('0x5'));var csv=require(_0xfeb9('0x6'));var ejs=require(_0xfeb9('0x7'));var fs=require('fs');var _=require(_0xfeb9('0x8'));var squel=require(_0xfeb9('0x9'));var crypto=require(_0xfeb9('0xa'));var jsforce=require(_0xfeb9('0xb'));var deskjs=require(_0xfeb9('0xc'));var toCsv=require(_0xfeb9('0x6'));var querystring=require('querystring');var Papa=require('papaparse');var Redis=require(_0xfeb9('0xd'));var authService=require(_0xfeb9('0xe'));var qs=require(_0xfeb9('0xf'));var as=require(_0xfeb9('0x10'));var hardwareService=require(_0xfeb9('0x11'));var logger=require(_0xfeb9('0x12'))(_0xfeb9('0x13'));var utils=require('../../config/utils');var config=require(_0xfeb9('0x14'));var licenseUtil=require(_0xfeb9('0x15'));var db=require(_0xfeb9('0x16'))['db'];var jayson=require(_0xfeb9('0x17'));var client=jayson['client']['http']({'port':0x232a});function respondWithRpcPromise(_0x1594e3,_0x2c2c9e,_0x111da7,_0x37f987){return new BPromise(function(_0x51e101,_0x44f978){var _0x54007d=_0x37f987||client;return _0x54007d[_0xfeb9('0x18')](_0x1594e3,_0x111da7)['then'](function(_0x4cd182){logger[_0xfeb9('0x19')](_0xfeb9('0x1a'),_0x2c2c9e,_0xfeb9('0x1b'));logger[_0xfeb9('0x1c')](_0xfeb9('0x1d'),_0x2c2c9e,_0xfeb9('0x1b'),JSON[_0xfeb9('0x1e')](_0x4cd182));if(_0x4cd182[_0xfeb9('0x1f')]){if(_0x4cd182[_0xfeb9('0x1f')]['code']===0x1f4){logger[_0xfeb9('0x1f')](_0xfeb9('0x1a'),_0x2c2c9e,_0x4cd182[_0xfeb9('0x1f')][_0xfeb9('0x20')]);return _0x44f978(_0x4cd182['error'][_0xfeb9('0x20')]);}logger['error'](_0xfeb9('0x1a'),_0x2c2c9e,_0x4cd182[_0xfeb9('0x1f')]['message']);return _0x51e101(_0x4cd182[_0xfeb9('0x1f')][_0xfeb9('0x20')]);}else{logger['info']('FreshdeskConfiguration,\x20%s,\x20%s',_0x2c2c9e,'request\x20sent');_0x51e101(_0x4cd182[_0xfeb9('0x21')][_0xfeb9('0x20')]);}})[_0xfeb9('0x22')](function(_0x1e312c){logger[_0xfeb9('0x1f')](_0xfeb9('0x1a'),_0x2c2c9e,_0x1e312c);_0x44f978(_0x1e312c);});});}function respondWithStatusCode(_0x3de616,_0x30cda9){_0x30cda9=_0x30cda9||0xcc;return function(_0x143271){if(_0x143271){return _0x3de616['sendStatus'](_0x30cda9);}return _0x3de616['status'](_0x30cda9)[_0xfeb9('0x23')]();};}function respondWithResult(_0x4a4e98,_0x40f8ea){_0x40f8ea=_0x40f8ea||0xc8;return function(_0x5a1958){if(_0x5a1958){return _0x4a4e98[_0xfeb9('0x24')](_0x40f8ea)['json'](_0x5a1958);}};}function respondWithFilteredResult(_0x352039,_0x211c26){return function(_0x61205){if(_0x61205){var _0x5486c0=_0x61205[_0xfeb9('0x25')],_0x1b4a8c=_0x211c26[_0xfeb9('0x26')],_0x27e54a=_0x211c26[_0xfeb9('0x26')]+_0x211c26[_0xfeb9('0x27')],_0x230e34;if(_0x27e54a>=_0x5486c0){_0x27e54a=_0x5486c0;_0x230e34=0xc8;}else{_0x230e34=0xce;}_0x352039[_0xfeb9('0x24')](_0x230e34);return _0x352039[_0xfeb9('0x28')](_0xfeb9('0x29'),_0x1b4a8c+'-'+_0x27e54a+'/'+_0x5486c0)['json'](_0x61205);}return null;};}function patchUpdates(_0x4fff52){return function(_0x1eb0e9){try{jsonpatch[_0xfeb9('0x2a')](_0x1eb0e9,_0x4fff52,!![]);}catch(_0x1be3bf){return BPromise['reject'](_0x1be3bf);}return _0x1eb0e9[_0xfeb9('0x2b')]();};}function saveUpdates(_0x3419c7,_0x1f9a2f){return function(_0x248857){if(_0x248857){return _0x248857[_0xfeb9('0x2c')](_0x3419c7)[_0xfeb9('0x2d')](function(_0x35d847){return _0x35d847;});}return null;};}function removeEntity(_0x4bf0d2,_0x1ab8b4){return function(_0x15941c){if(_0x15941c){return _0x15941c[_0xfeb9('0x2e')]()['then'](function(){_0x4bf0d2['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x34e0fd,_0xc7eb59){return function(_0x3245ce){if(!_0x3245ce){_0x34e0fd[_0xfeb9('0x2f')](0x194);}return _0x3245ce;};}function handleError(_0x1a901f,_0x4c3112){_0x4c3112=_0x4c3112||0x1f4;return function(_0x3f3811){logger[_0xfeb9('0x1f')](_0x3f3811['stack']);if(_0x3f3811[_0xfeb9('0x30')]){delete _0x3f3811[_0xfeb9('0x30')];}_0x1a901f[_0xfeb9('0x24')](_0x4c3112)[_0xfeb9('0x31')](_0x3f3811);};}exports['index']=function(_0x25c923,_0x4fca2e){var _0xf7f01b={},_0x1bc400={},_0x2cc460={'count':0x0,'rows':[]};var _0x2c0b6d=_[_0xfeb9('0x32')](db[_0xfeb9('0x33')]['rawAttributes'],function(_0xb9cdbc){return{'name':_0xb9cdbc['fieldName'],'type':_0xb9cdbc['type'][_0xfeb9('0x34')]};});_0x1bc400[_0xfeb9('0x35')]=_[_0xfeb9('0x32')](_0x2c0b6d,_0xfeb9('0x30'));_0x1bc400[_0xfeb9('0x36')]=_['keys'](_0x25c923[_0xfeb9('0x36')]);_0x1bc400[_0xfeb9('0x37')]=_['intersection'](_0x1bc400[_0xfeb9('0x35')],_0x1bc400[_0xfeb9('0x36')]);_0xf7f01b[_0xfeb9('0x38')]=_['intersection'](_0x1bc400[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x25c923[_0xfeb9('0x36')][_0xfeb9('0x39')]));_0xf7f01b[_0xfeb9('0x38')]=_0xf7f01b[_0xfeb9('0x38')][_0xfeb9('0x3a')]?_0xf7f01b[_0xfeb9('0x38')]:_0x1bc400[_0xfeb9('0x35')];if(!_0x25c923[_0xfeb9('0x36')][_0xfeb9('0x3b')](_0xfeb9('0x3c'))){_0xf7f01b['limit']=qs['limit'](_0x25c923[_0xfeb9('0x36')]['limit']);_0xf7f01b['offset']=qs[_0xfeb9('0x26')](_0x25c923['query'][_0xfeb9('0x26')]);}_0xf7f01b[_0xfeb9('0x3d')]=qs[_0xfeb9('0x3e')](_0x25c923[_0xfeb9('0x36')][_0xfeb9('0x3e')]);_0xf7f01b[_0xfeb9('0x3f')]=qs[_0xfeb9('0x37')](_[_0xfeb9('0x40')](_0x25c923[_0xfeb9('0x36')],_0x1bc400[_0xfeb9('0x37')]),_0x2c0b6d);if(_0x25c923[_0xfeb9('0x36')][_0xfeb9('0x41')]){_0xf7f01b[_0xfeb9('0x3f')]=_[_0xfeb9('0x42')](_0xf7f01b['where'],{'$or':_['map'](_0x2c0b6d,function(_0x443683){if(_0x443683['type']!==_0xfeb9('0x43')){var _0xfd477f={};_0xfd477f[_0x443683[_0xfeb9('0x30')]]={'$like':'%'+_0x25c923['query'][_0xfeb9('0x41')]+'%'};return _0xfd477f;}})});}_0xf7f01b=_[_0xfeb9('0x42')]({},_0xf7f01b,_0x25c923[_0xfeb9('0x44')]);var _0x3d8fd9={'where':_0xf7f01b[_0xfeb9('0x3f')]};return db['FreshdeskConfiguration']['count'](_0x3d8fd9)[_0xfeb9('0x2d')](function(_0x35003f){_0x2cc460[_0xfeb9('0x25')]=_0x35003f;if(_0x25c923['query'][_0xfeb9('0x45')]){_0xf7f01b[_0xfeb9('0x46')]=[{'all':!![]}];}return db['FreshdeskConfiguration'][_0xfeb9('0x47')](_0xf7f01b);})[_0xfeb9('0x2d')](function(_0x5603f0){_0x2cc460[_0xfeb9('0x48')]=_0x5603f0;return _0x2cc460;})[_0xfeb9('0x2d')](respondWithFilteredResult(_0x4fca2e,_0xf7f01b))[_0xfeb9('0x22')](handleError(_0x4fca2e,null));};exports[_0xfeb9('0x49')]=function(_0x1358b0,_0x273acf){var _0x324735={'raw':![],'where':{'id':_0x1358b0[_0xfeb9('0x4a')]['id']}},_0x36b465={};_0x36b465[_0xfeb9('0x35')]=_[_0xfeb9('0x4b')](db['FreshdeskConfiguration'][_0xfeb9('0x4c')]);_0x36b465[_0xfeb9('0x36')]=_[_0xfeb9('0x4b')](_0x1358b0['query']);_0x36b465[_0xfeb9('0x37')]=_[_0xfeb9('0x4d')](_0x36b465[_0xfeb9('0x35')],_0x36b465[_0xfeb9('0x36')]);_0x324735[_0xfeb9('0x38')]=_[_0xfeb9('0x4d')](_0x36b465[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x1358b0[_0xfeb9('0x36')][_0xfeb9('0x39')]));_0x324735[_0xfeb9('0x38')]=_0x324735[_0xfeb9('0x38')][_0xfeb9('0x3a')]?_0x324735['attributes']:_0x36b465[_0xfeb9('0x35')];if(_0x1358b0[_0xfeb9('0x36')]['includeAll']){_0x324735[_0xfeb9('0x46')]=[{'all':!![]}];}_0x324735=_[_0xfeb9('0x42')]({},_0x324735,_0x1358b0[_0xfeb9('0x44')]);return db[_0xfeb9('0x33')][_0xfeb9('0x4e')](_0x324735)[_0xfeb9('0x2d')](handleEntityNotFound(_0x273acf,null))['then'](respondWithResult(_0x273acf,null))[_0xfeb9('0x22')](handleError(_0x273acf,null));};exports[_0xfeb9('0x4f')]=function(_0x3ddf17,_0xcd3a7d){return db['FreshdeskConfiguration'][_0xfeb9('0x4f')](_0x3ddf17[_0xfeb9('0x50')],{})['then'](respondWithResult(_0xcd3a7d,0xc9))[_0xfeb9('0x22')](handleError(_0xcd3a7d,null));};exports['update']=function(_0x49f580,_0x3f09d2){if(_0x49f580[_0xfeb9('0x50')]['id']){delete _0x49f580[_0xfeb9('0x50')]['id'];}return db[_0xfeb9('0x33')][_0xfeb9('0x4e')]({'where':{'id':_0x49f580[_0xfeb9('0x4a')]['id']}})[_0xfeb9('0x2d')](handleEntityNotFound(_0x3f09d2,null))['then'](saveUpdates(_0x49f580[_0xfeb9('0x50')],null))['then'](respondWithResult(_0x3f09d2,null))[_0xfeb9('0x22')](handleError(_0x3f09d2,null));};exports[_0xfeb9('0x2e')]=function(_0x5a5837,_0x5166c6){return db['FreshdeskConfiguration'][_0xfeb9('0x4e')]({'where':{'id':_0x5a5837[_0xfeb9('0x4a')]['id']}})['then'](handleEntityNotFound(_0x5166c6,null))['then'](removeEntity(_0x5166c6,null))['catch'](handleError(_0x5166c6,null));};exports[_0xfeb9('0x51')]=function(_0x5b2b9a,_0x1aabde,_0x3bdaef){var _0x5b5b81={};var _0x3b5e60={};var _0x2749e7;var _0x3070b6;return db[_0xfeb9('0x33')]['findOne']({'where':{'id':_0x5b2b9a['params']['id']}})[_0xfeb9('0x2d')](handleEntityNotFound(_0x1aabde,null))[_0xfeb9('0x2d')](function(_0x2d04e3){if(_0x2d04e3){_0x2749e7=_0x2d04e3;_0x3b5e60['model']=_[_0xfeb9('0x4b')](db['FreshdeskField']['rawAttributes']);_0x3b5e60[_0xfeb9('0x36')]=_['keys'](_0x5b2b9a[_0xfeb9('0x36')]);_0x3b5e60[_0xfeb9('0x37')]=_[_0xfeb9('0x4d')](_0x3b5e60[_0xfeb9('0x35')],_0x3b5e60[_0xfeb9('0x36')]);_0x5b5b81['attributes']=_[_0xfeb9('0x4d')](_0x3b5e60[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x5b2b9a[_0xfeb9('0x36')][_0xfeb9('0x39')]));_0x5b5b81['attributes']=_0x5b5b81['attributes'][_0xfeb9('0x3a')]?_0x5b5b81[_0xfeb9('0x38')]:_0x3b5e60['model'];_0x5b5b81[_0xfeb9('0x3d')]=qs[_0xfeb9('0x3e')](_0x5b2b9a[_0xfeb9('0x36')]['sort']);_0x5b5b81[_0xfeb9('0x3f')]=qs[_0xfeb9('0x37')](_[_0xfeb9('0x40')](_0x5b2b9a[_0xfeb9('0x36')],_0x3b5e60[_0xfeb9('0x37')]));if(_0x5b2b9a[_0xfeb9('0x36')][_0xfeb9('0x41')]){_0x5b5b81['where']=_['merge'](_0x5b5b81[_0xfeb9('0x3f')],{'$or':_[_0xfeb9('0x32')](_0x5b5b81[_0xfeb9('0x38')],function(_0x1eb107){var _0x2ff261={};_0x2ff261[_0x1eb107]={'$like':'%'+_0x5b2b9a[_0xfeb9('0x36')][_0xfeb9('0x41')]+'%'};return _0x2ff261;})});}_0x5b5b81=_['merge']({},_0x5b5b81,_0x5b2b9a[_0xfeb9('0x44')]);return _0x2749e7[_0xfeb9('0x51')](_0x5b5b81);}})[_0xfeb9('0x2d')](function(_0x189a7e){if(_0x189a7e){_0x3070b6=_0x189a7e[_0xfeb9('0x3a')];if(!_0x5b2b9a[_0xfeb9('0x36')]['hasOwnProperty'](_0xfeb9('0x3c'))){_0x5b5b81[_0xfeb9('0x27')]=qs['limit'](_0x5b2b9a[_0xfeb9('0x36')]['limit']);_0x5b5b81[_0xfeb9('0x26')]=qs[_0xfeb9('0x26')](_0x5b2b9a[_0xfeb9('0x36')]['offset']);}return _0x2749e7[_0xfeb9('0x51')](_0x5b5b81);}})[_0xfeb9('0x2d')](function(_0x25a417){if(_0x25a417){return _0x25a417?{'count':_0x3070b6,'rows':_0x25a417}:null;}})[_0xfeb9('0x2d')](respondWithResult(_0x1aabde,null))[_0xfeb9('0x22')](handleError(_0x1aabde,null));};exports['getSubjects']=function(_0x22b3ed,_0x362a49,_0x8c61b5){var _0x2ceddd={};var _0x50a58f={};var _0x30c114;var _0x203ca1;return db[_0xfeb9('0x33')][_0xfeb9('0x52')]({'where':{'id':_0x22b3ed[_0xfeb9('0x4a')]['id']}})[_0xfeb9('0x2d')](handleEntityNotFound(_0x362a49,null))[_0xfeb9('0x2d')](function(_0x4e14ec){if(_0x4e14ec){_0x30c114=_0x4e14ec;_0x50a58f[_0xfeb9('0x35')]=_[_0xfeb9('0x4b')](db[_0xfeb9('0x53')][_0xfeb9('0x4c')]);_0x50a58f['query']=_[_0xfeb9('0x4b')](_0x22b3ed['query']);_0x50a58f[_0xfeb9('0x37')]=_[_0xfeb9('0x4d')](_0x50a58f['model'],_0x50a58f[_0xfeb9('0x36')]);_0x2ceddd['attributes']=_['intersection'](_0x50a58f[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x22b3ed[_0xfeb9('0x36')]['fields']));_0x2ceddd[_0xfeb9('0x38')]=_0x2ceddd[_0xfeb9('0x38')][_0xfeb9('0x3a')]?_0x2ceddd[_0xfeb9('0x38')]:_0x50a58f['model'];_0x2ceddd[_0xfeb9('0x3d')]=qs[_0xfeb9('0x3e')](_0x22b3ed[_0xfeb9('0x36')]['sort']);_0x2ceddd[_0xfeb9('0x3f')]=qs[_0xfeb9('0x37')](_[_0xfeb9('0x40')](_0x22b3ed['query'],_0x50a58f[_0xfeb9('0x37')]));if(_0x22b3ed['query'][_0xfeb9('0x41')]){_0x2ceddd[_0xfeb9('0x3f')]=_[_0xfeb9('0x42')](_0x2ceddd['where'],{'$or':_[_0xfeb9('0x32')](_0x2ceddd[_0xfeb9('0x38')],function(_0x4bd55){var _0x51a14a={};_0x51a14a[_0x4bd55]={'$like':'%'+_0x22b3ed['query'][_0xfeb9('0x41')]+'%'};return _0x51a14a;})});}_0x2ceddd=_[_0xfeb9('0x42')]({},_0x2ceddd,_0x22b3ed['options']);return _0x30c114[_0xfeb9('0x54')](_0x2ceddd);}})['then'](function(_0x2fbd13){if(_0x2fbd13){_0x203ca1=_0x2fbd13[_0xfeb9('0x3a')];if(!_0x22b3ed[_0xfeb9('0x36')][_0xfeb9('0x3b')](_0xfeb9('0x3c'))){_0x2ceddd[_0xfeb9('0x27')]=qs['limit'](_0x22b3ed[_0xfeb9('0x36')][_0xfeb9('0x27')]);_0x2ceddd[_0xfeb9('0x26')]=qs[_0xfeb9('0x26')](_0x22b3ed[_0xfeb9('0x36')][_0xfeb9('0x26')]);}return _0x30c114[_0xfeb9('0x54')](_0x2ceddd);}})['then'](function(_0x3f18dd){if(_0x3f18dd){return _0x3f18dd?{'count':_0x203ca1,'rows':_0x3f18dd}:null;}})[_0xfeb9('0x2d')](respondWithResult(_0x362a49,null))[_0xfeb9('0x22')](handleError(_0x362a49,null));};exports['getDescriptions']=function(_0x51dddd,_0x1e6dbe,_0x33bc07){var _0x13a867={};var _0x21e927={};var _0x572416;var _0x8d4cf1;return db[_0xfeb9('0x33')]['findOne']({'where':{'id':_0x51dddd[_0xfeb9('0x4a')]['id']}})['then'](handleEntityNotFound(_0x1e6dbe,null))[_0xfeb9('0x2d')](function(_0x3bfe8e){if(_0x3bfe8e){_0x572416=_0x3bfe8e;_0x21e927[_0xfeb9('0x35')]=_['keys'](db['FreshdeskField']['rawAttributes']);_0x21e927[_0xfeb9('0x36')]=_[_0xfeb9('0x4b')](_0x51dddd[_0xfeb9('0x36')]);_0x21e927[_0xfeb9('0x37')]=_[_0xfeb9('0x4d')](_0x21e927['model'],_0x21e927[_0xfeb9('0x36')]);_0x13a867['attributes']=_['intersection'](_0x21e927[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x51dddd[_0xfeb9('0x36')][_0xfeb9('0x39')]));_0x13a867[_0xfeb9('0x38')]=_0x13a867[_0xfeb9('0x38')][_0xfeb9('0x3a')]?_0x13a867['attributes']:_0x21e927[_0xfeb9('0x35')];_0x13a867[_0xfeb9('0x3d')]=qs['sort'](_0x51dddd[_0xfeb9('0x36')][_0xfeb9('0x3e')]);_0x13a867[_0xfeb9('0x3f')]=qs[_0xfeb9('0x37')](_[_0xfeb9('0x40')](_0x51dddd[_0xfeb9('0x36')],_0x21e927['filters']));if(_0x51dddd[_0xfeb9('0x36')][_0xfeb9('0x41')]){_0x13a867['where']=_[_0xfeb9('0x42')](_0x13a867['where'],{'$or':_[_0xfeb9('0x32')](_0x13a867[_0xfeb9('0x38')],function(_0x5c65d7){var _0x3b6567={};_0x3b6567[_0x5c65d7]={'$like':'%'+_0x51dddd['query']['filter']+'%'};return _0x3b6567;})});}_0x13a867=_[_0xfeb9('0x42')]({},_0x13a867,_0x51dddd[_0xfeb9('0x44')]);return _0x572416[_0xfeb9('0x55')](_0x13a867);}})[_0xfeb9('0x2d')](function(_0x1eb1e9){if(_0x1eb1e9){_0x8d4cf1=_0x1eb1e9['length'];if(!_0x51dddd[_0xfeb9('0x36')][_0xfeb9('0x3b')](_0xfeb9('0x3c'))){_0x13a867[_0xfeb9('0x27')]=qs[_0xfeb9('0x27')](_0x51dddd[_0xfeb9('0x36')][_0xfeb9('0x27')]);_0x13a867[_0xfeb9('0x26')]=qs[_0xfeb9('0x26')](_0x51dddd['query']['offset']);}return _0x572416['getDescriptions'](_0x13a867);}})[_0xfeb9('0x2d')](function(_0x40e222){if(_0x40e222){return _0x40e222?{'count':_0x8d4cf1,'rows':_0x40e222}:null;}})[_0xfeb9('0x2d')](respondWithResult(_0x1e6dbe,null))[_0xfeb9('0x22')](handleError(_0x1e6dbe,null));};exports[_0xfeb9('0x56')]=function(_0x1cb63a,_0x4082e4,_0x5b3375){var _0x5df867={};var _0x18a135={};var _0x115742;var _0x359ccf;return db[_0xfeb9('0x33')][_0xfeb9('0x52')]({'where':{'id':_0x1cb63a[_0xfeb9('0x4a')]['id']}})['then'](handleEntityNotFound(_0x4082e4,null))[_0xfeb9('0x2d')](function(_0x1cb8c3){if(_0x1cb8c3){_0x115742=_0x1cb8c3;_0x18a135[_0xfeb9('0x35')]=_[_0xfeb9('0x4b')](db[_0xfeb9('0x57')][_0xfeb9('0x4c')]);_0x18a135['query']=_[_0xfeb9('0x4b')](_0x1cb63a[_0xfeb9('0x36')]);_0x18a135[_0xfeb9('0x37')]=_[_0xfeb9('0x4d')](_0x18a135[_0xfeb9('0x35')],_0x18a135[_0xfeb9('0x36')]);_0x5df867[_0xfeb9('0x38')]=_[_0xfeb9('0x4d')](_0x18a135[_0xfeb9('0x35')],qs[_0xfeb9('0x39')](_0x1cb63a[_0xfeb9('0x36')][_0xfeb9('0x39')]));_0x5df867['attributes']=_0x5df867[_0xfeb9('0x38')][_0xfeb9('0x3a')]?_0x5df867[_0xfeb9('0x38')]:_0x18a135[_0xfeb9('0x35')];_0x5df867[_0xfeb9('0x3d')]=qs['sort'](_0x1cb63a[_0xfeb9('0x36')]['sort']);_0x5df867[_0xfeb9('0x3f')]=qs['filters'](_[_0xfeb9('0x40')](_0x1cb63a[_0xfeb9('0x36')],_0x18a135[_0xfeb9('0x37')]));if(_0x1cb63a[_0xfeb9('0x36')][_0xfeb9('0x41')]){_0x5df867[_0xfeb9('0x3f')]=_[_0xfeb9('0x42')](_0x5df867[_0xfeb9('0x3f')],{'$or':_[_0xfeb9('0x32')](_0x5df867[_0xfeb9('0x38')],function(_0x30ed3a){var _0x9b1fb={};_0x9b1fb[_0x30ed3a]={'$like':'%'+_0x1cb63a['query'][_0xfeb9('0x41')]+'%'};return _0x9b1fb;})});}_0x5df867=_[_0xfeb9('0x42')]({},_0x5df867,_0x1cb63a[_0xfeb9('0x44')]);return _0x115742[_0xfeb9('0x56')](_0x5df867);}})[_0xfeb9('0x2d')](function(_0x514ab7){if(_0x514ab7){_0x359ccf=_0x514ab7['length'];if(!_0x1cb63a[_0xfeb9('0x36')]['hasOwnProperty'](_0xfeb9('0x3c'))){_0x5df867['limit']=qs[_0xfeb9('0x27')](_0x1cb63a[_0xfeb9('0x36')]['limit']);_0x5df867['offset']=qs[_0xfeb9('0x26')](_0x1cb63a[_0xfeb9('0x36')]['offset']);}return _0x115742[_0xfeb9('0x56')](_0x5df867);}})[_0xfeb9('0x2d')](function(_0x40c82e){if(_0x40c82e){return _0x40c82e?{'count':_0x359ccf,'rows':_0x40c82e}:null;}})['then'](respondWithResult(_0x4082e4,null))[_0xfeb9('0x22')](handleError(_0x4082e4,null));};exports[_0xfeb9('0x58')]=function(_0x4885a9,_0xca96ee,_0x2821d8){if(_0x4885a9[_0xfeb9('0x50')]['id']){delete _0x4885a9[_0xfeb9('0x50')]['id'];}return db[_0xfeb9('0x33')][_0xfeb9('0x52')]({'where':{'id':_0x4885a9[_0xfeb9('0x4a')]['id']}})[_0xfeb9('0x2d')](handleEntityNotFound(_0xca96ee,null))['then'](function(_0x15ba37){if(_0x15ba37){return _0x15ba37['setTags'](_0x4885a9[_0xfeb9('0x50')][_0xfeb9('0x59')]||[]);}return null;})[_0xfeb9('0x2d')](respondWithResult(_0xca96ee,null))[_0xfeb9('0x22')](handleError(_0xca96ee,null));};
\ No newline at end of file
+var _0x3879=['to-csv','ejs','fs-extra','lodash','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','limit','set','apply','reject','save','update','then','destroy','stack','name','send','map','FreshdeskConfiguration','fieldName','key','model','query','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','order','sort','where','filter','merge','type','VIRTUAL','options','rows','catch','params','rawAttributes','includeAll','include','find','create','body','getFields','FreshdeskField','pick','findOne','keys','getSubjects','getDescriptions','getTags','Tag','setTags','ids','rimraf','fast-json-patch','request-promise','bluebird','mustache','util','path','sox'];(function(_0x291f14,_0x32ddbc){var _0x399cb1=function(_0x3c4ace){while(--_0x3c4ace){_0x291f14['push'](_0x291f14['shift']());}};_0x399cb1(++_0x32ddbc);}(_0x3879,0x1ab));var _0x9387=function(_0x36443f,_0x42cfdb){_0x36443f=_0x36443f-0x0;var _0x37bbf9=_0x3879[_0x36443f];return _0x37bbf9;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x9387('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x9387('0x1'));var rp=require(_0x9387('0x2'));var moment=require('moment');var BPromise=require(_0x9387('0x3'));var Mustache=require(_0x9387('0x4'));var util=require(_0x9387('0x5'));var path=require(_0x9387('0x6'));var sox=require(_0x9387('0x7'));var csv=require(_0x9387('0x8'));var ejs=require(_0x9387('0x9'));var fs=require('fs');var fs_extra=require(_0x9387('0xa'));var _=require(_0x9387('0xb'));var squel=require('squel');var crypto=require(_0x9387('0xc'));var jsforce=require(_0x9387('0xd'));var deskjs=require(_0x9387('0xe'));var toCsv=require('to-csv');var querystring=require(_0x9387('0xf'));var Papa=require(_0x9387('0x10'));var Redis=require(_0x9387('0x11'));var authService=require(_0x9387('0x12'));var qs=require(_0x9387('0x13'));var as=require(_0x9387('0x14'));var hardwareService=require(_0x9387('0x15'));var logger=require(_0x9387('0x16'))(_0x9387('0x17'));var utils=require(_0x9387('0x18'));var config=require(_0x9387('0x19'));var licenseUtil=require(_0x9387('0x1a'));var db=require(_0x9387('0x1b'))['db'];function respondWithStatusCode(_0x580b1f,_0x55d5e8){_0x55d5e8=_0x55d5e8||0xcc;return function(_0x59374d){if(_0x59374d){return _0x580b1f[_0x9387('0x1c')](_0x55d5e8);}return _0x580b1f[_0x9387('0x1d')](_0x55d5e8)[_0x9387('0x1e')]();};}function respondWithResult(_0x5123f9,_0x556ab8){_0x556ab8=_0x556ab8||0xc8;return function(_0x1930ef){if(_0x1930ef){return _0x5123f9[_0x9387('0x1d')](_0x556ab8)[_0x9387('0x1f')](_0x1930ef);}};}function respondWithFilteredResult(_0x1904a1,_0x17de98){return function(_0x3b7aa7){if(_0x3b7aa7){var _0x5dc252=typeof _0x17de98[_0x9387('0x20')]==='undefined'&&typeof _0x17de98['limit']===_0x9387('0x21');var _0x343d0b=_0x3b7aa7[_0x9387('0x22')];var _0x5a6dab=_0x5dc252?0x0:_0x17de98[_0x9387('0x20')];var _0xc5205e=_0x5dc252?_0x3b7aa7[_0x9387('0x22')]:_0x17de98[_0x9387('0x20')]+_0x17de98[_0x9387('0x23')];var _0x5a3e35;if(_0xc5205e>=_0x343d0b){_0xc5205e=_0x343d0b;_0x5a3e35=0xc8;}else{_0x5a3e35=0xce;}_0x1904a1['status'](_0x5a3e35);return _0x1904a1[_0x9387('0x24')]('Content-Range',_0x5a6dab+'-'+_0xc5205e+'/'+_0x343d0b)['json'](_0x3b7aa7);}return null;};}function patchUpdates(_0x4f41c6){return function(_0x15ef64){try{jsonpatch[_0x9387('0x25')](_0x15ef64,_0x4f41c6,!![]);}catch(_0x1464d1){return BPromise[_0x9387('0x26')](_0x1464d1);}return _0x15ef64[_0x9387('0x27')]();};}function saveUpdates(_0x25858c,_0xa9db64){return function(_0x11d5dd){if(_0x11d5dd){return _0x11d5dd[_0x9387('0x28')](_0x25858c)[_0x9387('0x29')](function(_0x30f5e4){return _0x30f5e4;});}return null;};}function removeEntity(_0x5edf13,_0x19f3a5){return function(_0x198b91){if(_0x198b91){return _0x198b91[_0x9387('0x2a')]()[_0x9387('0x29')](function(){_0x5edf13[_0x9387('0x1d')](0xcc)[_0x9387('0x1e')]();});}};}function handleEntityNotFound(_0x461f6b,_0x34cbb4){return function(_0x2bf730){if(!_0x2bf730){_0x461f6b['sendStatus'](0x194);}return _0x2bf730;};}function handleError(_0x53c67f,_0x50db5f){_0x50db5f=_0x50db5f||0x1f4;return function(_0x1be2e9){logger['error'](_0x1be2e9[_0x9387('0x2b')]);if(_0x1be2e9[_0x9387('0x2c')]){delete _0x1be2e9[_0x9387('0x2c')];}_0x53c67f[_0x9387('0x1d')](_0x50db5f)[_0x9387('0x2d')](_0x1be2e9);};}exports['index']=function(_0x447159,_0x5c9717){var _0x246e79={},_0x520ad6={},_0x4d0773={'count':0x0,'rows':[]};var _0x38b387=_[_0x9387('0x2e')](db[_0x9387('0x2f')]['rawAttributes'],function(_0x312025){return{'name':_0x312025[_0x9387('0x30')],'type':_0x312025['type'][_0x9387('0x31')]};});_0x520ad6[_0x9387('0x32')]=_[_0x9387('0x2e')](_0x38b387,_0x9387('0x2c'));_0x520ad6['query']=_['keys'](_0x447159[_0x9387('0x33')]);_0x520ad6[_0x9387('0x34')]=_[_0x9387('0x35')](_0x520ad6[_0x9387('0x32')],_0x520ad6[_0x9387('0x33')]);_0x246e79[_0x9387('0x36')]=_[_0x9387('0x35')](_0x520ad6[_0x9387('0x32')],qs['fields'](_0x447159['query'][_0x9387('0x37')]));_0x246e79['attributes']=_0x246e79['attributes'][_0x9387('0x38')]?_0x246e79[_0x9387('0x36')]:_0x520ad6[_0x9387('0x32')];if(!_0x447159[_0x9387('0x33')][_0x9387('0x39')](_0x9387('0x3a'))){_0x246e79[_0x9387('0x23')]=qs[_0x9387('0x23')](_0x447159[_0x9387('0x33')][_0x9387('0x23')]);_0x246e79[_0x9387('0x20')]=qs[_0x9387('0x20')](_0x447159['query'][_0x9387('0x20')]);}_0x246e79[_0x9387('0x3b')]=qs[_0x9387('0x3c')](_0x447159[_0x9387('0x33')][_0x9387('0x3c')]);_0x246e79[_0x9387('0x3d')]=qs[_0x9387('0x34')](_['pick'](_0x447159[_0x9387('0x33')],_0x520ad6['filters']),_0x38b387);if(_0x447159[_0x9387('0x33')][_0x9387('0x3e')]){_0x246e79[_0x9387('0x3d')]=_[_0x9387('0x3f')](_0x246e79[_0x9387('0x3d')],{'$or':_[_0x9387('0x2e')](_0x38b387,function(_0x4911cd){if(_0x4911cd[_0x9387('0x40')]!==_0x9387('0x41')){var _0x22465b={};_0x22465b[_0x4911cd[_0x9387('0x2c')]]={'$like':'%'+_0x447159[_0x9387('0x33')][_0x9387('0x3e')]+'%'};return _0x22465b;}})});}_0x246e79=_['merge']({},_0x246e79,_0x447159[_0x9387('0x42')]);var _0x15d3ce={'where':_0x246e79[_0x9387('0x3d')]};return db[_0x9387('0x2f')][_0x9387('0x22')](_0x15d3ce)[_0x9387('0x29')](function(_0x162f0e){_0x4d0773['count']=_0x162f0e;if(_0x447159[_0x9387('0x33')]['includeAll']){_0x246e79['include']=[{'all':!![]}];}return db[_0x9387('0x2f')]['findAll'](_0x246e79);})[_0x9387('0x29')](function(_0x5e8e26){_0x4d0773[_0x9387('0x43')]=_0x5e8e26;return _0x4d0773;})[_0x9387('0x29')](respondWithFilteredResult(_0x5c9717,_0x246e79))[_0x9387('0x44')](handleError(_0x5c9717,null));};exports['show']=function(_0x1dee1e,_0x51df89){var _0x518375={'raw':![],'where':{'id':_0x1dee1e[_0x9387('0x45')]['id']}},_0x3ee003={};_0x3ee003[_0x9387('0x32')]=_['keys'](db[_0x9387('0x2f')][_0x9387('0x46')]);_0x3ee003[_0x9387('0x33')]=_['keys'](_0x1dee1e[_0x9387('0x33')]);_0x3ee003['filters']=_[_0x9387('0x35')](_0x3ee003[_0x9387('0x32')],_0x3ee003['query']);_0x518375[_0x9387('0x36')]=_['intersection'](_0x3ee003[_0x9387('0x32')],qs[_0x9387('0x37')](_0x1dee1e['query'][_0x9387('0x37')]));_0x518375['attributes']=_0x518375['attributes'][_0x9387('0x38')]?_0x518375[_0x9387('0x36')]:_0x3ee003[_0x9387('0x32')];if(_0x1dee1e['query'][_0x9387('0x47')]){_0x518375[_0x9387('0x48')]=[{'all':!![]}];}_0x518375=_['merge']({},_0x518375,_0x1dee1e['options']);return db[_0x9387('0x2f')][_0x9387('0x49')](_0x518375)['then'](handleEntityNotFound(_0x51df89,null))[_0x9387('0x29')](respondWithResult(_0x51df89,null))[_0x9387('0x44')](handleError(_0x51df89,null));};exports[_0x9387('0x4a')]=function(_0x1b2884,_0x5d6143){return db['FreshdeskConfiguration'][_0x9387('0x4a')](_0x1b2884[_0x9387('0x4b')],{})['then'](respondWithResult(_0x5d6143,0xc9))[_0x9387('0x44')](handleError(_0x5d6143,null));};exports[_0x9387('0x28')]=function(_0x1e88dd,_0xb8bb8e){if(_0x1e88dd['body']['id']){delete _0x1e88dd[_0x9387('0x4b')]['id'];}return db[_0x9387('0x2f')]['find']({'where':{'id':_0x1e88dd[_0x9387('0x45')]['id']}})['then'](handleEntityNotFound(_0xb8bb8e,null))['then'](saveUpdates(_0x1e88dd[_0x9387('0x4b')],null))[_0x9387('0x29')](respondWithResult(_0xb8bb8e,null))[_0x9387('0x44')](handleError(_0xb8bb8e,null));};exports[_0x9387('0x2a')]=function(_0x1d588f,_0x1a8e15){return db[_0x9387('0x2f')][_0x9387('0x49')]({'where':{'id':_0x1d588f[_0x9387('0x45')]['id']}})[_0x9387('0x29')](handleEntityNotFound(_0x1a8e15,null))['then'](removeEntity(_0x1a8e15,null))[_0x9387('0x44')](handleError(_0x1a8e15,null));};exports[_0x9387('0x4c')]=function(_0x692c9a,_0x25cca9,_0x3a7702){var _0x421908={};var _0x2af97f={};var _0x3d22eb;var _0x1989ad;return db[_0x9387('0x2f')]['findOne']({'where':{'id':_0x692c9a[_0x9387('0x45')]['id']}})[_0x9387('0x29')](handleEntityNotFound(_0x25cca9,null))['then'](function(_0x192664){if(_0x192664){_0x3d22eb=_0x192664;_0x2af97f['model']=_['keys'](db[_0x9387('0x4d')]['rawAttributes']);_0x2af97f['query']=_['keys'](_0x692c9a[_0x9387('0x33')]);_0x2af97f[_0x9387('0x34')]=_[_0x9387('0x35')](_0x2af97f['model'],_0x2af97f[_0x9387('0x33')]);_0x421908[_0x9387('0x36')]=_[_0x9387('0x35')](_0x2af97f[_0x9387('0x32')],qs[_0x9387('0x37')](_0x692c9a['query'][_0x9387('0x37')]));_0x421908[_0x9387('0x36')]=_0x421908[_0x9387('0x36')][_0x9387('0x38')]?_0x421908[_0x9387('0x36')]:_0x2af97f[_0x9387('0x32')];_0x421908[_0x9387('0x3b')]=qs[_0x9387('0x3c')](_0x692c9a[_0x9387('0x33')][_0x9387('0x3c')]);_0x421908[_0x9387('0x3d')]=qs[_0x9387('0x34')](_[_0x9387('0x4e')](_0x692c9a[_0x9387('0x33')],_0x2af97f['filters']));if(_0x692c9a[_0x9387('0x33')][_0x9387('0x3e')]){_0x421908[_0x9387('0x3d')]=_['merge'](_0x421908[_0x9387('0x3d')],{'$or':_['map'](_0x421908['attributes'],function(_0x56e581){var _0x1b2449={};_0x1b2449[_0x56e581]={'$like':'%'+_0x692c9a['query'][_0x9387('0x3e')]+'%'};return _0x1b2449;})});}_0x421908=_[_0x9387('0x3f')]({},_0x421908,_0x692c9a[_0x9387('0x42')]);return _0x3d22eb['getFields'](_0x421908);}})['then'](function(_0x5e35a2){if(_0x5e35a2){_0x1989ad=_0x5e35a2[_0x9387('0x38')];if(!_0x692c9a['query']['hasOwnProperty'](_0x9387('0x3a'))){_0x421908[_0x9387('0x23')]=qs[_0x9387('0x23')](_0x692c9a[_0x9387('0x33')][_0x9387('0x23')]);_0x421908[_0x9387('0x20')]=qs[_0x9387('0x20')](_0x692c9a[_0x9387('0x33')]['offset']);}return _0x3d22eb['getFields'](_0x421908);}})[_0x9387('0x29')](function(_0x3c28a2){if(_0x3c28a2){return _0x3c28a2?{'count':_0x1989ad,'rows':_0x3c28a2}:null;}})['then'](respondWithResult(_0x25cca9,null))[_0x9387('0x44')](handleError(_0x25cca9,null));};exports['getSubjects']=function(_0x5133e8,_0x24857d,_0x26461d){var _0x5e39bd={};var _0x4fde33={};var _0xf939f5;var _0x4cacc9;return db[_0x9387('0x2f')][_0x9387('0x4f')]({'where':{'id':_0x5133e8['params']['id']}})['then'](handleEntityNotFound(_0x24857d,null))['then'](function(_0x5a372d){if(_0x5a372d){_0xf939f5=_0x5a372d;_0x4fde33['model']=_['keys'](db[_0x9387('0x4d')]['rawAttributes']);_0x4fde33[_0x9387('0x33')]=_[_0x9387('0x50')](_0x5133e8['query']);_0x4fde33[_0x9387('0x34')]=_['intersection'](_0x4fde33[_0x9387('0x32')],_0x4fde33[_0x9387('0x33')]);_0x5e39bd[_0x9387('0x36')]=_[_0x9387('0x35')](_0x4fde33['model'],qs[_0x9387('0x37')](_0x5133e8[_0x9387('0x33')][_0x9387('0x37')]));_0x5e39bd[_0x9387('0x36')]=_0x5e39bd[_0x9387('0x36')][_0x9387('0x38')]?_0x5e39bd[_0x9387('0x36')]:_0x4fde33[_0x9387('0x32')];_0x5e39bd[_0x9387('0x3b')]=qs['sort'](_0x5133e8[_0x9387('0x33')][_0x9387('0x3c')]);_0x5e39bd[_0x9387('0x3d')]=qs[_0x9387('0x34')](_[_0x9387('0x4e')](_0x5133e8[_0x9387('0x33')],_0x4fde33[_0x9387('0x34')]));if(_0x5133e8[_0x9387('0x33')][_0x9387('0x3e')]){_0x5e39bd[_0x9387('0x3d')]=_[_0x9387('0x3f')](_0x5e39bd[_0x9387('0x3d')],{'$or':_[_0x9387('0x2e')](_0x5e39bd['attributes'],function(_0xee9c33){var _0x1c4ab0={};_0x1c4ab0[_0xee9c33]={'$like':'%'+_0x5133e8[_0x9387('0x33')]['filter']+'%'};return _0x1c4ab0;})});}_0x5e39bd=_[_0x9387('0x3f')]({},_0x5e39bd,_0x5133e8[_0x9387('0x42')]);return _0xf939f5[_0x9387('0x51')](_0x5e39bd);}})['then'](function(_0x3f6714){if(_0x3f6714){_0x4cacc9=_0x3f6714['length'];if(!_0x5133e8[_0x9387('0x33')][_0x9387('0x39')](_0x9387('0x3a'))){_0x5e39bd[_0x9387('0x23')]=qs[_0x9387('0x23')](_0x5133e8[_0x9387('0x33')][_0x9387('0x23')]);_0x5e39bd[_0x9387('0x20')]=qs[_0x9387('0x20')](_0x5133e8[_0x9387('0x33')][_0x9387('0x20')]);}return _0xf939f5[_0x9387('0x51')](_0x5e39bd);}})[_0x9387('0x29')](function(_0x4be591){if(_0x4be591){return _0x4be591?{'count':_0x4cacc9,'rows':_0x4be591}:null;}})['then'](respondWithResult(_0x24857d,null))[_0x9387('0x44')](handleError(_0x24857d,null));};exports[_0x9387('0x52')]=function(_0x36a140,_0x5b8034,_0x524ccd){var _0x554af6={};var _0x7d960c={};var _0x1c4b75;var _0x18e054;return db['FreshdeskConfiguration']['findOne']({'where':{'id':_0x36a140[_0x9387('0x45')]['id']}})[_0x9387('0x29')](handleEntityNotFound(_0x5b8034,null))[_0x9387('0x29')](function(_0x1d0862){if(_0x1d0862){_0x1c4b75=_0x1d0862;_0x7d960c['model']=_[_0x9387('0x50')](db[_0x9387('0x4d')]['rawAttributes']);_0x7d960c['query']=_[_0x9387('0x50')](_0x36a140['query']);_0x7d960c[_0x9387('0x34')]=_[_0x9387('0x35')](_0x7d960c[_0x9387('0x32')],_0x7d960c[_0x9387('0x33')]);_0x554af6[_0x9387('0x36')]=_['intersection'](_0x7d960c['model'],qs[_0x9387('0x37')](_0x36a140['query'][_0x9387('0x37')]));_0x554af6[_0x9387('0x36')]=_0x554af6[_0x9387('0x36')][_0x9387('0x38')]?_0x554af6[_0x9387('0x36')]:_0x7d960c[_0x9387('0x32')];_0x554af6['order']=qs[_0x9387('0x3c')](_0x36a140[_0x9387('0x33')][_0x9387('0x3c')]);_0x554af6[_0x9387('0x3d')]=qs[_0x9387('0x34')](_[_0x9387('0x4e')](_0x36a140[_0x9387('0x33')],_0x7d960c[_0x9387('0x34')]));if(_0x36a140[_0x9387('0x33')][_0x9387('0x3e')]){_0x554af6['where']=_[_0x9387('0x3f')](_0x554af6['where'],{'$or':_[_0x9387('0x2e')](_0x554af6[_0x9387('0x36')],function(_0x143d05){var _0x492493={};_0x492493[_0x143d05]={'$like':'%'+_0x36a140['query'][_0x9387('0x3e')]+'%'};return _0x492493;})});}_0x554af6=_[_0x9387('0x3f')]({},_0x554af6,_0x36a140[_0x9387('0x42')]);return _0x1c4b75[_0x9387('0x52')](_0x554af6);}})['then'](function(_0x3f84ae){if(_0x3f84ae){_0x18e054=_0x3f84ae['length'];if(!_0x36a140['query']['hasOwnProperty'](_0x9387('0x3a'))){_0x554af6['limit']=qs[_0x9387('0x23')](_0x36a140[_0x9387('0x33')][_0x9387('0x23')]);_0x554af6['offset']=qs['offset'](_0x36a140[_0x9387('0x33')][_0x9387('0x20')]);}return _0x1c4b75['getDescriptions'](_0x554af6);}})[_0x9387('0x29')](function(_0x46d6fa){if(_0x46d6fa){return _0x46d6fa?{'count':_0x18e054,'rows':_0x46d6fa}:null;}})[_0x9387('0x29')](respondWithResult(_0x5b8034,null))[_0x9387('0x44')](handleError(_0x5b8034,null));};exports[_0x9387('0x53')]=function(_0x1ad604,_0x2c4a08,_0x37c0b4){var _0x2ec217={};var _0x44f9fb={};var _0x444411;var _0x1ad963;return db['FreshdeskConfiguration'][_0x9387('0x4f')]({'where':{'id':_0x1ad604[_0x9387('0x45')]['id']}})['then'](handleEntityNotFound(_0x2c4a08,null))[_0x9387('0x29')](function(_0x5ed394){if(_0x5ed394){_0x444411=_0x5ed394;_0x44f9fb[_0x9387('0x32')]=_['keys'](db[_0x9387('0x54')][_0x9387('0x46')]);_0x44f9fb[_0x9387('0x33')]=_['keys'](_0x1ad604[_0x9387('0x33')]);_0x44f9fb[_0x9387('0x34')]=_[_0x9387('0x35')](_0x44f9fb[_0x9387('0x32')],_0x44f9fb[_0x9387('0x33')]);_0x2ec217[_0x9387('0x36')]=_[_0x9387('0x35')](_0x44f9fb[_0x9387('0x32')],qs[_0x9387('0x37')](_0x1ad604['query'][_0x9387('0x37')]));_0x2ec217[_0x9387('0x36')]=_0x2ec217[_0x9387('0x36')][_0x9387('0x38')]?_0x2ec217[_0x9387('0x36')]:_0x44f9fb[_0x9387('0x32')];_0x2ec217['order']=qs[_0x9387('0x3c')](_0x1ad604[_0x9387('0x33')]['sort']);_0x2ec217[_0x9387('0x3d')]=qs['filters'](_[_0x9387('0x4e')](_0x1ad604['query'],_0x44f9fb['filters']));if(_0x1ad604['query'][_0x9387('0x3e')]){_0x2ec217['where']=_[_0x9387('0x3f')](_0x2ec217[_0x9387('0x3d')],{'$or':_['map'](_0x2ec217[_0x9387('0x36')],function(_0x3222eb){var _0x5298df={};_0x5298df[_0x3222eb]={'$like':'%'+_0x1ad604[_0x9387('0x33')]['filter']+'%'};return _0x5298df;})});}_0x2ec217=_[_0x9387('0x3f')]({},_0x2ec217,_0x1ad604[_0x9387('0x42')]);return _0x444411[_0x9387('0x53')](_0x2ec217);}})[_0x9387('0x29')](function(_0x4727e7){if(_0x4727e7){_0x1ad963=_0x4727e7[_0x9387('0x38')];if(!_0x1ad604['query'][_0x9387('0x39')](_0x9387('0x3a'))){_0x2ec217[_0x9387('0x23')]=qs[_0x9387('0x23')](_0x1ad604[_0x9387('0x33')][_0x9387('0x23')]);_0x2ec217[_0x9387('0x20')]=qs[_0x9387('0x20')](_0x1ad604[_0x9387('0x33')][_0x9387('0x20')]);}return _0x444411[_0x9387('0x53')](_0x2ec217);}})[_0x9387('0x29')](function(_0x47cf30){if(_0x47cf30){return _0x47cf30?{'count':_0x1ad963,'rows':_0x47cf30}:null;}})[_0x9387('0x29')](respondWithResult(_0x2c4a08,null))[_0x9387('0x44')](handleError(_0x2c4a08,null));};exports[_0x9387('0x55')]=function(_0x554786,_0x209f69,_0x1eaaf3){if(_0x554786['body']['id']){delete _0x554786[_0x9387('0x4b')]['id'];}return db[_0x9387('0x2f')][_0x9387('0x4f')]({'where':{'id':_0x554786[_0x9387('0x45')]['id']}})[_0x9387('0x29')](handleEntityNotFound(_0x209f69,null))[_0x9387('0x29')](function(_0xe7ecea){if(_0xe7ecea){return _0xe7ecea[_0x9387('0x55')](_0x554786[_0x9387('0x4b')][_0x9387('0x56')]||[]);}return null;})[_0x9387('0x29')](respondWithResult(_0x209f69,null))[_0x9387('0x44')](handleError(_0x209f69,null));};
\ No newline at end of file