function view_submissions()
{
$db = JFactory::getDBO();
$form_id = JRequest::getVar('form_id');
$after_save = JRequest::getVar('after_save', 0);
$paypal = 0;
$query = "SELECT DISTINCT `element_label` FROM #__formmaker_submits WHERE form_id='" . $db->escape((int) $form_id) . "'";
$db->setQuery($query);
$labels = $db->loadColumn();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
$query = "SELECT id FROM #__formmaker_sessions where form_id=" . $db->escape((int) $form_id);
$db->setQuery($query);
$paypal_info = $db->loadObject();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
if ($paypal_info) {
$paypal = 1;
}
$sorted_labels_id = array();
$label_titles = array();
$sorted_labels_type = array();
if ($labels) {
$label_id = array();
$label_order = array();
$label_order_original = array();
$label_type = array();
$this_form = JTable::getInstance('formmaker', 'Table');
$this_form->load($form_id);
if (strpos($this_form->label_order, 'type_paypal_')) {
$this_form->label_order = $this_form->label_order . "item_total#**id**#Item Total#**label**#type_paypal_payment_total#****#total#**id**#Total#**label**#type_paypal_payment_total#****#0#**id**#Payment Status#**label**#type_paypal_payment_status#****#";
}
$label_all = explode('#****#', $this_form->label_order);
$label_all = array_slice($label_all, 0, count($label_all) - 1);
foreach ($label_all as $key => $label_each) {
$label_id_each = explode('#**id**#', $label_each);
array_push($label_id, $label_id_each[0]);
$label_order_each = explode('#**label**#', $label_id_each[1]);
array_push($label_order_original, $label_order_each[0]);
array_push($label_type, $label_order_each[1]);
}
foreach ($label_id as $key => $label) {
if (in_array($label, $labels)) {
array_push($sorted_labels_type, $label_type[$key]);
array_push($sorted_labels_id, $label);
array_push($label_titles, $label_order_original[$key]);
}
}
}
HTML_contact::view_submissions($label_titles, $form_id, $sorted_labels_id, $sorted_labels_type, $after_save, $paypal);
}
