php code to display datewise stock in report
Posted: Wed Apr 05, 2017 3:20 am
Hi All,
Appreciate help in resolving the below issues. I had included the code below used but not able to get the exact output.
I am new to PHP so if any coding issues or improper way of presenting please ignore it.
[text]Emloyee Name 2016-04-02 2016-09-14 2017-02-15 2017-03-02 2017-04-02
Naveen 25 0 0 0 100
Srikanth 0 50 10 0 0
Sami 0 0 0 10 60
Total 25 50 10 10 160[/text]
=========================
[text]$distinctDate=array (size=5)
0 =>
array (size=1)
'field_5' => string '2016-04-02' (length=10)
1 =>
array (size=1)
'field_5' => string '2016-09-14' (length=10)
2 =>
array (size=1)
'field_5' => string '2017-02-15' (length=10)
3 =>
array (size=1)
'field_5' => string '2017-03-02' (length=10)
4 =>
array (size=1)
'field_5' => string '2017-04-02' (length=10)[/text]
=========================
[text]$dbData=array (size=6)
0 =>
array (size=3)
'field_1' => string 'naveen' (length=6)
'field_2' => string '25' (length=2)
'field_5' => string '2016-04-02' (length=10)
1 =>
array (size=3)
'field_1' => string 'srikanth' (length=8)
'field_2' => string '50' (length=2)
'field_5' => string '2016-09-14' (length=10)
2 =>
array (size=3)
'field_1' => string 'srikanth' (length=8)
'field_2' => string '10' (length=2)
'field_5' => string '2017-02-15' (length=10)
3 =>
array (size=3)
'field_1' => string 'sami' (length=4)
'field_2' => string '10' (length=2)
'field_5' => string '2017-03-02' (length=10)
4 =>
array (size=3)
'field_1' => string 'naveen' (length=6)
'field_2' => string '100' (length=3)
'field_5' => string '2017-04-02' (length=10)
5 =>
array (size=3)
'field_1' => string 'sami' (length=4)
'field_2' => string '60' (length=2)
'field_5' => string '2017-04-02' (length=10)[/text]
=======================
Thanks,
Nick
Appreciate help in resolving the below issues. I had included the code below used but not able to get the exact output.
I am new to PHP so if any coding issues or improper way of presenting please ignore it.
[text]Emloyee Name 2016-04-02 2016-09-14 2017-02-15 2017-03-02 2017-04-02
Naveen 25 0 0 0 100
Srikanth 0 50 10 0 0
Sami 0 0 0 10 60
Total 25 50 10 10 160[/text]
=========================
[text]$distinctDate=array (size=5)
0 =>
array (size=1)
'field_5' => string '2016-04-02' (length=10)
1 =>
array (size=1)
'field_5' => string '2016-09-14' (length=10)
2 =>
array (size=1)
'field_5' => string '2017-02-15' (length=10)
3 =>
array (size=1)
'field_5' => string '2017-03-02' (length=10)
4 =>
array (size=1)
'field_5' => string '2017-04-02' (length=10)[/text]
=========================
[text]$dbData=array (size=6)
0 =>
array (size=3)
'field_1' => string 'naveen' (length=6)
'field_2' => string '25' (length=2)
'field_5' => string '2016-04-02' (length=10)
1 =>
array (size=3)
'field_1' => string 'srikanth' (length=8)
'field_2' => string '50' (length=2)
'field_5' => string '2016-09-14' (length=10)
2 =>
array (size=3)
'field_1' => string 'srikanth' (length=8)
'field_2' => string '10' (length=2)
'field_5' => string '2017-02-15' (length=10)
3 =>
array (size=3)
'field_1' => string 'sami' (length=4)
'field_2' => string '10' (length=2)
'field_5' => string '2017-03-02' (length=10)
4 =>
array (size=3)
'field_1' => string 'naveen' (length=6)
'field_2' => string '100' (length=3)
'field_5' => string '2017-04-02' (length=10)
5 =>
array (size=3)
'field_1' => string 'sami' (length=4)
'field_2' => string '60' (length=2)
'field_5' => string '2017-04-02' (length=10)[/text]
=======================
Code: Select all
<table border="1px solid #666" style="text-align:center;" cellpadding='0' cellspacing='0'>
<thead>
<tr>
<th>Employee Name</th>
<?php foreach($distinctDate as $date):?>
<?php $dates[] = $date['field_5'];?>
<th><?php echo $date['field_5'];?></th>
<?php endforeach;?>
</tr>
</thead>
<tbody>
<?php $j = 0;?>
<?php foreach($dbData as $key => $value):?>
<?php $names[] = $value['field_1'];?>
<?php $uniValues = array_count_values($names);?>
<?php if($uniValues[$value['field_1']] == 1):?>
<tr>
<td>
<?php echo $value['field_1'];?>
</td>
<?php $i = 0;?>
<?php foreach($distinctDate as $date):?>
<td align="center">
<?php if($names[$i] == $dbData[$j]['field_1']):?>
<?php echo $dbData[$j]['field_2'];?>
<?php else:?>
<?php foreach($dbData as $dat):?>
<?php if($dat['field_1'] == $names[$j] && $dates[$i] == $dat['field_5']):?>
<?php echo $dat['field_2'];?>
<?php endif;?>
<?php endforeach;?>
<?php endif;?>
</td>
<?php ++$i;?>
<?php endforeach;?>
</tr>
<?php endif;?>
<?php ++$j;?>
<?php endforeach;?>
</tbody>
</table>Thanks,
Nick