大佬,我有一组json 不会取值,前端表格问题,求思路
我有一组json是这样的
{
"cid": 29,
"name": "XXX",
"main_department": "财务部",
"department": "财务",
"job_number": 123,
"menus": [{
"did": 2,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "1日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 3,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "1日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 4,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "2日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 5,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "3日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 6,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "4日",
"rules_start": "08:00",
"rules_finish": "17:00",
"practical_start": "07:42",
"practical_finish": "17:01"
}, {
"did": 7,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "5日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 8,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "6日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 9,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "7日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 10,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "8日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 11,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "9日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 12,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "10日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 13,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "11日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 14,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "12日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 15,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "13日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 16,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "14日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 17,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "15日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 18,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "16日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 19,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "17日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 20,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "18日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 21,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "19日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 22,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "20日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 23,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "21日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 24,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "22日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 25,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "23日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 26,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "24日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 27,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "25日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 28,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "26日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 29,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "27日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 30,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "28日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 31,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "29日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 32,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "30日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 33,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "31日",
"rules_start": "08:00",
"rules_finish": "17:00"
}]
}
这是我的表格 我之前所有的表格都是用 bootstrap table1,但是 这种横竖多数据源,好像不支持啊,我只能手绘出来,如果有前端表格框架,求告知!
然后表格这里我 不知道怎么从 jsonObject 中的jsonArray 把值取出来 怎么点。。。。, 我要取 rules_start 我试过 [rules_start] 各种都取不出来,尴尬
$.ajax({
type: "POST",
url: "/GetMainTable",
data: null,
dataType: "json",
success: function(json){
console.log(json)
//判断非null非空
var list = json;
var tableHtml = ' <tr height="50">\n' +
' <!--一共12-->\n' +
' <td colspan="59">出勤表</td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td rowspan="2">序号</td>\n' +
' <td rowspan="2">部门</td>\n' +
' <td rowspan="2">岗位</td>\n' +
' <td rowspan="2">姓名</td>\n' +
' <td rowspan="2">入职时间</td>\n' +
' <td rowspan="2">离职时间</td>\n' +
' <td rowspan="2">进入排班时间</td>\n' +
' <td rowspan="2">月应出勤</td>\n' +
' <td colspan="2">月实际出勤</td>\n' +
' <td rowspan="2">带薪假</td>\n' +
' <td rowspan="2">平时加班(H)</td>\n' +
' <td rowspan="2">周末加班(H)</td>\n' +
' <td rowspan="2">法定加班(H)</td>\n' +
' <td rowspan="2">加班计调休</td>\n' +
' <td rowspan="2">总上报计调休时间</td>\n' +
' <td rowspan="2">调休多余时间转加班</td>\n' +
' <td colspan="2">事假</td>\n' +
' <td colspan="2">病假</td>\n' +
'\n' +
' <td colspan="2"> 迟到/早退</td>\n' +
' <td colspan="2">考勤漏打卡</td>\n' +
' <td>出差</td>\n' +
'\n' +
' <td rowspan="2">区分</td>\n' +
' <td rowspan="2">1日</td>\n' +
' <td rowspan="2">2日</td>\n' +
' <td rowspan="2">3日</td>\n' +
' <td rowspan="2">4日</td>\n' +
' <td rowspan="2">5日</td>\n' +
' <td rowspan="2">6日</td>\n' +
' <td rowspan="2">7日</td>\n' +
' <td rowspan="2">8日</td>\n' +
' <td rowspan="2">9日</td>\n' +
' <td rowspan="2">10日</td>\n' +
' <td rowspan="2">11日</td>\n' +
' <td rowspan="2">12日</td>\n' +
' <td rowspan="2">13日</td>\n' +
' <td rowspan="2">14日</td>\n' +
' <td rowspan="2">15日</td>\n' +
' <td rowspan="2">16日</td>\n' +
' <td rowspan="2">17日</td>\n' +
' <td rowspan="2">18日</td>\n' +
' <td rowspan="2">19日</td>\n' +
' <td rowspan="2">20日</td>\n' +
' <td rowspan="2">21日</td>\n' +
' <td rowspan="2">22日</td>\n' +
' <td rowspan="2">23日</td>\n' +
' <td rowspan="2">24日</td>\n' +
' <td rowspan="2">25日</td>\n' +
' <td rowspan="2">26日</td>\n' +
' <td rowspan="2">27日</td>\n' +
' <td rowspan="2">28日</td>\n' +
' <td rowspan="2">29日</td>\n' +
' <td rowspan="2">30日</td>\n' +
' <td rowspan="2">31日</td>\n' +
' <!--<td colspan="31">星期</td>-->\n' +
'\n' +
' </tr>\n' +
' <tr>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>天数</td>\n' +
'\n' +
' <!--<td colspan="31">月份</td>-->\n' +
' </tr>';
for(var i = 0; i < list.length; i ++){
//新加
for(var j=0;j<list[i].menus.length;j++){
// html+='<td>'+list[i].menus[j].rules_start +'</td>\n'
tableHtml += ' <tr>\n' +
' <!--序号-->\n' +
' <td rowspan="15">'+(i+1)+'</td>\n' +
' <!--部门-->\n' +
' <td rowspan="15" id="main_department">'+ list[i].main_department +'</td>\n' +
' <!---岗位-->\n' +
' <td rowspan="15">'+list[i].gangwei+'</td>\n' +
' <!--姓名-->\n' +
' <td rowspan="15">'+list[i].name+'</td>\n' +
' <!--入职时间-->\n' +
' <td rowspan="15">'+list[i].hiredate+'</td>\n' +
' <!--离职时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--进入排班时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--月应出勤-->\n' +
' <td rowspan="15">月应出勤</td>\n' +
' <!--月实际出勤-->\n' +
' <td rowspan="15"></td>\n' +
' <td rowspan="15">2</td>\n' +
' <!--带薪假-->\n' +
' <td rowspan="15" >0</td>\n' +
' <!--平时加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--周末加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--法定加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--加班计调休-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--总上报计调休时间-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--调休多余时间转加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--事假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--病假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--迟到/早退-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--考勤漏打卡-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--出差-->\n' +
' <td rowspan="15">0</td>\n' +
'\n' +
' <!--区分-->\n' +
'\n' +
' <td>排班打卡时间(上班)</td>\n' +
'\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' <td >'+list[i].menus[j].rules_start+'</td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>排班打卡时间(下班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际打卡时间(上班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际打卡时间(下班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际出勤(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>平时加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>周末加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>法定加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>加班计调休(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>迟到/早退(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>漏打卡(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>出差(天)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
'\n' +
' <tr>\n' +
' <td>事假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>病假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>带薪假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>';
}
}
$("#testTable").html(tableHtml); //输出
//最后tableHtml就是拼好的 table html,
}
});
大佬们,应该用什么表格框架才能支持这种形式,或者手绘表格怎么做才能做出来,求思路。。一直卡在这里不是办法- -
这里应该是两层for循环吧,先取list[i],再从list里面读menu[j]
var html='';
alert(list);
if(list!=null){
for(var i=0;i<list.length;i++){
alert(list[i].menu)
if(list[i].menu!=null){
for(var j=0;j<list[i].menu.length;j++){
html+='<td>'+list[i].menus[j].rules_start +'</td>\n' ;
}
}
}
}
alert(html);
$.ajax({
type: "POST",
url: "/GetMainTable",
data: null,
dataType: "json",
success: function(json){
console.log(json)
//判断非null非空
var list = json;
var tableHtml = ' <tr height="50">\n' +
' <!--一共12-->\n' +
' <td colspan="59">出勤表</td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td rowspan="2">序号</td>\n' +
' <td rowspan="2">部门</td>\n' +
' <td rowspan="2">岗位</td>\n' +
' <td rowspan="2">姓名</td>\n' +
' <td rowspan="2">入职时间</td>\n' +
' <td rowspan="2">离职时间</td>\n' +
' <td rowspan="2">进入排班时间</td>\n' +
' <td rowspan="2">月应出勤</td>\n' +
' <td colspan="2">月实际出勤</td>\n' +
' <td rowspan="2">带薪假</td>\n' +
' <td rowspan="2">平时加班(H)</td>\n' +
' <td rowspan="2">周末加班(H)</td>\n' +
' <td rowspan="2">法定加班(H)</td>\n' +
' <td rowspan="2">加班计调休</td>\n' +
' <td rowspan="2">总上报计调休时间</td>\n' +
' <td rowspan="2">调休多余时间转加班</td>\n' +
' <td colspan="2">事假</td>\n' +
' <td colspan="2">病假</td>\n' +
'\n' +
' <td colspan="2"> 迟到/早退</td>\n' +
' <td colspan="2">考勤漏打卡</td>\n' +
' <td>出差</td>\n' +
'\n' +
' <td rowspan="2">区分</td>\n' +
' <td rowspan="2">1日</td>\n' +
' <td rowspan="2">2日</td>\n' +
' <td rowspan="2">3日</td>\n' +
' <td rowspan="2">4日</td>\n' +
' <td rowspan="2">5日</td>\n' +
' <td rowspan="2">6日</td>\n' +
' <td rowspan="2">7日</td>\n' +
' <td rowspan="2">8日</td>\n' +
' <td rowspan="2">9日</td>\n' +
' <td rowspan="2">10日</td>\n' +
' <td rowspan="2">11日</td>\n' +
' <td rowspan="2">12日</td>\n' +
' <td rowspan="2">13日</td>\n' +
' <td rowspan="2">14日</td>\n' +
' <td rowspan="2">15日</td>\n' +
' <td rowspan="2">16日</td>\n' +
' <td rowspan="2">17日</td>\n' +
' <td rowspan="2">18日</td>\n' +
' <td rowspan="2">19日</td>\n' +
' <td rowspan="2">20日</td>\n' +
' <td rowspan="2">21日</td>\n' +
' <td rowspan="2">22日</td>\n' +
' <td rowspan="2">23日</td>\n' +
' <td rowspan="2">24日</td>\n' +
' <td rowspan="2">25日</td>\n' +
' <td rowspan="2">26日</td>\n' +
' <td rowspan="2">27日</td>\n' +
' <td rowspan="2">28日</td>\n' +
' <td rowspan="2">29日</td>\n' +
' <td rowspan="2">30日</td>\n' +
' <td rowspan="2">31日</td>\n' +
' <!--<td colspan="31">星期</td>-->\n' +
'\n' +
' </tr>\n' +
' <tr>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>天数</td>\n' +
'\n' +
' <!--<td colspan="31">月份</td>-->\n' +
' </tr>';
for(var i = 0; i < list.length; i ++){
tableHtml += ' <tr>\n' +
' <!--序号-->\n' +
' <td rowspan="15">'+(i+1)+'</td>\n' +
' <!--部门-->\n' +
' <td rowspan="15" id="main_department">'+ list[i].main_department +'</td>\n' +
' <!---岗位-->\n' +
' <td rowspan="15">'+list[i].gangwei+'</td>\n' +
' <!--姓名-->\n' +
' <td rowspan="15">'+list[i].name+'</td>\n' +
' <!--入职时间-->\n' +
' <td rowspan="15">'+list[i].hiredate+'</td>\n' +
' <!--离职时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--进入排班时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--月应出勤-->\n' +
' <td rowspan="15">月应出勤</td>\n' +
' <!--月实际出勤-->\n' +
' <td rowspan="15"></td>\n' +
' <td rowspan="15">2</td>\n' +
' <!--带薪假-->\n' +
' <td rowspan="15" >0</td>\n' +
' <!--平时加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--周末加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--法定加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--加班计调休-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--总上报计调休时间-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--调休多余时间转加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--事假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--病假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--迟到/早退-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--考勤漏打卡-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--出差-->\n' +
' <td rowspan="15">0</td>\n' +
'\n' +
' <!--区分-->\n' +
'\n' +
' <td>排班打卡时间(上班)</td>\n' ;
tableHtml+= '\n' ;
if(list[i].menu!=null){
for(var j=0;j<list[i].menu.length;j++){
tableHtml+='<td>'+list[i].menus[j].rules_start +'</td>\n' ;
}
}
tableHtml+=' </tr>\n' +
' <tr>\n' +
' <td>排班打卡时间(下班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际打卡时间(上班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际打卡时间(下班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际出勤(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>平时加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>周末加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>法定加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>加班计调休(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>迟到/早退(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>漏打卡(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>出差(天)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
'\n' +
' <tr>\n' +
' <td>事假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>病假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>带薪假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>';
}
$("#testTable").html(tableHtml); //输出
//最后tableHtml就是拼好的 table html,
}
});
lenth+index
假设var data = jsonObject,定义data变量接受json
至于生成html
可以定义一个var mmHtml = "";
var menus = data.menus;
for(var i = 0 ;i < menus.length;i++){
alert(menus[i].did);
alert(menus[i].job_number);
alert(menus[i].yearmonth);
alert(menus[i].day);
alert(menus[i].rules_start);
alert(menus[i].rules_finish);
mmHtml += "
mmHtml += ""+menus[i].rules_start+"";
.
.
.
mmHtml += "";
}
for(var i=0;i<jsonarray.menus.length;i++){
alert(jsonarray.menus[i].did);
}
实测能拿到值
可以for循环拼接html啊
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>select.suggest</title>
<!-- Bootstrap -->
<script type="text/javascript" src="js/jquery-1.10.2.js"></script>
</head>
<body>
<script>
$(function () {
var json = [{
"cid": 29,
"name": "XXX",
"main_department": "财务部",
"department": "财务",
"job_number": 123,
"menus": [{
"did": 2,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "1日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 3,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "1日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 4,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "2日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 5,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "3日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 6,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "4日",
"rules_start": "08:00",
"rules_finish": "17:00",
"practical_start": "07:42",
"practical_finish": "17:01"
}, {
"did": 7,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "5日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 8,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "6日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 9,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "7日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 10,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "8日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 11,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "9日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 12,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "10日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 13,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "11日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 14,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "12日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 15,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "13日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 16,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "14日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 17,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "15日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 18,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "16日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 19,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "17日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 20,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "18日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 21,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "19日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 22,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "20日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 23,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "21日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 24,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "22日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 25,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "23日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 26,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "24日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 27,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "25日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 28,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "26日",
"rules_start": "休",
"rules_finish": "休"
}, {
"did": 29,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "27日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 30,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "28日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 31,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "29日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 32,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "30日",
"rules_start": "08:00",
"rules_finish": "17:00"
}, {
"did": 33,
"job_number": 10005,
"yearmonth": "2019.5",
"day": "31日",
"rules_start": "08:00",
"rules_finish": "17:00"
}]
}];
var list = json;
var tableHtml = ' <tr height="50">\n' +
' <!--一共12-->\n' +
' <td colspan="59">出勤表</td>\n';
for (var i = 0; i < list.length; i++) {
var menu = list[i].menus;
var tr1 = "<tr>\n";
var td1 = ' <td rowspan="2">序号</td>\n' +
' <td rowspan="2">部门</td>\n' +
' <td rowspan="2">岗位</td>\n' +
' <td rowspan="2">姓名</td>\n' +
' <td rowspan="2">入职时间</td>\n' +
' <td rowspan="2">离职时间</td>\n' +
' <td rowspan="2">进入排班时间</td>\n' +
' <td rowspan="2">月应出勤</td>\n' +
' <td colspan="2">月实际出勤</td>\n' +
' <td rowspan="2">带薪假</td>\n' +
' <td rowspan="2">平时加班(H)</td>\n' +
' <td rowspan="2">周末加班(H)</td>\n' +
' <td rowspan="2">法定加班(H)</td>\n' +
' <td rowspan="2">加班计调休</td>\n' +
' <td rowspan="2">总上报计调休时间</td>\n' +
' <td rowspan="2">调休多余时间转加班</td>\n' +
' <td colspan="2">事假</td>\n' +
' <td colspan="2">病假</td>\n' +
'\n' +
' <td colspan="2"> 迟到/早退</td>\n' +
' <td colspan="2">考勤漏打卡</td>\n' +
' <td>出差</td>\n' + '\n';
td1 += '<td td rowspan="2">区分</td>';
var td3 = ' <td rowspan="15">' + (i + 1) + '</td>\n' +
' <!--部门-->\n' +
' <td rowspan="15" id="main_department">' + list[i].main_department + '</td>\n' +
' <!---岗位-->\n' +
' <td rowspan="15">' + list[i].gangwei + '</td>\n' +
' <!--姓名-->\n' +
' <td rowspan="15">' + list[i].name + '</td>\n' +
' <!--入职时间-->\n' +
' <td rowspan="15">' + list[i].hiredate + '</td>\n' +
' <!--离职时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--进入排班时间-->\n' +
' <td rowspan="15"></td>\n' +
' <!--月应出勤-->\n' +
' <td rowspan="15">月应出勤</td>\n' +
' <!--月实际出勤-->\n' +
' <td rowspan="15"></td>\n' +
' <td rowspan="15">2</td>\n' +
' <!--带薪假-->\n' +
' <td rowspan="15" >0</td>\n' +
' <!--平时加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--周末加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--法定加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--加班计调休-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--总上报计调休时间-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--调休多余时间转加班-->\n' +
' <td rowspan="15">0</td>\n' +
' <!--事假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--病假-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">0</td>\n' +
' <!--迟到/早退-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--考勤漏打卡-->\n' +
' <td rowspan="15">0</td>\n' +
' <td rowspan="15">无</td>\n' +
' <!--出差-->\n' +
' <td rowspan="15">0</td>\n';
td3 += ' <td>排班打卡时间(上班)</td>\n';
var td4 = ' <td>排班打卡时间(下班)</td>\n';
for (var i = 0; i < menu.length; i++) {
td1 += '<td td rowspan="2">' + menu[i].day + '</td> ';
td3 += '<td >' + menu[i].rules_start + '</td>\n'
td4 += '<td>' + menu[i].rules_finish + '</td>\n';
}
tr1 += td1;
tr1 += "</tr>"
var tr2 = ' <tr>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>小时</td>\n' +
' <td>天.班</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>次/月</td>\n' +
' <td>扣款</td>\n' +
' <td>天数</td>\n' +
'\n' +
' <!--<td colspan="31">月份</td>-->\n' +
' </tr>';
var tr3 = ' <tr>\n';
tr3 += td3;
tr3 += ' </tr>\n';
var tr4 = ' <tr>\n';
tr4 += td4;
tr4 += ' </tr>\n';
var otherTr = ' <tr>\n' +
' <td>实际打卡时间(上班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际打卡时间(下班)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>实际出勤(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>平时加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>周末加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>法定加班(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>加班计调休(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>迟到/早退(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>漏打卡(次)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>出差(天)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
'\n' +
' <tr>\n' +
' <td>事假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>病假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>\n' +
' <tr>\n' +
' <td>带薪假(H)</td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' <td></td>\n' +
' </tr>';
tableHtml += tr1;
tableHtml += tr2;
tableHtml += tr3;
tableHtml += tr4;
tableHtml += otherTr;
}
$("#tb").html(tableHtml);
})
</script>
<div>
<table id="tb" border="1"></table>
</div>
</body>
</html>
```