001.<div id="menu8" class="tab-pane fade">
002. <?php
003. $machine = $db->prepare('SELECT mType,mName,maintaince,id,inuse, SUBSTRING(mName,-2,2) AS substr
004. FROM tbl_machine
005. WHERE mType = 10
006. ORDER BY substr ASC');
007. $machine->execute();
008. ?>
009.
010. <?php
011. $i = 0;
012. while($row = $machine->fetch(PDO::FETCH_ASSOC)) {
013.
014.
015.
016.
017.
018.
019.
020.
021.
022.
023.
024.
025.
026.
027.
028.
029.
030.
031.
032.
033.
034.
035.
036.
037. ?>
038.
039. <div class="col-sm-2 col-md-2" style="padding-top: 1cm;" >
040. <div class="thumbnail">
041. <?php
042. $disabled = '';
043. if ($row['maintaince'] <> 0) {
044. $pic = 'image/installation-icon.jpg';
045. $disabled = 'disabled';
046. $text = 'ชำรุด';
047. $alert = 'danger';
048. }
049. else if ($row['inuse'] == 1) {
050.
051. $m_id = $row['id'];
052. $status = 'Y';
053.
054. $log = $db->prepare('SELECT Id,machine_id
055. FROM tbl_logs
056. WHERE machine_id = :m_id AND status = :status
057. ORDER BY Id DESC');
058. $log->bindParam(':m_id',$m_id,PDO::PARAM_STR);
059. $log->bindParam(':status',$status,PDO::PARAM_STR);
060. $log->execute();
061. $r = $log->fetch(PDO::FETCH_ASSOC);
062.
063.
064. $logs_id = $r['Id'];
065. $mat = $db->prepare('SELECT title,barcode,call_on
066. FROM tbl_material
067. WHERE logs_id = :logs_id
068. ORDER BY Id DESC');
069. $mat->bindParam(':logs_id',$logs_id,PDO::PARAM_STR);
070.
071. $mat->execute();
072. $r_mat = $mat->fetch(PDO::FETCH_ASSOC);
073.
074.
075. $call_on = $r_mat['call_on'];
076. $call = $db->prepare('SELECT result_callno,result_time
077. FROM tbl_result
078. WHERE result_callno = :call_on ');
079. $call->bindParam(':call_on',$call_on,PDO::PARAM_STR);
080. $call->execute();
081. $r_call = $call->fetch(PDO::FETCH_ASSOC);
082.
083. $pic = 'image/User-Computer.png';
084. $text = 'คืน';
085. $alert = 'warning';
086. $in = 'return';
087. }
088. else {
089. $pic = 'image/My-Computer-icon.png';
090. $text = 'ยืม';
091. $alert = 'primary';
092. $in = 'add';
093. }
094. ?>
095.
096. <img src="<?=$pic?>" alt="...">
097. <div class="caption">
098. <h5><?=$row['mName'];?></h5>
099. <p><?=$r_mat['call_on'];?></p>
100. <p class="text-primary"><?=$r_mat['title'];?></p>
101. <p class="text-primary"><?=$r_call['result_time'];?></p>
102. <p><a href="Machineborrowform.php?action=<?=$in;?>&&id=<?=$row['id'];?>&&inuse=<?=$row['inuse'];?>" class="btn btn-<?=$alert?>" role="button" <?=$disabled?> > <?=$text?></a><!-- <a href="javascript:if(confirm('ยืนยันการคืนทรัพยากร \r\n<?=$row['mName'] ?>')==true){window.location='return.php?id=<?=$row['id'];?>&&inuse=<?=$row['inuse'];?>';}" class="btn btn-default" role="button" <?=$a?> <?=$b?> >คืน</a> --></p>
103. </div>
104. </div>
105. </div>
106.<?php
107.$i++;
108.}
109.?>
110. </div>
Load balance : Server 04
