}
unset($db_count_cus);
$left_column .= $list->showFooter();
$total_left_top .= '<div class="total-pos">
<div class="col-xs-6-lft col-xs-6-lft-l">
<span>Tổng Cộng:</span><input class="ttl-hd" value="" readonly="readonly"/>
</div>
<div class="col-xs-6-rgh col-xs-6-lft-r">
<span>' . $i . '</span><input class="ttl-hd" value="' . number_format($total_all_billin_debit) . ' ' . DEFAULT_MONEY_UNIT . '" readonly="readonly"/>
</div>
<div class="clear"></div>
</div>';
// end left
$right_control .= '<span class="control-btn deactivate payments_liability"><i class="fa fa-check-square"></i> Thanh toán công nợ </span>';
$right_control .= '<span class="control-btn deactivate bill_detail"><i class="fa fa-list-alt"></i> Chi tiết hóa đơn </span>';
$right_control .= list_admin_control_button($add_btn, $edit_btn, $trash_btn, 1);
$list = new dataGrid($id_field_o, 10);
$list->add('sup_name', 'Nhà cung cấp', 'string', 1);
$list->add('', 'Số HĐ chưa TT');
$list->add('', 'Tổng tiền chưa TT');
// lấy ra tổng số nhà công nợ hóa đơn nhập
$db_bill_out = new db_query('SELECT *
FROM ' . $bg_table_o . '
LEFT JOIN suppliers ON sup_id = bio_supplier_id
WHERE 1 ' . $list->sqlSearch() . ' AND bio_status = 0
GROUP BY bio_supplier_id');
$total = mysqli_num_rows($db_bill_out->result);
unset($db_bill_out);
// danh sách nhà cung cấp còn nợ
$db_bill_out = new db_query('SELECT sup_id,sup_name, COUNT(bio_money_debit) as hd_ctt, SUM(bio_money_debit) as total_debit
FROM ' . $bg_table_o . '
?>
<li data-group-user="******">
<label class="user_group_name"><b><i class="fa fa-trash fa-fw"></i> Thùng rác (<?php
echo count_item_trash('admin_users');
?>
)</b></label>
</li>
</ul>
<div id="btn-module-permission" class="abs deactivate" onclick="module_permission()">
<span>Phân quyền nhóm tài khoản</span>
</div>
<?php
$left_column = ob_get_contents();
ob_clean();
//Khối bên phải, hiển thị list user tương ứng
$right_control = list_admin_control_button(1, 1, 1, 1);
#Bắt đầu với datagrid
$list = new dataGrid($id_field, 30);
$list->add('', 'Tài khoản');
$list->add('', 'Tên hiển thị');
$list->add('', 'Ghi chú');
//Biến group user
$group_user = getValue('group', 'int', 'POST', 0);
if ($group_user && $isAjaxRequest) {
$sql_extra = ' AND adm_group_id = ' . $group_user . ' ';
} else {
$sql_extra = '';
}
$db_count = new db_count('SELECT count(*) as count
FROM admin_users
WHERE 1 ' . $list->sqlSearch() . $sql_extra . '
$add_btn = getPermissionValue('add');
$edit_btn = getPermissionValue('edit');
$trash_btn = getPermissionValue('trash');
// dem ban ghi trong thung rac
$db_count = new db_count('SELECT count(*) as count FROM trash WHERE tra_table = "' . $bg_table . '"');
$trash_count = $db_count->total;
unset($db_count);
if ($add_btn || $edit_btn || $trash_btn) {
$left_control .= '<div class="modal-control">
<span class="control-btn control-btn-add" onclick="addPromo()"><i class="fa fa-file-o"></i> Thêm mới</span>
<span class="control-btn control-btn-edit deactivate"><i class="fa fa-edit"></i> Sửa</span>
<span class="control-btn control-btn-trash deactivate"><i class="fa fa-trash"></i> Xóa</span>
<span class="control-btn control-btn-recover" onclick="list_trash(\'out\')"><i class="fa fa-recycle"></i> Thùng rác (' . $trash_count . ')</span>
</div>';
}
$right_control = list_admin_control_button(0, 0, 0, 1);
#Bắt đầu với datagrid
$list = new dataGrid($id_field, 30);
$list->add('pms_agency_id', 'Cửa hàng');
$list->add('pms_name', 'Tên chiến dịch');
$list->add('pms_start_time', 'Thòi gian bắt đầu');
$list->add('pms_end_time', 'Thời gian kết thúc');
$db_count = new db_count('SELECT count(*) as count
FROM ' . $bg_table . '
WHERE 1 ' . $list->sqlSearch() . '
');
$total = $db_count->total;
unset($db_count);
// select agencies
$array_agencies = array();
$db_query_agen = new db_query('SELECT * FROM agencies');
log_action(ACTION_LOG_ADD, 'Chỉnh sửa bản ghi ' . $record_id . ' bảng ' . $bg_table);
redirect('index.php');
}
break;
}
}
//Phần hiển thị
//Khởi tạo
$left_control = '';
$left_column = '';
$left_column_title = 'DANH SÁCH KHO HÀNG';
$add_btn = getPermissionValue('add');
$edit_btn = getPermissionValue('edit');
$trash_btn = getPermissionValue('trash');
//control button trái
$left_control = list_admin_control_button($add_btn, $edit_btn, $trash_btn, 1);
//Hiển thị danh sách lý do thu chi
$list = new dataGrid('cat_id', 30);
$list->add('', 'Mô tả');
$db_count = new db_count('SELECT count(*) as count
FROM ' . $bg_table . '
WHERE cat_type = "' . $cat_type . '"');
$total = $db_count->total;
unset($db_count);
$db_listing = new db_query('SELECT *
FROM ' . $bg_table . '
WHERE 1 AND cat_type = "' . $cat_type . '"' . $list->sqlSearch() . '
ORDER BY ' . $list->sqlSort() . ' ' . $id_field . ' ASC
' . $list->limit($total));
$total_row = mysqli_num_rows($db_listing->result);
$left_column .= $list->showHeader($total_row);
