1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
|
<?php
if(isset($_POST['honoraires_e']))
{
$honoraires_e=htmlspecialchars($_POST['honoraires_e']);
if($_POST['honoraires_e']!=1)
{
$req=$bdd->prepare('select * from fact_devises where ID_DEVISES=?');
$req->execute(array($_POST['honoraires_e']));
$d=$req->fetch();
$budget=$budget * $d['COUR_DEVISE'];
$req->closeCursor();
}
}
if(isset($_POST['addmission']))
{
$req=$bdd->prepare('insert into missiontemp(nom_client,ID,Nom_simplifie,Client_facturation,groupe_appartenance,Maison_mere,LCMM,CAC_mm,adresse,
complement_adresse,code_postal,ville,Pays,Entite_fact,Add_fact,contact,forme_juridique,Capital_Social,N_R_C,Societe_cotee,S_N_C,client_sec,
mission_ref,BR_reseau,BR_pays,BR_ville,honoraires_e,devise,date_cloture,activite,nmondat,nm,dnm,cabinet_ref,refpays,
nomination,ns1ans,n3ans,annee1,annee2,annee3,acrr,cabinet_co_cac,
ass_co_cac,MC1,MC2,MC3,CI1,CI2,CI3,SC1,SC2,SC3,Code_ISIN,Gest_Fond,FDF,t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,
t14,t15,t16,t17,t18,t19,q1,q2,q3,q4,q60,q61,q62,q45,c7,q5,q6,q7,c8,c9,q8,q9,q10,q11,q12,q13,q14,A15,
A16,A17,A18,A23,A24,A25,A26,A27,A19,A22,A20,c1,q50,q51,q52,q21,
q25,q26,c2,q29,q30,q31,A21,
a1,d1,q32,q33,q34,c3,c4,a2,d2,q35,q36,
c5,c6,a,d,ass,at,m,sp
)
values(
?,\'\',?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?,?,
?,?,?,?,?,?,?,?,?,?,?,?,?
)');
$req->execute(array($_POST['nom_client'],$_POST['Nom_simplifie'],$_POST['Client_facturation'],
$_POST['groupe_appartenance'],$_POST['Maison_mere'],$_POST['LCMM'],$_POST['CAC_mm'],$_POST['adresse'],$_POST['complement_adresse'],$_POST['code_postal'],$_POST['ville'],
$_POST['Pays'],$_POST['Entite_fact'],$_POST['Add_fact'],$_POST['contact'],$_POST['forme_juridique'],$_POST['Capital_Social'],$_POST['N_R_C'],$_POST['Societe_cotee'],
$_POST['S_N_C'],$_POST['client_sec'],$_POST['mission_ref'],$_POST['BR_reseau'],$_POST['BR_pays'],$_POST['BR_ville'],$_POST['honoraires_e'],$_POST['devise'],
$_POST['date_cloture'], $_POST['activite'],$_POST['nmondat'],$_POST['nm'],$_POST['dnm'],$_POST['cabinet_ref'],
$_POST['refpays'],$_POST['nomination'],$_POST['ns1ans'],$_POST['n3ans'],$_POST['annee1'],
$_POST['annee2'],$_POST['annee3'],$_POST['acrr'],$_POST['cabinet_co_cac'],
$_POST['ass_co_cac'],$_POST['MC1'],$_POST['MC2'],$_POST['MC3'],$_POST['CI1'],$_POST['CI2'],$_POST['CI3'],$_POST['SC1'],$_POST['SC2'],$_POST['SC3'],
$_POST['Code_ISIN'],$_POST['Gest_Fond'],$_POST['FDF'],
$_POST['t1'],$_POST['t2'],$_POST['t3'],$_POST['t4'],$_POST['t5'],$_POST['t6'],$_POST['t7'],$_POST['t8'],$_POST['t9'],$_POST['t10'],$_POST['t11'],$_POST['t12'],
$_POST['t13'],$_POST['t14'],$_POST['t15'],$_POST['t16'],$_POST['t17'],$_POST['t18'],$_POST['t19'],$_POST['q1'],$_POST['q2'],$_POST['q3'],
$_POST['q4'],$_POST['q60'],$_POST['q61'],$_POST['q62'],$_POST['q45'],$_POST['c7'],$_POST['q5'],$_POST['q6'],$_POST['q7'],$_POST['c8'],$_POST['c9'],$_POST['q8'],$_POST['q9'],
$_POST['q10'],$_POST['q11'],$_POST['q12'],$_POST['q13'],$_POST['q14'],$_POST['A15'],$_POST['A16'],$_POST['A17'],$_POST['A18'],$_POST['A23'],$_POST['A24'],$_POST['A25'],
$_POST['A26'],$_POST['A27'],$_POST['A19'],$_POST['A22'],$_POST['A20'],
$_POST['c1'],$_POST['q50'],$_POST['q51'],$_POST['q52'],$_POST['q21'],
$_POST['q25'],$_POST['q26'],
$_POST['c2'],$_POST['q29'],$_POST['q30'],$_POST['q31'],$_POST['A21'],
$_POST['a1'],$_POST['d1'],$_POST['q32'],$_POST['q33'],$_POST['q34'],
$_POST['c3'],$_POST['c4'],$_POST['a2'],
$_POST['d2'],$_POST['q35'],$_POST['q36'],
$_POST['c5'],$_POST['c6'],
$_POST['a'],$_POST['d'],$_POST['ass'],$_POST['at'],$_POST['m'],$_POST['sp']));
header("location:index.php?action=4&id=26®");
}
elseif(isset($_POST['editmission']))
{
$req=$bdd->prepare('update missiontemp set nom_client=?,Nom_simplifie=?,Client_facturation=?,groupe_appartenance=?,Maison_mere=?,LCMM=?,CAC_mm=?,adresse=?,
complement_adresse=?,code_postal=?,ville=?,Pays=?,Entite_fact=?,Add_fact=?,contact=?,forme_juridique=?,Capital_Social=?,N_R_C=?,Societe_cotee=?,
S_N_C=?,client_sec=?,mission_ref=?,BR_reseau=?,BR_pays=?,BR_ville=?,honoraires_e=?,devise=?,date_cloture=?,activite=?,nmondat=?,nm=?,dnm=?,cabinet_ref=?,refpays=?,
nomination=?,ns1ans=?,n3ans=?,annee1=?,annee2=?,annee3=?,acrr=?,cabinet_co_cac=?,
ass_co_cac=?,MC1=?,MC2=?,MC3=?,CI1=?,CI2=?,CI3=?,SC1=?,SC2=?,SC3=?,Code_ISIN=?,Gest_Fond=?,FDF=?,
t1=?,t2=?,t3=?,t4=?,t5=?,t6=?,t7=?,t8=?,t9=?,t10=?,t11=?,t12=?,t13=?,t14=?,t15=?,t16=?,t17=?,t18=?,t19=?,
q1=?,q2=?,q3=?,q4=?,q60=?,q61=?,q62=?,q45=?,c7=?,q5=?,q6=?,q7=?,c8=?,c9=?,q8=?,q9=?,q10=?,q11=?,q12=?,q13=?,q14=?,A15=?,
A16=?,A17=?,A18=?,A23=?,A24=?,A25=?,A26=?,A27=?,A19=?,A22=?,A20=?,c1=?,q50=?,q51=?,q52=?,q21=?,
q25=?,q26=?,c2=?,q29=?,q30=?,q31=?,A21=?,
a1=?,d1=?,q32=?,q33=?,q34=?,c3=?,c4=?,a2=?,d2=?,q35=?,q36=?,
c5=?,c6=?,a=?,d=?,ass=?,at=?,m=?,sp=? where ID=?');
$req->execute(array($_POST['nom_client'],$_POST['Nom_simplifie'],$_POST['Client_facturation'],
$_POST['groupe_appartenance'],$_POST['Maison_mere'],$_POST['LCMM'],$_POST['CAC_mm'],$_POST['adresse'],$_POST['complement_adresse'],$_POST['code_postal'],$_POST['ville'],
$_POST['Pays'],$_POST['Entite_fact'],$_POST['Add_fact'],$_POST['contact'],$_POST['forme_juridique'],$_POST['Capital_Social'],$_POST['N_R_C'],$_POST['Societe_cotee'],
$_POST['S_N_C'],$_POST['client_sec'],$_POST['mission_ref'],$_POST['BR_reseau'],$_POST['BR_pays'],$_POST['BR_ville'],$_POST['honoraires_e'],$_POST['devise'],$_POST['date_cloture'],
$_POST['activite'],$_POST['nmondat'],$_POST['nm'],$_POST['dnm'],$_POST['cabinet_ref'],
$_POST['refpays'],$_POST['nomination'],$_POST['ns1ans'],$_POST['n3ans'],$_POST['annee1'],
$_POST['annee2'],$_POST['annee3'],$_POST['acrr'],$_POST['cabinet_co_cac'],
$_POST['ass_co_cac'],$_POST['MC1'],$_POST['MC2'],$_POST['MC3'],$_POST['CI1'],$_POST['CI2'],$_POST['CI3'],$_POST['SC1'],$_POST['SC2'],$_POST['SC3'],
$_POST['Code_ISIN'],$_POST['Gest_Fond'],$_POST['FDF'],
$_POST['t1'],$_POST['t2'],$_POST['t3'],$_POST['t4'],$_POST['t5'],$_POST['t6'],$_POST['t7'],$_POST['t8'],$_POST['t9'],$_POST['t10'],$_POST['t11'],$_POST['t12'],
$_POST['t13'],$_POST['t14'],$_POST['t15'],$_POST['t16'],$_POST['t17'],$_POST['t18'],$_POST['t19'],$_POST['q1'],$_POST['q2'],$_POST['q3'],
$_POST['q4'],$_POST['q60'],$_POST['q61'],$_POST['q62'],$_POST['q45'],$_POST['c7'],$_POST['q5'],$_POST['q6'],$_POST['q7'],$_POST['c8'],$_POST['c9'],$_POST['q8'],$_POST['q9'],
$_POST['q10'],$_POST['q11'],$_POST['q12'],$_POST['q13'],$_POST['q14'],$_POST['A15'],$_POST['A16'],$_POST['A17'],$_POST['A18'],$_POST['A23'],$_POST['A24'],$_POST['A25'],
$_POST['A26'],$_POST['A27'],$_POST['A19'],$_POST['A22'],$_POST['A20'],
$_POST['c1'],$_POST['q50'],$_POST['q51'],$_POST['q52'],$_POST['q21'],
$_POST['q25'],$_POST['q26'],
$_POST['c2'],$_POST['q29'],$_POST['q30'],$_POST['q31'],$_POST['A21'],
$_POST['a1'],$_POST['d1'],$_POST['q32'],$_POST['q33'],$_POST['q34'],
$_POST['c3'],$_POST['c4'],$_POST['a2'],
$_POST['d2'],$_POST['q35'],$_POST['q36'],
$_POST['c5'],$_POST['c6'],
$_POST['a'],$_POST['d'],$_POST['ass'],$_POST['at'],$_POST['m'],$_POST['sp'],$_POST['ID']));
$req->closeCursor();
header("location:index.php?action=4&id=26&edit");
} |
Partager