public static function get($id = null)
 {
     $q = new query(RUDE_DATABASE_TABLE_CALENDAR_LEGEND);
     if ($id !== null) {
         $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
         $q->query();
         return $q->get_object();
     }
     $q->query();
     return $q->get_object_list();
 }
 public static function get($id = null)
 {
     $q = new query(RUDE_DATABASE_TABLE_REPORTS_CATEGORIES_ITEMS);
     if ($id !== null) {
         $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
         $q->query();
         return $q->get_object();
     }
     $q->query();
     return $q->get_object_list();
 }
 public static function get($id = null)
 {
     $q = new query(RUDE_DATABASE_TABLE_SPECIALIZATIONS);
     if ($id !== null) {
         $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
         $q->query();
         return $q->get_object();
     }
     $q->order_by(RUDE_DATABASE_FIELD_NAME);
     $q->query();
     return $q->get_object_list();
 }
Exemplo n.º 4
0
 function nextid($sequence)
 {
     $esequence = ereg_replace("'", "''", $sequence) . "_seq";
     $query = new query($this, "Select * from {$esequence} limit 1");
     $query->query($this, "REPLACE INTO {$esequence} values ('', nextval+1)");
     if ($query->result) {
         $result = @mysql_insert_id($this->connect_id);
     } else {
         $query->query($this, "CREATE TABLE {$esequence} ( seq char(1) DEFAULT '' NOT NULL, nextval bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment, PRIMARY KEY (seq), KEY (nextval) )");
         $query->query($this, "REPLACE INTO {$esequence} values ('', nextval+1)");
         $result = @mysql_insert_id($this->connect_id);
     }
     return $result;
 }
 public static function get_by_report($report_id)
 {
     $q = new query(RUDE_DATABASE_TABLE_EDUCATION_PREVIEW);
     $q->where(RUDE_DATABASE_FIELD_REPORT_ID, (int) $report_id);
     $q->query();
     return $q->get_object_list();
 }
Exemplo n.º 6
0
 public static function get_by_shortname($shortname)
 {
     $q = new query(RUDE_DATABASE_TABLE_FACULTIES);
     $q->where(RUDE_DATABASE_FIELD_SHORTNAME, $shortname);
     $q->query();
     return $q->get_object();
 }
 public static function get_by_name($name)
 {
     $q = new query(RUDE_DATABASE_TABLE_QUALIFICATIONS);
     $q->where(RUDE_DATABASE_FIELD_NAME, $name);
     $q->query();
     return $q->get_object();
 }
 public static function get_by_order($education_id)
 {
     $q = new query(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_VALUES);
     $q->where('education_id', (int) $education_id);
     $q->order_by('order_num', 'ASC');
     $q->query();
     return $q->get_object_list();
 }
Exemplo n.º 9
0
 public static function get_popup($user_id)
 {
     $q = new query(RUDE_DATABASE_TABLE_SETTINGS);
     $q->where(RUDE_DATABASE_FIELD_USER_ID, (int) $user_id);
     $q->where(RUDE_DATABASE_FIELD_NAME, 'popup');
     $q->query();
     return $q->get_object();
 }
Exemplo n.º 10
0
 public static function is_exists($id)
 {
     $q = new query(RUDE_DATABASE_TABLE_USERS);
     $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
     $q->query();
     if ($q->get_object()) {
         return true;
     }
     return false;
 }
 public static function is_exists($name)
 {
     $q = new query(RUDE_DATABASE_TABLE_TRAINING_FORM);
     $q->where(RUDE_DATABASE_FIELD_NAME, $name);
     $q->query();
     if ($q->get_object()) {
         return true;
     }
     return false;
 }
Exemplo n.º 12
0
function _get_message_tree($id)
{
    global $PHORUM, $DB;
    $q = new query($DB);
    $SQL = "Select id from {$PHORUM['ForumTableName']} where parent={$id}";
    $q->query($DB, $SQL);
    $tree = "{$id}";
    while ($rec = $q->getrow()) {
        $tree .= "," . _get_message_tree($rec["id"]);
    }
    return $tree;
}
 public static function get($report_id = null, $year = null)
 {
     $q = new query(RUDE_DATABASE_TABLE_CALENDAR_ITEMS);
     if ($year !== null) {
         $q->where(RUDE_DATABASE_FIELD_YEAR, (int) $year);
     }
     if ($report_id !== null) {
         $q->where(RUDE_DATABASE_FIELD_REPORT_ID, (int) $report_id);
     }
     $q->query();
     return $q->get_object_list();
 }
