function SMC_displayRecords($meetingID) { global $wpdb; global $SMC_plugin_table; global $SMC_reqguests; global $SMC_plugin_name; $outputHTML = ""; $sqlQuery = 'SELECT * FROM ' . $SMC_plugin_table . ' WHERE meetingID="' . $meetingID . '" ;'; $resultData = $wpdb->get_results($sqlQuery); $outputHTML .= '<table>'; $outputHTML .= '<th>' . __('Name', $SMC_plugin_name) . '</th>'; $outputHTML .= '<th>' . __('Present', $SMC_plugin_name) . '</th>'; if ($SMC_reqguests == 'true') { $outputHTML .= '<th>' . __('Number', $SMC_plugin_name) . '</th>'; } $outputHTML .= '<th>' . __('Comments', $SMC_plugin_name) . '</th>'; foreach ($resultData as $row) { $outputHTML .= '<tr>'; $outputHTML .= '<td>' . esc_html($row->userName) . '</td>'; $outputHTML .= '<td>'; if ($row->answer == 'checked') { $outputHTML .= __('Yes', $SMC_plugin_name); } else { $outputHTML .= __('No', $SMC_plugin_name); } $outputHTML .= '</td>'; if ($SMC_reqguests == 'true') { $outputHTML .= '<td>' . $row->nbParticipants . '</td>'; } $outputHTML .= '<td>' . esc_html($row->comments) . '</td>'; $outputHTML .= '</tr>'; } $outputHTML .= '<tr>'; $outputHTML .= '<th><b>' . __('Total ', $SMC_plugin_name) . '</b></th>'; if ($SMC_reqguests == 'true') { $outputHTML .= '<td></td>'; $outputHTML .= '<td><b>' . SMC_countRecords($meetingID, null, false, true) . '</b></td>'; } else { $outputHTML .= '<td><b>' . SMC_countRecords($meetingID, null, true, false) . '/' . SMC_countRecords($meetingID, null, false, false) . '</b></td>'; } $outputHTML .= '<td></td>'; $outputHTML .= '</tr>'; $outputHTML .= '</table>'; $outputHTML .= '<hr>'; return $outputHTML; }
function SMC_main($atts, $content = null) { global $meta; global $SMC_date; global $SMC_location; global $SMC_reqguests; global $SMC_description; global $SMC_displayresults; global $SMC_usersonly; global $SMC_expireson; global $SMC_plugin_name; $output = ""; $output .= '<link rel="stylesheet" type="text/css" href="' . plugin_dir_url(__FILE__) . 'simplemeetingconfirmation.css" />'; // load custom variables SMC_loadShortCodeParameters($atts); // check if SMC_Date field was filled, if so, display meeting information if ($SMC_date == '') { $output .= SMC_display_error_message('dateMissing'); return $output; } // check if page was posted back if (@$_POST['hidUpdate'] == true) { if ($_POST['txtDate'] == $SMC_date) { if ($_POST['hidError'] != '') { $output .= SMC_display_error_message($_POST['hidError']); } else { if (SMC_countRecords($_POST['txtDate'], $_POST['txtUser'], false, false) > 0) { if (wp_get_current_user()->display_name != "") { // update existing record if registered user SMC_updateRegisteredUserToMeeting($_POST['txtUser'], $_POST['txtDate'], @$_POST['chkPresent'], @$_POST['txtNbGuests'], $_POST['txtComments']); } else { // do not update if the name already exists for open event entry } } else { // new record SMC_addRegisteredUserToMeeting($_POST['txtDate'], $_POST['txtUser'], @$_POST['chkPresent'], @$_POST['txtNbGuests'], $_POST['txtComments']); } } } } // load data into a record $row_data = SMC_loadUserData($SMC_date, @$_POST['txtUser']); $output .= '<script src="' . plugin_dir_url(__FILE__) . 'simplemeetingconfirmation.js" type="text/javascript"></script>'; if ($SMC_displayresults == 'true') { $output .= SMC_displayRecords($SMC_date); } if ($SMC_usersonly == "true" && wp_get_current_user()->display_name == "") { $output .= "<p>" . __("If you are logged in you can sign up", $SMC_plugin_name) . ".</p>"; } else { $output .= '<form name="frmSMCRegistration" method="post" action="' . get_permalink() . '"> <table border="2" width="80%"> <tbody>'; if ($SMC_description != '') { $output .= '<tr>'; $output .= '<th>' . __('Event', $SMC_plugin_name) . ':</th>'; $output .= '<td colspan="' . ($content != null ? 1 : 2) . '">' . $SMC_description . '</td>'; $output .= '</tr>'; } $output .= '<tr> <th>' . __('Date (dd/mm/yyyy)', $SMC_plugin_name) . ':</th> <td colspan="' . ($content != null ? 1 : 2) . '">' . $SMC_date . '</td> <input type="hidden" name="txtDate" value="' . $SMC_date . '">'; if ($content != null) { $i = 3; // for default fields (date, Present, submit button) if ($SMC_description != '') { $i++; } if ($SMC_location != '') { $i++; } if ($SMC_reqguests == 'true') { $i++; } if ($SMC_expireson != '') { if (date('d/m/Y') > date($SMC_expireson)) { $i = 4; // already expired, display limited number of fields } } $output .= '<td align="center" rowspan="' . $i . '">' . $content . '</td>'; } $output .= '</tr>'; if ($SMC_location != '') { $output .= '<tr>'; $output .= '<th>' . __('Location', $SMC_plugin_name) . ':</th>'; $output .= '<td colspan="' . ($content != null ? 1 : 2) . '">' . $SMC_location . '</td>'; $output .= '</tr>'; } if ($SMC_expireson == '' || date('d/m/Y') <= date($SMC_expireson)) { $output .= '<tr> <th>' . __('Name', $SMC_plugin_name) . ':</th> <td colspan="' . ($content != null ? 1 : 2) . '">'; if ($SMC_usersonly == 'true') { $output .= wp_get_current_user()->display_name; $output .= '<input type="hidden" name="txtUser" value="' . esc_attr(wp_get_current_user()->display_name) . '">'; } else { $public_username = @$_POST['txtUser']; if ($public_username == "") { $public_username = wp_get_current_user()->display_name; } $output .= '<input type="text" name="txtUser" onBlur="this.value=trim(this.value)" value="' . esc_attr($public_username) . '">'; } $output .= '</td> </tr> <tr> <th>' . __('Present', $SMC_plugin_name) . ':</th> <td colspan="' . ($content != null ? 1 : 2) . ' align="center"><input type="checkbox" checked="checked" name="chkPresent" ' . @$row_data->answer . '></td> </tr>'; if ($SMC_reqguests == 'true') { $output .= '<tr>'; $output .= '<th>' . __('Number of people', $SMC_plugin_name) . ':</th>'; $output .= '<td colspan="' . ($content != null ? 1 : 2) . '"><input type="textbox" name="txtNbGuests" value="' . @$row_data->nbParticipants . '"></td>'; $output .= '</tr>'; } $output .= '<tr> <th>' . __('Comments', $SMC_plugin_name) . ':</th> <td colspan="2"><textarea name="txtComments" rows="5" cols="20">' . @$row_data->comments . '</textarea></td> </tr> <tr>'; } if ($SMC_expireson != '') { $output .= '<th>' . __('Please reply before', $SMC_plugin_name) . ':</th>'; $output .= '<td>' . $SMC_expireson . '</td>'; } else { $output .= '<th></th>'; } if ($SMC_expireson == '' || date('d/m/Y') <= date($SMC_expireson)) { $output .= '<td colspan="' . ($SMC_expireson != '' ? 1 : 2) . '" align="right"><input type="submit" onClick="checkFields();" name="cmdSubmit" value="' . __('Submit', $SMC_plugin_name) . '" ></td>'; } $output .= '</tr> </tbody> </table> <input name="hidUpdate" type="hidden" value="true"> <input name="hidError" type="hidden" value=""> </form>'; } return $output; }