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
| //Recherche des articles composant le colis dans F_NOMENCLAT (AR_Ref correspondant à la réference colis)
$lignes_colis="SELECT AR_Ref, NO_RefDet, NO_Qte, NO_Type, NO_Ordre FROM F_NOMENCLAT WHERE AR_Ref='".$ar_ref."'";
$colis=odbc_exec($connexion, $lignes_colis);
$ref_int_colis=odbc_result($colis,'NO_RefDet');
$qte_colis=odbc_result($colis,'NO_Qte');
$req_nomenc=odbc_exec($connexion, "SELECT * FROM F_ARTICLE WHERE AR_Ref='".$ref_int_colis."'");
$nomenc_design=odbc_result($req_nomenc, 'AR_Design');
$recup_poidsnet2 =odbc_result($req_nomenc, 'AR_PoidsNet');
$nomenc_poidsnet = $recup_poidsnet2 * 1000 * $qte_colis; //Récupération Poids Net
$calcul_dl_prixunitaire2=odbc_result($req_nomenc, 'AR_PrixVen');
$nomenc_prixunitaire=$calcul_dl_prixunitaire2 / 1.055; //Récupération Prix Unitaire HT pour TVA à 5.5
$nomenc_puttc = odbc_result($req_nomenc, 'AR_PrixVen');
$nomenc_montantht = $qte_colis * $nomenc_prixunitaire; //HT
$nomenc_montantttc = $qte_colis * $nomenc_puttc; //TTC
$i=0;
$requete_nomenclature="INSERT INTO F_DOCLIGNE
(DO_Domaine, DO_Type, CT_Num, DO_Piece, DO_Date, DL_DateBC, DL_Ligne, DO_Ref, DL_TNomencl, DL_TRemPied, DL_TRemExep, AR_Ref,
DL_Design, DL_Qte, DL_QteBL, DL_QteBC, DL_PoidsNet, DL_PoidsBrut, DL_Remise01REM_Valeur, DL_Remise01REM_Type, DL_Remise02REM_Valeur, DL_Remise02REM_Type,
DL_Remise03REM_Valeur, DL_Remise03REM_Type, DL_PrixUnitaire, DL_PUBC, DL_Taxe1, DL_TypeTaux1, DL_TypeTaxe1, DL_Taxe2, DL_TypeTaux2, DL_TypeTaxe2,
CO_No, AG_No1, AG_No2, DL_PrixRU, DL_CMUP, DL_MvtStock, DT_No, EU_Enumere, EU_Qte, DL_TTC, DE_No, DL_NoRef, DL_TypePL, DL_PUDevise, DL_PUTTC,
DO_DateLivr, CA_Num, DL_Taxe3, DL_TypeTaux3, DL_TypeTaxe3, DL_Frais, DL_Valorise, AR_RefCompose, DL_NonLivre, DL_MontantHT, DL_MontantTTC, DL_FactPoids,
DL_Escompte, DL_QtePL, DL_NoLInk, DL_QteRessource, COMMENTAIRE)
VALUES
('0','1','".$ct_num."','".$do_piece."','".$datejour."','".$datejour."','".$dl_ligne."','".$do_ref."','0','0','0','".$ref_int_colis."',
'".$nomenc_design."','".$qte_colis."','".$qte_colis."','0.00000','".$nomenc_poidsnet."','0.00000','0.00000','0','0.00000','0',
'0.00000','0','".$nomenc_prixunitaire."','0.00000','".$dl_taxe1."','0','0','0.00000','0','0',
'".$co_no."','0','0','".$dl_prixru."','".$dl_prixru."','0','0','".$eu_enumere."','".$qte_colis."','1','0','".$dl_noref."','0','0.00000','".$nomenc_puttc."',
'".$do_datelivr."','".$ca_num."','0.00000','0','0','0.00000','0','".$ar_ref."','0','".$nomenc_montantht."','".$nomenc_montantttc."','1',
'0','".$qte_colis."','0','0','".$commentaire."')"; |
Partager