function printValue($val, $h, $css)
{
$align = '';
// Maybe formalise 'time_length' filter, but check SQL pre-filter also
if ($h['filter_special'] == 'time_length') {
// $val = format_time_interval_prefs($val);
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
} elseif ($h['description'] == 'time_input_length') {
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
}
switch ($h['filter']) {
case 'date':
// we leave the date in 0000-000-00 00:00:00 format
break;
case 'currency':
if ($val) {
$val = format_money($val);
} else {
$val = 0;
}
break;
case 'number':
$align = 'align="right"';
if (!$val) {
$val = 0;
}
break;
}
if (is_numeric($val)) {
echo $val . ", ";
} else {
// escape " character (csv)
$val = str_replace('"', '""', $val);
echo '"' . $val . '" , ';
}
}
function printValue($val, $h, $css)
{
$align = '';
// Maybe formalise 'time_length' filter, but check SQL pre-filter also
if ($h['filter_special'] == 'time_length') {
// $val = format_time_interval_prefs($val);
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
} elseif ($h['description'] == 'time_input_length') {
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
}
switch ($h['filter']) {
case 'date':
if ($val) {
$val = format_date($val, 'short');
}
break;
case 'currency':
if ($val) {
$val = format_money($val);
} else {
$val = 0;
}
break;
case 'number':
$align = 'align="right"';
if (!$val) {
$val = 0;
}
break;
}
echo '<td ' . $align . ' ' . $css . '>' . $val . "</td>\n";
}
function format_time_interval_prefs($time)
{
global $prefs;
$hours_only = $prefs['time_intervals_notation'] == 'hours_only';
return format_time_interval($time, $hours_only);
}
function printValue($val, $h, $css = '')
{
$xml = '<table:table-cell ';
$align = '';
$format = 'office:value-type="string"';
// Maybe formalise 'time_length' filter, but check SQL pre-filter also
if ($h['filter_special'] == 'time_length') {
// $val = format_time_interval_prefs($val);
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
} elseif ($h['description'] == 'time_input_length') {
$val = format_time_interval($val, true, '%.2f');
if (!$val) {
$val = 0;
}
}
switch ($h['filter']) {
case 'date':
if ($val) {
$val = format_date($val, 'short');
}
// not tested XXX
break;
case 'currency':
if ($val) {
$val = format_money($val);
} else {
$val = 0;
}
break;
case 'number':
if (!$val) {
$val = 0;
}
$align = 'align="right"';
// not used
$format = 'office:value-type="float" office:value="' . $val . '"';
break;
}
$xml .= $format . '>';
$xml .= '<text:p>' . $val . '</text:p>';
$xml .= '</table:table-cell>';
fwrite($this->fcontent, $xml);
}
$list_pos = $_REQUEST['list_pos'];
}
if ($list_pos >= $number_of_rows) {
$list_pos = 0;
}
// Position to the page info start
if ($list_pos > 0) {
if (!lcm_data_seek($result, $list_pos)) {
lcm_panic("Error seeking position {$list_pos} in the result");
}
}
// Show page of the list
for ($i = 0; $i < $prefs['page_rows'] && ($row = lcm_fetch_array($result)); $i++) {
echo "\t<tr>";
echo '<td class="tbl_cont_' . ($i % 2 ? 'dark' : 'light') . '">' . format_date($row['start_time'], 'short') . '</td>';
echo '<td class="tbl_cont_' . ($i % 2 ? 'dark' : 'light') . '">' . ($prefs['time_intervals'] == 'absolute' ? format_date($row['end_time'], 'short') : format_time_interval(strtotime($row['end_time']) - strtotime($row['start_time']), $prefs['time_intervals_notation'] == 'hours_only')) . '</td>';
echo '<td class="tbl_cont_' . ($i % 2 ? 'dark' : 'light') . '">' . _Tkw('appointments', $row['type']) . '</td>';
echo '<td class="tbl_cont_' . ($i % 2 ? 'dark' : 'light') . '">' . '<a href="app_det.php?app=' . $row['id_app'] . '" class="content_link">' . $row['title'] . '</a></td>';
// [ML] removed, not very useful.
// echo '<td class="tbl_cont_' . ($i % 2 ? 'dark' : 'light') . '">'
// . format_date($row['reminder'], 'short') . '</td>';
echo "</tr>\n";
}
show_list_end($list_pos, $number_of_rows);
}
echo "</p>\n";
if ($author_session['id_author'] == $author) {
echo '<p><a href="edit_app.php?app=0" class="create_new_lnk">' . _T('app_button_new') . '</a></p>';
}
break;
//
function show_listfu_item($item, $cpt, $screen = 'general')
{
global $prefs;
echo "<tr>\n";
// Id case
if ($screen == 'case') {
echo '<td valign="top"><abbr title="' . $item['title'] . '">' . $item['id_case'] . '</abbr></td>';
} else {
echo '<td valign="top">' . $item['id_followup'] . '</abbr></td>';
}
// Start date
echo '<td valign="top">' . format_date($item['date_start'], 'short') . '</td>';
// Time
echo '<td valign="top">';
$fu_date_end = vider_date($item['date_end']);
if ($prefs['time_intervals'] == 'absolute') {
if ($fu_date_end) {
echo format_date($item['date_end'], 'short');
}
} else {
$fu_time = $fu_date_end ? strtotime($item['date_end']) - strtotime($item['date_start']) : 0;
echo format_time_interval($fu_time, $prefs['time_intervals_notation'] == 'hours_only');
}
echo '</td>';
// Author initials
if ($screen != 'author') {
echo '<td valign="top">' . get_person_initials($item) . '</td>';
}
// Type
echo '<td valign="top">' . _Tkw('followups', $item['type']) . '</td>';
// Description
$cut_fu = isset($_REQUEST['more_fu_desc']) && $_REQUEST['more_fu_desc'] ? false : true;
$short_description = get_fu_description($item, $cut_fu);
if ($item['hidden'] == 'Y') {
$short_description .= ' <img src="images/jimmac/stock_trash-16.png" ' . 'height="16" width="16" border="0" ' . 'title="' . _T('fu_info_is_deleted') . '" ' . 'alt="' . _T('fu_info_is_deleted') . '" />';
}
echo '<td valign="top">';
echo '<a href="fu_det.php?followup=' . $item['id_followup'] . '" class="content_link">' . $short_description . '</a>';
echo '</td>';
echo "</tr>\n";
}
