confirmation popup

KoshNaranek

I'am writing a Trouble-Ticket-System, at the moment.

Here is what i want:

if the assignee isn't online, a popup asks:

Asignee isn't online at the moment!
Do you want to inform him via email?
YES | NO

Klicking YES should send out a email -- what else 😉

phpMyAdmin does something similar, performing a "DELETE"-Query...

I know how to query who's online... i know how to code this "normaly"... but i want a popup 🙂

need a litte advice...

PatrikG

Use some good ole Javascript and have

written by PHP when the assignee isn't online.

If OK is clicked, call your email-page either via submit (if you're using a form) or parsable URL.

jamie_kerwick

to use a pop-up window would require the use of javascript.

You would need to do something like

How is the assignee selected, & when do you check whether they are online or not.
ie. is the online status checked when the form is submitted ??

Jamie

KoshNaranek

it's one of the oldest scripts in this ticket-system... it was my 1st try with php... its a bit "quick'n'dirty" ... partly nonsens but working 😃

here is a part of the script:

if ($action=='show' OR !$action){
/** table displaying the case **/
}

if ($action=='save'){
    if(!$contact OR !$Text) {
        include ("./include/case_head.inc");
        echo "<font color=$FONTCOLOR1 face=$FONTFACE>";
        echo "<center><h1>".MSG_ERR_NOTALLFIELDS."</h1><p>";
        echo "<b>".MSG_MSG_USEBACK."<br>".MSG_MSG_FILLOUTSTAR."</b>";
        echo "<a href='javascript:history.back()'>".MSG_FU_BACK."</a>";
        echo "</font></center></body></html>";
        die();
        }
        $shortD=$top_1."/".$top_2."@".$top_a;
        $clb='';
        $cld="''";
     if ($status=='closed' AND $memStatus!='closed') {
            $clb=$admin;
            $cld='now()';
         $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'CLOSE', 'Case has been closed by $admin', now());";
             mysql_query($hist);
     }
        if ($status=='closed' AND $mailsenden=='yes'){

        $muster="^[_a-zA-Z0-9-](\.{0,1}[_a-zA-Z0-9-])*@([_a-zA-Z0-9-]{2,}\.)";
            $muster.="{0,}[_a-zA-Z0-9-]{3,}(\.[_a-zA-Z0-9-]{2,4}){1,2}$";
        if (ereg($muster, $contact))
        { $mailsenden='yes'; }
        else { $mailsenden='no'; }
     if ($Prio=='HOTLINE'){$mailsenden='no';}
        if ($mailsenden=='yes'){
         $mailsubj="Case #$id - $shortD - Status: $status";
        $mailmsg="Ihre Anfrage wurde bearbeitet, erledigt und geschlossen.\n \n";
        $mailmsg.="Ihre Anfrage lautetete: \n\n";
        $mailmsg.="--------------------------------------------------------\n";
        $mailmsg.=$Text;
        $mailmsg.="\n--------------------------------------------------------\n\n";
        $mailmsg.="Die Anfrage wurde in unserem Case-System unter der Nummer $id bearbeitet.\n\n";
        $mailmsg.="Bei Reklamationen senden Sie uns bitte ein Mail (ANTWORT MIT PROTOKOLL)\n";
        $mailmsg.="oder rufen Sie uns an: 0800-xxxxx.\n\n";
        $mailmsg.="\n\nMit freundlichem Gruss \n \n";
        $mailmsg.="Case-System@domain.com \n\n";
        $headers  = "MIME-Version: 1.0\r\n";
        $headers .= "Content-type: text/plain; charset=iso-8859-1\r\n";
        $headers .= "From: [email]Case-System@domain.com[/email] <dv-support@domain.com>\r\n";
     @mail("$contact",$mailsubj , $mailmsg, $headers);
        $abfrage="INSERT INTO Case_Msg (id, AsocId, openBy, openDate, sentTo, Type, ShortText, Text, visible) ";
        $abfrage.="VALUES('', $id, 'Case-System', now(), '$contact', 'mail_out', 'Mail sent: Case closed', '$mailmsg', '1') ";
        $result=mysql_query($abfrage);
        }
    }
    include ("./include/case_head.inc");
    $zuweisung=explode("/", $assto);
    $abfrage="UPDATE Case_Main SET Contact='$contact', Short='$shortD', Top1='$top_1', Top2='$top_2', TopAddI='$top_a', HWID='$hwid1', ";
    $abfrage.="Summary='$Text', Priority='$Prio', Status='$status', assignedTo='$zuweisung[1]', assignedGroup='$zuweisung[0]', closeBy='$clb', ";
    $abfrage.="closeDate=$cld where id='$id'";
    mysql_query($abfrage);

/** PUT HERE: check online-status of assignee - sendmail if not **/

 if ($memPrio <> $Prio){
         $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'PRIORITY', 'Priority has been changed FROM $memPrio TO $Prio  by $admin', now());";
         mysql_query($hist);
 }
 if ($status<>'closed' and $memStatus <> $status){
         $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'STATUS', 'Status has been changed FROM $memStatus TO $status  by $admin', now());";
         mysql_query($hist);
 }
 if ($mematg <> $zuweisung[0]){
         $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'MOVE', 'AssignedGroup has been changed FROM $mematg TO $zuweisung[0]  by $admin', now());";
         mysql_query($hist);
 }
 if ($memat <> $zuweisung[1]){
         $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'MOVE', 'Assignee has been changed FROM $memat TO $zuweisung[1]  by $admin', now());";
         mysql_query($hist);
 }

