<?php
include_once 'Actor.php';
// for testing
if ($argv[0] == 'getCoActors.php') {
$arr = getActors("PRC_A1J5J1E1N1K0Q1O4A4V8L1H4C2Q4C9");
foreach ($arr as $a) {
echo $a->toString() . "\n";
}
}
function getActors($content)
{
$txt = strip_tags($content);
$tokens = preg_split('/\\s+/', $txt);
$proposed = 0;
$actorArr = [];
foreach ($tokens as $value) {
echo "[{$value}]\n";
if ($value == "발의의원") {
echo "Here!";
$proposed = 1;
continue;
}
if ($value == "찬성의원") {
echo "Agrred!";
$proposed = 2;
continue;
}
if ($proposed && strpos($value, ')')) {
$namearr = parse_names($value);
// Add actors
$result = $db->query("SELECT * from Bill");
if (!$result) {
$message = 'Invalid query: ' . $db->error . "\n";
die($message);
}
if ($result->num_rows <= 0) {
die($message = 'no result query: ' . $db->error . "\n");
}
// output data of each row
while ($row = $result->fetch_assoc()) {
$sumHTML = $row['sumHTML'];
$coActorHTML = $row['coActorHTML'];
$id = $row['id'];
echo "Working on {$id}\n";
$bill = getBill($id, $sumHTML);
$actors = getActors($coActorHTML);
if ($dryrun) {
print $bill->toSummaryString();
if ($bill->summary === "") {
echo "\nNo summary! check http://likms.assembly.go.kr/bill/jsp/SummaryPopup.jsp?bill_id={$bill->id}\n";
}
$line = readline("\n\nOK?[y]/n: ");
if ($line === 'n') {
exit(-1);
}
continue;
// DO not put something to DB
}
// insert bill and actors to DB
$bill->update($db);
foreach ($actors as $a) {
{
$pdo = connect();
$ret = $pdo->query('SELECT DISTINCT Pays FROM Film ORDER BY Pays ASC;');
$pdo = close($pdo);
return $ret;
}
function executeQuery($query)
{
$pdo = connect();
$ret = $pdo->query($query);
$pdo = close($pdo);
return $ret;
}
if (!empty($_GET['init'])) {
if (!empty($_GET['getActors'])) {
foreach (getActors() as $actor) {
echo '<option value="' . $actor['Id'] . '">' . $actor['Nom'] . '</option>';
}
} else {
if (!empty($_GET['getCountries'])) {
foreach (getCountries() as $country) {
echo '<option value="' . $country['Pays'] . '">' . $country['Pays'] . '</option>';
}
}
}
} else {
$select = 'SELECT Titre';
$from = 'FROM Film F';
$where = 'WHERE 1';
if (!empty($_GET['actors'])) {
$actorsIdsList = urldecode($_GET['actors']);
