}
if ($filter->_etat_reglement_tiers == "reglee") {
$where["tiers_date_reglement"] = "IS NOT NULL";
}
if ($filter->_etat_reglement_tiers == "non_reglee") {
$where["tiers_date_reglement"] = "IS NULL";
$where["du_tiers"] = "> 0";
}
}
// Reglements via les factures de consultation
$where["cloture"] = "IS NOT NULL";
$where["patient_id"] = "IS NOT NULL";
$order = "ouverture, praticien_id";
$facture = new CFactureCabinet();
if ($all_group_money) {
$listFactures = $facture->loadList($where, $order, null, null, $ljoin);
} else {
$listFactures = $facture->loadGroupList($where, $order, null, null, $ljoin);
}
$listPlages = array();
CMbObject::massLoadFwdRef($listFactures, "praticien_id");
CMbObject::massLoadFwdRef($listFactures, "patient_id");
CMbObject::massCountBackRefs($listFactures, "reglements");
CMbObject::massCountBackRefs($listFactures, "notes");
foreach ($listFactures as $_facture) {
/* @var CFactureCabinet $_facture */
$_facture->loadRefGroup();
$_facture->loadRefPatient();
$_facture->loadRefPraticien();
$_facture->loadRefsConsultation();
if (count($_facture->_ref_consults)) {
$where["patient_id"] = " = '{$patient_id}'";
}
if ($numero && !CAppUI::conf("dPfacturation Other use_search_easy") && ($etat_relance || $search_easy == 7)) {
$where["facture_relance.numero"] = " = '{$numero}'";
}
if ($search_easy == 1) {
$where["definitive"] = " = '1'";
}
if ($num_facture) {
$where["facture_id"] = " = '{$num_facture}' ";
}
if ($xml_etat != "") {
$where["facture"] = " = '{$xml_etat}' ";
}
$facture = new CFactureCabinet();
$factures = $facture->loadList($where, "ouverture ASC", "0, 25", null, $ljoin);
$total_factures = $facture->countMultipleList($where, "facture_id", $ljoin);
$total_factures = $total_factures[0]['total'];
foreach ($factures as $key => $_facture) {
/* @var CFactureCabinet $_facture*/
$_facture->loadRefPatient();
$_facture->loadRefsItems();
$_facture->loadRefsConsultation();
$nb_tarmed = count($_facture->_ref_actes_tarmed);
$nb_caisse = count($_facture->_ref_actes_caisse);
$nb_ngap = count($_facture->_ref_actes_ngap);
$nb_ccam = count($_facture->_ref_actes_ccam);
if (count($_facture->_ref_consults) == 0) {
unset($factures[$key]);
}
}
