"; $q = entites::list_biblio($user_userid); $res = mysql_query($q, $dbh); $nbr = mysql_num_rows($res); if(!$nbr) { //Pas d'etablissements définis pour l'utilisateur $error = true; $error_msg.= htmlentities($msg["acquisition_err_coord"],ENT_QUOTES, $charset)."

"; } if ($error) { error_message($msg[321], $error_msg.htmlentities($msg["acquisition_err_par"],ENT_QUOTES, $charset), '1', './admin.php?categ=acquisition'); die; } if ($nbr == '1') { $row = mysql_fetch_object($res); show_list_exer($row->id_entite); } else { $parity=1; while($row=mysql_fetch_object($res)){ if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=compta&action=list&ent=$row->id_entite';\" "; $aff.= "$row->raison_sociale"; } $aff.= ""; print $aff; } } function show_list_exer($id_entite) { global $dbh; global $msg; global $charset; $biblio = new entites($id_entite); print "

".htmlentities($biblio->raison_sociale,ENT_QUOTES,$charset)."

"; print ""; $q = exercices::listByEntite($id_entite); $res = mysql_query($q, $dbh); $nbr = mysql_num_rows($res); $parity=1; for($i=0;$i<$nbr;$i++) { $row=mysql_fetch_object($res); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=compta&action=modif&ent=$row->num_entite&id=$row->id_exercice';\" "; print ""; } print "

".htmlentities($msg[103],ENT_QUOTES,$charset)."	".htmlentities($msg[calendrier_date_debut],ENT_QUOTES,$charset)."	".htmlentities($msg[calendrier_date_fin],ENT_QUOTES,$charset)."	".htmlentities($msg[acquisition_statut],ENT_QUOTES,$charset)."
".htmlentities($row->libelle, ENT_QUOTES, $charset)."	".formatdate($row->date_debut)."	".formatdate($row->date_fin)."	"; switch ($row->statut) { case STA_EXE_CLO : print htmlentities($msg['acquisition_statut_clot'],ENT_QUOTES,$charset); break; case STA_EXE_DEF : print htmlentities($msg['acquisition_statut_def'],ENT_QUOTES,$charset); break; default : print htmlentities($msg['acquisition_statut_actif'],ENT_QUOTES,$charset); break; } print "

"; //Affichage du bouton d'ajout print ""; } function show_exer_form($id_entite, $id_exer=0) { global $msg; global $charset; global $exer_form, $date_deb_mod, $date_fin_mod; global $ptab; $exer_form = str_replace('!!id_entite!!', $id_entite, $exer_form); $exer_form = str_replace('!!id_exer!!', $id_exer, $exer_form); if(!$id_exer) { $exer_form = str_replace('!!form_title!!', htmlentities($msg[acquisition_ajout_exer],ENT_QUOTES,$charset), $exer_form); $exer_form = str_replace('!!libelle!!', '', $exer_form); $exer_form = str_replace('!!date_deb!!', $date_deb_mod, $exer_form); $exer_form = str_replace('!!date_deb!!', '', $exer_form); $exer_form = str_replace('!!date_fin!!', $date_fin_mod, $exer_form); $exer_form = str_replace('!!date_fin!!', '', $exer_form); $exer_form = str_replace('!!statut!!', htmlentities($msg[acquisition_statut_actif], ENT_QUOTES, $charset), $exer_form); } else { $exer = new exercices($id_exer); $exer_form = str_replace('!!form_title!!', htmlentities($msg[acquisition_modif_exer],ENT_QUOTES,$charset), $exer_form); $exer_form = str_replace('!!libelle!!', htmlentities($exer->libelle,ENT_QUOTES,$charset), $exer_form); if (exercices::hasBudgets($id_exer) || exercices::hasActes($id_exer)) { $exer_form = str_replace('!!date_deb!!', formatdate($exer->date_debut), $exer_form); $exer_form = str_replace('!!date_fin!!', formatdate($exer->date_fin), $exer_form); } else { $exer_form = str_replace('!!date_deb!!', $date_deb_mod, $exer_form); $exer_form = str_replace('!!date_deb!!', formatdate($exer->date_debut), $exer_form); $exer_form = str_replace('!!date_fin!!', $date_fin_mod, $exer_form); $exer_form = str_replace('!!date_fin!!', formatdate($exer->date_fin), $exer_form); } switch ($exer->statut) { case STA_EXE_CLO : $ms = $msg['acquisition_statut_clot']; $aff_bt_def = FALSE; break; case STA_EXE_DEF : $ms = $msg['acquisition_statut_def']; $aff_bt_def = FALSE; break; default : $ms = $msg['acquisition_statut_actif']; $aff_bt_def = TRUE; break; } $exer_form = str_replace('!!statut!!', htmlentities($ms,ENT_QUOTES,$charset), $exer_form); if ($aff_bt_def) { $exer_form = str_replace('', $ptab[2], $exer_form); } else { $exer_form = str_replace('', '', $exer_form); } $ptab = str_replace('!!id!!', $id_exer, $ptab); $ptab = str_replace('!!libelle_suppr!!', addslashes($exer->libelle), $ptab); //Affichage du bouton de cloture if($exer->statut != STA_EXE_CLO) { $exer_form = str_replace('', $ptab[0], $exer_form); } $exer_form = str_replace('', $ptab[1], $exer_form); } print confirmation_suppression("./admin.php?categ=acquisition&sub=compta&action=del&ent=".$id_entite."&id="); print confirmation_cloture("./admin.php?categ=acquisition&sub=compta&action=clot&ent=".$id_entite."&id="); $biblio = new entites($id_entite); print "

