Sku.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. <?php namespace Api\Lib;
  2. use Dever;
  3. class Sku
  4. {
  5. # 获取当前价格
  6. public function getPrice($where, $spec_type, $app)
  7. {
  8. $result['price'] = 0;
  9. $result['id'] = 0;
  10. $result['name'] = '';
  11. if ($spec_type == 2) {
  12. $where['key'] = '-1';
  13. $sku = Dever::db('sku', $app)->find($where);
  14. } elseif ($spec_type == 3) {
  15. $sku = Dever::db('sku', $app)->find($where, array('order' => 'price asc,id desc'));
  16. }
  17. if (isset($sku) && $sku) {
  18. $result['price'] = $sku['price'];
  19. $result['id'] = $sku['id'];
  20. $result['key'] = str_replace(',', '_', $sku['key']);
  21. $result['name'] = $this->getName($sku['key'], $app);
  22. }
  23. return $result;
  24. }
  25. # 多规格获取多个价格
  26. public function getList($where, $sku_id, $app)
  27. {
  28. $result = array();
  29. $sku = Dever::db('sku', $app)->select($where, array('order' => 'price asc,id desc'));
  30. if ($sku) {
  31. $result['info'] = array();
  32. $result['spec'] = Dever::load('spec', 'api')->getList($where, $app);
  33. foreach ($sku as $k => $v) {
  34. $t = array();
  35. $k = str_replace(',', '_', $v['key']);
  36. $t['id'] = $v['id'];
  37. $t['pic'] = $v['pic'];
  38. $t['value'] = $v['price'];
  39. $result['price'][$k] = $t;
  40. if ($sku_id && $sku_id == $v['id']) {
  41. $t['name'] = $this->getName($v['key'], $app);
  42. $result['info'] = $t;
  43. }
  44. }
  45. }
  46. return $result;
  47. }
  48. # 获取某个sku的名称
  49. public function getName($key, $app)
  50. {
  51. if (!$key || $key == '-1') {
  52. return '';
  53. } else {
  54. $name = array();
  55. $where['id'] = array('in', $key);
  56. $data = Dever::db('spec_value', $app)->select($where);
  57. if ($data) {
  58. foreach ($data as $k => $v) {
  59. $info = Dever::db('spec', $app)->find($v['spec_id']);
  60. $name[] = $info['name'] . ':' . $v['value'];
  61. }
  62. }
  63. return implode(',', $name);
  64. }
  65. }
  66. }