暗能星系

zhangfanglin

insert into ai_model(author,name,uuid,description,size,category,tag,path,user_id,status,is_public,extend_json,created_at,updated_at)
values
('ali','qwen7b','ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8','qwen7b','4831838208','["类别1"]','["标签1"]','/cephfs_data/genostack_v3/genostack_php/ai_model/raw_data/ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8/qwen7b.gguf',1,'1',true,'{"blob":"sha256:2091ee8c8d8f","name":"qwen:7b"}','2024-07-02 18:15:46','2024-07-02 18:15:46'),
('ali','qwen2_72b','ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8','qwen2_72b','44023414784','["类别1"]','["标签1"]','/cephfs_data/genostack_v3/genostack_php/ai_model/raw_data/ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8/qwen2_72b.gguf',1,'1',true,'{"blob":"sha256:14066dfa503f","name":"qwen2:72b"}','2024-07-02 18:15:46','2024-07-02 18:15:46'),
('llama','llama:70b','ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8','qwen1_5-0_5b','41875931136','["类别1"]','["标签1"]','/cephfs_data/genostack_v3/genostack_php/ai_model/raw_data/ec/327/b04-fc62-a200-c5a9-e7a2c6e027f8/llama3_70b.gguf',1,'1',true,'{"blob":"sha256:786f3184aec0","name":"llama3:70b"}','2024-07-02 18:15:46','2024-07-02 18:15:46');

zhanglu

psql --dbname=qiime -c "COPY (select id,name,time_consuming,created_at,updated_at from data_analysis where status='Succeeded' order by id desc) TO STDOUT csv header" >/var/lib/postgresql/data/t.csv

zhanglu

t.csv

zhanglu

zhangfanglin

update permissions set icon='data_set' where name='dataset';
update permissions set icon='group' where name='group_detail';
update permissions set icon='menu_icon' where name='Menu';
update permissions set icon='group' where name='group_manger';
update permissions set icon='user_admin' where name='userManger';
update permissions set icon='role_management' where name='RolePermission';
update permissions set icon='dictionary_admin' where name='dictionary_manger';
update permissions set icon='app_list' where name='ToolIntro';
update permissions set icon='data_set' where name='DataTraining';
update permissions set icon='task_list' where name='dataAnalysiall_list';
update permissions set icon='report_list' where name='report_list';
update permissions set icon='software' where name='docker_warehouse';
update permissions set icon='software' where name='process_warehouse';
update permissions set icon='public_documents' where name='publicDataFile';
update permissions set icon='note' where name='commonNotebook';
update permissions set icon='language_model' where name='LanguageModel';
update permissions set icon='home_page' where name='home_config';
update permissions set icon='materialsetup' where name='activity';
update permissions set icon='license' where name='license_admin';
update permissions set icon='work_order' where name='Work_Order_List';
update permissions set icon='system_admin' where name='SystemSettings';
update permissions set icon='data_processing' where name='ProjectList';
update permissions set icon='report_config' where name='report_config';
update permissions set icon='file_datas' where name='commonFile';
update permissions set icon='knowledge_base' where name='LibraryKnowledge';
update permissions set icon='cloud_classroom' where name='cloudAcademyManage_plate';
update permissions set icon='literature' where name='literature_index';
update permissions set icon='department' where name='department_manger';

zhanglu

psql --dbname=qiime --username=postgres -c "COPY(select data_analysis.id,data_analysis.name,data_analysis.founder,data_analysis.process_name,data_analysis.time_consuming,projects.name as p_name, process_warehouse.name as process_name,flow_version,data_analysis.created_at from data_analysis left join projects on projects.id=data_analysis.project_id left join process_warehouse on process_warehouse.id=data_analysis.process_warehouse_id where data_analysis.status='Succeeded' order by data_analysis.id desc)TO STDOUT with csv header " > tt.csv

;tt.csv

zhangfanglin

public function get_task_output(Request $request,$project_id,$id){
        $da=Data_analysi::find($id);
        if($da->workflow_root && is_dir($da->workflow_root)){
            if($request->find_name){
                if($request->dir   && strpos($request->dir, $da->workflow_root)!== false){
                    $s=shell_exec("find $request->dir -name *$request->find_name*");
                    $find_list=explode("\n",$s);
                    array_pop($find_list);
                    return $find_list;
                }else{
                    $s=shell_exec("find $da->workflow_root -name *$request->find_name*");
                    $find_list=explode("\n",$s);
                    array_pop($find_list);
                    return $find_list;
                }
            }
            $dir=$da->workflow_root;
            $data=[];
            $dir_info=[];
            $is_file=false;
            \Log::info('文件夹列表-开始'.'-----'.$request->dir);
            if($request->dir && is_file($request->dir) && strpos($request->dir,$da->workflow_root)!== false){
                $is_file=true;
                $dir=$request->dir;
                $dir_info['file_info']["time"]=date("Y-m-d H:i:s",filectime($request->dir));
                $dir_info['file_info']["filesize"]=k_m(filesize($request->dir));
            }else if($request->dir && strpos($request->dir, $da->workflow_root)!== false){
                $dir=$request->dir;
                $data=catalogue_intro($dir);
            }else{
                $data=catalogue_intro($dir);
            }  
            \Log::info('文件夹列表-完成'.'-----'.$request->dir);
            if(!isset($dir_info['file_info'])){
                \Log::info('获取文件创建时间-开始'.'-----'.$request->dir);
                $dir_info['file_info']["time"]=date("Y-m-d H:i:s",filectime($dir));
                \Log::info('获取文件创建时间-完成'.'-----'.$request->dir);
                $dir_info['file_info']["filesize"]=k_m(dirSize($dir,true));
                \Log::info('文件夹dirSize-完成'.'-----'.$request->dir);
                $dir_info['file_info']["file_num"]=count($data);
                
            } 
            return [
                'dir_info'=>$dir_info,
                "is_file"=>$is_file,
                "dir"=>$dir,
                "data"=>$data
            ];
        }else{
            return [];
        }
    }

