repeater pages created by api could not able to retrieve from other languages

adrianmak · April 21, 2016

My site has three language, default, chs, eng. Default language is cht (traditional chinese)

I have an order template (no output template). Structure look like

An order will be created after a successful paypal transaction has been made.

When I'm on default language, the order creation is working properly.

However, if I switched to chs or eng

The order number field i.e. title field cannot be inserted. I just saw an empty title field. All other fields are populated values properly, except the order number

Here is my page creation code

$p = new Page();
$orderByUser = $user;
$p->template = "order";
$counter_name = $order_number_prefix . date('Y');
$number = $this->modules->get('DatabaseCounters')->next($counter_name, 1, 5000);
$ordernumber = $counter_name . '-' . sprintf("%06u", $number);
$p->title = $ordernumber;
$p->member = $orderByUser;
$p->payment_method = $session->get("payment_method");
$p->order_time = $session->get("order_time");
$p->paypal_transaction_id = $session->get("paypal_transaction_id");
foreach($session->get("cart_item") as $cart_item) {
    // create order items
    $item = $p->order_items->getNew();
    $item->product_id = $cart_item['id'];
    $item->product_name = $cart_item['name'];
    $item->product_price = $cart_item['price'];
    $item->product_quantity = $cart_item['quantity'];
    $item->save();
    $p->order_items->add($item);
    $transaction_amount += ($cart_item['price'] * $cart_item['quantity']);
}
$p->transaction_amount = $transaction_amount;
$p->of(false);
$p->save();

Craig · April 21, 2016

I think you need to specify the language.

Taken from an import script from a multi-lingual site I built, it would be done a bit like this:

$def = $wire->languages->get("default");
$chs = $wire->languages->get("chs");
$eng = $wire->languages->get("eng");
// ...
$p->title->setLanguageValue($def, $ordernumber);
$p->title->setLanguageValue($chs, null);
$p->title->setLanguageValue($eng, null);

ESRCH · April 21, 2016

In this case, I would actually suggest to create a new field for the order number, since it complicates things to have a multilanguage field for this value.

And as a multilanguage title doesn't make much sense for an order, you could make the title not required and hidden (under the visibility setting) for this specific template.

adrianmak · April 21, 2016

In this case, I would actually suggest to create a new field for the order number, since it complicates things to have a multilanguage field for this value.

And as a multilanguage title doesn't make much sense for an order, you could make the title not required and hidden (under the visibility setting) for this specific template.

Thank you for your suggestion

adrianmak · April 21, 2016

As ESRCH suggested, I added another text field (not the multilanguage text field) for order number

However I can only hide the original text field from ui and cannot deleted it (pw nature, title field is compulsory for all template)

and the text field is configured as PageTitleLanguage (used by other page templates), then the order template is also a multilanguage .

So I have to make other two languages active before saving.

Here is my updated code

// Add a customer order in database
$p = new Page();
$orderByUser = $user;
$p->template = "order";
$counter_name = $order_number_prefix . date('Y');
$number = $this->modules->get('DatabaseCounters')->next($counter_name, 1, 5000);
$ordernumber = $counter_name . '-' . sprintf("%06u", $number);
$p->order_number = $ordernumber;
$p->member = $orderByUser;
$p->payment_method = $session->get("payment_method");
$p->order_time = $session->get("order_time");
$p->paypal_transaction_id = $session->get("paypal_transaction_id");
foreach($session->get("cart_item") as $cart_item) {
    // create order items
    $item = $p->order_items->getNew();
    $item->product_id = $cart_item['id'];
    $item->product_price = $cart_item['price'];
    $item->product_quantity = $cart_item['quantity'];
    $item->save();
    $p->order_items->add($item);
    $transaction_amount += ($cart_item['price'] * $cart_item['quantity']);
}
$p->transaction_amount = $transaction_amount;
$p->of(false);
foreach($languages as $lang) {
    if($lang->isDefault()) continue;
        $p->set("status$lang", 1);
    $p->save();
}

I found that the order_items (repeater field) does not display on English language until I edit that order at the back-end and save once again.

There is no issue on default and chs language

Here is a recorded youtube to show the issue I described.

ESRCH · April 22, 2016

Since the order items are displayed in two languages, the order items must be created.

