GetMonitoringOrderPembelianDetailInvoiceList

<?php

namespace Sts\WebToko\BO;

use Sts\PleafCore\BusinessFunction;
use Sts\WebToko\Model\FiInvoiceAp;
use Sts\WebToko\Model\FiInvoiceApBalance;
use DB;
/**
 * @in
 * @In(["poId","numeric","true","ID PO"])
 */
class GetMonitoringOrderPembelianDetailInvoiceList implements BusinessFunction {

    public function getDescription(){
        return "Get Monitoring Order Pembelian Detail Invoice List";
    }

    public function execute($dto){

        $poId = $dto["poId"];

        $result = DB::table(with(new FiInvoiceAp)->getTable()." as A")
                ->join(with(new FiInvoiceApBalance)->getTable()." as B", "B.invoice_ap_id", "A.invoice_ap_id")
                ->select([
                    "A.doc_no", "A.doc_date", "A.status_doc", "A.due_date",
                   "B.invoice_amount"
                ])
                ->where("A.ref_id", $poId)
                ->get();

        return $result;
    }
}