
<?php
   require_once("forms/qlForms.inc");
   require_once("qlDatabase.inc");

   $form = new qlForm("Songs Archive");
   $form->rs = new qlDatabase();

   $form->dbTable = "songs";
   $form->action = "editSongs.php";
   $form->method = "post";
   $form->itemType = "Song";
   $form->idField = "song_id";
   $form->sortBy = "name";
   $form->tableWidth = 550;
   $form->viewField = array("name"=>"Name", "author"=>"Author");
   $form->secondaryDB = "Themes;song_id;songthemes;song_id;song_id";

   $form->add_element(array("type"=>"showtext",
                             "name"=>"text1",
                             "headerRow"=>true,
                             "oneColumn"=>true,
                             "value"=>"Song Information"));

   $form->add_element(array("type"=>"text",
                            "name"=>"name",
                            "description"=>"Name",
                            "tableBreak"=>"",
                            "required"=>true,
                            "maxlength"=>"40"));

   $form->add_element(array("type"=>"text",
                            "name"=>"author",
                            "description"=>"Author",
                            "tableBreak"=>"",
                            "value"=>"",
                            "maxlength"=>"40"));

   $lblArray = array(array("label"=>"A", "value"=>"A"),
                     array("label"=>"Am", "value"=>"Am"),
                     array("label"=>"Bb", "value"=>"B"),
                     array("label"=>"Bbm", "value"=>"Bm"),
                     array("label"=>"B", "value"=>"B"),
                     array("label"=>"Bm", "value"=>"Bm"),
                     array("label"=>"C", "value"=>"C"),
                     array("label"=>"Cm", "value"=>"Cm"),
                     array("label"=>"C#", "value"=>"C#"),
                     array("label"=>"C#m", "value"=>"C#m"),
                     array("label"=>"D", "value"=>"D"),
                     array("label"=>"Dm", "value"=>"Dm"),
                     array("label"=>"D#", "value"=>"D#"),
                     array("label"=>"D#m", "value"=>"D#m"),
                     array("label"=>"E", "value"=>"E"),
                     array("label"=>"Em", "value"=>"Em"),
                     array("label"=>"F", "value"=>"F"),
                     array("label"=>"Fm", "value"=>"Fm"),
                     array("label"=>"F#", "value"=>"F#"),
                     array("label"=>"F#m", "value"=>"F#m"),
                     array("label"=>"G", "value"=>"G"),
                     array("label"=>"Gm", "value"=>"Gm"),
                     array("label"=>"G#", "value"=>"G#"),
                     array("label"=>"G#m", "value"=>"G#m"),
                     array("label"=>"Accapella", "value"=>"Accapella"));
   $form->add_element(array("type"=>"select",
                            "name"=>"relativeKey",
                            "description"=>"Key",
                            "tableBreak"=>"",
                            "options"=>$lblArray,
                            "selected"=>array("G"),
                            "size"=>"1"));

   $form->add_element(array("type"=>"textarea",
                            "name"=>"lyrics",
                            "description"=>"Lyrics (preferably with chords)",
                            "tableBreak"=>"",
                            "rows"=>"10",
                            "cols"=>"65"));

   $form->add_element(array("type"=>"text",
                            "name"=>"etcInfo",
                            "description"=>"Etc Information (i.e. capo 2)",
                            "tableBreak"=>"",
                            "maxlength"=>"74"));

   $form->add_element(array("type"=>"text",
                            "name"=>"copyrightInfo",
                            "description"=>"Copyright Info",
                            "tableBreak"=>"",
                            "maxlength"=>"50"));

   $form->add_element(array("type"=>"text",
                            "name"=>"licenseInfo",
                            "description"=>"License Info",
                            "tableBreak"=>"",
                            "maxlength"=>"50"));

   $form->add_element(array("type"=>"text",
                            "name"=>"album",
                            "description"=>"Album Name",
                            "value"=>"",
                            "tableBreak"=>"",
                            "maxlength"=>"40"));

   $form->add_element(array("type"=>"text",
                            "name"=>"songNumber",
                            "description"=>"Song Number",
                            "tableBreak"=>"",
                            "size"=>2,
                            "maxlength"=>"2"));

   $form->add_element(array("type"=>"text",
                            "name"=>"author_written",
                            "description"=>"Written By",
                            "tableBreak"=>"",
                            "value"=>"",
                            "maxlength"=>"40"));

   $form->add_element(array("type"=>"date",
                            "name"=>"dateWritten",
                            "description"=>"Date Written",
                            "preYears"=>"9",
                            "postYears"=>"1"));

   $lblArray = array(array("label"=>"top", "value"=>"top"),
                     array("label"=>"mid", "value"=>"mid"),
                     array("label"=>"low", "value"=>"low"),
                     array("label"=>"band", "value"=>"band"));
   $form->add_element(array("type"=>"select",
                            "name"=>"level",
                            "description"=>"Priority",
                            "tableBreak"=>"",
                            "options"=>$lblArray,
                            "selected"=>array("top"),
                            "size"=>1,
                            "maxlength"=>"2"));

   $form->add_element(array("type"=>"showtext",
                            "name"=>"text2",
                            "tableBreak"=>true,
                            "description"=>"Song Description",
                            "headerRow"=>true));

   $lblArray = array(array("label"=>"Worship", "value"=>"worship"),
                     array("label"=>"Band", "value"=>"band"),
                     array("label"=>"Christmas", "value"=>"christmas"));
   $form->add_element(array("type"=>"checkbox",
                            "name"=>"category",
                            "description"=>"Category",
                            "required"=>true,
                            "options"=>$lblArray,
                            "selected"=>array("worship"),
                            "multiple"=>true,
                            "numRows"=>"1"));

   $form->add_element(array("type"=>"checkbox",
                            "name"=>"songLocation",
                            "description"=>"Where the Song is Sung",
                            "tableBreak"=>"",
                            "options"=>"ql_db;songLocations;name;songLocation",
                            "selected"=>array(""),
                            "multiple"=>true,
                            "numCols"=>2));

   //$form->add_element(array("type"=>"text",
    //                        "name"=>"theme",
     //                       "description"=>"Themes (i.e. grace, crucificion)",
      //                      "tableBreak"=>"",
       //                     "secondaryDB"=>"primary",
        //                    "maxlength"=>"100"));

   $form->add_element(array("type"=>"submit",
                             "name"=>"submit",
                             "value"=>"Submit Song"));

   $form->start();
?>