{{response.title=base_title + ' Management: ' + T('List of live sponsor emails')}}
{{response.files.append(URL('static', 'OZSponsor/SHOW_EMAILS.css'))}}
{{extend 'layout.html'}}
{{from urllib.parse import quote}}
<h2><a href="{{=URL('index')}}">Management</a>: list sponsors at various stages, to email</h2>
<p>Most recent first. Images that are absent from the OneZoom site are shown in <span class="missing">yellow</span>. Items where payment has not gone through may simply be so recently sponsored that payment has not yet been emailed, or may have been reserved by admin. Ones with no admin comment are in <span class="no_admin">pink</span> - these may need attention.</p><p>The verification page is <a href="{{=URL('SPONSOR_VALIDATE')}}">here</a>.</p>
<ul>
{{for summary,data in email_list.items():}}
<li><details>
    <summary>{{=summary}} &mdash; ({{=len(data)}} sponsors)</summary>
    <table>
    <tr><th></th><th>Click each to email</th><th>Click each to view on tree</th><th><details><summary>Pictures used</summary><p>Run this from within OZprivate to download these images<blockquote>echo '{{=XML("<br />".join([s["img_src_id"] for s in data if s]))}}' | ServerScripts/Utilities/getEOL_crops.py --file - --output_dir ../static/FinalOutputs/img/{{=src_flags['onezoom_via_eol']}} -v -f</blockquote></p></details></th></tr>
    {{for s in data:}}<tr{{if s.get('rowflag'):}} class="{{=s['rowflag']}}"{{pass}}>
    <td><input type="checkbox" /></td>
    <td><a href="mailto:{{=s['email']}}?subject={{=quote(s['subject'])}}&body={{=quote(s['message'])}}">{{=s['email']}}</a></td>
    <td><i><a href="{{=URL('life/@=' + str(s['ott']), url_encode=False, extension=False)}}" target="_blank">{{=s['name']}}</a></i></td>
    <td class="{{if s['local_pic'] is not None:}}{{if s['local_pic']:}}downloaded{{else:}}missing{{pass}}{{pass}}"><a href="http://eol.org/data_objects/{{=s['img_src_id']}}" target="_blank">{{=s['img_src_id']}}</a></td>
    <td>{{=s['mesg']}}</td>
    </tr>
    {{pass}}
</table>
</details>
{{pass}}
</li>
</ul>
<h2>Other email lists, etc.</h2>
<details>
<summary><a href="mailto:?bcc={{=",".join([row.get('e_mail') or row.get('PP_e_mail') for row in contactable_emails])}}">Email sponsors that <q>allow further contact</q></a>
 (or expand this summary to see a list, that can be pasted into the <q>bcc</q> field of your mail client</summary>
    {{=",".join([row.get('e_mail') or row.get('PP_e_mail') for row in contactable_emails])}}
</details>
<details>
<summary>Command to get all onezoom_via_eol pictures</summary>
    echo '
    {{=XML("<br />".join(onezoom_via_eol_images))}}
    ' |  ServerScripts/Utilities/getEOL_crops.py --file - --output_dir ../static/FinalOutputs/img/{{=src_flags['onezoom_via_eol']}} -v -f

    echo '
    {{=XML("<br />".join(eol_images))}}
    ' |  ServerScripts/Utilities/getEOL_crops.py --file - --output_dir ../static/FinalOutputs/img/{{=src_flags['eol']}} -v -f
</details>