$idTransaction = $transaction->insertTransaction(array(Consultations::$business, Consultations::$insert, Consultations::$descriptionBusiness));
/*
* subject, consultation, datetime_consultation,
fk_id_hcourse_matter_teacher, fk_id_flow_type_query,
fk_id_educational_role, cons_fk_id_teacher, cons_fk_id_holder,
cons_fk_id_student, fk_id_response_area, satisfy_fk_id_response,
*/
$pk_id_student = null;
if ($_POST['cons_fk_id_student'] > 0) {
$pk_id_student = $_POST['cons_fk_id_student'];
}
$pk_id_holder = null;
if ($_POST['cons_fk_id_holder'] > 0) {
$pk_id_holder = $_POST['cons_fk_id_holder'];
}
$dataAssignHCourseMatterTEacher = $matterCourse->getListAssignHCourseHardMatterTeacher($_POST['fk_id_hcourse_matter_teacher']);
$pk_id_teacher = null;
if (count($dataAssignHCourseMatterTEacher) > 0) {
$pk_id_teacher = $dataAssignHCourseMatterTEacher[0]['fk_id_teacher'];
}
$data = array($_POST['subject'], $_POST['consultation'], $_POST['fk_id_hcourse_matter_teacher'], $whosConsultation['fk_id_flow_type_query'], $whosConsultation['fk_id_educational_role'], $pk_id_teacher, $pk_id_holder, $pk_id_student, $flowData['pk_id_response_area'], NULL);
$res = $consultation->insertConsultations($data, $idTransaction);
if ($res > 0) {
Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'La consulta se registro exitosamente!');
} else {
Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la consulta no se pudieron registrar!');
}
}
$matterCourse = new AssignHCourseHardMatterTeacher($registry[$nameDataBase]);
$data = array();
$list = array();
});
});
</script>
<?php
$action = 'INSERT';
if (isset($_GET['ACTION']) && $_GET['ACTION'] == 'EDIT') {
$action = $_GET['ACTION'];
}
$preview_flag = 0;
$matterCourse = new AssignHCourseHardMatterTeacher($registry[$nameDataBase]);
$data = array();
if ($action == 'EDIT') {
if (isset($_GET['PK_ID_HCOURSE_MATTER_TEACHER'])) {
$res = $matterCourse->getListAssignHCourseHardMatterTeacher($_GET['PK_ID_HCOURSE_MATTER_TEACHER']);
//print_r($res);
$data = $res[0];
}
}
$teacher = new Teacher($registry[$nameDataBase]);
?>
<form id="course_data_form" method="POST" action="?page=course/course_matter_admin&ACTION=<?php
echo $action;
?>
&PK_ID_COURSE_HARD=<?php
echo $_GET['PK_ID_COURSE_HARD'];
?>
" enctype="multipart/form-data" >
<table class="form">
