Edit File: dobici.php

<?php
$fonddobitaka = 0;
$fond = 0;
$jackpot = 0;
$prenosfonda = 0;
$datum = date("d.m.y");  
 require_once('../configdb.php'); 
  //$Red = $dgsripts[p1];
  //echo $Red;
$con=mysqli_connect($configdb['db_server'],$configdb['db_korisnik'],$configdb['db_lozinka'],$configdb['db_ime']);
// Check connection
if (mysqli_connect_errno())
  {
  echo "Ne mogu se konektovati na bazu. " . mysqli_connect_error();
  }

$kolo = 0;
$result = mysqli_query($con,"SELECT * FROM kombinacije where zavrseno =0");
while($row = mysqli_fetch_array($result))
{

$kolo = $row['oznakakola'];
		
	}

$idfirme = 0;
$procenatigraci = 0;
$uplateuk = 0;
$maksdob = 0;
$result = mysqli_query($con,"SELECT * FROM firme");
while($row = mysqli_fetch_array($result))
{

$idfirme = $row['idfirme'];
 $result1 = mysqli_query($con,"SELECT * FROM podesavanja where idfirme = '$idfirme'");
while($row = mysqli_fetch_array($result1))
{
$maksdob = $row['maksimalandobitak'];
$mindob = $row['mindobitak'];
$prenosfonda = $row['ostatakfondaseprenosi'];
$procenatigraci = 100 - $row['pporez'] -  $row['pprogram'] - $row['pvlasnik'] - $row['pjackpot']  - $row['pkladjenje'];	
$pjackpot = $row['pjackpot'] ;
}

$result34 = mysqli_query($con,"SELECT sum(uplata) as sumuplate FROM tiketi_osnovna where idfirme = '$idfirme' and kolo = '$kolo'");
 while($row = mysqli_fetch_array($result34)){ 
 $uplateuk = $row['sumuplate'];
}

if ($uplateuk > 0){
		$jackpot = $uplateuk * $pjackpot /100;
	$sql="insert ignore  INTO `jackpot`( `idfirme`, `uplata`, `isplata`, `saldo`, `datum`, `kolo`) VALUES ('$idfirme','$jackpot','0','$jackpot','$datum','$kolo')";
	 if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
	
	$jackpotdobitak = 0;
	
	$result = mysqli_query($con,"SELECT sum(saldo) as iznos FROM jackpot where idfirme = '$idfirme'");
while($row = mysqli_fetch_array($result))
{

$jackpotdobitak = $row['iznos'];
		}
	if ($prenosfonda == 1){	
		
			$result = mysqli_query($con,"SELECT sum(saldo) as iznosf FROM fond where idfirme = '$idfirme'");
while($row = mysqli_fetch_array($result))
{

$fond = $row['iznosf'];
		}
	}
		
	
	
	
$dobitak = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

$ukkoeficijent = 465;
$fonddobitaka = $uplateuk * $procenatigraci/100;
if ($prenosfonda == 1){
	
	if ($fond > 0){
	$dobitnidio = (($uplateuk * $procenatigraci/100)+ $fond)/$ukkoeficijent ;
	}else{
	$dobitnidio = ($uplateuk * $procenatigraci/100)/$ukkoeficijent;	
	}
	
	
	
	
	
}else{
	$dobitnidio = ($uplateuk * $procenatigraci/100)/$ukkoeficijent;
	}
	
	for ($d = 1; $d <= 30; $d++){
	$dobitak[$d] = $dobitnidio * (31 - $d);	
	}
	
	
	
	
	
	
	$brojdobitnihvrste = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);
	$dobitakvrste = array(0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

for ($i = 1; $i <= 30; $i ++){
	$zapis = "v" . $i;
    $result3 = mysqli_query($con,"SELECT * FROM tiketi_osnovna where idfirme = '$idfirme' and kolo = '$kolo' and $zapis = '1' ");
	$brojdobitnihvrste[$i] = mysqli_num_rows($result3);

if($brojdobitnihvrste[$i] > 1){
		$dobitakvrste[$i] = $dobitak[$i] / $brojdobitnihvrste[$i] ;
		}else{
		$dobitakvrste[$i] = $dobitak[$i];
		}

}
	
	
$result4 = mysqli_query($con,"SELECT * FROM tiketi_osnovna where idfirme = '$idfirme' and kolo = '$kolo' and dobitni = '1' ");
		
while($row = mysqli_fetch_array($result4))
{
$unibroj = $row['unibroj'];	
	$dobitaktiketa = 0;
for ($p = 1; $p <= 30; $p++){	
$zapis1 = "v" . $p;
	if ($row[$zapis1] == 1){
	$dobitaktiketa	= $dobitaktiketa + $dobitakvrste[$p];
	}
	
}

if ($row['dobitniboja'] == 1) {
		$dobitaktiketa	= $dobitaktiketa + $row['uplata'] * 7.5;
		}
		if ($row['dobitnikladjenje'] == 1) {
		$dobitaktiketa	= $dobitaktiketa + $row['uplata'] * 1.9;
		}
	    if ($row['jackpot'] == 1) {
		$dobitaktiketa	= $dobitaktiketa + $jackpotdobitak;
				$sql="insert ignore  INTO `jackpot`( `idfirme`, `uplata`, `isplata`, `saldo`, `datum`, `kolo`) VALUES ('$idfirme','0','$jackpotdobitak','0-$jackpotdobitak','$datum','$kolo')";
	 if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
			
			
			
		}

if ($maksdob > 0 and $dobitaktiketa > $maksdob ) {
		
		$dobitaktiketa = $maksdob;
	}
	
		if ($mindob > 0 and $dobitaktiketa < $mindob ) {
		
		$dobitaktiketa = $mindob;
	}

mysqli_query($con,"update ignore tiketi_osnovna SET dobitak = $dobitaktiketa  WHERE unibroj = '$unibroj'");
	
	
}	
	
//odrediti koliko je ostalo za fonda
if ($prenosfonda == 1){
	
	$ukupnodobici = 0;
	
	 $result5 = mysqli_query($con,"SELECT sum(dobitak) as dobitak FROM tiketi_osnovna where idfirme = '$idfirme' and kolo = '$kolo'");
while($row = mysqli_fetch_array($result5))
{
$ukupnodobici = $row['dobitak'];
} 
$ostatakkola = 	$fonddobitaka  - $ukupnodobici;
if ($ostatakkola > 0){

$sql="insert ignore  INTO `fond`( `idfirme`, `uplata`, `isplata`, `saldo`, `datum`, `kolo`) VALUES ('$idfirme','$ostatakkola','0','$ostatakkola','$datum','$kolo')";
	 if (!mysqli_query($con,$sql))
  {
  die('Error: ' . mysqli_error($con));
  }
}
//insert ignore  INTO `analitika`(`ID`, `uplate`, `fonddobitaka`, `isplate`) VALUES ([value-1],[value-2],[value-3],[value-4])

}

} //if uplate > 0
	} //kraj firme

Back