Préavis 51/19

Plan d'affectation "Les Vernes".

Document

Type

Date

Preavis-51-19-PA-Les-Vernes.pdf 191.5 Kb

Préavis

10.12.2019

PA-Les-Vernes-reglement.pdf 1.6 Mb

Annexe

10.12.2019

1938_ppa_examen_complementaire.pdf 1.8 Mb

Annexe

10.12.2019

rapp-51-19.pdf 240.4 Kb

Rapport

06.01.2020

Séance du conseil concernée

Messages1 Timeline Exceptions Views2 Route Queries9 Models548 Mails Gate Session Request

7.4.1474.42ms4MBGET conseilcommunal/view/v1/theme/{id}

infolog[08:24:59] LOG.info: {get} object/{id} : 75

Booting (38.85ms)
Application (35.56ms)
1 x Booting (52.21%)
38.85ms
1 x Application (47.79%)
35.56ms

2 templates were rendered

conseilcommunal::roche.theme.detail (\app\Modules\ConseilCommunal\Resources\Views\roche\theme\detail.blade.php)1blade
Params
0
theme
conseilcommunal::roche.layouts.conseil (\app\Modules\ConseilCommunal\Resources\Views\roche\layouts\conseil.blade.php)8blade
Params
0
obLevel
1
__env
2
app
3
errors
4
theme
5
__currentLoopData
6
document
7
loop

Params
0	`theme`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`theme`
5	`__currentLoopData`
6	`document`
7	`loop`

uri: GET conseilcommunal/view/v1/theme/{id}
middleware: web
controller: App\Modules\ConseilCommunal\Http\Controllers\PublicViewController@theme
namespace: App\Modules\ConseilCommunal\Http\Controllers
prefix
where
file: \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:84-93

9 statements were executed16.78ms

select * from [tblCCParams] order by [strParamName] asc1.53ms\app\Modules\ConseilCommunal\Services\ParamService.php:14QSPWebDbroche24

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. \app\Modules\ConseilCommunal\Services\ParamService.php:14 15. \app\Modules\ConseilCommunal\Services\ParamService.php:69 16. \vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:223 17. \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:23 19. \vendor\laravel\framework\src\Illuminate\Container\Container.php:800

select top 1 * from [tblParameter] where [lngSiteID] = 0 and [lngLangID] = -1 and [strParamName] = 'arrLanguageSys'1.24ms\app\Quicksite\Services\ParamService.php:44QSPWebDbroche24

Metadata
Bindings	0. 0 1. -1 2. arrLanguageSys
Backtrace	15. \app\Quicksite\Services\ParamService.php:44 16. \app\Quicksite\Services\ParamService.php:73 17. \app\Quicksite\Services\ParamService.php:36 19. \vendor\laravel\framework\src\Illuminate\Container\Container.php:800 20. \vendor\laravel\framework\src\Illuminate\Container\Container.php:646

select * from [tblParameter] where [lngSiteID] = '0' and ([lngLangID] = -1 or [lngLangID] = 0)2.61ms\app\Quicksite\Services\ParamService.php:82QSPWebDbroche24

Metadata
Bindings	0. 0 1. -1 2. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. \app\Quicksite\Services\ParamService.php:82 15. \app\Quicksite\Services\ParamService.php:36 17. \vendor\laravel\framework\src\Illuminate\Container\Container.php:800 18. \vendor\laravel\framework\src\Illuminate\Container\Container.php:646 19. \vendor\laravel\framework\src\Illuminate\Container\Container.php:601

select top 1 * from [tblCCTheme] left join [tblMember] on [tblCCTheme].[lngAuthorFK] = [idsMembID] left join [tblCCPoliticalParty] on [tblMember].[intMembUDA10] = [idsPoliticalPartyID] where [idsThemeID] = 75

1.28ms\app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:519QSPWebDbroche24

Metadata
Bindings	0. 75
Backtrace	13. \app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:519 14. \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:87 17. \vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 18. \vendor\laravel\framework\src\Illuminate\Routing\Route.php:212 19. \vendor\laravel\framework\src\Illuminate\Routing\Route.php:169

