*   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Bickerdike_id);
$start = $_POST['start'];
$end = $_POST['end'];
$start_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $start);
$end_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $end);
?>
<!--
Gets surveys within the date range specified for all types of surveys.
Returns a table of average responses for each question.
-->
<table class="all_projects">
    <tr>
        <th></th>
        <th colspan="3">Average Responses</th> <!-- would it make sense to do median/mode? -->
    </tr>
    <?php 

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Bickerdike_id, $AdminAccess);
//need to first take care of any possible foreign key constraints:
//activities_users, participant survey responses, program dates users, programs users, user health data
//
//Then finally delete the user him/herself.  This is probably going to be phased out once the merge
//tool is in use.
//
include "../include/dbconnopen.php";
$user_id_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['user_id']);
$delete_activities_query_sqlsafe = "DELETE FROM Activities_Users WHERE User_ID='" . $user_id_sqlsafe . "'";
$delete_surveys_query_sqlsafe = "DELETE FROM Participant_Survey_Responses WHERE User_ID='" . $user_id_sqlsafe . "'";
$delete_attendance_query_sqlsafe = "DELETE FROM Program_Dates_Users WHERE User_ID='" . $user_id_sqlsafe . "'";
$delete_programs_query_sqlsafe = "DELETE FROM Programs_Users WHERE User_ID='" . $user_id_sqlsafe . "'";
$delete_health_query_sqlsafe = "DELETE FROM User_Health_Data WHERE User_ID='" . $user_id_sqlsafe . "'";
$delete_user_query_sqlsafe = "DELETE FROM Users WHERE User_ID='" . $user_id_sqlsafe . "'";
mysqli_query($cnnBickerdike, $delete_activities_query_sqlsafe);

     mysqli_query($cnnEnlace, $delete_participant);
     include "../include/dbconnclose.php";
     //delete participant from future expectations
     $delete_participant = "DELETE FROM Participants_Future_Expectations WHERE Participant_ID='" . $participant_id_sqlsafe . "'";
     echo $delete_participant;
     include "../include/dbconnopen.php";
     mysqli_query($cnnEnlace, $delete_participant);
     include "../include/dbconnclose.php";
     //delete participant from referrals
     $delete_participant = "DELETE FROM Referrals WHERE Participant_ID='" . $participant_id_sqlsafe . "'";
     echo $delete_participant;
     include "../include/dbconnopen.php";
     mysqli_query($cnnEnlace, $delete_participant);
     include "../include/dbconnclose.php";
 } elseif ($_POST['action'] == 'delete_participant_from_program') {
     user_enforce_has_access($Enlace_id, $AdminAccess);
     date_default_timezone_set('America/Chicago');
     include "../include/dbconnopen.php";
     $link_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['link_id']);
     //delete participant from program
     $delete_participant_from_program = "DELETE FROM Participants_Programs WHERE Participant_Program_ID='" . $link_id_sqlsafe . "'";
     echo $delete_participant_from_program;
     mysqli_query($cnnEnlace, $delete_participant_from_program);
     include "../include/dbconnclose.php";
 } elseif ($_POST['action'] == 'drop') {
     date_default_timezone_set('America/Chicago');
     include "../include/dbconnopen.php";
     $link_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['link_id']);
     $drop_from_program = "UPDATE Participants_Programs SET Date_Dropped='" . date('Y-m-d') . "' WHERE Participant_Program_ID='" . $link_id_sqlsafe . "'";
     echo $drop_from_program;
     mysqli_query($cnnEnlace, $drop_from_program);

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($TRP_id);
?>
      <link href="/styles/styles.css" rel="stylesheet" type="text/css" />
        <link href="/include/jquery/1.9.1/css/redmond/jquery-ui-1.8.23.custom.css" rel="stylesheet" type="text/css" />
        <script src="/include/jquery/1.9.1/js/jquery-1.8.2.js" type="text/javascript"></script>
        <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.core.js" type="text/javascript"></script>
        <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.widget.js" type="text/javascript"></script>
        <script src="/include/jquery/1.9.1/development-bundle/ui/jquery.ui.datepicker.js" type="text/javascript"></script>
       
        
        <!-- adds to a calendar to text boxes for consistent date format -->
		<script>
            //on search events
	$(function() {
                $(".hasDatepickers").datepicker({dateFormat: "mm/dd/yy",
                changeYear: true,

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($LSNA_id);
include "../../header.php";
include "../header.php";
include "../include/datepicker.php";
//filter by dates and funder(s) (probably by checkbox?)
// show table of activities in funding period
?>

<h3>Search Events by Funder</h3>
    <table class="all_projects">
<form method = "post"  action="<?php 
echo $_SERVER['PHP_SELF'];
?>
" >
<tr>
<th class="all_projects">Funder:</th><td>

<?php

/*
 *   TTM is a web application to manage data collected by community organizations.
 *   Copyright (C) 2014, 2015  Local Initiatives Support Corporation (lisc.org)
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($LSNA_id, $DataEntryAccess);
/*after a participant already exists, adding them to another institution (or vice versa) */
include "../include/dbconnopen.php";
$inst_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['inst']);
$parti_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['parti']);
$link_query = "INSERT INTO Institutions_Participants (Institution_ID, Participant_ID)\r\n    VALUES('" . $inst_sqlsafe . "', '" . $parti_sqlsafe . "')";
mysqli_query($cnnLSNA, $link_query);
include "../include/dbconnclose.php";

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($SWOP_id, $DataEntryAccess);
include "../../header.php";
include "../header.php";
include "reports_menu.php";
//include ($_SERVER['DOCUMENT_ROOT']."/include/block_group_finder.php");
?>

<!-- export information from the database.  Will change once Taryn gets back to me with the compound exports she needs: -->

<h2>Export All</h2>

<table class="all_projects">
    <tr>
        <td>
            <h4>Export Everything </h4>
            <table class="inner_table">

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($SWOP_id);
//I'm going to follow the same partial search mechanism that I've used before.  If a search term
//is chosen, then I'll use it for searching.  One thing I may have to change is allowing them to search for the
//null - that is, find people who /don't have/ a primary institution or something like that.
if ($_POST['inst'] != 0) {
    $institution_sqlsafe = " AND Institution_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['inst']) . "' AND Is_Primary=1 ";
    $join_inst_sqlsafe = " INNER JOIN Institutions_Participants ON Participants.Participant_ID=Institutions_Participants.Participant_ID ";
} else {
    $institution_sqlsafe = "";
    $join_inst_sqlsafe = "";
}
$join_inst_sqlsafe = " INNER JOIN Institutions_Participants ON Participants.Participant_ID=Institutions_Participants.Participant_ID ";
if ($_POST['type'] != 0) {
    $type_sqlsafe = " AND member_type.Member_Type='" . mysqli_real_escape_string($cnnSWOP, $_POST['type']) . "' ";
    $member_type_join_sqlsafe = " INNER JOIN \r\n        (SELECT Active, Participant_ID, max(Date_Changed) as lastdate FROM Pool_Status_Changes\r\n        GROUP BY Participant_ID) lasttypestatus\r\n        ON member_type.Date_Changed=lasttypestatus.lastdate ";
} else {

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Enlace_id);
/*Add a new program quality survey here: */
include "../../header.php";
include "../header.php";
include "../classes/program.php";
$survey_program = new Program();
$survey_program->load_with_program_id($_GET['prog']);
include "../include/dbconnopen.php";
$prog_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_GET['prog']);
?>
<script type="text/javascript">
	$(document).ready(function() {
		$('#programs_selector').addClass('selected');
			$('#ajax_loader').hide();
	});
	

    include "../include/dbconnopen.php";
    $make_household_sqlsafe = "INSERT INTO Households (Household_Name) VALUES ('" . mysqli_real_escape_string($cnnSWOP, $_POST['household']) . "')";
    mysqli_query($cnnSWOP, $make_household_sqlsafe);
    $last_id = mysqli_insert_id($cnnSWOP);
    $add_to_household_sqlsafe = "INSERT INTO Households_Participants(Household_ID, Participant_ID, Head_of_Household) \r\n        VALUES ('" . $last_id . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['participant']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['head']) . "')";
    echo $add_to_household_sqlsafe;
    mysqli_query($cnnSWOP, $add_to_household_sqlsafe);
    include "../include/dbconnclose.php";
} elseif ($_POST['action'] == 'add') {
    /* add a new person to an existing household: */
    include "../include/dbconnopen.php";
    $add_to_household_sqlsafe = "INSERT INTO Households_Participants(Household_ID, Participant_ID, Head_of_Household) \r\n        VALUES ('" . mysqli_real_escape_string($cnnSWOP, $_POST['household']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['participant']) . "', '" . mysqli_real_escape_string($cnnSWOP, $_POST['head']) . "')";
    echo $add_to_household_sqlsafe;
    mysqli_query($cnnSWOP, $add_to_household_sqlsafe);
    include "../include/dbconnclose.php";
} elseif ($_POST['action'] == 'edit') {
    /* change household name. */
    include "../include/dbconnopen.php";
    $change_name_sqlsafe = "UPDATE Households SET Household_Name='" . mysqli_real_escape_string($cnnSWOP, $_POST['name']) . "' WHERE New_Household_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['id']) . "'";
    echo $change_name_sqlsafe;
    mysqli_query($cnnSWOP, $change_name_sqlsafe);
    include "../include/dbconnclose.php";
} elseif ($_POST['action'] == 'delete') {
    user_enforce_has_access($SWOP_id, $AdminAccess);
    /* remove a person from a household */
    $remove_household_sqlsafe = "DELETE FROM Households_Participants WHERE Households_Participants_ID='" . mysqli_real_escape_string($cnnSWOP, $_POST['id']) . "'";
    echo $remove_household_sqlsafe;
    include "../include/dbconnopen.php";
    mysqli_query($cnnSWOP, $remove_household_sqlsafe);
    include "../include/dbconnclose.php";
}

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include_once $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include_once $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Enlace_id, $ReadOnlyAccess, $_COOKIE['program']);
include "../../header.php";
include "../header.php";
include "../classes/program.php";
require_once "../classes/assessment.php";
$program = new Program();
$program->load_with_program_id($_COOKIE['program']);
?>
<!--
Shows all program information.
-->

