<?php
include 'connect.php';

$result = mysqli_query($link,"SELECT * FROM `users` LEFT JOIN `user_status` on users.status = user_status.id_status LEFT JOIN `user_grade` on users.grade = user_grade.id_grade LEFT JOIN `user_rate` on users.rate = user_rate.id_rate LEFT JOIN `team` on users.team = team.id_team LEFT JOIN `unit` on users.unit = unit.id_unit LEFT JOIN `section` on users.section = section.id_section ORDER BY users.id");
while($row = mysqli_fetch_array($result))
{
	echo '<div class="modal fade" id="edit'.$row['id'].'" tabindex="-1" role="dialog" aria-labelledby="edit" aria-hidden="true">
      <div class="modal-dialog">
    <div class="modal-content">
          <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span class="glyphicon glyphicon-remove" aria-hidden="true"></span></button>
        <h4 class="modal-title custom_align" id="Heading">'.$row['id'].'</h4>
      </div>
          <div class="modal-body">
          <div class="form-group">
		  <span class="input-group-addon">Username</span>
        <input class="form-control " type="text" placeholder="'.$row['username'].'">
        </div>
        <div class="form-group">
		<span class="input-group-addon">JoinDate</span>
        <input class="form-control " type="text" placeholder="'.$row['joindate'].'">
        </div>
        <div class="form-group">
		<span class="input-group-addon">Rate</span>';
	echo '<select name="seldrop'.$row['id'].'" id="seldrop'.$row['id'].'" class="form-control">';
	switch($row['status'])
	{
		case 1:
			echo '<option selected="selected" value="1">Applicant</option>
			<option value="2">Traning</option>
			<option value="3">Active</option>
			<option value="4">Retired</option>
			<option value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 2:
			echo '<option value="1">Applicant</option>
			<option selected="selected" value="2">Traning</option>
			<option value="3">Active</option>
			<option value="4">Retired</option>
			<option value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 3:
			echo '<option value="1">Applicant</option>
			<option value="2">Traning</option>
			<option selected="selected" value="3">Active</option>
			<option value="4">Retired</option>
			<option value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 4:
			echo '<option value="1">Applicant</option>
			<option value="2">Traning</option>
			<option value="3">Active</option>
			<option selected="selected" value="4">Retired</option>
			<option value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 5:
			echo '<option value="1">Applicant</option>
			<option value="2">Traning</option>
			<option value="3">Active</option>
			<option value="4">Retired</option>
			<option selected="selected" value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 6:
			echo '<option value="1">Applicant</option>
			<option value="2">Traning</option>
			<option value="3">Active</option>
			<option value="4">Retired</option>
			<option value="5">Discharged</option>
			<option selected="selected" value="6">On Hold</option>
			<option value="7">Denied</option>';
			break;
		case 7:
			echo '<option value="1">Applicant</option>
			<option value="2">Traning</option>
			<option value="3">Active</option>
			<option value="4">Retired</option>
			<option value="5">Discharged</option>
			<option value="6">On Hold</option>
			<option selected="selected" value="7">Denied</option>';
			break;
	}
	echo '</select>';
	echo '</div>
	</div>
	<div class="modal-footer">';
		echo '<button type="button" id="set'.$row['id'].'" class="btn btn-info btn-large" width="100%" onclick="loadDoc(this.id)">Save</button>
	<span class="glyphicon glyphicon-ok-sign"></span>Update</button>
    </div>
    </div>
	</div>
    </div>';
}

?>