task

CREATE-task# # -

FEATURE-4900-bio - porting to .org

[previously]

1. [00:00] NEW task IN
1. [] # 2793 - CREATE-task# # - FEATURE-4900-bio - porting to .org - currently the MyStuff/Bio feature is not functional
2. [] TLDR - bio view should show 'all'  'task/items' that are 'Completed' and had a high priority value assigned(-1), [] these items are organized by the calendar, plan and taskgroup that they appeared in, aka bio_by_project, [*] based on view_priority (actually uses db viewPriority 
3. []
4. [*] repurposing this task, ORIG = PROCESS misc - tasks that, ON = 2019-09-19, content moved to today
2. [00:00] NEW task IN - prj-022 - ISSUE-001
   
1. [] # # - FEATURE bio - server error on page load
2. [x] ISSUE-001 - error of missing bracket
3. [00:00] NEW task IN - - ISSUE-002
1. [x] ISSUE-002- database construction error, the 'view' was created as a table and not as a view, REF = # 4569
4. [00:00] NEW task IN - ISSUE-003
1. [] # # - CREATE-task# # - ISSUE-003 - ] view is missing column used by the 'Page grouping', ]
2. [x] TRY = [] modify query to order results by desired ouput, execution is VERY VERY slow(30ish seconds) in phpmyadmin, [] modify view to remove 'grouping' queries and 'display' code 
3. ==
4. [] TRY =
5. [x] rebuild the VIEW adding fields for parent_id_plan and parent_id_taskgroup
6. [x] modified code for display, naming from: plan_parent_id to|: parent_id
7. [x] returned the REM oved display task item code  ( removed to isolate errors )
8. > [] REM oved 'code' in task display block, used to calculate totals, WAS not executing, WAS displaying
9. [x] TEST = view/bio
10. [x] result = PASS - page loads, and displays DATA, looks like CRAP, see TOD
5. [00:00] NEW task IN - ISSUE-004 - content alignment
   
1. [x] content is left aligned -
2. [x] RESOLUTION - added wrapper tag, removed errant  div tag,
6. [00:00] NEW task IN - ISSUE-005 - headings with no content
   
1. [x] ISSUE = why are 'heading's that have no content items displaying -
2. [x] CAUSE.suspect = the query to get the groups, is only checking priority and not status, therefore it displays groups where no records are displayed
3. [*] EX before - dons - [] myCal/plan-per/today-demo, [] myCal/plan-project/ideas, [] myCal/plan-project/money-invest, [] prj-022/doc-period/this-month, [] prj-022/plan-period/this-month[] prj-022/plan-prj/toolbar-records, [] prj-026-no/document/this-year, [] prj-026-no/plan/document, [] prj-026-no/plan/this-year
4. [*] the ones on the list above, should show up on the priority report with content
5. [x] EDIT = ] db qry for plans, ] for taskgroups, ] added var Status to Page, ]  
6. [x] EDITed qrys for cal, plans and taskgroups.
7. [x] TEST = display only groups where there is data items preset,
8. [x] .result = PASS on dons(# items, # groups), on public(2 items, 2 groups)
7. [00:00] NEW task IN - ISSUE-006 - stats bar - location and style
   
1. [x] ISSUE = stats bar - location  - currently displays at top of page, covering nav links in navHeader
2. [x] NEW LOCATION = relocated it to directly below navHeader, [x] removed current style of "statsbar" (used absolute postioning), 
3. [x] added style = navHeader to statsbar
4. [x] EDIT - navHeader - [x] removed id=navHeader -> added class = navHeader, [x] removed REMmed code
5. [x] EDIT - sospep.css - changed to . css class  VS # id, [x] added h4 , set to 1.0 rem, (h3 = 1.25 rem)
8. >[00:00] NEW task IN - ISSUE-007 - stats bar functionality
   
1. []  # # - [] stats bar - functionality -
2. [x] moved 'statsBar' into '/Shared' as partial page, call RenderPage,
3. [] ERROR re: - var doesnt exist in this context, RESOLUTION: changed varName to Page.varName
1. [] even after changing to Page["var"] property
2. [] PROBLEM WAS - shared page is rendered BEFORE values are caculated. Values are calculated in the display list items loop. Page is rendered at the top. This is why was previously using
3. [] RESOLUTION =
4. [1] return prev, render component after display loop, then re position  (update from :using absolute position, to: ] reposition with script ] reposition with css)
5. [] https://stackoverflow.com/questions/104953/position-an-html-element-relative-to-its-container-using-css
6. [2] call js method - ] write vars to input hidden, ] call js method, updateStatsBar(), ] write js method updateStatsBar, -uses hidden input vars to update statsbar # values
4. [] ERROR re: type passed into arg, when calling the calculateCompletedPercentage helper method
9.  [00:00] NEW task IN - CLOSE
   
1. [] CODE renamed view_p1 AS view_priority
2. [] DB
3. [] ?= REM OVE - case statement for cases based on called from plan,
4. will come back to update ] statsbar functionality

[currently]

1. [00:00] NEW task IN - UPDATES
1. [x] added isAuthenticated check on 'display' edit toolbars,
2. [x] moved view/task link to taskName VS in links toolbar,
3. [*] use of code inside code block, example nested if statement, 2nd if requres @{  ... } wrapper
4. []
   

[next]

1. [00:00] NEW task IN TODO
1. [x] content is left aligned -
2. [] heading styles -
3. [x] stats bar - location
4. [x] stats bar - style
5. [i] stats bar - functionality
6. [x] why are 'heading's that have no content displaying -
7. [i] database - update VIEW on OTHER DATABAseS, - [x] dons, [] ewa, []
2.  [00:00] NEW task IN
1. [] # # - CREATE-task# # -
2. [] bio - all
3. ===
4. [] bio - by calendar
5. [] bio - by plan/document
6. [] bio - by taskgroup
7. ===
8. [] bio - by period - ( day, month, week, quarter, )
9. [] bio - by period - custom

[reference]

query

SELECT * FROM `view_p1` WHERE priority = -5 and status = 'Completed'

create view

create query

Details

ID: 2793

NAME: DB-CREATE

DESCRIPTION: SQL SCRIPT - to generate a blank copy of the 'current version' of the sospep db

START DATE TIME: 2013-09-04 17:30:02

EST DURATION: 01:00:00

END DATE TIME: 2013-09-04 18:30:02

STATUS: Completed

PRIORITY: -5

OWNER ID: 75

photos

actions