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.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_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')) product_pricelist_tier1 = int(config.get_param('product.pricelist.tier1')) product_pricelist_tier2 = int(config.get_param('product.pricelist.tier2')) product_pricelist_tier3 = int(config.get_param('product.pricelist.tier3')) params = self.get_request_params(kw, { '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': [] }) 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'], } if params['value']['type'] == 'sale_order': parameters['approval_status'] = 'pengajuan1' sale_order = request.env['sale.order'].create([parameters]) order_line = json.loads(params['value']['order_line']) parameters = [] partner = request.env['res.partner'].browse(params['value']['partner_id']) partner_pricelist = partner.property_product_pricelist for line in order_line: product = request.env['product.product'].search([('id', '=', line['product_id'])], limit=1) discount = product._get_website_disc(0) price_tier = False pricelist = { 'tier1': product._get_pricelist_tier1, 'tier2': product._get_pricelist_tier2, 'tier3': product._get_pricelist_tier3, } partner_pricelist_id = partner_pricelist.id if partner_pricelist else False if partner_pricelist_id == product_pricelist_tier1: price_tier = 'tier1' if partner_pricelist_id == product_pricelist_tier2: price_tier = 'tier2' if partner_pricelist_id == product_pricelist_tier3: price_tier = 'tier3' if price_tier: price = pricelist[price_tier]() discount_key = 'discount_%s' % price_tier if price[discount_key] > 0: discount = price[discount_key] flashsale = product._get_flashsale_price() flashsale_discount = flashsale['flashsale_discount'] if flashsale_discount > 0 and flashsale_discount > discount: discount = flashsale_discount parameters.append({ 'company_id': 1, 'order_id': sale_order.id, 'product_id': line['product_id'], 'product_uom_qty': line['quantity'], 'price_unit': product._get_website_price_exclude_tax(), 'discount': discount }) request.env['sale.order.line'].create(parameters) 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)