| <?php // require_once('page.php');
function show_icon($type){ global $APP; $setOfType = array("doc","bmp", "gif", "jpg", "mp3", "pdf", "png", "ppt", "rar", "txt", "xls", "zip"); if(in_array($type, $setOfType)){ $icon_file = "icon_".strtolower($type).".png"; }else{ $icon_file = "icon_others.png"; } $retimage = '<img src="'.$APP['PATH_TPL'].'/img/icon_set/'.$icon_file.'" />'; return $retimage; }
$str = '<table width="100%" cellspacing="1" border="0" class="dropbox"> ';
$ADDOBJECT = new App($db_config[DB]); $Q = "SELECT DISTINCT(a.fileCatID), b.catName FROM tbl_files as a INNER JOIN tbl_category as b ON a.fileCatID = b.catID ORDER BY a.fileCatID ASC"; $APPOBJECT->query($Q); if($APPOBJECT->num_rows()>0){ while($cat = $APPOBJECT->fetch_assoc()){ $dataCat[] = $cat; } for($j=0;$j<count($dataCat);$j++){ $catid = $dataCat[$j]['fileCatID']; $catName = $dataCat[$j]['catName']; $str .= ' <tr style="border-bottom: 1px solid #EEE;"> </tr> '; $Q = "SELECT a.*, UNIX_TIMESTAMP(a.insertedDate) as ux_inserted FROM tbl_files as a WHERE a.fileCatID = $catid ORDER BY a.insertedDate DESC"; $APPOBJECT->query($Q); unset($data); if($APPOBJECT->num_rows()>0){ while($f = $APPOBJECT->fetch_assoc()){ $data[] = $f; } for($i=0;$i<count($data);$i++){ $Q = "UPDATE tbl_files SET fileViewed = fileViewed + 1 WHERE fileID = ".$data[$i]['fileID']; $APPOBJECT->query($Q); if($lang=="EN"){ $fileTitle = $data[$i]['fileTitle'.$lang]; $fileModified = date("Y-m-d", $data[$i]['ux_inserted']); }else if($lang=="IN"){ $fileTitle = $data[$i]['fileTitle']; $fileModified = date("d-m-Y", $data[$i]['ux_inserted']); }else{ $fileTitle = $data[$i]['fileTitle'.DEFAULT_LANG]; $fileModified = date("Y-m-d", $data[$i]['ux_inserted']); } $str .= ' <tr><td style="padding:0 0 0 5px;" class="small hiddenCol">'.$fileModified.'</td></tr> <tr><td style="padding:0 0 0 5px;" class="small">'.$fileTitle.'</td></tr> <tr><td style="padding:0 0 0 20px;"><a href="javascript:void(0)" onclick="goDownload('.$data[$i]['fileID'].')">'.show_icon($data[$i]['fileTypes']).'</a></td></tr> <tr><td>'.$data[$i]['fileID'].'</td></tr> '; } } } $str .= '</table>'; }else{ $TPLOBJECT->LoadTemplate($APP['PATH_TPL']."/page.notfound.htm"); }
?> |
Tidak ada komentar:
Posting Komentar