function fill_from_action(&$p_array, $p_style) { global $g_user; $profile = $g_user->get_profile(); $cn = new Database(dossier::id()); $sql = "select ag_id,to_char(ag_remind_date,'DD')::integer as ag_timestamp_day,ag_title,ag_hour,\n coalesce(name,'interne') as str_name\n\t\t\t" . " from action_gestion " . " left join vw_fiche_name on (f_id=f_id_dest) " . " where " . " to_char(ag_remind_date,'MM')::integer=\$1 " . " and to_char(ag_remind_date,'YYYY')::integer=\$2 " . " and ag_dest in (select p_granted from user_sec_action_profile where p_id =\$3)\n\t\t\t\t and ag_state IN (2, 3)\n\t\t\t\t"; $array = $cn->get_array($sql, array($this->month, $this->year, $profile)); for ($i = 0; $i < count($array); $i++) { $ind = $array[$i]['ag_timestamp_day']; $this->action[$ind][] = $array[$i]['ag_id']; $this->title[$ind][] = $array[$i]['ag_title']; $this->hour[$ind][] = $array[$i]['ag_hour']; $this->str_name[$ind][] = $array[$i]['str_name']; } /* * Fill foreach day */ if ($p_style == "short") { foreach ($this->action as $day => $aAction) { if ($p_array[$day] == "") { $p_array[$day] = '<span class="input_text" onclick="display_task(\'tsk' . $day . '\');">' . " " . count($aAction) . " " . _("Tâches") . '</span>'; } $this->action_div[$day] = '<div id="tsk' . $day . '" class="inner_box" style="width:200;display:none">'; $this->action_div[$day] .= HtmlInput::title_box($day . "/" . $this->month . "/" . $this->year, "tsk" . $day, "hide"); $this->action_div[$day] .= "<ol>"; for ($i = 0; $i < count($aAction); $i++) { $this->action_div[$day] .= '<li>' . HtmlInput::detail_action($aAction[$i], $this->title[$day][$i]) . '</li>'; } $this->action_div[$day] .= '</ol></div>'; } } else { if ($p_style == "long") { foreach ($this->action as $day => $aAction) { $p_array[$day] .= "<ol>"; for ($i = 0; $i < count($aAction); $i++) { $p_array[$day] .= '<li>' . hb($this->str_name[$day][$i]) . '→' . HtmlInput::detail_action($aAction[$i], $this->hour[$day][$i] . " " . $this->title[$day][$i]) . '</li>'; } $p_array[$day] .= '</ol>'; } } } }
</h1> <?php } /** * show possible linked actions */ echo '<ul style="list-style-type:square;">'; for ($i = 0; $i < count($a_followup); $i++) { $remove = ''; if ($access == 'W') { $remove = HtmlInput::button_action_remove_operation($a_followup[$i]['ago_id']); } if ($div == 'popup') { echo '<li id="op' . $a_followup[$i]['ago_id'] . '">' . HtmlInput::detail_action($a_followup[$i]['ag_id'], h($a_followup[$i]['ag_ref'] . " " . $a_followup[$i]['ag_title']), 0) . $remove . '</li>'; } else { echo '<li id="op' . $a_followup[$i]['ago_id'] . '">' . HtmlInput::detail_action($a_followup[$i]['ag_id'], h($a_followup[$i]['ag_ref'] . " " . $a_followup[$i]['ag_title']), 1) . $remove . '</li>'; } } echo '</ul>'; $related = new IRelated_Action('related'); $related->id = 'related' . $div; if ($access == 'W') { echo $related->input(); } echo '</div>'; ?> <?php require_once NOALYSS_INCLUDE . '/template/ledger_detail_file.php'; ?>
<table style="width: 100%"> <?php for ($i = 0; $i < $len_array; $i++) { ?> <tr class=" <?php echo $i % 2 == 0 ? 'even' : 'odd'; ?> "> <td class="box"> <?php echo smaller_date($array[$i]['ag_timestamp_fmt']); ?> </td> <td class="box"> <?php echo HtmlInput::detail_action($array[$i]['ag_id'], $array[$i]['ag_ref'], 1); ?> </td> <td class="box"> <?php echo mb_substr(h($array[$i]['quick_code']), 0, 15); ?> </td> <td class="box cut"> <?php echo h($array[$i]['ag_title']); ?> </td> </tr> <?php }
echo $a_event[$i]['delta_days'], " " . _('jours'); } ?> </td> <td> <?php echo $a_event[$i]['str_date']; ?> <?php echo $a_event[$i]['ag_hour']; ?> </td> <td> <?php echo HtmlInput::detail_action($a_event[$i]["ag_id"], $a_event[$i]["str_name"]); ?> </td> <td> <?php echo h($a_event[$i]['ag_title']); ?> </td> </tr> <?php } ?> </table>