| | 1 | | @model DailyReport |
| | 2 | | @{ |
| 0 | 3 | | int ASMAvailablePct = 0; |
| 0 | 4 | | int EPPAvailablePct = 0; |
| 0 | 5 | | int HTRAvailablePct = 0; |
| | 6 | |
|
| 0 | 7 | | int ASMSLL = 0; |
| 0 | 8 | | int HTRSLL = 0; |
| | 9 | |
|
| 0 | 10 | | int ASMUnloadTemps = 0; |
| 0 | 11 | | int HTRUnloadTemps = 0; |
| | 12 | |
|
| 0 | 13 | | int reportIndex = (int)DateTime.Now.DayOfWeek; |
| | 14 | |
|
| 0 | 15 | | int numberOfDaysInWeek = Model.CurrentWeek.OutsByDay.Count; |
| | 16 | |
|
| 0 | 17 | | ManualReportEntries rpt = Model.ManualReportEntries; |
| | 18 | |
|
| | 19 | | string myClass; |
| 0 | 20 | | List<string> toolsDownGreaterThan12Hours = new(); |
| | 21 | |
|
| 0 | 22 | | foreach (KeyValuePair<string, ToolStateByType> state in Model.ToolStateByType) |
| 0 | 23 | | { |
| 0 | 24 | | if (state.Key != "Metrology" && state.Key != "Cleans") |
| 0 | 25 | | toolsDownGreaterThan12Hours.AddRange(state.Value.ToolsDownGreaterThan12Hours); |
| 0 | 26 | | } |
| | 27 | |
|
| 0 | 28 | | toolsDownGreaterThan12Hours.Sort(); |
| | 29 | | } |
| | 30 | |
|
| | 31 | | @{ |
| 0 | 32 | | ViewData["Title"] = "Daily Passdown | Mesa Reporting Services"; |
| | 33 | | } |
| | 34 | |
|
| | 35 | | <div aria-label="breadcrumb"> |
| | 36 | | <ol class="breadcrumb"> |
| | 37 | | <li class="breadcrumb-item"><a asp-area="" asp-controller="Home" asp-action="Index">Home</a></li> |
| | 38 | | <li class="breadcrumb-item"><a asp-area="" asp-controller="ProductionReport" asp-action="Index">Production Repor |
| | 39 | | <li class="breadcrumb-item active" aria-current="page">Production Passdown Report</li> |
| | 40 | | </ol> |
| | 41 | | </div> |
| | 42 | | <br /> |
| | 43 | |
|
| | 44 | | <div class="text-center"> |
| | 45 | | <h2>Daily Report</h2> |
| | 46 | | <br /><br /> |
| | 47 | | </div> |
| | 48 | |
|
| | 49 | | <button class="btn btn-outline-dark float-start dailyReportTable" onclick="toggleWeek()">View Previous Week</button> |
| | 50 | | <button class="btn btn-outline-dark float-end dailyReportTable hidden" onclick="toggleWeek()">View Current Week</button> |
| | 51 | | <br /><br /> |
| | 52 | |
|
| | 53 | | <div class="table-responsive dailyReportTable"> |
| 0 | 54 | | <partial name="_DailyReportPartial" model="@Model.CurrentWeek"/> |
| | 55 | | </div> |
| | 56 | |
|
| | 57 | | <div class="table-responsive dailyReportTable hidden"> |
| 0 | 58 | | <partial name="_DailyReportPartial" model="@Model.PreviousWeek" /> |
| | 59 | | </div> |
| | 60 | |
|
| | 61 | | <br /> |
| | 62 | | <h5>Daily Target Summary</h5> |
| | 63 | | <ul> |
| 0 | 64 | | <li>Operator HC: (Days/Nights) @rpt.OperatorHeadcountDays/@rpt.OperatorHeadcountNights</li> |
| 0 | 65 | | <li>Total Call Outs: (Days/Nights) @rpt.OperatorCallOutsDays/@rpt.OperatorCallOutsNights</li> |
| 0 | 66 | | <li>Engineering HC: @rpt.EngineeringHeadcountDays/@rpt.EngineeringHeadcountNights</li> |
| 0 | 67 | | <li>Total Call Outs: (Days/Nights) @rpt.EngineeringCallOutsDays/@rpt.EngineeringCallOutsNights</li> |
| 0 | 68 | | <li>Maintenance HC: @rpt.MaintenanceHeadcountDays/@rpt.MaintenanceHeadcountNights</li> |
| 0 | 69 | | <li>Total Call Outs: (Days/Nights) @rpt.MaintenanceCallOutsDays/@rpt.MaintenanceCallOutsNights</li> |
| | 70 | | </ul> |
| | 71 | | <br /> |
| | 72 | | <ul> |
| 0 | 73 | | <li>Bottle Change (@rpt.BottleChanges.Split(',').Length): @string.Join(", ", rpt.BottleChanges.Split(','))</li> |
| 0 | 74 | | <li>Daily Part Changes (@rpt.DailyPartChanges.Split(',').Length): @string.Join(", ", rpt.DailyPartChanges.Split(',') |
| 0 | 75 | | <li>Weekly Part Changes (@rpt.WeeklyPartChanges.Split(',').Length): @string.Join(", ", rpt.WeeklyPartChanges.Split(' |
| | 76 | | </ul> |
| | 77 | | <br /> |
| | 78 | | <a class="btn btn-light" asp-controller="ProductionReport" asp-action="EditDailyReport">Edit</a> |
| | 79 | | <br /><br /> |
| 0 | 80 | | <h5>Current Reactors Down(@(Model.ToolStateByType["ASM"].DownTools + Model.ToolStateByType["EPP"].DownTools + Model.Tool |
| | 81 | | <div class="row"> |
| | 82 | | <div class="col-lg-4"> |
| 0 | 83 | | ASM(@Model.ToolStateByType["ASM"].DownTools) |
| | 84 | | <table class="table table-sm"> |
| | 85 | | <thead> |
| | 86 | | <tr> |
| | 87 | | <th scope="col">Reactor</th> |
| | 88 | | <th scope="col">Owner</th> |
| | 89 | | <th scope="col">Issue</th> |
| | 90 | | </tr> |
| | 91 | | </thead> |
| | 92 | | <tbody> |
| 0 | 93 | | @foreach (ToolStateCurrent tool in Model.ToolStateByType["ASM"].ToolStateCurrents) |
| 0 | 94 | | { |
| 0 | 95 | | if (tool.BasicStateDescription != "Productive" && tool.ReactorStatus != "Out of Service") |
| 0 | 96 | | { |
| 0 | 97 | | string owner = ""; |
| | 98 | |
|
| 0 | 99 | | if (Model.ToolStatesByOwner["Maintenance"].Contains(tool.ReactorStatus)) |
| 0 | 100 | | owner = "Maint"; |
| 0 | 101 | | else if (Model.ToolStatesByOwner["Engineering"].Contains(tool.ReactorStatus)) |
| 0 | 102 | | owner = "Eng"; |
| | 103 | | else |
| 0 | 104 | | owner = "Prod"; |
| | 105 | |
|
| | 106 | | <tr> |
| 0 | 107 | | <td>@tool.Tool</td> |
| 0 | 108 | | <td>@owner</td> |
| 0 | 109 | | <td>@tool.Comment</td> |
| | 110 | | </tr> |
| 0 | 111 | | } |
| 0 | 112 | | } |
| | 113 | | </tbody> |
| | 114 | | </table> |
| | 115 | | </div> |
| | 116 | | </div> |
| | 117 | | <div class="row"> |
| | 118 | | <div class="col-lg-4"> |
| 0 | 119 | | EPP(@Model.ToolStateByType["EPP"].DownTools) |
| | 120 | | <table class="table table-sm"> |
| | 121 | | <thead> |
| | 122 | | <tr> |
| | 123 | | <th scope="col">Reactor</th> |
| | 124 | | <th scope="col">Owner</th> |
| | 125 | | <th scope="col">Issue</th> |
| | 126 | | </tr> |
| | 127 | | </thead> |
| | 128 | | <tbody> |
| 0 | 129 | | @foreach (ToolStateCurrent tool in Model.ToolStateByType["EPP"].ToolStateCurrents) |
| 0 | 130 | | { |
| 0 | 131 | | if (tool.BasicStateDescription != "Productive" && tool.ReactorStatus != "Out of Service") |
| 0 | 132 | | { |
| 0 | 133 | | string owner = ""; |
| | 134 | |
|
| 0 | 135 | | if (Model.ToolStatesByOwner["Maintenance"].Contains(tool.ReactorStatus)) |
| 0 | 136 | | owner = "Maint"; |
| 0 | 137 | | else if (Model.ToolStatesByOwner["Engineering"].Contains(tool.ReactorStatus)) |
| 0 | 138 | | owner = "Eng"; |
| | 139 | | else |
| 0 | 140 | | owner = "Prod"; |
| | 141 | |
|
| | 142 | | <tr> |
| 0 | 143 | | <td>@tool.Tool</td> |
| 0 | 144 | | <td>@owner</td> |
| 0 | 145 | | <td>@tool.Comment</td> |
| | 146 | | </tr> |
| 0 | 147 | | } |
| 0 | 148 | | } |
| | 149 | | </tbody> |
| | 150 | | </table> |
| | 151 | | </div> |
| | 152 | | </div> |
| | 153 | | <div class="row"> |
| | 154 | | <div class="col-lg-4"> |
| 0 | 155 | | HTR(@Model.ToolStateByType["HTR"].DownTools) |
| | 156 | | <table class="table table-sm"> |
| | 157 | | <thead> |
| | 158 | | <tr> |
| | 159 | | <th scope="col">Reactor</th> |
| | 160 | | <th scope="col">Owner</th> |
| | 161 | | <th scope="col">Issue</th> |
| | 162 | | </tr> |
| | 163 | | </thead> |
| | 164 | | <tbody> |
| 0 | 165 | | @foreach (ToolStateCurrent tool in Model.ToolStateByType["HTR"].ToolStateCurrents) |
| 0 | 166 | | { |
| 0 | 167 | | if (tool.BasicStateDescription != "Productive" && tool.ReactorStatus != "Out of Service") |
| 0 | 168 | | { |
| 0 | 169 | | string owner = ""; |
| | 170 | |
|
| 0 | 171 | | if (Model.ToolStatesByOwner["Maintenance"].Contains(tool.ReactorStatus)) |
| 0 | 172 | | owner = "Maint"; |
| 0 | 173 | | else if (Model.ToolStatesByOwner["Engineering"].Contains(tool.ReactorStatus)) |
| 0 | 174 | | owner = "Eng"; |
| | 175 | | else |
| 0 | 176 | | owner = "Prod"; |
| | 177 | |
|
| | 178 | | <tr> |
| 0 | 179 | | <td>@tool.Tool</td> |
| 0 | 180 | | <td>@owner</td> |
| 0 | 181 | | <td>@tool.Comment</td> |
| | 182 | | </tr> |
| 0 | 183 | | } |
| 0 | 184 | | } |
| | 185 | | </tbody> |
| | 186 | | </table> |
| | 187 | | </div> |
| | 188 | | </div> |
| | 189 | | <ul> |
| | 190 | | <li>Application ENG (0):</li> |
| 0 | 191 | | <li>Reactors (Capacity @(Model.NumberOfToolsWaferSize6IN + Model.NumberOfToolsWaferSize8IN)) |
| | 192 | | <ul> |
| 0 | 193 | | <li>150mm - @Model.NumberOfToolsWaferSize6IN</li> |
| 0 | 194 | | <li>200mm - @Model.NumberOfToolsWaferSize8IN</li> |
| | 195 | | </ul> |
| | 196 | | </li> |
| 0 | 197 | | <li>Scheduled Reactors (@(Model.NumberOfToolsWaferSize6INScheduled + Model.NumberOfToolsWaferSize8INScheduled)): |
| | 198 | | <ul> |
| 0 | 199 | | <li>150mm - @Model.NumberOfToolsWaferSize6INScheduled</li> |
| 0 | 200 | | <li>200mm - @Model.NumberOfToolsWaferSize8INScheduled</li> |
| | 201 | | </ul> |
| | 202 | | </li> |
| | 203 | | <li>Dual Layer Reactors |
| | 204 | | <ul> |
| 0 | 205 | | <li>ASM - @(string.Join(',', Model.DualLayerReactors["ASM"]))</li> |
| 0 | 206 | | <li>HTR - @(string.Join(',', Model.DualLayerReactors["HTR"]))</li> |
| 0 | 207 | | <li>EpiPro - @(string.Join(',', Model.DualLayerReactors["EPP"]))</li> |
| | 208 | | </ul> |
| | 209 | | </li> |
| | 210 | | <li>Engineering Focus Tools (Down > 12 hours) |
| | 211 | | <ul> |
| 0 | 212 | | <li>@string.Join(",", toolsDownGreaterThan12Hours)</li> |
| | 213 | | </ul> |
| | 214 | | </li> |
| 0 | 215 | | <li>Metrology Down (@Model.ToolStateByType["Metrology"].DownTools): |
| 0 | 216 | | @if (Model.ToolStateByType["Metrology"].DownTools > 0) |
| 0 | 217 | | { |
| | 218 | | <ul> |
| 0 | 219 | | @foreach (ToolStateCurrent tool in Model.ToolStateByType["Metrology"].ToolStateCurrents) |
| 0 | 220 | | { |
| 0 | 221 | | if (tool.BasicStateDescription != "Productive" && tool.ReactorStatus != "Out of Service") |
| 0 | 222 | | { |
| 0 | 223 | | <li>@tool.Tool</li> |
| 0 | 224 | | } |
| 0 | 225 | | } |
| | 226 | | </ul> |
| 0 | 227 | | } |
| | 228 | | </li> |
| | 229 | | <li> |
| 0 | 230 | | Cleans (@Model.ToolStateByType["Cleans"].DownTools): |
| 0 | 231 | | @if (Model.ToolStateByType["Cleans"].DownTools > 0) |
| 0 | 232 | | { |
| | 233 | | <ul> |
| 0 | 234 | | @foreach (ToolStateCurrent tool in Model.ToolStateByType["Cleans"].ToolStateCurrents) |
| 0 | 235 | | { |
| 0 | 236 | | if (tool.BasicStateDescription != "Productive" && tool.ReactorStatus != "Out of Service") |
| 0 | 237 | | { |
| 0 | 238 | | <li>@tool.Tool</li> |
| 0 | 239 | | } |
| 0 | 240 | | } |
| | 241 | | </ul> |
| 0 | 242 | | } |
| | 243 | | </li> |
| | 244 | | </ul> |
| | 245 | | <br /><br /> |
| | 246 | | <div class="table-responsive"> |
| | 247 | | <table class="table"> |
| | 248 | | <thead> |
| | 249 | | <tr> |
| | 250 | | <th scope="col"></th> |
| | 251 | | <th scope="col">Monday</th> |
| | 252 | | <th scope="col">Tuesday</th> |
| | 253 | | <th scope="col">Wednesday</th> |
| | 254 | | <th scope="col">Thursday</th> |
| | 255 | | <th scope="col">Friday</th> |
| | 256 | | <th scope="col">Saturday</th> |
| | 257 | | <th scope="col">Sunday</th> |
| | 258 | | <th scope="col">WTD</th> |
| | 259 | | <th scope="col">Daily / Weekly</th> |
| | 260 | | </tr> |
| | 261 | | <tr> |
| | 262 | | <th scope="col"></th> |
| 0 | 263 | | @for (int i = 0; i < 7; i++) |
| 0 | 264 | | { |
| 0 | 265 | | <th scope="col">@Model.StartDate.AddDays(i).ToString("MM/dd/yyyy")</th> |
| 0 | 266 | | } |
| | 267 | | <th scope="col">Actual</th> |
| | 268 | | <th scope="col">Target</th> |
| | 269 | | </tr> |
| | 270 | | </thead> |
| | 271 | | <tbody> |
| | 272 | | <tr> |
| | 273 | | <td scope="row">ASMs Uptime</td> |
| 0 | 274 | | @for (int i = 0; i < 7; i++) |
| 0 | 275 | | { |
| 0 | 276 | | if (i < Model.ToolAvailibilityByType["ASM"].Count) |
| 0 | 277 | | { |
| 0 | 278 | | int availiblePct = (int)Math.Round(float.Parse(Model.ToolAvailibilityByType["ASM"][i].AvailableP |
| | 279 | |
|
| 0 | 280 | | if (availiblePct < 82) |
| 0 | 281 | | myClass = "table-danger text-danger"; |
| | 282 | | else |
| 0 | 283 | | myClass = ""; |
| | 284 | |
|
| 0 | 285 | | <td class="@myClass">@(availiblePct + "%")</td> |
| | 286 | |
|
| 0 | 287 | | ASMAvailablePct += availiblePct; |
| 0 | 288 | | } |
| | 289 | | else |
| 0 | 290 | | { |
| | 291 | | <td></td> |
| 0 | 292 | | } |
| 0 | 293 | | } |
| 0 | 294 | | <td>@(ASMAvailablePct / numberOfDaysInWeek + "%")</td> |
| | 295 | | <td>82%</td> |
| | 296 | | </tr> |
| | 297 | | <tr> |
| | 298 | | <td scope="row">EPPs Uptime</td> |
| 0 | 299 | | @for (int i = 0; i < 7; i++) |
| 0 | 300 | | { |
| 0 | 301 | | if (i < Model.ToolAvailibilityByType["EPP"].Count) |
| 0 | 302 | | { |
| 0 | 303 | | int availiblePct = (int)Math.Round(float.Parse(Model.ToolAvailibilityByType["EPP"][i].AvailableP |
| | 304 | |
|
| 0 | 305 | | if (availiblePct < 60) |
| 0 | 306 | | myClass = "table-danger text-danger"; |
| | 307 | | else |
| 0 | 308 | | myClass = ""; |
| | 309 | |
|
| 0 | 310 | | <td class="@myClass">@(availiblePct + "%")</td> |
| | 311 | |
|
| 0 | 312 | | EPPAvailablePct += availiblePct; |
| 0 | 313 | | } |
| | 314 | | else |
| 0 | 315 | | { |
| | 316 | | <td></td> |
| 0 | 317 | | } |
| 0 | 318 | | } |
| 0 | 319 | | <td>@(EPPAvailablePct / numberOfDaysInWeek + "%")</td> |
| | 320 | | <td>60%</td> |
| | 321 | | </tr> |
| | 322 | | <tr> |
| | 323 | | <td scope="row">HTRs Uptime</td> |
| 0 | 324 | | @for (int i = 0; i < 7; i++) |
| 0 | 325 | | { |
| 0 | 326 | | if (i < Model.ToolAvailibilityByType["HTR"].Count) |
| 0 | 327 | | { |
| 0 | 328 | | int availiblePct = (int)Math.Round(float.Parse(Model.ToolAvailibilityByType["HTR"][i].AvailableP |
| | 329 | |
|
| 0 | 330 | | if (availiblePct < 78) |
| 0 | 331 | | myClass = "table-danger text-danger"; |
| | 332 | | else |
| 0 | 333 | | myClass = ""; |
| | 334 | |
|
| 0 | 335 | | <td class="@myClass">@(availiblePct + "%")</td> |
| | 336 | |
|
| 0 | 337 | | HTRAvailablePct += availiblePct; |
| 0 | 338 | | } |
| | 339 | | else |
| 0 | 340 | | { |
| | 341 | | <td></td> |
| 0 | 342 | | } |
| 0 | 343 | | } |
| 0 | 344 | | <td>@(HTRAvailablePct / numberOfDaysInWeek + "%")</td> |
| | 345 | | <td>78%</td> |
| | 346 | | </tr> |
| | 347 | | <tr> |
| | 348 | | <td scope="row">ASMs SLL Tool Count</td> |
| 0 | 349 | | @for (int i = 0; i < 7; i++) |
| 0 | 350 | | { |
| 0 | 351 | | if (i < Model.SLLTools.Count()) |
| 0 | 352 | | { |
| 0 | 353 | | <td>@Model.SLLTools[i].ASM</td> |
| | 354 | |
|
| 0 | 355 | | ASMSLL += @Model.SLLTools[i].ASM; |
| 0 | 356 | | } |
| | 357 | | else |
| 0 | 358 | | { |
| | 359 | | <td></td> |
| 0 | 360 | | } |
| 0 | 361 | | } |
| 0 | 362 | | <td>@(ASMSLL / numberOfDaysInWeek)</td> |
| | 363 | | <td>0</td> |
| | 364 | | </tr> |
| | 365 | | <tr> |
| | 366 | | <td scope="row">HTRs SLL Tool Count</td> |
| 0 | 367 | | @for (int i = 0; i < 7; i++) |
| 0 | 368 | | { |
| 0 | 369 | | int index = i == 6 ? 0 : i + 1; |
| | 370 | |
|
| 0 | 371 | | if (i < Model.SLLTools.Count()) |
| 0 | 372 | | { |
| 0 | 373 | | <td>@Model.SLLTools[i].HTR</td> |
| | 374 | |
|
| 0 | 375 | | HTRSLL += @Model.SLLTools[i].HTR; |
| 0 | 376 | | } |
| | 377 | | else |
| 0 | 378 | | { |
| | 379 | | <td></td> |
| 0 | 380 | | } |
| 0 | 381 | | } |
| 0 | 382 | | <td>@(HTRSLL / numberOfDaysInWeek)</td> |
| | 383 | | <td>0</td> |
| | 384 | | </tr> |
| | 385 | | <tr> |
| | 386 | | <td scope="row">ASMs <700C (Unload Temps)</td> |
| 0 | 387 | | @for (int i = 0; i < 7; i++) |
| 0 | 388 | | { |
| 0 | 389 | | if (i < Model.UnloadTempsByDay.Count()) |
| 0 | 390 | | { |
| 0 | 391 | | <td>@Model.UnloadTempsByDay[i].ASMUnloadsBelow700</td> |
| | 392 | |
|
| 0 | 393 | | ASMUnloadTemps += @Model.UnloadTempsByDay[i].ASMUnloadsBelow700; |
| 0 | 394 | | } |
| | 395 | | else |
| 0 | 396 | | { |
| | 397 | | <td></td> |
| 0 | 398 | | } |
| 0 | 399 | | } |
| 0 | 400 | | <td>@(ASMUnloadTemps / numberOfDaysInWeek)</td> |
| | 401 | | <td>0</td> |
| | 402 | | </tr> |
| | 403 | | <tr> |
| | 404 | | <td scope="row">HTRs <700C (Unload Temps)</td> |
| 0 | 405 | | @for (int i = 0; i < 7; i++) |
| 0 | 406 | | { |
| 0 | 407 | | if (i < Model.UnloadTempsByDay.Count()) |
| 0 | 408 | | { |
| 0 | 409 | | <td>@Model.UnloadTempsByDay[i].HTRUnloadsBelow700</td> |
| | 410 | |
|
| 0 | 411 | | HTRUnloadTemps += @Model.UnloadTempsByDay[i].HTRUnloadsBelow700; |
| 0 | 412 | | } |
| | 413 | | else |
| 0 | 414 | | { |
| | 415 | | <td></td> |
| 0 | 416 | | } |
| 0 | 417 | | } |
| 0 | 418 | | <td>@(HTRUnloadTemps / numberOfDaysInWeek)</td> |
| | 419 | | <td>0</td> |
| | 420 | | </tr> |
| | 421 | | </tbody> |
| | 422 | | </table> |
| | 423 | | </div> |