Can you show the code where you retrieve and then display the order items on the front-end (after clicking on the order in the dashboard)? Since the order item is completely skipped in English (not just displayed without text), it seems like you are using a filter in the loop (something like "if (!$product) continue;"), and there is a problem with this filter in English. If you echo $order->order_items->count(), does it show 0 (nothing) or 1?

Also, is there a reason why you use a text field rather than a page field for the product_id on the order_items repeater?

Finally, in the code that you pasted above, you wrote $p->save() within the foreach loop. I think you should be able to do that only once under the loop.

adrianmak · April 22, 2016

This is the template to list all the order that current $user had made

<?php

$_heading = __("交易記錄"); // Order history
$_tbl_header_1 = __("訂單號碼"); // Order number
$_tbl_header_2 = __("PayPal交易號碼"); // paypal transaction id
$_tbl_header_3 = __("交易日期"); // order date
$_tbl_header_4 = __("交易金額"); // order amount
$_no_history = __("沒有交易記錄"); // No order history

$content = '';
$out = '';
$edit = '';
$header_image = '';
$rowcount = 1;
$orders = '';

$breadcrumb = breadcrumb($page->id);

if($user->isSuperuser() || $user->hasRole("editor"))
    $selector = "template=order, sort=-order_time";
else $selector = "template=order, member={$user}, sort=-order_time";

$orders = $pages->find($selector);

$out .= "<div class='row clearfix'>";
$out .= "<div class='col-md-12'>";
$out .= "<h2>{$_heading}</h2>";

if($orders) {
$out .= "<table class='table table-bordered table-condensed table-striped '>";
$out .= "<thead>";
$out .= "<tr>";
$out .= "<th>#</th>";
$out .= "<th class='center'>{$_tbl_header_1}</th>";
$out .= "<th class='center'>{$_tbl_header_2}</th>";
$out .= "<th class='center'>{$_tbl_header_3}</th>";
$out .= "<th class='center'>{$_tbl_header_4}</th>";
$out .= "</tr>";
$out .= "</thead>";
$out .= "<tbody>";



foreach($orders as $order) {

    // Order detail modal popup
    $out .= "<div class='modal fade' id='orderDetail-{$order->id}' tabindex='-1' role='dialog' aria-labelledby='myModalLabel' aria-hidden='true'>";
    $out .= "<div class='modal-dialog'>";
    $out .= "<div class='modal-content'>";
    $out .= "</div> <!-- /.modal-content -->";
    $out .= "</div> <!-- /.modal-dialog -->";
    $out .= "</div> <!-- /.modal -->";

    $out .= "<tr>";
    $out .= "<td class='center'>{$rowcount}</td>";
    $out .= "<td class='center'><a data-toggle='modal' data-target='#orderDetail-{$order->id}' href='".$pages->get(1208)->url."?id=".$order->id."'>{$order->order_number}</a></td>";
    $out .= "<td class='center'>{$order->paypal_transaction_id}</td>";
    $out .= "<td class='center'>".date('d-M-Y', $order->order_time)."</td>";
    $out .= "<td class='center'>".number_format($order->transaction_amount)."</td>";
    $out .= "</tr>";
    $rowcount++;
}

$out .= "</tbody>";
$out .= "</table>";
$out .= "</div>";
$out .= "</div>";

$content .= $out;
} else {
    $content .= $_no_history;
}

$out .= "<td class='center'><a data-toggle='modal' data-target='#orderDetail-{$order->id}' href='".$pages->get(1208)->url."?id=".$order->id."'>{$order->order_number}</a></td>";

The is 1208 is the page id of a order detail modal box, passing order is to this template

This is the modal box order-details.php template

<?php

// translation string
$_order_detail_text_1 = __("訂單號碼"); // Order number
$_order_detail_text_2 = __("PayPal交易號碼"); // PayPal transaction id
$_order_detail_text_3 = __("交易日期"); // Order time
$_order_detail_text_4 = __("交易金額"); // transaction amount
$_order_detail_text_5 = __("項目"); // Items
$_order_detail_text_6 = __("會員"); // Member
$_order_detail_text_7 = __("付款方法"); // Payment method

