<?php
error_reporting(0);

/* count the number of jobs in the system that do not have a location in the united states */
include_once dirname(__FILE__) . "/../../pearMail/Mail.php";

    $subject = "Pear Mailer: " . date("Y-m-d H:i:s") . "Monthly Job Location Report"; 
    $content = "<html>
    <head>
        <title>Pear Mailer: 2011-02-16 12:41:14Monthly Job Location Report</title>
        <style type='text/css'>
        td {
            border: 1px solid #ccc;
            padding: 4px;
        }
        th {
            border: 1px solid #ccc;
            padding: 4px;
            font-weight: bold;
        }
        </style>
    </head>
    <body>
        <h2>6747 jobs do not have a location in the system</h2>

        <h2>Companies with 100% of their jobs having no location</h2>
        <table style='width: 100%'>
            <tr>
                <th>Company Id</th>
                <th>Company Name</th>
                <th>Missing<br />Location</th>

                <th>numJobs</th>
            </tr>
            <tr>
                <td>8882</td>
                <td><a href='#####################'>LifeCell</a></td>
                <td>44</td>
                <td>44</td>

            </tr>
            <tr>
                <td>15051</td>
                <td><a href='#####################'>Central Montgomery</a></td>
                <td>25</td>
                <td>25</td>
            </tr>

            <tr>
                <td>2653</td>
                <td><a href='#####################'>Lake Metroparks</a></td>
                <td>17</td>
                <td>17</td>
            </tr>
            <tr>

                <td>1063</td>
                <td><a href='#####################'>Hampton Affiliates</a></td>
                <td>16</td>
                <td>16</td>
            </tr>
            <tr>
                <td>17667</td>

                <td><a href='#####################'>SS8 Networks, Inc.</a></td>
                <td>10</td>
                <td>10</td>
            </tr>
            <tr>
                <td>9626</td>
                <td><a href='#####################'>Davis County, Utah</a></td>

                <td>8</td>
                <td>8</td>
            </tr>
            <tr>
                <td>20475</td>
                <td><a href='#####################'>Saddlebrook Resorts, Inc.</a></td>
                <td>7</td>

                <td>7</td>
            </tr>
            <tr>
                <td>21121</td>
                <td><a href='#####################'>Margin10</a></td>
                <td>5</td>
                <td>5</td>

            </tr>
            <tr>
                <td>11806</td>
                <td><a href='#####################'>ASRC Aerospace Corporation</a></td>
                <td>5</td>
                <td>5</td>
            </tr>

            <tr>
                <td>15212</td>
                <td><a href='#####################'>Flurry</a></td>
                <td>4</td>
                <td>4</td>
            </tr>
            <tr>

                <td>15333</td>
                <td><a href='#####################'>J. Robert Folchetti and Associates</a></td>
                <td>4</td>
                <td>4</td>
            </tr>
            <tr>
                <td>8129</td>

                <td><a href='#####################'>DeAngelo Brothers Inc</a></td>
                <td>4</td>
                <td>4</td>
            </tr>
            <tr>
                <td>17621</td>
                <td><a href='#####################'>River Steel Inc.</a></td>

                <td>4</td>
                <td>4</td>
            </tr>
            <tr>
                <td>17310</td>
                <td><a href='#####################'>Denitech</a></td>
                <td>3</td>

                <td>3</td>
            </tr>
            <tr>
                <td>15761</td>
                <td><a href='#####################'>APPRION</a></td>
                <td>3</td>
                <td>3</td>

            </tr>
            <tr>
                <td>17406</td>
                <td><a href='#####################'>Head Start of Lane County</a></td>
                <td>3</td>
                <td>3</td>
            </tr>

            <tr>
                <td>9987</td>
                <td><a href='#####################'>City of Richardson Texas</a></td>
                <td>3</td>
                <td>3</td>
            </tr>
            <tr>

                <td>15486</td>
                <td><a href='#####################'>Fariel Consulting</a></td>
                <td>3</td>
                <td>3</td>
            </tr>
            <tr>
                <td>21310</td>

                <td><a href='#####################'>Smart Innovative Solutions</a></td>
                <td>2</td>
                <td>2</td>
            </tr>
            <tr>
                <td>5096</td>
                <td><a href='#####################'>G S S America Inc</a></td>

                <td>2</td>
                <td>2</td>
            </tr>
            <tr>
                <td>3800</td>
                <td><a href='#####################'>New Century Transportation Inc</a></td>
                <td>2</td>

                <td>2</td>
            </tr>
            <tr>
                <td>3036</td>
                <td><a href='#####################'>Elsevier</a></td>
                <td>2</td>
                <td>2</td>

            </tr>
            <tr>
                <td>15855</td>
                <td><a href='#####################'>The Equinox Resort & Spa</a></td>
                <td>1</td>
                <td>1</td>

            </tr>
            <tr>
                <td>19671</td>
                <td><a href='#####################'>Capital City Janitorial, Incorporated</a></td>
                <td>1</td>
                <td>1</td>
            </tr>

            <tr>
                <td>22054</td>
                <td><a href='#####################'>Access Development</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>

                <td>21588</td>
                <td><a href='#####################'>Bitsoft International, Inc.</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>6630</td>

                <td><a href='#####################'>Comfort Xpress</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>22472</td>
                <td><a href='#####################'>Raleigh-Durham Airport Authority</a></td>

                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>21299</td>
                <td><a href='#####################'>Duer/Carolina Coil</a></td>
                <td>1</td>

                <td>1</td>
            </tr>
            <tr>
                <td>21619</td>
                <td><a href='#####################'>INDUSTRY People Group</a></td>
                <td>1</td>
                <td>1</td>

            </tr>
            <tr>
                <td>21339</td>
                <td><a href='#####################'>Edwards Brothers NC</a></td>
                <td>1</td>
                <td>1</td>
            </tr>

            <tr>
                <td>21495</td>
                <td><a href='#####################'>R.T. Moore</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>

                <td>5110</td>
                <td><a href='#####################'>Manitoba Telecom Services Inc</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>21939</td>

                <td><a href='#####################'>HireSafely</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>22436</td>
                <td><a href='#####################'>RSA Medical</a></td>

                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>9554</td>
                <td><a href='#####################'>Lee County Transportation Dept</a></td>
                <td>1</td>

                <td>1</td>
            </tr>
            <tr>
                <td>22021</td>
                <td><a href='#####################'>OrderDog, Inc.</a></td>
                <td>1</td>
                <td>1</td>

            </tr>
            <tr>
                <td>5172</td>
                <td><a href='#####################'>Cottrell Inc</a></td>
                <td>1</td>
                <td>1</td>
            </tr>

            <tr>
                <td>17283</td>
                <td><a href='#####################'>CommunityONE Bank</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>

                <td>17571</td>
                <td><a href='#####################'>Orbit Irrigation Products, Inc.</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>11894</td>

                <td><a href='#####################'>Cap Rock Energy</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>22928</td>
                <td><a href='#####################'>GloryBee Foods</a></td>

                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>9484</td>
                <td><a href='#####################'>x10.com</a></td>
                <td>1</td>

                <td>1</td>
            </tr>
            <tr>
                <td>5200</td>
                <td><a href='#####################'>Davies Ward Phillips</a></td>
                <td>1</td>
                <td>1</td>

            </tr>
            <tr>
                <td>19239</td>
                <td><a href='#####################'>I B S</a></td>
                <td>1</td>
                <td>1</td>
            </tr>

            <tr>
                <td>21430</td>
                <td><a href='#####################'>Girl Scouts of Eastern PA, Inc.</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>

                <td>5307</td>
                <td><a href='#####################'>Davis-Standard Corp</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>21627</td>

                <td><a href='#####################'>Family First Credit Union</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>21625</td>
                <td><a href='#####################'>GARDNER GLASS PRODUCTS INC</a></td>

                <td>1</td>
                <td>1</td>
            </tr>
            <tr>
                <td>21487</td>
                <td><a href='#####################'>Action Technologies Defense Group</a></td>
                <td>1</td>

                <td>1</td>
            </tr>
            <tr>
                <td>4827</td>
                <td><a href='#####################'>King's College</a></td>
                <td>1</td>
                <td>1</td>

            </tr>
            <tr>
                <td>19779</td>
                <td><a href='#####################'>Engineering Solutions and Products, Inc.</a></td>
                <td>1</td>
                <td>1</td>
            </tr>

            <tr>
                <td>21840</td>
                <td><a href='#####################'>Safe Solutions</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
            <tr>

                <td>21986</td>
                <td><a href='#####################'>Holt Dental Supply Inc.</a></td>
                <td>1</td>
                <td>1</td>
            </tr>
