Built motion from commit (unavailable).|2.5.4
[motion2.git] / server / api / intFreshdeskConfiguration / intFreshdeskConfiguration.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 _0x0f16=['rawAttributes','find','create','body','getFields','where','findOne','FreshdeskField','getDescriptions','getTags','Tag','pick','setTags','ids','html-pdf','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','mustache','path','sox','to-csv','ejs','lodash','squel','crypto','desk.js','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','../../config/utils','../../config/environment','../../mysqldb','client','http','test','ValidationError','request','then','info','request\x20sent','debug','stringify','error','code','FreshdeskConfiguration,\x20%s,\x20%s','message','result','sendStatus','status','json','count','offset','set','Content-Range','apply','reject','save','update','destroy','name','send','index','map','FreshdeskConfiguration','type','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','order','sort','filter','merge','VIRTUAL','options','includeAll','include','findAll','rows','catch','show','params'];(function(_0x314105,_0x4134bd){var _0x4a1af2=function(_0x417b88){while(--_0x417b88){_0x314105['push'](_0x314105['shift']());}};_0x4a1af2(++_0x4134bd);}(_0x0f16,0x192));var _0x60f1=function(_0x2641f9,_0x26715f){_0x2641f9=_0x2641f9-0x0;var _0x585741=_0x0f16[_0x2641f9];return _0x585741;};'use strict';var pdf=require(_0x60f1('0x0'));var emlformat=require(_0x60f1('0x1'));var rimraf=require('rimraf');var zipdir=require(_0x60f1('0x2'));var jsonpatch=require(_0x60f1('0x3'));var rp=require(_0x60f1('0x4'));var moment=require(_0x60f1('0x5'));var BPromise=require(_0x60f1('0x6'));var Mustache=require(_0x60f1('0x7'));var util=require('util');var path=require(_0x60f1('0x8'));var sox=require(_0x60f1('0x9'));var csv=require(_0x60f1('0xa'));var ejs=require(_0x60f1('0xb'));var fs=require('fs');var _=require(_0x60f1('0xc'));var squel=require(_0x60f1('0xd'));var crypto=require(_0x60f1('0xe'));var jsforce=require('jsforce');var deskjs=require(_0x60f1('0xf'));var toCsv=require(_0x60f1('0xa'));var querystring=require(_0x60f1('0x10'));var Papa=require(_0x60f1('0x11'));var Redis=require(_0x60f1('0x12'));var authService=require(_0x60f1('0x13'));var qs=require('../../components/parsers/qs');var as=require(_0x60f1('0x14'));var hardwareService=require(_0x60f1('0x15'));var logger=require(_0x60f1('0x16'))('api');var utils=require(_0x60f1('0x17'));var config=require(_0x60f1('0x18'));var db=require(_0x60f1('0x19'))['db'];var jayson=require('jayson/promise');var client=jayson[_0x60f1('0x1a')][_0x60f1('0x1b')]({'port':0x232a});function checkPasswordPattern(_0x2da820,_0x1ddffe,_0x4a48ad){if(_0x4a48ad){var _0x4be0df=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x4be0df[_0x60f1('0x1c')](_0x1ddffe)){return _0x2da820;}else{throw new db['Sequelize'][(_0x60f1('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 _0x2da820;}}function respondWithRpcPromise(_0x2febfb,_0x59cad1,_0x806026,_0x147e5f){return new BPromise(function(_0x47cd3d,_0x511198){var _0x5d2e0d=_0x147e5f||client;return _0x5d2e0d[_0x60f1('0x1e')](_0x2febfb,_0x806026)[_0x60f1('0x1f')](function(_0x2ff9bf){logger[_0x60f1('0x20')]('FreshdeskConfiguration,\x20%s,\x20%s',_0x59cad1,_0x60f1('0x21'));logger[_0x60f1('0x22')]('FreshdeskConfiguration,\x20%s,\x20%s,\x20%s',_0x59cad1,'request\x20sent',JSON[_0x60f1('0x23')](_0x2ff9bf));if(_0x2ff9bf[_0x60f1('0x24')]){if(_0x2ff9bf[_0x60f1('0x24')][_0x60f1('0x25')]===0x1f4){logger[_0x60f1('0x24')](_0x60f1('0x26'),_0x59cad1,_0x2ff9bf[_0x60f1('0x24')]['message']);return _0x511198(_0x2ff9bf[_0x60f1('0x24')][_0x60f1('0x27')]);}logger[_0x60f1('0x24')](_0x60f1('0x26'),_0x59cad1,_0x2ff9bf['error'][_0x60f1('0x27')]);return _0x47cd3d(_0x2ff9bf['error']['message']);}else{logger[_0x60f1('0x20')](_0x60f1('0x26'),_0x59cad1,_0x60f1('0x21'));_0x47cd3d(_0x2ff9bf[_0x60f1('0x28')][_0x60f1('0x27')]);}})['catch'](function(_0x42ed74){logger[_0x60f1('0x24')](_0x60f1('0x26'),_0x59cad1,_0x42ed74);_0x511198(_0x42ed74);});});}function respondWithStatusCode(_0x4a6b5d,_0x2df145){_0x2df145=_0x2df145||0xcc;return function(_0x4534b4){if(_0x4534b4){return _0x4a6b5d[_0x60f1('0x29')](_0x2df145);}return _0x4a6b5d[_0x60f1('0x2a')](_0x2df145)['end']();};}function respondWithResult(_0x149b90,_0x4cab74){_0x4cab74=_0x4cab74||0xc8;return function(_0x57ed3d){if(_0x57ed3d){return _0x149b90[_0x60f1('0x2a')](_0x4cab74)[_0x60f1('0x2b')](_0x57ed3d);}};}function respondWithFilteredResult(_0x496a19,_0x2d383f){return function(_0x363571){if(_0x363571){var _0x51c21b=_0x363571[_0x60f1('0x2c')],_0x29189a=_0x2d383f[_0x60f1('0x2d')],_0x34d80a=_0x2d383f[_0x60f1('0x2d')]+_0x2d383f['limit'],_0x3146c3;if(_0x34d80a>=_0x51c21b){_0x34d80a=_0x51c21b;_0x3146c3=0xc8;}else{_0x3146c3=0xce;}_0x496a19[_0x60f1('0x2a')](_0x3146c3);return _0x496a19[_0x60f1('0x2e')](_0x60f1('0x2f'),_0x29189a+'-'+_0x34d80a+'/'+_0x51c21b)[_0x60f1('0x2b')](_0x363571);}return null;};}function patchUpdates(_0x414478){return function(_0x5bde9e){try{jsonpatch[_0x60f1('0x30')](_0x5bde9e,_0x414478,!![]);}catch(_0x1ce24c){return BPromise[_0x60f1('0x31')](_0x1ce24c);}return _0x5bde9e[_0x60f1('0x32')]();};}function saveUpdates(_0xadf236,_0x2374a2){return function(_0x3d78e4){if(_0x3d78e4){return _0x3d78e4[_0x60f1('0x33')](_0xadf236)['then'](function(_0x2d7ae7){return _0x2d7ae7;});}return null;};}function removeEntity(_0x2d2b45,_0x1e49f8){return function(_0x41140e){if(_0x41140e){return _0x41140e[_0x60f1('0x34')]()[_0x60f1('0x1f')](function(){_0x2d2b45['status'](0xcc)['end']();});}};}function handleEntityNotFound(_0x198799,_0xe9c9ea){return function(_0x31e9ae){if(!_0x31e9ae){_0x198799[_0x60f1('0x29')](0x194);}return _0x31e9ae;};}function handleError(_0x5342a7,_0x1e641d){_0x1e641d=_0x1e641d||0x1f4;return function(_0x262557){logger[_0x60f1('0x24')](_0x262557['stack']);if(_0x262557[_0x60f1('0x35')]){delete _0x262557[_0x60f1('0x35')];}_0x5342a7[_0x60f1('0x2a')](_0x1e641d)[_0x60f1('0x36')](_0x262557);};}exports[_0x60f1('0x37')]=function(_0x58a90b,_0x44b872){var _0x575b2c={},_0x4c895a={},_0x3ac269={'count':0x0,'rows':[]};var _0x340f74=_[_0x60f1('0x38')](db[_0x60f1('0x39')]['rawAttributes'],function(_0x24cdcd){return{'name':_0x24cdcd['fieldName'],'type':_0x24cdcd[_0x60f1('0x3a')]['key']};});_0x4c895a[_0x60f1('0x3b')]=_[_0x60f1('0x38')](_0x340f74,_0x60f1('0x35'));_0x4c895a[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0x58a90b['query']);_0x4c895a[_0x60f1('0x3e')]=_[_0x60f1('0x3f')](_0x4c895a[_0x60f1('0x3b')],_0x4c895a[_0x60f1('0x3c')]);_0x575b2c[_0x60f1('0x40')]=_[_0x60f1('0x3f')](_0x4c895a[_0x60f1('0x3b')],qs[_0x60f1('0x41')](_0x58a90b[_0x60f1('0x3c')][_0x60f1('0x41')]));_0x575b2c[_0x60f1('0x40')]=_0x575b2c[_0x60f1('0x40')][_0x60f1('0x42')]?_0x575b2c[_0x60f1('0x40')]:_0x4c895a[_0x60f1('0x3b')];if(!_0x58a90b['query'][_0x60f1('0x43')](_0x60f1('0x44'))){_0x575b2c[_0x60f1('0x45')]=qs[_0x60f1('0x45')](_0x58a90b[_0x60f1('0x3c')]['limit']);_0x575b2c[_0x60f1('0x2d')]=qs['offset'](_0x58a90b['query'][_0x60f1('0x2d')]);}_0x575b2c[_0x60f1('0x46')]=qs[_0x60f1('0x47')](_0x58a90b[_0x60f1('0x3c')][_0x60f1('0x47')]);_0x575b2c['where']=qs[_0x60f1('0x3e')](_['pick'](_0x58a90b[_0x60f1('0x3c')],_0x4c895a[_0x60f1('0x3e')]),_0x340f74);if(_0x58a90b[_0x60f1('0x3c')][_0x60f1('0x48')]){_0x575b2c['where']=_[_0x60f1('0x49')](_0x575b2c['where'],{'$or':_['map'](_0x340f74,function(_0x55f347){if(_0x55f347['type']!==_0x60f1('0x4a')){var _0x4f7938={};_0x4f7938[_0x55f347['name']]={'$like':'%'+_0x58a90b[_0x60f1('0x3c')][_0x60f1('0x48')]+'%'};return _0x4f7938;}})});}_0x575b2c=_['merge']({},_0x575b2c,_0x58a90b[_0x60f1('0x4b')]);var _0x15758e={'where':_0x575b2c['where']};return db[_0x60f1('0x39')][_0x60f1('0x2c')](_0x15758e)[_0x60f1('0x1f')](function(_0x1a94d1){_0x3ac269['count']=_0x1a94d1;if(_0x58a90b['query'][_0x60f1('0x4c')]){_0x575b2c[_0x60f1('0x4d')]=[{'all':!![]}];}return db[_0x60f1('0x39')][_0x60f1('0x4e')](_0x575b2c);})['then'](function(_0x5dfd0a){_0x3ac269[_0x60f1('0x4f')]=_0x5dfd0a;return _0x3ac269;})[_0x60f1('0x1f')](respondWithFilteredResult(_0x44b872,_0x575b2c))[_0x60f1('0x50')](handleError(_0x44b872,null));};exports[_0x60f1('0x51')]=function(_0xb477ce,_0x2fe6de){var _0x560d7a={'raw':![],'where':{'id':_0xb477ce[_0x60f1('0x52')]['id']}},_0x194bd8={};_0x194bd8[_0x60f1('0x3b')]=_[_0x60f1('0x3d')](db[_0x60f1('0x39')][_0x60f1('0x53')]);_0x194bd8[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0xb477ce['query']);_0x194bd8[_0x60f1('0x3e')]=_[_0x60f1('0x3f')](_0x194bd8[_0x60f1('0x3b')],_0x194bd8[_0x60f1('0x3c')]);_0x560d7a[_0x60f1('0x40')]=_['intersection'](_0x194bd8['model'],qs['fields'](_0xb477ce[_0x60f1('0x3c')][_0x60f1('0x41')]));_0x560d7a[_0x60f1('0x40')]=_0x560d7a[_0x60f1('0x40')]['length']?_0x560d7a[_0x60f1('0x40')]:_0x194bd8[_0x60f1('0x3b')];if(_0xb477ce[_0x60f1('0x3c')]['includeAll']){_0x560d7a['include']=[{'all':!![]}];}_0x560d7a=_['merge']({},_0x560d7a,_0xb477ce[_0x60f1('0x4b')]);return db[_0x60f1('0x39')][_0x60f1('0x54')](_0x560d7a)[_0x60f1('0x1f')](handleEntityNotFound(_0x2fe6de,null))[_0x60f1('0x1f')](respondWithResult(_0x2fe6de,null))[_0x60f1('0x50')](handleError(_0x2fe6de,null));};exports['create']=function(_0x5dcb55,_0x5578d8){return db['FreshdeskConfiguration'][_0x60f1('0x55')](_0x5dcb55[_0x60f1('0x56')],{})[_0x60f1('0x1f')](respondWithResult(_0x5578d8,0xc9))[_0x60f1('0x50')](handleError(_0x5578d8,null));};exports[_0x60f1('0x33')]=function(_0x791e53,_0x1dc807){if(_0x791e53[_0x60f1('0x56')]['id']){delete _0x791e53[_0x60f1('0x56')]['id'];}return db['FreshdeskConfiguration']['find']({'where':{'id':_0x791e53[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x1dc807,null))['then'](saveUpdates(_0x791e53[_0x60f1('0x56')],null))[_0x60f1('0x1f')](respondWithResult(_0x1dc807,null))[_0x60f1('0x50')](handleError(_0x1dc807,null));};exports[_0x60f1('0x34')]=function(_0x41e558,_0x503e1e){return db[_0x60f1('0x39')][_0x60f1('0x54')]({'where':{'id':_0x41e558[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x503e1e,null))[_0x60f1('0x1f')](removeEntity(_0x503e1e,null))[_0x60f1('0x50')](handleError(_0x503e1e,null));};exports[_0x60f1('0x57')]=function(_0x5e0756,_0x400678,_0x56bed2){var _0x38c781={};var _0x4d6229={};var _0x369aae;var _0x11ec1f;return db[_0x60f1('0x39')]['findOne']({'where':{'id':_0x5e0756[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x400678,null))[_0x60f1('0x1f')](function(_0x49357b){if(_0x49357b){_0x369aae=_0x49357b;_0x4d6229[_0x60f1('0x3b')]=_['keys'](db['FreshdeskField'][_0x60f1('0x53')]);_0x4d6229[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0x5e0756[_0x60f1('0x3c')]);_0x4d6229[_0x60f1('0x3e')]=_['intersection'](_0x4d6229[_0x60f1('0x3b')],_0x4d6229[_0x60f1('0x3c')]);_0x38c781[_0x60f1('0x40')]=_[_0x60f1('0x3f')](_0x4d6229[_0x60f1('0x3b')],qs['fields'](_0x5e0756[_0x60f1('0x3c')][_0x60f1('0x41')]));_0x38c781[_0x60f1('0x40')]=_0x38c781[_0x60f1('0x40')][_0x60f1('0x42')]?_0x38c781[_0x60f1('0x40')]:_0x4d6229[_0x60f1('0x3b')];_0x38c781[_0x60f1('0x46')]=qs[_0x60f1('0x47')](_0x5e0756[_0x60f1('0x3c')][_0x60f1('0x47')]);_0x38c781['where']=qs[_0x60f1('0x3e')](_['pick'](_0x5e0756[_0x60f1('0x3c')],_0x4d6229[_0x60f1('0x3e')]));if(_0x5e0756[_0x60f1('0x3c')]['filter']){_0x38c781[_0x60f1('0x58')]=_[_0x60f1('0x49')](_0x38c781[_0x60f1('0x58')],{'$or':_[_0x60f1('0x38')](_0x38c781[_0x60f1('0x40')],function(_0x1a70b1){var _0x2f3b47={};_0x2f3b47[_0x1a70b1]={'$like':'%'+_0x5e0756['query'][_0x60f1('0x48')]+'%'};return _0x2f3b47;})});}_0x38c781=_[_0x60f1('0x49')]({},_0x38c781,_0x5e0756[_0x60f1('0x4b')]);return _0x369aae[_0x60f1('0x57')](_0x38c781);}})[_0x60f1('0x1f')](function(_0x4dd48d){if(_0x4dd48d){_0x11ec1f=_0x4dd48d[_0x60f1('0x42')];if(!_0x5e0756['query'][_0x60f1('0x43')]('nolimit')){_0x38c781[_0x60f1('0x45')]=qs[_0x60f1('0x45')](_0x5e0756[_0x60f1('0x3c')]['limit']);_0x38c781[_0x60f1('0x2d')]=qs['offset'](_0x5e0756[_0x60f1('0x3c')]['offset']);}return _0x369aae['getFields'](_0x38c781);}})[_0x60f1('0x1f')](function(_0x49608e){if(_0x49608e){return _0x49608e?{'count':_0x11ec1f,'rows':_0x49608e}:null;}})['then'](respondWithResult(_0x400678,null))[_0x60f1('0x50')](handleError(_0x400678,null));};exports['getSubjects']=function(_0x31e895,_0x5d84b5,_0x2e324c){var _0xc93ccd={};var _0x528a84={};var _0x244ade;var _0x5f3dea;return db[_0x60f1('0x39')][_0x60f1('0x59')]({'where':{'id':_0x31e895['params']['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x5d84b5,null))[_0x60f1('0x1f')](function(_0x3c24be){if(_0x3c24be){_0x244ade=_0x3c24be;_0x528a84[_0x60f1('0x3b')]=_[_0x60f1('0x3d')](db[_0x60f1('0x5a')][_0x60f1('0x53')]);_0x528a84[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0x31e895[_0x60f1('0x3c')]);_0x528a84['filters']=_[_0x60f1('0x3f')](_0x528a84[_0x60f1('0x3b')],_0x528a84['query']);_0xc93ccd[_0x60f1('0x40')]=_[_0x60f1('0x3f')](_0x528a84['model'],qs[_0x60f1('0x41')](_0x31e895[_0x60f1('0x3c')]['fields']));_0xc93ccd[_0x60f1('0x40')]=_0xc93ccd[_0x60f1('0x40')][_0x60f1('0x42')]?_0xc93ccd[_0x60f1('0x40')]:_0x528a84['model'];_0xc93ccd[_0x60f1('0x46')]=qs['sort'](_0x31e895['query']['sort']);_0xc93ccd[_0x60f1('0x58')]=qs['filters'](_['pick'](_0x31e895['query'],_0x528a84[_0x60f1('0x3e')]));if(_0x31e895[_0x60f1('0x3c')][_0x60f1('0x48')]){_0xc93ccd[_0x60f1('0x58')]=_[_0x60f1('0x49')](_0xc93ccd['where'],{'$or':_[_0x60f1('0x38')](_0xc93ccd['attributes'],function(_0x14d62b){var _0x4351e0={};_0x4351e0[_0x14d62b]={'$like':'%'+_0x31e895[_0x60f1('0x3c')][_0x60f1('0x48')]+'%'};return _0x4351e0;})});}_0xc93ccd=_[_0x60f1('0x49')]({},_0xc93ccd,_0x31e895['options']);return _0x244ade['getSubjects'](_0xc93ccd);}})['then'](function(_0x5b37ec){if(_0x5b37ec){_0x5f3dea=_0x5b37ec[_0x60f1('0x42')];if(!_0x31e895['query']['hasOwnProperty'](_0x60f1('0x44'))){_0xc93ccd[_0x60f1('0x45')]=qs[_0x60f1('0x45')](_0x31e895[_0x60f1('0x3c')][_0x60f1('0x45')]);_0xc93ccd[_0x60f1('0x2d')]=qs[_0x60f1('0x2d')](_0x31e895['query']['offset']);}return _0x244ade['getSubjects'](_0xc93ccd);}})[_0x60f1('0x1f')](function(_0x43dbfa){if(_0x43dbfa){return _0x43dbfa?{'count':_0x5f3dea,'rows':_0x43dbfa}:null;}})[_0x60f1('0x1f')](respondWithResult(_0x5d84b5,null))[_0x60f1('0x50')](handleError(_0x5d84b5,null));};exports[_0x60f1('0x5b')]=function(_0x1b63d2,_0x5479f5,_0x42681a){var _0x1863ed={};var _0x5d0da9={};var _0x12d4ad;var _0x24c75e;return db['FreshdeskConfiguration'][_0x60f1('0x59')]({'where':{'id':_0x1b63d2[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x5479f5,null))[_0x60f1('0x1f')](function(_0x329b40){if(_0x329b40){_0x12d4ad=_0x329b40;_0x5d0da9[_0x60f1('0x3b')]=_['keys'](db[_0x60f1('0x5a')][_0x60f1('0x53')]);_0x5d0da9[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0x1b63d2[_0x60f1('0x3c')]);_0x5d0da9['filters']=_['intersection'](_0x5d0da9['model'],_0x5d0da9[_0x60f1('0x3c')]);_0x1863ed[_0x60f1('0x40')]=_[_0x60f1('0x3f')](_0x5d0da9[_0x60f1('0x3b')],qs['fields'](_0x1b63d2['query'][_0x60f1('0x41')]));_0x1863ed[_0x60f1('0x40')]=_0x1863ed['attributes']['length']?_0x1863ed[_0x60f1('0x40')]:_0x5d0da9[_0x60f1('0x3b')];_0x1863ed[_0x60f1('0x46')]=qs[_0x60f1('0x47')](_0x1b63d2[_0x60f1('0x3c')][_0x60f1('0x47')]);_0x1863ed['where']=qs[_0x60f1('0x3e')](_['pick'](_0x1b63d2[_0x60f1('0x3c')],_0x5d0da9['filters']));if(_0x1b63d2[_0x60f1('0x3c')]['filter']){_0x1863ed[_0x60f1('0x58')]=_[_0x60f1('0x49')](_0x1863ed[_0x60f1('0x58')],{'$or':_[_0x60f1('0x38')](_0x1863ed['attributes'],function(_0x27e704){var _0x361aaf={};_0x361aaf[_0x27e704]={'$like':'%'+_0x1b63d2[_0x60f1('0x3c')][_0x60f1('0x48')]+'%'};return _0x361aaf;})});}_0x1863ed=_[_0x60f1('0x49')]({},_0x1863ed,_0x1b63d2[_0x60f1('0x4b')]);return _0x12d4ad[_0x60f1('0x5b')](_0x1863ed);}})[_0x60f1('0x1f')](function(_0xa1462b){if(_0xa1462b){_0x24c75e=_0xa1462b[_0x60f1('0x42')];if(!_0x1b63d2['query'][_0x60f1('0x43')]('nolimit')){_0x1863ed[_0x60f1('0x45')]=qs['limit'](_0x1b63d2['query'][_0x60f1('0x45')]);_0x1863ed[_0x60f1('0x2d')]=qs[_0x60f1('0x2d')](_0x1b63d2['query']['offset']);}return _0x12d4ad['getDescriptions'](_0x1863ed);}})['then'](function(_0x3bfa31){if(_0x3bfa31){return _0x3bfa31?{'count':_0x24c75e,'rows':_0x3bfa31}:null;}})[_0x60f1('0x1f')](respondWithResult(_0x5479f5,null))[_0x60f1('0x50')](handleError(_0x5479f5,null));};exports[_0x60f1('0x5c')]=function(_0x113d4d,_0x58d61f,_0x384d21){var _0xd8f082={};var _0x52ff3b={};var _0x250555;var _0x533e74;return db[_0x60f1('0x39')][_0x60f1('0x59')]({'where':{'id':_0x113d4d[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x58d61f,null))[_0x60f1('0x1f')](function(_0x4dcde6){if(_0x4dcde6){_0x250555=_0x4dcde6;_0x52ff3b['model']=_[_0x60f1('0x3d')](db[_0x60f1('0x5d')]['rawAttributes']);_0x52ff3b[_0x60f1('0x3c')]=_[_0x60f1('0x3d')](_0x113d4d['query']);_0x52ff3b[_0x60f1('0x3e')]=_['intersection'](_0x52ff3b[_0x60f1('0x3b')],_0x52ff3b[_0x60f1('0x3c')]);_0xd8f082[_0x60f1('0x40')]=_[_0x60f1('0x3f')](_0x52ff3b[_0x60f1('0x3b')],qs['fields'](_0x113d4d[_0x60f1('0x3c')][_0x60f1('0x41')]));_0xd8f082['attributes']=_0xd8f082[_0x60f1('0x40')][_0x60f1('0x42')]?_0xd8f082[_0x60f1('0x40')]:_0x52ff3b['model'];_0xd8f082[_0x60f1('0x46')]=qs[_0x60f1('0x47')](_0x113d4d[_0x60f1('0x3c')]['sort']);_0xd8f082[_0x60f1('0x58')]=qs[_0x60f1('0x3e')](_[_0x60f1('0x5e')](_0x113d4d[_0x60f1('0x3c')],_0x52ff3b[_0x60f1('0x3e')]));if(_0x113d4d['query'][_0x60f1('0x48')]){_0xd8f082[_0x60f1('0x58')]=_[_0x60f1('0x49')](_0xd8f082[_0x60f1('0x58')],{'$or':_[_0x60f1('0x38')](_0xd8f082[_0x60f1('0x40')],function(_0xaa1745){var _0xa4cf0e={};_0xa4cf0e[_0xaa1745]={'$like':'%'+_0x113d4d['query'][_0x60f1('0x48')]+'%'};return _0xa4cf0e;})});}_0xd8f082=_['merge']({},_0xd8f082,_0x113d4d[_0x60f1('0x4b')]);return _0x250555[_0x60f1('0x5c')](_0xd8f082);}})[_0x60f1('0x1f')](function(_0xe61f64){if(_0xe61f64){_0x533e74=_0xe61f64['length'];if(!_0x113d4d[_0x60f1('0x3c')][_0x60f1('0x43')](_0x60f1('0x44'))){_0xd8f082[_0x60f1('0x45')]=qs[_0x60f1('0x45')](_0x113d4d[_0x60f1('0x3c')][_0x60f1('0x45')]);_0xd8f082['offset']=qs[_0x60f1('0x2d')](_0x113d4d[_0x60f1('0x3c')][_0x60f1('0x2d')]);}return _0x250555[_0x60f1('0x5c')](_0xd8f082);}})['then'](function(_0xae4d7e){if(_0xae4d7e){return _0xae4d7e?{'count':_0x533e74,'rows':_0xae4d7e}:null;}})[_0x60f1('0x1f')](respondWithResult(_0x58d61f,null))[_0x60f1('0x50')](handleError(_0x58d61f,null));};exports[_0x60f1('0x5f')]=function(_0x25df50,_0x163099,_0x3da39e){if(_0x25df50[_0x60f1('0x56')]['id']){delete _0x25df50[_0x60f1('0x56')]['id'];}return db['FreshdeskConfiguration'][_0x60f1('0x59')]({'where':{'id':_0x25df50[_0x60f1('0x52')]['id']}})[_0x60f1('0x1f')](handleEntityNotFound(_0x163099,null))[_0x60f1('0x1f')](function(_0x4315f9){if(_0x4315f9){return _0x4315f9[_0x60f1('0x5f')](_0x25df50[_0x60f1('0x56')][_0x60f1('0x60')]||[]);}return null;})[_0x60f1('0x1f')](respondWithResult(_0x163099,null))['catch'](handleError(_0x163099,null));};