getPeriodCode();
$breadcrumb = "home > Period: " .$period->getPeriodCode()."";
foreach($_GET as $k=>$v){
if(preg_match('/[^a-zA-Z0-9 _\,\!\'\|\"]/', $varTxt)){
continue;
}
if(k == "imprint_txt"){
$varArr = explode("|",$v);
}else{
$varArr = explode(",",$v);
}
if(!count($varArr) or (!$vendor_id && in_array($type,array('release','artist','track','imprint'))))
continue;
$validIds = array();
switch($k){
case "release_id_txt":
$bc_url .= "&release_id_txt=$release_id_txt";
$sql = "SELECT r.upc, r.release_name FROM releases r
INNER JOIN artist_info a on a.artist_id = r.artist_id
WHERE a.vendor_id = $vendor_id
AND r.upc IN ($release_id_txt) ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['release_name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Release: $tmp";
break;
case "imprint_txt":
$bc_url .= "&imprint_txt=".urlencode($v);
$breadcrumb .="> Imprint: ".htmlspecialchars($v)."";
break;
case "artist_id_txt":
$bc_url .= "&artist_id_txt=$artist_id_txt";
$sql = "SELECT a.artist_id, a.name
FROM artist_info a
WHERE a.vendor_id = $vendor_id
AND a.artist_id IN ($artist_id_txt) ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Artist: $tmp";
break;
case "track_id_txt":
$bc_url .= "&track_id_txt=$track_id_txt";
$bc_track_ids = explode(",", $track_id_txt);
$tmp = '';
foreach($bc_track_ids as $bc_track_unique_id){
list($bc_upc, $bc_cd, $bc_track_no) = explode("_",$bc_track_unique_id);
$sql = "SELECT t.track_name, r.release_name
FROM track t
INNER JOIN releases r ON r.upc = t.upc
INNER JOIN artist_info a on a.artist_id = r.artist_id
WHERE a.vendor_id = $vendor_id
AND r.upc = ".QueryFormatString($bc_upc);
if($bc_cd!= 0)
$sql .= " AND t.cd = ".QueryFormatNumber($bc_cd)." AND t.track_id = " . QueryFormatNumber($bc_track_no);
$sql .= " LIMIT 1 ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$row = $rs->fetch_array(MYSQLI_ASSOC);
if($bc_cd == 0)
$tmp .= ','.$row['release_name'];
else
$tmp .= ','.$row['track_name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Track: $tmp";
break;
case "dms_master_id_txt":
$bc_url .= "&dms_master_id_txt=$dms_master_id_txt";
$sql = "SELECT cmm.customer_name
FROM customer_master_master cmm
WHERE cmm.customer_master_master_id IN ($dms_master_id_txt) ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['customer_name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Source: $tmp";
break;
case "collection_society_id_txt":
$bc_url .= "&collection_society_id_txt=$collection_society_id_txt";
$sql = "SELECT collection_society_id, collection_society FROM collection_society WHERE collection_society_id IN ($collection_society_id_txt) ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['collection_society'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Source: $tmp";
break;
case "invoice_detail_id_txt":
$bc_url .= "&invoice_detail_id_txt=$invoice_detail_id_txt";
$sql = "SELECT client_name FROM vendor_sync_revenue WHERE invoice_detail_id IN ($invoice_detail_id_txt) ";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['client_name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Source: $tmp";
break;
case "country_id_txt":
$bc_url .= "&country_id_txt=$country_id_txt";
$sql = "select id, name from country WHERE id IN ($country_id_txt)";
if(!$rs = $mysqli->query($sql))
showierror($sql);
$tmp = '';
while($row = $rs->fetch_array(MYSQLI_ASSOC)){
$tmp .= ','.$row['name'];
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Country: $tmp";
break;
case "activity_period_txt":
$bc_url .= "&activity_period_txt=$activity_period_txt";
$tmp = '';
foreach ($varArr as $var){
$tmp .= ",".ConvertActPeriodToDisplayDate($var);
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Activity Period: $tmp";
break;
case "trans_type_txt":
$bc_url .= "&trans_type_txt=$trans_type_txt";
$tmp = '';
foreach ($varArr as $var){
$tmp .= ",".get_channel_name($var);
}
$tmp = trim($tmp,",");
$breadcrumb .= " > Channel: $tmp";
break;
}
}
echo $breadcrumb;
?>