<?php

namespace app\NewReedaw\controller\app;

use think\Db;
use think\Cache;

class Vitalcapacity extends Base{
    
    protected $vitalcapacity_db_name = [
        'zhanghao'=>'app_account_number',
        'juese'=>'app_user_data',
        'vitalcapacity'=>'app_card_vitalcapacity_data',
        'biaozhun'=>'pc_vitalcapacity_standard',
        
    ];
    protected $color = ['无效'=>'#FF5656','不及格'=>'#FF5656','及格'=>'#FFAB00','良好'=>'#5AD06D','优秀'=>'#6492F6','牛逼'=>'#3967D6'];
    protected $curve_data_format = ['one_val'=>['第一次','容积/ml','#009DFF'],'two_val'=>['第二次','容积/ml','#009DFF'],'three_val'=>['第三次','容积/ml','#009DFF'],'average_val'=>['平均','容积/ml','#009DFF']];
    protected $pagesize = 15;
    // 加 bcadd(,,20)
    // 减 bcsub(,,20)
    // 乘 bcmul(,,20)
    // 除 bcdiv(,,20)
    // 测试token=>'caadd1be045a65f30b92aa805f1de54a'
    
    ################################################################接口################################################################
    ################################################################接口################################################################
    ################################################################接口################################################################

    // 设备记录
    public function device_record(){
        try {  
            $data = input('post.');
            if(!array_key_exists('aud_id', $data) || !array_key_exists('one', $data) || !array_key_exists('two', $data) || !array_key_exists('three', $data) || !array_key_exists('token', $data)){
                return $this->msg(10001);
            }
            unset($data['token']);
            if(!$this->verify_data_is_ok($data['aud_id'],'intnum')){
                return $this->msg(10005,'aud_id type error');
            }
            if(!$this->verify_data_is_ok($data['one'],'intnum')){
                return $this->msg(10005,'one type error');
            }
            if(!$this->verify_data_is_ok($data['two'],'intnum')){
                return $this->msg(10005,'two type error');
            }
            if(!$this->verify_data_is_ok($data['three'],'intnum')){
                return $this->msg(10005,'three type error');
            }
            $data['time'] = date('Y-m-d H:i:s');
            return $this->manual_record_action($data,'by_device');
        } catch (\Exception $e) {  
            // 捕获异常  
            $logContent["flie"] = $e->getFile();  
            $logContent["line"] = $e->getLine();  
            $logContent['all_content'] = "异常信息：\n";  
            $logContent['all_content'] .= "消息: " . $e->getMessage() . "\n";  
            $logContent['all_content'] .= "代码: " . $e->getCode() . "\n";  
            $logContent['all_content'] .= "文件: " . $e->getFile() . "\n";  
            $logContent['all_content'] .= "行号: " . $e->getLine() . "\n";  
            $logContent['all_content'] .= "跟踪信息:\n" . $e->getTraceAsString() . "\n"; 
            $this->record_api_log($data, $logContent, null); 
            return $this->msg(99999);
        }
    }
    // 数据报告
    public function data_report(){
        $data = input('post.');
        try {  
            
            if(!array_key_exists('aud_id', $data) || !array_key_exists('token', $data)){
                return $this->msg(10001);
            }
            unset($data['token']);
            if(!$this->verify_data_is_ok($data['aud_id'],'intnum')){
                return $this->msg(10005,'aud_id type error');
            }
            return $this->data_report_action($data);
        } catch (\Exception $e) {  
            // 捕获异常  
            $logContent["flie"] = $e->getFile();  
            $logContent["line"] = $e->getLine();  
            $logContent['all_content'] = "异常信息：\n";  
            $logContent['all_content'] .= "消息: " . $e->getMessage() . "\n";  
            $logContent['all_content'] .= "代码: " . $e->getCode() . "\n";  
            $logContent['all_content'] .= "文件: " . $e->getFile() . "\n";  
            $logContent['all_content'] .= "行号: " . $e->getLine() . "\n";  
            $logContent['all_content'] .= "跟踪信息:\n" . $e->getTraceAsString() . "\n"; 
            $this->record_api_log($data, $logContent, null); 
            return $this->msg(99999);
        }
    }

    

