<?php

session_start();
include('../class/actionClass.php');
include('../class/user_Class.php');
include('../class/util_Class.php');
include('../class/view_Class.php');

$actiondata_db = new actiondata;
$view_db = new Viewdata;
$util_class = new Util;
$User_db = new User;

date_default_timezone_set("Asia/Bangkok");


$user = addslashes(trim($_POST['inputName']));
$pass= addslashes(trim($_POST['inputPassword']));

$pass_md5 = $User_db->cus_pass($pass);



$name_table = "admin";

$sql = array('table'=>$name_table,'count'=>'count(id) AS count_id','where'=>"username = '". $user ."' AND  status = '1'");
$view_sql = $view_db->view($sql);
$row = $view_db->q($view_sql);
$row["count_id"];


//echo $row["count_id"];
//echo $user;
//exit();


if($row["count_id"])
{

		$sql2 = array('table'=>$name_table,'count'=>'count(id) AS count_id','where'=>"username = '". $user ."' AND password = '". $pass_md5 ."' AND  status = '1'");
		$view_sql2 = $view_db->view($sql2);
		$row2 = $view_db->q($view_sql2);
		
		//print_r($view_sql2);
		//echo $row2["count_id"];
		//exit();
		if($row2["count_id"])
		{
			$sql_id = array('table'=>$name_table,'where'=>"username = '".$user."' AND password = '".$pass_md5."'");
			$viewid_sql = $view_db->view($sql_id);
			$row_id = $view_db->q($viewid_sql);
            
           
		
			$_SESSION["admin_cn_login"] = 1;
			$_SESSION["m-name"] = $row_id["username"];
			$_SESSION["admin_cn_user"] = $row_id["username"];
			$_SESSION["admin_cn_id"] = $row_id["id"];
			$_SESSION["admin_cn_type"] = $row_id["level"];




			//$add = $User_db->log_Admin($_SESSION["admin_cn_id"],$_SESSION["admin_cn_user"],'admin','login');


            header('Location: dashboard/index.php');

			exit;
			
		}
		else
		{
		 echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><script> alert("ข้อมลู Username หรือ Password ไม่ถูกต้อง");
            </script>
            <meta http-equiv="refresh" content="0;URL=index.php">';
            
		}
}
else
{
	echo '<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<script>
		alert("ข้อมลู Username หรือ Password ไม่ถูกต้อง");
	</script>
	<meta http-equiv="refresh" content="0;URL=index.php">';
	
}
?>