PHP Flight::aod方法代码示例

 public static function findByDivision($game_id, $limit = false)
 {
     if (!$limit) {
         $limit = 10;
     }
     return arrayToObject(Flight::aod()->from(self::$table)->where(array("member.game_id" => $game_id))->limit($limit)->sortDesc('date')->join('actions', array('actions.id' => 'user_actions.type_id'))->join('member', array('member.member_id' => 'user_actions.target_id'))->select(array('date', 'user_id', 'type_id', 'target_id', 'verbage', 'icon'))->many());
 }

 public static function delete($id)
 {
     $pt = self::find(array('id' => $id));
     if (count($pt)) {
         Flight::aod()->remove($pt);
     }
     return (bool) Flight::aod()->affected_rows;
 }

 public static function findSquadMembers($squad_id, $div_struc_sort = false, $recruiter = false)
 {
     $conditions = $recruiter ? array('squad_id' => $squad_id, 'position_id' => 6, 'recruiter !%' => $recruiter, 'status_id @' => array(1, 3, 999)) : array('squad_id' => $squad_id, 'position_id' => 6, 'status_id @' => array(1, 3, 999));
     if ($div_struc_sort) {
         return Flight::aod()->from(Member::$table)->where($conditions)->sortDesc('rank_id')->sortAsc('forum_name')->many();
     } else {
         return Flight::aod()->from(Member::$table)->where($conditions)->sortAsc('last_activity')->many();
     }
 }

 public static function findHandle($member_id, $type)
 {
     $params = Flight::aod()->using('MemberHandle')->where(array('member_id' => $member_id, 'handle_type' => $type))->find();
     if (is_object($params)) {
         $handle = Handle::findByType($params->handle_type);
         $params->handle_name = $handle->type;
         $params->name = $handle->name;
         $params->isInvalid = (bool) $params->invalid;
         $params->isVisible = (bool) $handle->show_on_profile;
         if (!is_null($handle->url)) {
             $params->url = $handle->url;
         }
     }
     return $params;
 }

function _doBattlelogIdUpdate()
{
    $members = array();
    $battlelog_names = objectToArray(Member::find(array('status_id' => 1, 'battlelog_name !%' => 0, 'battlelog_id' => 0)));
    $countNames = count($battlelog_names);
    echo "Fetched battlelog names. ({$countNames})<br /><br />";
    foreach ($battlelog_names as $row) {
        $battlelog_id = Member::getBattlelogId($row['battlelog_name']);
        if (!$battlelog_id['error']) {
            $sql = "UPDATE member SET battlelog_id = {$battlelog_id['id']} WHERE battlelog_name = '{$row['battlelog_name']}'";
            Flight::aod()->sql($sql)->one();
            echo "Added ID {$battlelog_id['id']} to {$row['battlelog_name']}<br />";
        } else {
            echo "ERROR: {$row['battlelog_name']} - {$battlelog_id['message']}<br />";
        }
    }
    echo "done syncing battlelog ids.";
}

 public static function remove($member_id)
 {
     $flag = self::find(array('member_id' => $member_id));
     Flight::aod()->remove($flag);
 }

 public static function findAll($game_id)
 {
     return Flight::aod()->using('RecruitingTask')->where(array('game_id @' => array(0, $game_id)))->sortDesc('game_id')->sortAsc('sort_order')->find();
 }

 public static function modify($params)
 {
     $member = new self();
     foreach ($params as $key => $value) {
         $member->{$key} = $value;
     }
     $member->update($params);
     return Flight::aod()->affected_rows;
 }

 public static function resetValidation($email)
 {
     $user = self::find(array('email' => $email));
     if (empty($user)) {
         return false;
     } else {
         $user->validation = md5(time() . rand());
         $user->validated = 0;
         Flight::aod()->save($user);
         Email::validate($user);
         return true;
     }
 }

 public static function recruitingByTheMonth($game_id)
 {
     $sql = "SELECT DATE(DATE_FORMAT(date, '%Y-%m-01')) AS month_beginning, count( * ) AS count\n\t\t\t\tFROM user_actions\n\t\t\t\tJOIN member ON member.member_id = user_actions.user_id\n\t\t\t\tWHERE member.game_id = {$game_id}\n\t\t\t\tAND date > DATE_SUB(NOW(), INTERVAL 4 MONTH)\n\t\t\t\tAND type_id = 1\n\t\t\t\tGROUP BY DATE(DATE_FORMAT(date, '%Y-%m-01'))\n\t\t\t\tORDER BY DATE(DATE_FORMAT(date, '%Y-%m-01'))";
     $params = Flight::aod()->sql($sql)->many();
     return objectToArray($params);
 }

 public static function findByName($name, $game_id)
 {
     $data = Flight::aod()->using('RecruitingString');
     return $data->find(['name' => $name, 'game_id' => $game_id]);
 }

 public static function delete($id)
 {
     $pt = self::find($id);
     Flight::aod()->remove($pt);
 }

    echo $js;
    ?>
.js"></script>
<?php 
}
if (!empty($extrajs) && is_array($extrajs)) {
    foreach ($extrajs as $js) {
        if (isset($js) && file_exists("assets/js/{$js}.js")) {
            ?>
        <script src="assets/js/<?php 
            echo $js;
            ?>
.js"></script>
    <?php 
        }
    }
}
?>

<?php 
// debug information
if (isset($_SESSION['userid'])) {
    Flight::aod()->show_sql = true;
    error_reporting(E_ALL);
    ini_set('display_errors', '1');
}
?>

</body>
</html>

 public static function get_number_from_id($platoon_id)
 {
     $sql = "SELECT number FROM " . Platoon::$table . " WHERE id = {$platoon_id}";
     $params = Flight::aod()->sql($sql)->one();
     return $params['number'];
 }

 /**
  * fetch all alerts not seen by user
  * @return array array of alerts
  */
 public static function find_all($user)
 {
     $sql = "SELECT DISTINCT * FROM " . self::$table . " WHERE start_date < CURRENT_TIMESTAMP AND end_date > CURRENT_TIMESTAMP AND NOT EXISTS ( SELECT * FROM " . AlertStatus::$table . " WHERE alert_id = alerts.id AND user_id = {$user} )";
     $params = Flight::aod()->sql($sql)->many();
     return arrayToObject($params);
 }