Holds most of the functions used for sponsormanagement. More...
Go to the source code of this file.
Variables | |
const | EDIT_SECTION_LOCK_DURATION 300 |
editsection locktime in seconds (35 ≤ x ≤ inf) More... | |
const | NUMBER_OF_CHANGES_SHOWN_PER_EDIT_SECTION 5 |
maximal number of changes that are shown when the user click 'Verlauf anzeigen' More... | |
Holds most of the functions used for sponsormanagement.
This file is one of the core-files of the whole package. It provides a huge number of functions to manipulate sponsors, sponsorcars and other persistent data. The manipulation include adding, deleting, updating and managing data in a lot of ways. Please consider reading the documentation of a single function if you want to know more about the functionalities provided by this script-file.
This file is linked with the other functions via inc/common.php.
Definition in file functions_sponsoring.php.
addCar | ( | $name) |
Adds a new car (dropdown fields)
string | $name | name of the car |
Definition at line 1788 of file functions_sponsoring.php.
addCategory | ( | $name) |
Adds a new category (dropdown fields)
string | $name | name of the category |
Definition at line 1769 of file functions_sponsoring.php.
addProductionFacility | ( | $name) |
Adds a new production facility (dropdown fields)
string | $name | name of the production facility |
Definition at line 1731 of file functions_sponsoring.php.
addSponsor | ( | $sponsor) |
Adds a new sponsor
array | $sponsor | details of the sponsor |
Definition at line 781 of file functions_sponsoring.php.
addSponsorCar | ( | $carId, | |
$sponsorId | |||
) |
Adds a new sponsor car
integer | $carId | id of the car (used to assign car name) |
integer | $sponsorId | id of the sponsor |
Definition at line 1079 of file functions_sponsoring.php.
addSponsorCarAttachment | ( | $attachment) |
Adds a new attachment
array | $attachment | details of the attachment including the sponsor car id |
Definition at line 1458 of file functions_sponsoring.php.
addSponsorCarEvent | ( | $event) |
Adds a new event
array | $event | details of the event including the sponsor car id |
Definition at line 1129 of file functions_sponsoring.php.
addSponsorCarFinancialDonation | ( | $financialDonation) |
Adds a new financial donation
array | $financialDonation | details of the financial donation including the sponsor car id |
Definition at line 1210 of file functions_sponsoring.php.
addSponsorCarMaterialDonation | ( | $materialDonation) |
Adds a new material donation
array | $materialDonation | details of the material donation including the sponsor car id |
Definition at line 1293 of file functions_sponsoring.php.
addSponsorCarProducedPart | ( | $producedPart) |
Adds a new produced part
array | $producedPart | details of the produced part including the sponsor car id |
Definition at line 1376 of file functions_sponsoring.php.
addSponsorContactPerson | ( | $sponsorContactPerson) |
Adds a new contact person
array | $sponsorContactPerson | details of the contact person including the sponsor id |
Definition at line 754 of file functions_sponsoring.php.
addSponsorProductionFacility | ( | $sponsorProductionFacility) |
Adds a new production facility
array | $sponsorProductionFacility | details of the production facility including the sponsor id |
Definition at line 661 of file functions_sponsoring.php.
addStatus | ( | $name) |
Adds a new status (dropdown fields)
string | $name | name of the status |
Definition at line 1750 of file functions_sponsoring.php.
contactPersonExists | ( | $contactPersonId) |
Checks if a contact person exists
integer | $contactPersonId | id of a contact person |
Definition at line 474 of file functions_sponsoring.php.
deleteCar | ( | $id) |
Deletes a car (dropdown fields)
integer | $id | id of the car |
Definition at line 1991 of file functions_sponsoring.php.
deleteCategory | ( | $id) |
Deletes a category (dropdown fields)
integer | $id | id of the category |
Definition at line 1958 of file functions_sponsoring.php.
deleteProductionFacility | ( | $id) |
Deletes a production facility (dropdown fields)
integer | $id | id of the production facility |
Definition at line 1892 of file functions_sponsoring.php.
deleteSponsorCarAttachment | ( | $attachmentId) |
Deletes an attachment
integer | $attachmentId | id of the attachment |
Definition at line 1479 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
deleteSponsorCarEvent | ( | $eventId) |
Deletes an event
integer | $eventId | id of the event |
Definition at line 1150 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
deleteSponsorCarFinancialDonation | ( | $financialDonationId) |
Deletes a financial donation
integer | $financialDonationId | id of the financial donation |
Definition at line 1231 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
deleteSponsorCarMaterialDonation | ( | $materialDonationId) |
Deletes a material donation
integer | $materialDonationId | id of the material donation |
Definition at line 1315 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
deleteSponsorCarProducedPart | ( | $producedPartId) |
Deletes a produced part
integer | $producedPartId | id of the produced part |
Definition at line 1398 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
deleteSponsorContactPerson | ( | $contactPersonId, | |
$updateLockUserIdBefore = FALSE |
|||
) |
Deletes a contact person
integer | $contactPersonId | id of the contact person |
boolean | $updateLockUserIdBefore | [optional]
|
Definition at line 684 of file functions_sponsoring.php.
Referenced by deleteSponsor().
deleteSponsorProductionFacility | ( | $sponsorProductionFacilityId, | |
$updateLockUserIdBefore = FALSE |
|||
) |
Deletes a production facility
integer | $sponsorProductionFacilityId | id of the production facility |
boolean | $updateLockUserIdBefore | [optional]
|
Definition at line 601 of file functions_sponsoring.php.
Referenced by deleteSponsor().
deleteStatus | ( | $id) |
Deletes a status (dropdown fields)
integer | $id | id of the status |
Definition at line 1925 of file functions_sponsoring.php.
fetchAllCars | ( | ) |
Fetches all the details of the cars (dropdown fields)
Definition at line 1513 of file functions_sponsoring.php.
fetchAllCategories | ( | ) |
Fetches all the details of the categories (dropdown fields)
Definition at line 1587 of file functions_sponsoring.php.
fetchAllProductionFacilities | ( | ) |
Fetches all the details of the production facilities (dropdown fields)
Definition at line 1537 of file functions_sponsoring.php.
fetchAllSponsors | ( | ) |
Fetches all the details of the sponsors in an alphabetical order
Definition at line 39 of file functions_sponsoring.php.
References $db, $mysqli, and fetchSponsorLatestEditData().
fetchAllStatus | ( | ) |
Fetches all the details of the status (dropdown fields)
Definition at line 1562 of file functions_sponsoring.php.
fetchCarDetails | ( | $carId) |
Fetches all the details of a car (dropdown fields)
integer | $carId | id of the car |
Definition at line 1703 of file functions_sponsoring.php.
fetchCategoryDetails | ( | $categoryId) |
Fetches all the details of a category (dropdown fields)
integer | $categoryId | id of the category |
Definition at line 1673 of file functions_sponsoring.php.
fetchContactPersonDetailsForVCard | ( | $contactPersonId) |
Fetches all the information needed for a vCard
integer | $contactPersonId | id of a contact person |
Definition at line 434 of file functions_sponsoring.php.
fetchPossibleNewSponsorCars | ( | $sponsorId) |
Fetches all the cars, which are not noted in a sponsor
integer | $sponsorId | id of the sponsor |
Definition at line 527 of file functions_sponsoring.php.
fetchProductionFacilityDetails | ( | $productionFacilityId) |
Fetches all the details of a production facility (dropdown fields)
integer | $productionFacilityId | id of the production facility |
Definition at line 1613 of file functions_sponsoring.php.
fetchSponsorCarAttachments | ( | $sponsorCarId) |
Fetches all the attachments of a sponsor car
integer | $sponsorCarId | id of the sponsor car |
Definition at line 1018 of file functions_sponsoring.php.
References $db, $filename, and $mysqli.
Referenced by deleteSponsorCar().
fetchSponsorCarDetails | ( | $sponsorId, | |
$sponsorCarId = null |
|||
) |
Fetches all the details of a sponsor car
integer | $sponsorId | id of the sponsor |
integer | $sponsorCarId | [optional]
|
Definition at line 817 of file functions_sponsoring.php.
Referenced by deleteSponsor(), and deleteSponsorCar().
fetchSponsorCarEvents | ( | $sponsorCarId) |
Fetches all the events of a sponsor car
integer | $sponsorCarId | id of the sponsor car |
Definition at line 894 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
fetchSponsorCarFinancialDonations | ( | $sponsorCarId) |
Fetches all the financial donations of a sponsor car
integer | $sponsorCarId | id of the sponsor car |
Definition at line 924 of file functions_sponsoring.php.
fetchSponsorCarMaterialDonation | ( | $sponsorCarId) |
Fetches all the material donations of a sponsor car
integer | $sponsorCarId | id of the sponsor car |
Definition at line 954 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
fetchSponsorCarNames | ( | $sponsorId) |
Fetches all the car names of a sponsor
integer | $sponsorId | id of the sponsor |
Definition at line 498 of file functions_sponsoring.php.
fetchSponsorCarProducedParts | ( | $sponsorCarId) |
Fetches all the produced parts of a sponsor car
integer | $sponsorCarId | id of the sponsor car |
Definition at line 986 of file functions_sponsoring.php.
Referenced by deleteSponsorCar().
fetchSponsorContactPersons | ( | $sponsorId) |
Fetches all the contact persons of a sponsor
integer | $sponsorId | id of the sponsor |
Definition at line 394 of file functions_sponsoring.php.
Referenced by deleteSponsor(), fetchContactPersonsWithMailAdresses(), fetchMailAdresses(), fetchMailAdressesNewsletter(), and fetchSponsorMailNewsletter().
fetchSponsorDetails | ( | $sponsorId, | |
$includingLastEdit = TRUE |
|||
) |
Fetches all the details of a sponsor
integer | $sponsorId | id of the sponsor |
boolean | $includingLastEdit | [optional]
|
Definition at line 99 of file functions_sponsoring.php.
References $db, $mysqli, and fetchSponsorLatestEditData().
Referenced by fetchContactPersonsWithMailAdresses(), fetchSponsorAddresses(), and fetchSponsorMailNewsletter().
fetchSponsorEditDataForEditSections | ( | $sponsorId, | |
$cnt | |||
) |
Fetches the a list of modification details of a sponsor (each edit section separately)
integer | $sponsorId | id of the sponsor |
integer | $cnt | number of entries in the list for each edit section |
Definition at line 243 of file functions_sponsoring.php.
References $db, $dbBackup, $mysqli, and fetchUsername().
fetchSponsorLatestEditData | ( | $sponsorId) |
Fetches the details a sponsor was last modified (all edit sections)
integer | $sponsorId | id of the sponsor |
Definition at line 158 of file functions_sponsoring.php.
References $db, $dbBackup, $mysqli, and fetchUsername().
Referenced by fetchAllSponsors(), fetchSponsorDetails(), and searchDatabase().
fetchSponsorProductionFacilities | ( | $sponsorId) |
Fetches all the production facilities of a sponsor
integer | $sponsorId | id of the sponsor |
Definition at line 362 of file functions_sponsoring.php.
Referenced by deleteSponsor().
fetchStatusDetails | ( | $statusId) |
Fetches all the details of a status (dropdown fields)
integer | $statusId | id of the status |
Definition at line 1643 of file functions_sponsoring.php.
updateCar | ( | $name, | |
$id | |||
) |
Updates a car (dropdown fields)
string | $name | new name of the car |
integer | $id | id of the car to update |
Definition at line 1871 of file functions_sponsoring.php.
updateCategory | ( | $name, | |
$id | |||
) |
Updates a catagory (dropdown fields)
string | $name | new name of the catagory |
integer | $id | id of the catagory to update |
Definition at line 1850 of file functions_sponsoring.php.
updateProductionFacility | ( | $name, | |
$id | |||
) |
Updates a production facility (dropdown fields)
string | $name | new name of the production facility |
integer | $id | id of the production facility to update |
Definition at line 1808 of file functions_sponsoring.php.
updateSponsorCarAttachments | ( | $attachments) |
Updates all the attachments of a sponsor car
array | $attachments | new details of the attachments |
Definition at line 1427 of file functions_sponsoring.php.
updateSponsorCarDetails | ( | $sponsorCar) |
Updates all the details of a sponsor car
array | $sponsorCar | new sponsor car details including the sponsor car id |
Definition at line 1048 of file functions_sponsoring.php.
updateSponsorCarEvents | ( | $events) |
Updates all the events of a sponsor car
array | $events | new details of the events |
Definition at line 1097 of file functions_sponsoring.php.
updateSponsorCarFinancialDonations | ( | $financialDonations) |
Updates all the financial donations of a sponsor car
array | $financialDonations | new details of the financial donations |
Definition at line 1178 of file functions_sponsoring.php.
updateSponsorCarMaterialDonations | ( | $materialDonations) |
Updates all the material donations of a sponsor car
array | $materialDonations | new details of the material donations |
Definition at line 1259 of file functions_sponsoring.php.
updateSponsorCarProducedParts | ( | $producedParts) |
Updates all the produced parts of a sponsor car
array | $producedParts | new details of the produced parts |
Definition at line 1343 of file functions_sponsoring.php.
updateSponsorContactPersons | ( | $sponsorContactPersons) |
Updates all the contact persons of a sponsor
array | $sponsorContactPersons | new details of the contact persons |
Definition at line 714 of file functions_sponsoring.php.
updateSponsorDetails | ( | $sponsorArray) |
Updates all the details of a sponsor
array | $sponsorArray | new sponsor details including the sponsor id |
Definition at line 554 of file functions_sponsoring.php.
updateSponsorProductionFacilities | ( | $sponsorProductionFacilities) |
Updates all the production facilities of a sponsor
array | $sponsorProductionFacilities | new details of the production facilities |
Definition at line 631 of file functions_sponsoring.php.
updateStatus | ( | $name, | |
$id | |||
) |
Updates a status (dropdown fields)
string | $name | new name of the status |
integer | $id | id of the status to update |
Definition at line 1829 of file functions_sponsoring.php.
const EDIT_SECTION_LOCK_DURATION 300 |
editsection locktime in seconds (35 ≤ x ≤ inf)
Definition at line 27 of file functions_sponsoring.php.
Referenced by lockCar(), lockCategory(), lockProductionFacility(), lockSponsorEditSection(), lockStatus(), and renewSponsorEditSectionLock().
const NUMBER_OF_CHANGES_SHOWN_PER_EDIT_SECTION 5 |
maximal number of changes that are shown when the user click 'Verlauf anzeigen'
Definition at line 29 of file functions_sponsoring.php.