$request_b->addOrder("patients.nom ASC, plageconsult.date ASC"); } elseif ($sejour_filled) { $request_b->addSelect("sejour.sejour_id, patients.patient_id" . $other_fields); $request_b->addTable("sejour"); $request_b->addOrder("patients.nom ASC, sejour.entree_prevue ASC"); } elseif ($interv_filled) { $request_b->addSelect("operations.operation_id, patients.patient_id" . $other_fields); $request_b->addTable("operations"); $request_b->addOrder("patients.nom ASC, operations.date ASC"); } else { $request_b->addSelect("patients.patient_id"); $request_b->addTable("patients"); $request_b->addOrder("patients.nom ASC"); } $request_b->addLJoin($ljoin); $request_b->addRJoin($rjoinMix); $request_b->addWhere($where); $request_b->addWhere($whereMix); if (!$export) { $request_b->setLimit("{$start},30"); } $results = array_merge($results, $ds->loadList($request_b->makeSelect())); } foreach ($results as $_result) { $_patient_id = $_result["patient_id"]; $pat = new CPatient(); $pat->load($_patient_id); // Recherche sur un antécédent if (isset($_result["antecedent_id"])) { $_atcd = new CAntecedent(); $_atcd->load($_result["antecedent_id"]);