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

<?\r
include("../../app.php");\r
include("../../inc/inc.restrict.php");\r
include("../../inc/inc.menu.php");\r
\r
global $routine;\r
global $form;\r
\r
$output->ajaxHeader();\r
\r
$sub = $menu->getSub();\r
$load->config("forms/Form" . ucfirst($sub->class) . ".php");\r
$class = "Form" . $sub->class;\r
$form = new $class();\r
\r
//if is a form only\r
if ($form->is_unique) {\r
	redir("form.php?menu=" . $input->request("menu") . "&routine=insert");\r
	die();\r
}\r
\r
//headers\r
$routine = "O";\r
$headers = $form->getHeaders();\r
\r
//filters\r
$routine = "F";\r
$filters = $form->getFilters();\r
\r
\r
//Reset fieldset for list\r
$routine = "L";\r
$form->resetFieldSet();\r
\r
\r
//procces query/page\r
$records_total = 0;\r
if (($filters["sql"] != "") || ($form->show_list_init)) {\r
	//.query\r
	$sql = $form->getListSql($filters["sql"], $headers["sql"]);\r
	\r
	$rs_list = $db->execute($sql);\r
	\r
	//.page\r
	$page = $form->getListPage();\r
	$rs_list->pagesize = $form->page_size;\r
	$records_total = $rs_list->recordCount();\r
	\r
	if ($records_total > $form->page_size) {\r
		$rs_list->page($page);\r
	}\r
}\r
\r
//execute routine of button(if request)\r
$old_routine = $routine;\r
$routine = $input->get("routine");\r
if ($routine == "list_button") {\r
	$form->execButton($input->get("name"));\r
	\r
	die();\r
}\r
$routine = $old_routine;\r
\r
//load init of form and fields\r
$form->loadInitAll("L");\r
\r
//display filters\r
if (($filters["sql"] == "") && (!$form->show_filters_init)) {\r
	$filters_display = "none";\r
	$filters_img = "";\r
} else { \r
	$filters_display = ""; \r
	$filters_img = "_disabled";\r
}\r
\r
if ((IS_LOCAL) && (IS_DEVELOP)) {\r
	?><div style="text-align: center;"><a href="javascript: ajaxGet('<?= $_SERVER['PHP_SELF']; ?>');">refresh</a></div><br><?\r
}\r
?>\r
<script>\r
delete_enabled = <?= (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) ? "true" : "false"; ?>;\r
</script>\r
<div>\r
	<table cellspacing="0" cellpadding="0" width="968" height="16" border="0">\r
		<tr>\r
			<td width='80' align="left" nowrap>\r
				<? if ($filters["html"] != "") { ?>\r
					<a href="#" onClick="javascript: showHideFilters();" title="Mostrar/Esconder filtro(s)"><img id="img_filter" src="../img/buttons/filter<?= $filters_img; ?>.jpg"></a>\r
				<? } ?>\r
			</td>\r
			<td width="150" nowrap>\r
				<?\r
				if ($records_total) {\r
					?>Listando <b><?= $records_total; ?></b> registro<? \r
					\r
					if ($records_total > 1) {\r
						?>s<?\r
					}\r
				}\r
				?></td>\r
			<td align="center" width="100%">\r
				<?\r
				if ((($filters["sql"] != "") || ($form->show_list_init)) && ($rs_list->recordCount() > 0) && ($rs_list->pagecount > 1)) {\r
					?>\r
					<table cellpadding="0" cellspacing="0">\r
						<tr>\r
							<td width="10" valign="middle">\r
								<? if ($rs_list->absolutepage > 1) { ?>\r
									<a href="#" onClick="javascript: listPage('<?= $rs_list->absolutepage-1 ?>');" title="Página anterior">Anterior</a>\r
								<? } ?>\r
							</td>\r
							<td style="padding: 0 10 0 10px;" align="center">\r
								<?\r
								$i = 1;\r
								if($rs_list->pagecount > 10){\r
									if ($rs_list->absolutepage + 5 <= $rs_list->pagecount) {\r
										$i = $rs_list->absolutepage - 5;\r
									} else {\r
										$i = $rs_list->pagecount - 9;\r
									}\r
									if($i <= 0){\r
										$i = 1;\r
									}\r
								}\r
								$counter = 0;\r
								while (($i <= $rs_list->pagecount) && ($counter < 10)) {\r
									if ($rs_list->absolutepage <> $i) {\r
										?><a href="javascript: listPage('<?= $i; ?>')" class="link"><?= $i; ?></a><?\r
									} else {\r
										?><span style="color:#D7A964;font-size:11px;"><b><?= $i; ?></b></span><?\r
									}\r
									\r
									if ($i < $rs_list->pagecount) {\r
										?> | <?\r
									}\r
									\r
									$i++;\r
									$counter++;\r
								}\r
								?>\r
							</td>\r
							<td width="10" valign="middle">\r
								<? if ($rs_list->absolutepage < $rs_list->pagecount) { ?>\r
									<a href="#" onClick="javascript: listPage('<?= $rs_list->absolutepage+1; ?>');" title="Próxima página">Próximo</a>\r
								<? } ?>\r
							</td>\r
						</tr>\r
					</table>\r
					<?\r
				}\r
				?>\r
			</td>\r
			<td width="250" align="right" height="16" id="button_bar" nowrap>\r
				<?\r
				foreach ($form->_buttons as $v) {\r
					$title = "";\r
					if ($v["label"] != "") {\r
						$title = "title=\"" . $v["label"] . "\"";\r
					}\r
					\r
					\r
					?><a <?= $title; ?> href="javascript: nothing_func();" onclick="javascript: listButton('<?= $v["name"]; ?>'); "><img src="../../_config/img/<?= $v["name"]?>.gif" style="margin-bottom: 2px; margin-right: 5px;" /></a><?\r
				}\r
				?>\r
				<? if ($form->testFlag("I")) { ?>\r
					<a href="javascript: listInsert();" title="Inserir registro"><img src="../img/buttons/add.jpg" alt="Inserir"></a>\r
				<? } ?>\r
			</td>\r
		</tr>\r
	</table>\r
