scorecard.js

// let url = "https://www.espncricinfo.com/series/ipl-2020-21-1210595/delhi-capitals-vs-mumbai-indians-final-1237181/full-scorecard";
const request = require('request');
const cheerio = require('cheerio');
const chalk = require('chalk');
const fs = require('fs');
const xlsx = require('xlsx');
const path = require('path');

function geturl(url) {
    request(url, cb);

}
function cb(err, response, html) {
    if (err) {
        console.log("Error");
    }
    else {
        // console.log(html);
        extractdetails(html);
    }
}
//venue date result opponent runs balls fours sixes sr
// format
// ipl
// team
// player
// runs ballsfours sixes sr opponent venue date result
//common ele find first
//venue date
// result
function extractdetails(html) {
    let $ = cheerio.load(html);
    let descriptionele = $(".match-header-container>.match-header-info .description");
    let result = $(".event .status-text").text().trim();

    // console.log(descriptionele.text());
    let stringArr = descriptionele.text().split(",");
    let venue = stringArr[1];
    let date = stringArr[2];
    // console.log(venue);
    // console.log(date);
    // console.log(result);
    // find innings  
    // make table first for innings to fetch data
    let inningsArr = $(".card.content-block.match-scorecard-table .Collapsible");
    // let htmlStr = "";
    let name;
    for (let i = 0; i < inningsArr.length; i++) { // loop --> since 2 innings
        // let cHtml = $(inningsArr[i]).html();
        // htmlStr = cHtml;
        // console.log(htmlStr);
        // teamname - opp name find
        let playerName = $(inningsArr[i]).find("h5").text();
        let teamName = playerName.split("INNINGS")[0].trim();
        let oppIndex = i == 0 ? 1 : 0;
        let oppName = $(inningsArr[oppIndex]).find("h5").text();
        oppName = oppName.split("INNINGS")[0].trim();
        console.log(`${venue} | ${date}| ${chalk.greenBright(teamName)} > ${chalk.blueBright(oppName)} | ${result}`);
        //find player run ,etc for both innings
        let tabelele = $(inningsArr[i]).find(".table.batsman tbody");
        let allrows = $(tabelele).find("tr");
        for (let j = 0; j < allrows.length; j++) {
            let allCols = $(allrows[j]).find("td");
            let isworthy = $(allCols[0]).hasClass("batsman-cell");
            if (isworthy == true) {
                // console.log(allCols.text());
                //player name 
                let playerName = $(allCols[0]).text();
                let runs = $(allCols[2]).text().trim();
                let balls = $(allCols[3]).text().trim();
                let fours = $(allCols[5]).text().trim();
                let sixes = $(allCols[6]).text().trim();
                let sr = $(allCols[7]).text().trim();
                console.log(`${playerName}     { ${runs} - ${balls} - ${fours} - ${sixes} - ${sr} }`)
                processPlayer(teamName, oppName, playerName, runs, balls, fours, sixes, sr, venue, date, result)


            }
        }
    }
}
function processPlayer(teamName, oppName, playerName, runs, balls, fours, sixes, sr, venue, date, result) {
    let teamPath = path.join(__dirname,"ipl",teamName);
    dirCreater(teamPath);
    let filePath= path.join(teamPath ,playerName+".xlsx");
    let content = excelReader(filePath,playerName);
    let playerObj = {
        "teamName" : teamName,
        "playerName":playerName,
        "runs":runs,
        "balls":balls,
        "fours":fours,
        "sixes":sixes,
        "sr":sr,
        "oppName":oppName,
        "venue":venue,
        "date":date,
        "result":result
    }
    content.push(playerObj);
    excelWriter(filePath,content,playerName);
}

function dirCreater(filepath) {
    if (fs.existsSync(filepath) == false) {
        fs.mkdirSync(filepath);
    }
}
function excelWriter(filePath, json, sheetName) {
    //creates new workbook
    let newwb = xlsx.utils.book_new();
    let newws = xlsx.utils.json_to_sheet(json);
    xlsx.utils.book_append_sheet(newwb, newws, sheetName);
    xlsx.writeFile(newwb, filePath);
}
function excelReader(filePath, sheetName) {
    // //creates new sheet - (data -> excel format )
    // // add sheet(newwb,ws,sheet name)
    // // file path
    // read
    if (fs.existsSync(filePath) == false) {
        return [];
    }
    let wb = xlsx.readFile(filePath);
    let exceldata = wb.Sheets[sheetName];//sheetr name inside wb
    let ans = xlsx.utils.sheet_to_json(exceldata);
    return ans;
}
module.exports = {
    geturlkey: geturl
}