Source for file OCSP_FORM_DBCTRL_mySQL.phpclass

Documentation is available at OCSP_FORM_DBCTRL_mySQL.phpclass

  1. <?php
  2. /**
  3.   * Class file OCSP_FORM_DBCTRL_mySQL.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.   * @requires OCSP_FORM_DBCONTROLL.phpclass
  16.   * 
  17.   * @version $Id: OCSP_FORM_DBCTRL_mySQL.phpclass,v 1.8 2008/06/02 21:09:27 pitlinz Exp $
  18.   */
  19.  
  20. require_once dirname(__FILE__)."/OCSP_FORM_DBCONTROLL.phpclass";
  21.  
  22. /**
  23.   * class OCSP_FORM_DBCONTROLL
  24.   *
  25.   * root class of database handling for form fields
  26.   * 
  27.   * @project    Open CSP-Management
  28.   * @package    forms
  29.   * @category   dbms_form
  30.   *
  31.   * @author     Peter Krebs (pk) <pitlinz@users.sourceforge.net>
  32.   * @license    http://opensource.org/licenses/gpl-license.php GNU Public License
  33.   *
  34.   * @since  pk-07-08-04
  35.   *
  36.   * @version $Id: OCSP_FORM_DBCTRL_mySQL.phpclass,v 1.8 2008/06/02 21:09:27 pitlinz Exp $
  37.   */
  38. class OCSP_FORM_DBCTRL_mySQL extends OCSP_FORM_DBCONTROLL
  39. {
  40.     /** generates a colDesc
  41.       *
  42.       * @param string $colName 
  43.       * @param string $colType 
  44.       * @param string $table 
  45.       * @param int $size 
  46.       * @param boolean $debug 
  47.       *
  48.       * @return array 
  49.       *
  50.       */
  51.     function generateColDesc($colName,$colType,$table=__OCSP_NO_DBFIELD__,$size='0',$debug=FALSE)
  52.     {
  53.         $arr_colDesc=parent::generateColDesc($colName,$colType,$table,$size,$debug);
  54.         
  55.         switch($colType) {
  56.             case "varchar":
  57.             case "string":
  58.             case "char": // <pk-08-02-27>
  59.                 $arr_colDesc['TYPE']="VARCHAR";
  60.                 if (!intval($size)) $size=32;
  61.                 else if ($size>255) $size=255;
  62.                 $arr_colDesc['LEN']=$size;
  63.                 break;
  64.             case "int":
  65.             case "integer":
  66.             case "tinyint":
  67.             case "smallint":
  68.             case "bigint":
  69.                 if (!intval($size))
  70.                 {
  71.                     $arr_colDesc['TYPE']="INT";
  72.                     $arr_colDesc['LEN'] ="11";
  73.                 }
  74.                 if (intval($size) < 5)
  75.                 {
  76.                     $arr_colDesc['TYPE']="TINYINT";
  77.                     $arr_colDesc['LEN'] =$size;
  78.                 } else if (intval($size) < 7) {
  79.                     $arr_colDesc['TYPE']="SMALLINT";
  80.                     $arr_colDesc['LEN'] =$size;
  81.                 } else if (intval($size) < 12) {
  82.                     $arr_colDesc['TYPE']="INT";
  83.                     $arr_colDesc['LEN'] =$size;
  84.                 } else {
  85.                     if ($size > 20) $size=20;
  86.                     $arr_colDesc['TYPE']="BIGINT";
  87.                     $arr_colDesc['LEN'] =$size;
  88.                 }
  89.                 break;
  90.             case "time":
  91.                 $arr_colDesc['TYPE']="TIME";
  92.                 $arr_colDesc['LEN']=8;
  93.                 break;
  94.             case "date":
  95.                 $arr_colDesc['TYPE']="DATE";
  96.                 $arr_colDesc['LEN']=10;
  97.                 break;
  98.             case "datetime":
  99.                 $arr_colDesc['TYPE']="DATETIME";
  100.                 $arr_colDesc['LEN']=19;
  101.                 break;
  102.             case "timestamp":
  103.                 $arr_colDesc['TYPE']="TIMESTAMP";
  104.                 $arr_colDesc['LEN']=14;
  105.                 break;
  106.             case "float":     // <pk-08-06-02 />
  107.             case "real":
  108.                 $arr_colDesc['TYPE']="FLOAT";
  109.                 $arr_colDesc['LEN']=NULL;
  110.                 break;
  111.             case "text":
  112.                 $arr_colDesc['TYPE']="TEXT";
  113.                 $arr_colDesc['LEN']=NULL;
  114.                 break;
  115.             case "blob":
  116.                 $arr_colDesc['TYPE']="BLOB";
  117.                 $arr_colDesc['LEN']=NULL;
  118.                 break;
  119.             case "layout":  // no database value only template or fix text form output
  120.                 $arr_colDesc['TYPE']="LAYOUT";
  121.                 $arr_colDesc['FLAGS']=__OCSP_NO_DBFIELD__;
  122.                 $arr_colDesc['TABLE']=__OCSP_NO_DBFIELD__;
  123.                 $arr_colDesc['LEN']=0;
  124.                 break;
  125.             default:
  126.                 ocsp_logError(__FILE__,__LINE__,"$colType not defined",E_NOTICE);
  127.         }
  128.         return $arr_colDesc;
  129.     }
  130.     
  131.     /**
  132.       * @param array $colDesc 
  133.       * @param boolean $debug 
  134.       *
  135.       * @param return DBMS_FIELD (the class best fit for dbType)
  136.       *
  137.       * @todo OCSP_FORM_DBCTRL_mySQL::use settings in T_DBMS_FIELDDESC
  138.       */
  139.     function generateField($colDesc,$debug=FALSE)
  140.     {
  141.         if ($debug) echoDebugMethod(__FILE__,get_class($this),"OCSP_FORM_DBCONTROLL::generateField()");
  142.         
  143.         switch(strtolower($colDesc['TYPE']))
  144.         {
  145.             case "tinyint":
  146.                 if ($colDesc['LEN']==1) 
  147.                 {
  148.                     require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_CHECKBOX.phpclass";
  149.                     return new DBMS_FIELD_CHECKBOX($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  150.                 }
  151.             case "smallint":
  152.             case "int":
  153.             case "bigint":
  154.                 if ($colDesc['AUTO_INCREMENT']) 
  155.                 {
  156.                     require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_AUTINC_KEY.phpclass";
  157.                     return new DBMS_FIELD_AUTINC_KEY($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  158.                 } else {
  159.                     require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_INT.phpclass";
  160.                     return new DBMS_FIELD_INT($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  161.                 }
  162.             case "float":
  163.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_FLOAT.phpclass";
  164.                 return new DBMS_FIELD_FLOAT($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  165.             case "text":
  166.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_TEXTAREA.phpclass";
  167.                 return new DBMS_FIELD_TEXTAREA($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  168.             case "date":
  169.             case "datetime":
  170.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_DATE.phpclass";
  171.                 return new DBMS_FIELD_DATE($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  172.             case "timestamp":
  173.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_TIMESTAMP.phpclass";
  174.                 return new DBMS_FIELD_TIMESTAMP($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  175.             case "char": // <pk-08-01-23 />
  176.               case "varchar":
  177.                 if ($colDesc['LEN'] > 128)
  178.                 {
  179.                     require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_TEXTAREA.phpclass";
  180.                     return new DBMS_FIELD_TEXTAREA($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  181.                 } else {
  182.                     require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD.phpclass";
  183.                     return new DBMS_FIELD($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  184.                 }
  185.             case "layout":
  186.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD_LAYOUT.phpclass";
  187.                 return new DBMS_FIELD_LAYOUT($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  188.             default:
  189.                 ocsp_logError(__FILE__,__LINE__,"unknown column type: <pre>".print_r($colDesc,TRUE)."</pre>",E_NOTICE);
  190.                 require_once __OCSP_PHPINCPATH__."db/frmClasses/DBMS_FIELD.phpclass";
  191.                 return new DBMS_FIELD($colDesc['TABLE'],$colDesc['COLNAME'],$colDesc);
  192.         }
  193.     }
  194.     
  195. } 
  196.  
  197. ?>

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