$startpage = ceil($Result_Set / $iPerPage) - 6; if ($startpage <= 2) { $startpage = 1; } $endpage = ceil($Result_Set / $iPerPage) + 9; if ($endpage >= $Pages - 1) { $endpage = $Pages; } // Show Link "1 ..." if startpage does not start at 1 if ($startpage != 1) { echo "<a href=\"FindDepositSlip.php?Result_Set=0&Sort={$sSort}&ID={$iID}&DateStart={$dDateStart}&DateEnd={$dDateEnd}\">1</a> ... "; } $dDateStart = FilterInputArr($_GET, "DateStart"); $dDateEnd = FilterInputArr($_GET, "DateEnd"); $iID = FilterInputArr($_GET, "ID"); $sSort = FilterInputArr($_GET, "Sort"); // Display page links if ($Pages > 1) { for ($c = $startpage; $c <= $endpage; $c++) { $b = $c - 1; $thisLinkResult = $iPerPage * $b; if ($thisLinkResult != $Result_Set) { echo "<a href=\"FindDepositSlip.php?Result_Set={$thisLinkResult}&Sort={$sSort}&ID={$iID}&DateStart={$dDateStart}&DateEnd={$dDateEnd}\">{$c}</a> "; } else { echo " [ " . $c . " ] "; } } } // Show Link "... xx" if endpage is not the maximum number of pages if ($endpage != $Pages) { $thisLinkResult = ($Pages - 1) * $iPerPage;
if (array_key_exists("GroupID", $_GET)) { $iGroupID = FilterInput($_GET["GroupID"], 'int'); } $bEmptyCart = array_key_exists("EmptyCart", $_GET) && $_GET["EmptyCart"] == "yes" && array_key_exists('aPeopleCart', $_SESSION) && count($_SESSION['aPeopleCart']) > 0; $bNameError = False; $bErrorFlag = False; //Is this the second pass? if (isset($_POST["GroupSubmit"])) { //Assign everything locally $sName = FilterInputArr($_POST, "Name"); $iGroupType = FilterInputArr($_POST, "GroupType", 'int'); $iDefaultRole = FilterInputArr($_POST, "DefaultRole", 'int'); $sDescription = FilterInputArr($_POST, "Description"); $bUseGroupProps = FilterInputArr($_POST, "UseGroupProps"); $cloneGroupRole = FilterInputArr($_POST, "cloneGroupRole", 'int'); $seedGroupID = FilterInputArr($_POST, "seedGroupID", 'int'); //Did they enter a Name? if (strlen($sName) < 1) { $bNameError = True; $bErrorFlag = True; } // If no errors, then let's update... if (!$bErrorFlag) { // Are we creating a new group? if (strlen($iGroupID) < 1) { //Get a new Role List ID $sSQL = "SELECT MAX(lst_ID) FROM list_lst"; $aTemp = mysql_fetch_array(RunQuery($sSQL)); if ($aTemp[0] > 9) { $newListID = $aTemp[0] + 1; } else {
* filename : Reports/FundRaiserStatement.php * last change : 2009-04-17 * description : Creates a PDF with one or more fund raiser statements * copyright : Copyright 2009 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. * ******************************************************************************/ require "../Include/Config.php"; require "../Include/Functions.php"; require "../Include/ReportFunctions.php"; require "../Include/ReportConfig.php"; $iPaddleNumID = FilterInputArr($_GET, "PaddleNumID", 'int'); $iFundRaiserID = $_SESSION['iCurrentFundraiser']; //Get the paddlenum records for this fundraiser if ($iPaddleNumID > 0) { $selectOneCrit = " AND pn_ID=" . $iPaddleNumID . " "; } else { $selectOneCrit = ""; } $sSQL = "SELECT pn_ID, pn_fr_ID, pn_Num, pn_per_ID,\n a.per_FirstName as paddleFirstName, a.per_LastName as paddleLastName, a.per_Email as paddleEmail,\n\t\t\t\tb.fam_ID, b.fam_Name, b.fam_Address1, b.fam_Address2, b.fam_City, b.fam_State, b.fam_Zip, b.fam_Country \n FROM paddlenum_pn\n LEFT JOIN person_per a ON pn_per_ID=a.per_ID\n LEFT JOIN family_fam b ON fam_ID = a.per_fam_ID \n WHERE pn_FR_ID =" . $iFundRaiserID . $selectOneCrit . " ORDER BY pn_Num"; $rsPaddleNums = RunQuery($sSQL); class PDF_FundRaiserStatement extends ChurchInfoReport { // Constructor function PDF_FundRaiserStatement() { parent::FPDF("P", "mm", $this->paperFormat);
* * filename : PaddleNumList.php * last change : 2009-04-15 * website : http://www.churchdb.org * copyright : Copyright 2009 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 = FilterInputArr($_GET, "linkBack"); $iFundRaiserID = $_SESSION['iCurrentFundraiser']; if ($iFundRaiserID > 0) { //Get the paddlenum records for this fundraiser $sSQL = "SELECT pn_ID, pn_fr_ID, pn_Num, pn_per_ID,\n\t a.per_FirstName as buyerFirstName, a.per_LastName as buyerLastName\n\t FROM paddlenum_pn\n\t LEFT JOIN person_per a ON pn_per_ID=a.per_ID\n\t WHERE pn_FR_ID = '" . $iFundRaiserID . "' ORDER BY pn_Num"; $rsPaddleNums = RunQuery($sSQL); } else { $rsPaddleNums = 0; } $sPageTitle = gettext("Buyers for this fundraiser:"); require "Include/Header.php"; ?> <?php echo "<form method=\"post\" action=\"Reports/FundRaiserStatement.php?CurrentFundraiser={$iFundRaiserID}&linkBack=FundRaiserEditor.php?FundRaiserID={$iFundRaiserID}&CurrentFundraiser={$iFundRaiserID}\">\n"; if ($iFundRaiserID > 0) {
* last change : 2015-01-01 * website : http://www.churchdb.org * copyright : Copyright 2015 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"; $iFundRaiserID = $_SESSION['iCurrentFundraiser']; $iDonatedItemID = FilterInputArr($_GET, "DonatedItemID", "int"); $iCount = FilterInputArr($_GET, "Count", "int"); $sLetter = 'a'; $sSQL = "SELECT di_item FROM donateditem_di WHERE di_ID={$iDonatedItemID}"; $rsItem = RunQuery($sSQL); $row = mysql_fetch_array($rsItem); $startItem = $row[0]; if (strlen($startItem) == 2) { // replicated items will sort better if they have a two-digit number $letter = substr($startItem, 0, 1); $number = substr($startItem, 1, 1); $startItem = $letter . '0' . $number; } $letterNum = ord("a"); for ($i = 0; $i < $iCount; $i++) { $sSQL = "INSERT INTO donateditem_di (di_item,di_FR_ID,di_donor_ID,di_multibuy,di_title,di_description,di_sellprice,di_estprice,di_minimum,di_materialvalue,di_EnteredBy,di_EnteredDate,di_picture)"; $sSQL .= "SELECT '" . $startItem . chr($letterNum) . "',di_FR_ID,di_donor_ID,di_multibuy,di_title,di_description,di_sellprice,di_estprice,di_minimum,di_materialvalue,";
//Set the page title $sPageTitle = gettext("Donated Item Editor"); //Is this the second pass? if (isset($_POST["DonatedItemSubmit"]) || isset($_POST["DonatedItemSubmitAndAdd"])) { //Get all the variables from the request object and assign them locally $sItem = FilterInputArr($_POST, "Item"); $bMultibuy = FilterInputArr($_POST, "Multibuy", 'int'); $iDonor = FilterInputArr($_POST, "Donor", 'int'); $iBuyer = FilterInputArr($_POST, "Buyer", 'int'); $sTitle = FilterInputArr($_POST, "Title"); $sDescription = FilterInputArr($_POST, "Description"); $nSellPrice = FilterInputArr($_POST, "SellPrice"); $nEstPrice = FilterInputArr($_POST, "EstPrice"); $nMaterialValue = FilterInputArr($_POST, "MaterialValue"); $nMinimumPrice = FilterInputArr($_POST, "MinimumPrice"); $sPictureURL = FilterInputArr($_POST, "PictureURL"); if (!$bMultibuy) { $bMultibuy = 0; } if (!$iBuyer) { $iBuyer = 0; } // New DonatedItem or deposit if (strlen($iDonatedItemID) < 1) { $sSQL = "INSERT INTO donateditem_di (di_FR_ID, di_Item, di_multibuy, di_donor_ID, di_buyer_ID, di_title, di_description, di_sellprice, di_estprice, di_materialvalue, di_minimum, di_picture, di_EnteredBy, di_EnteredDate)\n\t\tVALUES (" . $iCurrentFundraiser . ",'" . $sItem . "','" . $bMultibuy . "','" . $iDonor . "','" . $iBuyer . "','" . html_entity_decode($sTitle) . "','" . html_entity_decode($sDescription) . "','" . $nSellPrice . "','" . $nEstPrice . "','" . $nMaterialValue . "','" . $nMinimumPrice . "','" . mysql_real_escape_string($sPictureURL) . "'"; $sSQL .= "," . $_SESSION['iUserID'] . ",'" . date("YmdHis") . "')"; $bGetKeyBack = True; // Existing record (update) } else { $sSQL = "UPDATE donateditem_di SET di_FR_ID = " . $iCurrentFundraiser . ", di_Item = '" . $sItem . "', di_multibuy = '" . $bMultibuy . "', di_donor_ID = " . $iDonor . ", di_buyer_ID = " . $iBuyer . ", di_title = '" . html_entity_decode($sTitle) . "', di_description = '" . html_entity_decode($sDescription) . "', di_sellprice = '" . $nSellPrice . "', di_estprice = '" . $nEstPrice . "', di_materialvalue = '" . $nMaterialValue . "', di_minimum = '" . $nMinimumPrice . "', di_picture = '" . mysql_real_escape_string($sPictureURL) . "', di_EnteredBy=" . $_SESSION['iUserID'] . ", di_EnteredDate = '" . date("YmdHis") . "'"; $sSQL .= " WHERE di_ID = " . $iDonatedItemID;
extract(mysql_fetch_array($rsFRR)); // Set current fundraiser $_SESSION['iCurrentFundraiser'] = $iFundRaiserID; } if ($iFundRaiserID > 0) { $sPageTitle = gettext("Fund Raiser #") . $iFundRaiserID . " " . $fr_title; } else { $sPageTitle = gettext("Create New Fund Raiser"); } $sDateError = ""; //Is this the second pass? if (isset($_POST["FundRaiserSubmit"])) { //Get all the variables from the request object and assign them locally $dDate = FilterInputArr($_POST, "Date"); $sTitle = FilterInputArr($_POST, "Title"); $sDescription = FilterInputArr($_POST, "Description"); //Initialize the error flag $bErrorFlag = false; // Validate Date if (strlen($dDate) > 0) { list($iYear, $iMonth, $iDay) = sscanf($dDate, "%04d-%02d-%02d"); if (!checkdate($iMonth, $iDay, $iYear)) { $sDateError = "<span style=\"color: red; \">" . gettext("Not a valid Date") . "</span>"; $bErrorFlag = true; } } //If no errors, then let's update... if (!$bErrorFlag) { // New deposit slip if ($iFundRaiserID <= 0) { $sSQL = "INSERT INTO fundraiser_fr (fr_date, fr_title, fr_description, fr_EnteredBy, fr_EnteredDate) VALUES (" . "'" . $dDate . "','" . $sTitle . "','" . $sDescription . "'," . $_SESSION['iUserID'] . ",'" . date("YmdHis") . "')";
$iEnableBankDraft = 1; } // Other information that was just entered into the payment page that we will store for reference $sVancoName = FilterInputArr($_POST, "name"); $aVancoNames = explode(" ", $sVancoName, 2); $sVancoFirstName = $aVancoNames[0]; $sVancoLastName = $aVancoNames[1]; $sVancoAddr1 = FilterInputArr($_POST, "billingaddr1"); $sVancoBillingCity = FilterInputArr($_POST, "billingcity"); $sVancoBillingState = FilterInputArr($_POST, "billingstate"); $sVancoBillingZip = FilterInputArr($_POST, "billingzip"); $sVancoEmail = FilterInputArr($_POST, "email"); $sVancoExpMonth = FilterInputArr($_POST, "expmonth"); $sVancoExpYear = FilterInputArr($_POST, "expyear"); // information reflected back (use for verification) $sVancoClientID = FilterInputArr($_POST, "clientid"); $sSQL = "UPDATE autopayment_aut SET "; $sSQL .= "aut_FirstName=\"{$sVancoFirstName}\""; $sSQL .= ", aut_LastName=\"{$sVancoLastName}\""; $sSQL .= ", aut_Address1=\"{$sVancoAddr1}\""; $sSQL .= ", aut_City=\"{$sVancoBillingCity}\""; $sSQL .= ", aut_State=\"{$sVancoBillingState}\""; $sSQL .= ", aut_Zip=\"{$sVancoBillingZip}\""; $sSQL .= ", aut_Email=\"{$sVancoEmail}\""; $sSQL .= ", aut_EnableCreditCard=\"{$iEnableCreditCard}\""; $sSQL .= ", aut_CreditCardVanco=\"{$sVancoPaymentCreditCard}\""; $sSQL .= ", aut_EnableBankDraft=\"{$iEnableBankDraft}\""; $sSQL .= ", aut_AccountVanco=\"{$sVancoPaymentBankDraft}\""; $sSQL .= ", aut_ExpMonth=\"{$sVancoExpMonth}\""; $sSQL .= ", aut_ExpYear=\"{$sVancoExpYear}\""; $sSQL .= ", aut_DateLastEdited=\"" . date("YmdHis") . "\"";
//echo $iGroupID; $iFYID = FilterInput($_GET["FYID"], 'int'); $tFirstSunday = FilterInput($_GET["FirstSunday"]); $tLastSunday = FilterInput($_GET["LastSunday"]); $tAllRoles = FilterInput($_GET["AllRoles"], 'int'); //echo "all roles ={$tAllRoles}"; $tNoSchool1 = FilterInputArr($_GET, "NoSchool1"); $tNoSchool2 = FilterInputArr($_GET, "NoSchool2"); $tNoSchool3 = FilterInputArr($_GET, "NoSchool3"); $tNoSchool4 = FilterInputArr($_GET, "NoSchool4"); $tNoSchool5 = FilterInputArr($_GET, "NoSchool5"); $tNoSchool6 = FilterInputArr($_GET, "NoSchool6"); $tNoSchool7 = FilterInputArr($_GET, "NoSchool7"); $tNoSchool8 = FilterInputArr($_GET, "NoSchool8"); $iExtraStudents = FilterInputArr($_GET, "ExtraStudents", 'int'); $iExtraTeachers = FilterInputArr($_GET, "ExtraTeachers", 'int'); $dFirstSunday = strtotime($tFirstSunday); $dLastSunday = strtotime($tLastSunday); $dNoSchool1 = strtotime($tNoSchool1); $dNoSchool2 = strtotime($tNoSchool2); $dNoSchool3 = strtotime($tNoSchool3); $dNoSchool4 = strtotime($tNoSchool4); $dNoSchool5 = strtotime($tNoSchool5); $dNoSchool6 = strtotime($tNoSchool6); $dNoSchool7 = strtotime($tNoSchool7); $dNoSchool8 = strtotime($tNoSchool8); // Reformat the dates to get standardized text representation $tFirstSunday = date("Y-m-d", $dFirstSunday); $tLastSunday = date("Y-m-d", $dLastSunday); $tNoSchool1 = date("Y-m-d", $dNoSchool1); $tNoSchool2 = date("Y-m-d", $dNoSchool2);