1 2 3 4 5 6 7 8
|
$q3="INSERT INTO vtiger_inventoryproductrel (id, productid, sequence_no, quantity, listprice, product_name, tax1, type_cadeau) VALUES ('".$crmid."','".$_POST['cadeauRDV']."','1','1','0','".$db5->f("productname")." (Cadeau RDV)','0','RR')";
$db3->query($q3);
$db3->next_record();
$q = "INSERT INTO vtiger_salesorder (salesorderid, salesorder_no, subject, potentialid, contactid, sostatus, total, subtotal,duedate) VALUES ($crmid, '$salesorder_no','Commande Cadeau RDV (".$_SESSION['potential_no'].")', '".$_SESSION['potentialid']."','".$hotesse_rdv."', 'Non finalisée','0','0','".$_SESSION['date']."')";
$dbs->query($q);
$dbs->next_record(); |
Partager