Пример #1
0
 *
 */
$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');
Пример #2
0
$total_all_pay_bill_out = 0;
while ($data_financies_bill_out = mysqli_fetch_assoc($db_financies_bill_out->result)) {
    $i++;
    if ($data_financies_bill_out['fin_pay_type'] == PAY_TYPE_CASH) {
        $fin_pay_type = 'Tiền mặt';
    }
    if ($data_financies_bill_out['fin_pay_type'] == PAY_TYPE_CARD) {
        $fin_pay_type = 'Thẻ';
    }
    $bottom_conten_right_column .= $list->start_tr($i, $data_financies_bill_out['fin_id'], 'class="menu-normal record-item" ondblclick="detail_financies(' . $data_financies_bill_out['fin_id'] . ')" data-record_id="' . $data_financies_bill_out['fin_id'] . '"');
    $bottom_conten_right_column .= '<td class="center" width="100">' . format_codenumber($data_financies_bill_out['fin_id'], 6, '') . '</td>';
    $bottom_conten_right_column .= '<td class="center" width="100">' . date('d/m/Y', $data_financies_bill_out['fin_updated_time']) . '</td>';
    $bottom_conten_right_column .= '<td class="text-right" width="100">' . number_format($data_financies_bill_out['fin_money']) . '</td>';
    $bottom_conten_right_column .= '<td class="center" width="100">' . $fin_pay_type . '</td>';
    $bottom_conten_right_column .= '<td>' . $data_financies_bill_out['fin_note'] . '</td>';
    $bottom_conten_right_column .= $list->end_tr();
    $total_all_pay_bill_out += $data_financies_bill_out['fin_money'];
}
unset($db_financies_bill_out);
$bottom_conten_right_column .= $list->showFooter();
$bottom_conten_right_column .= '<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">
        <input class="ttl-hd" value="' . number_format($total_all_pay_bill_out) . ' ' . DEFAULT_MONEY_UNIT . '" readonly="readonly"/>
    </div>
    <div class="clear"></div>
</div>';
$bottom_right_column .= $bottom_conten_right_column;
$bottom_right_column .= '</div>';
Пример #3
0
    $content_column .= $list->start_tr($i, $row[$id_field], 'class="menu-normal record-item" data-record_id="' . $row[$id_field] . '"');
    /* code something */
    $content_column .= '<td class="center">' . date('d/m/Y h:i', $row['bii_start_time']) . '</td>';
    $content_column .= '<td class="center">' . $location . '</td>';
    $content_column .= '<td class="center">' . format_codenumber($row['bii_id'], 6, PREFIX_BILL_CODE) . '</td>';
    $content_column .= '<td class="text-right">' . number_format($row['bii_true_money']) . '</td>';
    // Số tiền tổng chưa giảm
    $content_column .= '<td class="text-right">' . number_format($row['bii_true_money'] * $row['bii_discount'] / 100) . '</td>';
    $content_column .= '<td class="text-right">' . number_format($row['bii_true_money'] * $row['bii_extra_fee'] / 100) . '</td>';
    $content_column .= '<td class="text-right">' . number_format($total_money_ext * $row['bii_vat'] / 100) . '</td>';
    $content_column .= '<td class="text-right">' . number_format(round($total_money_real, -3)) . '</td>';
    $content_column .= '<td class="text-right">' . number_format($row['bii_type'] == 0 ? $money_real : 0) . '</td>';
    /* Tiền mặt*/
    $content_column .= '<td class="text-right">' . number_format($row['bii_type'] == 1 ? $money_real : 0) . '</td>';
    $content_column .= '<td class="text-right">' . number_format($row['bii_money_debit']) . '</td>';
    $content_column .= $list->end_tr();
    /* Tổng các số tiền dựa theo hóa đơn bán hàng*/
    $all_money_default += $row['bii_true_money'];
    $all_money_discount += $row['bii_true_money'] * $row['bii_discount'] / 100;
    $all_money_real += round($total_money_real, -3);
    /* Tổng tiền*/
    $all_money_vat += $total_money_ext * $row['bii_vat'] / 100;
    $all_money_service += $row['bii_true_money'] * $row['bii_extra_fee'] / 100;
    $all_money_debit += $row['bii_money_debit'];
    $all_money_true += $row['bii_type'] == 0 ? $money_real : 0;
    /*Tiền mặt*/
    $all_money_cash += $row['bii_type'] == 1 ? $money_real : 0;
    /*Tiền mặt*/
}
unset($db_listing);
$content_column .= $list->showFooter();
Пример #4
0
    } else {
        $store_name = $list_store[$row['inv_store_id']];
    }
    if (!$row['inv_admin_id']) {
        $admin_name = '';
    } else {
        $admin_name = $list_admin[$row['inv_admin_id']];
    }
    $listing_menu .= $list->start_tr($i, $row['inv_id'], 'class="menu-trash record-item" id="record_' . $row['inv_id'] . '" onclick="active_record(' . $row['inv_id'] . ')" data-record_id="' . $row['inv_id'] . '"');
    /* code something */
    $listing_menu .= '<td class="center">' . format_codenumber($row['inv_id'], 6) . '</td>';
    $listing_menu .= '<td class="center">' . $staff_name . '</td>';
    $listing_menu .= '<td class="center">' . date('d/m/Y H:i', $row['inv_time']) . '</td>';
    $listing_menu .= '<td class="center">' . $store_name . '</td>';
    $listing_menu .= '<td class="center">' . $admin_name . '</td>';
    $listing_menu .= $list->end_tr();
}
$listing_menu .= $list->showFooter();
$content_column .= $listing_menu;
$content_column .= '</div>';
$rainTpl = new RainTPL();
add_more_css('custom.css', $load_header);
$rainTpl->assign('load_header', $load_header);
$custom_script = file_get_contents('custom_script_inventory.html');
$rainTpl->assign('custom_script', $custom_script);
$rainTpl->assign('content_column', $content_column);
$rainTpl->assign('footer_control', $footer_control);
$rainTpl->draw('mindow_iframe_1column');
?>
<script>
    var mindow_listing_inventory = $('#content-column');