<div style="display:none;">
    <?php 
include "../include/datepicker_wtw.php";
?>

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Enlace_id, $DataEntryAccess);
/*add new event, either to a campaign or to the Little Village-wide events*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/block_group_finder.php";
/*find the block group for the entered address */
$this_address = $_POST['address_num'] . " " . $_POST['address_dir'] . " " . $_POST['address_street'] . " " . $_POST['address_suffix'] . " Chicago IL";
$block_group = do_it_all($this_address, $map);
echo $block_group;
include "../include/dbconnopen.php";
$event_name_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['event_name']);
$campaign_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['campaign_id']);
$date_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['date']);
$address_num_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_num']);
$address_dir_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_dir']);
$address_street_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_street']);
$address_suffix_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['address_suffix']);
$event_type_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['event_type']);

<?php

/*
 *   TTM is a web application to manage data collected by community organizations.
 *   Copyright (C) 2014, 2015  Local Initiatives Support Corporation (lisc.org)
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Bickerdike_id, $DataEntryAccess);
/*
 * Add new aldermanic record (just an amount of money added at a given date).
 */
include "../include/dbconnopen.php";
$money_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['money']);
$date_sqlsafe = mysqli_real_escape_string($cnnBickerdike, $_POST['date']);
$add_bike_miles_sqlsafe = "INSERT INTO Aldermanic_Records (Environmental_Improvement_Money, Date) VALUES\r\n                    ('" . $money_sqlsafe . "',\r\n                     '" . $date_sqlsafe . "')";
mysqli_query($cnnBickerdike, $add_bike_miles_sqlsafe);
include "../include/dbconnclose.php";

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Enlace_id, $AdminAccess, $_POST['program_id']);
// Delete a program (if the user has access to that program).
//if delete program action
if ($_POST['action'] == "delete_program") {
    //get all program sessions
    include "../include/dbconnopen.php";
    $program_id_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['program_id']);
    $all_program_sessions = "SELECT Session_ID FROM Session_Names " . "WHERE Program_ID='" . $program_id_sqlsafe . "'";
    $all_program_sessions = mysqli_query($cnnEnlace, $all_program_sessions);
    include "../include/dbconnclose.php";
    //loop through program sessions
    while ($program_session = mysqli_fetch_array($all_program_sessions)) {
        //delete all program's sessions and details
        //delete session from baseline assessments
        $delete_session = "DELETE FROM Participants_Baseline_Assessments WHERE Program='" . $program_session['Session_ID'] . "'";
        echo $delete_session;

 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($LSNA_id, $AdminAccess);
/*delete various elements from places in the system (relatively self-explanatory).*/
include "../include/dbconnopen.php";
$id_sqlsafe = mysqli_real_escape_string($cnnLSNA, $_POST['id']);
if ($_POST['action'] == 'program') {
    $delete_query = "DELETE FROM Subcategories WHERE Subcategory_ID='" . $id_sqlsafe . "'";
} elseif ($_POST['action'] == 'institution') {
    $delete_query = "DELETE FROM Institutions WHERE Institution_ID='" . $id_sqlsafe . "'";
} elseif ($_POST['action'] == 'institution_affiliation') {
    $delete_query = "DELETE FROM Institutions_Participants WHERE Institutions_Participants_ID='" . $id_sqlsafe . "'";
} elseif ($_POST['action'] == 'participant') {
    $delete_query = "DELETE FROM Participants WHERE Participant_ID='" . $id_sqlsafe . "'";
} elseif ($_POST['action'] == 'event') {
    $delete_query = "DELETE FROM Subcategory_Dates WHERE Wright_College_Program_Date_ID='" . $id_sqlsafe . "'";
} elseif ($_POST['action'] == 'family') {
    $delete_query = "DELETE FROM Parent_Mentor_Children WHERE Parent_Mentor_Children_Link_ID='" . $id_sqlsafe . "'";

/*
 *   TTM is a web application to manage data collected by community organizations.
 *   Copyright (C) 2014, 2015  Local Initiatives Support Corporation (lisc.org)
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU Affero General Public License as published by
 *   the Free Software Foundation, either version 3 of the License, or
 *   (at your option) any later version.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU Affero General Public License for more details.
 *
 *   You should have received a copy of the GNU Affero General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
*/
include $_SERVER['DOCUMENT_ROOT'] . "/include/dbconnopen.php";
include $_SERVER['DOCUMENT_ROOT'] . "/core/include/setup_user.php";
user_enforce_has_access($Enlace_id, $ReadOnlyAccess);
/*check for duplicate campaigns (warn before creating two campaigns with the same name)*/
include "../include/dbconnopen.php";
$name_sqlsafe = mysqli_real_escape_string($cnnEnlace, $_POST['name']);
$get_duplicate_campaigns = "SELECT COUNT(Campaign_Name) FROM Campaigns\r\n    WHERE Campaign_Name='" . $name_sqlsafe . "'";
//echo $get_duplicate_campaigns;
$is_duplicate = mysqli_query($cnnEnlace, $get_duplicate_campaigns);
$duplicate = mysqli_fetch_row($is_duplicate);
if ($duplicate[0] > 0) {
    echo 'A campaign named ' . $_POST['name'] . ' is already in the database.  Are you sure you want to enter this campaign?';
}
include "../include/dbconnclose.php";