}
$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\">";
