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 _0x9efa=['zip-dir','fast-json-patch','moment','mustache','path','to-csv','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','api','../../config/utils','../../config/environment','sendStatus','status','offset','undefined','limit','count','set','Content-Range','json','apply','save','update','destroy','then','end','error','name','send','index','map','FreshdeskConfiguration','rawAttributes','fieldName','type','key','model','query','keys','intersection','attributes','fields','length','nolimit','sort','where','filters','filter','VIRTUAL','merge','options','include','findAll','rows','catch','show','params','includeAll','find','create','body','getFields','findOne','FreshdeskField','order','pick','hasOwnProperty','getSubjects','getDescriptions','getTags','Tag','setTags','ids','eml-format'];(function(_0x4c4d07,_0x48512b){var _0x278851=function(_0x507727){while(--_0x507727){_0x4c4d07['push'](_0x4c4d07['shift']());}};_0x278851(++_0x48512b);}(_0x9efa,0xa7));var _0xa9ef=function(_0x20a584,_0xe384a5){_0x20a584=_0x20a584-0x0;var _0x4b41a8=_0x9efa[_0x20a584];return _0x4b41a8;};'use strict';var emlformat=require(_0xa9ef('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xa9ef('0x1'));var jsonpatch=require(_0xa9ef('0x2'));var rp=require('request-promise');var moment=require(_0xa9ef('0x3'));var BPromise=require('bluebird');var Mustache=require(_0xa9ef('0x4'));var util=require('util');var path=require(_0xa9ef('0x5'));var sox=require('sox');var csv=require(_0xa9ef('0x6'));var ejs=require(_0xa9ef('0x7'));var fs=require('fs');var fs_extra=require(_0xa9ef('0x8'));var _=require(_0xa9ef('0x9'));var squel=require(_0xa9ef('0xa'));var crypto=require(_0xa9ef('0xb'));var jsforce=require(_0xa9ef('0xc'));var deskjs=require(_0xa9ef('0xd'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xa9ef('0xe'));var Redis=require(_0xa9ef('0xf'));var authService=require('../../components/auth/service');var qs=require(_0xa9ef('0x10'));var as=require(_0xa9ef('0x11'));var hardwareService=require('../../config/license/hardware');var logger=require(_0xa9ef('0x12'))(_0xa9ef('0x13'));var utils=require(_0xa9ef('0x14'));var config=require(_0xa9ef('0x15'));var licenseUtil=require('../../config/license/util');var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0xf1b880,_0x51ef14){_0x51ef14=_0x51ef14||0xcc;return function(_0x35e5ae){if(_0x35e5ae){return _0xf1b880[_0xa9ef('0x16')](_0x51ef14);}return _0xf1b880[_0xa9ef('0x17')](_0x51ef14)['end']();};}function respondWithResult(_0x2945d5,_0x4dd77c){_0x4dd77c=_0x4dd77c||0xc8;return function(_0x1c528b){if(_0x1c528b){return _0x2945d5['status'](_0x4dd77c)['json'](_0x1c528b);}};}function respondWithFilteredResult(_0x5908a8,_0x310ba0){return function(_0x5d6737){if(_0x5d6737){var _0x2fb89a=typeof _0x310ba0[_0xa9ef('0x18')]===_0xa9ef('0x19')&&typeof _0x310ba0[_0xa9ef('0x1a')]===_0xa9ef('0x19');var _0x1b52e4=_0x5d6737[_0xa9ef('0x1b')];var _0x31cd26=_0x2fb89a?0x0:_0x310ba0[_0xa9ef('0x18')];var _0x245912=_0x2fb89a?_0x5d6737[_0xa9ef('0x1b')]:_0x310ba0[_0xa9ef('0x18')]+_0x310ba0[_0xa9ef('0x1a')];var _0x31f07d;if(_0x245912>=_0x1b52e4){_0x245912=_0x1b52e4;_0x31f07d=0xc8;}else{_0x31f07d=0xce;}_0x5908a8[_0xa9ef('0x17')](_0x31f07d);return _0x5908a8[_0xa9ef('0x1c')](_0xa9ef('0x1d'),_0x31cd26+'-'+_0x245912+'/'+_0x1b52e4)[_0xa9ef('0x1e')](_0x5d6737);}return null;};}function patchUpdates(_0x53abde){return function(_0x682947){try{jsonpatch[_0xa9ef('0x1f')](_0x682947,_0x53abde,!![]);}catch(_0x1ab717){return BPromise['reject'](_0x1ab717);}return _0x682947[_0xa9ef('0x20')]();};}function saveUpdates(_0x2fa23d,_0x23bd2c){return function(_0x25215b){if(_0x25215b){return _0x25215b[_0xa9ef('0x21')](_0x2fa23d)['then'](function(_0x359969){return _0x359969;});}return null;};}function removeEntity(_0x3c6d65,_0x5b2322){return function(_0x3225e7){if(_0x3225e7){return _0x3225e7[_0xa9ef('0x22')]()[_0xa9ef('0x23')](function(){_0x3c6d65[_0xa9ef('0x17')](0xcc)[_0xa9ef('0x24')]();});}};}function handleEntityNotFound(_0x3e5aac,_0x186fd3){return function(_0x4250d2){if(!_0x4250d2){_0x3e5aac[_0xa9ef('0x16')](0x194);}return _0x4250d2;};}function handleError(_0x5308fe,_0x2a3275){_0x2a3275=_0x2a3275||0x1f4;return function(_0x4a3200){logger[_0xa9ef('0x25')](_0x4a3200['stack']);if(_0x4a3200[_0xa9ef('0x26')]){delete _0x4a3200[_0xa9ef('0x26')];}_0x5308fe[_0xa9ef('0x17')](_0x2a3275)[_0xa9ef('0x27')](_0x4a3200);};}exports[_0xa9ef('0x28')]=function(_0x5a0c7f,_0x3a7d65){var _0x364189={},_0x3675bd={},_0x40d0e4={'count':0x0,'rows':[]};var _0x3358f3=_[_0xa9ef('0x29')](db[_0xa9ef('0x2a')][_0xa9ef('0x2b')],function(_0xcac25){return{'name':_0xcac25[_0xa9ef('0x2c')],'type':_0xcac25[_0xa9ef('0x2d')][_0xa9ef('0x2e')]};});_0x3675bd[_0xa9ef('0x2f')]=_[_0xa9ef('0x29')](_0x3358f3,_0xa9ef('0x26'));_0x3675bd[_0xa9ef('0x30')]=_[_0xa9ef('0x31')](_0x5a0c7f[_0xa9ef('0x30')]);_0x3675bd['filters']=_[_0xa9ef('0x32')](_0x3675bd['model'],_0x3675bd[_0xa9ef('0x30')]);_0x364189[_0xa9ef('0x33')]=_[_0xa9ef('0x32')](_0x3675bd[_0xa9ef('0x2f')],qs[_0xa9ef('0x34')](_0x5a0c7f[_0xa9ef('0x30')][_0xa9ef('0x34')]));_0x364189['attributes']=_0x364189[_0xa9ef('0x33')][_0xa9ef('0x35')]?_0x364189[_0xa9ef('0x33')]:_0x3675bd[_0xa9ef('0x2f')];if(!_0x5a0c7f[_0xa9ef('0x30')]['hasOwnProperty'](_0xa9ef('0x36'))){_0x364189[_0xa9ef('0x1a')]=qs[_0xa9ef('0x1a')](_0x5a0c7f[_0xa9ef('0x30')][_0xa9ef('0x1a')]);_0x364189[_0xa9ef('0x18')]=qs[_0xa9ef('0x18')](_0x5a0c7f['query'][_0xa9ef('0x18')]);}_0x364189['order']=qs[_0xa9ef('0x37')](_0x5a0c7f[_0xa9ef('0x30')]['sort']);_0x364189[_0xa9ef('0x38')]=qs['filters'](_['pick'](_0x5a0c7f[_0xa9ef('0x30')],_0x3675bd[_0xa9ef('0x39')]),_0x3358f3);if(_0x5a0c7f[_0xa9ef('0x30')][_0xa9ef('0x3a')]){_0x364189[_0xa9ef('0x38')]=_['merge'](_0x364189[_0xa9ef('0x38')],{'$or':_['map'](_0x3358f3,function(_0x1c4d5f){if(_0x1c4d5f[_0xa9ef('0x2d')]!==_0xa9ef('0x3b')){var _0x436eb1={};_0x436eb1[_0x1c4d5f[_0xa9ef('0x26')]]={'$like':'%'+_0x5a0c7f['query'][_0xa9ef('0x3a')]+'%'};return _0x436eb1;}})});}_0x364189=_[_0xa9ef('0x3c')]({},_0x364189,_0x5a0c7f[_0xa9ef('0x3d')]);var _0x3e8353={'where':_0x364189[_0xa9ef('0x38')]};return db[_0xa9ef('0x2a')][_0xa9ef('0x1b')](_0x3e8353)[_0xa9ef('0x23')](function(_0x3ccf47){_0x40d0e4[_0xa9ef('0x1b')]=_0x3ccf47;if(_0x5a0c7f[_0xa9ef('0x30')]['includeAll']){_0x364189[_0xa9ef('0x3e')]=[{'all':!![]}];}return db[_0xa9ef('0x2a')][_0xa9ef('0x3f')](_0x364189);})['then'](function(_0x1dfd81){_0x40d0e4[_0xa9ef('0x40')]=_0x1dfd81;return _0x40d0e4;})[_0xa9ef('0x23')](respondWithFilteredResult(_0x3a7d65,_0x364189))[_0xa9ef('0x41')](handleError(_0x3a7d65,null));};exports[_0xa9ef('0x42')]=function(_0xf23ba5,_0x349946){var _0x2f209={'raw':![],'where':{'id':_0xf23ba5[_0xa9ef('0x43')]['id']}},_0x4e852b={};_0x4e852b[_0xa9ef('0x2f')]=_[_0xa9ef('0x31')](db[_0xa9ef('0x2a')]['rawAttributes']);_0x4e852b[_0xa9ef('0x30')]=_[_0xa9ef('0x31')](_0xf23ba5[_0xa9ef('0x30')]);_0x4e852b[_0xa9ef('0x39')]=_['intersection'](_0x4e852b[_0xa9ef('0x2f')],_0x4e852b['query']);_0x2f209[_0xa9ef('0x33')]=_[_0xa9ef('0x32')](_0x4e852b[_0xa9ef('0x2f')],qs[_0xa9ef('0x34')](_0xf23ba5[_0xa9ef('0x30')][_0xa9ef('0x34')]));_0x2f209[_0xa9ef('0x33')]=_0x2f209['attributes'][_0xa9ef('0x35')]?_0x2f209[_0xa9ef('0x33')]:_0x4e852b[_0xa9ef('0x2f')];if(_0xf23ba5[_0xa9ef('0x30')][_0xa9ef('0x44')]){_0x2f209[_0xa9ef('0x3e')]=[{'all':!![]}];}_0x2f209=_['merge']({},_0x2f209,_0xf23ba5[_0xa9ef('0x3d')]);return db[_0xa9ef('0x2a')][_0xa9ef('0x45')](_0x2f209)['then'](handleEntityNotFound(_0x349946,null))[_0xa9ef('0x23')](respondWithResult(_0x349946,null))[_0xa9ef('0x41')](handleError(_0x349946,null));};exports[_0xa9ef('0x46')]=function(_0x5369ce,_0x277216){return db[_0xa9ef('0x2a')][_0xa9ef('0x46')](_0x5369ce[_0xa9ef('0x47')],{})[_0xa9ef('0x23')](respondWithResult(_0x277216,0xc9))[_0xa9ef('0x41')](handleError(_0x277216,null));};exports[_0xa9ef('0x21')]=function(_0x2a6151,_0x566a3f){if(_0x2a6151[_0xa9ef('0x47')]['id']){delete _0x2a6151[_0xa9ef('0x47')]['id'];}return db[_0xa9ef('0x2a')][_0xa9ef('0x45')]({'where':{'id':_0x2a6151[_0xa9ef('0x43')]['id']}})['then'](handleEntityNotFound(_0x566a3f,null))[_0xa9ef('0x23')](saveUpdates(_0x2a6151['body'],null))['then'](respondWithResult(_0x566a3f,null))[_0xa9ef('0x41')](handleError(_0x566a3f,null));};exports[_0xa9ef('0x22')]=function(_0x572b18,_0x3de9f7){return db['FreshdeskConfiguration']['find']({'where':{'id':_0x572b18['params']['id']}})[_0xa9ef('0x23')](handleEntityNotFound(_0x3de9f7,null))[_0xa9ef('0x23')](removeEntity(_0x3de9f7,null))[_0xa9ef('0x41')](handleError(_0x3de9f7,null));};exports[_0xa9ef('0x48')]=function(_0x2587a2,_0x25daf4,_0x17486e){var _0xec5568={};var _0x1ad8b0={};var _0x5b763e;var _0x1ce460;return db[_0xa9ef('0x2a')][_0xa9ef('0x49')]({'where':{'id':_0x2587a2[_0xa9ef('0x43')]['id']}})[_0xa9ef('0x23')](handleEntityNotFound(_0x25daf4,null))['then'](function(_0x44ec25){if(_0x44ec25){_0x5b763e=_0x44ec25;_0x1ad8b0[_0xa9ef('0x2f')]=_['keys'](db[_0xa9ef('0x4a')][_0xa9ef('0x2b')]);_0x1ad8b0['query']=_[_0xa9ef('0x31')](_0x2587a2['query']);_0x1ad8b0[_0xa9ef('0x39')]=_['intersection'](_0x1ad8b0[_0xa9ef('0x2f')],_0x1ad8b0[_0xa9ef('0x30')]);_0xec5568[_0xa9ef('0x33')]=_[_0xa9ef('0x32')](_0x1ad8b0[_0xa9ef('0x2f')],qs['fields'](_0x2587a2[_0xa9ef('0x30')][_0xa9ef('0x34')]));_0xec5568[_0xa9ef('0x33')]=_0xec5568[_0xa9ef('0x33')]['length']?_0xec5568[_0xa9ef('0x33')]:_0x1ad8b0[_0xa9ef('0x2f')];_0xec5568[_0xa9ef('0x4b')]=qs[_0xa9ef('0x37')](_0x2587a2[_0xa9ef('0x30')][_0xa9ef('0x37')]);_0xec5568['where']=qs[_0xa9ef('0x39')](_[_0xa9ef('0x4c')](_0x2587a2['query'],_0x1ad8b0[_0xa9ef('0x39')]));if(_0x2587a2['query']['filter']){_0xec5568['where']=_[_0xa9ef('0x3c')](_0xec5568[_0xa9ef('0x38')],{'$or':_[_0xa9ef('0x29')](_0xec5568['attributes'],function(_0x4bfcfd){var _0xaec61a={};_0xaec61a[_0x4bfcfd]={'$like':'%'+_0x2587a2[_0xa9ef('0x30')][_0xa9ef('0x3a')]+'%'};return _0xaec61a;})});}_0xec5568=_[_0xa9ef('0x3c')]({},_0xec5568,_0x2587a2[_0xa9ef('0x3d')]);return _0x5b763e[_0xa9ef('0x48')](_0xec5568);}})[_0xa9ef('0x23')](function(_0x4a6214){if(_0x4a6214){_0x1ce460=_0x4a6214[_0xa9ef('0x35')];if(!_0x2587a2[_0xa9ef('0x30')][_0xa9ef('0x4d')](_0xa9ef('0x36'))){_0xec5568[_0xa9ef('0x1a')]=qs[_0xa9ef('0x1a')](_0x2587a2[_0xa9ef('0x30')]['limit']);_0xec5568[_0xa9ef('0x18')]=qs['offset'](_0x2587a2[_0xa9ef('0x30')][_0xa9ef('0x18')]);}return _0x5b763e['getFields'](_0xec5568);}})['then'](function(_0x2a6ed4){if(_0x2a6ed4){return _0x2a6ed4?{'count':_0x1ce460,'rows':_0x2a6ed4}:null;}})[_0xa9ef('0x23')](respondWithResult(_0x25daf4,null))['catch'](handleError(_0x25daf4,null));};exports[_0xa9ef('0x4e')]=function(_0x4484a1,_0x421f93,_0x3f1f62){var _0x447eed={};var _0x95b907={};var _0x740dc4;var _0x342afa;return db[_0xa9ef('0x2a')]['findOne']({'where':{'id':_0x4484a1[_0xa9ef('0x43')]['id']}})[_0xa9ef('0x23')](handleEntityNotFound(_0x421f93,null))[_0xa9ef('0x23')](function(_0x1d80a1){if(_0x1d80a1){_0x740dc4=_0x1d80a1;_0x95b907[_0xa9ef('0x2f')]=_['keys'](db[_0xa9ef('0x4a')][_0xa9ef('0x2b')]);_0x95b907[_0xa9ef('0x30')]=_[_0xa9ef('0x31')](_0x4484a1[_0xa9ef('0x30')]);_0x95b907['filters']=_[_0xa9ef('0x32')](_0x95b907[_0xa9ef('0x2f')],_0x95b907['query']);_0x447eed['attributes']=_[_0xa9ef('0x32')](_0x95b907['model'],qs['fields'](_0x4484a1[_0xa9ef('0x30')]['fields']));_0x447eed[_0xa9ef('0x33')]=_0x447eed[_0xa9ef('0x33')][_0xa9ef('0x35')]?_0x447eed[_0xa9ef('0x33')]:_0x95b907[_0xa9ef('0x2f')];_0x447eed[_0xa9ef('0x4b')]=qs[_0xa9ef('0x37')](_0x4484a1[_0xa9ef('0x30')][_0xa9ef('0x37')]);_0x447eed['where']=qs[_0xa9ef('0x39')](_['pick'](_0x4484a1[_0xa9ef('0x30')],_0x95b907['filters']));if(_0x4484a1[_0xa9ef('0x30')][_0xa9ef('0x3a')]){_0x447eed[_0xa9ef('0x38')]=_[_0xa9ef('0x3c')](_0x447eed[_0xa9ef('0x38')],{'$or':_[_0xa9ef('0x29')](_0x447eed[_0xa9ef('0x33')],function(_0x22d71b){var _0x4ccec7={};_0x4ccec7[_0x22d71b]={'$like':'%'+_0x4484a1[_0xa9ef('0x30')][_0xa9ef('0x3a')]+'%'};return _0x4ccec7;})});}_0x447eed=_[_0xa9ef('0x3c')]({},_0x447eed,_0x4484a1[_0xa9ef('0x3d')]);return _0x740dc4[_0xa9ef('0x4e')](_0x447eed);}})[_0xa9ef('0x23')](function(_0x17a4ab){if(_0x17a4ab){_0x342afa=_0x17a4ab[_0xa9ef('0x35')];if(!_0x4484a1[_0xa9ef('0x30')][_0xa9ef('0x4d')](_0xa9ef('0x36'))){_0x447eed['limit']=qs['limit'](_0x4484a1['query'][_0xa9ef('0x1a')]);_0x447eed[_0xa9ef('0x18')]=qs[_0xa9ef('0x18')](_0x4484a1[_0xa9ef('0x30')][_0xa9ef('0x18')]);}return _0x740dc4[_0xa9ef('0x4e')](_0x447eed);}})[_0xa9ef('0x23')](function(_0x2f364e){if(_0x2f364e){return _0x2f364e?{'count':_0x342afa,'rows':_0x2f364e}:null;}})[_0xa9ef('0x23')](respondWithResult(_0x421f93,null))[_0xa9ef('0x41')](handleError(_0x421f93,null));};exports[_0xa9ef('0x4f')]=function(_0x6f31e1,_0xc2962c,_0x3e6e18){var _0x36cb23={};var _0x57fd51={};var _0x261c5a;var _0x3ac0e6;return db['FreshdeskConfiguration'][_0xa9ef('0x49')]({'where':{'id':_0x6f31e1[_0xa9ef('0x43')]['id']}})['then'](handleEntityNotFound(_0xc2962c,null))[_0xa9ef('0x23')](function(_0x4740af){if(_0x4740af){_0x261c5a=_0x4740af;_0x57fd51['model']=_['keys'](db[_0xa9ef('0x4a')][_0xa9ef('0x2b')]);_0x57fd51[_0xa9ef('0x30')]=_[_0xa9ef('0x31')](_0x6f31e1[_0xa9ef('0x30')]);_0x57fd51[_0xa9ef('0x39')]=_['intersection'](_0x57fd51[_0xa9ef('0x2f')],_0x57fd51[_0xa9ef('0x30')]);_0x36cb23['attributes']=_[_0xa9ef('0x32')](_0x57fd51[_0xa9ef('0x2f')],qs['fields'](_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x34')]));_0x36cb23[_0xa9ef('0x33')]=_0x36cb23[_0xa9ef('0x33')][_0xa9ef('0x35')]?_0x36cb23['attributes']:_0x57fd51[_0xa9ef('0x2f')];_0x36cb23['order']=qs[_0xa9ef('0x37')](_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x37')]);_0x36cb23[_0xa9ef('0x38')]=qs[_0xa9ef('0x39')](_[_0xa9ef('0x4c')](_0x6f31e1[_0xa9ef('0x30')],_0x57fd51[_0xa9ef('0x39')]));if(_0x6f31e1['query'][_0xa9ef('0x3a')]){_0x36cb23[_0xa9ef('0x38')]=_[_0xa9ef('0x3c')](_0x36cb23[_0xa9ef('0x38')],{'$or':_[_0xa9ef('0x29')](_0x36cb23[_0xa9ef('0x33')],function(_0x56941e){var _0x8ff27b={};_0x8ff27b[_0x56941e]={'$like':'%'+_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x3a')]+'%'};return _0x8ff27b;})});}_0x36cb23=_['merge']({},_0x36cb23,_0x6f31e1[_0xa9ef('0x3d')]);return _0x261c5a['getDescriptions'](_0x36cb23);}})[_0xa9ef('0x23')](function(_0xec3611){if(_0xec3611){_0x3ac0e6=_0xec3611[_0xa9ef('0x35')];if(!_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x4d')]('nolimit')){_0x36cb23[_0xa9ef('0x1a')]=qs[_0xa9ef('0x1a')](_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x1a')]);_0x36cb23[_0xa9ef('0x18')]=qs[_0xa9ef('0x18')](_0x6f31e1[_0xa9ef('0x30')][_0xa9ef('0x18')]);}return _0x261c5a[_0xa9ef('0x4f')](_0x36cb23);}})[_0xa9ef('0x23')](function(_0x51179d){if(_0x51179d){return _0x51179d?{'count':_0x3ac0e6,'rows':_0x51179d}:null;}})[_0xa9ef('0x23')](respondWithResult(_0xc2962c,null))[_0xa9ef('0x41')](handleError(_0xc2962c,null));};exports[_0xa9ef('0x50')]=function(_0x5186f3,_0x13fe0c,_0xb9bae){var _0x303e26={};var _0x45331b={};var _0x1da887;var _0x514892;return db[_0xa9ef('0x2a')]['findOne']({'where':{'id':_0x5186f3[_0xa9ef('0x43')]['id']}})[_0xa9ef('0x23')](handleEntityNotFound(_0x13fe0c,null))['then'](function(_0x5144fb){if(_0x5144fb){_0x1da887=_0x5144fb;_0x45331b[_0xa9ef('0x2f')]=_[_0xa9ef('0x31')](db[_0xa9ef('0x51')][_0xa9ef('0x2b')]);_0x45331b[_0xa9ef('0x30')]=_[_0xa9ef('0x31')](_0x5186f3[_0xa9ef('0x30')]);_0x45331b[_0xa9ef('0x39')]=_[_0xa9ef('0x32')](_0x45331b[_0xa9ef('0x2f')],_0x45331b[_0xa9ef('0x30')]);_0x303e26[_0xa9ef('0x33')]=_[_0xa9ef('0x32')](_0x45331b[_0xa9ef('0x2f')],qs['fields'](_0x5186f3[_0xa9ef('0x30')]['fields']));_0x303e26['attributes']=_0x303e26[_0xa9ef('0x33')][_0xa9ef('0x35')]?_0x303e26[_0xa9ef('0x33')]:_0x45331b['model'];_0x303e26[_0xa9ef('0x4b')]=qs[_0xa9ef('0x37')](_0x5186f3['query'][_0xa9ef('0x37')]);_0x303e26['where']=qs[_0xa9ef('0x39')](_['pick'](_0x5186f3[_0xa9ef('0x30')],_0x45331b[_0xa9ef('0x39')]));if(_0x5186f3[_0xa9ef('0x30')][_0xa9ef('0x3a')]){_0x303e26['where']=_[_0xa9ef('0x3c')](_0x303e26[_0xa9ef('0x38')],{'$or':_['map'](_0x303e26[_0xa9ef('0x33')],function(_0x4ce9b2){var _0x26779c={};_0x26779c[_0x4ce9b2]={'$like':'%'+_0x5186f3[_0xa9ef('0x30')][_0xa9ef('0x3a')]+'%'};return _0x26779c;})});}_0x303e26=_[_0xa9ef('0x3c')]({},_0x303e26,_0x5186f3[_0xa9ef('0x3d')]);return _0x1da887[_0xa9ef('0x50')](_0x303e26);}})[_0xa9ef('0x23')](function(_0x1bccb9){if(_0x1bccb9){_0x514892=_0x1bccb9[_0xa9ef('0x35')];if(!_0x5186f3[_0xa9ef('0x30')]['hasOwnProperty'](_0xa9ef('0x36'))){_0x303e26['limit']=qs['limit'](_0x5186f3[_0xa9ef('0x30')][_0xa9ef('0x1a')]);_0x303e26['offset']=qs[_0xa9ef('0x18')](_0x5186f3[_0xa9ef('0x30')][_0xa9ef('0x18')]);}return _0x1da887[_0xa9ef('0x50')](_0x303e26);}})[_0xa9ef('0x23')](function(_0x351ecb){if(_0x351ecb){return _0x351ecb?{'count':_0x514892,'rows':_0x351ecb}:null;}})[_0xa9ef('0x23')](respondWithResult(_0x13fe0c,null))['catch'](handleError(_0x13fe0c,null));};exports[_0xa9ef('0x52')]=function(_0x6635e8,_0x229ee1,_0x48cbd2){if(_0x6635e8['body']['id']){delete _0x6635e8[_0xa9ef('0x47')]['id'];}return db['FreshdeskConfiguration'][_0xa9ef('0x49')]({'where':{'id':_0x6635e8[_0xa9ef('0x43')]['id']}})[_0xa9ef('0x23')](handleEntityNotFound(_0x229ee1,null))[_0xa9ef('0x23')](function(_0xc3d59f){if(_0xc3d59f){return _0xc3d59f[_0xa9ef('0x52')](_0x6635e8[_0xa9ef('0x47')][_0xa9ef('0x53')]||[]);}return null;})[_0xa9ef('0x23')](respondWithResult(_0x229ee1,null))[_0xa9ef('0x41')](handleError(_0x229ee1,null));};