File Source for CMS_MEDIA

<?php
/**
* Class file CMS_MEDIA_PAGE.phpclass
*
* @project Open CSP-Management
* @package cms
* @category page
*
* @author Peter Krebs <p.krebs@wpus.at>
* @copyright (c) 2002-2005 by Peter Krebs and WURM und Partner Unternehmensservice GesmbH.
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
***/
require_once $GLOBALS['DEFAULTCONFPATH']."cms.conf.phpinc";
require_once $GLOBALS['DEFAULTCONFPATH']."media.conf.phpinc";
require_once $GLOBALS['CMS']['PHPINCPATH']."page/CMS_PAGE_V2.phpclass";
/**
* class to handel PAGES with list of medias and show medias
*
* @project Open CSP-Management
* @package cms
* @category page
*
* @author Peter Krebs <p.krebs@wpus.at>
* @copyright (c) 2002-2005 by Peter Krebs and WURM und Partner Unternehmensservice GesmbH.
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-05-04-15
*
***/
class CMS_MEDIA_PAGE extends CMS_PAGE_V2 {
/**
* @staticvar string $myClassName name of the class
***/
var $myClassName = "CMS_MEDIA_PAGE";
/**
* @var string $medCatRoot
***/
var $medCatRoot=0;
/**
* @var int $myMediaCatId
* @since pk-05-09-09
***/
var $myMediaCatId=0;
/**
* @var MED_CATEGORY_NODE $myCatNode
* @since pk-05-09-09
***/
var $myMediaCatNode=NULL;
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// page definition methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* returns a array of variables used by the page object
*
* array[varName]=array(
* [TYPE] datatype
* [FLDCLASS] name of DBMS_FIELD* class
* [CLASSVALS] array of values of [FLDCLASS]
*
*
*
* @returns array
*
* @since pk-04-08-10
*
***/
function getObjVarDef() {
$retArr=parent::getObjVarDef();
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_HEADLINE.phpclass";
$retArr['MYFORMHAEDLINE']=array(
"TYPE" => "layout",
"FLDCLASS" => "DBMS_FIELD_HEADLINE",
"CLASSVALS" =>array(
"label" => "<b>MEDIEN</b>"
)
);
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_TREESELECT.phpclass";
$retArr['MEDIACATEGORY']= array(
"TYPE" => "int",
"FLDCLASS" => "DBMS_FIELD_TREESELECT",
"CLASSVALS" =>array(
"label" => "Wurzelkategorie",
"allowNull" => TRUE,
"isSearchable" => TRUE,
"showInList" => TRUE,
"foreignTbl" => "T_MED_CATEGORY",
"showField" => "MEC_NAME",
"keyField" => "MEC_ID",
"sortField" => "MEC_NAME",
"parentField" => "MEC_PARENT",
"allowNullSelect" => TRUE,
"reloadFormOnChange"=> FALSE,
"showFullTree" => TRUE,
"rootCheckOff" => TRUE
)
);
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_CHECKBOX.phpclass";
$retArr['MED_SHOWALL']=array(
"TYPE" => "tinyint",
"FLDCLASS" => "DBMS_FIELD_CHECKBOX",
"CLASSVALS" => array(
"label" => "Alle Medien",
"checkText" => "ja alle in der Kategorie"
)
);
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_FOREIGNKEY.phpclass";
$retArr['LSTFORM']= array(
"TYPE" => "int",
"FLDCLASS" => "DBMS_FIELD_FOREIGNKEY",
"CLASSVALS" =>array(
"label" => "Listen Formular",
"allowNull" => TRUE,
"isSearchable" => TRUE,
"showInList" => TRUE,
"foreignTbl" => "T_DBMS_FORM",
"showField" => "FRM_NAME",
"keyField" => "FRM_ID",
"sortField" => "FRM_NAME",
"whereAnd" => "(FRM_TABLES LIKE \"%T_MEDPAG_MEDIA%\" OR FRM_TABLES LIKE \"%T_MED_FILES%\")",
"allowNullSelect" => TRUE,
"reloadFormOnChange"=> FALSE
)
);
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_GROUPSELECT.phpclass";
$retArr['GRP_FILEADD'] = array(
"TYPE" => "int",
"FLDCLASS" => "DBMS_FIELD_GROUPSELECT",
"CLASSVALS" => array(
"label" => "Upload Gruppe",
"allowNull" => TRUE,
"showInList" => FALSE,
"defaultValue" => $GLOBALS['GROUPS']['CMSADMIN']
)
);
// <pk-05-11-22>
require_once $GLOBALS['OCSP']['DBMSFLD_PATH']."DBMS_FIELD_GLOBALARRSELECTLIST.phpclass";
$retArr['MED_NEWSTATE'] = array(
"TYPE" => "tinyint",
"FLDCLASS" => "DBMS_FIELD_GLOBALARRSELECTLIST",
"CLASSVALS" => array(
"label" => "Default Upload State",
"allowNull" => TRUE,
"showInList" => FALSE,
"arrayName" => "MED|FILESTATE",
"valueIsKey" => FALSE,
"subKey" => "NAME",
"defaultValue" => $GLOBALS['MED']['ONLINESTATE']
)
);
// </pk-05-11-22>
$retArr['LSTORDERBY'] = array(
"TYPE" => "string",
"FLDCLASS" => "DBMS_FIELD",
"CLASSVALS" => array(
"label" => "Listensortierung ORDER BY",
"allowNull" => TRUE,
"showInList" => FALSE,
"defaultValue" => "MEF_UPLTIME DESC"
)
);
return $retArr;
}
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// media Methods
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/**
* @return int
*
* @since pk-05-09-09
*
***/
function getMedia_RootCatId() {
return intval($this->getDBField("MEDIACATEGORY"));
}
/**
* returns the current MEC_ID
* if ($chkGet) $_GET['MEC_ID'] is set this is used instead of the root category
*
* @param boolean $chkGet
* @param boolean $debug
*
* @return int
*
* @since pk-05-09-09
*
***/
function getMediaCatId($chkGet=FALSE,$debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::getMediaCatId(".($chkGet ? "USE GET" : "USE ROOT").")</b> (".get_class($this).")</p>";
if (!intval($this->myMediaCatId)) {
if (($chkGet) && (intval($_GET['MEC_ID']))) {
$this->myMediaCatId=intval($_GET['MEC_ID']);
} else {
$this->myMediaCatId=$this->getMedia_RootCatId();
}
}
return intval($this->myMediaCatId);
}
/**
* @param boolean $chkGet
* @param boolean $debug
*
* @return MED_CATEGORY_NODE
*
* @since pk-05-09-09
*
***/
function &getMediaCatObj($chkGet=FALSE,$debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::getMediaCatObj(".($chkGet ? "USE GET" : "USE ROOT").")</b> (".get_class($this).")</p>";
if (!is_object($this->myMediaCatNode) || ($this->myMediaCatNode->getId() != $this->getMediaCatId($chkGet,$debug))) {
// we either don't have a object or a wrong object -> greate a new one
require_once $GLOBALS['MED']['PHPINCPATH']."MED_CATEGORY_NODE.phpclass";
$this->myMediaCatNode=new MED_CATEGORY_NODE($this->getMediaCatId($chkGet,$debug),$this->get_gDBIDX(),$debug);
}
return $this->myMediaCatNode;
}
/**
* checks if a user can upload new files
*
* @param int $mediaCatId
* @param boolean $debug
*
* @return boolean
*
* @version pk-05-09-09
*
* @todo if $mediaCatId != MEDIACATEGORY (root) we have to check the media category
*
***/
function userCanUploadMedia($mediaCatId,$debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::userCanUploadMedia()</b> (".get_class($this).")</p>";
if (intval($mediaCatId)) {
if ($GLOBALS['USER']->isGroupMember($this->getDBField("GRP_FILEADD"))) {
return TRUE;
}
}
return FALSE;
}
// #########################################
/**
* returns the HTML Code for the media file list
*
* @param boolean $previewMode
* @param boolean $debug
*
* @return string
*
* @version pk-05-09-09
* @version pk-05-11-22
*
***/
function getMED_FileLst($previewMode=FALSE,$debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::getMED_FileLst()</b> (".get_class($this).")</p>";
$where ="mf.MEF_SHOWFROM <= NOW() AND mf.MEF_SHOWTILL >= NOW()";
if (!$this->MED_SHOWALL) {
$where.=" AND mf.MEF_STATE = ".$GLOBALS['MED']['ONLINESTATE'];
}
if ($this->MED_SHOWALL) {
$query ="SELECT * FROM T_MED_FILES mf WHERE MEC_ID=".intval($this->MEDIACATEGORY);
$query.=" AND ".$where;
if (empty($this->LSTORDERBY)) {
$query.=" ORDER BY MEF_UPLTIME DESC";
} else {
$query.=" ORDER BY ".$this->LSTORDERBY;
}
} else {
$query ="SELECT * FROM T_MEDPAG_MEDIA pm, T_MED_FILES mf WHERE mf.MEF_ID=pm.MEF_ID";
$query.=" AND ".$where;
if (empty($this->LSTORDERBY)) {
$query.=" ORDER BY MPM_SORTORDER";
} else {
$query.=" ORDER BY ".$this->LSTORDERBY;
}
}
$s_link=pcf_HTML_changeURI_GetValue($this->getMyLink(),"MEC_ID",$this->getMediaCatId());
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEF_ID","\$*MEF_ID\$");
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEFCMD","");
$a_lstLnks=array(
'EDITINFO' => array(
'A' =>'href="'.pcf_HTML_changeURI_GetValue($s_link,"MEFCMD","MEFEDIT").'" class="tdLink" ',
'TEXT' =>'<img src="'.$GLOBALS['PROJECT']['SYSIMGURL'].'form_buttons/lst_edit.gif" border="0" alt="bearbeiten" title="bearbeiten">'
),
'MEFDEL' => array(
'A' =>'href="'.pcf_HTML_changeURI_GetValue($s_link,"MEFCMD","MEFDEL").'" class="tdLink" ',
'TEXT' =>'<img src="'.$GLOBALS['PROJECT']['SYSIMGURL'].'form_buttons/lst_delete.gif" border="0" alt="lüschen" title="lüschen">'
)
);
$ret="";
if ($cursor=$GLOBALS['USRDB']->query($query)) {
require_once $GLOBALS['OCSP']['PHPFORMPATH']."forms.phpinc";
if ($frmObj=&DBMS_form_loadId($this->LSTFORM)) {
$ret.= $frmObj->getHTMLLstFromCursor($cursor,$nofRows,$a_lstLnks,NULL,$debug);
} else {
$ret.= "<table>";
$headerDone=FALSE;
while($row = $cursor->fetchArrayFld()) {
$ret.= "<tr>";
if (!$headerDone) {
foreach($row as $key => $val) {
echo "<th>$key</th>";
}
$ret.= "</tr><tr>";
$headerDone=TRUE;
}
foreach($row as $val) {
$ret.= "<td>".htmlspecialchars($val)."</td>";
}
}
$ret.= "</table>";
}
} else {
if ($debug) echo "<p>ERROR: ".$query."</p>";
}
return $ret;
}
/**
* returns the file Upload Formul
*
* @param boolean $mediaCatId
* @param boolean $debug
*
* @return string
*
* @since pk-05-09-09
*
* @var array $a_DataRow
* @var string $s_tmpl
*
***/
function getMED_UploadForm($debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::getUploadForm()</b> (".get_class($this).")</p>";
require_once $GLOBALS['OCSP']['PHPINCPATH']."common/pcf_templates.phpinc";
if ($this->userCanUploadMedia($this->getMediaCatId(FALSE,$debug),$debug)) {
// otherwise it makeas no sence to write the form
$s_tmpl=$this->getDBField("NEWTEMPLATE");
if (empty($s_tmpl)) {
// use a default template
$s_tmpl="
<form name=\"frmNewMedia\" action=\"\$*FRM_ACTION\$\" method=\"post\" ENCTYPE=\"multipart/form-data\" \$*UPLOADFORMTAG\$>
<table>
<tr style=\"background-color: #C0C0C0\">
<td class=\"fldName\" valign=\"middle\">Neue Datei:</td>
<td class=\"fldValue\" valign=\"middle\">
<input type=\"file\" name=\"NEWMEDIAFILE\" size=\"40\">
</td>
<td class=\"fldValue\">
<button title=\"Datei anlegen\" type=\"button\" onClick=\"document.forms['frmNewMedia'].submit()\">
<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-22x22/filenew.png\" alt=\"Neue Datei\">
</button>
</td>
</tr>
</table>
</form>\n";
}
$a_DataRow=$this->getDBVal();
if (!intval($mediaCatId)) $mediaCatId=$this->getMedia_RootCatId();
$a_DataRow['FRM_ACTION']=pcf_HTML_changeURI_GetValue($this->getMyLink(),"MEC_ID",$this->getMediaCatId());
return pcf_tmpl_parse($s_tmpl,$a_DataRow);
}
return "";
}
/**
* echos the content of the page
*
* @param int $chaShowMode
* @param boolean $debug
*
* @version pk-05-09-09
*
* @var string $s_fKey
* @var array $a_fKeyLst
* @var array $a_ulFData
*
***/
function content($chaShowMode=0,$debug=FALSE) {
if ($debug) echo "<p><b>CMS_MEDIA_PAGE::content(Mode: $chaShowMode)</b> (".get_class($this).")</p>";
$this->getMediaCatId(TRUE,$debug); // ($chkGet=FALSE,$debug=FALSE)
// just call this method as it sets $this->myMediaCatId
// and to ensure we use the get param
if (!intval($chaShowMode)) {
echo $this->getChapter(CHAPTER_SHOWMODE_ALLWAYS_TOP,$debug);
if (!intval($_GET['MEF_ID'])) {
if ((is_array($_FILES)) && (sizeof($_FILES)) && ($this->userCanUploadMedia($this->myMediaCatId,$debug))) {
if ($debug) echo "<p>FILE POSTED: </p><blockquote><pre>".print_r($_FILES,TRUE)."</pre></blockquote>";
$this->getMediaCatObj(FALSE,$debug); // ($chkGet=FALSE,$debug=FALSE) no checkgroup as we alread called getMediaCatId
// just call it to set $this->myMediaCatNode
foreach($_FILES as $s_key => $a_ulFData) {
if (intval($a_ulFData['size']) && (file_exists($a_ulFData['tmp_name']))) {
if ($o_mefObj=$this->myMediaCatNode->addUploadFile($a_ulFData,$debug)) {
// echo "<pre>".pcf_object_info($o_mefObj,3,FALSE)."<pre>";
if ($debug) echo "<pre>".print_r($o_mefObj->getDBVal(),TRUE)."</pre>";
$o_mefObj->dbSave("USRDB",$debug);
$frmObj=&$o_mefObj->dbGetForm(FRM_MODE_EDIT,$this->LSTFORM,$debug);
$a_aktRec=$o_mefObj->getDBVal();
$a_defaults=$frmObj->getDefaultValArr("",$debug);
// check if we have some form defaults
if ($debug) echo "Defaults:<pre>".print_r($a_defaults,TRUE)."</pre>";
if (!intval($a_aktRec['MEF_STATE'])) $a_aktRec['MEF_STATE']=$a_defaults['MEF_STATE'];
$s_link=pcf_HTML_changeURI_GetValue($this->getMyLink(),"MEC_ID",$this->getMediaCatId());
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEF_ID",$o_mefObj->getId());
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEFCMD","");
global ${"DBVAL_".$s_key};
${"DBVAL_".$s_key}=$frmObj->reloadCheck($a_aktRec,$debug);
if ($debug) echo "<pre>".print_r(${"DBVAL_".$s_key},TRUE)."</pre>";
echo $frmObj->getHTMLFormFromArray(${"DBVAL_".$s_key},FRM_MODE_EDIT,NULL,$s_link,"DBVAL_".$s_key,$debug);
}
}
}
} else { // we do not have posted files or the user is not allowed to post files
echo $this->getMED_FileLst(FALSE,$debug);
echo $this->getMED_UploadForm($debug);
}
} else {
$s_query="SELECT * FROM T_MED_FILES WHERE MEF_ID=".intval($_GET['MEF_ID']);
$a_mefRow=$GLOBALS['USRDB']->quickQuery($s_query);
if ($debug) echo "<pre>".print_r($a_mefRow,TRUE)."</pre>";
if (!class_exists($a_mefRow['MEF_OBJCLASS'])) {
if (file_exists($GLOBALS['MED']['PHPINCPATH'].$a_mefRow['MEF_OBJCLASS'].".phpclass")) {
require_once $GLOBALS['MED']['PHPINCPATH'].$a_mefRow['MEF_OBJCLASS'].".phpclass";
} else {
require_once $GLOBALS['MED']['PHPINCPATH']."MED_FILE.phpclass";
$a_mefRow['MEF_OBJCLASS']="MED_FILE";
}
}
eval('$o_mefObj=new '.$a_mefRow['MEF_OBJCLASS'].'('.$a_mefRow['MEF_ID'].');');
$s_link=pcf_HTML_changeURI_GetValue($this->getMyLink(),"MEC_ID",$this->getMediaCatId());
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEF_ID","");
$s_link=pcf_HTML_changeURI_GetValue($s_link,"MEFCMD","");
// echo "<pre>".print_r($_GET,TRUE)."</pre>";
switch($_GET['MEFCMD']) {
case "CANCLENEW":
$s_cmd="DELETE FROM T_MED_FILES WHERE MEF_ID=".intval($_GET['MEF_ID']);
echo "<p>NOT FINISHED CANCLENEW</p>";
echo $this->getMED_FileLst(FALSE,$debug);
echo $this->getMED_UploadForm($debug);
break;
case "MEFEDIT":
if (is_object($o_mefObj)) {
$a_aktRec=$o_mefObj->getDBVal();
$frmObj=$o_mefObj->dbGetForm(FRM_MODE_EDIT,"ID:".$this->LSTFORM,$debug);
global $DBVAL;
$DBVAL=$frmObj->reloadCheck($a_aktRec,$debug);
echo $frmObj->getHTMLFormFromArray($DBVAL,FRM_MODE_EDIT,NULL,$s_link,"DBVAL",$debug);
}
break;
case "MEFDEL":
if (is_object($o_mefObj)) {
$a_aktRec=$o_mefObj->getDBVal();
$frmObj=$o_mefObj->dbGetForm(FRM_MODE_DELETE,"ID:".$this->LSTFORM,$debug);
global $DBVAL;
$DBVAL=$frmObj->reloadCheck($a_aktRec,$debug);
echo $frmObj->getHTMLFormFromArray($DBVAL,FRM_MODE_DELETE,NULL,$s_link,"DBVAL",$debug);
}
break;
default:
echo $this->getMED_FileLst(FALSE,$debug);
echo $this->getMED_UploadForm($debug);
}
}
echo $this->getChapter(CHAPTER_SHOWMODE_ALLWAYS_BOTTOM,$debug);
} else {
echo $this->getChapter($chaShowMode,$debug);
}
}
}
?>

Source for file CMS_MEDIA_PAGE.phpclass