/
sdm_slave_save_setup_plafond.php
executable file
·75 lines (73 loc) · 2.64 KB
/
sdm_slave_save_setup_plafond.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
<?php
require_once('master_validation.php');
require_once('config/connection.php');
include_once('lib/zLib.php');
$regional=$_POST['regional'];
$kodegolongan=$_POST['kodegolongan'];
$rupiah=$_POST['rupiah'];
$satuan=$_POST['satuan'];
$method=$_POST['method'];
$jenisbiaya=$_POST['jenisbiaya'];
switch($method)
{
case 'update':
$str="update ".$dbname.".sdm_pengobatanplafond set rupiah='".$rupiah."', satuan='".$satuan."'
where regional='".$regional."' and kodegolongan='".$kodegolongan."'
and kodejenisbiaya='".$jenisbiaya."'";
if(mysql_query($str))
{}
else
{echo " Gagal,".addslashes(mysql_error($conn));}
break;
case 'insert':
$sCount="select * from ".$dbname.".sdm_pengobatanplafond where regional='".$regional."' and kodegolongan='".$kodegolongan."' and kodejenisbiaya='".$jenisbiaya."'";
// echo mysql_num_rows(mysql_query($sCount));
if(mysql_num_rows(mysql_query($sCount)) >= 1){
echo " Gagal, Item ini sudah pernah terdaftar sebelumnya.";
exit(0);
}else{
$str="insert into ".$dbname.".sdm_pengobatanplafond (regional,kodegolongan,rupiah,kodejenisbiaya,satuan)
values('".$regional."','".$kodegolongan."','".$rupiah."','".$jenisbiaya."','".$satuan."')";
if(mysql_query($str))
{}
else
{echo " Gagal,".addslashes(mysql_error($conn));}
}
break;
case 'delete':
$str="delete from ".$dbname.".sdm_pengobatanplafond
where kodegolongan='".$kodegolongan."' and kodejenisbiaya='".$jenisbiaya."'";
if(mysql_query($str))
{}
else
{echo " Gagal,".addslashes(mysql_error($conn));}
break;
default:
break;
}
$str1="select * from ".$dbname.".sdm_pengobatanplafond order by regional asc, kodegolongan asc, kodejenisbiaya asc";
$vGolognan=makeOption($dbname,'sdm_5golongan','kodegolongan,namagolongan');
$vJenisBiaya=makeOption($dbname,'sdm_5jenisbiayapengobatan','kode,nama');
if($res1=mysql_query($str1))
{
while($bar1=mysql_fetch_object($res1))
{
if($bar1->satuan==1){
$hVal='per tahun';
}else if($bar1->satuan==2){
$hVal='per hari';
}else if($bar1->satuan==3){
$hVal='1 tahun sekali';
}else{
$hVal='3 tahun sekali';
}
echo"<tr class=rowcontent>
<td>".$bar1->regional."</td>
<td>".$vGolognan[$bar1->kodegolongan]." - ".$bar1->kodegolongan."</td>
<td>".$vJenisBiaya[$bar1->kodejenisbiaya]."</td>
<td>".$hVal."</td>
<td align=right>".number_format($bar1->rupiah,2)."</td>
<td><img src=images/application/application_edit.png class=resicon caption='Edit' onclick=\"fillField('".$bar1->regional."','".$bar1->kodegolongan."','".$bar1->rupiah."','".$bar1->kodejenisbiaya."','".$bar1->satuan."');\"></td></tr>";
}
}
?>