Interface to admin sent postcards

+1

It would certainly be nice to know what images are being forwarded using this module and which ones are not.

Here's some code you can use as a new page. It creates a table listing who the postcard was to (includes a link to view the postcard via the review interface), the recipient's email address, the date and time sent, the number of times the postcard has been viewed (views via review interface don't get logged) and the email address used to send the postcard.

The listing is based on the authenticated user viewing the page.

Not completely what you're asking for, but maybe it'll work until we get a viewing interface properly folded into the module. I'm not going to add code to remove the postcard as I don't yet understand the DB well enough.

I'd prefer the ability to unpublish the postcard without actually deleting it from the DB anyway :).

global $user, $base_url;

  // set the base variable from the clean url value
  if (variable_get('clean_url', 0)) {
    $base = $base_url .'/';
  }
  else {
    $base = $base_url .'/index.php?q=';
  }

print "<div>\n";
print "<a href='$base_url/postcard'>Postcard</a>s you have sent.\n";

$postcards = db_query("SELECT pid, nid, sender_mail, recp_name, recp_mail, send_time, count_view from {postcard} where uid = '%d' order by send_time desc", $user->uid );

if( isset( $postcards ) ) {
  print "<table>\n\t<tr><th>To</th><th>Recipient Email Address</th><th>Time Sent</th><th>Times viewed</th><th>From</th></tr>\n";
  while( $node = db_fetch_object( $postcards) ) {
    $card_url = "${base}postcard/$node->nid/$node->pid/review";
    $card_link = "<a hover { content:$node->recp_mail } href=\"$card_url\">$node->recp_name</a>";
    //printf( "<p>You sent a postcard from %s to %s at %s. It has been viewed %s times.\n</p>", $node->sender_mail, $card_link, format_date($node->send_time), $node->count_view );
    printf( "<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>\n", $card_link, $node->recp_mail,format_date($node->send_time), $node->count_view,$node->sender_mail );
  }
  print "</table>\n";
}

print "</div>\n";

add1sun,

this won't work as a patch. It's actually for building a page outside the module.

I'm using it now as a stopgap because I haven't yet figured out how to add this to the module :).

Thanks for the pointer to theme_table! I need to learn the drupal way for that type of thing.

I will also be following the links you posted in another thread for learning to code for drupal.

Hopefully I can figure out how to properly add this to the module.

danke,

der.hans

Here's an update to the above.

It now does a table the drupal way by following the documentation add1sun pointed out.

It also now has a pager.

Careful when copying the URL as the pager depends on capitalizing SQL keywords.

This is meant to be used in building a web page via create content and not to be part of the postcard module. It's a temporary measure until we get a management interface added to the module.

  global $user, $base_url;

  // set the base variable from the clean url value
  if (variable_get('clean_url', 0)) {
    $base = $base_url .'/';
  }
  else {
    $base = $base_url .'/index.php?q=';
  }

  // Number of results per page.
  $nrpp = 10;
  $caption = "<a href='$base_url/postcard'>Postcard</a>s you have sent.";
  $no_results_text = "You haven't yet sent any <a href='$base_url/postcard'>postcard</a>s.\n";
  // Default message. Overridden if there's actually data.
  $output = $no_results_text;

  $header = array( array( 'data' => 'To', 'field' => recp_name ), array( 'data' => 'Recipient Email Address', 'field' => recp_mail ), array( 'data' => 'Time Sent', 'field' => send_time, 'sort' => 'desc'  ), array( 'data' => 'Times Viewed', 'field' => count_view), array( 'data' => 'From', 'field' => sender_mail ) );

  // Query to grab postcard instance info for the user.
  $sql = "SELECT pid, nid, sender_mail, recp_name, recp_mail, send_time, count_view FROM {postcard} WHERE uid = $user->uid";
  // Add dynamic sort to the query.
  $sql .= tablesort_sql( $header );
  // Page the results. Limits until the rest of the paging info is added.  
  $postcards = pager_query( $sql, $nrpp );

  // Create a pager for going through results.
  $pager = theme_pager( NULL, $nrpp );

  if( isset( $postcards ) ) {
    while( $node = db_fetch_object( $postcards) ) {
      $card_url = "${base}postcard/$node->nid/$node->pid/review";
      $card_link = "<a hover { content:$node->recp_mail } href=\"$card_url\">$node->recp_name</a>";
      $rows[] = array( $card_link, $node->recp_mail, format_date($node->send_time),  $node->count_view, $node->sender_mail );
    }
  }

  // Add the pager to the table if needed
  if ( count($rows) ) {
    $rows[] = array(array('data' => $pager, 'colspan' => '5'));
    // If we have rows for a table, theme the table.
    $output = theme_table( $header, $rows, '', $caption );
  }

  print "<div>\n";
  print "$output\n";
  print "</div>\n";