simperpus/test.php at master · hectast/simperpus · 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
<?php
    include 'app/env.php';

    $kdklsf = "100";
    $nbk = "0001";

        $query = $mysqli->query("SELECT * FROM test WHERE kode_klasifikasi='$kdklsf' AND no_buku='$nbk'");

        if (mysqli_num_rows($query) > 0) {
            $no_buku = $nbk;
            echo $no_buku;
        } else {
            $query2 = $mysqli->query("SELECT * FROM test WHERE kode_klasifikasi='$kdklsf'");
            if (mysqli_num_rows($query2) == 0) {
                $cek_no_buku = $kdklsf."0";

                $urutan = (int) substr($cek_no_buku, 1, 3);
                $urutan++;

                $kode_klasifikasi = $kdklsf;
                $potong_kode = substr($kode_klasifikasi, 0, -2);

                $no_buku = $potong_kode . sprintf("%03s", $urutan);
                echo $no_buku;
            } else {
                $query3 = $mysqli->query("SELECT max(no_buku) AS kode_terbesar, kode_klasifikasi FROM test WHERE kode_klasifikasi='$kdklsf'");
                $row3 = $query3->fetch_assoc();

                $cek_no_buku = $row3['kode_terbesar'];

                $urutan = (int) substr($cek_no_buku, 1, 3);
                $urutan++;

                $kode_klasifikasi = $row3['kode_klasifikasi'];
                $potong_kode = substr($kode_klasifikasi, 0, -2);

                $no_buku = $potong_kode . sprintf("%03s", $urutan);
                echo $no_buku;
            }
        }
?>

<html>
    <head>
        <title>test</title>
        <style>
            .flex-between {
                display: flex;
                justify-content: space-between;
            }

            .ttd {
                text-align: center;
                width: 50%;
            }

            .head {
                margin-bottom: 6rem;
            }

            .nama {
                text-decoration: underline;
                font-weight: bold;
                margin-bottom: 0.5rem;
            }
        </style>
    </head>
    <body>
        <div class="flex-between">
            <div class="ttd">
                <p class="head"><b>Kepala Perpus SMP Negeri 1 Suwawa</b></p>
                <p class="nama">Wiwin S. Maksud, S.Pd</p>
                <span class="nip">NIP. 198001022007012027</span>
            </div>
            <div class="ttd">
                <p class="head"><b>Kepala SMP Negeri 1 Suwawa</b></p>
                <p class="nama">Pitria Deu, S.Pd, M.Si</p>
                <span class="nip">NIP. 197310261999032008</span>
            </div>
        </div>
    </body>
</html>