public function findVendor($vendorPublicId) { $vendorId = Vendor::getPrivateId($vendorPublicId); $accountid = \Auth::user()->account_id; $query = DB::table('expenses')->join('accounts', 'accounts.id', '=', 'expenses.account_id')->where('expenses.account_id', '=', $accountid)->where('expenses.vendor_id', '=', $vendorId)->select('expenses.id', 'expenses.expense_date', 'expenses.amount', 'expenses.public_notes', 'expenses.public_id', 'expenses.deleted_at', 'expenses.should_be_invoiced', 'expenses.created_at'); return $query; }
public function save($data) { if (isset($data['client_id']) && $data['client_id']) { $data['client_id'] = Client::getPrivateId($data['client_id']); } if (isset($data['vendor_id']) && $data['vendor_id']) { $data['vendor_id'] = Vendor::getPrivateId($data['vendor_id']); } return $this->expenseRepo->save($data); }
public function findVendor($vendorPublicId) { $vendorId = Vendor::getPrivateId($vendorPublicId); $query = $this->find()->where('expenses.vendor_id', '=', $vendorId); return $query; }