-
Notifications
You must be signed in to change notification settings - Fork 4
/
ConvertIndividualToFamily.php
152 lines (125 loc) · 4.66 KB
/
ConvertIndividualToFamily.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
/*******************************************************************************
*
* filename : ConvertIndividualToFamily.php
* website : http://www.churchdb.org
* description : utility to convert individuals to families
*
* Must be run manually by an administrator. Type this URL.
* http://www.mydomain.com/churchinfo/ConvertIndividualToFamily.php
*
* By default this script does one at a time. To do all entries
* at once use this URL
* http://www.mydomain.com/churchinfo/ConvertIndividualToFamily.php?all=true
*
* Your URL may vary. Replace "churchinfo" with $sRootPath
*
* Contributors:
* 2007 Ed Davis
*
*
* Copyright Contributors
*
* ChurchInfo is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This file best viewed in a text editor with tabs stops set to 4 characters
*
******************************************************************************/
//Include the function library
require 'Include/Config.php';
require 'Include/Functions.php';
// Security
if (!$_SESSION['bAdmin'])
{
Redirect('Menu.php');
exit;
}
if ($_GET['all'] == 'true') $bDoAll = TRUE;
//Set the page title
$sPageTitle = gettext('Convert Individuals to Families');
require 'Include/Header.php';
$iUserID = $_SESSION['iUserID'];
// find the family ID so we can associate to person record
$sSQL = 'SELECT MAX(fam_ID) AS iFamilyID FROM family_fam';
$rsLastEntry = RunQuery($sSQL);
extract(mysql_fetch_array($rsLastEntry));
// Get list of people that are not assigned to a family
$sSQL = "SELECT * FROM person_per WHERE per_fam_ID='0' ORDER BY per_LastName, per_FirstName";
$rsList = RunQuery($sSQL);
while ($aRow = mysql_fetch_array($rsList)) {
extract($aRow);
echo '<br><br><br>';
echo '*****************************************';
$per_LastName = mysql_real_escape_string($per_LastName);
$per_Address1 = mysql_real_escape_string($per_Address1);
$per_Address2 = mysql_real_escape_string($per_Address2);
$per_City = mysql_real_escape_string($per_City);
$per_State = mysql_real_escape_string($per_State);
$per_Zip = mysql_real_escape_string($per_Zip);
$per_Country = mysql_real_escape_string($per_Country);
$per_HomePhone = mysql_real_escape_string($per_HomePhone);
$sSQL = "INSERT INTO family_fam (
fam_Name,
fam_Address1,
fam_Address2,
fam_City,
fam_State,
fam_Zip,
fam_Country,
fam_HomePhone,
fam_DateEntered,
fam_EnteredBy)
VALUES ('" .
$per_LastName . "','" .
$per_Address1 . "','" .
$per_Address2 . "','" .
$per_City . "','" .
$per_State . "','" .
$per_Zip . "','" .
$per_Country . "','" .
$per_HomePhone . "'," .
"NOW()" . ",'" .
$iUserID . "')";
echo '<br>' . $sSQL;
// RunQuery to add family record
RunQuery($sSQL);
$iFamilyID++; // increment family ID
//Get the key back
$sSQL = 'SELECT MAX(fam_ID) AS iNewFamilyID FROM family_fam';
$rsLastEntry = RunQuery($sSQL);
extract(mysql_fetch_array($rsLastEntry));
if ($iNewFamilyID != $iFamilyID) {
echo '<br><br>Error with family ID';
break;
}
echo '<br><br>';
// Now update person record
$sSQL = "UPDATE person_per ".
"SET per_fam_ID='$iFamilyID',".
" per_Address1=NULL,".
" per_Address2=NULL,".
" per_City=NULL,".
" per_State=NULL,".
" per_Zip=NULL,".
" per_Country=NULL,".
" per_HomePhone=NULL,".
" per_DateLastEdited=NOW(),".
" per_EditedBy='$iUserID' ".
"WHERE per_ID='$per_ID'";
echo '<br>' . $sSQL;
RunQuery($sSQL);
echo '<br><br><br>';
echo "$per_FirstName $per_LastName (per_ID = $per_ID) is now part of the ";
echo "$per_LastName Family (fam_ID = $iFamilyID)<br>";
echo '*****************************************';
if (!$bDoAll)
break;
}
echo '<br><br>';
echo '<a href="ConvertIndividualToFamily.php">' . gettext('Convert Next') . '</a><br><br>';
echo '<a href="ConvertIndividualToFamily.php?all=true">' . gettext('Convert All') . '</a><br>';
require 'Include/Footer.php';
?>