Edit File: dobici1.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'];
		}
	}

$koeficijentvrste = array(0,10000,7500,5000,2500,1000,500,300,200,150,100,90,80,70,60,50,40,30,25,20,15,10,9,8,7,6,5,4,3,2,1);

$fonddobitaka = $uplateuk * $procenatigraci/100;

$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;
	$osnovica = $row['osnovicadobitka']; 
	
for ($p = 1; $p <= 30; $p++){	
$zapis1 = "v" . $p;
	if ($row[$zapis1] == 1){
	$dobitaktiketa	= $dobitaktiketa + $osnovica * $koeficijentvrste[$p];
	}
	
}

if ($row['dobitniboja'] == 1) {
		$dobitaktiketa	= $dobitaktiketa + $osnovica * 7.5;
		}
		if ($row['dobitnikladjenje'] == 1) {
		$dobitaktiketa	= $dobitaktiketa + $osnovica * 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));
  }
//}

}

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

Back