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

function ils_list(){
$output = '';
$query = db_select('node','n')->extend('PagerDefault');
$query->leftJoin('field_data_field_ils_image', 'i', 'n.nid = i.entity_id');
$query->fields('n')->fields('i');
$query->condition('n.status', 1)
  ->limit(3);//限制三条
$query->orderRandom();//随机排序
$objects = $query->execute()->fetchAll();
$rows = array();
$i = 1;
foreach ($objects as $key=>$object) {
  $row = array();
  $row['nid'] = $object -> nid;
  if($i == 1){
    //如果第一条数据，用big 样式。
    $row['ils_image'] = '<img src="'.image_style_url('big',gw_file_uri($object -> field_ils_image_fid)).'"/>';
  }
else{
    //其他数据，用small 样式。
    $row['ils_image'] = '<img src="'.image_style_url('small',gw_file_uri($object -> field_ils_image_fid)).'"/>';
  }
  $rows[] = $row;
  $i ++;
}
$output .= theme('ils', array('rows' => $rows));
return $output;
}