eve-seat / seat Goto Github PK

Allow for searches to be either with a OR (current implementation) or "inclusive" AND when displayed.

Running IE 11
Does not matter what width I make the browser.

The '+' on the character assets tab no longer drops down

Hi,

would it be possible that the Member Security Page considered Roles granted by Titles, too? In my corp we actually handle almost everything by titles, so the page doesn't contain much information at all.

See https://forums.eveonline.com/default.aspx?g=posts&m=4384137#post4384137 for some details.
This is going to require a reseed of the EveApiCalllistTableSeeder seeder as these calls are to be added here too.

I have some code that I can complete the testing on and commit. This should happen soon™

It looks like the ServerStatus job seems to sometimes not get processed properly and remain queued in the system.

I have had a few jobs now which get stuck on Currently Working for a few days and never clear themselves. After asking in IRC I believe these aren't the end of the world as SeAT will simply put in a new job for them according to the schedule and so no data is stopped being collected from the API.

Currently the only way to clear these jobs is to go into the DB and manually edit them. It would be good if say every few hours or something SeAT checked for currently running jobs which appear to have got stuck. A job would not take more than a day (or more than an hour really, but whatever).

Some kind of timeout thing would be nice so SeAT basically tidies up after itself. Making me poke around in the DB to clear these will not end well :p

At the moment on the dev branch, permissions are available, however I think this should be extended so that you can have permissions per corp. So rather than being a global "POS Manager" you are a "POS Manager" for that corporation.

I am constantly getting failed jobs, the information getting sent to the database is as follows:

The workers are working but failing as can be seen. However I have noticed that on the "Queue Status" page the jobs are still sitting in the queued section.

Let me know what else you require as I'm not incredibly knowledgeable about redis-server.

Some feedback from one of my members. Under corp assets you have to click Assets in the menu, then select the corp to view the assets. I understand this is useful for when we have multiple corps in there, however perhaps it is worth having it so IF SeAT only has one corp setup in it, then it by default loads that corps assets (likely applicable to more pages as well).

So just like a simple if statement or something; if corps < 2 load corp assets, else display list of corps. (yeah i can code! lol)

Anybody got any Idea why there are no registration mails send?

I've got to manually activate every damn account.... :(

Original report: https://forums.eveonline.com/default.aspx?g=posts&m=4482411#post4482411

Currently the web frontent attempts to check the AccountInfo for all 😦 entered keys [1] and makes little to no effort to handle errors correctly. Need to decide if we are going to try and distinguish between key types here or have separate inputs for Account/Character API's & Corporation API's

[1] https://github.com/eve-seat/seat/blob/master/app/controllers/ApiKeyController.php#L121

Hi,

According to my laravel.log I am getting the following error:

production.ERROR: exception 'Predis\ServerException' with message 'ERR wrong number of arguments for 'rpush' command' in /var/www/seat/vendor/predis/predis/lib/Predis/Client.php:282

which is causing all my jobs to fail, any ideas? As I'm not well versed on Redis.

Thanks

Since once deployed you can't pick them back up, we shouldn't list a m3 value.

It would be nice if the Corp Contracts page was split into more tabs:

Outstanding (default view (helps with loading times))
Completed
Deleted
Failed

This would give us a nice overview of the number of outstanding contracts, how many were deleted/failed (merge these 2 together?) and how many were completed.

Perhaps also some basic stats, but this I guess is a little bit more niche. But seeing a breakdown of number of contracts per corp member and perhaps value of the contracts in total and per member would be cool. This way a director could easily see whos slacking with their contract sales, who's made the most ISK, and how much the corp has made total from contract sales (I know this is would be in market ledger, but useful to see here as well).

If you have a character with both a personal key and a corporation key. If you then create a group with the lower of the two in the Unaffiliated keys, the one at the top of the list containing that character is added to the group and the one you selected remains in the list. The issue with this is when you then try to add the original key you tried to use, you get an error.

The issue is it isn't "Totaling" the items in the office.
Seeing that quick total m3 of crap in a particular station would be nice.

When you go in character > Asset search,
make a focus on input search (it tell you typing 3 chars to fire search)
when click anywhere in page and the input resize and it will be unusable for the autocomplete..

Allow for full wallet transactions to be filtered & searched to allow for queries such the following to be run:

• How many of this item has been bought? Today? The last week? Between and ?
• What has been bought & sold to ?
• How much has been spent? Today? The last week? Between and ?

