Manage.php 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. <?php namespace Channel\Lib;
  2. use Dever;
  3. use Manage\Lib\Auth;
  4. class Manage extends Auth
  5. {
  6. # 获取渠道列表
  7. public function getInfo()
  8. {
  9. return Dever::db('info', 'channel')->select(array('status' => 1));
  10. }
  11. public function formatTime($timevalue)
  12. {
  13. if(strpos($timevalue,"-"))
  14. {
  15. return strtotime($timevalue);
  16. }
  17. else
  18. {
  19. return intval(($timevalue- 25569) * 3600 * 24) - 8*3600 + 60;
  20. }
  21. }
  22. # 上传卡密
  23. public function uploadCard($data)
  24. {
  25. if ($data['channel_id'] && $data['goods'] && $data['file']) {
  26. $goods = explode(',', $data['goods']);
  27. $file = Dever::load('view', 'upload')->local($data['file']);
  28. $excel = Dever::load('import', 'excel')->act($file);
  29. if ($excel) {
  30. foreach ($excel as $k => $v) {
  31. if ($k > 1 && $v['A']) {
  32. $update = array();
  33. $update['number'] = $v['A'];
  34. $info = Dever::db('card', 'channel')->find($update);
  35. if ($info) {
  36. Dever::error('卡号:' . $update['number'] . '已存在');
  37. }
  38. $update['pwd'] = $v['B'];
  39. $value = $v['C'];
  40. $end = $v['D'];
  41. if (!strstr($end, '-')) {
  42. $end = $this->formatTime($end);
  43. $end = date('Y-m-d', $end);
  44. }
  45. $sku = Dever::db('info_sku', 'goods')->find(array('info_id' => $goods[1], 'value' => $value));
  46. if (!$sku) {
  47. continue;
  48. }
  49. $update['seller_id'] = $data['seller_id'];
  50. $update['goods_id'] = $goods[1];
  51. $update['sku_id'] = $sku['id'];
  52. $update['channel_id'] = $data['channel_id'];
  53. $update['goods'] = $data['goods'];
  54. $update['end'] = $end;
  55. Dever::db('card', 'channel')->insert($update);
  56. }
  57. }
  58. }
  59. } else {
  60. Dever::error('请上传文件或者选择商品');
  61. }
  62. return $data;
  63. }
  64. # 展示卡密统计
  65. public function showCardStat($where)
  66. {
  67. $db = Dever::db('card', 'channel');
  68. $total = $db->count($where);
  69. $where['use_status'] = 2;
  70. $yi = $db->count($where);
  71. $where['use_status'] = 1;
  72. $wei = $db->count($where);
  73. return array
  74. (
  75. array
  76. (
  77. # 一共24
  78. 'span' => '8',
  79. 'name' => '总数量',
  80. 'value' => $total,
  81. ),
  82. array
  83. (
  84. 'span' => '8',
  85. 'name' => '已用数量',
  86. 'value' => $yi,
  87. ),
  88. array
  89. (
  90. 'span' => '8',
  91. 'name' => '剩余可用数量',
  92. 'value' => $wei,
  93. ),
  94. );
  95. }
  96. }