Category Archives: Dong Shin

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!

Dong Shin 11.19.2014

  • modifying __view_project_detailed_data to use the REGEXP for po_reference column – done
  • working on Direct Cite/Reimbursable queries..
  • created scripts to start project_portfolio_enh database (bare minimum to start up)
    • src/resources/database/project_portfolio_enh_inserts.sql
    • src/resources/database/new_project.sql
    • src/resources/database/project_enh.111914.philsdata.zip
    • src/resources/database/project_portfolio_enh_clean.sql
  • missing Appropriations in server side Reqonciler Processing, this may have caused incorrect mapping of the COGNOS summary data for Outlays?
    • put back in ContractParser.java

Dong Shin 11.18.2014

  • working on master table to include required fields for Direct Cite/Reimbursable processing
    • query to summarize Direct Cite/Reimbursable
    • SELECT GROUP_CONCAT(requisition_id),
      MAX(obligation_date) AS obligation_date,
      MAX(expensed_date) AS expensed_date,
      SUM(obligated_amount) AS total_obligated_amount,
      SUM(expensed_amount) AS total_expensed_amount,
      SUM(IF(po_reference LIKE ‘HH98230%’,obligated_amount,0)) AS reimbursable_obligated_amount,
      SUM(IF(NOT po_reference LIKE ‘HH98230%’,obligated_amount,0)) AS direct_cite_obligated_amount,
      SUM(IF(po_reference LIKE ‘HH98230%’,expensed_amount,0)) AS reimbursable_expensed_amount,
      SUM(IF(NOT po_reference LIKE ‘HH98230%’,expensed_amount,0)) AS direct_cite_expensed_amount
      FROM budget_center_contracts
      WHERE NOT ISNULL(budget_center_id)
      GROUP BY budget_center_id;
    • REGEXP
    • SELECT po_reference, IF( po_reference REGEXP ‘^H98230-[0-9][0-9][0-9][0-9][0-9][0-9]’, ‘REIMBURSABLE’, ‘DIRECT CITE’) FROM `budget_center_contracts`
  • fixed RA not enabling PM Actuals in current month
  • deployed new FA/RA with updated __view_project_detailed_data
    • need to tweak how to determine Direct Cite/Reimbursable
  • discussed how to show Direct Cites/Reimbursables
    • should show in Scripting and/or Visibility
    • group by Budget Centers (Capabilities – ACC, GCC) and individual contracts/req along with totals