$total_views_url_aliases=$database->select('views_url_alias','vua')// assuming your table name is views_url_alias
->countQuery()
->execute()
->fetchField();
$form['paths_info']=[
'#markup'=>$this->t('Total paths in Drupal: @total_paths. Total paths in Views URL alias table: @total_views_url.',[
'@total_paths'=>$total_paths,
'@total_views_url'=>$total_views_url_aliases
]),
'#prefix'=>'<p>',
'#suffix'=>'</p>',
];
if($remaining_items>0){
$form['status']=[
'#markup'=>$this->t('There are currently @count items remaining in the queue to be processed. Run cron to process the queue.',['@count'=>$remaining_items]),
'#prefix'=>'<p>',
'#suffix'=>'</p>',
];
}else{
$form['status']=[
'#markup'=>$this->t('All items have been processed and the views URL table is up to date.'),
'#prefix'=>'<p>',
'#suffix'=>'</p>',
];
}
return$form;
}
/**
* {@inheritdoc}
*/
publicfunctiongetQuestion(){
return$this->t('Are you sure you want to rebuild the Views URL alias table?');