FreenetIS

$end_membership = ORM::factory('membership_interrupt')

->has_member_end_after_interrupt_end_in_date($member->id, date('Y-m-d'));

$flags = array();

if ($active_interrupt)

{

$flags[] = __('I');

}

if ($end_membership)

{

$flags[] = __('E');

}

$title = ($flags) ? $type . ' '.$member->name

. ' ('. implode(' + ', $flags) .')' : $type . ' '.$member->name;

$membership_interrupts_grid->callback_field('end_after_interrupt_end')

->callback('callback::boolean')

->class('center')

->label('End membership after end');

if ($this->acl_check_edit(get_class($this), 'members') &&

!$end_membership)

if ($member->type == Member_Model::TYPE_FORMER ||

!$this->acl_check_edit(get_class($this), 'members', $member->id))

$end_membership = ORM::factory('membership_interrupt')

->has_member_end_after_interrupt_end_in_date($member->id, date('Y-m-d'));

if ($end_membership)

{

status::warning('Cannot end membership when interrupt with end membership is activated.');

$this->redirect('members/show/', $member->id);

}

if ($member->type != Member_Model::TYPE_FORMER ||

!$this->acl_check_edit(get_class($this), 'members', $member_id))

if ($member->type != Member_Model::TYPE_FORMER)

{

$this->form->checkbox('end_after_interrupt_end')

->label('End membership after end of interrupt')

->callback(array($this, 'valid_end_after_interrupt_end'));

}

$members_fee->member_id = $member->id;

$membership_interrupt->member_id = $member->id;

if (isset($form_data['end_after_interrupt_end']) &&

$form_data['end_after_interrupt_end'] == '1' &&

$member->type != Member_Model::TYPE_FORMER)

{

$membership_interrupt->end_after_interrupt_end = 1;

// leaving date is validated by validator

$member->leaving_date = $to;

$member->save_throwable();

}

else

{

$membership_interrupt->end_after_interrupt_end = 0;

}

$member = new Member_Model($membership_interrupt->member_id);

if ($member->type != Member_Model::TYPE_FORMER)

{

$this->form->checkbox('end_after_interrupt_end')

->label('End membership after end of interrupt')

->callback(array($this, 'valid_end_after_interrupt_end'))

->checked($membership_interrupt->end_after_interrupt_end);

}

if (isset($form_data['end_after_interrupt_end']) &&

$form_data['end_after_interrupt_end'] == '1')

{

$membership_interrupt->end_after_interrupt_end = 1;

if ($member->leaving_date < date('Y-m-d'))

{

// leaving date is validated by validator

$member->leaving_date = $to;

$member->save_throwable();

}

}

else if (isset($form_data['end_after_interrupt_end']) &&

$form_data['end_after_interrupt_end'] == '0')

{

$membership_interrupt->end_after_interrupt_end = 0;

if ($member->leaving_date < date('Y-m-d'))

{

$member->leaving_date = NULL;

$member->save_throwable();

}

}

else

{

$membership_interrupt->end_after_interrupt_end = 0;

}

$members_fee->member_id = $membership_interrupt->member_id;

if ($membership_interrupt->end_after_interrupt_end &&

$member->leaving_date < date('Y-m-d'))

{

$member->leaving_date = NULL;

$member->save_throwable();

}

/**

* Callback function to valid date to field when checkbox is checked

*

* @author David Raška

* @param object $input

*/

public function valid_end_after_interrupt_end($input = NULL)

{

// validators cannot be accessed

if (empty($input) || !is_object($input))

{

self::error(PAGE);

}

$method = $this->form->from->method;

$to_array = date_parse($this->input->$method('to'));

$checked = $this->input->$method('end_after_interrupt_end');

$to = mktime(0, 0, 0, $to_array['month'], $to_array['day'], $to_array['year']);

if ($checked == '1' &&

$to <= mktime(23, 59, 59))

{

$this->form->to->add_error('required', __('Date to must be in future if End membership is selected'));

}

}

// former members message activation (each day after midnight)

$this->update_and_redirect_former_members();

'cannot end membership to association' => 'Sdružení nelze ukončit členství.',

'cannot end membership when interrupt with end membership is activated' => 'Nelze ukončit členství, pokud je aktivní přerušení členství s ukončením členství.',

'date to must be in future if end membership is selected' => 'Datum do musí být v budoucnosti, pokud je vybráno ukončení členství',

'e' => 'U',

'end membership after end' => 'Ukončit členství po skončení',

'end membership after end of interrupt' => 'Ukončit členství po skončení přerušení',

UPDATE members SET type = ? , locked = 1

/**

* Checks if member has membership interrupt with membership end in given date

*

* @author David Raška

* @param integer $member_id

* @param string $date

* @return bool

*/

public function has_member_end_after_interrupt_end_in_date($member_id, $date)

{

return (bool) $this->db->query("

SELECT COUNT(*) AS count

FROM membership_interrupts mi

JOIN members_fees mf ON mi.members_fee_id = mf.id

WHERE mi.member_id = ? AND

? BETWEEN mf.activation_date AND mf.deactivation_date AND

mi.end_after_interrupt_end = 1

", array($member_id, $date))->current()->count;

}

mf.deactivation_date AS 'to', mi.comment,

mi.end_after_interrupt_end

<?php defined('SYSPATH') or die('No direct script access.');

/*

* This file is part of open source system FreenetIS

* and it is released under GPLv3 licence.

*

* More info about licence can be found:

* http://www.gnu.org/licenses/gpl-3.0.html

*

* More info about project can be found:

* http://www.freenetis.org/

*

*/

/**

* This upgrade is not equal to any of previous upgrades

*

* @author David Raška

*/

$upgrade_equal_to['1.1.0~alpha52'] = array();

/**

* Adds end_after_interrupt_end column to membership_interrupt and

* removes unused bank_templates table

*

* @author David Raška

*/

$upgrade_sql['1.1.0~alpha52'] = array

(

"ALTER TABLE `membership_interrupts` ADD `end_after_interrupt_end` SMALLINT NOT NULL;",

"DROP TABLE `bank_templates`;"

);

define('FREENETIS_VERSION', '1.1.0~alpha52');