{
  "columns": [
    {
      "field": "wos_work_phase",
      "width": 10,
      "name": "Vaihe",
      "enterable": 1
    },
    {
      "field": "wos_remaining_amount",
      "width": 40,
      "name": "Jäljellä",
      "cellGraphFormatter": {"html": "<svg width='100%' height='100%'><rect x='{{x}}%' y='5%' height='90%' width='{{size}}%' fill='{{color}}'></rect><text dy='75%'>{{value}}</text></svg>", "negative_from_end": true, "percent_max": 30, "percent_color": [{"color": "red", "end": 0}, {"color": "orange", "start": 0, "end": 7}, {"color": "lightgreen", "start": 7, "end": 30}, {"color": "MediumSeaGreen", "start": 30}]},
      "cssClass": "gridGraph"
    },
    {
      "field": "wos_track_time_status",
      "width": 26,
      "name": "Ohja.",
      "cellGraphFormatter": {"html": "<svg width='100%' height='100%'><circle cx='50%' cy='50%' r='0.5em' fill='{{color}}'></circle></svg>", "value_color": [{"color": "none", "end": 0}, {"color": "none", "start": 0, "end": 1}, {"color": "orange", "start": 1, "end": 2}, {"color": "lightgreen", "start": 2, "end": 3}, {"color": "DarkGrey", "start": 3, "end": 4}, {"color": "red", "start": 4}]},
      "cssClass": "gridGraph"
    },
    {
      "field": "wos_work_load_group_id",
      "width": 30,
      "name": "Kuor.",
      "enterable": 1
    },
    {
      "field": "wos_state",
      "width": 25,
      "name": "Luk.",
      "enterable": 1
    },
    {
      "field": "wos_subcontract",
      "width": 20,
      "name": "AH.",
      "enterable": 1
    },
    {
      "field": "wos_work_phase_state",
      "width": 20,
      "name": "Tila",
      "enterable": 1
    },
    {
      "field": "wos_subtype",
      "width": 35,
      "name": "Alatila",
      "enterable": 1
    },
    {
      "field": "wos_start_date",
      "width": 40,
      "name": "Alku pv",
      "enterable": 1
    },
    {
      "field": "wos_end_date",
      "width": 40,
      "name": "Loppu pv",
      "enterable": 1
    },
    {
      "field": "wos_phase_critical_date_delayed",
      "width": 50,
      "name": "Vaih. eräpv",
      "enterable": 1
    },
    {
      "field": "wos_remaining_amount",
      "width": 40,
      "name": "Jälj.",
      "enterable": 1
    },
    {
      "field": "wos_extra_hours",
      "width": 55,
      "name": "Lisäaika",
      "enterable": 1
    },
    {
      "field": "wos_work_time",
      "width": 55,
      "name": "Työaika",
      "enterable": 1
    },
      {
        "headerBackColor": -2,
        "width": 63,
        "lineBackColor": -2,
        "field": "wo_company_id",
        "lineForeColor": -2,
        "name": "Asiakas",
        "headerForeColor": -2
      },
    {
      "field": "wos_urgency_index",
      "fieldX": ["wos_phase_critical_date_delayed", "-", "wos_end_date"],
      "width": 55,
      "name": "Kiireellisyys",
      "enterable": 1
    }
  ],
  "field_not_working": [
    {
      "field": "wos_mat_sub_coming_amount",
      "width": 68,
      "name": "Av.",
      "enterable": 1
    },
    {
      "field": "wos_mat_est_arrival_date",
      "width": 68,
      "name": "Arv. tulop.",
      "enterable": 1
    },
    {
      "field": "por_purchase_order_id",
      "width": 68,
      "name": "Ostotilaus",
      "enterable": 1
    },
    {
      "field": "por_confirmation_state",
      "width": 68,
      "name": "OTR v.",
      "enterable": 1
    },
    {
      "field": "por_order_amount",
      "width": 68,
      "name": "Til.",
      "enterable": 1
    },
    {
      "field": "po_supplier_id",
      "width": 68,
      "name": "Toimittaja",
      "enterable": 1
    }
  ],


  "old": [
    {
      "field": "wos_work_description",
      "width": 77,
      "name": "Työnkuvaus",
      "enterable": 1
    },
    {
      "headerBackColor": -2,
      "width": 48,
      "lineBackColor": -2,
      "field": "wo_state",
      "lineForeColor": -2,
      "name": "Tm tila",
      "headerForeColor": -2
    },
    {
      "width": 65,
      "enterable": 1,
      "field": "wos_production_lot__work_ph",
      "name": "Tm/työvaihe",
      "footerValue": "/O1"
    },
    {
      "field": "wos_work_phase",
      "width": 40,
      "name": "Työvaihe",
      "enterable": 1
    },
    {
      "field": "wos_work_phase_state",
      "width": 21,
      "name": "Tila",
      "enterable": 1
    },
    {
      "width": 47,
      "enterable": 1,
      "field": "wos_remaining_amount",
      "name": "Jäljellä",
      "footerValue": "==Sum"
    },
    {
      "field": "wos_phase_critical_start_date",
      "width": 62,
      "name": "Kr. alkupv",
      "enterable": 1
    },
    {
      "width": 66,
      "enterable": 1,
      "field": "wos_phase_critical_start_time",
      "name": "Kr. alkuaika",
      "format": "&/1"
    },
    {
      "field": "wos_phase_critical_date",
      "width": 58,
      "name": "Kr. pv",
      "enterable": 1
    },
    {
      "width": 57,
      "enterable": 1,
      "field": "wos_phase_critical_time",
      "name": "Kr. aika",
      "format": "&/1"
    },
    {
      "field": "wos_phase_critical_extra_date",
      "width": 69,
      "name": "Kr. lisäajan pv",
      "enterable": 1
    },
    {
      "width": 58,
      "enterable": 1,
      "field": "wos_phase_critical_extra_time",
      "name": "Kr. lisäaika",
      "format": "&/1"
    },
    {
      "field": "wos_phase_critical_date_delayed",
      "width": 62,
      "name": "Kr. pv. viiv.",
      "enterable": 1
    },
    {
      "field": "wos_critical_date_difference",
      "width": 64,
      "name": "Kr. pv:n ero",
      "enterable": 1
    },
    {
      "field": "wos_subcontract",
      "width": 27,
      "name": "Alih.",
      "enterable": 1
    },
    {
      "width": 41,
      "enterable": 1,
      "field": "wos_work_time",
      "name": "Työaika",
      "footerValue": "==Sum"
    },
    {
      "width": 43,
      "enterable": 1,
      "field": "wos_extra_hours",
      "name": "Lisäaika",
      "footerValue": "==Sum"
    },
    {
      "field": "wos_start_date",
      "width": 52,
      "name": "Alkupäivä",
      "enterable": 1
    },
    {
      "width": 46,
      "enterable": 1,
      "field": "wos_start_time",
      "name": "Alkuaika",
      "format": "&/1"
    },
    {
      "field": "wos_end_date",
      "width": 59,
      "name": "Loppupäivä",
      "enterable": 1
    },
    {
      "width": 53,
      "enterable": 1,
      "field": "wos_end_time",
      "name": "Loppuaika",
      "format": "&/1"
    },
    {
      "field": "wos_extra_end_date",
      "width": 55,
      "name": "Lis. lop pv",
      "enterable": 1
    },
    {
      "width": 52,
      "enterable": 1,
      "field": "wos_extra_end_time",
      "name": "Lis. l. aika",
      "format": "&/1"
    }
  ]
}
