goods.php 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. /**
  3. * @copyright (c) 2011 aircheng.com
  4. * @file goods.php
  5. * @author chendeshan
  6. * @date 2011-9-30 13:49:22
  7. * @version 0.6
  8. */
  9. class APIGoods
  10. {
  11. //获取全部商品特价活动
  12. public function getSaleList()
  13. {
  14. $promoDB = new IModel('promotion');
  15. $promoList = $promoDB->query("is_close = 0 and award_type = 7","*","sort asc");
  16. $goodsDB = new IModel('goods');
  17. foreach($promoList as $key => $val)
  18. {
  19. $intro = JSON::decode($val['intro']);
  20. $intro = array_keys($intro);
  21. $intro = join(",",$intro);
  22. $promoList[$key]['goodsList'] = $goodsDB->query("id in (".$intro.") and is_del = 0","id,name,sell_price,sort,img,market_price,sale","sort asc");
  23. }
  24. return $promoList;
  25. }
  26. //根据id获取单个商品特价活动
  27. public function getSaleRow($id)
  28. {
  29. $promoDB = new IModel('promotion');
  30. $promoRow = $promoDB->getObj("is_close = 0 and award_type = 7 and id = {$id}");
  31. if($promoRow)
  32. {
  33. $intro = JSON::decode($promoRow['intro']);
  34. $intro = array_keys($intro);
  35. $intro = join(",",$intro);
  36. $goodsDB = new IModel('goods');
  37. $promoRow['goodsList'] = $goodsDB->query("id in (".$intro.") and is_del = 0","id,name,sell_price,sort,img,market_price","sort asc");
  38. }
  39. return $promoRow;
  40. }
  41. }