001.<tbody>
002.<?php
003.
004.
005.$temp_data1=null;
006.$temp_data2=null;
007.$data_show=1;
008.
009.$i=1;
010.
011.
012.$arr_dateCheck=[];
013.
014.
015.$aggre_price=[];
016.$aggre_com=[];
017.
018.
019.$data_price=[];
020.$data_com=[];
021.
022.$q="
023.SELECT * FROM tbl_sale ORDER BY sale_date
024.";
025.$rs=$mysqli->query($q);
026.$total=$rs->num_rows;
027.while($data=$rs->fetch_assoc()){
028. $show_row_end=0;
029.
030. $dateKey=date("dmY",strtotime($data['sale_date']));
031.
032.
033. $temp_data1=$data['sale_date'];
034. if($temp_data2==null){
035. $temp_data2=$temp_data1;
036. $data_show=1;
037. }else{
038. if($temp_data1==$temp_data2){
039. $data_show=0;
040. $temp_data2=$temp_data1;
041. }else{
042. $temp_data2=$temp_data1;
043. $data_show=1;
044. }
045. }
046.
047.
048. $arr_dateCheck[$i]=$data['sale_date'];
049.
050.
051. if($i>1 && $arr_dateCheck[$i-1]!=$data['sale_date']){
052.
053. $dateKeyCheck=date("dmY",strtotime($arr_dateCheck[$i-1]));
054. $show_row_end=1;
055. }
056.
057.
058. if(!isset($data_price[$dateKey])){
059. $data_price[$dateKey]=[];
060. array_push($data_price[$dateKey],$data['sale_price']);
061. }else{
062. array_push($data_price[$dateKey],$data['sale_price']);
063. }
064. if(!isset($data_com[$dateKey])){
065. $data_com[$dateKey]=[];
066. array_push($data_com[$dateKey],$data['sale_com']);
067. }else{
068. array_push($data_com[$dateKey],$data['sale_com']);
069. }
070.
071.
072.?>
073. <?php
074.
075.
076. if($show_row_end==1){?>
077. <?php
078.
079. array_push($aggre_price,array_sum($data_price[$dateKeyCheck]));
080. array_push($aggre_com,array_sum($data_com[$dateKeyCheck]));
081. ?>
082. <tr class="bg-warning">
083. <td class="text-right">รวมรายวัน</td>
084. <td></td>
085. <td><?=array_sum($data_price[$dateKeyCheck])?></td>
086. <td><?=array_sum($data_com[$dateKeyCheck])?></td>
087. </tr>
088. <tr class="bg-info">
089. <td class="text-right">รวมสะสม</td>
090. <td></td>
091. <td><?=array_sum($aggre_price)?></td>
092. <td><?=array_sum($aggre_com)?></td>
093. </tr>
094. <?php } ?>
095. <tr>
096. <td>
097. <?php if($data_show==1){?>
098. <?=$data['sale_date']?>
099. <?php } ?>
100. </td>
101. <td><?=$data['sale_product']?></td>
102. <td><?=$data['sale_price']?></td>
103. <td><?=$data['sale_com']?></td>
104. </tr>
105. <?php if(
106.
107. $i==$total){?>
108. <?php
109.
110. $dateKeyCheck=date("dmY",strtotime($data['sale_date']));
111.
112. array_push($aggre_price,array_sum($data_price[$dateKeyCheck]));
113. array_push($aggre_com,array_sum($data_com[$dateKeyCheck]));
114. ?>
115. <tr class="bg-warning">
116. <td class="text-right">รวมรายวัน</td>
117. <td></td>
118. <td><?=array_sum($data_price[$dateKeyCheck])?></td>
119. <td><?=array_sum($data_com[$dateKeyCheck])?></td>
120. </tr>
121. <tr class="bg-info">
122. <td class="text-right">รวมสะสม</td>
123. <td></td>
124. <td><?=array_sum($aggre_price)?></td>
125. <td><?=array_sum($aggre_com)?></td>
126. </tr>
127. <?php } ?>
128.<?php $i++; } ?>
129.</tbody>
130.</table>
131.
132.
133.
134.</div>
135.
136.</body>
