<?php
if (Session::is_user()) {
$query = $_REQUEST['q'];
if ($query) {
$search = Search::tracks($query);
$tracks = $search["results"];
$jinglesearch = Search::jingles($query);
$jingles = $jinglesearch["results"];
// $advertsearch = Search::adverts($query);
// $advert = $advertsearch['results'];
$count = 1;
}
foreach ($jingles as $jingleid) {
$jingle = Jingles::get($jingleid);
echo "<div style=\"background-color: rgb(18,137,192);\" id=\"track-draggable-" . $count . "\" class=\"ui-draggable dps-aw-item\" data-dps-aw-style=\"118\" data-dps-audio-id=\"" . $jingle->get_id() . "\">\r\n\t\t<span class=\"text\">" . $jingle->get_title() . "</span>\r\n\t\t</div><br>";
}
// foreach ($adverts as $advertid){
// $advert = Advertss::get($advertid);
// echo "<div style=\"background-color: orange;\" id=\"track-draggable-".$count."\" class=\"ui-draggable dps-aw-item\" data-dps-aw-style=\"118\" data-dps-audio-id=\"".$advert->get_id()."\">
// <span class=\"text\">".$advert->get_title()."</span>
// </div><br>";
// }
foreach ($tracks as $track_id) {
$track = Tracks::get($track_id);
echo "<div style=\"background-color: rgb(18,137,192);\" id=\"track-draggable-" . $count . "\" class=\"ui-draggable dps-aw-item\" data-dps-aw-style=\"118\" data-dps-audio-id=\"" . $track->get_id() . "\">\r\n\t\t<span class=\"text\">" . $track->get_title() . "</span>\r\n\t\t</div><br>";
$count = $count + 1;
}
}
public static function get_by_md5($md5)
{
$type = DigiplayDB::select("type FROM audio WHERE md5 = '" . $md5 . "'");
if ($type) {
if ($type == 1) {
return Tracks::get_by_md5($md5);
} else {
if ($type == 2) {
return Jingles::get_by_md5($md5);
} else {
if ($type == 3) {
return Adverts::get_by_md5($md5);
} else {
if ($type == 4) {
return Prerecs::get_by_md5($md5);
}
}
}
}
}
}
$jingles = array();
foreach ($package->get_jingles() as $jingle) {
$jingles[] = array('id' => $jingle->get_id(), 'title' => $jingle->get_title());
}
$jsonrpc->output(array('package' => array('id' => $package->get_id(), 'name' => $package->get_name(), 'description' => $package->get_description()), 'jingles' => $jingles));
break;
case 'delete_from':
if (!isset($jsonrpc->params['package_id']) || !isset($jsonrpc->params['jingle_id'])) {
$jsonrpc->error('invalid jingle or package');
}
$package = JinglePackages::get_by_id($jsonrpc->params['package_id']);
$jingle = Jingles::get_by_id($jsonrpc->params['jingle_id']);
$result = $package->delete_jingle($jingle);
if ($result == true) {
$jsonrpc->output('ok');
} else {
$jsonrpc->output('error');
}
break;
case 'search':
if (!isset($jsonrpc->params['q'])) {
$jsonrpc->error('invalid search query');
}
$results = Search::jingles($jsonrpc->params['q']);
$jingles = array();
foreach ($results['results'] as $result) {
$jingles[] = array('id' => $result, 'label' => Jingles::get_by_id($result)->get_title());
}
$jsonrpc->output($jingles);
break;
}
