/** * 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"; }