Clean Up Data After Events
Imports: 9

From Andrew O'Dell on the Planning Center Slack #custom-reports channel After reading the article “Clean Up Database After Event” https://pcopeople.zendesk.com/hc/en-us/articles/360009391314-Clean-Up-Database-After-Event , I wrote this little report to generate a pdf for our children’s minister to be able to quickly identify which students are ours and which should be marked as Inactive (i.e. who are members of other churches, out-of-town grandchildren, etc) Thanks Andrew!

Preview

Report Preview


<!DOCTYPE html>
<html lang="en">
  <head>
    <title>Post-Event Audit</title>
    <style>
      @media print { 
        body { margin: 0; padding: 0; }
      }
      @media screen { 
        body { margin-top: 0.5in; margin-right: 0in; margin-bottom: 0in; margin-left: 0in; }
      }
      @page { margin-top: 0.5in; margin-right: 0in; margin-bottom: 0in; margin-left: 0in; size: US-Letter; }
      
      ul { margin: 0; padding: 0; }
      ul.labels li {
        margin: 0 0.1in 0 0;
        padding: 0;
        float: left;
        width: 2.625in;
        height: 1.25in !important;
        display: block;
        font-family: "Lato", Arial, Helvetica, sans-serif;
        font-size: 11pt;
      }
      ul.labels li:nth-of-type(31n+31) { page-break-inside: avoid;}
      ul.labels li div.address {
                 border:1px solid black;
        margin-left: 0.25in;
        margin-top: 0.1in;
        width: 91%;
      }
          .avatar { 
          width: 50px;
            height: 50px;
                    border-radius: 25px 25px 25px 25px;
          -moz-border-radius: 25px 25px 25px 25px;
          -webkit-border-radius: 25px 25px 25px 25px;
        }
    </style>
  </head>
  <body>
    <ul class="labels">
      {% for person in people %}
          <li>
          <div class="address">
           &nbsp;&nbsp; <img class="avatar" src="{{ person.photo_url }}" />
            {{ person.name }} <br />
            <span style="color:blue">&#9634;&nbsp;&nbsp;Active</span><br />
            <span style="color:orange">&#9634;&nbsp;&nbsp;Prospect</span><br />
            <span style="color:red">&#9634;&nbsp;&nbsp;Make Inactive</span><br />
          </div>
          </li>
      {% endfor %}
    </ul>
  </body>
</html>