<?php 
	require('db_config.php');
	class ParentClass
	{
		public function getUserBySessionId($userid)
		{
			 
			$conn 		=	 mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$selectUser = 	"select * from ".TB_USERLOGIN." where userId = '".$userid."'"; 
			$queryUser  = 	mysqli_query($conn,$selectUser);
			$result 	= 	mysqli_fetch_assoc($queryUser);
			 
			return $result;
		}
		public function getAllUser($userid)
		{
			$array 		= 	array();
			$conn 		=	 mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$selectuser = 	"select * from ".TB_USERLOGIN." where userId != '".$userid."'";
			$queryUser 	= 	mysqli_query($conn,$selectuser);
			while ($row	=	mysqli_fetch_assoc($queryUser))
				{
					$array[] = $row;	
				}
				return $array;
		}
		
		
		public function userlogin($username,$userpass)
		{  
			$conn 		=	 mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$date		= 	date ('Y-m-d');
			$status		= 	'1';
			$selectUser = 	"
								select * from ".TB_USERLOGIN." where db_username = '".mysql_real_escape_string($username)."' 
								|| db_email = '".mysql_real_escape_string($username)."' 
								|| db_phone = '".mysql_real_escape_string($username)."' 
								and 
								db_password = '".md5($userpass)."'
								and db_status = '".$status."'
							";
			$queryUser  = 	mysqli_query($conn,$selectUser);
			
			$result 	= 	mysqli_fetch_array($queryUser);
			$UserDate   =   strtotime($result['db_valid']);
			$validDate  =	date('Y-m-d',$UserDate);
			$vdate = strtotime($validDate);
			$Ndate = strtotime($date);
			
			if ($Ndate == $vdate)
			{
				$array = array('token'=>'0','userid'=>$result['userId']);
				return $array;
			}
			elseif ($Ndate >= $vdate)
			{
				$array = array('token'=>'11','userid'=>$result['userId']);
				return $array;
			}
			else
			{
				return $result['userId'];
			}
		}		
		
		public function addNewUser($username,$useremail,$userphone,$userpass,$usergroup,$unqId,$target_file,$usergroup,$vdate)
		{
			$array		= 	array();
			$conn 		=	mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$date		= 	date ('Y-m-d H:i:s');
			$status 	= 	'1';
			$selectEmail 	=	"select * from ".TB_USERLOGIN." where db_email = '".$useremail."'";
			$selectQuery  	= mysqli_query($conn,$selectEmail);
			$result 	= 	mysqli_fetch_array($selectQuery);
			if (!empty($result))
			{
				echo '11';
			}
			else
			{
				$insertDataQuery = "INSERT INTO ".TB_USERLOGIN." SET 		db_userRandId 		 = 	'".mysql_real_escape_string($unqId)."',
																			db_username   		 = 	'".mysql_real_escape_string($username)."',
																			db_password   		 = 	'".md5($userpass)."',
																			db_phone   		 	 = 	'".mysql_real_escape_string($userphone)."',
																			db_email   		 	 = 	'".mysql_real_escape_string($useremail)."',
																			db_userprofilepic    = 	'".mysql_real_escape_string($target_file)."',
																			db_status   		 = 	'".$status."',
																			db_usertype   		 = 	'".mysql_real_escape_string($usergroup)."',
																			db_valid   		 	 = 	'".$vdate."',
																			created_date		 = 	'".$date."'
																	 "; 
				$runquery	 	= 	mysqli_query($conn,$insertDataQuery);
				if ($runquery)
				{
					 echo '1';
				}
			}
		}
		
		public function UpdateNewUser($username,$useremail,$userphone,$userpass,$UID,$usergroup,$target_file,$vdate)
		{
			 
			$conn 		=	mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$date		= 	date ('Y-m-d H:i:s');
		  
			$insertDataQuery = "UPDATE  ".TB_USERLOGIN." SET 		db_username   		 	 = 	'".mysql_real_escape_string($username)."',
																	db_password   		 = 	'".md5($userpass)."',
																	db_phone   		 	 = 	'".mysql_real_escape_string($userphone)."',
																	db_email   		 	 = 	'".mysql_real_escape_string($useremail)."',
																	db_userprofilepic    = 	'".mysql_real_escape_string($target_file)."',
																	db_usertype   		 = 	'".mysql_real_escape_string($usergroup)."',
																	db_valid   		 	 = 	'".$vdate."',
																	updated_date		 = 	'".$date."'
																	WHERE	userId		 =  '".$UID."'
																";  
			$runquery	 	= 	mysqli_query($conn,$insertDataQuery);
			if ($runquery)
			{
				 echo '1';
			}
			 
		}
		
		public function deleteUser($userid)
		{
			$conn 		=	mysqli_connect(HOSTNAME,DBUSERNAME,DBPASSWORD,DBNAME);
			$deletUser	=   "DELETE FROM ".TB_USERLOGIN." WHERE userId = '".$userid."'";
			$queryUser	=	mysqli_query($conn,$deletUser);
			if($queryUser)
			{
				echo '1';
			}
		}
	}
?>