</table>

        <h2>Companies with 50% (or more) of their jobs having no location</h2>

        <table style='width: 100%'>
            <tr>
                <th>Company Id</th>
                <th>Company Name</th>
                <th>Missing<br />Location</th>
                <th>numJobs</th>

            </tr>
            <tr>
                <td>12882</td>
                <td><a href='#####################'>Trident Medical Center LLC</a></td>
                <td>3092</td>
                <td>5759</td>
            </tr>

            <tr>
                <td>22520</td>
                <td><a href='#####################'>PeopleFirst Rehabilitation</a></td>
                <td>746</td>
                <td>1164</td>
            </tr>
            <tr>

                <td>2848</td>
                <td><a href='#####################'>Goodrich</a></td>
                <td>555</td>
                <td>1008</td>
            </tr>
            <tr>
                <td>2894</td>

                <td><a href='#####################'>Barnes Jewish Hospital</a></td>
                <td>395</td>
                <td>621</td>
            </tr>
            <tr>
                <td>18256</td>
                <td><a href='#####################'>Paychex</a></td>

                <td>241</td>
                <td>287</td>
            </tr>
            <tr>
                <td>22789</td>
                <td><a href='#####################'>Liberty Tax Service</a></td>
                <td>184</td>

                <td>202</td>
            </tr>
            <tr>
                <td>17697</td>
                <td><a href='#####################'>Texas Instruments</a></td>
                <td>179</td>
                <td>200</td>

            </tr>
            <tr>
                <td>8582</td>
                <td><a href='#####################'>Ball Aerospace</a></td>
                <td>158</td>
                <td>183</td>
            </tr>

            <tr>
                <td>415</td>
                <td><a href='#####################'>Whirlpool</a></td>
                <td>113</td>
                <td>160</td>
            </tr>
            <tr>

                <td>21219</td>
                <td><a href='#####################'>Ag 1 Source</a></td>
                <td>91</td>
                <td>104</td>
            </tr>
            <tr>
                <td>8984</td>

                <td><a href='#####################'>Parsons Brinckerhoff</a></td>
                <td>82</td>
                <td>119</td>
            </tr>
            <tr>
                <td>12491</td>
                <td><a href='#####################'>Playstation</a></td>

                <td>61</td>
                <td>110</td>
            </tr>
            <tr>
                <td>8414</td>
                <td><a href='#####################'>Concur Technologies</a></td>
                <td>49</td>

                <td>72</td>
            </tr>
            <tr>
                <td>21117</td>
                <td><a href='#####################'>New Century Ag Recruiters</a></td>
                <td>41</td>
                <td>75</td>

            </tr>
            <tr>
                <td>21604</td>
                <td><a href='#####################'>Therapy 2000</a></td>
                <td>40</td>
                <td>69</td>
            </tr>

            <tr>
                <td>13384</td>
                <td><a href='#####################'>Bel-Rea Institute of Animal Technology</a></td>
                <td>29</td>
                <td>37</td>
            </tr>
            <tr>

                <td>15551</td>
                <td><a href='#####################'>Trader Joe's Company, Inc.</a></td>
                <td>29</td>
                <td>43</td>
            </tr>
            <tr>
                <td>8407</td>

                <td><a href='#####################'>ImClone Systems</a></td>
                <td>26</td>
                <td>49</td>
            </tr>
            <tr>
                <td>21642</td>
                <td><a href='#####################'>Mt. Rainier</a></td>

                <td>25</td>
                <td>40</td>
            </tr>
            <tr>
                <td>22689</td>
                <td><a href='#####################'>PCO Innovation</a></td>
                <td>22</td>

                <td>33</td>
            </tr>
            <tr>
                <td>18440</td>
                <td><a href='#####################'>Hulu</a></td>
                <td>22</td>
                <td>29</td>

            </tr>
            <tr>
                <td>22104</td>
                <td><a href='#####################'>Conrad's Tire Express and Total Car Care</a></td>
                <td>21</td>
                <td>29</td>
            </tr>

            <tr>
                <td>12216</td>
                <td><a href='#####################'>Itron</a></td>
                <td>20</td>
                <td>33</td>
            </tr>
            <tr>

                <td>20818</td>
                <td><a href='#####################'>Allied Technology Group, Inc.</a></td>
                <td>19</td>
                <td>37</td>
            </tr>
            <tr>
                <td>21296</td>

                <td><a href='#####################'>Spring Mobile</a></td>
                <td>19</td>
                <td>27</td>
            </tr>
            <tr>
                <td>2184</td>
                <td><a href='#####################'>CooperVision</a></td>

                <td>16</td>
                <td>29</td>
            </tr>
            <tr>
                <td>12485</td>
                <td><a href='#####################'>Pepco Holdings</a></td>
                <td>16</td>

                <td>25</td>
            </tr>
            <tr>
                <td>90</td>
                <td><a href='#####################'>HOM Furniture</a></td>
                <td>15</td>
                <td>29</td>

            </tr>
            <tr>
                <td>17405</td>
                <td><a href='#####################'>Hyundai-KIA America Technical Center, Inc.</a></td>
                <td>15</td>
                <td>21</td>
            </tr>

            <tr>
                <td>880</td>
                <td><a href='#####################'>3D Systems</a></td>
                <td>15</td>
                <td>16</td>
            </tr>
            <tr>

                <td>20066</td>
                <td><a href='#####################'>PrincetonOne</a></td>
                <td>14</td>
                <td>24</td>
            </tr>
            <tr>
                <td>22460</td>

                <td><a href='#####################'>Spectrum Athletic Clubs</a></td>
                <td>13</td>
                <td>24</td>
            </tr>
            <tr>
                <td>22513</td>
                <td><a href='#####################'>Jace Reed &amp; Associates</a></td>

                <td>12</td>
                <td>18</td>
            </tr>
            <tr>
                <td>21750</td>
                <td><a href='#####################'>TPG Staffing, LLC</a></td>
                <td>11</td>

                <td>14</td>
            </tr>
            <tr>
                <td>17729</td>
                <td><a href='#####################'>United Airlines</a></td>
                <td>10</td>
                <td>18</td>

            </tr>
            <tr>
                <td>21713</td>
                <td><a href='#####################'>Sriven Systems</a></td>
                <td>10</td>
                <td>11</td>
            </tr>

            <tr>
                <td>20201</td>
                <td><a href='#####################'>Tanknology</a></td>
                <td>9</td>
                <td>13</td>
            </tr>
            <tr>

                <td>21147</td>
                <td><a href='#####################'>Frank's Employment</a></td>
                <td>8</td>
                <td>11</td>
            </tr>
            <tr>
                <td>21345</td>

                <td><a href='#####################'>JoyMark Associates</a></td>
                <td>8</td>
                <td>14</td>
            </tr>
            <tr>
                <td>21537</td>
                <td><a href='#####################'>Zanett</a></td>

                <td>8</td>
                <td>9</td>
            </tr>
            <tr>
                <td>20484</td>
                <td><a href='#####################'>Tell/Com Recruiters</a></td>
                <td>8</td>

                <td>9</td>
            </tr>
            <tr>
                <td>13988</td>
                <td><a href='#####################'>Corsair</a></td>
                <td>6</td>
                <td>11</td>

            </tr>
            <tr>
                <td>14747</td>
                <td><a href='#####################'>Peopleflex Inc</a></td>
                <td>6</td>
                <td>9</td>
            </tr>

            <tr>
                <td>9179</td>
                <td><a href='#####################'>Valeant Pharmaceuticals</a></td>
                <td>6</td>
                <td>9</td>
            </tr>
            <tr>

                <td>22659</td>
                <td><a href='#####################'>McBee Associates</a></td>
                <td>6</td>
                <td>9</td>
            </tr>
            <tr>
                <td>10279</td>

                <td><a href='#####################'>VTech Communications Inc</a></td>
                <td>6</td>
                <td>8</td>
            </tr>
            <tr>
                <td>1422</td>
                <td><a href='#####################'>Arnold & Porter LLP</a></td>

                <td>6</td>
                <td>10</td>
            </tr>
            <tr>
                <td>21351</td>
                <td><a href='#####################'>Pluribus International</a></td>
                <td>6</td>

                <td>12</td>
            </tr>
            <tr>
                <td>13459</td>
                <td><a href='#####################'>L. Robert Kimball & Associates</a></td>
                <td>5</td>

                <td>9</td>
            </tr>
            <tr>
                <td>21319</td>
                <td><a href='#####################'>Baptist Children's Homes</a></td>
                <td>5</td>
                <td>7</td>

            </tr>
            <tr>
                <td>22470</td>
                <td><a href='#####################'>RiseSmart Government</a></td>
                <td>4</td>
                <td>7</td>
            </tr>

            <tr>
                <td>15843</td>
                <td><a href='#####################'>Lend Lease Real Estate Investments, Inc.</a></td>
                <td>4</td>
                <td>7</td>
            </tr>
            <tr>

                <td>947</td>
                <td><a href='#####################'>Hanover Compressor Company</a></td>
                <td>4</td>
                <td>7</td>
            </tr>
            <tr>
                <td>9228</td>

                <td><a href='#####################'>Youth Services International Springfield Academy</a></td>
                <td>3</td>
                <td>5</td>
            </tr>
            <tr>
                <td>20341</td>
                <td><a href='#####################'>Mercer Global Advisors</a></td>

                <td>3</td>
                <td>4</td>
            </tr>
            <tr>
                <td>22685</td>
                <td><a href='#####################'>A Servant's Heart Senior Care</a></td>
                <td>3</td>

                <td>6</td>
            </tr>
            <tr>
                <td>21752</td>
                <td><a href='#####################'>David Hite Executive Recruiting, LLC</a></td>
                <td>2</td>
                <td>3</td>

            </tr>
            <tr>
                <td>21266</td>
                <td><a href='#####################'>RBSI MedStaff</a></td>
                <td>2</td>
                <td>3</td>
            </tr>

            <tr>
                <td>17440</td>
                <td><a href='#####################'>imageQUEST</a></td>
                <td>2</td>
                <td>3</td>
            </tr>
            <tr>

                <td>16706</td>
                <td><a href='#####################'>Abaris Inc.</a></td>
                <td>2</td>
                <td>3</td>
            </tr>
            <tr>
                <td>16563</td>

                <td><a href='#####################'>Mailbox Merchants</a></td>
                <td>2</td>
                <td>3</td>
            </tr>
            <tr>
                <td>22245</td>
                <td><a href='#####################'>The EDH</a></td>

                <td>1</td>
                <td>2</td>
            </tr>
            <tr>
                <td>15535</td>
                <td><a href='#####################'>iGov</a></td>
                <td>1</td>

                <td>2</td>
            </tr>
            <tr>
                <td>19849</td>
                <td><a href='#####################'>Heritage Environmental Services, LLC</a></td>
                <td>1</td>
                <td>2</td>

            </tr>
            <tr>
                <td>19922</td>
                <td><a href='#####################'>KIRA</a></td>
                <td>1</td>
                <td>2</td>
            </tr>

            <tr>
                <td>22926</td>
                <td><a href='#####################'>Spectra Tech, Inc.</a></td>
                <td>1</td>
                <td>2</td>
            </tr>
            <tr>

                <td>22773</td>
                <td><a href='#####################'>net.America</a></td>
                <td>1</td>
                <td>2</td>
            </tr>
            <tr>
                <td>14895</td>

                <td><a href='#####################'>JBR Environmental Consultants, Inc</a></td>
                <td>1</td>
                <td>2</td>
            </tr>
            <tr>
                <td>20705</td>
                <td><a href='#####################'>Dal-Tile Group Inc</a></td>

                <td>1</td>
                <td>2</td>
            </tr>
            <tr>
                <td>21357</td>
                <td><a href='#####################'>2020 Communications</a></td>
                <td>1</td>

                <td>2</td>
            </tr>
</table>
    </body>
</html>";

    /* Remote SMTP Settings left out of this script.  Please fill in with whatever SMTP settings you normally use */
    $pearParams = array("host" => $host, "auth" => $auth, "username" => $user, "password" => $pass);
    $headers = array("From" => $from, "Subject" => $subject);
    $pearMail = Mail::factory("smtp", $pearParams);
    $result = $pearMail->send("lisa@********.com", $headers, $content);
    echo "Message Send Result: " . $result . "<br />";