<?php

class clsCustomField extends clsItem
{

    function clsCustomField($CustomFieldId=-1)
    {
        $this->clsItem();
        $this->tablename=GetTablePrefix()."CustomField";
        $this->type=10;
        $this->BasePermission="";
        $this->id_field = "CustomFieldId";
        $this->NoResourceId=1; //set this to avoid using a resource ID
		$this->debuglevel=0;
        if($CustomFieldId>-1)
            $this->LoadFromDatabase($CustomFieldId);
    }


    function GetAdminUI()
    {
    	$a = new clsConfigAdminItem();
        $a->name = "_".$this->Get("FieldName");
        $a->heading = $this->Get("Heading");
        $a->prompt = $this->Get("Prompt");
        $a->ElementType = $this->Get("ElementType");
    	
    	$main_prefix = $this->getMainPrefix($this->Get('Type'));
    	$fields = $this->Application->getUnitOption($main_prefix, 'Fields');
    	if (isset($fields['cust'.$a->name]['required']) && $fields['cust'.$a->name]['required']) {
    		$a->ValidationRules = 'exists';
    	}
    	else {
    		$a->ValidationRules = '';
    	}
    	
        $a->default_value = "";
        $a->ValueList=$this->Get("ValueList");
        if(!strlen($a->ElementType))
          $a->ElementType="text";
        if(!strlen($a->prompt))
          $a->prompt = "lu_fieldcustom__".strtolower($this->Get("FieldName"));
        return $a;
      }

    function getMainPrefix($item_type)
    {
    	static $main_prefixes = null;
    	if (!isset($main_prefixes)) {
    		$sql = 'SELECT Prefix, ItemType
    				FROM '.TABLE_PREFIX.'ItemTypes';
    		$main_prefixes = $this->Conn->GetCol($sql, 'ItemType');
    	}
    	
    	return $main_prefixes[$item_type];
    }
    
    function parsetag($tag)
    {
         if(is_object($tag))
         {
             $tagname = $tag->name;
         }
         else
             $tagname = $tag;
         switch($tagname)
         {
             case "fieldlabel":
                 return $this->Get("FieldLabel");
                 break;

             case "fieldname":
                 return $this->Get("FieldName");
                 break;

             case "customfieldid":
                return $this->Get("CustomFieldId");

             default:
                 return "Undefined:$tagname";
                break;
         }
    }

 }

class clsCustomFieldList extends clsItemCollection
{
    var $Type;

    function clsCustomFieldList($type = -1, $table = 'CustomField')
    {
        $this->clsItemCollection();
        $this->Type = $type;
        $this->classname = 'clsCustomField';
        if ($table == 'CustomField') {
			$table = GetTablePrefix().$table;
        }

        $this->SourceTable = $table;
        if ($this->Type > 0) {
			$this->LoadFields();
        }
    }

    function LoadFields()
    {
        $this->Clear();
        $sql = 'SELECT *
        		FROM '.$this->SourceTable.'
        		WHERE Type = '.$this->Type.' AND (IsSystem = 0 OR OnGeneralTab = 1)
        		ORDER BY DisplayOrder DESC, CustomFieldId ASC';
        if($this->debuglevel > 1)
        	echo $sql."<br>\n";
        $rs = $this->adodbConnection->Execute($sql);

        while($rs && !$rs->EOF)
        {
            $data = $rs->fields;
            $this->AddItemFromArray($data);
            $rs->MoveNext();
        }
    }

    function LoadFieldsAndValues($ResourceId, $main_prefix, $temp_table = false)
    {
        $this->Clear();
        
		$this->Application->getUnitOption($main_prefix, 'TableName');
        $table = $this->Application->getUnitOption($main_prefix.'-cdata', 'TableName');
        if ($temp_table) {
        	$table = $this->Application->GetTempName($table, 'prefix:'.$main_prefix);
        }

        $sql = 'SELECT *
        		FROM '.$table.'
        		WHERE ResourceId = '.$ResourceId;
        $custom_data = $this->adodbConnection->GetRow($sql);

        $sql = 'SELECT *
        		FROM '.TABLE_PREFIX.'CustomField
        		WHERE Type = '.$this->Application->getUnitOption($main_prefix, 'ItemType');
        $custom_fields = $this->Conn->Query($sql, 'CustomFieldId');

        $ml_formatter =& $this->Application->recallObject('kMultiLanguage');
        foreach ($custom_fields as $custom_id => $custom_info) {
        	$custom_name = $ml_formatter->LangFieldName('cust_'.$custom_id);
        	$custom_info['Value'] = $custom_data[$custom_name];
        	$custom_info['CustomDataId'] = 0;
        	$this->AddItemFromArray($custom_info);
        }
    }

    function GetFieldUIList($GeneralTab=FALSE)
    {
    	$ret = new clsConfigAdmin();

    	if ($this->NumItems() > 0) {
    		foreach ($this->Items as $field) {
    			if ($GeneralTab == true && $field->Get('OnGeneralTab') == 1 || !$GeneralTab) {
    				$ui = $field->GetAdminUI();
    				array_push($ret->Items,$ui);
    			}
    		}
    	}
    	return $ret;
    }

    function GetFieldNames()
    {
        $res = array();
        foreach($this->Items as $f)
            $res[] = $f->Get("FieldName");
        return $res;
    }

