29require_once DOL_DOCUMENT_ROOT.
"/core/modules/DolibarrModules.class.php";
44 global $langs,
$conf, $user;
45 $langs->load(
"ticket");
52 $this->numero = 56000;
54 $this->rights_class =
'ticket';
58 $this->family =
"crm";
60 $this->module_position =
'60';
64 $this->
name = preg_replace(
'/^mod/i',
'', get_class($this));
68 $this->
description =
"Incident/support ticket management";
73 $this->const_name =
'MAIN_MODULE_'.strtoupper($this->
name);
79 $this->picto =
'ticket';
84 $this->module_parts = [
95 $this->config_page_url = [
"ticket.php"];
98 $this->hidden =
false;
99 $this->depends = [
'modAgenda'];
100 $this->requiredby = [];
101 $this->conflictwith = [];
102 $this->langfiles = [
"ticket"];
108 $default_footer = $langs->trans(
'TicketMessageMailFooterText',
getDolGlobalString(
'MAIN_INFO_SOCIETE_NOM'));
110 [
'TICKET_ENABLE_PUBLIC_INTERFACE',
'chaine',
'0',
'Enable ticket public interface', 0],
111 [
'TICKET_ADDON',
'chaine',
'mod_ticket_simple',
'Ticket ref module', 0],
112 [
'TICKET_ADDON_PDF_ODT_PATH',
'chaine',
'DOL_DATA_ROOT'.($conf->entity > 1 ?
'/'.$conf->entity :
'').
'/doctemplates/tickets',
'Ticket templates ODT/ODS directory for templates', 0],
113 [
'TICKET_AUTO_READ_WHEN_CREATED_FROM_BACKEND',
'chaine', 0,
'Automatically mark ticket as read when created from backend', 0],
114 [
'TICKET_DELAY_BEFORE_FIRST_RESPONSE',
'chaine',
'0',
'Maximum wanted elapsed time before a first answer to a ticket (in hours). Display a warning in tickets list if not respected.', 0],
115 [
'TICKET_DELAY_SINCE_LAST_RESPONSE',
'chaine',
'0',
'Maximum wanted elapsed time between two answers on the same ticket (in hours). Display a warning in tickets list if not respected.', 0],
116 [
'TICKET_NOTIFY_AT_CLOSING',
'chaine',
'0',
'Default notify contacts when closing a module', 0],
117 [
'TICKET_PRODUCT_CATEGORY',
'chaine', 0,
'The category of product that is being used to find contract to link to created ticket', 0],
118 [
'TICKET_NOTIFICATION_EMAIL_FROM',
'chaine',
getDolGlobalString(
'MAIN_MAIL_EMAIL_FROM'),
'Email to use by default as sender for messages sent from Dolibarr', 0],
119 [
'TICKET_MESSAGE_MAIL_INTRO',
'chaine', $langs->trans(
'TicketMessageMailIntroText'),
'Introduction text of ticket replies sent from Dolibarr', 0],
120 [
'TICKET_MESSAGE_MAIL_SIGNATURE',
'chaine', $default_footer,
'Signature to use by default for messages sent from Dolibarr', 0],
121 [
'MAIN_EMAILCOLLECTOR_MAIL_WITHOUT_HEADER',
'chaine',
"1",
'Disable the rendering of headers in tickets', 0],
122 [
'MAIN_SECURITY_ENABLECAPTCHA_TICKET',
'chaine',
getDolGlobalInt(
'MAIN_SECURITY_ENABLECAPTCHA_TICKET'),
'Enable captcha code by default', 0],
123 [
'TICKET_SHOW_COMPANY_LOGO',
'chaine',
getDolGlobalInt(
'TICKET_SHOW_COMPANY_LOGO', 1),
'Enable logo header on ticket public page', 0],
124 [
'TICKET_SHOW_COMPANY_FOOTER',
'chaine',
getDolGlobalInt(
'TICKET_SHOW_COMPANY_FOOTER', 1),
'Enable footer on ticket public page', 0],
125 [
'TICKET_EMAIL_TEMPLATE_REMIND_STALE',
'emailtemplate:ticket',
'(SendingReminderForStaleTicket)',
'Email template used to remind the assigned user of a late ticket (see TICKET_DELAY_BEFORE_FIRST_RESPONSE and TICKET_DELAY_SINCE_LAST_RESPONSE)', 0],
135 if (!isset(
$conf->ticket->enabled)) {
137 $conf->ticket->enabled = 0;
143 'name' =>
'c_ticket_type',
144 'lib' =>
'TicketDictType',
145 'sql' =>
'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.$this->db->prefix().
'c_ticket_type as f WHERE f.entity IN ('.
getEntity(
'c_ticket_type').
')',
146 'sqlsort' =>
'pos ASC',
147 'field' =>
'code,label,pos,use_default',
148 'fieldvalue' =>
'code,label,pos,use_default',
149 'fieldinsert' =>
'code,label,pos,use_default,entity',
152 'help' => [
'code' => $langs->trans(
'EnterAnyCode'),
'use_default' => $langs->trans(
'EnterYesOrNo')],
159 'name' =>
'c_ticket_severity',
160 'lib' =>
'TicketDictSeverity',
161 'sql' =>
'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.$this->db->prefix().
'c_ticket_severity as f WHERE f.entity IN ('.
getEntity(
'c_ticket_severity').
')',
162 'sqlsort' =>
'pos ASC',
163 'field' =>
'code,label,pos,use_default',
164 'fieldvalue' =>
'code,label,pos,use_default',
165 'fieldinsert' =>
'code,label,pos,use_default,entity',
169 'code' => $langs->trans(
'EnterAnyCode'),
170 'use_default' => $langs->trans(
'EnterYesOrNo'),
178 'name' =>
'c_ticket_category',
179 'lib' =>
'TicketDictCategory',
180 'sql' =>
'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.public, f.fk_parent, f.entity FROM '.$this->db->prefix().
'c_ticket_category as f WHERE f.entity IN ('.
getEntity(
'c_ticket_category').
')',
181 'sqlsort' =>
'pos ASC',
182 'field' =>
'code,label,pos,use_default,public,fk_parent',
183 'fieldvalue' =>
'code,label,pos,use_default,public,fk_parent',
184 'fieldinsert' =>
'code,label,pos,use_default,public,fk_parent,entity',
188 'code' => $langs->trans(
'EnterAnyCode'),
189 'use_default' => $langs->trans(
'EnterYesOrNo'),
190 'public' => $langs->trans(
'Enter0or1').
'<br>'.$langs->trans(
'TicketGroupIsPublicDesc'),
191 'fk_parent' => $langs->trans(
'IfThisCategoryIsChildOfAnother'),
199 'name' =>
'c_ticket_resolution',
200 'lib' =>
'TicketDictResolution',
201 'sql' =>
'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.$this->db->prefix().
'c_ticket_resolution as f WHERE f.entity IN ('.
getEntity(
'c_ticket_resolution').
')',
202 'sqlsort' =>
'pos ASC',
203 'field' =>
'code,label,pos,use_default',
204 'fieldvalue' =>
'code,label,pos,use_default',
205 'fieldinsert' =>
'code,label,pos,use_default,entity',
209 'code' => $langs->trans(
'EnterAnyCode'),
210 'use_default' => $langs->trans(
'Enter0or1'),
217 $datestart =
dol_mktime(22, 0, 0, $arraydate[
'mon'], $arraydate[
'mday'], $arraydate[
'year']);
218 $this->cronjobs = array(
220 'label' =>
'SendReminderForStaleTicketsTitle',
221 'jobtype' =>
'method',
222 'class' =>
'ticket/class/ticket.class.php',
223 'objectname' =>
'Ticket',
224 'method' =>
'sendReminderForStaleTickets',
226 'comment' =>
'SendReminderForStaleTickets',
228 'unitfrequency' => 3600 * 24,
231 'test' =>
'isModEnabled("ticket")',
232 'datestart' => $datestart
239 [
'file' =>
'box_last_ticket.php',
'enabledbydefaulton' =>
'Home'],
240 [
'file' =>
'box_last_modified_ticket.php',
'enabledbydefaulton' =>
'Home'],
241 [
'file' =>
'box_graph_ticket_by_severity.php',
'enabledbydefaulton' =>
'ticketindex'],
242 [
'file' =>
'box_graph_nb_ticket_last_x_days.php',
'enabledbydefaulton' =>
'ticketindex'],
243 [
'file' =>
'box_graph_nb_tickets_type.php',
'enabledbydefaulton' =>
'ticketindex'],
244 [
'file' =>
'box_new_vs_close_ticket.php',
'enabledbydefaulton' =>
'ticketindex'],
251 $this->rights[$r][0] = 56001;
252 $this->rights[$r][1] =
"Read ticket";
253 $this->rights[$r][2] =
'r';
254 $this->rights[$r][3] = 0;
255 $this->rights[$r][4] =
'read';
258 $this->rights[$r][0] = 56002;
259 $this->rights[$r][1] =
"Create les tickets";
260 $this->rights[$r][2] =
'w';
261 $this->rights[$r][3] = 0;
262 $this->rights[$r][4] =
'write';
265 $this->rights[$r][0] = 56003;
266 $this->rights[$r][1] =
"Delete les tickets";
267 $this->rights[$r][2] =
'd';
268 $this->rights[$r][3] = 0;
269 $this->rights[$r][4] =
'delete';
272 $this->rights[$r][0] = 56004;
273 $this->rights[$r][1] =
"Manage tickets";
275 $this->rights[$r][3] = 0;
276 $this->rights[$r][4] =
'manage_advance';
279 $this->rights[$r][0] = 56006;
280 $this->rights[$r][1] =
"Export ticket";
282 $this->rights[$r][3] = 0;
283 $this->rights[$r][4] =
'export';
300 'fk_menu' =>
'fk_mainmenu=ticket',
303 'prefix' => img_picto(
'', $this->picto,
'class="paddingright pictofixedwidth em092"'),
304 'mainmenu' =>
'ticket',
305 'leftmenu' =>
'ticket',
306 'url' =>
'/ticket/index.php',
309 'enabled' =>
'isModEnabled("ticket")',
310 'perms' =>
'$user->hasRight("ticket","read")',
317 'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
319 'titre' =>
'NewTicket',
320 'mainmenu' =>
'ticket',
321 'url' =>
'/ticket/card.php?action=create&mode=init',
324 'enabled' =>
'isModEnabled("ticket")',
325 'perms' =>
'$user->hasRight("ticket", "write")',
332 'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
335 'mainmenu' =>
'ticket',
336 'leftmenu' =>
'ticketlist',
337 'url' =>
'/ticket/list.php?search_fk_statut=openall',
340 'enabled' =>
'isModEnabled("ticket")',
341 'perms' =>
'$user->hasRight("ticket","read")',
348 'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
350 'titre' =>
'MenuTicketMyAssign',
351 'mainmenu' =>
'ticket',
352 'leftmenu' =>
'ticketmy',
353 'url' =>
'/ticket/list.php?mode=mine&search_fk_statut=openall',
356 'enabled' =>
'isModEnabled("ticket")',
357 'perms' =>
'$user->hasRight("ticket","read")',
364 'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
366 'titre' =>
'Statistics',
367 'mainmenu' =>
'ticket',
368 'url' =>
'/ticket/stats/index.php',
371 'enabled' =>
'isModEnabled("ticket") && getDolGlobalString("MAIN_STATISTICS_IN_MENU")',
372 'perms' =>
'$user->hasRight("ticket","read")',
379 'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
381 'titre' =>
'Categories',
382 'mainmenu' =>
'ticket',
383 'url' =>
'/categories/categorie_list.php?type=12',
386 'enabled' =>
'isModEnabled("ticket") && isModEnabled("categorie") && getDolGlobalString("CATEGORY_EDIT_IN_MENU_NOT_IN_POPUP")',
387 'perms' =>
'$user->hasRight("ticket","read")',
398 $langs->load(
"ticket");
399 $this->export_code[$r] = $this->rights_class.
'_'.$r;
400 $this->export_label[$r] =
'ExportDataset_ticket_1';
401 $this->export_permission[$r] = [[
"ticket",
"export"]];
402 $this->export_icon[$r] =
'ticket';
403 $keyforclass =
'Ticket';
404 $keyforclassfile =
'/ticket/class/ticket.class.php';
405 $keyforelement =
'ticket';
406 include DOL_DOCUMENT_ROOT.
'/core/commonfieldsinexport.inc.php';
407 $keyforselect =
'ticket';
408 $keyforaliasextra =
'extra';
409 $keyforelement =
'ticket';
410 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
411 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
412 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'ticket as t';
413 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'ticket_extrafields as extra on (t.rowid = extra.fk_object)';
414 $this->export_sql_end[$r] .=
' WHERE 1 = 1';
415 $this->export_sql_end[$r] .=
' AND t.entity IN ('.getEntity(
'ticket').
')';
416 if (is_object($user) && !$user->hasRight(
'societe',
'client',
'voir')) {
418 $this->export_sql_end[$r] .=
' AND (t.fk_soc IS NULL OR EXISTS (SELECT sc.fk_soc FROM '.MAIN_DB_PREFIX.
'societe_commerciaux as sc WHERE sc.fk_soc = t.fk_soc AND sc.fk_user = '.((int) $user->id).
'))';
431 public function init($options =
'')
433 global
$conf, $langs;
435 $result = $this->
_load_tables(
'/install/mysql/',
'ticket');
441 $this->
remove($options);
444 $src = DOL_DOCUMENT_ROOT.
'/install/doctemplates/tickets/template_ticket.odt';
445 $dirodt = DOL_DATA_ROOT.($conf->entity > 1 ?
'/'.$conf->entity :
'').
'/doctemplates/tickets';
446 $dest = $dirodt.
'/template_ticket.odt';
448 if (file_exists($src) && !file_exists($dest)) {
449 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
451 $result =
dol_copy($src, $dest,
'0', 0);
453 $langs->load(
"errors");
454 $this->error = $langs->trans(
'ErrorFailToCopyFile', $src, $dest);
460 [
"sql" =>
"INSERT INTO ".$this->db->prefix().
"c_type_contact(rowid, element, source, code, libelle, active ) values (110120, 'ticket', 'internal', 'SUPPORTTEC', 'Utilisateur assigné au ticket', 1);",
"ignoreerror" => 1],
461 [
"sql" =>
"INSERT INTO ".$this->db->prefix().
"c_type_contact(rowid, element, source, code, libelle, active ) values (110121, 'ticket', 'internal', 'CONTRIBUTOR', 'Intervenant', 1);",
"ignoreerror" => 1],
462 [
"sql" =>
"INSERT INTO ".$this->db->prefix().
"c_type_contact(rowid, element, source, code, libelle, active ) values (110122, 'ticket', 'external', 'SUPPORTCLI', 'Contact client suivi incident', 1);",
"ignoreerror" => 1],
463 [
"sql" =>
"INSERT INTO ".$this->db->prefix().
"c_type_contact(rowid, element, source, code, libelle, active ) values (110123, 'ticket', 'external', 'CONTRIBUTOR', 'Intervenant', 1);",
"ignoreerror" => 1],
465 [
"sql" =>
"DELETE FROM ".$this->db->prefix().
"document_model WHERE nom = 'TICKET_ADDON_PDF_ODT_PATH' AND type = 'ticket' AND entity = ".((int)
$conf->entity),
"ignoreerror" => 1],
467 [
"sql" =>
"INSERT INTO ".$this->db->prefix().
"document_model (nom, type, libelle, entity, description) VALUES('generic_ticket_odt','ticket','ODT templates',".((int)
$conf->entity).
",'TICKET_ADDON_PDF_ODT_PATH');",
"ignoreerror" => 1],
470 return $this->
_init($sql, $options);
if(!isModEnabled('ai')||!getDolGlobalString('AI_ASSISTANT_ENABLED')) global $conf
The main.inc.php has been included so the following variable are now defined:
_init($array_sql, $options='')
Enables a module.
_load_tables($reldir, $onlywithsuffix='')
Create tables and keys required by module:
declareNewDictionary($dictionaryArray, $langs='')
Helper method to declare dictionaries one at a time (rather than declaring dictionaries property by p...
Description and activation class for module Ticket.
init($options='')
Function called when module is enabled.
__construct($db)
Constructor.
print $script_file $mode $langs defaultlang(is_numeric($duration_value) ? " delay=". $duration_value :"").(is_numeric($duration_value2) ? " after cd cd cd description as description
Only used if Module[ID]Desc translation string is not found.
dol_copy($srcfile, $destfile, $newmask='0', $overwriteifexists=1, $testvirus=0, $indexdatabase=0)
Copy a file to another file.
dol_now($mode='gmt')
Return date for now.
dol_mktime($hour, $minute, $second, $month, $day, $year, $gm='auto', $check=1)
Return a timestamp date built from detailed information (by default a local PHP server timestamp) Rep...
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
isModEnabled($module)
Is Dolibarr module enabled.
getEntity($element, $shared=1, $currentobject=null)
Get list of entity id to use.
dol_getdate($timestamp, $fast=false, $forcetimezone='')
Return an array with locale date info.
dol_mkdir($dir, $dataroot='', $newmask='')
Creation of a directory (this can create recursive subdir)
$conf db name
Only used if Module[ID]Name translation string is not found.