<?php
abstract class ACore_Admin {
	
	protected $db;
	
	public function __construct() {
		
		if(!$_SESSION['user']) {
			header("Location:?option=login");
		}

		$this->db = mysql_connect(HOST, USER, PASSWORD);
		if(!$this->db) {
			exit("DB connection error".mysql_error());
		}
		if(!mysql_select_db(DB,$this->db)) {
			exit("DB does not exist".mysql_error());
		}
		mysql_query("SET NAMES 'UTF8'");
		
	}
	
	public function get_header() {
		include "header_admin.php";
	}
	
	public function get_widget() {
		include "widget_admin.php";
	}

	public function get_footer() {
		include "footer.php";
	}

	public function get_menu() {
		$row = $this->menu_array();

echo '<DIV id="access" role="navigation">
<DIV class="skip-link screen-reader-text"><A title="Skip to content" href="?option=main">Skip to content</A></DIV>

<DIV id="accessfix" role="navigation"></DIV><DIV class="menu-header">
<UL class="menu" id="menu-main-menu">
  
';
//<LI class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item current_page_item home"   id="Home"><A href="?option=main">Home</A></LI>
		$i = 1;
		foreach($row as $item) {
			
			$row1 = $this->submenu_array($item['id_menu']);
			
				if($i != count($row)) {
					if(!($row1)) printf("<LI class='menu-item' id='%s'><A href='?option=update_menu&id_menu=%s'>%s</A>
					",$item['menu_name'],$item['id_menu'],$item['menu_name']);
					else printf("<LI class='menu-item' id='%s'><A href='#'>%s</A>
					",$item['menu_name'],$item['menu_name']);
				}
				else
				{
					printf("<LI class='menu-item contact' id='contact'><A href='?option=menu&id_menu=%s'>%s</A>
					",$item['id_menu'],$item['menu_name']);
				}

				if(($row1)) {
					echo '  <UL class="sub-menu">
					';
					foreach($row1 as $item1) {
										printf("<LI class='menu-item' id='%s'><A href='?option=admin'>%s</A></LI>
										",$item1['submenu_name'],$item1['submenu_name']);
					}
					echo '    
					</UL>
					';
				}
				echo '
				</LI>';
			$i++;
		}
echo '</DIV></DIV><!-- #access --> 
</DIV>	 <!-- #header -->
';

// header's part before main block input
				//echo '			<div id="container">
				//				<div id="content" role="main">
				//				<div id="post-467" class="post-467 page type-page status-publish hentry">';

	}

	protected function menu_array() {
		//$query = "SELECT id_menu, menu_name, menu_level, menu_content, project_id FROM menu";
		$query = "SELECT id_menu, menu_name FROM menu WHERE ((menu_name <> '') AND (menu_name IS NOT NULL))";
		
		$result = mysql_query($query);
		if(!$result) {
			exit(mysql_error());
		}
		
		$row = array();
		
		for($i = 0;$i < mysql_num_rows($result); $i++) {
			$row[] = mysql_fetch_array($result, MYSQL_ASSOC);
		}
		return $row;
	}
	
	protected function submenu_array($menu_id) {
		//$query = "SELECT id_menu, menu_name, menu_level, menu_content, project_id FROM menu";
		$query = "SELECT id_submenu, submenu_name FROM submenu WHERE id_menu='$menu_id'";
		
		$result = mysql_query($query);
		if(!$result) {
			exit(mysql_error());
		}
		
		$row = array();
		
		for($i = 0;$i < mysql_num_rows($result); $i++) {
			$row[] = mysql_fetch_array($result, MYSQL_ASSOC);
		}
		return $row;
	}
	
	
	public function get_body() {
		if($_POST || $_GET['del']) {
			$this->obr();
		}
		$this->get_header();
		$this->get_menu();
		$this->get_content();
		$this->get_widget();
		$this->get_footer();
	}
	
	
	abstract function get_content();
	
	protected function get_menu_text($id) {
		$query = "SELECT id_menu,content_title,menu_content,project_id FROM menu WHERE id_menu='$id'";
		$result = mysql_query($query);
		if(!$result) {
			exit(mysql_error());
		}
		
		$row = array();
		$row[] = mysql_fetch_array($result, MYSQL_ASSOC);
		
		return $row;
	}

}
?>