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;
}
