PHP AssetType::getAssetTypeの例

コード例 #1

ファイル: addListMenuType.php プロジェクト: JhunCabas/asset-project-system

            <?php 
include_once "../class/Config.php";
include_once "../class/AssetType.php";
$showType = new AssetType();
$dbType = new config();
$arr = $showType->getAssetType();
?>
*
            <select id="addAssetType" onchange="changeType();">
            <option value="00">ประเภทครุภัณฑ์</option>
            <?php 
while ($row = $dbType->fetch_array($arr)) {
    ?>
            <?php 
    echo "<option value='" . $row['assetTypeCode'] . "'>";
    echo $row['assetTypeCode'] . " " . $row['assetTypeName'] . "</option>";
    ?>
      
                <?php 
}
?>
             </select>
           

コード例 #2

ファイル: tableGroup.php プロジェクト: JhunCabas/asset-project-system

?>
    <table class="table table-bordered">
        <thead>
            <tr>
            	<th style="width: 5%; text-align:center">ลำดับ</th>
                <th style="width: 28%; text-align:center">รหัสประเภทครุภัณฑ์</th>
                <th style="width: 28%; text-align:center">ชื่อประเภทครุภัณฑ์</th>
                <th style="width: 28%; text-align:center">วัน/เดือน/ปี ที่ได้มา</th>
                <th style="width: 10%; text-align:center">แก้ไข</th>
                <th style="width: 10%; text-align:center">ลบ</th>
            </tr>
        </thead>
            <tbody>
            
<?php 
$arr = $assType->getAssetType();
$no = 1;
while ($res = $db->fetch_array($arr)) {
    $datetime = DateTime::createFromFormat('Y-m-d', $res['assetTypeAddDate']);
    $dateT = $datetime->format('d/m/Y');
    $texts = substr($dateT, 6, 4);
    $dates = substr($dateT, 0, 6);
    $years = $texts + 543;
    $showdate = $dates . "" . $years;
    echo "<tr>";
    echo "<td id='Uid" . $no . "' style='text-align:center'>" . $no . "</td>";
    echo "<td id='Uuname" . $no . "' style='text-align:center'>" . $res['assetTypeCode'] . "</td>";
    echo "<td id='Ufname" . $no . "'>" . $res['assetTypeName'] . "</td>";
    echo "<td id='Ulname" . $no . "' style='text-align:center'>" . $showdate . "</td>";
    echo "<td id='Uedit" . $no . "' style='text-align:center'><a class='button icon edit' onClick='getEditType(" . $res['id'] . ");'></a></td>";
    echo "<td id='Udel" . $no . "' style='text-align:center'><a class='button icon remove danger' onClick='delType(" . $res['id'] . ");'></a></td>";

コード例 #3

ファイル: tableType.php プロジェクト: JhunCabas/asset-project-system

?>
    <table class="table table-bordered">
        <thead>
            <tr>
            	<th style="width: 5%; text-align:center">ลำดับ</th>
                <th style="width: 20%; text-align:center">รหัสประเภทครุภัณฑ์</th>
                <th style="width: 55%; text-align:center">ชื่อประเภทครุภัณฑ์</th>
                <th style="width: 10%; text-align:center">แก้ไข</th>
                <th style="width: 10%; text-align:center">ลบ</th>
            </tr>
        </thead>
            <tbody>
            
<?php 
$searchName = $_GET["searchName"];
$arr = $assType->getAssetType($searchName);
$no = 1;
while ($res = $db->fetch_array($arr)) {
    echo "<tr>";
    echo "<td id='Uid" . $no . "' style='text-align:center'>" . $no . "</td>";
    echo "<td id='Uuname" . $no . "' style='text-align:center'>" . $res['assetTypeCode'] . "</td>";
    echo "<td id='Ufname" . $no . "'>" . $res['assetTypeName'] . "</td>";
    echo "<td id='Uedit" . $no . "' style='text-align:center'><a class='button icon edit' onClick='getEditType(" . $res['id'] . ");'></a></td>";
    echo "<td id='Udel" . $no . "' style='text-align:center'><a class='button icon remove danger' onClick='delType(" . $res['id'] . ");'></a></td>";
    echo "</tr>";
    $no++;
}
?>
        </tbody>
    </table>