compro/submit-lowongan.php at master · itselaras/compro · 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
<?php
	session_start();
	include("administrator/includes/connection.php");
	include("administrator/includes/function.php");

	$action = $_POST["action"];

	switch ($action) {

		case 'display_status':
			if ($_POST['pelamar_id']!='') {
				$sqlSelect = "SELECT *,DATE_FORMAT(tanggal,'%d %M %Y') AS tanggal_apply FROM tb_rekrutmen WHERE id_pelamar = '$_SESSION[pelamarID]' AND id_lowongan = '$_POST[lowongan_id]'";
				$querySelect = mysql_query($sqlSelect);
				$countSelect = mysql_num_rows($querySelect);
				if ($countSelect<1) {
					?>
	                <a href="#" class="btn btn-lg btn-primary submit-apply reg-apply">Apply</a>
	                <div class="clearfix"></div>
					<?php
				}else{
					$resultSelect = mysql_fetch_array($querySelect);
					?>
					<div class="status">
						<div class="row">
							<div class="col-sm-3 col-xs-12 category"><b>Keterangan</b></div>
	                        <div class="col-sm-9 col-xs-12 value-category">SUDAH TERDAFTAR</div>
	                        <div class="col-sm-3 col-xs-12 category"><b>Tanggal Apply</b></div>
	                        <div class="col-sm-9 col-xs-12 value-category"><?php echo $resultSelect['tanggal_apply'] ?></div>
	                        <!-- <div class="col-sm-3 col-xs-12 category"><b>Status</b></div> -->
	                        <!-- <div class="col-sm-9 col-xs-12 value-category"><?php echo ($resultSelect['status']==0) ? 'PROSES SELEKSI' : 'DITOLAK' ; ?></div> -->
	                    </div>
					</div>
					<?php
				}
			}else{
				?>
                <a href="#" class="btn btn-lg btn-primary submit-apply dot-apply">Apply</a>
                <div class="clearfix"></div>
				<?php
			}
			break;

		case 'insert':

			$auth = authByID($_SESSION["loginID"]);

			if($auth == 0){
				$sqlSelect = "SELECT * FROM tb_rekrutmen WHERE id_pelamar = '$_SESSION[pelamarID]' AND id_lowongan = '$_POST[lowongan_id]'";
				$querySelect = mysql_query($sqlSelect);
				$countSelect = mysql_num_rows($querySelect);

				if ($countSelect<1) {
					$sqlInsert = "INSERT INTO tb_rekrutmen (id_lowongan, id_pelamar, tanggal)
					VALUES ('$_POST[lowongan_id]', '$_SESSION[pelamarID]', CURDATE())";
					if (mysql_query($sqlInsert)) {
						echo "success";
					}
				}else{
					echo "exist";
				}
			}
			break;

		default:
			# code...
			break;
	}
?>