Built motion from commit 85328c08.|2.5.50
[motion2.git] / server / api / intFreshdeskConfiguration / intFreshdeskConfiguration.controller.js
index 7a0ebbf..012283f 100644 (file)
@@ -15,4 +15,4 @@
 // * treaties. The SOFTWARE PRODUCT is licensed, not sold.                        *
 // *                                                                       *
 // *************************************************************************
-var _0x121d=['fieldName','key','map','query','keys','filters','intersection','model','fields','attributes','hasOwnProperty','nolimit','order','sort','pick','filter','where','type','VIRTUAL','merge','options','FreshdeskConfiguration','count','includeAll','include','findAll','rows','show','params','length','create','body','find','getFields','findOne','FreshdeskField','getSubjects','getDescriptions','Tag','getTags','setTags','ids','html-pdf','eml-format','rimraf','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','util','path','sox','to-csv','ejs','squel','jsforce','querystring','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','jayson/promise','client','Sequelize','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~!@#$%^&-_=+[{]}.','request','then','request\x20sent','debug','code','error','message','FreshdeskConfiguration,\x20%s,\x20%s','result','catch','status','end','json','offset','limit','set','Content-Range','apply','reject','destroy','sendStatus','stack','name','index','rawAttributes'];(function(_0x457a40,_0x3b928e){var _0x4c845e=function(_0x578f52){while(--_0x578f52){_0x457a40['push'](_0x457a40['shift']());}};_0x4c845e(++_0x3b928e);}(_0x121d,0xea));var _0xd121=function(_0x1e2bd4,_0x204843){_0x1e2bd4=_0x1e2bd4-0x0;var _0x4149d4=_0x121d[_0x1e2bd4];return _0x4149d4;};'use strict';var pdf=require(_0xd121('0x0'));var emlformat=require(_0xd121('0x1'));var rimraf=require(_0xd121('0x2'));var zipdir=require(_0xd121('0x3'));var jsonpatch=require(_0xd121('0x4'));var rp=require(_0xd121('0x5'));var moment=require(_0xd121('0x6'));var BPromise=require(_0xd121('0x7'));var Mustache=require(_0xd121('0x8'));var util=require(_0xd121('0x9'));var path=require(_0xd121('0xa'));var sox=require(_0xd121('0xb'));var csv=require(_0xd121('0xc'));var ejs=require(_0xd121('0xd'));var fs=require('fs');var _=require('lodash');var squel=require(_0xd121('0xe'));var crypto=require('crypto');var jsforce=require(_0xd121('0xf'));var deskjs=require('desk.js');var toCsv=require(_0xd121('0xc'));var querystring=require(_0xd121('0x10'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0xd121('0x11'));var as=require(_0xd121('0x12'));var hardwareService=require(_0xd121('0x13'));var logger=require(_0xd121('0x14'))(_0xd121('0x15'));var utils=require(_0xd121('0x16'));var config=require(_0xd121('0x17'));var db=require('../../mysqldb')['db'];var jayson=require(_0xd121('0x18'));var client=jayson[_0xd121('0x19')]['http']({'port':0x232a});function checkPasswordPattern(_0x20c21f,_0xffeaf5,_0x66b631){if(_0x66b631){var _0x1dd31b=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x1dd31b['test'](_0xffeaf5)){return _0x20c21f;}else{throw new db[(_0xd121('0x1a'))][(_0xd121('0x1b'))](_0xd121('0x1c'));}}else{return _0x20c21f;}}function respondWithRpcPromise(_0x5e4dc3,_0x1e69df,_0x27384d,_0x5bda79){return new BPromise(function(_0xc71a1b,_0x5e68e1){var _0x43a36b=_0x5bda79||client;return _0x43a36b[_0xd121('0x1d')](_0x5e4dc3,_0x27384d)[_0xd121('0x1e')](function(_0x352806){logger['info']('FreshdeskConfiguration,\x20%s,\x20%s',_0x1e69df,_0xd121('0x1f'));logger[_0xd121('0x20')]('FreshdeskConfiguration,\x20%s,\x20%s,\x20%s',_0x1e69df,_0xd121('0x1f'),JSON['stringify'](_0x352806));if(_0x352806['error']){if(_0x352806['error'][_0xd121('0x21')]===0x1f4){logger[_0xd121('0x22')]('FreshdeskConfiguration,\x20%s,\x20%s',_0x1e69df,_0x352806[_0xd121('0x22')][_0xd121('0x23')]);return _0x5e68e1(_0x352806[_0xd121('0x22')][_0xd121('0x23')]);}logger[_0xd121('0x22')]('FreshdeskConfiguration,\x20%s,\x20%s',_0x1e69df,_0x352806[_0xd121('0x22')][_0xd121('0x23')]);return _0xc71a1b(_0x352806['error'][_0xd121('0x23')]);}else{logger['info'](_0xd121('0x24'),_0x1e69df,_0xd121('0x1f'));_0xc71a1b(_0x352806[_0xd121('0x25')][_0xd121('0x23')]);}})[_0xd121('0x26')](function(_0x393d1d){logger[_0xd121('0x22')](_0xd121('0x24'),_0x1e69df,_0x393d1d);_0x5e68e1(_0x393d1d);});});}function respondWithStatusCode(_0x1c39d3,_0x1d99f1){_0x1d99f1=_0x1d99f1||0xcc;return function(_0x3a1aa2){if(_0x3a1aa2){return _0x1c39d3['sendStatus'](_0x1d99f1);}return _0x1c39d3[_0xd121('0x27')](_0x1d99f1)[_0xd121('0x28')]();};}function respondWithResult(_0xf5e97c,_0x4eb4a3){_0x4eb4a3=_0x4eb4a3||0xc8;return function(_0x213897){if(_0x213897){return _0xf5e97c[_0xd121('0x27')](_0x4eb4a3)[_0xd121('0x29')](_0x213897);}};}function respondWithFilteredResult(_0x32da09,_0x51cf56){return function(_0x1ba0d2){if(_0x1ba0d2){var _0x52e5d0=_0x1ba0d2['count'],_0x53028b=_0x51cf56[_0xd121('0x2a')],_0x2878e8=_0x51cf56[_0xd121('0x2a')]+_0x51cf56[_0xd121('0x2b')],_0x15188e;if(_0x2878e8>=_0x52e5d0){_0x2878e8=_0x52e5d0;_0x15188e=0xc8;}else{_0x15188e=0xce;}_0x32da09[_0xd121('0x27')](_0x15188e);return _0x32da09[_0xd121('0x2c')](_0xd121('0x2d'),_0x53028b+'-'+_0x2878e8+'/'+_0x52e5d0)[_0xd121('0x29')](_0x1ba0d2);}return null;};}function patchUpdates(_0x148605){return function(_0xa6d042){try{jsonpatch[_0xd121('0x2e')](_0xa6d042,_0x148605,!![]);}catch(_0x54da30){return BPromise[_0xd121('0x2f')](_0x54da30);}return _0xa6d042['save']();};}function saveUpdates(_0xcc896a,_0x1ce4c1){return function(_0x4391d5){if(_0x4391d5){return _0x4391d5['update'](_0xcc896a)[_0xd121('0x1e')](function(_0x429211){return _0x429211;});}return null;};}function removeEntity(_0x3f05d2,_0x363e81){return function(_0x4ca8f5){if(_0x4ca8f5){return _0x4ca8f5[_0xd121('0x30')]()[_0xd121('0x1e')](function(){_0x3f05d2['status'](0xcc)[_0xd121('0x28')]();});}};}function handleEntityNotFound(_0x1dfb0e,_0xd5dcfc){return function(_0x16257a){if(!_0x16257a){_0x1dfb0e[_0xd121('0x31')](0x194);}return _0x16257a;};}function handleError(_0x7e526e,_0x3e77bc){_0x3e77bc=_0x3e77bc||0x1f4;return function(_0x7a5ef6){logger[_0xd121('0x22')](_0x7a5ef6[_0xd121('0x32')]);if(_0x7a5ef6[_0xd121('0x33')]){delete _0x7a5ef6[_0xd121('0x33')];}_0x7e526e[_0xd121('0x27')](_0x3e77bc)['send'](_0x7a5ef6);};}exports[_0xd121('0x34')]=function(_0x3e0ddb,_0x51bb7e){var _0x9a663d={},_0x2ae446={},_0x1e031c={'count':0x0,'rows':[]};var _0x330c6e=_['map'](db['FreshdeskConfiguration'][_0xd121('0x35')],function(_0x4eca30){return{'name':_0x4eca30[_0xd121('0x36')],'type':_0x4eca30['type'][_0xd121('0x37')]};});_0x2ae446['model']=_[_0xd121('0x38')](_0x330c6e,_0xd121('0x33'));_0x2ae446[_0xd121('0x39')]=_[_0xd121('0x3a')](_0x3e0ddb['query']);_0x2ae446[_0xd121('0x3b')]=_[_0xd121('0x3c')](_0x2ae446[_0xd121('0x3d')],_0x2ae446[_0xd121('0x39')]);_0x9a663d['attributes']=_['intersection'](_0x2ae446[_0xd121('0x3d')],qs['fields'](_0x3e0ddb[_0xd121('0x39')][_0xd121('0x3e')]));_0x9a663d[_0xd121('0x3f')]=_0x9a663d[_0xd121('0x3f')]['length']?_0x9a663d[_0xd121('0x3f')]:_0x2ae446['model'];if(!_0x3e0ddb['query'][_0xd121('0x40')](_0xd121('0x41'))){_0x9a663d[_0xd121('0x2b')]=qs[_0xd121('0x2b')](_0x3e0ddb[_0xd121('0x39')]['limit']);_0x9a663d[_0xd121('0x2a')]=qs['offset'](_0x3e0ddb[_0xd121('0x39')][_0xd121('0x2a')]);}_0x9a663d[_0xd121('0x42')]=qs[_0xd121('0x43')](_0x3e0ddb[_0xd121('0x39')][_0xd121('0x43')]);_0x9a663d['where']=qs[_0xd121('0x3b')](_[_0xd121('0x44')](_0x3e0ddb[_0xd121('0x39')],_0x2ae446[_0xd121('0x3b')]),_0x330c6e);if(_0x3e0ddb[_0xd121('0x39')][_0xd121('0x45')]){_0x9a663d[_0xd121('0x46')]=_['merge'](_0x9a663d[_0xd121('0x46')],{'$or':_[_0xd121('0x38')](_0x330c6e,function(_0x902ae1){if(_0x902ae1[_0xd121('0x47')]!==_0xd121('0x48')){var _0x19cfec={};_0x19cfec[_0x902ae1[_0xd121('0x33')]]={'$like':'%'+_0x3e0ddb[_0xd121('0x39')][_0xd121('0x45')]+'%'};return _0x19cfec;}})});}_0x9a663d=_[_0xd121('0x49')]({},_0x9a663d,_0x3e0ddb[_0xd121('0x4a')]);var _0x2c7236={'where':_0x9a663d['where']};return db[_0xd121('0x4b')]['count'](_0x2c7236)[_0xd121('0x1e')](function(_0x181f93){_0x1e031c[_0xd121('0x4c')]=_0x181f93;if(_0x3e0ddb[_0xd121('0x39')][_0xd121('0x4d')]){_0x9a663d[_0xd121('0x4e')]=[{'all':!![]}];}return db['FreshdeskConfiguration'][_0xd121('0x4f')](_0x9a663d);})[_0xd121('0x1e')](function(_0x1a211f){_0x1e031c[_0xd121('0x50')]=_0x1a211f;return _0x1e031c;})[_0xd121('0x1e')](respondWithFilteredResult(_0x51bb7e,_0x9a663d))[_0xd121('0x26')](handleError(_0x51bb7e,null));};exports[_0xd121('0x51')]=function(_0x1bb37e,_0x2dd49b){var _0x37d665={'raw':![],'where':{'id':_0x1bb37e[_0xd121('0x52')]['id']}},_0x552ad6={};_0x552ad6[_0xd121('0x3d')]=_[_0xd121('0x3a')](db[_0xd121('0x4b')][_0xd121('0x35')]);_0x552ad6[_0xd121('0x39')]=_[_0xd121('0x3a')](_0x1bb37e[_0xd121('0x39')]);_0x552ad6[_0xd121('0x3b')]=_['intersection'](_0x552ad6[_0xd121('0x3d')],_0x552ad6[_0xd121('0x39')]);_0x37d665[_0xd121('0x3f')]=_[_0xd121('0x3c')](_0x552ad6['model'],qs[_0xd121('0x3e')](_0x1bb37e[_0xd121('0x39')]['fields']));_0x37d665[_0xd121('0x3f')]=_0x37d665['attributes'][_0xd121('0x53')]?_0x37d665[_0xd121('0x3f')]:_0x552ad6[_0xd121('0x3d')];if(_0x1bb37e[_0xd121('0x39')][_0xd121('0x4d')]){_0x37d665[_0xd121('0x4e')]=[{'all':!![]}];}_0x37d665=_[_0xd121('0x49')]({},_0x37d665,_0x1bb37e[_0xd121('0x4a')]);return db['FreshdeskConfiguration']['find'](_0x37d665)[_0xd121('0x1e')](handleEntityNotFound(_0x2dd49b,null))[_0xd121('0x1e')](respondWithResult(_0x2dd49b,null))[_0xd121('0x26')](handleError(_0x2dd49b,null));};exports['create']=function(_0x473643,_0x4b33d4){return db[_0xd121('0x4b')][_0xd121('0x54')](_0x473643[_0xd121('0x55')],{})[_0xd121('0x1e')](respondWithResult(_0x4b33d4,0xc9))[_0xd121('0x26')](handleError(_0x4b33d4,null));};exports['update']=function(_0x76572b,_0x48101d){if(_0x76572b[_0xd121('0x55')]['id']){delete _0x76572b[_0xd121('0x55')]['id'];}return db[_0xd121('0x4b')][_0xd121('0x56')]({'where':{'id':_0x76572b['params']['id']}})[_0xd121('0x1e')](handleEntityNotFound(_0x48101d,null))['then'](saveUpdates(_0x76572b['body'],null))[_0xd121('0x1e')](respondWithResult(_0x48101d,null))[_0xd121('0x26')](handleError(_0x48101d,null));};exports['destroy']=function(_0x5404db,_0x487486){return db['FreshdeskConfiguration'][_0xd121('0x56')]({'where':{'id':_0x5404db[_0xd121('0x52')]['id']}})[_0xd121('0x1e')](handleEntityNotFound(_0x487486,null))[_0xd121('0x1e')](removeEntity(_0x487486,null))['catch'](handleError(_0x487486,null));};exports[_0xd121('0x57')]=function(_0x309c40,_0x59b1ca,_0x41d856){var _0x2bbf1e={};var _0x16dc1a={};var _0x42228d;var _0x152534;return db[_0xd121('0x4b')][_0xd121('0x58')]({'where':{'id':_0x309c40[_0xd121('0x52')]['id']}})[_0xd121('0x1e')](handleEntityNotFound(_0x59b1ca,null))['then'](function(_0x2ca462){if(_0x2ca462){_0x42228d=_0x2ca462;_0x16dc1a[_0xd121('0x3d')]=_[_0xd121('0x3a')](db[_0xd121('0x59')][_0xd121('0x35')]);_0x16dc1a[_0xd121('0x39')]=_['keys'](_0x309c40['query']);_0x16dc1a['filters']=_['intersection'](_0x16dc1a[_0xd121('0x3d')],_0x16dc1a[_0xd121('0x39')]);_0x2bbf1e[_0xd121('0x3f')]=_[_0xd121('0x3c')](_0x16dc1a[_0xd121('0x3d')],qs['fields'](_0x309c40['query'][_0xd121('0x3e')]));_0x2bbf1e[_0xd121('0x3f')]=_0x2bbf1e[_0xd121('0x3f')][_0xd121('0x53')]?_0x2bbf1e[_0xd121('0x3f')]:_0x16dc1a['model'];_0x2bbf1e['order']=qs['sort'](_0x309c40[_0xd121('0x39')][_0xd121('0x43')]);_0x2bbf1e['where']=qs[_0xd121('0x3b')](_[_0xd121('0x44')](_0x309c40['query'],_0x16dc1a[_0xd121('0x3b')]));if(_0x309c40[_0xd121('0x39')][_0xd121('0x45')]){_0x2bbf1e['where']=_[_0xd121('0x49')](_0x2bbf1e[_0xd121('0x46')],{'$or':_[_0xd121('0x38')](_0x2bbf1e[_0xd121('0x3f')],function(_0x53fa84){var _0x455721={};_0x455721[_0x53fa84]={'$like':'%'+_0x309c40[_0xd121('0x39')][_0xd121('0x45')]+'%'};return _0x455721;})});}_0x2bbf1e=_[_0xd121('0x49')]({},_0x2bbf1e,_0x309c40[_0xd121('0x4a')]);return _0x42228d['getFields'](_0x2bbf1e);}})['then'](function(_0x167481){if(_0x167481){_0x152534=_0x167481['length'];if(!_0x309c40[_0xd121('0x39')]['hasOwnProperty'](_0xd121('0x41'))){_0x2bbf1e['limit']=qs['limit'](_0x309c40[_0xd121('0x39')]['limit']);_0x2bbf1e[_0xd121('0x2a')]=qs[_0xd121('0x2a')](_0x309c40[_0xd121('0x39')][_0xd121('0x2a')]);}return _0x42228d[_0xd121('0x57')](_0x2bbf1e);}})[_0xd121('0x1e')](function(_0x33e163){if(_0x33e163){return _0x33e163?{'count':_0x152534,'rows':_0x33e163}:null;}})[_0xd121('0x1e')](respondWithResult(_0x59b1ca,null))[_0xd121('0x26')](handleError(_0x59b1ca,null));};exports[_0xd121('0x5a')]=function(_0x124699,_0x44c96c,_0x5d7a03){var _0x32aa37={};var _0x140e83={};var _0xe25631;var _0x4a099a;return db[_0xd121('0x4b')][_0xd121('0x58')]({'where':{'id':_0x124699[_0xd121('0x52')]['id']}})['then'](handleEntityNotFound(_0x44c96c,null))[_0xd121('0x1e')](function(_0x2b9343){if(_0x2b9343){_0xe25631=_0x2b9343;_0x140e83[_0xd121('0x3d')]=_[_0xd121('0x3a')](db[_0xd121('0x59')][_0xd121('0x35')]);_0x140e83['query']=_[_0xd121('0x3a')](_0x124699['query']);_0x140e83['filters']=_[_0xd121('0x3c')](_0x140e83[_0xd121('0x3d')],_0x140e83[_0xd121('0x39')]);_0x32aa37['attributes']=_[_0xd121('0x3c')](_0x140e83[_0xd121('0x3d')],qs[_0xd121('0x3e')](_0x124699[_0xd121('0x39')][_0xd121('0x3e')]));_0x32aa37[_0xd121('0x3f')]=_0x32aa37[_0xd121('0x3f')]['length']?_0x32aa37[_0xd121('0x3f')]:_0x140e83[_0xd121('0x3d')];_0x32aa37['order']=qs[_0xd121('0x43')](_0x124699[_0xd121('0x39')][_0xd121('0x43')]);_0x32aa37[_0xd121('0x46')]=qs[_0xd121('0x3b')](_[_0xd121('0x44')](_0x124699['query'],_0x140e83[_0xd121('0x3b')]));if(_0x124699[_0xd121('0x39')][_0xd121('0x45')]){_0x32aa37[_0xd121('0x46')]=_[_0xd121('0x49')](_0x32aa37['where'],{'$or':_[_0xd121('0x38')](_0x32aa37[_0xd121('0x3f')],function(_0x3ca264){var _0x5c2e7c={};_0x5c2e7c[_0x3ca264]={'$like':'%'+_0x124699[_0xd121('0x39')][_0xd121('0x45')]+'%'};return _0x5c2e7c;})});}_0x32aa37=_[_0xd121('0x49')]({},_0x32aa37,_0x124699['options']);return _0xe25631[_0xd121('0x5a')](_0x32aa37);}})[_0xd121('0x1e')](function(_0x235848){if(_0x235848){_0x4a099a=_0x235848[_0xd121('0x53')];if(!_0x124699[_0xd121('0x39')][_0xd121('0x40')](_0xd121('0x41'))){_0x32aa37[_0xd121('0x2b')]=qs[_0xd121('0x2b')](_0x124699[_0xd121('0x39')][_0xd121('0x2b')]);_0x32aa37[_0xd121('0x2a')]=qs[_0xd121('0x2a')](_0x124699[_0xd121('0x39')][_0xd121('0x2a')]);}return _0xe25631[_0xd121('0x5a')](_0x32aa37);}})['then'](function(_0x471bae){if(_0x471bae){return _0x471bae?{'count':_0x4a099a,'rows':_0x471bae}:null;}})[_0xd121('0x1e')](respondWithResult(_0x44c96c,null))[_0xd121('0x26')](handleError(_0x44c96c,null));};exports[_0xd121('0x5b')]=function(_0x152dc6,_0x4647a7,_0x1c557f){var _0x5c587e={};var _0x52c319={};var _0x31070f;var _0xda2926;return db[_0xd121('0x4b')][_0xd121('0x58')]({'where':{'id':_0x152dc6['params']['id']}})['then'](handleEntityNotFound(_0x4647a7,null))[_0xd121('0x1e')](function(_0xa3bfea){if(_0xa3bfea){_0x31070f=_0xa3bfea;_0x52c319['model']=_['keys'](db[_0xd121('0x59')][_0xd121('0x35')]);_0x52c319['query']=_['keys'](_0x152dc6[_0xd121('0x39')]);_0x52c319[_0xd121('0x3b')]=_[_0xd121('0x3c')](_0x52c319[_0xd121('0x3d')],_0x52c319[_0xd121('0x39')]);_0x5c587e[_0xd121('0x3f')]=_[_0xd121('0x3c')](_0x52c319[_0xd121('0x3d')],qs[_0xd121('0x3e')](_0x152dc6[_0xd121('0x39')][_0xd121('0x3e')]));_0x5c587e[_0xd121('0x3f')]=_0x5c587e['attributes'][_0xd121('0x53')]?_0x5c587e[_0xd121('0x3f')]:_0x52c319['model'];_0x5c587e[_0xd121('0x42')]=qs[_0xd121('0x43')](_0x152dc6[_0xd121('0x39')][_0xd121('0x43')]);_0x5c587e[_0xd121('0x46')]=qs[_0xd121('0x3b')](_[_0xd121('0x44')](_0x152dc6[_0xd121('0x39')],_0x52c319[_0xd121('0x3b')]));if(_0x152dc6['query']['filter']){_0x5c587e[_0xd121('0x46')]=_[_0xd121('0x49')](_0x5c587e[_0xd121('0x46')],{'$or':_[_0xd121('0x38')](_0x5c587e[_0xd121('0x3f')],function(_0x1668a3){var _0xa4a6b3={};_0xa4a6b3[_0x1668a3]={'$like':'%'+_0x152dc6[_0xd121('0x39')][_0xd121('0x45')]+'%'};return _0xa4a6b3;})});}_0x5c587e=_[_0xd121('0x49')]({},_0x5c587e,_0x152dc6[_0xd121('0x4a')]);return _0x31070f[_0xd121('0x5b')](_0x5c587e);}})[_0xd121('0x1e')](function(_0x15574c){if(_0x15574c){_0xda2926=_0x15574c[_0xd121('0x53')];if(!_0x152dc6[_0xd121('0x39')][_0xd121('0x40')](_0xd121('0x41'))){_0x5c587e['limit']=qs['limit'](_0x152dc6[_0xd121('0x39')][_0xd121('0x2b')]);_0x5c587e[_0xd121('0x2a')]=qs[_0xd121('0x2a')](_0x152dc6['query'][_0xd121('0x2a')]);}return _0x31070f[_0xd121('0x5b')](_0x5c587e);}})['then'](function(_0x4d2ac1){if(_0x4d2ac1){return _0x4d2ac1?{'count':_0xda2926,'rows':_0x4d2ac1}:null;}})[_0xd121('0x1e')](respondWithResult(_0x4647a7,null))[_0xd121('0x26')](handleError(_0x4647a7,null));};exports['getTags']=function(_0x246bb3,_0x354361,_0xcdcef3){var _0x2d48f9={};var _0x4fbf81={};var _0xccbf25;var _0x3271a6;return db[_0xd121('0x4b')][_0xd121('0x58')]({'where':{'id':_0x246bb3['params']['id']}})[_0xd121('0x1e')](handleEntityNotFound(_0x354361,null))[_0xd121('0x1e')](function(_0x11f4a1){if(_0x11f4a1){_0xccbf25=_0x11f4a1;_0x4fbf81['model']=_['keys'](db[_0xd121('0x5c')][_0xd121('0x35')]);_0x4fbf81[_0xd121('0x39')]=_['keys'](_0x246bb3[_0xd121('0x39')]);_0x4fbf81[_0xd121('0x3b')]=_[_0xd121('0x3c')](_0x4fbf81[_0xd121('0x3d')],_0x4fbf81['query']);_0x2d48f9[_0xd121('0x3f')]=_[_0xd121('0x3c')](_0x4fbf81[_0xd121('0x3d')],qs[_0xd121('0x3e')](_0x246bb3[_0xd121('0x39')][_0xd121('0x3e')]));_0x2d48f9[_0xd121('0x3f')]=_0x2d48f9[_0xd121('0x3f')][_0xd121('0x53')]?_0x2d48f9['attributes']:_0x4fbf81['model'];_0x2d48f9[_0xd121('0x42')]=qs[_0xd121('0x43')](_0x246bb3[_0xd121('0x39')][_0xd121('0x43')]);_0x2d48f9[_0xd121('0x46')]=qs[_0xd121('0x3b')](_[_0xd121('0x44')](_0x246bb3[_0xd121('0x39')],_0x4fbf81[_0xd121('0x3b')]));if(_0x246bb3[_0xd121('0x39')][_0xd121('0x45')]){_0x2d48f9[_0xd121('0x46')]=_['merge'](_0x2d48f9[_0xd121('0x46')],{'$or':_[_0xd121('0x38')](_0x2d48f9[_0xd121('0x3f')],function(_0x4949e8){var _0x4e29f5={};_0x4e29f5[_0x4949e8]={'$like':'%'+_0x246bb3['query'][_0xd121('0x45')]+'%'};return _0x4e29f5;})});}_0x2d48f9=_[_0xd121('0x49')]({},_0x2d48f9,_0x246bb3[_0xd121('0x4a')]);return _0xccbf25[_0xd121('0x5d')](_0x2d48f9);}})[_0xd121('0x1e')](function(_0x58eb96){if(_0x58eb96){_0x3271a6=_0x58eb96[_0xd121('0x53')];if(!_0x246bb3[_0xd121('0x39')][_0xd121('0x40')](_0xd121('0x41'))){_0x2d48f9[_0xd121('0x2b')]=qs['limit'](_0x246bb3[_0xd121('0x39')][_0xd121('0x2b')]);_0x2d48f9[_0xd121('0x2a')]=qs[_0xd121('0x2a')](_0x246bb3[_0xd121('0x39')][_0xd121('0x2a')]);}return _0xccbf25[_0xd121('0x5d')](_0x2d48f9);}})[_0xd121('0x1e')](function(_0x133077){if(_0x133077){return _0x133077?{'count':_0x3271a6,'rows':_0x133077}:null;}})['then'](respondWithResult(_0x354361,null))['catch'](handleError(_0x354361,null));};exports[_0xd121('0x5e')]=function(_0x314079,_0x43b5e3,_0x1e1d0c){if(_0x314079[_0xd121('0x55')]['id']){delete _0x314079['body']['id'];}return db[_0xd121('0x4b')][_0xd121('0x58')]({'where':{'id':_0x314079[_0xd121('0x52')]['id']}})['then'](handleEntityNotFound(_0x43b5e3,null))[_0xd121('0x1e')](function(_0x210956){if(_0x210956){return _0x210956[_0xd121('0x5e')](_0x314079['body'][_0xd121('0x5f')]||[]);}return null;})[_0xd121('0x1e')](respondWithResult(_0x43b5e3,null))[_0xd121('0x26')](handleError(_0x43b5e3,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