public function get_teams($team_id, $joint_id = 0)
{
// if it's a joint, let's deal it as a joing
if ($joint_id > 0) {
// get all the joint entries so we have all the teams
$joint = new Joint();
$joint->where("joint_id", $joint_id)->get();
// not an existing joint?
if ($joint->result_count() < 1) {
log_message('error', 'get_teams: joint -> joint not found');
return false;
}
// result array
$teamarray = array();
foreach ($joint->all as $key => $join) {
if (!($team = $this->get_cached($join->team_id))) {
$team = new Team();
$team->where('id', $join->team_id);
$team->get();
}
$teamarray[] = $team->get_clone();
}
if (empty($teamarray)) {
log_message('error', 'get_teams: joint -> no teams found');
return false;
}
return $teamarray;
}
// if we're here, it means it's a simple team
if (!($team = $this->get_cached($team_id))) {
$team = new Team($team_id);
}
return array($team);
}
public function remove_team_from_all($team_id)
{
$joints = new Joint();
$joints->where('team_id', $team_id)->get();
if (!$joints->delete_all()) {
set_notice('error', _('Couldn\'t remove the team from all the joints.'));
log_message('error', 'remove_team_from_all (joint.php): removing failed');
return false;
}
}
/**
* Returns chapters per page by joint ID
* Also returns the teams
*
* This is not a method light enough to lookup teams. use api/members/joint for that
*
* Available filters: id (required), page, per_page (default:30, max:100), orderby
*
* @author Woxxy
*/
function joint_get()
{
// check that the id is at least a valid number
$this->_check_id();
// grab by joint_id, id for joints means nothing much
$joint = new Joint();
$joint->where('joint_id', $this->get('id'))->limit(1)->get();
if ($joint->result_count() == 1) {
// good old get_teams() will give us all Team objects in an array
$team = new Team();
$teams = $team->get_teams(0, $this->get('id'));
// $teams is a normal array, so we have to do a loop
$result = array();
foreach ($teams as $item) {
$result['teams'][] = $item->to_array();
}
// grab all the chapters from the same joint
$chapters = new Chapter();
$chapters->where('joint_id', $joint->joint_id);
// apply the limit and orderby filters
$this->_orderby($chapters);
$this->_page_to_offset($chapters);
$chapters->get();
$chapters->get_comic();
// let's put the chapters in a nice [comic][chapter][teams] list
$result['chapters'] = array();
foreach ($chapters->all as $key => $chapter) {
$result['chapters'][$key]['comic'] = $chapter->comic->to_array();
$result['chapters'][$key]['chapter'] = $chapter->to_array();
$result['chapters'][$key]['teams'] = $result['teams'];
}
// all good
$this->response($result, 200);
// 200 being the HTTP response code
} else {
// nothing for this joint or page
$this->response(array('error' => _('Team could not be found')), 404);
}
}
function joint_get() {
if (!$this->get('id') || !is_numeric($this->get('id'))) {
$this->response(NULL, 400);
}
if (!$this->get('page') || !is_numeric($this->get('page')) || $this->get('page') < 1)
$page = 1;
else
$page = (int) $this->get('page');
$page = ($page * 100) - 100;
$joint = new Joint();
$joint->where('joint_id', $this->get('id'))->limit(1)->get();
if ($joint->result_count() == 1) {
$team = new Team();
$teams = $team->get_teams(0, $this->get('id'));
$result = array();
foreach ($teams as $item) {
$result['teams'][] = $item->to_array();
}
$chapters = new Chapter();
$chapters->where('joint_id', $joint->joint_id);
$chapters->limit(100, $page)->get();
$chapters->get_comic();
$result['chapters'] = array();
foreach ($chapters->all as $key => $chapter) {
$result['chapters'][$key]['comic'] = $chapter->comic->to_array();
$result['chapters'][$key]['chapter'] = $chapter->to_array();
$result['chapters'][$key]['teams'] = $result['teams'];
}
$this->response($result, 200); // 200 being the HTTP response code
} else {
$this->response(array('error' => _('Team could not be found')), 404);
}
}
public function get_teams($team_id, $joint_id = 0) {
if ($joint_id > 0) {
$joint = new Joint();
$joint->where("joint_id", $joint_id)->get();
if ($joint->result_count() < 1) {
log_message('error', 'get_teams: joint -> joint not found');
return false;
}
$teamarray = array();
$team = new Team();
foreach ($joint->all as $key => $join) {
$team->where('id', $join->team_id);
$team->get();
$teamarray[] = $team->get_clone();
}
if ($team->result_count() < 1) {
log_message('error', 'get_teams: joint -> no teams found');
return false;
}
return $teamarray;
}
$team = new Team($team_id);
return array($team);
}