For corporations, these need to be further filtered on a per wallet division too.

when trying to run update_sde.sh there an error
update_sde.sh: 38: update_sde.sh: Syntax error: "}" unexpected

Add the ability to clear all job related errors with one button instead of having to delete each one manually.

It appears as if fresh installs struggle to get wallet journals updated.

I have had feedback with a error stating Last status: Started WalletJournal Update Error: 0: Undefined variable: wallet_journal

Investigate and fix what is needed

When implementing #72, consider adding a version checker too.

We only need to check the releases here curl -i https://api.github.com/repos/eve-seat/seat/releases and try to compare this with \Config::get('seat.version')

Maybe we should slap in Requests for PHP to handle the actual request.

When a user has to enter in their API key it would be nice if SeAT provided a link to the API page on CCPs website, with a pre-filled in mask.

Perhaps provide 2 links:
1.) Basic Permissions - Bare minimum needed for SeAT to work and for future automated permission roles to work (so like just char sheet or something)
2.) Awesome Permissions - A mask which has access to everything SeAT can offer

Add a help/faq page with some information about common problems that may occur in SeAT. Include things like the php artisan seat:diagnose command as well as a link to the IRC channel.

Simple workaround is to change back to Bash, with the following command:
update-alternatives --install /bin/sh sh /bin/bash 1

Another would be to re-work the script to be POSIX Compliant.

https://wiki.ubuntu.com/DashAsBinSh

When keys are deleted, a option is needed that allows one to delete all of the information that is stored for characters too

When a new key is added an error occurs that writes a log entry:

 [2014-05-25 07:52:24] production.ERROR: exception 'ErrorException' with message 'Undefined variable: key' in /opt/seat/app/controllers/ApiKeyController.php:209

Looking at this line, it seems that $key->keyID, $key->vCode should actually be $key_data->keyID, $key_data->vCode

When I add a corp key/verify code to the SEAT database it generates an 'Error in exception handler.' message. On further investigation the key has been added to the SEAT DB table 'account_apikeyinfo' but has failed to generate a job to be added to the api calls to populate the rest (corporation_*).

A direct API call with the same key successfully returns data and I can confirm the key has been added to the seat db. This error is reproducible with different corp key/verify code combinations. Character keys are successfully added and populate the DB as intended.

Steps to reproduce (on my system :))

1. Add new key
2. Complete Key ID & Verification Code Fields.
3. Check Key returns
   • Never Expire
   • Corporation Key
   • Full Access Mask
4. Add this Key

Adding this key causes the URL: http://1.2.3.4/public/api-key/add/1234567/abcdefghijklmnopqrstuvwxyz1234567890 to return 'Error in exception handler.'

I Made a new graphical version for display character asset in character view.

Screenshot: http://i.imgur.com/TMnm06e.png

I not create a pull request before you give me your opinion and you vision on this!

I know I'm not the only one that has a well established corp website with loads of users / keys. Just looking for a non-invasive method to pre-populate my corp-mates data. As it will be pulling teeth to get them to register on another site. I'm getting close to cutting over to SEAT for all of our corps needs, and am starting to look at options to move the users over.

When viewing SeAT on a mobile device some of the tiles on the dashboard don't quite contain all the numbers. Can't think of a nice looking way to solve it, but yeah, looks silly at the moment.

This appears on the Jobs page and nothing else related in all logs concerning titles.

Probably the case would be that I'm using using coloured titles to set permisions, per example:
< color=0xff00E5FF >Researcher< /color >
< color=0xff33E500 >Distributor< /color >
< color=0xff33E500 >Trustee< /color >
and etc... (remove the spaces)

As discussed in IRC. Corp container contents are not being displayed for me.

http://imgur.com/EMRHqI3 Example container not showing up.

Example XML from the pheal cache:

          <row itemID="1315282314" typeID="17363" quantity="1" flag="117" singleton="1" rawQuantity="-1">
            <rowset name="contents" key="itemID" columns="itemID,typeID,quantity,flag,singleton">
              <row itemID="1291216628" typeID="22447" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="1356474072" typeID="28711" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="1468285432" typeID="22471" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="1542769796" typeID="22471" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="1558471334" typeID="11994" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="2030673120" typeID="28711" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
              <row itemID="1008767645001" typeID="22549" quantity="1" flag="64" singleton="1" rawQuantity="-2" />
            </rowset>
          </row>

