(public).sospep.events ~ view task ~ DB-CREATE

<h1 style="text-align: center;">CREATE-task# # -</h1>
<h1 style="text-align: center;">FEATURE-4900-bio - porting to .org</h1>
<h2>[previously]</h2>
<ol>
<li><strong>[00:00] NEW task IN </strong></li>
<ol>
<li>[] # 2793 - <a href="/view/task?id=2793" target="_blank">CREATE-task# # </a>- FEATURE-4900-bio - porting to .org - currently the MyStuff/Bio feature is not functional</li>
<li>[] TLDR - bio view should show 'all'&nbsp; '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&nbsp;</li>
<li>[]</li>
<li>[*] repurposing this task, ORIG = PROCESS misc - tasks that, ON = 2019-09-19, content moved to today</li>
</ol>
<li><strong>[00:00] NEW task IN - <a href="/view/plans?id=1" target="_blank">prj-022</a> - ISSUE-001<a href="/view/plans?id=1" target="_blank"><br /></a></strong></li>
<ol>
<li>[] # # - FEATURE bio - server error on page load</li>
<li>[x] ISSUE-001 - error of missing bracket</li>
</ol>
<li><strong>[00:00] NEW task IN - </strong><strong><strong>- ISSUE-002</strong></strong></li>
<ol>
<li>[x] ISSUE-002- database construction error, the 'view' was created as a table and not as a view, REF = # 4569</li>
</ol>
<li><strong>[00:00] NEW task IN </strong><strong><strong>- ISSUE-003</strong></strong></li>
<ol>
<li>[] # # - <a href="/view/task?id=1839" target="_blank">CREATE-task# # </a>- ISSUE-003 - ] view is missing column used by the 'Page grouping', ]</li>
<li>[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&nbsp;</li>
<li>==</li>
<li>[] TRY =</li>
<li>[x] rebuild the VIEW adding fields for parent_id_plan and parent_id_taskgroup</li>
<li>[x] modified code for display, naming from: plan_parent_id to|: parent_id</li>
<li>[x] returned the REM oved display task item code&nbsp; ( removed to isolate errors )</li>
<li>&gt; [] REM oved 'code' in task display block, used to calculate totals, WAS not executing, WAS displaying</li>
<li>[x] TEST = view/bio</li>
<li>[x] result = PASS - page loads, and displays DATA, looks like CRAP, see TOD</li>
</ol>
<li><strong>[00:00] NEW task IN - ISSUE-004 - content alignment<br /></strong></li>
<ol>
<li>[x] content is left aligned -</li>
<li>[x] RESOLUTION - added wrapper tag, removed errant&nbsp; div tag,</li>
</ol>
<li><strong>[00:00] NEW task IN - ISSUE-005 - headings with no content<br /></strong></li>
<ol>
<li>[x] ISSUE = why are 'heading's that have no content items displaying -</li>
<li>[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</li>
<li>[*] 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</li>
<li>[*] the ones on the list above, should show up on the priority report with content</li>
<li>[x] EDIT = ] db qry for plans, ] for taskgroups, ] added var Status to Page, ] &nbsp;</li>
<li>[x] EDITed qrys for cal, plans and taskgroups.</li>
<li>[x] TEST = display only groups where there is data items preset,</li>
<li>[x] .result = PASS on dons(# items, # groups), on public(2 items, 2 groups)</li>
</ol>
<li><strong>[00:00] NEW task IN - ISSUE-006 - stats bar - location and style<br /></strong></li>
<ol>
<li>[x] ISSUE = stats bar - location&nbsp; - currently displays at top of page, covering nav links in navHeader</li>
<li>[x] NEW LOCATION = relocated it to directly below navHeader, [x] removed current style of "statsbar" (used absolute postioning),&nbsp;</li>
<li>[x] added style = navHeader to statsbar</li>
<li>[x] EDIT - navHeader - [x] removed id=navHeader -&gt; added class = navHeader, [x] removed REMmed code</li>
<li>[x] EDIT - sospep.css - changed to . css class&nbsp; VS # id, [x] added h4 , set to 1.0 rem, (h3 = 1.25 rem)</li>
</ol>
<li><strong>&gt;[00:00] NEW task IN - ISSUE-007 - stats bar functionality<br /></strong></li>
<ol>
<li>[]&nbsp; # # - [] stats bar - functionality -</li>
<li>[x] moved 'statsBar' into '/Shared' as partial page, call RenderPage,</li>
<li>[] ERROR re: - var doesnt exist in this context, RESOLUTION: changed varName to Page.varName</li>
<ol>
<li>[] even after changing to Page["var"] property</li>
<li>[] 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</li>
<li>[] RESOLUTION =</li>
<li>[1] return prev, render component after display loop, then re position&nbsp; (update from :using absolute position, to: ] reposition with script ] reposition with css)</li>
<li>[] https://stackoverflow.com/questions/104953/position-an-html-element-relative-to-its-container-using-css</li>
<li>[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</li>
</ol>
<li>[] ERROR re: type passed into arg, when calling the calculateCompletedPercentage helper method</li>
</ol>
<li><strong>&nbsp;[00:00] NEW task IN - CLOSE <br /></strong></li>
<ol>
<li>[] CODE renamed view_p1 AS view_priority</li>
<li>[] DB</li>
<li>[] ?= REM OVE - case statement for cases based on called from plan,</li>
<li>will come back to update ] statsbar functionality</li>
</ol></ol>
<h2>[currently]</h2>
<ol>
<li><strong>[00:00] NEW task IN - UPDATES</strong></li>
<ol>
<li>[x] added isAuthenticated check on 'display' edit toolbars,</li>
<li>[x] moved view/task link to taskName VS in links toolbar,</li>
<li><span style="background-color: #ffff99;">[*] use of code inside code block, example nested if statement, 2nd if requres @{&nbsp; ... } wrapper</span></li>
<li><span style="background-color: #ffff99;"><span style="background-color: #ffffff;">[] </span> <br /></span></li>
</ol></ol>
<h2>[next]</h2>
<ol>
<li><strong>[00:00] NEW task IN TODO</strong></li>
<ol>
<li>[x] content is left aligned -</li>
<li>[] heading styles -</li>
<li>[x] stats bar - location</li>
<li>[x] stats bar - style</li>
<li>[i] stats bar - functionality</li>
<li>[x] why are 'heading's that have no content displaying -</li>
<li>[i] database - update VIEW on OTHER DATABAseS, - [x] dons, [] ewa, []</li>
</ol>
<li><strong>&nbsp;[00:00] NEW task IN </strong></li>
<ol>
<li>[] # # - <a href="/view/task?id=1839" target="_blank">CREATE-task# # </a>-</li>
<li>[] bio - all</li>
<li>===</li>
<li>[] bio - by calendar</li>
<li>[] bio - by plan/document</li>
<li>[] bio - by taskgroup</li>
<li>===</li>
<li>[] bio - by period - ( day, month, week, quarter, )</li>
<li>[] bio - by period - custom</li>
</ol></ol>
<h2>[reference]</h2>
<div><ol>
<li>[*] sospep public - # 4900 - feature definition</li>
</ol></div>
<hr />
<h1 style="text-align: center;">query</h1>
<p style="text-align: left;">SELECT * FROM `view_p1` WHERE priority = -5 and status = 'Completed'</p>
<p style="text-align: left;">&nbsp;</p>
<h1 style="text-align: center;">create view</h1>
<div><br />0 - example = CREATE VIEW view_p1 AS SELECT * FROM tasks t, taskgroups tg WHERE tasks.priority = -1 JOIN tg on tasks.parent_id = tg.id_taskgroup <br /><br /><br />1 - PASS = SELECT * FROM tasks JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup WHERE tasks.priority = -1 ;<br /><br />1.1 - PASS = SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup FROM tasks JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup WHERE tasks.priority = -1 <br /><br />1.2 - PASS = SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup, plans.id_plan, plans.name_plan <br />FROM tasks JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup JOIN plans ON taskgroups.parent_id = plans.id_plan WHERE tasks.priority = -1 <br /><br />1.3 - PASS = SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup, plans.id_plan, plans.name_plan, calendars.id_calendar, calendars.name_calendar <br />FROM tasks <br />JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup <br />JOIN plans ON taskgroups.parent_id = plans.id_plan <br />JOIN calendars ON plans.parent_id = calendars.id_calendar <br />WHERE tasks.priority = -1<br /><br />1.4 - PASS = <br /><br />CREATE VIEW view_p1 SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup, plans.id_plan, plans.name_plan, calendars.id_calendar, calendars.name_calendar <br />FROM tasks <br />JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup <br />JOIN plans ON taskgroups.parent_id = plans.id_plan <br />JOIN calendars ON plans.parent_id = calendars.id_calendar <br />WHERE tasks.priority = -1 AND tasks.status &lt;&gt; "Completed";<br />&nbsp; <br /><strong>1.5 =</strong> <br />CREATE VIEW view_p1 AS SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup, plans.id_plan, plans.name_plan, calendars.id_calendar, calendars.name_calendar <br />FROM tasks <br />JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup <br />JOIN plans ON taskgroups.parent_id = plans.id_plan <br />JOIN calendars ON plans.parent_id = calendars.id_calendar;</div>
<div><strong>1.6 = [] ADDing fields to view -</strong><br />- AS parent_id_plan, <br />- AS parent_id_taskgroup <br /><br />CREATE VIEW view_p1 AS SELECT tasks.*, taskgroups.id_taskgroup, taskgroups.name_taskgroup, taskgroups.parent_id AS parent_id_taskgroup, plans.id_plan, plans.name_plan, plans.parent_id AS parent_id_plan, calendars.id_calendar, calendars.name_calendar<br />FROM tasks<br />JOIN taskgroups ON tasks.parent_id = taskgroups.id_taskgroup<br />JOIN plans ON taskgroups.parent_id = plans.id_plan<br />JOIN calendars ON plans.parent_id = calendars.id_calendar;</div>
<div><hr /></div>
<div>displaying groups</div>
<div>- EDITed code on parent_id</div>
<div>- TO&nbsp; if (plan.parent_id_plan == calendar.id_calendar){</div>
<div><hr /></div>
<h1 style="text-align: center;">create query</h1>
<div>[] my groups - using order by in query to get dessired grouping, WORKS but very slow&nbsp; <br /><br />SELECT * FROM view_p1 WHERE priority=@0 &amp;&amp; status=@1 ORDER by name_calendar ASC, name_plan ASC, name_taskgroup ASC <br />SELECT * FROM view_p1 WHERE priority= -1 &amp;&amp; status='Completed' ORDER by name_calendar ASC, name_plan ASC, name_taskgroup ASC;</div>
<div><hr /></div>
<div>[] 2019-10-30 <br />[] FIX ISSUE - ERROR missing bracket<br />[] TEST appears to be in div displayList <br />[] removed some razor comments<br />[] bracket matching, i think i found and eliminated the extra <br />[] TEST = PASS BUT - page loads, BUT no results<br /><br />[] FIX ISSUE = no results display on page <br />[] CAUSE - suspect = view on database wasn't created properly<br />[] TRY =&nbsp; <br />[] RESOLUTION - created new view ,<br />[]</div>

~ view task ~ TaskGroup] DB FROM [ Plan] plan-projects IN [ calendars] prj-022-sospep