Answers

• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  June 2021 Answer ✓

  The first option is the one I would use myself, for exactly the multi-user reason you describe on the second option.

  You have integrated rows order recalculation while deleting some element (except last one) I am surprised that such behavior is not default

  To be honest, I hadn't thought of it! Here is how it can be done:

      ->on( 'preCreate', function ( $editor, $values ) {
          if (! $values['readingOrder']) {
              // If no value submitted, then use the max+1 as the new value
              $next = $editor->db()->sql('select IFNULL(MAX(readingOrder)+1, 1) as next FROM audiobooks')->fetch();
              $editor->field('readingOrder')->setValue($next['next']);
          }
          else {
              // On create update all the other records to make room for our new one
              $editor->db()
                  ->query( 'update', 'audiobooks' )
                  ->set( 'readingOrder', 'readingOrder+1', false )
                  ->where( 'readingOrder', $values['readingOrder'], '>=' )
                  ->exec();
          }
      } )
  

  Allan
• milap Posts: 40Questions: 13Answers: 2

  June 2021

  Thank You Allan!! It works like a charm!