adrian

Module
Batch Child Editor

316 posts in this topic

Now I have tested it with the browser console. As you can see, there are no JS-errors:

Screenshot_9.thumb.jpg.5a554b1f772a403abcb8a7aedde8e3b2.jpg

In line 165 of the BatchChildEditor.js the checkbox markup will be declared:

bce_toggleControl = '<input type="checkbox" class="' + bce_columnControlClass + '" style="position: relative; top: 2px; margin-right: 4px;" />',

But this markup will not be added next to tableheader cells.

I havent been working with the browser console so far. Maybe I am doing something wrong or I am in the wrong part of the console, but I cannot find an error.

1 person likes this

Share this post


Link to post
Share on other sites

Thanks - a script can fail even if there are no errors, eg. in this case probably the markup can't be added because the target element is not found in the DOM (maybe the selector used doesn't match anything). It's hard to tell anything else without seeing it. I would try using console.log(obj.length); where object is the target (jQuery) element. If it's 1 (shown in the console) then it's there, otherwise not.

1 person likes this

Share this post


Link to post
Share on other sites

OK I have tried the following:

I have added the following  script to the admin.php file

<script type="text/javascript">
a = "test";
console.log(a.length);
obj = bce_toggleControl;
console.log(obj.length);
</script>

The variable a with the content "test" is only to check if the console.log works.

I got the following output:

Screenshot_22.jpg.93a15132b914379bfad097b76e23dd0e.jpg

As you can see the variable "a" has a length of 4 - this is correct.

But the variable "bce_toggleControl" which is responsible for the checkbox doesnt return anything.

I have also tried it with bce_fieldID depending on this snippet

    // add column controls (top, bottom and replace modes)
    $(document).on('loaded', '#' + bce_fieldID, function () {
        addBceColumnControls();
    });

Same result

1 person likes this

Share this post


Link to post
Share on other sites

Try adding console.log() directly into BatchChildEditor.js file instead.

Share this post


Link to post
Share on other sites

Of course :)

Here is what I have added:

        a = "test";
        console.log(a,length);
        console.log(bce_fieldID,length);

   // add column controls (top, bottom and replace modes)
    $(document).on('loaded', '#' + bce_fieldID, function () {
        addBceColumnControls();
    });

And this is what I got:

Screenshot_24.jpg.081992a4f4ac6670d4afbb8a7a75f12e.jpg

As you can see the variable "bce_fieldsetID" consist of 23 letters (= ProcessPageEditChildren)

So this variable of the if statement is there!!!

1 person likes this

Share this post


Link to post
Share on other sites

What I have found out is the following.

In the JS-file there is the part where the additional function will be created (approx. at line 218)

    function addBceColumnControls() {
         
        //this timeout is a bit of a hack that should be improved in the future
        setTimeout(function () {

            if (bce_isColumnControlsAdded) {
                return false;
            }

            if ($(bce_adminDataTableSelector).length === 0) {
                return false;
            }

            // do not add controls if there is no more than 1 row
            if ($(bce_adminDataTableSelector + ' tbody tr').length <= 1) {
                return false;
            }

            //$(bce_adminDataTableSelector + ' tbody').on('click', 'input[type="checkbox"], i.InputfieldChildTableRowDeleteLink', function () {
            $(bce_adminDataTableSelector + ' tbody').on('click', 'input[type="checkbox"]', function () {
                setColumnControlStates($(this));
            });
            
            // add new controls
            for (var i = 0; i < bce_allowedColumnControls.length; i++) {

                var currentControl = bce_allowedColumnControls[i];

                // skip non-existing elements
                if (!$(currentControl).length) {
                    continue;
                }

                // get index of first checkbox in the first row
                var index = $(bce_adminDataTableSelector + ' ' + currentControl + ':eq(0)').parent().index();

                // do the add
                $(bce_adminDataTableSelector + ' th:eq(' + index + ')').prepend($(bce_toggleControl));

                // set initial checkbox states
                setColumnControlStates($(bce_adminDataTableSelector + ' th:eq(' + index + ') input'));

                // add event
                addColumnControlEvent(bce_adminDataTableSelector, currentControl, index);
            }

            // disable thead break to multiline
            $(bce_adminDataTableSelector + ' thead').css('white-space', 'nowrap');

            bce_isColumnControlsAdded = true;

            return true;

        }, 1000);

    }

There are a lot of if-statements depending on the length of a variable.

