<tbody> <?php $count=0 ;$countParent=0 ; if(isset($monitorList)){ foreach($monitorList as $key=>$val){ ?> <tr class="treegrid-<?=$key+1+$count?>" style="cursor: pointer;"> <td><?=$val['id']?></td> <td title=<?=$val['name']?> onclick="task(<?=$val['id']?>,'<?=$val['name']?>')"><?=Util::msubstr($val['name'],0,16,'gbk')?></td> <td><?if(!empty($val[$key])){echo count($val[$key]);}else{echo $val['product_qty'];}?></td> <td><?=date("Y-m-d ",strtotime($val['date_start']))?></td> <td><?=$val['plan_director_name']?></td> <td style="padding: 0px;"> <span><?switch($val['status']){case 1: echo '10%';break;case 9: echo '100%';default: echo ((intval($val['status'])-1)*20).'%';}?></span> <div id="progressouter" style=" border:2px solid red; height:10px; width: 64px;display:block"><div id="progressinner" style="position: relative; width:<?switch($val['status']){case 1: echo '10';break;case 9: echo '100';default: echo ((intval($val['status'])-1)*20);}?>%; height:6px; background:#23bd00;"></div></div> </td> <td> <a style="cursor: pointer;" onclick="window.location.href='/opt_monitoring/show.candor?plan_type=<?=$val['plan_type']?>&workcenter_id=<?=$val['workcenter_id']?>&plan_id=<?=$val['id']?>'" id="show"> 查看</a> </td> </tr> <?php $countParent=$key+1+$count;$child=0; if(is_array($val[$key]))foreach($val[$key] as $v){ //这里只执行了一次 if($val['id']==$v['parent_id']){ $count=$count+1;$child=$child+1; ?> <tr class="treegrid-<?echo $countParent+$child?> treegrid-parent-<?=$countParent?>"> <td><?=$v['id']?></td> <td><?=Util::msubstr($val['name'],0,16,'gbk')?></td> <td><?=1?></td> <td><?=date("Y-m-d ",strtotime($v['date_start']))?></td> <td><?=$val['plan_director_name']?></td> <td style="padding: 0px;"> <span><?if($v['status']=='1'){echo '10%';}else if($v['status']=='9'){echo '100%';}else{ echo ((intval($v['status'])-1)*20).'%';}?></span> <div id="progressouter" style=" border:2px solid red; height:10px; width: 64px;display:block"> <div id="progressinner" style="position: relative; width:<?if($v['status']=='1'){echo '10';}else if($v['status']=='9'){echo '100';}else{ echo ((intval($v['status'])-1)*20);}?>%; height:6px; background:#23bd00;"></div></div> </td> <td><?=$v['status']?></td> </tr> <?} } }}?> </tbody>
三维数组需要三个foreach嵌套遍历才可以。
但是我第一个父节点下的子节点能遍历出来啊
不是特别清楚你的数据结构,检查一下这个条件有没有满足
if(is_array($val[$key]))
你的外层循环是
foreach($monitorList as $key=>$val)
进入内层循环的条件是
if(is_array($val[$key]))
不符合条件时,自然就没有输出
你至少应
var_export($monitorList);
贴出结果看看
0 => array ( 'id' => '6166', 'create_uid' => '1000', 'create_date' => '2015-01-30 09:48:10.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 09:48:10.000', 'name' => 'C#高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => '1', 'plan_director' => '', 'status' => '2', 'routing_id' => '2049', 'bom_id' => '1', 'oe_production_id' => '0', 'note' => '', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6167', 'create_uid' => '1000', 'create_date' => '2015-01-30 09:48:11.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 09:48:11.000', 'name' => 'C#高级编程_xyd工艺组1', 'plan_type' => '102', 'parent_id' => '6166', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => NULL, 'plan_director' => '', 'status' => '1', 'routing_id' => '1', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => 'oo', 'curr_id' => NULL, 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), 1 => array ( 'id' => '6168', 'create_uid' => '1000', 'create_date' => '2015-01-30 09:49:20.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 09:49:20.000', 'name' => 'C#高级编程_xyd工艺组2', 'plan_type' => '102', 'parent_id' => '6166', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => NULL, 'plan_director' => '', 'status' => '1', 'routing_id' => '2', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => 'pp', 'curr_id' => NULL, 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), ), ), 1 => array ( 'id' => '6189', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:45:00.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:45:00.000', 'name' => 'Java高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '6', 'product_qty' => '1', 'plan_director' => '', 'status' => '1', 'routing_id' => '2045', 'bom_id' => '6', 'oe_production_id' => '0', 'note' => '', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6190', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:45:00.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:45:00.000', 'name' => 'Java高级编程_Java高级编程-次包-工序包1', 'plan_type' => '102', 'parent_id' => '6189', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '6', 'product_qty' => NULL, 'plan_director' => '', 'status' => '4', 'routing_id' => '8', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => '', 'curr_id' => '3032', 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), ), ), 2 => array ( 'id' => '6191', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:48:38.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:48:38.000', 'name' => 'Java高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '6', 'product_qty' => '1', 'plan_director' => '', 'status' => '1', 'routing_id' => '2045', 'bom_id' => '6', 'oe_production_id' => '0', 'note' => '', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6192', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:48:38.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:48:38.000', 'name' => 'Java高级编程_Java高级编程-主包-工序包1', 'plan_type' => '102', 'parent_id' => '6191', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '6', 'product_qty' => NULL, 'plan_director' => '', 'status' => '8', 'routing_id' => '7', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => '', 'curr_id' => NULL, 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), ), ), 3 => array ( 'id' => '6193', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:51:45.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:51:45.000', 'name' => 'C#高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => '1', 'plan_director' => '', 'status' => '1', 'routing_id' => '2043', 'bom_id' => '1', 'oe_production_id' => '0', 'note' => '', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6194', 'create_uid' => '1000', 'create_date' => '2015-01-30 14:51:45.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 14:51:45.000', 'name' => 'C#高级编程_C#高级编程-主包', 'plan_type' => '102', 'parent_id' => '6193', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => NULL, 'plan_director' => '', 'status' => '2', 'routing_id' => '5', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => '', 'curr_id' => NULL, 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), ), ), 4 => array ( 'id' => '6195', 'create_uid' => '1000', 'create_date' => '2015-01-30 15:12:48.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 15:12:48.000', 'name' => 'C#高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => '1', 'plan_director' => '', 'status' => '1', 'routing_id' => '2043', 'bom_id' => '1', 'oe_production_id' => '0', 'note' => 'ld', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6196', 'create_uid' => '1000', 'create_date' => '2015-01-30 15:12:48.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 15:12:48.000', 'name' => 'C#高级编程_主包', 'plan_type' => '102', 'parent_id' => '6195', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => NULL, 'plan_director' => '', 'status' => '5', 'routing_id' => '5', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => 'ld', 'curr_id' => '2008', 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), ), ), 5 => array ( 'id' => '6197', 'create_uid' => '1000', 'create_date' => '2015-01-30 15:38:50.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 15:38:50.000', 'name' => 'C#高级编程', 'plan_type' => '102', 'parent_id' => '0', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => '1', 'plan_director' => '', 'status' => '1', 'routing_id' => '2043', 'bom_id' => '1', 'oe_production_id' => '0', 'note' => '', 'curr_id' => NULL, 'oe_ean13' => '9002', 'workcenter_id' => NULL, 'ischild' => 1, 'plan_director_name' => '', 0 => array ( 0 => array ( 'id' => '6198', 'create_uid' => '1000', 'create_date' => '2015-01-30 15:38:50.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 15:38:50.000', 'name' => 'C#高级编程_次包1', 'plan_type' => '102', 'parent_id' => '6197', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2', 'product_qty' => NULL, 'plan_director' => '', 'status' => '3', 'routing_id' => '6', 'bom_id' => NULL, 'oe_production_id' => NULL, 'note' => '', 'curr_id' => NULL, 'oe_ean13' => NULL, 'workcenter_id' => NULL, ), 1 => array ( 'id' => '6199', 'create_uid' => '1000', 'create_date' => '2015-01-30 15:38:50.000', 'write_uid' => '1000', 'write_date' => '2015-01-30 15:38:50.000', 'name' => 'C#高级编程_主包', 'plan_type' => '102', 'parent_id' => '6197', 'date_start' => '2015-01-30 00:00:00.000', 'date_stop' => '2015-01-30 00:00:00.000', 'product_id' => '2',//富文本框限制字符串为10000所以删了些 ), ), ),)
看到这结果就昏了
if (is_array($val)) { //判断$val的值是否是一个数组,如果是,则进入下层遍历
??是
if (is_array($val)) 判?是否有下一?
谢谢各位大侠的指点错误原因找到了,后台压数据时没指定下标,直接$monitorList[$key][]=query($sql);导致前台遍历出错。
给个下标就搞定了。