// UPLOAD_ERR_OK = 0
// UPLOAD_ERR_PARTIAL = 3
if (isset($_FILES['music']) && $_FILES['music']['error'] == 0) {
$gal_musica = tnb_get_artista_galeria($profileuser->ID, 'music');
$acceptedFormats = array('audio/mpeg', 'audio/x-mpeg', 'audio/mp3', 'audio/x-mp3', 'audio/mpeg3', 'audio/x-mpeg3', 'audio/mpg', 'audio/x-mpg', 'audio/x-mpegaudio');
if (in_array($_FILES['music']['type'], $acceptedFormats)) {
$post = array("post_title" => $_POST['music_title'], "post_content" => $_FILES['music']['name'], "post_excerpt" => $_FILES['music']['name'], "post_author" => $profileuser->ID);
unset($GLOBALS['post']);
$media_id = media_handle_upload('music', $gal_musica->ID, $post);
if ($media_id->errors) {
$msg['error'][] = implode(' ', $media_id->errors['upload_error']);
}
if (!$msg['error']) {
$meta = get_post_meta($media_id, '_wp_attached_file');
$sizes = get_media_file_sizes($upload_dir . "/" . $meta[0]);
$menu_order = count(tnb_get_artista_musicas($profileuser->ID));
$update = array('ID' => $media_id, 'menu_order' => $menu_order);
wp_update_post($update);
//$albuns = get_user_meta($current_user->ID, 'albuns');
update_post_meta($media_id, '_filesize', $sizes['filesize']);
update_post_meta($media_id, '_playtime', $sizes['playtime']);
update_post_meta($media_id, '_album', $_POST['music_album']);
update_post_meta($media_id, '_download', $_POST['music_download'] ? 1 : 0);
if ($_POST['music_principal'] || $menu_order == 0) {
tnb_set_artista_musica_principal($profileuser->ID, $media_id);
}
tnb_cache_unset("ARTISTAS_MUSICAS", $profileuser->ID);
}
} else {
$msg['error'][] = __('Tipo de arquivo não permitido', 'tnb');
}
$obj->count = 0;
$obj->day = (string) $day->format($format);
$result[(string) $day->format($format)] = $obj;
}
$obj = new stdClass();
$obj->object_id = '';
$obj->count = 0;
$obj->day = $fdate;
$result[$fdate] = $obj;
return $result;
}
wp_enqueue_script('jquery-flot', TNB_URL . '/js/flot/jquery.flot.js', array('jquery'));
get_header();
$plays = $downloads = array();
$totais = array();
$_musicas = tnb_get_artista_musicas($profileuser->ID);
$musicas = array();
foreach ($_musicas as $mus) {
$musicas[] = $mus->ID;
}
$music_ids = implode(',', $musicas);
// define a data final: $_GET[fdate] ou CURRENT_DATE()
$where = '';
if (isset($_GET['fdate']) && preg_match('/[0-9]{2}\\/[0-9]{2}\\/[0-9]{4}/', $_GET['fdate'])) {
$__fdate = $fdate = preg_replace("/([0-9]{2})\\/([0-9]{2})\\/([0-9]{4})/", "\$3-\$2-\$1", $_GET['fdate']);
$where .= " AND day <= '{$fdate}'";
} else {
$__fdate = date('Y-m-d');
$where .= " AND day <= CURRENT_DATE()";
}
// define a data inicial: $_GET[sdate] ou CURRENT_DATE() - 30 dias
protected function update_form()
{
$profileuser = get_user_by('id', $this->user_id);
$formID = uniqid('form');
$musicas = tnb_get_artista_musicas($profileuser->ID);
?>
<h3><?php
_e('Músicas', 'tnb');
?>
</h3>
<label>
<?php
_e('título', 'tnb');
?>
<input type="text" name='property[title]' value='<?php
echo htmlentities(utf8_decode($this->property['title']));
?>
' />
</label>
<hr/>
<div id='<?php
echo $formID;
?>
_exibir'>
<?php
_e("quais músicas", "tnb");
?>
:
<label><input type='radio' name='property[exibir]' value='todas' <?php
if ($this->property['exibir'] == 'todas') {
echo 'checked="checked"';
}
?>
><?php
_e('todas', 'tnb');
?>
</label>
<label><input type='radio' name='property[exibir]' value='selecionadas' <?php
if ($this->property['exibir'] == 'selecionadas') {
echo 'checked="checked"';
}
?>
><?php
_e('somente as selecionadas', 'tnb');
?>
</label>
</div>
<hr/>
<div id='<?php
echo $formID;
?>
_musicas' <?php
if ($this->property['exibir'] == 'todas') {
echo 'class="hide";';
}
?>
>
<?php
_e('selecione as músicas que deseja exibir', 'tnb');
?>
:
<div class='clearfix'>
<?php
foreach ($musicas as $musica) {
?>
<input type="checkbox" id='<?php
echo $formID;
?>
_widget_musica_<?php
echo $musica->ID;
?>
_input' name="property[musicas][]" value='<?php
echo $musica->ID;
?>
' <?php
if (in_array($musica->ID, $this->property['musicas'])) {
echo 'checked';
}
?>
/>
<?php
echo $musica->post_title;
?>
<br/>
<?php
}
?>
</div>
</div>
<script type="text/javascript">
jQuery("#<?php
echo $formID;
?>
_exibir input").change(function (){
if(jQuery(this).val() == 'todas')
jQuery("#<?php
echo $formID;
?>
_musicas").slideUp();
else
jQuery("#<?php
echo $formID;
?>
_musicas").slideDown();
});
</script>
<?php
}
function tnb_get_artista_musica_principal($artista_id)
{
if (tnb_cache_exists('ARTISTAS_MUSICA_PRINCIPAL', $artista_id)) {
return tnb_cache_get('ARTISTAS_MUSICA_PRINCIPAL', $artista_id);
}
global $wpdb;
$result = $wpdb->get_row("SELECT {$wpdb->posts}.* FROM {$wpdb->posts}, {$wpdb->usermeta} WHERE {$wpdb->posts}.ID = {$wpdb->usermeta}.meta_value AND {$wpdb->usermeta}.meta_key = '_musica_principal' AND {$wpdb->usermeta}.user_id = '{$artista_id}'");
// echo "SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->usermeta WHERE $wpdb->posts.ID = $wpdb->usermeta.meta_value AND $wpdb->usermeta.meta_key = '_musica_principal' AND $wpdb->usermeta.user_id = '$artista_id'";
if (!$result) {
$musicas = tnb_get_artista_musicas($artista_id);
if (count($musicas)) {
tnb_set_artista_musica_principal($artista_id, $musicas[0]->ID);
}
}
tnb_cache_set('ARTISTAS_MUSICA_PRINCIPAL', $artista_id, $result);
return $result;
}
