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

16 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

16 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.

16 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.

16 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.

16 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.

16 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.

16 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

16 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

16 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

16 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.

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

16 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.

16 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

16 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

16 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.

16 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

16 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.

16 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.

16 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

16 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

16 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.

16 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

16 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.

16 years agoFixed issues with EQ Attendance tool not properly calculating the percent per month
Alan Jack Pippin [Mon, 6 Aug 2007 00:47:38 +0000 (18:47 -0600)]
Fixed issues with EQ Attendance tool not properly calculating the percent per month

16 years agoFixed bug related to not setting the valid bit to 1 when adding new families
Alan Jack Pippin [Fri, 13 Jul 2007 03:32:22 +0000 (21:32 -0600)]
Fixed bug related to not setting the valid bit to 1 when adding new families

16 years agoFixed scheduling tool title
Alan Jack Pippin [Mon, 11 Jun 2007 14:34:08 +0000 (08:34 -0600)]
Fixed scheduling tool title

17 years agoChanged current code to implement: Quarterly Hometeaching Interviews & Yearly PPIs
Alan Jack Pippin [Sun, 1 Apr 2007 23:09:11 +0000 (17:09 -0600)]
Changed current code to implement: Quarterly Hometeaching Interviews & Yearly PPIs
Created new eq_interview table to distinguish from eq_ppi table entries.

17 years agoFixed links in scheduling tool to point to "add" ability
Alan Jack Pippin [Fri, 19 Jan 2007 04:18:44 +0000 (21:18 -0700)]
Fixed links in scheduling tool to point to "add" ability

17 years agoAdded new elder_id field to the family table.
Alan Jack Pippin [Mon, 8 Jan 2007 04:50:03 +0000 (21:50 -0700)]
Added new elder_id field to the family table.
Changed yearly visit search criteria on family table to only match families with elders in them.

17 years agoAdded new vis_sched and schedule tools.
Alan Jack Pippin [Mon, 27 Nov 2006 05:28:56 +0000 (22:28 -0700)]
Added new vis_sched and schedule tools.
Fixed import bug related to finding a family_id for parent records.

17 years agoAdded truncated PPI notes to PPI completed table
Alan Jack Pippin [Tue, 14 Nov 2006 15:43:08 +0000 (08:43 -0700)]
Added truncated PPI notes to PPI completed table

17 years agoAdded new Last PPI column
Alan Jack Pippin [Tue, 14 Nov 2006 07:17:48 +0000 (00:17 -0700)]
Added new Last PPI column

17 years agoAdded table showing elders who have their yearly ppi completed.
Alan Jack Pippin [Mon, 13 Nov 2006 14:46:02 +0000 (07:46 -0700)]
Added table showing elders who have their yearly ppi completed.

17 years agoAdded a new ppi_sched tool for scheduling (via priority) EQ President Yearly PPIs
Alan Jack Pippin [Mon, 13 Nov 2006 07:11:54 +0000 (00:11 -0700)]
Added a new ppi_sched tool for scheduling (via priority) EQ President Yearly PPIs

17 years agoAdded new Admin page with a data import tool.
Alan Jack Pippin [Mon, 16 Oct 2006 04:04:53 +0000 (22:04 -0600)]
Added new Admin page with a data import tool.

17 years agoFixed bug related to preferred name mismatches with hometeaching family name.
Alan Jack Pippin [Mon, 11 Sep 2006 03:37:32 +0000 (21:37 -0600)]
Fixed bug related to preferred name mismatches with hometeaching family name.

17 years agoAllowed Deacons to be hometeaching companions.
Alan Jack Pippin [Mon, 12 Jun 2006 23:27:55 +0000 (17:27 -0600)]
Allowed Deacons to be hometeaching companions.

17 years agoChanged order of header bar
Alan Jack Pippin [Fri, 2 Jun 2006 06:07:32 +0000 (00:07 -0600)]
Changed order of header bar

17 years agoAdded new Ward Calling display application.
Alan Jack Pippin [Fri, 2 Jun 2006 06:03:50 +0000 (00:03 -0600)]
Added new Ward Calling display application.

17 years agoFixed import bug that existed when Aaronic Priesthood Companion was not found in db
Alan Jack Pippin [Fri, 2 Jun 2006 03:44:50 +0000 (21:44 -0600)]
Fixed import bug that existed when Aaronic Priesthood Companion was not found in db
because they haven't been ordained yet. This caused other Elders to be added instead.

18 years agoFixed bug related to how the eqpresppi district was being chosen.
Alan Jack Pippin [Wed, 5 Apr 2006 04:18:34 +0000 (22:18 -0600)]
Fixed bug related to how the eqpresppi district was being chosen.

18 years agoRemoved call to broken strtotime() php method & wrote my own.
Alan Jack Pippin [Wed, 29 Mar 2006 21:20:30 +0000 (14:20 -0700)]
Removed call to broken strtotime() php method & wrote my own.

18 years agoUpdated import script to populate new name_id field of the
Alan Jack Pippin [Mon, 27 Mar 2006 04:29:15 +0000 (21:29 -0700)]
Updated import script to populate new name_id field of the
eq_family table that is the case in-sensitive version of the
family name to be used for db lookup matching.

18 years agoFixed HT apps to sort families under a companionship in alphabetical order.
Alan Jack Pippin [Mon, 13 Mar 2006 06:36:35 +0000 (23:36 -0700)]
Fixed HT apps to sort families under a companionship in alphabetical order.

18 years agoFixed bug related to dropping family from being hometaught, still showed up under...
Alan Jack Pippin [Mon, 13 Feb 2006 00:53:09 +0000 (17:53 -0700)]
Fixed bug related to dropping family from being hometaught, still showed up under companionship.

18 years agoChanged default months being shown to 3.
Alan Jack Pippin [Fri, 10 Feb 2006 04:58:34 +0000 (21:58 -0700)]
Changed default months being shown to 3.

18 years agoCreated new ward directory viewing application.
Alan Jack Pippin [Fri, 10 Feb 2006 03:46:00 +0000 (20:46 -0700)]
Created new ward directory viewing application.

18 years agoFixed bug with valid qualifier missing from eq_companionship table access during...
Alan Jack Pippin [Fri, 10 Feb 2006 03:09:11 +0000 (20:09 -0700)]
Fixed bug with valid qualifier missing from eq_companionship table access during ht_update.

18 years agoFixed bug in updating eq_aaronic table.
Alan Jack Pippin [Tue, 31 Jan 2006 06:57:14 +0000 (23:57 -0700)]
Fixed bug in updating eq_aaronic table.

18 years agoAdded ability for aaronic to be given PPIs.
Alan Jack Pippin [Tue, 31 Jan 2006 06:47:43 +0000 (23:47 -0700)]
Added ability for aaronic to be given PPIs.
Added phone numbers to aaronic records.
Fixed ppi stats to only count a max of 1 per companionship per month.

18 years agoInitial Rev.
Alan Jack Pippin [Sat, 28 Jan 2006 03:47:13 +0000 (20:47 -0700)]
Initial Rev.

18 years agoAdded new phone and address field to eq_parent table.
Alan Jack Pippin [Sat, 28 Jan 2006 03:46:44 +0000 (20:46 -0700)]
Added new phone and address field to eq_parent table.
Added new header for online ward directory.
Updated parsing script to fill phone & address fields.