server/api/attachment/attachment.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 _0x0614=['intersection','attributes','fields','length','nolimit','sort','where','filters','pick','filter','merge','VIRTUAL','options','includeAll','include','rows','catch','show','params','keys','get','omit','createdAt','updatedAt','body','create','update','find','file','originalname','basename','download','ChatOfflineMessageId','join','root','server/files/attachments/','offline-chat/','rimraf','fast-json-patch','moment','bluebird','util','sox','to-csv','ejs','fs-extra','lodash','squel','crypto','desk.js','querystring','../../components/parsers/qs','../../components/parsers/advancedSearch','../../config/logger','../../config/utils','../../mysqldb','sendStatus','status','end','json','offset','undefined','count','limit','set','Content-Range','apply','reject','save','then','destroy','error','stack','name','index','Attachment','rawAttributes','fieldName','type','key','model','map','query'];(function(_0x18983b,_0x41d586){var _0x3ed24c=function(_0x318485){while(--_0x318485){_0x18983b['push'](_0x18983b['shift']());}};_0x3ed24c(++_0x41d586);}(_0x0614,0x78));var _0x4061=function(_0x485f73,_0x5de6e0){_0x485f73=_0x485f73-0x0;var _0x18f73b=_0x0614[_0x485f73];return _0x18f73b;};'use strict';var emlformat=require('eml-format');var rimraf=require(_0x4061('0x0'));var zipdir=require('zip-dir');var jsonpatch=require(_0x4061('0x1'));var rp=require('request-promise');var moment=require(_0x4061('0x2'));var BPromise=require(_0x4061('0x3'));var Mustache=require('mustache');var util=require(_0x4061('0x4'));var path=require('path');var sox=require(_0x4061('0x5'));var csv=require(_0x4061('0x6'));var ejs=require(_0x4061('0x7'));var fs=require('fs');var fs_extra=require(_0x4061('0x8'));var _=require(_0x4061('0x9'));var squel=require(_0x4061('0xa'));var crypto=require(_0x4061('0xb'));var jsforce=require('jsforce');var deskjs=require(_0x4061('0xc'));var toCsv=require(_0x4061('0x6'));var querystring=require(_0x4061('0xd'));var Papa=require('papaparse');var Redis=require('ioredis');var authService=require('../../components/auth/service');var qs=require(_0x4061('0xe'));var as=require(_0x4061('0xf'));var hardwareService=require('../../config/license/hardware');var logger=require(_0x4061('0x10'))('api');var utils=require(_0x4061('0x11'));var config=require('../../config/environment');var licenseUtil=require('../../config/license/util');var db=require(_0x4061('0x12'))['db'];function respondWithStatusCode(_0x2aa057,_0x995687){_0x995687=_0x995687||0xcc;return function(_0xb91a0f){if(_0xb91a0f){return _0x2aa057[_0x4061('0x13')](_0x995687);}return _0x2aa057[_0x4061('0x14')](_0x995687)[_0x4061('0x15')]();};}function respondWithResult(_0x31daca,_0x1887c9){_0x1887c9=_0x1887c9||0xc8;return function(_0xc09e06){if(_0xc09e06){return _0x31daca[_0x4061('0x14')](_0x1887c9)[_0x4061('0x16')](_0xc09e06);}};}function respondWithFilteredResult(_0x7f651b,_0x367a23){return function(_0x1ff668){if(_0x1ff668){var _0x2d24cf=typeof _0x367a23[_0x4061('0x17')]===_0x4061('0x18')&&typeof _0x367a23['limit']===_0x4061('0x18');var _0x2a96c7=_0x1ff668[_0x4061('0x19')];var _0x537e40=_0x2d24cf?0x0:_0x367a23[_0x4061('0x17')];var _0x352546=_0x2d24cf?_0x1ff668[_0x4061('0x19')]:_0x367a23[_0x4061('0x17')]+_0x367a23[_0x4061('0x1a')];var _0x5e4362;if(_0x352546>=_0x2a96c7){_0x352546=_0x2a96c7;_0x5e4362=0xc8;}else{_0x5e4362=0xce;}_0x7f651b[_0x4061('0x14')](_0x5e4362);return _0x7f651b[_0x4061('0x1b')](_0x4061('0x1c'),_0x537e40+'-'+_0x352546+'/'+_0x2a96c7)[_0x4061('0x16')](_0x1ff668);}return null;};}function patchUpdates(_0x4caa30){return function(_0x4f5afc){try{jsonpatch[_0x4061('0x1d')](_0x4f5afc,_0x4caa30,!![]);}catch(_0x2db974){return BPromise[_0x4061('0x1e')](_0x2db974);}return _0x4f5afc[_0x4061('0x1f')]();};}function saveUpdates(_0x4e1979,_0x25344c){return function(_0x3fbc7f){if(_0x3fbc7f){return _0x3fbc7f['update'](_0x4e1979)[_0x4061('0x20')](function(_0x249aef){return _0x249aef;});}return null;};}function removeEntity(_0x49f170,_0x29f60f){return function(_0x5bc2b0){if(_0x5bc2b0){return _0x5bc2b0[_0x4061('0x21')]()[_0x4061('0x20')](function(){_0x49f170[_0x4061('0x14')](0xcc)[_0x4061('0x15')]();});}};}function handleEntityNotFound(_0x1e72a3,_0x252ef2){return function(_0x292b48){if(!_0x292b48){_0x1e72a3[_0x4061('0x13')](0x194);}return _0x292b48;};}function handleError(_0x42c678,_0xb54332){_0xb54332=_0xb54332||0x1f4;return function(_0x402d6c){logger[_0x4061('0x22')](_0x402d6c[_0x4061('0x23')]);if(_0x402d6c[_0x4061('0x24')]){delete _0x402d6c[_0x4061('0x24')];}_0x42c678[_0x4061('0x14')](_0xb54332)['send'](_0x402d6c);};}exports[_0x4061('0x25')]=function(_0x4e27cd,_0x4f07d8){var _0x16806c={},_0x4d1271={},_0x10970d={'count':0x0,'rows':[]};var _0x5b35be=_['map'](db[_0x4061('0x26')][_0x4061('0x27')],function(_0x5ad5e3){return{'name':_0x5ad5e3[_0x4061('0x28')],'type':_0x5ad5e3[_0x4061('0x29')][_0x4061('0x2a')]};});_0x4d1271[_0x4061('0x2b')]=_[_0x4061('0x2c')](_0x5b35be,'name');_0x4d1271['query']=_['keys'](_0x4e27cd[_0x4061('0x2d')]);_0x4d1271['filters']=_[_0x4061('0x2e')](_0x4d1271['model'],_0x4d1271[_0x4061('0x2d')]);_0x16806c[_0x4061('0x2f')]=_[_0x4061('0x2e')](_0x4d1271[_0x4061('0x2b')],qs[_0x4061('0x30')](_0x4e27cd[_0x4061('0x2d')]['fields']));_0x16806c['attributes']=_0x16806c[_0x4061('0x2f')][_0x4061('0x31')]?_0x16806c['attributes']:_0x4d1271['model'];if(!_0x4e27cd[_0x4061('0x2d')]['hasOwnProperty'](_0x4061('0x32'))){_0x16806c[_0x4061('0x1a')]=qs[_0x4061('0x1a')](_0x4e27cd['query'][_0x4061('0x1a')]);_0x16806c[_0x4061('0x17')]=qs['offset'](_0x4e27cd['query'][_0x4061('0x17')]);}_0x16806c['order']=qs[_0x4061('0x33')](_0x4e27cd['query'][_0x4061('0x33')]);_0x16806c[_0x4061('0x34')]=qs[_0x4061('0x35')](_[_0x4061('0x36')](_0x4e27cd[_0x4061('0x2d')],_0x4d1271[_0x4061('0x35')]),_0x5b35be);if(_0x4e27cd[_0x4061('0x2d')][_0x4061('0x37')]){_0x16806c['where']=_[_0x4061('0x38')](_0x16806c[_0x4061('0x34')],{'$or':_[_0x4061('0x2c')](_0x5b35be,function(_0x5d97da){if(_0x5d97da[_0x4061('0x29')]!==_0x4061('0x39')){var _0x47d863={};_0x47d863[_0x5d97da[_0x4061('0x24')]]={'$like':'%'+_0x4e27cd[_0x4061('0x2d')][_0x4061('0x37')]+'%'};return _0x47d863;}})});}_0x16806c=_[_0x4061('0x38')]({},_0x16806c,_0x4e27cd[_0x4061('0x3a')]);var _0x58d242={'where':_0x16806c[_0x4061('0x34')]};return db['Attachment']['count'](_0x58d242)[_0x4061('0x20')](function(_0x1264b2){_0x10970d[_0x4061('0x19')]=_0x1264b2;if(_0x4e27cd[_0x4061('0x2d')][_0x4061('0x3b')]){_0x16806c[_0x4061('0x3c')]=[{'all':!![]}];}return db[_0x4061('0x26')]['findAll'](_0x16806c);})[_0x4061('0x20')](function(_0x3c0763){_0x10970d[_0x4061('0x3d')]=_0x3c0763;return _0x10970d;})['then'](respondWithFilteredResult(_0x4f07d8,_0x16806c))[_0x4061('0x3e')](handleError(_0x4f07d8,null));};exports[_0x4061('0x3f')]=function(_0x41db9c,_0x38a807){var _0x342189={'raw':!![],'where':{'id':_0x41db9c[_0x4061('0x40')]['id']}},_0x4c85c1={};_0x4c85c1[_0x4061('0x2b')]=_['keys'](db[_0x4061('0x26')][_0x4061('0x27')]);_0x4c85c1[_0x4061('0x2d')]=_['keys'](_0x41db9c['query']);_0x4c85c1[_0x4061('0x35')]=_[_0x4061('0x2e')](_0x4c85c1[_0x4061('0x2b')],_0x4c85c1['query']);_0x342189[_0x4061('0x2f')]=_[_0x4061('0x2e')](_0x4c85c1[_0x4061('0x2b')],qs[_0x4061('0x30')](_0x41db9c[_0x4061('0x2d')]['fields']));_0x342189[_0x4061('0x2f')]=_0x342189[_0x4061('0x2f')][_0x4061('0x31')]?_0x342189['attributes']:_0x4c85c1[_0x4061('0x2b')];if(_0x41db9c[_0x4061('0x2d')]['includeAll']){_0x342189[_0x4061('0x3c')]=[{'all':!![]}];}_0x342189=_[_0x4061('0x38')]({},_0x342189,_0x41db9c[_0x4061('0x3a')]);return db[_0x4061('0x26')]['find'](_0x342189)[_0x4061('0x20')](handleEntityNotFound(_0x38a807,null))['then'](respondWithResult(_0x38a807,null))['catch'](handleError(_0x38a807,null));};exports['clone']=function(_0x13b78a,_0x1b37bc){var _0x42c2cf={'where':{'id':_0x13b78a[_0x4061('0x40')]['id']}},_0x44076a={};_0x44076a[_0x4061('0x2b')]=_[_0x4061('0x41')](db['Attachment'][_0x4061('0x27')]);_0x42c2cf[_0x4061('0x2f')]=_[_0x4061('0x2e')](_0x44076a[_0x4061('0x2b')],qs['fields'](_0x13b78a[_0x4061('0x2d')]['fields']));_0x42c2cf[_0x4061('0x2f')]=_0x42c2cf[_0x4061('0x2f')][_0x4061('0x31')]?_0x42c2cf[_0x4061('0x2f')]:_0x44076a[_0x4061('0x2b')];if(_0x13b78a[_0x4061('0x2d')][_0x4061('0x3b')]){_0x42c2cf['include']=[{'all':!![]}];}_0x42c2cf=_[_0x4061('0x38')]({},_0x42c2cf,_0x13b78a['options']);return db[_0x4061('0x26')]['find'](_0x42c2cf)[_0x4061('0x20')](handleEntityNotFound(_0x1b37bc,null))[_0x4061('0x20')](function(_0x3941ab){if(_0x3941ab){var _0x1a322f=_0x3941ab[_0x4061('0x42')]({'plain':!![]});_0x1a322f=qs[_0x4061('0x43')](_0x1a322f,['id',_0x4061('0x44'),_0x4061('0x45')]);_0x13b78a[_0x4061('0x46')]=_['omit'](_0x13b78a['body'],['id',_0x4061('0x44'),_0x4061('0x45')]);return db[_0x4061('0x26')][_0x4061('0x47')](_[_0x4061('0x38')](_0x1a322f,_0x13b78a[_0x4061('0x46')]),{'include':_0x13b78a[_0x4061('0x2d')][_0x4061('0x3b')]?[{'all':!![]}]:undefined});}})[_0x4061('0x20')](respondWithResult(_0x1b37bc,0xc9))[_0x4061('0x3e')](handleError(_0x1b37bc,null));};exports[_0x4061('0x48')]=function(_0x10c140,_0x469a8b){if(_0x10c140[_0x4061('0x46')]['id']){delete _0x10c140[_0x4061('0x46')]['id'];}return db[_0x4061('0x26')][_0x4061('0x49')]({'where':{'id':_0x10c140[_0x4061('0x40')]['id']}})['then'](handleEntityNotFound(_0x469a8b,null))[_0x4061('0x20')](saveUpdates(_0x10c140['body'],null))[_0x4061('0x20')](respondWithResult(_0x469a8b,null))[_0x4061('0x3e')](handleError(_0x469a8b,null));};exports[_0x4061('0x21')]=function(_0x4fad0a,_0x124b6a){return db[_0x4061('0x26')][_0x4061('0x49')]({'where':{'id':_0x4fad0a[_0x4061('0x40')]['id']}})[_0x4061('0x20')](handleEntityNotFound(_0x124b6a,null))[_0x4061('0x20')](removeEntity(_0x124b6a,null))[_0x4061('0x3e')](handleError(_0x124b6a,null));};exports[_0x4061('0x47')]=function(_0x332986,_0x3125fb,_0x5ec3ae){_0x332986[_0x4061('0x46')]['name']=_0x332986[_0x4061('0x4a')][_0x4061('0x4b')];_0x332986[_0x4061('0x46')][_0x4061('0x4c')]=_0x332986[_0x4061('0x4a')]['filename'];_0x332986['body']['type']=_0x332986[_0x4061('0x4a')]['mimetype'];return db[_0x4061('0x26')][_0x4061('0x47')](_0x332986[_0x4061('0x46')])['then'](respondWithResult(_0x3125fb,0xc9))[_0x4061('0x3e')](handleError(_0x3125fb,null));};exports[_0x4061('0x4d')]=function(_0x5710fd,_0x4455c2,_0x140e22){return db[_0x4061('0x26')]['findOne']({'where':{'id':_0x5710fd[_0x4061('0x40')]['id']},'raw':!![]})[_0x4061('0x20')](handleEntityNotFound(_0x4455c2,null))['then'](function(_0x2c27a9){if(_0x2c27a9){var _0x789e56=_0x2c27a9[_0x4061('0x4e')]!==null;var _0x58c4b9=path[_0x4061('0x4f')](config[_0x4061('0x50')],_0x4061('0x51'));if(_0x789e56){_0x58c4b9=path['join'](_0x58c4b9,_0x4061('0x52'));}var _0x4cc613=path[_0x4061('0x4f')](_0x58c4b9,_0x2c27a9[_0x4061('0x4c')]);return _0x4455c2[_0x4061('0x4d')](_0x4cc613);}})[_0x4061('0x3e')](handleError(_0x4455c2,null));};