Пример #5
0
$db_query = new db_query('SELECT * FROM units');
while ($row = mysqli_fetch_assoc($db_query->result)) {
    $array_unit[$row['uni_id']] = $row['uni_name'];
}
while ($row = mysqli_fetch_assoc($db_listing->result)) {
    $i++;
    $listing_product .= $list->start_tr($i, $row[$id_field], 'class="menu-normal record-item" ondblclick="detailRecord()" onclick="active_record(' . $row[$id_field] . ')" data-record_id="' . $row[$id_field] . '"');
    /* code something */
    $pro_unit_id = $row['pro_unit_id'];
    $listing_product .= '<td class="center" width="100">' . format_codenumber($row['pro_id'], 6, PREFIX_PRODUCT_CODE) . '</td>';
    $listing_product .= '<td class="center" width="100">' . $row['pro_code'] . '</td>';
    $listing_product .= '<td>' . $row['pro_name'] . '</td>';
    $listing_product .= '<td class="center" width="100">' . $array_unit[$row['pro_unit_id']] . '</td>';
    $listing_product .= '<td class="center" width="100">' . $row['pro_instock'] . '</td>';
    $listing_product .= '<td class="center" width="100">' . $row['pro_quantity'] . '</td>';
    $listing_product .= $list->end_tr();
}
$listing_product .= $list->showFooter();
$right_column .= $listing_product;
$right_column .= '</div>';
// show tab footer
$footer_control .= '
    <div class="button_tab">
        <ul>
            <li><a href="../products/index.php" id="button_tab_active"><i class="fa fa-list"></i> DANH SÁCH MẶT HÀNG</a></li>
            <li><a href="../inventory_transfer/index.php"><i class="fa fa-check"></i> KIỂM KÊ - CHUYỂN KHO</a></li>
        </ul>
    </div>
