• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Display Paypal Status in Submissions Directory

Display Paypal Status in Submissions Directory 10 years 3 months ago #30123

  • yaani
  • yaani's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Thank you received: 4
I am trying to figure out how to display the Paypal Status (Accepted or Pending) in the submission directory.

I have the Menu Item>Submissions Directory parameter "Show only confirmed submissions" to "No".

I can see the Paypal Status (Accepted or Pending) in the Manage Submissions in the admin back end.

I have "PayPal Status" box checked in "Choose which columns to show" (Manage Submissions tab).

In the Manage Directories>Directory Fields I don't see PayPal status in any of the columns. How do I display the Paypal status?

Thanks for any help anyone can offer.
Last Edit: 10 years 3 weeks ago by yaani.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 2 months ago #30305

solved this problem? I am also interested in this
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 1 month ago #30639

I'm looking for the same option.

I've been able to show the PayPal status on the detail screen using the {_STATUS:value} variable, but there's no way that I've found to use it as a filter for the directory, or the CSV export (which I'm also interested in).

Any suggestions are appreciated.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 3 weeks ago #30929

I also would like to know how to do this - this is THE REASON I'm making a submissions directory - so my fundraising team can see which orders are paid. I want them to be able to do this from the front end.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 3 weeks ago #30940

  • yaani
  • yaani's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Thank you received: 4
I have got it working on a website

I added a Hidden Field _STATUS in the form in Manage Forms>Form Fields

In Manage Directories<Directory Fields I checked all the boxes (Show in Listing, Searchable, Editable, Show in Details & Export to CVS)

See screen shots in links below

www.dropbox.com/s/1tdc77shiypoubn/Screen...%2012.48.54.png?dl=0
www.dropbox.com/s/vrdqvpkw7gxyvs0/Screen...%2012.50.40.png?dl=0
Last Edit: 10 years 3 weeks ago by yaani.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 3 weeks ago #30941

  • yaani
  • yaani's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 41
  • Thank you received: 4
kmorgan221, what do you mean by "here's no way that I've found to use it as a filter for the directory, or the CSV export"?

If you select to "Show in Listing" in Manage Directory>Directory Fields, then you can sort by the _STATUS column to view all the 0 status together & all the 1 status together, then you can select them to export.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 10 years 1 week ago #31058

We're getting closer. Basically, there is a "PayPal Status" column in the back end that shows "pending" or "accepted." I want that column in the front end and it doesn't seem to be a built in option that I can find.

I added the "_STATUS" hidden field, but now it shows 0 or 1 instead of "Pending" or "Accepted" in the detail view. My goal is to have it say Pending or Accepted in the table and the detail view, preferably with the heading "PayPal Status" and not just _STATUS.

I'll experiment some more, but at least I can get something in the table view.
Last Edit: 10 years 1 week ago by kmorgan221.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 9 years 8 months ago #32136

  • oorzaak
  • oorzaak's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
Hi,

Any news on this topic? I'm facing the same issue - and I have some more questions as well. We would like to have front end editing of the submissions of a form which features both online and offline payment options. We prefer front end editing because the users who will edit these submissions have no other tasks in the back end. What do we need:
  • In case of offline payment, or if there might be a problem with the online payment, the Paypal status will be "Pending" (or sometimes it's something else but not "Accepted"). These users must be able to view the statuses in the front end directory view and also, when offline payment is done, they must be able to manually change the Paypal status to "Accepted".
  • After that, we want them to be able to send a mail to the user who submitted the form. Now sending a mail from the directory view is possible, but unfortunately we also want to attach a pdf to the mail. This is possible when resending mail from the back end but we cannot find a way to send an attachment from the front end.

So we'd really like to know if this is possible from the front end.
Last Edit: 9 years 8 months ago by oorzaak.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 9 years 3 months ago #33937

Count me in, we need the capability of seeing payment status in the front end too! If I add the hidden field "_STATUS" the table in the back end shows the column twice and unchecking it does no good. Using version 1.51.2 on Joomla 3.4.8.
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 9 years 3 months ago #33952

  • alexp
  • alexp's Avatar
  • OFFLINE
  • RSJoomla! Official Staff
  • Posts: 2253
  • Thank you received: 180
Currently the payment status can't be displayed within the directory listing, but a small (and rather inconvenient) workaround is available. This will display 0 or 1 depending if the payment is confirmed or not. Here is what you need to do:

- add a hidden field to your form
- name it _STATUS
- edit the directory for the form in question
- set it to display the _STATUS hidden field.

You should also add the following script in the "PHP Scripts" section in the `Scripts called on listing layout` field:

$directoryLayout = str_replace('_STATUS', 'Paid 1=Yes 0=No', $directoryLayout);

This will replace the column head _STATUS with the explanation of the column values.
Please note: my help is not official customer support. To receive your support, submit a ticket by clicking here
Regards,
RSJoomla! Development Team
The administrator has disabled public write access.
The following user(s) said Thank You: yaani

Display Paypal Status in Submissions Directory 9 years 3 months ago #33978

  • Teryakisan
  • Teryakisan's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 4
You should also add the following script in the "PHP Scripts" section in the `Scripts called on listing layout` field:

$directoryLayout = str_replace('_STATUS', 'Paid 1=Yes 0=No', $directoryLayout);

FYI - adding in the PHP breaks the sorting for the _STATUS column and generates an SQL error that you must log out and back in to clear.

Leaving out the PHP step allows the sort to work properly without SQL errors .
The administrator has disabled public write access.

Display Paypal Status in Submissions Directory 9 years 2 months ago #34001

  • Teryakisan
  • Teryakisan's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 4
This is kind of hacky, but if you need to display PAID and PENDING under the _STATUS column on the directory of version 1.51.8, here's how to do force it.

Keep in mind that an update will probably undo this. It is best practice to create the folder structure...
Templates/yourtemplate/html/com_rsform/views/directory/tmpl/

and drop a copy of
components/com_rsform/views/directory/tmpl/default_layout.php

into the 'tmpl' folder that you created under your Template directory.
This will prevent update overwrites of our customization. B)

Open up the default_layout.php that you copied into the new tmpl folder.

On or around line 30 you should find..
<?php foreach ($this->viewableFields as $field) { ?>
<td align="center" class="center directoryCol directoryCol<?php echo $this->getFilteredName($field->FieldName); ?>"><?php echo $this->getValue($item, $field); ?></td>
<?php } ?>

Replace that code with this...
<?php foreach ($this->viewableFields as $field) { ?>
 <td align="center" class="center directoryCol directoryCol<?php echo $this->getFilteredName($field->FieldName); ?>">
<?php
if($field->FieldCaption  == "_STATUS" && $this->getValue($item,$field) == 1) {
echo "<span style='color:green;'>PAID</span>";
}
elseif($field->FieldCaption  == "_STATUS" && $this->getValue($item,$field) == 0) {
echo "<span style='color:red;'>PENDING</span>";
}else{
echo $this->getValue($item, $field); 
 }
 ?>
</td>
 <?php } ?>

And you should get a result something like this...
Last Edit: 9 years 2 months ago by Teryakisan. Reason: added version that this mod works with
The administrator has disabled public write access.
The following user(s) said Thank You: yaani, tdilkie, jami, eurobad

Display Paypal Status in Submissions Directory 6 years 3 weeks ago #39023

  • jami
  • jami's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 35
  • Thank you received: 4
This is almost perfect!

Except in my version 3.9.4 of Joomla the custom folder that you copy and modify the default_layout.php file should be this:
Templates/yourtemplate/html/com_rsform/directory/
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!