Transaction::insertTransaction PHP代码示例

示例#1

0

显示文件

文件： course_response_save_script.php 项目： vicholuis/proyectopruebalms

<?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"];

示例#2

0

显示文件

文件： grade_education_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        GradeEducation::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(GradeEducation::$business, GradeEducation::$update, GradeEducation::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateGradeEducation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        GradeEducation::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(GradeEducation::$business, GradeEducation::$update, GradeEducation::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteGradeEducation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListGradeEducation();
?>
<div class="grid_10">

示例#3

0

显示文件

文件： admission_period.php 项目： vicholuis/proyectopruebalms

            $cursos = $_POST['chk_cursos'];
            $cap = new CourseApplyPeriod($registry[$nameDataBase]);
            $dsd = $cap->deleteCourseApplyPeriod(array($id_period), $idTransaction);
            for ($i = 0; $i < count($cursos); $i++) {
                $data_cursos = array($id_period, $cursos[$i]);
                $ds = $cap->insertCourseApplyPeriod($data_cursos, $idTransaction);
            }
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        AdmissionPeriod::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(AdmissionPeriod::$business, AdmissionPeriod::$update, AdmissionPeriod::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteAdmissionPeriod($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListAdmissionPeriod();
?>
<div class="grid_10">

示例#4

0

显示文件

文件： admission_supervisor.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        SupervisorAdmissionArea::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(SupervisorAdmissionArea::$business, SupervisorAdmissionArea::$update, SupervisorAdmissionArea::$descriptionBusiness));
        $data = array($_POST['ID_ADMISSION_AREA'], $_POST['ID_PERSON'], $_POST['ID_STATUS_SUPERVISOR'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateSupervisorAdmissionArea($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        SupervisorAdmissionArea::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(SupervisorAdmissionArea::$business, SupervisorAdmissionArea::$update, SupervisorAdmissionArea::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteSupervisorAdmissionArea($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListSupervisorAdmissionArea();
?>
<div class="grid_10">

示例#5

0

显示文件

文件： course_matter_save_script.php 项目： vicholuis/proyectopruebalms

<?php

$transaction = new Transaction($registry[$nameDataBase]);
AssignHCourseHardMatterTeacher::setDataOperationBusiness($registry[$nameDataBase]);
$idTransaction = $transaction->insertTransaction(array(AssignHCourseHardMatterTeacher::$business, AssignHCourseHardMatterTeacher::$insert, AssignHCourseHardMatterTeacher::$descriptionBusiness));
$matterCourse = new AssignHCourseHardMatterTeacher($registry[$nameDataBase]);
if (isset($_POST['ACTION']) && $_POST['ACTION'] == 'INSERT' && $_POST['ENTITY'] == 'ASSIGN_MATTER_TEACHER') {
    /*
    
    fk_id_teacher, fk_id_main_course_matter, fk_id_course_hard
    */
    $data = array($_POST['FK_ID_TEACHER'], $_POST['FK_ID_MAIN_COURSE_MATTER'], $_POST['PK_ID_COURSE_HARD']);
    $pk_id = $matterCourse->insertAssignHCourseHardMatterTeacher($data, $idTransaction);
    if ($pk_id > 0) {
        Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'Los Datos de la asignacion materia docente se guardaron correctamente!');
    } else {
        Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la asignacion materia docente no se pudieron guardar!');
    }
}
if (isset($_POST['ACTION']) && $_POST['ACTION'] == 'EDIT' && $_POST['ENTITY'] == 'ASSIGN_MATTER_TEACHER') {
    $data = array($_POST['FK_ID_TEACHER'], $_POST['FK_ID_MAIN_COURSE_MATTER'], $_POST['PK_ID_COURSE_HARD'], $_POST['PK_ID_HCOURSE_MATTER_TEACHER']);
    // ECHO $_POST['PK_ID_HCOURSE_MATTER_TEACHER'];
    $pk_id = $matterCourse->updateAssignHCourseHardMatterTeacher($data, $idTransaction);
    if ($pk_id > 0) {
        Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'Los Datos de la asignacion materia docente se actualizaron correctamente!');
    } else {
        Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la asignacion materia docente no se pudieron actualizar!');
    }
}
if (isset($_GET['ACTION']) && $_GET['ACTION'] == 'DELETE' && $_GET['ENTITY'] == 'ASSIGN_MATTER_TEACHER') {
    $data = array($_GET['PK_ID_HCOURSE_MATTER_TEACHER']);

示例#6

0

显示文件

文件： upload_debt_admin.php 项目： vicholuis/proyectopruebalms

     if (file_exists("upload/cuotas/" . $filename)) {
         unlink("upload/cuotas/" . $filename);
     }
     move_uploaded_file($_FILES["archivo"]["tmp_name"], "upload/cuotas/" . $filename);
     $res = 'OK';
 }
 if ($res == 'OK') {
     $opcion = $_POST['id_type_notes'];
     //TIPO DE ESTRUCTURA A CARGAR
     $filename = "upload/cuotas/" . $filename;
     $fp = fopen($filename, "r");
     $contador = 0;
     //Transaction
     $transaction = new Transaction($registry[$nameDataBase]);
     CourseNotesBallot::setDataOperationBusiness($registry[$nameDataBase]);
     $idTransaction = $transaction->insertTransaction(array(CourseNotesBallot::$business, CourseNotesBallot::$insert, CourseNotesBallot::$descriptionBusiness));
     while (!feof($fp)) {
         $linea = fgets($fp);
         $datos = explode("|", $linea);
         switch ($opcion) {
             case 1:
                 $student = new Student($db);
                 $id_student = $student->getStudentId($datos[1]);
                 $debt_share = new DebtShare($db);
                 $data = array(1, $id_student, $datos[0], $datos[3], $datos[4], $datos[5]);
                 $id = $debt_share->insertDebtShare($data, $idTransaction);
                 //adicionar la confirmacion o error del insert
                 //adicionar registro de los logs
                 $res = $id;
                 //resultado final
                 break;

示例#7

0

显示文件

文件： country_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Country::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Country::$business, Country::$update, Country::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateCountry($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Country::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Country::$business, Country::$update, Country::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteCountry($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListCountry();
?>
<div class="grid_10">

示例#8

0

显示文件

文件： admision_aproval.php 项目： vicholuis/proyectopruebalms

     } elseif ($_POST['status_admission_process'] == 34) {
         $statusData = array(38, $_POST['fk_id_membership_app_form']);
         //print_r($statusData);
         $statusTransactionDBStatus = $formObject->updateMembershipAppFormStatusAddmision($statusData, $idTransaction);
     }
     if ($statusTransactionDB > 0) {
         Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'Los Datos de Evaluacion del formulario se guardaron correctamente!' . $messageInsertFormData);
     } else {
         Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los Datos de Evaluacion del formulario no se pudieron guardar!');
     }
 }
 if (isset($_GET['ACTION']) && $_GET['ACTION'] == 'EDIT' && isset($_GET['pk_id_admission_process']) && $_GET['pk_id_admission_process'] > 0) {
     //echo 'entro';
     $transaction = new Transaction($registry[$nameDataBase]);
     AdmissionProcess::setDataOperationBusiness($registry[$nameDataBase]);
     $idTransaction = $transaction->insertTransaction(array(AdmissionProcess::$business, AdmissionProcess::$insert, AdmissionProcess::$descriptionBusiness));
     $statusTransactionDB = $process->reactiveAdmissionProcess($_GET['ID_FORM'], $_GET['pk_id_admission_process']);
     // El estado en el formulario se coloca a 36='PENDIENTE'
     $statusData = array(36, $_GET['ID_FORM']);
     //print_r($statusData);
     $statusTransactionDBStatus = $formObject->updateMembershipAppFormStatusAddmision($statusData, $idTransaction);
     if ($statusTransactionDB > 0) {
         Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'El proceso de admision se reactivo exitosamente!');
     } else {
         Forms::setMessage('ERROR', 'Transaccion erronea!!', 'El proceso de admision no se pudo reactivar!');
     }
 }
 $areas = $process->getListAdmissionProcessByAppForm($id_form);
 if (count($areas) == 0) {
     $active = 0;
 }

示例#9

0

显示文件

文件： reservation_admin.php 项目： vicholuis/proyectopruebalms

    case 'INSERT':
        $transaction = new Transaction($registry[$nameDataBase]);
        SeatReservation::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(SeatReservation::$business, SeatReservation::$insert, SeatReservation::$descriptionBusiness));
        $data = array($_POST['pk_id_seat_reservation_period'], $_GET['FK_ID_ASSIGN_HOLDER_STUDENT']);
        $statusTransactionDB = $seatReservation->insertSeatReservation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_NEW"], $v_label["DETAIL_MESSAGE_OK_NEW"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_NEW"], $v_label["DETAIL_MESSAGE_NOOK_NEW"]);
        }
        break;
    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        SeatReservation::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(SeatReservation::$business, SeatReservation::$insert, SeatReservation::$descriptionBusiness));
        $data = array($_POST['pk_id_seat_reservation_period'], $_GET['FK_ID_ASSIGN_HOLDER_STUDENT']);
        $statusTransactionDB = $seatReservation->updateSeatReservation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$id_person = 2;
if (isset($_SESSION["PK_ID_PERSON"])) {
    $id_person = $_SESSION["PK_ID_PERSON"];

示例#10

0

显示文件

文件： course_save_script.php 项目： vicholuis/proyectopruebalms

<?php

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
$mainCourse = new MainCourse($registry[$nameDataBase]);
$courseHard = new CourseHard($registry[$nameDataBase]);
$courseHard = new CourseHard($registry[$nameDataBase]);
$matterCourse = new AssignHCourseHardMatterTeacher($registry[$nameDataBase]);
$transaction = new Transaction($registry[$nameDataBase]);
CourseHard::setDataOperationBusiness($registry[$nameDataBase]);
$idTransaction = $transaction->insertTransaction(array(CourseHard::$business, CourseHard::$insert, CourseHard::$descriptionBusiness));
if (isset($_POST['ACTION'])) {
    if ($_POST['ACTION'] == 'INSERT' && isset($_POST['ENTITY']) && $_POST['ENTITY'] == 'COURSE_HARD') {
        //INSERCION DE NUEVO CURSO
        /*
                 
                    NAME_COURSE, DATE_START, DATE_END, 
                                                                COMMENTS_ADITIONAL, FK_ID_PERIOD, 
                                                                FK_ID_MAIN_COURSE, STATUS_COURSE_HARD, 
                  
                 * */
        $data = array($_POST['NAME_COURSE'], date('Y-m-d', strtotime(str_replace('/', '-', $_POST['DATE_START']))), date('Y-m-d', strtotime(str_replace('/', '-', $_POST['DATE_END']))), $_POST['COMMENTS_ADITIONAL'], $_POST['FK_ID_PERIOD'], $_POST['FK_ID_MAIN_COURSE'], $_POST['STATUS_COURSE_HARD']);
        $pk_id_course_hard = $courseHard->insertCourseHard($data, $idTransaction);
        $listMatterCourse = $matterCourse->getListAssignCourseMatterByCourseHard($pk_id_course_hard);
        foreach ($listMatterCourse as $item) {
            //fk_id_teacher, fk_id_main_course_matter, fk_id_course_hard
            $data = array(null, $item['pk_id_main_course_matter'], $pk_id_course_hard);
            $pk_id = $matterCourse->insertAssignHCourseHardMatterTeacher($data, $idTransaction);
        }

示例#11

0

显示文件

文件： location_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Location::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Location::$business, Location::$update, Location::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['ID_CITY'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateLocation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Location::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Location::$business, Location::$update, Location::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteLocation($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListLocation();
?>
<div class="grid_10">

示例#12

0

显示文件

文件： activity_admin.php 项目： vicholuis/proyectopruebalms

    PlanificationActivity::setDataOperationBusiness($registry[$nameDataBase]);
    $idTransaction = $transaction->insertTransaction(array(PlanificationActivity::$business, PlanificationActivity::$insert, PlanificationActivity::$descriptionBusiness));
    $data = array($_POST['activity'], date('Y-m-d', strtotime(str_replace('/', '-', $_POST['activity_start_datetime']))), date('Y-m-d', strtotime(str_replace('/', '-', $_POST['activity_end_datetime']))), $_POST['activity_description'], $_POST['pk_id_type_planification_activity'], $_POST['pk_id_hcourse_matter_teacher'], $_POST['pk_id_planification_activity']);
    $res = $activity->updatePlanificationActivity($data, $idTransaction);
    if ($res > 0) {
        Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'La actividad se actualizo exitosamente!');
    } else {
        Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la actividad no se pudieron actualizar!');
    }
}
//ELIMINAR
if (isset($_GET['ACTION']) && $_GET['ACTION'] == 'DELETE' && isset($_GET['DELETE'])) {
    $res = 0;
    $transaction = new Transaction($registry[$nameDataBase]);
    PlanificationActivity::setDataOperationBusiness($registry[$nameDataBase]);
    $idTransaction = $transaction->insertTransaction(array(PlanificationActivity::$business, PlanificationActivity::$insert, PlanificationActivity::$descriptionBusiness));
    $res = $activity->deletePlanificationActivity(array($_GET['DELETE']), $idTransaction);
    if ($res > 0) {
        Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'La actividad fue eliminada correctamente!');
    } else {
        Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la actividad no se pueden eliminar!!!!!!');
    }
}
$_SESSION['PK_ID_COURSE_HARD'] = $_GET['PK_ID_COURSE_HARD'];
//if($_SESSION['pk_id_role']==ROLE_TITULAR)   $list = $activity->getListActivityByHolder($_SESSION['pk_id_holder']);
//if($_SESSION['pk_id_role']==ROLE_PROFESOR)   $list = $activity->getListActivityByTeacherCourseHard($_GET['PK_ID_COURSE_HARD'],$_SESSION['pk_id_person'] );
?>

<div class="grid_10">
            <div class="box round first">
                <h2><?php

示例#13

0

显示文件

文件： gender_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Gender::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Gender::$business, Gender::$update, Gender::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateGender($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Gender::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Gender::$business, Gender::$update, Gender::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteGender($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListGender();
?>
<div class="grid_10">

示例#14

0

显示文件

文件： course_request_admin.php 项目： vicholuis/proyectopruebalms

</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, 
                   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']);

示例#15

0

显示文件

文件： main_course_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        MainCourse::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(MainCourse::$business, MainCourse::$update, MainCourse::$descriptionBusiness));
        $data = array($_POST['name'], $_POST['course_code'], $_POST['description'], $_POST['is_abstract_course'], $_POST['is_course_configuration'], $_POST['status_main_course'], $_POST['data_1'], $_POST['data_2'], $_POST['data_3'], $_POST['data_4'], $_POST['data_5'], $_POST['pk_id_main_course']);
        $statusTransactionDB = $catalog->updateMainCourse($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        MainCourse::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(MainCourse::$business, MainCourse::$update, MainCourse::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteMainCourse($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListMainCourse();
?>
<div class="grid_10">

示例#16

0

显示文件

文件： profession_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Profession::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Profession::$business, Profession::$update, Profession::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateProfession($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Profession::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Profession::$business, Profession::$update, Profession::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteProfession($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListProfession();
?>
<div class="grid_10">

示例#17

0

显示文件

文件： marital_status_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        MaritalStatus::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(MaritalStatus::$business, MaritalStatus::$update, MaritalStatus::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateMaritalStatus($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        MaritalStatus::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(MaritalStatus::$business, MaritalStatus::$update, MaritalStatus::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteMaritalStatus($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListMaritalStatus();
?>
<div class="grid_10">

示例#18

0

显示文件

文件： titular_admin.php 项目： vicholuis/proyectopruebalms

 case 'DELETE':
     $transaction = new Transaction($registry[$nameDataBase]);
     Holder::setDataOperationBusiness($registry[$nameDataBase]);
     $idTransaction = $transaction->insertTransaction(array(Holder::$business, Holder::$update, Holder::$descriptionBusiness));
     $data = array($_GET['DELETE']);
     //$statusTransactionDB = $catalog->deleteTeacher($data, $idTransaction);
     if ($statusTransactionDB > 0) {
         Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
     } else {
         Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
     }
     break;
 case 'ASIGNAR_DEPENDIENTES':
     $transaction = new Transaction($registry[$nameDataBase]);
     Holder::setDataOperationBusiness($registry[$nameDataBase]);
     $idTransaction = $transaction->insertTransaction(array(Holder::$business, Holder::$insert, Holder::$descriptionBusiness));
     $query = null;
     $dateTimeNowRow = null;
     $dateTimeNow = null;
     try {
         $query = "select DATE_FORMAT(CURRENT_TIMESTAMP(),'%Y-%m-%d %H:%i:%s') datetime";
         $result = DataBase::getArrayListQuery($query, array(), $registry[$nameDataBase]);
         $dateTimeNowRow = $result[0];
         $dateTimeNow = $dateTimeNowRow['datetime'];
     } catch (PDOException $e) {
         echo 'Error JF-Model-0011: ' . $e->getMessage();
     }
     //echo 'ESTUDIANTE='.$_POST['student'];
     /* 
     $data = array(                          
                   $dateTimeNow,

示例#19

0

显示文件

文件： level_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        Teacher::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Teacher::$business, Teacher::$update, Teacher::$descriptionBusiness));
        $data = array($_POST['TEACHER_STATUS'], $_POST['pk_id_person'], $_POST['data_1'], $_POST['data_2'], $_POST['data_3'], $_POST['data_4'], $_POST['data_5'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateTeacher($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Teacher::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Teacher::$business, Teacher::$update, Teacher::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteTeacher($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListLevelMainCourse();
?>
<div class="grid_10">

示例#20

0

显示文件

文件： type_identify_doc_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        TypeIdentifyDoc::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(TypeIdentifyDoc::$business, TypeIdentifyDoc::$update, TypeIdentifyDoc::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateTypeIdentityDoc($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        TypeIdentifyDoc::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(TypeIdentifyDoc::$business, TypeIdentifyDoc::$update, TypeIdentifyDoc::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteTypeDirection($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListTypeIdentifyDoc();
?>
<div class="grid_10">

示例#21

0

显示文件

文件： type_contact_admin.php 项目： vicholuis/proyectopruebalms

    case 'EDIT':
        $transaction = new Transaction($registry[$nameDataBase]);
        TypeContact::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(TypeContact::$business, TypeContact::$update, TypeContact::$descriptionBusiness));
        $data = array($_POST['NAME'], $_POST['EDIT']);
        $statusTransactionDB = $catalog->updateTypeContact($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        TypeContact::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(TypeContact::$business, TypeContact::$update, TypeContact::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteTypeContact($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListTypeContact();
?>
<div class="grid_10">

示例#22

0

显示文件

文件： person_save_script.php 项目： vicholuis/proyectopruebalms

            }
            $delete = @split(',', $_POST['bill_din_delete_array']);
            //print_r($delete);
            foreach ($delete as $del) {
                $res = $bill->deleteBillingData(array($del), $idTransaction);
            }
        }
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'Los Datos de la Persona se actualizaron correctamente!');
        } else {
            Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la persona no se pudieron actualizar!');
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        Person::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(Person::$business, Person::$insert, Person::$descriptionBusiness));
        $data1 = array($_GET['PK_ID_PERSON']);
        $pk_id_person = $person->deletePerson($data1, $idTransaction);
        if ($pk_id_person > 0) {
            Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'Los datos de la persona fueron eliminaos!');
        } else {
            Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la persona no se pudieron eliminar!!');
        }
        break;
    default:
        break;
}
?>

示例#23

0

显示文件

文件： admision_form.php 项目： vicholuis/proyectopruebalms

            if (isset($_POST['id_hm_3']) && isset($_POST['nombre_hm_3'])) {
                $idmh3 = $hnos->updateKindBrother($data_m_h3, $idTransaction);
            }
            if (empty($_POST['id_hm_3']) && isset($_POST['nombre_hm_3'])) {
                $data_m_h3 = array($_POST['EDIT'], 29, $_POST['nombre_hm_3'], $fch_nac_hm_3, $_POST['colegio_hm_3'], $_POST['universidad_hm_3'], $_POST['trabajo_hm_3']);
                $idmh3 = $hnos->insertKindBrother($data_m_h3, $idTransaction);
            }
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_EDIT"], $v_label["DETAIL_MESSAGE_OK_EDIT"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_EDIT"], $v_label["DETAIL_MESSAGE_NOOK_EDIT"]);
        }
        break;
    case 'DELETE':
        $transaction = new Transaction($registry[$nameDataBase]);
        MembershipAppForm::setDataOperationBusiness($registry[$nameDataBase]);
        $idTransaction = $transaction->insertTransaction(array(MembershipAppForm::$business, MembershipAppForm::$update, MembershipAppForm::$descriptionBusiness));
        $data = array($_GET['DELETE']);
        $statusTransactionDB = $catalog->deleteMembershipAppForm($data, $idTransaction);
        if ($statusTransactionDB > 0) {
            Forms::setMessage('SUCCESS', $v_label["SHORT_MESSAGE_OK_DELETE"], $v_label["DETAIL_MESSAGE_OK_DELETE"]);
        } else {
            Forms::setMessage('ERROR', $v_label["SHORT_MESSAGE_NOOK_DELETE"], $v_label["DETAIL_MESSAGE_NOOK_DELETE"]);
        }
        break;
    default:
        break;
}
// Obtener lista
$list = $catalog->getListMembershipAppForm();
?>
<div class="grid_10">

示例#24

0

显示文件

文件： take_care_admin.php 项目： vicholuis/proyectopruebalms

        }
    } else {
        if ($res > 0) {
            Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'La Tarea se actualizo exitosamente!');
        } else {
            Forms::setMessage('ERROR', 'Transaccion erronea!!', 'Los datos de la Tarea no se pudieron actualizar!');
        }
    }
}
//Calificar Tarea - Profesor
if (isset($_GET['ACTION']) && $_GET['ACTION'] == 'INSERT' && isset($_GET['ENTITY']) && $_GET['ENTITY'] == 'QUALIFY') {
    $res = 0;
    $student_task = new StudentTask($registry[$nameDataBase]);
    $transaction = new Transaction($registry[$nameDataBase]);
    StudentTask::setDataOperationBusiness($registry[$nameDataBase]);
    $idTransaction = $transaction->insertTransaction(array(StudentTask::$business, StudentTask::$insert, StudentTask::$descriptionBusiness));
    for ($i = 0; $i < $_POST['cantidad']; $i++) {
        $res = $student_task->updateStudentTask(array($_POST['score_achieved_' . $i], $_POST['pk_id_student_task_' . $i]), $idTransaction);
    }
    if ($res > 0) {
        Forms::setMessage('SUCCESS', 'Transaccion exitosa!!', 'La Calificacion Para el Estudiante se Actualizo correctamente !');
    } else {
        Forms::setMessage('ERROR', 'Transaccion erronea!!', 'La Calificacion Para el Estudiante no Pudo Realizarse!');
    }
}
$_SESSION['PK_ID_COURSE_HARD'] = $_GET['PK_ID_COURSE_HARD'];
?>

<div class="grid_10">
    <div class="box round first">
        <h2><?php

PHP Transaction::insertTransaction示例