37" Unisex Lab Coat in DWHZ

Style: 83402 Color: DWHZ

Choose a size:

Size Chart

Selected Color:

15.97

Please Choose A Size

About This Product

Unisex Fit lab coat features a notched collar and a four front button closure. Also featured are one chest pocket with a pen and instrument slot, and two lower patch pockets with side entry for easy access to pant pockets. Back waist belt and back kick pleat complete this coat. Center back length: 37".

Fabric: 65 Poly/35 Cotton Poplin

More like this

More in this style 37" Unisex Lab Coat (83402)

More in this color (DWHZ)

Size Chart

Dickies: Unisex Fit

Sizes
XS
S
M
L
XL
2XL
3XL
4XL
5XL
Size Comparison 2-4 6-8 10-12 14-16 18-20 22-24 26-28 30-32 34-36
Chest/Bust 33-34 35-37 38-40 41-44 45-48 49-52 53-56 57-60 61-64
Waist 25-26 27-29 30-32 33-36 37-40 41-44 45-48 49-52 53-57
Hip 34-35 36-38 39-41 42-45 46-49 50-53 54-57 58-61 62-65

Inseam: Regular 31", Petite 28.5", Tall 34"

SetCategoryInfo in BaseModel.php Array ( [category_name] => Men [description] => Array ( [short] => [long] => ) [required] => Array ( [gsa] => Array ( [0] => 40 ) [gba] => Array ( [0] => 89 ) [gscia] => Array ( [0] => 143 ) ) [optional] => Array ( [scia] => Array ( [0] => 1431 [1] => 1440 [2] => 1443 [3] => 1444 ) [sa] => Array ( [0] => 4010 [1] => 4012 [2] => 4066 ) [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 8905 [4] => 8916 ) ) ) RegisterFilter in BaseSearch.php szFilterField: gsa szFilterVal: 40 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gba szFilterVal: 89 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: gscia szFilterVal: 143 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1431 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1440 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1443 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: scia szFilterVal: 1444 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4010 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4012 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: sa szFilterVal: 4066 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8900 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8901 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8902 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8905 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: ba szFilterVal: 8916 szFilterType: optional RegisterFilter in BaseSearch.php szFilterField: style_id szFilterVal: 83402 szFilterType: required RegisterFilter in BaseSearch.php szFilterField: color_id szFilterVal: DWHZ szFilterType: required RegisterFilter in BaseSearch.php szFilterField: start_num szFilterVal: 12 szFilterType: required ! ignored filter start_num 1. I'm in the Search function in BaseSearch.php. SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL In BaseSearch::GenerateQuery with 2 filters In BaseSearch::GenerateQuery filters are Array ( [required] => Array ( [group] => Array ( [sa] => Array ( [0] => 40 ) [ba] => Array ( [0] => 89 ) [scia] => Array ( [0] => 143 ) ) [style_id] => Array ( [0] => 83402 ) [color_id] => Array ( [0] => DWHZ ) ) [optional] => Array ( [scia] => Array ( [0] => 1431 [1] => 1440 [2] => 1443 [3] => 1444 ) [sa] => Array ( [0] => 4010 [1] => 4012 [2] => 4066 ) [ba] => Array ( [0] => 8900 [1] => 8901 [2] => 8902 [3] => 8905 [4] => 8916 ) ) ) Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=style_id value= 83402 group= base:=style # join: p.style_id = #.style_id AND #.style_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorRequired in QueryBuilderBase::RefactorRequired field=color_id value= DWHZ group= base:=color # join: p.color_id = #.color_id AND #.color_id = '?' AND #.status = 0 End RefactorRequired QueryBuilderBase::RefactorRequired query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorOptional in QueryBuilderBase::RefactorOptional field=scia value= group= base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_attribute_id = '?' AND #.status = 0 End RefactorOptional QueryBuilderBase::RefactorOptional query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute opt1_scia, color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1431','1440','1443','1444') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorOptional in QueryBuilderBase::RefactorOptional field=sa value= group= base:=style_attribute # join: p.style_id = #.style_id AND #.style_attribute_id = '?' AND #.status = 0 End RefactorOptional QueryBuilderBase::RefactorOptional query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM style_attribute opt1_sa, sci_attribute opt1_scia, color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = opt1_sa.style_id AND opt1_sa.style_attribute_id IN ('4010','4012','4066') AND opt1_sa.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1431','1440','1443','1444') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Starting RefactorOptional in QueryBuilderBase::RefactorOptional field=ba value= group= base:=sci_attribute # join: p.style_id = #.style_id AND p.color_id = #.color_id AND p.identifier_id = #.identifier_id AND #.sci_group_id='89' AND #.sci_attribute_id = '?' AND #.status = 0 End RefactorOptional QueryBuilderBase::RefactorOptional query SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute opt1_ba, style_attribute opt1_sa, sci_attribute opt1_scia, color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8905','8916') AND opt1_ba.status = 0 AND p.style_id = opt1_sa.style_id AND opt1_sa.style_attribute_id IN ('4010','4012','4066') AND opt1_sa.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1431','1440','1443','1444') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '^' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL Checking for a brand RefactorQuery: 8900 | | 1; Refactored to: SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute opt1_ba, style_attribute opt1_sa, sci_attribute opt1_scia, color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8905','8916') AND opt1_ba.status = 0 AND p.style_id = opt1_sa.style_id AND opt1_sa.style_attribute_id IN ('4010','4012','4066') AND opt1_sa.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1431','1440','1443','1444') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '83402' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL =============================================================================================== Executed this query: SELECT p.upc_id, p.style_id, p.color_id, p.wholesale_price, c.color_name, c.color_description, s.style_name, s.style_description, p.quantity_ats, p.size_id, a.attribute_description, p.style_category_group_id FROM sci_attribute opt1_ba, style_attribute opt1_sa, sci_attribute opt1_scia, color req1_c, style req1_s, ( color c, style s, product p) LEFT JOIN sci_attribute scia ON (p.style_id = scia.style_id AND p.color_id = scia.color_id AND p.identifier_id = scia.identifier_id AND scia.sci_group_id = 5) LEFT JOIN attribute a ON (a.attribute_id = scia.sci_attribute_id) LEFT JOIN sci_attribute exscia ON (p.style_id = exscia.style_id AND p.color_id = exscia.color_id AND p.identifier_id=exscia.identifier_id AND exscia.sci_attribute_id = '647') WHERE p.style_id = opt1_ba.style_id AND p.color_id = opt1_ba.color_id AND p.identifier_id = opt1_ba.identifier_id AND opt1_ba.sci_group_id='89' AND opt1_ba.sci_attribute_id IN ('8900','8901','8902','8905','8916') AND opt1_ba.status = 0 AND p.style_id = opt1_sa.style_id AND opt1_sa.style_attribute_id IN ('4010','4012','4066') AND opt1_sa.status = 0 AND p.style_id = opt1_scia.style_id AND p.color_id = opt1_scia.color_id AND p.identifier_id = opt1_scia.identifier_id AND opt1_scia.sci_attribute_id IN ('1431','1440','1443','1444') AND opt1_scia.status = 0 AND p.color_id = req1_c.color_id AND req1_c.color_id IN ('DWHZ') AND req1_c.status = 0 AND p.style_id = req1_s.style_id AND req1_s.style_id IN ('83402') AND req1_s.status = 0 AND p.style_id = '83402' AND c.status = 0 AND s.status = 0 AND p.color_id = c.color_id AND p.style_id = s.style_id AND exscia.sci_attribute_id IS NULL =============================================================================================== No errors found. Well done! Attaching Attributes to results 1 style attributes found 1 color attributes found 1 sci attributes found Exiting attribute attachment after 0.029926061630249 seconds Exiting Search in BaseSearch =============================================================================================== label: obj->type: apparel