eq/.git
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.

16 years agoAdded new "Yearly PPI" checkbox to PPI or interview entry/edit form.
Alan J. Pippin [Wed, 13 Feb 2008 04:58:01 +0000 (21:58 -0700)]
Added new "Yearly PPI" checkbox to PPI or interview entry/edit form.

16 years agoCompleted the rest of the support needed for the new monthly_hometeaching_interview...
Alan J. Pippin [Wed, 13 Feb 2008 03:58:54 +0000 (20:58 -0700)]
Completed the rest of the support needed for the new monthly_hometeaching_interview mode.

16 years agoMerged the eq_interview table with the eq_ppi table.
Alan J. Pippin [Tue, 12 Feb 2008 06:53:30 +0000 (23:53 -0700)]
Merged the eq_interview table with the eq_ppi table.

Eliminated all references to the eq_interview table.
The newly created bin/merge_eq_ppi_eq_interview_tables
script needs to be run after pulling this code base.
After that script runs, you can safely drop the
eq_interview table once you know your entries have
been moved over to the eq_ppi table properly.

16 years agoAdded new hour/minute field preferences to control time increment & form style.
Alan J. Pippin [Mon, 11 Feb 2008 22:07:50 +0000 (15:07 -0700)]
Added new hour/minute field preferences to control time increment & form style.

16 years agoConverted calendar appointment emails into multi-part mime messages.
Alan J. Pippin [Mon, 11 Feb 2008 19:27:10 +0000 (12:27 -0700)]
Converted calendar appointment emails into multi-part mime messages.

16 years agoUnlocked (made editable) Interviewer drop down list in ppi or interview edit mode.
Alan J. Pippin [Mon, 11 Feb 2008 06:19:42 +0000 (23:19 -0700)]
Unlocked (made editable) Interviewer drop down list in ppi or interview edit mode.

16 years agoAdded a comment stating what the lowest and highest priority definitions are
Alan J. Pippin [Wed, 30 Jan 2008 15:38:24 +0000 (08:38 -0700)]
Added a comment stating what the lowest and highest priority definitions are

16 years agoCleaned up a number of warnings exposed by recent migration to PHP 5.2
Alan J. Pippin [Wed, 30 Jan 2008 15:29:04 +0000 (08:29 -0700)]
Cleaned up a number of warnings exposed by recent migration to PHP 5.2

16 years agoMade DBI connect changes suggested by Brett Williams.
Alan J. Pippin [Wed, 30 Jan 2008 15:00:32 +0000 (08:00 -0700)]
Made DBI connect changes suggested by Brett Williams.

16 years agoChanged reference to create jsCalendar to be our own local class.
Alan J. Pippin [Wed, 30 Jan 2008 14:50:47 +0000 (07:50 -0700)]
Changed reference to create jsCalendar to be our own local class.
This was done to fix the issue with the base phpgroupware phpgwapi
doing away with the "setup" parameter to the calendar which we
rely on for inputing our dates properly into SQL.

16 years agoUpdated install steps
Alan J. Pippin [Wed, 30 Jan 2008 14:49:34 +0000 (07:49 -0700)]
Updated install steps

16 years agoNumerous bug fixes from Brett's turn-on experience.
Alan Jack Pippin [Mon, 14 Jan 2008 04:47:52 +0000 (21:47 -0700)]
Numerous bug fixes from Brett's turn-on experience.

16 years agoTweaked help wording in admin tool release_0_1_0
Alan Jack Pippin [Mon, 7 Jan 2008 15:18:42 +0000 (08:18 -0700)]
Tweaked help wording in admin tool

16 years agoTweaked wording of assignments in the activity app
Alan Jack Pippin [Mon, 7 Jan 2008 15:15:32 +0000 (08:15 -0700)]
Tweaked wording of assignments in the activity app

16 years agoImproved documentation comments across multiple applications.
Alan Jack Pippin [Mon, 7 Jan 2008 07:36:20 +0000 (00:36 -0700)]
Improved documentation comments across multiple applications.
Fixed bad ordering of install steps.

16 years agoRemoved table defintions. These messed up the setup routine.
Alan Jack Pippin [Mon, 7 Jan 2008 04:07:59 +0000 (21:07 -0700)]
Removed table defintions. These messed up the setup routine.
These need to be done by hand.

16 years agoFurther tweaks to help messages
Alan Jack Pippin [Sun, 6 Jan 2008 07:16:07 +0000 (00:16 -0700)]
Further tweaks to help messages

16 years agoTweaked help given for EQ Presidency Table Update Form
Alan Jack Pippin [Sun, 6 Jan 2008 07:14:38 +0000 (00:14 -0700)]
Tweaked help given for EQ Presidency Table Update Form

16 years agoFurther tweaks to the install doc
Alan Jack Pippin [Sun, 6 Jan 2008 07:08:40 +0000 (00:08 -0700)]
Further tweaks to the install doc

16 years agoTweaked installation notes
Alan Jack Pippin [Sun, 6 Jan 2008 06:59:54 +0000 (23:59 -0700)]
Tweaked installation notes

16 years agoFinal notes added to the install process.
Alan Jack Pippin [Sun, 6 Jan 2008 06:54:24 +0000 (23:54 -0700)]
Final notes added to the install process.

16 years agoRemoved data being added to district table.
Alan Jack Pippin [Sun, 6 Jan 2008 00:04:30 +0000 (17:04 -0700)]
Removed data being added to district table.
This is now done automatically. When the presidency table is updated.

16 years agoUpdate docs
Alan Jack Pippin [Sun, 6 Jan 2008 00:03:37 +0000 (17:03 -0700)]
Update docs