</div>\r
<div id="div_filtros" class="sep" style="display: <?= $filters_display; ?>">\r
	<form id="frm_filters" name="frm_filters" action="<?= $_SERVER["PHP_SELF"]; ?>" method="post">\r
	<table cellpadding="0" cellspacing="0" width="968">\r
		<tr>\r
			<td width="150" valign="top" align="left" style="padding: 10px;">\r
				Filtros\r
			</td>\r
			<input type="hidden" name="sql" value="<?= base64_encode($sql); ?>" />			\r
			<input type="hidden" name="menu" value="<?= $input->request("menu"); ?>" />\r
			<input type="hidden" name="page" id="input_page" value="<?= $page; ?>" />\r
			<input type="hidden" name="order" id="input_order" value="<?= $input->post("order"); ?>" />\r
			<input type="hidden" name="sem_filtro" id="input_sem_filtro" value="0" />\r
			<input type="hidden" name="extra" id="input_extra" value="" />\r
			<td align="center">\r
				<table cellpadding="0" cellspacing="2" width="100%">\r
					<?= $filters["html"]; ?>\r
				</table>\r
				<script>\r
				f.maskFields();\r
				</script>\r
				<br />\r
				<input type="image" src="../img/buttons/filter_submit.jpg" onclick="javascript: { preListSubmitFilters(); }" title="Filtrar" alt="Filtrar" />\r
				<? if ($filters["sql"] != "") { \r
					//<input type="image" src="../img/buttons/filter_clean.jpg" onclick="javascript: { $$('input_sem_filtro').value = '1'; listSubmitFilters(); }" title="Sem filtro" alt="Sem filtro" />?>\r
					<input type="image" src="../img/buttons/cancel.jpg" onclick="javascript: { $$('input_sem_filtro').value = '1'; listSubmitFilters(); }" title="Cancelar" alt="Cancelar" />\r
				<? } ?>\r
				<br /><br />\r
			</td>\r
		</tr>\r
	</table>\r
	</form>\r
