codeablehq / expertstatsplugin Goto Github PK

It might be a cool idea to add a simple PERT estimate calculator to the plugin, for estimating on tasks.

http://pastebin.com/EjxJMyC7

If we find a transaction that already exists, bail out and don't continue updating all the transactions

We have been using this plugin for Codeable in past. It seems like its not working any more. While debugging I figured out that "auth_token" is missing in the initial login request. Is there any change on the API end? Or am I missing something?

Getting following error in the debug log;

PHP Notice: Undefined index: auth_token in /public_html/wp-content/plugins/expertstatsplugin-master/classes/api_calls.php on line 87

The risk of plain text username and password sending is too great. If an expert had their credentials stolen, an attacker could essentially make PayPal withdrawals via their account.

Perhaps we allow it if running from localhost or an intranet IP address. Will have to investigate further.

I just tried the new update ... for some reason it doesn't load tasks for me ... here is a video recording of what is happening
https://www.dropbox.com/s/guizcm3n4r8mxny/2019-07-22_18-10-53.mp4?dl=0

Pretty pretty please! :)

I assume it is a challenge to count in the ones a user would send to a colleague,
but it would be great if the stats would update the $ amount with the transactions received from other colleagues.

In essence, that's the more important angle - if we were to measure one VS the other :)

Pretty please! :D

Great job from screenshots

From live i got error 500

