1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

<?php  
$formid=$_REQUEST['formid'];
require_once "inc/configure.php";

$refid=(int)$_REQUEST['refid'];
$pdt_moldno=$_REQUEST['pdt_moldno'];

if($pdt_moldno){
    $sql = "SELECT top (1) *
            FROM
            dbo.dgn_master_mold
            WHERE
            dbo.dgn_master_mold.pdt_moldno = :pdt_moldno
            ORDER BY
            dbo.dgn_master_mold.refid DESC";
    $sth = $dbh->prepare($sql);
    $sth->execute(  array(':pdt_moldno' => $pdt_moldno) );    
    $row0 = $sth->fetch();
    $refid = $row0['refid'];
}
    

$sql = "SELECT * FROM dgn_master_moldimg WHERE mold_refid=:refid ORDER BY refid ASC";    
//echo $sql;    
$sth = $dbh->prepare($sql);
$sth->execute( array(":refid"=>$refid) );
//echo $sth->getSQL();
    
if($row = $sth->fetch() ){?>
    <img src="<?=$row['img_path'].THUMB_PATH.$row['img_src']?>" style="width: 300px;" />
<?php 
}     else {
    
    $sql = "SELECT
            dbo.dgn_techdrawing_img.refid,
            dbo.dgn_techdrawing_img.img_src,
            dbo.dgn_techdrawing_img.img_path
            
            FROM
            dbo.dgn_master_mold
            INNER JOIN dbo.dgn_drawing ON dbo.dgn_drawing.drawing_no = dbo.dgn_master_mold.drawing_no
            INNER JOIN dbo.dgn_techdrawing_img ON dbo.dgn_techdrawing_img.drawing_refid = dbo.dgn_drawing.refid
            WHERE
            dbo.dgn_master_mold.refid = :refid
            ORDER BY dbo.dgn_drawing.refid DESC
            ";    
    //echo $sql;    
    $sth = $dbh->prepare($sql);
    $sth->execute( array(":refid"=>$refid) );
    
    if($row = $sth->fetch() ){?>
        <img src="<?=$row['img_path'].THUMB_PATH.$row['img_src']?>" style="width: 300px;" />
    <?php }
    
}

?>