public static function find($filter = null)
{
$CI = get_instance();
$finder_manager = init_finder_manager(__CLASS__, __METHOD__, $filter);
$CI->db->select('id AS campaign:id, name AS campaign:name, created_at AS campaign:created_at')->from('campaign');
$finder_manager->complete_query();
$query = $CI->db->get();
$retour = array();
foreach ($query->result() as $row) {
cast_row($row);
$retour[] = self::make($row->{'campaign:id'}, $row->{'campaign:name'}, $row->{'campaign:created_at'});
}
return $finder_manager->format_return($retour);
}
public static function find($filter = null)
{
$CI = get_instance();
$finder_manager = init_finder_manager(__CLASS__, __METHOD__, $filter);
$CI->db->select('id AS version:id, database_version AS version:database_version, app_version_code AS version:app_version_code, app_version_name AS version:app_version_name, created_at AS version:created_at')->from('version');
$finder_manager->complete_query();
$query = $CI->db->get();
$retour = array();
foreach ($query->result() as $row) {
cast_row($row);
$version = self::make($row->{'version:id'}, $row->{'version:database_version'}, $row->{'version:app_version_code'}, $row->{'version:app_version_name'}, $row->{'version:created_at'});
$retour[] = $version;
}
return $finder_manager->format_return($retour);
}
public static function find_with_version_when_created($filter = null)
{
$CI = get_instance();
$CI->load->model('Version');
$finder_manager = init_finder_manager(__CLASS__, __METHOD__, $filter);
$current_version = Version::retrieve_current_version();
$CI->db->select('deck.id AS deck:id,' . 'deck.num AS deck:num,' . 'deck.name AS deck:name,' . 'version.id AS version:id,' . 'version.database_version AS version:database_version,' . 'version.app_version_code AS version:app_version_code,' . 'version.app_version_name AS version:app_version_name,' . 'version.created_at AS version:created_at')->from('deck')->join('version', 'version.id = deck.id_version_when_created');
$finder_manager->complete_query();
$query = $CI->db->get();
$retour = array();
foreach ($query->result() as $row) {
cast_row($row);
if ($row->{'version:id'} == $current_version->get_id()) {
$version_when_created = $current_version;
} else {
$version_when_created = Version::make($row->{'version:id'}, $row->{'version:database_version'}, $row->{'version:app_version_code'}, $row->{'version:app_version_name'}, $row->{'version:created_at'});
}
$deck = self::make($row->{'deck:id'}, $row->{'deck:num'}, $row->{'deck:name'});
$deck->set_version_when_created($version_when_created);
$retour[] = $deck;
}
return $finder_manager->format_return($retour);
}
public static function find($filter = null)
{
$CI = get_instance();
$finder_manager = init_finder_manager(__CLASS__, __METHOD__, $filter);
$CI->db->select('id AS card_content:id,' . 'word_english AS card_content:word_english,' . 'word_french AS card_content:word_french,' . 'is_active_english AS card_content:is_active_english,' . 'is_active_french AS card_content:is_active_french,' . 'is_last AS card_content:is_last')->from('card_content');
$finder_manager->complete_query();
$query = $CI->db->get();
$retour = array();
foreach ($query->result() as $row) {
cast_row($row);
$retour[] = self::make($row->{'card_content:id'}, $row->{'card_content:word_english'}, $row->{'card_content:word_french'}, $row->{'card_content:is_active_english'}, $row->{'card_content:is_active_french'}, $row->{'card_content:is_last'});
}
return $finder_manager->format_return($retour);
}
public static function find($filter = null)
{
$CI = get_instance();
$CI->load->model('Card_content');
$finder_manager = init_finder_manager(__CLASS__, __METHOD__, $filter);
$CI->db->select('card.id AS card:id,' . 'card.num AS card:num,' . 'card.is_deleted AS card:is_deleted,' . 'card_content.id AS card_content:id,' . 'card_content.word_english AS card_content:word_english,' . 'card_content.word_french AS card_content:word_french,' . 'card_content.is_active_english AS card_content:is_active_english,' . 'card_content.is_active_french AS card_content:is_active_french')->from('card')->join('card_content', 'card_content.id_card = card.id')->where('card_content.is_last', true);
$finder_manager->complete_query();
$query = $CI->db->get();
$retour = array();
foreach ($query->result() as $row) {
cast_row($row);
$card_content = Card_content::make($row->{'card_content:id'}, $row->{'card_content:word_english'}, $row->{'card_content:word_french'}, $row->{'card_content:is_active_english'}, $row->{'card_content:is_active_french'}, true);
$retour[] = self::make($row->{'card:id'}, $row->{'card:num'}, $card_content, $row->{'card:is_deleted'});
}
return $finder_manager->format_return($retour);
}
