コード例 #1
0
ファイル: gigpress_sidebar.php プロジェクト: alx/Tetalab
    function form($instance)
    {
        global $wpdb;
        $defaults = array('title' => 'Upcoming shows', 'limit' => 5, 'scope' => 'upcoming', 'show_tours' => 'no', 'group_artists' => 'no', 'artist_order' => 'alphabetical', 'artist' => '', 'tour' => '', 'venue' => '', 'show_feeds' => 'no', 'link_text' => '');
        $instance = wp_parse_args($instance, $defaults);
        extract($instance);
        ?>
		
		<p>
			<label for="<?php 
        echo $this->get_field_id('title');
        ?>
"><?php 
        _e('Title');
        ?>
: 
				<input class="widefat" id="<?php 
        echo $this->get_field_id('title');
        ?>
" name="<?php 
        echo $this->get_field_name('title');
        ?>
" type="text" value="<?php 
        echo $title;
        ?>
" />
			</label>
		</p>
		
		<p>
			<select style="width:100%;" id="<?php 
        echo $this->get_field_id('scope');
        ?>
" name="<?php 
        echo $this->get_field_name('scope');
        ?>
">	
				<option value="upcoming"<?php 
        if ($scope == 'upcoming') {
            echo ' selected="selected"';
        }
        ?>
> 
					<?php 
        _e('Display upcoming shows', 'gigpress');
        ?>
				</option>
				<option value="today"<?php 
        if ($scope == 'today') {
            echo ' selected="selected"';
        }
        ?>
> 
					<?php 
        _e("Display today's shows", 'gigpress');
        ?>
				</option>
			</select>
		</p>		

		<p>
			<label for="<?php 
        echo $this->get_field_id('limit');
        ?>
"><?php 
        _e('Number of shows to list', 'gigpress');
        ?>
: 
				<input style="width: 25px; text-align: center;" id="<?php 
        echo $this->get_field_id('limit');
        ?>
" name="<?php 
        echo $this->get_field_name('limit');
        ?>
" type="text" value="<?php 
        echo $limit;
        ?>
" />
			</label>
		</p>

		<p>
			<label for="<?php 
        echo $this->get_field_id('artist');
        ?>
">
				<?php 
        _e('Only display shows from this artist', 'gigpress');
        ?>
			</label>
			<select style="width:100%;" id="<?php 
        echo $this->get_field_id('artist');
        ?>
" name="<?php 
        echo $this->get_field_name('artist');
        ?>
">
		  		<option value="">--</option>
		  	<?php 
        $artists = fetch_gigpress_artists();
        if ($artists != FALSE) {
            foreach ($artists as $this_artist) {
                ?>
				<option value="<?php 
                echo $this_artist->artist_id;
                ?>
"<?php 
                if ($artist == $this_artist->artist_id) {
                    echo ' selected="selected"';
                }
                ?>
><?php 
                echo gigpress_db_out($this_artist->artist_name);
                ?>
</option>
			<?php 
            }
        }
        ?>
			</select>
		</p>

		<p>
			<label for="<?php 
        echo $this->get_field_id('tour');
        ?>
">
				<?php 
        _e('Only display shows from this tour', 'gigpress');
        ?>
			</label>
			<select style="width:100%;" id="<?php 
        echo $this->get_field_id('tour');
        ?>
" name="<?php 
        echo $this->get_field_name('tour');
        ?>
">
		  		<option value="">--</option>
		  	<?php 
        $tours = fetch_gigpress_tours();
        if ($tours != FALSE) {
            foreach ($tours as $this_tour) {
                ?>
				<option value="<?php 
                echo $this_tour->tour_id;
                ?>
"<?php 
                if ($tour == $this_tour->tour_id) {
                    echo ' selected="selected"';
                }
                ?>
><?php 
                echo gigpress_db_out($this_tour->tour_name);
                ?>
</option>
			<?php 
            }
        }
        ?>
			</select>
		</p>
		
		<p>
			<label for="<?php 
        echo $this->get_field_id('venue');
        ?>
">
				<?php 
        _e('Only display shows from this venue', 'gigpress');
        ?>
			</label>
			<select style="width:100%;" id="<?php 
        echo $this->get_field_id('venue');
        ?>
" name="<?php 
        echo $this->get_field_name('venue');
        ?>
">
		  		<option value="">--</option>
		  	<?php 
        $venues = fetch_gigpress_venues();
        if ($venues != FALSE) {
            foreach ($venues as $this_venue) {
                ?>
				<option value="<?php 
                echo $this_venue->venue_id;
                ?>
"<?php 
                if ($venue == $this_venue->venue_id) {
                    echo ' selected="selected"';
                }
                ?>
><?php 
                echo gigpress_db_out($this_venue->venue_name) . ' (' . gigpress_db_out($this_venue->venue_city) . ')';
                ?>
</option>
			<?php 
            }
        }
        ?>
			</select>
		</p>			
			
		<p>
			<label>
				<input id="<?php 
        echo $this->get_field_id('group_artists');
        ?>
" name="<?php 
        echo $this->get_field_name('group_artists');
        ?>
" type="checkbox" value="yes"<?php 
        if ($group_artists == 'yes') {
            echo ' checked="checked"';
        }
        ?>
 /> 
				<?php 
        _e('Group by artist', 'gigpress');
        ?>
<br />
				<small><?php 
        _e('Ignored when filtering by artist, tour, or venue.', 'gigpress');
        ?>
</small>
			</label>
		</p>
		
		<p>
			<select style="width:100%;" id="<?php 
        echo $this->get_field_id('artist_order');
        ?>
" name="<?php 
        echo $this->get_field_name('artist_order');
        ?>
">
				<option value="alphabetical"<?php 
        if ($artist_order == 'alphabetical') {
            echo ' selected="selected"';
        }
        ?>
>
					<?php 
        _e("Order artists alphabetically", "gigpress");
        ?>
				</option>
				<option value="custom"<?php 
        if ($artist_order == 'custom') {
            echo ' selected="selected"';
        }
        ?>
>
					<?php 
        _e("Order artists by custom order", "gigpress");
        ?>
				</option>
			</select><br />
			<small><?php 
        _e('Ignored when not grouping by artist.', 'gigpress');
        ?>
</small>
		</p>

		<p>
			<label>
				<input id="<?php 
        echo $this->get_field_id('show_tours');
        ?>
" name="<?php 
        echo $this->get_field_name('show_tours');
        ?>
" type="checkbox" value="yes"<?php 
        if ($show_tours == 'yes') {
            echo ' checked="checked"';
        }
        ?>
 /> 
				<?php 
        _e('Group by tour', 'gigpress');
        ?>
			</label>
		</p>

		<p>
			<label>
				<input id="<?php 
        echo $this->get_field_id('show_feeds');
        ?>
" name="<?php 
        echo $this->get_field_name('show_feeds');
        ?>
" type="checkbox" value="yes"<?php 
        if ($show_feeds == 'yes') {
            echo ' checked="checked"';
        }
        ?>
 /> 
				<?php 
        _e('Show RSS and iCal feeds', 'gigpress');
        ?>
			</label>
		</p>
										
		<p>
			<label for="<?php 
        echo $this->get_field_id('link_text');
        ?>
"><?php 
        _e('Link text');
        ?>
: 
				<input class="widefat" id="<?php 
        echo $this->get_field_id('link_text');
        ?>
" name="<?php 
        echo $this->get_field_name('link_text');
        ?>
" type="text" value="<?php 
        echo $link_text;
        ?>
" /><br />
				<small><?php 
        _e('This phrase is used to link to the page specified in your GigPress settings. (Leave blank to disable this link.)', 'gigpress');
        ?>
</small>
			</label>
		</p>
<?php 
    }
