from .. import controller from odoo import http from odoo.http import request import json class SaleOrder(controller.Controller): prefix = '/api/v1/' PREFIX_PARTNER = prefix + 'partner//' @http.route(prefix + "sale_order_number", auth='public', method=['GET', 'OPTIONS']) @controller.Controller.must_authorized() def get_number_sale_order(self, **kw): # for midtrans only sale_order_id = int(kw.get('sale_order_id', '0')) sale_number = str(kw.get('sale_number', '')) if sale_order_id > 0: query = [('id', '=', sale_order_id)] # sales = request.env['sale.order'].search_read([('id', '=', sale_order_id)], fields=['id', 'name', 'amount_total', 'state']) sales = request.env['sale.order'].search(query, limit=1) else: query = [('name', '=', sale_number)] # sales = request.env['sale.order'].search_read([('name', '=', sale_number)], fields=['id', 'name', 'amount_total', 'state']) sales = request.env['sale.order'].search(query, limit=1) data = [] for sale in sales: product_name = '' product_not_in_id = 0 for line in sale.order_line: product_name = line.product_id.name product_not_in_id = line.product_id.id break data.append({ 'id': sale.id, 'name': sale.name, 'date_order': self.time_to_str(sale.date_order, '%d/%m/%Y %H:%M:%S'), 'state': sale.state, 'amount_untaxed': sale.amount_untaxed, 'amount_tax': sale.amount_tax, 'amount_total': sale.amount_total, 'product_name': product_name, 'product_not_in_id': product_not_in_id, 'details': [request.env['sale.order.line'].api_single_response(x, context='with_detail') for x in sale.order_line] }) return self.response(data) @http.route(PREFIX_PARTNER + 'sale_order', auth='public', method=['GET', 'OPTIONS']) @controller.Controller.must_authorized(private=True, private_key='partner_id') def get_partner_sale_order(self, **kw): params = self.get_request_params(kw, { 'partner_id': ['number'], 'name': [], 'limit': ['default:0', 'number'], 'offset': ['default:0', 'number'], 'context': [] }) limit = params['value']['limit'] offset = params['value']['offset'] if not params['valid']: return self.response(code=400, description=params) partner_child_ids = self.get_partner_child_ids( params['value']['partner_id']) domain = [('partner_id', 'in', partner_child_ids)] context = params['value']['context'] if context == 'quotation': domain += ["|", "|", ("state", "=", "draft"), ("state", "=", "sent"), ("state", "=", "cancel")] if not context: domain += ["|", ("state", "=", "sale"), ("state", "=", "done")] if params['value']['name']: name = params['value']['name'].replace(' ', '%') domain += [ '|', ('name', 'ilike', '%' + name + '%'), ('partner_purchase_order_name', 'ilike', '%' + name + '%') ] sale_orders = request.env['sale.order'].search( domain, offset=offset, limit=limit) data = { 'sale_order_total': request.env['sale.order'].search_count(domain), 'sale_orders': [request.env['sale.order'].api_v1_single_response(x) for x in sale_orders] } return self.response(data) @http.route(PREFIX_PARTNER + 'sale_order/', auth='public', method=['GET', 'OPTIONS']) @controller.Controller.must_authorized(private=True, private_key='partner_id') def partner_get_sale_order_detail(self, **kw): params = self.get_request_params(kw, { 'partner_id': ['number'], 'id': ['number'] }) if not params['valid']: return self.response(code=400, description=params) partner_child_ids = self.get_partner_child_ids( params['value']['partner_id']) domain = [ ('id', '=', params['value']['id']), ('partner_id', 'in', partner_child_ids) ] data = {} sale_order = request.env['sale.order'].search(domain) if sale_order: data = request.env['sale.order'].api_v1_single_response( sale_order, context='with_detail') return self.response(data) @http.route(PREFIX_PARTNER + 'sale_order//checkout', auth='public', method=['POST', 'OPTIONS'], csrf=False) @controller.Controller.must_authorized(private=True, private_key='partner_id') def partner_checkout_sale_order_by_id(self, **kw): params = self.get_request_params(kw, { 'partner_id': ['number'], 'id': ['number'] }) if not params['valid']: return self.response(code=400, description=params) partner_child_ids = self.get_partner_child_ids( params['value']['partner_id']) domain = [ ('id', '=', params['value']['id']), ('partner_id', 'in', partner_child_ids) ] data = {} sale_order = request.env['sale.order'].search(domain) if sale_order: sale_order.approval_status = 'pengajuan1' data = request.env['sale.order'].api_v1_single_response( sale_order, context='with_detail') return self.response(data) @http.route(PREFIX_PARTNER + 'sale_order//upload_po', auth='public', method=['POST', 'OPTIONS'], csrf=False) def partner_upload_po_sale_order(self, **kw): user_token = self.authenticate() if not user_token: return self.unauthorized_response() params = self.get_request_params(kw, { 'partner_id': ['number'], 'id': ['number'], 'name': [], 'file': [] }) if not user_token['partner_id'] == params['value']['partner_id']: return self.unauthorized_response() if not params['valid']: return self.response(code=400, description=params) partner_child_ids = self.get_partner_child_ids( params['value']['partner_id']) domain = [ ('id', '=', params['value']['id']), ('partner_id', 'in', partner_child_ids) ] data = False sale_order = request.env['sale.order'].search(domain) if sale_order: sale_order.partner_purchase_order_name = params['value']['name'] sale_order.client_order_ref = params['value']['name'] sale_order.partner_purchase_order_file = params['value']['file'] data = sale_order.id return self.response(data) @http.route(PREFIX_PARTNER + 'sale_order//download_po/', auth='none', method=['GET']) def partner_download_po_sale_order(self, id, token): id = int(id) rest_api = request.env['rest.api'] md5_valid = rest_api.md5_salt_valid(id, 'sale.order', token) if not md5_valid: return self.response('Unauthorized') sale_order = request.env['sale.order'].sudo().search_read( [('id', '=', id)], ['partner_purchase_order_name']) attachment = rest_api.get_single_attachment( 'sale.order', 'partner_purchase_order_file', id) if attachment and len(sale_order) > 0: return rest_api.response_attachment({ 'content': attachment['datas'], 'decode_content': True, 'mimetype': attachment['mimetype'], 'filename': sale_order[0]['partner_purchase_order_name'] }) return self.response('Dokumen tidak ditemukan', code=404) @http.route(PREFIX_PARTNER + 'sale_order//download/', auth='none', method=['GET']) def partner_download_sale_order(self, id, token): id = int(id) rest_api = request.env['rest.api'] md5_valid = rest_api.md5_salt_valid(id, 'sale.order', token) if not md5_valid: return self.response('Unauthorized') sale_order = request.env['sale.order'].sudo( ).search_read([('id', '=', id)], ['name']) pdf, type = request.env['ir.actions.report'].sudo().search( [('report_name', '=', 'indoteknik_custom.report_saleorder_website')])._render_qweb_pdf([id]) if pdf and len(sale_order) > 0: return rest_api.response_attachment({ 'content': pdf, 'mimetype': 'application/pdf', 'filename': sale_order[0]['name'] }) return self.response('Dokumen tidak ditemukan', code=404) @http.route(PREFIX_PARTNER + 'sale_order//cancel', auth='public', method=['POST', 'OPTIONS'], csrf=False) @controller.Controller.must_authorized(private=True, private_key='partner_id') def partner_cancel_sale_order(self, **kw): params = self.get_request_params(kw, { 'partner_id': ['number'], 'id': ['number'] }) if not params['valid']: return self.response(code=400, description=params) partner_child_ids = self.get_partner_child_ids( params['value']['partner_id']) domain = [ ('id', '=', params['value']['id']), ('partner_id', 'in', partner_child_ids) ] data = False sale_order = request.env['sale.order'].search(domain) if sale_order: sale_order.state = 'cancel' data = sale_order.id return self.response(data) @http.route(prefix + 'user//sale_order/checkout', auth='public', method=['GET', 'OPTIONS'], csrf=False) @controller.Controller.must_authorized(private=True, private_key='user_id') def get_user_checkout_so(self, user_id, **kw): cart = request.env['website.user.cart'] voucher_code = kw.get('voucher') voucher = request.env['voucher'].search([('code', '=', voucher_code)], limit=1) result = cart.get_user_checkout(user_id, voucher) return self.response(result) @http.route(PREFIX_PARTNER + 'sale_order/checkout', auth='public', method=['POST', 'OPTIONS'], csrf=False) @controller.Controller.must_authorized(private=True, private_key='partner_id') def create_partner_sale_order(self, **kw): config = request.env['ir.config_parameter'] product_pricelist_default_discount_id = int(config.get_param('product.pricelist.default_discount_id')) params = self.get_request_params(kw, { 'user_id': ['number'], 'partner_id': ['number'], 'partner_shipping_id': ['required', 'number'], 'partner_invoice_id': ['required', 'number'], 'order_line': ['required', 'default:[]'], 'po_number': [], 'po_file': [], 'type': [], 'delivery_amount': ['number', 'default:0'], 'carrier_id': [], 'delivery_service_type': [], 'voucher': [] }) if not params['valid']: return self.response(code=400, description=params) parameters = { 'warehouse_id': 8, 'carrier_id': 1, 'sales_tax_id': 20, 'pricelist_id': product_pricelist_default_discount_id, 'payment_term_id': 26, 'team_id': 2, 'company_id': 1, 'currency_id': 12, 'state': 'draft', 'picking_policy': 'direct', 'partner_id': params['value']['partner_id'], 'partner_shipping_id': params['value']['partner_shipping_id'], 'real_shipping_id': params['value']['partner_shipping_id'], 'partner_invoice_id': params['value']['partner_invoice_id'], 'partner_purchase_order_name': params['value']['po_number'], 'partner_purchase_order_file': params['value']['po_file'], 'delivery_amt': params['value']['delivery_amount'], 'shipping_cost_covered': 'customer', 'shipping_paid_by': 'customer', 'carrier_id': params['value']['carrier_id'], 'delivery_service_type': params['value']['delivery_service_type'], 'customer_type': 'nonpkp', 'npwp': '0' } if params['value']['type'] == 'sale_order': parameters['approval_status'] = 'pengajuan1' sale_order = request.env['sale.order'].create([parameters]) parameters = [] user_id = params['value']['user_id'] user_cart = request.env['website.user.cart'] products = user_cart.get_product_by_user(user_id=user_id, selected=True) for product in products: total_qty = product['quantity'] price_unit = product['price']['price'] price_discount =product['price']['discount_percentage'] if product['program'] and product['program']['type']['value'] != 'special_price': total_qty += sum(x['quantity'] for x in product['program']['items']) price_unit = product['subtotal'] / total_qty price_discount = 0 param = { 'company_id': 1, 'order_id': sale_order.id, 'price_unit': price_unit, 'discount': price_discount } primary_product = { **param, 'product_id': product['id'], 'product_uom_qty': product['quantity'] } if product['program']: primary_product.update({ 'program_line_id': product['program']['id'] }) parameters.append(primary_product) if not product['program']: continue for item in product['program']['items']: parameters.append({ **param, 'product_id': item['id'], 'product_uom_qty': item['quantity'], }) request.env['sale.order.line'].create(parameters) voucher_code = params['value']['voucher'] voucher = request.env['voucher'].search([('code', '=', voucher_code)]) if voucher: amount_untaxed = 0 manufacture_ids = [x.id for x in voucher.manufacture_ids] for line in sale_order.order_line: manufacture_id = line.product_id.x_manufacture.id or False if len(manufacture_ids) == 0 or manufacture_id in manufacture_ids: amount_untaxed += line.price_subtotal voucher_discount = voucher.calculate_discount(amount_untaxed) sale_order.voucher_id = voucher.id sale_order.amount_voucher_disc = voucher_discount for line in sale_order.order_line: manufacture_id = line.product_id.x_manufacture.id or False if len(manufacture_ids) > 0 and manufacture_id not in manufacture_ids: continue voucher_discount_line = line.price_subtotal / amount_untaxed * voucher_discount line.amount_voucher_disc = voucher_discount_line discount_decimal = line.discount / 100 voucher_discount_item = voucher_discount_line / line.product_uom_qty voucher_disc_before_line_disc = voucher_discount_item / (1 - discount_decimal) line.price_unit -= voucher_disc_before_line_disc cart_ids = [x['cart_id'] for x in products] user_cart.browse(cart_ids).unlink() return self.response({ 'id': sale_order.id, 'name': sale_order.name }) @http.route('/api/sale_order/invoiced', auth='public', methods=['GET']) def get_sale_order_invoiced_by_partner_id(self, **kw): if not self.authenticate(): return self.unauthorized_response() partner_id = kw.get('partner_id') if not partner_id: return self.response(code=400, description='Field partner_id is required') partner_id = int(partner_id) # Get company member by partner_id parent_partner_id = request.env['res.partner'].search( [('id', '=', partner_id)], limit=1).parent_id.id partner_childs = request.env['res.partner'].search( [('parent_id', '=', int(parent_partner_id))]) partner_child_ids = [v['id'] for v in partner_childs] + [partner_id] # Get sale order by company member and invoiced data = [] default_domain = [ ('partner_id', 'in', partner_child_ids), ('state', 'in', ['sale', 'done']) ] sale_orders = self.search_filter('sale.order', kw, default_domain) for sale_order in sale_orders: pickings = [] for picking in sale_order.picking_ids: if picking.state in ['confirmed', 'assigned', 'done']: pickings.append({ 'id': picking.id, 'name': picking.name, 'delivery_address': picking.partner_id.street, 'delivery_tracking_no': picking.delivery_tracking_no, 'delivery_status': picking.delivery_status }) data.append({ 'id': sale_order.id, 'name': sale_order.name, 'amount_total': sale_order.amount_total, 'salesperson': sale_order.user_id.name, 'date_order': self.time_to_str(sale_order.date_order, '%d/%m/%Y'), 'pickings': pickings, 'access_token': sale_order.access_token }) return self.response(data) @http.route('/api/sale_order/invoiced/detail', auth='public', methods=['GET']) def get_sale_order_invoiced_detail_by_partner(self, **kw): if not self.authenticate(): return self.unauthorized_response() id = kw.get('id') partner_id = kw.get('partner_id') if not id: return self.response(code=400, description='Field id is required') if not partner_id: return self.response(code=400, description='Field partner_id is required') default_domain = [ ('id', '=', id), ('state', 'in', ['sale', 'done']) ] parent_partner_id = request.env['res.partner'].search( [('id', '=', int(partner_id))], limit=1).parent_id.id partner_childs = request.env['res.partner'].search( [('parent_id', '=', int(parent_partner_id))]) partner_child_ids = [v['id'] for v in partner_childs] + [int(partner_id)] default_domain.append(('partner_id', 'in', partner_child_ids)) sale_order = self.search_filter('sale.order', kw, default_domain) orders = [] for order in sale_order.order_line: orders.append({ 'name': order.name, 'product_qty': order.product_qty, 'price_unit': order.price_unit, 'price_tax': order.price_tax, 'price_total': order.price_total, 'price_subtotal': order.price_subtotal, 'tax': order.tax_id.name, 'discount': order.discount, }) data = { 'id': sale_order.id, 'name': sale_order.name, 'carrier': sale_order.carrier_id.name, 'partner': { 'id': sale_order.partner_id.id, 'name': sale_order.partner_id.name, 'mobile': sale_order.partner_id.mobile, 'email': sale_order.partner_id.email }, 'delivery_address': sale_order.partner_shipping_id.street, 'delivery_method': sale_order.carrier_id.name, 'payment_term': sale_order.payment_term_id.name, 'salesperson': sale_order.user_id.name, 'date_order': self.time_to_str(sale_order.date_order, '%d/%m/%Y %H:%M:%S'), 'note': sale_order.note, 'amount_untaxed': sale_order.amount_untaxed, 'amount_tax': sale_order.amount_tax, 'amount_total': sale_order.amount_total, 'orders': orders } return self.response(data)