def update_diary_from_form(dbo, username, data):
"""
Updates a diary note from form data
"""
l = dbo.locale
diaryid = utils.df_ki(data, "diaryid")
if utils.df_ks(data, "diarydate") == "":
raise utils.ASMValidationError(i18n._("Diary date cannot be blank", l))
if utils.df_kd(data, "diarydate", l) is None:
raise utils.ASMValidationError(i18n._("Diary date is not valid", l))
if utils.df_ks(data, "subject") == "":
raise utils.ASMValidationError(i18n._("Diary subject cannot be blank", l))
if utils.df_ks(data, "note") == "":
raise utils.ASMValidationError(i18n._("Diary note cannot be blank", l))
diarytime = utils.df_ks(data, "diarytime").strip()
if diarytime != "":
if diarytime.find(":") == -1:
raise utils.ASMValidationError(i18n._("Invalid time, times should be in HH:MM format", l))
if not utils.is_numeric(diarytime.replace(":", "")):
raise utils.ASMValidationError(i18n._("Invalid time, times should be in HH:MM format", l))
sql = db.make_update_user_sql(dbo, "diary", username, "ID=%d" % diaryid, (
( "DiaryDateTime", utils.df_dt(data, "diarydate", "diarytime", l) ),
( "DiaryForName", utils.df_t(data, "diaryfor") ),
( "Subject", utils.df_t(data, "subject") ),
( "Note", utils.df_t(data, "note") ),
( "Comments", utils.df_t(data, "comments") ),
( "DateCompleted", utils.df_d(data, "completed", l) )
))
preaudit = db.query(dbo, "SELECT * FROM diary WHERE ID=%d" % diaryid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM diary WHERE ID=%d" % diaryid)
audit.edit(dbo, username, "diary", audit.map_diff(preaudit, postaudit))
def update_movement_from_form(dbo, username, post):
"""
Updates a movement record from posted form data
"""
validate_movement_form_data(dbo, post)
movementid = post.integer("movementid")
sql = db.make_update_user_sql(dbo, "adoption", username, "ID=%d" % movementid, (
( "AdoptionNumber", post.db_string("adoptionno")),
( "OwnerID", post.db_integer("person")),
( "RetailerID", post.db_integer("retailer")),
( "AnimalID", post.db_integer("animal")),
( "OriginalRetailerMovementID", post.db_integer("originalretailermovement")),
( "MovementDate", post.db_date("movementdate")),
( "MovementType", post.db_integer("type")),
( "ReturnDate", post.db_date("returndate")),
( "ReturnedReasonID", post.db_integer("returncategory")),
( "Donation", post.db_integer("donation")),
( "InsuranceNumber", post.db_string("insurance")),
( "ReasonForReturn", post.db_string("reason")),
( "ReservationDate", post.db_date("reservationdate")),
( "ReservationCancelledDate", post.db_date("reservationcancelled")),
( "ReservationStatusID", post.db_integer("reservationstatus")),
( "IsTrial", post.db_boolean("trial")),
( "IsPermanentFoster", post.db_boolean("permanentfoster")),
( "TrialEndDate", post.db_date("trialenddate")),
( "Comments", post.db_string("comments"))
))
preaudit = db.query(dbo, "SELECT * FROM adoption WHERE ID = %d" % movementid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM adoption WHERE ID = %d" % movementid)
audit.edit(dbo, username, "adoption", movementid, audit.map_diff(preaudit, postaudit))
animal.update_animal_status(dbo, post.integer("animal"))
animal.update_variable_animal_data(dbo, post.integer("animal"))
update_movement_donation(dbo, movementid)
def update_vaccination_from_form(dbo, username, data):
"""
Updates a vaccination record from posted form data
"""
l = dbo.locale
vaccid = utils.df_ki(data, "vaccid")
if utils.df_kd(data, "required", l) is None:
raise utils.ASMValidationError(
_("Required date must be a valid date", l))
sql = db.make_update_user_sql(
dbo, "animalvaccination", username, "ID=%d" % vaccid,
(("AnimalID", db.di(utils.df_ki(data, "animal"))),
("VaccinationID", utils.df_s(data, "type")),
("DateOfVaccination", utils.df_d(data, "given", l)),
("DateRequired", utils.df_d(data, "required", l)),
("Cost", utils.df_m(data, "cost", l)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(
dbo, "SELECT * FROM animalvaccination WHERE ID = %d" % vaccid)
db.execute(dbo, sql)
postaudit = db.query(
dbo, "SELECT * FROM animalvaccination WHERE ID = %d" % vaccid)
audit.edit(dbo, username, "animalvaccination",
audit.map_diff(preaudit, postaudit))
def update_waitinglist_from_form(dbo, data, username):
"""
Updates a waiting list record from the screen
data: The webpy data object containing form parameters
"""
l = dbo.locale
wlid = utils.df_ki(data, "id")
if utils.df_ks(data, "description") == "":
raise utils.ASMValidationError(_("Description cannot be blank", l))
if utils.df_ki(data, "owner") == "0":
raise utils.ASMValidationError(_("Waiting list entries must have a contact", l))
if utils.df_ks(data, "dateputon") == "":
raise utils.ASMValidationError(_("Date put on cannot be blank", l))
preaudit = db.query(dbo, "SELECT * FROM animalwaitinglist WHERE ID = %d" % wlid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalwaitinglist", username, "ID=%d" % wlid, (
( "SpeciesID", utils.df_s(data, "species")),
( "DatePutOnList", utils.df_d(data, "dateputon", l)),
( "OwnerID", utils.df_s(data, "owner")),
( "AnimalDescription", utils.df_t(data, "description")),
( "ReasonForWantingToPart", utils.df_t(data, "reasonforwantingtopart")),
( "CanAffordDonation", utils.df_c(data, "canafforddonation")),
( "Urgency", utils.df_s(data, "urgency")),
( "DateRemovedFromList", utils.df_d(data, "dateremoved", l)),
( "AutoRemovePolicy", utils.df_s(data, "autoremovepolicy")),
( "DateOfLastOwnerContact", utils.df_d(data, "dateoflastownercontact", l)),
( "ReasonForRemoval", utils.df_t(data, "reasonforremoval")),
( "Comments", utils.df_t(data, "comments"))
)))
additional.save_values_for_link(dbo, data, wlid, "waitinglist")
postaudit = db.query(dbo, "SELECT * FROM animalwaitinglist WHERE ID = %d" % wlid)
audit.edit(dbo, username, "animalwaitinglist", audit.map_diff(preaudit, postaudit))
def update_regimen_from_form(dbo, username, data):
"""
Updates a regimen record from posted form data
"""
l = dbo.locale
regimenid = utils.df_ki(data, "regimenid")
if utils.df_ks(data, "treatmentname") == "":
raise utils.ASMValidationError(_("Treatment name cannot be blank", l))
sql = db.make_update_user_sql(
dbo, "animalmedical", username, "ID=%d" % regimenid,
(("TreatmentName", utils.df_t(data, "treatmentname")),
("Dosage", utils.df_t(data, "dosage")),
("Status", utils.df_s(data, "status")),
("Cost", utils.df_m(data, "cost", l)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(dbo,
"SELECT * FROM animalmedical WHERE ID=%d" % regimenid)
db.execute(dbo, sql)
postaudit = db.query(dbo,
"SELECT * FROM animalmedical WHERE ID=%d" % regimenid)
audit.edit(
dbo, username, "animalmedical",
audit.map_diff(preaudit, postaudit, ["TREATMENTNAME", "DOSAGE"]))
update_medical_treatments(dbo, username, utils.df_ki(data, "regimenid"))
def update_diary_from_form(dbo, username, post):
"""
Updates a diary note from form data
"""
l = dbo.locale
diaryid = post.integer("diaryid")
if post["diarydate"] == "":
raise utils.ASMValidationError(i18n._("Diary date cannot be blank", l))
if post.date("diarydate") is None:
raise utils.ASMValidationError(i18n._("Diary date is not valid", l))
if post["subject"] == "":
raise utils.ASMValidationError(
i18n._("Diary subject cannot be blank", l))
if post["note"] == "":
raise utils.ASMValidationError(i18n._("Diary note cannot be blank", l))
diarytime = post["diarytime"].strip()
if diarytime != "":
if diarytime.find(":") == -1:
raise utils.ASMValidationError(
i18n._("Invalid time, times should be in HH:MM format", l))
if not utils.is_numeric(diarytime.replace(":", "")):
raise utils.ASMValidationError(
i18n._("Invalid time, times should be in HH:MM format", l))
sql = db.make_update_user_sql(
dbo, "diary", username, "ID=%d" % diaryid,
(("DiaryDateTime", post.db_datetime("diarydate", "diarytime")),
("DiaryForName", post.db_string("diaryfor")),
("Subject", post.db_string("subject")),
("Note", post.db_string("note")),
("DateCompleted", post.db_date("completed"))))
preaudit = db.query(dbo, "SELECT * FROM diary WHERE ID=%d" % diaryid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM diary WHERE ID=%d" % diaryid)
audit.edit(dbo, username, "diary", audit.map_diff(preaudit, postaudit))
def update_test_from_form(dbo, username, data):
"""
Updates a test record from posted form data
"""
l = dbo.locale
testid = utils.df_ki(data, "testid")
if utils.df_kd(data, "required", l) is None:
raise utils.ASMValidationError(
_("Required date must be a valid date", l))
sql = db.make_update_user_sql(
dbo, "animaltest", username, "ID=%d" % testid,
(("AnimalID", db.di(utils.df_ki(data, "animal"))),
("TestTypeID", utils.df_s(data, "type")),
("TestResultID", utils.df_s(data, "result")),
("DateOfTest", utils.df_d(data, "given", l)),
("DateRequired", utils.df_d(data, "required", l)),
("Cost", utils.df_m(data, "cost", l)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(dbo, "SELECT * FROM animaltest WHERE ID = %d" % testid)
db.execute(dbo, sql)
postaudit = db.query(dbo,
"SELECT * FROM animaltest WHERE ID = %d" % testid)
audit.edit(dbo, username, "animaltest",
audit.map_diff(preaudit, postaudit))
# ASM2_COMPATIBILITY
update_asm2_tests(dbo, testid)
def update_donation_from_form(dbo, username, data):
"""
Updates a donation record from posted form data
"""
l = dbo.locale
donationid = utils.df_ki(data, "donationid")
sql = db.make_update_user_sql(
dbo, "ownerdonation", username, "ID=%d" % donationid,
(("OwnerID", db.di(utils.df_ki(data, "person"))),
("AnimalID", db.di(utils.df_ki(data, "animal"))),
("MovementID", db.di(utils.df_ki(data, "movement"))),
("DonationTypeID", utils.df_s(data, "type")),
("DonationPaymentID", utils.df_s(data, "payment")),
("Frequency", utils.df_s(data, "frequency")),
("Donation", utils.df_m(data, "amount", l)),
("DateDue", utils.df_d(data, "due", l)),
("Date", utils.df_d(data, "received", l)),
("IsGiftAid", utils.df_s(data, "giftaid")),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(
dbo, "SELECT * FROM ownerdonation WHERE ID = %d" % donationid)
db.execute(dbo, sql)
postaudit = db.query(
dbo, "SELECT * FROM ownerdonation WHERE ID = %d" % donationid)
audit.edit(dbo, username, "ownerdonation",
audit.map_diff(preaudit, postaudit))
update_matching_transaction(dbo, username, donationid)
check_create_next_donation(dbo, username, donationid)
movement.update_movement_donation(dbo, utils.df_ki(data, "movement"))
def update_foundanimal_from_form(dbo, data, username):
"""
Updates a found animal record from the screen
data: The webpy data object containing form parameters
"""
l = dbo.locale
lfid = utils.df_ki(data, "id")
if utils.df_kd(data, "datefound", l) is None:
raise utils.ASMValidationError(_("Date found cannot be blank", l))
if utils.df_kd(data, "datereported", l) is None:
raise utils.ASMValidationError(_("Date reported cannot be blank", l))
if utils.df_ki(data, "owner") == "0":
raise utils.ASMValidationError(_("Found animals must have a contact", l))
preaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalfound", username, "ID=%d" % lfid, (
( "AnimalTypeID", utils.df_s(data, "species")),
( "DateReported", utils.df_d(data, "datereported", l)),
( "ReturnToOwnerDate", utils.df_d(data, "returntoownerdate", l)),
( "DateFound", utils.df_d(data, "datefound", l)),
( "Sex", utils.df_s(data, "sex")),
( "BreedID", utils.df_s(data, "breed")),
( "AgeGroup", utils.df_t(data, "agegroup")),
( "BaseColourID", utils.df_s(data, "colour")),
( "DistFeat", utils.df_t(data, "markings")),
( "AreaFound", utils.df_t(data, "areafound")),
( "AreaPostcode", utils.df_t(data, "areapostcode")),
( "OwnerID", utils.df_s(data, "owner")),
( "Comments", utils.df_t(data, "comments"))
)))
additional.save_values_for_link(dbo, data, lfid, "foundanimal")
postaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
audit.edit(dbo, username, "animalfound", audit.map_diff(preaudit, postaudit))
def update_donation_from_form(dbo, username, data):
"""
Updates a donation record from posted form data
"""
l = dbo.locale
donationid = utils.df_ki(data, "donationid")
sql = db.make_update_user_sql(dbo, "ownerdonation", username, "ID=%d" % donationid, (
( "OwnerID", db.di(utils.df_ki(data, "person"))),
( "AnimalID", db.di(utils.df_ki(data, "animal"))),
( "MovementID", db.di(utils.df_ki(data, "movement"))),
( "DonationTypeID", utils.df_s(data, "type")),
( "DonationPaymentID", utils.df_s(data, "payment")),
( "Frequency", utils.df_s(data, "frequency")),
( "Donation", utils.df_m(data, "amount", l)),
( "DateDue", utils.df_d(data, "due", l)),
( "Date", utils.df_d(data, "received", l)),
( "IsGiftAid", utils.df_s(data, "giftaid")),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM ownerdonation WHERE ID = %d" % donationid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM ownerdonation WHERE ID = %d" % donationid)
audit.edit(dbo, username, "ownerdonation", audit.map_diff(preaudit, postaudit))
update_matching_transaction(dbo, username, donationid)
check_create_next_donation(dbo, username, donationid)
movement.update_movement_donation(dbo, utils.df_ki(data, "movement"))
def update_account_from_form(dbo, username, post):
"""
Updates an account from posted form data
"""
l = dbo.locale
accountid = post.integer("accountid")
if post["code"] == "":
raise utils.ASMValidationError(i18n._("Account code cannot be blank.", l))
if 0 != db.query_int(dbo, "SELECT COUNT(*) FROM accounts WHERE Code Like '%s' AND ID <> %d" % (post["code"], accountid)):
raise utils.ASMValidationError(i18n._("Account code '{0}' has already been used.", l).format(post["code"]))
sql = db.make_update_user_sql(dbo, "accounts", username, "ID=%d" % accountid, (
( "Code", post.db_string("code")),
( "AccountType", post.db_integer("type")),
( "DonationTypeID", post.db_integer("donationtype")),
( "Description", post.db_string("description"))
))
preaudit = db.query(dbo, "SELECT * FROM accounts WHERE ID = %d" % accountid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM accounts WHERE ID = %d" % accountid)
audit.edit(dbo, username, "accounts", audit.map_diff(preaudit, postaudit))
db.execute(dbo, "DELETE FROM accountsrole WHERE AccountID = %d" % accountid)
for rid in post.integer_list("viewroles"):
db.execute(dbo, "INSERT INTO accountsrole (AccountID, RoleID, CanView, CanEdit) VALUES (%d, %d, 1, 0)" % (accountid, rid))
for rid in post.integer_list("editroles"):
if rid in post.integer_list("viewroles"):
db.execute(dbo, "UPDATE accountsrole SET CanEdit = 1 WHERE AccountID = %d AND RoleID = %d" % (accountid, rid))
else:
db.execute(dbo, "INSERT INTO accountsrole (AccountID, RoleID, CanView, CanEdit) VALUES (%d, %d, 0, 1)" % (accountid, rid))
def update_trx_from_form(dbo, username, post):
"""
Updates a transaction from posted form data
"""
l = dbo.locale
amount = 0
source = 0
target = 0
deposit = post.money("deposit")
withdrawal = post.money("withdrawal")
account = post.integer("accountid")
trxid = post.integer("trxid")
other = get_account_id(dbo, post["otheraccount"])
if other == 0:
raise utils.ASMValidationError(i18n._("Account code '{0}' is not valid.", l).format(post["otheraccount"]))
if deposit > 0:
amount = deposit
source = other
target = account
else:
amount = withdrawal
source = account
target = other
sql = db.make_update_user_sql(dbo, "accountstrx", username, "ID=%d" % trxid, (
( "TrxDate", post.db_date("trxdate")),
( "Description", post.db_string("description")),
( "Reconciled", post.db_integer("reconciled")),
( "Amount", db.di(amount)),
( "SourceAccountID", db.di(source)),
( "DestinationAccountID", db.di(target))
))
preaudit = db.query(dbo, "SELECT * FROM accountstrx WHERE ID = %d" % trxid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM accountstrx WHERE ID = %d" % trxid)
audit.edit(dbo, username, "accountstrx", audit.map_diff(preaudit, postaudit))
def update_transport_from_form(dbo, username, post):
"""
Updates a movement record from posted form data
"""
transportid = post.integer("transportid")
sql = db.make_update_user_sql(dbo, "animaltransport", username, "ID=%d" % transportid, (
( "AnimalID", post.db_integer("animal")),
( "DriverOwnerID", post.db_integer("driver")),
( "PickupOwnerID", post.db_integer("pickup")),
( "PickupAddress", post.db_string("pickupaddress")),
( "PickupTown", post.db_string("pickuptown")),
( "PickupCounty", post.db_string("pickupcounty")),
( "PickupDateTime", post.db_datetime("pickupdate", "pickuptime")),
( "PickupPostcode", post.db_string("pickuppostcode")),
( "DropoffOwnerID", post.db_integer("dropoff")),
( "DropoffAddress", post.db_string("dropoffaddress")),
( "DropoffTown", post.db_string("dropofftown")),
( "DropoffCounty", post.db_string("dropoffcounty")),
( "DropoffPostcode", post.db_string("dropoffpostcode")),
( "DropoffDateTime", post.db_datetime("dropoffdate", "dropofftime")),
( "Status", post.db_integer("status")),
( "Miles", post.db_integer("miles")),
( "Cost", post.db_integer("cost")),
( "CostPaidDate", post.db_date("costpaid")),
( "Comments", post.db_string("comments"))
))
preaudit = db.query(dbo, "SELECT * FROM animaltransport WHERE ID = %d" % transportid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM animaltransport WHERE ID = %d" % transportid)
audit.edit(dbo, username, "animaltransport", transportid, audit.map_diff(preaudit, postaudit))
def update_movement_from_form(dbo, username, data):
"""
Updates a movement record from posted form data
"""
validate_movement_form_data(dbo, data)
l = dbo.locale
movementid = utils.df_ki(data, "movementid")
sql = db.make_update_user_sql(dbo, "adoption", username, "ID=%d" % movementid, (
( "AdoptionNumber", utils.df_t(data, "adoptionno")),
( "OwnerID", db.di(utils.df_ki(data, "person"))),
( "RetailerID", db.di(utils.df_ki(data, "retailer"))),
( "AnimalID", db.di(utils.df_ki(data, "animal"))),
( "OriginalRetailerMovementID", db.di(utils.df_ki(data, "originalretailermovement"))),
( "MovementDate", utils.df_d(data, "movementdate", l)),
( "MovementType", utils.df_s(data, "type")),
( "ReturnDate", utils.df_d(data, "returndate", l)),
( "ReturnedReasonID", utils.df_s(data, "returncategory")),
( "Donation", utils.df_m(data, "donation", l)),
( "InsuranceNumber", utils.df_t(data, "insurance")),
( "ReasonForReturn", utils.df_t(data, "reason")),
( "ReservationDate", utils.df_d(data, "reservationdate", l)),
( "ReservationCancelledDate", utils.df_d(data, "reservationcancelled", l)),
( "IsTrial", utils.df_c(data, "trial")),
( "IsPermanentFoster", utils.df_c(data, "permanentfoster")),
( "TrialEndDate", utils.df_d(data, "trialenddate", l)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM adoption WHERE ID = %d" % movementid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM adoption WHERE ID = %d" % movementid)
audit.edit(dbo, username, "adoption", audit.map_diff(preaudit, postaudit))
animal.update_animal_status(dbo, utils.df_ki(data, "animal"))
animal.update_variable_animal_data(dbo, utils.df_ki(data, "animal"))
update_movement_donation(dbo, movementid)
def update_vaccination_today(dbo, username, vaccid):
"""
Marks a vaccination record as given today.
"""
db.execute(dbo, db.make_update_user_sql(dbo, "animalvaccination", username, "ID = %d" % vaccid, (
( "DateOfVaccination", db.dd(now(dbo.timezone)) ),
None )
))
def update_test_today(dbo, username, testid, resultid):
"""
Marks a test record as performed today.
"""
db.execute(dbo, db.make_update_user_sql(dbo, "animaltest", username, "ID = %d" % testid, (
( "DateOfTest", db.dd(now(dbo.timezone)) ),
( "TestResultID", db.di(resultid) )
)))
def update_vaccination_today(dbo, username, vaccid):
"""
Marks a vaccination record as given today.
"""
db.execute(
dbo,
db.make_update_user_sql(
dbo, "animalvaccination", username, "ID = %d" % vaccid,
(("DateOfVaccination", db.dd(now(dbo.timezone))), None)))
def update_vaccination_required(dbo, username, vaccid, newdate):
"""
Gives a vaccination record a required date of newdate, assuming
that newdate is valid.
"""
db.execute(dbo, db.make_update_user_sql(dbo, "animalvaccination", username, "ID = %d" % vaccid, (
( "DateRequired", db.dd(newdate) ),
)))
audit.edit(dbo, username, "animalvaccination", "%d required => %s" % (vaccid, str(newdate)))
def update_test_today(dbo, username, testid, resultid):
"""
Marks a test record as performed today.
"""
db.execute(
dbo,
db.make_update_user_sql(dbo, "animaltest", username,
"ID = %d" % testid,
(("DateOfTest", db.dd(now(dbo.timezone))),
("TestResultID", db.di(resultid)))))
def update_animalcontrol_from_form(dbo, post, username):
"""
Updates an animal control incident record from the screen
data: The webpy data object containing form parameters
"""
l = dbo.locale
acid = post.integer("id")
if post.date("incidentdate") is None:
raise utils.ASMValidationError(_("Incident date cannot be blank", l))
preaudit = db.query(dbo,
"SELECT * FROM animalcontrol WHERE ID = %d" % acid)
db.execute(
dbo,
db.make_update_user_sql(
dbo, "animalcontrol", username, "ID=%d" % acid,
(("IncidentDateTime",
post.db_datetime("incidentdate", "incidenttime")),
("IncidentTypeID", post.db_integer("incidenttype")),
("CallDateTime", post.db_datetime("calldate", "calltime")),
("CallNotes", post.db_string("callnotes")),
("CallTaker", post.db_string("calltaker")),
("CallerID", post.db_integer("caller")),
("VictimID", post.db_integer("victim")),
("DispatchAddress", post.db_string("dispatchaddress")),
("DispatchTown", post.db_string("dispatchtown")),
("DispatchCounty", post.db_string("dispatchcounty")),
("DispatchPostcode", post.db_string("dispatchpostcode")),
("DispatchLatLong", post.db_string("dispatchlatlong")),
("DispatchedACO", post.db_string("dispatchedaco")),
("DispatchDateTime",
post.db_datetime("dispatchdate", "dispatchtime")),
("RespondedDateTime",
post.db_datetime("respondeddate", "respondedtime")),
("FollowupDateTime",
post.db_datetime("followupdate", "followuptime")),
("FollowupDateTime2",
post.db_datetime("followupdate2", "followuptime2")),
("FollowupDateTime3",
post.db_datetime("followupdate3", "followuptime3")),
("CompletedDate", post.db_date("completeddate")),
("IncidentCompletedID", post.db_integer("completedtype")),
("OwnerID", post.db_integer("owner")),
("Owner2ID", post.db_integer("owner2")),
("Owner3ID", post.db_integer("owner3")),
("AnimalID", post.db_integer("animal")),
("AnimalDescription", post.db_string("animaldescription")),
("SpeciesID", post.db_integer("species")),
("Sex", post.db_integer("sex")), ("AgeGroup",
post.db_string("agegroup")))))
additional.save_values_for_link(dbo, post, acid, "incident")
postaudit = db.query(dbo,
"SELECT * FROM animalcontrol WHERE ID = %d" % acid)
audit.edit(dbo, username, "animalcontrol",
audit.map_diff(preaudit, postaudit))
def update_vaccination_required(dbo, username, vaccid, newdate):
"""
Gives a vaccination record a required date of newdate, assuming
that newdate is valid.
"""
db.execute(
dbo,
db.make_update_user_sql(dbo, "animalvaccination", username,
"ID = %d" % vaccid,
(("DateRequired", db.dd(newdate)), )))
audit.edit(dbo, username, "animalvaccination",
"%d required => %s" % (vaccid, str(newdate)))
def update_animalcontrol_from_form(dbo, post, username):
"""
Updates an animal control incident record from the screen
data: The webpy data object containing form parameters
"""
l = dbo.locale
acid = post.integer("id")
if not db.check_recordversion(dbo, "animalcontrol", post.integer("id"), post.integer("recordversion")):
raise utils.ASMValidationError(_("This record has been changed by another user, please reload.", l))
if post.date("incidentdate") is None:
raise utils.ASMValidationError(_("Incident date cannot be blank", l))
preaudit = db.query(dbo, "SELECT * FROM animalcontrol WHERE ID = %d" % acid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalcontrol", username, "ID=%d" % acid, (
( "IncidentDateTime", post.db_datetime("incidentdate", "incidenttime")),
( "IncidentTypeID", post.db_integer("incidenttype")),
( "CallDateTime", post.db_datetime("calldate", "calltime")),
( "CallNotes", post.db_string("callnotes")),
( "CallTaker", post.db_string("calltaker")),
( "CallerID", post.db_integer("caller")),
( "VictimID", post.db_integer("victim")),
( "DispatchAddress", post.db_string("dispatchaddress")),
( "DispatchTown", post.db_string("dispatchtown")),
( "DispatchCounty", post.db_string("dispatchcounty")),
( "DispatchPostcode", post.db_string("dispatchpostcode")),
( "PickupLocationID", post.db_integer("pickuplocation")),
( "DispatchLatLong", post.db_string("dispatchlatlong")),
( "DispatchedACO", post.db_string("dispatchedaco")),
( "DispatchDateTime", post.db_datetime("dispatchdate", "dispatchtime")),
( "RespondedDateTime", post.db_datetime("respondeddate", "respondedtime")),
( "FollowupDateTime", post.db_datetime("followupdate", "followuptime")),
( "FollowupComplete", post.db_boolean("followupcomplete")),
( "FollowupDateTime2", post.db_datetime("followupdate2", "followuptime2")),
( "FollowupComplete2", post.db_boolean("followupcomplete2")),
( "FollowupDateTime3", post.db_datetime("followupdate3", "followuptime3")),
( "FollowupComplete3", post.db_boolean("followupcomplete3")),
( "CompletedDate", post.db_date("completeddate")),
( "IncidentCompletedID", post.db_integer("completedtype")),
( "OwnerID", post.db_integer("owner")),
( "Owner2ID", post.db_integer("owner2")),
( "Owner3ID", post.db_integer("owner3")),
( "AnimalDescription", post.db_string("animaldescription")),
( "SpeciesID", post.db_integer("species")),
( "Sex", post.db_integer("sex")),
( "AgeGroup", post.db_string("agegroup"))
)))
additional.save_values_for_link(dbo, post, acid, "incident")
postaudit = db.query(dbo, "SELECT * FROM animalcontrol WHERE ID = %d" % acid)
audit.edit(dbo, username, "animalcontrol", acid, audit.map_diff(preaudit, postaudit))
def update_investigation_from_form(dbo, username, data):
"""
Updates an investigation record from posted form data
"""
l = dbo.locale
investigationid = utils.df_ki(data, "investigationid")
sql = db.make_update_user_sql(dbo, "ownerinvestigation", username, "ID=%d" % investigationid, (
( "Date", utils.df_d(data, "date", l)),
( "Notes", utils.df_t(data, "notes"))
))
preaudit = db.query(dbo, "SELECT * FROM ownerinvestigation WHERE ID = %d" % investigationid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM ownerinvestigation WHERE ID = %d" % investigationid)
audit.edit(dbo, username, "ownerinvestigation", audit.map_diff(preaudit, postaudit))
def update_account_from_form(dbo, username, post):
"""
Updates an account from posted form data
"""
l = dbo.locale
accountid = post.integer("accountid")
if post["code"] == "":
raise utils.ASMValidationError(
i18n._("Account code cannot be blank.", l))
if 0 != db.query_int(
dbo,
"SELECT COUNT(*) FROM accounts WHERE Code Like '%s' AND ID <> %d" %
(post["code"], accountid)):
raise utils.ASMValidationError(
i18n._("Account code '{0}' has already been used.",
l).format(post["code"]))
sql = db.make_update_user_sql(
dbo, "accounts", username, "ID=%d" % accountid,
(("Code", post.db_string("code")),
("AccountType", post.db_integer("type")),
("DonationTypeID", post.db_integer("donationtype")),
("Description", post.db_string("description"))))
preaudit = db.query(dbo,
"SELECT * FROM accounts WHERE ID = %d" % accountid)
db.execute(dbo, sql)
postaudit = db.query(dbo,
"SELECT * FROM accounts WHERE ID = %d" % accountid)
audit.edit(dbo, username, "accounts", audit.map_diff(preaudit, postaudit))
db.execute(dbo,
"DELETE FROM accountsrole WHERE AccountID = %d" % accountid)
for rid in post.integer_list("viewroles"):
db.execute(
dbo,
"INSERT INTO accountsrole (AccountID, RoleID, CanView, CanEdit) VALUES (%d, %d, 1, 0)"
% (accountid, rid))
for rid in post.integer_list("editroles"):
if rid in post.integer_list("viewroles"):
db.execute(
dbo,
"UPDATE accountsrole SET CanEdit = 1 WHERE AccountID = %d AND RoleID = %d"
% (accountid, rid))
else:
db.execute(
dbo,
"INSERT INTO accountsrole (AccountID, RoleID, CanView, CanEdit) VALUES (%d, %d, 0, 1)"
% (accountid, rid))
def update_treatment_today(dbo, username, amtid):
"""
Marks a treatment record as given today.
"""
amid = db.query_int(dbo, "SELECT AnimalMedicalID FROM animalmedicaltreatment WHERE ID = %d" % amtid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalmedicaltreatment", username, "ID = %d" % amtid, (
( "DateGiven", db.dd(now(dbo.timezone)) ),
( "GivenBy", db.ds(username))
)))
audit.edit(dbo, username, "animalmedicaltreatment", "%d => given" % amtid)
# Update number of treatments given and remaining
calculate_given_remaining(dbo, amid)
# Generate next treatments in sequence or complete the
# medical record appropriately
update_medical_treatments(dbo, username, amid)
def update_voucher_from_form(dbo, username, data):
"""
Updates a voucher record from posted form data
"""
l = dbo.locale
voucherid = utils.df_ki(data, "voucherid")
sql = db.make_update_user_sql(dbo, "ownervoucher", username, "ID=%d" % voucherid, (
( "VoucherID", utils.df_s(data, "type")),
( "DateIssued", utils.df_d(data, "issued", l)),
( "DateExpired", utils.df_d(data, "expires", l)),
( "Value", utils.df_m(data, "amount", l)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM ownervoucher WHERE ID = %d" % voucherid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM ownervoucher WHERE ID = %d" % voucherid)
audit.edit(dbo, username, "ownervoucher", audit.map_diff(preaudit, postaudit))
def update_log_from_form(dbo, username, data):
"""
Updates a log from form data
"""
l = dbo.locale
logid = utils.df_ki(data, "logid")
if utils.df_kd(data, "logdate", l) is None:
raise utils.ASMValidationError(i18n._("Log date must be a valid date", l))
sql = db.make_update_user_sql(dbo, "log", username, "ID=%d" % logid, (
( "LogTypeID", utils.df_s(data, "type")),
( "Date", utils.df_d(data, "logdate", l) ),
( "Comments", utils.df_t(data, "entry") )
))
preaudit = db.query(dbo, "SELECT * FROM log WHERE ID=%d" % logid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM log WHERE ID=%d" % logid)
audit.edit(dbo, username, "log", audit.map_diff(preaudit, postaudit))
def update_treatment_given(dbo, username, amtid, newdate):
"""
Marks a treatment record as given on newdate, assuming
that newdate is valid.
"""
amid = db.query_int(dbo, "SELECT AnimalMedicalID FROM animalmedicaltreatment WHERE ID = %d" % amtid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalmedicaltreatment", username, "ID = %d" % amtid, (
( "DateGiven", db.dd(newdate) ),
( "GivenBy", db.ds(username))
)))
audit.edit(dbo, username, "animalmedicaltreatment", "%d given => %s" % (amtid, str(newdate)))
# Update number of treatments given and remaining
calculate_given_remaining(dbo, amid)
# Generate next treatments in sequence or complete the
# medical record appropriately
update_medical_treatments(dbo, username, amid)
def update_profile_from_form(dbo, username, data):
"""
Updates a profile record from posted form data
"""
l = dbo.locale
profileid = utils.df_ki(data, "profileid")
if utils.df_ks(data, "treatmentname") == "":
raise utils.ASMValidationError(_("Treatment name cannot be blank", l))
if utils.df_ks(data, "profilename") == "":
raise utils.ASMValidationError(_("Profile name cannot be blank", l))
timingrule = utils.df_ki(data, "timingrule")
timingrulenofrequencies = utils.df_ki(data, "timingrulenofrequencies")
timingrulefrequency = utils.df_ki(data, "timingrulefrequency")
totalnumberoftreatments = utils.df_ki(data, "totalnumberoftreatments")
treatmentrule = utils.df_ki(data, "treatmentrule")
singlemulti = utils.df_ki(data, "singlemulti")
if singlemulti == 0:
timingrule = 0
timingrulenofrequencies = 0
timingrulefrequency = 0
if treatmentrule != 0:
totalnumberoftreatments = 0
sql = db.make_update_user_sql(
dbo, "medicalprofile", username, "ID=%d" % profileid,
(("ProfileName", utils.df_t(data, "profilename")),
("TreatmentName", utils.df_t(data, "treatmentname")),
("Dosage", utils.df_t(data, "dosage")),
("Cost", utils.df_m(data, "cost", l)),
("TimingRule", db.di(timingrule)),
("TimingRuleFrequency", db.di(timingrulefrequency)),
("TimingRuleNoFrequencies", db.di(timingrulenofrequencies)),
("TreatmentRule", utils.df_s(data, "treatmentrule")),
("TotalNumberOfTreatments", db.di(totalnumberoftreatments)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(dbo,
"SELECT * FROM medicalprofile WHERE ID=%d" % profileid)
db.execute(dbo, sql)
postaudit = db.query(
dbo, "SELECT * FROM medicalprofile WHERE ID=%d" % profileid)
audit.edit(
dbo, username, "medicalprofile",
audit.map_diff(preaudit, postaudit, ["TREATMENTNAME", "DOSAGE"]))
def update_investigation_from_form(dbo, username, data):
"""
Updates an investigation record from posted form data
"""
l = dbo.locale
investigationid = utils.df_ki(data, "investigationid")
sql = db.make_update_user_sql(dbo, "ownerinvestigation", username,
"ID=%d" % investigationid,
(("Date", utils.df_d(data, "date", l)),
("Notes", utils.df_t(data, "notes"))))
preaudit = db.query(
dbo,
"SELECT * FROM ownerinvestigation WHERE ID = %d" % investigationid)
db.execute(dbo, sql)
postaudit = db.query(
dbo,
"SELECT * FROM ownerinvestigation WHERE ID = %d" % investigationid)
audit.edit(dbo, username, "ownerinvestigation",
audit.map_diff(preaudit, postaudit))
def update_voucher_from_form(dbo, username, data):
"""
Updates a voucher record from posted form data
"""
l = dbo.locale
voucherid = utils.df_ki(data, "voucherid")
sql = db.make_update_user_sql(
dbo, "ownervoucher", username, "ID=%d" % voucherid,
(("VoucherID", utils.df_s(data, "type")),
("DateIssued", utils.df_d(data, "issued", l)),
("DateExpired", utils.df_d(data, "expires", l)),
("Value", utils.df_m(data, "amount", l)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(dbo,
"SELECT * FROM ownervoucher WHERE ID = %d" % voucherid)
db.execute(dbo, sql)
postaudit = db.query(
dbo, "SELECT * FROM ownervoucher WHERE ID = %d" % voucherid)
audit.edit(dbo, username, "ownervoucher",
audit.map_diff(preaudit, postaudit))
def update_traploan_from_form(dbo, username, post):
"""
Updates a traploan record from posted form data
"""
traploanid = post.integer("traploanid")
sql = db.make_update_user_sql(dbo, "ownertraploan", username, "ID=%d" % traploanid, (
( "OwnerID", post.db_integer("person")),
( "TrapTypeID", post.db_integer("type")),
( "LoanDate", post.db_date("loandate")),
( "DepositAmount", post.db_integer("depositamount")),
( "DepositReturnDate", post.db_date("depositreturndate")),
( "TrapNumber", post.db_string("trapnumber")),
( "ReturnDueDate", post.db_date("returnduedate")),
( "ReturnDate", post.db_date("returndate")),
( "Comments", post.db_string("comments"))
))
preaudit = db.query(dbo, "SELECT * FROM ownertraploan WHERE ID = %d" % traploanid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM ownertraploan WHERE ID = %d" % traploanid)
audit.edit(dbo, username, "ownertraploan", traploanid, audit.map_diff(preaudit, postaudit))
def update_vaccination_from_form(dbo, username, data):
"""
Updates a vaccination record from posted form data
"""
l = dbo.locale
vaccid = utils.df_ki(data, "vaccid")
if utils.df_kd(data, "required", l) is None:
raise utils.ASMValidationError(_("Required date must be a valid date", l))
sql = db.make_update_user_sql(dbo, "animalvaccination", username, "ID=%d" % vaccid, (
( "AnimalID", db.di(utils.df_ki(data, "animal"))),
( "VaccinationID", utils.df_s(data, "type")),
( "DateOfVaccination", utils.df_d(data, "given", l)),
( "DateRequired", utils.df_d(data, "required", l)),
( "Cost", utils.df_m(data, "cost", l)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM animalvaccination WHERE ID = %d" % vaccid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM animalvaccination WHERE ID = %d" % vaccid)
audit.edit(dbo, username, "animalvaccination", audit.map_diff(preaudit, postaudit))
def update_regimen_from_form(dbo, username, data):
"""
Updates a regimen record from posted form data
"""
l = dbo.locale
regimenid = utils.df_ki(data, "regimenid")
if utils.df_ks(data, "treatmentname") == "":
raise utils.ASMValidationError(_("Treatment name cannot be blank", l))
sql = db.make_update_user_sql(dbo, "animalmedical", username, "ID=%d" % regimenid, (
( "TreatmentName", utils.df_t(data, "treatmentname")),
( "Dosage", utils.df_t(data, "dosage")),
( "Status", utils.df_s(data, "status")),
( "Cost", utils.df_m(data, "cost", l)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM animalmedical WHERE ID=%d" % regimenid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM animalmedical WHERE ID=%d" % regimenid)
audit.edit(dbo, username, "animalmedical", audit.map_diff(preaudit, postaudit, [ "TREATMENTNAME", "DOSAGE" ]))
update_medical_treatments(dbo, username, utils.df_ki(data, "regimenid"))
def update_waitinglist_from_form(dbo, data, username):
"""
Updates a waiting list record from the screen
data: The webpy data object containing form parameters
"""
l = dbo.locale
wlid = utils.df_ki(data, "id")
if utils.df_ks(data, "description") == "":
raise utils.ASMValidationError(_("Description cannot be blank", l))
if utils.df_ki(data, "owner") == "0":
raise utils.ASMValidationError(
_("Waiting list entries must have a contact", l))
if utils.df_ks(data, "dateputon") == "":
raise utils.ASMValidationError(_("Date put on cannot be blank", l))
preaudit = db.query(dbo,
"SELECT * FROM animalwaitinglist WHERE ID = %d" % wlid)
db.execute(
dbo,
db.make_update_user_sql(
dbo, "animalwaitinglist", username, "ID=%d" % wlid,
(("SpeciesID", utils.df_s(data, "species")),
("DatePutOnList", utils.df_d(data, "dateputon", l)),
("OwnerID", utils.df_s(data, "owner")),
("AnimalDescription", utils.df_t(data, "description")),
("ReasonForWantingToPart",
utils.df_t(data, "reasonforwantingtopart")),
("CanAffordDonation", utils.df_c(data, "canafforddonation")),
("Urgency", utils.df_s(data, "urgency")),
("DateRemovedFromList", utils.df_d(data, "dateremoved", l)),
("AutoRemovePolicy", utils.df_s(data, "autoremovepolicy")),
("DateOfLastOwnerContact",
utils.df_d(data, "dateoflastownercontact", l)),
("ReasonForRemoval", utils.df_t(data, "reasonforremoval")),
("Comments", utils.df_t(data, "comments")))))
additional.save_values_for_link(dbo, data, wlid, "waitinglist")
postaudit = db.query(
dbo, "SELECT * FROM animalwaitinglist WHERE ID = %d" % wlid)
audit.edit(dbo, username, "animalwaitinglist",
audit.map_diff(preaudit, postaudit))
def update_profile_from_form(dbo, username, data):
"""
Updates a profile record from posted form data
"""
l = dbo.locale
profileid = utils.df_ki(data, "profileid")
if utils.df_ks(data, "treatmentname") == "":
raise utils.ASMValidationError(_("Treatment name cannot be blank", l))
if utils.df_ks(data, "profilename") == "":
raise utils.ASMValidationError(_("Profile name cannot be blank", l))
timingrule = utils.df_ki(data, "timingrule")
timingrulenofrequencies = utils.df_ki(data, "timingrulenofrequencies")
timingrulefrequency = utils.df_ki(data, "timingrulefrequency")
totalnumberoftreatments = utils.df_ki(data, "totalnumberoftreatments")
treatmentrule = utils.df_ki(data, "treatmentrule")
singlemulti = utils.df_ki(data, "singlemulti")
if singlemulti == 0:
timingrule = 0
timingrulenofrequencies = 0
timingrulefrequency = 0
if treatmentrule != 0:
totalnumberoftreatments = 0
sql = db.make_update_user_sql(dbo, "medicalprofile", username, "ID=%d" % profileid, (
( "ProfileName", utils.df_t(data, "profilename")),
( "TreatmentName", utils.df_t(data, "treatmentname")),
( "Dosage", utils.df_t(data, "dosage")),
( "Cost", utils.df_m(data, "cost", l)),
( "TimingRule", db.di(timingrule)),
( "TimingRuleFrequency", db.di(timingrulefrequency)),
( "TimingRuleNoFrequencies", db.di(timingrulenofrequencies)),
( "TreatmentRule", utils.df_s(data, "treatmentrule")),
( "TotalNumberOfTreatments", db.di(totalnumberoftreatments)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM medicalprofile WHERE ID=%d" % profileid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM medicalprofile WHERE ID=%d" % profileid)
audit.edit(dbo, username, "medicalprofile", audit.map_diff(preaudit, postaudit, [ "TREATMENTNAME", "DOSAGE" ]))
def update_treatment_today(dbo, username, amtid):
"""
Marks a treatment record as given today.
"""
amid = db.query_int(
dbo,
"SELECT AnimalMedicalID FROM animalmedicaltreatment WHERE ID = %d" %
amtid)
db.execute(
dbo,
db.make_update_user_sql(dbo, "animalmedicaltreatment", username,
"ID = %d" % amtid,
(("DateGiven", db.dd(now(dbo.timezone))),
("GivenBy", db.ds(username)))))
audit.edit(dbo, username, "animalmedicaltreatment", "%d => given" % amtid)
# Update number of treatments given and remaining
calculate_given_remaining(dbo, amid)
# Generate next treatments in sequence or complete the
# medical record appropriately
update_medical_treatments(dbo, username, amid)
def update_movement_from_form(dbo, username, data):
"""
Updates a movement record from posted form data
"""
validate_movement_form_data(dbo, data)
l = dbo.locale
movementid = utils.df_ki(data, "movementid")
sql = db.make_update_user_sql(
dbo, "adoption", username, "ID=%d" % movementid,
(("AdoptionNumber", utils.df_t(data, "adoptionno")),
("OwnerID", db.di(utils.df_ki(data, "person"))),
("RetailerID", db.di(utils.df_ki(data, "retailer"))),
("AnimalID", db.di(utils.df_ki(data, "animal"))),
("OriginalRetailerMovementID",
db.di(utils.df_ki(data, "originalretailermovement"))),
("MovementDate", utils.df_d(data, "movementdate", l)),
("MovementType", utils.df_s(data, "type")),
("ReturnDate", utils.df_d(data, "returndate", l)),
("ReturnedReasonID", utils.df_s(data, "returncategory")),
("Donation", utils.df_m(data, "donation", l)),
("InsuranceNumber", utils.df_t(data, "insurance")),
("ReasonForReturn", utils.df_t(data, "reason")),
("ReservationDate", utils.df_d(data, "reservationdate", l)),
("ReservationCancelledDate",
utils.df_d(data, "reservationcancelled",
l)), ("IsTrial", utils.df_c(data, "trial")),
("IsPermanentFoster", utils.df_c(data, "permanentfoster")),
("TrialEndDate", utils.df_d(data, "trialenddate", l)),
("Comments", utils.df_t(data, "comments"))))
preaudit = db.query(dbo,
"SELECT * FROM adoption WHERE ID = %d" % movementid)
db.execute(dbo, sql)
postaudit = db.query(dbo,
"SELECT * FROM adoption WHERE ID = %d" % movementid)
audit.edit(dbo, username, "adoption", audit.map_diff(preaudit, postaudit))
animal.update_animal_status(dbo, utils.df_ki(data, "animal"))
animal.update_variable_animal_data(dbo, utils.df_ki(data, "animal"))
update_movement_donation(dbo, movementid)
def update_trx_from_form(dbo, username, post):
"""
Updates a transaction from posted form data
"""
l = dbo.locale
amount = 0
source = 0
target = 0
deposit = post.money("deposit")
withdrawal = post.money("withdrawal")
account = post.integer("accountid")
trxid = post.integer("trxid")
other = get_account_id(dbo, post["otheraccount"])
if other == 0:
raise utils.ASMValidationError(
i18n._("Account code '{0}' is not valid.",
l).format(post["otheraccount"]))
if deposit > 0:
amount = deposit
source = other
target = account
else:
amount = withdrawal
source = account
target = other
sql = db.make_update_user_sql(
dbo, "accountstrx", username, "ID=%d" % trxid,
(("TrxDate", post.db_date("trxdate")),
("Description", post.db_string("description")),
("Reconciled", post.db_integer("reconciled")),
("Amount", db.di(amount)), ("SourceAccountID", db.di(source)),
("DestinationAccountID", db.di(target))))
preaudit = db.query(dbo, "SELECT * FROM accountstrx WHERE ID = %d" % trxid)
db.execute(dbo, sql)
postaudit = db.query(dbo,
"SELECT * FROM accountstrx WHERE ID = %d" % trxid)
audit.edit(dbo, username, "accountstrx",
audit.map_diff(preaudit, postaudit))
def update_traploan_from_form(dbo, username, post):
"""
Updates a traploan record from posted form data
"""
traploanid = post.integer("traploanid")
sql = db.make_update_user_sql(
dbo, "ownertraploan", username, "ID=%d" % traploanid,
(("OwnerID", post.db_integer("person")),
("TrapTypeID", post.db_integer("type")),
("LoanDate", post.db_date("loandate")),
("DepositAmount", post.db_integer("depositamount")),
("DepositReturnDate", post.db_date("depositreturndate")),
("TrapNumber", post.db_string("trapnumber")),
("ReturnDueDate", post.db_date("returnduedate")),
("ReturnDate", post.db_date("returndate")),
("Comments", post.db_string("comments"))))
preaudit = db.query(
dbo, "SELECT * FROM ownertraploan WHERE ID = %d" % traploanid)
db.execute(dbo, sql)
postaudit = db.query(
dbo, "SELECT * FROM ownertraploan WHERE ID = %d" % traploanid)
audit.edit(dbo, username, "ownertraploan",
audit.map_diff(preaudit, postaudit))
def update_foundanimal_from_form(dbo, post, username):
"""
Updates a found animal record from the screen
post: The webpy data object containing form parameters
"""
l = dbo.locale
lfid = post.integer("id")
if not db.check_recordversion(dbo, "animalfound", post.integer("id"), post.integer("recordversion")):
raise utils.ASMValidationError(_("This record has been changed by another user, please reload.", l))
if post.date("datefound") is None:
raise utils.ASMValidationError(_("Date found cannot be blank", l))
if post.date("datereported") is None:
raise utils.ASMValidationError(_("Date reported cannot be blank", l))
if post.integer("owner") == 0:
raise utils.ASMValidationError(_("Found animals must have a contact", l))
preaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
db.execute(dbo, db.make_update_user_sql(dbo, "animalfound", username, "ID=%d" % lfid, (
( "AnimalTypeID", post.db_integer("species")),
( "DateReported", post.db_date("datereported")),
( "ReturnToOwnerDate", post.db_date("returntoownerdate")),
( "DateFound", post.db_date("datefound")),
( "Sex", post.db_integer("sex")),
( "BreedID", post.db_integer("breed")),
( "AgeGroup", post.db_string("agegroup")),
( "BaseColourID", post.db_integer("colour")),
( "DistFeat", post.db_string("markings")),
( "AreaFound", post.db_string("areafound")),
( "AreaPostcode", post.db_string("areapostcode")),
( "OwnerID", post.db_integer("owner")),
( "Comments", post.db_string("comments"))
)))
additional.save_values_for_link(dbo, post, lfid, "foundanimal")
postaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
audit.edit(dbo, username, "animalfound", lfid, audit.map_diff(preaudit, postaudit))
def update_foundanimal_from_form(dbo, post, username):
"""
Updates a found animal record from the screen
post: The webpy data object containing form parameters
"""
l = dbo.locale
lfid = post.integer("id")
if post.date("datefound") is None:
raise utils.ASMValidationError(_("Date found cannot be blank", l))
if post.date("datereported") is None:
raise utils.ASMValidationError(_("Date reported cannot be blank", l))
if post.integer("owner") == 0:
raise utils.ASMValidationError(
_("Found animals must have a contact", l))
preaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
db.execute(
dbo,
db.make_update_user_sql(
dbo, "animalfound", username, "ID=%d" % lfid,
(("AnimalTypeID", post.db_integer("species")),
("DateReported", post.db_date("datereported")),
("ReturnToOwnerDate", post.db_date("returntoownerdate")),
("DateFound", post.db_date("datefound")),
("Sex", post.db_integer("sex")),
("BreedID", post.db_integer("breed")),
("AgeGroup", post.db_string("agegroup")),
("BaseColourID", post.db_integer("colour")),
("DistFeat", post.db_string("markings")),
("AreaFound", post.db_string("areafound")),
("AreaPostcode", post.db_string("areapostcode")),
("OwnerID", post.db_integer("owner")),
("Comments", post.db_string("comments")))))
additional.save_values_for_link(dbo, post, lfid, "foundanimal")
postaudit = db.query(dbo, "SELECT * FROM animalfound WHERE ID = %d" % lfid)
audit.edit(dbo, username, "animalfound",
audit.map_diff(preaudit, postaudit))
def update_treatment_given(dbo, username, amtid, newdate):
"""
Marks a treatment record as given on newdate, assuming
that newdate is valid.
"""
amid = db.query_int(
dbo,
"SELECT AnimalMedicalID FROM animalmedicaltreatment WHERE ID = %d" %
amtid)
db.execute(
dbo,
db.make_update_user_sql(dbo, "animalmedicaltreatment", username,
"ID = %d" % amtid,
(("DateGiven", db.dd(newdate)),
("GivenBy", db.ds(username)))))
audit.edit(dbo, username, "animalmedicaltreatment",
"%d given => %s" % (amtid, str(newdate)))
# Update number of treatments given and remaining
calculate_given_remaining(dbo, amid)
# Generate next treatments in sequence or complete the
# medical record appropriately
update_medical_treatments(dbo, username, amid)
def update_test_from_form(dbo, username, data):
"""
Updates a test record from posted form data
"""
l = dbo.locale
testid = utils.df_ki(data, "testid")
if utils.df_kd(data, "required", l) is None:
raise utils.ASMValidationError(_("Required date must be a valid date", l))
sql = db.make_update_user_sql(dbo, "animaltest", username, "ID=%d" % testid, (
( "AnimalID", db.di(utils.df_ki(data, "animal"))),
( "TestTypeID", utils.df_s(data, "type")),
( "TestResultID", utils.df_s(data, "result")),
( "DateOfTest", utils.df_d(data, "given", l)),
( "DateRequired", utils.df_d(data, "required", l)),
( "Cost", utils.df_m(data, "cost", l)),
( "Comments", utils.df_t(data, "comments"))
))
preaudit = db.query(dbo, "SELECT * FROM animaltest WHERE ID = %d" % testid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM animaltest WHERE ID = %d" % testid)
audit.edit(dbo, username, "animaltest", audit.map_diff(preaudit, postaudit))
# ASM2_COMPATIBILITY
update_asm2_tests(dbo, testid)
def update_person_from_form(dbo, data, username):
"""
Updates an existing person record from incoming form data
data: The webpy data object containing form parameters
"""
l = dbo.locale
pid = utils.df_ki(data, "id")
flags = utils.df_ks(data, "flags").split(",")
def bi(b):
return b and 1 or 0
homechecked = bi("homechecked" in flags)
banned = bi("banned" in flags)
volunteer = bi("volunteer" in flags)
member = bi("member" in flags)
homechecker = bi("homechecker" in flags)
donor = bi("donor" in flags)
shelter = bi("shelter" in flags)
aco = bi("aco" in flags)
staff = bi("staff" in flags)
fosterer = bi("fosterer" in flags)
retailer = bi("retailer" in flags)
vet = bi("vet" in flags)
giftaid = bi("giftaid" in flags)
flagstr = "|".join(flags) + "|"
sql = db.make_update_user_sql(
dbo, "owner", username, "ID=%d" % pid,
(("OwnerName",
db.ds("%s %s %s" %
(utils.df_ks(data, "title"), utils.df_ks(
data, "forenames"), utils.df_ks(data, "surname")))),
("OwnerTitle", utils.df_t(data, "title")),
("OwnerInitials", utils.df_t(data, "initials")),
("OwnerForenames", utils.df_t(data, "forenames")),
("OwnerSurname", utils.df_t(data, "surname")),
("OwnerAddress", utils.df_t(data, "address")),
("OwnerTown", utils.df_t(data, "town")),
("OwnerCounty", utils.df_t(data, "county")),
("OwnerPostcode", utils.df_t(data, "postcode")),
("LatLong", utils.df_t(data, "latlong")),
("HomeTelephone", utils.df_t(data, "hometelephone")),
("WorkTelephone", utils.df_t(data, "worktelephone")),
("MobileTelephone", utils.df_t(data, "mobiletelephone")),
("EmailAddress", utils.df_t(
data, "email")), ("IDCheck", db.di(homechecked)),
("Comments", utils.df_t(data,
"comments")), ("IsBanned", db.di(banned)),
("IsVolunteer", db.di(volunteer)), ("IsMember", db.di(member)),
("MembershipExpiryDate", utils.df_d(data, "membershipexpires", l)),
("MembershipNumber", utils.df_t(data, "membershipnumber")),
("IsHomeChecker", db.di(homechecker)), ("IsDonor", db.di(donor)),
("IsShelter", db.di(shelter)), ("IsACO", db.di(aco)),
("IsStaff", db.di(staff)), ("IsFosterer", db.di(fosterer)),
("IsRetailer", db.di(retailer)), ("IsVet", db.di(vet)),
("IsGiftAid", db.di(giftaid)), ("AdditionalFlags", db.ds(flagstr)),
("HomeCheckAreas", utils.df_t(data, "areas")),
("DateLastHomeChecked", utils.df_d(data, "homechecked", l)),
("HomeCheckedBy", utils.df_s(data, "homecheckedby")),
("MatchActive", utils.df_s(data, "matchactive")),
("MatchAdded", utils.df_d(data, "matchadded", l)),
("MatchExpires", utils.df_d(data, "matchexpires", l)),
("MatchSex", utils.df_s(
data, "matchsex")), ("MatchSize", utils.df_s(data, "matchsize")),
("MatchColour", utils.df_s(data, "matchcolour")),
("MatchAgeFrom", utils.df_s(data, "agedfrom")),
("MatchAgeTo", utils.df_s(
data, "agedto")), ("MatchAnimalType", utils.df_s(
data, "matchtype")), ("MatchSpecies",
utils.df_s(data, "matchspecies")),
("MatchBreed", utils.df_s(
data,
"matchbreed1")), ("MatchBreed2", utils.df_s(data, "matchbreed2")),
("MatchGoodWithCats", utils.df_s(data, "matchgoodwithcats")),
("MatchGoodWithDogs", utils.df_s(data, "matchgoodwithdogs")),
("MatchGoodWithChildren", utils.df_s(data, "matchgoodwithchildren")),
("MatchHouseTrained", utils.df_s(data, "matchhousetrained")),
("MatchCommentsContain", utils.df_t(data, "commentscontain"))))
preaudit = db.query(dbo, "SELECT * FROM owner WHERE ID=%d" % pid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM owner WHERE ID=%d" % pid)
audit.edit(dbo, username, "owner",
audit.map_diff(preaudit, postaudit, [
"OWNERNAME",
]))
# Save any additional field values given
additional.save_values_for_link(dbo, data, pid, "person")
def update_person_from_form(dbo, data, username):
"""
Updates an existing person record from incoming form data
data: The webpy data object containing form parameters
"""
l = dbo.locale
pid = utils.df_ki(data, "id")
flags = utils.df_ks(data, "flags").split(",")
def bi(b): return b and 1 or 0
homechecked = bi("homechecked" in flags)
banned = bi("banned" in flags)
volunteer = bi("volunteer" in flags)
member = bi("member" in flags)
homechecker = bi("homechecker" in flags)
donor = bi("donor" in flags)
shelter = bi("shelter" in flags)
aco = bi("aco" in flags)
staff = bi("staff" in flags)
fosterer = bi("fosterer" in flags)
retailer = bi("retailer" in flags)
vet = bi("vet" in flags)
giftaid = bi("giftaid" in flags)
flagstr = "|".join(flags) + "|"
sql = db.make_update_user_sql(dbo, "owner", username, "ID=%d" % pid, (
( "OwnerName", db.ds("%s %s %s" % ( utils.df_ks(data, "title"), utils.df_ks(data, "forenames"), utils.df_ks(data, "surname") ))),
( "OwnerTitle", utils.df_t(data, "title")),
( "OwnerInitials", utils.df_t(data, "initials")),
( "OwnerForenames", utils.df_t(data, "forenames")),
( "OwnerSurname", utils.df_t(data, "surname")),
( "OwnerAddress", utils.df_t(data, "address")),
( "OwnerTown", utils.df_t(data, "town")),
( "OwnerCounty", utils.df_t(data, "county")),
( "OwnerPostcode", utils.df_t(data, "postcode")),
( "LatLong", utils.df_t(data, "latlong")),
( "HomeTelephone", utils.df_t(data, "hometelephone")),
( "WorkTelephone", utils.df_t(data, "worktelephone")),
( "MobileTelephone", utils.df_t(data, "mobiletelephone")),
( "EmailAddress", utils.df_t(data, "email")),
( "IDCheck", db.di(homechecked) ),
( "Comments", utils.df_t(data, "comments")),
( "IsBanned", db.di(banned)),
( "IsVolunteer", db.di(volunteer)),
( "IsMember", db.di(member)),
( "MembershipExpiryDate", utils.df_d(data, "membershipexpires", l)),
( "MembershipNumber", utils.df_t(data, "membershipnumber")),
( "IsHomeChecker", db.di(homechecker)),
( "IsDonor", db.di(donor)),
( "IsShelter", db.di(shelter)),
( "IsACO", db.di(aco)),
( "IsStaff", db.di(staff)),
( "IsFosterer", db.di(fosterer)),
( "IsRetailer", db.di(retailer)),
( "IsVet", db.di(vet)),
( "IsGiftAid", db.di(giftaid)),
( "AdditionalFlags", db.ds(flagstr)),
( "HomeCheckAreas", utils.df_t(data, "areas")),
( "DateLastHomeChecked", utils.df_d(data, "homechecked", l)),
( "HomeCheckedBy", utils.df_s(data, "homecheckedby")),
( "MatchActive", utils.df_s(data, "matchactive")),
( "MatchAdded", utils.df_d(data, "matchadded", l)),
( "MatchExpires", utils.df_d(data, "matchexpires", l)),
( "MatchSex", utils.df_s(data, "matchsex")),
( "MatchSize", utils.df_s(data, "matchsize")),
( "MatchColour", utils.df_s(data, "matchcolour")),
( "MatchAgeFrom", utils.df_s(data, "agedfrom")),
( "MatchAgeTo", utils.df_s(data, "agedto")),
( "MatchAnimalType", utils.df_s(data, "matchtype")),
( "MatchSpecies", utils.df_s(data, "matchspecies")),
( "MatchBreed", utils.df_s(data, "matchbreed1")),
( "MatchBreed2", utils.df_s(data, "matchbreed2")),
( "MatchGoodWithCats", utils.df_s(data, "matchgoodwithcats")),
( "MatchGoodWithDogs", utils.df_s(data, "matchgoodwithdogs")),
( "MatchGoodWithChildren", utils.df_s(data, "matchgoodwithchildren")),
( "MatchHouseTrained", utils.df_s(data, "matchhousetrained")),
( "MatchCommentsContain", utils.df_t(data, "commentscontain"))
))
preaudit = db.query(dbo, "SELECT * FROM owner WHERE ID=%d" % pid)
db.execute(dbo, sql)
postaudit = db.query(dbo, "SELECT * FROM owner WHERE ID=%d" % pid)
audit.edit(dbo, username, "owner", audit.map_diff(preaudit, postaudit, [ "OWNERNAME", ]))
# Save any additional field values given
additional.save_values_for_link(dbo, data, pid, "person")
