Gecko [ 43.229.15.234 ]

Name	Size	Permission
ExpectedLastSal	[ DIR ]	drwxr-xr-x
FringerTham	[ DIR ]	drwxr-xr-x
SignetureSample	[ DIR ]	drwxr-xr-x
delcrearation	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
ajaxviewgrade.php	544 B	-rw-r--r--
general.php	26.11 KB	-rw-r--r--
general_allemp.php	13.46 KB	-rw-r--r--
general_editor.php	47.52 KB	-rw-r--r--
general_list.php	11.51 KB	-rw-r--r--
general_report.php	23.71 KB	-rw-r--r--
pdsreport.php	72.99 KB	-rw-r--r--

Code Editor : general_editor.php

<?php
 include("../homepage/header.php");
 include("../homepage/headermenu.php");
?>

<div class="container fullheight">
    <div class="row">
        <div class="col-md-12">
                <br/>
                <div><font class="headline">সাধারণ তথ্য যোগ করুন </font></div>

<div style="background-color: #ff0000;height: 2px">&nbsp;</div>
            
                <div align="right"><a href="general.php?cmd=list">লিস্ট দেখুন</a></font></div>

<div class="form-group">
                                <label class="col-md-4 control-label">নাম (বাংলায়)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" required name="NameB" id="NameB" value="<?=$NameB?>">                        
                                </div>
                            </div>
                            <div class="form-group">
                                <label class="col-md-4 control-label">নাম (ইংরেজিতে)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" required name="NameE" value="<?=$NameE?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label"> পিতার নাম (বাংলায়)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="FatherB"  id="FatherB" value="<?=$FatherB?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">পিতার নাম (ইংরেজিতে)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="FatherE"  value="<?=$FatherE?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">মাতার নাম (বাংলায়)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="MotherB" value="<?=$MotherB?>">                                                                      
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">মাতার নাম (ইংরেজিতে)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="MotherE" value="<?=$MotherE?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label"> জাতীয় পরিচয়পত্র </label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="NationalID" id="NationalID" value="<?=$NationalID?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">পাসপোর্ট নম্বর</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="PassportNo" id="PassportNo" value="<?=$PassportNo?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">পাসপোর্ট ইস্যুর তারিখ(দিন/মাস/বছর)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="PassIssueDate" id="PassIssueDate" value="<?=$PassIssueDate?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">পাসপোর্ট মেয়াদের শেষ তারিখ(দিন/মাস/বছর)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="PassLastDate" id="PassLastDate" value="<?=$PassLastDate?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">জন্ম তারিখ(দিন/মাস/বছর)</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" required name="dob" id="dob" value="<?=$dob?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">জন্ম সনদের  নম্বর</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="BirthCertificateNo" id="BirthCertificateNo" value="<?=$BirthCertificateNo?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">ব্যক্তিগত ইমেইল</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="PersonalEmail" id="PersonalEmail" value="<?=$PersonalEmail?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label"> অফিসিয়াল ইমেইল</label>
                                <div class="col-md-6">
                                <input type="text" class="form-control" name="OfficialEmail" id="OfficialEmail" value="<?=$OfficialEmail?>">                        
                                </div>
                            </div>

<div class="form-group">
                                <label class="col-md-4 control-label">জন্মস্থান (জেলার নাম)</label>
                                <div class="col-md-6">
                                
                                    <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM district");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();	
                                    
                                    ?>
                                <select  name="district_id" required id="district_id" class="form-control">
                                    <option value="">--Select--</option>
                                    <?php
                                    while($row = $result->fetch_assoc())
                                        { 
                                        ?>
                                    <option value="<?=$row["id"]?>" <?php if($row["id"]==$district_id){ echo "selected"; }?>><?=$row["DistrictName"]?>
                                    </option>
                                        <?php
                                           }
                                        $stmt->close();
                                     
                                        ?> 
                                </select>                        
                                </div>
                            </div>

