Feature #4992

permit to link several items to a ticket

Added by moyo almost 7 years ago. Updated about 6 years ago.

Status:ClosedStart date:07/02/2014
Priority:NormalDue date:
Assignee:ludo% Done:

100%

Category:Helpdesk
Target version:0.85.3

associated_elements_0.85.3.patch Magnifier (135 KB) tsmr, 01/22/2015 11:37 AM

Associated revisions

Revision 23344
Added by moyo over 6 years ago

prepare DB for #4992

Revision 23346
Added by moyo over 6 years ago

initial commit patch for #4992

Revision 23353
Added by ddurieux over 6 years ago

Fix code when delete an item linked with a ticket. references #4992

Revision 23354
Added by ddurieux over 6 years ago

Fix search tickets with type of elements associated. references #4992

Revision 23355
Added by ddurieux over 6 years ago

Missing force group by in previous commit. references #4992

Revision 23356
Added by moyo over 6 years ago

fix search for #4992

Revision 23404
Added by ddurieux about 6 years ago

Display associated elements (5 max) in ticket form + link to tab associated items. references #4992

Revision 23449
Added by yllen about 6 years ago

fix purposed for item_ticket - fixed #4992

Revision 23453
Added by moyo about 6 years ago

minor fix for #4992

History

#1 Updated by tsmr over 6 years ago

  • Assignee set to ludo

#2 Updated by tsmr over 6 years ago

  • Description updated (diff)

#3 Updated by tsmr over 6 years ago

Patch with svn 22/01/2015

#4 Updated by ddurieux about 6 years ago

J'ai mis en place chez un client et la première chose qui remonte c'est qu'il n'est pas pratique de ne pas avoir la liste des items dans le form principal, il faut aller cliquer sur l'onglet 'éléments associés'.

Est-ce que vous voyez une objection pour juste afficher la liste des éléments associés dans le formulaire du ticket?

#5 Updated by moyo about 6 years ago

Peut être en limitant quand même le nombre affiché car s'il y en a 50 ca va rendre le form illisible.

#6 Updated by ddurieux about 6 years ago

Si on limite à 5 avec un lien vers l'onglet des éléments associé s'il y en a plus, ça devrait gérer la majorité des cas.

Si t'es ok, je vais coder ça

#7 Updated by moyo about 6 years ago

Oui je pense

#8 Updated by moyo about 6 years ago

  • Status changed from Feedback to Closed
  • % Done changed from 0 to 100

#9 Updated by yllen about 6 years ago

  • Status changed from Closed to Assigned

SQL: SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(`glpi_tickets`.`solvedate`),\'%Y-%m\')
AS date_unix,
AVG AS total_visites
FROM `glpi_tickets`
INNER JOIN `glpi_computers`
ON (`glpi_computers`.`id` = `glpi_tickets`.`items_id`
AND `glpi_tickets`.`itemtype` = \'Computer\')
WHERE NOT `glpi_tickets`.`is_deleted` AND ( `glpi_tickets`.`entities_id` IN (\'1\') ) AND `glpi_computers`.`computertypes_id` = \'6\'
AND `glpi_computers`.`is_template` <> \'1\' AND `glpi_tickets`.`actiontime` > \'0\'
AND ( `glpi_tickets`.`solvedate` >= \'2014-04-17\' AND `glpi_tickets`.`solvedate` <= ADDDATE )
GROUP BY date_unix
ORDER BY `glpi_tickets`.`solvedate`
Error: Unknown column 'glpi_tickets.items_id' in 'on clause'
Backtrace :
inc/stat.class.php:1074
inc/stat.class.php:666 Stat::constructEntryValues()
front/stat.location.php:155 Stat::showTable()

#10 Updated by yllen about 6 years ago

  • % Done changed from 100 to 90

#11 Updated by yllen about 6 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 90 to 100

Applied in changeset r23449.

#12 Updated by tsmr about 6 years ago

Correction OK pour moi. Merci yllen

#13 Updated by moyo about 6 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF