Create customers in admin & assign categories to users

[ecartz]

Code: Select all

public function listen_infoBox($parameters) {
  $parameters['contents'][] = ['text' => 'Private Category' . '<br>' . (new Tickable('private', ['value' => '1', 'class' => 'custom-control-input', 'id' => 'private'], 'checkbox'))->tick($GLOBALS['cInfo']->private)];
    
  }

Note that you probably want this in some kind of if statement, because as is, it would show in every infobox on the catalog page. Presumably that's not what you want.

[burt]

Code: Select all

function listen_infoBox($parameters) {
    $parameters['contents'][] = ['class' => '',
                                 'text'  => '<div class="custom-control custom-switch">' . (new Tickable('private', ['value' => $GLOBALS['cInfo']->private, 'class' => 'custom-control-input', 'id' => 'private'], 'checkbox'))->tick($GLOBALS['cInfo']->private) . '<label for="private" class="custom-control-label text-muted"><small>Private Category</small></label></div>'];
  }

The tickbox needs the relevant bootstrap HTML surrounding it..

[LeeFoster]

That's got it showing, now to do all the update stuff.

One thing though, and it's minor, is there any way to change the location the tick box appears?

[LeeFoster]

Almost there with this, last piece of the puzzle is setting the category to private, I have the checkbox but it's not updating the database.

This is my code -

Code: Select all

public function listen_infoBox($parameters) {
		 
		 if(isset($_GET['action']) && $_GET['action'] == 'edit_category'){
  $parameters['contents'][] = ['text' => 'Private Category'];
  $parameters['contents'][] = ['class' => '',
                                 'text'  => '<div class="custom-control custom-switch">' . (new Tickable('private', ['value' => $GLOBALS['cInfo']->private, 'class' => 'custom-control-input', 'id' => 'private'], 'checkbox'))->tick($GLOBALS['cInfo']->private) . '<label for="private" class="custom-control-label text-muted"></label></div>'];
		 }
  }
    

  public function listen_productActionSave() {
	  $private = $_POST['private'];
	  $sql_data = [
            'private' => (int)$private,
            'last_modified' => NOW(),
          ];
    
	 $GLOBALS['db']->perform('categories', $sql_data, 'update', "categories_id = " . (int)$_GET['cID']); 
  }

I am 99% certain it's the way I'm dealing with the $_POST however my brain just can't comprehend what I'm doing wrong. Updating the last_modified column does go through.

[ecartz]

You are editing the category. Why are you trying to save the value in the product action? You'd want listen_updateCategory. And possibly listen_insertCategory but that would require more changes to the infoBox listener.

[LeeFoster]

You are editing the category. Why are you trying to save the value in the product action? You'd want listen_updateCategory. And possibly listen_insertCategory but that would require more changes to the infoBox listener.

Get what you're saying but it seems to work for updating the last_modified column, in addition this is what I got from the admin comments hook, that one uses updateProductAction.

Changed listen_productActionSave to listen_updateCategory and still encountering the same issue.

[ecartz]

I don't think that your code is working for the last_modified either. Note that update_category already updates the last_modified column. Looking at update category suggests

Code: Select all

	 $GLOBALS['db']->perform('categories', $sql_data, 'update', "categories_id = " . (int)$_POST['categories_id']);

[ecartz]

Or actually, toss it entirely and do

Code: Select all

public function listen_updateCategoryPrep() {
  if (isset($_POST['private'])) {
    $GLOBALS['sql_data']['private'] = Text::input($_POST['private']);
  }
}

That section's hooked between the initialization and the perform.

[LeeFoster]

I don't think that your code is working for the last_modified either. Note that update_category already updates the last_modified column. Looking at update category suggests

Code: Select all

	 $GLOBALS['db']->perform('categories', $sql_data, 'update', "categories_id = " . (int)$_POST['categories_id']);

Yeah, I think you might be right there

[LeeFoster]

Or actually, toss it entirely and do

Code: Select all

public function listen_updateCategoryPrep() {
  $GLOBALS['sql_data']['private'] = Text::input($_POST['private']);
}

That section's hooked between the initialization and the perform.

Does Text::input work for a checkbox?