コード例 #2
0
ファイル: new.php プロジェクト: alx/Tetalab
function gigpress_add()
{
    global $wpdb, $wp_locale;
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "add") {
        // This is for when we've just POST-ed a new show ...
        require_once 'handlers.php';
        $result = gigpress_add_show();
    }
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "update") {
        require_once 'handlers.php';
        $result = gigpress_update_show();
    }
    $gpo = get_option('gigpress_settings');
    // If they're done with the welcome message, kill it
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "killwelcome") {
        $gpo['welcome'] = "no";
        update_option('gigpress_settings', $gpo);
        $gpo = get_option('gigpress_settings');
    }
    // If the welcome message is to be displayed, then do so
    if ($gpo['welcome'] == "yes") {
        ?>
	
		<div id="message" class="updated">
			<p>
				<?php 
        _e("<strong>Welcome to GigPress!</strong> Get started by adding your first show below. To display your shows, simply add the", "gigpress");
        ?>
 [gigpress_shows] <?php 
        _e("shortcode to any page or post.", "gigpress");
        ?>
				<?php 
        _e("Questions?  Please check out the", "gigpress");
        ?>
 <a href="http://gigpress.com/docs"><?php 
        _e("documentation", "gigpress");
        ?>
</a> <?php 
        _e("and", "gigpress");
        ?>
 <a href="http://gigpress.com/faq"><?php 
        _e("FAQ", "gigpress");
        ?>
</a> <?php 
        _e("on the GigPress website. Enjoy!", "gigpress");
        ?>
 <small>(<a href="<?php 
        bloginfo('wpurl');
        ?>
/wp-admin/admin.php?page=gigpress/gigpress.php&amp;gpaction=killwelcome"><?php 
        _e("Don't show this again", "gigpress");
        ?>
.</a>)</small>
			</p>
		</div>
		
	<?php 
    }
    ?>
	
	<div class="wrap gigpress">
	
	<?php 
    // Setup months
    $gp_months = array('01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12');
    // Sanitize the show_id if we're editing or fixing errors
    $show_id = isset($_REQUEST['show_id']) ? $wpdb->prepare('%d', $_REQUEST['show_id']) : '';
    // If the handler returned an array ($result), it means there were errors.
    // This takes precedence over any other conditionals below.
    if (is_array($result)) {
        $mm = $_POST['gp_mm'];
        $dd = $_POST['gp_dd'];
        $yy = $_POST['gp_yy'];
        $hh = $_POST['gp_hh'];
        $min = $_POST['gp_min'];
        $exp_mm = $_POST['exp_mm'];
        $exp_dd = $_POST['exp_dd'];
        $exp_yy = $_POST['exp_yy'];
        $show_multi = $_POST['show_multi'];
        $show_artist_id = $_POST['show_artist_id'];
        $show_venue_id = $_POST['show_venue_id'];
        $new_artist_name = gigpress_db_out($_POST['artist_name']);
        $new_venue_name = gigpress_db_out($_POST['venue_name']);
        $venue_address = gigpress_db_out($_POST['venue_address']);
        $new_venue_city = gigpress_db_out($_POST['venue_city']);
        $venue_country = gigpress_db_out($_POST['venue_country']);
        $venue_url = gigpress_db_out($_POST['venue_url']);
        $venue_phone = gigpress_db_out($_POST['venue_phone']);
        $new_tour_name = gigpress_db_out($_POST['tour_name']);
        $show_ages = gigpress_db_out($_POST['show_ages']);
        $show_tix_url = gigpress_db_out($_POST['show_tix_url']);
        $show_tix_phone = gigpress_db_out($_POST['show_tix_phone']);
        $show_notes = gigpress_db_out($_POST['show_notes']);
        $show_price = gigpress_db_out($_POST['show_price']);
        $show_tour_id = $_POST['show_tour_id'];
        $show_related = $_POST['show_related'];
        $show_related_title = gigpress_db_out($_POST['show_related_title']);
        $show_related_date = $_POST['show_related_date'];
        $show_status = $_POST['show_status'];
        $have_data = TRUE;
    } else {
        if (isset($_GET['gpaction']) && ($_GET['gpaction'] == "edit" || $_GET['gpaction'] == "copy")) {
            // We're about to edit an existing show ...
            // Load the previous show info into the edit form, and so forth
            $show_edit = $wpdb->get_results("\n\t\t\tSELECT * from " . GIGPRESS_SHOWS . " WHERE show_id = " . $show_id . " LIMIT 1\n\t\t\t");
            if ($show_edit) {
                // We got the goods from the DB
                foreach ($show_edit as $show) {
                    $show_date = explode('-', $show->show_date);
                    $mm = $show_date[1];
                    $dd = $show_date[2];
                    $yy = $show_date[0];
                    $show_time = explode(':', $show->show_time);
                    $hh = $show_time[0];
                    $min = $show_time[1];
                    $ss = $show_time[2];
                    if ($ss == "01") {
                        $hh = "na";
                        $min = "na";
                    }
                    $show_expire = explode('-', $show->show_expire);
                    $exp_mm = $show_expire[1];
                    $exp_dd = $show_expire[2];
                    $exp_yy = $show_expire[0];
                    $show_multi = $show->show_multi;
                    $show_artist_id = $show->show_artist_id;
                    $show_venue_id = $show->show_venue_id;
                    $show_ages = gigpress_db_out($show->show_ages);
                    $show_tix_url = gigpress_db_out($show->show_tix_url);
                    $show_tix_phone = gigpress_db_out($show->show_tix_phone);
                    $show_notes = gigpress_db_out($show->show_notes);
                    $show_price = gigpress_db_out($show->show_price);
                    $show_tour_id = $show->show_tour_id;
                    $show_related = $show->show_related;
                    $show_related_title = $gpo['default_title'];
                    $show_related_date = $gpo['related_date'];
                    $show_status = $show->show_status;
                }
                $have_data = TRUE;
            } else {
                $have_data == FALSE;
                $load_error = '<div id="message" class="error fade"><p>' . __("Sorry, but we had trouble loading that show for editing.", "gigpress") . '</div>';
            }
        }
    }
    if (!$have_data) {
        // We're adding a new show, so get the defaults
        $show_date = explode('-', $gpo['default_date']);
        $mm = $show_date[1];
        $dd = $show_date[2];
        $yy = $show_date[0];
        $show_time = explode(':', $gpo['default_time']);
        $hh = $show_time[0];
        $min = $show_time[1];
        $ss = $show_time[2];
        if ($ss == "01") {
            $hh = "na";
            $min = "na";
        }
        $show_expire = explode('-', $gpo['default_date']);
        $exp_mm = $show_expire[1];
        $exp_dd = $show_expire[2];
        $exp_yy = $show_expire[0];
        $show_artist_id = $gpo['default_artist'];
        $show_tour_id = $gpo['default_tour'];
        $venue_country = $gpo['default_country'];
        $show_related_title = $gpo['default_title'];
        $show_related_date = $gpo['related_date'];
    }
    screen_icon('gigpress');
    // We're editing a show
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "edit" && $show_edit || $result['editing'] == TRUE) {
        ?>
		
			<h2><?php 
        _e("Edit this show", "gigpress");
        ?>
</h2>
		
			<form method="post" action="<?php 
        bloginfo('wpurl');
        ?>
/wp-admin/admin.php?page=gigpress/gigpress.php">
				<?php 
        wp_nonce_field('gigpress-action');
        ?>
				<input type="hidden" name="gpaction" value="update" />
				<input type="hidden" name="show_id" value="<?php 
        echo $show_id;
        ?>
" />
		
		<?php 
    } else {
        // We're adding a new show
        ?>
		
			<h2><?php 
        _e("Add a show", "gigpress");
        ?>
</h2>
			
			<?php 
        if ($load_error) {
            echo $load_error;
        }
        ?>
					
			<form method="post" action="<?php 
        bloginfo('wpurl');
        ?>
/wp-admin/admin.php?page=gigpress/gigpress.php">
				<?php 
        wp_nonce_field('gigpress-action');
        ?>
				<input type="hidden" name="gpaction" value="add" />
				<input type="hidden" name="show_status" value="active" />
				
		<?php 
    }
    ?>
			
			<table class="form-table gp-table" cellspacing="0">
			<tbody>
			  <tr>
				<th scope="row"><label for="gp_mm"><?php 
    _e("Date", "gigpress");
    ?>
