<?php

$servername = "localhost";
$username = "erikdals_rs";
$password = "5{c!AXHGTF^P";
$dbname = "erikdals_rs";
//var_dump($_POST);
//echo '<br>';
//var_dump($_GET);
//echo '<br>';
//var_dump($_FILES);

if (isset($_POST['rapporter'])) {
    $rs_kundes_id = $_POST['rs_kundes_id'];
    $virksomheds_id = $_POST['virksomheds_id'];
    $rs_kundes_kategori_id = $_POST['rs_kundes_kategori_id'];
    $ansattes_id = $_POST['ansat_id'];
    $branches_id = $_POST['branches_id'];

    /* billedeuploader */
    if ($nummerplade == ['']) {
        $nummerplade = ['Ikke angivet'];
    } else {
        $nummerplade = $_POST['nummerplade'];
    }

    $rapport = $_POST['rapport'];
    $opgave_ids = $_POST['opgave_id'];

    $file = $_POST['file'];
    $file = array();

    try {
        $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// klargøre sql .
        $stmt = $conn->prepare(" INSERT INTO `RS_kunders_rapporter`(`nummerplade`, `rapport`, `ansattes_id`, `ansattes_kategori_id`, "
                . "`branche_id`, `rs_kundes_id`, `virksomheds_id`) "
                . "VALUES "
                . "( :nummerplade,:rapport,:ansattes_id,:ansattes_kategori_id,:branche_id,:rs_kundes_id,:virksomheds_id ) ");
        $stmt->bindParam(':nummerplade', $nummerplade);
        $stmt->bindParam(':rapport', $rapport);
        $stmt->bindParam(':ansattes_id', $ansattes_id, PDO::PARAM_INT);
        $stmt->bindParam(':ansattes_kategori_id', $rs_kundes_kategori_id, PDO::PARAM_INT);
        $stmt->bindParam(':branche_id', $branches_id, PDO::PARAM_INT);
        $stmt->bindParam(':rs_kundes_id', $rs_kundes_id, PDO::PARAM_INT);
        $stmt->bindParam(':virksomheds_id', $virksomheds_id);
        $stmt->execute();
        $id = $conn->lastInsertId();

        foreach ($opgave_ids as $opgave_id) {
            $stmt = $conn->prepare("INSERT INTO `RS_kunders_udfoerte_opgaver`( `opgavens_id`, `rapportens_id`)"
                    . " VALUES (:opgavens_id,:rapportens_id)");

            $stmt->bindParam(':opgavens_id', $opgave_id, PDO::PARAM_INT);
            $stmt->bindParam(':rapportens_id', $id, PDO::PARAM_INT);

            $stmt->execute();
        }

        foreach ($file as $files) {

            $files = $_FILES["file"]["name"];
            $stmt = $conn->prepare(" INSERT INTO `RS_kunders_rapport_billeder`(`img_url`, `rs_kunders_rapport_id`)"
                    . " VALUES "
                    . " (:img_url,:rs_kunders_rapport_id) ");

            $stmt->bindParam(':img_url', "../../uploads/$files");
            $stmt->bindParam(':rs_kunders_rapport_id', $id);
            $stmt->execute();

        }

        die('hey2');
        echo '<div class="alert alert-success">
              <strong><h3><center>Rapport oprettet</center></h3></strong>
              </div>';
    } catch (PDOException $e) {
        echo "<div class='alert alert-success'>
              <strong><h3><center> 000001 " . $e->getMessage() . "</center></h3></strong>
              </div>";
    }
    $conn = null;
}