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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
| <?php
require('connexion.php');
ob_start();
?>
<link rel="stylesheet" href="style.css" />
<style type="text/css">
table{
width:100%;
}
.table-header-rotated{
color: red;
text-align: right;
width: auto;
height: 15px;
font-size:10px;
padding-right:0px;
}
.table-header-rotated th {
transform: rotate(90deg);
transform-origin: left top 0;}
</style>
<page backtop="20mm" backleft="10mm" backright="10mm" backbottom="30mm">
<?php
echo"<table class=table-header-rotated>
<thead>
<tr>
<th></th>";
$cpt=0;
$conn;
$tmp2=16;
$table= array();
$stid5 = oci_parse($conn, "SELECT BODY_NAME_EN, BODY_ACRONYM, BODY_ID FROM BODY WHERE BODY_ID in (select role_body_id_fk from role where role_member_id_fk in (select member_id from member where MEMBER_NATION_COUNTRY_ID_FK=".$tmp2." AND BODY_BODYTYPE_CODE_FK='DE' OR BODY_BODYTYPE_CODE_FK='AP' )) order by body_name_en");
oci_execute($stid5);
$countBody = oci_fetch_all($stid5, $res, 0, -1, OCI_FETCHSTATEMENT_BY_ROW);
$j=0;
while ($j < $countBody){
echo"<tr class=rotate-45>";
echo $res[$j]['BODY_NAME_EN'];
$j++;
echo "<br></tr>";
}
echo"</tr>
</thead>
<tbody>";
$stid2 = oci_parse($conn, 'SELECT COUNTRY_NAME_EN,MEMBER_LASTNAME, MEMBER_PHOTO_URL, MEMBER_FIRSTNAME, MEMBER_ID FROM MEMBER INNER JOIN COUNTRY ON MEMBER_NATION_COUNTRY_ID_FK=COUNTRY_ID WHERE MEMBER_NATION_COUNTRY_ID_FK='.$tmp2.' ORDER BY MEMBER_LASTNAME');
oci_execute($stid2);
while (($row = oci_fetch_array($stid2, OCI_BOTH)) != false) {
////je prend le nom prenom et id
$TmpNom=$row['MEMBER_LASTNAME'];
$TmpPrenom=$row['MEMBER_FIRSTNAME'];
$memberId=$row['MEMBER_ID'];
$memberPhoto=$row['MEMBER_PHOTO_URL'];
$memberCountry=$row['COUNTRY_NAME_EN'];
echo"<tr>";
echo $TmpNom,' ',$TmpPrenom ;
echo "</tr>";
}
echo "</tbody>
</table>
</page>";
?>
<?php
$content=ob_get_clean();
require('html2pdf/html2pdf.class.php');
try{
$pdf = new HTML2PDF('P','A4','fr');
$pdf->writeHTML($content);
$pdf->Output('testpdf.pdf');
}catch (HTML2PDF_exception $e){
die($e);
}?> |
Partager