-
Notifications
You must be signed in to change notification settings - Fork 0
/
manage_records.php
113 lines (108 loc) · 3.9 KB
/
manage_records.php
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
<?php include 'db_connect.php' ?>
<?php
session_start();
if(isset($_GET['id'])){
$qry = $conn->query("SELECT t.*,concat(p.lastname,', ',p.firstname,' ',p.middlename) as name, concat(p.address,', ',p.street,', ',p.baranggay,', ',p.city,', ',p.state,', ',p.zip_code) as caddress,e.name as ename,p.tracking_id FROM person_tracks t inner join persons p on p.id = t.person_id inner join establishments e on e.id = t.establishment_id where t.id= ".$_GET['id']);
foreach($qry->fetch_array() as $k => $val){
$$k=$val;
}
}
?>
<div class="container-fluid">
<form action="" id="manage-records">
<input type="hidden" name="id" value="<?php echo isset($id) ? $id :'' ?>">
<div class="form-group">
<label for="" class="control-label">Toner Serial</label>
<input type="number" class="form-control" id="tracking_id" name="tracking_id" value="<?php echo isset($tracking_id) ? $tracking_id :'' ?>" required autocomplete="off">
</div>
<div class="row">
<div class="col-md-12">
<button class="btn btn-sm btn-primary btn-sm col-sm-2 btn-block float-right" type="button" id="check">Check</button>
</div>
</div>
<div id="details" <?php echo isset($id) ? "style='display:block'" : 'style="display:none"' ?>>
<p><b>Toner Model: <span id="name"><?php echo isset($id) ? ucwords($name) : '' ?></span></b></p>
<p><b>Toner Details: <span id="address"><?php echo isset($id) ? $caddress : '' ?></span></b></p>
<input type="hidden" name="person_id" value="<?php echo isset($person_id) ? $person_id : '' ?>">
<div class="form-group">
<label for="" class="control-label">Issued Date</label>
<input type="text" class="form-control" name="temperature" value="<?php echo isset($temperature) ? $temperature :'' ?>" required>
</div>
<?php if($_SESSION['login_type'] == 1): ?>
<div class="form-group">
<label for="" class="control-label">Department</label>
<select name="establishment_id" id="" class="custom-select select2">
<option value=""></option>
<?php
$establishment = $conn->query("SELECT * FROM establishments order by name asc");
while($row= $establishment->fetch_assoc()):
?>
<option value="<?php echo $row['id'] ?>" <?php echo isset($establishment_id) && $row['id'] == $establishment_id ? 'selected' : '' ?>><?php echo $row['name'] ?></option>
<?php endwhile; ?>
</select>
</div>
<?php else: ?>
<input type="hidden" name="establishment_id" value="<?php echo isset($establishment_id) ? $establishment_id : $_SESSION['login_establishment_id'] ?>">
<?php endif; ?>
</div>
</form>
</div>
<script>
$(".select2").select2({
placeholder:"Please select here",
width:'100%'
})
$('#manage-records').submit(function(e){
e.preventDefault()
start_load()
$.ajax({
url:'ajax.php?action=save_track',
data: new FormData($(this)[0]),
cache: false,
contentType: false,
processData: false,
method: 'POST',
type: 'POST',
success:function(resp){
resp=JSON.parse(resp)
if(resp.status==1){
alert_toast("Data successfully saved",'success')
setTimeout(function(){
location.reload()
},1500)
}
}
})
})
$('#tracking_id').on('keypress',function(e){
if(e.which == 13){
get_person()
}
})
$('#check').on('click',function(e){
get_person()
})
function get_person(){
start_load()
$.ajax({
url:'ajax.php?action=get_pdetails',
method:"POST",
data:{tracking_id : $('#tracking_id').val()},
success:function(resp){
if(resp){
resp = JSON.parse(resp)
if(resp.status == 1){
$('#name').html(resp.name)
$('#address').html(resp.address)
$('[name="person_id"]').val(resp.id)
$('#details').show()
end_load()
}else if(resp.status == 2){
alert_toast("Unknow tracking id.",'danger');
end_load();
}
}
}
})
}
</script>