$where = $where . " and atskaites_veids = " . "'" . $a_veids . "'";
}
if ($piegadatajs != '0') {
$where = $where . " and piegadatajs = {$piegadatajs}";
}
if ($registrator != 0) {
$where = $where . " and lietotajs_veidoja = " . "'" . $registrator . "'";
}
if ($vieta != '0' && $vieta != '') {
$where = $where . " and vieta = " . "'" . $vieta . "'";
}
if ($date_from != 0) {
$where = $where . " and datums_uzmer >= '" . sqldate(datums($date_from)) . " 00:00'";
}
if ($date_to != 0) {
$where = $where . " and datums_uzmer <= '" . sqldate(datums($date_to)) . " 23:59'";
}
$query = "SELECT * FROM g_registrs WHERE " . $where . " AND opcija != 'D' ORDER BY id ASC";
if ($SortDouble === "on") {
$sub_query = "SELECT pavadzime FROM g_registrs WHERE " . $where . " AND opcija != 'D' GROUP BY pavadzime having count(pavadzime)> 1";
$sub_query_SQL = mysql_query($sub_query);
while ($sub_query_temps = mysql_fetch_assoc($sub_query_SQL)) {
$sub_query_temp[] = $sub_query_temps;
}
}
?>
<table border="0" align="center">
<font size="10">
<tr bgcolor=CCFFCC>
<td align="center">ID</td>
<td align="center">Atskaites veids</td>
function laika_ievadisana($laiks_no, $laiks_lidz, $laiks_noh, $laiks_nom, $laiks_lidzh, $laiks_lidzm)
{
if ($laiks_no && $laiks_lidz) {
if (datums($laiks_no) != -1 && datums($laiks_lidz) != -1) {
if (datums_laiks($laiks_no, $laiks_noh, $laiks_nom) < datums_laiks($laiks_lidz, $laiks_lidzh, $laiks_lidzm)) {
return true;
}
}
}
if (!$laiks_no && !$laiks_lidz) {
return true;
}
}
