eq/.git
14 years agolast commit just used tc_presidency.email, changed it to use tc_presidency.email... owenleonard/database_changes
Owen Leonard [Fri, 1 Oct 2010 21:15:46 +0000 (15:15 -0600)]
last commit just used tc_presidency.email, changed it to use tc_presidency.email first, then tc_individual.email

14 years agofixed so that tc_presidency.email trumps tc_individual.email when sending out appt...
Owen Leonard [Fri, 1 Oct 2010 21:04:24 +0000 (15:04 -0600)]
fixed so that tc_presidency.email trumps tc_individual.email when sending out appt invites

14 years agoRemoved all references to mls_id, these were unncessary. github/owenleonard/database_changes
Alan Pippin [Fri, 1 Oct 2010 20:50:38 +0000 (14:50 -0600)]
Removed all references to mls_id, these were unncessary.
Fixed PPI location auto filling with supervisor's address

14 years agoFixed bug in scheduling table for null individual and/or family
Alan Pippin [Fri, 1 Oct 2010 20:22:32 +0000 (14:22 -0600)]
Fixed bug in scheduling table for null individual and/or family

14 years agoMerge branch 'owenleonard/database_changes' of git@github.com:apippin/3rd into owenle...
Alan Pippin [Fri, 1 Oct 2010 20:13:09 +0000 (14:13 -0600)]
Merge branch 'owenleonard/database_changes' of git@github.com:apippin/3rd into owenleonard/database_changes

14 years agoMade the date column a little wider
Alan Pippin [Fri, 1 Oct 2010 20:12:56 +0000 (14:12 -0600)]
Made the date column a little wider

14 years agochanged query from tc_companionship to tc_companion to fix the ht interview scheduling
Owen Leonard [Fri, 1 Oct 2010 20:07:32 +0000 (14:07 -0600)]
changed query from tc_companionship to tc_companion to fix the ht interview scheduling

14 years agoFixed issues with interviews and ppis not being recorded properly.
Alan Pippin [Fri, 1 Oct 2010 18:12:35 +0000 (12:12 -0600)]
Fixed issues with interviews and ppis not being recorded properly.

14 years agofixed issues with updating to newer dataset
Owen Leonard [Fri, 1 Oct 2010 06:40:20 +0000 (00:40 -0600)]
fixed issues with updating to newer dataset

14 years agoadded new tc_companion table, updated tc_companionship table, linked tc_calling table...
Owen Leonard [Thu, 30 Sep 2010 23:49:40 +0000 (17:49 -0600)]
added new tc_companion table, updated tc_companionship table, linked tc_calling table to tc_individual table

14 years agoforgot to remove the lines that empty the tc_visit table - temporary development...
Owen Leonard [Mon, 20 Sep 2010 21:00:16 +0000 (15:00 -0600)]
forgot to remove the lines that empty the tc_visit table - temporary development code

14 years agofixed import of ht stats so it doesn't include last month since that is always No...
Owen Leonard [Mon, 20 Sep 2010 20:58:13 +0000 (14:58 -0600)]
fixed import of ht stats so it doesn't include last month since that is always No for every family

14 years agoAdded "default_stewardship" variable to the tc_config.
Alan Pippin [Mon, 20 Sep 2010 15:05:04 +0000 (09:05 -0600)]
Added "default_stewardship" variable to the tc_config.
Added comments to cross link its value in both config files.
Added missing steward qualifer to a number of queries.

14 years agoAdded the $default_stewardship variable and put it to use
Alan Pippin [Mon, 20 Sep 2010 14:43:44 +0000 (08:43 -0600)]
Added the $default_stewardship variable and put it to use

14 years agoFixed bug in schedule yearly visit table. Bad index being used in vis_notes array.
Alan Pippin [Mon, 20 Sep 2010 14:29:44 +0000 (08:29 -0600)]
Fixed bug in schedule yearly visit table. Bad index being used in vis_notes array.

14 years agoFixed import script so it sets "attending" correctly so that attendance gets prepopul...
Owen Leonard [Mon, 20 Sep 2010 04:39:16 +0000 (22:39 -0600)]
Fixed import script so it sets "attending" correctly so that attendance gets prepopulated.

