if the preoficiency_level (star) greater than or equal to 3 star it will be green or else Orange
frappe.query_reports["Employee Skill Report"] = {
"filters": [
{
"fieldname": "branch",
"label": __("Select Branch"),
"fieldtype": "Link",
"options": "Branch"
},
{
"fieldname":"project_manager",
"label": __("Project Manager"),
"fieldtype": "Link",
"options":"User",
"get_query": function () {
return {
query: "ss_custom_erpnext.ss_custom_erpnext.constant.constant.get_project_manager_list"
}
}
},
],
"formatter": function (value, row, column, data, default_formatter) {
value = default_formatter(value, row, column, data);
let star = ['***','****','*****']
if (column.id == "technology"){
if(star.includes(data["proficiency_level"])){
value = `<span style='color:green';>${data['technology']} </span>`;
}
else{
value = `<span style='color:#ff8c00';>${data['technology']} </span>`;
}
}else if (column.id == "employee"){
if (data['employee'].includes("(hide)")){
return value = ''
}else{
return value = data['employee']
}
}else if (column.id == "employee_name"){
if (data['employee_name'].includes("(hide)")){
return value = ''
}else{
return value = data['employee_name']
}
}else if (column.id == "team_lead"){
if (data['team_lead'].includes("(hide)")){
return value = ''
}else{
return value = data['team_lead']
}
}else if (column.id == "date_of_joining"){
if (data['date_of_joining'].includes("(hide)")){
return value = ''
}else{
return value = data['date_of_joining']
}
}
return value;
},
};