<?php
include("../dbinfo.php");
$no=0;
$workerId;
$name;
$relation;
$dob;
$recidingYN;
$address;
$city;
$pin;
$dist;
$state;
$flag_for_checking=false;

if(array_key_exists('workerid',$_GET)&& $_GET['workerid']!=0){
	$workerId=$_GET['workerid'];
	$mysql_query=mysql_query("select * from wfamilydetail where workerId='$workerId' order by id desc");
	if(mysql_num_rows($mysql_query)>0){
		$flag_for_checking=true;
	$POST=mysql_fetch_array($mysql_query);
	$workerId=$POST['workerId'];
	$name=$POST['name'];
	$relation=$POST['relation'];
	$dob=$POST['dob'];
	$recidingYN=$POST['recidingYN'];
	$address=$POST['address'];
	$city=$POST['city'];
	$pin=$POST['pin'];
	$dist=$POST['dist'];
	$state=$POST['state'];

	
	}
}
?>


        <form class="form-horizontal" action="javascript:addwfamilydetails()" id='addwfamilydetails' >
        <fieldset>

   <table>

            <tr>
        <td>
    <div class="control-group">
    <label class="control-label" for="inputName">Name</label>
    <div class="controls">
    <input type="text" id="inputName" placeholder="Name" name="name<?php echo $no?>" value="<?php if($flag_for_checking) echo $name?>">
    </div>
    </div>
    </td>
    
        <td>
    <div class="control-group">
    <label class="control-label" for="inputR">Relation</label>
    <div class="controls">
    <input type="text" id="inputR" placeholder="Relation" name="relation<?php echo $no?>" value="<?php if($flag_for_checking) echo $relation?>">
    </div>
    </div>
    </td>
    
        <td>
    <div class="control-group">
    <label class="control-label" for="inputDOB">DOB</label>
    <div class="controls">
    <input type="text" id="inputDOB" placeholder="DD-MM-YYYY" name="dob<?php echo $no?>" value="<?php if($flag_for_checking) echo $dob?>">
    </div>
    </div>
    </td>
    
    

    </tr>
    <tr>
           
    <td>
     <div class="control-group">
    <label class="control-label" for="inputRYN">Residing</label>
    <div class="controls">
    <input type="radio"  id="inputRYN" value='1' name="reciding<?php echo $no?>"  <?php if($flag_for_checking&&$recidingYN==1)echo "checked='checked'"; ?>>Yes
    <input type="radio" id="inputRYN"  value='0' name="reciding<?php echo $no?>"  <?php if($flag_for_checking&&$recidingYN==0)echo "checked='checked'"; ?>>No
   
    </div>
    </div>
    </td>
      <td>
    <div class="control-group">
    <label class="control-label" for="inputADD"> Address</label>
    <div class="controls">
    <textarea id="inputADD" placeholder="Address" rows="3" cols="50" name="address<?php echo $no?>" ><?php if($flag_for_checking) echo $address; ?></textarea>
    </div>
    </div>
    </td>
    <td>
    <div class="control-group">
    <label class="control-label" for="inputCity">City</label>
    <div class="controls">
    <select name="city<?php echo $no?>" id='inputCity' onChange="javascript:devd()">
    <?php if($flag_for_checking&&$city!='0'){

	$query=mysql_query("select city_name from cities where city_id='$city'");
	
	//if(mysql_num_rows($query>0)){
	$row=mysql_fetch_array($query);
	 $city_name=$row['city_name'];
	 echo     '<option value="'.$city.'">'.$city_name.'</option>';
	}
	else echo '<option value="0">Select City</option>';
	?>
    
    
    <option value="1090">Jodhpur</option>
    
    <?php

	$query_for_city_names=mysql_query("select city_name,city_id from cities where city_name!='Jodhpur' order by city_name asc");
	if(mysql_num_rows($query_for_city_names)>0){
		while($row_for_city_names=mysql_fetch_array($query_for_city_names)){
			$city_name=$row_for_city_names['city_name'];
			$cityid=$row_for_city_names['city_id'];
      echo '<option value="'.$cityid.'">'.$city_name.'</option>';
			
		}
		
	}
	?>
    </select>
    </div>
    </div>
    </td>
    
    </tr>
    <tr>
    
    
     <td>
    <div class="control-group">
    <label class="control-label" for="inputState">State</label>
    <div class="controls">
    <input type="text" id="inputState" placeholder="State" name='state<?php echo $no?>' value="<?php if($flag_for_checking&&$city!='0'){
			$query=mysql_query("select city_state from cities where city_id='$city'");
			//echo "select city_state from cities where city_id='$city'";
				$row=mysql_fetch_array($query);
			    $city_state=$row['city_state'];
				echo $city_state;
	}
	
	 ?>">
    </div>
    </div>
    </td>
    
    <td>
    <div class="control-group">
    <label class="control-label" for="inputPin">Pincode</label>
    <div class="controls">
    <input type="text" id="inputPin" placeholder="Pincode" name="pin<?php echo $no?>" value="<?php if($flag_for_checking) echo $pin;?>">
    </div>
    </div>
    </td>
    <td>
    <div class="control-group">
    <label class="control-label" for="inputD">District</label>
    <div class="controls">
    <input type="text" id="inputD" placeholder="District" name="dist<?php echo $no?>" value="<?php if($flag_for_checking) echo $dist;?>">
    </div>
    </div>
    </td>
    
    </tr>
    

       <div id='more_family'>
       
       <?php 
	include("../dbinfo.php");
	include("../editable_forms/family.php");
	if(array_key_exists('workerid',$_GET) && $_GET['workerid']!=0){
		$workerid=$_GET['workerid'];
		$noofrows=(mysql_query("select id from wfamilydetail where workerId='$workerid' order by id desc")); 
		$flag=1;
		if(mysql_num_rows($noofrows)>0){
			$row_for_id=mysql_fetch_array($noofrows);
			while($row_for_id=mysql_fetch_array($noofrows)){
				showform($row_for_id['id'],$flag);
				$flag++;	
				
			}
			
		}
	}
	?>
    </div>
    
    <tr>
    
    
    <td>
    </td>
    <td>
    </td>
    
    
    <td>
   <div class="control-group">
    <div class="controls">
    <label class="control-group">
	<a href="javascript:addmorefamily()">+ Add More Family Member</a><br  />
    <button type="submit" class="btn">Submit Details</button>
     </label>
    </div>
    </div>
    
    </td>
    
    </tr>
    </tbody>
    </table>
    </fieldset>
    </form>


<?php



?>