Exemplo n.º 14
0
 function nextid($sequence)
 {
     $esequence = $sequence . "_seq";
     $query = new query($this, "select nextval('{$esequence}') as nextid");
     if ($query->result) {
         $row = $query->getrow();
         $nextid = $row["nextid"];
     } else {
         $query->query($this, "create sequence {$esequence}");
         if ($query->result) {
             $nextid = $this->nextid($sequence);
         } else {
             $nextid = 0;
         }
     }
     return $nextid;
 }
Exemplo n.º 15
0
    while (is_array($rec)) {
        $empty = false;
        $name = $rec["name"];
        $num = $rec["id"];
        $description = $rec["description"];
        if (!$rec["folder"]) {
            $sSQL = "select count(*) as posts from {$rec['table_name']} where approved='Y'";
            $tq = new query($DB, $sSQL);
            if ($tq->numrows()) {
                $trec = $tq->getrow();
                $num_posts = $trec["posts"];
            } else {
                $num_posts = '0';
            }
            $sSQL = "select max(datestamp) as max_date from {$rec['table_name']} where approved='Y'";
            $tq->query($DB, $sSQL);
            $trec = $tq->getrow();
            if (empty($trec["max_date"])) {
                $last_post_date = "";
            } else {
                $last_post_date = phorum_date_format($trec["max_date"]);
            }
            $posts = "{$lNumPosts}: <strong>{$num_posts}</strong>&nbsp;&nbsp;";
            $last = "{$lLastPostDate}: <strong>{$last_post_date}</strong>";
            $url = "{$list_page}.{$ext}?f={$num}{$GetVars}";
        } else {
            $last = $lForumFolder;
            $url = "{$forum_page}.{$ext}?f={$num}{$GetVars}";
        }
        ?>
<tr>
Exemplo n.º 16
0
 $SQL = "ALTER TABLE {$rec['table_name']} ADD userid int4 DEFAULT '0' NOT NULL";
 $q->query($DB, $SQL);
 $SQL = "CREATE INDEX " . $rec[table_name] . "_userid on {$rec['table_name']}(userid)";
 $q->query($DB, $SQL);
 echo "Updating modifystamp for {$rec['name']}<br />\n";
 flush();
 $SQL = "select thread, max(datestamp) as datestamp from {$rec['table_name']} group by thread";
 $q->query($DB, $SQL);
 $q2 = new query($DB);
 while ($rec2 = $q->getrow()) {
     list($date, $time) = explode(" ", $rec2["datestamp"]);
     list($year, $month, $day) = explode("-", $date);
     list($hour, $minute, $second) = explode(":", $time);
     $tstamp = mktime($hour, $minute, $second, $month, $day, $year);
     $SQL = "update {$rec['table_name']} set modifystamp={$tstamp} where thread={$rec2['thread']}";
     $q2->query($DB, $SQL);
     echo ".";
     flush();
 }
 $SQL = "select id, attachment from {$rec['table_name']}";
 $q->query($DB, $SQL);
 if ($q->numrows() > 0) {
     echo "<br />\n";
     echo "Converting Attachments for {$rec['name']}<br />\n";
     create_table($DB, "attachments", "{$rec['table_name']}_attachments");
     while ($rec2 = $q->getrow()) {
         $id = $DB->nextid("{$rec['table_name']}_attachments");
         if ($id == 0 && $DB->type != "mysql") {
             echo "Could not get an id for the attachment.<br />\n";
         } else {
             $SQL = "Insert into {$rec['table_name']}_attachments (id, message_id, filename) values({$id}, {$rec2['id']}, '{$rec2['attachment']}')";
Exemplo n.º 17
0
        if ($rows = $q->numrows()) {
            $rec = $q->getrow();
            while (is_array($rec)) {
                $thread = $rec["thread"];
                $rec = $q->getrow();
            }
        }
        $thread = $thread + 1;
    }
    $cutoff_thread = $thread - $cutoff;
    $sSQL = "Select thread from {$ForumTableName} where thread < {$thread} and thread > {$cutoff_thread} order by thread desc" . $limit;
}
$thread_list = new query($DB, $sSQL);
if ($DB->type == "sybase") {
    $limit = "";
    $q->query($DB, "set rowcount 0");
} elseif ($DB->type == "postgresql") {
    $q->query($DB, "set QUERY_LIMIT TO '0'");
}
$rows = $thread_list->numrows();
// This needs to be fixed...
//  if($rows==0 && $navigate!=0){
//    Header("Location: $list_page.$ext?num=$num$GetVars");
//    exit();
//  }
$rec = $thread_list->getrow();
if (isset($rec['thread'])) {
    $max = $rec["thread"];
    while (is_array($rec)) {
        $min = $rec["thread"];
        $rec = $thread_list->getrow();
 public function __construct()
 {
     if (!template_session::is_admin() and !template_session::is_editor()) {
         if (get('ajax')) {
             exit(RUDE_AJAX_ACCESS_VIOLATION);
         }
         return false;
     }
     $report_id = (int) get('report_id');
     if (!$report_id) {
         $reports = new reports();
         $report_id = $reports::add();
         header('Location: /?page=reports-edit&report_id=' . $report_id);
         die;
     }
     if (get('is_tmp')) {
         $reports = new reports_preview();
     } else {
         $reports = new reports();
     }
     if (!$reports::is_exists($report_id)) {
         new template_404(true);
     }
     $this->report = $reports::get($report_id);
     if (!$this->report) {
         new template_404(true);
     }
     switch (get('task')) {
         case 'update':
             $status = true;
             exit((string) $reports::update(get('report_id'), get('year'), get('duration'), get('rector'), get('registration_number'), get('training_form_id'), get('qualification_id'), get('specialty_id'), get('specialization_id'), get('study_practice'), get('manufact_practice'), get('grad_work'), get('gos_exam')));
             break;
         case 'update_education':
             $q = new uquery(RUDE_DATABASE_TABLE_EDUCATION);
             $q->update('not_save', (int) 0);
             $q->where('id', (int) get('dis_id'));
             $q->query();
             $status = true;
             break;
         case 'update_education_item':
             $q = new uquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS);
             $q->update('order_num', (int) get('item_order'));
             $q->update('is_optional', (int) get('optional'));
             $q->where('id', (int) get('item_id'));
             $q->query();
             $status = true;
             break;
         case 'delete_item_discipline':
             $q = new dquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS);
             $q->where('id', (int) get('id'));
             $q->query();
             $status = true;
             break;
         case 'save_education':
             $data = get('data');
             $item_id = get('item_id');
             if (!$data or !$item_id) {
                 return false;
             }
             $education_items = new education_items_values();
             if ($education_items::is_exists($item_id)) {
                 $education_items::remove($item_id);
             }
             $y = 0;
             $id = $item_id[$y];
             foreach ($item_id as $d_id) {
                 $q = new dquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_VALUES);
                 $q->where('item_id', $d_id);
                 $q->query();
             }
             $col_num = 1;
             foreach ($data as $item) {
                 if ($item != '') {
                     $education_items::add($id, $item, $col_num);
                 }
                 if ($col_num == 40) {
                     $col_num = 0;
                     $id = $item_id[$y + 1];
                     $y++;
                 }
                 $col_num++;
             }
             //debug($data);
             $status = true;
             break;
         case 'add_education':
             $tmp = education::add(get('report_id'), get('name'));
             $status = true;
             die(json_encode($tmp));
             break;
         case 'remove_education':
             education::remove(get('id'));
             break;
         case 'add_education_item':
             $tmp = education_items::add(get('education_id'), get('name'), get('order'));
             $status = true;
             die(json_encode($tmp));
             break;
         case 'copy_education':
             $education = education::get(get('dis_id'));
             $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_PREVIEW);
             $q->add('report_id', (int) get('report_id'));
             $q->add('name', $education->name);
             $q->query();
             $new_id = $q->get_id();
             $q = new query(RUDE_DATABASE_TABLE_EDUCATION_ITEMS);
             $q->where('education_id', (int) get('dis_id'));
             $q->query();
             $all_dis = $q->get_object_list();
             foreach ($all_dis as $cur_dis) {
                 $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_PREVIEW);
                 $q->add('name', $cur_dis->name);
                 $q->add('education_id', $new_id);
                 $q->add('order_num', $cur_dis->order_num);
                 $q->add('is_optional', $cur_dis->is_optional);
                 $q->query();
                 $new_item_id = $q->get_id();
                 $q = new query(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_VALUES);
                 $q->where('item_id', $cur_dis->id);
                 $q->query();
                 $all_item_val = $q->get_object_list();
                 foreach ($all_item_val as $cur_item_val) {
                     $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_VALUES_PREVIEW);
                     $q->add('value', $cur_item_val->value);
                     $q->add('item_id', $new_item_id);
                     $q->add('col_num', $cur_item_val->col_num);
                     $q->query();
                 }
             }
             $status = true;
             break;
         default:
             $status = false;
             break;
     }
     if (get('ajax')) {
         if ($status) {
             exit(RUDE_AJAX_OK);
         } else {
             exit(RUDE_AJAX_ERROR);
         }
     }
     return true;
 }