require_once 'inc_security.php'; if (!isset($_GET['id'])) { die; } $record_id = getValue('id', 'int', 'GET', 0); $content_column = ''; $footer_control = ''; $list = new dataGrid($record_id, 1); $list->add('', 'Số HĐ'); $list->add('', 'Ngày ghi nợ'); $list->add('', 'Tổng ghi nợ'); $list->add('', 'Thanh toán'); $db_financies = new db_query('SELECT * FROM financial WHERE fin_id = ' . $record_id . ' ORDER BY ' . $list->sqlSort() . ' fin_id ASC ' . $list->limit(1)); if ($data_financial = mysqli_fetch_assoc($db_financies->result)) { //số tiền thanh toán $thanhtoan = $data_financial['fin_money']; // nếu fin cat id là thanh toán công nợ khách hàng thì select bảng bill in lấy ra ngày nợ túc là ngày tạo hóa đơn nợ if ($data_financial['fin_cat_id'] == 33) { $db_bill = new db_query('SELECT * FROM bill_in WHERE bii_id = ' . $data_financial['fin_billcode']); if ($data_bill = mysqli_fetch_assoc($db_bill->result)) { $ngay_no = $data_bill['bii_end_time']; $bill_id = $data_bill['bii_id']; $so_no = $data_bill['bii_money_debit'] + $data_financial['fin_money']; } } elseif ($data_financial['fin_cat_id'] == 32) { $db_bill = new db_query('SELECT * FROM bill_out WHERE bio_id = ' . $data_financial['fin_billcode']); if ($data_bill = mysqli_fetch_assoc($db_bill->result)) { $ngay_no = $data_bill['bio_start_time'];
* */ $list->add('dic_key', 'Nội dung', 'string', 1, 0); $list->add('dic_translate_en', 'Bản dịch', 'string'); $list->add('', 'Edit', 'edit'); $list->add('', 'Delete', 'delete'); $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch() . ' '); $total = $db_count->total; unset($db_count); $db_listing = new db_query('SELECT * FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch() . ' ORDER BY ' . $list->sqlSort() . ' ' . $id_field . ' DESC ' . $list->limit($total)); $total_row = mysqli_num_rows($db_listing->result); $table_header = $list->showHeader($total_row); $rainTpl->assign('table_header', $table_header); $table_footer = $list->showFooter(); $rainTpl->assign('table_footer', $table_footer); $table_listing = array(); $i = 0; while ($row = mysqli_fetch_assoc($db_listing->result)) { $i++; $array_td = array('<td width="50%">' . $row['dic_key'] . '</td>', '<td width="50%">' . $row['dic_translate_en'] . '</td>', $list->showEdit($row[$id_field]), $list->showDelete($row[$id_field])); $table_listing[] = array('start_tr' => $list->start_tr($i, $row[$id_field]), 'end_tr' => $list->end_tr(), 'array_td' => $array_td); } $rainTpl->assign('table_listing', $table_listing); $rainTpl->draw('listing');
function listRecord() { global $id_field; global $bg_table; global $cat_field; $cat_id = getValue('cat_id', 'str', 'POST', 0); $html = ''; $class_context_menu = 'menu-normal'; #Bắt đầu với datagrid $list = new dataGrid($id_field, 30); /*code something*/ $list->add('', 'Tên cửa hàng'); $list->add('', 'Điện thoại'); switch ($cat_id) { case 'all': $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch()); $total = $db_count->total; unset($db_count); $db_listing = new db_query('SELECT * FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch() . ' ORDER BY ' . $list->sqlSort() . ' ' . $id_field . ' ASC ' . $list->limit($total)); $array_row = $db_listing->resultArray(); unset($db_listing); break; case 'trash': $class_context_menu = 'menu-trash'; $db_count = new db_count('SELECT count(*) as count FROM trash WHERE tra_table = "' . $bg_table . '"'); $total = $db_count->total; unset($db_count); $array_row = trash_list($bg_table); $list->limit($total); break; default: $cat_id = (int) $cat_id; $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch() . ' AND ' . $cat_field . ' = ' . $cat_id); $total = $db_count->total; unset($db_count); $db_listing = new db_query('SELECT * FROM ' . $bg_table . ' WHERE 1 ' . $list->sqlSearch() . ' AND ' . $cat_field . ' = ' . $cat_id . ' ORDER BY ' . $list->sqlSort() . ' ' . $id_field . ' ASC ' . $list->limit($total)); $array_row = $db_listing->resultArray(); unset($db_listing); break; } $total_row = count($array_row); $html .= $list->showHeader($total_row); $i = 0; foreach ($array_row as $row) { $i++; $html .= $list->start_tr($i, $row[$id_field], 'class="' . $class_context_menu . ' record-item" onclick="active_record(' . $row[$id_field] . ')" data-record_id="' . $row[$id_field] . '"'); /*code something */ $html .= '<td>' . $row['sed_name'] . '</td>'; $html .= '<td class="right">' . $row['sed_phone'] . '</td>'; $html .= $list->end_tr(); } $html .= $list->showFooter(); echo $html; }
$and_bio_sup_id .= $type_bill_fillter . ' <= ' . $time_end; } } else { $and_bio_sup_id = $type_bill_fillter . ' >= ' . (convertDateTime($today, '0:0:0') - 2592000) . $type_bill_fillter . ' <= ' . convertDateTime($today, '23:59:59'); } $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_table_o . ' WHERE 1 ' . $list_right->sqlSearch() . $and_bio_sup_id . ' '); $total_ = $db_count->total; unset($db_count); $db_listing = new db_query('SELECT * FROM ' . $bg_table_o . ' WHERE 1 ' . $list_right->sqlSearch() . $and_bio_sup_id . ' ORDER BY ' . $list_right->sqlSort() . ' ' . $id_field_o . ' ASC ' . $list_right->limit($total_)); $total_row = mysqli_num_rows($db_listing->result); $right_column .= '<div id="table_bill_out">'; $table_right_column = ''; $table_right_column .= $list_right->showHeader($total_row, '', 'id="table-listing-right"'); $i = 0; $totalAll_ = 0; while ($row = mysqli_fetch_assoc($db_listing->result)) { $backgrouds = ''; if ($row['bio_status'] == BILL_STATUS_DEBIT && $row['bio_money_debit'] != 0) { $backgrouds = 'style="background:#B3F8FF;"'; } $supplier = new db_query('SELECT sup_name FROM suppliers WHERE sup_id = ' . $row['bio_supplier_id']); $row_ = mysqli_fetch_assoc($supplier->result);
$to_date = convertDateTime($to_date, '0:0:0') + 86400 - 1; $And .= ' AND ' . $time_order_field . ' <= ' . $to_date; } if ($adm_user_report > 0) { $And .= ' AND fin_admin_id = ' . $adm_user_report; } } else { $And = 'AND ' . $time_order_field . ' >= ' . ($today - 2592000) . ' AND ' . $time_order_field . ' <= ' . $today; } $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_financial . ' WHERE 1 ' . $list->sqlSearch() . $And . ' AND fin_cat_id IN (' . FINANCIAL_CAT_NHAP_HANG . ', ' . FINANCIAL_CAT_CONG_NO_NHAP_HANG . ')'); $total = $db_count->total; unset($db_count); $db_financial_bill_out = new db_query("SELECT * FROM " . $bg_financial . "\n WHERE 1 " . $list->sqlSearch() . $And . " \n AND fin_cat_id IN(" . FINANCIAL_CAT_NHAP_HANG . ", " . FINANCIAL_CAT_CONG_NO_NHAP_HANG . ")\n ORDER BY " . $time_order_field . " ASC\n " . $list->limit($total) . " \n "); $total_financial_bill_out = mysqli_num_rows($db_financial_bill_out->result); $right_column = $list->showHeader($total_financial_bill_out); $i = 0; $total_fund = 0; $data_financial_bill_out = array(); $compare_dates = array(); $arrDate = array(); while ($data_financial = mysqli_fetch_assoc($db_financial_bill_out->result)) { $arrDate['cash'] = 0; $arrDate['card'] = 0; $date = gmdate("d/m/Y", $data_financial['fin_updated_time']); $data_financial_bill_out[$date] = $data_financial; $arrDate['id_fin'] = $data_financial['fin_id']; $arrDate['date'] = $data_financial['fin_updated_time']; $arrDate['money'] = $data_financial['fin_money'];
$list->add('bid_pro_number', 'SL'); $list->add('bid_pro_price', 'Đơn giá'); $list->add('', 'Thành tiền'); // xem chi tiet hoa don nhap tu trang index if (trim($position) == 'right') { $db_count = new db_count('SELECT count(*) as count FROM bill_out_detail WHERE 1 ' . $list->sqlSearch() . ' AND bid_bill_id = ' . $data_record_id . ' '); $total = $db_count->total; unset($db_count); // danh sach san pham nhap trong hoa don $menu_listing = new db_query('SELECT * FROM bill_out_detail LEFT JOIN products ON bid_pro_id = pro_id LEFT JOIN units ON pro_unit_id = uni_id WHERE bid_bill_id = ' . $data_record_id . ' ' . $list->limit($total)); } // xem chi tiet hoa don nhâp từ trong thung rac if (trim($position) == 'bill_out') { $db_count_bill_in_trash = new db_count('SELECT count(*) as count FROM trash WHERE 1 ' . $list->sqlSearch() . ' AND tra_record_id = ' . $data_record_id . ' AND tra_table = \'bill_out_detail\''); $total = $db_count_bill_in_trash->total; unset($db_count_bill_in_trash); // lọc danh sách thực đơn của hóa đơn $menu_listing = new db_query('SELECT * FROM trash WHERE tra_record_id = ' . $data_record_id . ' AND tra_table = \'bill_out_detail\'' . $list->limit($total)); }
$And .= ' AND bii_staff_id = ' . $user_report; } if ($adm_user_report >= 0) { $And .= ' AND bii_admin_id = ' . $adm_user_report; } } else { $time_order_field = 'bii_start_time'; $And = 'AND ' . $time_order_field . ' >= ' . ($today - 2592000) . ' AND ' . $time_order_field . ' <= ' . $today; } $db_count = new db_count('SELECT count(*) as count FROM ' . $bg_table_i . ' WHERE 1 ' . $list->sqlSearch() . $And . ' '); $total = $db_count->total; unset($db_count); $db_bill_in = new db_query("SELECT * FROM " . $bg_table_i . "\n WHERE 1 " . $And . "\n ORDER BY " . $time_order_field . " ASC\n " . $list->limit($total) . " \n "); $total_bill_in = mysqli_num_rows($db_bill_in->result); $right_column = $list->showHeader($total_bill_in); $i = 0; $total_fund = 0; $date_money = array(); $aray = array(); $data = array(); while ($data_bill_in = mysqli_fetch_assoc($db_bill_in->result)) { $aray['id'] = $data_bill_in['bii_id']; $aray['date'] = $data_bill_in['bii_start_time']; $aray['money'] = $data_bill_in['bii_true_money']; $date_money[] = $aray; // $date = gmdate("d-m-Y", $data_bill_in['bii_start_time']); // lay ra ngay tao hoa don
$list = new dataGrid($bill_id, 10); $list->add($bill_id, 'Số HĐ'); $list->add('', $type); $list->add('', $date); $list->add('', 'Tổng tiền'); $list->add('', 'Ghi chú'); // tổng số hóa đơn trong thùng rác $count_bill_trash = new db_count('SELECT count(*) as count FROM trash WHERE 1 ' . $list->sqlSearch() . ' AND tra_table = "' . $table . '" '); $total = $count_bill_trash->total; unset($count_bill_trash); $db_list_bill_trash = new db_query('SELECT * FROM trash WHERE tra_table = "' . $table . '" ' . $list->limit($total)); $total = mysqli_num_rows($db_list_bill_trash->result); unset($db_list_bill_trash); // lọc ra thông tin hóa đơn trong thùng rác $array_bill = trash_list($table, $total, 0); $i = 0; $content_column .= '<div class="section-content">'; $content_column .= $list->showHeader($total, '', 'id="list_trash"'); foreach ($array_bill as $row) { $i++; if ($row[$id_object] == 0) { $name = $name_obj; } else { $db_list_bill = new db_query('SELECT ' . $name_object . ' FROM ' . $table_object . ' WHERE ' . $id . ' = ' . $row[$id_object]); $data_list_bill = mysqli_fetch_assoc($db_list_bill->result); unset($db_list_bill);
function fillerStockTransfer() { $right_column = ''; //Hiển thị danh sách phiếu thu bên trái #Bắt đầu với datagird $list = new dataGrid('sto_id', 30); $list->add('', 'Số phiếu'); $list->add('', 'Nhân viên chuyển'); $list->add('', 'Ngày chuyển'); $list->add('', 'Từ kho'); $list->add('', 'Đến kho'); // lấy biên từ form tìm kiếm theo ngày và nhân viên $start_date_in = getValue('start_date_in', 'str', 'POST', 0); $date_from = convertDateTime($start_date_in, '0:0:0'); $end_date_in = getValue('end_date_in', 'str', 'POST', 0); $date_to = convertDateTime($end_date_in, '0:0:0'); $staff_id = getValue('list_staff_id', 'int', 'POST', 0); if ($start_date_in && $end_date_in && $staff_id) { $search_sql = ' AND sto_time >=' . $date_from . ' AND sto_time <=' . $date_to . ' AND sto_staff_id = ' . $staff_id . ' '; } elseif ($staff_id) { $search_sql = ' AND sto_staff_id = ' . $staff_id . ''; } elseif ($start_date_in && $end_date_in) { $search_sql = ' AND sto_time >=' . $date_from . ' AND sto_time <=' . $date_to . ''; } else { $search_sql = ''; } // slect list danh sách phiếu kiểm kê $db_count = new db_count('SELECT count(*) as count FROM stock_transfer WHERE 1 ' . $list->sqlSearch() . $search_sql . ' '); $total = $db_count->total; unset($db_count); $sql_query = 'SELECT * FROM stock_transfer WHERE 1 ' . $list->sqlSearch() . $search_sql . ' ORDER BY ' . $list->sqlSort() . ' sto_id DESC ' . $list->limit($total); $db_listing = new db_query($sql_query); $total_row = mysqli_num_rows($db_listing->result); // tạo mảng để hiện thị tên nhân viên $staff_array = array(); $db_staff = new db_query('SELECT * FROM users'); while ($row_user = mysqli_fetch_assoc($db_staff->result)) { $staff_array[$row_user['use_id']] = $row_user['use_name']; } // tạo mảng để hiện thị kho hàng $store_array = array(); $db_store = new db_query('SELECT * FROM categories_multi WHERE cat_type = "stores" '); while ($row_store = mysqli_fetch_assoc($db_store->result)) { $store_array[$row_store['cat_id']] = $row_store['cat_name']; } //Vì đây là module cần 2 table listing nên khai báo thêm table_extra id=table-listing-left $right_column .= $list->showHeader($total_row, '', 'id="table-listing-right"'); $i = 0; while ($row = mysqli_fetch_assoc($db_listing->result)) { $i++; $right_column .= $list->start_tr($i, $row['sto_id'], 'class="menu-normal record-item" ondblclick="detail_stock_transfer(' . $row['sto_id'] . ')" dblclick="detail_record(' . $row['sto_id'] . ')" onclick="active_record(' . $row['sto_id'] . ')" data-record_id="' . $row['sto_id'] . '"'); /* code something */ //Số phiếu - ID phiếu $right_column .= '<td class="center" width="">' . format_codenumber($row['sto_id'], 6) . '</td>'; //Người trả $right_column .= '<td width="120" class="center">' . $staff_array[$row['sto_staff_id']] . '</td>'; //Mô tả $right_column .= '<td class="center">' . date('d/m/Y H:i', $row['sto_time']) . '</td>'; //số tiền $right_column .= '<td width="120" class="text-left">' . $store_array[$row['sto_from_storeid']] . '</td>'; $right_column .= '<td width="120" class="text-left">' . $store_array[$row['sto_to_storeid']] . '</td>'; $right_column .= $list->end_tr(); } $right_column .= $list->showFooter(); $this->add($right_column); }
function reportProducts() { $array_return = array(); //lấy các giá trị bắn ajax về để xuất báo cáo $array_product = getValue('products', 'arr', 'POST', ''); if (!$array_product) { $array_return['content'] = 'Chưa chọn sản phẩm'; die(json_encode($array_return)); } $store_id = getValue('store_id', 'int', 'POST', 0); if (!$store_id) { $array_return['content'] = 'Chưa chọn kho hàng'; die(json_encode($array_return)); } $start_date = convertDateTime(getValue('start_date', 'str', 'POST', ''), '0:0:0'); $end_date = convertDateTime(getValue('end_date', 'str', 'POST', ''), '0:0:0'); // select ra báo cáo với các thông tin trên //lấy số lượng nhập hàng $arr_pro = array(); foreach ($array_product as $product) { $arr_pro[] = $product; } $arr_pro = implode(',', $arr_pro); $left_column = ''; //Hiển thị danh sách phiếu thu bên trái #Bắt đầu với datagird $list = new dataGrid('pro_id', 100); $list->add('', 'Tên mặt hàng'); $list->add('', 'ĐVT'); $list->add('', 'SL nhập'); $list->add('', 'Tổng tiền tồn'); // tảo mảng bill_id lọc theo thời gian và theo kho hàng $array_bill = array(); $db_bill_out = new db_query('SELECT bio_id FROM bill_out WHERE bio_start_time >= ' . $start_date . ' AND bio_start_time <=' . $end_date . ' AND bio_store_id = ' . $store_id . ''); while ($row_bill_out = mysqli_fetch_assoc($db_bill_out->result)) { $array_bill[] = $row_bill_out['bio_id']; } unset($db_bill_out); $array_bill = implode(',', $array_bill); if ($array_bill == null) { $sql_search = ' AND bid_bill_id IN(0)'; } else { $sql_search = ' AND bid_pro_id IN(' . $arr_pro . ') AND bid_bill_id IN(' . $array_bill . ')'; } // select list danh $db_count = new db_count('SELECT count(*) as count FROM bill_out_detail WHERE 1 ' . $list->sqlSearch() . $sql_search . ' GROUP BY bid_pro_id '); $total = $db_count->total; unset($db_count); $sql_query = 'SELECT * FROM bill_out_detail WHERE 1 ' . $list->sqlSearch() . $sql_search . ' GROUP BY bid_pro_id ORDER BY ' . $list->sqlSort() . ' bid_pro_id ASC ' . $list->limit($total); $db_listing = new db_query($sql_query); $total_row = mysqli_num_rows($db_listing->result); //tao mang hien thi ten product $array_pro_name = array(); $db_product = new db_query('SELECT pro_id,pro_name FROM products'); while ($row_pro = mysqli_fetch_assoc($db_product->result)) { $array_pro_name[$row_pro['pro_id']] = $row_pro['pro_name']; } //Vì đây là module cần 2 table listing nên khai báo thêm table_extra id=table-listing-left $left_column .= $list->showHeader($total_row, '', 'id="table-listing-right"'); $i = 0; $total_all = 0; while ($row = mysqli_fetch_assoc($db_listing->result)) { $i++; // lấy ra pro_unit_id để $db_query_unit = new db_query('SELECT pro_unit_id FROM products WHERE pro_id = ' . $row['bid_pro_id'] . ' '); $row_pro_unit = mysqli_fetch_assoc($db_query_unit->result); // lấy ra đơn vị tính của sản phẩm $db_unit_name = new db_query('SELECT uni_name FROM units WHERE uni_id = ' . $row_pro_unit['pro_unit_id'] . ''); $row_unit = mysqli_fetch_assoc($db_unit_name->result); //tính tổng số lượng và giá tiền theo mặt hàng $db_price_ave = new db_query('SELECT SUM(bid_pro_price) AS total_price, SUM(bid_pro_number) AS total_number FROM bill_out_detail WHERE bid_pro_id = ' . $row['bid_pro_id'] . ''); $row_total = mysqli_fetch_assoc($db_price_ave->result); $left_column .= $list->start_tr($i, $row['bid_pro_id'], 'class="menu-normal record-item" data-record_id="' . $row['bid_pro_id'] . '"'); /* code something */ $left_column .= '<td class="text-left">' . $array_pro_name[$row['bid_pro_id']] . '</td>'; $left_column .= '<td width="100" class="center">' . $row_unit['uni_name'] . '</td>'; $left_column .= '<td width="120" class="text-right">' . $row_total['total_number'] . '</td>'; $left_column .= '<td width="120" class="text-right">' . number_format($row_total['total_price']) . '</td>'; // tổng tiền tất cả mặt hàng đã chọn $total_all += $row_total['total_number'] * $row_total['total_price']; $left_column .= $list->end_tr(); } unset($db_count_price); unset($db_price_ave); unset($db_listing); unset($db_unit_name); unset($db_query_unit); $left_column .= $list->showFooter(); $array_return['content'] = $left_column; $array_return['total'] = number_format($total_all); die(json_encode($array_return)); }
$list = new dataGrid('pms_id', 100, '#mindow-listing-promotions'); $list->add('', 'Cửa hàng'); $list->add('', 'Tên chiến dịch'); $list->add('', 'Ngày bắt đầu'); $list->add('', 'Ngày kết thúc'); $list->add('', 'Giảm'); $list->add('', 'Kiểu KM'); $list->add('', 'Điều kiện HĐ'); $db_count = new db_count('SELECT count(*) as count FROM trash WHERE tra_table = "' . $bg_table . '" '); $total = $db_count->total; unset($db_count); $array_row = trash_list($bg_table, 30, 0); $list->limit($total); $total_row = count($array_row); $content_column .= $list->showHeader($total_row, '', 'id="table-trash"'); $i = 0; //Lấy ra list cửa hàng $list_agencies = array(); $db_query_agencies = new db_query("SELECT * FROM agencies"); $list_agencies = array(); while ($row = mysqli_fetch_assoc($db_query_agencies->result)) { $list_agencies[$row['age_id']] = $row['age_name']; } unset($db_query_agencies); // select các bản ghi trong thung rác foreach ($array_row as $row) { $i++; $content_column .= $list->start_tr($i, $row[$id_field], 'class="' . $class_context_menu . ' record-item" onclick="active_record(' . $row[$id_field] . ')" data-record_id="' . $row[$id_field] . '"');