JSFiddle - React, Tailwind, and code Playground

by Serge Zahharenko

HTML

<pre id="query"></pre>

JavaScript

const generateRandom = (min, max) => {
    let difference = max - min;
    let rand = Math.random();
    rand = Math.floor( rand * difference);
    rand = rand + min;
    return `${rand < 10 ? '0' : ''}${rand}`;
}

const randomTime = () => {
    const hours = generateRandom(0,24);
    const minutes = generateRandom(0,60);
    return `${hours}:${minutes}:00`;
}

const generateQuery = (data) => {
    let QUERY = 'INSERT INTO `vichy_prizes` (`prize_type`, `prize_name`, `prize_date`, `winner_id`, `prize_used`) VALUES';
    data.forEach(prize => {
        const type = prize.type;
        const name = prize.name;
        const days = prize.days
        console.log(`${name} : ${days.length}`)
        days.forEach(day => QUERY += ` ('${type}','${name}', '${day} ${randomTime()}',0,0),<br/>`);
    })
    QUERY = QUERY.slice(0, -1);
    return QUERY;
}
const generateDays = () => {
    let day = 2;
    let mon = 5;
    for(i=0;i<91;i++) {
        console.log(`'2022-0${mon}-${day < 10 ? '0' : ''}${day}',`);
        console.log(`'2022-0${mon}-${day < 10 ? '0' : ''}${day}',`);
        console.log(`'2022-0${mon}-${day < 10 ? '0' : ''}${day}',`);
        day++
        if(day === 32) {
            day = 1;
            mon++;
        }
    }
}

var queryData = [
    {
        type: 1,
        name: 'Vichy toode (6-ne plokk)',
        days: [
            '2022-05-02',
            '2022-05-02',
            '2022-05-02',
            '2022-05-03',
            '2022-05-03',
            '2022-05-03',
            '2022-05-04',
            '2022-05-04',
            '2022-05-04',
            '2022-05-05',
            '2022-05-05',
            '2022-05-05',
            '2022-05-06',
            '2022-05-06',
            '2022-05-06',
            '2022-05-07',
            '2022-05-07',
            '2022-05-07',
            '2022-05-08',
            '2022-05-08',
            '2022-05-08',
            '2022-05-09',
            '2022-05-09',
            '2022-05-09',
            '2022-05-10',
  ...