</div>\r
<div class="sep">\r
	<form id="frm_list" name="frm_list" action="form/routines.php?menu=<?= $input->request("menu"); ?>&routine=delete_checks" method="post">\r
	<table cellpadding="0" cellspacing="1" width="968" class="listagem">\r
		<? if (($filters["sql"] != "") || ($form->show_list_init)) { ?>	\r
			<thead>\r
				<tr>\r
					<? //if ($form->testFlag("D")) { \r
						//condição conforme perfil adicionada\r
					   if (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) { ?>\r
						<td class="header_cinza" width="30"><input id="chk_todos" type="checkbox" onClick="javascript: check(this); "></td>\r
					<? } ?>\r
					<?= $headers["html"]; ?>\r
				</tr>\r
			</thead>\r
			<tbody>\r
			<?\r
			if (!$rs_list->EOF) {\r
				$css = 2;\r
				$i = 1;\r
				\r
				$fields = $form->getFieldSet();\r
				\r
				while (!$rs_list->EOF) {\r
					$css = 3 - $css;\r
					\r
					echo "<tr id='tr_" . $i . "' onmouseover=\"javascript: listOverOut('over', '" . $i . "');\" onmouseout=\"javascript: listOverOut('out', '" . $i . "');\">" . CRLF;\r
					\r
					$extra = "class='td" . $css . "' ";\r
					// $canChange = true;\r
					// if($rs_list->fields('id_usuario') != ''){\r
						// global $profile;\r
						// if($profile->fields('id') != 1){\r
							// if($profile->fields('id') != $rs_list->fields('id_usuario')){\r
								// $canChange = false;\r
							// }\r
						// }\r
					// }\r
					\r
					//if (($form->testFlag("U")) && ($canChange)) {\r
					if ($form->testFlag("U")) {\r
						$extra .= "onclick=\"javascript: listUpdate('" . $rs_list->fields($form->key_field) . "');\"";\r
					} else {\r
						$extra .= "style=\"cursor: default;\"";\r
					}\r
					\r
					if (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) {\r
						echo "	<td align='center'><input type='checkbox' name='chk_" . $i . "' id='chk_" . $i . "' value='" . $rs_list->fields($form->key_field) . "' onclick=\"javascript: { checkMostrar(); listOverOut('over', '" . $i . "'); }\"></td>" . CRLF;\r
					}\r
					\r
					$form->setValuesFromRs($rs_list);\r
					\r
					foreach ($fields as $k => $v) {\r
						if ($v->testFlag("L")) {\r
							$v->value = $rs_list->fields($v->name);\r
							$v->is_formated = false;\r
							\r
							echo "	" . trim($v->getHtmlList($extra)) . LF;\r
						}\r
					}\r
					\r
					echo "</tr>";\r
					\r
					$rs_list->moveNext();\r
					$i++;\r
				}\r
			} else {\r
				?><tr><td colspan="100%" align="center" style="height: 40px; background: #ECD9D5;"><strong style="color: #9D412C;">Nenhum registro encontrado</strong></td></tr><?\r
			}?>\r
			</tbody>\r
			<?\r
		}\r
		?>\r
	</table>\r
	</form>\r
</div>\r
<div class="sep" id="div_botao_excluir" style="display: none;">\r
	<a href="javascript: checkExcluir();" title="Excluir Selecionados"><img src="../img/buttons/delete_selected.jpg" alt="Excluir Selecionados" /></a>\r
