Skip to content

Instantly share code, notes, and snippets.

@arun12209
Created July 23, 2023 11:23
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save arun12209/9d118699526281f94e3d865c4d6370c0 to your computer and use it in GitHub Desktop.
permissionsExplorer.js
import { LightningElement, wire ,track} from 'lwc';
import getPermissionSets from '@salesforce/apex/PermissionSetController.getPermissionSets';
import getPermissions from '@salesforce/apex/PermissionSetController.getPermissions';
import { loadScript, loadStyle } from 'lightning/platformResourceLoader';
import SheetJS from '@salesforce/resourceUrl/SheetJS'; // The static resource for SheetJS
export default class PermissionsExplorer extends LightningElement {
selectedPermissionSet;
isLoading = false;
permissionSetOptions = [];
@track objectPermissions = [];
async connectedCallback() {
await loadScript(this, SheetJS); // load the library
// At this point, the library is accessible with the `XLSX` variable
this.version = XLSX.version;
console.log('version: '+this.version);
}
@wire(getPermissionSets)
wiredPermissionSets({ error, data }) {
if (data) {
this.permissionSetOptions = data.map((item) => {
return { label: item.Name, value: item.Id };
});
} else if (error) {
console.error('Error fetching permission sets: ', error);
}
}
handlePermissionSetChange(event) {
this.selectedPermissionSet = event.detail.value;
if (this.selectedPermissionSet) {
this.isLoading = true; // Show the spinner when the user selects a permission set
this.fetchObjectPermissions(this.selectedPermissionSet);
} else {
this.objectPermissions = [];
}
}
fetchObjectPermissions(permissionSetId) {
getPermissions({ permissionSetId: permissionSetId })
.then((data) => {
this.objectPermissions = this.prepareObjectPermissions(data);
this.isLoading = false; // Hide the spinner when data is fetched successfully
})
.catch((error) => {
console.error('Error fetching permissions: ', error);
this.isLoading = false; // Hide the spinner when data is fetched successfully
});
}
prepareObjectPermissions(data) {
let preparedData = [];
for (const objectName in data) {
if (data.hasOwnProperty(objectName)) {
const sheetData = data[objectName];
for (const record of sheetData) {
preparedData.push({
SObjectType: record.SObjectType,
PermissionsRead: record.PermissionsRead,
PermissionsCreate: record.PermissionsCreate,
PermissionsEdit: record.PermissionsEdit,
PermissionsDelete: record.PermissionsDelete,
PermissionsViewlAll: record.PermissionsViewlAll,
PermissionsModifyAll: record.PermissionsModifyAll,
});
}
}
}
return preparedData;
}
handleGenerateExcel() {
getPermissions({ permissionSetId: this.selectedPermissionSet })
.then((data) => {
this.downloadExcel(data);
})
.catch((error) => {
console.error('Error fetching permissions: ', error);
});
}
downloadExcel(data) {
const filename = 'PermissionSetPermissions.xlsx';
const workbook = XLSX.utils.book_new();
const headers = [];
const worksheetData = [];
for (const objectName in data) {
if (data.hasOwnProperty(objectName)) {
const sheetData = data[objectName];
for (const record of sheetData) {
worksheetData.push({
"Object": record.SObjectType,
"Read": record.PermissionsRead,
"Create":record.PermissionsCreate,
"Edit": record.PermissionsEdit,
"Delete": record.PermissionsDelete,
"View All": record.PermissionsViewlAll,
"Modify All": record.PermissionsModifyAll,
});
}
}
}
const worksheet = XLSX.utils.json_to_sheet(worksheetData, { header: headers });
XLSX.utils.book_append_sheet(workbook, worksheet, 'Object Permissions');
const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
const blob = new Blob([excelBuffer], { type: 'application/octet-stream' });
// Create a download link and click it programmatically to initiate the download
const a = document.createElement('a');
a.href = URL.createObjectURL(blob);
a.download = filename;
a.click();
// Release the object URL to free up memory
URL.revokeObjectURL(a.href);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment