{% extends 'onlineanywhere_base.html' %}
{% block content %}

db_type: {{db_type}}
<br>
table_name----: {{table_name}}

<br>
<br>
<br>

{% if row_vals == 'new'%}
    <form method="post" action="/edit_row/{{db_type}}/{{table_name}}/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in exclude_cols %}
                    <div class="row" id="date-row_">
                        <div class="col">
                        <label>{{col_name}}</label>
                        {% if col_name == 'category' %}
                            <select name="{{ col_name }}">
                            {% for category in categories %}
                            <option value="{{ category }}">{{ category }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_name == 'myconto' %}
                            <select name="{{ col_name }}">
                            {% for conto in myContos %}
                            <option value="{{ conto }}">{{ conto }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_name == 'plane' %}
                            <select name="{{ col_name }}">
                            {% for conto in myContos %}
                            <option value="{{ conto }}">{{ conto }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_type == 'varchar' or col_type == 'text'%}
                            <input type="text" name="{{col_name}}"/>
                        {% elif col_type == 'date' %}
                            <input type="date"  name="{{col_name}}"/>
                        {% elif col_type == 'time' %}
                            <input type="time"  name="{{col_name}}"/>
                        {% elif col_type == 'int' or col_type == 'decimal' or col_type == 'float' %}
                            <input type="number"  name="{{col_name}}" step="any"/>
                        {% elif col_type == 'tinyint' %}
                            <input value=1 name="{{col_name}}" type="checkbox">
                        {% else %}
                        {% endif %}
                </div>
                    </div>
                {% endif %}
            {% endfor %}
    </div>
    <br>
    <div class="row" id="aaaa-row">
        <div class="col">
            <input type="submit" name="insert_new"/>
        </div>
    </div>
    </form>
{% elif row_vals == 'one_time' %}
    <form method="post" action="/edit_row/{{db_type}}/{{table_name}}/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in exclude_cols %}
                    <div class="row" id="date-*row_">
                        <div class="col">
                        <label>{{col_name}}</label>
                        {% if col_name == 'category' %}
                            <select name="{{ col_name }}">
                            {% for category in categories %}
                            <option value="{{ category }}">{{ category }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_name == 'myconto' %}
                            <select name="{{ col_name }}">
                            {% for conto in myContos %}
                            <option value="{{ conto }}">{{ conto }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_type == 'varchar' or col_type == 'text'%}
                            <input type="text" name="{{col_name}}"/>
                        {% elif col_type == 'date' %}
                            <input type="date"  name="{{col_name}}"/>
                        {% elif col_type == 'time' %}
                            <input type="time"  name="{{col_name}}"/>
                        {% elif col_type == 'int' or col_type == 'decimal' or col_type == 'float' %}
                            <input type="number"  name="{{col_name}}" step="any"/>
                        {% elif col_type == 'tinyint' %}
                            <input value=1 name="{{col_name}}" type="checkbox">
                        {% else %}
                        {% endif %}
                </div>
                    </div>
                {% endif %}
            {% endfor %}
    </div>
    <br>
    <div class="row" id="sub__mit-row">
        <div class="col">
            <input type="submit" name="add_one_time"/>
        </div>
    </div>
</form>
{% else %}
    <form method="post" action="/edit_row/{{db_type}}/{{table_name}}/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in exclude_cols %}
                    <div class="row" id="date-row">
                        <div class="col">
                    <label>{{col_name}}</label>
                        {% if col_name == 'category' %}
                            <select name="{{ col_name }}">
                            {% for category in categories %}
                            <option value="{{ category }}">{{ category }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_name == 'myconto' %}
                            <select name="{{ col_name }}" required>
                                {% for conto in myContos %}
                                    <option value="{{ conto }}">{{ conto }}</option>
                                {% endfor %}
                                </select>
                        {% elif col_type == 'varchar' or col_type == 'text'%}
                            <input type="text" value="{{ row_vals[loop.index - 1] }}" name="{{col_name}}"/>
                        {% elif col_type == 'date' %}
                            <input type="date" value="{{ row_vals[loop.index -1 ] }}" name="{{col_name}}"/>
                        {% elif col_type == 'time' %}
                            <input type="time"  value="{{ row_vals[loop.index -1 ] }}" name="{{col_name}}"/>
                        {% elif col_type == 'int' or col_type == 'decimal' or col_type == 'float' %}
                            <input type="number" value="{{ row_vals[loop.index -1] }}" name="{{col_name}}" step="any"/>
                        {% elif col_type == 'tinyint' %}
                            {% if row_vals[loop.index -1] == 1%}
                                <input checked="" value=1 name="{{col_name}}" type="checkbox">
                            {% else %}
                                <input value=1 name="{{col_name}}" type="checkbox">
                            {% endif %}
                        {% else %}
                        {% endif %}
                </div>
                    </div>
                {% endif %}
            {% endfor %}
    </div>
    <br>
    <div class="col">
        <button type="submit" name="edit_row" class="btn btn-primary">Edit</button>
    </div>
    <br>
    <div class="col" id="submit-row">
            <button type="submit" name="copy_as" class="btn btn-primary">Copy As</button>
            {% if db_type == 'new'%}
                <div class="col">
                <label>Cancel the auto_extension and  set valid to for the original</label>
                <input checked="" value=True name="cancel_auto_ext" type="checkbox">
                </div>
            {% endif %}
    </div>
    <br>
    <div class="col">
        <button type="submit" name="delete_row" class="btn btn-danger">Delete Row</button>
    </div>

    </form>
{% endif %}
<br>

{% endblock %}