Table to store data for aimeos job ?

[MikaelNazarenko]

Hello)

I use Laravel.

I have created aimeos job. This job I added to crontab. But it must perform the task when I press button on back-end side. For this I think to write some data to db, so when cron executes the job - it knows if has to be executed and additional parameters.
But is there existing aimeos table for this ?

[aimeos]

Yes, the madmin_job table stores the information and you can use the job manager to manipulate the entries:

Code: Select all

$manager = \Aimeos\MAdmin::create( $context, 'job' );

[MikaelNazarenko]

Thank you! But there is no implemented way in aimeos to interact with jobs from back-end interface ? Or where that madmin_job table is used at all ?

[aimeos]

Guess you want to create an export or something like that.
You have to extend the template to add your button, extend the admin client class by implementing the export() method, use the job manager to write the data needed into the madmin_job table and implement a job controller which reads the entries applicable to the jobs using the job manager, performs the export and writes the resulting file name into the job entry so it will be listed in the dashboard for download.

If you only want to perform an action with no result in the admin interface, you can also use the message queue provided by the context object.

[MikaelNazarenko]

Ok let me explain what exactly I need. I need to generate pdf files when admin press button on dashboard. Generate them with browser request - is bad I idea. So I already have added button to dashboard (extended view). And I also have created new job controller with run method and so on. And I have set up cron every minute. So cron executes my job every minute. But problem is to tell somehow, so job has to know when button is pressed and job has to generate files + I have to pass some parameters to job when button is pressed. This data I guess to write in some DB table. And then job checks if it has to generate files + job grabs needed parameters from that table. After job is done, when script near finished execution - it will write another state to table like "no needed to generate files".

Also, since cron executes the job every minute, and files generation may take longer, to prevent several same processes, I am going to use next solution:

Code: Select all

$f = fopen('commission-calculation-lock', 'w');
if (flock($f, LOCK_EX | LOCK_NB)) {
       //////////
}

If you could suggest something better solution, please fix me Especially now I am wondering the table where to save info..

[MikaelNazarenko]

And yes, I noticed, when I add data to madmin_job table - it is shown on dashboard, but my target is not that, I have described my target on above post.

Thank you!

[aimeos]

The button is an URL where you can add parameters like here:
https://github.com/aimeos/ai-admin-jqad ... #L249-L253

If you don't need to display a result, remove the madmin_job entry after the job controller was executed or use the message queue instead.

[MikaelNazarenko]

ok and then the job each time has to find the entry in madmin_job table. But how can I identify it? I can set always same label and identify by label. So if entry found - job will perform the job and remove entry after finished... right ?

[MikaelNazarenko]

Ah, please, clarify me what the fields method, parameter, result, status are used for ?

[aimeos]

The method and parameter fields are not used any more and will be removed 2021.

In result a JSON encoded array is stored like

Code: Select all

['file' => 'filename']

to add a file download in the dashboard.

The status value can be 1/0/-1/-2 (enabled/disabled/review/archive).

Use the message queue to create a task and a job controller to process the task. Add a madmin_job entry if you want to show a file download. Use the order export as reference:
- https://github.com/aimeos/ai-admin-jqad ... #L249-L253
- https://github.com/aimeos/ai-admin-jqad ... #L105-L136
- https://github.com/aimeos/ai-controller ... andard.php