if ($ma_valeur != 3) {
$sql = "INSERT INTO `aerogard2`.`facturation` (`id`, `id_c`, `date`, `veto`, `veto2`, `detail`, `totalttc`,`reglementttc`, `total_acte`,`reglement_acte`, `total_medic`,`reglement_medic`, `acte`, `medic` ) VALUES('' , :consultation_id, ( UNIX_TIMESTAMP(STR_TO_DATE(:date_consult,'%d/%m/%Y %H:%i')) *1000 ), '" . $_SESSION['login'] . "', '" . $_SESSION['login2'] . "', '', :totalttc, :reglementttc, :total_acte, :reglement_acte, :total_medic, :reglement_medic, :acte, :medic)";
$sth = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
//$sth->execute(array(':consultation_id' => $consultation_id, ':date_consult' => $info_formulaire['date_consultation'], ':totalttc' => $info_formulaire['total_consult'], ':reglementttc' => $total_reglement, ':acte' => $info_acte, ':medic' => $info_medic));
$sth->execute(array(':consultation_id' => $consultation_id, ':date_consult' => $info_formulaire['date_consultation'] == date("d/m/Y") ? $info_formulaire['date_consultation'] . " " . date("H:i") : $info_formulaire['date_consultation'] . " 00:00", ':totalttc' => $info_formulaire['total_consult'], ':reglementttc' => 0, ':total_acte' => $info_formulaire['montant_acte'], ':reglement_acte' => 0, ':total_medic' => $info_formulaire['montant_medic'], ':reglement_medic' => 0, ':acte' => $info_acte, ':medic' => $info_medic));
$facturation_id = $db->lastInsertId();
} elseif ($ma_valeur == 3) {
$sql = "INSERT INTO `aerogard2`.`facturation` (`id`, `id_c`, `date`, `veto`, `veto2`, `detail`, `totalttc`,`reglementttc`, `total_acte`,`reglement_acte`, `total_medic`,`reglement_medic`, `acte`, `medic` ) VALUES('' , :consultation_id, ( UNIX_TIMESTAMP(STR_TO_DATE(:date_consult,'%d/%m/%Y %H:%i')) *1000 ), '" . $_SESSION['login'] . "', '" . $_SESSION['login2'] . "', '', :totalttc, :reglementttc, :total_acte, :reglement_acte, :total_medic, :reglement_medic, :acte, :medic)";
$sth = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
//$sth->execute(array(':consultation_id' => $consultation_id, ':date_consult' => $info_formulaire['date_consultation'], ':totalttc' => $info_formulaire['total_consult'], ':reglementttc' => $total_reglement, ':acte' => $info_acte, ':medic' => $info_medic));
$sth->execute(array(':consultation_id' => $consultation_id, ':date_consult' => $info_formulaire['date_consultation'] == date("d/m/Y") ? $info_formulaire['date_consultation'] . " " . date("H:i") : $info_formulaire['date_consultation'] . " 00:00", ':totalttc' => 0, ':reglementttc' => 0, ':total_acte' => 0, ':reglement_acte' => 0, ':total_medic' => 0, ':reglement_medic' => 0, ':acte' => $info_acte, ':medic' => $info_medic));
$facturation_id = $db->lastInsertId();
}
$mon_array = array();
if ($ma_valeur == 2) {
$reste_a_payer_json = requetemysql::reste_a_payer2(array('consult' => $consultation_id));
} else {
$reste_a_payer_json = requetemysql::reste_a_payer(array('id_proprio' => $info_client[0]['id2']));
}
$reste_a_payer = json_decode($reste_a_payer_json, TRUE);
$reste_a_payer2 = $reste_a_payer;
array_push($mon_array, $info_paiement);
//$mavariable = array();
$reste_a_payer_2 = $reste_a_payer;
$info_paiement_2 = $info_paiement;
if (count($info_paiement) > 0 && $ma_valeur != 3) {
while (list($key_paiement, $value_paiement) = each($info_paiement)) {
//$mavariable[$key_paiement]["cat"]=$value_paiement['montant'];
//$mavariable[$key_paiement]["long"]=count($reste_a_payer);
while (list($key_a_payer, $value_a_payer) = each($reste_a_payer)) {
$reste_du = difference($value_a_payer['totalttc'], $value_a_payer['reglementttc']);
