/**
* List items
*/
function menu_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'id ASC';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$db = DataConnection::readOnly();
$total_records = 0;
// Search
if (!empty($search)) {
$search_fields = array('id', 'label', 'func', 'module');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$menus = $db->menu()->where($row_id)->and($search_query)->order($sort)->limit($limit, $offset);
} else {
$menus = $db->menu()->where($row_id)->order($sort)->limit($limit, $offset);
}
$total_records = $db->menu()->count("*");
$i = 0;
if (count($menus)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Label', 'field' => 'label');
$headers[] = array('display' => 'Function', 'field' => 'func');
$headers[] = array('display' => 'Module', 'field' => 'module');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('menu_list', 'menu', $headers, $sort);
foreach ($menus as $menu) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $menu['id'];
/////////////////////////////////////////////
$rows[$j]['id'] = $menu['id'];
$rows[$j]['label'] = $menu['label'];
$rows[$j]['func'] = $menu['func'];
$rows[$j]['module'] = $menu['module'];
if ($menu['system'] == 1) {
$disabled = 'disabled';
} else {
$disabled = '';
}
$rows[$j]['edit'] = theme_link_process_information('', 'menu_edit_form', 'menu_edit_form', 'menu', array('extra_value' => 'id|' . $menu['id'], 'response_type' => 'modal', 'icon' => NATURAL_EDIT_ICON, 'class' => $disabled));
$rows[$j]['delete'] = theme_link_process_information('', 'menu_delete_form', 'menu_delete_form', 'menu', array('extra_value' => 'id|' . $menu['id'], 'response_type' => 'modal', 'icon' => NATURAL_REMOVE_ICON, 'class' => $disabled));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Users List'), 'page_subtitle' => translate('Manage Menus'), 'empty_message' => translate('No menu found!'), 'table_prefix' => theme_link_process_information(translate('Create New Menu'), 'menu_create_form', 'menu_create_form', 'menu', array('response_type' => 'modal')), 'pager_items' => build_pager('menu_list', 'menu', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'menu_list', 'module' => 'menu', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* User List.
*/
function user_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'first_name ASC';
}
$limit = PAGER_LIMIT;
// PAGER_LIMIT
$offset = $page * $limit - $limit;
$db = DataConnection::readOnly();
$total_records = 0;
// Search
if (!empty($search)) {
$search_fields = array('id', 'first_name', 'last_name', 'username');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$users = $db->user()->where($row_id)->and($search_query)->order($sort)->limit($limit, $offset);
} else {
$users = $db->user()->where($row_id)->order($sort)->limit($limit, $offset);
}
$total_records = $db->user()->count("*");
if (count($users) > 0) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'First Name', 'field' => 'first_name');
$headers[] = array('display' => 'Last Name', 'field' => 'last_name');
$headers[] = array('display' => 'Username', 'field' => 'username');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('user_list', 'user', $headers, $sort);
$i = 0;
foreach ($users as $user) {
$class = "";
if ($user['username'] == "admin") {
$class = "disabled";
}
//This is important for the row update
$rows[$i]['row_id'] = $user['id'];
$rows[$i]['id'] = $user['id'];
$rows[$i]['first_name'] = $user['first_name'];
$rows[$i]['last_name'] = $user['last_name'];
$rows[$i]['username'] = $user['username'];
$rows[$i]['edit'] = theme_link_process_information('', 'user_edit_form', 'user_edit_form', 'user', array('extra_value' => 'user_id|' . $user['id'], 'response_type' => 'modal', 'icon' => constant("NATURAL_EDIT_ICON")));
$rows[$i]['delete'] = theme_link_process_information('', 'user_delete_form', 'user_delete_form', 'user', array('extra_value' => 'user_id|' . $user['id'], 'response_type' => 'modal', 'icon' => constant("NATURAL_REMOVE_ICON"), 'class' => $class));
$i++;
}
}
//count($users)
$options = array('show_headers' => TRUE, 'page_title' => translate('Users List'), 'page_subtitle' => translate('Manage Users'), 'empty_message' => translate('No user found!'), 'table_prefix' => theme_link_process_information(translate('Create New User'), 'user_create_form', 'user_create_form', 'user', array('response_type' => 'modal')), 'pager_items' => build_pager('user_list', 'user', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'user_list', 'module' => 'user', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* List items
*/
function bank_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'bank_name asc';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$total_records = 0;
$pdo = new PDO(NATURAL_PDO_DSN_READ, NATURAL_PDO_USER_READ, NATURAL_PDO_PASS_READ);
// Search
if (!empty($search)) {
$search_fields = array('id', 'bank_name', 'account_number', 'comment');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$sql = 'select SQL_CALC_FOUND_ROWS * from bank where church_id = ' . $_SESSION['log_church_id'] . ' and ' . $search_query . ' order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
} else {
$sql = 'select SQL_CALC_FOUND_ROWS * from bank where church_id = ' . $_SESSION['log_church_id'] . ' order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
}
$total_records = $pdo->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN);
$i = 0;
if (count($records)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Bank Name', 'field' => 'bank_name');
$headers[] = array('display' => 'Account Number', 'field' => 'bank_account_number');
$headers[] = array('display' => 'Comment', 'field' => 'comment');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('bank_list', 'bank', $headers, $sort);
foreach ($records as $bank) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $bank['id'];
/////////////////////////////////////////////
$rows[$j]['id'] = $bank['id'];
$rows[$j]['bank_name'] = $bank['bank_name'];
$rows[$j]['account_number'] = $bank['bank_account_number'];
$rows[$j]['comment'] = $bank['comment'];
$rows[$j]['edit'] = theme_link_process_information('', 'bank_edit_form', 'bank_edit_form', 'bank', array('extra_value' => 'id|' . $bank['id'], 'response_type' => 'modal', 'icon' => NATURAL_EDIT_ICON));
$rows[$j]['delete'] = theme_link_process_information('', 'bank_delete_form', 'bank_delete_form', 'bank', array('extra_value' => 'id|' . $bank['id'], 'response_type' => 'modal', 'icon' => NATURAL_REMOVE_ICON));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Banks List'), 'page_subtitle' => translate('Manage Banks'), 'empty_message' => translate('No bank found!'), 'table_prefix' => theme_link_process_information(translate('Create New Bank'), 'bank_create_form', 'bank_create_form', 'bank', array('response_type' => 'modal')), 'pager_items' => build_pager('bank_list', 'bank', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'bank_list', 'module' => 'bank', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* List items
*/
function categories_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'tt.id = ' . $row_id;
} else {
$row_id = 'tt.id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'tt.type_id, tt.name asc';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$total_records = 0;
$pdo = new PDO(NATURAL_PDO_DSN_READ, NATURAL_PDO_USER_READ, NATURAL_PDO_PASS_READ);
// Search
if (!empty($search)) {
$search_fields = array('id', 'bank_name', 'account_number', 'comment');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$sql = "select SQL_CALC_FOUND_ROWS tt.id, tt.name, tt.budget, (case tt.type_id when 0 then 'Income' else 'Withdraw' end) type from categories tt\n where tt.church_id = " . $_SESSION['log_church_id'] . " and " . $search_query . " order by " . $sort . " limit " . $limit . " offset " . $offset;
$records = $pdo->prepare($sql);
$records->execute();
} else {
$sql = "select SQL_CALC_FOUND_ROWS tt.id, tt.name, tt.budget, (case tt.type_id when 0 then 'Income' else 'Withdraw' end) type from categories tt\n where tt.church_id = " . $_SESSION['log_church_id'] . " order by " . $sort . " limit " . $limit . " offset " . $offset;
$records = $pdo->prepare($sql);
$records->execute();
}
$total_records = $pdo->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN);
$i = 0;
if (count($records)) {
// Building the header with sorter
$headers[] = array('display' => 'Type', 'field' => 'type');
$headers[] = array('display' => 'Name', 'field' => 'name');
$headers[] = array('display' => 'Budget', 'field' => 'budget');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('categories_list', 'categories', $headers, $sort);
foreach ($records as $record) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $record['id'];
/////////////////////////////////////////////
$rows[$j]['type'] = $record['type'];
$rows[$j]['name'] = $record['name'];
$rows[$j]['budget'] = $record['budget'];
$rows[$j]['edit'] = theme_link_process_information('', 'categories_edit_form', 'categories_edit_form', 'categories', array('extra_value' => 'id|' . $record['id'], 'response_type' => 'modal', 'icon' => NATURAL_EDIT_ICON));
$rows[$j]['delete'] = theme_link_process_information('', 'categories_delete_form', 'categories_delete_form', 'categories', array('extra_value' => 'id|' . $record['id'], 'response_type' => 'modal', 'icon' => NATURAL_REMOVE_ICON));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Categories List'), 'page_subtitle' => translate('Manage Categories'), 'empty_message' => translate('No category found!'), 'table_prefix' => theme_link_process_information(translate('Create New Category'), 'categories_create_form', 'categories_create_form', 'categories', array('response_type' => 'modal')), 'pager_items' => build_pager('categories_list', 'categories', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'categories_list', 'module' => 'categories', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* List items
*/
function dashboard_widgets_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'id ASC';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$db = DataConnection::readOnly();
$total_records = 0;
// Search
if (!empty($search)) {
$search_fields = array('id', 'title', 'description');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$dashboard_widgets = $db->dashboard_widgets()->where($row_id)->and($search_query)->order($sort)->limit($limit, $offset);
} else {
$dashboard_widgets = $db->dashboard_widgets()->where($row_id)->order($sort)->limit($limit, $offset);
}
$total_records = $db->dashboard_widgets()->count("*");
if (count($dashboard_widgets) > 0) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Title', 'field' => 'title');
$headers[] = array('display' => 'Description', 'field' => 'description');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('dashboard_widgets_list', 'dashboard_widgets', $headers, $sort);
$i = 0;
foreach ($dashboard_widgets as $widget) {
$rows[$i]['row_id'] = $widget['id'];
$rows[$i]['id'] = $widget['id'];
$rows[$i]['title'] = $widget['title'];
if (strlen($widget['description']) > 50) {
$rows[$i]['description'] = substr($widget['description'], 0, 50) . '...';
} else {
$rows[$i]['description'] = $widget['description'];
}
$rows[$i]['edit'] = theme_link_process_information('', 'dashboard_widgets_edit_form', 'dashboard_widgets_edit_form', 'dashboard_widgets', array('extra_value' => 'id|' . $widget['id'], 'response_type' => 'modal', 'icon' => NATURAL_EDIT_ICON, 'class' => $disabled));
$rows[$i]['delete'] = theme_link_process_information('', 'dashboard_widgets_delete_form', 'dashboard_widgets_delete_form', 'dashboard_widgets', array('extra_value' => 'id|' . $widget['id'], 'response_type' => 'modal', 'icon' => NATURAL_REMOVE_ICON, 'class' => $disabled));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Users List'), 'page_subtitle' => translate('Manage Dashboard Widgetss'), 'empty_message' => translate('No dashboard widgets found!'), 'table_prefix' => theme_link_process_information(translate('Create New Dashboard Widget'), 'dashboard_widgets_graph_line_template', 'dashboard_widgets_graph_line_template', 'dashboard_widgets', array('response_type' => 'in_modal')), 'pager_items' => build_pager('dashboard_widgets_list', 'dashboard_widgets', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'dashboard_widgets_list', 'module' => 'dashboard_widgets', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* List items
*/
function report_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'id ASC';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$db = DataConnection::readOnly();
$total_records = 0;
// Search
if (!empty($search)) {
$search_fields = array('id', 'report_name', 'report_content');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$reports = $db->report()->where($row_id)->and($search_query)->order($sort)->limit($limit, $offset);
} else {
$reports = $db->report()->where($row_id)->order($sort)->limit($limit, $offset);
}
$total_records = $db->report()->count("*");
$i = 0;
if (count($reports)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Report Name', 'field' => 'report_name');
$headers[] = array('display' => 'Pdf', 'field' => NULL);
$headers = build_sort_header('report_list', 'report', $headers, $sort);
foreach ($reports as $report) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $report['id'];
/////////////////////////////////////////////
$rows[$j]['id'] = $report['id'];
$rows[$j]['report_name'] = $report['report_name'];
$rows[$j]['Pdf'] = theme_link_process_information('Pdf', 'report_pdf', 'report_pdf', 'report', array('extra_value' => 'id|' . $report['id'], 'response_type' => 'modal'));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Reports List'), 'page_subtitle' => translate('Generate Reports'), 'empty_message' => translate('No report found!'), 'pager_items' => build_pager('report_list', 'report', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'report_list', 'module' => 'report', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* User List.
*/
function user_list_vendors($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'u.id = ' . $row_id;
} else {
$row_id = 'u.id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'u.first_name, u.last_name asc';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$total_records = 0;
$pdo = new PDO(NATURAL_PDO_DSN_READ, NATURAL_PDO_USER_READ, NATURAL_PDO_PASS_READ);
// Search
if (!empty($search)) {
$search_fields = array('u.id', 'u.first_name', 'u.last_name', 'u.phone_number', 'u.email');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$sql = 'select SQL_CALC_FOUND_ROWS u.`id`, u.`first_name`, u.`last_name`, u.`username`, u.`email`, u.`phone_number`, al.description, al.access_level
from church_link cl
left outer join user u on u.id = cl.user_id
left outer join acl_levels al on al.id = cl.acl_levels_id
where cl.church_id = ' . $_SESSION['log_church_id'] . ' and u.vendor = 1 and ' . $search_query . ' order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
} else {
$sql = 'select SQL_CALC_FOUND_ROWS u.`id`, u.`first_name`, u.`last_name`, u.`username`, u.`email`, u.`phone_number`, al.description, al.access_level
from church_link cl
left outer join user u on u.id = cl.user_id
left outer join acl_levels al on al.id = cl.acl_levels_id
where cl.church_id = ' . $_SESSION['log_church_id'] . ' and u.vendor = 1 order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
}
$total_records = $pdo->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN);
if (count($records)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'First Name', 'field' => 'first_name');
$headers[] = array('display' => 'Last Name', 'field' => 'last_name');
$headers[] = array('display' => 'User Name', 'field' => 'username');
$headers[] = array('display' => 'Email', 'field' => 'email');
$headers[] = array('display' => 'Phone', 'field' => 'phone_number');
$headers[] = array('display' => 'Rule', 'field' => 'description');
$headers[] = array('display' => 'Level', 'field' => 'access_level');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('user_list_vendors', 'user', $headers, $sort);
foreach ($records as $record) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $record['id'];
/////////////////////////////////////////////
$rows[$j]['id'] = $record['id'];
$rows[$j]['first_name'] = $record['first_name'];
$rows[$j]['last_name'] = $record['last_name'];
$rows[$j]['username'] = $record['username'];
$rows[$j]['email'] = $record['email'];
$rows[$j]['phone_number'] = $record['phone_number'];
$rows[$j]['description'] = $record['description'];
$rows[$j]['level'] = $record['access_level'];
$rows[$j]['edit'] = theme_link_process_information('', 'user_edit_form', 'user_edit_form', 'user', array('extra_value' => 'user_id|' . $record['id'], 'response_type' => 'modal', 'icon' => constant("NATURAL_EDIT_ICON")));
$rows[$j]['delete'] = theme_link_process_information('', 'user_delete_form', 'user_delete_form', 'user', array('extra_value' => 'user_id|' . $record['id'], 'response_type' => 'modal', 'icon' => constant("NATURAL_REMOVE_ICON"), 'class' => $class));
$i++;
}
}
//count($users)
$options = array('show_headers' => TRUE, 'page_title' => translate('Vendors List'), 'page_subtitle' => translate('Manage Vendors'), 'empty_message' => translate('No vendor found!'), 'table_prefix' => theme_link_process_information(translate('Create New Vendor'), 'user_create_form', 'user_create_form', 'user', array('response_type' => 'modal')), 'pager_items' => build_pager('user_list_vendors', 'user', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'user_list_vendors', 'module' => 'user', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
function field_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'form_reference ASC';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$db = DataConnection::readOnly();
$total_records = 0;
// Search
if (!empty($search)) {
$search_fields = array('id', 'field_name', 'form_reference', 'html_type', 'def_label');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$fields = $db->field_templates()->where($row_id)->and($search_query)->order($sort)->limit($limit, $offset);
} else {
$fields = $db->field_templates()->where($row_id)->order($sort)->limit($limit, $offset);
}
$total_records = $db->field_templates()->count("*");
$i = 0;
if (count($fields)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Form Reference', 'field' => 'form_reference');
$headers[] = array('display' => 'Position', 'field' => 'form_field_order');
$headers[] = array('display' => 'Name', 'field' => 'field_name');
$headers[] = array('display' => 'HTML Type', 'field' => 'html_type');
$headers[] = array('display' => 'Label', 'field' => 'def_label');
$headers[] = array('display' => 'Edit', 'field' => NULL);
$headers[] = array('display' => 'Delete', 'field' => NULL);
$headers = build_sort_header('field_list', 'natural', $headers, $sort);
$total = 0;
foreach ($fields as $field) {
$j = $i + 1;
//This is important for the row update
$rows[$j]['row_id'] = $field['id'];
//////////////////////////////////////
$rows[$j]['id'] = $field['id'];
$rows[$j]['form_reference'] = $field['form_reference'];
$rows[$j]['form_field_order'] = $field['form_field_order'];
$rows[$j]['field_name'] = $field['field_name'];
$rows[$j]['html_type'] = $field['html_type'];
$rows[$j]['def_label'] = $field['def_label'];
$rows[$j]['edit'] = theme_link_process_information('', 'field_edit_form', 'field_edit_form', 'natural', array('extra_value' => 'id|' . $field['id'], 'response_type' => 'modal', 'icon' => NATURAL_EDIT_ICON));
$rows[$j]['delete'] = theme_link_process_information('', 'field_delete_form', 'field_delete_form', 'natural', array('extra_value' => 'id|' . $field['id'], 'response_type' => 'modal', 'icon' => NATURAL_REMOVE_ICON));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Field List'), 'page_subtitle' => translate('Manage Fields'), 'empty_message' => translate('No field found!'), 'table_prefix' => theme_link_process_information(translate('Create New Field'), 'field_create_form', 'field_create_form', 'natural', array('response_type' => 'modal')), 'pager_items' => build_pager('field_list', 'natural', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'field_list', 'module' => 'natural', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}
/**
* List items
*/
function church_list($row_id = NULL, $search = NULL, $sort = NULL, $page = 1)
{
$view = new ListView();
// Row Id for update only row
if (!empty($row_id)) {
$row_id = 'id = ' . $row_id;
} else {
$row_id = 'id != 0';
}
// Sort
if (empty($sort)) {
$sort = 'c.name asc';
}
$limit = PAGER_LIMIT;
$offset = $page * $limit - $limit;
$total_records = 0;
$pdo = new PDO(NATURAL_PDO_DSN_READ, NATURAL_PDO_USER_READ, NATURAL_PDO_PASS_READ);
// Search
if (!empty($search)) {
$search_fields = array('id', 'name', 'rowcount');
$exceptions = array();
$search_query = build_search_query($search, $search_fields, $exceptions);
$sql = 'select SQL_CALC_FOUND_ROWS c.id, c.name,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 1) visitors,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 2) members,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 3) pastors,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 4) treasurers,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 5) administrators
from church_link cl
left outer join church c on c.id = cl.church_id
where cl.user_id = ' . $_SESSION['log_id'] . ' ' . $search_query . ' order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
} else {
$sql = 'select SQL_CALC_FOUND_ROWS c.id, c.name,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 1) visitors,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 2) members,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 3) pastors,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 4) treasurers,
(select count(id) from church_link where church_id = c.id and acl_levels_id = 5) administrators
from church_link cl
left outer join church c on c.id = cl.church_id
where cl.user_id = ' . $_SESSION['log_id'] . ' order by ' . $sort . ' limit ' . $limit . ' offset ' . $offset;
$records = $pdo->prepare($sql);
$records->execute();
}
$total_records = $pdo->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN);
$i = 0;
if (count($records)) {
// Building the header with sorter
$headers[] = array('display' => 'Id', 'field' => 'id');
$headers[] = array('display' => 'Church', 'field' => 'name');
$headers[] = array('display' => 'Visitors', 'field' => 'visitors');
$headers[] = array('display' => 'Members', 'field' => 'members');
$headers[] = array('display' => 'Pastors', 'field' => 'pastors');
$headers[] = array('display' => 'Treasurers', 'field' => 'treasurers');
$headers[] = array('display' => 'Administrators', 'field' => 'administrators');
$headers[] = array('display' => 'Access', 'field' => NULL);
$headers = build_sort_header('church_list', 'church', $headers, $sort);
foreach ($records as $record) {
$j = $i + 1;
//This is important for the row update/delete
$rows[$j]['row_id'] = $record['id'];
/////////////////////////////////////////////
$rows[$j]['id'] = $record['id'];
$rows[$j]['name'] = $record['name'];
$rows[$j]['visitors'] = $record['visitors'];
$rows[$j]['members'] = $record['members'];
$rows[$j]['pastors'] = $record['pastors'];
$rows[$j]['treasurers'] = $record['treasurers'];
$rows[$j]['administrators'] = $record['administrators'];
$rows[$j]['account_management'] = theme_link_process_information('Manage', '', '', 'church', array('response_type' => null, 'href' => 'jump.php?url=dashboard_church.php&church_id=' . $record['id']));
$i++;
}
}
$options = array('show_headers' => TRUE, 'page_title' => translate('Churchs List'), 'page_subtitle' => translate('Manage Churchs'), 'empty_message' => translate('No church found!'), 'table_prefix' => theme_link_process_information(translate('Create New Church'), 'church_create_form', 'church_create_form', 'church', array('response_type' => 'modal')), 'pager_items' => build_pager('church_list', 'church', $total_records, $limit, $page), 'page' => $page, 'sort' => $sort, 'search' => $search, 'show_search' => TRUE, 'function' => 'church_list', 'module' => 'church', 'update_row_id' => '', 'table_form_id' => '', 'table_form_process' => '');
$listview = $view->build($rows, $headers, $options);
return $listview;
}