if ($rows['pertype'] != 0) { if ($rows['appkey'] == 2) { ?> <tr> <td nowrap class="TableContent" align="right" width="130"> <span style="font-size:16px;"><?php echo $rows['name']; ?> </span></td> <td class="TableData"> <b>日期:</b><?php echo $rows['approvaldate']; ?> <br> <b>状态:</b><?php echo work_pertype($rows['pertype']); ?> <br> <b>批示:</b><?php echo $rows['lnstructions']; ?> <br></td> </tr> <?php } 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)) { ?> <tr> <td nowrap class="TableContent" align="right" width="130"> <span style="font-size:16px;"><?php
$result = $db->fetch_all($sql); $i = 0; foreach ($result as $rows) { $sql = "SELECT * FROM " . DB_TABLEPRE . "workclass_flow WHERE fid = '" . $rows['flowid'] . "'"; $flow = $db->fetch_one_array($sql); $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>