{% extends 'onlineanywhere_base.html' %}
{% block content %}
<!--<a href="/edit_cheltuieli/new" class="btn btn-danger btn-sm">Insert New</a>-->
db_type: {{db_type}}
<br>
table_name: {{table_name}}

<br>
<br>

{% if row_vals == 'new'%}
    <form method="post" action="/edit_cheltuieli/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in ['id', 'id_users', 'inptimestamp', 'post_pay'] %}
                    <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="{{ category }}">{{ 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 == 'int' or col_type == 'decimal' %}
                            <input type="number"  name="{{col_name}}"/>
                        {% 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="copy_as"/>
        </div>
    </div>
</form>
{% elif row_vals == 'one_time'%}
    <form method="post" action="/edit_cheltuieli/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in ['id', 'id_users', 'inptimestamp', 'post_pay', 'category', 'freq', 'valid_from', 'valid_to', 'auto_ext'] %}
                    <div class="row" id="one_time_">
                <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="{{ category }}">{{ conto }}</option>
                            {% endfor %}
                            </select>
                        {% elif col_name == 'pay_day'%}
                            <input type="date" name="{{col_name}}"/>
                        {% 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 == 'int' or col_type == 'decimal' %}
                            <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_cheltuieli/{{id_row}}">
    <div class="container text-left">
            {% for col_name, col_type in table_head.items() %}
                {% if col_name not in ['id', 'id_users', 'inptimestamp', 'post_pay'] %}
                    <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="{{ category }}">{{ 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 == 'int' or col_type == 'decimal' %}
                            <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="row" id="submit-row">
        <div class="col">
            <button type="submit" name="copy_as" class="btn btn-primary">Copy As</button>
        </div>
            <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>

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

{% endblock %}