diff options
Diffstat (limited to 'testimonials_edit.inc')
| -rw-r--r-- | testimonials_edit.inc | 360 |
1 files changed, 360 insertions, 0 deletions
diff --git a/testimonials_edit.inc b/testimonials_edit.inc new file mode 100644 index 0000000..7a979e3 --- /dev/null +++ b/testimonials_edit.inc @@ -0,0 +1,360 @@ +<?php +function fellowship_testimonials_edit() { + $page_content = ""; + $fellowship_testimonials_edit_form = drupal_get_form("fellowship_testimonials_edit_form"); + $page_content .= drupal_render($fellowship_testimonials_edit_form); + return $page_content; + } +function fellowship_testimonials_edit_form($form,$form_state, $testimonial_id = 0) { + $testimonial_id = arg(2); + //var_dump($testimonial_id);die; + $query = db_select('fellowship_testimonials'); + $query->fields('fellowship_testimonials'); + $query->condition('id', $testimonial_id); + $result = $query->execute(); + $row = $result->fetchObject(); + $form = array(); + $form["fellowship_year"] = array( + "#type" => "textfield", + "#title" => "Enter the fellowship year participated by the fellow(s)", + '#attributes' => array( + 'placeholder' => t('For eg: 2019') + ), + "#default_value" => $row->year, + "#required" => TRUE, + ); + $form["fellowship_task"] = array( + "#type" => "textfield", + "#title" => "Enter the fellowship task done by the fellow(s)", + '#attributes' => array( + 'placeholder' => t('For eg: Python, DWSIM, eSim etc') + ), + "#default_value" => $row->fellowship_task, + "#required" => TRUE, + ); + $form["opt_text_or_video"] = array( + "#type" => 'select', + "#title" => t('Select the type of testimonial'), + "#options" => array( + 'T' => 'Text', + 'V' => 'Video' + ), + "#required" => TRUE, + '#default_value' => $row->testimonial_type, + '#disabled' => TRUE, + /*'#ajax' => array( + 'callback' => 'ajax_testimonial_type' + )*/ + ); + if($row->testimonial_type == 'T'){ + $form["testimonial_text"] = array( + "#type" => "text_format", + '#format' => 'full_html', + "#title" => "Testimonial text", + "#default_value" => $row->testimonial_text, + '#prefix' => '<div id="testimonial-text">', + '#suffix' => '</div>', + // "#required" => TRUE, + '#states' => array( + 'visible' => array( + ':input[name="opt_text_or_video"]' => array( + 'value' => 'T' + ) + ) + ), + ); + } + else{ + $form["testimonial_video"] = array( + "#type" => "textfield", + "#title" => "Testimonial Video", + '#attributes' => array( + 'placeholder' => t('Copy paste the static url of the video, for eg: https://static.fossee.in/fossee/videos/FOSSEE_intern_Video/DSC_0006.m4v') + ), + "#default_value" => $row->testimonial_video, + '#size' => 90, + '#prefix' => '<div id="testimonial-video">', + '#suffix' => '</div>', + //"#required" => TRUE, + '#states' => array( + 'visible' => array( + ':input[name="opt_text_or_video"]' => array( + 'value' => 'V' + ) + ) + ), + ); + } + $query_s = db_select('fellows'); + $query_s->fields('fellows'); + $query_s->condition('t_id', $row->id); + $result_s = $query_s->execute(); + $num_of_fellowresults = $result_s->rowCount(); + + $form['fellows_fieldset'] = array( + '#type' => 'fieldset', + '#tree' => TRUE, + '#prefix' => '<div id="fellows-fieldset-wrapper">', + '#suffix' => '</div>' + ); + + if ($num_of_fellowresults != 0) { + + $form_state['num_fellows'] = $num_of_fellowresults; + $temp = 0; + $i = 0; + while ($row_s = $result_s->fetchObject()) { + $temp = $i; + $form['fellows_fieldset'][$i]["s_text"] = array( + "#type" => "item", + "#markup" => "<h4><label>fellows : " . ($temp + 1) . "</label></h4>" + ); + $form['fellows_fieldset'][$i]["f_id"] = array( + "#type" => "hidden", + "#default_value" => $row_s->f_id + ); + $form['fellows_fieldset'][$i]["fellowname"] = array( + "#type" => "textfield", + "#title" => "Name", + "#default_value" => $row_s->name + ); + $form['fellows_fieldset'][$i]["institute"] = array( + "#type" => "textfield", + "#title" => "Institute", + "#default_value" => $row_s->institute + ); + $form['fellows_fieldset'][$i]["place"] = array( + "#type" => "textfield", + "#title" => "Place", + "#default_value" => $row_s->place + ); + $i++; + } + + + $form["fellows_count"] = array( + "#type" => "hidden", + "#value" => $temp + ); + + } + else { + if (empty($form_state['num_fellows'])) { + $form_state['num_fellows'] = 1; + } + $temp = 0; + for ($i = 0; $i < $form_state['num_fellows']; $i++) { + $temp = $i; + $form['fellows_fieldset'][$i]["s_text"] = array( + "#type" => "item", + "#markup" => "<h4><label>fellows : " . ($temp + 1) . "</label></h4>" + ); + $form['fellows_fieldset'][$i]["fellowname"] = array( + "#type" => "textfield", + "#title" => "Name", + "#default_value" => "" + ); + $form['fellows_fieldset'][$i]["institute"] = array( + "#type" => "textfield", + "#title" => "University", + "#default_value" => "" + ); + $form['fellows_fieldset'][$i]["place"] = array( + "#type" => "textfield", + "#title" => "Place", + "#default_value" => "" + ); + + } + $form["fellows_count"] = array( + "#type" => "hidden", + "#value" => $temp + ); + $form['fellows_fieldset']['add_fellows'] = array( + '#type' => 'submit', + '#value' => t('Add fellow'), + '#limit_validation_errors' => array(), + '#submit' => array( + 'fellows_add_more_add_one' + ), + '#ajax' => array( + 'callback' => 'fellows_add_more_callback', + 'wrapper' => 'fellows-fieldset-wrapper' + ) + ); + if ($form_state['num_fellows'] > 1) { + $form['fellows_fieldset']['remove_fellows'] = array( + '#type' => 'submit', + '#value' => t('Remove'), + '#limit_validation_errors' => array(), + '#submit' => array( + 'fellows_add_more_remove_one' + ), + '#ajax' => array( + 'callback' => 'fellows_add_more_callback', + 'wrapper' => 'fellows-fieldset-wrapper' + ) + ); + } + if ($no_js_use) { + if (!empty($form['fellows_fieldset']['remove_fellows']['#ajax'])) { + unset($form['fellows_fieldset']['remove_fellows']['#ajax']); + } + unset($form['fellows_fieldset']['add_fellows']['#ajax']); + } + } + + $form["testimonial_id"] = array( + "#type" => "hidden", + "#value" => $testimonial_id + ); + $form["submit"] = array( + "#type" => "submit", + "#value" => "Submit" + ); + return $form; + } + +/*function ajax_testimonial_type($form, $form_state){ + $type = $form_state['values']['opt_text_or_video']; + if($type == 'V'){ + $commands[] = ajax_command_replace('#testimonial-video', drupal_render($form['testimonial_video'])); + $commands[] = ajax_command_html('#testimonial-text', ''); + } + else{ + $commands[] = ajax_command_replace('#testimonial-text', drupal_render($form['testimonial_text'])); + $commands[] = ajax_command_html('#testimonial-video', ''); + } + return array( + '#type' => 'ajax', + '#commands' => $commands + ); +}*/ + + function fellows_add_more_callback($form, $form_state) { + return $form['fellows_fieldset']; +} + + +function fellows_add_more_add_one($form, &$form_state) { + $form_state['num_fellows']++; + $form_state['rebuild'] = TRUE; + //$form_state['no_redirect'] = TRUE; +} + + +function fellows_add_more_remove_one($form, &$form_state) { + if ($form_state['num_fellows'] > 1) { + $form_state['num_fellows']--; + } + $form_state['rebuild'] = TRUE; +} + + function fellowship_testimonials_edit_form_validate($form, &$form_state) { + // for future use + } + + function fellowship_testimonials_edit_form_submit($form, &$form_state) { + $v = $form_state["values"]; + if($v['opt_text_or_video'] == 'V'){ + $query = db_update('fellowship_testimonials'); + $query->fields(array( + 'year' => $v["fellowship_year"], + 'fellowship_task' => $v["fellowship_task"], + 'testimonial_video' => $v["testimonial_video"] + )); + } + else if($v['opt_text_or_video'] == 'T'){ + $query = db_update('fellowship_testimonials'); + $query->fields(array( + 'year' => $v["fellowship_year"], + 'fellowship_task' => $v["fellowship_task"], + 'testimonial_text' => $v["testimonial_text"], + 'testimonial_text_format' => $v["testimonial_text_format"] + )); + } + $query->condition('id', $v["testimonial_id"]); + $result = $query->execute(); + + $fellowsupload = 0; + for ($i = 0; $i <= $v["fellows_count"]; $i++) { + $f_id=$v['fellows_fieldset'][$i]["f_id"]; + //var_dump($f_id);die; + if ($f_id != "") { + if ($v['fellows_fieldset'][$i]["fellowname"] != "") { + $query = db_update('fellows'); + $query->fields(array( + 'name' => $v['fellows_fieldset'][$i]["fellowname"], + 'institute' => $v['fellows_fieldset'][$i]["institute"], + 'place' => $v['fellows_fieldset'][$i]["place"] + )); + $query->condition('f_id', $v['fellows_fieldset'][$i]["f_id"]); + $result = $query->execute(); + if ($result != 0) { + $fellowsupload++; + } + } + } + } + if(!$result) { + drupal_set_message("Something went wrong, please try again.", "error"); + } else { + drupal_set_message("Testimonial updated successfully", "status"); + } + drupal_goto('fellowship-testimonials/edit'); + } + +function fellowship_testimonials_edit_all($testimonial_id=0) { + + $page_content = ""; + //var_dump($testimonial_id);die; + if($testimonial_id){ + + $fellowship_testimonials_edit_form = drupal_get_form("fellowship_testimonials_edit_form", $testimonial_id); + $page_content .= drupal_render($fellowship_testimonials_edit_form); + } else { + $query = db_select('fellowship_testimonials'); + $query->fields('fellowship_testimonials'); + // $query->orderBy('time', 'DESC'); + //$query->condition('id', $speakerrow->t_id); + $result = $query->execute(); + + $headers = array( + "Name", "Institute", "Type", "Action" + ); + + $rows = array(); + while($row = $result->fetchObject()) { + $speakerquery = db_query("SELECT GROUP_CONCAT(name separator ', ') as name, GROUP_CONCAT(institute separator ', ') as institute FROM fellows WHERE t_id = :t_id GROUP BY t_id", array( + ":t_id" => $row->id + )); + if($row->testimonial_type == 'T'){ + $testimonial_type = "Text"; + } + else{ + $testimonial_type = "Video"; + } + /*$speakerquery = db_select('fellows'); + $speakerquery->fields('fellows'); + $speakerquery->condition('t_id', $row->id); + $speakerresult = $speakerquery->execute();*/ + while($speakerrow = $speakerquery->fetchObject()){ + $fellow_name = $speakerrow->name; + $institute = $speakerrow->institute; + } + //$speakerrow = $speakerresult->fetchObject(); + $item = array( + $fellow_name, + $institute, + $testimonial_type, + l("Edit", "fellowship-testimonials/edit/{$row->id}") + // l("Delete", "fellowship-testimonials/delete/{$row->id}") + ); + array_push($rows, $item); + //} + } + //$page_content .= theme("table", $headers, $rows); + $page_content .= theme('table', array('header' => $headers, 'rows' => $rows )); + } + return $page_content; + } |