class

	public function insert_pegawai(){
		$nip  	= htmlentities($_POST['nip']);
		$nama 	= htmlentities($_POST['nmPeg']);
		$gol  	= htmlentities($_POST['golPEg']);
		$gender = htmlentities($_POST['jkPeg']);

		$cekNip = $this->db->prepare("SELECT * FROM ssh_pegawai WHERE peg_nip = ?");
		$cekNip->execute(array($nip));
		if($cekNip->rowCount() > 0){
			/*echo "<script> alert('NIP Sudah Digunakan'); location.href='pegawai.php' </script>";
			exit(); */
			//echo json_encode($cekNip, JSON_PRETTY_PRINT);
            echo json_encode(array(
                "pesan" => "<font color='red'><i class='fa fa-warning'></i> NIP ini sudah digunakan.!</font>
            "));
		}else{
			$sql = "INSERT INTO ssh_pegawai SET peg_nip = ?, peg_nama = ?, peg_gol = ?, peg_gender = ?";
			$stmt = $this->db->prepare($sql);
			$stmt->bindParam(1, $nip);
			$stmt->bindParam(2, $nama);
			$stmt->bindParam(3, $gol);
			$stmt->bindParam(4, $gender);
			$stmt->execute();
			/*ambil AUTO INCREMENT terakhir dari tabel ssh_pegawai*/
			$query = "SELECT LAST_INSERT_ID()";
			$stmt1 = $this->db->prepare($query);
			$stmt1->execute();
			while($r = $stmt1->fetch(PDO::FETCH_LAZY)){
				$ID = $r[0];
			}
			/*simpan ke tabel ssh_login*/
			$statusLog = htmlentities($_POST['status']);
			$pass_u    = htmlentities($_POST['logPass']);
			$query_login = "INSERT INTO ssh_login SET login_peg = ?, login_user = ?, login_status = ?, login_pass = ?";
			$stmt2 = $this->db->prepare($query_login);
			$stmt2->bindParam(1, $ID);
			$stmt2->bindParam(2, $nip);
			$stmt2->bindParam(3, $statusLog);
			$stmt2->bindParam(4, password_hash($pass_u, PASSWORD_DEFAULT));
			$stmt2->execute();
			/*echo "<script> alert('Data Berhasil Disimpan'); location.href='pegawai.php' </script>";
			exit();*/
            echo json_encode(array(
                "pesan" => "<font color='green'><i class='fa fa-check'></i> Data berhasil disimpan.!</font>
            "));
		} /*End If*/
	}