// $output = view_findings_cpar(179);
// print "<pre>";
// print_r($output);
// print "</pre>";
$query = assessment_findings_compilation($loc, $grp, $cred);
// echo $query;
$result = mysql_query($query) or die('query failed ' . mysql_error());
// echo $query;
// echo 'panget';
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$id = $row['id'];
$loc = $row['locale_id'];
$toa = $row['toa_def'];
$date = dateletterformatmdy($row['date_of_assessment']);
$start = dateletterformatmdy($row['start_scope']);
$end = dateletterformatmdy($row['end_scope']);
$dev_text = $row['dev_label'] . ' - ' . $row['dev'];
$nc = $row['nc_def'];
$stt = $row['cpar_status'];
$dev = $row['deviation'];
$rca = $row['root_cause_analysis'];
$rem = $row['remarks'];
$tab = '<tr class="vert-align">
<td >
' . $loc . '
</td>
<td>
' . $toa . '
</td>
<td>
' . $date . '
$cp = $row['cp_act'];
// end assessment findings //
// emp //
$dept = $row2[0]['group_name'];
$last = $row3[0]['last'];
$first = $row3[0]['first'];
$middle = $row3[0]['middle'];
$emp = $last . ' ' . $first . ' ' . $middle;
//end emp //
// dept //
// end dept//
if ($im_date == "0000-00-00") {
$im_date = '';
$dept = '';
} else {
$im_date = dateletterformatmdy($row['im_date']);
}
// print "<pre>";
// print_r($row);
// print "</pre>";
// Initalize the TBS instance
$TBS = new clsTinyButStrong();
// new instance of TBS
$TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
// load the OpenTBS plugin
$TBS->VarRef['dept'] = $dept . ' Department';
$TBS->VarRef['emp'] = $emp;
$TBS->VarRef['doa'] = $date_of_assessment;
$TBS->VarRef['lbl'] = $dev_label . ': ';
$TBS->VarRef['pnp'] = $dev_label;
$TBS->VarRef['dev'] = $dev;
