/**
* Method to remove venues
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($pks = array())
{
$result = false;
if (count($pks)) {
//JArrayHelper::toInteger($cid);
$cids = implode(',', $pks);
/*
$query="SELECT id FROM #__joomleague_club WHERE standard_playground IN ($cids)";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult())
{
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_VENUE_MODEL_ERROR_CLUB_EXISTS'));
return false;
}
*/
$query = "SELECT id FROM #__joomleague_project_team WHERE standard_playground IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_VENUE_MODEL_ERROR_P_TEAM_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_match WHERE playground_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_VENUE_MODEL_ERROR_MATCH_EXISTS'));
return false;
}
return parent::delete($pks);
}
return true;
}
/**
* Method to remove an event
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($cid = array())
{
$result = false;
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
// first check that it not used in any match events
$query = ' SELECT ms.id ' . ' FROM #__joomleague_match_statistic AS ms ' . ' WHERE ms.statistic_id IN (' . implode(',', $cid) . ')';
$this->_db->setQuery($query);
$this->_db->query();
if ($this->_db->getAffectedRows()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_STATISTIC_MODEL_CANT_DELETE_STATS_MATCHES'));
return false;
}
// then check that it is not assigned to positions
$query = ' SELECT id ' . ' FROM #__joomleague_position_statistic ' . ' WHERE statistic_id IN (' . implode(',', $cid) . ')';
$this->_db->setQuery($query);
$this->_db->query();
if ($this->_db->getAffectedRows()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_STATISTIC_MODEL_CANT_DELETE_STATS_MATCHES'));
return false;
}
return parent::delete($cids);
}
return true;
}
/**
* Method to remove a club
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($pks = array())
{
$mainframe =& JFactory::getApplication();
$result = false;
if (count($pks)) {
//JArrayHelper::toInteger($cid);
$cids = implode(',', $pks);
$mainframe->enqueueMessage(JText::_('JoomleagueModelClub-delete id->' . $cids), 'Notice');
$query = "SELECT id FROM #__joomleague_team WHERE club_id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_CLUB_MODEL_ERROR_TEAM_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_playground WHERE club_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_CLUB_MODEL_ERROR_VENUE_EXISTS'));
return false;
}
return parent::delete($pks);
}
return true;
}
/**
* Method to load content template data
*
* @access private
* @return boolean True on success
*/
function _loadData()
{
// Lets load the content if it doesn't already exist
if (empty($this->_data)) {
$this->_data = parent::getItem($this->_id);
return (bool) $this->_data;
}
return true;
}
function getState($property = null)
{
static $set;
if (!$set) {
$folder = JRequest::getVar('folder');
$this->setState('folder', $folder);
$set = true;
}
return parent::getState($property);
}
/**
* Method to remove a league
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($cid = array())
{
$result = false;
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
$query = "SELECT id FROM #__joomleague_countries WHERE league_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_LEAGUE_MODEL_ERROR_PROJECT_EXISTS'));
return false;
}
return parent::delete($cids);
}
return true;
}
/**
* Method to remove a league
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($pks = array())
{
$mainframe =& JFactory::getApplication();
$result = false;
if (count($pks)) {
//JArrayHelper::toInteger($cid);
$cids = implode(',', $pks);
$mainframe->enqueueMessage(JText::_('JoomleagueModelLeague-delete id->' . $cids), 'Notice');
$query = "SELECT id FROM #__joomleague_project WHERE league_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_LEAGUE_MODEL_ERROR_PROJECT_EXISTS'));
return false;
}
return parent::delete($pks);
}
return true;
}
/**
* Method to remove a division
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($cid = array())
{
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
$query = "UPDATE #__joomleague_project_team SET division_id=0 WHERE division_id IN ({$cids})";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$query = "UPDATE #__joomleague_treeto SET division_id=0 WHERE division_id IN ({$cids})";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
return parent::delete($cids);
}
return true;
}
/**
* Method to remove a matchday
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function deleteMatches($cid = array(), $mdlMatches, $mdlMatch, $onlyMatches = false)
{
$result = false;
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
for ($r = 0; $r < count($cid); $r++) {
//echo "Deleting Round: ".$cid[$r]."<br>";
$matches = $mdlMatches->getMatchesByRound($cid[$r]);
$matchids = array();
for ($m = 0; $m < count($matches); $m++) {
$matchids[] = $matches[$m]->id;
//echo " Deleting Match: ".$matches[$m]->id."<br>";
}
$mdlMatch->delete($matchids);
}
if (!$onlyMatches) {
return parent::delete($cids);
}
}
return true;
}
/**
* Method to remove a sportstype
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($pks = array())
{
$mainframe =& JFactory::getApplication();
$result = false;
if (count($pks)) {
//JArrayHelper::toInteger($pks);
$cids = implode(',', $pks);
$mainframe->enqueueMessage(JText::_('JoomleagueModelSportsType-delete id->' . $cids), 'Notice');
$query = "SELECT COUNT(id) FROM #__joomleague_sports_type";
$this->_db->setQuery($query);
if ($this->_db->loadResult() == count($cid)) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_SPORTTYPE_MODEL_ERROR_LAST_SPORTSTYPE'));
return false;
}
$query = "SELECT id FROM #__joomleague_eventtype WHERE sports_type_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_SPORTTYPE_MODEL_ERROR_EVENT_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_position WHERE sports_type_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_SPORTTYPE_MODEL_ERROR_POSITION_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_project WHERE sports_type_id IN ({$cids})";
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_SPORTTYPE_MODEL_ERROR_PROJECT_EXISTS'));
return false;
}
return parent::delete($pks);
}
return true;
}
function delete(&$pks = array())
{
if (count($pks)) {
$cids = implode(',', $pks);
$query = ' DELETE tt, ttn, ttm ';
$query .= ' FROM #__joomleague_treeto AS tt ';
$query .= ' LEFT JOIN #__joomleague_treeto_node AS ttn ON ttn.treeto_id=tt.id ';
$query .= ' LEFT JOIN #__joomleague_treeto_match AS ttm ON ttm.node_id=ttn.id ';
$query .= ' WHERE tt.id IN (' . $cids . ')';
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
return parent::delete($pks);
}
return true;
}
/**
* Save match details from modal window
*
* @param array $data
* @return boolean
*/
function savedetails($data)
{
if (!$data['id']) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_MATCH_ID_IS_NULL'));
return false;
}
if ($data["new_match_id"] > 0) {
$table = $this->getTable();
if (!$table->load($data['new_match_id'])) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_OLD_GAME_NOT_FOUND'));
return false;
}
$newdata = array();
$newdata["old_match_id"] = $data["id"];
// Bind the form fields to the table row
if (!$table->bind($newdata)) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_BINDING_FAILED'));
return false;
}
if (!$table->check()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_CHECK_FAILED'));
return false;
}
if (!$table->store(true)) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_STORE_FAILED'));
return false;
}
}
if ($data["old_match_id"] > 0) {
$table = $this->getTable();
if (!$table->load($data['old_match_id'])) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_OLD_GAME_NOT_FOUND'));
return false;
}
$newdata = array();
$newdata["new_match_id"] = $data["id"];
// Bind the form fields to the table row
if (!$table->bind($newdata)) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_BINDING_FAILED'));
return false;
}
if (!$table->check()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_CHECK_FAILED'));
return false;
}
if (!$table->store(true)) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_MATCH_MODEL_STORE_FAILED'));
return false;
}
}
return parent::save($data);
}
/**
* Method to remove an event
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($cid = array())
{
$result = false;
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
// first check that they are not used in any match events
$query = ' SELECT event_type_id
FROM #__joomleague_match_event
WHERE event_type_id IN (' . implode(',', $cid) . ')';
$this->_db->setQuery($query);
$this->_db->query();
if ($this->_db->getAffectedRows()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_EVENT_MODEL_ERROR_MATCHES_EXISTS'));
return false;
}
// then check that they are not assigned to any positions
$query = ' SELECT eventtype_id
FROM #__joomleague_position_eventtype
WHERE eventtype_id IN (' . implode(',', $cid) . ')';
$this->_db->setQuery($query);
$this->_db->query();
if ($this->_db->getAffectedRows()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_EVENT_MODEL_ERROR_POSITION_EXISTS'));
return false;
}
return parent::delete($cids);
}
return true;
}
/**
* Method to remove a person
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($pks = array())
{
$mainframe =& JFactory::getApplication();
$result = false;
if (count($pks)) {
//JArrayHelper::toInteger($cid);
$cids = implode(',', $pks);
//First select all subpersons of the selected ids
$mainframe->enqueueMessage(JText::_('JoomleagueModelPerson-delete id->' . $cids), 'Notice');
$query = "SELECT * FROM #__joomleague_person WHERE id IN ({$cids})";
$this->_db->setQuery($query);
if ($results = $this->_db->loadObjectList()) {
foreach ($results as $result) {
//Now delete all match-persons assigned as player to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_event\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")\n\t\t\t\t\t\t\t\t\tOR teamplayer_id2 in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as referee to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_referee\n\t\t\t\t\t\t\t\tWHERE project_referee_id in (select id from #__joomleague_project_referee where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as player1 to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_player\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as player2 to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_staff\n\t\t\t\t\t\t\t\tWHERE team_staff_id in (select id from #__joomleague_team_staff where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$query = "DELETE FROM #__joomleague_match_statistic\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$query = "DELETE FROM #__joomleague_match_staff_statistic\n\t\t\t\t\t\t\t\tWHERE team_staff_id in (select id from #__joomleague_team_staff where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as referee in a project of the selected ids
$query = "DELETE FROM #__joomleague_project_referee\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as player in a team of the selected ids
$query = "DELETE FROM #__joomleague_team_player\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as staff in a team of the selected ids
$query = "DELETE FROM #__joomleague_team_staff\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->query()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
}
return parent::delete($pks);
}
return true;
}
/**
* Method to remove a person
*
* @access public
* @return boolean True on success
*/
function delete(&$pks = array())
{
if (count($pks)) {
$cids = implode(',', $pks);
//First select all subpersons of the selected ids
$query = "SELECT * FROM #__joomleague_person WHERE id IN ({$cids})";
$this->_db->setQuery($query);
if ($results = $this->_db->loadObjectList()) {
foreach ($results as $result) {
//Now delete all match-persons assigned as player to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_event\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")\n\t\t\t\t\t\t\t\t\tOR teamplayer_id2 in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as referee to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_referee\n\t\t\t\t\t\t\t\tWHERE project_referee_id in (select id from #__joomleague_project_referee where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as player1 to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_player\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all match-events assigned as player2 to subpersons of the selected ids
$query = "DELETE FROM #__joomleague_match_staff\n\t\t\t\t\t\t\t\tWHERE team_staff_id in (select id from #__joomleague_team_staff where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$query = "DELETE FROM #__joomleague_match_statistic\n\t\t\t\t\t\t\t\tWHERE teamplayer_id in (select id from #__joomleague_team_player where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
$query = "DELETE FROM #__joomleague_match_staff_statistic\n\t\t\t\t\t\t\t\tWHERE team_staff_id in (select id from #__joomleague_team_staff where person_id = " . $result->id . ")";
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as referee in a project of the selected ids
$query = "DELETE FROM #__joomleague_project_referee\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as player in a team of the selected ids
$query = "DELETE FROM #__joomleague_team_player\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
//Now delete all person assigned as staff in a team of the selected ids
$query = "DELETE FROM #__joomleague_team_staff\n\t\t\t\t\t\t\t\tWHERE person_id=" . $result->id;
$this->_db->setQuery($query);
if (!$this->_db->execute()) {
$this->setError($this->_db->getErrorMsg());
return false;
}
}
}
return parent::delete($pks);
}
return true;
}
/**
* Method to remove a position
*
* @access public
* @return boolean True on success
* @since 0.1
*/
function delete($cid = array())
{
$result = false;
if (count($cid)) {
JArrayHelper::toInteger($cid);
$cids = implode(',', $cid);
$query = "SELECT pos.id FROM #__joomleague_project_position AS ppos\n INNER JOIN #__joomleague_position AS pos ON pos.id = ppos.position_id\n WHERE pos.id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_POSITION_MODEL_ERROR_P_POSITION_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_project_referee AS pref \n INNER JOIN #__joomleague_project_position AS ppos ON ppos.id = pref.project_position_id\n INNER JOIN #__joomleague_position AS pos ON pos.id = ppos.position_id\n WHERE pos.id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_POSITION_MODEL_ERROR_P_REFEREE_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_team_player AS tp\n INNER JOIN #__joomleague_project_position AS ppos ON ppos.id = tp.project_position_id\n INNER JOIN #__joomleague_position AS pos ON pos.id = ppos.position_id\n WHERE pos.id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_POSITION_MODEL_ERROR_PLAYER_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_team_staff AS ts\n INNER JOIN #__joomleague_project_position AS ppos ON ppos.id = ts.project_position_id\n INNER JOIN #__joomleague_position AS pos ON pos.id = ppos.position_id\n WHERE pos.position_id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_POSITION_MODEL_ERROR_STAFF_EXISTS'));
return false;
}
$query = "SELECT id FROM #__joomleague_person \n WHERE position_id IN ({$cids})";
//echo '<pre>'.print_r($query,true).'</pre>';
$this->_db->setQuery($query);
if ($this->_db->loadResult()) {
$this->setError(JText::_('COM_JOOMLEAGUE_ADMIN_POSITION_MODEL_ERROR_PERSON_EXISTS'));
return false;
}
return parent::delete($cids);
}
return true;
}
