Скачать или смотреть Ajax Callback setvalue + SweetAlert2 oracle apex 20.2 Part - 3

#Set Value
avec #Ajax Callback + #SweetAlert2
Process Ajax Callback PL/SQL
GET_DEPT_INFO
declare
l_location dept.loc%TYPE;
l_no_emp number;

begin

select DEPT.LOC LOC,
count(EMP.EMPNO) EMPNO

into l_location , l_no_emp

from DEPT DEPT,
EMP EMP
where DEPT.DEPTNO = EMP.DEPTNO(+)
and DEPT.DEPTNO = :P22_DEPTNO
group by dept.loc;

apex_json.open_object;
apex_json.write(
p_name= ('LOC'),
p_value = l_location
);
apex_json.write (
p_name = ('EMPNO'),
p_value = l_no_emp
);
apex_json.close_object;
end;
Action dynamique JS code
apex.server.process("GET_DEPT_INFO", {
pageItems: "#P22_DEPTNO"
},
{

success: function(data){
$s("P22_LOCATION",data.LOC);
$s("P22_NO_EMP",data.EMPNO);
}
}

);


Utiliser Sweet Alert 2 pour confirmer
Set Value avec Ajax Callback

const swalWithBootstrapButtons = Swal.mixin({
customClass: {
confirmButton: 'btn btn-success',
cancelButton: 'btn btn-danger'

},
buttonsStyling: false
})
swalWithBootstrapButtons.fire({
title: 'tu veux valider DA Set Value?',
text: "Tu confirmes cette Action SetValue!",
icon: 'warning',
showCancelButton: true,
confirmButtonText: 'Valider!',
cancelButtonText: 'Annuler!',
reverseButtons: true
}).then((result) = {
if (result.isConfirmed) {
apex.da.cancel();
swalWithBootstrapButtons.fire(
'Valider !',
'l’opération SetValue a été bien exécuté.',
'success'
)

} else if (
/* Read more about handling dismissals below */
result.dismiss === Swal.DismissReason.cancel
) {

swalWithBootstrapButtons.fire(
'Annuler',
'l’opération SetValue a été annulé :)',
'error'
)

}
})