get('roleid'); $viewer = new Vtiger_Viewer(); $viewer->assign('MODULE', 'Home'); $viewer->assign('SELECTED_MENU_CATEGORY', 'MARKETING'); $viewer->assign('COMPANY_LOGO', Vtiger_CompanyDetails_Model::getInstanceById()->getLogo()); $viewer->assign('COMPANY_DETAILS_SETTINGS',new Settings_Vtiger_CompanyDetails_Model()); $viewer->assign('USER_MODEL', $current_user); $viewer->assign('CURRENT_USER_MODEL', $current_user); $viewer->assign('PAGETITLE','Creation'); $viewer->view('CustomDashboard.tpl'); if(isset($_POST['save'])) { $reseau = implode("::", $_POST['reseau'] ); $query = "INSERT INTO `ent_qcm` (`libelle_qcm` , `date_debut`, `date_fin`, `heure_debut`, `heure_fin`,`type`,`duree` ,`reseau` ,`forme` ,`memo`) VALUES ('".$_POST['libelle']."','".$_POST['dateD']."' ,'".$_POST['dateF']."','".$_POST['heureD']."','".$_POST['heureF']."' ,'".$_POST['type']."' ,'".$_POST['duree']."' ,'".$reseau."' ,'".addslashes($_POST['forme'])."' ,'".addslashes($_POST['memo'])."' );"; $adb->query($query); $query3= "SELECT max(code_qcm) as id FROM `ent_qcm`"; $sql_get_result3 = $adb->query($query3); while ($recordinfo = $adb->fetch_array($sql_get_result3)) { $id[] = $recordinfo; } $a=1; for ($x = 0; $x < sizeof($_POST['question']); $x++) { $tableau="checkboxcChoix".$a; $comma_separated = implode("::", $_POST[$tableau]); $checkboxcChoix=$comma_separated; $query2 = "INSERT INTO `lignes_qcm` (`ordre` , `code_ent_qcm`, `question`, `choix1`, `choix2`,`choix3`, `choix4`, `choix5`,`correction`,`note`) VALUES ('".$_POST["ordre"][$x]."','".$id[0]['id']."','".htmlentities($_POST['question'][$x], ENT_QUOTES, "UTF-8")."','".htmlentities($_POST['choix1'][$x], ENT_QUOTES, "UTF-8")."','".htmlentities($_POST['choix2'][$x], ENT_QUOTES, "UTF-8")."' ,'".htmlentities($_POST['choix3'][$x], ENT_QUOTES, "UTF-8")."','".htmlentities($_POST['choix4'][$x], ENT_QUOTES, "UTF-8")."' ,'".htmlentities($_POST['choix5'][$x],ENT_QUOTES, "UTF-8")."','". $checkboxcChoix."','".$_POST['note'][$x]."');"; $adb->query($query2); $a=$a+1; } } echo'

Details Examen

Libellé	Type
Date Début	Date fin
Heure début	Heure fin
Durée	Réseau	A B C
Forme

MÉMO

Lignes Question

Ordre	Question	Choix 1	Choix 2	Choix 3	Choix 4	Choix 5	Correction	Note

'; echo '

'; $viewer->view('CustomDashboardFooter.tpl'); ?>