Kitchen Config All
query($configsql); ?>
num_rows > 0) { // output data of each row while($rowkitch = $result->fetch_assoc()) { $KitchConfigID = $rowkitch["KitchConfigID"]; $KitchConfig = $rowkitch["KitchConfig"]; $KitchDesigner = $rowkitch["FirstName"]." ".$rowkitch["LastName"]; $KitchReason = $rowkitch["Reason"]; $KitchKeyNote = $rowkitch["KeyNote"]; $KitchComment = $rowkitch["Comment"]; $KitchStandard = $rowkitch["Standard"]; $KitchActiv = $rowkitch["Activ"]; //----------- Check Names instead óf ID Nr ---------- // -- Check ContactsID with CreatedBy and output Name $KitchCreated = $rowkitch["CreatedBy"]; $contactsql = ("SELECT * FROM `tbl_contacts` WHERE ContactID ='".$KitchCreated."'"); $contactsresult = $conn->query($contactsql); $rowcontacts = $contactsresult->fetch_assoc(); $KitchCreatedBy = $rowcontacts["FirstName"] ." ". $rowcontacts["LastName"]; $KitchCreatedDate = $rowkitch["CreatedDate"]; // -- Check ContactsID with LastEditBy and output Name $KitchLastEdit = $rowkitch["LastEditBy"]; $contactsql = ("SELECT * FROM `tbl_contacts` WHERE ContactID ='".$KitchLastEdit."'"); $contactsresult = $conn->query($contactsql); $rowcontacts = $contactsresult->fetch_assoc(); $KitchLastEditBy = $rowcontacts["FirstName"] ." ". $rowcontacts["LastName"]; $KitchLastEditDate = $rowkitch["LastEditDate"]; //----------- END Check Names ---------- if($KitchStandard==0){ $KitchStdDetail ="
"; } else{ $KitchStdDetail ="
"; } if($KitchActiv==0){ $KitchActChkBox="
"; $KitchActDetail ="
"; } else{ $KitchActChkBox="
"; $KitchActDetail ="
"; } echo (" "); // Start Modal // -- Modal echo("
".$KitchConfig."
×
Config Name:
"); $designersql = "SELECT * FROM `tbl_contacts` ORDER BY `FirstName`"; $resultdesigner = $conn->query($designersql); if ($resultdesigner->num_rows > 0) { $resultdesigner->MoveFirst; while($rowdesigner = $resultdesigner->fetch_assoc()) { $DesignerName = $rowdesigner["FirstName"]." ".$rowdesigner["LastName"]; $DesignerID = $rowdesigner["ContactID"]; if($rowdesigner["ContactID"]==$rowkitch["Designer"]){ echo("
".$DesignerName."
"); } else { echo("
".$DesignerName."
"); } } } echo("
Designer:
Reason:
".$KitchKeyNote."
Key Note:
".$KitchComment."
Comment:
".$KitchStdDetail."
Standard
".$KitchActDetail."
Activ
"); // -- End Modal --> // Ende Modal } } else { echo (" "); } //$conn->close(); ?>
Kitchen Config Name
Designer
Reason
Key Note
Active
" .$KitchConfig ."
" .$KitchDesigner ."
" .$KitchReason ."
" .$KitchKeyNote ."
" .$KitchActChkBox ."
No Datas found
Kitchen Config Name
Designer
Reason
Key Note
Active