$a8 = unserialize(work_db($id, '_19_58_a8')); $a9 = unserialize(work_db($id, '_19_58_a9')); $a10 = unserialize(work_db($id, '_19_58_a10')); $a11 = unserialize(work_db($id, '_19_58_a11')); $a12 = unserialize(work_db($id, '_19_58_a12')); $a13 = unserialize(work_db($id, '_19_58_a13')); $a14 = unserialize(work_db($id, '_19_58_a14')); for ($i = 0; $i < 15; $i++) { $m++; $htmls .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n <td height=33 class=xl24 width=38 style='height:24.95pt;border-top:none;\n width:29pt'>" . $m . "</td>\n <td class=xl24 width=87 style='border-top:none;border-left:none;width:65pt'>" . $a1[$i] . "</td>\n <td class=xl24 width=119 style='border-top:none;border-left:none;width:89pt'>" . $a2[$i] . "</td>\n <td class=xl24 width=86 style='border-top:none;border-left:none;width:65pt'>" . $a3[$i] . "</td>\n <td class=xl24 width=86 style='border-top:none;border-left:none;width:65pt'>" . $a4[$i] . "</td>\n <td class=xl24 width=113 style='border-top:none;border-left:none;width:85pt'>" . $a5[$i] . "</td>\n <td class=xl24 width=98 style='border-top:none;border-left:none;width:74pt'>" . $a6[$i] . "</td>\n <td class=xl24 width=91 style='border-top:none;border-left:none;width:68pt'>" . $a7[$i] . "</td>\n <td class=xl24 width=93 style='border-top:none;border-left:none;width:70pt'>" . $a8[$i] . "</td>\n <td class=xl24 width=88 style='border-top:none;border-left:none;width:66pt'>" . $a9[$i] . "</td>\n <td class=xl24 width=82 style='border-top:none;border-left:none;width:62pt'>" . $a10[$i] . "</td>\n <td class=xl24 width=112 style='border-top:none;border-left:none;width:84pt'>" . $a11[$i] . "</td>\n <td class=xl24 width=94 style='border-top:none;border-left:none;width:71pt'>" . $a12[$i] . "</td>\n <td class=xl24 width=80 style='border-top:none;border-left:none;width:60pt'>" . $a13[$i] . "</td>\n <td class=xl24 width=130 style='border-top:none;border-left:none;width:98pt'>" . $a14[$i] . "</td>\n </tr>"; } $htmls .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n <td colspan=4 height=33 class=xl27 width=330 style='height:24.95pt;\n width:248pt'>编制:" . work_db($id, '_19_58_3') . "</td>\n <td colspan=11 class=xl27 width=1067 style='width:803pt'>审核:" . w_p_v(190, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n <td width=38 style='width:29pt'></td>\n <td width=87 style='width:65pt'></td>\n <td width=119 style='width:89pt'></td>\n <td width=86 style='width:65pt'></td>\n <td width=86 style='width:65pt'></td>\n <td width=113 style='width:85pt'></td>\n <td width=98 style='width:74pt'></td>\n <td width=91 style='width:68pt'></td>\n <td width=93 style='width:70pt'></td>\n <td width=88 style='width:66pt'></td>\n <td width=82 style='width:62pt'></td>\n <td width=112 style='width:84pt'></td>\n <td width=94 style='width:71pt'></td>\n <td width=80 style='width:60pt'></td>\n <td width=130 style='width:98pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n"; return $htmls; } ?> <!--内容部份 --> <?php $docs = trim(xls_views($row['id'], $row['uid'])); $Path = "data/excel/workclass/" . $row['id'] . ".xls"; $fp = fopen($Path, "w"); fwrite($fp, $docs); fclose($fp); echo $docs; ?> <!--/内容部份 --> <?php include_once 'footer_view.php';
<x:WindowHeight>11640</x:WindowHeight> <x:WindowWidth>19200</x:WindowWidth> <x:WindowTopX>0</x:WindowTopX> <x:WindowTopY>90</x:WindowTopY> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> </x:ExcelWorkbook> </xml><![endif]--> </head> <body link=blue vlink=purple class=xl65>'; $htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=715 style='border-collapse:\n collapse;table-layout:fixed;width:536pt'>\n <col class=xl65 width=160 span=3 style='mso-width-source:userset;mso-width-alt:\n 5120;width:120pt'>\n <col class=xl65 width=235 style='mso-width-source:userset;mso-width-alt:7520;\n width:176pt'>\n <tr height=49 style='mso-height-source:userset;height:36.75pt'>\n <td colspan=4 height=49 class=xl66 width=715 style='height:36.75pt;\n width:536pt'>" . $title . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl67 width=160 style='height:29.25pt;width:120pt'>经办人</td>\n <td class=xl73 width=160 style='border-left:none;width:120pt'>" . project_db($id, '_4_10_2_1') . "</td>\n <td class=xl68 width=160 style='border-left:none;width:120pt'>日期</td>\n <td class=xl74 width=235 style='border-left:none;width:176pt'>" . project_db($id, '_4_10_2_2') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>合同项目</td>\n <td colspan=3 class=xl75 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_3') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>甲方</td>\n <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_4') . "</td>\n <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>乙方</td>\n <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_5') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>合同编号</td>\n <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_6') . "</td>\n <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>项目地点</td>\n <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_7') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>合同类型</td>\n <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . project_db($id, '_4_10_2_8') . "</td>\n <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>合同期限</td>\n <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . project_db($id, '_4_10_2_9') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>合同金额</td>\n <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_10') . "</td>\n </tr>\n <tr height=39 style='mso-height-source:userset;height:29.25pt'>\n <td height=39 class=xl69 width=160 style='height:29.25pt;border-top:none;\n width:120pt'>大写</td>\n <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_11') . "</td>\n </tr>\n <tr height=57 style='mso-height-source:userset;height:42.75pt'>\n <td height=57 class=xl69 width=160 style='height:42.75pt;border-top:none;\n width:120pt'>付款方式</td>\n <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_12') . "</td>\n </tr>\n <tr height=159 style='mso-height-source:userset;height:119.25pt'>\n <td height=159 class=xl69 width=160 style='height:119.25pt;border-top:none;\n width:120pt'>项目内容说明</td>\n <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_13') . "</td>\n </tr>\n <tr height=74 style='mso-height-source:userset;height:55.5pt'>\n <td height=74 class=xl69 width=160 style='height:55.5pt;border-top:none;\n width:120pt'>备注</td>\n <td colspan=3 class=xl78 width=555 style='border-right:1.0pt solid black;\n border-left:none;width:416pt'>" . project_db($id, '_4_10_2_14') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n <td height=44 class=xl69 width=160 style='height:33.0pt;border-top:none;\n width:120pt'>部门负责人审批</td>\n <td class=xl78 width=160 style='border-top:none;border-left:none;width:120pt'>" . w_p_v(4, $id, 'name') . "</td>\n <td class=xl70 width=160 style='border-top:none;border-left:none;width:120pt'>运营负责人审批</td>\n <td class=xl79 width=235 style='border-top:none;border-left:none;width:176pt'>" . w_p_v(5, $id, 'name') . "</td>\n </tr>\n <tr height=44 style='mso-height-source:userset;height:33.0pt'>\n <td height=44 class=xl71 width=160 style='height:33.0pt;border-top:none;\n width:120pt'>财务负责人审批</td>\n <td class=xl80 width=160 style='border-top:none;border-left:none;width:120pt'>" . w_p_v(6, $id, 'name') . "</td>\n <td class=xl72 width=160 style='border-top:none;border-left:none;width:120pt'>总经理审批</td>\n <td class=xl81 width=235 style='border-top:none;border-left:none;width:176pt'>" . w_p_v(7, $id, 'name') . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n <td width=160 style='width:120pt'></td>\n <td width=160 style='width:120pt'></td>\n <td width=160 style='width:120pt'></td>\n <td width=235 style='width:176pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>\n\n"; return $htmls; } ?> <!--内容部份 --> <?php $docs = trim(xls_views($row['lid'], $row['uid'], $row['title'])); $Path = "data/excel/project/l_" . $row['lid'] . ".xls"; $fp = fopen($Path, "w"); fwrite($fp, $docs); fclose($fp); echo $docs; ?> <!--/内容部份 --> <?php include_once 'footer_view.php';