通达OA模块开发实战

New-Item -ItemType Directory -Path "MYOA\webroot\general\project"

project/
├── index.php          # 项目列表页
├── add.php            # 添加项目页
├── edit.php           # 编辑项目页
├── detail.php         # 项目详情页
├── delete.php         # 删除项目接口
├── ajax.php           # AJAX接口
└── style.css          # 模块样式文件

CREATE TABLE IF NOT EXISTS `project` (
    `project_id` int(11) NOT NULL AUTO_INCREMENT,
    `project_name` varchar(100) NOT NULL,
    `description` text,
    `start_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `status` tinyint(1) DEFAULT '0',
    `creator_uid` int(11) NOT NULL,
    `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`project_id`),
    KEY `creator_uid` (`creator_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?php
$HTML_PAGE_TITLE = _("项目管理");
include_once("inc/auth.inc.php");
include_once("inc/header.inc.php");

$td = new TD();

// 分页参数
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$page_size = 10;
$offset = ($page - 1) * $page_size;

// 查询项目列表
$sql = "SELECT p.*, u.name AS creator_name 
        FROM project p 
        LEFT JOIN user u ON p.creator_uid = u.uid 
        ORDER BY p.create_time DESC 
        LIMIT $offset, $page_size";
$result = $td->query($sql);

// 查询总数
$count_sql = "SELECT COUNT(*) AS total FROM project";
$count_result = $td->query($count_sql);
$count_row = $td->fetch_array($count_result);
$total = $count_row['total'];
$total_pages = ceil($total / $page_size);
?>

<div class="main-content">
    <h2><?php echo _("项目列表"); ?></h2>
    
    <a href="add.php" class="btn btn-primary">
        <?php echo _("添加项目"); ?>
    </a>
    
    <table class="table">
        <thead>
            <tr>
                <th><?php echo _("项目名称"); ?></th>
                <th><?php echo _("描述"); ?></th>
                <th><?php echo _("时间范围"); ?></th>
                <th><?php echo _("状态"); ?></th>
                <th><?php echo _("创建人"); ?></th>
                <th><?php echo _("操作"); ?></th>
            </tr>
        </thead>
        <tbody>
            <?php while ($row = $td->fetch_array($result)) { ?>
            <tr>
                <td><?php echo $row['project_name']; ?></td>
                <td><?php echo csubstr($row['description'], 0, 50); ?></td>
                <td><?php echo $row['start_date'] . ' ~ ' . $row['end_date']; ?></td>
                <td><?php echo $row['status'] ? _('已完成') : _('进行中'); ?></td>
                <td><?php echo $row['creator_name']; ?></td>
                <td>
                    <a href="detail.php?id=<?php echo $row['project_id']; ?>">
                        <?php echo _("查看"); ?>
                    </a>
                    <a href="edit.php?id=<?php echo $row['project_id']; ?>">
                        <?php echo _("编辑"); ?>
                    </a>
                    <a href="delete.php?id=<?php echo $row['project_id']; ?>" 
                       onclick="return confirm('<?php echo _('确定删除?'); ?>')">
                        <?php echo _("删除"); ?>
                    </a>
                </td>
            </tr>
            <?php } ?>
        </tbody>
    </table>
    
    <?php // 分页代码省略 ?>
</div>

<?php
include_once("inc/footer.inc.php");
?>

<?php
$HTML_PAGE_TITLE = _("添加项目");
include_once("inc/auth.inc.php");
include_once("inc/header.inc.php");

if ($_POST) {
    $td = new TD();
    
    $project_name = $td->escape($_POST['project_name']);
    $description = $td->escape($_POST['description']);
    $start_date = $_POST['start_date'];
    $end_date = $_POST['end_date'];
    $creator_uid = $_SESSION['uid'];
    
    $sql = "INSERT INTO project (project_name, description, start_date, end_date, creator_uid) 
            VALUES ('$project_name', '$description', '$start_date', '$end_date', $creator_uid)";
    
    if ($td->query($sql)) {
        Message(_("添加成功"), "index.php");
        exit;
    } else {
        Message(_("添加失败"), "add.php");
        exit;
    }
}
?>

<div class="main-content">
    <h2><?php echo _("添加项目"); ?></h2>
    
    <form method="post" action="add.php">
        <div class="form-group">
            <label><?php echo _("项目名称"); ?>:</label>
            <input type="text" name="project_name" required class="form-control">
        </div>
        
        <div class="form-group">
            <label><?php echo _("项目描述"); ?>:</label>
            <textarea name="description" class="form-control"></textarea>
        </div>
        
        <div class="form-group">
            <label><?php echo _("开始日期"); ?>:</label>
            <input type="date" name="start_date" required class="form-control">
        </div>
        
        <div class="form-group">
            <label><?php echo _("结束日期"); ?>:</label>
            <input type="date" name="end_date" required class="form-control">
        </div>
        
        <button type="submit" class="btn btn-primary">
            <?php echo _("提交"); ?>
        </button>
        <a href="index.php" class="btn btn-default">
            <?php echo _("返回"); ?>
        </a>
    </form>
</div>

<?php
include_once("inc/footer.inc.php");
?>

<?php
include_once("inc/auth.inc.php");

$td = new TD();
$project_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

if ($project_id > 0) {
    $sql = "DELETE FROM project WHERE project_id = $project_id";
    if ($td->query($sql)) {
        Message(_("删除成功"), "index.php");
    } else {
        Message(_("删除失败"), "index.php");
    }
} else {
    Message(_("参数错误"), "index.php");
}
?>

Mermaid 渲染失败: Lexical error on line 9. Unrecognized text.
...al/project/index.php]    E -->|父菜单| E3[
-----------------------^

<?php
include_once("inc/utility_file.php");

// 处理文件上传
if ($_FILES['attachment']['name']) {
    $attach = upload('attachment', 0, 0, 'project');
    if ($attach['error'] == 0) {
        $attach_id = $attach['id'];
        // 保存附件ID到数据库
    }
}
?>

<?php
include_once("inc/header.inc.php");
?>

<!-- 人员多选组件 -->
<input type="hidden" name="user_ids" id="user_ids">
<script type="text/javascript">
    // 调用人员选择组件
    selectUser('user_ids', 'multi');
</script>

<?php
// ajax.php
include_once("inc/auth.inc.php");

$action = isset($_GET['action']) ? $_GET['action'] : '';

if ($action == 'search') {
    $keyword = $_GET['keyword'];
    $td = new TD();
    $keyword = $td->escape($keyword);
    
    $sql = "SELECT * FROM project WHERE project_name LIKE '%$keyword%'";
    $result = $td->query($sql);
    
    $data = array();
    while ($row = $td->fetch_array($result)) {
        $data[] = $row;
    }
    
    echo json_encode($data);
    exit;
}
?>