server/api/migration/migration.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 _0xfe7b=['update','then','error','stack','name','send','index','map','Migration','fieldName','key','model','query','keys','filters','intersection','attributes','fields','length','nolimit','order','sort','where','pick','filter','type','merge','options','includeAll','include','rows','catch','eml-format','zip-dir','fast-json-patch','moment','util','sox','ejs','fs-extra','lodash','squel','crypto','jsforce','desk.js','to-csv','querystring','papaparse','ioredis','../../components/auth/service','../../components/parsers/qs','../../config/license/hardware','../../config/logger','api','../../config/utils','../../config/environment','../../config/license/util','sendStatus','status','end','json','offset','undefined','limit','count','set','Content-Range','apply','save'];(function(_0x4ef1b6,_0x502ac2){var _0x164c1f=function(_0x3c6ee2){while(--_0x3c6ee2){_0x4ef1b6['push'](_0x4ef1b6['shift']());}};_0x164c1f(++_0x502ac2);}(_0xfe7b,0xef));var _0xbfe7=function(_0x282a1f,_0x49a6ef){_0x282a1f=_0x282a1f-0x0;var _0x296ea7=_0xfe7b[_0x282a1f];return _0x296ea7;};'use strict';var emlformat=require(_0xbfe7('0x0'));var rimraf=require('rimraf');var zipdir=require(_0xbfe7('0x1'));var jsonpatch=require(_0xbfe7('0x2'));var rp=require('request-promise');var moment=require(_0xbfe7('0x3'));var BPromise=require('bluebird');var Mustache=require('mustache');var util=require(_0xbfe7('0x4'));var path=require('path');var sox=require(_0xbfe7('0x5'));var csv=require('to-csv');var ejs=require(_0xbfe7('0x6'));var fs=require('fs');var fs_extra=require(_0xbfe7('0x7'));var _=require(_0xbfe7('0x8'));var squel=require(_0xbfe7('0x9'));var crypto=require(_0xbfe7('0xa'));var jsforce=require(_0xbfe7('0xb'));var deskjs=require(_0xbfe7('0xc'));var toCsv=require(_0xbfe7('0xd'));var querystring=require(_0xbfe7('0xe'));var Papa=require(_0xbfe7('0xf'));var Redis=require(_0xbfe7('0x10'));var authService=require(_0xbfe7('0x11'));var qs=require(_0xbfe7('0x12'));var as=require('../../components/parsers/advancedSearch');var hardwareService=require(_0xbfe7('0x13'));var logger=require(_0xbfe7('0x14'))(_0xbfe7('0x15'));var utils=require(_0xbfe7('0x16'));var config=require(_0xbfe7('0x17'));var licenseUtil=require(_0xbfe7('0x18'));var db=require('../../mysqldb')['db'];function respondWithStatusCode(_0x569559,_0x5cc7e5){_0x5cc7e5=_0x5cc7e5||0xcc;return function(_0x4a1e32){if(_0x4a1e32){return _0x569559[_0xbfe7('0x19')](_0x5cc7e5);}return _0x569559[_0xbfe7('0x1a')](_0x5cc7e5)[_0xbfe7('0x1b')]();};}function respondWithResult(_0xf0b9ed,_0x26bfa7){_0x26bfa7=_0x26bfa7||0xc8;return function(_0x5ddcf6){if(_0x5ddcf6){return _0xf0b9ed['status'](_0x26bfa7)[_0xbfe7('0x1c')](_0x5ddcf6);}};}function respondWithFilteredResult(_0x580760,_0x409d9d){return function(_0x3da16f){if(_0x3da16f){var _0x3fe50b=typeof _0x409d9d[_0xbfe7('0x1d')]===_0xbfe7('0x1e')&&typeof _0x409d9d[_0xbfe7('0x1f')]===_0xbfe7('0x1e');var _0x3a78c2=_0x3da16f['count'];var _0x182281=_0x3fe50b?0x0:_0x409d9d[_0xbfe7('0x1d')];var _0x30a4b1=_0x3fe50b?_0x3da16f[_0xbfe7('0x20')]:_0x409d9d[_0xbfe7('0x1d')]+_0x409d9d[_0xbfe7('0x1f')];var _0x373245;if(_0x30a4b1>=_0x3a78c2){_0x30a4b1=_0x3a78c2;_0x373245=0xc8;}else{_0x373245=0xce;}_0x580760['status'](_0x373245);return _0x580760[_0xbfe7('0x21')](_0xbfe7('0x22'),_0x182281+'-'+_0x30a4b1+'/'+_0x3a78c2)[_0xbfe7('0x1c')](_0x3da16f);}return null;};}function patchUpdates(_0x5654de){return function(_0x21581e){try{jsonpatch[_0xbfe7('0x23')](_0x21581e,_0x5654de,!![]);}catch(_0x5a8178){return BPromise['reject'](_0x5a8178);}return _0x21581e[_0xbfe7('0x24')]();};}function saveUpdates(_0x35902b,_0x976004){return function(_0x4a4f8f){if(_0x4a4f8f){return _0x4a4f8f[_0xbfe7('0x25')](_0x35902b)[_0xbfe7('0x26')](function(_0x212b72){return _0x212b72;});}return null;};}function removeEntity(_0x3f2582,_0x1f68a5){return function(_0x1e0be1){if(_0x1e0be1){return _0x1e0be1['destroy']()[_0xbfe7('0x26')](function(){_0x3f2582[_0xbfe7('0x1a')](0xcc)[_0xbfe7('0x1b')]();});}};}function handleEntityNotFound(_0x1dbcdb,_0xb83d8d){return function(_0x2eb9b8){if(!_0x2eb9b8){_0x1dbcdb[_0xbfe7('0x19')](0x194);}return _0x2eb9b8;};}function handleError(_0xfdb1ff,_0x1880bb){_0x1880bb=_0x1880bb||0x1f4;return function(_0x58f009){logger[_0xbfe7('0x27')](_0x58f009[_0xbfe7('0x28')]);if(_0x58f009[_0xbfe7('0x29')]){delete _0x58f009['name'];}_0xfdb1ff[_0xbfe7('0x1a')](_0x1880bb)[_0xbfe7('0x2a')](_0x58f009);};}exports[_0xbfe7('0x2b')]=function(_0x1924cd,_0xe4cd5c){var _0x2191ba={},_0x1f629d={},_0x11b3d7={'count':0x0,'rows':[]};var _0x4fa7ba=_[_0xbfe7('0x2c')](db[_0xbfe7('0x2d')]['rawAttributes'],function(_0x3c06af){return{'name':_0x3c06af[_0xbfe7('0x2e')],'type':_0x3c06af['type'][_0xbfe7('0x2f')]};});_0x1f629d[_0xbfe7('0x30')]=_[_0xbfe7('0x2c')](_0x4fa7ba,_0xbfe7('0x29'));_0x1f629d[_0xbfe7('0x31')]=_[_0xbfe7('0x32')](_0x1924cd[_0xbfe7('0x31')]);_0x1f629d[_0xbfe7('0x33')]=_[_0xbfe7('0x34')](_0x1f629d[_0xbfe7('0x30')],_0x1f629d[_0xbfe7('0x31')]);_0x2191ba[_0xbfe7('0x35')]=_[_0xbfe7('0x34')](_0x1f629d[_0xbfe7('0x30')],qs[_0xbfe7('0x36')](_0x1924cd[_0xbfe7('0x31')]['fields']));_0x2191ba[_0xbfe7('0x35')]=_0x2191ba[_0xbfe7('0x35')][_0xbfe7('0x37')]?_0x2191ba[_0xbfe7('0x35')]:_0x1f629d[_0xbfe7('0x30')];if(!_0x1924cd[_0xbfe7('0x31')]['hasOwnProperty'](_0xbfe7('0x38'))){_0x2191ba['limit']=qs[_0xbfe7('0x1f')](_0x1924cd['query'][_0xbfe7('0x1f')]);_0x2191ba[_0xbfe7('0x1d')]=qs[_0xbfe7('0x1d')](_0x1924cd[_0xbfe7('0x31')][_0xbfe7('0x1d')]);}_0x2191ba[_0xbfe7('0x39')]=qs[_0xbfe7('0x3a')](_0x1924cd[_0xbfe7('0x31')][_0xbfe7('0x3a')]);_0x2191ba[_0xbfe7('0x3b')]=qs[_0xbfe7('0x33')](_[_0xbfe7('0x3c')](_0x1924cd[_0xbfe7('0x31')],_0x1f629d['filters']),_0x4fa7ba);if(_0x1924cd[_0xbfe7('0x31')][_0xbfe7('0x3d')]){_0x2191ba['where']=_['merge'](_0x2191ba['where'],{'$or':_['map'](_0x4fa7ba,function(_0x1b24fb){if(_0x1b24fb[_0xbfe7('0x3e')]!=='VIRTUAL'){var _0xeb07e0={};_0xeb07e0[_0x1b24fb[_0xbfe7('0x29')]]={'$like':'%'+_0x1924cd['query'][_0xbfe7('0x3d')]+'%'};return _0xeb07e0;}})});}_0x2191ba=_[_0xbfe7('0x3f')]({},_0x2191ba,_0x1924cd[_0xbfe7('0x40')]);var _0x174c03={'where':_0x2191ba[_0xbfe7('0x3b')]};return db['Migration'][_0xbfe7('0x20')](_0x174c03)[_0xbfe7('0x26')](function(_0x285b0c){_0x11b3d7[_0xbfe7('0x20')]=_0x285b0c;if(_0x1924cd[_0xbfe7('0x31')][_0xbfe7('0x41')]){_0x2191ba[_0xbfe7('0x42')]=[{'all':!![]}];}return db[_0xbfe7('0x2d')]['findAll'](_0x2191ba);})['then'](function(_0x5ef0c0){_0x11b3d7[_0xbfe7('0x43')]=_0x5ef0c0;return _0x11b3d7;})[_0xbfe7('0x26')](respondWithFilteredResult(_0xe4cd5c,_0x2191ba))[_0xbfe7('0x44')](handleError(_0xe4cd5c,null));};