{
	"name": "grid/manager/product/product_work/workpost/phase_column.json",
	"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": "ordr.order_id",
			"width": 68,
			"name": "Ostotilaus",
			"enterable": 1
		},
		{
			"field": "ordr.json_data.confirmation_state",
			"width": 68,
			"name": "OTR v.",
			"enterable": 1
		},
		{
			"field": "ordr.order_amount",
			"width": 68,
			"name": "Til.",
			"enterable": 1
		},
		{
			"field": "ord.company_id",
			"width": 68,
			"name": "Toimittaja",
			"enterable": 1
		}
	],
	"columns": [
		{
			"field": "prwo.work_phase_number",
			"width": 10,
			"name": "Vaihe",
			"enterable": 1
		},
		{
			"width": 40,
			"cellGraphFormatter": {
				"percent_max": 30,
				"html": "<svg width='100%' height='100%'><rect x='{{x}}%' y='5%' height='90%' width='{{size}}%' fill='{{color}}'></rect><text dy='75%'>{{value}}</text></svg>",
				"percent_color": [
					{
						"end": 0,
						"color": "red"
					},
					{
						"start": 0,
						"end": 7,
						"color": "orange"
					},
					{
						"start": 7,
						"end": 30,
						"color": "lightgreen"
					},
					{
						"start": 30,
						"color": "MediumSeaGreen"
					}
				],
				"negative_from_end": true
			},
			"field": "prwo.remaining_amount",
			"cssClass": "gridGraph",
			"name": "Jäljellä"
		},
		{
			"width": 26,
			"cellGraphFormatter": {
				"value_color": [
					{
						"end": 0,
						"color": "none"
					},
					{
						"start": 0,
						"end": 1,
						"color": "none"
					},
					{
						"start": 1,
						"end": 2,
						"color": "orange"
					},
					{
						"start": 2,
						"end": 3,
						"color": "lightgreen"
					},
					{
						"start": 3,
						"end": 4,
						"color": "DarkGrey"
					},
					{
						"start": 4,
						"color": "red"
					}
				],
				"html": "<svg width='100%' height='100%'><circle cx='50%' cy='50%' r='0.5em' fill='{{color}}'></circle></svg>"
			},
			"field": "prwo.json_data.track_time_status",
			"cssClass": "gridGraph",
			"name": "Ohja."
		},
		{
			"field": "prwo.resource_id",
			"width": 30,
			"name": "Kuor.",
			"enterable": 1
		},
		{
			"field": "prwo.product_work_state",
			"width": 25,
			"name": "Luk.",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.subcontract",
			"width": 20,
			"name": "AH.",
			"enterable": 1
		},
		{
			"field": "prwo.work_phase_state",
			"width": 20,
			"name": "Tila",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.subtype",
			"width": 35,
			"name": "Alatila",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.start_time",
			"width": 40,
			"name": "Alku pv",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.end_time",
			"width": 40,
			"name": "Loppu pv",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.critical_delayed_end_date",
			"width": 50,
			"name": "Vaih. eräpv",
			"enterable": 1
		},
		{
			"field": "prwo.remaining_amount",
			"width": 40,
			"name": "Jälj.",
			"enterable": 1
		},
		{
			"field": "prwo.extra_hours",
			"width": 55,
			"name": "Lisäaika",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.work_time",
			"width": 55,
			"name": "Työaika",
			"enterable": 1
		},
		{
			"headerBackColor": -2,
			"width": 63,
			"lineBackColor": -2,
			"field": "pro.company_id",
			"lineForeColor": -2,
			"name": "Asiakas",
			"headerForeColor": -2
		},
		{
			"fieldX": [
				"prwo.json_data.critical_delayed_end_date",
				"-",
				"prwo.json_data.end_time"
			],
			"enterable": 1,
			"field": "prwo.json_data.urgency_index",
			"name": "Kiireellisyys",
			"width": 55
		}
	],
	"old": [
		{
			"field": "prwo.description",
			"width": 77,
			"name": "Työnkuvaus",
			"enterable": 1
		},
		{
			"headerBackColor": -2,
			"width": 48,
			"lineBackColor": -2,
			"field": "pro.production_order_state",
			"lineForeColor": -2,
			"name": "Tm tila",
			"headerForeColor": -2
		},
		{
			"width": 65,
			"enterable": 1,
			"field": "prwo.json_data.production_lot__work_ph",
			"name": "Tm/työvaihe",
			"footerValue": "/O1"
		},
		{
			"field": "prwo.work_phase_number",
			"width": 40,
			"name": "Työvaihe",
			"enterable": 1
		},
		{
			"field": "prwo.work_phase_state",
			"width": 21,
			"name": "Tila",
			"enterable": 1
		},
		{
			"width": 47,
			"enterable": 1,
			"field": "prwo.remaining_amount",
			"name": "Jäljellä",
			"footerValue": "==Sum"
		},
		{
			"field": "prwo.json_data.critical_start_time",
			"width": 62,
			"name": "Kr. alkupv",
			"enterable": 1
		},
		{
			"width": 66,
			"enterable": 1,
			"field": "prwo.json_data.critical_start_time",
			"name": "Kr. alkuaika",
			"format": "&/1"
		},
		{
			"field": "prwo.json_data.critical_end_time",
			"width": 58,
			"name": "Kr. pv",
			"enterable": 1
		},
		{
			"width": 57,
			"enterable": 1,
			"field": "prwo.json_data.critical_end_time",
			"name": "Kr. aika",
			"format": "&/1"
		},
		{
			"field": "prwo.json_data.critical_extra_end_time",
			"width": 69,
			"name": "Kr. lisäajan pv",
			"enterable": 1
		},
		{
			"width": 58,
			"enterable": 1,
			"field": "prwo.json_data.critical_extra_end_time",
			"name": "Kr. lisäaika",
			"format": "&/1"
		},
		{
			"field": "prwo.json_data.critical_delayed_end_date",
			"width": 62,
			"name": "Kr. pv. viiv.",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.critical_date_difference",
			"width": 64,
			"name": "Kr. pv:n ero",
			"enterable": 1
		},
		{
			"field": "prwo.json_data.subcontract",
			"width": 27,
			"name": "Alih.",
			"enterable": 1
		},
		{
			"width": 41,
			"enterable": 1,
			"field": "prwo.json_data.work_time",
			"name": "Työaika",
			"footerValue": "==Sum"
		},
		{
			"width": 43,
			"enterable": 1,
			"field": "prwo.extra_hours",
			"name": "Lisäaika",
			"footerValue": "==Sum"
		},
		{
			"field": "prwo.json_data.start_time",
			"width": 52,
			"name": "Alkupäivä",
			"enterable": 1
		},
		{
			"width": 46,
			"enterable": 1,
			"field": "prwo.json_data.start_time",
			"name": "Alkuaika",
			"format": "&/1"
		},
		{
			"field": "prwo.json_data.end_time",
			"width": 59,
			"name": "Loppupäivä",
			"enterable": 1
		},
		{
			"width": 53,
			"enterable": 1,
			"field": "prwo.json_data.end_time",
			"name": "Loppuaika",
			"format": "&/1"
		},
		{
			"field": "prwo.json_data.extra_end_time",
			"width": 55,
			"name": "Lis. lop pv",
			"enterable": 1
		},
		{
			"width": 52,
			"enterable": 1,
			"field": "prwo.json_data.extra_end_time",
			"name": "Lis. l. aika",
			"format": "&/1"
		}
	]
}