<?php require_once('header.php'); ?>

<?php

$error_message = '';
$success_message = '';

/*
|--------------------------------------------------------------------------
| Check ID
|--------------------------------------------------------------------------
*/

if (!isset($_REQUEST['id']) || empty($_REQUEST['id'])) {

    header('location: logout.php');
    exit;

}

$id = (int) $_REQUEST['id'];


/*
|--------------------------------------------------------------------------
| Get Certificate
|--------------------------------------------------------------------------
*/

$statement = $pdo->prepare(
    "SELECT * FROM tbl_certificate WHERE id = ?"
);

$statement->execute([$id]);

$row = $statement->fetch(PDO::FETCH_ASSOC);


if (!$row) {

    header('location: logout.php');
    exit;

}


$caption = $row['caption'];
$photo   = $row['photo'];


/*
|--------------------------------------------------------------------------
| Handle Form Submission
|--------------------------------------------------------------------------
*/

if (isset($_POST['form1'])) {


    /*
    |--------------------------------------------------------------------------
    | Get Caption
    |--------------------------------------------------------------------------
    */

    $caption = trim($_POST['page_name'] ?? '');


    /*
    |--------------------------------------------------------------------------
    | Update Caption
    |--------------------------------------------------------------------------
    */

    $statement = $pdo->prepare(
        "UPDATE tbl_certificate
         SET caption = ?
         WHERE id = ?"
    );

    $statement->execute([
        $caption,
        $id
    ]);


    /*
    |--------------------------------------------------------------------------
    | Check Uploaded File
    |--------------------------------------------------------------------------
    */

    if (
        isset($_FILES['photo']) &&
        $_FILES['photo']['error'] === UPLOAD_ERR_OK
    ) {


        $path = $_FILES['photo']['name'];

        $path_tmp = $_FILES['photo']['tmp_name'];


        /*
        |--------------------------------------------------------------------------
        | Get Extension
        |--------------------------------------------------------------------------
        */

        $ext = strtolower(
            pathinfo($path, PATHINFO_EXTENSION)
        );


        /*
        |--------------------------------------------------------------------------
        | Allowed File Types
        |--------------------------------------------------------------------------
        */

        $allowed_ext = [
            'jpg',
            'jpeg',
            'png',
            'gif',
            'webp',
            'pdf'
        ];


        /*
        |--------------------------------------------------------------------------
        | Validate Extension
        |--------------------------------------------------------------------------
        */

        if (!in_array($ext, $allowed_ext, true)) {


            $error_message .=
                'Only JPG, JPEG, PNG, WEBP, GIF and PDF files are allowed.<br>';


        } else {


            /*
            |--------------------------------------------------------------------------
            | Generate New File Name
            |--------------------------------------------------------------------------
            */

            $final_name =
                'photo-' . $id . '-' . time() . '.' . $ext;


            /*
            |--------------------------------------------------------------------------
            | Upload Path
            |--------------------------------------------------------------------------
            */

            $upload_path =
                'img/certificate/' . $final_name;


            /*
            |--------------------------------------------------------------------------
            | Upload New File
            |--------------------------------------------------------------------------
            */

            if (move_uploaded_file($path_tmp, $upload_path)) {


                /*
                |--------------------------------------------------------------------------
                | Delete Previous File
                |--------------------------------------------------------------------------
                */

                if (
                    !empty($photo) &&
                    file_exists('img/certificate/' . $photo)
                ) {

                    unlink(
                        'img/certificate/' . $photo
                    );

                }


                /*
                |--------------------------------------------------------------------------
                | Update Photo
                |--------------------------------------------------------------------------
                */

                $statement = $pdo->prepare(
                    "UPDATE tbl_certificate
                     SET photo = ?
                     WHERE id = ?"
                );


                $statement->execute([
                    $final_name,
                    $id
                ]);


                /*
                |--------------------------------------------------------------------------
                | Update Current Photo
                |--------------------------------------------------------------------------
                */

                $photo = $final_name;


            } else {


                $error_message .=
                    'Failed to upload the file. Please check the upload folder.<br>';

            }

        }

    } elseif (
        isset($_FILES['photo']['error']) &&
        $_FILES['photo']['error'] !== UPLOAD_ERR_NO_FILE
    ) {


        $error_message .=
            'There was an error uploading the file.<br>';

    }


    /*
    |--------------------------------------------------------------------------
    | Success Message
    |--------------------------------------------------------------------------
    */

    if (empty($error_message)) {

        $success_message =
            'Certificate updated successfully.';

    }

}

?>


<section class="content-header">

    <div class="content-header-left">

        <h1>Edit Certificate</h1>

    </div>


    <div class="content-header-right">

        <a
            href="certificate.php"
            class="btn btn-primary btn-sm"
        >
            View All
        </a>

    </div>

