/**
* This is construct base of the class.
*
* A public constructor; initializes the variable $instanceDataBase.
*
*/
public function __construct($instanceDataBase)
{
parent::__construct($instanceDataBase);
Consultations::setDataOperationBusiness($instanceDataBase);
Consultations::getBusiness();
Consultations::getDescriptionBusiness();
}
<?php
$response = new Response($registry[$nameDataBase]);
$consultation = new Consultations($registry[$nameDataBase]);
if (isset($_POST['ACTION']) && $_POST['ACTION'] == 'INSERT' && $_POST['ENTITY'] == 'REQUEST_RESPONSE') {
$res = 0;
$transaction = new Transaction($registry[$nameDataBase]);
Consultations::setDataOperationBusiness($registry[$nameDataBase]);
$idTransaction = $transaction->insertTransaction(array(Response::$business, Response::$insert, Response::$descriptionBusiness));
/*
*
* response, datetime_response,
level, parent_response, fk_id_consultation, fk_id_query_area,
fk_id_educational_role, resp_fk_id_deputy_director,
resp_fk_id_psychologist, resp_fk_id_headmaster,
resp_fk_id_board_directors, resp_fk_id_student,
resp_fk_id_holder, resp_fk_id_teacher, state_satisfaction
*/
$fk_id_educational_role = $_SESSION["pk_id_educational_role"];
$resp_fk_id_deputy_director = NULL;
$resp_fk_id_psychologist = NULL;
$resp_fk_id_headmaster = NULL;
$resp_fk_id_board_directors = NULL;
$resp_fk_id_student = NULL;
$resp_fk_id_holder = NULL;
$resp_fk_id_teacher = NULL;
if ($_SESSION["pk_id_role"] == User::ROLE_ESTUDIANTE) {
$resp_fk_id_student = $_SESSION["pk_id_student"];
}
if ($_SESSION["pk_id_role"] == User::ROLE_PROFESOR) {
$resp_fk_id_teacher = $_SESSION["pk_id_teacher"];
if (count($request_data) > 0) {
//obtener datos de consulta
$request_data = $request_data[0];
if ($request_data['satisfy_fk_id_response'] != null && $request_data['satisfy_fk_id_response'] == '') {
$flag_consulta_cerrada = 1;
}
$request_sucess_response = $request_data['satisfy_fk_id_response'];
$request_subject = $request_data['subject'];
$request_date = $request_data['datetime_consultation'];
$request_name = $_SESSION['authenticated_user'];
$request_rol_open = $_SESSION['authenticated_role'];
$request_description = $request_data['consultation'];
}
//obtener datos de respuestas
$response = new Response($db);
$consultation = new Consultations($db);
$responses = $response->getListResponseByConsultation($pk_id_consultation);
$consult = $consultation->getListConsultations($pk_id_consultation);
// catalogo de respuesta de datos de respuesta
$courseStatus = new SystemCatalog($db);
$catalogo1 = $courseStatus->getListSystemCatalog('STATE_SATISFACTION');
$escalations = $consultation->getConsultationEscalation($pk_id_consultation);
?>
<div class="grid_10">
<div class="box round first">
<h2><?php
echo 'Respuestas de Consulta';
?>
</h2>
"sInfoPostFix": "",
"sSearch": "Buscar",
"sUrl": "",
"oPaginate": {
"sFirst": "Primero",
"sPrevious": "Anterior",
"sNext": "Siguiente",
"sLast": "Ultimo"
}
}});
});
</script>
<?php
//getListAssignHCourseHardMatterTeacherByCourseHard
$consultation = new Consultations($registry[$nameDataBase]);
$whosConsultation = $consultation->getWhosConsultationByRole($_SESSION["pk_id_educational_role"]);
if (isset($_POST['ACTION']) && $_POST['ACTION'] == 'INSERT' && $_POST['ENTITY'] == 'COURSE_CONSULTATION' && count($whosConsultation) > 0) {
//1 id area del flujo par ainiciar conslta
$flowData = $consultation->getListAllFlowData($_SESSION["pk_id_educational_role"], 1);
$flowData = $flowData[0];
$res = 0;
$whosConsultation = $whosConsultation[0];
// $holder = new Holder($instanceDataBase)
$transaction = new Transaction($registry[$nameDataBase]);
Consultations::setDataOperationBusiness($registry[$nameDataBase]);
$matterCourse = new AssignHCourseHardMatterTeacher($registry[$nameDataBase]);
$idTransaction = $transaction->insertTransaction(array(Consultations::$business, Consultations::$insert, Consultations::$descriptionBusiness));
/*
* subject, consultation, datetime_consultation,
fk_id_hcourse_matter_teacher, fk_id_flow_type_query,