/**
* Sets up a query for a particular entry type.
* @param QUERY $query
* @param string $type
* @access private
*/
function project_query_set_type($query, $type)
{
$table_names = $query->app->table_names;
switch ($type) {
case 'change':
$query->add_select('chng.*');
$query->add_table($table_names->changes . ' chng', 'chng.entry_id = entry.id');
break;
case 'job':
$query->add_select('job.*');
$query->add_table($table_names->jobs . ' job', 'job.entry_id = entry.id');
break;
default:
$query->add_select('chng.*, job.*');
$query->add_table($table_names->changes . ' chng', 'chng.entry_id = entry.id', 'LEFT');
$query->add_table($table_names->jobs . ' job', 'job.entry_id = entry.id', 'LEFT');
break;
}
$query->order_by_recent();
}
/**
* Sets up a query for a particular entry type.
* @param QUERY $query
* @param string $type
* @access private
*/
function album_query_set_type($query, $type)
{
/** @var ALBUM_APPLICATION_TABLE_NAMES $table_names */
$table_names = $query->app->table_names;
switch ($type) {
case 'picture':
$query->add_select('pic.*');
$query->add_table($table_names->pictures . ' pic', 'pic.entry_id = entry.id');
break;
case 'journal':
$query->add_select('jrnl.*');
$query->add_table($table_names->journals . ' jrnl', 'jrnl.entry_id = entry.id');
break;
default:
$query->add_select('jrnl.*, pic.*');
$query->add_table($table_names->journals . ' jrnl', 'jrnl.entry_id = entry.id', 'LEFT');
$query->add_table($table_names->pictures . ' pic', 'pic.entry_id = entry.id', 'LEFT');
break;
}
$query->order_by_day('ASC');
}
