duanpo7354 2015-12-18 12:27
浏览 16
已采纳

如果单元格重复,php表添加值

I have a wordpress loop retriving a table like this:

enter image description here

I want to check if the name repeats it self and if so do a sum of partial values to show the total. On my screenshot the 1st and 3rd rows have the same "nome" so the global value should be 85, can any one tellme how to do this ?

my php :

<?php while( have_rows('wallet_repeater') ): the_row(); 

echo '<div class="promotoras_item_wallet">  ';
echo '<div class="promnames_wallet">  ';
// vars

$adicionados = get_sub_field('wallet_promotora');

  foreach($adicionados as $post) :

$nome = simple_fields_values("pname1");
$im = simple_fields_values("ftotop");
$cp=$adicionados ;
$imatop = $im; 
$data=get_sub_field('wallet_data');
$evento=get_sub_field('wallet_evento');
$obs=get_sub_field("wallet_obs");  
$numeros_horas = get_sub_field("Wallet_n_horas");
$valor_horas = get_sub_field("wallet_valorh");
$evento = get_sub_field("wallet_evento");
$horarios = get_sub_field("wallet_horario");

$total_parcial = $valor_horas * $numeros_horas."€";
$ii = wp_get_attachment_image($imatop[0]);


?>

<table id="wallet_table1" width="900px" border="0" cellspacing="2" cellpadding="0">
  <tbody>
    <tr>
       <tr onmouseover="this.style.backgroundColor='#ffff66';" onmouseout="this.style.backgroundColor='#d4e3e5';">

      <td class="wallet_data_img" width="5"><div class="w_promotora_images"><?php echo wp_get_attachment_image($imatop[0]);  ?></td>
      <td class="wallet_data_data" width="20"><?php echo the_sub_field('wallet_data'); ?> </td>
      <td class="wallet_data_nome" width="200"><?php echo $nome[0];$nomes[]=$nome[0];?></td>
      <td class="wallet_data_evento" width="10"> <?php echo the_sub_field("wallet_evento"); ?></td>
      <td class="wallet_data_horarios" width="10"><?php echo the_sub_field("wallet_horario");  ?></td>
      <td class="wallet_data_obs" width="10"><?php echo the_sub_field("wallet_obs"); ?></td>
      <td class="wallet_data_horas" width="10"><?php echo the_sub_field("Wallet_n_horas")."h"; ?></td>
      <td class="wallet_data_valorh" width="5"><?php echo the_sub_field("wallet_valorh")."€"; ?></td>
      <td class="wallet_data_props" width="5"><?php echo the_sub_field("wallet_props"); ?></td>
      <td class="wallet_data_total" width="5">Parcial: <?php echo $total_parcial; ?> global: 

</td> </tr></tbody></table>


<?php
  • 写回答

1条回答 默认 最新

  • douhe4336 2015-12-18 14:18
    关注

    Stuff the query data into an associative array and after that output it. You can do it like that:

    $qry = new WP_Query('post_type' => 'your_post_type', 'posts_per_page' => -1)
    $arr = array();
    while($qry->have_posts()) {
        $qry->the_post()
        $nam = //Get the name data;
        $val = //Get the «global» data;
        if($qry[$nam]) {
            $qry[$nam]['global'] += $val;
        }
        else {
            $qry[$nam] = array(
                'foto' => //Photo data of the current post,
                'name' => //Photo data of the current post,
                //and so on
                'global' => $val,
            );
        }
    }
    foreach($qry as $key => $data) {
        //Output your table here
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
  • ¥15 数据可视化Python
  • ¥15 要给毕业设计添加扫码登录的功能!!有偿
  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题:求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