Sortable Table - Issues with Table Header

No worries! ;o) Afraid it'll only integrate auto-sorting when the results are gained from a db table (as Drupal uses mysqls sort function) but as you're loading the arrays yourself - you're responsible I'm afraid!

I thought perhaps the sort routine I posted above was a little too specific for Tablemanagers requirements, so here's a skimmed down version;

function tablemanager_sort(&$data, $field, $sort = "asc") {
$code = "return strnatcmp(\$a['data']['$field'], \$b['data']['$field']);";
  if ($sort == "asc"){
    uasort($data, create_function('$a,$b', $code));
  }
  else {
    uasort($data, create_function('$b,$a', $code));
  }
return;
} // tablemanager_sort

It's from a very early version of Tablemanager (before it got complicated!) and sorts arrays while they're held in theme_table type arrays. Hope this helps!

Pobster
edit: You can swap strnatcmp with strnatcasecmp if it suits better btw.

I pulled a beginning php error. I now see the $table variable is passed by reference. No wonder the above code isn't working. Sorry!!!!

Should be..

tablemanager_sort($table, 1);
return theme_table($tableHeader, $table);

So, I have actually sorted the first field ascending, However, the arrow keys on the header do not reverse the sort, and I am still working to try and figure out how to apply this to more than one field. If you happen to come along in the next year, I will likely still be messing with it. Again, thanks for taking the time.

I am attaching the portion of the module that you probably need. I did not include the functions called as they don't seem like they are needed.

**
* Sort function
*/
function tablemanager_sort(&$data, $field, $sort = "asc") {
$code = "return strnatcasecmp(\$a['data']['$field'], \$b['data']['$field']);";
  if ($sort == "asc"){
    uasort($data, create_function('$a,$b', $code));
  }
  else {
    uasort($data, create_function('$b,$a', $code));
  }
return;
} // tablemanager_sort



/**
* Returns the page at url /myrounds.
* This function retrieves all published encounters and places their needed data into an array.
*/
function myrounds_list(){
        $table = array();
        $result = db_query(db_rewrite_sql('SELECT n.nid FROM {node} n
        WHERE n.status = 1 AND n.type = "encounter"'));
        while ($node = db_fetch_object($result))
        {
                $encounter = node_load($node->nid);
                if (user_is_provider($encounter))
                {
                        //Get the current room Number.
                        $room_nid = $encounter->field_hospitalization_location[0]['nid'];
                        $room = node_load($room_nid);
                        $room_num = check_plain($room->title);

                        //Get the nursing team.
                        $nurse_team_nid = $encounter->field_encounter_nursing_team[0]['nid'];
                        $nursing = node_load($nurse_team_nid);
                        $nurse_team = check_plain($nursing->title);

                        //Get the demographic then load the node.
                        $demographic_nid = $encounter->field_hospitalized_patient[0]['nid'];
                        $demographic = node_load($demographic_nid);

                        //Get the patients first and last name with link from the encounter.
                        $lastname = check_plain($demographic->field_patient_last_name[0]['value']);
                        $lastname_lnk = l($lastname,'node/'.$encounter->nid);
                        $firstname = check_plain($demographic->field_patient_first_name[0]['value']);

                        //Get the workflow of the encounter.
                        $wid = workflow_get_workflow_for_type($encounter->type);
                        $states = workflow_get_states($wid) + array(t('(creation)'));
                        $current = workflow_node_current_state($node);
                        $wf = check_plain($states[$current]);

                        //Get the collab time slot.
                        $time_array = collab_time_slot($demographic_nid);
                        $time_lnk = l($time_array['title'], 'node/'.$time_array['nid']);

                        //Build the table array.
                        $table[] = array( 
                        array('data' => $room_num),
                        array('data' => $lastname_lnk),
                        array('data' => $firstname),
                        array('data' => $nurse_team),
                        array('data' => $wf),
                        array('data' => $time_lnk)
                        );





                }
        }

        // Create the header for the table
        $tableHeader = array(
        array('data'=>"Room", 'field' => '0'),
        array('data'=>"Last Name", 'field' => '1'),
        array('data'=>"First Name", 'field' => '2'),
        array('data'=>"Nursing", 'field' => '3'),
        array('data'=>"Workflow", 'field'=> '4'),
        array('data'=>"Time", 'field' => '5')
        );

        $sort = tablesort_get_sort($tableHeader);
        $order = tablesort_get_order($tableHeader);
        tablemanager_sort($table, $order['sql'], $sort);

        return theme('table',$tableHeader, $table);

}

I changed the field numbers to start with 0, but still no go. :(