本文整理汇总了PHP中get_realname函数的典型用法代码示例。如果您正苦于以下问题:PHP get_realname函数的具体用法?PHP get_realname怎么用?PHP get_realname使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了get_realname函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: get_position_list_save_view
function get_position_list_save_view($fatherid = 0, $selid = 0, $layer = 0, $ac, $fileurl)
{
global $db;
$sql = "SELECT * FROM " . DB_TABLEPRE . "goods_type where father='{$fatherid}' ORDER BY id Asc";
$query = $db->query($sql);
if (count($query) > 0) {
for ($i = 0; $i < $layer; $i++) {
$str .= " ";
}
while ($row = $db->fetch_array($query)) {
$rsfno = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "goods_type where father='" . $row[id] . "' ORDER BY id asc limit 0,1");
echo '<tr class="hover">';
echo '<td class="td25"></td>';
echo '<td class="td25">' . get_realname($row['uid']) . '';
echo '<td><div class="board">' . $str . $row['title'] . '</div></td>';
echo '<td width="160">';
get_urlkey("编辑", "admin.php?ac=goods_type_edit&do=edit&fileurl=goods&id=" . $row['id'] . "", "" . $row['uid'] != $_USER->id);
if ($rsfno[id] == '') {
echo ' | ';
get_urlkey("删除", "admin.php?ac=goods_type&fileurl=goods&do=delete&id=" . $row['id'] . "", "" . $row['uid'] != $_USER->id);
}
echo '</td></tr>';
if ($rsfno[id] != '') {
get_position_list_save_view($row['id'], $selid, $layer + 1, $ac, $fileurl);
}
}
}
return;
}
示例2: rawurlencode
if ($title = getGP('title', 'G')) {
$wheresql .= " AND title LIKE '%{$title}%'";
$url .= '&title=' . rawurlencode($title);
}
//时间
$venddate = getGP('venddate', 'G');
$vstartdate = getGP('vstartdate', 'G');
if ($vstartdate != '' && $venddate != '') {
$wheresql .= " AND (issuedate>='" . $vstartdate . "' and issuedate<='" . $venddate . "')";
$url .= '&vstartdate=' . $vstartdate . '&venddate=' . $venddate;
}
if ($ischeck == '1') {
$wheresql .= " AND uid='" . $_USER->id . "'";
}
if ($ischeck == '2') {
$sql = "SELECT classadmin FROM " . DB_TABLEPRE . "bbsclass WHERE classadmin like '%" . get_realname($_USER->id) . "%' ";
$type_bbsclass = $db->fetch_one_array($sql);
if ($type_bbsclass["classadmin"] != '') {
$wheresql .= " AND type = '1'";
}
} else {
if ($ischeck != '1') {
$wheresql .= " AND (type = '2' or type='3')";
}
}
$vuidtype = getGP('vuidtype', 'G');
if ($vuidtype != '') {
if ($vuidtype == '-1') {
$wheresql .= get_subordinate($_USER->id, 'uid');
} else {
$wheresql .= " and uid='" . $vuidtype . "'";
示例3: get_realname
?>
"><?php
echo $row['jobpost'];
?>
</a>
</td>
<td class="info"><?php
echo $row['persondate'];
?>
</td>
<td class="info"><?php
echo $row['jobnum'];
?>
</td>
<td class="info"><?php
echo get_realname($row['uid']);
?>
</td>
<td class="info"><?php
echo $row['date'];
?>
</td>
<td class="action">
<?php
get_urlkey("编辑", "admin.php?ac=job_demand_edit&fileurl=jobs&do=edit&id=" . $row['id'] . "", "" . $row['uid'] != $_USER->id);
?>
</td>
</tr>
<?php
}
示例4: getGP
if ($type = getGP('type', 'G')) {
$wheresql .= " AND type='" . $type . "'";
}
//时间
$vstartdate = getGP('vstartdate', 'G');
$venddate = getGP('venddate', 'G');
if ($vstartdate != '' && $venddate != '') {
$wheresql .= " AND (startdate>'" . $vstartdate . "' and startdate<'" . $venddate . "')";
}
$sql = "SELECT * FROM " . DB_TABLEPRE . "oalog WHERE 1 {$wheresql} and uid='" . $_USER->id . "' ORDER BY id desc";
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
$content = explode('|515158.com|', $row[content]);
$contentdata = "";
for ($i = 0; $i < sizeof($content); $i++) {
if ($content[$i] != '') {
$contentdata = $contentdata . $content[$i];
}
}
$archive = array("" . $row[title] . "", "" . get_realname($row['uid']) . "", "" . $contentdata . "", "" . str_replace('-', '.', $row[startdate]) . "", "" . get_oalog_type($row['type']) . "");
$content[] = $archive;
}
$excel = new ExcelWriter($outputFileName);
if ($excel == false) {
echo $excel->error;
}
foreach ($content as $v) {
$excel->writeLine($v);
}
$excel->sendfile($outputFileName);
}
示例5: and
echo $nview[$i] . '</a> | ';
}
}
?>
<!--
<a href="#" onClick="expression.PrintOut(1,1,1,false,'打印机名',false,false);">+打印文件</a> --> <a href="down.php?urls=<?php
echo "data/excel/workclass/" . $row['id'] . ".xls";
?>
">+导出报表</a>
<?php
$sql = "SELECT * FROM " . DB_TABLEPRE . "workclass_personnel WHERE workid = '" . $row['id'] . "' and (pertype=0 or pertype=2 or pertype=4 or pertype=5) and typeid='" . $row['typeid'] . "' order by perid desc";
$per = $db->fetch_one_array($sql);
//审批
$sql = "SELECT * FROM " . DB_TABLEPRE . "workclass_personnel where name like '%" . get_realname($_USER->id) . "%' and (pertype=0 or pertype=4) and typeid='" . $row['typeid'] . "' and workid='" . $row['id'] . "' order by perid desc";
$per = $db->fetch_one_array($sql);
if ($per['perid'] != '') {
if ($per['appkey'] == 1 && $per['appkey1'] == 1) {
$perlnum = $db->result("SELECT COUNT(*) AS perlnum FROM " . DB_TABLEPRE . "workclass_personnel_log where perid='" . $per['perid'] . "' and uid='" . $_USER->id . "' and pertype=0");
if ($perlnum > 0) {
echo '<a href="admin.php?ac=' . $ac . '&do=personnel&fileurl=' . $fileurl . '&workid=' . $row['id'] . '" style="color:#FF0000;">+在线审批</a>';
}
} else {
echo '<a href="admin.php?ac=' . $ac . '&do=personnel&fileurl=' . $fileurl . '&workid=' . $row['id'] . '" style="color:#FF0000;">+在线审批</a>';
}
}
?>
示例6: project_pertype
$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 .= project_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 .= project_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 . "project_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 .= project_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/project/p_" . $row['id'] . ".xls";
$fp = fopen($Path, "w");
fwrite($fp, $html);
fclose($fp);
示例7: while
echo '</table>';
}
?>
<table class="TableBlock" border="0" width="98%" align="center" style="margin-top:10px;">
<tr>
<td nowrap class="TableHeader" colspan="2" id="m2"><b> 附件下载</b></td>
</tr>
<?php
global $db;
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "fileoffice WHERE officeid='" . $row['id'] . "' and officetype='5' and filetype='2' ORDER BY id asc");
while ($file = $db->fetch_array($query)) {
?>
<tr>
<td nowrap class="TableContent" width="15%"><?php
echo get_realname($file['uid']);
?>
<br><?php
echo $file['date'];
?>
</td>
<td class="TableData">
<?php
echo $file['filename'];
?>
<a href="down.php?urls=<?php
echo $file['fileaddr'];
?>
">+下载</a>
</td>
</tr>
示例8: getGP
if ($documentid = getGP('documentid', 'G')) {
$wheresql .= " AND documentid like '%," . $documentid . "%'";
$url .= '&documentid=' . $documentid;
}
$vuidtype = getGP('vuidtype', 'G');
if ($vuidtype != '') {
if ($vuidtype == '-1') {
$wheresql .= get_subordinate($_USER->id, 'uid');
} else {
$wheresql .= " and uid='" . $vuidtype . "'";
}
$url .= '&vuidtype=' . $vuidtype;
}
if (getGP('type', 'G') != '1') {
if (!is_superadmin() && $vuidtype == '') {
$wheresql .= " and (readuser LIKE'%" . get_realname($_USER->id) . "%' or uid='" . $_USER->id . "' or readuser='全体人员')";
}
} else {
if ($vuidtype == '') {
$wheresql .= " and uid='" . $_USER->id . "'";
}
}
if ($title = getGP('title', 'G')) {
$wheresql .= " AND title LIKE '%{$title}%'";
$url .= '&title=' . rawurlencode($title);
}
//时间
$venddate = getGP('venddate', 'G');
$vstartdate = getGP('vstartdate', 'G');
if ($vstartdate != '' && $venddate != '') {
$wheresql .= " AND (date>='" . $vstartdate . "' and date<='" . $venddate . "')";
示例9: xls_views
//.........这里部分代码省略.........
.xl36
{mso-style-parent:style0;
text-align:center;
vertical-align:middle;
border:.5pt solid windowtext;
background:silver;
mso-pattern:auto none;}
ruby
{ruby-align:left;}
rt
{color:windowtext;
font-size:9.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:宋体;
mso-generic-font-family:auto;
mso-font-charset:134;
mso-char-type:none;
display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>285</x:DefaultRowHeight>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>180</x:HorizontalResolution>
<x:VerticalResolution>180</x:VerticalResolution>
</x:Print>
<x:CodeName>Sheet1</x:CodeName>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>5</x:ActiveRow>
<x:ActiveCol>2</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>285</x:DefaultRowHeight>
<x:CodeName>Sheet2</x:CodeName>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:DefaultRowHeight>285</x:DefaultRowHeight>
<x:CodeName>Sheet3</x:CodeName>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>4530</x:WindowHeight>
<x:WindowWidth>8505</x:WindowWidth>
<x:WindowTopX>480</x:WindowTopX>
<x:WindowTopY>120</x:WindowTopY>
<x:AcceptLabelsInFormulas/>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>';
$htmls .= "<table x:str border=0 cellpadding=0 cellspacing=0 width=1172 style='border-collapse:\n collapse;table-layout:fixed;width:881pt'>\n <col width=72 style='width:54pt'>\n <col width=176 style='mso-width-source:userset;mso-width-alt:5632;width:132pt'>\n <col width=125 style='mso-width-source:userset;mso-width-alt:4000;width:94pt'>\n <col width=138 style='mso-width-source:userset;mso-width-alt:4416;width:104pt'>\n <col width=101 style='mso-width-source:userset;mso-width-alt:3232;width:76pt'>\n <col width=85 style='mso-width-source:userset;mso-width-alt:2720;width:64pt'>\n <col width=79 style='mso-width-source:userset;mso-width-alt:2528;width:59pt'>\n <col width=90 style='mso-width-source:userset;mso-width-alt:2880;width:68pt'>\n <col width=88 style='mso-width-source:userset;mso-width-alt:2816;width:66pt'>\n <col width=92 style='mso-width-source:userset;mso-width-alt:2944;width:69pt'>\n <col width=126 style='mso-width-source:userset;mso-width-alt:4032;width:95pt'>\n <tr height=80 style='mso-height-source:userset;height:60.0pt'>\n <td colspan=11 height=80 class=xl33 width=1172 style='height:60.0pt;\n width:881pt'>采购物品申购计划单</td>\n </tr>\n <tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td colspan=4 height=40 class=xl34 style='height:30.0pt'>部门:" . work_db($id, '_12_18_dep') . "</td>\n <td colspan=4 class=xl34>供货商:" . work_db($id, '_12_18_company') . " </td>\n <td colspan=3 class=xl34>单号:" . work_db($id, '_12_18_111') . "</td>\n </tr>\n <tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td colspan=4 height=40 class=xl35 style='height:30.0pt'>项目名称:" . work_db($id, '_12_18_name') . "</td>\n <td colspan=4 class=xl35>合同编号:" . work_db($id, '_12_18_number') . "</td>\n <td colspan=3 class=xl35>工单号:" . work_db($id, '_12_18_zipcode') . "</td>\n </tr>\n <tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td height=40 class=xl36 style='height:30.0pt;border-top:none'>序号</td>\n <td class=xl36 style='border-top:none;border-left:none'>申购物品名称</td>\n <td class=xl36 style='border-top:none;border-left:none'>品牌</td>\n <td class=xl36 style='border-top:none;border-left:none'>规格</td>\n <td class=xl36 style='border-top:none;border-left:none'>型号</td>\n <td class=xl36 style='border-top:none;border-left:none'>颜色</td>\n <td class=xl36 style='border-top:none;border-left:none'>单位</td>\n <td class=xl36 style='border-top:none;border-left:none'>数量</td>\n <td class=xl36 style='border-top:none;border-left:none'>单价</td>\n <td class=xl36 style='border-top:none;border-left:none'>金额</td>\n <td class=xl36 style='border-top:none;border-left:none'>备注</td>\n </tr>";
$_12_18_wname = unserialize(work_db($id, '_12_18_wname'));
$_12_18_wping = unserialize(work_db($id, '_12_18_wping'));
$_12_18_wgg = unserialize(work_db($id, '_12_18_wgg'));
$_12_18_wxh = unserialize(work_db($id, '_12_18_wxh'));
$_12_18_wys = unserialize(work_db($id, '_12_18_wys'));
$_12_18_wdw = unserialize(work_db($id, '_12_18_wdw'));
$_12_18_wxl = unserialize(work_db($id, '_12_18_wxl'));
$_12_18_wdj = unserialize(work_db($id, '_12_18_wdj'));
$_12_18_wprice = unserialize(work_db($id, '_12_18_wprice'));
$_12_18_wnote = unserialize(work_db($id, '_12_18_wnote'));
for ($i = 0; $i < 15; $i++) {
$m = $i + 1;
$htmls .= "<tr height=33 style='mso-height-source:userset;height:24.95pt'>\n\t <td height=33 class=xl25 style='height:24.95pt;border-top:none' x:num>" . $m . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wname[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wping[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wgg[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wxh[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wys[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wdw[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wxl[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wdj[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wprice[$i] . "</td>\n\t <td class=xl26 style='border-top:none;border-left:none'>" . $_12_18_wnote[$i] . "</td>\n\t </tr>";
}
$htmls .= "<tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td colspan=2 height=40 class=xl25 style='height:30.0pt'>合计:</td>\n <td colspan=9 class=xl30 style='border-right:.5pt solid black;border-left:\n none'><span style='mso-spacerun:yes'> </span>¥<span\n style='mso-spacerun:yes'>" . work_db($id, '_12_18_hj') . " \n </span>大写:" . work_db($id, '_12_18_pidfdd') . "</td>\n </tr>\n <tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td colspan=11 height=40 class=xl28 style='height:30.0pt'>付款方式:" . work_db($id, '_12_18_type') . "</td>\n </tr>\n <tr height=80 style='mso-height-source:userset;height:60.0pt'>\n <td colspan=2 height=80 class=xl25 style='height:60.0pt'>备注:</td>\n <td colspan=9 class=xl29 style='border-left:none'>" . work_db($id, '_12_18_note') . "</td>\n </tr>\n <tr height=40 style='mso-height-source:userset;height:30.0pt'>\n <td colspan=2 height=40 class=xl27 style='height:30.0pt'>采购部经手人:" . get_realname($uid) . "</td>\n <td colspan=2 class=xl27>采购部负责人:" . w_p_v(12, $id, 'name') . "</td>\n <td colspan=4 class=xl27>财务部负责人:" . w_p_v(13, $id, 'name') . "</td>\n <td colspan=3 class=xl27>总经理审批:" . w_p_v(14, $id, 'name') . "</td>\n </tr>\n\n</table>\n\n</body>\n\n</html>";
return $htmls;
}
示例10: getGP
$wheresql .= " AND testdate ='" . $testdate . "'";
}
if ($testenddate = getGP('testenddate', 'P')) {
$wheresql .= " AND testenddate ='" . $testenddate . "'";
}
if ($signenddate = getGP('signenddate', 'P')) {
$wheresql .= " AND signenddate ='" . $signenddate . "'";
}
$vuidtype = getGP('vuidtype', 'P');
if ($vuidtype != '') {
if ($vuidtype == '-1') {
$wheresql .= get_subordinate($_USER->id, 'uid');
} else {
$wheresql .= " and uid='" . $vuidtype . "'";
}
}
$sql = "SELECT * FROM " . DB_TABLEPRE . "humancontract WHERE 1 {$wheresql} ORDER BY id desc";
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
$archive = array("" . get_realname($row['userid']) . "", "" . $row[number] . "", "" . get_typename($row["type"]) . "", "" . get_typename($row["ckey"]) . "", "" . str_replace("-", ".", $row['signdate']) . "", "" . str_replace("-", ".", $row['testdate']) . "", "" . $row[testday] . "", "" . str_replace("-", ".", $row['testenddate']) . "", "" . $row[signnum] . "", "" . str_replace("-", ".", $row['signenddate']) . "", "" . $row['content'] . "");
$content[] = $archive;
}
$excel = new ExcelWriter($outputFileName);
if ($excel == false) {
echo $excel->error;
}
foreach ($content as $v) {
$excel->writeLine($v);
}
$excel->sendfile($outputFileName);
}
示例11: exit
/*
*/
(!defined('IN_TOA') || !defined('IN_ADMIN')) && exit('Access Denied!');
empty($do) && ($do = 'list');
if ($do == 'list') {
if ($_GET['officeid'] != '') {
$sql = "SELECT * FROM " . DB_TABLEPRE . "fileoffice WHERE officeid='" . $_GET['officeid'] . "' and officetype='" . $_GET['officetype'] . "' and filetype='2' ORDER BY id desc";
} else {
$sql = "SELECT * FROM " . DB_TABLEPRE . "fileoffice WHERE number='" . $_GET['filenumber'] . "' and officetype='" . $_GET['officetype'] . "' and filetype='2' ORDER BY id desc";
}
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
///echo '<a href="down.php?urls='.$row['fileaddr'].'">'.$row['filename'].'</a> 上传人:'.get_realname($row['uid']).' 上传时间:'.$row['date'].'<br>';
echo '<a href=' . $row['fileaddr'] . ' target="_blank">' . $row['filename'] . '</a> 上传人:' . get_realname($row['uid']) . ' 上传时间:' . $row['date'] . '<br>';
}
} elseif ($do = 'office') {
if ($_GET['officeid'] != '') {
$sql = "SELECT * FROM " . DB_TABLEPRE . "fileoffice WHERE officeid='" . $_GET['officeid'] . "' and officetype='" . $_GET['officetype'] . "' and filetype='1' ORDER BY id desc";
} else {
$sql = "SELECT * FROM " . DB_TABLEPRE . "fileoffice WHERE number='" . $_GET['filenumber'] . "' and officetype='" . $_GET['officetype'] . "' and filetype='1' ORDER BY id desc";
}
$result = $db->query($sql);
while ($row = $db->fetch_array($result)) {
if ($_GET['viewtype'] == 5) {
echo '<a target="_blank" href="ntko/Fileview.php?FileId=' . $row['fileid'] . '&uid=' . $_USER->id . '&filenumber=' . $row['number'] . '&officetype=' . $row['officetype'] . '&date=' . $row['date'] . '">' . $row['filename'] . '</a> 上传人:' . get_realname($row['uid']) . ' 上传时间:' . $row['date'] . '<br>';
} else {
echo '<a target="_blank" href="ntko/FileEdit.php?FileId=' . $row['fileid'] . '&uid=' . $_USER->id . '&filenumber=' . $row['number'] . '&officetype=' . $row['officetype'] . '&date=' . $row['date'] . '">' . $row['filename'] . '</a> 上传人:' . get_realname($row['uid']) . ' 上传时间:' . $row['date'] . '<br>';
}
}
}
示例12: get_realname
?>
"><?php
echo $row['filename'];
?>
</a>
</td>
<td width="100"><?php
echo get_realname($row['appperson']);
?>
</td>
<td width="120"><?php
echo $row['appdate'];
?>
</td>
<td width="80" align="center"><?php
echo get_realname($row['examperson']);
?>
</td>
<td class="info"><?php
echo $row['examdate'];
?>
</td>
<td width="80" align="center"><?php
if ($row['type'] == '1') {
echo "待审";
} elseif ($row['type'] == '2') {
echo "未通过";
} elseif ($row['type'] == '3') {
echo "借阅中";
} elseif ($row['type'] == '4') {
echo "己归还";
示例13: get_realname
$flow = $db->fetch_one_array($sql);
if ($flow['flownum'] != '') {
echo '<b>第<span style="font-size:18px; font-weight:bold; color:#FF0000;">' . $flow['flownum'] . '</span>步:' . $flow['flowname'] . '</b><br>';
echo '审批人:' . $per['name'];
}
}
?>
</td>
<td align="center" class="TableData">
<?php
if ($row['type'] == 1) {
echo $mod['modname'] . '己撤消';
} else {
//审批
$sql = "SELECT * FROM " . DB_TABLEPRE . "project_personnel where name like '%" . get_realname($_USER->id) . "%' and (pertype=0 or pertype=4) and typeid='" . $row['typeid'] . "' and projectid='" . $row['lid'] . "' and appkey2=2 order by perid desc";
$per = $db->fetch_one_array($sql);
if ($per['perid'] != '') {
if ($per['appkey'] == 1 && $per['appkey1'] == 1) {
$perlnum = $db->result("SELECT COUNT(*) AS perlnum FROM " . DB_TABLEPRE . "project_personnel_log where perid='" . $per['perid'] . "' and uid='" . $_USER->id . "' and pertype=0 and appkey2=2");
if ($perlnum > 0) {
echo '<a href="admin.php?ac=' . $ac . '&do=personnel&fileurl=' . $fileurl . '&lid=' . $row['lid'] . '&modid=' . $modid . '&projectid=' . $projectid . '&typeid=' . $typeid . '">审批</a> | ';
}
} else {
echo '<a href="admin.php?ac=' . $ac . '&do=personnel&fileurl=' . $fileurl . '&lid=' . $row['lid'] . '&modid=' . $modid . '&projectid=' . $projectid . '&typeid=' . $typeid . '">审批</a> | ';
}
}
//撤消
if ($_GET['type'] == 3) {
if ($perkey != 5 && $perkey != 2) {
echo '<a href="admin.php?ac=' . $ac . '&do=workkey&fileurl=' . $fileurl . '&lid=' . $row['lid'] . '&modid=' . $modid . '&projectid=' . $projectid . '&typeid=' . $typeid . '">撤消</a> | ';
示例14: elseif
} elseif ($row['key1'] == '3') {
echo "拒绝";
} elseif ($row['key1'] == '4') {
echo "己入库";
}
?>
</td>
<td width="100"><?php
echo get_realname($row['uid']);
?>
</td>
<td class="title">
<?php
if ($row["key1"] == '1') {
global $db;
$key1 = $db->result("SELECT * FROM " . DB_TABLEPRE . "office_goods_key where examination like '%" . get_realname($_USER->id) . "%' ");
if ($key1["examination"] != '') {
echo '<a href="admin.php?ac=goods_purchase&do=keys&fileurl=goods&id=' . $row['id'] . '&key1=2">审批</a> ';
echo '| <a href="admin.php?ac=goods_purchase&do=keys&fileurl=goods&id=' . $row['id'] . '&key1=3">拒绝</a> | ';
}
}
?>
<a href="admin.php?ac=goods_purchase_views&do=list&fileurl=goods&id=<?php
echo $row['id'];
?>
">查看</a>
<?php
if ($_USER->id == $row['uid'] && $row['key1'] == '1') {
?>
示例15: print_name
function print_name($entry)
{
global $users;
if (substr($entry['name'], 0, 1) == "=") {
$uid = intval(str_replace('=', '', $entry['name']));
if ($users[$uid]['privacy'] >= 4 || is_logged_in() && $users[$uid]['privacy'] >= 3) {
$rv = "<a href=\"me.php?id={$uid}\" class=\"hidden\">" . get_realname($uid) . "</a>";
} else {
$rv = get_realname($uid);
}
$college = get_college($uid, $entry['year'], $entry['term']);
if ($college != '') {
$rv .= ' <span class="college">(' . $college . ')</span>';
}
} else {
$rv = $entry['name'];
if ($entry['college'] != '') {
$rv .= ' <span class="college">(' . $entry['college'] . ')</span>';
}
}
print $rv;
}