    ################################################################action################################################################
    ################################################################action################################################################
    public function manual_record_action($data,$type){
        $temporary_arr['aud_id'] = $data['aud_id'];
        $temporary_arr['record_time'] = $data['time'];
        $temporary_arr['one'] = $data['one'];
        $temporary_arr['two'] = $data['two'];
        $temporary_arr['three'] = $data['three'];
        $temporary_arr['average'] = bcdiv(bcadd(bcadd($data['one'],$data['two'],2),$data['three'],2),3,2);
        $temporary_arr['create_time'] = date('Y-m-d H:i:s');
        $temporary_arr['one_val'] = $data['one'];
        $temporary_arr['two_val'] = $data['two'];
        $temporary_arr['three_val'] = $data['three'];
        $temporary_arr['average_val'] = $temporary_arr['average'];
        $temporary_arr['flow_val'] = array_key_exists('flow', $data)?$data['flow']:'0.00';//流速
        $temporary_arr['record_type'] = $type;
        // die;
        // 处理记录时间
        
        $user_msg = Db::name($this->vitalcapacity_db_name['juese'])->where(['id'=>$data['aud_id']])->field('id,grade,gender,birthday')->find();
        // die;
        if($user_msg){
            // 根据性别&年级&年龄查规则
            if($user_msg['grade'] == 'nothing'){
                // 计算年龄判断是属于哪个年级
                $user_age = $this->calculate_age($user_msg['birthday']);
                if($user_age <= 7){
                    $user_msg['grade'] = 'grade_s_1';
                }else if($user_age == 8){
                    $user_msg['grade'] = 'grade_s_2';
                }else if($user_age == 9){
                    $user_msg['grade'] = 'grade_s_3';
                }else if($user_age == 10){
                    $user_msg['grade'] = 'grade_s_4';
                }else if($user_age == 11){
                    $user_msg['grade'] = 'grade_s_5';
                }else if($user_age == 12){
                    $user_msg['grade'] = 'grade_s_6';
                }else if($user_age == 13){
                    $user_msg['grade'] = 'grade_m_1';
                }else if($user_age == 14){
                    $user_msg['grade'] = 'grade_m_2';
                }else if($user_age == 15){
                    $user_msg['grade'] = 'grade_m_3';
                }else if($user_age == 16){
                    $user_msg['grade'] = 'grade_h_1';
                }else if($user_age == 17){
                    $user_msg['grade'] = 'grade_h_2';
                }else if($user_age == 18){
                    $user_msg['grade'] = 'grade_h_3';
                }else if($user_age == 19 || $user_age == 20){
                    $user_msg['grade'] = 'grade_u_12';
                }else if($user_age >= 21){
                    $user_msg['grade'] = 'grade_u_34';
                }
            }
            $sql_str = "sex = ".$user_msg['gender']." and ".$user_msg['grade']." <= ".$temporary_arr['average_val']; 
            $user_achievement = Db::name($this->vitalcapacity_db_name['biaozhun'])->where($sql_str)->order($user_msg['grade'] .' desc')->field('level,score,'.$user_msg['grade'])->limit(1)->cache(86400)->select();
            if(count($user_achievement)<=0){
                $user_achievement[0] = ['level'=>'无效','score'=>'0'];
            }
            $temporary_arr['score'] = $user_achievement[0]['score'].','.$user_achievement[0]['level'].','.$this->color[$user_achievement[0]['level']];
            $temporary_arr['score_val'] = $user_achievement[0]['score'];
            
        }else{
            return $this->msg(10004,'未找到有效数据');
        }
        $standard_data = $this->get_vitalcapacity_data($data['aud_id']);
        $temporary_arr['standard_data'] = json_encode($standard_data);
        $result = Db::table($this->vitalcapacity_db_name['vitalcapacity'])->insert($temporary_arr);
        
        if($result){
            $time = $result[0]['record_time'];
            $time = strtotime($time);  
            $time = date('Y年m月d日 H:i:s', $time);  
            return $this->msg([
                'average'=>$temporary_arr['average'].'ml',
                'level'=>$user_achievement[0]['level'],
                'time'=>$time,
                'flow_val'=>$temporary_arr['flow_val'],
                'list'=>$standard_data,
                'offset'=>$this->vitalcapacity_standard_interval($temporary_arr['average'],$standard_data)
            ]);
        }else{
            return $this->msg(10002);
        }
    }
    public function data_report_action($data){
        $result = Db::table($this->vitalcapacity_db_name['vitalcapacity'])->where(['aud_id'=>$data['aud_id']])->order('record_time desc')->field('record_time,score,average,flow_val,standard_data')->limit(1)->select();
        
        if(count($result) <= 0){
            // return $this->msg(10004);
            return $this->msg([
                'average'=>'',
                'level'=>'',
                'time'=>'',
                'flow_val'=>'',
                'list'=>'',
                'offset'=>''
            ]);
            
        }else{
            
            $time = $result[0]['record_time'];
            $time = strtotime($time);  
            $time = date('Y年m月d日 H:i:s', $time);  
            $o_l = explode(',',$result[0]['score']);
            // $standard_data = $this->get_vitalcapacity_data($data['aud_id']);
            $standard_data = json_decode($result[0]['standard_data'],true);
            
            return $this->msg([
                'average'=>$result[0]['average'].'ml',
                'level'=>$o_l[1],
                'time'=>$time,
                'flow_val'=>$result[0]['flow_val'] == '.00'?'0.00':$result[0]['flow_val'],
                'list'=>$standard_data,
                'offset'=>$this->vitalcapacity_standard_interval($result[0]['average'],$standard_data)
            ]);
        }
    }