14 years agoadding some sample csv files to be used for development. They are not complete,...
Owen Leonard [Mon, 20 Sep 2010 04:10:00 +0000 (22:10 -0600)]
adding some sample csv files to be used for development.  They are not complete, just a basic start

14 years agoMerge branch 'owenleonard/database_changes' of git@github.com:apippin/3rd into owenle...
Alan Pippin [Sun, 19 Sep 2010 23:37:57 +0000 (17:37 -0600)]
Merge branch 'owenleonard/database_changes' of git@github.com:apippin/3rd into owenleonard/database_changes

14 years agoMade additional changes to allow the import to work and do the right
Alan Pippin [Sun, 19 Sep 2010 23:33:08 +0000 (17:33 -0600)]
Made additional changes to allow the import to work and do the right
thing with "steward" and "organization" in the absence of the
"Organization class per member.csv" file

14 years agofixed a few more variable rename issues that were breaking some sql queries
Owen Leonard [Sun, 19 Sep 2010 23:28:53 +0000 (17:28 -0600)]
fixed a few more variable rename issues that were breaking some sql queries

14 years agoChanged "Organization class per member.csv" to an optional file to work with older...
Alan Pippin [Sun, 19 Sep 2010 23:17:18 +0000 (17:17 -0600)]
Changed "Organization class per member.csv" to an optional file to work with older dumps

14 years agofound one more place where we reference eq - this is the last one that grep finds
Owen Leonard [Sun, 19 Sep 2010 04:45:25 +0000 (22:45 -0600)]
found one more place where we reference eq - this is the last one that grep finds

14 years agoforgot to make it tc_config - it still said ec_config
Owen Leonard [Sun, 19 Sep 2010 04:42:21 +0000 (22:42 -0600)]
forgot to make it tc_config - it still said ec_config

14 years agothe install instructions say to make changes to the .local files, but this script...
Owen Leonard [Sun, 19 Sep 2010 04:41:00 +0000 (22:41 -0600)]
the install instructions say to make changes to the .local files, but this script checks the originals.  changing to check the .local versions so that we verify the changes

14 years agoremoving upgrade scripts since we're going to redo the version tags and expect people...
Owen Leonard [Sat, 18 Sep 2010 21:01:10 +0000 (15:01 -0600)]
removing upgrade scripts since we're going to redo the version tags and expect people to set up their database from scratch

14 years agoadded cleanup functionality for tc_scheduling_priority during import of new data
Owen Leonard [Sat, 18 Sep 2010 20:47:07 +0000 (14:47 -0600)]
added cleanup functionality for tc_scheduling_priority during import of new data

14 years agoremoved name field from tc_district
Owen Leonard [Sat, 18 Sep 2010 19:42:22 +0000 (13:42 -0600)]
removed name field from tc_district

14 years agoremoved name field from tc_presidency, updated tc.jpg
Owen Leonard [Sat, 18 Sep 2010 19:25:36 +0000 (13:25 -0600)]
removed name field from tc_presidency, updated tc.jpg

14 years agofixed updating tc_scheduling_priority so we don't get jumbled information
Owen Leonard [Sat, 18 Sep 2010 17:41:52 +0000 (11:41 -0600)]
fixed updating tc_scheduling_priority so we don't get jumbled information

14 years agofixed sql table creation file and import script
Owen Leonard [Sat, 18 Sep 2010 06:28:17 +0000 (00:28 -0600)]
fixed sql table creation file and import script

14 years agoadded tc_task and tc_accomplishment tables to database
Owen Leonard [Sat, 18 Sep 2010 05:34:46 +0000 (23:34 -0600)]
added tc_task and tc_accomplishment tables to database

14 years agoremoved family field from tc_individual (double linkage), removed hoh_id/name/name_id...
Owen Leonard [Sat, 18 Sep 2010 05:25:52 +0000 (23:25 -0600)]
removed family field from tc_individual (double linkage), removed hoh_id/name/name_id from tc_family as they were unnecessary

14 years agoremoved indiv_id and sequence from tc_calling - redundant, unnecessary information
Owen Leonard [Sat, 18 Sep 2010 03:57:05 +0000 (21:57 -0600)]
removed indiv_id and sequence from tc_calling - redundant, unnecessary information

