28 require_once DOL_DOCUMENT_ROOT.
"/core/modules/DolibarrModules.class.php";
44 $langs->load(
"ticket");
51 $this->numero = 56000;
53 $this->rights_class =
'ticket';
57 $this->family =
"crm";
59 $this->module_position =
'60';
63 $this->
name = preg_replace(
'/^mod/i',
'', get_class($this));
67 $this->
description =
"Incident/support ticket management";
69 $this->version =
'dolibarr';
72 $this->const_name =
'MAIN_MODULE_'.strtoupper($this->
name);
78 $this->picto =
'ticket';
83 $this->module_parts = array(
90 $this->dirs = array();
94 $this->config_page_url = array(
"ticket.php");
97 $this->hidden =
false;
98 $this->depends = array(
'modAgenda');
99 $this->requiredby = array();
100 $this->conflictwith = array();
101 $this->phpmin = array(7, 0);
102 $this->langfiles = array(
"ticket");
108 $default_footer = $langs->trans(
'TicketMessageMailFooterText',
getDolGlobalString(
'MAIN_INFO_SOCIETE_NOM'));
109 $this->
const = array(
110 1 => array(
'TICKET_ENABLE_PUBLIC_INTERFACE',
'chaine',
'0',
'Enable ticket public interface', 0),
111 2 => array(
'TICKET_ADDON',
'chaine',
'mod_ticket_simple',
'Ticket ref module', 0),
112 3 => array(
'TICKET_ADDON_PDF_ODT_PATH',
'chaine',
'DOL_DATA_ROOT/doctemplates/tickets',
'Ticket templates ODT/ODS directory for templates', 0),
113 4 => array(
'TICKET_AUTO_READ_WHEN_CREATED_FROM_BACKEND',
'chaine', 0,
'Automatically mark ticket as read when created from backend', 0),
114 5 => array(
'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 6 => array(
'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 7 => array(
'TICKET_NOTIFY_AT_CLOSING',
'chaine',
'0',
'Default notify contacts when closing a module', 0),
117 8 => array(
'TICKET_PRODUCT_CATEGORY',
'chaine', 0,
'The category of product that is being used for ticket accounting', 0),
118 9 => array(
'TICKET_NOTIFICATION_EMAIL_FROM',
'chaine',
getDolGlobalString(
'MAIN_MAIL_EMAIL_FROM'),
'Email to use by default as sender for messages sent from Dolibarr', 0),
119 10 => array(
'TICKET_MESSAGE_MAIL_INTRO',
'chaine', $langs->trans(
'TicketMessageMailIntroText'),
'Introduction text of ticket replies sent from Dolibarr', 0),
120 11 => array(
'TICKET_MESSAGE_MAIL_SIGNATURE',
'chaine', $default_footer,
'Signature to use by default for messages sent from Dolibarr', 0),
121 12 => array(
'MAIN_EMAILCOLLECTOR_MAIL_WITHOUT_HEADER',
'chaine',
"1",
'Disable the rendering of headers in tickets', 0),
122 13 => array(
'MAIN_SECURITY_ENABLECAPTCHA_TICKET',
'chaine',
getDolGlobalInt(
'MAIN_SECURITY_ENABLECAPTCHA_TICKET'),
'Enable captcha code by default', 0),
123 14 => array(
'TICKET_SHOW_COMPANY_LOGO',
'chaine',
getDolGlobalInt(
'TICKET_SHOW_COMPANY_LOGO'),
'Enable logo header on ticket public page', 0),
124 15 => array(
'TICKET_SHOW_COMPANY_FOOTER',
'chaine',
getDolGlobalInt(
'TICKET_SHOW_COMPANY_FOOTER'),
'Enable footer on ticket public page', 0)
129 'thirdparty:+ticket:Tickets:ticket:$user->rights->ticket->read:/ticket/list.php?socid=__ID__',
133 if (!isset($conf->ticket->enabled)) {
135 $conf->ticket->enabled = 0;
137 $this->dictionaries = array(
143 "c_ticket_resolution"
147 "TicketDictSeverity",
148 "TicketDictCategory",
149 "TicketDictResolution"
152 'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.MAIN_DB_PREFIX.
'c_ticket_type as f WHERE f.entity IN ('.
getEntity(
'c_ticket_type').
')',
153 'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.MAIN_DB_PREFIX.
'c_ticket_severity as f WHERE f.entity IN ('.
getEntity(
'c_ticket_severity').
')',
154 'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.public, f.fk_parent, f.entity FROM '.MAIN_DB_PREFIX.
'c_ticket_category as f WHERE f.entity IN ('.
getEntity(
'c_ticket_category').
')',
155 'SELECT f.rowid as rowid, f.code, f.pos, f.label, f.active, f.use_default, f.entity FROM '.MAIN_DB_PREFIX.
'c_ticket_resolution as f WHERE f.entity IN ('.
getEntity(
'c_ticket_resolution').
')'
157 'tabsqlsort' => array(
"pos ASC",
"pos ASC",
"pos ASC",
"pos ASC"),
158 'tabfield' => array(
"code,label,pos,use_default",
"code,label,pos,use_default",
"code,label,pos,use_default,public,fk_parent",
"code,label,pos,use_default"),
159 'tabfieldvalue' => array(
"code,label,pos,use_default",
"code,label,pos,use_default",
"code,label,pos,use_default,public,fk_parent",
"code,label,pos,use_default"),
160 'tabfieldinsert' => array(
"code,label,pos,use_default,entity",
"code,label,pos,use_default,entity",
"code,label,pos,use_default,public,fk_parent,entity",
"code,label,pos,use_default,entity"),
161 'tabrowid' => array(
"rowid",
"rowid",
"rowid",
"rowid"),
164 array(
'code' => $langs->trans(
"EnterAnyCode"),
'use_default' => $langs->trans(
"Enter0or1")),
165 array(
'code' => $langs->trans(
"EnterAnyCode"),
'use_default' => $langs->trans(
"Enter0or1")),
166 array(
'code' => $langs->trans(
"EnterAnyCode"),
'use_default' => $langs->trans(
"Enter0or1"),
'public' => $langs->trans(
"Enter0or1").
'<br>'.$langs->trans(
"TicketGroupIsPublicDesc"),
'fk_parent' => $langs->trans(
"IfThisCategoryIsChildOfAnother")),
167 array(
'code' => $langs->trans(
"EnterAnyCode"),
'use_default' => $langs->trans(
"Enter0or1"))
173 $this->boxes = array(
174 0 => array(
'file' =>
'box_last_ticket.php',
'enabledbydefaulton' =>
'Home'),
175 1 => array(
'file' =>
'box_last_modified_ticket.php',
'enabledbydefaulton' =>
'Home'),
176 2 => array(
'file' =>
'box_ticket_by_severity.php',
'enabledbydefaulton' =>
'ticketindex'),
177 3 => array(
'file' =>
'box_graph_nb_ticket_last_x_days.php',
'enabledbydefaulton' =>
'ticketindex'),
178 4 => array(
'file' =>
'box_graph_nb_tickets_type.php',
'enabledbydefaulton' =>
'ticketindex'),
179 5 => array(
'file' =>
'box_new_vs_close_ticket.php',
'enabledbydefaulton' =>
'ticketindex')
183 $this->rights = array();
186 $this->rights[$r][0] = 56001;
187 $this->rights[$r][1] =
"Read ticket";
188 $this->rights[$r][2] =
'r';
189 $this->rights[$r][3] = 0;
190 $this->rights[$r][4] =
'read';
193 $this->rights[$r][0] = 56002;
194 $this->rights[$r][1] =
"Create les tickets";
195 $this->rights[$r][2] =
'w';
196 $this->rights[$r][3] = 0;
197 $this->rights[$r][4] =
'write';
200 $this->rights[$r][0] = 56003;
201 $this->rights[$r][1] =
"Delete les tickets";
202 $this->rights[$r][2] =
'd';
203 $this->rights[$r][3] = 0;
204 $this->rights[$r][4] =
'delete';
207 $this->rights[$r][0] = 56004;
208 $this->rights[$r][1] =
"Manage tickets";
210 $this->rights[$r][3] = 0;
211 $this->rights[$r][4] =
'manage';
214 $this->rights[$r][0] = 56006;
215 $this->rights[$r][1] =
"Export ticket";
217 $this->rights[$r][3] = 0;
218 $this->rights[$r][4] =
'export';
231 $this->menu = array();
249 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket',
252 'prefix' =>
img_picto(
'', $this->picto,
'class="paddingright pictofixedwidth em092"'),
253 'mainmenu' =>
'ticket',
254 'leftmenu' =>
'ticket',
255 'url' =>
'/ticket/index.php',
258 'enabled' =>
'isModEnabled("ticket")',
259 'perms' =>
'$user->rights->ticket->read',
264 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
266 'titre' =>
'NewTicket',
267 'mainmenu' =>
'ticket',
268 'url' =>
'/ticket/card.php?action=create',
271 'enabled' =>
'isModEnabled("ticket")',
272 'perms' =>
'$user->rights->ticket->write',
277 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
280 'mainmenu' =>
'ticket',
281 'leftmenu' =>
'ticketlist',
282 'url' =>
'/ticket/list.php?search_fk_status=non_closed',
285 'enabled' =>
'isModEnabled("ticket")',
286 'perms' =>
'$user->rights->ticket->read',
291 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
293 'titre' =>
'MenuTicketMyAssign',
294 'mainmenu' =>
'ticket',
295 'leftmenu' =>
'ticketmy',
296 'url' =>
'/ticket/list.php?mode=mine&search_fk_status=non_closed',
299 'enabled' =>
'isModEnabled("ticket")',
300 'perms' =>
'$user->rights->ticket->read',
305 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
307 'titre' =>
'Statistics',
308 'mainmenu' =>
'ticket',
309 'url' =>
'/ticket/stats/index.php',
312 'enabled' =>
'isModEnabled("ticket")',
313 'perms' =>
'$user->rights->ticket->read',
318 $this->menu[$r] = array(
'fk_menu' =>
'fk_mainmenu=ticket,fk_leftmenu=ticket',
320 'titre' =>
'Categories',
321 'mainmenu' =>
'ticket',
322 'url' =>
'/categories/index.php?type=12',
325 'enabled' =>
'$conf->categorie->enabled',
326 'perms' =>
'$user->rights->ticket->read',
336 $langs->load(
"ticket");
337 $this->export_code[$r] = $this->rights_class.
'_'.$r;
338 $this->export_label[$r] =
'ExportDataset_ticket_1';
339 $this->export_permission[$r] = array(array(
"ticket",
"export"));
340 $this->export_icon[$r] =
'ticket';
341 $keyforclass =
'Ticket';
342 $keyforclassfile =
'/ticket/class/ticket.class.php';
343 $keyforelement =
'ticket';
344 include DOL_DOCUMENT_ROOT.
'/core/commonfieldsinexport.inc.php';
345 $keyforselect =
'ticket';
346 $keyforaliasextra =
'extra';
347 $keyforelement =
'ticket';
348 include DOL_DOCUMENT_ROOT.
'/core/extrafieldsinexport.inc.php';
349 $this->export_sql_start[$r] =
'SELECT DISTINCT ';
350 $this->export_sql_end[$r] =
' FROM '.MAIN_DB_PREFIX.
'ticket as t';
351 $this->export_sql_end[$r] .=
' LEFT JOIN '.MAIN_DB_PREFIX.
'ticket_extrafields as extra on (t.rowid = extra.fk_object)';
352 $this->export_sql_end[$r] .=
' WHERE 1 = 1';
353 $this->export_sql_end[$r] .=
' AND t.entity IN ('.getEntity(
'ticket').
')';
365 public function init($options =
'')
367 global $conf, $langs;
369 $result = $this->
_load_tables(
'/install/mysql/',
'ticket');
375 $this->
remove($options);
378 $src = DOL_DOCUMENT_ROOT.
'/install/doctemplates/tickets/template_ticket.odt';
379 $dirodt = DOL_DATA_ROOT.
'/doctemplates/tickets';
380 $dest = $dirodt.
'/template_ticket.odt';
382 if (file_exists($src) && !file_exists($dest)) {
383 require_once DOL_DOCUMENT_ROOT.
'/core/lib/files.lib.php';
385 $result =
dol_copy($src, $dest, 0, 0);
387 $langs->load(
"errors");
388 $this->error = $langs->trans(
'ErrorFailToCopyFile', $src, $dest);
394 array(
"sql" =>
"insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110120, 'ticket', 'internal', 'SUPPORTTEC', 'Utilisateur assigné au ticket', 1);",
"ignoreerror" => 1),
395 array(
"sql" =>
"insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110121, 'ticket', 'internal', 'CONTRIBUTOR', 'Intervenant', 1);",
"ignoreerror" => 1),
396 array(
"sql" =>
"insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110122, 'ticket', 'external', 'SUPPORTCLI', 'Contact client suivi incident', 1);",
"ignoreerror" => 1),
397 array(
"sql" =>
"insert into llx_c_type_contact(rowid, element, source, code, libelle, active ) values (110123, 'ticket', 'external', 'CONTRIBUTOR', 'Intervenant', 1);",
"ignoreerror" => 1),
399 "DELETE FROM ".MAIN_DB_PREFIX.
"document_model WHERE nom = 'TICKET_ADDON_PDF_ODT_PATH' AND type = 'ticket' AND entity = ".((
int) $conf->entity),
401 array(
"sql" =>
"INSERT INTO ".MAIN_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),
_init($array_sql, $options='')
Enables a module.
_load_tables($reldir, $onlywithsuffix='')
Create tables and keys required by module:
Description and activation class for module Ticket.
init($options='')
Function called when module is enabled.
__construct($db)
Constructor.
if(isModEnabled('invoice') && $user->hasRight('facture', 'lire')) if((isModEnabled('fournisseur') &&!getDolGlobalString('MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight("fournisseur", "facture", "lire"))||(isModEnabled('supplier_invoice') && $user->hasRight("supplier_invoice", "lire"))) if(isModEnabled('don') && $user->hasRight('don', 'lire')) if(isModEnabled('tax') && $user->hasRight('tax', 'charges', 'lire')) if(isModEnabled('invoice') &&isModEnabled('order') && $user->hasRight("commande", "lire") &&!getDolGlobalString('WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) $sql
Social contributions to pay.
print *****$script_file(".$version.") pid 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.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
getDolGlobalString($key, $default='')
Return 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_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.