} $str_tmanager = "select ti.TrainingId,ti.TrainingName,ti.SpeakerName,ti.TrainingBegin,ti.TrainingEnd,ti.StartDate,ti.EndDate,\n ti.TrainingLocation,ti.TrainingMemo,ti.TrainingManager,ti.Status,ti.ApproreLevel from trainings ti \n where ti.status = 1 and TIMESTAMPDIFF(DAY,date(ti.StartDate),now()) >= 0 \n and TIMESTAMPDIFF(DAY,date(ti.EndDate),now()) <= 0 \n and ti.TrainingManager like '%,{$userid},%' order by ti.TrainingId"; if ($rs = mysqli_query($link, $str_tmanager)) { $tmanagercount = mysqli_num_rows($rs); while ($row = mysqli_fetch_assoc($rs)) { $sm = new StuTrainings(); $sm->Id = $row['TrainingId']; $sm->Name = $row['TrainingName']; $sm->SpeakerName = $row['SpeakerName']; $sm->Begin = date("Y/m/d", strtotime($row['TrainingBegin'])); $sm->End = date("Y/m/d", strtotime($row['TrainingEnd'])); $sm->StartDate = date("Y/m/d", strtotime($row['StartDate'])); $sm->EndDate = date("Y/m/d", strtotime($row['EndDate'])); $sm->Location = $row['TrainingLocation']; $sm->Memo = $row['TrainingMemo']; $sm->Manager = get_employ_id_from_usernames($row['TrainingManager']); $sm->ApproreLevel = $row['ApproreLevel']; $sm->Status = $row['Status']; array_push($dataTManagers, $sm); } } else { if ($link) { mysqli_close($link); } sleep(DELAY_SEC); echo json_encode(array("status" => 0, "count" => $trainingcount, "tmanagerdata" => $dataTManagers, "result" => "课程信息获取失败!")); return; } mysqli_close($link); echo json_encode(array("status" => 1, "count" => $trainingcount, "trainingsdata" => $dataTrainings, "tmanagerdata" => $dataTManagers, "result" => "")); return;
} $return_string = $return_string . ">" . "<table id=\"search_table\" class=\"report\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" . "<colgroup>" . "<col class=\"num\"/>" . "<col class=\"TrainingName\" />" . "<col class=\"SpeakerName\" />" . "<col class=\"TrainingManager\" />" . "<col class=\"Status\" />" . "<col class=\"TrainingDate\" />" . "<col class=\"Date\" />" . "<col class=\"TrainingAction\"/>" . "</colgroup>" . "<tr>" . "<th>编号</th>" . "<th>课程名称</th>" . "<th>讲师名称</th>" . "<th>课程负责人</th>" . "<th>课程状态</th>" . "<th>课程时间</th>" . "<th>报名时间</th>" . "<th>动作</th>" . "</tr>"; } if ($page_count < $page_size) { $row = mysqli_fetch_assoc($result); $TrainingId = $row["TrainingId"]; $TrainingName = $row["TrainingName"]; $SpeakerName = $row["SpeakerName"]; $TrainingManager = $row["TrainingManager"]; $Status = $row["Status"]; $StatusStr = $row["Status"] == 0 ? "下架" : "上架"; $StatusAction = $row["Status"] == 1 ? "下架" : "上架"; $TrainingDate = substr($row["TrainingBegin"], 0, 10) . "~" . substr($row["TrainingEnd"], 0, 10); $EnrollDate = substr($row["StartDate"], 0, 10) . "~" . substr($row["EndDate"], 0, 10); $page_count_display = $page_count + 1; $return_string = $return_string . "<tr>" . "<td>{$page_count_display}</td>" . "<td><span class=\"TrainingName fixWidth\">{$TrainingName}</span></td>" . "<td><span class=\"SpeakerName fixWidth\">{$SpeakerName}</span></td>" . "<td>" . get_employ_id_from_usernames($TrainingManager) . "</td>" . "<td>{$StatusStr}</td>" . "<td>{$TrainingDate}</td>" . "<td>{$EnrollDate}</td>" . "<td><A OnClick=\"actionSearchTrainings({$TrainingId},{$Status});\">{$StatusAction}</A><br/>" . "<A OnClick=\"modifySearchTrainings({$TrainingId});\">修改</A><br/>" . "<A OnClick=\"deleteSearchTrainings({$TrainingId});\">删除</A><br/>" . "<A OnClick=\"uploadUserTrainings({$TrainingId});\">上传课程人员名单</A><br/>" . "<A OnClick=\"uploadUserTrainingManagers({$TrainingId});\">上传课程负责人员名单</A></td>" . "</tr>"; $i++; $page_count++; if ($page_count == $page_size) { $return_string = $return_string . "</table>" . "</div>\n"; $page_no++; $page_count = 0; } } } if ($page_count > 0) { $return_string = $return_string . "</table>" . "</div>\n"; } } //***Step8 Field name and field number must be modified. end $return_string = $return_string . "<div class=\"toolMenu\">" . "<span align=right class=\"btn\" OnClick=\"TrainingsearchTrainingsContentFunc();\">新增</span> " . "<span class=\"btn TrainingsexpandSR\" OnClick=\"expandSearchTrainingsContentFunc();\">显示过长内容</span>" . "<span class=\"paging\">";
$EmployeeId = $row["EmployeeId"]; $TraineeDate = substr($row["TrainingBegin"], 0, 10) . " ~ " . substr($row["TrainingEnd"], 0, 10); $RegisterDate = date("Y-m-d H:i:s", strtotime($row["RegisterDate"])); $ExamineUser = $row["ExamineUser"]; $Status = $row["Status"]; $ApproreLevel = $row["ApproreLevel"]; $strStatus = ""; if ($ApproreLevel == $Status) { $strStatus = "通过审核"; } elseif ($ApproreLevel > $Status && $Status != -1) { $strStatus = "审核中..."; } elseif ($Status == -1) { $strStatus = "审核驳回"; } $page_count_display = $page_count + 1; $return_string = $return_string . "<tr>" . "<td>{$page_count_display}</td>" . "<td><span class=\"TraineeName\">{$TrainingName}</span></td>" . "<td><span class=\"SpeakerName\">{$SpeakerName}</span></td>" . "<td>{$UserName}</td>" . "<td>{$EmployeeId}</td>" . "<td><span class=\"ExamineUser\">{$TraineeDate}</span></td>" . "<td>{$RegisterDate}</td>" . "<td><span class=\"ExamineUser\">" . get_employ_id_from_usernames($ExamineUser) . "</span></td>" . "<td>{$strStatus}</td>" . "<td><A OnClick=\"actionSearchTrainee({$TrainingId},{$ApproreLevel},{$UserId});\">审核 同意</A><br/>" . "<A OnClick=\"deleteSearchTrainee({$TrainingId},{$UserId});\">审核 驳回</A></td>" . "</tr>"; $i++; $page_count++; if ($page_count == $page_size) { $return_string = $return_string . "</table>" . "</div>\n"; $page_no++; $page_count = 0; } } } if ($page_count > 0) { $return_string = $return_string . "</table>" . "</div>\n"; } } //***Step8 Field name and field number must be modified. end $return_string = $return_string . "<div class=\"toolMenu\">" . "<span class=\"btn TraineesexpandSR\" OnClick=\"expandSearchTraineesContentFunc();\">显示过长内容</span>" . "<span class=\"paging\">";