?>
</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'];
