/**
* delete group membership
*
* @param int $p_id
* @param int $g_id
*
* @return string
*/
function _churchdb_delPersonGroupRelation($p_id, $g_id)
{
global $user;
$gp_id = _churchdb_getGemeindepersonIdFromPersonId($p_id);
$info_rel = getPersonGroupRelation($gp_id, $g_id);
db_insert('cdb_gemeindeperson_gruppe_archive')->fields(array('gemeindeperson_id' => $gp_id, 'gruppe_id' => $g_id, 'status_no' => $info_rel->status_no, 'letzteaenderung' => $info_rel->letzteaenderung, 'aenderunguser' => $info_rel->aenderunguser))->execute();
// add info about archiving
$dt = new DateTime();
db_insert('cdb_gemeindeperson_gruppe_archive')->fields(array('gemeindeperson_id' => $gp_id, 'gruppe_id' => $g_id, 'status_no' => -99, 'letzteaenderung' => $dt->format('Y-m-d H:i:s'), 'aenderunguser' => $user->cmsuserid))->execute();
$info = getGroupInfo($g_id);
if (readConf('churchdb_sendgroupmails', true) && $info->mail_an_leiter_yn == 1) {
informLeaderAboutDeletedGroupMember($g_id, $gp_id);
}
db_query("DELETE FROM {cdb_gemeindeperson_gruppe} WHERE gemeindeperson_id={$gp_id} AND gruppe_id={$g_id}");
cdb_log("Entferne: " . $info->gruppentyp . " " . $info->gruppe . " (P" . $p_id . ":G" . $g_id . " Leiter:" . $info_rel->status_no . ")", 2, $p_id, CDB_LOG_PERSON, 1);
return "ok";
}
public function addPersonTag($params)
{
$dt = new DateTime();
$gp_id = _churchdb_getGemeindepersonIdFromPersonId($params["id"]);
$new_id = db_insert('cdb_gemeindeperson_tag')->fields(array("gemeindeperson_id" => $gp_id, "tag_id" => $params["tag_id"], "letzteaenderung" => $dt->format('Y-m-d H:i:s')))->execute();
$this->logPerson($params);
}
/**
*
* @param array $params
* @return string "ok"
*/
function editCheckinGroupMeetingStats($params)
{
global $user;
$dt = new DateTime();
db_query("UPDATE {cdb_gruppentreffen} SET eintragerfolgt_yn=1 WHERE id=:id", array(":id" => $params["gruppentreffen_id"]));
$gp_id = _churchdb_getGemeindepersonIdFromPersonId($params["p_id"]);
db_query("INSERT INTO {cdb_gruppentreffen_gemeindeperson} (gruppentreffen_id, gemeindeperson_id, treffen_yn, modified_date, modified_pid) \n VALUES (:gruppentreffen_id, :gemeindeperson_id, :treffen_yn, :modified_date, :modified_pid) \n ON DUPLICATE KEY UPDATE treffen_yn=:treffen_yn, modified_date=:modified_date, modified_pid=:modified_pid", array(":gruppentreffen_id" => $params["gruppentreffen_id"], ":gemeindeperson_id" => $gp_id, ":treffen_yn" => $params["treffen_yn"], ":modified_date" => $dt->format('Y-m-d H:i:s'), ":modified_pid" => $user->id));
return "ok";
}
