NODE.JS

MODIFICATION IMPORTANTE

app.use(bodyparser.urlencoded({ extended: false}));

DÉMARRAGE DU PROJET

cd /Users/juliechaumard/Documents/GitHub/Aduzuki_v2
npm start

DOCUMENTATION

Dans ce dossier sous /documentation
MindMap : GoogleDrive-juliechaumard@gmail.com/Mon Drive/Projets/Suzuki/Adusuki/dev
Notion

DOMAIN

inscription.afpedagogiesuzuki.fr

OVH ZONE DNS

inscription.afpedagogiesuzuki.fr A 162.19.79.63 inscription.afpedagogiesuzuki.fr AAAA 2001:41d0:304:200::537f www.inscription.afpedagogiesuzuki.fr CNAME inscription.afpedagogiesuzuki.fr

VPS

port = 8891 proxy_pass http://localhost:8891; proxy_http_version 1.1; proxy_set_header Upgrade $http_upgrade; proxy_set_header Connection ‘upgrade’; proxy_set_header Host $host; proxy_cache_bypass $http_upgrade;

DB SQL

CREATE USER ‘sqladmin’@‘37.170.212.144’ IDENTIFIED BY ‘Squser1admin!’; GRANT ALL PRIVILEGES ON . TO ‘sqladmin’@‘37.170.212.144’; FLUSH PRIVILEGES;

db_connection_host=“localhost” db_connection_port=3306 db_connection_user=“root” db_connection_password=“G1plumeverte!” db_connection_database=“aduzuki”

PM2

/var/www/aduzuki pm2 start /var/www/aduzuki/modules/adhesion/majgs_webhook.js –name majgs_webhook

GOOGLE SHEET

Partager avec

- afpedagogiesuzuki@gmail.com
- al.sauvegrain@gmail.com
- userapi@inscriptionsafps.iam.gserviceaccount.com

SITE DE DEV

NEW

URL

aduzuki.darkweb.land

NGNINX sites-available

