static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_get_all', Kanban::get_instance()->settings->basename, self::$table_name), $sql);
$records = parent::get_all($sql);
return Kanban_Utils::build_array_with_id_keys($records, 'id');
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters('kanban_estimate_get_all_sql', $sql);
$records = parent::get_all($sql);
return apply_filters('kanban_estimate_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t\t\tORDER BY `position` ASC\n\t\t;";
$sql = apply_filters('kanban_status_get_all_sql', $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
}
return apply_filters('kanban_status_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$tasks_table_name = Kanban_Task::table_name();
$sql = "SELECT `projects`.*,\n\t\t\t\t(\n\t\t\t\t\tSELECT COUNT(`id`)\n\t\t\t\t\tFROM `{$tasks_table_name}` tasks\n\t\t\t\t\tWHERE `tasks`.`project_id` = `projects`.`id`\n\t\t\t\t\tAND `tasks`.`is_active` = 1\n\t\t\t\t)\n\t\t\t\tAS 'task_count'\n\t\t\t\tFROM `{$table_name}` projects\n\t\t\t\tWHERE `projects`.`is_active` = 1\n\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_get_all', Kanban::get_instance()->settings->basename, self::$slug), $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
}
return Kanban_Utils::build_array_with_id_keys($records, 'id');
}
static function get_all_raw()
{
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\tFROM `{$table_name}`\n\t\t;";
$sql = apply_filters(sprintf('%s_sql_%s_get_all', Kanban::get_instance()->settings->basename, self::$table_name), $sql);
$records = parent::get_all($sql);
// unserialize arrays
foreach ($records as $key => $record) {
if (!is_serialized($record->value)) {
continue;
}
$records[$key]->value = unserialize($record->value);
}
return $records;
}
static function get_all_raw()
{
if (empty(self::$options_raw)) {
$table_name = self::table_name();
$sql = "SELECT *\n\t\t\t\t\tFROM `{$table_name}`\n\t\t\t;";
$sql = apply_filters('kanban_option_get_all_raw_sql', $sql);
self::$options_raw = parent::get_all($sql);
self::$options_raw = Kanban_Utils::build_array_with_id_keys(self::$options_raw, 'id');
// unserialize arrays
foreach (self::$options_raw as $key => $record) {
if (!is_serialized($record->value)) {
continue;
}
self::$options_raw[$key]->value = unserialize($record->value);
}
}
return apply_filters('kanban_option_get_all_raw_return', self::$options_raw);
}
static function on_activation()
{
// check for db updates and migration
Kanban_Db::check_for_updates();
// populate defaults
if (Kanban::get_instance()->settings->records_to_move == 0) {
add_action('init', Kanban_Db::add_defaults());
}
// redirect to welcome page
// @link http://premium.wpmudev.org/blog/tabbed-interface/
set_transient(sprintf('_%s_welcome_screen_activation_redirect', Kanban::get_instance()->settings->basename), true, 30);
}
static function get_all($sql = NULL)
{
$table_name = self::table_name();
$worked_table_name = Kanban_Task_Hour::table_name();
$sql = "SELECT tasks.*,\n\t\t\t\tCOALESCE(SUM(worked.hours), 0) 'hour_count'\n\t\t\t\tFROM {$table_name} tasks\n\t\t\t\tLEFT JOIN {$worked_table_name} worked\n\t\t\t\tON tasks.id = worked.task_id\n\t\t\t\tWHERE tasks.is_active = 1\n\t\t\t\tGROUP BY tasks.id\n\t\t;";
$sql = apply_filters('kanban_task_get_all_sql', $sql);
$records = parent::get_all($sql);
foreach ($records as $key => $record) {
$records[$key]->title = Kanban_Utils::str_for_frontend($records[$key]->title);
$records[$key]->description = Kanban_Utils::str_for_frontend($records[$key]->description);
}
return apply_filters('kanban_task_get_all_return', Kanban_Utils::build_array_with_id_keys($records, 'id'));
}
/**
* get the instance of this class
* @return object the instance
*/
public static function get_instance()
{
if (!self::$instance) {
self::$instance = new self();
}
return self::$instance;
}
