<? 
    require_once($MODPATH ."inc.php") ;

    echo "<table border=1 cellspacing=0>";
    echo "<tr>" ;
    echo "<td>วันที่</td>" ;
    echo "<td>สถานที่</td>" ;
    echo "<td width=100>ชนิด</td>" ;
    echo "<td width=180>อุปกรณ์</td>" ;
    echo "<td width=250>อาการเสีย</td>" ;
    echo "<td width=150>สถานะ</td>" ;
    echo "<td width=150>จัดการ</td>" ;
    echo "</tr>" ;

    $sql =  "SELECT * FROM " . TB_mtitem ;
    $res['item'] = $db->select_query($sql);
    
    while($arr['item'] = $db->fetch($res['item']) ){
        //print_r($arr['item']); echo "<br>" ;
        echo "<tr>" ;
        echo "<td>" . ThaiTimeConvert($arr['item']['post_date']) . "</td>" ;
        echo "<td>" . $arr['item']['room'] . "</td>" ;
        echo "<td>" . $arr['item']['type'] . "</td>" ;
        echo "<td>";
        $res[device] = $db->select_query($sql="SELECT * FROM ".TB_device." WHERE id='" .  $arr['item']['device'] ."'" );
        $arr[device] = $db->fetch($res[device]) ;
        if($arr[device]){
            echo $arr[device][brand] . ' ' . $arr[device][model]  . ' ' . $arr[device][sn]  ;
        }
        else {
            echo $arr['item']['device'] ;
        }
        echo "</td>" ;

        echo "<td>" . $arr['item']['comment'] . "</td>" ;
        echo "<td>" . $arr['item']['status'] . "</td>" ;

        echo "<td>";
        echo "<a href='?name=maintenance&file=item_del&op=del&id=".$arr['item'][id] ."' >ลบ</a>  \n";
        echo "<a href='?name=maintenance&file=inform&op=view&id=".$arr['item'][id] ."' >แก้ไข</a>  \n";
        echo "</td>";
        echo "</tr>" ;
    }

    echo "</table>";
    
?>