<?php
require_once("../headMyStockStaff.php");
?>
 
  
<center> 
 
<table border="0" class="shop_default">
 <tr>
  <td colspan="2"> 

    <label id="main_lab">MY SHOP</label>

    </td>
 </tr>
<?php    
//id=$shopid&&id2=$ownID&&id3=$ownerid
$myS=$mcon->getMyShop($ownID);
if($myS->rowCount()>0){
 $sho=$myS->fetchAll();
 foreach ($sho as $key => $shop) {
  $shopid=$shop['shopid']; 
    
?> 
<tr>
  <td colspan="2">
             
  
<label id="main_lab">PRODUCTS</label><p/>

 <center>

<table border="1" style="border-color:white" id="output">
    
    <tr><td id="td_height" ><label id="inner_top">NAME</label></td> <td><label id="inner_top">WEIGHT / VOLUME</label></td>
              <td><label id="inner_top">CATEGORY</label></td>

                <!--<td id="td_height" ><label id="inner_top">MANUFACTURE/VENDOR</label></td>


                <td id="td_height" ><label id="inner_top">DESCRIPTION</label></td>-->
 
                <td id="td_height" ><label id="inner_top">PRICE</label></td>  
 
 
                </tr>    
      

 <?php
    

  
         
$dD=$mcon->getShopItemPrices($shopid,$ownID);

if($dD->rowCount()>0){
 $roN=$dD->fetchAll();
 foreach ($roN as $key => $rowN){ 
 
  $itemid=$rowN['itemID'];
 
  $item=$mcon->getThisItem($itemid);
if($item->rowCount()>0){
   $it=$item->fetch(); 
    
  
   ?>    
     
 <tr>
     <td id="td_height" ><label id="inner_lab"> <?php echo $it["itemname"];?> </label></td>

     <td><label id="inner_lab"><?php echo $it["itemtype"];?> </label></td>

     <td id="td_height" ><label id="inner_lab"><?php echo $it["itemcategory"];?> </label></td>

    <!-- <td><label id="inner_lab"><?php //echo $it["vendor"];?> </label></td>

     <td><label id="inner_lab"><?php //echo $it["description"];?> </label></td>-->
 


     <td ><label id="inner_lab"><?php echo $rowN["price"];?> </label></td>

      
   </tr> 
            
       
 
   
<?php 
}
 
 
}
?>

 
 </table>

   </center>
          

  <?php  
  
}
  ?>

  <p/><label id="main_lab">LOCATION AND CONTACT INFORMATION</label><p/>

     <ul>
        <li id="padli">
          <label id="min_lab">NAME</label>
          <p/><i><?php echo $shop['shopname'];?></i>
        </li>
         <li id="padli">
          <label id="min_lab">STREET</label>

          <p/><i><?php echo $shop['street'];?></i>
        </li>
        <li>
          <label id="min_lab">WARD</label>

          <p/><i><?php echo $shop['ward'];?></i>

        </li>

        <li id="padli">
          <label id="min_lab">DISTRICT</label>

          <p/><i><?php echo $shop['district'];?></i>
        </li>
        <li id="padli">
          <label id="min_lab">REGION</label>

          <p/><i><?php echo $shop['region'];?></i>
        </li>
        <li id="padli">
          <label id="min_lab">COUNTRY</label>

          <p/><i><?php echo $shop['country'];?></i>
        </li>

        <li id="padli">
          <label id="min_lab">PHONE NUMBER</label>

          <p/><i><?php echo $shop['phoneno'];?></i>
        </li>

        <li id="padli">
          <label id="min_lab">EMAIL ADDRESS</label>

          <p/><i><?php echo $shop['email'];?></i>
        </li>

        <li id="padli">
          <label id="min_lab">POSTAL ADDRESS</label>

          <p/><i><?php echo $shop['postAddress'];?></i>
        </li>
        <li id="padli">
          <label id="min_lab">POPULAR MARK</label>

          <p/><i><?php echo $shop['popularmark'];?></i>
        </li> 
     </ul><p/>



       </td>

  </tr>


<?php
     
 }  
}
else{ 
  ?>
  <tr>
    <td colspan="2">
      Not yet register a shop!..
    </td>

  </tr>
  </table>
<?php
}

 
?>
</center>