#
# spec file for ASP Lycee program
# (c) 2004 IMC
#

# Existing macros ?
%define _htmldir /var/www/html

# Basic macros
%define grade    Lyc
%define gradeid  lyc
%define withswf  0
%define name     asp-not_%{gradeid}_demo_noswf
%define version  1.0.0
%define release  %mkrel 5
%define titlePrg Synthèse de cours
%define titleEva Tests d'évaluation
%define abstract Database for ASP program

# Standard EduPack menu-file macros
%define m_teacher  00. Poste de travail de l'enseignant
%define m_mat_soft 10. Maternelle : Logiciels
%define m_mat_ps   11. Maternelle : Ressources PS
%define m_mat_ms   12. Maternelle : Ressources MS
%define m_mat_gs   13. Maternelle : Ressources GS
%define m_pri_soft 20. École primaire : Logiciels
%define m_pri_cp   21. École primaire : Ressources CP
%define m_pri_ce1  22. École primaire : Ressources CE1
%define m_pri_ce2  23. École primaire : Ressources CE2
%define m_pri_cm1  24. École primaire : Ressources CM1
%define m_pri_cm2  25. École primaire : Ressources CM2
%define m_col_soft 30. Collège : Logiciels
%define m_col_6    31. Collège : Ressources 6e
%define m_col_5    32. Collège : Ressources 5e
%define m_col_4    33. Collège : Ressources 4e
%define m_col_3    34. Collège : Ressources 3e
%define m_lyc_soft 40. Lycée : Logiciels
%define m_lyc_2    41. Lycée : Ressources Seconde
%define m_lyc_1    42. Lycée : Ressources Première
%define m_lyc_T    43. Lycée : Ressources Terminale
%define m_mmedia   Multimédia
%define m_office   Bureautique
%define m_organize Organisation
%define m_sciences Sciences
%define m_web_use  Internet : Utilisation
%define m_web_cre  Internet : Création
%define m_M        Mathématiques
%define m_MS       Mathématiques série S
%define m_ME       Mathématiques série ES
%define m_ML       Mathématiques série L
%define m_F        Français
%define m_P        Physique
%define m_C        Chimie
%define m_PC       Physique - Chimie
%define m_T        S.V.T.
%define m_W        Enseignement scientifique
%define m_H        Histoire
%define m_G        Géographie
%define m_I        Philosophie
%define m_E        Éducation civique
%define m_D        Découverte du monde
%define m_SE       S.E.S.
%define m_A        Anglais
%define m_AL       Allemand
%define m_ES       Espagnol
%define m_edupack  PACKS Éducatifs libres


Name:            %name
Summary:         %abstract
Version:         %version
Release:         %release
License:         GFDL
Group:           Education
URL:             http://www.ruedesecoles.com/EduPack
Buildarch:       noarch
BuildRoot:       %{_tmppath}/%{name}-buildroot
Requires:        asp 
Provides:        asp-not_%{gradeid}_ti asp-not_%{gradeid}_1me
%if %withswf
Requires:        FlashPlayer
%endif

Source0:         http://www.ruedesecoles.com/EduPack/%name-%version.tar.bz2

%description
Database for ASP Lycée program.

%prep

%setup -q

