<?php

namespace Database\Seeders;

use App\Models\CSVDonneesClient;
use Illuminate\Database\Seeder;

class CSVDonneesClientSeeder extends Seeder
{
    const LIBELLE_MARCHE = [
        'AUTRES MATIERES ET FOURNITURES',
        'AUTRES PRESTATIONS DE SERVICES',
        'AUTRES TRAVAUX',
        'BATIMENT',
        'FOURNITURES DE BUREAU',
        'HORS MARCHE',
    ];
    const LIBELLE_DIRECTION = [
        'DASE',
        'DSI',
        'DEDU',
        'DCTM',
    ];
    const LIBELLE_SERVICE = [
        'CENTRE',
        'BAT',
        'SPORTS',
        'ENFANCE',
    ];
    const TIERS_NOM = [
        'SARL EXEMPLE',
        'LEFRANC',
        'MACHINE',
        'JEANPOLO',
        'EXEMPLE',
        'FRANC',
        "MANE",
        "POLO",
        "SARL",
        "LE",
        "CHINE",
        "JEAN",
    ];
    const MONTANT_HT = [
        16497, 43,
        63498, 43,
        64959, 43,
        26500, 43,
    ];
    const MONTANT_TTC = [
        '16497,43',
        '63498,43',
        '34959,43',
        '26500,43',
    ];
    const DOMAINE = [
        '15 - Moyens',
        '16 - généraux',
        '17 - Moyens généraux',
        '18 - MANGROVE',
        '19 - Moyx',
        '20 - Maux',
    ];
    const STRUCTURE_ID = [
        1,
        2,
        3,
    ];
    const DATE = [
        '2021-01-01',
        '2021-01-02',
        '2021-01-03',
        '2021-01-04',
        '2021-01-05',
        '2021-01-06',
        '2021-01-07',
        '2021-01-08',
        '2021-01-09',
        '2021-01-10',
    ];
    const DATE_FIN = [
        '2021-01-01',
        '2021-08-02',
        '2021-07-03',
        '2021-09-04',
        '2021-09-05',
        '2021-08-06',
        '2021-07-07',
        '2021-10-08',
        '2021-11-09',
        '2021-12-10',
    ];
    const SOUS_SEGMENT = [
        'Batiment',
        'Sport',
        'Manga',
        'Top',
        'Lits',
        'Series',
        'Toilettes',
        'Rangement',
        'Tuyauterie',
        'Bois',
        'Acier',
        'Fer'
    ];
    const SEGMENT = [
        'Batiment',
        'Sport',
        'Manga',
        'Top',
        'Lits',
        'Series',
        'Toilettes',
        'Rangement',
        'Tuyauterie',
        'Bois',
        'Acier',
        'Fer'
    ];

    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $data = [];

        for ($i = 0; $i < 70; $i++) {
            $data[] = [
                'LIBELLE_MARCHE' => self::LIBELLE_MARCHE[array_rand(self::LIBELLE_MARCHE)],
                'LIBELLE_DIRECTION' => self::LIBELLE_DIRECTION[array_rand(self::LIBELLE_DIRECTION)],
                'LIBELLE_SERVICE' => self::LIBELLE_SERVICE[array_rand(self::LIBELLE_SERVICE)],
                'TIERS_NOM' => self::TIERS_NOM[array_rand(self::TIERS_NOM)],
                'DATE' => self::DATE[array_rand(self::DATE)],
                'DATE_FIN' => self::DATE_FIN[array_rand(self::DATE_FIN)],
                'SOUS_SEGMENT' => self::SOUS_SEGMENT[array_rand(self::SOUS_SEGMENT)],
                'SEGMENT' => self::SEGMENT[array_rand(self::SEGMENT)],
                'MONTANT_HT' => self::MONTANT_HT[array_rand(self::MONTANT_HT)],
                'MONTANT_TTC' => self::MONTANT_TTC[array_rand(self::MONTANT_TTC)],
                'DOMAINE' => self::DOMAINE[array_rand(self::DOMAINE)],
                'structure_id' => self::STRUCTURE_ID[array_rand(self::STRUCTURE_ID)],
                'checksum' => md5('exemple' . ($i + 1))
            ];
        }

        CSVDonneesClient::insert($data);
    }
}