$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);