It is not possible to log the variables inside this function. Fe. if I want to check the variable length of the second if statement

if ($(bce_adminDataTableSelector).length === 0) {
                return false;
            }

with console.log(bce_adminDataTableSelector.length); or console.log($(bce_adminDataTableSelector).length); nothing will be returned, so maybe the if-statements doesnt work in this case.

1 person likes this

Share this post


Link to post
Share on other sites

Yepp, the main goal would be to detect where it stops at your side :) 

Btw "variable length" in these cases are the number of items found in the DOM. So if it's 0 for "$(bce_adminDataTableSelector).length" it means the html tag is not found in the DOM.

I guess you can't provide login details via PM, that would make things easier :) 

1 person likes this

Share this post


Link to post
Share on other sites

If you write "bce_adminDataTableSelector.length instead of ($(bce_adminDataTableSelector).length) it will return 41 instead of 0 after clicking the tab. It seems that $ before causes a problem.

Share this post


Link to post
Share on other sites

The search is over, thanks to @Juergen providing login to the site in question. I have modified the way the controls are added, now it happens when you hover on the admindatatable, this seems to be the most reliable way. See the modified file attached.

BatchChildEditor.js

3 people like this

Share this post


Link to post
Share on other sites

Thank you both for getting to the bottom of this!

@tpr - I did tweak your changes slightly to use "one" and "mouseover":

    $(document).one('mouseover', bce_adminDataTableSelector, function () {

instead of "on" and "hover":

    $(document).on('hover', bce_adminDataTableSelector, function () {

so that it's triggered only once. I know you had another check in there to see if the controls were already added, but I still think this an improvement. Do you see any issues with this change?

1 person likes this

Share this post


Link to post
Share on other sites

Thanks, I also think yours is better. At the time I wrote the original Js I wasn't aware of .one(), I would use that too.

1 person likes this

Share this post


Link to post
Share on other sites

Hi,

I'm using PW 3.0.61  with PHP7 and yesterday I downloaded this module as I urgently need to import coordinates to link those pages to my map in the frontend.  As I'm using  Leaflet Map Marker in the admin, the subfields in the 'map' table in the database are:

map.data map.lat map.lng map.zoom map.status
e.g. Albatrosstraat, Knokke-Heist, BE 51.34085 3.242333 18

-100

As I have to import 1000's of pages, I have no option but to work by batch georefferring and csv imports.

I tried everything to make the import of the subfields work but to no avail. Could it be that the module is not compatible with PW 3.0.61  or that Leaflet Map Marker has other settings, or am I missing something somewhere?

I tried to pair CSV column number and Processwire field names as in:

1:title
2:
map.data (tried map.address too)
3:map.lat
4.map:lng etc. 

 

 

Share this post


Link to post
Share on other sites

I am trying to import several child pages using a cvs file. All normal field types are importing without a problem, but when importing 'ProFields Textareas' fields, these fields are not being populated with the specified data form the CSV file.

My Textareas field type is named “chartNumbers”, which contains 3 ‘Textarea Definitions’: “fieldfrom”, “fieldto”, fieldsplit”.

I have written the ‘CSV filed pairings’ in my page settings like this:

1:title
2:page_shorttitle
3:page_subtitle
4:page_summary
5:chartNumbers.fieldfrom
6:chartNumbers.fieldto
7:chartNumbers.fieldsplit

I believe that the above field parings are correct based on what I read in this post .

Having spent almost 5-hours trying to figure this out, my brain has decided to give up at 5:30am.

Can anybody tell me what I’m doing incorrect (if that is the case), or help me figure out what is going wrong.


My setup:  PW v3.0.61 Master, ProFields Textareas v0.0.7,  Batch Child Editor v1.6.6

Share this post


Link to post
Share on other sites
On 12/05/2017 at 5:38 AM, CodeCoffeeCode said:

My setup:  PW v3.0.61 Master, ProFields Textareas v0.0.7,  Batch Child Editor v1.6.6

Ive just updated to PW v3.0.62.  As Pretobrazza mentioned on May 3rd in this post, I think there maybe a compatibility issue with this module when trying to import 'ProFields Textareas - Textarea Definitions' fields.

Any help would be useful. It is impossible to import these fields using the 'Import pages from CSV' module,  I've several hundred pages to import that require these fields populating.

Share this post


Link to post
Share on other sites

hi codecoffeecode,

you can try to use something like my solution for your import if you are only doing the import once (and not need your users to be able to import anything). it's very easy to import all kinds of data like this. adrian will be offline for some weeks...

hope that helps ;)

1 person likes this

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By joshuag
      Introducing our newest [commercial] module:
      Recurme
      Processwire Recurring Dates Field & Custom Calendar Module.
      http://www.99lime.com/modules/recurme/
      One Field to Recur them ALL…
      A Recurring Dates InputField for your Processwire templates. The InputField you’ve been waiting for.
      Complex RRule date repeating in a simple and fast user interface.
      Use the super simple, & powerful API to output them into your templates.
      example:
      <? // easy to get recurring events $events = $recurme->find(); // events for this day $events = $recurme->day(); // events for this week $events = $recurme->week(); // events for this month $events = $recurme->month(); ?> <? // Loop through your events foreach($events as $event){ echo $event->title; echo $event->start_date; echo $event->rrule; echo $event->original->url; ... } ?> Unlimited Custom Calendars.
      Imagine you could create any calendar you wanted on your website. Use recurring events with the Recurme field, or use your own Processwire pages and date fields to render calendars… it’s up to you. Fully customizable. Make as many calendars as you like. Get events from anywhere. Recurme does all the hard date work for you.
      Unlimited Custom Admin Calendars too.
      Hope you like it  ,
       Joshua & Eduardo from 99Lime.
       




    • By valan
      At our site we use both email and phone authorizations at frontend. To make life easier, I've developed HelperPhone pack that handles phone numbers. This pack includes following modules for ProcessWire CMS/CMF:
      FieldtypePhoneNumber: module that stores phone numbers InputfieldPhoneNumber: module that renders inputfield for phone numbers HelperPhone: module that loads PhoneNumber and PhoneNumberConst classes, and 'libphonenumber' namespace All these modules require included PW WireData-derived class PhoneNumber and PhoneNumberConst.
      PhoneNumber class is a thin wrapper over giggsey/libphonenumber-for-php, itself is port of Google's libphonenumber. PhoneNumberConst class stores constants, used by PhoneNumber class Usage: PhoneNumber class
      $phone = '8 (916) 318-07-29 ext 1234'; // input string could be in any phone-recognizable format $phoneNumber = new PhoneNumber($phone, 'RU'); // or wire('modules')->get('HelperPhone')->makePhoneNumber($phone, 'RU'); echo ($phoneNumber->isValidNumber() ? 'Yes':'No'); // Yes echo ($phoneNumber->isValidNumberForRegion($regionCode) ? 'Yes':'No'); // Yes echo $phoneNumber->getNumberTypeTitle(); // Mobile echo $phoneNumber->getCountryCode(); // 7 echo $phoneNumber->getRegionCode(); // RU echo $phoneNumber->getNationalNumber(); // 9163180729 echo $phoneNumber->getExtension(); // 1234 echo $phoneNumber->formatForCallingFrom('US') // 011 7 916 318-07-28 echo $phoneNumber->formatForCallingFrom('GE') // 00 7 916 318-07-28
      For more methods and properties please refer to PhoneNumber and PhoneNumberConst source files. Need more? Check giggsey/libphonenumber-for-php and use it by accessing $phoneNumber->phoneNumber property - it is instance of \libphonenumber\PhoneNumber or null (if empty).
      Usage: field
      Note: on field creation, make sure that you've configured field settings
      Default region: assumed region if input phone number string is not in international format (starts with '+', etc)
      Enabled/disabled phone extentions: if disabled, phone extension will be removed on field save.
      Phone field settings in example below: default region code 'RU', phone extensions are enabled
      echo $page->phone; // +79163180729 // Note1: $page->phone stores instance of PhoneNumber and renders to string in E164 format. // Note2: E164 format does not include extension. echo $page->getFormatted('phone'); // +7 916 318-07-29 ext. 1234 echo $page->getUnformatted('phone'); // +79163180729 echo $page->phone->format(PhoneNumberConst::RFC3966); // tel:+7-916-318-07-29;ext=1234 echo $page->phone->getNationalNumber(); // 9163180729 Usage: PW selectors
      FieldtypePhoneNumber is instance of FieldtypeText. It stores phone numbers and extensions as string in E164 format with #extention (if provided by user and enabled in settings) E.g. in db it looks like this: '+79163180729#1234'. This makes it easy to query fields as any text field.
      echo $pages->find([     'template' => 'my_temlate',     'phone^=' => '+79163180729', ]); // will echo page ids where phone starts with '+79163180729' Finally
      I've decided to put it here first and later to Modules directory (based on your feedbacks).
      GitHub: https://github.com/valieand/HelperPhone
      Enjoy
    • By justb3a
      Little admin helper module: Using this module you can view all template cache settings at once. E.g. cache status, cache time (configurable). Furthermore it adds the functionality to clear the entire template cache or just the template cache for a given template. Note that this may cause a temporary delay for one or more requests while pages are re-cached.

       
      GitHub: https://github.com/justb3a/processwire-templatecacheoverview
    • By Steven Veerbeek
      Hi,
      I am trying to create a module for a webshop in which I can predefine a number of thumbnail sizes for my product images. I was thinking of storing each of these image sizes as a child page with 'width' and 'height' fields under the module page , so I can use a PageTable input field in my module to easily manage them.
      I know how to create a Pagetable field and add it to templates so I can use it in regular pages, but because I am planning on implementing some other functionalities that (I think) can't be achieved with a regular page, I need the PageTable field to work within a module.
      So far I have come up with this piece of code by trial and error:
      $page = $this->page; $field_sizes = $this->modules->get("InputfieldPageTable"); $field_sizes->title = "image_sizes"; $field_sizes->label = "Image sizes"; $field_sizes->set('parent_id', $page->id); $template = wire("templates")->get("image_size"); $field_sizes->set('template_id', $template->id); $field_sizes->set('columns', "title\nimage_width\nimage_height"); $wrapper->add($field_sizes); It works in that it does display an empty PageTable in my module. I can also add pages and they will be added as child pages under my module page, but when I do, the way the PageTable is displayed gets all messed up. Instead of showing the newly created page as a row in the PageTable, all the fields on the module page (including the PageTable field itself) are repeated within the PageTable field.
      I hope my explanation makes sense. I am fairly new to Processwire (and module development in particular) so perhaps I am just trying to use PageTable in a way it was not intended to be. Maybe you guys could give me some directions on how to achieve what I am looking for?
      Thanks!
    • By abdus
      After this tutorial you'll have learned how to:
      Build a Process module Make an AJAX request to backend Serve JSON as response Let's say you want to display the latest orders in a dashboard that you can access from admin panel. And you want it to refresh its content with a button click. Most straightforward and proper way (that I know of) is to create a Process module, as they're built for this purpose.
      First, create a directory under /site/modules/, call it ProcessDashboard, and create a file named ProcessDashboard.module under that directory. Following is about the least amount of code you need to create a Process module.
      <?php namespace ProcessWire; class ProcessDashboard extends Process { public static function getModuleInfo() { return [ 'title' => 'Orders Dashboard', 'summary' => 'Shows latest orders', 'version' => '0.0.1', 'author' => 'abdus', 'autoload' => true, // to automatically create process page 'page' => [ 'name' => 'order-dashboard', 'title' => 'Orders', 'template' => 'admin' ] ]; } public function ___execute() { return 'hello'; } } Once you refresh module cache from Modules > Refresh, you'll see your module. Install it.

      It will create an admin page under admin (/processwire/) and will show up as a new item in top menu, and when you click on it, it will show the markup we've built in execute() function.

       
      All right, now let's make it do something useful. Let's add create a data list to display latest orders. We'll change execute() function to render a data table.
      public function ___execute() { /* @var $table MarkupAdminDataTable */ $table = $this->modules->MarkupAdminDataTable; $table->setID($this->className . 'Table'); // "#ProcessDashboardTable" $table->headerRow([ 'Product', 'Date', 'Total' ]); // fill the table foreach ($this->getLatest(10) as $order) { $table->row([ $order['title'], $order['date'], $order['total'] ]); } // to refresh items $refreshButton = $this->modules->InputfieldSubmit; $refreshButton->name = 'refresh'; $refreshButton->id = $this->className . 'Refresh'; // "#ProcessDashboardRefresh" $refreshButton->value = 'Refresh'; // label of the button return $table->render() . $refreshButton->render(); } where getLatest() function finds and returns the latest orders (with only title, date and total fields)
      protected function getLatest($limit = 5, $start = 0) { // find last $limit orders, starting from $start $orders = $this->pages->find("template=order, sort=-created, limit=$limit, start=$start"); // Only return what's necessary return $orders->explode(function ($order) { return [ 'title' => $order->title, 'date' => date('Y-m-d h:i:s', $order->created), 'total' => $order->total ]; }); } When you refresh the page, you should see a table like this

      Now we'll make that Refresh button work. When the button is clicked, it will make an AJAX request to ./latest endpoint, which will return a JSON of latest orders. We need some JS to make AJAX request and render new values. Create a JS file ./assets/dashboard.js inside the module directory.
      window.addEventListener('DOMContentLoaded', function () { let refresh = document.querySelector('#ProcessDashboardRefresh'); let table = document.querySelector('#ProcessDashboardTable'); refresh.addEventListener('click', function (e) { // https://developer.mozilla.org/en/docs/Web/API/Event/preventDefault e.preventDefault(); // Send a GET request to ./latest // http://api.jquery.com/jquery.getjson/ $.getJSON('./latest', { limit: 10 }, function (data) { // check if data is how we want it // if (data.length) {} etc // it's good to go, update the table updateTable(data); }); }); function renderRow(row) { return `<tr> <td>${row.title}</td> <td>${row.date}</td> <td>${row.total}</td> </tr>`; } function updateTable(rows) { table.tBodies[0].innerHTML = rows.map(renderRow).join(''); } }); And we'll add this to list of JS that runs on backend inside init() function
      public function init() { $scriptUrl = $this->urls->$this . 'assets/dashboard.js'; $this->config->scripts->add($scriptUrl); } Requests to ./latest will be handled by ___executeLatest() function inside the module, just creating the function is enough, PW will do the routing. Here you should notice how we're getting query parameters that are sent with the request.
      // handles ./latest endpoint public function ___executeLatest() { // get limit from request, if not provided, default to 10 $limit = $this->sanitizer->int($this->input->get->limit) ?? 10; return json_encode($this->getRandom($limit)); } Here getRandom() returns random orders to make it look like there's new orders coming in. 
      protected function getRandom($limit = 5) { $orders = $this->pages->find("template=order, sort=random, limit=$limit"); return $orders->explode(function ($order) { return [ 'title' => $order->title, 'date' => date('Y-m-d h:i:s', $order->created), 'total' => $order->total ]; }); } And we're done. When refresh button is clicked, the table is refreshed with new data.
      Here it is in action: 
      2017-04-29_19-01-40.mp4 (227KB MP4, 0m4sec)
      Here's the source code:
      https://gist.github.com/abdusco/2bb649cd2fc181734a132b0e660f64a2
       
      [Enhancement] Converting page titles to edit links
      If we checkout the source of MarkupAdminDataTable module, we can see we actually have several options on how columns are built.
      /** * Add a row to the table * * @param array $a Array of columns that will each be a `<td>`, where each element may be one of the following: * - `string`: converts to `<td>string</td>` * - `array('label' => 'url')`: converts to `<td><a href='url'>label</a></td>` * - `array('label', 'class')`: converts to `<td class='class'>label</td>` * @param array $options Optionally specify any one of the following: * - separator (bool): specify true to show a stronger visual separator above the column * - class (string): specify one or more class names to apply to the `<tr>` * - attrs (array): array of attr => value for attributes to add to the `<tr>` * @return $this * */ public function row(array $a, array $options = array()) {} This means, we can convert a column to link or add CSS classes to it.
      // (ProcessDashboard.module, inside ___execute() method) // fill the table foreach ($this->getLatest(10) as $order) { $table->row([ $order['title'] => $order['editUrl'], // associative -> becomes link $order['date'], // simple -> becomes text [$order['total'], 'some-class'] // array -> class is added ]); } Now, we need to get page edit urls. By changing getLatest() and getRandom() methods to return edit links in addition to previous fields
      protected function getLatest($limit = 5, $start = 0) { // find last $limit orders, starting from $offset $orders = $this->pages->find("template=order, sort=-created, limit=$limit, start=$start"); return $orders->explode(function ($order) { return [ 'title' => $order->title, 'date' => date('Y-m-d h:i:s', $order->created), 'total' => $order->total, 'editUrl' => $order->editUrl ]; }); } protected function getRandom($limit = 5) { $orders = $this->pages->find("template=order, sort=random, limit=$limit"); return $orders->explode(function ($order) { return [ 'title' => $order->title, 'date' => date('Y-m-d h:i:s', $order->created), 'total' => $order->total, 'editUrl' => $order->editUrl ]; }); } and tweaking JS file to render first column as links
      function renderRow(row) { return `<tr> <td><a href="${row.editUrl}">${row.title}</a></td> <td>${row.date}</td> <td>${row.total}</td> </tr>`; } we get a much more practical dashboard.