xTable/dd.php at BDD · coderize/xTable · GitHub

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
<?php
error_reporting(E_ALL ^ E_NOTICE);
include "includes/config.php";


?>

<?php
		$client = $_GET['client'];
		$project = $_GET['project'];
		$vert = $_GET['vert'];

	$verts = mysql_query("SELECT vertical_id, vertical_name FROM table_vertical WHERE vertical_id < 5 ORDER BY vertical_name ASC");


	if($vert && !$client && !$project){
?>

	<option value='na'>Vertical Selection</option>

<?php	 while($qverts = mysql_fetch_object($verts)){
?>

				<option value="<?php echo $qverts->vertical_id; ?>"><?php echo $qverts->vertical_name; ?></option>

<?php
	 }

}
?>


<?php

		if($client && !$project){
?>

		<option value=''>Client Selection</option>
<?php
				$clients = mysql_query("SELECT client_id, client_name
											FROM table_client, table_vertical, table_relation

											WHERE vertical_id = r_vertical
											AND vertical_id= '{$vert}'
											AND client_id = r_client

											GROUP BY client_id
											ORDER BY client_name ASC
											");

				while($qclients = mysql_fetch_object($clients)){
?>

				<option value="<?php echo $qclients->client_id; ?>"><?php echo $qclients->client_name; ?></option>


<?php
				}


		}

?>


<?php


		if($project){
?>

		<option value=''>Project Selection</option>
<?php
				$projects = mysql_query("SELECT project_id, project_name

															FROM table_project, table_client, table_vertical, table_relation

															WHERE vertical_id = r_vertical
															AND vertical_id = '{$vert}'
															AND client_id = r_client
															AND client_id = '{$client}'
															AND project_id = r_project

															GROUP BY project_id
															ORDER BY project_name ASC
															");

				while($qprojects = mysql_fetch_object($projects)){
?>

				<option value="<?php echo $qprojects->project_id; ?>"><?php echo $qprojects->project_name; ?></option>


<?php
				}


	}

?>