105 lines
4.3 KiB
PHP
Executable File
105 lines
4.3 KiB
PHP
Executable File
<?php
|
|
$nomFicAppelant = basename(__FILE__);
|
|
// -----------------------------------------------------
|
|
// Mise à jour de l'abonnement suite a paiement
|
|
// -----------------------------------------------------
|
|
$today = date("Y-n-j");
|
|
|
|
// -----------------------------------------------------
|
|
// 1 - recup idClient 123clients
|
|
// -----------------------------------------------------
|
|
include ($includePathAdmin. "/req/reqRecupClient123.php");
|
|
|
|
// -----------------------------------------------------
|
|
// Debug
|
|
// -----------------------------------------------------
|
|
$idFormule= $_SESSION['idFormule'];
|
|
$idModule=$_SESSION['idModule'];
|
|
if (isset($debug[2]) && $debug[2] == '1') {
|
|
$debugMsg .= monDebug (2, [
|
|
'SESSION idFormule' => $_SESSION['idFormule'],
|
|
'SESSION idModule' => $_SESSION['idModule'],
|
|
'idFormule' => $idFormule
|
|
]'',);
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// Retrouver le subscription ID pour le mettre en base ( pas reussi à le faire directement dans le checkout, mais marche ici )
|
|
// -----------------------------------------------------
|
|
//
|
|
require 'vendor/autoload.php';
|
|
|
|
// recup cles api
|
|
include ("clesStripe/stripePKSFormules.php");
|
|
|
|
// recup subscription
|
|
$stripe = new \Stripe\StripeClient($privateSecretStripe);
|
|
try {
|
|
$response= $stripe->checkout->sessions->retrieve($_SESSION['checkOutSession_id']);
|
|
if (isset($debug[2]) && $debug[2] == '1' ) {
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['reponse' => $response], '');}
|
|
}
|
|
$stripePaiement_id=$response->id;
|
|
$_SESSION['stripePaiement_id']=$stripePaiement_id;
|
|
if (isset($debug[2]) && $debug[2] == '1' ) $debugMsg .= monDebug (2, ['stripePaiement_id' => $stripePaiement_id ],'');
|
|
|
|
$stripeSubscription_id=$response->subscription;
|
|
$_SESSION['stripeSubscription_id']=$stripeSubscription_id;
|
|
if (isset($debug[2]) && $debug[2] == '1' ) $debugMsg .= monDebug (2, ['stripeSubscription_id' => $stripeSubscription_id ],'');
|
|
|
|
$custId=$response->client_reference_id;
|
|
$cust=$response->customer;
|
|
$_SESSION['custId']=$cust;
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['cust' => $cust], '');}
|
|
$continuer=1;
|
|
}
|
|
catch(Exception $e) {
|
|
$api_error = $e->getMessage();
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['api_error' => $api_error], '');}
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Erreur lors de la récupération du paiement (' => $api_error], '');}
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// 4 - Mettre à jour la DB
|
|
// -----------------------------------------------------
|
|
if ($continuer==1) {
|
|
$today = date("Y-n-j");
|
|
|
|
$reqUpdate="UPDATE `123projets` SET is_payed=1, ";
|
|
$reqUpdate .= "param1='" .$idFormule. "', ";
|
|
if (isset($desc)) $reqUpdate .= "param2='" .$desc. "', ";
|
|
$reqUpdate .= "stripeSubscription_id='" .$stripeSubscription_id. "', ";
|
|
$reqUpdate .= "stripePaiement_id='" .$stripePaiement_id. "', ";
|
|
$reqUpdate .= "stripeClient_id='" .$cust. "', ";
|
|
$reqUpdate .= "statut='actif', ";
|
|
$reqUpdate .= "dateAchat='" .$today. "', ";
|
|
$reqUpdate .= "dateRenouvellement='sans', ";
|
|
if (isset($desc)) $reqUpdate .= "description='" .$desc. "', ";
|
|
$reqUpdate .= "commentaire='Prestation', ";
|
|
$reqUpdate .= "jsonReponse='" .$response. "' ";
|
|
$reqUpdate .= "WHERE idClient=" .$idClient123. " AND idModule=" .$idModule. ";";
|
|
|
|
if (isset($debug[2]) && $debug[2] == '1') { $debugMsg .= monDebug(2, ['Req update Presta' => $reqUpdate], 'reqUpdateFormules.php');}
|
|
$resConn=$connexion->query($reqUpdate);
|
|
if ($resConn) {
|
|
$admMsg .="<br>Mise à jour du de la formule ok. ";
|
|
}
|
|
else {
|
|
$admMsg .="<br>Echec de la mise à jour de la formule => reqUpdatePresta.php";
|
|
}
|
|
}
|
|
|
|
// -----------------------------------------------------
|
|
// Version SMS free API
|
|
// -----------------------------------------------------
|
|
// setlocale (LC_TIME, 'fr_FR.utf8','fra');
|
|
// $msg= "Nouvel prestation 123ventes : " .$_SESSION['nomSiteAff']. ' - ' .$desc ;
|
|
// include ("smsFree.php");
|
|
// if (isset($debug[1]) && $debug[1] == '1' ) $debugMsg .=$output;
|
|
|
|
// -----------------------------------------------------
|
|
// Make facture
|
|
// -----------------------------------------------------
|
|
$idModule=21; // pour reqUdateFacture
|
|
include ("./extensions/makeFact/chapeauMakeFacture.php");
|
|
?>
|