    ################################################################内部调用################################################################
    ################################################################内部调用################################################################
    // 肺活量判断区间
    public function vitalcapacity_standard_interval($val,$data){
        // 缓存一周
        $result = '';
        if(!$data || count($data) <= 0){
            return $result;
        }
        $temporary_qj = $data;
        $max = 0;
        $min = 0;
        $num = 0;
        foreach ($temporary_qj as $key => $value) {
            if($val >= $value['min_val'] && $val <= $value['max_val']){
                $max = $value['max_val'];
                $min = $value['min_val'];
                $num = $key;
                break;
            }
        }
        
        $num = count($temporary_qj)-1-$num;

        if($max == 0){
            if($val >= $temporary_qj[0]['max_val']){
                $result = 100;
            }
        }else{
            $temporary_num = bcmul(bcdiv(bcsub($val,$min,20),bcsub($max,$min,20),2),bcdiv(100,count($temporary_qj),2),2);
            $result = bcadd(bcmul(bcdiv(100,count($temporary_qj),2),$num,2),$temporary_num,2);
        }
        return $result;
    }
    // 肺活量判断区间(根据得分)
    public function vitalcapacity_standard_interval2($val,$data){
        // 缓存一周
        $result = '';
        if(count($data) <= 0){
            return $result;
        }
        $temporary_qj = $data;
        $max = 0;
        $min = 0;
        $num = 0;
        foreach ($temporary_qj as $key => $value) {
            if($val >= $value['min_val'] && $val <= $value['max_val']){
                $max = $value['max_val'];
                $min = $value['min_val'];
                $num = $key;
                break;
            }
        }
        // 计算每份占比
        $share_value = bcdiv($temporary_qj[0]['max_val'],count($temporary_qj),1);
        // 计算在这一段中占多少
        $result = bcsub($val,$min,1);
        $result = bcdiv($result,bcsub($max,$min,1),1);
        $num = count($temporary_qj)-1-$num;
        $num = bcmul($num,$share_value,1);
        $result = bcadd($num,$result,1);
        // $num = count($temporary_qj)-1-$num;
        // $temporary_num = bcmul(bcdiv(bcsub($val,$min,20),bcsub($max,$min,20),2),bcdiv(100,count($temporary_qj),2),2);
        // $result = bcadd(bcmul(bcdiv(100,count($temporary_qj),2),$num,2),$temporary_num,2);
        
        return $result;
    }
    

}