<table border="1" style="background-color:#FFFFCC;border-collapse:collapse;border:1px solid #FFCC00;color:#000000;width:100%" cellpadding="3" cellspacing="3">
    <tr>
        <td colspan="6" align="center">
            <h1 style="padding: 0px; margin-bottom: 0px;"><?php echo COMPANY; ?></h1>
            <h3 style="padding: 0px; margin: 0px;"><?php echo $branch[0]->branch_name; ?></h3>
            <?php echo ADDRESS; ?><br>
            <?php echo PHONE; ?><br>
            Stock Reports<br>
        </td>		
    </tr>
    <tr>
        <td colspan="3" style="vertical-align:top;">
            <table border="1" style="background-color:#FFFFCC;border-collapse:collapse;border:1px solid #FFCC00;color:#000000;width:100%" cellpadding="3" cellspacing="3">
                <tr>
                    <td>Product ID</td>
                    <td>Product Name</td>
                    <?php foreach ($branch1 as $res) { ?>
                    <td align="center" width="120px"><?php echo $res->branch_name;?></td>
                    <?php } ?>
                </tr>
                <?php
                $itotal = 0;

//                echo '<pre>';
//                print_r($result);
//                echo '</pre>'; 
                
                foreach ($result as $in) {
                    $branch_quantity = $in->branch_quantity;
                    
                        //  print_r($branch_qty_array);
                       
                            ?>
                            <tr>
                                <td><?php echo $in->product_id; ?></td>
                                <td><?php echo $in->product_name; ?></td>
                                <?php 
                        ?>
                                <?php
                                foreach ($branch1 as $res1) {?>
                                    <td align="center"><?php
                                    $branch_id = $res1->branch_id;
                                    $branch_qty_array = json_decode($branch_quantity, true);
                                    echo $branch_qty_array[$branch_id];?></td><?php
                                 }  ?>
                                    
                               
                            </tr>
                            <?php
                        
                }
                ?>
                <tr>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td></td>
                    <td><?php echo $itotal; ?></td>

                </tr>
            </table>





        </td>


    </tr>


</table>
<?php
//print_r($expanse); ?>