$_tbl_header_1 = __("產品"); // product
$_tbl_header_2 = __("售價"); // price
$_tbl_header_3 = __("數量"); // quantity
$_tbl_header_4 = __("總額"); // total

$content = '';
$out = '';
$header_image = '';
$edit = '';
$oder = '';
$total = 0;
$subtotal = 0;

$order = $pages->get($input->get->id); // get order detail record

if($input->get->id) {

$out .= "<div class='order-detail-container'>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_6}: <strong>".$order->member->name."</p>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_1}: <strong>".$order->order_number."</p>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_2}: <strong>".$order->paypal_transaction_id."</p>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_3}: <strong>".date('d-M-Y', $order->order_time)."</p>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_4}: <strong>".number_format($order->transaction_amount)."</p>";
$out .= "<p class='no-indent'><strong>{$_order_detail_text_7}: <strong>".$order->payment_method."</p>";
$out .= "<h3>$_order_detail_text_5</h3>";
$out .= "<table class='table table-bordered'>";
$out .= "<thead>";
$out .= "<tr>";
$out .= "<th>{$_tbl_header_1}</th>";
$out .= "<th class='center'>{$_tbl_header_2}</th>";
$out .= "<th class='center'>{$_tbl_header_3}</th>";
$out .= "<th class='center'>{$_tbl_header_4}</th>";
$out .= "</thead>";
$out .= "<tbody>";

foreach($order->order_items as $item) {
    $p = $pages->get($item->product_id);
    $out .= "<tr>";
    //$out .= "<td>{$item->product_name}</td>";
    $out .= "<td>{$p->title}</td>";
    $out .= "<td class='center'>{$item->product_price}</td>";
    $out .= "<td class='center'>{$item->product_quantity}</td>";
    $total = $item->product_price * $item->product_quantity;
    $out .= "<td class='center'>".number_format($total)."</td>";
    $out .= "</tr>";
    $subtotal += $total;
}
$out .= "</tbody>";
$out .= "</table>";
$out .= "</div>";

$content .= $out;
} else {
     $session->redirect($homepage->url);
}

adrianmak · April 22, 2016

$order->order_items->count();

Show a count only in default and chs. eng is returned zero

ESRCH · April 22, 2016

Hmmm, I don't have much time to test myself for the moment, but in your initial code to create the order, try saving the order before adding the order items:

Add

$p->save();

before

