Thêm thanh toán shopee vào hệ thống sẽ giúp kiểm tra đơn hàng được thanh toán hay chưa giúp kế toán .File thanh toán demo ở đây ShopeePay.ps_reports_wallet_all.20200801_20200903
Đầu tiên cần hiển thị đường dẫn đến mục thanh toán trên menu
<li id="products_count_stock">
<a class="submenu" href="<?= admin_url('sales/payment_shopee'); ?>">
<i class="fa fa-plus-circle"></i>
<span class="text"> Up file thanh toán shopee</span>
</a>
</li>
Tiếp theo trong phần đường link upload file ta cần set mod 777
Trong mục controller Sales :
public function payment_shopee()
{
$this->sma->checkPermissions('payments', true);
$paid_by = $this->input->post('paid_by');
if (isset($_FILES["userfile"])) {
$this->load->library('upload');
$config['upload_path'] = $this->digital_upload_path;
$config['allowed_types'] = 'csv';
$config['max_size'] = $this->allowed_file_size;
$config['overwrite'] = true;
$this->upload->initialize($config);
if (!$this->upload->do_upload()) {
echo $this->upload->display_errors();
die;
$error = $this->upload->display_errors();
$this->session->set_flashdata('error', $error);
admin_redirect("sales/payment_shopee");
}
$csv = $this->upload->file_name;
$data['attachment'] = $csv;
$arrResult = array();
// đọc dữ liệu
$handle = fopen($this->digital_upload_path . $csv, "r");
if ($handle) {
while (($row = fgetcsv($handle, 1000000, ",")) !== false) {
$arrResult[] = $row;
}
fclose($handle);
}
#xóa file xls;
unlink($this->digital_upload_path . $csv);
$titles = array_shift($arrResult);
//phân tích dữ liệu
// lấy id các đơn hàng trong file đã sang giao nhận
$array_id_donhang = array();
$array_infocoban_donhang = array();
foreach ($arrResult as $key => $value) {
if (!in_array($value[0], $array_id_donhang) && $value[5] != '') {
$array_id_donhang[] = $value[0];
$array_infocoban_donhang[] = $value;
}
}
for ($i = 4; $i < count($array_infocoban_donhang); $i++) {
$pattern = '/#(.+)/';
$chuoi_donhangcanloc = $array_infocoban_donhang[$i][3];
/* không có điều chỉnh chuỗi
preg_match($pattern, $chuoi_donhangcanloc, $chuoi_id_donhang);
$id_donhang = $chuoi_id_donhang[1];
$sotien_donhang = $array_infocoban_donhang[$i][2];
echo $id_donhang;
echo '<br/>';
*/
$id_donhang = str_replace('Doanh Thu từ Đơn Hàng #2', '2', $chuoi_donhangcanloc);
$id_donhang = str_replace('Adjustment for 2', '2', $id_donhang);
$id_donhang = str_replace('Adjustment', '', $id_donhang);
// chuẩn bị add thanh toán vào
$paid_by ='cash';
$cc_type = 'Visa';
$sale = $this->sales_model->getInfoSalebyReference_no($id_donhang);
$sale_id = $sale->id;
$payment_status = $sale->payment_status;
$date = date('Y-m-d H:i:s');
if ($payment_status =='pending' || $payment_status =='due')
{
$payment = array(
'date' => $date,
'sale_id' => $sale_id,
'reference_no' => $this->input->post('reference_no') ? $this->input->post('reference_no') : $this->site->getReference('pay'),
'amount' => $sale->grand_total ,
'paid_by' => $paid_by,
'cc_type' => $cc_type,
'cc_no' => $this->input->post('paid_by') == 'gift_card' ? $this->input->post('gift_card_no') : $this->input->post('pcc_no'),
'created_by' => $this->session->userdata('user_id'),
'type' => 'received',
);
$customer_id = null;
$status_payment = $this->sales_model->addPayment($payment, $customer_id);
}
//$this->sma->print_arrays($payment);
}
$this->session->set_flashdata('message', 'Thêm thanh toán thành công');
admin_redirect("sales");
} else {
$data['error'] = (validation_errors() ? validation_errors() : $this->session->flashdata('error'));
$bc = array(array('link' => base_url(), 'page' => lang('home')), array('link' => admin_url('sales'), 'page' => lang('sales')), array('link' => '#', 'page' => lang('Thêm file xls từ shopee ')));
$meta = array('page_title' => lang('Thêm thanh toán bằng csv'), 'bc' => $bc);
$this->page_construct('sales/payment_shopee', $meta, $this->data);
}
}
Trong model : Sales_model.php thêm function
public function getInfoSalebyReference_no($reference_no) {
$q = $this->db->get_where('sales', array('reference_no' => $reference_no), 1);
if ($q->num_rows() > 0) {
return $q->row();
}
return FALSE;
}
Trong mục views ở sale thêm file payment_shopee.php
<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>
<?php
header('Content-Type: text/html; charset=UTF-8');
?>
<div class="box">
<div class="box-header">
<h2 class="blue"><i class="fa-fw fa fa-plus"></i><?= lang('Thanh toán shopee '); ?></h2>
</div>
<div class="box-content">
<div class="row">
<div class="col-lg-12">
<p class="introtext"><?php echo lang('enter_info'); ?></p>
<?php
$attrib = array('data-toggle' => 'validator', 'role' => 'form');
echo admin_form_open_multipart("sales/payment_shopee", $attrib);
?>
<div class="row">
<div class="col-lg-12">
<div class="col-md-6">
<div class="form-group">
<h2>File thanh toán shopee</h2>
<input type="file" data-browse-label="<?= lang('browse'); ?>" name="userfile" required="required"
data-show-upload="false" data-show-preview="false" class="form-control file">
</div>
</div>
<div class="clearfix"></div>
<div class="col-sm-4">
<div class="form-group">
<?= lang("paying_by", "paid_by_1"); ?>
<select name="paid_by" id="paid_by_1" class="form-control paid_by">
<?= $this->sma->paid_opts(); ?>
</select>
</div>
</div>
<div class="col-md-12">
<div
class="fprom-group"><?php echo form_submit('add_sale', $this->lang->line("submit"), 'id="add_sale" class="btn btn-primary" style="padding: 6px 15px; margin:15px 0;"'); ?>
<button type="button" class="btn btn-danger" id="reset"><?= lang('reset') ?></div>
</div>
<?php echo form_close(); ?>
</div>
</div>
</div>
</div>
<script type="text/javascript">
$(document).ready(function () {
var $customer = $('#slcustomer');
$customer.change(function (e) {
localStorage.setItem('slcustomer', $(this).val());
//$('#slcustomer_id').val($(this).val());
});
if (slcustomer = localStorage.getItem('slcustomer')) {
$customer.val(slcustomer).select2({
minimumInputLength: 1,
data: [],
initSelection: function (element, callback) {
$.ajax({
type: "get", async: false,
url: site.base_url+"customers/getCustomer/" + $(element).val(),
dataType: "json",
success: function (data) {
callback(data[0]);
}
});
},
ajax: {
url: site.base_url + "customers/suggestions",
dataType: 'json',
quietMillis: 15,
data: function (term, page) {
return {
term: term,
limit: 10
};
},
results: function (data, page) {
if (data.results != null) {
return {results: data.results};
} else {
return {results: [{id: '', text: 'No Match Found'}]};
}
}
}
});
if (count > 1) {
$customer.select2("readonly", true);
$customer.val(slcustomer);
$('#slwarehouse').select2("readonly", true);
//$('#slcustomer_id').val(slcustomer);
}
} else {
nsCustomer();
}
// Order level shipping and discount localStorage
if (sldiscount = localStorage.getItem('sldiscount')) {
$('#sldiscount').val(sldiscount);
}
$('#sltax2').change(function (e) {
localStorage.setItem('sltax2', $(this).val());
});
if (sltax2 = localStorage.getItem('sltax2')) {
$('#sltax2').select2("val", sltax2);
}
$('#slsale_status').change(function (e) {
localStorage.setItem('slsale_status', $(this).val());
});
if (slsale_status = localStorage.getItem('slsale_status')) {
$('#slsale_status').select2("val", slsale_status);
}
var old_payment_term;
$('#slpayment_term').focus(function () {
old_payment_term = $(this).val();
}).change(function (e) {
var new_payment_term = $(this).val() ? parseFloat($(this).val()) : 0;
if (!is_numeric($(this).val())) {
$(this).val(old_payment_term);
bootbox.alert('Unexpected value provided!');
return;
} else {
localStorage.setItem('slpayment_term', new_payment_term);
$('#slpayment_term').val(new_payment_term);
}
});
if (slpayment_term = localStorage.getItem('slpayment_term')) {
$('#slpayment_term').val(slpayment_term);
}
var old_shipping;
$('#slshipping').focus(function () {
old_shipping = $(this).val();
}).change(function () {
if (!is_numeric($(this).val())) {
$(this).val(old_shipping);
bootbox.alert('Unexpected value provided!');
return;
} else {
shipping = $(this).val() ? parseFloat($(this).val()) : '0';
}
localStorage.setItem('slshipping', shipping);
var gtotal = ((total + product_tax + invoice_tax) - total_discount) + shipping;
$('#gtotal').text(formatMoney(gtotal));
});
if (slshipping = localStorage.getItem('slshipping')) {
shipping = parseFloat(slshipping);
$('#slshipping').val(shipping);
} else {
shipping = 0;
}
$('#slref').change(function (e) {
localStorage.setItem('slref', $(this).val());
});
if (slref = localStorage.getItem('slref')) {
$('#slref').val(slref);
}
$('#slwarehouse').change(function (e) {
localStorage.setItem('slwarehouse', $(this).val());
});
if (slwarehouse = localStorage.getItem('slwarehouse')) {
$('#slwarehouse').select2("val", slwarehouse);
}
// prevent default action usln enter
$('body').bind('keypress', function (e) {
if (e.keyCode == 13) {
e.preventDefault();
return false;
}
});
// Order tax calcuation
if (site.settings.tax2 != 0) {
$('#sltax2').change(function () {
localStorage.setItem('sltax2', $(this).val());
loadItems();
return;
});
}
// Order discount calcuation
var old_sldiscount;
$('#sldiscount').focus(function () {
old_sldiscount = $(this).val();
}).change(function () {
var new_discount = $(this).val() ? $(this).val() : '0';
if (is_valid_discount(new_discount)) {
localStorage.removeItem('sldiscount');
localStorage.setItem('sldiscount', new_discount);
loadItems();
return;
} else {
$(this).val(old_sldiscount);
bootbox.alert('Unexpected value provided!');
return;
}
});
//$(document).on('change', '#slnote', function (e) {
// $('#slnote').redactor('destroy');
// $('#slnote').redactor({
// buttons: ['formatting', '|', 'alignleft', 'aligncenter', 'alignright', 'justify', '|', 'bold', 'italic', 'underline', '|', 'unorderedlist', 'orderedlist', '|', 'link', '|', 'html'],
// formattingTags: ['p', 'pre', 'h3', 'h4'],
// minHeight: 100,
// changeCallback: function (e) {
// var v = this.get();
// localStorage.setItem('slnote', v);
// }
// });
// if (slnote = localStorage.getItem('slnote')) {
// $('#slnote').redactor('set', slnote);
// }
// $('#slinnote').redactor('destroy');
// $('#slinnote').redactor({
// buttons: ['formatting', '|', 'alignleft', 'aligncenter', 'alignright', 'justify', '|', 'bold', 'italic', 'underline', '|', 'unorderedlist', 'orderedlist', '|', 'link', '|', 'html'],
// formattingTags: ['p', 'pre', 'h3', 'h4'],
// minHeight: 100,
// changeCallback: function (e) {
// var v = this.get();
// localStorage.setItem('slinnote', v);
// }
// });
// if (slinnote = localStorage.getItem('slinnote')) {
// $('#slinnote').redactor('set', slinnote);
// }
});
function nsCustomer() {
$('#slcustomer').select2({
minimumInputLength: 1,
ajax: {
url: site.base_url + "customers/suggestions",
dataType: 'json',
quietMillis: 15,
data: function (term, page) {
return {
term: term,
limit: 10
};
},
results: function (data, page) {
if (data.results != null) {
return {results: data.results};
} else {
return {results: [{id: '', text: 'No Match Found'}]};
}
}
}
});
}
</script>
