<div class="form-group has-feedback">
<label class="col-sm-3 control-label">Implementation Date</label>
<div class="col-sm-9">
<strong>
<input type="text" value="' . $im_date . '" id="input_date" class="form-control" name="input_date" readonly>
</strong>
</div>
</div>
';
$body .= '</div>';
echo $body;
}
}
if ($action == "edit_findings") {
//query for assessment findings trans MASTERDATA
$query = view_findings();
$query .= " WHERE trans.id={$id} AND trans.is_deleted=0";
$result = mysql_query($query);
// echo $query;
//end for assesment masterdata
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$id = $row['id'];
$loc_id = $row['locale'];
$loc = $row['locale_id'];
$toa_id = $row['f_type_of_a'];
$toa = $row['toa_def'];
$date = dateletterformatmdy($row['date_of_assessment']);
$start = dateletterformatmdy($row['start_scope']);
$end = dateletterformatmdy($row['end_scope']);
$im_date = $row['im_date'];
$nc_id = $row['f_nc_class'];
function view_findings_cpar($id)
{
// $query = "SELECT trans.id, trans.locale, trans.remarks, l.locale_id, l.locale_name, trans.f_type_of_a, toa.toa_def,
// toa.toa_name, trans.date_of_assessment, trans.start_scope, trans.end_scope, trans.f_nc_class, ncc.nc_def,
// ncc.nc_name, trans.deviation, dt.dev, dl.dev_label, trans.root_cause_analysis, trans.is_deleted
// FROM assessment_findings trans
// LEFT JOIN locale l ON l.id = trans.locale
// LEFT JOIN type_of_assessment toa ON toa.toa_id = trans.f_type_of_a
// LEFT JOIN nc_classification ncc ON ncc.nc_id = trans.f_nc_class
// LEFT JOIN dev_table dt ON dt.id= trans.deviation
// LEFT JOIN dev_label dl ON dl.id= dt.lbl_id WHERE trans.id=$id";
$query = view_findings();
$query .= " WHERE trans.id={$id}";
$result = mysql_query($query);
$outputdata = array();
while ($row = mysql_fetch_assoc($result)) {
$outputdata = $row;
}
return $outputdata;
}
