<?php
// $Revision: 1.2 $
/* vim: set expandtab ts=4 sw=4 sts=4: */
/**
* $Id: noti_newrequest.php,v 1.2 2004/12/13 00:18:26 madbear Exp $
*
* Copyright (c) 2003 by the NetOffice developers
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*/
$mail = new notification();
$mail->getUserinfo($_SESSION['idSession'], "from");
$tmpquery = "WHERE sr.id = '{$num}'";
$requestDetail = new request();
$requestDetail->openSupportRequests($tmpquery);
if ($supportType == "team") {
$tmpquery = "WHERE tea.project = '" . $requestDetail->sr_project[0] . "'";
$listTeam = new request();
$listTeam->openTeams($tmpquery);
$comptListTeam = count($listTeam->tea_id);
for ($i = 0; $i < $comptListTeam; $i++) {
if ($_SESSION['idSession'] == $listTeam->tea_mem_id[$i]) {
$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] . "";
$userDetail = new request();
$userDetail->openMembers($tmpquery);
$comptUserDetail = count($userDetail->mem_id);
// test if user exists
if ($comptUserDetail == "0") {
$error = $strings["no_login"];
} else {
if ($userDetail->mem_email_work[0] != "") {
// test if email of user exists
password_generator();
$pw = get_password($pass_g);
$tmpquery = 'UPDATE ' . $tableCollab['members'] . " SET password='******' WHERE login = '******'";
connectSql($tmpquery);
$body = $strings['user_name'] . ' : ' . $userDetail->mem_login[0] . "\n\n" . $strings['password'] . " : {$pass_g}";
$mail = new notification();
$mail->getUserinfo('1', 'from');
$subject = 'NetOffice ' . $strings['password'];
$mail->Subject = $subject;
$mail->Priority = '1';
$mail->Body = $body;
$mail->AddAddress($userDetail->mem_email_work[0], $userDetail->mem_name[0]);
$mail->Send();
$mail->ClearAddresses();
// redirect to login page with message
header('Location: ../general/login.php?msg=emailpwd');
exit;
} else {
$error = $strings['no_email'];
}
}
$send = 'on';
<?php
$tmpquery = "WHERE tas.id IN({$id})";
$taskNoti = new request();
$taskNoti->openTasks($tmpquery);
$tmpquery = "WHERE pro.id = '{$project}'";
$projectNoti = new request();
$projectNoti->openProjects($tmpquery);
$tmpquery = "WHERE noti.member IN({$at})";
$listNotifications = new request();
$listNotifications->openNotifications($tmpquery);
$comptListNotifications = count($listNotifications->not_id);
if ($listNotifications->not_statustaskchange[0] == "0") {
$mail = new notification();
$mail->getUserinfo($idSession, "from");
$mail->partSubject = $strings["noti_prioritytaskchange1"];
$mail->partMessage = $strings["noti_prioritytaskchange2"];
if ($projectNoti->pro_org_id[0] == "1") {
$projectNoti->pro_org_name[0] = $strings["none"];
}
$complValue = $taskNoti->tas_completion[0] > 0 ? $taskNoti->tas_completion[0] . "0 %" : $taskNoti->tas_completion[0] . " %";
$idStatus = $taskNoti->tas_status[0];
$idPriority = $taskNoti->tas_priority[0];
$body = $mail->partMessage . "\n\n" . $strings["task"] . " : " . $taskNoti->tas_name[0] . "\n" . $strings["start_date"] . " : " . $taskNoti->tas_start_date[0] . "\n" . $strings["due_date"] . " : " . $taskNoti->tas_due_date[0] . "\n" . $strings["completion"] . " : " . $complValue . "\n" . $strings["priority"] . " : {$priority[$idPriority]}\n" . $strings["status"] . " : {$status[$idStatus]}\n" . $strings["description"] . " : " . $taskNoti->tas_description[0] . "\n\n" . $strings["project"] . " : " . $projectNoti->pro_name[0] . " (" . $projectNoti->pro_id[0] . ")\n" . $strings["organization"] . " : " . $projectNoti->pro_org_name[0] . "\n\n" . $strings["noti_moreinfo"] . "\n";
if ($taskNoti->tas_mem_organization[0] == "1") {
$body .= "{$root}/general/login.php?url=tasks/viewtask.php%3Fid={$id}";
} else {
if ($taskNoti->tas_mem_organization[0] != "1" && $projectNoti->pro_published[0] == "0" && $taskNoti->tas_published[0] == "0") {
$body .= "{$root}/general/login.php?url=projects_site/home.php%3Fproject=" . $projectNoti->pro_id[0];
}
}
$userDetail = new request();
$userDetail->openMembers($tmpquery);
$comptUserDetail = count($userDetail->mem_id);
//test if user exists
if ($comptUserDetail == "0") {
$error = $strings["no_login"];
//test if email of user exists
} else {
if ($userDetail->mem_email_work[0] != "") {
password_generator();
$pw = get_password($pass_g);
$tmpquery = "UPDATE " . $tableCollab["members"] . " SET password='******' WHERE login = '******'";
connectSql("{$tmpquery}");
$body = $strings["user_name"] . " : " . $userDetail->mem_login[0] . "\n\n" . $strings["password"] . " : {$pass_g}";
$mail = new notification();
$mail->getUserinfo("1", "from");
$subject = $setTitle . " " . $strings["password"];
$mail->Subject = $subject;
$mail->Priority = "1";
$mail->Body = $body;
$mail->AddAddress($userDetail->mem_email_work[0], $userDetail->mem_name[0]);
$mail->Send();
$mail->ClearAddresses();
$msg = 'email_pwd';
} else {
$error = $strings["no_email"];
}
}
$send = "on";
}
$notLogged = "true";
