$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "workclass_personnel_log where perid='" . $rows['perid'] . "' ORDER BY lid Asc");
while ($log = $db->fetch_array($query)) {
?>
<tr>
<td nowrap class="TableContent" align="right" width="130">
<span style="font-size:16px;"><?php
echo $log['name'];
?>
</span></td>
<td class="TableData">
<b>日期：</b><?php
echo $log['approvaldate'];
?>
<br>
<b>状态：</b><?php
echo work_pertype_log($log['pertype']);
?>
<br>
<b>批示：</b><?php
echo $log['lnstructions'];
?>
<br></td>
</tr>
<?php
}
}
}
}
?>
<?php
$i++;
$html .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n\t <td height=33 class=xl26 style='height:24.95pt;border-top:none'>第" . $i . "步</td>\n\t <td class=xl27 width=135 style='border-top:none;border-left:none;width:101pt'>" . $flow['flowname'] . "</td>\n\t <td class=xl25 width=423 style='border-top:none;border-left:none;width:317pt'>审批人员：" . $rows['name'] . "</td>\n\t </tr>";
if ($flow['flownum'] == 1) {
$html .= "<tr height=80 style='mso-height-source:userset;height:60.0pt'>\n\t <td colspan=2 height=80 class=xl31 width=189 style='border-right:.5pt solid black;\n\t height:60.0pt;width:142pt'>" . $rows['name'] . "</td>\n\t <td class=xl25 width=423 style='border-top:none;border-left:none;width:317pt'>\n\t <b>日期：</b>" . $rows['approvaldate'] . "<br>\n\t\t <b>状态：</b>";
$html .= work_pertype($rows['pertype']);
$html .= "<br>\n\t\t <b>批示：</b>" . $rows['lnstructions'] . "<br>\n\t\t</td>\n\t </tr>";
} else {
if ($rows['pertype'] != 0) {
if ($rows['appkey'] == 2) {
$html .= "<tr height=80 style='mso-height-source:userset;height:60.0pt'>\n\t\t\t <td colspan=2 height=80 class=xl31 width=189 style='border-right:.5pt solid black;\n\t\t\t height:60.0pt;width:142pt'>" . $rows['name'] . "</td>\n\t\t\t <td class=xl25 width=423 style='border-top:none;border-left:none;width:317pt'>\n\t\t\t <b>日期：</b>" . $rows['approvaldate'] . "<br>\n\t\t\t\t <b>状态：</b>";
$html .= work_pertype($rows['pertype']);
$html .= "<br>\n\t\t\t\t <b>批示：</b>" . $rows['lnstructions'] . "<br>\n\t\t\t\t</td>\n\t\t\t </tr>";
} else {
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "workclass_personnel_log where perid='" . $rows['perid'] . "' ORDER BY lid Asc");
while ($log = $db->fetch_array($query)) {
$html .= "<tr height=80 style='mso-height-source:userset;height:60.0pt'>\n\t\t\t <td colspan=2 height=80 class=xl31 width=189 style='border-right:.5pt solid black;\n\t\t\t height:60.0pt;width:142pt'>" . $log['name'] . "</td>\n\t\t\t <td class=xl25 width=423 style='border-top:none;border-left:none;width:317pt'>\n\t\t\t <b>日期：</b>" . $log['approvaldate'] . "<br>\n\t\t\t\t <b>状态：</b>";
$html .= work_pertype_log($log['pertype']);
$html .= "<br>\n\t\t\t\t <b>批示：</b>" . $log['lnstructions'] . "<br>\n\t\t\t\t</td>\n\t\t\t </tr>";
}
}
}
}
}
$html .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n <td colspan=3 height=33 class=xl33 width=612 style='height:24.95pt;\n width:459pt'>制表人:" . get_realname($row["uid"]) . "</td>\n </tr>\n <![if supportMisalignedColumns]>\n <tr height=0 style='display:none'>\n <td width=54 style='width:41pt'></td>\n <td width=135 style='width:101pt'></td>\n <td width=423 style='width:317pt'></td>\n </tr>\n <![endif]>\n</table>\n\n</body>\n\n</html>";
?>
</div>
<?php
$Path = "data/excel/workclass/" . $row['id'] . ".xls";
$fp = fopen($Path, "w");
fwrite($fp, $html);
fclose($fp);
