<?php
session_start();

if(isset($_GET['name']))
	$name = $_GET['name'];
else
	$name = '';

if(isset($_GET['mode']))
	$mode = $_GET['mode'];
else
	$mode = '';


if(isset($_GET['action']))
	$action = $_GET['action'];
else
	$action = '';

if($action=='') header('location:index.php?action=display');

if($action=='signout')
{
	session_unset();
	session_destroy(); 
	header('location:index.php?action=display');
}

function get_client_ip() {
    $ipaddress = '';
    if (isset($_SERVER['HTTP_CLIENT_IP']))
        $ipaddress = $_SERVER['HTTP_CLIENT_IP'];
    else if(isset($_SERVER['HTTP_X_FORWARDED_FOR']))
        $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];
    else if(isset($_SERVER['HTTP_X_FORWARDED']))
        $ipaddress = $_SERVER['HTTP_X_FORWARDED'];
    else if(isset($_SERVER['HTTP_FORWARDED_FOR']))
        $ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];
    else if(isset($_SERVER['HTTP_FORWARDED']))
        $ipaddress = $_SERVER['HTTP_FORWARDED'];
    else if(isset($_SERVER['REMOTE_ADDR']))
        $ipaddress = $_SERVER['REMOTE_ADDR'];
    else
        $ipaddress = 'UNKNOWN';
    return $ipaddress;
}

if(get_client_ip()=='::1')
{
	$host = "localhost";
	$user = "root";
	$pass = "madaragaul";
	$db = "me_obsessionmediagroup";
}
else
{
	$host = "localhost";
	$user = "omgcom_widgets";
	$pass = "Jr34@&k9-~Ex48.34";
	$db = "omgcom_widgets";
}

$mysqli = new mysqli($host,$user,$pass,$db);

if ($mysqli ->connect_errno) {
  echo "Failed to connect to MySQL: " . $mysqli->connect_error;
  exit();
}

$sql = "SELECT id,jumlah FROM `widget_data_covid19` ORDER BY id";
$result = $mysqli->query($sql);

while($data = $result->fetch_array(MYSQLI_NUM)){
	$arr_data[] = array($data[0],$data[1]);
}



if($_POST)
{
	if($action=='signin')
	{
		$username = $_POST['username'];
		$password = $_POST['password'];

		if($username=='omg' && $password=='OMGgeopbyte')
		{
			$_SESSION['is_signin'] = '1';
			header('location:index.php?action=edit');
		}
	}

	if($action=='edit')
	{
		$terkonfirmasi = $_POST['terkonfirmasi'];
		$sembuh = $_POST['sembuh'];
		$meninggal = $_POST['meninggal'];

		$sql_edit1 = "UPDATE `widget_data_covid19` SET jumlah='".$terkonfirmasi."' WHERE id=1";
		$mysqli->query($sql_edit1);

		$sql_edit2 = "UPDATE `widget_data_covid19` SET jumlah='".$sembuh."' WHERE id=2";
		$mysqli->query($sql_edit2);

		$sql_edit3 = "UPDATE `widget_data_covid19` SET jumlah='".$meninggal."' WHERE id=3";
		$mysqli->query($sql_edit3);

		header('location:index.php?action=edit');
	}
}
?>

