} 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);