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
125
126
127
128
129
130
131
| <?php
$building_type= getSet($db, "select building_type from elevators group by building_type order by building_type", null);
$elevator_type= getSet($db, "select elevator_type from elevators group by elevator_type order by elevator_type", null);
$internal_doors= getSet($db, "select internal_doors from elevators group by internal_doors order by internal_doors", null);
$door_type= getSet($db, "select door_type from elevators group by door_type order by door_type", null);
$external_floor_door= getSet($db, "select external_floor_door from elevators group by external_floor_door order by external_floor_door", null);
$door_collisions= getSet($db, "select door_collisions from elevators group by door_collisions order by door_collisions", null);
$lock_type= getSet($db, "select lock_type from elevators group by lock_type order by lock_type", null);
$engine_room= getSet($db, "select engine_room from elevators group by engine_room order by engine_room", null);
$trochaliostasio= getSet($db, "select trochaliostasio from elevators group by trochaliostasio order by trochaliostasio", null);
$cableway_count= getSet($db, "select cableway_count from elevators group by cableway_count order by cableway_count", null);
$magnet_power_supply= getSet($db, "select magnet_power_supply from elevators group by magnet_power_supply order by magnet_power_supply", null);
$brake_power_supply= getSet($db, "select brake_power_supply from elevators group by brake_power_supply order by brake_power_supply", null);
$light_chamber= getSet($db, "select light_chamber from elevators group by light_chamber order by light_chamber", null);
$light_type= getSet($db, "select light_type from elevators group by light_type order by light_type", null);
$light_well= getSet($db, "select light_well from elevators group by light_well order by light_well", null);
?>
$(function ()
{
fill_elevator_combos();
//when new add it to combo + select it - http://stackoverflow.com/a/24281246/1320686
$('#light_well, #light_type, #light_chamber, #brake_power_supply, #magnet_power_supply, #cableway_count, #trochaliostasio, #engine_room, #lock_type, #door_collisions, #external_floor_door, #door_type, #internal_doors, #elevator_type, #building_type').on('change', function() {
if (this.value == "**new**") {
var new_entry = prompt("Input the new record", "");
if (!new_entry)
return;
var o = new Option(new_entry);
o.selected=true;
$("#" + this.name).append(o);
}
});
}); // jQ
function fill_elevator_combos()
{
var building_type = <?php echo json_encode($building_type); ?>;
setComboItems("building_type", building_type);
var elevator_type = <?php echo json_encode($elevator_type); ?>;
setComboItems("elevator_type", elevator_type);
var internal_doors = <?php echo json_encode($internal_doors); ?>;
setComboItems("internal_doors", internal_doors);
var door_type = <?php echo json_encode($door_type); ?>;
setComboItems("door_type", door_type);
var external_floor_door = <?php echo json_encode($external_floor_door); ?>;
setComboItems("external_floor_door", external_floor_door);
var door_collisions = <?php echo json_encode($door_collisions); ?>;
setComboItems("door_collisions", door_collisions);
var lock_type = <?php echo json_encode($lock_type); ?>;
setComboItems("lock_type", lock_type);
var engine_room = <?php echo json_encode($engine_room); ?>;
setComboItems("engine_room", engine_room);
var trochaliostasio = <?php echo json_encode($trochaliostasio); ?>;
setComboItems("trochaliostasio", trochaliostasio);
var cableway_count = <?php echo json_encode($cableway_count); ?>;
setComboItems("cableway_count", cableway_count);
var magnet_power_supply = <?php echo json_encode($magnet_power_supply); ?>;
setComboItems("magnet_power_supply", magnet_power_supply);
var brake_power_supply = <?php echo json_encode($brake_power_supply); ?>;
setComboItems("brake_power_supply", brake_power_supply);
var light_chamber = <?php echo json_encode($light_chamber); ?>;
setComboItems("light_chamber", light_chamber);
var light_type = <?php echo json_encode($light_type); ?>;
setComboItems("light_type", light_type);
var light_well = <?php echo json_encode($light_well); ?>;
setComboItems("light_well", light_well);
//empty vars
building_type = elevator_type = internal_doors = door_type = external_floor_door = door_collisions = lock_type = engine_room = trochaliostasio = cableway_count = magnet_power_supply = brake_power_supply = light_chamber = light_type = light_well = null
}
function setComboItems(ctl_name, jArray)
{
if(jArray) {
var combo_rows = "<option value='0'></option>";
for (var i = 0; i < jArray.length; i++)
{
combo_rows += "<option>" + jArray[i][ctl_name] + "</option>";
}
combo_rows+= "<option>**new**</option>";
$("[name=" + ctl_name + "]").html(combo_rows);
$("[name=" + ctl_name + "]").change();
}
}
<div class='form-group'>
<label>building_type :</label>
<select name='building_type' id='building_type' class='form-control'> </select>
</div>
<div class='form-group'>
<label>elevator_type :</label>
<select name='elevator_type' id='elevator_type' class='form-control'> </select>
</div>
.
.
.
.
.
.
.
<div class='form-group'>
<label>light_well :</label>
<select name='light_well' id='light_well' class='form-control'> </select>
</div>
|