/
pabrik_slave_save_pbrik_jam.php
executable file
·121 lines (115 loc) · 4.51 KB
/
pabrik_slave_save_pbrik_jam.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
114
115
116
117
118
119
120
121
<?php
require_once('master_validation.php');
require_once('config/connection.php');
include('lib/nangkoelib.php');
$koderorg=$_POST['koderorg'];
$kapasitasolah=$_POST['kapasitasolah'];
$berlakusampai=tanggalsystemd($_POST['berlakusampai']);
$jammulai=tanggalsystemd($_POST['jam_mulai']);
$jamselesai=tanggalsystemd($_POST['jam_selesai']);
$kapasitaslori = $_POST['kapasitaslori'];
$method=$_POST['method'];
switch($method){
case 'delete':
$strx="delete from ".$dbname.".pabrik_5jampengolahan where koderorg='".$koderorg."' ";
//echo $strx; exit();
break;
case 'update':
//print_r($_POST);
$strx="update ".$dbname.".pabrik_5jampengolahan set kapasitasolah='".$kapasitasolah."',jammulai='".$jammulai."',jamselesai='".$jamselesai."',berlakusampai='".$berlakusampai."',kapasitaslori=".$kapasitaslori." where koderorg='".$koderorg."'";
//echo "warning:".$strx; exit();
if(mysql_query($strx))
echo"";
else
echo " Gagal,".(mysql_error($conn));
break;
case 'insert':
$sql="select from ".$dbname.".pabrik_5jampengolahan where kodeorg='".$koderorg."'";
$query=mysql_query($sql) or die(mysql_error());
$res=mysql_fetch_row($query);
if($res<1)
{
$strx="insert into ".$dbname.".pabrik_5jampengolahan(
koderorg,kapasitasolah,jammulai,jamselesai,berlakusampai,kapasitaslori)
values('".$koderorg."','".$kapasitasolah."','".$jammulai."','".$jamselesai."','".$berlakusampai."',".$kapasitaslori.")";
if(mysql_query($strx)) //echo $strx; exit();
echo"";
else
echo " Gagal,".(mysql_error($conn));
}
else
{
echo"warning:This Factory Already Input";
exit();
}
break;
case'load_data':
//echo "warning:Masuk";
$str="select * from ".$dbname.".pabrik_5jampengolahan order by koderorg desc"; //echo "warning:".$str;exit();
if($res=mysql_query($str))
{
while($bar=mysql_fetch_object($res))
{
$noakun=$bar->noakun;
$spr="select * from ".$dbname.".organisasi where kodeorganisasi='".$bar->koderorg."'";
$rep=mysql_query($spr) or die(mysql_error($conn));
$bas=mysql_fetch_object($rep);
$no+=1;
//echo $minute_selesai; exit();
echo"<tr class=rowcontent id='tr_".$no."'>
<td>".$no."</td>
<td id='nmorg_".$no."'>".$bas->namaorganisasi."</td>
<td id='kpsits_".$no."'>".$bar->kapasitasolah."</td>
<td id='strt_".$no."'>".tanggalnormald($bar->jammulai)."</td>
<td id='end_".$no."'>".tanggalnormald($bar->jamselesai)."</td>
<td id='tglex_".$no."'>".tanggalnormald($bar->berlakusampai)."</td>
<td id='kplori_".$no."'>".$bar->kapasitaslori."</td>
<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('".$bar->koderorg."','".$bar->kapasitasolah."','".tanggalnormald($bar->jammulai)."','".tanggalnormald($bar->jamselesai)."','".tanggalnormald($bar->berlakusampai)."','".$bar->kapasitaslori."');\"></td>
<td><img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delJampeng('".$bar->koderorg."');\"></td>
</tr>";
}
}
else
{
echo " Gagal,".(mysql_error($conn));
}
break;
default:
break;
}
/* if(mysql_query($strx))
{}
else
{
echo " Gagal,".addslashes(mysql_error($conn));
}
$str="select * from ".$dbname.".pabrik_5jampengolahan order by koderorg desc";
if($res=mysql_query($str))
{
while($bar=mysql_fetch_object($res))
{
$noakun=$bar->noakun;
$spr="select * from ".$dbname.".organisasi where kodeorganisasi='".$bar->koderorg."'";
$rep=mysql_query($spr) or die(mysql_error($conn));
$bas=mysql_fetch_object($rep);
$no+=1;
//$jam_mulai=substr($bar->jammulai,0,2);
echo"<tr class=rowcontent>
<td>".$no."</td>
<td>".$bas->namaorganisasi."</td>
<td>".$bar->kapasitasolah."</td>
<td>".tanggalnormald($bar->jammulai)."</td>
<td>".tanggalnormald($bar->jamselesai)."</td>
<td>".tanggalnormald($bar->berlakusampai)."</td>
<td>".$bar->kapasitaslori."</td>
<td><img src=images/application/application_edit.png class=resicon title='Edit' onclick=\"fillField('".$bar->koderorg."','".$bar->kapasitasolah."','".tanggalnormald($bar->jammulai)."','".tanggalnormald($bar->jamselesai)."','".tanggalnormald($bar->berlakusampai)."','".$bar->kapasitaslori."');\"></td>
<td><img src=images/application/application_delete.png class=resicon title='Delete' onclick=\"delJampeng('".$bar->koderorg."');\"></td>
</tr>";
}
}
else
{
echo " Gagal,".(mysql_error($conn));
}
*/
?>