<?php

        $DB = pg_connect("host=pgsql2 user=tpcurseurs dbname=tpcurseurs password=tpcurseurs");
        if(!$DB){
                die("Unable to connect");
        }

        $request = "SELECT * FROM service ORDER BY num_service";
        $result = pg_query($DB, $request);
        if(!$result){
                die("Unable to query : </br> $request");
        }

        $stmt = "reqEmplServ";
        $subPreparedRequest = pg_prepare($DB, $stmt, "SELECT * FROM employe WHERE num_service = $1 ORDER BY coeff_salaire");

        while($raw = pg_fetch_assoc($result)){
                echo("<table>");
                $num_service = $raw["num_service"];

                //premiere ligne du service
                echo("<tr>");
                echo("<td>".$num_service."</td>");
                echo("<td>".$raw["nom_service"]."</td>");
                echo("<td>".$raw["nom_chef"]."</td>");
                echo("</tr>");

                //Ligne des employes
                $subResult = pg_execute($DB, $stmt, array($num_service));
                if(!$subResult){
                        die("Unable to query : </br> \$subRequest");
                }

                $average = 0;
                $max = 0;
                $min = 10000000;
                $total = pg_num_rows($subResult);
                while($subRaw = pg_fetch_assoc($subResult)){
                        $coeff = $subRaw["coeff_salaire"];

                        echo("<tr>");
                        echo("<td>".$subRaw["num_employe"]."</td>");
                        echo("<td>".$subRaw["nom_employe"]."</td>");
                        echo("<td>".$coeff."</td>");
                        echo("</tr>");

                        $average = $average + $coeff;
                        if($max < $coeff){
                                $max = $coeff;
                        }
                        if($min > $coeff){
                                $min = $coeff;
                        }
                }
                echo("</table>");
                $average = $average / $total;
                //Derniere ligne du service
                echo("Moyenne = ".$average." | Coef max = ".$max." | Coef min = ".$min." | Total employes = ".$total."</br></br>");
        }


?>