search

JaminQuimby / AWS

AWS
1 stars 0 forks source link

Task Status Updates - Text and Color Coding #29

Closed emidas closed 10 years ago

emidas commented 10 years ago

Add an expand-all button to each module's form

Add green color coding to the labels on each expanding module when the corresponding completed date is filled in

The date and completed by initials are to show on the expanding module's label

"Obtain information - 11/27/13 - MDB"

JaminQuimby commented 10 years ago

Added expand button.

JaminQuimby commented 10 years ago

Sample query for testing

<!--- Asset GUI Completed Tasks--->
<cfcase value="assetCompTask">
<cfquery datasource="AWS" name="fQuery">
SELECT[of_obtaininfo_datecompleted]=CONVERT(VARCHAR(10),of_obtaininfo_datecompleted,101)
,[of_obtaininfo_completedbyTEXT]=(SELECT TOP(1)[si_initials]FROM[staffinitials]WHERE(of_obtaininfo_completedby=[user_id]))
,[of_preparation_datecompleted]=CONVERT(VARCHAR(10),of_preparation_datecompleted,101)
,[of_preparation_completedbyTEXT]=(SELECT TOP(1)[si_initials]FROM[staffinitials]WHERE(of_preparation_completedby=[user_id]))
,[of_review_datecompleted]=CONVERT(VARCHAR(10),of_review_datecompleted,101)
,[of_review_completedbyTEXT]=(SELECT TOP(1)[si_initials]FROM[staffinitials]WHERE(of_review_completedby=[user_id]))
,[of_assembly_datecompleted]=CONVERT(VARCHAR(10),of_assembly_datecompleted,101)
,[of_assembly_completedbyTEXT]=(SELECT TOP(1)[si_initials]FROM[staffinitials]WHERE(of_assembly_completedby=[user_id]))
,[of_delivery_datecompleted]=CONVERT(VARCHAR(10),of_delivery_datecompleted,101)
,[of_delivery_completedbyTEXT]=(SELECT TOP(1)[si_initials]FROM[staffinitials]WHERE(of_delivery_completedby=[user_id]))
FROM[otherfilings]
WHERE[OF_ID]=<cfqueryparam value="#ARGUMENTS.ID#"/>
</cfquery>
</cfcase>

Sample CFM H4 MOD

<h4 onClick='_loadData({"id":"task_id","group":"group1_1","page":"otherfilings"});$("#isLoaded_group1_1").val(1);'>Obtain Info | <span id="g1_g1_head1"></span> | <span id="g1_g1_head2"></span></h4>

Sample JS LoadIT

/*assetCompTask*/case "OF_OBTAININFO_DATECOMPLETED":var list='g1_g1_head1,g1_g1_head2,g1_g2_head1,g1_g2_head2,g1_g3_head1,g1_g3_head2,g1_g4_head1,g1_g4_head2,g1_g5_head1,g1_g5_head2';_loadit({"query":query,"list":list});break;

Add to GRID 1 Load

_loadData({"id":"task_id","group":"assetCompTask","page":"otherfilings"});
JaminQuimby commented 10 years ago
  1. Other Filings complete
JaminQuimby commented 10 years ago

Completed. Deviation from original program. Green color does not mach schema and is not included.