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();
?> |
