<?
    $people_id=intval($_REQUEST['people_id']);
?>
<h1>Gospel Timeline - Admin</h1>

<p><small><a href='?add=true'>Add New Person</a> - <a href='people.php?edit=true'>Edit Entries</a></small></p>

<p><h2>People - Edit Entries</h2></p>

<blockquote>

        <form action='people_submit.php' method='post'>
        <input type='hidden' name='ref_id' value='<?=$people_id;?>'>
        <p><b>Add Reference:</b></p>
        <table>
            <tr>
                <td><b>Reference:</b></td>
                <td><select name='book'>
                    <option value=''></option>
                <?
                    $book=$_REQUEST['book'];
                    $ref_sql="SELECT id, short FROM mdp_books ORDER BY short";
                    $ref_rs=mysql_query($ref_sql);
                    while($ref_array=mysql_fetch_array($ref_rs)) {
                        echo "<option value='".$ref_array['id']."'";
                        if($book==$ref_array['id'])
                            echo " selected";
                        echo ">".$ref_array['short']."</option>\n";
                    }
                ?>
                </select>
                <input type='text' name='chapter' size='2'> <b>:</b> <input type='text' name='verse' size='3'> - <input type='text' name='chapter_end' size='2'> <b>:</b> <input type='text' name='verse_end' size='3'> <b><tt>JST</tt></b> <input type='checkbox' name='jst' value='t'> <input type='submit' name='submit' value='Add New Reference'>
                </td>
                    
            </tr>
        </table>
        </form>

