Prepravljam skripte mysql u mysqli i javlja mi greške može li neko pomoći:
Notice: Undefined index: pdv7 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.php on line 199
Notice: Undefined index: pdv1 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.php on line 210
Notice: Undefined index: pdv2 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.php on line 211
Notice: Undefined index: pdv3 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.php on line 212
<?php
if (session_status() == PHP_SESSION_NONE) {
session_start();
}
include_once("../../class/application_core.php");
function calculateItem($item, &$sumItems) {
$sumItems['br_fakture'] = $item['nalobr'];
$sumItems['br_dokument'] = $item['br_dokument'];
$sumItems['id_fakt'] = $item['id_fakt'];
$sumItems['nalobr'] = $item['nalobr'];
$sumItems['vs'] = $item['vs'];
$sumItems['uvoz'] = $item['uvoz'];
$sumItems['nam'] = $item['nam'];
$sumItems['sa_pdv'] = $item['analitika1'];
$sumItems['datum'] = $item['datum'];
if ($item['oznaka'] == '1') {
$sumItems['sa_pdv'] = $item['analitika1'];
}
$sifra_konta = $item['konto'];
$s = "SELECT automat FROM automati WHERE naziv = '$sifra_konta'";
$q = sqlQuery($s);
$automat = $q[0]['automat'];
if (($automat == 'zalihem') && ($item['oznaka'] == '4')){
$sumItems['sa_pdv'] = $item['analitika2'];
}
if ($sumItems['sa_pdv'] != 0) {
if (($item['nam'] == 1) && ($item['oznaka'] == '2')) {
$sumItems['pdv5'] = $item['analitika2'];
$sumItems['pdv8'] = $item['analitika2'];
}
if ($item['oznaka'] == '1') {
$komitentId = intval($item['to']);
$komitentQuery = "
SELECT
*
FROM
komitenti
WHERE
komitenti.komitent = $komitentId
LIMIT
1;
";
$komitentResult = sqlQuery($komitentQuery);
$komitentData = $komitentResult[0];
$sumItems['naziv_dobavljaca'] = $komitentData['naziv'];
$sumItems['pdv_broj'] = $komitentData['pdv'];
}
}
}
$needLoop = FALSE;
if (!(empty($_GET))) {
$korisnik = $_GET['id_korisnik'];
$datumOd = $_GET['f1_datumod'];
$datumDo = $_GET['f1_datumdo'];
$obrac = $_GET['f1_obrac'];
$uvoz = $_GET['f1_uvoz'];
if (isset($_GET['get_izv']) && ($_GET['get_izv'] == 1)) {
$query = "
SELECT
*
FROM
nalo
WHERE
nalo.sifkor = $korisnik AND (nalo.vs IN (125, 128, 160, 161, 181, 190, 191)) AND (nalo.uvoz IN (1, 2, 3, 4, 5, 6)) AND (nalo.nam IN (1, 2, 3, 4, 5, 6)) AND (date_format(datum, '%d.%m.') != '01.01.')
";
$query .= " ORDER BY nalo.sifkor, nalo.datum, nalo.nalobr, nalo.vs, nalo.id_fakt, nalo.id_nalo, nalo.br_dokument ASC";
$result = sqlQuery($query);
$userQuery = "
SELECT
*
FROM
korisnik
WHERE
korisnik.sifra = $korisnik
LIMIT
1;
";
$userResult = sqlQuery($userQuery);
$needLoop = TRUE;
}
}
?>
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<meta content="bs-latn-ba" http-equiv="Content-Language">
<style type="text/css">
body{font-family:Arial, Helvetica, sans-serif; font-size:12px}
table{font-family:Arial, Helvetica, sans-serif; font-size:12px; width:95%}
table th{border-bottom:1px black solid}
</style>
</head>
<body>
<div style="width:1000px; border:0px gray solid" align="center">
<strong>KNJIGA IZLAZNIH FAKTURA</strong>
<br />
<span><b><?php print(date("d.m.Y.").' god.'); ?></span>
<?php if ($needLoop): ?>
<?php $userData = $userResult[0]; ?>
<table width="100%">
<tr>
<td width="50%"><b><?php echo $userData['naziv']; ?></td>
<td width="50%" align="right"><b><?php print('ŽIRO RAČUN: '.$userData['ziro']); ?></td>
</tr>
<tr>
<td colspan="2"><div style="height:3px; border-bottom:1px solid #000000;"></div></td>
</tr>
</table>
<br /><br />
<table>
<?php
$i = 0;
$brojDokumenta = '';
$br_dokument = '';
$vs = '';
$nalobr = '';
$konto = '';
$id_fakt = '';
$finalItems = array();
foreach($result as $rec => $line) {
if (($br_dokument != $line['br_dokument']) OR ($vs != $line['vs']) OR ($br_fakture != $line['nalobr']) OR ($nalobr != $line['nalobr']) OR ($id_fakt != $line['id_fakt'])){
$brojDokumenta = $line['nalobr'];
$nalobr = $line['nalobr'];
$br_fakture = $line['nalobr'];
$id_fakt = $line['id_fakt'];
$br_dokument = $line['br_dokument'];
$vs = $line['vs'];
$datum = $line['datum'];
$uvoz = $line['uvoz'];
$nam = $line['nam'];
$i++;
$finalItems[$i] = array();
}
calculateItem($line, $finalItems[$i]);
}
$i = 1;
$suma1 = 0;
$suma2 = 0;
$suma3 = 0;
$suma4 = 0;
$suma5 = 0;
$suma6 = 0;
$suma7 = 0;
$suma8 = 0;
$suma9 = 0;
foreach ($finalItems as $item):
$value1 = $item['sa_pdv'];
if ($value1 != 0) {
if ($item['nam'] == 1) {
$item['pdv4'] = $item['sa_pdv'] - $item['pdv5'];
}
if ($item['nam'] == 3) {
$item['pdv4'] = $item['sa_pdv'] - $item['pdv5'];
}
if ($item['nam'] == 5) {
$item['pdv6'] = $item['sa_pdv'] - $item['pdv7'];
}
if (($item['nam'] == 4) AND ($item['uvoz'] == 4)) {
$value1 = 0;
}
?>
<?php
$suma1 += $value1;
$suma2 += $item['pdv1'];
$suma3 += $item['pdv2'];
$suma4 += $item['pdv3'];
$suma5 += $item['pdv4'];
$suma6 += $item['pdv5'];
$suma7 += $item['pdv6'];
$suma8 += $item['pdv7'];
$suma9 += $item['pdv8'];
$i++;
}
endforeach;
?>
</table>
<br /><br />
<?php endif; ?>
</div>
</body>
</html>