</div>\r
<?\r
$debug->loadList();\r
?>
Commit	Line	Data
696f20d5 MS	1	<?\r
	2	include("../../app.php");\r
	3	include("../../inc/inc.restrict.php");\r
	4	include("../../inc/inc.menu.php");\r
	5	\r
	6	global $routine;\r
	7	global $form;\r
	8	\r
	9	$output->ajaxHeader();\r
	10	\r
	11	$sub = $menu->getSub();\r
	12	$load->config("forms/Form" . ucfirst($sub->class) . ".php");\r
	13	$class = "Form" . $sub->class;\r
	14	$form = new $class();\r
	15	\r
	16	//if is a form only\r
	17	if ($form->is_unique) {\r
	18	redir("form.php?menu=" . $input->request("menu") . "&routine=insert");\r
	19	die();\r
	20	}\r
	21	\r
	22	//headers\r
	23	$routine = "O";\r
	24	$headers = $form->getHeaders();\r
	25	\r
	26	//filters\r
	27	$routine = "F";\r
	28	$filters = $form->getFilters();\r
	29	\r
	30	\r
	31	//Reset fieldset for list\r
	32	$routine = "L";\r
	33	$form->resetFieldSet();\r
	34	\r
	35	\r
	36	//procces query/page\r
	37	$records_total = 0;\r
	38	if (($filters["sql"] != "") \|\| ($form->show_list_init)) {\r
	39	//.query\r
	40	$sql = $form->getListSql($filters["sql"], $headers["sql"]);\r
	41	\r
	42	$rs_list = $db->execute($sql);\r
	43	\r
	44	//.page\r
	45	$page = $form->getListPage();\r
	46	$rs_list->pagesize = $form->page_size;\r
	47	$records_total = $rs_list->recordCount();\r
	48	\r
	49	if ($records_total > $form->page_size) {\r
	50	$rs_list->page($page);\r
	51	}\r
	52	}\r
	53	\r
	54	//execute routine of button(if request)\r
	55	$old_routine = $routine;\r
	56	$routine = $input->get("routine");\r
	57	if ($routine == "list_button") {\r
	58	$form->execButton($input->get("name"));\r
	59	\r
	60	die();\r
	61	}\r
	62	$routine = $old_routine;\r
	63	\r
	64	//load init of form and fields\r
