Dong Shin 10.05.11

  • I know I shouldn’t have, but went ahead and updated to the Flash Player 11.0. It kept crashing in Firefox. Not just the our software, but Adobe’s as well. Chrome uses the version 11.0 and it looks ok. Well, going back to the version 10.
  • The problem I have had with ADL (Adobe Air Debug Launcher) for the mobile apps turned out to be related to the FlashFireBug plugin. mm.cfg file in my home directory is set to pre-load the plugin swf on start up. Somehow it messes up the ADL…. Set the PreloadSWF field to empty, and now it runs. I had to remove the plugin completely because it tries to fill the field again and when it did, it messed up the ADL again.
  • working on retrieving obligations/outlays data
    • created view for financial data – this allows to retrieve the data in one-shot.
    • CREATE
      ALGORITHM = UNDEFINED
      VIEW `project_obligations_outlays`
      AS       SELECT
      p.uid as p_uid,
      p.project_number as p_project_number,
      p.title as p_title,
      p.exec_summary as p_exec_summary,
      p.description as p_description,
      p.location as p_location,
      p.begin_year as p_begin_year,
      p.end_year as p_end_year,
      p.total_budget as p_total_budget,
      p.proj_mgr_login as p_proj_mgr_login,
      p.proj_admin_login as p_proj_admin_login,
      p.portfolio_mgr_login as p_portfolio_mgr_login,
      p.portfolio_admin_login as p_portfolio_admin_login,
      p.priority as p_priority,
      p.services as p_services,
      p.TRL_start as p_TRL_start,
      p.TRL_current as p_TRL_current,
      p.TRL_end as p_TRL_end,
      p.TCL_start as p_TCL_start,
      p.TCL_current as p_TCL_current,
      p.TCL_end as p_TCL_end,
      p.TP_start as p_TP_start,
      p.TP_current as p_TP_current,
      p.TP_end as p_TP_end,
      p.lock_id as p_lock_id,
      p.lock_time as p_lock_time,
      c.uid as c_uid,
      c.project_id as c_project_id,
      c.center_number as c_center_number,
      c.center_name as c_center_name,
      c.funding_transaction_name as c_funding_transaction_name,
      c.funding_transaction_number as c_funding_transaction_number,
      c.funding_transaction_type as c_funding_transaction_type,
      c.capability as c_capability,
      c.expenditure_center as c_expenditure_center,
      c.investment_portfolio as c_investment_portfolio,
      c.appropriation as c_appropriation,
      c.total_budget as c_total_budget,
      c.type as c_type,
      c.program_element as c_program_element,
      c.facts_pe as c_facts_pe,
      a.uid as a_uid,
      a.year as a_year,
      a.amount as a_amount,
      a.status_amount as a_status_amount,
      a.budget_center_id as a_budget_center_id,
      a.last_updated as a_last_updated,
      o.uid as o_uid,
      o.type as o_type,
      o.description as o_description,
      o.year as o_year,
      o.year_count as o_year_count,
      o.project_id as o_project_id,
      o.funding_id as o_funding_id,
      o.month_1 as o_month_1,
      o.month_1 as o_month_2,
      o.month_1 as o_month_3,
      o.month_1 as o_month_4,
      o.month_1 as o_month_5,
      o.month_1 as o_month_6,
      o.month_1 as o_month_7,
      o.month_1 as o_month_8,
      o.month_1 as o_month_9,
      o.month_1 as o_month_10,
      o.month_1 as o_month_11,
      o.month_1 as o_month_12

      FROM `projects` p,
      budget_centers c,
      budget_amounts a,
      obligations_outlays o
      WHERE p.uid = c.project_id
      AND c.uid = a.budget_center_id
      AND o.funding_id = c.uid
      AND a.year = o.year_count
      ORDER BY o.uid