Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 12.18.2014

  • discussion with Lenny today
    • add fund type (Base/OCO) to COGNOS data, a script that updates the current data as well.
    • ignore duplicate Obligations is for EA only
      • EA now has matching Req ID in COGNOS
      • When Budget Center <> Executing Budget Center = EA

Dong Shin 12.11.2014

  • working on Query Builder (AngularJS)
    • added export to CSV, PDF to query result grid
    • created a user specific to project_portfolio_enh database – fa_user, create_user.sql
      • SELECT, INSERT, UPDATE, DELETE previleges
    • queries.sql – table to store queries
    • load query – done
    • run query – done
    • save – done
  • working on User Management
    • current user info page
    • change password

Dong Shin 12.08.2014

  • working on FiancialAssistant (AngularJS) to talk to FinancialAssistantService (Java)
    • set up ui-router to move between states
    • login is default state
    • set up FinancialAssistant to deploy Tomcat’s wtpwebapps directory (Java project run/debug location)
    • login working!

Dong Shin 12.05.2014

  • Web Development Using Spring and AngularJS Tutorials – very long and helpful!
    • Spring, Hibernate, Spring Security
    • grunt (watch), ng-boilerplate, ui-router(state changes), ngroute, ng-resource, build
    • getting the master example/tutorial to work – maven project!
      1. dependencies
        • <dependency>
          <groupId>org.springframework.security</groupId>
          <artifactId>spring-security-web</artifactId>
          <version>3.2.5.RELEASE</version>
          </dependency>
          <dependency>
          <groupId>org.springframework.security</groupId>
          <artifactId>spring-security-config</artifactId>
          <version>3.2.5.RELEASE</version>
          </dependency>
          <dependency>
          <groupId>org.aspectj</groupId>
          <artifactId>aspectjweaver</artifactId>
          <version>1.7.4</version>
          </dependency>
        •  Screenshot 2014-12-05 18.40.47
      2. add component scan to business-config.xml – tutorial.core.security
      3. create tutorial.core.security.SecurityWebAppInitializer class
      4. create tutorial.core.security.SecurityConfig class
        • @Configuration, @EnableWebSecurity
        • configAuthBuilder() – where the authentication happens!
      5. create tutorial.core.security.AuthFailure class to return response.setStatus(HttpServletResponse.SC_UNAUTHORIZED)
      6. create tutorial.core.security.AuthSucess to return response.setStatus(HttpServletResponse.SC_OK)
      7. add AuthFailure and AuthSuccess to SecurityConfig (@Autowired)
      8. add configure() method to SecurityConfig – configuation
        • add AuthFailure and AuthSuccess
        • JSESSIONID will be added to client – expires after 30min
      9. tutorial.core.security.EntryPointUnauthorizedHandler class
        1. add commence method
      10. add EntryPointUnauthorizedHandler to SecurityConfig
      11. add AccountUserDetails and UserDetailServiceImpl classes and add to configAuthBuilder() method in SecurityConfig
      12. modify sessionService, LoginCtrl in account.js
      13. use SecurityContextHolder (AccountController class) to get current user details for further processing
        1. throw Forbidden exception
      14. whitelist access –
        • security:protect-pointcut in mvc-dispacher-servlet.xml
        • @PreAuthorize(“permitAll”)

Dong Shin 12.03.2014

  • trouble shooting javaUtils – need to find the change dated 04/19/2014
  • discussion on Direct Cite/Reimbursable – By capability, project
  • added more currency fields to Query Builder
  • working on Monthly Status Query

Dong Shin 11.24.2014

  • on-site
    • cleaned up COGNOS data so that correct appropriations are mapped
    • deployed new FinancialAssistant.jar with appropriation fix
    • sanity checked new data upload
    • Lenny will upload complete (?) data set
  • AngularJS
    • working on SQL Editor – send up queries and display results!