Source for file DBMS_FIELD_PRO_AUDIENCE.phpclass

Documentation is available at DBMS_FIELD_PRO_AUDIENCE.phpclass

  1. <?php
  2. /**
  3.   * Class file DBMS_FIELD_PRO_AUDIENCE.phpclass
  4.   *
  5.   * @project    Open CSP-Management
  6.   * @package    dbms_field
  7.   * @category   any
  8.   *
  9.   * @author     Peter Krebs <p.krebs@lvus.at>
  10.   * @copyright  &copy; 2002-2005 by Peter Krebs and Landesverlag Unternehmensservice
  11.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  12.   *
  13.   ***/
  14.  
  15. if (empty($GLOBALS['OCSP']['PHPFORMPATH'])) $GLOBALS['OCSP']['PHPFORMPATH']=dirname(__FILE__)."/";
  16.  
  17. if (!class_exists("DBMS_FIELD_DBLOOKUPSELECTLIST")) {
  18.     require_once dirname(__FILE__)."/DBMS_FIELD_DBLOOKUPSELECTLIST.phpclass";
  19. }
  20.  
  21. /**
  22.   * Class DBMS_FIELD_PRO_AUDIENCE
  23.   *
  24.   * handels audience (T_AUDIENCE) select fields
  25.   *
  26.   *
  27.   *
  28.   * @project    Open CSP-Management
  29.   * @package    dbms_field
  30.   * @category   any
  31.   *
  32.   * @author     Peter Krebs <p.krebs@wpus.at>
  33.   * @copyright  &copy; 2002-2005 by Peter Krebs and Landesverlag Unternehmensservice
  34.   * @copyright  &copy; 2005-2006 by Peter Krebs and WURM & Partner Unternehmensservice
  35.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  36.   *
  37.   * @since pk-06-02-10
  38.   *
  39.   ***/
  40. class DBMS_FIELD_PRO_AUDIENCE extends DBMS_FIELD_DBLOOKUPSELECTLIST {
  41.  
  42.     // ###########################################################
  43.     // OBJECT (CONST) VAR DECLARATION
  44.     // ###########################################################
  45.  
  46.     /**
  47.       * overwrite variables:
  48.       **/
  49.  
  50.      var $className         ="AudienceList";
  51.      var $lookupTable       ="T_AUDIENCE";
  52.      var $lookupShowField   ="AUD_NAME";
  53.      var $lookupField       ="AUD_ID";
  54.      var $classSrcFile      =__FILE__;
  55.      var $mySeperator       =",";
  56.  
  57.     // ###########################################################
  58.     // OBJECT SETTINGS METHODS
  59.     // ###########################################################
  60.  
  61.     /**
  62.       * echos the filed definition form
  63.       *
  64.       * @param boolean $showSize 
  65.       * @param boolean $showDBFields 
  66.       *
  67.       ***/
  68.      function editTblForm($showSize=FALSE,$showDBFields=FALSE) {
  69.         parent::editTblForm($showSize,$showDBFields);
  70.     }
  71.  
  72.     /**
  73.       * save the filed definition form
  74.       *
  75.       * @returns boolean
  76.       *
  77.       ***/
  78.     function save() {
  79.         $ret=parent::save();
  80.         $this->allowAddValues   =(intval($_POST['allowAddValues']) ? TRUE : FALSE );
  81.         $this->popUp_frmId      =(intval($_POST['popUp_frmId']));
  82.         $this->popUp_width      =(intval($_POST['popUp_width']));
  83.         $this->popUp_height     =(intval($_POST['popUp_height']));
  84.         $this->allowEditValues  =(intval($_POST['allowEditValues']) ? TRUE : FALSE );
  85.  
  86.         // fixed values
  87.         $this->lookupTable      = "T_AUDIENCE";
  88.         $this->lookupField      = "AUD_ID";
  89.         $this->lookupShowField  = "AUD_NAME";
  90.         $this->lookupWhere      = "";
  91.         $this->mySeperator=",";
  92.         return $ret;
  93.     }
  94.  
  95.     // ###########################################################
  96.     // OBJECT DATA METHODS
  97.     // ###########################################################
  98.  
  99.  
  100.     // ###########################################################
  101.     // OBJECT HTML FORM METHODS
  102.     // ###########################################################
  103.  
  104.     /**
  105.       * return a javascript code sequence to popup a input or edit dialog
  106.       *
  107.       * if $selName isset this is used instead of $this->myName
  108.       *
  109.       * if $mode is different from FRM_MODE_NEW the popup must get
  110.       * the value through javascript
  111.       *
  112.       * see $GLOBALS['OCSP']['SYSTEMURL']."forms/popup_form.php" for details
  113.       *
  114.       * if !empty $setMethod popup_form.php calls this method after adding
  115.       * the option instead of selecting the option
  116.       *
  117.       * @param int $mode 
  118.       * @param string $selName since 06-02-10 (name of the select element
  119.       * @param string $setMethod 
  120.       * @param boolean $debug 
  121.       *
  122.       * @returns string
  123.       *
  124.       * @since pk-06-02-06
  125.       *
  126.       ***/
  127.     function getPopupLinkJs($mode=FRM_MODE_NEW,$selName="",$setMethod="",$debug=FALSE) {
  128.         if ($debug) echo "<p><b>DBMS_FIELD_DBLOOKUPSELECTLIST::getPopupLinkJs(...)</b> (".get_class($this)."/".$this->myName.")</p>";
  129.  
  130.         $s_url=$GLOBALS['OCSP']['SYSTEMURL']."forms/popup_form.php?";
  131.         $a_args['FRMID']    =$this->popUp_frmId;
  132.         $a_args['FRMMODE']  =$mode;
  133.         $a_args['FRMNAME']  =$this->getMyFormName();
  134.         $a_args['ARRNAME']  =$this->myDataArrName;
  135.         $a_args['ARRFLD']   =$this->myName;
  136.         $a_args['SELFLD']   =(empty($selName) ? $this->myName : $selName);
  137.         $a_args['SETMETHOD']=$setMethod;
  138.         $a_args['SHOWFIELD']=$this->lookupShowField;
  139.         $a_args['KEYFIELD'] =$this->lookupField;
  140.         $a_args['TABLE']    =$this->lookupTable;
  141.  
  142.         require_once $GLOBALS['PHPINCPATH']."common/pcf_md5.phpinc";
  143.         $s_url.="ARGS=".urlencode(pcfmd5_encrypt(serialize($a_args)));
  144.  
  145.         if ($this->reloadFormOnChange) $url.="&OPENERRELOAD=1";
  146.  
  147.         $s_jCmd ="var url_".$this->myName."='".$s_url."';\n";
  148.         $s_jCmd.="var opt_".$this->myName."='width=".$this->popUp_width.",height=".$this->popUp_height.",toolbar=no,location=no,status=yes,menubar=no,scrollbars=yes,resizable=yes';\n";
  149.         $s_jCmd.="hWnd_".$this->myName."=window.open(url_".$this->myName.",'".$this->myName."', opt_".$this->myName.");\n";
  150.         $s_jCmd.="hWnd_".$this->myName.".focus();\n";
  151.  
  152.         if ($debug) echo "<blockquote><pre>".htmlspecialchars($s_jCmd)."</pre></blockquote>";
  153.  
  154.         return $s_jCmd;
  155.  
  156.     }
  157.  
  158.     /**
  159.       * returns the html option list of all elements in $aValArr
  160.       *
  161.       * @param array $aValArr 
  162.       * @param boolean $debug 
  163.       *
  164.       * @returns string
  165.       *
  166.       * @version pk-06-04-29 no empty values in list
  167.       *
  168.       ***/
  169.     function getOptionListIn($aValArr,$debug=FALSE) {
  170.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_PRO_AUDIENCE::getOptionListIn()","",0);
  171.  
  172.         $s_ret="";
  173.         if (is_array($aValArr)) {
  174.             foreach($aValArr as $m_key) {
  175.                 if (!empty($m_key)) { // <pk-06-04-29 />
  176.                     $s_ret.="\t<option value=\"".$m_key."\">".htmlspecialchars($this->getDBValue($m_key,$debug))."</option>\n";
  177.                 }
  178.             }
  179.         }
  180.  
  181.         return $s_ret;
  182.     }
  183.  
  184.     /**
  185.       * returns the html option list of all elements in $aValArr
  186.       *
  187.       * @param array $aValArr 
  188.       * @param boolean $debug 
  189.       *
  190.       * @returns string
  191.       *
  192.       * @version pk-06-04-29 no empty values in list
  193.       *
  194.       ***/
  195.     function getOptionListOut($aValArr,$debug=FALSE) {
  196.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"DBMS_FIELD_PRO_AUDIENCE::getOptionListIn()","",0);
  197.  
  198.         $this->setMyValues($arrName="DBVAL",$debug=FALSE);
  199.  
  200.         $s_ret="";
  201.         $a_allValues=$this->myValues;
  202.         if (is_array($a_allValues)) {
  203.             if (is_array($aValArr)) {
  204.                 foreach($aValArr as $m_key) {
  205.                     // remove selected form list
  206.                     unset($a_allValues[$m_key]);
  207.                 }
  208.             }
  209.             foreach($a_allValues as $m_key => $s_label) {
  210.                 if (!empty($m_key)) { // <pk-06-04-29 />
  211.                     $s_ret.="\t<option value=\"".$m_key."\">".htmlspecialchars($s_label)."</option>\n";
  212.                 }
  213.             }
  214.         }
  215.  
  216.         return $s_ret;
  217.     }
  218.  
  219.  
  220.     /**
  221.       * returns the html code for the select
  222.       *
  223.       * @param string $aValue 
  224.       * @param array $arrName 
  225.       * @param boolean $debug 
  226.       *
  227.       * @returns string
  228.       *
  229.       * @version pk-05-12-01
  230.       * @version pk-06-02-06 popUp_frmId
  231.       * @version pk-06-04-29 layout
  232.       *
  233.       ***/
  234.     function getInputTag($aValue,$arrName="DBVAL",$debug=FALSE) {
  235.         global ${$arrName};
  236.         if ($debug) echoDebugMethod(__FILE__,get_class($this)."DBMS_FIELD_PRO_AUDIENCE::getInputTag()","",0);
  237.  
  238.         $this->setMyValues($arrName,$debug);
  239.  
  240.         if (is_array($aValue)) {
  241.             $s_valStr=implode($this->mySeperator,$aValue);
  242.             $a_valArr=$aValue;
  243.         } else {
  244.             $s_valStr=$aValue;
  245.             $a_valArr=explode($this->mySeperator,$aValue);
  246.         }
  247.         if (!is_array($a_valArr)) {
  248.             // set empty array to avoid errors
  249.             $a_valArr=array();
  250.         }
  251.  
  252.  
  253.  
  254.         $ret ="<input type=\"hidden\" name=\"".$arrName."[".$this->myName."]\" value=\"$s_valStr\">";
  255.  
  256.         $s_eNamePart=$arrName."[".$this->myName;
  257.         $ret.="
  258.                 <script language=\"javascript\" type=\"text/javascript\">
  259.                 <!--
  260.                     function sel_".$arrName."_".$this->myName."_addAll() {
  261.                         frmObj=getFormByName('".$this->getMyFormName()."');
  262.                         elemOut=findElement(frmObj,'".$s_eNamePart."_outList]');
  263.                         elemIn =findElement(frmObj,'".$s_eNamePart."_inList]');
  264.                         if ((elemOut) && (elemIn)) {
  265.                             var i=0;
  266.                             while(i < elemOut.length) { // copy the fields from Out to In
  267.                                 nOpt_".$arrName."_".$this->myName."(elemOut[i].value,elemOut[i].text);
  268.                                 elemIn[elemIn.length]=new Option(elemOut[i].text,elemOut[i].value,false,false);
  269.                                 i++;
  270.                             }
  271.                             while(elemOut.length) elemOut[0]=null; // clear Out
  272.                         }
  273.                     }
  274.  
  275.                     function sel_".$arrName."_".$this->myName."_add() {
  276.                         frmObj=getFormByName('".$this->getMyFormName()."');
  277.                         elemOut=findElement(frmObj,'".$s_eNamePart."_outList]');
  278.                         elemIn =findElement(frmObj,'".$s_eNamePart."_inList]');
  279.                         if ((elemOut) && (elemIn) && (elemOut.selectedIndex)) {
  280.                             // alert(elemOut[elemOut.selectedIndex].value+'::'+elemOut[elemOut.selectedIndex].text);
  281.                             nOpt_".$arrName."_".$this->myName."(elemOut[elemOut.selectedIndex].value,elemOut[elemOut.selectedIndex].text);
  282.                             elemIn[elemIn.length]=new Option(elemOut[elemOut.selectedIndex].text,elemOut[elemOut.selectedIndex].value,false,false);
  283.                             elemOut[elemOut.selectedIndex]=null;
  284.                         }
  285.                     }
  286.  
  287.                     function sel_".$arrName."_".$this->myName."_remove() {
  288.                         frmObj=getFormByName('".$this->getMyFormName()."');
  289.                         elemOut=findElement(frmObj,'".$s_eNamePart."_outList]');
  290.                         elemIn =findElement(frmObj,'".$s_eNamePart."_inList]');
  291.                         if ((elemOut) && (elemIn) && (elemIn.selectedIndex)) {
  292.                             // alert(elemIn[elemIn.selectedIndex].value+'::'+elemIn[elemIn.selectedIndex].text);
  293.                             elemOut[elemOut.length]=new Option(elemIn[elemIn.selectedIndex].text,elemIn[elemIn.selectedIndex].value,false,false);
  294.                             elemIn[elemIn.selectedIndex]=null;
  295.                             sel_".$arrName."_".$this->myName."_updateHidden()
  296.                         }
  297.                     }
  298.  
  299.                     function sel_".$arrName."_".$this->myName."_removeAll() {
  300.                         frmObj=getFormByName('".$this->getMyFormName()."');
  301.                         elemOut=findElement(frmObj,'".$s_eNamePart."_outList]');
  302.                         elemIn =findElement(frmObj,'".$s_eNamePart."_inList]');
  303.                         if ((elemOut) && (elemIn)) {
  304.                             var i=0;
  305.                             while(i < elemIn.length) {
  306.                                 elemOut[elemOut.length]=new Option(elemIn[i].text,elemIn[i].value,false,false);
  307.                                 i++;
  308.                             }
  309.                             i=0;
  310.                             while(i < elemOut.length) elemOut[i++]=null; // clear Out
  311.                             setElemValByName(frmObj,'".$s_eNamePart."]','');
  312.                         }
  313.                     }
  314.  
  315.                     function sel_".$arrName."_".$this->myName."_updateHidden() {
  316.                         frmObj=getFormByName('".$this->getMyFormName()."');
  317.                         elemIn =findElement(frmObj,'".$s_eNamePart."_inList]');
  318.                         elemVal=findElement(frmObj,'".$s_eNamePart."]');
  319.  
  320.                         var i=0;
  321.                         var sep='';
  322.                         var values='';
  323.                         while(i < elemIn.length) {
  324.                             values=values+sep+elemIn[i++].value;
  325.                             sep=',';
  326.                         }
  327.                         setElemValByName(frmObj,'".$s_eNamePart."]',values);
  328.                     }
  329.  
  330.                     function nOpt_".$arrName."_".$this->myName."(key,label) {
  331.                         frmObj=getFormByName('".$this->getMyFormName()."');
  332.                         if (elem=findElement(frmObj,'".$s_eNamePart."]')) {
  333.                             if (elem.value != '') {
  334.                                 elem.value=elem.value+','+key;
  335.                             } else {
  336.                                 elem.value=key;
  337.                             }
  338.                         }
  339.                     }
  340.  
  341.  
  342.  
  343.                 //-->
  344.                 </script>
  345.             ";
  346.         $ret.="<table border=\"0\" class=\"frmSelInOut\">"; // <pk-06-04-29 /> align=center removed
  347.         $ret.="<tr><td width=\"45%\" align=\"center\">gew&auml;hlt</td><td width=\"10%\"><td width=\"45%\" align=\"center\">verf&uuml;gbar</td></tr>";
  348.         $ret.="<tr>";
  349.         $ret.="<td width=\"45%\" align=\"center\">";
  350.         $ret.="<select name=\"".$arrName."[".$this->myName."_inList]\" size=\"".intval($this->selectsize)."\">\n";
  351.         $ret.=$this->getOptionListIn($a_valArr,$debug);;
  352.         $ret.="</select>\n";
  353.  
  354.         $ret.="</td>";
  355.         $ret.="<td valign=\"middle\" width=\"10%\" align=\"center\">";
  356.  
  357.         $ret.="<a href=\"javascript:{sel_".$arrName."_".$this->myName."_addAll()}\">\n";
  358.         $ret.="\t\t<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/2leftarrow.gif\" border=\"0\" alt=\"alle Eif&uuml;gen\" align=\"middle\" class=\"button\"></a><br />";
  359.         $ret.="<a href=\"javascript:{sel_".$arrName."_".$this->myName."_add()}\">\n";
  360.         $ret.="\t\t<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/1leftarrow.gif\" border=\"0\" alt=\"gew&auml;hlte Eif&uuml;gen\" align=\"middle\" class=\"button\"></a><br />";
  361.         $ret.="<a href=\"javascript:{sel_".$arrName."_".$this->myName."_remove()}\">\n";
  362.         $ret.="\t\t<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/1rightarrow.gif\" border=\"0\" alt=\"gew&auml;hlte Entfernen\" align=\"middle\" class=\"button\"></a><br />";
  363.         $ret.="<a href=\"javascript:{sel_".$arrName."_".$this->myName."_removeAll()}\">\n";
  364.         $ret.="\t\t<img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/2rightarrow.gif\" border=\"0\" alt=\"alle Entfernen\" align=\"middle\" class=\"button\"></a><br />";
  365.  
  366.  
  367.         if (($this->allowAddValues) && (intval($this->popUp_frmId))) { // <pk-06-02-06>
  368.             $ret.="<!--\n\t\t _______ ADD VALUES BUTTON _______ \n";
  369.             $ret.="\t\t--> <a name=\"".$this->getMyFormName()."_".$this->myName."\" href=\"javascript:{";
  370.             $ret.=$this->getPopupLinkJs(FRM_MODE_NEW,$this->myName."_inList","nOpt_".$arrName."_".$this->myName,$debug);
  371.             $ret.="}\n";
  372.             $ret.="\t\t \"><img src=\"".$GLOBALS['PROJECT']['SYSIMGURL']."icons-16x16/filenew.gif\" border=\"0\" alt=\"neuer Eintrag\" align=\"middle\" class=\"button\">";
  373.             $ret.="</a><!--\n";
  374.             $ret.="\t\t _______ ADD VALUES BUTTON _______ \n-->";
  375.         }
  376.  
  377.         $ret.="</td>";
  378.  
  379.         $ret.="<td width=\"45%\" align=\"center\">";
  380.         $ret.="<select name=\"".$arrName."[".$this->myName."_outList]\" size=\"".intval($this->selectsize)."\" >\n";
  381.         $ret.=$this->getOptionListOut($a_valArr,$debug);;
  382.         $ret.="</select>\n";
  383.  
  384.         $ret.="</td>";
  385.         $ret.="</tr></table>";
  386.  
  387.         return $ret;
  388.     }
  389.  
  390.     // ###########################################################
  391.     // SEARCH FORM METHODS
  392.     // ###########################################################
  393.  
  394.     // ###########################################################
  395.     // OBJECT HTML FORM METHODS
  396.     // ###########################################################
  397.  
  398.     // ###########################################################
  399.     // OBJECT VALUE CHECK/RETURN METHODS
  400.     // ###########################################################
  401.  
  402.  
  403. } // end class DBMS_FIELD_PRO_AUDIENCE
  404. ?>

Documentation generated on Thu, 08 Jan 2009 17:42:40 +0100 by phpDocumentor 1.4.0a2