123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899 |
- <?php namespace Channel\Lib;
- use Dever;
- use Manage\Lib\Auth;
- class Manage extends Auth
- {
- # 获取渠道列表
- public function getInfo()
- {
- return Dever::db('info', 'channel')->select(array('status' => 1));
- }
- public function formatTime($timevalue)
- {
- if(strpos($timevalue,"-"))
- {
- return strtotime($timevalue);
- }
- else
- {
- return intval(($timevalue- 25569) * 3600 * 24) - 8*3600 + 60;
- }
- }
- # 上传卡密
- public function uploadCard($data)
- {
- if ($data['channel_id'] && $data['goods'] && $data['file']) {
- $goods = explode(',', $data['goods']);
- $file = Dever::load('view', 'upload')->local($data['file']);
- $excel = Dever::load('import', 'excel')->act($file);
- if ($excel) {
- foreach ($excel as $k => $v) {
- if ($k > 1 && $v['A']) {
- $update = array();
- $update['number'] = $v['A'];
- $info = Dever::db('card', 'channel')->find($update);
- if ($info) {
- Dever::error('卡号:' . $update['number'] . '已存在');
- }
- $update['pwd'] = $v['B'];
- $value = $v['C'];
- $end = $v['D'];
- if (!strstr($end, '-')) {
- $end = $this->formatTime($end);
- $end = date('Y-m-d', $end);
- }
- $sku = Dever::db('info_sku', 'goods')->find(array('info_id' => $goods[1], 'value' => $value));
- if (!$sku) {
- continue;
- }
- $update['seller_id'] = $data['seller_id'];
- $update['goods_id'] = $goods[1];
- $update['sku_id'] = $sku['id'];
- $update['channel_id'] = $data['channel_id'];
- $update['goods'] = $data['goods'];
- $update['end'] = $end;
- Dever::db('card', 'channel')->insert($update);
- }
- }
- }
- } else {
- Dever::error('请上传文件或者选择商品');
- }
- return $data;
- }
- # 展示卡密统计
- public function showCardStat($where)
- {
- $db = Dever::db('card', 'channel');
- $total = $db->count($where);
- $where['use_status'] = 2;
- $yi = $db->count($where);
- $where['use_status'] = 1;
- $wei = $db->count($where);
- return array
- (
- array
- (
- # 一共24
- 'span' => '8',
- 'name' => '总数量',
- 'value' => $total,
- ),
- array
- (
- 'span' => '8',
- 'name' => '已用数量',
- 'value' => $yi,
- ),
- array
- (
- 'span' => '8',
- 'name' => '剩余可用数量',
- 'value' => $wei,
- ),
- );
- }
- }
|