import { base } from '$app/paths'

 import { assets as a } from '$app/paths'

 export let assets = a as string

             `${base}/profiles/${x}.csv`,

             `${assets}/profiles/${x}.csv`,

         const srv = import.meta.env.MODE == 'production' ? 'https://x.coturnix.fr' : 'http://localhost:5173'

         const srv = browser ? 'https://coturnix.fr' : 'http://localhost:8000'

<form method="POST" action="/api/faisan" id="pdl" on:submit={refresh}>

<form method="POST" action="/api/grain" id="pdl" on:submit={refresh}>

  import Banque from '../../Banque.svelte'
  import Simulation from './Simulation.svelte'
  import { page } from '$app/stores';
  import { enhance, applyAction } from '$app/forms';
  import { onMount } from 'svelte';
  import type { SubmitFunction } from '@sveltejs/kit';

 import Banque from '../../Banque.svelte'
 import Simulation from './Simulation.svelte'
 import { page } from '$app/stores';
 import { base as b, assets as a } from '$app/paths';
 import { enhance, applyAction } from '$app/forms';
 import { onMount } from 'svelte';
 import type { SubmitFunction } from '@sveltejs/kit';

 export let base: "" | `/${string}` = b
 export let assets: "" | `/${string}` = a

  let prodWeekly: number[] = []
  let maxProd = 0
  let pvgis_loading = false

 let prodWeekly: number[] = []
 let maxProd = 0
 let pvgis_loading = false

  let fmt = (n: number) => Intl.NumberFormat('fr-FR', { maximumFractionDigits: n });
  $: p = data.simulation

 let fmt = (n: number) => Intl.NumberFormat('fr-FR', { maximumFractionDigits: n });
 $: p = data.simulation

  onMount(async () => {
      email.set(data.email || null)
      email.subscribe((value) => { if(value) data.email = value })
      let modal = document.getElementById('grainSaveModal')
      console.log("mount modal", modal)
      if(modal) {
          document.body.appendChild(modal);
      }
      if(!window.bootstrap) {
          console.log("no window bootstrap, load");
          window.bootstrap = await import('bootstrap')
      }
      menuElt = document.getElementById('menuoff')
      if(!menuElt) {
          return
      }
      menu = new window.bootstrap.Offcanvas(menuElt)
      const popoverTriggerList = document.querySelectorAll('[data-bs-toggle="popover"]')
      for(let t of popoverTriggerList) {
          new window.bootstrap.Popover(t)
      }
  })

 onMount(async () => {
     email.set(data.email || null)
     email.subscribe((value) => { if(value) data.email = value })
     let modal = document.getElementById('grainSaveModal')
     console.log("mount modal", modal)
     if(modal) {
         document.body.appendChild(modal);
     }
     if(!window.bootstrap) {
         console.log("no window bootstrap, load");
         window.bootstrap = await import('bootstrap')
     }
     menuElt = document.getElementById('menuoff')
     if(!menuElt) {
         return
     }
     menu = new window.bootstrap.Offcanvas(menuElt)
     const popoverTriggerList = document.querySelectorAll('[data-bs-toggle="popover"]')
     for(let t of popoverTriggerList) {
         new window.bootstrap.Popover(t)
     }
 })

  let saveModal_: null | Modal = null;
  let menu: null | Offcanvas = null;
  let menuElt: null | HTMLElement = null

 let saveModal_: null | Modal = null;
 let menu: null | Offcanvas = null;
 let menuElt: null | HTMLElement = null

  async function saveModal(_e: Event) {
      console.log("saveModal", _e)
      if(!saveModal_) {
          console.log("no saveModal")
          saveModal_ = new window.bootstrap.Modal('#grainSaveModal', {
              focus: false,
              keyboard: true,
          })
      }

 async function saveModal(_e: Event) {
     console.log("saveModal", _e)
     if(!saveModal_) {
         console.log("no saveModal")
         saveModal_ = new window.bootstrap.Modal('#grainSaveModal', {
             focus: false,
             keyboard: true,
         })
     }

      showSaveModalAfterMenuHide()
      menu?.hide()
  }

     showSaveModalAfterMenuHide()
     menu?.hide()
 }

  function showSaveModalAfterMenuHide() {
      // menuElt?.removeEventListener('hidden.bs.offcanvas', showSaveModalAfterMenuHide)
      let c = document.getElementsByClassName("offcanvas-backdrop")
      for(const elt of c) {
          elt.parentElement?.removeChild(elt)
      }
      saveModal_?.show()
  }

 function showSaveModalAfterMenuHide() {
     // menuElt?.removeEventListener('hidden.bs.offcanvas', showSaveModalAfterMenuHide)
     let c = document.getElementsByClassName("offcanvas-backdrop")
     for(const elt of c) {
         elt.parentElement?.removeChild(elt)
     }
     saveModal_?.show()
 }

  let save: SubmitFunction = async ({ formData }) => {
      console.log("save called")
      formData.set('data', JSON.stringify(p))
      formData.set('prms', JSON.stringify(data.prms))
      saveModal_?.hide()
      return async ({ result }) => {
          console.log(JSON.stringify(result))
          await applyAction(result);
      };
  }

 let save: SubmitFunction = async ({ formData }) => {
     console.log("save called")
     formData.set('data', JSON.stringify(p))
     formData.set('prms', JSON.stringify(data.prms))
     saveModal_?.hide()
     return async ({ result }) => {
         console.log(JSON.stringify(result))
         await applyAction(result);
     };
 }

  let expert = $page.url.hash == "#expert"

 let expert = $page.url.hash == "#expert"

  $: compteActive = ($page.url.hash == "#compte") ? "active": ""
  $: banqueActive = ($page.url.hash == "#banque") ? "active": ""
  $: expertActive = (expert && $page.url.hash == "#expert") ? "active": ""
  $: simuActive = ((true || !data.guest) && $page.url.hash == "#simu") ? "active": ""
  $: syntheseActive = (!compteActive && !banqueActive && !simuActive && !expertActive) ? "active": ""

 $: compteActive = ($page.url.hash == "#compte") ? "active": ""
 $: banqueActive = ($page.url.hash == "#banque") ? "active": ""
 $: expertActive = (expert && $page.url.hash == "#expert") ? "active": ""
 $: simuActive = ((true || !data.guest) && $page.url.hash == "#simu") ? "active": ""
 $: syntheseActive = (!compteActive && !banqueActive && !simuActive && !expertActive) ? "active": ""

  $: compteShow = compteActive ? "show": ""
  $: banqueShow = banqueActive ? "show": ""
  $: simuShow = simuActive ? "show": ""
  $: syntheseShow = syntheseActive ? "show": ""
  $: expertShow = expertActive ? "show": ""

 $: compteShow = compteActive ? "show": ""
 $: banqueShow = banqueActive ? "show": ""
 $: simuShow = simuActive ? "show": ""
 $: syntheseShow = syntheseActive ? "show": ""
 $: expertShow = expertActive ? "show": ""

  let N = 30
  const arr = 0

 let N = 30
 const arr = 0

  let an = new Date().getFullYear()

 let an = new Date().getFullYear()

  function tarifSurplus_(puissance: number): number {
      let resultat = p.tarifCRE.prix[0];
      for(let i = 0; i < p.tarifCRE.limites.length; i++) {
          if(puissance < p.tarifCRE.limites[i]) {
              return resultat
          } else {
              resultat = p.tarifCRE.prix[i]
          }
      }
      return resultat
  }

 function tarifSurplus_(puissance: number): number {
     let resultat = p.tarifCRE.prix[0];
     for(let i = 0; i < p.tarifCRE.limites.length; i++) {
         if(puissance < p.tarifCRE.limites[i]) {
             return resultat
         } else {
             resultat = p.tarifCRE.prix[i]
         }
     }
     return resultat
 }

 const surface_kwc = 5
 let surface = surface_kwc * (p?.puissance || 0)
 function onSurfaceChange(ev: ChangeEvent) {
     surface = ev.target.value
     p.puissance = surface / surface_kwc
 }
 function onPuissanceChange(ev: ChangeEvent) {
     p.puissance = ev.target.value
     surface = p.puissance * surface_kwc
 }

  $: chiffreAffaires = (i: number) =>((i == 0) ? primeInvestissement : 0) + productionAnnuelle(i) * (autoconso * tarifLocal(i) + (1 - autoconso) * tarifSurplus(i) + p.autoprod * tarifAllo(i)/100)

 $: chiffreAffaires = (i: number) =>((i == 0) ? primeInvestissement : 0) + productionAnnuelle(i) * (autoconso * tarifLocal(i) + (1 - autoconso) * tarifSurplus(i) + p.autoprod * tarifAllo(i)/100)

  $: exploitation = (i: number) => p.puissance * p.maintenance * Math.pow(1 + p.inflation / 100, i)

 $: exploitation = (i: number) => p.puissance * p.maintenance * Math.pow(1 + p.inflation / 100, i)

  $: turpe = (i: number) => (p.puissance * p.turpe + (1-autoconso) * productionAnnuelle(i) * p.turpeInjection) * Math.pow(1+p.inflation/100, i)

 $: turpe = (i: number) => (p.puissance * p.turpe + (1-autoconso) * productionAnnuelle(i) * p.turpeInjection) * Math.pow(1+p.inflation/100, i)

  $: assurance = (i: number) => (investissement * p.assurance / 100) * Math.pow(1+p.inflation/100, i)

 $: assurance = (i: number) => (investissement * p.assurance / 100) * Math.pow(1+p.inflation/100, i)

  $: divers = (i: number) => p.divers * p.puissance * Math.pow(1 + p.inflation/100, i)

 $: divers = (i: number) => p.divers * p.puissance * Math.pow(1 + p.inflation/100, i)

  $: charges = (i: number) => (investissement && i == 0 ? p.fraisDivers : 0) + exploitation(i) + turpe(i) + assurance(i) + divers(i)

 $: charges = (i: number) => (investissement && i == 0 ? p.fraisDivers : 0) + exploitation(i) + turpe(i) + assurance(i) + divers(i)

  $: valeurAjoutee = (i: number) => chiffreAffaires(i) - charges(i)

 $: valeurAjoutee = (i: number) => chiffreAffaires(i) - charges(i)

  // Impots
  // Accise: taux dérogatoire d'1€/MWh jusqu'au 31/1/2025
  $: accise = (i: number) => productionAnnuelle(i) * 0.001

 // Impots
 // Accise: taux dérogatoire d'1€/MWh jusqu'au 31/1/2025
 $: accise = (i: number) => productionAnnuelle(i) * 0.001

  $: ifer = (_: number) => (p.puissance < 100) ? 0: 3.394 * p.puissance * p.ratioDcAc

 $: ifer = (_: number) => (p.puissance < 100) ? 0: 3.394 * p.puissance * p.ratioDcAc

  // Exonération de taxe foncière: https://www.legifrance.gouv.fr/codes/article_lc/LEGIARTI000044996150
  $: taxeFonciere = (_: number) => 0

 // Exonération de taxe foncière: https://www.legifrance.gouv.fr/codes/article_lc/LEGIARTI000044996150
 $: taxeFonciere = (_: number) => 0

  // Formule compliquée, exonéré sur les cas concrets
  $: cfe = (_: number) => 0

 // Formule compliquée, exonéré sur les cas concrets
 $: cfe = (_: number) => 0

  $: impots = (i: number) => ifer(i) + taxeFonciere(i) + cfe(i)

 $: impots = (i: number) => ifer(i) + taxeFonciere(i) + cfe(i)

  // EBE
  $: ebe = (i: number) => valeurAjoutee(i) - impots(i)

 // EBE
 $: ebe = (i: number) => valeurAjoutee(i) - impots(i)

  // Déductions fiscales
  $: amortissement = (i: number) => (i < p.dureeAmortissement) ? investissement / p.dureeAmortissement: 0

 // Déductions fiscales
 $: amortissement = (i: number) => (i < p.dureeAmortissement) ? investissement / p.dureeAmortissement: 0

  $: provisionOnduleurs = (i: number) => p.puissance * 1000 * p.provisionOnduleurs * Math.pow(1 + p.inflation/100, i) / 10

 $: provisionOnduleurs = (i: number) => p.puissance * 1000 * p.provisionOnduleurs * Math.pow(1 + p.inflation/100, i) / 10

  let remboursementAnnuel: Array<number> = []
  let interetsAnnuels: Array<number> = []

 let remboursementAnnuel: Array<number> = []
 let interetsAnnuels: Array<number> = []

  $: dette = Math.max(0, investissement - apport)

 $: dette = Math.max(0, investissement - apport)

  $: interetsDetteSenior = (i: number) => (i < interetsAnnuels.length) ? interetsAnnuels[i] : 0

 $: interetsDetteSenior = (i: number) => (i < interetsAnnuels.length) ? interetsAnnuels[i] : 0

  $: interetsDSRA = (i: number) => interetsDetteSenior(i) * p.tauxDSRA / 100

 $: interetsDSRA = (i: number) => interetsDetteSenior(i) * p.tauxDSRA / 100

  $: serviceDetteSenior = (i: number) => interetsDSRA(i) + interetsDetteSenior(i) + remboursementAnnuel[i]

 $: serviceDetteSenior = (i: number) => interetsDSRA(i) + interetsDetteSenior(i) + remboursementAnnuel[i]

  $: dscr = (i: number) => (i < remboursementAnnuel.length) ? tresorerieDisponibleDetteSenior(i) / serviceDetteSenior(i) : 0

 $: dscr = (i: number) => (i < remboursementAnnuel.length) ? tresorerieDisponibleDetteSenior(i) / serviceDetteSenior(i) : 0

  $: resultatFiscal = (i: number) => ebe(i) - amortissement(i) - provisionOnduleurs(i) - interetsDetteSenior(i) - interetsDSRA(i)

 $: resultatFiscal = (i: number) => ebe(i) - amortissement(i) - provisionOnduleurs(i) - interetsDetteSenior(i) - interetsDSRA(i)

  $: is = (i: number) => (resultatFiscal(i) <= 0) ? 0: resultatFiscal(i) * p.tauxIS / 100

 $: is = (i: number) => (resultatFiscal(i) <= 0) ? 0: resultatFiscal(i) * p.tauxIS / 100

  $: resultatNet = (i: number) => resultatFiscal(i) - is(i)

 $: resultatNet = (i: number) => resultatFiscal(i) - is(i)

  let resultatNetData: { id: string, data: {x:number,y:number}[]}[] = [{id:"",data:[]}]

 let resultatNetData: { id: string, data: {x:number,y:number}[]}[] = [{id:"",data:[]}]

  $: {
      resultatNetData[0] = { id: "", data: new Array(N).fill(0).map((_, i) => { return { x: an + i, y: resultatNet(i) }}) }
  }

 $: {
     resultatNetData[0] = { id: "", data: new Array(N).fill(0).map((_, i) => { return { x: an + i, y: resultatNet(i) }}) }
 }

  // Synthèse
  $: consoMoyenneFoyer = (i: number) => H.consoMoyenneFoyer(p, i)

 // Synthèse
 $: consoMoyenneFoyer = (i: number) => H.consoMoyenneFoyer(p, i)

  $: coutElec = () => {
      let cout = 0
      for(let i = 0; i < N; i++) {
          cout += p.coutElec * Math.pow(1 + p.inflationElec / 100, i) * consoMoyenneFoyer(i)

 $: coutElec = () => {
     let cout = 0
     for(let i = 0; i < N; i++) {
         cout += p.coutElec * Math.pow(1 + p.inflationElec / 100, i) * consoMoyenneFoyer(i)

      }
      return cout
  }

     }
     return cout
 }

  $: coutElecAuto = () => {
      let cout = 0
      for(let i = 0; i < N; i++) {
          cout += tarifLocal(i) * consoMoyenneFoyer(i) * p.autoprod / 100
                + p.coutElec * Math.pow(1 + p.inflationElec / 100, i) * consoMoyenneFoyer(i) * (100 - p.autoprod) / 100
      }
      return cout
  }

 $: coutElecAuto = () => {
     let cout = 0
     for(let i = 0; i < N; i++) {
         cout += tarifLocal(i) * consoMoyenneFoyer(i) * p.autoprod / 100
               + p.coutElec * Math.pow(1 + p.inflationElec / 100, i) * consoMoyenneFoyer(i) * (100 - p.autoprod) / 100
     }
     return cout
 }

  function sum(x: (_: number) => number, n: number){
      return  new Array(n).fill(0).reduce((a, _, i) => a + x(i), 0)
  }

 function sum(x: (_: number) => number, n: number){
     return  new Array(n).fill(0).reduce((a, _, i) => a + x(i), 0)
 }

  function format(x : number){
      let f = 0
      let s = ''
      if (Math.abs(x) <= 1000){
          s = ' €'
          f = x
      } else if (Math.abs(x) < 1000000) {
          s = ' k€'
          f = x/1000
      } else if(Math.abs(x) < 1000000000) {
          s = ' M€'
          f = x/1000000
      } else {
          s = ' mds€'
          f = x/1000000000
      }
      return fmt(2).format(f) + s
  }

 function format(x : number){
     let f = 0
     let s = ''
     if (Math.abs(x) <= 1000){
         s = ' €'
         f = x
     } else if (Math.abs(x) < 1000000) {
         s = ' k€'
         f = x/1000
     } else if(Math.abs(x) < 1000000000) {
         s = ' M€'
         f = x/1000000
     } else {
         s = ' mds€'
         f = x/1000000000
     }
     return fmt(2).format(f) + s
 }

  function rentabiliteTaux(x:number,y:number){
      return fmt(2).format(
          y ?
          ((x*100/y)-100)
          : 0
      ) + "%"
  }

 function rentabiliteTaux(resultat: number): string {
     return fmt(2).format(
         investissement ?
         ((resultat*100/investissement)-100)
         : 0
     ) + "%"
 }

  let maxa = -1/0
  let mina = 1/0
  let margin = 1
  function traceArray(f: (_: number) => number, n:number){
      let c = ''
      let ai = 0
      maxa = -1/0
      mina = 1/0
      for (let i = 0; i < n; i ++ ){
          ai += f(i)
          maxa = Math.max(maxa, ai)
          mina = Math.min(mina, ai)
          c += ` ${c ? 'L':'M'} ${i.toFixed(arr)}, ${(-ai.toFixed(arr))}`
      }
      margin = Math.max(1, (maxa - mina) / 20)
      return c
  }

 let maxa = -1/0
 let mina = 1/0
 let margin = 1
 function traceArray(f: (_: number) => number, n:number){
     let c = ''
     let ai = 0
     maxa = -1/0
     mina = 1/0
     for (let i = 0; i < n; i ++ ){
         ai += f(i)
         maxa = Math.max(maxa, ai)
         mina = Math.min(mina, ai)
         c += ` ${c ? 'L':'M'} ${i.toFixed(arr)}, ${(-ai.toFixed(arr))}`
     }
     margin = Math.max(1, (maxa - mina) / 20)
     return c
 }

  $: roiDate = () => {
      let sum = 0
      let lastNeg = 0
      for (let i = 0; i < N; i += 1 ){
          sum += resultatNet(i)
          if(sum < 0)
              lastNeg = i
      }
      lastNeg += 1
      if (lastNeg < N) {
          if(lastNeg <= 1 && sum >= 0) {
              return `Tout de suite`
          } else if (lastNeg == 1) {
              return `1 an`
          } else {
              return `${lastNeg} ans`
          }
      } else {
          return "À la saint Glinglin"
      }
  }

 $: roiDate = () => {
     let sum = 0
     let lastNeg = 0
     for (let i = 0; i < N; i += 1 ){
         sum += resultatNet(i)
         if(sum < 0)
             lastNeg = i
     }
     lastNeg += 1
     if (lastNeg < N) {
         if(lastNeg <= 1 && sum >= 0) {
             return `Tout de suite`
         } else if (lastNeg == 1) {
             return `1 an`
         } else {
             return `${lastNeg} ans`
         }
     } else {
         return "À la saint Glinglin"
     }
 }

  $: rembPret = (n:number) => {
      let totalRembAnnuel_n = remboursementAnnuel.slice(0, n).reduce((a, b) => a + b, 0)
      let totalInteret_n = sum(interetsDetteSenior, n)
      let totalRembAnnuel =remboursementAnnuel.reduce((a, b) => a + b, 0)
      let totalInteret = sum(interetsDetteSenior, n)
      return fmt(2).format(
          (totalRembAnnuel + totalInteret) ?
          ((totalRembAnnuel_n + totalInteret_n) * 100 / (totalRembAnnuel + totalInteret))
          : 0
      )
  }

 $: rembPret = (n:number) => {
     let totalRembAnnuel_n = remboursementAnnuel.slice(0, n).reduce((a, b) => a + b, 0)
     let totalInteret_n = sum(interetsDetteSenior, n)
     let totalRembAnnuel =remboursementAnnuel.reduce((a, b) => a + b, 0)
     let totalInteret = sum(interetsDetteSenior, n)
     return fmt(2).format(
         (totalRembAnnuel + totalInteret) ?
         ((totalRembAnnuel_n + totalInteret_n) * 100 / (totalRembAnnuel + totalInteret))
         : 0
     )
 }

  $: economieFoyerMois = fmt(2).format(coutElec_ ? ((coutElec_ - coutElecAuto_) / (coutElec_/(N*12))):0)

 $: economieFoyerMois = fmt(2).format(coutElec_ ? ((coutElec_ - coutElecAuto_) / (coutElec_/(N*12))):0)

                        <input class="form-control form-control-sm" type="number" id="puissance" min="1" bind:value={p.puissance}/>

                        <input class="form-control form-control-sm" type="number" id="puissance" min="1" value={p.puissance} on:change={onPuissanceChange} />
                    </div>
                    <div class="my-3">
                        <label class="form-label" for="puissance">Surface totale (m²)</label>
                        <input class="form-control form-control-sm" type="number" id="surface" min="1" value={surface} on:change={onSurfaceChange} />

                                    <div class="donnee">{rentabiliteTaux(sum(resultatNet,10),apport)}</div>

                                    <div class="donnee">{rentabiliteTaux(sum(resultatNet,10))}</div>

                                    <div class="donnee">{rentabiliteTaux(sum(resultatNet,5),apport)}</div>

                                    <div class="donnee">{rentabiliteTaux(sum(resultatNet,5))}</div>

                        <div class="row flex-row-reverse px-4  ">
                            <div class="d-flex justify-content-between p-5">

                        <div class="row flex-row flex-wrap px-4">
                            <div class="d-flex justify-content-between py-5">

                                <div class="flex-column text-center">

                                <div class="flex-column text-center mx-3">

                                <div class="flex-column text-center">

                                <div class="flex-column text-center mx-3">

                                <div class="flex-column text-center">

                                <div class="flex-column text-center mx-3">
                                    <div class="donnee">{fmt(2).format((investissement ? ((sum(resultatNet, N)*100/investissement)-100): 0) / N)}%
                                    </div>
                                    <div>Rentabilité annuelle</div>
                                </div>
                                <div class="flex-column text-center mx-3">

                    <Simulation prmsFeature={prmsFeature} bind:prms={data.prms} puissance={p.puissance} bind:prodWeekly={prodWeekly} bind:maxProd={maxProd} bind:pvgis_loading={pvgis_loading} />

                    <Simulation base={base} assets={assets} prmsFeature={prmsFeature} bind:prms={data.prms} puissance={p.puissance} bind:prodWeekly={prodWeekly} bind:maxProd={maxProd} bind:pvgis_loading={pvgis_loading} />

 let fmt = (n: number) => Intl.NumberFormat('fr-FR', { maximumFractionDigits: n });
 function format(x : number){
     let f = 0
     let s = ''
     if (Math.abs(x) <= 1000){
         s = ' kWc'
         f = x
     } else if(Math.abs(x) <= 1000000) {
         s = ' MWc€'
         f = x/1000
     } else {
         s = ' GWc'
         f = x/1000000
     }
     return fmt(2).format(f) + s
 }

                    <div class="pb-3 mb-3 border-bottom border-4 border-primary fs-1 fw-bold bg-cc fs-1 fw-bold">{donnees.puissance} MWc</div>

                    <div class="pb-3 mb-3 border-bottom border-4 border-primary fs-1 fw-bold bg-cc fs-1 fw-bold">{format(donnees.puissance)}</div>

 import { base } from '$app/paths'

 import { base as b, assets as a } from '$app/paths'

 export let base = b
 export let assets: string = a

    <div class="img">

    <div class="img" style ="background-image: url({assets}/trace.svg);">

     background-image: url(/trace.svg);

        "miniflare": "^3.20231030.1",
        "plotly.js-dist": "^2.26.1",

        "plotly.js-dist": "^2.26.1",

        "suncalc": "^1.9.0",
        "ui": "file:../ui"

        "suncalc": "^1.9.0"

                "suncalc": "^1.9.0",
                "ui": "file:../ui"

                "suncalc": "^1.9.0"