$data[2] = "<a href='index.php?sec=projects&sec2=operation/workorders/wo&operation=view&id=".
$wo['id']."'>".short_string ($wo['name'],45)."</a>";
if ($wo["id_task"] != 0){
$id_project = get_db_value ("id_project", "ttask", "id", $wo["id_task"]);
$project_title = short_string (get_db_value ("name", "tproject", "id", $id_project), 35);
$task_title = short_string (get_db_value ("name", "ttask", "id", $wo["id_task"]), 35);
$buffer = "<br><span style='font-size: 9px'>" . $project_title . " / " . $task_title . "</span>";
$data[2] .= $buffer;
}
$data[3] = print_priority_flag_image ($wo["priority"], true);
$data[4] = translate_wo_status($wo["progress"]);
if ($wo["assigned_user"] == $config["id_user"]) {
$data[5] = '<a href="index.php?sec=projects&sec2=operation/workorders/wo&owner='.$wo["assigned_user"].'">'.__("Me").'</a>';
}
else {
$data[5] = '<a href="index.php?sec=projects&sec2=operation/workorders/wo&owner='.$wo["assigned_user"].'">'.$wo["assigned_user"].'</a>';
}
if ($wo["assigned_user"] != $wo["created_by_user"]) {
if ($wo["created_by_user"] == $config["id_user"]) {
$data[6] = '<a href="index.php?sec=projects&sec2=operation/workorders/wo&creator='.$wo["created_by_user"].'">'.__("Me").'</a>';
} else {
$data[6] = '<a href="index.php?sec=projects&sec2=operation/workorders/wo&creator='.$wo["created_by_user"].'">'.$wo["created_by_user"].'</a>';
}
if ($wo["need_external_validation"] == 1)
function mail_workorder($id_wo, $mode, $id_note = false, $wo_info = false, $note_info = false)
{
global $config;
$wo = $wo_info;
if (!$wo_info) {
$wo = get_db_row("ttodo", "id", $id_wo);
}
// Only send mails when creator is different than owner
if ($wo['assigned_user'] == $wo['created_by_user']) {
return;
}
$MACROS["_sitename_"] = $config['sitename'];
$MACROS["_wo_id_"] = $wo['id'];
$MACROS["_wo_name_"] = $wo['name'];
$MACROS["_wo_last_update_"] = $wo['last_update'];
$MACROS["_wo_created_by_user_"] = $wo['created_by_user'];
$MACROS["_wo_assigned_user_"] = $wo['assigned_user'];
$MACROS["_wo_progress_"] = translate_wo_status($wo['progress']);
$MACROS["_wo_priority_"] = get_priority_name($wo['priority']);
$MACROS["_wo_description_"] = wordwrap($wo["description"], 70, "\n");
$MACROS["_wo_url_"] = $config["base_url"] . "/index.php?sec=projects&sec2=operation/workorders/wo&operation=view&id={$id_wo}";
$MACROS["_wo_title_"] = $wo['name'];
$MACROS["_wo_delete_user_"] = $config["id_user"];
//Replace note macros if needed
if ($id_note) {
if (!$note_info) {
$note_info = get_db_row('ttodo_notes', 'id', $id_note);
}
$MACROS["_wo_note_created_by_user_"] = $note_info["written_by"];
$MACROS["_wo_notes_url_"] = $config["base_url"] . "/index.php?sec=projects&sec2=operation/workorders/wo&operation=view&tab=notes&id={$id_wo}";
$MACROS["_wo_note_info_"] = $note_info["description"];
$MACROS["_wo_note_delete_user_"] = $config["id_user"];
}
// Send email for assigned and creator of this workorder
$email_creator = get_user_email($wo['created_by_user']);
$email_assigned = get_user_email($wo['assigned_user']);
switch ($mode) {
case 0:
// WO update
$text = template_process($config["homedir"] . "/include/mailtemplates/wo_update.tpl", $MACROS);
$subject = template_process($config["homedir"] . "/include/mailtemplates/wo_subject_update.tpl", $MACROS);
break;
case 1:
// WO creation
$text = template_process($config["homedir"] . "/include/mailtemplates/wo_create.tpl", $MACROS);
$subject = template_process($config["homedir"] . "/include/mailtemplates/wo_subject_create.tpl", $MACROS);
break;
case 3:
// WO deleted
$text = template_process($config["homedir"] . "/include/mailtemplates/wo_delete.tpl", $MACROS);
$subject = template_process($config["homedir"] . "/include/mailtemplates/wo_subject_delete.tpl", $MACROS);
break;
case 4:
//New note
$text = template_process($config["homedir"] . "/include/mailtemplates/wo_new_note.tpl", $MACROS);
$subject = template_process($config["homedir"] . "/include/mailtemplates/wo_subject_new_note.tpl", $MACROS);
break;
case 5:
//Delete note
$text = template_process($config["homedir"] . "/include/mailtemplates/wo_delete_note.tpl", $MACROS);
$subject = template_process($config["homedir"] . "/include/mailtemplates/wo_subject_delete_note.tpl", $MACROS);
break;
}
$msg_code = "WO#{$id_wo}";
$msg_code .= "/" . substr(md5($id_wo . $config["smtp_pass"] . $wo["assigned_user"]), 0, 5);
$msg_code .= "/" . $wo["assigned_user"];
integria_sendmail($email_assigned, $subject, $text, false, $msg_code);
$msg_code = "WO#{$id_wo}";
$msg_code .= "/" . substr(md5($id_wo . $config["smtp_pass"] . $wo["created_by_user"]), 0, 5);
$msg_code .= "/" . $wo["created_by_user"];
integria_sendmail($email_creator, $subject, $text, false, $msg_code);
}
function mail_todo($mode, $id_todo)
{
global $config;
$todo = get_db_row("ttodo", "id", $id_todo);
$tcreated = $todo["created_by_user"];
$tassigned = $todo["assigned_user"];
// Only send mails when creator is different than owner
if ($tassigned == $tcreated) {
return;
}
$tlastupdate = $todo["last_update"];
$tdescription = wordwrap($todo["description"], 70, "\n");
$tprogress = translate_wo_status($todo["progress"]);
$tpriority = get_priority_name($todo["priority"]);
$tname = $todo["name"];
$url = $config["base_url"] . "/index.php?sec=todo&sec2=operation/todo/todo&operation=update&id={$id_todo}";
switch ($mode) {
case 0:
// Add
$text = "TO-DO '{$tname}' has been CREATED by user {$tcreated}. You could track this todo in the following URL (need to use your credentials): {$url}\n\n";
$subject = "[" . $config["sitename"] . "] New TO-DO from '{$tcreated}' : {$tname}";
break;
case 1:
// Update
$text = "TO-DO '{$tname}' has been UPDATED by user {$tassigned}. This TO-DO was created by user {$tcreated}. You could track this todo in the following URL (need to use your credentials): {$url}\n\n";
$subject = "[" . $config["sitename"] . "] Updated TO-DO from '{$tcreated}' : {$tname}";
break;
case 2:
// Delete
$text = "TO-DO '{$tname}' has been DELETED by user {$tassigned}. This TO-DO was created by user {$tcreated}. You could track this todo in the following URL (need to use your credentials): {$url}\n\n";
$subject = "[" . $config["sitename"] . "] Deleted TO-DO from '{$tcreated}' : {$tname}";
}
$text .= "\n\t\t---------------------------------------------------------------------\n\t\tTO-DO NAME : {$tname}\n\t\tDATE / TIME : {$tlastupdate}\n\t\tCREATED BY : {$tcreated}\n\t\tASSIGNED TO : {$tassigned}\n\t\tPROGRESS : {$tprogress}\n\t\tPRIORITY : {$tpriority}\n\t\tDESCRIPTION\n\t\t---------------------------------------------------------------------\n\t\t{$tdescription}\n\n";
$text = ascii_output($text);
$subject = ascii_output($subject);
// Send an email to both
integria_sendmail(get_user_email($tcreated), $subject, $text);
integria_sendmail(get_user_email($tassigned), $subject, $text);
}