65	$form->loadInitAll("L");\r
66	\r
67	//display filters\r
68	if (($filters["sql"] == "") && (!$form->show_filters_init)) {\r
69	$filters_display = "none";\r
70	$filters_img = "";\r
71	} else { \r
72	$filters_display = ""; \r
73	$filters_img = "_disabled";\r
74	}\r
75	\r
76	if ((IS_LOCAL) && (IS_DEVELOP)) {\r
77	?><div style="text-align: center;"><a href="javascript: ajaxGet('<?= $_SERVER['PHP_SELF']; ?>');">refresh</a></div><br><?\r
78	}\r
79	?>\r
80	<script>\r
81	delete_enabled = <?= (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) ? "true" : "false"; ?>;\r
82	</script>\r
83	<div>\r
84	<table cellspacing="0" cellpadding="0" width="968" height="16" border="0">\r
85	<tr>\r
86	<td width='80' align="left" nowrap>\r
87	<? if ($filters["html"] != "") { ?>\r
88	<a href="#" onClick="javascript: showHideFilters();" title="Mostrar/Esconder filtro(s)"><img id="img_filter" src="../img/buttons/filter<?= $filters_img; ?>.jpg"></a>\r
89	<? } ?>\r
90	</td>\r
91	<td width="150" nowrap>\r
92	<?\r
93	if ($records_total) {\r
94	?>Listando <b><?= $records_total; ?></b> registro<? \r
95	\r
96	if ($records_total > 1) {\r
97	?>s<?\r
98	}\r
99	}\r
100	?></td>\r
101	<td align="center" width="100%">\r
102	<?\r
103	if ((($filters["sql"] != "") \|\| ($form->show_list_init)) && ($rs_list->recordCount() > 0) && ($rs_list->pagecount > 1)) {\r
104	?>\r
105	<table cellpadding="0" cellspacing="0">\r
106	<tr>\r
107	<td width="10" valign="middle">\r
108	<? if ($rs_list->absolutepage > 1) { ?>\r
109	<a href="#" onClick="javascript: listPage('<?= $rs_list->absolutepage-1 ?>');" title="Página anterior">Anterior</a>\r
110	<? } ?>\r
111	</td>\r
112	<td style="padding: 0 10 0 10px;" align="center">\r
113	<?\r
114	$i = 1;\r
115	if($rs_list->pagecount > 10){\r
116	if ($rs_list->absolutepage + 5 <= $rs_list->pagecount) {\r
117	$i = $rs_list->absolutepage - 5;\r
118	} else {\r
119	$i = $rs_list->pagecount - 9;\r
120	}\r
121	if($i <= 0){\r
122	$i = 1;\r
123	}\r
124	}\r
125	$counter = 0;\r
126	while (($i <= $rs_list->pagecount) && ($counter < 10)) {\r
127	if ($rs_list->absolutepage <> $i) {\r
128	?><a href="javascript: listPage('<?= $i; ?>')" class="link"><?= $i; ?></a><?\r
129	} else {\r
130	?><span style="color:#D7A964;font-size:11px;"><b><?= $i; ?></b></span><?\r
131	}\r
132	\r
133	if ($i < $rs_list->pagecount) {\r
134	?> \| <?\r
135	}\r
136	\r
137	$i++;\r
138	$counter++;\r
139	}\r
140	?>\r
141	</td>\r
142	<td width="10" valign="middle">\r
143	<? if ($rs_list->absolutepage < $rs_list->pagecount) { ?>\r
144	<a href="#" onClick="javascript: listPage('<?= $rs_list->absolutepage+1; ?>');" title="Próxima página">Próximo</a>\r
145	<? } ?>\r
146	</td>\r
147	</tr>\r
148	</table>\r
149	<?\r
150	}\r
151	?>\r
152	</td>\r
153	<td width="250" align="right" height="16" id="button_bar" nowrap>\r
154	<?\r
155	foreach ($form->_buttons as $v) {\r
156	$title = "";\r
157	if ($v["label"] != "") {\r
158	$title = "title=\"" . $v["label"] . "\"";\r
159	}\r
160	\r
161	\r
162	?><a <?= $title; ?> href="javascript: nothing_func();" onclick="javascript: listButton('<?= $v["name"]; ?>'); "><img src="../../_config/img/<?= $v["name"]?>.gif" style="margin-bottom: 2px; margin-right: 5px;" /></a><?\r
163	}\r
164	?>\r
165	<? if ($form->testFlag("I")) { ?>\r
166	<a href="javascript: listInsert();" title="Inserir registro"><img src="../img/buttons/add.jpg" alt="Inserir"></a>\r
167	<? } ?>\r
168	</td>\r
169	</tr>\r
170	</table>\r
171	</div>\r
172	<div id="div_filtros" class="sep" style="display: <?= $filters_display; ?>">\r
173	<form id="frm_filters" name="frm_filters" action="<?= $_SERVER["PHP_SELF"]; ?>" method="post">\r
174	<table cellpadding="0" cellspacing="0" width="968">\r
175	<tr>\r
176	<td width="150" valign="top" align="left" style="padding: 10px;">\r
177	Filtros\r
178	</td>\r
179	<input type="hidden" name="sql" value="<?= base64_encode($sql); ?>" /> \r
180	<input type="hidden" name="menu" value="<?= $input->request("menu"); ?>" />\r
181	<input type="hidden" name="page" id="input_page" value="<?= $page; ?>" />\r
182	<input type="hidden" name="order" id="input_order" value="<?= $input->post("order"); ?>" />\r
183	<input type="hidden" name="sem_filtro" id="input_sem_filtro" value="0" />\r
184	<input type="hidden" name="extra" id="input_extra" value="" />\r
185	<td align="center">\r
186	<table cellpadding="0" cellspacing="2" width="100%">\r
187	<?= $filters["html"]; ?>\r
188	</table>\r
189	<script>\r
190	f.maskFields();\r
191	</script>\r
192	<br />\r
193	<input type="image" src="../img/buttons/filter_submit.jpg" onclick="javascript: { preListSubmitFilters(); }" title="Filtrar" alt="Filtrar" />\r
194	<? if ($filters["sql"] != "") { \r
195	//<input type="image" src="../img/buttons/filter_clean.jpg" onclick="javascript: { $$('input_sem_filtro').value = '1'; listSubmitFilters(); }" title="Sem filtro" alt="Sem filtro" />?>\r
196	<input type="image" src="../img/buttons/cancel.jpg" onclick="javascript: { $$('input_sem_filtro').value = '1'; listSubmitFilters(); }" title="Cancelar" alt="Cancelar" />\r
197	<? } ?>\r
198	<br /><br />\r
199	</td>\r
200	</tr>\r
201	</table>\r
202	</form>\r
203	</div>\r
204	<div class="sep">\r
205	<form id="frm_list" name="frm_list" action="form/routines.php?menu=<?= $input->request("menu"); ?>&routine=delete_checks" method="post">\r
206	<table cellpadding="0" cellspacing="1" width="968" class="listagem">\r
207	<? if (($filters["sql"] != "") \|\| ($form->show_list_init)) { ?> \r
208	<thead>\r
209	<tr>\r
210	<? //if ($form->testFlag("D")) { \r
211	//condição conforme perfil adicionada\r
212	if (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) { ?>\r
213	<td class="header_cinza" width="30"><input id="chk_todos" type="checkbox" onClick="javascript: check(this); "></td>\r
214	<? } ?>\r
215	<?= $headers["html"]; ?>\r
216	</tr>\r
217	</thead>\r
218	<tbody>\r
219	<?\r
220	if (!$rs_list->EOF) {\r
221	$css = 2;\r
222	$i = 1;\r
223	\r
224	$fields = $form->getFieldSet();\r
225	\r
226	while (!$rs_list->EOF) {\r
227	$css = 3 - $css;\r
228	\r
229	echo "<tr id='tr_" . $i . "' onmouseover=\"javascript: listOverOut('over', '" . $i . "');\" onmouseout=\"javascript: listOverOut('out', '" . $i . "');\">" . CRLF;\r
230	\r
231	$extra = "class='td" . $css . "' ";\r
232	// $canChange = true;\r
233	// if($rs_list->fields('id_usuario') != ''){\r
234	// global $profile;\r
235	// if($profile->fields('id') != 1){\r
236	// if($profile->fields('id') != $rs_list->fields('id_usuario')){\r
237	// $canChange = false;\r
238	// }\r
239	// }\r
240	// }\r
241	\r
242	//if (($form->testFlag("U")) && ($canChange)) {\r
243	if ($form->testFlag("U")) {\r
244	$extra .= "onclick=\"javascript: listUpdate('" . $rs_list->fields($form->key_field) . "');\"";\r
245	} else {\r
246	$extra .= "style=\"cursor: default;\"";\r
247	}\r
248	\r
249	if (($form->testFlag("D")) && ($profile->fields('nivel') == 1)) {\r
250	echo " <td align='center'><input type='checkbox' name='chk_" . $i . "' id='chk_" . $i . "' value='" . $rs_list->fields($form->key_field) . "' onclick=\"javascript: { checkMostrar(); listOverOut('over', '" . $i . "'); }\"></td>" . CRLF;\r
251	}\r
252	\r
253	$form->setValuesFromRs($rs_list);\r
254	\r
255	foreach ($fields as $k => $v) {\r
256	if ($v->testFlag("L")) {\r
257	$v->value = $rs_list->fields($v->name);\r
258	$v->is_formated = false;\r
259	\r
260	echo " " . trim($v->getHtmlList($extra)) . LF;\r
261	}\r
262	}\r
263	\r
264	echo "</tr>";\r
265	\r
266	$rs_list->moveNext();\r
267	$i++;\r
268	}\r
269	} else {\r
270	?><tr><td colspan="100%" align="center" style="height: 40px; background: #ECD9D5;"><strong style="color: #9D412C;">Nenhum registro encontrado</strong></td></tr><?\r
271	}?>\r
272	</tbody>\r
273	<?\r
274	}\r
275	?>\r
276	</table>\r
277	</form>\r
278	</div>\r
279	<div class="sep" id="div_botao_excluir" style="display: none;">\r
280	<a href="javascript: checkExcluir();" title="Excluir Selecionados"><img src="../img/buttons/delete_selected.jpg" alt="Excluir Selecionados" /></a>\r
281	</div>\r
282	<?\r
283	$debug->loadList();\r
284	?>