<?php

function subscripe($btn , $ser_id){

	if (isset($btn)) {
		$service_id = $ser_id;
		$phoneNumber = $_SESSION['phoneNumber'];
		$query = "SELECT *FROM `ser_trace` WHERE `Cus_num` = $phoneNumber AND `Service_id` = $service_id";
		$result = mysql_query($query);
		$count = mysql_num_rows($result);

		// check if subscribed or not
if(isset($_POST["Activate7"]))							
{

		if ($count == 1 AND $service_id == 7) {
			echo "<img src='img/error.png' /> You Are already subscribed";
		}else{
			// check the user credit 
			
			
			$check_user_credit_query = "SELECT * FROM `user_information`
			                      WHERE `Cus_num` = $phoneNumber";

			$check_user_credit = mysql_query($check_user_credit_query);

			$row = mysql_fetch_array($check_user_credit);
			// user current credit 
			$user_credit = $row['Credit'];

			// select service cost from the table

			$check_service_cost = "SELECT * FROM `services` WHERE `Service_id` = $service_id ";
			$check_service_cost_query = mysql_query($check_service_cost);
			$service_row = mysql_fetch_array($check_service_cost_query);
			$service_cost = $service_row['Cost'];
			$service_period = $service_row['Period'];


			// check if user credit is enough to subscribe 
			if ($user_credit > $service_cost) {
				// enough do this

				//discard credit 
				$q = "SELECT * FROM `user_information` WHERE `Cus_num` = $phoneNumber";
				$res = mysql_query($q);
				$r = mysql_fetch_array($res);
				$my_old_credit = $r['Credit'];
				$my_new_credit = $my_old_credit - $service_cost ;

				// update credit of the user 
				$update_user_creidt_query = "UPDATE `user_information` 
									         SET `Credit`= $my_new_credit
									         WHERE `cus_num` = $phoneNumber ";
				$update_user_creidt = mysql_query($update_user_creidt_query);

 				
$to_date = date("d/m/y h:i:s " , time() + $service_period );
$end_date = date("d/m/y h:i:s" , time() + $service_period + 86400 );
				
				$user_subscription_query = "INSERT INTO `ser_trace`(`Cus_num`, `Service_id`, `From`, `To`)
				                            VALUES ( '$phoneNumber','$service_id' ,NOW(),'$to_date')";

				$user_subscription = mysql_query($user_subscription_query);
				
							
$order = "SELECT * FROM ser_trace where service_id = 7 AND Cus_num=$phoneNumber";

				$result = mysql_query($order);
				while ($row = mysql_fetch_array($result)){;
echo ("<img src='img/success.png' /> You Have Successfully
Subscribed in Daily Internet Service From  $to_date To $end_date");}







				

				
			} else {
				// not enough error message
				echo "<img src='img/error.png' /> not enough credit";
			}
			

			
			

}			

		}

if(isset($_POST["Activate8"]))							
{

		if ($count == 1 AND $service_id == 8) {
			echo "<img src='img/error.png' /> You Are already subscribed";
		}else{
			// check the user credit 
			
			
			$check_user_credit_query = "SELECT * FROM `user_information`
			                      WHERE `Cus_num` = $phoneNumber";

			$check_user_credit = mysql_query($check_user_credit_query);

			$row = mysql_fetch_array($check_user_credit);
			// user current credit 
			$user_credit = $row['Credit'];

			// select service cost from the table

			$check_service_cost = "SELECT * FROM `services` WHERE `Service_id` = $service_id ";
			$check_service_cost_query = mysql_query($check_service_cost);
			$service_row = mysql_fetch_array($check_service_cost_query);
			$service_cost = $service_row['Cost'];
			$service_period = $service_row['Period'];


			// check if user credit is enough to subscribe 
			if ($user_credit > $service_cost) {
				// enough do this

				//discard credit 
				$q = "SELECT * FROM `user_information` WHERE `Cus_num` = $phoneNumber";
				$res = mysql_query($q);
				$r = mysql_fetch_array($res);
				$my_old_credit = $r['Credit'];
				$my_new_credit = $my_old_credit - $service_cost ;

				// update credit of the user 
				$update_user_creidt_query = "UPDATE `user_information` 
									         SET `Credit`= $my_new_credit
									         WHERE `cus_num` = $phoneNumber ";
				$update_user_creidt = mysql_query($update_user_creidt_query);

				$to_date = date("d/m/y h:i:s " , time() + $service_period );
$end_date = date("d/m/y h:i:s" , time() + $service_period + 604800 );
				
				$user_subscription_query = "INSERT INTO `ser_trace`(`Cus_num`, `Service_id`, `From`, `To`)
				                            VALUES ( '$phoneNumber','$service_id' ,NOW(),'$to_date')";

				$user_subscription = mysql_query($user_subscription_query);
				
							
$order = "SELECT * FROM ser_trace where service_id = 8 AND Cus_num=$phoneNumber";

				$result = mysql_query($order);
				while ($row = mysql_fetch_array($result)){;
echo ("<img src='img/success.png' /> You Have Successfully
Subscribed in Weekly Internet Service From  $to_date To $end_date");}







				

				
			} else {
				// not enough error message
				echo "<img src='img/error.png' /> not enough credit";
			}
			

			}
			

			

		}












if(isset($_POST["Activate9"]))							
{



if ($count == 1 AND $service_id == 9) {
			echo "<img src='img/error.png' /> You Are already subscribed";
		}else{
			// check the user credit 
			
			
			$check_user_credit_query = "SELECT * FROM `user_information`
			                      WHERE `Cus_num` = $phoneNumber";

			$check_user_credit = mysql_query($check_user_credit_query);

			$row = mysql_fetch_array($check_user_credit);
			// user current credit 
			$user_credit = $row['Credit'];

			// select service cost from the table

			$check_service_cost = "SELECT * FROM `services` WHERE `Service_id` = $service_id ";
			$check_service_cost_query = mysql_query($check_service_cost);
			$service_row = mysql_fetch_array($check_service_cost_query);
			$service_cost = $service_row['Cost'];
			$service_period = $service_row['Period'];


			// check if user credit is enough to subscribe 
			if ($user_credit > $service_cost) {
				// enough do this

				//discard credit 
				$q = "SELECT * FROM `user_information` WHERE `Cus_num` = $phoneNumber";
				$res = mysql_query($q);
				$r = mysql_fetch_array($res);
				$my_old_credit = $r['Credit'];
				$my_new_credit = $my_old_credit - $service_cost ;

				// update credit of the user 
				$update_user_creidt_query = "UPDATE `user_information` 
									         SET `Credit`= $my_new_credit
									         WHERE `cus_num` = $phoneNumber ";
				$update_user_creidt = mysql_query($update_user_creidt_query);

				$to_date = date("d/m/y h:i:s " , time() + $service_period );
$end_date = date("d/m/y h:i:s" , time() + $service_period + 2592000 );
				
				$user_subscription_query = "INSERT INTO `ser_trace`(`Cus_num`, `Service_id`, `From`, `To`)
				                            VALUES ( '$phoneNumber','$service_id' ,NOW(),'$to_date')";

				$user_subscription = mysql_query($user_subscription_query);
				
							
$order = "SELECT * FROM ser_trace where service_id = 9 AND Cus_num=$phoneNumber";

				$result = mysql_query($order);
				while ($row = mysql_fetch_array($result)){;
echo ("<img src='img/success.png' /> You Have Successfully
Subscribed in Mothly Internet Service From  $to_date To $end_date");}





				

				
			} else {
				// not enough error message
				echo "<img src='img/error.png' /> not enough credit";
			}
			

			
}			

			

		}






















































	}




}


function unsubscripe($btn , $ser_id){

	if (isset($btn)) {
		$service_id = $ser_id;
		$phoneNumber = $_SESSION['phoneNumber'];
		$query = "SELECT *FROM `ser_trace` WHERE `Cus_num` = $phoneNumber AND `Service_id` = $service_id";
		$result = mysql_query($query);
		$count = mysql_num_rows($result);

		// check if customer subscribed or not 
		//if subscribed continue the proccess . 
		//if not subscribed send an error message tell the customer .

		if ($count == 1) {
			
			$unsubscripe_query = "DELETE FROM `ser_trace` 
			                      WHERE `Cus_num` = $phoneNumber AND `Service_id` = $service_id";

			$unsubscripe = mysql_query($unsubscripe_query);
			echo "<img src='img/success.png' /> You UnSubscribed Successfully";


		}else{
			echo "<img src='img/error.png' /> You Are already UnSubscribed";
		}
}

}

function download($btn , $id){

	

}