[4.0] Implement the workflow into the multilang sample data

[bembelimen]

Pull Request for Issue #21707 . (second part)

Summary of Changes

This PR let the multilang sample data creating a new Workflow to ensure, that the articles are published

Testing Instructions

• Install a 2nd language
• Apply the "Multilingual Sample Data" (from the dashboard)
• check the workflows, a new workflow called "Sample Workflow (xx-xx)" is created and assigned to the specific new sample data category (xx-xx is the language tag).

[brianteeman]

Can you update this please
PLG_SAMPLEDATA_MULTILANG_STEP6_SUCCESS

[brianteeman]

Category created but showing no articles

Workflows created but only with one stage and no transitions

Articles not listed but do exist in the db

[brianteeman]

approve the language changes

[brianteeman]

I have tested this item 🔴 unsuccessfully on 356e15d

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21968.}

[infograf768]

In fact (not taking into account the transitions which should be the same as Joomla default imho), is missing the article set in _workflows_associations.

In my POC I had added in private function addArticle($itemLanguage, $categoryId)

+		$query->clear()
+			->insert($db->qn('#__workflow_associations'))
+			->values($newId . ', 2,' . $db->quote('com_content'));
+
+		$db->setQuery($query);
+
+		try
+		{
+			$db->execute();
+		}
+		catch (JDatabaseExceptionExecuting $e)
+		{
+			$this->setError($e->getMessage());
+
 			return false;
 		}

In this case with this new workflow, the value has to change in
->values($newId . ', 2,' . $db->quote('com_content')); if I do not mistake.

I do not see the reason to create a specific workflow per language btw.
Call it what you want but it can be generic for all content languages, imho.

[bembelimen]

The last commit did not go through last night..... I recommited it, should be fixed now.

[infograf768]

This corrects now the status of articles. Tks.
Remains the fact that the new workflow do not have the same stages than joomla default and that it looks overkill to create a workflow per language.

[bembelimen]

For stages the same applies as here.

For The workflow itself...I have no feelings if there should be one for each language or one in general...It's just a matter of moving the creation outside of the foreach...

[infograf768]

Simple is better. Call it "Sample Multilingual Workflow" and out the foreach. :)

[chmst]

I have tested this item ✅ successfully on 83b0f51

Tested successfully with de-DE and en-GB. All data found as described.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21968.}

[HRIT-Florian]

I have tested this item ✅ successfully on 83b0f51

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21968.}

[ghost]

Ready to Commit after two successful tests.

[infograf768]

Please be nice to drone. Param $itemlanguage is no more. :)

FILE: ...github.com/joomla/joomla-cms/plugins/sampledata/multilang/multilang.php
--------------------------------------------------------------------------------
FOUND 1 ERROR(S) AFFECTING 1 LINE(S)
--------------------------------------------------------------------------------
987 | ERROR | Superfluous doc comment at position 1

[infograf768]

@bembelimen
Please correct drone

[infograf768]

@bembelimen Why was this closed?

[bembelimen]

Ooops, I deleted the branch accidently, here is the PR again: #22123