if ($status=='reopen')        {
    $abfrage1="INSERT INTO Case_Msg (id, AsocId, Type, openBy, openDate, ShortText, visible) ";
    $abfrage1.="VALUES ('', '$id', 'system', '$admin', now(), 'Case has been reopened','1')";
    mysql_query($abfrage1);
     $hist="INSERT INTO Case_Audittrail (id, AsocId, Short, Audit, AuditDate) VALUES ('', '$id', 'REOPEN', 'Case has been re-opened by $admin', now());";
    mysql_query($hist);
}
if ($status=='closed'AND $mailsenden=='yes'){echo MSG_MSG_NOTIFICATIONSENT."<br>";}
    echo "<center><h3>".MSG_MSG_SAVING."</h3>";
    echo "<meta http-equiv='refresh' content='1; URL=$PHP_SELF?Radio=$id'>";
    echo "<a href='case_main.php'><li>Cases</a>";
    echo "</center></font></body></HTML>";
} ?>

<? }

jamie_kerwick

From that i'm guessing, that the form is totally blank,
Users input the information and select who the assignee is.

The form is then submitted,
the online status of assignee is then tested.

In this case you would need to either ,

a) change it so that all possible assignee statuses are checked, then using javascript, check the status depending on the assignee selected. something like

<script language="Javascript">
<!-- hide
var offline = new Array(1,0,1,1,1) // this array is populated by PHP, 1 means use is offline, 0 means online
function isonline(assignee_number)
{
    if (offline[assignee_number] == 0)
    {
           notonline();
    }
}
function notonline() 
{ 
if (confirm("This user is not online, do you want to send an email instead?")) 
{ 
      formname.sendemail = 1; 
} 
else 
{ 
      formname.sendemail = 0; 
} 
} 
</script>

You would then have an variable $sendemail passed by the form.

or
b)On submitting the form, check to see if the assignee is online, if not, you would need to output another page which is something like:

<head>
<script language="Javascript">
<!-- hide
function notonline() 
{ 
if (confirm("This user is not online, do you want to send an email instead?")) 
{ 
      formname.sendemail = 1; 
} 
else 
{ 
      formname.sendemail = 0; 
} 
} 
</script>
</head>
<body onLoad="formname.submit()">
<form name=formname onSubmit=notonline()>
<input type=hidden name=sendemail value=0>
<input type=hidden name=form_variable1 value=$form_variable1
........
</form>

