Source for file OCSP_FORM_DBCONTROLL.phpclass

Documentation is available at OCSP_FORM_DBCONTROLL.phpclass

  1. <?php
  2. /**
  3.   * Class file OCSP_FORM_DBCONTROLL.phpclass
  4.   *
  5.   *
  6.   * @project    Open CSP-Management
  7.   * @package    forms
  8.   * @category   dbms_form
  9.   *
  10.   * @author     Peter Krebs (pk) <pitlinz@users.sourceforge.net>
  11.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  12.   *
  13.   * @since  pk-07-08-04
  14.   *
  15.   ***/
  16.  
  17.     if (!defined('__OCSP_NO_DBFIELD__')) define('__OCSP_NO_DBFIELD__','__NO-DBFIELD__');
  18.  
  19. /**
  20.   * class OCSP_FORM_DBCONTROLL
  21.   *
  22.   * root class of database handling for form fields
  23.   *
  24.   * @project    Open CSP-Management
  25.   * @package    forms
  26.   * @category   dbms_form
  27.   *
  28.   * @author     Peter Krebs (pk) <pitlinz@users.sourceforge.net>
  29.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  30.   *
  31.   * @since  pk-07-08-04
  32.   *
  33.   */
  34. class OCSP_FORM_DBCONTROLL
  35. {
  36.  
  37.     /**
  38.       * this constructure returns an object of the subclass able to
  39.       * deal with the database type of $aDBObj
  40.       *
  41.       * @param OCSP_DB $aDBObj 
  42.       * @param boolean $debug 
  43.       *
  44.       */
  45.     function newSubClass(&$aDBObj,$debug=FALSE)
  46.     {
  47.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FORM_DBCONTROLL::newSubClass(".get_class($aDBObj).")");
  48.  
  49.         $str_subClassName=str_replace('OCSP_DB','OCSP_FORM_DBCTRL',get_class($aDBObj));
  50.         if (!class_exists($str_subClassName))
  51.         {
  52.             if (file_exists(dirname(__FILE__)._OCSP_DIRSEP_.$str_subClassName.".phpclass"))
  53.             {
  54.                 require_once dirname(__FILE__)._OCSP_DIRSEP_.$str_subClassName.".phpclass";
  55.             } else {
  56.                 $str_subClassName=get_class($this);
  57.             }
  58.         }
  59.  
  60.         $str_cmd="\$obj_ret=new ".$str_subClassName."();";
  61.         eval($str_cmd);
  62.         if (!isset($obj_ret))
  63.         {
  64.             ocsp_logError(__FILE__,__LINE__,"could not eval $str_cmd");
  65.             return new OCSP_FORM_DBCONTROLL();
  66.         }
  67.         return $obj_ret;
  68.     }
  69.  
  70.     /** generates a colDesc
  71.       *
  72.       * @param string $colName 
  73.       * @param string $colType 
  74.       * @param string $table 
  75.       * @param string $size 
  76.       * @param boolean $debug 
  77.       *
  78.       * @return array 
  79.       *
  80.       */
  81.     function generateColDesc($colName,$colType,$table=__OCSP_NO_DBFIELD__,$size='0',$debug=FALSE)
  82.     {
  83.         return array(
  84.                 'NULL'              => TRUE,
  85.                 'AUTO_INCREMENT'    => FALSE,
  86.                 'PRIMARY_KEY'       => FALSE,
  87.                 'DEFAULT'           => '',
  88.                 'KEY'               => '',
  89.                 'COLNAME'           => $colName,
  90.                 'TABLE'             => $table,
  91.                 'TYPE'              => $colType,
  92.                 'LEN'               => $size,
  93.                 'FLAGS'             => NULL,
  94.             );
  95.     }
  96.  
  97.     /**
  98.       * @param array $colDesc 
  99.       * @param boolean $debug 
  100.       */
  101.     function generateField($colDesc,$debug=FALSE)
  102.     {
  103.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FORM_DBCONTROLL::generateField()");
  104.  
  105.         require_once __OCSP_PHPINCPATH__."db"._OCSP_DIRSEP_."frmClasses"._OCSP_DIRSEP_."DBMS_FIELD.phpclass";
  106.         return new DBMS_FIELD($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  107.     }
  108.  
  109.     /**
  110.       * creates the field column in the database
  111.       *
  112.       * @param DBMS_FIELD $field (name or object)
  113.       * @param boolean $debug 
  114.       *
  115.       * @global array $OCSP_OBJ 
  116.       *
  117.       * @return boolean 
  118.       */
  119.     function createDBColumn(&$field,$debug)
  120.     {        
  121.         global $OCSP_OBJ;
  122.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FORM_DBCTRL_mySQL::createDBColumn()");
  123.  
  124.         if (!OCSP_OBJ::currentUser()->isGroupMember(_OCSP_GROUP_DBMS_))
  125.         {
  126.             ocsp_logError(__FILE__,__LINE__,"no rights",E_NOTICE);
  127.             return FALSE;
  128.         }
  129.  
  130.         if (!pcf_is_instance_of($field,'DBMS_FIELD'))
  131.         {
  132.             ocsp_logError(__FILE__,__LINE__,"no field",E_WARNING);
  133.             return FALSE;
  134.         }
  135.  
  136.         $arr_desc=$field->getdbDesc();
  137.         $str_table=$field->getTable();
  138.  
  139.         if (!OCSP_OBJ::defaultReadDBObj()->tblExists($str_table))
  140.         {
  141.             
  142.             ocsp_logError(__FILE__,__LINE__,"$str_table does not exist",E_WARNING);
  143.             return FALSE;
  144.         }
  145.  
  146.         if (isset($arr_desc['NULL']) && !$arr_desc['NULL'])
  147.         {
  148.             if (!isset($arr_desc['DEFAULT']) || empty($arr_desc['DEFAULT']))
  149.             {
  150.                 $arr_desc['DEFAULT']=$field->getDefaultValue();
  151.                 if (empty($arr_desc['DEFAULT']))
  152.                 {
  153.                     $arr_desc['NULL']=TRUE;
  154.                 }
  155.             }
  156.         } else {
  157.             $arr_desc['NULL']=TRUE;
  158.         }
  159.  
  160.         if (!isset($arr_desc['COLNAME']) || empty($arr_desc['COLNAME']))
  161.         {
  162.             $arr_desc['COLNAME']=$field->getName();
  163.             if (empty($arr_desc['COLNAME']))
  164.             {
  165.                 ocsp_logError(__FILE__,__LINE__,"no column name set",E_WARNING);
  166.                 return FALSE;
  167.             }
  168.         }
  169.  
  170.         if (OCSP_OBJ::defaultWriteDBObj()->addColumn($str_table,$arr_desc['COLNAME'],$arr_desc,$debug))
  171.         {
  172.             $field->setdbDesc($arr_desc);
  173.             return TRUE;
  174.         } else {
  175.             return FALSE;
  176.         }
  177.     }
  178. }
  179.  
  180. ?>

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