public ReminderService(OcerraClient ocerraClient, OdataProxy odata, EmailSender emailSender)
{
this.ocerraClient = ocerraClient;
this.odata = odata;
this.emailSender = emailSender;
}
public NotifyController(OdataProxy odata, ReminderService reminderService)
{
Get("/Reminders", args => {
int page = int.Parse((string)Request.Query.page ?? "1");
page = page < 1 ? 1 : page;
string search = Request.Query.search;
string exportState = Request.Query.exportState;
string state = Request.Query.state;
string poState = Request.Query.poState;
string poMatches = Request.Query.poMatches;
string reminded = Request.Query.reminded;
var query = odata.VoucherHeader
.Expand("vendor,workflow($expand=workflowState),voucherValidation,purchaseOrderHeader");
//Find all un-approved voucher headers, where PO is not approved (approved date is null)
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)
query.Where(vh => vh.IsActive && !vh.IsArchived && vh.PurchaseOrderHeaderId != null);
if (IsDefined(search))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Number.Contains(search) || vh.Vendor.Name.Contains(search));
}
if (exportState == "Yes")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.ExternalId != null);
}
if (exportState == "No")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.ExternalId == null);
}
if (poMatches == "Yes")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.VoucherValidation.HasPoMatches == "Success");
}
if (poMatches == "No")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.VoucherValidation.HasPoMatches == "Fail" || vh.VoucherValidation.HasPoMatches == "Missing");
}
if (IsDefined(state))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Workflow.WorkflowState.Name == state);
}
if (IsDefined(poState))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.PurchaseOrderHeader.Status == poState);
}
if (IsDefined(reminded))
{
if (reminded == "Yes")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Extra5 == "Yes");
}
else
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Extra5 == null);
}
}
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.OrderByDescending(vh => vh.CreatedDate).Skip((page - 1) * 20).Take(20);
Model.Reminders = query
.Execute()
.Select(vh => new Reminder
{
VoucherId = vh.VoucherHeaderId.ToString(),
DocumentId = vh.DocumentId.ToString(),
Vendor = vh.Vendor != null ? vh.Vendor.Name : "Unknown",
Number = vh.Number,
Date = (vh.Date ?? vh.CreatedDate).ToString("dd-MMM-yy"),
State = vh.Workflow.WorkflowState.Name,
PONumber = vh.PurchaseOrderHeader?.Number ?? "Unknown",
POOriginator = vh.PurchaseOrderHeader?.PurchaserName,
POOriginatorEmail = vh.PurchaseOrderHeader?.PurchaserEmail,
POStatus = vh.PurchaseOrderHeader?.Status,
ExternalId = vh.PurchaseOrderHeader.ExternalId,
CanNotify = vh.PurchaseOrderHeader != null ? "" : "disabled='disabled'",
CanNotifyMessage =
vh.PurchaseOrderHeader == null ? "You cannot notify without the Purchase Order" :
null,
Total = vh.FcGross?.ToString("C") ?? "$0.00",
Reminded = vh.Extra5 ?? ""
}).ToList();
var totalCount = query.Count();
Model.Page = page;
Model.Count = totalCount;
Model.SearchStr = !string.IsNullOrEmpty(search) ? search.Replace("\"", "\\\"") : null;
Model.ExportStates = PickerModel.YesNo;
if (IsDefined(exportState))
{
Model.ExportStates.Find(s => s.Value == exportState).Selected = "selected";
}
Model.Reminded = PickerModel.YesNo;
if (IsDefined(reminded))
{
Model.Reminded.Find(s => s.Value == reminded).Selected = "selected";
}
Model.PoMatches = PickerModel.YesNo;
if (IsDefined(poMatches))
{
Model.PoMatches.Find(s => s.Value == poMatches).Selected = "selected";
}
Model.States = PickerModel.States;
if (IsDefined(state))
{
Model.States.Find(s => s.Value == state).Selected = "selected";
}
Model.PoStates = PickerModel.PoStates;
if (IsDefined(poState))
{
Model.PoStates.Find(s => s.Value == poState).Selected = "selected";
}
return(View["Reminders.html", Model]);
});
Post("/NotifyPurchasersByIds", async args => {
var voucherHeaderIdsStr = (string)Request.Form["voucherHeaderIds[]"];
if (!string.IsNullOrEmpty(voucherHeaderIdsStr))
{
var voucherHeaderIds = voucherHeaderIdsStr.Split(',').Select(s => Guid.Parse(s)).ToArray();
var result = await reminderService.RemindPurchasersByIds(voucherHeaderIds);
return(Response.AsJson(new { message = $"The notification was submitted: " + result + " times." }));
}
else
{
return(Response.AsJson(new { message = "You have not selected any invoices for remind." }));
}
});
this.reminderService = reminderService;
}
public ListController(OdataProxy odata, ExportService exportService)
{
Get("/Invoices", args => {
int page = int.Parse((string)Request.Query.page ?? "1");
page = page < 1 ? 1 : page;
string search = Request.Query.search;
string exportState = Request.Query.exportState;
string state = Request.Query.state;
string odooState = Request.Query.odooState;
string poState = Request.Query.poState;
string poMatches = Request.Query.poMatches;
var workflowStates = odata.WorkflowState.ToList();
var query = odata.VoucherHeader
.Expand("vendor,workflow($expand=workflowState),voucherValidation,purchaseOrderHeader");
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.IsActive && !vh.IsArchived);
if (!string.IsNullOrEmpty(search))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Number.Contains(search) || vh.Vendor.Name.Contains(search));
}
if (exportState == "Yes")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.ExternalId != null);
}
if (exportState == "No")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.ExternalId == null);
}
if (poMatches == "Yes")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.VoucherValidation.HasPoMatches == "Success");
}
if (poMatches == "No")
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.VoucherValidation.HasPoMatches == "Fail" || vh.VoucherValidation.HasPoMatches == "Missing");
}
if (IsDefined(state))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Workflow.WorkflowState.Name == state);
}
if (IsDefined(odooState))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.Extra2 == odooState);
}
if (IsDefined(poState))
{
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.Where(vh => vh.PurchaseOrderHeader.Status == poState);
}
query = (DataServiceQuery <ODataClient.Proxies.VoucherHeader>)query.OrderByDescending(vh => vh.CreatedDate).Skip((page - 1) * 20).Take(20);
Model.Invoices = query
.Execute()
.Select(vh => new InvoiceModel
{
Id = vh.VoucherHeaderId.ToString(),
DocumentId = vh.DocumentId.ToString(),
Vendor = vh.Vendor != null ? vh.Vendor.Name : "Unknown",
Status = vh.Workflow?.WorkflowState?.Name ?? "",
Number = vh.Number,
Date = (vh.Date ?? vh.CreatedDate).ToString("dd-MMM-yy"),
DueDate = vh.DueDate != null ? vh.DueDate.Value.ToString("dd-MMM-yy") : "",
Amount = vh.FcGross != null ? vh.FcGross.Value.ToString("C") : "$0.00",
Exported = vh.ExternalId != null ? "Yes" : "",
CanExport =
vh.PurchaseOrderHeader?.Number != null && vh.PurchaseOrderHeader.Number.Contains("JSPO") && vh.Extra1 == null ? "disabled='disabled'" :
vh.Vendor != null && vh.FcGross != null && vh.FcNet != null && vh.VoucherValidation.HasTotalMatches != "Fail" ? "" :
"disabled='disabled'",
CanExportMessage =
vh.PurchaseOrderHeader?.Number != null && vh.PurchaseOrderHeader.Number.Contains("JSPO") && vh.Extra1 == null ? "You cannot export Job Invoice without Draft invoice in Odoo." :
vh.Vendor == null ? "You cannot export Invoice without vendor" :
vh.FcGross == null ? "You cannot export Invoice without amount" :
vh.VoucherValidation.HasTotalMatches == "Fail" ? "You cannot export Invoice without matching amounts" :
null,
PoNumber = vh.PurchaseOrderHeader?.Number,
PoMatches =
vh.VoucherValidation.HasPoMatches == "Ignore" ? "" :
vh.VoucherValidation.HasPoMatches == "Success" ? "Yes"
: "<b class='red'>No</b>",
TotalMatches =
vh.VoucherValidation.HasTotalMatches == "Ignore" ? "" :
vh.VoucherValidation.HasTotalMatches == "Success" ? "Yes"
: "<b class='red'>No</b>",
Paid = vh.IsPaid ? "Yes" : "",
OdooLink = vh.Extra1 != null ? $"<a href='https://{Settings.Default.OdooUrl}/web#id={vh.Extra1}&view_type=form&model=account.invoice&action=242' target='_blank'>{vh.Extra2}</a>" : ""
//PurchaseOrder = vh.VoucherPurchaseOrders.FirstOrDefault()?.PurchaseOrderHeader?.Number
}).ToList();
var totalCount = query.Count();
Model.Page = page;
Model.Count = totalCount;
Model.SearchStr = !string.IsNullOrEmpty(search) ? search.Replace("\"", "\\\"") : null;
Model.ExportStates = PickerModel.YesNo;
if (IsDefined(exportState))
{
Model.ExportStates.Find(s => s.Value == exportState).Selected = "selected";
}
Model.PoMatches = PickerModel.YesNo;
if (IsDefined(poMatches))
{
Model.PoMatches.Find(s => s.Value == poMatches).Selected = "selected";
}
Model.States = PickerModel.States;
if (IsDefined(state))
{
Model.States.Find(s => s.Value == state).Selected = "selected";
}
Model.PoStates = PickerModel.PoStates;
if (IsDefined(poState))
{
Model.PoStates.Find(s => s.Value == poState).Selected = "selected";
}
Model.OdooStates = PickerModel.OdooStates;
if (IsDefined(odooState))
{
Model.OdooStates.Find(s => s.Value == odooState).Selected = "selected";
}
return(View["List.html", Model]);
});
Post("/ExportInvoicesByIds", async args => {
var voucherHeaderIdsStr = (string)Request.Form["voucherHeaderIds[]"];
if (!string.IsNullOrEmpty(voucherHeaderIdsStr))
{
var voucherHeaderIds = voucherHeaderIdsStr.Split(',').Select(s => Guid.Parse(s)).ToArray();
var result = await exportService.ExportInvoicesByIds(voucherHeaderIds);
return(Response.AsJson(new { message = $"Export complete: " + result.Message }));
}
else
{
return(Response.AsJson(new { message = "You have not selected any invoices for export." }));
}
});
}
