CakePHP: the rapid development php framework: Errors

FPDF error: Unable to create output file: /home/provencebf/www/production/app/tmp/1751324627.pdf

Error: An Internal Error Has Occurred.

Stack Trace

ROOT/vendors/fpdf181/fpdf.php line 1022 → FPDF->Error(string)

        case 'F':
            // Save to local file
            if(!file_put_contents($name,$this->buffer))
                $this->Error('Unable to create output file: '.$name);
            break;

'Unable to create output file: /home/provencebf/www/production/app/tmp/1751324627.pdf'

APP/View/Menus/imprimer_fiche_ref.ctp line 486 → FPDF->Output(string, string)

    $fichier_mixes = TMP.'mixes_'.$jour.'.pdf';
    
    $fichier = TMP.time().".pdf";
    $fpdf->Output("F", $fichier);

'F'
'/home/provencebf/www/production/app/tmp/1751324627.pdf'

CORE/Cake/View/View.php line 971 → include(string)

        extract($dataForView);
        ob_start();

        include $this->__viewFile;

'/home/provencebf/www/production/app/View/Menus/imprimer_fiche_ref.ctp'

CORE/Cake/View/View.php line 933 → View->_evaluate(string, array)

        $beforeEvent = new CakeEvent('View.beforeRenderFile', $this, array($viewFile));

        $eventManager->dispatch($beforeEvent);
        $content = $this->_evaluate($viewFile, $data);

'/home/provencebf/www/production/app/View/Menus/imprimer_fiche_ref.ctp'
array(
	'jour' => '2025-07-03',
	'conf_pdf' => false,
	'type' => 'tout',
	'type_g' => 'tout',
	'tab_lignes' => array(
		'2025-07-03' => array(
			'spe' => array(
				(int) 0 => ' Pâtes',
				(int) 1 => ' Riz',
				(int) 2 => ' Bouillon',
				(int) 3 => ' Purée',
				(int) 4 => ' Légumes',
				(int) 5 => ' Omelette',
				(int) 6 => ' Steack haché',
				(int) 7 => ' Poisson',
				(int) 8 => '',
				(int) 9 => ''
			),
			'A' => array(
				(int) 0 => '',
				(int) 1 => '',
				(int) 2 => '',
				(int) 3 => '',
				(int) 4 => '',
				(int) 5 => '',
				(int) 6 => '',
				(int) 7 => '',
				(int) 8 => '',
				(int) 9 => ''
			),
			'B' => array(
				(int) 0 => '',
				(int) 1 => '',
				(int) 2 => '',
				(int) 3 => '',
				(int) 4 => '',
				(int) 5 => '',
				(int) 6 => '',
				(int) 7 => '',
				(int) 8 => '',
				(int) 9 => ''
			),
			'C' => array(
				(int) 0 => '',
				(int) 1 => '',
				(int) 2 => '',
				(int) 3 => '',
				(int) 4 => '',
				(int) 5 => '',
				(int) 6 => '',
				(int) 7 => '',
				(int) 8 => '',
				(int) 9 => ''
			)
		)
	),
	'plats' => array()
)

CORE/Cake/View/View.php line 473 → View->_render(string)

        if ($view !== false && $viewFileName = $this->_getViewFileName($view)) {
            $this->_currentType = static::TYPE_VIEW;
            $this->getEventManager()->dispatch(new CakeEvent('View.beforeRender', $this, array($viewFileName)));
            $this->Blocks->set('content', $this->_render($viewFileName));
            $this->getEventManager()->dispatch(new CakeEvent('View.afterRender', $this, array($viewFileName)));

'/home/provencebf/www/production/app/View/Menus/imprimer_fiche_ref.ctp'

CORE/Cake/Controller/Controller.php line 960 → View->render(null, null)

        }

        $this->autoRender = false;
        $this->response->body($this->View->render($view, $layout));
        return $this->response;

null
null

