/[drupal]/contributions/modules/biblio/biblio.pages.inc
ViewVC logotype

Diff of /contributions/modules/biblio/biblio.pages.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.55.2.11 by rjerome, Tue Nov 10 22:09:18 2009 UTC revision 1.55.2.12 by rjerome, Mon Nov 16 02:24:22 2009 UTC
# Line 1  Line 1 
1  <?PHP  <?PHP
2  // $Id: biblio.pages.inc,v 1.55.2.10 2009/11/09 21:22:48 rjerome Exp $  // $Id: biblio.pages.inc,v 1.55.2.11 2009/11/10 22:09:18 rjerome Exp $
3  /**  /**
4   *   *
5   *   Copyright (C) 2006-2008  Ron Jerome   *   Copyright (C) 2006-2008  Ron Jerome
# Line 146  function biblio_build_query($arg_list) { Line 146  function biblio_build_query($arg_list) {
146    switch ($sort_attrib['sort']) {    switch ($sort_attrib['sort']) {
147      case 'type':      case 'type':
148        //$sortby = "ORDER BY bt.name %s, b.biblio_year DESC ";        //$sortby = "ORDER BY bt.name %s, b.biblio_year DESC ";
149          $query->addField('n', 'title');
150        $query->orderBy($type_name, $sort_attrib['order']);        $query->orderBy($type_name, $sort_attrib['order']);
151        $query->orderBy($type_name, $sort_title);        $query->orderBy('n', $sort_title);
152        break;        break;
153      case 'title':      case 'title':
154          $query->addField('n', 'title');
155        $query->orderBy($sort_title, $sort_attrib['order']);        $query->orderBy($sort_title, $sort_attrib['order']);
156    
157        break;        break;
158      case 'author':      case 'author':
159        //$last_name = $query->addField('bcd', 'lastname');        //$last_name = $query->addField('bcd', 'lastname');
160        $query->innerJoin('biblio_contributor', 'bc', 'b.vid = bc.vid');        $query->innerJoin('biblio_contributor', 'bc', 'b.vid = bc.vid');
161        $query->join('biblio_contributor_data', 'bcd', 'bc.cid = bcd.cid');        $query->join('biblio_contributor_data', 'bcd', 'bc.cid = bcd.cid');
162        $query->condition('bc.rank', 0);        $query->condition('bc.rank', 0);
163          $query->addField('bcd', 'lastname');
164        $query->orderBy('bcd.lastname', $sort_attrib['order']);        $query->orderBy('bcd.lastname', $sort_attrib['order']);
165       // $query->condition('bc.auth_category', 1);       // $query->condition('bc.auth_category', 1);
166        break;        break;
# Line 168  function biblio_build_query($arg_list) { Line 172  function biblio_build_query($arg_list) {
172        break;        break;
173      case 'year':      case 'year':
174      default:      default:
175          $query->addField('b', 'biblio_year');
176          $query->addField('b', 'biblio_date');
177        $query->orderBy('biblio_year', $sort_attrib['order']);        $query->orderBy('biblio_year', $sort_attrib['order']);
178        $query->orderBy('biblio_date', $sort_attrib['order']);        $query->orderBy('biblio_date', $sort_attrib['order']);
179    } //end switch    } //end switch
Legend:
Removed from v.1.55.2.11  
changed lines
  Added in v.1.55.2.12
  ViewVC Help
Powered by ViewVC 1.1.3