Type id 22471 doesn't appear in the SeAT DB corp contents table.

On the Assets views, it would be useful to have the total m3 of assets (separated by Ships / stuff) listed in the header showing the station / tower.

With Kronos hitting June the 3rd, the IndustryJobs endpoint will be deprecated in favor of new endpoints. These are not available at the time of this issue creation, but serves as a todo for when the new endpoints land.

This applies to both char & corp

Whoops, looks like something went wrong.

I'd love to give more detail.
Let me know what logs I can check.

Add the people related information in the character details view so that a understanding of related characters by person can be made. I am thinking that the character.view view should have the current character's avatar, information, and other characters on key shifted up a little, and another box be added if the character is part of a people group.

When starting supervisord, supervisorctl reports that there was a FATAL exit. When restarting the service, the supervisorctl is reporting ERROR: Abnormal Termination.

Yet, when looking in the logs, i don't see any specific errors taking place asides:
[quote]
2014-04-22 13:51:33,183 INFO spawned: 'seat4' with pid 951
2014-04-22 13:51:33,184 INFO spawned: 'seat1' with pid 952
2014-04-22 13:51:33,186 INFO spawned: 'seat2' with pid 953
2014-04-22 13:51:33,188 INFO spawned: 'seat3' with pid 954
2014-04-22 13:51:33,469 INFO exited: seat3 (exit status 0; not expected)
2014-04-22 13:51:33,469 INFO gave up: seat3 entered FATAL state, too many start retries too quickly
2014-04-22 13:51:33,470 INFO exited: seat4 (exit status 0; not expected)
2014-04-22 13:51:33,472 INFO gave up: seat4 entered FATAL state, too many start retries too quickly
2014-04-22 13:51:33,486 INFO exited: seat1 (exit status 0; not expected)
2014-04-22 13:51:33,486 INFO exited: seat2 (exit status 0; not expected)
2014-04-22 13:51:34,488 INFO gave up: seat1 entered FATAL state, too many start retries too quickly
2014-04-22 13:51:34,488 INFO gave up: seat2 entered FATAL state, too many start retries too quickly
[/quote]

When dealing with larger industrial corps, many players have multiple characters in corp sometimes even spanning many accounts. Providing a view to show what characters a given player "owns" would be a great feature add.

From time to time, API keys become "stuck", i.e. some calls get banned, or keys become disabled. It'd be nice to have some sort of notification of that happening. And also, why it does that. Happened several times to a corp key now, no idea what's causing it. Re-enabling the key and unbanning the calls usually gets me back online, but i feel that it isn't supposed to be disabled in the first place.
Maybe some sort of retry algorithm will do the trick if calls fail? e.g., schedule the same api call again in 10 minutes, if it fails 3 times in a row then it should be disabled and someone notified.

I just logged dot my eveseat and notice 658 errors most of them all say Last status: Started IndustryJobs Update

http://pastebin.com/M4zJCwPX

See error below:

Last status: Started WalletTransactions Update
Error: 23000: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '71c68bc6241d73dd148f967677b18aaa' for key 'character_wallettransactions_hash_unique'

raising this as an issue to track

seat / app / database / migrations / 2014_04_17_192312_Fix5CorporationSheetOptionalAlliance.php

Has no prefix variable for table names. Prefix is set in database config file for table names.

Implement a table sorter and filter that can be easily used application wide.
There are also some areas in the application that would require filtering of random DOM elements, such as the all characters view.

Fix up all of the indentation to 4 spaces and update the contribution guide to include this indentation rule.

I have the site up and running, and have entered a corp key under the admin account. It seems like the "Profile" link for the admin account is not active. Where do I enable user signups?

We run a large number of reactions towers.

A email or push notification when a tower is running low on fuel (or even better on a reaction material) would be awesome. Silo's would be important to have an alert on both near-empty and near-full, since a POS might be making or using the material.

Should be an easy add. the url's are as follows:
EVE-Kill - http://eve-kill.net/?a=pilot_detail&plt_external_id=charid
EVE WHO - http://evewho.com/pilot/charname
EVEBoard - http://eveboard.com/pilot/charname
EVE-Search - http://eve-search.com/search/author/charname
EVE Gate - https://gate.eveonline.com/Profile/charname

When viewing the key details for corporation keys, the "Update Now" feature does not correctly run the updater for them.