<td class="TableContent" width="150">培训名称:</td> <td class="TableData"><?php echo $blog['name']; ?> </td> </tr> <tr> <td nowrap class="TableContent" width="150">培训类型:</td> <td class="TableData"><?php echo get_typename($blog["channel"]); ?> </td> <td class="TableContent" width="150">培训形式:</td> <td class="TableData"><?php echo get_typename($blog["trform"]); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="150">主办部门:</td> <td class="TableData"><div style="width:400px;"><?php echo $blog['sponsor']; ?> </div></td> <td class="TableContent" width="150">负责人:</td> <td class="TableData"><?php echo $blog['responsible']; ?> </td> </tr>
?> </td> </tr> <tr> <td nowrap class="TableContent"> 应聘岗位:</td> <td class="TableData"><?php echo get_postname($blog['job']); ?> </td> </tr> <tr> <td nowrap class="TableContent"> 学历:</td> <td class="TableData"><?php echo get_typename($blog["education"]); ?> </td> </tr> <tr> <td nowrap class="TableContent"> 附件简历:</td> <td class="TableData"> <a href="down.php?urls=<?php echo $blog['appendix']; ?> " target="_blank" >附件下载</a> </td> </tr> <tr> <td nowrap class="TableContent"> 简历:</td> <td class="TableData"><?php
$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); }
$wheresql .= " AND responsible LIKE '%" . get_realname($_USER->id) . "%'"; } if ($_POST['type'] == '2') { $wheresql .= " AND user LIKE '%" . get_realname($_USER->id) . "%'"; } if ($_POST['type'] == '3') { $wheresql .= " AND type='1'"; } $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 . "training WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . $row[number] . "", "" . $row[name] . "", "" . get_typename($row["channel"]) . "", "" . get_typename($row["trform"]) . "", "" . $row[sponsor] . "", "" . $row[responsible] . "", "" . $row[participation] . "", "" . $row[address] . "", "" . $row[organization] . "", "" . $row[orgperson] . "", "" . $row[curriculum] . "", "" . $row[classhour] . "", "" . str_replace("-", ".", $row[startdate]) . "", "" . str_replace("-", ".", $row[enddate]) . "", "" . $row[price] . "", "" . $row[examination] . "", "" . $row[department] . "", "" . $row[user] . "", "" . $row[organizationinfo] . "", "" . $row[contactperson] . "", "" . $row[request] . "", "" . $row['content'] . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
<?php echo $record['date']; ?> </td> </tr> <tr> <td nowrap class="TableContent"> 具体出席参会人员:</td> <td class="TableData"><?php echo $record['attendance']; ?> </td> </tr> <tr> <td nowrap class="TableContent"> 所在会议室:</td> <td class="TableData"><?php echo get_typename($record['conferenceroom']); ?> </td> </tr> <tr> <td nowrap class="TableContent"> 会议总结人:</td> <td class="TableData"><?php echo get_realname($record['recordperson']); ?> </td> </tr> <tr> <td nowrap class="TableContent"> 附件:</td> <td class="TableData"> <?php
?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 计划名称:</td> <td class="TableData"> <?php echo $blog['jobpost']; ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 招聘渠道:</td> <td class="TableData"> <?php echo get_typename($blog["channel"]); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 招聘费用:</td> <td class="TableData"> <?php echo $blog['price']; ?> RMB</td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 开始日期:</td> <td class="TableData">
echo $fileurl; ?> &do=views&id=<?php echo $row['id']; ?> "><?php echo $row['name']; ?> </a> </td> <td><?php echo get_typename($row["channel"]); ?> </td> <td><?php echo get_typename($row["trform"]); ?> </td> <td align="center"><?php echo $row['responsible']; ?> </td> <td><?php echo $row['price']; ?> </td> <td align="center"><?php if ($row['type'] == '1') { echo "<font color=#006600>待审</font>"; } elseif ($row['type'] == '2') { echo "<font color=red>己批</font>";
$startdate = explode(' ', $row['startdate']); $enddate = explode(' ', $row['enddate']); ?> <?php echo $date[0] . "<br>" . $date[1]; ?> </td> <td class="info"><?php echo $startdate[0] . "<br>" . $startdate[1] . "至" . $enddate[1]; ?> </td> <td class="info"><?php if ($row['conferenceroom'] != '') { ?> <?php echo get_typename($row['conferenceroom']); ?> <?php } ?> </td> <td class="info"><?php if ($row['type'] == '1') { echo "<font color=#003300>待批</font>"; } if ($row['type'] == '2') { echo "<font color=red>己批</font>"; } if ($row['type'] == '3') { echo "<font color=#cccccc>拒绝</font>"; }
$wheresql .= " AND job='" . $job . "'"; } if ($education = getGP('education', 'P')) { $wheresql .= " AND education='" . $education . "'"; } $vuidtype = getGP('vuidtype', 'P'); if (!is_superadmin() && $vuidtype == '') { $wheresql .= " AND uid = {$_USER->id}"; } if ($vuidtype != '') { if ($vuidtype == '-1') { $wheresql .= get_subordinate($_USER->id, 'uid'); } else { $wheresql .= " and uid='" . $vuidtype . "'"; } } $sql = "SELECT * FROM " . DB_TABLEPRE . "job_talent WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . $row[number] . "", "" . get_job_name($row[jobpost]) . "", "" . $row[name] . "", "" . $row[sex] . "", "" . $row[contact] . "", "" . get_postname($row[job]) . "", "" . get_typename($row[education]) . "", "" . $row[appendix] . "", "" . $row[content] . "", "" . get_realname($row['uid']) . "", "" . str_replace("-", ".", $row[date]) . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
</td> <td class="info"><?php echo $row['number']; ?> </td> <td class="title"> <a href="admin.php?ac=views&fileurl=jobs&do=edit&id=<?php echo $row['id']; ?> "><?php echo $row['jobpost']; ?> </a> </td> <td width="100"><?php echo get_typename($row["channel"]); ?> </td> <td width="80"><?php echo $row['jobnum']; ?> 人</td> <td width="80"><?php echo $row['startdate']; ?> </td> <td width="80"><?php echo $row['enddate']; ?> </td> <td width="60"><?php
$vstartdate = getGP('vstartdate', 'P'); $venddate = getGP('venddate', 'P'); if ($vstartdate != '' && $venddate != '') { $wheresql .= " AND (startdate>='" . $vstartdate . "' and enddate<='" . $venddate . "')"; } $vuidtype = getGP('vuidtype', 'P'); if (!is_superadmin() && $vuidtype == '') { $wheresql .= " AND uid = {$_USER->id}"; } if ($vuidtype != '') { if ($vuidtype == '-1') { $wheresql .= get_subordinate($_USER->id, 'uid'); } else { $wheresql .= " and uid='" . $vuidtype . "'"; } } $sql = "SELECT * FROM " . DB_TABLEPRE . "job WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array("" . $row[number] . "", "" . $row[jobpost] . "", "" . get_typename($row[channel]) . "", "" . $row[price] . "", "" . str_replace("-", ".", $row[startdate]) . "", "" . str_replace("-", ".", $row[enddate]) . "", "" . $row[jobnum] . "人", "" . $row[examination] . "", "" . str_replace("-", ".", $row[examinationdate]) . "", "" . $row[appendix] . "", "" . $row[content] . "", "" . get_realname($row['uid']) . "", "" . str_replace("-", ".", $row[date]) . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
?> "><?php echo $row['number']; ?> </a> </td> <td class="info"><?php echo get_realname($row['userid']); ?> </td> <td class="info"><?php echo get_typename($row["type"]); ?> </td> <td class="info"><?php echo get_typename($row["ckey"]); ?> </td> <td class="info"><?php echo $row['signdate']; ?> </td> <td class="info"><?php echo $row['signenddate']; ?> </td> <td class="info"><?php echo $row['signnum']; ?> </td> <td class="info"><?php
class="split" <?php } ?> > <td class="checkbox"> <?php echo get_boxlistkey("id[]", $row['id'], $row['uid'], $_USER->id); ?> </td> <td class="title"> <?php echo $row['user']; ?> </td> <td class="info"><?php echo get_typename($row["project"]); ?> </td> <td class="info"><?php echo $row['rewardsdate']; ?> </td> <td width="60"><?php echo $row['wagesmonth']; ?> </td> <td width="60"><?php if ($row['rewardskey'] == '1') { echo "<font color=#006600>奖励</font>"; } else { echo "惩罚";
} if ($vuidtype != '') { if ($vuidtype == '-1') { $wheresql .= get_subordinate($_USER->id, 'uid'); } else { $wheresql .= " and uid='" . $vuidtype . "'"; } } $sql = "SELECT * FROM " . DB_TABLEPRE . "conference WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $record = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "conference_record WHERE conferenceid='" . $row[id] . "'"); if ($row[type] == '1') { $type = '待批'; } elseif ($row[type] == '2') { $type = '己批'; } else { $type = '拒绝'; } $archive = array("" . $type . "", "" . $row[title] . "", "" . $row[subject] . "", "" . str_replace("-", ".", $row[startdate]) . "", "" . str_replace("-", ".", $row[enddate]) . "", "" . get_realname($row['appperson']) . "", "" . get_realname($row['recorduser']) . "", "" . $row[attendance] . "", "" . get_realname($row['staffid']) . "", "" . get_typename($row['conferenceroom']) . "", "" . get_typename($row['otype']) . "", "" . $row['content'] . "", "" . $record['content'] . ""); $content[] = $archive; } $excel = new ExcelWriter($outputFileName); if ($excel == false) { echo $excel->error; } foreach ($content as $v) { $excel->writeLine($v); } $excel->sendfile($outputFileName); }
<?php echo $blog['number']; ?> </td> </tr> <tr> <td nowrap class="TableContent" width="130"> 合同类型:</td> <td class="TableData"><?php echo get_typename($blog["type"]); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="130"> 合同状态:</td> <td class="TableData"><?php echo get_typename($blog["ckey"]); ?> </td> </tr> <tr> <td nowrap class="TableContent" width="130"> 合同签订日期:</td> <td class="TableData"> <?php echo $blog['signdate']; ?> </td> </tr> <tr> <td nowrap class="TableContent" width="130"> 试用生效日期:</td> <td class="TableData"> <?php