$student .= ' ' . $rows['gm_username']; } if ($student == ' ') { //count($student_arr)在没有学生的情况下还是1 $student_arr = NULL; $student = '无'; } //$row['gm_num']="'".$row['gm_num']; echo $i + 1 . "\t" . $row['gm_username'] . "\t" . $row['gm_num'] . "\t" . $row['gm_zc'] . "\t" . $row['gm_funds'] . "\t" . count($student_arr) . "\t" . $student . "\n"; } } if ($_POST['source'] == 'czjl') { //引入资金专用函数库 require dirname(__FILE__) . '/includes/funds.func.php'; $sql = "SELECT * FROM gm_funds AS f INNER JOIN gm_teacher AS t ON f.gm_num=t.gm_num ORDER BY f.gm_time DESC,f.gm_num,f.gm_lmoney DESC"; $num = _num_rows($sql); $res = _query($sql); echo "序号\t操作种类\t姓名\t工号\t操作日期\t支出/收入\t剩余经费\t摘要\n"; for ($i = 0; $i < $num; $i++) { $row = _fetch_array_list($res); $type = _check_funds_type($row['gm_ftype']); if ($type == '<i>撤销</i>') { $type = '撤销'; } if ($row['gm_ftype'] == 10 or $row['gm_ftype'] == 20) { $type .= "[已撤销]"; } echo $i + 1 . "\t" . $type . "\t" . $row['gm_username'] . "\t" . $row['gm_num'] . "\t" . $row['gm_time'] . "\t" . $row['gm_money'] . "\t" . $row['gm_lmoney'] . "\t" . $row['gm_details'] . "\n"; } } }
<th class="sortableCol" >管理类型</th> <th class="sortableCol">申请时间</th> <th class="sortableCol">金额</th> <th class="sortableCol" >事由</th> <th>操作</th> </tr> </thead> <tbody> <?php for ($i = 1; $i <= $pagesize; $i++) { $rows = _fetch_array_list($res); if ($rows['gm_num'] == '') { break; } $gm_details = _cut($rows['gm_details'], 10); $rows['gm_ftype'] = _check_funds_type($rows['gm_ftype']); $rows['gm_money'] = _check_money($rows['gm_money']); echo "<tr><td>{$i}</td><td><a href='stu_date_one.php?num={$rows['gm_num']}' class='a'>{$rows['gm_username']}</a></td><td>{$rows['gm_num']}</td><td>{$rows['gm_sex']}</td><td>{$rows['gm_grade']}</td><td>{$rows['gm_subject']}</td><td>{$rows['gm_type']}</td><td>{$rows['gm_time']}</td><td><b>{$rows['gm_money']}</b></td><td title='{$rows['gm_details']}'>{$gm_details}</td><td><a href='###' onclick=_confirm('确定通过该条申请吗?','funds_active.php?action=pass&id={$rows['gm_fid']}')>通过 </a> <a href='###' onclick=_confirm('确定删除该条申请吗?','funds_active.php?action=del&id={$rows['gm_fid']}')>删除</a></td></tr>"; } ?> </tbody> </table> <?php //引入分页 if ($_GET['action'] == '') { _paging($_system['funds_admin_page']); } echo "<p class='record'>共有<span>{$num}</span>条信息需要审核</p>"; } ?> </div>