:<span class="gp-required">*</span></label></th>
					<td>
					<?php 
    if ($result['show_date']) {
        echo '<span class="gigpress-error">';
    }
    ?>
				
					<select name="gp_mm" id="gp_mm">
					<?php 
    foreach ($gp_months as $month) {
        ?>
						<option value="<?php 
        echo $month;
        ?>
"<?php 
        if ($mm == $month) {
            ?>
 selected="selected"<?php 
        }
        ?>
>
							<?php 
        echo $wp_locale->get_month($month);
        ?>
						</option>
					<?php 
    }
    ?>
					</select>
					  <select name="gp_dd" id="gp_dd">
					  	<?php 
    for ($i = 1; $i <= 31; $i++) {
        $i = $i < 10 ? '0' . $i : $i;
        echo '<option value="' . $i . '"';
        if ($dd == $i) {
            echo ' selected="selected"';
        }
        echo '>' . $i . '</option>';
    }
    ?>
					  </select>
					  
					  <select name="gp_yy" id="gp_yy">
					  	<?php 
    for ($i = 1900; $i <= 2050; $i++) {
        echo '<option value="' . $i . '"';
        if ($yy == $i) {
            echo ' selected="selected"';
        }
        echo '>' . $i . '</option>';
    }
    ?>
					</select>
					<?php 
    if ($result['show_date']) {
        echo '</span>';
    }
    ?>
				
					&nbsp; <?php 
    _e("at", "gigpress");
    ?>
 &nbsp; 
					
					<?php 
    if ($gpo['alternate_clock'] == 1) {
        ?>
					<select name="gp_hh" id="gp_hh" class="twentyfour">
						<option value="na"<?php 
        if ($hh == "na") {
            echo ' selected="selected"';
        }
        ?>
>--</option>
						<option value="00"<?php 
        if ($hh == "00") {
            echo ' selected="selected"';
        }
        ?>
>00</option>
						<option value="01"<?php 
        if ($hh == "01") {
            echo ' selected="selected"';
        }
        ?>
>01</option>
						<option value="02"<?php 
        if ($hh == "02") {
            echo ' selected="selected"';
        }
        ?>
>02</option>
						<option value="03"<?php 
        if ($hh == "03") {
            echo ' selected="selected"';
        }
        ?>
>03</option>
						<option value="04"<?php 
        if ($hh == "04") {
            echo ' selected="selected"';
        }
        ?>
>04</option>
						<option value="05"<?php 
        if ($hh == "05") {
            echo ' selected="selected"';
        }
        ?>
>05</option>
						<option value="06"<?php 
        if ($hh == "06") {
            echo ' selected="selected"';
        }
        ?>
>06</option>
						<option value="07"<?php 
        if ($hh == "07") {
            echo ' selected="selected"';
        }
        ?>
>07</option>
						<option value="08"<?php 
        if ($hh == "08") {
            echo ' selected="selected"';
        }
        ?>
>08</option>
						<option value="09"<?php 
        if ($hh == "09") {
            echo ' selected="selected"';
        }
        ?>
>09</option>
						<option value="10"<?php 
        if ($hh == "10") {
            echo ' selected="selected"';
        }
        ?>
>10</option>
						<option value="11"<?php 
        if ($hh == "11") {
            echo ' selected="selected"';
        }
        ?>
>11</option>
						<option value="12"<?php 
        if ($hh == "12") {
            echo ' selected="selected"';
        }
        ?>
>12</option>
						<option value="13"<?php 
        if ($hh == "13") {
            echo ' selected="selected"';
        }
        ?>
>13</option>
						<option value="14"<?php 
        if ($hh == "14") {
            echo ' selected="selected"';
        }
        ?>
>14</option>
						<option value="15"<?php 
        if ($hh == "15") {
            echo ' selected="selected"';
        }
        ?>
>15</option>
						<option value="16"<?php 
        if ($hh == "16") {
            echo ' selected="selected"';
        }
        ?>
>16</option>
						<option value="17"<?php 
        if ($hh == "17") {
            echo ' selected="selected"';
        }
        ?>
>17</option>
						<option value="18"<?php 
        if ($hh == "18") {
            echo ' selected="selected"';
        }
        ?>
>18</option>
						<option value="19"<?php 
        if ($hh == "19") {
            echo ' selected="selected"';
        }
        ?>
>19</option>
						<option value="20"<?php 
        if ($hh == "20") {
            echo ' selected="selected"';
        }
        ?>
>20</option>
						<option value="21"<?php 
        if ($hh == "21") {
            echo ' selected="selected"';
        }
        ?>
>21</option>
						<option value="22"<?php 
        if ($hh == "22") {
            echo ' selected="selected"';
        }
        ?>
>22</option>
						<option value="23"<?php 
        if ($hh == "23") {
            echo ' selected="selected"';
        }
        ?>
>23</option>
					</select>
					<?php 
    } else {
        ?>
					<select name="gp_hh" id="gp_hh" class="twelve">
						<optgroup label="<?php 
        _e("None", "gigpress");
        ?>
">
						  <option value="na"<?php 
        if ($hh == "na") {
            echo ' selected="selected"';
        }
        ?>
>--</option>
						</optgroup>
						<optgroup id="am" label="AM">
						  <option value="00"<?php 
        if ($hh == "00") {
            echo ' selected="selected"';
        }
        ?>
>12</option>
						  <option value="01"<?php 
        if ($hh == "01") {
            echo ' selected="selected"';
        }
        ?>
>01</option>
						  <option value="02"<?php 
        if ($hh == "02") {
            echo ' selected="selected"';
        }
        ?>
>02</option>
						  <option value="03"<?php 
        if ($hh == "03") {
            echo ' selected="selected"';
        }
        ?>
>03</option>
						  <option value="04"<?php 
        if ($hh == "04") {
            echo ' selected="selected"';
        }
        ?>
>04</option>
						  <option value="05"<?php 
        if ($hh == "05") {
            echo ' selected="selected"';
        }
        ?>
>05</option>
						  <option value="06"<?php 
        if ($hh == "06") {
            echo ' selected="selected"';
        }
        ?>
>06</option>
						  <option value="07"<?php 
        if ($hh == "07") {
            echo ' selected="selected"';
        }
        ?>
>07</option>
						  <option value="08"<?php 
        if ($hh == "08") {
            echo ' selected="selected"';
        }
        ?>
>08</option>
						  <option value="09"<?php 
        if ($hh == "09") {
            echo ' selected="selected"';
        }
        ?>
>09</option>
						  <option value="10"<?php 
        if ($hh == "10") {
            echo ' selected="selected"';
        }
        ?>
>10</option>
						  <option value="11"<?php 
        if ($hh == "11") {
            echo ' selected="selected"';
        }
        ?>
>11</option>
						</optgroup>
						<optgroup id="pm" label="PM">
						  <option value="12"<?php 
        if ($hh == "12") {
            echo ' selected="selected"';
        }
        ?>
>12</option>
						  <option value="13"<?php 
        if ($hh == "13") {
            echo ' selected="selected"';
        }
        ?>
>01</option>
						  <option value="14"<?php 
        if ($hh == "14") {
            echo ' selected="selected"';
        }
        ?>
>02</option>
						  <option value="15"<?php 
        if ($hh == "15") {
            echo ' selected="selected"';
        }
        ?>
>03</option>
						  <option value="16"<?php 
        if ($hh == "16") {
            echo ' selected="selected"';
        }
        ?>
>04</option>
						  <option value="17"<?php 
        if ($hh == "17") {
            echo ' selected="selected"';
        }
        ?>
>05</option>
						  <option value="18"<?php 
        if ($hh == "18") {
            echo ' selected="selected"';
        }
        ?>
>06</option>
						  <option value="19"<?php 
        if ($hh == "19") {
            echo ' selected="selected"';
        }
        ?>
>07</option>
						  <option value="20"<?php 
        if ($hh == "20") {
            echo ' selected="selected"';
        }
        ?>
>08</option>
						  <option value="21"<?php 
        if ($hh == "21") {
            echo ' selected="selected"';
        }
        ?>
>09</option>
						  <option value="22"<?php 
        if ($hh == "22") {
            echo ' selected="selected"';
        }
        ?>
>10</option>
						  <option value="23"<?php 
        if ($hh == "23") {
            echo ' selected="selected"';
        }
        ?>
>11</option>
						</optgroup>
					</select>
					<?php 
    }
    ?>
					<select name="gp_min" id="gp_min">
						  	<option value="na"<?php 
    if ($min == "na") {
        echo ' selected="selected"';
    }
    ?>
>--</option>
							<option value="00"<?php 
    if ($min == "00") {
        echo ' selected="selected"';
    }
    ?>
>00</option>
							<option value="05"<?php 
    if ($min == "05") {
        echo ' selected="selected"';
    }
    ?>
>05</option>
							<option value="10"<?php 
    if ($min == "10") {
        echo ' selected="selected"';
    }
    ?>
>10</option>
							<option value="15"<?php 
    if ($min == "15") {
        echo ' selected="selected"';
    }
    ?>
>15</option>
							<option value="20"<?php 
    if ($min == "20") {
        echo ' selected="selected"';
    }
    ?>
>20</option>
							<option value="25"<?php 
    if ($min == "25") {
        echo ' selected="selected"';
    }
    ?>
>25</option>
							<option value="30"<?php 
    if ($min == "30") {
        echo ' selected="selected"';
    }
    ?>
>30</option>
							<option value="35"<?php 
    if ($min == "35") {
        echo ' selected="selected"';
    }
    ?>
