Here is my php and html code i have problem in final calculation of total When in any item there is only entry in Kg at that time it does not effect in main total.
Example
If Have value value in kgqty 1 and in kgpcs i have value 0 than in main total it's shows me 0 but the real calculation is it's shows me 1 in Total
Php Code
$pendingArray = array();
$qty = 0;
$selectParty = "SELECT *,categorynm FROM item
JOIN category ON category.categoryId = item.categoryId
ORDER BY item.itemId";
$selectPartyRes = mysql_query($selectParty);
while($row = mysql_fetch_array($selectPartyRes))
{
$pendingArray[$row['itemId']]['itemId'] = $row['itemId'];
$pendingArray[$row['itemId']]['itemNm'] = $row['itemNm'];
$pendingArray[$row['itemId']]['qty'] = 0;
$pendingArray[$row['itemId']]['kgqty'] = 0;
$pendingArray[$row['itemId']]['kgpcs'] = 0;
$pendingArray[$row['itemId']]['ing'] = 0;
$slectIssue = "SELECT SUM(qty) AS kgqty
FROM tableorderdetail
JOIN item ON item.itemId = tableorderdetail.itemId
JOIN tableorder ON tableorder.tableorderId = tableorderdetail.tableorderId
WHERE unit = 'KG'
AND tableorderdetail.itemId = ".$row['itemId']."
AND categoryId = 1
AND (status = 'Y' OR status = 'N')
GROUP BY item.itemId";
$slectIssueRes = mysql_query($slectIssue);
while($irow = mysql_fetch_array($slectIssueRes))
{
$pendingArray[$row['itemId']]['tableorderdetailId'] = $irow['tableorderdetailId'];
$pendingArray[$row['itemId']]['kgqty'] += round($irow['kgqty'],2);
}
$slectIssue = "SELECT SUM(qty) AS kgpcs
FROM tableorderdetail
JOIN item ON item.itemId = tableorderdetail.itemId
JOIN tableorder ON tableorder.tableorderId = tableorderdetail.tableorderId
WHERE unit = 'PCS'
AND tableorderdetail.itemId = ".$row['itemId']."
AND categoryId = 1
AND (status = 'Y' OR status = 'N')
GROUP BY item.itemId";
$slectIssueResi = mysql_query($slectIssue);
while($irow = mysql_fetch_array($slectIssueResi))
{
$pendingArray[$row['itemId']]['kgpcs'] += $irow['kgpcs'];
$pendingArray[$row['itemId']]['inKg'] += $irow['kgpcs']/10;
$pendingArray[$row['itemId']]['ing'] = $pendingArray[$row['itemId']]['kgqty']+ $pendingArray[$row['itemId']]['inKg'];
}
$kgQtys += $pendingArray[$row['itemId']]['kgqty'];
$allQty += $pendingArray[$row['itemId']]['ing'];
$kgPcs += $pendingArray[$row['itemId']]['kgpcs'];
Html Code
<tr>
<th>Item Name</th>
<th>Qty</th>
<th>Pcs</th>
<th>Totoal </th>
</tr>
{foreach from=$pendingArray item=onerow}
{if $onerow.kgqty gt 0 || $onerow.kgpcs gt 0}
<tr>
<td align="center">{$onerow.itemNm}</td>
<td align="center">{$onerow.kgqty}</td>
<td align="center">{$onerow.kgpcs}</td>
<td align="center">{$onerow.ing}</td>
</tr>
{/if}
{/foreach}