[23-Feb-2017 21:22:59 UTC] PHP Notice: Undefined index: revenue in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\functions\admin-page.php on line 90 [23-Feb-2017 21:22:59 UTC] PHP Notice: Undefined index: total_cost in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\functions\admin-page.php on line 91 [23-Feb-2017 21:22:59 UTC] PHP Notice: Undefined index: totals in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\functions\admin-page.php on line 184 [23-Feb-2017 21:22:59 UTC] PHP Notice: Undefined index: clients in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\functions\admin-page.php on line 428 [23-Feb-2017 21:22:59 UTC] PHP Warning: Invalid argument supplied for foreach() in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\functions\admin-page.php on line 428 [23-Feb-2017 21:23:48 UTC] WordPress database error Column 'client_id' cannot be null for query REPLACE INTO wp_codeable_clients (client_id, full_name, role, last_sign_in_at, pro, timezone_offset, tiny, small, medium, large) VALUES (NULL, NULL, NULL, '1970-01-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions [23-Feb-2017 21:23:48 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 134 [23-Feb-2017 21:23:48 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 135 [23-Feb-2017 21:23:48 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 138 [23-Feb-2017 21:23:48 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 139 [23-Feb-2017 21:23:48 UTC] WordPress database error Column 'task_id' cannot be null for query INSERT INTO wp_codeable_amounts (task_id, client_id, credit_revenue_id, credit_revenue_amount, credit_fee_id, credit_fee_amount, credit_user_id, credit_user_amount, debit_cost_id, debit_cost_amount, debit_user_id, debit_user_amount) VALUES (NULL, NULL, '255629', '12019.0', '255628', '50.0', NULL, NULL, '255630', '12069.0', NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions [23-Feb-2017 21:24:08 UTC] WordPress database error Column 'client_id' cannot be null for query REPLACE INTO wp_codeable_clients (client_id, full_name, role, last_sign_in_at, pro, timezone_offset, tiny, small, medium, large) VALUES (NULL, NULL, NULL, '1970-01-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions [23-Feb-2017 21:24:08 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 134 [23-Feb-2017 21:24:08 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 135 [23-Feb-2017 21:24:08 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 138 [23-Feb-2017 21:24:08 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 139 [23-Feb-2017 21:24:08 UTC] WordPress database error Column 'task_id' cannot be null for query INSERT INTO wp_codeable_amounts (task_id, client_id, credit_revenue_id, credit_revenue_amount, credit_fee_id, credit_fee_amount, credit_user_id, credit_user_amount, debit_cost_id, debit_cost_amount, debit_user_id, debit_user_amount) VALUES (NULL, NULL, '231596', '18088.4', '231595', '50.0', NULL, NULL, '231597', '18138.4', NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions [23-Feb-2017 21:24:19 UTC] WordPress database error Column 'client_id' cannot be null for query REPLACE INTO wp_codeable_clients (client_id, full_name, role, last_sign_in_at, pro, timezone_offset, tiny, small, medium, large) VALUES (NULL, NULL, NULL, '1970-01-01 00:00:00', NULL, NULL, NULL, NULL, NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions [23-Feb-2017 21:24:19 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 134 [23-Feb-2017 21:24:19 UTC] PHP Notice: Undefined offset: 2 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 135 [23-Feb-2017 21:24:19 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 138 [23-Feb-2017 21:24:19 UTC] PHP Notice: Undefined offset: 1 in C:\wamp\www\wptest\wp-content\plugins\expertstatsplugin-master\classes\transactions.php on line 139 [23-Feb-2017 21:24:19 UTC] WordPress database error Column 'task_id' cannot be null for query INSERT INTO wp_codeable_amounts (task_id, client_id, credit_revenue_id, credit_revenue_amount, credit_fee_id, credit_fee_amount, credit_user_id, credit_user_amount, debit_cost_id, debit_cost_amount, debit_user_id, debit_user_amount) VALUES (NULL, NULL, '219909', '350.0', '219908', '50.0', NULL, NULL, '219910', '400.0', NULL, NULL) made by do_action('codeable-stats_page_codeable_settings'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, codeable_settings_callback, wpcable_transcactions->store_transactions

Just committed to master the readme and some screenshots...

So I wanted to bring up how we should do this looking ahead with feature branches and pull requests ect...

Just creating the issue for now I assume @vimes1984 may have input as I really don't know what's best! Thanks - Raleigh :D

Challenging, uh? 😆

Hey guys, I'd love to be able to download these charts to use in my blog... Specifically the "monthly money chart" + "Amounts Range" + "Tasks per Month" charts.

And by this I mean to simply download a jpg of the chart to quickly add to my blog.

https://codex.wordpress.org/Class_Reference/WP_Object_Cache

Should we swicth the averages to monthly or daily averages on the table, in order to match the selected "chart display" radio button?

Contractor, tasks and conversion information is missing.

We need a way to notify experts that there is a new version of the plugin, that they should come to our repo and download it.

We dont want to have the plugin public to the wordpress repo, so something like a remote file with a version to check should be enough

Comments, thoughts ?

http://take.ms/eSGSf

It would probably be a good idea to change the default chart subtitle if this will be made public. It'd also be cool to be able to customize this subtitle.

Need to rename tables that have spelling errors in them, so adding some upgrade logic would be a good idea anyways for future releases.

I just clicked into one of my clients and noticed you're able to track which tasks came in as preferred and which didn't.

I think it would be really cool to have a little breakdown that shows total revenue generated by preferred tasks VS non-preferred tasks.

Personally I'd like to share my #'s with the rest of the experts on Codeable to show them just how important these preferred tasks are and how easy it is to get them.

Hey guys, first off I just want to say that I'm really loving the plugin, there's so much wonderful information here at my fingertips now, I feel like a kid on Christmas!

One stat that I track personally is my average task size month-over-month as my goal as a freelancer is to work on less tasks that are ultimately worth more money... Perhaps that could be overlaid on the "tasks per month" bar graph to chart total # of tasks VS average task size.

Anyways, just thinking out loud here...

Right now it just doesn't do anything.

As one of the oldest on ...... in my time .... they dont make good pasta like they did back then .....

.... .

There are no transactions before 2014 . Ive been on codeable since January 2013 and i have done tasks that year but even tried 3-4 times re-fetching the data the oldest i see is January 2014 .

Regards

Add an option in settings wp-admin/admin.php?page=codeable_settings for experts to set how many pages to retrieve for the new tasks page wp-admin/admin.php?page=codeable_tasks that @stracker-phil built

This readme should detail how code is to be commited, what gitflow we are using on it.
Best coding practises etc etc...

Just checking if this is still being supported? I've installed it on WP 6.0.1. Profile and Tasks are working :) but revenue is 0. But even without revenue, I love the task listing!

Seems like tha last login date of the clients is not updated, if there are no new tasks for that client.
If we need to update this date, then we have to go through all the clients and get the last login date.

It might take a while :)

Running on my local Ubuntu 16.04 install with nginx and PHP7, with WP_DEBUG enabled, I get a bunch of PHP notices (file attached) when viewing the stats page.

PHP Notices.txt

My PHP error_reporting is set to

error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT

I'm getting PHP warnings, and failure to update stats (well, anything) in PHP 7.1.7, as follows:

mod_fcgid: stderr: PHP Warning: A non-numeric value encountered in /httpdocs/wp-content/plugins/expertstatsplugin/classes/stats.php on line 470, referer: https://silicondales.com/wp-admin/admin.php?page=codeable_settings

Not 100% its just the PHP version, but will cross check in some other versions to pick apart. Posting this so I can track when I fix it :)

When displaying per day, in the highscores section, instead of best month we should display best day

Remove fees best - Total Best -Total from highscore columns

• Add (all time) next to the Clients Data http://take.ms/qSlQF
• Make total tasks link

@jin0x do your magic :)

Add the ability to sort by task #'s ... Currently this graph is based on $ and I think it would be interesting to compare both graphs.

Total Tasks Complete (#) VS Income ($)

There is no use of the "Tasks" legend on the Tasks per month/day chart. It should be removed.

Codeable is changing authentication endpoint. Change is simple but it breaks compatibility.

We are preparing the scene for removal of "auth_token" property from user serializer.

First step that is happening in the next few days is that we are starting to send old "user" object and new "auth_token" string separately. So response will became a hash and not root user object. Then after a while user.auth_token will go away.

We have added the code in our frontend app to handle both cases so there is no downtime in transition, but eventually we will completely turn off auth_code from user and we will kill "old_way" else branch in the fronted receiver.

We should implement https://codeclimate.com/dashboard to help maintain a low level of complexity on the coidebase.

The charts are not showing when I installed the plugin.

`Uncaught TypeError: r.attachEvent is not a function
at a.Chart.isReadyToRender (highcharts.js:13)
at a.Chart.firstRender (highcharts.js:13)
at a.Chart.init (highcharts.js:13)
at a.Chart.getArgs (highcharts.js:13)
at new a.Chart (highcharts.js:13)
at Object.a.chart (highcharts.js:13)
at HTMLDocument. (admin.php?page=codeable_transcactions_stats:1605)
at i (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-core&ver=5.2.3:2)
at Object.fireWith [as resolveWith] (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-core&ver=5.2.3:2)
at Function.ready (load-scripts.php?c=0&load[]=jquery-core,jquery-migrate,utils,jquery-ui-core&ver=5.2.3:2)

`

Would be great when the plugin is deleted to remove the tables as well
Regards

That totalcost, revenue, fees are clickable

Last night, ajax posts to wp-admin/admin.php?page=codeable_transcactions_stats appeared to be stuck in a loop.

I checked my site access logs, and it tried calling it about 50,000 times last night, resulting in a temporary IP ban from the Codeable API.

It looks like at some point the API timed out (possibly after my IP ban from the API), but the plugin kept attempting indefinitely.

Hey guys, why not release the plugin publicly and if someone doesn't have a user/pass for Codeable you could either link them to either the apply to become a developer page OR create a new client account page?

This could potentially be expanded into allowing clients to install this plugin on their site and pull a completely different dashboard with their own stats into their own WP site and allow them to post a new project right from their dashboard. Maybe it would showcase the developers they've worked with in the past and you could tie Referoo into this and end up making some $ from your plugin?

Just thinking out loud here again... Will stop spamming this repo now :)

Hey Guys,

Also noticed we're able to drill down and see task type; "theme, plugin, project, subtask, install, etc" and I thought it might be cool to have a stat to track average task revenue based on task type?

Might give us some sort of indication where our time is best spent?

I did not see a license attached to this project.

In the expert profile section, I still see the old Codeable logo.

Can you update it with the new one?

I think that we shouldn't store the password in the DB settings as plain text.
It would be safer if fetch remote data was a POST action and we experts would have to type their password everytime

cc @spyrosvl

I've got a self-signed cert on my local machine. When I try to "Fetch remote data" I get the following error:

https://api.codeable.io/users/login
SSL certificate problem: unable to get local issuer certificate
60

Any way you can provide a hook that would allow plugins to set additioanl curl_opts (e.g., CURLOPT_SSL_VERIFYPEER in this case)?

• Prepend Parent
• Rearrange columns