View Code - 20260723

« Back to History

assign_manage.php | 20260723_000646.php Initial Domain Snapshot

<?php
require_once __DIR__ . '/modules/auth/page_acl.php';
$ctx = page_require_access('assign_manage');

$pdo        = $ctx['pdo'];
$company_id = (int)$ctx['company_id'];

require_once __DIR__ . '/helpers/activity_helper.php';
require_once __DIR__ . '/partials/header.php';

$msg='';

/* ========= ADD ========= */

if(isset($_POST['add_assign'])){

$name=trim($_POST['assign_name']);

if($name!=''){

$q=$pdo->prepare("

INSERT INTO assign_master
(company_id,assign_name,is_active)

VALUES
(:cid,:name,1)

");

$q->execute([
':cid'=>$company_id,
':name'=>$name
]);

// Log activity for CREATE operation
        log_activity([
            'company_id'  => $company_id,
            'user_id'     => $ctx['user']['id'] ?? 0,
            'module'      => 'assign',
            'page'        => basename(__FILE__),
            'action'      => 'CREATE',
            'entity_type' => 'assign',
            'entity_id'   => (int)$pdo->lastInsertId(),
            'description' => "Assign '{$name}' created"
        ]);
$msg="Assign added";

}

/* ========= TOGGLE ========= */

if(isset($_GET['toggle'])){

$id=(int)$_GET['toggle'];

$t=$pdo->prepare("

UPDATE assign_master
SET is_active = IF(is_active=1,0,1)
WHERE id=:id
AND company_id=:cid

");

$t->execute([
':id'=>$id,
':cid'=>$company_id
]);

// Log activity for STATUS_CHANGE operation
        $new_status = $t->rowCount() > 0 ? ($edit_row['is_active'] ?? 0 ? 'Inactive' : 'Active') : 'Unknown'; // Assuming $edit_row is available or fetching current status
        log_activity([
            'company_id'  => $company_id,
            'user_id'     => $ctx['user']['id'] ?? 0,
            'module'      => 'assign',
            'page'        => basename(__FILE__),
            'action'      => 'STATUS_CHANGE',
            'entity_type' => 'assign',
            'entity_id'   => $id,
            'description' => "Assign ID {$id} status toggled to {$new_status}"
        ]);
$msg="Status updated";

}

/* ========= LIST ========= */

$l=$pdo->prepare("

SELECT *
FROM assign_master
WHERE company_id=:cid
ORDER BY assign_name

");

$l->execute([':cid'=>$company_id]);

$list=$l->fetchAll(PDO::FETCH_ASSOC);

Assign Manage

</div>

<?php if($msg): ?>

<?=$msg?>

</div>

<?php endif; ?>

</div>

Add

</button>

</div>

</form>

<hr>

<thead>

<tr>

<th>ID</th>
<th>Assign Name</th>
<th>Status</th>
<th>Action</th>

</tr>

</thead>

<tbody>

<?php foreach($list as $r): ?>

<tr>

<td>

<?php if($r['is_active']): ?>

<span class="badge bg-success">Active</span>

<?php else: ?>

<span class="badge bg-danger">Inactive</span>

<?php endif; ?>

</td>

<td>

<a href="?toggle=<?=$r['id']?>"
class="btn btn-sm btn-warning">

Toggle

</a>

</td>

</tr>

<?php endforeach; ?>

</tbody>

</table>

</div>

<?php
require_once __DIR__ . '/partials/footer.php';
?>