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 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')); }