30 $cn->exec_sql(
"delete from rapport_advanced.declaration where to_keep='N' and d_generated < now() - interval '5 hours'");
31 $cn->exec_sql(
"delete from rapport_advanced.listing_compute where l_keep='N' and l_timestamp < now() - interval '5 hours'");
33 d_start,d_end,to_char(d_generated,'DD/MM/YY HH24:MI') as fmt_generated,
34 d_description,d_generated,
35 to_char(d_start,'YYMMDD') as fmt_start,
36 to_char(d_end,'YYMMDD') as fmt_end,
37 to_char(d_generated,'YYMMDDHH24MI') as fmt_order_generated,
39 from rapport_advanced.declaration
42 order by d_generated desc,d_title");
44 <div
id=
"declaration_list_div">
46 echo
'<span style="display:block">';
47 echo _(
'Cherche').HtmlInput::infobulle(204);
48 echo HtmlInput::filter_table(
"t_declaration",
"0,1,2,3",
"1");
51 <
table id=
"t_declaration" class=
"sortable">
53 <th
class=
" sorttable_sorted_reverse">
54 Date début <?php echo HtmlInput::infobulle(17);?>
67 <span
id=
"sorttable_sortrevind">&
nbsp;▴</span>
76 <?php
for ($i=0;$i<count($data);$i++) :?>
77 <?php
$class=($i%2==0)?
'class="even"':
' class="odd" '; ?>
78 <tr
id=
"tr_<?php echo $data[$i]['d_id']?>" <?php echo
$class;?> >
79 <td sorttable_customkey=
"<?php echo $data[$i]['fmt_start']?>">
81 <?php echo format_date(
$data[$i][
'd_start'])?>
83 <td sorttable_customkey=
"<?php echo $data[$i]['fmt_end']?>">
84 <?php echo format_date(
$data[$i][
'd_end'])?>
87 <?php echo h(
$data[$i][
'd_title'])?>
90 <?php echo h(
$data[$i][
'd_description'])?>
92 <td sorttable_customkey=
"<?php echo $data[$i]['fmt_order_generated']?>">
93 <?php echo h(
$data[$i][
'fmt_generated'])?>
95 <?php
if (
$data[$i][
'type']==1): ?>
97 <td
id=
"mod_<?php echo $data[$i]['d_id']?>">
98 <?php echo HtmlInput::anchor(
"Afficher",
"",sprintf(
"onclick=\"rapav_declaration_display('%s','%s','%s','%s')\"",
$_REQUEST[
'plugin_code'],
$_REQUEST[
'ac'],
$_REQUEST[
'gDossier'],
$data[$i][
'd_id']))?>
100 <td
id=
"del_<?php echo $data[$i]['d_id']?>">
101 <?php echo HtmlInput::anchor(
"Efface",
"",sprintf(
"onclick=\"rapav_declaration_delete('%s','%s','%s','%s')\"",
$_REQUEST[
'plugin_code'],
$_REQUEST[
'ac'],
$_REQUEST[
'gDossier'],
$data[$i][
'd_id']))?>
104 <?php
if (
$data[$i][
'type']==2): ?>
106 <td
id=
"mod_<?php echo $data[$i]['d_id']?>">
107 <?php echo HtmlInput::anchor(
"Afficher",
"",sprintf(
"onclick=\"rapav_listing_display('%s','%s','%s','%s')\"",
$_REQUEST[
'plugin_code'],
$_REQUEST[
'ac'],
$_REQUEST[
'gDossier'],
$data[$i][
'd_id']))?>
109 <td
id=
"del_<?php echo $data[$i]['d_id']?>">
110 <?php echo HtmlInput::anchor(
"Efface",
"",sprintf(
"onclick=\"rapav_listing_delete('%s','%s','%s','%s')\"",
$_REQUEST[
'plugin_code'],
$_REQUEST[
'ac'],
$_REQUEST[
'gDossier'],
$data[$i][
'd_id']))?>
117 <div
id=
"declaration_display_div">