</section>


<section class="content">

    <div class="row">

        <div class="col-md-12">


            <!-- ERROR -->

            <?php if (!empty($error_message)): ?>

                <div class="callout callout-danger">

                    <p>
                        <?php echo $error_message; ?>
                    </p>

                </div>

            <?php endif; ?>


            <!-- SUCCESS -->

            <?php if (!empty($success_message)): ?>

                <div class="callout callout-success">

                    <p>
                        <?php echo $success_message; ?>
                    </p>

                </div>

            <?php endif; ?>


            <!-- FORM -->

            <form
                class="form-horizontal"
                action=""
                method="post"
                enctype="multipart/form-data"
            >


                <!-- Form Identifier -->

                <input
                    type="hidden"
                    name="form1"
                    value="1"
                >


                <!-- ID -->

                <input
                    type="hidden"
                    name="id"
                    value="<?php echo $id; ?>"
                >


                <div class="box box-info">

                    <div class="box-body">


                        <!-- =================================================
                             CAPTION
                        ================================================== -->

                        <div class="form-group">

                            <label class="col-sm-2 control-label">

                                Certificate Caption

                            </label>


                            <div class="col-sm-4">

                                <input
                                    type="text"
                                    class="form-control"
                                    name="page_name"
                                    value="<?php echo htmlspecialchars(
                                        $caption,
                                        ENT_QUOTES,
                                        'UTF-8'
                                    ); ?>"
                                >

                            </div>

                        </div>


                        <!-- =================================================
                             EXISTING FILE
                        ================================================== -->

                        <div class="form-group">

                            <label class="col-sm-2 control-label">

                                Existing File

                            </label>


                            <div
                                class="col-sm-6"
                                style="padding-top:6px;"
                            >


                                <?php if (!empty($photo)): ?>


                                    <?php

                                    $extension = strtolower(
                                        pathinfo(
                                            $photo,
                                            PATHINFO_EXTENSION
                                        )
                                    );

                                    ?>


                                    <?php if ($extension === 'pdf'): ?>


                                        <!-- PDF -->

                                        <div
                                            style="
                                                width:300px;
                                                height:200px;
                                                background:#f5f5f5;
                                                border:1px solid #ddd;
                                                display:flex;
                                                align-items:center;
                                                justify-content:center;
                                                text-align:center;
                                            "
                                        >

                                            <div>


                                                <i
                                                    class="fa fa-file-pdf-o"
                                                    style="
                                                        font-size:60px;
                                                        color:#e3342f;
                                                    "
                                                ></i>


                                                <br>


                                                <a
                                                    href="img/certificate/<?php echo htmlspecialchars(
                                                        $photo,
                                                        ENT_QUOTES,
                                                        'UTF-8'
                                                    ); ?>"
                                                    target="_blank"
                                                    class="btn btn-primary btn-sm"
                                                    style="margin-top:10px;"
                                                >

                                                    View PDF

                                                </a>


                                            </div>

                                        </div>


                                    <?php else: ?>


                                        <!-- IMAGE -->

                                        <img
                                            src="img/certificate/<?php echo htmlspecialchars(
                                                $photo,
                                                ENT_QUOTES,
                                                'UTF-8'
                                            ); ?>"
                                            style="
                                                width:300px;
                                                height:300px;
                                                object-fit:contain;
                                                border:1px solid #ddd;
                                            "
                                        >


                                    <?php endif; ?>


                                <?php else: ?>


                                    <p>
                                        No file available.
                                    </p>


                                <?php endif; ?>


                            </div>

                        </div>


                        <!-- =================================================
                             UPLOAD NEW FILE
                        ================================================== -->

                        <div class="form-group">

                            <label class="col-sm-2 control-label">

                                Upload New Photo/PDF

                            </label>


                            <div
                                class="col-sm-4"
                                style="padding-top:6px;"
                            >


                                <input
                                    type="file"
                                    name="photo"
                                    accept=".jpg,.jpeg,.png,.gif,.webp,.pdf"
                                >


                                <br>


                                <small class="text-muted">

                                    Allowed: JPG, JPEG, PNG, GIF, WEBP and PDF

                                </small>


                            </div>

                        </div>


                        <!-- =================================================
                             SUBMIT
                        ================================================== -->

                        <div class="form-group">

                            <label class="col-sm-2 control-label"></label>


                            <div class="col-sm-6">

                                <button
                                    type="submit"
                                    class="btn btn-success"
                                >

                                    Submit

                                </button>

                            </div>

                        </div>


                    </div>

                </div>


            </form>


        </div>

    </div>

</section>


<?php require_once('footer.php'); ?>