Module: Upload Approval Queue

What exactly are you looking for? There is also a forum for requests like these as well - Services

I think you may be able to accomplish this with a hidden album that has 'add' for everyone, but not 'view' except for admin. Then you could use the 'organize' module to move the approved photos to the appropriate album. I remember seeing a suggestion of something like this before, I'll have to dig around and see if I can find it.

To get this right a very detailed use story is needed.
go into an approval queue before they are visible in the album is vaugue at best.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

Let's start the dialog then:

Module thought process:

1) Disable uploads to the public
2) On the sidebar, have an 'upload item for approval' (this can be displayed in each album for example so you know where the item is supposed to reside once approved)
2a) Does the user need to be registered to upload, or can guest upload as well? (should this be an option?)
3) The upload an item for approval 'hides' in an album that is -not viewable- to anyone
4) Add an option at the bottom of the item (in the hidden album) that allows admin to 'approve' it (therefore moving it to the appropriate album)

Further notes:

1) 'Add' must -not- be enabled for 'live albums' to the registered users
2) 'Add' must be enabled for the 'Approval Queue' album
3) 'View' must -not- be enabled for the 'Approval Queue' album

Just about done with the framework...

The module will provide a sidebar block that will have an 'upload for approval' button that will allow the user to select the photo(s) they want to upload
- The button will only show for registered users
- will show in each album the user has view access to
- this way if you have multiple albums, and a user wants to upload to a specific album, they can (even though it will go in to the approval queue album until approved)
- The uploaded photo(s) will be uploaded to the 'approval queue' folder which will only be visible to the admin of the gallery
- The admin can browse in the 'approval queue' folder and for each photo, an option will be provided to approve the photo
- Once admin approves a photo, it is automatically moved to the album from which the user original uploaded to (even though it went in to the approval queue album)

Does this sound about right and makes sense?

I think I have everything wrapped up for the initial release...

All admin/install stuff completed...

Testing out final and should release tomorrow.

Sample screenshots to follow

Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Screenshot 5

Give it a shot, remember, this is -initial- (If anyone looks at the code, I hope your eyes bleed! I joke... remember, I'm not a coder!)

Approval Queue Module

Good suggestions. I'll see what I can do for the next update, once this gets tested a bit and confirmed working well.

Good catch - fix will be up in a sec, along with some minor changes.

Added ability to add description and comment for admin on upload form (tags may come later, but I don't want to redo the form (which I have to) right now until all is tested)

Okay, v2 uploaded give this a shot

The link to upload has not completely disappeared for regular users. Admin can still see it and it still seems to work.

Right. As an admin, I see it all. If I open a different browser and log in as a normal user, I don't see the upload link. I did see it with v1, but when I clicked it, it never gave me the upload window.

That worked! I can now see it as a regular user and the link opens the upload dialog. The upload worked, but the dialog box did not close. That's not the biggest deal, but I think it will confuse people.

Ah, okay... I see what has happened on the upload. It actually wants to download the .json file that says "success" after it successfully uploads.

Also, the admin approval appears to be working now. I must have had something stuck in cache.

Sorry, I posted that before really trying everything on my side. I got the approval working. It does everything it should. It's great!!! That worked beautifully.

The only issue I can't get around yet is Chrome (and IE) prompting to save the .json file that is the success message.

Perfect! That did the trick! This is REALLY going to help out. Amazing work!

I tested the module today. It' not working for me.

Have same problems as Digitizit mentioned:
- The upload worked, but the dialog box did not close.
- when I approve the photo, the dialog box that comes up is blank.

Do we need to specify Album where will approved photos go?
I deleted Approval-queue album, and deactivated modul, then activated modul, and approval-queue album does not appear. I can still upload a photo, it looks like that is working, but where the hell is it? Where is uploaded photo?
I think I broke it.

While it was still working, when I go to Approval-queue album and click on a photo, title and description doesn't show up. Same for comment for admin.

____________________________
Gallery 3.0.8 | Clean Canvas theme

One thing I had to do, and it could just have been me, was toggle the permissions off and on again. I did that first thing, and everything after that was good.

Thank you kind sir!

Found an issue with permissions settings on some installs - reworking and will send up new version soon.

Finally got round to looking at this.
Coding looks fine and you have done some stuff that is impressive so don't kid yourself.

When I tried to activate the module (5) for the first time I got a error and the checkbox on the modules page would not stick.
I think it is this bit of code:

    $db = Database::instance();
    $table = "appqs";
    $query = "SHOW TABLES LIKE 'appqs'";
    $result = $db->query($query)->count();
    if(empty($result)) { 
      message::error("ERR [approvalqueue]: APPQ database does not exist!");
      if(identity::active_user()->admin){
	url::redirect("admin/approvalqueue");
      } else {
	return "ERROR";
      }
    }

is the culprit as I removed it and the module activated properly. The table was already created so I don't know why this bit of code did not see the table that was created.

Anyway I have no time to test further at this time.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

I think I might know why this is...

Do you guys have table prefixes on in Gallery?

if so, I can add the table prefix code in to the query... (I keep forgetting about the table prefixes)

Yes.
Good catch!

Dave_____________________________________________
Blog & G2 || floridave - Gallery Team

Okay, v6 now up. Think I have those two pesky bugs worked out...

1) I fixed the appq db search to account for table prefixes
2) I reverted a 'test setting' that caused a bug on uploading to say nothing uploaded...