<?php

function initDashboard(){
	global $mysqli;	
	$siteLabels = getLanguage();

	
	if(isset($_POST['downloadExcel'])){
		createExcelFile();
		header('location: ./');
	}

	$output = '';
	$output .= '<h1>Dashboard</h1>';

	$output .= '<div class="submenu">';
		$output .= '<form action="" method="post">';
			//$output .= '<input type="submit" name="downloadExcel" value="Download Excel Bestand" class="btn176 btn176b proceed"/>';
		$output .= '</form>';
	$output .= '</div>';


	/// LAATSTE ORDERS \\\\


	## top row ##
	
	$output .= '<div class="double-column margin-right-40">';
	
		$output .= '<h2>latest orders</h2><br />';
		
		$output .= '<div class="dashboardlist-row dashboardlist-heading">';
			$output .= '<div class="dashboardlist-double-column">title</div>';
			$output .= '<div class="dashboardlist-single-column">added on</div>';
			$output .= '<div class="dashboardlist-single-column">status</div>';
		$output .= '</div>';	
		
		$query = 'SELECT DISTINCT oi.id AS orderId, oi.orderCode, oi.orderDate, oi.orderStatus
					 FROM shop_order_info AS oi
					 WHERE NOT oi.orderStatus = "-1"
					 ORDER BY oi.orderDate DESC LIMIT 5';
					  
		if($result = $mysqli->query($query)){
			$numOrders = $result->num_rows;							 
												 
			while($record = $result->fetch_assoc()){ 
				//// store info \\\\ 
				$orderId = $record['orderId'];				
				$orderCode = $record['orderCode'];				
							
				$orderDate = $record['orderDate'];				
				$orderStatus = $record['orderStatus'];		
				
				//order status
				$orderStatusResult = $mysqli->query('SELECT orderStatus
														  FROM shop_status
														  WHERE statusNr = '.$orderStatus.' LIMIT 1');
					$orderStatusRecord = $orderStatusResult->fetch_assoc();
					$displayOrderStatus = $orderStatusRecord['orderStatus'];
				
				
				//// create display info \\\\		
				$orderDate = date('d / m / Y',$orderDate); # orderDate
								
				//display info
				$output .= '<div class="dashboardlist-row">';
					$output .= '<div class="dashboardlist-double-column"><a href="/admin/orders/ordernr/'.$orderCode.'-'.$orderId.'/">'.$orderCode.'</a></div>';
					$output .= '<div class="dashboardlist-single-column">'.$orderDate.'</div>';
					$output .= '<div class="dashboardlist-single-column">'.$displayOrderStatus.'</div>';
				$output .= '</div>';
			}
			$output .= '<a href="/admin/orders/" class="inline-block"><span class="btn176 btn176a proceed">Toon alle orders</span></a>';
		}
	$output .= '</div>';
	
	/// LAATSTE KLANTEN \\\\
	
	$output .= '<div class="double-column">';
		
		$output .= '<h2>latest customers</h2><br />';
		
		$output .= '<div class="dashboardlist-row dashboardlist-heading">';
			$output .= '<div class="dashboardlist-double-column">name</div>';
			$output .= '<div class="dashboardlist-single-column">member since</div>';
			$output .= '<div class="dashboardlist-single-column">city</div>';
		$output .= '</div>';	
		
		$query = 'SELECT DISTINCT cl.id AS customerId, cl.email, cl.status, cp.customerCode, cp.firstName, cp.middleName, cp.lastName, cp.city, cp.timest
				FROM shop_customer_login AS cl, shop_customer_personal AS cp
				WHERE cl.personalId = cp.id
				ORDER BY cp.timest DESC LIMIT 5';
					  
		if($result = $mysqli->query($query)){
			$numOrders = $result->num_rows;							 
												 
			while($record = $result->fetch_assoc()){ 
				$customerId = $record['customerId'];				
				$customerCode = $record['customerCode'];				
				$memberSince = $record['timest'];
				
				$city = fromDatabase($record['city']);
				
				$name = fromDatabase($record['firstName']);
				if(!empty($record['middleName'])) $name .= ' '.fromDatabase($record['middleName']);
				$name .= ' '.fromDatabase($record['lastName']);
				
				//// create display info \\\\		
				$memberSince = date('d / m / Y',$memberSince); # memberSince
								
				//display info
				$output .= '<div class="dashboardlist-row">';
					$output .= '<div class="dashboardlist-double-column"><a href="/admin/customers/details/'.$customerCode.'-'.$customerId.'/">'.$name.'</a></div>';
					$output .= '<div class="dashboardlist-single-column">'.$memberSince.'</div>';
					$output .= '<div class="dashboardlist-single-column">'.$city.'</div>';
				$output .= '</div>';
			}
			$output .= '<a href="/admin/customers/"><span class="btn176 btn176a proceed">Toon alle klanten</span></a>';
		}
	$output .= '</div>';
	return $output;
}


?>