<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>多表头表格</title>
</head>
<body>
<div style='width:100%; height:2800px; overflow:scroll;'><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【全基地合计】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>21210</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>13275</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>7936</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>10116</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>3484</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>6632</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-11094</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-9791</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1304</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4572</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2168</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2403</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1072</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>458</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>614</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-3500</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1710</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1789</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>604</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>296</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>308</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-600</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-292</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-308</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>9236</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>6482</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2753</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>6916</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2610</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4306</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-2320</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-3872</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1553</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>807</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>338</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>469</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>80</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>80</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-727</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-338</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-389</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声酒柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1803</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>562</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1241</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>352</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>92</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>260</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1451</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-470</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-981</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4189</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>3428</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>761</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1692</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>320</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1372</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-2497</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-3108</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>611</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱扬州】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>6101</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4319</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1782</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4708</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1668</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>3040</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1393</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-2651</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1258</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>68</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>68</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-68</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-68</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4319</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2918</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1401</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>3835</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1518</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2317</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-484</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1400</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>916</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>42</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>42</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-42</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-42</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1666</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1401</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>265</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>873</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>150</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>723</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-793</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1251</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>458</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声酒柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>5</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>5</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-5</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-5</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱中山东菱OEM】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>36</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>36</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-36</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-36</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>36</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>36</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-36</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-36</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱成都】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2085</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1524</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>561</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>661</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>400</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>261</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1424</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1124</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-300</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>881</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>458</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>423</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>491</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>230</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>261</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-390</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-228</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-162</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1204</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1066</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>138</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>170</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>170</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1034</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-896</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-138</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱顺德】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1943</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1377</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>567</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1246</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>632</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>614</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-697</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-745</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>47</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1262</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1017</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>245</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1216</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>632</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>584</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-46</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-385</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>339</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>77</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>58</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>19</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>10</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>10</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-67</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-58</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-9</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>561</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>301</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>259</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>20</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>20</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-541</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-301</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-239</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>44</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>44</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-44</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-44</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱宿迁双鹿】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱宁波申丝】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>98</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>30</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>68</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>120</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>120</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>22</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-30</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>52</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>87</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>30</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>57</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>120</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>120</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>33</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-30</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>63</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>11</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>11</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-11</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-11</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱平度】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>10939</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>6024</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4915</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>3381</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>784</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2597</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-7558</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-5240</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-2318</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>721</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>338</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>383</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>80</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>80</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-641</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-338</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-303</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2769</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2089</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>680</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1374</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>230</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1144</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1395</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1859</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>464</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冷柜</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1175</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>261</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>914</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>332</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>92</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>240</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-843</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-169</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-674</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4449</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2138</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>2311</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>952</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>458</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>494</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-3497</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1680</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-1817</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>1238</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>903</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>335</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>639</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>639</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-599</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-903</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>304</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声洗衣机</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>588</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>296</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>292</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-584</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-292</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-292</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱盐城】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td></tr></table><table cellpadding='1' cellspacing='1' border='1'> <caption align='top'>2021-07-30--【冰箱南京】-基地下单情况</caption><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>基地 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' rowspan='2'>合计 </td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='2'>下单目标</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单实际</td> <td style='text-align:center;vertical-align:middle;background:#E3E3A4' colspan='3'>下单差异</td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td> <td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>合计</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线上</div></td><td style='text-align:center;vertical-align:middle;background:#FF9900'><div style='width:80px'>线下</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>合计</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td></tr> <tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>容声冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td></tr><tr style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>海信冰箱</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td> <td style='text-align:center;vertical-align:middle;'><div style='width:80px'>4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>0</div></td><td style='text-align:center;vertical-align:middle;'><div style='width:80px'>-4</div></td></tr></table><div>
</body>
</html>
package com.hisense.iam800;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.HashSet;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import org.apache.commons.lang3.StringEscapeUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.IndexedColors;
import org.apache.poi.ss.usermodel.Workbook;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.ibm.wsdl.util.StringUtils;
import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.ExportParams;
import cn.afterturn.easypoi.excel.entity.params.ExcelExportEntity;
/*各个基地表格汇总*/
public class BaseTableUtils {
private static Logger logger = Logger.getLogger(TableUtils.class);
private static String styleCss=" style='table-layout: fixed;border:1px solid #cad9ea;padding:0 1em 0;width=100%;'";
private static String tdTitleCss=" style='text-align:center;vertical-align:middle;background:#E3E3A4'";
private static String tdTitleCss2=" style='text-align:center;vertical-align:middle;background:#FF9900'";
private static String tdCss=" style='text-align:center;vertical-align:middle;'";
// 时间处理类
static DataUtils dataUtils = new DataUtils();
public static void main(String[] args) {
List<BaseDto> baseList = getBaseApiData();
Map<String, Object> map=exportToKV(baseList);
Set<String> line=(LinkedHashSet<String>) map.get("line");
String allTable="<div style='width:100%; height:2800px; overflow:scroll;'>";
for(String n:line) {
allTable+=map.get(n);
("line>>>>>"+n+">>>allTable>>>>>>>>>>"+allTable);
}
allTable+="<div>";
(">>>allTable>>>>>>>>>>"+allTable);
// for(String n:line) {
// ("line>>>>>"+n);
// }
//String content=(String) map.get("全基地合计");
//("content>>>>>>>>>>"+content);
}
public static String getAllContent(List<BaseDto> baseList) {
Map<String, Object> map=exportToKV(baseList);
Set<String> line=(LinkedHashSet<String>) map.get("line");
String allTable="<div style='width:100%; height:2800px; overflow:scroll;'>";
for(String n:line) {
allTable+=map.get(n);
("line>>>>>"+n+">>>allTable>>>>>>>>>>"+allTable);
}
allTable+="<div>";
(">>>allTable>>>>>>>>>>"+allTable);
return allTable;
}
public static Map<String, Object> exportToKV(List<BaseDto> base) {
//产品基地类型==表格内容
Map<String,Object> fileMap=new HashMap<>();
//基础分类数据
Set<String> lineBase=new LinkedHashSet(); //产品线-基地
lineBase.add("全基地合计");
for(BaseDto b:base) {
if(b.getProduct_line().equals("冰箱")) {
lineBase.add(b.getProduct_line()+b.getStorage_base());
} else {
continue;
}
}
lineBase.remove("冰箱全基地合计");
//k-V 产品线基地:汇总集合
Map<String,Object> typeList=new HashMap<>();
for(String type:lineBase) {
//产品线基地
List<BaseDto> list=new ArrayList<>();
BaseDto total=new BaseDto();
for(BaseDto b:base) {
if(org.apache.commons.lang3.StringUtils.isNotEmpty(b.getStorage_base())) {
//全品类
if(type.equals("全基地合计")&&type.equals(b.getStorage_base())&&b.getProduct_line().equals("冰箱")) {
//全品类---各个数据集合
if(!b.getGoods_type_name().contains("合计")) {
list.add(b);
}
//全品类---合计
if(b.getGoods_type_name().equals("合计")){
(">>>>111>>>>"+b.getGoods_type_name()+type);
total=new BaseDto();
total=b;
//合计对象
typeList.put("全品类合计", total);
}
}else if(!type.equals("全基地合计")&&b.getProduct_line().equals("冰箱")){
//产品线基地---各个数据集合
String str1=b.getProduct_line()+b.getStorage_base();
if(type.equals(str1)&&(!b.getGoods_type_name().contains("合计"))) {
list.add(b);
}
//产品线基地---合计
if(b.getGoods_type_name().equals("合计")){
total=b;
//合计对象
typeList.put("合计"+b.getProduct_line()+b.getStorage_base(), total);
}
}
}else {
continue;
}
}
typeList.put(type, list);
}
fileMap.put("line", lineBase);
//产品基地类型==表格内容封装
for (String t : lineBase) {
// 全部数据汇总
List<BaseDto> list = (List<BaseDto>) typeList.get(t);
BaseDto total=new BaseDto();
if(t.contains("冰箱")) {
total= (BaseDto) typeList.get("合计"+t);
}else if(t.contains("空调")){
total= (BaseDto) typeList.get("合计"+t);
} else if(t.contains("全基地合计")){
total= (BaseDto) typeList.get("全品类合计");
}
List<String> small=new ArrayList<>();
small.add("下单实际");
small.add("下单差异");
// 标题
String day = dataUtils.getYesterday(new Date(), 0);
String title = day + "--【" + t + "】-基地下单情况";
String allstr = //"<div style='width:1000px; height:280px; overflow:scroll;'>"+
"<table cellpadding='1' cellspacing='1' border='1'> "
+ "<caption align='top'>" + title + "</caption>";
// 动态标题
String t1 = getTitle(small);
// 动态标题数据
String t2 = getTitleDate(list,total,small);
allstr+=t1;
allstr+=t2;
allstr += "</table>";
//+ "</div>";
("【table-content】---"+allstr);
// 数据封装
fileMap.put(t, allstr);
}
return fileMap;
}
// 【动态标题】
private static String getTitle(List<String> small) {
String title="<tr "+styleCss+">" +
" <td"+tdTitleCss+" rowspan='2'>基地 </td>" +
" <td"+tdTitleCss+" rowspan='2'>合计 </td>" +
" <td"+tdTitleCss+" colspan='2'>下单目标</td>" ;
for(String sm:small) {
title+=" <td"+tdTitleCss+" colspan='3'>"+sm+"</td>" ;
}
title+="</tr> "
+ "<tr "+styleCss+">" +
" <td"+tdTitleCss2+"><div style='width:80px'>线上</div></td>" +
" <td"+tdTitleCss2+"><div style='width:80px'>线下</div></td>" ;
for(String sm:small) {
title+= "<td"+tdTitleCss2+"><div style='width:80px'>合计</div></td>"
+ "<td"+tdTitleCss2+"><div style='width:80px'>线上</div></td>"
+ "<td"+tdTitleCss2+"><div style='width:80px'>线下</div></td>" ;
}
title+= "</tr> ";
return title;
}
// 【动态数据】
private static String getTitleDate(List<BaseDto> list,BaseDto total, List<String> small) {
String titleData = "";
//合计行
titleData+="<tr "+styleCss+">" +
" <td"+tdCss+"><div style='width:80px'>合计</div></td>" +
" <td"+tdCss+"><div style='width:80px'>"+total.getObjective_all()+"</div></td>" +
" <td"+tdCss+"><div style='width:80px'>"+total.getOn_line_up_esqty()+"</div></td>" +
" <td"+tdCss+"><div style='width:80px'>"+total.getOn_line_down_esqty()+"</div></td>" ;
//实际下单
titleData+=
"<td"+tdCss+"><div style='width:80px'>"+total.getReality_all()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+total.getOn_line_up_reqty()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+total.getOn_line_down_reqty()+"</div></td>" ;
//差异下单
titleData+=
"<td"+tdCss+"><div style='width:80px'>"+total.getDifference_all()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+total.getOn_line_up_difference()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+total.getOn_line_down_difference()+"</div></td>" ;
titleData+= "</tr> ";
//基地行
for(BaseDto ba:list) {
titleData+="<tr "+styleCss+">" +
" <td"+tdCss+"><div style='width:80px'>"+ba.getGoods_type_name()+"</div></td>"+
" <td"+tdCss+"><div style='width:80px'>"+ba.getObjective_all()+"</div></td>" +
" <td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_up_esqty()+"</div></td>" +
" <td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_down_esqty()+"</div></td>";
//实际下单
titleData+=
"<td"+tdCss+"><div style='width:80px'>"+ba.getReality_all()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_up_reqty()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_down_reqty()+"</div></td>" ;
//差异下单
titleData+=
"<td"+tdCss+"><div style='width:80px'>"+ba.getDifference_all()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_up_difference()+"</div></td>"
+ "<td"+tdCss+"><div style='width:80px'>"+ba.getOn_line_down_difference()+"</div></td>" ;
titleData+= "</tr>" ;
}
return titleData;
}
private static List<BaseDto> getBaseApiData() {
List<BaseDto> res = new ArrayList<>();
String date = dataUtils.getYesterday(new Date(), 0);
String url ="http:///sd/ords/edw_apex/sd/dwsd_lr_tf_base_daily_ship_p_s?user_key=47919b0749133c83a3f5cef2dc4fa290&";
// url += "zdate=2021-06-22";
url += "zdate=" + date;
("【调用接口API参数】0 时间=" + date + ">>>>>>>>url" + url);
String getData = HttpParam.Get(url);
JSONObject json = JSONObject.parseObject(getData);
//
String items = null;
if (json.get("items") == null) {
return res;
} else {
items = json.get("items") + "";
JSONArray jsons = JSONArray.parseArray(items);
for (int i = 0; i < jsons.size(); i++) {
BaseDto dto = JSONObject.toJavaObject(jsons.getJSONObject(i), BaseDto.class);
res.add(dto);
}
return res;
}
}
}
