memberpage.php

<?php require('includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); exit(); }

$editmode = false;
$restricted = false;
$dialogContent = "";
$changessaved = false;
if(isset($_POST['submit'])) {
    if (isset($_POST['hwtitle']) && isset($_POST['hwdetails']) && isset($_POST['hwdonedate'])) {
        $name = $_POST['hwtitle'];
        $details = $_POST['hwdetails'];
        $donedate = $_POST['hwdonedate'];
        $owner = $_SESSION['username'];
        $stmt = $db->prepare('INSERT INTO homeworks (name,owner,details,donedate,done) VALUES (:name,:owner, :details, :donedate, :done)');
        $stmt->execute(array(

            ':name' => $name,
            ':owner' => $owner,
            ':details' => $details,
            ':donedate' => $donedate,
            ':done' => '0'
        ));
        $id = $db->lastInsertId('homeworkID');
        header('Location: memberpage.php?savedsuccess=true');
    }
} else if (isset($_GET['edit'])) {
    $stmt = $db->prepare('SELECT * FROM homeworks WHERE homeworkID = :id');
    $stmt->execute(array(':id' => $_GET['edit']));
    $row2edit = $stmt->fetch(PDO::FETCH_ASSOC);


    if ($row2edit['owner'] == $_SESSION['username']) {
        $editmode = true;
        $hwid = $_GET['edit'];
        $name = $row2edit['name'];
        $details = $row2edit['details'];
        $donedate = $row2edit['donedate'];
        $done= $row2edit['done'];
        $checked = "";
        if (!isset($done)) {
            $checked = "checked";
        }
        $dialogContent = "      <div class=\"modal-header\">
                <h4 class=\"modal-title\" id=\"editModalLabel\">Muokkaa Läksy</h4>
            </div>
            <div class=\"modal-body\">
                <form action='https://developerfromjokela.com/homework/web/edithw.php' method=\"post\">
                    <div class=\"form-group\">
                        <label for=\"hwtitle\">Läksyn otsikko</label>
                        <input type=\"text\" class=\"form-control\" name=\"hwtitle\" id=\"hwtitle\" placeholder=\"Biologian läksy...\" value=\"$name\"/>
                    </div>

                    <div class=\"form-group\">
                        <label for=\"hwdetails\">Läksyn tiedot</label>
                        <input type=\"text\" class=\"form-control\" name=\"hwdetails\" id=\"hwdetails\" placeholder=\"Sivu 12 tehtävä 1 luettavaksi...\" value=\"$details\"/>
                    </div>

                    <div class=\"form-group\">
                        <label class=\"label-control\">Palautuspäivä</label>
                        <input type=\"date\" name=\"hwdonedate\" value=\"$donedate\"/>
                    </div>
                    <div style='visibility: hidden;'>
                    <input type='text' name='hwid' value='$hwid'/>
                    </div>


                       <label class=\"mdl-checkbox mdl-js-checkbox mdl-js-ripple-effect\" for=\"checkbox-1\">
                          <input type=\"checkbox\" id=\"checkbox-1\" name=\"done\" value=\"1\" class=\"mdl-checkbox__input\" $checked />
                           <span class=\"mdl-checkbox__label\">Tehty</span>
                        </label>


                    <input type=\"submit\" name='submit' class=\"btn btn-primary\" value='Tallenna'/>
                    <a href='memberpage.php' class='btn btn-primary'>Takaisin</a>
                    </form>
            </div>";
    } else {
        $restricted = true;
        $dialogContent = "<div class=\"modal-header\">
                <h3 class=\"modal-title\" id=\"editModalLabel\">Virhe!</h3>
            </div>
              <div class=\"modal-body\">

              <h1 class=\"modal-title\"> Sinulla ei ole oikeutta muokata henkilön ".$row2edit['owner']." läksyä! </h1>
              <a href='memberpage.php' class='btn btn-primary'>Takaisin</a>
              </div>";

    }


} else if (isset($_GET['restricted'])) {
    $dialogContent = "<div class=\"modal-header\">
                <h3 class=\"modal-title\" id=\"editModalLabel\">Virhe!</h3>
            </div>
              <div class=\"modal-body\">

              <h1 class=\"modal-title\"> Sinulla ei ole oikeutta muokata henkilön " . $_GET['restricted'] . " läksyjä! </h1>
              <button type='button' data-dismiss=\"modal\" class='btn btn-primary'>Sulje</button>
              </div>";
}

$stmt = $db->prepare('SELECT * FROM homeworks WHERE owner = :username');
$stmt->execute(array(':username' => $_SESSION['username']));



//include header template
include('layout/header2.php');


?>
<div class="demo-layout mdl-layout mdl-js-layout mdl-layout--fixed-drawer mdl-layout--fixed-header">
    <header class="demo-header mdl-layout__header mdl-color--grey-100 mdl-color-text--grey-600">
        <div class="mdl-layout__header-row">
            <span class="mdl-layout-title"><?php echo htmlspecialchars($_SESSION['name'], ENT_QUOTES); ?> - Läksyvihko</span>
            <div class="mdl-layout-spacer"></div>
            <button class="mdl-button mdl-js-button mdl-js-ripple-effect mdl-button--icon" id="hdrbtn">
                <i class="material-icons">more_vert</i>
            </button>
            <ul class="mdl-menu mdl-js-menu mdl-js-ripple-effect mdl-menu--bottom-right" for="hdrbtn">
                <li class="mdl-menu__item">Tietoja Läksyvihosta</li>
            </ul>
        </div>
    </header>
    <div class="demo-drawer mdl-layout__drawer mdl-color--blue-grey-900 mdl-color-text--blue-grey-50">
        <header class="demo-drawer-header">
            <img src="images/user.jpg" class="demo-avatar">
            <div class="demo-avatar-dropdown">
                <span style="text-overflow: ellipsis; white-space: nowrap;"><?php $out = strlen(htmlspecialchars($_SESSION['email'], ENT_QUOTES)) > 21 ? substr(htmlspecialchars($_SESSION['email'], ENT_QUOTES),0,21)."..." : htmlspecialchars($_SESSION['email'], ENT_QUOTES); echo $out ?></span>
                <br>
                <div class="mdl-layout-spacer"></div>
                <button id="accbtn" class="mdl-button mdl-js-button mdl-js-ripple-effect mdl-button--icon">
                    <i class="material-icons" role="presentation">arrow_drop_down</i>
                    <span class="visuallyhidden">Tilit</span>
                </button>
                <ul class="mdl-menu mdl-menu--bottom-right mdl-js-menu mdl-js-ripple-effect" for="accbtn">
                    <li class="mdl-menu__item"><?php $out = strlen(htmlspecialchars($_SESSION['username'], ENT_QUOTES)) > 21 ? substr(htmlspecialchars($_SESSION['username'], ENT_QUOTES),0,21)."..." : htmlspecialchars($_SESSION['username'], ENT_QUOTES); echo $out  ?></li>
                    <a class="mdl-menu__item" href="logout.php"><i class="material-icons">exit_to_app</i>Kirjaudu Ulos</a>
                </ul>
            </div>
        </header>
        <nav class="demo-navigation mdl-navigation mdl-color--blue-grey-800">
            <a class="mdl-navigation__link" href=""><i class="mdl-color-text--blue-grey-400 material-icons" role="presentation">home</i>Kotisivu</a>
            <a class="mdl-navigation__link" href=""><i class="mdl-color-text--blue-grey-400 material-icons" role="presentation">people</i>Profiilitiedot</a>
            <div class="mdl-layout-spacer"></div>
        </nav>
    </div>
    <main class="mdl-layout__content mdl-color--grey-100">
        <div class="mdl-grid demo-content">

            <div class="demo-options mdl-card mdl-color--deep-purple-500 mdl-shadow--2dp mdl-cell mdl-cell--4-col mdl-cell--3-col-tablet mdl-cell--12-col-desktop">
                <div class="mdl-card__supporting-text mdl-color-text--blue-grey-50">
                    <h3>Läksyt</h3>

                    <style>
                        .demo-list-two {
                            width: auto;
                        }
                    </style>

                    <ul class="demo-list-two mdl-list">


                    <?php
                    if ($stmt->rowCount() > 0) {
                        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {


                            $name = $row['name'];
                            $details = $row['details'];
                            $done = $row['done'];
                            $hwid = $row['homeworkID'];
                            $donedate = date_create($row['donedate']);
                            $icon = "done_outline";
                            if (isset($done)) {
                                $icon = "done_outline";
                            } else {
                                $icon = "done";
                            }
                          echo('                      <li class="mdl-list__item mdl-list__item--two-line">
    <span class="mdl-list__item-primary-content">
      <i class="material-icons mdl-list__item-avatar">book</i>
      <span style="color: white;">'.$name.'</span>
      <span class="mdl-list__item-sub-title" style="color: white;">'.$details.'</span>
      <span style="color: white;"><i class="material-icons">access_alarm</i>'.date_format($donedate, 'd.m.Y').'</span>


    </span>
                            <span class="mdl-list__item-secondary-content">
      <a class="mdl-list__item-secondary-action" href="#"><i class="material-icons">'.$icon.'</i></a>
      <a class="mdl-list__item-secondary-action" href="memberpage.php?edit='.$hwid.'"><i class="material-icons">edit</i></a>
    </span> </li>');
                        }
                    } else {
                        echo'<script>
(function() {
    var snackbarContainer = document.querySelector(\'#saved_snackbar\');
    var handler = function(event) {
     }
         var data = {
      message: \'Ei läksyjä!\',
      timeout: 2000,
      actionHandler: handler,
    };
    snackbarContainer.MaterialSnackbar.showSnackbar(data);

}());


</script>';
                        echo('                    <li class="mdl-list__item mdl-list__item--two-line">
    <span class="mdl-list__item-primary-content" style="color: white;">
      <i class="material-icons mdl-list__item-avatar">assignment_turned_in</i>
      <span style="color: white;">Ei läksyjä!</span>
    </span>

                        </li>');
                    }
                    ?>

                </div>
                <div class="mdl-card__actions mdl-card--border">
                    <button type="button" data-toggle="modal" data-target="#exampleModal" class="mdl-button mdl-js-button mdl-js-ripple-effect mdl-color-text--blue-grey-50">
                        Lisää läksy
                    </button>
                </div>

            </div>

        </div>
        <div id="saved_snackbar" class="mdl-js-snackbar mdl-snackbar">
            <div class="mdl-snackbar__text"></div>
            <button class="mdl-snackbar__action" type="button"></button>
        </div>
</div>
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h4 class="modal-title" id="exampleModalLabel">Lisää Läksy</h4>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form action="" method="post" id="">
                    <div class="form-group">
                        <label for="hwtitle">Läksyn otsikko</label>
                        <input type="text" class="form-control" name="hwtitle" id="hwtitle" placeholder="Biologian läksy..."/>
                    </div>

                    <div class="form-group">
                            <label for="hwdetails">Läksyn tiedot</label>
                            <input type="text" class="form-control" name="hwdetails" id="hwdetails" placeholder="Sivu 12 tehtävä 1 luettavaksi..."/>
                        </div>

                    <div class="form-group">
                        <label class="label-control">Palautuspäivä</label>
                        <input type="date" name="hwdonedate"/>
                    </div>


                    <input type="submit" name="submit" class="btn btn-primary" value="Tallenna"/>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Peruuta</button>

            </div>

        </div>
        </div>
    </div>

<div class="modal fade" id="editModal" tabindex="-1" role="dialog" aria-labelledby="editModal" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <?php
            if ($restricted === true) {
                echo ($dialogContent);
            } else if ($editmode === true) {
                echo ($dialogContent);
            }
            ?>

        </div>
    </div>
</div>

<?php
if (isset($_GET['savedsuccess'])) {
    echo "<script>
$(document).ready(function(){
    console.log('Jee');
  'use strict';
  var snackbarContainer = document.querySelector('#saved_snackbar');
    var data = {
      message: 'Tallennettu Onnistuneesti!',
      timeout: 2000,
      actionHandler: handler
    };
    snackbarContainer.MaterialSnackbar.showSnackbar(data);}
</script>";

} else if (isset($_GET['restricted'])) {
$myCookie = $_COOKIE[$_SESSION['USERNAME']];
    echo "<script type='text/javascript'>
$(document).ready(function(){
$('#editModal').modal('show');
});
</script>";
} else if ($editmode === true) {echo "<script type='text/javascript'>
$(document).ready(function(){
$('#editModal').modal('show');
});
</script>";

} else if ($restricted === true) {
    echo "<script type='text/javascript'>
$(document).ready(function(){
$('#editModal').modal('show');
});</script>";
}

//include header template
require('layout/footer2.php');
?>