Example #1
0
         $t->edit = 'SupportTicketsform';
         $t->ipe_table = 'SupportTickets';
         #uncomment this for immediate table update (no save button)
     } else {
         $off = 'checked="checked"';
         $on = '';
     }
     echo "\nEdit Mode <input type='radio' name='EditMode' value='on' {$on}> On <input type='radio' name='EditMode' value='off' {$off} /> Off ";
 } else {
     $EditMode = '';
 }
 echo "\n</form>\n";
 // When we hit this page the first time,
 // there is no .
 if (!isset($q_SupportTickets)) {
     $q_SupportTickets = new SupportTickets_Sql_Query();
     // We make one
     $q_SupportTickets->conditions = 1;
     // ... with a single condition (at first)
     $q_SupportTickets->translate = "on";
     // ... column names are to be translated
     $q_SupportTickets->container = "on";
     // ... with a nice container table
     $q_SupportTickets->variable = "on";
     // ... # of conditions is variable
     $q_SupportTickets->lang = "en";
     // ... in English, please
     $q_SupportTickets->primary_key = "id";
     // let Query engine know primary key
     $q_SupportTickets->default_query = $db->qi("id") . "!='0' desc";
     // let Query engine know primary key
         $cj = " or ";
         $sql .= "Status='{$v}'";
     }
     if ($cj == " or ") {
         $sql .= " ) ";
     }
 }
 $query = $sql;
 // These fields will be searchable and displayed in results.
 // Format is "RealFieldName"=>"Field Name Formatted For Display",
 $t->fields = array("id", "UserName", "ShortDesc", "Status", "Severity", "Created", "Updated", "Location", "EnteredBy");
 $t->map_cols = array("id" => "Ticket No", "UserName" => "UserName", "ShortDesc" => "Description", "Status" => "Status", "Severity" => "Severity", "Created" => "Created", "Updated" => "Updated", "EnteredBy" => "Entered By");
 // When we hit this page the first time,
 // there is no .
 if (!isset($q) or $q->classname != "SupportTickets_Sql_Query") {
     $q = new SupportTickets_Sql_Query();
     // We make one
     $q->conditions = 1;
     // ... with a single condition (at first)
     $q->translate = "on";
     // ... column names are to be translated
     $q->container = "on";
     // ... with a nice container table
     $q->variable = "on";
     // ... # of conditions is variable
     $q->lang = "en";
     // ... in English, please
     $sess->register("q");
     // and don't forget this!
 }
 if ($rowcount) {