';
if ($isAjaxRequest) {
    $action = getValue('action', 'str', 'POST', '');
Пример #6
0
$i = 0;
while ($row = mysqli_fetch_assoc($db_listing->result)) {
    $i++;
    if (!$row['cus_code']) {
        $customer_code = format_codenumber($row['cus_id'], 6, PREFIX_CUSTOMER_CODE);
    } else {
        $customer_code = $row['cus_code'];
    }
    $right_column .= $list->start_tr($i, $row[$id_field], 'class="menu-normal record-item" data-customer_code="' . $customer_code . '" data-customer_name="' . $row['cus_name'] . '" data-customer_discount="' . $row['cus_cat_discount'] . '" ondblclick="addToParentWindow(' . $row[$id_field] . ')" onclick="active_record(' . $row[$id_field] . ')" data-record_id="' . $row[$id_field] . '"');
    /* code something */
    $right_column .= '<td class="center">' . format_codenumber($row['cus_id'], 6, PREFIX_CUSTOMER_CODE) . '</td>';
    $right_column .= '<td class="center">' . $row['cus_code'] . '</td>';
    $right_column .= '<td class="center">' . $row['cus_name'] . '</td>';
    $right_column .= '<td class="center">' . $row['cus_address'] . '</td>';
    $right_column .= '<td class="center">' . $row['cus_phone'] . '</td>';
    $right_column .= $list->end_tr();
}
$right_column .= $list->showFooter();
//Phần option lựa chọn customer
$right_column .= '<div class="clearfix"></div>
<div class="col-xs-12">
    <span class="col-xs-4"></span>
    <span class="col-xs-8 text-right"><i>Bấm đúp chuột vào một nhân viên để chọn</i>&nbsp;&nbsp;&nbsp;&nbsp; <i class="fa fa-bell-o"></i> Chọn</span>
</div>';
if ($isAjaxRequest) {
    $action = getValue('action', 'str', 'POST', '');
    switch ($action) {
        case 'listRecord':
            echo $right_column;
            break;
    }
Пример #7
0
    $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);
    unset($supplier);
    $i++;
    $table_right_column .= $list_right->start_tr($i, $row[$id_field_o], '' . $backgrouds . ' class="menu-normal record-item" onclick="active_record(' . $row[$id_field_o] . ',\'right\')" data-debit="' . $row['bio_money_debit'] . '" data-record_id="' . $row[$id_field_o] . '" ondblclick="showDetail(\'right\')"');
    $table_right_column .= '<td class="center" width="80">' . format_codenumber($row[$id_field_o], 6, PREFIX_BILL_CODE) . '</td>';
    $table_right_column .= '<td>' . $row_['sup_name'] . '</td>';
    $table_right_column .= '<td class="center" width="130">' . date('d-m-Y H:i:s', $row['bio_start_time']) . '</td>';
    $table_right_column .= '<td class="text-right" width="100">' . number_format($row['bio_total_money']) . ' ' . DEFAULT_MONEY_UNIT . '</td>';
    $table_right_column .= $list_right->end_tr();
    $totalAll_ += $row['bio_total_money'];
}
$table_right_column .= $list_right->showFooter();
// lấy ra tổng tiền và tổng số hóa đơn
$table_right_column .= '<div class="total-pos">
    <div class="col-xs-6-lft col-xs-6-lft-l">
        <span>Tổng HĐ:</span><input class="ttl-hd" value="' . $total_ . '" readonly="readonly"/>
    </div>
    <div class="col-xs-6-rgh col-xs-6-lft-r">
        <span>Tổng tiền:</span><input class="ttl-hd" value="' . number_format($totalAll_) . ' ' . DEFAULT_MONEY_UNIT . '" readonly="readonly"/>
    </div>
