<?php
	
	include $_SERVER['DOCUMENT_ROOT'] . '/php/functions/CommonFunctions.php';
	include $_SERVER['DOCUMENT_ROOT'] . '/php/functions/MainPageFunctions.php';
	include $_SERVER['DOCUMENT_ROOT'] . '/php/modals.php';
	
	$sql = "SELECT id, code, sale, price, title, descripe, stcs FROM courses ORDER BY code ASC";
	$m = $e = $f = $t = $s = $txt = $cpns = $bill = $email = $dNone = $session = '';
	$ratesArr = $daysArr = array();

	if(isset($_GET['policy']) and !isset($_GET['session'])) $session = 'onload="getPolicy('.$_GET['policy'].')"';
	if(isset($_GET['session'])) $session = 'onload="getSessionModal('.$_GET['session'].')"';
	if(isset($_GET['registered_email']) and isset($_GET['activation_code']) and !isset($_GET['session'])) $session = get_active($_GET['registered_email'], $_GET['activation_code']);

	if(isset($_SESSION['id'])) {
		$id    = $_SESSION['id'];
		$email = $_SESSION['email'];
		$type  = $_SESSION['type'];
		$cpns  = $_SESSION['cpns'];
		$bill  = $_SESSION['bill'];
		
		if($type != 'active') $session = 'onload="getModal(\'activeModal\')"';
		
		$user = '<li class="nav-item dropdown">
				 <button type="button" class="btn btn-outline-secondry btn-sm txt-sm ms-2" data-bs-toggle="dropdown"><small>' . $_SESSION['name'] . '
				 <i class="bi bi-chevron-down me-1"></i></small></button><ul class="dropdown-menu text-end" style="position:absolute">
				 <li><span class="dropdown-item txt-sm disabled"><small>' . $email . '</small></span></li>' . $_SESSION['user'];
		$freeSql = "SELECT id, code, sale, price, title, descripe, stcs FROM courses WHERE price = 0 ORDER BY code ASC";
		$userSql = "SELECT t1.id, code, sale, price, title, descripe, stcs, DATEDIFF(t2.end_date, CURRENT_TIMESTAMP) days FROM courses t1 JOIN students t2 ON t1.id = t2.course_id AND t2.user_id = $id ORDER BY code ASC";
		$inCrds = $conn->query($userSql);
		
		foreach ($inCrds as $data) {
			if($data['days'] > 0) $daysArr += [$data['id'] => $data['days']];
		}	
		if(isset($_GET['session']) and ($_GET['session'] == $email or $_GET['session'] == 'freecourses')) {
			$dNone = 'd-none';
			($_GET['session'] == $email)?($sql = $userSql):($sql = $freeSql);
		}
	}else $user = '<li class="nav-item"><small><span type="button" class="navBtn text-dark" data-bs-toggle="modal" data-bs-target="#inputModal" onclick="resetModal(\'inputForm\')">دخول</span>
				   <span type="button" class="navBtn text-dark me-3 me-sm-4 ms-3" data-bs-toggle="modal" data-bs-target="#registerModal" onclick="resetModal(\'regForm\')">تسجيل</span></small></li>';

	$cards = $conn->query($sql);
	
	if(!isset($_SESSION['rates'])) {
		$rates = $conn->query("SELECT course_id id, COUNT(rating) total, AVG(rating) avg FROM ratings GROUP BY course_id");		
		foreach ($rates as $rate) $ratesArr += [$rate['id'] => ['total' => $rate['total'], 'avg' => $rate['avg']]];
		$_SESSION['rates'] = $ratesArr;
	}else $ratesArr = $_SESSION['rates'];
	
	// --------main proccess-------
	foreach ($cards as $data) {
		$coursId = $data['id'];
		$code    = $data['code'];
		$sale    = $data['sale'];
		$price   = $data['price'];		
		$review  = 0; $avg = 0;
		($price == 0)?($price = '<div class="badge txt-sm text-success border border-success py-2 px-3 my-2"><small>دورة مجانية</small></div>'):
		($price = '<div class="text-danger dollar fw-bold fs-5 my-2"> '.number_format($data['price'], 2).'</div>');
		
		if(array_key_exists($coursId, $daysArr)) {
			$sale = 0;
			$price = '<div class="badge txt-sm border border-danger text-danger p-2 my-2"><small>ستغلق الدورة بعد '.$daysArr[$coursId].' يوما</small></div>';			
		}
		
		if(array_key_exists($coursId, $ratesArr)) {
			$review = $ratesArr[$coursId]['total'];
			$avg = $ratesArr[$coursId]['avg'];
		}
		$GLOBALS[strtolower($code[0])] .= get_card($code, $data['title'], $data['descripe'], $data['stcs'], $review, get_avg($avg), $price, $sale);			
	}

	$crds = get_cards('أسواق المال', 'Markets', 'دورات تعلمك كيف تقرأ البيانات الإقتصادية ودراسة تأثرها على استثمارات ومضارباتك', 'm').
		    get_cards('التحليل الأساسي', 'Macro Economic', 'دورات تعلمك كيف تقرأ البيانات الإقتصادية ودراسة تأثرها على استثمارات ومضارباتك', 'e').
		    get_cards('التحليل المالي', 'Financial Analysis', 'دورات تعلمك كيف تقرأ البيانات الإقتصادية ودراسة تأثرها على استثمارات ومضارباتك', 'f').
		    get_cards('التحليل الفني', 'Technical Analysis', 'دورات تعلمك كيف تقرأ البيانات الإقتصادية ودراسة تأثرها على استثمارات ومضارباتك', 't').
		    get_cards('الإستراتيجيات', 'Strategies', 'دورات تعلمك كيف تقرأ البيانات الإقتصادية ودراسة تأثرها على استثمارات ومضارباتك', 's');
			 
	$btns = get_btns('أسواق<br><br>المال', '#m', 'bank').
	        get_btns('التحليل<br><br>الأساسي', '#e', 'cash-coin').
		    get_btns('التحليل<br><br>المالي', '#f', 'bar-chart').
		    get_btns('التحليل<br><br>الفني', '#t', 'graph-up').
		    get_btns('إستراتيجيات<br><br>فنية', '#s', 'box').
			get_btns('الحاسبة<br><br>المالية', 'calculator', 'calculator-fill');
	
	$mainPage = '<!DOCTYPE html>
					<html lang="ar" dir="rtl">
						<head>
							<title>'.URL.' - دورات مالية متكاملة</title>
							<meta charset="utf-8">
							<meta name="viewport" content="width=device-width, initial-scale=1">
							<meta http-equiv="X-UA-Compatible" content="IE=Edge">
							<link rel="icon" href="img/favicon.png" sizes="16x16" type="image/png">
							<link rel="preconnect" href="https://fonts.googleapis.com">
							<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
							<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Readex+Pro:wght@500;700&display=swap">
							<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Marhey&display=swap">
							<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Protest+Strike&family=Tiny5&display=swap">
							<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Cairo:wght@900&family=Marhey:wght@300..700&display=swap">
							<link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Cairo:wght@1000&family=Marhey:wght@300..700&family=Playfair+Display:ital,wght@0,400..900;1,400..900&display=swap">
							<link rel="stylesheet" href="css/bs_css/bootstrap.min.css">
							<link rel="stylesheet" href="css/bs_icon/font/bootstrap-icons.min.css">
							<link rel="stylesheet" href="css/style.css"/>
							<script src="js/jquery.min.js"></script>
							<script src="https://www.paypal.com/sdk/js?client-id=AW1GiuIkjRMj7xmV1XOr1g69aXfA51tdCI9FnEkMZmDEAc-5Bzh_2TY4bnlQgx-ESNbL-1Oqhnr_rINi"></script>
							<script async src="https://www.googletagmanager.com/gtag/js?id=G-EP5NWN7HT5"></script>
							<script>
								window.dataLayer = window.dataLayer || [];
								function gtag(){dataLayer.push(arguments);}
								gtag("js", new Date());
								gtag("config", "G-EP5NWN7HT5");
							</script>
						</head>	
						<body '.$session.'>		
							'.$cpns.$bill.$modals.'
							<nav class="navbar">
								<div class="container border border-2 border-dark border-opacity-25 border-top-0 border-end-0 border-start-0 py-3">
									<div>
										<a class="navbar-brand logo text-black-50 fs-1" style="font-family:Playfair Display, serif" href="https://'.URL.'">
										<span class="text-info fst-italic" style="font-family:Protest Strike, sans-serif">I<span class="text-primary">I</span><span class="text-danger">I&nbsp;</span></span>iborsa.io</a>
									</div>
									<div class="txt-sm">	
										<ul class="navbar-nav">'.$user.'</ul>
									</div>
								</div>
							</nav>
							<div class="container mt-5 mt-md-4">
								<div class="row row-cols-1 row-cols-md-2 gy-5 mb-3 pt-md-4 px-1 mx-1 px-md-0 mx-md-0 px-xxl-3 mx-xxl-2 '.$dNone.'">
									<div class="col pe-0 pe-lg-5">
										<div class="fw-bold text-primary-emphasis border border-5 border-top-0 border-bottom-0 border-start-0 border-secondary ps-0 pe-3 pt-0 me-4 me-md-2" style="font-family:Cairo, sans-serif">
											<p class="fs-2 mt-xxl-5 me-xxl-3 d-none d-xxl-block">أفضل منصة تدريب عن بعد</p>
											<p class="fs-2 me-xxl-3 d-none d-xxl-block">تقدم دورات مالية متكاملة</p>
											<p class="fs-2 mb-4 me-xxl-3 d-none d-xxl-block">للتداول في البورصة</p>								
											<p class="fs-4 mt-2 mt-md-3 mt-lg-4 mt-xl-5 d-xxl-none">أفضل منصة تدريب عن بعد</p>
											<p class="fs-4 d-xxl-none">تقدم دورات مالية متكاملة</p>
											<p class="fs-4 mb-4 d-xxl-none">للتداول في البورصة</p>												
										</div>
									</div>
									<div class="col ps-0 ps-lg-5">
										<div class="ratio ratio-16x9 my-0">
											<img src="img/head.png"></img>
										</div>						
									</div>
								</div>
								<div class="text-center txt-sm mt-4"><small>'.$btns.'</small></div>
							</div> 
							<div class="container mb-5">
								<div class="container">'.$crds.'</div>
							</div><br>
							<div class="container">'.$footer.'</div>	
							<div id="email" class="d-none">'.$email.'</div>
							<script src="js/main.js" type="text/javascript"></script>
							<script src="https://accounts.google.com/gsi/client?hl=ar" async></script>
							<script src="js/jwt-decode.min.js"></script>
							<script src="js/bs_js/bootstrap.bundle.min.js"></script>
						</body>
					</html>';
					
	$conn->close();
	echo $mainPage;