function get_scws_words($disease_article) { $keywords_scws = array(); if (empty($keywords_scws) && !empty($disease_article->keywords)) { $keywords_scws = \librarys\helpers\utils\SearchHelper::scws($disease_article->keywords); } if (empty($keywords_scws) && !empty($disease_article->title)) { $keywords_scws = \librarys\helpers\utils\SearchHelper::scws($disease_article->title); } return $keywords_scws; }
/** * 分诊 * @param type $askinfo 问答的信息 */ public function triage($askinfo) { $db_v2sns = self::getDB(); $db_jbv2 = \Yii::$app->db_jbv2; $wd_keshi_ret_default = array('class_level1' => '15', 'class_level2' => '0', 'class_level3' => '0'); $content = $askinfo['content']; $explain_result = SearchHelper::scws($content); $callback = array($this, 'filter'); //获取过滤数据 $explain_result = array_filter($explain_result, $callback); // print_r($explain_result);exit; //如果无法从用户输入的内容里分出有意义的词,返回默认科室 if (!isset($explain_result[0])) { return $wd_keshi_ret_default; } $all = array(); foreach ($explain_result as $k => $v) { $all[$v['attr']][] = $v; } $wd_keshi_ret['class_level3'] = '0'; //默认三级疾病为0 // //Ⅰ //如果有疾病词 if (isset($all['XB'][0])) { //第一个病的词的名称 $disease_name = $all['XB'][0]['word']; //通过疾病名查疾病id $disease_sql = "select id from 9939_disease where name='{$disease_name}'"; $disease_ret = $db_jbv2->createCommand($disease_sql)->queryOne(); $disease_id = $disease_ret['id']; //9725 //先直接查疾病表是否有该疾病 //如果有直接返回查询结果 //如果没有,通过从症状表查 //通过查wd_disease表得到disease_id $disease_name_sql = "select id,name from 9939_disease where id={$disease_id}"; $disease_name_ret = $db_jbv2->createCommand($disease_name_sql)->queryOne(); $disease_name = $disease_name_ret['name']; $class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'"; $class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne(); if (isset($class_level3['id'])) { $wd_keshi_ret = $class_level3; $wd_keshi_ret['class_level3'] = $class_level3['id']; unset($wd_keshi_ret['id']); return $wd_keshi_ret; } else { //通过疾病id查科室 $disease_condition = 'disease' . $disease_id; $department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id"; $department_ret = $db_jbv2->createCommand($department_sql)->queryOne(); $department_name = $department_ret['name']; //通过科室名称进入wd_keshi查询最终的 $wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'"; $wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne(); //如果查不到数据放到默认科室里 if (!isset($wd_keshi_ret['class_level1'])) { $wd_keshi_ret = $wd_keshi_ret_default; } else { if (!$wd_keshi_ret['class_level3']) { $class_level3_sql = "select id from wd_disease where id='{$wd_keshi_ret['class_level3']}'"; $class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne(); } } return $wd_keshi_ret; } } //Ⅱ //如果没有疾病词,症状词,只有部位词 if (!isset($all['XZ'][0]) && isset($all['XS'][0])) { //第一个部位的词的名称 $condition_part_name = $all['XS'][0]['word']; //通过部位名查部位id $condition_part_sql = "select id from 9939_part where name='{$condition_part_name}'"; $condition_part_ret = $db_jbv2->createCommand($condition_part_sql)->queryOne(); $condition_part_id = $condition_part_ret['id']; //39 //通过部位查找所有的疾病 $part_disease_sql = "SELECT unique_key FROM 9939_part_rel_merge WHERE source_flag=1 AND partid={$condition_part_id}"; $part_disease_ret = $db_jbv2->createCommand($part_disease_sql)->queryOne(); $disease_id = str_replace('disease', '', $part_disease_ret['unique_key']); //7211 //先直接查疾病表是否有该疾病 //如果有直接返回查询结果 //如果没有,通过从症状表查 //通过查wd_disease表得到disease_id $disease_name_sql = "select id,name from 9939_disease where id={$disease_id}"; $disease_name_ret = $db_jbv2->createCommand($disease_name_sql)->queryOne(); $disease_name = $disease_name_ret['name']; $class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'"; $class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne(); if (isset($class_level3['id'])) { $wd_keshi_ret = $class_level3; $wd_keshi_ret['class_level3'] = $class_level3['id']; unset($wd_keshi_ret['id']); return $wd_keshi_ret; } else { //通过疾病id查科室 $disease_condition = 'disease' . $disease_id; $department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id"; $department_ret = $db_jbv2->createCommand($department_sql)->queryOne(); $department_name = $department_ret['name']; //通过科室名称进入wd_keshi查询最终的 $wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'"; $wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne(); //如果查不到数据放到默认科室里 if (!isset($wd_keshi_ret['class_level1'])) { $wd_keshi_ret = $wd_keshi_ret_default; } return $wd_keshi_ret; } } //Ⅲ //如果没有疾病词,部位词,只有症状词 if (!isset($all['XS'][0]) && isset($all['XZ'][0])) { //症状的词的名称 $symtpom_name = $all['XZ'][0]['word']; //通过症状名查症状id $symtpom_sql = "select id from 9939_symptom where name='{$symtpom_name}'"; $symtpom_ret = $db_v2jb->createCommand($symtpom_sql)->queryOne(); $symtpom_id = $symtpom_ret['id']; //6521 //通过症状id查关联疾病,取第一个病 // $rel_disease_sql = "SELECT diseaseid FROM 9939_disease_symptom_rel WHERE symptomid ={$symtpom_id}"; $rel_disease_sql = "SELECT 9939_disease.id,9939_disease.`name`,9939_disease_symptom_rel.diseaseid FROM 9939_disease LEFT JOIN 9939_disease_symptom_rel ON 9939_disease_symptom_rel.diseaseid=9939_disease.id WHERE symptomid = {$symtpom_id}"; $rel_disease_ret = $db_v2jb->createCommand($rel_disease_sql)->queryOne(); //获取所有症状关联的疾病id $rel_disease_id = $rel_disease_ret['diseaseid']; //取第一个病 $rel_disease_name = $rel_disease_ret['name']; //取第一个病 //先直接查疾病表是否有该疾病 //如果有直接返回查询结果 //如果没有,通过从症状表查 //通过查wd_disease表得到disease_id $class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$rel_disease_name}'"; $class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne(); if (isset($class_level3['id'])) { $wd_keshi_ret = $class_level3; $wd_keshi_ret['class_level3'] = $class_level3['id']; unset($wd_keshi_ret['id']); return $wd_keshi_ret; } else { //通过疾病id查科室 $disease_condition = 'disease' . $rel_disease_id; $department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id"; $department_ret = $db_v2jb->createCommand($department_sql)->queryOne(); $department_name = $department_ret['name']; //通过科室名称进入wd_keshi查询最终的 $wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'"; $wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne(); //如果查不到数据放到默认科室里 if (!isset($wd_keshi_ret['class_level1'])) { $wd_keshi_ret = $wd_keshi_ret_default; } return $wd_keshi_ret; } } //Ⅳ //如果没有疾病词,有症状词和部位词 if (isset($all['XZ'][0]) && isset($all['XS'][0])) { //**************1、根据症状取出所有的疾病************** foreach ($all['XZ'] as $k => $v) { //症状的词的名称 $symtpom_name = $v['word']; //通过症状名查症状id $symtpom_sql = "select id from 9939_symptom where name='{$symtpom_name}'"; $symtpom_ret = $db_v2jb->createCommand($symtpom_sql)->queryOne(); $symtpom_id = $symtpom_ret['id']; //6521 //通过症状id查关联疾病,取第一个病 $rel_disease_sql = "SELECT diseaseid FROM 9939_disease_symptom_rel WHERE symptomid ={$symtpom_id}"; $rel_disease_ret = $db_v2jb->createCommand($rel_disease_sql)->queryAll(); //获取所有症状关联的疾病id if (isset($rel_disease_ret[0])) { break; } } foreach ($rel_disease_ret as $k => $v) { $rel_disease_id_arr[] = $v['diseaseid']; } //**************2、根据部位取出所有的疾病************** //第一个部位的名称 $condition_part_name = $all['XS'][0]['word']; //通过部位名查部位id $condition_part_sql = "select id from 9939_part where name='{$condition_part_name}'"; $condition_part_ret = $db_v2jb->createCommand($condition_part_sql)->queryOne(); //3、如果根据部位查不到疾病,设置疾病id为根据症状查出来的第一个疾病 if (!$condition_part_ret) { $last_disease_id = $rel_disease_id_arr[0]; } else { $condition_part_id = $condition_part_ret['id']; //67 //3.1、通过部位查找所有的疾病 $part_disease_sql = "SELECT unique_key FROM 9939_part_rel_merge WHERE source_flag=1 AND partid={$condition_part_id}"; $part_disease_ret = $db_v2jb->createCommand($part_disease_sql)->queryAll(); foreach ($part_disease_ret as $k => $v) { $part_disease_id_arr[] = str_replace('disease', '', $v['unique_key']); } //**************3.2、取二者的交集的第一个疾病作为最终疾病************** $last_disease_id_arr = array_intersect($rel_disease_id_arr, $part_disease_id_arr); //如果没有交集时: if (empty($last_disease_id_arr)) { if (!empty($rel_disease_id_arr)) { $last_disease_id_arr[0] = $rel_disease_id_arr[0]; } else { if (!empty($part_disease_id_arr)) { $last_disease_id_arr[0] = $part_disease_id_arr[0]; } } } sort($last_disease_id_arr); $last_disease_id = $last_disease_id_arr[0]; } //先直接查疾病表是否有该疾病 //如果有直接返回查询结果 //如果没有,通过从症状表查 //通过查wd_disease表得到disease_id $disease_name_sql = "select id,name from 9939_disease where id={$last_disease_id}"; $disease_name_ret = $db_v2jb->createCommand($disease_name_sql)->queryOne(); $disease_name = $disease_name_ret['name']; $class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'"; $class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne(); if (isset($class_level3['id'])) { $wd_keshi_ret = $class_level3; $wd_keshi_ret['class_level3'] = $class_level3['id']; unset($wd_keshi_ret['id']); return $wd_keshi_ret; } else { //通过疾病id查科室 $disease_condition = 'disease' . $last_disease_id; $department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id"; $department_ret = $db_v2jb->createCommand($department_sql)->queryOne(); $department_name = $department_ret['name']; //通过科室名称进入wd_keshi查询最终的 $wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'"; $wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne(); //如果查不到数据放到默认科室里 if (!isset($wd_keshi_ret['class_level1'])) { $wd_keshi_ret = $wd_keshi_ret_default; } return $wd_keshi_ret; } } //未考虑到的情形,直接返回默认科室 return $wd_keshi_ret_default; }