/**
* Retrieves the list of carts that are currently owned by/
* assigned to a given user. Can be filtered to hide carts
* that have already expired
*
* @param integer $eus_id The user_id of the cart owner
* @param boolean $show_expired should we show expired entries?
*
* @return array
*
* @author Ken Auberry <*****@*****.**>
*/
public function get_active_carts($eus_id, $show_expired = TRUE)
{
$DB_myemsl = $this->load->database('default', TRUE);
$select_array = array('cart_id', 'submit_time', 'last_mtime as modification_time', 'last_email as last_email_time', 'state', 'size as size_in_bytes', 'items as item_count');
$state_array = array('admin_notified' => 'admin', 'ingest' => 'unsubmitted', 'submitted' => 'building', 'amalgam' => 'building', 'downloading' => 'building', 'email' => 'available', 'download_expiring' => 'expired', 'expiring' => 'expired', 'expired' => 'expired');
$cart_list = array();
$accepted_states = array('amalgam', 'downloading', 'email', 'admin_notified', 'submitted');
$DB_myemsl->select($select_array)->where('person_id', $eus_id)->order_by('last_mtime desc');
$query = $DB_myemsl->where_in('state', $accepted_states)->get(CART_TABLE);
if ($query && $query->num_rows() > 0) {
foreach ($query->result() as $row) {
$display_state = array_key_exists($row->state, $state_array) ? $state_array[$row->state] : 'unknown';
$display_size = format_bytes($row->size_in_bytes);
$cart_id = $row->cart_id;
$submit_time = new DateTime($row->submit_time);
$modified_time = new DateTime($row->modification_time);
$email_time = new DateTime($row->last_email_time);
$cart_list[$display_state][$row->cart_id] = array('cart_id' => $row->cart_id, 'raw_state' => $row->state, 'display_state' => $display_state, 'size_bytes' => $row->size_in_bytes, 'display_size' => $display_size, 'item_count' => 0, 'times' => array('submit' => $row->submit_time, 'modified' => $row->modification_time, 'email' => $row->last_email_time, 'submit_time_obj' => $submit_time, 'modified_time_obj' => $modified_time, 'email_time_obj' => $email_time, 'formatted_submit' => format_cart_display_time_element($submit_time), 'formatted_modified' => format_cart_display_time_element($modified_time), 'formatted_email' => format_cart_display_time_element($email_time), 'generation_time' => friendlyElapsedTime($submit_time, $email_time, FALSE)));
$cart_items_query = $DB_myemsl->select('item_id')->get_where(ITEMS_TABLE, array('cart_id' => $cart_id));
$cart_item_list = array();
$metadata = array('proposal_id' => 'None Specified', 'proposal_description' => 'No Proposal Specified', 'instrument_id' => 'None Specified', 'instrument_description' => 'No Instrument Specified');
if ($cart_items_query && $cart_items_query->num_rows() > 0) {
foreach ($cart_items_query->result() as $ci_row) {
$cart_item_list[] = $ci_row->item_id;
}
}
if (!empty($cart_item_list)) {
$item_count = sizeof($cart_item_list);
$cart_list[$display_state][$row->cart_id]['item_count'] = $item_count;
$item_count_pluralizer = $item_count != 1 ? 's' : '';
$cart_list[$display_state][$row->cart_id]['display_item_count'] = "{$item_count} item{$item_count_pluralizer}";
$inst_matcher = "/Instrument\\.(\\d+)/i";
$md_select_array = array('g.name', 'g.type');
$DB_myemsl->select($md_select_array)->distinct();
$DB_myemsl->from('groups g')->join('group_items gi', 'g.group_id = gi.group_id');
$metadata_query = $DB_myemsl->where_in('gi.item_id', $cart_item_list)->get();
if ($metadata_query && $metadata_query->num_rows() > 0) {
foreach ($metadata_query->result() as $md_row) {
$type = $md_row->type;
$name = $md_row->name;
if (preg_match($inst_matcher, $type, $inst_matches)) {
$metadata['instrument_id'] = $inst_matches[1];
$metadata['instrument_description'] = $name;
} elseif (strtolower($type) == 'proposal') {
$metadata['proposal_id'] = $name;
}
}
}
$DB_myemsl->select(array('max(t.transaction) as tx_id', 'max(t.stime) as upload_time'));
$DB_myemsl->from('transactions t')->join('files f', 'f.transaction = t.transaction');
$DB_myemsl->group_by('t.transaction')->where_in('f.item_id', $cart_item_list);
$tx_query = $DB_myemsl->limit(1)->get();
if ($tx_query && $tx_query->num_rows() > 0) {
$cart_list[$display_state][$row->cart_id]['transaction_id'] = $tx_query->row()->tx_id;
$cart_list[$display_state][$row->cart_id]['times']['upload_time'] = $tx_query->row()->upload_time;
$up_time = new DateTime($tx_query->row()->upload_time);
$cart_list[$display_state][$row->cart_id]['times']['formatted_upload_time'] = $up_time->format('d M Y g:ia');
}
}
$cart_list[$display_state][$row->cart_id]['metadata'] = $metadata;
if ($display_state == 'available') {
$cart_url = CART_URL_BASE . "{$this->user_id}/{$row->cart_id}.amalgam/{$row->cart_id}.tar";
$cart_list[$display_state][$row->cart_id]['download_url'] = $cart_url;
}
}
}
return $cart_list;
}
/**
* Generate an appropriate HTML5 time object containing
* a nicely formatted time string in the display area,
* and an ISO-formatted string in the datetime object
*
* @param datetime $time_obj object to be formatted
*
* @return string
*
* @author Ken Auberry <*****@*****.**>
*/
function format_cart_display_time_element($time_obj)
{
$elapsed_time = friendlyElapsedTime($time_obj);
$formatted_time = $time_obj->format('d M Y g:ia');
$iso_time = $time_obj->getTimestamp();
return "<time title='{$formatted_time}' datetime='{$iso_time}'>{$elapsed_time}</time>";
}