14 years agoadded email list tables
Owen Leonard [Sat, 18 Sep 2010 03:47:47 +0000 (21:47 -0600)]
added email list tables

14 years agoadded tc_scheduling_priority table, removed pri and notes fields from tc_individual...
Owen Leonard [Sat, 18 Sep 2010 03:40:05 +0000 (21:40 -0600)]
added tc_scheduling_priority table, removed pri and notes fields from tc_individual tc_family and tc_companionship

14 years agochanged code field in tc_assignment to be abbreviation
Owen Leonard [Fri, 17 Sep 2010 06:47:01 +0000 (00:47 -0600)]
changed code field in tc_assignment to be abbreviation

14 years agochanged mls_indiv_id to mls_id
Owen Leonard [Fri, 17 Sep 2010 06:38:56 +0000 (00:38 -0600)]
changed mls_indiv_id to mls_id

14 years agochanged indiv fields to individual
Owen Leonard [Fri, 17 Sep 2010 06:33:37 +0000 (00:33 -0600)]
changed indiv fields to individual

14 years agochanged indiv_id in tc_individual to mls_indiv_id, removed indiv_id fields in all...
Owen Leonard [Fri, 17 Sep 2010 05:11:14 +0000 (23:11 -0600)]
changed indiv_id in tc_individual to mls_indiv_id, removed indiv_id fields in all other tables

14 years agoremoved more references to EQ
Owen Leonard [Wed, 15 Sep 2010 07:00:42 +0000 (01:00 -0600)]
removed more references to EQ

14 years agochanged int_notes to hti_notes and int_pri to hti_pri in the tc_indiv table
Owen Leonard [Wed, 15 Sep 2010 06:42:33 +0000 (00:42 -0600)]
changed int_notes to hti_notes and int_pri to hti_pri in the tc_indiv table

14 years agoforgot to sort by name
Owen Leonard [Wed, 15 Sep 2010 06:27:55 +0000 (00:27 -0600)]
forgot to sort by name

14 years agoscheduling page now only shows one table per individual
Owen Leonard [Wed, 15 Sep 2010 06:23:57 +0000 (00:23 -0600)]
scheduling page now only shows one table per individual

14 years agoremove eqpres from tc_presidency table - just used the president field instead -...
Owen Leonard [Wed, 15 Sep 2010 06:01:00 +0000 (00:01 -0600)]
remove eqpres from tc_presidency table - just used the president field instead - need to enhance it to include all presidency members depending on new config file setting

14 years agoupdated msi to include xml changes
Owen Leonard [Tue, 14 Sep 2010 15:34:00 +0000 (09:34 -0600)]
updated msi to include xml changes

14 years agoremoving birthday field from tc_indiv since we don't use it and it is personal info
Owen Leonard [Tue, 14 Sep 2010 01:47:10 +0000 (19:47 -0600)]
removing birthday field from tc_indiv since we don't use it and it is personal info

14 years agoonly list families assigned to the quorum in presidency visits page
Owen Leonard [Tue, 14 Sep 2010 01:31:16 +0000 (19:31 -0600)]
only list families assigned to the quorum in presidency visits page

14 years agofixed indentation to be tabs, alignment uses tabs to match code block, then spaces...
Owen Leonard [Mon, 13 Sep 2010 23:37:28 +0000 (17:37 -0600)]
fixed indentation to be tabs, alignment uses tabs to match code block, then spaces to align

14 years agoFixed missing AUTO INCREMENT property on some fields
Alan Pippin [Mon, 13 Sep 2010 19:28:29 +0000 (13:28 -0600)]
Fixed missing AUTO INCREMENT property on some fields

14 years agoFixed syntax errors in DB upgrade script
Alan Pippin [Mon, 13 Sep 2010 18:57:43 +0000 (12:57 -0600)]
Fixed syntax errors in DB upgrade script

14 years agoAdded default values for interview_pri and visit_pri and changed the default value...
Alan Pippin [Mon, 13 Sep 2010 18:32:32 +0000 (12:32 -0600)]
Added default values for interview_pri and visit_pri and changed the default value to be 30 instead of 1.

14 years agofix some filtering of visit data like families to visit so they only list the ones...
Owen Leonard [Sun, 12 Sep 2010 22:10:59 +0000 (16:10 -0600)]
fix some filtering of visit data like families to visit so they only list the ones under the stewardship of the quorum (ones that have home teachers assigned)
fixed some ordering of the lists so that they are more alphabetic and therefore easier to scan.