select [idsThemeDocumentID], [strDocName], [dtmDocLastUpdate], [lngDocumentTypeFK], [lngDocSize], [strDocExt], [strDocumentDescription] from [tblCCThemeDocument] inner join [tblDocument] on [tblCCThemeDocument].[lngDocumentFK] = [idsDocID] left join [tblCCMeeting] on [idsMeetingID] = [tblCCThemeDocument].[lngMeetingFK] where [strSession] is null and [lngDocumentTypeFK] <> 7 and [lngDocumentTypeFK] <> 8 and [lngDocumentTypeFK] <> 103 and [lngThemeFK] = '75' order by [tblDocument].[dtmDocLastUpdate] asc, [strDocName] asc

1.58ms\app\Modules\ConseilCommunal\Models\Document\Document.php:113QSPWebDbroche24

Metadata
Bindings	0. 7 1. 8 2. 103 3. 75
Backtrace	12. \app\Modules\ConseilCommunal\Models\Document\Document.php:113 13. \app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:528 14. \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:87 17. \vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 18. \vendor\laravel\framework\src\Illuminate\Routing\Route.php:212

select [strDicRText], [strDicTText] from [tblDicoRef] inner join [tblDicoTrad] on [idsDicRID] = [intDicTDicRefFK] where [strDicRPage] = 'MAIN' and [intDicTLang] = 3

3.9ms\app\Quicksite\Services\TradService.php:90QSPWebDbroche24

Metadata
Bindings	0. MAIN 1. 3
Backtrace	12. \app\Quicksite\Services\TradService.php:90 13. \app\Quicksite\Services\TradService.php:129 14. \app\Quicksite\Services\TradService.php:108 15. \vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:223 16. \app\Modules\ConseilCommunal\Models\Document\Document.php:236

select [strDicRText], [strDicTText] from [tblDicoRef] inner join [tblDicoTrad] on [idsDicRID] = [intDicTDicRefFK] where [strDicRPage] = 'ConseilCommunal' and [intDicTLang] = 3

2.23ms\app\Quicksite\Services\TradService.php:90QSPWebDbroche24

Metadata
Bindings	0. ConseilCommunal 1. 3
Backtrace	12. \app\Quicksite\Services\TradService.php:90 13. \app\Quicksite\Services\TradService.php:150 14. \app\Quicksite\Services\TradService.php:108 15. \vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:223 16. \app\Modules\ConseilCommunal\Models\Document\Document.php:236

select * from [tblCCMeetingTheme] left join [tblCCMeeting] on [tblCCMeetingTheme].[lngMeetingFK] = [idsMeetingID] where [dtmMeetingDate] <= '2025-06-05 08:24:59.886' and [lngThemeFK] = 75 and [lngMeetingThemeTypeFK] = 4 order by [lngThemeHistoryFK] asc

1.36ms\app\Modules\ConseilCommunal\Models\Theme\MeetingTheme.php:51QSPWebDbroche24

Metadata
Bindings	0. 2025-06-05 08:24:59.886 1. 75 2. 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. \app\Modules\ConseilCommunal\Models\Theme\MeetingTheme.php:51 13. \app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:548 14. \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:87 17. \vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 18. \vendor\laravel\framework\src\Illuminate\Routing\Route.php:212

select top 1 * from [tblCCMeetingTheme] where [lngThemeFK] = '75' and [lngmeetingthemetypefk] = 01.05ms\app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:619QSPWebDbroche24

Metadata
Bindings	0. 75 1. 0
Backtrace	13. \app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:619 14. \app\Modules\ConseilCommunal\Http\Controllers\DocumentsController.php:606 15. \app\Modules\ConseilCommunal\Http\Controllers\PublicViewController.php:87 18. \vendor\laravel\framework\src\Illuminate\Routing\ControllerDispatcher.php:45 19. \vendor\laravel\framework\src\Illuminate\Routing\Route.php:212

app\Quicksite\Models\Parameter: 480
App\Modules\ConseilCommunal\Models\Parameters\Params: 68

_token: ChMEXMFCvTZWrNOHW6x19U0jOVNGEE0eBmofqB01
locale: fr
PHPDEBUGBAR_STACK_DATA: []

path_info

/conseilcommunal/view/v1/theme/75

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:8 [▶
  "content-type" => array:1 [▶
    0 => ""
  ]
  "content-length" => array:1 [▶
    0 => "0"
  ]
  "x-original-url" => array:1 [▶
    0 => "/conseilcommunal/view/v1/theme/75"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "172.16.2.233"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/4.0 (compatible; Win32; WinHttp.WinHttpRequest.5)"
  ]
  "host" => array:1 [▶
    0 => "www.roche-vd.ch"
  ]
  "accept" => array:1 [▶
    0 => "*/*"
  ]
]

