# Search Type 80: Time Span + Profit Center + Work Order + Item/Operation/MIS - Test Scripts

## Overview

Test scripts for Search Type 80 (Time Span + Profit Center + Work Order + Item/Operation/MIS). This is the most comprehensive search type, allowing users to find work orders within a specified date range, filtered by profit center, specific work order numbers, and part operations (Item Number, Operation Number, MIS Number, and MIS Revision).

**Filters Enabled:**
- Timespan (Min Date, Max Date)
- Profit Center
- Work Order
- Part Operations (Item Number, Operation Number, MIS Number, MIS Revision)

---

## Valid Test Data

### Timespan
Valid date range in database: **1905-01-20** to **2020-09-01**

Recommended test ranges:
- Recent: `2020-01-01` to `2020-09-01`
- Mid-range: `2018-01-01` to `2019-12-31`
- Historical: `2016-01-01` to `2017-12-31`

### Profit Centers (Branch Codes)

| Code |
|------|
| 1AM |
| 1BM |
| 1CM |
| 1PM |
| 2DM |
| 2SM |
| 3TM |
| 4IM |
| 5SM |

### Work Orders

| WorkOrderNumber | ItemNumber |
|-----------------|------------|
| 99059700 | 00598004702 |
| 99002260 | 82070000028 |
| 99002259 | 82070000027 |
| 99002258 | 82070000019 |
| 99002257 | 82070000018 |
| 99002256 | 82070000017 |
| 99002255 | 00855140333 |
| 99002254 | 00855480834 |
| 99002252 | 82070000016 |
| 99002251 | 00855910448 |
| 99002250 | 82070000015 |
| 99002249 | 00855480834 |
| 99002248 | 00855910446 |
| 99002247 | 00855910447 |
| 99002246 | 82900171601 |

### Item/Operation/MIS (Part Operations)

| ItemNumber | OperationNumber | MisNumber | MisRevision |
|------------|-----------------|-----------|-------------|
| 00-5952-012-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-012-02 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-02 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-05 | 505 | 26-1002-003-00 | 00 |
| 00-5952-013-06 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-01 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-02 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-05 | 505 | 26-1002-003-00 | 00 |
| 00-5952-014-06 | 505 | 26-1002-003-00 | 00 |

---

## Positive Test Cases

### TC-080-P01: Single Value for All Filters

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Single Values Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Search appears in search list with correct name
- Search criteria shows all filter values correctly

---

### TC-080-P02: Multiple Profit Centers with Single Work Order and Part Operation

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Multiple PC Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit centers: `1AM`, `1BM`, `1CM`
7. Add work order `99002259`
8. Add part operation:
   - Item: `00-5952-012-02`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows all three profit centers

---

### TC-080-P03: Single Profit Center with Multiple Work Orders

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Multiple WO Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1PM`
7. Add work orders: `99002258`, `99002257`, `99002256`
8. Add part operation:
   - Item: `00-5952-013-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows all three work orders

---

### TC-080-P04: Single Profit Center and Work Order with Multiple Part Operations

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Multiple Part Ops Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `2DM`
7. Add work order `99002255`
8. Add part operation 1:
   - Item: `00-5952-013-02`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Add part operation 2:
   - Item: `00-5952-013-05`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
10. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows both part operations

---

### TC-080-P05: Multiple Values for All Filter Types

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 All Multiple Values Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit centers: `1PM`, `2SM`, `3TM`
7. Add work orders: `99002254`, `99002252`, `99002251`
8. Add part operation 1:
   - Item: `00-5952-013-06`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Add part operation 2:
   - Item: `00-5952-014-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
10. Add part operation 3:
    - Item: `00-5952-014-02`
    - Operation: `505`
    - MIS: `26-1002-003-00`
    - Revision: `00`
11. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Search criteria shows all profit centers, work orders, and part operations

---

### TC-080-P06: Recent Date Range

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Recent Range Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2020-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `4IM`
7. Add work order `99002250`
8. Add part operation:
   - Item: `00-5952-014-05`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Date range correctly captured

---

### TC-080-P07: Historical Date Range

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Historical Range Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2016-01-01`
5. Set maximum date to `2017-12-31`
6. Add profit center `5SM`
7. Add work order `99002249`
8. Add part operation:
   - Item: `00-5952-014-06`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Historical date range correctly captured

---

