<?php
session_start();
// ============
include ("../../asset/theme/css/myfunc.php");
include ("../../php_crud/my_class.php");
$obj = new my_class();
// ============
$branchid = $_SESSION['LOGIN_BRANCH'];
extract($_GET);
//echo"hellow";
$litho_info = $obj->Details_By_Cond("HYDROLOGY.BLPUMP_TBL@HYDRO10", "WELL_ID='$well_id'");
// print_r($litho_info);
$upzila = $litho_info['UPZL_CODE'];
$upz_info = $obj->Details_By_Cond("HYDROLOGY.UPAZILA_TBL@HYDRO10", "UPZL_CODE='$upzila'");
// print_r($upz_info);
$upz_name = $upz_info['UPZL_NAME'];
$well_data_type = $litho_info['WELL_DATA_TYPE'];
$well_typ_name = $obj->Details_By_Cond("HYDROLOGY.GWM_STATION_TYPE@HYDRO10", "ID='$well_data_type'");
//print_r($well_typ_name);
$sub_div = $litho_info['SUBDIVISION'];
$wel_type_nm = $well_typ_name['TYPE_NAME'];
$subdiv_name = $obj->Details_By_Cond("HYDROLOGY.GW_SUBDIVCODE_TBL@HYDRO10", "HYDSUBDIVCODE='$sub_div'");
$subdivision_name = $subdiv_name['SUBDIVISION_NAME'];
$start_date = $subdiv_name['START_DT'];
$end_date = $subdiv_name['END_DT'];
$number_of_well = $litho_info['NUMBER_OF_OBS_WELL'];
$well_id = $litho_info['WELL_ID'];
$pre_reg_no = $litho_info['PREREG_NO'];
$tube_well_no = $litho_info['TUBEWELL_NO'];
$well_type = $litho_info['WELL_TYPE'];
$mouza = $litho_info['MOUZA'];
$village = $litho_info['VILLAGE'];
$site = $litho_info['SITE'];
$jl_no = $litho_info['JL_NO'];
$plot_no = $litho_info['PLOT_NO'];
$lat = $litho_info['LATITUDE'];
$lon = $litho_info['LONGITUDE'];
$rl = $litho_info['RL'];
$depth = $litho_info['DEPTH'];
$housing_length = $litho_info['HOUSING_LNTH'];
$housing_dia = $litho_info['HOUSING_DIA'];
$strainer_from_to = $litho_info['STRAINER_FRMTO'];
$strainer_lnth = $litho_info['STRAINER_LNTH'];
$strainer_dia = $litho_info['STRAINER_DIA'];
$blindpipe_length = $litho_info['BLINDPIPE_LTH'];
$blindpipe_dia = $litho_info['BLINDPIPE_DIA'];
$bailplug_length = $litho_info['BAILPLUG_LTH'];
$reducer_length = $litho_info['REDUCER_LTH'];
$hole_id = $litho_info['HOLE_ID'];
$pump_type = $litho_info['PUMP_TYPE'];
$well_dia = $litho_info['WELL_DIA'];
$agency_code = $litho_info['AGENCY_CODE'];
$unit = $litho_info['UNIT'];
$purpose = $litho_info['PURPOSE'];
$note = $litho_info['NOTE'];
$grnd_elev = $litho_info['GRND_ELEV'];
$methd_of_sampling = $litho_info['METHOD_OF_SAMPLING'];
$geologist = $litho_info['GEOLOGIST'];
// $unit = $litho_info['UNIT'];
?>
<div class="row-fluid">
	<table style="width: 100%; border-collapse: collapse; padding-left: 5px;">
		<tr>
			<th style="text-align: right; width: 20%;">Well ID: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $well_id; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;"> Well Data Type: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $wel_type_nm; ?></td>
			<th style="text-align: right; width: 20%;">&nbsp;&nbsp;&nbsp;</th>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
			<th style="text-align: right; width: 20%;"> Subdivision : </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $subdivision_name ; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Upzila: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $upz_name; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<!-- <tr>
			<th style="text-align: right; width: 20%;">Start Date: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php //echo "&nbsp;" . $start_date; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">End Date: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php //echo "&nbsp;" .$end_date; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr> -->
		<!-- <tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr> -->
		<tr>
			<th style="text-align: right; width: 20%;">Latitude: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $lat; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Longitude: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $lon; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
			<th style="text-align: right; width: 20%;">Total Drilling Depth: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $depth; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Ground Elevation: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $grnd_elev; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Purpose: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $purpose; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">RL: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $rl; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
			
			<th style="text-align: right; width: 20%;">JL No: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $jl_no; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Housing Length: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $housing_length; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Plot No: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $plot_no ?></td>
			
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Housing Dia: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $housing_dia; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Mouza: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $mouza; ?></td>
			
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">No. of Obs. Well: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $number_of_well; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		
		
			<th style="text-align: right; width: 20%;">Village: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $village; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Strainer From to: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $strainer_from_to; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Pre Reg. No: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $pre_reg_no; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Strainer Dia: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $strainer_dia; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Location: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $site; ?></td>
		
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Strainer Length: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $strainer_lnth; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
			<th style="text-align: right; width: 20%;">Hole Id: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $hole_id; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Blindpipe Length: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $blindpipe_length; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
			<th style="text-align: right; width: 20%;">Method Of Sampling: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $methd_of_sampling; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Blindpipe Dia: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $blindpipe_dia; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>
		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Geologist: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $geologist; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Bailplug Length: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $bailplug_length; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>

		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;">Remark: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $note; ?></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Pump Type: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $pump_type; ?></td>
		
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>

		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;"> </th>
			<td style="width: 28%; "></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Reducer Length: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $reducer_length; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>

		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
		<tr>
		<th style="text-align: right; width: 20%;"> </th>
			<td style="width: 28%;"></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Well Dia: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $well_dia; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>

		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>	
		<tr>
		<th style="text-align: right; width: 20%;"> </th>
			<td style="width: 28%; "></td>
			<td style="width: 4%;">&nbsp;&nbsp;&nbsp;</td>
			<th style="text-align: right; width: 20%;">Unit: </th>
			<td style="width: 28%; border-bottom: 1px dotted;"><?php echo "&nbsp;" . $unit; ?></td>
			<td style="width: 28%;">&nbsp;&nbsp;&nbsp;</td>

		</tr>
		<tr>
			<td colspan="6">&nbsp;&nbsp;&nbsp; </td>
		</tr>
	</table>
</div>