<html>
<head>
<title>New Call</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<script language="php">
# Variables
$host=localhost;
$username=crs;
$password=callreg;
$databasename=crs;
$tablename=call;
# Connecting to database
$msg="Database connect ok";
if ($submit=="ok")
{
if ($monitor=="")
{
$monitor=0;
}
if ($notify=="")
{
$notify=0;
}
$connection=mysql_connect($host,$username,$password);
$insquery="INSERT INTO call (registrant,execid,clientid,notify,areaid,importanceid,statusid,timedatestamp,callmsg,monitor) VALUES ($registrant,$execid,$clientid,$notify,$areaid,$importanceid,$statusid,'$timedatestamp','$callmsg',$monitor)";
$result=mysql_db_query ($databasename, $insquery,$connection);
if ($result>0)
{
$msg="Query succesful, previous record added";
# now we're going to mail the record info
$callid=mysql_insert_id($result);
$result=mysql_db_query("crs","SELECT * FROM user WHERE userid=$execid",$connection);
$subrow=mysql_fetch_array($result);
$mailadres=$subrow["emailaddress"];
$pageradres=$subrow["pager"];
$result=mysql_db_query("crs","SELECT * FROM user WHERE userid=$registrant",$connection);
$subrow=mysql_fetch_array($result);
$registrant=$subrow["username"];
$result=mysql_db_query("crs","SELECT * FROM clients WHERE clientid=$clientid",$connection);
$subrow=mysql_fetch_array($result);
$clientid=$subrow["name"];
$clientemail=$subrow["email"];
$result=mysql_db_query("crs","SELECT * FROM area WHERE area_id=$areaid",$connection);
$subrow=mysql_fetch_array($result);
$areaid=$subrow["areastring"];
$result=mysql_db_query("crs","SELECT * FROM importance WHERE importanceid=$importanceid",$connection);
$subrow=mysql_fetch_array($result);
$importanceid=$subrow["importancestring"];
$result=mysql_db_query("crs","SELECT * FROM status WHERE statusid=$statusid",$connection);
$subrow=mysql_fetch_array($result);
$statusid=$subrow["statusstring"];
if ($notify==0)
$notify="Nee";
else
{
# we're going to notify our client here
$mailsubject="IC&S - CRS call #$callid @ $timedatestamp";
$mailmessage="Geachte Klant,\n\n";
$mailmessage=$mailmessage."Er is bij u een storing geconstateerd. Wij zijn druk bezig de storing zo snel mogelijk op te lossen. Indien u wilt weten wat de huidige status is van deze storing, kunt u een emailbericht sturen naar calls@ics-group.net of bellen naar 030-2519000. Hiervoor hebben wij wel uw callregistratienummer (in dit geval ".$callid.") nodig.\n";
$mailmessage=$mailmessage."\nMet vriendelijke groet,\n";
$mailmessage=$mailmessage."\nIC&S Support\n\n";
$mailmessage=$mailmessage."Omschrijving van de storing:\n";
$mailmessage=$mailmessage.$callmsg;
$notify="ja";
mail("$clientemail", "$mailsubject", "$mailmessage","From: crs@ics-group.net");
}
$mailsubject="IC&S - CRS call #$callid @ $timedatestamp";
$mailmessage="Er is een nieuwe call voor u aangemaakt door door $registrant\n";
$mailmessage=$mailmessage."-------------------------------------------------------\n";
$mailmessage=$mailmessage." Call informatie \n";
$mailmessage=$mailmessage."-------------------------------------------------------\n";
$mailmessage=$mailmessage."Client : ".$clientid."\n";
$mailmessage=$mailmessage."Notified : ".$notify."\n";
$mailmessage=$mailmessage."Area of call : ".$areaid."\n";
$mailmessage=$mailmessage."Importance : ".$importanceid."\n";
$mailmessage=$mailmessage."Status : ".$statusid."\n";
$mailmessage=$mailmessage."Date / Time : ".$timedatestamp."\n";
if ($monitor==1)
$mailmessage=$mailmessage."Deze storing is geconstateerd door Mon\n";
$mailmessage=$mailmessage."=======================================================\n";
$mailmessage=$mailmessage." Call message \n";
$mailmessage=$mailmessage."-------------------------------------------------------\n";
$mailmessage=$mailmessage.$callmsg;
mail("$mailadres", "$mailsubject", "$mailmessage","From: crs@ic-s.nl");
if (($pageradres!="") && ($importanceid=="MAX"))
{
$mailsubject="Urgent call! frm: ".$registrant." clt: ".$clientid." Stat: ".$statusid." ".$callmsg;
mail("$pageradres","$mailsubject","CRS MAX CALL","From: crs@ic-s.nl");
$msg=$msg." message has been paged";
}
}
else
{
$msg="Insert failed (did you check all fields?";
}
}
</script>
<body bgcolor="#FFFFFF">
<form action="newcall.php3" method="POST">
<table width="100%" border="1" bordercolorlight="#E3E3E3">
<tr>
<td colspan="4" bgcolor="#CCCCFF">
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="4">
<b>IC&S Call Registration System V1.0a</b></font></div>
</td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFFCC"><font face="Verdana, Arial, Helvetica, sans-serif">
<script language="php">
print ("<b>Call information [$msg]</font>");
</script></td>
</tr>
<tr>
<td width="16%"><font face="Verdana, Arial, Helvetica, sans-serif">Call registered
by</font></td>
<td width="28%"> <font face="Verdana, Arial, Helvetica, sans-serif">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM user WHERE username='$user'",$connection);
$myrow=mysql_fetch_array($result);
$userid=$myrow["userid"];
printf ("<input type=\"hidden\" name=\"registrant\" value=\"$userid\">");
printf ("<input type=\"hidden\" name=\"user\" value=\"$user\">");
printf ("<input type=\"hidden\" name=\"pass\" value=\"$pass\">");
printf ("$user");
</script>
</font></td>
<td width="22%"><font face="Verdana, Arial, Helvetica, sans-serif"> Date /
Time</font></td>
<td width="34%"> <font face="Verdana, Arial, Helvetica, sans-serif">
<script language="php">
$mydatetime=strftime("%Y-%m-%d %H:%M:%S");
printf ("<input type=\"hidden\" name=\"timedatestamp\" value=\"$mydatetime\">");
printf ("$mydatetime");
</script>
</font></td>
</tr>
<tr>
<td width="16%"><font face="Verdana, Arial, Helvetica, sans-serif">Call registered
to</font></td>
<td width="28%"> <font face="Verdana, Arial, Helvetica, sans-serif">
<select name="execid">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM user",$connection);
while ($myrow=mysql_fetch_array($result))
{
echo '<option value="'.$myrow["userid"].'">'.$myrow["username"].'</option>';
}
</script>
</select>
</font></td>
<td width="22%"><font face="Verdana, Arial, Helvetica, sans-serif">Concerning
client</font></td>
<td width="34%"> <font face="Verdana, Arial, Helvetica, sans-serif">
<select name="clientid">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM clients",$connection);
while ($myrow=mysql_fetch_array($result))
{
echo '<option value="'.$myrow["clientid"].'">'.$myrow["name"].'</option>';
}
</script>
</select>
(
<input type="checkbox" name="notify" value="1">
Notify)</font></td>
</tr>
<tr>
<td width="16%" height="31"><font face="Verdana, Arial, Helvetica, sans-serif">Area
of call</font></td>
<td width="28%" height="31"> <font face="Verdana, Arial, Helvetica, sans-serif">
<select name="areaid">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM area",$connection);
while ($myrow=mysql_fetch_array($result))
{
echo '<option value="'.$myrow["area_id"].'">'.$myrow["areastring"].'</option>';
}
</script>
</select>
</font></td>
<td width="22%" height="31"><font face="Verdana, Arial, Helvetica, sans-serif">Importance</font></td>
<td width="34%" height="31"> <font face="Verdana, Arial, Helvetica, sans-serif">
<select name="importanceid">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM importance",$connection);
while ($myrow=mysql_fetch_array($result))
{
echo '<option value="'.$myrow["importanceid"].'">'.$myrow["importancestring"].'</option>';
}
</script>
</select>
</font></td>
</tr>
<tr>
<td width="16%"><font face="Verdana, Arial, Helvetica, sans-serif">Status
of call</font></td>
<td width="28%"> <font face="Verdana, Arial, Helvetica, sans-serif">
<select name="statusid">
<script language="php">
$connection=mysql_connect("localhost","crs","callreg");
$result=mysql_db_query("crs","SELECT * FROM status",$connection);
while ($myrow=mysql_fetch_array($result))
{
echo '<option value="'.$myrow["statusid"].'">'.$myrow["statusstring"].'</option>';
}
</script>
</select>
</font></td>
<td width="22%"><font face="Verdana, Arial, Helvetica, sans-serif"></font>
Detected by Mon <input type="checkbox" name="monitor" value="1">
</td>
<td width="34%"><font face="Verdana, Arial, Helvetica, sans-serif"></font>
</td>
</tr>
<tr>
<td width="200%" colspan="4" bgcolor="#FFFFCC"><font face="Verdana, Arial, Helvetica, sans-serif"><b>Call
message</b></font></td>
</tr>
<tr>
<td width="200%" colspan="4"> <font face="Verdana, Arial, Helvetica, sans-serif">
<textarea rows="4" cols="100" name="callmsg"></textarea>
</font></td>
</tr>
<tr bgcolor="#CCCCFF">
<td width="200%" colspan="4">
<div align="right"> <font face="Verdana, Arial, Helvetica, sans-serif">
<input type="submit" name="submit" value="ok">
<input type="reset" name="reset" value="Reset">
</font></div>
</td>
</tr>
</table>
</form>
<form action="menu.php3" method="POST">
<script language="php">
printf ("<input type=\"hidden\" name=\"user\" value=\"$user\">");
printf ("<input type=\"hidden\" name=\"pass\" value=\"$pass\">");
</script>
<input type="submit" name="menu" value="Back to Menu">
</form>
</body>
</html>