Table Manger questions

Hey there :o)

Okay, I've updated the sorting function... It now sorts on the column you've clicked on, but if there's double matches it'll sort on the next column along. If that doesn't make obvious sense, here's an example:

New 03 Wilier Lampre Team carbon fork & Stays
New 04 Derosa Merak carbon fork & rear end
New 04 Giant TCR
New 04 Look AL384, Look Carbon Fork + Stays (Slope)
New 04 Look KX Lite full carbon
New 04 Massi CM4000 (no fork)
New 04 Massi CM4000, No Fork
New 05 Ambrosio Rapide (very small)

Notice that where the first column is the same, it sorts on the next column along instead.

I've also finished programming for the main permissions functions and so next I'm going to look into your idea for that... Watch this space! :o)

Oh and by the way, I've now finished both the add and delete column functions, the most current version should allow you to do all this now:

http://cvs.drupal.org/viewcvs/*checkout*/drupal/contributions/modules/ta...

Pobster

Without wanting to sound rude... How on earth could it be possible? Tablemanager isn't magic you know? ;o)

If it's possible to export your table in a csv format (comma separated values) then you can copy the csv into tablemanagers csv import function and tablemanager should be able to create a table of its own from that?

Pobster

Well obviously as I didn't write the print module I'm not familiar with how it works but it should be pretty simple to just create a custom version of it's main display function.

/**
 * Outputs a printer friendly page.
 */
function print_generate_node($title) {
  global $base_url;

  /* We can take a node id or a node title */
  $node = (is_numeric($title)) ? node_load(array('nid' => $title)) : node_load(array('title' => $title));
  if (!$node->title) return false;

  $teaser = false;
  $page = true;
  /* This section is ripped from node_view.
     This does everything node_view does except theme the node! */

  // Remove the delimiter (if any) that separates the teaser from the body.
  // TODO: this strips legitimate uses of '<!--break-->' also.
  $node->body = str_replace('<!--break-->', '', $node->body);

  // The 'view' hook can be implemented to overwrite the default function
  // to display nodes.
  if (node_hook($node, 'view'))
    node_invoke($node, 'view', $teaser, $page);
  else
    $node = node_prepare($node, $teaser);
  // Allow modules to change $node->body before viewing.
  node_invoke_nodeapi($node, 'view', $teaser, $page);

  /* End of code stealing from node_view() */

  // associative array settings
  $print_settings = variable_get('print_settings', NULL);

  if (!isset($print_settings['urls']) || !empty($print_settings['urls'])) {
    /* Collect links and display them at the bottom of the page. Code once taken from Kjartan Mannes' project.module  */
    $pattern = "@<a.*?href=([\']?[\"]?)([^\"|^\'|^|^>]*)([^>]*)>(.+?)</a>@ise";
    $node->body = preg_replace($pattern, "'<u>'.stripslashes('\\4').'</u> ['. print_friendly_urls(stripslashes('\\2')) .']'", $node->body);
    $urls = print_friendly_urls();
    if (count($urls)) {
      $node->pfp_links = '';
      $max = count($urls);
      for ($i = 0; $i < $max; $i++) {
        $node->pfp_links .= '['. ($i + 1) .'] '. $urls[$i] ."<br />\n";
      }
    }
  }

  $node->logo = !empty($print_settings['logo_url']) ? $print_settings['logo_url'] : theme_get_setting('logo');

  /* Grab and format the src URL */
  $node->source_url = $base_url . url("node/$node->nid");
  $node->language = $GLOBALS['locale'];
  $node->printcss = empty($print_settings['css']) ? 'misc/print.css' : $print_settings['css'];

  $robots_meta = _print_robots_meta_generator();

  include_once('print.node.tpl.php');
}

If you follow the code you'll see that all it does is 'load up' the $node object with the data it needs to display on the printer friendly page. All you have to do is pass your custom function the data you need to display on that page and create a printer friendly link to display that custom function. Job done!

Pobster

Helloooooo :o)