<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান পদবী</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM designation ORDER BY grade_id");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="designation_id" required id="designation_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$designation_id){ echo "selected"; }?>><?=$row["DesignationName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">গ্রেড</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM grade");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="grade_id" id="grade_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$grade_id){ echo "selected"; }?>><?=$row["GradeName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">প্রধান প্রকৌশলীর কার্য্যালয়/তত্ত্বাবধায়ক প্রকৌশলীর কার্য্যালয়/নির্বাহী প্রকৌশলীর কার্য্যালয়</label>
                        <div class="col-md-6">
						   
							<?php
                            // prepare and bind
                            $stmt = $conn->prepare("SELECT * FROM districtoffice order by districtofficeName");
                            $stmt->execute();

//Result
                            $result = $stmt->get_result();
                            $numrows=$result->num_rows;

if($numrows==0) exit('No rows');

?>
						 <select  name="districtoffice_id" id="districtoffice_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
                               while($row = $result->fetch_assoc())
								  { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$districtoffice_id){ echo "selected"; }?>><?=$row["districtofficeName"]?>
							 </option>
								<?php
								  }
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান কর্মস্থল</label>
                        <div class="col-md-6">
						   
							 <?php
                                    if ($_SESSION["userrole_id"]==1)
                                    {
                                        $where="";
                                    }
                                    else{
                                        $where="where id=".$_SESSION["office_id"];
                                    }
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM office ");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="office_id" id="office_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$office_id){ echo "selected"; }?>><?=$row["OfficeName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">ক্যাডারের নাম</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="CaderName" value="<?=$CaderName?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">ক্যাডারে যোগদানের তারিখ(দিন/মাস/বছর)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="CaderDate" id="CaderDate" value="<?=$CaderDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">ব্যাচ নং</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="BatchNo" value="<?=$BatchNo?>">                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">মুক্তিযোদ্ধা কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM fredomfighter");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="FredomFighter_id" id="FredomFighter_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$FredomFighter_id){ echo "selected"; }?>><?=$row["FredomFighterName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">মুক্তিযোদ্ধার ছেলেমেয়ে/নাতিনাতনি কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM fredomchildgrand");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="FredomChildGrand_id" id="FredomChildGrand_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$FredomChildGrand_id){ echo "selected"; }?>><?=$row["FredomChildGrandName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">উপজাতি হলে নাম</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM triballist");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="triballist_id" id="triballist_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$triballist_id){ echo "selected"; }?>><?=$row["TriballistName"]?>
							 </option>
								<?php
                                           }
								$stmt->close();
                             
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">লিঙ্গ পরিচয়</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM sex");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="sex_id" id="sex_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$sex_id){ echo "selected"; }?>><?=$row["SexName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">বৈবাহিক অবস্থা</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM maritualstatus");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="MaritualStatus_id" id="MaritualStatus_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$MaritualStatus_id){ echo "selected"; }?>><?=$row["MaritualStatusName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>
					
				
					<div class="form-group">
                        <label class="col-md-4 control-label">ধর্ম</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM religion");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="religion_id" id="religion_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$religion_id){ echo "selected"; }?>><?=$row["religionName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

</div>
                    <div class="col-md-6">

<div class="form-group">
                        <label class="col-md-4 control-label">সর্বশেষ শিক্ষাগত যোগ্যতা</label>
                        <div class="col-md-6">
						   
                        <?php
                            // prepare and bind
                            $stmt = $conn->prepare("SELECT * FROM profsubject");
                            $stmt->execute();

//Result
                            $result = $stmt->get_result();								
                        ?>
						 <select  name="profsubject_id" id="profsubject_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$profsubject_id){ echo "selected"; }?>><?=$row["profsubjectName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান বেতন স্কেল</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM grade");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="CurrScale_id" id="CurrScale_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$CurrScale_id){ echo "selected"; }?>><?=$row["PayScale"]?>
							 </option>
								<?php
                                            }
								$stmt->close();
                            
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">মূল বেতন</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="SalBasic" value="<?=$SalBasic?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">প্রথম নিয়োগের ধরণ</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM emptype");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="emptype_id" id="emptype_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$emptype_id){ echo "selected"; }?>><?=$row["EmptypeName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">প্রকল্পে নিয়োগ হলে প্রকল্পের নাম</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="ProjectName" value="<?=$ProjectName?>">                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label"> বর্তমান নিয়োগের ধরণ</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM emptype");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="emptypenow_id" id="emptypenow_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$emptypenow_id){ echo "selected"; }?>><?=$row["EmptypeName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">চাকুরিতে প্রথম যোগদানের তারিখ(দিন/মাস/বছর)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="FirstJoinDate" id="FirstJoinDate" required value="<?=$FirstJoinDate?>">                        
                        </div>
                    </div>
					
                    <div class="form-group">
                        <label class="col-md-4 control-label">মেধা ক্রম</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="meritno" value="<?=$meritno?>">                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">শিক্ষা প্রকৌশল অধিদপ্তরে যোগদানের তারিখ(দিন/মাস/বছর)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="EedJoinDate" id="EedJoinDate" value="<?=$EedJoinDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">শিক্ষা প্রকৌশল অধিদপ্তরে বর্তমান পদবীতে যোগদানের তারিখ(দিন/মাস/বছর)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="EedCDJoinDate" id="EedCDJoinDate" value="<?=$EedCDJoinDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান কর্মস্থলে যোগদানের তারিখ(দিন/মাস/বছর)</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="CLJoinDate" id="CLJoinDate" value="<?=$CLJoinDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label"> পূর্ববর্তী কর্মস্থলে যোগদানের তারিখ (দিন/মাস/বছর) </label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="PLJoindate"  id="PLJoindate" value="<?=$PLJoindate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label"> চাকুরি নিয়মিতকরনের তারিখ(দিন/মাস/বছর) </label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="RegularDate" id="RegularDate" value="<?=$RegularDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label"> চাকুরি স্থায়ীকরনের তারিখ(দিন/মাস/বছর) </label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="PermanentDate"  id="PermanentDate" value="<?=$PermanentDate?>">                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">সরকারী বাসায় থাকেন কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM govtresident");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="GovtResident_id" id="GovtResident_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$GovtResident_id){ echo "selected"; }?>><?=$row["GovtResidentName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">অবসরের সময় পদবি </label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM designation");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="LprDesignation_id" id="LprDesignation_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$LprDesignation_id){ echo "selected"; }?>><?=$row["DesignationName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">অবসরে যাওয়ার সময় মূল বেতন</label>
                        <div class="col-md-6">
						   <input type="text" class="form-control" name="AnutoshikClass" value="<?=$AnutoshikClass?>">                        
                        </div>
                    </div>
					
				
					
					<div class="form-group">
                        <label class="col-md-4 control-label">টেলিফোন বিল পরিশোধ কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM teliphone");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="Teliphone_id" id="Teliphone_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$Teliphone_id){ echo "selected"; }?>><?=$row["TeliphoneName"]?>
							 </option>
								<?php
                                           }
								$stmt->close();
                             
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">বিদ্যুৎ বিল পরিশোধ কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM electricitybill");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="ElectricityBill_id" id="ElectricityBill_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$ElectricityBill_id){ echo "selected"; }?>><?=$row["ElectricityBillName"]?>
							 </option>
								<?php
                                         }
								$stmt->close();
                               
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">গাড়ী ভাড়া পরিশোধ কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM vhechilefair");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="Vhechilefair_id" id="Vhechilefair_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$Vhechilefair_id){ echo "selected"; }?>><?=$row["VhechilefairName"]?>
							 </option>
								<?php
                                           }
								$stmt->close();
                             
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">বাড়ী ভাড়া পরিশোধ কি না?</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM houserent");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="HouseRent_id" id="HouseRent_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$HouseRent_id){ echo "selected"; }?>><?=$row["HouseRentName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">উত্তরাধিকারীর ঘোষনা পত্র </label>
                        <div class="col-md-6">
						   <input type="file" class="form-control" name="delcrearation" >                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">প্রত্যাশিত শেষ বেতনের সনদ(ই এল পি সি)</label>
                        <div class="col-md-6">
						   <input type="file" class="form-control" name="ExpectedLastSal" >                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">যানবাহন ব্যবহারের তথ্য</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM vheinfo");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="VheInfo_id" id="VheInfo_id" class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$VheInfo_id){ echo "selected"; }?>><?=$row["VheInfoName"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>
					
					<div class="form-group">
                        <label class="col-md-4 control-label">আঙ্গুলের ছাপ</label>
                        <div class="col-md-6">
						   <input type="file" class="form-control" name="FringerTham" >                        
                        </div>
                    </div>
					
				
					
					<div class="form-group">
                        <label class="col-md-4 control-label">নমুনা স্বাক্ষর</label>
                        <div class="col-md-6">
						   <input type="file" class="form-control" name="SignetureSample" >                        
                        </div>
                    </div>

<div class="form-group">
                        <label class="col-md-4 control-label">বর্তমান অবস্থা</label>
                        <div class="col-md-6">
						   
							 <?php
                                    // prepare and bind
                                    $stmt = $conn->prepare("SELECT * FROM status");
                                    $stmt->execute();

//Result
                                    $result = $stmt->get_result();								
							 ?>
						 <select  name="status_id" id="status_id" required class="form-control">
							<option value="">--Select--</option>
							   <?php
								while($row = $result->fetch_assoc())
                                        { 
								?>
							 <option value="<?=$row["id"]?>" <?php if($row["id"]==$status_id){ echo "selected"; }?>><?=$row["statusname"]?>
							 </option>
								<?php
                                          }
								$stmt->close();
                              
								?> 
						</select>                        
                        </div>
                    </div>

<div class="form-group">
                                <div class="col-md-6 col-md-offset-4">
                                <input type="hidden" name="cmd" value="add">
                                <input type="hidden" name="id" value="<?=$Id?>">	
                                <button type="submit" class="btn btn-primary">
                                <i class="fa fa-btn fa-sign-in"></i>Submit
                                </button>
                                </div>
                            </div>

</div>
                   </form>                
             </div>
          </div>
        </div>
    </div>
</div>
<script type="text/javascript">
     $('#PassIssueDate').datepicker({
         dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#PassLastDate').datepicker({
         dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#dob').datepicker({
            dateFormat:"dd/mm/yy",
           changeMonth: true,
           changeYear: true,
           yearRange: "1955:2040"
        })

$('#CaderDate').datepicker({
         dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#FirstJoinDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#EedJoinDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#EedCDJoinDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#CLJoinDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#PLJoindate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#RegularDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

$('#PermanentDate').datepicker({
            dateFormat:"dd/mm/yy",
         changeMonth: true,
         changeYear: true,
         yearRange: "1955:2040"
        })

</script>

if(districtoffice_id) {

$.ajax({
            url: "../userinfo/ajaxview.php",
            dataType: 'Json',
            data: {'districtoffice_id':districtoffice_id},
            success: function(data) {
                $('select[name="office_id"]').empty();
                $.each(data, function(key, value) {
                    $('select[name="office_id"]').append('<option value="'+ key +'">'+ value +'</option>');
                });
            }
        });

}else{
        $('select[name="office_id"]').empty();
    }
});

//GRADE
$( "select[name='designation_id']" ).change(function () {
    var designation_id = $(this).val();

if(designation_id) {

$.ajax({
            url: "ajaxviewgradennnnn.php",
            dataType: 'Json',
            data: {'designation_id':designation_id},
            success: function(data) {
                $('select[name="grade_id"]').empty();
                $.each(data, function(key, value) {
                    $('select[name="grade_id"]').append('<option value="'+ key +'">'+ value +'</option>');
                });
            }
        });

}else{
        $('select[name="grade_id"]').empty();
    }
});

</script>

<?php
 include("../homepage/footer.php");
?>

${this.title}

Code Editor : general_editor.php