Editing: adminhome.php
Kembali
<!DOCTYPE html> <html lang="en"> <?php include 'connect.php';?> <?php require_once('check_login.php');?> <?php include('head.php');?> <?php include('header.php');?> <?php include('sidebar.php');?> <?php //echo $_SESSION["email"]; date_default_timezone_set('Asia/Dili'); $current_date = date('Y-m-d');?> <!-- Main wrapper --> <div id="main-wrapper"> <!-- Page wrapper --> <div class="page-wrapper"> <!-- Bread crumb --> <div class="row page-titles"> <div class="col-md-5 align-self-center"> <h3 class="text-primary">Dashboard</h3> </div> <div class="col-md-7 align-self-center"> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li> <li class="breadcrumb-item active">Dashboard</li> </ol> </div> </div> <!-- End Bread crumb --> <!-- Container fluid --> <div class="container-fluid"> <!-- Start Page Content --> <div class="row"> <div class="col-md-3"> <div class="card p-30"> <div class="media"> <div class="media-left meida media-middle"> <span><i class="fa fa-address-card f-s-40 color-primary"></i></span> </div> <div class="media-body media-text-right"> <?php $sql="SELECT COUNT(*) FROM `tbl_rooms`"; $res = $conn->query($sql); $row=mysqli_fetch_array($res);?> <h2 class="color-black"><?php echo $row[0];?></h2> <p class="m-b-0">Total Rooms</p> </div> </div> </div> </div> <div class="col-md-3"> <div class="card p-30"> <div class="media"> <div class="media-left meida media-middle"> <span><i class="fa fa-users f-s-40 color-success"></i></span> </div> <div class="media-body media-text-right"> <?php $sql="SELECT COUNT(*) FROM `tbl_customer`"; $res = $conn->query($sql); $row=mysqli_fetch_array($res);?> <h2 class="color-black"><?php echo $row[0];?></h2> <p class="m-b-0">Total Guests</p> </div> </div> </div> </div> <div class="col-md-3"> <div class="card p-30"> <div class="media"> <div class="media-left meida media-middle"> <span><i class="fa fa-book f-s-40 color-warning"></i></span> </div> <div class="media-body media-text-right"> <?php $sql="SELECT COUNT(*) FROM `tbl_booking`"; $res = $conn->query($sql); $row=mysqli_fetch_array($res);?> <h2 class="color-black"><?php echo $row[0];?></h2> <p class="m-b-0">Total Bookings</p> </div> </div> </div> </div> </div> <!-- End Container fluid --> <!-- End PAge Content --> <!-- footer --> <?php include('footer.php');?> <script> $(function () { <?php include 'connect.php'; $sql = "SELECT * FROM `tbl_booking`"; $result = $conn->query($sql); $i=0; $display_appoint=array(); while($row = $result->fetch_assoc()) { $sql2 = "SELECT * FROM `tbl_customer` WHERE id='".$row['name']."'"; $result2=$conn->query($sql2); $row2=$result2->fetch_assoc(); $sql3 = "SELECT * FROM `tbl_rooms` WHERE id='".$row['roomname']."'"; $result3=$conn->query($sql3); $row3=$result3->fetch_assoc(); $display_appoint[$i]['name']=$row2['name']; $display_appoint[$i]['fromdate']=$row['fromdate']; $display_appoint[$i]['todate']=$row['todate']; $display_appoint[$i]['roomname']=$row3['roomname']; $display_appoint[$i]['color']=$row3['color']; $i++; } ?> /* initialize the external events -----------------------------------------------------------------*/ function init_events(ele) { ele.each(function () { // create an Event Object (http://arshaw.com/fullcalendar/docs/event_data/Event_Object/) // it doesn't need to have a start or end var eventObject = { title: $.trim($(this).text()) // use the element's text as the event title } // store the Event Object in the DOM element so we can get to it later $(this).data('eventObject', eventObject) // make the event draggable using jQuery UI $(this).draggable({ zIndex : 1070, revert : true, // will cause the event to go back to its revertDuration: 0 // original position after the drag }) }) } init_events($('#external-events div.external-event')) /* initialize the calendar -----------------------------------------------------------------*/ //Date for the calendar events (dummy data) var date = new Date() var d = date.getDate(), m = date.getMonth(), y = date.getFullYear() $('#calendar').fullCalendar({ header : { left : 'prev,next today', center: 'title', right : 'month,agendaWeek,agendaDay' }, buttonText: { today: 'today', month: 'month', week : 'week', day : 'day' }, //Random default events events : [ <?php foreach ($display_appoint as $value) { ?> { title : '<?php echo $value['name'],$value['roomname'] ?>', start : new Date(<?php echo date("Y", strtotime($value['fromdate'])); ?>, <?php echo date("m", strtotime($value['fromdate'])); ?>-1, <?php echo date("d", strtotime($value['fromdate'])); ?>), end : new Date(<?php echo date("Y", strtotime($value['todate'])); ?>, <?php echo date("m", strtotime($value['todate'])); ?>-1, <?php echo date("d", strtotime($value['todate'])); ?>+1), backgroundColor: '<?php echo $value['color']?>', //red borderColor : '<?php echo $value['color']?>' //red }, <?php } ?>/* { title : 'Long Event', start : new Date(y, m, d - 5), end : new Date(y, m, d - 2), backgroundColor: '#f39c12', //yellow borderColor : '#f39c12' //yellow }, { title : 'Meeting', start : new Date(y, m, d, 10, 30), allDay : false, backgroundColor: '#0073b7', //Blue borderColor : '#0073b7' //Blue }, { title : 'Lunch', start : new Date(y, m, d, 12, 0), end : new Date(y, m, d, 14, 0), allDay : false, backgroundColor: '#00c0ef', //Info (aqua) borderColor : '#00c0ef' //Info (aqua) }, { title : 'Birthday Party', start : new Date(y, m, d + 1, 19, 0), end : new Date(y, m, d + 1, 22, 30), allDay : false, backgroundColor: '#00a65a', //Success (green) borderColor : '#00a65a' //Success (green) }, { title : 'Click for Google', start : new Date(y, m, 28), end : new Date(y, m, 29), url : 'http://google.com/', backgroundColor: '#3c8dbc', //Primary (light-blue) borderColor : '#3c8dbc' //Primary (light-blue) }*/ ], editable : true, droppable : true, // this allows things to be dropped onto the calendar !!! drop : function (date, allDay) { // this function is called when something is dropped // retrieve the dropped element's stored Event Object var originalEventObject = $(this).data('eventObject') // we need to copy it, so that multiple events don't have a reference to the same object var copiedEventObject = $.extend({}, originalEventObject) // assign it the date that was reported copiedEventObject.start = date copiedEventObject.allDay = allDay copiedEventObject.backgroundColor = $(this).css('background-color') copiedEventObject.borderColor = $(this).css('border-color') // render the event on the calendar // the last `true` argument determines if the event "sticks" (http://arshaw.com/fullcalendar/docs/event_rendering/renderEvent/) $('#calendar').fullCalendar('renderEvent', copiedEventObject, true) // is the "remove after drop" checkbox checked? if ($('#drop-remove').is(':checked')) { // if so, remove the element from the "Draggable Events" list $(this).remove() } } }) /* ADDING EVENTS */ var currColor = '#3c8dbc' //Red by default //Color chooser button var colorChooser = $('#color-chooser-btn') $('#color-chooser > li > a').click(function (e) { e.preventDefault() //Save color currColor = $(this).css('color') //Add color effect to button $('#add-new-event').css({ 'background-color': currColor, 'border-color': currColor }) }) $('#add-new-event').click(function (e) { e.preventDefault() //Get value and make sure it is not null var val = $('#new-event').val() if (val.length == 0) { return } //Create events var event = $('<div />') event.css({ 'background-color': currColor, 'border-color' : currColor, 'color' : '#fff' }).addClass('external-event') event.html(val) $('#external-events').prepend(event) //Add draggable funtionality init_events(event) //Remove event from text input $('#new-event').val('') }) }) </script> <?php if(!empty($_SESSION['success'])) { ?> <div class="popup popup--icon -success js_success-popup popup--visible"> <div class="popup__background"></div> <div class="popup__content"> <h3 class="popup__content__title"> Success </h1> <p><?php echo $_SESSION['success']; ?></p> <p> <button class="button button--success" data-for="js_success-popup">Close</button> </p> </div> </div> <?php unset($_SESSION["success"]); } ?> <?php if(!empty($_SESSION['error'])) { ?> <div class="popup popup--icon -error js_error-popup popup--visible"> <div class="popup__background"></div> <div class="popup__content"> <h3 class="popup__content__title"> Error </h1> <p><?php echo $_SESSION['error']; ?></p> <p> <button class="button button--error" data-for="js_error-popup">Close</button> </p> </div> </div> <?php unset($_SESSION["error"]); } ?> <script> var addButtonTrigger = function addButtonTrigger(el) { el.addEventListener('click', function () { var popupEl = document.querySelector('.' + el.dataset.for); popupEl.classList.toggle('popup--visible'); }); }; Array.from(document.querySelectorAll('button[data-for]')). forEach(addButtonTrigger); </script> </body> </html>
SIMPAN PERUBAHAN