The idea being it shows a blank page, with all of the form values in hidden vars (or you could just show the table again. thats really upto you)
The <body onload> automatically submits the form. You may need to experiment with the placement of the formname.submit(), it may not work in onLoad, you may just have to put

<script language="Javascript">
formname.submit();
</script>

at the very end of the page.

Jamie

KoshNaranek

in VB it is:

REM Popup a Windows-Dialog with a "bubble-?"
reply=MsgBox$("User " & assigne$ & " isn't online" & vbcrlf & "Do you want to send a email?",vbYesNo+vbQuestion,"send a mail?")

if reply=vbYes then
REM YES was clicked
...call the mailfunction...
end if

that's a peace of cake 😃

PHP is a little uncomfortable here :rolleyes:

jamie_kerwick

It can be a bit awkward, because PHP is server side it acts based on requests sent to the server,
so you can only give it new information (ie from user interaction) by sending information to the server (in the form of a get or post request).
It cannot act directly on a user (client) action.

Jamie

Weedpacket

Originally posted by KoshNaranek
in VB it is:

REM Popup a Windows-Dialog with a "bubble-?"

PHP is a little uncomfortable here :rolleyes:

Well, PHP can't open dialogue boxes on the client, can it?

What I've done in the past, when I've needed PHP to bring up dialogue boxes on the client (so that they look exactly the same as the Javascript-generated ones) is to have PHP to insert an onload= handler into the page it returns in its response that will call a function to bring up the dialogue and deal appropriately with the result.

KoshNaranek

Here is my idea, how it should be

        /** Assignee online? **/
        $temp="SELECT * FROM online WHERE Username like '$zuweisung[1]' and online='YES';";
        $tresult=mysql_query($temp);
        if (mysql_numrows($tresult)=='0')       {
            /** no... he isn't! **/
            echo"<h2>ASSIGNEE NICHT ONLINE!</h2>";

        /** now the popup should appear 'send a mail?' **/
        /** if YES is clicked, the emailadress of the assignee ($zuweisung[1])
            is selected from the table users - doing this: **/
        $temp="SELECT Email from Users where Username like '$zuweisung[1]';";
        $tresult=mysql_query($temp);
        $sendto=mysql_result($tresult,0,'email');
        /** send a mail: **/
        $headers .= "Content-type: text/plain; charset=iso-8859-1\r\n";
        $headers .= "From: [email]Case-System@domain.com[/email] <dv-support@domain.com>\r\n";
        @mail("$sendto","Please check your Trouble-Ticket-System" , "There was a Case assigned to you", $headers);

    }

jamie_kerwick

That is the correct process, unfortunately, though, you cannot do that all in one page request.
As i said earlier, PHP can only take input from a get or post request, it CANNOT act on user input
.
It is a SERVER SIDE client, to have CLIENT interaction like that needs CLIENT SIDE scripting.
The only way to do it is to split it into sections like I did earlier.

So the user submits the form to the server.

The server checks if the assignee is online, if not it sends a page asking the user if they want to send an email instead.

The user then selects either yes or no.

The server then either sends the email or not (+ whatever else it needs to do)

Hope this clears things up

KoshNaranek

got it...

so.... i have to "refresh" the page after saving
"?action=checkonline"
this action "refresh"'s to "?action=askmail"
this action "refresh"'s to "?action=mailassignee"
or "?action=show"

Grrrrr... thats to much for this time... i will add this function later.

It's on the "nice to have"-List, again 😃

Thanks so far...

jamie_kerwick

Originally posted by KoshNaranek
got it...

so.... i have to "refresh" the page after saving
"?action=checkonline"
this action "refresh"'s to "?action=askmail"
this action "refresh"'s to "?action=mailassignee"
or "?action=show"
..

It's on the "nice to have"-List, again 😃

Thanks so far...

Thats exactly right, yes. A mild annoyance, but unfortunately thats the way its gotta be.

Jamie