zhangfanglin

    public function gettree(Request $request){
        $path=$request->path?$request->path:env('PUBLIC_FILE_DATA');
        if($request->find_name){
            $datas=public_data::where('file_path','ilike',"%$request->find_name%")
            ->orWhere('intro','ilike',"%$request->find_name%")
            ->orWhere('db_category','ilike',"%$request->find_name%")
            ->orWhere('db_name','ilike',"%$request->find_name%")
            ->orWhere('tag','ilike',"%$request->find_name%")
            ->orWhere('expand_json','ilike',"%$request->find_name%")
            ->orWhere('remark','ilike',"%$request->find_name%")
            ->get();
            $find_list=[];
            foreach($datas as $k =>$v){
                $find_list[]=$v->file_path;
            }
            if($path  && strpos($path,env('PUBLIC_FILE_DATA'))!== false){

                $s=shell_exec("find $path -name *$request->find_name*");
                $find_list=array_merge($find_list,explode("\n",$s));
                array_pop($find_list);
                return array_values(array_unique($find_list));
            }else{
                $s=shell_exec("find ".env('PUBLIC_FILE_DATA')." -name *$request->find_name*");
                $find_list=array_merge($find_list,explode("\n",$s));
                array_pop($find_list);
                return array_values(array_unique($find_list));
            }
        }
        $dir_info=[];
        $is_file=false;
        \Log::info('文件夹列表-开始'.'-----'.$path);
        if($path && is_file($path) && strpos($path,env('PUBLIC_FILE_DATA'))!== false){
            $data=[];
            $pathinfo=pathinfo($path);
            $dir_info['metadata']=public_data::where('file_path',$pathinfo['dirname'])->where('name',$pathinfo['basename'])->with('user')->first();
            if($dir_info['metadata']){
                $dir_info['metadata']->expand_json=json_decode($dir_info['metadata']->expand_json,true);
            }
            $is_file=true;
            $dir_info['file_info']["time"]=date("Y-m-d H:i:s",filectime($path));
            $dir_info['file_info']["filesize"]=k_m(filesize($path));
        }else if($path && strpos($path,env('PUBLIC_FILE_DATA'))!== false){
            $data=catalogue_intro($path);
        }else{
            $data=catalogue_intro(env('PUBLIC_FILE_DATA'));
        }
        \Log::info('文件夹列表-完成'.'-----'.$path);
        \Log::info('数据库处理-开始'.'-----'.$path);
        foreach($data as $k =>$vs){
            $data[$k]['dir_info']=public_data::where('file_path',$vs['dir'])->with('user')->whereNull('name')->first();
            if($data[$k]['dir_info']){
                $data[$k]['dir_info']->expand_json=json_decode($data[$k]['dir_info']->expand_json,true);
            }
        }
        \Log::info('数据库处理-完成'.'-----'.$path);
        if(!isset($dir_info['file_info'])){
            $dir_info['metadata']=public_data::where('file_path',$path)->with('user')->whereNull('name')->first();
            if($dir_info['metadata']){
                $dir_info['metadata']->expand_json=json_decode($dir_info['metadata']->expand_json,true);
            }
            \Log::info('获取文件创建时间-开始'.'-----'.$path);
            $dir_info['file_info']["time"]=date("Y-m-d H:i:s",filectime($path));
            \Log::info('获取文件创建时间-完成'.'-----'.$path);
            \Log::info('文件大小读取-开始'.'-----'.$path);
            $dir_info['file_info']["filesize"]=k_m(dirSize($path,true));
            \Log::info('文件大小读取-完成'.'-----'.$path);
            $dir_info['file_info']["file_num"]=count($data);
        }
        $ebi_err_list=public_data::where('file_path',$path)->whereNotIn('status',['success','init'])->count();
        return [
            'ebi_err_list'=>$ebi_err_list,
            'dir_info'=>$dir_info,
            "dir"=>$path,
            'is_file'=>$is_file,
            "data"=>$data
        ];
    }

zhangfanglin

阿里-金智CRM

JZ_URL=http://nboa.jzsoft.cn:777
JZ_APPID=91307
JZ_SECRETID=MIOAmSeu3m8c
JZ_SECRETKEY=d724a2f9-c5f8-4612-b1c6-db8734c6180a

zhangfanglin

JZ_URL=https://crmapi.jzsoft.cn
JZ_APPID=509331
JZ_SECRETID=cVaQjWPqn1XQ
JZ_SECRETKEY=cc0b2385-5358-4f95-91d6-80341e82d5d3

zhanglu

/cephfs_data/genostack_v3/genostack_php/source_v3/reportHtml/2024_09/a9cc132fd641478e84caacd66ab8502e.zip

tmp

阿里-金智CRM