コード例 #1
0
 public static function edit($id, $name)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_QUALIFICATIONS);
     $q->update(RUDE_DATABASE_FIELD_NAME, $name);
     $q->where(RUDE_DATABASE_FIELD_ID, $id);
     $q->query();
     return true;
 }
コード例 #2
0
 public static function edit($id, $legend_letter, $description)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_CALENDAR_LEGEND);
     $q->update(RUDE_DATABASE_FIELD_LEGEND_LETTER, $legend_letter);
     $q->update(RUDE_DATABASE_FIELD_LEGEND_DESCRIPTION, $description);
     $q->where(RUDE_DATABASE_FIELD_ID, $id);
     $q->query();
     return true;
 }
コード例 #3
0
 public static function edit($id, $name, $code)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_SPECIALIZATIONS);
     $q->update(RUDE_DATABASE_FIELD_NAME, $name);
     $q->update('code', $code);
     $q->where(RUDE_DATABASE_FIELD_ID, $id);
     $q->query();
     return true;
 }
コード例 #4
0
 public static function edit($id, $name)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_DIRECTION);
     $q->update(RUDE_DATABASE_FIELD_NAME, $name);
     $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
     $q->limit(1);
     $q->query();
     return true;
 }
コード例 #5
0
 public static function edit($id, $name, $shortname)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_FACULTIES);
     $q->update(RUDE_DATABASE_FIELD_NAME, $name);
     $q->update(RUDE_DATABASE_FIELD_SHORTNAME, $shortname);
     $q->where(RUDE_DATABASE_FIELD_ID, $id);
     $q->query();
     return true;
 }
コード例 #6
0
 public static function edit($id, $name, $role_id)
 {
     if (static::is_exists($id)) {
         $q = new uquery(RUDE_DATABASE_TABLE_USERS);
         $q->update(RUDE_DATABASE_FIELD_NAME, $name);
         $q->update(RUDE_DATABASE_FIELD_ROLE_ID, (int) $role_id);
         $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
         $q->query();
         return true;
     }
     return false;
 }
コード例 #7
0
 public static function save($popup_id, $popup, $rector_id, $rector)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_SETTINGS);
     $q->update(RUDE_DATABASE_FIELD_VALUE, $popup);
     $q->where(RUDE_DATABASE_FIELD_ID, $popup_id);
     $q->query();
     $q = new uquery(RUDE_DATABASE_TABLE_SETTINGS);
     $q->update(RUDE_DATABASE_FIELD_VALUE, $rector);
     $q->where(RUDE_DATABASE_FIELD_ID, $rector_id);
     $q->query();
     return true;
 }
コード例 #8
0
 public static function edit($id, $name, $faculti_id, $qualif_id)
 {
     $q = new uquery(RUDE_DATABASE_TABLE_SPECIALTIES);
     $q->update(RUDE_DATABASE_FIELD_NAME, $name);
     $q->update(RUDE_DATABASE_FIELD_FACULTY_ID, $faculti_id);
     $q->update(RUDE_DATABASE_FIELD_QUALIFICATION_ID, $qualif_id);
     $q->where(RUDE_DATABASE_FIELD_ID, $id);
     $q->query();
     return true;
 }
コード例 #9
0
 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;
 }
コード例 #10
0
 public static function update($id, $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 uquery(RUDE_DATABASE_TABLE_REPORTS_PREVIEW);
     if ($year !== null) {
         $q->update(RUDE_DATABASE_FIELD_YEAR, (int) $year);
     }
     if ($duration !== null) {
         $q->update(RUDE_DATABASE_FIELD_DURATION, (int) $duration);
     }
     if ($rector !== null) {
         $q->update(RUDE_DATABASE_FIELD_RECTOR, $rector);
     }
     if ($registration_number !== null) {
         $q->update(RUDE_DATABASE_FIELD_REGISTRATION_NUMBER, $registration_number);
     }
     if ($training_form_id !== null) {
         $q->update(RUDE_DATABASE_FIELD_TRAINING_FORM_ID, (int) $training_form_id);
     }
     if ($qualification_id !== null) {
         $q->update(RUDE_DATABASE_FIELD_QUALIFICATION_ID, (int) $qualification_id);
     }
     if ($specialty_id !== null) {
         $q->update(RUDE_DATABASE_FIELD_SPECIALTY_ID, (int) $specialty_id);
     }
     if ($specialization_id !== null) {
         $q->update(RUDE_DATABASE_FIELD_SPECIALIZATION_ID, (int) $specialization_id);
     }
     if ($study_practice !== null) {
         $q->update('study_practice', $study_practice);
     }
     if ($manufact_practice !== null) {
         $q->update('manufact_practice', $manufact_practice);
     }
     if ($grad_work !== null) {
         $q->update('grad_work', $grad_work);
     }
     if ($gos_exam !== null) {
         $q->update('gos_exam', $gos_exam);
     }
     $q->where(RUDE_DATABASE_FIELD_ID, (int) $id);
     $q->query();
     return true;
 }