CORE/Cake/Routing/Dispatcher.php line 200 → Controller->render()

        }

        if ($render && $controller->autoRender) {
            $response = $controller->render();
        } elseif (!($result instanceof CakeResponse) && $response->body() === null) {

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(MenusController, CakeRequest)

            ));
        }

        $response = $this->_invoke($controller, $request);
        if (isset($request->params['return'])) {

object(MenusController) {
	uses => array(
		(int) 0 => 'Menu',
		(int) 1 => 'CommandeComposition',
		(int) 2 => 'Etablissement',
		(int) 3 => 'Repartition',
		(int) 4 => 'Plat',
		(int) 5 => 'Texture',
		(int) 6 => 'Regime',
		(int) 7 => 'TypeMenu',
		(int) 8 => 'PlatSpecifique',
		(int) 9 => 'Specifique',
		(int) 10 => 'Edition',
		(int) 11 => 'SpecifiqueHisto',
		(int) 12 => 'EditionComposant',
		(int) 13 => 'EditionProduction',
		(int) 14 => 'HisRecapProd',
		(int) 15 => 'DocumentMenu',
		(int) 16 => 'DocumentSpecifique',
		(int) 17 => 'DocumentPlat',
		(int) 18 => 'TypePlat',
		(int) 19 => 'DocumentHr',
		(int) 20 => 'ConfigSupp',
		(int) 21 => 'ConfigurationComposition',
		(int) 22 => 'Personne',
		(int) 23 => 'TraceEnvoi',
		(int) 24 => 'RepartitionEtiquette',
		(int) 25 => 'vGroupeSpeMenus',
		(int) 26 => 'EtiquetteSpecifique',
		(int) 27 => 'NomenclatureDetail',
		(int) 28 => 'Nomenclature',
		(int) 29 => 'HistoTicket',
		(int) 30 => 'Tache',
		(int) 31 => 'User',
		(int) 32 => 'TypeComposante',
		(int) 33 => 'TypeProduitAnnexe',
		(int) 34 => 'Parametre',
		(int) 35 => 'Commande',
		(int) 36 => 'TypeDocument',
		(int) 37 => 'Log'
	)
	bdd_direction => 'provence_bfdir'
	components => array(
		(int) 0 => 'Auth',
		(int) 1 => 'Session',
		(int) 2 => 'Cookie',
		(int) 3 => 'RequestHandler'
	)
	name => 'Menus'
	helpers => array()
	request => object(CakeRequest) {
		params => array(
			[maximum depth reached]
		)
		data => array([maximum depth reached])
		query => array([maximum depth reached])
		url => 'menus/imprimer_fiche_ref/tout/2025-07-03'
		base => '/production'
		webroot => '/production/'
		here => '/production/menus/imprimer_fiche_ref/tout/2025-07-03'
		[protected] _detectors => array(
			[maximum depth reached]
		)
		[protected] _input => ''
	}
	response => object(CakeResponse) {
		[protected] _statusCodes => array(
			[maximum depth reached]
		)
		[protected] _mimeTypes => array(
			[maximum depth reached]
		)
		[protected] _protocol => 'HTTP/1.1'
		[protected] _status => (int) 200
		[protected] _contentType => 'application/pdf'
		[protected] _headers => array([maximum depth reached])
		[protected] _body => null
		[protected] _file => null
		[protected] _fileRange => null
		[protected] _charset => 'UTF-8'
		[protected] _cacheDirectives => array([maximum depth reached])
		[protected] _cookies => array([maximum depth reached])
	}
	viewPath => 'Menus'
	layoutPath => null
	viewVars => array(
		'jour' => '2025-07-03',
		'conf_pdf' => false,
		'type' => 'tout',
		'type_g' => 'tout',
		'tab_lignes' => array(
			'2025-07-03' => array(
				[maximum depth reached]
			)
		),
		'plats' => array()
	)
	view => 'imprimer_fiche_ref'
	layout => 'pdf'
	autoRender => false
	autoLayout => true
	Components => object(ComponentCollection) {
		defaultPriority => (int) 10
		[protected] _Controller => object(MenusController) {}
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	viewClass => 'View'
	View => object(View) {
		Helpers => object(HelperCollection) {}
		Blocks => object(ViewBlock) {}
		plugin => null
		name => 'Menus'
		passedArgs => array(
			[maximum depth reached]
		)
		helpers => array([maximum depth reached])
		viewPath => 'Menus'
		viewVars => array(
			[maximum depth reached]
		)
		view => 'imprimer_fiche_ref'
		layout => 'pdf'
		layoutPath => null
		autoLayout => true
		ext => '.ctp'
		subDir => null
		theme => null
		cacheAction => false
		validationErrors => array(
			[maximum depth reached]
		)
		hasRendered => false
		uuids => array([maximum depth reached])
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		elementCache => 'default'
		elementCacheSettings => array([maximum depth reached])
		__viewFile => '/home/provencebf/www/production/app/View/Menus/imprimer_fiche_ref.ctp'
		[protected] _passedVars => array(
			[maximum depth reached]
		)
		[protected] _scripts => array([maximum depth reached])
		[protected] _paths => array(
			[maximum depth reached]
		)
		[protected] _pathsForPlugin => array([maximum depth reached])
		[protected] _parents => array([maximum depth reached])
		[protected] _current => '/home/provencebf/www/production/app/View/Menus/imprimer_fiche_ref.ctp'
		[protected] _currentType => 'view'
		[protected] _stack => array([maximum depth reached])
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _eventManagerConfigured => true
	}
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array(
		(int) 0 => 'tout',
		(int) 1 => '2025-07-03'
	)
	scaffold => false
	methods => array(
		(int) 0 => 'imprimerfichespecifiques',
		(int) 1 => 'imprimerficheproduction',
		(int) 2 => 'imprimer_v2',
		(int) 3 => 'afficherobjet',
		(int) 4 => 'imprimermenu',
		(int) 5 => 'temperature',
		(int) 6 => 'avance',
		(int) 7 => 'traca_etiq',
		(int) 8 => 'fiches_refpf',
		(int) 9 => 'imprimer_fref_pf',
		(int) 10 => 'imprimer_fref_des',
		(int) 11 => 'imprimer_fref_spe',
		(int) 12 => 'enregistrerTicket',
		(int) 13 => 'imprimer_jour_allergenes',
		(int) 14 => 'valider_etiquette_spe',
		(int) 15 => 'gerer_special',
		(int) 16 => 'imprimer_special',
		(int) 17 => 'etiquettes_spe',
		(int) 18 => 'imprimer_fiche_ref_tout',
		(int) 19 => 'imprimer_fiche_meo',
		(int) 20 => 'imprimer_fiche_mixes',
		(int) 21 => 'imprimer_fiche_ref',
		(int) 22 => 'fiches_ref',
		(int) 23 => 'fiches_meo',
		(int) 24 => 'envoyer_pdf',
		(int) 25 => 'imprimer_menu',
		(int) 26 => 'imprimer_jour',
		(int) 27 => '_imprimer_jour',
		(int) 29 => 'selection_plat',
		(int) 30 => 'valider_journee',
		(int) 31 => 'valider_menu',
		(int) 32 => 'devalider_menu',
		(int) 33 => 'validation',
		(int) 34 => 'annulation',
		(int) 35 => 'definir_etab_etiq',
		(int) 36 => 'recap_prod_plat',
		(int) 37 => 'recap_prod',
		(int) 38 => 'recap_specifique_supp',
		(int) 39 => 'supprimer_edtprod',
		(int) 40 => 'supprimer_edtspe',
		(int) 41 => 'generer',
		(int) 42 => 'recap_specifique',
		(int) 43 => 'enregistrerDonneesSpecsBl',
		(int) 44 => 'enregistrerDonneesPlatsBl',
		(int) 45 => 'EnregistrerLigneProd',
		(int) 46 => 'EnregistrerSpecifiques',
		(int) 47 => 'export',
		(int) 48 => 'selection_cp',
		(int) 49 => 'selection',
		(int) 50 => 'imprimer_rr',
		(int) 51 => 'imprimer_rhr',
		(int) 52 => 'imprimer_spe',
		(int) 53 => 'imprimer_etq',
		(int) 54 => 'imprimer',
		(int) 55 => 'copier_menu',
		(int) 56 => 'copie',
		(int) 57 => 'types',
		(int) 58 => 'liste',
		(int) 59 => 'etiquettes_prod',
		(int) 60 => 'etiquettes_etab',
		(int) 61 => 'liste_spe',
		(int) 62 => 'liste_repas',
		(int) 63 => 'supprimer',
		(int) 64 => 'gerer',
		(int) 65 => 'gerer_etab',
		(int) 66 => 'valider',
		(int) 67 => 'calculerjourminimum',
		(int) 68 => 'rendreVue',
		(int) 69 => 'insererlienssemaines',
		(int) 70 => 'calculerjourssemaine',
		(int) 71 => 'logger',
		(int) 72 => 'cheminabsolu',
		(int) 73 => 'chemin',
		(int) 74 => 'retournerSite',
		(int) 75 => 'enregistrerLog',
		(int) 76 => 'racine',
		(int) 77 => 'retournerSchema',
		(int) 78 => 'genererSemaines',
		(int) 79 => 'afficherNoDocument',
		(int) 80 => 'lireParametre',
		(int) 81 => 'lireAdresse',
		(int) 82 => 'listerTypesComposante',
		(int) 83 => 'listerTypesProduitsAnnexe',
		(int) 84 => 'afficher',
		(int) 85 => 'entete',
		(int) 86 => 'definirTitre',
		(int) 87 => 'listerTaches',
		(int) 88 => 'listerControles',
		(int) 89 => '_setErrorLayout',
		(int) 90 => 'nb',
		(int) 91 => 'recupererEnvois',
		(int) 92 => 'date_depuis_mysql',
		(int) 93 => 'date_vers_mysql',
		(int) 94 => 'calcul_mktime',
		(int) 95 => 'jour',
		(int) 96 => 'initiales',
		(int) 97 => 'enregistrer',
		(int) 99 => 'moveTohttp'
	)
	modelClass => 'Menu'
	modelKey => 'menu'
	validationErrors => null
	Auth => object(AuthComponent) {
		components => array(
			[maximum depth reached]
		)
		authenticate => array(
			[maximum depth reached]
		)
		authorize => false
		ajaxLogin => null
		flash => array(
			[maximum depth reached]
		)
		loginAction => array(
			[maximum depth reached]
		)
		loginRedirect => null
		logoutRedirect => array(
			[maximum depth reached]
		)
		authError => 'You are not authorized to access that location.'
		unauthorizedRedirect => true
		allowedActions => array(
			[maximum depth reached]
		)
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		settings => array([maximum depth reached])
		[protected] _authenticateObjects => array([maximum depth reached])
		[protected] _authorizeObjects => array([maximum depth reached])
		[protected] _user => array([maximum depth reached])
		[protected] _methods => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	Session => object(SessionComponent) {
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Cookie => object(CookieComponent) {
		name => 'CakeCookie'
		time => null
		path => '/'
		domain => ''
		secure => false
		key => 'DYhG93b0qyJfIxfs2guVoUSz3pubWwvniR2G0FgaC9mi'
		httpOnly => false
		settings => array([maximum depth reached])
		components => array([maximum depth reached])
		[protected] _values => array(
			[maximum depth reached]
		)
		[protected] _type => 'cipher'
		[protected] _reset => null
		[protected] _expires => (int) 0
		[protected] _response => object(CakeResponse) {}
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	RequestHandler => object(RequestHandlerComponent) {
		ajaxLayout => 'ajax'
		enabled => true
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		ext => null
		settings => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		params => object(CakeRequest) {}
		[protected] _renderType => null
		[protected] _inputTypeMap => array(
			[maximum depth reached]
		)
		[protected] _viewClassMap => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Etablissement => object(Etablissement) {
		useDbConfig => 'default'
		useTable => 'etablissements'
		id => null
		data => array([maximum depth reached])
		schemaName => 'provence_bfpr'
		table => 'etablissements'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'Etablissement'
		alias => 'Etablissement'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => null
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => null
		[protected] _validator => null
	}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
}
object(CakeRequest) {
	params => array(
		'plugin' => null,
		'controller' => 'menus',
		'action' => 'imprimer_fiche_ref',
		'named' => array(),
		'pass' => array(
			(int) 0 => 'tout',
			(int) 1 => '2025-07-03'
		),
		'isAjax' => false,
		'models' => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'CommandeComposition' => array(
				[maximum depth reached]
			),
			'Etablissement' => array(
				[maximum depth reached]
			),
			'Repartition' => array(
				[maximum depth reached]
			),
			'Plat' => array(
				[maximum depth reached]
			),
			'Texture' => array(
				[maximum depth reached]
			),
			'Regime' => array(
				[maximum depth reached]
			),
			'TypeMenu' => array(
				[maximum depth reached]
			),
			'PlatSpecifique' => array(
				[maximum depth reached]
			),
			'Specifique' => array(
				[maximum depth reached]
			),
			'Edition' => array(
				[maximum depth reached]
			),
			'SpecifiqueHisto' => array(
				[maximum depth reached]
			),
			'EditionComposant' => array(
				[maximum depth reached]
			),
			'EditionProduction' => array(
				[maximum depth reached]
			),
			'HisRecapProd' => array(
				[maximum depth reached]
			),
			'DocumentMenu' => array(
				[maximum depth reached]
			),
			'DocumentSpecifique' => array(
				[maximum depth reached]
			),
			'DocumentPlat' => array(
				[maximum depth reached]
			),
			'TypePlat' => array(
				[maximum depth reached]
			),
			'DocumentHr' => array(
				[maximum depth reached]
			),
			'ConfigSupp' => array(
				[maximum depth reached]
			),
			'ConfigurationComposition' => array(
				[maximum depth reached]
			),
			'Personne' => array(
				[maximum depth reached]
			),
			'TraceEnvoi' => array(
				[maximum depth reached]
			),
			'RepartitionEtiquette' => array(
				[maximum depth reached]
			),
			'vGroupeSpeMenus' => array(
				[maximum depth reached]
			),
			'EtiquetteSpecifique' => array(
				[maximum depth reached]
			),
			'NomenclatureDetail' => array(
				[maximum depth reached]
			),
			'Nomenclature' => array(
				[maximum depth reached]
			),
			'HistoTicket' => array(
				[maximum depth reached]
			),
			'Tache' => array(
				[maximum depth reached]
			),
			'User' => array(
				[maximum depth reached]
			),
			'TypeComposante' => array(
				[maximum depth reached]
			),
			'TypeProduitAnnexe' => array(
				[maximum depth reached]
			),
			'Parametre' => array(
				[maximum depth reached]
			),
			'Commande' => array(
				[maximum depth reached]
			),
			'TypeDocument' => array(
				[maximum depth reached]
			),
			'Log' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'menus/imprimer_fiche_ref/tout/2025-07-03'
	base => '/production'
	webroot => '/production/'
	here => '/production/menus/imprimer_fiche_ref/tout/2025-07-03'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}

APP/webroot/index.php line 111 → Dispatcher->dispatch(CakeRequest, CakeResponse)

$Dispatcher->dispatch(
    new CakeRequest(),
    new CakeResponse()
);

object(CakeRequest) {
	params => array(
		'plugin' => null,
		'controller' => 'menus',
		'action' => 'imprimer_fiche_ref',
		'named' => array(),
		'pass' => array(
			(int) 0 => 'tout',
			(int) 1 => '2025-07-03'
		),
		'isAjax' => false,
		'models' => array(
			'Menu' => array(
				[maximum depth reached]
			),
			'CommandeComposition' => array(
				[maximum depth reached]
			),
			'Etablissement' => array(
				[maximum depth reached]
			),
			'Repartition' => array(
				[maximum depth reached]
			),
			'Plat' => array(
				[maximum depth reached]
			),
			'Texture' => array(
				[maximum depth reached]
			),
			'Regime' => array(
				[maximum depth reached]
			),
			'TypeMenu' => array(
				[maximum depth reached]
			),
			'PlatSpecifique' => array(
				[maximum depth reached]
			),
			'Specifique' => array(
				[maximum depth reached]
			),
			'Edition' => array(
				[maximum depth reached]
			),
			'SpecifiqueHisto' => array(
				[maximum depth reached]
			),
			'EditionComposant' => array(
				[maximum depth reached]
			),
			'EditionProduction' => array(
				[maximum depth reached]
			),
			'HisRecapProd' => array(
				[maximum depth reached]
			),
			'DocumentMenu' => array(
				[maximum depth reached]
			),
			'DocumentSpecifique' => array(
				[maximum depth reached]
			),
			'DocumentPlat' => array(
				[maximum depth reached]
			),
			'TypePlat' => array(
				[maximum depth reached]
			),
			'DocumentHr' => array(
				[maximum depth reached]
			),
			'ConfigSupp' => array(
				[maximum depth reached]
			),
			'ConfigurationComposition' => array(
				[maximum depth reached]
			),
			'Personne' => array(
				[maximum depth reached]
			),
			'TraceEnvoi' => array(
				[maximum depth reached]
			),
			'RepartitionEtiquette' => array(
				[maximum depth reached]
			),
			'vGroupeSpeMenus' => array(
				[maximum depth reached]
			),
			'EtiquetteSpecifique' => array(
				[maximum depth reached]
			),
			'NomenclatureDetail' => array(
				[maximum depth reached]
			),
			'Nomenclature' => array(
				[maximum depth reached]
			),
			'HistoTicket' => array(
				[maximum depth reached]
			),
			'Tache' => array(
				[maximum depth reached]
			),
			'User' => array(
				[maximum depth reached]
			),
			'TypeComposante' => array(
				[maximum depth reached]
			),
			'TypeProduitAnnexe' => array(
				[maximum depth reached]
			),
			'Parametre' => array(
				[maximum depth reached]
			),
			'Commande' => array(
				[maximum depth reached]
			),
			'TypeDocument' => array(
				[maximum depth reached]
			),
			'Log' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'menus/imprimer_fiche_ref/tout/2025-07-03'
	base => '/production'
	webroot => '/production/'
	here => '/production/menus/imprimer_fiche_ref/tout/2025-07-03'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}
object(CakeResponse) {
	[protected] _statusCodes => array(
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Time-out',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Request Entity Too Large',
		(int) 414 => 'Request-URI Too Large',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Requested range not satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 429 => 'Too Many Requests',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Time-out',
		(int) 505 => 'Unsupported Version'
	)
	[protected] _mimeTypes => array(
		'html' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'json' => 'application/json',
		'xml' => array(
			(int) 0 => 'application/xml',
			(int) 1 => 'text/xml'
		),
		'rss' => 'application/rss+xml',
		'ai' => 'application/postscript',
		'bcpio' => 'application/x-bcpio',
		'bin' => 'application/octet-stream',
		'ccad' => 'application/clariscad',
		'cdf' => 'application/x-netcdf',
		'class' => 'application/octet-stream',
		'cpio' => 'application/x-cpio',
		'cpt' => 'application/mac-compactpro',
		'csh' => 'application/x-csh',
		'csv' => array(
			(int) 0 => 'text/csv',
			(int) 1 => 'application/vnd.ms-excel'
		),
		'dcr' => 'application/x-director',
		'dir' => 'application/x-director',
		'dms' => 'application/octet-stream',
		'doc' => 'application/msword',
		'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
		'drw' => 'application/drafting',
		'dvi' => 'application/x-dvi',
		'dwg' => 'application/acad',
		'dxf' => 'application/dxf',
		'dxr' => 'application/x-director',
		'eot' => 'application/vnd.ms-fontobject',
		'eps' => 'application/postscript',
		'exe' => 'application/octet-stream',
		'ez' => 'application/andrew-inset',
		'flv' => 'video/x-flv',
		'gtar' => 'application/x-gtar',
		'gz' => 'application/x-gzip',
		'bz2' => 'application/x-bzip',
		'7z' => 'application/x-7z-compressed',
		'hdf' => 'application/x-hdf',
		'hqx' => 'application/mac-binhex40',
		'ico' => 'image/x-icon',
		'ips' => 'application/x-ipscript',
		'ipx' => 'application/x-ipix',
		'js' => 'application/javascript',
		'latex' => 'application/x-latex',
		'lha' => 'application/octet-stream',
		'lsp' => 'application/x-lisp',
		'lzh' => 'application/octet-stream',
		'man' => 'application/x-troff-man',
		'me' => 'application/x-troff-me',
		'mif' => 'application/vnd.mif',
		'ms' => 'application/x-troff-ms',
		'nc' => 'application/x-netcdf',
		'oda' => 'application/oda',
		'otf' => 'font/otf',
		'pdf' => 'application/pdf',
		'pgn' => 'application/x-chess-pgn',
		'pot' => 'application/vnd.ms-powerpoint',
		'pps' => 'application/vnd.ms-powerpoint',
		'ppt' => 'application/vnd.ms-powerpoint',
		'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
		'ppz' => 'application/vnd.ms-powerpoint',
		'pre' => 'application/x-freelance',
		'prt' => 'application/pro_eng',
		'ps' => 'application/postscript',
		'roff' => 'application/x-troff',
		'scm' => 'application/x-lotusscreencam',
		'set' => 'application/set',
		'sh' => 'application/x-sh',
		'shar' => 'application/x-shar',
		'sit' => 'application/x-stuffit',
		'skd' => 'application/x-koan',
		'skm' => 'application/x-koan',
		'skp' => 'application/x-koan',
		'skt' => 'application/x-koan',
		'smi' => 'application/smil',
		'smil' => 'application/smil',
		'sol' => 'application/solids',
		'spl' => 'application/x-futuresplash',
		'src' => 'application/x-wais-source',
		'step' => 'application/STEP',
		'stl' => 'application/SLA',
		'stp' => 'application/STEP',
		'sv4cpio' => 'application/x-sv4cpio',
		'sv4crc' => 'application/x-sv4crc',
		'svg' => 'image/svg+xml',
		'svgz' => 'image/svg+xml',
		'swf' => 'application/x-shockwave-flash',
		't' => 'application/x-troff',
		'tar' => 'application/x-tar',
		'tcl' => 'application/x-tcl',
		'tex' => 'application/x-tex',
		'texi' => 'application/x-texinfo',
		'texinfo' => 'application/x-texinfo',
		'tr' => 'application/x-troff',
		'tsp' => 'application/dsptype',
		'ttc' => 'font/ttf',
		'ttf' => 'font/ttf',
		'unv' => 'application/i-deas',
		'ustar' => 'application/x-ustar',
		'vcd' => 'application/x-cdlink',
		'vda' => 'application/vda',
		'xlc' => 'application/vnd.ms-excel',
		'xll' => 'application/vnd.ms-excel',
		'xlm' => 'application/vnd.ms-excel',
		'xls' => 'application/vnd.ms-excel',
		'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
		'xlw' => 'application/vnd.ms-excel',
		'zip' => 'application/zip',
		'aif' => 'audio/x-aiff',
		'aifc' => 'audio/x-aiff',
		'aiff' => 'audio/x-aiff',
		'au' => 'audio/basic',
		'kar' => 'audio/midi',
		'mid' => 'audio/midi',
		'midi' => 'audio/midi',
		'mp2' => 'audio/mpeg',
		'mp3' => 'audio/mpeg',
		'mpga' => 'audio/mpeg',
		'ogg' => 'audio/ogg',
		'oga' => 'audio/ogg',
		'spx' => 'audio/ogg',
		'ra' => 'audio/x-realaudio',
		'ram' => 'audio/x-pn-realaudio',
		'rm' => 'audio/x-pn-realaudio',
		'rpm' => 'audio/x-pn-realaudio-plugin',
		'snd' => 'audio/basic',
		'tsi' => 'audio/TSP-audio',
		'wav' => 'audio/x-wav',
		'aac' => 'audio/aac',
		'asc' => 'text/plain',
		'c' => 'text/plain',
		'cc' => 'text/plain',
		'css' => 'text/css',
		'etx' => 'text/x-setext',
		'f' => 'text/plain',
		'f90' => 'text/plain',
		'h' => 'text/plain',
		'hh' => 'text/plain',
		'htm' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'ics' => 'text/calendar',
		'm' => 'text/plain',
		'rtf' => 'text/rtf',
		'rtx' => 'text/richtext',
		'sgm' => 'text/sgml',
		'sgml' => 'text/sgml',
		'tsv' => 'text/tab-separated-values',
		'tpl' => 'text/template',
		'txt' => 'text/plain',
		'text' => 'text/plain',
		'avi' => 'video/x-msvideo',
		'fli' => 'video/x-fli',
		'mov' => 'video/quicktime',
		'movie' => 'video/x-sgi-movie',
		'mpe' => 'video/mpeg',
		'mpeg' => 'video/mpeg',
		'mpg' => 'video/mpeg',
		'qt' => 'video/quicktime',
		'viv' => 'video/vnd.vivo',
		'vivo' => 'video/vnd.vivo',
		'ogv' => 'video/ogg',
		'webm' => 'video/webm',
		'mp4' => 'video/mp4',
		'm4v' => 'video/mp4',
		'f4v' => 'video/mp4',
		'f4p' => 'video/mp4',
		'm4a' => 'audio/mp4',
		'f4a' => 'audio/mp4',
		'f4b' => 'audio/mp4',
		'gif' => 'image/gif',
		'ief' => 'image/ief',
		'jpg' => 'image/jpeg',
		'jpeg' => 'image/jpeg',
		'jpe' => 'image/jpeg',
		'pbm' => 'image/x-portable-bitmap',
		'pgm' => 'image/x-portable-graymap',
		'png' => 'image/png',
		'pnm' => 'image/x-portable-anymap',
		'ppm' => 'image/x-portable-pixmap',
		'ras' => 'image/cmu-raster',
		'rgb' => 'image/x-rgb',
		'tif' => 'image/tiff',
		'tiff' => 'image/tiff',
		'xbm' => 'image/x-xbitmap',
		'xpm' => 'image/x-xpixmap',
		'xwd' => 'image/x-xwindowdump',
		'ice' => 'x-conference/x-cooltalk',
		'iges' => 'model/iges',
		'igs' => 'model/iges',
		'mesh' => 'model/mesh',
		'msh' => 'model/mesh',
		'silo' => 'model/mesh',
		'vrml' => 'model/vrml',
		'wrl' => 'model/vrml',
		'mime' => 'www/mime',
		'pdb' => 'chemical/x-pdb',
		'xyz' => 'chemical/x-pdb',
		'javascript' => 'application/javascript',
		'form' => 'application/x-www-form-urlencoded',
		'file' => 'multipart/form-data',
		'xhtml' => array(
			(int) 0 => 'application/xhtml+xml',
			(int) 1 => 'application/xhtml',
			(int) 2 => 'text/xhtml'
		),
		'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
		'atom' => 'application/atom+xml',
		'amf' => 'application/x-amf',
		'wap' => array(
			(int) 0 => 'text/vnd.wap.wml',
			(int) 1 => 'text/vnd.wap.wmlscript',
			(int) 2 => 'image/vnd.wap.wbmp'
		),
		'wml' => 'text/vnd.wap.wml',
		'wmlscript' => 'text/vnd.wap.wmlscript',
		'wbmp' => 'image/vnd.wap.wbmp',
		'woff' => 'application/x-font-woff',
		'webp' => 'image/webp',
		'appcache' => 'text/cache-manifest',
		'manifest' => 'text/cache-manifest',
		'htc' => 'text/x-component',
		'rdf' => 'application/xml',
		'crx' => 'application/x-chrome-extension',
		'oex' => 'application/x-opera-extension',
		'xpi' => 'application/x-xpinstall',
		'safariextz' => 'application/octet-stream',
		'webapp' => 'application/x-web-app-manifest+json',
		'vcf' => 'text/x-vcard',
		'vtt' => 'text/vtt',
		'mkv' => 'video/x-matroska',
		'pkpass' => 'application/vnd.apple.pkpass'
	)
	[protected] _protocol => 'HTTP/1.1'
	[protected] _status => (int) 200
	[protected] _contentType => 'application/pdf'
	[protected] _headers => array()
	[protected] _body => null
	[protected] _file => null
	[protected] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array()
	[protected] _cookies => array()
}

Nr	Query	Took (ms)
1	select distinct Plat.nom from plats Plat, menus Menu where Plat.id = Menu.hoe_code and Menu.date_fab = '2025-07-03' and Menu.periode = 2	40
2	select nom from (select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 1 and Plat.id = Menu.via_code and Menu.date_fab = '2025-07-03' union select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 1 and Plat.id = Menu.leg_code and Menu.date_fab = '2025-07-03' union select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 1 and Plat.id = Menu.pg3_code and Menu.date_fab = '2025-07-03') Plat order by nom	124
3	select nom from (select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 2 and Plat.id = Menu.via_code and Menu.date_fab = '2025-07-03' union select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 2 and Plat.id = Menu.leg_code and Menu.date_fab = '2025-07-03' union select distinct Plat.nom from plats Plat, menus Menu where Menu.id_tm = 2 and Plat.id = Menu.pg3_code and Menu.date_fab = '2025-07-03') Plat order by nom	119