File Source for DBMS_FIELD_MEDIAFILE

<?php
/**
* Class file DBMS_FIELD_MEDIAFILE_SELID.phpclass
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs (pk) <p.krebs@lvus.at>
* @copyright (c) 2002-2003 by Peter Krebs and Landesverlag Unternehmensservice
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-05-10-10
*
***/
require_once dirname(__FILE__)."/DBMS_FIELD_FOREIGNKEY.phpclass";
require_once __OCSP_DEFAULTCONFPATH__."media.conf.phpinc";
/**
* handles foreign key fields
*
* @project Open CSP-Management
* @package dbms_field
* @category int
*
* @author Peter Krebs (pk) <p.krebs@lvus.at>
* @copyright (c) 2002-2003 by Peter Krebs and Landesverlag Unternehmensservice
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
* @since pk-05-10-10
*
***/
class DBMS_FIELD_MEDIAFILE_SELID extends DBMS_FIELD_FOREIGNKEY {
/**
* overwrite parent settings
**/
/**
* @staticvar string $className
***/
var $className = "MEDIAFILE_SELID";
/**
* @var string $foreignTbl name of the media files table
***/
var $foreignTbl = "T_MED_FILES";
/**
* @var string $showField columnname or sql statement to use to show the
***/
var $showField = "MEF_NAME";
/**
* @var string $showField columnname or sql statement to use to show the
***/
var $keyField = "MEF_ID";
/**
* @var string $showField columnname or sql statement to use to show the
***/
var $sortField = "MIM_ID,MEF_NAME";
/**
* source file of the class
*
* @var string $classSrcFile
* @since pk-05-01-20
***/
var $classSrcFile=__FILE__;
/**
* @var int $mecRootId id of the root category
***/
var $mecRootId=0;
/**
* @var int $cur_mecId id currently selected (not stored to the db)
* @since pk-06-08-09
***/
var $cur_mecId=0;
/**
* @var boolean $allowNewMedia user can add media files if he has the rights for the category
***/
var $allowNewMedia=TRUE;
/**
* @var boolean $allowChangeCat allow to change into subcategories of $this::mecRootId
* @since pk-06-08-09
***/
var $allowChangeCat=FALSE;
/**
* @var boolean $allowNewSubCat allow to add new categories under $this::mecRootId
* @since pk-06-08-09
***/
var $allowNewSubCat=FALSE;
/**
* @var boolean $allowEditMedia user can edit the media files if he has the rights for the category
***/
var $allowEditMedia=TRUE;
/**
* returns an array of field to bie shown in the edit form
* by using editTbl_echoForm
*
* the array is in the form:
*
* <code>
* [_sectionName_]
* [TITLE] -> string
* [_rowName_]
* [FLDLAB] (complete html code with <td></td>)
* [FLDVAL] (complete html code with <td></td>)
* </code>
*
* @param boolean $debug
*
* @returns array
*
* @since pk-06-04-26
* @version pk-06-04-29
*
***/
function editTbl_getFieldEditArr($debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_FOREIGNKEY::editTbl_getFieldEditArr","",0);
$a_ret=parent::editTbl_getFieldEditArr($debug);
if (empty($this->showField)) $this->showField="MEF_NAME";
if (empty($this->sortField)) $this->sortField="MIM_ID,MEF_NAME";
unset($a_ret['DBLOOKUP']['FLD_VALFLD']);
unset($a_ret['DBLOOKUP']['FLD_FRMRELOAD']);
$a_ret['DBLOOKUP']['FLD_FOREIGNTBL']['FLDVAL']="T_MED_FILES.MED_ID";
$a_ret['DBLOOKUP']['FLD_FOREIGNTBL']['FLDVAL'].="
<a onClick=\"
var tblName=getSelectedOptionByName(document.forms['frmEdit'],'foreignTbl');
if (tblName=='') {
alert('W�hlen Sie zuerst eine Tabelle aus');
} else {
var link='".$GLOBALS['PROJECT']['ADMINURL']."phpmyadmin/tbl_properties_structure.php?db=".$GLOBALS['USRDB']->getMyDBName()."';
link=link+'&table=T_MED_FILES';
openLinkWnd(link);
}
\" title=\"Tabelle in phpMyAdmin zeigen\">
<img src=\"".$GLOBALS['OCSP']['SYSIMGURL']."icons-16x16/b_browse.png\" border=\"0\" class=\"button\">
</a>";
$a_ret['DBLOOKUP']['FLD_MEDIACAT']['FLDLAB'] ='Medienkategorie';
$a_ret['DBLOOKUP']['FLD_MEDIACAT']['FLDVAL'] =$this->getCatSelectTree(NULL,0,"EDIT",FALSE,0,$debug);
$a_ret['DBLOOKUP']['FLD_MEDIACAT']['FLDVAL'].="
<input type=\"checkbox\" name=\"allowChangeCat\" value=\"1\" ".($this->allowChangeCat ? "checked":"").">
Wechesl in Unterkategorien zulassen.
";
$a_ret['FTBL_POPUPS']=array(
'TITLE'=>"Bearbeiten/Hinzufügen",
'FLD_ALLOWNEWMED'=>array(
'FLDLAB'=>'Neue Medien',
'FLDVAL'=>"
<input type=\"checkbox\" name=\"allowNewMedia\" value=\"1\" ".($this->allowNewMedia ? "checked" :"")."> ja, upload von Medien erlabuen.<br />
<input type=\"checkbox\" name=\"allowNewSubCat\" value=\"1\" ".($this->allowNewSubCat ? "checked" :"")."> ja neue Medienkategorie erlauben"
),
'FLD_NEWPUP'=>array(
'FLDLAB'=>"Neuer Datensatz URL",
'FLDVAL'=>"<input name=\"newUrl\" value=\"".$this->newUrl."\" size=\"40\">"
),
'FLD_ALLOWEDITMED'=>array(
'FLDLAB'=>'Medien bearbeiten',
'FLDVAL'=>"<input type=\"checkbox\" name=\"allowEditMedia\" value=\"1\" ".($this->allowEditMedia ? "checked" :"")."> ja, bearbeiten von Medien erlabuen."
),
'FLD_EDITPUP'=>array(
'FLDLAB'=>"Datensatz bearbeiten URL",
'FLDVAL'=>"<input name=\"editUrl\" value=\"".$this->editUrl."\" size=\"40\">"
),
'FLD_PUPARGS'=>array(
'FLDLAB'=>"Popup Arguments",
'FLDVAL'=>'<input name="myURIQueryArrgs" value="'.$this->myURIQueryArrgs.'" size="40"><br />(durch Semicolon ";" getrennte Feldnamen)'
),
'FLD_POPUPSIZE'=>array(
'FLDLAB'=>"Popup Größe",
'FLDVAL'=>"
width=<input name=\"popupWndWidth\" value=\"".$this->popupWndWidth."\" size=\"4\"> 
height=<input name=\"popupWndHeight\" value=\"".$this->popupWndHeight."\" size=\"4\">
"
)
);
return $a_ret;
}
/**
* save the filed definition form
*
* @return bool <code>parent::save()</code>
* @version pk-03-10-17
*
***/
function save($debug=FALSE) {
$ret=parent::save($debug);
$this->foreignTbl ="T_MED_FILES";
$this->keyField ="MEF_ID";
$this->reloadFormOnChange =FALSE;
$this->mecRootId =intval($_POST['EDIT_MEC_ID_'.$this->myName]);
$this->allowChangeCat =(intval($_POST['allowChangeCat']) ? TRUE : FALSE);
$this->allowNewMedia =(intval($_POST['allowNewMedia']) ? TRUE : FALSE);
$this->allowNewSubCat =(intval($_POST['allowNewSubCat']) ? TRUE : FALSE);
$this->allowEditMedia =(intval($_POST['allowEditMedia']) ? TRUE : FALSE);
return $ret;
}
// ###########################################
/**
* returns the where part of to select the foreign Value
*
* @param string $arrName
* @param string $append
* @param boolean $debug
* @param boolean $withWhereAnd
*
* @returns string
*
* @version pk-06-08-08
* @version pk-07-02-08 bugfix with $append
*
***/
function getWhereStmt($arrName="DBVAL",$append="",$debug=FALSE,$withWhereAnd=TRUE) {
$debug=($debug || $this->fldDebug);
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_MEDIAFILE_SELID::getWhereStmt()");
if (!strstr($append,"MEF_ID")) {
if (!empty($append)) $append.=" AND"; // <pk-07-02-08 />
$append.=" MEC_ID=".(intval($this->cur_mecId) ? intval($this->cur_mecId) : intval($this->mecRootId)); // <pk-07-02-08> use cur_mecId if is set
}
return parent::getWhereStmt($arrName,$append,$debug,$withWhereAnd);
}
// ###########################################
/**
* returns the html code for category select tree
*
* @param int $aValue
* @param int $catTreeRoot
* @param string $arrName
* @param boolean $reloadOnChange
* @param int $mecId
* @param boolean $debug
*
* @return string
*
***/
function getCatSelectTree($aValue,$catTreeRoot=0,$arrName="DBVAL",$reloadOnChange=TRUE,$mecId=0,$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_MEDIAFILE_SELID::getCatSelectTree(ROOT: ".intval($catTreeRoot).")");
require_once $GLOBALS['OCSP_MED']['PHPINCPATH']."MED_CATEGORY.phpclass";
if (intval($mecId)) {
$i_mecId=intval($mecId);
} else if (intval($aValue)) {
$i_mecId=intval($GLOBALS['USRDB']->quickQuery("SELECT MEC_ID FROM T_MED_FILES WHERE MEF_ID=".intval($aValue),0));
} else {
$i_mecId=$this->mecRootId;
}
$this->cur_mecId=$i_mecId; // <pk-06-08-09 /> is used for generating queries
if ($debug) echo "<p style=\"padding-left: 20px;\">MEC_ID set to: ".$this->cur_mecId."</p>";
$ret="\n<select ";
$ret.=" name=\"".$arrName."_MEC_ID_".$this->myName."\" size=\"1\" ";
$ret.=" onChange=\"document.forms['".$this->getMyFormName()."'].action='".$frmReloadURL."#".$this->myName."';document.forms['".$this->getMyFormName()."'].submit();\"";
$ret.=">\n";
if (!intval($this->mecRootId)) {
$ret.="<option value=\"\">Wurzel</option>\n";
}
$mecTree=new MED_CATEGORY();
$mecTree->populateTree(TRUE,FALSE);
if (intval($catTreeRoot)) {
$o_mecRoot=$mecTree->getNode(intval($catTreeRoot),FALSE);
} else {
$o_mecRoot=NULL;
}
$ret.= $mecTree->getHTMLSelectOptionList($o_mecRoot,$i_mecId,FALSE);
$ret.="\n</select>";
return $ret;
}
/**
* returns the html code for the add Button
*
* @param string $arrName
* @param string $url
*
* @returns string
*
* @since pk-04-08-31
* @version pk-05-03-17 getPopupLinkJs added -> rewrite
*
***/
function getAddButton($arrName="",$url="",$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_MEDIAFILE_SELID::getAddButton()");
require_once $GLOBALS['MED']['PHPINCPATH']."MED_CATEGORY_NODE.phpclass";
$this->myDataArrName=$arrName;
global ${$arrName};
$i_mecId=(isset(${$arrName['MEC_ID']}) ? intval(${$arrName['MEC_ID']}) : $this->mecRootId);
$i_mecId=(intval($this->cur_mecId) ? $this->cur_mecId : $i_mecId);
$o_mecNode=new MED_CATEGORY_NODE($i_mecId);
if ($o_mecNode->curUserCanUpload()) {
${$arrName}['MEC_ID']=$o_mecNode->getId();
if (empty($this->myURIQueryArrgs)) {
$this->myURIQueryArrgs="MEC_ID";
} else if (!strstr($this->myURIQueryArrgs,"MEC_ID")) {
$this->myURIQueryArrgs.=";MEC_ID";
}
$s_jsCmd=$this->getPopupLinkJs($GLOBALS['OCSP_MED']['CMS_WEBROOT']."file/newmedia.php",FRM_MODE_NEW,$debug);
$s_aName=$this->getMyFormName()."_".$this->myDataArrName."_".$this->myName;
$s_ret ="<a name=\"".$s_aName."\" href=\"#".$s_aName."\" onClick=\"".$s_jsCmd."\">";
$s_ret.="<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/filenew.gif\" border=\"0\" alt=\"hinzuf�gen\" class=\"button\">";
$s_ret.="</a>\n";
return $s_ret;
} else {
return "";
}
}
/**
* returns the html code for inputting the value
*
* @param mixed $aValue the value to set
* @param string $arrName
* @param string $nameAdd append something to name like "[VALUE]" for search forms
*
* @returns string
*
* @since pk-06-08-09
*
***/
function getInputTag($aValue,$arrName="DBVAL",$nameAdd="",$debug=FALSE) {
if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_MEDIAFILE_SELID::getInputTag()");
if (!empty($arrName)) $this->setDataArrName($arrName);
$s_ret="";
if ($this->allowChangeCat) {
if (isset($_POST[$arrName."_MEC_ID_".$this->myName]) && intval($_POST[$arrName."_MEC_ID_".$this->myName])) {
// we have a reload of the form use the postet value
$i_mecId=intval($_POST[$arrName."_MEC_ID_".$this->myName]);
} else if (intval($aValue)) {
$i_mecId=0; // let getCatSelectTree find the category ID out of the value or the mecRootId
}
$s_ret.=$this->getCatSelectTree($aValue,$this->mecRootId,$arrName,TRUE,$i_mecId,$debug);
} else {
if (!intval($this->mecRootId)) {
// configuration error
return "<p>CONFIGURATION ERROR: the field has no Category Root ID set</p>";
}
if (intval($aValue)) {
$s_query="SELECT MEC_NAME FROM T_MED_CATEGORY c,T_MED_FILES f WHERE c.MEC_ID=f.MEC_ID and MEF_ID=".intval($aValue);
if ($s_mecName=$GLOBALS[$this->get_gDBIDX()]->quickQuery($s_query,0)) {
$s_ret.=$s_mecName;
} else {
$s_query="SELECT MEC_NAME FROM T_MED_CATEGORY WHERE MEC_ID=".intval($this->mecRootId);
$s_ret.=$GLOBALS[$this->get_gDBIDX()]->quickQuery($s_query,0);
}
}
$this->cur_mecId=intval($this->mecRootId); // <pk-06-08-09 /> is used for generating queries
}
$s_ret.=$this->getSelect($aValue,$debug,$nameAdd);
return $s_ret;
}
// ###########################################################
// OBJECT VALUE CHECK/RETURN METHODS
// ###########################################################
}
?>

Source for file DBMS_FIELD_MEDIAFILE_SELID.phpclass