$d_big_qr = "SELECT SUM(ketebida) as d_big FROM bajikattuttate_aidudi WHERE prakar = '4' AND ojana = 'H' AND kalaparichaya = ".$samasyesreni['atadaaidi']." AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1')";
$d_big_rs = $conn->query($d_big_qr);
$d_big_ar = mysqli_fetch_array($d_big_rs);
$d_big = $d_big_ar['d_big'];
$d_small_qr = "SELECT SUM(ketebida) as d_small FROM bajikattuttate_aidudi WHERE prakar = '4' AND ojana = 'L' AND kalaparichaya = ".$samasyesreni['atadaaidi']." AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1')";
$d_small_rs = $conn->query($d_small_qr);
$d_small_ar = mysqli_fetch_array($d_small_rs);
$d_small = $d_small_ar['d_small'];
$d_odd_qr = "SELECT SUM(ketebida) as d_odd FROM bajikattuttate_aidudi WHERE prakar = '4' AND ojana = 'O' AND kalaparichaya = ".$samasyesreni['atadaaidi']." AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1')";
$d_odd_rs = $conn->query($d_odd_qr);
$d_odd_ar = mysqli_fetch_array($d_odd_rs);
$d_odd = $d_odd_ar['d_odd'];
$d_even_qr = "SELECT SUM(ketebida) as d_even FROM bajikattuttate_aidudi WHERE prakar = '4' AND ojana = 'E' AND kalaparichaya = ".$samasyesreni['atadaaidi']." AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1')";
$d_even_rs = $conn->query($d_even_qr);
$d_even_ar = mysqli_fetch_array($d_even_rs);
$d_even = $d_even_ar['d_even'];
$d_top = $d_big + $d_small + $d_odd + $d_even;
$d_num_qr = "SELECT SUM(menge * wettanzahl) as d_num FROM bajikattuttate_aidudi WHERE prakar = '4' AND (ojana != 'H' AND ojana != 'L' AND ojana != 'O' AND ojana != 'E') AND kalaparichaya = ".$samasyesreni['atadaaidi']." AND byabaharkarta NOT IN (SELECT balakedara FROM `demo` WHERE `sthiti`='1')";
$d_num_rs = $conn->query($d_num_qr);
$d_num_ar = mysqli_fetch_array($d_num_rs);
$d_num = $d_num_ar['d_num'];
© 2023 Quttera Ltd. All rights reserved.