Exemplo n.º 1
0
 function recommend($pageId, $uid = null)
 {
     $itemsNum = 4;
     //控制次调用返回的数据数量$itemsNum-1个
     $from = $itemsNum * ($pageId - 1);
     $to = $itemsNum;
     $limit = ' ' . $from . ',' . $to . ' ';
     // 每页4条数据
     if (isset($uid)) {
         $items = UserLikeModel::getUserItems($uid);
         $arr = array('isRecommend' => 1);
         $orderby = '`itemPic desc`';
         $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit);
         $data = array();
         while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) {
             if (in_array($line['id'], $items)) {
                 $line['isFavorite'] = 1;
             } else {
                 $line['isFavorite'] = 0;
             }
             $data[] = $line;
         }
         return $data;
     } else {
         $arr = array('isRecommend' => 1);
         $orderby = '`itemPic desc`';
         $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit);
         $data = array();
         while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) {
             $line['isFavorite'] = 0;
             $data[] = $line;
         }
         return $data;
     }
 }
Exemplo n.º 2
0
 function presentForHuman2($pageId = 1)
 {
     $itemsNum = 4;
     //控制次调用返回的数据数量
     $from = $itemsNum * ($pageId - 1);
     $to = $itemsNum * $pageId - 1;
     $limit = ' ' . $from . ',' . $to . ' ';
     // 每页5条数据
     $arr = array("isRecommend" => 1);
     $orderby = 'itemDate';
     $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit);
     $data = array();
     while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) {
         $data[] = $line;
     }
     return $data;
 }
Exemplo n.º 3
0
 function newItems($pageId, $itemNum = null, $uid = 0)
 {
     $itemsNum = isset($itemNum) ? $itemNum : 6;
     //控制次调用返回的数据数量
     $from = $itemsNum * ($pageId - 1);
     $to = $itemsNum;
     $limit = ' ' . $from . ',' . $to . ' ';
     $orderby = 'itemDate';
     $arr = array('isTop' => 0);
     //第一页加上置顶内容
     if ($pageId == 1) {
         $arr_top = array('isTop' => 1);
         $re1 = ItemInfo::iteminfo_select_ordby($arr_top, $orderby, null);
         $re2 = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit);
         $data = array();
         $like = new UserLikeModel();
         while ($line = mysql_fetch_array($re1, MYSQL_ASSOC)) {
             $line['islike'] = $like->checkUserLike($uid, $line['id']);
             $line['likesum'] = $like->itemLikeSum($line['id']);
             $data[] = $line;
         }
         while ($line = mysql_fetch_array($re2, MYSQL_ASSOC)) {
             $line['islike'] = $like->checkUserLike($uid, $line['id']);
             $line['likesum'] = $like->itemLikeSum($line['id']);
             $data[] = $line;
         }
         return $data;
     } else {
         $re = ItemInfo::iteminfo_select_ordby($arr, $orderby, $limit);
         $data = array();
         $like = new UserLikeModel();
         while ($line = mysql_fetch_array($re, MYSQL_ASSOC)) {
             $line['islike'] = $like->checkUserLike($uid, $line['id']);
             $line['likesum'] = $like->itemLikeSum($line['id']);
             $data[] = $line;
         }
         return $data;
     }
 }