%install
rm -rf %buildroot
mkdir -p %buildroot/%_liconsdir
mkdir -p %buildroot/%_iconsdir
mkdir -p %buildroot/%_miconsdir
mkdir -p %buildroot/%_htmldir/Asp/Data/Base
%if %withswf
cp -r Swf %buildroot/%_htmldir/Asp/
%endif
install -m 644 Mysql/*.sql  %buildroot/%_htmldir/Asp/Data/Base/

# Menu icons
install -m 644 Icons/asp-prog_%{gradeid}48.png %buildroot/%_liconsdir/asp-prog_%gradeid.png
install -m 644 Icons/asp-eval_%{gradeid}48.png %buildroot/%_liconsdir/asp-eval_%gradeid.png
install -m 644 Icons/asp-prog_%{gradeid}32.png %buildroot/%_iconsdir/asp-prog_%gradeid.png
install -m 644 Icons/asp-eval_%{gradeid}32.png %buildroot/%_iconsdir/asp-eval_%gradeid.png
install -m 644 Icons/asp-prog_%{gradeid}16.png %buildroot/%_miconsdir/asp-prog_%gradeid.png
install -m 644 Icons/asp-eval_%{gradeid}16.png %buildroot/%_miconsdir/asp-eval_%gradeid.png

# Menu entries
mkdir -p %buildroot/%_menudir/simplified
cat > %buildroot/%_menudir/%name << EOF
?package(%name): command="konqueror --profile webbrowsing http://localhost/Asp/Application/EduPack/program.php?Module=1E_ME" \
needs="X11" icon="asp-prog_%gradeid.png" section="%m_edupack/%m_lyc_1/%m_ME" title="%titlePrg"
?package(%name): command="konqueror --profile webbrowsing http://localhost/Asp/Application/EduPack/eval.php?Module=1E_ME" \
needs="X11" icon="asp-eval_%gradeid.png" section="%m_edupack/%m_lyc_1/%m_ME" title="%titleEva"

?package(%name): command="konqueror --profile webbrowsing http://localhost/Asp/Application/EduPack/program.php?Module=T_I" \
needs="X11" icon="asp-prog_%gradeid.png" section="%m_edupack/%m_lyc_T/%m_I" title="%titlePrg"
?package(%name): command="konqueror --profile webbrowsing http://localhost/Asp/Application/EduPack/eval.php?Module=T_I" \
needs="X11" icon="asp-eval_%gradeid.png" section="%m_edupack/%m_lyc_T/%m_I" title="%titleEva"
EOF

cp  %buildroot/%_menudir/%name %buildroot/%_menudir/simplified/.

%pre
# if mysqld is not running, start it
echo "Check if mysqld is running"
if ! test -f /var/lib/mysql/mysql.sock
then /sbin/service mysql start
sleep 2
fi

%post
%update_menus
%_bindir/mysqladmin create Notions%grade
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_clip.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_glossary.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_image.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_level.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_link.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_sheet.sql"
%_bindir/mysql Notions%grade < %_htmldir/Asp/Data/Base/notions_%gradeid"_test.sql"
rm %_htmldir/Asp/Data/Base/{notions_%gradeid"_clip",notions_%gradeid"_glossary",notions_%gradeid"_image",notions_%gradeid"_level"}.sql
rm %_htmldir/Asp/Data/Base/{notions_%gradeid"_link",notions_%gradeid"_sheet",notions_%gradeid"_test"}.sql

%preun
# if mysqld is not running, start it
echo "Check if mysqld is running"
if ! test -f /var/lib/mysql/mysql.sock
then /sbin/service mysql start
sleep 2
fi

%postun
%clean_menus
%_bindir/mysqladmin --force drop Notions%grade

%clean
rm -rf %buildroot

%files
%defattr(0644,root,root,0755)
%_htmldir/Asp/Data/Base/notions_lyc_clip.sql
%_htmldir/Asp/Data/Base/notions_lyc_glossary.sql
%_htmldir/Asp/Data/Base/notions_lyc_image.sql
%_htmldir/Asp/Data/Base/notions_lyc_level.sql
%_htmldir/Asp/Data/Base/notions_lyc_link.sql
%_htmldir/Asp/Data/Base/notions_lyc_sheet.sql
%_htmldir/Asp/Data/Base/notions_lyc_test.sql

%_iconsdir/asp-eval_lyc.png
%_iconsdir/asp-prog_lyc.png
%_liconsdir/asp-eval_lyc.png
%_liconsdir/asp-prog_lyc.png
%_miconsdir/asp-eval_lyc.png
%_miconsdir/asp-prog_lyc.png

%_menudir/%name
%_menudir/simplified/%name

%changelog
* Wed Jul 27 2005 Nicolas Lécureuil <neoclust@mandriva.org> 1.0.0-5mdk
- Cosmetics
- %%mkrel 
* Thu Apr 22 2004 Lenny Cartier <lenny@mandrakesoft.com> 1.0.0-4mdk
- add simplified menu

* Fri Apr 16 2004 Lenny Cartier <lenny@mandrakesoft.com> 1.0.0-3mdk
- change script test

* Thu Apr 15 2004 Lenny Cartier <lenny@mandrakesoft.com> 1.0.0-2mdk
- check if mysqld is running

* Wed Apr 07 2004 Patrick PIERRE <patrick.pierre@ruedesecoles.com> 1.0.0-1mdk
- initial release