Sorry this was my fault. That was a remain of one of my many own attempts to find the syntax error before posting here again. Syntax error remains but now is pointed to be at line 5.
This is the init Function:
Code: Select all
function itm_requirements_init(&$options, $memberInfo, &$args) {
// get the original fields array
$oldFields = $options->QueryFieldsTV;
// loop through all fields
foreach($oldFields as $field => $title){
// find the field that we need to customize
if($field == '`itm_requirements`.`requirement_status`'){
// apply custom SQL formatting to the field
$ReqStatus = '`itm_requirements`.`requirement_status`';
$modField = "CASE ".$ReqStatus."
WHEN 'New' THEN CONCAT('<img src=\"hooks/','icon1','.png\" border=\"0\" />')
WHEN 'Closed' THEN CONCAT('<img src=\"hooks/','icon2','.png\" border=\"0\" />')
ELSE ".$ReqStatus."
END CASE";
$newFields[$modField] = $title;
}else{
// for other fields, keep them unchanged
$newFields[$field] = $title;
}
}
// now apply the modified fields
$options->QueryFieldsTV = $newFields;
return TRUE;
}
This is the syntax error message after removing the brackets:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE as `requirement_status`, `itm_requirements`.`requirement_name` as `requirem' at line 5
SQL-Anfrage:
SELECT `itm_requirements`.`id` as `id`, IF( CHAR_LENGTH(`itm_project_list1`.`project_id`) || CHAR_LENGTH(`itm_project_list1`.`project_name`), CONCAT_WS('', `itm_project_list1`.`project_id`, ' ', `itm_project_list1`.`project_name`), '') /* Projekt */ as `associated_project`, CASE `itm_requirements`.`requirement_status`
WHEN 'New' THEN CONCAT('<img src="hooks/','icon1','.png" border="0" />')
WHEN 'Closed' THEN CONCAT('<img src="hooks/','icon2','.png" border="0" />')
ELSE `itm_requirements`.`requirement_status`
END CASE as `requirement_status`, `itm_requirements`.`requirement_name` as `requirement_name`, `itm_requirements`.`requirement_description` as `requirement_description`, `itm_requirements`.`mantis_reference` as `mantis_reference`, `itm_requirements`.`mantis_reference_link` as `mantis_reference_link`, IF( CHAR_LENGTH(`itm_cycle_planning1`.`cycle_name`), CONCAT_WS('', `itm_cycle_planning1`.`cycle_name`), '') /* Geplanter Cycle */ as `associated_cycle`, IF( CHAR_LENGTH(if(`itm_cycle_planning1`.`cycle_start`,date_format(`itm_cycle_planning1`.`cycle_start`,'%d.%m.%Y %H:%i'),'')), CONCAT_WS('', if(`itm_cycle_planning1`.`cycle_start`,date_format(`itm_cycle_planning1`.`cycle_start`,'%d.%m.%Y %H:%i'),'')), '') /* Cycle Start */ as `associated_cycle_start`, IF( CHAR_LENGTH(if(`itm_cycle_planning1`.`cycle_end`,date_format(`itm_cycle_planning1`.`cycle_end`,'%d.%m.%Y %H:%i'),'')), CONCAT_WS('', if(`itm_cycle_planning1`.`cycle_end`,date_format(`itm_cycle_planning1`.`cycle_end`,'%d.%m.%Y %H:%i'),'')), '') /* Cycle Ende */ as `associated_cycle_end`, `itm_requirements`.`creation_info` as `creation_info`, `itm_requirements`.`edit_info` as `edit_info`, `itm_requirements`.`id` as 'itm_requirements.id' from `itm_requirements` LEFT JOIN `itm_project_list` as itm_project_list1 ON `itm_project_list1`.`id`=`itm_requirements`.`associated_project` LEFT JOIN `itm_cycle_planning` as itm_cycle_planning1 ON `itm_cycle_planning1`.`id`=`itm_requirements`.`associated_cycle` order by 1 desc limit 0,2000