<?php
header('Content-type: application/json');
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type"); 
$link = mysqli_connect("localhost", "invoices", "9rhJvEkV15jAhJD","invoices") or die("Impossible de se connecter : " . mysqli_error());
if (!$link) { 
    die('Could not connect to MySQL: ' . mysql_error()); 
}  
//Suppression Service
if ($_POST['r_facture']) {
	$reponse = "delete from detail_devis where ref_devis = '$_POST[r_facture]' and ref_as = '$_POST[ref_service]';";
	mysqli_query($link,$reponse);
	echo  (true);
}else if($_POST['r_devis']){
	$reponse = "delete from detail_devis where ref_devis = '$_POST[r_devis]' and ref_as = '$_POST[ref_service]';";
	mysqli_query($link,$reponse);
	echo  (true);
}else if($_POST['r_devis_bc']){
	$reponse = "delete from detail_bc where ref_bc = '$_POST[r_devis_bc]' and ref_as = '$_POST[ref_service]';";
	mysqli_query($link,$reponse);
	echo  (true);
}else if($_POST['r_devis_blf']){
	$reponse = "delete from detail_bl_fournisseur where ref_bl = '$_POST[r_devis_blf]' and ref_as = '$_POST[ref_service]';";
	mysqli_query($link,$reponse);
	echo  (true);
}else if($_POST['r_devis_bl']){
	$reponse = "delete from detail_bl where ref_bl = '$_POST[r_devis_bl]' and ref_as = '$_POST[ref_service]';";
	mysqli_query($link,$reponse);
	echo  (true);
}else if($_POST['r_article']){
	$check = "select * from detail_devis where ref_as = '$_POST[r_article]';";
	$exec =mysqli_query($link,$check);
	$row = mysqli_fetch_assoc($exec);
	if($row == null){
		  $reponse = "delete from article_service where id_art_serv = '$_POST[r_article]';";
		  mysqli_query($link,$reponse);
		// 
		echo (true); 
	}else{
		echo (false);
	} 
	
}

exit();
?>