public function get_job_stat($form_id) { $job = new stdClass(); $job->total = RM_Job_Manager::get_job_total($form_id); if ($job->total === null) { $job->is_job_running = false; $job->offset = null; $job->started_on = null; } else { $job->is_job_running = true; $job->offset = RM_Job_Manager::get_job_offset($form_id); $start_time = RM_Job_Manager::get_job_starting_time($form_id); $job->started_on = RM_Utilities::localize_time($start_time, 'd M Y'); } return $job; }
public function display($model, $service, $request, $params) { $data = new stdClass(); $submissions = $service->get('SUBMISSIONS', 1, null, 'results', 0, 10, '*', 'submitted_on', true); $sub_data = array(); $count = 0; if ($submissions) { foreach ($submissions as $submission) { //echo "<br>ID: ".$submission->form_id." : ".RM_Utilities::localize_time($submission->submitted_on, 'M dS Y, h:ia')." : "; $name = $service->get('FORMS', array('form_id' => $submission->form_id), array('%d'), 'var', 0, 10, 'form_name'); $date = RM_Utilities::localize_time($submission->submitted_on, 'M dS Y, h:ia'); $payment_status = $service->get('PAYPAL_LOGS', array('submission_id' => $submission->submission_id), array('%d'), 'var', 0, 10, 'status'); $sub_data[] = (object) array('submission_id' => $submission->submission_id, 'name' => $name, 'date' => $date, 'payment_status' => $payment_status); $count++; } } $data->submissions = $sub_data; $data->total_sub = $count; $view = $this->mv_handler->setView("dashboard_widget"); $view->render($data); }
public function widget($model, RM_User_Services $service, $request, $params) { if ($params['user'] instanceof WP_User) { $data = new stdClass(); $submissions = $service->get_submissions_by_email($params['user']->user_email, 10); $sub_data = array(); $count = 0; if ($submissions) { foreach ($submissions as $submission) { //echo "<br>ID: ".$submission->form_id." : ".RM_Utilities::localize_time($submission->submitted_on, 'M dS Y, h:ia')." : "; $name = $service->get('FORMS', array('form_id' => $submission->form_id), array('%d'), 'var', 0, 10, 'form_name'); $date = RM_Utilities::localize_time($submission->submitted_on, 'M dS Y, h:ia'); $payment_status = $service->get('PAYPAL_LOGS', array('submission_id' => $submission->submission_id), array('%d'), 'var', 0, 10, 'status'); $sub_data[] = (object) array('submission_id' => $submission->submission_id, 'name' => $name, 'date' => $date, 'payment_status' => $payment_status); $count++; } } $data->submissions = $sub_data; $data->total_sub = $count; $view = $this->mv_handler->setView('user_edit_widget'); $view->render($data); } }
?> </th> <th><?php echo RM_UI_Strings::get('LABEL_SUBMITTED_ON'); ?> </th> <th><?php echo RM_UI_Strings::get('LABEL_TIME_TAKEN'); ?> </th> <?php $i = $data->starting_serial_number; foreach ($data->stat_data as $stat) { $visited_on = RM_Utilities::convert_to_mysql_timestamp($stat->visited_on); $visited_on = RM_Utilities::localize_time($visited_on, 'd M Y, h:ia'); if ($stat->submitted_on) { if ($stat->submitted_on == 'banned') { $submitted_on = RM_UI_Strings::get('LABEL_BANNED_SUBMISSIONS'); } else { $submitted_on = RM_Utilities::convert_to_mysql_timestamp($stat->submitted_on); } } else { $submitted_on = null; } ?> <tr> <td><?php echo $i; ?> </td>
<a href="?page=rm_submission_manage&rm_form_id=<?php echo $entry->form_id; ?> ">(<?php echo $subcount_display; ?> )</a></b></div> <?php if ($entry->count > 0) { foreach ($entry->submissions as $submission) { ?> <div class="rm-last-submission"> <?php echo $submission->gravatar . ' ' . RM_Utilities::localize_time($submission->submitted_on); ?> </div> <?php } } else { echo '<div class="rm-last-submission">' . RM_UI_Strings::get('MSG_NO_SUBMISSION') . '</div>'; } ?> <?php if ($entry->expiry_details->state == 'expired') { echo "<div class='rm-form-expiry-info'>" . RM_UI_Strings::get('LABEL_FORM_EXPIRED') . "</div>"; } else { if ($entry->expiry_details->state == 'not_expired' && $entry->expiry_details->criteria != 'subs') { if ($entry->expiry_details->remaining_days < 26) { echo "<div class='rm-form-expiry-info'>" . sprintf(RM_UI_Strings::get('LABEL_FORM_EXPIRES_IN'), $entry->expiry_details->remaining_days) . "</div>";
?> </div> <?php foreach ($data->notes as $note) { ?> <div class="rm-submission-note" style="border-left: 4px solid #<?php echo maybe_unserialize($note->note_options)->bg_color; ?> "> <div class="rm-submission-note-text"><?php echo $note->notes; ?> </div> <div class="rm-submission-note-attribute"> <?php echo RM_UI_Strings::get('LABEL_CREATED_BY') . " <b>" . $note->author . "</b> <em>" . RM_Utilities::localize_time($note->publication_date) . "</em>"; if ($note->editor) { echo " (" . RM_UI_Strings::get('LABEL_EDITED_BY') . " <b>" . $note->editor . "</b> <em>" . RM_Utilities::localize_time($note->last_edit_date) . "</em>"; } ?> </div> </div> <?php } ?> </div> <?php } ?> </div>
public function get_submissions_to_export($form_id, $is_searched = false, $search = null) { $export_data = array(); $is_payment = false; $option = new RM_Options(); if (!(int) $form_id) { return false; } $fields = $this->get_all_form_fields($form_id); if (!$fields) { return false; } $field_ids = array(); foreach ($fields as $field) { if ($field->field_type != 'Price' && $field->field_type != 'HTMLH' && $field->field_type != 'HTMLP') { $field_ids[] = $field->field_id; $export_data[0][$field->field_id] = $field->field_label; } $i = 0; if ($field->field_type == 'price' && $i == 0) { $is_payment = true; $export_data[0]['invoice'] = 'Payment Invoice'; $export_data[0]['txn_id'] = 'Payment TXN Id'; $export_data[0]['status'] = 'Payment Status'; $export_data[0]['total_amount'] = 'Paid Amount'; $export_data[0]['date'] = 'Date of Payment'; $i++; } } if (!$is_searched && !$search instanceof stdClass) { $submission_ids = $this->get('SUBMISSIONS', array('form_id' => $form_id), array('%d'), 'col', 0, 999999, 'submission_id', null, true); if (!$submission_ids) { return false; } $submissions = RM_DBManager::get_results_for_array('SUBMISSION_FIELDS', 'field_id', $field_ids); } else { $submission_ids = RM_DBManager::get_results_for_last_col($search->interval, $form_id, $search->id, $search->value); if (!$submission_ids) { return false; } $submissions = RM_DBManager::get_sub_fields_for_array('SUBMISSION_FIELDS', 'field_id', $field_ids, 'submission_id', $submission_ids); } foreach ($submission_ids as $s_id) { $export_data[$s_id] = array(); $payment = $this->get('PAYPAL_LOGS', array('submission_id' => $s_id), array('%d'), 'row', 0, 10, '*', null, true); foreach ($field_ids as $f_id) { $export_data[$s_id][$f_id] = null; } if ($is_payment) { $export_data[$s_id]['invoice'] = isset($payment->invoice) ?: null; $export_data[$s_id]['txn_id'] = isset($payment->txn_id) ?: null; $export_data[$s_id]['status'] = isset($payment->status) ?: null; $export_data[$s_id]['total_amount'] = isset($payment->total_amount) ? $option->get_formatted_amount($payment->total_amount, $payment->currency) : null; $export_data[$s_id]['date'] = isset($payment->posted_date) ? RM_Utilities::localize_time($payment->posted_date, get_option('date_format')) : null; } } foreach ($submissions as $submission) { $value = maybe_unserialize($submission->value); if (is_array($value)) { if (isset($value['rm_field_type']) && $value['rm_field_type'] == 'File') { unset($value['rm_field_type']); if (count($value) == 0) { $value = null; } else { $file = array(); foreach ($value as $a) { $file[] = wp_get_attachment_url($a); } $value = implode(',', $file); } } else { $value = implode(',', $value); } } if (array_key_exists($submission->submission_id, $export_data)) { $export_data[$submission->submission_id][$submission->field_id] = stripslashes($value); } } return $export_data; }
</th> <th><?php echo RM_UI_Strings::get('LABEL_TXN_ID'); ?> </th> <th><?php echo RM_UI_Strings::get('LABEL_STATUS'); ?> </th> </tr> <?php for ($i = $data->offset_pay; $i < $data->end_offset_this_page; $i++) { ?> <tr> <td><?php echo RM_Utilities::localize_time($data->payments[$i]->posted_date, $data->date_format); ?> </td> <td><a href="?submission_id=<?php echo $data->payments[$i]->submission_id; ?> "><?php echo $data->form_names[$data->payments[$i]->submission_id]; ?> </a></td> <td><?php echo $data->payments[$i]->total_amount; ?> </td> <td><?php echo $data->payments[$i]->txn_id;
?> :</td> <td class="rm-submission-value"><?php if (isset($data->payment->total_amount)) { echo $data->payment->total_amount; } ?> </td> </tr> <tr class="rm-submission-field-row"> <td class="rm-submission-label"><?php echo RM_UI_Strings::get('LABEL_DATE_OF_PAYMENT'); ?> :</td> <td class="rm-submission-value"><?php if (isset($data->payment->posted_date)) { echo RM_Utilities::localize_time($data->payment->posted_date, get_option('date_format')); } ?> </td> </tr> <?php } ?> </table> </div> </body> </html>