c477509178ecd848d5684a6e256aaed1d93c3aae
[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 _0x594d=['fast-json-patch','request-promise','moment','mustache','util','path','sox','squel','crypto','jsforce','desk.js','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','jayson/promise','http','Sequelize','ValidationError','request','then','FreshdeskConfiguration,\x20%s,\x20%s','debug','stringify','error','message','info','request\x20sent','result','catch','sendStatus','status','end','json','count','offset','limit','set','Content-Range','apply','reject','save','update','stack','name','send','index','map','FreshdeskConfiguration','rawAttributes','fieldName','type','model','query','keys','filters','attributes','intersection','fields','length','hasOwnProperty','order','sort','where','filter','merge','VIRTUAL','includeAll','findAll','rows','show','options','find','create','body','destroy','getFields','params','FreshdeskField','pick','nolimit','getSubjects','findOne','getDescriptions','getTags','Tag','setTags','ids','rimraf','zip-dir'];(function(_0x342d3c,_0x13c0f0){var _0x4ed255=function(_0x40b544){while(--_0x40b544){_0x342d3c['push'](_0x342d3c['shift']());}};_0x4ed255(++_0x13c0f0);}(_0x594d,0x172));var _0xd594=function(_0x559137,_0x3b006b){_0x559137=_0x559137-0x0;var _0x4bf14d=_0x594d[_0x559137];return _0x4bf14d;};'use strict';var pdf=require('html-pdf');var emlformat=require('eml-format');var rimraf=require(_0xd594('0x0'));var zipdir=require(_0xd594('0x1'));var jsonpatch=require(_0xd594('0x2'));var rp=require(_0xd594('0x3'));var moment=require(_0xd594('0x4'));var BPromise=require('bluebird');var Mustache=require(_0xd594('0x5'));var util=require(_0xd594('0x6'));var path=require(_0xd594('0x7'));var sox=require(_0xd594('0x8'));var csv=require('to-csv');var ejs=require('ejs');var fs=require('fs');var _=require('lodash');var squel=require(_0xd594('0x9'));var crypto=require(_0xd594('0xa'));var jsforce=require(_0xd594('0xb'));var deskjs=require(_0xd594('0xc'));var toCsv=require('to-csv');var querystring=require('querystring');var Papa=require(_0xd594('0xd'));var Redis=require(_0xd594('0xe'));var authService=require(_0xd594('0xf'));var qs=require(_0xd594('0x10'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xd594('0x11'));var logger=require(_0xd594('0x12'))(_0xd594('0x13'));var utils=require('../../config/utils');var config=require('../../config/environment');var db=require('../../mysqldb')['db'];var jayson=require(_0xd594('0x14'));var client=jayson['client'][_0xd594('0x15')]({'port':0x232a});function checkPasswordPattern(_0x25600a,_0xd6b968,_0x567805){if(_0x567805){var _0x299dc8=new RegExp(/(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9])(?=.*[?!@#\$%\^&\*~\-_=+[{\]\}])(?=.{8,})/);if(_0x299dc8['test'](_0xd6b968)){return _0x25600a;}else{throw new db[(_0xd594('0x16'))][(_0xd594('0x17'))]('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 _0x25600a;}}function respondWithRpcPromise(_0x14159e,_0x3e39ef,_0x1b5a8e,_0x2299c7){return new BPromise(function(_0x5464e2,_0x311d8d){var _0x5c7e60=_0x2299c7||client;return _0x5c7e60[_0xd594('0x18')](_0x14159e,_0x1b5a8e)[_0xd594('0x19')](function(_0x2a005b){logger['info'](_0xd594('0x1a'),_0x3e39ef,'request\x20sent');logger[_0xd594('0x1b')]('FreshdeskConfiguration,\x20%s,\x20%s,\x20%s',_0x3e39ef,'request\x20sent',JSON[_0xd594('0x1c')](_0x2a005b));if(_0x2a005b[_0xd594('0x1d')]){if(_0x2a005b['error']['code']===0x1f4){logger['error']('FreshdeskConfiguration,\x20%s,\x20%s',_0x3e39ef,_0x2a005b['error'][_0xd594('0x1e')]);return _0x311d8d(_0x2a005b[_0xd594('0x1d')][_0xd594('0x1e')]);}logger[_0xd594('0x1d')](_0xd594('0x1a'),_0x3e39ef,_0x2a005b[_0xd594('0x1d')][_0xd594('0x1e')]);return _0x5464e2(_0x2a005b[_0xd594('0x1d')][_0xd594('0x1e')]);}else{logger[_0xd594('0x1f')]('FreshdeskConfiguration,\x20%s,\x20%s',_0x3e39ef,_0xd594('0x20'));_0x5464e2(_0x2a005b[_0xd594('0x21')]['message']);}})[_0xd594('0x22')](function(_0x10f35a){logger[_0xd594('0x1d')](_0xd594('0x1a'),_0x3e39ef,_0x10f35a);_0x311d8d(_0x10f35a);});});}function respondWithStatusCode(_0x19e9bf,_0x55e9f0){_0x55e9f0=_0x55e9f0||0xcc;return function(_0x5a996f){if(_0x5a996f){return _0x19e9bf[_0xd594('0x23')](_0x55e9f0);}return _0x19e9bf[_0xd594('0x24')](_0x55e9f0)[_0xd594('0x25')]();};}function respondWithResult(_0x348ea6,_0x5cb20b){_0x5cb20b=_0x5cb20b||0xc8;return function(_0x5601b8){if(_0x5601b8){return _0x348ea6[_0xd594('0x24')](_0x5cb20b)[_0xd594('0x26')](_0x5601b8);}};}function respondWithFilteredResult(_0x380457,_0x1dbe82){return function(_0x3b75da){if(_0x3b75da){var _0xe27623=_0x3b75da[_0xd594('0x27')],_0x14fd94=_0x1dbe82[_0xd594('0x28')],_0x1d784a=_0x1dbe82[_0xd594('0x28')]+_0x1dbe82[_0xd594('0x29')],_0x5774b7;if(_0x1d784a>=_0xe27623){_0x1d784a=_0xe27623;_0x5774b7=0xc8;}else{_0x5774b7=0xce;}_0x380457[_0xd594('0x24')](_0x5774b7);return _0x380457[_0xd594('0x2a')](_0xd594('0x2b'),_0x14fd94+'-'+_0x1d784a+'/'+_0xe27623)[_0xd594('0x26')](_0x3b75da);}return null;};}function patchUpdates(_0x31271a){return function(_0xb52c22){try{jsonpatch[_0xd594('0x2c')](_0xb52c22,_0x31271a,!![]);}catch(_0x4c6a22){return BPromise[_0xd594('0x2d')](_0x4c6a22);}return _0xb52c22[_0xd594('0x2e')]();};}function saveUpdates(_0x3f1ca3,_0x2b44ab){return function(_0x3efbd4){if(_0x3efbd4){return _0x3efbd4[_0xd594('0x2f')](_0x3f1ca3)[_0xd594('0x19')](function(_0x3a843e){return _0x3a843e;});}return null;};}function removeEntity(_0x50386a,_0x5663f5){return function(_0x40bbb6){if(_0x40bbb6){return _0x40bbb6['destroy']()[_0xd594('0x19')](function(){_0x50386a[_0xd594('0x24')](0xcc)['end']();});}};}function handleEntityNotFound(_0x47adae,_0x3d761f){return function(_0x11f830){if(!_0x11f830){_0x47adae[_0xd594('0x23')](0x194);}return _0x11f830;};}function handleError(_0x309200,_0x3bfd6d){_0x3bfd6d=_0x3bfd6d||0x1f4;return function(_0x4c5a97){logger[_0xd594('0x1d')](_0x4c5a97[_0xd594('0x30')]);if(_0x4c5a97[_0xd594('0x31')]){delete _0x4c5a97[_0xd594('0x31')];}_0x309200[_0xd594('0x24')](_0x3bfd6d)[_0xd594('0x32')](_0x4c5a97);};}exports[_0xd594('0x33')]=function(_0x4f9858,_0x4f55de){var _0x466a94={},_0x54ebd9={},_0x40dcfb={'count':0x0,'rows':[]};var _0x56bae4=_[_0xd594('0x34')](db[_0xd594('0x35')][_0xd594('0x36')],function(_0x610461){return{'name':_0x610461[_0xd594('0x37')],'type':_0x610461[_0xd594('0x38')]['key']};});_0x54ebd9[_0xd594('0x39')]=_[_0xd594('0x34')](_0x56bae4,'name');_0x54ebd9[_0xd594('0x3a')]=_[_0xd594('0x3b')](_0x4f9858[_0xd594('0x3a')]);_0x54ebd9[_0xd594('0x3c')]=_['intersection'](_0x54ebd9[_0xd594('0x39')],_0x54ebd9[_0xd594('0x3a')]);_0x466a94[_0xd594('0x3d')]=_[_0xd594('0x3e')](_0x54ebd9['model'],qs[_0xd594('0x3f')](_0x4f9858[_0xd594('0x3a')][_0xd594('0x3f')]));_0x466a94[_0xd594('0x3d')]=_0x466a94[_0xd594('0x3d')][_0xd594('0x40')]?_0x466a94[_0xd594('0x3d')]:_0x54ebd9['model'];if(!_0x4f9858[_0xd594('0x3a')][_0xd594('0x41')]('nolimit')){_0x466a94[_0xd594('0x29')]=qs[_0xd594('0x29')](_0x4f9858[_0xd594('0x3a')]['limit']);_0x466a94[_0xd594('0x28')]=qs[_0xd594('0x28')](_0x4f9858[_0xd594('0x3a')][_0xd594('0x28')]);}_0x466a94[_0xd594('0x42')]=qs['sort'](_0x4f9858[_0xd594('0x3a')][_0xd594('0x43')]);_0x466a94[_0xd594('0x44')]=qs[_0xd594('0x3c')](_['pick'](_0x4f9858[_0xd594('0x3a')],_0x54ebd9[_0xd594('0x3c')]),_0x56bae4);if(_0x4f9858['query'][_0xd594('0x45')]){_0x466a94['where']=_[_0xd594('0x46')](_0x466a94[_0xd594('0x44')],{'$or':_[_0xd594('0x34')](_0x56bae4,function(_0x3c3a28){if(_0x3c3a28[_0xd594('0x38')]!==_0xd594('0x47')){var _0x31e3a3={};_0x31e3a3[_0x3c3a28[_0xd594('0x31')]]={'$like':'%'+_0x4f9858[_0xd594('0x3a')]['filter']+'%'};return _0x31e3a3;}})});}_0x466a94=_[_0xd594('0x46')]({},_0x466a94,_0x4f9858['options']);var _0x88987e={'where':_0x466a94['where']};return db[_0xd594('0x35')][_0xd594('0x27')](_0x88987e)[_0xd594('0x19')](function(_0x40bbd6){_0x40dcfb[_0xd594('0x27')]=_0x40bbd6;if(_0x4f9858[_0xd594('0x3a')][_0xd594('0x48')]){_0x466a94['include']=[{'all':!![]}];}return db['FreshdeskConfiguration'][_0xd594('0x49')](_0x466a94);})[_0xd594('0x19')](function(_0x3eeaf9){_0x40dcfb[_0xd594('0x4a')]=_0x3eeaf9;return _0x40dcfb;})[_0xd594('0x19')](respondWithFilteredResult(_0x4f55de,_0x466a94))[_0xd594('0x22')](handleError(_0x4f55de,null));};exports[_0xd594('0x4b')]=function(_0x3ffb1b,_0xc94665){var _0x22a20a={'raw':![],'where':{'id':_0x3ffb1b['params']['id']}},_0x3e93e6={};_0x3e93e6[_0xd594('0x39')]=_[_0xd594('0x3b')](db[_0xd594('0x35')][_0xd594('0x36')]);_0x3e93e6['query']=_[_0xd594('0x3b')](_0x3ffb1b[_0xd594('0x3a')]);_0x3e93e6[_0xd594('0x3c')]=_[_0xd594('0x3e')](_0x3e93e6[_0xd594('0x39')],_0x3e93e6[_0xd594('0x3a')]);_0x22a20a[_0xd594('0x3d')]=_[_0xd594('0x3e')](_0x3e93e6['model'],qs[_0xd594('0x3f')](_0x3ffb1b[_0xd594('0x3a')][_0xd594('0x3f')]));_0x22a20a[_0xd594('0x3d')]=_0x22a20a['attributes'][_0xd594('0x40')]?_0x22a20a[_0xd594('0x3d')]:_0x3e93e6[_0xd594('0x39')];if(_0x3ffb1b[_0xd594('0x3a')][_0xd594('0x48')]){_0x22a20a['include']=[{'all':!![]}];}_0x22a20a=_[_0xd594('0x46')]({},_0x22a20a,_0x3ffb1b[_0xd594('0x4c')]);return db[_0xd594('0x35')][_0xd594('0x4d')](_0x22a20a)[_0xd594('0x19')](handleEntityNotFound(_0xc94665,null))[_0xd594('0x19')](respondWithResult(_0xc94665,null))['catch'](handleError(_0xc94665,null));};exports[_0xd594('0x4e')]=function(_0xe092c0,_0x5d729e){return db['FreshdeskConfiguration'][_0xd594('0x4e')](_0xe092c0[_0xd594('0x4f')],{})[_0xd594('0x19')](respondWithResult(_0x5d729e,0xc9))[_0xd594('0x22')](handleError(_0x5d729e,null));};exports[_0xd594('0x2f')]=function(_0xb84ec8,_0x550622){if(_0xb84ec8[_0xd594('0x4f')]['id']){delete _0xb84ec8[_0xd594('0x4f')]['id'];}return db['FreshdeskConfiguration']['find']({'where':{'id':_0xb84ec8['params']['id']}})[_0xd594('0x19')](handleEntityNotFound(_0x550622,null))[_0xd594('0x19')](saveUpdates(_0xb84ec8[_0xd594('0x4f')],null))[_0xd594('0x19')](respondWithResult(_0x550622,null))['catch'](handleError(_0x550622,null));};exports[_0xd594('0x50')]=function(_0x542769,_0x4bc500){return db['FreshdeskConfiguration'][_0xd594('0x4d')]({'where':{'id':_0x542769['params']['id']}})[_0xd594('0x19')](handleEntityNotFound(_0x4bc500,null))['then'](removeEntity(_0x4bc500,null))[_0xd594('0x22')](handleError(_0x4bc500,null));};exports[_0xd594('0x51')]=function(_0x4f1918,_0xe96f88,_0x2160b1){var _0x589115={};var _0x5e0bd9={};var _0x2448c3;var _0x1fe590;return db[_0xd594('0x35')]['findOne']({'where':{'id':_0x4f1918[_0xd594('0x52')]['id']}})[_0xd594('0x19')](handleEntityNotFound(_0xe96f88,null))[_0xd594('0x19')](function(_0xe708de){if(_0xe708de){_0x2448c3=_0xe708de;_0x5e0bd9[_0xd594('0x39')]=_[_0xd594('0x3b')](db[_0xd594('0x53')]['rawAttributes']);_0x5e0bd9[_0xd594('0x3a')]=_[_0xd594('0x3b')](_0x4f1918['query']);_0x5e0bd9[_0xd594('0x3c')]=_[_0xd594('0x3e')](_0x5e0bd9[_0xd594('0x39')],_0x5e0bd9[_0xd594('0x3a')]);_0x589115['attributes']=_[_0xd594('0x3e')](_0x5e0bd9[_0xd594('0x39')],qs[_0xd594('0x3f')](_0x4f1918['query'][_0xd594('0x3f')]));_0x589115[_0xd594('0x3d')]=_0x589115['attributes']['length']?_0x589115[_0xd594('0x3d')]:_0x5e0bd9[_0xd594('0x39')];_0x589115[_0xd594('0x42')]=qs[_0xd594('0x43')](_0x4f1918[_0xd594('0x3a')]['sort']);_0x589115['where']=qs[_0xd594('0x3c')](_[_0xd594('0x54')](_0x4f1918[_0xd594('0x3a')],_0x5e0bd9[_0xd594('0x3c')]));if(_0x4f1918[_0xd594('0x3a')][_0xd594('0x45')]){_0x589115[_0xd594('0x44')]=_[_0xd594('0x46')](_0x589115['where'],{'$or':_['map'](_0x589115[_0xd594('0x3d')],function(_0x2f3976){var _0x301acf={};_0x301acf[_0x2f3976]={'$like':'%'+_0x4f1918[_0xd594('0x3a')][_0xd594('0x45')]+'%'};return _0x301acf;})});}_0x589115=_[_0xd594('0x46')]({},_0x589115,_0x4f1918[_0xd594('0x4c')]);return _0x2448c3[_0xd594('0x51')](_0x589115);}})[_0xd594('0x19')](function(_0x4c0046){if(_0x4c0046){_0x1fe590=_0x4c0046[_0xd594('0x40')];if(!_0x4f1918[_0xd594('0x3a')]['hasOwnProperty'](_0xd594('0x55'))){_0x589115['limit']=qs[_0xd594('0x29')](_0x4f1918[_0xd594('0x3a')]['limit']);_0x589115['offset']=qs['offset'](_0x4f1918[_0xd594('0x3a')][_0xd594('0x28')]);}return _0x2448c3[_0xd594('0x51')](_0x589115);}})[_0xd594('0x19')](function(_0x1bcf77){if(_0x1bcf77){return _0x1bcf77?{'count':_0x1fe590,'rows':_0x1bcf77}:null;}})[_0xd594('0x19')](respondWithResult(_0xe96f88,null))[_0xd594('0x22')](handleError(_0xe96f88,null));};exports[_0xd594('0x56')]=function(_0x2e8291,_0x100d14,_0x428951){var _0x1f9d10={};var _0x2e990c={};var _0x134d09;var _0x41628a;return db[_0xd594('0x35')][_0xd594('0x57')]({'where':{'id':_0x2e8291[_0xd594('0x52')]['id']}})[_0xd594('0x19')](handleEntityNotFound(_0x100d14,null))[_0xd594('0x19')](function(_0x4eccb2){if(_0x4eccb2){_0x134d09=_0x4eccb2;_0x2e990c['model']=_[_0xd594('0x3b')](db['FreshdeskField'][_0xd594('0x36')]);_0x2e990c[_0xd594('0x3a')]=_[_0xd594('0x3b')](_0x2e8291[_0xd594('0x3a')]);_0x2e990c[_0xd594('0x3c')]=_[_0xd594('0x3e')](_0x2e990c[_0xd594('0x39')],_0x2e990c[_0xd594('0x3a')]);_0x1f9d10['attributes']=_[_0xd594('0x3e')](_0x2e990c['model'],qs[_0xd594('0x3f')](_0x2e8291[_0xd594('0x3a')][_0xd594('0x3f')]));_0x1f9d10[_0xd594('0x3d')]=_0x1f9d10['attributes'][_0xd594('0x40')]?_0x1f9d10[_0xd594('0x3d')]:_0x2e990c[_0xd594('0x39')];_0x1f9d10[_0xd594('0x42')]=qs[_0xd594('0x43')](_0x2e8291[_0xd594('0x3a')][_0xd594('0x43')]);_0x1f9d10[_0xd594('0x44')]=qs[_0xd594('0x3c')](_['pick'](_0x2e8291[_0xd594('0x3a')],_0x2e990c[_0xd594('0x3c')]));if(_0x2e8291['query']['filter']){_0x1f9d10['where']=_[_0xd594('0x46')](_0x1f9d10[_0xd594('0x44')],{'$or':_[_0xd594('0x34')](_0x1f9d10['attributes'],function(_0x25ad37){var _0x59fd00={};_0x59fd00[_0x25ad37]={'$like':'%'+_0x2e8291[_0xd594('0x3a')][_0xd594('0x45')]+'%'};return _0x59fd00;})});}_0x1f9d10=_[_0xd594('0x46')]({},_0x1f9d10,_0x2e8291['options']);return _0x134d09['getSubjects'](_0x1f9d10);}})['then'](function(_0x507ea0){if(_0x507ea0){_0x41628a=_0x507ea0['length'];if(!_0x2e8291[_0xd594('0x3a')][_0xd594('0x41')](_0xd594('0x55'))){_0x1f9d10[_0xd594('0x29')]=qs[_0xd594('0x29')](_0x2e8291[_0xd594('0x3a')][_0xd594('0x29')]);_0x1f9d10['offset']=qs[_0xd594('0x28')](_0x2e8291[_0xd594('0x3a')][_0xd594('0x28')]);}return _0x134d09['getSubjects'](_0x1f9d10);}})[_0xd594('0x19')](function(_0x4f6e74){if(_0x4f6e74){return _0x4f6e74?{'count':_0x41628a,'rows':_0x4f6e74}:null;}})[_0xd594('0x19')](respondWithResult(_0x100d14,null))[_0xd594('0x22')](handleError(_0x100d14,null));};exports[_0xd594('0x58')]=function(_0x208518,_0x5e17f0,_0x33e504){var _0x176bae={};var _0x49b0c7={};var _0x47fc03;var _0x3ac6b8;return db[_0xd594('0x35')][_0xd594('0x57')]({'where':{'id':_0x208518[_0xd594('0x52')]['id']}})['then'](handleEntityNotFound(_0x5e17f0,null))[_0xd594('0x19')](function(_0x464144){if(_0x464144){_0x47fc03=_0x464144;_0x49b0c7[_0xd594('0x39')]=_['keys'](db[_0xd594('0x53')]['rawAttributes']);_0x49b0c7['query']=_[_0xd594('0x3b')](_0x208518[_0xd594('0x3a')]);_0x49b0c7[_0xd594('0x3c')]=_[_0xd594('0x3e')](_0x49b0c7[_0xd594('0x39')],_0x49b0c7[_0xd594('0x3a')]);_0x176bae[_0xd594('0x3d')]=_[_0xd594('0x3e')](_0x49b0c7[_0xd594('0x39')],qs[_0xd594('0x3f')](_0x208518['query'][_0xd594('0x3f')]));_0x176bae['attributes']=_0x176bae['attributes']['length']?_0x176bae[_0xd594('0x3d')]:_0x49b0c7['model'];_0x176bae['order']=qs[_0xd594('0x43')](_0x208518[_0xd594('0x3a')][_0xd594('0x43')]);_0x176bae[_0xd594('0x44')]=qs[_0xd594('0x3c')](_[_0xd594('0x54')](_0x208518[_0xd594('0x3a')],_0x49b0c7['filters']));if(_0x208518[_0xd594('0x3a')]['filter']){_0x176bae[_0xd594('0x44')]=_[_0xd594('0x46')](_0x176bae[_0xd594('0x44')],{'$or':_[_0xd594('0x34')](_0x176bae[_0xd594('0x3d')],function(_0x125631){var _0x530cb5={};_0x530cb5[_0x125631]={'$like':'%'+_0x208518[_0xd594('0x3a')][_0xd594('0x45')]+'%'};return _0x530cb5;})});}_0x176bae=_['merge']({},_0x176bae,_0x208518['options']);return _0x47fc03['getDescriptions'](_0x176bae);}})[_0xd594('0x19')](function(_0x13f637){if(_0x13f637){_0x3ac6b8=_0x13f637['length'];if(!_0x208518[_0xd594('0x3a')][_0xd594('0x41')](_0xd594('0x55'))){_0x176bae['limit']=qs[_0xd594('0x29')](_0x208518[_0xd594('0x3a')][_0xd594('0x29')]);_0x176bae[_0xd594('0x28')]=qs[_0xd594('0x28')](_0x208518[_0xd594('0x3a')][_0xd594('0x28')]);}return _0x47fc03[_0xd594('0x58')](_0x176bae);}})[_0xd594('0x19')](function(_0x25d936){if(_0x25d936){return _0x25d936?{'count':_0x3ac6b8,'rows':_0x25d936}:null;}})[_0xd594('0x19')](respondWithResult(_0x5e17f0,null))['catch'](handleError(_0x5e17f0,null));};exports[_0xd594('0x59')]=function(_0x4eeab7,_0x2229ac,_0x13f353){var _0x3c6401={};var _0x3bd266={};var _0x5d641d;var _0x5ec264;return db['FreshdeskConfiguration'][_0xd594('0x57')]({'where':{'id':_0x4eeab7[_0xd594('0x52')]['id']}})[_0xd594('0x19')](handleEntityNotFound(_0x2229ac,null))[_0xd594('0x19')](function(_0x33bf60){if(_0x33bf60){_0x5d641d=_0x33bf60;_0x3bd266[_0xd594('0x39')]=_[_0xd594('0x3b')](db[_0xd594('0x5a')][_0xd594('0x36')]);_0x3bd266['query']=_['keys'](_0x4eeab7[_0xd594('0x3a')]);_0x3bd266['filters']=_[_0xd594('0x3e')](_0x3bd266['model'],_0x3bd266[_0xd594('0x3a')]);_0x3c6401[_0xd594('0x3d')]=_[_0xd594('0x3e')](_0x3bd266['model'],qs[_0xd594('0x3f')](_0x4eeab7[_0xd594('0x3a')]['fields']));_0x3c6401[_0xd594('0x3d')]=_0x3c6401[_0xd594('0x3d')]['length']?_0x3c6401[_0xd594('0x3d')]:_0x3bd266['model'];_0x3c6401['order']=qs[_0xd594('0x43')](_0x4eeab7['query'][_0xd594('0x43')]);_0x3c6401[_0xd594('0x44')]=qs['filters'](_['pick'](_0x4eeab7['query'],_0x3bd266[_0xd594('0x3c')]));if(_0x4eeab7['query'][_0xd594('0x45')]){_0x3c6401[_0xd594('0x44')]=_[_0xd594('0x46')](_0x3c6401['where'],{'$or':_[_0xd594('0x34')](_0x3c6401['attributes'],function(_0x567a06){var _0x1fda8d={};_0x1fda8d[_0x567a06]={'$like':'%'+_0x4eeab7[_0xd594('0x3a')]['filter']+'%'};return _0x1fda8d;})});}_0x3c6401=_[_0xd594('0x46')]({},_0x3c6401,_0x4eeab7[_0xd594('0x4c')]);return _0x5d641d[_0xd594('0x59')](_0x3c6401);}})['then'](function(_0x3f4683){if(_0x3f4683){_0x5ec264=_0x3f4683[_0xd594('0x40')];if(!_0x4eeab7[_0xd594('0x3a')][_0xd594('0x41')](_0xd594('0x55'))){_0x3c6401[_0xd594('0x29')]=qs['limit'](_0x4eeab7[_0xd594('0x3a')][_0xd594('0x29')]);_0x3c6401[_0xd594('0x28')]=qs[_0xd594('0x28')](_0x4eeab7['query']['offset']);}return _0x5d641d[_0xd594('0x59')](_0x3c6401);}})[_0xd594('0x19')](function(_0x44ad40){if(_0x44ad40){return _0x44ad40?{'count':_0x5ec264,'rows':_0x44ad40}:null;}})[_0xd594('0x19')](respondWithResult(_0x2229ac,null))[_0xd594('0x22')](handleError(_0x2229ac,null));};exports[_0xd594('0x5b')]=function(_0x102cf4,_0x20f747,_0x2f1ff3){if(_0x102cf4[_0xd594('0x4f')]['id']){delete _0x102cf4[_0xd594('0x4f')]['id'];}return db[_0xd594('0x35')][_0xd594('0x57')]({'where':{'id':_0x102cf4[_0xd594('0x52')]['id']}})[_0xd594('0x19')](handleEntityNotFound(_0x20f747,null))['then'](function(_0x4f971a){if(_0x4f971a){return _0x4f971a[_0xd594('0x5b')](_0x102cf4[_0xd594('0x4f')][_0xd594('0x5c')]||[]);}return null;})[_0xd594('0x19')](respondWithResult(_0x20f747,null))[_0xd594('0x22')](handleError(_0x20f747,null));};