<form action='people.php'>
<select name='people_id'>
<?
    $people_sql="SELECT * FROM tl_people ORDER BY name";
    $people_rs=mysql_query($people_sql);
    while($people_array=mysql_fetch_array($people_rs))
        $people[]=$people_array;
    
    for($a=0; $a < count($people); $a++) {
        extract($people[$a]);

        echo "<option value='$id'";
        if($id == $people_id)
            echo " selected";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>
</select> <input type='submit' value='Edit Person' name='submit'>
</form>
</blockquote>

<?
//    echo "<pre>";
//    print_r($people);
    if($people_id) {
        
        $person_sql="SELECT * FROM tl_people WHERE tl_people.id = $people_id";
        $person_rs=mysql_query($person_sql);
        $person=mysql_fetch_array($person_rs);
        extract($person);
        
        echo "<h2>";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</h2>\n";
        
        echo "<table cellpadding='0' cellspacing='0'>\n";
        echo "<tr>\n";
        echo "<td valign='top'>\n";
        
        echo "<blockquote>\n";
        ?>
        <form action='people_submit.php' method='post'>
        <input type='hidden' name='people_id' value='<?=$people_id;?>'>
        
        <table>
            <tr>
                <td><b>Name:</b></td>
                <td><input type='text' name='name' value='<?=$name;?>'></td>
            </tr>
            
            <tr>
                <td><b>Sex:</b></td>
                <td>
                    <select name='sex'>
                    <option value='m'<? if($sex=='m') { echo " selected"; } ?>>male</option>
                    <option value='f'<? if($sex=='f') { echo " selected"; } ?>>female</option>
                    </select>
                </td>
            </tr>

            <tr>
                <td><b>Trans.:</b></td>
                <td><input type='text' name='translation' value='<?=$translation;?>'></td>
            </tr>

            <tr>
                <td><b>Age:</b></td>
                <td><input type='text' name='age' size='3' value='<?=$age;?>'></td>
            </tr>
                    
            <tr>
                <td><b>Birth:</b></td>
                <td><input type='text' name='birth' size='5' maxlength='5' value='<?=$birth;?>'>
                <b>Death:</b>
                <input type='text' name='death' size='5' maxlength='5' value='<?=$death;?>'></td>
            </tr>

            <tr>
                <td><b>Father:</b></td>
                <td>
                    <select name='father'>
                    <option value=''></option>
<?
    array($father);
    $father_sql="SELECT id AS father_id, name, birth, death FROM tl_people WHERE id != $people_id AND sex != 'f' ORDER BY name";
    $father_rs=mysql_query($father_sql);
    while($father_array=mysql_fetch_array($father_rs)) {
        extract($father_array);
        echo "<option value='$father_id'";
        if($father == $father_id)
            echo " selected";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>

            <tr>
                <td><b>Mother:</b></td>
                <td>
                    <select name='mother'>
                    <option value=''></option>
<?
    array($mother);
    $mother_sql="SELECT id AS mother_id, name, birth, death FROM tl_people WHERE id != $people_id AND sex != 'm' ORDER BY name";
    $mother_rs=mysql_query($mother_sql);
    while($mother_array=mysql_fetch_array($mother_rs)) {
        extract($mother_array);
        echo "<option value='$mother_id'";
        if($mother == $mother_id)
            echo " selected";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>
            
            <?
                if($sex=='f') {
            ?>
            <tr>
                <td><b>Husband:</b></td>
                <td>
                    <select name='husband'>
                    <option value=''></option>
<?
    array($husband);
    $husband_sql="SELECT id AS husband_id, name, birth, death FROM tl_people WHERE sex != 'f' ORDER BY name";
    $husband_rs=mysql_query($husband_sql);
    while($husband_array=mysql_fetch_array($husband_rs)) {
        extract($husband_array);
        echo "<option value='$husband_id'";
        if($husband == $husband_id)
            echo " selected";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>                
            <?
                }
            ?>
            
            <tr>
                <td><b>Tribe:</b></td>
                <td>
                    <select name='tribe'>
                        <option value=''></option>
                        <option value='Asher'<? if($tribe=='Asher') { echo " selected"; } ?>>Asher</option>
                        <option value='Benjamin'<? if($tribe=='Benjamin') { echo " selected"; } ?>>Benjamin</option>
                        <option value='Dan'<? if($tribe=='Dan') { echo " selected"; } ?>>Dan</option>                        
                        <option value='Ephraim'<? if($tribe=='Ephraim') { echo " selected"; } ?>>Ephraim</option>
                        <option value='Gad'<? if($tribe=='Gad') { echo " selected"; } ?>>Gad</option>
                        <option value='Issachar'<? if($tribe=='Issachar') { echo " selected"; } ?>>Issachar</option>
                        <option value='Judah'<? if($tribe=='Judah') { echo " selected"; } ?>>Judah</option>
                        <option value='Levi'<? if($tribe=='Levi') { echo " selected"; } ?>>Levi</option>
                        <option value='Manasseh'<? if($tribe=='Manasseh') { echo " selected"; } ?>>Manasseh</option>
                        <option value='Naphtali'<? if($tribe=='Naphtali') { echo " selected"; } ?>>Naphtali</option>
                        <option value='Simeon'<? if($tribe=='Simeon') { echo " selected"; } ?>>Simeon</option>
                        <option value='Zebulun'<? if($tribe=='Zebulun') { echo " selected"; } ?>>Zebulun</option>
                    </select>
                </td>
            </tr>
            
            <? if($sex=='m') { ?>
            
            <tr>
                <td><b>Prophet:</b></td>
                <td><input type='checkbox' name='prophet' value='t'<? if($prophet=='t') { echo " checked"; } ?>></td>
            </tr>
            <? } ?>
            
        </table>
        
        <p><input type='submit' name='submit' value='Update Person'></p>
        </form>

    
        </td>
        <td valign='top'>
        <b>Current References:</b><p>
        <?
            $current_sql="SELECT tl_references.chapter, tl_references.chapter_end, tl_references.verse, tl_references.verse_end, mdp_books.title_short FROM tl_references, mdp_books WHERE tl_references.book = mdp_books.id AND tl_references.ref_id = $people_id ORDER BY mdp_books.id, tl_references.chapter, tl_references.verse";
            // echo $current_sql;
            $current_rs=mysql_query($current_sql);
            while ($current_array=mysql_fetch_array($current_rs)) {
                extract($current_array);
                echo "$title_short $chapter";
                if($verse)
                    echo ":$verse";
                if(($chapter_end == $chapter) && $verse_end)
                    echo "-$verse_end";
                elseif(($chapter_end && ($chapter_end != $chapter)) && $verse_end)
                    echo "-$chapter_end:$verse_end";
                elseif($chapter && $chapter_end && !$verse && !$verse_end)
                    echo "-$chapter_end";
                echo "<br>";
            }
            
        ?>
        
        </td>
        </tr>
        </table>
        
        <?
    }        
?>

</blockquote>

<p><h2>Add New Person</h2></p>

<blockquote>
<form action='people_submit.php' method='post'>
        <table>
            <tr>
                <td><b>Name:</b></td>
                <td><input type='text' name='name'></td>
            </tr>
            
            <tr>
                <td><b>Sex:</b></td>
                <td>
                    <select name='sex'>
                    <option value='m'>male</option>
                    <option value='f'>female</option>
                    </select>
                </td>
            </tr>

            <tr>
                <td><b>Age:</b></td>
                <td><input type='text' name='age' size='3'></td>
            </tr>            

            <tr>
                <td><b>Trans.:</b></td>
                <td><input type='text' name='translation'></td>
            </tr>

            <tr>
                <td><b>Birth:</b></td>
                <td><input type='text' name='birth' size='5' maxlength='5'>
                <b>Death:</b>
                <input type='text' name='death' size='5' maxlength='5'></td>
            </tr>

            <tr>
                <td><b>Father:</b></td>
                <td>
                    <select name='father'>
                    <option value=''></option>
<?
    array($father);
    $father_sql="SELECT id AS father_id, name, birth, death FROM tl_people WHERE sex != 'f' ORDER BY name";
    $father_rs=mysql_query($father_sql);
    while($father_array=mysql_fetch_array($father_rs)) {
        extract($father_array);
        echo "<option value='$father_id'";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>

            <tr>
                <td><b>Mother:</b></td>
                <td>
                    <select name='mother'>
                    <option value=''></option>
<?
    array($mother);
    $mother_sql="SELECT id AS mother_id, name, birth, death FROM tl_people WHERE sex != 'm' ORDER BY name";
    $mother_rs=mysql_query($mother_sql);
    while($mother_array=mysql_fetch_array($mother_rs)) {
        extract($mother_array);
        echo "<option value='$mother_id'";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>
            
            <tr>
                <td><b>Husband:</b></td>
                <td>
                    <select name='husband'>
                    <option value=''></option>
<?
    array($husband);
    $husband_sql="SELECT id AS husband_id, name, birth, death FROM tl_people WHERE sex != 'f' ORDER BY name";
    $husband_rs=mysql_query($husband_sql);
    while($husband_array=mysql_fetch_array($husband_rs)) {
        extract($husband_array);
        echo "<option value='$husband_id'";
        echo ">";
        echo $name;
        if($birth && $death) {
            if($birth < 0 || $death < 0)
                $meridian = "BC";
            else
                $meridian = "AD";
            echo " (".abs($birth)." - ".abs($death)." $meridian)";
        }
        echo "</option>\n";
    }
?>                    
                    </select>
                </td>
            </tr>                

            
            <tr>
                <td><b>Tribe:</b></td>
                <td>
                    <select name='tribe'>
                        <option value=''></option>
                        <option value='Asher'>Asher</option>
                        <option value='Benjamin'>Benjamin</option>
                        <option value='Dan'>Dan</option>                        
                        <option value='Ephraim'>Ephraim</option>
                        <option value='Gad'>Gad</option>
                        <option value='Issachar'>Issachar</option>
                        <option value='Judah'>Judah</option>
                        <option value='Levi'>Levi</option>
                        <option value='Manasseh'>Manasseh</option>
                        <option value='Naphtali'>Naphtali</option>
                        <option value='Simeon'>Simeon</option>
                        <option value='Zebulun'>Zebulun</option>
                    </select>
                </td>
            </tr>
            
            <tr>
                <td><b>Prophet:</b></td>
                <td><input type='checkbox' name='prophet' value='t'></td>
            </tr>
        </table>
        
        <p><input type='submit' name='submit' value='Add Person'></p>
        </form>