edit-task
Home
Up
Delete
Task Name:
Task Description:
jobs listing site, curates jobs from multiple sources in multiple countries, has revenue stream for content publishers,
TaskGroup ID:
Start Date:
Start Time:
Duration:
Priority:
Status:
To Do
Completed
In Process
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">CREATE-task# # -</h1> <h1 style="text-align: center;">FEATURE-000n-view-buying - porting to .org</h1> <h2>[previously]</h2> <ol> <li><strong>[00:00] NEW task IN </strong></li> <ol> <li>[] # 2919 - <a href="/view/task?id=2919" target="_blank">CREATE-task# # </a>- ADD-FEATURE - view buying - port - ] porting the view / buying functionality into the .org version</li> <li>[*] reference example = # 2793 - <a href="/view/task?id=2793" target="_blank">CREATE-task# #</a> -FEATURE-4900-view-bio - porting to .org - currently the MyStuff/Bio feature is not functional</li> <li>[] TLDR - 'view buying' should show 'all' 'items' that have a status value of "Need" ( and a Priaaority value of "" )</li> <li>[] these items are then organized by the warehouse, inventory and itemgroup that they appear in, aka bio_by_project, [*] based on view_priority (actually uses db viewPriority </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>[x] # # - FEATURE view/buying - server error on page load</li> <li>[x] ISSUE-001 - error of @Session VS Session</li> </ol> <li><strong>[00:00] NEW task IN</strong></li> <ol> <li>[x] EDIT PAGE - view buying - save copy of original/current version to deprecate</li> </ol> <li><strong>[00:00] NEW Task IN - database<br /></strong></li> <ol> <li>[x] EDIT db - .org - added new view_buying view, as per sql below</li> <li>[x] EDIT db - dons - added new view_buying, renamed orig table as prev_view_buying, ] delete ?</li> <li>[]</li> </ol> <li><strong>[00:00] NEW task IN - UPDATES</strong></li> <ol> <li>[x] added isAuthenticated check on 'display' "edit links toolbar",</li> <li>[x] moved view/task link to taskName VS in "edit links toolbar",</li> <li><span style="background-color: #ffff99;">[*] use of code inside code block, example nested if statement, 2nd if requres @{ ... } wrapper</span></li> </ol> <li><strong>>[00:00] NEW task IN - CLOSE <br /></strong></li> <ol> <li>[x] REM OVEd - case statement for cases based on IF called from plan, see below</li> </ol> <li><strong>[00:00] NEW task IN - *</strong></li> <ol> <li>[x] not seeing issue-002 - database view_buying</li> <li>[x] not seeing issue-003 - view missing required column</li> <li>[x] not seeing issue-005 - headings with no content</li> </ol> <li><strong>[] [00:00] NEW task IN - stats bar - location and style<br /></strong></li> <ol> <li>[x] used NEW statsBarBio AS example</li> <li>[x] in NEW LOCATION = relocated it to directly below navHeader, [x] removed current style of "statsbar" (used absolute postioning),</li> <li>[x] created AS _statsBarBuying = itemsCount, itemsTotalCOST,</li> </ol> <li><strong>[00:00] NEW task IN - refactor</strong></li> <ol> <li>[x] removed unused vars</li> <li>[x] re ordered vars</li> <li>[x] renamed vars</li> <li>[] notes in source comments</li> </ol> <li><strong>[] NEW task IN - add view for single warehouse by name<br /></strong></li> <ol> <li>[x] add case "warehouse" where we can get view_buying for just a single warehouse</li> <li>[x] add 4th parameter as warehouse name</li> <li>[x] http://sospep.org/view/buying/warehouse/Want/1/nations</li> </ol> <li><strong>[00:00] NEW task IN - review</strong></li> <ol> <li>[] dont seem to see/find any documentation for view/buying OR view/selling </li> <li>[] </li> </ol></ol> <div><hr /></div> <ol> <li><strong>[] >[00:00] NEW task IN - ISSUE-007 - stats bar functionality<br /></strong></li> <ol> <li>[] # # - [] 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 (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> [] [00:00] NEW task IN - git commit & merge</strong></li> <ol> <li>[x] commit -m = {"ADD-FEATURE - bio - porting feature functionality from original sospep.com version"}</li> <li>[x] git local commited branch(ADD-FEATURE-bio)</li> <li>[x] merged branch into master</li> </ol></ol> <h2>[currently]</h2> <ol> <li> <strong>[00:00] NEW task IN </strong></li> <ol> <li>[] # # -</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] public [x] dons, [] ewa, [] other(s) ,</li> </ol> <li><strong> [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;">SELECT * FROM view_buying WHERE status = Want || NEED ||</p> <p style="text-align: left;">and priority =</p> <p style="text-align: left;"> </p> <h1 style="text-align: center;">create view</h1> <p><br /><br />[] rewriting view_priorities as view BUYING<br /><br />CREATE VIEW view_buying AS SELECT items.*, itemcategories.id_itemCategory, itemcategories.name_itemCategory, itemcategories.parent_id AS parent_id_itemCategory, inventories.id_inventory, inventories.name_inventory, inventories.parent_id AS parent_id_inventory, warehouses.id_warehouse, warehouses.name_warehouse<br />FROM items<br />JOIN itemcategories ON items.parent_id = itemcategories.id_itemCategory<br />JOIN inventories ON itemcategories.parent_id = inventories.id_inventory<br />JOIN warehouses ON inventories.parent_id = warehouses.id_warehouse;</p> <p> </p> <div><hr /></div> <div>displaying groups</div> <div>- EDITed code on parent_id</div> <div>- TO 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 <br /><br />SELECT * FROM view_p1 WHERE priority=@0 && status=@1 ORDER by name_calendar ASC, name_plan ASC, name_taskgroup ASC <br />SELECT * FROM view_p1 WHERE priority= -1 && 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 = <br />[] RESOLUTION - created new view ,<br />[]</div> <div><hr /></div> <h1 style="text-align: center;">[] logic blocks from view buying</h1> <div>// LOGIC BL 1 - to build qry's IF called from viewCalendar's<br /> if (planId=="000")<br /> { // put code here for CAL <br /> if (String.IsNullOrEmpty(status1))<br /> {<br /> selectQuery = "select * from tasks where parent_id IN (select id_taskgroup from taskgroups where parent_id IN (select id_plan from plans where parent_id=@0))";<br /> var tasks=db.Query(selectQuery,Parent);<br /> msg ="planId= 000 and no status";<br /> Page["tasks"] = tasks;<br /> } <br /> <br /> if (!String.IsNullOrEmpty(status1))<br /> {<br /> // EX selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) && status IN(@1) ORDER by name_task ASC";<br /> selectQuery = "select * from tasks where parent_id IN (select id_taskgroup from taskgroups where parent_id IN (select id_plan from plans where parent_id=@0)) && status IN(@1) ";<br /> var tasks= db.Query(selectQuery,parent_id, status1);<br /> msg ="parentid 000 and HAS status";<br /> Page["tasks"] = tasks;<br /> } <br /> }<br /> <br /> // LOGIC BL 2 - to build qry IF called from viewPlan's<br /> if (parent_id=="000")<br /> { <br /> // WORKs -this means 1] we dont know the tgr id bc this page is being called from a higher level, ie PLAN or CAL<br /> // msg ="test IF tgr is 000 YES it is, the PLAN Id is: "+planId;<br /> // - this means 1] we dont know the plan id bc this page is being called from a higher level ie CAL<br /> <br /> //TRY 002 will just add IF statement and use selectQry1 IF */<br /> if (String.IsNullOrEmpty(status1))<br /> {<br /> selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) && status IN('Completed','To-Do','In-Process') ORDER by name_task ASC";<br /> // selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) ORDER by name_task ASC";<br /> var tasks=db.Query(selectQuery,planId);<br /> msg ="parentid 000 and no status";<br /> Page["tasks"] = tasks;<br /> } <br /> <br /> if (!String.IsNullOrEmpty(status1))<br /> {<br /> selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) && status IN(@1) ORDER by name_task ASC";<br /> var tasks= db.Query(selectQuery,planId, status1);<br /> msg ="parentid 000 and HAS status";<br /> Page["tasks"] = tasks;<br /> } <br /> }<br /> <br /> // LOGIC BL 3 - to build qry's IF called from viewTaskGroups<br /> if (!String.IsNullOrEmpty(status1) && parent_id !="000" && planId !="000")<br /> {<br /> selectQuery = "SELECT * FROM tasks WHERE parent_id=@0 && status IN(@1) ORDER by name_task ASC";<br /> // REV fea 001 <br /> // selectQuery = "SELECT * FROM tasks WHERE parent_id IN(@0) && status IN(@1) ORDER by name_task ASC"; // NOT WORKING PRB with params<br /> // try ### subqry<br /> // selectQuery= "SELECT * FROM tasks WHERE parent_id IN (SELECT id_taskgroup from taskgroups where parent_id=@0 ) && status IN(@1) ORDER by name_task ASC";<br /> var tasks= db.Query(selectQuery,parent_id, status1);<br /> msg ="parentid NOT 000 and HAS status" ;<br /> Page["tasks"] = tasks;<br /> } <br /> <br /> <br /> /*<br /> // LOGIC BL 0044 - to build qry's IF called from viewTaskGroups and NOT from search page<br /> if (String.IsNullOrEmpty(status1) && parent_id !="000" && planId !="000" && Request["qry"].IsEmpty()){<br /> //selectQuery= "SELECT * FROM view_priority";<br /> selectQuery= "SELECT * FROM view_priority WHERE priority=@0 and parent_id=@1";<br /> // var tasks=db.Query(selectQuery,parent_id,-2);<br /> var tasks=db.Query(selectQuery,Priority,parent_id);<br /> <br /> // var sqlQ= "select name_taskgroup from taskgroups where id_taskgroup=parent_id"<br /> <br /> //var sqlQcalendars="select * from calendars";<br /> //var sqlQcalendars= "SELECT id_calendar,name_calendar from view_priority GROUP BY id_calendar ORDER BY name_calendar ASC";<br /> var sqlQcalendars= "SELECT id_calendar,name_calendar,id_plan,name_plan,id_taskgroup,name_taskgroup from view_priority GROUP BY id_calendar ORDER BY name_calendar ASC";<br /> var sqlQplans= "SELECT id_plan,name_plan,plan_parent_id from view_priority GROUP BY id_plan ORDER BY name_plan ASC";<br /> var sqlQtaskgroups= "SELECT id_taskgroup,name_taskgroup, parent_id_taskgroup from view_priority GROUP BY id_taskgroup ORDER BY name_taskgroup ASC";<br /> // var sqlQgroups = "SELECT id_taskgroup,name_taskgroup FROM view_priority GROUP BY id_taskgroup"; <br /> var calendars=db.Query(sqlQcalendars);<br /> var plans = db.Query(sqlQplans);<br /> var taskgroups = db.Query(sqlQtaskgroups);<br /> <br /> Page["tasks"] = tasks;<br /> Page["calendars"]= calendars; <br /> Page["plans"] = plans;<br /> Page["taskgroups"]=taskgroups;<br /> <br /> msg ="HELLO WORLD! FROM status=Null, parentid !='000' and planId !='000' && Request['qry'].IsEmpty "; <br /> }<br /> */<br /> <br /> // LOGIC - BL 005 - <br /> // Feature - 802 - Search Events by Feild MODIFIED for viewPriority IN Taskgroup/<br /> // if (!Request["qry"].IsEmpty()){</div>