| $kat | $lini | $jml | ".number_format($om,0,',','.')." |
".number_format($profit,2,'.',',')." |
");
$query_server = "SELECT tahun,bulan,toko,kategori,lini FROM om_kat_lini
WHERE tahun = '$tahun'
AND bulan = '$bulan'
AND toko = '$idToko'
AND lini = '$lini'";
if($stmt2 = mysqli_prepare($connPA,$query_server)){
mysqli_stmt_execute($stmt2);
mysqli_stmt_store_result($stmt2);
$cek2 = mysqli_stmt_num_rows($stmt2);
if($cek2 > 0){
//cek di pusat,jika ada data yg sama,maka di update
while(mysqli_stmt_fetch($stmt2)){
$queryUpdate = "UPDATE om_kat_lini SET unit = $jml, omset = $om, nett_profit = $profit
WHERE tahun = '$tahun'
AND bulan = '$bulan'
AND toko = '$idToko'
AND lini = '$lini'";
runQueryPA($queryUpdate);
}
}else{
// jika tdk ada data yg sama,masukkan data yang baru.
$queryins = "INSERT INTO om_kat_lini(tahun,bulan,toko,kategori,lini,unit,omset,nett_profit)
VALUES ('$tahun', '$bulan', '$idToko', '$kat', '$lini', $jml, $om, $profit)";
runQueryPA($queryins);
}
}
$jum += 1;
}
print("