123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308 |
- <?php
- namespace Bill\Lib;
- use Dever;
- class Manage
- {
- public function cashUpdate($id, $name, $data)
- {
- Dever::config('base')->hook = true;
- $mid = Dever::param('mid', $data);
- $cash = Dever::param('cash', $data);
- $desc = Dever::param('desc', $data);
- if ($mid && $cash && $desc) {
- $member = Dever::db('agent/member')->find($mid);
- if ($member && $member['status'] == 2) {
- Dever::load('bill/lib/cash')->up($mid, 10, $cash, $member['role'], $id, $desc, 2);
- $where['where_id'] = $mid;
- $where['cash'] = $cash;
- Dever::db('agent/member')->upCash($where);
- } else {
- Dever::db('bill/push_cash')->update(array('where_id' => $id, 'status' => 2));
- Dever::alert('代理商未审核通过,发放失败');
- }
- }
- }
- public function cashAuditUpdateStart($param, $name, $data)
- {
- $mul_type = Dever::config('base')->mul_type;
- if ($mul_type == 2) {
- $list = Dever::db('bill/cash')->select(array('status' => 1));
- } else {
- $list = explode(',', $param['where_id']);
- }
- }
- public function cashAuditUpdate($id, $name, $data)
- {
- Dever::config('base')->hook = true;
- $audit = Dever::param('audit', $data);
- if ($audit > 1) {
- $mul_type = Dever::config('base')->mul_type;
- if ($mul_type == 2) {
- $list = Dever::db('bill/cash')->select(array('status' => 1));
- } else {
- $list = explode(',', $id);
- }
-
- foreach ($list as $k => $v) {
- if (is_array($v)) {
- $id = $v['id'];
- } else {
- $id = $v;
- $info = Dever::db('bill/cash')->find(array('id' => $id, 'clear' => true));
- }
-
- if ($info['status'] != 1) {
- continue;
- }
- #已审核
- if ($audit == 2) {
- Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
- $info = Dever::db('bill/cash')->find($id);
- if ($info && $info['type'] <= 10) {
- $where['where_id'] = $info['mid'];
- $where['cash'] = $info['cash'];
- Dever::db('agent/member')->upCash($where);
- }elseif ($info && $info['type'] == 11) {
- $tixian = Dever::db('bill/tixian')->find($info['type_id']);
- $where['where_id'] = $tixian['id'];
- $where['status'] = 1;
- $admin = Dever::load('manage/auth.data');
- $where['audit_admin'] = $admin['id'];
- Dever::db('bill/tixian')->update($where);
- }
- } else {
- #作废
- Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
- $info = Dever::db('bill/cash')->find($id);
- if ($info && $info['type'] == 11) {
- $tixian = Dever::db('bill/tixian')->find($info['type_id']);
- $where['where_id'] = $info['mid'];
- $where['cash'] = -1*$tixian['ycash'];
- Dever::db('agent/member')->upCash($where);
- $update['where_id'] = $tixian['id'];
- $update['status'] = 3;
- $admin = Dever::load('manage/auth.data');
- $update['audit_admin'] = $admin['id'];
- Dever::db('bill/tixian')->update($update);
- }
- }
- }
- }
- }
- public function tixianAuditUpdate($id, $name, $data)
- {
- Dever::config('base')->hook = true;
- $audit = Dever::param('audit', $data);
- $desc = Dever::param('audit_desc', $data);
- if ($audit > 1) {
- $mul_type = Dever::config('base')->mul_type;
- if ($mul_type == 2) {
- $list = Dever::db('bill/tixian')->select(array('status' => 1));
- } else {
- $list = explode(',', $id);
- }
-
- foreach ($list as $k => $v) {
- if (is_array($v)) {
- $id = $v['id'];
- } else {
- $id = $v;
- $info = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
- }
-
- if ($info['status'] != 1) {
- continue;
- }
- $info = Dever::db('bill/cash')->find(array('type' => 11, 'type_id' => $id));
- if (!$info) {
- continue;
- }
- if ($audit == 2) {
- $admin = Dever::load('manage/auth.data');
- $where['audit_admin'] = $admin['id'];
- Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 2, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
- if ($info && $info['status'] == 1) {
- Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
- }
- # 通知短信
- if (Dever::project('sms')) {
- $member = Dever::db('agent/member')->find($info['mid']);
- Dever::load('sms/api')->send('daili_tixian_yes', $member['mobile'], array('name' => $member['name']));
- }
- } else {
- $admin = Dever::load('manage/auth.data');
- $where['audit_admin'] = $admin['id'];
- Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 3, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
- # 通知短信
- if (Dever::project('sms')) {
- $member = Dever::db('agent/member')->find($info['mid']);
- Dever::load('sms/api')->send('daili_tixian_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
- }
- }
- }
- }
- }
- public function sellUpdate($id, $name, $data)
- {
- Dever::config('base')->hook = true;
- $mid = Dever::param('mid', $data);
- $num = Dever::param('num', $data);
- $desc = Dever::param('desc', $data);
- $type = Dever::param('type', $data);
- if ($mid && $num && $desc) {
- $member = Dever::db('agent/member')->find($mid);
- if ($member && $member['status'] == 2) {
- if ($type == 1) {
- Dever::load('bill/lib/sell.push_one_commit', $mid, $num, $member['role'], $id, $desc);
- } else {
- Dever::load('bill/lib/sell.push_all_commit', $mid, $num, $member['role'], $id, $desc);
- }
- } else {
- Dever::db('bill/push_sell')->update(array('where_id' => $id, 'status' => 2));
- Dever::alert('代理商未审核通过,发放失败');
- }
- }
- }
- # 获取新增业绩
- public function getSellNewNum($num, $month, $mid)
- {
- $where = array('month' => $month, 'mid' => $mid);
- $search = Dever::search_button();
- if ($search) {
- $where['config']['group'] = $search[0];
- $where['config']['col'] = str_replace('|id', '', $search[1]);
- }
- if ($num < 0) {
- $num = 0;
- }
- $new_num = 0;
- $prev = Dever::db('bill/sell_stat')->prev($where);
- if ($prev && $num > 0 && $prev['num'] >= 0) {
- $new_num = $num - $prev['num'];
- }
- return $new_num;
- }
- #提现导出
- public function tixian_out_api(){
- $status = Dever::input('search_option_status');
- $start = Dever::input('search_option_start_cdate');
- $end = Dever::input('search_option_end_cdate');
- $where = array();
- $where['state'] = 1;
- if($start){
- $where['start']=strtotime($start);
- }
- if($end){
- $where['end']=strtotime($end);
- }
- $where['status'] = $status;
- $header = array('提现单号', '姓名', '手机号', '身份证号', '会员角色', '提现金额', '到账金额', '手续费金额', '申请时间', '审核时间', '审核状态','发放状态','审核人', '来源');
- $data = Dever::db('bill/tixian')->getExcelAll($where);
-
- $body = array();
- foreach($data as $k => $v){
- $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
- $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
-
- if($v['status'] == -1){
- $status = '未审核待发放';
- $audit = '待审核';
- }elseif($v['status'] == 1){
- $status = '已审核待发放';
- $audit = '已审核';
- }elseif($v['status'] == 2){
- $status = '已发放';
- $audit = '已审核';
- }else{
- $status = '已作废';
- $audit = '已作废';
- }
- $cdate = date('Y-m-d H:i',$v['cdate']);
- $operdate = date('Y-m-d H:i',$v['operdate']);
- if($v['audit_admin']){
- $admin = Dever::load('manage/admin-find',$v['audit_admin']);
- $username = $admin['username'];
- }else{
- $username = '';
- }
-
- if($v['ycash'] < 0){
- $ycash = $v['ycash'] * (-1);
- }else{
- $ycash = $v['ycash'];
- }
- if($v['cash'] < 0){
- $cash = $v['cash'] * (-1);
- }else{
- $cash = $v['cash'];
- }
- $d = array
- (
- $v['order_num'],
- $member['name'],
- $member['mobile'],
- $member['idcard'],
- $role['name'],
- $ycash,
- $cash,
- $ycash-$cash,
- $cdate,
- $operdate,
- $audit,
- $status,
- $username,
- '',
- );
- $body[] = $d;
- }
- $file = '每日提现';
- Dever::excelExport($body, $header, $file);
- }
- #归店统计导出
- public function out_shop_stat_api(){
- $start = Dever::input('search_option_start_month');
- $end = Dever::input('search_option_end_month');
- $where = array();
- $where['state'] = 1;
- if($start){
- $where['start'] = strtotime($start);
- }
- if($end){
- $where['end'] = strtotime($end);
- }
- $data = Dever::db('bill/shop_stat')->getExcelAll($where);
- $header = array('月份', '店铺名称', '代理商数量', '创V名额外数量', '创V名额内数量', '代理商业绩', '创V名额外业绩', '创V名额内业绩');
- $body = array();
- foreach($data as $k => $v){
- $month = date('Y-m',$v['month'])."\t";
- $shop = Dever::db('shop/info')->find(array('id'=>$v['shop_id']));
- $d = array
- (
- $month,
- $shop['name'],
- $v['dl_num'],
- $v['out_num'],
- $v['nei_num'],
- $v['dl_money'],
- $v['out_money'],
- $v['nei_money'],
- );
- $body[] = $d;
- }
- $file = '归店统计';
- Dever::excelExport($body, $header, $file);
- }
- }
|