UIComponent.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "66848986",
   "metadata": {},
   "source": [
    "## General components"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3a6b8528",
   "metadata": {
    "lines_to_next_cell": 0
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Writing C:\\Anaconda\\Lib\\CropNBalUICompenents.py\n"
     ]
    }
   ],
   "source": [
    "%%writefile C:\\Anaconda\\Lib\\CropNBalUICompenents.py\n",
    "\n",
    "import dash\n",
    "from dash import dash_table\n",
    "from dash import html\n",
    "from dash import dcc\n",
    "import plotly.graph_objects as go\n",
    "import plotly.express as px\n",
    "import datetime as dt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from bisect import bisect_left, bisect_right\n",
    "from jupyter_dash import JupyterDash\n",
    "import dash_bootstrap_components as dbc\n",
    "from dash.dependencies import Input, Output\n",
    "import cufflinks as cf\n",
    "from plotly.offline import download_plotlyjs, init_notebook_mode, plot, iplot\n",
    "import copy\n",
    "import ast\n",
    "\n",
    "Positions = ['Previous_','Current_','Following_']\n",
    "Actions = [\"EstablishDate\", \"HarvestDate\"]\n",
    "\n",
    "CropParams = ['EndUse', 'Group','Colloquial Name', 'Type', 'Family', 'Genus', 'Specific epithet', 'Sub species',\n",
    "       'Typical Establish Stage', 'Typical Establish month', 'Typical Harvest Stage',\n",
    "       'Typical Harvest month', 'Typical Yield', 'Typical Yield Units',\n",
    "       'Yield type', 'Typical HI', 'HI Range',\n",
    "       'Moisture %', 'Typical Dressing Loss %', 'Typical Field Loss %', 'P Root', 'Max RD', 'A cover', 'rCover', 'k_ME',\n",
    "       'Nfixation', 'Root [N]', 'Stover [N]', 'Product [N]','Product [P]', 'Product [K]', 'Product [S]',\n",
    "       'Product [Ca]', 'Product [Mg]', 'Product [Na]', 'Product [Cl]',\n",
    "       'Stover [P]', 'Stover [K]', 'Stover [S]', 'Stover [Ca]', 'Stover [Mg]','Stover [Na]', 'Stover [Cl]']\n",
    "\n",
    "CropConfigs = [\"EndUse\",\"Group\",\"Crop\",\"Type\",\"SaleableYield\",\"Units\",\"FieldLoss\",\"DressingLoss\",\n",
    "               \"MoistureContent\",\"EstablishDate\",\"EstablishStage\",\"HarvestDate\",\"HarvestStage\",\n",
    "               \"ResidueTreatment\",\"EstablishN\",\"DefoliationDates\"]\n",
    "\n",
    "Units = pd.DataFrame(index = ['t/ha','kg/ha'],data=[1000,1],columns=['toKG/ha'])\n",
    "UnitsDropDown = [{'label':i,'value':Units.loc[i,'toKG/ha']} for i in Units.index]\n",
    "\n",
    "Methods = ['Seed','Seedling','Vegetative','EarlyReproductive','MidReproductive','LateReproductive','Maturity','Late']\n",
    "EstablishStageDropdown = [{'label':i,'value':i} for i in Methods[:2]]\n",
    "HarvestStageDropdown = [{'label':i,'value':i} for i in Methods[2:]]\n",
    "\n",
    "ResTreats = pd.DataFrame(index = [\"None\",\"Baled\",\"Burnt\",\"Grazed\",\"Incorporated\"],\n",
    "                                 data = [1.0,0.2,0.1,0.6,1.0], columns = ['propn'])\n",
    "ResidueTreatDropdown = [{'label':i,'value':ResTreats.loc[i,'propn']} for i in ResTreats.index]\n",
    "\n",
    "def splitprops(prop_ID,propExt):\n",
    "    prop_ID = prop_ID.replace(propExt,'')\n",
    "    return prop_ID.split('_')[0]+'_', prop_ID.split('_')[1]\n",
    "\n",
    "def Generalcomponents():\n",
    "    # Read in Crop coefficients table and filter out nasty ones\n",
    "    CropCoefficients = pd.read_excel('C:\\\\GitHubRepos\\\\Overseer-testing\\\\CropCoefficients\\\\CropCoefficientTable.xlsx',skiprows=2, engine='openpyxl')\n",
    "\n",
    "    # Make lists of EndUse options\n",
    "    EndUseCatagories = CropCoefficients.loc[:,'EndUse'].drop_duplicates().dropna().values\n",
    "    EndUseCatagories.sort()\n",
    "\n",
    "    # Make some drop down lists\n",
    "    EndUseCatagoriesDropdown = [{'label':i,'value':i} for i in EndUseCatagories]\n",
    "    CropDropDown = [{'label':i,'value':i} for i in CropCoefficients.index]\n",
    "\n",
    "\n",
    "\n",
    "    # Read in weather data files\n",
    "    LincolnMet = pd.read_csv('C:\\GitHubRepos\\Weather\\Broadfields\\LincolnClean.met',delimiter = '\\t')\n",
    "    LincolnMet.name = 'Lincoln'\n",
    "    GoreMet = pd.read_csv('C:\\GitHubRepos\\Weather\\OtherLocations\\GoreClean.met',delimiter = '\\t')\n",
    "    GoreMet.name = 'Gore'\n",
    "    WhatatuMet = pd.read_csv('C:\\GitHubRepos\\Weather\\OtherLocations\\WhatatuClean.met',delimiter = '\\t')\n",
    "    WhatatuMet.name = 'Napier'\n",
    "    PukekoheMet = pd.read_csv('C:\\GitHubRepos\\Weather\\OtherLocations\\PukekoheClean.met',delimiter = '\\t')\n",
    "    PukekoheMet.name = 'Pukekohe'\n",
    "\n",
    "    #Load met files into dictionary \n",
    "    metFiles ={'Pukekohe':PukekoheMet,'Whatatu':WhatatuMet,'Lincoln':LincolnMet,'Gore':GoreMet}\n",
    "\n",
    "    ## Function to calculate thermal time from temperature\n",
    "    def tt(x,b):\n",
    "        return max(0,x-b)\n",
    "\n",
    "    # Calculate thermal time for each met file and get date in correct format\n",
    "    for f in metFiles.keys():\n",
    "        metFiles[f].loc[:,'Date'] = pd.to_datetime(metFiles[f].loc[:,'Date'])\n",
    "        metFiles[f].loc[:,'tt'] = [tt(x,0) for x in metFiles[f].Temp]\n",
    "        metFiles[f].set_index('Date',inplace=True)\n",
    "\n",
    "    # Make a drop down list with met file options\n",
    "    MetDropDown = [{'label':i,'value':i} for i in metFiles.keys()]\n",
    "\n",
    "    MonthIndexs = pd.DataFrame(index = range(1,13),columns=['Name'],data=['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'])\n",
    "    \n",
    "    return CropCoefficients, EndUseCatagoriesDropdown, metFiles, MetDropDown, MonthIndexs\n",
    "\n",
    "def validateConfigs():\n",
    "    NotSet = 0\n",
    "    for pos in Positions+['field_']:\n",
    "        Config=pd.read_pickle(pos+\"Config.pkl\")\n",
    "        NotSet += Config.isnull().sum()\n",
    "    if NotSet > 0: \n",
    "        return html.Button(\"Update NBalance\",id=\"RefreshButton\",disabled=True,style={'width':'100%','height':'150%',\"font-size\":\"150%\"})\n",
    "    else: \n",
    "        return html.Button(\"Update NBalance\",id=\"RefreshButton\",disabled=False,style={'width':'100%','height':'150%',\"font-size\":\"150%\"})\n",
    "\n",
    "def updateConfig(keys,values,ConfigAddress):\n",
    "    Config = pd.read_pickle(ConfigAddress)\n",
    "    its = range(len(keys))\n",
    "    for i in its:\n",
    "        Config[keys[i]] = values[i]\n",
    "    Config.to_pickle(ConfigAddress)\n",
    "\n",
    "ddStyle = style={\"height\":\"95%\",\"font-size\":\"95%\",'color':'#3a3f44','background-color':'#3a3f44','border': '#3a3f44'}\n",
    "adStyle = style={\"height\":\"95%\",\"font-size\":\"95%\"}\n",
    "diStyle = style={\"width\": \"95%\",\"height\":\"95%\",\"font-size\":\"95%\",'color':'#3a3f44','background-color':'#3a3f44'}\n",
    "aiStyle = style={\"width\": \"95%\",\"height\":\"95%\",\"font-size\":\"95%\"}\n",
    "dpStyle = style={\"height\":\"95%\",'color':'#3a3f44','background-color':'#3a3f44'}\n",
    "headingStyle = {\"width\":\"95%\",\"height\":\"100%\",\"font-size\":\"150%\", \"justifyContent\":'left'}\n",
    "textStyle = {\"width\":\"95%\",\"height\":\"95%\",\"font-size\":\"95%\",\"justifyContent\":'left'}\n",
    "colStyle = {\"height\":\"95%\"}\n",
    "hrStyle = {'height':'8%'}\n",
    "drStyle = {'height':'10%'}\n",
    "trStyle = {'height':'5%'}\n",
    "brStyle = {'height':'1%'}    \n",
    "    \n",
    "def UpdateCropOptions(pos, inputDF, outputDF, CropCoefficients, EndUseCatagoriesDropdown):\n",
    "    c = pd.read_pickle(pos+\"Config.pkl\")\n",
    "    PopulateDefaults = False\n",
    "    DropDownMembers = pd.Series(index = ['Group','Crop','Type'],dtype=object)\n",
    "    DropDownOptions = pd.Series(index = ['EndUse','Group','Crop','Type'],dtype=object)\n",
    "    \n",
    "    #Set up values series\n",
    "    Values = pd.Series(index = ['EndUse','Group','Crop','Type'],data=[None]*4)\n",
    "    Values['EndUse'] = inputDF['EndUse']\n",
    "    if (Values['EndUse']!=None):\n",
    "        Values['Group'] = inputDF['Group']\n",
    "        if (Values['Group']!= None):\n",
    "            Values['Crop'] = inputDF['Crop']\n",
    "            if (Values['Crop'] != None):\n",
    "                Values['Type'] = inputDF['Type']\n",
    "    # Default drop down configs\n",
    "    outputDF['EndUse'] = dcc.Dropdown(value = Values['EndUse'], options = EndUseCatagoriesDropdown,placeholder='Pick End use',\n",
    "                                      style = ddStyle,\n",
    "                                      id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"EndUse\"})\n",
    "    outputDF['Group'] = dcc.Dropdown(options = [], disabled = True, placeholder='Pick \"End use\" first', \n",
    "                                     style = ddStyle,\n",
    "                                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Group\"})\n",
    "    outputDF['Crop'] = dcc.Dropdown(options = [], disabled = True, placeholder='Pick \"Group\" first', \n",
    "                                    style = ddStyle,\n",
    "                                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Crop\"})\n",
    "    outputDF['Type'] = dcc.Dropdown(options = [], disabled = True, placeholder='Pick \"Crop\" first', \n",
    "                                    style = ddStyle,\n",
    "                                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Type\"})\n",
    "    \n",
    "    # Set drop down configs based on selected values\n",
    "    if Values['EndUse'] != None:\n",
    "        Values, DropDownOptions = checkGroupOptions(Values, DropDownOptions, CropCoefficients,pos) \n",
    "        outputDF['Group'] = dcc.Dropdown(options = DropDownOptions['Group'],placeholder = 'Pick Group', value = Values['Group'],\n",
    "                                         style = adStyle,\n",
    "                                         id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Group\"})\n",
    "        if Values['Group'] != None:\n",
    "            Values, DropDownOptions = checkCropOptions(Values,DropDownOptions,CropCoefficients,pos)\n",
    "            outputDF['Crop'] = dcc.Dropdown(options = DropDownOptions['Crop'],placeholder = 'Pick Crop', value = Values['Crop'], \n",
    "                                            style = adStyle,\n",
    "                                            id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Crop\"})        \n",
    "            if Values['Crop'] != None:\n",
    "                Values, DropDownOptions = checkTypeOptions(Values,DropDownOptions,CropCoefficients,pos)\n",
    "                outputDF['Type'] = dcc.Dropdown(options = DropDownOptions['Type'],placeholder = 'Pick Type', value = Values['Type'], \n",
    "                                                style = adStyle,\n",
    "                                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Type\"})\n",
    "        \n",
    "    #Enable Crop data fields and populate with default values if all crop selection catagories are made\n",
    "    PopulateDefaults = (Values[\"EndUse\"]!=None) & (Values[\"Group\"]!=None) & (Values[\"Crop\"]!=None) & (Values[\"Type\"]!=None)\n",
    "    if (PopulateDefaults == True):\n",
    "        CropFilter = (CropCoefficients.loc[:,'EndUse'] == Values[\"EndUse\"])&(CropCoefficients.loc[:,'Group'] == Values[\"Group\"])\\\n",
    "                     &(CropCoefficients.loc[:,'Colloquial Name'] == Values[\"Crop\"])&(CropCoefficients.loc[:,'Type'] == Values[\"Type\"])\n",
    "        Params = pd.Series(index=CropCoefficients.loc[CropFilter,CropParams].columns, data = CropCoefficients.loc[CropFilter,CropParams].values[0])\n",
    "        outputDF['SaleableYield'] = dcc.Input(type=\"number\",disabled = False, value = Params[\"Typical Yield\"],min=0,\n",
    "                                              style = aiStyle,\n",
    "                                              id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"SaleableYield\"})\n",
    "        outputDF['Units'] = dcc.Dropdown(options = UnitsDropDown, disabled = False, value =Units.loc[Params[\"Typical Yield Units\"],\"toKG/ha\"], \n",
    "                                         style = adStyle,\n",
    "                                         id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"Units\"})\n",
    "        outputDF['ProductType'] = html.Div(Params['Yield type'] + \" yield\", \n",
    "                                           style = textStyle,\n",
    "                                           id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"displaytext\",\"id\":\"ProductType\"})\n",
    "        outputDF['FieldLoss'] = dcc.Input(type=\"number\",disabled = False, value = Params[\"Typical Field Loss %\"],min=0,\n",
    "                                          style = aiStyle,\n",
    "                                          id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"FieldLoss\"})\n",
    "        outputDF['DressingLoss'] = dcc.Input(type=\"number\",disabled = False, value = Params[\"Typical Dressing Loss %\"],min=0,\n",
    "                                             style = aiStyle,\n",
    "                                             id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"DressingLoss\"})\n",
    "        outputDF['MoistureContent'] = dcc.Input(type=\"number\",disabled = False, value = (round(Params[\"Moisture %\"],0)),min=0,\n",
    "                                                style = aiStyle,\n",
    "                                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"MoistureContent\"})\n",
    "        outputDF['EstablishStage'] = dcc.Dropdown(options = EstablishStageDropdown, disabled = False, value =Params[\"Typical Establish Stage\"], \n",
    "                                                  style = adStyle,\n",
    "                                                  id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"EstablishStage\"})\n",
    "        outputDF['HarvestStage'] = dcc.Dropdown(options = HarvestStageDropdown, disabled = False, value =Params[\"Typical Harvest Stage\"], \n",
    "                                                style = adStyle,\n",
    "                                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"HarvestStage\"})\n",
    "        outputDF[\"ResidueTreatment\"] = dcc.Dropdown(options = ResidueTreatDropdown, disabled = False, value = \"Incorporated\", \n",
    "                                                    style = adStyle,\n",
    "                                                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"ResidueTreatment\"})\n",
    "        outputDF[\"EstablishN\"] = dcc.Input(type=\"number\",disabled = False, value = 0, min=0, \n",
    "                                                    style = aiStyle,\n",
    "                                                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"EstablishN\"})\n",
    "        updateConfig([\"SaleableYield\",\"Units\",\"FieldLoss\",\"DressingLoss\",\"MoistureContent\",\"EstablishStage\",\"HarvestStage\",\"ResidueTreatment\"],\n",
    "                     [Params[\"Typical Yield\"],Units.loc[Params[\"Typical Yield Units\"],\"toKG/ha\"],Params[\"Typical Field Loss %\"],\n",
    "                      Params[\"Typical Dressing Loss %\"],Params[\"Moisture %\"],Params[\"Typical Establish Stage\"],Params[\"Typical Harvest Stage\"],1.0],\n",
    "                     pos+\"Config.pkl\")\n",
    "        updateConfig([\"EndUse\",\"Group\",\"Crop\",\"Type\"],Values.values,pos+\"Config.pkl\")\n",
    "    else:\n",
    "        outputDF['SaleableYield'] = dcc.Input(type=\"number\",disabled = True, placeholder='Choose \"Crop\" first',min=0,\n",
    "                                              style = diStyle,\n",
    "                                              id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"SaleableYield\"})\n",
    "        outputDF['Units'] = dcc.Dropdown(options = [], disabled = True, placeholder='Choose \"Crop\" first', \n",
    "                                         style = ddStyle,\n",
    "                                         id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"Units\"})\n",
    "        outputDF['ProductType'] = html.Div(\"Yield Data\", \n",
    "                                           style = textStyle,\n",
    "                                           id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"displaytext\",\"id\":\"ProductType\"})\n",
    "        outputDF['FieldLoss'] = dcc.Input(type=\"number\",disabled = True, placeholder='Choose \"Crop\" first',min=0,\n",
    "                                          style = diStyle,\n",
    "                                          id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"FieldLoss\"})\n",
    "        outputDF['DressingLoss'] = dcc.Input(type=\"number\",disabled = True, placeholder='Choose \"Crop\" first',min=0,\n",
    "                                             style = diStyle,\n",
    "                                             id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"DressingLoss\"})\n",
    "        outputDF['MoistureContent'] = dcc.Input(type=\"number\",disabled = True, placeholder='Choose \"Crop\" first',min=0,\n",
    "                                                style = diStyle,\n",
    "                                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"MoistureContent\"})\n",
    "        outputDF['EstablishStage'] = dcc.Dropdown(options = [], disabled = True, placeholder='Choose \"Crop\" first', \n",
    "                                                  style = ddStyle,\n",
    "                                                  id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"EstablishStage\"})\n",
    "        outputDF['HarvestStage'] = dcc.Dropdown(options = [], disabled = True, placeholder='Choose \"Crop\" first', \n",
    "                                                style = ddStyle,\n",
    "                                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"HarvestStage\"})\n",
    "        outputDF[\"ResidueTreatment\"] = dcc.Dropdown(options = [], disabled = True, placeholder='Choose \"Crop\" first', \n",
    "                                                    style = ddStyle,\n",
    "                                                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"ResidueTreatment\"})\n",
    "        outputDF['EstablishN'] = dcc.Input(type=\"number\",disabled = True, placeholder='Choose \"Crop\" first',min=0,\n",
    "                                             style = diStyle,\n",
    "                                             id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"EstablishN\"})\n",
    "        updateConfig([\"SaleableYield\",\"Units\",\"FieldLoss\",\"DressingLoss\",\"MoistureContent\",\n",
    "                      \"EstablishStage\",\"HarvestStage\",\"ResidueTreatment\"],\n",
    "                     [0.0,1.0,0.0,0.0,0.0,\"Seed\",\"EarlyReproductive\",1.0],\n",
    "                     pos+\"Config.pkl\")\n",
    "        updateConfig([\"EndUse\",\"Group\",\"Crop\",\"Type\"],[None,None,None,None],pos+\"Config.pkl\")\n",
    "    return list(outputDF[0:4]), list(outputDF[4:14])\n",
    "\n",
    "def checkGroupOptions(Values,DropDownOptions,CropCoefficients,pos):\n",
    "    GroupSelections = CropCoefficients.loc[CropCoefficients.loc[:,'EndUse'] == Values['EndUse'],\"Group\"].drop_duplicates().dropna().values\n",
    "    GroupSelections.sort()\n",
    "    if len(GroupSelections)<=1:\n",
    "        DropDownOptions['Group'] = [{'label':\"No Groups for \" +Values['EndUse']+\" EndUse\",'value': GroupSelections[0]}]\n",
    "        Values['Group'] = GroupSelections[0]\n",
    "        Values, DropDownOptions = checkCropOptions(Values,DropDownOptions,CropCoefficients,pos)\n",
    "    else:\n",
    "        DropDownOptions['Group'] = [{'label':i,'value':i} for i in GroupSelections]\n",
    "        DropDownOptions['Crop'] = []\n",
    "        DropDownOptions['Type'] = []\n",
    "    return Values, DropDownOptions\n",
    "\n",
    "def checkCropOptions(Values,DropDownOptions,CropCoefficients,pos):\n",
    "    GroupSelections = CropCoefficients.loc[CropCoefficients.loc[:,'EndUse'] == Values['EndUse'],\"Group\"].drop_duplicates().dropna().values\n",
    "    GroupSelections.sort()\n",
    "    DropDownOptions['Group'] = [{'label':i,'value':i} for i in GroupSelections] \n",
    "    CropSelections = CropCoefficients.loc[(CropCoefficients.loc[:,'EndUse'] == Values['EndUse'])&(CropCoefficients.loc[:,'Group'] == Values['Group']),\"Colloquial Name\"].drop_duplicates().dropna().values\n",
    "    CropSelections.sort()\n",
    "    if len(CropSelections) <= 1:\n",
    "            DropDownOptions['Crop'] = [{'label':CropSelections[0]+\" is the only \" + Values['EndUse']+\" crop\",'value': CropSelections[0]}]\n",
    "            Values['Crop'] = CropSelections[0]\n",
    "            Values, DropDownOptions = checkTypeOptions(Values, DropDownOptions,CropCoefficients,pos)\n",
    "    else:\n",
    "        DropDownOptions['Crop'] = [{'label':i,'value':i} for i in CropSelections]\n",
    "        DropDownOptions['Type'] = []\n",
    "    return Values, DropDownOptions\n",
    "\n",
    "def checkTypeOptions(Values,DropDownOptions,CropCoefficients,pos):\n",
    "    GroupSelections = CropCoefficients.loc[CropCoefficients.loc[:,'EndUse'] == Values['EndUse'],\"Group\"].drop_duplicates().dropna().values\n",
    "    GroupSelections.sort()\n",
    "    DropDownOptions['Group'] = [{'label':i,'value':i} for i in GroupSelections] \n",
    "    CropSelections = CropCoefficients.loc[(CropCoefficients.loc[:,'EndUse'] == Values['EndUse'])&(CropCoefficients.loc[:,'Group'] == Values['Group']),\"Colloquial Name\"].drop_duplicates().dropna().values\n",
    "    CropSelections.sort()\n",
    "    DropDownOptions['Crop'] = [{'label':i,'value':i} for i in CropSelections]\n",
    "    TypeSelections = CropCoefficients.loc[(CropCoefficients.loc[:,'EndUse'] == Values['EndUse'])&(CropCoefficients.loc[:,'Group'] == Values['Group'])&(CropCoefficients.loc[:,'Colloquial Name'] == Values['Crop']),\"Type\"].drop_duplicates().dropna().values\n",
    "    if len(TypeSelections) <= 1:\n",
    "            DropDownOptions['Type'] = [{'label':Values['Crop']+\" has no Type options\",'value': TypeSelections[0]}]\n",
    "            Values['Type'] = TypeSelections[0]\n",
    "    else:\n",
    "        DropDownOptions['Type'] = [{'label':i,'value':i} for i in TypeSelections]\n",
    "    return Values, DropDownOptions\n",
    "\n",
    "def SetDatePicker(pos,act,PHtext,minDate,selDate,isEnabled):\n",
    "    if isEnabled:\n",
    "        DateP = dcc.DatePickerSingle(id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"date\",\"id\":act}, date = selDate, placeholder = PHtext,\n",
    "                                          min_date_allowed=minDate, max_date_allowed=dt.date(2025, 12, 31), \n",
    "                                          initial_visible_month = selDate, display_format='D-MMM-YYYY')     \n",
    "    else:\n",
    "        DateP = dcc.DatePickerSingle(id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"date\",\"id\":act}, placeholder = PHtext, disabled = True)\n",
    "    return DateP\n",
    "\n",
    "def UpdateDatePickerOptions(datedf):\n",
    "    for d in datedf.index:\n",
    "        pos = d[0]\n",
    "        act = d[1]\n",
    "        updateConfig([act],[np.datetime64(datedf.loc[d,'date'])],pos+\"Config.pkl\")\n",
    "    \n",
    "    posc=0\n",
    "    for pos in Positions:\n",
    "        for act in Actions:\n",
    "            if (pos == \"Previous_\") and (act == \"EstablishDate\"):\n",
    "                minDate = dt.date(2020,1,1)\n",
    "                isEnabled = datedf.loc[(pos,act),'date']!=None\n",
    "                selDate = datedf.loc[(pos,act),'date']#.astype(dt.datetime)\n",
    "                PHtext = 'Select Establish Date'\n",
    "            else:\n",
    "                isEnabled = datedf.iloc[posc-1,0]!=None\n",
    "                if isEnabled:\n",
    "                    minDate = datedf.iloc[posc-1,0]#.astype(dt.datetime)\n",
    "                else:\n",
    "                    minDate = dt.date(2020,1,1)\n",
    "                if datedf.iloc[posc,0]==None:\n",
    "                    selDate = None\n",
    "                else:    \n",
    "                    selDate = datedf.iloc[posc,0]#.astype(dt.datetime)\n",
    "                if act == 'HarvestDate':\n",
    "                    if isEnabled:\n",
    "                        PHtext = 'Select Harvest Date'\n",
    "                    else:\n",
    "                        PHtext = 'Set Prior Crop dates first'\n",
    "                if act == 'EstablishDate':\n",
    "                    if isEnabled:\n",
    "                        PHtext = 'Select Planting Date'\n",
    "                    else:\n",
    "                        PHtext = 'Set Prior Crop dates first'\n",
    "            globals()[pos+act] = SetDatePicker(pos,act,PHtext,minDate,selDate,isEnabled)\n",
    "            posc +=1\n",
    "    \n",
    "    return Previous_EstablishDate, Previous_HarvestDate, Current_EstablishDate, Current_HarvestDate, Following_EstablishDate, Following_HarvestDate\n",
    "\n",
    "def makeDataSeries(names,values):\n",
    "    Names = []\n",
    "    for n1 in range(len(names)):\n",
    "        for n2 in range(len(names[n1])):\n",
    "            Names.append(names[n1][n2]['id']['id'])\n",
    "    df = pd.Series(index=Names,data=values)\n",
    "    return df\n",
    "\n",
    "def makeDateDataDF(names,dates):\n",
    "    p=0\n",
    "    df = pd.DataFrame(index = range(0,6), columns=['pos','act','date'])\n",
    "    for n1 in range(len(names)):\n",
    "        for n2 in range(len(names[n1])):\n",
    "            df.loc[p,'pos'] = names[n1][n2]['id']['pos']\n",
    "            df.loc[p,'act'] = names[n1][n2]['id']['id']\n",
    "            df.loc[p,'date'] = dates[p]\n",
    "            p+=1\n",
    "    df.set_index(['pos','act'],inplace=True)\n",
    "    return df\n",
    "\n",
    "def CropInputs(pos,EndUseCatagoriesDropdown,disableDates,EDatePHtext,HDatePHtext):\n",
    "    return dbc.CardBody([\n",
    "    ## Crop Type informaiton\n",
    "    dbc.Row([html.B(pos[:-1]+ \" crop information\",\n",
    "                     style=headingStyle,\n",
    "                     id = {\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Title\",\"RetType\":\"displaytext\",\"id\":\"PositionTitle\"})],\n",
    "           style=hrStyle),\n",
    "    dbc.Row([dbc.Col([html.B('End use',\n",
    "                            style = textStyle)],\n",
    "                     width=3, align='center',style = colStyle),\n",
    "             dbc.Col([html.B('Group', \n",
    "                             style = textStyle)],\n",
    "                     width=3, align='center',style = colStyle),\n",
    "             dbc.Col([html.B('Crop', \n",
    "                             style = textStyle)], \n",
    "                     width=3, align='center',style = colStyle),\n",
    "             dbc.Col([html.B('Type', \n",
    "                             style = textStyle)], \n",
    "                     width=3, align='center',style = colStyle)],\n",
    "           style=trStyle), \n",
    "    dbc.Row([dbc.Col([dcc.Dropdown(options = EndUseCatagoriesDropdown, placeholder=' Select crop EndUse',\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"EndUse\"})],\n",
    "                     width=3 ,align='center', style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"children\",\"id\":\"EndUse\"}),\n",
    "             dbc.Col([dcc.Dropdown(options = [], placeholder=' Select \"EndUse\" first' ,\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Group\"})], \n",
    "                      width=3 ,align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"children\",\"id\":\"Group\"}),\n",
    "             dbc.Col([dcc.Dropdown(options = [], placeholder=' Select \"Group\" first',\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Crop\"})], \n",
    "                     width=3 ,align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"children\",\"id\":\"Crop\"}),\n",
    "             dbc.Col([dcc.Dropdown(options = [], placeholder='',\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"value\",\"id\":\"Type\"})], \n",
    "                     width=3 ,align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Catagory\",\"RetType\":\"children\",\"id\":\"Type\"})],\n",
    "           style=drStyle),\n",
    "    dbc.Row([],style=brStyle),\n",
    "    ## Crop Harvest Information\n",
    "    dbc.Row([dbc.Col([html.B(pos[:-1]+ ' harvest information',\n",
    "                               style=headingStyle,\n",
    "                               id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"displaytext\",\"id\":\"ProductType\"})],\n",
    "                     width=12, align='left',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"Product Type\"})],\n",
    "            style=hrStyle),\n",
    "    dbc.Row([dbc.Col([dcc.Input(type=\"number\",placeholder = \"Enter Expected Yield\",min=0,disabled=True,\n",
    "                                style=diStyle,\n",
    "                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\": \"SaleableYield\"})],\n",
    "                      width=3, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"SaleableYield\"}),\n",
    "             dbc.Col([dcc.Dropdown(options = [], placeholder = \"\",disabled=True,\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"Units\"})], \n",
    "                     width=3, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"Units\"}),\n",
    "             dbc.Col([html.Div('at',\n",
    "                               style=dict(display='flex', justifyContent='center'))],\n",
    "                     width = 1, align='center', style = colStyle),\n",
    "             dbc.Col([dcc.Input(type=\"number\",min=0,max=96,disabled=True,\n",
    "                                style=diStyle,\n",
    "                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"MoistureContent\"})],\n",
    "                     width=2, align='center', style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"MoistureContent\"}),\n",
    "             dbc.Col([html.Div('% Moisture',\n",
    "                               style=dict(display='flex', justifyContent='left'))], \n",
    "                     width=3, align='left',style = colStyle)],\n",
    "           style=drStyle), \n",
    "    dbc.Row([],style=brStyle),\n",
    "    \n",
    "    dbc.Row([dbc.Col([dcc.Input(type=\"number\",min=0,max=100,disabled=True,\n",
    "                                style=diStyle,\n",
    "                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"FieldLoss\"})],\n",
    "                     width=2, align='right',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"FieldLoss\"}),\n",
    "             dbc.Col([html.Div('Field Loss (%)',\n",
    "                               style=dict(display='flex', justifyContent='left'))],\n",
    "                     width=3, align='left',style = colStyle),\n",
    "             dbc.Col([dcc.Input(type=\"number\",min=0,max=100,disabled=True,\n",
    "                                style=diStyle,\n",
    "                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"DressingLoss\"})],\n",
    "                      width=2, align='right',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"DressingLoss\"}),\n",
    "            dbc.Col([html.Div('Dressing loss (%)',\n",
    "                               style=dict(display='flex', justifyContent='left'))], \n",
    "                     width=3, align='left',style = colStyle)],\n",
    "           style=drStyle), \n",
    "    dbc.Row([],style=brStyle),\n",
    "    \n",
    "\n",
    "    # Crop Management Information    \n",
    "    dbc.Row([dbc.Col([html.B(pos[:-1]+ ' management information',\n",
    "                               style=headingStyle)],\n",
    "                     width=12, align='left',style = colStyle)],\n",
    "            style=hrStyle),\n",
    "    dbc.Row([dbc.Col([html.Div('Planting Date',\n",
    "                               style = textStyle)], \n",
    "                     width=4, align='center',style = colStyle),\n",
    "             dbc.Col([html.Div('Planting method',\n",
    "                               style = textStyle)], \n",
    "                     width=4, align='center',style = colStyle),\n",
    "             dbc.Col([html.Div('Planting Nitrogen', \n",
    "                               style = textStyle)],\n",
    "                     width=4, align='center',style = colStyle)],\n",
    "             style=trStyle),    \n",
    "    dbc.Row([dbc.Col([dcc.DatePickerSingle(min_date_allowed=dt.date(2020, 1, 1),\n",
    "                                           max_date_allowed=dt.date(2025, 12, 31), initial_visible_month=dt.date(2021, 5, 15),\n",
    "                                           placeholder = EDatePHtext, display_format='D-MMM-YYYY', disabled = disableDates,\n",
    "                                           style = dpStyle,\n",
    "                                           id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"date\",\"id\":\"EstablishDate\"})], \n",
    "                     width=4, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"children\",\"id\":\"EstablishDate\"}),\n",
    "             dbc.Col([dcc.Dropdown(options =[], placeholder='',disabled=True,\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"EstablishStage\"})],\n",
    "                     width=4, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"EstablishStage\"}),\n",
    "             dbc.Col([dcc.Input(type=\"number\",min=0,max=400,disabled=True,\n",
    "                                style=diStyle,\n",
    "                                id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"EstablishN\"})],\n",
    "                     width=2, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"children\",\"id\":\"EstablishN\"}),\n",
    "            dbc.Col([html.Div('kg/ha',\n",
    "                               style=dict(display='flex', justifyContent='left'))],\n",
    "                    width=2, align='left',style = colStyle)],\n",
    "            style=drStyle), \n",
    "    dbc.Row([dbc.Col([html.Div('Harvest Date',\n",
    "                               style = textStyle)], \n",
    "                     width=4, align='center',style = colStyle),\n",
    "            dbc.Col([html.Div('Harvest Stage',\n",
    "                               style = textStyle)],\n",
    "                     width=4, align='center',style = colStyle),\n",
    "            dbc.Col([html.Div('Residue Treatment',\n",
    "                               style = textStyle)],\n",
    "                     width=4, align='center',style = colStyle)],\n",
    "            style=trStyle),\n",
    "    dbc.Row([dbc.Col([dcc.DatePickerSingle(min_date_allowed=dt.date(2020, 1, 1),\n",
    "                                           max_date_allowed=dt.date(2025, 12, 31), initial_visible_month=dt.date(2021, 5, 15),\n",
    "                                           placeholder = HDatePHtext,display_format='D-MMM-YYYY',disabled=True,\n",
    "                                           style = dpStyle,\n",
    "                                           id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"date\",\"id\":\"HarvestDate\"})], \n",
    "                     width=4, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"Event\",\"RetType\":\"children\",\"id\":\"HarvestDate\"}), \n",
    "             dbc.Col([dcc.Dropdown(options = [],placeholder='',disabled=True,\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"HarvestStage\"})], \n",
    "                     width=4, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"HarvestStage\"}),\n",
    "             dbc.Col([dcc.Dropdown(options =[], placeholder='',disabled=True,\n",
    "                                   style=ddStyle,\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"value\",\"id\":\"ResidueTreatment\"})],\n",
    "                     width=4, align='center',style = colStyle,\n",
    "                     id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"data\",\"RetType\":\"children\",\"id\":\"ResidueTreatment\"})],\n",
    "            style=drStyle), \n",
    "    dbc.Row([dbc.Col([html.Div('Defoliatoin Dates')], \n",
    "                     width=3, align='center',style = colStyle),\n",
    "            dbc.Col([dcc.Checklist(options=[],\n",
    "                                   id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"defoliation\",\"RetType\":\"value\",\"id\":\"DefoliationDates\"})],\n",
    "                    width=9, align='left',style = colStyle,\n",
    "                    id={\"pos\":pos,\"Group\":\"Crop\",\"subGroup\":\"defoliation\",\"RetType\":\"children\",\"id\":\"DefoliationDates\"})],\n",
    "            style=drStyle)],\n",
    "    style={\"height\": \"100%\"})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "f3e7b9c6",
   "metadata": {
    "lines_to_next_cell": 2
   },
   "outputs": [],
   "source": [
    "CropConfigs = [\"EndUse\",\"Group\",\"Crop\",\"Type\",\"SaleableYield\",\"Units\",\"FieldLoss\",\"DressingLoss\",\n",
    "               \"MoistureContent\",\"EstablishDate\",\"EstablishStage\",\"HarvestDate\",\"HarvestStage\",\n",
    "               \"ResidueTreatment\",\"EstablishN\",\"DefoliationDates\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2eb16e21-4d82-41fa-bd58-961d90f69ee0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['EndUse',\n",
       " 'Group',\n",
       " 'Crop',\n",
       " 'Type',\n",
       " 'SaleableYield',\n",
       " 'Units',\n",
       " 'FieldLoss',\n",
       " 'DressingLoss',\n",
       " 'MoistureContent',\n",
       " 'EstablishDate',\n",
       " 'EstablishStage',\n",
       " 'HarvestDate',\n",
       " 'HarvestStage',\n",
       " 'ResidueTreatment',\n",
       " 'EstablishN',\n",
       " 'DefoliationDates']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(CropConfigs)"
   ]
  }
 ],
 "metadata": {
  "jupytext": {
   "formats": "ipynb,py:light"
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}