14 years agoupdated msi to include changes to xml file
Owen Leonard [Sun, 12 Sep 2010 21:05:20 +0000 (15:05 -0600)]
updated msi to include changes to xml file

14 years agoadded YM to ht interview individual list if they are a home teacher
Owen Leonard [Sun, 12 Sep 2010 16:14:16 +0000 (10:14 -0600)]
added YM to ht interview individual list if they are a home teacher

14 years agofixed bug I introduced in ht scheduling page
Owen Leonard [Sun, 12 Sep 2010 14:45:06 +0000 (08:45 -0600)]
fixed bug I introduced in ht scheduling page

14 years agoadded steward field to tc_indiv so we can list prospective elders
Owen Leonard [Sun, 12 Sep 2010 08:35:08 +0000 (02:35 -0600)]
added steward field to tc_indiv so we can list prospective elders

14 years agoremoved tc_parent, tc_child, and tc_aaronic tables, moved required info into tc_indiv...
Owen Leonard [Sun, 12 Sep 2010 07:13:07 +0000 (01:13 -0600)]
removed tc_parent, tc_child, and tc_aaronic tables, moved required info into tc_indiv and linked tc_indiv to tc_family

14 years agochanged app name to tc
Owen Leonard [Sun, 12 Sep 2010 04:43:13 +0000 (22:43 -0600)]
changed app name to tc

14 years agoFlushed out another set of changes required to rename the app from eq to 3rd
Alan Pippin [Sun, 12 Sep 2010 03:03:28 +0000 (21:03 -0600)]
Flushed out another set of changes required to rename the app from eq to 3rd

14 years agostarted changing app name to 3rd, changing file names to not have eq in them
Owen Leonard [Sat, 11 Sep 2010 18:04:21 +0000 (12:04 -0600)]
started changing app name to 3rd, changing file names to not have eq in them

changed 3rd_elder to 3rd_indivi, removed as many references to elder as I could

removed more instances of 'EQ'

14 years agoupdated visit table links for companion1 and companion2
Owen Leonard [Sat, 11 Sep 2010 05:46:33 +0000 (23:46 -0600)]
updated visit table links for companion1 and companion2

14 years agoupdated jpg of database layout
Owen Leonard [Sat, 11 Sep 2010 05:39:07 +0000 (23:39 -0600)]
updated jpg of database layout

14 years agodatabase changes
Owen Leonard [Sat, 11 Sep 2010 03:16:30 +0000 (21:16 -0600)]
database changes
 - changed tables to start with 3rd_ instead of eq_
 - added prospective flag to 3rd_elder table
 - added visit_type, companion1, companion2 fields to 3rd_visit table
 - changed 3rd_ppi table to 3rd_interview
 - "converted" eqpresppi field to interview_type (enumeration) in 3rd_interview table
 - changed ppi field to interview in 3rd_interview table

more changes

asdf

again

14 years agoadding msi so you don't have to build to use MLSFileTrimmer.exe msi
Owen Leonard [Fri, 10 Sep 2010 17:59:20 +0000 (11:59 -0600)]
adding msi so you don't have to build to use MLSFileTrimmer.exe

14 years agoUpdated with latest DB schema
Alan Pippin [Fri, 10 Sep 2010 05:56:03 +0000 (23:56 -0600)]
Updated with latest DB schema

14 years agoMade the upgrade script executable release_0_4_0
Alan Pippin [Fri, 10 Sep 2010 05:51:28 +0000 (23:51 -0600)]
Made the upgrade script executable

