Logo Search packages:      
Sourcecode: odontolinux version File versions  Download package

includi_mostra_piano_cura.php

<?   $esito = pg_Exec($conn, "SELECT * FROM pianocura where id = '$idpz' order by vocepianocura;");
   if (!$esito) {
                      echo "Si &egrave; verificato un errore.\n";
                      exit;
                      } // Errore interrogazione database
   $nume = pg_NumRows($esito); //inizia l'output tabelare della query
   $i = 0;
echo "<TABLE  WIDTH=\"100%\" Border=\"0\" cellpadding=\"2\" cellspacing=\"0\"><TR BGCOLOR=\"#000000\"><TD>";
echo "<TABLE  WIDTH=\"100%\" Border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
echo "<TR BGCOLOR=\"#FFFFFF\"><TD colspan=\"6\" ALIGN=\"CENTER\"><b><font color=\"#dda0dd\">";
echo gettext ("Treatment plan/s");
echo "</font></B></TD></TR>";
echo "<TR BGCOLOR=\"#dda0dd\"><TH><font color=\"#FFFFFF\">";
echo gettext ("Treatment");
echo "</font></TH>  <TH><font color=\"#FFFFFF\">";
echo gettext ("Tooth");
echo "</font></TH>  <TH><font color=\"#FFFFFF\">";
echo gettext ("Charge/U");
echo "</font></TH>  <TH><font color=\"#FFFFFF\">";
echo gettext ("Q.");
echo "</font></TH>  <TH><font color=\"#FFFFFF\">";
echo gettext ("Total charge");
echo "</font></TH>  <TH><font color=\"#FFFFFF\">";
echo gettext ("Treatment plan");
echo "</font></TH></TR>";


   while ($i < $nume) {
                  if (!($i % 2)) {
                              echo "<TR bgcolor=\"#fffaf0\"><TD>";
                              } else {
                                    echo "<TR bgcolor=\"#ffffff\"><TD>";
                              }
                  echo "<B><FONT COLOR=\"#dda0dd\">";
                  echo pg_Result($esito, $i, "prestazione");
                  echo "</FONT></B></TD><TD><I>&nbsp;&nbsp;";
                  echo pg_Result($esito, $i, "posizione");
                  echo "</I></TD><TD ALIGN=RIGHT>";
                  echo number_format (pg_Result($esito, $i, "prezzounitario"),2,',','.')        ;
                  echo "</TD><TD ALIGN=CENTER>";
                  echo pg_Result($esito, $i, "quantita");
                  echo "</TD><TD ALIGN=RIGHT><FONT COLOR=\"#FF69b4\">";
                  echo number_format (pg_Result($esito, $i, "prezzomoltiplicato"),2,',','.');
                  echo "</FONT></TD><TD align=\"center\">";
                  echo pg_Result($esito, $i, "vocepianocura");
                  echo "</TD></TR>";
                  $i++;
            }

      echo "</TABLE></TR></TABLE>";

   pg_FreeResult($esito); //liberazione memoria
?>

Generated by  Doxygen 1.6.0   Back to index