示例#1
0
function AutoID()
{
    global $db;
    $querycount = "SELECT count(id_servis) as LastID FROM servis";
    $result = $db->query($querycount) or die($db->error());
    $row = $result->fetch_assoc();
    return $row['LastID'];
}
function IdKredit($num)
{
    $num = $num + 1;
    switch (strlen($num)) {
        case 1:
            $NoTrans = "S0000" . $num;
            break;
        case 2:
            $NoTrans = "S000" . $num;
            break;
        case 3:
            $NoTrans = "S00" . $num;
            break;
        case 4:
            $NoTrans = "S0" . $num;
            break;
        default:
            $NoTrans = $num;
    }
    return $NoTrans;
}
echo IdKredit(autoID());
示例#2
0
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <!-- CSS  -->
    <script src="js/sweetalert-dev.js"></script>
    <link rel="stylesheet" href="css/sweetalert.css">
    <link href="css/custom.css" type="text/css" rel="stylesheet">
</head>
<body>
    <?php 
require_once "connect.php";
session_start();
require_once "functionsparepart.php";
$id_sparepart = IdKredit(autoID());
$nama_sparepart = $_POST['nama_sparepart'];
$harga_sparepart = $_POST['harga_sparepart'];
$query = "INSERT INTO sparepart VALUES ('{$id_sparepart}','{$nama_sparepart}','{$harga_sparepart}')";
if (mysqli_query($db, $query)) {
    echo "<script>\n                    swal({\n                        title: \"Sukses!\",\n                        text: \"Data Servis Berhasil Ditambah\",\n                        type: \"success\"\n                    },\n                    function () {\n                        window.location.href = 'menuservis.php';\n                    });\n                    </script>";
} else {
    echo "<script>\n                    swal({\n                        title: \"Gagal!\",\n                        text: \"Data Servis Gagal ditambah\",\n                        type: \"error\"\n                    },\n                    function () {\n                        window.location.href = 'menuservis.php';\n                    });\n                    </script>";
}
mysqli_close($db);
?>
</body>
</html>
示例#3
0
 <?php 
require_once "connect.php";
require_once "functionproduct.php";
$id_kredit = IdKredit(autoID());
$id_product = $_POST['id_product'];
$uang_muka = $_POST['uang_muka'];
$tahun1 = $_POST['tahun1'];
$tahun2 = $_POST['tahun2'];
$tahun3 = $_POST['tahun2'];
$query = "INSERT INTO kredit VALUES ('{$id_kredit}','{$id_product}','{$uang_muka}','{$tahun1}','{$tahun2}','{$tahun3}')";
if (mysqli_query($db, $query)) {
    echo "<script>\n        alert('Berhasil ditambah');\n        window.location.href='menukredit.php';\n        </script>";
    exit;
} else {
    echo "<script>\n        alert('Product sudah ada');\n        window.location.href='index.php';\n        </script>";
}
mysqli_close($db);
示例#4
0
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <!-- CSS  -->
    <script src="js/sweetalert-dev.js"></script>
    <link rel="stylesheet" href="css/sweetalert.css">
    <link href="css/custom.css" type="text/css" rel="stylesheet">
</head>
<body>
    <?php 
require_once "connect.php";
session_start();
require_once "functionservis.php";
$id_servis = IdKredit(autoID());
$jenis_servis = $_POST['jenis_servis'];
$harga_servis = $_POST['harga_servis'];
$query = "INSERT INTO servis VALUES ('{$id_servis}','{$jenis_servis}','{$harga_servis}')";
if (mysqli_query($db, $query)) {
    echo "<script>\n                    swal({\n                        title: \"Sukses!\",\n                        text: \"Data Servis Berhasil Ditambah\",\n                        type: \"success\"\n                    },\n                    function () {\n                        window.location.href = 'menuservis.php';\n                    });\n                    </script>";
} else {
    echo "<script>\n                    swal({\n                        title: \"Gagal!\",\n                        text: \"Data Servis Gagal ditambah\",\n                        type: \"error\"\n                    },\n                    function () {\n                        window.location.href = 'menuservis.php';\n                    });\n                    </script>";
}
mysqli_close($db);
?>
</body>
</html>
示例#5
0
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <!-- CSS  -->
    <script src="js/sweetalert-dev.js"></script>
    <link rel="stylesheet" href="css/sweetalert.css">
    <link href="css/custom.css" type="text/css" rel="stylesheet">
</head>
<body>
    
<?php 
session_start();
require_once "connect.php";
require_once "functionbook.php";
$id_book = IdKredit(autoID());
$_SESSION['id_book'] = $id_book;
$nopol = $_POST['nopol'];
$jam = $_POST['jam'];
$query = "INSERT INTO booking (id_book,tanggal,ktp,nopol,jam,status) VALUES ('{$id_book}',now(),'" . $_SESSION['ktp'] . "','{$nopol}','{$jam}','pending')";
if (mysqli_query($db, $query)) {
    echo "<script>\n            swal({\n                title: \"Sukses!\",\n                text: \"Booking sukses\",\n                type: \"success\"\n                },\n            function () {\n            window.location.href = 'home.php';\n                });\n                </script>";
    exit;
} else {
    echo "<script> \n            swal({\n                title: \"Gagal!\",\n                text: \"Booking gagal\",\n                type: \"error\"\n                },\n                function () {\n                window.location.href = 'home.php';\n                });\n                    </script>";
}
mysqli_close($db);
?>
    </body>
</html>