server/components/export/xlsx.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 _0x0841=['format','SELECT\x20count(*)\x20as\x20num\x20FROM\x20(%s)\x20t','sequelize','Empty','length','num','push','query','%s\x20limit\x20%d\x20OFFSET\x20%d','QueryTypes','SELECT','dirname','basename','.xlsx','existsSync','join','mkdirSync','each','%s%d.%s','xlsx','%s.%s','writeFileSync','binary','Completed','zip','catch','error','path','lodash','bluebird','rimraf','../../mysqldb','dbH','argv','savename','AnalyticExtractedReport','update','Setting','find','split','splitSizeXlsx','then'];(function(_0x1b6563,_0x3bf0f1){var _0xdea7b8=function(_0x49e6c6){while(--_0x49e6c6){_0x1b6563['push'](_0x1b6563['shift']());}};_0xdea7b8(++_0x3bf0f1);}(_0x0841,0x6f));var _0x1084=function(_0x135332,_0x464ba3){_0x135332=_0x135332-0x0;var _0x2d0b6e=_0x0841[_0x135332];return _0x2d0b6e;};'use strict';var util=require('util');var path=require(_0x1084('0x0'));var _=require(_0x1084('0x1'));var fs=require('fs');var json2xls=require('json2xls');var BPromise=require(_0x1084('0x2'));var zipdir=require('zip-dir');var rimraf=require(_0x1084('0x3'));var db=require(_0x1084('0x4'))['db'];var dbH=require('../../mysqldb')[_0x1084('0x5')];var EXTRACTED_REPORT_ID=Number(process['argv'][0x2]);var QUERY=process['argv'][0x3];var PATH=process[_0x1084('0x6')][0x4];function analyticExtractedReport(_0x204972,_0x441e04){var _0x5d24a5={'status':_0x204972};var _0x5cae15={'where':{'id':EXTRACTED_REPORT_ID}};if(_0x441e04){_0x5d24a5[_0x1084('0x7')]=_0x441e04;}return db[_0x1084('0x8')][_0x1084('0x9')](_0x5d24a5,_0x5cae15);}function main(){var _0x5893da=0x1388;var _0xa56e19;return db[_0x1084('0xa')][_0x1084('0xb')]({'where':{'id':0x1},'raw':!![],'attributes':['id',_0x1084('0xc'),_0x1084('0xd')]})[_0x1084('0xe')](function(_0x1904ec){if(_0x1904ec){_0xa56e19=_0x1904ec;_0x5893da=_0xa56e19[_0x1084('0xd')]||0x1388;}})[_0x1084('0xe')](function(){return dbH['sequelize']['query'](util[_0x1084('0xf')](_0x1084('0x10'),QUERY),{'type':dbH[_0x1084('0x11')]['QueryTypes']['SELECT']});})[_0x1084('0xe')](function(_0x530490){if(!_0x530490[0x0]['num']){return analyticExtractedReport(_0x1084('0x12'));}var _0x36b9f8=[];var _0x593b2b=0x0;var _0x1e6244=!![];if(_0xa56e19[_0x1084('0xc')]){if(_0x530490&&_0x530490[_0x1084('0x13')]){var _0x1b69a4=_0x530490[0x0][_0x1084('0x14')]%(_0x593b2b+_0x5893da);for(;_0x1e6244;_0x593b2b+=_0x5893da,_0x1b69a4=_0x530490[0x0][_0x1084('0x14')]%(_0x593b2b+_0x5893da)){if(_0x1b69a4==0x0||_0x1b69a4==_0x530490[0x0]['num']){_0x1e6244=![];}_0x36b9f8[_0x1084('0x15')](dbH[_0x1084('0x11')][_0x1084('0x16')](util[_0x1084('0xf')](_0x1084('0x17'),QUERY,_0x5893da,_0x593b2b),{'type':dbH[_0x1084('0x11')][_0x1084('0x18')]['SELECT']}));}}}else{_0x36b9f8[_0x1084('0x15')](dbH[_0x1084('0x11')][_0x1084('0x16')](QUERY,{'type':dbH[_0x1084('0x11')][_0x1084('0x18')][_0x1084('0x19')]}));}var _0x44d0a9=path[_0x1084('0x1a')](PATH);var _0x53976b=path[_0x1084('0x1b')](PATH,_0x1084('0x1c'));var _0x55d684=_0xa56e19[_0x1084('0xc')]&&_0x36b9f8[_0x1084('0x13')]>0x1;var _0x20e87f=[];if(!fs[_0x1084('0x1d')](path[_0x1084('0x1e')](_0x44d0a9,_0x53976b))&&_0x55d684){fs[_0x1084('0x1f')](path[_0x1084('0x1e')](_0x44d0a9,_0x53976b));}return BPromise[_0x1084('0x20')](_0x36b9f8,function(_0x32b4ee){_0x20e87f['push'](_0x32b4ee);})[_0x1084('0xe')](function(){for(var _0x4babe7=0x0;_0x4babe7<_0x20e87f['length'];_0x4babe7+=0x1){var _0x5e4c62;var _0x1d8e91=_0x20e87f[_0x4babe7];if(_0x55d684){_0x5e4c62=path[_0x1084('0x1e')](_0x44d0a9,_0x53976b,util[_0x1084('0xf')](_0x1084('0x21'),_0x53976b,_0x4babe7,_0x1084('0x22')));}else{_0x5e4c62=path[_0x1084('0x1e')](_0x44d0a9,util[_0x1084('0xf')](_0x1084('0x23'),_0x53976b,_0x1084('0x22')));}fs[_0x1084('0x24')](_0x5e4c62,json2xls(_0x1d8e91),_0x1084('0x25'));}})[_0x1084('0xe')](function(){if(_0x55d684){zipdir(path[_0x1084('0x1e')](_0x44d0a9,_0x53976b),{'saveTo':path[_0x1084('0x1e')](_0x44d0a9,util['format'](_0x1084('0x23'),_0x53976b,'zip'))},function(_0xa9d9ec,_0x35a11){});rimraf(path[_0x1084('0x1e')](_0x44d0a9,_0x53976b),function(){});}})[_0x1084('0xe')](function(){return analyticExtractedReport(_0x1084('0x26'),_0x55d684?util[_0x1084('0xf')](_0x1084('0x23'),_0x53976b,_0x55d684?_0x1084('0x27'):'xlsx'):null);});})[_0x1084('0x28')](function(_0x509f67){console[_0x1084('0x29')](_0x509f67);return analyticExtractedReport('Error');});}main();