https://afpma-webapp.e-conception.fr/generate-pdf/129

PDFController :: generatePDF

Request

GET Parameters

No GET parameters

POST Parameters

No POST parameters

Uploaded Files

No files were uploaded

Request Attributes

Key Value
_access_control_attributes
null
_controller
"App\Controller\PDFController::generatePDF"
_firewall_context
"security.firewall.map.context.main"
_route
"generate_pdf"
_route_params
[
  "id" => "129"
]
_stopwatch_token
"1a9d7f"
fiche
App\Entity\Trainings {#645
  -id: 129
  -title: "Excel initiation"
  -subTitle: "Avec ou sans certification TOSA"
  -code: null
  -cutInBlocks: false
  -domain: Doctrine\ORM\PersistentCollection {#640 …}
  -subDomain: Doctrine\ORM\PersistentCollection {#606 …}
  -keywords: Doctrine\ORM\PersistentCollection {#601 …}
  -type: Proxies\__CG__\App\Entity\Type {#441 …}
  -new: false
  -customizable: "Formation Personnalisable"
  -objectives: """
    <p>Les objectifs de la formation sont de rendre les participants capables de&nbsp;:</p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Ma&icirc;triser les fonctions de base d&rsquo;un tableur Excel</li>\r\n
    \t<li>Concevoir des tableaux de calcul simple</li>\r\n
    \t<li>Exploiter les donn&eacute;es de mani&egrave;re graphique</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Ce programme est ajust&eacute; en fonction du niveau et des attentes du participant</strong></p>\r\n
    \r\n
    <p>&nbsp;</p>
    """
  -complementaryObjectives: null
  -pedagogicContent: """
    <p><em><strong>Rappel sur l&#39;environnement Windows :</strong></em></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Organiser les dossiers de classement</li>\r\n
    \t<li>G&eacute;rer des documents &ndash; Ouvrir, cr&eacute;er, enregistrer, imprimer, compresser</li>\r\n
    </ul>\r\n
    \r\n
    <p><em><strong>Logiciel EXCEL :</strong></em></p>\r\n
    \r\n
    <p><strong>S&rsquo;approprier l&rsquo;application</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Cr&eacute;er et ouvrir un document</li>\r\n
    \t<li>Naviguer dans le logiciel</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Savoir saisir et modifier du texte &nbsp;</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Saisir des donn&eacute;es</li>\r\n
    \t<li>S&eacute;lectionner des cellules</li>\r\n
    \t<li>Supprimer des &eacute;l&eacute;ments &nbsp;</li>\r\n
    \t<li>Modifier l&rsquo;alignement du contenu</li>\r\n
    \t<li>Ins&eacute;rer des caract&egrave;res sp&eacute;ciaux</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Utiliser les formats de nombre</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Formater une cellule</li>\r\n
    \t<li>Personnaliser les formats</li>\r\n
    \t<li>Appliquer un format selon des conditions.</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Mettre en forme des donn&eacute;es</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Ajuster, ins&eacute;rer des colonnes et lignes.</li>\r\n
    \t<li>D&eacute;placer des donn&eacute;es,</li>\r\n
    \t<li>Copier et coller des valeurs</li>\r\n
    \t<li>Mettre en forme des donn&eacute;es</li>\r\n
    \t<li>Utiliser des couleurs</li>\r\n
    \t<li>Modifier le style des cellules</li>\r\n
    \t<li>Mettre en valeur un titre</li>\r\n
    \t<li>Utiliser les mises en forme conditionnelles</li>\r\n
    \t<li>D&eacute;placer des mises en forme</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Mettre en page un document</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Ins&eacute;rer des bordures</li>\r\n
    \t<li>Ajuster un tableau sur une page</li>\r\n
    \t<li>Ajouter des ent&ecirc;tes et pieds de pages</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Illustrer et enrichir le document</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Ins&eacute;rer une illustration</li>\r\n
    \t<li>Ins&eacute;rer un lien hypertexte</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Organiser ses donn&eacute;es</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Rechercher et remplacer</li>\r\n
    \t<li>Trier, filtrer les donn&eacute;es d&rsquo;un tableau</li>\r\n
    \t<li>Appliquer des crit&egrave;res de filtres avanc&eacute;s</li>\r\n
    \t<li>Ins&eacute;rer des menus d&eacute;roulants.</li>\r\n
    \t<li>Nommer des plages de donn&eacute;es.</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Organiser ses donn&eacute;es sur plusieurs feuilles</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>D&eacute;placer des donn&eacute;es d&rsquo;une feuille &agrave; l&rsquo;autre</li>\r\n
    \t<li>G&eacute;rer les feuilles de calcul</li>\r\n
    \t<li>Utiliser des donn&eacute;es sur plusieurs feuilles</li>\r\n
    \t<li>Consolider des donn&eacute;es</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Effectuer des calculs avec des formules</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Effectuer un calcul simple</li>\r\n
    \t<li>Cumuler automatiquement des valeurs</li>\r\n
    \t<li>Ins&eacute;rer des sous totaux</li>\r\n
    \t<li>Arrondir un nombre</li>\r\n
    \t<li>Convertir des nombres dans une autre base</li>\r\n
    \t<li>Atteindre une valeur cible</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Analyser des donn&eacute;es avec un graphique</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>R&eacute;aliser et mettre en forme un graphique</li>\r\n
    \t<li>Ajouter des informations suppl&eacute;mentaires</li>\r\n
    \t<li>Combiner deux types de graphique</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Effectuer des calculs sous condition</strong></p>\r\n
    \r\n
    <p><strong>Compter le nombre de donn&eacute;es</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Compter, d&eacute;compter</li>\r\n
    \t<li>Eviter les doublons</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Effectuer des calculs avec des dates</strong></p>\r\n
    \r\n
    <p><strong>Utiliser une base de donn&eacute;e simplifi&eacute;e</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Trouver des informations</li>\r\n
    \t<li>Faire des calculs &agrave; partir de la base</li>\r\n
    </ul>\r\n
    \r\n
    <p><strong>Travailler &agrave; plusieurs sur un document</strong></p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Prot&eacute;ger un document</li>\r\n
    \t<li>Commenter un tableau</li>\r\n
    </ul>
    """
  -pluses: null
  -concernedPersons: """
    <ul>\r\n
    \t<li>Toute personne souhaitant conna&icirc;tre les bases d&rsquo;EXCEL</li>\r\n
    </ul>
    """
  -prerequisites: """
    <ul>\r\n
    \t<li>Pratique &eacute;crite et orale de la langue fran&ccedil;aise</li>\r\n
    \t<li>Connaitre le fonctionnement de base d&#39;un ordinateur</li>\r\n
    </ul>
    """
  -price: "750 €HT pour une formation en INTER"
  -time: null
  -date: null
  -place: null
  -deviceAndTraining: Doctrine\ORM\PersistentCollection {#649 …}
  -termsOfAccess: null
  -alternatingRythm: null
  -teachingMethods: """
    <p>La formation est compos&eacute;e de s&eacute;quences successives&nbsp;:</p>\r\n
    \r\n
    <ul>\r\n
    \t<li>Formation th&eacute;orique, pr&eacute;sentation du vocabulaire et des concepts</li>\r\n
    \t<li>Formation &agrave; l&rsquo;aide d&rsquo;un logiciel en auto formation</li>\r\n
    \t<li>Echange avec le formateur</li>\r\n
    \t<li>Cas pratique&nbsp;: chaque utilisateur dispose d&rsquo;un ordinateur pour effectuer les diff&eacute;rentes manipulations et r&eacute;aliser des exercices pratiques sur l&rsquo;outil&nbsp;</li>\r\n
    </ul>
    """
  -teachingMeans: null
  -certificationType: Proxies\__CG__\App\Entity\CertificationType {#628 …}
  -educationLevel: null
  -trainingOrder: 0
  -certificationName: "Avec ou sans certification TOSA (choix possible)"
  -assessmentMethods: null
  -targetFunctions: null
  -continuingStudies: null
  -disabledAccessibility: 0
  -pedagogicalReferent: Doctrine\ORM\PersistentCollection {#627 …}
  -commercials: Doctrine\ORM\PersistentCollection {#625 …}
  -owner: null
  -testimonials: null
  -accessibilityText: null
  -creationDate: DateTime @1506895200 {#648
    date: 2017-10-02 00:00:00.0 Europe/Berlin (+02:00)
  }
  -editDate: DateTime @1705273200 {#647
    date: 2024-01-15 00:00:00.0 Europe/Berlin (+01:00)
  }
  -logoDisplay: false
  -whichPublic: false
  -sessions: Doctrine\ORM\PersistentCollection {#650 …}
  -published: true
  -isFiche: false
  -slug: "excel-initiation"
  -trainingPlace: Proxies\__CG__\App\Entity\TrainingPlace {#669 …}
  -ficheTitle: null
  -linkedTrainings: Doctrine\ORM\PersistentCollection {#668 …}
  -traineeOrEnterprise: null
  -validityDate: null
  -subDomainOrders: Doctrine\ORM\PersistentCollection {#660 …}
  -linkVideo: null
  -rncpOrRs: null
  -days: 3
  -hours: 21
  -companyMissions: null
  -educationLevelName: null
  -publicType: null
  -validityDateRncp: null
  -resetDate: false
}
id
"129"

Request Headers

Header Value
accept
"*/*"
accept-encoding
"deflate, gzip, br"
host
"afpma-webapp.e-conception.fr"
user-agent
"Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)"
x-php-ob-level
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control
"no-cache, private"
content-disposition
"attachment; filename="AFPMA - Excel-initiation.pdf""
content-type
"application/pdf"
date
"Wed, 03 Jul 2024 03:27:51 GMT"
x-debug-token
"e0f62c"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

0 Usages
Stateless check enabled

Session not used.

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_ENV
"dev"
APP_SECRET
"5bc027bc16d738ff92dfe3407b803fb4"
DATABASE_URL
"mysql://afpma-webapp:BkbkYWyKn0j9avxN@127.0.0.1:3306/afpma-webapp?charset=utf8mb4"
MAILER_DSN
"smtp://recrutement@afpma.fr:Akebia01960@afpma-fr.mail.protection.outlook.com:25"
MESSENGER_TRANSPORT_DSN
"doctrine://default?auto_setup=0"

Defined as regular env variables

Key Value
APP_DEBUG
"1"
CONTEXT_DOCUMENT_ROOT
"/var/www/afpma-webapp/www/public"
CONTEXT_PREFIX
""
DOCUMENT_ROOT
"/var/www/afpma-webapp/www/public"
FCGI_ROLE
"RESPONDER"
GATEWAY_INTERFACE
"CGI/1.1"
H2PUSH
"off"
H2_PUSH
"off"
H2_PUSHED
""
H2_PUSHED_ON
""
H2_STREAM_ID
"1"
H2_STREAM_TAG
"17-1"
HOME
"/var/www/afpma-webapp"
HTTP2
"on"
HTTPS
"on"
HTTP_ACCEPT
"*/*"
HTTP_ACCEPT_ENCODING
"deflate, gzip, br"
HTTP_HOST
"afpma-webapp.e-conception.fr"
HTTP_USER_AGENT
"Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
PHP_SELF
"/index.php"
QUERY_STRING
""
REDIRECT_H2PUSH
"off"
REDIRECT_H2_PUSH
"off"
REDIRECT_H2_PUSHED
""
REDIRECT_H2_PUSHED_ON
""
REDIRECT_H2_STREAM_ID
"1"
REDIRECT_H2_STREAM_TAG
"17-1"
REDIRECT_HTTP2
"on"
REDIRECT_HTTPS
"on"
REDIRECT_SSL_CIPHER
"TLS_AES_256_GCM_SHA384"
REDIRECT_SSL_CIPHER_ALGKEYSIZE
"256"
REDIRECT_SSL_CIPHER_EXPORT
"false"
REDIRECT_SSL_CIPHER_USEKEYSIZE
"256"
REDIRECT_SSL_CLIENT_VERIFY
"NONE"
REDIRECT_SSL_COMPRESS_METHOD
"NULL"
REDIRECT_SSL_PROTOCOL
"TLSv1.3"
REDIRECT_SSL_SECURE_RENEG
"true"
REDIRECT_SSL_SERVER_A_KEY
"rsaEncryption"
REDIRECT_SSL_SERVER_A_SIG
"sha256WithRSAEncryption"
REDIRECT_SSL_SERVER_I_DN
"CN=R10,O=Let's Encrypt,C=US"
REDIRECT_SSL_SERVER_I_DN_C
"US"
REDIRECT_SSL_SERVER_I_DN_CN
"R10"
REDIRECT_SSL_SERVER_I_DN_O
"Let's Encrypt"
REDIRECT_SSL_SERVER_M_SERIAL
"03C51E34D33C49DEE314A70D7781A4F1D47A"
REDIRECT_SSL_SERVER_M_VERSION
"3"
REDIRECT_SSL_SERVER_SAN_DNS_0
"afpma-webapp.e-conception.fr"
REDIRECT_SSL_SERVER_S_DN
"CN=afpma-webapp.e-conception.fr"
REDIRECT_SSL_SERVER_S_DN_CN
"afpma-webapp.e-conception.fr"
REDIRECT_SSL_SERVER_V_END
"Sep  6 04:58:51 2024 GMT"
REDIRECT_SSL_SERVER_V_START
"Jun  8 04:58:52 2024 GMT"
REDIRECT_SSL_SESSION_ID
"0ecfce1a8edfda12818bdf9a4f78fef8a7448b4500f7faf5ebf8859d4ac9930d"
REDIRECT_SSL_SESSION_RESUMED
"Initial"
REDIRECT_SSL_TLS_SNI
"afpma-webapp.e-conception.fr"
REDIRECT_SSL_VERSION_INTERFACE
"mod_ssl/2.4.38"
REDIRECT_SSL_VERSION_LIBRARY
"OpenSSL/1.1.1n"
REDIRECT_STATUS
"200"
REDIRECT_URL
"/generate-pdf/129"
REMOTE_ADDR
"54.36.149.16"
REMOTE_PORT
"16837"
REQUEST_METHOD
"GET"
REQUEST_SCHEME
"https"
REQUEST_TIME
1719977269
REQUEST_TIME_FLOAT
1719977269.9553
REQUEST_URI
"/generate-pdf/129"
SCRIPT_FILENAME
"//var/www/afpma-webapp/www/public/index.php"
SCRIPT_NAME
"/index.php"
SERVER_ADDR
"37.59.128.226"
SERVER_ADMIN
"[no address given]"
SERVER_NAME
"afpma-webapp.e-conception.fr"
SERVER_PORT
"443"
SERVER_PROTOCOL
"HTTP/2.0"
SERVER_SIGNATURE
""
SERVER_SOFTWARE
"Apache"
SSL_CIPHER
"TLS_AES_256_GCM_SHA384"
SSL_CIPHER_ALGKEYSIZE
"256"
SSL_CIPHER_EXPORT
"false"
SSL_CIPHER_USEKEYSIZE
"256"
SSL_CLIENT_VERIFY
"NONE"
SSL_COMPRESS_METHOD
"NULL"
SSL_PROTOCOL
"TLSv1.3"
SSL_SECURE_RENEG
"true"
SSL_SERVER_A_KEY
"rsaEncryption"
SSL_SERVER_A_SIG
"sha256WithRSAEncryption"
SSL_SERVER_I_DN
"CN=R10,O=Let's Encrypt,C=US"
SSL_SERVER_I_DN_C
"US"
SSL_SERVER_I_DN_CN
"R10"
SSL_SERVER_I_DN_O
"Let's Encrypt"
SSL_SERVER_M_SERIAL
"03C51E34D33C49DEE314A70D7781A4F1D47A"
SSL_SERVER_M_VERSION
"3"
SSL_SERVER_SAN_DNS_0
"afpma-webapp.e-conception.fr"
SSL_SERVER_S_DN
"CN=afpma-webapp.e-conception.fr"
SSL_SERVER_S_DN_CN
"afpma-webapp.e-conception.fr"
SSL_SERVER_V_END
"Sep  6 04:58:51 2024 GMT"
SSL_SERVER_V_START
"Jun  8 04:58:52 2024 GMT"
SSL_SESSION_ID
"0ecfce1a8edfda12818bdf9a4f78fef8a7448b4500f7faf5ebf8859d4ac9930d"
SSL_SESSION_RESUMED
"Initial"
SSL_TLS_SNI
"afpma-webapp.e-conception.fr"
SSL_VERSION_INTERFACE
"mod_ssl/2.4.38"
SSL_VERSION_LIBRARY
"OpenSSL/1.1.1n"
SYMFONY_DOTENV_VARS
"MESSENGER_TRANSPORT_DSN,APP_ENV,APP_SECRET,DATABASE_URL,MAILER_DSN"
USER
"afpma-webapp"
proxy-nokeepalive
"1"