$President = new President();
$Follower = new Follower();
$Party = new Party();
$Princess = new Princess();
// facebook_idの取得
$facebook_id = $facebook->getUser();
// President情報の取得
$presidents = $President->findBy(array('facebook_id' => $facebook_id));
if ($presidents->num_rows == 0) {
echo 'president取得の失敗なう';
die;
}
$president = $presidents->fetch_assoc();
// Presidentに紐付くParty情報の取得
$party = array();
$result = $Party->findBy(array('president_id' => $facebook_id));
while ($row = $result->fetch_assoc()) {
array_push($party, $row);
}
// Presidentに紐付くPartyに紐付くFollowers情報の取得
$followers = array();
foreach ($party as $party_member) {
$result = $Follower->findBy(array('facebook_id' => $party_member['follower_id']));
while ($row = $result->fetch_assoc()) {
array_push($followers, $row);
}
}
// Presidentに紐付くPrincess情報の取得
$result = $Princess->findBy(array('facebook_id' => $president['princess_id']));
if ($result->num_rows == 0) {
header("HTTP/1.1 301 Moved Permanently");
require_once dirname(__FILE__) . '/../facebook.php';
require_once dirname(__FILE__) . '/../model/Follower.php';
require_once dirname(__FILE__) . '/../model/Party.php';
require_once dirname(__FILE__) . '/../calc_used_money.php';
// Follower,Party Model用意
$Follower = new Follower();
$Party = new Party();
// 全Follower情報取得を試みる
$fql = 'SELECT uid,name,pic,sex FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())';
$followers = $facebook->api(array('method' => 'fql.query', 'query' => $fql));
$followers_data = array();
// 全Followerの情報がMySQLにあるか確認 なければINSERT
foreach ($followers as $follower) {
$uid = $follower['uid'];
$result = $Follower->findBy(array('facebook_id' => $uid));
if ($result->num_rows == 0) {
// INSERTするデータを用意
$data = array('facebook_id' => $uid, 'name' => $follower['name'], 'power' => Job::getPower($uid), 'money' => Job::getMoney($uid), 'pic' => $follower['pic'], 'sex' => $follower['sex'] == 'male' ? 0 : 1, 'job_name' => Job::getMood($uid) . Job::getPosition($uid) . Job::getJob($uid));
$Follower->insert($data);
array_push($followers_data, $data);
} else {
$follower_info = $result->fetch_assoc();
array_push($followers_data, $follower_info);
}
}
$party = array('', '', '');
$result = $Party->findBy(array('president_id' => $facebook->getUser()));
$index = 0;
while ($p = $result->fetch_assoc()) {
$party[$index++] = $p;
}
