Initial import.

[siap.git] / manager / core / form / fields / FieldMultiItems.php

<?\r
class FieldMultiItems extends Field {\r
	var $menu;\r
	\r
	var $_table_rel;\r
	var $_table_rel_from_index;\r
	var $_table_rel_to_index;\r
	\r
	var $number_cols;\r
	\r
	function FieldMultiItems($tmp_params) {\r
		parent::Field("multiItems", $tmp_params[0]);\r
		\r
		$this->label = $tmp_params[1];\r
		$this->validation = "CHK";\r
		\r
		if (isset($tmp_params[2])) {\r
			$this->_table_rel = $tmp_params[2];\r
		}\r
		\r
		if (isset($tmp_params[3])) {\r
			$this->_table_rel_from_index = $tmp_params[3];\r
		}\r
		\r
		if (isset($tmp_params[4])) {\r
			$this->_table_rel_to_index = $tmp_params[4];\r
		}\r
		\r
		$this->is_required = false;\r
		$this->is_sql_affect = false;\r
		$this->number_cols = 4;\r
		\r
		$this->accept_flags = "IUL";\r
	}\r
	\r
	//private functions\r
	function getInput() {\r
		global $routine;\r
		global $db;\r
		global $form;\r
		\r
		//get values\r
		$arr_values = array();\r
		\r
		if ($routine == "update") {\r
			$sql = "select " . $this->_table_rel_to_index . " as k from " . $this->_table_rel . " where " . $this->_table_rel_from_index . " = '" . $form->fields("id") . "'";\r
			$rs = $db->execute($sql);\r
			\r
			while (!$rs->EOF) {\r
				$arr_values[$rs->fields("k")] = true;\r
			\r
				$rs->moveNext();\r
			}\r
		}\r
		\r
		\r
		//list\r
		$i = 1;\r
		$s = "";\r
		$html = "<table cellspaccing='0' cellpadding='0' width='100%'><tr><td>";\r
		$disabled = '';\r
		if($this->is_static){\r
			$disabled = ' disabled ';\r
		}\r
		foreach ($this->elements as $k => $v) {\r
			if (array_key_exists($k, $arr_values)) {\r
				$s = " checked".$disabled;\r
			} else {\r
				$s = "".$disabled;\r
			}\r
			\r
			$id = $this->_getFormatedId($i);\r
			\r
			$html .= "<div class='item' style='width:". floor(100 / $this->number_cols) ."%;'>";\r
			$html .= "<div id='input'>";\r
			$html .= "<input type='checkbox' id='" . $id . "' name='" . $this->name . "_" . $i . "' value='" . $k . "'" . $s . " " . $this->input_extra . ">";\r
			$html .= "</div><div id='label' style='width:auto;'>";\r
			$html .= "<label for='" . $id . "'>" . $v . "</label>";\r
			$html .= "</div>";\r
			$html .= "</div>" . LF;\r
			\r
			$i++;\r
		}\r
		\r
		$html .= "<input type='hidden' name='" . $this->name . "_total' id='" . $this->_getFormatedId() . "' value='" . ($i-1) . "'>";\r
		\r
		if (($this->menu != "") && (!$this->is_static)) {\r
			global $menu;\r
			\r
			$n = "";\r
			\r
			foreach ($menu->_itens as $k => $v) {\r
				foreach ($v["subs"] as $k2 => $v2) {\r
					if ($v2->class == $this->menu) {\r
						$n = $k . "-" . $k2;\r
						\r
						break;\r
					}\r
				}\r
			}\r
			\r
			if ($n != "") {\r
				$html .= "</td><td align='right' valign='top' width='0'><img style='position: absolute; margin-left: -12px; cursor: pointer;' title='Editar registros' align='top' onclick=\"javascript: { document.location = '?menu=" . $n . "'; }\" src='../img/icons/table_edit.gif'>";\r
			}\r
		}\r
		\r
		$html .= "</td></tr></table>";\r
		if($this->is_static){\r
			$this->value = $html;\r
		} else {\r
			return $html;\r
		}\r
	}\r
	\r
	function onPosPost() {\r
		global $db;\r
		global $form;\r
		global $routine;\r
		global $input;\r
		\r
		if ($this->_table_rel != "") {\r
			if ($routine == "update") {\r
				$this->onDelete();\r
			}\r
			\r
			$total = $input->post($this->name . "_total");\r
			$i = 1;\r
			$id = $form->fields("id");\r
			\r
			$inserts = array();\r
			\r
			while ($i <= $total) {\r
				$v = $input->post($this->name . "_" . $i);\r
				\r
				if ($v != "") {\r
					 $inserts[] = "('" . $id . "', '" . $v . "')";\r
				}\r
				\r
				$i++;\r
			}\r
			\r
			if (sizeof($inserts) > 0) {\r
				$sql = "insert into " . $this->_table_rel . " (" . $this->_table_rel_from_index . ", " . $this->_table_rel_to_index . ") values " . implode(", ", $inserts) . ";";\r
				$db->execute($sql);\r
			}\r
		}\r
	}\r
	\r
	function onDelete() {\r
		global $form;\r
		global $db;\r
		\r
		$sql = "delete from " . $this->_table_rel . " where " . $this->_table_rel_from_index . " = '" . $form->fields("id") . "'";\r
		$db->execute($sql);\r
	}\r
	\r
	function getHtmlList($tmp_extra) {\r
		$this->formatValue();\r
		\r
		$this->element_key = $this->value;\r
		if (array_key_exists($this->value, $this->elements)) {\r
			$this->value = $this->elements[$this->value];\r
		} else {\r
			$this->value = "";\r
		}\r
		\r
		if ($this->value == "") {\r
			if ($this->element_key == "") {\r
				$this->value = "<font color='silver'>(vazio)</font>";\r
			} else {\r
				$this->value = "<font color='silver'>[" . $this->element_key . "]</font>";\r
			}\r
		}\r
		\r
		$html = "<td " . $tmp_extra . ">" . $this->value . "</td>" . LF;\r
		\r
		return $html;\r
	}\r
}\r
?>