*/
require "../../../inc/dbconnect.php";
require "../../../inc/Facture.php";
extract($_GET);
$result = mysql_query("SELECT value FROM webfinance_pref WHERE type_pref='societe' AND owner=-1") or die(mysql_error());
list($value) = mysql_fetch_array($result);
mysql_free_result($result);
$societe = unserialize(base64_decode($value));
//"PBX_RETOUR" => "montant:M;ref:R;auto:A;trans:T;pbxtype:P;card:C;soletrans:S;error:E",
//http://webfinance.dev.jexiste.org/payment/paybox/secure/?montant=14472&ref=1041153308810&auto=XXXXXX&trans=605964387&pbxtype=CARTE&card=CB&soletrans=608599999&error=00000
if (isset($ref, $auto, $montant) and !empty($ref) and !empty($auto) and $montant > 200) {
echo "test ref,auto,montant: passed <br/>";
$res = mysql_query("SELECT id_invoice FROM webfinance_paybox WHERE reference='{$ref}' AND amount = {$montant}/100 ") or die(mysql_error());
if (mysql_num_rows($res) == 1) {
list($id_invoice) = mysql_fetch_array($res);
echo "ref,auto,montant: exist <br/>";
// mail($societe->email, "[DEBUG] WEBFINANCE Paybox passed", "This paybox updated : $ref $auto $montant ");
$res = mysql_query("UPDATE webfinance_paybox SET " . "state='ok' , " . "autorisation='{$auto}' , " . "transaction_id='{$trans}' , " . "amount = {$montant}/100 ," . "payment_type='{$pbxtype}' ," . "card_type='{$card}' ," . "transaction_sole_id='{$soletrans}' ," . "error_code='{$error}' , " . "date=NOW() " . "WHERE reference='{$ref}'") or die(mysql_error());
//maj de la facture
mysql_query("UPDATE webfinance_invoices SET is_paye=1, date_paiement=NOW() WHERE id_facture={$id_invoice} ") or die(mysql_error());
//on met à jour le cashflow
$Facture = new Facture();
$Facture->updateTransaction($id_invoice);
} else {
echo "ref,auto,montant: don't exist <br/>";
mail($societe->email, "[ALERT] WEBFINANCE Paybox ", "This reference doesn't exist : {$ref} {$auto} {$montant}");
}
} else {
echo "ref,auto,montant: invalid <br/>";
mail($societe->email, "[ALERT] CB transaction, REF or AUTORISATION not found", "CB transaction, REF or AUTORISATION or AMOUNT INVALID : {$ref} {$auto} {$montant}.");
}
mysql_query("DELETE FROM webfinance_invoices WHERE id_facture=" . $_GET['id_facture']) or wf_mysqldie();
$_SESSION['message'] = _('Invoice deleted');
//mysql_query("DELETE FROM webfinance_invoice_rows WHERE id_facture=".$_GET['id_facture']); <- ON DELETE CASCADE
mysql_query("DELETE FROM webfinance_transactions WHERE id_invoice=" . $_GET['id_facture'] . " AND type<>'real'") or wf_mysqldie();
$_SESSION['message'] .= "<br/>" . _('Transaction deleted');
}
header("Location: fiche_prospect.php?onglet=billing&tab=billing&id={$id_client}");
exit;
}
if ($action == "duplicate") {
extract($_GET);
$Invoice = new Facture();
$id_new_facture = $Invoice->duplicate($id);
if ($id_new_facture) {
logmessage("New invoice fa:{$id_new_facture} duplicated of fa:{$id} ", 'NULL', $id);
$Invoice->updateTransaction($id_new_facture);
/* $_SESSION['message'] = _("Invoice duplicated"); */
header("Location: edit_facture.php?id_facture={$id_new_facture}");
die;
} else {
//Error;
die("duplicate action failed");
}
die;
}
if ($action == "send") {
extract($_POST);
require "/usr/share/php/libphp-phpmailer/class.phpmailer.php";
$mail_addresses = explode(',', $mails2);
$mails = array_merge($mail_addresses, $mails);
if (count($mails) > 0) {