server {

    root /var/www/aduzuki;
    index index.html index.htm index.nginx-debian.html;

    server_name aduzuki.darkweb.land;

    location / {
        proxy_pass http://localhost:8893;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection 'upgrade';
        proxy_set_header Host $host;
        proxy_cache_bypass $http_upgrade;
    }

listen [::]:443 ssl; # managed by Certbot
listen 443 ssl; # managed by Certbot
ssl_certificate /etc/letsencrypt/live/aduzuki.darkweb.land/fullchain.pem; # managed by Certbot
ssl_certificate_key /etc/letsencrypt/live/aduzuki.darkweb.land/privkey.pem; # managed by Certbot
include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot

} server { if ($host = aduzuki.darkweb.land) { return 301 https://$host$request_uri; } # managed by Certbot

    listen 80;
    listen [::]:80;

    server_name aduzuki.darkweb.land;
return 404; # managed by Certbot

}

vps-38339055.vps.ovh.net:49170 /var/www debian G1plumeverte!

URLs

ACCUEIL

https://www.adhesion.afpedagogiesuzuki.fr/inscription/accueil

FORMULAIRE ADHÉSION

http://localhost:8890/adhesion
https://www.adusuki.juliechaumard.paris/adhesion
https://inscription.afpedagogiesuzuki.fr/adhesion

GESTION DES ADHÉSION

https://inscription.afpedagogiesuzuki.fr/adhesion/maj_googlesheet_auto
https://www.inscription.afpedagogiesuzuki.fr/adhesion/maj_googlesheet

ENVOIE CARTE ADHÉRENT ET JUSTIFICATIF DE DON MANUEL

http://localhost:8888/inscription/adhesion/carte_manuelle
https://www.adusuki.juliechaumard.paris/inscription/adhesion/carte_manuelle
https://inscription.afpedagogiesuzuki.fr/adhesion/carte_manuelle

STAGE ANNUEL

http://localhost:8890/stagenational
https://adusuki.juliechaumard.paris/stagenational
https://inscription.afpedagogiesuzuki.fr/stagenational

GESTION DU STAGE

https://www.inscription.afpedagogiesuzuki.fr/adhesion/admin

RASSEMBLEMENT IDF

http://localhost:8890/rassemblementidf
https://www.adusuki.juliechaumard.paris/rassemblementidf
https://www.inscription.afpedagogiesuzuki.fr/rassemblementidf

RASSEMBLEMENT IDF

http://localhost:8890/rassemblementra
https://adusuki.juliechaumard.paris/rassemblementidf
https://inscription.afpedagogiesuzuki.fr/rassemblementra

CONCERT UNESCO

http://localhost:8890/concert
https://www.adusuki.juliechaumard.paris/concert
https://www.inscription.afpedagogiesuzuki.fr/concert
https://inscription.afpedagogiesuzuki.fr/
https://inscription.afpedagogiesuzuki.fr/concert/concert_paiement/annule?id={CHECKOUT_SESSION_ID}
https://inscription.afpedagogiesuzuki.fr/concert/concert_paiement/reussi?id={CHECKOUT_SESSION_ID}

BOUTIQUE

VIDÉOS

https://inscription.afpedagogiesuzuki.fr/boutique/videos

STRIPE_VENTEVIDEO_SUCCESSURL=https://inscription.afpedagogiesuzuki.fr/boutique/videos/paiement_reussi?id={CHECKOUT_SESSION_ID} STRIPE_VENTEVIDEO_CANCELURL=https://inscription.afpedagogiesuzuki.fr/boutique/videos/paiement_annule?id={CHECKOUT_SESSION_ID}

STRIPE_PRIVATE_KEY_TEST=sk_test_51Kv1j8BAHsmvBJpQhGQV4hHbLEKGls7MMm5wuMRa3xBqYXtF5JP4RUPFyK0QBQwrrCPPF1l3dSW3KZ3AYDGEdwSd00uDYg3ACp STRIPE_PUBLISHABLE_KEY_TEST=pk_test_51Kv1j8BAHsmvBJpQ8SVqXOMsgQs0slKAbtSUqUnqQZt4FBvr9t5TY5ZlEkQjWqTwTIhdx3H2iRCgQizqn1NN0BWU00239nRLYv

https://inscription.afpedagogiesuzuki.fr/wh_stripe Traitements après paiement. Pour le moment effectif pour le paiement d’un don via le bouton “SOUTENIR” du site de l’AFPS

checkout.session.async_payment_failed checkout.session.async_payment_succeeded checkout.session.completed checkout.session.expired

Version de l’API : 2024-11-20.acacia

DOMAIN_EXTERNE=“https://inscription.afpedagogiesuzuki.fr/”

VARIABLES D’ENVIRONNEMENT DE PROD

PORT=“8891” ENV=“production” COOKIE_SECRET=‘patapuf’ DOMAIN=“http://localhost:8891/”

STRIPE_PRIVATE_KEY=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 STRIPE_PUBLISHABLE_KEY=pk_live_51L888YBaJ0SjyxPrhYkkZ0zTH54PQQlsnfmZQ7obB3HsZzvscNFssjVdDMyuH4fyRZEyybOg9UKoDfTn5JIuI6OI003bou1D3Y STRIPE_SUCCESSURL=https://inscription.afpedagogiesuzuki.fr/adhesion/adhesion_paiement/reussi?id={CHECKOUT_SESSION_ID} STRIPE_CANCELURL=https://inscription.afpedagogiesuzuki.fr/adhesion/adhesion_paiement/annule?id={CHECKOUT_SESSION_ID} STRIPE_SN_SUCCESSURL=https://inscription.afpedagogiesuzuki.fr/stagenational/paiement_reussi?id={CHECKOUT_SESSION_ID} STRIPE_SN_CANCELURL=https://inscription.afpedagogiesuzuki.fr/stagenational/paiement_annule?id={CHECKOUT_SESSION_ID} STRIPE_RI_SUCCESSURL=https://inscription.afpedagogiesuzuki.fr/rassemblementidf/paiement_reussi?id={CHECKOUT_SESSION_ID} STRIPE_RI_CANCELURL=https://inscription.afpedagogiesuzuki.fr/rassemblementidf/paiement_annule?id={CHECKOUT_SESSION_ID} STRIPE_RI_PRIVATE_KEY=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 STRIPE_RI_PUBLISHABLE_KEY=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 STRIPE_CONCERT_SUCCESSURL=https://inscription.afpedagogiesuzuki.fr/concert/concert_paiement/reussi?id={CHECKOUT_SESSION_ID} STRIPE_CONCERT_CANCELURL=https://inscription.afpedagogiesuzuki.fr/concert/concert_paiement/annule?id={CHECKOUT_SESSION_ID}

PDF_SERVICES_CLIENT_ID_julie=7596ed8f2a634c84a631d17e9d841844 PDF_SERVICES_CLIENT_SECRET_julie=p8e-Rf13NOjxHR1EUvlhhsn8aTwc2fHROSw0 PDF_SERVICES_CLIENT_ID=3f87412e36174973864e7c678c6fe918 PDF_SERVICES_CLIENT_SECRET=p8e-U5qFwt7VT7mUspkww9Tloj5kK4tVreDW

nodemailer_user=“afps.inscription@gmail.com” nodemailer_pass=“fuqw qbtu mlly dcvu”

gsheet_adhesion=“1kk3w5yGnHxGb9dtUkTlizVSvnf40erk6zYzR2QTk16g” gsheet_concertannuel=“1KHU5uIJnOWWs3xWifJGxalYG2fFsMzSec84ikU8dPcY” gsheet_stagenat=“1STdRD5lXP316hgtdQfNqcqSQavzaoOXDMOqmfqPc3_0”

db_connection_host=“localhost” db_connection_port=3306 db_connection_user=“root” db_connection_password=“G1plumeverte!” db_connection_database=“aduzuki”

weezevent_API_KEY=“17f7767ebe199c534b2cf1848dcb3490” weezevent_API_KEY_AFPS=“17f7767ebe199c534b2cf1848dcb3490” weezevent_USER_AFPS=“julie@parisweb.art” weezevent_USER=“julie@parisweb.art” weezevent_PASSWORD=“testapi123” weezevent_TOKEN_afps=“ecba0495a54cb69c10c34945a51abaec” weezevent_TOKEN=“ecba0495a54cb69c10c34945a51abaec” weezevent_id_event_concertiste=“1043199” weezevent_id_event_encacrant=“1043198” weezevent_id_event_spect=“1043050” weez_id_billet_concertiste=“3875316” weez_id_billet_spectateur=“3874933” weez_id_billet_encadrant_parent=“3875313” weez_id_billet_encadrant_prof=“3875315”

spectateur_nb_places=1308 remiseenvente_spect=“non” encadr_parent_nb_places=60 piano_nb_places=55 alto_nb_places=33 flute_nb_places=32 trompette_nb_places=15 harpe_nb_places=10 violon1_nb_places=220 violon2_nb_places=43 violoncelle1_nb_places=62 violoncelle2_nb_places=37

DEV

OVH WEB CLOUD
    jivciei.cluster024.hosting.ovh.net
DOMAINE
    adusuki.juliechaumard.paris
DOSSIER
    adusuki
MOTEUR D'EXECUTION
    nodejs-14
SYNCHRO GOODSYNC
    ADUZUKI DEV - OVH WebCloud Julie
BD
    jivcieiadmin.mysql.db
CONNEXION TERMINAL
    /usr/bin/ssh jivciei@sshcloud.cluster024.hosting.ovh.net -p 46057
    password = uTpn9mcDAVsC
    cd /home/jivciei/adusuki
GMAIL
    nodemailer_user="juliechaumard@gmail.com"
    nodemailer_pass="etfq umof iwbx ltxk"

### GNROK
https://bf89-2a01-e0a-5ee-1510-4021-f309-9a2c-823.ngrok-free.app/wh_stripe
https://9243-2a01-e0a-5ee-1510-4c7b-ac31-5c89-f077.ngrok-free.app

MODULES

npm-node14 install htmltopdf-weasyprint

PROD

GMAIL
    nodemailer_user="afps.inscription@gmail.com"
    nodemailer_pass="fuqw qbtu mlly dcvu"

ABBRÉVIATIONS

SN ou stn = STAGE NATIONAL

LOGGING

Exemples de traces

N'importe où
    logger.info("NOUS SOMMES DANS LE FICHIER : " + __filename,

{ label: __filename });

Dans une fonction req res :
    logger.info('bonjour Julie',

{ numsession: req.session.id }); logger.info(‘process.env.PORT :’ + process.env.PORT), { numsession: req.session.id }, { label: __filename };

    logger.info("XXX" + ZZZ, { numsession: req.session.id }, { label: __filename });

ENV

Si on change une variable d’environnement, il faut redémarrer le projet

HTACCESS

–ORIGINAL RewriteEngine On RewriteCond %{ENV:HTTPS} !on RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

PDF

try {
    var pdf_html = fs.readFileSync(path.resolve(__dirname,"../pdf/template/carte_adherent.html"), "utf8");
    var pdf_buffer = await weasyprint(pdf_html);
    fs.writeFileSync("juju.pdf", pdf_buffer);
} catch (error) {
    logger.info("Erreur durant la création du PDF : " + error, { numsession: req.session.id });
}

STRIPE

TEST CARD

ok normal
4242424242424242
4242 4242 4242 4242

ok 3DS
4000000000003063

pb
4000000000000002

RETOUR https://www.adusuki.afpedagogiesuzuki.fr/inscription/adhesion_paiement/reussi?id=cs_test_b1teU2a5wbTFwdPKGefvrKS1N6deBGPK86xFhdbxqKo9dtmgCzwoYZ8fJ6

INSCRIPTION MAJ Google Sheet automatique

CRON - le cron est lancé par la librairie cron de NodeJS - fichier modules/adhesion/majgs_webhook.js - mise en prod - ne pas oublier de changer l’URL à lancer dans le fichier majgs_webhook.js : commenter l’URL de dev localhost et décommenter l’URL de prod - pm2 start /var/www/aduzuki/modules/adhesion/majgs_webhook.js –name majgs_webhook

/Users/juliechaumard/Documents/GitHub/Aduzuki_v2/controllers/vente_video/files

INSERT INTO ras_adherent ( identifiant, association_suzuki, lieu, saison, date_maj, adherent_nom, adherent_prenom, adherent_telephone, adherent_mail, adherent_adresse_rue, adherent_adresse_complement, adherent_adresse_codepostal, adherent_adresse_ville, adherent_adresse_pays, ras_commentaire, accompagnant_nom, accompagnant_prenom, tarif_rassemblement, cout_total, statut_paiement, statut_suppression ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)