OK - I have an application where I am pulling a single row, populating the grind, and then pulling data within the expanded row. Everything was working perfectly until the 'expanded' data extended below the window size and scrollbars appeared. Now what happens in the original row, with the plus or minus to expand (remember this is a single row, will never be more than 1 row) will scroll up and down and disappear / reappear as I scroll. However the additional data that is pulled, i.e. the 'expanded' data, will not scroll. It says put where it is. The bottom is cut off by the window so you can never see the bottom, and cannot scroll to it.
I have searched the web, and cannot find a resolution to this.
Datagrid code
<table id="wells" class="easyui-datagrid" title="<?php echo "$wellname $wellnum"; ?>" style="width:100%;height:300px"
pagination="false" idField="api" fitColumns="true" url="getwell.php?api=<?php echo $api; ?>"
collapsible="true" singleSelect="true" resizeHandle="both"
autoRowHeight="true" nowrap="false">
<thead>
<tr>
<th data-options="field:'well_name',width:48" sortable='true'>Name</th>
<th data-options="field:'well_num',width:18" sortable='true'>Num</th>
<th data-options="field:'field',width:48" sortable="true">Field</th>
<th data-options="field:'pad',width:36" sortable="true">Pad</th>
<th data-options="field:'api',width:32" sortable="true">API</th>
<th data-options="field:'legal_description',width:46" sortable="true">Legal</th>
<th data-options="field:'county_state',width:40" sortable="true">County, State</th>
<th data-options="field:'lease',width:33" sortable="true">Lease</th>
<th data-options="field:'unit_ca_pa',width:57" sortable="true">Unit CA PA</th>
<th data-options="field:'status',width:27">Status</th>
<th data-options="field:'status_date',width:22">Updated</th>
<th data-options="field:'wildlife_stips',width:75">Wildlife Stips</th>
<th data-options="field:'notes',width:75">Notes</th>
</tr>
</thead>
</table>
Row to call / expand the row
<script type="text/javascript">
$('#wells').datagrid(
{
view: detailview,
detailFormatter:function(index,row)
{return '<div class="ddv" style="padding:5px 0"></div>';},
onExpandRow: function(index,row)
{
var ddv = $(this).datagrid('getRowDetail',index).find('div.ddv');
ddv.panel(
{
border:false,
cache:false,
href:'getexpandwell.php?api='+row.api,
onLoad:function()
{ $('#wells').datagrid('fixDetailRowHeight',index); }
});
$('#wells').datagrid('fixDetailRowHeight',index);
},
onLoadSuccess: function(data){
if (data.rows.length){
$(this).datagrid('expandRow', 0);
}
}
});
</script>
And last but not least, the code that is called in getexpandwell.php which is the data that populates / displays for the expanded row (yes it is 3 different groups of data, and works FANTASTIC, except this little problem...
)
<?php
include("../Includes/aedclass.php");
$nconn = new WorkData();
$conn = new PDO ($nconn->DB_DSN,$nconn->DB_USER,$nconn->DB_PASSWORD);
$api = $_REQUEST['api'];
?>
<?php
//additional well info
echo "<hr>";
$sql = "select location, NorthSouth, EastWest, latitude, longitude, lot, tract
from master_well_list where api='$api' order by location desc;";
$stmt = $conn->prepare($sql);
$stmt->execute();
//echo "<table class='dv-table' border='0' style='width:100%;'>";
echo "<table class='dv-table' border='0'>";
while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT))
{
echo "<tr>\n";
echo "<td class='dv-label'>Location: </td>\n";
echo "<td>$row[0]</td>\n";
echo "<td class='dv-label'>N+S-:</td>\n";
echo "<td>$row[1]</td>\n";
echo "<td class='dv-label'>E+W-: </td>\n";
echo "<td>$row[2]</td>\n";
echo "<td class='dv-label'>Latitude:</td>\n";
echo "<td>$row[3]</td>\n";
echo "<td class='dv-label'>Longitude:</td>\n";
echo "<td>$row[4]</td>";
echo "<td class='dv-label'>Lot:</td>\n";
echo "<td>$row[5]</td>\n";
echo "<td class='dv-label'>Tract:</td>\n";
echo "<td>$row[6]</td>\n";
echo "</tr>";
}
echo "</table>";
//excalibur account info
echo "<hr>";
$sql = "SELECT excal_well_numbers.excal_well_name, excal_well_numbers.excal_acct_num, partner.partner_name, partner_percent.percnt, Max(partner_percent.effective_date) as 'effective_date' FROM wexwellconfig.dbo.excal_well_numbers excal_well_numbers, wexwellconfig.dbo.master_well_list master_well_list, wexwellconfig.dbo.partner partner, wexwellconfig.dbo.partner_percent partner_percent WHERE partner_percent.excal_acct_num = excal_well_numbers.excal_acct_num AND partner_percent.partner_num = partner.partner_num AND master_well_list.api_no_dash = excal_well_numbers.api AND ((master_well_list.api='$api') AND (master_well_list.location='SHL')) GROUP BY excal_well_numbers.excal_well_name, excal_well_numbers.excal_acct_num, partner.partner_name, partner_percent.percnt ORDER BY excal_well_numbers.excal_acct_num, partner_percent.percnt desc;";
$stmt = $conn->prepare($sql);
$stmt->execute();
echo "<table class='dv-table' border='0'>";
while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT))
{
echo "<tr>\n";
echo "<td class='dv-label'>Excal Well Name: </td>\n";
echo "<td>$row[0]</td>\n";
echo "<td class='dv-label'>Excal Well Num:</td>\n";
echo "<td>$row[1]</td>\n";
echo "<td class='dv-label'>Partner: </td>\n";
echo "<td>$row[2]</td>\n";
echo "<td class='dv-label'>Percent:</td>\n";
echo "<td>$row[3]</td>\n";
echo "<td class='dv-label'>Effective Date:</td>\n";
echo "<td>$row[4]</td>";
echo "</tr>";
}
echo "</table>";
//file attachment info
echo "<hr>";
$sql = "SELECT file_name, file_type, size, description, First, Last from file_attachment, users where users.userid = file_attachment.userid and (type='WBD') and api='$api' ORDER BY file_name desc;";
$stmt = $conn->prepare($sql);
$stmt->execute();
echo "<table class='dv-table' border='0'>";
while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT))
{
echo "<tr>\n";
echo "<td class='dv-label'>File Name: </td>\n";
echo "<td><a href='get.php?id=" . urlencode($row[0]) . "'>$row[0]</a></td>\n";
echo "<td class='dv-label'>File Type:</td>\n";
echo "<td>$row[1]</td>\n";
echo "<td class='dv-label'>Size: </td>\n";
echo "<td>$row[2]</td>\n";
echo "<td class='dv-label'>Description:</td>\n";
echo "<td>$row[3]</td>\n";
echo "<td class='dv-label'>Name Posted</td>\n";
echo "<td>$row[5], $row[4]</td>";
echo "</tr>";
}
echo "</table>";