request_server

  0 of 0   
array:88 [▶
  "_FCGI_X_PIPE_" => "\\.\pipe\IISFCGI-ad21a573-84c0-4e09-bcad-69f1ac1a8c37"
  "PHP_FCGI_MAX_REQUESTS" => "10000"
  "ALLUSERSPROFILE" => "C:\ProgramData"
  "APPDATA" => "C:\Windows\system32\config\systemprofile\AppData\Roaming"
  "APP_POOL_CONFIG" => "C:\inetpub\temp\apppools\wwwRoche24\wwwRoche24.config"
  "APP_POOL_ID" => "wwwRoche24"
  "CommonProgramFiles" => "C:\Program Files\Common Files"
  "CommonProgramFiles(x86)" => "C:\Program Files (x86)\Common Files"
  "CommonProgramW6432" => "C:\Program Files\Common Files"
  "COMPUTERNAME" => "QS-WEB-COM-N233"
  "ComSpec" => "C:\Windows\system32\cmd.exe"
  "DriverData" => "C:\Windows\System32\Drivers\DriverData"
  "LOCALAPPDATA" => "C:\Windows\system32\config\systemprofile\AppData\Local"
  "NUMBER_OF_PROCESSORS" => "4"
  "OS" => "Windows_NT"
  "Path" => "C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;c:\php;C:\ProgramData\ComposerSetup\bin;C:\Program Files\Microsoft VS Code\bin;C:\Program Files\Git\cmd;C:\Program Files\BackupClient\CommandLineTool\;C:\Program Files (x86)\Common Files\Acronis\FileProtector\;C:\Program Files (x86)\Common Files\Acronis\FileProtector64\;C:\Program Files\BackupClient\PyShell\bin\;C:\Program Files (x86)\Common Files\Acronis\SnapAPI\;C:\Windows\system32\config\systemprofile\AppData\Local\Microsoft\WindowsApps ◀C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;c:\php;C:\ProgramData\ComposerS ▶"
  "PATHEXT" => ".COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC"
  "PROCESSOR_ARCHITECTURE" => "AMD64"
  "PROCESSOR_IDENTIFIER" => "AMD64 Family 25 Model 17 Stepping 1, AuthenticAMD"
  "PROCESSOR_LEVEL" => "25"
  "PROCESSOR_REVISION" => "1101"
  "ProgramData" => "C:\ProgramData"
  "ProgramFiles" => "C:\Program Files"
  "ProgramFiles(x86)" => "C:\Program Files (x86)"
  "ProgramW6432" => "C:\Program Files"
  "PSModulePath" => "C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules"
  "PUBLIC" => "C:\Users\Public"
  "SystemDrive" => "C:"
  "SystemRoot" => "C:\Windows"
  "TEMP" => "C:\Windows\TEMP"
  "TMP" => "C:\Windows\TEMP"
  "USERDOMAIN" => "GAN-LAN-DTC"
  "USERNAME" => "QS-WEB-COM-N233$"
  "USERPROFILE" => "C:\Windows\system32\config\systemprofile"
  "windir" => "C:\Windows"
  "ORIG_PATH_INFO" => "/coreapi/public/index.php"
  "URL" => "/coreapi/public/index.php"
  "SERVER_SOFTWARE" => "Microsoft-IIS/10.0"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "SERVER_PORT_SECURE" => "0"
  "SERVER_PORT" => "80"
  "SERVER_NAME" => "www.roche-vd.ch"
  "SCRIPT_NAME" => "/coreapi/public/index.php"
  "SCRIPT_FILENAME" => "E:\wwwFiles\Hosting\wwwRoche24\coreapi\public\index.php"
  "REQUEST_URI" => "/conseilcommunal/view/v1/theme/75"
  "REQUEST_METHOD" => "GET"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "38292"
  "REMOTE_HOST" => "172.16.210.221"
  "REMOTE_ADDR" => "172.16.210.221"
  "QUERY_STRING" => ""
  "PATH_TRANSLATED" => "E:\wwwFiles\Hosting\wwwRoche24\coreapi\public\index.php"
  "LOGON_USER" => ""
  "LOCAL_ADDR" => "172.16.2.233"
  "INSTANCE_META_PATH" => "/LM/W3SVC/14"
  "INSTANCE_NAME" => "WWWROCHE24"
  "INSTANCE_ID" => "14"
  "HTTPS_SERVER_SUBJECT" => ""
  "HTTPS_SERVER_ISSUER" => ""
  "HTTPS_SECRETKEYSIZE" => ""
  "HTTPS_KEYSIZE" => ""
  "HTTPS" => "off"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "DOCUMENT_ROOT" => "E:\wwwFiles\Hosting\wwwRoche24"
  "CONTENT_TYPE" => ""
  "CONTENT_LENGTH" => "0"
  "CERT_SUBJECT" => ""
  "CERT_SERIALNUMBER" => ""
  "CERT_ISSUER" => ""
  "CERT_FLAGS" => ""
  "CERT_COOKIE" => ""
  "AUTH_USER" => ""
  "AUTH_PASSWORD" => "******"
  "AUTH_TYPE" => ""
  "APPL_PHYSICAL_PATH" => "E:\wwwFiles\Hosting\wwwRoche24\"
  "APPL_MD_PATH" => "/LM/W3SVC/14/ROOT"
  "IIS_UrlRewriteModule" => "7,1,1993,2336"
  "HTTP_X_ORIGINAL_URL" => "/conseilcommunal/view/v1/theme/75"
  "HTTP_X_FORWARDED_FOR" => "172.16.2.233"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_USER_AGENT" => "Mozilla/4.0 (compatible; Win32; WinHttp.WinHttpRequest.5)"
  "HTTP_HOST" => "www.roche-vd.ch"
  "HTTP_ACCEPT" => "*/*"
  "HTTP_CONTENT_LENGTH" => "0"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/coreapi/public/index.php"
  "REQUEST_TIME_FLOAT" => 1749104699.8191
  "REQUEST_TIME" => 1749104699
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 05 Jun 2025 06:24:59 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkJRT2JSbEFZblZ0WllTQk0zYzIySnc9PSIsInZhbHVlIjoiSXZYNllBd1BaQ3RnUlpvQXVRWGswcWpacFgzejhyWHV6VjVkeTltUDhzSEZuSlwvd0NNSUlsa1c4YTA0dGpNQ2giLCJtYWMiOiJjZDhlOTk5OWQ4OWRiOWIzMmFhNDBiNjIxODNmNzU1ZGUxZjJkNTljMmQyNDVkODc0ZDBhYjU1MmYzZGIyNGEwIn0%3D; expires=Thu, 05-Jun-2025 08:24:59 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJRT2JSbEFZblZ0WllTQk0zYzIySnc9PSIsInZhbHVlIjoiSXZYNllBd1BaQ3RnUlpvQXVRWGswcWpacFgzejhyWHV6VjVkeTltUDhzSEZuSlwvd0NNSUlsa1c4YTA0dGpNQ2giLCJtY ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkJRT2JSbEFZblZ0WllTQk0zYzIySnc9PSIsInZhbHVlIjoiSXZYNllBd1BaQ3RnUlpvQXVRWGswcWpacFgzejhyWHV6VjVkeTltUDhzSEZuSlwvd0NNSUlsa1c4YTA0dGpNQ2giLCJtYWMiOiJjZDhlOTk5OWQ4OWRiOWIzMmFhNDBiNjIxODNmNzU1ZGUxZjJkNTljMmQyNDVkODc0ZDBhYjU1MmYzZGIyNGEwIn0%3D; expires=Thu, 05-Jun-2025 08:24:59 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJRT2JSbEFZblZ0WllTQk0zYzIySnc9PSIsInZhbHVlIjoiSXZYNllBd1BaQ3RnUlpvQXVRWGswcWpacFgzejhyWHV6VjVkeTltUDhzSEZuSlwvd0NNSUlsa1c4YTA0dGpNQ2giLCJtY ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▶
  "_token" => "ChMEXMFCvTZWrNOHW6x19U0jOVNGEE0eBmofqB01"
  "locale" => "fr"
  "PHPDEBUGBAR_STACK_DATA" => []
]

Guichet virtuel

Salles communales

Agenda

News

Contact

Galeries photos

Préavis 51/19

Plan d'affectation "Les Vernes".

1 x Booting (52.21%)	38.85ms
1 x Application (47.79%)	35.56ms

Officiel

Administration

Vivre à Roche

Préavis 51/19

Plan d'affectation "Les Vernes".

Décret sur l'assainissement des chauffages et chauffe-eau électriques

Plus de détails dans la rubrique News