16 years agoMinor restructuring of program locations.
Alan Jack Pippin [Sun, 6 Jan 2008 00:03:23 +0000 (17:03 -0700)]
Minor restructuring of program locations.
Added new sql create script.
Updated docs/ folder with proper install instructions.
Added new "EQ Presidency Table Update" tool under Admin.

17 years agoFixed bug in unwilling elder filter
Alan Jack Pippin [Mon, 15 Oct 2007 00:46:28 +0000 (18:46 -0600)]
Fixed bug in unwilling elder filter

17 years agoFixed "null" interviewer in PPI scheduling tool.
Alan Jack Pippin [Sun, 14 Oct 2007 18:08:11 +0000 (12:08 -0600)]
Fixed "null" interviewer in PPI scheduling tool.
Added "filter unwilling elders" option to willingness tool.

17 years agoFixed bug in the PPI tool where the interviewer wasn't being
Alan Jack Pippin [Tue, 9 Oct 2007 02:02:11 +0000 (20:02 -0600)]
Fixed bug in the PPI tool where the interviewer wasn't being
set to the EQ president in the ppi_update() method properly.

17 years agoFixed some bugs in the scheduling appointment email logic.
Alan Jack Pippin [Sun, 7 Oct 2007 21:39:12 +0000 (15:39 -0600)]
Fixed some bugs in the scheduling appointment email logic.

17 years agoRemoved interview priority and notes fields for aaronic priesthood holders in intervi...
Alan Jack Pippin [Wed, 19 Sep 2007 05:39:21 +0000 (23:39 -0600)]
Removed interview priority and notes fields for aaronic priesthood holders in interview scheduler tool.

17 years agoRemoved all calls to db->db_addslashes. This seems to be unnecessary.
Alan Jack Pippin [Tue, 18 Sep 2007 13:52:31 +0000 (07:52 -0600)]
Removed all calls to db->db_addslashes. This seems to be unnecessary.

17 years agoAdded phone info when hovering over Elder Names
Alan Jack Pippin [Thu, 6 Sep 2007 03:39:03 +0000 (21:39 -0600)]
Added phone info when hovering over Elder Names
Added latest participation date under willingness

17 years agoChanged default "blank appointment rows" to show from 1 to 4
Alan Jack Pippin [Thu, 6 Sep 2007 03:16:08 +0000 (21:16 -0600)]
Changed default "blank appointment rows" to show from 1 to 4

17 years agoFixed Elder name column width
Alan Jack Pippin [Thu, 6 Sep 2007 02:33:14 +0000 (20:33 -0600)]
Fixed Elder name column width

17 years agoCentered total elders willing to serve data.
Alan Jack Pippin [Mon, 27 Aug 2007 02:59:38 +0000 (20:59 -0600)]
Centered total elders willing to serve data.

17 years agoImplemented new willingness table
Alan Jack Pippin [Mon, 27 Aug 2007 02:41:17 +0000 (20:41 -0600)]
Implemented new willingness table

17 years agoFixed appointment sending bug. Only send appointments if they have changed.
Alan Jack Pippin [Wed, 15 Aug 2007 04:45:45 +0000 (22:45 -0600)]
Fixed appointment sending bug. Only send appointments if they have changed.

17 years agoFont adjustments to participated table
Alan Jack Pippin [Tue, 14 Aug 2007 13:22:54 +0000 (07:22 -0600)]
Font adjustments to participated table

17 years agoFixed participation table to show activities by assignment
Alan Jack Pippin [Tue, 14 Aug 2007 13:11:44 +0000 (07:11 -0600)]
Fixed participation table to show activities by assignment

17 years agoCreated new assignment tool. Revamped activity tool to use the assignments.
Alan Jack Pippin [Tue, 14 Aug 2007 05:25:09 +0000 (23:25 -0600)]
Created new assignment tool. Revamped activity tool to use the assignments.

17 years agoAdded address to visit type appointment calendar items
Alan Jack Pippin [Mon, 13 Aug 2007 05:00:48 +0000 (23:00 -0600)]
Added address to visit type appointment calendar items

17 years agoAdded new iCal notification feature for all appointments that are scheduled.
Alan Jack Pippin [Mon, 13 Aug 2007 02:55:51 +0000 (20:55 -0600)]
Added new iCal notification feature for all appointments that are scheduled.

17 years agoAdded new 'attending' flag to eq_elder table.
Alan Jack Pippin [Sun, 12 Aug 2007 22:33:34 +0000 (16:33 -0600)]
Added new 'attending' flag to eq_elder table.
Increased intelligence of import tool to set 'attending' flag
apprpriately based on the Elder's calling.

17 years agoFixed attendance tool to show history by quarters, not months
Alan Jack Pippin [Sun, 12 Aug 2007 21:54:19 +0000 (15:54 -0600)]
Fixed attendance tool to show history by quarters, not months

17 years agoChanged interview viewing tool to display results by quarter
Alan Jack Pippin [Sun, 12 Aug 2007 21:43:51 +0000 (15:43 -0600)]
Changed interview viewing tool to display results by quarter

17 years agoFixed interview tool to encorporate a new interview scheduling tool.
Alan Jack Pippin [Sun, 12 Aug 2007 21:33:16 +0000 (15:33 -0600)]
Fixed interview tool to encorporate a new interview scheduling tool.

17 years agoCreated new scheduling application for HT interviews
Alan Jack Pippin [Mon, 6 Aug 2007 05:41:58 +0000 (23:41 -0600)]
Created new scheduling application for HT interviews

17 years agoSwitched PPIs back to just being done by the EQ President.
Alan Jack Pippin [Mon, 6 Aug 2007 03:27:18 +0000 (21:27 -0600)]
Switched PPIs back to just being done by the EQ President.
Added new eq_presidency table, and switched over to using it.