$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); }