1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
$strScript = "SELECT DATE_FORMAT(dateEnvoiRapport,'%d/%m/%Y') AS laDateEnvoi ";
$strScript .= "FROM tblrappelenvoi WHERE dossierID = '".$result['dossierID']."' ";
$strScript .= "ORDER BY dateEnvoiRapport DESC LIMIT 0,1";
$req2 = $objCon->dbQuery($strScript);
$result2 = mysql_fetch_assoc($req2);
echo "
<tr>
<td align=\"center\" width=\"15%\">
".$result['versionDossier']."
</td>
<td align=\"center\" width=\"25%\">
".$result['cieAssuranceNom']."
</td>
";
//L'affichage ne dois pas dépasser la cellule, alors petit arnaque...voir css
$nomtotal = str_replace(" "," ",$result['clientAssureNom'].' '.$result['clientAssurePrenom']);
//ici je concatene la string seulement s'il y a un 2e nom au dossier dans clientAssureNom2
$nomtotal .= ($result['clientAssureNom2'] != '') ? str_replace(" "," ",' ET '.$result['clientAssureNom2'].' '.$result['clientAssurePrenom2']) : '';
echo "
<td align=\"center\" width=\"20%\">
<div class=\"div\">".$nomtotal."</div>
</td>
<td align=\"center\" width=\"20%\">
".$result['laDateRappel']."
</td>
<td align=\"center\" width=\"20%\">
";
echo ($result2['laDateEnvoi'] != '00/00/0000') ? $result2['laDateEnvoi'] : 'Aucun envoi';
echo "
</td>
</tr>
"; |
Partager