1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<?php
require_once(__DIR__ . '/../checkuser.php');
$ids = $_POST['payroll']['selected'];
if (!empty($ids) && is_array($ids)) {
$in_values = array();
foreach ($ids as $id) {
$in_values[] = '?';
}
$in = implode(', ', $in_values);
$sql = "UPDATE `mis_payroll` SET `lastupby` = ?, `lastupdate` = ?, `deleted` = ? WHERE `id` IN ($in)";
$parameters = array_merge(array($_SESSION['webadmin']['id'], date('Y-m-d H:i:s'), 1), $ids);
$sth = Db\Util::execute($dbh, $sql, $parameters);
$data = array(
'message' => 'Deleted',
);
redirectAndExit(Util::link(__DIR__ . '/index.php') . '?' . http_build_query($data));
}
|