".htmlentities($biblio->raison_sociale,ENT_QUOTES,$charset)."

"; print $exer_form; } function confirmation_cloture($url) { global $msg; return ""; } function confirmation_suppression($url) { global $msg; return ""; } ?> 0 ) { error_form_message($libelle.$msg["acquisition_compta_already_used"]); break; } if ($date_deb && $date_fin) { //Vérification des dates //Format date début et format date fin $deb = extraitdate($date_deb); $fin = extraitdate($date_fin); $ex_deb = explode('-', $deb); $ex_fin = explode('-', $fin); if ( $deb=='' || $fin=='' || strlen($ex_deb[0])<>4 || strlen($ex_fin[0])<>4 || !checkdate($ex_deb[1], $ex_deb[2], $ex_deb[0]) || !checkdate($ex_fin[1], $ex_fin[2], $ex_fin[0]) ) { error_form_message($libelle.$msg["acquisition_compta_date_inv"]); break; } //Date fin > date début if ( ($ex_deb[0] > $ex_fin[0]) || ( ($ex_deb[0] == $ex_fin[0]) && ($ex_deb[1] > $ex_fin[1]) ) || ( ($ex_deb[0] == $ex_fin[0]) && ($ex_deb[1] == $ex_fin[1]) && ($ex_deb[2] >= $ex_fin[2]) ) ) { error_form_message($libelle.$msg["acquisition_compta_date_inf"]); break; } //A voir , Pas de recoupements entre exercices } $ex = new exercices($id); $ex->libelle = $libelle; $ex->num_entite = $ent; if ($date_deb && $date_fin) { $ex->date_debut = $deb; $ex->date_fin = $fin; } $ex->save(); if ($def) $ex->setDefault(); show_list_exer($ent); break; case 'del': if($id) { $total1 = exercices::hasBudgetsActifs($id); $total2 = exercices::hasActesACtifs($id); if (($total1+$total2)==0) { exercices::delete($id); show_list_exer($ent); } else { $msg_suppr_err = $msg[acquisition_compta_used] ; if ($total1) $msg_suppr_err .= "
- ".$msg[acquisition_compta_used_bud] ; if ($total2) $msg_suppr_err .= "
- ".$msg[acquisition_compta_used_act] ; error_message($msg[321], $msg_suppr_err, 1, 'admin.php?categ=acquisition&sub=compta&action=list&ent='.$ent); } } else { show_list_exer($ent); } break; case 'clot': //On vérifie que tous les budgets sont cloturés et toutes les commandes archivées if($id) { $total1 = exercices::hasBudgetsActifs($id); $total2 = exercices::hasActesActifs($id); if (($total1+$total2)==0) { $ex = new exercices($id); $ex->statut='0'; $ex->save(); show_list_exer($ent); } else { $msg_suppr_err = $msg[acquisition_compta_actif] ; if ($total1) $msg_suppr_err .= "
- ".$msg[acquisition_compta_used_bud] ; if ($total2) $msg_suppr_err .= "
- ".$msg[acquisition_compta_used_act] ; error_message($msg[321], $msg_suppr_err, 1, 'admin.php?categ=acquisition&sub=compta&action=list&ent='.$ent); } } else { show_list_exer($ent); } break; default: show_list_biblio(); break; } ?>