//連結檔案 -------------------------------------------------------------------------------
require_once "../php_fun/func.inc";
//程式開始--------------------------------------------------------------------------------
//顯示Filter
$caseFilterStr = showAllTagData();
//顯示資料
$caseDataStr = showAllCaseData();
//顯示資料 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
function showAllCaseData() {
$sql = 'SELECT * FROM `showcase` ORDER BY `moDate` DESC';
$postStr;
$rc = GetRows($sql);
$total = GetNum($sql);
$sql = DList($rc,'rc');
if($total) {
for ($i = 0; $i < $total; $i++) {
eval("\$string = $sql;");
$postStr .= '
';
$postStr .= showPanel($id).'
'.$e_title.'
'.$e_description.'
';
}
}
return $postStr;
}
//顯示Tag Class
function tagClass($caseID) {
$sql = 'SELECT * FROM `related` WHERE `showcaseID`='.$caseID;
$tagStr;
$rc = GetRows($sql);
$total = GetNum($sql);
$sql = DList($rc,'rc');
if($total) {
for ($i = 0; $i < $total; $i++) {
eval("\$string = $sql;");
$tagStr .= ' '.showTag($tagID);
}
}
return $tagStr;
}
//顯示Tag
function showTag($tID) {
$sql = 'SELECT * FROM `tag` WHERE `id`='.$tID;
$REQ=GetObj(GetRows($sql));
return str_replace(' ','-',strtolower($REQ->e_name));
}
//顯示Panel
function showPanel($caseID) {
$sql = 'SELECT * FROM `attach` WHERE `showcaseID`='.$caseID.' ORDER BY `type` DESC';
$panelStr;
$rc = GetRows($sql);
$total = GetNum($sql);
$sql = DList($rc,'rc');
if($total) {
for ($i = 0; $i < $total; $i++) {
eval("\$string = $sql;");
if($type == 0) {
$panelStr .= '