$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) {