TBH this was my overall goal with tablemanager, I've coded it to be easily 'upgradeable' for adding new field types. It wasn't next on my 'to-do' list (to add some more I mean) but I can make it next if you like? :o) Currently I'm struggling over adding cell attributes, so it'd be a welcome rest!!! ;o)

I'll start on adding a selection box feature this week, it shouldn't take too long.

Pobster

-- ArcadeGeek.co.uk --

Wow! That really *is* a wild idea!!! ;o)

Well... It's already possible in a 'hackish' type way (I've just tested this and it does indeed work...) it's not ideal though... Try it and you'll see what I mean:

Install attached_node module
As it's an input filter assign it to 'full html' or whatever you prefer
Create a test table and use the node id for one of your polls as the content of a table cell

In my test case I used:

[node:15]

You'll now have a poll embedded in your table. The reason I say it's not ideal is that using attached_node means you kind of have a 'mini' page displayed rather than only the poll... But then again I guess this is helpful in a way as then the polls title is displayed. Try it and see what you think?

Thanks

Pobster

Woops my bad, i didn't notice tablemanager setting ^^;

Sorry yeah that is a known bug, it's because I stupidly made the selection box options 'required' - just stick a space (or anything) in that box and it'll ignore it. Sorry my bad...

Incidentally, apologies that it's all gone quiet on the Tablemanager front. I'm afraid I'm seriously lacking in time at the moment and what time I do get to play around I'm devoting to a rewrite (ready for Drupal 5.0) - don't panic though, you'll easily be able to run update.php to upgrade your existing tables. Part of the *new* exciting features is a 'SUM' cell for numeric columns which will work exactly like a spreadsheet does and auto-update the total on every new row added/ altered. Whilst this is also possible with how the db is structured now, I figured I'd finally make my life a bit easier and lose the serialized arrays ;o) It opens the doors for much easier coding to add new features unlike now where everything feels like a messy hack...

Pobster

Uhhhh - yeah, look at the modules issues page, it's been known for ages. Changes to Drupal core broke it and to be honest - I don't know how to fix it cleanly so I'm not going to bother at the moment.

Pobster

If you only have one table then you could alter the sorting function yourself, it's hardcoded to take the field ID and the one following it - it should be pretty evident how to change it;

/**
* Sort function
*/
function tablemanager_sort(&$data, $field, $sort = "asc") {
  // reduce $field by one as it currently holds human friendly numbering - first column should be 0 not 1
  $next = $field;
  $field--;
  $code = array_key_exists($next, $data) ? "if (0 == (\$cmp = strnatcasecmp(strip_tags_c(\$a['data']['$field']['data']), strip_tags_c(\$b['data']['$field']['data'])))) return strnatcasecmp(strip_tags_c(\$a['data']['$next']['data']), strip_tags_c(\$b['data']['$next']['data'])); else return \$cmp;" : "return strnatcasecmp(strip_tags_c(\$a['data']['$field']['data']), strip_tags_c(\$b['data']['$field']['data']));";
  if ($sort == "asc"){
    uasort($data, create_function('$a,$b', $code));
  }
  else {
    uasort($data, create_function('$b,$a', $code));
  }
  return;
} // tablemanager_sort

To be honest with you, although it *may* be quite nice to specify which order they sort in - left to right through columns is the way 99% of people will require... I can't think of a 'clean' way to accomplish it either? I doubt I'll consider changing it I'm afraid...

And erm... Do you mean the *active* column? That's white in both IE and Firefox, in fact that's how it works throughout the whole of Drupal to show which column is being sorted! It's not a bug - it's a feature! ;o) If you wish to make it transparent then you'll need to alter your css... That's another story...

Pobster

Hmmm... Tablemanager 1.69 onwards uses elements to allow separate table to be sorted separately... Which version are you using? I'm *sure* you always use the latest version - especially as I recall you asking about the selection box bug thingy before? That's odd...

Pobster

Well I could possibly add the permissions to the create table page, but surely the access permissions page is where they all belong! ;o) I'll see what I can do...

Pobster