>35</option>
							<option value="40"<?php 
    if ($min == "40") {
        echo ' selected="selected"';
    }
    ?>
>40</option>
							<option value="45"<?php 
    if ($min == "45") {
        echo ' selected="selected"';
    }
    ?>
>45</option>
							<option value="50"<?php 
    if ($min == "50") {
        echo ' selected="selected"';
    }
    ?>
>50</option>
							<option value="55"<?php 
    if ($min == "55") {
        echo ' selected="selected"';
    }
    ?>
>55</option>
					</select>
						<span id="ampm">&nbsp;</span>
						<p><span class="description">&nbsp;<label><input type="checkbox" value="1"<?php 
    if ($show_multi == 1) {
        echo ' checked="checked"';
    }
    ?>
 id="show_multi" name="show_multi" />&nbsp;<?php 
    _e("This is a multi-day event", "gigpress");
    ?>
</label></span></p>
						</td>
					</tr>
					<!-- For multiple-day events -->
					<tr id="expire"<?php 
    if ($show_multi != 1) {
        echo ' class="gigpress-inactive"';
    }
    ?>
>
						<th scope="row"><label for="exp_mm"><?php 
    _e("End date", "gigpress");
    ?>
:</label></th>
						<td>
						<?php 
    if ($result['expire_date']) {
        echo '<span class="gigpress-error">';
    }
    ?>
						<select name="exp_mm" id="exp_mm">
						<?php 
    foreach ($gp_months as $month) {
        ?>
							<option value="<?php 
        echo $month;
        ?>
"<?php 
        if ($exp_mm == $month) {
            ?>
 selected="selected"<?php 
        }
        ?>
>
								<?php 
        echo $wp_locale->get_month($month);
        ?>
							</option>
						<?php 
    }
    ?>
						</select>
						
						  <select name="exp_dd" id="exp_dd">
						  	<?php 
    for ($i = 1; $i <= 31; $i++) {
        $i = $i < 10 ? '0' . $i : $i;
        echo '<option value="' . $i . '"';
        if ($exp_dd == $i) {
            echo ' selected="selected"';
        }
        echo '>' . $i . '</option>';
    }
    ?>
						  </select>
						  
						  <select name="exp_yy" id="exp_yy">
						  	<?php 
    for ($i = 1900; $i <= 2050; $i++) {
        echo '<option value="' . $i . '"';
        if ($exp_yy == $i) {
            echo ' selected="selected"';
        }
        echo '>' . $i . '</option>';
    }
    ?>
					  	</select>
						<?php 
    if ($result['expire_date']) {
        echo '</span>';
    }
    ?>
						</td>
					</tr>
				<tr>
					<th scope="row"><label for="show_artist_id"><?php 
    _e("Artist", "gigpress");
    ?>