<!DOCTYPE html>
<html>
<head>
	<title>Widget Covid 19 - Obsession Media Group</title>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	
	<!-- Global site tag (gtag.js) - Google Analytics -->
	<script async src="https://www.googletagmanager.com/gtag/js?id=UA-64636332-8"></script>
	<script>
	  window.dataLayer = window.dataLayer || [];
	  function gtag(){dataLayer.push(arguments);}
	  gtag('js', new Date());

	  gtag('config', 'UA-64636332-8');
	</script>

	<link rel="stylesheet" href="css/w3.css">
	<style type="text/css">
		* {font-family: arial; font-size: 18px; margin:0; padding:0;}
		body {background-color:#dbcda8 !important;}
		#realdata {width:100%;}
		#realdata div {color:#fff; text-align: center;}
		#realdata div.grey {background-color:#414141; center;}
		#realdata div span {display: inline-block; vertical-align: middle; line-height: normal;}
		#realdata div.cyan {background-color:#167071; padding:5px 0;}
		#realdata div.brown {background-color:#c16228; padding:5px 0;}
		#realdata div.grape {background-color:#553b60; padding:5px 0;}
	</style>
</head>
<body>

	<?php if($action=='signin'){?>

	
	<form method="post" action="index.php?action=signin">
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">Username</div>
		<div class="w3-col s12 m1 w1">
			<input type="text" name="username">
		</div>
	</div>
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">Password</div>
		<div class="w3-col s12 m1 w1">
			<input type="password" name="password">
		</div>
	</div>
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">&nbsp;</div>
		<div class="w3-col s12 m1 w1">
			<input type="submit" value=" Sign In ">
		</div>
	</div>
	</form>

	<?php } ?>



	<?php if($action=='display'){ ?>
	<?php
	?>
	<div class="w3-row">
		<div id="realdata">
			<div class="w3-col s12 m12 w12" style="background-color:#dbcda8; color:#414141;">
				<b>MONITORING DATA COVID-19</b>
			</div>
			<div style="margin:0 15px;">
				<div class="cyan w3-col s4 m4 w4 w3-large">
					<span style="font-weight:bold; font-size:12px;">TERKONFIRMASI</span><br>
					<span style="font-weight:bold; font-size:27px;"><?=substr(number_format($arr_data[0][1], 2, ',', '.'), 0, -3);?></span>
				</div>
				<div class="brown w3-col s4 m4 w4 w3-large">
					<span style="font-weight:bold; font-size:12px;">SEMBUH</span><br>
					<span style="font-weight:bold; font-size:27px;"><?=substr(number_format($arr_data[1][1], 2, ',', '.'), 0, -3);?></span>
				</div>
				<div class="grape w3-col s4 m4 w4 w3-large">
					<span style="font-weight:bold; font-size:12px;">MENINGGAL</span><br>
					<span style="font-weight:bold; font-size:27px;"><?=substr(number_format($arr_data[2][1], 2, ',', '.'), 0, -3);?></span>
				</div>
			</div>
			<div class="w3-col s12 m12 w12 w3-xxlarge align-middle" style="background-color:#dbcda8; color:#414141; vertical-align: middle !important; line-height:10px; padding-top:10px;">
				<span style="font-size:12px; font-weight:bold;">COVID-19 HOTLINE:&nbsp; <span style="color:#ba1816; font-weight:bold; font-size:16px;">119 EXT 9</span> &nbsp;(KEMENKES RI)</span>&nbsp;<br>
				<span style="font-size:12px; font-weight:bold;">CHATBOT COVID-19:&nbsp; <span style="color:#ba1816; font-weight:bold; font-size:16px;">+62811-3339-9000</span>&nbsp; 
			</div>
			<div class="w3-col s12 m12 w12 w3-xxlarge align-middle" style="background-color:#dbcda8; color:#414141; vertical-align: middle !important; line-height: normal;">
			</div>
		</div>
	</div>
	<?php } ?>



	<?php if($action=='edit'){?>

	<?php if(isset($_SESSION['is_signin']) && $_SESSION['is_signin']=='1'){ ?>
	<form method="post" action="index.php?action=edit">
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">Terkonfirmasi</div>
		<div class="w3-col s12 m1 w1">
			<input type="text" name="terkonfirmasi" value="<?=$arr_data[0][1];?>">
		</div>
	</div>
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">Sembuh</div>
		<div class="w3-col s12 m1 w1">
			<input type="text" name="sembuh" value="<?=$arr_data[1][1];?>">
		</div>
	</div>
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">Meninggal</div>
		<div class="w3-col s12 m1 w1">
			<input type="text" name="meninggal" value="<?=$arr_data[2][1];?>">
		</div>
	</div>
	<div class="w3-row">
		<div class="w3-col s12 m1 w1">&nbsp;</div>
		<div class="w3-col s12 m1 w1">
			<input type="submit" value=" Update ">
			<input type="button" value=" Sign Out " onclick="location.href='index.php?action=signout';">
		</div>
	</div>
	</form>
	<?php } else { ?>
	<script type="text/javascript">location.href='index.php?action=signin';</script>
	<?php } ?>

	<?php } ?>

</body>
</html>

<?php 

$result->free_result();
$mysqli->close();

?>