$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']); if (difference($reste_du, $value_paiement['montant']) == 0 && $value_paiement['montant'] > 0) { $ma_var = $value_a_payer['reglementttc'] + $value_paiement['montant'];