SWDB/application/action/save_run_team.php

<?php
    /**
     * File for the run team saving action.
     *
     * Implements an action function to be called from the {@see Controller}.
     * 
     * @category Action
     */

    /**
     * Saves a run party as a team.
     *
     * Reads the POST parameters looking for the following KEYS:
     *  player
     *  run
     *  name
     *  description
     * Validates the data and creates the team in the database.
     * 
     * @return int 0 on success, negative values on error.
     * @category Action
     * @global resource Database connection.
     */
    function action(){
        global $db;
        $player = filter_input(INPUT_POST, 'player');
        $run = filter_input(INPUT_POST, 'run');
        $name = filter_input(INPUT_POST, 'name');
        $description = filter_input(INPUT_POST, 'description');
        if ($name == null || strlen($name) == 0){
            return -1;
        }
        $s = "SELECT CASE WHEN MAX(id) IS NULL THEN 1 ELSE MAX(id) + 1 END AS id FROM team;";
        $q = $db->query($s);
        $r = $q->fetchArray(SQLITE3_ASSOC);
        $team_id = $r["id"];
        $statement = $db->prepare("
          SELECT
            run.area AS area,
            run.stage AS stage,
            run.difficulty AS difficulty,
            k_area.type AS area_type
          FROM
            data.run run,
            key.area k_area
          WHERE
            run.player = :player AND
            run.id = :run AND
            k_area.id = run.area AND
            run.helper = 0;
        ");
        $statement->bindValue(':player', $player, SQLITE3_TEXT);
        $statement->bindValue(':run', $run, SQLITE3_TEXT);
        $r = $statement->execute()->fetchArray(SQLITE3_ASSOC);
        if (!$r){
            return -2;
        }
        $statement = $db->prepare("
          INSERT INTO datateam (
            player,
            id,
            name,
            description,
            area_type,
            area,
            stage,
            difficulty,
            score
          ) VALUES (
            :player,
            :id,
            :name,
            :description,
            :area_type,
            :area,
            :stage,
            :difficulty,
            :score);
          ");
        $statement->bindValue(':player', $player, SQLITE3_TEXT);
        $statement->bindValue(':id', $team_id, SQLITE3_TEXT);
        $statement->bindValue(':name', $name, SQLITE3_TEXT);
        $statement->bindValue(':description', $description, SQLITE3_TEXT);
        $statement->bindValue(':area_type', $r["area_type"], SQLITE3_TEXT);
        $statement->bindValue(':area', $r["area"], SQLITE3_TEXT);
        $statement->bindValue(':stage', $r["stage"], SQLITE3_TEXT);
        $statement->bindValue(':difficulty', $r["difficulty"], SQLITE3_TEXT);
        $statement->bindValue(':score', 0, SQLITE3_TEXT);
        $res = $statement->execute();
        if (!$res){
            return -3;
        }
        $s = "SELECT unit FROM data.run_party WHERE run = $run AND unit IS NOT NULL;";
        $q = $db->query($s);
        while ($r = $q->fetchArray(SQLITE3_ASSOC)){
            $statement = $db->prepare("
              INSERT INTO data.team_unit (team, unit)
              VALUES (:team, :unit)
            ");
            $statement->bindValue(':team', $team_id, SQLITE3_TEXT);
            $statement->bindValue(':unit', $r["unit"], SQLITE3_TEXT);
            $statement->execute();
        }
        return 0;
    }
?>