IntelligentRailwayCosting/SourceCode/IntelligentRailwayCosting/app/stores/railway_costing_sqlserver/project_task.py

from sqlalchemy import and_
from datetime import datetime
from typing import Optional

import tools.db_helper as db_helper
from core.dtos import ProjectTaskDto
from core.models import ProjectTaskModel
from core.user_session import UserSession


class ProjectTaskStore:
    def __init__(self):
        # self._database= None
        self._database = 'Iwb_RailwayCosting'
        self._current_user = None

    @property
    def current_user(self):
        if self._current_user is None:
            self._current_user = UserSession.get_current_user()
        return self._current_user
    def get_tasks_paginated(
        self,
        project_id: str,
        item_code: str,
        page: int = 1,
        page_size: int = 10,
        keyword: Optional[str] = None,
        collect_status: Optional[int] = None,
        process_status: Optional[int] = None,
        send_status: Optional[int] = None,
    ) :
        """分页查询任务列表

        Args:
            page: 页码，从1开始
            page_size: 每页数量
            project_id: 项目编号
            item_code: 条目编号
            keyword: 关键字
            collect_status: 采集状态
            process_status: 处理状态
            send_status: 发送状态

        Returns:

        """
        with (db_helper.sqlserver_query_session(self._database) as db_session):
            query = db_session.query(ProjectTaskModel)

            # 构建查询条件
            conditions = [
                ProjectTaskModel.is_del == 0,
                ProjectTaskModel.project_id == project_id,
                # ProjectTaskModel.budget_id == budget_id,
                ProjectTaskModel.item_code.like(f"{item_code}%")
            ]
            if keyword:
                conditions.append(ProjectTaskModel.task_name.like(f'%{keyword}%'))
            if collect_status is not None:
                conditions.append(ProjectTaskModel.collect_status == collect_status)
            if process_status is not None:
                conditions.append(ProjectTaskModel.process_status == process_status)
            if send_status is not None:
                conditions.append(ProjectTaskModel.send_status == send_status)

            query = query.filter(and_(*conditions))

            # 计算总数
            total_count = query.count()

            # 分页
            query = query.order_by(ProjectTaskModel.created_at.desc())\
                .offset((page - 1) * page_size).limit(page_size)

            tasks = query.all()

            return {
                'total': total_count,
                'data': tasks
            }

    def get_tasks_paginated_bk(
        self,
        budget_id: int,
        project_id: str,
        item_code: str,
        page: int = 1,
        page_size: int = 10,
        keyword: Optional[str] = None,
        collect_status: Optional[int] = None,
        process_status: Optional[int] = None,
        send_status: Optional[int] = None,
    ) :
        """分页查询任务列表

        Args:
            page: 页码，从1开始
            page_size: 每页数量
            project_id: 项目编号
            budget_id: 概算序号
            item_code: 条目编号
            keyword: 关键字
            collect_status: 采集状态
            process_status: 处理状态
            send_status: 发送状态

        Returns:

        """
        with db_helper.sqlserver_query_session(self._database) as db_session:
            query = db_session.query(ProjectTaskModel)

            # 构建查询条件
            conditions = [
                ProjectTaskModel.is_del == 0,
                ProjectTaskModel.project_id == project_id,
                ProjectTaskModel.budget_id == budget_id,
                ProjectTaskModel.item_code.like(f"{item_code}%")
            ]
            if keyword:
                conditions.append(ProjectTaskModel.task_name.like(f'%{keyword}%'))
            if collect_status is not None:
                conditions.append(ProjectTaskModel.collect_status == collect_status)
            if process_status is not None:
                conditions.append(ProjectTaskModel.process_status == process_status)
            if send_status is not None:
                conditions.append(ProjectTaskModel.send_status == send_status)

            query = query.filter(and_(*conditions))

            # 计算总数
            total_count = query.count()

            # 分页
            query = query.order_by(ProjectTaskModel.created_at.desc()).offset((page - 1) * page_size).limit(page_size)

            tasks = query.all()

            return {
                'total': total_count,
                'data': tasks
            }

    def get_task(self, task_id: int) -> Optional[ProjectTaskModel]:
        with db_helper.sqlserver_query_session(self._database) as db_session:
            task = db_session.query(ProjectTaskModel).filter(
                and_(
                    ProjectTaskModel.id == task_id,
                    ProjectTaskModel.is_del == 0
                )).first()
            return task

    def get_task_dto(self, task_id: int) -> Optional[ProjectTaskDto]:
        """根据ID查询任务

        Args:
            task_id: 任务ID

        Returns:
            Optional[ProjectTaskDto]
        """
        task_dto = self.get_task(task_id)
        return ProjectTaskDto.from_model(task_dto) if task_dto else None

    def create_task(self, task_dto: ProjectTaskDto) -> ProjectTaskDto:
        """创建任务

        Args:
            task_dto: 任务DTO

        Returns:
            ProjectTaskDto
        """
        task = ProjectTaskModel(
            task_name=task_dto.task_name,
            task_desc=task_dto.task_desc,
            project_id=task_dto.project_id,
            budget_id=task_dto.budget_id,
            item_id=task_dto.item_id,
            item_code=task_dto.item_code,
            file_path=task_dto.file_path,
            created_by=self.current_user.username,
            created_at=datetime.now(),
        )

        with db_helper.sqlserver_session(self._database) as db_session:
            db_session.add(task)
            db_session.flush()
            return ProjectTaskDto.from_model(task)

    def update_task(self, task_dto: ProjectTaskDto) -> Optional[ProjectTaskDto]:
        """更新任务

        Args:
            task_dto: 任务DTO

        Returns:
            Optional[ProjectTaskDto]
        """
        task = self.get_task(task_dto.id)

        if not task:
            return None
        with db_helper.sqlserver_session(self._database) as db_session:
            task.task_name = task_dto.task_name
            task.task_desc = task_dto.task_desc
            # task.project_id = task_dto.project_id
            # task.budget_id = task_dto.budget_id
            # task.item_id = task_dto.item_id
            # task.item_code = task_dto.item_code
            # task.file_path = task_dto.file_path
            task.updated_by=self.current_user.username
            task.updated_at=datetime.now()
            task = db_session.merge(task)
            return ProjectTaskDto.from_model(task)

    def update_task_files(self, task_id: int,files: str):
        task = self.get_task(task_id)
        if not task:
            return None
        with db_helper.sqlserver_session(self._database) as db_session:
            task.file_path = files
            if task.collect_status != 0:
                task.collect_status = 4
            if task.process_status != 0:
                task.process_status = 4
            if task.send_status != 0:
                task.send_status = 4
            task.updated_by=self.current_user.username
            task.updated_at=datetime.now()
            task = db_session.merge(task)
            return ProjectTaskDto.from_model(task)

    def delete_task(self, task_id: int) -> bool:
        """删除任务

        Args:
            task_id: 任务ID
        Returns:
            bool
        """
        task = self.get_task(task_id)

        if not task:
            return False

        with db_helper.sqlserver_session(self._database) as db_session:
            task.is_del = 1
            task.deleted_by = self.current_user.username
            task.deleted_at = datetime.now()
            db_session.merge(task)
            return True

    def update_collect_status(self,task_id:int, status:int, err:str = None):
        task = self.get_task(task_id)
        if not task:
            return False
        with db_helper.sqlserver_session(self._database) as db_session:
            task.collect_status = status
            if err:
                task.collect_error = err
            task.collect_time = datetime.now()
            db_session.merge(task)
            return True

    def update_process_status(self,task_id:int, status:int, err:str = None):
        task = self.get_task(task_id)
        if not task:
            return False
        with db_helper.sqlserver_session(self._database) as db_session:
            task.process_status = status
            if err:
                task.process_error = err
            task.process_time = datetime.now()
            db_session.merge(task)
            return True

    def update_send_status(self,task_id:int, status:int, err:str = None):
        task = self.get_task(task_id)
        if not task:
            return False
        with db_helper.sqlserver_session(self._database) as db_session:
            task.send_status = status
            if err:
                task.send_error = err
            task.send_time = datetime.now()
            db_session.merge(task)
            return True