[motion2.git] / server / api / intFreshdeskConfiguration / intFreshdeskConfiguration.controller.js

// *************************************************************************
// *                                                                       *
// * xCALLY Motion -  The Omnichannel Contact Center                       *
// * Copyright (c) Xenialab s.r.l. All Rights Reserved                     *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * Email: info@xcally.com                                                *
// * Website: https://www.xcally.com                                       *
// *                                                                       *
// *************************************************************************
// *                                                                       *
// * The SOFTWARE PRODUCT is protected by copyright laws and international *
// * copyright treaties, as well as other intellectual property laws and   *
// * treaties. The SOFTWARE PRODUCT is licensed, not sold.                         *
// *                                                                       *
// *************************************************************************
var _0x1b4d=['pick','VIRTUAL','merge','options','includeAll','include','FreshdeskConfiguration','findAll','rows','find','create','body','params','getFields','FreshdeskField','order','getSubjects','findOne','filter','getDescriptions','getTags','Tag','setTags','eml-format','zip-dir','fast-json-patch','request-promise','moment','bluebird','util','path','sox','to-csv','ejs','lodash','squel','crypto','jsforce','desk.js','querystring','papaparse','ioredis','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/license/hardware','../../config/logger','api','../../config/environment','../../config/license/util','../../mysqldb','jayson/promise','client','http','request','then','info','request\x20sent','debug','FreshdeskConfiguration,\x20%s,\x20%s,\x20%s','stringify','error','code','FreshdeskConfiguration,\x20%s,\x20%s','message','result','catch','end','status','json','count','offset','set','Content-Range','apply','reject','save','update','sendStatus','stack','name','send','index','map','rawAttributes','fieldName','type','key','model','query','keys','filters','intersection','attributes','fields','length','hasOwnProperty','nolimit','limit','sort','where'];(function(_0x1b2ff7,_0x12a034){var _0x31656a=function(_0x1165a5){while(--_0x1165a5){_0x1b2ff7['push'](_0x1b2ff7['shift']());}};_0x31656a(++_0x12a034);}(_0x1b4d,0xdf));var _0xd1b4=function(_0x501510,_0x61caa9){_0x501510=_0x501510-0x0;var _0x1e6ee5=_0x1b4d[_0x501510];return _0x1e6ee5;};'use strict';var pdf=require('html-pdf');var emlformat=require(_0xd1b4('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xd1b4('0x1'));var jsonpatch=require(_0xd1b4('0x2'));var rp=require(_0xd1b4('0x3'));var moment=require(_0xd1b4('0x4'));var BPromise=require(_0xd1b4('0x5'));var Mustache=require('mustache');var util=require(_0xd1b4('0x6'));var path=require(_0xd1b4('0x7'));var sox=require(_0xd1b4('0x8'));var csv=require(_0xd1b4('0x9'));var ejs=require(_0xd1b4('0xa'));var fs=require('fs');var _=require(_0xd1b4('0xb'));var squel=require(_0xd1b4('0xc'));var crypto=require(_0xd1b4('0xd'));var jsforce=require(_0xd1b4('0xe'));var deskjs=require(_0xd1b4('0xf'));var toCsv=require(_0xd1b4('0x9'));var querystring=require(_0xd1b4('0x10'));var Papa=require(_0xd1b4('0x11'));var Redis=require(_0xd1b4('0x12'));var authService=require('../../components/auth/service');var qs=require(_0xd1b4('0x13'));var as=require(_0xd1b4('0x14'));var hardwareService=require(_0xd1b4('0x15'));var logger=require(_0xd1b4('0x16'))(_0xd1b4('0x17'));var utils=require('../../config/utils');var config=require(_0xd1b4('0x18'));var licenseUtil=require(_0xd1b4('0x19'));var db=require(_0xd1b4('0x1a'))['db'];var jayson=require(_0xd1b4('0x1b'));var client=jayson[_0xd1b4('0x1c')][_0xd1b4('0x1d')]({'port':0x232a});function respondWithRpcPromise(_0x163a55,_0x8a4e5b,_0xfed642,_0x24aaca){return new BPromise(function(_0x1ea61a,_0x5d7c85){var _0x4bb33d=_0x24aaca||client;return _0x4bb33d[_0xd1b4('0x1e')](_0x163a55,_0xfed642)[_0xd1b4('0x1f')](function(_0x32daf6){logger[_0xd1b4('0x20')]('FreshdeskConfiguration,\x20%s,\x20%s',_0x8a4e5b,_0xd1b4('0x21'));logger[_0xd1b4('0x22')](_0xd1b4('0x23'),_0x8a4e5b,_0xd1b4('0x21'),JSON[_0xd1b4('0x24')](_0x32daf6));if(_0x32daf6[_0xd1b4('0x25')]){if(_0x32daf6[_0xd1b4('0x25')][_0xd1b4('0x26')]===0x1f4){logger['error'](_0xd1b4('0x27'),_0x8a4e5b,_0x32daf6['error']['message']);return _0x5d7c85(_0x32daf6[_0xd1b4('0x25')][_0xd1b4('0x28')]);}logger[_0xd1b4('0x25')](_0xd1b4('0x27'),_0x8a4e5b,_0x32daf6[_0xd1b4('0x25')]['message']);return _0x1ea61a(_0x32daf6[_0xd1b4('0x25')][_0xd1b4('0x28')]);}else{logger['info'](_0xd1b4('0x27'),_0x8a4e5b,_0xd1b4('0x21'));_0x1ea61a(_0x32daf6[_0xd1b4('0x29')][_0xd1b4('0x28')]);}})[_0xd1b4('0x2a')](function(_0x480fef){logger[_0xd1b4('0x25')](_0xd1b4('0x27'),_0x8a4e5b,_0x480fef);_0x5d7c85(_0x480fef);});});}function respondWithStatusCode(_0x3dab38,_0x52bd84){_0x52bd84=_0x52bd84||0xcc;return function(_0xa0df95){if(_0xa0df95){return _0x3dab38['sendStatus'](_0x52bd84);}return _0x3dab38['status'](_0x52bd84)[_0xd1b4('0x2b')]();};}function respondWithResult(_0x1e3424,_0x230850){_0x230850=_0x230850||0xc8;return function(_0x42a6e4){if(_0x42a6e4){return _0x1e3424[_0xd1b4('0x2c')](_0x230850)[_0xd1b4('0x2d')](_0x42a6e4);}};}function respondWithFilteredResult(_0x2b4cc5,_0x2a60f9){return function(_0x283d05){if(_0x283d05){var _0x1fe818=_0x283d05[_0xd1b4('0x2e')],_0x62b1f3=_0x2a60f9['offset'],_0xf5c23e=_0x2a60f9[_0xd1b4('0x2f')]+_0x2a60f9['limit'],_0x1e9f03;if(_0xf5c23e>=_0x1fe818){_0xf5c23e=_0x1fe818;_0x1e9f03=0xc8;}else{_0x1e9f03=0xce;}_0x2b4cc5[_0xd1b4('0x2c')](_0x1e9f03);return _0x2b4cc5[_0xd1b4('0x30')](_0xd1b4('0x31'),_0x62b1f3+'-'+_0xf5c23e+'/'+_0x1fe818)[_0xd1b4('0x2d')](_0x283d05);}return null;};}function patchUpdates(_0x1ef99c){return function(_0x206d1f){try{jsonpatch[_0xd1b4('0x32')](_0x206d1f,_0x1ef99c,!![]);}catch(_0x1f75f9){return BPromise[_0xd1b4('0x33')](_0x1f75f9);}return _0x206d1f[_0xd1b4('0x34')]();};}function saveUpdates(_0x2ee2d3,_0x1f1703){return function(_0x3eed5d){if(_0x3eed5d){return _0x3eed5d[_0xd1b4('0x35')](_0x2ee2d3)[_0xd1b4('0x1f')](function(_0x5d7295){return _0x5d7295;});}return null;};}function removeEntity(_0x488a6f,_0x23c876){return function(_0x175927){if(_0x175927){return _0x175927['destroy']()[_0xd1b4('0x1f')](function(){_0x488a6f['status'](0xcc)[_0xd1b4('0x2b')]();});}};}function handleEntityNotFound(_0x2e4a43,_0xaf567){return function(_0x495f44){if(!_0x495f44){_0x2e4a43[_0xd1b4('0x36')](0x194);}return _0x495f44;};}function handleError(_0x31e64e,_0x1555e4){_0x1555e4=_0x1555e4||0x1f4;return function(_0x5820b8){logger[_0xd1b4('0x25')](_0x5820b8[_0xd1b4('0x37')]);if(_0x5820b8[_0xd1b4('0x38')]){delete _0x5820b8[_0xd1b4('0x38')];}_0x31e64e[_0xd1b4('0x2c')](_0x1555e4)[_0xd1b4('0x39')](_0x5820b8);};}exports[_0xd1b4('0x3a')]=function(_0x3566bc,_0x6bb5c1){var _0x18020c={},_0xd762a7={},_0x592bd0={'count':0x0,'rows':[]};var _0x2fc26b=_[_0xd1b4('0x3b')](db['FreshdeskConfiguration'][_0xd1b4('0x3c')],function(_0x2538cf){return{'name':_0x2538cf[_0xd1b4('0x3d')],'type':_0x2538cf[_0xd1b4('0x3e')][_0xd1b4('0x3f')]};});_0xd762a7[_0xd1b4('0x40')]=_[_0xd1b4('0x3b')](_0x2fc26b,'name');_0xd762a7[_0xd1b4('0x41')]=_[_0xd1b4('0x42')](_0x3566bc['query']);_0xd762a7[_0xd1b4('0x43')]=_[_0xd1b4('0x44')](_0xd762a7[_0xd1b4('0x40')],_0xd762a7[_0xd1b4('0x41')]);_0x18020c[_0xd1b4('0x45')]=_[_0xd1b4('0x44')](_0xd762a7[_0xd1b4('0x40')],qs[_0xd1b4('0x46')](_0x3566bc[_0xd1b4('0x41')][_0xd1b4('0x46')]));_0x18020c[_0xd1b4('0x45')]=_0x18020c[_0xd1b4('0x45')][_0xd1b4('0x47')]?_0x18020c['attributes']:_0xd762a7[_0xd1b4('0x40')];if(!_0x3566bc[_0xd1b4('0x41')][_0xd1b4('0x48')](_0xd1b4('0x49'))){_0x18020c['limit']=qs['limit'](_0x3566bc['query'][_0xd1b4('0x4a')]);_0x18020c[_0xd1b4('0x2f')]=qs['offset'](_0x3566bc[_0xd1b4('0x41')][_0xd1b4('0x2f')]);}_0x18020c['order']=qs[_0xd1b4('0x4b')](_0x3566bc[_0xd1b4('0x41')][_0xd1b4('0x4b')]);_0x18020c[_0xd1b4('0x4c')]=qs['filters'](_[_0xd1b4('0x4d')](_0x3566bc[_0xd1b4('0x41')],_0xd762a7[_0xd1b4('0x43')]),_0x2fc26b);if(_0x3566bc[_0xd1b4('0x41')]['filter']){_0x18020c[_0xd1b4('0x4c')]=_['merge'](_0x18020c['where'],{'$or':_[_0xd1b4('0x3b')](_0x2fc26b,function(_0x269b33){if(_0x269b33[_0xd1b4('0x3e')]!==_0xd1b4('0x4e')){var _0x592c62={};_0x592c62[_0x269b33[_0xd1b4('0x38')]]={'$like':'%'+_0x3566bc['query']['filter']+'%'};return _0x592c62;}})});}_0x18020c=_[_0xd1b4('0x4f')]({},_0x18020c,_0x3566bc[_0xd1b4('0x50')]);var _0x343e92={'where':_0x18020c[_0xd1b4('0x4c')]};return db['FreshdeskConfiguration'][_0xd1b4('0x2e')](_0x343e92)[_0xd1b4('0x1f')](function(_0x35fb77){_0x592bd0[_0xd1b4('0x2e')]=_0x35fb77;if(_0x3566bc[_0xd1b4('0x41')][_0xd1b4('0x51')]){_0x18020c[_0xd1b4('0x52')]=[{'all':!![]}];}return db[_0xd1b4('0x53')][_0xd1b4('0x54')](_0x18020c);})[_0xd1b4('0x1f')](function(_0x3e029c){_0x592bd0[_0xd1b4('0x55')]=_0x3e029c;return _0x592bd0;})['then'](respondWithFilteredResult(_0x6bb5c1,_0x18020c))[_0xd1b4('0x2a')](handleError(_0x6bb5c1,null));};exports['show']=function(_0x488329,_0x42ea8e){var _0x41225b={'raw':![],'where':{'id':_0x488329['params']['id']}},_0x3c5179={};_0x3c5179['model']=_[_0xd1b4('0x42')](db[_0xd1b4('0x53')]['rawAttributes']);_0x3c5179[_0xd1b4('0x41')]=_['keys'](_0x488329[_0xd1b4('0x41')]);_0x3c5179['filters']=_[_0xd1b4('0x44')](_0x3c5179[_0xd1b4('0x40')],_0x3c5179[_0xd1b4('0x41')]);_0x41225b['attributes']=_['intersection'](_0x3c5179[_0xd1b4('0x40')],qs[_0xd1b4('0x46')](_0x488329[_0xd1b4('0x41')][_0xd1b4('0x46')]));_0x41225b[_0xd1b4('0x45')]=_0x41225b['attributes']['length']?_0x41225b[_0xd1b4('0x45')]:_0x3c5179[_0xd1b4('0x40')];if(_0x488329[_0xd1b4('0x41')][_0xd1b4('0x51')]){_0x41225b[_0xd1b4('0x52')]=[{'all':!![]}];}_0x41225b=_['merge']({},_0x41225b,_0x488329[_0xd1b4('0x50')]);return db[_0xd1b4('0x53')][_0xd1b4('0x56')](_0x41225b)[_0xd1b4('0x1f')](handleEntityNotFound(_0x42ea8e,null))['then'](respondWithResult(_0x42ea8e,null))['catch'](handleError(_0x42ea8e,null));};exports[_0xd1b4('0x57')]=function(_0xfb929a,_0x5bc91d){return db[_0xd1b4('0x53')][_0xd1b4('0x57')](_0xfb929a['body'],{})[_0xd1b4('0x1f')](respondWithResult(_0x5bc91d,0xc9))[_0xd1b4('0x2a')](handleError(_0x5bc91d,null));};exports[_0xd1b4('0x35')]=function(_0x3a8ce1,_0x4538e0){if(_0x3a8ce1['body']['id']){delete _0x3a8ce1[_0xd1b4('0x58')]['id'];}return db[_0xd1b4('0x53')]['find']({'where':{'id':_0x3a8ce1[_0xd1b4('0x59')]['id']}})[_0xd1b4('0x1f')](handleEntityNotFound(_0x4538e0,null))['then'](saveUpdates(_0x3a8ce1['body'],null))['then'](respondWithResult(_0x4538e0,null))[_0xd1b4('0x2a')](handleError(_0x4538e0,null));};exports['destroy']=function(_0xd3f64,_0x51e2ad){return db[_0xd1b4('0x53')][_0xd1b4('0x56')]({'where':{'id':_0xd3f64[_0xd1b4('0x59')]['id']}})[_0xd1b4('0x1f')](handleEntityNotFound(_0x51e2ad,null))['then'](removeEntity(_0x51e2ad,null))['catch'](handleError(_0x51e2ad,null));};exports[_0xd1b4('0x5a')]=function(_0x235216,_0x2e1e5a,_0x13e016){var _0x33774e={};var _0x1d0c4f={};var _0x21b037;var _0x314360;return db[_0xd1b4('0x53')]['findOne']({'where':{'id':_0x235216[_0xd1b4('0x59')]['id']}})[_0xd1b4('0x1f')](handleEntityNotFound(_0x2e1e5a,null))[_0xd1b4('0x1f')](function(_0x5641f3){if(_0x5641f3){_0x21b037=_0x5641f3;_0x1d0c4f[_0xd1b4('0x40')]=_['keys'](db[_0xd1b4('0x5b')][_0xd1b4('0x3c')]);_0x1d0c4f[_0xd1b4('0x41')]=_[_0xd1b4('0x42')](_0x235216[_0xd1b4('0x41')]);_0x1d0c4f[_0xd1b4('0x43')]=_['intersection'](_0x1d0c4f[_0xd1b4('0x40')],_0x1d0c4f[_0xd1b4('0x41')]);_0x33774e[_0xd1b4('0x45')]=_[_0xd1b4('0x44')](_0x1d0c4f[_0xd1b4('0x40')],qs[_0xd1b4('0x46')](_0x235216[_0xd1b4('0x41')][_0xd1b4('0x46')]));_0x33774e[_0xd1b4('0x45')]=_0x33774e[_0xd1b4('0x45')][_0xd1b4('0x47')]?_0x33774e[_0xd1b4('0x45')]:_0x1d0c4f['model'];_0x33774e[_0xd1b4('0x5c')]=qs[_0xd1b4('0x4b')](_0x235216['query'][_0xd1b4('0x4b')]);_0x33774e[_0xd1b4('0x4c')]=qs['filters'](_[_0xd1b4('0x4d')](_0x235216[_0xd1b4('0x41')],_0x1d0c4f['filters']));if(_0x235216[_0xd1b4('0x41')]['filter']){_0x33774e['where']=_['merge'](_0x33774e[_0xd1b4('0x4c')],{'$or':_[_0xd1b4('0x3b')](_0x33774e[_0xd1b4('0x45')],function(_0x4509b8){var _0x3f002f={};_0x3f002f[_0x4509b8]={'$like':'%'+_0x235216[_0xd1b4('0x41')]['filter']+'%'};return _0x3f002f;})});}_0x33774e=_[_0xd1b4('0x4f')]({},_0x33774e,_0x235216[_0xd1b4('0x50')]);return _0x21b037[_0xd1b4('0x5a')](_0x33774e);}})[_0xd1b4('0x1f')](function(_0x324fa2){if(_0x324fa2){_0x314360=_0x324fa2[_0xd1b4('0x47')];if(!_0x235216[_0xd1b4('0x41')][_0xd1b4('0x48')](_0xd1b4('0x49'))){_0x33774e[_0xd1b4('0x4a')]=qs[_0xd1b4('0x4a')](_0x235216[_0xd1b4('0x41')]['limit']);_0x33774e[_0xd1b4('0x2f')]=qs['offset'](_0x235216[_0xd1b4('0x41')][_0xd1b4('0x2f')]);}return _0x21b037[_0xd1b4('0x5a')](_0x33774e);}})[_0xd1b4('0x1f')](function(_0xf761c){if(_0xf761c){return _0xf761c?{'count':_0x314360,'rows':_0xf761c}:null;}})[_0xd1b4('0x1f')](respondWithResult(_0x2e1e5a,null))['catch'](handleError(_0x2e1e5a,null));};exports[_0xd1b4('0x5d')]=function(_0x29e763,_0x3f584c,_0x4f2f2a){var _0x1f67e={};var _0x175287={};var _0x7accee;var _0x57d532;return db[_0xd1b4('0x53')][_0xd1b4('0x5e')]({'where':{'id':_0x29e763[_0xd1b4('0x59')]['id']}})['then'](handleEntityNotFound(_0x3f584c,null))[_0xd1b4('0x1f')](function(_0xc1025a){if(_0xc1025a){_0x7accee=_0xc1025a;_0x175287[_0xd1b4('0x40')]=_[_0xd1b4('0x42')](db[_0xd1b4('0x5b')]['rawAttributes']);_0x175287['query']=_['keys'](_0x29e763[_0xd1b4('0x41')]);_0x175287[_0xd1b4('0x43')]=_[_0xd1b4('0x44')](_0x175287[_0xd1b4('0x40')],_0x175287[_0xd1b4('0x41')]);_0x1f67e[_0xd1b4('0x45')]=_[_0xd1b4('0x44')](_0x175287[_0xd1b4('0x40')],qs[_0xd1b4('0x46')](_0x29e763[_0xd1b4('0x41')]['fields']));_0x1f67e['attributes']=_0x1f67e['attributes'][_0xd1b4('0x47')]?_0x1f67e[_0xd1b4('0x45')]:_0x175287[_0xd1b4('0x40')];_0x1f67e[_0xd1b4('0x5c')]=qs[_0xd1b4('0x4b')](_0x29e763['query']['sort']);_0x1f67e[_0xd1b4('0x4c')]=qs[_0xd1b4('0x43')](_[_0xd1b4('0x4d')](_0x29e763[_0xd1b4('0x41')],_0x175287[_0xd1b4('0x43')]));if(_0x29e763['query'][_0xd1b4('0x5f')]){_0x1f67e[_0xd1b4('0x4c')]=_[_0xd1b4('0x4f')](_0x1f67e[_0xd1b4('0x4c')],{'$or':_[_0xd1b4('0x3b')](_0x1f67e[_0xd1b4('0x45')],function(_0x12ef86){var _0x4f90f3={};_0x4f90f3[_0x12ef86]={'$like':'%'+_0x29e763[_0xd1b4('0x41')][_0xd1b4('0x5f')]+'%'};return _0x4f90f3;})});}_0x1f67e=_[_0xd1b4('0x4f')]({},_0x1f67e,_0x29e763[_0xd1b4('0x50')]);return _0x7accee[_0xd1b4('0x5d')](_0x1f67e);}})['then'](function(_0x5267df){if(_0x5267df){_0x57d532=_0x5267df[_0xd1b4('0x47')];if(!_0x29e763[_0xd1b4('0x41')][_0xd1b4('0x48')](_0xd1b4('0x49'))){_0x1f67e[_0xd1b4('0x4a')]=qs['limit'](_0x29e763[_0xd1b4('0x41')][_0xd1b4('0x4a')]);_0x1f67e['offset']=qs[_0xd1b4('0x2f')](_0x29e763[_0xd1b4('0x41')]['offset']);}return _0x7accee[_0xd1b4('0x5d')](_0x1f67e);}})[_0xd1b4('0x1f')](function(_0x3cbdc9){if(_0x3cbdc9){return _0x3cbdc9?{'count':_0x57d532,'rows':_0x3cbdc9}:null;}})[_0xd1b4('0x1f')](respondWithResult(_0x3f584c,null))[_0xd1b4('0x2a')](handleError(_0x3f584c,null));};exports[_0xd1b4('0x60')]=function(_0x34594e,_0x7ba111,_0x1e52ce){var _0x12e699={};var _0x19b56d={};var _0x51cd57;var _0x27c92a;return db[_0xd1b4('0x53')][_0xd1b4('0x5e')]({'where':{'id':_0x34594e[_0xd1b4('0x59')]['id']}})['then'](handleEntityNotFound(_0x7ba111,null))['then'](function(_0x586003){if(_0x586003){_0x51cd57=_0x586003;_0x19b56d[_0xd1b4('0x40')]=_['keys'](db['FreshdeskField'][_0xd1b4('0x3c')]);_0x19b56d[_0xd1b4('0x41')]=_[_0xd1b4('0x42')](_0x34594e[_0xd1b4('0x41')]);_0x19b56d[_0xd1b4('0x43')]=_['intersection'](_0x19b56d['model'],_0x19b56d[_0xd1b4('0x41')]);_0x12e699[_0xd1b4('0x45')]=_['intersection'](_0x19b56d['model'],qs[_0xd1b4('0x46')](_0x34594e[_0xd1b4('0x41')][_0xd1b4('0x46')]));_0x12e699[_0xd1b4('0x45')]=_0x12e699[_0xd1b4('0x45')]['length']?_0x12e699[_0xd1b4('0x45')]:_0x19b56d[_0xd1b4('0x40')];_0x12e699[_0xd1b4('0x5c')]=qs[_0xd1b4('0x4b')](_0x34594e[_0xd1b4('0x41')][_0xd1b4('0x4b')]);_0x12e699['where']=qs[_0xd1b4('0x43')](_[_0xd1b4('0x4d')](_0x34594e[_0xd1b4('0x41')],_0x19b56d[_0xd1b4('0x43')]));if(_0x34594e['query'][_0xd1b4('0x5f')]){_0x12e699[_0xd1b4('0x4c')]=_[_0xd1b4('0x4f')](_0x12e699[_0xd1b4('0x4c')],{'$or':_[_0xd1b4('0x3b')](_0x12e699[_0xd1b4('0x45')],function(_0x3cafd3){var _0x250b11={};_0x250b11[_0x3cafd3]={'$like':'%'+_0x34594e[_0xd1b4('0x41')][_0xd1b4('0x5f')]+'%'};return _0x250b11;})});}_0x12e699=_[_0xd1b4('0x4f')]({},_0x12e699,_0x34594e[_0xd1b4('0x50')]);return _0x51cd57[_0xd1b4('0x60')](_0x12e699);}})['then'](function(_0xd56887){if(_0xd56887){_0x27c92a=_0xd56887[_0xd1b4('0x47')];if(!_0x34594e[_0xd1b4('0x41')][_0xd1b4('0x48')](_0xd1b4('0x49'))){_0x12e699[_0xd1b4('0x4a')]=qs[_0xd1b4('0x4a')](_0x34594e[_0xd1b4('0x41')][_0xd1b4('0x4a')]);_0x12e699['offset']=qs['offset'](_0x34594e[_0xd1b4('0x41')]['offset']);}return _0x51cd57[_0xd1b4('0x60')](_0x12e699);}})['then'](function(_0x165277){if(_0x165277){return _0x165277?{'count':_0x27c92a,'rows':_0x165277}:null;}})[_0xd1b4('0x1f')](respondWithResult(_0x7ba111,null))['catch'](handleError(_0x7ba111,null));};exports[_0xd1b4('0x61')]=function(_0x501afe,_0x1d705c,_0x474afb){var _0x59e5da={};var _0x1a379d={};var _0x4562c7;var _0x3a07fc;return db[_0xd1b4('0x53')][_0xd1b4('0x5e')]({'where':{'id':_0x501afe[_0xd1b4('0x59')]['id']}})[_0xd1b4('0x1f')](handleEntityNotFound(_0x1d705c,null))['then'](function(_0x519b48){if(_0x519b48){_0x4562c7=_0x519b48;_0x1a379d[_0xd1b4('0x40')]=_[_0xd1b4('0x42')](db[_0xd1b4('0x62')][_0xd1b4('0x3c')]);_0x1a379d[_0xd1b4('0x41')]=_[_0xd1b4('0x42')](_0x501afe['query']);_0x1a379d[_0xd1b4('0x43')]=_[_0xd1b4('0x44')](_0x1a379d[_0xd1b4('0x40')],_0x1a379d['query']);_0x59e5da['attributes']=_[_0xd1b4('0x44')](_0x1a379d[_0xd1b4('0x40')],qs['fields'](_0x501afe[_0xd1b4('0x41')]['fields']));_0x59e5da[_0xd1b4('0x45')]=_0x59e5da[_0xd1b4('0x45')][_0xd1b4('0x47')]?_0x59e5da['attributes']:_0x1a379d[_0xd1b4('0x40')];_0x59e5da[_0xd1b4('0x5c')]=qs['sort'](_0x501afe[_0xd1b4('0x41')]['sort']);_0x59e5da['where']=qs['filters'](_[_0xd1b4('0x4d')](_0x501afe['query'],_0x1a379d[_0xd1b4('0x43')]));if(_0x501afe[_0xd1b4('0x41')][_0xd1b4('0x5f')]){_0x59e5da['where']=_[_0xd1b4('0x4f')](_0x59e5da[_0xd1b4('0x4c')],{'$or':_['map'](_0x59e5da[_0xd1b4('0x45')],function(_0x1b1c94){var _0x50f91f={};_0x50f91f[_0x1b1c94]={'$like':'%'+_0x501afe[_0xd1b4('0x41')][_0xd1b4('0x5f')]+'%'};return _0x50f91f;})});}_0x59e5da=_[_0xd1b4('0x4f')]({},_0x59e5da,_0x501afe[_0xd1b4('0x50')]);return _0x4562c7['getTags'](_0x59e5da);}})[_0xd1b4('0x1f')](function(_0x34ee62){if(_0x34ee62){_0x3a07fc=_0x34ee62['length'];if(!_0x501afe[_0xd1b4('0x41')]['hasOwnProperty'](_0xd1b4('0x49'))){_0x59e5da['limit']=qs[_0xd1b4('0x4a')](_0x501afe[_0xd1b4('0x41')][_0xd1b4('0x4a')]);_0x59e5da[_0xd1b4('0x2f')]=qs['offset'](_0x501afe['query']['offset']);}return _0x4562c7[_0xd1b4('0x61')](_0x59e5da);}})[_0xd1b4('0x1f')](function(_0x16553c){if(_0x16553c){return _0x16553c?{'count':_0x3a07fc,'rows':_0x16553c}:null;}})[_0xd1b4('0x1f')](respondWithResult(_0x1d705c,null))['catch'](handleError(_0x1d705c,null));};exports[_0xd1b4('0x63')]=function(_0x898613,_0x380f9b,_0x768cfa){if(_0x898613['body']['id']){delete _0x898613[_0xd1b4('0x58')]['id'];}return db['FreshdeskConfiguration'][_0xd1b4('0x5e')]({'where':{'id':_0x898613[_0xd1b4('0x59')]['id']}})[_0xd1b4('0x1f')](handleEntityNotFound(_0x380f9b,null))['then'](function(_0x2f54c5){if(_0x2f54c5){return _0x2f54c5['setTags'](_0x898613['body']['ids']||[]);}return null;})['then'](respondWithResult(_0x380f9b,null))[_0xd1b4('0x2a')](handleError(_0x380f9b,null));};