</div>';
$right_column .= $table_right_column;
$right_column .= '</div>';
//hiển thị phần footer , lọc hóa đơn BÁN theo thời gian, theo tên
Пример #8
0
$i = 0;
$array_unit = array();
$db_query = new db_query('SELECT * FROM units');
while ($row = mysqli_fetch_assoc($db_query->result)) {
    $array_unit[$row['uni_id']] = $row['uni_name'];
}
while ($row = mysqli_fetch_assoc($db_listing->result)) {
    $i++;
    $center_column .= $list->start_tr($i, $row[$id_field], 'class="menu-normal record-item" ondblclick="detailRecord()" onclick="active_record(' . $row[$id_field] . ')" data-record_id="' . $row[$id_field] . '"');
    /* code something */
    $center_column .= '<td class="center">' . format_codenumber($row['men_id'], 3) . '</td>';
    $center_column .= '<td>' . $row['men_name'] . '</td>';
    $center_column .= '<td class="center">' . (isset($array_unit[$row['men_unit_id']]) ? $array_unit[$row['men_unit_id']] : '') . '</td>';
    $center_column .= '<td class="text-right">' . format_number($row['men_price']) . ' vnđ</td>';
    $center_column .= '<td class="center">' . '</td>';
    $center_column .= $list->end_tr();
}
$center_column .= $list->showFooter();
//Khối bên phải, hiển thị công thức chế biến tương ứng với menu
$right_control = list_admin_control_button($add_btn, $edit_btn, $trash_btn, 1);
$right_column = '<div class="alert-warning alert text-center">Chọn một thực đơn để xem công thức chế biến</div>';
if ($isAjaxRequest) {
    $action = getValue('action', 'str', 'POST', '');
    switch ($action) {
        case 'listRecord':
            echo $center_column;
            break;
    }
    if ($import_menu) {
        if ($import_menu['type'] === 'application/vnd.ms-excel') {
            echo $center_column;
Пример #9
0
 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;
 }
Пример #10
0
                                         LEFT JOIN units ON pro_unit_id = uni_id
                                         WHERE pro_id = ' . $row['bid_pro_id']);
         $data_pro_unit = mysqli_fetch_assoc($db_pro_unit->result);
         unset($db_pro_unit);
         $pro_name = $data_pro_unit['pro_name'];
         $uni_name = $data_pro_unit['uni_name'];
     }
     $total = $row['bid_pro_price'] * $row['bid_pro_number'];
     $left_column .= $list->start_tr($i, $row['bid_pro_id'], 'class="menu-normal record-item" onclick="active_record(' . $row['bid_pro_id'] . ',\'left\')" data-record_id="' . $row['bid_pro_id'] . '"');
     $left_column .= '<td class="center">' . format_codenumber($row['bid_pro_id'], 6, '') . '</td>';
     $left_column .= '<td>' . $pro_name . '</td>';
     $left_column .= '<td class="center">' . $uni_name . '</td>';
     $left_column .= '<td class="center">' . $row['bid_pro_number'] . '</td>';
     $left_column .= '<td class="text-right">' . number_format($row['bid_pro_price']) . '</td>';
     $left_column .= '<td class="text-right">' . number_format($total) . '</td>';
     $left_column .= $list->end_tr();
     $totalAll += $total;
 }
 unset($menu_listing);
 $left_column .= $list->showFooter();
 // lay ra thong tin cua nha cug cap, trang thai thanh toan,ngay nhap khi xem chi tiet tu trang index
 if (trim($position) == 'right') {
     $db_date_brand_store_status = new db_query('SELECT * FROM bill_out
                                                         LEFT JOIN categories_multi ON bio_store_id = cat_id
                                                         LEFT JOIN suppliers ON bio_supplier_id = sup_id
                                                         WHERE bio_id = ' . $data_record_id);
 }
 // lay ra thong tin cua nha cug cap, trang thai thanh toan,ngay nhap khi xem chi tiet tu trong thung rac
 if (trim($position) == 'bill_out') {
     $db_date_brand_store_status = new db_query('SELECT * FROM trash
                                                     WHERE tra_record_id = ' . $data_record_id . '
Пример #11
0
                                    ASC ' . $list->limit($total));
$total_row = mysqli_num_rows($db_list_bill->result);
$content_column .= '<div id="table_result">';
$table_result = '';
$table_result .= $list->showHeader($total_row);
$i = 0;
while ($data_bill = mysqli_fetch_assoc($db_list_bill->result)) {
    $i++;
    $table_result .= $list->start_tr($i, $data_bill[$bill_id], 'class="menu-normal record-item" onclick="active_record(' . $data_bill[$bill_id] . ')"');
    $table_result .= '<td class="center">' . format_codenumber($data_bill[$bill_id], 6, '') . '</td>';
    $table_result .= '<td class="center"  width="170">' . date("d-m-Y h:i", $data_bill[$date]) . '</td>';
    $table_result .= '<td class="text-right" width="100">' . number_format($data_bill[$debit]) . '</td>';
    $table_result .= '<td class="text-right"> </td>';
    $table_result .= '<td class="center">Chưa Thanh Toán</td>';
    $obj = $name_obj . ': <b>' . $data_bill[$name] . '</b>';
    $table_result .= $list->end_tr();
}
$table_result .= $list->showFooter();
$content_column .= $table_result;
$content_column .= '</div>';
$footer_control .= '<div class="name_obj">' . $obj . '</div>';
$footer_control .= '<span class="bill-close"><i class="fa fa-sign-out"></i> Đóng cửa sổ</span>';
if ($isAjaxRequest) {
    echo $table_result;
    die;
}
$rainTpl = new RainTPL();
add_more_css('css_detail.css', $load_header);
$rainTpl->assign('load_header', $load_header);
$rainTpl->assign('top_control', $top_control);
$rainTpl->assign('content_column', $content_column);
Пример #12
0
 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);
 }
Пример #13
0
 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));
 }
Пример #14
0
    <td>
        <?php 
    echo form_input('use_phone' . $row[$id_field], $row['use_phone'], 'class="span3" onkeyup="check_edit(\'record_' . $i . '\')"');
    ?>
    </td>
    <td>
        <?php 
    echo form_input('use_contact' . $row[$id_field], $row['use_contact'], 'class="span3" onkeyup="check_edit(\'record_' . $i . '\')"');
    ?>
    </td>
    <?php 
    echo $list->showCheckbox('use_active', $row['use_active'], $row[$id_field]);
    ?>
    <?php 
    echo $list->showEdit($row[$id_field]);
    ?>
    <?php 
    echo $list->showDelete($row[$id_field]);
    ?>
    <?php 
    echo $list->end_tr();
    ?>
    <?php 
}
?>
    <?php 
echo $list->showFooter();
?>
</div>
</body>
</html>