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>