foreach($session->get("cart_item") as $cart_item) {

Also, I don't see you add a parent to the page during the creation. It might not be necessary, but you can try to see whether this changes anything.

adrianmak · April 22, 2016

Hmmm, I don't have much time to test myself for the moment, but in your initial code to create the order, try saving the order before adding the order items:

Add
$p->save();
before
foreach($session->get("cart_item") as $cart_item) {
Also, I don't see you add a parent to the page during the creation. It might not be necessary, but you can try to see whether this changes anything.

Tried your suggestion. Worst than before

This time only the default language get a count from order items

Settting a parent did not help.

adrianmak · April 22, 2016

Any ideas of my repeater field issue on multi-language

ESRCH · April 23, 2016

I'll try to replicate this problem on my side , to see whether I can understand it . However, I have a few questions:

- Which version of Processwire are you using ?

- What are the fields types of the fields on the product template

- When you create an order on the English backend, and then view the order in the back-end in English (by setting your profile language to English), do the order items appear?

– Do you have the same problem if you create the order in the chs front-end ? Do the order items then not appear in Chinese simplified, but appear in English and default languages ?

adrianmak · April 23, 2016

product template

order_items repeater field

Which version of Processwire are you using ?

>2.7.3

What are the fields types of the fields on the product template

> See the above screen cap

When you create an order on the English backend, and then view the order in the back-end in English (by setting your profile language to English), do the order items appear?

> No matter which language used in user profile, creating an order in back-end ui directly, All items can shown in all languages.

ps I used admin to create an order. other user role has no permission to created an order thru the back-end.

Do you have the same problem if you create the order in the chs front-end ? Do the order items then not appear in Chinese simplified, but appear in English and default languages ?

> no matter using chs or english front-end language for the whole order purchase, order item shown on default language only.

adrianmak · April 23, 2016

By the way, I did find other people has similar issue on repeater field on multilanguage site

https://processwire.com/talk/topic/11300-problem-with-repeater-fields-in-multi-language-pages/

https://processwire.com/talk/topic/11732-repeater-fields-not-displayed-on-non-default-language-page/?hl=repeater

Unfortunately, they didn't get a solid answer or find out what caused that problem.

cstevensjr · April 23, 2016

By the way, I did find other people has similar issue on repeater field on multilanguage site

https://processwire.com/talk/topic/11300-problem-with-repeater-fields-in-multi-language-pages/

https://processwire.com/talk/topic/11732-repeater-fields-not-displayed-on-non-default-language-page/?hl=repeater

Unfortunately, they didn't get a solid answer or find out what caused that problem.

I would suggest that you please open a github issue on this, in addition to commenting on this problem here:

https://github.com/ryancramerdesign/ProcessWire/issues

Thanks

adrianmak · April 23, 2016

If ESRCH could replicate the same issue, then we can ensure there is a bug in between repeater field and multi-language

cstevensjr · April 23, 2016

If ESRCH could replicate the same issue, then we can ensure there is a bug in between repeater field and multi-language

You make a good point, however whether it's a bug or not, reporting and tracking in github ensures that your problem gets proper visibility with other important issues.

ESRCH · April 23, 2016

I made a quick attempt at replicating the issue, but it worked for me. I unfortunately don't have the time to work on this further today, so if someone else has an idea how to solve this...

adrianmak · April 23, 2016

I tried to delete the old order template and repeater field, and to create both a new one.

Issue is still existed.

Anyway, I have posted an issue on github

https://github.com/ryancramerdesign/ProcessWire/issues/1790

ryan · April 24, 2016

Hey guys, I think a few things in the code examples above need to be moved around. Also, since Repeaters don't know about languages, if you are creating repeater items on your own from the PHP side, you'll have to enable those items for all the languages they are applicable to. I replied on that GitHub issue report, along with suggestions for adjustments to the code.

adrianmak · April 24, 2016

Thank you Ryan for my code adjustments commented on the github.

The issue is resolved.

I posted the complete code snippet with Ryan's code adjustment

// Add a customer order in database
$orders = $pages->get(1152);
$p = new Page();
$orderByUser = $user;
$p->template = "order";
$p->parent = $orders;
$counter_name = $order_number_prefix . date('Y');
$number = $this->modules->get('DatabaseCounters')->next($counter_name, 1, 5000);
$ordernumber = $counter_name . '-' . sprintf("%06u", $number);
$p->of(false);
$def = $wire->languages->get("default");
$chs = $wire->languages->get("chs");
$eng = $wire->languages->get("eng");
$p->title->setLanguageValue($def, $ordernumber);
$p->title->setLanguageValue($chs, $ordernumber);
$p->title->setLanguageValue($eng, $ordernumber);
$p->order_number = $ordernumber;
$p->member = $orderByUser;
$p->payment_method = $session->get("payment_method");
$p->order_time = $session->get("order_time");
$p->paypal_transaction_id = $session->get("paypal_transaction_id");

foreach($languages as $lang)
    $p->set("status$lang", 1);
$p->save();

foreach($session->get("cart_item") as $cart_item) {
    $item = $p->items->getNew();
    foreach($languages as $lang)
        $item->set("status$lang", 1);
    $item->product_id = $cart_item['id'];
    $item->product_price = $cart_item['price'];
    $item->product_quantity = $cart_item['quantity'];
    $item->save();
    $p->items->add($item);
    $transaction_amount += ($cart_item['price'] * $cart_item['quantity']);
}

$p->transaction_amount = $transaction_amount;
$p->save();

Sign In

repeater pages created by api could not able to retrieve from other languages

Recommended Posts

adrianmak

Craig

ESRCH

adrianmak

adrianmak

ESRCH

adrianmak

adrianmak

ESRCH

adrianmak

adrianmak

ESRCH

adrianmak

adrianmak

cstevensjr

adrianmak

cstevensjr

ESRCH

adrianmak

ryan

adrianmak

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Similar Content

Image Hotspots

mdx Processwire and MDX export/import

Problem when loading a modal window page in multi-language site

Norwegian (nb-NO)

Error feeding the Page auto complet field

Browse

Activity

My Activity Streams

Support

Store

My Details