:<span class="gp-required">*</span></label></th>
					<td>
					<select name="show_artist_id" id="show_artist_id" class="can-add-new">
						<option value="new"<?php 
    if ($show_artist_id == 'new') {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Add a new artist", "gigpress");
    ?>
</option>
						<option value="">------------------</option>
					  	<?php 
    $artists = fetch_gigpress_artists();
    if ($artists != FALSE) {
        foreach ($artists as $artist) {
            $artist_name = gigpress_db_out($artist->artist_name);
            echo "<option value=\"{$artist->artist_id}\"";
            if ($show_artist_id == $artist->artist_id) {
                echo ' selected="selected"';
            }
            echo ">{$artist_name}</option>\n\t\t\t";
        }
    } else {
        echo '<option value="0" selected="selected">' . __("No artists in the database", "gigpress") . '</option>';
    }
    ?>
					  </select>
					</td>
				  </tr>
				 </tbody>
				 
				<tbody id="show_artist_id_new" class="gigpress-addition<?php 
    if ($show_artist_id != 'new') {
        echo ' gigpress-inactive';
    }
    ?>
">
				<tr>
					<th scope="row"><label for="artist_name"><?php 
    _e("Artist name", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="artist_name" id="artist_name" value="<?php 
    echo $new_artist_name;
    ?>
"<?php 
    if ($result['artist_name']) {
        echo ' class="gigpress-error"';
    }
    ?>
 /></td>
				</tr>
				</tbody>
				
				<tbody>
				<tr>
					<th scope="row"><label for="show_venue_id"><?php 
    _e("Venue", "gigpress");
    ?>
:<span class="gp-required">*</span></label></th>
					<td>
					<select name="show_venue_id" id="show_venue_id" class="can-add-new">
						<option value="new"<?php 
    if ($show_venue_id == 'new') {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Add a new venue", "gigpress");
    ?>
</option>
						<option value="">------------------</option>
						<option value=""<?php 
    if (!$show_venue_id) {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Select a venue", "gigpress");
    ?>
</option>
						<option value="">------------------</option>
					  	<?php 
    $venues = fetch_gigpress_venues();
    if ($venues != FALSE) {
        foreach ($venues as $venue) {
            $venue_name = gigpress_db_out($venue->venue_name);
            $venue_city = gigpress_db_out($venue->venue_city);
            echo "<option value=\"{$venue->venue_id}\"";
            if ($show_venue_id == $venue->venue_id) {
                echo ' selected="selected"';
            }
            echo ">{$venue_name} ({$venue_city})</option>\n\t\t\t";
        }
    } else {
        echo "<option value=\"0\">" . __("No venues in the database", "gigpress") . "</option>/n/t/t/t";
    }
    ?>
					  </select>
					</td>
				  </tr>
				</tbody>
				
				<tbody id="show_venue_id_new" class="gigpress-addition<?php 
    if ($show_venue_id != 'new') {
        echo ' gigpress-inactive';
    }
    ?>
">
				  <tr>
					<th scope="row"><label for="venue_name"><?php 
    _e("Venue name", "gigpress");
    ?>
:<span class="gp-required">*</span></label>
					</th>
					<td><input type="text" size="48" name="venue_name" id="venue_name" value="<?php 
    echo $new_venue_name;
    ?>
"<?php 
    if ($result['venue_name']) {
        echo ' class="gigpress-error"';
    }
    ?>
 /></td>
				  </tr>	
				<tr>
					<th scope="row"><label for="venue_city"><?php 
    _e("Venue city", "gigpress");
    ?>
:<span class="gp-required">*</span></label></th>
					<td><input type="text" size="48" name="venue_city" id="venue_city" value="<?php 
    echo $new_venue_city;
    ?>
"<?php 
    if ($result['venue_city']) {
        echo ' class="gigpress-error"';
    }
    ?>
 class="required" /></td>
				</tr>			  		
				<tr>
					<th scope="row"><label for="venue_address"><?php 
    _e("Venue address", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="venue_address" id="venue_address" value="<?php 
    echo $venue_address;
    ?>
" /></td>
				  </tr>
				  
				 <tr>
					<th scope="row"><label for="venue_country"><?php 
    _e("Venue country", "gigpress");
    ?>
:</label></th>
					<td>
						<select name="venue_country" id="venue_country">
						<?php 
    global $gp_countries;
    foreach ($gp_countries as $code => $name) {
        $sel = $code == $venue_country ? ' selected="selected"' : '';
        echo '<option value="' . $code . '"' . $sel . '>' . $name . '</option>';
    }
    ?>
						</select>
					</td>
				  </tr>
				  			  
				  <tr>
					<th scope="row"><label for="venue_url"><?php 
    _e("Venue website", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="venue_url" id="venue_url" value="<?php 
    echo $venue_url;
    ?>
" /></td>
				  </tr>
				  <tr>
					<th scope="row"><label for="venue_phone"><?php 
    _e("Venue phone", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="venue_phone" id="venue_phone" value="<?php 
    echo $venue_phone;
    ?>
" /></td>
				  </tr>			  
				</tbody>
				
				<tbody>
				<?php 
    if ($_GET['gpaction'] == 'edit' || $result['editing'] == TRUE) {
        ?>
				<tr>
					<th scope="row"><label for="show_status"><?php 
        _e("Status", "gigpress");
        ?>
:</label></th>
					<td><select name="show_status" id="show_status">
							<option value="active"<?php 
        if ($show_status == 'active') {
            echo ' selected="selected"';
        }
        ?>
><?php 
        _e("Active", "gigpress");
        ?>
</option>
							<option value="soldout"<?php 
        if ($show_status == 'soldout') {
            echo ' selected="selected"';
        }
        ?>
><?php 
        _e("Sold Out", "gigpress");
        ?>
</option>
							<option value="cancelled"<?php 
        if ($show_status == 'cancelled') {
            echo ' selected="selected"';
        }
        ?>
><?php 
        _e("Cancelled", "gigpress");
        ?>
</option>
						</select>
					</td>
				</tr>
				<?php 
    }
    ?>
			
				  <tr>
					<th scope="row"><label for="show_ages"><?php 
    _e("Admittance", "gigpress");
    ?>
:</label></th>
					<td><select name="show_ages" id="show_ages">
					  <option value="Not sure"<?php 
    if ($show_ages == "Not sure") {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Not sure", "gigpress");
    ?>
</option>
					  <?php 
    $ages = explode('|', $gpo['age_restrictions']);
    foreach ($ages as $age) {
        $age = trim($age);
        $selected = $show_ages == $age ? ' selected="selected"' : '';
        echo '<option value="' . $age . '"' . $selected . '>' . $age . '</option>
					  		';
    }
    ?>
					  </select>
					</td>
				  </tr>
				  <tr>
					<th scope="row"><label for="show_price"><?php 
    _e("Price", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="10" name="show_price" id="show_price" value="<?php 
    echo $show_price;
    ?>
" /> <span class="description">(<?php 
    _e("include currency symbol", "gigpress");
    ?>
)</span></td>
				  </tr>
				  <tr>
					<th scope="row"><label for="show_tix_url"><?php 
    _e("Ticket URL", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="show_tix_url" id="show_tix_url" value="<?php 
    echo $show_tix_url;
    ?>
" /></td>
				  </tr>
	 				<tr>
					<th scope="row"><label for="show_tix_phone"><?php 
    _e("Ticket phone", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="show_tix_phone" id="show_tix_phone" value="<?php 
    echo $show_tix_phone;
    ?>
" /></td>
				  </tr>
				  <tr>
					<th scope="row"><label for="show_notes"><?php 
    _e("Notes", "gigpress");
    ?>
:</label></th>
					<td>
						<textarea name="show_notes" id="show_notes" cols="45" rows="5"><?php 
    echo $show_notes;
    ?>
</textarea><br />
						<span class="description"><?php 
    _e("Use this space to list other bands, 'presented by' info, etc", "gigpress");
    ?>
</span>
					</td>
				  </tr>
				  <tr>
					<th scope="row"><label for="show_tour_id"><?php 
    _e("Part of a tour?", "gigpress");
    ?>
</label></th>
					<td>
						<select name="show_tour_id" id="show_tour_id" class="can-add-new">
						<option value="0"><?php 
    _e("No", "gigpress");
    ?>
</option>
						<option value="0">------------------</option>
						<option value="new"<?php 
    if ($show_tour_id == 'new') {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Add a new tour", "gigpress");
    ?>
</option>
						<option value="0">------------------</option>
					  	<?php 
    $tours = fetch_gigpress_tours();
    if ($tours != FALSE) {
        foreach ($tours as $tour) {
            $tour_name = gigpress_db_out($tour->tour_name);
            echo "<option value=\"{$tour->tour_id}\"";
            if ($show_tour_id == $tour->tour_id) {
                echo ' selected="selected"';
            }
            echo ">{$tour_name}</option>\n\t\t\t";
        }
    } else {
        echo "<option value=\"\">" . __("No tours in the database", "gigpress") . "</option>/n/t/t/t";
    }
    ?>
					  </select>
					</td>
				  </tr>
			</tbody>
			
			<tbody id="show_tour_id_new" class="gigpress-addition<?php 
    if ($show_tour_id != 'new') {
        echo ' gigpress-inactive';
    }
    ?>
">
				<tr>
					<th scope="row"><label for="tour_name"><?php 
    _e("Tour name", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="tour_name" id="tour_name" value="<?php 
    echo $new_tour_name;
    ?>
"<?php 
    if ($result['tour_name']) {
        echo ' class="gigpress-error"';
    }
    ?>
 /></td>
				</tr>
			</tbody>	  
			
			<tbody>
			<tr>
					<th scope="row"><label for="show_related"><?php 
    _e("Related post", "gigpress");
    ?>
:</label></th>
					<td>
						<select name="show_related" id="show_related" class="can-add-new">
					  		<option value="0"><?php 
    _e("None", "gigpress");
    ?>
</option>
							<option value="0">------------------</option>
					  		<option value="new"<?php 
    if ($_GET['gpaction'] != "edit" && $gpo['autocreate_post'] == "1") {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Add a new post", "gigpress");
    ?>
</option>
							<option value="0">------------------</option>
							
					  	<?php 
    $entries = $wpdb->get_results("SELECT ID, post_title FROM " . $wpdb->prefix . "posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY ID DESC LIMIT 500", ARRAY_A);
    if ($entries != FALSE) {
        foreach ($entries as $entry) {
            ?>
								<option value="<?php 
            echo $entry['ID'];
            ?>
"<?php 
            if ($entry['ID'] == $show_related) {
                echo ' selected="selected"';
                $found_related = TRUE;
            }
            ?>
><?php 
            echo gigpress_db_out($entry['post_title']);
            ?>
</option>
						<?php 
        }
    }
    ?>
						
						<?php 
    if ($show_related != FALSE && !isset($found_related)) {
        $old_related = $wpdb->get_results("SELECT ID, post_title FROM " . $wpdb->prefix . "posts WHERE post_status = 'publish' AND post_type = 'post' AND ID = " . $wpdb->prepare('%d', $show_related) . " LIMIT 1", ARRAY_A);
        if ($old_related != FALSE) {
            foreach ($old_related as $entry) {
                ?>
									<option value="<?php 
                echo $entry['ID'];
                ?>
" selected="selected"><?php 
                echo gigpress_db_out($entry['post_title']);
                ?>
</option>
						<?php 
            }
        }
    }
    ?>
					  </select>
					</td>
				  </tr>
				 </tbody>
				<tbody id="show_related_new" class="gigpress-addition<?php 
    if ($show_related != 'new' && $gpo['autocreate_post'] != "1") {
        echo ' gigpress-inactive';
    }
    ?>
">
				<tr>
					<th scope="row"><label for="show_related_title"><?php 
    _e("Related post title", "gigpress");
    ?>
:</label></th>
					<td><input type="text" size="48" name="show_related_title" id="show_related_title" value="<?php 
    echo $show_related_title;
    ?>
" /><br />
					<span class="description"><?php 
    _e("Available placeholders:", "gigpress");
    ?>
 <code>%date%</code>, <code>%long_date%</code>, <code>%artist%</code>, <code>%city%</code>, <code>%venue%</code>.</span><br />
					<label><input type="radio" name="show_related_date" value="now"<?php 
    if ($show_related_date == 'now') {
        echo ' checked="checked"';
    }
    ?>
 /> <?php 
    _e('Publish now', 'gigpress');
    ?>
</label> &nbsp; 
					<label><input type="radio" name="show_related_date" value="show"<?php 
    if ($show_related_date == 'show') {
        echo ' checked="checked"';
    }
    ?>
 /> <?php 
    _e('Publish on show date', 'gigpress');
    ?>
</label>
					</td>
				</tr>
			</tbody>
			<tbody>  				 
				<tr>
					<td>&nbsp;</td>
					<td>
				<?php 
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "edit" || $result['editing'] == TRUE) {
        ?>
					<span class="submit"><input type="submit" name="Submit" class="button-primary" value="<?php 
        _e("Update show", "gigpress");
        ?>
" /></span> <?php 
        _e("or", "gigpress");
        ?>
 <a href="<?php 
        bloginfo('wpurl');
        ?>
/wp-admin/admin.php?page=gigpress-shows"><?php 
        _e("cancel", "gigpress");
        ?>
</a>
				
				<?php 
    } else {
        ?>
				
					<span class="submit"><input type="submit" name="Submit" class="button-primary" value="<?php 
        _e("Add show", "gigpress");
        ?>
" /></span>
				
				<?php 
    }
    ?>
				</td>
				</tr>
				</tbody>
			</table>		
		</form>
	</div>
	<?php 
    unset($result);
}
コード例 #3
0
ファイル: artists.php プロジェクト: Ashleyotero/oldest-old
function gigpress_artists()
{
    global $wpdb;
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "add") {
        require_once 'handlers.php';
        $result = gigpress_add_artist();
    }
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "update") {
        require_once 'handlers.php';
        $result = gigpress_update_artist();
    }
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "delete") {
        require_once 'handlers.php';
        gigpress_delete_artist();
    }
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "import-tours") {
        require_once 'handlers.php';
        gigpress_map_tours_to_artists();
    }
    $url_args = isset($_GET['gp-page']) ? '&amp;gp-page=' . $_GET['gp-page'] : '';
    ?>

	<div class="wrap gigpress gp-artists">

	<?php 
    screen_icon('gigpress');
    ?>
		
	<h2><?php 
    _e("Artists", "gigpress");
    ?>
</h2>	
	
	<?php 
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "edit" || is_array($result) && $result['editing'] == TRUE) {
        $artist_id = isset($_REQUEST['artist_id']) ? $wpdb->prepare('%d', $_REQUEST['artist_id']) : '';
        $artist_name = gigpress_db_out($wpdb->get_var("SELECT artist_name from " . GIGPRESS_ARTISTS . " WHERE artist_id = " . $artist_id));
        if ($artist_name) {
            $submit = '<span class="submit"><input type="submit" name="Submit" class="button-primary" value="' . __("Update artist", "gigpress") . '" /></span> ' . __("or", "gigpress") . ' <a href="' . get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-artists' . $url_args . '">' . __("cancel", "gigpress") . '</a>';
            ?>

			<h3><?php 
            _e("Edit this artist", "gigpress");
            ?>
</h3>
		
			<form method="post" action="<?php 
            echo get_bloginfo('wpurl') . "/wp-admin/admin.php?page=gigpress-artists" . $url_args;
            ?>
">
			<input type="hidden" name="gpaction" value="update" />
			<input type="hidden" name="artist_id" value="<?php 
            echo $artist_id;
            ?>
" />
		
		<?php 
        } else {
            ?>
		
			<div id="message" class="error fade"><p><?php 
            _e("Sorry, but we had trouble loading that artist for editing.", "gigpress");
            ?>
</p></div>	
			
			<h3><?php 
            _e("Add an artist", "gigpress");
            ?>
</h3>
		
		<?php 
        }
    } else {
        $artist_name = '';
        $submit = '<span class="submit"><input type="submit" name="Submit" class="button-primary" value="' . __("Add artist", "gigpress") . '" /></span>';
        ?>

		<h3><?php 
        _e("Add an artist", "gigpress");
        ?>
</h3>
		
		<form method="post" action="<?php 
        echo get_bloginfo('wpurl') . "/wp-admin/admin.php?page=gigpress-artists" . $url_args;
        ?>
">
		<input type="hidden" name="gpaction" value="add" />	
	
	<?php 
    }
    wp_nonce_field('gigpress-action');
    ?>
		
		<table class="form-table gp-table">
			<tr>
				<th scope="row"><label for="artist_name"><?php 
    _e("Artist name", "gigpress");
    ?>
:</label></th>
				<td>
					<input name="artist_name" id="artist_name" type="text" size="48" value="<?php 
    echo $artist_name;
    ?>
" /> &nbsp; <?php 
    echo $submit;
    ?>
				</td>
			</tr>
		
		</table>
		
		</form>

	<h3><?php 
    _e("All artists", "gigpress");
    ?>
</h3>
	
	<div class="tablenav">
		<div class="alignleft"><p><?php 
    _e("Note that you cannot delete an artist while they have shows in the database.", "gigpress");
    ?>
</p></div>
	<?php 
    $artists = fetch_gigpress_artists();
    /*		Removed pagination to allow for single-page AJAX reordering. Complaints might being it back?
    		if($artists) {
    			$pagination_args['page'] = 'gigpress-artists';
    			$pagination = gigpress_admin_pagination(count($artists), 20, $pagination_args);
    			if($pagination) {
    				$artists = array_slice($artists, $pagination['offset'], $pagination['records_per_page']);
    				echo $pagination['output'];
    			}
    		}
    */
    ?>
	</div>
	
	<table class="widefat">
		<thead>
			<tr>
				<th scope="col" class="gp-tiny">&nbsp;</th>
				<th scope="col" class="gp-tiny">ID</th>
				<th scope="col"><?php 
    _e("Artist name", "gigpress");
    ?>
</th>
				<th scope="col" class="gp-centre"><?php 
    _e("Number of shows", "gigpress");
    ?>
</th>
				<th class="gp-centre" scope="col"><?php 
    _e("Actions", "gigpress");
    ?>
</th>
			</tr>
		</thead>
		<tbody class="gigpress-artist-sort">
	<?php 
    if ($artists) {
        foreach ($artists as $artist) {
            if ($n = $wpdb->get_var("SELECT count(*) FROM " . GIGPRESS_SHOWS . " WHERE show_artist_id = " . $artist->artist_id . " AND show_status != 'deleted'")) {
                $count = '<a href="' . get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-shows&amp;artist_id=' . $artist->artist_id . '">' . $n . '</a>';
            } else {
                $count = 0;
            }
            ++$i;
            $style = $i % 2 ? '' : ' class="alternate"';
            // Print out our rows.
            ?>
				<tr<?php 
            echo $style;
            ?>
 id="artist_<?php 
            echo $artist->artist_id;
            ?>
">
					<td class="gp-tiny"><img src="<?php 
            echo WP_PLUGIN_URL;
            ?>
/gigpress/images/sort.png" alt="" class="gp-sort-handle" /></td>
					<td class="gp-tiny"><?php 
            echo $artist->artist_id;
            ?>
</td>
					<td><?php 
            echo wptexturize($artist->artist_name);
            ?>
</td>
					<td class="gp-centre"><?php 
            echo $count;
            ?>
</td>
					<td class="gp-centre">
						<a href="<?php 
            echo get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-artists&amp;gpaction=edit&amp;artist_id=' . $artist->artist_id . $url_args;
            ?>
" class="edit"><?php 
            _e("Edit", "gigpress");
            ?>
</a>
						<?php 
            if (!$count) {
                ?>
 | <a href="<?php 
                echo wp_nonce_url(get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-artists&amp;gpaction=delete&amp;artist_id=' . $artist->artist_id . $url_args, 'gigpress-action');
                ?>
" class="delete"><?php 
                _e("Delete", "gigpress");
                ?>
</a><?php 
            }
            ?>
					</td>
				</tr>
				<?php 
        }
    } else {
        // We don't have any artists, so let's say so
        ?>
			<tr><td colspan="5"><strong><?php 
        _e("No artists in the database", "gigpress");
        ?>
</strong></td></tr>
	<?php 
    }
    ?>
		</tbody>
		<tfoot>
			<tr>
				<th scope="col" class="gp-tiny">&nbsp;</th>
				<th scope="col" class="gp-tiny">ID</th>
				<th scope="col"><?php 
    _e("Artist name", "gigpress");
    ?>
</th>
				<th scope="col" class="gp-centre"><?php 
    _e("Number of shows", "gigpress");
    ?>
</th>
				<th class="gp-centre" scope="col"><?php 
    _e("Actions", "gigpress");
    ?>
</th>
			</tr>
		</tfoot>
	</table>

<?php 
    if ($pagination) {
        ?>
	<div class="tablenav">
	<?php 
        // echo $pagination['output'];
        ?>
	</div>
<?php 
    }
    ?>
	
	<div id="artist-sort-update"></div>	
	
	</div>
<?php 
}
コード例 #4
0
function gigpress_import_export()
{
    global $wpdb, $gpo;
    ?>

	<div class="wrap gigpress gp-options">

	<?php 
    screen_icon('gigpress');
    ?>
			
	<h2><?php 
    _e("Import/Export", "gigpress");
    ?>
</h2>
	
	<div class="gp-import-panel">
	
		<h3>Import</h3>
		
		<p><?php 
    _e("Upload a CSV (comma-separated values) file to import into your GigPress database.", "gigpress");
    ?>
 <a href="http://gigpress.com/docs/#import"><strong><?php 
    _e("Please review the formatting specifications to save yourself headaches!", "gigpress");
    ?>
</strong></a></p>
		
		<div class="form-wrap">
			<form action="" enctype="multipart/form-data" method="POST">
				<div>
					<?php 
    wp_nonce_field('gigpress-action');
    ?>
					<input type="hidden" name="gpaction" value="import" />
					<input type="file" name="gp_import" />
					<p>
						<label><input type="checkbox" name="include_related" value="y" /> <?php 
    _e("Include Related Post associations?", "gigpress");
    ?>
</label>
					</p>
					<input type="submit" class="button" value="<?php 
    _e("Upload CSV", "gigpress");
    ?>
" />
				</div>
			</form>
		</div>
		
	
		<?php 
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "import") {
        require_once 'handlers.php';
        gigpress_import();
    }
    ?>

	</div>
	
	<div class="gp-export-panel">
		
		<h3>Export</h3>
		
		<p><?php 
    _e("Download your complete show database as a CSV (comma-separated values) file, compatible with programs such as Microsoft Excel. This file is also suitable to import into another GigPress installation.", "gigpress");
    ?>
</p>
		
		<form action="admin-post.php" method="post">
			<div>
				<?php 
    wp_nonce_field('gigpress-action');
    ?>
				<input type="hidden" name="action" value="gigpress_export" />
			</div>
			<div style="margin-bottom:5px;">
				<select name="artist_id">
					<option value="-1"><?php 
    _e("Export all artists", "gigpress");
    ?>
</option>
				<?php 
    $artistdata = fetch_gigpress_artists();
    if ($artistdata) {
        foreach ($artistdata as $artist) {
            echo '<option value="' . $artist->artist_id . '">' . gigpress_db_out($artist->artist_name) . '</option>';
        }
    } else {
        echo '<option value="-1">' . __("No artists in the database", "gigpress") . '</option>';
    }
    ?>
				</select>
			</div>
			<div style="margin-bottom:5px;">	
				<select name="tour_id">
					<option value="-1"><?php 
    _e("Export all tours", "gigpress");
    ?>
</option>
				<?php 
    $tourdata = fetch_gigpress_tours();
    if ($tourdata) {
        foreach ($tourdata as $tour) {
            echo '<option value="' . $tour->tour_id . '">' . gigpress_db_out($tour->tour_name) . '</option>';
        }
    } else {
        echo '<option value="-1">' . __("No tours in the database", "gigpress") . '</option>';
    }
    ?>
				</select>
			</div>
			<div style="margin-bottom:5px;">
				<select name="scope">
					<option value="-1"><?php 
    _e("Export all dates", "gigpress");
    ?>
</option>
					<option value="upcoming"><?php 
    _e("Export upcoming dates", "gigpress");
    ?>
</option>
					<option value="past"><?php 
    _e("Export past dates", "gigpress");
    ?>
</option>
				</select>
			</div>
			<div>							
				<input type="submit" value="<?php 
    _e("Download CSV", "gigpress");
    ?>
" class="button-secondary" />
			</div>
		</form>
	
	</div>

	</div>
<?php 
}
コード例 #5
0
ファイル: shows.php プロジェクト: Ashleyotero/oldest-old
function gigpress_admin_shows()
{
    if (isset($_REQUEST['gpaction']) && $_REQUEST['gpaction'] == "delete") {
        require_once 'handlers.php';
        gigpress_delete_show();
    }
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "undo") {
        require_once 'handlers.php';
        gigpress_undo('show');
    }
    if (isset($_POST['gpaction']) && $_POST['gpaction'] == "update") {
        require_once 'handlers.php';
        gigpress_update_show();
    }
    if (isset($_GET['gpaction']) && $_GET['gpaction'] == "trash") {
        require_once 'handlers.php';
        gigpress_empty_trash();
    }
    global $wpdb, $gpo;
    // Checks for filtering and pagination
    $url_args = '';
    $further_where = '';
    $pagination_args = array();
    switch ($_GET['scope']) {
        case 'upcoming':
            $condition = ">= '" . GIGPRESS_NOW . "'";
            $url_args .= '&amp;scope=upcoming';
            $pagination_args['scope'] = 'upcoming';
            break;
        case 'past':
            $condition = "< '" . GIGPRESS_NOW . "'";
            $url_args .= '&amp;scope=past';
            $pagination_args['scope'] = 'past';
            break;
        default:
            $condition = 'IS NOT NULL';
    }
    global $current_user;
    get_currentuserinfo();
    switch ($_GET['sort']) {
        case 'asc':
            $sort = 'ASC';
            update_usermeta($current_user->ID, 'gigpress_sort', $sort);
            break;
        case 'desc':
            $sort = 'DESC';
            update_usermeta($current_user->ID, 'gigpress_sort', $sort);
            break;
    }
    if (!isset($_GET['sort'])) {
        if (!($sort = get_usermeta($current_user->ID, 'gigpress_sort'))) {
            $sort = 'DESC';
            update_usermeta($current_user->ID, 'gigpress_sort', $sort);
        }
    }
    if (isset($_GET['gp-page'])) {
        $url_args .= '&amp;gp-page=' . $_GET['gp-page'];
    }
    if (isset($_GET['artist_id']) && $_GET['artist_id'] != '-1') {
        $further_where .= ' AND s.show_artist_id = ' . $wpdb->prepare('%d', $_GET['artist_id']) . ' ';
        $pagination_args['artist_id'] = $_GET['artist_id'];
        $url_args .= '&amp;artist_id=' . $_GET['artist_id'];
    }
    if (isset($_GET['tour_id']) && $_GET['tour_id'] != '-1') {
        $further_where .= ' AND s.show_tour_id = ' . $wpdb->prepare('%d', $_GET['tour_id']) . ' ';
        $pagination_args['tour_id'] = $_GET['tour_id'];
        $url_args .= '&amp;tour_id=' . $_GET['tour_id'];
    }
    if (isset($_GET['venue_id']) && $_GET['venue_id'] != '-1') {
        $further_where .= ' AND s.show_venue_id = ' . $wpdb->prepare('%d', $_GET['venue_id']) . ' ';
        $pagination_args['venue_id'] = $_GET['venue_id'];
        $url_args .= '&amp;venue_id=' . $_GET['venue_id'];
    }
    // Build pagination
    $show_count = $wpdb->get_var("SELECT COUNT(*) FROM " . GIGPRESS_ARTISTS . " AS a, " . GIGPRESS_VENUES . " as v, " . GIGPRESS_SHOWS . " AS s LEFT JOIN  " . GIGPRESS_TOURS . " AS t ON s.show_tour_id = t.tour_id WHERE show_expire " . $condition . " AND show_status != 'deleted' AND s.show_artist_id = a.artist_id AND s.show_venue_id = v.venue_id " . $further_where . "ORDER BY show_date " . $sort . ",show_time " . $sort);
    if ($show_count) {
        $pagination_args['page'] = 'gigpress-shows';
        $pagination = gigpress_admin_pagination($show_count, 10, $pagination_args);
    }
    $limit = isset($_GET['gp-page']) ? $pagination['offset'] . ',' . $pagination['records_per_page'] : 10;
    // Build the query
    $shows = $wpdb->get_results("\n\t\tSELECT * FROM " . GIGPRESS_ARTISTS . " AS a, " . GIGPRESS_VENUES . " as v, " . GIGPRESS_SHOWS . " AS s LEFT JOIN  " . GIGPRESS_TOURS . " AS t ON s.show_tour_id = t.tour_id WHERE show_expire " . $condition . " AND show_status != 'deleted' AND s.show_artist_id = a.artist_id AND s.show_venue_id = v.venue_id " . $further_where . "ORDER BY show_date " . $sort . ",show_expire " . $sort . ",show_time " . $sort . " LIMIT " . $limit);
    ?>
		
	<div class="wrap gigpress">

		<?php 
    screen_icon('gigpress');
    ?>
		
		<h2><?php 
    _e("Shows", "gigpress");
    ?>
</h2>
		
		<ul class="subsubsub">
		<?php 
    $all = $wpdb->get_var("SELECT COUNT(show_id) FROM " . GIGPRESS_SHOWS . " WHERE show_status != 'deleted'");
    $upcoming = $wpdb->get_var("SELECT count(show_id) FROM " . GIGPRESS_SHOWS . " WHERE show_expire >= '" . GIGPRESS_NOW . "' AND show_status != 'deleted'");
    $past = $wpdb->get_var("SELECT count(show_id) FROM " . GIGPRESS_SHOWS . " WHERE show_expire < '" . GIGPRESS_NOW . "' AND show_status != 'deleted'");
    echo '<li><a href="' . get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-shows"';
    if (!isset($_GET['scope'])) {
        echo ' class="current"';
    }
    echo '>' . __("All", "gigpress") . '</a> <span class="count">(' . $all . ')</span> | </li>';
    echo '<li><a href="' . get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-shows&amp;scope=upcoming"';
    if (isset($_GET['scope']) && $_GET['scope'] == 'upcoming') {
        echo ' class="current"';
    }
    echo '>' . __("Upcoming", "gigpress") . '</a> <span class="count">(' . $upcoming . ')</span> | </li>';
    echo '<li><a href="' . get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-shows&amp;scope=past"';
    if (isset($_GET['scope']) && $_GET['scope'] == 'past') {
        echo ' class="current"';
    }
    echo '>' . __("Past", "gigpress") . '</a> <span class="count">(' . $past . ')</span></li>';
    ?>
		</ul>
		
		<div class="tablenav">
			<div class="alignleft">
				<form action="" method="get">
					<div>
						<input type="hidden" name="page" value="gigpress-shows" />
						<?php 
    if (isset($_GET['scope'])) {
        ?>
						<input type="hidden" name="scope" value="<?php 
        echo $_GET['scope'];
        ?>
" />
						<?php 
    }
    ?>
						<select name="artist_id">
							<option value="-1"><?php 
    _e("View all artists", "gigpress");
    ?>
</option>
						<?php 
    $artistdata = fetch_gigpress_artists();
    if ($artistdata) {
        foreach ($artistdata as $artist) {
            $selected = isset($_GET['artist_id']) && $_GET['artist_id'] == $artist->artist_id ? ' selected="selected"' : '';
            echo '<option value="' . $artist->artist_id . '"' . $selected . '>' . gigpress_db_out($artist->artist_name) . '</option>';
        }
    } else {
        echo '<option value="-1">' . __("No artists in the database", "gigpress") . '</option>';
    }
    ?>
						</select>
						
						<select name="tour_id">
							<option value="-1"><?php 
    _e("View all tours", "gigpress");
    ?>
</option>
						<?php 
    $tourdata = fetch_gigpress_tours();
    if ($tourdata) {
        foreach ($tourdata as $tour) {
            $selected = isset($_GET['tour_id']) && $_GET['tour_id'] == $tour->tour_id ? ' selected="selected"' : '';
            echo '<option value="' . $tour->tour_id . '"' . $selected . '>' . gigpress_db_out($tour->tour_name) . '</option>';
        }
    } else {
        echo '<option value="-1">' . __("No tours in the database", "gigpress") . '</option>';
    }
    ?>
						</select>

						<select name="venue_id">
							<option value="-1"><?php 
    _e("View all venues", "gigpress");
    ?>
</option>
						<?php 
    $venuedata = fetch_gigpress_venues();
    if ($venuedata) {
        foreach ($venuedata as $venue) {
            $selected = isset($_GET['venue_id']) && $_GET['venue_id'] == $venue->venue_id ? ' selected="selected"' : '';
            echo '<option value="' . $venue->venue_id . '"' . $selected . '>' . gigpress_db_out($venue->venue_name) . '</option>';
        }
    } else {
        echo '<option value="-1">' . __("No venues in the database", "gigpress") . '</option>';
    }
    ?>
						</select>
								
						<select name="sort">
							<option value="desc"<?php 
    if ($sort == 'DESC') {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Descending", "gigpress");
    ?>
</option>
							<option value="asc"<?php 
    if ($sort == 'ASC') {
        echo ' selected="selected"';
    }
    ?>
><?php 
    _e("Ascending", "gigpress");
    ?>
</option>
						</select>
						<input type="submit" value="Filter" class="button-secondary" />
					</div>
				</form>
			</div>
			<?php 
    if ($pagination) {
        echo $pagination['output'];
    }
    ?>
			<div class="clear"></div>
		</div>

		<form action="" method="post">
			<?php 
    wp_nonce_field('gigpress-action');
    ?>
			<input type="hidden" name="gpaction" value="delete" />

		<table class="widefat">
			<thead>
				<tr>
					<th scope="col" class="column-cb check-column"><input type="checkbox" /></th>
					<th scope="col"><?php 
    _e("Date", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Artist", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("City", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Venue", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Country", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Tour", "gigpress");
    ?>
</th>					
					<th class="gp-centre" scope="col"><?php 
    _e("Actions", "gigpress");
    ?>
</th>
				</tr>
			</thead>
			<tfoot>
				<tr>
					<th scope="col" class="column-cb check-column"><input type="checkbox" /></th>
					<th scope="col"><?php 
    _e("Date", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Artist", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("City", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Venue", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Country", "gigpress");
    ?>
</th>
					<th scope="col"><?php 
    _e("Tour", "gigpress");
    ?>
</th>					
					<th class="gp-centre" scope="col"><?php 
    _e("Actions", "gigpress");
    ?>
</th>
				</tr>
			</tfoot>			
			<tbody>
		<?php 
    // Do we have dates?
    if ($shows != FALSE) {
        foreach ($shows as $show) {
            $showdata = gigpress_prepare($show, 'admin');
            ?>
				<tr class="<?php 
            echo 'gigpress-' . $showdata['status'];
            ?>
">
					<th scope="row" class="check-column"><input type="checkbox" name="show_id[]" value="<?php 
            echo $show->show_id;
            ?>
" /></th>
					<td><span class="gigpress-date"><?php 
            echo $showdata['date'];
            if ($showdata['end_date']) {
                echo ' - ' . $showdata['end_date'];
            }
            ?>
</span>
					</td>
					<td><?php 
            echo $showdata['artist'];
            ?>
</td>
					<td><?php 
            echo $showdata['city'];
            ?>
</td>
					<td><?php 
            echo $showdata['venue'];
            if ($showdata['address']) {
                echo ' (' . $showdata['address'] . ')';
            }
            ?>
</td>
					<td><?php 
            echo $showdata['country'];
            ?>
</td>
					<td><?php 
            echo $showdata['tour'];
            ?>
</td>
					<td class="gp-centre">
						<a href="<?php 
            bloginfo('wpurl');
            ?>
/wp-admin/admin.php?page=gigpress/gigpress.php&amp;gpaction=edit&amp;show_id=<?php 
            echo $show->show_id;
            ?>
" class="edit" title="<?php 
            _e("Edit", "gigpress");
            ?>
"><?php 
            _e("Edit", "gigpress");
            ?>
</a>&nbsp;|&nbsp;<a href="<?php 
            bloginfo('wpurl');
            ?>
/wp-admin/admin.php?page=gigpress/gigpress.php&amp;gpaction=copy&amp;show_id=<?php 
            echo $show->show_id;
            ?>
" class="edit" title="<?php 
            _e("Copy", "gigpress");
            ?>
"><?php 
            _e("Copy", "gigpress");
            ?>
</a>
					</td>
				</tr>
				<tr class="<?php 
            echo 'alternate' . ' gigpress-' . $showdata['status'];
            ?>
">
					<td colspan="8"><small>
					<?php 
            if ($showdata['time']) {
                echo $showdata['time'] . '. ';
            }
            if ($showdata['price']) {
                echo __("Price", "gigpress") . ': ' . $showdata['price'] . '. ';
            }
            if ($showdata['admittance']) {
                echo $showdata['admittance'] . '. ';
            }
            if ($showdata['ticket_link']) {
                echo $showdata['ticket_link'] . '. ';
            }
            if ($showdata['ticket_phone']) {
                echo __('Box office', "gigpress") . ': ' . $showdata['ticket_phone'] . '. ';
            }
            echo $showdata['notes'] . ' ';
            echo $showdata['related_edit'];
            ?>
					</small></td>
				</tr>	
			<?php 
        }
        // end foreach
    } else {
        // No results from the query
        ?>
			<tr><td colspan="8"><?php 
        _e("Sorry, no shows to display based on your criteria.", "gigpress");
        ?>
</td></tr>
		<?php 
    }
    ?>
			</tbody>
		</table>
		<div class="tablenav">
			<div class="alignleft">
				<input type="submit" value="<?php 
    _e('Trash selected shows', 'gigpress');
    ?>
" class="button-secondary" /> &nbsp; 
				<?php 
    if ($tour_count = $wpdb->get_var("SELECT count(*) FROM " . GIGPRESS_TOURS . " WHERE tour_status = 'deleted'")) {
        $tours = $tour_count;
    } else {
        $tours = 0;
    }
    if ($show_count = $wpdb->get_var("SELECT count(*) FROM " . GIGPRESS_SHOWS . " WHERE show_status = 'deleted'")) {
        $shows = $show_count;
    } else {
        $shows = 0;
    }
    if ($tour_count || $show_count) {
        echo '<small>' . __("You have", "gigpress") . ' <strong>' . $shows . ' ' . __("shows", "gigpress") . '</strong> ' . __("and", "gigpress") . ' <strong>' . $tours . ' ' . __("tours", "gigpress") . '</strong> ' . __("in your trash", "gigpress") . '.';
        if ($shows != 0 || $tours != 0) {
            echo ' <a href="' . wp_nonce_url(get_bloginfo('wpurl') . '/wp-admin/admin.php?page=gigpress-shows&amp;gpaction=trash' . $url_args, 'gigpress-action') . '">' . __("Take out the trash now", "gigpress") . '</a>.';
        }
        echo '</small>';
    }
    ?>
				</div>
	
			<?php 
    if ($pagination) {
        echo $pagination['output'];
    }
    ?>

		</div>
		</form>
	</div>
<?php 
}