public function manage(): void {
$this->module('trongate_security');
$this->trongate_security->_make_sure_allowed();

if (segment(4) !== '') {
$data['headline'] = 'Search Results';
$searchphrase = trim($_GET['searchphrase']);
$sql = 'select * from datetimes ORDER BY id';
$all_rows = $this->model->query_bind($sql, $params, 'object');
} else {
$data['headline'] = 'Manage Datetimes';
$all_rows = $this->model->get('id');
}

nvm use 18.17.1

git clone https://github.com/trongate/trongate-desktop-app.git trongate

npm install
npx electron .

npm install
npm WARN deprecated [email protected]: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.
npm WARN deprecated [email protected]: this library is no longer supported
npm WARN deprecated [email protected]: Glob versions prior to v9 are no longer supported
npm WARN deprecated [email protected]: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.
npm WARN deprecated [email protected]: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details.
npm WARN deprecated [email protected]: request has been deprecated, see https://github.com/request/request/issues/3142

"dependencies": {
"download": "^3.3.0",
"extract-zip": "^1.6.7",
"fs-extra": "^8.0.1",
"latest": "^0.2.0",
"mariadb": "^2.1.5",
"mysql-import": "^3.0.6",
"normalize-url": "^6.0.1",
"request": "^2.88.2"
}

<h1><?= out($headline) ?></h1>
<?php
flashdata();
echo '<p>'.anchor('tasks/create', 'Create New Task Record', array("class" => "button"));
if(strtolower(ENV) === 'dev') {
echo anchor('api/explorer/tasks', 'API Explorer', array("class" => "button alt"));
}
echo '</p>';
echo Pagination::display($pagination_data);
if (count($rows)>0) { ?>
<table id="results-tbl">
<thead>
<tr>
<th colspan="3">
<div>
<div><?php
echo form_open('tasks/manage/1/', array("method" => "get"));
echo form_search('searchphrase', '', array("placeholder" => "Search records..."));
echo form_submit('submit', 'Search', array("class" => "alt"));
echo form_close();
?></div>
<div>Records Per Page: <?php
$dropdown_attr['onchange'] = 'setPerPage()';
echo form_dropdown('per_page', $per_page_options, $selected_per_page, $dropdown_attr);
?></div>

</div>
</th>
</tr>
<tr>
<th>Task Title</th>
<th>Task Complete</th>
<th style="width: 20px;">Action</th>
</tr>
</thead>
<tbody>
<?php
$attr['class'] = 'button alt';
foreach($rows as $row) { ?>
<tr>
<td><?= out($row->task_title) ?></td>
<td><?= out($row->task_complete) ?></td>
<td><?= anchor('tasks/show/'.$row->id, 'View', $attr) ?></td>
</tr>
<?php
}
?>
</tbody>
</table>
<?php
if(count($rows)>9) {
unset($pagination_data['include_showing_statement']);
echo Pagination::display($pagination_data);
}
}
?>

/**
* Display a webpage to manage records.
*
* @return void
*/
public function manage(): void {
$this->module('trongate_security');
$this->trongate_security->_make_sure_allowed();

if (segment(4) !== '') {
$data['headline'] = 'Search Results';
$searchphrase = trim($_GET['searchphrase']);
$params['task_title'] = '%'.$searchphrase.'%';
$sql = 'select * from tasks
WHERE task_title LIKE :task_title
ORDER BY id';
$all_rows = $this->model->query_bind($sql, $params, 'object');
} else {
$data['headline'] = 'Manage Tasks';
$all_rows = $this->model->get('id');
}

$pagination_data['total_rows'] = count($all_rows);
$pagination_data['page_num_segment'] = 3;
$pagination_data['limit'] = $this->get_limit();
$pagination_data['pagination_root'] = 'tasks/manage';
$pagination_data['record_name_plural'] = 'tasks';
$pagination_data['include_showing_statement'] = true;
$data['pagination_data'] = $pagination_data;

$data['rows'] = $this->reduce_rows($all_rows);
$data['selected_per_page'] = $this->get_selected_per_page();
$data['per_page_options'] = $this->per_page_options;
$data['view_module'] = 'tasks';
$data['view_file'] = 'manage';
$this->template('admin', $data);
}