### TC-080-P08: Same Day Date Range

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Same Day Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2019-06-15`
5. Set maximum date to `2019-06-15`
6. Add profit center `1AM`
7. Add work order `99002248`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- Same-day date range is accepted

---

### TC-080-P09: All Profit Centers

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 All Profit Centers Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add all profit centers: 1AM, 1BM, 1CM, 1PM, 2DM, 2SM, 3TM, 4IM, 5SM
7. Add work order `99002247`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- All 9 profit centers are captured in search criteria

---

### TC-080-P10: Maximum Work Orders

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Many Work Orders Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work orders: 99059700, 99002260, 99002259, 99002258, 99002257, 99002256, 99002255, 99002254, 99002252, 99002251
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Search is created with status "Queued"
- All 10 work orders are captured in search criteria

---

## Negative Test Cases

### TC-080-N01: Missing Search Name

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Leave search name empty
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates search name is required

---

### TC-080-N02: Missing Profit Center

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing PC Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Do not add any profit centers
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates at least one profit center is required

---

### TC-080-N03: Missing Work Order

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing WO Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Do not add any work orders
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates at least one work order is required

---

### TC-080-N04: Missing Part Operation

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Part Op Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Do not add any part operations
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates at least one part operation is required

---

### TC-080-N05: Missing Minimum Date

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Min Date Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Leave minimum date empty
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates minimum date is required

---

### TC-080-N06: Missing Maximum Date

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Max Date Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Leave maximum date empty
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates maximum date is required

---

### TC-080-N07: Invalid Date Range (Min > Max)

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Invalid Date Range Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2020-09-01`
5. Set maximum date to `2018-01-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates minimum date must be before or equal to maximum date

---

### TC-080-N08: Incomplete Part Operation - Missing Item

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Item Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation with missing Item:
   - Item: (empty)
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates Item Number is required for part operation

---

### TC-080-N09: Incomplete Part Operation - Missing Operation Number

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Operation Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation with missing Operation:
   - Item: `00-5952-012-01`
   - Operation: (empty)
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates Operation Number is required for part operation

---

### TC-080-N10: Incomplete Part Operation - Missing MIS Number

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing MIS Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation with missing MIS:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: (empty)
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates MIS Number is required for part operation

---

### TC-080-N11: Incomplete Part Operation - Missing MIS Revision

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Missing Revision Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation with missing Revision:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: (empty)
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates MIS Revision is required for part operation

---

### TC-080-N12: Whitespace-Only Search Name

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "   " (whitespace only)
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Form validation error is displayed
- Search is not created
- Error message indicates valid search name is required

---

### TC-080-N13: Missing All Required Filters

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 No Filters Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Leave minimum date empty
5. Leave maximum date empty
6. Do not add any profit centers
7. Do not add any work orders
8. Do not add any part operations
9. Click Submit button

**Expected Results:**
- Form validation errors are displayed for all missing required fields
- Search is not created
- Error messages indicate all required fields: min date, max date, profit center, work order, and part operation

---

### TC-080-N14: Invalid Date Format

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Invalid Date Format Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Attempt to enter `99/99/9999` as minimum date
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Date field rejects invalid format
- Form validation error is displayed if invalid date is accepted
- Search is not created

---

### TC-080-N15: Empty Work Order Value

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Empty WO Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Add profit center `1AM`
7. Attempt to add empty string as work order
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Empty work order value is rejected
- Form validation error is displayed
- Search is not created

---

### TC-080-N16: Empty Profit Center Value

**Preconditions:**
- User is logged in
- User has access to the Submit Search page

**Steps:**
1. Navigate to Submit Search page
2. Enter search name: "Type80 Empty PC Test"
3. Select "Time Span + Profit Center + Work Order + Item/Operation/MIS" search type (Type 80)
4. Set minimum date to `2018-01-01`
5. Set maximum date to `2020-09-01`
6. Attempt to add empty string as profit center
7. Add work order `99002260`
8. Add part operation:
   - Item: `00-5952-012-01`
   - Operation: `505`
   - MIS: `26-1002-003-00`
   - Revision: `00`
9. Click Submit button

**Expected Results:**
- Empty profit center value is rejected
- Form validation error is displayed
- Search is not created

---

## Notes

- Type 80 is the most comprehensive search type with four filter categories
- Part operations consist of four fields: Item Number, Operation Number, MIS Number, and MIS Revision
- All four fields are required for each part operation entry
- Multiple values within each filter type result in OR conditions
- Combined filters use AND logic between filter types (profit center AND work order AND part operation)
- Work order numbers are from the WorkOrder_Hist table
- MIS data comes from the MisData_Hist table