session_start();
include_once("beheer/config/mysql.php");
include_once("beheer/config/functions.php");
include_once("tools/functions.php");
include_once("tools/settings.php");
include_once("tools/header.php");
?>
include_once("tools/metadata.php"); ?>
////////////////////////////////////////////////// DETAIL
$this_db = "work_items";
$this_db_groups = "work_groups";
$this_p = "work";
ob_start();
$groups_data = getdata("work_groups","id","=",1);
$groups_list = explode("]---[",$groups_data['content']);
if($groups_list[0]){
echo "
";
$active = "";
if($_REQUEST['p'] != "tag"){
$active = " class='active'";
}
echo "
ALLES";
foreach($groups_list as $groups_id){
$group_data = getdata("work_groups","id","=",$groups_id);
if($group_data['id'] != "8" && $group_data['visible'] == "y" && $group_data['order']){
$tag_list = explode("]---[",$group_data['order']);
if($tag_list[0]){
$active = "";
if($_REQUEST['p'] == "tag" && $_REQUEST['id'] == $group_data['id']){
$active = " class='active'";
}
echo "
".clean_txt($group_data['name'])."";
}
}
}
echo "
";
}
$show_dropdown = ob_get_clean();
if(($_REQUEST['p'] == "work" && $_REQUEST['id']) || ($_REQUEST['p'] == "tag") && $_REQUEST['sid'] && $_REQUEST['sname']){
$item_data = getdata($this_db,"id","=",$_REQUEST['id']);
if($_REQUEST['p'] == "tag"){
$item_data = getdata($this_db,"id","=",$_REQUEST['sid']);
}
$images = get_files("img",$dir_thumb,$this_db,$item_data['id'],"");
$first_image = array_shift($images);
array_push($images,$first_image);
if($images[0]){
echo "
";
foreach($images as $image){
echo "
";
$file_data = getdata("files","id","=",$image);
$fullscreen_fit = "";
$img_dir = $dir_thumb;
if($file_data['fullscreen'] != "y"){
$fullscreen_fit = " work_preview_bg_fit";
$img_dir = $dir;
}
$bg_color = "";
if($file_data['text']){
$bg_color = " background-color:#".str_replace("#","",$file_data['text']);
}
echo "
";
echo "
".clean_txt($item_data['name'])."
";
echo "
";
echo "
";
}
echo "
";
echo "
";
echo "
";
echo "
";
if(file_exists("img/upload/files/".get_file_url($item_data['file']))){
echo "
";
}
echo "
";
echo "
";
echo "";
echo "
";
}
$group_data = getdata($this_db_groups,"id","=","2");
$pager_items = explode("]---[",$group_data['order']);
$next = array_search($_REQUEST['id'],$pager_items) + 1;
$prev = array_search($_REQUEST['id'],$pager_items) - 1;
if(array_search($_REQUEST['id'],$pager_items) == (count($pager_items) - 1)){
$next = 0;
}
if(array_search($_REQUEST['id'],$pager_items) == "0"){
$prev = count($pager_items) - 1;
}
if($_REQUEST['p'] != "tag"){
$prev = $pager_items[$prev];
$next = $pager_items[$next];
} else {
$prev = $_REQUEST['p']."/".$_REQUEST['id']."/".$_REQUEST['name']."/".$pager_items[$prev];
$next = $_REQUEST['p']."/".$_REQUEST['id']."/".$_REQUEST['name']."/".$pager_items[$next];
}
echo "
";
echo "
";
echo "
";
echo $show_dropdown;
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
} else { ////////////////////////////////////////////////// OVERZICHT
//if($result = mysqli_query($_SESSION['sql'],"SELECT * FROM `".$this_db."` WHERE `visible` = 'y' AND `date`<='".date("Ymd")."' ORDER BY `date` DESC LIMIT 3")){
//while($item_data = mysqli_fetch_array($result)){
if($_REQUEST['p'] == "tag" && $_REQUEST['id']){
$group_data = getdata($this_db_groups,"id","=",$_REQUEST['id']);
$group_items = explode("]---[",$group_data['order']);
} else {
$group_items = array();
if($result = mysqli_query($_SESSION['sql'],"SELECT * FROM `".$this_db."` WHERE `visible` = 'y' AND `groups`!='' ORDER BY RAND()")){
while($item_data = mysqli_fetch_array($result)){
array_push($group_items,$item_data['id']);
}
}
}
if(isset($group_items[0])){
$key = 0;
if(is_numeric($_REQUEST['p']) && in_array($_REQUEST['p'],$group_items)){
$key = array_search($_REQUEST['p'],$group_items);
} else if($_REQUEST['p'] == "tag" && is_numeric($_REQUEST['sid']) && !$_REQUEST['sname'] && in_array($_REQUEST['sid'],$group_items)){
$key = array_search($_REQUEST['sid'],$group_items);
}
echo "
";
foreach($group_items as $item){
$item_data = getdata($this_db,"id","=",$item);
if($_REQUEST['p'] != "tag"){
$item_link = $strt.$this_p."/".$item_data['id']."/".pretty_url($item_data['name']);
} else {
$item_link = $strt.$_REQUEST['p']."/".$_REQUEST['id']."/".$_REQUEST['name']."/".$item_data['id']."/".pretty_url($item_data['name']);
}
//onclick='location.href=\"".$item_link."\";'
$image = get_first_file($dir_thumb,$this_db,$item_data['id']);
if($image != ""){
echo "
";
echo "
";
echo "
";
echo "
".clean_txt($item_data['name'])."
";
echo "
";
$images = get_files("img",$dir_thumb,$this_db,$item_data['id'],"");
if(count($images) > 1){
echo "
";
}
if(file_exists("img/upload/files/".get_file_url($item_data['file']))){
echo "
";
}
echo "
";
echo "
";
}
}
echo "
";
echo "
";
echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo $show_dropdown;
echo "";
echo "
";
$books_data = getdata("work_groups","id","=",8);
echo "
";
echo "";
echo "";
echo "";
}
}
echo "
";
echo "";
echo "
";
?>