H69UNtblNBNpha2dtB1Odn8qYp1Qk5NK2gi7yfceofo9N

/home/ymswebso/crms/application/views/admin/tables/

<?php

defined('BASEPATH') or exit('No direct script access allowed');

$aColumns = [
    'name',
    'dateadded',
    ];

$sIndexColumn = 'announcementid';
$sTable       = db_prefix() . 'announcements';
$where        = [];
$is_admin     = is_admin();

if (!is_admin()) {
    $where = ['AND showtostaff=1'];
}

$result = data_tables_init($aColumns, $sIndexColumn, $sTable, [], $where, [
    'announcementid',
    'showtostaff',
    '(SELECT COUNT(*) FROM ' . db_prefix() . 'dismissed_announcements WHERE announcementid=' . db_prefix() . 'announcements.announcementid AND staff=1 AND userid=' . get_staff_user_id() . ') as is_dismissed',
    ]);

$output   = $result['output'];
$rResult  = $result['rResult'];
$is_admin = is_admin();
foreach ($rResult as $aRow) {
    $row = [];
    for ($i = 0; $i < count($aColumns); $i++) {
        $_data = $aRow[$aColumns[$i]];
        if ($aColumns[$i] == 'name') {
            if ($is_admin) {
                $_data = '<a href="' . admin_url('announcements/announcement/' . $aRow['announcementid']) . '">' . $_data . '</a>';
            } else {
                $_data = '<a href="' . admin_url('announcements/view/' . $aRow['announcementid']) . '">' . $_data . '</a>';
            }
            $_data .= '<div class="row-options">';
            $_data .= '<a href="' . admin_url('announcements/view/' . $aRow['announcementid']) . '">' . _l('view') . '</a>';

if (!$aRow['is_dismissed'] && $aRow['showtostaff'] == '1') {
                $_data .= ' | <a href="' . admin_url('misc/dismiss_announcement/' . $aRow['announcementid']) . '"><b>' . _l('dismiss_announcement') . '</b></a>';
            }

if (is_admin()) {
                $_data .= ' | <a href="' . admin_url('announcements/announcement/' . $aRow['announcementid']) . '">' . _l('edit') . '</a>';
                $_data .= ' | <a href="' . admin_url('announcements/delete/' . $aRow['announcementid']) . '" class="text-danger _delete">' . _l('delete') . '</a>';
            }

$_data .= '</div>';
        } elseif ($aColumns[$i] == 'dateadded') {
            $_data = _d($_data);
        }
        $row[] = $_data;
    }

$row['DT_RowClass'] = 'has-row-options';

if (!$aRow['is_dismissed'] && $aRow['showtostaff'] == '1') {
        $row['DT_RowClass'] .= ' info';
    }

$output['aaData'][] = $row;
}

Nama File / Folder	Size	Action
includes	--	NONE
all_contacts.php	6.369KB	Hapus Edit Rename
all_reminders.php	4.668KB	Hapus Edit Rename
announcements.php	2.354KB	Hapus Edit Rename
clients.php	10.88KB	Hapus Edit Rename
credit_notes.php	5.184KB	Hapus Edit Rename
custom_fields.php	1.889KB	Hapus Edit Rename
departments.php	2.578KB	Hapus Edit Rename
estimates.php	6.616KB	Hapus Edit Rename
expenses.php	6.804KB	Hapus Edit Rename
invoice_items.php	3.893KB	Hapus Edit Rename
leads.php	10.845KB	Hapus Edit Rename
milestones.php	2.223KB	Hapus Edit Rename
payment_modes.php	2.782KB	Hapus Edit Rename
project_expenses.php	4.694KB	Hapus Edit Rename
projects.php	5.912KB	Hapus Edit Rename
proposals.php	6.557KB	Hapus Edit Rename
proposals_relations.php	3.612KB	Hapus Edit Rename
reminders.php	2.113KB	Hapus Edit Rename
roles.php	1.504KB	Hapus Edit Rename
staff_reminders.php	3.972KB	Hapus Edit Rename
staff_timesheets.php	15.991KB	Hapus Edit Rename
subscriptions.php	4.018KB	Hapus Edit Rename
tasks.php	10.223KB	Hapus Edit Rename
tasks_relations.php	12.192KB	Hapus Edit Rename
taxes.php	2.146KB	Hapus Edit Rename
tickets.php	9.36KB	Hapus Edit Rename
web_to_lead.php	1.474KB	Hapus Edit Rename