public static function add($name)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_DISCIPLINES);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->query();
     return true;
 }
 public static function add($name)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_QUALIFICATIONS);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->query();
     return true;
 }
 public static function add($name, $shortname)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_FACULTIES);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_SHORTNAME, $shortname);
     $q->query();
     return true;
 }
 public static function add($name, $code)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_SPECIALIZATIONS);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add('code', $code);
     $q->query();
     return true;
 }
 public static function add($legend_letter, $description)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_CALENDAR_LEGEND);
     $q->add(RUDE_DATABASE_FIELD_LEGEND_LETTER, $legend_letter);
     $q->add(RUDE_DATABASE_FIELD_LEGEND_DESCRIPTION, $description);
     $q->query();
     return true;
 }
 public static function add($report_id, $name)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_PREVIEW);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_REPORT_ID, $report_id);
     $q->query();
     return $q->get_id();
 }
 public static function add($name, $faculti_id, $qualif_id)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_SPECIALTIES);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_FACULTY_ID, $faculti_id);
     $q->add(RUDE_DATABASE_FIELD_QUALIFICATION_ID, $qualif_id);
     $q->query();
     return true;
 }
 public static function add($name, $report_id, $order = 0)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_REPORTS_CATEGORIES);
     $q->add(RUDE_DATABASE_FIELD_REPORT_ID, (int) $report_id);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_ORDER, (int) $order);
     $q->query();
     return true;
 }
 public static function add($id, $item, $col_num)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_VALUES);
     $q->add('col_num', $col_num);
     $q->add('value', $item);
     $q->add('item_id', $id);
     $q->query();
     return true;
 }
 public static function add($education_id, $name, $order)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS_PREVIEW);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add('order_num', $order);
     $q->add('education_id', $education_id);
     $q->query();
     return true;
 }
 public static function add($name, $discipline_id, $order = 0)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_REPORTS_CATEGORIES_ITEMS);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_DISCIPLINE_ID, (int) $discipline_id);
     $q->add(RUDE_DATABASE_FIELD_ORDER, (int) $order);
     $q->query();
     return true;
 }
Esempio n. 12
0
 public static function add($user_id)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_SETTINGS);
     $q->add(RUDE_DATABASE_FIELD_USER_ID, $user_id);
     $q->add(RUDE_DATABASE_FIELD_NAME, 'rector');
     $q->add(RUDE_DATABASE_FIELD_VALUE, '');
     $q->query();
     $q = new cquery(RUDE_DATABASE_TABLE_SETTINGS);
     $q->add(RUDE_DATABASE_FIELD_USER_ID, $user_id);
     $q->add(RUDE_DATABASE_FIELD_NAME, 'popup');
     $q->add(RUDE_DATABASE_FIELD_VALUE, 'false');
     $q->query();
     return true;
 }
 public static function add($education_id, $name, $order, $is_optional = 0)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_EDUCATION_ITEMS);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add('order_num', $order);
     $q->add('education_id', $education_id);
     $q->add('is_optional', $is_optional);
     $q->query();
     return $q->get_id();
 }
 public static function add($report_id, $year, $column, $value)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_CALENDAR_ITEMS);
     $q->add(RUDE_DATABASE_FIELD_REPORT_ID, (int) $report_id);
     $q->add(RUDE_DATABASE_FIELD_YEAR, $year);
     $q->add(RUDE_DATABASE_FIELD_COLUMN, (int) $column);
     $q->add(RUDE_DATABASE_FIELD_VALUE, $value);
     $q->query();
     return $q->get_id();
 }
 public static function add($year = null, $duration = null, $rector = null, $registration_number = null, $training_form_id = null, $qualification_id = null, $specialty_id = null, $specialization_id = null, $study_practice = null, $manufact_practice = null, $grad_work = null, $gos_exam = null)
 {
     $q = new cquery(RUDE_DATABASE_TABLE_REPORTS_PREVIEW);
     $q->add(RUDE_DATABASE_FIELD_YEAR, (int) $year);
     $q->add(RUDE_DATABASE_FIELD_DURATION, (int) $duration);
     $q->add(RUDE_DATABASE_FIELD_RECTOR, $rector);
     $q->add(RUDE_DATABASE_FIELD_REGISTRATION_NUMBER, $registration_number);
     $q->add(RUDE_DATABASE_FIELD_TRAINING_FORM_ID, (int) $training_form_id);
     $q->add(RUDE_DATABASE_FIELD_QUALIFICATION_ID, (int) $qualification_id);
     $q->add(RUDE_DATABASE_FIELD_SPECIALTY_ID, (int) $specialty_id);
     $q->add(RUDE_DATABASE_FIELD_SPECIALIZATION_ID, (int) $specialization_id);
     $q->add('study_practice', $study_practice);
     $q->add('manufact_practice', $manufact_practice);
     $q->add('grad_work', $grad_work);
     $q->add('gos_exam', $gos_exam);
     $q->query();
     return $q->get_id();
 }
Esempio n. 16
0
 public static function add($name, $password, $role_id)
 {
     list($hash, $salt) = crypt::password($password);
     $q = new cquery(RUDE_DATABASE_TABLE_USERS);
     $q->add(RUDE_DATABASE_FIELD_NAME, $name);
     $q->add(RUDE_DATABASE_FIELD_HASH, $hash);
     $q->add(RUDE_DATABASE_FIELD_SALT, $salt);
     $q->add(RUDE_DATABASE_FIELD_ROLE_ID, $role_id);
     $q->query();
     return $q->get_id();
 }
 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;
 }