function ListContractRenew()
{
global $URL;
$sql = "\n\tSELECT `insurancecontract`.`idContract`, `FirstName`, `FamilyName`, `TypeContract`, `KindContract`, MAX(`StartDate`), MAX(`EndDate`), `Amount`, `idCycle`,`client`.`idClient`\n\t \n\t FROM `insurancecontract`,`contractcycle`,`payment`,`client`\n\t \n\t WHERE `client`.`idClient`=`insurancecontract`.`idClient`\n\t\t AND\n\t `contractcycle`.`idContract`=`insurancecontract`.`idContract`\n\t\t AND \n\t `payment`.`idPayment`=`contractcycle`.`idPayment`\n AND\n `insurancecontract`.`KindContract`='Renouvelable'\n\tGROUP BY `insurancecontract`.`idContract`\n\t";
$result = QueryExcuteWhile($sql);
while ($o = mysqli_fetch_array($result)) {
$idContract = $o[0];
echo '
<tr id="tr" onclick="document.location=\'' . $URL . 'ili-modules/contrat/renew/renew?id=' . $o[0] . '\'">
<td>' . $o[0] . '</td>
<td>' . $o[2] . ' ' . $o[1] . '</td>
<td>' . $o[3] . '</td>
<td>' . $o[5] . '</td>
<td>' . $o[6] . '</td>
<td>';
ExpireIn($o[6]);
echo '</td>
</tr>
';
}
}
<td><?php
ContractGetAllAmount($idContract);
?>
</td>
</tr>
<tr>
<td class="span4">Renouvellement :</td>
<td><?php
ContractGetRenewTimes($idContract);
?>
</td>
</tr>
<tr>
<td class="span4">Etat :</td>
<td><?php
ExpireIn($cnt->EndDate);
?>
</td>
</tr>
</tbody>
</table>
<h3>#Client : <a href="<?php
echo $URL;
?>
ili-modules/client/client?id=<?php
echo $cnt->idClient;
?>
"><?php
echo $cnt->idClient;
?>
</a></h3>
