-
Notifications
You must be signed in to change notification settings - Fork 4
/
BatchWinnerEntry.php
121 lines (104 loc) · 4.11 KB
/
BatchWinnerEntry.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
<?php
/*******************************************************************************
*
* filename : BatchWinnerEntry.php
* last change : 2011-04-01
* website : http://www.churchdb.org
* copyright : Copyright 2011 Michael Wilt
*
* 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.
*
******************************************************************************/
//Include the function library
require "Include/Config.php";
require "Include/Functions.php";
$linkBack = FilterInput($_GET["linkBack"]);
$iCurrentFundraiser = FilterInput($_GET["CurrentFundraiser"]);
if ($iCurrentFundraiser)
$_SESSION['iCurrentFundraiser'] = $iCurrentFundraiser;
else
$iCurrentFundraiser = $_SESSION['iCurrentFundraiser'];
// Get the current fundraiser data
if ($iCurrentFundraiser) {
$sSQL = "SELECT * from fundraiser_fr WHERE fr_ID = " . $iCurrentFundraiser;
$rsDeposit = RunQuery($sSQL);
extract(mysql_fetch_array($rsDeposit));
}
//Set the page title
$sPageTitle = gettext("Batch Winner Entry");
//Is this the second pass?
if (isset($_POST["EnterWinners"])) {
for ($row = 0; $row < 10; $row += 1) {
$buyer = $_POST["Paddle$row"];
$di = $_POST["Item$row"];
$price = $_POST["SellPrice$row"];
if ($buyer>0 && $di>0 && $price > 0) {
$sSQL = "UPDATE donateditem_di SET di_buyer_id=$buyer, di_sellprice=$price WHERE di_ID=$di";
RunQuery($sSQL);
}
}
Redirect ($linkBack);
}
// Get Items for the drop-down
$sDonatedItemsSQL = "SELECT di_ID, di_Item, di_title, di_multibuy
FROM donateditem_di
WHERE di_FR_ID = '" . $iCurrentFundraiser . "' ORDER BY SUBSTR(di_Item,1,1), CONVERT(SUBSTR(di_Item,2,3),SIGNED)";
$rsDonatedItems = RunQuery($sDonatedItemsSQL);
//Get Paddles for the drop-down
$sPaddleSQL = "SELECT pn_ID, pn_Num, pn_per_ID,
a.per_FirstName AS buyerFirstName,
a.per_LastName AS buyerLastName
FROM paddlenum_pn
LEFT JOIN person_per a on a.per_ID=pn_per_ID
WHERE pn_fr_ID=" . $iCurrentFundraiser . " ORDER BY pn_Num";
$rsPaddles = RunQuery($sPaddleSQL);
require "Include/Header.php";
?>
<form method="post" action="BatchWinnerEntry.php?<?php echo "CurrentFundraiser=" . "&linkBack=" . $linkBack; ?>" name="BatchWinnerEntry">
<table cellpadding="3" align="center">
<tr>
<td class="LabelColumn"><?php echo gettext("Item"); ?></td>
<td class="LabelColumn"><?php echo gettext("Winner"); ?></td>
<td class="LabelColumn"><?php echo gettext("Price"); ?></td>
</tr>
<?php
for ($row = 0; $row < 10; $row += 1) {
echo "<tr>";
echo "<td>";
echo "<select name=\"Item" . $row . "\">\n";
echo "<option value=\"0\" selected>" . gettext("Unassigned") . "</option>\n";
mysql_data_seek ($rsDonatedItems, 0);
while ($itemArr = mysql_fetch_array($rsDonatedItems)) {
extract($itemArr);
echo "<option value=\"".$di_ID."\">" . $di_Item . " " . $di_title . "</option>\n";
}
echo "</select>\n";
echo "</td>";
echo "<td>";
echo "<select name=\"Paddle" . $row . "\">\n";
echo "<option value=\"0\" selected>" . gettext("Unassigned") . "</option>\n";
mysql_data_seek ($rsPaddles, 0);
while ($paddleArr = mysql_fetch_array($rsPaddles)) {
extract($paddleArr);
echo "<option value=\"".$pn_per_ID."\">" . $pn_Num . " " . $buyerFirstName . " " . $buyerLastName . "</option>\n";
}
echo "</select>\n";
echo "</td>";
echo "<td class=\"TextColumn\"><input type=\"text\" name=\"SellPrice$row\" id=\"SellPrice\"$row value=\"\"></td>\n";
echo "</tr>";
}
?>
<tr>
<td align="center">
<input type="submit" class="icButton" value="<?php echo gettext("Enter Winners"); ?>" name="EnterWinners">
<input type="button" class="icButton" value="<?php echo gettext("Cancel"); ?>" name="Cancel" onclick="javascript:document.location='<?php if (strlen($linkBack) > 0) { echo $linkBack; } else {echo "Menu.php"; } ?>';">
</td>
</tr>
</table>
</form>
<?php
require "Include/Footer.php";
?>