e-peralatan/ubah.php at master · ashrulpuo/e-peralatan · GitHub

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
<?php
	session_start();
	include 'connection.php';

	if(isset($_POST['submit']))
	{
		$test = "SELECT * FROM permohonan WHERE id_permohonan = '".$_SESSION['id_permohonan']."'";
		$test=mysql_query($test);

		while($lists=mysql_fetch_array($test)) {
			$peralatan1 = $lists['peralatan1'];
			$peralatan2 = $lists['peralatan2'];
			$peralatan3 = $lists['peralatan3'];
		}

        $string1 = preg_replace('/\s+/', '', $peralatan1);
        $string2 = preg_replace('/\s+/', '', $peralatan2);
        $string3 = preg_replace('/\s+/', '', $peralatan3);

        //print_r($string1);
       	//echo '<script type="text/javascript">alert("'.$string1.'");</script>';

		//peralatan1 change
		if ($peralatan1 == 'Tiada') {
			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan1']."' ";
				mysql_query($update)or die(mysql_error());
		} else if ($peralatan1 != 'Tiada') {
		 	$update = "UPDATE peralatan SET peralatan_status=0 WHERE no_aset = '".$string1."' ";
			mysql_query($update)or die(mysql_error());

			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan1']."' ";
			mysql_query($update)or die(mysql_error());
		} else {

		}

		//peralatan2 change
		if ($peralatan2 == 'Tiada') {
			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan2']."' ";
				mysql_query($update)or die(mysql_error());
		} else if ($peralatan2 != 'Tiada') {
		 	$update = "UPDATE peralatan SET peralatan_status=0 WHERE no_aset = '".$string2."' ";
			mysql_query($update)or die(mysql_error());

			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan2']."' ";
			mysql_query($update)or die(mysql_error());
		} else {

		}


		//peralatan3 change
		if ($peralatan3 == 'Tiada') {
			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan3']."' ";
				mysql_query($update)or die(mysql_error());
		} else if ($_POST['peralatan3'] != $peralatan3){
		 	$update = "UPDATE peralatan SET peralatan_status=0 WHERE no_aset = '".$string3."' ";
			mysql_query($update)or die(mysql_error());

			$update = "UPDATE peralatan SET peralatan_status=1 WHERE no_aset = '".$_POST['peralatan3']."' ";
			mysql_query($update)or die(mysql_error());
		} else {

		}


		$update = "UPDATE permohonan SET peralatan1='".$_POST['peralatan1']."', peralatan2='".$_POST['peralatan2']."', peralatan3='".$_POST['peralatan3']."' WHERE id_permohonan='".$_SESSION['id_permohonan']."'";
		mysql_query($update)or die(mysql_error());


		$semua = "SELECT * FROM pulang WHERE id_permohonan = '".$_SESSION['id_permohonan']."' and status=0";
		$peralatan=mysql_query($semua);
			$counter = 1;
			while ($items=mysql_fetch_array($peralatan)) {
				$counter2 = $counter++;

				if ($counter2 == 1) {
		          $update = "UPDATE pulang SET peralatan='".$_POST['peralatan1']."' WHERE id_permohonan='".$_SESSION['id_permohonan']."' and id_pemulang='".$items['id_pemulang']."'";
		          mysql_query($update)or die(mysql_error());
		        }

		        if ($counter2 == 2) {
		          $update = "UPDATE pulang SET peralatan='".$_POST['peralatan2']."' WHERE id_permohonan='".$_SESSION['id_permohonan']."' and id_pemulang='".$items['id_pemulang']."'";
		          mysql_query($update)or die(mysql_error());
		        }

		        if ($counter2 == 3) {
		          $update = "UPDATE pulang SET peralatan='".$_POST['peralatan3']."' WHERE id_permohonan='".$_SESSION['id_permohonan']."' and id_pemulang='".$items['id_pemulang']."'";
		          mysql_query($update)or die(mysql_error());
		        }


	    }


		header('Location: perincian.php?permohonanID='.$_SESSION['id_permohonan']);
	}
?>