Re: [Phphelpdesk-help] customize addjob

[Ed B. <eba...@ta...>]

I cut'n'pasted something similar into my addjob.scp.php and vj_closejob.scp=
.php files to give me this functionality.  if you replace

$mailto =3D "$t_useremail";

with=20

$mailto =3D getuseremailaddress($Company);

and you've set each school's/department's email address to the principal's =
email address, it should do what you want.  The getuseremailaddress() =
function is below.  I'm a PHP/MySQL newbie, so it's probably not the =
fastest way to do it, but it works for me.

Edward Barrett

-- start of getuseremailaddress() --
function getuseremailaddress($ticketdept) {
        $querydeptintname =3D "SELECT s_user from userdepartments ";      =
// This gets me
        $querydeptintname .=3D "WHERE d_name=3D'$ticketdept' ORDER BY =
s_user;";     // Internal name of group so I can find email in next query
        $mysql_result =3D query($querydeptintname);
        $row =3D mysql_fetch_array($mysql_result);
        $queryemail =3D "SELECT s_email from security "; // This gets me
        $queryemail .=3D "WHERE s_user=3D'$row[0]';";      // The email of =
the group
        $mysql_result =3D query($queryemail);
        $row =3D mysql_fetch_array($mysql_result);
        $email =3D $row[0];
        return $email;
}
-- end of getuseremailaddress() --
>>> <JFe...@ao...> 12/08/01 03:16PM >>>
Hello,
  I work for a medium sized school system and I am trying to customize =
phphelpdesk to better suit our needs. I have setup my departments to =
represent each school. I would like to automatically send an email to each =
principal of the school/department whenever a ticket is opened for thier =
school. I don't want this to be a user available option. Just something =
that happens behind the scenes. Here's what I've done so far:
--snip--

--
F. Edward Barrett
Network Specialist, Traverse Area District Library
http://tadl.tcnet.org