?> </td> <td width="90"><?php echo $row['phone']; ?> </td> <td class="info"><?php echo $row['mail']; ?> </td> <td width="50"><?php echo $row['position']; ?> </td> <td width="90"><?php echo get_realdepaname($row['departmentid']); ?> </td> </tr> <?php } ?> </tbody> </table> </div> <div class="fn-clear">
<?php echo public_upload('pic', $result['pic']); ?> </td> <td nowrap class="TableContent" width="90">所属权限组:</td> <td class="TableData"><?php echo get_groupname($result['groupid']); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="90">所属部门:</td> <td class="TableData"> <?php echo get_realdepaname($result['departmentid']); ?> </td> <td nowrap class="TableContent" width="90">所属岗位:</td> <td class="TableData"><?php echo get_postname($result['positionid']); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="90">出生日期:</td> <td class="TableData"> <input type="text" class="BigInput" name="birthdate" style="width:180px;" value="<?php echo $result['birthdate']; ?>
if ($goods_type = getGP('goods_type', 'P')) { $wheresql .= " AND goods_type ='" . $goods_type . "'"; } if ($type = getGP('type', 'P')) { $wheresql .= " AND type ='" . $type . "'"; } $vuidtype = getGP('vuidtype', 'P'); if (!is_superadmin() && $vuidtype == '') { $key1 = $db->result("SELECT * FROM " . DB_TABLEPRE . "office_goods_key where examination like '%" . get_realname($_USER->id) . "%' "); if ($key1['examination'] == '') { $wheresql .= " AND uid = {$_USER->id}"; } } if ($vuidtype != '') { $wheresql .= " AND " . get_subordinate($_USER->id, 'uid'); } $sql = "SELECT * FROM " . DB_TABLEPRE . "office_goods_record WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . $row[number] . "", "" . get_goods_type_name($row['goods_type']) . "", "" . $row['title'] . "", "" . $row['specification'] . "", "" . $row['price'] . "RMB", "" . get_realdepaname($row['department']) . "", "" . $row['recorduser'] . "", "" . $row['recordnum'] . $row['unit'] . "", "" . str_replace("-", ".", $row[date]) . "", "" . $row['examination'] . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
if ($type = getGP('type', 'P')) { $wheresql .= " AND department ='" . $type . "'"; } $vuidtype = getGP('vuidtype', 'P'); if (!is_superadmin() && $vuidtype == '') { $wheresql .= " AND uid = {$_USER->id}"; } if ($vuidtype != '') { $wheresql .= " " . get_subordinate($_USER->id, 'uid'); } //时间 $vstartdate = getGP('vstartdate', 'P'); $venddate = getGP('venddate', 'P'); if ($vstartdate != '' && $venddate != '') { $wheresql .= " AND (startdate>='" . $vstartdate . "' and startdate<='" . $venddate . "')"; } $sql = "SELECT * FROM " . DB_TABLEPRE . "property WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . $row[number] . "", "" . $row[name] . "", "" . get_property_type_name($row[property_type]) . "", "" . get_realdepaname($row[department]) . "", "" . $row[cptl_val] . "", "" . $row[cptl_bal] . "", "" . $row[dpct_yy] . "", "" . $row[sum_dpct] . "", "" . $row[mon_dpct] . "", "" . str_replace("-", ".", $row[startdate]) . "", "" . $row[content] . "", "" . $row[user] . "", "" . str_replace("-", ".", $row[date]) . "", "" . get_realname($row['uid']) . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
} if ($department = getGP('department', 'P', 'int')) { $wheresql .= " AND a.departmentid = {$department}"; } if ($usergroup = getGP('usergroup', 'P', 'int')) { $wheresql .= " AND a.groupid = {$usergroup}"; } $sql = "SELECT * FROM " . DB_TABLEPRE . "user a," . DB_TABLEPRE . "user_view b WHERE a.id=b.uid {$wheresql} ORDER BY a.id ASC"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { if ($row['ischeck'] == '1') { $ischeck = '正常'; } else { $ischeck = '禁用'; } $archive = array("" . $row[username] . "", "" . get_groupname($row['groupid']) . "", "" . $row[name] . "", "" . get_postname($row['positionid']) . "", "" . $ischeck . "", "" . $row[loginip] . "", "" . get_realdepaname($row['departmentid']) . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); } elseif ($do == 'add') { if ($_POST['view'] != '') { $id = getGP('id', 'P', 'int'); if ($id != '') { $username = getGP('username', 'P');
</td> <td nowrap align="left" width="120" class="TableContent">岗位:</td> <td class="TableData" width="180" colspan="2"><?php echo get_postname(get_realusername($blog['userid'], 'positionid ')); ?> </td> </tr> <tr> <td nowrap align="left" width="120" class="TableContent">姓名:</td> <td class="TableData" width="180"><?php echo get_human_db($blog['id'], "toa_1_1"); ?> </td> <td nowrap align="left" width="120" class="TableContent">部门:</td> <td class="TableData" width="180" colspan="2"><?php echo get_realdepaname(get_realusername($blog['userid'], 'departmentid ')); ?> </td> </tr> <tr> <td nowrap align="left" width="120" class="TableContent">英文名:</td> <td class="TableData" width="180"><?php echo get_human_db($blog['id'], "toa_1_2"); ?> </td> <td nowrap align="left" width="120" class="TableContent">性别:</td> <td class="TableData" width="180" colspan="2"><?php echo get_human_db($blog['id'], "toa_1_3"); ?> </td> </tr>
?> </td> </tr> <tr> <td nowrap class="TableContent"> 资产名称:</td> <td class="TableData"> <?php echo $blog['name']; ?> </td> </tr> <tr> <td nowrap class="TableContent"> 所属部门:</td> <td class="TableData"> <?php echo get_realdepaname($blog['department']); ?> </td> </tr> <tr> <td nowrap class="TableContent"> 资产净值:</td> <td class="TableData"> <?php echo $blog['cptl_val']; ?> </td> </tr> <tr> <td nowrap class="TableContent"> 残值:</td> <td class="TableData"><?php echo $blog['cptl_bal'];