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
|
<script>
$(document).ready(function(){
var val = [];
$('.subsidy_get:checked').each(function(i) {
val[i] = $(this).val();
//alert(val[i]);
});
$.ajax({
type: "POST",
url: "ajax_subsidy_get.php",
data: {
subsidy: val
},
cache: false,
success: function(html) {
$("#subsidy_percent").val(html);
}
});
});
$(document).on('click','.subsidy_get',function(){
var val = [];
$('.subsidy_get:checked').each(function(i) {
val[i] = $(this).val();
//alert(val[i]);
});
$.ajax({
type: "POST",
url: "ajax_subsidy_get.php",
data: {
subsidy: val
},
cache: false,
success: function(html) {
$("#subsidy_percent").val(html);
}
});
});
</script>
<?php
include_once '../include/DBConnect.php';
$subsidy=$_POST['subsidy'];
$linking_id=$_POST['linking_id'];
$check=FALSE;
if($subsidy!=1){
$query="Select Subsidy_ID as s,title,percent from subsidy where actived='1' and deleted='0' and subsidy_type='$subsidy'";
$result=$dbh->query($query);
$result->setFetchMode(PDO::FETCH_OBJ);
while($row=$result->fetch()){
$query1="Select subsidy_id from student_subsidy where actived='1' and deleted='0' and stu_subsidy_id='$linking_id'";
$result1=$dbh->query($query1);
$result1->setFetchMode(PDO::FETCH_OBJ);
while($row1=$result1->fetch()){
if($row1->subsidy_id==$row->s)
$check=TRUE;
}
if($check==TRUE){
echo '
<input type="checkbox" name="subsidy_get[]" class="subsidy_get" value="'.$row->s.'"checked/>
'.$row->title.'-'.$row->percent.'%
<br>';
}
else{
echo '
<input type="checkbox" name="subsidy_get[]" class="subsidy_get" value="'.$row->s.'"/>
'.$row->title.'-'.$row->percent.'%
<br>';
}
$check=FALSE;
}
}
|