<?php
// error_reporting(E_ALL);
// ini_set('display_errors', 1);

include "db-con.php";

$randomNumber = rand(100,999);

if (isset($_REQUEST['submit'])) {

	$member_id = "AISM-".$randomNumber;
	$member_name = $_POST['member_name'];
	$member_address = $_POST['member_address'];
	$issue_date = $_POST['issue_date'];
	$issue_date_change = date("Y-m-d", strtotime($issue_date));
	
	
	
    $issue_Cmonth = date("m", strtotime($issue_date));

    $issue_fyear = date("Y", strtotime($issue_date));

    $issue_Uyear= $issue_fyear+1;
    
	if($issue_Cmonth == 01 || $issue_Cmonth == 02 || $issue_Cmonth == 03){

//	echo $issue_fyear;

	}else{

//	echo $issue_Uyear;

	};

	$final_end_date = "31-03-".$issue_Uyear;

	// $end_date = $_POST['end_date'];
	
	$contiunue = "Lifetime";

	$membership_plan = $_POST['membership_plan'];

    $type_board_affiliation = $_POST['type_board_affiliation'];
    $status_school_management = $_POST['status_school_management'];
    $auth_details = $_POST['auth_details'];
    $contact_number = $_POST['contact_number'];
    $email = $_POST['email'];
	$member_no = $_POST['member_no'];

	// $date = '$issue_date';

	// $time 	= strtotime( $issue_date );
	// $day 	  = date('Y-m-d \w\a\s l', $time);
	// $day 	  = date('d-m-Y', $time);
	// $dayPre = date('d', $time)-(01);
	// $daymonth = date('m', $time);
	// $dayyear = date('Y', $time);
	// $endDate = $dayPre. "-" .$daymonth."-".$dayyear+1;

	if($membership_plan == "Annual"){

	// $insertData = "INSERT INTO `membership` (`member_id`, `member_name`, `member_address`, `issue_date`,  `end_date`, `membership_plan`, `member_no`) VALUES ('$member_id', '$member_name', '$member_address', '$issue_date', '$endDate', '$membership_plan', '$member_no')";	

	$insertData = "INSERT INTO `membership`(`member_id`, `member_name`, `member_address`, `issue_date`, `end_date`, `membership_plan`, `type_board_affiliation`, `status_school_management`, `authorised_person_contact_details`, `contact_number`, `email`, `member_no`) VALUES ('$member_id','$member_name','$member_address','$issue_date_change','$final_end_date','$membership_plan','$type_board_affiliation','$status_school_management','$auth_details','$contact_number','$email','$member_no')";	

	}else{

	$insertData = "INSERT INTO `membership` (`member_id`, `member_name`, `member_address`, `issue_date`,  `end_date`, `membership_plan`, `type_board_affiliation`, `status_school_management`, `authorised_person_contact_details`, `contact_number`, `email`, `member_no`) VALUES ('$member_id', '$member_name', '$member_address', '$issue_date_change', '$contiunue', '$membership_plan', '$type_board_affiliation', '$status_school_management', '$auth_details', '$contact_number', '$email', '$member_no')";

	}

	// $insertData = "INSERT INTO `membership` (`member_id`, `member_name`, `member_address`, `issue_date`,  `end_date`, `membership_plan`) VALUES ('$member_id', '$member_name', '$member_address', '$issue_date', '$end_date', '$membership_plan')";

    $result = $con->query($insertData) or die("query error");
	
    if ($result == TRUE) {

        $con->close();	

    	header("Location: https://ais.org.in/digitalcertificate/membership_form.php");

        exit;
   	

	}else{


	}




}


?>