    function SaveFields()
    {
        foreach($this->Items as $i)
        {
          if($i->Get("CustomFieldId"))
          {
              $i->Update();
          }
          else
              $i->Create();
        }

    }

    function Query_CustomField($where=NULL,$orderby=NULL,$limit=NULL)
    {
      $this->Clear();
      $sql = "SELECT * FROM ".$this->SourceTable;
      if(isset($where))
          $sql = sprintf('%s WHERE %s',$sql,$where);
      if(isset($orderby) && strlen(trim($orderby))>0)
          $sql = sprintf('%s ORDER BY %s',$sql,$orderby);
      if(isset($limit) && strlen(trim($limit)))
         $sql .= " ".$limit;
      // $sql."<br>";
      $this->Query_Item($sql);
      return $this->Items;
    }

    function AddField($Type,$FieldName,$FieldLabel,$ShowGeneral=0,$Heading="", $Prompt="",
    				  $ElementType="",$ValueList="")
    {
    	global $objItemTypes,$objSearchConfig,$objLanguages;

    	//if(!is_numeric($Type))
    //	{
          $f = new clsCustomField();
          $f->tablename = $this->SourceTable;
          $f->Set(array("Type","FieldName","FieldLabel","OnGeneralTab","Heading","Prompt",
          				"ElementType","ValueList"),
                  array($Type,$FieldName,$FieldLabel,$ShowGeneral,$Heading,$Prompt,
                  		$ElementType,$ValueList));
          $f->Create();
          $Item = $objItemTypes->GetItem($Type);
          if(is_object($Item))
          {
          	  //$Table = $Item->Get("SourceTable");
          	  $Table = 'CustomField';
          	  $Header = "la_text_".strtolower($Item->Get("ItemName"));
          	  $Module = $Item->Get("Module");
//          	  $Desc = $FieldLabel;

          	  if(!is_object($objSearchConfig))
          	  {
          	  	$objSearchConfig = new clsSearchConfigList();
          	  }

			  $NextOrder = $objSearchConfig->GetNextDisplayOrder($Module);
			  $desc = "lu_fieldcustom__".strtolower($FieldName);
			  if(!strlen($FieldLabel))
			  {
			  	$FieldLabel = $FieldName;
			  }

		  	  $l = $objLanguages->GetPrimary();
 		  	  $phrases = new clsPhraseList();
 		  	  $phrases->AddPhrase($desc,$l,$FieldLabel,2, $Item->Get('Module') );

			  $dtable = GetTablePrefix()."CustomMetaData";
			  $Join = "($dtable.ResourceId={Table}.ResourceId)";
			  $objSearchConfig->AddSearchField($Table,$FieldName,$Module,$Type == 6 ? -1 : 0,0,
			  									$FieldLabel,$desc,$Header,$NextOrder,0,
			  									$ElementType, NULL, NULL, NULL, NULL, NULL,
			  									$f->Get("CustomFieldId"), NULL);
          }
          return $f;
    	//}
    	//else
    	//  return FALSE;
    }

    function EditField($FieldId,$Type,$FieldName,$FieldLabel,$ShowGeneral=0,$Heading="", $Prompt="",$ElementType="",$ValueList="")
    {
		global $objSearchConfig;

    	$f = $this->GetItem($FieldId);
		$f->Set(array("Type","FieldName","FieldLabel","OnGeneralTab","Heading","Prompt","ElementType","ValueList"),
                  array($Type,$FieldName,$FieldLabel,$ShowGeneral,$Heading,$Prompt,$ElementType,$ValueList));
		$f->Update();

		$db =& $this->adodbConnection;

		if (!$FieldLabel) $FieldLabel = $FieldName;
		$sql = 'UPDATE '.GetTablePrefix().'SearchConfig
				SET FieldType = '.$db->qstr($ElementType).',
					DisplayName = '.$db->qstr('lu_fieldcustom__'.strtolower($FieldName)).',
					FieldName = '.$db->qstr($FieldName).',
					Description = '.$db->qstr($FieldLabel).'
				WHERE CustomFieldId = '.$FieldId;
		$this->adodbConnection->Execute($sql);

		return $f;
    }

    function DeleteField($FieldId)
    {
    	global $objItemTypes, $objSearchConfig;
    	//echo "<pre>"; print_r($objSearchConfig); echo "</pre>";
        $f = $this->GetItem($FieldId);
        $Type = $f->Get("Type");
        $Item = $objItemTypes->GetItem($Type);
        $Module = $Item->Get("Module");
        if(is_object($Item))
        {
           //$table = $Item->Get("TableName");
           $table = GetTablePrefix()."CustomField";
           if(!is_object($objSearchConfig))
           {
           		$objSearchConfig = new clsSearchConfigList($Module);
           }

           $sql = 'DELETE FROM '.$objSearchConfig->SourceTable.' WHERE CustomFieldId = '.$FieldId;
           $this->adodbConnection->Execute($sql);

           $phrase_name = 'lu_fieldcustom__'.strtolower($f->Get('FieldName'));
           $sql = 'DELETE FROM '.GetTablePrefix().'Phrase WHERE Phrase = '.$this->adodbConnection->qstr($phrase_name);
           $this->adodbConnection->Execute($sql);
        }
        $f->Delete();
    }

}/*clsCustomFieldList*/


?>