"; echo" "; echo" "; $title =""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $aRole = "SELECT * FROM `user_modules` WHERE `deleted`=0 ORDER BY `title_name`, `module_name` ASC"; $qRole = mysqli_query($conn,$aRole); while($row = mysqli_fetch_array($qRole)){ $canView = 0; $canAdd = 0; $canEdit = 0; $canDelete = 0; $canPrint=0; $canDownload=0; $moduleID = $row['id']; $varView = "canView".$searchID."".$moduleID; //Profile => module $varAdd = "canAdd".$searchID."".$moduleID; $varEdit = "canEdit".$searchID."".$moduleID; $varDelete = "canDelete".$searchID."".$moduleID; $varPrint = "canDelete".$searchID."".$moduleID; $varDownload = "canDelete".$searchID."".$moduleID; $chkAccess = "SELECT * FROM `user_profile_data` WHERE `profile_id`='$searchID' AND `module_id`='$moduleID' AND `deleted`=0"; $QchkAccess = mysqli_query($conn,$chkAccess); while($qC = mysqli_fetch_array($QchkAccess)){ $canView = $qC['can_view']; $canAdd = $qC['can_add']; $canEdit = $qC['can_edit']; $canDelete = $qC['can_delete']; $canDownload = $qC['download']; $canPrint = $qC['print']; } if($canView == 1){ $viewCheck = "checked"; }else{ $viewCheck = ""; } if($canAdd == 1){ $addCheck = "checked"; }else{ $addCheck = ""; } if($canEdit == 1){ $editCheck = "checked"; }else{ $editCheck = ""; } if($canDelete == 1){ $deleteCheck = "checked"; }else{ $deleteCheck = ""; } if($canDownload == 1){ $downloadCheck = "checked"; }else{ $downloadCheck = ""; } if($canPrint == 1){ $printCheck = "checked"; }else{ $printCheck = ""; } ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; }else{ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; $title = $row['title_name']; } echo "

ID	MAIN MENU	MODULE NAME	VIEW	ADD	EDIT	DELETE	PRINT	DOWNLOAD
	".$row['module_name']."	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	".$row['id']."	".$row['title_name']."	".$row['module_name']."	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "	"; echo ""; echo "

"; $conn->close(); } ?>