-- 1 ---
SELECT * FROM `p_prestationactes`
WHERE  numeroFeuilleMaladie="23985"

UPDATE  `p_prestationactes`
SET codePrestataire="CE0236"
WHERE  numeroFeuilleMaladie="23985"


-- 2-- 
SELECT * FROM p_facture
WHERE  YEAR(LEFT(dateSysteme,10))=2022
AND numeroFeuilleMaladie="24369"
AND id=30734

-- 4--

SELECT *  FROM `p_feuillemaladie`
WHERE numeroFeuilleMaladie="23985"

				
WHERE `idPrestationactes`=62203


SELECT * FROM `p_prestationmedicaments`
WHERE `idPrestationactes`=70384


UPDATE  `p_feuillemaladie`
SET `numeroBonConsultation`="24583",`numeroBonOrdonnance`="24583"
WHERE numeroFeuilleMaladie="23985"

SELECT * FROM `p_prestationactes`   -- CE0236   -- PR0470
WHERE codeActe='A00000003'
AND id=6855


--- 25--

INSERT INTO p_feuillemaladie (codeSociete, codePrestataire,numeroFeuilleMaladie,idPolice,idAdherent,idBeneficiaire, numeroBeneficiaire, 
	dateConsultation,codeRaisonConsultation,codeAffection,dateSurvenance,codeMedecin,numeroBonConsultation, 
	numeroBonOrdonnance,numeroBonHospitalisation,numeroBonOptique,numeroBonExamen,numeroBonKine,observations, 
	fraisReel,montantTm,montantArembourser,fraisExclu,fraisRetenu,montantRembourse,tiersPayant,montantFranchise, 
	dateSysteme,numeroPrescription,numeroOptique,numeroExamen,numeroPrescriptionKine,codeUtilisateur, 
	facture,userFacturation,dateFinHospit,tm,numeroDerogation,numeroDerogationFinger,hospitalisation, 
	motifHospitalisation,miseEnObservation,motifMiseEnObservation,numeroChambre, 
	chirurgie,fregle,numeroBonConsultationAnc,numeroBonOrdonnanceAnc,idFactureFeuille,medecinManquant, 
	noPrescription,modeSaisieFeuille,sansBon,fraisAssure,user_id_substitut,maladieChronique,codeMaternite, 
	motifExamen,motifSeance,motifOptique,facPartiel,codeReferencement,dateReferencement,prixBase,depassement, 
	fraisReelBase, optionHospitalisation)
VALUES
	('vitalis','PR0730','27677','135','1571','4381','0135001801','2022-05-18','NAT', 
	'000','2022-05-18', 'ME9553','28262' ,'28262'
	,'0','0','0','0','', '7890','1578','6312','1475','6312','0', 
'1','0','2022-05-18 16:23:08', '0','0', '0','0','pazito755','1','ina','','20','0','0','0','', 
'0','','','0','0','0','0','','','0','0','0','1578','0', '0','0','','','', '', 
'','','0','0','0','');
