In case you want to see the whole view function please take a look at:
# =================================================================================================================
# search & display requested info based on name/month/year criteria
# =================================================================================================================
@app.route( '/seek', methods=['GET', 'POST'] )
def seek():
pdata = ''
name = request.args.get('name')
month = request.args.get('month')
year = request.args.get('year')
try:
if '=' not in name + month + year:
cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, month, year) )
elif '=' not in name + year:
cur.execute( '''SELECT * FROM jobs WHERE clientID = (SELECT id FROM clients WHERE name = %s) and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (name, year) )
elif '=' not in month + year:
cur.execute( '''SELECT * FROM jobs WHERE MONTH(lastvisit) = %s and YEAR(lastvisit) = %s ORDER BY lastvisit DESC''', (month, year) )
elif '=' not in year:
cur.execute( '''SELECT * FROM jobs WHERE YEAR(lastvisit) = %s ORDER BY lastvisit ASC''', year )
else:
pdata = pdata + "<h2><font color=red>Πώς να γίνει αναζήτηση αφού δεν επέλεξες ούτε πελάτη ούτε μήνα ή τουλάχιστον το έτος?"
data = cur.fetchall()
hits = money = 0
for row in data:
hits += 1
money = money + row[2]
pdata = pdata + '''
<body background="/static/img/pelatologio.jpg">
<center><h2><font color=yellow size=5> Απολαβές από </font> <font color=lime size=5> [ %s - %s - %s ] </font>
<br><br>
<font color=white>
Επισκευές: <font color=violet> %s </font>
Σύνολο: <font color=orangered> %s € </font>
<br><br>
<table border=5 cellpadding=5 bgcolor=black>
<th><u><font color=lime size=5> Πελάτης </th> <th><u><font color=tomato size=5> Περιγραφή </th>
<th><u><font color=cyan size=5> Αμοιβή </th> <th><u><font color=orange size=5> Ημερομηνία </th>
''' % (name, month, year, hits, money)
for row in data:
(clientID, task, price, lastvisit) = row
cur.execute( '''SELECT name FROM clients WHERE id = %s''', clientID )
data = cur.fetchone()
name = data[0]
lastvisit = lastvisit.strftime('%A, %e %b %Y')
pdata = pdata + '''
<tr>
<td><center><font color=lime size=5> %s </td>
<td><center><font color=tomato size=5> %s </td>
<td><center><font color=cyan size=5> %s </td>
<td><center><font color=orange size=5> %s </td>
</tr>
''' % (name, task, price, lastvisit)
except pymysql.ProgrammingError as e:
print( repr(e) )
pdata = pdata + "<meta http-equiv='REFRESH' content='200;%s'>" % url_for( 'index' )
return pdata