Example #1
0
         }
         $bill_price = str_replace(".", ",", sprintf("%.05f", $bill_thisprice));
         if (@$_REQUEST["view"] == "csv") {
             echo "" . $bill_row["formatteddate"] . ";";
             echo "'" . $bill_dest . "';";
             echo "" . $disposition_text . ";";
             echo "" . sec_to_hours($bill_row["billsec"]) . ";";
             echo "" . str_replace(".", ",", $real_price_novat) . ";";
             echo "" . $bill_price . ";";
             echo "" . 100 * $vat_value . "\n";
         } else {
             echo "<tr class=\"" . $oddeven_class . "\">";
             echo "<td>" . htmlEnt($bill_row["formatteddate"]) . "</td>";
             echo "<td>" . htmlEnt($bill_dest) . "</td>";
             echo "<td>" . htmlEnt($disposition_text) . "</td>";
             echo "<td>" . htmlEnt(sec_to_hours($bill_row["billsec"])) . "</td>";
             echo "<td>" . $billing_currency . " " . htmlEnt($bill_price) . "</td>";
             echo "</td>\n";
             echo "</tr>\n";
         }
         //echo "<pre>"; print_r($bill_row); echo "</pre>";
     }
     if (@$_REQUEST["view"] != "csv") {
         echo "</tbody>\n";
         echo "</table><br />\n";
     }
 }
 if (@$_REQUEST["view"] != "csv") {
     $bill_sum_brutto = $bill_base + $bill_minutes_sum * $real_price;
     $bill_base_novat = round($bill_base / (1 + $vat_value), 5);
     echo "<table cellspacing=\"1\" class=\"phonebook\">\n";
Example #2
0
?>
:</th>
	<td class="r"><?php 
$where = trim($query_string);
if (strToUpper(subStr($where, 0, 5)) == 'WHERE') {
    $where = $where . ' AND `billsec` > 0';
} else {
    $where = 'WHERE `billsec` > 0';
}
$num_total_with_talktime = $CDR_DB->executeGetOne('SELECT COUNT(*) FROM `ast_cdr` ' . $where);
if ($num_total_with_talktime > 0) {
    echo sec_to_hours($sum_talktime / $num_total_with_talktime);
} else {
    echo '<i>', sec_to_hours(0), '</i>';
}
?>
</td>
</tr>
<tr>
	<th><?php 
echo __('Verbindungszeit');
?>
:</th>
	<td class="r"><?php 
echo sec_to_hours($sum_calltime);
?>
</td>
</tr>
</tbody>
</table>
Example #3
0
	<td class="r" style="min-width:6em;"><?php echo $num_total; ?></td>
</tr>
<tr>
	<th><?php echo __('Anrufdauer insgesamt'); ?>:</th>
	<td class="r"><?php echo sec_to_hours( $sum_talktime ); ?></td>
</tr>
<tr>
	<th><?php echo __('Anrufdauer im Durchschnitt'); ?>:</th>
	<td class="r"><?php
		
		$where = trim( $query_string );
		if (strToUpper(subStr($where,0,5)) == 'WHERE')
			$where = $where.' AND `billsec` > 0';
		else
			$where = 'WHERE `billsec` > 0';
		
		$num_total_with_talktime = $CDR_DB->executeGetOne( 'SELECT COUNT(*) FROM `ast_cdr` '. $where );
		
		if ($num_total_with_talktime > 0)
			echo sec_to_hours( $sum_talktime / $num_total_with_talktime );
		//else echo '<i>', __('keine Anrufe'), '</i>';
		else echo '<i>', sec_to_hours( 0 ), '</i>';

	?></td>
</tr>
<tr>
	<th><?php echo __('Verbindungszeit'); ?>:</th>
	<td class="r"><?php echo sec_to_hours( $sum_calltime ); ?></td>
</tr>
</tbody>
</table>