Prepravljam skipte 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.ph p on line 256
Notice: Undefined index: pdv1 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.ph p on line 287
Notice: Undefined index: pdv2 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.ph p on line 288
Notice: Undefined index: pdv3 in C:\xampp\htdocs\finmap\lib\izvjestaji\ajax_izv4.ph p on line 289
<?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>
Linearni mod
