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 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124
|
Code de la page projet_general.php :
Partie requête sql :
$sql="SELECT p.id_project as id, c.name as customer, c.logo, co.name AS country, c.url_customer, g.firstname as gpm_firstname, g.lastname as gpm_lastname, m.firstname as op_firstname, m.lastname as op_lastname, c.customer_contact_name, c.customer_contact_phone, c.customer_benefits, p.number_employees_outsourced, p.alu_benefits, p.solution, p.challenge,r.name as region, u.reg,t.name as type_project,g.x500link,con.contract_award_date as date, con.contract_duration_years as duration,s.subscribers_scope as sub
FROM customer AS c, project AS p, gpm AS g, op_mgr AS m, country AS co,region as r, regional_unit as u, type_project as t, contract as con, scope as s
WHERE
s.id_scope=p.id_scope
and con.id_customer=c.id_customer
and c.id_customer = p.id_customer
AND p.id_op = m.id_op
AND p.id_gpm = g.id_gpm
AND co.id_country = c.id_country
and co.id_region=r.id_region
and co.id_uniteregional=u.id_uniteregional
and t.id_typeproject=p.id_typeproject
GROUP BY (
c.name)" ;
$result=mysql_query($sql);
Partie affichage
<th class="locked" scope="col"> Customer</th><th scope="col">Country</th><th scope="col">Project Type</th>
<th scope="col">GPM Name</th>
<th scope="col">Project Contacts</th>
<th scope="col">Contract Award Date </th><th >Contract Duration Years </th> <th scope="col">Calendar Information</th><th >Subscribers in Scope </th>
<th scope="col">Customer Benefits </th><th scope="col">Scope in the Project</th><th scope="col"> Alu in the Project</th></tr>
<?php while($rows=mysql_fetch_array($result)){
?>
<tr style="color: Black; background-color: rgb(238, 238, 238);" align="left" valign="middle">
<td class="locked" style="font-weight: bold;">
<span><?PHP echo $rows['customer']; ?></span>
</td>
<td style="font-weight: bold;">
<span> <?PHP echo $rows['country']; ?></span>
</td>
</td>
<td style="font-weight: bold;">
<span ><?PHP echo $rows['type_project']; ?></span>
</td>
<td style="font-weight: bold;">
<a href="<?PHP echo $rows['x500link']; ?>" target="_blank"> <U><?PHP echo $rows['gpm_firstname']; ?> <?PHP echo $rows['gpm_lastname']; ?></U></a> </td>
<td style="font-weight: bold;"> <a style="color: red" href="#" onClick="popup1('pop_up_contact.php', 700, 400)"> <u>More Contact</u></a>
</td>
<td style="font-weight: bold;">
<span><?PHP echo $rows['date']; ?></span>
</td><td style="font-weight: bold;">
<span ><?PHP echo $rows['duration']; ?></span>
</td><td style="font-weight: bold;"> <a style="color: red" href="#" onClick="popup1('pop_up_calendar.php', 800, 400)"> <u>Calendar</u></a>
</td>
<td style="font-weight: bold;"><?PHP echo $rows['sub']; ?></td><td>
<span ><?PHP echo $rows['customer_benefits']; ?></span>
</td>
<td style="font-weight: bold;"> <span ><a style="color: red" href="#" onClick="popup1('pop_up_scope.php', 1100, 400)"><U>Scope</U></span></td>
<TD style="font-weight: bold;"><a style="color: red" href="#" onClick="popup1('pop_up_alu.php', 700, 400)"><u>Alu</a></u>
</td>
</tr>
<?php
}
mysql_close();
?>
</table>
code de la page pop_up_scope.php :
la requête sql :
$sql="SELECT s.subscribers_scope,s.function_scope,s.technologie_scope,s.main_scope_customer
, p.id_project,c.name as customer
FROM project AS p, scope as s, customer as c
WHERE p.id_scope = s.id_scope
and c.id_customer=p.id_customer
AND p.id_project = '1'
ORDER BY (
p.id_project)
" ;
$result=mysql_query($sql);
code de la page
<?php while($rows=mysql_fetch_array($result)){
?>
<h1> Project Scope <?PHP echo $rows['customer']; ?></h1>
<br/> <!--mettre le code-->
<table style="border: 1px none ; width: 1030px; border-collapse: collapse; font-family: 'Trebuchet MS'; border="0" cellpadding="3" cellspacing="2" >
<tr>
<td><big>Subscribers Scope</big> </td>
<td style="FONT-FAMILY: Arial; COLOR : green"><H3><?PHP echo $rows['subscribers_scope']; ?></H3></td>
<td><big>Function Scope </big> </td>
<td style="COLOR: green;"><H3><?PHP echo $rows['function_scope']; ?></H3></td>
</tr>
<tr><td></td><td></td></tr>
<tr>
<td ><big>Technologie Scope</big> </td>
<td style="COLOR: green"><H3><?PHP echo $rows['technologie_scope']; ?></H3></td>
<td ><big>Main Scope Customer</big> </td>
<td style="COLOR: green"><H3><?PHP echo $rows['main_scope_customer']; ?></H3></td></tr>
<tr><td></td><td></td></tr>
<?php }
mysql_close();
?> |
Partager