Initial import.

[siap.git] / manager / routines / form / routines.php

<?\r
include("../../app.php");\r
include("../../inc/inc.restrict.php");\r
include("../../inc/inc.menu.php");\r
\r
ini_set("max_execution_time", 60*20); //20 Minutes\r
\r
$output->ajaxHeader();\r
\r
global $routine;\r
\r
$routine = $input->get("routine");\r
$routine_field = $input->get("routine_field");\r
\r
//form class\r
$sub = $menu->getSub();\r
if (isset($sub)) {\r
	if($sub->module != ""){\r
		$load->config("forms/Form" . ucfirst($sub->class) . ".php");\r
		$class = "Form" . $sub->class;\r
		$form = new $class();\r
	}\r
}\r
\r
//insert / update / delete\r
if ($routine_field == "") {\r
	switch($routine) {\r
		case 'insert':\r
				$form->postInsert();\r
				\r
				redir("list.php?menu=" . $input->request("menu"), false, "", false);\r
			\r
			break;\r
		\r
		case 'update':\r
				$form->fields[$form->key_field] = $input->get("id");\r
				$form->select();\r
				\r
				$form->postUpdate();\r
		\r
				redir("list.php?menu=" . $input->request("menu"), false, "", false);\r
			\r
			break;\r
			\r
		case 'delete':\r
				$form->fields[$form->key_field] = $input->get("id");\r
				$form->select();\r
				\r
				$form->postDelete();\r
				\r
				redir("list.php?menu=" . $input->request("menu"), false, "", false);\r
			\r
			break;\r
			\r
		case 'delete_checks':\r
				foreach ($_POST as $k => $v) {\r
					$form->fields[$form->key_field] = $v;\r
					$form->select();\r
					\r
					$form->postDelete();\r
				}\r
				\r
				redir("list.php?menu=" . $input->request("menu"));\r
			\r
			break;\r
		\r
		case 'ativo':\r
				$id = $input->get("id");\r
				\r
				$form->fields[$form->key_field] = $id;\r
				$form->select();\r
				\r
				$name = $input->get("name");\r
				\r
				if($form->fields[$name] == 1){\r
					$form->fields[$name] = '0';\r
				} else {\r
					$form->fields[$name] = '1';\r
				}\r
				\r
				$form->update();\r
				\r
				if ($form->fields[$name] == 1) {\r
					echo "<img src='../img/icons/accept.gif' style='cursor: pointer;' onclick=\"javascript: ativoSwap(this, '" . $name . "', '" . $id . "'); \" src='' title='Alterar para inativo'>";\r
				} else {\r
					echo "<img src='../img/icons/cancel.gif' style='cursor: pointer;' onclick=\"javascript: ativoSwap(this, '" . $name . "', '" . $id . "'); \" src='' title='Alterar para ativo'>";\r
				}\r
			\r
			break;\r
	\r
		case 'refresh_combo':\r
				$value = $input->get('value');\r
				$name_fields = $input->get('name_fields');\r
				$table_rel = $input->get('table_rel');\r
				$value_field_rel = $input->get('value_field_rel');\r
				$name_field_rel = $input->get('name_field_rel');\r
				$value_select = $input->get('value_select');\r
\r
				$sql = "SELECT DISTINCT(" . $value_field_rel . "), " . $name_field_rel . " FROM " . $table_rel . " WHERE " . $name_fields . " LIKE '". $value."' ORDER BY ". $name_field_rel . " ASC";\r
				$rs = $db->execute($sql);\r
				\r
				if (!$rs->EOF) {\r
					echo("+ Selecione #+-------------");\r
					while(!$rs->EOF) {\r
							echo("#".$rs->fields($value_field_rel)."+".$rs->fields($name_field_rel));\r
						$rs->moveNext();\r
					}\r
				} else {\r
					echo("+Nenhum elemento relacionado");\r
				}\r
			break;\r
	\r
		case 'refresh_tree':\r
				/*\r
				 * 2 - id (campo a ser buscado na tabela)\r
				 * 3 - idPai (campo que se relaciona com o id)\r
				 * 4 - nome (campo que será mostrado nos outros combos)\r
				 * 5 - tabela (tabela)\r
				 */\r
				$args = array();\r
				$args[] = $input->get('arg0');\r
				$args[] = $input->get('arg1');\r
				$args[] = $input->get('arg2');\r
				$args[] = $input->get('arg3');\r
				$id = $input->get('id');\r
				\r
				$sql = "SELECT DISTINCT ".$args[0].",".$args[2]." FROM ".$args[3]." WHERE ".$args[1]." = ".$id." ORDER BY ". $args[2] . " ASC";\r
				//echo $sql;\r
				$rs = "";\r
				if ($id != "") {\r
					$rs = $db->execute($sql);\r
				}else{\r
					break;\r
				}\r
				\r
				if ((!$rs->EOF)&&($rs->recordcount > 0)){\r
					echo("+ Selecione #+-------------");\r
					//print_r2($rs);\r
					while(!$rs->EOF) {\r
							echo("#".$rs->fields($args[0])."+".$rs->fields($args[2]));\r
						$rs->moveNext();\r
					}\r
				}/* else {\r
					echo("");\r
				}*/\r
			break;\r
	}\r
}\r
\r
//fields routines\r
if ($routine_field != "") {\r
	$output->ajaxHeader();\r
	\r
	if ($routine == "update") {\r
		$id = $input->get("id");\r
		if ($id != "") {\r
			$form->fields[$form->key_field] = $id;\r
			$form->select();\r
		}\r
	}\r
	\r
	$f =& $form->getFieldByName($input->request("name"));\r
	\r
	echo $f->ajaxRoutine($routine_field);\r
}\r
?>