// This pulls out posts from WordPress and displays them on a Page Template, along with some Custom Fields.

<?php
/*
Template Name: Offerings
*/

get_header(); ?>

        <div id="content" class="widecolumn">
                <div id="copy">
            <?php if (have_posts()) : while (have_posts()) : the_post(); ?>
                        <h1 id="post-<?php the_ID(); ?>"><?php the_title(); ?></h1>
                                <?php the_content('<p class="serif">Read the rest of this page &raquo;</p>'); ?>
                                <?php link_pages('<p><strong>Pages:</strong> ', '</p>', 'number'); ?>
                
                        <? $posts = get_posts('numberposts=50&category=1'); 
                           if($posts) : ?>
                                
                                        <table border="0" cellpadding="5" cellspacing="0" width="100%">
                                        <tr style="background:#cde; font-size:12pt; font-weight:bold">
                                            <td width="40%">Description</td>
                                            <td width="20%">Location</td>
                                            <td width="20%">Revenue</td>
                                            <td width="20%">Earnings</td>
                                        </tr>
                                
                                        <? $i=0;
                                        foreach($posts as $post) : setup_postdata($post); 
                                                $rev = get_post_custom_values('revenue');
                                                $rev1 = trim($rev[0], "$");
                                                $rev2 = str_replace(",", "", $rev1);
                                                $revs[] = preg_replace('/ (\w* ?)?\d*/i', '', $rev2); /* strips space+words+space+digits */
                                                $post_ids[] = $post->ID;
                                        endforeach;
                                
                                        $together = array_combine($post_ids, $revs);
                                        arsort($together);
                                        
                                        if($together) : foreach($together as $key => $value) : get_a_post($key); ?>                       
                                        
                                                <tr<? if($i % 2) { echo ' style="background:#def"'; } ?>>
                                                        <td><a href="<?php the_permalink() ?>"><?php the_title(); ?></a></td>
                                                        <td><?php $loc = get_post_custom_values('location'); echo $loc[0]; ?></td>
                                                        <td><?php $rev = get_post_custom_values('revenue'); if($rev) { echo $rev[0]; } else { echo '&nbsp;'; } ?></td>
                                                        <td><?php $adj = get_post_custom_values('adj_earn'); if($adj) { echo $adj[0]; } else { echo '&nbsp;'; } ?></td>
                                                </tr>
                                        <? $i++; endforeach; endif; ?>
                                
                                </table><br />
                                
                        <? endif; ?>
                        
                <?php endwhile; endif; ?>   
                </div>

<?php get_footer(); ?>