14 years agoAdded email field to eq_aaronic
Owen Leonard [Fri, 10 Sep 2010 04:44:44 +0000 (22:44 -0600)]
Added email field to eq_aaronic
Added priesthood field to eq_elder
Added prospective elders to eq_elder during import of data and set the priesthood field  (this way they are included in attendance, ppi's, etc)

14 years agochanged from email address, import email addresses to eq_elder, flush temp files...
Owen Leonard [Thu, 9 Sep 2010 07:05:45 +0000 (01:05 -0600)]
changed from email address, import email addresses to eq_elder, flush temp files in mlstrimmer.py so we don't keep losing data

14 years agoUpdated "Phone 1" field to be "Household Phone" to match MLS
Owen Leonard [Mon, 6 Sep 2010 23:34:35 +0000 (17:34 -0600)]
Updated "Phone 1" field to be "Household Phone" to match MLS
updated install instructions
added mls report file to create the home teaching stats csv file
adding C# windows program and python script for parsing mls data (c#-.net 3.5, python-2.6)

14 years agoChanged hard coded areacode number into a configurable variable
Alan J. Pippin [Fri, 10 Sep 2010 04:10:16 +0000 (22:10 -0600)]
Changed hard coded areacode number into a configurable variable

14 years agoFixed initialization issue with unique_companionships array
Alan J. Pippin [Wed, 8 Sep 2010 20:44:34 +0000 (14:44 -0600)]
Fixed initialization issue with unique_companionships array

14 years agoImproved drop down list choices for ppi and ht interviews
Alan J. Pippin [Wed, 8 Sep 2010 20:37:25 +0000 (14:37 -0600)]
Improved drop down list choices for ppi and ht interviews

14 years agoAdded extra messages for failed file upload.
Alan J. Pippin [Wed, 8 Sep 2010 20:30:47 +0000 (14:30 -0600)]
Added extra messages for failed file upload.
Added EQ presidency members to interviewer drop down list in PPI scheduling tool.

15 years agoFixed paths to match more common linux distros
Alan J. Pippin [Sun, 4 Jan 2009 21:05:38 +0000 (14:05 -0700)]
Fixed paths to match more common linux distros

16 years agoFixed bug with "Add Activity" button to move it outside of the for loop
Alan J. Pippin [Sat, 20 Sep 2008 01:51:10 +0000 (19:51 -0600)]
Fixed bug with "Add Activity" button to move it outside of the for loop
that looped over all of the Activities. This prevented it from being
displayed when the activity table was empty.

16 years agoFixed bug in querying eqpres PPI history in scheduling tool. release_0_3_1
Alan J. Pippin [Mon, 7 Jul 2008 04:52:46 +0000 (22:52 -0600)]
Fixed bug in querying eqpres PPI history in scheduling tool.

16 years agoAdded new fields to sql db create script release_0_3_0
Alan J. Pippin [Tue, 13 May 2008 14:38:46 +0000 (08:38 -0600)]
Added new fields to sql db create script

16 years agoReduced font of drop down menus to allow appointment slot to fit on 1 line
Alan J. Pippin [Tue, 13 May 2008 14:34:49 +0000 (08:34 -0600)]
Reduced font of drop down menus to allow appointment slot to fit on 1 line

16 years agoAdded under construction indication
Alan J. Pippin [Tue, 29 Apr 2008 02:51:04 +0000 (20:51 -0600)]
Added under construction indication

16 years agoAdded ability to pull address of district leaders for their interviews.
Alan J. Pippin [Wed, 23 Apr 2008 13:34:46 +0000 (07:34 -0600)]
Added ability to pull address of district leaders for their interviews.

16 years agoAdded some usage/help text for new location field.
Alan J. Pippin [Wed, 23 Apr 2008 06:31:24 +0000 (00:31 -0600)]
Added some usage/help text for new location field.

16 years agoAdded new database fields: elder->email and appointment->location
Alan J. Pippin [Wed, 23 Apr 2008 05:49:08 +0000 (23:49 -0600)]
Added new database fields: elder->email and appointment->location
Added code to populate and allow editing of appointment location.
Stubbed out links for new email application

16 years agoIncreased width of "Notes" text boxes from 60 to 100.
Alan J. Pippin [Wed, 23 Apr 2008 03:15:12 +0000 (21:15 -0600)]
Increased width of "Notes" text boxes from 60 to 100.

16 years agoFixed bug in attendance tool in quarter boundary calculation.
Alan J. Pippin [Mon, 14 Apr 2008 01:22:52 +0000 (19:22 -0600)]
Fixed bug in attendance tool in quarter boundary calculation.

The attendance tool was not displaying "quarters" of data properly.
There was a bug in the algorithm that was calculating the quarter
window of time, causing it to be 2 months instead of 3.
This is a fix for that issue.

16 years agoSpelled out dependencies explicitly
Alan J. Pippin [Mon, 14 Apr 2008 01:09:16 +0000 (19:09 -0600)]
Spelled out dependencies explicitly

16 years agoFixed yearly ppi scheduling tool bug which caused non eqpresppi's to count as yearly...
Alan J. Pippin [Mon, 17 Mar 2008 02:43:42 +0000 (20:43 -0600)]
Fixed yearly ppi scheduling tool bug which caused non eqpresppi's to count as yearly PPIs.

16 years agoChanged the way hometeaching stats are calculated.
Alan J. Pippin [Tue, 11 Mar 2008 22:57:40 +0000 (16:57 -0600)]
Changed the way hometeaching stats are calculated.

If a family has a blank as a hometeaching visit status,
that family will not count for the total homteaching
percentages. Only families marked with Y or N will now
count for the hometeaching percentages.

16 years agoUpdated docs to reference new check_config_syntax script
Alan J. Pippin [Mon, 18 Feb 2008 04:34:34 +0000 (21:34 -0700)]
Updated docs to reference new check_config_syntax script

16 years agoAdded new script to check the syntax of the config files
Alan J. Pippin [Mon, 18 Feb 2008 04:31:07 +0000 (21:31 -0700)]
Added new script to check the syntax of the config files

16 years agoUndid the change of the include path. It was better the way it was.
Alan J. Pippin [Mon, 18 Feb 2008 04:14:58 +0000 (21:14 -0700)]
Undid the change of the include path. It was better the way it was.

16 years agoChanged include syntax to be a full path instead of a relative path.
Alan J. Pippin [Mon, 18 Feb 2008 04:07:43 +0000 (21:07 -0700)]
Changed include syntax to be a full path instead of a relative path.
Renamed db upgrade command to better fit the naming convention I want to follow long term.

16 years agoFixed "interview total" bug when pulling up previous quarters of history.
Alan J. Pippin [Sat, 16 Feb 2008 03:02:18 +0000 (20:02 -0700)]
Fixed "interview total" bug when pulling up previous quarters of history.

16 years agoChanged monthly_hometeaching_interview_stats config variable to mean every X months.
Alan J. Pippin [Sat, 16 Feb 2008 02:56:23 +0000 (19:56 -0700)]
Changed monthly_hometeaching_interview_stats config variable to mean every X months.

It now represents the frequency of hometeaching interview stats in months.
Example Values: Monthly=1 Quarterly=3 Yearly=12

16 years agoUpdated path to direct download of module release_0_2_0
Alan J. Pippin [Wed, 13 Feb 2008 15:50:28 +0000 (08:50 -0700)]
Updated path to direct download of module

16 years agoMerge branch 'test'
Alan J. Pippin [Wed, 13 Feb 2008 15:44:32 +0000 (08:44 -0700)]
Merge branch 'test'

16 years agoFixed changelog message
Alan J. Pippin [Wed, 13 Feb 2008 15:42:26 +0000 (08:42 -0700)]
Fixed changelog message

16 years agoRolled version number to 2.0
Alan J. Pippin [Wed, 13 Feb 2008 15:38:51 +0000 (08:38 -0700)]
Rolled version number to 2.0

16 years agoFixed bug related to not being able to edit hometeaching history for
Alan J. Pippin [Wed, 13 Feb 2008 15:06:55 +0000 (08:06 -0700)]
Fixed bug related to not being able to edit hometeaching history for
a family once they had been reassigned to a new companionship.

16 years agoAdded path local variable for unzip and added "update" option to unzip command.
Alan J. Pippin [Wed, 13 Feb 2008 07:47:35 +0000 (00:47 -0700)]
Added path local variable for unzip and added "update" option to unzip command.

Root caused hometeaching issue with changing visited status in the past
for a family that has moved to a new companionship. Added comments for the fix,
but I'm not ready to enforce the fix yet.

16 years agoChanges required to implement config files that can be overridden locally.
Alan J. Pippin [Wed, 13 Feb 2008 05:57:48 +0000 (22:57 -0700)]
Changes required to implement config files that can be overridden locally.

This enables an end user to make .local config files, and edit them
as appropriate, preventing future code upgrades from blowing away their
site specific settings.