<?xml version="1.0" encoding="UTF-8"?>
<LightningComponentBundle xmlns="http://soap.sforce.com/2006/04/metadata" fqn="myLWCComponent">
	<apiVersion>62.0</apiVersion>
	<isExposed>true</isExposed>
	<masterLabel>Generic Data Table</masterLabel>
	<description>A generic data table LWC component.</description>
	<targets>
		<target>lightning__AppPage</target>
		<target>lightning__RecordPage</target>
		<target>lightning__HomePage</target>
		<target>lightningCommunity__Page</target>
		<target>lightningCommunity__Default</target>
		<target>lightning__Tab</target>
	</targets>
	<targetConfigs>
		<targetConfig targets="lightning__AppPage,lightning__RecordPage,lightning__HomePage">
			<property name="fields" label="Fields Api Names" type="String"
				default="Name,Phone,CreatedDate"
				description="Enter a comma-separated list of field api names to display in the table, 
				like Name,CreatedDate,CustomField__c." />
			<property name="fieldsLabels" label="Fields Labels" type="String"
				default="Name,Phone,Created Date"
				description="Enter a comma-separated list of field column lables to display in the table, 
				like Name,Created Date,Custom Field." />
			<property name="sObjectName" label="Object Name" type="String" default="Account"
				description="Enter the api name of sobject from which you want to show data." />
			<property name="urlField" label="Url Field" type="String" default=""
				description="Enter the field api name, which you want to show as value  in table column, 
				but want it to redirect to sobject record as a link." />
			<property name="allowSorting" label="Allow Sorting" type="Boolean" default="false"
				description="Do you need sorting on fields in data table." />
			<property name="sortingColumns" label="Column Name to allow sorting" type="String"
				default="Name,CreatedDate"
				description="Enter a comma-separated list of string of field api name, which should 
				be allowed for sorting in the table like Name,CreatedDate,CustomField__c." />
			<property name="pageSizeOptionsString" label="Page Size Options" type="String"
				default="5,10,25"
				description="Enter a comma-separated list of string for page size options like 5,10,25." />
			<property name="pageSizeDefaultSelectedValue" label="Page Size Default Value"
				type="String" default="10"
				description="Enter the default page size for table in integer value like 10." />
		</targetConfig>
	</targetConfigs>
</LightningComponentBundle>

/* Tabler Header Column Color and css*/
.myTable table > thead .slds-th__action {
  background-color: rgba(1, 118, 211, 1) !important;
  color: white !important;
  font-size: 10px;
  font-weight: 700;
  width: 75%;
}
/* Tabler Header Column hover color and css*/
.myTable table > thead .slds-th__action:hover {
  background-color: rgba(35, 118, 204, 1) !important;
  font-size: 10px;
  font-weight: 700;
  width: 75%;
}
/* overriding data table color and background color*/
.datatable-style {
  color: black;
  background-color: white !important;
}
/* overriding data table hovor color and background color*/
.datatable-style:hover {
  color: black;
  background-color: white !important;
}
/* overriding data table special column color and background color*/
.datatable-styleOther {
  background-color: white !important;
}
/* overriding data table special column hover color and background color*/
.datatable-styleOther:hover {
  background-color: white !important;
}
.slds-is-sortable__icon {
  fill: white !important;
}
.dt-outer-container {
  padding-left: 10px;
  padding-right: 10px;
}
.slds-resizable__divider {
  background-color: rgba(35, 118, 204, 1) !important;
}
.noRowHover .slds-truncate {
  overflow-wrap: break-word !important;
  white-space: pre-line !important;
  width: 75%;
}

public with sharing class GenericRecordController {
    /**
    * Retrieves a list of records for a specified sObject
      and selected fields.
    * @param sObjectName Name of the sObject to query.
    * @param fieldNames Comma-separated list of fields to retrieve.
    * @return List of sObject records or null if an exception occurs.
    */
    @AuraEnabled(cacheable = true)
    public static List < sObject > getRecords(String sObjectName, 
                                              String fieldNames) 
    {
      try {
        // Split the field names by comma and store them in a list
        List <String> fields = new List <String> (fieldNames.split(','));
   
        // Get the schema description of the sObject
        Schema.DescribeSObjectResult sObjectDescribe =
          Schema.getGlobalDescribe().get(sObjectName).getDescribe();
   
        // Check if the user has access to the sObject
        if (!sObjectDescribe.isAccessible()) {
          throw new AuraHandledException(
            'You do not have access to the ' + sObjectName + ' object.'
          );
        }
   
        // Retrieve the map of fields for the sObject
        Map <String, Schema.SObjectField> fieldMap =
          sObjectDescribe.fields.getMap();
   
        // Validate each field name for accessibility and existence
        for (String fieldName: fields) {
          if (!fieldMap.containsKey(fieldName.trim()) 
				&& !fieldName.contains('.')) {
            throw new AuraHandledException(
              'Invalid field name: ' + fieldName.trim()
            );
          }
   
          // Check if the user has access to the field (non-relationship fields)
          if (!fieldName.contains('.')) {
            if (!fieldMap.get(fieldName.trim()).getDescribe().isAccessible()) {
              throw new AuraHandledException(
                'You do not have access to the ' +
                fieldName.trim() +
                ' field on the ' + sObjectName +
                ' object.'
              );
            }
          }
        }
   
        // Escape single quotes to prevent SOQL injection
        String sObjectNameEscaped = String.escapeSingleQuotes(sObjectName);
        String fieldNamesEscaped = String.escapeSingleQuotes(fieldNames);
   
        // Construct the SOQL query to retrieve the records
        String query =
          'SELECT ID, ' + fieldNamesEscaped + ' FROM ' +
          sObjectNameEscaped + ' ORDER BY Name LIMIT 2000';
   
        // Execute the query and return the result
        return Database.query(query);
      } catch (Exception ex) {
        // Log the exception for debugging purposes
        System.debug(
          'exception+++' + ex.getLineNumber() + ' ' + ex.getMessage()
        );
        return null;
      }
    }
   
    /**
    * Retrieves the data types for specified fields of an sObject.
    * @param sObjectName Name of the sObject to query.
    * @param fieldNames List of field names to retrieve data types for.
    * @return A map of field names to their data types.
    */
    @AuraEnabled(cacheable = true)
    public static Map <String, String> getFieldTypes(String sObjectName, 
                                                     List <String> fieldNames) 
    {
      // Retrieve the map of fields for the specified sObject
      Map <String, Schema.SObjectField> fieldMap =
        Schema.getGlobalDescribe().get(sObjectName).getDescribe().fields.getMap();
   
      // Map to store field names and their data types
      Map <String, String> fieldTypes = new Map <String, String> ();
   
      // Iterate through each field name
      for (String fieldName: fieldNames) {
        // Check if the field exists in the sObject
        if (fieldMap.containsKey(fieldName)) {
          // Get the field description
          Schema.DescribeFieldResult fieldDescribe =
            fieldMap.get(fieldName).getDescribe();
   
          // Store the field name and its type in lowercase in the map
          fieldTypes.put(
            fieldName,
            fieldDescribe.getType().name().toLowerCase()
          );
        }
      }
   
      // Return the map of field names and their types
      return fieldTypes;
    }
}