next »

[jgold723]

I've added calendar fields for contact information for people posting events subject to approval.

I'd like to be able to see that info when I view events pending approval -- but not have it posted on the calendar.

I tried to alter the approve.html page in the Admin section, but it doesn't bring up the data.

What else do I need to change to make this happen?

Thanks,

John

[eladyar]

Did you add the fields on the customize user database screen?

You might want to add them as custom event fields, and then not show them in the details or make them searchable.

------------------
Dale Ray
http://www.sscsoftball.org

[jgold723]

I didn't -- because it didn't seem that any info from this database was called when viewing events awaiting approval (all events can be posted by "anonymous".

But I'm willing to give it a shot.

John

------------------

[DanO]

** I've added calendar fields **

You added event fields or fields to the user database?

** I tried to alter the approve.html page in the Admin section **

What code did you try?

If you added the new field to the event database, in the approve.html template where there are lines of code like:

<B>Title: </B><%=$title%><BR>
<B>Description: </B><%=$desc%><BR>
<B>Author: </B><%=$author%><BR>
<B>ID: </B><%= $id%><BR>
<B>Schedule: </B><%= &Event::getScheduleDescription($e->{'schedule'}) %><BR>

You would have to add something like

<B>Contact: </B><%= $e->{'details'}->{'Field_Key'} %><BR>

where Field_Key is the key of the event field you wanted printed there.

Dan O.

------------------

[jgold723]

Hi Dan:

I'm not certain what the field key is -- I was assuming it was the name the program automatically generates for a new field. If not this may be my problem. Here's what I did:

I added two fields to the Event Database:

email
telephone

Then I found the code you mentioned in approve.html and altered it to include my fields, like so:
-----------------------------
<%
$total = 0;
foreach $e (@$events) {
   $total++;
   $id = $e->{'details'}->{'id'};
   $title = $e->{'details'}->{'title'};
   $telephone = $e->{'details'}->{'telephone'};
   $email = $e->{'details'}->{'email'};
   $desc = $e->{'details'}->{'description'};
   $author = $e->{'details'}->{'author_name'}." (".$e->{'details'}->{'author_id'}.")";
%>
<TR>
   <TD ALIGN="center" VALIGN="top">
      <SELECT NAME="APPROVE_<%=$id%>"><OPTION VALUE="">No Action</OPTION><OPTION VALUE="APPROVE">Approve</OPTION><OPTION VALUE="REJECT">Reject</OPTION></SELECT>
      <BR>
      <INPUT TYPE="button" CLASS="button" VALUE="Edit" onClick="edit_event('<%=$id%>')">
   </TD>
   <TD ALIGN="left" VALIGN="top">
      <B>Title: </B><%=$title%><BR>
      <B>Description: </B><%=$desc%><BR>
      <B>Telephone: </B><%=$telephone%><BR>
      <B>Email: </B><%=$email%><BR>
      <B>Author: </B><%=$author%><BR>
      <B>ID: </B><%= $id%><BR>
      <B>Schedule: </B><%= &Event::getScheduleDescription($e->{'schedule'}) %>

-----------------------------
Now, when I get the approval page, I see the event data, and the labels (Email: and Telephone: ) for the email and telephone, but no data in the space next to the labels.

Thanks,

John

------------------

[DanO]

** I'm not certain what the field key is -- I was assuming it was the name the program automatically generates for a new field. **

Yes.

** when I get the approval page, I see the [field] labels (Email: and Telephone: ) but no data  **

I don't know why that would be unless you misspelled something.

Instead of doing the
$telephone = $e->{'details'}->{'telephone'};
thing, just put the variables directly where they're going to be printed like I showed previously. The less typing you do, the less chance of making mistakes.

JMO

Dan O.

[This message has been edited by DanO (edited September 12, 2003).]

[wderzawiec]

Does anyone know of a way to have the approval page show all of the fields for an event?  (excluding the schedule, I see there are posts on that).

I tried <%=$e->{'details'}->{'$_'}%> but that doesn't show anything.   I could add lines for each field as is already on the approval page, but not all my calendars have the same fields.   Thank you.

[DanO]

I though I answered this earlier today but I guess not...

What you want to do is more complicated to accomplish. Basically you would have to loop through each $e variable from the previous foreach loop, printing each value out. It should also be possible to skip the displaying of blank fields at that time if wanted.

I can not tell you the exact code to use but there is code in the default.html template just after <%-- EVENT VIEW --%> which might give you an idea of how to go about retrieving the event record data? It goes about it slightly differently however looping through the registered event field names and then looking for those names in the event record data.

JMO

Dan O.

[wderzawiec]

**I though I answered this earlier today but I guess not. . . **

Sorry I did not see anything.

** What you want to do is more complicated to accomplish.  Basically you would have to loop through each $e variable from the previous foreach loop, printing each value out.  It should also be possible to skip the displaying of blank fields at that time if wanted.
I can not tell you the exact code to use but there is code in the default. html template just after <%-- EVENT VIEW --%> which might give you an idea of how to go about retrieving the event record data? It goes about it slightly differently however looping through the registered event field names and then looking for those names in the event record data.  **

That was helpful, thank you.   What I did was add a variable for $fields at the top of the approve. html page:
 $fields = &main::DBGetFieldsInDisplayOrder($events_db);

Then, within the foreach loop of events, underneath where it says
<B>Schedule: </B><%= &Event::getScheduleDescription($e->{'schedule'}) %><BR>,

I added another loop:
                <%
      foreach (@$fields) {
         next unless ($events_db->{'properties'}->{$_}->{'display_details'});
         %>
         <B><%=$events_db->{'properties'}->{$_}->{'name'}%>: </B><%=$e->{details}->{$_}%><br>
         <% } %>

It displays the Title twice, but I could take out the <B>Title: </B><%=$title%><BR> line if I want.   Thanks for your time and help.

[DanO]

** Sorry I did not see anything. **

I know I worked on it, I must not have posted it. 

** That was helpful, thank you. **

You're welcome. Thanks for posting the code in case others are interested.

Dan O.