1const XLSX = require('xlsx');
2const Apify = require('apify');
3const _ = require('underscore');
4const Promise = require('bluebird');
5const request = require('request-promise');
6
7Apify.main(async () => {
8    Apify.setPromisesDependency(Promise);
9    console.log("Start");
10    const attachments = [];
11    
12    // get Act input and validate it
13    let input = await Apify.getValue('INPUT');
14    let finishWebhookData;
15    console.log(JSON.stringify(input));
16    if(input.data){
17        //run from webhook
18        finishWebhookData = JSON.parse(input.data);
19        finishWebhookData._id = input._id
20    }else if(input){
21        //manual run from console
22        finishWebhookData = input;
23    }else{
24         throw new Error('Input is missing!');
25    }
26
27    console.log("ID is -> "+ finishWebhookData._id)
28    console.log("Create XLS from json.");
29    
30    const run = await Apify.call(
31    	'petr_cermak/execution-to-xlsx',
32    	{"_id": finishWebhookData._id});
33    
34   
35    const xlsUrl = run.output.body.output;
36    console.log(JSON.stringify(run));
37    
38    const xlsSize = parseFloat(run.output.size);
39    console.log("We have XLS url: "+xlsUrl);
40    console.log("Size of XLS is: "+xlsSize);
41    const runMail = await Apify.call(
42    	'apify/send-mail',
43        {to: finishWebhookData.reciever,
44        subject: finishWebhookData.subjectText,
45        text: "Hello, here is the link for XLS result: "+ xlsUrl,
46        attachments: attachments
47        },
48        {});
49    
50    
51    /*
52    //Next step to attach the file if the size is ok
53    if(xlsSize < 10000000){
54      console.log("Creating attachement, size is ok.")
55      var attachement = await request({ url: xlsUrl, encoding: null });
56      attachments.push({
57            filename: `data.xls`,
58            data: attachement,
59        });
60      }else{
61        console.log("We cant send it as attachement, file is too big.")    
62      }
63      */
64      /*
65    console.log("Now we can send the mail.");
66    await Apify.setValue('OUTPUT', {output: xlsUrl});
67    const runMail = await Apify.call({
68        actId: 'apify/send-mail',
69        input: {
70            contentType: 'application/json; charset=utf-8',
71            body: JSON.stringify({
72                to: finishWebhookData.reciever,
73                subject: finishWebhookData.subjectText,
74                text: "Hello, here is the link for XLS result: "+ xlsUrl,
75                attachments: attachments
76            })
77          
78        }
79    });
80    console.log("Mail sent, done.")
81    */
82});