' . esc_attr__( 'This will erase all Answers who people given to this survey. Do you really want to delete all results of this survey?', 'questions-locale' ) . '
' . count( $users ) . ' ' . esc_attr__( 'participiant/s', 'questions-locale' ) . '
'; $html .= '| ' . esc_attr__( 'ID', 'questions-locale' ) . ' | '; $html .= '' . esc_attr__( 'User nicename', 'questions-locale' ) . ' | '; $html .= '' . esc_attr__( 'Display name', 'questions-locale' ) . ' | '; $html .= '' . esc_attr__( 'Email', 'questions-locale' ) . ' | '; $html .= '' . esc_attr__( 'Status', 'questions-locale' ) . ' | '; $html .= ''; $html .= ' |
|---|---|---|---|---|---|
| ' . $user->ID . ' | '; $html .= '' . $user->user_nicename . ' | '; $html .= '' . $user->display_name . ' | '; $html .= '' . $user->user_email . ' | '; $html .= '' . $user_text . ' | '; $html .= '' . esc_attr__( 'Delete', 'questions-locale' ) . ''; $html .= ' |
' . esc_attr__( 'You can invite Participiants to this survey after the survey is published.', 'questions-locale' ) . '
'; endif; echo $html; } /** * Saving data * * @param int $form_id * @since 1.0.0 */ public static function save_form( $form_id ) { global $questions_global, $wpdb; if ( !array_key_exists( 'questions', $_REQUEST ) ) { return; } if ( array_key_exists( 'questions-duplicate-survey', $_REQUEST ) ) { return; } if ( wp_is_post_revision( $form_id ) ) { return; } if ( ! array_key_exists( 'post_type', $_POST ) ) { return; } if ( 'questions' != $_POST[ 'post_type' ] ) { return; } $survey_elements = $_POST[ 'questions' ]; $survey_deleted_formelements = $_POST[ 'questions_deleted_formelements' ]; $survey_deleted_answers = $_POST[ 'questions_deleted_answers' ]; $survey_participiant_restrictions = $_POST[ 'questions_participiants_restrictions_select' ]; $survey_show_results = $_POST[ 'show_results' ]; $questions_participiants = $_POST[ 'questions_participiants' ]; $start_date = $_POST[ 'start_date' ]; $end_date = $_POST[ 'end_date' ]; /** * Saving Restrictions */ update_post_meta( $form_id, 'participiant_restrictions', $survey_participiant_restrictions ); /** * Saving if results have to be shown after participating */ update_post_meta( $form_id, 'show_results', $survey_show_results ); /** * Saving start and end date */ update_post_meta( $form_id, 'start_date', $start_date ); update_post_meta( $form_id, 'end_date', $end_date ); $survey_deleted_formelements = explode( ',', $survey_deleted_formelements ); /** * Deleting deleted answers */ if ( is_array( $survey_deleted_formelements ) && count( $survey_deleted_formelements ) > 0 ): foreach ( $survey_deleted_formelements AS $deleted_question ): $wpdb->delete( $questions_global->tables->questions, array( 'id' => $deleted_question ) ); $wpdb->delete( $questions_global->tables->answers, array( 'question_id' => $deleted_question ) ); endforeach; endif; $survey_deleted_answers = explode( ',', $survey_deleted_answers ); /* * Deleting deleted answers */ if ( is_array( $survey_deleted_answers ) && count( $survey_deleted_answers ) > 0 ): foreach ( $survey_deleted_answers AS $deleted_answer ): $wpdb->delete( $questions_global->tables->answers, array( 'id' => $deleted_answer ) ); endforeach; endif; /* * Saving elements */ foreach ( $survey_elements AS $key => $survey_question ): if ( 'widget_formelement_XXnrXX' == $key ) { continue; } $question_id = (int) $survey_question[ 'id' ]; $question = ''; $sort = (int) $survey_question[ 'sort' ]; $type = $survey_question[ 'type' ]; if ( array_key_exists( 'question', $survey_question ) ) { $question = qu_prepare_post_data( $survey_question[ 'question' ] ); } $answers = array(); $settings = array(); if ( array_key_exists( 'answers', $survey_question ) ) { $answers = $survey_question[ 'answers' ]; } if ( array_key_exists( 'settings', $survey_question ) ) { $settings = $survey_question[ 'settings' ]; } // Saving question if ( '' != $question_id ): // Updating if question already exists $wpdb->update( $questions_global->tables->questions, array( 'question' => $question, 'sort' => $sort, 'type' => $type ), array( 'id' => $question_id ) ); else: // Adding new question $wpdb->insert( $questions_global->tables->questions, array( 'questions_id' => $form_id, 'question' => $question, 'sort' => $sort, 'type' => $type ) ); $question_id = $wpdb->insert_id; endif; do_action( 'questions_save_form_after_saving_question', $survey_question, $question_id ); /* * Saving answers */ if ( is_array( $answers ) && count( $answers ) > 0 ): foreach ( $answers AS $answer ): $answer_id = (int) $answer[ 'id' ]; $answer_text = qu_prepare_post_data( $answer[ 'answer' ] ); $answer_sort = (int) $answer[ 'sort' ]; $answer_section = ''; if ( array_key_exists( 'section', $answer ) ) { $answer_section = $answer[ 'section' ]; } if ( '' != $answer_id ): $wpdb->update( $questions_global->tables->answers, array( 'answer' => $answer_text, 'section' => $answer_section, 'sort' => $answer_sort ), array( 'id' => $answer_id ) ); else: $wpdb->insert( $questions_global->tables->answers, array( 'question_id' => $question_id, 'answer' => $answer_text, 'section' => $answer_section, 'sort' => $answer_sort ) ); $answer_id = $wpdb->insert_id; endif; do_action( 'questions_save_form_after_saving_answer', $survey_question, $answer_id ); endforeach; endif; /* * Saving question settings */ if ( is_array( $settings ) && count( $settings ) > 0 ): foreach ( $settings AS $name => $setting ): $sql = $wpdb->prepare( "SELECT COUNT(*) FROM {$questions_global->tables->settings} WHERE question_id = %d AND name = %s", $question_id, $name ); $count = $wpdb->get_var( $sql ); if ( $count > 0 ): $wpdb->update( $questions_global->tables->settings, array( 'value' => qu_prepare_post_data( $settings[ $name ] ) ), array( 'question_id' => $question_id, 'name' => $name ) ); else: $wpdb->insert( $questions_global->tables->settings, array( 'name' => $name, 'question_id' => $question_id, 'value' => qu_prepare_post_data( $settings[ $name ] ) ) ); endif; endforeach; endif; endforeach; $questions_participiant_ids = explode( ',', $questions_participiants ); $sql = "DELETE FROM {$questions_global->tables->participiants} WHERE survey_id = %d"; $sql = $wpdb->prepare( $sql, $form_id ); $wpdb->query( $sql ); if ( is_array( $questions_participiant_ids ) && count( $questions_participiant_ids ) > 0 ): foreach ( $questions_participiant_ids AS $user_id ): $wpdb->insert( $questions_global->tables->participiants, array( 'survey_id' => $form_id, 'user_id' => $user_id ) ); endforeach; endif; do_action( 'questions_save_form', $form_id ); // Preventing duplicate saving remove_action( 'save_post', array( __CLASS__, 'save_form' ), 50 ); } /** * Delete form * * @param int $form_id * @since 1.0.0 */ public static function delete_form( $form_id ) { $form = new Questions_Form( $form_id ); $form->delete(); } /** * Adding user by AJAX * * @since 1.0.0 */ public static function ajax_add_members() { $users = get_users( array( 'orderby' => 'ID' ) ); $return_array = array(); foreach ( $users AS $user ): $return_array[ ] = array( 'id' => $user->ID, 'user_nicename' => $user->user_nicename, 'display_name' => $user->display_name, 'user_email' => $user->user_email, ); endforeach; echo json_encode( $return_array ); die(); } /** * Invite participiants AJAX * * @since 1.0.0 */ public static function ajax_invite_participiants() { global $wpdb, $questions_global; $return_array = array( 'sent' => FALSE ); $form_id = $_POST[ 'form_id' ]; $subject_template = $_POST[ 'subject_template' ]; $text_template = $_POST[ 'text_template' ]; $sql = "SELECT user_id FROM {$questions_global->tables->participiants} WHERE survey_id = %d"; $sql = $wpdb->prepare( $sql, $form_id ); $user_ids = $wpdb->get_col( $sql ); if ( 'reinvite' == $_POST[ 'invitation_type' ] ): $user_ids_new = ''; if ( is_array( $user_ids ) && count( $user_ids ) > 0 ): foreach ( $user_ids AS $user_id ): if ( ! qu_user_has_participated( $form_id, $user_id ) ): $user_ids_new[ ] = $user_id; endif; endforeach; endif; $user_ids = $user_ids_new; endif; $post = get_post( $form_id ); if ( is_array( $user_ids ) && count( $user_ids ) > 0 ): $users = get_users( array( 'include' => $user_ids, 'orderby' => 'ID', ) ); $content = str_replace( '%site_name%', get_bloginfo( 'name' ), $text_template ); $content = str_replace( '%survey_title%', $post->post_title, $content ); $content = str_replace( '%survey_url%', get_permalink( $post->ID ), $content ); $subject = str_replace( '%site_name%', get_bloginfo( 'name' ), $subject_template ); $subject = str_replace( '%survey_title%', $post->post_title, $subject ); $subject = str_replace( '%survey_url%', get_permalink( $post->ID ), $subject ); foreach ( $users AS $user ): if ( '' != $user->data->display_name ) { $display_name = $user->data->display_name; } else { $display_name = $user->data->user_nicename; } $user_nicename = $user->data->user_nicename; $user_email = $user->data->user_email; $subject_user = str_replace( '%displayname%', $display_name, $subject ); $subject_user = str_replace( '%username%', $user_nicename, $subject_user ); $content_user = str_replace( '%displayname%', $display_name, $content ); $content_user = str_replace( '%username%', $user_nicename, $content_user ); qu_mail( $user_email, $subject_user, stripslashes( $content_user ) ); endforeach; $return_array = array( 'sent' => TRUE ); endif; echo json_encode( $return_array ); die(); } /** * Dublicating survey AJAX * * @since 1.0.0 */ public static function ajax_duplicate_form() { $form_id = $_REQUEST[ 'form_id' ]; $form = get_post( $form_id ); if ( 'questions' != $form->post_type ) { return; } $form = new Questions_Form( $form_id ); $new_form_id = $form->duplicate( TRUE, TRUE, FALSE, TRUE, TRUE, TRUE, TRUE ); $post = get_post( $new_form_id ); $response = array( 'survey_id' => $new_form_id, 'post_title' => $post->post_title, 'admin_url' => site_url( '/wp-admin/post.php?post=' . $new_form_id . '&action=edit' ) ); echo json_encode( $response ); die(); } /** * Deleting survey responses * * @since 1.0.0 */ public static function ajax_delete_responses() { $form_id = $_REQUEST[ 'form_id' ]; $form = get_post( $form_id ); if ( 'questions' != $form->post_type ) { return; } $form = new Questions_form( $form_id ); $new_form_id = $form->delete_responses(); $response = array( 'survey_id' => $form_id, 'deleted' => TRUE ); echo json_encode( $response ); die(); } /** * Cheks if we are in correct post type * * @return boolean $is_questions_post_type * @since 1.0.0 */ private static function is_questions_post_type() { global $post; // If there is no post > stop adding scripts if ( ! isset( $post ) ) { return FALSE; } // If post type is wrong > stop adding scripts if ( 'questions' != $post->post_type ) { return FALSE; } return TRUE; } /** * Adds the message area to the edit post site * @since 1.0.0 */ public static function jquery_messages_area(){ $max_input_vars = ini_get( 'max_input_vars' ); $html = ''; // Updated, error, notice echo $html; } /** * Enqueue admin scripts * * @since 1.0.0 */ public static function enqueue_scripts() { if ( ! self::is_questions_post_type() ) return; $translation_admin = array( 'delete' => esc_attr__( 'Delete', 'questions-locale' ), 'yes' => esc_attr__( 'Yes', 'questions-locale' ), 'no' => esc_attr__( 'No', 'questions-locale' ), 'just_added' => esc_attr__( 'just added', 'questions-locale' ), 'invitations_sent_successfully' => esc_attr__( 'Invitations sent successfully!', 'questions-locale' ), 'invitations_not_sent_successfully' => esc_attr__( 'Invitations could not be sent!', 'questions-locale' ), 'reinvitations_sent_successfully' => esc_attr__( 'Renvitations sent successfully!', 'questions-locale' ), 'reinvitations_not_sent_successfully' => esc_attr__( 'Renvitations could not be sent!', 'questions-locale' ), 'deleted_results_successfully' => esc_attr__( 'Survey results deleted successfully!', 'questions-locale' ), 'duplicate_form_successfully' => esc_attr__( 'Survey duplicated successfully!', 'questions-locale' ), 'edit_survey' => esc_attr__( 'Edit Survey', 'questions-locale' ), 'added_participiants' => esc_attr__( 'participiant/s', 'questions-locale' ), 'max_fields_near_limit' => esc_attr__( 'You are under 50 form fields away from reaching PHP max_num_fields!', 'questions-locale' ), 'max_fields_over_limit' => esc_attr__( 'You are over the limit of PHP max_num_fields!', 'questions-locale' ), 'max_fields_todo' => esc_attr__( 'Please increase the value by addingphp_value max_input_vars [NUMBER OF INPUT VARS] in your htaccess or contact your hoster. Otherwise your form can not be saved correct.', 'questions-locale' ),
'of' => esc_attr__( 'of', 'questions-locale' ),
'dateformat' => esc_attr__( 'yy/mm/dd', 'questions-locale' ),
'min_sun' => esc_attr__( 'Su', 'questions-locale' ),
'min_mon' => esc_attr__( 'Mo', 'questions-locale' ),
'min_tue' => esc_attr__( 'Tu', 'questions-locale' ),
'min_wed' => esc_attr__( 'We', 'questions-locale' ),
'min_thu' => esc_attr__( 'Th', 'questions-locale' ),
'min_fri' => esc_attr__( 'Fr', 'questions-locale' ),
'min_sat' => esc_attr__( 'Sa', 'questions-locale' ),
'january' => esc_attr__( 'January', 'questions-locale' ),
'february' => esc_attr__( 'February', 'questions-locale' ),
'march' => esc_attr__( 'March', 'questions-locale' ),
'april' => esc_attr__( 'April', 'questions-locale' ),
'may' => esc_attr__( 'May', 'questions-locale' ),
'june' => esc_attr__( 'June', 'questions-locale' ),
'july' => esc_attr__( 'July', 'questions-locale' ),
'august' => esc_attr__( 'August', 'questions-locale' ),
'september' => esc_attr__( 'September', 'questions-locale' ),
'october' => esc_attr__( 'October', 'questions-locale' ),
'november' => esc_attr__( 'November', 'questions-locale' ),
'december' => esc_attr__( 'December', 'questions-locale' ),
);
wp_enqueue_script( 'admin-questions-post-type', QUESTIONS_URLPATH . '/components/admin/includes/js/admin-questions-post-type.js' );
wp_enqueue_script( 'jquery-ui-draggable' );
wp_enqueue_script( 'jquery-ui-droppable' );
wp_enqueue_script( 'jquery-ui-dialog' );
wp_enqueue_script( 'jquery-ui-tabs' );
wp_enqueue_script( 'jquery-ui-datepicker');
wp_enqueue_script( 'admin-widgets' );
wp_enqueue_script( 'wpdialogs-popup' );
wp_enqueue_style( 'jquery-style', QUESTIONS_URLPATH . '/components/admin/includes/css/datepicker.css' );
wp_localize_script( 'admin-questions-post-type', 'translation_admin', $translation_admin );
if ( wp_is_mobile() ) {
wp_enqueue_script( 'jquery-touch-punch' );
}
}
}
Questions_FormBuilder::init();