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
| }
if($val=='projet') {// $ls = $rdfReporting->getAbout('urn:steria:reporting:plateforme:'.$item['plateforme_id'].':projet');
// $ls = $rdfReporting->getAbout('urn:steria:reporting:plateforme:'.$item['plateforme_id'].':projet');
$ls=array();
// $dbsql = "select * from PROJET,PLATEFORME WHERE PROJET.ACTIF=1 AND PROJET.ID_PLATEFORME=PLATEFORME.ID_PLATEFORME order by PLATEFORME.ID_PLATEFORME asc";
$sql="select * from PLATEFORME WHERE ID_PLATEFORME=2";
$query = @sqlite_query(Steria::$database, $sql,SQLITE_ASSOC ,$error);
?>
<div >
<fieldset>
<table>
<tr><th>Nom du projet</th><th>PER réel</th><th>FV Réel</th><th>MEP</th><th>VSR</th><th>Commentaires</th></tr>
<?php
while ($fetcha = sqlite_fetch_array($query,SQLITE_ASSOC )){
$variable=$item['plateforme_id'];
$dbsql = "select * from PROJET,PLATEFORME WHERE PROJET.ACTIF=1 AND PROJET.ID_PLATEFORME=PLATEFORME.ID_PLATEFORME AND PROJET.ID_PLATEFORME='$variable'";
$dbquery = @sqlite_query(Steria::$database, $dbsql,SQLITE_ASSOC ,$error);
while ($fetch = sqlite_fetch_array($dbquery,SQLITE_ASSOC )){// $list[$fetch['ID_PROJET']] = $fetch['NOM_PROJET'];
//$list[$fetch['NOM_PROJET']] = $fetch['CATEGORIE'];
$list=array();
$class = ($class=='rowcol1') ? 'rowcol2' : 'rowcol1' ;
// echo "<tr class=\"$class\">";
//echo "<tr class=\"$class\" onDblClick=\"window.alert('FORBIDDEN !!')\" onMouseOut=\"this.style.backgroundColor=''\">";
//echo "<tr class=\"$class\" onDblClick=\"<input type=\"text\" size=\"10\" name=\"$class\" >";
echo "<tr class=\"$class\" onDblClick=\"<input type=\"text\" size=\"10\" name=\"$class\" >" ;
// "<input type=\"button\" value=\"$inputName\" oncliCk=\"javascript: document.manager.mngAction.value='$actionName'; document.manager.submit();\" >";
echo "<td>".@$fetch['PROJET.NOM_PROJET']."</td>";
// echo "<td>"."<input type=\"text\" size=\"10\" name=\"$class\" >"."</td>";
echo "<td>".$fetch['PROJET.PER_REEL']."</td>";
// $moda=$fetch['PROJET.PER_REEL'];
echo "<td>".$fetch['PROJET.FV_REEL']."</td>";
// echo "<th><a href='$moda'>$moda</a></th>";
//$modb=$fetch['PROJET.FV_REEL'];
// echo "<th><a href='$modb'>$modb</a></th>";
echo "<td>".$fetch['PROJET.MEP']."</td>";
// $modc=$fetch['PROJET.MEP'];
// echo "<th><a href='$modc'>$modc</a></th>";
echo "<td>".$fetch['PROJET.VSR']."</td>";
// $modD=$fetch['PROJET.VSR'];
// echo "<th><a href='$modD'>$modD</a></th>";
echo "<td>".$fetch['PROJET.COMMENTAIRE']."</td>";
//$modE=$fetch['PROJET.COMMENTAIRE'];
// echo "<th><a href='$modE'>$modE</a></th>";
echo "</tr>";
}
}
?>
</table>
</fieldset>
</div>
<?php
$dbsql=array(array("","submit","","ENREGISTRER SAISIE"));
echo"<FORM ACTION=\"doc_planification.php\"METHOD=\"POST\">\n";
//$test=array($dbsql);
foreach($dbsql as $zone){
echo "$zone[0]<INPUT TYPE=\"$zone[1]\"
NAME=\"$zone[2]\" VALUE=\"$zone[3]\"><BR>\n";
}
echo"</FORM>";
} |
Partager