{"id":103,"date":"2026-09-30T15:10:21","date_gmt":"2026-09-30T13:10:21","guid":{"rendered":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/?p=103"},"modified":"2026-09-30T15:15:20","modified_gmt":"2026-09-30T13:15:20","slug":"stage-en-bts-sio-de-1ere-annee-du-25-mai-au-26-juin-2026","status":"publish","type":"post","link":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/2026\/09\/30\/stage-en-bts-sio-de-1ere-annee-du-25-mai-au-26-juin-2026\/","title":{"rendered":"Stage en BTS SIO de 1\u00e8re ann\u00e9e du 25 mai au 26 juin 2026"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Pr\u00e9sentation de l’entreprise<\/h2>\n\n\n\n

Prestasono34 est une entreprise sp\u00e9cialis\u00e9e dans l\u2019\u00e9v\u00e8nementiel sonore et lumineux, bas\u00e9e dans l\u2019H\u00e9rault (34) et les Pyr\u00e9n\u00e9es-Atlantiques (64). Elle propose des services complets de location de mat\u00e9riel professionnel (syst\u00e8mes de sonorisation, \u00e9clairages, effets sp\u00e9ciaux), de prestations musicales avec des DJ et musiciens, d\u2019animation \u00e9v\u00e8nementielle et d\u2019int\u00e9gration technique pour des \u00e9v\u00e8nements tels que des mariages, concerts ou soir\u00e9es d\u2019entreprise. <\/p>\n\n\n\n

Le projet<\/h2>\n\n\n\n

J’ai \u00e9t\u00e9 charg\u00e9 de d\u00e9velopper PrestaFactu, une application web qui permet de centraliser le suivi des factures fournisseurs, des avoirs et des cr\u00e9anciers, un outil destin\u00e9 \u00e0 aider a mieux g\u00e9rer sa comptabilit\u00e9. Elle permet de cr\u00e9er, modifier, visualiser et payer des factures, de g\u00e9rer des fournisseurs qu\u2019ils soient des entreprises ou des particuliers et de suivre l\u2019\u00e9tat des d\u00e9penses.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Comment nous avons proc\u00e9d\u00e9 <\/h2>\n\n\n\n

J\u2018ai eu la chance de pouvoir effectuer mon stage \u00e0 2 ce qui m\u2019a permis de pouvoir travailler en \u00e9quipe. On s\u2019est r\u00e9parti le travail et je me suis occup\u00e9 en premier de mettre en place la base de donn\u00e9es. Xavier, pendant ce temps, a commenc\u00e9 la cr\u00e9ation du site et de son architecture. Avant de cr\u00e9er la base de donn\u00e9es, j’ai r\u00e9alis\u00e9 un MCD (Mod\u00e8le Conceptuel de Donn\u00e9es). Faire le MCD a \u00e9t\u00e9 plut\u00f4t compliqu\u00e9, notamment pour mod\u00e9liser l\u2019h\u00e9ritage entre les types de fournisseurs. J’ai demand\u00e9 de l’aide aupr\u00e8s de mes professeurs et de mon ma\u00eetre de stage pour y arriver. Le MCD m’a ensuite permis de g\u00e9n\u00e9rer le script SQL de cr\u00e9ation de la base de donn\u00e9es de fa\u00e7on structur\u00e9e et coh\u00e9rente.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

D\u00e9roulement semaine par semaine <\/h2>\n\n\n\n

Semaine 1 – Prise en main et base de donn\u00e9es<\/h3>\n\n\n\n
    \n
  • D\u00e9couverte de l\u2019environnement et des outils (OpenVPN)<\/li>\n\n\n\n
  • Conception du MCD<\/li>\n\n\n\n
  • Cr\u00e9ation de la base de donn\u00e9es<\/li>\n\n\n\n
  • Aide des professeurs, du ma\u00eetre de stage et de l\u2019IA<\/li>\n<\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Semaine 2 – Page des factures d\u2019achat<\/h3>\n\n\n\n
      \n
    • D\u00e9veloppement d\u2019une page web en architecture MVC<\/li>\n\n\n\n
    • Ajout et enregistrement des factures dans la BDD<\/li>\n\n\n\n
    • Ajout de justificatifs PDF par glisser-d\u00e9poser<\/li>\n\n\n\n
    • Calcul automatique du montant TTC<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      Semaine 3 \u2013 Utilisateurs, factures & avoirs<\/h3>\n\n\n\n
        \n
      • Cr\u00e9ation de la gestion des comptes utilisateurs<\/li>\n\n\n\n
      • Isolation des donn\u00e9es entre les utilisateurs<\/li>\n\n\n\n
      • Affichage du statut des factures : brouillon, en retard, due, pay\u00e9e<\/li>\n\n\n\n
      • Cr\u00e9ation de la page de gestion des avoirs<\/li>\n\n\n\n
      • Approfondissement des requ\u00eates SQL<\/li>\n<\/ul>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Semaine 4 \u2013 Corrections & responsive<\/h3>\n\n\n\n
          \n
        • Correction de plusieurs bugs sur les factures et les avoirs<\/li>\n\n\n\n
        • Pr\u00e9sentation de l\u2019application au ma\u00eetre de stage<\/li>\n\n\n\n
        • Am\u00e9lioration de l\u2019affichage des donn\u00e9es<\/li>\n\n\n\n
        • D\u00e9but de la mise en responsive pour mobile<\/li>\n\n\n\n
        • Meilleure compr\u00e9hension du d\u00e9veloppement responsive<\/li>\n<\/ul>\n\n\n\n

          Semaine 5 \u2013 Corrections avanc\u00e9es & MinIO<\/h3>\n\n\n\n
            \n
          • Correction de bugs plus complexes<\/li>\n\n\n\n
          • Gestion correcte des factures impay\u00e9es<\/li>\n\n\n\n
          • Correction des probl\u00e8mes de dates et de fuseau horaire<\/li>\n\n\n\n
          • Correction des doublons et des erreurs sur les avoirs<\/li>\n\n\n\n
          • D\u00e9couverte de MinIO pour le stockage des fichiers PDF<\/li>\n\n\n\n
          • Tests et am\u00e9lioration de la qualit\u00e9 de l\u2019application<\/li>\n<\/ul>\n\n\n\n

            <\/p>\n","protected":false},"excerpt":{"rendered":"

            Pr\u00e9sentation de l’entreprise Prestasono34 est une entreprise sp\u00e9cialis\u00e9e dans l\u2019\u00e9v\u00e8nementiel sonore et lumineux, bas\u00e9e dans l\u2019H\u00e9rault (34) et les Pyr\u00e9n\u00e9es-Atlantiques […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[12],"tags":[],"class_list":["post-103","post","type-post","status-publish","format-standard","hentry","category-stages"],"_links":{"self":[{"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/posts\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":2,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"predecessor-version":[{"id":117,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/posts\/103\/revisions\/117"}],"wp:attachment":[{"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sio.lycee-saint-john-perse.fr\/portfolio-arramond\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}