search

Capping-CPCA / Database

all code dealing with the database for this application environment
0 stars 1 forks source link

Update Statements for Forms #120

Closed sbohner14335 closed 7 years ago

sbohner14335 commented 7 years ago

Could you guys write us update statements for all fields in our forms (for the edit feature), so this way we don't have to spend the time writing the statements ourselves and can copy and paste some code?

jrands commented 7 years ago 
UPDATE 
SelfReferral
SET 
referralSource = newReferralSource,
hasInvolvementCPS = newHasInvolvementCPS,
hasAttendedPEP = newHasAttendedPEP,
reasonAttendingPEP = newReasonAttendingPEP,
dateFirstCall = newDateFirstCall,
returnClientCallDate = newReturnClientCallDate,
tentativeStartDate = newTentativeStartDate,
classAssignedTo = newClassAssignedTo,
introLetterMailedDate = newIntroLetterMailedDate,
Notes = newNotes;

Is this what you meant?

sbohner14335 commented 7 years ago

Yes, but could you do those for the Family members, agency referrals, phone numbers, etc?

Also maybe a condition, like WHERE pID = $phpvariable

jrands commented 7 years ago

yep, will do, just wanted to make sure that that's what you wanted

jrands commented 7 years ago

Do we want people to be able to edit their own names?

What about their family members? If I remember correctly Algozzine said we wanted to see the historical data for how their family members changed from form to form so maybe that shouldn't be editable either.

sbohner14335 commented 7 years ago

We can ask him about that on Wednesday, for now just do all of the fields in the forms.

jrands commented 7 years ago

created UPDATES.sql on develop branch, check out commits e155bc55a58932a5652f4304f936510fa3faef69 and 7a17f4fd856fbfa954a1f95423f6af019cc35784

Dr-Crow commented 7 years ago

Merging in 2.2