API Module Sale - loukmho/BCAccount_API GitHub Wiki
BCAccount_API
Module Sale
1.BCArInvoice ขายสินค้า
Model
type ArInvoice struct {
SaveFrom int `json:"save_from" db:"SaveFrom"`
Source int `json:"source" db:"Source"`
DocNo string `json:"doc_no" db:"DocNo"`
DocDate string `json:"doc_date" db:"DocDate"`
InvOutPutTax
InvCustomer
InvSaleMan
CreatorCode string `json:"creator_code" db:"CreatorCode"`
CreateDateTime string `json:"create_date_time" db:"CreateDateTime"`
LastEditorCode string `json:"last_editor_code" db:"LastEditorCode"`
LastEditDateT string `json:"last_edit_date_t" db:"LastEditDateT"`
TaxType int `json:"tax_type" db:"TaxType"`
DepartCode string `json:"depart_code" db:"DepartCode"`
CreditDay int `json:"credit_day" db:"CreditDay"`
DeliveryDay int `json:"delivery_day" db:"DeliveryDay"`
DeliveryDate string `json:"delivery_date" db:"DeliveryDate"`
DueDate string `json:"due_date" db:"DueDate"`
PayBillDate string `json:"pay_bill_date" db:"PayBillDate"`
TaxRate float64 `json:"tax_rate" db:"TaxRate"`
IsConfirm int `json:"is_confirm" db:"IsConfirm"`
MyDescription string `json:"my_description" db:"MyDescription"`
BillType int `json:"bill_type" db:"BillType"`
BillGroup string `json:"bill_group" db:"BillGroup"`
RefDocNo string `json:"ref_doc_no" db:"RefDocNo"`
DeliveryAddr string `json:"delivery_addr" db:"DeliveryAddr"`
ContactCode string `json:"contact_code" db:"ContactCode"`
SumOfItemAmount float64 `json:"sum_of_item_amount" db:"SumOfItemAmount"`
DiscountWord string `json:"discount_word" db:"DiscountWord"`
DiscountAmount float64 `json:"discount_amount" db:"DiscountAmount"`
AfterDiscount float64 `json:"after_discount" db:"AfterDiscount"`
BeforeTaxAmount float64 `json:"before_tax_amount" db:"BeforeTaxAmount"`
TaxAmount float64 `json:"tax_amount" db:"TaxAmount"`
TotalAmount float64 `json:"total_amount" db:"TotalAmount"`
ZeroTaxAmount float64 `json:"zero_tax_amount" db:"ZeroTaxAmount"`
ExceptTaxAmount float64 `json:"except_tax_amount" db:"ExceptTaxAmount"`
SumCashAmount float64 `json:"sum_cash_amount" db:"SumCashAmount"`
SumChqAmount float64 `json:"sum_chq_amount" db:"SumChqAmount"`
SumCreditAmount float64 `json:"sum_credit_amount" db:"SumCreditAmount"`
SumBankAmount float64 `json:"sum_bank_amount" db:"SumBankAmount"`
DepositIncTax int `json:"deposit_inc_tax" db:"DepositIncTax"`
SumOfDeposit1 float64 `json:"sum_of_deposit_1" db:"SumOfDeposit1"`
SumOfDeposit2 float64 `json:"sum_of_deposit_2" db:"SumOfDeposit2"`
SumOfWTax float64 `json:"sum_of_w_tax" db:"SumOfWTax"`
NetDebtAmount float64 `json:"net_debt_amount" db:"NetDebtAmount"`
HomeAmount float64 `json:"home_amount" db:"HomeAmount"`
OtherIncome float64 `json:"other_income" db:"OtherIncome"`
OtherExpense float64 `json:"other_expense" db:"OtherExpense"`
ExcessAmount1 float64 `json:"excess_amount_1" db:"ExcessAmount1"`
ExcessAmount2 float64 `json:"excess_amount_2" db:"ExcessAmount2"`
BillBalance float64 `json:"bill_balance" db:"BillBalance"`
CurrencyCode string `json:"currency_code" db:"CurrencyCode"`
ExchangeRate float64 `json:"exchange_rate" db:"ExchangeRate"`
GLFormat string `json:"gl_format" db:"GLFormat"`
IsCancel int `json:"is_cancel" db:"IsCancel"`
IsCompleteSave int `json:"is_complete_save" db:"IsCompleteSave"`
AllocateCode string `json:"allocate_code" db:"AllocateCode"`
ProjectCode string `json:"project_code" db:"ProjectCode"`
RecurName string `json:"recur_name" db:"RecurName"`
ConfirmCode string `json:"confirm_code" db:"ConfirmCode"`
ConfirmDateTime string `json:"confirm_date_time" db:"ConfirmDateTime"`
CancelCode string `json:"cancel_code" db:"CancelCode"`
CancelDateTime string `json:"cancel_date_time" db:"CancelDateTime"`
IsConditionSend int `json:"is_condition_send" db:"IsConditionSend"`
PayBillAmount float64 `json:"pay_bill_amount" db:"PayBillAmount"`
SORefNo string `json:"so_ref_no" db:"SORefNo"`
HoldingStatus int `json:"holding_status" db:"HoldingStatus"`
PosStatus int `json:"pos_status" db:"PosStatus"`
CreditBaseAmount float64 `json:"credit_base_amount" db:"CreditBaseAmount"`
UserCode string `json:"user_code" db:"UserCode"`
Pos
ListInvRecMoney
Subs []*InvItem `json:"subs"`
Deps []*ListInvArDepositUsed `json:"deps"`
Cdcs []*ListInvCreditCard `json:"cdcs"`
Chqs []*ListInvChqIn `json:"chqs"`
}
type InvOutPutTax struct {
TaxNo string `json:"tax_no" db:"TaxNo"`
TaxDate string `json:"tax_date" db:"TaxDate"`
BookCode string `json:"book_code" db:"BookCode"`
}
type InvCustomer struct {
ArCode string `json:"ar_code" db:"ArCode"`
ArName string `json:"ar_name" db:"ArName"`
}
type InvSaleMan struct {
SaleCode string `json:"sale_code" db:"SaleCode"`
SaleName string `json:"sale_name" db:"SaleName"`
}
type Pos struct {
ShiftCode string `json:"shiftcode" db:"ShiftCode"`
CashierCode string `json:"cashier_code" db:"CashierCode"`
ShiftNo string `json:"shift_no" db:"ShiftNo"`
MachineNo string `json:"machine_no" db:"MachineNo"`
MachineCode string `json:"machine_code" db:"MachineCode"`
BillTime string `json:"bill_time" db:"BillTime"`
CoupongAmount float64 `json:"coupong_amount" db:"CoupongAmount"`
ChangeAmount float64 `json:"change_amount" db:"ChangeAmount"`
ChargeAmount float64 `json:"charge_amount" db:"ChargeAmount"`
GrandTotal float64 `json:"grand_total" db:"GrandTotal"`
}
type InvItem struct {
MyType int `json:"my_type" db:"MyType"`
ItemCode string `json:"item_code" db:"ItemCode"`
MyDescription string `json:"my_description" db:"MyDescription"`
ItemName string `json:"item_name" db:"ItemName"`
WHCode string `json:"wh_code" db:"WHCode"`
ShelfCode string `json:"shelf_code" db:"ShelfCode"`
CNQty float64 `json:"cn_qty" db:"CNQty"`
Qty float64 `json:"qty" db:"Qty"`
Price float64 `json:"price" db:"Price"`
DiscountWord string `json:"discount_word" db:"DiscountWord"`
DiscountAmount float64 `json:"discount_amount" db:"DiscountAmount"`
Amount float64 `json:"amount" db:"Amount"`
NetAmount float64 `json:"net_amount" db:"NetAmount"`
HomeAmount float64 `json:"home_amount" db:"HomeAmount"`
SumOfCost float64 `json:"sum_of_cost" db:"SumOfCost"`
BalanceAmount float64 `json:"balance_amount" db:"BalanceAmount"`
UnitCode string `json:"unit_code" db:"UnitCode"`
SORefNo string `json:"so_ref_no" db:"SORefNo"`
PORefNo string `json:"po_ref_no" db:"PORefNo"`
LineNumber int `json:"line_number" db:"LineNumber"`
RefLineNumber int `json:"ref_line_number" db:"RefLineNumber"`
IsCancel int `json:"is_cancel" db:"IsCancel"`
BarCode string `json:"bar_code" db:"BarCode"`
PosStatus int `json:"posstatus" db:"PosStatus"`
IsConditionSend int `json:"is_condition_send" db:"IsConditionSend"`
AverageCost float64 `json:"averagecost" db:"AverageCost"`
LotNumber string `json:"lot_number" db:"LotNumber"`
StockType int `json:"stock_type" db:"StockType"`
PackingRate1 float64 `json:"packing_rate_1" db:"PackingRate1"`
PackingRate2 float64 `json:"packing_rate_2" db:"PackingRate2"`
}
type ListInvRecMoney struct {
CreditType string `json:"credit_type" db:"CreditType"`
ConfirmNo string `json:"confirm_no" db:"ConfirmNo"`
CreditRefNo string `json:"credit_ref_no" db:"CreditRefNo"`
CreditDueDate string `json:"credit_due_date" db:"CreditDueDate"`
BankCode string `json:"bank_code" db:"BookCode"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
BankRefNo string `json:"bank_ref_no" db:"BankRefNo"`
TransBankDate string `json:"trans_bank_date" db:"TransBankDate"`
RefDate string `json:"ref_date" db:"RefDate"`
}
type ListInvArDepositUsed struct {
DepositNo string `json:"deposit_no" db:"DepositNo"`
Balance float64 `json:"balance" db:"Balance"`
Amount float64 `json:"amount" db:"Amount"`
NetAmount float64 `json:"net_amount" db:"NetAmount"`
LineNumber int `json:"line_number" db:"LineNumber"`
}
type ListInvChqIn struct {
ChqNumber string `json:"chq_number" db:"ChqNumber"`
BankCode string `json:"bank_code" db:"BankCode"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
BookNo string `json:"book_no" db:"BookNo"`
ReceiveDate string `json:"receive_date" db:"ReceiveDate"`
DueDate string `json:"due_date" db:"DueDate"`
Status int `json:"status" db:"Status"`
Amount float64 `json:"amount" db:"Amount"`
Balance float64 `json:"balance" db:"Balance"`
RefChqRowOrder int `json:"ref_chq_row_order" db:"RefChqRowOrder"`
StatusDate string `json:"status_date" db:"StatusDate"`
StatusDocNo string `json:"status_doc_no" db:"StatusDocNo"`
}
type ListInvCreditCard struct {
BankCode string `json:"bank_code" db:"BankCode"`
CreditCardNo string `json:"credit_card_no" db:"CreditCardNo"`
ReceiveDate string `json:"receive_date" db:"ReceiveDate"`
DueDate string `json:"due_date" db:"DueDate"`
BookNo string `json:"book_no" db:"BookNo"`
Status int `json:"status" db:"Status"`
StatusDate string `json:"status_date" db:"StatusDate"`
StatusDocNo string `json:"status_doc_no" db:"StatusDocNo"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
Amount float64 `json:"amount" db:"Amount"`
MyDescription string `json:"my_description" db:"MyDescription"`
CreditType string `json:"credit_type" db:"CreditType"`
ConfirmNo string `json:"confirm_no" db:"ConfirmNo"`
ChargeAmount float64 `json:"charge_amount" db:"ChargeAmount"`
}
API
1.1.InsertAndEditArInvoice
Type POST endpoint = http://localhost:8002/arinvoice
Request
{
"doc_no": "CDO-610401-0001",
"doc_date": "2018/04/02",
"ar_code": "45040",
"sale_code": "01",
"user_code": "moo",
"is_cancel":0,
"tax_type": 1,
"depart_code": "SALE",
"my_description": "Test",
"bill_type": 0,
"ref_doc_no": "S01-SHV6104-0001",
"sum_of_item_amount": 2500,
"discount_word": "",
"discount_amount": 0,
"after_discount": 2500,
"except_tax_amount": 0,
"sum_cash_amount": 300,
"sum_chq_amount": 800,
"sum_credit_amount": 500,
"sum_bank_amount": 700,
"sum_of_deposit_1": 200,
"is_condition_send": 0,
"so_ref_no": "600107-0008",
"shiftcode": "",
"cashier_code": "",
"shift_no": "",
"machine_no": "",
"machine_code": "",
"bill_time": "",
"credit_type": "MASTERCARD",
"confirm_no":"1133",
"credit_ref_no":"6721",
"bank_code":"BBL",
"bank_branch_code":"01",
"credit_ref_no":"5678",
"bank_ref_no":"533-0-03046-3",
"subs": [
{
"my_type": 4,
"item_code": "S20027",
"my_description": "",
"item_name": "พลาสติกโคน 9x10 มิล",
"wh_code": "01",
"shelf_code": "01",
"qty": 500,
"price": 7.75,
"discount_word": "",
"discount_amount": 0,
"amount": 3875,
"sum_of_cost": 2110,
"unit_code": "ตัว",
"so_ref_no": "SO600107-0008",
"ref_line_number": 0,
"bar_code": "",
"is_condition_send": 0,
"averagecost": 4.22,
"packing_rate_1": 3
},
{
"my_type": 4,
"item_code": "S20028",
"my_description": "",
"item_name": "พลาสติกโคน 9x10 มิล",
"wh_code": "01",
"shelf_code": "01",
"qty": 5,
"price": 7.00,
"discount_word": "",
"discount_amount": 0,
"amount": 35,
"sum_of_cost": 21,
"unit_code": "ตัว",
"so_ref_no": "SO600107-0008",
"ref_line_number": 0,
"bar_code": "8852437100080",
"is_condition_send": 0,
"averagecost": 4.22,
"packing_rate_1": 5
}
],
"deps":[
{
"deposit_no":"DEP-Test-0001",
"balance":100,
"amount":100,
"net_amount":100
},
{
"deposit_no":"DEP-Test-0002",
"balance":100,
"amount":100,
"net_amount":100
}
],
"chqs":[{
"chq_number":"55457",
"bank_code":"BBL",
"bank_branch_code":"01",
"amount":1000
}]
}
Response
{
"status": "success",
"data": {
"save_from": 1,
"source": 6,
"doc_no": "CDO-610401-0001",
"doc_date": "2018/04/02",
"tax_no": "CDO-610401-0001",
"tax_date": "2018/04/02",
"book_code": "03",
"ar_code": "45040",
"ar_name": "",
"sale_code": "01",
"sale_name": "",
"creator_code": "",
"create_date_time": "",
"last_editor_code": "moo",
"last_edit_date_t": "",
"tax_type": 1,
"depart_code": "SALE",
"credit_day": 0,
"delivery_day": 0,
"delivery_date": "2018/04/02",
"due_date": "2018/04/02",
"pay_bill_date": "2018/04/02",
"tax_rate": 7,
"is_confirm": 0,
"my_description": "Test",
"bill_type": 0,
"bill_group": "",
"ref_doc_no": "S01-SHV6104-0001",
"delivery_addr": "",
"contact_code": "",
"sum_of_item_amount": 2500,
"discount_word": "",
"discount_amount": 0,
"after_discount": 2500,
"before_tax_amount": 2149.53,
"tax_amount": 150.47,
"total_amount": 2300,
"zero_tax_amount": 0,
"except_tax_amount": 0,
"sum_cash_amount": 300,
"sum_chq_amount": 800,
"sum_credit_amount": 500,
"sum_bank_amount": 700,
"deposit_inc_tax": 1,
"sum_of_deposit_1": 200,
"sum_of_deposit_2": 186.92,
"sum_of_w_tax": 0,
"net_debt_amount": 2300,
"home_amount": 2300,
"other_income": 0,
"other_expense": 0,
"excess_amount_1": 0,
"excess_amount_2": 0,
"bill_balance": 0,
"currency_code": "",
"exchange_rate": 1,
"gl_format": "B01",
"is_cancel": 0,
"is_complete_save": 1,
"allocate_code": "",
"project_code": "",
"recur_name": "",
"confirm_code": "",
"confirm_date_time": "",
"cancel_code": "",
"cancel_date_time": "",
"is_condition_send": 0,
"pay_bill_amount": 0,
"so_ref_no": "600107-0008",
"holding_status": 0,
"pos_status": 0,
"credit_base_amount": 0,
"user_code": "moo",
"shiftcode": "",
"cashier_code": "",
"shift_no": "",
"machine_no": "",
"machine_code": "",
"bill_time": "",
"coupong_amount": 0,
"change_amount": 0,
"charge_amount": 0,
"grand_total": 0,
"credit_type": "MASTERCARD",
"cofirm_no": "1133",
"credit_no": "6721",
"credit_due_date": "2018/04/02",
"bank_code": "BBL",
"bank_branch_code": "01",
"bank_ref_no": "533-0-03046-3",
"trans_bank_date": "2018/04/02",
"ref_date": "",
"subs": [
{
"my_type": 4,
"item_code": "S20027",
"my_description": "",
"item_name": "พลาสติกโคน 9x10 มิล",
"wh_code": "01",
"shelf_code": "01",
"cn_qty": 500,
"qty": 500,
"price": 7.75,
"discount_word": "",
"discount_amount": 0,
"amount": 3875,
"net_amount": 3621.5,
"home_amount": 3621.5,
"sum_of_cost": 2110,
"balance_amount": 3875,
"unit_code": "ตัว",
"so_ref_no": "SO600107-0008",
"po_ref_no": "",
"line_number": 0,
"ref_line_number": 0,
"is_cancel": 0,
"bar_code": "",
"posstatus": 0,
"is_condition_send": 0,
"averagecost": 4.22,
"lot_number": "",
"stock_type": 0,
"packing_rate_1": 3,
"packing_rate_2": 1
},
{
"my_type": 4,
"item_code": "S20028",
"my_description": "",
"item_name": "พลาสติกโคน 9x10 มิล",
"wh_code": "01",
"shelf_code": "01",
"cn_qty": 5,
"qty": 5,
"price": 7,
"discount_word": "",
"discount_amount": 0,
"amount": 35,
"net_amount": 32.71,
"home_amount": 32.71,
"sum_of_cost": 21,
"balance_amount": 35,
"unit_code": "ตัว",
"so_ref_no": "SO600107-0008",
"po_ref_no": "",
"line_number": 1,
"ref_line_number": 0,
"is_cancel": 0,
"bar_code": "8852437100080",
"posstatus": 0,
"is_condition_send": 0,
"averagecost": 4.22,
"lot_number": "",
"stock_type": 0,
"packing_rate_1": 5,
"packing_rate_2": 1
}
],
"deps": [
{
"deposit_no": "DEP-Test-0001",
"balance": 100,
"amount": 100,
"net_amount": 100,
"line_number": 0
},
{
"deposit_no": "DEP-Test-0002",
"balance": 100,
"amount": 100,
"net_amount": 100,
"line_number": 1
}
],
"cdcs": null,
"chqs": [
{
"chq_number": "55457",
"bank_code": "BBL",
"bank_branch_code": "01",
"book_no": "",
"receive_date": "2018/04/02",
"due_date": "2018/04/02",
"status": 0,
"amount": 1000,
"balance": 0,
"ref_chq_row_order": 0,
"status_date": "",
"status_doc_no": ""
}
]
}
}
1.2.SearchArInvoiceByDocNo
Type GET endpoint = http://localhost:8002/arinvoice?docno=CDO-600107-0001
Reponse
{
"status": "success",
"data": {
"save_from": 0,
"source": 0,
"doc_no": "CDO-600107-0001",
"doc_date": "2017-01-07T00:00:00Z",
"tax_no": "",
"tax_date": "",
"book_code": "",
"ar_code": "AR-00692",
"ar_name": "บริษัท กิตติวิบูลย์ จำกัด (สำนักงานใหญ่)",
"sale_code": "01",
"sale_name": "ชนิดาพร เดชอุบ",
"creator_code": "kae",
"create_date_time": "2017-01-07T00:00:00Z",
"last_editor_code": "",
"last_edit_date_t": "",
"tax_type": 2,
"depart_code": "SALE",
"credit_day": 0,
"delivery_day": 0,
"delivery_date": "1900-01-01T00:00:00Z",
"due_date": "2017-01-07T00:00:00Z",
"pay_bill_date": "2017-01-07T00:00:00Z",
"tax_rate": 0,
"is_confirm": 0,
"my_description": "",
"bill_type": 0,
"bill_group": "",
"ref_doc_no": "",
"delivery_addr": "",
"contact_code": "",
"sum_of_item_amount": 3875,
"discount_word": "",
"discount_amount": 0,
"after_discount": 3875,
"before_tax_amount": 0,
"tax_amount": 0,
"total_amount": 3875,
"zero_tax_amount": 3875,
"except_tax_amount": 0,
"sum_cash_amount": 3875,
"sum_chq_amount": 0,
"sum_credit_amount": 0,
"sum_bank_amount": 0,
"deposit_inc_tax": 1,
"sum_of_deposit_1": 0,
"sum_of_deposit_2": 0,
"sum_of_w_tax": 0,
"net_debt_amount": 3875,
"home_amount": 3875,
"other_income": 0,
"other_expense": 0,
"excess_amount_1": 0,
"excess_amount_2": 0,
"bill_balance": 0,
"currency_code": "",
"exchange_rate": 1,
"gl_format": "B01",
"is_cancel": 0,
"is_complete_save": 1,
"allocate_code": "",
"project_code": "",
"recur_name": "",
"confirm_code": "",
"confirm_date_time": "",
"cancel_code": "",
"cancel_date_time": "",
"is_condition_send": 0,
"pay_bill_amount": 0,
"so_ref_no": "SO600107-0008",
"holding_status": 0,
"pos_status": 0,
"credit_base_amount": 0,
"user_code": "",
"shiftcode": "",
"cashier_code": "",
"shift_no": "",
"machine_no": "",
"machine_code": "",
"bill_time": "",
"coupong_amount": 0,
"change_amount": 0,
"charge_amount": 0,
"grand_total": 0,
"credit_type": "",
"cofirm_no": "",
"credit_no": "",
"credit_due_date": "1900-01-01T00:00:00Z",
"bank_code": "",
"bank_branch_code": "",
"bank_ref_no": "",
"trans_bank_date": "",
"ref_date": "",
"subs": [
{
"my_type": 4,
"item_code": "S20027",
"my_description": "",
"item_name": "พลาสติกโคน 9x10 มิล",
"wh_code": "01",
"shelf_code": "01",
"cn_qty": 500,
"qty": 500,
"price": 7.75,
"discount_word": "",
"discount_amount": 0,
"amount": 3875,
"net_amount": 3875,
"home_amount": 3875,
"sum_of_cost": 2110,
"balance_amount": 3875,
"unit_code": "ตัว",
"so_ref_no": "SO600107-0008",
"po_ref_no": "",
"line_number": 0,
"ref_line_number": 0,
"is_cancel": 0,
"bar_code": "",
"posstatus": 0,
"is_condition_send": 0,
"averagecost": 4.22,
"lot_number": "",
"stock_type": 0,
"packing_rate_1": 1,
"packing_rate_2": 1
}
],
"deps": null,
"cdcs": null,
"chqs": null
}
}
1.3.SearchArInvoiceByKeyword
Type GET endpoint = http://localhost:8002/arinvoices?keyword=CDO-601110-000
Reponse
{
"status": "success",
"data": [
{
"save_from": 0,
"source": 0,
"doc_no": "CDO-601110-0003",
"doc_date": "2017-11-10T00:00:00Z",
"tax_no": "CDO-601110-0001",
"tax_date": "",
"book_code": "",
"ar_code": "00",
"ar_name": "ลูกค้าเงินสด",
"sale_code": "02",
"sale_name": "นพดล กันทา",
"creator_code": "sale",
"create_date_time": "2017-11-10T09:43:05Z",
"last_editor_code": "",
"last_edit_date_t": "",
"tax_type": 2,
"depart_code": "SALE",
"credit_day": 0,
"delivery_day": 0,
"delivery_date": "1900-01-01T00:00:00Z",
"due_date": "2017-11-10T00:00:00Z",
"pay_bill_date": "2017-11-10T00:00:00Z",
"tax_rate": 0,
"is_confirm": 0,
"my_description": "",
"bill_type": 0,
"bill_group": "",
"ref_doc_no": "",
"delivery_addr": "",
"contact_code": "",
"sum_of_item_amount": 480,
"discount_word": "",
"discount_amount": 0,
"after_discount": 480,
"before_tax_amount": 0,
"tax_amount": 0,
"total_amount": 480,
"zero_tax_amount": 480,
"except_tax_amount": 0,
"sum_cash_amount": 480,
"sum_chq_amount": 0,
"sum_credit_amount": 0,
"sum_bank_amount": 0,
"deposit_inc_tax": 1,
"sum_of_deposit_1": 0,
"sum_of_deposit_2": 0,
"sum_of_w_tax": 0,
"net_debt_amount": 480,
"home_amount": 480,
"other_income": 0,
"other_expense": 0,
"excess_amount_1": 0,
"excess_amount_2": 0,
"bill_balance": 0,
"currency_code": "",
"exchange_rate": 1,
"gl_format": "B01",
"is_cancel": 0,
"is_complete_save": 1,
"allocate_code": "",
"project_code": "",
"recur_name": "",
"confirm_code": "",
"confirm_date_time": "",
"cancel_code": "",
"cancel_date_time": "",
"is_condition_send": 0,
"pay_bill_amount": 0,
"so_ref_no": "SO601110-0002",
"holding_status": 0,
"pos_status": 0,
"credit_base_amount": 0,
"user_code": "",
"shiftcode": "",
"cashier_code": "",
"shift_no": "",
"machine_no": "",
"machine_code": "",
"bill_time": "",
"coupong_amount": 0,
"change_amount": 0,
"charge_amount": 0,
"grand_total": 0,
"credit_type": "",
"cofirm_no": "",
"credit_no": "",
"credit_due_date": "1900-01-01T00:00:00Z",
"bank_code": "",
"bank_branch_code": "",
"bank_ref_no": "",
"trans_bank_date": "",
"ref_date": "",
"subs": [
{
"my_type": 4,
"item_code": "S20033",
"my_description": "",
"item_name": "อินเนอร์ 9x200 มิล",
"wh_code": "01",
"shelf_code": "01",
"cn_qty": 60,
"qty": 60,
"price": 8,
"discount_word": "",
"discount_amount": 0,
"amount": 480,
"net_amount": 480,
"home_amount": 480,
"sum_of_cost": 168.6,
"balance_amount": 480,
"unit_code": "ตัว",
"so_ref_no": "SO601110-0002",
"po_ref_no": "",
"line_number": 0,
"ref_line_number": 0,
"is_cancel": 0,
"bar_code": "",
"posstatus": 0,
"is_condition_send": 0,
"averagecost": 2.81,
"lot_number": "",
"stock_type": 0,
"packing_rate_1": 1,
"packing_rate_2": 1
}
],
"deps": null,
"cdcs": null,
"chqs": null
}
]
}
2.BCArDeposit รับเงินมัดจำ
Model
type ArDeposit struct {
RowOrder int `json:"row_order" db:"RowOrder"`
DocNo string `json:"doc_no" db:"DocNo"`
DocDate string `json:"doc_date" db:"DocDate"`
TaxType int `json:"tax_type" db:"TaxType"`
Source int `json:"source" db:"Source"`
SaveFrom int `json:"save_from" db:"SaveFrom"`
OutPutTax
Customer
SaleMan
DepartCode string `json:"depart_code" db:"DepartCode"`
CreditDay int `json:"credit_day" db:"CreditDay"`
DueDate string `json:"due_date" db:"DueDate"`
TaxRate float64 `json:"tax_rate" db:"TaxRate"`
IsConfirm int `json:"is_confirm" db:"IsConfirm"`
MyDescription string `json:"my_description" db:"MyDescription"`
BeforeTaxAmount float64 `json:"before_tax_amount" db:"BeforeTaxAmount"`
TaxAmount float64 `json:"tax_amount" db:"TaxAmount"`
TotalAmount float64 `json:"total_amount" db:"TotalAmount"`
SumOfWTax float64 `json:"sum_of_w_tax" db:"SumOfWTax"`
NetAmount float64 `json:"net_amount" db:"NetAmount"`
BillBalance float64 `json:"bill_balance" db:"BillBalance"`
OtherIncome float64 `json:"other_income" db:"OtherIncome"`
OtherExpense float64 `json:"other_expense" db:"OtherExpense"`
ExcessAmount1 float64 `json:"excess_amount_1" db:"ExcessAmount1"`
ExcessAmount2 float64 `json:"excess_amount_2" db:"ExcessAmount2"`
ChargeAmount float64 `json:"charge_amount" db:"ChargeAmount"`
ChangeAmount float64 `json:"change_amount" db:"ChangeAmount"`
RefNo string `json:"ref_no" db:"RefNo"`
CurrencyCode string `json:"currency_code" db:"CurrencyCode"`
ExchangeRate float64 `json:"exchange_rate" db:"ExchangeRate"`
SumCashAmount float64 `json:"sum_cash_amount" db:"SumCashAmount"`
SumChqAmount float64 `json:"sum_chq_amount" db:"SumChqAmount"`
SumCreditAmount float64 `json:"sum_credit_amount" db:"SumCreditAmount"`
SumBankAmount float64 `json:"sum_bank_amount" db:"SumBankAmount"`
GLFormat string `json:"gl_format" db:"GLFormat"`
GLStartPosting int `json:"gl_start_posting" db:"GLStartPosting"`
IsPostGL int `json:"is_post_gl" db:"IsPostGL"`
IsCancel int `json:"is_cancel" db:"IsCancel"`
IsReturnMoney int `json:"is_return_money" db:"IsReturnMoney"`
AllocateCode string `json:"allocate_code" db:"AllocateCode"`
ProjectCode string `json:"project_code" db:"ProjectCode"`
BillGroup string `json:"bill_group" db:"BillGroup"`
RecurName string `json:"recur_name" db:"RecurName"`
ConfirmCode string `json:"confirm_code" db:"ConfirmCode"`
ConfirmDateTime string `json:"confirm_date_time" db:"ConfirmDateTime"`
CancelCode string `json:"cancel_code" db:"CancelCode"`
CancelDateTime string `json:"cancel_date_time" db:"CancelCode"`
CreatorCode string `json:"creator_code" db:"CreatorCode"`
CreateDateTime string `json:"create_date_time" db:"CreateDateTime"`
LastEditorCode string `json:"last_editor_code" db:"LastEditorCode"`
LastEditDateT string `json:"last_edit_date_t" db:"LastEditDateT"`
UserCode string `json:"user_code" db:"UserCode"`
ListArDepRecMoney
Cdcs []*ListDepCreditCard `json:"cdcs"`
Chqs []*ListDepChqIn `json:"chqs"`
}
type Customer struct {
ArCode string `json:"ar_code" db:"ArCode"`
ArName string `json:"ar_name" db:"ArName"`
}
type OutPutTax struct {
TaxNo string `json:"tax_no" db:"TaxNo"`
TaxDate string `json:"tax_date" db:"TaxDate"`
BookCode string `json:"book_code" db:"BookCode"`
}
type SaleMan struct {
SaleCode string `json:"sale_code" db:"SaleCode"`
SaleName string `json:"sale_name" db:"SaleName"`
}
type ListArDepRecMoney struct {
CreditType string `json:"credit_type" db:"CreditType"`
ConfirmNo string `json:"confirm_no" db:"ConfirmNo"`
CreditRefNo string `json:"credit_ref_no" db:"CreditRefNo"`
BankCode string `json:"bank_code" db:"BookCode"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
BankRefNo string `json:"bank_ref_no" db:"BankRefNo"`
TransBankDate string `json:"trans_bank_date" db:"TransBankDate"`
RefDate string `json:"ref_date" db:"RefDate"`
}
type ListDepChqIn struct {
ChqNumber string `json:"chq_number" db:"ChqNumber"`
BankCode string `json:"bank_code" db:"BankCode"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
BookNo string `json:"book_no" db:"BookNo"`
ReceiveDate string `json:"receive_date" db:"ReceiveDate"`
DueDate string `json:"due_date" db:"DueDate"`
Status int `json:"status" db:"Status"`
Amount float64 `json:"amount" db:"Amount"`
Balance float64 `json:"balance" db:"Balance"`
RefChqRowOrder int `json:"ref_chq_row_order" db:"RefChqRowOrder"`
StatusDate string `json:"status_date" db:"StatusDate"`
StatusDocNo string `json:"status_doc_no" db:"StatusDocNo"`
}
type ListDepCreditCard struct {
BankCode string `json:"bank_code" db:"BankCode"`
CreditCardNo string `json:"credit_card_no" db:"CreditCardNo"`
ReceiveDate string `json:"receive_date" db:"ReceiveDate"`
DueDate string `json:"due_date" db:"DueDate"`
BookNo string `json:"book_no" db:"BookNo"`
Status int `json:"status" db:"Status"`
StatusDate string `json:"status_date" db:"StatusDate"`
StatusDocNo string `json:"status_doc_no" db:"StatusDocNo"`
BankBranchCode string `json:"bank_branch_code" db:"BankBranchCode"`
Amount float64 `json:"amount" db:"Amount"`
MyDescription string `json:"my_description" db:"MyDescription"`
CreditType string `json:"credit_type" db:"CreditType"`
ConfirmNo string `json:"confirm_no" db:"ConfirmNo"`
ChargeAmount float64 `json:"charge_amount" db:"ChargeAmount"`
}
API
2.1.InsertAndEditArDeposit
Type POST endpoint = http://localhost:8002/ardeposit
Request
{
"doc_no":"AIP-5911-00841",
"doc_date":"2018/04/06",
"credit_day":10,
"tax_type":0,
"tax_rate":0,
"ar_code":"อ-3129",
"sale_code":"56163",
"total_amount":12000,
"ref_no":"S01-ROV6104-0001",
"sum_cash_amount":0,
"sum_chq_amount":0,
"sum_credit_amount":0,
"sum_bank_amount":12000,
"user_code":"somrod",
"credit_type":"Master",
"confirm_no":"1124",
"credit_ref_no":"6769",
"bank_code":"BBL",
"bank_branch_code":"01",
"bank_ref_no":"123456789",
"credit_ref_no":"55555"
}
Reponse
{
"status": "success",
"data": {
"row_order": 0,
"doc_no": "AIP-5911-00841",
"doc_date": "2018/04/06",
"tax_type": 0,
"source": 7,
"save_from": 5,
"tax_no": "AIP-5911-00841",
"tax_date": "2018/04/06",
"book_code": "41",
"ar_code": "อ-3129",
"ar_name": "",
"sale_code": "56163",
"sale_name": "",
"depart_code": "",
"credit_day": 10,
"due_date": "2018-05-07",
"tax_rate": 7,
"is_confirm": 0,
"my_description": "",
"before_tax_amount": 11160,
"tax_amount": 840,
"total_amount": 12000,
"sum_of_w_tax": 0,
"net_amount": 12000,
"bill_balance": 12000,
"other_income": 0,
"other_expense": 0,
"excess_amount_1": 0,
"excess_amount_2": 0,
"charge_amount": 0,
"change_amount": 0,
"ref_no": "S01-ROV6104-0001",
"currency_code": "",
"exchange_rate": 1,
"sum_cash_amount": 0,
"sum_chq_amount": 0,
"sum_credit_amount": 0,
"sum_bank_amount": 12000,
"gl_format": "D01",
"gl_start_posting": 0,
"is_post_gl": 0,
"is_cancel": 0,
"is_return_money": 0,
"allocate_code": "",
"project_code": "",
"bill_group": "",
"recur_name": "",
"confirm_code": "",
"confirm_date_time": "",
"cancel_code": "",
"cancel_date_time": "",
"creator_code": "somrod",
"create_date_time": "",
"last_editor_code": "",
"last_edit_date_t": "",
"user_code": "somrod",
"credit_type": "Master",
"confirm_no": "1124",
"credit_ref_no": "55555",
"bank_code": "BBL",
"bank_branch_code": "01",
"bank_ref_no": "123456789",
"trans_bank_date": "2018/04/06",
"ref_date": "",
"cdcs": null,
"chqs": null
}
}
2.2.SearchArDepositByDocNo
Type GET endpoint = http://localhost:8002/ardeposit?docno=DR6004-0003
Response
{
"status": "success",
"data": {
"row_order": 55,
"doc_no": "DR6004-0003",
"doc_date": "2017-04-29T00:00:00Z",
"tax_type": 1,
"source": 0,
"save_from": 0,
"tax_no": "DR6004-0003",
"tax_date": "2017-04-29T00:00:00Z",
"book_code": "",
"ar_code": "AR-03799",
"ar_name": "บริษัท เอ็กเซคคิวทีฟ เรสซิเดนซ์ ดีเวลลอปเม้นท์ จำกัด (สำนักงานใหญ่)",
"sale_code": "03",
"sale_name": "สุจิตรา จันทร์พงษ์",
"depart_code": "",
"credit_day": 0,
"due_date": "2017-05-02T00:00:00Z",
"tax_rate": 7,
"is_confirm": 0,
"my_description": "",
"before_tax_amount": 88650.47,
"tax_amount": 6205.53,
"total_amount": 94856,
"sum_of_w_tax": 0,
"net_amount": 94856,
"bill_balance": 94856,
"other_income": 0,
"other_expense": 0,
"excess_amount_1": 0,
"excess_amount_2": 0,
"charge_amount": 0,
"change_amount": 0,
"ref_no": "",
"currency_code": "",
"exchange_rate": 1,
"sum_cash_amount": 0,
"sum_chq_amount": 0,
"sum_credit_amount": 0,
"sum_bank_amount": 94856,
"gl_format": "D01",
"gl_start_posting": 0,
"is_post_gl": 0,
"is_cancel": 0,
"is_return_money": 0,
"allocate_code": "",
"project_code": "",
"bill_group": "",
"recur_name": "",
"confirm_code": "",
"confirm_date_time": "",
"cancel_code": "",
"cancel_date_time": "",
"creator_code": "tawon",
"create_date_time": "2017-05-02T08:51:50Z",
"last_editor_code": "",
"last_edit_date_t": "",
"user_code": "",
"credit_type": "",
"confirm_no": "",
"credit_ref_no": "",
"bank_code": "03",
"bank_branch_code": "",
"bank_ref_no": "",
"trans_bank_date": "",
"ref_date": "",
"cdcs": null,
"chqs": null
}
}