$branchID = $_GET["branchID"];
$dsn = "dsn_bank_security";
$dbConnectionID = odbc_connect ( $dsn, "app_user", "D0m@monitoring");
if (!$dbConnectionID)
{
die("Could Not Connect to DB" . mysql_error());
}
$query = "SELECT tblCheckListItem.item_id, tblItem.Description, item_status_branch, CONVERT (varchar(10), [record_date_branch], 104) As record_date_branch, item_status_dpo, remarks_dpo, ISNULL( CONVERT (varchar(10), [record_date_dpo], 104), '') AS record_date_dpo, tblUser.user_name FROM tblCheckListItem LEFT OUTER JOIN tblUser on tblCheckListItem.dpo_user_id = tblUser.user_id, tblItem where tblCheckListItem.item_id = tblItem.item_id and tblCheckListItem.branch_id = 601 order by tblCheckListItem.item_id, record_date_branch";
// echo $query;
$result = odbc_exec ( $dbConnectionID, $query);
?>
Sr. No. |
Item |
Status by Branch |
Branch's Status Updation Date |
Verification by DPO |
Remakrs by DPO (If any) |
DPO's Status Updation Date |
DPO User Name |
$counter = 1;
$previousItemID = $currentItemID = "";
while (odbc_fetch_row( $result))
{
$currentItemID = odbc_result($result, "item_id");
if( $currentItemID == $previousItemID )
{
echo "";
echo "- | ";
echo "- | ";
}
else
{
echo " ";
echo "". $counter ." | ";
echo " ". odbc_result($result, "description") ." | ";
++$counter;
}
echo " ". odbc_result($result, "item_status_branch") ." | ";
echo " ". odbc_result($result, "record_date_branch") ." | ";
echo "". odbc_result($result, "item_status_dpo") ." | ";
echo "". odbc_result($result, "remarks_dpo") ." | ";
echo "". odbc_result($result, "record_date_dpo") ." | ";
echo "". odbc_result($result, "user_name") ." | ";
echo " ";
$previousItemID = $currentItemID ;
}
mysql_close($dbConnectionID);
if ($counter == 1)
{
echo " ";
echo "No Security Measures uploaded by the Branch | ";
echo " ";
}
?>
|