0) {
has_refsettings = true;
}
// Charge la liste des prestataires RH
_prestataire_collection = new CTI_ArrayCollection();
_prestataire_collection.loadXMLList(resultatService.PRESTATAIRE);
}
searchChange();
setTimeout(setBuildComplete, 1000);
}
}
private function setBuildComplete():void {
buildComplete = true;
}
private function resize():void {
}
private function searchChange():void {
if (list_collection.filterFunction == null) {
list_collection.filterFunction = filterFunction;
}
list_collection.refresh();
}
// Filter function
public function filterFunction(item:Object):Boolean {
var result:Boolean = true;
if (Number(item.oid) >= 0) {
if (textSearch_GUI.text != "") {
result = false
for each (var attributeName:String in list_collection.attributesArray) {
if (item[attributeName].toString().toUpperCase().indexOf(textSearch_GUI.text.toUpperCase()) >= 0) {
result=true;
break;
}
}
}
if (result == true) {
if (refSearch_GUI.selected == true) {
if (item.hasOwnProperty("nbref")) {
if (Number(item.nbref.toString()) <= 0) {
if (item.hasOwnProperty("nbref2")) {
if (Number(item.nbref.toString()) <= 0) {
result = false;
}
}
else {
result = false;
}
}
}
}
}
if (result == true) {
if (code_calcul_search_GUI.selected == true) {
if (item.hasOwnProperty("code_calcul")) {
if (Number(item.code_calcul.toString()) <= 0) {
result = false;
}
}else {
result = false;
}
}
}
}
return result;
}
public function clearSearchText():void {
textSearch_GUI.text = "";
searchChange();
}
public function getRecord():void {
if (recordUpdated == true) {
return;
}
if (tableCode == "POP") {
if (POP_list_GUI.selectedIndex < 0) {
return;
}
currendRecordItem = POP_list_GUI.selectedItem as Object;
} else if (tableCode == "PER") {
if (PER_list_GUI.selectedIndex < 0) {
return;
}
currendRecordItem = PER_list_GUI.selectedItem as Object;
} else if (tableCode == "EXC") {
/*if (event.columnIndex == 0) {
return;
}*/
if (qimport) {
return;
}
if (EXC_list_GUI.selectedIndex < 0) {
return;
}
currendRecordItem = EXC_list_GUI.selectedItem as Object;
} else {
if (list_GUI.selectedIndex < 0) {
return;
}
currendRecordItem = list_GUI.selectedItem as Object;
}
showDetail();
}
public function addRecord():void {
if (currendRecordItem == null) {
currendRecordItem = new Object();
currendRecordItem.oid = "-1";
currendRecordItem.code = "";
currendRecordItem.code_original = "";
currendRecordItem.texte = "";
currendRecordItem.texte_court = "";
currendRecordItem.nbref = 0;
currendRecordItem.valeur = "";
currendRecordItem.valeur_date = "";
currendRecordItem.code_calcul = "";
currendRecordItem.base_calcul_etp = "";
currendRecordItem.code_ets_planning = "";
currendRecordItem.code_ent_planning = "";
currendRecordItem.unite = "";
currendRecordItem.coefficient = "";
currendRecordItem.coefficient_base = "";
currendRecordItem.coefficient_nombre = "";
currendRecordItem.coefficient_txs = "";
currendRecordItem.coefficient_txp = "";
currendRecordItem.coefficient_nombre = "";
currendRecordItem.user_modified = "";
currendRecordItem.p_cumul = "";
currendRecordItem.p_detail = "";
currendRecordItem.p_nombre = "";
currendRecordItem.s_nombre = "";
currendRecordItem.c_nombre = "";
currendRecordItem.p_base = "";
currendRecordItem.s_base = "";
currendRecordItem.c_base = "";
currendRecordItem.p_heures_contrat = "";
currendRecordItem.s_heures_contrat = "";
currendRecordItem.c_heures_contrat = "";
currendRecordItem.p_heures_payees = "";
currendRecordItem.s_heures_payees = "";
currendRecordItem.c_heures_payees = "";
currendRecordItem.p_heures_travaillees = "";
currendRecordItem.s_heures_travaillees = "";
currendRecordItem.c_heures_travaillees = "";
currendRecordItem.p_masse_salariale = "";
currendRecordItem.s_masse_salariale = "";
currendRecordItem.c_masse_salariale = "";
currendRecordItem.p_brut = "";
currendRecordItem.s_brut = "";
currendRecordItem.c_brut = "";
currendRecordItem.p_avantage_nature = "";
currendRecordItem.s_avantage_nature = "";
currendRecordItem.c_avantage_nature = "";
currendRecordItem.p_frais_imposables = "";
currendRecordItem.s_frais_imposables = "";
currendRecordItem.c_frais_imposables = "";
currendRecordItem.p_cotisation_salarie = "";
currendRecordItem.s_cotisation_salarie = "";
currendRecordItem.c_cotisation_salarie = "";
currendRecordItem.p_cotisation_patronale = "";
currendRecordItem.s_cotisation_patronale = "";
currendRecordItem.c_cotisation_patronale = "";
currendRecordItem.p_od_net_salarie = "";
currendRecordItem.s_od_net_salarie = "";
currendRecordItem.c_od_net_salarie = "";
currendRecordItem.p_od_net_patronale = "";
currendRecordItem.s_od_net_patronale = "";
currendRecordItem.c_od_net_patronale = "";
currendRecordItem.p_net_imposable = "";
currendRecordItem.s_net_imposable = "";
currendRecordItem.c_net_imposable = "";
currendRecordItem.p_net_a_payer = "";
currendRecordItem.s_net_a_payer = "";
currendRecordItem.c_net_a_payer = "";
switch (tableCode) {
case "ETA" :
currendRecordItem.finess_id = "0";
break;
case "TRF" :
currendRecordItem.texte_date = "";
currendRecordItem.texte_from = "";
currendRecordItem.texte_to = "";
currendRecordItem.date_debut = "0001-01-01";
currendRecordItem.date_fin = "2099-12-31";
currendRecordItem.salarie_id = "-1";
currendRecordItem.from_service_id = "-1";
currendRecordItem.to_service_id = "-1";
currendRecordItem.from_qualification_id = "-1";
currendRecordItem.to_qualification_id = "-1";
break;
case "DPR" :
currendRecordItem.etablissement_inclus
currendRecordItem.etablissement_exclus
currendRecordItem.service_inclus
currendRecordItem.service_exclus
currendRecordItem.statut_inclus
currendRecordItem.statut_exclus
break;
case "POP" :
currendRecordItem.oid = "-1";
currendRecordItem.nbref = 0;
currendRecordItem.code = "";
currendRecordItem.texte = "";
case "PER" :
currendRecordItem.oid = "-1";
currendRecordItem.texte = "";
currendRecordItem.priorite = "5000";
currendRecordItem.population_id = "0";
currendRecordItem.liste_finess = "";
currendRecordItem.liste_etablissement = "";
currendRecordItem.liste_service = "";
currendRecordItem.liste_specialite = "";
currendRecordItem.liste_section_analytique = "";
currendRecordItem.liste_section_analytique_paie = "";
currendRecordItem.liste_qualification = "";
currendRecordItem.liste_grille = "";
currendRecordItem.liste_code_emploi = "";
currendRecordItem.liste_categorie_socio_professionnelle = "";
currendRecordItem.liste_statut = "";
case "EXC" :
currendRecordItem.oid = "-1";
currendRecordItem.nbref = 0;
currendRecordItem.code = "";
currendRecordItem.texte = "";
currendRecordItem.texte_abrege = "";
currendRecordItem.description = "";
currendRecordItem.is_hide = "0";
currendRecordItem.is_active = "1";
currendRecordItem.is_cti = "0";
currendRecordItem.gravite = "0";
currendRecordItem.gravite_texte = "";
currendRecordItem.complement = "";
currendRecordItem.rule_oid1 = "0";
currendRecordItem.sqlcmd_where1 = "";
currendRecordItem.sqlcmd_justificatif1 = "";
currendRecordItem.table1 = "0";
currendRecordItem.last_execution_date1 = "";
currendRecordItem.last_execution_ok1 = "";
currendRecordItem.prestataire_id = "-1";
currendRecordItem.prestataire_texte = "Tous";
currendRecordItem.is_alert = "0";
}
showDetail();
}
}
public function getRecordExpert(event:ListEvent = null):void {
// Spécial Controles Expert
if (tableCode == "EXC") {
/*if (event.columnIndex == 0) {
return;
}*/
if (qimport) {
return;
}
}
if (recordUpdated == true) {
return;
}
if (EXC_list_GUI.selectedIndex < 0) {
return;
}
currendRecordItem = EXC_list_GUI.selectedItem as Object;
showDetail();
}
public function showDetail():void {
var i:Number;
var item:Object;
if (currendRecordItem == null) {
return;
}
if (tableCode == "EXC"){
fillFields(new Array("oid", "code", "texte", "texte_court", "texte_abrege", "description",
"rule_oid1", "sqlcmd_where1", "sqlcmd_justificatif1",
"is_hide", "is_cti", "is_active", "is_alert"
));
setSelectedIndex(EXC_gravite_GUI, currendRecordItem.gravite.toString());
setSelectedIndex(EXC_prestataire_GUI, currendRecordItem.prestataire_id.toString());
setSelectedIndex(EXC_table1_GUI, currendRecordItem.table1.toString());
EXC_is_alert_GUI.selected = currendRecordItem.is_alert.toString() == '1' ? true : false;
EXC_sqlcmd_where1_GUI.setStyle("backgroundColor", null);
EXC_sqlcmd_justificatif1_GUI.setStyle("backgroundColor", null);
} else {
oid_GUI.text = currendRecordItem.oid.toString();
nbref_GUI.text = currendRecordItem.nbref.toString();
code_GUI.text = currendRecordItem.code.toString();
texte_GUI.text = currendRecordItem.texte.toString();
texte_court_GUI.text = currendRecordItem.texte_court.toString();
valeur_GUI.text = currendRecordItem.valeur.toString();
valeur_date_GUI.text = currendRecordItem.valeur_date.toString();
code_original_GUI.text = currendRecordItem.code_original.toString();
code_calcul_GUI.selectedIndex = currendRecordItem.code_calcul.toString();
base_calcul_etp_GUI.text = currendRecordItem.base_calcul_etp.toString();
code_ets_planning_GUI.text = currendRecordItem.code_ets_planning.toString();
code_ent_planning_GUI.text = currendRecordItem.code_ent_planning.toString();
unite_GUI.selectedIndex = currendRecordItem.unite.toString();
coefficient_GUI.text = currendRecordItem.coefficient.toString();
coefficient_base_GUI.text = currendRecordItem.coefficient_base.toString();
coefficient_nombre_GUI.text = currendRecordItem.coefficient_nombre.toString();
coefficient_txs_GUI.text = currendRecordItem.coefficient_txs.toString();
coefficient_txp_GUI.text = currendRecordItem.coefficient_txp.toString();
}
if (tableCode == "RUB") {
user_modified_GUI.selected = (currendRecordItem.user_modified.toString() == "M");
p_cumul_GUI.selected = (currendRecordItem.p_cumul.toString() == "C");
p_detail_GUI.selected = (currendRecordItem.p_detail.toString() == "D");
proratiser_conversion_GUI.selected = (currendRecordItem.proratiser_conversion.toString() == "X");
p_nombre_GUI.selected = (currendRecordItem.p_nombre.toString() == "X");
s_nombre_GUI.selectedIndex = currendRecordItem.s_nombre;
c_nombre_GUI.text = currendRecordItem.c_nombre;
p_base_GUI.selected = (currendRecordItem.p_base.toString() == "X");
s_base_GUI.selectedIndex = currendRecordItem.s_base;
c_base_GUI.text = currendRecordItem.c_base;
p_heures_contrat_GUI.selected = (currendRecordItem.p_heures_contrat.toString() == "X");
s_heures_contrat_GUI.selectedIndex = currendRecordItem.s_heures_contrat;
c_heures_contrat_GUI.text = currendRecordItem.c_heures_contrat;
p_heures_payees_GUI.selected = (currendRecordItem.p_heures_payees.toString() == "X");
s_heures_payees_GUI.selectedIndex = currendRecordItem.s_heures_payees;
c_heures_payees_GUI.text = currendRecordItem.c_heures_payees;
p_heures_travaillees_GUI.selected = (currendRecordItem.p_heures_travaillees.toString() == "X");
s_heures_travaillees_GUI.selectedIndex = currendRecordItem.s_heures_travaillees;
c_heures_travaillees_GUI.text = currendRecordItem.c_heures_travaillees;
p_masse_salariale_GUI.selected = (currendRecordItem.p_masse_salariale.toString() == "X");
s_masse_salariale_GUI.selectedIndex = currendRecordItem.s_masse_salariale;
c_masse_salariale_GUI.text = currendRecordItem.c_masse_salariale;
p_brut_GUI.selected = (currendRecordItem.p_brut.toString() == "X");
s_brut_GUI.selectedIndex = currendRecordItem.s_brut;
c_brut_GUI.text = currendRecordItem.c_brut;
p_avantage_nature_GUI.selected = (currendRecordItem.p_avantage_nature.toString() == "X");
s_avantage_nature_GUI.selectedIndex = currendRecordItem.s_avantage_nature;
c_avantage_nature_GUI.text = currendRecordItem.c_avantage_nature;
p_frais_imposables_GUI.selected = (currendRecordItem.p_frais_imposables.toString() == "X");
s_frais_imposables_GUI.selectedIndex = currendRecordItem.s_frais_imposables;
c_frais_imposables_GUI.text = currendRecordItem.c_frais_imposables;
p_cotisation_salarie_GUI.selected = (currendRecordItem.p_cotisation_salarie.toString() == "X");
s_cotisation_salarie_GUI.selectedIndex = currendRecordItem.s_cotisation_salarie;
c_cotisation_salarie_GUI.text = currendRecordItem.c_cotisation_salarie;
p_cotisation_patronale_GUI.selected = (currendRecordItem.p_cotisation_patronale.toString() == "X");
s_cotisation_patronale_GUI.selectedIndex = currendRecordItem.s_cotisation_patronale;
c_cotisation_patronale_GUI.text = currendRecordItem.c_cotisation_patronale;
p_od_net_salarie_GUI.selected = (currendRecordItem.p_od_net_salarie.toString() == "X");
s_od_net_salarie_GUI.selectedIndex = currendRecordItem.s_od_net_salarie;
c_od_net_salarie_GUI.text = currendRecordItem.c_od_net_salarie;
p_od_net_patronale_GUI.selected = (currendRecordItem.p_od_net_patronale.toString() == "X");
s_od_net_patronale_GUI.selectedIndex = currendRecordItem.s_od_net_patronale;
c_od_net_patronale_GUI.text = currendRecordItem.c_od_net_patronale;
p_net_imposable_GUI.selected = (currendRecordItem.p_net_imposable.toString() == "X");
s_net_imposable_GUI.selectedIndex = currendRecordItem.s_net_imposable;
c_net_imposable_GUI.text = currendRecordItem.c_net_imposable;
p_net_a_payer_GUI.selected = (currendRecordItem.p_net_a_payer.toString() == "X");
s_net_a_payer_GUI.selectedIndex = currendRecordItem.s_net_a_payer;
c_net_a_payer_GUI.text = currendRecordItem.c_net_a_payer;
}
if (tableCode == "ETA") {
setComboSelectedIndex(ETA_finess_id_GUI, currendRecordItem.finess_id)
}
if (tableCode == "TRF") {
setComboSelectedIndex(TRF_date_debut_GUI, currendRecordItem.date_debut)
setComboSelectedIndex(TRF_date_fin_GUI, currendRecordItem.date_fin)
setComboSelectedIndex(TRF_salarie_id_GUI, currendRecordItem.salarie_id)
setComboSelectedIndex(TRF_from_service_id_GUI, currendRecordItem.from_service_id)
setComboSelectedIndex(TRF_to_service_id_GUI, currendRecordItem.to_service_id)
setComboSelectedIndex(TRF_from_qualification_id_GUI, currendRecordItem.from_qualification_id)
setComboSelectedIndex(TRF_to_qualification_id_GUI, currendRecordItem.to_qualification_id)
}
if (tableCode == "PSE") {
setComboSelectedIndex(PSE_service_id_GUI, currendRecordItem.service_id)
}
if (tableCode == "DIV") {
show_info_module_GUI.selected = (currendRecordItem.show_info_module.toString() == "1");
}
if (tableCode == "PQU") {
setComboSelectedIndex(PQU_qualification_id_GUI, currendRecordItem.qualification_id)
}
if (tableCode == "DPR") {
DPR_etablissement_inclus_GUI.text = currendRecordItem.etablissement_inclus;
DPR_etablissement_exclus_GUI.text = currendRecordItem.etablissement_exclus;
DPR_service_inclus_GUI.text = currendRecordItem.service_inclus;
DPR_service_exclus_GUI.text = currendRecordItem.service_exclus;
DPR_statut_inclus_GUI.text = currendRecordItem.statut_inclus;
DPR_statut_exclus_GUI.text = currendRecordItem.statut_exclus;
}
if (tableCode == "POP") {
POP_oid_GUI.text = currendRecordItem.oid.toString();
POP_nbref_GUI.text = currendRecordItem.nbref.toString();
POP_code_GUI.text = currendRecordItem.code.toString();
POP_texte_GUI.text = currendRecordItem.texte.toString();
}
if (tableCode == "PER") {
PER_oid_GUI.text = currendRecordItem.oid.toString();
PER_code_GUI.text = currendRecordItem.code.toString();
PER_texte_GUI.text = currendRecordItem.texte.toString();
PER_priorite_GUI.text = currendRecordItem.priorite.toString();
PER_RH_liste_service_GUI.text = currendRecordItem.liste_service.toString();
PER_RH_liste_specialite_GUI.text = currendRecordItem.liste_specialite.toString();
PER_RH_liste_section_analytique_GUI.text = currendRecordItem.liste_section_analytique.toString();
PER_RH_liste_section_analytique_paie_GUI.text = currendRecordItem.liste_section_analytique_paie.toString();
PER_RH_liste_qualification_GUI.text = currendRecordItem.liste_qualification.toString();
PER_RH_liste_grille_GUI.text = currendRecordItem.liste_grille.toString();
PER_RH_liste_code_emploi_GUI.text = currendRecordItem.liste_code_emploi.toString();
PER_RH_liste_categorie_socio_professionnelle_GUI.text = currendRecordItem.liste_categorie_socio_professionnelle.toString();
PER_RH_liste_statut_GUI.text = currendRecordItem.liste_statut.toString();
PER_RH_liste_finess_GUI.text = currendRecordItem.liste_finess.toString();
PER_RH_liste_etablissement_GUI.text = currendRecordItem.liste_etablissement.toString();
PER_RH_Qliste_service_GUI.selected = PER_RH_liste_service_GUI.text != "" ? true : false;
PER_RH_Qliste_specialite_GUI.selected = PER_RH_liste_specialite_GUI.text != "" ? true : false;
PER_RH_Qliste_section_analytique_GUI.selected = PER_RH_liste_section_analytique_GUI.text != "" ? true : false;
PER_RH_Qliste_section_analytique_paie_GUI.selected = PER_RH_liste_section_analytique_paie_GUI.text != "" ? true : false;
PER_RH_Qliste_qualification_GUI.selected = PER_RH_liste_qualification_GUI.text != "" ? true : false;
PER_RH_Qliste_grille_GUI.selected = PER_RH_liste_grille_GUI.text != "" ? true : false;
PER_RH_Qliste_code_emploi_GUI.selected = PER_RH_liste_code_emploi_GUI.text != "" ? true : false;
PER_RH_Qliste_categorie_socio_professionnelle_GUI.selected = PER_RH_liste_categorie_socio_professionnelle_GUI.text != ""? true : false;
PER_RH_Qliste_statut_GUI.selected = PER_RH_liste_statut_GUI.text != ""? true : false;
PER_RH_Qliste_finess_GUI.selected = PER_RH_liste_finess_GUI.text != "" ? true : false;
PER_RH_Qliste_etablissement_GUI.selected = PER_RH_liste_etablissement_GUI.text != "" ? true : false;
setComboSelectedIndex(PER_population_id_GUI, currendRecordItem.population_id.toString());
}
recordUpdated = false;
if (tableCode == "POP") {
POP_detailBox_GUI.height = 500;
} else if (tableCode == "PER") {
PER_detailBox_GUI.height = 500;
} else if (tableCode == "EXC") {
EXC_detailBox_GUI.height = 500;
} else {
detailBox_GUI.height = 535;
}
}
private function askCancel():void {
if (recordUpdated == false) {
hideRecord();
return;
}
Alert.yesLabel = "OUI";
Alert.noLabel = "NON";
var alert:Alert = Alert.show("Les données ont été changées, désirez vous les annuler ?", title, 3, this, alertClickHandler, question_class);
function alertClickHandler(event:CloseEvent):void {
if (event.detail==Alert.YES) {
hideRecord();
}
}
}
private function hideRecord():void {
if (tableCode == "POP") {
POP_detailBox_GUI.height = 0
} else if (tableCode == "PER") {
PER_detailBox_GUI.height = 0
} else if (tableCode == "EXC") {
EXC_detailBox_GUI.height = 0
if (EXC_mode == 2) {
EXC_mode = 0;
}
}
else {
detailBox_GUI.height = 0
}
currendRecordItem = null;
recordUpdated = false;
}
private function askDelete():void {
Alert.yesLabel = "OUI";
Alert.noLabel = "NON";
var alert:Alert = Alert.show("Désirez vous vraiment supprimer " + texte_GUI.text + " ?", title, 3, this, alertClickHandler, question_class);
function alertClickHandler(event:CloseEvent):void {
if (event.detail==Alert.YES) {
deleteRecord()
}
}
}
public function deleteRecord():void {
updateRecord("delete");
}
private function askPurge():void {
var alert:Alert;
Alert.yesLabel = "OUI";
Alert.noLabel = "NON";
if (currendRecordItem == null) {
Alert.show("Désirez vous vraiment supprimer l'historique de TOUS les contrôles experts ?", title, 3, this, alertClickHandler, question_class);
}
else {
Alert.show("Désirez vous vraiment supprimer l'historique de " + EXC_texte_GUI.text + " ?", title, 3, this, alertClickHandler, question_class);
}
function alertClickHandler(event:CloseEvent):void {
if (event.detail == Alert.YES) {
purgeHistory();
}
}
}
public function purgeHistory():void {
updateRecord("purge_history");
}
public function copyRecord():void {
updateRecord("copy");
}
public function saveRecord():void {
updateRecord("save");
}
public function updateRecord(action:String):void {
var urlVariables:URLVariables = new URLVariables()
urlVariables.tableName = tableName;
urlVariables.action = action;
urlVariables.softCode = softCode;
var recordNode:XML = new XML();
recordNode.@oid = oid_GUI.text;
recordNode.@code = code_GUI.text;
recordNode.@texte = texte_GUI.text;
recordNode.@texte_court = texte_court_GUI.text;
recordNode.@valeur = valeur_GUI.text;
recordNode.@valeur_date = valeur_date_GUI.text;
recordNode.@show_info_module = (show_info_module_GUI.selected ? "1" : "0");
recordNode.@code_original = code_original_GUI.text;
recordNode.@code_calcul = code_calcul_GUI.selectedIndex;
recordNode.@base_calcul_etp = base_calcul_etp_GUI.text;
recordNode.@code_ets_planning = code_ets_planning_GUI.text;
recordNode.@code_ent_planning = code_ent_planning_GUI.text;
recordNode.@unite = unite_GUI.selectedIndex;
recordNode.@coefficient = coefficient_GUI.text;
recordNode.@coefficient_base = coefficient_base_GUI.text;
recordNode.@coefficient_nombre = coefficient_nombre_GUI.text;
recordNode.@coefficient_txs = coefficient_txs_GUI.text;
recordNode.@coefficient_txp = coefficient_txp_GUI.text;
recordNode.@user_modified = (user_modified_GUI.selected ? "M" : "");
recordNode.@p_cumul = (p_cumul_GUI.selected ? "C" : "");
recordNode.@p_detail = (p_detail_GUI.selected ? "D" : "");
recordNode.@proratiser_conversion = (proratiser_conversion_GUI.selected ? "X" : "");
recordNode.@p_nombre = (p_nombre_GUI.selected ? "X" : "");
recordNode.@s_nombre = s_nombre_GUI.selectedIndex;
recordNode.@c_nombre = c_nombre_GUI.text;
recordNode.@p_base = (p_base_GUI.selected ? "X" : "");
recordNode.@s_base = s_base_GUI.selectedIndex;
recordNode.@c_base = c_base_GUI.text;
recordNode.@p_heures_contrat = (p_heures_contrat_GUI.selected ? "X" : "");
recordNode.@s_heures_contrat = s_heures_contrat_GUI.selectedIndex;
recordNode.@c_heures_contrat = c_heures_contrat_GUI.text;
recordNode.@p_heures_payees = (p_heures_payees_GUI.selected ? "X" : "");
recordNode.@s_heures_payees = s_heures_payees_GUI.selectedIndex;
recordNode.@c_heures_payees = c_heures_payees_GUI.text;
recordNode.@p_heures_travaillees = (p_heures_travaillees_GUI.selected ? "X" : "");
recordNode.@s_heures_travaillees = s_heures_travaillees_GUI.selectedIndex;
recordNode.@c_heures_travaillees = c_heures_travaillees_GUI.text;
recordNode.@p_masse_salariale = (p_masse_salariale_GUI.selected ? "X" : "");
recordNode.@s_masse_salariale = s_masse_salariale_GUI.selectedIndex;
recordNode.@c_masse_salariale = c_masse_salariale_GUI.text;
recordNode.@p_brut = (p_brut_GUI.selected ? "X" : "");
recordNode.@s_brut = s_brut_GUI.selectedIndex;
recordNode.@c_brut = c_brut_GUI.text;
recordNode.@p_avantage_nature = (p_avantage_nature_GUI.selected ? "X" : "");
recordNode.@s_avantage_nature = s_avantage_nature_GUI.selectedIndex;
recordNode.@c_avantage_nature = c_avantage_nature_GUI.text;
recordNode.@p_frais_imposables = (p_frais_imposables_GUI.selected ? "X" : "");
recordNode.@s_frais_imposables = s_frais_imposables_GUI.selectedIndex;
recordNode.@c_frais_imposables = c_frais_imposables_GUI.text;
recordNode.@p_cotisation_salarie = (p_cotisation_salarie_GUI.selected ? "X" : "");
recordNode.@s_cotisation_salarie = s_cotisation_salarie_GUI.selectedIndex;
recordNode.@c_cotisation_salarie = c_cotisation_salarie_GUI.text;
recordNode.@p_cotisation_patronale = (p_cotisation_patronale_GUI.selected ? "X" : "");
recordNode.@s_cotisation_patronale = s_cotisation_patronale_GUI.selectedIndex;
recordNode.@c_cotisation_patronale = c_cotisation_patronale_GUI.text;
recordNode.@p_od_net_salarie = (p_od_net_salarie_GUI.selected ? "X" : "");
recordNode.@s_od_net_salarie = s_od_net_salarie_GUI.selectedIndex;
recordNode.@c_od_net_salarie = c_od_net_salarie_GUI.text;
recordNode.@p_od_net_patronale = (p_od_net_patronale_GUI.selected ? "X" : "");
recordNode.@s_od_net_patronale = s_od_net_patronale_GUI.selectedIndex;
recordNode.@c_od_net_patronale = c_od_net_patronale_GUI.text;
recordNode.@p_net_imposable = (p_net_imposable_GUI.selected ? "X" : "");
recordNode.@s_net_imposable = s_net_imposable_GUI.selectedIndex;
recordNode.@c_net_imposable = c_net_imposable_GUI.text;
recordNode.@p_net_a_payer = (p_net_a_payer_GUI.selected ? "X" : "");
recordNode.@s_net_a_payer = s_net_a_payer_GUI.selectedIndex;
recordNode.@c_net_a_payer = c_net_a_payer_GUI.text;
if (tableCode == "ETA") {
recordNode.@finess_id = ETA_finess_id_GUI.selectedItem.@oid
}
if (tableCode == "TRF") {
recordNode.@date_debut = TRF_date_debut_GUI.selectedItem.@oid
recordNode.@date_fin = TRF_date_fin_GUI.selectedItem.@oid
recordNode.@salarie_id = TRF_salarie_id_GUI.selectedItem.@oid
recordNode.@from_service_id = TRF_from_service_id_GUI.selectedItem.@oid
recordNode.@to_service_id = TRF_to_service_id_GUI.selectedItem.@oid
recordNode.@from_qualification_id = TRF_from_qualification_id_GUI.selectedItem.@oid
recordNode.@to_qualification_id = TRF_to_qualification_id_GUI.selectedItem.@oid
}
if (tableCode == "PSE") {
recordNode.@service_id = PSE_service_id_GUI.selectedItem.@oid
}
if (tableCode == "PQU") {
recordNode.@qualification_id = PQU_qualification_id_GUI.selectedItem.@oid
}
if (tableCode == "DPR") {
recordNode.@etablissement_inclus = DPR_etablissement_inclus_GUI.text
recordNode.@etablissement_exclus = DPR_etablissement_exclus_GUI.text
recordNode.@service_inclus = DPR_service_inclus_GUI.text
recordNode.@service_exclus = DPR_service_exclus_GUI.text
recordNode.@statut_inclus = DPR_statut_inclus_GUI.text
recordNode.@statut_exclus = DPR_statut_exclus_GUI.text
}
if (tableCode == "POP") {
recordNode.@oid = POP_oid_GUI.text
recordNode.@code = POP_code_GUI.text
recordNode.@texte = POP_texte_GUI.text
}
if (tableCode == "PER") {
recordNode.@oid = PER_oid_GUI.text
recordNode.@code = PER_code_GUI.text
recordNode.@texte = PER_texte_GUI.text
recordNode.@priorite = PER_priorite_GUI.text
recordNode.@liste_service = PER_RH_liste_service_GUI.text
recordNode.@liste_specialite = PER_RH_liste_specialite_GUI.text
recordNode.@liste_section_analytique = PER_RH_liste_section_analytique_GUI.text
recordNode.@liste_section_analytique_paie = PER_RH_liste_section_analytique_paie_GUI.text
recordNode.@liste_qualification = PER_RH_liste_qualification_GUI.text
recordNode.@liste_grille = PER_RH_liste_grille_GUI.text
recordNode.@liste_code_emploi = PER_RH_liste_code_emploi_GUI.text
recordNode.@liste_categorie_socio_professionnelle = PER_RH_liste_categorie_socio_professionnelle_GUI.text
recordNode.@liste_statut = PER_RH_liste_statut_GUI.text
recordNode.@liste_finess = PER_RH_liste_finess_GUI.text
recordNode.@liste_etablissement = PER_RH_liste_etablissement_GUI.text
recordNode.@population_id = PER_population_id_GUI.selectedItem.@oid;
}
if (tableCode == "EXC") {
// Controles normaux
if (EXC_mode == 0) {
recordNode.@mode = EXC_mode;
recordNode = readFields(new Array(
"oid", "code", "texte", "texte_court", "texte_abrege", "description",
"rule_oid1", "sqlcmd_where1", "sqlcmd_justificatif1",
"prestataire",
"gravite", "table1",
"is_active","is_alert", "is_hide", "is_cti"
), recordNode);
}
// Paramètres généraux
if (EXC_mode == 2) {
recordNode.@mode = EXC_mode;
recordNode.@EXPERT_ACTIVE = EXC_EXPERT_ACTIVE_GUI.selected == true ? "1" : "0";
recordNode.@EXPERT_DATE_DEBUT = EXC_EXPERT_DATE_DEBUT_GUI.text;
EXC_mode = 0;
}
}
urlVariables.recordNode = recordNode.toXMLString();
CTI_Utilitaires.startRequestHTTP("modules/rh/php/httpService_tablesManager_setData.php",urlVariables,exec,true,this.parentApplication)
function exec(resultatService:XML):void {
getData();
if (tableCode == "POP") {
POP_detailBox_GUI.height = 0
} else if (tableCode == "PER") {
PER_detailBox_GUI.height = 0
} else if (tableCode == "EXC") {
EXC_detailBox_GUI.height = 0
} else {
detailBox_GUI.height = 0
}
currendRecordItem = null;
recordUpdated = false;
}
}
public function print():void {
var printReport:CTI_Print = new CTI_Print();
if (printReport.start("RH_TablesManager", titlePrint) == false) {
return;
}
printReport.addAdvancedDataGrid(list_GUI)
printReport.print();
}
public function exportExcel():void {
var xml:XML = new XML();
var ongletNode:XML;
var similiTabNode:XML;
var selectionsNode:XML;
var datagridNode:XML;
var columnNode:XML;
var dataNode:XML;
var rowNode:XML;
xml.@viewName = this.viewName;
xml.@title = this.title;
selectionsNode = new XML();
selectionsNode.displayText = "";
if (refSearch_GUI.selected == true) {
selectionsNode.@displayText = selectionsNode.displayText + "Uniquement les codes référencés. ";
}
if (textSearch_GUI.text != "") {
selectionsNode.@displayText = selectionsNode.displayText + "(Filtre : " + textSearch_GUI.text + ") ";
}
xml.appendChild(selectionsNode);
ongletNode = new XML();
ongletNode.@excelLabel = tableCode;
xml.appendChild(ongletNode);
similiTabNode = new XML();
similiTabNode.@excelLabel = "Liste";
ongletNode.appendChild(similiTabNode);
datagridNode = new XML();
datagridNode.@total = "false";
ongletNode.appendChild(datagridNode);
for each (var column:AdvancedDataGridColumn in list_GUI.columns) {
columnNode = new XML();
columnNode.@dataField = column.dataField;
columnNode.@headerText = column.headerText;
columnNode.@type = "Char";
columnNode.@textAlign = column.getStyle("textAlign");
datagridNode.appendChild(columnNode);
}
dataNode = new XML();
similiTabNode.appendChild(dataNode);
for each (var itemNode:Object in list_collection) {
if (itemNode.oid != "-1") {
rowNode = new XML(
)
var c:int = 0;
for each (column in list_GUI.columns) {
c++;
rowNode.@["c" + c.toString()] = itemNode[column.dataField]
}
dataNode.appendChild(rowNode);
}
}
CTI_ExcelUtilitaires.exportExcel(xml);
}
public function exportPDF():void {
var xml:XML = new XML();
var ongletNode:XML;
var selectionsNode:XML;
var datagridNode:XML;
var columnNode:XML;
var dataNode:XML;
var rowNode:XML;
xml.@viewName = this.viewName;
xml.@title = this.title;
selectionsNode = new XML();
selectionsNode.displayText = "";
if (refSearch_GUI.selected == true) {
selectionsNode.displayText = selectionsNode.displayText + "Uniquement les codes référencés. ";
}
if (textSearch_GUI.text != "") {
selectionsNode.displayText = selectionsNode.displayText + "(Filtre : " + textSearch_GUI.text + ") ";
}
xml.appendChild(selectionsNode);
ongletNode = new XML();
ongletNode.@excelLabel = tableCode;
xml.appendChild(ongletNode);
datagridNode = new XML();
datagridNode.@total = "false";
ongletNode.appendChild(datagridNode);
for each (var column:AdvancedDataGridColumn in list_GUI.columns) {
columnNode = new XML();
columnNode.@dataField = column.dataField;
columnNode.@headerText = column.headerText;
columnNode.@type = "Char";
columnNode.@textAlign = column.getStyle("textAlign");
datagridNode.appendChild(columnNode);
}
dataNode = new XML();
ongletNode.appendChild(dataNode);
for each (var itemNode:Object in list_collection) {
if (itemNode.oid != "-1") {
rowNode = new XML(
)
var c:int = 0;
for each (column in list_GUI.columns) {
c++;
rowNode.@["c" + c.toString()] = itemNode[column.dataField]
}
dataNode.appendChild(rowNode);
}
}
CTI_PDFUtilitaires.exportPDF(xml);
xml = null;
}
public function copyRefSettings():void {
var urlVariables:URLVariables = new URLVariables();
urlVariables.tableName = tableName;
urlVariables.oids = "";
for each (var item:Object in ref_list_collection) {
if (item.selected == "1") {
if (urlVariables.oids != "") {
urlVariables.oids = urlVariables.oids + ", ";
}
urlVariables.oids = urlVariables.oids + item.oid;
}
}
if (urlVariables.oids == "") {
CTI_Utilitaires.alert_error("Import de données", "Vous devez d'abord choisir les données à récupérer");
return;
}
CTI_Utilitaires.startRequestHTTP("modules/rh/php/httpService_RH_tableManager_copyRef.php", urlVariables, exec, true, this.parentApplication);
function exec(resultatService:XML):void {
getData();
detailBox_GUI.visible = false;
detailBox_GUI.includeInLayout = false;
currendRecordItem = null;
toggleUpdate(false);
}
}
private function setComboSelectedIndex(cb:Object, str:String):void {
for (var idx:int = 0; idx < cb.dataProvider.length; idx++){
if (cb.dataProvider.getItemAt(idx).@oid == str){
cb.selectedIndex = idx;
}
}
}
private function setSelectedIndex(cb:Object, str:String, field:String='data'):void {
for (var idx:int = 0, len:int = cb.dataProvider.length; idx < len; idx++) {
if (cb.dataProvider.getItemAt(idx)[field] == str) {
cb.selectedIndex = idx;
}
}
}
private function fillFields(fields:Array):void {
var dobj:DisplayObject;
var field:String;
for each (field in fields) {
dobj = findChild(EXC_detailBox_GUI, tableCode + "_" + field + "_GUI");
if (dobj is RichTextEditor) {
if (currendRecordItem[field].toString() != "") {
(dobj as RichTextEditor).htmlText = CTI_Utilitaires.uncompress64(currendRecordItem[field].toString());
}
else {
(dobj as RichTextEditor).htmlText = "";
}
}
else if (dobj is TextArea) {
(dobj as TextArea).text = currendRecordItem[field].toString();
}
else if (dobj is DateField) {
(dobj as DateField).selectedDate = DateField.stringToDate(currendRecordItem[field].toString(), 'DD/MM/YYYY');
}
else if (dobj is CheckBox) {
(dobj as CheckBox).selected = currendRecordItem[field].toString() == "1" ? true : false;
}
}
dobj = null;
}
private function readFields(fields:Array, recordNode:XML):XML {
var dobj:DisplayObject;
var field:String;
for each (field in fields) {
dobj = findChild(EXC_detailBox_GUI, tableCode + "_" + field + "_GUI");
if (dobj is RichTextEditor) {
if ((dobj as RichTextEditor).text != "") {
recordNode.@[field] = CTI_Utilitaires.compress64((dobj as RichTextEditor).htmlText);
}
else {
recordNode.@[field] = "";
}
}
else if (dobj is TextArea) {
recordNode.@[field] = (dobj as TextArea).text;
}
else if (dobj is DateField) {
recordNode.@[field] = DateField.dateToString((dobj as DateField).selectedDate, 'DD/MM/YYYY');
}
else if (dobj is ComboBox) {
recordNode.@[field] = (dobj as ComboBox).selectedItem.data;
}
else if (dobj is CheckBox) {
recordNode.@[field] = (dobj as CheckBox).selected ? "1" : "0";
}
}
dobj = null;
return recordNode;
}
private function EXC_show_generalSettings():void {
EXC_mode = 2;
detailBox_GUI.visible = true;
detailBox_GUI.includeInLayout = true;
}
public function EXC_execute_rules(controle_id:String=null):void {
var urlVariables:URLVariables = new URLVariables()
urlVariables.tableName = tableName;
urlVariables.action = 'execute_rules';
if (controle_id != null) {
urlVariables.oids = controle_id
}
else {
urlVariables.oids = "";
// for each (var item:Object in list_collection) {
// if (item.selected == "1") {
// if (urlVariables.oids != "") {
// urlVariables.oids = urlVariables.oids + ", "
// }
// urlVariables.oids = urlVariables.oids + item.oid
// }
// }
}
CTI_Utilitaires.startRequestHTTP("modules/rh/php/RH_setTableRecord.php", urlVariables, exec, true, this.parentApplication);
function exec(resultatService:XML):void {
if (resultatService.RETURN.@code.toString() != "KO") {
CTI_Utilitaires.alert_info("Exécution règles Expert", "Exécution terminée : " + resultatService.RETURN.@message.toString());
}
else {
CTI_Utilitaires.alert_error("Exécution règles Expert", "Exécution terminée avec ERREURS : " + resultatService.RETURN.@message.toString());
}
getData();
detailBox_GUI.visible = false
detailBox_GUI.includeInLayout = false
currendRecordItem = null;
recordUpdated = false;
}
}
public function EXC_getSQL(controle_id:String=null):void {
var urlVariables:URLVariables = new URLVariables();
urlVariables.tableName = tableName;
if (controle_id != null) {
urlVariables.oids = controle_id;
}
else {
urlVariables.oids = "";
for each (var item:Object in list_collection) {
if (item.selected == "1") {
if (urlVariables.oids != "") {
urlVariables.oids = urlVariables.oids + ", ";
}
urlVariables.oids = urlVariables.oids + item.oid;
}
}
}
if (urlVariables.oids == "") {
CTI_Utilitaires.alert_error("Export SQL", "Vous devez d'abord choisir les contrôles à exporter");
return;
}
// @todo
CTI_Utilitaires.openURL("modules/rh/php/httpService_RH_tableManager_getSqlScript.php", urlVariables, "iCTI_expert_controle.SQL");
}
/**
* Fonction qui cherche un displayObject par son nom dans toute l'arboresence d'un
* container. Cette fonction supplante la fonction getChildByName dans le sens où elle
* ne se cantonne pas au premier niveau de l'arboresence mais inspecte tous les niveaux
*
* @param container Container dans lequel chercher l'enfant
* @param childname Nom de l'enfant à chercher
* @return L'élement trouvé dans l'arborescence
*/
private function findChild(container:DisplayObjectContainer, childname:String ):DisplayObject {
if (container == null) {
container = this;
}
for (var j:int = 0; j < container.numChildren; ++j) {
var obj:DisplayObject = container.getChildAt(j) as DisplayObject;
if (obj.name == childname) {
return obj;
}
if (obj is DisplayObjectContainer) {
var doc:DisplayObjectContainer = obj as DisplayObjectContainer;
if (doc.numChildren > 0) {
var ret:DisplayObject = findChild( doc, childname );
if (ret != null) {
return ret;
}
}
}
}
return null;
}
public function toggleUpdate(value:Boolean):void {
recordUpdated = value;
}
public function PER_execute_regles():void {
var urlVariables:URLVariables = new URLVariables()
urlVariables.tableName = tableName;
urlVariables.softCode = softCode
urlVariables.action = 'PER_execute_regles';
CTI_Utilitaires.startRequestHTTP("modules/rh/php/httpService_tablesManager_setData.php", urlVariables, exec, true, this.parentApplication);
function exec(resultatService:XML):void {
getData();
}
}
public function getRefSettings():void {
detailBox_GUI.visible = false;
detailBox_GUI.includeInLayout = false;
qimport = true;
}
public function hideRefSettings():void {
detailBox_GUI.visible = true;
detailBox_GUI.includeInLayout = true;
qimport = false;
}
]]>