$subject = $mail->partSubject . ": " . $requestDetail->sr_id[0];
$body = $mail->partMessage . "";
$body .= "" . $requestDetail->sr_pro_name[0] . "";
}
$body .= "\n\n" . $strings["id"] . " : " . $requestDetail->sr_id[0] . "\n" . $strings["subject"] . " : " . $requestDetail->sr_subject[0] . "\n" . $strings["status"] . " : " . $requestStatus[$requestDetail->sr_status[0]] . "\n" . $strings["details"] . " : ";
if ($listTeam->tea_mem_profil[$i] == 3) {
$body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $requestDetail->sr_project[0] . "\n\n";
} else {
$body .= "{$root}/general/login.php?url=support/viewrequest.php%3Fid={$num} \n\n";
}
if ($listTeam->tea_mem_email_work[$i] != "") {
$mail->Subject = $subject;
$mail->Priority = "3";
$mail->Body = $body;
$mail->AddAddress($listTeam->tea_mem_email_work[$i], $listTeam->tea_mem_name[$i]);
$mail->Send();
$mail->ClearAddresses();
}
}
} else {
$tmpquery = "WHERE mem.id = '1'";
$userDetail = new request();
$userDetail->openMembers($tmpquery);
if ($userDetail->mem_email_work[0] != "") {
$mail->partSubject = $strings["support"] . " " . $strings["support_id"];
$mail->partMessage = $strings["noti_support_request_new2"];
$subject = $mail->partSubject . ": " . $requestDetail->sr_id[0];
$body = $mail->partMessage . "";
$body .= "" . $requestDetail->sr_subject[0] . "";
$body .= "\n\n" . $strings["id"] . " : " . $requestDetail->sr_id[0] . "\n" . $strings["subject"] . " : " . $requestDetail->sr_subject[0] . "\n" . $strings["status"] . " : " . $requestStatus[$requestDetail->sr_status[0]] . "\n" . $strings["details"] . " : ";
$body .= "{$root}/general/login.php?url=support/viewrequest.php%3Fid={$num} \n\n";
$sql = "SELECT tas.id, tas.name, pro.id, pro.name, tas.priority, tas.status, tas.due_date\r\n FROM " . $tableCollab["tasks"] . " tas, " . $tableCollab["projects"] . " pro\r\n WHERE tas.status IN (2,3) \r\n AND tas.project = pro.id\r\n AND tas.assigned_to = '{$staffid}'\r\n ORDER BY tas.due_date, tas.status";
$rows = mysql_query($sql, $res);
while ($row = mysql_fetch_row($rows)) {
if ($row[6] < $datenow) {
$content .= task_row($row, $late_task_color);
} elseif ($row[6] == $datenow) {
$content .= task_row($row, $today_task_color);
} else {
$content .= task_row($row, $normal_task_color);
}
}
$content .= task_footer();
// set up the email object
$tasknotice = new notification();
$tasknotice->From = $from_email;
$tasknotice->FromName = $from_name;
$tasknotice->Subject = $subject_txt;
$tasknotice->Body = $content;
$tasknotice->AddAddress($email);
// $tasknotice->getUserinfo($staffid,"to");
if ($send_html) {
$tasknotice->IsHTML("true");
$tasknotice->AltBody = "this message uses html entities, but you prefer plain text !";
}
// send the email
if (!$tasknotice->Send()) {
echo "Message was not sent\n";
echo "Mailer Error: " . $tasknotice->ErrorInfo . "\n\n";
}
}
@mysql_close($res);
